Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.1048736572266E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018129348754883 / seconds
host not found setting manual db connection
loadtime:0.0095429420471191 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.009788990020752 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099899768829346 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010050058364868 / seconds
zipcode:
loadtime:0.010077953338623 / seconds
Query Executed:select * from search_referrer where page_hash='517c9b571c2e4c07723a360382ce0eda' limit 10 DB:ezrox_toadli
loadtime:0.010322093963623 / seconds
Operation header executed (non global)
loadtime:0.010349988937378 / seconds
Operation leaderboard executed (non global)
loadtime:0.010400056838989 / seconds
Operation square executed (non global)
loadtime:0.010430097579956 / seconds
Operation square_bottom executed (non global)
loadtime:0.010457038879395 / seconds
Operation smallsquare executed (non global)
loadtime:0.0104820728302 / seconds
Operation headeradright executed (non global)
loadtime:0.010508060455322 / seconds
Operation google_analytics executed (non global)
loadtime:0.010531902313232 / seconds
Operation topstories executed (non global)
loadtime:0.010556936264038 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010583877563477 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010607957839966 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010886907577515 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011070966720581 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011112928390503 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011183977127075 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011236906051636 / seconds
Template key: archive_menu pushed
loadtime:0.011245965957642 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011260032653809 / seconds
Template key: get_gravatar pushed
loadtime:0.011266946792603 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011276006698608 / seconds
*10)-10)+1 | start:0
loadtime:0.011316061019897 / seconds
DB connected to localhost business_master_new
loadtime:0.011600971221924 / seconds
Query Executed:select * from categories where cat_URLid='child-day-care-services'DB:business_master_new
loadtime:0.012648105621338 / seconds
Query stored in cache : _QUERY_www.toadli.comec7df97df751cc0967c3a50b1488eb4d
loadtime:0.012716054916382 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.012772083282471 / seconds
Query Executed:select * from `va_catmap` where sic='8351' order by city ascDB:business_master_new
loadtime:0.038455009460449 / seconds
Query stored in cache : _QUERY_www.toadli.com7c83fe5906fcbe4970599cd89eaccfed
loadtime:0.042217016220093 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.042285919189453 / seconds
Query Executed:select sum(totalcount) as totalsum from `va_catmap` where sic='8351'DB:business_master_new
loadtime:0.047144889831543 / seconds
Query stored in cache : _QUERY_www.toadli.com775ddda5cf4b515ef0aee865107419d6
loadtime:0.047184944152832 / seconds
942 / 11
loadtime:0.047241926193237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abingdon' limit 1
loadtime:0.04731297492981 / seconds
Query Executed:select id FROM `va` where city='Abingdon' && SIC_code='8351'DB:business_master_new
loadtime:0.069761037826538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accomac' limit 1
loadtime:0.069869995117188 / seconds
Query Executed:select id FROM `va` where city='Accomac' && SIC_code='8351'DB:business_master_new
loadtime:0.072072982788086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Achilles' limit 1
loadtime:0.072135925292969 / seconds
Query Executed:select id FROM `va` where city='Achilles' && SIC_code='8351'DB:business_master_new
loadtime:0.072648048400879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.072700023651123 / seconds
Query Executed:select id FROM `va` where city='Afton' && SIC_code='8351'DB:business_master_new
loadtime:0.074640989303589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alberta' limit 1
loadtime:0.074709892272949 / seconds
Query Executed:select id FROM `va` where city='Alberta' && SIC_code='8351'DB:business_master_new
loadtime:0.075753927230835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aldie' limit 1
loadtime:0.075822114944458 / seconds
Query Executed:select id FROM `va` where city='Aldie' && SIC_code='8351'DB:business_master_new
loadtime:0.077984094619751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.078051090240479 / seconds
Query Executed:select id FROM `va` where city='Alexandria' && SIC_code='8351'DB:business_master_new
loadtime:0.11023306846619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleghany' limit 1
loadtime:0.11057209968567 / seconds
Query Executed:select id FROM `va` where city='Alleghany' && SIC_code='8351'DB:business_master_new
loadtime:0.11107897758484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allisonia' limit 1
loadtime:0.11116099357605 / seconds
Query Executed:select id FROM `va` where city='Allisonia' && SIC_code='8351'DB:business_master_new
loadtime:0.11157703399658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altavista' limit 1
loadtime:0.11163401603699 / seconds
Query Executed:select id FROM `va` where city='Altavista' && SIC_code='8351'DB:business_master_new
loadtime:0.11902809143066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.11909794807434 / seconds
Query Executed:select id FROM `va` where city='Alton' && SIC_code='8351'DB:business_master_new
loadtime:0.12014007568359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Ridge' limit 1
loadtime:0.12020802497864 / seconds
Query Executed:select id FROM `va` where city='Alum Ridge' && SIC_code='8351'DB:business_master_new
loadtime:0.12061190605164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court House' limit 1
loadtime:0.12067294120789 / seconds
Query Executed:select id FROM `va` where city='Amelia Court House' && SIC_code='8351'DB:business_master_new
loadtime:0.12895202636719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court Hse' limit 1
loadtime:0.12904000282288 / seconds
Query Executed:select id FROM `va` where city='Amelia Court Hse' && SIC_code='8351'DB:business_master_new
loadtime:0.12968587875366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.12975192070007 / seconds
Query Executed:select id FROM `va` where city='Amherst' && SIC_code='8351'DB:business_master_new
loadtime:0.13789701461792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amissville' limit 1
loadtime:0.13798809051514 / seconds
Query Executed:select id FROM `va` where city='Amissville' && SIC_code='8351'DB:business_master_new
loadtime:0.14027500152588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ammon' limit 1
loadtime:0.14034295082092 / seconds
Query Executed:select id FROM `va` where city='Ammon' && SIC_code='8351'DB:business_master_new
loadtime:0.14076995849609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amonate' limit 1
loadtime:0.14083194732666 / seconds
Query Executed:select id FROM `va` where city='Amonate' && SIC_code='8351'DB:business_master_new
loadtime:0.14130711555481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.14136004447937 / seconds
Query Executed:select id FROM `va` where city='Andover' && SIC_code='8351'DB:business_master_new
loadtime:0.14187788963318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.14193511009216 / seconds
Query Executed:select id FROM `va` where city='Annandale' && SIC_code='8351'DB:business_master_new
loadtime:0.17456102371216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appalachia' limit 1
loadtime:0.17469191551208 / seconds
Query Executed:select id FROM `va` where city='Appalachia' && SIC_code='8351'DB:business_master_new
loadtime:0.17622709274292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appomattox' limit 1
loadtime:0.17631006240845 / seconds
Query Executed:select id FROM `va` where city='Appomattox' && SIC_code='8351'DB:business_master_new
loadtime:0.18435001373291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.18442392349243 / seconds
Query Executed:select id FROM `va` where city='Ararat' && SIC_code='8351'DB:business_master_new
loadtime:0.18565011024475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.18572592735291 / seconds
Query Executed:select id FROM `va` where city='Arcola' && SIC_code='8351'DB:business_master_new
loadtime:0.1863899230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ark' limit 1
loadtime:0.18645000457764 / seconds
Query Executed:select id FROM `va` where city='Ark' && SIC_code='8351'DB:business_master_new
loadtime:0.18704199790955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.18709588050842 / seconds
Query Executed:select id FROM `va` where city='Arlington' && SIC_code='8351'DB:business_master_new
loadtime:0.21914005279541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aroda' limit 1
loadtime:0.21935296058655 / seconds
Query Executed:select id FROM `va` where city='Aroda' && SIC_code='8351'DB:business_master_new
loadtime:0.22003602981567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrington' limit 1
loadtime:0.22009897232056 / seconds
Query Executed:select id FROM `va` where city='Arrington' && SIC_code='8351'DB:business_master_new
loadtime:0.22129607200623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvonia' limit 1
loadtime:0.22136092185974 / seconds
Query Executed:select id FROM `va` where city='Arvonia' && SIC_code='8351'DB:business_master_new
loadtime:0.22205209732056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburn' limit 1
loadtime:0.22210597991943 / seconds
Query Executed:select id FROM `va` where city='Ashburn' && SIC_code='8351'DB:business_master_new
loadtime:0.24271893501282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.24284505844116 / seconds
Query Executed:select id FROM `va` where city='Ashland' && SIC_code='8351'DB:business_master_new
loadtime:0.26442694664001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assawoman' limit 1
loadtime:0.26452708244324 / seconds
Query Executed:select id FROM `va` where city='Assawoman' && SIC_code='8351'DB:business_master_new
loadtime:0.26495003700256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.26501989364624 / seconds
Query Executed:select id FROM `va` where city='Atkins' && SIC_code='8351'DB:business_master_new
loadtime:0.26619911193848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.26625394821167 / seconds
Query Executed:select id FROM `va` where city='Atlantic' && SIC_code='8351'DB:business_master_new
loadtime:0.26695704460144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta Springs' limit 1
loadtime:0.26702189445496 / seconds
Query Executed:select id FROM `va` where city='Augusta Springs' && SIC_code='8351'DB:business_master_new
loadtime:0.26744890213013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.26750707626343 / seconds
Query Executed:select id FROM `va` where city='Austinville' && SIC_code='8351'DB:business_master_new
loadtime:0.26849603652954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axton' limit 1
loadtime:0.26855707168579 / seconds
Query Executed:select id FROM `va` where city='Axton' && SIC_code='8351'DB:business_master_new
loadtime:0.27074503898621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aylett' limit 1
loadtime:0.27080607414246 / seconds
Query Executed:select id FROM `va` where city='Aylett' && SIC_code='8351'DB:business_master_new
loadtime:0.27301502227783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bacova' limit 1
loadtime:0.2730929851532 / seconds
Query Executed:select id FROM `va` where city='Bacova' && SIC_code='8351'DB:business_master_new
loadtime:0.27352404594421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Crossrds' limit 1
loadtime:0.27358198165894 / seconds
Query Executed:select id FROM `va` where city='Baileys Crossrds' && SIC_code='8351'DB:business_master_new
loadtime:0.2740740776062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banco' limit 1
loadtime:0.2741379737854 / seconds
Query Executed:select id FROM `va` where city='Banco' && SIC_code='8351'DB:business_master_new
loadtime:0.2745668888092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bandy' limit 1
loadtime:0.2746250629425 / seconds
Query Executed:select id FROM `va` where city='Bandy' && SIC_code='8351'DB:business_master_new
loadtime:0.27511596679688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barboursville' limit 1
loadtime:0.27518010139465 / seconds
Query Executed:select id FROM `va` where city='Barboursville' && SIC_code='8351'DB:business_master_new
loadtime:0.27683091163635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barhamsville' limit 1
loadtime:0.27688407897949 / seconds
Query Executed:select id FROM `va` where city='Barhamsville' && SIC_code='8351'DB:business_master_new
loadtime:0.27768898010254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barren Springs' limit 1
loadtime:0.27774691581726 / seconds
Query Executed:select id FROM `va` where city='Barren Springs' && SIC_code='8351'DB:business_master_new
loadtime:0.27825093269348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baskerville' limit 1
loadtime:0.27831411361694 / seconds
Query Executed:select id FROM `va` where city='Baskerville' && SIC_code='8351'DB:business_master_new
loadtime:0.27899289131165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.27904891967773 / seconds
Query Executed:select id FROM `va` where city='Bassett' && SIC_code='8351'DB:business_master_new
loadtime:0.28745102882385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bastian' limit 1
loadtime:0.28753399848938 / seconds
Query Executed:select id FROM `va` where city='Bastian' && SIC_code='8351'DB:business_master_new
loadtime:0.28837490081787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basye' limit 1
loadtime:0.28845500946045 / seconds
Query Executed:select id FROM `va` where city='Basye' && SIC_code='8351'DB:business_master_new
loadtime:0.2895040512085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.28956007957458 / seconds
Query Executed:select id FROM `va` where city='Batesville' && SIC_code='8351'DB:business_master_new
loadtime:0.29011487960815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battery Park' limit 1
loadtime:0.29017901420593 / seconds
Query Executed:select id FROM `va` where city='Battery Park' && SIC_code='8351'DB:business_master_new
loadtime:0.29063010215759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bavon' limit 1
loadtime:0.29068899154663 / seconds
Query Executed:select id FROM `va` where city='Bavon' && SIC_code='8351'DB:business_master_new
loadtime:0.29110908508301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bealeton' limit 1
loadtime:0.29116988182068 / seconds
Query Executed:select id FROM `va` where city='Bealeton' && SIC_code='8351'DB:business_master_new
loadtime:0.2944450378418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.29452991485596 / seconds
Query Executed:select id FROM `va` where city='Beaumont' && SIC_code='8351'DB:business_master_new
loadtime:0.29495692253113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverdam' limit 1
loadtime:0.29502010345459 / seconds
Query Executed:select id FROM `va` where city='Beaverdam' && SIC_code='8351'DB:business_master_new
loadtime:0.29668402671814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverlett' limit 1
loadtime:0.29676198959351 / seconds
Query Executed:select id FROM `va` where city='Beaverlett' && SIC_code='8351'DB:business_master_new
loadtime:0.2971510887146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.29720497131348 / seconds
Query Executed:select id FROM `va` where city='Bedford' && SIC_code='8351'DB:business_master_new
loadtime:0.3111310005188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bee' limit 1
loadtime:0.31120800971985 / seconds
Query Executed:select id FROM `va` where city='Bee' && SIC_code='8351'DB:business_master_new
loadtime:0.31170296669006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellamy' limit 1
loadtime:0.31177091598511 / seconds
Query Executed:select id FROM `va` where city='Bellamy' && SIC_code='8351'DB:business_master_new
loadtime:0.31218194961548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Haven' limit 1
loadtime:0.3122410774231 / seconds
Query Executed:select id FROM `va` where city='Belle Haven' && SIC_code='8351'DB:business_master_new
loadtime:0.31368088722229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belspring' limit 1
loadtime:0.31375694274902 / seconds
Query Executed:select id FROM `va` where city='Belspring' && SIC_code='8351'DB:business_master_new
loadtime:0.31422305107117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ben Hur' limit 1
loadtime:0.31428289413452 / seconds
Query Executed:select id FROM `va` where city='Ben Hur' && SIC_code='8351'DB:business_master_new
loadtime:0.31476092338562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bena' limit 1
loadtime:0.31482696533203 / seconds
Query Executed:select id FROM `va` where city='Bena' && SIC_code='8351'DB:business_master_new
loadtime:0.31542205810547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent Mountain' limit 1
loadtime:0.31547999382019 / seconds
Query Executed:select id FROM `va` where city='Bent Mountain' && SIC_code='8351'DB:business_master_new
loadtime:0.31640005111694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonville' limit 1
loadtime:0.3164529800415 / seconds
Query Executed:select id FROM `va` where city='Bentonville' && SIC_code='8351'DB:business_master_new
loadtime:0.31761789321899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergton' limit 1
loadtime:0.31767702102661 / seconds
Query Executed:select id FROM `va` where city='Bergton' && SIC_code='8351'DB:business_master_new
loadtime:0.31827998161316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berryville' limit 1
loadtime:0.31834506988525 / seconds
Query Executed:select id FROM `va` where city='Berryville' && SIC_code='8351'DB:business_master_new
loadtime:0.32678294181824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Island' limit 1
loadtime:0.32686710357666 / seconds
Query Executed:select id FROM `va` where city='Big Island' && SIC_code='8351'DB:business_master_new
loadtime:0.32788801193237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.32795405387878 / seconds
Query Executed:select id FROM `va` where city='Big Rock' && SIC_code='8351'DB:business_master_new
loadtime:0.32876801490784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone Gap' limit 1
loadtime:0.32883191108704 / seconds
Query Executed:select id FROM `va` where city='Big Stone Gap' && SIC_code='8351'DB:business_master_new
loadtime:0.33652710914612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchleaf' limit 1
loadtime:0.33660793304443 / seconds
Query Executed:select id FROM `va` where city='Birchleaf' && SIC_code='8351'DB:business_master_new
loadtime:0.33721899986267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birdsnest' limit 1
loadtime:0.33728504180908 / seconds
Query Executed:select id FROM `va` where city='Birdsnest' && SIC_code='8351'DB:business_master_new
loadtime:0.33786010742188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishop' limit 1
loadtime:0.33792400360107 / seconds
Query Executed:select id FROM `va` where city='Bishop' && SIC_code='8351'DB:business_master_new
loadtime:0.33843398094177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackridge' limit 1
loadtime:0.33849406242371 / seconds
Query Executed:select id FROM `va` where city='Blackridge' && SIC_code='8351'DB:business_master_new
loadtime:0.33898496627808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.3390429019928 / seconds
Query Executed:select id FROM `va` where city='Blacksburg' && SIC_code='8351'DB:business_master_new
loadtime:0.36076498031616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.36088705062866 / seconds
Query Executed:select id FROM `va` where city='Blackstone' && SIC_code='8351'DB:business_master_new
loadtime:0.36821508407593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwater' limit 1
loadtime:0.36829710006714 / seconds
Query Executed:select id FROM `va` where city='Blackwater' && SIC_code='8351'DB:business_master_new
loadtime:0.36887788772583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairs' limit 1
loadtime:0.36894011497498 / seconds
Query Executed:select id FROM `va` where city='Blairs' && SIC_code='8351'DB:business_master_new
loadtime:0.37060689926147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakes' limit 1
loadtime:0.37067890167236 / seconds
Query Executed:select id FROM `va` where city='Blakes' && SIC_code='8351'DB:business_master_new
loadtime:0.37110590934753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bland' limit 1
loadtime:0.37116408348083 / seconds
Query Executed:select id FROM `va` where city='Bland' && SIC_code='8351'DB:business_master_new
loadtime:0.37305307388306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloxom' limit 1
loadtime:0.37313008308411 / seconds
Query Executed:select id FROM `va` where city='Bloxom' && SIC_code='8351'DB:business_master_new
loadtime:0.37394595146179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.37402892112732 / seconds
Query Executed:select id FROM `va` where city='Blue Grass' && SIC_code='8351'DB:business_master_new
loadtime:0.37473201751709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Ridge' limit 1
loadtime:0.37479400634766 / seconds
Query Executed:select id FROM `va` where city='Blue Ridge' && SIC_code='8351'DB:business_master_new
loadtime:0.37674808502197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:0.37680292129517 / seconds
Query Executed:select id FROM `va` where city='Bluefield' && SIC_code='8351'DB:business_master_new
loadtime:0.38484907150269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluemont' limit 1
loadtime:0.38492202758789 / seconds
Query Executed:select id FROM `va` where city='Bluemont' && SIC_code='8351'DB:business_master_new
loadtime:0.38661098480225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bohannon' limit 1
loadtime:0.38667011260986 / seconds
Query Executed:select id FROM `va` where city='Bohannon' && SIC_code='8351'DB:business_master_new
loadtime:0.38711190223694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boissevain' limit 1
loadtime:0.38717293739319 / seconds
Query Executed:select id FROM `va` where city='Boissevain' && SIC_code='8351'DB:business_master_new
loadtime:0.38766503334045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolar' limit 1
loadtime:0.3877260684967 / seconds
Query Executed:select id FROM `va` where city='Bolar' && SIC_code='8351'DB:business_master_new
loadtime:0.38811111450195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:0.38817000389099 / seconds
Query Executed:select id FROM `va` where city='Bon Air' && SIC_code='8351'DB:business_master_new
loadtime:0.38893294334412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boones Mill' limit 1
loadtime:0.389004945755 / seconds
Query Executed:select id FROM `va` where city='Boones Mill' && SIC_code='8351'DB:business_master_new
loadtime:0.42082405090332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.42091798782349 / seconds
Query Executed:select id FROM `va` where city='Boston' && SIC_code='8351'DB:business_master_new
loadtime:0.42168092727661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.42173600196838 / seconds
Query Executed:select id FROM `va` where city='Bowling Green' && SIC_code='8351'DB:business_master_new
loadtime:0.42470788955688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyce' limit 1
loadtime:0.42477989196777 / seconds
Query Executed:select id FROM `va` where city='Boyce' && SIC_code='8351'DB:business_master_new
loadtime:0.42635989189148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boydton' limit 1
loadtime:0.42643904685974 / seconds
Query Executed:select id FROM `va` where city='Boydton' && SIC_code='8351'DB:business_master_new
loadtime:0.42832708358765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykins' limit 1
loadtime:0.42840695381165 / seconds
Query Executed:select id FROM `va` where city='Boykins' && SIC_code='8351'DB:business_master_new
loadtime:0.42952704429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bracey' limit 1
loadtime:0.42960095405579 / seconds
Query Executed:select id FROM `va` where city='Bracey' && SIC_code='8351'DB:business_master_new
loadtime:0.43138790130615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.43144202232361 / seconds
Query Executed:select id FROM `va` where city='Branchville' && SIC_code='8351'DB:business_master_new
loadtime:0.43204689025879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandy Station' limit 1
loadtime:0.43211197853088 / seconds
Query Executed:select id FROM `va` where city='Brandy Station' && SIC_code='8351'DB:business_master_new
loadtime:0.43318009376526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breaks' limit 1
loadtime:0.43323493003845 / seconds
Query Executed:select id FROM `va` where city='Breaks' && SIC_code='8351'DB:business_master_new
loadtime:0.43373703956604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremo Bluff' limit 1
loadtime:0.43379807472229 / seconds
Query Executed:select id FROM `va` where city='Bremo Bluff' && SIC_code='8351'DB:business_master_new
loadtime:0.43435192108154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.43440508842468 / seconds
Query Executed:select id FROM `va` where city='Bridgewater' && SIC_code='8351'DB:business_master_new
loadtime:0.44079399108887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:0.44087100028992 / seconds
Query Executed:select id FROM `va` where city='Brightwood' && SIC_code='8351'DB:business_master_new
loadtime:0.44155097007751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.44160509109497 / seconds
Query Executed:select id FROM `va` where city='Bristol' && SIC_code='8351'DB:business_master_new
loadtime:0.46130704879761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.46140789985657 / seconds
Query Executed:select id FROM `va` where city='Bristow' && SIC_code='8351'DB:business_master_new
loadtime:0.46750092506409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Run' limit 1
loadtime:0.46758604049683 / seconds
Query Executed:select id FROM `va` where city='Broad Run' && SIC_code='8351'DB:business_master_new
loadtime:0.46888303756714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadford' limit 1
loadtime:0.46894502639771 / seconds
Query Executed:select id FROM `va` where city='Broadford' && SIC_code='8351'DB:business_master_new
loadtime:0.46941304206848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.46946692466736 / seconds
Query Executed:select id FROM `va` where city='Broadway' && SIC_code='8351'DB:business_master_new
loadtime:0.47612690925598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodnax' limit 1
loadtime:0.47620797157288 / seconds
Query Executed:select id FROM `va` where city='Brodnax' && SIC_code='8351'DB:business_master_new
loadtime:0.47763109207153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooke' limit 1
loadtime:0.4776918888092 / seconds
Query Executed:select id FROM `va` where city='Brooke' && SIC_code='8351'DB:business_master_new
loadtime:0.47816610336304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookneal' limit 1
loadtime:0.47822690010071 / seconds
Query Executed:select id FROM `va` where city='Brookneal' && SIC_code='8351'DB:business_master_new
loadtime:0.48106408119202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsburg' limit 1
loadtime:0.4811429977417 / seconds
Query Executed:select id FROM `va` where city='Brownsburg' && SIC_code='8351'DB:business_master_new
loadtime:0.4816210269928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brucetown' limit 1
loadtime:0.48168110847473 / seconds
Query Executed:select id FROM `va` where city='Brucetown' && SIC_code='8351'DB:business_master_new
loadtime:0.48210597038269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruington' limit 1
loadtime:0.48216390609741 / seconds
Query Executed:select id FROM `va` where city='Bruington' && SIC_code='8351'DB:business_master_new
loadtime:0.48263788223267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:0.48269009590149 / seconds
Query Executed:select id FROM `va` where city='Buchanan' && SIC_code='8351'DB:business_master_new
loadtime:0.48533010482788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:0.48540091514587 / seconds
Query Executed:select id FROM `va` where city='Buckingham' && SIC_code='8351'DB:business_master_new
loadtime:0.48691010475159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.48696398735046 / seconds
Query Executed:select id FROM `va` where city='Buena Vista' && SIC_code='8351'DB:business_master_new
loadtime:0.49362397193909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Junction' limit 1
loadtime:0.49370193481445 / seconds
Query Executed:select id FROM `va` where city='Buffalo Junction' && SIC_code='8351'DB:business_master_new
loadtime:0.49478602409363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bumpass' limit 1
loadtime:0.49486303329468 / seconds
Query Executed:select id FROM `va` where city='Bumpass' && SIC_code='8351'DB:business_master_new
loadtime:0.49676895141602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgess' limit 1
loadtime:0.49685001373291 / seconds
Query Executed:select id FROM `va` where city='Burgess' && SIC_code='8351'DB:business_master_new
loadtime:0.49822092056274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.49829006195068 / seconds
Query Executed:select id FROM `va` where city='Burke' && SIC_code='8351'DB:business_master_new
loadtime:0.51685404777527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkes Garden' limit 1
loadtime:0.51695895195007 / seconds
Query Executed:select id FROM `va` where city='Burkes Garden' && SIC_code='8351'DB:business_master_new
loadtime:0.51744890213013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkeville' limit 1
loadtime:0.51751208305359 / seconds
Query Executed:select id FROM `va` where city='Burkeville' && SIC_code='8351'DB:business_master_new
loadtime:0.51900005340576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.51906991004944 / seconds
Query Executed:select id FROM `va` where city='Burnsville' && SIC_code='8351'DB:business_master_new
loadtime:0.51954793930054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Hill' limit 1
loadtime:0.51960706710815 / seconds
Query Executed:select id FROM `va` where city='Burr Hill' && SIC_code='8351'DB:business_master_new
loadtime:0.52013397216797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callands' limit 1
loadtime:0.52019500732422 / seconds
Query Executed:select id FROM `va` where city='Callands' && SIC_code='8351'DB:business_master_new
loadtime:0.52099204063416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callao' limit 1
loadtime:0.52106189727783 / seconds
Query Executed:select id FROM `va` where city='Callao' && SIC_code='8351'DB:business_master_new
loadtime:0.52339100837708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callaway' limit 1
loadtime:0.52346396446228 / seconds
Query Executed:select id FROM `va` where city='Callaway' && SIC_code='8351'DB:business_master_new
loadtime:0.52450299263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calverton' limit 1
loadtime:0.52455902099609 / seconds
Query Executed:select id FROM `va` where city='Calverton' && SIC_code='8351'DB:business_master_new
loadtime:0.52535605430603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cana' limit 1
loadtime:0.52541494369507 / seconds
Query Executed:select id FROM `va` where city='Cana' && SIC_code='8351'DB:business_master_new
loadtime:0.52710199356079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Charles' limit 1
loadtime:0.52717590332031 / seconds
Query Executed:select id FROM `va` where city='Cape Charles' && SIC_code='8351'DB:business_master_new
loadtime:0.53333210945129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capeville' limit 1
loadtime:0.53340697288513 / seconds
Query Executed:select id FROM `va` where city='Capeville' && SIC_code='8351'DB:business_master_new
loadtime:0.53388595581055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capron' limit 1
loadtime:0.53394103050232 / seconds
Query Executed:select id FROM `va` where city='Capron' && SIC_code='8351'DB:business_master_new
loadtime:0.53505992889404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardinal' limit 1
loadtime:0.53519797325134 / seconds
Query Executed:select id FROM `va` where city='Cardinal' && SIC_code='8351'DB:business_master_new
loadtime:0.53571701049805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caret' limit 1
loadtime:0.53577589988708 / seconds
Query Executed:select id FROM `va` where city='Caret' && SIC_code='8351'DB:business_master_new
loadtime:0.53627490997314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.53632998466492 / seconds
Query Executed:select id FROM `va` where city='Carrollton' && SIC_code='8351'DB:business_master_new
loadtime:0.53880906105042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrsville' limit 1
loadtime:0.53891205787659 / seconds
Query Executed:select id FROM `va` where city='Carrsville' && SIC_code='8351'DB:business_master_new
loadtime:0.53976607322693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.53981995582581 / seconds
Query Executed:select id FROM `va` where city='Carson' && SIC_code='8351'DB:business_master_new
loadtime:0.54065108299255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cartersville' limit 1
loadtime:0.54071187973022 / seconds
Query Executed:select id FROM `va` where city='Cartersville' && SIC_code='8351'DB:business_master_new
loadtime:0.54156708717346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casanova' limit 1
loadtime:0.54162192344666 / seconds
Query Executed:select id FROM `va` where city='Casanova' && SIC_code='8351'DB:business_master_new
loadtime:0.54216194152832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.54221606254578 / seconds
Query Executed:select id FROM `va` where city='Cascade' && SIC_code='8351'DB:business_master_new
loadtime:0.54306697845459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.54313707351685 / seconds
Query Executed:select id FROM `va` where city='Castleton' && SIC_code='8351'DB:business_master_new
loadtime:0.54383111000061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.54389691352844 / seconds
Query Executed:select id FROM `va` where city='Castlewood' && SIC_code='8351'DB:business_master_new
loadtime:0.54568099975586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.54574704170227 / seconds
Query Executed:select id FROM `va` where city='Catawba' && SIC_code='8351'DB:business_master_new
loadtime:0.54652690887451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharpin' limit 1
loadtime:0.54659509658813 / seconds
Query Executed:select id FROM `va` where city='Catharpin' && SIC_code='8351'DB:business_master_new
loadtime:0.5477659702301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catlett' limit 1
loadtime:0.54783606529236 / seconds
Query Executed:select id FROM `va` where city='Catlett' && SIC_code='8351'DB:business_master_new
loadtime:0.55005097389221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:0.55012106895447 / seconds
Query Executed:select id FROM `va` where city='Cedar Bluff' && SIC_code='8351'DB:business_master_new
loadtime:0.5559139251709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Cross' limit 1
loadtime:0.55599498748779 / seconds
Query Executed:select id FROM `va` where city='Center Cross' && SIC_code='8351'DB:business_master_new
loadtime:0.55668497085571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.5567409992218 / seconds
Query Executed:select id FROM `va` where city='Centreville' && SIC_code='8351'DB:business_master_new
loadtime:0.58045196533203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceres' limit 1
loadtime:0.58059310913086 / seconds
Query Executed:select id FROM `va` where city='Ceres' && SIC_code='8351'DB:business_master_new
loadtime:0.58117198944092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champlain' limit 1
loadtime:0.58123087882996 / seconds
Query Executed:select id FROM `va` where city='Champlain' && SIC_code='8351'DB:business_master_new
loadtime:0.58182597160339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chantilly' limit 1
loadtime:0.58189296722412 / seconds
Query Executed:select id FROM `va` where city='Chantilly' && SIC_code='8351'DB:business_master_new
loadtime:0.61409997940063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:0.61421799659729 / seconds
Query Executed:select id FROM `va` where city='Charles City' && SIC_code='8351'DB:business_master_new
loadtime:0.61998605728149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Court House' limit 1
loadtime:0.62007403373718 / seconds
Query Executed:select id FROM `va` where city='Charlotte Court House' && SIC_code='8351'DB:business_master_new
loadtime:0.62160611152649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Ct Hse' limit 1
loadtime:0.62167406082153 / seconds
Query Executed:select id FROM `va` where city='Charlotte Ct Hse' && SIC_code='8351'DB:business_master_new
loadtime:0.62240791320801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlottesville' limit 1
loadtime:0.62248802185059 / seconds
Query Executed:select id FROM `va` where city='Charlottesville' && SIC_code='8351'DB:business_master_new
loadtime:0.65470600128174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase City' limit 1
loadtime:0.654944896698 / seconds
Query Executed:select id FROM `va` where city='Chase City' && SIC_code='8351'DB:business_master_new
loadtime:0.68670701980591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.68683409690857 / seconds
Query Executed:select id FROM `va` where city='Chatham' && SIC_code='8351'DB:business_master_new
loadtime:0.69508504867554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Check' limit 1
loadtime:0.69517397880554 / seconds
Query Executed:select id FROM `va` where city='Check' && SIC_code='8351'DB:business_master_new
loadtime:0.69601202011108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheriton' limit 1
loadtime:0.69607591629028 / seconds
Query Executed:select id FROM `va` where city='Cheriton' && SIC_code='8351'DB:business_master_new
loadtime:0.69718408584595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesapeake' limit 1
loadtime:0.69725394248962 / seconds
Query Executed:select id FROM `va` where city='Chesapeake' && SIC_code='8351'DB:business_master_new
loadtime:0.79643893241882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.79677796363831 / seconds
Query Executed:select id FROM `va` where city='Chester' && SIC_code='8351'DB:business_master_new
loadtime:0.8171010017395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester Gap' limit 1
loadtime:0.81722092628479 / seconds
Query Executed:select id FROM `va` where city='Chester Gap' && SIC_code='8351'DB:business_master_new
loadtime:0.81774091720581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.81779789924622 / seconds
Query Executed:select id FROM `va` where city='Chesterfield' && SIC_code='8351'DB:business_master_new
loadtime:0.83502793312073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilhowie' limit 1
loadtime:0.83515310287476 / seconds
Query Executed:select id FROM `va` where city='Chilhowie' && SIC_code='8351'DB:business_master_new
loadtime:0.83825993537903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague' limit 1
loadtime:0.83834290504456 / seconds
Query Executed:select id FROM `va` where city='Chincoteague' && SIC_code='8351'DB:business_master_new
loadtime:0.8390679359436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague Island' limit 1
loadtime:0.83913087844849 / seconds
Query Executed:select id FROM `va` where city='Chincoteague Island' && SIC_code='8351'DB:business_master_new
loadtime:0.8431990146637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christchurch' limit 1
loadtime:0.8432788848877 / seconds
Query Executed:select id FROM `va` where city='Christchurch' && SIC_code='8351'DB:business_master_new
loadtime:0.84373497962952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christiansburg' limit 1
loadtime:0.84378910064697 / seconds
Query Executed:select id FROM `va` where city='Christiansburg' && SIC_code='8351'DB:business_master_new
loadtime:0.86368608474731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Road' limit 1
loadtime:0.86378502845764 / seconds
Query Executed:select id FROM `va` where city='Church Road' && SIC_code='8351'DB:business_master_new
loadtime:0.86471700668335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church View' limit 1
loadtime:0.86478805541992 / seconds
Query Executed:select id FROM `va` where city='Church View' && SIC_code='8351'DB:business_master_new
loadtime:0.86541509628296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churchville' limit 1
loadtime:0.86546897888184 / seconds
Query Executed:select id FROM `va` where city='Churchville' && SIC_code='8351'DB:business_master_new
loadtime:0.8671441078186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cismont' limit 1
loadtime:0.8672149181366 / seconds
Query Executed:select id FROM `va` where city='Cismont' && SIC_code='8351'DB:business_master_new
loadtime:0.8676769733429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.86773109436035 / seconds
Query Executed:select id FROM `va` where city='Claremont' && SIC_code='8351'DB:business_master_new
loadtime:0.86846709251404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.86852097511292 / seconds
Query Executed:select id FROM `va` where city='Clarksville' && SIC_code='8351'DB:business_master_new
loadtime:0.87258911132812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claudville' limit 1
loadtime:0.87266492843628 / seconds
Query Executed:select id FROM `va` where city='Claudville' && SIC_code='8351'DB:business_master_new
loadtime:0.87353205680847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Brook' limit 1
loadtime:0.87359404563904 / seconds
Query Executed:select id FROM `va` where city='Clear Brook' && SIC_code='8351'DB:business_master_new
loadtime:0.87509202957153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.87514495849609 / seconds
Query Executed:select id FROM `va` where city='Cleveland' && SIC_code='8351'DB:business_master_new
loadtime:0.87595796585083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:0.87601208686829 / seconds
Query Executed:select id FROM `va` where city='Clifford' && SIC_code='8351'DB:business_master_new
loadtime:0.87647104263306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.8765230178833 / seconds
Query Executed:select id FROM `va` where city='Clifton' && SIC_code='8351'DB:business_master_new
loadtime:0.88268804550171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton Forge' limit 1
loadtime:0.88276696205139 / seconds
Query Executed:select id FROM `va` where city='Clifton Forge' && SIC_code='8351'DB:business_master_new
loadtime:0.91490507125854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchco' limit 1
loadtime:0.91498589515686 / seconds
Query Executed:select id FROM `va` where city='Clinchco' && SIC_code='8351'DB:business_master_new
loadtime:0.91587805747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchport' limit 1
loadtime:0.91596293449402 / seconds
Query Executed:select id FROM `va` where city='Clinchport' && SIC_code='8351'DB:business_master_new
loadtime:0.91642594337463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintwood' limit 1
loadtime:0.91649103164673 / seconds
Query Executed:select id FROM `va` where city='Clintwood' && SIC_code='8351'DB:business_master_new
loadtime:0.92278695106506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:0.92286205291748 / seconds
Query Executed:select id FROM `va` where city='Clover' && SIC_code='8351'DB:business_master_new
loadtime:0.92375302314758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:0.92380690574646 / seconds
Query Executed:select id FROM `va` where city='Cloverdale' && SIC_code='8351'DB:business_master_new
loadtime:0.92508697509766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cluster Springs' limit 1
loadtime:0.92515301704407 / seconds
Query Executed:select id FROM `va` where city='Cluster Springs' && SIC_code='8351'DB:business_master_new
loadtime:0.92552804946899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobbs Creek' limit 1
loadtime:0.92558789253235 / seconds
Query Executed:select id FROM `va` where city='Cobbs Creek' && SIC_code='8351'DB:business_master_new
loadtime:0.92643308639526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobham' limit 1
loadtime:0.9264919757843 / seconds
Query Executed:select id FROM `va` where city='Cobham' && SIC_code='8351'DB:business_master_new
loadtime:0.92689609527588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coeburn' limit 1
loadtime:0.92696189880371 / seconds
Query Executed:select id FROM `va` where city='Coeburn' && SIC_code='8351'DB:business_master_new
loadtime:0.93350911140442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman Falls' limit 1
loadtime:0.93358993530273 / seconds
Query Executed:select id FROM `va` where city='Coleman Falls' && SIC_code='8351'DB:business_master_new
loadtime:0.93408799171448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coles Point' limit 1
loadtime:0.93414688110352 / seconds
Query Executed:select id FROM `va` where city='Coles Point' && SIC_code='8351'DB:business_master_new
loadtime:0.93462800979614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.93467998504639 / seconds
Query Executed:select id FROM `va` where city='Collinsville' && SIC_code='8351'DB:business_master_new
loadtime:0.94214010238647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:0.94221305847168 / seconds
Query Executed:select id FROM `va` where city='Cologne' && SIC_code='8351'DB:business_master_new
loadtime:0.94261288642883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Beach' limit 1
loadtime:0.94267511367798 / seconds
Query Executed:select id FROM `va` where city='Colonial Beach' && SIC_code='8351'DB:business_master_new
loadtime:0.94950103759766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Heights' limit 1
loadtime:0.94957590103149 / seconds
Query Executed:select id FROM `va` where city='Colonial Heights' && SIC_code='8351'DB:business_master_new
loadtime:0.96809697151184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.96819806098938 / seconds
Query Executed:select id FROM `va` where city='Columbia' && SIC_code='8351'DB:business_master_new
loadtime:0.96911406517029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conaway' limit 1
loadtime:0.96917605400085 / seconds
Query Executed:select id FROM `va` where city='Conaway' && SIC_code='8351'DB:business_master_new
loadtime:0.9695611000061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.96961402893066 / seconds
Query Executed:select id FROM `va` where city='Concord' && SIC_code='8351'DB:business_master_new
loadtime:0.97135496139526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Hill' limit 1
loadtime:0.97143387794495 / seconds
Query Executed:select id FROM `va` where city='Copper Hill' && SIC_code='8351'DB:business_master_new
loadtime:0.97238397598267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin' limit 1
loadtime:0.97246408462524 / seconds
Query Executed:select id FROM `va` where city='Corbin' && SIC_code='8351'DB:business_master_new
loadtime:0.97297310829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:0.97303295135498 / seconds
Query Executed:select id FROM `va` where city='Council' && SIC_code='8351'DB:business_master_new
loadtime:0.97346496582031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.97351908683777 / seconds
Query Executed:select id FROM `va` where city='Courtland' && SIC_code='8351'DB:business_master_new
loadtime:0.9761700630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covesville' limit 1
loadtime:0.97625088691711 / seconds
Query Executed:select id FROM `va` where city='Covesville' && SIC_code='8351'DB:business_master_new
loadtime:0.97691488265991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:0.97698307037354 / seconds
Query Executed:select id FROM `va` where city='Covington' && SIC_code='8351'DB:business_master_new
loadtime:0.98835897445679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craddockville' limit 1
loadtime:0.98844408988953 / seconds
Query Executed:select id FROM `va` where city='Craddockville' && SIC_code='8351'DB:business_master_new
loadtime:0.9889349937439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:0.98899698257446 / seconds
Query Executed:select id FROM `va` where city='Craigsville' && SIC_code='8351'DB:business_master_new
loadtime:0.98984289169312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crewe' limit 1
loadtime:0.98991894721985 / seconds
Query Executed:select id FROM `va` where city='Crewe' && SIC_code='8351'DB:business_master_new
loadtime:0.99306297302246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criders' limit 1
loadtime:0.99318289756775 / seconds
Query Executed:select id FROM `va` where city='Criders' && SIC_code='8351'DB:business_master_new
loadtime:0.99370908737183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criglersville' limit 1
loadtime:0.99377202987671 / seconds
Query Executed:select id FROM `va` where city='Criglersville' && SIC_code='8351'DB:business_master_new
loadtime:0.99417901039124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crimora' limit 1
loadtime:0.99424600601196 / seconds
Query Executed:select id FROM `va` where city='Crimora' && SIC_code='8351'DB:business_master_new
loadtime:0.99513792991638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:0.99519896507263 / seconds
Query Executed:select id FROM `va` where city='Cripple Creek' && SIC_code='8351'DB:business_master_new
loadtime:0.99563407897949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Critz' limit 1
loadtime:0.99568700790405 / seconds
Query Executed:select id FROM `va` where city='Critz' && SIC_code='8351'DB:business_master_new
loadtime:0.99627995491028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crockett' limit 1
loadtime:0.99633407592773 / seconds
Query Executed:select id FROM `va` where city='Crockett' && SIC_code='8351'DB:business_master_new
loadtime:0.99696803092957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Junction' limit 1
loadtime:0.9970281124115 / seconds
Query Executed:select id FROM `va` where city='Cross Junction' && SIC_code='8351'DB:business_master_new
loadtime:0.99840092658997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozet' limit 1
loadtime:0.99847602844238 / seconds
Query Executed:select id FROM `va` where city='Crozet' && SIC_code='8351'DB:business_master_new
loadtime:1.001935005188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozier' limit 1
loadtime:1.0020070075989 / seconds
Query Executed:select id FROM `va` where city='Crozier' && SIC_code='8351'DB:business_master_new
loadtime:1.0029850006104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Hill' limit 1
loadtime:1.0030579566956 / seconds
Query Executed:select id FROM `va` where city='Crystal Hill' && SIC_code='8351'DB:business_master_new
loadtime:1.0035419464111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullen' limit 1
loadtime:1.0035989284515 / seconds
Query Executed:select id FROM `va` where city='Cullen' && SIC_code='8351'DB:business_master_new
loadtime:1.0042359828949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culpeper' limit 1
loadtime:1.0042960643768 / seconds
Query Executed:select id FROM `va` where city='Culpeper' && SIC_code='8351'DB:business_master_new
loadtime:1.0235130786896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:1.0235979557037 / seconds
Query Executed:select id FROM `va` where city='Cumberland' && SIC_code='8351'DB:business_master_new
loadtime:1.0259070396423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dahlgren' limit 1
loadtime:1.025976896286 / seconds
Query Executed:select id FROM `va` where city='Dahlgren' && SIC_code='8351'DB:business_master_new
loadtime:1.0277030467987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale City' limit 1
loadtime:1.0277719497681 / seconds
Query Executed:select id FROM `va` where city='Dale City' && SIC_code='8351'DB:business_master_new
loadtime:1.0285210609436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:1.0285758972168 / seconds
Query Executed:select id FROM `va` where city='Daleville' && SIC_code='8351'DB:business_master_new
loadtime:1.0312809944153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:1.0313498973846 / seconds
Query Executed:select id FROM `va` where city='Damascus' && SIC_code='8351'DB:business_master_new
loadtime:1.0333869457245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:1.0334498882294 / seconds
Query Executed:select id FROM `va` where city='Dante' && SIC_code='8351'DB:business_master_new
loadtime:1.0341010093689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:1.0341548919678 / seconds
Query Executed:select id FROM `va` where city='Danville' && SIC_code='8351'DB:business_master_new
loadtime:1.0726020336151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington Hts' limit 1
loadtime:1.0727829933167 / seconds
Query Executed:select id FROM `va` where city='Darlington Hts' && SIC_code='8351'DB:business_master_new
loadtime:1.0732510089874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:1.0733110904694 / seconds
Query Executed:select id FROM `va` where city='Davenport' && SIC_code='8351'DB:business_master_new
loadtime:1.0738379955292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Wharf' limit 1
loadtime:1.0739130973816 / seconds
Query Executed:select id FROM `va` where city='Davis Wharf' && SIC_code='8351'DB:business_master_new
loadtime:1.0743100643158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:1.0743629932404 / seconds
Query Executed:select id FROM `va` where city='Dayton' && SIC_code='8351'DB:business_master_new
loadtime:1.077840089798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:1.0779159069061 / seconds
Query Executed:select id FROM `va` where city='Deerfield' && SIC_code='8351'DB:business_master_new
loadtime:1.0784330368042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaplane' limit 1
loadtime:1.0784919261932 / seconds
Query Executed:select id FROM `va` where city='Delaplane' && SIC_code='8351'DB:business_master_new
loadtime:1.0793581008911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deltaville' limit 1
loadtime:1.0794339179993 / seconds
Query Executed:select id FROM `va` where city='Deltaville' && SIC_code='8351'DB:business_master_new
loadtime:1.0816819667816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dendron' limit 1
loadtime:1.0817420482635 / seconds
Query Executed:select id FROM `va` where city='Dendron' && SIC_code='8351'DB:business_master_new
loadtime:1.0824670791626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:1.0825350284576 / seconds
Query Executed:select id FROM `va` where city='Dewitt' && SIC_code='8351'DB:business_master_new
loadtime:1.0834350585938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diggs' limit 1
loadtime:1.0834970474243 / seconds
Query Executed:select id FROM `va` where city='Diggs' && SIC_code='8351'DB:business_master_new
loadtime:1.0839219093323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillwyn' limit 1
loadtime:1.0839860439301 / seconds
Query Executed:select id FROM `va` where city='Dillwyn' && SIC_code='8351'DB:business_master_new
loadtime:1.0871250629425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinwiddie' limit 1
loadtime:1.0872020721436 / seconds
Query Executed:select id FROM `va` where city='Dinwiddie' && SIC_code='8351'DB:business_master_new
loadtime:1.0894498825073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Disputanta' limit 1
loadtime:1.0895290374756 / seconds
Query Executed:select id FROM `va` where city='Disputanta' && SIC_code='8351'DB:business_master_new
loadtime:1.0915110111237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doe Hill' limit 1
loadtime:1.0915760993958 / seconds
Query Executed:select id FROM `va` where city='Doe Hill' && SIC_code='8351'DB:business_master_new
loadtime:1.0920839309692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dogue' limit 1
loadtime:1.0921471118927 / seconds
Query Executed:select id FROM `va` where city='Dogue' && SIC_code='8351'DB:business_master_new
loadtime:1.0926089286804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolphin' limit 1
loadtime:1.0926649570465 / seconds
Query Executed:select id FROM `va` where city='Dolphin' && SIC_code='8351'DB:business_master_new
loadtime:1.0933001041412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doran' limit 1
loadtime:1.0933630466461 / seconds
Query Executed:select id FROM `va` where city='Doran' && SIC_code='8351'DB:business_master_new
loadtime:1.094043970108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doswell' limit 1
loadtime:1.0941090583801 / seconds
Query Executed:select id FROM `va` where city='Doswell' && SIC_code='8351'DB:business_master_new
loadtime:1.0956799983978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakes Branch' limit 1
loadtime:1.0957400798798 / seconds
Query Executed:select id FROM `va` where city='Drakes Branch' && SIC_code='8351'DB:business_master_new
loadtime:1.0970780849457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:1.0971460342407 / seconds
Query Executed:select id FROM `va` where city='Draper' && SIC_code='8351'DB:business_master_new
loadtime:1.0979769229889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewryville' limit 1
loadtime:1.0980460643768 / seconds
Query Executed:select id FROM `va` where city='Drewryville' && SIC_code='8351'DB:business_master_new
loadtime:1.098669052124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Fork' limit 1
loadtime:1.0987310409546 / seconds
Query Executed:select id FROM `va` where city='Dry Fork' && SIC_code='8351'DB:business_master_new
loadtime:1.1003799438477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:1.1004469394684 / seconds
Query Executed:select id FROM `va` where city='Dryden' && SIC_code='8351'DB:business_master_new
loadtime:1.1013779640198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:1.1014449596405 / seconds
Query Executed:select id FROM `va` where city='Dublin' && SIC_code='8351'DB:business_master_new
loadtime:1.1067628860474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duffield' limit 1
loadtime:1.1068410873413 / seconds
Query Executed:select id FROM `va` where city='Duffield' && SIC_code='8351'DB:business_master_new
loadtime:1.108855009079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugspur' limit 1
loadtime:1.1089370250702 / seconds
Query Executed:select id FROM `va` where city='Dugspur' && SIC_code='8351'DB:business_master_new
loadtime:1.1096260547638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulles' limit 1
loadtime:1.1097040176392 / seconds
Query Executed:select id FROM `va` where city='Dulles' && SIC_code='8351'DB:business_master_new
loadtime:1.1104669570923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumfries' limit 1
loadtime:1.110543012619 / seconds
Query Executed:select id FROM `va` where city='Dumfries' && SIC_code='8351'DB:business_master_new
loadtime:1.1229250431061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundas' limit 1
loadtime:1.1230249404907 / seconds
Query Executed:select id FROM `va` where city='Dundas' && SIC_code='8351'DB:business_master_new
loadtime:1.1236519813538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dungannon' limit 1
loadtime:1.1237089633942 / seconds
Query Executed:select id FROM `va` where city='Dungannon' && SIC_code='8351'DB:business_master_new
loadtime:1.1244959831238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn Loring' limit 1
loadtime:1.124559879303 / seconds
Query Executed:select id FROM `va` where city='Dunn Loring' && SIC_code='8351'DB:business_master_new
loadtime:1.1264810562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunnsville' limit 1
loadtime:1.1265559196472 / seconds
Query Executed:select id FROM `va` where city='Dunnsville' && SIC_code='8351'DB:business_master_new
loadtime:1.1273260116577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:1.1273798942566 / seconds
Query Executed:select id FROM `va` where city='Dutton' && SIC_code='8351'DB:business_master_new
loadtime:1.1279640197754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyke' limit 1
loadtime:1.1280291080475 / seconds
Query Executed:select id FROM `va` where city='Dyke' && SIC_code='8351'DB:business_master_new
loadtime:1.1286220550537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:1.1286809444427 / seconds
Query Executed:select id FROM `va` where city='Eagle Rock' && SIC_code='8351'DB:business_master_new
loadtime:1.129597902298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlysville' limit 1
loadtime:1.1296660900116 / seconds
Query Executed:select id FROM `va` where city='Earlysville' && SIC_code='8351'DB:business_master_new
loadtime:1.1321609020233 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Stone Gap' limit 1
loadtime:1.1322350502014 / seconds
Query Executed:select id FROM `va` where city='East Stone Gap' && SIC_code='8351'DB:business_master_new
loadtime:1.1326680183411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastville' limit 1
loadtime:1.1327209472656 / seconds
Query Executed:select id FROM `va` where city='Eastville' && SIC_code='8351'DB:business_master_new
loadtime:1.1339690685272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ebony' limit 1
loadtime:1.1340439319611 / seconds
Query Executed:select id FROM `va` where city='Ebony' && SIC_code='8351'DB:business_master_new
loadtime:1.1347320079803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:1.1347858905792 / seconds
Query Executed:select id FROM `va` where city='Edinburg' && SIC_code='8351'DB:business_master_new
loadtime:1.1387469768524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:1.1388010978699 / seconds
Query Executed:select id FROM `va` where city='Edwardsville' && SIC_code='8351'DB:business_master_new
loadtime:1.1392569541931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eggleston' limit 1
loadtime:1.139319896698 / seconds
Query Executed:select id FROM `va` where city='Eggleston' && SIC_code='8351'DB:business_master_new
loadtime:1.1398599147797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:1.1399259567261 / seconds
Query Executed:select id FROM `va` where city='Elberon' && SIC_code='8351'DB:business_master_new
loadtime:1.1405119895935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Creek' limit 1
loadtime:1.1405720710754 / seconds
Query Executed:select id FROM `va` where city='Elk Creek' && SIC_code='8351'DB:business_master_new
loadtime:1.1413309574127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:1.1413938999176 / seconds
Query Executed:select id FROM `va` where city='Elk Garden' && SIC_code='8351'DB:business_master_new
loadtime:1.1417820453644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:1.1418330669403 / seconds
Query Executed:select id FROM `va` where city='Elkton' && SIC_code='8351'DB:business_master_new
loadtime:1.1462049484253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkwood' limit 1
loadtime:1.1462790966034 / seconds
Query Executed:select id FROM `va` where city='Elkwood' && SIC_code='8351'DB:business_master_new
loadtime:1.1469960212708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliston' limit 1
loadtime:1.1470520496368 / seconds
Query Executed:select id FROM `va` where city='Elliston' && SIC_code='8351'DB:business_master_new
loadtime:1.148365020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emory' limit 1
loadtime:1.1484398841858 / seconds
Query Executed:select id FROM `va` where city='Emory' && SIC_code='8351'DB:business_master_new
loadtime:1.1489479541779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:1.1490108966827 / seconds
Query Executed:select id FROM `va` where city='Emporia' && SIC_code='8351'DB:business_master_new
loadtime:1.1598720550537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engleside' limit 1
loadtime:1.1599540710449 / seconds
Query Executed:select id FROM `va` where city='Engleside' && SIC_code='8351'DB:business_master_new
loadtime:1.1605820655823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esmont' limit 1
loadtime:1.1606431007385 / seconds
Query Executed:select id FROM `va` where city='Esmont' && SIC_code='8351'DB:business_master_new
loadtime:1.1613230705261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etlan' limit 1
loadtime:1.1613988876343 / seconds
Query Executed:select id FROM `va` where city='Etlan' && SIC_code='8351'DB:business_master_new
loadtime:1.161847114563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:1.1619100570679 / seconds
Query Executed:select id FROM `va` where city='Ettrick' && SIC_code='8351'DB:business_master_new
loadtime:1.1623001098633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:1.1623530387878 / seconds
Query Executed:select id FROM `va` where city='Evergreen' && SIC_code='8351'DB:business_master_new
loadtime:1.1628499031067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evington' limit 1
loadtime:1.1629209518433 / seconds
Query Executed:select id FROM `va` where city='Evington' && SIC_code='8351'DB:business_master_new
loadtime:1.1648149490356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewing' limit 1
loadtime:1.1648800373077 / seconds
Query Executed:select id FROM `va` where city='Ewing' && SIC_code='8351'DB:business_master_new
loadtime:1.1660668849945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exmore' limit 1
loadtime:1.1661438941956 / seconds
Query Executed:select id FROM `va` where city='Exmore' && SIC_code='8351'DB:business_master_new
loadtime:1.1689779758453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faber' limit 1
loadtime:1.1690559387207 / seconds
Query Executed:select id FROM `va` where city='Faber' && SIC_code='8351'DB:business_master_new
loadtime:1.1699550151825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:1.1700110435486 / seconds
Query Executed:select id FROM `va` where city='Fairfax' && SIC_code='8351'DB:business_master_new
loadtime:1.2021460533142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax Station' limit 1
loadtime:1.2023320198059 / seconds
Query Executed:select id FROM `va` where city='Fairfax Station' && SIC_code='8351'DB:business_master_new
loadtime:1.2135200500488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.213604927063 / seconds
Query Executed:select id FROM `va` where city='Fairfield' && SIC_code='8351'DB:business_master_new
loadtime:1.2149980068207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlawn' limit 1
loadtime:1.2150700092316 / seconds
Query Executed:select id FROM `va` where city='Fairlawn' && SIC_code='8351'DB:business_master_new
loadtime:1.21550989151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Church' limit 1
loadtime:1.2155640125275 / seconds
Query Executed:select id FROM `va` where city='Falls Church' && SIC_code='8351'DB:business_master_new
loadtime:1.2470109462738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Mills' limit 1
loadtime:1.2471950054169 / seconds
Query Executed:select id FROM `va` where city='Falls Mills' && SIC_code='8351'DB:business_master_new
loadtime:1.2479090690613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:1.247987985611 / seconds
Query Executed:select id FROM `va` where city='Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:1.2483599185944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fancy Gap' limit 1
loadtime:1.2484200000763 / seconds
Query Executed:select id FROM `va` where city='Fancy Gap' && SIC_code='8351'DB:business_master_new
loadtime:1.2497498989105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:1.2498180866241 / seconds
Query Executed:select id FROM `va` where city='Farmville' && SIC_code='8351'DB:business_master_new
loadtime:1.2631199359894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnham' limit 1
loadtime:1.2631950378418 / seconds
Query Executed:select id FROM `va` where city='Farnham' && SIC_code='8351'DB:business_master_new
loadtime:1.2642529010773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrum' limit 1
loadtime:1.2643249034882 / seconds
Query Executed:select id FROM `va` where city='Ferrum' && SIC_code='8351'DB:business_master_new
loadtime:1.266007900238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldale' limit 1
loadtime:1.2660889625549 / seconds
Query Executed:select id FROM `va` where city='Fieldale' && SIC_code='8351'DB:business_master_new
loadtime:1.2676808834076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:1.26775598526 / seconds
Query Executed:select id FROM `va` where city='Fife' && SIC_code='8351'DB:business_master_new
loadtime:1.26819896698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fincastle' limit 1
loadtime:1.2682640552521 / seconds
Query Executed:select id FROM `va` where city='Fincastle' && SIC_code='8351'DB:business_master_new
loadtime:1.2710111141205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishers Hill' limit 1
loadtime:1.271087884903 / seconds
Query Executed:select id FROM `va` where city='Fishers Hill' && SIC_code='8351'DB:business_master_new
loadtime:1.2715179920197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishersville' limit 1
loadtime:1.2715790271759 / seconds
Query Executed:select id FROM `va` where city='Fishersville' && SIC_code='8351'DB:business_master_new
loadtime:1.302985906601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint Hill' limit 1
loadtime:1.3030760288239 / seconds
Query Executed:select id FROM `va` where city='Flint Hill' && SIC_code='8351'DB:business_master_new
loadtime:1.3041160106659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:1.3041698932648 / seconds
Query Executed:select id FROM `va` where city='Floyd' && SIC_code='8351'DB:business_master_new
loadtime:1.3117361068726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foneswood' limit 1
loadtime:1.3117940425873 / seconds
Query Executed:select id FROM `va` where city='Foneswood' && SIC_code='8351'DB:business_master_new
loadtime:1.3121750354767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:1.3122339248657 / seconds
Query Executed:select id FROM `va` where city='Ford' && SIC_code='8351'DB:business_master_new
loadtime:1.3127949237823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:1.3128490447998 / seconds
Query Executed:select id FROM `va` where city='Forest' && SIC_code='8351'DB:business_master_new
loadtime:1.3251628875732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork Union' limit 1
loadtime:1.3252511024475 / seconds
Query Executed:select id FROM `va` where city='Fork Union' && SIC_code='8351'DB:business_master_new
loadtime:1.326544046402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Belvoir' limit 1
loadtime:1.3266079425812 / seconds
Query Executed:select id FROM `va` where city='Fort Belvoir' && SIC_code='8351'DB:business_master_new
loadtime:1.3292179107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Blackmore' limit 1
loadtime:1.3292980194092 / seconds
Query Executed:select id FROM `va` where city='Fort Blackmore' && SIC_code='8351'DB:business_master_new
loadtime:1.3299100399017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:1.3299651145935 / seconds
Query Executed:select id FROM `va` where city='Fort Defiance' && SIC_code='8351'DB:business_master_new
loadtime:1.3306949138641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Eustis' limit 1
loadtime:1.3307590484619 / seconds
Query Executed:select id FROM `va` where city='Fort Eustis' && SIC_code='8351'DB:business_master_new
loadtime:1.3321769237518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:1.3322510719299 / seconds
Query Executed:select id FROM `va` where city='Fort Lee' && SIC_code='8351'DB:business_master_new
loadtime:1.3334939479828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:1.3335609436035 / seconds
Query Executed:select id FROM `va` where city='Fort Mitchell' && SIC_code='8351'DB:business_master_new
loadtime:1.3340220451355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monroe' limit 1
loadtime:1.3340849876404 / seconds
Query Executed:select id FROM `va` where city='Fort Monroe' && SIC_code='8351'DB:business_master_new
loadtime:1.3349089622498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Myer' limit 1
loadtime:1.3349840641022 / seconds
Query Executed:select id FROM `va` where city='Fort Myer' && SIC_code='8351'DB:business_master_new
loadtime:1.3358409404755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Valley' limit 1
loadtime:1.3359260559082 / seconds
Query Executed:select id FROM `va` where city='Fort Valley' && SIC_code='8351'DB:business_master_new
loadtime:1.3369178771973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:1.336993932724 / seconds
Query Executed:select id FROM `va` where city='Foster' && SIC_code='8351'DB:business_master_new
loadtime:1.337513923645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:1.3375809192657 / seconds
Query Executed:select id FROM `va` where city='Franconia' && SIC_code='8351'DB:business_master_new
loadtime:1.3380789756775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.3381330966949 / seconds
Query Executed:select id FROM `va` where city='Franklin' && SIC_code='8351'DB:business_master_new
loadtime:1.3494310379028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:1.3495280742645 / seconds
Query Executed:select id FROM `va` where city='Franktown' && SIC_code='8351'DB:business_master_new
loadtime:1.3502130508423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:1.3502700328827 / seconds
Query Executed:select id FROM `va` where city='Fredericksburg' && SIC_code='8351'DB:business_master_new
loadtime:1.3822059631348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Union' limit 1
loadtime:1.3824050426483 / seconds
Query Executed:select id FROM `va` where city='Free Union' && SIC_code='8351'DB:business_master_new
loadtime:1.3834829330444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:1.3835670948029 / seconds
Query Executed:select id FROM `va` where city='Freeman' && SIC_code='8351'DB:business_master_new
loadtime:1.3843009471893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fries' limit 1
loadtime:1.3843700885773 / seconds
Query Executed:select id FROM `va` where city='Fries' && SIC_code='8351'DB:business_master_new
loadtime:1.3857100009918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Front Royal' limit 1
loadtime:1.3857710361481 / seconds
Query Executed:select id FROM `va` where city='Front Royal' && SIC_code='8351'DB:business_master_new
loadtime:1.4060719013214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ft Myer' limit 1
loadtime:1.4061770439148 / seconds
Query Executed:select id FROM `va` where city='Ft Myer' && SIC_code='8351'DB:business_master_new
loadtime:1.4065549373627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulks Run' limit 1
loadtime:1.4066200256348 / seconds
Query Executed:select id FROM `va` where city='Fulks Run' && SIC_code='8351'DB:business_master_new
loadtime:1.4076368808746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:1.4076919555664 / seconds
Query Executed:select id FROM `va` where city='Gainesville' && SIC_code='8351'DB:business_master_new
loadtime:1.4165499210358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galax' limit 1
loadtime:1.4166350364685 / seconds
Query Executed:select id FROM `va` where city='Galax' && SIC_code='8351'DB:business_master_new
loadtime:1.4286410808563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrisonville' limit 1
loadtime:1.4287281036377 / seconds
Query Executed:select id FROM `va` where city='Garrisonville' && SIC_code='8351'DB:business_master_new
loadtime:1.4295370578766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gasburg' limit 1
loadtime:1.4296069145203 / seconds
Query Executed:select id FROM `va` where city='Gasburg' && SIC_code='8351'DB:business_master_new
loadtime:1.4304990768433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gate City' limit 1
loadtime:1.4305698871613 / seconds
Query Executed:select id FROM `va` where city='Gate City' && SIC_code='8351'DB:business_master_new
loadtime:1.4624750614166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Hill' limit 1
loadtime:1.4625689983368 / seconds
Query Executed:select id FROM `va` where city='Glade Hill' && SIC_code='8351'DB:business_master_new
loadtime:1.4641261100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Spring' limit 1
loadtime:1.4641880989075 / seconds
Query Executed:select id FROM `va` where city='Glade Spring' && SIC_code='8351'DB:business_master_new
loadtime:1.4665789604187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladehill' limit 1
loadtime:1.4666459560394 / seconds
Query Executed:select id FROM `va` where city='Gladehill' && SIC_code='8351'DB:business_master_new
loadtime:1.4670839309692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.467139005661 / seconds
Query Executed:select id FROM `va` where city='Gladstone' && SIC_code='8351'DB:business_master_new
loadtime:1.4681100845337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladys' limit 1
loadtime:1.4681720733643 / seconds
Query Executed:select id FROM `va` where city='Gladys' && SIC_code='8351'DB:business_master_new
loadtime:1.4696309566498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:1.4697051048279 / seconds
Query Executed:select id FROM `va` where city='Glasgow' && SIC_code='8351'DB:business_master_new
loadtime:1.4709050655365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:1.470978975296 / seconds
Query Executed:select id FROM `va` where city='Glen Allen' && SIC_code='8351'DB:business_master_new
loadtime:1.5001380443573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Lyn' limit 1
loadtime:1.5002729892731 / seconds
Query Executed:select id FROM `va` where city='Glen Lyn' && SIC_code='8351'DB:business_master_new
loadtime:1.5009648799896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Wilton' limit 1
loadtime:1.501030921936 / seconds
Query Executed:select id FROM `va` where city='Glen Wilton' && SIC_code='8351'DB:business_master_new
loadtime:1.5014278888702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:1.501482963562 / seconds
Query Executed:select id FROM `va` where city='Gloucester' && SIC_code='8351'DB:business_master_new
loadtime:1.5142769813538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester Point' limit 1
loadtime:1.5143609046936 / seconds
Query Executed:select id FROM `va` where city='Gloucester Point' && SIC_code='8351'DB:business_master_new
loadtime:1.5161979198456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldbond' limit 1
loadtime:1.5162620544434 / seconds
Query Executed:select id FROM `va` where city='Goldbond' && SIC_code='8351'DB:business_master_new
loadtime:1.5166881084442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldvein' limit 1
loadtime:1.5167460441589 / seconds
Query Executed:select id FROM `va` where city='Goldvein' && SIC_code='8351'DB:business_master_new
loadtime:1.5175778865814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goochland' limit 1
loadtime:1.5176498889923 / seconds
Query Executed:select id FROM `va` where city='Goochland' && SIC_code='8351'DB:business_master_new
loadtime:1.5206880569458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goode' limit 1
loadtime:1.5207660198212 / seconds
Query Executed:select id FROM `va` where city='Goode' && SIC_code='8351'DB:business_master_new
loadtime:1.5222489833832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodview' limit 1
loadtime:1.5223250389099 / seconds
Query Executed:select id FROM `va` where city='Goodview' && SIC_code='8351'DB:business_master_new
loadtime:1.5237801074982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordonsville' limit 1
loadtime:1.5238480567932 / seconds
Query Executed:select id FROM `va` where city='Gordonsville' && SIC_code='8351'DB:business_master_new
loadtime:1.5557548999786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore' limit 1
loadtime:1.5558469295502 / seconds
Query Executed:select id FROM `va` where city='Gore' && SIC_code='8351'DB:business_master_new
loadtime:1.557018995285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:1.5570778846741 / seconds
Query Executed:select id FROM `va` where city='Goshen' && SIC_code='8351'DB:business_master_new
loadtime:1.5579059123993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:1.5579600334167 / seconds
Query Executed:select id FROM `va` where city='Grafton' && SIC_code='8351'DB:business_master_new
loadtime:1.5585079193115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graves Mill' limit 1
loadtime:1.5585680007935 / seconds
Query Executed:select id FROM `va` where city='Graves Mill' && SIC_code='8351'DB:business_master_new
loadtime:1.5589740276337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:1.5590269565582 / seconds
Query Executed:select id FROM `va` where city='Great Falls' && SIC_code='8351'DB:business_master_new
loadtime:1.5732989311218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:1.5733830928802 / seconds
Query Executed:select id FROM `va` where city='Green Bay' && SIC_code='8351'DB:business_master_new
loadtime:1.5740990638733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbackville' limit 1
loadtime:1.5741600990295 / seconds
Query Executed:select id FROM `va` where city='Greenbackville' && SIC_code='8351'DB:business_master_new
loadtime:1.5747981071472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.5748510360718 / seconds
Query Executed:select id FROM `va` where city='Greenbush' && SIC_code='8351'DB:business_master_new
loadtime:1.5754699707031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.5755228996277 / seconds
Query Executed:select id FROM `va` where city='Greenville' && SIC_code='8351'DB:business_master_new
loadtime:1.5765879154205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenway' limit 1
loadtime:1.5766530036926 / seconds
Query Executed:select id FROM `va` where city='Greenway' && SIC_code='8351'DB:business_master_new
loadtime:1.577094078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.5771479606628 / seconds
Query Executed:select id FROM `va` where city='Greenwood' && SIC_code='8351'DB:business_master_new
loadtime:1.57781291008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gretna' limit 1
loadtime:1.5778739452362 / seconds
Query Executed:select id FROM `va` where city='Gretna' && SIC_code='8351'DB:business_master_new
loadtime:1.5842740535736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimstead' limit 1
loadtime:1.5843579769135 / seconds
Query Executed:select id FROM `va` where city='Grimstead' && SIC_code='8351'DB:business_master_new
loadtime:1.5848529338837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grottoes' limit 1
loadtime:1.5849239826202 / seconds
Query Executed:select id FROM `va` where city='Grottoes' && SIC_code='8351'DB:business_master_new
loadtime:1.5869569778442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy' limit 1
loadtime:1.5870270729065 / seconds
Query Executed:select id FROM `va` where city='Grundy' && SIC_code='8351'DB:business_master_new
loadtime:1.5948059558868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gum Spring' limit 1
loadtime:1.5948801040649 / seconds
Query Executed:select id FROM `va` where city='Gum Spring' && SIC_code='8351'DB:business_master_new
loadtime:1.5958259105682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwynn' limit 1
loadtime:1.595899105072 / seconds
Query Executed:select id FROM `va` where city='Gwynn' && SIC_code='8351'DB:business_master_new
loadtime:1.5964488983154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacksneck' limit 1
loadtime:1.5965120792389 / seconds
Query Executed:select id FROM `va` where city='Hacksneck' && SIC_code='8351'DB:business_master_new
loadtime:1.5969910621643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadensville' limit 1
loadtime:1.5970520973206 / seconds
Query Executed:select id FROM `va` where city='Hadensville' && SIC_code='8351'DB:business_master_new
loadtime:1.5975470542908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hague' limit 1
loadtime:1.5975999832153 / seconds
Query Executed:select id FROM `va` where city='Hague' && SIC_code='8351'DB:business_master_new
loadtime:1.5987420082092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:1.5987958908081 / seconds
Query Executed:select id FROM `va` where city='Halifax' && SIC_code='8351'DB:business_master_new
loadtime:1.605516910553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallieford' limit 1
loadtime:1.6055901050568 / seconds
Query Executed:select id FROM `va` where city='Hallieford' && SIC_code='8351'DB:business_master_new
loadtime:1.6060800552368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallwood' limit 1
loadtime:1.6061420440674 / seconds
Query Executed:select id FROM `va` where city='Hallwood' && SIC_code='8351'DB:business_master_new
loadtime:1.6067609786987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.6068251132965 / seconds
Query Executed:select id FROM `va` where city='Hamilton' && SIC_code='8351'DB:business_master_new
loadtime:1.6086249351501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden Sydney' limit 1
loadtime:1.6086928844452 / seconds
Query Executed:select id FROM `va` where city='Hampden Sydney' && SIC_code='8351'DB:business_master_new
loadtime:1.6092839241028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:1.6093389987946 / seconds
Query Executed:select id FROM `va` where city='Hampton' && SIC_code='8351'DB:business_master_new
loadtime:1.6656119823456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.6658461093903 / seconds
Query Executed:select id FROM `va` where city='Hanover' && SIC_code='8351'DB:business_master_new
loadtime:1.6683850288391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harborton' limit 1
loadtime:1.6684749126434 / seconds
Query Executed:select id FROM `va` where city='Harborton' && SIC_code='8351'DB:business_master_new
loadtime:1.6689519882202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:1.6690120697021 / seconds
Query Executed:select id FROM `va` where city='Hardy' && SIC_code='8351'DB:business_master_new
loadtime:1.6717810630798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardyville' limit 1
loadtime:1.6718440055847 / seconds
Query Executed:select id FROM `va` where city='Hardyville' && SIC_code='8351'DB:business_master_new
loadtime:1.6724200248718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:1.6724810600281 / seconds
Query Executed:select id FROM `va` where city='Harman' && SIC_code='8351'DB:business_master_new
loadtime:1.6729409694672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonburg' limit 1
loadtime:1.6730051040649 / seconds
Query Executed:select id FROM `va` where city='Harrisonburg' && SIC_code='8351'DB:business_master_new
loadtime:1.7111840248108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartfield' limit 1
loadtime:1.7113699913025 / seconds
Query Executed:select id FROM `va` where city='Hartfield' && SIC_code='8351'DB:business_master_new
loadtime:1.7126710414886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwood' limit 1
loadtime:1.712730884552 / seconds
Query Executed:select id FROM `va` where city='Hartwood' && SIC_code='8351'DB:business_master_new
loadtime:1.7133688926697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:1.7134230136871 / seconds
Query Executed:select id FROM `va` where city='Hayes' && SIC_code='8351'DB:business_master_new
loadtime:1.7219700813293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haymarket' limit 1
loadtime:1.7220640182495 / seconds
Query Executed:select id FROM `va` where city='Haymarket' && SIC_code='8351'DB:business_master_new
loadtime:1.7310049533844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haynesville' limit 1
loadtime:1.731085062027 / seconds
Query Executed:select id FROM `va` where city='Haynesville' && SIC_code='8351'DB:business_master_new
loadtime:1.7316300868988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysi' limit 1
loadtime:1.731693983078 / seconds
Query Executed:select id FROM `va` where city='Haysi' && SIC_code='8351'DB:business_master_new
loadtime:1.7333149909973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:1.7333900928497 / seconds
Query Executed:select id FROM `va` where city='Haywood' && SIC_code='8351'DB:business_master_new
loadtime:1.7339129447937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Head Waters' limit 1
loadtime:1.7339770793915 / seconds
Query Executed:select id FROM `va` where city='Head Waters' && SIC_code='8351'DB:business_master_new
loadtime:1.7344040870667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heathsville' limit 1
loadtime:1.7344698905945 / seconds
Query Executed:select id FROM `va` where city='Heathsville' && SIC_code='8351'DB:business_master_new
loadtime:1.7373859882355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:1.7374560832977 / seconds
Query Executed:select id FROM `va` where city='Henry' && SIC_code='8351'DB:business_master_new
loadtime:1.7383949756622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:1.738461971283 / seconds
Query Executed:select id FROM `va` where city='Herndon' && SIC_code='8351'DB:business_master_new
loadtime:1.783539056778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Springs' limit 1
loadtime:1.7837009429932 / seconds
Query Executed:select id FROM `va` where city='Highland Springs' && SIC_code='8351'DB:business_master_new
loadtime:1.7842819690704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightown' limit 1
loadtime:1.7843511104584 / seconds
Query Executed:select id FROM `va` where city='Hightown' && SIC_code='8351'DB:business_master_new
loadtime:1.78475689888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsville' limit 1
loadtime:1.7848188877106 / seconds
Query Executed:select id FROM `va` where city='Hillsville' && SIC_code='8351'DB:business_master_new
loadtime:1.7936360836029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiltons' limit 1
loadtime:1.7937140464783 / seconds
Query Executed:select id FROM `va` where city='Hiltons' && SIC_code='8351'DB:business_master_new
loadtime:1.7944889068604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:1.7945520877838 / seconds
Query Executed:select id FROM `va` where city='Hinton' && SIC_code='8351'DB:business_master_new
loadtime:1.7952680587769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiwassee' limit 1
loadtime:1.79532289505 / seconds
Query Executed:select id FROM `va` where city='Hiwassee' && SIC_code='8351'DB:business_master_new
loadtime:1.796147108078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:1.7962079048157 / seconds
Query Executed:select id FROM `va` where city='Hollins' && SIC_code='8351'DB:business_master_new
loadtime:1.796639919281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaker' limit 1
loadtime:1.7967009544373 / seconds
Query Executed:select id FROM `va` where city='Honaker' && SIC_code='8351'DB:business_master_new
loadtime:1.7987689971924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood' limit 1
loadtime:1.7988269329071 / seconds
Query Executed:select id FROM `va` where city='Hood' && SIC_code='8351'DB:business_master_new
loadtime:1.7993249893188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:1.7993791103363 / seconds
Query Executed:select id FROM `va` where city='Hopewell' && SIC_code='8351'DB:business_master_new
loadtime:1.812844991684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horntown' limit 1
loadtime:1.812952041626 / seconds
Query Executed:select id FROM `va` where city='Horntown' && SIC_code='8351'DB:business_master_new
loadtime:1.8135390281677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horsepen' limit 1
loadtime:1.8136160373688 / seconds
Query Executed:select id FROM `va` where city='Horsepen' && SIC_code='8351'DB:business_master_new
loadtime:1.8139929771423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:1.8140490055084 / seconds
Query Executed:select id FROM `va` where city='Hot Springs' && SIC_code='8351'DB:business_master_new
loadtime:1.8457269668579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howardsville' limit 1
loadtime:1.8457899093628 / seconds
Query Executed:select id FROM `va` where city='Howardsville' && SIC_code='8351'DB:business_master_new
loadtime:1.8463621139526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howertons' limit 1
loadtime:1.8464210033417 / seconds
Query Executed:select id FROM `va` where city='Howertons' && SIC_code='8351'DB:business_master_new
loadtime:1.8468639850616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huddleston' limit 1
loadtime:1.8469378948212 / seconds
Query Executed:select id FROM `va` where city='Huddleston' && SIC_code='8351'DB:business_master_new
loadtime:1.8486928939819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudgins' limit 1
loadtime:1.8487749099731 / seconds
Query Executed:select id FROM `va` where city='Hudgins' && SIC_code='8351'DB:business_master_new
loadtime:1.8495049476624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hume' limit 1
loadtime:1.8495590686798 / seconds
Query Executed:select id FROM `va` where city='Hume' && SIC_code='8351'DB:business_master_new
loadtime:1.8503909111023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntly' limit 1
loadtime:1.8504450321198 / seconds
Query Executed:select id FROM `va` where city='Huntly' && SIC_code='8351'DB:business_master_new
loadtime:1.8510770797729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:1.8511309623718 / seconds
Query Executed:select id FROM `va` where city='Hurley' && SIC_code='8351'DB:business_master_new
loadtime:1.852098941803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurt' limit 1
loadtime:1.8521559238434 / seconds
Query Executed:select id FROM `va` where city='Hurt' && SIC_code='8351'DB:business_master_new
loadtime:1.8543970584869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustle' limit 1
loadtime:1.8544590473175 / seconds
Query Executed:select id FROM `va` where city='Hustle' && SIC_code='8351'DB:business_master_new
loadtime:1.854966878891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:1.8550200462341 / seconds
Query Executed:select id FROM `va` where city='Independence' && SIC_code='8351'DB:business_master_new
loadtime:1.8859639167786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Valley' limit 1
loadtime:1.8860468864441 / seconds
Query Executed:select id FROM `va` where city='Indian Valley' && SIC_code='8351'DB:business_master_new
loadtime:1.8866090774536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Gate' limit 1
loadtime:1.8866701126099 / seconds
Query Executed:select id FROM `va` where city='Iron Gate' && SIC_code='8351'DB:business_master_new
loadtime:1.887176990509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironto' limit 1
loadtime:1.8872420787811 / seconds
Query Executed:select id FROM `va` where city='Ironto' && SIC_code='8351'DB:business_master_new
loadtime:1.8876440525055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:1.8876950740814 / seconds
Query Executed:select id FROM `va` where city='Irvington' && SIC_code='8351'DB:business_master_new
loadtime:1.8892250061035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Wight' limit 1
loadtime:1.8892788887024 / seconds
Query Executed:select id FROM `va` where city='Isle Of Wight' && SIC_code='8351'DB:business_master_new
loadtime:1.8899610042572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:1.8900148868561 / seconds
Query Executed:select id FROM `va` where city='Ivanhoe' && SIC_code='8351'DB:business_master_new
loadtime:1.8906450271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivor' limit 1
loadtime:1.8907039165497 / seconds
Query Executed:select id FROM `va` where city='Ivor' && SIC_code='8351'DB:business_master_new
loadtime:1.8920359611511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivy' limit 1
loadtime:1.8921000957489 / seconds
Query Executed:select id FROM `va` where city='Ivy' && SIC_code='8351'DB:business_master_new
loadtime:1.8931000232697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:1.8931679725647 / seconds
Query Executed:select id FROM `va` where city='Jamaica' && SIC_code='8351'DB:business_master_new
loadtime:1.893639087677 / seconds
Query loaded from cache:select * from geodata_geocity where city='James Store' limit 1
loadtime:1.8936960697174 / seconds
Query Executed:select id FROM `va` where city='James Store' && SIC_code='8351'DB:business_master_new
loadtime:1.8941080570221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.8941609859467 / seconds
Query Executed:select id FROM `va` where city='Jamestown' && SIC_code='8351'DB:business_master_new
loadtime:1.8945639133453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:1.8946149349213 / seconds
Query Executed:select id FROM `va` where city='Jamesville' && SIC_code='8351'DB:business_master_new
loadtime:1.8950788974762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarratt' limit 1
loadtime:1.8951408863068 / seconds
Query Executed:select id FROM `va` where city='Jarratt' && SIC_code='8351'DB:business_master_new
loadtime:1.8965239524841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:1.8965818881989 / seconds
Query Executed:select id FROM `va` where city='Java' && SIC_code='8351'DB:business_master_new
loadtime:1.8973019123077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonton' limit 1
loadtime:1.8973550796509 / seconds
Query Executed:select id FROM `va` where city='Jeffersonton' && SIC_code='8351'DB:business_master_new
loadtime:1.8983728885651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkins Bridge' limit 1
loadtime:1.8984348773956 / seconds
Query Executed:select id FROM `va` where city='Jenkins Bridge' && SIC_code='8351'DB:business_master_new
loadtime:1.8988111019135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey' limit 1
loadtime:1.8988680839539 / seconds
Query Executed:select id FROM `va` where city='Jersey' && SIC_code='8351'DB:business_master_new
loadtime:1.8993010520935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetersville' limit 1
loadtime:1.8993599414825 / seconds
Query Executed:select id FROM `va` where city='Jetersville' && SIC_code='8351'DB:business_master_new
loadtime:1.9005019664764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell Ridge' limit 1
loadtime:1.9005570411682 / seconds
Query Executed:select id FROM `va` where city='Jewell Ridge' && SIC_code='8351'DB:business_master_new
loadtime:1.9010651111603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:1.9011189937592 / seconds
Query Executed:select id FROM `va` where city='Jonesville' && SIC_code='8351'DB:business_master_new
loadtime:1.9037621021271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keeling' limit 1
loadtime:1.9038460254669 / seconds
Query Executed:select id FROM `va` where city='Keeling' && SIC_code='8351'DB:business_master_new
loadtime:1.9045979976654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keen Mountain' limit 1
loadtime:1.9046618938446 / seconds
Query Executed:select id FROM `va` where city='Keen Mountain' && SIC_code='8351'DB:business_master_new
loadtime:1.9053339958191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:1.9053869247437 / seconds
Query Executed:select id FROM `va` where city='Keene' && SIC_code='8351'DB:business_master_new
loadtime:1.9059209823608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keezletown' limit 1
loadtime:1.9059739112854 / seconds
Query Executed:select id FROM `va` where city='Keezletown' && SIC_code='8351'DB:business_master_new
loadtime:1.9067499637604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:1.9068100452423 / seconds
Query Executed:select id FROM `va` where city='Keller' && SIC_code='8351'DB:business_master_new
loadtime:1.9074840545654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenbridge' limit 1
loadtime:1.9075489044189 / seconds
Query Executed:select id FROM `va` where city='Kenbridge' && SIC_code='8351'DB:business_master_new
loadtime:1.9102039337158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kents Store' limit 1
loadtime:1.9102630615234 / seconds
Query Executed:select id FROM `va` where city='Kents Store' && SIC_code='8351'DB:business_master_new
loadtime:1.9111480712891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokee' limit 1
loadtime:1.9112200737 / seconds
Query Executed:select id FROM `va` where city='Keokee' && SIC_code='8351'DB:business_master_new
loadtime:1.9117579460144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:1.9118111133575 / seconds
Query Executed:select id FROM `va` where city='Keswick' && SIC_code='8351'DB:business_master_new
loadtime:1.9142498970032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keysville' limit 1
loadtime:1.9143240451813 / seconds
Query Executed:select id FROM `va` where city='Keysville' && SIC_code='8351'DB:business_master_new
loadtime:1.9171249866486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmarnock' limit 1
loadtime:1.9171969890594 / seconds
Query Executed:select id FROM `va` where city='Kilmarnock' && SIC_code='8351'DB:business_master_new
loadtime:1.92529296875 / seconds
Query loaded from cache:select * from geodata_geocity where city='King & Queen C H' limit 1
loadtime:1.9253749847412 / seconds
Query Executed:select id FROM `va` where city='King & Queen C H' && SIC_code='8351'DB:business_master_new
loadtime:1.9258410930634 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court Hous' limit 1
loadtime:1.9259059429169 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court Hous' && SIC_code='8351'DB:business_master_new
loadtime:1.9263360500336 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court House' limit 1
loadtime:1.9263970851898 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court House' && SIC_code='8351'DB:business_master_new
loadtime:1.9272620677948 / seconds
Query loaded from cache:select * from geodata_geocity where city='King George' limit 1
loadtime:1.9273250102997 / seconds
Query Executed:select id FROM `va` where city='King George' && SIC_code='8351'DB:business_master_new
loadtime:1.9373619556427 / seconds
Query loaded from cache:select * from geodata_geocity where city='King William' limit 1
loadtime:1.9374508857727 / seconds
Query Executed:select id FROM `va` where city='King William' && SIC_code='8351'DB:business_master_new
loadtime:1.9394030570984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsale' limit 1
loadtime:1.9394779205322 / seconds
Query Executed:select id FROM `va` where city='Kinsale' && SIC_code='8351'DB:business_master_new
loadtime:1.9403460025787 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:1.9404170513153 / seconds
Query Executed:select id FROM `va` where city='La Crosse' && SIC_code='8351'DB:business_master_new
loadtime:1.9423360824585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey Spring' limit 1
loadtime:1.9424159526825 / seconds
Query Executed:select id FROM `va` where city='Lacey Spring' && SIC_code='8351'DB:business_master_new
loadtime:1.9428429603577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lackey' limit 1
loadtime:1.9429109096527 / seconds
Query Executed:select id FROM `va` where city='Lackey' && SIC_code='8351'DB:business_master_new
loadtime:1.9433860778809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:1.9434568881989 / seconds
Query Executed:select id FROM `va` where city='Ladysmith' && SIC_code='8351'DB:business_master_new
loadtime:1.944326877594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:1.9443941116333 / seconds
Query Executed:select id FROM `va` where city='Lafayette' && SIC_code='8351'DB:business_master_new
loadtime:1.9447538852692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambsburg' limit 1
loadtime:1.9448099136353 / seconds
Query Executed:select id FROM `va` where city='Lambsburg' && SIC_code='8351'DB:business_master_new
loadtime:1.9453229904175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.945375919342 / seconds
Query Executed:select id FROM `va` where city='Lancaster' && SIC_code='8351'DB:business_master_new
loadtime:1.9477479457855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laneview' limit 1
loadtime:1.9478158950806 / seconds
Query Executed:select id FROM `va` where city='Laneview' && SIC_code='8351'DB:business_master_new
loadtime:1.9483070373535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanexa' limit 1
loadtime:1.9483680725098 / seconds
Query Executed:select id FROM `va` where city='Lanexa' && SIC_code='8351'DB:business_master_new
loadtime:1.9500050544739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley Afb' limit 1
loadtime:1.9500739574432 / seconds
Query Executed:select id FROM `va` where city='Langley Afb' && SIC_code='8351'DB:business_master_new
loadtime:1.9505729675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Fork' limit 1
loadtime:1.9506249427795 / seconds
Query Executed:select id FROM `va` where city='Laurel Fork' && SIC_code='8351'DB:business_master_new
loadtime:1.9514360427856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:1.9514889717102 / seconds
Query Executed:select id FROM `va` where city='Lawrenceville' && SIC_code='8351'DB:business_master_new
loadtime:1.955708026886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:1.9557769298553 / seconds
Query Executed:select id FROM `va` where city='Lebanon' && SIC_code='8351'DB:business_master_new
loadtime:1.9641599655151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon Church' limit 1
loadtime:1.9642460346222 / seconds
Query Executed:select id FROM `va` where city='Lebanon Church' && SIC_code='8351'DB:business_master_new
loadtime:1.9646580219269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:1.9647130966187 / seconds
Query Executed:select id FROM `va` where city='Leesburg' && SIC_code='8351'DB:business_master_new
loadtime:2.0022070407867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:2.002317905426 / seconds
Query Executed:select id FROM `va` where city='Leon' && SIC_code='8351'DB:business_master_new
loadtime:2.0028960704803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:2.0029540061951 / seconds
Query Executed:select id FROM `va` where city='Lexington' && SIC_code='8351'DB:business_master_new
loadtime:2.0178120136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lightfoot' limit 1
loadtime:2.0179040431976 / seconds
Query Executed:select id FROM `va` where city='Lightfoot' && SIC_code='8351'DB:business_master_new
loadtime:2.0188779830933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lignum' limit 1
loadtime:2.0189459323883 / seconds
Query Executed:select id FROM `va` where city='Lignum' && SIC_code='8351'DB:business_master_new
loadtime:2.0196130275726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:2.0196659564972 / seconds
Query Executed:select id FROM `va` where city='Lincoln' && SIC_code='8351'DB:business_master_new
loadtime:2.0202369689941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:2.0202898979187 / seconds
Query Executed:select id FROM `va` where city='Linden' && SIC_code='8351'DB:business_master_new
loadtime:2.0217759609222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:2.0218288898468 / seconds
Query Executed:select id FROM `va` where city='Linville' && SIC_code='8351'DB:business_master_new
loadtime:2.0228118896484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Plymouth' limit 1
loadtime:2.0228779315948 / seconds
Query Executed:select id FROM `va` where city='Little Plymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.0233430862427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lively' limit 1
loadtime:2.023402929306 / seconds
Query Executed:select id FROM `va` where city='Lively' && SIC_code='8351'DB:business_master_new
loadtime:2.0242209434509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Dale' limit 1
loadtime:2.0242788791656 / seconds
Query Executed:select id FROM `va` where city='Locust Dale' && SIC_code='8351'DB:business_master_new
loadtime:2.0248010158539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Grove' limit 1
loadtime:2.0248529911041 / seconds
Query Executed:select id FROM `va` where city='Locust Grove' && SIC_code='8351'DB:business_master_new
loadtime:2.0313649177551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Hill' limit 1
loadtime:2.031445980072 / seconds
Query Executed:select id FROM `va` where city='Locust Hill' && SIC_code='8351'DB:business_master_new
loadtime:2.0322110652924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locustville' limit 1
loadtime:2.0322749614716 / seconds
Query Executed:select id FROM `va` where city='Locustville' && SIC_code='8351'DB:business_master_new
loadtime:2.0328269004822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:2.032879114151 / seconds
Query Executed:select id FROM `va` where city='Long Island' && SIC_code='8351'DB:business_master_new
loadtime:2.0336179733276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:2.0336709022522 / seconds
Query Executed:select id FROM `va` where city='Loretto' && SIC_code='8351'DB:business_master_new
loadtime:2.0340950489044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorton' limit 1
loadtime:2.0341489315033 / seconds
Query Executed:select id FROM `va` where city='Lorton' && SIC_code='8351'DB:business_master_new
loadtime:2.0507030487061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lottsburg' limit 1
loadtime:2.0507841110229 / seconds
Query Executed:select id FROM `va` where city='Lottsburg' && SIC_code='8351'DB:business_master_new
loadtime:2.0520100593567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisa' limit 1
loadtime:2.0520761013031 / seconds
Query Executed:select id FROM `va` where city='Louisa' && SIC_code='8351'DB:business_master_new
loadtime:2.0601940155029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovettsville' limit 1
loadtime:2.0602738857269 / seconds
Query Executed:select id FROM `va` where city='Lovettsville' && SIC_code='8351'DB:business_master_new
loadtime:2.063159942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovingston' limit 1
loadtime:2.063227891922 / seconds
Query Executed:select id FROM `va` where city='Lovingston' && SIC_code='8351'DB:business_master_new
loadtime:2.065376996994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:2.0654540061951 / seconds
Query Executed:select id FROM `va` where city='Low Moor' && SIC_code='8351'DB:business_master_new
loadtime:2.0663459300995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowesville' limit 1
loadtime:2.0664169788361 / seconds
Query Executed:select id FROM `va` where city='Lowesville' && SIC_code='8351'DB:business_master_new
loadtime:2.0668070316315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowmoor' limit 1
loadtime:2.0668640136719 / seconds
Query Executed:select id FROM `va` where city='Lowmoor' && SIC_code='8351'DB:business_master_new
loadtime:2.0672380924225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:2.0672950744629 / seconds
Query Executed:select id FROM `va` where city='Lowry' && SIC_code='8351'DB:business_master_new
loadtime:2.0676860809326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:2.0677380561829 / seconds
Query Executed:select id FROM `va` where city='Lunenburg' && SIC_code='8351'DB:business_master_new
loadtime:2.068393945694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:2.0684480667114 / seconds
Query Executed:select id FROM `va` where city='Luray' && SIC_code='8351'DB:business_master_new
loadtime:2.0791020393372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynch Station' limit 1
loadtime:2.0791819095612 / seconds
Query Executed:select id FROM `va` where city='Lynch Station' && SIC_code='8351'DB:business_master_new
loadtime:2.0802230834961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:2.080276966095 / seconds
Query Executed:select id FROM `va` where city='Lynchburg' && SIC_code='8351'DB:business_master_new
loadtime:2.136116027832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:2.1362609863281 / seconds
Query Executed:select id FROM `va` where city='Lyndhurst' && SIC_code='8351'DB:business_master_new
loadtime:2.1374309062958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Machipongo' limit 1
loadtime:2.1374950408936 / seconds
Query Executed:select id FROM `va` where city='Machipongo' && SIC_code='8351'DB:business_master_new
loadtime:2.1382720470428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:2.138326883316 / seconds
Query Executed:select id FROM `va` where city='Macon' && SIC_code='8351'DB:business_master_new
loadtime:2.1387350559235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:2.1387870311737 / seconds
Query Executed:select id FROM `va` where city='Madison' && SIC_code='8351'DB:business_master_new
loadtime:2.1428120136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:2.1428949832916 / seconds
Query Executed:select id FROM `va` where city='Madison Heights' && SIC_code='8351'DB:business_master_new
loadtime:2.1531050205231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Mills' limit 1
loadtime:2.1531960964203 / seconds
Query Executed:select id FROM `va` where city='Madison Mills' && SIC_code='8351'DB:business_master_new
loadtime:2.1537690162659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidens' limit 1
loadtime:2.1538279056549 / seconds
Query Executed:select id FROM `va` where city='Maidens' && SIC_code='8351'DB:business_master_new
loadtime:2.155100107193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manakin Sabot' limit 1
loadtime:2.1551740169525 / seconds
Query Executed:select id FROM `va` where city='Manakin Sabot' && SIC_code='8351'DB:business_master_new
loadtime:2.1586320400238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas' limit 1
loadtime:2.1587059497833 / seconds
Query Executed:select id FROM `va` where city='Manassas' && SIC_code='8351'DB:business_master_new
loadtime:2.2277688980103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas Park' limit 1
loadtime:2.2280340194702 / seconds
Query Executed:select id FROM `va` where city='Manassas Park' && SIC_code='8351'DB:business_master_new
loadtime:2.2285730838776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mangohick' limit 1
loadtime:2.2286438941956 / seconds
Query Executed:select id FROM `va` where city='Mangohick' && SIC_code='8351'DB:business_master_new
loadtime:2.2290270328522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannboro' limit 1
loadtime:2.2290968894958 / seconds
Query Executed:select id FROM `va` where city='Mannboro' && SIC_code='8351'DB:business_master_new
loadtime:2.2294969558716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manquin' limit 1
loadtime:2.2295579910278 / seconds
Query Executed:select id FROM `va` where city='Manquin' && SIC_code='8351'DB:business_master_new
loadtime:2.230427980423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mappsville' limit 1
loadtime:2.2304940223694 / seconds
Query Executed:select id FROM `va` where city='Mappsville' && SIC_code='8351'DB:business_master_new
loadtime:2.2311100959778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:2.231164932251 / seconds
Query Executed:select id FROM `va` where city='Marion' && SIC_code='8351'DB:business_master_new
loadtime:2.242439031601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marionville' limit 1
loadtime:2.2425150871277 / seconds
Query Executed:select id FROM `va` where city='Marionville' && SIC_code='8351'DB:business_master_new
loadtime:2.2431099414825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markham' limit 1
loadtime:2.2431719303131 / seconds
Query Executed:select id FROM `va` where city='Markham' && SIC_code='8351'DB:business_master_new
loadtime:2.2438170909882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:2.2438690662384 / seconds
Query Executed:select id FROM `va` where city='Marshall' && SIC_code='8351'DB:business_master_new
loadtime:2.2485449314117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:2.2486159801483 / seconds
Query Executed:select id FROM `va` where city='Martinsville' && SIC_code='8351'DB:business_master_new
loadtime:2.2752768993378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maryus' limit 1
loadtime:2.2754299640656 / seconds
Query Executed:select id FROM `va` where city='Maryus' && SIC_code='8351'DB:business_master_new
loadtime:2.2759339809418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mascot' limit 1
loadtime:2.2759931087494 / seconds
Query Executed:select id FROM `va` where city='Mascot' && SIC_code='8351'DB:business_master_new
loadtime:2.2764129638672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massies Mill' limit 1
loadtime:2.2764720916748 / seconds
Query Executed:select id FROM `va` where city='Massies Mill' && SIC_code='8351'DB:business_master_new
loadtime:2.2769110202789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:2.2769649028778 / seconds
Query Executed:select id FROM `va` where city='Mathews' && SIC_code='8351'DB:business_master_new
loadtime:2.2801480293274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattaponi' limit 1
loadtime:2.2802278995514 / seconds
Query Executed:select id FROM `va` where city='Mattaponi' && SIC_code='8351'DB:business_master_new
loadtime:2.2809898853302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurertown' limit 1
loadtime:2.2810459136963 / seconds
Query Executed:select id FROM `va` where city='Maurertown' && SIC_code='8351'DB:business_master_new
loadtime:2.282301902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mavisdale' limit 1
loadtime:2.2823820114136 / seconds
Query Executed:select id FROM `va` where city='Mavisdale' && SIC_code='8351'DB:business_master_new
loadtime:2.2827930450439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Max Meadows' limit 1
loadtime:2.2828509807587 / seconds
Query Executed:select id FROM `va` where city='Max Meadows' && SIC_code='8351'DB:business_master_new
loadtime:2.2852020263672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxie' limit 1
loadtime:2.2852730751038 / seconds
Query Executed:select id FROM `va` where city='Maxie' && SIC_code='8351'DB:business_master_new
loadtime:2.2857880592346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clure' limit 1
loadtime:2.2858409881592 / seconds
Query Executed:select id FROM `va` where city='Mc Clure' && SIC_code='8351'DB:business_master_new
loadtime:2.2863290309906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:2.2863869667053 / seconds
Query Executed:select id FROM `va` where city='Mc Coy' && SIC_code='8351'DB:business_master_new
loadtime:2.2868499755859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Dowell' limit 1
loadtime:2.2869260311127 / seconds
Query Executed:select id FROM `va` where city='Mc Dowell' && SIC_code='8351'DB:business_master_new
loadtime:2.2876770496368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gaheysville' limit 1
loadtime:2.2877480983734 / seconds
Query Executed:select id FROM `va` where city='Mc Gaheysville' && SIC_code='8351'DB:business_master_new
loadtime:2.289498090744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenney' limit 1
loadtime:2.2895750999451 / seconds
Query Executed:select id FROM `va` where city='Mc Kenney' && SIC_code='8351'DB:business_master_new
loadtime:2.2909181118011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lean' limit 1
loadtime:2.2909739017487 / seconds
Query Executed:select id FROM `va` where city='Mc Lean' && SIC_code='8351'DB:business_master_new
loadtime:2.3481249809265 / seconds
Query Executed:select * from geodata_geocity where city='Mckenney' limit 1DB:business_master_new
loadtime:2.348699092865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mclean' limit 1
loadtime:2.3487839698792 / seconds
Query Executed:select id FROM `va` where city='Mclean' && SIC_code='8351'DB:business_master_new
loadtime:2.3496010303497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows Of Dan' limit 1
loadtime:2.3496708869934 / seconds
Query Executed:select id FROM `va` where city='Meadows Of Dan' && SIC_code='8351'DB:business_master_new
loadtime:2.3509559631348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowview' limit 1
loadtime:2.3510150909424 / seconds
Query Executed:select id FROM `va` where city='Meadowview' && SIC_code='8351'DB:business_master_new
loadtime:2.3528249263763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:2.3529119491577 / seconds
Query Executed:select id FROM `va` where city='Mears' && SIC_code='8351'DB:business_master_new
loadtime:2.3533990383148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:2.3534588813782 / seconds
Query Executed:select id FROM `va` where city='Mechanicsville' && SIC_code='8351'DB:business_master_new
loadtime:2.3822190761566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meherrin' limit 1
loadtime:2.3823499679565 / seconds
Query Executed:select id FROM `va` where city='Meherrin' && SIC_code='8351'DB:business_master_new
loadtime:2.3831870555878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melfa' limit 1
loadtime:2.3832550048828 / seconds
Query Executed:select id FROM `va` where city='Melfa' && SIC_code='8351'DB:business_master_new
loadtime:2.3846979141235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendota' limit 1
loadtime:2.3847739696503 / seconds
Query Executed:select id FROM `va` where city='Mendota' && SIC_code='8351'DB:business_master_new
loadtime:2.3853139877319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredithville' limit 1
loadtime:2.3853890895844 / seconds
Query Executed:select id FROM `va` where city='Meredithville' && SIC_code='8351'DB:business_master_new
loadtime:2.3857669830322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrifield' limit 1
loadtime:2.3858308792114 / seconds
Query Executed:select id FROM `va` where city='Merrifield' && SIC_code='8351'DB:business_master_new
loadtime:2.3876950740814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Point' limit 1
loadtime:2.3877580165863 / seconds
Query Executed:select id FROM `va` where city='Merry Point' && SIC_code='8351'DB:business_master_new
loadtime:2.3882060050964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebrook' limit 1
loadtime:2.3882639408112 / seconds
Query Executed:select id FROM `va` where city='Middlebrook' && SIC_code='8351'DB:business_master_new
loadtime:2.3890459537506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:2.389102935791 / seconds
Query Executed:select id FROM `va` where city='Middleburg' && SIC_code='8351'DB:business_master_new
loadtime:2.3971700668335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:2.3972408771515 / seconds
Query Executed:select id FROM `va` where city='Middletown' && SIC_code='8351'DB:business_master_new
loadtime:2.399218082428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:2.3992869853973 / seconds
Query Executed:select id FROM `va` where city='Midland' && SIC_code='8351'DB:business_master_new
loadtime:2.4009571075439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midlothian' limit 1
loadtime:2.4010291099548 / seconds
Query Executed:select id FROM `va` where city='Midlothian' && SIC_code='8351'DB:business_master_new
loadtime:2.4393129348755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:2.4394700527191 / seconds
Query Executed:select id FROM `va` where city='Milford' && SIC_code='8351'DB:business_master_new
loadtime:2.4408760070801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millboro' limit 1
loadtime:2.4409799575806 / seconds
Query Executed:select id FROM `va` where city='Millboro' && SIC_code='8351'DB:business_master_new
loadtime:2.4420919418335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Tavern' limit 1
loadtime:2.4421739578247 / seconds
Query Executed:select id FROM `va` where city='Millers Tavern' && SIC_code='8351'DB:business_master_new
loadtime:2.4428060054779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:2.4428720474243 / seconds
Query Executed:select id FROM `va` where city='Millwood' && SIC_code='8351'DB:business_master_new
loadtime:2.4436039924622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Run' limit 1
loadtime:2.4436590671539 / seconds
Query Executed:select id FROM `va` where city='Mine Run' && SIC_code='8351'DB:business_master_new
loadtime:2.4441220760345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:2.4441869258881 / seconds
Query Executed:select id FROM `va` where city='Mineral' && SIC_code='8351'DB:business_master_new
loadtime:2.476380109787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Spring' limit 1
loadtime:2.4764568805695 / seconds
Query Executed:select id FROM `va` where city='Mint Spring' && SIC_code='8351'DB:business_master_new
loadtime:2.4770479202271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchells' limit 1
loadtime:2.4771149158478 / seconds
Query Executed:select id FROM `va` where city='Mitchells' && SIC_code='8351'DB:business_master_new
loadtime:2.4777081012726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modest Town' limit 1
loadtime:2.4777679443359 / seconds
Query Executed:select id FROM `va` where city='Modest Town' && SIC_code='8351'DB:business_master_new
loadtime:2.4781758785248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mollusk' limit 1
loadtime:2.4782350063324 / seconds
Query Executed:select id FROM `va` where city='Mollusk' && SIC_code='8351'DB:business_master_new
loadtime:2.478688955307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moneta' limit 1
loadtime:2.4787499904633 / seconds
Query Executed:select id FROM `va` where city='Moneta' && SIC_code='8351'DB:business_master_new
loadtime:2.4874761104584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.4875481128693 / seconds
Query Executed:select id FROM `va` where city='Monroe' && SIC_code='8351'DB:business_master_new
loadtime:2.4892230033875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montebello' limit 1
loadtime:2.4892930984497 / seconds
Query Executed:select id FROM `va` where city='Montebello' && SIC_code='8351'DB:business_master_new
loadtime:2.4897799491882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:2.4898328781128 / seconds
Query Executed:select id FROM `va` where city='Monterey' && SIC_code='8351'DB:business_master_new
loadtime:2.4919209480286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:2.4919879436493 / seconds
Query Executed:select id FROM `va` where city='Montpelier' && SIC_code='8351'DB:business_master_new
loadtime:2.5229859352112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Sta' limit 1
loadtime:2.5230779647827 / seconds
Query Executed:select id FROM `va` where city='Montpelier Sta' && SIC_code='8351'DB:business_master_new
loadtime:2.5234689712524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Station' limit 1
loadtime:2.5235359668732 / seconds
Query Executed:select id FROM `va` where city='Montpelier Station' && SIC_code='8351'DB:business_master_new
loadtime:2.5239470005035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montross' limit 1
loadtime:2.5240080356598 / seconds
Query Executed:select id FROM `va` where city='Montross' && SIC_code='8351'DB:business_master_new
loadtime:2.5300290584564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:2.5301239490509 / seconds
Query Executed:select id FROM `va` where city='Montvale' && SIC_code='8351'DB:business_master_new
loadtime:2.5313050746918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moon' limit 1
loadtime:2.5313820838928 / seconds
Query Executed:select id FROM `va` where city='Moon' && SIC_code='8351'DB:business_master_new
loadtime:2.5319120883942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morattico' limit 1
loadtime:2.5319759845734 / seconds
Query Executed:select id FROM `va` where city='Morattico' && SIC_code='8351'DB:business_master_new
loadtime:2.53244805336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:2.5325019359589 / seconds
Query Executed:select id FROM `va` where city='Morrisville' && SIC_code='8351'DB:business_master_new
loadtime:2.5329639911652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moseley' limit 1
loadtime:2.5330169200897 / seconds
Query Executed:select id FROM `va` where city='Moseley' && SIC_code='8351'DB:business_master_new
loadtime:2.5349590778351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Crawford' limit 1
loadtime:2.5350179672241 / seconds
Query Executed:select id FROM `va` where city='Mount Crawford' && SIC_code='8351'DB:business_master_new
loadtime:2.5370230674744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:2.5370810031891 / seconds
Query Executed:select id FROM `va` where city='Mount Holly' && SIC_code='8351'DB:business_master_new
loadtime:2.537661075592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Jackson' limit 1
loadtime:2.5377130508423 / seconds
Query Executed:select id FROM `va` where city='Mount Jackson' && SIC_code='8351'DB:business_master_new
loadtime:2.5690240859985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sidney' limit 1
loadtime:2.5691249370575 / seconds
Query Executed:select id FROM `va` where city='Mount Sidney' && SIC_code='8351'DB:business_master_new
loadtime:2.5704019069672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Solon' limit 1
loadtime:2.5704679489136 / seconds
Query Executed:select id FROM `va` where city='Mount Solon' && SIC_code='8351'DB:business_master_new
loadtime:2.5717771053314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:2.5718309879303 / seconds
Query Executed:select id FROM `va` where city='Mount Vernon' && SIC_code='8351'DB:business_master_new
loadtime:2.5726969242096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mouth Of Wilson' limit 1
loadtime:2.5727550983429 / seconds
Query Executed:select id FROM `va` where city='Mouth Of Wilson' && SIC_code='8351'DB:business_master_new
loadtime:2.5736498832703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Crawford' limit 1
loadtime:2.5737080574036 / seconds
Query Executed:select id FROM `va` where city='Mt Crawford' && SIC_code='8351'DB:business_master_new
loadtime:2.5741739273071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:2.574245929718 / seconds
Query Executed:select id FROM `va` where city='Mt Holly' && SIC_code='8351'DB:business_master_new
loadtime:2.5746109485626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Jackson' limit 1
loadtime:2.574667930603 / seconds
Query Executed:select id FROM `va` where city='Mt Jackson' && SIC_code='8351'DB:business_master_new
loadtime:2.5751359462738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sidney' limit 1
loadtime:2.5751979351044 / seconds
Query Executed:select id FROM `va` where city='Mt Sidney' && SIC_code='8351'DB:business_master_new
loadtime:2.5755779743195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Solon' limit 1
loadtime:2.5756390094757 / seconds
Query Executed:select id FROM `va` where city='Mt Solon' && SIC_code='8351'DB:business_master_new
loadtime:2.576024055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:2.5760810375214 / seconds
Query Executed:select id FROM `va` where city='Mt Vernon' && SIC_code='8351'DB:business_master_new
loadtime:2.5764861106873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mustoe' limit 1
loadtime:2.5765450000763 / seconds
Query Executed:select id FROM `va` where city='Mustoe' && SIC_code='8351'DB:business_master_new
loadtime:2.5769379138947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narrows' limit 1
loadtime:2.5769910812378 / seconds
Query Executed:select id FROM `va` where city='Narrows' && SIC_code='8351'DB:business_master_new
loadtime:2.579078912735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naruna' limit 1
loadtime:2.5791580677032 / seconds
Query Executed:select id FROM `va` where city='Naruna' && SIC_code='8351'DB:business_master_new
loadtime:2.5797019004822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nassawadox' limit 1
loadtime:2.5797600746155 / seconds
Query Executed:select id FROM `va` where city='Nassawadox' && SIC_code='8351'DB:business_master_new
loadtime:2.58118891716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathalie' limit 1
loadtime:2.5812571048737 / seconds
Query Executed:select id FROM `va` where city='Nathalie' && SIC_code='8351'DB:business_master_new
loadtime:2.5832200050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Brdg Sta' limit 1
loadtime:2.5832960605621 / seconds
Query Executed:select id FROM `va` where city='Natural Brdg Sta' && SIC_code='8351'DB:business_master_new
loadtime:2.5837240219116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge' limit 1
loadtime:2.5837769508362 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge' && SIC_code='8351'DB:business_master_new
loadtime:2.5850150585175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge Station' limit 1
loadtime:2.5850749015808 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge Station' && SIC_code='8351'DB:business_master_new
loadtime:2.5860240459442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naval Base' limit 1
loadtime:2.5861029624939 / seconds
Query Executed:select id FROM `va` where city='Naval Base' && SIC_code='8351'DB:business_master_new
loadtime:2.5866770744324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellysford' limit 1
loadtime:2.5867340564728 / seconds
Query Executed:select id FROM `va` where city='Nellysford' && SIC_code='8351'DB:business_master_new
loadtime:2.5885629653931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:2.5886359214783 / seconds
Query Executed:select id FROM `va` where city='Nelson' && SIC_code='8351'DB:business_master_new
loadtime:2.5892379283905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonia' limit 1
loadtime:2.5892999172211 / seconds
Query Executed:select id FROM `va` where city='Nelsonia' && SIC_code='8351'DB:business_master_new
loadtime:2.5898420810699 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canton' limit 1
loadtime:2.5899078845978 / seconds
Query Executed:select id FROM `va` where city='New Canton' && SIC_code='8351'DB:business_master_new
loadtime:2.5907828807831 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:2.5908529758453 / seconds
Query Executed:select id FROM `va` where city='New Castle' && SIC_code='8351'DB:business_master_new
loadtime:2.5928170681 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Church' limit 1
loadtime:2.59290599823 / seconds
Query Executed:select id FROM `va` where city='New Church' && SIC_code='8351'DB:business_master_new
loadtime:2.5941898822784 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:2.5942440032959 / seconds
Query Executed:select id FROM `va` where city='New Hope' && SIC_code='8351'DB:business_master_new
loadtime:2.5947799682617 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Kent' limit 1
loadtime:2.5948390960693 / seconds
Query Executed:select id FROM `va` where city='New Kent' && SIC_code='8351'DB:business_master_new
loadtime:2.5965549945831 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:2.5966210365295 / seconds
Query Executed:select id FROM `va` where city='New Market' && SIC_code='8351'DB:business_master_new
loadtime:2.6004350185394 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Point' limit 1
loadtime:2.6005129814148 / seconds
Query Executed:select id FROM `va` where city='New Point' && SIC_code='8351'DB:business_master_new
loadtime:2.6009860038757 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:2.6010410785675 / seconds
Query Executed:select id FROM `va` where city='New River' && SIC_code='8351'DB:business_master_new
loadtime:2.6014831066132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:2.6015350818634 / seconds
Query Executed:select id FROM `va` where city='Newbern' && SIC_code='8351'DB:business_master_new
loadtime:2.6020970344543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:2.6021640300751 / seconds
Query Executed:select id FROM `va` where city='Newington' && SIC_code='8351'DB:business_master_new
loadtime:2.603667974472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:2.6037220954895 / seconds
Query Executed:select id FROM `va` where city='Newport' && SIC_code='8351'DB:business_master_new
loadtime:2.6047160625458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport News' limit 1
loadtime:2.6047790050507 / seconds
Query Executed:select id FROM `va` where city='Newport News' && SIC_code='8351'DB:business_master_new
loadtime:2.6365969181061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newsoms' limit 1
loadtime:2.6368350982666 / seconds
Query Executed:select id FROM `va` where city='Newsoms' && SIC_code='8351'DB:business_master_new
loadtime:2.6377010345459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:2.6377699375153 / seconds
Query Executed:select id FROM `va` where city='Newtown' && SIC_code='8351'DB:business_master_new
loadtime:2.6382720470428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickelsville' limit 1
loadtime:2.6383299827576 / seconds
Query Executed:select id FROM `va` where city='Nickelsville' && SIC_code='8351'DB:business_master_new
loadtime:2.6393671035767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninde' limit 1
loadtime:2.6394340991974 / seconds
Query Executed:select id FROM `va` where city='Ninde' && SIC_code='8351'DB:business_master_new
loadtime:2.6398499011993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nokesville' limit 1
loadtime:2.6399230957031 / seconds
Query Executed:select id FROM `va` where city='Nokesville' && SIC_code='8351'DB:business_master_new
loadtime:2.6435840129852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora' limit 1
loadtime:2.6436579227448 / seconds
Query Executed:select id FROM `va` where city='Nora' && SIC_code='8351'DB:business_master_new
loadtime:2.6442079544067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:2.6442639827728 / seconds
Query Executed:select id FROM `va` where city='Norfolk' && SIC_code='8351'DB:business_master_new
loadtime:2.6756041049957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norge' limit 1
loadtime:2.6758089065552 / seconds
Query Executed:select id FROM `va` where city='Norge' && SIC_code='8351'DB:business_master_new
loadtime:2.6764490604401 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:2.6765220165253 / seconds
Query Executed:select id FROM `va` where city='North' && SIC_code='8351'DB:business_master_new
loadtime:2.6772220134735 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Garden' limit 1
loadtime:2.6772859096527 / seconds
Query Executed:select id FROM `va` where city='North Garden' && SIC_code='8351'DB:business_master_new
loadtime:2.6784501075745 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Tazewell' limit 1
loadtime:2.6785089969635 / seconds
Query Executed:select id FROM `va` where city='North Tazewell' && SIC_code='8351'DB:business_master_new
loadtime:2.6810638904572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:2.6811308860779 / seconds
Query Executed:select id FROM `va` where city='Norton' && SIC_code='8351'DB:business_master_new
loadtime:2.689877986908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:2.6899619102478 / seconds
Query Executed:select id FROM `va` where city='Norwood' && SIC_code='8351'DB:business_master_new
loadtime:2.6903929710388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottoway' limit 1
loadtime:2.6904530525208 / seconds
Query Executed:select id FROM `va` where city='Nottoway' && SIC_code='8351'DB:business_master_new
loadtime:2.691104888916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nuttsville' limit 1
loadtime:2.6911599636078 / seconds
Query Executed:select id FROM `va` where city='Nuttsville' && SIC_code='8351'DB:business_master_new
loadtime:2.6915829181671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hall' limit 1
loadtime:2.6916530132294 / seconds
Query Executed:select id FROM `va` where city='Oak Hall' && SIC_code='8351'DB:business_master_new
loadtime:2.6926579475403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakpark' limit 1
loadtime:2.6927170753479 / seconds
Query Executed:select id FROM `va` where city='Oakpark' && SIC_code='8351'DB:business_master_new
loadtime:2.693186044693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakton' limit 1
loadtime:2.6933319568634 / seconds
Query Executed:select id FROM `va` where city='Oakton' && SIC_code='8351'DB:business_master_new
loadtime:2.7039361000061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakwood' limit 1
loadtime:2.7040200233459 / seconds
Query Executed:select id FROM `va` where city='Oakwood' && SIC_code='8351'DB:business_master_new
loadtime:2.7055220603943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Occoquan' limit 1
loadtime:2.7055790424347 / seconds
Query Executed:select id FROM `va` where city='Occoquan' && SIC_code='8351'DB:business_master_new
loadtime:2.7075529098511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oilville' limit 1
loadtime:2.7076199054718 / seconds
Query Executed:select id FROM `va` where city='Oilville' && SIC_code='8351'DB:business_master_new
loadtime:2.7089200019836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldhams' limit 1
loadtime:2.7089738845825 / seconds
Query Executed:select id FROM `va` where city='Oldhams' && SIC_code='8351'DB:business_master_new
loadtime:2.7094490528107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onancock' limit 1
loadtime:2.7095100879669 / seconds
Query Executed:select id FROM `va` where city='Onancock' && SIC_code='8351'DB:business_master_new
loadtime:2.7126979827881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onemo' limit 1
loadtime:2.7127649784088 / seconds
Query Executed:select id FROM `va` where city='Onemo' && SIC_code='8351'DB:business_master_new
loadtime:2.7132380008698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onley' limit 1
loadtime:2.7132930755615 / seconds
Query Executed:select id FROM `va` where city='Onley' && SIC_code='8351'DB:business_master_new
loadtime:2.7153429985046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophelia' limit 1
loadtime:2.7154240608215 / seconds
Query Executed:select id FROM `va` where city='Ophelia' && SIC_code='8351'DB:business_master_new
loadtime:2.715861082077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:2.7159268856049 / seconds
Query Executed:select id FROM `va` where city='Orange' && SIC_code='8351'DB:business_master_new
loadtime:2.725811958313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordinary' limit 1
loadtime:2.72589802742 / seconds
Query Executed:select id FROM `va` where city='Ordinary' && SIC_code='8351'DB:business_master_new
loadtime:2.7265388965607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriskany' limit 1
loadtime:2.7265939712524 / seconds
Query Executed:select id FROM `va` where city='Oriskany' && SIC_code='8351'DB:business_master_new
loadtime:2.7270278930664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orkney Springs' limit 1
loadtime:2.7270929813385 / seconds
Query Executed:select id FROM `va` where city='Orkney Springs' && SIC_code='8351'DB:business_master_new
loadtime:2.7275450229645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlean' limit 1
loadtime:2.7276039123535 / seconds
Query Executed:select id FROM `va` where city='Orlean' && SIC_code='8351'DB:business_master_new
loadtime:2.7281849384308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyster' limit 1
loadtime:2.7282478809357 / seconds
Query Executed:select id FROM `va` where city='Oyster' && SIC_code='8351'DB:business_master_new
loadtime:2.7286651134491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paeonian Springs' limit 1
loadtime:2.7287170886993 / seconds
Query Executed:select id FROM `va` where city='Paeonian Springs' && SIC_code='8351'DB:business_master_new
loadtime:2.7295429706573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Bank' limit 1
loadtime:2.7296130657196 / seconds
Query Executed:select id FROM `va` where city='Paint Bank' && SIC_code='8351'DB:business_master_new
loadtime:2.7301380634308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painter' limit 1
loadtime:2.7302041053772 / seconds
Query Executed:select id FROM `va` where city='Painter' && SIC_code='8351'DB:business_master_new
loadtime:2.7314579486847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:2.7315249443054 / seconds
Query Executed:select id FROM `va` where city='Palmyra' && SIC_code='8351'DB:business_master_new
loadtime:2.7393620014191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplin' limit 1
loadtime:2.7394540309906 / seconds
Query Executed:select id FROM `va` where city='Pamplin' && SIC_code='8351'DB:business_master_new
loadtime:2.7404708862305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:2.7405269145966 / seconds
Query Executed:select id FROM `va` where city='Paris' && SIC_code='8351'DB:business_master_new
loadtime:2.7411708831787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksley' limit 1
loadtime:2.7412259578705 / seconds
Query Executed:select id FROM `va` where city='Parksley' && SIC_code='8351'DB:business_master_new
loadtime:2.7433159351349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrott' limit 1
loadtime:2.7433869838715 / seconds
Query Executed:select id FROM `va` where city='Parrott' && SIC_code='8351'DB:business_master_new
loadtime:2.7438230514526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partlow' limit 1
loadtime:2.7438900470734 / seconds
Query Executed:select id FROM `va` where city='Partlow' && SIC_code='8351'DB:business_master_new
loadtime:2.7448039054871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick Springs' limit 1
loadtime:2.7448658943176 / seconds
Query Executed:select id FROM `va` where city='Patrick Springs' && SIC_code='8351'DB:business_master_new
loadtime:2.746148109436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:2.7462010383606 / seconds
Query Executed:select id FROM `va` where city='Patterson' && SIC_code='8351'DB:business_master_new
loadtime:2.7466259002686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearisburg' limit 1
loadtime:2.7466878890991 / seconds
Query Executed:select id FROM `va` where city='Pearisburg' && SIC_code='8351'DB:business_master_new
loadtime:2.7787730693817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:2.7788960933685 / seconds
Query Executed:select id FROM `va` where city='Pembroke' && SIC_code='8351'DB:business_master_new
loadtime:2.7807040214539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penhook' limit 1
loadtime:2.7807788848877 / seconds
Query Executed:select id FROM `va` where city='Penhook' && SIC_code='8351'DB:business_master_new
loadtime:2.7821691036224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penn Laird' limit 1
loadtime:2.7822370529175 / seconds
Query Executed:select id FROM `va` where city='Penn Laird' && SIC_code='8351'DB:business_master_new
loadtime:2.7832899093628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington Gap' limit 1
loadtime:2.7833499908447 / seconds
Query Executed:select id FROM `va` where city='Pennington Gap' && SIC_code='8351'DB:business_master_new
loadtime:2.7868540287018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:2.7869389057159 / seconds
Query Executed:select id FROM `va` where city='Petersburg' && SIC_code='8351'DB:business_master_new
loadtime:2.814994096756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix' limit 1
loadtime:2.815141916275 / seconds
Query Executed:select id FROM `va` where city='Phenix' && SIC_code='8351'DB:business_master_new
loadtime:2.815896987915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomont' limit 1
loadtime:2.8159739971161 / seconds
Query Executed:select id FROM `va` where city='Philomont' && SIC_code='8351'DB:business_master_new
loadtime:2.8165218830109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilgrims Knob' limit 1
loadtime:2.81658411026 / seconds
Query Executed:select id FROM `va` where city='Pilgrims Knob' && SIC_code='8351'DB:business_master_new
loadtime:2.8170490264893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot' limit 1
loadtime:2.8171100616455 / seconds
Query Executed:select id FROM `va` where city='Pilot' && SIC_code='8351'DB:business_master_new
loadtime:2.817841053009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney River' limit 1
loadtime:2.8179080486298 / seconds
Query Executed:select id FROM `va` where city='Piney River' && SIC_code='8351'DB:business_master_new
loadtime:2.818629026413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:2.8186900615692 / seconds
Query Executed:select id FROM `va` where city='Pittsville' && SIC_code='8351'DB:business_master_new
loadtime:2.8192780017853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain View' limit 1
loadtime:2.8193430900574 / seconds
Query Executed:select id FROM `va` where city='Plain View' && SIC_code='8351'DB:business_master_new
loadtime:2.8197829723358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:2.8198339939117 / seconds
Query Executed:select id FROM `va` where city='Pleasant Valley' && SIC_code='8351'DB:business_master_new
loadtime:2.8203070163727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:2.8203589916229 / seconds
Query Executed:select id FROM `va` where city='Pocahontas' && SIC_code='8351'DB:business_master_new
loadtime:2.8211140632629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquoson' limit 1
loadtime:2.821172952652 / seconds
Query Executed:select id FROM `va` where city='Poquoson' && SIC_code='8351'DB:business_master_new
loadtime:2.8287830352783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Haywood' limit 1
loadtime:2.8288609981537 / seconds
Query Executed:select id FROM `va` where city='Port Haywood' && SIC_code='8351'DB:business_master_new
loadtime:2.8295609951019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:2.8296248912811 / seconds
Query Executed:select id FROM `va` where city='Port Republic' && SIC_code='8351'DB:business_master_new
loadtime:2.8306469917297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:2.8307139873505 / seconds
Query Executed:select id FROM `va` where city='Port Royal' && SIC_code='8351'DB:business_master_new
loadtime:2.8315711021423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:2.8316249847412 / seconds
Query Executed:select id FROM `va` where city='Portsmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.8728830814362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:2.8730719089508 / seconds
Query Executed:select id FROM `va` where city='Pound' && SIC_code='8351'DB:business_master_new
loadtime:2.8753950595856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pounding Mill' limit 1
loadtime:2.8754758834839 / seconds
Query Executed:select id FROM `va` where city='Pounding Mill' && SIC_code='8351'DB:business_master_new
loadtime:2.8770949840546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:2.8771660327911 / seconds
Query Executed:select id FROM `va` where city='Powhatan' && SIC_code='8351'DB:business_master_new
loadtime:2.8896789550781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratts' limit 1
loadtime:2.8897519111633 / seconds
Query Executed:select id FROM `va` where city='Pratts' && SIC_code='8351'DB:business_master_new
loadtime:2.8903169631958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince George' limit 1
loadtime:2.8903830051422 / seconds
Query Executed:select id FROM `va` where city='Prince George' && SIC_code='8351'DB:business_master_new
loadtime:2.89430809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:2.8943769931793 / seconds
Query Executed:select id FROM `va` where city='Prospect' && SIC_code='8351'DB:business_master_new
loadtime:2.8954041004181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence Forge' limit 1
loadtime:2.8954639434814 / seconds
Query Executed:select id FROM `va` where city='Providence Forge' && SIC_code='8351'DB:business_master_new
loadtime:2.8979249000549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:2.8979790210724 / seconds
Query Executed:select id FROM `va` where city='Pulaski' && SIC_code='8351'DB:business_master_new
loadtime:2.9047288894653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pungoteague' limit 1
loadtime:2.9048120975494 / seconds
Query Executed:select id FROM `va` where city='Pungoteague' && SIC_code='8351'DB:business_master_new
loadtime:2.9054179191589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purcellville' limit 1
loadtime:2.9054861068726 / seconds
Query Executed:select id FROM `va` where city='Purcellville' && SIC_code='8351'DB:business_master_new
loadtime:2.9380369186401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quantico' limit 1
loadtime:2.938138961792 / seconds
Query Executed:select id FROM `va` where city='Quantico' && SIC_code='8351'DB:business_master_new
loadtime:2.9409511089325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quicksburg' limit 1
loadtime:2.9410529136658 / seconds
Query Executed:select id FROM `va` where city='Quicksburg' && SIC_code='8351'DB:business_master_new
loadtime:2.9419560432434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:2.942018032074 / seconds
Query Executed:select id FROM `va` where city='Quinby' && SIC_code='8351'DB:business_master_new
loadtime:2.9425139427185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinque' limit 1
loadtime:2.942568063736 / seconds
Query Executed:select id FROM `va` where city='Quinque' && SIC_code='8351'DB:business_master_new
loadtime:2.9431519508362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:2.9432048797607 / seconds
Query Executed:select id FROM `va` where city='Quinton' && SIC_code='8351'DB:business_master_new
loadtime:2.9461669921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radford' limit 1
loadtime:2.9462530612946 / seconds
Query Executed:select id FROM `va` where city='Radford' && SIC_code='8351'DB:business_master_new
loadtime:2.9592471122742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radiant' limit 1
loadtime:2.9593279361725 / seconds
Query Executed:select id FROM `va` where city='Radiant' && SIC_code='8351'DB:business_master_new
loadtime:2.9598879814148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:2.9599440097809 / seconds
Query Executed:select id FROM `va` where city='Randolph' && SIC_code='8351'DB:business_master_new
loadtime:2.9604840278625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raphine' limit 1
loadtime:2.9605450630188 / seconds
Query Executed:select id FROM `va` where city='Raphine' && SIC_code='8351'DB:business_master_new
loadtime:2.9618771076202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapidan' limit 1
loadtime:2.9619319438934 / seconds
Query Executed:select id FROM `va` where city='Rapidan' && SIC_code='8351'DB:business_master_new
loadtime:2.9629180431366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Academy' limit 1
loadtime:2.9629778862 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Academy' && SIC_code='8351'DB:business_master_new
loadtime:2.9635150432587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Acd' limit 1
loadtime:2.9635729789734 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Acd' && SIC_code='8351'DB:business_master_new
loadtime:2.9640231132507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raven' limit 1
loadtime:2.9640901088715 / seconds
Query Executed:select id FROM `va` where city='Raven' && SIC_code='8351'DB:business_master_new
loadtime:2.9650180339813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlings' limit 1
loadtime:2.9650940895081 / seconds
Query Executed:select id FROM `va` where city='Rawlings' && SIC_code='8351'DB:business_master_new
loadtime:2.9656310081482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rectortown' limit 1
loadtime:2.9656879901886 / seconds
Query Executed:select id FROM `va` where city='Rectortown' && SIC_code='8351'DB:business_master_new
loadtime:2.9661729335785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Ash' limit 1
loadtime:2.9662389755249 / seconds
Query Executed:select id FROM `va` where city='Red Ash' && SIC_code='8351'DB:business_master_new
loadtime:2.9666531085968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:2.9667060375214 / seconds
Query Executed:select id FROM `va` where city='Red House' && SIC_code='8351'DB:business_master_new
loadtime:2.9672770500183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:2.967334985733 / seconds
Query Executed:select id FROM `va` where city='Red Oak' && SIC_code='8351'DB:business_master_new
loadtime:2.9682009220123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redart' limit 1
loadtime:2.9682590961456 / seconds
Query Executed:select id FROM `va` where city='Redart' && SIC_code='8351'DB:business_master_new
loadtime:2.9686958789825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:2.9687480926514 / seconds
Query Executed:select id FROM `va` where city='Redwood' && SIC_code='8351'DB:business_master_new
loadtime:2.9692780971527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedville' limit 1
loadtime:2.9693369865417 / seconds
Query Executed:select id FROM `va` where city='Reedville' && SIC_code='8351'DB:business_master_new
loadtime:2.9711930751801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:2.9712619781494 / seconds
Query Executed:select id FROM `va` where city='Reliance' && SIC_code='8351'DB:business_master_new
loadtime:2.9716899394989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remington' limit 1
loadtime:2.9717528820038 / seconds
Query Executed:select id FROM `va` where city='Remington' && SIC_code='8351'DB:business_master_new
loadtime:2.9736950397491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republican Grove' limit 1
loadtime:2.9737689495087 / seconds
Query Executed:select id FROM `va` where city='Republican Grove' && SIC_code='8351'DB:business_master_new
loadtime:2.9742178916931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rescue' limit 1
loadtime:2.974277973175 / seconds
Query Executed:select id FROM `va` where city='Rescue' && SIC_code='8351'DB:business_master_new
loadtime:2.9747529029846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reston' limit 1
loadtime:2.9748110771179 / seconds
Query Executed:select id FROM `va` where city='Reston' && SIC_code='8351'DB:business_master_new
loadtime:3.0192050933838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:3.0193920135498 / seconds
Query Executed:select id FROM `va` where city='Reva' && SIC_code='8351'DB:business_master_new
loadtime:3.020339012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhoadesville' limit 1
loadtime:3.0204100608826 / seconds
Query Executed:select id FROM `va` where city='Rhoadesville' && SIC_code='8351'DB:business_master_new
loadtime:3.0213809013367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:3.0214369297028 / seconds
Query Executed:select id FROM `va` where city='Rice' && SIC_code='8351'DB:business_master_new
loadtime:3.0223090648651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Creek' limit 1
loadtime:3.0223710536957 / seconds
Query Executed:select id FROM `va` where city='Rich Creek' && SIC_code='8351'DB:business_master_new
loadtime:3.0235650539398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richardsville' limit 1
loadtime:3.0236270427704 / seconds
Query Executed:select id FROM `va` where city='Richardsville' && SIC_code='8351'DB:business_master_new
loadtime:3.0242440700531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:3.0243060588837 / seconds
Query Executed:select id FROM `va` where city='Richlands' && SIC_code='8351'DB:business_master_new
loadtime:3.0325090885162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:3.0325779914856 / seconds
Query Executed:select id FROM `va` where city='Richmond' && SIC_code='8351'DB:business_master_new
loadtime:3.0649430751801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:3.0654180049896 / seconds
Query Executed:select id FROM `va` where city='Ridgeway' && SIC_code='8351'DB:business_master_new
loadtime:3.0692529678345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rileyville' limit 1
loadtime:3.0693500041962 / seconds
Query Executed:select id FROM `va` where city='Rileyville' && SIC_code='8351'DB:business_master_new
loadtime:3.0701019763947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riner' limit 1
loadtime:3.0701670646667 / seconds
Query Executed:select id FROM `va` where city='Riner' && SIC_code='8351'DB:business_master_new
loadtime:3.0715579986572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringgold' limit 1
loadtime:3.0716309547424 / seconds
Query Executed:select id FROM `va` where city='Ringgold' && SIC_code='8351'DB:business_master_new
loadtime:3.0737030506134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripplemead' limit 1
loadtime:3.0737800598145 / seconds
Query Executed:select id FROM `va` where city='Ripplemead' && SIC_code='8351'DB:business_master_new
loadtime:3.074492931366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:3.0745599269867 / seconds
Query Executed:select id FROM `va` where city='Riverton' && SIC_code='8351'DB:business_master_new
loadtime:3.0750069618225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rixeyville' limit 1
loadtime:3.0750799179077 / seconds
Query Executed:select id FROM `va` where city='Rixeyville' && SIC_code='8351'DB:business_master_new
loadtime:3.0765120983124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:3.0765650272369 / seconds
Query Executed:select id FROM `va` where city='Roanoke' && SIC_code='8351'DB:business_master_new
loadtime:3.10773396492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle' limit 1
loadtime:3.107950925827 / seconds
Query Executed:select id FROM `va` where city='Rochelle' && SIC_code='8351'DB:business_master_new
loadtime:3.1087920665741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockbridge Baths' limit 1
loadtime:3.1088600158691 / seconds
Query Executed:select id FROM `va` where city='Rockbridge Baths' && SIC_code='8351'DB:business_master_new
loadtime:3.1095430850983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:3.1096050739288 / seconds
Query Executed:select id FROM `va` where city='Rockville' && SIC_code='8351'DB:business_master_new
loadtime:3.1119339466095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Gap' limit 1
loadtime:3.1120119094849 / seconds
Query Executed:select id FROM `va` where city='Rocky Gap' && SIC_code='8351'DB:business_master_new
loadtime:3.112930059433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:3.1130061149597 / seconds
Query Executed:select id FROM `va` where city='Rocky Mount' && SIC_code='8351'DB:business_master_new
loadtime:3.1278429031372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollins Fork' limit 1
loadtime:3.1279399394989 / seconds
Query Executed:select id FROM `va` where city='Rollins Fork' && SIC_code='8351'DB:business_master_new
loadtime:3.1283929347992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:3.1284511089325 / seconds
Query Executed:select id FROM `va` where city='Rose Hill' && SIC_code='8351'DB:business_master_new
loadtime:3.1296639442444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:3.1297299861908 / seconds
Query Executed:select id FROM `va` where city='Rosedale' && SIC_code='8351'DB:business_master_new
loadtime:3.1307408809662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:3.1308059692383 / seconds
Query Executed:select id FROM `va` where city='Roseland' && SIC_code='8351'DB:business_master_new
loadtime:3.1320900917053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Hill' limit 1
loadtime:3.132150888443 / seconds
Query Executed:select id FROM `va` where city='Round Hill' && SIC_code='8351'DB:business_master_new
loadtime:3.1344571113586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:3.1345269680023 / seconds
Query Executed:select id FROM `va` where city='Rowe' && SIC_code='8351'DB:business_master_new
loadtime:3.1349680423737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:3.1350219249725 / seconds
Query Executed:select id FROM `va` where city='Ruby' && SIC_code='8351'DB:business_master_new
loadtime:3.1354930400848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruckersville' limit 1
loadtime:3.1355500221252 / seconds
Query Executed:select id FROM `va` where city='Ruckersville' && SIC_code='8351'DB:business_master_new
loadtime:3.1425619125366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Retreat' limit 1
loadtime:3.1426439285278 / seconds
Query Executed:select id FROM `va` where city='Rural Retreat' && SIC_code='8351'DB:business_master_new
loadtime:3.1449019908905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rustburg' limit 1
loadtime:3.1449799537659 / seconds
Query Executed:select id FROM `va` where city='Rustburg' && SIC_code='8351'DB:business_master_new
loadtime:3.1521399021149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruther Glen' limit 1
loadtime:3.152214050293 / seconds
Query Executed:select id FROM `va` where city='Ruther Glen' && SIC_code='8351'DB:business_master_new
loadtime:3.1557838916779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthville' limit 1
loadtime:3.1558799743652 / seconds
Query Executed:select id FROM `va` where city='Ruthville' && SIC_code='8351'DB:business_master_new
loadtime:3.1563971042633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:3.1564559936523 / seconds
Query Executed:select id FROM `va` where city='Saint Charles' && SIC_code='8351'DB:business_master_new
loadtime:3.1571280956268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:3.1571960449219 / seconds
Query Executed:select id FROM `va` where city='Saint Paul' && SIC_code='8351'DB:business_master_new
loadtime:3.1590468883514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens Church' limit 1
loadtime:3.1591029167175 / seconds
Query Executed:select id FROM `va` where city='Saint Stephens Church' && SIC_code='8351'DB:business_master_new
loadtime:3.1599380970001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:3.1599910259247 / seconds
Query Executed:select id FROM `va` where city='Salem' && SIC_code='8351'DB:business_master_new
loadtime:3.1855330467224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltville' limit 1
loadtime:3.1856451034546 / seconds
Query Executed:select id FROM `va` where city='Saltville' && SIC_code='8351'DB:business_master_new
loadtime:3.1880879402161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:3.1881659030914 / seconds
Query Executed:select id FROM `va` where city='Saluda' && SIC_code='8351'DB:business_master_new
loadtime:3.1908569335938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandston' limit 1
loadtime:3.1909260749817 / seconds
Query Executed:select id FROM `va` where city='Sandston' && SIC_code='8351'DB:business_master_new
loadtime:3.1995389461517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:3.1996359825134 / seconds
Query Executed:select id FROM `va` where city='Sandy Hook' && SIC_code='8351'DB:business_master_new
loadtime:3.2002799510956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Level' limit 1
loadtime:3.2003409862518 / seconds
Query Executed:select id FROM `va` where city='Sandy Level' && SIC_code='8351'DB:business_master_new
loadtime:3.2009110450745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Point' limit 1
loadtime:3.2009699344635 / seconds
Query Executed:select id FROM `va` where city='Sandy Point' && SIC_code='8351'DB:business_master_new
loadtime:3.2014210224152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:3.201474905014 / seconds
Query Executed:select id FROM `va` where city='Sanford' && SIC_code='8351'DB:business_master_new
loadtime:3.2019801139832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxe' limit 1
loadtime:3.2020449638367 / seconds
Query Executed:select id FROM `va` where city='Saxe' && SIC_code='8351'DB:business_master_new
loadtime:3.2026600837708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxis' limit 1
loadtime:3.2027220726013 / seconds
Query Executed:select id FROM `va` where city='Saxis' && SIC_code='8351'DB:business_master_new
loadtime:3.2032930850983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schley' limit 1
loadtime:3.203360080719 / seconds
Query Executed:select id FROM `va` where city='Schley' && SIC_code='8351'DB:business_master_new
loadtime:3.2038168907166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schuyler' limit 1
loadtime:3.2038788795471 / seconds
Query Executed:select id FROM `va` where city='Schuyler' && SIC_code='8351'DB:business_master_new
loadtime:3.2046639919281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:3.2047159671783 / seconds
Query Executed:select id FROM `va` where city='Scottsburg' && SIC_code='8351'DB:business_master_new
loadtime:3.2059619426727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsville' limit 1
loadtime:3.2060151100159 / seconds
Query Executed:select id FROM `va` where city='Scottsville' && SIC_code='8351'DB:business_master_new
loadtime:3.2094120979309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaford' limit 1
loadtime:3.2094819545746 / seconds
Query Executed:select id FROM `va` where city='Seaford' && SIC_code='8351'DB:business_master_new
loadtime:3.2110838890076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealston' limit 1
loadtime:3.2111570835114 / seconds
Query Executed:select id FROM `va` where city='Sealston' && SIC_code='8351'DB:business_master_new
loadtime:3.2115659713745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:3.2116219997406 / seconds
Query Executed:select id FROM `va` where city='Seaview' && SIC_code='8351'DB:business_master_new
loadtime:3.2120189666748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedley' limit 1
loadtime:3.2120890617371 / seconds
Query Executed:select id FROM `va` where city='Sedley' && SIC_code='8351'DB:business_master_new
loadtime:3.2129991054535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:3.2130570411682 / seconds
Query Executed:select id FROM `va` where city='Selma' && SIC_code='8351'DB:business_master_new
loadtime:3.2135779857635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Corners' limit 1
loadtime:3.2136330604553 / seconds
Query Executed:select id FROM `va` where city='Seven Corners' && SIC_code='8351'DB:business_master_new
loadtime:3.2140419483185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Mile Ford' limit 1
loadtime:3.214103937149 / seconds
Query Executed:select id FROM `va` where city='Seven Mile Ford' && SIC_code='8351'DB:business_master_new
loadtime:3.2144870758057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:3.2145431041718 / seconds
Query Executed:select id FROM `va` where city='Severn' && SIC_code='8351'DB:business_master_new
loadtime:3.214940071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shacklefords' limit 1
loadtime:3.2149939537048 / seconds
Query Executed:select id FROM `va` where city='Shacklefords' && SIC_code='8351'DB:business_master_new
loadtime:3.2158470153809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharps' limit 1
loadtime:3.2159070968628 / seconds
Query Executed:select id FROM `va` where city='Sharps' && SIC_code='8351'DB:business_master_new
loadtime:3.2163970470428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawsville' limit 1
loadtime:3.2164559364319 / seconds
Query Executed:select id FROM `va` where city='Shawsville' && SIC_code='8351'DB:business_master_new
loadtime:3.2178089618683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:3.217885017395 / seconds
Query Executed:select id FROM `va` where city='Shelby' && SIC_code='8351'DB:business_master_new
loadtime:3.21830701828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:3.2183699607849 / seconds
Query Executed:select id FROM `va` where city='Shenandoah' && SIC_code='8351'DB:business_master_new
loadtime:3.2207779884338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Cvrns' limit 1
loadtime:3.2208449840546 / seconds
Query Executed:select id FROM `va` where city='Shenandoah Cvrns' && SIC_code='8351'DB:business_master_new
loadtime:3.2212910652161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherando' limit 1
loadtime:3.2213521003723 / seconds
Query Executed:select id FROM `va` where city='Sherando' && SIC_code='8351'DB:business_master_new
loadtime:3.2217860221863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:3.2218370437622 / seconds
Query Executed:select id FROM `va` where city='Shiloh' && SIC_code='8351'DB:business_master_new
loadtime:3.2222650051117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shipman' limit 1
loadtime:3.2223229408264 / seconds
Query Executed:select id FROM `va` where city='Shipman' && SIC_code='8351'DB:business_master_new
loadtime:3.2231929302216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shortt Gap' limit 1
loadtime:3.223249912262 / seconds
Query Executed:select id FROM `va` where city='Shortt Gap' && SIC_code='8351'DB:business_master_new
loadtime:3.223620891571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Singers Glen' limit 1
loadtime:3.2236790657043 / seconds
Query Executed:select id FROM `va` where city='Singers Glen' && SIC_code='8351'DB:business_master_new
loadtime:3.224319934845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skippers' limit 1
loadtime:3.2243800163269 / seconds
Query Executed:select id FROM `va` where city='Skippers' && SIC_code='8351'DB:business_master_new
loadtime:3.2251451015472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipwith' limit 1
loadtime:3.2252058982849 / seconds
Query Executed:select id FROM `va` where city='Skipwith' && SIC_code='8351'DB:business_master_new
loadtime:3.2259719371796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:3.2260239124298 / seconds
Query Executed:select id FROM `va` where city='Smithfield' && SIC_code='8351'DB:business_master_new
loadtime:3.2363939285278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snell' limit 1
loadtime:3.2364790439606 / seconds
Query Executed:select id FROM `va` where city='Snell' && SIC_code='8351'DB:business_master_new
loadtime:3.236841917038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:3.2369060516357 / seconds
Query Executed:select id FROM `va` where city='Somerset' && SIC_code='8351'DB:business_master_new
loadtime:3.237489938736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:3.2375419139862 / seconds
Query Executed:select id FROM `va` where city='Somerville' && SIC_code='8351'DB:business_master_new
loadtime:3.2379229068756 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:3.2379810810089 / seconds
Query Executed:select id FROM `va` where city='South Boston' && SIC_code='8351'DB:business_master_new
loadtime:3.2521810531616 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hill' limit 1
loadtime:3.2522609233856 / seconds
Query Executed:select id FROM `va` where city='South Hill' && SIC_code='8351'DB:business_master_new
loadtime:3.2622549533844 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Riding' limit 1
loadtime:3.2623279094696 / seconds
Query Executed:select id FROM `va` where city='South Riding' && SIC_code='8351'DB:business_master_new
loadtime:3.2627909183502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:3.2628428936005 / seconds
Query Executed:select id FROM `va` where city='Sparta' && SIC_code='8351'DB:business_master_new
loadtime:3.2633099555969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speedwell' limit 1
loadtime:3.2633759975433 / seconds
Query Executed:select id FROM `va` where city='Speedwell' && SIC_code='8351'DB:business_master_new
loadtime:3.264014005661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:3.2640740871429 / seconds
Query Executed:select id FROM `va` where city='Spencer' && SIC_code='8351'DB:business_master_new
loadtime:3.2652220726013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperryville' limit 1
loadtime:3.2652959823608 / seconds
Query Executed:select id FROM `va` where city='Sperryville' && SIC_code='8351'DB:business_master_new
loadtime:3.266674041748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotsylvania' limit 1
loadtime:3.2667319774628 / seconds
Query Executed:select id FROM `va` where city='Spotsylvania' && SIC_code='8351'DB:business_master_new
loadtime:3.2792809009552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spout Spring' limit 1
loadtime:3.2793629169464 / seconds
Query Executed:select id FROM `va` where city='Spout Spring' && SIC_code='8351'DB:business_master_new
loadtime:3.2802500724792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Grove' limit 1
loadtime:3.2803130149841 / seconds
Query Executed:select id FROM `va` where city='Spring Grove' && SIC_code='8351'DB:business_master_new
loadtime:3.2810881137848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:3.2811551094055 / seconds
Query Executed:select id FROM `va` where city='Springfield' && SIC_code='8351'DB:business_master_new
loadtime:3.3345930576324 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:3.3347990512848 / seconds
Query Executed:select id FROM `va` where city='St Charles' && SIC_code='8351'DB:business_master_new
loadtime:3.3352830410004 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:3.3353478908539 / seconds
Query Executed:select id FROM `va` where city='St Paul' && SIC_code='8351'DB:business_master_new
loadtime:3.3357539176941 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens Chr' limit 1
loadtime:3.3358159065247 / seconds
Query Executed:select id FROM `va` where city='St Stephens Chr' && SIC_code='8351'DB:business_master_new
loadtime:3.336217880249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:3.3362720012665 / seconds
Query Executed:select id FROM `va` where city='Stafford' && SIC_code='8351'DB:business_master_new
loadtime:3.3611850738525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordsville' limit 1
loadtime:3.3613049983978 / seconds
Query Executed:select id FROM `va` where city='Staffordsville' && SIC_code='8351'DB:business_master_new
loadtime:3.3617739677429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanardsville' limit 1
loadtime:3.3618450164795 / seconds
Query Executed:select id FROM `va` where city='Stanardsville' && SIC_code='8351'DB:business_master_new
loadtime:3.3649580478668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:3.3650269508362 / seconds
Query Executed:select id FROM `va` where city='Stanley' && SIC_code='8351'DB:business_master_new
loadtime:3.3676779270172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanleytown' limit 1
loadtime:3.3677589893341 / seconds
Query Executed:select id FROM `va` where city='Stanleytown' && SIC_code='8351'DB:business_master_new
loadtime:3.3686060905457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Tannery' limit 1
loadtime:3.3686790466309 / seconds
Query Executed:select id FROM `va` where city='Star Tannery' && SIC_code='8351'DB:business_master_new
loadtime:3.3692789077759 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Farm' limit 1
loadtime:3.3693399429321 / seconds
Query Executed:select id FROM `va` where city='State Farm' && SIC_code='8351'DB:business_master_new
loadtime:3.3698110580444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staunton' limit 1
loadtime:3.3698759078979 / seconds
Query Executed:select id FROM `va` where city='Staunton' && SIC_code='8351'DB:business_master_new
loadtime:3.393748998642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steeles Tavern' limit 1
loadtime:3.3938550949097 / seconds
Query Executed:select id FROM `va` where city='Steeles Tavern' && SIC_code='8351'DB:business_master_new
loadtime:3.394406080246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephens City' limit 1
loadtime:3.3944699764252 / seconds
Query Executed:select id FROM `va` where city='Stephens City' && SIC_code='8351'DB:business_master_new
loadtime:3.4023420810699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:3.4024269580841 / seconds
Query Executed:select id FROM `va` where city='Stephenson' && SIC_code='8351'DB:business_master_new
loadtime:3.4035470485687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:3.4036018848419 / seconds
Query Executed:select id FROM `va` where city='Sterling' && SIC_code='8351'DB:business_master_new
loadtime:3.4542329311371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensburg' limit 1
loadtime:3.4544351100922 / seconds
Query Executed:select id FROM `va` where city='Stevensburg' && SIC_code='8351'DB:business_master_new
loadtime:3.4550089836121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:3.455090045929 / seconds
Query Executed:select id FROM `va` where city='Stevensville' && SIC_code='8351'DB:business_master_new
loadtime:3.4555261135101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Ridge' limit 1
loadtime:3.4555780887604 / seconds
Query Executed:select id FROM `va` where city='Stone Ridge' && SIC_code='8351'DB:business_master_new
loadtime:3.4559578895569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonega' limit 1
loadtime:3.4560170173645 / seconds
Query Executed:select id FROM `va` where city='Stonega' && SIC_code='8351'DB:business_master_new
loadtime:3.4563920497894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Creek' limit 1
loadtime:3.4564459323883 / seconds
Query Executed:select id FROM `va` where city='Stony Creek' && SIC_code='8351'DB:business_master_new
loadtime:3.458025932312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:3.4580988883972 / seconds
Query Executed:select id FROM `va` where city='Strasburg' && SIC_code='8351'DB:business_master_new
loadtime:3.4906148910522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:3.4907040596008 / seconds
Query Executed:select id FROM `va` where city='Stratford' && SIC_code='8351'DB:business_master_new
loadtime:3.4911620616913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:3.4912259578705 / seconds
Query Executed:select id FROM `va` where city='Stuart' && SIC_code='8351'DB:business_master_new
loadtime:3.4991359710693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuarts Draft' limit 1
loadtime:3.4992210865021 / seconds
Query Executed:select id FROM `va` where city='Stuarts Draft' && SIC_code='8351'DB:business_master_new
loadtime:3.5035429000854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:3.5036220550537 / seconds
Query Executed:select id FROM `va` where city='Studley' && SIC_code='8351'DB:business_master_new
loadtime:3.5041909217834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffolk' limit 1
loadtime:3.5042560100555 / seconds
Query Executed:select id FROM `va` where city='Suffolk' && SIC_code='8351'DB:business_master_new
loadtime:3.5353300571442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:3.5354549884796 / seconds
Query Executed:select id FROM `va` where city='Sugar Grove' && SIC_code='8351'DB:business_master_new
loadtime:3.5362849235535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerduck' limit 1
loadtime:3.5363500118256 / seconds
Query Executed:select id FROM `va` where city='Sumerduck' && SIC_code='8351'DB:business_master_new
loadtime:3.5372869968414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:3.5373458862305 / seconds
Query Executed:select id FROM `va` where city='Supply' && SIC_code='8351'DB:business_master_new
loadtime:3.5377280712128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:3.5377850532532 / seconds
Query Executed:select id FROM `va` where city='Surry' && SIC_code='8351'DB:business_master_new
loadtime:3.5398070812225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susan' limit 1
loadtime:3.5398879051208 / seconds
Query Executed:select id FROM `va` where city='Susan' && SIC_code='8351'DB:business_master_new
loadtime:3.5403549671173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:3.5404160022736 / seconds
Query Executed:select id FROM `va` where city='Sussex' && SIC_code='8351'DB:business_master_new
loadtime:3.5409879684448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:3.5410521030426 / seconds
Query Executed:select id FROM `va` where city='Sutherland' && SIC_code='8351'DB:business_master_new
loadtime:3.5422511100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:3.5423219203949 / seconds
Query Executed:select id FROM `va` where city='Sutherlin' && SIC_code='8351'DB:business_master_new
loadtime:3.5432550907135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Briar' limit 1
loadtime:3.5433139801025 / seconds
Query Executed:select id FROM `va` where city='Sweet Briar' && SIC_code='8351'DB:business_master_new
loadtime:3.5438089370728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swoope' limit 1
loadtime:3.543881893158 / seconds
Query Executed:select id FROM `va` where city='Swoope' && SIC_code='8351'DB:business_master_new
loadtime:3.5447800159454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swords Creek' limit 1
loadtime:3.54483294487 / seconds
Query Executed:select id FROM `va` where city='Swords Creek' && SIC_code='8351'DB:business_master_new
loadtime:3.5456318855286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syria' limit 1
loadtime:3.5456941127777 / seconds
Query Executed:select id FROM `va` where city='Syria' && SIC_code='8351'DB:business_master_new
loadtime:3.5462300777435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syringa' limit 1
loadtime:3.5462880134583 / seconds
Query Executed:select id FROM `va` where city='Syringa' && SIC_code='8351'DB:business_master_new
loadtime:3.5467369556427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabb' limit 1
loadtime:3.5467920303345 / seconds
Query Executed:select id FROM `va` where city='Tabb' && SIC_code='8351'DB:business_master_new
loadtime:3.5473539829254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangier' limit 1
loadtime:3.5474119186401 / seconds
Query Executed:select id FROM `va` where city='Tangier' && SIC_code='8351'DB:business_master_new
loadtime:3.5481300354004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tannersville' limit 1
loadtime:3.548182964325 / seconds
Query Executed:select id FROM `va` where city='Tannersville' && SIC_code='8351'DB:business_master_new
loadtime:3.5486168861389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tappahannock' limit 1
loadtime:3.548672914505 / seconds
Query Executed:select id FROM `va` where city='Tappahannock' && SIC_code='8351'DB:business_master_new
loadtime:3.5553789138794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tasley' limit 1
loadtime:3.5554709434509 / seconds
Query Executed:select id FROM `va` where city='Tasley' && SIC_code='8351'DB:business_master_new
loadtime:3.5563468933105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tazewell' limit 1
loadtime:3.5564050674438 / seconds
Query Executed:select id FROM `va` where city='Tazewell' && SIC_code='8351'DB:business_master_new
loadtime:3.5610399246216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperanceville' limit 1
loadtime:3.5611081123352 / seconds
Query Executed:select id FROM `va` where city='Temperanceville' && SIC_code='8351'DB:business_master_new
loadtime:3.5619750022888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:3.5620288848877 / seconds
Query Executed:select id FROM `va` where city='Thaxton' && SIC_code='8351'DB:business_master_new
loadtime:3.5630970001221 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Plains' limit 1
loadtime:3.5631499290466 / seconds
Query Executed:select id FROM `va` where city='The Plains' && SIC_code='8351'DB:business_master_new
loadtime:3.5651340484619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:3.5652010440826 / seconds
Query Executed:select id FROM `va` where city='Thornburg' && SIC_code='8351'DB:business_master_new
loadtime:3.5660429000854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberville' limit 1
loadtime:3.5661029815674 / seconds
Query Executed:select id FROM `va` where city='Timberville' && SIC_code='8351'DB:business_master_new
loadtime:3.5683269500732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toano' limit 1
loadtime:3.5683829784393 / seconds
Query Executed:select id FROM `va` where city='Toano' && SIC_code='8351'DB:business_master_new
loadtime:3.5712630748749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms Brook' limit 1
loadtime:3.5713350772858 / seconds
Query Executed:select id FROM `va` where city='Toms Brook' && SIC_code='8351'DB:business_master_new
loadtime:3.5725779533386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topping' limit 1
loadtime:3.5726470947266 / seconds
Query Executed:select id FROM `va` where city='Topping' && SIC_code='8351'DB:business_master_new
loadtime:3.5738010406494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:3.5738549232483 / seconds
Query Executed:select id FROM `va` where city='Townsend' && SIC_code='8351'DB:business_master_new
loadtime:3.5743870735168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trammel' limit 1
loadtime:3.5744469165802 / seconds
Query Executed:select id FROM `va` where city='Trammel' && SIC_code='8351'DB:business_master_new
loadtime:3.5748999118805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevilians' limit 1
loadtime:3.5749580860138 / seconds
Query Executed:select id FROM `va` where city='Trevilians' && SIC_code='8351'DB:business_master_new
loadtime:3.5754380226135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triangle' limit 1
loadtime:3.5754909515381 / seconds
Query Executed:select id FROM `va` where city='Triangle' && SIC_code='8351'DB:business_master_new
loadtime:3.5783898830414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triplet' limit 1
loadtime:3.5784730911255 / seconds
Query Executed:select id FROM `va` where city='Triplet' && SIC_code='8351'DB:business_master_new
loadtime:3.5788860321045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Dale' limit 1
loadtime:3.5789480209351 / seconds
Query Executed:select id FROM `va` where city='Trout Dale' && SIC_code='8351'DB:business_master_new
loadtime:3.5793540477753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:3.5794069766998 / seconds
Query Executed:select id FROM `va` where city='Troutdale' && SIC_code='8351'DB:business_master_new
loadtime:3.5802080631256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutville' limit 1
loadtime:3.5802710056305 / seconds
Query Executed:select id FROM `va` where city='Troutville' && SIC_code='8351'DB:business_master_new
loadtime:3.5841190814972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:3.5841860771179 / seconds
Query Executed:select id FROM `va` where city='Troy' && SIC_code='8351'DB:business_master_new
loadtime:3.5861949920654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:3.5862638950348 / seconds
Query Executed:select id FROM `va` where city='Turbeville' && SIC_code='8351'DB:business_master_new
loadtime:3.5866470336914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:3.5866990089417 / seconds
Query Executed:select id FROM `va` where city='Tyro' && SIC_code='8351'DB:business_master_new
loadtime:3.587189912796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Hall' limit 1
loadtime:3.5872480869293 / seconds
Query Executed:select id FROM `va` where city='Union Hall' && SIC_code='8351'DB:business_master_new
loadtime:3.5883100032806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:3.5883619785309 / seconds
Query Executed:select id FROM `va` where city='Unionville' && SIC_code='8351'DB:business_master_new
loadtime:3.5895819664001 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Of Richmond' limit 1
loadtime:3.589663028717 / seconds
Query Executed:select id FROM `va` where city='University Of Richmond' && SIC_code='8351'DB:business_master_new
loadtime:3.5900979042053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperville' limit 1
loadtime:3.5901579856873 / seconds
Query Executed:select id FROM `va` where city='Upperville' && SIC_code='8351'DB:business_master_new
loadtime:3.5914900302887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbanna' limit 1
loadtime:3.5915639400482 / seconds
Query Executed:select id FROM `va` where city='Urbanna' && SIC_code='8351'DB:business_master_new
loadtime:3.5937728881836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentines' limit 1
loadtime:3.5938510894775 / seconds
Query Executed:select id FROM `va` where city='Valentines' && SIC_code='8351'DB:business_master_new
loadtime:3.5944530963898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vansant' limit 1
loadtime:3.5945219993591 / seconds
Query Executed:select id FROM `va` where city='Vansant' && SIC_code='8351'DB:business_master_new
loadtime:3.5964620113373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Hill' limit 1
loadtime:3.596519947052 / seconds
Query Executed:select id FROM `va` where city='Vernon Hill' && SIC_code='8351'DB:business_master_new
loadtime:3.5971839427948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:3.5972371101379 / seconds
Query Executed:select id FROM `va` where city='Verona' && SIC_code='8351'DB:business_master_new
loadtime:3.6008770465851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesta' limit 1
loadtime:3.6009590625763 / seconds
Query Executed:select id FROM `va` where city='Vesta' && SIC_code='8351'DB:business_master_new
loadtime:3.6014530658722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesuvius' limit 1
loadtime:3.6015179157257 / seconds
Query Executed:select id FROM `va` where city='Vesuvius' && SIC_code='8351'DB:business_master_new
loadtime:3.6021449565887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:3.6022040843964 / seconds
Query Executed:select id FROM `va` where city='Victoria' && SIC_code='8351'DB:business_master_new
loadtime:3.6043269634247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:3.6043970584869 / seconds
Query Executed:select id FROM `va` where city='Vienna' && SIC_code='8351'DB:business_master_new
loadtime:3.6609199047089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viewtown' limit 1
loadtime:3.6611490249634 / seconds
Query Executed:select id FROM `va` where city='Viewtown' && SIC_code='8351'DB:business_master_new
loadtime:3.6616570949554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village' limit 1
loadtime:3.6617269515991 / seconds
Query Executed:select id FROM `va` where city='Village' && SIC_code='8351'DB:business_master_new
loadtime:3.6622440814972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villamont' limit 1
loadtime:3.6623048782349 / seconds
Query Executed:select id FROM `va` where city='Villamont' && SIC_code='8351'DB:business_master_new
loadtime:3.6626839637756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vint Hill Farms' limit 1
loadtime:3.662740945816 / seconds
Query Executed:select id FROM `va` where city='Vint Hill Farms' && SIC_code='8351'DB:business_master_new
loadtime:3.6631140708923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:3.6631679534912 / seconds
Query Executed:select id FROM `va` where city='Vinton' && SIC_code='8351'DB:business_master_new
loadtime:3.6750779151917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgilina' limit 1
loadtime:3.6751620769501 / seconds
Query Executed:select id FROM `va` where city='Virgilina' && SIC_code='8351'DB:business_master_new
loadtime:3.6763510704041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virginia Beach' limit 1
loadtime:3.6764140129089 / seconds
Query Executed:select id FROM `va` where city='Virginia Beach' && SIC_code='8351'DB:business_master_new
loadtime:3.7088379859924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wachapreague' limit 1
loadtime:3.709312915802 / seconds
Query Executed:select id FROM `va` where city='Wachapreague' && SIC_code='8351'DB:business_master_new
loadtime:3.7101368904114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake' limit 1
loadtime:3.7102160453796 / seconds
Query Executed:select id FROM `va` where city='Wake' && SIC_code='8351'DB:business_master_new
loadtime:3.7106919288635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:3.7107439041138 / seconds
Query Executed:select id FROM `va` where city='Wakefield' && SIC_code='8351'DB:business_master_new
loadtime:3.7123420238495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerton' limit 1
loadtime:3.7124021053314 / seconds
Query Executed:select id FROM `va` where city='Walkerton' && SIC_code='8351'DB:business_master_new
loadtime:3.7130699157715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallops Island' limit 1
loadtime:3.7131478786469 / seconds
Query Executed:select id FROM `va` where city='Wallops Island' && SIC_code='8351'DB:business_master_new
loadtime:3.713947057724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walters' limit 1
loadtime:3.7140231132507 / seconds
Query Executed:select id FROM `va` where city='Walters' && SIC_code='8351'DB:business_master_new
loadtime:3.7144570350647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardtown' limit 1
loadtime:3.7145149707794 / seconds
Query Executed:select id FROM `va` where city='Wardtown' && SIC_code='8351'DB:business_master_new
loadtime:3.7149379253387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Neck' limit 1
loadtime:3.7150030136108 / seconds
Query Executed:select id FROM `va` where city='Ware Neck' && SIC_code='8351'DB:business_master_new
loadtime:3.715528011322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warfield' limit 1
loadtime:3.7155849933624 / seconds
Query Executed:select id FROM `va` where city='Warfield' && SIC_code='8351'DB:business_master_new
loadtime:3.7162261009216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:3.716285943985 / seconds
Query Executed:select id FROM `va` where city='Warm Springs' && SIC_code='8351'DB:business_master_new
loadtime:3.7174160480499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:3.7174689769745 / seconds
Query Executed:select id FROM `va` where city='Warner' && SIC_code='8351'DB:business_master_new
loadtime:3.7178790569305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:3.7179319858551 / seconds
Query Executed:select id FROM `va` where city='Warrenton' && SIC_code='8351'DB:business_master_new
loadtime:3.742635011673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:3.7427430152893 / seconds
Query Executed:select id FROM `va` where city='Warsaw' && SIC_code='8351'DB:business_master_new
loadtime:3.7502861022949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:3.7503690719604 / seconds
Query Executed:select id FROM `va` where city='Washington' && SIC_code='8351'DB:business_master_new
loadtime:3.7526938915253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water View' limit 1
loadtime:3.7527670860291 / seconds
Query Executed:select id FROM `va` where city='Water View' && SIC_code='8351'DB:business_master_new
loadtime:3.7532269954681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:3.7532820701599 / seconds
Query Executed:select id FROM `va` where city='Waterford' && SIC_code='8351'DB:business_master_new
loadtime:3.7545249462128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:3.7545909881592 / seconds
Query Executed:select id FROM `va` where city='Wattsville' && SIC_code='8351'DB:business_master_new
loadtime:3.7550420761108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:3.7550959587097 / seconds
Query Executed:select id FROM `va` where city='Waverly' && SIC_code='8351'DB:business_master_new
loadtime:3.7573900222778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:3.7574560642242 / seconds
Query Executed:select id FROM `va` where city='Waynesboro' && SIC_code='8351'DB:business_master_new
loadtime:3.7748050689697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weber City' limit 1
loadtime:3.7749030590057 / seconds
Query Executed:select id FROM `va` where city='Weber City' && SIC_code='8351'DB:business_master_new
loadtime:3.7768120765686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weems' limit 1
loadtime:3.7769019603729 / seconds
Query Executed:select id FROM `va` where city='Weems' && SIC_code='8351'DB:business_master_new
loadtime:3.7779099941254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirwood' limit 1
loadtime:3.7779879570007 / seconds
Query Executed:select id FROM `va` where city='Weirwood' && SIC_code='8351'DB:business_master_new
loadtime:3.7784099578857 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Augusta' limit 1
loadtime:3.7784690856934 / seconds
Query Executed:select id FROM `va` where city='West Augusta' && SIC_code='8351'DB:business_master_new
loadtime:3.7789421081543 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mclean' limit 1
loadtime:3.7790069580078 / seconds
Query Executed:select id FROM `va` where city='West Mclean' && SIC_code='8351'DB:business_master_new
loadtime:3.7796969413757 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:3.7797501087189 / seconds
Query Executed:select id FROM `va` where city='West Point' && SIC_code='8351'DB:business_master_new
loadtime:3.7834079265594 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:3.7834889888763 / seconds
Query Executed:select id FROM `va` where city='West Springfield' && SIC_code='8351'DB:business_master_new
loadtime:3.783921957016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:3.7839770317078 / seconds
Query Executed:select id FROM `va` where city='Westmoreland' && SIC_code='8351'DB:business_master_new
loadtime:3.7843968868256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyers Cave' limit 1
loadtime:3.7844569683075 / seconds
Query Executed:select id FROM `va` where city='Weyers Cave' && SIC_code='8351'DB:business_master_new
loadtime:3.7864360809326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitacre' limit 1
loadtime:3.7865030765533 / seconds
Query Executed:select id FROM `va` where city='Whitacre' && SIC_code='8351'DB:business_master_new
loadtime:3.7869229316711 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Hall' limit 1
loadtime:3.7869780063629 / seconds
Query Executed:select id FROM `va` where city='White Hall' && SIC_code='8351'DB:business_master_new
loadtime:3.7874510288239 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Marsh' limit 1
loadtime:3.7875158786774 / seconds
Query Executed:select id FROM `va` where city='White Marsh' && SIC_code='8351'DB:business_master_new
loadtime:3.7885909080505 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:3.7886440753937 / seconds
Query Executed:select id FROM `va` where city='White Plains' && SIC_code='8351'DB:business_master_new
loadtime:3.7891290187836 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Post' limit 1
loadtime:3.7891891002655 / seconds
Query Executed:select id FROM `va` where city='White Post' && SIC_code='8351'DB:business_master_new
loadtime:3.7904160022736 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:3.7904698848724 / seconds
Query Executed:select id FROM `va` where city='White Stone' && SIC_code='8351'DB:business_master_new
loadtime:3.7929248809814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitetop' limit 1
loadtime:3.7929880619049 / seconds
Query Executed:select id FROM `va` where city='Whitetop' && SIC_code='8351'DB:business_master_new
loadtime:3.7935988903046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:3.793653011322 / seconds
Query Executed:select id FROM `va` where city='Whitewood' && SIC_code='8351'DB:business_master_new
loadtime:3.7941679954529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico' limit 1
loadtime:3.7942290306091 / seconds
Query Executed:select id FROM `va` where city='Wicomico' && SIC_code='8351'DB:business_master_new
loadtime:3.7947640419006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico Church' limit 1
loadtime:3.7948350906372 / seconds
Query Executed:select id FROM `va` where city='Wicomico Church' && SIC_code='8351'DB:business_master_new
loadtime:3.7954659461975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:3.795520067215 / seconds
Query Executed:select id FROM `va` where city='Williamsburg' && SIC_code='8351'DB:business_master_new
loadtime:3.8384099006653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:3.8385479450226 / seconds
Query Executed:select id FROM `va` where city='Williamsville' && SIC_code='8351'DB:business_master_new
loadtime:3.8391470909119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:3.8392128944397 / seconds
Query Executed:select id FROM `va` where city='Willis' && SIC_code='8351'DB:business_master_new
loadtime:3.8404800891876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis Wharf' limit 1
loadtime:3.8405389785767 / seconds
Query Executed:select id FROM `va` where city='Willis Wharf' && SIC_code='8351'DB:business_master_new
loadtime:3.8410229682922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons' limit 1
loadtime:3.8410940170288 / seconds
Query Executed:select id FROM `va` where city='Wilsons' && SIC_code='8351'DB:business_master_new
loadtime:3.8415670394897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:3.84161901474 / seconds
Query Executed:select id FROM `va` where city='Winchester' && SIC_code='8351'DB:business_master_new
loadtime:3.883749961853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:3.8839008808136 / seconds
Query Executed:select id FROM `va` where city='Windsor' && SIC_code='8351'DB:business_master_new
loadtime:3.8869380950928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingina' limit 1
loadtime:3.8870220184326 / seconds
Query Executed:select id FROM `va` where city='Wingina' && SIC_code='8351'DB:business_master_new
loadtime:3.8875360488892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wintergreen' limit 1
loadtime:3.8875980377197 / seconds
Query Executed:select id FROM `va` where city='Wintergreen' && SIC_code='8351'DB:business_master_new
loadtime:3.8880579471588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wirtz' limit 1
loadtime:3.8881170749664 / seconds
Query Executed:select id FROM `va` where city='Wirtz' && SIC_code='8351'DB:business_master_new
loadtime:3.8904008865356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:3.8904690742493 / seconds
Query Executed:select id FROM `va` where city='Wise' && SIC_code='8351'DB:business_master_new
loadtime:3.896420955658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withams' limit 1
loadtime:3.8965039253235 / seconds
Query Executed:select id FROM `va` where city='Withams' && SIC_code='8351'DB:business_master_new
loadtime:3.8969879150391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolford' limit 1
loadtime:3.8970530033112 / seconds
Query Executed:select id FROM `va` where city='Wolford' && SIC_code='8351'DB:business_master_new
loadtime:3.8975238800049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolftown' limit 1
loadtime:3.8975811004639 / seconds
Query Executed:select id FROM `va` where city='Wolftown' && SIC_code='8351'DB:business_master_new
loadtime:3.8981959819794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodberry Forest' limit 1
loadtime:3.8982539176941 / seconds
Query Executed:select id FROM `va` where city='Woodberry Forest' && SIC_code='8351'DB:business_master_new
loadtime:3.8986549377441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:3.8987069129944 / seconds
Query Executed:select id FROM `va` where city='Woodbridge' && SIC_code='8351'DB:business_master_new
loadtime:3.9600570201874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:3.9603500366211 / seconds
Query Executed:select id FROM `va` where city='Woodford' && SIC_code='8351'DB:business_master_new
loadtime:3.9620800018311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodlawn' limit 1
loadtime:3.9621601104736 / seconds
Query Executed:select id FROM `va` where city='Woodlawn' && SIC_code='8351'DB:business_master_new
loadtime:3.963907957077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Rds' limit 1
loadtime:3.9639880657196 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Rds' && SIC_code='8351'DB:business_master_new
loadtime:3.9643828868866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Roads' limit 1
loadtime:3.9644460678101 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Roads' && SIC_code='8351'DB:business_master_new
loadtime:3.9649090766907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:3.9649620056152 / seconds
Query Executed:select id FROM `va` where city='Woodstock' && SIC_code='8351'DB:business_master_new
loadtime:3.9719231128693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:3.9720020294189 / seconds
Query Executed:select id FROM `va` where city='Woodville' && SIC_code='8351'DB:business_master_new
loadtime:3.9726889133453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolwine' limit 1
loadtime:3.972757101059 / seconds
Query Executed:select id FROM `va` where city='Woolwine' && SIC_code='8351'DB:business_master_new
loadtime:3.9735779762268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wylliesburg' limit 1
loadtime:3.9736421108246 / seconds
Query Executed:select id FROM `va` where city='Wylliesburg' && SIC_code='8351'DB:business_master_new
loadtime:3.9743149280548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wytheville' limit 1
loadtime:3.9743759632111 / seconds
Query Executed:select id FROM `va` where city='Wytheville' && SIC_code='8351'DB:business_master_new
loadtime:3.9882569313049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:3.9883320331573 / seconds
Query Executed:select id FROM `va` where city='Yale' && SIC_code='8351'DB:business_master_new
loadtime:3.9889860153198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:3.9890520572662 / seconds
Query Executed:select id FROM `va` where city='Yorktown' && SIC_code='8351'DB:business_master_new
loadtime:4.0118319988251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zacata' limit 1
loadtime:4.0119619369507 / seconds
Query Executed:select id FROM `va` where city='Zacata' && SIC_code='8351'DB:business_master_new
loadtime:4.0124380588531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zanoni' limit 1
loadtime:4.0124979019165 / seconds
Query Executed:select id FROM `va` where city='Zanoni' && SIC_code='8351'DB:business_master_new
loadtime:4.0130379199982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:4.0130910873413 / seconds
Query Executed:select id FROM `va` where city='Zuni' && SIC_code='8351'DB:business_master_new
loadtime:4.0141470432281 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:4.0142951011658 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:4.0148389339447 / seconds
Operation template executed (chunk cache operation)
loadtime:4.0150148868561 / seconds
template override:Default
loadtime:4.0150640010834 / 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:4.0166881084442 / seconds
Template Constructed, Array Rows:49
loadtime:4.017245054245 / seconds
TOTAL EXECUTION TIME: 4.01678
loadtime:4.020359992981 / 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] => child-day-care-services [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:4.0203709602356
TOTAL KEY ARRAYS: 69