Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00012993812561035 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00089097023010254 / seconds
host not found setting manual db connection
loadtime:0.0017199516296387 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0021979808807373 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0025949478149414 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0026528835296631 / seconds
zipcode:
loadtime:0.0026710033416748 / seconds
Query Executed:select * from search_referrer where page_hash='6cecb4c7b239e2f48ef3ccd526a6ab37' limit 10 DB:ezrox_toadli
loadtime:0.0029969215393066 / seconds
Operation header executed (non global)
loadtime:0.0030198097229004 / seconds
Operation leaderboard executed (non global)
loadtime:0.0030598640441895 / seconds
Operation square executed (non global)
loadtime:0.00307297706604 / seconds
Operation square_bottom executed (non global)
loadtime:0.0030858516693115 / seconds
Operation smallsquare executed (non global)
loadtime:0.0030968189239502 / seconds
Operation headeradright executed (non global)
loadtime:0.003108024597168 / seconds
Operation google_analytics executed (non global)
loadtime:0.0031189918518066 / seconds
Operation topstories executed (non global)
loadtime:0.0031299591064453 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0031609535217285 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0031888484954834 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0036609172821045 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0038039684295654 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0039169788360596 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0040619373321533 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0041589736938477 / seconds
Template key: archive_menu pushed
loadtime:0.0041708946228027 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0041868686676025 / seconds
Template key: get_gravatar pushed
loadtime:0.0041968822479248 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0042068958282471 / seconds
*10)-10)+1 | start:0
loadtime:0.0042619705200195 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.0043590068817139 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.0043950080871582 / seconds
DB connected to localhost business_master_new
loadtime:0.0046968460083008 / seconds
Query Executed:select * from `va_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.039834976196289 / seconds
Query stored in cache : _QUERY_www.toadli.comd9f9724816d68b4bebf2564a4d369676
loadtime:0.041700839996338 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.041757822036743 / seconds
Query Executed:select sum(totalcount) as totalsum from `va_catmap` where sic='6021'DB:business_master_new
loadtime:0.046774864196777 / seconds
Query stored in cache : _QUERY_www.toadli.com8e544715c6979c6289e0c39be2dcbf4a
loadtime:0.046800851821899 / seconds
942 / 11
loadtime:0.046839952468872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abingdon' limit 1
loadtime:0.04689884185791 / seconds
Query Executed:select id FROM `va` where city='Abingdon' && SIC_code='6021'DB:business_master_new
loadtime:0.052665948867798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accomac' limit 1
loadtime:0.052734851837158 / seconds
Query Executed:select id FROM `va` where city='Accomac' && SIC_code='6021'DB:business_master_new
loadtime:0.053920984268188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Achilles' limit 1
loadtime:0.053975820541382 / seconds
Query Executed:select id FROM `va` where city='Achilles' && SIC_code='6021'DB:business_master_new
loadtime:0.054356813430786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.054471015930176 / seconds
Query Executed:select id FROM `va` where city='Afton' && SIC_code='6021'DB:business_master_new
loadtime:0.056168794631958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alberta' limit 1
loadtime:0.056216955184937 / seconds
Query Executed:select id FROM `va` where city='Alberta' && SIC_code='6021'DB:business_master_new
loadtime:0.057053804397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aldie' limit 1
loadtime:0.057097911834717 / seconds
Query Executed:select id FROM `va` where city='Aldie' && SIC_code='6021'DB:business_master_new
loadtime:0.058280944824219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.058411836624146 / seconds
Query Executed:select id FROM `va` where city='Alexandria' && SIC_code='6021'DB:business_master_new
loadtime:0.082188844680786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleghany' limit 1
loadtime:0.082297801971436 / seconds
Query Executed:select id FROM `va` where city='Alleghany' && SIC_code='6021'DB:business_master_new
loadtime:0.082641839981079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allisonia' limit 1
loadtime:0.082690000534058 / seconds
Query Executed:select id FROM `va` where city='Allisonia' && SIC_code='6021'DB:business_master_new
loadtime:0.082998991012573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altavista' limit 1
loadtime:0.083046913146973 / seconds
Query Executed:select id FROM `va` where city='Altavista' && SIC_code='6021'DB:business_master_new
loadtime:0.084354877471924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.084405899047852 / seconds
Query Executed:select id FROM `va` where city='Alton' && SIC_code='6021'DB:business_master_new
loadtime:0.085335969924927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Ridge' limit 1
loadtime:0.085487842559814 / seconds
Query Executed:select id FROM `va` where city='Alum Ridge' && SIC_code='6021'DB:business_master_new
loadtime:0.085803985595703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court House' limit 1
loadtime:0.085834980010986 / seconds
Query Executed:select id FROM `va` where city='Amelia Court House' && SIC_code='6021'DB:business_master_new
loadtime:0.087251901626587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court Hse' limit 1
loadtime:0.087411880493164 / seconds
Query Executed:select id FROM `va` where city='Amelia Court Hse' && SIC_code='6021'DB:business_master_new
loadtime:0.087960958480835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.088011026382446 / seconds
Query Executed:select id FROM `va` where city='Amherst' && SIC_code='6021'DB:business_master_new
loadtime:0.089392900466919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amissville' limit 1
loadtime:0.089564800262451 / seconds
Query Executed:select id FROM `va` where city='Amissville' && SIC_code='6021'DB:business_master_new
loadtime:0.090698003768921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ammon' limit 1
loadtime:0.090753793716431 / seconds
Query Executed:select id FROM `va` where city='Ammon' && SIC_code='6021'DB:business_master_new
loadtime:0.091032028198242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amonate' limit 1
loadtime:0.091064929962158 / seconds
Query Executed:select id FROM `va` where city='Amonate' && SIC_code='6021'DB:business_master_new
loadtime:0.091369867324829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.091404914855957 / seconds
Query Executed:select id FROM `va` where city='Andover' && SIC_code='6021'DB:business_master_new
loadtime:0.091713905334473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.091748952865601 / seconds
Query Executed:select id FROM `va` where city='Annandale' && SIC_code='6021'DB:business_master_new
loadtime:0.094225883483887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appalachia' limit 1
loadtime:0.094298839569092 / seconds
Query Executed:select id FROM `va` where city='Appalachia' && SIC_code='6021'DB:business_master_new
loadtime:0.095538854598999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appomattox' limit 1
loadtime:0.095596790313721 / seconds
Query Executed:select id FROM `va` where city='Appomattox' && SIC_code='6021'DB:business_master_new
loadtime:0.096912860870361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.096962928771973 / seconds
Query Executed:select id FROM `va` where city='Ararat' && SIC_code='6021'DB:business_master_new
loadtime:0.097976922988892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.09803581237793 / seconds
Query Executed:select id FROM `va` where city='Arcola' && SIC_code='6021'DB:business_master_new
loadtime:0.098538875579834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ark' limit 1
loadtime:0.098570823669434 / seconds
Query Executed:select id FROM `va` where city='Ark' && SIC_code='6021'DB:business_master_new
loadtime:0.099025964736938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.099153995513916 / seconds
Query Executed:select id FROM `va` where city='Arlington' && SIC_code='6021'DB:business_master_new
loadtime:0.11937284469604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aroda' limit 1
loadtime:0.11946892738342 / seconds
Query Executed:select id FROM `va` where city='Aroda' && SIC_code='6021'DB:business_master_new
loadtime:0.11997294425964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrington' limit 1
loadtime:0.12002396583557 / seconds
Query Executed:select id FROM `va` where city='Arrington' && SIC_code='6021'DB:business_master_new
loadtime:0.12098479270935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvonia' limit 1
loadtime:0.12102580070496 / seconds
Query Executed:select id FROM `va` where city='Arvonia' && SIC_code='6021'DB:business_master_new
loadtime:0.12157297134399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburn' limit 1
loadtime:0.12162494659424 / seconds
Query Executed:select id FROM `va` where city='Ashburn' && SIC_code='6021'DB:business_master_new
loadtime:0.12354183197021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.12360501289368 / seconds
Query Executed:select id FROM `va` where city='Ashland' && SIC_code='6021'DB:business_master_new
loadtime:0.12554502487183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assawoman' limit 1
loadtime:0.12560081481934 / seconds
Query Executed:select id FROM `va` where city='Assawoman' && SIC_code='6021'DB:business_master_new
loadtime:0.12593197822571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.12598490715027 / seconds
Query Executed:select id FROM `va` where city='Atkins' && SIC_code='6021'DB:business_master_new
loadtime:0.12699580192566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.12705183029175 / seconds
Query Executed:select id FROM `va` where city='Atlantic' && SIC_code='6021'DB:business_master_new
loadtime:0.1276068687439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta Springs' limit 1
loadtime:0.12763500213623 / seconds
Query Executed:select id FROM `va` where city='Augusta Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.12799191474915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.12812399864197 / seconds
Query Executed:select id FROM `va` where city='Austinville' && SIC_code='6021'DB:business_master_new
loadtime:0.12902998924255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axton' limit 1
loadtime:0.12912583351135 / seconds
Query Executed:select id FROM `va` where city='Axton' && SIC_code='6021'DB:business_master_new
loadtime:0.13034296035767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aylett' limit 1
loadtime:0.13039493560791 / seconds
Query Executed:select id FROM `va` where city='Aylett' && SIC_code='6021'DB:business_master_new
loadtime:0.13156294822693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bacova' limit 1
loadtime:0.13160490989685 / seconds
Query Executed:select id FROM `va` where city='Bacova' && SIC_code='6021'DB:business_master_new
loadtime:0.13198590278625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Crossrds' limit 1
loadtime:0.13212299346924 / seconds
Query Executed:select id FROM `va` where city='Baileys Crossrds' && SIC_code='6021'DB:business_master_new
loadtime:0.13256001472473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banco' limit 1
loadtime:0.13258695602417 / seconds
Query Executed:select id FROM `va` where city='Banco' && SIC_code='6021'DB:business_master_new
loadtime:0.13289093971252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bandy' limit 1
loadtime:0.13294100761414 / seconds
Query Executed:select id FROM `va` where city='Bandy' && SIC_code='6021'DB:business_master_new
loadtime:0.13327884674072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barboursville' limit 1
loadtime:0.13332581520081 / seconds
Query Executed:select id FROM `va` where city='Barboursville' && SIC_code='6021'DB:business_master_new
loadtime:0.13442397117615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barhamsville' limit 1
loadtime:0.13445997238159 / seconds
Query Executed:select id FROM `va` where city='Barhamsville' && SIC_code='6021'DB:business_master_new
loadtime:0.13519597053528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barren Springs' limit 1
loadtime:0.13532900810242 / seconds
Query Executed:select id FROM `va` where city='Barren Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.13574481010437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baskerville' limit 1
loadtime:0.13578081130981 / seconds
Query Executed:select id FROM `va` where city='Baskerville' && SIC_code='6021'DB:business_master_new
loadtime:0.13630700111389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.13643789291382 / seconds
Query Executed:select id FROM `va` where city='Bassett' && SIC_code='6021'DB:business_master_new
loadtime:0.13791084289551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bastian' limit 1
loadtime:0.13797402381897 / seconds
Query Executed:select id FROM `va` where city='Bastian' && SIC_code='6021'DB:business_master_new
loadtime:0.13858294487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basye' limit 1
loadtime:0.13862085342407 / seconds
Query Executed:select id FROM `va` where city='Basye' && SIC_code='6021'DB:business_master_new
loadtime:0.13951301574707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.13957381248474 / seconds
Query Executed:select id FROM `va` where city='Batesville' && SIC_code='6021'DB:business_master_new
loadtime:0.13997793197632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battery Park' limit 1
loadtime:0.14002394676208 / seconds
Query Executed:select id FROM `va` where city='Battery Park' && SIC_code='6021'DB:business_master_new
loadtime:0.14033794403076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bavon' limit 1
loadtime:0.14037394523621 / seconds
Query Executed:select id FROM `va` where city='Bavon' && SIC_code='6021'DB:business_master_new
loadtime:0.14063692092896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bealeton' limit 1
loadtime:0.14067983627319 / seconds
Query Executed:select id FROM `va` where city='Bealeton' && SIC_code='6021'DB:business_master_new
loadtime:0.14188694953918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.14194679260254 / seconds
Query Executed:select id FROM `va` where city='Beaumont' && SIC_code='6021'DB:business_master_new
loadtime:0.14226484298706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverdam' limit 1
loadtime:0.14229798316956 / seconds
Query Executed:select id FROM `va` where city='Beaverdam' && SIC_code='6021'DB:business_master_new
loadtime:0.14370393753052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverlett' limit 1
loadtime:0.14376091957092 / seconds
Query Executed:select id FROM `va` where city='Beaverlett' && SIC_code='6021'DB:business_master_new
loadtime:0.14407587051392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.14411187171936 / seconds
Query Executed:select id FROM `va` where city='Bedford' && SIC_code='6021'DB:business_master_new
loadtime:0.14576292037964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bee' limit 1
loadtime:0.14582681655884 / seconds
Query Executed:select id FROM `va` where city='Bee' && SIC_code='6021'DB:business_master_new
loadtime:0.14619588851929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellamy' limit 1
loadtime:0.14623880386353 / seconds
Query Executed:select id FROM `va` where city='Bellamy' && SIC_code='6021'DB:business_master_new
loadtime:0.14651489257812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Haven' limit 1
loadtime:0.14656901359558 / seconds
Query Executed:select id FROM `va` where city='Belle Haven' && SIC_code='6021'DB:business_master_new
loadtime:0.14773297309875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belspring' limit 1
loadtime:0.14779496192932 / seconds
Query Executed:select id FROM `va` where city='Belspring' && SIC_code='6021'DB:business_master_new
loadtime:0.14813685417175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ben Hur' limit 1
loadtime:0.1481819152832 / seconds
Query Executed:select id FROM `va` where city='Ben Hur' && SIC_code='6021'DB:business_master_new
loadtime:0.14854788780212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bena' limit 1
loadtime:0.14859294891357 / seconds
Query Executed:select id FROM `va` where city='Bena' && SIC_code='6021'DB:business_master_new
loadtime:0.14910697937012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent Mountain' limit 1
loadtime:0.14922189712524 / seconds
Query Executed:select id FROM `va` where city='Bent Mountain' && SIC_code='6021'DB:business_master_new
loadtime:0.1501088142395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonville' limit 1
loadtime:0.15024399757385 / seconds
Query Executed:select id FROM `va` where city='Bentonville' && SIC_code='6021'DB:business_master_new
loadtime:0.15128087997437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergton' limit 1
loadtime:0.15139079093933 / seconds
Query Executed:select id FROM `va` where city='Bergton' && SIC_code='6021'DB:business_master_new
loadtime:0.15196180343628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berryville' limit 1
loadtime:0.15201497077942 / seconds
Query Executed:select id FROM `va` where city='Berryville' && SIC_code='6021'DB:business_master_new
loadtime:0.15336680412292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Island' limit 1
loadtime:0.15341091156006 / seconds
Query Executed:select id FROM `va` where city='Big Island' && SIC_code='6021'DB:business_master_new
loadtime:0.15431785583496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.15445780754089 / seconds
Query Executed:select id FROM `va` where city='Big Rock' && SIC_code='6021'DB:business_master_new
loadtime:0.1552197933197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone Gap' limit 1
loadtime:0.15536284446716 / seconds
Query Executed:select id FROM `va` where city='Big Stone Gap' && SIC_code='6021'DB:business_master_new
loadtime:0.15677881240845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchleaf' limit 1
loadtime:0.15683794021606 / seconds
Query Executed:select id FROM `va` where city='Birchleaf' && SIC_code='6021'DB:business_master_new
loadtime:0.15732097625732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birdsnest' limit 1
loadtime:0.15741395950317 / seconds
Query Executed:select id FROM `va` where city='Birdsnest' && SIC_code='6021'DB:business_master_new
loadtime:0.15788793563843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishop' limit 1
loadtime:0.15793681144714 / seconds
Query Executed:select id FROM `va` where city='Bishop' && SIC_code='6021'DB:business_master_new
loadtime:0.15836000442505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackridge' limit 1
loadtime:0.15843987464905 / seconds
Query Executed:select id FROM `va` where city='Blackridge' && SIC_code='6021'DB:business_master_new
loadtime:0.15882682800293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.15886783599854 / seconds
Query Executed:select id FROM `va` where city='Blacksburg' && SIC_code='6021'DB:business_master_new
loadtime:0.16098189353943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.16104888916016 / seconds
Query Executed:select id FROM `va` where city='Blackstone' && SIC_code='6021'DB:business_master_new
loadtime:0.16239190101624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwater' limit 1
loadtime:0.1624448299408 / seconds
Query Executed:select id FROM `va` where city='Blackwater' && SIC_code='6021'DB:business_master_new
loadtime:0.16288089752197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairs' limit 1
loadtime:0.16293382644653 / seconds
Query Executed:select id FROM `va` where city='Blairs' && SIC_code='6021'DB:business_master_new
loadtime:0.16433095932007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakes' limit 1
loadtime:0.1644458770752 / seconds
Query Executed:select id FROM `va` where city='Blakes' && SIC_code='6021'DB:business_master_new
loadtime:0.16477584838867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bland' limit 1
loadtime:0.16481995582581 / seconds
Query Executed:select id FROM `va` where city='Bland' && SIC_code='6021'DB:business_master_new
loadtime:0.16595602035522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloxom' limit 1
loadtime:0.16601395606995 / seconds
Query Executed:select id FROM `va` where city='Bloxom' && SIC_code='6021'DB:business_master_new
loadtime:0.16663098335266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.16665887832642 / seconds
Query Executed:select id FROM `va` where city='Blue Grass' && SIC_code='6021'DB:business_master_new
loadtime:0.16720294952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Ridge' limit 1
loadtime:0.16725993156433 / seconds
Query Executed:select id FROM `va` where city='Blue Ridge' && SIC_code='6021'DB:business_master_new
loadtime:0.16839098930359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:0.16843485832214 / seconds
Query Executed:select id FROM `va` where city='Bluefield' && SIC_code='6021'DB:business_master_new
loadtime:0.16977882385254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluemont' limit 1
loadtime:0.16983890533447 / seconds
Query Executed:select id FROM `va` where city='Bluemont' && SIC_code='6021'DB:business_master_new
loadtime:0.17096185684204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bohannon' limit 1
loadtime:0.17100787162781 / seconds
Query Executed:select id FROM `va` where city='Bohannon' && SIC_code='6021'DB:business_master_new
loadtime:0.17130994796753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boissevain' limit 1
loadtime:0.17135095596313 / seconds
Query Executed:select id FROM `va` where city='Boissevain' && SIC_code='6021'DB:business_master_new
loadtime:0.17169499397278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolar' limit 1
loadtime:0.17172884941101 / seconds
Query Executed:select id FROM `va` where city='Bolar' && SIC_code='6021'DB:business_master_new
loadtime:0.17197799682617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:0.17201495170593 / seconds
Query Executed:select id FROM `va` where city='Bon Air' && SIC_code='6021'DB:business_master_new
loadtime:0.17260599136353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boones Mill' limit 1
loadtime:0.17264294624329 / seconds
Query Executed:select id FROM `va` where city='Boones Mill' && SIC_code='6021'DB:business_master_new
loadtime:0.17384099960327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.17388987541199 / seconds
Query Executed:select id FROM `va` where city='Boston' && SIC_code='6021'DB:business_master_new
loadtime:0.17448496818542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.1745548248291 / seconds
Query Executed:select id FROM `va` where city='Bowling Green' && SIC_code='6021'DB:business_master_new
loadtime:0.17573881149292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyce' limit 1
loadtime:0.17579102516174 / seconds
Query Executed:select id FROM `va` where city='Boyce' && SIC_code='6021'DB:business_master_new
loadtime:0.17691683769226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boydton' limit 1
loadtime:0.17697501182556 / seconds
Query Executed:select id FROM `va` where city='Boydton' && SIC_code='6021'DB:business_master_new
loadtime:0.17810583114624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykins' limit 1
loadtime:0.17815399169922 / seconds
Query Executed:select id FROM `va` where city='Boykins' && SIC_code='6021'DB:business_master_new
loadtime:0.17907786369324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bracey' limit 1
loadtime:0.17920589447021 / seconds
Query Executed:select id FROM `va` where city='Bracey' && SIC_code='6021'DB:business_master_new
loadtime:0.18042302131653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.18048596382141 / seconds
Query Executed:select id FROM `va` where city='Branchville' && SIC_code='6021'DB:business_master_new
loadtime:0.18094491958618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandy Station' limit 1
loadtime:0.18099594116211 / seconds
Query Executed:select id FROM `va` where city='Brandy Station' && SIC_code='6021'DB:business_master_new
loadtime:0.18183994293213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breaks' limit 1
loadtime:0.18187499046326 / seconds
Query Executed:select id FROM `va` where city='Breaks' && SIC_code='6021'DB:business_master_new
loadtime:0.18225693702698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremo Bluff' limit 1
loadtime:0.18231391906738 / seconds
Query Executed:select id FROM `va` where city='Bremo Bluff' && SIC_code='6021'DB:business_master_new
loadtime:0.18270301818848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.18274188041687 / seconds
Query Executed:select id FROM `va` where city='Bridgewater' && SIC_code='6021'DB:business_master_new
loadtime:0.1840558052063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:0.18422698974609 / seconds
Query Executed:select id FROM `va` where city='Brightwood' && SIC_code='6021'DB:business_master_new
loadtime:0.18484497070312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.18489789962769 / seconds
Query Executed:select id FROM `va` where city='Bristol' && SIC_code='6021'DB:business_master_new
loadtime:0.18675494194031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.18681192398071 / seconds
Query Executed:select id FROM `va` where city='Bristow' && SIC_code='6021'DB:business_master_new
loadtime:0.18806791305542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Run' limit 1
loadtime:0.18820691108704 / seconds
Query Executed:select id FROM `va` where city='Broad Run' && SIC_code='6021'DB:business_master_new
loadtime:0.1893138885498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadford' limit 1
loadtime:0.18942880630493 / seconds
Query Executed:select id FROM `va` where city='Broadford' && SIC_code='6021'DB:business_master_new
loadtime:0.18987083435059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.18992400169373 / seconds
Query Executed:select id FROM `va` where city='Broadway' && SIC_code='6021'DB:business_master_new
loadtime:0.19124698638916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodnax' limit 1
loadtime:0.19140481948853 / seconds
Query Executed:select id FROM `va` where city='Brodnax' && SIC_code='6021'DB:business_master_new
loadtime:0.1925950050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooke' limit 1
loadtime:0.19262981414795 / seconds
Query Executed:select id FROM `va` where city='Brooke' && SIC_code='6021'DB:business_master_new
loadtime:0.19296479225159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookneal' limit 1
loadtime:0.1930148601532 / seconds
Query Executed:select id FROM `va` where city='Brookneal' && SIC_code='6021'DB:business_master_new
loadtime:0.19425892829895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsburg' limit 1
loadtime:0.19441699981689 / seconds
Query Executed:select id FROM `va` where city='Brownsburg' && SIC_code='6021'DB:business_master_new
loadtime:0.1948549747467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brucetown' limit 1
loadtime:0.19490599632263 / seconds
Query Executed:select id FROM `va` where city='Brucetown' && SIC_code='6021'DB:business_master_new
loadtime:0.19516086578369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruington' limit 1
loadtime:0.19525098800659 / seconds
Query Executed:select id FROM `va` where city='Bruington' && SIC_code='6021'DB:business_master_new
loadtime:0.19563484191895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:0.1956729888916 / seconds
Query Executed:select id FROM `va` where city='Buchanan' && SIC_code='6021'DB:business_master_new
loadtime:0.19687986373901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:0.19692587852478 / seconds
Query Executed:select id FROM `va` where city='Buckingham' && SIC_code='6021'DB:business_master_new
loadtime:0.19807386398315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.19820594787598 / seconds
Query Executed:select id FROM `va` where city='Buena Vista' && SIC_code='6021'DB:business_master_new
loadtime:0.19957399368286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Junction' limit 1
loadtime:0.19963192939758 / seconds
Query Executed:select id FROM `va` where city='Buffalo Junction' && SIC_code='6021'DB:business_master_new
loadtime:0.20048189163208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bumpass' limit 1
loadtime:0.20057392120361 / seconds
Query Executed:select id FROM `va` where city='Bumpass' && SIC_code='6021'DB:business_master_new
loadtime:0.2016658782959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgess' limit 1
loadtime:0.20171594619751 / seconds
Query Executed:select id FROM `va` where city='Burgess' && SIC_code='6021'DB:business_master_new
loadtime:0.20283484458923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.2028968334198 / seconds
Query Executed:select id FROM `va` where city='Burke' && SIC_code='6021'DB:business_master_new
loadtime:0.20475888252258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkes Garden' limit 1
loadtime:0.20482301712036 / seconds
Query Executed:select id FROM `va` where city='Burkes Garden' && SIC_code='6021'DB:business_master_new
loadtime:0.20517301559448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkeville' limit 1
loadtime:0.20522379875183 / seconds
Query Executed:select id FROM `va` where city='Burkeville' && SIC_code='6021'DB:business_master_new
loadtime:0.20632886886597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.20638084411621 / seconds
Query Executed:select id FROM `va` where city='Burnsville' && SIC_code='6021'DB:business_master_new
loadtime:0.20671081542969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Hill' limit 1
loadtime:0.20675492286682 / seconds
Query Executed:select id FROM `va` where city='Burr Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.20714092254639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callands' limit 1
loadtime:0.20726180076599 / seconds
Query Executed:select id FROM `va` where city='Callands' && SIC_code='6021'DB:business_master_new
loadtime:0.20802688598633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callao' limit 1
loadtime:0.20816683769226 / seconds
Query Executed:select id FROM `va` where city='Callao' && SIC_code='6021'DB:business_master_new
loadtime:0.20941281318665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callaway' limit 1
loadtime:0.20946884155273 / seconds
Query Executed:select id FROM `va` where city='Callaway' && SIC_code='6021'DB:business_master_new
loadtime:0.21033501625061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calverton' limit 1
loadtime:0.2104549407959 / seconds
Query Executed:select id FROM `va` where city='Calverton' && SIC_code='6021'DB:business_master_new
loadtime:0.21114087104797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cana' limit 1
loadtime:0.2111918926239 / seconds
Query Executed:select id FROM `va` where city='Cana' && SIC_code='6021'DB:business_master_new
loadtime:0.21238899230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Charles' limit 1
loadtime:0.21257495880127 / seconds
Query Executed:select id FROM `va` where city='Cape Charles' && SIC_code='6021'DB:business_master_new
loadtime:0.21377801895142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capeville' limit 1
loadtime:0.21382689476013 / seconds
Query Executed:select id FROM `va` where city='Capeville' && SIC_code='6021'DB:business_master_new
loadtime:0.2142059803009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capron' limit 1
loadtime:0.21434497833252 / seconds
Query Executed:select id FROM `va` where city='Capron' && SIC_code='6021'DB:business_master_new
loadtime:0.21534299850464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardinal' limit 1
loadtime:0.21545791625977 / seconds
Query Executed:select id FROM `va` where city='Cardinal' && SIC_code='6021'DB:business_master_new
loadtime:0.21589183807373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caret' limit 1
loadtime:0.21594285964966 / seconds
Query Executed:select id FROM `va` where city='Caret' && SIC_code='6021'DB:business_master_new
loadtime:0.21639180183411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.21652293205261 / seconds
Query Executed:select id FROM `va` where city='Carrollton' && SIC_code='6021'DB:business_master_new
loadtime:0.21768999099731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrsville' limit 1
loadtime:0.21773481369019 / seconds
Query Executed:select id FROM `va` where city='Carrsville' && SIC_code='6021'DB:business_master_new
loadtime:0.218416929245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.21846294403076 / seconds
Query Executed:select id FROM `va` where city='Carson' && SIC_code='6021'DB:business_master_new
loadtime:0.2191379070282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cartersville' limit 1
loadtime:0.21918702125549 / seconds
Query Executed:select id FROM `va` where city='Cartersville' && SIC_code='6021'DB:business_master_new
loadtime:0.21984696388245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casanova' limit 1
loadtime:0.21988987922668 / seconds
Query Executed:select id FROM `va` where city='Casanova' && SIC_code='6021'DB:business_master_new
loadtime:0.22033786773682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.22048091888428 / seconds
Query Executed:select id FROM `va` where city='Cascade' && SIC_code='6021'DB:business_master_new
loadtime:0.22125792503357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.22139382362366 / seconds
Query Executed:select id FROM `va` where city='Castleton' && SIC_code='6021'DB:business_master_new
loadtime:0.22202086448669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.22207188606262 / seconds
Query Executed:select id FROM `va` where city='Castlewood' && SIC_code='6021'DB:business_master_new
loadtime:0.22328495979309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.22343301773071 / seconds
Query Executed:select id FROM `va` where city='Catawba' && SIC_code='6021'DB:business_master_new
loadtime:0.2241268157959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharpin' limit 1
loadtime:0.22417497634888 / seconds
Query Executed:select id FROM `va` where city='Catharpin' && SIC_code='6021'DB:business_master_new
loadtime:0.22511386871338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catlett' limit 1
loadtime:0.22516179084778 / seconds
Query Executed:select id FROM `va` where city='Catlett' && SIC_code='6021'DB:business_master_new
loadtime:0.22632884979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:0.22638702392578 / seconds
Query Executed:select id FROM `va` where city='Cedar Bluff' && SIC_code='6021'DB:business_master_new
loadtime:0.22764587402344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Cross' limit 1
loadtime:0.22769594192505 / seconds
Query Executed:select id FROM `va` where city='Center Cross' && SIC_code='6021'DB:business_master_new
loadtime:0.22822999954224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.2283627986908 / seconds
Query Executed:select id FROM `va` where city='Centreville' && SIC_code='6021'DB:business_master_new
loadtime:0.23049688339233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceres' limit 1
loadtime:0.23057389259338 / seconds
Query Executed:select id FROM `va` where city='Ceres' && SIC_code='6021'DB:business_master_new
loadtime:0.23101782798767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champlain' limit 1
loadtime:0.23106098175049 / seconds
Query Executed:select id FROM `va` where city='Champlain' && SIC_code='6021'DB:business_master_new
loadtime:0.23150682449341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chantilly' limit 1
loadtime:0.23155689239502 / seconds
Query Executed:select id FROM `va` where city='Chantilly' && SIC_code='6021'DB:business_master_new
loadtime:0.23395991325378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:0.23401784896851 / seconds
Query Executed:select id FROM `va` where city='Charles City' && SIC_code='6021'DB:business_master_new
loadtime:0.2352249622345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Court House' limit 1
loadtime:0.23528385162354 / seconds
Query Executed:select id FROM `va` where city='Charlotte Court House' && SIC_code='6021'DB:business_master_new
loadtime:0.23650288581848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Ct Hse' limit 1
loadtime:0.23657202720642 / seconds
Query Executed:select id FROM `va` where city='Charlotte Ct Hse' && SIC_code='6021'DB:business_master_new
loadtime:0.23713183403015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlottesville' limit 1
loadtime:0.23717284202576 / seconds
Query Executed:select id FROM `va` where city='Charlottesville' && SIC_code='6021'DB:business_master_new
loadtime:0.2572078704834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase City' limit 1
loadtime:0.2574508190155 / seconds
Query Executed:select id FROM `va` where city='Chase City' && SIC_code='6021'DB:business_master_new
loadtime:0.25883889198303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.25891184806824 / seconds
Query Executed:select id FROM `va` where city='Chatham' && SIC_code='6021'DB:business_master_new
loadtime:0.2603018283844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Check' limit 1
loadtime:0.26035380363464 / seconds
Query Executed:select id FROM `va` where city='Check' && SIC_code='6021'DB:business_master_new
loadtime:0.26101589202881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheriton' limit 1
loadtime:0.26106595993042 / seconds
Query Executed:select id FROM `va` where city='Cheriton' && SIC_code='6021'DB:business_master_new
loadtime:0.26195502281189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesapeake' limit 1
loadtime:0.26199889183044 / seconds
Query Executed:select id FROM `va` where city='Chesapeake' && SIC_code='6021'DB:business_master_new
loadtime:0.28171801567078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.28179979324341 / seconds
Query Executed:select id FROM `va` where city='Chester' && SIC_code='6021'DB:business_master_new
loadtime:0.28373098373413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester Gap' limit 1
loadtime:0.28379392623901 / seconds
Query Executed:select id FROM `va` where city='Chester Gap' && SIC_code='6021'DB:business_master_new
loadtime:0.2841968536377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.28424191474915 / seconds
Query Executed:select id FROM `va` where city='Chesterfield' && SIC_code='6021'DB:business_master_new
loadtime:0.28605484962463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilhowie' limit 1
loadtime:0.28619289398193 / seconds
Query Executed:select id FROM `va` where city='Chilhowie' && SIC_code='6021'DB:business_master_new
loadtime:0.28754186630249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague' limit 1
loadtime:0.28760600090027 / seconds
Query Executed:select id FROM `va` where city='Chincoteague' && SIC_code='6021'DB:business_master_new
loadtime:0.28818702697754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague Island' limit 1
loadtime:0.28831386566162 / seconds
Query Executed:select id FROM `va` where city='Chincoteague Island' && SIC_code='6021'DB:business_master_new
loadtime:0.28964495658875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christchurch' limit 1
loadtime:0.28969693183899 / seconds
Query Executed:select id FROM `va` where city='Christchurch' && SIC_code='6021'DB:business_master_new
loadtime:0.29005694389343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christiansburg' limit 1
loadtime:0.29018902778625 / seconds
Query Executed:select id FROM `va` where city='Christiansburg' && SIC_code='6021'DB:business_master_new
loadtime:0.29232597351074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Road' limit 1
loadtime:0.29246282577515 / seconds
Query Executed:select id FROM `va` where city='Church Road' && SIC_code='6021'DB:business_master_new
loadtime:0.29334402084351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church View' limit 1
loadtime:0.29349088668823 / seconds
Query Executed:select id FROM `va` where city='Church View' && SIC_code='6021'DB:business_master_new
loadtime:0.29395794868469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churchville' limit 1
loadtime:0.29399800300598 / seconds
Query Executed:select id FROM `va` where city='Churchville' && SIC_code='6021'DB:business_master_new
loadtime:0.29536080360413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cismont' limit 1
loadtime:0.29542088508606 / seconds
Query Executed:select id FROM `va` where city='Cismont' && SIC_code='6021'DB:business_master_new
loadtime:0.2957239151001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.29576301574707 / seconds
Query Executed:select id FROM `va` where city='Claremont' && SIC_code='6021'DB:business_master_new
loadtime:0.29634499549866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.29646897315979 / seconds
Query Executed:select id FROM `va` where city='Clarksville' && SIC_code='6021'DB:business_master_new
loadtime:0.29778695106506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claudville' limit 1
loadtime:0.29784488677979 / seconds
Query Executed:select id FROM `va` where city='Claudville' && SIC_code='6021'DB:business_master_new
loadtime:0.29853296279907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Brook' limit 1
loadtime:0.29856896400452 / seconds
Query Executed:select id FROM `va` where city='Clear Brook' && SIC_code='6021'DB:business_master_new
loadtime:0.29976391792297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.29980993270874 / seconds
Query Executed:select id FROM `va` where city='Cleveland' && SIC_code='6021'DB:business_master_new
loadtime:0.30036091804504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:0.30040383338928 / seconds
Query Executed:select id FROM `va` where city='Clifford' && SIC_code='6021'DB:business_master_new
loadtime:0.30071783065796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.30076098442078 / seconds
Query Executed:select id FROM `va` where city='Clifton' && SIC_code='6021'DB:business_master_new
loadtime:0.3021068572998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton Forge' limit 1
loadtime:0.30215001106262 / seconds
Query Executed:select id FROM `va` where city='Clifton Forge' && SIC_code='6021'DB:business_master_new
loadtime:0.30340385437012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchco' limit 1
loadtime:0.30346488952637 / seconds
Query Executed:select id FROM `va` where city='Clinchco' && SIC_code='6021'DB:business_master_new
loadtime:0.30409693717957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchport' limit 1
loadtime:0.30413889884949 / seconds
Query Executed:select id FROM `va` where city='Clinchport' && SIC_code='6021'DB:business_master_new
loadtime:0.30447888374329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintwood' limit 1
loadtime:0.30453491210938 / seconds
Query Executed:select id FROM `va` where city='Clintwood' && SIC_code='6021'DB:business_master_new
loadtime:0.3057758808136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:0.30582690238953 / seconds
Query Executed:select id FROM `va` where city='Clover' && SIC_code='6021'DB:business_master_new
loadtime:0.30654001235962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:0.30658984184265 / seconds
Query Executed:select id FROM `va` where city='Cloverdale' && SIC_code='6021'DB:business_master_new
loadtime:0.30760097503662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cluster Springs' limit 1
loadtime:0.30764889717102 / seconds
Query Executed:select id FROM `va` where city='Cluster Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.30790996551514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobbs Creek' limit 1
loadtime:0.30794382095337 / seconds
Query Executed:select id FROM `va` where city='Cobbs Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.30859684944153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobham' limit 1
loadtime:0.30862188339233 / seconds
Query Executed:select id FROM `va` where city='Cobham' && SIC_code='6021'DB:business_master_new
loadtime:0.30887198448181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coeburn' limit 1
loadtime:0.30890893936157 / seconds
Query Executed:select id FROM `va` where city='Coeburn' && SIC_code='6021'DB:business_master_new
loadtime:0.31015491485596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman Falls' limit 1
loadtime:0.31019902229309 / seconds
Query Executed:select id FROM `va` where city='Coleman Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.31053495407104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coles Point' limit 1
loadtime:0.3105788230896 / seconds
Query Executed:select id FROM `va` where city='Coles Point' && SIC_code='6021'DB:business_master_new
loadtime:0.31094789505005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.31098198890686 / seconds
Query Executed:select id FROM `va` where city='Collinsville' && SIC_code='6021'DB:business_master_new
loadtime:0.31231284141541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:0.31237387657166 / seconds
Query Executed:select id FROM `va` where city='Cologne' && SIC_code='6021'DB:business_master_new
loadtime:0.31265997886658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Beach' limit 1
loadtime:0.31270098686218 / seconds
Query Executed:select id FROM `va` where city='Colonial Beach' && SIC_code='6021'DB:business_master_new
loadtime:0.31401491165161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Heights' limit 1
loadtime:0.31417393684387 / seconds
Query Executed:select id FROM `va` where city='Colonial Heights' && SIC_code='6021'DB:business_master_new
loadtime:0.31624579429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.3164279460907 / seconds
Query Executed:select id FROM `va` where city='Columbia' && SIC_code='6021'DB:business_master_new
loadtime:0.31725883483887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conaway' limit 1
loadtime:0.31737184524536 / seconds
Query Executed:select id FROM `va` where city='Conaway' && SIC_code='6021'DB:business_master_new
loadtime:0.31772780418396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.31777381896973 / seconds
Query Executed:select id FROM `va` where city='Concord' && SIC_code='6021'DB:business_master_new
loadtime:0.31890892982483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Hill' limit 1
loadtime:0.31896686553955 / seconds
Query Executed:select id FROM `va` where city='Copper Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.31964683532715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin' limit 1
loadtime:0.31968998908997 / seconds
Query Executed:select id FROM `va` where city='Corbin' && SIC_code='6021'DB:business_master_new
loadtime:0.32011294364929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:0.3202269077301 / seconds
Query Executed:select id FROM `va` where city='Council' && SIC_code='6021'DB:business_master_new
loadtime:0.32060194015503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.32064294815063 / seconds
Query Executed:select id FROM `va` where city='Courtland' && SIC_code='6021'DB:business_master_new
loadtime:0.32182693481445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covesville' limit 1
loadtime:0.32188487052917 / seconds
Query Executed:select id FROM `va` where city='Covesville' && SIC_code='6021'DB:business_master_new
loadtime:0.32239389419556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:0.32244181632996 / seconds
Query Executed:select id FROM `va` where city='Covington' && SIC_code='6021'DB:business_master_new
loadtime:0.32399582862854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craddockville' limit 1
loadtime:0.32404899597168 / seconds
Query Executed:select id FROM `va` where city='Craddockville' && SIC_code='6021'DB:business_master_new
loadtime:0.32439494132996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:0.32443499565125 / seconds
Query Executed:select id FROM `va` where city='Craigsville' && SIC_code='6021'DB:business_master_new
loadtime:0.3251268863678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crewe' limit 1
loadtime:0.32517790794373 / seconds
Query Executed:select id FROM `va` where city='Crewe' && SIC_code='6021'DB:business_master_new
loadtime:0.32640981674194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criders' limit 1
loadtime:0.32646989822388 / seconds
Query Executed:select id FROM `va` where city='Criders' && SIC_code='6021'DB:business_master_new
loadtime:0.32690286636353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criglersville' limit 1
loadtime:0.32694697380066 / seconds
Query Executed:select id FROM `va` where city='Criglersville' && SIC_code='6021'DB:business_master_new
loadtime:0.32721281051636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crimora' limit 1
loadtime:0.32728981971741 / seconds
Query Executed:select id FROM `va` where city='Crimora' && SIC_code='6021'DB:business_master_new
loadtime:0.32807588577271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:0.32812881469727 / seconds
Query Executed:select id FROM `va` where city='Cripple Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.32843494415283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Critz' limit 1
loadtime:0.32846784591675 / seconds
Query Executed:select id FROM `va` where city='Critz' && SIC_code='6021'DB:business_master_new
loadtime:0.3289258480072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crockett' limit 1
loadtime:0.32897281646729 / seconds
Query Executed:select id FROM `va` where city='Crockett' && SIC_code='6021'DB:business_master_new
loadtime:0.3294038772583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Junction' limit 1
loadtime:0.32943987846375 / seconds
Query Executed:select id FROM `va` where city='Cross Junction' && SIC_code='6021'DB:business_master_new
loadtime:0.33056783676147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozet' limit 1
loadtime:0.33061194419861 / seconds
Query Executed:select id FROM `va` where city='Crozet' && SIC_code='6021'DB:business_master_new
loadtime:0.33186602592468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozier' limit 1
loadtime:0.33192086219788 / seconds
Query Executed:select id FROM `va` where city='Crozier' && SIC_code='6021'DB:business_master_new
loadtime:0.33270192146301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Hill' limit 1
loadtime:0.33273601531982 / seconds
Query Executed:select id FROM `va` where city='Crystal Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.33310389518738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullen' limit 1
loadtime:0.33315181732178 / seconds
Query Executed:select id FROM `va` where city='Cullen' && SIC_code='6021'DB:business_master_new
loadtime:0.33356380462646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culpeper' limit 1
loadtime:0.33359789848328 / seconds
Query Executed:select id FROM `va` where city='Culpeper' && SIC_code='6021'DB:business_master_new
loadtime:0.33543491363525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.33549380302429 / seconds
Query Executed:select id FROM `va` where city='Cumberland' && SIC_code='6021'DB:business_master_new
loadtime:0.33663988113403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dahlgren' limit 1
loadtime:0.33669495582581 / seconds
Query Executed:select id FROM `va` where city='Dahlgren' && SIC_code='6021'DB:business_master_new
loadtime:0.33779191970825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale City' limit 1
loadtime:0.33784794807434 / seconds
Query Executed:select id FROM `va` where city='Dale City' && SIC_code='6021'DB:business_master_new
loadtime:0.33843779563904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:0.33847880363464 / seconds
Query Executed:select id FROM `va` where city='Daleville' && SIC_code='6021'DB:business_master_new
loadtime:0.33976483345032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:0.33993482589722 / seconds
Query Executed:select id FROM `va` where city='Damascus' && SIC_code='6021'DB:business_master_new
loadtime:0.34120893478394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.34136390686035 / seconds
Query Executed:select id FROM `va` where city='Dante' && SIC_code='6021'DB:business_master_new
loadtime:0.34201288223267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.34214091300964 / seconds
Query Executed:select id FROM `va` where city='Danville' && SIC_code='6021'DB:business_master_new
loadtime:0.34500479698181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington Hts' limit 1
loadtime:0.34506297111511 / seconds
Query Executed:select id FROM `va` where city='Darlington Hts' && SIC_code='6021'DB:business_master_new
loadtime:0.34532189369202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:0.34536385536194 / seconds
Query Executed:select id FROM `va` where city='Davenport' && SIC_code='6021'DB:business_master_new
loadtime:0.34576892852783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Wharf' limit 1
loadtime:0.34581589698792 / seconds
Query Executed:select id FROM `va` where city='Davis Wharf' && SIC_code='6021'DB:business_master_new
loadtime:0.34606790542603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.34614300727844 / seconds
Query Executed:select id FROM `va` where city='Dayton' && SIC_code='6021'DB:business_master_new
loadtime:0.34742879867554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.34748697280884 / seconds
Query Executed:select id FROM `va` where city='Deerfield' && SIC_code='6021'DB:business_master_new
loadtime:0.34789085388184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaplane' limit 1
loadtime:0.34792685508728 / seconds
Query Executed:select id FROM `va` where city='Delaplane' && SIC_code='6021'DB:business_master_new
loadtime:0.34859895706177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deltaville' limit 1
loadtime:0.34865093231201 / seconds
Query Executed:select id FROM `va` where city='Deltaville' && SIC_code='6021'DB:business_master_new
loadtime:0.34981894493103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dendron' limit 1
loadtime:0.34987998008728 / seconds
Query Executed:select id FROM `va` where city='Dendron' && SIC_code='6021'DB:business_master_new
loadtime:0.35043597221375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:0.35047888755798 / seconds
Query Executed:select id FROM `va` where city='Dewitt' && SIC_code='6021'DB:business_master_new
loadtime:0.35123896598816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diggs' limit 1
loadtime:0.35137486457825 / seconds
Query Executed:select id FROM `va` where city='Diggs' && SIC_code='6021'DB:business_master_new
loadtime:0.35176086425781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillwyn' limit 1
loadtime:0.35179901123047 / seconds
Query Executed:select id FROM `va` where city='Dillwyn' && SIC_code='6021'DB:business_master_new
loadtime:0.35301780700684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinwiddie' limit 1
loadtime:0.35307788848877 / seconds
Query Executed:select id FROM `va` where city='Dinwiddie' && SIC_code='6021'DB:business_master_new
loadtime:0.35429692268372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Disputanta' limit 1
loadtime:0.35443496704102 / seconds
Query Executed:select id FROM `va` where city='Disputanta' && SIC_code='6021'DB:business_master_new
loadtime:0.35557293891907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doe Hill' limit 1
loadtime:0.35562300682068 / seconds
Query Executed:select id FROM `va` where city='Doe Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.35599279403687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dogue' limit 1
loadtime:0.35603499412537 / seconds
Query Executed:select id FROM `va` where city='Dogue' && SIC_code='6021'DB:business_master_new
loadtime:0.35633397102356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolphin' limit 1
loadtime:0.35637092590332 / seconds
Query Executed:select id FROM `va` where city='Dolphin' && SIC_code='6021'DB:business_master_new
loadtime:0.35681581497192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doran' limit 1
loadtime:0.35686588287354 / seconds
Query Executed:select id FROM `va` where city='Doran' && SIC_code='6021'DB:business_master_new
loadtime:0.35740280151367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doswell' limit 1
loadtime:0.3574378490448 / seconds
Query Executed:select id FROM `va` where city='Doswell' && SIC_code='6021'DB:business_master_new
loadtime:0.35856199264526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakes Branch' limit 1
loadtime:0.35861992835999 / seconds
Query Executed:select id FROM `va` where city='Drakes Branch' && SIC_code='6021'DB:business_master_new
loadtime:0.35964393615723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.35969591140747 / seconds
Query Executed:select id FROM `va` where city='Draper' && SIC_code='6021'DB:business_master_new
loadtime:0.36034488677979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewryville' limit 1
loadtime:0.36039900779724 / seconds
Query Executed:select id FROM `va` where city='Drewryville' && SIC_code='6021'DB:business_master_new
loadtime:0.36089587211609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Fork' limit 1
loadtime:0.36093997955322 / seconds
Query Executed:select id FROM `va` where city='Dry Fork' && SIC_code='6021'DB:business_master_new
loadtime:0.36225581169128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:0.36230492591858 / seconds
Query Executed:select id FROM `va` where city='Dryden' && SIC_code='6021'DB:business_master_new
loadtime:0.36311101913452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.36324787139893 / seconds
Query Executed:select id FROM `va` where city='Dublin' && SIC_code='6021'DB:business_master_new
loadtime:0.36465191841125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duffield' limit 1
loadtime:0.36470890045166 / seconds
Query Executed:select id FROM `va` where city='Duffield' && SIC_code='6021'DB:business_master_new
loadtime:0.36597681045532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugspur' limit 1
loadtime:0.36611199378967 / seconds
Query Executed:select id FROM `va` where city='Dugspur' && SIC_code='6021'DB:business_master_new
loadtime:0.36671590805054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulles' limit 1
loadtime:0.36681699752808 / seconds
Query Executed:select id FROM `va` where city='Dulles' && SIC_code='6021'DB:business_master_new
loadtime:0.36743402481079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumfries' limit 1
loadtime:0.36748886108398 / seconds
Query Executed:select id FROM `va` where city='Dumfries' && SIC_code='6021'DB:business_master_new
loadtime:0.36899399757385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundas' limit 1
loadtime:0.36904788017273 / seconds
Query Executed:select id FROM `va` where city='Dundas' && SIC_code='6021'DB:business_master_new
loadtime:0.36946392059326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dungannon' limit 1
loadtime:0.36950397491455 / seconds
Query Executed:select id FROM `va` where city='Dungannon' && SIC_code='6021'DB:business_master_new
loadtime:0.37006402015686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn Loring' limit 1
loadtime:0.3701159954071 / seconds
Query Executed:select id FROM `va` where city='Dunn Loring' && SIC_code='6021'DB:business_master_new
loadtime:0.37128782272339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunnsville' limit 1
loadtime:0.37140583992004 / seconds
Query Executed:select id FROM `va` where city='Dunnsville' && SIC_code='6021'DB:business_master_new
loadtime:0.37208580970764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:0.37212800979614 / seconds
Query Executed:select id FROM `va` where city='Dutton' && SIC_code='6021'DB:business_master_new
loadtime:0.37256002426147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyke' limit 1
loadtime:0.3726007938385 / seconds
Query Executed:select id FROM `va` where city='Dyke' && SIC_code='6021'DB:business_master_new
loadtime:0.37309789657593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:0.37323188781738 / seconds
Query Executed:select id FROM `va` where city='Eagle Rock' && SIC_code='6021'DB:business_master_new
loadtime:0.37403988838196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlysville' limit 1
loadtime:0.37409400939941 / seconds
Query Executed:select id FROM `va` where city='Earlysville' && SIC_code='6021'DB:business_master_new
loadtime:0.37524485588074 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Stone Gap' limit 1
loadtime:0.37529683113098 / seconds
Query Executed:select id FROM `va` where city='East Stone Gap' && SIC_code='6021'DB:business_master_new
loadtime:0.37561583518982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastville' limit 1
loadtime:0.37565493583679 / seconds
Query Executed:select id FROM `va` where city='Eastville' && SIC_code='6021'DB:business_master_new
loadtime:0.37665891647339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ebony' limit 1
loadtime:0.37669992446899 / seconds
Query Executed:select id FROM `va` where city='Ebony' && SIC_code='6021'DB:business_master_new
loadtime:0.37726593017578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:0.37739992141724 / seconds
Query Executed:select id FROM `va` where city='Edinburg' && SIC_code='6021'DB:business_master_new
loadtime:0.37864279747009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:0.37869381904602 / seconds
Query Executed:select id FROM `va` where city='Edwardsville' && SIC_code='6021'DB:business_master_new
loadtime:0.3789598941803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eggleston' limit 1
loadtime:0.3790009021759 / seconds
Query Executed:select id FROM `va` where city='Eggleston' && SIC_code='6021'DB:business_master_new
loadtime:0.37934398651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:0.37937593460083 / seconds
Query Executed:select id FROM `va` where city='Elberon' && SIC_code='6021'DB:business_master_new
loadtime:0.37984585762024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Creek' limit 1
loadtime:0.37989497184753 / seconds
Query Executed:select id FROM `va` where city='Elk Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.38048982620239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:0.38056898117065 / seconds
Query Executed:select id FROM `va` where city='Elk Garden' && SIC_code='6021'DB:business_master_new
loadtime:0.38081979751587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.380854845047 / seconds
Query Executed:select id FROM `va` where city='Elkton' && SIC_code='6021'DB:business_master_new
loadtime:0.38214302062988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkwood' limit 1
loadtime:0.38220286369324 / seconds
Query Executed:select id FROM `va` where city='Elkwood' && SIC_code='6021'DB:business_master_new
loadtime:0.38273596763611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliston' limit 1
loadtime:0.38276386260986 / seconds
Query Executed:select id FROM `va` where city='Elliston' && SIC_code='6021'DB:business_master_new
loadtime:0.3837559223175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emory' limit 1
loadtime:0.38380479812622 / seconds
Query Executed:select id FROM `va` where city='Emory' && SIC_code='6021'DB:business_master_new
loadtime:0.38418793678284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:0.38423180580139 / seconds
Query Executed:select id FROM `va` where city='Emporia' && SIC_code='6021'DB:business_master_new
loadtime:0.38575601577759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engleside' limit 1
loadtime:0.38581895828247 / seconds
Query Executed:select id FROM `va` where city='Engleside' && SIC_code='6021'DB:business_master_new
loadtime:0.38624095916748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esmont' limit 1
loadtime:0.38627696037292 / seconds
Query Executed:select id FROM `va` where city='Esmont' && SIC_code='6021'DB:business_master_new
loadtime:0.38681983947754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etlan' limit 1
loadtime:0.38688087463379 / seconds
Query Executed:select id FROM `va` where city='Etlan' && SIC_code='6021'DB:business_master_new
loadtime:0.38722395896912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:0.38727498054504 / seconds
Query Executed:select id FROM `va` where city='Ettrick' && SIC_code='6021'DB:business_master_new
loadtime:0.38753700256348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:0.38756990432739 / seconds
Query Executed:select id FROM `va` where city='Evergreen' && SIC_code='6021'DB:business_master_new
loadtime:0.38795399665833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evington' limit 1
loadtime:0.38806390762329 / seconds
Query Executed:select id FROM `va` where city='Evington' && SIC_code='6021'DB:business_master_new
loadtime:0.38926482200623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewing' limit 1
loadtime:0.38932180404663 / seconds
Query Executed:select id FROM `va` where city='Ewing' && SIC_code='6021'DB:business_master_new
loadtime:0.39029002189636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exmore' limit 1
loadtime:0.39035487174988 / seconds
Query Executed:select id FROM `va` where city='Exmore' && SIC_code='6021'DB:business_master_new
loadtime:0.39157295227051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faber' limit 1
loadtime:0.39162182807922 / seconds
Query Executed:select id FROM `va` where city='Faber' && SIC_code='6021'DB:business_master_new
loadtime:0.39233779907227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.39239096641541 / seconds
Query Executed:select id FROM `va` where city='Fairfax' && SIC_code='6021'DB:business_master_new
loadtime:0.41232085227966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax Station' limit 1
loadtime:0.41257786750793 / seconds
Query Executed:select id FROM `va` where city='Fairfax Station' && SIC_code='6021'DB:business_master_new
loadtime:0.4139997959137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.41405200958252 / seconds
Query Executed:select id FROM `va` where city='Fairfield' && SIC_code='6021'DB:business_master_new
loadtime:0.41525888442993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlawn' limit 1
loadtime:0.41543388366699 / seconds
Query Executed:select id FROM `va` where city='Fairlawn' && SIC_code='6021'DB:business_master_new
loadtime:0.41584587097168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Church' limit 1
loadtime:0.41589999198914 / seconds
Query Executed:select id FROM `va` where city='Falls Church' && SIC_code='6021'DB:business_master_new
loadtime:0.43558096885681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Mills' limit 1
loadtime:0.43565988540649 / seconds
Query Executed:select id FROM `va` where city='Falls Mills' && SIC_code='6021'DB:business_master_new
loadtime:0.43622899055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.43634581565857 / seconds
Query Executed:select id FROM `va` where city='Falmouth' && SIC_code='6021'DB:business_master_new
loadtime:0.4366979598999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fancy Gap' limit 1
loadtime:0.43673801422119 / seconds
Query Executed:select id FROM `va` where city='Fancy Gap' && SIC_code='6021'DB:business_master_new
loadtime:0.43782186508179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:0.43787002563477 / seconds
Query Executed:select id FROM `va` where city='Farmville' && SIC_code='6021'DB:business_master_new
loadtime:0.43951487541199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnham' limit 1
loadtime:0.43958783149719 / seconds
Query Executed:select id FROM `va` where city='Farnham' && SIC_code='6021'DB:business_master_new
loadtime:0.44038081169128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrum' limit 1
loadtime:0.44042682647705 / seconds
Query Executed:select id FROM `va` where city='Ferrum' && SIC_code='6021'DB:business_master_new
loadtime:0.44183897972107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldale' limit 1
loadtime:0.44188189506531 / seconds
Query Executed:select id FROM `va` where city='Fieldale' && SIC_code='6021'DB:business_master_new
loadtime:0.44328188896179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:0.44343400001526 / seconds
Query Executed:select id FROM `va` where city='Fife' && SIC_code='6021'DB:business_master_new
loadtime:0.44379091262817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fincastle' limit 1
loadtime:0.4438328742981 / seconds
Query Executed:select id FROM `va` where city='Fincastle' && SIC_code='6021'DB:business_master_new
loadtime:0.44502687454224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishers Hill' limit 1
loadtime:0.44507598876953 / seconds
Query Executed:select id FROM `va` where city='Fishers Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.44540691375732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishersville' limit 1
loadtime:0.44544792175293 / seconds
Query Executed:select id FROM `va` where city='Fishersville' && SIC_code='6021'DB:business_master_new
loadtime:0.44667887687683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint Hill' limit 1
loadtime:0.44672298431396 / seconds
Query Executed:select id FROM `va` where city='Flint Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.44756102561951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.44761991500854 / seconds
Query Executed:select id FROM `va` where city='Floyd' && SIC_code='6021'DB:business_master_new
loadtime:0.44892501831055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foneswood' limit 1
loadtime:0.44896697998047 / seconds
Query Executed:select id FROM `va` where city='Foneswood' && SIC_code='6021'DB:business_master_new
loadtime:0.44922399520874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:0.44926595687866 / seconds
Query Executed:select id FROM `va` where city='Ford' && SIC_code='6021'DB:business_master_new
loadtime:0.44970798492432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:0.44974493980408 / seconds
Query Executed:select id FROM `va` where city='Forest' && SIC_code='6021'DB:business_master_new
loadtime:0.45134282112122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork Union' limit 1
loadtime:0.45140385627747 / seconds
Query Executed:select id FROM `va` where city='Fork Union' && SIC_code='6021'DB:business_master_new
loadtime:0.45247983932495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Belvoir' limit 1
loadtime:0.45254302024841 / seconds
Query Executed:select id FROM `va` where city='Fort Belvoir' && SIC_code='6021'DB:business_master_new
loadtime:0.45371580123901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Blackmore' limit 1
loadtime:0.45377993583679 / seconds
Query Executed:select id FROM `va` where city='Fort Blackmore' && SIC_code='6021'DB:business_master_new
loadtime:0.45424485206604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:0.45428991317749 / seconds
Query Executed:select id FROM `va` where city='Fort Defiance' && SIC_code='6021'DB:business_master_new
loadtime:0.45489501953125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Eustis' limit 1
loadtime:0.45494389533997 / seconds
Query Executed:select id FROM `va` where city='Fort Eustis' && SIC_code='6021'DB:business_master_new
loadtime:0.45609402656555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:0.45622396469116 / seconds
Query Executed:select id FROM `va` where city='Fort Lee' && SIC_code='6021'DB:business_master_new
loadtime:0.45733690261841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:0.4573860168457 / seconds
Query Executed:select id FROM `va` where city='Fort Mitchell' && SIC_code='6021'DB:business_master_new
loadtime:0.45766496658325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monroe' limit 1
loadtime:0.45770502090454 / seconds
Query Executed:select id FROM `va` where city='Fort Monroe' && SIC_code='6021'DB:business_master_new
loadtime:0.45829200744629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Myer' limit 1
loadtime:0.45834684371948 / seconds
Query Executed:select id FROM `va` where city='Fort Myer' && SIC_code='6021'DB:business_master_new
loadtime:0.45914101600647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Valley' limit 1
loadtime:0.45927691459656 / seconds
Query Executed:select id FROM `va` where city='Fort Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.46021795272827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:0.46036100387573 / seconds
Query Executed:select id FROM `va` where city='Foster' && SIC_code='6021'DB:business_master_new
loadtime:0.46086096763611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.46091198921204 / seconds
Query Executed:select id FROM `va` where city='Franconia' && SIC_code='6021'DB:business_master_new
loadtime:0.46130681037903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.46143388748169 / seconds
Query Executed:select id FROM `va` where city='Franklin' && SIC_code='6021'DB:business_master_new
loadtime:0.46301698684692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:0.46306300163269 / seconds
Query Executed:select id FROM `va` where city='Franktown' && SIC_code='6021'DB:business_master_new
loadtime:0.46354389190674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:0.46358799934387 / seconds
Query Executed:select id FROM `va` where city='Fredericksburg' && SIC_code='6021'DB:business_master_new
loadtime:0.48334789276123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Union' limit 1
loadtime:0.48352694511414 / seconds
Query Executed:select id FROM `va` where city='Free Union' && SIC_code='6021'DB:business_master_new
loadtime:0.48444485664368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.48449897766113 / seconds
Query Executed:select id FROM `va` where city='Freeman' && SIC_code='6021'DB:business_master_new
loadtime:0.48506879806519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fries' limit 1
loadtime:0.48511981964111 / seconds
Query Executed:select id FROM `va` where city='Fries' && SIC_code='6021'DB:business_master_new
loadtime:0.48629784584045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Front Royal' limit 1
loadtime:0.48645901679993 / seconds
Query Executed:select id FROM `va` where city='Front Royal' && SIC_code='6021'DB:business_master_new
loadtime:0.48849081993103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ft Myer' limit 1
loadtime:0.4885528087616 / seconds
Query Executed:select id FROM `va` where city='Ft Myer' && SIC_code='6021'DB:business_master_new
loadtime:0.48886680603027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulks Run' limit 1
loadtime:0.48891687393188 / seconds
Query Executed:select id FROM `va` where city='Fulks Run' && SIC_code='6021'DB:business_master_new
loadtime:0.48974680900574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:0.48979592323303 / seconds
Query Executed:select id FROM `va` where city='Gainesville' && SIC_code='6021'DB:business_master_new
loadtime:0.49122881889343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galax' limit 1
loadtime:0.4913489818573 / seconds
Query Executed:select id FROM `va` where city='Galax' && SIC_code='6021'DB:business_master_new
loadtime:0.493008852005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrisonville' limit 1
loadtime:0.49307179450989 / seconds
Query Executed:select id FROM `va` where city='Garrisonville' && SIC_code='6021'DB:business_master_new
loadtime:0.49371695518494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gasburg' limit 1
loadtime:0.49375987052917 / seconds
Query Executed:select id FROM `va` where city='Gasburg' && SIC_code='6021'DB:business_master_new
loadtime:0.49448394775391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gate City' limit 1
loadtime:0.49454784393311 / seconds
Query Executed:select id FROM `va` where city='Gate City' && SIC_code='6021'DB:business_master_new
loadtime:0.4958348274231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Hill' limit 1
loadtime:0.49587988853455 / seconds
Query Executed:select id FROM `va` where city='Glade Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.4970920085907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Spring' limit 1
loadtime:0.49714398384094 / seconds
Query Executed:select id FROM `va` where city='Glade Spring' && SIC_code='6021'DB:business_master_new
loadtime:0.49837779998779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladehill' limit 1
loadtime:0.49843597412109 / seconds
Query Executed:select id FROM `va` where city='Gladehill' && SIC_code='6021'DB:business_master_new
loadtime:0.49870085716248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:0.49874186515808 / seconds
Query Executed:select id FROM `va` where city='Gladstone' && SIC_code='6021'DB:business_master_new
loadtime:0.49949479103088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladys' limit 1
loadtime:0.49954700469971 / seconds
Query Executed:select id FROM `va` where city='Gladys' && SIC_code='6021'DB:business_master_new
loadtime:0.50066900253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:0.50071787834167 / seconds
Query Executed:select id FROM `va` where city='Glasgow' && SIC_code='6021'DB:business_master_new
loadtime:0.50162386894226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:0.50168299674988 / seconds
Query Executed:select id FROM `va` where city='Glen Allen' && SIC_code='6021'DB:business_master_new
loadtime:0.50414180755615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Lyn' limit 1
loadtime:0.50430798530579 / seconds
Query Executed:select id FROM `va` where city='Glen Lyn' && SIC_code='6021'DB:business_master_new
loadtime:0.50495195388794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Wilton' limit 1
loadtime:0.5050048828125 / seconds
Query Executed:select id FROM `va` where city='Glen Wilton' && SIC_code='6021'DB:business_master_new
loadtime:0.50530695915222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.5053379535675 / seconds
Query Executed:select id FROM `va` where city='Gloucester' && SIC_code='6021'DB:business_master_new
loadtime:0.50696897506714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester Point' limit 1
loadtime:0.50703096389771 / seconds
Query Executed:select id FROM `va` where city='Gloucester Point' && SIC_code='6021'DB:business_master_new
loadtime:0.50818991661072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldbond' limit 1
loadtime:0.50823998451233 / seconds
Query Executed:select id FROM `va` where city='Goldbond' && SIC_code='6021'DB:business_master_new
loadtime:0.50849986076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldvein' limit 1
loadtime:0.50855088233948 / seconds
Query Executed:select id FROM `va` where city='Goldvein' && SIC_code='6021'DB:business_master_new
loadtime:0.509192943573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goochland' limit 1
loadtime:0.50932502746582 / seconds
Query Executed:select id FROM `va` where city='Goochland' && SIC_code='6021'DB:business_master_new
loadtime:0.51058197021484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goode' limit 1
loadtime:0.51063084602356 / seconds
Query Executed:select id FROM `va` where city='Goode' && SIC_code='6021'DB:business_master_new
loadtime:0.51182699203491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodview' limit 1
loadtime:0.51187801361084 / seconds
Query Executed:select id FROM `va` where city='Goodview' && SIC_code='6021'DB:business_master_new
loadtime:0.51314496994019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordonsville' limit 1
loadtime:0.51327681541443 / seconds
Query Executed:select id FROM `va` where city='Gordonsville' && SIC_code='6021'DB:business_master_new
loadtime:0.5145628452301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore' limit 1
loadtime:0.51461386680603 / seconds
Query Executed:select id FROM `va` where city='Gore' && SIC_code='6021'DB:business_master_new
loadtime:0.51557087898254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.51562190055847 / seconds
Query Executed:select id FROM `va` where city='Goshen' && SIC_code='6021'DB:business_master_new
loadtime:0.51622200012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.51627087593079 / seconds
Query Executed:select id FROM `va` where city='Grafton' && SIC_code='6021'DB:business_master_new
loadtime:0.51669096946716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graves Mill' limit 1
loadtime:0.51672887802124 / seconds
Query Executed:select id FROM `va` where city='Graves Mill' && SIC_code='6021'DB:business_master_new
loadtime:0.51703381538391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:0.51707696914673 / seconds
Query Executed:select id FROM `va` where city='Great Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.51870393753052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:0.51876282691956 / seconds
Query Executed:select id FROM `va` where city='Green Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.51929593086243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbackville' limit 1
loadtime:0.51934194564819 / seconds
Query Executed:select id FROM `va` where city='Greenbackville' && SIC_code='6021'DB:business_master_new
loadtime:0.51986384391785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:0.51998996734619 / seconds
Query Executed:select id FROM `va` where city='Greenbush' && SIC_code='6021'DB:business_master_new
loadtime:0.52045583724976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.52049398422241 / seconds
Query Executed:select id FROM `va` where city='Greenville' && SIC_code='6021'DB:business_master_new
loadtime:0.52132201194763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenway' limit 1
loadtime:0.52137184143066 / seconds
Query Executed:select id FROM `va` where city='Greenway' && SIC_code='6021'DB:business_master_new
loadtime:0.52167987823486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.52172088623047 / seconds
Query Executed:select id FROM `va` where city='Greenwood' && SIC_code='6021'DB:business_master_new
loadtime:0.52226495742798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gretna' limit 1
loadtime:0.52231287956238 / seconds
Query Executed:select id FROM `va` where city='Gretna' && SIC_code='6021'DB:business_master_new
loadtime:0.52357602119446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimstead' limit 1
loadtime:0.52363801002502 / seconds
Query Executed:select id FROM `va` where city='Grimstead' && SIC_code='6021'DB:business_master_new
loadtime:0.52402186393738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grottoes' limit 1
loadtime:0.52411890029907 / seconds
Query Executed:select id FROM `va` where city='Grottoes' && SIC_code='6021'DB:business_master_new
loadtime:0.52532291412354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy' limit 1
loadtime:0.52537989616394 / seconds
Query Executed:select id FROM `va` where city='Grundy' && SIC_code='6021'DB:business_master_new
loadtime:0.52669095993042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gum Spring' limit 1
loadtime:0.52673697471619 / seconds
Query Executed:select id FROM `va` where city='Gum Spring' && SIC_code='6021'DB:business_master_new
loadtime:0.527508020401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwynn' limit 1
loadtime:0.52757501602173 / seconds
Query Executed:select id FROM `va` where city='Gwynn' && SIC_code='6021'DB:business_master_new
loadtime:0.52800297737122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacksneck' limit 1
loadtime:0.52811598777771 / seconds
Query Executed:select id FROM `va` where city='Hacksneck' && SIC_code='6021'DB:business_master_new
loadtime:0.52850198745728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadensville' limit 1
loadtime:0.52855801582336 / seconds
Query Executed:select id FROM `va` where city='Hadensville' && SIC_code='6021'DB:business_master_new
loadtime:0.528892993927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hague' limit 1
loadtime:0.52899885177612 / seconds
Query Executed:select id FROM `va` where city='Hague' && SIC_code='6021'DB:business_master_new
loadtime:0.5299289226532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.53006291389465 / seconds
Query Executed:select id FROM `va` where city='Halifax' && SIC_code='6021'DB:business_master_new
loadtime:0.53142094612122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallieford' limit 1
loadtime:0.5314769744873 / seconds
Query Executed:select id FROM `va` where city='Hallieford' && SIC_code='6021'DB:business_master_new
loadtime:0.53182888031006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallwood' limit 1
loadtime:0.5318717956543 / seconds
Query Executed:select id FROM `va` where city='Hallwood' && SIC_code='6021'DB:business_master_new
loadtime:0.53233480453491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.53239393234253 / seconds
Query Executed:select id FROM `va` where city='Hamilton' && SIC_code='6021'DB:business_master_new
loadtime:0.53354287147522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden Sydney' limit 1
loadtime:0.53360199928284 / seconds
Query Executed:select id FROM `va` where city='Hampden Sydney' && SIC_code='6021'DB:business_master_new
loadtime:0.53406190872192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.5341968536377 / seconds
Query Executed:select id FROM `va` where city='Hampton' && SIC_code='6021'DB:business_master_new
loadtime:0.55399680137634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.55406785011292 / seconds
Query Executed:select id FROM `va` where city='Hanover' && SIC_code='6021'DB:business_master_new
loadtime:0.55532789230347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harborton' limit 1
loadtime:0.55539488792419 / seconds
Query Executed:select id FROM `va` where city='Harborton' && SIC_code='6021'DB:business_master_new
loadtime:0.55576086044312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:0.55580496788025 / seconds
Query Executed:select id FROM `va` where city='Hardy' && SIC_code='6021'DB:business_master_new
loadtime:0.55701994895935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardyville' limit 1
loadtime:0.55707001686096 / seconds
Query Executed:select id FROM `va` where city='Hardyville' && SIC_code='6021'DB:business_master_new
loadtime:0.55748081207275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:0.55753397941589 / seconds
Query Executed:select id FROM `va` where city='Harman' && SIC_code='6021'DB:business_master_new
loadtime:0.5578498840332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonburg' limit 1
loadtime:0.55790090560913 / seconds
Query Executed:select id FROM `va` where city='Harrisonburg' && SIC_code='6021'DB:business_master_new
loadtime:0.56075382232666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartfield' limit 1
loadtime:0.5608229637146 / seconds
Query Executed:select id FROM `va` where city='Hartfield' && SIC_code='6021'DB:business_master_new
loadtime:0.56185102462769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwood' limit 1
loadtime:0.5619068145752 / seconds
Query Executed:select id FROM `va` where city='Hartwood' && SIC_code='6021'DB:business_master_new
loadtime:0.56250286102295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.56255698204041 / seconds
Query Executed:select id FROM `va` where city='Hayes' && SIC_code='6021'DB:business_master_new
loadtime:0.56389784812927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haymarket' limit 1
loadtime:0.56395792961121 / seconds
Query Executed:select id FROM `va` where city='Haymarket' && SIC_code='6021'DB:business_master_new
loadtime:0.56531190872192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haynesville' limit 1
loadtime:0.56535482406616 / seconds
Query Executed:select id FROM `va` where city='Haynesville' && SIC_code='6021'DB:business_master_new
loadtime:0.56581592559814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysi' limit 1
loadtime:0.56586480140686 / seconds
Query Executed:select id FROM `va` where city='Haysi' && SIC_code='6021'DB:business_master_new
loadtime:0.56723880767822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:0.56728887557983 / seconds
Query Executed:select id FROM `va` where city='Haywood' && SIC_code='6021'DB:business_master_new
loadtime:0.56761193275452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Head Waters' limit 1
loadtime:0.56765985488892 / seconds
Query Executed:select id FROM `va` where city='Head Waters' && SIC_code='6021'DB:business_master_new
loadtime:0.56800699234009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heathsville' limit 1
loadtime:0.56805300712585 / seconds
Query Executed:select id FROM `va` where city='Heathsville' && SIC_code='6021'DB:business_master_new
loadtime:0.56926488876343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.56932401657104 / seconds
Query Executed:select id FROM `va` where city='Henry' && SIC_code='6021'DB:business_master_new
loadtime:0.57015895843506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:0.57027983665466 / seconds
Query Executed:select id FROM `va` where city='Herndon' && SIC_code='6021'DB:business_master_new
loadtime:0.57331800460815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Springs' limit 1
loadtime:0.57338786125183 / seconds
Query Executed:select id FROM `va` where city='Highland Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.57371783256531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightown' limit 1
loadtime:0.57374596595764 / seconds
Query Executed:select id FROM `va` where city='Hightown' && SIC_code='6021'DB:business_master_new
loadtime:0.57399702072144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsville' limit 1
loadtime:0.5740818977356 / seconds
Query Executed:select id FROM `va` where city='Hillsville' && SIC_code='6021'DB:business_master_new
loadtime:0.57553601264954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiltons' limit 1
loadtime:0.5755889415741 / seconds
Query Executed:select id FROM `va` where city='Hiltons' && SIC_code='6021'DB:business_master_new
loadtime:0.57613587379456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:0.57627701759338 / seconds
Query Executed:select id FROM `va` where city='Hinton' && SIC_code='6021'DB:business_master_new
loadtime:0.57693481445312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiwassee' limit 1
loadtime:0.57698082923889 / seconds
Query Executed:select id FROM `va` where city='Hiwassee' && SIC_code='6021'DB:business_master_new
loadtime:0.57761597633362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:0.57766199111938 / seconds
Query Executed:select id FROM `va` where city='Hollins' && SIC_code='6021'DB:business_master_new
loadtime:0.57791900634766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaker' limit 1
loadtime:0.57798886299133 / seconds
Query Executed:select id FROM `va` where city='Honaker' && SIC_code='6021'DB:business_master_new
loadtime:0.5791928768158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood' limit 1
loadtime:0.57925200462341 / seconds
Query Executed:select id FROM `va` where city='Hood' && SIC_code='6021'DB:business_master_new
loadtime:0.57958579063416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:0.57962679862976 / seconds
Query Executed:select id FROM `va` where city='Hopewell' && SIC_code='6021'DB:business_master_new
loadtime:0.5812029838562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horntown' limit 1
loadtime:0.58124899864197 / seconds
Query Executed:select id FROM `va` where city='Horntown' && SIC_code='6021'DB:business_master_new
loadtime:0.58165097236633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horsepen' limit 1
loadtime:0.58169198036194 / seconds
Query Executed:select id FROM `va` where city='Horsepen' && SIC_code='6021'DB:business_master_new
loadtime:0.58192682266235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.58199191093445 / seconds
Query Executed:select id FROM `va` where city='Hot Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.58322882652283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howardsville' limit 1
loadtime:0.58329486846924 / seconds
Query Executed:select id FROM `va` where city='Howardsville' && SIC_code='6021'DB:business_master_new
loadtime:0.58363389968872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howertons' limit 1
loadtime:0.58366584777832 / seconds
Query Executed:select id FROM `va` where city='Howertons' && SIC_code='6021'DB:business_master_new
loadtime:0.58391690254211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huddleston' limit 1
loadtime:0.58401679992676 / seconds
Query Executed:select id FROM `va` where city='Huddleston' && SIC_code='6021'DB:business_master_new
loadtime:0.58519887924194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudgins' limit 1
loadtime:0.58525800704956 / seconds
Query Executed:select id FROM `va` where city='Hudgins' && SIC_code='6021'DB:business_master_new
loadtime:0.58581781387329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hume' limit 1
loadtime:0.5858678817749 / seconds
Query Executed:select id FROM `va` where city='Hume' && SIC_code='6021'DB:business_master_new
loadtime:0.58648681640625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntly' limit 1
loadtime:0.58654093742371 / seconds
Query Executed:select id FROM `va` where city='Huntly' && SIC_code='6021'DB:business_master_new
loadtime:0.58698081970215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.58703184127808 / seconds
Query Executed:select id FROM `va` where city='Hurley' && SIC_code='6021'DB:business_master_new
loadtime:0.58786702156067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurt' limit 1
loadtime:0.58796286582947 / seconds
Query Executed:select id FROM `va` where city='Hurt' && SIC_code='6021'DB:business_master_new
loadtime:0.58914995193481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustle' limit 1
loadtime:0.5892288684845 / seconds
Query Executed:select id FROM `va` where city='Hustle' && SIC_code='6021'DB:business_master_new
loadtime:0.58955979347229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.58960199356079 / seconds
Query Executed:select id FROM `va` where city='Independence' && SIC_code='6021'DB:business_master_new
loadtime:0.59076189994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Valley' limit 1
loadtime:0.59093999862671 / seconds
Query Executed:select id FROM `va` where city='Indian Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.59131598472595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Gate' limit 1
loadtime:0.59135985374451 / seconds
Query Executed:select id FROM `va` where city='Iron Gate' && SIC_code='6021'DB:business_master_new
loadtime:0.59173798561096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironto' limit 1
loadtime:0.5917809009552 / seconds
Query Executed:select id FROM `va` where city='Ironto' && SIC_code='6021'DB:business_master_new
loadtime:0.59217500686646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:0.59229588508606 / seconds
Query Executed:select id FROM `va` where city='Irvington' && SIC_code='6021'DB:business_master_new
loadtime:0.59351396560669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Wight' limit 1
loadtime:0.59356999397278 / seconds
Query Executed:select id FROM `va` where city='Isle Of Wight' && SIC_code='6021'DB:business_master_new
loadtime:0.5941698551178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:0.59430694580078 / seconds
Query Executed:select id FROM `va` where city='Ivanhoe' && SIC_code='6021'DB:business_master_new
loadtime:0.59491896629333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivor' limit 1
loadtime:0.59496784210205 / seconds
Query Executed:select id FROM `va` where city='Ivor' && SIC_code='6021'DB:business_master_new
loadtime:0.59606099128723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivy' limit 1
loadtime:0.59621787071228 / seconds
Query Executed:select id FROM `va` where city='Ivy' && SIC_code='6021'DB:business_master_new
loadtime:0.59710597991943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.59725093841553 / seconds
Query Executed:select id FROM `va` where city='Jamaica' && SIC_code='6021'DB:business_master_new
loadtime:0.59768581390381 / seconds
Query loaded from cache:select * from geodata_geocity where city='James Store' limit 1
loadtime:0.59771299362183 / seconds
Query Executed:select id FROM `va` where city='James Store' && SIC_code='6021'DB:business_master_new
loadtime:0.59795594215393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.59799599647522 / seconds
Query Executed:select id FROM `va` where city='Jamestown' && SIC_code='6021'DB:business_master_new
loadtime:0.59824395179749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:0.59827780723572 / seconds
Query Executed:select id FROM `va` where city='Jamesville' && SIC_code='6021'DB:business_master_new
loadtime:0.59857201576233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarratt' limit 1
loadtime:0.59859681129456 / seconds
Query Executed:select id FROM `va` where city='Jarratt' && SIC_code='6021'DB:business_master_new
loadtime:0.59970283508301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.59976196289062 / seconds
Query Executed:select id FROM `va` where city='Java' && SIC_code='6021'DB:business_master_new
loadtime:0.60035085678101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonton' limit 1
loadtime:0.60038685798645 / seconds
Query Executed:select id FROM `va` where city='Jeffersonton' && SIC_code='6021'DB:business_master_new
loadtime:0.60122799873352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkins Bridge' limit 1
loadtime:0.60127592086792 / seconds
Query Executed:select id FROM `va` where city='Jenkins Bridge' && SIC_code='6021'DB:business_master_new
loadtime:0.60154700279236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey' limit 1
loadtime:0.6015739440918 / seconds
Query Executed:select id FROM `va` where city='Jersey' && SIC_code='6021'DB:business_master_new
loadtime:0.60189390182495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetersville' limit 1
loadtime:0.60194802284241 / seconds
Query Executed:select id FROM `va` where city='Jetersville' && SIC_code='6021'DB:business_master_new
loadtime:0.60286784172058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell Ridge' limit 1
loadtime:0.60298490524292 / seconds
Query Executed:select id FROM `va` where city='Jewell Ridge' && SIC_code='6021'DB:business_master_new
loadtime:0.60335493087769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.60339188575745 / seconds
Query Executed:select id FROM `va` where city='Jonesville' && SIC_code='6021'DB:business_master_new
loadtime:0.60457587242126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keeling' limit 1
loadtime:0.60461902618408 / seconds
Query Executed:select id FROM `va` where city='Keeling' && SIC_code='6021'DB:business_master_new
loadtime:0.60522484779358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keen Mountain' limit 1
loadtime:0.60535979270935 / seconds
Query Executed:select id FROM `va` where city='Keen Mountain' && SIC_code='6021'DB:business_master_new
loadtime:0.6059308052063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:0.60598087310791 / seconds
Query Executed:select id FROM `va` where city='Keene' && SIC_code='6021'DB:business_master_new
loadtime:0.60639595985413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keezletown' limit 1
loadtime:0.60642290115356 / seconds
Query Executed:select id FROM `va` where city='Keezletown' && SIC_code='6021'DB:business_master_new
loadtime:0.60715293884277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:0.6072850227356 / seconds
Query Executed:select id FROM `va` where city='Keller' && SIC_code='6021'DB:business_master_new
loadtime:0.60787582397461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenbridge' limit 1
loadtime:0.60792589187622 / seconds
Query Executed:select id FROM `va` where city='Kenbridge' && SIC_code='6021'DB:business_master_new
loadtime:0.60915184020996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kents Store' limit 1
loadtime:0.60928893089294 / seconds
Query Executed:select id FROM `va` where city='Kents Store' && SIC_code='6021'DB:business_master_new
loadtime:0.61002397537231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokee' limit 1
loadtime:0.61007285118103 / seconds
Query Executed:select id FROM `va` where city='Keokee' && SIC_code='6021'DB:business_master_new
loadtime:0.61049580574036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:0.61053991317749 / seconds
Query Executed:select id FROM `va` where city='Keswick' && SIC_code='6021'DB:business_master_new
loadtime:0.61169791221619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keysville' limit 1
loadtime:0.61174702644348 / seconds
Query Executed:select id FROM `va` where city='Keysville' && SIC_code='6021'DB:business_master_new
loadtime:0.61298584938049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmarnock' limit 1
loadtime:0.61314082145691 / seconds
Query Executed:select id FROM `va` where city='Kilmarnock' && SIC_code='6021'DB:business_master_new
loadtime:0.61456179618835 / seconds
Query loaded from cache:select * from geodata_geocity where city='King & Queen C H' limit 1
loadtime:0.61461281776428 / seconds
Query Executed:select id FROM `va` where city='King & Queen C H' && SIC_code='6021'DB:business_master_new
loadtime:0.61497282981873 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court Hous' limit 1
loadtime:0.61511087417603 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court Hous' && SIC_code='6021'DB:business_master_new
loadtime:0.61544179916382 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court House' limit 1
loadtime:0.61546993255615 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court House' && SIC_code='6021'DB:business_master_new
loadtime:0.61615896224976 / seconds
Query loaded from cache:select * from geodata_geocity where city='King George' limit 1
loadtime:0.61629486083984 / seconds
Query Executed:select id FROM `va` where city='King George' && SIC_code='6021'DB:business_master_new
loadtime:0.61778879165649 / seconds
Query loaded from cache:select * from geodata_geocity where city='King William' limit 1
loadtime:0.61783885955811 / seconds
Query Executed:select id FROM `va` where city='King William' && SIC_code='6021'DB:business_master_new
loadtime:0.61900687217712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsale' limit 1
loadtime:0.61906480789185 / seconds
Query Executed:select id FROM `va` where city='Kinsale' && SIC_code='6021'DB:business_master_new
loadtime:0.61980795860291 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:0.61986184120178 / seconds
Query Executed:select id FROM `va` where city='La Crosse' && SIC_code='6021'DB:business_master_new
loadtime:0.62104797363281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey Spring' limit 1
loadtime:0.62114286422729 / seconds
Query Executed:select id FROM `va` where city='Lacey Spring' && SIC_code='6021'DB:business_master_new
loadtime:0.62157893180847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lackey' limit 1
loadtime:0.62162089347839 / seconds
Query Executed:select id FROM `va` where city='Lackey' && SIC_code='6021'DB:business_master_new
loadtime:0.62205386161804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:0.62217688560486 / seconds
Query Executed:select id FROM `va` where city='Ladysmith' && SIC_code='6021'DB:business_master_new
loadtime:0.62303400039673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:0.62313580513 / seconds
Query Executed:select id FROM `va` where city='Lafayette' && SIC_code='6021'DB:business_master_new
loadtime:0.62339496612549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambsburg' limit 1
loadtime:0.62343001365662 / seconds
Query Executed:select id FROM `va` where city='Lambsburg' && SIC_code='6021'DB:business_master_new
loadtime:0.62384986877441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.62389588356018 / seconds
Query Executed:select id FROM `va` where city='Lancaster' && SIC_code='6021'DB:business_master_new
loadtime:0.62504482269287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laneview' limit 1
loadtime:0.625079870224 / seconds
Query Executed:select id FROM `va` where city='Laneview' && SIC_code='6021'DB:business_master_new
loadtime:0.6254768371582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanexa' limit 1
loadtime:0.62553191184998 / seconds
Query Executed:select id FROM `va` where city='Lanexa' && SIC_code='6021'DB:business_master_new
loadtime:0.62662696838379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley Afb' limit 1
loadtime:0.62667083740234 / seconds
Query Executed:select id FROM `va` where city='Langley Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.62704992294312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Fork' limit 1
loadtime:0.6271059513092 / seconds
Query Executed:select id FROM `va` where city='Laurel Fork' && SIC_code='6021'DB:business_master_new
loadtime:0.62765192985535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:0.62769079208374 / seconds
Query Executed:select id FROM `va` where city='Lawrenceville' && SIC_code='6021'DB:business_master_new
loadtime:0.62897181510925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.62902998924255 / seconds
Query Executed:select id FROM `va` where city='Lebanon' && SIC_code='6021'DB:business_master_new
loadtime:0.63041090965271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon Church' limit 1
loadtime:0.63045597076416 / seconds
Query Executed:select id FROM `va` where city='Lebanon Church' && SIC_code='6021'DB:business_master_new
loadtime:0.63071298599243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:0.6307590007782 / seconds
Query Executed:select id FROM `va` where city='Leesburg' && SIC_code='6021'DB:business_master_new
loadtime:0.63342189788818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:0.63349485397339 / seconds
Query Executed:select id FROM `va` where city='Leon' && SIC_code='6021'DB:business_master_new
loadtime:0.63389182090759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.63393998146057 / seconds
Query Executed:select id FROM `va` where city='Lexington' && SIC_code='6021'DB:business_master_new
loadtime:0.63563895225525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lightfoot' limit 1
loadtime:0.63570189476013 / seconds
Query Executed:select id FROM `va` where city='Lightfoot' && SIC_code='6021'DB:business_master_new
loadtime:0.6364438533783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lignum' limit 1
loadtime:0.63648796081543 / seconds
Query Executed:select id FROM `va` where city='Lignum' && SIC_code='6021'DB:business_master_new
loadtime:0.63698196411133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.63703083992004 / seconds
Query Executed:select id FROM `va` where city='Lincoln' && SIC_code='6021'DB:business_master_new
loadtime:0.63748097419739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:0.6375298500061 / seconds
Query Executed:select id FROM `va` where city='Linden' && SIC_code='6021'DB:business_master_new
loadtime:0.63875794410706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:0.6388099193573 / seconds
Query Executed:select id FROM `va` where city='Linville' && SIC_code='6021'DB:business_master_new
loadtime:0.63955497741699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Plymouth' limit 1
loadtime:0.6395959854126 / seconds
Query Executed:select id FROM `va` where city='Little Plymouth' && SIC_code='6021'DB:business_master_new
loadtime:0.63996887207031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lively' limit 1
loadtime:0.64001798629761 / seconds
Query Executed:select id FROM `va` where city='Lively' && SIC_code='6021'DB:business_master_new
loadtime:0.64065098762512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Dale' limit 1
loadtime:0.64069080352783 / seconds
Query Executed:select id FROM `va` where city='Locust Dale' && SIC_code='6021'DB:business_master_new
loadtime:0.64105987548828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Grove' limit 1
loadtime:0.64114594459534 / seconds
Query Executed:select id FROM `va` where city='Locust Grove' && SIC_code='6021'DB:business_master_new
loadtime:0.64248180389404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Hill' limit 1
loadtime:0.64254689216614 / seconds
Query Executed:select id FROM `va` where city='Locust Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.64315390586853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locustville' limit 1
loadtime:0.64329600334167 / seconds
Query Executed:select id FROM `va` where city='Locustville' && SIC_code='6021'DB:business_master_new
loadtime:0.6437349319458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:0.64377284049988 / seconds
Query Executed:select id FROM `va` where city='Long Island' && SIC_code='6021'DB:business_master_new
loadtime:0.64429402351379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:0.64434194564819 / seconds
Query Executed:select id FROM `va` where city='Loretto' && SIC_code='6021'DB:business_master_new
loadtime:0.64464282989502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorton' limit 1
loadtime:0.64467096328735 / seconds
Query Executed:select id FROM `va` where city='Lorton' && SIC_code='6021'DB:business_master_new
loadtime:0.64637780189514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lottsburg' limit 1
loadtime:0.64643597602844 / seconds
Query Executed:select id FROM `va` where city='Lottsburg' && SIC_code='6021'DB:business_master_new
loadtime:0.64744901657104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisa' limit 1
loadtime:0.64748597145081 / seconds
Query Executed:select id FROM `va` where city='Louisa' && SIC_code='6021'DB:business_master_new
loadtime:0.64883399009705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovettsville' limit 1
loadtime:0.64889693260193 / seconds
Query Executed:select id FROM `va` where city='Lovettsville' && SIC_code='6021'DB:business_master_new
loadtime:0.65017199516296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovingston' limit 1
loadtime:0.65023684501648 / seconds
Query Executed:select id FROM `va` where city='Lovingston' && SIC_code='6021'DB:business_master_new
loadtime:0.65141582489014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:0.65148091316223 / seconds
Query Executed:select id FROM `va` where city='Low Moor' && SIC_code='6021'DB:business_master_new
loadtime:0.65216183662415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowesville' limit 1
loadtime:0.65219688415527 / seconds
Query Executed:select id FROM `va` where city='Lowesville' && SIC_code='6021'DB:business_master_new
loadtime:0.65249180793762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowmoor' limit 1
loadtime:0.65254592895508 / seconds
Query Executed:select id FROM `va` where city='Lowmoor' && SIC_code='6021'DB:business_master_new
loadtime:0.65279793739319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.65283179283142 / seconds
Query Executed:select id FROM `va` where city='Lowry' && SIC_code='6021'DB:business_master_new
loadtime:0.65318894386292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.65332984924316 / seconds
Query Executed:select id FROM `va` where city='Lunenburg' && SIC_code='6021'DB:business_master_new
loadtime:0.65396094322205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:0.65401101112366 / seconds
Query Executed:select id FROM `va` where city='Luray' && SIC_code='6021'DB:business_master_new
loadtime:0.65553283691406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynch Station' limit 1
loadtime:0.65558481216431 / seconds
Query Executed:select id FROM `va` where city='Lynch Station' && SIC_code='6021'DB:business_master_new
loadtime:0.65636682510376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:0.65641689300537 / seconds
Query Executed:select id FROM `va` where city='Lynchburg' && SIC_code='6021'DB:business_master_new
loadtime:0.67627882957458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:0.67636394500732 / seconds
Query Executed:select id FROM `va` where city='Lyndhurst' && SIC_code='6021'DB:business_master_new
loadtime:0.67732191085815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Machipongo' limit 1
loadtime:0.67746090888977 / seconds
Query Executed:select id FROM `va` where city='Machipongo' && SIC_code='6021'DB:business_master_new
loadtime:0.67814087867737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:0.6781919002533 / seconds
Query Executed:select id FROM `va` where city='Macon' && SIC_code='6021'DB:business_master_new
loadtime:0.67853188514709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.67856001853943 / seconds
Query Executed:select id FROM `va` where city='Madison' && SIC_code='6021'DB:business_master_new
loadtime:0.6798198223114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:0.67986989021301 / seconds
Query Executed:select id FROM `va` where city='Madison Heights' && SIC_code='6021'DB:business_master_new
loadtime:0.68134689331055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Mills' limit 1
loadtime:0.68151497840881 / seconds
Query Executed:select id FROM `va` where city='Madison Mills' && SIC_code='6021'DB:business_master_new
loadtime:0.68189787864685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidens' limit 1
loadtime:0.68193984031677 / seconds
Query Executed:select id FROM `va` where city='Maidens' && SIC_code='6021'DB:business_master_new
loadtime:0.68292498588562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manakin Sabot' limit 1
loadtime:0.68297386169434 / seconds
Query Executed:select id FROM `va` where city='Manakin Sabot' && SIC_code='6021'DB:business_master_new
loadtime:0.68419480323792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas' limit 1
loadtime:0.68424797058105 / seconds
Query Executed:select id FROM `va` where city='Manassas' && SIC_code='6021'DB:business_master_new
loadtime:0.70393180847168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas Park' limit 1
loadtime:0.70400595664978 / seconds
Query Executed:select id FROM `va` where city='Manassas Park' && SIC_code='6021'DB:business_master_new
loadtime:0.70435690879822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mangohick' limit 1
loadtime:0.70440483093262 / seconds
Query Executed:select id FROM `va` where city='Mangohick' && SIC_code='6021'DB:business_master_new
loadtime:0.70467281341553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannboro' limit 1
loadtime:0.70469999313354 / seconds
Query Executed:select id FROM `va` where city='Mannboro' && SIC_code='6021'DB:business_master_new
loadtime:0.70501279830933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manquin' limit 1
loadtime:0.70506501197815 / seconds
Query Executed:select id FROM `va` where city='Manquin' && SIC_code='6021'DB:business_master_new
loadtime:0.70574498176575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mappsville' limit 1
loadtime:0.70578098297119 / seconds
Query Executed:select id FROM `va` where city='Mappsville' && SIC_code='6021'DB:business_master_new
loadtime:0.70623302459717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.70628380775452 / seconds
Query Executed:select id FROM `va` where city='Marion' && SIC_code='6021'DB:business_master_new
loadtime:0.70779991149902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marionville' limit 1
loadtime:0.70785784721375 / seconds
Query Executed:select id FROM `va` where city='Marionville' && SIC_code='6021'DB:business_master_new
loadtime:0.70822882652283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markham' limit 1
loadtime:0.70836400985718 / seconds
Query Executed:select id FROM `va` where city='Markham' && SIC_code='6021'DB:business_master_new
loadtime:0.7089478969574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:0.70899391174316 / seconds
Query Executed:select id FROM `va` where city='Marshall' && SIC_code='6021'DB:business_master_new
loadtime:0.71029591560364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:0.71035480499268 / seconds
Query Executed:select id FROM `va` where city='Martinsville' && SIC_code='6021'DB:business_master_new
loadtime:0.71256995201111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maryus' limit 1
loadtime:0.71262884140015 / seconds
Query Executed:select id FROM `va` where city='Maryus' && SIC_code='6021'DB:business_master_new
loadtime:0.71295595169067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mascot' limit 1
loadtime:0.71301102638245 / seconds
Query Executed:select id FROM `va` where city='Mascot' && SIC_code='6021'DB:business_master_new
loadtime:0.71328186988831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massies Mill' limit 1
loadtime:0.71331787109375 / seconds
Query Executed:select id FROM `va` where city='Massies Mill' && SIC_code='6021'DB:business_master_new
loadtime:0.71359300613403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:0.71362900733948 / seconds
Query Executed:select id FROM `va` where city='Mathews' && SIC_code='6021'DB:business_master_new
loadtime:0.71484780311584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattaponi' limit 1
loadtime:0.71491098403931 / seconds
Query Executed:select id FROM `va` where city='Mattaponi' && SIC_code='6021'DB:business_master_new
loadtime:0.71551179885864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurertown' limit 1
loadtime:0.71558380126953 / seconds
Query Executed:select id FROM `va` where city='Maurertown' && SIC_code='6021'DB:business_master_new
loadtime:0.7165629863739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mavisdale' limit 1
loadtime:0.71660494804382 / seconds
Query Executed:select id FROM `va` where city='Mavisdale' && SIC_code='6021'DB:business_master_new
loadtime:0.71694993972778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Max Meadows' limit 1
loadtime:0.71699786186218 / seconds
Query Executed:select id FROM `va` where city='Max Meadows' && SIC_code='6021'DB:business_master_new
loadtime:0.71819496154785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxie' limit 1
loadtime:0.71823883056641 / seconds
Query Executed:select id FROM `va` where city='Maxie' && SIC_code='6021'DB:business_master_new
loadtime:0.71862483024597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clure' limit 1
loadtime:0.71866893768311 / seconds
Query Executed:select id FROM `va` where city='Mc Clure' && SIC_code='6021'DB:business_master_new
loadtime:0.71904397010803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:0.71908497810364 / seconds
Query Executed:select id FROM `va` where city='Mc Coy' && SIC_code='6021'DB:business_master_new
loadtime:0.71942186355591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Dowell' limit 1
loadtime:0.71946382522583 / seconds
Query Executed:select id FROM `va` where city='Mc Dowell' && SIC_code='6021'DB:business_master_new
loadtime:0.72011089324951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gaheysville' limit 1
loadtime:0.7202479839325 / seconds
Query Executed:select id FROM `va` where city='Mc Gaheysville' && SIC_code='6021'DB:business_master_new
loadtime:0.72170186042786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenney' limit 1
loadtime:0.72173690795898 / seconds
Query Executed:select id FROM `va` where city='Mc Kenney' && SIC_code='6021'DB:business_master_new
loadtime:0.72281384468079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lean' limit 1
loadtime:0.72288179397583 / seconds
Query Executed:select id FROM `va` where city='Mc Lean' && SIC_code='6021'DB:business_master_new
loadtime:0.72639393806458 / seconds
Query Executed:select * from geodata_geocity where city='Mckenney' limit 1DB:business_master_new
loadtime:0.72674584388733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mclean' limit 1
loadtime:0.72678184509277 / seconds
Query Executed:select id FROM `va` where city='Mclean' && SIC_code='6021'DB:business_master_new
loadtime:0.72743487358093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows Of Dan' limit 1
loadtime:0.72748994827271 / seconds
Query Executed:select id FROM `va` where city='Meadows Of Dan' && SIC_code='6021'DB:business_master_new
loadtime:0.72854685783386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowview' limit 1
loadtime:0.72859597206116 / seconds
Query Executed:select id FROM `va` where city='Meadowview' && SIC_code='6021'DB:business_master_new
loadtime:0.7302188873291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:0.73037195205688 / seconds
Query Executed:select id FROM `va` where city='Mears' && SIC_code='6021'DB:business_master_new
loadtime:0.73080801963806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:0.73084282875061 / seconds
Query Executed:select id FROM `va` where city='Mechanicsville' && SIC_code='6021'DB:business_master_new
loadtime:0.73330783843994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meherrin' limit 1
loadtime:0.7334988117218 / seconds
Query Executed:select id FROM `va` where city='Meherrin' && SIC_code='6021'DB:business_master_new
loadtime:0.73424291610718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melfa' limit 1
loadtime:0.73438382148743 / seconds
Query Executed:select id FROM `va` where city='Melfa' && SIC_code='6021'DB:business_master_new
loadtime:0.73566198348999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendota' limit 1
loadtime:0.73570990562439 / seconds
Query Executed:select id FROM `va` where city='Mendota' && SIC_code='6021'DB:business_master_new
loadtime:0.73615789413452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredithville' limit 1
loadtime:0.73628902435303 / seconds
Query Executed:select id FROM `va` where city='Meredithville' && SIC_code='6021'DB:business_master_new
loadtime:0.73663187026978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrifield' limit 1
loadtime:0.73666596412659 / seconds
Query Executed:select id FROM `va` where city='Merrifield' && SIC_code='6021'DB:business_master_new
loadtime:0.73775100708008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Point' limit 1
loadtime:0.73780083656311 / seconds
Query Executed:select id FROM `va` where city='Merry Point' && SIC_code='6021'DB:business_master_new
loadtime:0.73815298080444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebrook' limit 1
loadtime:0.73826289176941 / seconds
Query Executed:select id FROM `va` where city='Middlebrook' && SIC_code='6021'DB:business_master_new
loadtime:0.73893785476685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:0.73898696899414 / seconds
Query Executed:select id FROM `va` where city='Middleburg' && SIC_code='6021'DB:business_master_new
loadtime:0.74031686782837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.74037384986877 / seconds
Query Executed:select id FROM `va` where city='Middletown' && SIC_code='6021'DB:business_master_new
loadtime:0.741534948349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.7415919303894 / seconds
Query Executed:select id FROM `va` where city='Midland' && SIC_code='6021'DB:business_master_new
loadtime:0.74266600608826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midlothian' limit 1
loadtime:0.74271702766418 / seconds
Query Executed:select id FROM `va` where city='Midlothian' && SIC_code='6021'DB:business_master_new
loadtime:0.74554491043091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.74562001228333 / seconds
Query Executed:select id FROM `va` where city='Milford' && SIC_code='6021'DB:business_master_new
loadtime:0.74671387672424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millboro' limit 1
loadtime:0.74676990509033 / seconds
Query Executed:select id FROM `va` where city='Millboro' && SIC_code='6021'DB:business_master_new
loadtime:0.74767589569092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Tavern' limit 1
loadtime:0.74772000312805 / seconds
Query Executed:select id FROM `va` where city='Millers Tavern' && SIC_code='6021'DB:business_master_new
loadtime:0.74822688102722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:0.74827980995178 / seconds
Query Executed:select id FROM `va` where city='Millwood' && SIC_code='6021'DB:business_master_new
loadtime:0.74886298179626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Run' limit 1
loadtime:0.74889898300171 / seconds
Query Executed:select id FROM `va` where city='Mine Run' && SIC_code='6021'DB:business_master_new
loadtime:0.74917483329773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:0.74921584129333 / seconds
Query Executed:select id FROM `va` where city='Mineral' && SIC_code='6021'DB:business_master_new
loadtime:0.75041580200195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Spring' limit 1
loadtime:0.75047397613525 / seconds
Query Executed:select id FROM `va` where city='Mint Spring' && SIC_code='6021'DB:business_master_new
loadtime:0.75090885162354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchells' limit 1
loadtime:0.75095200538635 / seconds
Query Executed:select id FROM `va` where city='Mitchells' && SIC_code='6021'DB:business_master_new
loadtime:0.75139999389648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modest Town' limit 1
loadtime:0.75145292282104 / seconds
Query Executed:select id FROM `va` where city='Modest Town' && SIC_code='6021'DB:business_master_new
loadtime:0.75174498558044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mollusk' limit 1
loadtime:0.75178384780884 / seconds
Query Executed:select id FROM `va` where city='Mollusk' && SIC_code='6021'DB:business_master_new
loadtime:0.75218081474304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moneta' limit 1
loadtime:0.75230002403259 / seconds
Query Executed:select id FROM `va` where city='Moneta' && SIC_code='6021'DB:business_master_new
loadtime:0.75373196601868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.75379300117493 / seconds
Query Executed:select id FROM `va` where city='Monroe' && SIC_code='6021'DB:business_master_new
loadtime:0.75491380691528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montebello' limit 1
loadtime:0.75496697425842 / seconds
Query Executed:select id FROM `va` where city='Montebello' && SIC_code='6021'DB:business_master_new
loadtime:0.75534200668335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:0.75537586212158 / seconds
Query Executed:select id FROM `va` where city='Monterey' && SIC_code='6021'DB:business_master_new
loadtime:0.75653696060181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.75659799575806 / seconds
Query Executed:select id FROM `va` where city='Montpelier' && SIC_code='6021'DB:business_master_new
loadtime:0.75775790214539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Sta' limit 1
loadtime:0.75781488418579 / seconds
Query Executed:select id FROM `va` where city='Montpelier Sta' && SIC_code='6021'DB:business_master_new
loadtime:0.75812697410583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Station' limit 1
loadtime:0.75816297531128 / seconds
Query Executed:select id FROM `va` where city='Montpelier Station' && SIC_code='6021'DB:business_master_new
loadtime:0.75848579406738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montross' limit 1
loadtime:0.75853896141052 / seconds
Query Executed:select id FROM `va` where city='Montross' && SIC_code='6021'DB:business_master_new
loadtime:0.75975799560547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:0.75982093811035 / seconds
Query Executed:select id FROM `va` where city='Montvale' && SIC_code='6021'DB:business_master_new
loadtime:0.76076483726501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moon' limit 1
loadtime:0.76080894470215 / seconds
Query Executed:select id FROM `va` where city='Moon' && SIC_code='6021'DB:business_master_new
loadtime:0.76119589805603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morattico' limit 1
loadtime:0.76125001907349 / seconds
Query Executed:select id FROM `va` where city='Morattico' && SIC_code='6021'DB:business_master_new
loadtime:0.76154184341431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.76158380508423 / seconds
Query Executed:select id FROM `va` where city='Morrisville' && SIC_code='6021'DB:business_master_new
loadtime:0.76183199882507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moseley' limit 1
loadtime:0.76188397407532 / seconds
Query Executed:select id FROM `va` where city='Moseley' && SIC_code='6021'DB:business_master_new
loadtime:0.76307082176208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Crawford' limit 1
loadtime:0.76315784454346 / seconds
Query Executed:select id FROM `va` where city='Mount Crawford' && SIC_code='6021'DB:business_master_new
loadtime:0.7643518447876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.76440691947937 / seconds
Query Executed:select id FROM `va` where city='Mount Holly' && SIC_code='6021'DB:business_master_new
loadtime:0.76486492156982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Jackson' limit 1
loadtime:0.76491379737854 / seconds
Query Executed:select id FROM `va` where city='Mount Jackson' && SIC_code='6021'DB:business_master_new
loadtime:0.76617884635925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sidney' limit 1
loadtime:0.76631188392639 / seconds
Query Executed:select id FROM `va` where city='Mount Sidney' && SIC_code='6021'DB:business_master_new
loadtime:0.76734685897827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Solon' limit 1
loadtime:0.76740097999573 / seconds
Query Executed:select id FROM `va` where city='Mount Solon' && SIC_code='6021'DB:business_master_new
loadtime:0.76849699020386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.76855683326721 / seconds
Query Executed:select id FROM `va` where city='Mount Vernon' && SIC_code='6021'DB:business_master_new
loadtime:0.76921987533569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mouth Of Wilson' limit 1
loadtime:0.76933097839355 / seconds
Query Executed:select id FROM `va` where city='Mouth Of Wilson' && SIC_code='6021'DB:business_master_new
loadtime:0.77016282081604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Crawford' limit 1
loadtime:0.77029490470886 / seconds
Query Executed:select id FROM `va` where city='Mt Crawford' && SIC_code='6021'DB:business_master_new
loadtime:0.77072596549988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.77076387405396 / seconds
Query Executed:select id FROM `va` where city='Mt Holly' && SIC_code='6021'DB:business_master_new
loadtime:0.77106881141663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Jackson' limit 1
loadtime:0.77112889289856 / seconds
Query Executed:select id FROM `va` where city='Mt Jackson' && SIC_code='6021'DB:business_master_new
loadtime:0.7715539932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sidney' limit 1
loadtime:0.77159285545349 / seconds
Query Executed:select id FROM `va` where city='Mt Sidney' && SIC_code='6021'DB:business_master_new
loadtime:0.77190780639648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Solon' limit 1
loadtime:0.77194881439209 / seconds
Query Executed:select id FROM `va` where city='Mt Solon' && SIC_code='6021'DB:business_master_new
loadtime:0.77224397659302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.77227902412415 / seconds
Query Executed:select id FROM `va` where city='Mt Vernon' && SIC_code='6021'DB:business_master_new
loadtime:0.77257394790649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mustoe' limit 1
loadtime:0.77261281013489 / seconds
Query Executed:select id FROM `va` where city='Mustoe' && SIC_code='6021'DB:business_master_new
loadtime:0.77294683456421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narrows' limit 1
loadtime:0.77306890487671 / seconds
Query Executed:select id FROM `va` where city='Narrows' && SIC_code='6021'DB:business_master_new
loadtime:0.77430391311646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naruna' limit 1
loadtime:0.77434682846069 / seconds
Query Executed:select id FROM `va` where city='Naruna' && SIC_code='6021'DB:business_master_new
loadtime:0.77474999427795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nassawadox' limit 1
loadtime:0.77479100227356 / seconds
Query Executed:select id FROM `va` where city='Nassawadox' && SIC_code='6021'DB:business_master_new
loadtime:0.77594089508057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathalie' limit 1
loadtime:0.77600979804993 / seconds
Query Executed:select id FROM `va` where city='Nathalie' && SIC_code='6021'DB:business_master_new
loadtime:0.77722501754761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Brdg Sta' limit 1
loadtime:0.77727484703064 / seconds
Query Executed:select id FROM `va` where city='Natural Brdg Sta' && SIC_code='6021'DB:business_master_new
loadtime:0.77758193016052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge' limit 1
loadtime:0.77760982513428 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge' && SIC_code='6021'DB:business_master_new
loadtime:0.7785849571228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge Station' limit 1
loadtime:0.77863502502441 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge Station' && SIC_code='6021'DB:business_master_new
loadtime:0.77932691574097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naval Base' limit 1
loadtime:0.77936983108521 / seconds
Query Executed:select id FROM `va` where city='Naval Base' && SIC_code='6021'DB:business_master_new
loadtime:0.77983379364014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellysford' limit 1
loadtime:0.77988481521606 / seconds
Query Executed:select id FROM `va` where city='Nellysford' && SIC_code='6021'DB:business_master_new
loadtime:0.78103685379028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:0.78109192848206 / seconds
Query Executed:select id FROM `va` where city='Nelson' && SIC_code='6021'DB:business_master_new
loadtime:0.78160190582275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonia' limit 1
loadtime:0.78164291381836 / seconds
Query Executed:select id FROM `va` where city='Nelsonia' && SIC_code='6021'DB:business_master_new
loadtime:0.78208994865417 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canton' limit 1
loadtime:0.78221082687378 / seconds
Query Executed:select id FROM `va` where city='New Canton' && SIC_code='6021'DB:business_master_new
loadtime:0.78300499916077 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.78305387496948 / seconds
Query Executed:select id FROM `va` where city='New Castle' && SIC_code='6021'DB:business_master_new
loadtime:0.78422284126282 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Church' limit 1
loadtime:0.78427290916443 / seconds
Query Executed:select id FROM `va` where city='New Church' && SIC_code='6021'DB:business_master_new
loadtime:0.78532600402832 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:0.78537797927856 / seconds
Query Executed:select id FROM `va` where city='New Hope' && SIC_code='6021'DB:business_master_new
loadtime:0.78583002090454 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Kent' limit 1
loadtime:0.78587889671326 / seconds
Query Executed:select id FROM `va` where city='New Kent' && SIC_code='6021'DB:business_master_new
loadtime:0.7870078086853 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:0.78705787658691 / seconds
Query Executed:select id FROM `va` where city='New Market' && SIC_code='6021'DB:business_master_new
loadtime:0.7883129119873 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Point' limit 1
loadtime:0.78837299346924 / seconds
Query Executed:select id FROM `va` where city='New Point' && SIC_code='6021'DB:business_master_new
loadtime:0.78872680664062 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:0.7887659072876 / seconds
Query Executed:select id FROM `va` where city='New River' && SIC_code='6021'DB:business_master_new
loadtime:0.789137840271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:0.7892529964447 / seconds
Query Executed:select id FROM `va` where city='Newbern' && SIC_code='6021'DB:business_master_new
loadtime:0.78974294662476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.78977084159851 / seconds
Query Executed:select id FROM `va` where city='Newington' && SIC_code='6021'DB:business_master_new
loadtime:0.79101896286011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.79106688499451 / seconds
Query Executed:select id FROM `va` where city='Newport' && SIC_code='6021'DB:business_master_new
loadtime:0.79187989234924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport News' limit 1
loadtime:0.79192996025085 / seconds
Query Executed:select id FROM `va` where city='Newport News' && SIC_code='6021'DB:business_master_new
loadtime:0.81170797348022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newsoms' limit 1
loadtime:0.81179094314575 / seconds
Query Executed:select id FROM `va` where city='Newsoms' && SIC_code='6021'DB:business_master_new
loadtime:0.81247591972351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.81253385543823 / seconds
Query Executed:select id FROM `va` where city='Newtown' && SIC_code='6021'DB:business_master_new
loadtime:0.81299495697021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickelsville' limit 1
loadtime:0.81309199333191 / seconds
Query Executed:select id FROM `va` where city='Nickelsville' && SIC_code='6021'DB:business_master_new
loadtime:0.81407999992371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninde' limit 1
loadtime:0.81423997879028 / seconds
Query Executed:select id FROM `va` where city='Ninde' && SIC_code='6021'DB:business_master_new
loadtime:0.8146288394928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nokesville' limit 1
loadtime:0.81465697288513 / seconds
Query Executed:select id FROM `va` where city='Nokesville' && SIC_code='6021'DB:business_master_new
loadtime:0.81588983535767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora' limit 1
loadtime:0.81594681739807 / seconds
Query Executed:select id FROM `va` where city='Nora' && SIC_code='6021'DB:business_master_new
loadtime:0.81638479232788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.81642580032349 / seconds
Query Executed:select id FROM `va` where city='Norfolk' && SIC_code='6021'DB:business_master_new
loadtime:0.83622002601624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norge' limit 1
loadtime:0.83648490905762 / seconds
Query Executed:select id FROM `va` where city='Norge' && SIC_code='6021'DB:business_master_new
loadtime:0.83702802658081 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:0.83707189559937 / seconds
Query Executed:select id FROM `va` where city='North' && SIC_code='6021'DB:business_master_new
loadtime:0.83758687973022 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Garden' limit 1
loadtime:0.83762788772583 / seconds
Query Executed:select id FROM `va` where city='North Garden' && SIC_code='6021'DB:business_master_new
loadtime:0.83857679367065 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Tazewell' limit 1
loadtime:0.83863282203674 / seconds
Query Executed:select id FROM `va` where city='North Tazewell' && SIC_code='6021'DB:business_master_new
loadtime:0.83984899520874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.83990788459778 / seconds
Query Executed:select id FROM `va` where city='Norton' && SIC_code='6021'DB:business_master_new
loadtime:0.84129595756531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:0.84135794639587 / seconds
Query Executed:select id FROM `va` where city='Norwood' && SIC_code='6021'DB:business_master_new
loadtime:0.84166598320007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottoway' limit 1
loadtime:0.84169483184814 / seconds
Query Executed:select id FROM `va` where city='Nottoway' && SIC_code='6021'DB:business_master_new
loadtime:0.84218692779541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nuttsville' limit 1
loadtime:0.84223699569702 / seconds
Query Executed:select id FROM `va` where city='Nuttsville' && SIC_code='6021'DB:business_master_new
loadtime:0.84252691268921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hall' limit 1
loadtime:0.84256291389465 / seconds
Query Executed:select id FROM `va` where city='Oak Hall' && SIC_code='6021'DB:business_master_new
loadtime:0.84334683418274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakpark' limit 1
loadtime:0.84340381622314 / seconds
Query Executed:select id FROM `va` where city='Oakpark' && SIC_code='6021'DB:business_master_new
loadtime:0.84370398521423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakton' limit 1
loadtime:0.84373879432678 / seconds
Query Executed:select id FROM `va` where city='Oakton' && SIC_code='6021'DB:business_master_new
loadtime:0.84524893760681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakwood' limit 1
loadtime:0.84540891647339 / seconds
Query Executed:select id FROM `va` where city='Oakwood' && SIC_code='6021'DB:business_master_new
loadtime:0.84667992591858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Occoquan' limit 1
loadtime:0.84672999382019 / seconds
Query Executed:select id FROM `va` where city='Occoquan' && SIC_code='6021'DB:business_master_new
loadtime:0.84786891937256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oilville' limit 1
loadtime:0.84790992736816 / seconds
Query Executed:select id FROM `va` where city='Oilville' && SIC_code='6021'DB:business_master_new
loadtime:0.84891986846924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldhams' limit 1
loadtime:0.84896779060364 / seconds
Query Executed:select id FROM `va` where city='Oldhams' && SIC_code='6021'DB:business_master_new
loadtime:0.84933185577393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onancock' limit 1
loadtime:0.84937882423401 / seconds
Query Executed:select id FROM `va` where city='Onancock' && SIC_code='6021'DB:business_master_new
loadtime:0.85058188438416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onemo' limit 1
loadtime:0.85063695907593 / seconds
Query Executed:select id FROM `va` where city='Onemo' && SIC_code='6021'DB:business_master_new
loadtime:0.85104179382324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onley' limit 1
loadtime:0.85117602348328 / seconds
Query Executed:select id FROM `va` where city='Onley' && SIC_code='6021'DB:business_master_new
loadtime:0.85240793228149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophelia' limit 1
loadtime:0.85246086120605 / seconds
Query Executed:select id FROM `va` where city='Ophelia' && SIC_code='6021'DB:business_master_new
loadtime:0.85281991958618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.85286784172058 / seconds
Query Executed:select id FROM `va` where city='Orange' && SIC_code='6021'DB:business_master_new
loadtime:0.8543438911438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordinary' limit 1
loadtime:0.85440683364868 / seconds
Query Executed:select id FROM `va` where city='Ordinary' && SIC_code='6021'DB:business_master_new
loadtime:0.85496091842651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriskany' limit 1
loadtime:0.85499787330627 / seconds
Query Executed:select id FROM `va` where city='Oriskany' && SIC_code='6021'DB:business_master_new
loadtime:0.85532188415527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orkney Springs' limit 1
loadtime:0.85536289215088 / seconds
Query Executed:select id FROM `va` where city='Orkney Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.85569882392883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlean' limit 1
loadtime:0.85572981834412 / seconds
Query Executed:select id FROM `va` where city='Orlean' && SIC_code='6021'DB:business_master_new
loadtime:0.85620880126953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyster' limit 1
loadtime:0.85635089874268 / seconds
Query Executed:select id FROM `va` where city='Oyster' && SIC_code='6021'DB:business_master_new
loadtime:0.85670590400696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paeonian Springs' limit 1
loadtime:0.85674595832825 / seconds
Query Executed:select id FROM `va` where city='Paeonian Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.85739994049072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Bank' limit 1
loadtime:0.85744190216064 / seconds
Query Executed:select id FROM `va` where city='Paint Bank' && SIC_code='6021'DB:business_master_new
loadtime:0.8578188419342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painter' limit 1
loadtime:0.85786986351013 / seconds
Query Executed:select id FROM `va` where city='Painter' && SIC_code='6021'DB:business_master_new
loadtime:0.85885000228882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:0.85891890525818 / seconds
Query Executed:select id FROM `va` where city='Palmyra' && SIC_code='6021'DB:business_master_new
loadtime:0.8602340221405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplin' limit 1
loadtime:0.86028480529785 / seconds
Query Executed:select id FROM `va` where city='Pamplin' && SIC_code='6021'DB:business_master_new
loadtime:0.86115789413452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:0.86128997802734 / seconds
Query Executed:select id FROM `va` where city='Paris' && SIC_code='6021'DB:business_master_new
loadtime:0.86187195777893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksley' limit 1
loadtime:0.86192083358765 / seconds
Query Executed:select id FROM `va` where city='Parksley' && SIC_code='6021'DB:business_master_new
loadtime:0.86309099197388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrott' limit 1
loadtime:0.86320400238037 / seconds
Query Executed:select id FROM `va` where city='Parrott' && SIC_code='6021'DB:business_master_new
loadtime:0.8635938167572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partlow' limit 1
loadtime:0.86363387107849 / seconds
Query Executed:select id FROM `va` where city='Partlow' && SIC_code='6021'DB:business_master_new
loadtime:0.86435079574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick Springs' limit 1
loadtime:0.8643958568573 / seconds
Query Executed:select id FROM `va` where city='Patrick Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.86544585227966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:0.86550283432007 / seconds
Query Executed:select id FROM `va` where city='Patterson' && SIC_code='6021'DB:business_master_new
loadtime:0.86584091186523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearisburg' limit 1
loadtime:0.86587691307068 / seconds
Query Executed:select id FROM `va` where city='Pearisburg' && SIC_code='6021'DB:business_master_new
loadtime:0.86719989776611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:0.86736083030701 / seconds
Query Executed:select id FROM `va` where city='Pembroke' && SIC_code='6021'DB:business_master_new
loadtime:0.86859202384949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penhook' limit 1
loadtime:0.86864495277405 / seconds
Query Executed:select id FROM `va` where city='Penhook' && SIC_code='6021'DB:business_master_new
loadtime:0.86974287033081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penn Laird' limit 1
loadtime:0.86979389190674 / seconds
Query Executed:select id FROM `va` where city='Penn Laird' && SIC_code='6021'DB:business_master_new
loadtime:0.87064385414124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington Gap' limit 1
loadtime:0.87068581581116 / seconds
Query Executed:select id FROM `va` where city='Pennington Gap' && SIC_code='6021'DB:business_master_new
loadtime:0.87195181846619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:0.87201285362244 / seconds
Query Executed:select id FROM `va` where city='Petersburg' && SIC_code='6021'DB:business_master_new
loadtime:0.87435698509216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix' limit 1
loadtime:0.87442588806152 / seconds
Query Executed:select id FROM `va` where city='Phenix' && SIC_code='6021'DB:business_master_new
loadtime:0.87500786781311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomont' limit 1
loadtime:0.87505102157593 / seconds
Query Executed:select id FROM `va` where city='Philomont' && SIC_code='6021'DB:business_master_new
loadtime:0.87547779083252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilgrims Knob' limit 1
loadtime:0.87553286552429 / seconds
Query Executed:select id FROM `va` where city='Pilgrims Knob' && SIC_code='6021'DB:business_master_new
loadtime:0.87588381767273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot' limit 1
loadtime:0.87593293190002 / seconds
Query Executed:select id FROM `va` where city='Pilot' && SIC_code='6021'DB:business_master_new
loadtime:0.8765389919281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney River' limit 1
loadtime:0.87657499313354 / seconds
Query Executed:select id FROM `va` where city='Piney River' && SIC_code='6021'DB:business_master_new
loadtime:0.8771870136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:0.8773238658905 / seconds
Query Executed:select id FROM `va` where city='Pittsville' && SIC_code='6021'DB:business_master_new
loadtime:0.87782382965088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain View' limit 1
loadtime:0.87787795066833 / seconds
Query Executed:select id FROM `va` where city='Plain View' && SIC_code='6021'DB:business_master_new
loadtime:0.87814998626709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.87822890281677 / seconds
Query Executed:select id FROM `va` where city='Pleasant Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.87859201431274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:0.8786289691925 / seconds
Query Executed:select id FROM `va` where city='Pocahontas' && SIC_code='6021'DB:business_master_new
loadtime:0.87922501564026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquoson' limit 1
loadtime:0.87934184074402 / seconds
Query Executed:select id FROM `va` where city='Poquoson' && SIC_code='6021'DB:business_master_new
loadtime:0.88069987297058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Haywood' limit 1
loadtime:0.8807578086853 / seconds
Query Executed:select id FROM `va` where city='Port Haywood' && SIC_code='6021'DB:business_master_new
loadtime:0.88125586509705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:0.88130283355713 / seconds
Query Executed:select id FROM `va` where city='Port Republic' && SIC_code='6021'DB:business_master_new
loadtime:0.88209891319275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:0.88222479820251 / seconds
Query Executed:select id FROM `va` where city='Port Royal' && SIC_code='6021'DB:business_master_new
loadtime:0.88300490379333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.88304996490479 / seconds
Query Executed:select id FROM `va` where city='Portsmouth' && SIC_code='6021'DB:business_master_new
loadtime:0.88590598106384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:0.8859748840332 / seconds
Query Executed:select id FROM `va` where city='Pound' && SIC_code='6021'DB:business_master_new
loadtime:0.88719701766968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pounding Mill' limit 1
loadtime:0.88735890388489 / seconds
Query Executed:select id FROM `va` where city='Pounding Mill' && SIC_code='6021'DB:business_master_new
loadtime:0.88871383666992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:0.88875699043274 / seconds
Query Executed:select id FROM `va` where city='Powhatan' && SIC_code='6021'DB:business_master_new
loadtime:0.89030981063843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratts' limit 1
loadtime:0.89036989212036 / seconds
Query Executed:select id FROM `va` where city='Pratts' && SIC_code='6021'DB:business_master_new
loadtime:0.8907368183136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince George' limit 1
loadtime:0.8907790184021 / seconds
Query Executed:select id FROM `va` where city='Prince George' && SIC_code='6021'DB:business_master_new
loadtime:0.89205980300903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.89222097396851 / seconds
Query Executed:select id FROM `va` where city='Prospect' && SIC_code='6021'DB:business_master_new
loadtime:0.89309597015381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence Forge' limit 1
loadtime:0.8931930065155 / seconds
Query Executed:select id FROM `va` where city='Providence Forge' && SIC_code='6021'DB:business_master_new
loadtime:0.89444398880005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:0.89449787139893 / seconds
Query Executed:select id FROM `va` where city='Pulaski' && SIC_code='6021'DB:business_master_new
loadtime:0.89594793319702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pungoteague' limit 1
loadtime:0.89600801467896 / seconds
Query Executed:select id FROM `va` where city='Pungoteague' && SIC_code='6021'DB:business_master_new
loadtime:0.89648485183716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purcellville' limit 1
loadtime:0.89654088020325 / seconds
Query Executed:select id FROM `va` where city='Purcellville' && SIC_code='6021'DB:business_master_new
loadtime:0.89815282821655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quantico' limit 1
loadtime:0.8983268737793 / seconds
Query Executed:select id FROM `va` where city='Quantico' && SIC_code='6021'DB:business_master_new
loadtime:0.8995988368988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quicksburg' limit 1
loadtime:0.89965081214905 / seconds
Query Executed:select id FROM `va` where city='Quicksburg' && SIC_code='6021'DB:business_master_new
loadtime:0.90037393569946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:0.90042495727539 / seconds
Query Executed:select id FROM `va` where city='Quinby' && SIC_code='6021'DB:business_master_new
loadtime:0.90074682235718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinque' limit 1
loadtime:0.90077900886536 / seconds
Query Executed:select id FROM `va` where city='Quinque' && SIC_code='6021'DB:business_master_new
loadtime:0.90119981765747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:0.90132689476013 / seconds
Query Executed:select id FROM `va` where city='Quinton' && SIC_code='6021'DB:business_master_new
loadtime:0.90257287025452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radford' limit 1
loadtime:0.90262699127197 / seconds
Query Executed:select id FROM `va` where city='Radford' && SIC_code='6021'DB:business_master_new
loadtime:0.90430998802185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radiant' limit 1
loadtime:0.90447402000427 / seconds
Query Executed:select id FROM `va` where city='Radiant' && SIC_code='6021'DB:business_master_new
loadtime:0.90490794181824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.90495991706848 / seconds
Query Executed:select id FROM `va` where city='Randolph' && SIC_code='6021'DB:business_master_new
loadtime:0.90536379814148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raphine' limit 1
loadtime:0.90546083450317 / seconds
Query Executed:select id FROM `va` where city='Raphine' && SIC_code='6021'DB:business_master_new
loadtime:0.90655088424683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapidan' limit 1
loadtime:0.90660381317139 / seconds
Query Executed:select id FROM `va` where city='Rapidan' && SIC_code='6021'DB:business_master_new
loadtime:0.90739583969116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Academy' limit 1
loadtime:0.90743684768677 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Academy' && SIC_code='6021'DB:business_master_new
loadtime:0.90781593322754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Acd' limit 1
loadtime:0.90786695480347 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Acd' && SIC_code='6021'DB:business_master_new
loadtime:0.90811085700989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raven' limit 1
loadtime:0.9081928730011 / seconds
Query Executed:select id FROM `va` where city='Raven' && SIC_code='6021'DB:business_master_new
loadtime:0.90894484519958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlings' limit 1
loadtime:0.90899682044983 / seconds
Query Executed:select id FROM `va` where city='Rawlings' && SIC_code='6021'DB:business_master_new
loadtime:0.90938901901245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rectortown' limit 1
loadtime:0.90942788124084 / seconds
Query Executed:select id FROM `va` where city='Rectortown' && SIC_code='6021'DB:business_master_new
loadtime:0.90976500511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Ash' limit 1
loadtime:0.90979886054993 / seconds
Query Executed:select id FROM `va` where city='Red Ash' && SIC_code='6021'DB:business_master_new
loadtime:0.91015696525574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:0.91029286384583 / seconds
Query Executed:select id FROM `va` where city='Red House' && SIC_code='6021'DB:business_master_new
loadtime:0.9108099937439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:0.91086101531982 / seconds
Query Executed:select id FROM `va` where city='Red Oak' && SIC_code='6021'DB:business_master_new
loadtime:0.91155600547791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redart' limit 1
loadtime:0.91159796714783 / seconds
Query Executed:select id FROM `va` where city='Redart' && SIC_code='6021'DB:business_master_new
loadtime:0.91184782981873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:0.9118869304657 / seconds
Query Executed:select id FROM `va` where city='Redwood' && SIC_code='6021'DB:business_master_new
loadtime:0.91223192214966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedville' limit 1
loadtime:0.9122679233551 / seconds
Query Executed:select id FROM `va` where city='Reedville' && SIC_code='6021'DB:business_master_new
loadtime:0.91339492797852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.91345500946045 / seconds
Query Executed:select id FROM `va` where city='Reliance' && SIC_code='6021'DB:business_master_new
loadtime:0.91371297836304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remington' limit 1
loadtime:0.91375398635864 / seconds
Query Executed:select id FROM `va` where city='Remington' && SIC_code='6021'DB:business_master_new
loadtime:0.91489195823669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republican Grove' limit 1
loadtime:0.91494202613831 / seconds
Query Executed:select id FROM `va` where city='Republican Grove' && SIC_code='6021'DB:business_master_new
loadtime:0.91519594192505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rescue' limit 1
loadtime:0.91528987884521 / seconds
Query Executed:select id FROM `va` where city='Rescue' && SIC_code='6021'DB:business_master_new
loadtime:0.91565990447998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reston' limit 1
loadtime:0.91569685935974 / seconds
Query Executed:select id FROM `va` where city='Reston' && SIC_code='6021'DB:business_master_new
loadtime:0.91863179206848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.91870379447937 / seconds
Query Executed:select id FROM `va` where city='Reva' && SIC_code='6021'DB:business_master_new
loadtime:0.91946387290955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhoadesville' limit 1
loadtime:0.91950702667236 / seconds
Query Executed:select id FROM `va` where city='Rhoadesville' && SIC_code='6021'DB:business_master_new
loadtime:0.92029500007629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:0.92034387588501 / seconds
Query Executed:select id FROM `va` where city='Rice' && SIC_code='6021'DB:business_master_new
loadtime:0.92111301422119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Creek' limit 1
loadtime:0.92125582695007 / seconds
Query Executed:select id FROM `va` where city='Rich Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.92234396934509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richardsville' limit 1
loadtime:0.92239379882812 / seconds
Query Executed:select id FROM `va` where city='Richardsville' && SIC_code='6021'DB:business_master_new
loadtime:0.92283296585083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:0.92289590835571 / seconds
Query Executed:select id FROM `va` where city='Richlands' && SIC_code='6021'DB:business_master_new
loadtime:0.92430090904236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.92436099052429 / seconds
Query Executed:select id FROM `va` where city='Richmond' && SIC_code='6021'DB:business_master_new
loadtime:0.9443678855896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.94461584091187 / seconds
Query Executed:select id FROM `va` where city='Ridgeway' && SIC_code='6021'DB:business_master_new
loadtime:0.94587779045105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rileyville' limit 1
loadtime:0.94592690467834 / seconds
Query Executed:select id FROM `va` where city='Rileyville' && SIC_code='6021'DB:business_master_new
loadtime:0.94647598266602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riner' limit 1
loadtime:0.9465389251709 / seconds
Query Executed:select id FROM `va` where city='Riner' && SIC_code='6021'DB:business_master_new
loadtime:0.94769597053528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringgold' limit 1
loadtime:0.94775581359863 / seconds
Query Executed:select id FROM `va` where city='Ringgold' && SIC_code='6021'DB:business_master_new
loadtime:0.94889092445374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripplemead' limit 1
loadtime:0.94892692565918 / seconds
Query Executed:select id FROM `va` where city='Ripplemead' && SIC_code='6021'DB:business_master_new
loadtime:0.94950485229492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.94960784912109 / seconds
Query Executed:select id FROM `va` where city='Riverton' && SIC_code='6021'DB:business_master_new
loadtime:0.94988584518433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rixeyville' limit 1
loadtime:0.94992399215698 / seconds
Query Executed:select id FROM `va` where city='Rixeyville' && SIC_code='6021'DB:business_master_new
loadtime:0.95107889175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:0.951171875 / seconds
Query Executed:select id FROM `va` where city='Roanoke' && SIC_code='6021'DB:business_master_new
loadtime:0.97107696533203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle' limit 1
loadtime:0.97133493423462 / seconds
Query Executed:select id FROM `va` where city='Rochelle' && SIC_code='6021'DB:business_master_new
loadtime:0.97210597991943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockbridge Baths' limit 1
loadtime:0.97225189208984 / seconds
Query Executed:select id FROM `va` where city='Rockbridge Baths' && SIC_code='6021'DB:business_master_new
loadtime:0.97291898727417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:0.97297096252441 / seconds
Query Executed:select id FROM `va` where city='Rockville' && SIC_code='6021'DB:business_master_new
loadtime:0.97416400909424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Gap' limit 1
loadtime:0.9742739200592 / seconds
Query Executed:select id FROM `va` where city='Rocky Gap' && SIC_code='6021'DB:business_master_new
loadtime:0.97517395019531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:0.97530698776245 / seconds
Query Executed:select id FROM `va` where city='Rocky Mount' && SIC_code='6021'DB:business_master_new
loadtime:0.97712779045105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollins Fork' limit 1
loadtime:0.9771900177002 / seconds
Query Executed:select id FROM `va` where city='Rollins Fork' && SIC_code='6021'DB:business_master_new
loadtime:0.97748589515686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:0.97751379013062 / seconds
Query Executed:select id FROM `va` where city='Rose Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.97846794128418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:0.97853899002075 / seconds
Query Executed:select id FROM `va` where city='Rosedale' && SIC_code='6021'DB:business_master_new
loadtime:0.97939085960388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:0.97944593429565 / seconds
Query Executed:select id FROM `va` where city='Roseland' && SIC_code='6021'DB:business_master_new
loadtime:0.98050880432129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Hill' limit 1
loadtime:0.98060584068298 / seconds
Query Executed:select id FROM `va` where city='Round Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.98174285888672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:0.98179292678833 / seconds
Query Executed:select id FROM `va` where city='Rowe' && SIC_code='6021'DB:business_master_new
loadtime:0.9821789264679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:0.98228979110718 / seconds
Query Executed:select id FROM `va` where city='Ruby' && SIC_code='6021'DB:business_master_new
loadtime:0.98273682594299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruckersville' limit 1
loadtime:0.98277688026428 / seconds
Query Executed:select id FROM `va` where city='Ruckersville' && SIC_code='6021'DB:business_master_new
loadtime:0.98409581184387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Retreat' limit 1
loadtime:0.98426985740662 / seconds
Query Executed:select id FROM `va` where city='Rural Retreat' && SIC_code='6021'DB:business_master_new
loadtime:0.98554491996765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rustburg' limit 1
loadtime:0.98558783531189 / seconds
Query Executed:select id FROM `va` where city='Rustburg' && SIC_code='6021'DB:business_master_new
loadtime:0.98689079284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruther Glen' limit 1
loadtime:0.98694896697998 / seconds
Query Executed:select id FROM `va` where city='Ruther Glen' && SIC_code='6021'DB:business_master_new
loadtime:0.988205909729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthville' limit 1
loadtime:0.98825788497925 / seconds
Query Executed:select id FROM `va` where city='Ruthville' && SIC_code='6021'DB:business_master_new
loadtime:0.98859786987305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.98863792419434 / seconds
Query Executed:select id FROM `va` where city='Saint Charles' && SIC_code='6021'DB:business_master_new
loadtime:0.98914384841919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:0.98927283287048 / seconds
Query Executed:select id FROM `va` where city='Saint Paul' && SIC_code='6021'DB:business_master_new
loadtime:0.99052786827087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens Church' limit 1
loadtime:0.99058794975281 / seconds
Query Executed:select id FROM `va` where city='Saint Stephens Church' && SIC_code='6021'DB:business_master_new
loadtime:0.99130582809448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.99135088920593 / seconds
Query Executed:select id FROM `va` where city='Salem' && SIC_code='6021'DB:business_master_new
loadtime:0.99351191520691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltville' limit 1
loadtime:0.99358296394348 / seconds
Query Executed:select id FROM `va` where city='Saltville' && SIC_code='6021'DB:business_master_new
loadtime:0.99472689628601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:0.99478602409363 / seconds
Query Executed:select id FROM `va` where city='Saluda' && SIC_code='6021'DB:business_master_new
loadtime:0.99600386619568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandston' limit 1
loadtime:0.99606585502625 / seconds
Query Executed:select id FROM `va` where city='Sandston' && SIC_code='6021'DB:business_master_new
loadtime:0.99741792678833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.99746680259705 / seconds
Query Executed:select id FROM `va` where city='Sandy Hook' && SIC_code='6021'DB:business_master_new
loadtime:0.99796080589294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Level' limit 1
loadtime:0.99801301956177 / seconds
Query Executed:select id FROM `va` where city='Sandy Level' && SIC_code='6021'DB:business_master_new
loadtime:0.99844098091125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Point' limit 1
loadtime:0.99848389625549 / seconds
Query Executed:select id FROM `va` where city='Sandy Point' && SIC_code='6021'DB:business_master_new
loadtime:0.99882102012634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:0.99888181686401 / seconds
Query Executed:select id FROM `va` where city='Sanford' && SIC_code='6021'DB:business_master_new
loadtime:0.99927592277527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxe' limit 1
loadtime:0.9993999004364 / seconds
Query Executed:select id FROM `va` where city='Saxe' && SIC_code='6021'DB:business_master_new
loadtime:0.9999577999115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxis' limit 1
loadtime:0.9999988079071 / seconds
Query Executed:select id FROM `va` where city='Saxis' && SIC_code='6021'DB:business_master_new
loadtime:1.0003969669342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schley' limit 1
loadtime:1.0004379749298 / seconds
Query Executed:select id FROM `va` where city='Schley' && SIC_code='6021'DB:business_master_new
loadtime:1.000739812851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schuyler' limit 1
loadtime:1.0007648468018 / seconds
Query Executed:select id FROM `va` where city='Schuyler' && SIC_code='6021'DB:business_master_new
loadtime:1.0013539791107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:1.001405954361 / seconds
Query Executed:select id FROM `va` where city='Scottsburg' && SIC_code='6021'DB:business_master_new
loadtime:1.002415895462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsville' limit 1
loadtime:1.002466917038 / seconds
Query Executed:select id FROM `va` where city='Scottsville' && SIC_code='6021'DB:business_master_new
loadtime:1.0036969184875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaford' limit 1
loadtime:1.003753900528 / seconds
Query Executed:select id FROM `va` where city='Seaford' && SIC_code='6021'DB:business_master_new
loadtime:1.0050759315491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealston' limit 1
loadtime:1.0051259994507 / seconds
Query Executed:select id FROM `va` where city='Sealston' && SIC_code='6021'DB:business_master_new
loadtime:1.0054659843445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:1.0055019855499 / seconds
Query Executed:select id FROM `va` where city='Seaview' && SIC_code='6021'DB:business_master_new
loadtime:1.0057778358459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedley' limit 1
loadtime:1.0058038234711 / seconds
Query Executed:select id FROM `va` where city='Sedley' && SIC_code='6021'DB:business_master_new
loadtime:1.0065388679504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:1.0065867900848 / seconds
Query Executed:select id FROM `va` where city='Selma' && SIC_code='6021'DB:business_master_new
loadtime:1.0069777965546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Corners' limit 1
loadtime:1.007022857666 / seconds
Query Executed:select id FROM `va` where city='Seven Corners' && SIC_code='6021'DB:business_master_new
loadtime:1.0073199272156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Mile Ford' limit 1
loadtime:1.0073549747467 / seconds
Query Executed:select id FROM `va` where city='Seven Mile Ford' && SIC_code='6021'DB:business_master_new
loadtime:1.0076329708099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:1.0076730251312 / seconds
Query Executed:select id FROM `va` where city='Severn' && SIC_code='6021'DB:business_master_new
loadtime:1.0079779624939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shacklefords' limit 1
loadtime:1.0080189704895 / seconds
Query Executed:select id FROM `va` where city='Shacklefords' && SIC_code='6021'DB:business_master_new
loadtime:1.0086967945099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharps' limit 1
loadtime:1.0087368488312 / seconds
Query Executed:select id FROM `va` where city='Sharps' && SIC_code='6021'DB:business_master_new
loadtime:1.0090968608856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawsville' limit 1
loadtime:1.0091409683228 / seconds
Query Executed:select id FROM `va` where city='Shawsville' && SIC_code='6021'DB:business_master_new
loadtime:1.0102989673615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:1.0103569030762 / seconds
Query Executed:select id FROM `va` where city='Shelby' && SIC_code='6021'DB:business_master_new
loadtime:1.010636806488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:1.0107319355011 / seconds
Query Executed:select id FROM `va` where city='Shenandoah' && SIC_code='6021'DB:business_master_new
loadtime:1.0120348930359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Cvrns' limit 1
loadtime:1.012188911438 / seconds
Query Executed:select id FROM `va` where city='Shenandoah Cvrns' && SIC_code='6021'DB:business_master_new
loadtime:1.012542963028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherando' limit 1
loadtime:1.0125749111176 / seconds
Query Executed:select id FROM `va` where city='Sherando' && SIC_code='6021'DB:business_master_new
loadtime:1.0128829479218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:1.0129339694977 / seconds
Query Executed:select id FROM `va` where city='Shiloh' && SIC_code='6021'DB:business_master_new
loadtime:1.013190984726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shipman' limit 1
loadtime:1.0132257938385 / seconds
Query Executed:select id FROM `va` where city='Shipman' && SIC_code='6021'DB:business_master_new
loadtime:1.0139439105988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shortt Gap' limit 1
loadtime:1.0140409469604 / seconds
Query Executed:select id FROM `va` where city='Shortt Gap' && SIC_code='6021'DB:business_master_new
loadtime:1.0143609046936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Singers Glen' limit 1
loadtime:1.014408826828 / seconds
Query Executed:select id FROM `va` where city='Singers Glen' && SIC_code='6021'DB:business_master_new
loadtime:1.0149109363556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skippers' limit 1
loadtime:1.0149478912354 / seconds
Query Executed:select id FROM `va` where city='Skippers' && SIC_code='6021'DB:business_master_new
loadtime:1.0155329704285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipwith' limit 1
loadtime:1.0155749320984 / seconds
Query Executed:select id FROM `va` where city='Skipwith' && SIC_code='6021'DB:business_master_new
loadtime:1.0161638259888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:1.0162088871002 / seconds
Query Executed:select id FROM `va` where city='Smithfield' && SIC_code='6021'DB:business_master_new
loadtime:1.0176630020142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snell' limit 1
loadtime:1.017707824707 / seconds
Query Executed:select id FROM `va` where city='Snell' && SIC_code='6021'DB:business_master_new
loadtime:1.018059015274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:1.0182018280029 / seconds
Query Executed:select id FROM `va` where city='Somerset' && SIC_code='6021'DB:business_master_new
loadtime:1.0188050270081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:1.0188539028168 / seconds
Query Executed:select id FROM `va` where city='Somerville' && SIC_code='6021'DB:business_master_new
loadtime:1.019119977951 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:1.0191988945007 / seconds
Query Executed:select id FROM `va` where city='South Boston' && SIC_code='6021'DB:business_master_new
loadtime:1.0210030078888 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hill' limit 1
loadtime:1.0211279392242 / seconds
Query Executed:select id FROM `va` where city='South Hill' && SIC_code='6021'DB:business_master_new
loadtime:1.022668838501 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Riding' limit 1
loadtime:1.022716999054 / seconds
Query Executed:select id FROM `va` where city='South Riding' && SIC_code='6021'DB:business_master_new
loadtime:1.0230669975281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:1.0231549739838 / seconds
Query Executed:select id FROM `va` where city='Sparta' && SIC_code='6021'DB:business_master_new
loadtime:1.023509979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speedwell' limit 1
loadtime:1.0235598087311 / seconds
Query Executed:select id FROM `va` where city='Speedwell' && SIC_code='6021'DB:business_master_new
loadtime:1.0240788459778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:1.0242059230804 / seconds
Query Executed:select id FROM `va` where city='Spencer' && SIC_code='6021'DB:business_master_new
loadtime:1.0252249240875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperryville' limit 1
loadtime:1.0253608226776 / seconds
Query Executed:select id FROM `va` where city='Sperryville' && SIC_code='6021'DB:business_master_new
loadtime:1.0265879631042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotsylvania' limit 1
loadtime:1.0266239643097 / seconds
Query Executed:select id FROM `va` where city='Spotsylvania' && SIC_code='6021'DB:business_master_new
loadtime:1.0282828807831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spout Spring' limit 1
loadtime:1.0284550189972 / seconds
Query Executed:select id FROM `va` where city='Spout Spring' && SIC_code='6021'DB:business_master_new
loadtime:1.029266834259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Grove' limit 1
loadtime:1.0293970108032 / seconds
Query Executed:select id FROM `va` where city='Spring Grove' && SIC_code='6021'DB:business_master_new
loadtime:1.0300939083099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:1.0301430225372 / seconds
Query Executed:select id FROM `va` where city='Springfield' && SIC_code='6021'DB:business_master_new
loadtime:1.0498478412628 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:1.0499229431152 / seconds
Query Executed:select id FROM `va` where city='St Charles' && SIC_code='6021'DB:business_master_new
loadtime:1.0502870082855 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:1.0504128932953 / seconds
Query Executed:select id FROM `va` where city='St Paul' && SIC_code='6021'DB:business_master_new
loadtime:1.0508279800415 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens Chr' limit 1
loadtime:1.0508677959442 / seconds
Query Executed:select id FROM `va` where city='St Stephens Chr' && SIC_code='6021'DB:business_master_new
loadtime:1.0512390136719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:1.0513708591461 / seconds
Query Executed:select id FROM `va` where city='Stafford' && SIC_code='6021'DB:business_master_new
loadtime:1.0535349845886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordsville' limit 1
loadtime:1.0535988807678 / seconds
Query Executed:select id FROM `va` where city='Staffordsville' && SIC_code='6021'DB:business_master_new
loadtime:1.0539388656616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanardsville' limit 1
loadtime:1.0539898872375 / seconds
Query Executed:select id FROM `va` where city='Stanardsville' && SIC_code='6021'DB:business_master_new
loadtime:1.0552139282227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.0552749633789 / seconds
Query Executed:select id FROM `va` where city='Stanley' && SIC_code='6021'DB:business_master_new
loadtime:1.056468963623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanleytown' limit 1
loadtime:1.0565118789673 / seconds
Query Executed:select id FROM `va` where city='Stanleytown' && SIC_code='6021'DB:business_master_new
loadtime:1.0572338104248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Tannery' limit 1
loadtime:1.0574109554291 / seconds
Query Executed:select id FROM `va` where city='Star Tannery' && SIC_code='6021'DB:business_master_new
loadtime:1.0579409599304 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Farm' limit 1
loadtime:1.0579779148102 / seconds
Query Executed:select id FROM `va` where city='State Farm' && SIC_code='6021'DB:business_master_new
loadtime:1.0583198070526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staunton' limit 1
loadtime:1.0583679676056 / seconds
Query Executed:select id FROM `va` where city='Staunton' && SIC_code='6021'DB:business_master_new
loadtime:1.0604989528656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steeles Tavern' limit 1
loadtime:1.0605759620667 / seconds
Query Executed:select id FROM `va` where city='Steeles Tavern' && SIC_code='6021'DB:business_master_new
loadtime:1.0609970092773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephens City' limit 1
loadtime:1.0610468387604 / seconds
Query Executed:select id FROM `va` where city='Stephens City' && SIC_code='6021'DB:business_master_new
loadtime:1.0623478889465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:1.0623989105225 / seconds
Query Executed:select id FROM `va` where city='Stephenson' && SIC_code='6021'DB:business_master_new
loadtime:1.0632989406586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:1.0633478164673 / seconds
Query Executed:select id FROM `va` where city='Sterling' && SIC_code='6021'DB:business_master_new
loadtime:1.066535949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensburg' limit 1
loadtime:1.0666058063507 / seconds
Query Executed:select id FROM `va` where city='Stevensburg' && SIC_code='6021'DB:business_master_new
loadtime:1.0670700073242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:1.067195892334 / seconds
Query Executed:select id FROM `va` where city='Stevensville' && SIC_code='6021'DB:business_master_new
loadtime:1.0676028728485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Ridge' limit 1
loadtime:1.0676410198212 / seconds
Query Executed:select id FROM `va` where city='Stone Ridge' && SIC_code='6021'DB:business_master_new
loadtime:1.0678868293762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonega' limit 1
loadtime:1.0679159164429 / seconds
Query Executed:select id FROM `va` where city='Stonega' && SIC_code='6021'DB:business_master_new
loadtime:1.0681579113007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Creek' limit 1
loadtime:1.0682299137115 / seconds
Query Executed:select id FROM `va` where city='Stony Creek' && SIC_code='6021'DB:business_master_new
loadtime:1.0695779323578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:1.0696339607239 / seconds
Query Executed:select id FROM `va` where city='Strasburg' && SIC_code='6021'DB:business_master_new
loadtime:1.0709428787231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:1.0710079669952 / seconds
Query Executed:select id FROM `va` where city='Stratford' && SIC_code='6021'DB:business_master_new
loadtime:1.0713028907776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:1.0713357925415 / seconds
Query Executed:select id FROM `va` where city='Stuart' && SIC_code='6021'DB:business_master_new
loadtime:1.0726888179779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuarts Draft' limit 1
loadtime:1.0727529525757 / seconds
Query Executed:select id FROM `va` where city='Stuarts Draft' && SIC_code='6021'DB:business_master_new
loadtime:1.0740878582001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:1.0742099285126 / seconds
Query Executed:select id FROM `va` where city='Studley' && SIC_code='6021'DB:business_master_new
loadtime:1.0747029781342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffolk' limit 1
loadtime:1.0747468471527 / seconds
Query Executed:select id FROM `va` where city='Suffolk' && SIC_code='6021'DB:business_master_new
loadtime:1.0772359371185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:1.0774118900299 / seconds
Query Executed:select id FROM `va` where city='Sugar Grove' && SIC_code='6021'DB:business_master_new
loadtime:1.0782129764557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerduck' limit 1
loadtime:1.0783138275146 / seconds
Query Executed:select id FROM `va` where city='Sumerduck' && SIC_code='6021'DB:business_master_new
loadtime:1.07914686203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:1.0792779922485 / seconds
Query Executed:select id FROM `va` where city='Supply' && SIC_code='6021'DB:business_master_new
loadtime:1.0796189308167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:1.0796589851379 / seconds
Query Executed:select id FROM `va` where city='Surry' && SIC_code='6021'DB:business_master_new
loadtime:1.0807719230652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susan' limit 1
loadtime:1.0808157920837 / seconds
Query Executed:select id FROM `va` where city='Susan' && SIC_code='6021'DB:business_master_new
loadtime:1.0811970233917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:1.081337928772 / seconds
Query Executed:select id FROM `va` where city='Sussex' && SIC_code='6021'DB:business_master_new
loadtime:1.0818629264832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:1.0819208621979 / seconds
Query Executed:select id FROM `va` where city='Sutherland' && SIC_code='6021'DB:business_master_new
loadtime:1.082897901535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:1.0829458236694 / seconds
Query Executed:select id FROM `va` where city='Sutherlin' && SIC_code='6021'DB:business_master_new
loadtime:1.0836029052734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Briar' limit 1
loadtime:1.0836369991302 / seconds
Query Executed:select id FROM `va` where city='Sweet Briar' && SIC_code='6021'DB:business_master_new
loadtime:1.0840449333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swoope' limit 1
loadtime:1.0841798782349 / seconds
Query Executed:select id FROM `va` where city='Swoope' && SIC_code='6021'DB:business_master_new
loadtime:1.0849809646606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swords Creek' limit 1
loadtime:1.0850229263306 / seconds
Query Executed:select id FROM `va` where city='Swords Creek' && SIC_code='6021'DB:business_master_new
loadtime:1.0856199264526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syria' limit 1
loadtime:1.0856659412384 / seconds
Query Executed:select id FROM `va` where city='Syria' && SIC_code='6021'DB:business_master_new
loadtime:1.0860078334808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syringa' limit 1
loadtime:1.086042881012 / seconds
Query Executed:select id FROM `va` where city='Syringa' && SIC_code='6021'DB:business_master_new
loadtime:1.0862967967987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabb' limit 1
loadtime:1.0863349437714 / seconds
Query Executed:select id FROM `va` where city='Tabb' && SIC_code='6021'DB:business_master_new
loadtime:1.0866708755493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangier' limit 1
loadtime:1.0867099761963 / seconds
Query Executed:select id FROM `va` where city='Tangier' && SIC_code='6021'DB:business_master_new
loadtime:1.0872678756714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tannersville' limit 1
loadtime:1.0873107910156 / seconds
Query Executed:select id FROM `va` where city='Tannersville' && SIC_code='6021'DB:business_master_new
loadtime:1.0876100063324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tappahannock' limit 1
loadtime:1.0876379013062 / seconds
Query Executed:select id FROM `va` where city='Tappahannock' && SIC_code='6021'DB:business_master_new
loadtime:1.0890018939972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tasley' limit 1
loadtime:1.0890610218048 / seconds
Query Executed:select id FROM `va` where city='Tasley' && SIC_code='6021'DB:business_master_new
loadtime:1.0896627902985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tazewell' limit 1
loadtime:1.089704990387 / seconds
Query Executed:select id FROM `va` where city='Tazewell' && SIC_code='6021'DB:business_master_new
loadtime:1.0910239219666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperanceville' limit 1
loadtime:1.0910699367523 / seconds
Query Executed:select id FROM `va` where city='Temperanceville' && SIC_code='6021'DB:business_master_new
loadtime:1.0917348861694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:1.091784954071 / seconds
Query Executed:select id FROM `va` where city='Thaxton' && SIC_code='6021'DB:business_master_new
loadtime:1.0925588607788 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Plains' limit 1
loadtime:1.0925948619843 / seconds
Query Executed:select id FROM `va` where city='The Plains' && SIC_code='6021'DB:business_master_new
loadtime:1.0936949253082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:1.0937449932098 / seconds
Query Executed:select id FROM `va` where city='Thornburg' && SIC_code='6021'DB:business_master_new
loadtime:1.0944089889526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberville' limit 1
loadtime:1.094456911087 / seconds
Query Executed:select id FROM `va` where city='Timberville' && SIC_code='6021'DB:business_master_new
loadtime:1.0955967903137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toano' limit 1
loadtime:1.0957310199738 / seconds
Query Executed:select id FROM `va` where city='Toano' && SIC_code='6021'DB:business_master_new
loadtime:1.0970299243927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms Brook' limit 1
loadtime:1.0971620082855 / seconds
Query Executed:select id FROM `va` where city='Toms Brook' && SIC_code='6021'DB:business_master_new
loadtime:1.0982398986816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topping' limit 1
loadtime:1.098335981369 / seconds
Query Executed:select id FROM `va` where city='Topping' && SIC_code='6021'DB:business_master_new
loadtime:1.0993638038635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:1.0994169712067 / seconds
Query Executed:select id FROM `va` where city='Townsend' && SIC_code='6021'DB:business_master_new
loadtime:1.0997447967529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trammel' limit 1
loadtime:1.0997829437256 / seconds
Query Executed:select id FROM `va` where city='Trammel' && SIC_code='6021'DB:business_master_new
loadtime:1.1000289916992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevilians' limit 1
loadtime:1.1000919342041 / seconds
Query Executed:select id FROM `va` where city='Trevilians' && SIC_code='6021'DB:business_master_new
loadtime:1.1004109382629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triangle' limit 1
loadtime:1.1004428863525 / seconds
Query Executed:select id FROM `va` where city='Triangle' && SIC_code='6021'DB:business_master_new
loadtime:1.101588010788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triplet' limit 1
loadtime:1.1016290187836 / seconds
Query Executed:select id FROM `va` where city='Triplet' && SIC_code='6021'DB:business_master_new
loadtime:1.1018838882446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Dale' limit 1
loadtime:1.1019229888916 / seconds
Query Executed:select id FROM `va` where city='Trout Dale' && SIC_code='6021'DB:business_master_new
loadtime:1.1021678447723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:1.1022388935089 / seconds
Query Executed:select id FROM `va` where city='Troutdale' && SIC_code='6021'DB:business_master_new
loadtime:1.1029438972473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutville' limit 1
loadtime:1.1029999256134 / seconds
Query Executed:select id FROM `va` where city='Troutville' && SIC_code='6021'DB:business_master_new
loadtime:1.1042609214783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.1043179035187 / seconds
Query Executed:select id FROM `va` where city='Troy' && SIC_code='6021'DB:business_master_new
loadtime:1.1055018901825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:1.1056079864502 / seconds
Query Executed:select id FROM `va` where city='Turbeville' && SIC_code='6021'DB:business_master_new
loadtime:1.1059160232544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:1.1059567928314 / seconds
Query Executed:select id FROM `va` where city='Tyro' && SIC_code='6021'DB:business_master_new
loadtime:1.1063349246979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Hall' limit 1
loadtime:1.1063718795776 / seconds
Query Executed:select id FROM `va` where city='Union Hall' && SIC_code='6021'DB:business_master_new
loadtime:1.1072478294373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:1.1073038578033 / seconds
Query Executed:select id FROM `va` where city='Unionville' && SIC_code='6021'DB:business_master_new
loadtime:1.1082968711853 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Of Richmond' limit 1
loadtime:1.1083388328552 / seconds
Query Executed:select id FROM `va` where city='University Of Richmond' && SIC_code='6021'DB:business_master_new
loadtime:1.1086139678955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperville' limit 1
loadtime:1.1086578369141 / seconds
Query Executed:select id FROM `va` where city='Upperville' && SIC_code='6021'DB:business_master_new
loadtime:1.1096940040588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbanna' limit 1
loadtime:1.1097350120544 / seconds
Query Executed:select id FROM `va` where city='Urbanna' && SIC_code='6021'DB:business_master_new
loadtime:1.1109030246735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentines' limit 1
loadtime:1.1109628677368 / seconds
Query Executed:select id FROM `va` where city='Valentines' && SIC_code='6021'DB:business_master_new
loadtime:1.1114180088043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vansant' limit 1
loadtime:1.1114640235901 / seconds
Query Executed:select id FROM `va` where city='Vansant' && SIC_code='6021'DB:business_master_new
loadtime:1.1125869750977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Hill' limit 1
loadtime:1.1126430034637 / seconds
Query Executed:select id FROM `va` where city='Vernon Hill' && SIC_code='6021'DB:business_master_new
loadtime:1.1131799221039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:1.1132769584656 / seconds
Query Executed:select id FROM `va` where city='Verona' && SIC_code='6021'DB:business_master_new
loadtime:1.1145498752594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesta' limit 1
loadtime:1.1146099567413 / seconds
Query Executed:select id FROM `va` where city='Vesta' && SIC_code='6021'DB:business_master_new
loadtime:1.1149888038635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesuvius' limit 1
loadtime:1.1150298118591 / seconds
Query Executed:select id FROM `va` where city='Vesuvius' && SIC_code='6021'DB:business_master_new
loadtime:1.1154849529266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:1.1155338287354 / seconds
Query Executed:select id FROM `va` where city='Victoria' && SIC_code='6021'DB:business_master_new
loadtime:1.1166648864746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:1.116721868515 / seconds
Query Executed:select id FROM `va` where city='Vienna' && SIC_code='6021'DB:business_master_new
loadtime:1.1364347934723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viewtown' limit 1
loadtime:1.1365118026733 / seconds
Query Executed:select id FROM `va` where city='Viewtown' && SIC_code='6021'DB:business_master_new
loadtime:1.1368370056152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village' limit 1
loadtime:1.1368808746338 / seconds
Query Executed:select id FROM `va` where city='Village' && SIC_code='6021'DB:business_master_new
loadtime:1.1372900009155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villamont' limit 1
loadtime:1.1374249458313 / seconds
Query Executed:select id FROM `va` where city='Villamont' && SIC_code='6021'DB:business_master_new
loadtime:1.1378269195557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vint Hill Farms' limit 1
loadtime:1.1378679275513 / seconds
Query Executed:select id FROM `va` where city='Vint Hill Farms' && SIC_code='6021'DB:business_master_new
loadtime:1.1381130218506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:1.1381959915161 / seconds
Query Executed:select id FROM `va` where city='Vinton' && SIC_code='6021'DB:business_master_new
loadtime:1.1398370265961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgilina' limit 1
loadtime:1.139899969101 / seconds
Query Executed:select id FROM `va` where city='Virgilina' && SIC_code='6021'DB:business_master_new
loadtime:1.1408169269562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virginia Beach' limit 1
loadtime:1.1408538818359 / seconds
Query Executed:select id FROM `va` where city='Virginia Beach' && SIC_code='6021'DB:business_master_new
loadtime:1.1605579853058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wachapreague' limit 1
loadtime:1.1606619358063 / seconds
Query Executed:select id FROM `va` where city='Wachapreague' && SIC_code='6021'DB:business_master_new
loadtime:1.1612708568573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake' limit 1
loadtime:1.1613199710846 / seconds
Query Executed:select id FROM `va` where city='Wake' && SIC_code='6021'DB:business_master_new
loadtime:1.1617360115051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:1.1617629528046 / seconds
Query Executed:select id FROM `va` where city='Wakefield' && SIC_code='6021'DB:business_master_new
loadtime:1.1630988121033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerton' limit 1
loadtime:1.1631548404694 / seconds
Query Executed:select id FROM `va` where city='Walkerton' && SIC_code='6021'DB:business_master_new
loadtime:1.1636829376221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallops Island' limit 1
loadtime:1.1637120246887 / seconds
Query Executed:select id FROM `va` where city='Wallops Island' && SIC_code='6021'DB:business_master_new
loadtime:1.1643128395081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walters' limit 1
loadtime:1.1643648147583 / seconds
Query Executed:select id FROM `va` where city='Walters' && SIC_code='6021'DB:business_master_new
loadtime:1.1646327972412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardtown' limit 1
loadtime:1.1646637916565 / seconds
Query Executed:select id FROM `va` where city='Wardtown' && SIC_code='6021'DB:business_master_new
loadtime:1.1648998260498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Neck' limit 1
loadtime:1.1649899482727 / seconds
Query Executed:select id FROM `va` where city='Ware Neck' && SIC_code='6021'DB:business_master_new
loadtime:1.1653988361359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warfield' limit 1
loadtime:1.1654298305511 / seconds
Query Executed:select id FROM `va` where city='Warfield' && SIC_code='6021'DB:business_master_new
loadtime:1.165876865387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:1.1659259796143 / seconds
Query Executed:select id FROM `va` where city='Warm Springs' && SIC_code='6021'DB:business_master_new
loadtime:1.1668589115143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:1.1669189929962 / seconds
Query Executed:select id FROM `va` where city='Warner' && SIC_code='6021'DB:business_master_new
loadtime:1.1671798229218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:1.1672129631042 / seconds
Query Executed:select id FROM `va` where city='Warrenton' && SIC_code='6021'DB:business_master_new
loadtime:1.1693489551544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:1.1694118976593 / seconds
Query Executed:select id FROM `va` where city='Warsaw' && SIC_code='6021'DB:business_master_new
loadtime:1.1707220077515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.1707808971405 / seconds
Query Executed:select id FROM `va` where city='Washington' && SIC_code='6021'DB:business_master_new
loadtime:1.1719489097595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water View' limit 1
loadtime:1.1720058917999 / seconds
Query Executed:select id FROM `va` where city='Water View' && SIC_code='6021'DB:business_master_new
loadtime:1.1723449230194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:1.1723909378052 / seconds
Query Executed:select id FROM `va` where city='Waterford' && SIC_code='6021'DB:business_master_new
loadtime:1.1733939647675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:1.1734368801117 / seconds
Query Executed:select id FROM `va` where city='Wattsville' && SIC_code='6021'DB:business_master_new
loadtime:1.1737577915192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.1737968921661 / seconds
Query Executed:select id FROM `va` where city='Waverly' && SIC_code='6021'DB:business_master_new
loadtime:1.1749699115753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:1.1750288009644 / seconds
Query Executed:select id FROM `va` where city='Waynesboro' && SIC_code='6021'DB:business_master_new
loadtime:1.176864862442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weber City' limit 1
loadtime:1.1769368648529 / seconds
Query Executed:select id FROM `va` where city='Weber City' && SIC_code='6021'DB:business_master_new
loadtime:1.1781339645386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weems' limit 1
loadtime:1.17826795578 / seconds
Query Executed:select id FROM `va` where city='Weems' && SIC_code='6021'DB:business_master_new
loadtime:1.1792349815369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirwood' limit 1
loadtime:1.1793758869171 / seconds
Query Executed:select id FROM `va` where city='Weirwood' && SIC_code='6021'DB:business_master_new
loadtime:1.1797318458557 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Augusta' limit 1
loadtime:1.179759979248 / seconds
Query Executed:select id FROM `va` where city='West Augusta' && SIC_code='6021'DB:business_master_new
loadtime:1.1801128387451 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mclean' limit 1
loadtime:1.1802558898926 / seconds
Query Executed:select id FROM `va` where city='West Mclean' && SIC_code='6021'DB:business_master_new
loadtime:1.1808679103851 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:1.1809189319611 / seconds
Query Executed:select id FROM `va` where city='West Point' && SIC_code='6021'DB:business_master_new
loadtime:1.1821908950806 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:1.1823418140411 / seconds
Query Executed:select id FROM `va` where city='West Springfield' && SIC_code='6021'DB:business_master_new
loadtime:1.1826949119568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:1.1827340126038 / seconds
Query Executed:select id FROM `va` where city='Westmoreland' && SIC_code='6021'DB:business_master_new
loadtime:1.1829860210419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyers Cave' limit 1
loadtime:1.1830179691315 / seconds
Query Executed:select id FROM `va` where city='Weyers Cave' && SIC_code='6021'DB:business_master_new
loadtime:1.18417096138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitacre' limit 1
loadtime:1.1842148303986 / seconds
Query Executed:select id FROM `va` where city='Whitacre' && SIC_code='6021'DB:business_master_new
loadtime:1.1844599246979 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Hall' limit 1
loadtime:1.1845028400421 / seconds
Query Executed:select id FROM `va` where city='White Hall' && SIC_code='6021'DB:business_master_new
loadtime:1.1848328113556 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Marsh' limit 1
loadtime:1.1848788261414 / seconds
Query Executed:select id FROM `va` where city='White Marsh' && SIC_code='6021'DB:business_master_new
loadtime:1.1856808662415 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:1.185733795166 / seconds
Query Executed:select id FROM `va` where city='White Plains' && SIC_code='6021'DB:business_master_new
loadtime:1.1861069202423 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Post' limit 1
loadtime:1.1861429214478 / seconds
Query Executed:select id FROM `va` where city='White Post' && SIC_code='6021'DB:business_master_new
loadtime:1.1872339248657 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:1.1873669624329 / seconds
Query Executed:select id FROM `va` where city='White Stone' && SIC_code='6021'DB:business_master_new
loadtime:1.1885988712311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitetop' limit 1
loadtime:1.1886439323425 / seconds
Query Executed:select id FROM `va` where city='Whitetop' && SIC_code='6021'DB:business_master_new
loadtime:1.1891138553619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:1.1892518997192 / seconds
Query Executed:select id FROM `va` where city='Whitewood' && SIC_code='6021'DB:business_master_new
loadtime:1.18971991539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico' limit 1
loadtime:1.1897578239441 / seconds
Query Executed:select id FROM `va` where city='Wicomico' && SIC_code='6021'DB:business_master_new
loadtime:1.1902229785919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico Church' limit 1
loadtime:1.1903338432312 / seconds
Query Executed:select id FROM `va` where city='Wicomico Church' && SIC_code='6021'DB:business_master_new
loadtime:1.1909198760986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.1909689903259 / seconds
Query Executed:select id FROM `va` where city='Williamsburg' && SIC_code='6021'DB:business_master_new
loadtime:1.1941080093384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:1.1942789554596 / seconds
Query Executed:select id FROM `va` where city='Williamsville' && SIC_code='6021'DB:business_master_new
loadtime:1.1946878433228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:1.1947269439697 / seconds
Query Executed:select id FROM `va` where city='Willis' && SIC_code='6021'DB:business_master_new
loadtime:1.1956918239594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis Wharf' limit 1
loadtime:1.1957488059998 / seconds
Query Executed:select id FROM `va` where city='Willis Wharf' && SIC_code='6021'DB:business_master_new
loadtime:1.1961607933044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons' limit 1
loadtime:1.1962819099426 / seconds
Query Executed:select id FROM `va` where city='Wilsons' && SIC_code='6021'DB:business_master_new
loadtime:1.1967179775238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:1.1967599391937 / seconds
Query Executed:select id FROM `va` where city='Winchester' && SIC_code='6021'DB:business_master_new
loadtime:1.1998629570007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.1999368667603 / seconds
Query Executed:select id FROM `va` where city='Windsor' && SIC_code='6021'DB:business_master_new
loadtime:1.2011790275574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingina' limit 1
loadtime:1.2013509273529 / seconds
Query Executed:select id FROM `va` where city='Wingina' && SIC_code='6021'DB:business_master_new
loadtime:1.2017498016357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wintergreen' limit 1
loadtime:1.2017819881439 / seconds
Query Executed:select id FROM `va` where city='Wintergreen' && SIC_code='6021'DB:business_master_new
loadtime:1.202131986618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wirtz' limit 1
loadtime:1.202262878418 / seconds
Query Executed:select id FROM `va` where city='Wirtz' && SIC_code='6021'DB:business_master_new
loadtime:1.2035098075867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:1.2035658359528 / seconds
Query Executed:select id FROM `va` where city='Wise' && SIC_code='6021'DB:business_master_new
loadtime:1.20490193367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withams' limit 1
loadtime:1.2049598693848 / seconds
Query Executed:select id FROM `va` where city='Withams' && SIC_code='6021'DB:business_master_new
loadtime:1.2052698135376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolford' limit 1
loadtime:1.2053048610687 / seconds
Query Executed:select id FROM `va` where city='Wolford' && SIC_code='6021'DB:business_master_new
loadtime:1.2055969238281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolftown' limit 1
loadtime:1.2056279182434 / seconds
Query Executed:select id FROM `va` where city='Wolftown' && SIC_code='6021'DB:business_master_new
loadtime:1.2060308456421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodberry Forest' limit 1
loadtime:1.2060799598694 / seconds
Query Executed:select id FROM `va` where city='Woodberry Forest' && SIC_code='6021'DB:business_master_new
loadtime:1.2063789367676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:1.2064168453217 / seconds
Query Executed:select id FROM `va` where city='Woodbridge' && SIC_code='6021'DB:business_master_new
loadtime:1.2262008190155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:1.2263998985291 / seconds
Query Executed:select id FROM `va` where city='Woodford' && SIC_code='6021'DB:business_master_new
loadtime:1.2278079986572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodlawn' limit 1
loadtime:1.2278568744659 / seconds
Query Executed:select id FROM `va` where city='Woodlawn' && SIC_code='6021'DB:business_master_new
loadtime:1.2289838790894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Rds' limit 1
loadtime:1.2290258407593 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Rds' && SIC_code='6021'DB:business_master_new
loadtime:1.2292718887329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Roads' limit 1
loadtime:1.2293109893799 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Roads' && SIC_code='6021'DB:business_master_new
loadtime:1.2296190261841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.2296578884125 / seconds
Query Executed:select id FROM `va` where city='Woodstock' && SIC_code='6021'DB:business_master_new
loadtime:1.2310838699341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:1.2311429977417 / seconds
Query Executed:select id FROM `va` where city='Woodville' && SIC_code='6021'DB:business_master_new
loadtime:1.2316188812256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolwine' limit 1
loadtime:1.2316508293152 / seconds
Query Executed:select id FROM `va` where city='Woolwine' && SIC_code='6021'DB:business_master_new
loadtime:1.2322800159454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wylliesburg' limit 1
loadtime:1.2323358058929 / seconds
Query Executed:select id FROM `va` where city='Wylliesburg' && SIC_code='6021'DB:business_master_new
loadtime:1.2328519821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wytheville' limit 1
loadtime:1.2328939437866 / seconds
Query Executed:select id FROM `va` where city='Wytheville' && SIC_code='6021'DB:business_master_new
loadtime:1.2345409393311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:1.2346029281616 / seconds
Query Executed:select id FROM `va` where city='Yale' && SIC_code='6021'DB:business_master_new
loadtime:1.2350838184357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:1.2351279258728 / seconds
Query Executed:select id FROM `va` where city='Yorktown' && SIC_code='6021'DB:business_master_new
loadtime:1.2371869087219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zacata' limit 1
loadtime:1.237352848053 / seconds
Query Executed:select id FROM `va` where city='Zacata' && SIC_code='6021'DB:business_master_new
loadtime:1.2377238273621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zanoni' limit 1
loadtime:1.2377669811249 / seconds
Query Executed:select id FROM `va` where city='Zanoni' && SIC_code='6021'DB:business_master_new
loadtime:1.2381808757782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:1.2382910251617 / seconds
Query Executed:select id FROM `va` where city='Zuni' && SIC_code='6021'DB:business_master_new
loadtime:1.2392208576202 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.2394609451294 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.2397630214691 / seconds
Operation template executed (chunk cache operation)
loadtime:1.2399289608002 / seconds
template override:Default
loadtime:1.2399759292603 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.2409029006958 / seconds
Template Constructed, Array Rows:49
loadtime:1.2411658763885 / seconds
TOTAL EXECUTION TIME: 1.24094
loadtime:1.2413909435272 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => national-commercial-banks [stateURLid] => virginia )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


Array ( [0] => cache [1] => query [2] => output [3] => session [4] => db [5] => db2 [6] => dbnew [7] => sphinxsearch [8] => sphinx [9] => dbConn [10] => functions [11] => sphinx_search [12] => template_operations [13] => buildtemplate [14] => syndication_handler [15] => directorystate )


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.2413959503174
TOTAL KEY ARRAYS: 69