Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.5088272094727E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017831325531006 / seconds
host not found setting manual db connection
loadtime:0.0095829963684082 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0098280906677246 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010028123855591 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010094165802002 / seconds
zipcode:
loadtime:0.01012110710144 / seconds
Query Executed:select * from search_referrer where page_hash='8c1ab94f9f6f6b09aa54db4642127858' limit 10 DB:ezrox_toadli
loadtime:0.010394096374512 / seconds
Operation header executed (non global)
loadtime:0.010426044464111 / seconds
Operation leaderboard executed (non global)
loadtime:0.010477066040039 / seconds
Operation square executed (non global)
loadtime:0.010507106781006 / seconds
Operation square_bottom executed (non global)
loadtime:0.010535001754761 / seconds
Operation smallsquare executed (non global)
loadtime:0.010560989379883 / seconds
Operation headeradright executed (non global)
loadtime:0.010586977005005 / seconds
Operation google_analytics executed (non global)
loadtime:0.010612010955811 / seconds
Operation topstories executed (non global)
loadtime:0.010637998580933 / seconds
Operation businessnearyou executed (non global)
loadtime:0.01066517829895 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010689973831177 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010951042175293 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011137008666992 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011183023452759 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011245965957642 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011295080184937 / seconds
Template key: archive_menu pushed
loadtime:0.011304140090942 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.01131796836853 / seconds
Template key: get_gravatar pushed
loadtime:0.011325120925903 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011332988739014 / seconds
*10)-10)+1 | start:0
loadtime:0.011373996734619 / seconds
DB connected to localhost business_master_new
loadtime:0.011635065078735 / seconds
Query Executed:select * from categories where cat_URLid='hotels-and-motels'DB:business_master_new
loadtime:0.012634038925171 / seconds
Query stored in cache : _QUERY_www.toadli.coma3d211b8c105c1f61843ec3bcfcfa87f
loadtime:0.012696027755737 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='west-virginia'
loadtime:0.012748003005981 / seconds
Query Executed:select * from `wv_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.041435956954956 / seconds
Query stored in cache : _QUERY_www.toadli.comf3317b4e553e766cb03a5c588299ae4d
loadtime:0.044954061508179 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='west-virginia'
loadtime:0.0450279712677 / seconds
Query Executed:select sum(totalcount) as totalsum from `wv_catmap` where sic='7011'DB:business_master_new
loadtime:0.049520969390869 / seconds
Query stored in cache : _QUERY_www.toadli.com1bc9f98bad97c6a6b8d4e149a78a5e15
loadtime:0.049561977386475 / seconds
899 / 11
loadtime:0.049620151519775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accoville' limit 1
loadtime:0.049687147140503 / seconds
Query Executed:select id FROM `wv` where city='Accoville' && SIC_code='7011'DB:business_master_new
loadtime:0.052289962768555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adrian' limit 1
loadtime:0.052356958389282 / seconds
Query Executed:select id FROM `wv` where city='Adrian' && SIC_code='7011'DB:business_master_new
loadtime:0.05284595489502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Advent' limit 1
loadtime:0.052908182144165 / seconds
Query Executed:select id FROM `wv` where city='Advent' && SIC_code='7011'DB:business_master_new
loadtime:0.053331136703491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albright' limit 1
loadtime:0.053390979766846 / seconds
Query Executed:select id FROM `wv` where city='Albright' && SIC_code='7011'DB:business_master_new
loadtime:0.054244995117188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alderson' limit 1
loadtime:0.054306030273438 / seconds
Query Executed:select id FROM `wv` where city='Alderson' && SIC_code='7011'DB:business_master_new
loadtime:0.056564092636108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alkol' limit 1
loadtime:0.05665397644043 / seconds
Query Executed:select id FROM `wv` where city='Alkol' && SIC_code='7011'DB:business_master_new
loadtime:0.05722713470459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen Junction' limit 1
loadtime:0.05728816986084 / seconds
Query Executed:select id FROM `wv` where city='Allen Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.057746171951294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alloy' limit 1
loadtime:0.057806015014648 / seconds
Query Executed:select id FROM `wv` where city='Alloy' && SIC_code='7011'DB:business_master_new
loadtime:0.058485984802246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.058554172515869 / seconds
Query Executed:select id FROM `wv` where city='Alma' && SIC_code='7011'DB:business_master_new
loadtime:0.059165000915527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Bridge' limit 1
loadtime:0.059231042861938 / seconds
Query Executed:select id FROM `wv` where city='Alum Bridge' && SIC_code='7011'DB:business_master_new
loadtime:0.059746980667114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Creek' limit 1
loadtime:0.059808015823364 / seconds
Query Executed:select id FROM `wv` where city='Alum Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.061588048934937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherstdale' limit 1
loadtime:0.061652183532715 / seconds
Query Executed:select id FROM `wv` where city='Amherstdale' && SIC_code='7011'DB:business_master_new
loadtime:0.06220817565918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amigo' limit 1
loadtime:0.062268972396851 / seconds
Query Executed:select id FROM `wv` where city='Amigo' && SIC_code='7011'DB:business_master_new
loadtime:0.062710046768188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amma' limit 1
loadtime:0.062772035598755 / seconds
Query Executed:select id FROM `wv` where city='Amma' && SIC_code='7011'DB:business_master_new
loadtime:0.063333988189697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anawalt' limit 1
loadtime:0.063403129577637 / seconds
Query Executed:select id FROM `wv` where city='Anawalt' && SIC_code='7011'DB:business_master_new
loadtime:0.063918113708496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anmoore' limit 1
loadtime:0.063977956771851 / seconds
Query Executed:select id FROM `wv` where city='Anmoore' && SIC_code='7011'DB:business_master_new
loadtime:0.065351009368896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansted' limit 1
loadtime:0.065413951873779 / seconds
Query Executed:select id FROM `wv` where city='Ansted' && SIC_code='7011'DB:business_master_new
loadtime:0.067193984985352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.067279100418091 / seconds
Query Executed:select id FROM `wv` where city='Anthony' && SIC_code='7011'DB:business_master_new
loadtime:0.067707061767578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apple Grove' limit 1
loadtime:0.067774057388306 / seconds
Query Executed:select id FROM `wv` where city='Apple Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.068993091583252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arbovale' limit 1
loadtime:0.069056987762451 / seconds
Query Executed:select id FROM `wv` where city='Arbovale' && SIC_code='7011'DB:business_master_new
loadtime:0.069622993469238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnett' limit 1
loadtime:0.069700956344604 / seconds
Query Executed:select id FROM `wv` where city='Arnett' && SIC_code='7011'DB:business_master_new
loadtime:0.070188045501709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnoldsburg' limit 1
loadtime:0.070250988006592 / seconds
Query Executed:select id FROM `wv` where city='Arnoldsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.071603059768677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arthur' limit 1
loadtime:0.071683168411255 / seconds
Query Executed:select id FROM `wv` where city='Arthur' && SIC_code='7011'DB:business_master_new
loadtime:0.072102069854736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arthurdale' limit 1
loadtime:0.072175025939941 / seconds
Query Executed:select id FROM `wv` where city='Arthurdale' && SIC_code='7011'DB:business_master_new
loadtime:0.072847127914429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artie' limit 1
loadtime:0.072906970977783 / seconds
Query Executed:select id FROM `wv` where city='Artie' && SIC_code='7011'DB:business_master_new
loadtime:0.073352098464966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asbury' limit 1
loadtime:0.073417186737061 / seconds
Query Executed:select id FROM `wv` where city='Asbury' && SIC_code='7011'DB:business_master_new
loadtime:0.073973178863525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.074042081832886 / seconds
Query Executed:select id FROM `wv` where city='Ashford' && SIC_code='7011'DB:business_master_new
loadtime:0.074553966522217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.074615955352783 / seconds
Query Executed:select id FROM `wv` where city='Ashland' && SIC_code='7011'DB:business_master_new
loadtime:0.075047016143799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.075107097625732 / seconds
Query Executed:select id FROM `wv` where city='Ashton' && SIC_code='7011'DB:business_master_new
loadtime:0.075652122497559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.075716018676758 / seconds
Query Executed:select id FROM `wv` where city='Athens' && SIC_code='7011'DB:business_master_new
loadtime:0.077456951141357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.077540159225464 / seconds
Query Executed:select id FROM `wv` where city='Auburn' && SIC_code='7011'DB:business_master_new
loadtime:0.0779709815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.078037023544312 / seconds
Query Executed:select id FROM `wv` where city='Augusta' && SIC_code='7011'DB:business_master_new
loadtime:0.080172061920166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.080254077911377 / seconds
Query Executed:select id FROM `wv` where city='Aurora' && SIC_code='7011'DB:business_master_new
loadtime:0.080989122390747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auto' limit 1
loadtime:0.081057071685791 / seconds
Query Executed:select id FROM `wv` where city='Auto' && SIC_code='7011'DB:business_master_new
loadtime:0.081506967544556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.081567049026489 / seconds
Query Executed:select id FROM `wv` where city='Avondale' && SIC_code='7011'DB:business_master_new
loadtime:0.082102060317993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baisden' limit 1
loadtime:0.082173109054565 / seconds
Query Executed:select id FROM `wv` where city='Baisden' && SIC_code='7011'DB:business_master_new
loadtime:0.082709074020386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baker' limit 1
loadtime:0.082769155502319 / seconds
Query Executed:select id FROM `wv` where city='Baker' && SIC_code='7011'DB:business_master_new
loadtime:0.08437705039978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakerton' limit 1
loadtime:0.084443092346191 / seconds
Query Executed:select id FROM `wv` where city='Bakerton' && SIC_code='7011'DB:business_master_new
loadtime:0.08489203453064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bald Knob' limit 1
loadtime:0.084952116012573 / seconds
Query Executed:select id FROM `wv` where city='Bald Knob' && SIC_code='7011'DB:business_master_new
loadtime:0.085409164428711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballard' limit 1
loadtime:0.085469961166382 / seconds
Query Executed:select id FROM `wv` where city='Ballard' && SIC_code='7011'DB:business_master_new
loadtime:0.08617901802063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballengee' limit 1
loadtime:0.086239099502563 / seconds
Query Executed:select id FROM `wv` where city='Ballengee' && SIC_code='7011'DB:business_master_new
loadtime:0.086665153503418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.086724996566772 / seconds
Query Executed:select id FROM `wv` where city='Bancroft' && SIC_code='7011'DB:business_master_new
loadtime:0.087299108505249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barboursville' limit 1
loadtime:0.087358951568604 / seconds
Query Executed:select id FROM `wv` where city='Barboursville' && SIC_code='7011'DB:business_master_new
loadtime:0.093973159790039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrackville' limit 1
loadtime:0.094058990478516 / seconds
Query Executed:select id FROM `wv` where city='Barrackville' && SIC_code='7011'DB:business_master_new
loadtime:0.09477710723877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrett' limit 1
loadtime:0.094841957092285 / seconds
Query Executed:select id FROM `wv` where city='Barrett' && SIC_code='7011'DB:business_master_new
loadtime:0.095339059829712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartley' limit 1
loadtime:0.095400094985962 / seconds
Query Executed:select id FROM `wv` where city='Bartley' && SIC_code='7011'DB:business_master_new
loadtime:0.095905065536499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartow' limit 1
loadtime:0.095965147018433 / seconds
Query Executed:select id FROM `wv` where city='Bartow' && SIC_code='7011'DB:business_master_new
loadtime:0.096673011779785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baxter' limit 1
loadtime:0.09675407409668 / seconds
Query Executed:select id FROM `wv` where city='Baxter' && SIC_code='7011'DB:business_master_new
loadtime:0.097303152084351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.097364187240601 / seconds
Query Executed:select id FROM `wv` where city='Bayard' && SIC_code='7011'DB:business_master_new
loadtime:0.097876071929932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beards Fork' limit 1
loadtime:0.097936153411865 / seconds
Query Executed:select id FROM `wv` where city='Beards Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.098334074020386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.098392963409424 / seconds
Query Executed:select id FROM `wv` where city='Beaver' && SIC_code='7011'DB:business_master_new
loadtime:0.10219311714172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beckley' limit 1
loadtime:0.10227417945862 / seconds
Query Executed:select id FROM `wv` where city='Beckley' && SIC_code='7011'DB:business_master_new
loadtime:0.10859799385071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beckwith' limit 1
loadtime:0.10870409011841 / seconds
Query Executed:select id FROM `wv` where city='Beckwith' && SIC_code='7011'DB:business_master_new
loadtime:0.10920310020447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Bottom' limit 1
loadtime:0.10926795005798 / seconds
Query Executed:select id FROM `wv` where city='Beech Bottom' && SIC_code='7011'DB:business_master_new
loadtime:0.10986804962158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beeson' limit 1
loadtime:0.10993313789368 / seconds
Query Executed:select id FROM `wv` where city='Beeson' && SIC_code='7011'DB:business_master_new
loadtime:0.11040711402893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belington' limit 1
loadtime:0.11047196388245 / seconds
Query Executed:select id FROM `wv` where city='Belington' && SIC_code='7011'DB:business_master_new
loadtime:0.11275315284729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle' limit 1
loadtime:0.11283111572266 / seconds
Query Executed:select id FROM `wv` where city='Belle' && SIC_code='7011'DB:business_master_new
loadtime:0.11537599563599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.11543917655945 / seconds
Query Executed:select id FROM `wv` where city='Belleville' && SIC_code='7011'DB:business_master_new
loadtime:0.11611008644104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.11618804931641 / seconds
Query Executed:select id FROM `wv` where city='Belmont' && SIC_code='7011'DB:business_master_new
loadtime:0.11763906478882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belva' limit 1
loadtime:0.11770105361938 / seconds
Query Executed:select id FROM `wv` where city='Belva' && SIC_code='7011'DB:business_master_new
loadtime:0.11826109886169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bens Run' limit 1
loadtime:0.11832118034363 / seconds
Query Executed:select id FROM `wv` where city='Bens Run' && SIC_code='7011'DB:business_master_new
loadtime:0.11878395080566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentree' limit 1
loadtime:0.1188440322876 / seconds
Query Executed:select id FROM `wv` where city='Bentree' && SIC_code='7011'DB:business_master_new
loadtime:0.11931610107422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benwood' limit 1
loadtime:0.11937618255615 / seconds
Query Executed:select id FROM `wv` where city='Benwood' && SIC_code='7011'DB:business_master_new
loadtime:0.12112498283386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berea' limit 1
loadtime:0.12119817733765 / seconds
Query Executed:select id FROM `wv` where city='Berea' && SIC_code='7011'DB:business_master_new
loadtime:0.12163710594177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergoo' limit 1
loadtime:0.12169814109802 / seconds
Query Executed:select id FROM `wv` where city='Bergoo' && SIC_code='7011'DB:business_master_new
loadtime:0.12215399742126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkeley Springs' limit 1
loadtime:0.12221598625183 / seconds
Query Executed:select id FROM `wv` where city='Berkeley Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.12809205055237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berwind' limit 1
loadtime:0.1282069683075 / seconds
Query Executed:select id FROM `wv` where city='Berwind' && SIC_code='7011'DB:business_master_new
loadtime:0.12883615493774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.12890005111694 / seconds
Query Executed:select id FROM `wv` where city='Bethany' && SIC_code='7011'DB:business_master_new
loadtime:0.12947797775269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.12953901290894 / seconds
Query Executed:select id FROM `wv` where city='Beverly' && SIC_code='7011'DB:business_master_new
loadtime:0.13133001327515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bickmore' limit 1
loadtime:0.1313910484314 / seconds
Query Executed:select id FROM `wv` where city='Bickmore' && SIC_code='7011'DB:business_master_new
loadtime:0.13195013999939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bend' limit 1
loadtime:0.13202309608459 / seconds
Query Executed:select id FROM `wv` where city='Big Bend' && SIC_code='7011'DB:business_master_new
loadtime:0.13258814811707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Chimney' limit 1
loadtime:0.13264799118042 / seconds
Query Executed:select id FROM `wv` where city='Big Chimney' && SIC_code='7011'DB:business_master_new
loadtime:0.13313317298889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Creek' limit 1
loadtime:0.13320398330688 / seconds
Query Executed:select id FROM `wv` where city='Big Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.13372898101807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Otter' limit 1
loadtime:0.1337890625 / seconds
Query Executed:select id FROM `wv` where city='Big Otter' && SIC_code='7011'DB:business_master_new
loadtime:0.13421106338501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Run' limit 1
loadtime:0.1342761516571 / seconds
Query Executed:select id FROM `wv` where city='Big Run' && SIC_code='7011'DB:business_master_new
loadtime:0.1346549987793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Sandy' limit 1
loadtime:0.13471913337708 / seconds
Query Executed:select id FROM `wv` where city='Big Sandy' && SIC_code='7011'DB:business_master_new
loadtime:0.13515710830688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Springs' limit 1
loadtime:0.13521814346313 / seconds
Query Executed:select id FROM `wv` where city='Big Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.13570809364319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bigbend' limit 1
loadtime:0.13576817512512 / seconds
Query Executed:select id FROM `wv` where city='Bigbend' && SIC_code='7011'DB:business_master_new
loadtime:0.13617205619812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bim' limit 1
loadtime:0.13623213768005 / seconds
Query Executed:select id FROM `wv` where city='Bim' && SIC_code='7011'DB:business_master_new
loadtime:0.13668203353882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birch River' limit 1
loadtime:0.13674402236938 / seconds
Query Executed:select id FROM `wv` where city='Birch River' && SIC_code='7011'DB:business_master_new
loadtime:0.13741898536682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksville' limit 1
loadtime:0.13748002052307 / seconds
Query Executed:select id FROM `wv` where city='Blacksville' && SIC_code='7011'DB:business_master_new
loadtime:0.13822507858276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.13828611373901 / seconds
Query Executed:select id FROM `wv` where city='Blair' && SIC_code='7011'DB:business_master_new
loadtime:0.13872313499451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomery' limit 1
loadtime:0.13878297805786 / seconds
Query Executed:select id FROM `wv` where city='Bloomery' && SIC_code='7011'DB:business_master_new
loadtime:0.13933610916138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingrose' limit 1
loadtime:0.13939714431763 / seconds
Query Executed:select id FROM `wv` where city='Bloomingrose' && SIC_code='7011'DB:business_master_new
loadtime:0.13988900184631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blount' limit 1
loadtime:0.13994908332825 / seconds
Query Executed:select id FROM `wv` where city='Blount' && SIC_code='7011'DB:business_master_new
loadtime:0.14040613174438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Creek' limit 1
loadtime:0.14046597480774 / seconds
Query Executed:select id FROM `wv` where city='Blue Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.14099597930908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Jay' limit 1
loadtime:0.14105701446533 / seconds
Query Executed:select id FROM `wv` where city='Blue Jay' && SIC_code='7011'DB:business_master_new
loadtime:0.14151811599731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:0.14157915115356 / seconds
Query Executed:select id FROM `wv` where city='Bluefield' && SIC_code='7011'DB:business_master_new
loadtime:0.1479229927063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluewell' limit 1
loadtime:0.1480131149292 / seconds
Query Executed:select id FROM `wv` where city='Bluewell' && SIC_code='7011'DB:business_master_new
loadtime:0.14892506599426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bob White' limit 1
loadtime:0.14899897575378 / seconds
Query Executed:select id FROM `wv` where city='Bob White' && SIC_code='7011'DB:business_master_new
loadtime:0.14953517913818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolt' limit 1
loadtime:0.14959597587585 / seconds
Query Executed:select id FROM `wv` where city='Bolt' && SIC_code='7011'DB:business_master_new
loadtime:0.15020203590393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bomont' limit 1
loadtime:0.15026211738586 / seconds
Query Executed:select id FROM `wv` where city='Bomont' && SIC_code='7011'DB:business_master_new
loadtime:0.15074706077576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boomer' limit 1
loadtime:0.15080714225769 / seconds
Query Executed:select id FROM `wv` where city='Boomer' && SIC_code='7011'DB:business_master_new
loadtime:0.1513090133667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booth' limit 1
loadtime:0.15136909484863 / seconds
Query Executed:select id FROM `wv` where city='Booth' && SIC_code='7011'DB:business_master_new
loadtime:0.151771068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Borderland' limit 1
loadtime:0.15183210372925 / seconds
Query Executed:select id FROM `wv` where city='Borderland' && SIC_code='7011'DB:business_master_new
loadtime:0.15230703353882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowden' limit 1
loadtime:0.15236711502075 / seconds
Query Executed:select id FROM `wv` where city='Bowden' && SIC_code='7011'DB:business_master_new
loadtime:0.15287804603577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozoo' limit 1
loadtime:0.15295314788818 / seconds
Query Executed:select id FROM `wv` where city='Bozoo' && SIC_code='7011'DB:business_master_new
loadtime:0.15338397026062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.15344500541687 / seconds
Query Executed:select id FROM `wv` where city='Bradley' && SIC_code='7011'DB:business_master_new
loadtime:0.15492701530457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradshaw' limit 1
loadtime:0.15499997138977 / seconds
Query Executed:select id FROM `wv` where city='Bradshaw' && SIC_code='7011'DB:business_master_new
loadtime:0.15577507019043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bramwell' limit 1
loadtime:0.15584015846252 / seconds
Query Executed:select id FROM `wv` where city='Bramwell' && SIC_code='7011'DB:business_master_new
loadtime:0.15659713745117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchland' limit 1
loadtime:0.15667510032654 / seconds
Query Executed:select id FROM `wv` where city='Branchland' && SIC_code='7011'DB:business_master_new
loadtime:0.1585111618042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandywine' limit 1
loadtime:0.15857601165771 / seconds
Query Executed:select id FROM `wv` where city='Brandywine' && SIC_code='7011'DB:business_master_new
loadtime:0.15938901901245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breeden' limit 1
loadtime:0.15946507453918 / seconds
Query Executed:select id FROM `wv` where city='Breeden' && SIC_code='7011'DB:business_master_new
loadtime:0.15994811058044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brenton' limit 1
loadtime:0.16001415252686 / seconds
Query Executed:select id FROM `wv` where city='Brenton' && SIC_code='7011'DB:business_master_new
loadtime:0.16073107719421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bretz' limit 1
loadtime:0.16079115867615 / seconds
Query Executed:select id FROM `wv` where city='Bretz' && SIC_code='7011'DB:business_master_new
loadtime:0.1612069606781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.1612720489502 / seconds
Query Executed:select id FROM `wv` where city='Bridgeport' && SIC_code='7011'DB:business_master_new
loadtime:0.16757106781006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.16766309738159 / seconds
Query Executed:select id FROM `wv` where city='Bristol' && SIC_code='7011'DB:business_master_new
loadtime:0.16811299324036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brohard' limit 1
loadtime:0.16818594932556 / seconds
Query Executed:select id FROM `wv` where city='Brohard' && SIC_code='7011'DB:business_master_new
loadtime:0.16858196258545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooks' limit 1
loadtime:0.16864109039307 / seconds
Query Executed:select id FROM `wv` where city='Brooks' && SIC_code='7011'DB:business_master_new
loadtime:0.16907000541687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownton' limit 1
loadtime:0.16913104057312 / seconds
Query Executed:select id FROM `wv` where city='Brownton' && SIC_code='7011'DB:business_master_new
loadtime:0.16953897476196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruceton Mills' limit 1
loadtime:0.1695990562439 / seconds
Query Executed:select id FROM `wv` where city='Bruceton Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.17221307754517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruno' limit 1
loadtime:0.17229199409485 / seconds
Query Executed:select id FROM `wv` where city='Bruno' && SIC_code='7011'DB:business_master_new
loadtime:0.17273902893066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.17280101776123 / seconds
Query Executed:select id FROM `wv` where city='Buckeye' && SIC_code='7011'DB:business_master_new
loadtime:0.17347598075867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckhannon' limit 1
loadtime:0.17355799674988 / seconds
Query Executed:select id FROM `wv` where city='Buckhannon' && SIC_code='7011'DB:business_master_new
loadtime:0.17988395690918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bud' limit 1
loadtime:0.1799750328064 / seconds
Query Executed:select id FROM `wv` where city='Bud' && SIC_code='7011'DB:business_master_new
loadtime:0.18048906326294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.18055701255798 / seconds
Query Executed:select id FROM `wv` where city='Buffalo' && SIC_code='7011'DB:business_master_new
loadtime:0.18205499649048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunker Hill' limit 1
loadtime:0.18213200569153 / seconds
Query Executed:select id FROM `wv` where city='Bunker Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.18434405326843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.18441104888916 / seconds
Query Executed:select id FROM `wv` where city='Burlington' && SIC_code='7011'DB:business_master_new
loadtime:0.1859290599823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.18601512908936 / seconds
Query Executed:select id FROM `wv` where city='Burnsville' && SIC_code='7011'DB:business_master_new
loadtime:0.18672895431519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnwell' limit 1
loadtime:0.18680906295776 / seconds
Query Executed:select id FROM `wv` where city='Burnwell' && SIC_code='7011'DB:business_master_new
loadtime:0.18728303909302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burton' limit 1
loadtime:0.18734908103943 / seconds
Query Executed:select id FROM `wv` where city='Burton' && SIC_code='7011'DB:business_master_new
loadtime:0.18790507316589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabin Creek' limit 1
loadtime:0.18796515464783 / seconds
Query Executed:select id FROM `wv` where city='Cabin Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.18946599960327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cabins' limit 1
loadtime:0.18952918052673 / seconds
Query Executed:select id FROM `wv` where city='Cabins' && SIC_code='7011'DB:business_master_new
loadtime:0.19011402130127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cairo' limit 1
loadtime:0.19020295143127 / seconds
Query Executed:select id FROM `wv` where city='Cairo' && SIC_code='7011'DB:business_master_new
loadtime:0.19087600708008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caldwell' limit 1
loadtime:0.19094395637512 / seconds
Query Executed:select id FROM `wv` where city='Caldwell' && SIC_code='7011'DB:business_master_new
loadtime:0.19164800643921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calvin' limit 1
loadtime:0.19170904159546 / seconds
Query Executed:select id FROM `wv` where city='Calvin' && SIC_code='7011'DB:business_master_new
loadtime:0.19223308563232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.19229412078857 / seconds
Query Executed:select id FROM `wv` where city='Camden' && SIC_code='7011'DB:business_master_new
loadtime:0.19281506538391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden On Gauley' limit 1
loadtime:0.19287514686584 / seconds
Query Executed:select id FROM `wv` where city='Camden On Gauley' && SIC_code='7011'DB:business_master_new
loadtime:0.19342708587646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.19348907470703 / seconds
Query Executed:select id FROM `wv` where city='Cameron' && SIC_code='7011'DB:business_master_new
loadtime:0.19557309150696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Creek' limit 1
loadtime:0.19563508033752 / seconds
Query Executed:select id FROM `wv` where city='Camp Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.19618010520935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannelton' limit 1
loadtime:0.19624018669128 / seconds
Query Executed:select id FROM `wv` where city='Cannelton' && SIC_code='7011'DB:business_master_new
loadtime:0.19678401947021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canvas' limit 1
loadtime:0.19684600830078 / seconds
Query Executed:select id FROM `wv` where city='Canvas' && SIC_code='7011'DB:business_master_new
loadtime:0.19745302200317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capels' limit 1
loadtime:0.19751405715942 / seconds
Query Executed:select id FROM `wv` where city='Capels' && SIC_code='7011'DB:business_master_new
loadtime:0.19796109199524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capon Bridge' limit 1
loadtime:0.19802808761597 / seconds
Query Executed:select id FROM `wv` where city='Capon Bridge' && SIC_code='7011'DB:business_master_new
loadtime:0.19990015029907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capon Springs' limit 1
loadtime:0.19997501373291 / seconds
Query Executed:select id FROM `wv` where city='Capon Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.20045113563538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caretta' limit 1
loadtime:0.20051217079163 / seconds
Query Executed:select id FROM `wv` where city='Caretta' && SIC_code='7011'DB:business_master_new
loadtime:0.2009711265564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina' limit 1
loadtime:0.20103597640991 / seconds
Query Executed:select id FROM `wv` where city='Carolina' && SIC_code='7011'DB:business_master_new
loadtime:0.20150399208069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cass' limit 1
loadtime:0.20156908035278 / seconds
Query Executed:select id FROM `wv` where city='Cass' && SIC_code='7011'DB:business_master_new
loadtime:0.20214009284973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassville' limit 1
loadtime:0.20222616195679 / seconds
Query Executed:select id FROM `wv` where city='Cassville' && SIC_code='7011'DB:business_master_new
loadtime:0.20271801948547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:0.20278000831604 / seconds
Query Executed:select id FROM `wv` where city='Cedar Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.20353603363037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:0.20359706878662 / seconds
Query Executed:select id FROM `wv` where city='Cedarville' && SIC_code='7011'DB:business_master_new
loadtime:0.20428013801575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Point' limit 1
loadtime:0.20434808731079 / seconds
Query Executed:select id FROM `wv` where city='Center Point' && SIC_code='7011'DB:business_master_new
loadtime:0.204833984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centralia' limit 1
loadtime:0.20489811897278 / seconds
Query Executed:select id FROM `wv` where city='Centralia' && SIC_code='7011'DB:business_master_new
loadtime:0.20536804199219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceredo' limit 1
loadtime:0.20543313026428 / seconds
Query Executed:select id FROM `wv` where city='Ceredo' && SIC_code='7011'DB:business_master_new
loadtime:0.20765614509583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapmanville' limit 1
loadtime:0.20773410797119 / seconds
Query Executed:select id FROM `wv` where city='Chapmanville' && SIC_code='7011'DB:business_master_new
loadtime:0.21159100532532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles Town' limit 1
loadtime:0.21167516708374 / seconds
Query Executed:select id FROM `wv` where city='Charles Town' && SIC_code='7011'DB:business_master_new
loadtime:0.21990895271301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.22000503540039 / seconds
Query Executed:select id FROM `wv` where city='Charleston' && SIC_code='7011'DB:business_master_new
loadtime:0.2264449596405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Heights' limit 1
loadtime:0.22658205032349 / seconds
Query Executed:select id FROM `wv` where city='Charlton Heights' && SIC_code='7011'DB:business_master_new
loadtime:0.22718405723572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charmco' limit 1
loadtime:0.22725009918213 / seconds
Query Executed:select id FROM `wv` where city='Charmco' && SIC_code='7011'DB:business_master_new
loadtime:0.22790908813477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chattaroy' limit 1
loadtime:0.22797513008118 / seconds
Query Executed:select id FROM `wv` where city='Chattaroy' && SIC_code='7011'DB:business_master_new
loadtime:0.22861409187317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chauncey' limit 1
loadtime:0.22867512702942 / seconds
Query Executed:select id FROM `wv` where city='Chauncey' && SIC_code='7011'DB:business_master_new
loadtime:0.22911095619202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.22918915748596 / seconds
Query Executed:select id FROM `wv` where city='Chester' && SIC_code='7011'DB:business_master_new
loadtime:0.23186802864075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chloe' limit 1
loadtime:0.23194813728333 / seconds
Query Executed:select id FROM `wv` where city='Chloe' && SIC_code='7011'DB:business_master_new
loadtime:0.23245906829834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Circleville' limit 1
loadtime:0.23253417015076 / seconds
Query Executed:select id FROM `wv` where city='Circleville' && SIC_code='7011'DB:business_master_new
loadtime:0.23309397697449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:0.23316717147827 / seconds
Query Executed:select id FROM `wv` where city='Clarksburg' && SIC_code='7011'DB:business_master_new
loadtime:0.23946595191956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay' limit 1
loadtime:0.23954701423645 / seconds
Query Executed:select id FROM `wv` where city='Clay' && SIC_code='7011'DB:business_master_new
loadtime:0.24186611175537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Creek' limit 1
loadtime:0.24194598197937 / seconds
Query Executed:select id FROM `wv` where city='Clear Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.24245405197144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Fork' limit 1
loadtime:0.24251508712769 / seconds
Query Executed:select id FROM `wv` where city='Clear Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.2430100440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clendenin' limit 1
loadtime:0.24307203292847 / seconds
Query Executed:select id FROM `wv` where city='Clendenin' && SIC_code='7011'DB:business_master_new
loadtime:0.24563813209534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.24570608139038 / seconds
Query Executed:select id FROM `wv` where city='Cleveland' && SIC_code='7011'DB:business_master_new
loadtime:0.24617409706116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.24623513221741 / seconds
Query Executed:select id FROM `wv` where city='Clifton' && SIC_code='7011'DB:business_master_new
loadtime:0.24667096138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintonville' limit 1
loadtime:0.24673199653625 / seconds
Query Executed:select id FROM `wv` where city='Clintonville' && SIC_code='7011'DB:business_master_new
loadtime:0.24718499183655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clothier' limit 1
loadtime:0.24724507331848 / seconds
Query Executed:select id FROM `wv` where city='Clothier' && SIC_code='7011'DB:business_master_new
loadtime:0.2477240562439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coal City' limit 1
loadtime:0.24778413772583 / seconds
Query Executed:select id FROM `wv` where city='Coal City' && SIC_code='7011'DB:business_master_new
loadtime:0.24861598014832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coal Mountain' limit 1
loadtime:0.24867701530457 / seconds
Query Executed:select id FROM `wv` where city='Coal Mountain' && SIC_code='7011'DB:business_master_new
loadtime:0.24923706054688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalton' limit 1
loadtime:0.24929904937744 / seconds
Query Executed:select id FROM `wv` where city='Coalton' && SIC_code='7011'DB:business_master_new
loadtime:0.24987697601318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalwood' limit 1
loadtime:0.24993801116943 / seconds
Query Executed:select id FROM `wv` where city='Coalwood' && SIC_code='7011'DB:business_master_new
loadtime:0.25048398971558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colcord' limit 1
loadtime:0.25054907798767 / seconds
Query Executed:select id FROM `wv` where city='Colcord' && SIC_code='7011'DB:business_master_new
loadtime:0.25105714797974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.25111818313599 / seconds
Query Executed:select id FROM `wv` where city='Colfax' && SIC_code='7011'DB:business_master_new
loadtime:0.2516131401062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colliers' limit 1
loadtime:0.25167417526245 / seconds
Query Executed:select id FROM `wv` where city='Colliers' && SIC_code='7011'DB:business_master_new
loadtime:0.2525200843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comfort' limit 1
loadtime:0.25259017944336 / seconds
Query Executed:select id FROM `wv` where city='Comfort' && SIC_code='7011'DB:business_master_new
loadtime:0.25313711166382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cool Ridge' limit 1
loadtime:0.2532069683075 / seconds
Query Executed:select id FROM `wv` where city='Cool Ridge' && SIC_code='7011'DB:business_master_new
loadtime:0.25399899482727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copen' limit 1
loadtime:0.25406002998352 / seconds
Query Executed:select id FROM `wv` where city='Copen' && SIC_code='7011'DB:business_master_new
loadtime:0.25453114509583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cora' limit 1
loadtime:0.25459313392639 / seconds
Query Executed:select id FROM `wv` where city='Cora' && SIC_code='7011'DB:business_master_new
loadtime:0.25517106056213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Core' limit 1
loadtime:0.25523114204407 / seconds
Query Executed:select id FROM `wv` where city='Core' && SIC_code='7011'DB:business_master_new
loadtime:0.25573110580444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinne' limit 1
loadtime:0.25579118728638 / seconds
Query Executed:select id FROM `wv` where city='Corinne' && SIC_code='7011'DB:business_master_new
loadtime:0.25627899169922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.25634598731995 / seconds
Query Executed:select id FROM `wv` where city='Corinth' && SIC_code='7011'DB:business_master_new
loadtime:0.25680303573608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Costa' limit 1
loadtime:0.25686311721802 / seconds
Query Executed:select id FROM `wv` where city='Costa' && SIC_code='7011'DB:business_master_new
loadtime:0.25734400749207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottageville' limit 1
loadtime:0.25740504264832 / seconds
Query Executed:select id FROM `wv` where city='Cottageville' && SIC_code='7011'DB:business_master_new
loadtime:0.25819611549377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottle' limit 1
loadtime:0.25825905799866 / seconds
Query Executed:select id FROM `wv` where city='Cottle' && SIC_code='7011'DB:business_master_new
loadtime:0.25873208045959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covel' limit 1
loadtime:0.25879406929016 / seconds
Query Executed:select id FROM `wv` where city='Covel' && SIC_code='7011'DB:business_master_new
loadtime:0.25930213928223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowen' limit 1
loadtime:0.25936317443848 / seconds
Query Executed:select id FROM `wv` where city='Cowen' && SIC_code='7011'DB:business_master_new
loadtime:0.26068615913391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coxs Mills' limit 1
loadtime:0.26076698303223 / seconds
Query Executed:select id FROM `wv` where city='Coxs Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.26127409934998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crab Orchard' limit 1
loadtime:0.26134300231934 / seconds
Query Executed:select id FROM `wv` where city='Crab Orchard' && SIC_code='7011'DB:business_master_new
loadtime:0.26357007026672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:0.26363205909729 / seconds
Query Executed:select id FROM `wv` where city='Craigsville' && SIC_code='7011'DB:business_master_new
loadtime:0.26570415496826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cranberry' limit 1
loadtime:0.26576495170593 / seconds
Query Executed:select id FROM `wv` where city='Cranberry' && SIC_code='7011'DB:business_master_new
loadtime:0.26625204086304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:0.26631903648376 / seconds
Query Executed:select id FROM `wv` where city='Crawford' && SIC_code='7011'DB:business_master_new
loadtime:0.26687407493591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawley' limit 1
loadtime:0.26693797111511 / seconds
Query Executed:select id FROM `wv` where city='Crawley' && SIC_code='7011'DB:business_master_new
loadtime:0.26773595809937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.26779818534851 / seconds
Query Executed:select id FROM `wv` where city='Creston' && SIC_code='7011'DB:business_master_new
loadtime:0.2682831287384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Lanes' limit 1
loadtime:0.26834797859192 / seconds
Query Executed:select id FROM `wv` where city='Cross Lanes' && SIC_code='7011'DB:business_master_new
loadtime:0.26895308494568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crown Hill' limit 1
loadtime:0.26902413368225 / seconds
Query Executed:select id FROM `wv` where city='Crown Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.26946902275085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crum' limit 1
loadtime:0.2695300579071 / seconds
Query Executed:select id FROM `wv` where city='Crum' && SIC_code='7011'DB:business_master_new
loadtime:0.27013111114502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crumpler' limit 1
loadtime:0.27020215988159 / seconds
Query Executed:select id FROM `wv` where city='Crumpler' && SIC_code='7011'DB:business_master_new
loadtime:0.27064108848572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cucumber' limit 1
loadtime:0.27070116996765 / seconds
Query Executed:select id FROM `wv` where city='Cucumber' && SIC_code='7011'DB:business_master_new
loadtime:0.27119898796082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culloden' limit 1
loadtime:0.27125906944275 / seconds
Query Executed:select id FROM `wv` where city='Culloden' && SIC_code='7011'DB:business_master_new
loadtime:0.27265095710754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cyclone' limit 1
loadtime:0.27271699905396 / seconds
Query Executed:select id FROM `wv` where city='Cyclone' && SIC_code='7011'DB:business_master_new
loadtime:0.27331304550171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dailey' limit 1
loadtime:0.27337408065796 / seconds
Query Executed:select id FROM `wv` where city='Dailey' && SIC_code='7011'DB:business_master_new
loadtime:0.27407312393188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.27416396141052 / seconds
Query Executed:select id FROM `wv` where city='Dallas' && SIC_code='7011'DB:business_master_new
loadtime:0.27465295791626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danese' limit 1
loadtime:0.27471518516541 / seconds
Query Executed:select id FROM `wv` where city='Danese' && SIC_code='7011'DB:business_master_new
loadtime:0.27535796165466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daniels' limit 1
loadtime:0.2754180431366 / seconds
Query Executed:select id FROM `wv` where city='Daniels' && SIC_code='7011'DB:business_master_new
loadtime:0.27762699127197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.27770900726318 / seconds
Query Executed:select id FROM `wv` where city='Danville' && SIC_code='7011'DB:business_master_new
loadtime:0.28018307685852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davin' limit 1
loadtime:0.28026103973389 / seconds
Query Executed:select id FROM `wv` where city='Davin' && SIC_code='7011'DB:business_master_new
loadtime:0.28082513809204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.28088712692261 / seconds
Query Executed:select id FROM `wv` where city='Davis' && SIC_code='7011'DB:business_master_new
loadtime:0.28315806388855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davisville' limit 1
loadtime:0.28325700759888 / seconds
Query Executed:select id FROM `wv` where city='Davisville' && SIC_code='7011'DB:business_master_new
loadtime:0.28412318229675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davy' limit 1
loadtime:0.28419804573059 / seconds
Query Executed:select id FROM `wv` where city='Davy' && SIC_code='7011'DB:business_master_new
loadtime:0.28475904464722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawes' limit 1
loadtime:0.28482413291931 / seconds
Query Executed:select id FROM `wv` where city='Dawes' && SIC_code='7011'DB:business_master_new
loadtime:0.28533101081848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawson' limit 1
loadtime:0.28539800643921 / seconds
Query Executed:select id FROM `wv` where city='Dawson' && SIC_code='7011'DB:business_master_new
loadtime:0.28582501411438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Water' limit 1
loadtime:0.28588509559631 / seconds
Query Executed:select id FROM `wv` where city='Deep Water' && SIC_code='7011'DB:business_master_new
loadtime:0.28635215759277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delbarton' limit 1
loadtime:0.28641200065613 / seconds
Query Executed:select id FROM `wv` where city='Delbarton' && SIC_code='7011'DB:business_master_new
loadtime:0.28781318664551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dellslow' limit 1
loadtime:0.28788709640503 / seconds
Query Executed:select id FROM `wv` where city='Dellslow' && SIC_code='7011'DB:business_master_new
loadtime:0.28881096839905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delray' limit 1
loadtime:0.28887295722961 / seconds
Query Executed:select id FROM `wv` where city='Delray' && SIC_code='7011'DB:business_master_new
loadtime:0.28935217857361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamond' limit 1
loadtime:0.28942608833313 / seconds
Query Executed:select id FROM `wv` where city='Diamond' && SIC_code='7011'DB:business_master_new
loadtime:0.28983497619629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diana' limit 1
loadtime:0.28990197181702 / seconds
Query Executed:select id FROM `wv` where city='Diana' && SIC_code='7011'DB:business_master_new
loadtime:0.29044413566589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dille' limit 1
loadtime:0.29050517082214 / seconds
Query Executed:select id FROM `wv` where city='Dille' && SIC_code='7011'DB:business_master_new
loadtime:0.29095101356506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dingess' limit 1
loadtime:0.29101610183716 / seconds
Query Executed:select id FROM `wv` where city='Dingess' && SIC_code='7011'DB:business_master_new
loadtime:0.29167008399963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixie' limit 1
loadtime:0.29173111915588 / seconds
Query Executed:select id FROM `wv` where city='Dixie' && SIC_code='7011'DB:business_master_new
loadtime:0.29235601425171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorcas' limit 1
loadtime:0.29241609573364 / seconds
Query Executed:select id FROM `wv` where city='Dorcas' && SIC_code='7011'DB:business_master_new
loadtime:0.29288506507874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorothy' limit 1
loadtime:0.29294610023499 / seconds
Query Executed:select id FROM `wv` where city='Dorothy' && SIC_code='7011'DB:business_master_new
loadtime:0.29347014427185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dothan' limit 1
loadtime:0.2935311794281 / seconds
Query Executed:select id FROM `wv` where city='Dothan' && SIC_code='7011'DB:business_master_new
loadtime:0.29399013519287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drennen' limit 1
loadtime:0.29404997825623 / seconds
Query Executed:select id FROM `wv` where city='Drennen' && SIC_code='7011'DB:business_master_new
loadtime:0.29458713531494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Droop' limit 1
loadtime:0.29464817047119 / seconds
Query Executed:select id FROM `wv` where city='Droop' && SIC_code='7011'DB:business_master_new
loadtime:0.29511404037476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Creek' limit 1
loadtime:0.29518604278564 / seconds
Query Executed:select id FROM `wv` where city='Dry Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.29566597938538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drybranch' limit 1
loadtime:0.29572701454163 / seconds
Query Executed:select id FROM `wv` where city='Drybranch' && SIC_code='7011'DB:business_master_new
loadtime:0.29624199867249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryfork' limit 1
loadtime:0.29630208015442 / seconds
Query Executed:select id FROM `wv` where city='Dryfork' && SIC_code='7011'DB:business_master_new
loadtime:0.29686403274536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck' limit 1
loadtime:0.29692411422729 / seconds
Query Executed:select id FROM `wv` where city='Duck' && SIC_code='7011'DB:business_master_new
loadtime:0.29755210876465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbar' limit 1
loadtime:0.2976131439209 / seconds
Query Executed:select id FROM `wv` where city='Dunbar' && SIC_code='7011'DB:business_master_new
loadtime:0.30290603637695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunlow' limit 1
loadtime:0.30299806594849 / seconds
Query Executed:select id FROM `wv` where city='Dunlow' && SIC_code='7011'DB:business_master_new
loadtime:0.30366015434265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunmore' limit 1
loadtime:0.30372309684753 / seconds
Query Executed:select id FROM `wv` where city='Dunmore' && SIC_code='7011'DB:business_master_new
loadtime:0.30437111854553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durbin' limit 1
loadtime:0.30445504188538 / seconds
Query Executed:select id FROM `wv` where city='Durbin' && SIC_code='7011'DB:business_master_new
loadtime:0.30519318580627 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bank' limit 1
loadtime:0.30527114868164 / seconds
Query Executed:select id FROM `wv` where city='East Bank' && SIC_code='7011'DB:business_master_new
loadtime:0.30607414245605 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lynn' limit 1
loadtime:0.30613613128662 / seconds
Query Executed:select id FROM `wv` where city='East Lynn' && SIC_code='7011'DB:business_master_new
loadtime:0.30678296089172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eccles' limit 1
loadtime:0.30684900283813 / seconds
Query Executed:select id FROM `wv` where city='Eccles' && SIC_code='7011'DB:business_master_new
loadtime:0.30739498138428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckman' limit 1
loadtime:0.30745601654053 / seconds
Query Executed:select id FROM `wv` where city='Eckman' && SIC_code='7011'DB:business_master_new
loadtime:0.30794501304626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgarton' limit 1
loadtime:0.30801010131836 / seconds
Query Executed:select id FROM `wv` where city='Edgarton' && SIC_code='7011'DB:business_master_new
loadtime:0.30851602554321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmond' limit 1
loadtime:0.30857706069946 / seconds
Query Executed:select id FROM `wv` where city='Edmond' && SIC_code='7011'DB:business_master_new
loadtime:0.30907917022705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eglon' limit 1
loadtime:0.3091561794281 / seconds
Query Executed:select id FROM `wv` where city='Eglon' && SIC_code='7011'DB:business_master_new
loadtime:0.30989909172058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elbert' limit 1
loadtime:0.30996417999268 / seconds
Query Executed:select id FROM `wv` where city='Elbert' && SIC_code='7011'DB:business_master_new
loadtime:0.31043100357056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eleanor' limit 1
loadtime:0.31049299240112 / seconds
Query Executed:select id FROM `wv` where city='Eleanor' && SIC_code='7011'DB:business_master_new
loadtime:0.31181001663208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth' limit 1
loadtime:0.31187009811401 / seconds
Query Executed:select id FROM `wv` where city='Elizabeth' && SIC_code='7011'DB:business_master_new
loadtime:0.31416511535645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:0.31423211097717 / seconds
Query Executed:select id FROM `wv` where city='Elk Garden' && SIC_code='7011'DB:business_master_new
loadtime:0.31498217582703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhorn' limit 1
loadtime:0.31504607200623 / seconds
Query Executed:select id FROM `wv` where city='Elkhorn' && SIC_code='7011'DB:business_master_new
loadtime:0.31549096107483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.31555199623108 / seconds
Query Executed:select id FROM `wv` where city='Elkins' && SIC_code='7011'DB:business_master_new
loadtime:0.32588815689087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkview' limit 1
loadtime:0.32598400115967 / seconds
Query Executed:select id FROM `wv` where city='Elkview' && SIC_code='7011'DB:business_master_new
loadtime:0.32984709739685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellamore' limit 1
loadtime:0.3299241065979 / seconds
Query Executed:select id FROM `wv` where city='Ellamore' && SIC_code='7011'DB:business_master_new
loadtime:0.3305070400238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellenboro' limit 1
loadtime:0.33056998252869 / seconds
Query Executed:select id FROM `wv` where city='Ellenboro' && SIC_code='7011'DB:business_master_new
loadtime:0.33149313926697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Grove' limit 1
loadtime:0.33155798912048 / seconds
Query Executed:select id FROM `wv` where city='Elm Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.33198499679565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmira' limit 1
loadtime:0.33206105232239 / seconds
Query Executed:select id FROM `wv` where city='Elmira' && SIC_code='7011'DB:business_master_new
loadtime:0.33246898651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elton' limit 1
loadtime:0.33252906799316 / seconds
Query Executed:select id FROM `wv` where city='Elton' && SIC_code='7011'DB:business_master_new
loadtime:0.33292508125305 / seconds
Query loaded from cache:select * from geodata_geocity where city='English' limit 1
loadtime:0.33299398422241 / seconds
Query Executed:select id FROM `wv` where city='English' && SIC_code='7011'DB:business_master_new
loadtime:0.33342814445496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.33348917961121 / seconds
Query Executed:select id FROM `wv` where city='Enterprise' && SIC_code='7011'DB:business_master_new
loadtime:0.33403611183167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erbacon' limit 1
loadtime:0.33409810066223 / seconds
Query Executed:select id FROM `wv` where city='Erbacon' && SIC_code='7011'DB:business_master_new
loadtime:0.33458614349365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eskdale' limit 1
loadtime:0.3346471786499 / seconds
Query Executed:select id FROM `wv` where city='Eskdale' && SIC_code='7011'DB:business_master_new
loadtime:0.33516216278076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethel' limit 1
loadtime:0.33522200584412 / seconds
Query Executed:select id FROM `wv` where city='Ethel' && SIC_code='7011'DB:business_master_new
loadtime:0.33569002151489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evans' limit 1
loadtime:0.33575010299683 / seconds
Query Executed:select id FROM `wv` where city='Evans' && SIC_code='7011'DB:business_master_new
loadtime:0.33645510673523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exchange' limit 1
loadtime:0.33651614189148 / seconds
Query Executed:select id FROM `wv` where city='Exchange' && SIC_code='7011'DB:business_master_new
loadtime:0.33698511123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairdale' limit 1
loadtime:0.33705997467041 / seconds
Query Executed:select id FROM `wv` where city='Fairdale' && SIC_code='7011'DB:business_master_new
loadtime:0.33769202232361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlea' limit 1
loadtime:0.33775305747986 / seconds
Query Executed:select id FROM `wv` where city='Fairlea' && SIC_code='7011'DB:business_master_new
loadtime:0.33850502967834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairmont' limit 1
loadtime:0.33856797218323 / seconds
Query Executed:select id FROM `wv` where city='Fairmont' && SIC_code='7011'DB:business_master_new
loadtime:0.34500908851624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.34510207176208 / seconds
Query Executed:select id FROM `wv` where city='Fairview' && SIC_code='7011'DB:business_master_new
loadtime:0.34676313400269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falling Rock' limit 1
loadtime:0.3468279838562 / seconds
Query Executed:select id FROM `wv` where city='Falling Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.3472900390625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falling Waters' limit 1
loadtime:0.34735202789307 / seconds
Query Executed:select id FROM `wv` where city='Falling Waters' && SIC_code='7011'DB:business_master_new
loadtime:0.34966111183167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fanrock' limit 1
loadtime:0.34974503517151 / seconds
Query Executed:select id FROM `wv` where city='Fanrock' && SIC_code='7011'DB:business_master_new
loadtime:0.35027098655701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.35033416748047 / seconds
Query Executed:select id FROM `wv` where city='Farmington' && SIC_code='7011'DB:business_master_new
loadtime:0.35135197639465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayetteville' limit 1
loadtime:0.35142207145691 / seconds
Query Executed:select id FROM `wv` where city='Fayetteville' && SIC_code='7011'DB:business_master_new
loadtime:0.3552451133728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwick' limit 1
loadtime:0.35533404350281 / seconds
Query Executed:select id FROM `wv` where city='Fenwick' && SIC_code='7011'DB:business_master_new
loadtime:0.35595202445984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrellsburg' limit 1
loadtime:0.35601902008057 / seconds
Query Executed:select id FROM `wv` where city='Ferrellsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.3564989566803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fisher' limit 1
loadtime:0.35656118392944 / seconds
Query Executed:select id FROM `wv` where city='Fisher' && SIC_code='7011'DB:business_master_new
loadtime:0.35717916488647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Top' limit 1
loadtime:0.35725712776184 / seconds
Query Executed:select id FROM `wv` where city='Flat Top' && SIC_code='7011'DB:business_master_new
loadtime:0.35795402526855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flatwoods' limit 1
loadtime:0.35804605484009 / seconds
Query Executed:select id FROM `wv` where city='Flatwoods' && SIC_code='7011'DB:business_master_new
loadtime:0.35871195793152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flemington' limit 1
loadtime:0.35877513885498 / seconds
Query Executed:select id FROM `wv` where city='Flemington' && SIC_code='7011'DB:business_master_new
loadtime:0.35951018333435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Follansbee' limit 1
loadtime:0.35957098007202 / seconds
Query Executed:select id FROM `wv` where city='Follansbee' && SIC_code='7011'DB:business_master_new
loadtime:0.36264514923096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Folsom' limit 1
loadtime:0.36270713806152 / seconds
Query Executed:select id FROM `wv` where city='Folsom' && SIC_code='7011'DB:business_master_new
loadtime:0.36324715614319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Hill' limit 1
loadtime:0.36330795288086 / seconds
Query Executed:select id FROM `wv` where city='Forest Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.36392307281494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Ashby' limit 1
loadtime:0.36398601531982 / seconds
Query Executed:select id FROM `wv` where city='Fort Ashby' && SIC_code='7011'DB:business_master_new
loadtime:0.36533498764038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Gay' limit 1
loadtime:0.36539697647095 / seconds
Query Executed:select id FROM `wv` where city='Fort Gay' && SIC_code='7011'DB:business_master_new
loadtime:0.3666250705719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Spring' limit 1
loadtime:0.36668610572815 / seconds
Query Executed:select id FROM `wv` where city='Fort Spring' && SIC_code='7011'DB:business_master_new
loadtime:0.36718201637268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:0.36724305152893 / seconds
Query Executed:select id FROM `wv` where city='Foster' && SIC_code='7011'DB:business_master_new
loadtime:0.36777901649475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Four States' limit 1
loadtime:0.36783909797668 / seconds
Query Executed:select id FROM `wv` where city='Four States' && SIC_code='7011'DB:business_master_new
loadtime:0.36834001541138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frametown' limit 1
loadtime:0.36840009689331 / seconds
Query Executed:select id FROM `wv` where city='Frametown' && SIC_code='7011'DB:business_master_new
loadtime:0.36902117729187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankford' limit 1
loadtime:0.36908197402954 / seconds
Query Executed:select id FROM `wv` where city='Frankford' && SIC_code='7011'DB:business_master_new
loadtime:0.3699951171875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.37006115913391 / seconds
Query Executed:select id FROM `wv` where city='Franklin' && SIC_code='7011'DB:business_master_new
loadtime:0.37293910980225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraziers Bottom' limit 1
loadtime:0.37303304672241 / seconds
Query Executed:select id FROM `wv` where city='Fraziers Bottom' && SIC_code='7011'DB:business_master_new
loadtime:0.37380218505859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.37386512756348 / seconds
Query Executed:select id FROM `wv` where city='Freeman' && SIC_code='7011'DB:business_master_new
loadtime:0.37437295913696 / seconds
Query loaded from cache:select * from geodata_geocity where city='French Creek' limit 1
loadtime:0.37443399429321 / seconds
Query Executed:select id FROM `wv` where city='French Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.3753080368042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frenchton' limit 1
loadtime:0.37538695335388 / seconds
Query Executed:select id FROM `wv` where city='Frenchton' && SIC_code='7011'DB:business_master_new
loadtime:0.37585401535034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friendly' limit 1
loadtime:0.37591600418091 / seconds
Query Executed:select id FROM `wv` where city='Friendly' && SIC_code='7011'DB:business_master_new
loadtime:0.37669801712036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallagher' limit 1
loadtime:0.37675905227661 / seconds
Query Executed:select id FROM `wv` where city='Gallagher' && SIC_code='7011'DB:business_master_new
loadtime:0.37728309631348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallipolis Ferry' limit 1
loadtime:0.377357006073 / seconds
Query Executed:select id FROM `wv` where city='Gallipolis Ferry' && SIC_code='7011'DB:business_master_new
loadtime:0.37812113761902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galloway' limit 1
loadtime:0.37819409370422 / seconds
Query Executed:select id FROM `wv` where city='Galloway' && SIC_code='7011'DB:business_master_new
loadtime:0.37865209579468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gandeeville' limit 1
loadtime:0.37871813774109 / seconds
Query Executed:select id FROM `wv` where city='Gandeeville' && SIC_code='7011'DB:business_master_new
loadtime:0.37932109832764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gap Mills' limit 1
loadtime:0.37939500808716 / seconds
Query Executed:select id FROM `wv` where city='Gap Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.38017010688782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gary' limit 1
loadtime:0.38023996353149 / seconds
Query Executed:select id FROM `wv` where city='Gary' && SIC_code='7011'DB:business_master_new
loadtime:0.38102602958679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gassaway' limit 1
loadtime:0.38109111785889 / seconds
Query Executed:select id FROM `wv` where city='Gassaway' && SIC_code='7011'DB:business_master_new
loadtime:0.38364005088806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gauley Bridge' limit 1
loadtime:0.38370203971863 / seconds
Query Executed:select id FROM `wv` where city='Gauley Bridge' && SIC_code='7011'DB:business_master_new
loadtime:0.38471817970276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay' limit 1
loadtime:0.3847930431366 / seconds
Query Executed:select id FROM `wv` where city='Gay' && SIC_code='7011'DB:business_master_new
loadtime:0.38526511192322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa' limit 1
loadtime:0.38532996177673 / seconds
Query Executed:select id FROM `wv` where city='Genoa' && SIC_code='7011'DB:business_master_new
loadtime:0.38589215278625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gerrardstown' limit 1
loadtime:0.38595294952393 / seconds
Query Executed:select id FROM `wv` where city='Gerrardstown' && SIC_code='7011'DB:business_master_new
loadtime:0.38680195808411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ghent' limit 1
loadtime:0.3868670463562 / seconds
Query Executed:select id FROM `wv` where city='Ghent' && SIC_code='7011'DB:business_master_new
loadtime:0.38768911361694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.38776803016663 / seconds
Query Executed:select id FROM `wv` where city='Gilbert' && SIC_code='7011'DB:business_master_new
loadtime:0.39033102989197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilboa' limit 1
loadtime:0.39041614532471 / seconds
Query Executed:select id FROM `wv` where city='Gilboa' && SIC_code='7011'DB:business_master_new
loadtime:0.39091515541077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Given' limit 1
loadtime:0.39097595214844 / seconds
Query Executed:select id FROM `wv` where city='Given' && SIC_code='7011'DB:business_master_new
loadtime:0.39157795906067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glace' limit 1
loadtime:0.3916380405426 / seconds
Query Executed:select id FROM `wv` where city='Glace' && SIC_code='7011'DB:business_master_new
loadtime:0.39209699630737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glady' limit 1
loadtime:0.39216899871826 / seconds
Query Executed:select id FROM `wv` where city='Glady' && SIC_code='7011'DB:business_master_new
loadtime:0.39264011383057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:0.39270114898682 / seconds
Query Executed:select id FROM `wv` where city='Glasgow' && SIC_code='7011'DB:business_master_new
loadtime:0.3935010433197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.39356207847595 / seconds
Query Executed:select id FROM `wv` where city='Glen' && SIC_code='7011'DB:business_master_new
loadtime:0.39399409294128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Dale' limit 1
loadtime:0.39405512809753 / seconds
Query Executed:select id FROM `wv` where city='Glen Dale' && SIC_code='7011'DB:business_master_new
loadtime:0.39619016647339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Daniel' limit 1
loadtime:0.39627504348755 / seconds
Query Executed:select id FROM `wv` where city='Glen Daniel' && SIC_code='7011'DB:business_master_new
loadtime:0.39725613594055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Easton' limit 1
loadtime:0.39731812477112 / seconds
Query Executed:select id FROM `wv` where city='Glen Easton' && SIC_code='7011'DB:business_master_new
loadtime:0.39787817001343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Ferris' limit 1
loadtime:0.39793801307678 / seconds
Query Executed:select id FROM `wv` where city='Glen Ferris' && SIC_code='7011'DB:business_master_new
loadtime:0.39842295646667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Fork' limit 1
loadtime:0.39849996566772 / seconds
Query Executed:select id FROM `wv` where city='Glen Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.39905309677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Jean' limit 1
loadtime:0.39912009239197 / seconds
Query Executed:select id FROM `wv` where city='Glen Jean' && SIC_code='7011'DB:business_master_new
loadtime:0.39972710609436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Morgan' limit 1
loadtime:0.39978694915771 / seconds
Query Executed:select id FROM `wv` where city='Glen Morgan' && SIC_code='7011'DB:business_master_new
loadtime:0.40031003952026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Rogers' limit 1
loadtime:0.40037107467651 / seconds
Query Executed:select id FROM `wv` where city='Glen Rogers' && SIC_code='7011'DB:business_master_new
loadtime:0.40082716941833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen White' limit 1
loadtime:0.4008891582489 / seconds
Query Executed:select id FROM `wv` where city='Glen White' && SIC_code='7011'DB:business_master_new
loadtime:0.4014630317688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glengary' limit 1
loadtime:0.40152406692505 / seconds
Query Executed:select id FROM `wv` where city='Glengary' && SIC_code='7011'DB:business_master_new
loadtime:0.40205717086792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenville' limit 1
loadtime:0.40211701393127 / seconds
Query Executed:select id FROM `wv` where city='Glenville' && SIC_code='7011'DB:business_master_new
loadtime:0.40518712997437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.40527296066284 / seconds
Query Executed:select id FROM `wv` where city='Glenwood' && SIC_code='7011'DB:business_master_new
loadtime:0.40589118003845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordon' limit 1
loadtime:0.40595698356628 / seconds
Query Executed:select id FROM `wv` where city='Gordon' && SIC_code='7011'DB:business_master_new
loadtime:0.4065101146698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gormania' limit 1
loadtime:0.40657114982605 / seconds
Query Executed:select id FROM `wv` where city='Gormania' && SIC_code='7011'DB:business_master_new
loadtime:0.4070999622345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.40717315673828 / seconds
Query Executed:select id FROM `wv` where city='Grafton' && SIC_code='7011'DB:business_master_new
loadtime:0.41180205345154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant Town' limit 1
loadtime:0.41188097000122 / seconds
Query Executed:select id FROM `wv` where city='Grant Town' && SIC_code='7011'DB:business_master_new
loadtime:0.41243600845337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsville' limit 1
loadtime:0.41249799728394 / seconds
Query Executed:select id FROM `wv` where city='Grantsville' && SIC_code='7011'DB:business_master_new
loadtime:0.41491603851318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.41497707366943 / seconds
Query Executed:select id FROM `wv` where city='Granville' && SIC_code='7011'DB:business_master_new
loadtime:0.41566705703735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grassy Meadows' limit 1
loadtime:0.4157280921936 / seconds
Query Executed:select id FROM `wv` where city='Grassy Meadows' && SIC_code='7011'DB:business_master_new
loadtime:0.41617202758789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Cacapon' limit 1
loadtime:0.41623306274414 / seconds
Query Executed:select id FROM `wv` where city='Great Cacapon' && SIC_code='7011'DB:business_master_new
loadtime:0.41687417030334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bank' limit 1
loadtime:0.41695308685303 / seconds
Query Executed:select id FROM `wv` where city='Green Bank' && SIC_code='7011'DB:business_master_new
loadtime:0.41768407821655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Slphr Spgs' limit 1
loadtime:0.41775918006897 / seconds
Query Executed:select id FROM `wv` where city='Green Slphr Spgs' && SIC_code='7011'DB:business_master_new
loadtime:0.41821503639221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Spring' limit 1
loadtime:0.41827607154846 / seconds
Query Executed:select id FROM `wv` where city='Green Spring' && SIC_code='7011'DB:business_master_new
loadtime:0.41883015632629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Sulphur Springs' limit 1
loadtime:0.41889095306396 / seconds
Query Executed:select id FROM `wv` where city='Green Sulphur Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.41941595077515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:0.41949105262756 / seconds
Query Executed:select id FROM `wv` where city='Green Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.4200119972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.42008113861084 / seconds
Query Executed:select id FROM `wv` where city='Greenville' && SIC_code='7011'DB:business_master_new
loadtime:0.4207329750061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.4208071231842 / seconds
Query Executed:select id FROM `wv` where city='Greenwood' && SIC_code='7011'DB:business_master_new
loadtime:0.42137002944946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Griffithsville' limit 1
loadtime:0.42145204544067 / seconds
Query Executed:select id FROM `wv` where city='Griffithsville' && SIC_code='7011'DB:business_master_new
loadtime:0.42212104797363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gypsy' limit 1
loadtime:0.42219710350037 / seconds
Query Executed:select id FROM `wv` where city='Gypsy' && SIC_code='7011'DB:business_master_new
loadtime:0.42264318466187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacker Valley' limit 1
loadtime:0.42270517349243 / seconds
Query Executed:select id FROM `wv` where city='Hacker Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.4233500957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halltown' limit 1
loadtime:0.42341613769531 / seconds
Query Executed:select id FROM `wv` where city='Halltown' && SIC_code='7011'DB:business_master_new
loadtime:0.42395401000977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hambleton' limit 1
loadtime:0.42402410507202 / seconds
Query Executed:select id FROM `wv` where city='Hambleton' && SIC_code='7011'DB:business_master_new
loadtime:0.42457318305969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlin' limit 1
loadtime:0.42464017868042 / seconds
Query Executed:select id FROM `wv` where city='Hamlin' && SIC_code='7011'DB:business_master_new
loadtime:0.42720508575439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:0.42726802825928 / seconds
Query Executed:select id FROM `wv` where city='Hampden' && SIC_code='7011'DB:business_master_new
loadtime:0.42770504951477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Handley' limit 1
loadtime:0.42776608467102 / seconds
Query Executed:select id FROM `wv` where city='Handley' && SIC_code='7011'DB:business_master_new
loadtime:0.428307056427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.42838215827942 / seconds
Query Executed:select id FROM `wv` where city='Hanover' && SIC_code='7011'DB:business_master_new
loadtime:0.42906618118286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hansford' limit 1
loadtime:0.42912817001343 / seconds
Query Executed:select id FROM `wv` where city='Hansford' && SIC_code='7011'DB:business_master_new
loadtime:0.42970013618469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:0.42975997924805 / seconds
Query Executed:select id FROM `wv` where city='Harman' && SIC_code='7011'DB:business_master_new
loadtime:0.43050909042358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:0.43057703971863 / seconds
Query Executed:select id FROM `wv` where city='Harper' && SIC_code='7011'DB:business_master_new
loadtime:0.43116402626038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harpers Ferry' limit 1
loadtime:0.43122506141663 / seconds
Query Executed:select id FROM `wv` where city='Harpers Ferry' && SIC_code='7011'DB:business_master_new
loadtime:0.43480801582336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.43489718437195 / seconds
Query Executed:select id FROM `wv` where city='Harrisville' && SIC_code='7011'DB:business_master_new
loadtime:0.43723511695862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.43731808662415 / seconds
Query Executed:select id FROM `wv` where city='Hartford' && SIC_code='7011'DB:business_master_new
loadtime:0.43783903121948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harts' limit 1
loadtime:0.43790102005005 / seconds
Query Executed:select id FROM `wv` where city='Harts' && SIC_code='7011'DB:business_master_new
loadtime:0.43891501426697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:0.43897604942322 / seconds
Query Executed:select id FROM `wv` where city='Haywood' && SIC_code='7011'DB:business_master_new
loadtime:0.43948912620544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelton' limit 1
loadtime:0.43955016136169 / seconds
Query Executed:select id FROM `wv` where city='Hazelton' && SIC_code='7011'DB:business_master_new
loadtime:0.44004511833191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heaters' limit 1
loadtime:0.44011116027832 / seconds
Query Executed:select id FROM `wv` where city='Heaters' && SIC_code='7011'DB:business_master_new
loadtime:0.44065308570862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hedgesville' limit 1
loadtime:0.44071412086487 / seconds
Query Executed:select id FROM `wv` where city='Hedgesville' && SIC_code='7011'DB:business_master_new
loadtime:0.44434905052185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helen' limit 1
loadtime:0.44443106651306 / seconds
Query Executed:select id FROM `wv` where city='Helen' && SIC_code='7011'DB:business_master_new
loadtime:0.44489312171936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helvetia' limit 1
loadtime:0.44495606422424 / seconds
Query Executed:select id FROM `wv` where city='Helvetia' && SIC_code='7011'DB:business_master_new
loadtime:0.44547510147095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemphill' limit 1
loadtime:0.44555807113647 / seconds
Query Executed:select id FROM `wv` where city='Hemphill' && SIC_code='7011'DB:business_master_new
loadtime:0.44600200653076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.44606399536133 / seconds
Query Executed:select id FROM `wv` where city='Henderson' && SIC_code='7011'DB:business_master_new
loadtime:0.44678115844727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hendricks' limit 1
loadtime:0.44684100151062 / seconds
Query Executed:select id FROM `wv` where city='Hendricks' && SIC_code='7011'DB:business_master_new
loadtime:0.44738006591797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henlawson' limit 1
loadtime:0.44744110107422 / seconds
Query Executed:select id FROM `wv` where city='Henlawson' && SIC_code='7011'DB:business_master_new
loadtime:0.44796800613403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hensley' limit 1
loadtime:0.44803810119629 / seconds
Query Executed:select id FROM `wv` where city='Hensley' && SIC_code='7011'DB:business_master_new
loadtime:0.44850015640259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hepzibah' limit 1
loadtime:0.44856095314026 / seconds
Query Executed:select id FROM `wv` where city='Hepzibah' && SIC_code='7011'DB:business_master_new
loadtime:0.44916009902954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:0.44922113418579 / seconds
Query Executed:select id FROM `wv` where city='Herndon' && SIC_code='7011'DB:business_master_new
loadtime:0.44977807998657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernshaw' limit 1
loadtime:0.44983911514282 / seconds
Query Executed:select id FROM `wv` where city='Hernshaw' && SIC_code='7011'DB:business_master_new
loadtime:0.45045614242554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hewett' limit 1
loadtime:0.45051717758179 / seconds
Query Executed:select id FROM `wv` where city='Hewett' && SIC_code='7011'DB:business_master_new
loadtime:0.45104217529297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hico' limit 1
loadtime:0.4511079788208 / seconds
Query Executed:select id FROM `wv` where city='Hico' && SIC_code='7011'DB:business_master_new
loadtime:0.45206499099731 / seconds
Query loaded from cache:select * from geodata_geocity where city='High View' limit 1
loadtime:0.45215606689453 / seconds
Query Executed:select id FROM `wv` where city='High View' && SIC_code='7011'DB:business_master_new
loadtime:0.45271515846252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.45278096199036 / seconds
Query Executed:select id FROM `wv` where city='Hillsboro' && SIC_code='7011'DB:business_master_new
loadtime:0.45372414588928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilltop' limit 1
loadtime:0.4538049697876 / seconds
Query Executed:select id FROM `wv` where city='Hilltop' && SIC_code='7011'DB:business_master_new
loadtime:0.45438313484192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hines' limit 1
loadtime:0.45444416999817 / seconds
Query Executed:select id FROM `wv` where city='Hines' && SIC_code='7011'DB:business_master_new
loadtime:0.45492696762085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:0.45499205589294 / seconds
Query Executed:select id FROM `wv` where city='Hinton' && SIC_code='7011'DB:business_master_new
loadtime:0.45889496803284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:0.45897817611694 / seconds
Query Executed:select id FROM `wv` where city='Holden' && SIC_code='7011'DB:business_master_new
loadtime:0.45992398262024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hometown' limit 1
loadtime:0.45999002456665 / seconds
Query Executed:select id FROM `wv` where city='Hometown' && SIC_code='7011'DB:business_master_new
loadtime:0.46050596237183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horner' limit 1
loadtime:0.46056699752808 / seconds
Query Executed:select id FROM `wv` where city='Horner' && SIC_code='7011'DB:business_master_new
loadtime:0.46121406555176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horse Shoe Run' limit 1
loadtime:0.46127510070801 / seconds
Query Executed:select id FROM `wv` where city='Horse Shoe Run' && SIC_code='7011'DB:business_master_new
loadtime:0.46175003051758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hugheston' limit 1
loadtime:0.46181106567383 / seconds
Query Executed:select id FROM `wv` where city='Hugheston' && SIC_code='7011'DB:business_master_new
loadtime:0.46235704421997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hundred' limit 1
loadtime:0.46242308616638 / seconds
Query Executed:select id FROM `wv` where city='Hundred' && SIC_code='7011'DB:business_master_new
loadtime:0.46348810195923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.46355295181274 / seconds
Query Executed:select id FROM `wv` where city='Huntington' && SIC_code='7011'DB:business_master_new
loadtime:0.47006511688232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurricane' limit 1
loadtime:0.4701771736145 / seconds
Query Executed:select id FROM `wv` where city='Hurricane' && SIC_code='7011'DB:business_master_new
loadtime:0.47995710372925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huttonsville' limit 1
loadtime:0.48005509376526 / seconds
Query Executed:select id FROM `wv` where city='Huttonsville' && SIC_code='7011'DB:business_master_new
loadtime:0.48074412345886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iaeger' limit 1
loadtime:0.48082518577576 / seconds
Query Executed:select id FROM `wv` where city='Iaeger' && SIC_code='7011'DB:business_master_new
loadtime:0.48205208778381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idamay' limit 1
loadtime:0.48212099075317 / seconds
Query Executed:select id FROM `wv` where city='Idamay' && SIC_code='7011'DB:business_master_new
loadtime:0.48265409469604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ikes Fork' limit 1
loadtime:0.48271608352661 / seconds
Query Executed:select id FROM `wv` where city='Ikes Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.48332905769348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.48339009284973 / seconds
Query Executed:select id FROM `wv` where city='Independence' && SIC_code='7011'DB:business_master_new
loadtime:0.48394203186035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indore' limit 1
loadtime:0.48400902748108 / seconds
Query Executed:select id FROM `wv` where city='Indore' && SIC_code='7011'DB:business_master_new
loadtime:0.48452997207642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Industrial' limit 1
loadtime:0.48459100723267 / seconds
Query Executed:select id FROM `wv` where city='Industrial' && SIC_code='7011'DB:business_master_new
loadtime:0.48502111434937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Institute' limit 1
loadtime:0.48508310317993 / seconds
Query Executed:select id FROM `wv` where city='Institute' && SIC_code='7011'DB:business_master_new
loadtime:0.48593306541443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inwood' limit 1
loadtime:0.48600006103516 / seconds
Query Executed:select id FROM `wv` where city='Inwood' && SIC_code='7011'DB:business_master_new
loadtime:0.48935103416443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ireland' limit 1
loadtime:0.48941397666931 / seconds
Query Executed:select id FROM `wv` where city='Ireland' && SIC_code='7011'DB:business_master_new
loadtime:0.48996806144714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isaban' limit 1
loadtime:0.49003314971924 / seconds
Query Executed:select id FROM `wv` where city='Isaban' && SIC_code='7011'DB:business_master_new
loadtime:0.49053907394409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Itmann' limit 1
loadtime:0.49060010910034 / seconds
Query Executed:select id FROM `wv` where city='Itmann' && SIC_code='7011'DB:business_master_new
loadtime:0.49106907844543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivydale' limit 1
loadtime:0.49113011360168 / seconds
Query Executed:select id FROM `wv` where city='Ivydale' && SIC_code='7011'DB:business_master_new
loadtime:0.49175310134888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonburg' limit 1
loadtime:0.49181413650513 / seconds
Query Executed:select id FROM `wv` where city='Jacksonburg' && SIC_code='7011'DB:business_master_new
loadtime:0.49233198165894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jane Lew' limit 1
loadtime:0.49239802360535 / seconds
Query Executed:select id FROM `wv` where city='Jane Lew' && SIC_code='7011'DB:business_master_new
loadtime:0.49459195137024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffrey' limit 1
loadtime:0.49466705322266 / seconds
Query Executed:select id FROM `wv` where city='Jeffrey' && SIC_code='7011'DB:business_master_new
loadtime:0.49521207809448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkinjones' limit 1
loadtime:0.49527406692505 / seconds
Query Executed:select id FROM `wv` where city='Jenkinjones' && SIC_code='7011'DB:business_master_new
loadtime:0.4956750869751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jesse' limit 1
loadtime:0.49573612213135 / seconds
Query Executed:select id FROM `wv` where city='Jesse' && SIC_code='7011'DB:business_master_new
loadtime:0.4962329864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jodie' limit 1
loadtime:0.49629497528076 / seconds
Query Executed:select id FROM `wv` where city='Jodie' && SIC_code='7011'DB:business_master_new
loadtime:0.4967200756073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jolo' limit 1
loadtime:0.49678015708923 / seconds
Query Executed:select id FROM `wv` where city='Jolo' && SIC_code='7011'DB:business_master_new
loadtime:0.49732899665833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonben' limit 1
loadtime:0.49739098548889 / seconds
Query Executed:select id FROM `wv` where city='Jonben' && SIC_code='7011'DB:business_master_new
loadtime:0.49779105186462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Josephine' limit 1
loadtime:0.49785804748535 / seconds
Query Executed:select id FROM `wv` where city='Josephine' && SIC_code='7011'DB:business_master_new
loadtime:0.49829912185669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julian' limit 1
loadtime:0.49836397171021 / seconds
Query Executed:select id FROM `wv` where city='Julian' && SIC_code='7011'DB:business_master_new
loadtime:0.4989550113678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jumping Branch' limit 1
loadtime:0.49902105331421 / seconds
Query Executed:select id FROM `wv` where city='Jumping Branch' && SIC_code='7011'DB:business_master_new
loadtime:0.49962306022644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction' limit 1
loadtime:0.49968695640564 / seconds
Query Executed:select id FROM `wv` where city='Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.50013709068298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junior' limit 1
loadtime:0.50021004676819 / seconds
Query Executed:select id FROM `wv` where city='Junior' && SIC_code='7011'DB:business_master_new
loadtime:0.50072312355042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Justice' limit 1
loadtime:0.50078511238098 / seconds
Query Executed:select id FROM `wv` where city='Justice' && SIC_code='7011'DB:business_master_new
loadtime:0.50147294998169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanawha Falls' limit 1
loadtime:0.5015549659729 / seconds
Query Executed:select id FROM `wv` where city='Kanawha Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.50200295448303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanawha Head' limit 1
loadtime:0.50206995010376 / seconds
Query Executed:select id FROM `wv` where city='Kanawha Head' && SIC_code='7011'DB:business_master_new
loadtime:0.50255012512207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearneysville' limit 1
loadtime:0.50261616706848 / seconds
Query Executed:select id FROM `wv` where city='Kearneysville' && SIC_code='7011'DB:business_master_new
loadtime:0.50555205345154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kegley' limit 1
loadtime:0.5056140422821 / seconds
Query Executed:select id FROM `wv` where city='Kegley' && SIC_code='7011'DB:business_master_new
loadtime:0.50610518455505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellysville' limit 1
loadtime:0.50617718696594 / seconds
Query Executed:select id FROM `wv` where city='Kellysville' && SIC_code='7011'DB:business_master_new
loadtime:0.50662016868591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenna' limit 1
loadtime:0.50668001174927 / seconds
Query Executed:select id FROM `wv` where city='Kenna' && SIC_code='7011'DB:business_master_new
loadtime:0.50763297080994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenova' limit 1
loadtime:0.50769305229187 / seconds
Query Executed:select id FROM `wv` where city='Kenova' && SIC_code='7011'DB:business_master_new
loadtime:0.51102709770203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kerens' limit 1
loadtime:0.51110911369324 / seconds
Query Executed:select id FROM `wv` where city='Kerens' && SIC_code='7011'DB:business_master_new
loadtime:0.51160097122192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kermit' limit 1
loadtime:0.51166200637817 / seconds
Query Executed:select id FROM `wv` where city='Kermit' && SIC_code='7011'DB:business_master_new
loadtime:0.51287913322449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keslers Cross Lanes' limit 1
loadtime:0.51293897628784 / seconds
Query Executed:select id FROM `wv` where city='Keslers Cross Lanes' && SIC_code='7011'DB:business_master_new
loadtime:0.51338696479797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keslers Crs Lns' limit 1
loadtime:0.51344704627991 / seconds
Query Executed:select id FROM `wv` where city='Keslers Crs Lns' && SIC_code='7011'DB:business_master_new
loadtime:0.51386308670044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keyser' limit 1
loadtime:0.51392817497253 / seconds
Query Executed:select id FROM `wv` where city='Keyser' && SIC_code='7011'DB:business_master_new
loadtime:0.52035617828369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.52043509483337 / seconds
Query Executed:select id FROM `wv` where city='Keystone' && SIC_code='7011'DB:business_master_new
loadtime:0.52094006538391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiahsville' limit 1
loadtime:0.52100706100464 / seconds
Query Executed:select id FROM `wv` where city='Kiahsville' && SIC_code='7011'DB:business_master_new
loadtime:0.52146697044373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilsyth' limit 1
loadtime:0.52152705192566 / seconds
Query Executed:select id FROM `wv` where city='Kilsyth' && SIC_code='7011'DB:business_master_new
loadtime:0.52196907997131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:0.52203297615051 / seconds
Query Executed:select id FROM `wv` where city='Kimball' && SIC_code='7011'DB:business_master_new
loadtime:0.52273201942444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimberly' limit 1
loadtime:0.5228111743927 / seconds
Query Executed:select id FROM `wv` where city='Kimberly' && SIC_code='7011'DB:business_master_new
loadtime:0.52339816093445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kincaid' limit 1
loadtime:0.52346014976501 / seconds
Query Executed:select id FROM `wv` where city='Kincaid' && SIC_code='7011'DB:business_master_new
loadtime:0.52397704124451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingmont' limit 1
loadtime:0.52404117584229 / seconds
Query Executed:select id FROM `wv` where city='Kingmont' && SIC_code='7011'DB:business_master_new
loadtime:0.52456998825073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingwood' limit 1
loadtime:0.52463698387146 / seconds
Query Executed:select id FROM `wv` where city='Kingwood' && SIC_code='7011'DB:business_master_new
loadtime:0.529128074646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirby' limit 1
loadtime:0.52921795845032 / seconds
Query Executed:select id FROM `wv` where city='Kirby' && SIC_code='7011'DB:business_master_new
loadtime:0.5296790599823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kistler' limit 1
loadtime:0.52974104881287 / seconds
Query Executed:select id FROM `wv` where city='Kistler' && SIC_code='7011'DB:business_master_new
loadtime:0.53038716316223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kopperston' limit 1
loadtime:0.5304479598999 / seconds
Query Executed:select id FROM `wv` where city='Kopperston' && SIC_code='7011'DB:business_master_new
loadtime:0.53096318244934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kyle' limit 1
loadtime:0.53103303909302 / seconds
Query Executed:select id FROM `wv` where city='Kyle' && SIC_code='7011'DB:business_master_new
loadtime:0.53153109550476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lahmansville' limit 1
loadtime:0.53159213066101 / seconds
Query Executed:select id FROM `wv` where city='Lahmansville' && SIC_code='7011'DB:business_master_new
loadtime:0.53203797340393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:0.53209805488586 / seconds
Query Executed:select id FROM `wv` where city='Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.53265595436096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakin' limit 1
loadtime:0.5327160358429 / seconds
Query Executed:select id FROM `wv` where city='Lakin' && SIC_code='7011'DB:business_master_new
loadtime:0.53313803672791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanark' limit 1
loadtime:0.53321003913879 / seconds
Query Executed:select id FROM `wv` where city='Lanark' && SIC_code='7011'DB:business_master_new
loadtime:0.5336480140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:0.53370904922485 / seconds
Query Executed:select id FROM `wv` where city='Lansing' && SIC_code='7011'DB:business_master_new
loadtime:0.53437995910645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lashmeet' limit 1
loadtime:0.53446197509766 / seconds
Query Executed:select id FROM `wv` where city='Lashmeet' && SIC_code='7011'DB:business_master_new
loadtime:0.5350501537323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lavalette' limit 1
loadtime:0.53511309623718 / seconds
Query Executed:select id FROM `wv` where city='Lavalette' && SIC_code='7011'DB:business_master_new
loadtime:0.53725814819336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layland' limit 1
loadtime:0.53732013702393 / seconds
Query Executed:select id FROM `wv` where city='Layland' && SIC_code='7011'DB:business_master_new
loadtime:0.53775405883789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Roy' limit 1
loadtime:0.53781509399414 / seconds
Query Executed:select id FROM `wv` where city='Le Roy' && SIC_code='7011'DB:business_master_new
loadtime:0.53837013244629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leckie' limit 1
loadtime:0.53843116760254 / seconds
Query Executed:select id FROM `wv` where city='Leckie' && SIC_code='7011'DB:business_master_new
loadtime:0.53883504867554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Left Hand' limit 1
loadtime:0.53889417648315 / seconds
Query Executed:select id FROM `wv` where city='Left Hand' && SIC_code='7011'DB:business_master_new
loadtime:0.53938317298889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehew' limit 1
loadtime:0.53944396972656 / seconds
Query Executed:select id FROM `wv` where city='Lehew' && SIC_code='7011'DB:business_master_new
loadtime:0.53987002372742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leivasy' limit 1
loadtime:0.53993105888367 / seconds
Query Executed:select id FROM `wv` where city='Leivasy' && SIC_code='7011'DB:business_master_new
loadtime:0.54048609733582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenore' limit 1
loadtime:0.54055213928223 / seconds
Query Executed:select id FROM `wv` where city='Lenore' && SIC_code='7011'DB:business_master_new
loadtime:0.5412859916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:0.54134702682495 / seconds
Query Executed:select id FROM `wv` where city='Leon' && SIC_code='7011'DB:business_master_new
loadtime:0.54208517074585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lerona' limit 1
loadtime:0.54215598106384 / seconds
Query Executed:select id FROM `wv` where city='Lerona' && SIC_code='7011'DB:business_master_new
loadtime:0.54279017448425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lesage' limit 1
loadtime:0.54285717010498 / seconds
Query Executed:select id FROM `wv` where city='Lesage' && SIC_code='7011'DB:business_master_new
loadtime:0.5438129901886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leslie' limit 1
loadtime:0.54387807846069 / seconds
Query Executed:select id FROM `wv` where city='Leslie' && SIC_code='7011'DB:business_master_new
loadtime:0.54431104660034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lester' limit 1
loadtime:0.54437613487244 / seconds
Query Executed:select id FROM `wv` where city='Lester' && SIC_code='7011'DB:business_master_new
loadtime:0.54496097564697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letart' limit 1
loadtime:0.54502701759338 / seconds
Query Executed:select id FROM `wv` where city='Letart' && SIC_code='7011'DB:business_master_new
loadtime:0.54570007324219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letter Gap' limit 1
loadtime:0.5457661151886 / seconds
Query Executed:select id FROM `wv` where city='Letter Gap' && SIC_code='7011'DB:business_master_new
loadtime:0.54621696472168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levels' limit 1
loadtime:0.54627799987793 / seconds
Query Executed:select id FROM `wv` where city='Levels' && SIC_code='7011'DB:business_master_new
loadtime:0.54691910743713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewisburg' limit 1
loadtime:0.54698014259338 / seconds
Query Executed:select id FROM `wv` where city='Lewisburg' && SIC_code='7011'DB:business_master_new
loadtime:0.55572104454041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.55581998825073 / seconds
Query Executed:select id FROM `wv` where city='Liberty' && SIC_code='7011'DB:business_master_new
loadtime:0.55646300315857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindside' limit 1
loadtime:0.55652713775635 / seconds
Query Executed:select id FROM `wv` where city='Lindside' && SIC_code='7011'DB:business_master_new
loadtime:0.55731415748596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linn' limit 1
loadtime:0.55737996101379 / seconds
Query Executed:select id FROM `wv` where city='Linn' && SIC_code='7011'DB:business_master_new
loadtime:0.55788207054138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Birch' limit 1
loadtime:0.55794811248779 / seconds
Query Executed:select id FROM `wv` where city='Little Birch' && SIC_code='7011'DB:business_master_new
loadtime:0.55852198600769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.55858397483826 / seconds
Query Executed:select id FROM `wv` where city='Littleton' && SIC_code='7011'DB:business_master_new
loadtime:0.55911016464233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liverpool' limit 1
loadtime:0.55918598175049 / seconds
Query Executed:select id FROM `wv` where city='Liverpool' && SIC_code='7011'DB:business_master_new
loadtime:0.55962896347046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lizemores' limit 1
loadtime:0.55968904495239 / seconds
Query Executed:select id FROM `wv` where city='Lizemores' && SIC_code='7011'DB:business_master_new
loadtime:0.56029295921326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochgelly' limit 1
loadtime:0.56035399436951 / seconds
Query Executed:select id FROM `wv` where city='Lochgelly' && SIC_code='7011'DB:business_master_new
loadtime:0.56093001365662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockney' limit 1
loadtime:0.56099700927734 / seconds
Query Executed:select id FROM `wv` where city='Lockney' && SIC_code='7011'DB:business_master_new
loadtime:0.56146001815796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.56152105331421 / seconds
Query Executed:select id FROM `wv` where city='Logan' && SIC_code='7011'DB:business_master_new
loadtime:0.56795001029968 / seconds
Query loaded from cache:select * from geodata_geocity where city='London' limit 1
loadtime:0.56805300712585 / seconds
Query Executed:select id FROM `wv` where city='London' && SIC_code='7011'DB:business_master_new
loadtime:0.56860017776489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longacre' limit 1
loadtime:0.56866717338562 / seconds
Query Executed:select id FROM `wv` where city='Longacre' && SIC_code='7011'DB:business_master_new
loadtime:0.56916403770447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lookout' limit 1
loadtime:0.56922602653503 / seconds
Query Executed:select id FROM `wv` where city='Lookout' && SIC_code='7011'DB:business_master_new
loadtime:0.56984114646912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Looneyville' limit 1
loadtime:0.56992316246033 / seconds
Query Executed:select id FROM `wv` where city='Looneyville' && SIC_code='7011'DB:business_master_new
loadtime:0.57049918174744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorado' limit 1
loadtime:0.57056498527527 / seconds
Query Executed:select id FROM `wv` where city='Lorado' && SIC_code='7011'DB:business_master_new
loadtime:0.57104110717773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorentz' limit 1
loadtime:0.57110214233398 / seconds
Query Executed:select id FROM `wv` where city='Lorentz' && SIC_code='7011'DB:business_master_new
loadtime:0.57155418395996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost City' limit 1
loadtime:0.57161498069763 / seconds
Query Executed:select id FROM `wv` where city='Lost City' && SIC_code='7011'DB:business_master_new
loadtime:0.57223296165466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Creek' limit 1
loadtime:0.57231211662292 / seconds
Query Executed:select id FROM `wv` where city='Lost Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.57343196868896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost River' limit 1
loadtime:0.57349514961243 / seconds
Query Executed:select id FROM `wv` where city='Lost River' && SIC_code='7011'DB:business_master_new
loadtime:0.57400298118591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberport' limit 1
loadtime:0.57407808303833 / seconds
Query Executed:select id FROM `wv` where city='Lumberport' && SIC_code='7011'DB:business_master_new
loadtime:0.57492709159851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lundale' limit 1
loadtime:0.57499313354492 / seconds
Query Executed:select id FROM `wv` where city='Lundale' && SIC_code='7011'DB:business_master_new
loadtime:0.5754771232605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyburn' limit 1
loadtime:0.57553815841675 / seconds
Query Executed:select id FROM `wv` where city='Lyburn' && SIC_code='7011'DB:business_master_new
loadtime:0.57624411582947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynco' limit 1
loadtime:0.57630515098572 / seconds
Query Executed:select id FROM `wv` where city='Lynco' && SIC_code='7011'DB:business_master_new
loadtime:0.57679414749146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maben' limit 1
loadtime:0.57685518264771 / seconds
Query Executed:select id FROM `wv` where city='Maben' && SIC_code='7011'DB:business_master_new
loadtime:0.57733917236328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mabie' limit 1
loadtime:0.57739996910095 / seconds
Query Executed:select id FROM `wv` where city='Mabie' && SIC_code='7011'DB:business_master_new
loadtime:0.57784914970398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mabscott' limit 1
loadtime:0.57790899276733 / seconds
Query Executed:select id FROM `wv` where city='Mabscott' && SIC_code='7011'DB:business_master_new
loadtime:0.57866907119751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mac Arthur' limit 1
loadtime:0.57873010635376 / seconds
Query Executed:select id FROM `wv` where city='Mac Arthur' && SIC_code='7011'DB:business_master_new
loadtime:0.57949900627136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macfarlan' limit 1
loadtime:0.5795590877533 / seconds
Query Executed:select id FROM `wv` where city='Macfarlan' && SIC_code='7011'DB:business_master_new
loadtime:0.58003497123718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.58009600639343 / seconds
Query Executed:select id FROM `wv` where city='Madison' && SIC_code='7011'DB:business_master_new
loadtime:0.58267998695374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidsville' limit 1
loadtime:0.58276295661926 / seconds
Query Executed:select id FROM `wv` where city='Maidsville' && SIC_code='7011'DB:business_master_new
loadtime:0.58368301391602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:0.58374500274658 / seconds
Query Executed:select id FROM `wv` where city='Malden' && SIC_code='7011'DB:business_master_new
loadtime:0.58424401283264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mallory' limit 1
loadtime:0.58430504798889 / seconds
Query Executed:select id FROM `wv` where city='Mallory' && SIC_code='7011'DB:business_master_new
loadtime:0.58485507965088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1
loadtime:0.58491516113281 / seconds
Query Executed:select id FROM `wv` where city='Mammoth' && SIC_code='7011'DB:business_master_new
loadtime:0.58543610572815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Man' limit 1
loadtime:0.58550405502319 / seconds
Query Executed:select id FROM `wv` where city='Man' && SIC_code='7011'DB:business_master_new
loadtime:0.58760714530945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannington' limit 1
loadtime:0.58768701553345 / seconds
Query Executed:select id FROM `wv` where city='Mannington' && SIC_code='7011'DB:business_master_new
loadtime:0.59007406234741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplewood' limit 1
loadtime:0.59013700485229 / seconds
Query Executed:select id FROM `wv` where city='Maplewood' && SIC_code='7011'DB:business_master_new
loadtime:0.59060716629028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marianna' limit 1
loadtime:0.59066796302795 / seconds
Query Executed:select id FROM `wv` where city='Marianna' && SIC_code='7011'DB:business_master_new
loadtime:0.59112811088562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlinton' limit 1
loadtime:0.59120416641235 / seconds
Query Executed:select id FROM `wv` where city='Marlinton' && SIC_code='7011'DB:business_master_new
loadtime:0.5946249961853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marmet' limit 1
loadtime:0.59471416473389 / seconds
Query Executed:select id FROM `wv` where city='Marmet' && SIC_code='7011'DB:business_master_new
loadtime:0.59524512290955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsburg' limit 1
loadtime:0.59530806541443 / seconds
Query Executed:select id FROM `wv` where city='Martinsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.60186696052551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:0.60196399688721 / seconds
Query Executed:select id FROM `wv` where city='Mason' && SIC_code='7011'DB:business_master_new
loadtime:0.60326313972473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masontown' limit 1
loadtime:0.60334205627441 / seconds
Query Executed:select id FROM `wv` where city='Masontown' && SIC_code='7011'DB:business_master_new
loadtime:0.60440897941589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matewan' limit 1
loadtime:0.60447216033936 / seconds
Query Executed:select id FROM `wv` where city='Matewan' && SIC_code='7011'DB:business_master_new
loadtime:0.60555195808411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matheny' limit 1
loadtime:0.60562705993652 / seconds
Query Executed:select id FROM `wv` where city='Matheny' && SIC_code='7011'DB:business_master_new
loadtime:0.60627603530884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathias' limit 1
loadtime:0.60633707046509 / seconds
Query Executed:select id FROM `wv` where city='Mathias' && SIC_code='7011'DB:business_master_new
loadtime:0.6075119972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matoaka' limit 1
loadtime:0.60757303237915 / seconds
Query Executed:select id FROM `wv` where city='Matoaka' && SIC_code='7011'DB:business_master_new
loadtime:0.60825896263123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwelton' limit 1
loadtime:0.60831999778748 / seconds
Query Executed:select id FROM `wv` where city='Maxwelton' && SIC_code='7011'DB:business_master_new
loadtime:0.60890603065491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybeury' limit 1
loadtime:0.60896611213684 / seconds
Query Executed:select id FROM `wv` where city='Maybeury' && SIC_code='7011'DB:business_master_new
loadtime:0.60952997207642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maysel' limit 1
loadtime:0.60960006713867 / seconds
Query Executed:select id FROM `wv` where city='Maysel' && SIC_code='7011'DB:business_master_new
loadtime:0.61018896102905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maysville' limit 1
loadtime:0.6102499961853 / seconds
Query Executed:select id FROM `wv` where city='Maysville' && SIC_code='7011'DB:business_master_new
loadtime:0.61132502555847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Connell' limit 1
loadtime:0.61139011383057 / seconds
Query Executed:select id FROM `wv` where city='Mc Connell' && SIC_code='7011'DB:business_master_new
loadtime:0.61186218261719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Graws' limit 1
loadtime:0.61192297935486 / seconds
Query Executed:select id FROM `wv` where city='Mc Graws' && SIC_code='7011'DB:business_master_new
loadtime:0.61240696907043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Mechen' limit 1
loadtime:0.61246800422668 / seconds
Query Executed:select id FROM `wv` where city='Mc Mechen' && SIC_code='7011'DB:business_master_new
loadtime:0.61289000511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcmechen' limit 1
loadtime:0.61295008659363 / seconds
Query Executed:select id FROM `wv` where city='Mcmechen' && SIC_code='7011'DB:business_master_new
loadtime:0.61403918266296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meador' limit 1
loadtime:0.61410403251648 / seconds
Query Executed:select id FROM `wv` where city='Meador' && SIC_code='7011'DB:business_master_new
loadtime:0.61456799507141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow Bluff' limit 1
loadtime:0.61462807655334 / seconds
Query Executed:select id FROM `wv` where city='Meadow Bluff' && SIC_code='7011'DB:business_master_new
loadtime:0.61512804031372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow Bridge' limit 1
loadtime:0.61520099639893 / seconds
Query Executed:select id FROM `wv` where city='Meadow Bridge' && SIC_code='7011'DB:business_master_new
loadtime:0.61608695983887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow Creek' limit 1
loadtime:0.61617302894592 / seconds
Query Executed:select id FROM `wv` where city='Meadow Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.61659502983093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowbrook' limit 1
loadtime:0.61666917800903 / seconds
Query Executed:select id FROM `wv` where city='Meadowbrook' && SIC_code='7011'DB:business_master_new
loadtime:0.61722016334534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metz' limit 1
loadtime:0.6172821521759 / seconds
Query Executed:select id FROM `wv` where city='Metz' && SIC_code='7011'DB:business_master_new
loadtime:0.61777305603027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.61783409118652 / seconds
Query Executed:select id FROM `wv` where city='Miami' && SIC_code='7011'DB:business_master_new
loadtime:0.61832618713379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebourne' limit 1
loadtime:0.61838698387146 / seconds
Query Executed:select id FROM `wv` where city='Middlebourne' && SIC_code='7011'DB:business_master_new
loadtime:0.62021899223328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midkiff' limit 1
loadtime:0.62028098106384 / seconds
Query Executed:select id FROM `wv` where city='Midkiff' && SIC_code='7011'DB:business_master_new
loadtime:0.62080717086792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway' limit 1
loadtime:0.62086701393127 / seconds
Query Executed:select id FROM `wv` where city='Midway' && SIC_code='7011'DB:business_master_new
loadtime:0.62154102325439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milam' limit 1
loadtime:0.62160110473633 / seconds
Query Executed:select id FROM `wv` where city='Milam' && SIC_code='7011'DB:business_master_new
loadtime:0.6221010684967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill Creek' limit 1
loadtime:0.62217211723328 / seconds
Query Executed:select id FROM `wv` where city='Mill Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.62323212623596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill Point' limit 1
loadtime:0.62331199645996 / seconds
Query Executed:select id FROM `wv` where city='Mill Point' && SIC_code='7011'DB:business_master_new
loadtime:0.62376117706299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millstone' limit 1
loadtime:0.62382197380066 / seconds
Query Executed:select id FROM `wv` where city='Millstone' && SIC_code='7011'DB:business_master_new
loadtime:0.62434005737305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:0.6244010925293 / seconds
Query Executed:select id FROM `wv` where city='Millville' && SIC_code='7011'DB:business_master_new
loadtime:0.62489795684814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:0.62495899200439 / seconds
Query Executed:select id FROM `wv` where city='Millwood' && SIC_code='7011'DB:business_master_new
loadtime:0.62604999542236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.62611198425293 / seconds
Query Executed:select id FROM `wv` where city='Milton' && SIC_code='7011'DB:business_master_new
loadtime:0.62990403175354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden' limit 1
loadtime:0.62998700141907 / seconds
Query Executed:select id FROM `wv` where city='Minden' && SIC_code='7011'DB:business_master_new
loadtime:0.63048911094666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Wells' limit 1
loadtime:0.63055205345154 / seconds
Query Executed:select id FROM `wv` where city='Mineral Wells' && SIC_code='7011'DB:business_master_new
loadtime:0.63324403762817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineralwells' limit 1
loadtime:0.63333010673523 / seconds
Query Executed:select id FROM `wv` where city='Mineralwells' && SIC_code='7011'DB:business_master_new
loadtime:0.63376998901367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minnora' limit 1
loadtime:0.63383603096008 / seconds
Query Executed:select id FROM `wv` where city='Minnora' && SIC_code='7011'DB:business_master_new
loadtime:0.63430309295654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moatsville' limit 1
loadtime:0.63436317443848 / seconds
Query Executed:select id FROM `wv` where city='Moatsville' && SIC_code='7011'DB:business_master_new
loadtime:0.63495802879333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohawk' limit 1
loadtime:0.63502597808838 / seconds
Query Executed:select id FROM `wv` where city='Mohawk' && SIC_code='7011'DB:business_master_new
loadtime:0.63552403450012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monaville' limit 1
loadtime:0.63558506965637 / seconds
Query Executed:select id FROM `wv` where city='Monaville' && SIC_code='7011'DB:business_master_new
loadtime:0.63605904579163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monongah' limit 1
loadtime:0.63612103462219 / seconds
Query Executed:select id FROM `wv` where city='Monongah' && SIC_code='7011'DB:business_master_new
loadtime:0.63662099838257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montana Mines' limit 1
loadtime:0.63668203353882 / seconds
Query Executed:select id FROM `wv` where city='Montana Mines' && SIC_code='7011'DB:business_master_new
loadtime:0.63718509674072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montcalm' limit 1
loadtime:0.63724613189697 / seconds
Query Executed:select id FROM `wv` where city='Montcalm' && SIC_code='7011'DB:business_master_new
loadtime:0.63784408569336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montcoal' limit 1
loadtime:0.63790917396545 / seconds
Query Executed:select id FROM `wv` where city='Montcoal' && SIC_code='7011'DB:business_master_new
loadtime:0.63839912414551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterville' limit 1
loadtime:0.63846015930176 / seconds
Query Executed:select id FROM `wv` where city='Monterville' && SIC_code='7011'DB:business_master_new
loadtime:0.63895916938782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:0.6390380859375 / seconds
Query Executed:select id FROM `wv` where city='Montgomery' && SIC_code='7011'DB:business_master_new
loadtime:0.64165902137756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.6417350769043 / seconds
Query Executed:select id FROM `wv` where city='Montrose' && SIC_code='7011'DB:business_master_new
loadtime:0.64240407943726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorefield' limit 1
loadtime:0.64246606826782 / seconds
Query Executed:select id FROM `wv` where city='Moorefield' && SIC_code='7011'DB:business_master_new
loadtime:0.64632415771484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgantown' limit 1
loadtime:0.64640212059021 / seconds
Query Executed:select id FROM `wv` where city='Morgantown' && SIC_code='7011'DB:business_master_new
loadtime:0.652752161026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisvale' limit 1
loadtime:0.65287113189697 / seconds
Query Executed:select id FROM `wv` where city='Morrisvale' && SIC_code='7011'DB:business_master_new
loadtime:0.65329718589783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moundsville' limit 1
loadtime:0.65336298942566 / seconds
Query Executed:select id FROM `wv` where city='Moundsville' && SIC_code='7011'DB:business_master_new
loadtime:0.66004610061646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Alto' limit 1
loadtime:0.6601300239563 / seconds
Query Executed:select id FROM `wv` where city='Mount Alto' && SIC_code='7011'DB:business_master_new
loadtime:0.66069602966309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carbon' limit 1
loadtime:0.66075801849365 / seconds
Query Executed:select id FROM `wv` where city='Mount Carbon' && SIC_code='7011'DB:business_master_new
loadtime:0.66135811805725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Clare' limit 1
loadtime:0.6614191532135 / seconds
Query Executed:select id FROM `wv` where city='Mount Clare' && SIC_code='7011'DB:business_master_new
loadtime:0.6625280380249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Gay' limit 1
loadtime:0.66258811950684 / seconds
Query Executed:select id FROM `wv` where city='Mount Gay' && SIC_code='7011'DB:business_master_new
loadtime:0.66338515281677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Hope' limit 1
loadtime:0.66344594955444 / seconds
Query Executed:select id FROM `wv` where city='Mount Hope' && SIC_code='7011'DB:business_master_new
loadtime:0.66685104370117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Lookout' limit 1
loadtime:0.66692900657654 / seconds
Query Executed:select id FROM `wv` where city='Mount Lookout' && SIC_code='7011'DB:business_master_new
loadtime:0.66770100593567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Nebo' limit 1
loadtime:0.66776418685913 / seconds
Query Executed:select id FROM `wv` where city='Mount Nebo' && SIC_code='7011'DB:business_master_new
loadtime:0.66859698295593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:0.66867995262146 / seconds
Query Executed:select id FROM `wv` where city='Mount Olive' && SIC_code='7011'DB:business_master_new
loadtime:0.66914200782776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Storm' limit 1
loadtime:0.66921615600586 / seconds
Query Executed:select id FROM `wv` where city='Mount Storm' && SIC_code='7011'DB:business_master_new
loadtime:0.66995096206665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Zion' limit 1
loadtime:0.67003107070923 / seconds
Query Executed:select id FROM `wv` where city='Mount Zion' && SIC_code='7011'DB:business_master_new
loadtime:0.67057204246521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moyers' limit 1
loadtime:0.67063403129578 / seconds
Query Executed:select id FROM `wv` where city='Moyers' && SIC_code='7011'DB:business_master_new
loadtime:0.67110395431519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Alto' limit 1
loadtime:0.67117500305176 / seconds
Query Executed:select id FROM `wv` where city='Mt Alto' && SIC_code='7011'DB:business_master_new
loadtime:0.6716251373291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carbon' limit 1
loadtime:0.67168998718262 / seconds
Query Executed:select id FROM `wv` where city='Mt Carbon' && SIC_code='7011'DB:business_master_new
loadtime:0.67216801643372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Clare' limit 1
loadtime:0.67222809791565 / seconds
Query Executed:select id FROM `wv` where city='Mt Clare' && SIC_code='7011'DB:business_master_new
loadtime:0.67267799377441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Gay' limit 1
loadtime:0.67274308204651 / seconds
Query Executed:select id FROM `wv` where city='Mt Gay' && SIC_code='7011'DB:business_master_new
loadtime:0.67321610450745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Hope' limit 1
loadtime:0.67327499389648 / seconds
Query Executed:select id FROM `wv` where city='Mt Hope' && SIC_code='7011'DB:business_master_new
loadtime:0.67375516891479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Lookout' limit 1
loadtime:0.67381715774536 / seconds
Query Executed:select id FROM `wv` where city='Mt Lookout' && SIC_code='7011'DB:business_master_new
loadtime:0.67430114746094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Nebo' limit 1
loadtime:0.67436218261719 / seconds
Query Executed:select id FROM `wv` where city='Mt Nebo' && SIC_code='7011'DB:business_master_new
loadtime:0.67483711242676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:0.67490100860596 / seconds
Query Executed:select id FROM `wv` where city='Mt Olive' && SIC_code='7011'DB:business_master_new
loadtime:0.67536306381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Storm' limit 1
loadtime:0.67542314529419 / seconds
Query Executed:select id FROM `wv` where city='Mt Storm' && SIC_code='7011'DB:business_master_new
loadtime:0.6759181022644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Zion' limit 1
loadtime:0.67597913742065 / seconds
Query Executed:select id FROM `wv` where city='Mt Zion' && SIC_code='7011'DB:business_master_new
loadtime:0.67644906044006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullens' limit 1
loadtime:0.676509141922 / seconds
Query Executed:select id FROM `wv` where city='Mullens' && SIC_code='7011'DB:business_master_new
loadtime:0.67849016189575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munday' limit 1
loadtime:0.67855310440063 / seconds
Query Executed:select id FROM `wv` where city='Munday' && SIC_code='7011'DB:business_master_new
loadtime:0.67898106575012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murraysville' limit 1
loadtime:0.67904496192932 / seconds
Query Executed:select id FROM `wv` where city='Murraysville' && SIC_code='7011'DB:business_master_new
loadtime:0.67948508262634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myra' limit 1
loadtime:0.67954611778259 / seconds
Query Executed:select id FROM `wv` where city='Myra' && SIC_code='7011'DB:business_master_new
loadtime:0.67997908592224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nallen' limit 1
loadtime:0.68004703521729 / seconds
Query Executed:select id FROM `wv` where city='Nallen' && SIC_code='7011'DB:business_master_new
loadtime:0.68052411079407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naoma' limit 1
loadtime:0.68058395385742 / seconds
Query Executed:select id FROM `wv` where city='Naoma' && SIC_code='7011'DB:business_master_new
loadtime:0.68118715286255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Napier' limit 1
loadtime:0.6812469959259 / seconds
Query Executed:select id FROM `wv` where city='Napier' && SIC_code='7011'DB:business_master_new
loadtime:0.68172001838684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.68178009986877 / seconds
Query Executed:select id FROM `wv` where city='Naugatuck' && SIC_code='7011'DB:business_master_new
loadtime:0.68241095542908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nebo' limit 1
loadtime:0.68247199058533 / seconds
Query Executed:select id FROM `wv` where city='Nebo' && SIC_code='7011'DB:business_master_new
loadtime:0.68296813964844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellis' limit 1
loadtime:0.68303298950195 / seconds
Query Executed:select id FROM `wv` where city='Nellis' && SIC_code='7011'DB:business_master_new
loadtime:0.6835310459137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemours' limit 1
loadtime:0.68359613418579 / seconds
Query Executed:select id FROM `wv` where city='Nemours' && SIC_code='7011'DB:business_master_new
loadtime:0.68409109115601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:0.68416309356689 / seconds
Query Executed:select id FROM `wv` where city='Neola' && SIC_code='7011'DB:business_master_new
loadtime:0.68465113639832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nettie' limit 1
loadtime:0.68471312522888 / seconds
Query Executed:select id FROM `wv` where city='Nettie' && SIC_code='7011'DB:business_master_new
loadtime:0.68555903434753 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Creek' limit 1
loadtime:0.68561911582947 / seconds
Query Executed:select id FROM `wv` where city='New Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.68630313873291 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Cumberland' limit 1
loadtime:0.68638014793396 / seconds
Query Executed:select id FROM `wv` where city='New Cumberland' && SIC_code='7011'DB:business_master_new
loadtime:0.6887891292572 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.6888530254364 / seconds
Query Executed:select id FROM `wv` where city='New Haven' && SIC_code='7011'DB:business_master_new
loadtime:0.68991208076477 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Manchester' limit 1
loadtime:0.68997311592102 / seconds
Query Executed:select id FROM `wv` where city='New Manchester' && SIC_code='7011'DB:business_master_new
loadtime:0.69060897827148 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Martinsville' limit 1
loadtime:0.69067001342773 / seconds
Query Executed:select id FROM `wv` where city='New Martinsville' && SIC_code='7011'DB:business_master_new
loadtime:0.69660997390747 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milton' limit 1
loadtime:0.69669604301453 / seconds
Query Executed:select id FROM `wv` where city='New Milton' && SIC_code='7011'DB:business_master_new
loadtime:0.69729900360107 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Richmond' limit 1
loadtime:0.69737410545349 / seconds
Query Executed:select id FROM `wv` where city='New Richmond' && SIC_code='7011'DB:business_master_new
loadtime:0.69792318344116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburg' limit 1
loadtime:0.69798803329468 / seconds
Query Executed:select id FROM `wv` where city='Newburg' && SIC_code='7011'DB:business_master_new
loadtime:0.698734998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.69879603385925 / seconds
Query Executed:select id FROM `wv` where city='Newell' && SIC_code='7011'DB:business_master_new
loadtime:0.70007014274597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhall' limit 1
loadtime:0.70015406608582 / seconds
Query Executed:select id FROM `wv` where city='Newhall' && SIC_code='7011'DB:business_master_new
loadtime:0.70062518119812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.70069098472595 / seconds
Query Executed:select id FROM `wv` where city='Newton' && SIC_code='7011'DB:business_master_new
loadtime:0.70129799842834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.70136117935181 / seconds
Query Executed:select id FROM `wv` where city='Newtown' && SIC_code='7011'DB:business_master_new
loadtime:0.7018301486969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nicut' limit 1
loadtime:0.70188999176025 / seconds
Query Executed:select id FROM `wv` where city='Nicut' && SIC_code='7011'DB:business_master_new
loadtime:0.70234107971191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nimitz' limit 1
loadtime:0.70240116119385 / seconds
Query Executed:select id FROM `wv` where city='Nimitz' && SIC_code='7011'DB:business_master_new
loadtime:0.70303297042847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nitro' limit 1
loadtime:0.70309400558472 / seconds
Query Executed:select id FROM `wv` where city='Nitro' && SIC_code='7011'DB:business_master_new
loadtime:0.70879411697388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nolan' limit 1
loadtime:0.70887207984924 / seconds
Query Executed:select id FROM `wv` where city='Nolan' && SIC_code='7011'DB:business_master_new
loadtime:0.70932006835938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Normantown' limit 1
loadtime:0.70938396453857 / seconds
Query Executed:select id FROM `wv` where city='Normantown' && SIC_code='7011'DB:business_master_new
loadtime:0.70989012718201 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Matewan' limit 1
loadtime:0.70994997024536 / seconds
Query Executed:select id FROM `wv` where city='North Matewan' && SIC_code='7011'DB:business_master_new
loadtime:0.71051001548767 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Spring' limit 1
loadtime:0.71057105064392 / seconds
Query Executed:select id FROM `wv` where city='North Spring' && SIC_code='7011'DB:business_master_new
loadtime:0.71099615097046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfork' limit 1
loadtime:0.71105813980103 / seconds
Query Executed:select id FROM `wv` where city='Northfork' && SIC_code='7011'DB:business_master_new
loadtime:0.71218109130859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.71225500106812 / seconds
Query Executed:select id FROM `wv` where city='Norton' && SIC_code='7011'DB:business_master_new
loadtime:0.71279716491699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hill' limit 1
loadtime:0.71285915374756 / seconds
Query Executed:select id FROM `wv` where city='Oak Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.71911406517029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakvale' limit 1
loadtime:0.7192051410675 / seconds
Query Executed:select id FROM `wv` where city='Oakvale' && SIC_code='7011'DB:business_master_new
loadtime:0.71980905532837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceana' limit 1
loadtime:0.71987199783325 / seconds
Query Executed:select id FROM `wv` where city='Oceana' && SIC_code='7011'DB:business_master_new
loadtime:0.72250318527222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odd' limit 1
loadtime:0.72257900238037 / seconds
Query Executed:select id FROM `wv` where city='Odd' && SIC_code='7011'DB:business_master_new
loadtime:0.7231080532074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ohley' limit 1
loadtime:0.72318005561829 / seconds
Query Executed:select id FROM `wv` where city='Ohley' && SIC_code='7011'DB:business_master_new
loadtime:0.72365117073059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Fields' limit 1
loadtime:0.72371101379395 / seconds
Query Executed:select id FROM `wv` where city='Old Fields' && SIC_code='7011'DB:business_master_new
loadtime:0.72436213493347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omar' limit 1
loadtime:0.72442317008972 / seconds
Query Executed:select id FROM `wv` where city='Omar' && SIC_code='7011'DB:business_master_new
loadtime:0.72506499290466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ona' limit 1
loadtime:0.7251250743866 / seconds
Query Executed:select id FROM `wv` where city='Ona' && SIC_code='7011'DB:business_master_new
loadtime:0.7270359992981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onego' limit 1
loadtime:0.72709798812866 / seconds
Query Executed:select id FROM `wv` where city='Onego' && SIC_code='7011'DB:business_master_new
loadtime:0.72757911682129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orgas' limit 1
loadtime:0.7276439666748 / seconds
Query Executed:select id FROM `wv` where city='Orgas' && SIC_code='7011'DB:business_master_new
loadtime:0.72817397117615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlando' limit 1
loadtime:0.72823405265808 / seconds
Query Executed:select id FROM `wv` where city='Orlando' && SIC_code='7011'DB:business_master_new
loadtime:0.7287220954895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orma' limit 1
loadtime:0.72878313064575 / seconds
Query Executed:select id FROM `wv` where city='Orma' && SIC_code='7011'DB:business_master_new
loadtime:0.72934198379517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage' limit 1
loadtime:0.72940707206726 / seconds
Query Executed:select id FROM `wv` where city='Osage' && SIC_code='7011'DB:business_master_new
loadtime:0.73002910614014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottawa' limit 1
loadtime:0.73009014129639 / seconds
Query Executed:select id FROM `wv` where city='Ottawa' && SIC_code='7011'DB:business_master_new
loadtime:0.73062896728516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovapa' limit 1
loadtime:0.73069000244141 / seconds
Query Executed:select id FROM `wv` where city='Ovapa' && SIC_code='7011'DB:business_master_new
loadtime:0.73111915588379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paden City' limit 1
loadtime:0.73119115829468 / seconds
Query Executed:select id FROM `wv` where city='Paden City' && SIC_code='7011'DB:business_master_new
loadtime:0.73250913619995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Page' limit 1
loadtime:0.73258996009827 / seconds
Query Executed:select id FROM `wv` where city='Page' && SIC_code='7011'DB:business_master_new
loadtime:0.73310995101929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pageton' limit 1
loadtime:0.73318195343018 / seconds
Query Executed:select id FROM `wv` where city='Pageton' && SIC_code='7011'DB:business_master_new
loadtime:0.73367714881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palestine' limit 1
loadtime:0.73373818397522 / seconds
Query Executed:select id FROM `wv` where city='Palestine' && SIC_code='7011'DB:business_master_new
loadtime:0.73431706428528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panther' limit 1
loadtime:0.73437905311584 / seconds
Query Executed:select id FROM `wv` where city='Panther' && SIC_code='7011'DB:business_master_new
loadtime:0.73492002487183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkersburg' limit 1
loadtime:0.73498201370239 / seconds
Query Executed:select id FROM `wv` where city='Parkersburg' && SIC_code='7011'DB:business_master_new
loadtime:0.74146604537964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parsons' limit 1
loadtime:0.74156999588013 / seconds
Query Executed:select id FROM `wv` where city='Parsons' && SIC_code='7011'DB:business_master_new
loadtime:0.74419498443604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Paw' limit 1
loadtime:0.74427914619446 / seconds
Query Executed:select id FROM `wv` where city='Paw Paw' && SIC_code='7011'DB:business_master_new
loadtime:0.74519896507263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pax' limit 1
loadtime:0.74527406692505 / seconds
Query Executed:select id FROM `wv` where city='Pax' && SIC_code='7011'DB:business_master_new
loadtime:0.74583315849304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paynesville' limit 1
loadtime:0.74589395523071 / seconds
Query Executed:select id FROM `wv` where city='Paynesville' && SIC_code='7011'DB:business_master_new
loadtime:0.74642109870911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peach Creek' limit 1
loadtime:0.74648213386536 / seconds
Query Executed:select id FROM `wv` where city='Peach Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.7470850944519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pecks Mill' limit 1
loadtime:0.74715495109558 / seconds
Query Executed:select id FROM `wv` where city='Pecks Mill' && SIC_code='7011'DB:business_master_new
loadtime:0.74799418449402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pemberton' limit 1
loadtime:0.74805617332458 / seconds
Query Executed:select id FROM `wv` where city='Pemberton' && SIC_code='7011'DB:business_master_new
loadtime:0.74848103523254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pence Springs' limit 1
loadtime:0.74854111671448 / seconds
Query Executed:select id FROM `wv` where city='Pence Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.7490291595459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennsboro' limit 1
loadtime:0.74910306930542 / seconds
Query Executed:select id FROM `wv` where city='Pennsboro' && SIC_code='7011'DB:business_master_new
loadtime:0.75116801261902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pentress' limit 1
loadtime:0.75124502182007 / seconds
Query Executed:select id FROM `wv` where city='Pentress' && SIC_code='7011'DB:business_master_new
loadtime:0.75181913375854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:0.75188302993774 / seconds
Query Executed:select id FROM `wv` where city='Petersburg' && SIC_code='7011'DB:business_master_new
loadtime:0.75690817832947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterstown' limit 1
loadtime:0.75699806213379 / seconds
Query Executed:select id FROM `wv` where city='Peterstown' && SIC_code='7011'DB:business_master_new
loadtime:0.75905704498291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petroleum' limit 1
loadtime:0.75912117958069 / seconds
Query Executed:select id FROM `wv` where city='Petroleum' && SIC_code='7011'DB:business_master_new
loadtime:0.75964498519897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peytona' limit 1
loadtime:0.7597131729126 / seconds
Query Executed:select id FROM `wv` where city='Peytona' && SIC_code='7011'DB:business_master_new
loadtime:0.7602961063385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philippi' limit 1
loadtime:0.76035714149475 / seconds
Query Executed:select id FROM `wv` where city='Philippi' && SIC_code='7011'DB:business_master_new
loadtime:0.76412796974182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickaway' limit 1
loadtime:0.76422095298767 / seconds
Query Executed:select id FROM `wv` where city='Pickaway' && SIC_code='7011'DB:business_master_new
loadtime:0.76470017433167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:0.76476407051086 / seconds
Query Executed:select id FROM `wv` where city='Pickens' && SIC_code='7011'DB:business_master_new
loadtime:0.76527404785156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.76533508300781 / seconds
Query Executed:select id FROM `wv` where city='Piedmont' && SIC_code='7011'DB:business_master_new
loadtime:0.76623296737671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinch' limit 1
loadtime:0.76629400253296 / seconds
Query Executed:select id FROM `wv` where city='Pinch' && SIC_code='7011'DB:business_master_new
loadtime:0.76699209213257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Grove' limit 1
loadtime:0.76705408096313 / seconds
Query Executed:select id FROM `wv` where city='Pine Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.76801109313965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:0.76807308197021 / seconds
Query Executed:select id FROM `wv` where city='Pineville' && SIC_code='7011'DB:business_master_new
loadtime:0.77108407020569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney View' limit 1
loadtime:0.77117609977722 / seconds
Query Executed:select id FROM `wv` where city='Piney View' && SIC_code='7011'DB:business_master_new
loadtime:0.77172613143921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pipestem' limit 1
loadtime:0.77178907394409 / seconds
Query Executed:select id FROM `wv` where city='Pipestem' && SIC_code='7011'DB:business_master_new
loadtime:0.77255797386169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pliny' limit 1
loadtime:0.77263712882996 / seconds
Query Executed:select id FROM `wv` where city='Pliny' && SIC_code='7011'DB:business_master_new
loadtime:0.77310109138489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poca' limit 1
loadtime:0.77317404747009 / seconds
Query Executed:select id FROM `wv` where city='Poca' && SIC_code='7011'DB:business_master_new
loadtime:0.77582216262817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Pleasant' limit 1
loadtime:0.77588510513306 / seconds
Query Executed:select id FROM `wv` where city='Point Pleasant' && SIC_code='7011'DB:business_master_new
loadtime:0.78131508827209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Points' limit 1
loadtime:0.78139400482178 / seconds
Query Executed:select id FROM `wv` where city='Points' && SIC_code='7011'DB:business_master_new
loadtime:0.78184103965759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pond Gap' limit 1
loadtime:0.781907081604 / seconds
Query Executed:select id FROM `wv` where city='Pond Gap' && SIC_code='7011'DB:business_master_new
loadtime:0.78239417076111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pool' limit 1
loadtime:0.78245615959167 / seconds
Query Executed:select id FROM `wv` where city='Pool' && SIC_code='7011'DB:business_master_new
loadtime:0.78291296958923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porters Falls' limit 1
loadtime:0.78297805786133 / seconds
Query Executed:select id FROM `wv` where city='Porters Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.78342199325562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powellton' limit 1
loadtime:0.78348398208618 / seconds
Query Executed:select id FROM `wv` where city='Powellton' && SIC_code='7011'DB:business_master_new
loadtime:0.78405714035034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:0.78412318229675 / seconds
Query Executed:select id FROM `wv` where city='Powhatan' && SIC_code='7011'DB:business_master_new
loadtime:0.78457307815552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratt' limit 1
loadtime:0.78463315963745 / seconds
Query Executed:select id FROM `wv` where city='Pratt' && SIC_code='7011'DB:business_master_new
loadtime:0.78523015975952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Premier' limit 1
loadtime:0.78529214859009 / seconds
Query Executed:select id FROM `wv` where city='Premier' && SIC_code='7011'DB:business_master_new
loadtime:0.78577899932861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prenter' limit 1
loadtime:0.78584003448486 / seconds
Query Executed:select id FROM `wv` where city='Prenter' && SIC_code='7011'DB:business_master_new
loadtime:0.78630805015564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prichard' limit 1
loadtime:0.78636813163757 / seconds
Query Executed:select id FROM `wv` where city='Prichard' && SIC_code='7011'DB:business_master_new
loadtime:0.78718614578247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince' limit 1
loadtime:0.78724598884583 / seconds
Query Executed:select id FROM `wv` where city='Prince' && SIC_code='7011'DB:business_master_new
loadtime:0.78772115707397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:0.78778195381165 / seconds
Query Executed:select id FROM `wv` where city='Princeton' && SIC_code='7011'DB:business_master_new
loadtime:0.80356812477112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princewick' limit 1
loadtime:0.80366802215576 / seconds
Query Executed:select id FROM `wv` where city='Princewick' && SIC_code='7011'DB:business_master_new
loadtime:0.80419707298279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Procious' limit 1
loadtime:0.80426597595215 / seconds
Query Executed:select id FROM `wv` where city='Procious' && SIC_code='7011'DB:business_master_new
loadtime:0.80486297607422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctor' limit 1
loadtime:0.80492305755615 / seconds
Query Executed:select id FROM `wv` where city='Proctor' && SIC_code='7011'DB:business_master_new
loadtime:0.80582499504089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prosperity' limit 1
loadtime:0.80590415000916 / seconds
Query Executed:select id FROM `wv` where city='Prosperity' && SIC_code='7011'DB:business_master_new
loadtime:0.80667805671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pullman' limit 1
loadtime:0.80674004554749 / seconds
Query Executed:select id FROM `wv` where city='Pullman' && SIC_code='7011'DB:business_master_new
loadtime:0.80721497535706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purgitsville' limit 1
loadtime:0.80727601051331 / seconds
Query Executed:select id FROM `wv` where city='Purgitsville' && SIC_code='7011'DB:business_master_new
loadtime:0.80785202980042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pursglove' limit 1
loadtime:0.8079149723053 / seconds
Query Executed:select id FROM `wv` where city='Pursglove' && SIC_code='7011'DB:business_master_new
loadtime:0.80844807624817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinwood' limit 1
loadtime:0.80850911140442 / seconds
Query Executed:select id FROM `wv` where city='Quinwood' && SIC_code='7011'DB:business_master_new
loadtime:0.80909895896912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rachel' limit 1
loadtime:0.8091721534729 / seconds
Query Executed:select id FROM `wv` where city='Rachel' && SIC_code='7011'DB:business_master_new
loadtime:0.80966114997864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Racine' limit 1
loadtime:0.80972099304199 / seconds
Query Executed:select id FROM `wv` where city='Racine' && SIC_code='7011'DB:business_master_new
loadtime:0.8103289604187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ragland' limit 1
loadtime:0.81039094924927 / seconds
Query Executed:select id FROM `wv` where city='Ragland' && SIC_code='7011'DB:business_master_new
loadtime:0.81091618537903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainelle' limit 1
loadtime:0.81097602844238 / seconds
Query Executed:select id FROM `wv` where city='Rainelle' && SIC_code='7011'DB:business_master_new
loadtime:0.81383013725281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:0.81390810012817 / seconds
Query Executed:select id FROM `wv` where city='Raleigh' && SIC_code='7011'DB:business_master_new
loadtime:0.81446003913879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranger' limit 1
loadtime:0.81452202796936 / seconds
Query Executed:select id FROM `wv` where city='Ranger' && SIC_code='7011'DB:business_master_new
loadtime:0.815181016922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranson' limit 1
loadtime:0.81524205207825 / seconds
Query Executed:select id FROM `wv` where city='Ranson' && SIC_code='7011'DB:business_master_new
loadtime:0.81795501708984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravencliff' limit 1
loadtime:0.81804513931274 / seconds
Query Executed:select id FROM `wv` where city='Ravencliff' && SIC_code='7011'DB:business_master_new
loadtime:0.81851506233215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenswood' limit 1
loadtime:0.81858515739441 / seconds
Query Executed:select id FROM `wv` where city='Ravenswood' && SIC_code='7011'DB:business_master_new
loadtime:0.82229995727539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawl' limit 1
loadtime:0.82237815856934 / seconds
Query Executed:select id FROM `wv` where city='Rawl' && SIC_code='7011'DB:business_master_new
loadtime:0.82285809516907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raysal' limit 1
loadtime:0.82292008399963 / seconds
Query Executed:select id FROM `wv` where city='Raysal' && SIC_code='7011'DB:business_master_new
loadtime:0.82347106933594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reader' limit 1
loadtime:0.8235330581665 / seconds
Query Executed:select id FROM `wv` where city='Reader' && SIC_code='7011'DB:business_master_new
loadtime:0.82418513298035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Creek' limit 1
loadtime:0.8242461681366 / seconds
Query Executed:select id FROM `wv` where city='Red Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.82472205162048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:0.82478213310242 / seconds
Query Executed:select id FROM `wv` where city='Red House' && SIC_code='7011'DB:business_master_new
loadtime:0.82566809654236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Jacket' limit 1
loadtime:0.82573008537292 / seconds
Query Executed:select id FROM `wv` where city='Red Jacket' && SIC_code='7011'DB:business_master_new
loadtime:0.82629609107971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsville' limit 1
loadtime:0.82635712623596 / seconds
Query Executed:select id FROM `wv` where city='Reedsville' && SIC_code='7011'DB:business_master_new
loadtime:0.82820415496826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedy' limit 1
loadtime:0.82826614379883 / seconds
Query Executed:select id FROM `wv` where city='Reedy' && SIC_code='7011'DB:business_master_new
loadtime:0.82892799377441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renick' limit 1
loadtime:0.8289999961853 / seconds
Query Executed:select id FROM `wv` where city='Renick' && SIC_code='7011'DB:business_master_new
loadtime:0.82983207702637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reynoldsville' limit 1
loadtime:0.82989311218262 / seconds
Query Executed:select id FROM `wv` where city='Reynoldsville' && SIC_code='7011'DB:business_master_new
loadtime:0.83044409751892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodell' limit 1
loadtime:0.83050513267517 / seconds
Query Executed:select id FROM `wv` where city='Rhodell' && SIC_code='7011'DB:business_master_new
loadtime:0.8310010433197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richwood' limit 1
loadtime:0.83106398582458 / seconds
Query Executed:select id FROM `wv` where city='Richwood' && SIC_code='7011'DB:business_master_new
loadtime:0.83335399627686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeley' limit 1
loadtime:0.83343315124512 / seconds
Query Executed:select id FROM `wv` where city='Ridgeley' && SIC_code='7011'DB:business_master_new
loadtime:0.83575510978699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeview' limit 1
loadtime:0.83581900596619 / seconds
Query Executed:select id FROM `wv` where city='Ridgeview' && SIC_code='7011'DB:business_master_new
loadtime:0.83634996414185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.8364109992981 / seconds
Query Executed:select id FROM `wv` where city='Ridgeway' && SIC_code='7011'DB:business_master_new
loadtime:0.83681511878967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rig' limit 1
loadtime:0.83687400817871 / seconds
Query Executed:select id FROM `wv` where city='Rig' && SIC_code='7011'DB:business_master_new
loadtime:0.83727598190308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio' limit 1
loadtime:0.83733797073364 / seconds
Query Executed:select id FROM `wv` where city='Rio' && SIC_code='7011'DB:business_master_new
loadtime:0.8379180431366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripley' limit 1
loadtime:0.83797907829285 / seconds
Query Executed:select id FROM `wv` where city='Ripley' && SIC_code='7011'DB:business_master_new
loadtime:0.8442280292511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rippon' limit 1
loadtime:0.84431004524231 / seconds
Query Executed:select id FROM `wv` where city='Rippon' && SIC_code='7011'DB:business_master_new
loadtime:0.84482002258301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.84488296508789 / seconds
Query Executed:select id FROM `wv` where city='Riverton' && SIC_code='7011'DB:business_master_new
loadtime:0.84546613693237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rivesville' limit 1
loadtime:0.84552812576294 / seconds
Query Executed:select id FROM `wv` where city='Rivesville' && SIC_code='7011'DB:business_master_new
loadtime:0.84640502929688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:0.84646797180176 / seconds
Query Executed:select id FROM `wv` where city='Roanoke' && SIC_code='7011'DB:business_master_new
loadtime:0.84690308570862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robson' limit 1
loadtime:0.84696316719055 / seconds
Query Executed:select id FROM `wv` where city='Robson' && SIC_code='7011'DB:business_master_new
loadtime:0.84749102592468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock' limit 1
loadtime:0.84755206108093 / seconds
Query Executed:select id FROM `wv` where city='Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.84825396537781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Cave' limit 1
loadtime:0.84831500053406 / seconds
Query Executed:select id FROM `wv` where city='Rock Cave' && SIC_code='7011'DB:business_master_new
loadtime:0.84913802146912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Creek' limit 1
loadtime:0.84920811653137 / seconds
Query Executed:select id FROM `wv` where city='Rock Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.84966897964478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock View' limit 1
loadtime:0.84973001480103 / seconds
Query Executed:select id FROM `wv` where city='Rock View' && SIC_code='7011'DB:business_master_new
loadtime:0.85022807121277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:0.85030198097229 / seconds
Query Executed:select id FROM `wv` where city='Rockport' && SIC_code='7011'DB:business_master_new
loadtime:0.85081505775452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roderfield' limit 1
loadtime:0.85088109970093 / seconds
Query Executed:select id FROM `wv` where city='Roderfield' && SIC_code='7011'DB:business_master_new
loadtime:0.85144400596619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romance' limit 1
loadtime:0.85150599479675 / seconds
Query Executed:select id FROM `wv` where city='Romance' && SIC_code='7011'DB:business_master_new
loadtime:0.85193109512329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romney' limit 1
loadtime:0.85199618339539 / seconds
Query Executed:select id FROM `wv` where city='Romney' && SIC_code='7011'DB:business_master_new
loadtime:0.85683703422546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ronceverte' limit 1
loadtime:0.85691714286804 / seconds
Query Executed:select id FROM `wv` where city='Ronceverte' && SIC_code='7011'DB:business_master_new
loadtime:0.85987496376038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:0.85993909835815 / seconds
Query Executed:select id FROM `wv` where city='Rosedale' && SIC_code='7011'DB:business_master_new
loadtime:0.86045002937317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosemont' limit 1
loadtime:0.86051106452942 / seconds
Query Executed:select id FROM `wv` where city='Rosemont' && SIC_code='7011'DB:business_master_new
loadtime:0.86105012893677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rossmore' limit 1
loadtime:0.86111497879028 / seconds
Query Executed:select id FROM `wv` where city='Rossmore' && SIC_code='7011'DB:business_master_new
loadtime:0.86158418655396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowlesburg' limit 1
loadtime:0.86165118217468 / seconds
Query Executed:select id FROM `wv` where city='Rowlesburg' && SIC_code='7011'DB:business_master_new
loadtime:0.86251211166382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rupert' limit 1
loadtime:0.86257314682007 / seconds
Query Executed:select id FROM `wv` where city='Rupert' && SIC_code='7011'DB:business_master_new
loadtime:0.86367702484131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sabine' limit 1
loadtime:0.86373805999756 / seconds
Query Executed:select id FROM `wv` where city='Sabine' && SIC_code='7011'DB:business_master_new
loadtime:0.86418509483337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Albans' limit 1
loadtime:0.86424517631531 / seconds
Query Executed:select id FROM `wv` where city='Saint Albans' && SIC_code='7011'DB:business_master_new
loadtime:0.87485313415527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Marys' limit 1
loadtime:0.87494206428528 / seconds
Query Executed:select id FROM `wv` where city='Saint Marys' && SIC_code='7011'DB:business_master_new
loadtime:0.87825798988342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.87833905220032 / seconds
Query Executed:select id FROM `wv` where city='Salem' && SIC_code='7011'DB:business_master_new
loadtime:0.88092017173767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salt Rock' limit 1
loadtime:0.8809859752655 / seconds
Query Executed:select id FROM `wv` where city='Salt Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.88188815116882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Fork' limit 1
loadtime:0.88194918632507 / seconds
Query Executed:select id FROM `wv` where city='Sand Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.88250303268433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandstone' limit 1
loadtime:0.88256406784058 / seconds
Query Executed:select id FROM `wv` where city='Sandstone' && SIC_code='7011'DB:business_master_new
loadtime:0.88312697410583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandyville' limit 1
loadtime:0.88321805000305 / seconds
Query Executed:select id FROM `wv` where city='Sandyville' && SIC_code='7011'DB:business_master_new
loadtime:0.88394117355347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarah Ann' limit 1
loadtime:0.8840069770813 / seconds
Query Executed:select id FROM `wv` where city='Sarah Ann' && SIC_code='7011'DB:business_master_new
loadtime:0.88450217247009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saulsville' limit 1
loadtime:0.88456296920776 / seconds
Query Executed:select id FROM `wv` where city='Saulsville' && SIC_code='7011'DB:business_master_new
loadtime:0.88506603240967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxon' limit 1
loadtime:0.88514113426208 / seconds
Query Executed:select id FROM `wv` where city='Saxon' && SIC_code='7011'DB:business_master_new
loadtime:0.8856041431427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scarbro' limit 1
loadtime:0.88566613197327 / seconds
Query Executed:select id FROM `wv` where city='Scarbro' && SIC_code='7011'DB:business_master_new
loadtime:0.88642501831055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scherr' limit 1
loadtime:0.88649916648865 / seconds
Query Executed:select id FROM `wv` where city='Scherr' && SIC_code='7011'DB:business_master_new
loadtime:0.88697099685669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scott Depot' limit 1
loadtime:0.8870370388031 / seconds
Query Executed:select id FROM `wv` where city='Scott Depot' && SIC_code='7011'DB:business_master_new
loadtime:0.89131999015808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Secondcreek' limit 1
loadtime:0.89139604568481 / seconds
Query Executed:select id FROM `wv` where city='Secondcreek' && SIC_code='7011'DB:business_master_new
loadtime:0.89189314842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seebert' limit 1
loadtime:0.89195418357849 / seconds
Query Executed:select id FROM `wv` where city='Seebert' && SIC_code='7011'DB:business_master_new
loadtime:0.89242815971375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selbyville' limit 1
loadtime:0.89249110221863 / seconds
Query Executed:select id FROM `wv` where city='Selbyville' && SIC_code='7011'DB:business_master_new
loadtime:0.8929750919342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca Rocks' limit 1
loadtime:0.89304399490356 / seconds
Query Executed:select id FROM `wv` where city='Seneca Rocks' && SIC_code='7011'DB:business_master_new
loadtime:0.89372110366821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seth' limit 1
loadtime:0.8938000202179 / seconds
Query Executed:select id FROM `wv` where city='Seth' && SIC_code='7011'DB:business_master_new
loadtime:0.89445614814758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shady Spring' limit 1
loadtime:0.8945300579071 / seconds
Query Executed:select id FROM `wv` where city='Shady Spring' && SIC_code='7011'DB:business_master_new
loadtime:0.89655017852783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shanks' limit 1
loadtime:0.8966281414032 / seconds
Query Executed:select id FROM `wv` where city='Shanks' && SIC_code='7011'DB:business_master_new
loadtime:0.89722299575806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharples' limit 1
loadtime:0.89728498458862 / seconds
Query Executed:select id FROM `wv` where city='Sharples' && SIC_code='7011'DB:business_master_new
loadtime:0.89778614044189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Jct' limit 1
loadtime:0.89784812927246 / seconds
Query Executed:select id FROM `wv` where city='Shenandoah Jct' && SIC_code='7011'DB:business_master_new
loadtime:0.89835095405579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Junction' limit 1
loadtime:0.89841198921204 / seconds
Query Executed:select id FROM `wv` where city='Shenandoah Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.89937806129456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shepherdstown' limit 1
loadtime:0.89945316314697 / seconds
Query Executed:select id FROM `wv` where city='Shepherdstown' && SIC_code='7011'DB:business_master_new
loadtime:0.90417313575745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.90425801277161 / seconds
Query Executed:select id FROM `wv` where city='Sherman' && SIC_code='7011'DB:business_master_new
loadtime:0.90467214584351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shinnston' limit 1
loadtime:0.90473508834839 / seconds
Query Executed:select id FROM `wv` where city='Shinnston' && SIC_code='7011'DB:business_master_new
loadtime:0.90772294998169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:0.90780115127563 / seconds
Query Executed:select id FROM `wv` where city='Shirley' && SIC_code='7011'DB:business_master_new
loadtime:0.90826511383057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoals' limit 1
loadtime:0.90832710266113 / seconds
Query Executed:select id FROM `wv` where city='Shoals' && SIC_code='7011'DB:business_master_new
loadtime:0.90879702568054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shock' limit 1
loadtime:0.90885806083679 / seconds
Query Executed:select id FROM `wv` where city='Shock' && SIC_code='7011'DB:business_master_new
loadtime:0.90931510925293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Short Creek' limit 1
loadtime:0.90937495231628 / seconds
Query Executed:select id FROM `wv` where city='Short Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.90986108779907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:0.90992116928101 / seconds
Query Executed:select id FROM `wv` where city='Shrewsbury' && SIC_code='7011'DB:business_master_new
loadtime:0.91038417816162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simon' limit 1
loadtime:0.91044402122498 / seconds
Query Executed:select id FROM `wv` where city='Simon' && SIC_code='7011'DB:business_master_new
loadtime:0.91090607643127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpson' limit 1
loadtime:0.91097211837769 / seconds
Query Executed:select id FROM `wv` where city='Simpson' && SIC_code='7011'DB:business_master_new
loadtime:0.91145896911621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinks Grove' limit 1
loadtime:0.91152000427246 / seconds
Query Executed:select id FROM `wv` where city='Sinks Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.91218900680542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sissonville' limit 1
loadtime:0.91225004196167 / seconds
Query Executed:select id FROM `wv` where city='Sissonville' && SIC_code='7011'DB:business_master_new
loadtime:0.91275310516357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sistersville' limit 1
loadtime:0.91281414031982 / seconds
Query Executed:select id FROM `wv` where city='Sistersville' && SIC_code='7011'DB:business_master_new
loadtime:0.91504812240601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skelton' limit 1
loadtime:0.91512513160706 / seconds
Query Executed:select id FROM `wv` where city='Skelton' && SIC_code='7011'DB:business_master_new
loadtime:0.91572213172913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skygusty' limit 1
loadtime:0.91578412055969 / seconds
Query Executed:select id FROM `wv` where city='Skygusty' && SIC_code='7011'DB:business_master_new
loadtime:0.91625308990479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slab Fork' limit 1
loadtime:0.91631412506104 / seconds
Query Executed:select id FROM `wv` where city='Slab Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.91684007644653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slanesville' limit 1
loadtime:0.91690111160278 / seconds
Query Executed:select id FROM `wv` where city='Slanesville' && SIC_code='7011'DB:business_master_new
loadtime:0.91759395599365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slatyfork' limit 1
loadtime:0.9176561832428 / seconds
Query Executed:select id FROM `wv` where city='Slatyfork' && SIC_code='7011'DB:business_master_new
loadtime:0.91841197013855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithburg' limit 1
loadtime:0.91849112510681 / seconds
Query Executed:select id FROM `wv` where city='Smithburg' && SIC_code='7011'DB:business_master_new
loadtime:0.91909003257751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithers' limit 1
loadtime:0.91916513442993 / seconds
Query Executed:select id FROM `wv` where city='Smithers' && SIC_code='7011'DB:business_master_new
loadtime:0.92013311386108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:0.92020606994629 / seconds
Query Executed:select id FROM `wv` where city='Smithfield' && SIC_code='7011'DB:business_master_new
loadtime:0.92077898979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:0.92084002494812 / seconds
Query Executed:select id FROM `wv` where city='Smithville' && SIC_code='7011'DB:business_master_new
loadtime:0.92144417762756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smoot' limit 1
loadtime:0.92150497436523 / seconds
Query Executed:select id FROM `wv` where city='Smoot' && SIC_code='7011'DB:business_master_new
loadtime:0.9220860004425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowshoe' limit 1
loadtime:0.92215895652771 / seconds
Query Executed:select id FROM `wv` where city='Snowshoe' && SIC_code='7011'DB:business_master_new
loadtime:0.92319512367249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sod' limit 1
loadtime:0.92328214645386 / seconds
Query Executed:select id FROM `wv` where city='Sod' && SIC_code='7011'DB:business_master_new
loadtime:0.92385005950928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sophia' limit 1
loadtime:0.92391300201416 / seconds
Query Executed:select id FROM `wv` where city='Sophia' && SIC_code='7011'DB:business_master_new
loadtime:0.92589807510376 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Charleston' limit 1
loadtime:0.92596006393433 / seconds
Query Executed:select id FROM `wv` where city='South Charleston' && SIC_code='7011'DB:business_master_new
loadtime:0.92738318443298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southside' limit 1
loadtime:0.92744398117065 / seconds
Query Executed:select id FROM `wv` where city='Southside' && SIC_code='7011'DB:business_master_new
loadtime:0.9280731678009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spanishburg' limit 1
loadtime:0.92813301086426 / seconds
Query Executed:select id FROM `wv` where city='Spanishburg' && SIC_code='7011'DB:business_master_new
loadtime:0.92872500419617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spelter' limit 1
loadtime:0.9287850856781 / seconds
Query Executed:select id FROM `wv` where city='Spelter' && SIC_code='7011'DB:business_master_new
loadtime:0.92930006980896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.92936611175537 / seconds
Query Executed:select id FROM `wv` where city='Spencer' && SIC_code='7011'DB:business_master_new
loadtime:0.93408203125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sprague' limit 1
loadtime:0.93417096138 / seconds
Query Executed:select id FROM `wv` where city='Sprague' && SIC_code='7011'DB:business_master_new
loadtime:0.93465995788574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sprigg' limit 1
loadtime:0.93472218513489 / seconds
Query Executed:select id FROM `wv` where city='Sprigg' && SIC_code='7011'DB:business_master_new
loadtime:0.93521904945374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Dale' limit 1
loadtime:0.93528199195862 / seconds
Query Executed:select id FROM `wv` where city='Spring Dale' && SIC_code='7011'DB:business_master_new
loadtime:0.93578696250916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Hill' limit 1
loadtime:0.93584799766541 / seconds
Query Executed:select id FROM `wv` where city='Spring Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.93633913993835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.93640899658203 / seconds
Query Executed:select id FROM `wv` where city='Springfield' && SIC_code='7011'DB:business_master_new
loadtime:0.93737006187439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spurlockville' limit 1
loadtime:0.93743109703064 / seconds
Query Executed:select id FROM `wv` where city='Spurlockville' && SIC_code='7011'DB:business_master_new
loadtime:0.93792295455933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Squire' limit 1
loadtime:0.9379870891571 / seconds
Query Executed:select id FROM `wv` where city='Squire' && SIC_code='7011'DB:business_master_new
loadtime:0.93844699859619 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Albans' limit 1
loadtime:0.93850803375244 / seconds
Query Executed:select id FROM `wv` where city='St Albans' && SIC_code='7011'DB:business_master_new
loadtime:0.93910908699036 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Marys' limit 1
loadtime:0.93918204307556 / seconds
Query Executed:select id FROM `wv` where city='St Marys' && SIC_code='7011'DB:business_master_new
loadtime:0.93962907791138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanaford' limit 1
loadtime:0.93969106674194 / seconds
Query Executed:select id FROM `wv` where city='Stanaford' && SIC_code='7011'DB:business_master_new
loadtime:0.94037008285522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star City' limit 1
loadtime:0.94043207168579 / seconds
Query Executed:select id FROM `wv` where city='Star City' && SIC_code='7011'DB:business_master_new
loadtime:0.94090700149536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Statts Mills' limit 1
loadtime:0.94096708297729 / seconds
Query Executed:select id FROM `wv` where city='Statts Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.94144105911255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:0.94150304794312 / seconds
Query Executed:select id FROM `wv` where city='Stephenson' && SIC_code='7011'DB:business_master_new
loadtime:0.94200205802917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stollings' limit 1
loadtime:0.94206500053406 / seconds
Query Executed:select id FROM `wv` where city='Stollings' && SIC_code='7011'DB:business_master_new
loadtime:0.94296407699585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strange Creek' limit 1
loadtime:0.94302916526794 / seconds
Query Executed:select id FROM `wv` where city='Strange Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.94350814819336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:0.94356799125671 / seconds
Query Executed:select id FROM `wv` where city='Sugar Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.9442150592804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerco' limit 1
loadtime:0.94427704811096 / seconds
Query Executed:select id FROM `wv` where city='Sumerco' && SIC_code='7011'DB:business_master_new
loadtime:0.9447910785675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerlee' limit 1
loadtime:0.94485306739807 / seconds
Query Executed:select id FROM `wv` where city='Summerlee' && SIC_code='7011'DB:business_master_new
loadtime:0.9453010559082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summersville' limit 1
loadtime:0.94536209106445 / seconds
Query Executed:select id FROM `wv` where city='Summersville' && SIC_code='7011'DB:business_master_new
loadtime:0.95235395431519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit Point' limit 1
loadtime:0.95244717597961 / seconds
Query Executed:select id FROM `wv` where city='Summit Point' && SIC_code='7011'DB:business_master_new
loadtime:0.95328998565674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sundial' limit 1
loadtime:0.9533531665802 / seconds
Query Executed:select id FROM `wv` where city='Sundial' && SIC_code='7011'DB:business_master_new
loadtime:0.95383810997009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surveyor' limit 1
loadtime:0.95389914512634 / seconds
Query Executed:select id FROM `wv` where city='Surveyor' && SIC_code='7011'DB:business_master_new
loadtime:0.95457601547241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:0.95463705062866 / seconds
Query Executed:select id FROM `wv` where city='Sutton' && SIC_code='7011'DB:business_master_new
loadtime:0.9579930305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Springs' limit 1
loadtime:0.95808601379395 / seconds
Query Executed:select id FROM `wv` where city='Sweet Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.95851111412048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweetland' limit 1
loadtime:0.95857310295105 / seconds
Query Executed:select id FROM `wv` where city='Sweetland' && SIC_code='7011'DB:business_master_new
loadtime:0.9589831829071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swiss' limit 1
loadtime:0.95905995368958 / seconds
Query Executed:select id FROM `wv` where city='Swiss' && SIC_code='7011'DB:business_master_new
loadtime:0.95955109596252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Switchback' limit 1
loadtime:0.95961213111877 / seconds
Query Executed:select id FROM `wv` where city='Switchback' && SIC_code='7011'DB:business_master_new
loadtime:0.96004700660706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Switzer' limit 1
loadtime:0.96010804176331 / seconds
Query Executed:select id FROM `wv` where city='Switzer' && SIC_code='7011'DB:business_master_new
loadtime:0.96079397201538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvester' limit 1
loadtime:0.96085500717163 / seconds
Query Executed:select id FROM `wv` where city='Sylvester' && SIC_code='7011'DB:business_master_new
loadtime:0.96142911911011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tad' limit 1
loadtime:0.96150517463684 / seconds
Query Executed:select id FROM `wv` where city='Tad' && SIC_code='7011'DB:business_master_new
loadtime:0.96202206611633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talcott' limit 1
loadtime:0.9620840549469 / seconds
Query Executed:select id FROM `wv` where city='Talcott' && SIC_code='7011'DB:business_master_new
loadtime:0.96282315254211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tallmansville' limit 1
loadtime:0.96288895606995 / seconds
Query Executed:select id FROM `wv` where city='Tallmansville' && SIC_code='7011'DB:business_master_new
loadtime:0.96344614028931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tanner' limit 1
loadtime:0.96350717544556 / seconds
Query Executed:select id FROM `wv` where city='Tanner' && SIC_code='7011'DB:business_master_new
loadtime:0.96397399902344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taplin' limit 1
loadtime:0.96403908729553 / seconds
Query Executed:select id FROM `wv` where city='Taplin' && SIC_code='7011'DB:business_master_new
loadtime:0.96450304985046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariff' limit 1
loadtime:0.9645631313324 / seconds
Query Executed:select id FROM `wv` where city='Tariff' && SIC_code='7011'DB:business_master_new
loadtime:0.96503114700317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teays' limit 1
loadtime:0.96509695053101 / seconds
Query Executed:select id FROM `wv` where city='Teays' && SIC_code='7011'DB:business_master_new
loadtime:0.96600008010864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennerton' limit 1
loadtime:0.96606302261353 / seconds
Query Executed:select id FROM `wv` where city='Tennerton' && SIC_code='7011'DB:business_master_new
loadtime:0.96654415130615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terra Alta' limit 1
loadtime:0.9666051864624 / seconds
Query Executed:select id FROM `wv` where city='Terra Alta' && SIC_code='7011'DB:business_master_new
loadtime:0.96884107589722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terry' limit 1
loadtime:0.96891808509827 / seconds
Query Executed:select id FROM `wv` where city='Terry' && SIC_code='7011'DB:business_master_new
loadtime:0.96941804885864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thacker' limit 1
loadtime:0.96948003768921 / seconds
Query Executed:select id FROM `wv` where city='Thacker' && SIC_code='7011'DB:business_master_new
loadtime:0.96997213363647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomas' limit 1
loadtime:0.97003698348999 / seconds
Query Executed:select id FROM `wv` where city='Thomas' && SIC_code='7011'DB:business_master_new
loadtime:0.97108697891235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.97117400169373 / seconds
Query Executed:select id FROM `wv` where city='Thornton' && SIC_code='7011'DB:business_master_new
loadtime:0.97174000740051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorpe' limit 1
loadtime:0.9718029499054 / seconds
Query Executed:select id FROM `wv` where city='Thorpe' && SIC_code='7011'DB:business_master_new
loadtime:0.97230505943298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Churches' limit 1
loadtime:0.97236514091492 / seconds
Query Executed:select id FROM `wv` where city='Three Churches' && SIC_code='7011'DB:business_master_new
loadtime:0.9728090763092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurmond' limit 1
loadtime:0.9728741645813 / seconds
Query Executed:select id FROM `wv` where city='Thurmond' && SIC_code='7011'DB:business_master_new
loadtime:0.97337412834167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tioga' limit 1
loadtime:0.97343516349792 / seconds
Query Executed:select id FROM `wv` where city='Tioga' && SIC_code='7011'DB:business_master_new
loadtime:0.97394418716431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tornado' limit 1
loadtime:0.97400903701782 / seconds
Query Executed:select id FROM `wv` where city='Tornado' && SIC_code='7011'DB:business_master_new
loadtime:0.97468709945679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triadelphia' limit 1
loadtime:0.97474813461304 / seconds
Query Executed:select id FROM `wv` where city='Triadelphia' && SIC_code='7011'DB:business_master_new
loadtime:0.97727108001709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.97735095024109 / seconds
Query Executed:select id FROM `wv` where city='Troy' && SIC_code='7011'DB:business_master_new
loadtime:0.97788000106812 / seconds
Query loaded from cache:select * from geodata_geocity where city='TRUE' limit 1
loadtime:0.97794914245605 / seconds
Query Executed:select id FROM `wv` where city='TRUE' && SIC_code='7011'DB:business_master_new
loadtime:0.97842407226562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunnelton' limit 1
loadtime:0.97848606109619 / seconds
Query Executed:select id FROM `wv` where city='Tunnelton' && SIC_code='7011'DB:business_master_new
loadtime:0.97951006889343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turtle Creek' limit 1
loadtime:0.97957110404968 / seconds
Query Executed:select id FROM `wv` where city='Turtle Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.98018598556519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twilight' limit 1
loadtime:0.98024702072144 / seconds
Query Executed:select id FROM `wv` where city='Twilight' && SIC_code='7011'DB:business_master_new
loadtime:0.98069095611572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uneeda' limit 1
loadtime:0.98075199127197 / seconds
Query Executed:select id FROM `wv` where city='Uneeda' && SIC_code='7011'DB:business_master_new
loadtime:0.98126912117004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unger' limit 1
loadtime:0.9813289642334 / seconds
Query Executed:select id FROM `wv` where city='Unger' && SIC_code='7011'DB:business_master_new
loadtime:0.9817361831665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.98179602622986 / seconds
Query Executed:select id FROM `wv` where city='Union' && SIC_code='7011'DB:business_master_new
loadtime:0.98409509658813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upper Tract' limit 1
loadtime:0.98416996002197 / seconds
Query Executed:select id FROM `wv` where city='Upper Tract' && SIC_code='7011'DB:business_master_new
loadtime:0.98493909835815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperglade' limit 1
loadtime:0.98500514030457 / seconds
Query Executed:select id FROM `wv` where city='Upperglade' && SIC_code='7011'DB:business_master_new
loadtime:0.98552513122559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Bend' limit 1
loadtime:0.98558616638184 / seconds
Query Executed:select id FROM `wv` where city='Valley Bend' && SIC_code='7011'DB:business_master_new
loadtime:0.9862060546875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Fork' limit 1
loadtime:0.98626613616943 / seconds
Query Executed:select id FROM `wv` where city='Valley Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.98671197891235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Grove' limit 1
loadtime:0.98677706718445 / seconds
Query Executed:select id FROM `wv` where city='Valley Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.98769307136536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Head' limit 1
loadtime:0.98777008056641 / seconds
Query Executed:select id FROM `wv` where city='Valley Head' && SIC_code='7011'DB:business_master_new
loadtime:0.98848700523376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van' limit 1
loadtime:0.9885721206665 / seconds
Query Executed:select id FROM `wv` where city='Van' && SIC_code='7011'DB:business_master_new
loadtime:0.98922514915466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varney' limit 1
loadtime:0.98928809165955 / seconds
Query Executed:select id FROM `wv` where city='Varney' && SIC_code='7011'DB:business_master_new
loadtime:0.99000215530396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verdunville' limit 1
loadtime:0.99006509780884 / seconds
Query Executed:select id FROM `wv` where city='Verdunville' && SIC_code='7011'DB:business_master_new
loadtime:0.99074411392212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verner' limit 1
loadtime:0.99080514907837 / seconds
Query Executed:select id FROM `wv` where city='Verner' && SIC_code='7011'DB:business_master_new
loadtime:0.99132513999939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:0.99138998985291 / seconds
Query Executed:select id FROM `wv` where city='Victor' && SIC_code='7011'DB:business_master_new
loadtime:0.99194312095642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:0.99200701713562 / seconds
Query Executed:select id FROM `wv` where city='Vienna' && SIC_code='7011'DB:business_master_new
loadtime:0.9986720085144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:0.99875211715698 / seconds
Query Executed:select id FROM `wv` where city='Volga' && SIC_code='7011'DB:business_master_new
loadtime:0.99931216239929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadestown' limit 1
loadtime:0.99937415122986 / seconds
Query Executed:select id FROM `wv` where city='Wadestown' && SIC_code='7011'DB:business_master_new
loadtime:0.99986410140991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waiteville' limit 1
loadtime:0.99993801116943 / seconds
Query Executed:select id FROM `wv` where city='Waiteville' && SIC_code='7011'DB:business_master_new
loadtime:1.0003969669342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walker' limit 1
loadtime:1.0004580020905 / seconds
Query Executed:select id FROM `wv` where city='Walker' && SIC_code='7011'DB:business_master_new
loadtime:1.0012941360474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkersville' limit 1
loadtime:1.0013551712036 / seconds
Query Executed:select id FROM `wv` where city='Walkersville' && SIC_code='7011'DB:business_master_new
loadtime:1.0020570755005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:1.0021340847015 / seconds
Query Executed:select id FROM `wv` where city='Wallace' && SIC_code='7011'DB:business_master_new
loadtime:1.0026650428772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallback' limit 1
loadtime:1.0027270317078 / seconds
Query Executed:select id FROM `wv` where city='Wallback' && SIC_code='7011'DB:business_master_new
loadtime:1.0032210350037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walton' limit 1
loadtime:1.0032820701599 / seconds
Query Executed:select id FROM `wv` where city='Walton' && SIC_code='7011'DB:business_master_new
loadtime:1.0040061473846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wana' limit 1
loadtime:1.0040671825409 / seconds
Query Executed:select id FROM `wv` where city='Wana' && SIC_code='7011'DB:business_master_new
loadtime:1.0046451091766 / seconds
Query loaded from cache:select * from geodata_geocity where city='War' limit 1
loadtime:1.0047061443329 / seconds
Query Executed:select id FROM `wv` where city='War' && SIC_code='7011'DB:business_master_new
loadtime:1.0064949989319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardensville' limit 1
loadtime:1.0065701007843 / seconds
Query Executed:select id FROM `wv` where city='Wardensville' && SIC_code='7011'DB:business_master_new
loadtime:1.008308172226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warriormine' limit 1
loadtime:1.0083870887756 / seconds
Query Executed:select id FROM `wv` where city='Warriormine' && SIC_code='7011'DB:business_master_new
loadtime:1.0088410377502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwood' limit 1
loadtime:1.0089030265808 / seconds
Query Executed:select id FROM `wv` where city='Warwood' && SIC_code='7011'DB:business_master_new
loadtime:1.0094139575958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.009476184845 / seconds
Query Executed:select id FROM `wv` where city='Washington' && SIC_code='7011'DB:business_master_new
loadtime:1.0115129947662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.0115749835968 / seconds
Query Executed:select id FROM `wv` where city='Waverly' && SIC_code='7011'DB:business_master_new
loadtime:1.012374162674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:1.0124371051788 / seconds
Query Executed:select id FROM `wv` where city='Wayne' && SIC_code='7011'DB:business_master_new
loadtime:1.0156359672546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayside' limit 1
loadtime:1.0157120227814 / seconds
Query Executed:select id FROM `wv` where city='Wayside' && SIC_code='7011'DB:business_master_new
loadtime:1.0162131786346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster Springs' limit 1
loadtime:1.0162761211395 / seconds
Query Executed:select id FROM `wv` where city='Webster Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.0188360214233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirton' limit 1
loadtime:1.0189130306244 / seconds
Query Executed:select id FROM `wv` where city='Weirton' && SIC_code='7011'DB:business_master_new
loadtime:1.0254771709442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welch' limit 1
loadtime:1.0255591869354 / seconds
Query Executed:select id FROM `wv` where city='Welch' && SIC_code='7011'DB:business_master_new
loadtime:1.0296940803528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsburg' limit 1
loadtime:1.0297729969025 / seconds
Query Executed:select id FROM `wv` where city='Wellsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.0332391262054 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Columbia' limit 1
loadtime:1.0333020687103 / seconds
Query Executed:select id FROM `wv` where city='West Columbia' && SIC_code='7011'DB:business_master_new
loadtime:1.0338451862335 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hamlin' limit 1
loadtime:1.0339059829712 / seconds
Query Executed:select id FROM `wv` where city='West Hamlin' && SIC_code='7011'DB:business_master_new
loadtime:1.0355169773102 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Liberty' limit 1
loadtime:1.0355801582336 / seconds
Query Executed:select id FROM `wv` where city='West Liberty' && SIC_code='7011'DB:business_master_new
loadtime:1.0362570285797 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Logan' limit 1
loadtime:1.036318063736 / seconds
Query Executed:select id FROM `wv` where city='West Logan' && SIC_code='7011'DB:business_master_new
loadtime:1.0367841720581 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Milford' limit 1
loadtime:1.0368449687958 / seconds
Query Executed:select id FROM `wv` where city='West Milford' && SIC_code='7011'DB:business_master_new
loadtime:1.0375781059265 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:1.0376479625702 / seconds
Query Executed:select id FROM `wv` where city='West Union' && SIC_code='7011'DB:business_master_new
loadtime:1.040009021759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:1.0400719642639 / seconds
Query Executed:select id FROM `wv` where city='Weston' && SIC_code='7011'DB:business_master_new
loadtime:1.0453581809998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westover' limit 1
loadtime:1.0454421043396 / seconds
Query Executed:select id FROM `wv` where city='Westover' && SIC_code='7011'DB:business_master_new
loadtime:1.0458991527557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wharncliffe' limit 1
loadtime:1.0459611415863 / seconds
Query Executed:select id FROM `wv` where city='Wharncliffe' && SIC_code='7011'DB:business_master_new
loadtime:1.0465459823608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wharton' limit 1
loadtime:1.0466210842133 / seconds
Query Executed:select id FROM `wv` where city='Wharton' && SIC_code='7011'DB:business_master_new
loadtime:1.0472509860992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeling' limit 1
loadtime:1.0473129749298 / seconds
Query Executed:select id FROM `wv` where city='Wheeling' && SIC_code='7011'DB:business_master_new
loadtime:1.053649187088 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Oak' limit 1
loadtime:1.053740978241 / seconds
Query Executed:select id FROM `wv` where city='White Oak' && SIC_code='7011'DB:business_master_new
loadtime:1.0543069839478 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Slphr Spgs' limit 1
loadtime:1.0543711185455 / seconds
Query Executed:select id FROM `wv` where city='White Slphr Spgs' && SIC_code='7011'DB:business_master_new
loadtime:1.0548961162567 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Sulphur Springs' limit 1
loadtime:1.0549581050873 / seconds
Query Executed:select id FROM `wv` where city='White Sulphur Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.0581121444702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitesville' limit 1
loadtime:1.0582101345062 / seconds
Query Executed:select id FROM `wv` where city='Whitesville' && SIC_code='7011'DB:business_master_new
loadtime:1.0598940849304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:1.0599839687347 / seconds
Query Executed:select id FROM `wv` where city='Whitman' && SIC_code='7011'DB:business_master_new
loadtime:1.0607399940491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmer' limit 1
loadtime:1.0608031749725 / seconds
Query Executed:select id FROM `wv` where city='Whitmer' && SIC_code='7011'DB:business_master_new
loadtime:1.0612931251526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Widen' limit 1
loadtime:1.0613541603088 / seconds
Query Executed:select id FROM `wv` where city='Widen' && SIC_code='7011'DB:business_master_new
loadtime:1.0618290901184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilcoe' limit 1
loadtime:1.0618901252747 / seconds
Query Executed:select id FROM `wv` where city='Wilcoe' && SIC_code='7011'DB:business_master_new
loadtime:1.0624451637268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiley Ford' limit 1
loadtime:1.0625059604645 / seconds
Query Executed:select id FROM `wv` where city='Wiley Ford' && SIC_code='7011'DB:business_master_new
loadtime:1.0632350444794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wileyville' limit 1
loadtime:1.0632960796356 / seconds
Query Executed:select id FROM `wv` where city='Wileyville' && SIC_code='7011'DB:business_master_new
loadtime:1.0638041496277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinson' limit 1
loadtime:1.0638651847839 / seconds
Query Executed:select id FROM `wv` where city='Wilkinson' && SIC_code='7011'DB:business_master_new
loadtime:1.0646650791168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.0647439956665 / seconds
Query Executed:select id FROM `wv` where city='Williamsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.0653741359711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamson' limit 1
loadtime:1.0654361248016 / seconds
Query Executed:select id FROM `wv` where city='Williamson' && SIC_code='7011'DB:business_master_new
loadtime:1.0700941085815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:1.0701861381531 / seconds
Query Executed:select id FROM `wv` where city='Williamstown' && SIC_code='7011'DB:business_master_new
loadtime:1.0733561515808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Island' limit 1
loadtime:1.073438167572 / seconds
Query Executed:select id FROM `wv` where city='Willow Island' && SIC_code='7011'DB:business_master_new
loadtime:1.0739409923553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsie' limit 1
loadtime:1.0740880966187 / seconds
Query Executed:select id FROM `wv` where city='Wilsie' && SIC_code='7011'DB:business_master_new
loadtime:1.0745911598206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsonburg' limit 1
loadtime:1.0746531486511 / seconds
Query Executed:select id FROM `wv` where city='Wilsonburg' && SIC_code='7011'DB:business_master_new
loadtime:1.075159072876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsondale' limit 1
loadtime:1.0752201080322 / seconds
Query Executed:select id FROM `wv` where city='Wilsondale' && SIC_code='7011'DB:business_master_new
loadtime:1.0756859779358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Heights' limit 1
loadtime:1.0757501125336 / seconds
Query Executed:select id FROM `wv` where city='Windsor Heights' && SIC_code='7011'DB:business_master_new
loadtime:1.0763001441956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:1.0763649940491 / seconds
Query Executed:select id FROM `wv` where city='Winfield' && SIC_code='7011'DB:business_master_new
loadtime:1.0796070098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winifrede' limit 1
loadtime:1.0796689987183 / seconds
Query Executed:select id FROM `wv` where city='Winifrede' && SIC_code='7011'DB:business_master_new
loadtime:1.0802030563354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winona' limit 1
loadtime:1.080265045166 / seconds
Query Executed:select id FROM `wv` where city='Winona' && SIC_code='7011'DB:business_master_new
loadtime:1.0807189941406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolf Pen' limit 1
loadtime:1.0807950496674 / seconds
Query Executed:select id FROM `wv` where city='Wolf Pen' && SIC_code='7011'DB:business_master_new
loadtime:1.0812361240387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolf Summit' limit 1
loadtime:1.0813009738922 / seconds
Query Executed:select id FROM `wv` where city='Wolf Summit' && SIC_code='7011'DB:business_master_new
loadtime:1.0817260742188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfcreek' limit 1
loadtime:1.081787109375 / seconds
Query Executed:select id FROM `wv` where city='Wolfcreek' && SIC_code='7011'DB:business_master_new
loadtime:1.0822441577911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfe' limit 1
loadtime:1.0823090076447 / seconds
Query Executed:select id FROM `wv` where city='Wolfe' && SIC_code='7011'DB:business_master_new
loadtime:1.0827419757843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:1.0828020572662 / seconds
Query Executed:select id FROM `wv` where city='Woodville' && SIC_code='7011'DB:business_master_new
loadtime:1.0832300186157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worth' limit 1
loadtime:1.0832901000977 / seconds
Query Executed:select id FROM `wv` where city='Worth' && SIC_code='7011'DB:business_master_new
loadtime:1.0837230682373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:1.0837831497192 / seconds
Query Executed:select id FROM `wv` where city='Worthington' && SIC_code='7011'DB:business_master_new
loadtime:1.0845019817352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyatt' limit 1
loadtime:1.0845620632172 / seconds
Query Executed:select id FROM `wv` where city='Wyatt' && SIC_code='7011'DB:business_master_new
loadtime:1.0850470066071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyco' limit 1
loadtime:1.0851080417633 / seconds
Query Executed:select id FROM `wv` where city='Wyco' && SIC_code='7011'DB:business_master_new
loadtime:1.0855569839478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:1.085618019104 / seconds
Query Executed:select id FROM `wv` where city='Wyoming' && SIC_code='7011'DB:business_master_new
loadtime:1.0860891342163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yawkey' limit 1
loadtime:1.0861611366272 / seconds
Query Executed:select id FROM `wv` where city='Yawkey' && SIC_code='7011'DB:business_master_new
loadtime:1.0867600440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yellow Spring' limit 1
loadtime:1.0868201255798 / seconds
Query Executed:select id FROM `wv` where city='Yellow Spring' && SIC_code='7011'DB:business_master_new
loadtime:1.0874030590057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yolyn' limit 1
loadtime:1.0874781608582 / seconds
Query Executed:select id FROM `wv` where city='Yolyn' && SIC_code='7011'DB:business_master_new
loadtime:1.0880060195923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yukon' limit 1
loadtime:1.0880670547485 / seconds
Query Executed:select id FROM `wv` where city='Yukon' && SIC_code='7011'DB:business_master_new
loadtime:1.0885741710663 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.0887241363525 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.0892519950867 / seconds
Operation template executed (chunk cache operation)
loadtime:1.0894150733948 / seconds
template override:Default
loadtime:1.0894570350647 / 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:1.090754032135 / seconds
Template Constructed, Array Rows:49
loadtime:1.0912909507751 / seconds
TOTAL EXECUTION TIME: 1.09084
loadtime:1.0931851863861 / 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] => hotels-and-motels [stateURLid] => west-virginia )


_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:1.0931961536407
TOTAL KEY ARRAYS: 69