Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.6069107055664E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00050497055053711 / seconds
host not found setting manual db connection
loadtime:0.0011429786682129 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0014400482177734 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0016541481018066 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0017099380493164 / seconds
zipcode:
loadtime:0.0017280578613281 / seconds
Query Executed:select * from search_referrer where page_hash='46606a3ac2d60ff0c80e8c5173d0754d' limit 10 DB:ezrox_toadli
loadtime:0.0019519329071045 / seconds
Operation header executed (non global)
loadtime:0.0019700527191162 / seconds
Operation leaderboard executed (non global)
loadtime:0.0020129680633545 / seconds
Operation square executed (non global)
loadtime:0.0020270347595215 / seconds
Operation square_bottom executed (non global)
loadtime:0.0020389556884766 / seconds
Operation smallsquare executed (non global)
loadtime:0.0020511150360107 / seconds
Operation headeradright executed (non global)
loadtime:0.0020620822906494 / seconds
Operation google_analytics executed (non global)
loadtime:0.0020730495452881 / seconds
Operation topstories executed (non global)
loadtime:0.0020840167999268 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0020949840545654 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0021049976348877 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0023391246795654 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0024900436401367 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0025291442871094 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.002593994140625 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0026400089263916 / seconds
Template key: archive_menu pushed
loadtime:0.0026450157165527 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0026509761810303 / seconds
Template key: get_gravatar pushed
loadtime:0.0026559829711914 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0026600360870361 / seconds
*10)-10)+1 | start:0
loadtime:0.0026841163635254 / seconds
Query loaded from cache:select * from categories where cat_URLid='religious-organizations'
loadtime:0.0032229423522949 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.0032620429992676 / seconds
DB connected to localhost business_master_new
loadtime:0.0035219192504883 / seconds
Query Executed:select * from `va_catmap` where sic='8661' order by city ascDB:business_master_new
loadtime:0.15840697288513 / seconds
Query stored in cache : _QUERY_www.toadli.come8129c53d333b96536d12d9c82237f71
loadtime:0.16029715538025 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.16041994094849 / seconds
Query Executed:select sum(totalcount) as totalsum from `va_catmap` where sic='8661'DB:business_master_new
loadtime:0.16562008857727 / seconds
Query stored in cache : _QUERY_www.toadli.comaa42ee0b1340a3a6f6dac4851f3207ef
loadtime:0.16565299034119 / seconds
942 / 11
loadtime:0.16569495201111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abingdon' limit 1
loadtime:0.1657440662384 / seconds
Query Executed:select id FROM `va` where city='Abingdon' && SIC_code='8661'DB:business_master_new
loadtime:0.24205803871155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accomac' limit 1
loadtime:0.24216914176941 / seconds
Query Executed:select id FROM `va` where city='Accomac' && SIC_code='8661'DB:business_master_new
loadtime:0.27109313011169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Achilles' limit 1
loadtime:0.27116107940674 / seconds
Query Executed:select id FROM `va` where city='Achilles' && SIC_code='8661'DB:business_master_new
loadtime:0.27153205871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.27158093452454 / seconds
Query Executed:select id FROM `va` where city='Afton' && SIC_code='8661'DB:business_master_new
loadtime:0.35985803604126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alberta' limit 1
loadtime:0.36001896858215 / seconds
Query Executed:select id FROM `va` where city='Alberta' && SIC_code='8661'DB:business_master_new
loadtime:0.36102914810181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aldie' limit 1
loadtime:0.36108708381653 / seconds
Query Executed:select id FROM `va` where city='Aldie' && SIC_code='8661'DB:business_master_new
loadtime:0.37824702262878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.37831211090088 / seconds
Query Executed:select id FROM `va` where city='Alexandria' && SIC_code='8661'DB:business_master_new
loadtime:0.43151211738586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleghany' limit 1
loadtime:0.432049036026 / seconds
Query Executed:select id FROM `va` where city='Alleghany' && SIC_code='8661'DB:business_master_new
loadtime:0.43297696113586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allisonia' limit 1
loadtime:0.4331591129303 / seconds
Query Executed:select id FROM `va` where city='Allisonia' && SIC_code='8661'DB:business_master_new
loadtime:0.43359303474426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altavista' limit 1
loadtime:0.4336359500885 / seconds
Query Executed:select id FROM `va` where city='Altavista' && SIC_code='8661'DB:business_master_new
loadtime:0.47930407524109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.47938108444214 / seconds
Query Executed:select id FROM `va` where city='Alton' && SIC_code='8661'DB:business_master_new
loadtime:0.48024296760559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Ridge' limit 1
loadtime:0.48031806945801 / seconds
Query Executed:select id FROM `va` where city='Alum Ridge' && SIC_code='8661'DB:business_master_new
loadtime:0.48056602478027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court House' limit 1
loadtime:0.48060011863708 / seconds
Query Executed:select id FROM `va` where city='Amelia Court House' && SIC_code='8661'DB:business_master_new
loadtime:0.49110198020935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court Hse' limit 1
loadtime:0.49120211601257 / seconds
Query Executed:select id FROM `va` where city='Amelia Court Hse' && SIC_code='8661'DB:business_master_new
loadtime:0.49166703224182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.49173092842102 / seconds
Query Executed:select id FROM `va` where city='Amherst' && SIC_code='8661'DB:business_master_new
loadtime:0.54050707817078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amissville' limit 1
loadtime:0.54060006141663 / seconds
Query Executed:select id FROM `va` where city='Amissville' && SIC_code='8661'DB:business_master_new
loadtime:0.55634498596191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ammon' limit 1
loadtime:0.55641794204712 / seconds
Query Executed:select id FROM `va` where city='Ammon' && SIC_code='8661'DB:business_master_new
loadtime:0.55667614936829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amonate' limit 1
loadtime:0.55671095848083 / seconds
Query Executed:select id FROM `va` where city='Amonate' && SIC_code='8661'DB:business_master_new
loadtime:0.55700397491455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.55703997612 / seconds
Query Executed:select id FROM `va` where city='Andover' && SIC_code='8661'DB:business_master_new
loadtime:0.55734801292419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.55738496780396 / seconds
Query Executed:select id FROM `va` where city='Annandale' && SIC_code='8661'DB:business_master_new
loadtime:0.57200598716736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appalachia' limit 1
loadtime:0.57210898399353 / seconds
Query Executed:select id FROM `va` where city='Appalachia' && SIC_code='8661'DB:business_master_new
loadtime:0.57333111763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appomattox' limit 1
loadtime:0.57340312004089 / seconds
Query Executed:select id FROM `va` where city='Appomattox' && SIC_code='8661'DB:business_master_new
loadtime:0.61467599868774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.61475706100464 / seconds
Query Executed:select id FROM `va` where city='Ararat' && SIC_code='8661'DB:business_master_new
loadtime:0.61578392982483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.61585307121277 / seconds
Query Executed:select id FROM `va` where city='Arcola' && SIC_code='8661'DB:business_master_new
loadtime:0.61634302139282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ark' limit 1
loadtime:0.61638307571411 / seconds
Query Executed:select id FROM `va` where city='Ark' && SIC_code='8661'DB:business_master_new
loadtime:0.61678695678711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.61684393882751 / seconds
Query Executed:select id FROM `va` where city='Arlington' && SIC_code='8661'DB:business_master_new
loadtime:0.65179395675659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aroda' limit 1
loadtime:0.65196204185486 / seconds
Query Executed:select id FROM `va` where city='Aroda' && SIC_code='8661'DB:business_master_new
loadtime:0.65243911743164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrington' limit 1
loadtime:0.65249300003052 / seconds
Query Executed:select id FROM `va` where city='Arrington' && SIC_code='8661'DB:business_master_new
loadtime:0.65342998504639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvonia' limit 1
loadtime:0.65348601341248 / seconds
Query Executed:select id FROM `va` where city='Arvonia' && SIC_code='8661'DB:business_master_new
loadtime:0.6540629863739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburn' limit 1
loadtime:0.65412712097168 / seconds
Query Executed:select id FROM `va` where city='Ashburn' && SIC_code='8661'DB:business_master_new
loadtime:0.66523313522339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.66531014442444 / seconds
Query Executed:select id FROM `va` where city='Ashland' && SIC_code='8661'DB:business_master_new
loadtime:0.67719602584839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assawoman' limit 1
loadtime:0.67727208137512 / seconds
Query Executed:select id FROM `va` where city='Assawoman' && SIC_code='8661'DB:business_master_new
loadtime:0.67760992050171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.67766499519348 / seconds
Query Executed:select id FROM `va` where city='Atkins' && SIC_code='8661'DB:business_master_new
loadtime:0.67866802215576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.67873001098633 / seconds
Query Executed:select id FROM `va` where city='Atlantic' && SIC_code='8661'DB:business_master_new
loadtime:0.67928695678711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta Springs' limit 1
loadtime:0.67933297157288 / seconds
Query Executed:select id FROM `va` where city='Augusta Springs' && SIC_code='8661'DB:business_master_new
loadtime:0.6796441078186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.67970204353333 / seconds
Query Executed:select id FROM `va` where city='Austinville' && SIC_code='8661'DB:business_master_new
loadtime:0.68050003051758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axton' limit 1
loadtime:0.68054795265198 / seconds
Query Executed:select id FROM `va` where city='Axton' && SIC_code='8661'DB:business_master_new
loadtime:0.69985198974609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aylett' limit 1
loadtime:0.69993209838867 / seconds
Query Executed:select id FROM `va` where city='Aylett' && SIC_code='8661'DB:business_master_new
loadtime:0.71376204490662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bacova' limit 1
loadtime:0.71381092071533 / seconds
Query Executed:select id FROM `va` where city='Bacova' && SIC_code='8661'DB:business_master_new
loadtime:0.71413207054138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Crossrds' limit 1
loadtime:0.71417593955994 / seconds
Query Executed:select id FROM `va` where city='Baileys Crossrds' && SIC_code='8661'DB:business_master_new
loadtime:0.71456813812256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banco' limit 1
loadtime:0.714604139328 / seconds
Query Executed:select id FROM `va` where city='Banco' && SIC_code='8661'DB:business_master_new
loadtime:0.71487212181091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bandy' limit 1
loadtime:0.71491599082947 / seconds
Query Executed:select id FROM `va` where city='Bandy' && SIC_code='8661'DB:business_master_new
loadtime:0.71523094177246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barboursville' limit 1
loadtime:0.71528100967407 / seconds
Query Executed:select id FROM `va` where city='Barboursville' && SIC_code='8661'DB:business_master_new
loadtime:0.72477602958679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barhamsville' limit 1
loadtime:0.72482514381409 / seconds
Query Executed:select id FROM `va` where city='Barhamsville' && SIC_code='8661'DB:business_master_new
loadtime:0.72554302215576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barren Springs' limit 1
loadtime:0.72559714317322 / seconds
Query Executed:select id FROM `va` where city='Barren Springs' && SIC_code='8661'DB:business_master_new
loadtime:0.72594094276428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baskerville' limit 1
loadtime:0.72598814964294 / seconds
Query Executed:select id FROM `va` where city='Baskerville' && SIC_code='8661'DB:business_master_new
loadtime:0.72648596763611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.72653603553772 / seconds
Query Executed:select id FROM `va` where city='Bassett' && SIC_code='8661'DB:business_master_new
loadtime:0.73516702651978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bastian' limit 1
loadtime:0.73527407646179 / seconds
Query Executed:select id FROM `va` where city='Bastian' && SIC_code='8661'DB:business_master_new
loadtime:0.7358980178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basye' limit 1
loadtime:0.73595404624939 / seconds
Query Executed:select id FROM `va` where city='Basye' && SIC_code='8661'DB:business_master_new
loadtime:0.73686408996582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.73692393302917 / seconds
Query Executed:select id FROM `va` where city='Batesville' && SIC_code='8661'DB:business_master_new
loadtime:0.73730611801147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battery Park' limit 1
loadtime:0.73735404014587 / seconds
Query Executed:select id FROM `va` where city='Battery Park' && SIC_code='8661'DB:business_master_new
loadtime:0.73767805099487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bavon' limit 1
loadtime:0.73772597312927 / seconds
Query Executed:select id FROM `va` where city='Bavon' && SIC_code='8661'DB:business_master_new
loadtime:0.73797106742859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bealeton' limit 1
loadtime:0.73801207542419 / seconds
Query Executed:select id FROM `va` where city='Bealeton' && SIC_code='8661'DB:business_master_new
loadtime:0.75843000411987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.75853705406189 / seconds
Query Executed:select id FROM `va` where city='Beaumont' && SIC_code='8661'DB:business_master_new
loadtime:0.75887703895569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverdam' limit 1
loadtime:0.75893306732178 / seconds
Query Executed:select id FROM `va` where city='Beaverdam' && SIC_code='8661'DB:business_master_new
loadtime:0.76734113693237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverlett' limit 1
loadtime:0.76740503311157 / seconds
Query Executed:select id FROM `va` where city='Beaverlett' && SIC_code='8661'DB:business_master_new
loadtime:0.76769614219666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.76773500442505 / seconds
Query Executed:select id FROM `va` where city='Bedford' && SIC_code='8661'DB:business_master_new
loadtime:0.77775192260742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bee' limit 1
loadtime:0.77785706520081 / seconds
Query Executed:select id FROM `va` where city='Bee' && SIC_code='8661'DB:business_master_new
loadtime:0.77820110321045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellamy' limit 1
loadtime:0.77823805809021 / seconds
Query Executed:select id FROM `va` where city='Bellamy' && SIC_code='8661'DB:business_master_new
loadtime:0.77861404418945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Haven' limit 1
loadtime:0.77875304222107 / seconds
Query Executed:select id FROM `va` where city='Belle Haven' && SIC_code='8661'DB:business_master_new
loadtime:0.79896807670593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belspring' limit 1
loadtime:0.79914212226868 / seconds
Query Executed:select id FROM `va` where city='Belspring' && SIC_code='8661'DB:business_master_new
loadtime:0.79978609085083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ben Hur' limit 1
loadtime:0.79983115196228 / seconds
Query Executed:select id FROM `va` where city='Ben Hur' && SIC_code='8661'DB:business_master_new
loadtime:0.80083203315735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bena' limit 1
loadtime:0.80095410346985 / seconds
Query Executed:select id FROM `va` where city='Bena' && SIC_code='8661'DB:business_master_new
loadtime:0.80188298225403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent Mountain' limit 1
loadtime:0.80199408531189 / seconds
Query Executed:select id FROM `va` where city='Bent Mountain' && SIC_code='8661'DB:business_master_new
loadtime:0.80363893508911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonville' limit 1
loadtime:0.80377006530762 / seconds
Query Executed:select id FROM `va` where city='Bentonville' && SIC_code='8661'DB:business_master_new
loadtime:0.80586194992065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergton' limit 1
loadtime:0.80596399307251 / seconds
Query Executed:select id FROM `va` where city='Bergton' && SIC_code='8661'DB:business_master_new
loadtime:0.80709314346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berryville' limit 1
loadtime:0.80714201927185 / seconds
Query Executed:select id FROM `va` where city='Berryville' && SIC_code='8661'DB:business_master_new
loadtime:0.81914496421814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Island' limit 1
loadtime:0.81925106048584 / seconds
Query Executed:select id FROM `va` where city='Big Island' && SIC_code='8661'DB:business_master_new
loadtime:0.8201470375061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.82025098800659 / seconds
Query Executed:select id FROM `va` where city='Big Rock' && SIC_code='8661'DB:business_master_new
loadtime:0.82085013389587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone Gap' limit 1
loadtime:0.82089996337891 / seconds
Query Executed:select id FROM `va` where city='Big Stone Gap' && SIC_code='8661'DB:business_master_new
loadtime:0.82639503479004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchleaf' limit 1
loadtime:0.82646298408508 / seconds
Query Executed:select id FROM `va` where city='Birchleaf' && SIC_code='8661'DB:business_master_new
loadtime:0.82686305046082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birdsnest' limit 1
loadtime:0.82690405845642 / seconds
Query Executed:select id FROM `va` where city='Birdsnest' && SIC_code='8661'DB:business_master_new
loadtime:0.82729315757751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishop' limit 1
loadtime:0.8273389339447 / seconds
Query Executed:select id FROM `va` where city='Bishop' && SIC_code='8661'DB:business_master_new
loadtime:0.82765913009644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackridge' limit 1
loadtime:0.82770109176636 / seconds
Query Executed:select id FROM `va` where city='Blackridge' && SIC_code='8661'DB:business_master_new
loadtime:0.82798314094543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.82801795005798 / seconds
Query Executed:select id FROM `va` where city='Blacksburg' && SIC_code='8661'DB:business_master_new
loadtime:0.8417489528656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.84185409545898 / seconds
Query Executed:select id FROM `va` where city='Blackstone' && SIC_code='8661'DB:business_master_new
loadtime:0.87076306343079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwater' limit 1
loadtime:0.87085008621216 / seconds
Query Executed:select id FROM `va` where city='Blackwater' && SIC_code='8661'DB:business_master_new
loadtime:0.87125611305237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairs' limit 1
loadtime:0.87130403518677 / seconds
Query Executed:select id FROM `va` where city='Blairs' && SIC_code='8661'DB:business_master_new
loadtime:0.87688899040222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakes' limit 1
loadtime:0.87692904472351 / seconds
Query Executed:select id FROM `va` where city='Blakes' && SIC_code='8661'DB:business_master_new
loadtime:0.8771710395813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bland' limit 1
loadtime:0.87722706794739 / seconds
Query Executed:select id FROM `va` where city='Bland' && SIC_code='8661'DB:business_master_new
loadtime:0.88939905166626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloxom' limit 1
loadtime:0.88946008682251 / seconds
Query Executed:select id FROM `va` where city='Bloxom' && SIC_code='8661'DB:business_master_new
loadtime:0.89011192321777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.89015197753906 / seconds
Query Executed:select id FROM `va` where city='Blue Grass' && SIC_code='8661'DB:business_master_new
loadtime:0.8906569480896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Ridge' limit 1
loadtime:0.89070510864258 / seconds
Query Executed:select id FROM `va` where city='Blue Ridge' && SIC_code='8661'DB:business_master_new
loadtime:0.89818000793457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:0.89824104309082 / seconds
Query Executed:select id FROM `va` where city='Bluefield' && SIC_code='8661'DB:business_master_new
loadtime:0.90677213668823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluemont' limit 1
loadtime:0.90684509277344 / seconds
Query Executed:select id FROM `va` where city='Bluemont' && SIC_code='8661'DB:business_master_new
loadtime:0.91364312171936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bohannon' limit 1
loadtime:0.9137179851532 / seconds
Query Executed:select id FROM `va` where city='Bohannon' && SIC_code='8661'DB:business_master_new
loadtime:0.91406011581421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boissevain' limit 1
loadtime:0.91411209106445 / seconds
Query Executed:select id FROM `va` where city='Boissevain' && SIC_code='8661'DB:business_master_new
loadtime:0.9144561290741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolar' limit 1
loadtime:0.91449499130249 / seconds
Query Executed:select id FROM `va` where city='Bolar' && SIC_code='8661'DB:business_master_new
loadtime:0.91474294662476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:0.91478395462036 / seconds
Query Executed:select id FROM `va` where city='Bon Air' && SIC_code='8661'DB:business_master_new
loadtime:0.91536712646484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boones Mill' limit 1
loadtime:0.91540598869324 / seconds
Query Executed:select id FROM `va` where city='Boones Mill' && SIC_code='8661'DB:business_master_new
loadtime:0.93075704574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.93080997467041 / seconds
Query Executed:select id FROM `va` where city='Boston' && SIC_code='8661'DB:business_master_new
loadtime:0.93139815330505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.93145203590393 / seconds
Query Executed:select id FROM `va` where city='Bowling Green' && SIC_code='8661'DB:business_master_new
loadtime:0.94353604316711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyce' limit 1
loadtime:0.94358897209167 / seconds
Query Executed:select id FROM `va` where city='Boyce' && SIC_code='8661'DB:business_master_new
loadtime:0.95087194442749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boydton' limit 1
loadtime:0.95092701911926 / seconds
Query Executed:select id FROM `va` where city='Boydton' && SIC_code='8661'DB:business_master_new
loadtime:0.95941209793091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykins' limit 1
loadtime:0.9594669342041 / seconds
Query Executed:select id FROM `va` where city='Boykins' && SIC_code='8661'DB:business_master_new
loadtime:0.96379899978638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bracey' limit 1
loadtime:0.96386098861694 / seconds
Query Executed:select id FROM `va` where city='Bracey' && SIC_code='8661'DB:business_master_new
loadtime:0.96962594985962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.96968603134155 / seconds
Query Executed:select id FROM `va` where city='Branchville' && SIC_code='8661'DB:business_master_new
loadtime:0.97010493278503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandy Station' limit 1
loadtime:0.9701509475708 / seconds
Query Executed:select id FROM `va` where city='Brandy Station' && SIC_code='8661'DB:business_master_new
loadtime:0.97095894813538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breaks' limit 1
loadtime:0.97099709510803 / seconds
Query Executed:select id FROM `va` where city='Breaks' && SIC_code='8661'DB:business_master_new
loadtime:0.9713499546051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremo Bluff' limit 1
loadtime:0.97140097618103 / seconds
Query Executed:select id FROM `va` where city='Bremo Bluff' && SIC_code='8661'DB:business_master_new
loadtime:0.97177314758301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.97181510925293 / seconds
Query Executed:select id FROM `va` where city='Bridgewater' && SIC_code='8661'DB:business_master_new
loadtime:0.98427700996399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:0.98438811302185 / seconds
Query Executed:select id FROM `va` where city='Brightwood' && SIC_code='8661'DB:business_master_new
loadtime:0.98490309715271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.98495101928711 / seconds
Query Executed:select id FROM `va` where city='Bristol' && SIC_code='8661'DB:business_master_new
loadtime:0.99325704574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.99335813522339 / seconds
Query Executed:select id FROM `va` where city='Bristow' && SIC_code='8661'DB:business_master_new
loadtime:1.0034980773926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Run' limit 1
loadtime:1.0035750865936 / seconds
Query Executed:select id FROM `va` where city='Broad Run' && SIC_code='8661'DB:business_master_new
loadtime:1.0108590126038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadford' limit 1
loadtime:1.0109081268311 / seconds
Query Executed:select id FROM `va` where city='Broadford' && SIC_code='8661'DB:business_master_new
loadtime:1.0112519264221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:1.0112979412079 / seconds
Query Executed:select id FROM `va` where city='Broadway' && SIC_code='8661'DB:business_master_new
loadtime:1.0194010734558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodnax' limit 1
loadtime:1.0194640159607 / seconds
Query Executed:select id FROM `va` where city='Brodnax' && SIC_code='8661'DB:business_master_new
loadtime:1.0243179798126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooke' limit 1
loadtime:1.0243639945984 / seconds
Query Executed:select id FROM `va` where city='Brooke' && SIC_code='8661'DB:business_master_new
loadtime:1.0246651172638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookneal' limit 1
loadtime:1.0247139930725 / seconds
Query Executed:select id FROM `va` where city='Brookneal' && SIC_code='8661'DB:business_master_new
loadtime:1.0331439971924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsburg' limit 1
loadtime:1.0332860946655 / seconds
Query Executed:select id FROM `va` where city='Brownsburg' && SIC_code='8661'DB:business_master_new
loadtime:1.0338449478149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brucetown' limit 1
loadtime:1.0339040756226 / seconds
Query Executed:select id FROM `va` where city='Brucetown' && SIC_code='8661'DB:business_master_new
loadtime:1.0343549251556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruington' limit 1
loadtime:1.0344190597534 / seconds
Query Executed:select id FROM `va` where city='Bruington' && SIC_code='8661'DB:business_master_new
loadtime:1.0348119735718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:1.0349190235138 / seconds
Query Executed:select id FROM `va` where city='Buchanan' && SIC_code='8661'DB:business_master_new
loadtime:1.04123711586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:1.041316986084 / seconds
Query Executed:select id FROM `va` where city='Buckingham' && SIC_code='8661'DB:business_master_new
loadtime:1.0450370311737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:1.0451290607452 / seconds
Query Executed:select id FROM `va` where city='Buena Vista' && SIC_code='8661'DB:business_master_new
loadtime:1.0507609844208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Junction' limit 1
loadtime:1.0508360862732 / seconds
Query Executed:select id FROM `va` where city='Buffalo Junction' && SIC_code='8661'DB:business_master_new
loadtime:1.0516519546509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bumpass' limit 1
loadtime:1.0516929626465 / seconds
Query Executed:select id FROM `va` where city='Bumpass' && SIC_code='8661'DB:business_master_new
loadtime:1.0569491386414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgess' limit 1
loadtime:1.0570170879364 / seconds
Query Executed:select id FROM `va` where city='Burgess' && SIC_code='8661'DB:business_master_new
loadtime:1.0627291202545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:1.0627861022949 / seconds
Query Executed:select id FROM `va` where city='Burke' && SIC_code='8661'DB:business_master_new
loadtime:1.0688700675964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkes Garden' limit 1
loadtime:1.0689480304718 / seconds
Query Executed:select id FROM `va` where city='Burkes Garden' && SIC_code='8661'DB:business_master_new
loadtime:1.0692780017853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkeville' limit 1
loadtime:1.0693249702454 / seconds
Query Executed:select id FROM `va` where city='Burkeville' && SIC_code='8661'DB:business_master_new
loadtime:1.0716459751129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:1.0717051029205 / seconds
Query Executed:select id FROM `va` where city='Burnsville' && SIC_code='8661'DB:business_master_new
loadtime:1.0720419883728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Hill' limit 1
loadtime:1.0721049308777 / seconds
Query Executed:select id FROM `va` where city='Burr Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.0724320411682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callands' limit 1
loadtime:1.0724711418152 / seconds
Query Executed:select id FROM `va` where city='Callands' && SIC_code='8661'DB:business_master_new
loadtime:1.0730941295624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callao' limit 1
loadtime:1.0731561183929 / seconds
Query Executed:select id FROM `va` where city='Callao' && SIC_code='8661'DB:business_master_new
loadtime:1.0776460170746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callaway' limit 1
loadtime:1.0777380466461 / seconds
Query Executed:select id FROM `va` where city='Callaway' && SIC_code='8661'DB:business_master_new
loadtime:1.0785989761353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calverton' limit 1
loadtime:1.0786509513855 / seconds
Query Executed:select id FROM `va` where city='Calverton' && SIC_code='8661'DB:business_master_new
loadtime:1.0792150497437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cana' limit 1
loadtime:1.0792670249939 / seconds
Query Executed:select id FROM `va` where city='Cana' && SIC_code='8661'DB:business_master_new
loadtime:1.0814559459686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Charles' limit 1
loadtime:1.0815160274506 / seconds
Query Executed:select id FROM `va` where city='Cape Charles' && SIC_code='8661'DB:business_master_new
loadtime:1.0879859924316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capeville' limit 1
loadtime:1.0880630016327 / seconds
Query Executed:select id FROM `va` where city='Capeville' && SIC_code='8661'DB:business_master_new
loadtime:1.0883820056915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capron' limit 1
loadtime:1.0884349346161 / seconds
Query Executed:select id FROM `va` where city='Capron' && SIC_code='8661'DB:business_master_new
loadtime:1.0908489227295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardinal' limit 1
loadtime:1.0908889770508 / seconds
Query Executed:select id FROM `va` where city='Cardinal' && SIC_code='8661'DB:business_master_new
loadtime:1.091206073761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caret' limit 1
loadtime:1.0912489891052 / seconds
Query Executed:select id FROM `va` where city='Caret' && SIC_code='8661'DB:business_master_new
loadtime:1.0916221141815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:1.0916681289673 / seconds
Query Executed:select id FROM `va` where city='Carrollton' && SIC_code='8661'DB:business_master_new
loadtime:1.0977120399475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrsville' limit 1
loadtime:1.0977730751038 / seconds
Query Executed:select id FROM `va` where city='Carrsville' && SIC_code='8661'DB:business_master_new
loadtime:1.0984330177307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:1.098482131958 / seconds
Query Executed:select id FROM `va` where city='Carson' && SIC_code='8661'DB:business_master_new
loadtime:1.0990979671478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cartersville' limit 1
loadtime:1.0991430282593 / seconds
Query Executed:select id FROM `va` where city='Cartersville' && SIC_code='8661'DB:business_master_new
loadtime:1.0997569561005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casanova' limit 1
loadtime:1.0997929573059 / seconds
Query Executed:select id FROM `va` where city='Casanova' && SIC_code='8661'DB:business_master_new
loadtime:1.1001670360565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:1.1002309322357 / seconds
Query Executed:select id FROM `va` where city='Cascade' && SIC_code='8661'DB:business_master_new
loadtime:1.1008751392365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:1.1009230613708 / seconds
Query Executed:select id FROM `va` where city='Castleton' && SIC_code='8661'DB:business_master_new
loadtime:1.1014339923859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:1.1014800071716 / seconds
Query Executed:select id FROM `va` where city='Castlewood' && SIC_code='8661'DB:business_master_new
loadtime:1.1053440570831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:1.1054310798645 / seconds
Query Executed:select id FROM `va` where city='Catawba' && SIC_code='8661'DB:business_master_new
loadtime:1.1060140132904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharpin' limit 1
loadtime:1.1060619354248 / seconds
Query Executed:select id FROM `va` where city='Catharpin' && SIC_code='8661'DB:business_master_new
loadtime:1.1119689941406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catlett' limit 1
loadtime:1.1120331287384 / seconds
Query Executed:select id FROM `va` where city='Catlett' && SIC_code='8661'DB:business_master_new
loadtime:1.1169519424438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:1.1170301437378 / seconds
Query Executed:select id FROM `va` where city='Cedar Bluff' && SIC_code='8661'DB:business_master_new
loadtime:1.1223120689392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Cross' limit 1
loadtime:1.1223659515381 / seconds
Query Executed:select id FROM `va` where city='Center Cross' && SIC_code='8661'DB:business_master_new
loadtime:1.1228229999542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:1.1228721141815 / seconds
Query Executed:select id FROM `va` where city='Centreville' && SIC_code='8661'DB:business_master_new
loadtime:1.1294009685516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceres' limit 1
loadtime:1.1294739246368 / seconds
Query Executed:select id FROM `va` where city='Ceres' && SIC_code='8661'DB:business_master_new
loadtime:1.1298720836639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champlain' limit 1
loadtime:1.1299130916595 / seconds
Query Executed:select id FROM `va` where city='Champlain' && SIC_code='8661'DB:business_master_new
loadtime:1.1303510665894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chantilly' limit 1
loadtime:1.1303961277008 / seconds
Query Executed:select id FROM `va` where city='Chantilly' && SIC_code='8661'DB:business_master_new
loadtime:1.1368341445923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:1.1368970870972 / seconds
Query Executed:select id FROM `va` where city='Charles City' && SIC_code='8661'DB:business_master_new
loadtime:1.1450700759888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Court House' limit 1
loadtime:1.1451449394226 / seconds
Query Executed:select id FROM `va` where city='Charlotte Court House' && SIC_code='8661'DB:business_master_new
loadtime:1.149111032486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Ct Hse' limit 1
loadtime:1.1491651535034 / seconds
Query Executed:select id FROM `va` where city='Charlotte Ct Hse' && SIC_code='8661'DB:business_master_new
loadtime:1.149719953537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlottesville' limit 1
loadtime:1.1497640609741 / seconds
Query Executed:select id FROM `va` where city='Charlottesville' && SIC_code='8661'DB:business_master_new
loadtime:1.1626479625702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase City' limit 1
loadtime:1.1628389358521 / seconds
Query Executed:select id FROM `va` where city='Chase City' && SIC_code='8661'DB:business_master_new
loadtime:1.1703729629517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.170618057251 / seconds
Query Executed:select id FROM `va` where city='Chatham' && SIC_code='8661'DB:business_master_new
loadtime:1.1845300197601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Check' limit 1
loadtime:1.1847469806671 / seconds
Query Executed:select id FROM `va` where city='Check' && SIC_code='8661'DB:business_master_new
loadtime:1.1865100860596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheriton' limit 1
loadtime:1.1866500377655 / seconds
Query Executed:select id FROM `va` where city='Cheriton' && SIC_code='8661'DB:business_master_new
loadtime:1.1889700889587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesapeake' limit 1
loadtime:1.1890709400177 / seconds
Query Executed:select id FROM `va` where city='Chesapeake' && SIC_code='8661'DB:business_master_new
loadtime:1.222617149353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.2234399318695 / seconds
Query Executed:select id FROM `va` where city='Chester' && SIC_code='8661'DB:business_master_new
loadtime:1.2384171485901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester Gap' limit 1
loadtime:1.2386860847473 / seconds
Query Executed:select id FROM `va` where city='Chester Gap' && SIC_code='8661'DB:business_master_new
loadtime:1.2398569583893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.2400150299072 / seconds
Query Executed:select id FROM `va` where city='Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:1.2482991218567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilhowie' limit 1
loadtime:1.2483811378479 / seconds
Query Executed:select id FROM `va` where city='Chilhowie' && SIC_code='8661'DB:business_master_new
loadtime:1.2510731220245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague' limit 1
loadtime:1.2511539459229 / seconds
Query Executed:select id FROM `va` where city='Chincoteague' && SIC_code='8661'DB:business_master_new
loadtime:1.2517011165619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague Island' limit 1
loadtime:1.2517540454865 / seconds
Query Executed:select id FROM `va` where city='Chincoteague Island' && SIC_code='8661'DB:business_master_new
loadtime:1.2661161422729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christchurch' limit 1
loadtime:1.2661709785461 / seconds
Query Executed:select id FROM `va` where city='Christchurch' && SIC_code='8661'DB:business_master_new
loadtime:1.2665729522705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christiansburg' limit 1
loadtime:1.2666161060333 / seconds
Query Executed:select id FROM `va` where city='Christiansburg' && SIC_code='8661'DB:business_master_new
loadtime:1.2752470970154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Road' limit 1
loadtime:1.2753350734711 / seconds
Query Executed:select id FROM `va` where city='Church Road' && SIC_code='8661'DB:business_master_new
loadtime:1.2760870456696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church View' limit 1
loadtime:1.2761549949646 / seconds
Query Executed:select id FROM `va` where city='Church View' && SIC_code='8661'DB:business_master_new
loadtime:1.2766151428223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churchville' limit 1
loadtime:1.2766659259796 / seconds
Query Executed:select id FROM `va` where city='Churchville' && SIC_code='8661'DB:business_master_new
loadtime:1.279235124588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cismont' limit 1
loadtime:1.2793080806732 / seconds
Query Executed:select id FROM `va` where city='Cismont' && SIC_code='8661'DB:business_master_new
loadtime:1.2796010971069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:1.2796471118927 / seconds
Query Executed:select id FROM `va` where city='Claremont' && SIC_code='8661'DB:business_master_new
loadtime:1.2801599502563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:1.2802269458771 / seconds
Query Executed:select id FROM `va` where city='Clarksville' && SIC_code='8661'DB:business_master_new
loadtime:1.2892601490021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claudville' limit 1
loadtime:1.289458990097 / seconds
Query Executed:select id FROM `va` where city='Claudville' && SIC_code='8661'DB:business_master_new
loadtime:1.290990114212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Brook' limit 1
loadtime:1.291121006012 / seconds
Query Executed:select id FROM `va` where city='Clear Brook' && SIC_code='8661'DB:business_master_new
loadtime:1.2950811386108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:1.2951481342316 / seconds
Query Executed:select id FROM `va` where city='Cleveland' && SIC_code='8661'DB:business_master_new
loadtime:1.2957060337067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:1.2957580089569 / seconds
Query Executed:select id FROM `va` where city='Clifford' && SIC_code='8661'DB:business_master_new
loadtime:1.2960541248322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.2961010932922 / seconds
Query Executed:select id FROM `va` where city='Clifton' && SIC_code='8661'DB:business_master_new
loadtime:1.3013200759888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton Forge' limit 1
loadtime:1.3014540672302 / seconds
Query Executed:select id FROM `va` where city='Clifton Forge' && SIC_code='8661'DB:business_master_new
loadtime:1.308121919632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchco' limit 1
loadtime:1.3083770275116 / seconds
Query Executed:select id FROM `va` where city='Clinchco' && SIC_code='8661'DB:business_master_new
loadtime:1.309445142746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchport' limit 1
loadtime:1.309602022171 / seconds
Query Executed:select id FROM `va` where city='Clinchport' && SIC_code='8661'DB:business_master_new
loadtime:1.3101511001587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintwood' limit 1
loadtime:1.3103010654449 / seconds
Query Executed:select id FROM `va` where city='Clintwood' && SIC_code='8661'DB:business_master_new
loadtime:1.3167290687561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:1.3168671131134 / seconds
Query Executed:select id FROM `va` where city='Clover' && SIC_code='8661'DB:business_master_new
loadtime:1.3185050487518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:1.3186750411987 / seconds
Query Executed:select id FROM `va` where city='Cloverdale' && SIC_code='8661'DB:business_master_new
loadtime:1.3212909698486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cluster Springs' limit 1
loadtime:1.3213500976562 / seconds
Query Executed:select id FROM `va` where city='Cluster Springs' && SIC_code='8661'DB:business_master_new
loadtime:1.3216230869293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobbs Creek' limit 1
loadtime:1.3216669559479 / seconds
Query Executed:select id FROM `va` where city='Cobbs Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.3223190307617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobham' limit 1
loadtime:1.3223569393158 / seconds
Query Executed:select id FROM `va` where city='Cobham' && SIC_code='8661'DB:business_master_new
loadtime:1.3226051330566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coeburn' limit 1
loadtime:1.3226511478424 / seconds
Query Executed:select id FROM `va` where city='Coeburn' && SIC_code='8661'DB:business_master_new
loadtime:1.3293399810791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman Falls' limit 1
loadtime:1.329400062561 / seconds
Query Executed:select id FROM `va` where city='Coleman Falls' && SIC_code='8661'DB:business_master_new
loadtime:1.329735994339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coles Point' limit 1
loadtime:1.3297829627991 / seconds
Query Executed:select id FROM `va` where city='Coles Point' && SIC_code='8661'DB:business_master_new
loadtime:1.3301091194153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:1.3301351070404 / seconds
Query Executed:select id FROM `va` where city='Collinsville' && SIC_code='8661'DB:business_master_new
loadtime:1.3353891372681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:1.3354530334473 / seconds
Query Executed:select id FROM `va` where city='Cologne' && SIC_code='8661'DB:business_master_new
loadtime:1.3357131481171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Beach' limit 1
loadtime:1.3357570171356 / seconds
Query Executed:select id FROM `va` where city='Colonial Beach' && SIC_code='8661'DB:business_master_new
loadtime:1.3449749946594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Heights' limit 1
loadtime:1.3451571464539 / seconds
Query Executed:select id FROM `va` where city='Colonial Heights' && SIC_code='8661'DB:business_master_new
loadtime:1.3601369857788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:1.3603439331055 / seconds
Query Executed:select id FROM `va` where city='Columbia' && SIC_code='8661'DB:business_master_new
loadtime:1.361652135849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conaway' limit 1
loadtime:1.3617179393768 / seconds
Query Executed:select id FROM `va` where city='Conaway' && SIC_code='8661'DB:business_master_new
loadtime:1.3619790077209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:1.3620281219482 / seconds
Query Executed:select id FROM `va` where city='Concord' && SIC_code='8661'DB:business_master_new
loadtime:1.3650479316711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Hill' limit 1
loadtime:1.3651220798492 / seconds
Query Executed:select id FROM `va` where city='Copper Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.3658480644226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin' limit 1
loadtime:1.365926027298 / seconds
Query Executed:select id FROM `va` where city='Corbin' && SIC_code='8661'DB:business_master_new
loadtime:1.3663020133972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:1.3663449287415 / seconds
Query Executed:select id FROM `va` where city='Council' && SIC_code='8661'DB:business_master_new
loadtime:1.3666350841522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:1.3666760921478 / seconds
Query Executed:select id FROM `va` where city='Courtland' && SIC_code='8661'DB:business_master_new
loadtime:1.3695571422577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covesville' limit 1
loadtime:1.3696129322052 / seconds
Query Executed:select id FROM `va` where city='Covesville' && SIC_code='8661'DB:business_master_new
loadtime:1.370080947876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:1.3701269626617 / seconds
Query Executed:select id FROM `va` where city='Covington' && SIC_code='8661'DB:business_master_new
loadtime:1.3762819766998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craddockville' limit 1
loadtime:1.3763761520386 / seconds
Query Executed:select id FROM `va` where city='Craddockville' && SIC_code='8661'DB:business_master_new
loadtime:1.3767170906067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:1.3768010139465 / seconds
Query Executed:select id FROM `va` where city='Craigsville' && SIC_code='8661'DB:business_master_new
loadtime:1.378082036972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crewe' limit 1
loadtime:1.3781859874725 / seconds
Query Executed:select id FROM `va` where city='Crewe' && SIC_code='8661'DB:business_master_new
loadtime:1.382472038269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criders' limit 1
loadtime:1.3825500011444 / seconds
Query Executed:select id FROM `va` where city='Criders' && SIC_code='8661'DB:business_master_new
loadtime:1.3831419944763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criglersville' limit 1
loadtime:1.3832590579987 / seconds
Query Executed:select id FROM `va` where city='Criglersville' && SIC_code='8661'DB:business_master_new
loadtime:1.3836660385132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crimora' limit 1
loadtime:1.3838140964508 / seconds
Query Executed:select id FROM `va` where city='Crimora' && SIC_code='8661'DB:business_master_new
loadtime:1.3853061199188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:1.3853690624237 / seconds
Query Executed:select id FROM `va` where city='Cripple Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.3858079910278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Critz' limit 1
loadtime:1.3858439922333 / seconds
Query Executed:select id FROM `va` where city='Critz' && SIC_code='8661'DB:business_master_new
loadtime:1.3865900039673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crockett' limit 1
loadtime:1.3867480754852 / seconds
Query Executed:select id FROM `va` where city='Crockett' && SIC_code='8661'DB:business_master_new
loadtime:1.3874769210815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Junction' limit 1
loadtime:1.3876099586487 / seconds
Query Executed:select id FROM `va` where city='Cross Junction' && SIC_code='8661'DB:business_master_new
loadtime:1.3901200294495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozet' limit 1
loadtime:1.3903069496155 / seconds
Query Executed:select id FROM `va` where city='Crozet' && SIC_code='8661'DB:business_master_new
loadtime:1.396005153656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozier' limit 1
loadtime:1.3960771560669 / seconds
Query Executed:select id FROM `va` where city='Crozier' && SIC_code='8661'DB:business_master_new
loadtime:1.3968479633331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Hill' limit 1
loadtime:1.3968911170959 / seconds
Query Executed:select id FROM `va` where city='Crystal Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.3972351551056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullen' limit 1
loadtime:1.3972799777985 / seconds
Query Executed:select id FROM `va` where city='Cullen' && SIC_code='8661'DB:business_master_new
loadtime:1.3976790904999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culpeper' limit 1
loadtime:1.3977179527283 / seconds
Query Executed:select id FROM `va` where city='Culpeper' && SIC_code='8661'DB:business_master_new
loadtime:1.4038400650024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:1.4039211273193 / seconds
Query Executed:select id FROM `va` where city='Cumberland' && SIC_code='8661'DB:business_master_new
loadtime:1.4063990116119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dahlgren' limit 1
loadtime:1.4065809249878 / seconds
Query Executed:select id FROM `va` where city='Dahlgren' && SIC_code='8661'DB:business_master_new
loadtime:1.4100849628448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale City' limit 1
loadtime:1.4103009700775 / seconds
Query Executed:select id FROM `va` where city='Dale City' && SIC_code='8661'DB:business_master_new
loadtime:1.4116759300232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:1.4117259979248 / seconds
Query Executed:select id FROM `va` where city='Daleville' && SIC_code='8661'DB:business_master_new
loadtime:1.4168241024017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:1.4169189929962 / seconds
Query Executed:select id FROM `va` where city='Damascus' && SIC_code='8661'DB:business_master_new
loadtime:1.420294046402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:1.4204740524292 / seconds
Query Executed:select id FROM `va` where city='Dante' && SIC_code='8661'DB:business_master_new
loadtime:1.4211311340332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:1.4212551116943 / seconds
Query Executed:select id FROM `va` where city='Danville' && SIC_code='8661'DB:business_master_new
loadtime:1.4413340091705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington Hts' limit 1
loadtime:1.4419391155243 / seconds
Query Executed:select id FROM `va` where city='Darlington Hts' && SIC_code='8661'DB:business_master_new
loadtime:1.4424231052399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:1.4425740242004 / seconds
Query Executed:select id FROM `va` where city='Davenport' && SIC_code='8661'DB:business_master_new
loadtime:1.4438071250916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Wharf' limit 1
loadtime:1.4438610076904 / seconds
Query Executed:select id FROM `va` where city='Davis Wharf' && SIC_code='8661'DB:business_master_new
loadtime:1.444314956665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:1.4444251060486 / seconds
Query Executed:select id FROM `va` where city='Dayton' && SIC_code='8661'DB:business_master_new
loadtime:1.4510991573334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:1.4511671066284 / seconds
Query Executed:select id FROM `va` where city='Deerfield' && SIC_code='8661'DB:business_master_new
loadtime:1.4519460201263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaplane' limit 1
loadtime:1.4520680904388 / seconds
Query Executed:select id FROM `va` where city='Delaplane' && SIC_code='8661'DB:business_master_new
loadtime:1.4535911083221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deltaville' limit 1
loadtime:1.453761100769 / seconds
Query Executed:select id FROM `va` where city='Deltaville' && SIC_code='8661'DB:business_master_new
loadtime:1.4588479995728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dendron' limit 1
loadtime:1.4589140415192 / seconds
Query Executed:select id FROM `va` where city='Dendron' && SIC_code='8661'DB:business_master_new
loadtime:1.4604189395905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:1.4605309963226 / seconds
Query Executed:select id FROM `va` where city='Dewitt' && SIC_code='8661'DB:business_master_new
loadtime:1.46222615242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diggs' limit 1
loadtime:1.4622910022736 / seconds
Query Executed:select id FROM `va` where city='Diggs' && SIC_code='8661'DB:business_master_new
loadtime:1.4627120494843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillwyn' limit 1
loadtime:1.4628720283508 / seconds
Query Executed:select id FROM `va` where city='Dillwyn' && SIC_code='8661'DB:business_master_new
loadtime:1.4683809280396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinwiddie' limit 1
loadtime:1.4684889316559 / seconds
Query Executed:select id FROM `va` where city='Dinwiddie' && SIC_code='8661'DB:business_master_new
loadtime:1.4710690975189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Disputanta' limit 1
loadtime:1.4711680412292 / seconds
Query Executed:select id FROM `va` where city='Disputanta' && SIC_code='8661'DB:business_master_new
loadtime:1.4744319915771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doe Hill' limit 1
loadtime:1.4746110439301 / seconds
Query Executed:select id FROM `va` where city='Doe Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.4754300117493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dogue' limit 1
loadtime:1.475536108017 / seconds
Query Executed:select id FROM `va` where city='Dogue' && SIC_code='8661'DB:business_master_new
loadtime:1.4759891033173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolphin' limit 1
loadtime:1.4760971069336 / seconds
Query Executed:select id FROM `va` where city='Dolphin' && SIC_code='8661'DB:business_master_new
loadtime:1.4771320819855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doran' limit 1
loadtime:1.4772551059723 / seconds
Query Executed:select id FROM `va` where city='Doran' && SIC_code='8661'DB:business_master_new
loadtime:1.4779939651489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doswell' limit 1
loadtime:1.4780900478363 / seconds
Query Executed:select id FROM `va` where city='Doswell' && SIC_code='8661'DB:business_master_new
loadtime:1.4808859825134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakes Branch' limit 1
loadtime:1.4809489250183 / seconds
Query Executed:select id FROM `va` where city='Drakes Branch' && SIC_code='8661'DB:business_master_new
loadtime:1.4820311069489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:1.4820809364319 / seconds
Query Executed:select id FROM `va` where city='Draper' && SIC_code='8661'DB:business_master_new
loadtime:1.4827120304108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewryville' limit 1
loadtime:1.4827671051025 / seconds
Query Executed:select id FROM `va` where city='Drewryville' && SIC_code='8661'DB:business_master_new
loadtime:1.483204126358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Fork' limit 1
loadtime:1.483246088028 / seconds
Query Executed:select id FROM `va` where city='Dry Fork' && SIC_code='8661'DB:business_master_new
loadtime:1.4845440387726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:1.4845979213715 / seconds
Query Executed:select id FROM `va` where city='Dryden' && SIC_code='8661'DB:business_master_new
loadtime:1.4853060245514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:1.4853570461273 / seconds
Query Executed:select id FROM `va` where city='Dublin' && SIC_code='8661'DB:business_master_new
loadtime:1.4906251430511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duffield' limit 1
loadtime:1.4906859397888 / seconds
Query Executed:select id FROM `va` where city='Duffield' && SIC_code='8661'DB:business_master_new
loadtime:1.4944789409637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugspur' limit 1
loadtime:1.494637966156 / seconds
Query Executed:select id FROM `va` where city='Dugspur' && SIC_code='8661'DB:business_master_new
loadtime:1.4961199760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulles' limit 1
loadtime:1.4963319301605 / seconds
Query Executed:select id FROM `va` where city='Dulles' && SIC_code='8661'DB:business_master_new
loadtime:1.4977951049805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumfries' limit 1
loadtime:1.4979360103607 / seconds
Query Executed:select id FROM `va` where city='Dumfries' && SIC_code='8661'DB:business_master_new
loadtime:1.5074369907379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundas' limit 1
loadtime:1.5075061321259 / seconds
Query Executed:select id FROM `va` where city='Dundas' && SIC_code='8661'DB:business_master_new
loadtime:1.5079319477081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dungannon' limit 1
loadtime:1.5079901218414 / seconds
Query Executed:select id FROM `va` where city='Dungannon' && SIC_code='8661'DB:business_master_new
loadtime:1.5085470676422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn Loring' limit 1
loadtime:1.508602142334 / seconds
Query Executed:select id FROM `va` where city='Dunn Loring' && SIC_code='8661'DB:business_master_new
loadtime:1.5104839801788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunnsville' limit 1
loadtime:1.5105490684509 / seconds
Query Executed:select id FROM `va` where city='Dunnsville' && SIC_code='8661'DB:business_master_new
loadtime:1.5111391544342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:1.5111999511719 / seconds
Query Executed:select id FROM `va` where city='Dutton' && SIC_code='8661'DB:business_master_new
loadtime:1.5116369724274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyke' limit 1
loadtime:1.5116951465607 / seconds
Query Executed:select id FROM `va` where city='Dyke' && SIC_code='8661'DB:business_master_new
loadtime:1.5121319293976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:1.5121791362762 / seconds
Query Executed:select id FROM `va` where city='Eagle Rock' && SIC_code='8661'DB:business_master_new
loadtime:1.5129010677338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlysville' limit 1
loadtime:1.5129599571228 / seconds
Query Executed:select id FROM `va` where city='Earlysville' && SIC_code='8661'DB:business_master_new
loadtime:1.5149729251862 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Stone Gap' limit 1
loadtime:1.5150439739227 / seconds
Query Executed:select id FROM `va` where city='East Stone Gap' && SIC_code='8661'DB:business_master_new
loadtime:1.5153830051422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastville' limit 1
loadtime:1.5154330730438 / seconds
Query Executed:select id FROM `va` where city='Eastville' && SIC_code='8661'DB:business_master_new
loadtime:1.5175199508667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ebony' limit 1
loadtime:1.5175931453705 / seconds
Query Executed:select id FROM `va` where city='Ebony' && SIC_code='8661'DB:business_master_new
loadtime:1.5181250572205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:1.5182030200958 / seconds
Query Executed:select id FROM `va` where city='Edinburg' && SIC_code='8661'DB:business_master_new
loadtime:1.5223031044006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:1.5223679542542 / seconds
Query Executed:select id FROM `va` where city='Edwardsville' && SIC_code='8661'DB:business_master_new
loadtime:1.5226149559021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eggleston' limit 1
loadtime:1.522665977478 / seconds
Query Executed:select id FROM `va` where city='Eggleston' && SIC_code='8661'DB:business_master_new
loadtime:1.5229840278625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:1.5230259895325 / seconds
Query Executed:select id FROM `va` where city='Elberon' && SIC_code='8661'DB:business_master_new
loadtime:1.5234560966492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Creek' limit 1
loadtime:1.5235030651093 / seconds
Query Executed:select id FROM `va` where city='Elk Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.5242569446564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:1.5244159698486 / seconds
Query Executed:select id FROM `va` where city='Elk Garden' && SIC_code='8661'DB:business_master_new
loadtime:1.5248379707336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:1.5248861312866 / seconds
Query Executed:select id FROM `va` where city='Elkton' && SIC_code='8661'DB:business_master_new
loadtime:1.5315611362457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkwood' limit 1
loadtime:1.5316450595856 / seconds
Query Executed:select id FROM `va` where city='Elkwood' && SIC_code='8661'DB:business_master_new
loadtime:1.5327091217041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliston' limit 1
loadtime:1.5328149795532 / seconds
Query Executed:select id FROM `va` where city='Elliston' && SIC_code='8661'DB:business_master_new
loadtime:1.5357191562653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emory' limit 1
loadtime:1.5357799530029 / seconds
Query Executed:select id FROM `va` where city='Emory' && SIC_code='8661'DB:business_master_new
loadtime:1.5361299514771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:1.5361731052399 / seconds
Query Executed:select id FROM `va` where city='Emporia' && SIC_code='8661'DB:business_master_new
loadtime:1.5465021133423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engleside' limit 1
loadtime:1.5466051101685 / seconds
Query Executed:select id FROM `va` where city='Engleside' && SIC_code='8661'DB:business_master_new
loadtime:1.5470230579376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esmont' limit 1
loadtime:1.5470700263977 / seconds
Query Executed:select id FROM `va` where city='Esmont' && SIC_code='8661'DB:business_master_new
loadtime:1.5476169586182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etlan' limit 1
loadtime:1.5476801395416 / seconds
Query Executed:select id FROM `va` where city='Etlan' && SIC_code='8661'DB:business_master_new
loadtime:1.5480060577393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:1.5480589866638 / seconds
Query Executed:select id FROM `va` where city='Ettrick' && SIC_code='8661'DB:business_master_new
loadtime:1.5483169555664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:1.5483510494232 / seconds
Query Executed:select id FROM `va` where city='Evergreen' && SIC_code='8661'DB:business_master_new
loadtime:1.5492379665375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evington' limit 1
loadtime:1.5492990016937 / seconds
Query Executed:select id FROM `va` where city='Evington' && SIC_code='8661'DB:business_master_new
loadtime:1.5512340068817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewing' limit 1
loadtime:1.5513269901276 / seconds
Query Executed:select id FROM `va` where city='Ewing' && SIC_code='8661'DB:business_master_new
loadtime:1.5522501468658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exmore' limit 1
loadtime:1.5523059368134 / seconds
Query Executed:select id FROM `va` where city='Exmore' && SIC_code='8661'DB:business_master_new
loadtime:1.5547940731049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faber' limit 1
loadtime:1.5548391342163 / seconds
Query Executed:select id FROM `va` where city='Faber' && SIC_code='8661'DB:business_master_new
loadtime:1.5555310249329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:1.5555830001831 / seconds
Query Executed:select id FROM `va` where city='Fairfax' && SIC_code='8661'DB:business_master_new
loadtime:1.5765421390533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax Station' limit 1
loadtime:1.5769109725952 / seconds
Query Executed:select id FROM `va` where city='Fairfax Station' && SIC_code='8661'DB:business_master_new
loadtime:1.5911331176758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.5913879871368 / seconds
Query Executed:select id FROM `va` where city='Fairfield' && SIC_code='8661'DB:business_master_new
loadtime:1.5944321155548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlawn' limit 1
loadtime:1.5945019721985 / seconds
Query Executed:select id FROM `va` where city='Fairlawn' && SIC_code='8661'DB:business_master_new
loadtime:1.5948081016541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Church' limit 1
loadtime:1.5948600769043 / seconds
Query Executed:select id FROM `va` where city='Falls Church' && SIC_code='8661'DB:business_master_new
loadtime:1.6045501232147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Mills' limit 1
loadtime:1.6046731472015 / seconds
Query Executed:select id FROM `va` where city='Falls Mills' && SIC_code='8661'DB:business_master_new
loadtime:1.6051969528198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:1.605241060257 / seconds
Query Executed:select id FROM `va` where city='Falmouth' && SIC_code='8661'DB:business_master_new
loadtime:1.6054921150208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fancy Gap' limit 1
loadtime:1.6055300235748 / seconds
Query Executed:select id FROM `va` where city='Fancy Gap' && SIC_code='8661'DB:business_master_new
loadtime:1.606673002243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:1.6067180633545 / seconds
Query Executed:select id FROM `va` where city='Farmville' && SIC_code='8661'DB:business_master_new
loadtime:1.6125500202179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnham' limit 1
loadtime:1.6126279830933 / seconds
Query Executed:select id FROM `va` where city='Farnham' && SIC_code='8661'DB:business_master_new
loadtime:1.6133949756622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrum' limit 1
loadtime:1.6134431362152 / seconds
Query Executed:select id FROM `va` where city='Ferrum' && SIC_code='8661'DB:business_master_new
loadtime:1.6149570941925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldale' limit 1
loadtime:1.6150000095367 / seconds
Query Executed:select id FROM `va` where city='Fieldale' && SIC_code='8661'DB:business_master_new
loadtime:1.6167650222778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:1.6168160438538 / seconds
Query Executed:select id FROM `va` where city='Fife' && SIC_code='8661'DB:business_master_new
loadtime:1.6170661449432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fincastle' limit 1
loadtime:1.617103099823 / seconds
Query Executed:select id FROM `va` where city='Fincastle' && SIC_code='8661'DB:business_master_new
loadtime:1.6194591522217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishers Hill' limit 1
loadtime:1.6195080280304 / seconds
Query Executed:select id FROM `va` where city='Fishers Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.6199841499329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishersville' limit 1
loadtime:1.6201519966125 / seconds
Query Executed:select id FROM `va` where city='Fishersville' && SIC_code='8661'DB:business_master_new
loadtime:1.6254050731659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint Hill' limit 1
loadtime:1.6254639625549 / seconds
Query Executed:select id FROM `va` where city='Flint Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.6262860298157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:1.6263411045074 / seconds
Query Executed:select id FROM `va` where city='Floyd' && SIC_code='8661'DB:business_master_new
loadtime:1.6317870616913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foneswood' limit 1
loadtime:1.6319601535797 / seconds
Query Executed:select id FROM `va` where city='Foneswood' && SIC_code='8661'DB:business_master_new
loadtime:1.6326620578766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:1.632807970047 / seconds
Query Executed:select id FROM `va` where city='Ford' && SIC_code='8661'DB:business_master_new
loadtime:1.6336100101471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:1.6336679458618 / seconds
Query Executed:select id FROM `va` where city='Forest' && SIC_code='8661'DB:business_master_new
loadtime:1.6472351551056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork Union' limit 1
loadtime:1.6474649906158 / seconds
Query Executed:select id FROM `va` where city='Fork Union' && SIC_code='8661'DB:business_master_new
loadtime:1.650120973587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Belvoir' limit 1
loadtime:1.6503140926361 / seconds
Query Executed:select id FROM `va` where city='Fort Belvoir' && SIC_code='8661'DB:business_master_new
loadtime:1.6556961536407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Blackmore' limit 1
loadtime:1.6558771133423 / seconds
Query Executed:select id FROM `va` where city='Fort Blackmore' && SIC_code='8661'DB:business_master_new
loadtime:1.6571681499481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:1.6573481559753 / seconds
Query Executed:select id FROM `va` where city='Fort Defiance' && SIC_code='8661'DB:business_master_new
loadtime:1.6585810184479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Eustis' limit 1
loadtime:1.658744096756 / seconds
Query Executed:select id FROM `va` where city='Fort Eustis' && SIC_code='8661'DB:business_master_new
loadtime:1.6616570949554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:1.6617169380188 / seconds
Query Executed:select id FROM `va` where city='Fort Lee' && SIC_code='8661'DB:business_master_new
loadtime:1.6639950275421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:1.6641290187836 / seconds
Query Executed:select id FROM `va` where city='Fort Mitchell' && SIC_code='8661'DB:business_master_new
loadtime:1.6648890972137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monroe' limit 1
loadtime:1.665048122406 / seconds
Query Executed:select id FROM `va` where city='Fort Monroe' && SIC_code='8661'DB:business_master_new
loadtime:1.666384935379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Myer' limit 1
loadtime:1.6665179729462 / seconds
Query Executed:select id FROM `va` where city='Fort Myer' && SIC_code='8661'DB:business_master_new
loadtime:1.6684241294861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Valley' limit 1
loadtime:1.6684720516205 / seconds
Query Executed:select id FROM `va` where city='Fort Valley' && SIC_code='8661'DB:business_master_new
loadtime:1.6697809696198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:1.6698460578918 / seconds
Query Executed:select id FROM `va` where city='Foster' && SIC_code='8661'DB:business_master_new
loadtime:1.6704111099243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:1.6705451011658 / seconds
Query Executed:select id FROM `va` where city='Franconia' && SIC_code='8661'DB:business_master_new
loadtime:1.6713221073151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.6714649200439 / seconds
Query Executed:select id FROM `va` where city='Franklin' && SIC_code='8661'DB:business_master_new
loadtime:1.6784491539001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:1.6785299777985 / seconds
Query Executed:select id FROM `va` where city='Franktown' && SIC_code='8661'DB:business_master_new
loadtime:1.6789901256561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:1.6790471076965 / seconds
Query Executed:select id FROM `va` where city='Fredericksburg' && SIC_code='8661'DB:business_master_new
loadtime:1.6892280578613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Union' limit 1
loadtime:1.6893739700317 / seconds
Query Executed:select id FROM `va` where city='Free Union' && SIC_code='8661'DB:business_master_new
loadtime:1.6902420520782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:1.6903140544891 / seconds
Query Executed:select id FROM `va` where city='Freeman' && SIC_code='8661'DB:business_master_new
loadtime:1.6908731460571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fries' limit 1
loadtime:1.6909351348877 / seconds
Query Executed:select id FROM `va` where city='Fries' && SIC_code='8661'DB:business_master_new
loadtime:1.692085981369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Front Royal' limit 1
loadtime:1.6921529769897 / seconds
Query Executed:select id FROM `va` where city='Front Royal' && SIC_code='8661'DB:business_master_new
loadtime:1.7021689414978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ft Myer' limit 1
loadtime:1.7022960186005 / seconds
Query Executed:select id FROM `va` where city='Ft Myer' && SIC_code='8661'DB:business_master_new
loadtime:1.7029979228973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulks Run' limit 1
loadtime:1.703145980835 / seconds
Query Executed:select id FROM `va` where city='Fulks Run' && SIC_code='8661'DB:business_master_new
loadtime:1.7050931453705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:1.7053000926971 / seconds
Query Executed:select id FROM `va` where city='Gainesville' && SIC_code='8661'DB:business_master_new
loadtime:1.7163441181183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galax' limit 1
loadtime:1.7164900302887 / seconds
Query Executed:select id FROM `va` where city='Galax' && SIC_code='8661'DB:business_master_new
loadtime:1.7294359207153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrisonville' limit 1
loadtime:1.7297120094299 / seconds
Query Executed:select id FROM `va` where city='Garrisonville' && SIC_code='8661'DB:business_master_new
loadtime:1.7313621044159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gasburg' limit 1
loadtime:1.7314190864563 / seconds
Query Executed:select id FROM `va` where city='Gasburg' && SIC_code='8661'DB:business_master_new
loadtime:1.7332339286804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gate City' limit 1
loadtime:1.7332980632782 / seconds
Query Executed:select id FROM `va` where city='Gate City' && SIC_code='8661'DB:business_master_new
loadtime:1.7416000366211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Hill' limit 1
loadtime:1.741779088974 / seconds
Query Executed:select id FROM `va` where city='Glade Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.7446660995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Spring' limit 1
loadtime:1.7448401451111 / seconds
Query Executed:select id FROM `va` where city='Glade Spring' && SIC_code='8661'DB:business_master_new
loadtime:1.748939037323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladehill' limit 1
loadtime:1.7491271495819 / seconds
Query Executed:select id FROM `va` where city='Gladehill' && SIC_code='8661'DB:business_master_new
loadtime:1.7495470046997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.7496869564056 / seconds
Query Executed:select id FROM `va` where city='Gladstone' && SIC_code='8661'DB:business_master_new
loadtime:1.7515549659729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladys' limit 1
loadtime:1.7516100406647 / seconds
Query Executed:select id FROM `va` where city='Gladys' && SIC_code='8661'DB:business_master_new
loadtime:1.7540681362152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:1.7542059421539 / seconds
Query Executed:select id FROM `va` where city='Glasgow' && SIC_code='8661'DB:business_master_new
loadtime:1.7561280727386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:1.7562639713287 / seconds
Query Executed:select id FROM `va` where city='Glen Allen' && SIC_code='8661'DB:business_master_new
loadtime:1.7687740325928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Lyn' limit 1
loadtime:1.7688930034637 / seconds
Query Executed:select id FROM `va` where city='Glen Lyn' && SIC_code='8661'DB:business_master_new
loadtime:1.7699699401855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Wilton' limit 1
loadtime:1.7701079845428 / seconds
Query Executed:select id FROM `va` where city='Glen Wilton' && SIC_code='8661'DB:business_master_new
loadtime:1.7705929279327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:1.7706351280212 / seconds
Query Executed:select id FROM `va` where city='Gloucester' && SIC_code='8661'DB:business_master_new
loadtime:1.7821929454803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester Point' limit 1
loadtime:1.7824461460114 / seconds
Query Executed:select id FROM `va` where city='Gloucester Point' && SIC_code='8661'DB:business_master_new
loadtime:1.7860100269318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldbond' limit 1
loadtime:1.7860641479492 / seconds
Query Executed:select id FROM `va` where city='Goldbond' && SIC_code='8661'DB:business_master_new
loadtime:1.7867591381073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldvein' limit 1
loadtime:1.786896944046 / seconds
Query Executed:select id FROM `va` where city='Goldvein' && SIC_code='8661'DB:business_master_new
loadtime:1.7882580757141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goochland' limit 1
loadtime:1.7884271144867 / seconds
Query Executed:select id FROM `va` where city='Goochland' && SIC_code='8661'DB:business_master_new
loadtime:1.7943649291992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goode' limit 1
loadtime:1.7945349216461 / seconds
Query Executed:select id FROM `va` where city='Goode' && SIC_code='8661'DB:business_master_new
loadtime:1.7968349456787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodview' limit 1
loadtime:1.7970221042633 / seconds
Query Executed:select id FROM `va` where city='Goodview' && SIC_code='8661'DB:business_master_new
loadtime:1.7994539737701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordonsville' limit 1
loadtime:1.7995181083679 / seconds
Query Executed:select id FROM `va` where city='Gordonsville' && SIC_code='8661'DB:business_master_new
loadtime:1.8054959774017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore' limit 1
loadtime:1.8056330680847 / seconds
Query Executed:select id FROM `va` where city='Gore' && SIC_code='8661'DB:business_master_new
loadtime:1.807450056076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:1.8076190948486 / seconds
Query Executed:select id FROM `va` where city='Goshen' && SIC_code='8661'DB:business_master_new
loadtime:1.8087599277496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:1.8088221549988 / seconds
Query Executed:select id FROM `va` where city='Grafton' && SIC_code='8661'DB:business_master_new
loadtime:1.809602022171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graves Mill' limit 1
loadtime:1.8096520900726 / seconds
Query Executed:select id FROM `va` where city='Graves Mill' && SIC_code='8661'DB:business_master_new
loadtime:1.8099400997162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:1.810035943985 / seconds
Query Executed:select id FROM `va` where city='Great Falls' && SIC_code='8661'DB:business_master_new
loadtime:1.818932056427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:1.8189980983734 / seconds
Query Executed:select id FROM `va` where city='Green Bay' && SIC_code='8661'DB:business_master_new
loadtime:1.8195300102234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbackville' limit 1
loadtime:1.8195860385895 / seconds
Query Executed:select id FROM `va` where city='Greenbackville' && SIC_code='8661'DB:business_master_new
loadtime:1.8200380802155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.820109128952 / seconds
Query Executed:select id FROM `va` where city='Greenbush' && SIC_code='8661'DB:business_master_new
loadtime:1.820564031601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.8206181526184 / seconds
Query Executed:select id FROM `va` where city='Greenville' && SIC_code='8661'DB:business_master_new
loadtime:1.821417093277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenway' limit 1
loadtime:1.8215780258179 / seconds
Query Executed:select id FROM `va` where city='Greenway' && SIC_code='8661'DB:business_master_new
loadtime:1.8219840526581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.8220360279083 / seconds
Query Executed:select id FROM `va` where city='Greenwood' && SIC_code='8661'DB:business_master_new
loadtime:1.8225879669189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gretna' limit 1
loadtime:1.8226511478424 / seconds
Query Executed:select id FROM `va` where city='Gretna' && SIC_code='8661'DB:business_master_new
loadtime:1.8273830413818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimstead' limit 1
loadtime:1.8275060653687 / seconds
Query Executed:select id FROM `va` where city='Grimstead' && SIC_code='8661'DB:business_master_new
loadtime:1.8283159732819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grottoes' limit 1
loadtime:1.8283560276031 / seconds
Query Executed:select id FROM `va` where city='Grottoes' && SIC_code='8661'DB:business_master_new
loadtime:1.83136510849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy' limit 1
loadtime:1.8314321041107 / seconds
Query Executed:select id FROM `va` where city='Grundy' && SIC_code='8661'DB:business_master_new
loadtime:1.84255194664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gum Spring' limit 1
loadtime:1.8427040576935 / seconds
Query Executed:select id FROM `va` where city='Gum Spring' && SIC_code='8661'DB:business_master_new
loadtime:1.8447380065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwynn' limit 1
loadtime:1.8448750972748 / seconds
Query Executed:select id FROM `va` where city='Gwynn' && SIC_code='8661'DB:business_master_new
loadtime:1.8459570407867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacksneck' limit 1
loadtime:1.8460991382599 / seconds
Query Executed:select id FROM `va` where city='Hacksneck' && SIC_code='8661'DB:business_master_new
loadtime:1.8469431400299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadensville' limit 1
loadtime:1.8470871448517 / seconds
Query Executed:select id FROM `va` where city='Hadensville' && SIC_code='8661'DB:business_master_new
loadtime:1.8479819297791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hague' limit 1
loadtime:1.8481180667877 / seconds
Query Executed:select id FROM `va` where city='Hague' && SIC_code='8661'DB:business_master_new
loadtime:1.8496949672699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:1.8498439788818 / seconds
Query Executed:select id FROM `va` where city='Halifax' && SIC_code='8661'DB:business_master_new
loadtime:1.8595359325409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallieford' limit 1
loadtime:1.8597540855408 / seconds
Query Executed:select id FROM `va` where city='Hallieford' && SIC_code='8661'DB:business_master_new
loadtime:1.860659122467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallwood' limit 1
loadtime:1.8607850074768 / seconds
Query Executed:select id FROM `va` where city='Hallwood' && SIC_code='8661'DB:business_master_new
loadtime:1.861720085144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.8617811203003 / seconds
Query Executed:select id FROM `va` where city='Hamilton' && SIC_code='8661'DB:business_master_new
loadtime:1.865226984024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden Sydney' limit 1
loadtime:1.8653831481934 / seconds
Query Executed:select id FROM `va` where city='Hampden Sydney' && SIC_code='8661'DB:business_master_new
loadtime:1.8663120269775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:1.8664920330048 / seconds
Query Executed:select id FROM `va` where city='Hampton' && SIC_code='8661'DB:business_master_new
loadtime:1.8826339244843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.8828549385071 / seconds
Query Executed:select id FROM `va` where city='Hanover' && SIC_code='8661'DB:business_master_new
loadtime:1.8856239318848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harborton' limit 1
loadtime:1.8856899738312 / seconds
Query Executed:select id FROM `va` where city='Harborton' && SIC_code='8661'DB:business_master_new
loadtime:1.8860280513763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:1.8860719203949 / seconds
Query Executed:select id FROM `va` where city='Hardy' && SIC_code='8661'DB:business_master_new
loadtime:1.8884589672089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardyville' limit 1
loadtime:1.8885080814362 / seconds
Query Executed:select id FROM `va` where city='Hardyville' && SIC_code='8661'DB:business_master_new
loadtime:1.8888819217682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:1.8889219760895 / seconds
Query Executed:select id FROM `va` where city='Harman' && SIC_code='8661'DB:business_master_new
loadtime:1.8892021179199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonburg' limit 1
loadtime:1.8892409801483 / seconds
Query Executed:select id FROM `va` where city='Harrisonburg' && SIC_code='8661'DB:business_master_new
loadtime:1.900218963623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartfield' limit 1
loadtime:1.9005651473999 / seconds
Query Executed:select id FROM `va` where city='Hartfield' && SIC_code='8661'DB:business_master_new
loadtime:1.9030821323395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwood' limit 1
loadtime:1.9033041000366 / seconds
Query Executed:select id FROM `va` where city='Hartwood' && SIC_code='8661'DB:business_master_new
loadtime:1.9046740531921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:1.9047889709473 / seconds
Query Executed:select id FROM `va` where city='Hayes' && SIC_code='8661'DB:business_master_new
loadtime:1.91641497612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haymarket' limit 1
loadtime:1.9165060520172 / seconds
Query Executed:select id FROM `va` where city='Haymarket' && SIC_code='8661'DB:business_master_new
loadtime:1.927628993988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haynesville' limit 1
loadtime:1.927768945694 / seconds
Query Executed:select id FROM `va` where city='Haynesville' && SIC_code='8661'DB:business_master_new
loadtime:1.9290030002594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysi' limit 1
loadtime:1.9291639328003 / seconds
Query Executed:select id FROM `va` where city='Haysi' && SIC_code='8661'DB:business_master_new
loadtime:1.9325790405273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:1.9327199459076 / seconds
Query Executed:select id FROM `va` where city='Haywood' && SIC_code='8661'DB:business_master_new
loadtime:1.9336271286011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Head Waters' limit 1
loadtime:1.9336919784546 / seconds
Query Executed:select id FROM `va` where city='Head Waters' && SIC_code='8661'DB:business_master_new
loadtime:1.9341261386871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heathsville' limit 1
loadtime:1.9342999458313 / seconds
Query Executed:select id FROM `va` where city='Heathsville' && SIC_code='8661'DB:business_master_new
loadtime:1.940817117691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:1.9410080909729 / seconds
Query Executed:select id FROM `va` where city='Henry' && SIC_code='8661'DB:business_master_new
loadtime:1.9428539276123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:1.9430069923401 / seconds
Query Executed:select id FROM `va` where city='Herndon' && SIC_code='8661'DB:business_master_new
loadtime:1.9616630077362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Springs' limit 1
loadtime:1.9617531299591 / seconds
Query Executed:select id FROM `va` where city='Highland Springs' && SIC_code='8661'DB:business_master_new
loadtime:1.9621469974518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightown' limit 1
loadtime:1.9622571468353 / seconds
Query Executed:select id FROM `va` where city='Hightown' && SIC_code='8661'DB:business_master_new
loadtime:1.9629950523376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsville' limit 1
loadtime:1.9630990028381 / seconds
Query Executed:select id FROM `va` where city='Hillsville' && SIC_code='8661'DB:business_master_new
loadtime:1.9748060703278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiltons' limit 1
loadtime:1.9749939441681 / seconds
Query Executed:select id FROM `va` where city='Hiltons' && SIC_code='8661'DB:business_master_new
loadtime:1.9762420654297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:1.9764120578766 / seconds
Query Executed:select id FROM `va` where city='Hinton' && SIC_code='8661'DB:business_master_new
loadtime:1.9777510166168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiwassee' limit 1
loadtime:1.9778070449829 / seconds
Query Executed:select id FROM `va` where city='Hiwassee' && SIC_code='8661'DB:business_master_new
loadtime:1.9790380001068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:1.9792330265045 / seconds
Query Executed:select id FROM `va` where city='Hollins' && SIC_code='8661'DB:business_master_new
loadtime:1.979975938797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaker' limit 1
loadtime:1.9801261425018 / seconds
Query Executed:select id FROM `va` where city='Honaker' && SIC_code='8661'DB:business_master_new
loadtime:1.9844441413879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood' limit 1
loadtime:1.9846220016479 / seconds
Query Executed:select id FROM `va` where city='Hood' && SIC_code='8661'DB:business_master_new
loadtime:1.9857029914856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:1.9858660697937 / seconds
Query Executed:select id FROM `va` where city='Hopewell' && SIC_code='8661'DB:business_master_new
loadtime:1.9956300258636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horntown' limit 1
loadtime:1.9957151412964 / seconds
Query Executed:select id FROM `va` where city='Horntown' && SIC_code='8661'DB:business_master_new
loadtime:1.9961330890656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horsepen' limit 1
loadtime:1.9962091445923 / seconds
Query Executed:select id FROM `va` where city='Horsepen' && SIC_code='8661'DB:business_master_new
loadtime:1.9964439868927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:1.9964780807495 / seconds
Query Executed:select id FROM `va` where city='Hot Springs' && SIC_code='8661'DB:business_master_new
loadtime:1.9983649253845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howardsville' limit 1
loadtime:1.9984309673309 / seconds
Query Executed:select id FROM `va` where city='Howardsville' && SIC_code='8661'DB:business_master_new
loadtime:1.9987859725952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howertons' limit 1
loadtime:1.9988360404968 / seconds
Query Executed:select id FROM `va` where city='Howertons' && SIC_code='8661'DB:business_master_new
loadtime:1.9990861415863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huddleston' limit 1
loadtime:1.9991281032562 / seconds
Query Executed:select id FROM `va` where city='Huddleston' && SIC_code='8661'DB:business_master_new
loadtime:2.0006041526794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudgins' limit 1
loadtime:2.000669002533 / seconds
Query Executed:select id FROM `va` where city='Hudgins' && SIC_code='8661'DB:business_master_new
loadtime:2.0012109279633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hume' limit 1
loadtime:2.0012731552124 / seconds
Query Executed:select id FROM `va` where city='Hume' && SIC_code='8661'DB:business_master_new
loadtime:2.0018889904022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntly' limit 1
loadtime:2.0019400119781 / seconds
Query Executed:select id FROM `va` where city='Huntly' && SIC_code='8661'DB:business_master_new
loadtime:2.0023350715637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:2.0023851394653 / seconds
Query Executed:select id FROM `va` where city='Hurley' && SIC_code='8661'DB:business_master_new
loadtime:2.0031599998474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurt' limit 1
loadtime:2.0032489299774 / seconds
Query Executed:select id FROM `va` where city='Hurt' && SIC_code='8661'DB:business_master_new
loadtime:2.0054130554199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustle' limit 1
loadtime:2.0054800510406 / seconds
Query Executed:select id FROM `va` where city='Hustle' && SIC_code='8661'DB:business_master_new
loadtime:2.0058031082153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:2.0058550834656 / seconds
Query Executed:select id FROM `va` where city='Independence' && SIC_code='8661'DB:business_master_new
loadtime:2.0084030628204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Valley' limit 1
loadtime:2.0084681510925 / seconds
Query Executed:select id FROM `va` where city='Indian Valley' && SIC_code='8661'DB:business_master_new
loadtime:2.0088450908661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Gate' limit 1
loadtime:2.0088911056519 / seconds
Query Executed:select id FROM `va` where city='Iron Gate' && SIC_code='8661'DB:business_master_new
loadtime:2.0093669891357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironto' limit 1
loadtime:2.009418964386 / seconds
Query Executed:select id FROM `va` where city='Ironto' && SIC_code='8661'DB:business_master_new
loadtime:2.0097091197968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:2.009742975235 / seconds
Query Executed:select id FROM `va` where city='Irvington' && SIC_code='8661'DB:business_master_new
loadtime:2.0109961032867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Wight' limit 1
loadtime:2.0110421180725 / seconds
Query Executed:select id FROM `va` where city='Isle Of Wight' && SIC_code='8661'DB:business_master_new
loadtime:2.0116050243378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:2.011656999588 / seconds
Query Executed:select id FROM `va` where city='Ivanhoe' && SIC_code='8661'DB:business_master_new
loadtime:2.0121569633484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivor' limit 1
loadtime:2.012218952179 / seconds
Query Executed:select id FROM `va` where city='Ivor' && SIC_code='8661'DB:business_master_new
loadtime:2.0133190155029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivy' limit 1
loadtime:2.0133850574493 / seconds
Query Executed:select id FROM `va` where city='Ivy' && SIC_code='8661'DB:business_master_new
loadtime:2.0141410827637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:2.014219045639 / seconds
Query Executed:select id FROM `va` where city='Jamaica' && SIC_code='8661'DB:business_master_new
loadtime:2.0145919322968 / seconds
Query loaded from cache:select * from geodata_geocity where city='James Store' limit 1
loadtime:2.0146360397339 / seconds
Query Executed:select id FROM `va` where city='James Store' && SIC_code='8661'DB:business_master_new
loadtime:2.014876127243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:2.0149259567261 / seconds
Query Executed:select id FROM `va` where city='Jamestown' && SIC_code='8661'DB:business_master_new
loadtime:2.0151650905609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:2.0152180194855 / seconds
Query Executed:select id FROM `va` where city='Jamesville' && SIC_code='8661'DB:business_master_new
loadtime:2.0155320167542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarratt' limit 1
loadtime:2.0155770778656 / seconds
Query Executed:select id FROM `va` where city='Jarratt' && SIC_code='8661'DB:business_master_new
loadtime:2.0167140960693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:2.016783952713 / seconds
Query Executed:select id FROM `va` where city='Java' && SIC_code='8661'DB:business_master_new
loadtime:2.017373085022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonton' limit 1
loadtime:2.0174119472504 / seconds
Query Executed:select id FROM `va` where city='Jeffersonton' && SIC_code='8661'DB:business_master_new
loadtime:2.0182249546051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkins Bridge' limit 1
loadtime:2.018285036087 / seconds
Query Executed:select id FROM `va` where city='Jenkins Bridge' && SIC_code='8661'DB:business_master_new
loadtime:2.0185379981995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey' limit 1
loadtime:2.0185720920563 / seconds
Query Executed:select id FROM `va` where city='Jersey' && SIC_code='8661'DB:business_master_new
loadtime:2.0188679695129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetersville' limit 1
loadtime:2.0189130306244 / seconds
Query Executed:select id FROM `va` where city='Jetersville' && SIC_code='8661'DB:business_master_new
loadtime:2.0198681354523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell Ridge' limit 1
loadtime:2.0199301242828 / seconds
Query Executed:select id FROM `va` where city='Jewell Ridge' && SIC_code='8661'DB:business_master_new
loadtime:2.0202920436859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:2.0203330516815 / seconds
Query Executed:select id FROM `va` where city='Jonesville' && SIC_code='8661'DB:business_master_new
loadtime:2.0226719379425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keeling' limit 1
loadtime:2.0227310657501 / seconds
Query Executed:select id FROM `va` where city='Keeling' && SIC_code='8661'DB:business_master_new
loadtime:2.0233030319214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keen Mountain' limit 1
loadtime:2.0233559608459 / seconds
Query Executed:select id FROM `va` where city='Keen Mountain' && SIC_code='8661'DB:business_master_new
loadtime:2.0237979888916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:2.0238521099091 / seconds
Query Executed:select id FROM `va` where city='Keene' && SIC_code='8661'DB:business_master_new
loadtime:2.0242509841919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keezletown' limit 1
loadtime:2.0242891311646 / seconds
Query Executed:select id FROM `va` where city='Keezletown' && SIC_code='8661'DB:business_master_new
loadtime:2.0248911380768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:2.0249419212341 / seconds
Query Executed:select id FROM `va` where city='Keller' && SIC_code='8661'DB:business_master_new
loadtime:2.0254149436951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenbridge' limit 1
loadtime:2.0254690647125 / seconds
Query Executed:select id FROM `va` where city='Kenbridge' && SIC_code='8661'DB:business_master_new
loadtime:2.0277490615845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kents Store' limit 1
loadtime:2.0278100967407 / seconds
Query Executed:select id FROM `va` where city='Kents Store' && SIC_code='8661'DB:business_master_new
loadtime:2.0284340381622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokee' limit 1
loadtime:2.0284879207611 / seconds
Query Executed:select id FROM `va` where city='Keokee' && SIC_code='8661'DB:business_master_new
loadtime:2.028883934021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:2.0289270877838 / seconds
Query Executed:select id FROM `va` where city='Keswick' && SIC_code='8661'DB:business_master_new
loadtime:2.0310299396515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keysville' limit 1
loadtime:2.0310859680176 / seconds
Query Executed:select id FROM `va` where city='Keysville' && SIC_code='8661'DB:business_master_new
loadtime:2.0336151123047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmarnock' limit 1
loadtime:2.0336859226227 / seconds
Query Executed:select id FROM `va` where city='Kilmarnock' && SIC_code='8661'DB:business_master_new
loadtime:2.0445830821991 / seconds
Query loaded from cache:select * from geodata_geocity where city='King & Queen C H' limit 1
loadtime:2.0446410179138 / seconds
Query Executed:select id FROM `va` where city='King & Queen C H' && SIC_code='8661'DB:business_master_new
loadtime:2.0449540615082 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court Hous' limit 1
loadtime:2.0450141429901 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court Hous' && SIC_code='8661'DB:business_master_new
loadtime:2.0453851222992 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court House' limit 1
loadtime:2.0454139709473 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court House' && SIC_code='8661'DB:business_master_new
loadtime:2.046324968338 / seconds
Query loaded from cache:select * from geodata_geocity where city='King George' limit 1
loadtime:2.0463860034943 / seconds
Query Executed:select id FROM `va` where city='King George' && SIC_code='8661'DB:business_master_new
loadtime:2.0576491355896 / seconds
Query loaded from cache:select * from geodata_geocity where city='King William' limit 1
loadtime:2.0577149391174 / seconds
Query Executed:select id FROM `va` where city='King William' && SIC_code='8661'DB:business_master_new
loadtime:2.0610530376434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsale' limit 1
loadtime:2.0611250400543 / seconds
Query Executed:select id FROM `va` where city='Kinsale' && SIC_code='8661'DB:business_master_new
loadtime:2.0620999336243 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:2.0621650218964 / seconds
Query Executed:select id FROM `va` where city='La Crosse' && SIC_code='8661'DB:business_master_new
loadtime:2.0652611255646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey Spring' limit 1
loadtime:2.0653140544891 / seconds
Query Executed:select id FROM `va` where city='Lacey Spring' && SIC_code='8661'DB:business_master_new
loadtime:2.0656819343567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lackey' limit 1
loadtime:2.0657410621643 / seconds
Query Executed:select id FROM `va` where city='Lackey' && SIC_code='8661'DB:business_master_new
loadtime:2.0662779808044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:2.0663249492645 / seconds
Query Executed:select id FROM `va` where city='Ladysmith' && SIC_code='8661'DB:business_master_new
loadtime:2.0674240589142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:2.0674860477448 / seconds
Query Executed:select id FROM `va` where city='Lafayette' && SIC_code='8661'DB:business_master_new
loadtime:2.0677390098572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambsburg' limit 1
loadtime:2.0677750110626 / seconds
Query Executed:select id FROM `va` where city='Lambsburg' && SIC_code='8661'DB:business_master_new
loadtime:2.0682849884033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:2.0683209896088 / seconds
Query Executed:select id FROM `va` where city='Lancaster' && SIC_code='8661'DB:business_master_new
loadtime:2.0710730552673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laneview' limit 1
loadtime:2.0711240768433 / seconds
Query Executed:select id FROM `va` where city='Laneview' && SIC_code='8661'DB:business_master_new
loadtime:2.0715079307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanexa' limit 1
loadtime:2.0715620517731 / seconds
Query Executed:select id FROM `va` where city='Lanexa' && SIC_code='8661'DB:business_master_new
loadtime:2.0729870796204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley Afb' limit 1
loadtime:2.0730400085449 / seconds
Query Executed:select id FROM `va` where city='Langley Afb' && SIC_code='8661'DB:business_master_new
loadtime:2.0733821392059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Fork' limit 1
loadtime:2.0734231472015 / seconds
Query Executed:select id FROM `va` where city='Laurel Fork' && SIC_code='8661'DB:business_master_new
loadtime:2.0739810466766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:2.0740361213684 / seconds
Query Executed:select id FROM `va` where city='Lawrenceville' && SIC_code='8661'DB:business_master_new
loadtime:2.0781681537628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:2.0782589912415 / seconds
Query Executed:select id FROM `va` where city='Lebanon' && SIC_code='8661'DB:business_master_new
loadtime:2.0834090709686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon Church' limit 1
loadtime:2.0834641456604 / seconds
Query Executed:select id FROM `va` where city='Lebanon Church' && SIC_code='8661'DB:business_master_new
loadtime:2.0837030410767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:2.0837509632111 / seconds
Query Executed:select id FROM `va` where city='Leesburg' && SIC_code='8661'DB:business_master_new
loadtime:2.0908560752869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:2.0909481048584 / seconds
Query Executed:select id FROM `va` where city='Leon' && SIC_code='8661'DB:business_master_new
loadtime:2.0914549827576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:2.0915050506592 / seconds
Query Executed:select id FROM `va` where city='Lexington' && SIC_code='8661'DB:business_master_new
loadtime:2.0975511074066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lightfoot' limit 1
loadtime:2.0977189540863 / seconds
Query Executed:select id FROM `va` where city='Lightfoot' && SIC_code='8661'DB:business_master_new
loadtime:2.0985560417175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lignum' limit 1
loadtime:2.0986039638519 / seconds
Query Executed:select id FROM `va` where city='Lignum' && SIC_code='8661'DB:business_master_new
loadtime:2.0991389751434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:2.099219083786 / seconds
Query Executed:select id FROM `va` where city='Lincoln' && SIC_code='8661'DB:business_master_new
loadtime:2.0997350215912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:2.0997960567474 / seconds
Query Executed:select id FROM `va` where city='Linden' && SIC_code='8661'DB:business_master_new
loadtime:2.1011469364166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:2.1012260913849 / seconds
Query Executed:select id FROM `va` where city='Linville' && SIC_code='8661'DB:business_master_new
loadtime:2.1021060943604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Plymouth' limit 1
loadtime:2.1021749973297 / seconds
Query Executed:select id FROM `va` where city='Little Plymouth' && SIC_code='8661'DB:business_master_new
loadtime:2.1026220321655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lively' limit 1
loadtime:2.1026840209961 / seconds
Query Executed:select id FROM `va` where city='Lively' && SIC_code='8661'DB:business_master_new
loadtime:2.1033630371094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Dale' limit 1
loadtime:2.103404045105 / seconds
Query Executed:select id FROM `va` where city='Locust Dale' && SIC_code='8661'DB:business_master_new
loadtime:2.1038210391998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Grove' limit 1
loadtime:2.1038749217987 / seconds
Query Executed:select id FROM `va` where city='Locust Grove' && SIC_code='8661'DB:business_master_new
loadtime:2.1076829433441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Hill' limit 1
loadtime:2.1077311038971 / seconds
Query Executed:select id FROM `va` where city='Locust Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.1083030700684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locustville' limit 1
loadtime:2.1083550453186 / seconds
Query Executed:select id FROM `va` where city='Locustville' && SIC_code='8661'DB:business_master_new
loadtime:2.1087720394135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:2.1088199615479 / seconds
Query Executed:select id FROM `va` where city='Long Island' && SIC_code='8661'DB:business_master_new
loadtime:2.1093699932098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:2.1094260215759 / seconds
Query Executed:select id FROM `va` where city='Loretto' && SIC_code='8661'DB:business_master_new
loadtime:2.1097590923309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorton' limit 1
loadtime:2.1098051071167 / seconds
Query Executed:select id FROM `va` where city='Lorton' && SIC_code='8661'DB:business_master_new
loadtime:2.1162390708923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lottsburg' limit 1
loadtime:2.1163210868835 / seconds
Query Executed:select id FROM `va` where city='Lottsburg' && SIC_code='8661'DB:business_master_new
loadtime:2.1173260211945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisa' limit 1
loadtime:2.1173820495605 / seconds
Query Executed:select id FROM `va` where city='Louisa' && SIC_code='8661'DB:business_master_new
loadtime:2.1228640079498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovettsville' limit 1
loadtime:2.1229450702667 / seconds
Query Executed:select id FROM `va` where city='Lovettsville' && SIC_code='8661'DB:business_master_new
loadtime:2.1256539821625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovingston' limit 1
loadtime:2.1257050037384 / seconds
Query Executed:select id FROM `va` where city='Lovingston' && SIC_code='8661'DB:business_master_new
loadtime:2.1277029514313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:2.1277740001678 / seconds
Query Executed:select id FROM `va` where city='Low Moor' && SIC_code='8661'DB:business_master_new
loadtime:2.1284699440002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowesville' limit 1
loadtime:2.1285059452057 / seconds
Query Executed:select id FROM `va` where city='Lowesville' && SIC_code='8661'DB:business_master_new
loadtime:2.1288270950317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowmoor' limit 1
loadtime:2.128888130188 / seconds
Query Executed:select id FROM `va` where city='Lowmoor' && SIC_code='8661'DB:business_master_new
loadtime:2.1292431354523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:2.1292841434479 / seconds
Query Executed:select id FROM `va` where city='Lowry' && SIC_code='8661'DB:business_master_new
loadtime:2.1296100616455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:2.1296629905701 / seconds
Query Executed:select id FROM `va` where city='Lunenburg' && SIC_code='8661'DB:business_master_new
loadtime:2.1302649974823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:2.1303160190582 / seconds
Query Executed:select id FROM `va` where city='Luray' && SIC_code='8661'DB:business_master_new
loadtime:2.136137008667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynch Station' limit 1
loadtime:2.1362330913544 / seconds
Query Executed:select id FROM `va` where city='Lynch Station' && SIC_code='8661'DB:business_master_new
loadtime:2.1371130943298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:2.1371810436249 / seconds
Query Executed:select id FROM `va` where city='Lynchburg' && SIC_code='8661'DB:business_master_new
loadtime:2.1475801467896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:2.1478271484375 / seconds
Query Executed:select id FROM `va` where city='Lyndhurst' && SIC_code='8661'DB:business_master_new
loadtime:2.1489250659943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Machipongo' limit 1
loadtime:2.149001121521 / seconds
Query Executed:select id FROM `va` where city='Machipongo' && SIC_code='8661'DB:business_master_new
loadtime:2.1497459411621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:2.1498079299927 / seconds
Query Executed:select id FROM `va` where city='Macon' && SIC_code='8661'DB:business_master_new
loadtime:2.1502139568329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:2.1502420902252 / seconds
Query Executed:select id FROM `va` where city='Madison' && SIC_code='8661'DB:business_master_new
loadtime:2.154139995575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:2.1542191505432 / seconds
Query Executed:select id FROM `va` where city='Madison Heights' && SIC_code='8661'DB:business_master_new
loadtime:2.1599271297455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Mills' limit 1
loadtime:2.1600151062012 / seconds
Query Executed:select id FROM `va` where city='Madison Mills' && SIC_code='8661'DB:business_master_new
loadtime:2.1603829860687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidens' limit 1
loadtime:2.1604261398315 / seconds
Query Executed:select id FROM `va` where city='Maidens' && SIC_code='8661'DB:business_master_new
loadtime:2.161425113678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manakin Sabot' limit 1
loadtime:2.1614861488342 / seconds
Query Executed:select id FROM `va` where city='Manakin Sabot' && SIC_code='8661'DB:business_master_new
loadtime:2.1647250652313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas' limit 1
loadtime:2.1647839546204 / seconds
Query Executed:select id FROM `va` where city='Manassas' && SIC_code='8661'DB:business_master_new
loadtime:2.1742830276489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas Park' limit 1
loadtime:2.1744170188904 / seconds
Query Executed:select id FROM `va` where city='Manassas Park' && SIC_code='8661'DB:business_master_new
loadtime:2.1748950481415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mangohick' limit 1
loadtime:2.1749510765076 / seconds
Query Executed:select id FROM `va` where city='Mangohick' && SIC_code='8661'DB:business_master_new
loadtime:2.175262928009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannboro' limit 1
loadtime:2.1752901077271 / seconds
Query Executed:select id FROM `va` where city='Mannboro' && SIC_code='8661'DB:business_master_new
loadtime:2.1756479740143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manquin' limit 1
loadtime:2.1757090091705 / seconds
Query Executed:select id FROM `va` where city='Manquin' && SIC_code='8661'DB:business_master_new
loadtime:2.1764271259308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mappsville' limit 1
loadtime:2.1764631271362 / seconds
Query Executed:select id FROM `va` where city='Mappsville' && SIC_code='8661'DB:business_master_new
loadtime:2.1769690513611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:2.1770300865173 / seconds
Query Executed:select id FROM `va` where city='Marion' && SIC_code='8661'DB:business_master_new
loadtime:2.1828711032867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marionville' limit 1
loadtime:2.1829540729523 / seconds
Query Executed:select id FROM `va` where city='Marionville' && SIC_code='8661'DB:business_master_new
loadtime:2.1833131313324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markham' limit 1
loadtime:2.1833670139313 / seconds
Query Executed:select id FROM `va` where city='Markham' && SIC_code='8661'DB:business_master_new
loadtime:2.1839239597321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:2.1839790344238 / seconds
Query Executed:select id FROM `va` where city='Marshall' && SIC_code='8661'DB:business_master_new
loadtime:2.1884191036224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:2.1884920597076 / seconds
Query Executed:select id FROM `va` where city='Martinsville' && SIC_code='8661'DB:business_master_new
loadtime:2.1962480545044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maryus' limit 1
loadtime:2.1963901519775 / seconds
Query Executed:select id FROM `va` where city='Maryus' && SIC_code='8661'DB:business_master_new
loadtime:2.1967661380768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mascot' limit 1
loadtime:2.1968309879303 / seconds
Query Executed:select id FROM `va` where city='Mascot' && SIC_code='8661'DB:business_master_new
loadtime:2.1971020698547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massies Mill' limit 1
loadtime:2.1971390247345 / seconds
Query Executed:select id FROM `va` where city='Massies Mill' && SIC_code='8661'DB:business_master_new
loadtime:2.1974129676819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:2.1974499225616 / seconds
Query Executed:select id FROM `va` where city='Mathews' && SIC_code='8661'DB:business_master_new
loadtime:2.2004330158234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattaponi' limit 1
loadtime:2.2004890441895 / seconds
Query Executed:select id FROM `va` where city='Mattaponi' && SIC_code='8661'DB:business_master_new
loadtime:2.2011511325836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurertown' limit 1
loadtime:2.201229095459 / seconds
Query Executed:select id FROM `va` where city='Maurertown' && SIC_code='8661'DB:business_master_new
loadtime:2.2022790908813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mavisdale' limit 1
loadtime:2.2023301124573 / seconds
Query Executed:select id FROM `va` where city='Mavisdale' && SIC_code='8661'DB:business_master_new
loadtime:2.2027249336243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Max Meadows' limit 1
loadtime:2.2027831077576 / seconds
Query Executed:select id FROM `va` where city='Max Meadows' && SIC_code='8661'DB:business_master_new
loadtime:2.2050440311432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxie' limit 1
loadtime:2.2050940990448 / seconds
Query Executed:select id FROM `va` where city='Maxie' && SIC_code='8661'DB:business_master_new
loadtime:2.2055900096893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clure' limit 1
loadtime:2.2056441307068 / seconds
Query Executed:select id FROM `va` where city='Mc Clure' && SIC_code='8661'DB:business_master_new
loadtime:2.2060630321503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:2.2061040401459 / seconds
Query Executed:select id FROM `va` where city='Mc Coy' && SIC_code='8661'DB:business_master_new
loadtime:2.2065351009369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Dowell' limit 1
loadtime:2.2065999507904 / seconds
Query Executed:select id FROM `va` where city='Mc Dowell' && SIC_code='8661'DB:business_master_new
loadtime:2.2072670459747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gaheysville' limit 1
loadtime:2.207328081131 / seconds
Query Executed:select id FROM `va` where city='Mc Gaheysville' && SIC_code='8661'DB:business_master_new
loadtime:2.208927154541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenney' limit 1
loadtime:2.2089760303497 / seconds
Query Executed:select id FROM `va` where city='Mc Kenney' && SIC_code='8661'DB:business_master_new
loadtime:2.2102041244507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lean' limit 1
loadtime:2.2102699279785 / seconds
Query Executed:select id FROM `va` where city='Mc Lean' && SIC_code='8661'DB:business_master_new
loadtime:2.2183780670166 / seconds
Query Executed:select * from geodata_geocity where city='Mckenney' limit 1DB:business_master_new
loadtime:2.2187540531158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mclean' limit 1
loadtime:2.2187900543213 / seconds
Query Executed:select id FROM `va` where city='Mclean' && SIC_code='8661'DB:business_master_new
loadtime:2.2194650173187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows Of Dan' limit 1
loadtime:2.219514131546 / seconds
Query Executed:select id FROM `va` where city='Meadows Of Dan' && SIC_code='8661'DB:business_master_new
loadtime:2.2206380367279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowview' limit 1
loadtime:2.2206890583038 / seconds
Query Executed:select id FROM `va` where city='Meadowview' && SIC_code='8661'DB:business_master_new
loadtime:2.2223999500275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:2.2224681377411 / seconds
Query Executed:select id FROM `va` where city='Mears' && SIC_code='8661'DB:business_master_new
loadtime:2.2229030132294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:2.2229399681091 / seconds
Query Executed:select id FROM `va` where city='Mechanicsville' && SIC_code='8661'DB:business_master_new
loadtime:2.2299370765686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meherrin' limit 1
loadtime:2.2300379276276 / seconds
Query Executed:select id FROM `va` where city='Meherrin' && SIC_code='8661'DB:business_master_new
loadtime:2.2308261394501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melfa' limit 1
loadtime:2.2308919429779 / seconds
Query Executed:select id FROM `va` where city='Melfa' && SIC_code='8661'DB:business_master_new
loadtime:2.2322289943695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendota' limit 1
loadtime:2.2322909832001 / seconds
Query Executed:select id FROM `va` where city='Mendota' && SIC_code='8661'DB:business_master_new
loadtime:2.232764005661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredithville' limit 1
loadtime:2.2328150272369 / seconds
Query Executed:select id FROM `va` where city='Meredithville' && SIC_code='8661'DB:business_master_new
loadtime:2.2331161499023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrifield' limit 1
loadtime:2.2331500053406 / seconds
Query Executed:select id FROM `va` where city='Merrifield' && SIC_code='8661'DB:business_master_new
loadtime:2.2348439693451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Point' limit 1
loadtime:2.234904050827 / seconds
Query Executed:select id FROM `va` where city='Merry Point' && SIC_code='8661'DB:business_master_new
loadtime:2.2352559566498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebrook' limit 1
loadtime:2.2352890968323 / seconds
Query Executed:select id FROM `va` where city='Middlebrook' && SIC_code='8661'DB:business_master_new
loadtime:2.2359690666199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:2.236034154892 / seconds
Query Executed:select id FROM `va` where city='Middleburg' && SIC_code='8661'DB:business_master_new
loadtime:2.2412700653076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:2.2413330078125 / seconds
Query Executed:select id FROM `va` where city='Middletown' && SIC_code='8661'DB:business_master_new
loadtime:2.243143081665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:2.2432191371918 / seconds
Query Executed:select id FROM `va` where city='Midland' && SIC_code='8661'DB:business_master_new
loadtime:2.2447221279144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midlothian' limit 1
loadtime:2.2447891235352 / seconds
Query Executed:select id FROM `va` where city='Midlothian' && SIC_code='8661'DB:business_master_new
loadtime:2.2521550655365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:2.2522671222687 / seconds
Query Executed:select id FROM `va` where city='Milford' && SIC_code='8661'DB:business_master_new
loadtime:2.2534990310669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millboro' limit 1
loadtime:2.2541239261627 / seconds
Query Executed:select id FROM `va` where city='Millboro' && SIC_code='8661'DB:business_master_new
loadtime:2.2551469802856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Tavern' limit 1
loadtime:2.2552280426025 / seconds
Query Executed:select id FROM `va` where city='Millers Tavern' && SIC_code='8661'DB:business_master_new
loadtime:2.2557809352875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:2.2558500766754 / seconds
Query Executed:select id FROM `va` where city='Millwood' && SIC_code='8661'DB:business_master_new
loadtime:2.2564151287079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Run' limit 1
loadtime:2.2564520835876 / seconds
Query Executed:select id FROM `va` where city='Mine Run' && SIC_code='8661'DB:business_master_new
loadtime:2.2567131519318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:2.2567501068115 / seconds
Query Executed:select id FROM `va` where city='Mineral' && SIC_code='8661'DB:business_master_new
loadtime:2.2600729465485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Spring' limit 1
loadtime:2.2601580619812 / seconds
Query Executed:select id FROM `va` where city='Mint Spring' && SIC_code='8661'DB:business_master_new
loadtime:2.2606310844421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchells' limit 1
loadtime:2.2606859207153 / seconds
Query Executed:select id FROM `va` where city='Mitchells' && SIC_code='8661'DB:business_master_new
loadtime:2.2611660957336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modest Town' limit 1
loadtime:2.2612321376801 / seconds
Query Executed:select id FROM `va` where city='Modest Town' && SIC_code='8661'DB:business_master_new
loadtime:2.2615959644318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mollusk' limit 1
loadtime:2.2616529464722 / seconds
Query Executed:select id FROM `va` where city='Mollusk' && SIC_code='8661'DB:business_master_new
loadtime:2.2620620727539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moneta' limit 1
loadtime:2.2620990276337 / seconds
Query Executed:select id FROM `va` where city='Moneta' && SIC_code='8661'DB:business_master_new
loadtime:2.2675340175629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.2676110267639 / seconds
Query Executed:select id FROM `va` where city='Monroe' && SIC_code='8661'DB:business_master_new
loadtime:2.2691481113434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montebello' limit 1
loadtime:2.2692401409149 / seconds
Query Executed:select id FROM `va` where city='Montebello' && SIC_code='8661'DB:business_master_new
loadtime:2.2696859836578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:2.2697350978851 / seconds
Query Executed:select id FROM `va` where city='Monterey' && SIC_code='8661'DB:business_master_new
loadtime:2.2716610431671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:2.2717289924622 / seconds
Query Executed:select id FROM `va` where city='Montpelier' && SIC_code='8661'DB:business_master_new
loadtime:2.2742750644684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Sta' limit 1
loadtime:2.2743411064148 / seconds
Query Executed:select id FROM `va` where city='Montpelier Sta' && SIC_code='8661'DB:business_master_new
loadtime:2.2746160030365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Station' limit 1
loadtime:2.2746450901031 / seconds
Query Executed:select id FROM `va` where city='Montpelier Station' && SIC_code='8661'DB:business_master_new
loadtime:2.2749979496002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montross' limit 1
loadtime:2.2750380039215 / seconds
Query Executed:select id FROM `va` where city='Montross' && SIC_code='8661'DB:business_master_new
loadtime:2.2780170440674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:2.2780930995941 / seconds
Query Executed:select id FROM `va` where city='Montvale' && SIC_code='8661'DB:business_master_new
loadtime:2.2791259288788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moon' limit 1
loadtime:2.2791979312897 / seconds
Query Executed:select id FROM `va` where city='Moon' && SIC_code='8661'DB:business_master_new
loadtime:2.2796320915222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morattico' limit 1
loadtime:2.2796881198883 / seconds
Query Executed:select id FROM `va` where city='Morattico' && SIC_code='8661'DB:business_master_new
loadtime:2.2800390720367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:2.2800929546356 / seconds
Query Executed:select id FROM `va` where city='Morrisville' && SIC_code='8661'DB:business_master_new
loadtime:2.2803800106049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moseley' limit 1
loadtime:2.2804131507874 / seconds
Query Executed:select id FROM `va` where city='Moseley' && SIC_code='8661'DB:business_master_new
loadtime:2.2821760177612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Crawford' limit 1
loadtime:2.2822561264038 / seconds
Query Executed:select id FROM `va` where city='Mount Crawford' && SIC_code='8661'DB:business_master_new
loadtime:2.2840170860291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:2.2840869426727 / seconds
Query Executed:select id FROM `va` where city='Mount Holly' && SIC_code='8661'DB:business_master_new
loadtime:2.2846150398254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Jackson' limit 1
loadtime:2.2846660614014 / seconds
Query Executed:select id FROM `va` where city='Mount Jackson' && SIC_code='8661'DB:business_master_new
loadtime:2.2880139350891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sidney' limit 1
loadtime:2.2880790233612 / seconds
Query Executed:select id FROM `va` where city='Mount Sidney' && SIC_code='8661'DB:business_master_new
loadtime:2.2891249656677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Solon' limit 1
loadtime:2.2892079353333 / seconds
Query Executed:select id FROM `va` where city='Mount Solon' && SIC_code='8661'DB:business_master_new
loadtime:2.290333032608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:2.2903959751129 / seconds
Query Executed:select id FROM `va` where city='Mount Vernon' && SIC_code='8661'DB:business_master_new
loadtime:2.2910630702972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mouth Of Wilson' limit 1
loadtime:2.2911169528961 / seconds
Query Executed:select id FROM `va` where city='Mouth Of Wilson' && SIC_code='8661'DB:business_master_new
loadtime:2.2919080257416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Crawford' limit 1
loadtime:2.2919671535492 / seconds
Query Executed:select id FROM `va` where city='Mt Crawford' && SIC_code='8661'DB:business_master_new
loadtime:2.2923290729523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:2.2923760414124 / seconds
Query Executed:select id FROM `va` where city='Mt Holly' && SIC_code='8661'DB:business_master_new
loadtime:2.2926440238953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Jackson' limit 1
loadtime:2.2926750183105 / seconds
Query Executed:select id FROM `va` where city='Mt Jackson' && SIC_code='8661'DB:business_master_new
loadtime:2.2930979728699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sidney' limit 1
loadtime:2.2931439876556 / seconds
Query Executed:select id FROM `va` where city='Mt Sidney' && SIC_code='8661'DB:business_master_new
loadtime:2.2935199737549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Solon' limit 1
loadtime:2.2935719490051 / seconds
Query Executed:select id FROM `va` where city='Mt Solon' && SIC_code='8661'DB:business_master_new
loadtime:2.2938520908356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:2.293897151947 / seconds
Query Executed:select id FROM `va` where city='Mt Vernon' && SIC_code='8661'DB:business_master_new
loadtime:2.2942430973053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mustoe' limit 1
loadtime:2.2942841053009 / seconds
Query Executed:select id FROM `va` where city='Mustoe' && SIC_code='8661'DB:business_master_new
loadtime:2.2945590019226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narrows' limit 1
loadtime:2.2945940494537 / seconds
Query Executed:select id FROM `va` where city='Narrows' && SIC_code='8661'DB:business_master_new
loadtime:2.2964839935303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naruna' limit 1
loadtime:2.2965381145477 / seconds
Query Executed:select id FROM `va` where city='Naruna' && SIC_code='8661'DB:business_master_new
loadtime:2.2970039844513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nassawadox' limit 1
loadtime:2.2970650196075 / seconds
Query Executed:select id FROM `va` where city='Nassawadox' && SIC_code='8661'DB:business_master_new
loadtime:2.298278093338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathalie' limit 1
loadtime:2.2983241081238 / seconds
Query Executed:select id FROM `va` where city='Nathalie' && SIC_code='8661'DB:business_master_new
loadtime:2.3000719547272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Brdg Sta' limit 1
loadtime:2.3001489639282 / seconds
Query Executed:select id FROM `va` where city='Natural Brdg Sta' && SIC_code='8661'DB:business_master_new
loadtime:2.3005230426788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge' limit 1
loadtime:2.3005621433258 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge' && SIC_code='8661'DB:business_master_new
loadtime:2.3016519546509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge Station' limit 1
loadtime:2.3017160892487 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge Station' && SIC_code='8661'DB:business_master_new
loadtime:2.3023900985718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naval Base' limit 1
loadtime:2.3024280071259 / seconds
Query Executed:select id FROM `va` where city='Naval Base' && SIC_code='8661'DB:business_master_new
loadtime:2.3029210567474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellysford' limit 1
loadtime:2.3029749393463 / seconds
Query Executed:select id FROM `va` where city='Nellysford' && SIC_code='8661'DB:business_master_new
loadtime:2.3045909404755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:2.3046510219574 / seconds
Query Executed:select id FROM `va` where city='Nelson' && SIC_code='8661'DB:business_master_new
loadtime:2.3051550388336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonia' limit 1
loadtime:2.305230140686 / seconds
Query Executed:select id FROM `va` where city='Nelsonia' && SIC_code='8661'DB:business_master_new
loadtime:2.3057079315186 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canton' limit 1
loadtime:2.3057551383972 / seconds
Query Executed:select id FROM `va` where city='New Canton' && SIC_code='8661'DB:business_master_new
loadtime:2.3064501285553 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:2.3065030574799 / seconds
Query Executed:select id FROM `va` where city='New Castle' && SIC_code='8661'DB:business_master_new
loadtime:2.3082151412964 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Church' limit 1
loadtime:2.3082780838013 / seconds
Query Executed:select id FROM `va` where city='New Church' && SIC_code='8661'DB:business_master_new
loadtime:2.3093740940094 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:2.3094401359558 / seconds
Query Executed:select id FROM `va` where city='New Hope' && SIC_code='8661'DB:business_master_new
loadtime:2.3099370002747 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Kent' limit 1
loadtime:2.3099920749664 / seconds
Query Executed:select id FROM `va` where city='New Kent' && SIC_code='8661'DB:business_master_new
loadtime:2.3115220069885 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:2.3115870952606 / seconds
Query Executed:select id FROM `va` where city='New Market' && SIC_code='8661'DB:business_master_new
loadtime:2.3149919509888 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Point' limit 1
loadtime:2.315062046051 / seconds
Query Executed:select id FROM `va` where city='New Point' && SIC_code='8661'DB:business_master_new
loadtime:2.3154110908508 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:2.3154590129852 / seconds
Query Executed:select id FROM `va` where city='New River' && SIC_code='8661'DB:business_master_new
loadtime:2.315838098526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:2.3158919811249 / seconds
Query Executed:select id FROM `va` where city='Newbern' && SIC_code='8661'DB:business_master_new
loadtime:2.316358089447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:2.3163931369781 / seconds
Query Executed:select id FROM `va` where city='Newington' && SIC_code='8661'DB:business_master_new
loadtime:2.3177480697632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:2.3178160190582 / seconds
Query Executed:select id FROM `va` where city='Newport' && SIC_code='8661'DB:business_master_new
loadtime:2.3187351226807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport News' limit 1
loadtime:2.3187990188599 / seconds
Query Executed:select id FROM `va` where city='Newport News' && SIC_code='8661'DB:business_master_new
loadtime:2.3320069313049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newsoms' limit 1
loadtime:2.3323309421539 / seconds
Query Executed:select id FROM `va` where city='Newsoms' && SIC_code='8661'DB:business_master_new
loadtime:2.3330581188202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:2.3331301212311 / seconds
Query Executed:select id FROM `va` where city='Newtown' && SIC_code='8661'DB:business_master_new
loadtime:2.333615064621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickelsville' limit 1
loadtime:2.3336601257324 / seconds
Query Executed:select id FROM `va` where city='Nickelsville' && SIC_code='8661'DB:business_master_new
loadtime:2.3345761299133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninde' limit 1
loadtime:2.3346309661865 / seconds
Query Executed:select id FROM `va` where city='Ninde' && SIC_code='8661'DB:business_master_new
loadtime:2.3350031375885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nokesville' limit 1
loadtime:2.335037946701 / seconds
Query Executed:select id FROM `va` where city='Nokesville' && SIC_code='8661'DB:business_master_new
loadtime:2.3382761478424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora' limit 1
loadtime:2.3383450508118 / seconds
Query Executed:select id FROM `va` where city='Nora' && SIC_code='8661'DB:business_master_new
loadtime:2.3388259410858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:2.3389029502869 / seconds
Query Executed:select id FROM `va` where city='Norfolk' && SIC_code='8661'DB:business_master_new
loadtime:2.3536591529846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norge' limit 1
loadtime:2.3540201187134 / seconds
Query Executed:select id FROM `va` where city='Norge' && SIC_code='8661'DB:business_master_new
loadtime:2.3545789718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:2.354651927948 / seconds
Query Executed:select id FROM `va` where city='North' && SIC_code='8661'DB:business_master_new
loadtime:2.355241060257 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Garden' limit 1
loadtime:2.355299949646 / seconds
Query Executed:select id FROM `va` where city='North Garden' && SIC_code='8661'DB:business_master_new
loadtime:2.3562610149384 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Tazewell' limit 1
loadtime:2.3563210964203 / seconds
Query Executed:select id FROM `va` where city='North Tazewell' && SIC_code='8661'DB:business_master_new
loadtime:2.3586370944977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:2.3587081432343 / seconds
Query Executed:select id FROM `va` where city='Norton' && SIC_code='8661'DB:business_master_new
loadtime:2.3641331195831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:2.3642251491547 / seconds
Query Executed:select id FROM `va` where city='Norwood' && SIC_code='8661'DB:business_master_new
loadtime:2.3645911216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottoway' limit 1
loadtime:2.3646371364594 / seconds
Query Executed:select id FROM `va` where city='Nottoway' && SIC_code='8661'DB:business_master_new
loadtime:2.3651819229126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nuttsville' limit 1
loadtime:2.3652601242065 / seconds
Query Executed:select id FROM `va` where city='Nuttsville' && SIC_code='8661'DB:business_master_new
loadtime:2.3655459880829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hall' limit 1
loadtime:2.3655819892883 / seconds
Query Executed:select id FROM `va` where city='Oak Hall' && SIC_code='8661'DB:business_master_new
loadtime:2.3663599491119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakpark' limit 1
loadtime:2.3664190769196 / seconds
Query Executed:select id FROM `va` where city='Oakpark' && SIC_code='8661'DB:business_master_new
loadtime:2.3667850494385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakton' limit 1
loadtime:2.3668370246887 / seconds
Query Executed:select id FROM `va` where city='Oakton' && SIC_code='8661'DB:business_master_new
loadtime:2.3722779750824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakwood' limit 1
loadtime:2.372533082962 / seconds
Query Executed:select id FROM `va` where city='Oakwood' && SIC_code='8661'DB:business_master_new
loadtime:2.3739259243011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Occoquan' limit 1
loadtime:2.3739919662476 / seconds
Query Executed:select id FROM `va` where city='Occoquan' && SIC_code='8661'DB:business_master_new
loadtime:2.3757960796356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oilville' limit 1
loadtime:2.3758490085602 / seconds
Query Executed:select id FROM `va` where city='Oilville' && SIC_code='8661'DB:business_master_new
loadtime:2.3769769668579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldhams' limit 1
loadtime:2.3770370483398 / seconds
Query Executed:select id FROM `va` where city='Oldhams' && SIC_code='8661'DB:business_master_new
loadtime:2.3773839473724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onancock' limit 1
loadtime:2.3774349689484 / seconds
Query Executed:select id FROM `va` where city='Onancock' && SIC_code='8661'DB:business_master_new
loadtime:2.3802659511566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onemo' limit 1
loadtime:2.3803300857544 / seconds
Query Executed:select id FROM `va` where city='Onemo' && SIC_code='8661'DB:business_master_new
loadtime:2.3807580471039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onley' limit 1
loadtime:2.3808181285858 / seconds
Query Executed:select id FROM `va` where city='Onley' && SIC_code='8661'DB:business_master_new
loadtime:2.3826770782471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophelia' limit 1
loadtime:2.3827369213104 / seconds
Query Executed:select id FROM `va` where city='Ophelia' && SIC_code='8661'DB:business_master_new
loadtime:2.3831191062927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:2.3831679821014 / seconds
Query Executed:select id FROM `va` where city='Orange' && SIC_code='8661'DB:business_master_new
loadtime:2.3886971473694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordinary' limit 1
loadtime:2.3887779712677 / seconds
Query Executed:select id FROM `va` where city='Ordinary' && SIC_code='8661'DB:business_master_new
loadtime:2.3893070220947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriskany' limit 1
loadtime:2.389347076416 / seconds
Query Executed:select id FROM `va` where city='Oriskany' && SIC_code='8661'DB:business_master_new
loadtime:2.3897571563721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orkney Springs' limit 1
loadtime:2.3898100852966 / seconds
Query Executed:select id FROM `va` where city='Orkney Springs' && SIC_code='8661'DB:business_master_new
loadtime:2.3902280330658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlean' limit 1
loadtime:2.3902699947357 / seconds
Query Executed:select id FROM `va` where city='Orlean' && SIC_code='8661'DB:business_master_new
loadtime:2.3907690048218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyster' limit 1
loadtime:2.3908369541168 / seconds
Query Executed:select id FROM `va` where city='Oyster' && SIC_code='8661'DB:business_master_new
loadtime:2.3912291526794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paeonian Springs' limit 1
loadtime:2.3912711143494 / seconds
Query Executed:select id FROM `va` where city='Paeonian Springs' && SIC_code='8661'DB:business_master_new
loadtime:2.3919739723206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Bank' limit 1
loadtime:2.3920171260834 / seconds
Query Executed:select id FROM `va` where city='Paint Bank' && SIC_code='8661'DB:business_master_new
loadtime:2.3923511505127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painter' limit 1
loadtime:2.3923950195312 / seconds
Query Executed:select id FROM `va` where city='Painter' && SIC_code='8661'DB:business_master_new
loadtime:2.393373966217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:2.3934330940247 / seconds
Query Executed:select id FROM `va` where city='Palmyra' && SIC_code='8661'DB:business_master_new
loadtime:2.3986690044403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplin' limit 1
loadtime:2.3987300395966 / seconds
Query Executed:select id FROM `va` where city='Pamplin' && SIC_code='8661'DB:business_master_new
loadtime:2.3996551036835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:2.3997240066528 / seconds
Query Executed:select id FROM `va` where city='Paris' && SIC_code='8661'DB:business_master_new
loadtime:2.4002480506897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksley' limit 1
loadtime:2.4002969264984 / seconds
Query Executed:select id FROM `va` where city='Parksley' && SIC_code='8661'DB:business_master_new
loadtime:2.402204990387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrott' limit 1
loadtime:2.4022650718689 / seconds
Query Executed:select id FROM `va` where city='Parrott' && SIC_code='8661'DB:business_master_new
loadtime:2.4026391506195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partlow' limit 1
loadtime:2.4026911258698 / seconds
Query Executed:select id FROM `va` where city='Partlow' && SIC_code='8661'DB:business_master_new
loadtime:2.4034340381622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick Springs' limit 1
loadtime:2.4034819602966 / seconds
Query Executed:select id FROM `va` where city='Patrick Springs' && SIC_code='8661'DB:business_master_new
loadtime:2.4046170711517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:2.4046840667725 / seconds
Query Executed:select id FROM `va` where city='Patterson' && SIC_code='8661'DB:business_master_new
loadtime:2.4050619602203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearisburg' limit 1
loadtime:2.4050979614258 / seconds
Query Executed:select id FROM `va` where city='Pearisburg' && SIC_code='8661'DB:business_master_new
loadtime:2.4087181091309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:2.408793926239 / seconds
Query Executed:select id FROM `va` where city='Pembroke' && SIC_code='8661'DB:business_master_new
loadtime:2.4104280471802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penhook' limit 1
loadtime:2.4104919433594 / seconds
Query Executed:select id FROM `va` where city='Penhook' && SIC_code='8661'DB:business_master_new
loadtime:2.4117069244385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penn Laird' limit 1
loadtime:2.4117770195007 / seconds
Query Executed:select id FROM `va` where city='Penn Laird' && SIC_code='8661'DB:business_master_new
loadtime:2.4127471446991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington Gap' limit 1
loadtime:2.4128000736237 / seconds
Query Executed:select id FROM `va` where city='Pennington Gap' && SIC_code='8661'DB:business_master_new
loadtime:2.4158811569214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:2.4159550666809 / seconds
Query Executed:select id FROM `va` where city='Petersburg' && SIC_code='8661'DB:business_master_new
loadtime:2.4236259460449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix' limit 1
loadtime:2.4237771034241 / seconds
Query Executed:select id FROM `va` where city='Phenix' && SIC_code='8661'DB:business_master_new
loadtime:2.4244000911713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomont' limit 1
loadtime:2.4244511127472 / seconds
Query Executed:select id FROM `va` where city='Philomont' && SIC_code='8661'DB:business_master_new
loadtime:2.4249329566956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilgrims Knob' limit 1
loadtime:2.4249880313873 / seconds
Query Executed:select id FROM `va` where city='Pilgrims Knob' && SIC_code='8661'DB:business_master_new
loadtime:2.4253721237183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot' limit 1
loadtime:2.4254200458527 / seconds
Query Executed:select id FROM `va` where city='Pilot' && SIC_code='8661'DB:business_master_new
loadtime:2.4260771274567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney River' limit 1
loadtime:2.4261231422424 / seconds
Query Executed:select id FROM `va` where city='Piney River' && SIC_code='8661'DB:business_master_new
loadtime:2.4267699718475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:2.4268319606781 / seconds
Query Executed:select id FROM `va` where city='Pittsville' && SIC_code='8661'DB:business_master_new
loadtime:2.427258014679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain View' limit 1
loadtime:2.4273171424866 / seconds
Query Executed:select id FROM `va` where city='Plain View' && SIC_code='8661'DB:business_master_new
loadtime:2.4275801181793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:2.4276311397552 / seconds
Query Executed:select id FROM `va` where city='Pleasant Valley' && SIC_code='8661'DB:business_master_new
loadtime:2.4280500411987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:2.4281070232391 / seconds
Query Executed:select id FROM `va` where city='Pocahontas' && SIC_code='8661'DB:business_master_new
loadtime:2.4287121295929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquoson' limit 1
loadtime:2.4287600517273 / seconds
Query Executed:select id FROM `va` where city='Poquoson' && SIC_code='8661'DB:business_master_new
loadtime:2.4339389801025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Haywood' limit 1
loadtime:2.4340081214905 / seconds
Query Executed:select id FROM `va` where city='Port Haywood' && SIC_code='8661'DB:business_master_new
loadtime:2.4346239566803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:2.4346780776978 / seconds
Query Executed:select id FROM `va` where city='Port Republic' && SIC_code='8661'DB:business_master_new
loadtime:2.4354231357574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:2.4354751110077 / seconds
Query Executed:select id FROM `va` where city='Port Royal' && SIC_code='8661'DB:business_master_new
loadtime:2.4362161159515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:2.4362630844116 / seconds
Query Executed:select id FROM `va` where city='Portsmouth' && SIC_code='8661'DB:business_master_new
loadtime:2.4456140995026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:2.4458329677582 / seconds
Query Executed:select id FROM `va` where city='Pound' && SIC_code='8661'DB:business_master_new
loadtime:2.4479970932007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pounding Mill' limit 1
loadtime:2.4480829238892 / seconds
Query Executed:select id FROM `va` where city='Pounding Mill' && SIC_code='8661'DB:business_master_new
loadtime:2.4493680000305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:2.4494180679321 / seconds
Query Executed:select id FROM `va` where city='Powhatan' && SIC_code='8661'DB:business_master_new
loadtime:2.4552021026611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratts' limit 1
loadtime:2.4552879333496 / seconds
Query Executed:select id FROM `va` where city='Pratts' && SIC_code='8661'DB:business_master_new
loadtime:2.4557180404663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince George' limit 1
loadtime:2.4557731151581 / seconds
Query Executed:select id FROM `va` where city='Prince George' && SIC_code='8661'DB:business_master_new
loadtime:2.4592089653015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:2.4592809677124 / seconds
Query Executed:select id FROM `va` where city='Prospect' && SIC_code='8661'DB:business_master_new
loadtime:2.4600911140442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence Forge' limit 1
loadtime:2.4601509571075 / seconds
Query Executed:select id FROM `va` where city='Providence Forge' && SIC_code='8661'DB:business_master_new
loadtime:2.4624180793762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:2.4624800682068 / seconds
Query Executed:select id FROM `va` where city='Pulaski' && SIC_code='8661'DB:business_master_new
loadtime:2.4681251049042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pungoteague' limit 1
loadtime:2.4682321548462 / seconds
Query Executed:select id FROM `va` where city='Pungoteague' && SIC_code='8661'DB:business_master_new
loadtime:2.4687030315399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purcellville' limit 1
loadtime:2.4687609672546 / seconds
Query Executed:select id FROM `va` where city='Purcellville' && SIC_code='8661'DB:business_master_new
loadtime:2.4742910861969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quantico' limit 1
loadtime:2.4743709564209 / seconds
Query Executed:select id FROM `va` where city='Quantico' && SIC_code='8661'DB:business_master_new
loadtime:2.4768171310425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quicksburg' limit 1
loadtime:2.4768631458282 / seconds
Query Executed:select id FROM `va` where city='Quicksburg' && SIC_code='8661'DB:business_master_new
loadtime:2.4776411056519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:2.4777030944824 / seconds
Query Executed:select id FROM `va` where city='Quinby' && SIC_code='8661'DB:business_master_new
loadtime:2.4780900478363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinque' limit 1
loadtime:2.4781329631805 / seconds
Query Executed:select id FROM `va` where city='Quinque' && SIC_code='8661'DB:business_master_new
loadtime:2.4785890579224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:2.4786500930786 / seconds
Query Executed:select id FROM `va` where city='Quinton' && SIC_code='8661'DB:business_master_new
loadtime:2.4812340736389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radford' limit 1
loadtime:2.4812951087952 / seconds
Query Executed:select id FROM `va` where city='Radford' && SIC_code='8661'DB:business_master_new
loadtime:2.4872629642487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radiant' limit 1
loadtime:2.4873580932617 / seconds
Query Executed:select id FROM `va` where city='Radiant' && SIC_code='8661'DB:business_master_new
loadtime:2.4878001213074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:2.4878640174866 / seconds
Query Executed:select id FROM `va` where city='Randolph' && SIC_code='8661'DB:business_master_new
loadtime:2.4882490634918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raphine' limit 1
loadtime:2.4882841110229 / seconds
Query Executed:select id FROM `va` where city='Raphine' && SIC_code='8661'DB:business_master_new
loadtime:2.4892909526825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapidan' limit 1
loadtime:2.4893641471863 / seconds
Query Executed:select id FROM `va` where city='Rapidan' && SIC_code='8661'DB:business_master_new
loadtime:2.4902319908142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Academy' limit 1
loadtime:2.4902849197388 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Academy' && SIC_code='8661'DB:business_master_new
loadtime:2.4906990528107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Acd' limit 1
loadtime:2.4907550811768 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Acd' && SIC_code='8661'DB:business_master_new
loadtime:2.4910399913788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raven' limit 1
loadtime:2.4910759925842 / seconds
Query Executed:select id FROM `va` where city='Raven' && SIC_code='8661'DB:business_master_new
loadtime:2.4918251037598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlings' limit 1
loadtime:2.4918899536133 / seconds
Query Executed:select id FROM `va` where city='Rawlings' && SIC_code='8661'DB:business_master_new
loadtime:2.4923319816589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rectortown' limit 1
loadtime:2.4923830032349 / seconds
Query Executed:select id FROM `va` where city='Rectortown' && SIC_code='8661'DB:business_master_new
loadtime:2.4927849769592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Ash' limit 1
loadtime:2.4928369522095 / seconds
Query Executed:select id FROM `va` where city='Red Ash' && SIC_code='8661'DB:business_master_new
loadtime:2.4931070804596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:2.493145942688 / seconds
Query Executed:select id FROM `va` where city='Red House' && SIC_code='8661'DB:business_master_new
loadtime:2.4936280250549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:2.4936909675598 / seconds
Query Executed:select id FROM `va` where city='Red Oak' && SIC_code='8661'DB:business_master_new
loadtime:2.4943749904633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redart' limit 1
loadtime:2.4944190979004 / seconds
Query Executed:select id FROM `va` where city='Redart' && SIC_code='8661'DB:business_master_new
loadtime:2.494665145874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:2.4947049617767 / seconds
Query Executed:select id FROM `va` where city='Redwood' && SIC_code='8661'DB:business_master_new
loadtime:2.4950640201569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedville' limit 1
loadtime:2.495090007782 / seconds
Query Executed:select id FROM `va` where city='Reedville' && SIC_code='8661'DB:business_master_new
loadtime:2.4967670440674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:2.4968349933624 / seconds
Query Executed:select id FROM `va` where city='Reliance' && SIC_code='8661'DB:business_master_new
loadtime:2.4971251487732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remington' limit 1
loadtime:2.4971680641174 / seconds
Query Executed:select id FROM `va` where city='Remington' && SIC_code='8661'DB:business_master_new
loadtime:2.4989070892334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republican Grove' limit 1
loadtime:2.4989650249481 / seconds
Query Executed:select id FROM `va` where city='Republican Grove' && SIC_code='8661'DB:business_master_new
loadtime:2.4992780685425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rescue' limit 1
loadtime:2.4993209838867 / seconds
Query Executed:select id FROM `va` where city='Rescue' && SIC_code='8661'DB:business_master_new
loadtime:2.4996831417084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reston' limit 1
loadtime:2.4997379779816 / seconds
Query Executed:select id FROM `va` where city='Reston' && SIC_code='8661'DB:business_master_new
loadtime:2.5070910453796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:2.5071749687195 / seconds
Query Executed:select id FROM `va` where city='Reva' && SIC_code='8661'DB:business_master_new
loadtime:2.5079889297485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhoadesville' limit 1
loadtime:2.5080490112305 / seconds
Query Executed:select id FROM `va` where city='Rhoadesville' && SIC_code='8661'DB:business_master_new
loadtime:2.508908033371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:2.5089681148529 / seconds
Query Executed:select id FROM `va` where city='Rice' && SIC_code='8661'DB:business_master_new
loadtime:2.5097880363464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Creek' limit 1
loadtime:2.5098569393158 / seconds
Query Executed:select id FROM `va` where city='Rich Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.5109550952911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richardsville' limit 1
loadtime:2.51100897789 / seconds
Query Executed:select id FROM `va` where city='Richardsville' && SIC_code='8661'DB:business_master_new
loadtime:2.5114710330963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:2.5115270614624 / seconds
Query Executed:select id FROM `va` where city='Richlands' && SIC_code='8661'DB:business_master_new
loadtime:2.5170090198517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:2.5170879364014 / seconds
Query Executed:select id FROM `va` where city='Richmond' && SIC_code='8661'DB:business_master_new
loadtime:2.5388879776001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:2.5394511222839 / seconds
Query Executed:select id FROM `va` where city='Ridgeway' && SIC_code='8661'DB:business_master_new
loadtime:2.5429329872131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rileyville' limit 1
loadtime:2.5430250167847 / seconds
Query Executed:select id FROM `va` where city='Rileyville' && SIC_code='8661'DB:business_master_new
loadtime:2.5436971187592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riner' limit 1
loadtime:2.5437619686127 / seconds
Query Executed:select id FROM `va` where city='Riner' && SIC_code='8661'DB:business_master_new
loadtime:2.5450551509857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringgold' limit 1
loadtime:2.5451209545135 / seconds
Query Executed:select id FROM `va` where city='Ringgold' && SIC_code='8661'DB:business_master_new
loadtime:2.547003030777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripplemead' limit 1
loadtime:2.5470631122589 / seconds
Query Executed:select id FROM `va` where city='Ripplemead' && SIC_code='8661'DB:business_master_new
loadtime:2.5476980209351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:2.5477509498596 / seconds
Query Executed:select id FROM `va` where city='Riverton' && SIC_code='8661'DB:business_master_new
loadtime:2.5480201244354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rixeyville' limit 1
loadtime:2.548061132431 / seconds
Query Executed:select id FROM `va` where city='Rixeyville' && SIC_code='8661'DB:business_master_new
loadtime:2.5492660999298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:2.549329996109 / seconds
Query Executed:select id FROM `va` where city='Roanoke' && SIC_code='8661'DB:business_master_new
loadtime:2.5632910728455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle' limit 1
loadtime:2.5636050701141 / seconds
Query Executed:select id FROM `va` where city='Rochelle' && SIC_code='8661'DB:business_master_new
loadtime:2.5643439292908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockbridge Baths' limit 1
loadtime:2.5644240379333 / seconds
Query Executed:select id FROM `va` where city='Rockbridge Baths' && SIC_code='8661'DB:business_master_new
loadtime:2.5650341510773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:2.5650930404663 / seconds
Query Executed:select id FROM `va` where city='Rockville' && SIC_code='8661'DB:business_master_new
loadtime:2.567214012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Gap' limit 1
loadtime:2.5672619342804 / seconds
Query Executed:select id FROM `va` where city='Rocky Gap' && SIC_code='8661'DB:business_master_new
loadtime:2.5680429935455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:2.5681059360504 / seconds
Query Executed:select id FROM `va` where city='Rocky Mount' && SIC_code='8661'DB:business_master_new
loadtime:2.5744149684906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollins Fork' limit 1
loadtime:2.5745191574097 / seconds
Query Executed:select id FROM `va` where city='Rollins Fork' && SIC_code='8661'DB:business_master_new
loadtime:2.5749599933624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:2.5750169754028 / seconds
Query Executed:select id FROM `va` where city='Rose Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.5760760307312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:2.5761439800262 / seconds
Query Executed:select id FROM `va` where city='Rosedale' && SIC_code='8661'DB:business_master_new
loadtime:2.5770709514618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:2.5771369934082 / seconds
Query Executed:select id FROM `va` where city='Roseland' && SIC_code='8661'DB:business_master_new
loadtime:2.5782489776611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Hill' limit 1
loadtime:2.5783100128174 / seconds
Query Executed:select id FROM `va` where city='Round Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.580381155014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:2.5804469585419 / seconds
Query Executed:select id FROM `va` where city='Rowe' && SIC_code='8661'DB:business_master_new
loadtime:2.5808720588684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:2.5809149742126 / seconds
Query Executed:select id FROM `va` where city='Ruby' && SIC_code='8661'DB:business_master_new
loadtime:2.5813391208649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruckersville' limit 1
loadtime:2.5813801288605 / seconds
Query Executed:select id FROM `va` where city='Ruckersville' && SIC_code='8661'DB:business_master_new
loadtime:2.5854330062866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Retreat' limit 1
loadtime:2.5855090618134 / seconds
Query Executed:select id FROM `va` where city='Rural Retreat' && SIC_code='8661'DB:business_master_new
loadtime:2.5875060558319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rustburg' limit 1
loadtime:2.5875580310822 / seconds
Query Executed:select id FROM `va` where city='Rustburg' && SIC_code='8661'DB:business_master_new
loadtime:2.591696023941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruther Glen' limit 1
loadtime:2.5917730331421 / seconds
Query Executed:select id FROM `va` where city='Ruther Glen' && SIC_code='8661'DB:business_master_new
loadtime:2.5949890613556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthville' limit 1
loadtime:2.5950591564178 / seconds
Query Executed:select id FROM `va` where city='Ruthville' && SIC_code='8661'DB:business_master_new
loadtime:2.5955159664154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:2.5955770015717 / seconds
Query Executed:select id FROM `va` where city='Saint Charles' && SIC_code='8661'DB:business_master_new
loadtime:2.5961000919342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:2.5961561203003 / seconds
Query Executed:select id FROM `va` where city='Saint Paul' && SIC_code='8661'DB:business_master_new
loadtime:2.5979249477386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens Church' limit 1
loadtime:2.5979990959167 / seconds
Query Executed:select id FROM `va` where city='Saint Stephens Church' && SIC_code='8661'DB:business_master_new
loadtime:2.5988121032715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.5988709926605 / seconds
Query Executed:select id FROM `va` where city='Salem' && SIC_code='8661'DB:business_master_new
loadtime:2.6057231426239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltville' limit 1
loadtime:2.6058280467987 / seconds
Query Executed:select id FROM `va` where city='Saltville' && SIC_code='8661'DB:business_master_new
loadtime:2.6080830097198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:2.6081631183624 / seconds
Query Executed:select id FROM `va` where city='Saluda' && SIC_code='8661'DB:business_master_new
loadtime:2.610475063324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandston' limit 1
loadtime:2.6105470657349 / seconds
Query Executed:select id FROM `va` where city='Sandston' && SIC_code='8661'DB:business_master_new
loadtime:2.6158480644226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:2.6159100532532 / seconds
Query Executed:select id FROM `va` where city='Sandy Hook' && SIC_code='8661'DB:business_master_new
loadtime:2.6163971424103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Level' limit 1
loadtime:2.6164510250092 / seconds
Query Executed:select id FROM `va` where city='Sandy Level' && SIC_code='8661'DB:business_master_new
loadtime:2.6169321537018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Point' limit 1
loadtime:2.6169860363007 / seconds
Query Executed:select id FROM `va` where city='Sandy Point' && SIC_code='8661'DB:business_master_new
loadtime:2.6173329353333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:2.6173779964447 / seconds
Query Executed:select id FROM `va` where city='Sanford' && SIC_code='8661'DB:business_master_new
loadtime:2.6178071498871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxe' limit 1
loadtime:2.6178641319275 / seconds
Query Executed:select id FROM `va` where city='Saxe' && SIC_code='8661'DB:business_master_new
loadtime:2.6183650493622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxis' limit 1
loadtime:2.6184079647064 / seconds
Query Executed:select id FROM `va` where city='Saxis' && SIC_code='8661'DB:business_master_new
loadtime:2.6188650131226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schley' limit 1
loadtime:2.61891913414 / seconds
Query Executed:select id FROM `va` where city='Schley' && SIC_code='8661'DB:business_master_new
loadtime:2.6192610263824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schuyler' limit 1
loadtime:2.6192979812622 / seconds
Query Executed:select id FROM `va` where city='Schuyler' && SIC_code='8661'DB:business_master_new
loadtime:2.6199460029602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:2.6200110912323 / seconds
Query Executed:select id FROM `va` where city='Scottsburg' && SIC_code='8661'DB:business_master_new
loadtime:2.6211459636688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsville' limit 1
loadtime:2.62122797966 / seconds
Query Executed:select id FROM `va` where city='Scottsville' && SIC_code='8661'DB:business_master_new
loadtime:2.6243100166321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaford' limit 1
loadtime:2.624382019043 / seconds
Query Executed:select id FROM `va` where city='Seaford' && SIC_code='8661'DB:business_master_new
loadtime:2.625764131546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealston' limit 1
loadtime:2.6258280277252 / seconds
Query Executed:select id FROM `va` where city='Sealston' && SIC_code='8661'DB:business_master_new
loadtime:2.6262440681458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:2.6262891292572 / seconds
Query Executed:select id FROM `va` where city='Seaview' && SIC_code='8661'DB:business_master_new
loadtime:2.62655210495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedley' limit 1
loadtime:2.6265830993652 / seconds
Query Executed:select id FROM `va` where city='Sedley' && SIC_code='8661'DB:business_master_new
loadtime:2.6273159980774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:2.6273739337921 / seconds
Query Executed:select id FROM `va` where city='Selma' && SIC_code='8661'DB:business_master_new
loadtime:2.627809047699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Corners' limit 1
loadtime:2.6278660297394 / seconds
Query Executed:select id FROM `va` where city='Seven Corners' && SIC_code='8661'DB:business_master_new
loadtime:2.6282439231873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Mile Ford' limit 1
loadtime:2.6282799243927 / seconds
Query Executed:select id FROM `va` where city='Seven Mile Ford' && SIC_code='8661'DB:business_master_new
loadtime:2.628545999527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:2.6285870075226 / seconds
Query Executed:select id FROM `va` where city='Severn' && SIC_code='8661'DB:business_master_new
loadtime:2.6289410591125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shacklefords' limit 1
loadtime:2.6289849281311 / seconds
Query Executed:select id FROM `va` where city='Shacklefords' && SIC_code='8661'DB:business_master_new
loadtime:2.6297650337219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharps' limit 1
loadtime:2.6298260688782 / seconds
Query Executed:select id FROM `va` where city='Sharps' && SIC_code='8661'DB:business_master_new
loadtime:2.6302509307861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawsville' limit 1
loadtime:2.630294084549 / seconds
Query Executed:select id FROM `va` where city='Shawsville' && SIC_code='8661'DB:business_master_new
loadtime:2.6314699649811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:2.631539106369 / seconds
Query Executed:select id FROM `va` where city='Shelby' && SIC_code='8661'DB:business_master_new
loadtime:2.6318030357361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:2.6318581104279 / seconds
Query Executed:select id FROM `va` where city='Shenandoah' && SIC_code='8661'DB:business_master_new
loadtime:2.6340219974518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Cvrns' limit 1
loadtime:2.6340939998627 / seconds
Query Executed:select id FROM `va` where city='Shenandoah Cvrns' && SIC_code='8661'DB:business_master_new
loadtime:2.6343791484833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherando' limit 1
loadtime:2.6344151496887 / seconds
Query Executed:select id FROM `va` where city='Sherando' && SIC_code='8661'DB:business_master_new
loadtime:2.6347739696503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:2.6348359584808 / seconds
Query Executed:select id FROM `va` where city='Shiloh' && SIC_code='8661'DB:business_master_new
loadtime:2.635185956955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shipman' limit 1
loadtime:2.6352410316467 / seconds
Query Executed:select id FROM `va` where city='Shipman' && SIC_code='8661'DB:business_master_new
loadtime:2.635941028595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shortt Gap' limit 1
loadtime:2.6359860897064 / seconds
Query Executed:select id FROM `va` where city='Shortt Gap' && SIC_code='8661'DB:business_master_new
loadtime:2.6362500190735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Singers Glen' limit 1
loadtime:2.6363010406494 / seconds
Query Executed:select id FROM `va` where city='Singers Glen' && SIC_code='8661'DB:business_master_new
loadtime:2.6368429660797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skippers' limit 1
loadtime:2.6368911266327 / seconds
Query Executed:select id FROM `va` where city='Skippers' && SIC_code='8661'DB:business_master_new
loadtime:2.6375980377197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipwith' limit 1
loadtime:2.6376600265503 / seconds
Query Executed:select id FROM `va` where city='Skipwith' && SIC_code='8661'DB:business_master_new
loadtime:2.6382701396942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:2.6383299827576 / seconds
Query Executed:select id FROM `va` where city='Smithfield' && SIC_code='8661'DB:business_master_new
loadtime:2.6439940929413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snell' limit 1
loadtime:2.6440651416779 / seconds
Query Executed:select id FROM `va` where city='Snell' && SIC_code='8661'DB:business_master_new
loadtime:2.644364118576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.6444139480591 / seconds
Query Executed:select id FROM `va` where city='Somerset' && SIC_code='8661'DB:business_master_new
loadtime:2.6449410915375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:2.6449971199036 / seconds
Query Executed:select id FROM `va` where city='Somerville' && SIC_code='8661'DB:business_master_new
loadtime:2.6452760696411 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:2.6453189849854 / seconds
Query Executed:select id FROM `va` where city='South Boston' && SIC_code='8661'DB:business_master_new
loadtime:2.6515970230103 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hill' limit 1
loadtime:2.6517131328583 / seconds
Query Executed:select id FROM `va` where city='South Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.6574540138245 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Riding' limit 1
loadtime:2.6575319766998 / seconds
Query Executed:select id FROM `va` where city='South Riding' && SIC_code='8661'DB:business_master_new
loadtime:2.6579580307007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:2.6580150127411 / seconds
Query Executed:select id FROM `va` where city='Sparta' && SIC_code='8661'DB:business_master_new
loadtime:2.6583280563354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speedwell' limit 1
loadtime:2.6583759784698 / seconds
Query Executed:select id FROM `va` where city='Speedwell' && SIC_code='8661'DB:business_master_new
loadtime:2.658900976181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.6589601039886 / seconds
Query Executed:select id FROM `va` where city='Spencer' && SIC_code='8661'DB:business_master_new
loadtime:2.6599690914154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperryville' limit 1
loadtime:2.6600339412689 / seconds
Query Executed:select id FROM `va` where city='Sperryville' && SIC_code='8661'DB:business_master_new
loadtime:2.6612751483917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotsylvania' limit 1
loadtime:2.6613249778748 / seconds
Query Executed:select id FROM `va` where city='Spotsylvania' && SIC_code='8661'DB:business_master_new
loadtime:2.6669981479645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spout Spring' limit 1
loadtime:2.6670789718628 / seconds
Query Executed:select id FROM `va` where city='Spout Spring' && SIC_code='8661'DB:business_master_new
loadtime:2.6678800582886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Grove' limit 1
loadtime:2.6679451465607 / seconds
Query Executed:select id FROM `va` where city='Spring Grove' && SIC_code='8661'DB:business_master_new
loadtime:2.668662071228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.6687209606171 / seconds
Query Executed:select id FROM `va` where city='Springfield' && SIC_code='8661'DB:business_master_new
loadtime:2.6769490242004 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:2.6770670413971 / seconds
Query Executed:select id FROM `va` where city='St Charles' && SIC_code='8661'DB:business_master_new
loadtime:2.6774151325226 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:2.6774671077728 / seconds
Query Executed:select id FROM `va` where city='St Paul' && SIC_code='8661'DB:business_master_new
loadtime:2.6778440475464 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens Chr' limit 1
loadtime:2.6778869628906 / seconds
Query Executed:select id FROM `va` where city='St Stephens Chr' && SIC_code='8661'DB:business_master_new
loadtime:2.6782479286194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:2.6782901287079 / seconds
Query Executed:select id FROM `va` where city='Stafford' && SIC_code='8661'DB:business_master_new
loadtime:2.6848161220551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordsville' limit 1
loadtime:2.6849119663239 / seconds
Query Executed:select id FROM `va` where city='Staffordsville' && SIC_code='8661'DB:business_master_new
loadtime:2.6852819919586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanardsville' limit 1
loadtime:2.6853370666504 / seconds
Query Executed:select id FROM `va` where city='Stanardsville' && SIC_code='8661'DB:business_master_new
loadtime:2.6880159378052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:2.688089132309 / seconds
Query Executed:select id FROM `va` where city='Stanley' && SIC_code='8661'DB:business_master_new
loadtime:2.690376996994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanleytown' limit 1
loadtime:2.6904411315918 / seconds
Query Executed:select id FROM `va` where city='Stanleytown' && SIC_code='8661'DB:business_master_new
loadtime:2.6911499500275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Tannery' limit 1
loadtime:2.6912350654602 / seconds
Query Executed:select id FROM `va` where city='Star Tannery' && SIC_code='8661'DB:business_master_new
loadtime:2.6917231082916 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Farm' limit 1
loadtime:2.6917679309845 / seconds
Query Executed:select id FROM `va` where city='State Farm' && SIC_code='8661'DB:business_master_new
loadtime:2.6921150684357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staunton' limit 1
loadtime:2.6921539306641 / seconds
Query Executed:select id FROM `va` where city='Staunton' && SIC_code='8661'DB:business_master_new
loadtime:2.6990809440613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steeles Tavern' limit 1
loadtime:2.6992070674896 / seconds
Query Executed:select id FROM `va` where city='Steeles Tavern' && SIC_code='8661'DB:business_master_new
loadtime:2.6996800899506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephens City' limit 1
loadtime:2.6997470855713 / seconds
Query Executed:select id FROM `va` where city='Stephens City' && SIC_code='8661'DB:business_master_new
loadtime:2.7042810916901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:2.7043459415436 / seconds
Query Executed:select id FROM `va` where city='Stephenson' && SIC_code='8661'DB:business_master_new
loadtime:2.7052590847015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.7053229808807 / seconds
Query Executed:select id FROM `va` where city='Sterling' && SIC_code='8661'DB:business_master_new
loadtime:2.7130210399628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensburg' limit 1
loadtime:2.7131109237671 / seconds
Query Executed:select id FROM `va` where city='Stevensburg' && SIC_code='8661'DB:business_master_new
loadtime:2.7136130332947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:2.7136759757996 / seconds
Query Executed:select id FROM `va` where city='Stevensville' && SIC_code='8661'DB:business_master_new
loadtime:2.7140591144562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Ridge' limit 1
loadtime:2.7141139507294 / seconds
Query Executed:select id FROM `va` where city='Stone Ridge' && SIC_code='8661'DB:business_master_new
loadtime:2.714378118515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonega' limit 1
loadtime:2.7144110202789 / seconds
Query Executed:select id FROM `va` where city='Stonega' && SIC_code='8661'DB:business_master_new
loadtime:2.7146661281586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Creek' limit 1
loadtime:2.7147059440613 / seconds
Query Executed:select id FROM `va` where city='Stony Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.7161130905151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:2.7161920070648 / seconds
Query Executed:select id FROM `va` where city='Strasburg' && SIC_code='8661'DB:business_master_new
loadtime:2.7203271389008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:2.7204070091248 / seconds
Query Executed:select id FROM `va` where city='Stratford' && SIC_code='8661'DB:business_master_new
loadtime:2.7207660675049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:2.720813035965 / seconds
Query Executed:select id FROM `va` where city='Stuart' && SIC_code='8661'DB:business_master_new
loadtime:2.7254500389099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuarts Draft' limit 1
loadtime:2.7255330085754 / seconds
Query Executed:select id FROM `va` where city='Stuarts Draft' && SIC_code='8661'DB:business_master_new
loadtime:2.7293519973755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:2.7294120788574 / seconds
Query Executed:select id FROM `va` where city='Studley' && SIC_code='8661'DB:business_master_new
loadtime:2.729896068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffolk' limit 1
loadtime:2.7299611568451 / seconds
Query Executed:select id FROM `va` where city='Suffolk' && SIC_code='8661'DB:business_master_new
loadtime:2.7381579875946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:2.7383379936218 / seconds
Query Executed:select id FROM `va` where city='Sugar Grove' && SIC_code='8661'DB:business_master_new
loadtime:2.7390489578247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerduck' limit 1
loadtime:2.7391049861908 / seconds
Query Executed:select id FROM `va` where city='Sumerduck' && SIC_code='8661'DB:business_master_new
loadtime:2.7398700714111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:2.7399301528931 / seconds
Query Executed:select id FROM `va` where city='Supply' && SIC_code='8661'DB:business_master_new
loadtime:2.7402229309082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:2.7402639389038 / seconds
Query Executed:select id FROM `va` where city='Surry' && SIC_code='8661'DB:business_master_new
loadtime:2.7421109676361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susan' limit 1
loadtime:2.7421741485596 / seconds
Query Executed:select id FROM `va` where city='Susan' && SIC_code='8661'DB:business_master_new
loadtime:2.7425560951233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:2.7426209449768 / seconds
Query Executed:select id FROM `va` where city='Sussex' && SIC_code='8661'DB:business_master_new
loadtime:2.7430989742279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:2.7431559562683 / seconds
Query Executed:select id FROM `va` where city='Sutherland' && SIC_code='8661'DB:business_master_new
loadtime:2.7441749572754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:2.7442469596863 / seconds
Query Executed:select id FROM `va` where city='Sutherlin' && SIC_code='8661'DB:business_master_new
loadtime:2.7449719905853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Briar' limit 1
loadtime:2.7450280189514 / seconds
Query Executed:select id FROM `va` where city='Sweet Briar' && SIC_code='8661'DB:business_master_new
loadtime:2.7454259395599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swoope' limit 1
loadtime:2.7454690933228 / seconds
Query Executed:select id FROM `va` where city='Swoope' && SIC_code='8661'DB:business_master_new
loadtime:2.7462301254272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swords Creek' limit 1
loadtime:2.7462861537933 / seconds
Query Executed:select id FROM `va` where city='Swords Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.7469840049744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syria' limit 1
loadtime:2.7470519542694 / seconds
Query Executed:select id FROM `va` where city='Syria' && SIC_code='8661'DB:business_master_new
loadtime:2.7474191188812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syringa' limit 1
loadtime:2.7474539279938 / seconds
Query Executed:select id FROM `va` where city='Syringa' && SIC_code='8661'DB:business_master_new
loadtime:2.7476980686188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabb' limit 1
loadtime:2.7477390766144 / seconds
Query Executed:select id FROM `va` where city='Tabb' && SIC_code='8661'DB:business_master_new
loadtime:2.7481260299683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangier' limit 1
loadtime:2.7481610774994 / seconds
Query Executed:select id FROM `va` where city='Tangier' && SIC_code='8661'DB:business_master_new
loadtime:2.7487599849701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tannersville' limit 1
loadtime:2.7488179206848 / seconds
Query Executed:select id FROM `va` where city='Tannersville' && SIC_code='8661'DB:business_master_new
loadtime:2.7491180896759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tappahannock' limit 1
loadtime:2.749153137207 / seconds
Query Executed:select id FROM `va` where city='Tappahannock' && SIC_code='8661'DB:business_master_new
loadtime:2.7544951438904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tasley' limit 1
loadtime:2.7545680999756 / seconds
Query Executed:select id FROM `va` where city='Tasley' && SIC_code='8661'DB:business_master_new
loadtime:2.7552161216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tazewell' limit 1
loadtime:2.7552680969238 / seconds
Query Executed:select id FROM `va` where city='Tazewell' && SIC_code='8661'DB:business_master_new
loadtime:2.7606070041656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperanceville' limit 1
loadtime:2.7606689929962 / seconds
Query Executed:select id FROM `va` where city='Temperanceville' && SIC_code='8661'DB:business_master_new
loadtime:2.7613599300385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:2.7614290714264 / seconds
Query Executed:select id FROM `va` where city='Thaxton' && SIC_code='8661'DB:business_master_new
loadtime:2.7622649669647 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Plains' limit 1
loadtime:2.7623131275177 / seconds
Query Executed:select id FROM `va` where city='The Plains' && SIC_code='8661'DB:business_master_new
loadtime:2.7640130519867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:2.7640740871429 / seconds
Query Executed:select id FROM `va` where city='Thornburg' && SIC_code='8661'DB:business_master_new
loadtime:2.7648019790649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberville' limit 1
loadtime:2.7648451328278 / seconds
Query Executed:select id FROM `va` where city='Timberville' && SIC_code='8661'DB:business_master_new
loadtime:2.7668190002441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toano' limit 1
loadtime:2.7668859958649 / seconds
Query Executed:select id FROM `va` where city='Toano' && SIC_code='8661'DB:business_master_new
loadtime:2.7694599628448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms Brook' limit 1
loadtime:2.7695331573486 / seconds
Query Executed:select id FROM `va` where city='Toms Brook' && SIC_code='8661'DB:business_master_new
loadtime:2.7704939842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topping' limit 1
loadtime:2.770544052124 / seconds
Query Executed:select id FROM `va` where city='Topping' && SIC_code='8661'DB:business_master_new
loadtime:2.771476984024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.771546125412 / seconds
Query Executed:select id FROM `va` where city='Townsend' && SIC_code='8661'DB:business_master_new
loadtime:2.7719249725342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trammel' limit 1
loadtime:2.7719810009003 / seconds
Query Executed:select id FROM `va` where city='Trammel' && SIC_code='8661'DB:business_master_new
loadtime:2.7722511291504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevilians' limit 1
loadtime:2.7722840309143 / seconds
Query Executed:select id FROM `va` where city='Trevilians' && SIC_code='8661'DB:business_master_new
loadtime:2.7725360393524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triangle' limit 1
loadtime:2.7725851535797 / seconds
Query Executed:select id FROM `va` where city='Triangle' && SIC_code='8661'DB:business_master_new
loadtime:2.7752089500427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triplet' limit 1
loadtime:2.775267124176 / seconds
Query Executed:select id FROM `va` where city='Triplet' && SIC_code='8661'DB:business_master_new
loadtime:2.7755279541016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Dale' limit 1
loadtime:2.7755711078644 / seconds
Query Executed:select id FROM `va` where city='Trout Dale' && SIC_code='8661'DB:business_master_new
loadtime:2.7758181095123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:2.7758550643921 / seconds
Query Executed:select id FROM `va` where city='Troutdale' && SIC_code='8661'DB:business_master_new
loadtime:2.7764661312103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutville' limit 1
loadtime:2.7765130996704 / seconds
Query Executed:select id FROM `va` where city='Troutville' && SIC_code='8661'DB:business_master_new
loadtime:2.7798719406128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:2.7800199985504 / seconds
Query Executed:select id FROM `va` where city='Troy' && SIC_code='8661'DB:business_master_new
loadtime:2.7817010879517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:2.7817659378052 / seconds
Query Executed:select id FROM `va` where city='Turbeville' && SIC_code='8661'DB:business_master_new
loadtime:2.7820420265198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:2.7820811271667 / seconds
Query Executed:select id FROM `va` where city='Tyro' && SIC_code='8661'DB:business_master_new
loadtime:2.7824709415436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Hall' limit 1
loadtime:2.7825410366058 / seconds
Query Executed:select id FROM `va` where city='Union Hall' && SIC_code='8661'DB:business_master_new
loadtime:2.783360004425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:2.7834079265594 / seconds
Query Executed:select id FROM `va` where city='Unionville' && SIC_code='8661'DB:business_master_new
loadtime:2.7843811511993 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Of Richmond' limit 1
loadtime:2.7844350337982 / seconds
Query Executed:select id FROM `va` where city='University Of Richmond' && SIC_code='8661'DB:business_master_new
loadtime:2.7846961021423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperville' limit 1
loadtime:2.7848041057587 / seconds
Query Executed:select id FROM `va` where city='Upperville' && SIC_code='8661'DB:business_master_new
loadtime:2.78595495224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbanna' limit 1
loadtime:2.7860081195831 / seconds
Query Executed:select id FROM `va` where city='Urbanna' && SIC_code='8661'DB:business_master_new
loadtime:2.7879190444946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentines' limit 1
loadtime:2.7879841327667 / seconds
Query Executed:select id FROM `va` where city='Valentines' && SIC_code='8661'DB:business_master_new
loadtime:2.7884130477905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vansant' limit 1
loadtime:2.7884590625763 / seconds
Query Executed:select id FROM `va` where city='Vansant' && SIC_code='8661'DB:business_master_new
loadtime:2.7900919914246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Hill' limit 1
loadtime:2.7901549339294 / seconds
Query Executed:select id FROM `va` where city='Vernon Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.7906351089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:2.790687084198 / seconds
Query Executed:select id FROM `va` where city='Verona' && SIC_code='8661'DB:business_master_new
loadtime:2.7937331199646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesta' limit 1
loadtime:2.7937989234924 / seconds
Query Executed:select id FROM `va` where city='Vesta' && SIC_code='8661'DB:business_master_new
loadtime:2.794144153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesuvius' limit 1
loadtime:2.7941780090332 / seconds
Query Executed:select id FROM `va` where city='Vesuvius' && SIC_code='8661'DB:business_master_new
loadtime:2.7946479320526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:2.7947051525116 / seconds
Query Executed:select id FROM `va` where city='Victoria' && SIC_code='8661'DB:business_master_new
loadtime:2.7965090274811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:2.7965750694275 / seconds
Query Executed:select id FROM `va` where city='Vienna' && SIC_code='8661'DB:business_master_new
loadtime:2.8045449256897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viewtown' limit 1
loadtime:2.8046579360962 / seconds
Query Executed:select id FROM `va` where city='Viewtown' && SIC_code='8661'DB:business_master_new
loadtime:2.8049330711365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village' limit 1
loadtime:2.8049709796906 / seconds
Query Executed:select id FROM `va` where city='Village' && SIC_code='8661'DB:business_master_new
loadtime:2.80531001091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villamont' limit 1
loadtime:2.8053550720215 / seconds
Query Executed:select id FROM `va` where city='Villamont' && SIC_code='8661'DB:business_master_new
loadtime:2.8056230545044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vint Hill Farms' limit 1
loadtime:2.8056540489197 / seconds
Query Executed:select id FROM `va` where city='Vint Hill Farms' && SIC_code='8661'DB:business_master_new
loadtime:2.8058929443359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:2.8059260845184 / seconds
Query Executed:select id FROM `va` where city='Vinton' && SIC_code='8661'DB:business_master_new
loadtime:2.8115670681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgilina' limit 1
loadtime:2.811653137207 / seconds
Query Executed:select id FROM `va` where city='Virgilina' && SIC_code='8661'DB:business_master_new
loadtime:2.8125691413879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virginia Beach' limit 1
loadtime:2.8126289844513 / seconds
Query Executed:select id FROM `va` where city='Virginia Beach' && SIC_code='8661'DB:business_master_new
loadtime:2.8310749530792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wachapreague' limit 1
loadtime:2.8315930366516 / seconds
Query Executed:select id FROM `va` where city='Wachapreague' && SIC_code='8661'DB:business_master_new
loadtime:2.8322660923004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake' limit 1
loadtime:2.8323340415955 / seconds
Query Executed:select id FROM `va` where city='Wake' && SIC_code='8661'DB:business_master_new
loadtime:2.8327810764313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.8328809738159 / seconds
Query Executed:select id FROM `va` where city='Wakefield' && SIC_code='8661'DB:business_master_new
loadtime:2.8343291282654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerton' limit 1
loadtime:2.8343939781189 / seconds
Query Executed:select id FROM `va` where city='Walkerton' && SIC_code='8661'DB:business_master_new
loadtime:2.8349640369415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallops Island' limit 1
loadtime:2.8350660800934 / seconds
Query Executed:select id FROM `va` where city='Wallops Island' && SIC_code='8661'DB:business_master_new
loadtime:2.8357419967651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walters' limit 1
loadtime:2.8357930183411 / seconds
Query Executed:select id FROM `va` where city='Walters' && SIC_code='8661'DB:business_master_new
loadtime:2.8360459804535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardtown' limit 1
loadtime:2.8360779285431 / seconds
Query Executed:select id FROM `va` where city='Wardtown' && SIC_code='8661'DB:business_master_new
loadtime:2.8363180160522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Neck' limit 1
loadtime:2.8363599777222 / seconds
Query Executed:select id FROM `va` where city='Ware Neck' && SIC_code='8661'DB:business_master_new
loadtime:2.8367419242859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warfield' limit 1
loadtime:2.8368830680847 / seconds
Query Executed:select id FROM `va` where city='Warfield' && SIC_code='8661'DB:business_master_new
loadtime:2.8373730182648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:2.8374230861664 / seconds
Query Executed:select id FROM `va` where city='Warm Springs' && SIC_code='8661'DB:business_master_new
loadtime:2.8383340835571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:2.8383951187134 / seconds
Query Executed:select id FROM `va` where city='Warner' && SIC_code='8661'DB:business_master_new
loadtime:2.83864402771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:2.8386790752411 / seconds
Query Executed:select id FROM `va` where city='Warrenton' && SIC_code='8661'DB:business_master_new
loadtime:2.8449261188507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:2.8450109958649 / seconds
Query Executed:select id FROM `va` where city='Warsaw' && SIC_code='8661'DB:business_master_new
loadtime:2.8493270874023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.8494040966034 / seconds
Query Executed:select id FROM `va` where city='Washington' && SIC_code='8661'DB:business_master_new
loadtime:2.8513090610504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water View' limit 1
loadtime:2.8513741493225 / seconds
Query Executed:select id FROM `va` where city='Water View' && SIC_code='8661'DB:business_master_new
loadtime:2.8517351150513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:2.8518650531769 / seconds
Query Executed:select id FROM `va` where city='Waterford' && SIC_code='8661'DB:business_master_new
loadtime:2.8529510498047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:2.8530039787292 / seconds
Query Executed:select id FROM `va` where city='Wattsville' && SIC_code='8661'DB:business_master_new
loadtime:2.8533170223236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:2.8533570766449 / seconds
Query Executed:select id FROM `va` where city='Waverly' && SIC_code='8661'DB:business_master_new
loadtime:2.8553199768066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:2.8553950786591 / seconds
Query Executed:select id FROM `va` where city='Waynesboro' && SIC_code='8661'DB:business_master_new
loadtime:2.8618259429932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weber City' limit 1
loadtime:2.8621089458466 / seconds
Query Executed:select id FROM `va` where city='Weber City' && SIC_code='8661'DB:business_master_new
loadtime:2.8638250827789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weems' limit 1
loadtime:2.863981962204 / seconds
Query Executed:select id FROM `va` where city='Weems' && SIC_code='8661'DB:business_master_new
loadtime:2.8649499416351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirwood' limit 1
loadtime:2.8650920391083 / seconds
Query Executed:select id FROM `va` where city='Weirwood' && SIC_code='8661'DB:business_master_new
loadtime:2.8653969764709 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Augusta' limit 1
loadtime:2.8654270172119 / seconds
Query Executed:select id FROM `va` where city='West Augusta' && SIC_code='8661'DB:business_master_new
loadtime:2.8657519817352 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mclean' limit 1
loadtime:2.865816116333 / seconds
Query Executed:select id FROM `va` where city='West Mclean' && SIC_code='8661'DB:business_master_new
loadtime:2.8662979602814 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:2.8663399219513 / seconds
Query Executed:select id FROM `va` where city='West Point' && SIC_code='8661'DB:business_master_new
loadtime:2.8695170879364 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.8696010112762 / seconds
Query Executed:select id FROM `va` where city='West Springfield' && SIC_code='8661'DB:business_master_new
loadtime:2.8698470592499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:2.8699309825897 / seconds
Query Executed:select id FROM `va` where city='Westmoreland' && SIC_code='8661'DB:business_master_new
loadtime:2.8702549934387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyers Cave' limit 1
loadtime:2.8702931404114 / seconds
Query Executed:select id FROM `va` where city='Weyers Cave' && SIC_code='8661'DB:business_master_new
loadtime:2.8719639778137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitacre' limit 1
loadtime:2.8720109462738 / seconds
Query Executed:select id FROM `va` where city='Whitacre' && SIC_code='8661'DB:business_master_new
loadtime:2.8722641468048 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Hall' limit 1
loadtime:2.8723089694977 / seconds
Query Executed:select id FROM `va` where city='White Hall' && SIC_code='8661'DB:business_master_new
loadtime:2.872661113739 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Marsh' limit 1
loadtime:2.8727860450745 / seconds
Query Executed:select id FROM `va` where city='White Marsh' && SIC_code='8661'DB:business_master_new
loadtime:2.8737070560455 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:2.8738040924072 / seconds
Query Executed:select id FROM `va` where city='White Plains' && SIC_code='8661'DB:business_master_new
loadtime:2.8742129802704 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Post' limit 1
loadtime:2.8742470741272 / seconds
Query Executed:select id FROM `va` where city='White Post' && SIC_code='8661'DB:business_master_new
loadtime:2.8752279281616 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:2.8752889633179 / seconds
Query Executed:select id FROM `va` where city='White Stone' && SIC_code='8661'DB:business_master_new
loadtime:2.8773181438446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitetop' limit 1
loadtime:2.8773679733276 / seconds
Query Executed:select id FROM `va` where city='Whitetop' && SIC_code='8661'DB:business_master_new
loadtime:2.8778569698334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:2.8780241012573 / seconds
Query Executed:select id FROM `va` where city='Whitewood' && SIC_code='8661'DB:business_master_new
loadtime:2.8785140514374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico' limit 1
loadtime:2.8785650730133 / seconds
Query Executed:select id FROM `va` where city='Wicomico' && SIC_code='8661'DB:business_master_new
loadtime:2.878986120224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico Church' limit 1
loadtime:2.8790280818939 / seconds
Query Executed:select id FROM `va` where city='Wicomico Church' && SIC_code='8661'DB:business_master_new
loadtime:2.87952709198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.8795850276947 / seconds
Query Executed:select id FROM `va` where city='Williamsburg' && SIC_code='8661'DB:business_master_new
loadtime:2.8872690200806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:2.8873801231384 / seconds
Query Executed:select id FROM `va` where city='Williamsville' && SIC_code='8661'DB:business_master_new
loadtime:2.8878350257874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:2.887974023819 / seconds
Query Executed:select id FROM `va` where city='Willis' && SIC_code='8661'DB:business_master_new
loadtime:2.8890290260315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis Wharf' limit 1
loadtime:2.8890910148621 / seconds
Query Executed:select id FROM `va` where city='Willis Wharf' && SIC_code='8661'DB:business_master_new
loadtime:2.889475107193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons' limit 1
loadtime:2.8895211219788 / seconds
Query Executed:select id FROM `va` where city='Wilsons' && SIC_code='8661'DB:business_master_new
loadtime:2.8899300098419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.8900671005249 / seconds
Query Executed:select id FROM `va` where city='Winchester' && SIC_code='8661'DB:business_master_new
loadtime:2.8980669975281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.8983030319214 / seconds
Query Executed:select id FROM `va` where city='Windsor' && SIC_code='8661'DB:business_master_new
loadtime:2.9008059501648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingina' limit 1
loadtime:2.9008779525757 / seconds
Query Executed:select id FROM `va` where city='Wingina' && SIC_code='8661'DB:business_master_new
loadtime:2.9012091159821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wintergreen' limit 1
loadtime:2.9012501239777 / seconds
Query Executed:select id FROM `va` where city='Wintergreen' && SIC_code='8661'DB:business_master_new
loadtime:2.9015080928802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wirtz' limit 1
loadtime:2.9015591144562 / seconds
Query Executed:select id FROM `va` where city='Wirtz' && SIC_code='8661'DB:business_master_new
loadtime:2.9034569263458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:2.9035060405731 / seconds
Query Executed:select id FROM `va` where city='Wise' && SIC_code='8661'DB:business_master_new
loadtime:2.9088139533997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withams' limit 1
loadtime:2.9088900089264 / seconds
Query Executed:select id FROM `va` where city='Withams' && SIC_code='8661'DB:business_master_new
loadtime:2.9091739654541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolford' limit 1
loadtime:2.9092350006104 / seconds
Query Executed:select id FROM `va` where city='Wolford' && SIC_code='8661'DB:business_master_new
loadtime:2.9095590114594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolftown' limit 1
loadtime:2.9096040725708 / seconds
Query Executed:select id FROM `va` where city='Wolftown' && SIC_code='8661'DB:business_master_new
loadtime:2.9100029468536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodberry Forest' limit 1
loadtime:2.910059928894 / seconds
Query Executed:select id FROM `va` where city='Woodberry Forest' && SIC_code='8661'DB:business_master_new
loadtime:2.9103400707245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:2.910383939743 / seconds
Query Executed:select id FROM `va` where city='Woodbridge' && SIC_code='8661'DB:business_master_new
loadtime:2.9194560050964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:2.9195971488953 / seconds
Query Executed:select id FROM `va` where city='Woodford' && SIC_code='8661'DB:business_master_new
loadtime:2.9210081100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodlawn' limit 1
loadtime:2.9210770130157 / seconds
Query Executed:select id FROM `va` where city='Woodlawn' && SIC_code='8661'DB:business_master_new
loadtime:2.9225170612335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Rds' limit 1
loadtime:2.9225809574127 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Rds' && SIC_code='8661'DB:business_master_new
loadtime:2.922816991806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Roads' limit 1
loadtime:2.9229090213776 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Roads' && SIC_code='8661'DB:business_master_new
loadtime:2.9232680797577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:2.9233090877533 / seconds
Query Executed:select id FROM `va` where city='Woodstock' && SIC_code='8661'DB:business_master_new
loadtime:2.9287021160126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.9287950992584 / seconds
Query Executed:select id FROM `va` where city='Woodville' && SIC_code='8661'DB:business_master_new
loadtime:2.9292619228363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolwine' limit 1
loadtime:2.9293029308319 / seconds
Query Executed:select id FROM `va` where city='Woolwine' && SIC_code='8661'DB:business_master_new
loadtime:2.9299221038818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wylliesburg' limit 1
loadtime:2.9299800395966 / seconds
Query Executed:select id FROM `va` where city='Wylliesburg' && SIC_code='8661'DB:business_master_new
loadtime:2.9304850101471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wytheville' limit 1
loadtime:2.930536031723 / seconds
Query Executed:select id FROM `va` where city='Wytheville' && SIC_code='8661'DB:business_master_new
loadtime:2.9363210201263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:2.9364049434662 / seconds
Query Executed:select id FROM `va` where city='Yale' && SIC_code='8661'DB:business_master_new
loadtime:2.936872959137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:2.9369299411774 / seconds
Query Executed:select id FROM `va` where city='Yorktown' && SIC_code='8661'DB:business_master_new
loadtime:2.9433960914612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zacata' limit 1
loadtime:2.9434931278229 / seconds
Query Executed:select id FROM `va` where city='Zacata' && SIC_code='8661'DB:business_master_new
loadtime:2.9437670707703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zanoni' limit 1
loadtime:2.9438860416412 / seconds
Query Executed:select id FROM `va` where city='Zanoni' && SIC_code='8661'DB:business_master_new
loadtime:2.9443180561066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:2.9443559646606 / seconds
Query Executed:select id FROM `va` where city='Zuni' && SIC_code='8661'DB:business_master_new
loadtime:2.9451401233673 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.9452531337738 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.9456069469452 / seconds
Operation template executed (chunk cache operation)
loadtime:2.9458010196686 / seconds
template override:Default
loadtime:2.9458730220795 / 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:2.9467570781708 / seconds
Template Constructed, Array Rows:49
loadtime:2.9474000930786 / seconds
TOTAL EXECUTION TIME: 2.94686
loadtime:2.9478030204773 / 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] => religious-organizations [stateURLid] => 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:2.9478080272675
TOTAL KEY ARRAYS: 69