Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.3221664428711E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001878023147583 / seconds
host not found setting manual db connection
loadtime:0.0096750259399414 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0099260807037354 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010135173797607 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010200023651123 / seconds
zipcode:
loadtime:0.010227203369141 / seconds
Query Executed:select * from search_referrer where page_hash='1c128e670f405033b39eb707146e7fe7' limit 10 DB:ezrox_toadli
loadtime:0.010462999343872 / seconds
Operation header executed (non global)
loadtime:0.010491132736206 / seconds
Operation leaderboard executed (non global)
loadtime:0.010542154312134 / seconds
Operation square executed (non global)
loadtime:0.010572195053101 / seconds
Operation square_bottom executed (non global)
loadtime:0.010599136352539 / seconds
Operation smallsquare executed (non global)
loadtime:0.010624170303345 / seconds
Operation headeradright executed (non global)
loadtime:0.010650157928467 / seconds
Operation google_analytics executed (non global)
loadtime:0.010673999786377 / seconds
Operation topstories executed (non global)
loadtime:0.010699987411499 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010727167129517 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010751008987427 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011033058166504 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011268138885498 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011304140090942 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011365175247192 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011412143707275 / seconds
Template key: archive_menu pushed
loadtime:0.011421203613281 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011435031890869 / seconds
Template key: get_gravatar pushed
loadtime:0.011442184448242 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011450052261353 / seconds
*10)-10)+1 | start:0
loadtime:0.011490106582642 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.011531114578247 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.011565208435059 / seconds
DB connected to localhost business_master_new
loadtime:0.011831045150757 / seconds
Query Executed:select * from `va_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.01964807510376 / seconds
Query stored in cache : _QUERY_www.toadli.com3c8aa597cf1e5b8014857891d72aebbb
loadtime:0.02338719367981 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.02345609664917 / seconds
Query Executed:select sum(totalcount) as totalsum from `va_catmap` where sic='7231'DB:business_master_new
loadtime:0.028205156326294 / seconds
Query stored in cache : _QUERY_www.toadli.com55ac419821857a30d17398cc67ef9773
loadtime:0.028250217437744 / seconds
942 / 11
loadtime:0.028309106826782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abingdon' limit 1
loadtime:0.02837610244751 / seconds
Query Executed:select id FROM `va` where city='Abingdon' && SIC_code='7231'DB:business_master_new
loadtime:0.10688018798828 / seconds
Query Executed:select * from geodata_geocity where city='Accomac' limit 1DB:business_master_new
loadtime:0.10748100280762 / seconds
Query stored in cache : _QUERY_www.toadli.com4a76fd2a692b1a843886a800e8c695b9
loadtime:0.10755920410156 / seconds
Query Executed:select id FROM `va` where city='Accomac' && SIC_code='7231'DB:business_master_new
loadtime:0.10976815223694 / seconds
Query Executed:select * from geodata_geocity where city='Achilles' limit 1DB:business_master_new
loadtime:0.11021113395691 / seconds
Query stored in cache : _QUERY_www.toadli.comcb2e57dde29ed671255aeadfb4ee2da7
loadtime:0.11027717590332 / seconds
Query Executed:select id FROM `va` where city='Achilles' && SIC_code='7231'DB:business_master_new
loadtime:0.11079812049866 / seconds
Query Executed:select * from geodata_geocity where city='Afton' limit 1DB:business_master_new
loadtime:0.11121416091919 / seconds
Query stored in cache : _QUERY_www.toadli.com750ebf792f3bb5e851cead7fcb58daca
loadtime:0.11127805709839 / seconds
Query Executed:select id FROM `va` where city='Afton' && SIC_code='7231'DB:business_master_new
loadtime:0.11323499679565 / seconds
Query Executed:select * from geodata_geocity where city='Alberta' limit 1DB:business_master_new
loadtime:0.11362910270691 / seconds
Query stored in cache : _QUERY_www.toadli.comfb920e5637998db0226f62a8abc504e7
loadtime:0.11369204521179 / seconds
Query Executed:select id FROM `va` where city='Alberta' && SIC_code='7231'DB:business_master_new
loadtime:0.11474800109863 / seconds
Query Executed:select * from geodata_geocity where city='Aldie' limit 1DB:business_master_new
loadtime:0.11518621444702 / seconds
Query stored in cache : _QUERY_www.toadli.com39d9d1d3a3c33b9186556ca5648450b4
loadtime:0.11525106430054 / seconds
Query Executed:select id FROM `va` where city='Aldie' && SIC_code='7231'DB:business_master_new
loadtime:0.11741304397583 / seconds
Query Executed:select * from geodata_geocity where city='Alexandria' limit 1DB:business_master_new
loadtime:0.11785221099854 / seconds
Query stored in cache : _QUERY_www.toadli.com8ef56321ea78509b61968613561384ce
loadtime:0.1179211139679 / seconds
Query Executed:select id FROM `va` where city='Alexandria' && SIC_code='7231'DB:business_master_new
loadtime:0.28914308547974 / seconds
Query Executed:select * from geodata_geocity where city='Alleghany' limit 1DB:business_master_new
loadtime:0.29017114639282 / seconds
Query stored in cache : _QUERY_www.toadli.com53f732c1cecbd6e60487e4579177ae44
loadtime:0.29024815559387 / seconds
Query Executed:select id FROM `va` where city='Alleghany' && SIC_code='7231'DB:business_master_new
loadtime:0.29072904586792 / seconds
Query Executed:select * from geodata_geocity where city='Allisonia' limit 1DB:business_master_new
loadtime:0.29118013381958 / seconds
Query stored in cache : _QUERY_www.toadli.com5080233e5607aacfba4b1255a27997be
loadtime:0.29125118255615 / seconds
Query Executed:select id FROM `va` where city='Allisonia' && SIC_code='7231'DB:business_master_new
loadtime:0.29167699813843 / seconds
Query Executed:select * from geodata_geocity where city='Altavista' limit 1DB:business_master_new
loadtime:0.292160987854 / seconds
Query stored in cache : _QUERY_www.toadli.com4d540593ba7ee4199cdef277a501da11
loadtime:0.29222702980042 / seconds
Query Executed:select id FROM `va` where city='Altavista' && SIC_code='7231'DB:business_master_new
loadtime:0.29671406745911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.29680204391479 / seconds
Query Executed:select id FROM `va` where city='Alton' && SIC_code='7231'DB:business_master_new
loadtime:0.29785418510437 / seconds
Query Executed:select * from geodata_geocity where city='Alum Ridge' limit 1DB:business_master_new
loadtime:0.29827618598938 / seconds
Query stored in cache : _QUERY_www.toadli.com14a40e073bc8f11d7a9cca14b2814dd1
loadtime:0.29834008216858 / seconds
Query Executed:select id FROM `va` where city='Alum Ridge' && SIC_code='7231'DB:business_master_new
loadtime:0.29875302314758 / seconds
Query Executed:select * from geodata_geocity where city='Amelia Court House' limit 1DB:business_master_new
loadtime:0.29917907714844 / seconds
Query stored in cache : _QUERY_www.toadli.comdfcad32a654bf615384944ca33a5c843
loadtime:0.29924416542053 / seconds
Query Executed:select id FROM `va` where city='Amelia Court House' && SIC_code='7231'DB:business_master_new
loadtime:0.3760130405426 / seconds
Query Executed:select * from geodata_geocity where city='Amelia Court Hse' limit 1DB:business_master_new
loadtime:0.3766040802002 / seconds
Query stored in cache : _QUERY_www.toadli.com9cde5f15223f5b451aebe757b301b5c5
loadtime:0.37668800354004 / seconds
Query Executed:select id FROM `va` where city='Amelia Court Hse' && SIC_code='7231'DB:business_master_new
loadtime:0.37738108634949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.3774471282959 / seconds
Query Executed:select id FROM `va` where city='Amherst' && SIC_code='7231'DB:business_master_new
loadtime:0.45361304283142 / seconds
Query Executed:select * from geodata_geocity where city='Amissville' limit 1DB:business_master_new
loadtime:0.45419812202454 / seconds
Query stored in cache : _QUERY_www.toadli.com9a62ba4acd0fa1e8019b9e423ff78eee
loadtime:0.4542670249939 / seconds
Query Executed:select id FROM `va` where city='Amissville' && SIC_code='7231'DB:business_master_new
loadtime:0.45659017562866 / seconds
Query Executed:select * from geodata_geocity where city='Ammon' limit 1DB:business_master_new
loadtime:0.45706701278687 / seconds
Query stored in cache : _QUERY_www.toadli.com018a89f3e0c91e561387f8ebd3f9a6a3
loadtime:0.45713305473328 / seconds
Query Executed:select id FROM `va` where city='Ammon' && SIC_code='7231'DB:business_master_new
loadtime:0.45757412910461 / seconds
Query Executed:select * from geodata_geocity where city='Amonate' limit 1DB:business_master_new
loadtime:0.45799207687378 / seconds
Query stored in cache : _QUERY_www.toadli.comdede7fd2380f743223ce4e873deebd2f
loadtime:0.45806407928467 / seconds
Query Executed:select id FROM `va` where city='Amonate' && SIC_code='7231'DB:business_master_new
loadtime:0.4585440158844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.45859909057617 / seconds
Query Executed:select id FROM `va` where city='Andover' && SIC_code='7231'DB:business_master_new
loadtime:0.45913815498352 / seconds
Query Executed:select * from geodata_geocity where city='Annandale' limit 1DB:business_master_new
loadtime:0.45959711074829 / seconds
Query stored in cache : _QUERY_www.toadli.come46ae50e06a0685fd1cfb2684387ca9e
loadtime:0.45966100692749 / seconds
Query Executed:select id FROM `va` where city='Annandale' && SIC_code='7231'DB:business_master_new
loadtime:0.49542498588562 / seconds
Query Executed:select * from geodata_geocity where city='Appalachia' limit 1DB:business_master_new
loadtime:0.49598598480225 / seconds
Query stored in cache : _QUERY_www.toadli.com1b7790fffd05855e98cf2425e1e69786
loadtime:0.4960629940033 / seconds
Query Executed:select id FROM `va` where city='Appalachia' && SIC_code='7231'DB:business_master_new
loadtime:0.49755311012268 / seconds
Query Executed:select * from geodata_geocity where city='Appomattox' limit 1DB:business_master_new
loadtime:0.49798798561096 / seconds
Query stored in cache : _QUERY_www.toadli.com4cf8ab823f456772a91fac977e0a42da
loadtime:0.49806213378906 / seconds
Query Executed:select id FROM `va` where city='Appomattox' && SIC_code='7231'DB:business_master_new
loadtime:0.50338506698608 / seconds
Query Executed:select * from geodata_geocity where city='Ararat' limit 1DB:business_master_new
loadtime:0.50383400917053 / seconds
Query stored in cache : _QUERY_www.toadli.comc66246ce4fdc7919520c7a56e281b569
loadtime:0.50390315055847 / seconds
Query Executed:select id FROM `va` where city='Ararat' && SIC_code='7231'DB:business_master_new
loadtime:0.50514006614685 / seconds
Query Executed:select * from geodata_geocity where city='Arcola' limit 1DB:business_master_new
loadtime:0.50556707382202 / seconds
Query stored in cache : _QUERY_www.toadli.com47592d08128deec883f3a8f00ea7b89c
loadtime:0.5056300163269 / seconds
Query Executed:select id FROM `va` where city='Arcola' && SIC_code='7231'DB:business_master_new
loadtime:0.50630617141724 / seconds
Query Executed:select * from geodata_geocity where city='Ark' limit 1DB:business_master_new
loadtime:0.5067081451416 / seconds
Query stored in cache : _QUERY_www.toadli.com23030dacbdac5a38016ccc89bc432b9a
loadtime:0.5067720413208 / seconds
Query Executed:select id FROM `va` where city='Ark' && SIC_code='7231'DB:business_master_new
loadtime:0.50737309455872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.5074291229248 / seconds
Query Executed:select id FROM `va` where city='Arlington' && SIC_code='7231'DB:business_master_new
loadtime:0.62434816360474 / seconds
Query Executed:select * from geodata_geocity where city='Aroda' limit 1DB:business_master_new
loadtime:0.6252281665802 / seconds
Query stored in cache : _QUERY_www.toadli.comacd3ce7fcfb4e27a71a885b017244da4
loadtime:0.62530422210693 / seconds
Query Executed:select id FROM `va` where city='Aroda' && SIC_code='7231'DB:business_master_new
loadtime:0.62598705291748 / seconds
Query Executed:select * from geodata_geocity where city='Arrington' limit 1DB:business_master_new
loadtime:0.62639713287354 / seconds
Query stored in cache : _QUERY_www.toadli.comc623ceaf785251ff1d38f5ad5ef124ee
loadtime:0.62646412849426 / seconds
Query Executed:select id FROM `va` where city='Arrington' && SIC_code='7231'DB:business_master_new
loadtime:0.627681016922 / seconds
Query Executed:select * from geodata_geocity where city='Arvonia' limit 1DB:business_master_new
loadtime:0.6281361579895 / seconds
Query stored in cache : _QUERY_www.toadli.com588978c17e084a2299800e30d331f77e
loadtime:0.62820100784302 / seconds
Query Executed:select id FROM `va` where city='Arvonia' && SIC_code='7231'DB:business_master_new
loadtime:0.62889504432678 / seconds
Query Executed:select * from geodata_geocity where city='Ashburn' limit 1DB:business_master_new
loadtime:0.62933707237244 / seconds
Query stored in cache : _QUERY_www.toadli.com5bd0eee92e498ba2e9745e7d7ccbbfcd
loadtime:0.62940216064453 / seconds
Query Executed:select id FROM `va` where city='Ashburn' && SIC_code='7231'DB:business_master_new
loadtime:0.65261816978455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.65272903442383 / seconds
Query Executed:select id FROM `va` where city='Ashland' && SIC_code='7231'DB:business_master_new
loadtime:0.67737221717834 / seconds
Query Executed:select * from geodata_geocity where city='Assawoman' limit 1DB:business_master_new
loadtime:0.67796015739441 / seconds
Query stored in cache : _QUERY_www.toadli.come40349bdc015152c67ef8e11ae6cc628
loadtime:0.6780481338501 / seconds
Query Executed:select id FROM `va` where city='Assawoman' && SIC_code='7231'DB:business_master_new
loadtime:0.67845821380615 / seconds
Query Executed:select * from geodata_geocity where city='Atkins' limit 1DB:business_master_new
loadtime:0.67886805534363 / seconds
Query stored in cache : _QUERY_www.toadli.com0888029435c25bafd5dc588bf7bbfd53
loadtime:0.6789391040802 / seconds
Query Executed:select id FROM `va` where city='Atkins' && SIC_code='7231'DB:business_master_new
loadtime:0.68014121055603 / seconds
Query Executed:select * from geodata_geocity where city='Atlantic' limit 1DB:business_master_new
loadtime:0.68064403533936 / seconds
Query stored in cache : _QUERY_www.toadli.com5a7670c3a0a3a96f0bb8a7adfc30e514
loadtime:0.68070816993713 / seconds
Query Executed:select id FROM `va` where city='Atlantic' && SIC_code='7231'DB:business_master_new
loadtime:0.68142604827881 / seconds
Query Executed:select * from geodata_geocity where city='Augusta Springs' limit 1DB:business_master_new
loadtime:0.68186616897583 / seconds
Query stored in cache : _QUERY_www.toadli.com0518ebe7c3f8a19947a59abe2b33379b
loadtime:0.68193411827087 / seconds
Query Executed:select id FROM `va` where city='Augusta Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.68236017227173 / seconds
Query Executed:select * from geodata_geocity where city='Austinville' limit 1DB:business_master_new
loadtime:0.68279504776001 / seconds
Query stored in cache : _QUERY_www.toadli.com26252d9ca767d54493148628766d99af
loadtime:0.68285918235779 / seconds
Query Executed:select id FROM `va` where city='Austinville' && SIC_code='7231'DB:business_master_new
loadtime:0.6838641166687 / seconds
Query Executed:select * from geodata_geocity where city='Axton' limit 1DB:business_master_new
loadtime:0.68429112434387 / seconds
Query stored in cache : _QUERY_www.toadli.comd49e6b92fde886958529b9de33aeffdd
loadtime:0.68435502052307 / seconds
Query Executed:select id FROM `va` where city='Axton' && SIC_code='7231'DB:business_master_new
loadtime:0.6865701675415 / seconds
Query Executed:select * from geodata_geocity where city='Aylett' limit 1DB:business_master_new
loadtime:0.68699812889099 / seconds
Query stored in cache : _QUERY_www.toadli.comedfed2d79312b0846ddaf8f108131430
loadtime:0.68707299232483 / seconds
Query Executed:select id FROM `va` where city='Aylett' && SIC_code='7231'DB:business_master_new
loadtime:0.68928909301758 / seconds
Query Executed:select * from geodata_geocity where city='Bacova' limit 1DB:business_master_new
loadtime:0.68967199325562 / seconds
Query stored in cache : _QUERY_www.toadli.com28ef04b9ad3e31c36998c7ce1baf5723
loadtime:0.68973708152771 / seconds
Query Executed:select id FROM `va` where city='Bacova' && SIC_code='7231'DB:business_master_new
loadtime:0.69019317626953 / seconds
Query Executed:select * from geodata_geocity where city='Baileys Crossrds' limit 1DB:business_master_new
loadtime:0.69057703018188 / seconds
Query stored in cache : _QUERY_www.toadli.com9f938fbb71ee3e8312f1495fe962c9f2
loadtime:0.69064807891846 / seconds
Query Executed:select id FROM `va` where city='Baileys Crossrds' && SIC_code='7231'DB:business_master_new
loadtime:0.69115805625916 / seconds
Query Executed:select * from geodata_geocity where city='Banco' limit 1DB:business_master_new
loadtime:0.69157910346985 / seconds
Query stored in cache : _QUERY_www.toadli.com7109eced64c6c6d7eae42401b9901f33
loadtime:0.69164204597473 / seconds
Query Executed:select id FROM `va` where city='Banco' && SIC_code='7231'DB:business_master_new
loadtime:0.69209408760071 / seconds
Query Executed:select * from geodata_geocity where city='Bandy' limit 1DB:business_master_new
loadtime:0.69250917434692 / seconds
Query stored in cache : _QUERY_www.toadli.comdf8d18c66c0af046b48b8249d91c5951
loadtime:0.69257116317749 / seconds
Query Executed:select id FROM `va` where city='Bandy' && SIC_code='7231'DB:business_master_new
loadtime:0.69306612014771 / seconds
Query Executed:select * from geodata_geocity where city='Barboursville' limit 1DB:business_master_new
loadtime:0.69349002838135 / seconds
Query stored in cache : _QUERY_www.toadli.comac61609d4a173f496d9cae55133509d7
loadtime:0.69355320930481 / seconds
Query Executed:select id FROM `va` where city='Barboursville' && SIC_code='7231'DB:business_master_new
loadtime:0.695228099823 / seconds
Query Executed:select * from geodata_geocity where city='Barhamsville' limit 1DB:business_master_new
loadtime:0.69565510749817 / seconds
Query stored in cache : _QUERY_www.toadli.com3ad4b046d4703f1c827a7be918934d85
loadtime:0.69571900367737 / seconds
Query Executed:select id FROM `va` where city='Barhamsville' && SIC_code='7231'DB:business_master_new
loadtime:0.69655013084412 / seconds
Query Executed:select * from geodata_geocity where city='Barren Springs' limit 1DB:business_master_new
loadtime:0.69694805145264 / seconds
Query stored in cache : _QUERY_www.toadli.com765482dad8a34391146deeb119c4f3fa
loadtime:0.69701218605042 / seconds
Query Executed:select id FROM `va` where city='Barren Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.69753503799438 / seconds
Query Executed:select * from geodata_geocity where city='Baskerville' limit 1DB:business_master_new
loadtime:0.69797015190125 / seconds
Query stored in cache : _QUERY_www.toadli.combd33fa40cb65392b81f59e13543752dc
loadtime:0.69804906845093 / seconds
Query Executed:select id FROM `va` where city='Baskerville' && SIC_code='7231'DB:business_master_new
loadtime:0.69872808456421 / seconds
Query Executed:select * from geodata_geocity where city='Bassett' limit 1DB:business_master_new
loadtime:0.69918012619019 / seconds
Query stored in cache : _QUERY_www.toadli.com20d1d27dfeccb70cc2c1a03c346c6765
loadtime:0.69924402236938 / seconds
Query Executed:select id FROM `va` where city='Bassett' && SIC_code='7231'DB:business_master_new
loadtime:0.7758572101593 / seconds
Query Executed:select * from geodata_geocity where city='Bastian' limit 1DB:business_master_new
loadtime:0.77643013000488 / seconds
Query stored in cache : _QUERY_www.toadli.com2aa7f8ec09d9a09f1fc0bd8b92825c58
loadtime:0.77650499343872 / seconds
Query Executed:select id FROM `va` where city='Bastian' && SIC_code='7231'DB:business_master_new
loadtime:0.77737021446228 / seconds
Query Executed:select * from geodata_geocity where city='Basye' limit 1DB:business_master_new
loadtime:0.77780914306641 / seconds
Query stored in cache : _QUERY_www.toadli.com1f14c026a65c3c0d1a7e646341a5c208
loadtime:0.77787709236145 / seconds
Query Executed:select id FROM `va` where city='Basye' && SIC_code='7231'DB:business_master_new
loadtime:0.77895522117615 / seconds
Query Executed:select * from geodata_geocity where city='Batesville' limit 1DB:business_master_new
loadtime:0.77939915657043 / seconds
Query stored in cache : _QUERY_www.toadli.come77b13af4b726f51ab911d8783411f7c
loadtime:0.77946519851685 / seconds
Query Executed:select id FROM `va` where city='Batesville' && SIC_code='7231'DB:business_master_new
loadtime:0.78002214431763 / seconds
Query Executed:select * from geodata_geocity where city='Battery Park' limit 1DB:business_master_new
loadtime:0.78047513961792 / seconds
Query stored in cache : _QUERY_www.toadli.coma02a95a8555da965811d8cd967f9a406
loadtime:0.78054308891296 / seconds
Query Executed:select id FROM `va` where city='Battery Park' && SIC_code='7231'DB:business_master_new
loadtime:0.78101515769958 / seconds
Query Executed:select * from geodata_geocity where city='Bavon' limit 1DB:business_master_new
loadtime:0.78141903877258 / seconds
Query stored in cache : _QUERY_www.toadli.comdefc26ef67027d3ef3df54d3c0e5b195
loadtime:0.78148102760315 / seconds
Query Executed:select id FROM `va` where city='Bavon' && SIC_code='7231'DB:business_master_new
loadtime:0.78189420700073 / seconds
Query Executed:select * from geodata_geocity where city='Bealeton' limit 1DB:business_master_new
loadtime:0.78231406211853 / seconds
Query stored in cache : _QUERY_www.toadli.comcb73d4431742a50e9c8b43d16cd08f40
loadtime:0.78237819671631 / seconds
Query Executed:select id FROM `va` where city='Bealeton' && SIC_code='7231'DB:business_master_new
loadtime:0.78566312789917 / seconds
Query Executed:select * from geodata_geocity where city='Beaumont' limit 1DB:business_master_new
loadtime:0.78613519668579 / seconds
Query stored in cache : _QUERY_www.toadli.com0343b0ee2e2cd4cf21415ad678f7f531
loadtime:0.78620409965515 / seconds
Query Executed:select id FROM `va` where city='Beaumont' && SIC_code='7231'DB:business_master_new
loadtime:0.78662419319153 / seconds
Query Executed:select * from geodata_geocity where city='Beaverdam' limit 1DB:business_master_new
loadtime:0.78702306747437 / seconds
Query stored in cache : _QUERY_www.toadli.comdbf6c63e6e3132bc236b48f9cc71bba8
loadtime:0.78709721565247 / seconds
Query Executed:select id FROM `va` where city='Beaverdam' && SIC_code='7231'DB:business_master_new
loadtime:0.7887761592865 / seconds
Query Executed:select * from geodata_geocity where city='Beaverlett' limit 1DB:business_master_new
loadtime:0.78920102119446 / seconds
Query stored in cache : _QUERY_www.toadli.com547ac9ce47d42e8b45e05dc40db3fcf8
loadtime:0.78926420211792 / seconds
Query Executed:select id FROM `va` where city='Beaverlett' && SIC_code='7231'DB:business_master_new
loadtime:0.78965306282043 / seconds
Query Executed:select * from geodata_geocity where city='Bedford' limit 1DB:business_master_new
loadtime:0.79007315635681 / seconds
Query stored in cache : _QUERY_www.toadli.com9e83f75e7728777412daa94759d94266
loadtime:0.79013800621033 / seconds
Query Executed:select id FROM `va` where city='Bedford' && SIC_code='7231'DB:business_master_new
loadtime:0.80704808235168 / seconds
Query Executed:select * from geodata_geocity where city='Bee' limit 1DB:business_master_new
loadtime:0.80752110481262 / seconds
Query stored in cache : _QUERY_www.toadli.com881c34392a9a0758dc2cdb8275c63c59
loadtime:0.80758500099182 / seconds
Query Executed:select id FROM `va` where city='Bee' && SIC_code='7231'DB:business_master_new
loadtime:0.8080530166626 / seconds
Query Executed:select * from geodata_geocity where city='Bellamy' limit 1DB:business_master_new
loadtime:0.80845618247986 / seconds
Query stored in cache : _QUERY_www.toadli.com5b31f6514400d8b2c11a31afc122a2ce
loadtime:0.80852007865906 / seconds
Query Executed:select id FROM `va` where city='Bellamy' && SIC_code='7231'DB:business_master_new
loadtime:0.80890703201294 / seconds
Query Executed:select * from geodata_geocity where city='Belle Haven' limit 1DB:business_master_new
loadtime:0.8093090057373 / seconds
Query stored in cache : _QUERY_www.toadli.com7d38dd5344e65f4134a29673dc4e3761
loadtime:0.80937504768372 / seconds
Query Executed:select id FROM `va` where city='Belle Haven' && SIC_code='7231'DB:business_master_new
loadtime:0.81079411506653 / seconds
Query Executed:select * from geodata_geocity where city='Belspring' limit 1DB:business_master_new
loadtime:0.81127715110779 / seconds
Query stored in cache : _QUERY_www.toadli.comf9bdf436bfb17160a5ef3b564f32dea0
loadtime:0.81134605407715 / seconds
Query Executed:select id FROM `va` where city='Belspring' && SIC_code='7231'DB:business_master_new
loadtime:0.81180620193481 / seconds
Query Executed:select * from geodata_geocity where city='Ben Hur' limit 1DB:business_master_new
loadtime:0.8122022151947 / seconds
Query stored in cache : _QUERY_www.toadli.com83771a597d28ebc5432f60e7ac855010
loadtime:0.81227111816406 / seconds
Query Executed:select id FROM `va` where city='Ben Hur' && SIC_code='7231'DB:business_master_new
loadtime:0.81275820732117 / seconds
Query Executed:select * from geodata_geocity where city='Bena' limit 1DB:business_master_new
loadtime:0.81315422058105 / seconds
Query stored in cache : _QUERY_www.toadli.comf7088364513abbad8b08951a75c419dc
loadtime:0.81322002410889 / seconds
Query Executed:select id FROM `va` where city='Bena' && SIC_code='7231'DB:business_master_new
loadtime:0.81381011009216 / seconds
Query Executed:select * from geodata_geocity where city='Bent Mountain' limit 1DB:business_master_new
loadtime:0.81424117088318 / seconds
Query stored in cache : _QUERY_www.toadli.com620cce376129dc23c10e98c8462135c7
loadtime:0.81431102752686 / seconds
Query Executed:select id FROM `va` where city='Bent Mountain' && SIC_code='7231'DB:business_master_new
loadtime:0.81524705886841 / seconds
Query Executed:select * from geodata_geocity where city='Bentonville' limit 1DB:business_master_new
loadtime:0.81566119194031 / seconds
Query stored in cache : _QUERY_www.toadli.comb4edaf05d185ff799de93868f70b0842
loadtime:0.81572413444519 / seconds
Query Executed:select id FROM `va` where city='Bentonville' && SIC_code='7231'DB:business_master_new
loadtime:0.81689214706421 / seconds
Query Executed:select * from geodata_geocity where city='Bergton' limit 1DB:business_master_new
loadtime:0.8173360824585 / seconds
Query stored in cache : _QUERY_www.toadli.com7561a8c8469b47cfd960c5de9680899b
loadtime:0.81740498542786 / seconds
Query Executed:select id FROM `va` where city='Bergton' && SIC_code='7231'DB:business_master_new
loadtime:0.8180091381073 / seconds
Query Executed:select * from geodata_geocity where city='Berryville' limit 1DB:business_master_new
loadtime:0.8184220790863 / seconds
Query stored in cache : _QUERY_www.toadli.com03ef35442b03990448be9807e797ef3f
loadtime:0.81848621368408 / seconds
Query Executed:select id FROM `va` where city='Berryville' && SIC_code='7231'DB:business_master_new
loadtime:0.89468002319336 / seconds
Query Executed:select * from geodata_geocity where city='Big Island' limit 1DB:business_master_new
loadtime:0.89520120620728 / seconds
Query stored in cache : _QUERY_www.toadli.com38f39025cc89e02bf0bf1244e1c2fccb
loadtime:0.895268201828 / seconds
Query Executed:select id FROM `va` where city='Big Island' && SIC_code='7231'DB:business_master_new
loadtime:0.89631509780884 / seconds
Query Executed:select * from geodata_geocity where city='Big Rock' limit 1DB:business_master_new
loadtime:0.89672517776489 / seconds
Query stored in cache : _QUERY_www.toadli.com3950604a3457edeeb2ebe70db830c65f
loadtime:0.89679408073425 / seconds
Query Executed:select id FROM `va` where city='Big Rock' && SIC_code='7231'DB:business_master_new
loadtime:0.89763307571411 / seconds
Query Executed:select * from geodata_geocity where city='Big Stone Gap' limit 1DB:business_master_new
loadtime:0.89807510375977 / seconds
Query stored in cache : _QUERY_www.toadli.com4a239245810e107042b0ec0538545a68
loadtime:0.89813899993896 / seconds
Query Executed:select id FROM `va` where city='Big Stone Gap' && SIC_code='7231'DB:business_master_new
loadtime:0.97445917129517 / seconds
Query Executed:select * from geodata_geocity where city='Birchleaf' limit 1DB:business_master_new
loadtime:0.97501921653748 / seconds
Query stored in cache : _QUERY_www.toadli.combecabd79d0b16b5dac9ba23085a2e7b8
loadtime:0.97509908676147 / seconds
Query Executed:select id FROM `va` where city='Birchleaf' && SIC_code='7231'DB:business_master_new
loadtime:0.97572708129883 / seconds
Query Executed:select * from geodata_geocity where city='Birdsnest' limit 1DB:business_master_new
loadtime:0.97616600990295 / seconds
Query stored in cache : _QUERY_www.toadli.com6e28512f1e81d305a5550a36c5ad99fe
loadtime:0.97623205184937 / seconds
Query Executed:select id FROM `va` where city='Birdsnest' && SIC_code='7231'DB:business_master_new
loadtime:0.97681617736816 / seconds
Query Executed:select * from geodata_geocity where city='Bishop' limit 1DB:business_master_new
loadtime:0.97728300094604 / seconds
Query stored in cache : _QUERY_www.toadli.com6d2eede016c1f91cd43aa92ec100257b
loadtime:0.97734904289246 / seconds
Query Executed:select id FROM `va` where city='Bishop' && SIC_code='7231'DB:business_master_new
loadtime:0.977872133255 / seconds
Query Executed:select * from geodata_geocity where city='Blackridge' limit 1DB:business_master_new
loadtime:0.97824215888977 / seconds
Query stored in cache : _QUERY_www.toadli.comc53fe9057df2fe2683b4e430e1118a8d
loadtime:0.97830605506897 / seconds
Query Executed:select id FROM `va` where city='Blackridge' && SIC_code='7231'DB:business_master_new
loadtime:0.97878909111023 / seconds
Query Executed:select * from geodata_geocity where city='Blacksburg' limit 1DB:business_master_new
loadtime:0.97916102409363 / seconds
Query stored in cache : _QUERY_www.toadli.com518d2dcedd6eb420cd0024dc16e7b6de
loadtime:0.97922611236572 / seconds
Query Executed:select id FROM `va` where city='Blacksburg' && SIC_code='7231'DB:business_master_new
loadtime:1.0039350986481 / seconds
Query Executed:select * from geodata_geocity where city='Blackstone' limit 1DB:business_master_new
loadtime:1.004387140274 / seconds
Query stored in cache : _QUERY_www.toadli.comea09d4d3da061dff455b1612a3d62222
loadtime:1.0044541358948 / seconds
Query Executed:select id FROM `va` where city='Blackstone' && SIC_code='7231'DB:business_master_new
loadtime:1.0805811882019 / seconds
Query Executed:select * from geodata_geocity where city='Blackwater' limit 1DB:business_master_new
loadtime:1.0810890197754 / seconds
Query stored in cache : _QUERY_www.toadli.com87695e83cf6ccdcd7ba06fcdc080f101
loadtime:1.0811560153961 / seconds
Query Executed:select id FROM `va` where city='Blackwater' && SIC_code='7231'DB:business_master_new
loadtime:1.0817620754242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairs' limit 1
loadtime:1.081826210022 / seconds
Query Executed:select id FROM `va` where city='Blairs' && SIC_code='7231'DB:business_master_new
loadtime:1.0834941864014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakes' limit 1
loadtime:1.0835649967194 / seconds
Query Executed:select id FROM `va` where city='Blakes' && SIC_code='7231'DB:business_master_new
loadtime:1.0839891433716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bland' limit 1
loadtime:1.0840530395508 / seconds
Query Executed:select id FROM `va` where city='Bland' && SIC_code='7231'DB:business_master_new
loadtime:1.0859351158142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloxom' limit 1
loadtime:1.0860071182251 / seconds
Query Executed:select id FROM `va` where city='Bloxom' && SIC_code='7231'DB:business_master_new
loadtime:1.0868241786957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:1.0868961811066 / seconds
Query Executed:select id FROM `va` where city='Blue Grass' && SIC_code='7231'DB:business_master_new
loadtime:1.0876140594482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Ridge' limit 1
loadtime:1.0876820087433 / seconds
Query Executed:select id FROM `va` where city='Blue Ridge' && SIC_code='7231'DB:business_master_new
loadtime:1.0896461009979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:1.0897190570831 / seconds
Query Executed:select id FROM `va` where city='Bluefield' && SIC_code='7231'DB:business_master_new
loadtime:1.1649720668793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluemont' limit 1
loadtime:1.1651401519775 / seconds
Query Executed:select id FROM `va` where city='Bluemont' && SIC_code='7231'DB:business_master_new
loadtime:1.1669611930847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bohannon' limit 1
loadtime:1.1670300960541 / seconds
Query Executed:select id FROM `va` where city='Bohannon' && SIC_code='7231'DB:business_master_new
loadtime:1.1674671173096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boissevain' limit 1
loadtime:1.1675281524658 / seconds
Query Executed:select id FROM `va` where city='Boissevain' && SIC_code='7231'DB:business_master_new
loadtime:1.1680340766907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolar' limit 1
loadtime:1.1680932044983 / seconds
Query Executed:select id FROM `va` where city='Bolar' && SIC_code='7231'DB:business_master_new
loadtime:1.1684620380402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:1.1685171127319 / seconds
Query Executed:select id FROM `va` where city='Bon Air' && SIC_code='7231'DB:business_master_new
loadtime:1.1692872047424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boones Mill' limit 1
loadtime:1.169340133667 / seconds
Query Executed:select id FROM `va` where city='Boones Mill' && SIC_code='7231'DB:business_master_new
loadtime:1.1722810268402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:1.1723520755768 / seconds
Query Executed:select id FROM `va` where city='Boston' && SIC_code='7231'DB:business_master_new
loadtime:1.1730670928955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:1.1731221675873 / seconds
Query Executed:select id FROM `va` where city='Bowling Green' && SIC_code='7231'DB:business_master_new
loadtime:1.176078081131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyce' limit 1
loadtime:1.1761541366577 / seconds
Query Executed:select id FROM `va` where city='Boyce' && SIC_code='7231'DB:business_master_new
loadtime:1.177707195282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boydton' limit 1
loadtime:1.1777670383453 / seconds
Query Executed:select id FROM `va` where city='Boydton' && SIC_code='7231'DB:business_master_new
loadtime:1.1796531677246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykins' limit 1
loadtime:1.1797211170197 / seconds
Query Executed:select id FROM `va` where city='Boykins' && SIC_code='7231'DB:business_master_new
loadtime:1.180831193924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bracey' limit 1
loadtime:1.1809051036835 / seconds
Query Executed:select id FROM `va` where city='Bracey' && SIC_code='7231'DB:business_master_new
loadtime:1.1826770305634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:1.182745218277 / seconds
Query Executed:select id FROM `va` where city='Branchville' && SIC_code='7231'DB:business_master_new
loadtime:1.1833531856537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandy Station' limit 1
loadtime:1.1834180355072 / seconds
Query Executed:select id FROM `va` where city='Brandy Station' && SIC_code='7231'DB:business_master_new
loadtime:1.1844871044159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breaks' limit 1
loadtime:1.1845409870148 / seconds
Query Executed:select id FROM `va` where city='Breaks' && SIC_code='7231'DB:business_master_new
loadtime:1.1850621700287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremo Bluff' limit 1
loadtime:1.1851141452789 / seconds
Query Executed:select id FROM `va` where city='Bremo Bluff' && SIC_code='7231'DB:business_master_new
loadtime:1.1856541633606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:1.1857089996338 / seconds
Query Executed:select id FROM `va` where city='Bridgewater' && SIC_code='7231'DB:business_master_new
loadtime:1.1892549991608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:1.1893291473389 / seconds
Query Executed:select id FROM `va` where city='Brightwood' && SIC_code='7231'DB:business_master_new
loadtime:1.1900100708008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:1.1900842189789 / seconds
Query Executed:select id FROM `va` where city='Bristol' && SIC_code='7231'DB:business_master_new
loadtime:1.2129111289978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:1.2131061553955 / seconds
Query Executed:select id FROM `va` where city='Bristow' && SIC_code='7231'DB:business_master_new
loadtime:1.216569185257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Run' limit 1
loadtime:1.2166471481323 / seconds
Query Executed:select id FROM `va` where city='Broad Run' && SIC_code='7231'DB:business_master_new
loadtime:1.2178390026093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadford' limit 1
loadtime:1.2179110050201 / seconds
Query Executed:select id FROM `va` where city='Broadford' && SIC_code='7231'DB:business_master_new
loadtime:1.2183611392975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:1.218414068222 / seconds
Query Executed:select id FROM `va` where city='Broadway' && SIC_code='7231'DB:business_master_new
loadtime:1.2933161258698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodnax' limit 1
loadtime:1.2934331893921 / seconds
Query Executed:select id FROM `va` where city='Brodnax' && SIC_code='7231'DB:business_master_new
loadtime:1.2949960231781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooke' limit 1
loadtime:1.2950761318207 / seconds
Query Executed:select id FROM `va` where city='Brooke' && SIC_code='7231'DB:business_master_new
loadtime:1.2955300807953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookneal' limit 1
loadtime:1.2955830097198 / seconds
Query Executed:select id FROM `va` where city='Brookneal' && SIC_code='7231'DB:business_master_new
loadtime:1.2983891963959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsburg' limit 1
loadtime:1.2984671592712 / seconds
Query Executed:select id FROM `va` where city='Brownsburg' && SIC_code='7231'DB:business_master_new
loadtime:1.2989490032196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brucetown' limit 1
loadtime:1.2990031242371 / seconds
Query Executed:select id FROM `va` where city='Brucetown' && SIC_code='7231'DB:business_master_new
loadtime:1.2994070053101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruington' limit 1
loadtime:1.299458026886 / seconds
Query Executed:select id FROM `va` where city='Bruington' && SIC_code='7231'DB:business_master_new
loadtime:1.2999391555786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:1.2999911308289 / seconds
Query Executed:select id FROM `va` where city='Buchanan' && SIC_code='7231'DB:business_master_new
loadtime:1.3028631210327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:1.3029451370239 / seconds
Query Executed:select id FROM `va` where city='Buckingham' && SIC_code='7231'DB:business_master_new
loadtime:1.3048441410065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:1.3049201965332 / seconds
Query Executed:select id FROM `va` where city='Buena Vista' && SIC_code='7231'DB:business_master_new
loadtime:1.3811280727386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Junction' limit 1
loadtime:1.3812820911407 / seconds
Query Executed:select id FROM `va` where city='Buffalo Junction' && SIC_code='7231'DB:business_master_new
loadtime:1.3824951648712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bumpass' limit 1
loadtime:1.3825511932373 / seconds
Query Executed:select id FROM `va` where city='Bumpass' && SIC_code='7231'DB:business_master_new
loadtime:1.3844451904297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgess' limit 1
loadtime:1.3845191001892 / seconds
Query Executed:select id FROM `va` where city='Burgess' && SIC_code='7231'DB:business_master_new
loadtime:1.3858561515808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:1.3859272003174 / seconds
Query Executed:select id FROM `va` where city='Burke' && SIC_code='7231'DB:business_master_new
loadtime:1.4071590900421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkes Garden' limit 1
loadtime:1.4072680473328 / seconds
Query Executed:select id FROM `va` where city='Burkes Garden' && SIC_code='7231'DB:business_master_new
loadtime:1.4077370166779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkeville' limit 1
loadtime:1.4077930450439 / seconds
Query Executed:select id FROM `va` where city='Burkeville' && SIC_code='7231'DB:business_master_new
loadtime:1.4092631340027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:1.4093351364136 / seconds
Query Executed:select id FROM `va` where city='Burnsville' && SIC_code='7231'DB:business_master_new
loadtime:1.4098100662231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Hill' limit 1
loadtime:1.4098680019379 / seconds
Query Executed:select id FROM `va` where city='Burr Hill' && SIC_code='7231'DB:business_master_new
loadtime:1.4103810787201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callands' limit 1
loadtime:1.4104340076447 / seconds
Query Executed:select id FROM `va` where city='Callands' && SIC_code='7231'DB:business_master_new
loadtime:1.4111850261688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callao' limit 1
loadtime:1.4112420082092 / seconds
Query Executed:select id FROM `va` where city='Callao' && SIC_code='7231'DB:business_master_new
loadtime:1.4135460853577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callaway' limit 1
loadtime:1.4136180877686 / seconds
Query Executed:select id FROM `va` where city='Callaway' && SIC_code='7231'DB:business_master_new
loadtime:1.4146411418915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calverton' limit 1
loadtime:1.4147131443024 / seconds
Query Executed:select id FROM `va` where city='Calverton' && SIC_code='7231'DB:business_master_new
loadtime:1.4154970645905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cana' limit 1
loadtime:1.4155621528625 / seconds
Query Executed:select id FROM `va` where city='Cana' && SIC_code='7231'DB:business_master_new
loadtime:1.4172320365906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Charles' limit 1
loadtime:1.4173061847687 / seconds
Query Executed:select id FROM `va` where city='Cape Charles' && SIC_code='7231'DB:business_master_new
loadtime:1.4206700325012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capeville' limit 1
loadtime:1.4207441806793 / seconds
Query Executed:select id FROM `va` where city='Capeville' && SIC_code='7231'DB:business_master_new
loadtime:1.4212181568146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capron' limit 1
loadtime:1.4212729930878 / seconds
Query Executed:select id FROM `va` where city='Capron' && SIC_code='7231'DB:business_master_new
loadtime:1.422327041626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardinal' limit 1
loadtime:1.4223971366882 / seconds
Query Executed:select id FROM `va` where city='Cardinal' && SIC_code='7231'DB:business_master_new
loadtime:1.4229090213776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caret' limit 1
loadtime:1.422963142395 / seconds
Query Executed:select id FROM `va` where city='Caret' && SIC_code='7231'DB:business_master_new
loadtime:1.4234449863434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:1.4234981536865 / seconds
Query Executed:select id FROM `va` where city='Carrollton' && SIC_code='7231'DB:business_master_new
loadtime:1.4259631633759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrsville' limit 1
loadtime:1.4260439872742 / seconds
Query Executed:select id FROM `va` where city='Carrsville' && SIC_code='7231'DB:business_master_new
loadtime:1.4268970489502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:1.4269690513611 / seconds
Query Executed:select id FROM `va` where city='Carson' && SIC_code='7231'DB:business_master_new
loadtime:1.4277951717377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cartersville' limit 1
loadtime:1.4278481006622 / seconds
Query Executed:select id FROM `va` where city='Cartersville' && SIC_code='7231'DB:business_master_new
loadtime:1.4286880493164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casanova' limit 1
loadtime:1.4287531375885 / seconds
Query Executed:select id FROM `va` where city='Casanova' && SIC_code='7231'DB:business_master_new
loadtime:1.4292922019958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:1.429347038269 / seconds
Query Executed:select id FROM `va` where city='Cascade' && SIC_code='7231'DB:business_master_new
loadtime:1.4301931858063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:1.4302589893341 / seconds
Query Executed:select id FROM `va` where city='Castleton' && SIC_code='7231'DB:business_master_new
loadtime:1.4309601783752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:1.43101811409 / seconds
Query Executed:select id FROM `va` where city='Castlewood' && SIC_code='7231'DB:business_master_new
loadtime:1.4327881336212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:1.4328591823578 / seconds
Query Executed:select id FROM `va` where city='Catawba' && SIC_code='7231'DB:business_master_new
loadtime:1.4336380958557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharpin' limit 1
loadtime:1.4336969852448 / seconds
Query Executed:select id FROM `va` where city='Catharpin' && SIC_code='7231'DB:business_master_new
loadtime:1.4348561763763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catlett' limit 1
loadtime:1.43492603302 / seconds
Query Executed:select id FROM `va` where city='Catlett' && SIC_code='7231'DB:business_master_new
loadtime:1.4371061325073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:1.4371790885925 / seconds
Query Executed:select id FROM `va` where city='Cedar Bluff' && SIC_code='7231'DB:business_master_new
loadtime:1.4403791427612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Cross' limit 1
loadtime:1.4404602050781 / seconds
Query Executed:select id FROM `va` where city='Center Cross' && SIC_code='7231'DB:business_master_new
loadtime:1.4411571025848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:1.4412131309509 / seconds
Query Executed:select id FROM `va` where city='Centreville' && SIC_code='7231'DB:business_master_new
loadtime:1.4673910140991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceres' limit 1
loadtime:1.4675140380859 / seconds
Query Executed:select id FROM `va` where city='Ceres' && SIC_code='7231'DB:business_master_new
loadtime:1.4681060314178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champlain' limit 1
loadtime:1.4681630134583 / seconds
Query Executed:select id FROM `va` where city='Champlain' && SIC_code='7231'DB:business_master_new
loadtime:1.4687640666962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chantilly' limit 1
loadtime:1.4688282012939 / seconds
Query Executed:select id FROM `va` where city='Chantilly' && SIC_code='7231'DB:business_master_new
loadtime:1.50359416008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:1.5037159919739 / seconds
Query Executed:select id FROM `va` where city='Charles City' && SIC_code='7231'DB:business_master_new
loadtime:1.5068001747131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Court House' limit 1
loadtime:1.5068740844727 / seconds
Query Executed:select id FROM `va` where city='Charlotte Court House' && SIC_code='7231'DB:business_master_new
loadtime:1.508397102356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Ct Hse' limit 1
loadtime:1.5084681510925 / seconds
Query Executed:select id FROM `va` where city='Charlotte Ct Hse' && SIC_code='7231'DB:business_master_new
loadtime:1.5092070102692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlottesville' limit 1
loadtime:1.5092730522156 / seconds
Query Executed:select id FROM `va` where city='Charlottesville' && SIC_code='7231'DB:business_master_new
loadtime:1.5961170196533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase City' limit 1
loadtime:1.5964601039886 / seconds
Query Executed:select id FROM `va` where city='Chase City' && SIC_code='7231'DB:business_master_new
loadtime:1.600494146347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.6005930900574 / seconds
Query Executed:select id FROM `va` where city='Chatham' && SIC_code='7231'DB:business_master_new
loadtime:1.6061170101166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Check' limit 1
loadtime:1.6062049865723 / seconds
Query Executed:select id FROM `va` where city='Check' && SIC_code='7231'DB:business_master_new
loadtime:1.6070420742035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheriton' limit 1
loadtime:1.6070990562439 / seconds
Query Executed:select id FROM `va` where city='Cheriton' && SIC_code='7231'DB:business_master_new
loadtime:1.6082031726837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesapeake' limit 1
loadtime:1.6082701683044 / seconds
Query Executed:select id FROM `va` where city='Chesapeake' && SIC_code='7231'DB:business_master_new
loadtime:1.7109141349792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.7114171981812 / seconds
Query Executed:select id FROM `va` where city='Chester' && SIC_code='7231'DB:business_master_new
loadtime:1.7883050441742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester Gap' limit 1
loadtime:1.7885479927063 / seconds
Query Executed:select id FROM `va` where city='Chester Gap' && SIC_code='7231'DB:business_master_new
loadtime:1.7892022132874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.7892611026764 / seconds
Query Executed:select id FROM `va` where city='Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:1.8653440475464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilhowie' limit 1
loadtime:1.8654870986938 / seconds
Query Executed:select id FROM `va` where city='Chilhowie' && SIC_code='7231'DB:business_master_new
loadtime:1.868693113327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague' limit 1
loadtime:1.8687860965729 / seconds
Query Executed:select id FROM `va` where city='Chincoteague' && SIC_code='7231'DB:business_master_new
loadtime:1.8695020675659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague Island' limit 1
loadtime:1.869570016861 / seconds
Query Executed:select id FROM `va` where city='Chincoteague Island' && SIC_code='7231'DB:business_master_new
loadtime:1.8735949993134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christchurch' limit 1
loadtime:1.8736741542816 / seconds
Query Executed:select id FROM `va` where city='Christchurch' && SIC_code='7231'DB:business_master_new
loadtime:1.8741362094879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christiansburg' limit 1
loadtime:1.8741919994354 / seconds
Query Executed:select id FROM `va` where city='Christiansburg' && SIC_code='7231'DB:business_master_new
loadtime:1.9522550106049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Road' limit 1
loadtime:1.952406167984 / seconds
Query Executed:select id FROM `va` where city='Church Road' && SIC_code='7231'DB:business_master_new
loadtime:1.9534161090851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church View' limit 1
loadtime:1.9534871578217 / seconds
Query Executed:select id FROM `va` where city='Church View' && SIC_code='7231'DB:business_master_new
loadtime:1.9541280269623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churchville' limit 1
loadtime:1.9541831016541 / seconds
Query Executed:select id FROM `va` where city='Churchville' && SIC_code='7231'DB:business_master_new
loadtime:1.9558510780334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cismont' limit 1
loadtime:1.9559290409088 / seconds
Query Executed:select id FROM `va` where city='Cismont' && SIC_code='7231'DB:business_master_new
loadtime:1.9564020633698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:1.9564571380615 / seconds
Query Executed:select id FROM `va` where city='Claremont' && SIC_code='7231'DB:business_master_new
loadtime:1.957200050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:1.9572532176971 / seconds
Query Executed:select id FROM `va` where city='Clarksville' && SIC_code='7231'DB:business_master_new
loadtime:1.961333990097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claudville' limit 1
loadtime:1.9614090919495 / seconds
Query Executed:select id FROM `va` where city='Claudville' && SIC_code='7231'DB:business_master_new
loadtime:1.962277173996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Brook' limit 1
loadtime:1.962345123291 / seconds
Query Executed:select id FROM `va` where city='Clear Brook' && SIC_code='7231'DB:business_master_new
loadtime:1.9638321399689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:1.9639070034027 / seconds
Query Executed:select id FROM `va` where city='Cleveland' && SIC_code='7231'DB:business_master_new
loadtime:1.9647090435028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:1.9647741317749 / seconds
Query Executed:select id FROM `va` where city='Clifford' && SIC_code='7231'DB:business_master_new
loadtime:1.965252161026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.9653060436249 / seconds
Query Executed:select id FROM `va` where city='Clifton' && SIC_code='7231'DB:business_master_new
loadtime:1.9714682102203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton Forge' limit 1
loadtime:1.9715390205383 / seconds
Query Executed:select id FROM `va` where city='Clifton Forge' && SIC_code='7231'DB:business_master_new
loadtime:1.9749591350555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchco' limit 1
loadtime:1.9750351905823 / seconds
Query Executed:select id FROM `va` where city='Clinchco' && SIC_code='7231'DB:business_master_new
loadtime:1.9758009910583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchport' limit 1
loadtime:1.9758770465851 / seconds
Query Executed:select id FROM `va` where city='Clinchport' && SIC_code='7231'DB:business_master_new
loadtime:1.9763560295105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintwood' limit 1
loadtime:1.9764091968536 / seconds
Query Executed:select id FROM `va` where city='Clintwood' && SIC_code='7231'DB:business_master_new
loadtime:2.0524230003357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:2.0525100231171 / seconds
Query Executed:select id FROM `va` where city='Clover' && SIC_code='7231'DB:business_master_new
loadtime:2.0534331798553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:2.0535070896149 / seconds
Query Executed:select id FROM `va` where city='Cloverdale' && SIC_code='7231'DB:business_master_new
loadtime:2.0547831058502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cluster Springs' limit 1
loadtime:2.0548501014709 / seconds
Query Executed:select id FROM `va` where city='Cluster Springs' && SIC_code='7231'DB:business_master_new
loadtime:2.0552680492401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobbs Creek' limit 1
loadtime:2.0553271770477 / seconds
Query Executed:select id FROM `va` where city='Cobbs Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.0561821460724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobham' limit 1
loadtime:2.0562481880188 / seconds
Query Executed:select id FROM `va` where city='Cobham' && SIC_code='7231'DB:business_master_new
loadtime:2.056648015976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coeburn' limit 1
loadtime:2.0567021369934 / seconds
Query Executed:select id FROM `va` where city='Coeburn' && SIC_code='7231'DB:business_master_new
loadtime:2.133064031601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman Falls' limit 1
loadtime:2.1331541538239 / seconds
Query Executed:select id FROM `va` where city='Coleman Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.133730173111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coles Point' limit 1
loadtime:2.1337890625 / seconds
Query Executed:select id FROM `va` where city='Coles Point' && SIC_code='7231'DB:business_master_new
loadtime:2.1342971324921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:2.1343550682068 / seconds
Query Executed:select id FROM `va` where city='Collinsville' && SIC_code='7231'DB:business_master_new
loadtime:2.2108161449432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:2.2109591960907 / seconds
Query Executed:select id FROM `va` where city='Cologne' && SIC_code='7231'DB:business_master_new
loadtime:2.2114441394806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Beach' limit 1
loadtime:2.2115020751953 / seconds
Query Executed:select id FROM `va` where city='Colonial Beach' && SIC_code='7231'DB:business_master_new
loadtime:2.2875192165375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Heights' limit 1
loadtime:2.2876131534576 / seconds
Query Executed:select id FROM `va` where city='Colonial Heights' && SIC_code='7231'DB:business_master_new
loadtime:2.3094460964203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:2.3095831871033 / seconds
Query Executed:select id FROM `va` where city='Columbia' && SIC_code='7231'DB:business_master_new
loadtime:2.3104860782623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conaway' limit 1
loadtime:2.3105452060699 / seconds
Query Executed:select id FROM `va` where city='Conaway' && SIC_code='7231'DB:business_master_new
loadtime:2.3109521865845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:2.311005115509 / seconds
Query Executed:select id FROM `va` where city='Concord' && SIC_code='7231'DB:business_master_new
loadtime:2.3127410411835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Hill' limit 1
loadtime:2.3128139972687 / seconds
Query Executed:select id FROM `va` where city='Copper Hill' && SIC_code='7231'DB:business_master_new
loadtime:2.3137741088867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin' limit 1
loadtime:2.3138420581818 / seconds
Query Executed:select id FROM `va` where city='Corbin' && SIC_code='7231'DB:business_master_new
loadtime:2.3143730163574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:2.3144280910492 / seconds
Query Executed:select id FROM `va` where city='Council' && SIC_code='7231'DB:business_master_new
loadtime:2.3148682117462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:2.3149411678314 / seconds
Query Executed:select id FROM `va` where city='Courtland' && SIC_code='7231'DB:business_master_new
loadtime:2.3175640106201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covesville' limit 1
loadtime:2.3176422119141 / seconds
Query Executed:select id FROM `va` where city='Covesville' && SIC_code='7231'DB:business_master_new
loadtime:2.3183209896088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:2.3183760643005 / seconds
Query Executed:select id FROM `va` where city='Covington' && SIC_code='7231'DB:business_master_new
loadtime:2.3324961662292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craddockville' limit 1
loadtime:2.3326051235199 / seconds
Query Executed:select id FROM `va` where city='Craddockville' && SIC_code='7231'DB:business_master_new
loadtime:2.333113193512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:2.3331711292267 / seconds
Query Executed:select id FROM `va` where city='Craigsville' && SIC_code='7231'DB:business_master_new
loadtime:2.3340380191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crewe' limit 1
loadtime:2.3341112136841 / seconds
Query Executed:select id FROM `va` where city='Crewe' && SIC_code='7231'DB:business_master_new
loadtime:2.3372550010681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criders' limit 1
loadtime:2.337345123291 / seconds
Query Executed:select id FROM `va` where city='Criders' && SIC_code='7231'DB:business_master_new
loadtime:2.3378641605377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criglersville' limit 1
loadtime:2.3379271030426 / seconds
Query Executed:select id FROM `va` where city='Criglersville' && SIC_code='7231'DB:business_master_new
loadtime:2.338338136673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crimora' limit 1
loadtime:2.3383951187134 / seconds
Query Executed:select id FROM `va` where city='Crimora' && SIC_code='7231'DB:business_master_new
loadtime:2.3392970561981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:2.3393630981445 / seconds
Query Executed:select id FROM `va` where city='Cripple Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.339809179306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Critz' limit 1
loadtime:2.3398621082306 / seconds
Query Executed:select id FROM `va` where city='Critz' && SIC_code='7231'DB:business_master_new
loadtime:2.3404731750488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crockett' limit 1
loadtime:2.3405261039734 / seconds
Query Executed:select id FROM `va` where city='Crockett' && SIC_code='7231'DB:business_master_new
loadtime:2.3411722183228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Junction' limit 1
loadtime:2.3412251472473 / seconds
Query Executed:select id FROM `va` where city='Cross Junction' && SIC_code='7231'DB:business_master_new
loadtime:2.342591047287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozet' limit 1
loadtime:2.3426430225372 / seconds
Query Executed:select id FROM `va` where city='Crozet' && SIC_code='7231'DB:business_master_new
loadtime:2.3460800647736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozier' limit 1
loadtime:2.3461501598358 / seconds
Query Executed:select id FROM `va` where city='Crozier' && SIC_code='7231'DB:business_master_new
loadtime:2.3471450805664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Hill' limit 1
loadtime:2.3471992015839 / seconds
Query Executed:select id FROM `va` where city='Crystal Hill' && SIC_code='7231'DB:business_master_new
loadtime:2.3476881980896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullen' limit 1
loadtime:2.34774518013 / seconds
Query Executed:select id FROM `va` where city='Cullen' && SIC_code='7231'DB:business_master_new
loadtime:2.3483910560608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culpeper' limit 1
loadtime:2.3484470844269 / seconds
Query Executed:select id FROM `va` where city='Culpeper' && SIC_code='7231'DB:business_master_new
loadtime:2.3706982135773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:2.3708171844482 / seconds
Query Executed:select id FROM `va` where city='Cumberland' && SIC_code='7231'DB:business_master_new
loadtime:2.3731241226196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dahlgren' limit 1
loadtime:2.3732080459595 / seconds
Query Executed:select id FROM `va` where city='Dahlgren' && SIC_code='7231'DB:business_master_new
loadtime:2.3749451637268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale City' limit 1
loadtime:2.3750140666962 / seconds
Query Executed:select id FROM `va` where city='Dale City' && SIC_code='7231'DB:business_master_new
loadtime:2.3757610321045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:2.3758180141449 / seconds
Query Executed:select id FROM `va` where city='Daleville' && SIC_code='7231'DB:business_master_new
loadtime:2.3785190582275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:2.37859416008 / seconds
Query Executed:select id FROM `va` where city='Damascus' && SIC_code='7231'DB:business_master_new
loadtime:2.3806300163269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:2.380707025528 / seconds
Query Executed:select id FROM `va` where city='Dante' && SIC_code='7231'DB:business_master_new
loadtime:2.3813672065735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:2.3814251422882 / seconds
Query Executed:select id FROM `va` where city='Danville' && SIC_code='7231'DB:business_master_new
loadtime:2.4232721328735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington Hts' limit 1
loadtime:2.4235410690308 / seconds
Query Executed:select id FROM `va` where city='Darlington Hts' && SIC_code='7231'DB:business_master_new
loadtime:2.4239730834961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:2.4240441322327 / seconds
Query Executed:select id FROM `va` where city='Davenport' && SIC_code='7231'DB:business_master_new
loadtime:2.4245851039886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Wharf' limit 1
loadtime:2.4246380329132 / seconds
Query Executed:select id FROM `va` where city='Davis Wharf' && SIC_code='7231'DB:business_master_new
loadtime:2.4250481128693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:2.4251010417938 / seconds
Query Executed:select id FROM `va` where city='Dayton' && SIC_code='7231'DB:business_master_new
loadtime:2.4285850524902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:2.4286510944366 / seconds
Query Executed:select id FROM `va` where city='Deerfield' && SIC_code='7231'DB:business_master_new
loadtime:2.4291861057281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaplane' limit 1
loadtime:2.4292411804199 / seconds
Query Executed:select id FROM `va` where city='Delaplane' && SIC_code='7231'DB:business_master_new
loadtime:2.4301102161407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deltaville' limit 1
loadtime:2.430162191391 / seconds
Query Executed:select id FROM `va` where city='Deltaville' && SIC_code='7231'DB:business_master_new
loadtime:2.4324300289154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dendron' limit 1
loadtime:2.4325041770935 / seconds
Query Executed:select id FROM `va` where city='Dendron' && SIC_code='7231'DB:business_master_new
loadtime:2.433235168457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:2.4332940578461 / seconds
Query Executed:select id FROM `va` where city='Dewitt' && SIC_code='7231'DB:business_master_new
loadtime:2.4342050552368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diggs' limit 1
loadtime:2.4342560768127 / seconds
Query Executed:select id FROM `va` where city='Diggs' && SIC_code='7231'DB:business_master_new
loadtime:2.4346799850464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillwyn' limit 1
loadtime:2.4347360134125 / seconds
Query Executed:select id FROM `va` where city='Dillwyn' && SIC_code='7231'DB:business_master_new
loadtime:2.4378921985626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinwiddie' limit 1
loadtime:2.4379680156708 / seconds
Query Executed:select id FROM `va` where city='Dinwiddie' && SIC_code='7231'DB:business_master_new
loadtime:2.4402430057526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Disputanta' limit 1
loadtime:2.4403162002563 / seconds
Query Executed:select id FROM `va` where city='Disputanta' && SIC_code='7231'DB:business_master_new
loadtime:2.4423100948334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doe Hill' limit 1
loadtime:2.4423642158508 / seconds
Query Executed:select id FROM `va` where city='Doe Hill' && SIC_code='7231'DB:business_master_new
loadtime:2.4428660869598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dogue' limit 1
loadtime:2.4429302215576 / seconds
Query Executed:select id FROM `va` where city='Dogue' && SIC_code='7231'DB:business_master_new
loadtime:2.4434130191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolphin' limit 1
loadtime:2.4434640407562 / seconds
Query Executed:select id FROM `va` where city='Dolphin' && SIC_code='7231'DB:business_master_new
loadtime:2.4441070556641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doran' limit 1
loadtime:2.4441590309143 / seconds
Query Executed:select id FROM `va` where city='Doran' && SIC_code='7231'DB:business_master_new
loadtime:2.4448411464691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doswell' limit 1
loadtime:2.4449181556702 / seconds
Query Executed:select id FROM `va` where city='Doswell' && SIC_code='7231'DB:business_master_new
loadtime:2.4464991092682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakes Branch' limit 1
loadtime:2.4465529918671 / seconds
Query Executed:select id FROM `va` where city='Drakes Branch' && SIC_code='7231'DB:business_master_new
loadtime:2.4478921890259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:2.4479660987854 / seconds
Query Executed:select id FROM `va` where city='Draper' && SIC_code='7231'DB:business_master_new
loadtime:2.4488031864166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewryville' limit 1
loadtime:2.4488570690155 / seconds
Query Executed:select id FROM `va` where city='Drewryville' && SIC_code='7231'DB:business_master_new
loadtime:2.4495031833649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Fork' limit 1
loadtime:2.4495561122894 / seconds
Query Executed:select id FROM `va` where city='Dry Fork' && SIC_code='7231'DB:business_master_new
loadtime:2.4512162208557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:2.4512820243835 / seconds
Query Executed:select id FROM `va` where city='Dryden' && SIC_code='7231'DB:business_master_new
loadtime:2.4522271156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:2.4522922039032 / seconds
Query Executed:select id FROM `va` where city='Dublin' && SIC_code='7231'DB:business_master_new
loadtime:2.4576292037964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duffield' limit 1
loadtime:2.4577171802521 / seconds
Query Executed:select id FROM `va` where city='Duffield' && SIC_code='7231'DB:business_master_new
loadtime:2.4597480297089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugspur' limit 1
loadtime:2.4598200321198 / seconds
Query Executed:select id FROM `va` where city='Dugspur' && SIC_code='7231'DB:business_master_new
loadtime:2.4605321884155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulles' limit 1
loadtime:2.4606029987335 / seconds
Query Executed:select id FROM `va` where city='Dulles' && SIC_code='7231'DB:business_master_new
loadtime:2.4613790512085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumfries' limit 1
loadtime:2.461433172226 / seconds
Query Executed:select id FROM `va` where city='Dumfries' && SIC_code='7231'DB:business_master_new
loadtime:2.5383009910583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundas' limit 1
loadtime:2.5384202003479 / seconds
Query Executed:select id FROM `va` where city='Dundas' && SIC_code='7231'DB:business_master_new
loadtime:2.5391399860382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dungannon' limit 1
loadtime:2.5391972064972 / seconds
Query Executed:select id FROM `va` where city='Dungannon' && SIC_code='7231'DB:business_master_new
loadtime:2.5399920940399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn Loring' limit 1
loadtime:2.5400550365448 / seconds
Query Executed:select id FROM `va` where city='Dunn Loring' && SIC_code='7231'DB:business_master_new
loadtime:2.5419981479645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunnsville' limit 1
loadtime:2.5420560836792 / seconds
Query Executed:select id FROM `va` where city='Dunnsville' && SIC_code='7231'DB:business_master_new
loadtime:2.5428240299225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:2.5428891181946 / seconds
Query Executed:select id FROM `va` where city='Dutton' && SIC_code='7231'DB:business_master_new
loadtime:2.5434820652008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyke' limit 1
loadtime:2.5435521602631 / seconds
Query Executed:select id FROM `va` where city='Dyke' && SIC_code='7231'DB:business_master_new
loadtime:2.5441660881042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:2.544221162796 / seconds
Query Executed:select id FROM `va` where city='Eagle Rock' && SIC_code='7231'DB:business_master_new
loadtime:2.5451500415802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlysville' limit 1
loadtime:2.5452160835266 / seconds
Query Executed:select id FROM `va` where city='Earlysville' && SIC_code='7231'DB:business_master_new
loadtime:2.5477061271667 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Stone Gap' limit 1
loadtime:2.5477740764618 / seconds
Query Executed:select id FROM `va` where city='East Stone Gap' && SIC_code='7231'DB:business_master_new
loadtime:2.5482361316681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastville' limit 1
loadtime:2.548290014267 / seconds
Query Executed:select id FROM `va` where city='Eastville' && SIC_code='7231'DB:business_master_new
loadtime:2.5495431423187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ebony' limit 1
loadtime:2.5496079921722 / seconds
Query Executed:select id FROM `va` where city='Ebony' && SIC_code='7231'DB:business_master_new
loadtime:2.5503141880035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:2.5503680706024 / seconds
Query Executed:select id FROM `va` where city='Edinburg' && SIC_code='7231'DB:business_master_new
loadtime:2.5543141365051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:2.554386138916 / seconds
Query Executed:select id FROM `va` where city='Edwardsville' && SIC_code='7231'DB:business_master_new
loadtime:2.5548400878906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eggleston' limit 1
loadtime:2.5549020767212 / seconds
Query Executed:select id FROM `va` where city='Eggleston' && SIC_code='7231'DB:business_master_new
loadtime:2.5554640293121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:2.5555210113525 / seconds
Query Executed:select id FROM `va` where city='Elberon' && SIC_code='7231'DB:business_master_new
loadtime:2.5561242103577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Creek' limit 1
loadtime:2.5561771392822 / seconds
Query Executed:select id FROM `va` where city='Elk Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.5569410324097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:2.5570120811462 / seconds
Query Executed:select id FROM `va` where city='Elk Garden' && SIC_code='7231'DB:business_master_new
loadtime:2.5574200153351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:2.5574741363525 / seconds
Query Executed:select id FROM `va` where city='Elkton' && SIC_code='7231'DB:business_master_new
loadtime:2.5618350505829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkwood' limit 1
loadtime:2.5619192123413 / seconds
Query Executed:select id FROM `va` where city='Elkwood' && SIC_code='7231'DB:business_master_new
loadtime:2.5626451969147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliston' limit 1
loadtime:2.5626981258392 / seconds
Query Executed:select id FROM `va` where city='Elliston' && SIC_code='7231'DB:business_master_new
loadtime:2.5640170574188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emory' limit 1
loadtime:2.5640740394592 / seconds
Query Executed:select id FROM `va` where city='Emory' && SIC_code='7231'DB:business_master_new
loadtime:2.5645861625671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:2.5646359920502 / seconds
Query Executed:select id FROM `va` where city='Emporia' && SIC_code='7231'DB:business_master_new
loadtime:2.5729720592499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engleside' limit 1
loadtime:2.5730791091919 / seconds
Query Executed:select id FROM `va` where city='Engleside' && SIC_code='7231'DB:business_master_new
loadtime:2.5737071037292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esmont' limit 1
loadtime:2.5737681388855 / seconds
Query Executed:select id FROM `va` where city='Esmont' && SIC_code='7231'DB:business_master_new
loadtime:2.5744540691376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etlan' limit 1
loadtime:2.5745060443878 / seconds
Query Executed:select id FROM `va` where city='Etlan' && SIC_code='7231'DB:business_master_new
loadtime:2.5749711990356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:2.5750269889832 / seconds
Query Executed:select id FROM `va` where city='Ettrick' && SIC_code='7231'DB:business_master_new
loadtime:2.5754270553589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:2.575483083725 / seconds
Query Executed:select id FROM `va` where city='Evergreen' && SIC_code='7231'DB:business_master_new
loadtime:2.5759980678558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evington' limit 1
loadtime:2.5760550498962 / seconds
Query Executed:select id FROM `va` where city='Evington' && SIC_code='7231'DB:business_master_new
loadtime:2.5779600143433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewing' limit 1
loadtime:2.5780291557312 / seconds
Query Executed:select id FROM `va` where city='Ewing' && SIC_code='7231'DB:business_master_new
loadtime:2.5792140960693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exmore' limit 1
loadtime:2.5792870521545 / seconds
Query Executed:select id FROM `va` where city='Exmore' && SIC_code='7231'DB:business_master_new
loadtime:2.5821511745453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faber' limit 1
loadtime:2.5822310447693 / seconds
Query Executed:select id FROM `va` where city='Faber' && SIC_code='7231'DB:business_master_new
loadtime:2.58314204216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:2.583202123642 / seconds
Query Executed:select id FROM `va` where city='Fairfax' && SIC_code='7231'DB:business_master_new
loadtime:2.6894400119781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax Station' limit 1
loadtime:2.6897411346436 / seconds
Query Executed:select id FROM `va` where city='Fairfax Station' && SIC_code='7231'DB:business_master_new
loadtime:2.7666051387787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:2.7666990756989 / seconds
Query Executed:select id FROM `va` where city='Fairfield' && SIC_code='7231'DB:business_master_new
loadtime:2.7682020664215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlawn' limit 1
loadtime:2.7682740688324 / seconds
Query Executed:select id FROM `va` where city='Fairlawn' && SIC_code='7231'DB:business_master_new
loadtime:2.7687220573425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Church' limit 1
loadtime:2.7687749862671 / seconds
Query Executed:select id FROM `va` where city='Falls Church' && SIC_code='7231'DB:business_master_new
loadtime:2.8443961143494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Mills' limit 1
loadtime:2.8446650505066 / seconds
Query Executed:select id FROM `va` where city='Falls Mills' && SIC_code='7231'DB:business_master_new
loadtime:2.8454492092133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:2.8455309867859 / seconds
Query Executed:select id FROM `va` where city='Falmouth' && SIC_code='7231'DB:business_master_new
loadtime:2.8459150791168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fancy Gap' limit 1
loadtime:2.8459692001343 / seconds
Query Executed:select id FROM `va` where city='Fancy Gap' && SIC_code='7231'DB:business_master_new
loadtime:2.847314119339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:2.8473801612854 / seconds
Query Executed:select id FROM `va` where city='Farmville' && SIC_code='7231'DB:business_master_new
loadtime:2.8634610176086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnham' limit 1
loadtime:2.8635740280151 / seconds
Query Executed:select id FROM `va` where city='Farnham' && SIC_code='7231'DB:business_master_new
loadtime:2.8646471500397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrum' limit 1
loadtime:2.8647241592407 / seconds
Query Executed:select id FROM `va` where city='Ferrum' && SIC_code='7231'DB:business_master_new
loadtime:2.8664190769196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldale' limit 1
loadtime:2.8664891719818 / seconds
Query Executed:select id FROM `va` where city='Fieldale' && SIC_code='7231'DB:business_master_new
loadtime:2.868105173111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:2.8681840896606 / seconds
Query Executed:select id FROM `va` where city='Fife' && SIC_code='7231'DB:business_master_new
loadtime:2.8686211109161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fincastle' limit 1
loadtime:2.868674993515 / seconds
Query Executed:select id FROM `va` where city='Fincastle' && SIC_code='7231'DB:business_master_new
loadtime:2.8714201450348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishers Hill' limit 1
loadtime:2.8714871406555 / seconds
Query Executed:select id FROM `va` where city='Fishers Hill' && SIC_code='7231'DB:business_master_new
loadtime:2.871924161911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishersville' limit 1
loadtime:2.8719780445099 / seconds
Query Executed:select id FROM `va` where city='Fishersville' && SIC_code='7231'DB:business_master_new
loadtime:2.8756890296936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint Hill' limit 1
loadtime:2.8757572174072 / seconds
Query Executed:select id FROM `va` where city='Flint Hill' && SIC_code='7231'DB:business_master_new
loadtime:2.8767750263214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:2.876834154129 / seconds
Query Executed:select id FROM `va` where city='Floyd' && SIC_code='7231'DB:business_master_new
loadtime:2.9529850482941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foneswood' limit 1
loadtime:2.9530670642853 / seconds
Query Executed:select id FROM `va` where city='Foneswood' && SIC_code='7231'DB:business_master_new
loadtime:2.9535272121429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:2.9535801410675 / seconds
Query Executed:select id FROM `va` where city='Ford' && SIC_code='7231'DB:business_master_new
loadtime:2.9541699886322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:2.9542231559753 / seconds
Query Executed:select id FROM `va` where city='Forest' && SIC_code='7231'DB:business_master_new
loadtime:2.9695181846619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork Union' limit 1
loadtime:2.9696011543274 / seconds
Query Executed:select id FROM `va` where city='Fork Union' && SIC_code='7231'DB:business_master_new
loadtime:2.9709072113037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Belvoir' limit 1
loadtime:2.9709811210632 / seconds
Query Executed:select id FROM `va` where city='Fort Belvoir' && SIC_code='7231'DB:business_master_new
loadtime:2.9735810756683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Blackmore' limit 1
loadtime:2.9736502170563 / seconds
Query Executed:select id FROM `va` where city='Fort Blackmore' && SIC_code='7231'DB:business_master_new
loadtime:2.9742670059204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:2.9743220806122 / seconds
Query Executed:select id FROM `va` where city='Fort Defiance' && SIC_code='7231'DB:business_master_new
loadtime:2.9750730991364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Eustis' limit 1
loadtime:2.9751400947571 / seconds
Query Executed:select id FROM `va` where city='Fort Eustis' && SIC_code='7231'DB:business_master_new
loadtime:2.9765510559082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:2.9766180515289 / seconds
Query Executed:select id FROM `va` where city='Fort Lee' && SIC_code='7231'DB:business_master_new
loadtime:2.9778761863708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:2.9779431819916 / seconds
Query Executed:select id FROM `va` where city='Fort Mitchell' && SIC_code='7231'DB:business_master_new
loadtime:2.9784121513367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monroe' limit 1
loadtime:2.9784660339355 / seconds
Query Executed:select id FROM `va` where city='Fort Monroe' && SIC_code='7231'DB:business_master_new
loadtime:2.9792950153351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Myer' limit 1
loadtime:2.9793481826782 / seconds
Query Executed:select id FROM `va` where city='Fort Myer' && SIC_code='7231'DB:business_master_new
loadtime:2.9802260398865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Valley' limit 1
loadtime:2.9802920818329 / seconds
Query Executed:select id FROM `va` where city='Fort Valley' && SIC_code='7231'DB:business_master_new
loadtime:2.9812850952148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:2.9813392162323 / seconds
Query Executed:select id FROM `va` where city='Foster' && SIC_code='7231'DB:business_master_new
loadtime:2.9818642139435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:2.9819250106812 / seconds
Query Executed:select id FROM `va` where city='Franconia' && SIC_code='7231'DB:business_master_new
loadtime:2.9824252128601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.9824900627136 / seconds
Query Executed:select id FROM `va` where city='Franklin' && SIC_code='7231'DB:business_master_new
loadtime:3.0588941574097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:3.0590200424194 / seconds
Query Executed:select id FROM `va` where city='Franktown' && SIC_code='7231'DB:business_master_new
loadtime:3.0597832202911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:3.0598421096802 / seconds
Query Executed:select id FROM `va` where city='Fredericksburg' && SIC_code='7231'DB:business_master_new
loadtime:3.1402230262756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Union' limit 1
loadtime:3.1405560970306 / seconds
Query Executed:select id FROM `va` where city='Free Union' && SIC_code='7231'DB:business_master_new
loadtime:3.1417090892792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:3.1417820453644 / seconds
Query Executed:select id FROM `va` where city='Freeman' && SIC_code='7231'DB:business_master_new
loadtime:3.1425352096558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fries' limit 1
loadtime:3.1425881385803 / seconds
Query Executed:select id FROM `va` where city='Fries' && SIC_code='7231'DB:business_master_new
loadtime:3.1439580917358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Front Royal' limit 1
loadtime:3.1440269947052 / seconds
Query Executed:select id FROM `va` where city='Front Royal' && SIC_code='7231'DB:business_master_new
loadtime:3.1670050621033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ft Myer' limit 1
loadtime:3.1671171188354 / seconds
Query Executed:select id FROM `va` where city='Ft Myer' && SIC_code='7231'DB:business_master_new
loadtime:3.1675081253052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulks Run' limit 1
loadtime:3.1675641536713 / seconds
Query Executed:select id FROM `va` where city='Fulks Run' && SIC_code='7231'DB:business_master_new
loadtime:3.1685900688171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:3.1686580181122 / seconds
Query Executed:select id FROM `va` where city='Gainesville' && SIC_code='7231'DB:business_master_new
loadtime:3.2447102069855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galax' limit 1
loadtime:3.2447919845581 / seconds
Query Executed:select id FROM `va` where city='Galax' && SIC_code='7231'DB:business_master_new
loadtime:3.2599670886993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrisonville' limit 1
loadtime:3.260073184967 / seconds
Query Executed:select id FROM `va` where city='Garrisonville' && SIC_code='7231'DB:business_master_new
loadtime:3.2608931064606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gasburg' limit 1
loadtime:3.2609491348267 / seconds
Query Executed:select id FROM `va` where city='Gasburg' && SIC_code='7231'DB:business_master_new
loadtime:3.2618269920349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gate City' limit 1
loadtime:3.261904001236 / seconds
Query Executed:select id FROM `va` where city='Gate City' && SIC_code='7231'DB:business_master_new
loadtime:3.2659311294556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Hill' limit 1
loadtime:3.2660059928894 / seconds
Query Executed:select id FROM `va` where city='Glade Hill' && SIC_code='7231'DB:business_master_new
loadtime:3.2675251960754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Spring' limit 1
loadtime:3.2675950527191 / seconds
Query Executed:select id FROM `va` where city='Glade Spring' && SIC_code='7231'DB:business_master_new
loadtime:3.2699890136719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladehill' limit 1
loadtime:3.27006316185 / seconds
Query Executed:select id FROM `va` where city='Gladehill' && SIC_code='7231'DB:business_master_new
loadtime:3.2704901695251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:3.2705430984497 / seconds
Query Executed:select id FROM `va` where city='Gladstone' && SIC_code='7231'DB:business_master_new
loadtime:3.2715129852295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladys' limit 1
loadtime:3.2715671062469 / seconds
Query Executed:select id FROM `va` where city='Gladys' && SIC_code='7231'DB:business_master_new
loadtime:3.2730300426483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:3.2731041908264 / seconds
Query Executed:select id FROM `va` where city='Glasgow' && SIC_code='7231'DB:business_master_new
loadtime:3.2743020057678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:3.2743730545044 / seconds
Query Executed:select id FROM `va` where city='Glen Allen' && SIC_code='7231'DB:business_master_new
loadtime:3.3062682151794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Lyn' limit 1
loadtime:3.3064141273499 / seconds
Query Executed:select id FROM `va` where city='Glen Lyn' && SIC_code='7231'DB:business_master_new
loadtime:3.3071441650391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Wilton' limit 1
loadtime:3.3072030544281 / seconds
Query Executed:select id FROM `va` where city='Glen Wilton' && SIC_code='7231'DB:business_master_new
loadtime:3.3075981140137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:3.3076500892639 / seconds
Query Executed:select id FROM `va` where city='Gloucester' && SIC_code='7231'DB:business_master_new
loadtime:3.3232131004333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester Point' limit 1
loadtime:3.3233051300049 / seconds
Query Executed:select id FROM `va` where city='Gloucester Point' && SIC_code='7231'DB:business_master_new
loadtime:3.3251440525055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldbond' limit 1
loadtime:3.3252151012421 / seconds
Query Executed:select id FROM `va` where city='Goldbond' && SIC_code='7231'DB:business_master_new
loadtime:3.3256471157074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldvein' limit 1
loadtime:3.325700044632 / seconds
Query Executed:select id FROM `va` where city='Goldvein' && SIC_code='7231'DB:business_master_new
loadtime:3.3265302181244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goochland' limit 1
loadtime:3.3265841007233 / seconds
Query Executed:select id FROM `va` where city='Goochland' && SIC_code='7231'DB:business_master_new
loadtime:3.3295991420746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goode' limit 1
loadtime:3.32967710495 / seconds
Query Executed:select id FROM `va` where city='Goode' && SIC_code='7231'DB:business_master_new
loadtime:3.3311491012573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodview' limit 1
loadtime:3.3312170505524 / seconds
Query Executed:select id FROM `va` where city='Goodview' && SIC_code='7231'DB:business_master_new
loadtime:3.3326630592346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordonsville' limit 1
loadtime:3.3327350616455 / seconds
Query Executed:select id FROM `va` where city='Gordonsville' && SIC_code='7231'DB:business_master_new
loadtime:3.3359291553497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore' limit 1
loadtime:3.3359971046448 / seconds
Query Executed:select id FROM `va` where city='Gore' && SIC_code='7231'DB:business_master_new
loadtime:3.33713722229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:3.3372089862823 / seconds
Query Executed:select id FROM `va` where city='Goshen' && SIC_code='7231'DB:business_master_new
loadtime:3.3380281925201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:3.3380861282349 / seconds
Query Executed:select id FROM `va` where city='Grafton' && SIC_code='7231'DB:business_master_new
loadtime:3.3386361598969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graves Mill' limit 1
loadtime:3.3387031555176 / seconds
Query Executed:select id FROM `va` where city='Graves Mill' && SIC_code='7231'DB:business_master_new
loadtime:3.3391180038452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:3.3391721248627 / seconds
Query Executed:select id FROM `va` where city='Great Falls' && SIC_code='7231'DB:business_master_new
loadtime:3.3562331199646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:3.3563301563263 / seconds
Query Executed:select id FROM `va` where city='Green Bay' && SIC_code='7231'DB:business_master_new
loadtime:3.3571321964264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbackville' limit 1
loadtime:3.3571891784668 / seconds
Query Executed:select id FROM `va` where city='Greenbackville' && SIC_code='7231'DB:business_master_new
loadtime:3.3578350543976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:3.3578960895538 / seconds
Query Executed:select id FROM `va` where city='Greenbush' && SIC_code='7231'DB:business_master_new
loadtime:3.3585300445557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:3.3585832118988 / seconds
Query Executed:select id FROM `va` where city='Greenville' && SIC_code='7231'DB:business_master_new
loadtime:3.3596580028534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenway' limit 1
loadtime:3.359726190567 / seconds
Query Executed:select id FROM `va` where city='Greenway' && SIC_code='7231'DB:business_master_new
loadtime:3.3601770401001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:3.3602321147919 / seconds
Query Executed:select id FROM `va` where city='Greenwood' && SIC_code='7231'DB:business_master_new
loadtime:3.3609080314636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gretna' limit 1
loadtime:3.3609611988068 / seconds
Query Executed:select id FROM `va` where city='Gretna' && SIC_code='7231'DB:business_master_new
loadtime:3.364865064621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimstead' limit 1
loadtime:3.3649661540985 / seconds
Query Executed:select id FROM `va` where city='Grimstead' && SIC_code='7231'DB:business_master_new
loadtime:3.3654811382294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grottoes' limit 1
loadtime:3.3655371665955 / seconds
Query Executed:select id FROM `va` where city='Grottoes' && SIC_code='7231'DB:business_master_new
loadtime:3.3675601482391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy' limit 1
loadtime:3.36763215065 / seconds
Query Executed:select id FROM `va` where city='Grundy' && SIC_code='7231'DB:business_master_new
loadtime:3.4440162181854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gum Spring' limit 1
loadtime:3.4441390037537 / seconds
Query Executed:select id FROM `va` where city='Gum Spring' && SIC_code='7231'DB:business_master_new
loadtime:3.4451789855957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwynn' limit 1
loadtime:3.4452481269836 / seconds
Query Executed:select id FROM `va` where city='Gwynn' && SIC_code='7231'DB:business_master_new
loadtime:3.4458000659943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacksneck' limit 1
loadtime:3.445864200592 / seconds
Query Executed:select id FROM `va` where city='Hacksneck' && SIC_code='7231'DB:business_master_new
loadtime:3.4463691711426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadensville' limit 1
loadtime:3.4464221000671 / seconds
Query Executed:select id FROM `va` where city='Hadensville' && SIC_code='7231'DB:business_master_new
loadtime:3.4469220638275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hague' limit 1
loadtime:3.4469740390778 / seconds
Query Executed:select id FROM `va` where city='Hague' && SIC_code='7231'DB:business_master_new
loadtime:3.448135137558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:3.4482011795044 / seconds
Query Executed:select id FROM `va` where city='Halifax' && SIC_code='7231'DB:business_master_new
loadtime:3.4524149894714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallieford' limit 1
loadtime:3.4524919986725 / seconds
Query Executed:select id FROM `va` where city='Hallieford' && SIC_code='7231'DB:business_master_new
loadtime:3.4529800415039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallwood' limit 1
loadtime:3.4530341625214 / seconds
Query Executed:select id FROM `va` where city='Hallwood' && SIC_code='7231'DB:business_master_new
loadtime:3.4536700248718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:3.453723192215 / seconds
Query Executed:select id FROM `va` where city='Hamilton' && SIC_code='7231'DB:business_master_new
loadtime:3.4555320739746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden Sydney' limit 1
loadtime:3.4555850028992 / seconds
Query Executed:select id FROM `va` where city='Hampden Sydney' && SIC_code='7231'DB:business_master_new
loadtime:3.4561860561371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:3.4562389850616 / seconds
Query Executed:select id FROM `va` where city='Hampton' && SIC_code='7231'DB:business_master_new
loadtime:3.5165181159973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:3.516841173172 / seconds
Query Executed:select id FROM `va` where city='Hanover' && SIC_code='7231'DB:business_master_new
loadtime:3.5193700790405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harborton' limit 1
loadtime:3.5194551944733 / seconds
Query Executed:select id FROM `va` where city='Harborton' && SIC_code='7231'DB:business_master_new
loadtime:3.5199429988861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:3.5199971199036 / seconds
Query Executed:select id FROM `va` where city='Hardy' && SIC_code='7231'DB:business_master_new
loadtime:3.5227642059326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardyville' limit 1
loadtime:3.5228350162506 / seconds
Query Executed:select id FROM `va` where city='Hardyville' && SIC_code='7231'DB:business_master_new
loadtime:3.5234282016754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:3.5234930515289 / seconds
Query Executed:select id FROM `va` where city='Harman' && SIC_code='7231'DB:business_master_new
loadtime:3.5239660739899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonburg' limit 1
loadtime:3.5240190029144 / seconds
Query Executed:select id FROM `va` where city='Harrisonburg' && SIC_code='7231'DB:business_master_new
loadtime:3.5650780200958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartfield' limit 1
loadtime:3.565258026123 / seconds
Query Executed:select id FROM `va` where city='Hartfield' && SIC_code='7231'DB:business_master_new
loadtime:3.5665202140808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwood' limit 1
loadtime:3.5665981769562 / seconds
Query Executed:select id FROM `va` where city='Hartwood' && SIC_code='7231'DB:business_master_new
loadtime:3.5672471523285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:3.5673010349274 / seconds
Query Executed:select id FROM `va` where city='Hayes' && SIC_code='7231'DB:business_master_new
loadtime:3.6433691978455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haymarket' limit 1
loadtime:3.6434600353241 / seconds
Query Executed:select id FROM `va` where city='Haymarket' && SIC_code='7231'DB:business_master_new
loadtime:3.7197701931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haynesville' limit 1
loadtime:3.7198910713196 / seconds
Query Executed:select id FROM `va` where city='Haynesville' && SIC_code='7231'DB:business_master_new
loadtime:3.7205410003662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysi' limit 1
loadtime:3.720596075058 / seconds
Query Executed:select id FROM `va` where city='Haysi' && SIC_code='7231'DB:business_master_new
loadtime:3.7222440242767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:3.7223210334778 / seconds
Query Executed:select id FROM `va` where city='Haywood' && SIC_code='7231'DB:business_master_new
loadtime:3.7228450775146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Head Waters' limit 1
loadtime:3.7229111194611 / seconds
Query Executed:select id FROM `va` where city='Head Waters' && SIC_code='7231'DB:business_master_new
loadtime:3.723354101181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heathsville' limit 1
loadtime:3.7234120368958 / seconds
Query Executed:select id FROM `va` where city='Heathsville' && SIC_code='7231'DB:business_master_new
loadtime:3.7263300418854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:3.7264001369476 / seconds
Query Executed:select id FROM `va` where city='Henry' && SIC_code='7231'DB:business_master_new
loadtime:3.7273571491241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:3.7274250984192 / seconds
Query Executed:select id FROM `va` where city='Herndon' && SIC_code='7231'DB:business_master_new
loadtime:3.7754900455475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Springs' limit 1
loadtime:3.7756700515747 / seconds
Query Executed:select id FROM `va` where city='Highland Springs' && SIC_code='7231'DB:business_master_new
loadtime:3.7762010097504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightown' limit 1
loadtime:3.7762660980225 / seconds
Query Executed:select id FROM `va` where city='Hightown' && SIC_code='7231'DB:business_master_new
loadtime:3.776670217514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsville' limit 1
loadtime:3.7767231464386 / seconds
Query Executed:select id FROM `va` where city='Hillsville' && SIC_code='7231'DB:business_master_new
loadtime:3.8531551361084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiltons' limit 1
loadtime:3.853255033493 / seconds
Query Executed:select id FROM `va` where city='Hiltons' && SIC_code='7231'DB:business_master_new
loadtime:3.8541040420532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:3.8541741371155 / seconds
Query Executed:select id FROM `va` where city='Hinton' && SIC_code='7231'DB:business_master_new
loadtime:3.8548781871796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiwassee' limit 1
loadtime:3.8549330234528 / seconds
Query Executed:select id FROM `va` where city='Hiwassee' && SIC_code='7231'DB:business_master_new
loadtime:3.8557450771332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:3.8557980060577 / seconds
Query Executed:select id FROM `va` where city='Hollins' && SIC_code='7231'DB:business_master_new
loadtime:3.8562471866608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaker' limit 1
loadtime:3.856299161911 / seconds
Query Executed:select id FROM `va` where city='Honaker' && SIC_code='7231'DB:business_master_new
loadtime:3.8583710193634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood' limit 1
loadtime:3.858451128006 / seconds
Query Executed:select id FROM `va` where city='Hood' && SIC_code='7231'DB:business_master_new
loadtime:3.858950138092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:3.8590052127838 / seconds
Query Executed:select id FROM `va` where city='Hopewell' && SIC_code='7231'DB:business_master_new
loadtime:3.8754251003265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horntown' limit 1
loadtime:3.8755321502686 / seconds
Query Executed:select id FROM `va` where city='Horntown' && SIC_code='7231'DB:business_master_new
loadtime:3.8761250972748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horsepen' limit 1
loadtime:3.876195192337 / seconds
Query Executed:select id FROM `va` where city='Horsepen' && SIC_code='7231'DB:business_master_new
loadtime:3.8765530586243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:3.8766131401062 / seconds
Query Executed:select id FROM `va` where city='Hot Springs' && SIC_code='7231'DB:business_master_new
loadtime:3.878769159317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howardsville' limit 1
loadtime:3.8788402080536 / seconds
Query Executed:select id FROM `va` where city='Howardsville' && SIC_code='7231'DB:business_master_new
loadtime:3.8793730735779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howertons' limit 1
loadtime:3.8794431686401 / seconds
Query Executed:select id FROM `va` where city='Howertons' && SIC_code='7231'DB:business_master_new
loadtime:3.8798861503601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huddleston' limit 1
loadtime:3.8799440860748 / seconds
Query Executed:select id FROM `va` where city='Huddleston' && SIC_code='7231'DB:business_master_new
loadtime:3.8816931247711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudgins' limit 1
loadtime:3.8817632198334 / seconds
Query Executed:select id FROM `va` where city='Hudgins' && SIC_code='7231'DB:business_master_new
loadtime:3.8824992179871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hume' limit 1
loadtime:3.8825650215149 / seconds
Query Executed:select id FROM `va` where city='Hume' && SIC_code='7231'DB:business_master_new
loadtime:3.8833990097046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntly' limit 1
loadtime:3.8834521770477 / seconds
Query Executed:select id FROM `va` where city='Huntly' && SIC_code='7231'DB:business_master_new
loadtime:3.8840742111206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:3.8841261863708 / seconds
Query Executed:select id FROM `va` where city='Hurley' && SIC_code='7231'DB:business_master_new
loadtime:3.885094165802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurt' limit 1
loadtime:3.8851652145386 / seconds
Query Executed:select id FROM `va` where city='Hurt' && SIC_code='7231'DB:business_master_new
loadtime:3.8874161243439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustle' limit 1
loadtime:3.8874921798706 / seconds
Query Executed:select id FROM `va` where city='Hustle' && SIC_code='7231'DB:business_master_new
loadtime:3.8879911899567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:3.8880500793457 / seconds
Query Executed:select id FROM `va` where city='Independence' && SIC_code='7231'DB:business_master_new
loadtime:3.8910801410675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Valley' limit 1
loadtime:3.8911511898041 / seconds
Query Executed:select id FROM `va` where city='Indian Valley' && SIC_code='7231'DB:business_master_new
loadtime:3.8916201591492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Gate' limit 1
loadtime:3.8916730880737 / seconds
Query Executed:select id FROM `va` where city='Iron Gate' && SIC_code='7231'DB:business_master_new
loadtime:3.8921840190887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironto' limit 1
loadtime:3.892235994339 / seconds
Query Executed:select id FROM `va` where city='Ironto' && SIC_code='7231'DB:business_master_new
loadtime:3.892646074295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:3.8926980495453 / seconds
Query Executed:select id FROM `va` where city='Irvington' && SIC_code='7231'DB:business_master_new
loadtime:3.8942220211029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Wight' limit 1
loadtime:3.8942890167236 / seconds
Query Executed:select id FROM `va` where city='Isle Of Wight' && SIC_code='7231'DB:business_master_new
loadtime:3.8949780464172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:3.8950312137604 / seconds
Query Executed:select id FROM `va` where city='Ivanhoe' && SIC_code='7231'DB:business_master_new
loadtime:3.8956739902496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivor' limit 1
loadtime:3.8957250118256 / seconds
Query Executed:select id FROM `va` where city='Ivor' && SIC_code='7231'DB:business_master_new
loadtime:3.8970561027527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivy' limit 1
loadtime:3.8971271514893 / seconds
Query Executed:select id FROM `va` where city='Ivy' && SIC_code='7231'DB:business_master_new
loadtime:3.8981251716614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:3.8981800079346 / seconds
Query Executed:select id FROM `va` where city='Jamaica' && SIC_code='7231'DB:business_master_new
loadtime:3.8986570835114 / seconds
Query loaded from cache:select * from geodata_geocity where city='James Store' limit 1
loadtime:3.8987090587616 / seconds
Query Executed:select id FROM `va` where city='James Store' && SIC_code='7231'DB:business_master_new
loadtime:3.899129152298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:3.8991811275482 / seconds
Query Executed:select id FROM `va` where city='Jamestown' && SIC_code='7231'DB:business_master_new
loadtime:3.8995940685272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:3.8996441364288 / seconds
Query Executed:select id FROM `va` where city='Jamesville' && SIC_code='7231'DB:business_master_new
loadtime:3.9001140594482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarratt' limit 1
loadtime:3.9001660346985 / seconds
Query Executed:select id FROM `va` where city='Jarratt' && SIC_code='7231'DB:business_master_new
loadtime:3.9015500545502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:3.9016201496124 / seconds
Query Executed:select id FROM `va` where city='Java' && SIC_code='7231'DB:business_master_new
loadtime:3.9023551940918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonton' limit 1
loadtime:3.9024221897125 / seconds
Query Executed:select id FROM `va` where city='Jeffersonton' && SIC_code='7231'DB:business_master_new
loadtime:3.9034440517426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkins Bridge' limit 1
loadtime:3.9034972190857 / seconds
Query Executed:select id FROM `va` where city='Jenkins Bridge' && SIC_code='7231'DB:business_master_new
loadtime:3.9038951396942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey' limit 1
loadtime:3.9039521217346 / seconds
Query Executed:select id FROM `va` where city='Jersey' && SIC_code='7231'DB:business_master_new
loadtime:3.9043850898743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetersville' limit 1
loadtime:3.904440164566 / seconds
Query Executed:select id FROM `va` where city='Jetersville' && SIC_code='7231'DB:business_master_new
loadtime:3.9055871963501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell Ridge' limit 1
loadtime:3.9056401252747 / seconds
Query Executed:select id FROM `va` where city='Jewell Ridge' && SIC_code='7231'DB:business_master_new
loadtime:3.9061532020569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:3.9062051773071 / seconds
Query Executed:select id FROM `va` where city='Jonesville' && SIC_code='7231'DB:business_master_new
loadtime:3.908863067627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keeling' limit 1
loadtime:3.9089469909668 / seconds
Query Executed:select id FROM `va` where city='Keeling' && SIC_code='7231'DB:business_master_new
loadtime:3.9097080230713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keen Mountain' limit 1
loadtime:3.909775018692 / seconds
Query Executed:select id FROM `va` where city='Keen Mountain' && SIC_code='7231'DB:business_master_new
loadtime:3.9104611873627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:3.9105269908905 / seconds
Query Executed:select id FROM `va` where city='Keene' && SIC_code='7231'DB:business_master_new
loadtime:3.9110732078552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keezletown' limit 1
loadtime:3.9111261367798 / seconds
Query Executed:select id FROM `va` where city='Keezletown' && SIC_code='7231'DB:business_master_new
loadtime:3.9119091033936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:3.9119601249695 / seconds
Query Executed:select id FROM `va` where city='Keller' && SIC_code='7231'DB:business_master_new
loadtime:3.9126360416412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenbridge' limit 1
loadtime:3.9126870632172 / seconds
Query Executed:select id FROM `va` where city='Kenbridge' && SIC_code='7231'DB:business_master_new
loadtime:3.9153361320496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kents Store' limit 1
loadtime:3.9154081344604 / seconds
Query Executed:select id FROM `va` where city='Kents Store' && SIC_code='7231'DB:business_master_new
loadtime:3.9163031578064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokee' limit 1
loadtime:3.9163711071014 / seconds
Query Executed:select id FROM `va` where city='Keokee' && SIC_code='7231'DB:business_master_new
loadtime:3.9169201850891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:3.9169781208038 / seconds
Query Executed:select id FROM `va` where city='Keswick' && SIC_code='7231'DB:business_master_new
loadtime:3.9194090366364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keysville' limit 1
loadtime:3.9194631576538 / seconds
Query Executed:select id FROM `va` where city='Keysville' && SIC_code='7231'DB:business_master_new
loadtime:3.9222550392151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmarnock' limit 1
loadtime:3.9223291873932 / seconds
Query Executed:select id FROM `va` where city='Kilmarnock' && SIC_code='7231'DB:business_master_new
loadtime:3.9986720085144 / seconds
Query loaded from cache:select * from geodata_geocity where city='King & Queen C H' limit 1
loadtime:3.9987649917603 / seconds
Query Executed:select id FROM `va` where city='King & Queen C H' && SIC_code='7231'DB:business_master_new
loadtime:3.9993321895599 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court Hous' limit 1
loadtime:3.999388217926 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court Hous' && SIC_code='7231'DB:business_master_new
loadtime:3.9998211860657 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court House' limit 1
loadtime:3.999881029129 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court House' && SIC_code='7231'DB:business_master_new
loadtime:4.0007522106171 / seconds
Query loaded from cache:select * from geodata_geocity where city='King George' limit 1
loadtime:4.0008051395416 / seconds
Query Executed:select id FROM `va` where city='King George' && SIC_code='7231'DB:business_master_new
loadtime:4.0772590637207 / seconds
Query loaded from cache:select * from geodata_geocity where city='King William' limit 1
loadtime:4.0773642063141 / seconds
Query Executed:select id FROM `va` where city='King William' && SIC_code='7231'DB:business_master_new
loadtime:4.079469203949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsale' limit 1
loadtime:4.0795431137085 / seconds
Query Executed:select id FROM `va` where city='Kinsale' && SIC_code='7231'DB:business_master_new
loadtime:4.0804162025452 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:4.0804710388184 / seconds
Query Executed:select id FROM `va` where city='La Crosse' && SIC_code='7231'DB:business_master_new
loadtime:4.0824010372162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey Spring' limit 1
loadtime:4.0824790000916 / seconds
Query Executed:select id FROM `va` where city='Lacey Spring' && SIC_code='7231'DB:business_master_new
loadtime:4.0829250812531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lackey' limit 1
loadtime:4.0829861164093 / seconds
Query Executed:select id FROM `va` where city='Lackey' && SIC_code='7231'DB:business_master_new
loadtime:4.0834610462189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:4.0835130214691 / seconds
Query Executed:select id FROM `va` where city='Ladysmith' && SIC_code='7231'DB:business_master_new
loadtime:4.0843820571899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:4.0844390392303 / seconds
Query Executed:select id FROM `va` where city='Lafayette' && SIC_code='7231'DB:business_master_new
loadtime:4.0848100185394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambsburg' limit 1
loadtime:4.0848619937897 / seconds
Query Executed:select id FROM `va` where city='Lambsburg' && SIC_code='7231'DB:business_master_new
loadtime:4.085391998291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:4.0854570865631 / seconds
Query Executed:select id FROM `va` where city='Lancaster' && SIC_code='7231'DB:business_master_new
loadtime:4.0878460407257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laneview' limit 1
loadtime:4.0879390239716 / seconds
Query Executed:select id FROM `va` where city='Laneview' && SIC_code='7231'DB:business_master_new
loadtime:4.0884389877319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanexa' limit 1
loadtime:4.0884940624237 / seconds
Query Executed:select id FROM `va` where city='Lanexa' && SIC_code='7231'DB:business_master_new
loadtime:4.0901391506195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley Afb' limit 1
loadtime:4.0902061462402 / seconds
Query Executed:select id FROM `va` where city='Langley Afb' && SIC_code='7231'DB:business_master_new
loadtime:4.0907130241394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Fork' limit 1
loadtime:4.0907771587372 / seconds
Query Executed:select id FROM `va` where city='Laurel Fork' && SIC_code='7231'DB:business_master_new
loadtime:4.0915400981903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:4.0915942192078 / seconds
Query Executed:select id FROM `va` where city='Lawrenceville' && SIC_code='7231'DB:business_master_new
loadtime:4.0957860946655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:4.0958800315857 / seconds
Query Executed:select id FROM `va` where city='Lebanon' && SIC_code='7231'DB:business_master_new
loadtime:4.172199010849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon Church' limit 1
loadtime:4.1723740100861 / seconds
Query Executed:select id FROM `va` where city='Lebanon Church' && SIC_code='7231'DB:business_master_new
loadtime:4.1729152202606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:4.1729731559753 / seconds
Query Executed:select id FROM `va` where city='Leesburg' && SIC_code='7231'DB:business_master_new
loadtime:4.2120501995087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:4.2121951580048 / seconds
Query Executed:select id FROM `va` where city='Leon' && SIC_code='7231'DB:business_master_new
loadtime:4.2127201557159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:4.2127799987793 / seconds
Query Executed:select id FROM `va` where city='Lexington' && SIC_code='7231'DB:business_master_new
loadtime:4.2302122116089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lightfoot' limit 1
loadtime:4.2303202152252 / seconds
Query Executed:select id FROM `va` where city='Lightfoot' && SIC_code='7231'DB:business_master_new
loadtime:4.2312791347504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lignum' limit 1
loadtime:4.2313370704651 / seconds
Query Executed:select id FROM `va` where city='Lignum' && SIC_code='7231'DB:business_master_new
loadtime:4.2320010662079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:4.2320580482483 / seconds
Query Executed:select id FROM `va` where city='Lincoln' && SIC_code='7231'DB:business_master_new
loadtime:4.2326080799103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:4.2326591014862 / seconds
Query Executed:select id FROM `va` where city='Linden' && SIC_code='7231'DB:business_master_new
loadtime:4.2341442108154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:4.23419713974 / seconds
Query Executed:select id FROM `va` where city='Linville' && SIC_code='7231'DB:business_master_new
loadtime:4.2351720333099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Plymouth' limit 1
loadtime:4.2352252006531 / seconds
Query Executed:select id FROM `va` where city='Little Plymouth' && SIC_code='7231'DB:business_master_new
loadtime:4.2356669902802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lively' limit 1
loadtime:4.2357201576233 / seconds
Query Executed:select id FROM `va` where city='Lively' && SIC_code='7231'DB:business_master_new
loadtime:4.236524105072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Dale' limit 1
loadtime:4.2365911006927 / seconds
Query Executed:select id FROM `va` where city='Locust Dale' && SIC_code='7231'DB:business_master_new
loadtime:4.2371180057526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Grove' limit 1
loadtime:4.2371730804443 / seconds
Query Executed:select id FROM `va` where city='Locust Grove' && SIC_code='7231'DB:business_master_new
loadtime:4.2410931587219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Hill' limit 1
loadtime:4.2411720752716 / seconds
Query Executed:select id FROM `va` where city='Locust Hill' && SIC_code='7231'DB:business_master_new
loadtime:4.2419111728668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locustville' limit 1
loadtime:4.2419781684875 / seconds
Query Executed:select id FROM `va` where city='Locustville' && SIC_code='7231'DB:business_master_new
loadtime:4.2425150871277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:4.2425680160522 / seconds
Query Executed:select id FROM `va` where city='Long Island' && SIC_code='7231'DB:business_master_new
loadtime:4.2432980537415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:4.2433631420135 / seconds
Query Executed:select id FROM `va` where city='Loretto' && SIC_code='7231'DB:business_master_new
loadtime:4.2437601089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorton' limit 1
loadtime:4.243812084198 / seconds
Query Executed:select id FROM `va` where city='Lorton' && SIC_code='7231'DB:business_master_new
loadtime:4.2630791664124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lottsburg' limit 1
loadtime:4.2631599903107 / seconds
Query Executed:select id FROM `va` where city='Lottsburg' && SIC_code='7231'DB:business_master_new
loadtime:4.2643752098083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisa' limit 1
loadtime:4.2644441127777 / seconds
Query Executed:select id FROM `va` where city='Louisa' && SIC_code='7231'DB:business_master_new
loadtime:4.3424789905548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovettsville' limit 1
loadtime:4.3426051139832 / seconds
Query Executed:select id FROM `va` where city='Lovettsville' && SIC_code='7231'DB:business_master_new
loadtime:4.3456211090088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovingston' limit 1
loadtime:4.3456931114197 / seconds
Query Executed:select id FROM `va` where city='Lovingston' && SIC_code='7231'DB:business_master_new
loadtime:4.3478281497955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:4.3479051589966 / seconds
Query Executed:select id FROM `va` where city='Low Moor' && SIC_code='7231'DB:business_master_new
loadtime:4.3487730026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowesville' limit 1
loadtime:4.348827123642 / seconds
Query Executed:select id FROM `va` where city='Lowesville' && SIC_code='7231'DB:business_master_new
loadtime:4.3492140769958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowmoor' limit 1
loadtime:4.3492691516876 / seconds
Query Executed:select id FROM `va` where city='Lowmoor' && SIC_code='7231'DB:business_master_new
loadtime:4.3496241569519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:4.3496751785278 / seconds
Query Executed:select id FROM `va` where city='Lowry' && SIC_code='7231'DB:business_master_new
loadtime:4.3500781059265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:4.3501310348511 / seconds
Query Executed:select id FROM `va` where city='Lunenburg' && SIC_code='7231'DB:business_master_new
loadtime:4.3507690429688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:4.350821018219 / seconds
Query Executed:select id FROM `va` where city='Luray' && SIC_code='7231'DB:business_master_new
loadtime:4.4274191856384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynch Station' limit 1
loadtime:4.4275860786438 / seconds
Query Executed:select id FROM `va` where city='Lynch Station' && SIC_code='7231'DB:business_master_new
loadtime:4.4287521839142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:4.4288280010223 / seconds
Query Executed:select id FROM `va` where city='Lynchburg' && SIC_code='7231'DB:business_master_new
loadtime:4.4885251522064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:4.4888892173767 / seconds
Query Executed:select id FROM `va` where city='Lyndhurst' && SIC_code='7231'DB:business_master_new
loadtime:4.490070104599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Machipongo' limit 1
loadtime:4.4901490211487 / seconds
Query Executed:select id FROM `va` where city='Machipongo' && SIC_code='7231'DB:business_master_new
loadtime:4.4909121990204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:4.4909651279449 / seconds
Query Executed:select id FROM `va` where city='Macon' && SIC_code='7231'DB:business_master_new
loadtime:4.4913740158081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:4.4914271831512 / seconds
Query Executed:select id FROM `va` where city='Madison' && SIC_code='7231'DB:business_master_new
loadtime:4.4954280853271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:4.4955101013184 / seconds
Query Executed:select id FROM `va` where city='Madison Heights' && SIC_code='7231'DB:business_master_new
loadtime:4.5719540119171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Mills' limit 1
loadtime:4.5721340179443 / seconds
Query Executed:select id FROM `va` where city='Madison Mills' && SIC_code='7231'DB:business_master_new
loadtime:4.5727779865265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidens' limit 1
loadtime:4.5728352069855 / seconds
Query Executed:select id FROM `va` where city='Maidens' && SIC_code='7231'DB:business_master_new
loadtime:4.5741691589355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manakin Sabot' limit 1
loadtime:4.5742411613464 / seconds
Query Executed:select id FROM `va` where city='Manakin Sabot' && SIC_code='7231'DB:business_master_new
loadtime:4.5776591300964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas' limit 1
loadtime:4.5777339935303 / seconds
Query Executed:select id FROM `va` where city='Manassas' && SIC_code='7231'DB:business_master_new
loadtime:4.6508271694183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas Park' limit 1
loadtime:4.6511580944061 / seconds
Query Executed:select id FROM `va` where city='Manassas Park' && SIC_code='7231'DB:business_master_new
loadtime:4.6517531871796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mangohick' limit 1
loadtime:4.6518220901489 / seconds
Query Executed:select id FROM `va` where city='Mangohick' && SIC_code='7231'DB:business_master_new
loadtime:4.6521830558777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannboro' limit 1
loadtime:4.6522371768951 / seconds
Query Executed:select id FROM `va` where city='Mannboro' && SIC_code='7231'DB:business_master_new
loadtime:4.652624130249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manquin' limit 1
loadtime:4.6526761054993 / seconds
Query Executed:select id FROM `va` where city='Manquin' && SIC_code='7231'DB:business_master_new
loadtime:4.6535210609436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mappsville' limit 1
loadtime:4.6535739898682 / seconds
Query Executed:select id FROM `va` where city='Mappsville' && SIC_code='7231'DB:business_master_new
loadtime:4.6542110443115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:4.6542811393738 / seconds
Query Executed:select id FROM `va` where city='Marion' && SIC_code='7231'DB:business_master_new
loadtime:4.7307810783386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marionville' limit 1
loadtime:4.7309629917145 / seconds
Query Executed:select id FROM `va` where city='Marionville' && SIC_code='7231'DB:business_master_new
loadtime:4.7315831184387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markham' limit 1
loadtime:4.7316410541534 / seconds
Query Executed:select id FROM `va` where city='Markham' && SIC_code='7231'DB:business_master_new
loadtime:4.7323021888733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:4.7323570251465 / seconds
Query Executed:select id FROM `va` where city='Marshall' && SIC_code='7231'DB:business_master_new
loadtime:4.736955165863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:4.7370381355286 / seconds
Query Executed:select id FROM `va` where city='Martinsville' && SIC_code='7231'DB:business_master_new
loadtime:4.7663152217865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maryus' limit 1
loadtime:4.7665200233459 / seconds
Query Executed:select id FROM `va` where city='Maryus' && SIC_code='7231'DB:business_master_new
loadtime:4.7670080661774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mascot' limit 1
loadtime:4.7670781612396 / seconds
Query Executed:select id FROM `va` where city='Mascot' && SIC_code='7231'DB:business_master_new
loadtime:4.7675070762634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massies Mill' limit 1
loadtime:4.7675590515137 / seconds
Query Executed:select id FROM `va` where city='Massies Mill' && SIC_code='7231'DB:business_master_new
loadtime:4.7679920196533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:4.7680490016937 / seconds
Query Executed:select id FROM `va` where city='Mathews' && SIC_code='7231'DB:business_master_new
loadtime:4.771213054657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattaponi' limit 1
loadtime:4.7712872028351 / seconds
Query Executed:select id FROM `va` where city='Mattaponi' && SIC_code='7231'DB:business_master_new
loadtime:4.7720501422882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurertown' limit 1
loadtime:4.77210521698 / seconds
Query Executed:select id FROM `va` where city='Maurertown' && SIC_code='7231'DB:business_master_new
loadtime:4.7734320163727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mavisdale' limit 1
loadtime:4.7734990119934 / seconds
Query Executed:select id FROM `va` where city='Mavisdale' && SIC_code='7231'DB:business_master_new
loadtime:4.7739260196686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Max Meadows' limit 1
loadtime:4.773980140686 / seconds
Query Executed:select id FROM `va` where city='Max Meadows' && SIC_code='7231'DB:business_master_new
loadtime:4.7763061523438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxie' limit 1
loadtime:4.776388168335 / seconds
Query Executed:select id FROM `va` where city='Maxie' && SIC_code='7231'DB:business_master_new
loadtime:4.7769191265106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clure' limit 1
loadtime:4.7769742012024 / seconds
Query Executed:select id FROM `va` where city='Mc Clure' && SIC_code='7231'DB:business_master_new
loadtime:4.7774641513824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:4.777517080307 / seconds
Query Executed:select id FROM `va` where city='Mc Coy' && SIC_code='7231'DB:business_master_new
loadtime:4.7779920101166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Dowell' limit 1
loadtime:4.7780501842499 / seconds
Query Executed:select id FROM `va` where city='Mc Dowell' && SIC_code='7231'DB:business_master_new
loadtime:4.7787930965424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gaheysville' limit 1
loadtime:4.778843164444 / seconds
Query Executed:select id FROM `va` where city='Mc Gaheysville' && SIC_code='7231'DB:business_master_new
loadtime:4.7805790901184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenney' limit 1
loadtime:4.7806460857391 / seconds
Query Executed:select id FROM `va` where city='Mc Kenney' && SIC_code='7231'DB:business_master_new
loadtime:4.7819771766663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lean' limit 1
loadtime:4.7820529937744 / seconds
Query Executed:select id FROM `va` where city='Mc Lean' && SIC_code='7231'DB:business_master_new
loadtime:4.8418650627136 / seconds
Query Executed:select * from geodata_geocity where city='Mckenney' limit 1DB:business_master_new
loadtime:4.8425421714783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mclean' limit 1
loadtime:4.8426120281219 / seconds
Query Executed:select id FROM `va` where city='Mclean' && SIC_code='7231'DB:business_master_new
loadtime:4.8434391021729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows Of Dan' limit 1
loadtime:4.8435060977936 / seconds
Query Executed:select id FROM `va` where city='Meadows Of Dan' && SIC_code='7231'DB:business_master_new
loadtime:4.8447730541229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowview' limit 1
loadtime:4.844841003418 / seconds
Query Executed:select id FROM `va` where city='Meadowview' && SIC_code='7231'DB:business_master_new
loadtime:4.8466520309448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:4.8467261791229 / seconds
Query Executed:select id FROM `va` where city='Mears' && SIC_code='7231'DB:business_master_new
loadtime:4.8472301959991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:4.8472859859467 / seconds
Query Executed:select id FROM `va` where city='Mechanicsville' && SIC_code='7231'DB:business_master_new
loadtime:4.8786790370941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meherrin' limit 1
loadtime:4.8788340091705 / seconds
Query Executed:select id FROM `va` where city='Meherrin' && SIC_code='7231'DB:business_master_new
loadtime:4.8796691894531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melfa' limit 1
loadtime:4.8797299861908 / seconds
Query Executed:select id FROM `va` where city='Melfa' && SIC_code='7231'DB:business_master_new
loadtime:4.8811750411987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendota' limit 1
loadtime:4.8812420368195 / seconds
Query Executed:select id FROM `va` where city='Mendota' && SIC_code='7231'DB:business_master_new
loadtime:4.8817632198334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredithville' limit 1
loadtime:4.8818151950836 / seconds
Query Executed:select id FROM `va` where city='Meredithville' && SIC_code='7231'DB:business_master_new
loadtime:4.8822040557861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrifield' limit 1
loadtime:4.8822569847107 / seconds
Query Executed:select id FROM `va` where city='Merrifield' && SIC_code='7231'DB:business_master_new
loadtime:4.8841061592102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Point' limit 1
loadtime:4.8841731548309 / seconds
Query Executed:select id FROM `va` where city='Merry Point' && SIC_code='7231'DB:business_master_new
loadtime:4.8846101760864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebrook' limit 1
loadtime:4.884663105011 / seconds
Query Executed:select id FROM `va` where city='Middlebrook' && SIC_code='7231'DB:business_master_new
loadtime:4.8854451179504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:4.8855111598969 / seconds
Query Executed:select id FROM `va` where city='Middleburg' && SIC_code='7231'DB:business_master_new
loadtime:4.9633190631866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:4.9635012149811 / seconds
Query Executed:select id FROM `va` where city='Middletown' && SIC_code='7231'DB:business_master_new
loadtime:4.9655640125275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:4.9656701087952 / seconds
Query Executed:select id FROM `va` where city='Midland' && SIC_code='7231'DB:business_master_new
loadtime:4.9673771858215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midlothian' limit 1
loadtime:4.9674580097198 / seconds
Query Executed:select id FROM `va` where city='Midlothian' && SIC_code='7231'DB:business_master_new
loadtime:5.0091381072998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:5.0093669891357 / seconds
Query Executed:select id FROM `va` where city='Milford' && SIC_code='7231'DB:business_master_new
loadtime:5.0108020305634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millboro' limit 1
loadtime:5.0108799934387 / seconds
Query Executed:select id FROM `va` where city='Millboro' && SIC_code='7231'DB:business_master_new
loadtime:5.0119850635529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Tavern' limit 1
loadtime:5.012059211731 / seconds
Query Executed:select id FROM `va` where city='Millers Tavern' && SIC_code='7231'DB:business_master_new
loadtime:5.0126981735229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:5.0127530097961 / seconds
Query Executed:select id FROM `va` where city='Millwood' && SIC_code='7231'DB:business_master_new
loadtime:5.0134871006012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Run' limit 1
loadtime:5.0135390758514 / seconds
Query Executed:select id FROM `va` where city='Mine Run' && SIC_code='7231'DB:business_master_new
loadtime:5.0140051841736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:5.0140631198883 / seconds
Query Executed:select id FROM `va` where city='Mineral' && SIC_code='7231'DB:business_master_new
loadtime:5.0177040100098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Spring' limit 1
loadtime:5.0177760124207 / seconds
Query Executed:select id FROM `va` where city='Mint Spring' && SIC_code='7231'DB:business_master_new
loadtime:5.0183410644531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchells' limit 1
loadtime:5.0183961391449 / seconds
Query Executed:select id FROM `va` where city='Mitchells' && SIC_code='7231'DB:business_master_new
loadtime:5.0189971923828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modest Town' limit 1
loadtime:5.0190541744232 / seconds
Query Executed:select id FROM `va` where city='Modest Town' && SIC_code='7231'DB:business_master_new
loadtime:5.0194540023804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mollusk' limit 1
loadtime:5.0195050239563 / seconds
Query Executed:select id FROM `va` where city='Mollusk' && SIC_code='7231'DB:business_master_new
loadtime:5.0199711322784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moneta' limit 1
loadtime:5.0200271606445 / seconds
Query Executed:select id FROM `va` where city='Moneta' && SIC_code='7231'DB:business_master_new
loadtime:5.096036195755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:5.0961830615997 / seconds
Query Executed:select id FROM `va` where city='Monroe' && SIC_code='7231'DB:business_master_new
loadtime:5.0979812145233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montebello' limit 1
loadtime:5.0980591773987 / seconds
Query Executed:select id FROM `va` where city='Montebello' && SIC_code='7231'DB:business_master_new
loadtime:5.0985569953918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:5.098610162735 / seconds
Query Executed:select id FROM `va` where city='Monterey' && SIC_code='7231'DB:business_master_new
loadtime:5.1006891727448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:5.10076212883 / seconds
Query Executed:select id FROM `va` where city='Montpelier' && SIC_code='7231'DB:business_master_new
loadtime:5.1034951210022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Sta' limit 1
loadtime:5.1035652160645 / seconds
Query Executed:select id FROM `va` where city='Montpelier Sta' && SIC_code='7231'DB:business_master_new
loadtime:5.1039350032806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Station' limit 1
loadtime:5.1039891242981 / seconds
Query Executed:select id FROM `va` where city='Montpelier Station' && SIC_code='7231'DB:business_master_new
loadtime:5.1043980121613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montross' limit 1
loadtime:5.1044521331787 / seconds
Query Executed:select id FROM `va` where city='Montross' && SIC_code='7231'DB:business_master_new
loadtime:5.107773065567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:5.1078591346741 / seconds
Query Executed:select id FROM `va` where city='Montvale' && SIC_code='7231'DB:business_master_new
loadtime:5.1090362071991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moon' limit 1
loadtime:5.1091060638428 / seconds
Query Executed:select id FROM `va` where city='Moon' && SIC_code='7231'DB:business_master_new
loadtime:5.1096169948578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morattico' limit 1
loadtime:5.1096692085266 / seconds
Query Executed:select id FROM `va` where city='Morattico' && SIC_code='7231'DB:business_master_new
loadtime:5.1101570129395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:5.1102111339569 / seconds
Query Executed:select id FROM `va` where city='Morrisville' && SIC_code='7231'DB:business_master_new
loadtime:5.110668182373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moseley' limit 1
loadtime:5.1107211112976 / seconds
Query Executed:select id FROM `va` where city='Moseley' && SIC_code='7231'DB:business_master_new
loadtime:5.1126470565796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Crawford' limit 1
loadtime:5.1127140522003 / seconds
Query Executed:select id FROM `va` where city='Mount Crawford' && SIC_code='7231'DB:business_master_new
loadtime:5.1146941184998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:5.1147620677948 / seconds
Query Executed:select id FROM `va` where city='Mount Holly' && SIC_code='7231'DB:business_master_new
loadtime:5.1153590679169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Jackson' limit 1
loadtime:5.1154141426086 / seconds
Query Executed:select id FROM `va` where city='Mount Jackson' && SIC_code='7231'DB:business_master_new
loadtime:5.11927318573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sidney' limit 1
loadtime:5.1193540096283 / seconds
Query Executed:select id FROM `va` where city='Mount Sidney' && SIC_code='7231'DB:business_master_new
loadtime:5.1206011772156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Solon' limit 1
loadtime:5.1206560134888 / seconds
Query Executed:select id FROM `va` where city='Mount Solon' && SIC_code='7231'DB:business_master_new
loadtime:5.1219680309296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:5.1220400333405 / seconds
Query Executed:select id FROM `va` where city='Mount Vernon' && SIC_code='7231'DB:business_master_new
loadtime:5.1229121685028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mouth Of Wilson' limit 1
loadtime:5.1229660511017 / seconds
Query Executed:select id FROM `va` where city='Mouth Of Wilson' && SIC_code='7231'DB:business_master_new
loadtime:5.1238470077515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Crawford' limit 1
loadtime:5.123908996582 / seconds
Query Executed:select id FROM `va` where city='Mt Crawford' && SIC_code='7231'DB:business_master_new
loadtime:5.1243600845337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:5.1244120597839 / seconds
Query Executed:select id FROM `va` where city='Mt Holly' && SIC_code='7231'DB:business_master_new
loadtime:5.1247789859772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Jackson' limit 1
loadtime:5.1248300075531 / seconds
Query Executed:select id FROM `va` where city='Mt Jackson' && SIC_code='7231'DB:business_master_new
loadtime:5.1253011226654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sidney' limit 1
loadtime:5.1253530979156 / seconds
Query Executed:select id FROM `va` where city='Mt Sidney' && SIC_code='7231'DB:business_master_new
loadtime:5.1257400512695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Solon' limit 1
loadtime:5.1257910728455 / seconds
Query Executed:select id FROM `va` where city='Mt Solon' && SIC_code='7231'DB:business_master_new
loadtime:5.126186132431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:5.126237154007 / seconds
Query Executed:select id FROM `va` where city='Mt Vernon' && SIC_code='7231'DB:business_master_new
loadtime:5.1266300678253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mustoe' limit 1
loadtime:5.1266801357269 / seconds
Query Executed:select id FROM `va` where city='Mustoe' && SIC_code='7231'DB:business_master_new
loadtime:5.1270771026611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narrows' limit 1
loadtime:5.1271290779114 / seconds
Query Executed:select id FROM `va` where city='Narrows' && SIC_code='7231'DB:business_master_new
loadtime:5.1292150020599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naruna' limit 1
loadtime:5.1292850971222 / seconds
Query Executed:select id FROM `va` where city='Naruna' && SIC_code='7231'DB:business_master_new
loadtime:5.1298320293427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nassawadox' limit 1
loadtime:5.1298940181732 / seconds
Query Executed:select id FROM `va` where city='Nassawadox' && SIC_code='7231'DB:business_master_new
loadtime:5.1313090324402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathalie' limit 1
loadtime:5.1313741207123 / seconds
Query Executed:select id FROM `va` where city='Nathalie' && SIC_code='7231'DB:business_master_new
loadtime:5.1333041191101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Brdg Sta' limit 1
loadtime:5.1333720684052 / seconds
Query Executed:select id FROM `va` where city='Natural Brdg Sta' && SIC_code='7231'DB:business_master_new
loadtime:5.1338031291962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge' limit 1
loadtime:5.1338670253754 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge' && SIC_code='7231'DB:business_master_new
loadtime:5.1350960731506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge Station' limit 1
loadtime:5.1351501941681 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge Station' && SIC_code='7231'DB:business_master_new
loadtime:5.1361021995544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naval Base' limit 1
loadtime:5.1361680030823 / seconds
Query Executed:select id FROM `va` where city='Naval Base' && SIC_code='7231'DB:business_master_new
loadtime:5.1367461681366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellysford' limit 1
loadtime:5.1367981433868 / seconds
Query Executed:select id FROM `va` where city='Nellysford' && SIC_code='7231'DB:business_master_new
loadtime:5.1386091709137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:5.1386752128601 / seconds
Query Executed:select id FROM `va` where city='Nelson' && SIC_code='7231'DB:business_master_new
loadtime:5.1392760276794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonia' limit 1
loadtime:5.1393291950226 / seconds
Query Executed:select id FROM `va` where city='Nelsonia' && SIC_code='7231'DB:business_master_new
loadtime:5.1398870944977 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canton' limit 1
loadtime:5.1399390697479 / seconds
Query Executed:select id FROM `va` where city='New Canton' && SIC_code='7231'DB:business_master_new
loadtime:5.1408071517944 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:5.1408801078796 / seconds
Query Executed:select id FROM `va` where city='New Castle' && SIC_code='7231'DB:business_master_new
loadtime:5.1428220272064 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Church' limit 1
loadtime:5.1429080963135 / seconds
Query Executed:select id FROM `va` where city='New Church' && SIC_code='7231'DB:business_master_new
loadtime:5.1441841125488 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:5.1442542076111 / seconds
Query Executed:select id FROM `va` where city='New Hope' && SIC_code='7231'DB:business_master_new
loadtime:5.1447970867157 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Kent' limit 1
loadtime:5.1448581218719 / seconds
Query Executed:select id FROM `va` where city='New Kent' && SIC_code='7231'DB:business_master_new
loadtime:5.1465752124786 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:5.1466410160065 / seconds
Query Executed:select id FROM `va` where city='New Market' && SIC_code='7231'DB:business_master_new
loadtime:5.1504511833191 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Point' limit 1
loadtime:5.15052318573 / seconds
Query Executed:select id FROM `va` where city='New Point' && SIC_code='7231'DB:business_master_new
loadtime:5.1510000228882 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:5.1510601043701 / seconds
Query Executed:select id FROM `va` where city='New River' && SIC_code='7231'DB:business_master_new
loadtime:5.1515040397644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:5.1515560150146 / seconds
Query Executed:select id FROM `va` where city='Newbern' && SIC_code='7231'DB:business_master_new
loadtime:5.1521232128143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:5.1521761417389 / seconds
Query Executed:select id FROM `va` where city='Newington' && SIC_code='7231'DB:business_master_new
loadtime:5.1536750793457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:5.1537280082703 / seconds
Query Executed:select id FROM `va` where city='Newport' && SIC_code='7231'DB:business_master_new
loadtime:5.1547131538391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport News' limit 1
loadtime:5.1547651290894 / seconds
Query Executed:select id FROM `va` where city='Newport News' && SIC_code='7231'DB:business_master_new
loadtime:5.2479140758514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newsoms' limit 1
loadtime:5.2484230995178 / seconds
Query Executed:select id FROM `va` where city='Newsoms' && SIC_code='7231'DB:business_master_new
loadtime:5.2494461536407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:5.2495460510254 / seconds
Query Executed:select id FROM `va` where city='Newtown' && SIC_code='7231'DB:business_master_new
loadtime:5.2500600814819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickelsville' limit 1
loadtime:5.2501151561737 / seconds
Query Executed:select id FROM `va` where city='Nickelsville' && SIC_code='7231'DB:business_master_new
loadtime:5.2511570453644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninde' limit 1
loadtime:5.2512249946594 / seconds
Query Executed:select id FROM `va` where city='Ninde' && SIC_code='7231'DB:business_master_new
loadtime:5.251650094986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nokesville' limit 1
loadtime:5.2517042160034 / seconds
Query Executed:select id FROM `va` where city='Nokesville' && SIC_code='7231'DB:business_master_new
loadtime:5.2553701400757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora' limit 1
loadtime:5.2554430961609 / seconds
Query Executed:select id FROM `va` where city='Nora' && SIC_code='7231'DB:business_master_new
loadtime:5.2559940814972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:5.2560541629791 / seconds
Query Executed:select id FROM `va` where city='Norfolk' && SIC_code='7231'DB:business_master_new
loadtime:5.369213104248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norge' limit 1
loadtime:5.3698060512543 / seconds
Query Executed:select id FROM `va` where city='Norge' && SIC_code='7231'DB:business_master_new
loadtime:5.3705801963806 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:5.3706781864166 / seconds
Query Executed:select id FROM `va` where city='North' && SIC_code='7231'DB:business_master_new
loadtime:5.3713891506195 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Garden' limit 1
loadtime:5.3714561462402 / seconds
Query Executed:select id FROM `va` where city='North Garden' && SIC_code='7231'DB:business_master_new
loadtime:5.3726160526276 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Tazewell' limit 1
loadtime:5.3726711273193 / seconds
Query Executed:select id FROM `va` where city='North Tazewell' && SIC_code='7231'DB:business_master_new
loadtime:5.3753051757812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:5.3753941059113 / seconds
Query Executed:select id FROM `va` where city='Norton' && SIC_code='7231'DB:business_master_new
loadtime:5.4516150951385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:5.4517819881439 / seconds
Query Executed:select id FROM `va` where city='Norwood' && SIC_code='7231'DB:business_master_new
loadtime:5.4523651599884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottoway' limit 1
loadtime:5.4524230957031 / seconds
Query Executed:select id FROM `va` where city='Nottoway' && SIC_code='7231'DB:business_master_new
loadtime:5.4530820846558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nuttsville' limit 1
loadtime:5.4531362056732 / seconds
Query Executed:select id FROM `va` where city='Nuttsville' && SIC_code='7231'DB:business_master_new
loadtime:5.4535660743713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hall' limit 1
loadtime:5.4536180496216 / seconds
Query Executed:select id FROM `va` where city='Oak Hall' && SIC_code='7231'DB:business_master_new
loadtime:5.4546232223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakpark' limit 1
loadtime:5.4546911716461 / seconds
Query Executed:select id FROM `va` where city='Oakpark' && SIC_code='7231'DB:business_master_new
loadtime:5.4551680088043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakton' limit 1
loadtime:5.4552221298218 / seconds
Query Executed:select id FROM `va` where city='Oakton' && SIC_code='7231'DB:business_master_new
loadtime:5.5328090190887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakwood' limit 1
loadtime:5.5329520702362 / seconds
Query Executed:select id FROM `va` where city='Oakwood' && SIC_code='7231'DB:business_master_new
loadtime:5.5345721244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Occoquan' limit 1
loadtime:5.5346300601959 / seconds
Query Executed:select id FROM `va` where city='Occoquan' && SIC_code='7231'DB:business_master_new
loadtime:5.5365970134735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oilville' limit 1
loadtime:5.5366690158844 / seconds
Query Executed:select id FROM `va` where city='Oilville' && SIC_code='7231'DB:business_master_new
loadtime:5.5379650592804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldhams' limit 1
loadtime:5.5380251407623 / seconds
Query Executed:select id FROM `va` where city='Oldhams' && SIC_code='7231'DB:business_master_new
loadtime:5.5385110378265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onancock' limit 1
loadtime:5.5385630130768 / seconds
Query Executed:select id FROM `va` where city='Onancock' && SIC_code='7231'DB:business_master_new
loadtime:5.541748046875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onemo' limit 1
loadtime:5.5418281555176 / seconds
Query Executed:select id FROM `va` where city='Onemo' && SIC_code='7231'DB:business_master_new
loadtime:5.5423121452332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onley' limit 1
loadtime:5.5423672199249 / seconds
Query Executed:select id FROM `va` where city='Onley' && SIC_code='7231'DB:business_master_new
loadtime:5.5444090366364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophelia' limit 1
loadtime:5.5444860458374 / seconds
Query Executed:select id FROM `va` where city='Ophelia' && SIC_code='7231'DB:business_master_new
loadtime:5.5449411869049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:5.5449960231781 / seconds
Query Executed:select id FROM `va` where city='Orange' && SIC_code='7231'DB:business_master_new
loadtime:5.6216671466827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordinary' limit 1
loadtime:5.6218121051788 / seconds
Query Executed:select id FROM `va` where city='Ordinary' && SIC_code='7231'DB:business_master_new
loadtime:5.6225891113281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriskany' limit 1
loadtime:5.622661113739 / seconds
Query Executed:select id FROM `va` where city='Oriskany' && SIC_code='7231'DB:business_master_new
loadtime:5.623113155365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orkney Springs' limit 1
loadtime:5.6231679916382 / seconds
Query Executed:select id FROM `va` where city='Orkney Springs' && SIC_code='7231'DB:business_master_new
loadtime:5.6236231327057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlean' limit 1
loadtime:5.6236751079559 / seconds
Query Executed:select id FROM `va` where city='Orlean' && SIC_code='7231'DB:business_master_new
loadtime:5.6242570877075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyster' limit 1
loadtime:5.6243100166321 / seconds
Query Executed:select id FROM `va` where city='Oyster' && SIC_code='7231'DB:business_master_new
loadtime:5.62473320961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paeonian Springs' limit 1
loadtime:5.6247851848602 / seconds
Query Executed:select id FROM `va` where city='Paeonian Springs' && SIC_code='7231'DB:business_master_new
loadtime:5.6256101131439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Bank' limit 1
loadtime:5.6256620883942 / seconds
Query Executed:select id FROM `va` where city='Paint Bank' && SIC_code='7231'DB:business_master_new
loadtime:5.6261901855469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painter' limit 1
loadtime:5.6262421607971 / seconds
Query Executed:select id FROM `va` where city='Painter' && SIC_code='7231'DB:business_master_new
loadtime:5.6275010108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:5.6275770664215 / seconds
Query Executed:select id FROM `va` where city='Palmyra' && SIC_code='7231'DB:business_master_new
loadtime:5.7038950920105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplin' limit 1
loadtime:5.704066991806 / seconds
Query Executed:select id FROM `va` where city='Pamplin' && SIC_code='7231'DB:business_master_new
loadtime:5.705157995224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:5.7052311897278 / seconds
Query Executed:select id FROM `va` where city='Paris' && SIC_code='7231'DB:business_master_new
loadtime:5.7058911323547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksley' limit 1
loadtime:5.7059512138367 / seconds
Query Executed:select id FROM `va` where city='Parksley' && SIC_code='7231'DB:business_master_new
loadtime:5.7080512046814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrott' limit 1
loadtime:5.7081370353699 / seconds
Query Executed:select id FROM `va` where city='Parrott' && SIC_code='7231'DB:business_master_new
loadtime:5.7085871696472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partlow' limit 1
loadtime:5.7086441516876 / seconds
Query Executed:select id FROM `va` where city='Partlow' && SIC_code='7231'DB:business_master_new
loadtime:5.7095730304718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick Springs' limit 1
loadtime:5.7096509933472 / seconds
Query Executed:select id FROM `va` where city='Patrick Springs' && SIC_code='7231'DB:business_master_new
loadtime:5.7109351158142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:5.7110111713409 / seconds
Query Executed:select id FROM `va` where city='Patterson' && SIC_code='7231'DB:business_master_new
loadtime:5.7114520072937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearisburg' limit 1
loadtime:5.7115070819855 / seconds
Query Executed:select id FROM `va` where city='Pearisburg' && SIC_code='7231'DB:business_master_new
loadtime:5.7155320644379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:5.7156131267548 / seconds
Query Executed:select id FROM `va` where city='Pembroke' && SIC_code='7231'DB:business_master_new
loadtime:5.7173900604248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penhook' limit 1
loadtime:5.7174861431122 / seconds
Query Executed:select id FROM `va` where city='Penhook' && SIC_code='7231'DB:business_master_new
loadtime:5.7188670635223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penn Laird' limit 1
loadtime:5.7189490795135 / seconds
Query Executed:select id FROM `va` where city='Penn Laird' && SIC_code='7231'DB:business_master_new
loadtime:5.7200050354004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington Gap' limit 1
loadtime:5.720076084137 / seconds
Query Executed:select id FROM `va` where city='Pennington Gap' && SIC_code='7231'DB:business_master_new
loadtime:5.723601102829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:5.723687171936 / seconds
Query Executed:select id FROM `va` where city='Petersburg' && SIC_code='7231'DB:business_master_new
loadtime:5.7552371025085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix' limit 1
loadtime:5.755499124527 / seconds
Query Executed:select id FROM `va` where city='Phenix' && SIC_code='7231'DB:business_master_new
loadtime:5.7562880516052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomont' limit 1
loadtime:5.7563691139221 / seconds
Query Executed:select id FROM `va` where city='Philomont' && SIC_code='7231'DB:business_master_new
loadtime:5.7569341659546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilgrims Knob' limit 1
loadtime:5.7569890022278 / seconds
Query Executed:select id FROM `va` where city='Pilgrims Knob' && SIC_code='7231'DB:business_master_new
loadtime:5.7574520111084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot' limit 1
loadtime:5.7575039863586 / seconds
Query Executed:select id FROM `va` where city='Pilot' && SIC_code='7231'DB:business_master_new
loadtime:5.7582712173462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney River' limit 1
loadtime:5.7583250999451 / seconds
Query Executed:select id FROM `va` where city='Piney River' && SIC_code='7231'DB:business_master_new
loadtime:5.7590651512146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:5.759131193161 / seconds
Query Executed:select id FROM `va` where city='Pittsville' && SIC_code='7231'DB:business_master_new
loadtime:5.7597260475159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain View' limit 1
loadtime:5.7597951889038 / seconds
Query Executed:select id FROM `va` where city='Plain View' && SIC_code='7231'DB:business_master_new
loadtime:5.7603940963745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:5.760448217392 / seconds
Query Executed:select id FROM `va` where city='Pleasant Valley' && SIC_code='7231'DB:business_master_new
loadtime:5.7609481811523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:5.7610020637512 / seconds
Query Executed:select id FROM `va` where city='Pocahontas' && SIC_code='7231'DB:business_master_new
loadtime:5.7617571353912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquoson' limit 1
loadtime:5.7618281841278 / seconds
Query Executed:select id FROM `va` where city='Poquoson' && SIC_code='7231'DB:business_master_new
loadtime:5.7667911052704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Haywood' limit 1
loadtime:5.7668881416321 / seconds
Query Executed:select id FROM `va` where city='Port Haywood' && SIC_code='7231'DB:business_master_new
loadtime:5.7675750255585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:5.7676310539246 / seconds
Query Executed:select id FROM `va` where city='Port Republic' && SIC_code='7231'DB:business_master_new
loadtime:5.768648147583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:5.7687160968781 / seconds
Query Executed:select id FROM `va` where city='Port Royal' && SIC_code='7231'DB:business_master_new
loadtime:5.7695741653442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:5.7696440219879 / seconds
Query Executed:select id FROM `va` where city='Portsmouth' && SIC_code='7231'DB:business_master_new
loadtime:5.8143820762634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:5.8147060871124 / seconds
Query Executed:select id FROM `va` where city='Pound' && SIC_code='7231'DB:business_master_new
loadtime:5.8170750141144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pounding Mill' limit 1
loadtime:5.8171629905701 / seconds
Query Executed:select id FROM `va` where city='Pounding Mill' && SIC_code='7231'DB:business_master_new
loadtime:5.8187720775604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:5.8188691139221 / seconds
Query Executed:select id FROM `va` where city='Powhatan' && SIC_code='7231'DB:business_master_new
loadtime:5.8285820484161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratts' limit 1
loadtime:5.8286960124969 / seconds
Query Executed:select id FROM `va` where city='Pratts' && SIC_code='7231'DB:business_master_new
loadtime:5.8292870521545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince George' limit 1
loadtime:5.8293480873108 / seconds
Query Executed:select id FROM `va` where city='Prince George' && SIC_code='7231'DB:business_master_new
loadtime:5.8332500457764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:5.8333241939545 / seconds
Query Executed:select id FROM `va` where city='Prospect' && SIC_code='7231'DB:business_master_new
loadtime:5.8343551158905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence Forge' limit 1
loadtime:5.8344230651855 / seconds
Query Executed:select id FROM `va` where city='Providence Forge' && SIC_code='7231'DB:business_master_new
loadtime:5.8368680477142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:5.8369400501251 / seconds
Query Executed:select id FROM `va` where city='Pulaski' && SIC_code='7231'DB:business_master_new
loadtime:5.8436601161957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pungoteague' limit 1
loadtime:5.8437361717224 / seconds
Query Executed:select id FROM `va` where city='Pungoteague' && SIC_code='7231'DB:business_master_new
loadtime:5.8443660736084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purcellville' limit 1
loadtime:5.844437122345 / seconds
Query Executed:select id FROM `va` where city='Purcellville' && SIC_code='7231'DB:business_master_new
loadtime:5.8533840179443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quantico' limit 1
loadtime:5.8534691333771 / seconds
Query Executed:select id FROM `va` where city='Quantico' && SIC_code='7231'DB:business_master_new
loadtime:5.8562481403351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quicksburg' limit 1
loadtime:5.8563230037689 / seconds
Query Executed:select id FROM `va` where city='Quicksburg' && SIC_code='7231'DB:business_master_new
loadtime:5.8572289943695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:5.8572971820831 / seconds
Query Executed:select id FROM `va` where city='Quinby' && SIC_code='7231'DB:business_master_new
loadtime:5.8577921390533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinque' limit 1
loadtime:5.8578450679779 / seconds
Query Executed:select id FROM `va` where city='Quinque' && SIC_code='7231'DB:business_master_new
loadtime:5.8584361076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:5.8584890365601 / seconds
Query Executed:select id FROM `va` where city='Quinton' && SIC_code='7231'DB:business_master_new
loadtime:5.8614201545715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radford' limit 1
loadtime:5.8614990711212 / seconds
Query Executed:select id FROM `va` where city='Radford' && SIC_code='7231'DB:business_master_new
loadtime:5.871710062027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radiant' limit 1
loadtime:5.8718371391296 / seconds
Query Executed:select id FROM `va` where city='Radiant' && SIC_code='7231'DB:business_master_new
loadtime:5.8724110126495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:5.8724701404572 / seconds
Query Executed:select id FROM `va` where city='Randolph' && SIC_code='7231'DB:business_master_new
loadtime:5.8730220794678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raphine' limit 1
loadtime:5.8730762004852 / seconds
Query Executed:select id FROM `va` where city='Raphine' && SIC_code='7231'DB:business_master_new
loadtime:5.8743941783905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapidan' limit 1
loadtime:5.8744611740112 / seconds
Query Executed:select id FROM `va` where city='Rapidan' && SIC_code='7231'DB:business_master_new
loadtime:5.8754410743713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Academy' limit 1
loadtime:5.8754951953888 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Academy' && SIC_code='7231'DB:business_master_new
loadtime:5.8760411739349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Acd' limit 1
loadtime:5.8760941028595 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Acd' && SIC_code='7231'DB:business_master_new
loadtime:5.8765389919281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raven' limit 1
loadtime:5.8765912055969 / seconds
Query Executed:select id FROM `va` where city='Raven' && SIC_code='7231'DB:business_master_new
loadtime:5.8775260448456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlings' limit 1
loadtime:5.8775951862335 / seconds
Query Executed:select id FROM `va` where city='Rawlings' && SIC_code='7231'DB:business_master_new
loadtime:5.8781499862671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rectortown' limit 1
loadtime:5.8782041072845 / seconds
Query Executed:select id FROM `va` where city='Rectortown' && SIC_code='7231'DB:business_master_new
loadtime:5.8786771297455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Ash' limit 1
loadtime:5.8787271976471 / seconds
Query Executed:select id FROM `va` where city='Red Ash' && SIC_code='7231'DB:business_master_new
loadtime:5.8791601657867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:5.8792130947113 / seconds
Query Executed:select id FROM `va` where city='Red House' && SIC_code='7231'DB:business_master_new
loadtime:5.8797709941864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:5.8798341751099 / seconds
Query Executed:select id FROM `va` where city='Red Oak' && SIC_code='7231'DB:business_master_new
loadtime:5.8807001113892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redart' limit 1
loadtime:5.8807530403137 / seconds
Query Executed:select id FROM `va` where city='Redart' && SIC_code='7231'DB:business_master_new
loadtime:5.8812100887299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:5.8812630176544 / seconds
Query Executed:select id FROM `va` where city='Redwood' && SIC_code='7231'DB:business_master_new
loadtime:5.8817820549011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedville' limit 1
loadtime:5.8818330764771 / seconds
Query Executed:select id FROM `va` where city='Reedville' && SIC_code='7231'DB:business_master_new
loadtime:5.8838369846344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:5.8839130401611 / seconds
Query Executed:select id FROM `va` where city='Reliance' && SIC_code='7231'DB:business_master_new
loadtime:5.8843970298767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remington' limit 1
loadtime:5.8844501972198 / seconds
Query Executed:select id FROM `va` where city='Remington' && SIC_code='7231'DB:business_master_new
loadtime:5.8864250183105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republican Grove' limit 1
loadtime:5.8864941596985 / seconds
Query Executed:select id FROM `va` where city='Republican Grove' && SIC_code='7231'DB:business_master_new
loadtime:5.8869531154633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rescue' limit 1
loadtime:5.8870060443878 / seconds
Query Executed:select id FROM `va` where city='Rescue' && SIC_code='7231'DB:business_master_new
loadtime:5.887510061264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reston' limit 1
loadtime:5.8875629901886 / seconds
Query Executed:select id FROM `va` where city='Reston' && SIC_code='7231'DB:business_master_new
loadtime:5.9347732067108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:5.9349040985107 / seconds
Query Executed:select id FROM `va` where city='Reva' && SIC_code='7231'DB:business_master_new
loadtime:5.935868024826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhoadesville' limit 1
loadtime:5.9359290599823 / seconds
Query Executed:select id FROM `va` where city='Rhoadesville' && SIC_code='7231'DB:business_master_new
loadtime:5.9369029998779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:5.9369561672211 / seconds
Query Executed:select id FROM `va` where city='Rice' && SIC_code='7231'DB:business_master_new
loadtime:5.9378280639648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Creek' limit 1
loadtime:5.9378900527954 / seconds
Query Executed:select id FROM `va` where city='Rich Creek' && SIC_code='7231'DB:business_master_new
loadtime:5.9391021728516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richardsville' limit 1
loadtime:5.9391720294952 / seconds
Query Executed:select id FROM `va` where city='Richardsville' && SIC_code='7231'DB:business_master_new
loadtime:5.9397811889648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:5.9398341178894 / seconds
Query Executed:select id FROM `va` where city='Richlands' && SIC_code='7231'DB:business_master_new
loadtime:5.9453191757202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:5.9454112052917 / seconds
Query Executed:select id FROM `va` where city='Richmond' && SIC_code='7231'DB:business_master_new
loadtime:6.0320041179657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:6.032998085022 / seconds
Query Executed:select id FROM `va` where city='Ridgeway' && SIC_code='7231'DB:business_master_new
loadtime:6.0369222164154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rileyville' limit 1
loadtime:6.0370650291443 / seconds
Query Executed:select id FROM `va` where city='Rileyville' && SIC_code='7231'DB:business_master_new
loadtime:6.0378429889679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riner' limit 1
loadtime:6.0379071235657 / seconds
Query Executed:select id FROM `va` where city='Riner' && SIC_code='7231'DB:business_master_new
loadtime:6.0393509864807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringgold' limit 1
loadtime:6.039430141449 / seconds
Query Executed:select id FROM `va` where city='Ringgold' && SIC_code='7231'DB:business_master_new
loadtime:6.0415451526642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripplemead' limit 1
loadtime:6.0416262149811 / seconds
Query Executed:select id FROM `va` where city='Ripplemead' && SIC_code='7231'DB:business_master_new
loadtime:6.0424880981445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:6.0425550937653 / seconds
Query Executed:select id FROM `va` where city='Riverton' && SIC_code='7231'DB:business_master_new
loadtime:6.0430362224579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rixeyville' limit 1
loadtime:6.0431020259857 / seconds
Query Executed:select id FROM `va` where city='Rixeyville' && SIC_code='7231'DB:business_master_new
loadtime:6.0445652008057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:6.0446259975433 / seconds
Query Executed:select id FROM `va` where city='Roanoke' && SIC_code='7231'DB:business_master_new
loadtime:6.152626991272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle' limit 1
loadtime:6.1531641483307 / seconds
Query Executed:select id FROM `va` where city='Rochelle' && SIC_code='7231'DB:business_master_new
loadtime:6.1541450023651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockbridge Baths' limit 1
loadtime:6.1542332172394 / seconds
Query Executed:select id FROM `va` where city='Rockbridge Baths' && SIC_code='7231'DB:business_master_new
loadtime:6.1549429893494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:6.1550052165985 / seconds
Query Executed:select id FROM `va` where city='Rockville' && SIC_code='7231'DB:business_master_new
loadtime:6.1573791503906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Gap' limit 1
loadtime:6.157457113266 / seconds
Query Executed:select id FROM `va` where city='Rocky Gap' && SIC_code='7231'DB:business_master_new
loadtime:6.1584219932556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:6.1585211753845 / seconds
Query Executed:select id FROM `va` where city='Rocky Mount' && SIC_code='7231'DB:business_master_new
loadtime:6.2357761859894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollins Fork' limit 1
loadtime:6.2359941005707 / seconds
Query Executed:select id FROM `va` where city='Rollins Fork' && SIC_code='7231'DB:business_master_new
loadtime:6.236563205719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:6.2366302013397 / seconds
Query Executed:select id FROM `va` where city='Rose Hill' && SIC_code='7231'DB:business_master_new
loadtime:6.2378830909729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:6.2379710674286 / seconds
Query Executed:select id FROM `va` where city='Rosedale' && SIC_code='7231'DB:business_master_new
loadtime:6.2390282154083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:6.2391130924225 / seconds
Query Executed:select id FROM `va` where city='Roseland' && SIC_code='7231'DB:business_master_new
loadtime:6.240424156189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Hill' limit 1
loadtime:6.2404990196228 / seconds
Query Executed:select id FROM `va` where city='Round Hill' && SIC_code='7231'DB:business_master_new
loadtime:6.242849111557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:6.2429351806641 / seconds
Query Executed:select id FROM `va` where city='Rowe' && SIC_code='7231'DB:business_master_new
loadtime:6.2434182167053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:6.243479013443 / seconds
Query Executed:select id FROM `va` where city='Ruby' && SIC_code='7231'DB:business_master_new
loadtime:6.2439911365509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruckersville' limit 1
loadtime:6.2440521717072 / seconds
Query Executed:select id FROM `va` where city='Ruckersville' && SIC_code='7231'DB:business_master_new
loadtime:6.2485911846161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Retreat' limit 1
loadtime:6.2486801147461 / seconds
Query Executed:select id FROM `va` where city='Rural Retreat' && SIC_code='7231'DB:business_master_new
loadtime:6.2509570121765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rustburg' limit 1
loadtime:6.2510402202606 / seconds
Query Executed:select id FROM `va` where city='Rustburg' && SIC_code='7231'DB:business_master_new
loadtime:6.2557082176208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruther Glen' limit 1
loadtime:6.2557981014252 / seconds
Query Executed:select id FROM `va` where city='Ruther Glen' && SIC_code='7231'DB:business_master_new
loadtime:6.2593591213226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthville' limit 1
loadtime:6.2594420909882 / seconds
Query Executed:select id FROM `va` where city='Ruthville' && SIC_code='7231'DB:business_master_new
loadtime:6.2599911689758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:6.2600541114807 / seconds
Query Executed:select id FROM `va` where city='Saint Charles' && SIC_code='7231'DB:business_master_new
loadtime:6.2607409954071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:6.260801076889 / seconds
Query Executed:select id FROM `va` where city='Saint Paul' && SIC_code='7231'DB:business_master_new
loadtime:6.2626800537109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens Church' limit 1
loadtime:6.2627642154694 / seconds
Query Executed:select id FROM `va` where city='Saint Stephens Church' && SIC_code='7231'DB:business_master_new
loadtime:6.2636489868164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:6.2637250423431 / seconds
Query Executed:select id FROM `va` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:6.2925291061401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltville' limit 1
loadtime:6.2927181720734 / seconds
Query Executed:select id FROM `va` where city='Saltville' && SIC_code='7231'DB:business_master_new
loadtime:6.2952001094818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:6.295294046402 / seconds
Query Executed:select id FROM `va` where city='Saluda' && SIC_code='7231'DB:business_master_new
loadtime:6.2980120182037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandston' limit 1
loadtime:6.2981050014496 / seconds
Query Executed:select id FROM `va` where city='Sandston' && SIC_code='7231'DB:business_master_new
loadtime:6.3743619918823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:6.3745391368866 / seconds
Query Executed:select id FROM `va` where city='Sandy Hook' && SIC_code='7231'DB:business_master_new
loadtime:6.3752980232239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Level' limit 1
loadtime:6.375363111496 / seconds
Query Executed:select id FROM `va` where city='Sandy Level' && SIC_code='7231'DB:business_master_new
loadtime:6.3759682178497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Point' limit 1
loadtime:6.3760290145874 / seconds
Query Executed:select id FROM `va` where city='Sandy Point' && SIC_code='7231'DB:business_master_new
loadtime:6.3765201568604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:6.3765830993652 / seconds
Query Executed:select id FROM `va` where city='Sanford' && SIC_code='7231'DB:business_master_new
loadtime:6.3771340847015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxe' limit 1
loadtime:6.3771951198578 / seconds
Query Executed:select id FROM `va` where city='Saxe' && SIC_code='7231'DB:business_master_new
loadtime:6.3778471946716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxis' limit 1
loadtime:6.377907037735 / seconds
Query Executed:select id FROM `va` where city='Saxis' && SIC_code='7231'DB:business_master_new
loadtime:6.378525018692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schley' limit 1
loadtime:6.378585100174 / seconds
Query Executed:select id FROM `va` where city='Schley' && SIC_code='7231'DB:business_master_new
loadtime:6.3790900707245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schuyler' limit 1
loadtime:6.3791530132294 / seconds
Query Executed:select id FROM `va` where city='Schuyler' && SIC_code='7231'DB:business_master_new
loadtime:6.3799760341644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:6.3800361156464 / seconds
Query Executed:select id FROM `va` where city='Scottsburg' && SIC_code='7231'DB:business_master_new
loadtime:6.3813190460205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsville' limit 1
loadtime:6.3813941478729 / seconds
Query Executed:select id FROM `va` where city='Scottsville' && SIC_code='7231'DB:business_master_new
loadtime:6.3848180770874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaford' limit 1
loadtime:6.3849031925201 / seconds
Query Executed:select id FROM `va` where city='Seaford' && SIC_code='7231'DB:business_master_new
loadtime:6.3865540027618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealston' limit 1
loadtime:6.3866481781006 / seconds
Query Executed:select id FROM `va` where city='Sealston' && SIC_code='7231'DB:business_master_new
loadtime:6.3871002197266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:6.3871641159058 / seconds
Query Executed:select id FROM `va` where city='Seaview' && SIC_code='7231'DB:business_master_new
loadtime:6.3875892162323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedley' limit 1
loadtime:6.38765001297 / seconds
Query Executed:select id FROM `va` where city='Sedley' && SIC_code='7231'DB:business_master_new
loadtime:6.3885991573334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:6.3886590003967 / seconds
Query Executed:select id FROM `va` where city='Selma' && SIC_code='7231'DB:business_master_new
loadtime:6.3892312049866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Corners' limit 1
loadtime:6.3892920017242 / seconds
Query Executed:select id FROM `va` where city='Seven Corners' && SIC_code='7231'DB:business_master_new
loadtime:6.3897252082825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Mile Ford' limit 1
loadtime:6.3897850513458 / seconds
Query Executed:select id FROM `va` where city='Seven Mile Ford' && SIC_code='7231'DB:business_master_new
loadtime:6.3902401924133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:6.3903021812439 / seconds
Query Executed:select id FROM `va` where city='Severn' && SIC_code='7231'DB:business_master_new
loadtime:6.3907291889191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shacklefords' limit 1
loadtime:6.3907899856567 / seconds
Query Executed:select id FROM `va` where city='Shacklefords' && SIC_code='7231'DB:business_master_new
loadtime:6.3916912078857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharps' limit 1
loadtime:6.3917510509491 / seconds
Query Executed:select id FROM `va` where city='Sharps' && SIC_code='7231'DB:business_master_new
loadtime:6.3922891616821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawsville' limit 1
loadtime:6.3923501968384 / seconds
Query Executed:select id FROM `va` where city='Shawsville' && SIC_code='7231'DB:business_master_new
loadtime:6.3937411308289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:6.3938190937042 / seconds
Query Executed:select id FROM `va` where city='Shelby' && SIC_code='7231'DB:business_master_new
loadtime:6.3942840099335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:6.3943450450897 / seconds
Query Executed:select id FROM `va` where city='Shenandoah' && SIC_code='7231'DB:business_master_new
loadtime:6.3967781066895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Cvrns' limit 1
loadtime:6.3968660831451 / seconds
Query Executed:select id FROM `va` where city='Shenandoah Cvrns' && SIC_code='7231'DB:business_master_new
loadtime:6.3973500728607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherando' limit 1
loadtime:6.3974130153656 / seconds
Query Executed:select id FROM `va` where city='Sherando' && SIC_code='7231'DB:business_master_new
loadtime:6.3978850841522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:6.3979561328888 / seconds
Query Executed:select id FROM `va` where city='Shiloh' && SIC_code='7231'DB:business_master_new
loadtime:6.3984181880951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shipman' limit 1
loadtime:6.3984789848328 / seconds
Query Executed:select id FROM `va` where city='Shipman' && SIC_code='7231'DB:business_master_new
loadtime:6.399384021759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shortt Gap' limit 1
loadtime:6.399444103241 / seconds
Query Executed:select id FROM `va` where city='Shortt Gap' && SIC_code='7231'DB:business_master_new
loadtime:6.399854183197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Singers Glen' limit 1
loadtime:6.3999240398407 / seconds
Query Executed:select id FROM `va` where city='Singers Glen' && SIC_code='7231'DB:business_master_new
loadtime:6.4006011486053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skippers' limit 1
loadtime:6.4006640911102 / seconds
Query Executed:select id FROM `va` where city='Skippers' && SIC_code='7231'DB:business_master_new
loadtime:6.4014611244202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipwith' limit 1
loadtime:6.4015212059021 / seconds
Query Executed:select id FROM `va` where city='Skipwith' && SIC_code='7231'DB:business_master_new
loadtime:6.4023320674896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:6.4024062156677 / seconds
Query Executed:select id FROM `va` where city='Smithfield' && SIC_code='7231'DB:business_master_new
loadtime:6.4787499904633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snell' limit 1
loadtime:6.4789340496063 / seconds
Query Executed:select id FROM `va` where city='Snell' && SIC_code='7231'DB:business_master_new
loadtime:6.4794189929962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:6.479483127594 / seconds
Query Executed:select id FROM `va` where city='Somerset' && SIC_code='7231'DB:business_master_new
loadtime:6.4801020622253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:6.4801650047302 / seconds
Query Executed:select id FROM `va` where city='Somerville' && SIC_code='7231'DB:business_master_new
loadtime:6.4805769920349 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:6.4806380271912 / seconds
Query Executed:select id FROM `va` where city='South Boston' && SIC_code='7231'DB:business_master_new
loadtime:6.4980990886688 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hill' limit 1
loadtime:6.4982922077179 / seconds
Query Executed:select id FROM `va` where city='South Hill' && SIC_code='7231'DB:business_master_new
loadtime:6.574755191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Riding' limit 1
loadtime:6.574963092804 / seconds
Query Executed:select id FROM `va` where city='South Riding' && SIC_code='7231'DB:business_master_new
loadtime:6.5755531787872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:6.5756192207336 / seconds
Query Executed:select id FROM `va` where city='Sparta' && SIC_code='7231'DB:business_master_new
loadtime:6.5761201381683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speedwell' limit 1
loadtime:6.5761821269989 / seconds
Query Executed:select id FROM `va` where city='Speedwell' && SIC_code='7231'DB:business_master_new
loadtime:6.5768492221832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:6.5769190788269 / seconds
Query Executed:select id FROM `va` where city='Spencer' && SIC_code='7231'DB:business_master_new
loadtime:6.5781180858612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperryville' limit 1
loadtime:6.5781960487366 / seconds
Query Executed:select id FROM `va` where city='Sperryville' && SIC_code='7231'DB:business_master_new
loadtime:6.5796270370483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotsylvania' limit 1
loadtime:6.5796890258789 / seconds
Query Executed:select id FROM `va` where city='Spotsylvania' && SIC_code='7231'DB:business_master_new
loadtime:6.6560080051422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spout Spring' limit 1
loadtime:6.6561880111694 / seconds
Query Executed:select id FROM `va` where city='Spout Spring' && SIC_code='7231'DB:business_master_new
loadtime:6.6571941375732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Grove' limit 1
loadtime:6.6572711467743 / seconds
Query Executed:select id FROM `va` where city='Spring Grove' && SIC_code='7231'DB:business_master_new
loadtime:6.6580719947815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:6.6581401824951 / seconds
Query Executed:select id FROM `va` where city='Springfield' && SIC_code='7231'DB:business_master_new
loadtime:6.7147660255432 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:6.7150712013245 / seconds
Query Executed:select id FROM `va` where city='St Charles' && SIC_code='7231'DB:business_master_new
loadtime:6.7156081199646 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:6.7156810760498 / seconds
Query Executed:select id FROM `va` where city='St Paul' && SIC_code='7231'DB:business_master_new
loadtime:6.7161421775818 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens Chr' limit 1
loadtime:6.7162020206451 / seconds
Query Executed:select id FROM `va` where city='St Stephens Chr' && SIC_code='7231'DB:business_master_new
loadtime:6.7166349887848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:6.7167091369629 / seconds
Query Executed:select id FROM `va` where city='Stafford' && SIC_code='7231'DB:business_master_new
loadtime:6.7443020343781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordsville' limit 1
loadtime:6.7444500923157 / seconds
Query Executed:select id FROM `va` where city='Staffordsville' && SIC_code='7231'DB:business_master_new
loadtime:6.7449591159821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanardsville' limit 1
loadtime:6.7450270652771 / seconds
Query Executed:select id FROM `va` where city='Stanardsville' && SIC_code='7231'DB:business_master_new
loadtime:6.7481770515442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:6.7482690811157 / seconds
Query Executed:select id FROM `va` where city='Stanley' && SIC_code='7231'DB:business_master_new
loadtime:6.7509570121765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanleytown' limit 1
loadtime:6.7510430812836 / seconds
Query Executed:select id FROM `va` where city='Stanleytown' && SIC_code='7231'DB:business_master_new
loadtime:6.7519221305847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Tannery' limit 1
loadtime:6.7519850730896 / seconds
Query Executed:select id FROM `va` where city='Star Tannery' && SIC_code='7231'DB:business_master_new
loadtime:6.752613067627 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Farm' limit 1
loadtime:6.7526750564575 / seconds
Query Executed:select id FROM `va` where city='State Farm' && SIC_code='7231'DB:business_master_new
loadtime:6.753201007843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staunton' limit 1
loadtime:6.7532620429993 / seconds
Query Executed:select id FROM `va` where city='Staunton' && SIC_code='7231'DB:business_master_new
loadtime:6.780189037323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steeles Tavern' limit 1
loadtime:6.7803440093994 / seconds
Query Executed:select id FROM `va` where city='Steeles Tavern' && SIC_code='7231'DB:business_master_new
loadtime:6.7809231281281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephens City' limit 1
loadtime:6.7809920310974 / seconds
Query Executed:select id FROM `va` where city='Stephens City' && SIC_code='7231'DB:business_master_new
loadtime:6.8571121692657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:6.8572721481323 / seconds
Query Executed:select id FROM `va` where city='Stephenson' && SIC_code='7231'DB:business_master_new
loadtime:6.858510017395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:6.8585741519928 / seconds
Query Executed:select id FROM `va` where city='Sterling' && SIC_code='7231'DB:business_master_new
loadtime:6.912379026413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensburg' limit 1
loadtime:6.9126110076904 / seconds
Query Executed:select id FROM `va` where city='Stevensburg' && SIC_code='7231'DB:business_master_new
loadtime:6.9132452011108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:6.913318157196 / seconds
Query Executed:select id FROM `va` where city='Stevensville' && SIC_code='7231'DB:business_master_new
loadtime:6.9137899875641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Ridge' limit 1
loadtime:6.9138510227203 / seconds
Query Executed:select id FROM `va` where city='Stone Ridge' && SIC_code='7231'DB:business_master_new
loadtime:6.9143841266632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonega' limit 1
loadtime:6.9144451618195 / seconds
Query Executed:select id FROM `va` where city='Stonega' && SIC_code='7231'DB:business_master_new
loadtime:6.9148530960083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Creek' limit 1
loadtime:6.9149241447449 / seconds
Query Executed:select id FROM `va` where city='Stony Creek' && SIC_code='7231'DB:business_master_new
loadtime:6.9165441989899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:6.9166250228882 / seconds
Query Executed:select id FROM `va` where city='Strasburg' && SIC_code='7231'DB:business_master_new
loadtime:6.9214069843292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:6.9214930534363 / seconds
Query Executed:select id FROM `va` where city='Stratford' && SIC_code='7231'DB:business_master_new
loadtime:6.9219501018524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:6.9220130443573 / seconds
Query Executed:select id FROM `va` where city='Stuart' && SIC_code='7231'DB:business_master_new
loadtime:6.9272811412811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuarts Draft' limit 1
loadtime:6.9273672103882 / seconds
Query Executed:select id FROM `va` where city='Stuarts Draft' && SIC_code='7231'DB:business_master_new
loadtime:6.9316639900208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:6.9317491054535 / seconds
Query Executed:select id FROM `va` where city='Studley' && SIC_code='7231'DB:business_master_new
loadtime:6.9323501586914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffolk' limit 1
loadtime:6.9324131011963 / seconds
Query Executed:select id FROM `va` where city='Suffolk' && SIC_code='7231'DB:business_master_new
loadtime:6.9668750762939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:6.9671120643616 / seconds
Query Executed:select id FROM `va` where city='Sugar Grove' && SIC_code='7231'DB:business_master_new
loadtime:6.9679770469666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerduck' limit 1
loadtime:6.9680631160736 / seconds
Query Executed:select id FROM `va` where city='Sumerduck' && SIC_code='7231'DB:business_master_new
loadtime:6.9690279960632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:6.9690961837769 / seconds
Query Executed:select id FROM `va` where city='Supply' && SIC_code='7231'DB:business_master_new
loadtime:6.969526052475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:6.9695870876312 / seconds
Query Executed:select id FROM `va` where city='Surry' && SIC_code='7231'DB:business_master_new
loadtime:6.9716529846191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susan' limit 1
loadtime:6.9717330932617 / seconds
Query Executed:select id FROM `va` where city='Susan' && SIC_code='7231'DB:business_master_new
loadtime:6.9722430706024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:6.972305059433 / seconds
Query Executed:select id FROM `va` where city='Sussex' && SIC_code='7231'DB:business_master_new
loadtime:6.9729042053223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:6.9729740619659 / seconds
Query Executed:select id FROM `va` where city='Sutherland' && SIC_code='7231'DB:business_master_new
loadtime:6.9742050170898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:6.9742801189423 / seconds
Query Executed:select id FROM `va` where city='Sutherlin' && SIC_code='7231'DB:business_master_new
loadtime:6.9752461910248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Briar' limit 1
loadtime:6.9753069877625 / seconds
Query Executed:select id FROM `va` where city='Sweet Briar' && SIC_code='7231'DB:business_master_new
loadtime:6.9758410453796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swoope' limit 1
loadtime:6.9759011268616 / seconds
Query Executed:select id FROM `va` where city='Swoope' && SIC_code='7231'DB:business_master_new
loadtime:6.9768481254578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swords Creek' limit 1
loadtime:6.976909160614 / seconds
Query Executed:select id FROM `va` where city='Swords Creek' && SIC_code='7231'DB:business_master_new
loadtime:6.977756023407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syria' limit 1
loadtime:6.977833032608 / seconds
Query Executed:select id FROM `va` where city='Syria' && SIC_code='7231'DB:business_master_new
loadtime:6.9784049987793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syringa' limit 1
loadtime:6.9784669876099 / seconds
Query Executed:select id FROM `va` where city='Syringa' && SIC_code='7231'DB:business_master_new
loadtime:6.9789531230927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabb' limit 1
loadtime:6.9790151119232 / seconds
Query Executed:select id FROM `va` where city='Tabb' && SIC_code='7231'DB:business_master_new
loadtime:6.9796061515808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangier' limit 1
loadtime:6.9796671867371 / seconds
Query Executed:select id FROM `va` where city='Tangier' && SIC_code='7231'DB:business_master_new
loadtime:6.9804220199585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tannersville' limit 1
loadtime:6.9804830551147 / seconds
Query Executed:select id FROM `va` where city='Tannersville' && SIC_code='7231'DB:business_master_new
loadtime:6.9809641838074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tappahannock' limit 1
loadtime:6.9810252189636 / seconds
Query Executed:select id FROM `va` where city='Tappahannock' && SIC_code='7231'DB:business_master_new
loadtime:6.9876620769501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tasley' limit 1
loadtime:6.987781047821 / seconds
Query Executed:select id FROM `va` where city='Tasley' && SIC_code='7231'DB:business_master_new
loadtime:6.9886980056763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tazewell' limit 1
loadtime:6.9887781143188 / seconds
Query Executed:select id FROM `va` where city='Tazewell' && SIC_code='7231'DB:business_master_new
loadtime:6.9934041500092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperanceville' limit 1
loadtime:6.993485212326 / seconds
Query Executed:select id FROM `va` where city='Temperanceville' && SIC_code='7231'DB:business_master_new
loadtime:6.9943971633911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:6.994472026825 / seconds
Query Executed:select id FROM `va` where city='Thaxton' && SIC_code='7231'DB:business_master_new
loadtime:6.9955680370331 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Plains' limit 1
loadtime:6.9956421852112 / seconds
Query Executed:select id FROM `va` where city='The Plains' && SIC_code='7231'DB:business_master_new
loadtime:6.9976580142975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:6.9977200031281 / seconds
Query Executed:select id FROM `va` where city='Thornburg' && SIC_code='7231'DB:business_master_new
loadtime:6.9985990524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberville' limit 1
loadtime:6.9986600875854 / seconds
Query Executed:select id FROM `va` where city='Timberville' && SIC_code='7231'DB:business_master_new
loadtime:7.0009241104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toano' limit 1
loadtime:7.0010051727295 / seconds
Query Executed:select id FROM `va` where city='Toano' && SIC_code='7231'DB:business_master_new
loadtime:7.0039072036743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms Brook' limit 1
loadtime:7.0039970874786 / seconds
Query Executed:select id FROM `va` where city='Toms Brook' && SIC_code='7231'DB:business_master_new
loadtime:7.0052740573883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topping' limit 1
loadtime:7.0053369998932 / seconds
Query Executed:select id FROM `va` where city='Topping' && SIC_code='7231'DB:business_master_new
loadtime:7.0065271854401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:7.0066010951996 / seconds
Query Executed:select id FROM `va` where city='Townsend' && SIC_code='7231'DB:business_master_new
loadtime:7.0071702003479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trammel' limit 1
loadtime:7.0072381496429 / seconds
Query Executed:select id FROM `va` where city='Trammel' && SIC_code='7231'DB:business_master_new
loadtime:7.0077211856842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevilians' limit 1
loadtime:7.0077810287476 / seconds
Query Executed:select id FROM `va` where city='Trevilians' && SIC_code='7231'DB:business_master_new
loadtime:7.0083100795746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triangle' limit 1
loadtime:7.0083711147308 / seconds
Query Executed:select id FROM `va` where city='Triangle' && SIC_code='7231'DB:business_master_new
loadtime:7.0113010406494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triplet' limit 1
loadtime:7.0113790035248 / seconds
Query Executed:select id FROM `va` where city='Triplet' && SIC_code='7231'DB:business_master_new
loadtime:7.0118210315704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Dale' limit 1
loadtime:7.0118820667267 / seconds
Query Executed:select id FROM `va` where city='Trout Dale' && SIC_code='7231'DB:business_master_new
loadtime:7.0123391151428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:7.0124001502991 / seconds
Query Executed:select id FROM `va` where city='Troutdale' && SIC_code='7231'DB:business_master_new
loadtime:7.0132400989532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutville' limit 1
loadtime:7.0133020877838 / seconds
Query Executed:select id FROM `va` where city='Troutville' && SIC_code='7231'DB:business_master_new
loadtime:7.0171852111816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:7.0172669887543 / seconds
Query Executed:select id FROM `va` where city='Troy' && SIC_code='7231'DB:business_master_new
loadtime:7.0193130970001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:7.0193901062012 / seconds
Query Executed:select id FROM `va` where city='Turbeville' && SIC_code='7231'DB:business_master_new
loadtime:7.0198121070862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:7.0198740959167 / seconds
Query Executed:select id FROM `va` where city='Tyro' && SIC_code='7231'DB:business_master_new
loadtime:7.0203971862793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Hall' limit 1
loadtime:7.0204582214355 / seconds
Query Executed:select id FROM `va` where city='Union Hall' && SIC_code='7231'DB:business_master_new
loadtime:7.0215580463409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:7.0216331481934 / seconds
Query Executed:select id FROM `va` where city='Unionville' && SIC_code='7231'DB:business_master_new
loadtime:7.0228869915009 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Of Richmond' limit 1
loadtime:7.0229752063751 / seconds
Query Executed:select id FROM `va` where city='University Of Richmond' && SIC_code='7231'DB:business_master_new
loadtime:7.0234432220459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperville' limit 1
loadtime:7.0235111713409 / seconds
Query Executed:select id FROM `va` where city='Upperville' && SIC_code='7231'DB:business_master_new
loadtime:7.0248761177063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbanna' limit 1
loadtime:7.0249471664429 / seconds
Query Executed:select id FROM `va` where city='Urbanna' && SIC_code='7231'DB:business_master_new
loadtime:7.0271971225739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentines' limit 1
loadtime:7.0272800922394 / seconds
Query Executed:select id FROM `va` where city='Valentines' && SIC_code='7231'DB:business_master_new
loadtime:7.0279011726379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vansant' limit 1
loadtime:7.0279741287231 / seconds
Query Executed:select id FROM `va` where city='Vansant' && SIC_code='7231'DB:business_master_new
loadtime:7.0299501419067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Hill' limit 1
loadtime:7.0300321578979 / seconds
Query Executed:select id FROM `va` where city='Vernon Hill' && SIC_code='7231'DB:business_master_new
loadtime:7.0307250022888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:7.0307869911194 / seconds
Query Executed:select id FROM `va` where city='Verona' && SIC_code='7231'DB:business_master_new
loadtime:7.0344550609589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesta' limit 1
loadtime:7.0345370769501 / seconds
Query Executed:select id FROM `va` where city='Vesta' && SIC_code='7231'DB:business_master_new
loadtime:7.0350711345673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesuvius' limit 1
loadtime:7.0351521968842 / seconds
Query Executed:select id FROM `va` where city='Vesuvius' && SIC_code='7231'DB:business_master_new
loadtime:7.0358011722565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:7.035863161087 / seconds
Query Executed:select id FROM `va` where city='Victoria' && SIC_code='7231'DB:business_master_new
loadtime:7.038015127182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:7.0381021499634 / seconds
Query Executed:select id FROM `va` where city='Vienna' && SIC_code='7231'DB:business_master_new
loadtime:7.097470998764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viewtown' limit 1
loadtime:7.0977251529694 / seconds
Query Executed:select id FROM `va` where city='Viewtown' && SIC_code='7231'DB:business_master_new
loadtime:7.0982551574707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village' limit 1
loadtime:7.0983290672302 / seconds
Query Executed:select id FROM `va` where city='Village' && SIC_code='7231'DB:business_master_new
loadtime:7.0988681316376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villamont' limit 1
loadtime:7.0989401340485 / seconds
Query Executed:select id FROM `va` where city='Villamont' && SIC_code='7231'DB:business_master_new
loadtime:7.0993812084198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vint Hill Farms' limit 1
loadtime:7.0994420051575 / seconds
Query Executed:select id FROM `va` where city='Vint Hill Farms' && SIC_code='7231'DB:business_master_new
loadtime:7.0998311042786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:7.0998911857605 / seconds
Query Executed:select id FROM `va` where city='Vinton' && SIC_code='7231'DB:business_master_new
loadtime:7.1765689849854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgilina' limit 1
loadtime:7.1767702102661 / seconds
Query Executed:select id FROM `va` where city='Virgilina' && SIC_code='7231'DB:business_master_new
loadtime:7.1780910491943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virginia Beach' limit 1
loadtime:7.1781711578369 / seconds
Query Executed:select id FROM `va` where city='Virginia Beach' && SIC_code='7231'DB:business_master_new
loadtime:7.3841571807861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wachapreague' limit 1
loadtime:7.3852150440216 / seconds
Query Executed:select id FROM `va` where city='Wachapreague' && SIC_code='7231'DB:business_master_new
loadtime:7.3860890865326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake' limit 1
loadtime:7.3862121105194 / seconds
Query Executed:select id FROM `va` where city='Wake' && SIC_code='7231'DB:business_master_new
loadtime:7.3867270946503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:7.3867881298065 / seconds
Query Executed:select id FROM `va` where city='Wakefield' && SIC_code='7231'DB:business_master_new
loadtime:7.3884301185608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerton' limit 1
loadtime:7.3885090351105 / seconds
Query Executed:select id FROM `va` where city='Walkerton' && SIC_code='7231'DB:business_master_new
loadtime:7.3892140388489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallops Island' limit 1
loadtime:7.3892760276794 / seconds
Query Executed:select id FROM `va` where city='Wallops Island' && SIC_code='7231'DB:business_master_new
loadtime:7.3901300430298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walters' limit 1
loadtime:7.3902070522308 / seconds
Query Executed:select id FROM `va` where city='Walters' && SIC_code='7231'DB:business_master_new
loadtime:7.3906722068787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardtown' limit 1
loadtime:7.3907341957092 / seconds
Query Executed:select id FROM `va` where city='Wardtown' && SIC_code='7231'DB:business_master_new
loadtime:7.3912000656128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Neck' limit 1
loadtime:7.3912601470947 / seconds
Query Executed:select id FROM `va` where city='Ware Neck' && SIC_code='7231'DB:business_master_new
loadtime:7.391820192337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warfield' limit 1
loadtime:7.3918809890747 / seconds
Query Executed:select id FROM `va` where city='Warfield' && SIC_code='7231'DB:business_master_new
loadtime:7.3925750255585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:7.3926351070404 / seconds
Query Executed:select id FROM `va` where city='Warm Springs' && SIC_code='7231'DB:business_master_new
loadtime:7.3938071727753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:7.3938682079315 / seconds
Query Executed:select id FROM `va` where city='Warner' && SIC_code='7231'DB:business_master_new
loadtime:7.3943130970001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:7.3943741321564 / seconds
Query Executed:select id FROM `va` where city='Warrenton' && SIC_code='7231'DB:business_master_new
loadtime:7.4216141700745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:7.4217522144318 / seconds
Query Executed:select id FROM `va` where city='Warsaw' && SIC_code='7231'DB:business_master_new
loadtime:7.426765203476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:7.4268732070923 / seconds
Query Executed:select id FROM `va` where city='Washington' && SIC_code='7231'DB:business_master_new
loadtime:7.4292180538177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water View' limit 1
loadtime:7.429300069809 / seconds
Query Executed:select id FROM `va` where city='Water View' && SIC_code='7231'DB:business_master_new
loadtime:7.4297771453857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:7.4298400878906 / seconds
Query Executed:select id FROM `va` where city='Waterford' && SIC_code='7231'DB:business_master_new
loadtime:7.4311320781708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:7.4312071800232 / seconds
Query Executed:select id FROM `va` where city='Wattsville' && SIC_code='7231'DB:business_master_new
loadtime:7.4316802024841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:7.431755065918 / seconds
Query Executed:select id FROM `va` where city='Waverly' && SIC_code='7231'DB:business_master_new
loadtime:7.4340920448303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:7.4341762065887 / seconds
Query Executed:select id FROM `va` where city='Waynesboro' && SIC_code='7231'DB:business_master_new
loadtime:7.4545609951019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weber City' limit 1
loadtime:7.4546961784363 / seconds
Query Executed:select id FROM `va` where city='Weber City' && SIC_code='7231'DB:business_master_new
loadtime:7.4566450119019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weems' limit 1
loadtime:7.4567341804504 / seconds
Query Executed:select id FROM `va` where city='Weems' && SIC_code='7231'DB:business_master_new
loadtime:7.457780122757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirwood' limit 1
loadtime:7.4578671455383 / seconds
Query Executed:select id FROM `va` where city='Weirwood' && SIC_code='7231'DB:business_master_new
loadtime:7.4583411216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Augusta' limit 1
loadtime:7.4584031105042 / seconds
Query Executed:select id FROM `va` where city='West Augusta' && SIC_code='7231'DB:business_master_new
loadtime:7.4589040279388 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mclean' limit 1
loadtime:7.4589741230011 / seconds
Query Executed:select id FROM `va` where city='West Mclean' && SIC_code='7231'DB:business_master_new
loadtime:7.4597170352936 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:7.459792137146 / seconds
Query Executed:select id FROM `va` where city='West Point' && SIC_code='7231'DB:business_master_new
loadtime:7.4634671211243 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:7.4635531902313 / seconds
Query Executed:select id FROM `va` where city='West Springfield' && SIC_code='7231'DB:business_master_new
loadtime:7.4640221595764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:7.4640891551971 / seconds
Query Executed:select id FROM `va` where city='Westmoreland' && SIC_code='7231'DB:business_master_new
loadtime:7.4645490646362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyers Cave' limit 1
loadtime:7.4646100997925 / seconds
Query Executed:select id FROM `va` where city='Weyers Cave' && SIC_code='7231'DB:business_master_new
loadtime:7.4666230678558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitacre' limit 1
loadtime:7.4667000770569 / seconds
Query Executed:select id FROM `va` where city='Whitacre' && SIC_code='7231'DB:business_master_new
loadtime:7.4671640396118 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Hall' limit 1
loadtime:7.4672250747681 / seconds
Query Executed:select id FROM `va` where city='White Hall' && SIC_code='7231'DB:business_master_new
loadtime:7.4677340984344 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Marsh' limit 1
loadtime:7.4677951335907 / seconds
Query Executed:select id FROM `va` where city='White Marsh' && SIC_code='7231'DB:business_master_new
loadtime:7.4689180850983 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:7.4689950942993 / seconds
Query Executed:select id FROM `va` where city='White Plains' && SIC_code='7231'DB:business_master_new
loadtime:7.4695119857788 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Post' limit 1
loadtime:7.469574213028 / seconds
Query Executed:select id FROM `va` where city='White Post' && SIC_code='7231'DB:business_master_new
loadtime:7.4708361625671 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:7.4708981513977 / seconds
Query Executed:select id FROM `va` where city='White Stone' && SIC_code='7231'DB:business_master_new
loadtime:7.4734001159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitetop' limit 1
loadtime:7.4734880924225 / seconds
Query Executed:select id FROM `va` where city='Whitetop' && SIC_code='7231'DB:business_master_new
loadtime:7.474151134491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:7.4742140769958 / seconds
Query Executed:select id FROM `va` where city='Whitewood' && SIC_code='7231'DB:business_master_new
loadtime:7.474757194519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico' limit 1
loadtime:7.4748320579529 / seconds
Query Executed:select id FROM `va` where city='Wicomico' && SIC_code='7231'DB:business_master_new
loadtime:7.4754221439362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico Church' limit 1
loadtime:7.4755001068115 / seconds
Query Executed:select id FROM `va` where city='Wicomico Church' && SIC_code='7231'DB:business_master_new
loadtime:7.476172208786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:7.4762501716614 / seconds
Query Executed:select id FROM `va` where city='Williamsburg' && SIC_code='7231'DB:business_master_new
loadtime:7.522420167923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:7.5226640701294 / seconds
Query Executed:select id FROM `va` where city='Williamsville' && SIC_code='7231'DB:business_master_new
loadtime:7.5233020782471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:7.5233750343323 / seconds
Query Executed:select id FROM `va` where city='Willis' && SIC_code='7231'DB:business_master_new
loadtime:7.5246760845184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis Wharf' limit 1
loadtime:7.5247371196747 / seconds
Query Executed:select id FROM `va` where city='Willis Wharf' && SIC_code='7231'DB:business_master_new
loadtime:7.5252590179443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons' limit 1
loadtime:7.5253210067749 / seconds
Query Executed:select id FROM `va` where city='Wilsons' && SIC_code='7231'DB:business_master_new
loadtime:7.525829076767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:7.5258901119232 / seconds
Query Executed:select id FROM `va` where city='Winchester' && SIC_code='7231'DB:business_master_new
loadtime:7.5711801052094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:7.571417093277 / seconds
Query Executed:select id FROM `va` where city='Windsor' && SIC_code='7231'DB:business_master_new
loadtime:7.5744931697845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingina' limit 1
loadtime:7.5745952129364 / seconds
Query Executed:select id FROM `va` where city='Wingina' && SIC_code='7231'DB:business_master_new
loadtime:7.5751621723175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wintergreen' limit 1
loadtime:7.5752260684967 / seconds
Query Executed:select id FROM `va` where city='Wintergreen' && SIC_code='7231'DB:business_master_new
loadtime:7.5757172107697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wirtz' limit 1
loadtime:7.5757801532745 / seconds
Query Executed:select id FROM `va` where city='Wirtz' && SIC_code='7231'DB:business_master_new
loadtime:7.5780880451202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:7.5781891345978 / seconds
Query Executed:select id FROM `va` where city='Wise' && SIC_code='7231'DB:business_master_new
loadtime:7.5841820240021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withams' limit 1
loadtime:7.5842890739441 / seconds
Query Executed:select id FROM `va` where city='Withams' && SIC_code='7231'DB:business_master_new
loadtime:7.5847990512848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolford' limit 1
loadtime:7.5848650932312 / seconds
Query Executed:select id FROM `va` where city='Wolford' && SIC_code='7231'DB:business_master_new
loadtime:7.5853869915009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolftown' limit 1
loadtime:7.5854651927948 / seconds
Query Executed:select id FROM `va` where city='Wolftown' && SIC_code='7231'DB:business_master_new
loadtime:7.586118221283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodberry Forest' limit 1
loadtime:7.5861802101135 / seconds
Query Executed:select id FROM `va` where city='Woodberry Forest' && SIC_code='7231'DB:business_master_new
loadtime:7.5866210460663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:7.5866820812225 / seconds
Query Executed:select id FROM `va` where city='Woodbridge' && SIC_code='7231'DB:business_master_new
loadtime:7.650621175766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:7.6509871482849 / seconds
Query Executed:select id FROM `va` where city='Woodford' && SIC_code='7231'DB:business_master_new
loadtime:7.6528990268707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodlawn' limit 1
loadtime:7.6530179977417 / seconds
Query Executed:select id FROM `va` where city='Woodlawn' && SIC_code='7231'DB:business_master_new
loadtime:7.6552610397339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Rds' limit 1
loadtime:7.6553390026093 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Rds' && SIC_code='7231'DB:business_master_new
loadtime:7.6557760238647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Roads' limit 1
loadtime:7.6558401584625 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Roads' && SIC_code='7231'DB:business_master_new
loadtime:7.656347990036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:7.6564102172852 / seconds
Query Executed:select id FROM `va` where city='Woodstock' && SIC_code='7231'DB:business_master_new
loadtime:7.6633570194244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:7.6634550094604 / seconds
Query Executed:select id FROM `va` where city='Woodville' && SIC_code='7231'DB:business_master_new
loadtime:7.6642072200775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolwine' limit 1
loadtime:7.6642730236053 / seconds
Query Executed:select id FROM `va` where city='Woolwine' && SIC_code='7231'DB:business_master_new
loadtime:7.665137052536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wylliesburg' limit 1
loadtime:7.6652131080627 / seconds
Query Executed:select id FROM `va` where city='Wylliesburg' && SIC_code='7231'DB:business_master_new
loadtime:7.6659049987793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wytheville' limit 1
loadtime:7.6659750938416 / seconds
Query Executed:select id FROM `va` where city='Wytheville' && SIC_code='7231'DB:business_master_new
loadtime:7.7446050643921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:7.7448260784149 / seconds
Query Executed:select id FROM `va` where city='Yale' && SIC_code='7231'DB:business_master_new
loadtime:7.7456130981445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:7.7456951141357 / seconds
Query Executed:select id FROM `va` where city='Yorktown' && SIC_code='7231'DB:business_master_new
loadtime:7.771968126297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zacata' limit 1
loadtime:7.7721481323242 / seconds
Query Executed:select id FROM `va` where city='Zacata' && SIC_code='7231'DB:business_master_new
loadtime:7.7726850509644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zanoni' limit 1
loadtime:7.7727501392365 / seconds
Query Executed:select id FROM `va` where city='Zanoni' && SIC_code='7231'DB:business_master_new
loadtime:7.7733170986176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:7.7733721733093 / seconds
Query Executed:select id FROM `va` where city='Zuni' && SIC_code='7231'DB:business_master_new
loadtime:7.7744390964508 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:7.7745871543884 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:7.7751491069794 / seconds
Operation template executed (chunk cache operation)
loadtime:7.7753100395203 / seconds
template override:Default
loadtime:7.7753520011902 / 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:7.7766032218933 / seconds
Template Constructed, Array Rows:49
loadtime:7.7771680355072 / seconds
TOTAL EXECUTION TIME: 7.77669
loadtime:7.7811682224274 / 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] => beauty-shops [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:7.7811779975891
TOTAL KEY ARRAYS: 69