Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.6069107055664E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018231868743896 / seconds
host not found setting manual db connection
loadtime:0.0095810890197754 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0098199844360352 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010071992874146 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.01014518737793 / seconds
zipcode:
loadtime:0.010173082351685 / seconds
Query Executed:select * from search_referrer where page_hash='46606a3ac2d60ff0c80e8c5173d0754d' limit 10 DB:ezrox_toadli
loadtime:0.010465145111084 / seconds
Operation header executed (non global)
loadtime:0.010493993759155 / seconds
Operation leaderboard executed (non global)
loadtime:0.010545969009399 / seconds
Operation square executed (non global)
loadtime:0.01057505607605 / seconds
Operation square_bottom executed (non global)
loadtime:0.010603189468384 / seconds
Operation smallsquare executed (non global)
loadtime:0.01062798500061 / seconds
Operation headeradright executed (non global)
loadtime:0.010653018951416 / seconds
Operation google_analytics executed (non global)
loadtime:0.010688066482544 / seconds
Operation topstories executed (non global)
loadtime:0.010717153549194 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010745048522949 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010770082473755 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011033058166504 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011219024658203 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011254072189331 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011312961578369 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011360168457031 / seconds
Template key: archive_menu pushed
loadtime:0.011368989944458 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011382102966309 / seconds
Template key: get_gravatar pushed
loadtime:0.011389017105103 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011398077011108 / seconds
*10)-10)+1 | start:0
loadtime:0.011438131332397 / seconds
Query loaded from cache:select * from categories where cat_URLid='religious-organizations'
loadtime:0.011478185653687 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.011514186859131 / seconds
DB connected to localhost business_master_new
loadtime:0.01179313659668 / seconds
Query Executed:select * from `va_catmap` where sic='8661' order by city ascDB:business_master_new
loadtime:0.042781114578247 / seconds
Query stored in cache : _QUERY_www.toadli.come8129c53d333b96536d12d9c82237f71
loadtime:0.046525001525879 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.046604156494141 / seconds
Query Executed:select sum(totalcount) as totalsum from `va_catmap` where sic='8661'DB:business_master_new
loadtime:0.051338195800781 / seconds
Query stored in cache : _QUERY_www.toadli.comaa42ee0b1340a3a6f6dac4851f3207ef
loadtime:0.051390171051025 / seconds
942 / 11
loadtime:0.05146312713623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abingdon' limit 1
loadtime:0.051551103591919 / seconds
Query Executed:select id FROM `va` where city='Abingdon' && SIC_code='8661'DB:business_master_new
loadtime:0.20704913139343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accomac' limit 1
loadtime:0.20731616020203 / seconds
Query Executed:select id FROM `va` where city='Accomac' && SIC_code='8661'DB:business_master_new
loadtime:0.20957708358765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Achilles' limit 1
loadtime:0.20967698097229 / seconds
Query Executed:select id FROM `va` where city='Achilles' && SIC_code='8661'DB:business_master_new
loadtime:0.210205078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.21027398109436 / seconds
Query Executed:select id FROM `va` where city='Afton' && SIC_code='8661'DB:business_master_new
loadtime:0.21220707893372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alberta' limit 1
loadtime:0.21229100227356 / seconds
Query Executed:select id FROM `va` where city='Alberta' && SIC_code='8661'DB:business_master_new
loadtime:0.21332907676697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aldie' limit 1
loadtime:0.2134051322937 / seconds
Query Executed:select id FROM `va` where city='Aldie' && SIC_code='8661'DB:business_master_new
loadtime:0.21553897857666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.21561312675476 / seconds
Query Executed:select id FROM `va` where city='Alexandria' && SIC_code='8661'DB:business_master_new
loadtime:0.39201998710632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleghany' limit 1
loadtime:0.39263105392456 / seconds
Query Executed:select id FROM `va` where city='Alleghany' && SIC_code='8661'DB:business_master_new
loadtime:0.39318704605103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allisonia' limit 1
loadtime:0.39328217506409 / seconds
Query Executed:select id FROM `va` where city='Allisonia' && SIC_code='8661'DB:business_master_new
loadtime:0.39369416236877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altavista' limit 1
loadtime:0.39374709129333 / seconds
Query Executed:select id FROM `va` where city='Altavista' && SIC_code='8661'DB:business_master_new
loadtime:0.39821910858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.39833402633667 / seconds
Query Executed:select id FROM `va` where city='Alton' && SIC_code='8661'DB:business_master_new
loadtime:0.39937615394592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Ridge' limit 1
loadtime:0.3994619846344 / seconds
Query Executed:select id FROM `va` where city='Alum Ridge' && SIC_code='8661'DB:business_master_new
loadtime:0.39987111091614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court House' limit 1
loadtime:0.39992713928223 / seconds
Query Executed:select id FROM `va` where city='Amelia Court House' && SIC_code='8661'DB:business_master_new
loadtime:0.40563702583313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court Hse' limit 1
loadtime:0.4057731628418 / seconds
Query Executed:select id FROM `va` where city='Amelia Court Hse' && SIC_code='8661'DB:business_master_new
loadtime:0.40642499923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.40650606155396 / seconds
Query Executed:select id FROM `va` where city='Amherst' && SIC_code='8661'DB:business_master_new
loadtime:0.41215205192566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amissville' limit 1
loadtime:0.41227698326111 / seconds
Query Executed:select id FROM `va` where city='Amissville' && SIC_code='8661'DB:business_master_new
loadtime:0.41454601287842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ammon' limit 1
loadtime:0.41463017463684 / seconds
Query Executed:select id FROM `va` where city='Ammon' && SIC_code='8661'DB:business_master_new
loadtime:0.41506600379944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amonate' limit 1
loadtime:0.41512107849121 / seconds
Query Executed:select id FROM `va` where city='Amonate' && SIC_code='8661'DB:business_master_new
loadtime:0.41557598114014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.41562819480896 / seconds
Query Executed:select id FROM `va` where city='Andover' && SIC_code='8661'DB:business_master_new
loadtime:0.41614603996277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.41620302200317 / seconds
Query Executed:select id FROM `va` where city='Annandale' && SIC_code='8661'DB:business_master_new
loadtime:0.45619606971741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appalachia' limit 1
loadtime:0.45640015602112 / seconds
Query Executed:select id FROM `va` where city='Appalachia' && SIC_code='8661'DB:business_master_new
loadtime:0.45791602134705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appomattox' limit 1
loadtime:0.45801615715027 / seconds
Query Executed:select id FROM `va` where city='Appomattox' && SIC_code='8661'DB:business_master_new
loadtime:0.46330213546753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.46343016624451 / seconds
Query Executed:select id FROM `va` where city='Ararat' && SIC_code='8661'DB:business_master_new
loadtime:0.46464419364929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.46472501754761 / seconds
Query Executed:select id FROM `va` where city='Arcola' && SIC_code='8661'DB:business_master_new
loadtime:0.46538496017456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ark' limit 1
loadtime:0.4654541015625 / seconds
Query Executed:select id FROM `va` where city='Ark' && SIC_code='8661'DB:business_master_new
loadtime:0.46605515480042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.46612405776978 / seconds
Query Executed:select id FROM `va` where city='Arlington' && SIC_code='8661'DB:business_master_new
loadtime:0.58635401725769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aroda' limit 1
loadtime:0.58676409721375 / seconds
Query Executed:select id FROM `va` where city='Aroda' && SIC_code='8661'DB:business_master_new
loadtime:0.5875141620636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrington' limit 1
loadtime:0.58760213851929 / seconds
Query Executed:select id FROM `va` where city='Arrington' && SIC_code='8661'DB:business_master_new
loadtime:0.58881211280823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvonia' limit 1
loadtime:0.58890604972839 / seconds
Query Executed:select id FROM `va` where city='Arvonia' && SIC_code='8661'DB:business_master_new
loadtime:0.58958411216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburn' limit 1
loadtime:0.58966112136841 / seconds
Query Executed:select id FROM `va` where city='Ashburn' && SIC_code='8661'DB:business_master_new
loadtime:0.61737012863159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.61748814582825 / seconds
Query Executed:select id FROM `va` where city='Ashland' && SIC_code='8661'DB:business_master_new
loadtime:0.64643502235413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assawoman' limit 1
loadtime:0.64657306671143 / seconds
Query Executed:select id FROM `va` where city='Assawoman' && SIC_code='8661'DB:business_master_new
loadtime:0.64699602127075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.64705514907837 / seconds
Query Executed:select id FROM `va` where city='Atkins' && SIC_code='8661'DB:business_master_new
loadtime:0.64823007583618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.64830899238586 / seconds
Query Executed:select id FROM `va` where city='Atlantic' && SIC_code='8661'DB:business_master_new
loadtime:0.64901399612427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta Springs' limit 1
loadtime:0.64908504486084 / seconds
Query Executed:select id FROM `va` where city='Augusta Springs' && SIC_code='8661'DB:business_master_new
loadtime:0.64948701858521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.64955496788025 / seconds
Query Executed:select id FROM `va` where city='Austinville' && SIC_code='8661'DB:business_master_new
loadtime:0.65053701400757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axton' limit 1
loadtime:0.65061211585999 / seconds
Query Executed:select id FROM `va` where city='Axton' && SIC_code='8661'DB:business_master_new
loadtime:0.65282607078552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aylett' limit 1
loadtime:0.65293502807617 / seconds
Query Executed:select id FROM `va` where city='Aylett' && SIC_code='8661'DB:business_master_new
loadtime:0.65513300895691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bacova' limit 1
loadtime:0.65521001815796 / seconds
Query Executed:select id FROM `va` where city='Bacova' && SIC_code='8661'DB:business_master_new
loadtime:0.65563607215881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Crossrds' limit 1
loadtime:0.65569019317627 / seconds
Query Executed:select id FROM `va` where city='Baileys Crossrds' && SIC_code='8661'DB:business_master_new
loadtime:0.65617704391479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banco' limit 1
loadtime:0.65623116493225 / seconds
Query Executed:select id FROM `va` where city='Banco' && SIC_code='8661'DB:business_master_new
loadtime:0.65665316581726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bandy' limit 1
loadtime:0.65670919418335 / seconds
Query Executed:select id FROM `va` where city='Bandy' && SIC_code='8661'DB:business_master_new
loadtime:0.65719413757324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barboursville' limit 1
loadtime:0.65726399421692 / seconds
Query Executed:select id FROM `va` where city='Barboursville' && SIC_code='8661'DB:business_master_new
loadtime:0.65891098976135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barhamsville' limit 1
loadtime:0.65899395942688 / seconds
Query Executed:select id FROM `va` where city='Barhamsville' && SIC_code='8661'DB:business_master_new
loadtime:0.6598060131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barren Springs' limit 1
loadtime:0.65987515449524 / seconds
Query Executed:select id FROM `va` where city='Barren Springs' && SIC_code='8661'DB:business_master_new
loadtime:0.66036701202393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baskerville' limit 1
loadtime:0.66042113304138 / seconds
Query Executed:select id FROM `va` where city='Baskerville' && SIC_code='8661'DB:business_master_new
loadtime:0.6610951423645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.66116404533386 / seconds
Query Executed:select id FROM `va` where city='Bassett' && SIC_code='8661'DB:business_master_new
loadtime:0.66692614555359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bastian' limit 1
loadtime:0.66707706451416 / seconds
Query Executed:select id FROM `va` where city='Bastian' && SIC_code='8661'DB:business_master_new
loadtime:0.66790509223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basye' limit 1
loadtime:0.66798710823059 / seconds
Query Executed:select id FROM `va` where city='Basye' && SIC_code='8661'DB:business_master_new
loadtime:0.6690411567688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.66911911964417 / seconds
Query Executed:select id FROM `va` where city='Batesville' && SIC_code='8661'DB:business_master_new
loadtime:0.66965198516846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battery Park' limit 1
loadtime:0.66971898078918 / seconds
Query Executed:select id FROM `va` where city='Battery Park' && SIC_code='8661'DB:business_master_new
loadtime:0.6701819896698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bavon' limit 1
loadtime:0.67023611068726 / seconds
Query Executed:select id FROM `va` where city='Bavon' && SIC_code='8661'DB:business_master_new
loadtime:0.67063117027283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bealeton' limit 1
loadtime:0.67068314552307 / seconds
Query Executed:select id FROM `va` where city='Bealeton' && SIC_code='8661'DB:business_master_new
loadtime:0.67395615577698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.67405200004578 / seconds
Query Executed:select id FROM `va` where city='Beaumont' && SIC_code='8661'DB:business_master_new
loadtime:0.67445707321167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverdam' limit 1
loadtime:0.67451310157776 / seconds
Query Executed:select id FROM `va` where city='Beaverdam' && SIC_code='8661'DB:business_master_new
loadtime:0.67619109153748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverlett' limit 1
loadtime:0.67627906799316 / seconds
Query Executed:select id FROM `va` where city='Beaverlett' && SIC_code='8661'DB:business_master_new
loadtime:0.67665815353394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.6767270565033 / seconds
Query Executed:select id FROM `va` where city='Bedford' && SIC_code='8661'DB:business_master_new
loadtime:0.81445407867432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bee' limit 1
loadtime:0.81470417976379 / seconds
Query Executed:select id FROM `va` where city='Bee' && SIC_code='8661'DB:business_master_new
loadtime:0.81524801254272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellamy' limit 1
loadtime:0.81531310081482 / seconds
Query Executed:select id FROM `va` where city='Bellamy' && SIC_code='8661'DB:business_master_new
loadtime:0.81568503379822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Haven' limit 1
loadtime:0.81573700904846 / seconds
Query Executed:select id FROM `va` where city='Belle Haven' && SIC_code='8661'DB:business_master_new
loadtime:0.81714916229248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belspring' limit 1
loadtime:0.81722617149353 / seconds
Query Executed:select id FROM `va` where city='Belspring' && SIC_code='8661'DB:business_master_new
loadtime:0.81767416000366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ben Hur' limit 1
loadtime:0.81774115562439 / seconds
Query Executed:select id FROM `va` where city='Ben Hur' && SIC_code='8661'DB:business_master_new
loadtime:0.81821703910828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bena' limit 1
loadtime:0.81827211380005 / seconds
Query Executed:select id FROM `va` where city='Bena' && SIC_code='8661'DB:business_master_new
loadtime:0.81885814666748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent Mountain' limit 1
loadtime:0.81892609596252 / seconds
Query Executed:select id FROM `va` where city='Bent Mountain' && SIC_code='8661'DB:business_master_new
loadtime:0.81983804702759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonville' limit 1
loadtime:0.81991004943848 / seconds
Query Executed:select id FROM `va` where city='Bentonville' && SIC_code='8661'DB:business_master_new
loadtime:0.82106399536133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergton' limit 1
loadtime:0.82113409042358 / seconds
Query Executed:select id FROM `va` where city='Bergton' && SIC_code='8661'DB:business_master_new
loadtime:0.82171297073364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berryville' limit 1
loadtime:0.82177901268005 / seconds
Query Executed:select id FROM `va` where city='Berryville' && SIC_code='8661'DB:business_master_new
loadtime:0.82747101783752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Island' limit 1
loadtime:0.8275671005249 / seconds
Query Executed:select id FROM `va` where city='Big Island' && SIC_code='8661'DB:business_master_new
loadtime:0.82857918739319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.82866215705872 / seconds
Query Executed:select id FROM `va` where city='Big Rock' && SIC_code='8661'DB:business_master_new
loadtime:0.82947015762329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone Gap' limit 1
loadtime:0.82954216003418 / seconds
Query Executed:select id FROM `va` where city='Big Stone Gap' && SIC_code='8661'DB:business_master_new
loadtime:0.83461308479309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchleaf' limit 1
loadtime:0.83472418785095 / seconds
Query Executed:select id FROM `va` where city='Birchleaf' && SIC_code='8661'DB:business_master_new
loadtime:0.83531618118286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birdsnest' limit 1
loadtime:0.83538603782654 / seconds
Query Executed:select id FROM `va` where city='Birdsnest' && SIC_code='8661'DB:business_master_new
loadtime:0.83596110343933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishop' limit 1
loadtime:0.83602905273438 / seconds
Query Executed:select id FROM `va` where city='Bishop' && SIC_code='8661'DB:business_master_new
loadtime:0.83653616905212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackridge' limit 1
loadtime:0.83660197257996 / seconds
Query Executed:select id FROM `va` where city='Blackridge' && SIC_code='8661'DB:business_master_new
loadtime:0.8370840549469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.83715009689331 / seconds
Query Executed:select id FROM `va` where city='Blacksburg' && SIC_code='8661'DB:business_master_new
loadtime:0.86664605140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.86684203147888 / seconds
Query Executed:select id FROM `va` where city='Blackstone' && SIC_code='8661'DB:business_master_new
loadtime:0.87151098251343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwater' limit 1
loadtime:0.87164711952209 / seconds
Query Executed:select id FROM `va` where city='Blackwater' && SIC_code='8661'DB:business_master_new
loadtime:0.87223196029663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairs' limit 1
loadtime:0.87229204177856 / seconds
Query Executed:select id FROM `va` where city='Blairs' && SIC_code='8661'DB:business_master_new
loadtime:0.87393617630005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakes' limit 1
loadtime:0.87401604652405 / seconds
Query Executed:select id FROM `va` where city='Blakes' && SIC_code='8661'DB:business_master_new
loadtime:0.8744170665741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bland' limit 1
loadtime:0.87447118759155 / seconds
Query Executed:select id FROM `va` where city='Bland' && SIC_code='8661'DB:business_master_new
loadtime:0.87634015083313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloxom' limit 1
loadtime:0.87641501426697 / seconds
Query Executed:select id FROM `va` where city='Bloxom' && SIC_code='8661'DB:business_master_new
loadtime:0.87723207473755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.87730598449707 / seconds
Query Executed:select id FROM `va` where city='Blue Grass' && SIC_code='8661'DB:business_master_new
loadtime:0.87801718711853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Ridge' limit 1
loadtime:0.87808299064636 / seconds
Query Executed:select id FROM `va` where city='Blue Ridge' && SIC_code='8661'DB:business_master_new
loadtime:0.88002014160156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:0.88010311126709 / seconds
Query Executed:select id FROM `va` where city='Bluefield' && SIC_code='8661'DB:business_master_new
loadtime:1.016587972641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluemont' limit 1
loadtime:1.0167610645294 / seconds
Query Executed:select id FROM `va` where city='Bluemont' && SIC_code='8661'DB:business_master_new
loadtime:1.0185511112213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bohannon' limit 1
loadtime:1.018627166748 / seconds
Query Executed:select id FROM `va` where city='Bohannon' && SIC_code='8661'DB:business_master_new
loadtime:1.0190641880035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boissevain' limit 1
loadtime:1.0191311836243 / seconds
Query Executed:select id FROM `va` where city='Boissevain' && SIC_code='8661'DB:business_master_new
loadtime:1.0196180343628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolar' limit 1
loadtime:1.019690990448 / seconds
Query Executed:select id FROM `va` where city='Bolar' && SIC_code='8661'DB:business_master_new
loadtime:1.0200681686401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:1.0201230049133 / seconds
Query Executed:select id FROM `va` where city='Bon Air' && SIC_code='8661'DB:business_master_new
loadtime:1.0208630561829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boones Mill' limit 1
loadtime:1.0209159851074 / seconds
Query Executed:select id FROM `va` where city='Boones Mill' && SIC_code='8661'DB:business_master_new
loadtime:1.0238490104675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:1.0239441394806 / seconds
Query Executed:select id FROM `va` where city='Boston' && SIC_code='8661'DB:business_master_new
loadtime:1.0246460437775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:1.024717092514 / seconds
Query Executed:select id FROM `va` where city='Bowling Green' && SIC_code='8661'DB:business_master_new
loadtime:1.0276560783386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyce' limit 1
loadtime:1.0277390480042 / seconds
Query Executed:select id FROM `va` where city='Boyce' && SIC_code='8661'DB:business_master_new
loadtime:1.0293200016022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boydton' limit 1
loadtime:1.0293991565704 / seconds
Query Executed:select id FROM `va` where city='Boydton' && SIC_code='8661'DB:business_master_new
loadtime:1.0312850475311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykins' limit 1
loadtime:1.031378030777 / seconds
Query Executed:select id FROM `va` where city='Boykins' && SIC_code='8661'DB:business_master_new
loadtime:1.0324959754944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bracey' limit 1
loadtime:1.0325820446014 / seconds
Query Executed:select id FROM `va` where city='Bracey' && SIC_code='8661'DB:business_master_new
loadtime:1.0343379974365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:1.0344130992889 / seconds
Query Executed:select id FROM `va` where city='Branchville' && SIC_code='8661'DB:business_master_new
loadtime:1.035012960434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandy Station' limit 1
loadtime:1.0350821018219 / seconds
Query Executed:select id FROM `va` where city='Brandy Station' && SIC_code='8661'DB:business_master_new
loadtime:1.0361511707306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breaks' limit 1
loadtime:1.0362260341644 / seconds
Query Executed:select id FROM `va` where city='Breaks' && SIC_code='8661'DB:business_master_new
loadtime:1.0367250442505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremo Bluff' limit 1
loadtime:1.0368030071259 / seconds
Query Executed:select id FROM `va` where city='Bremo Bluff' && SIC_code='8661'DB:business_master_new
loadtime:1.0373480319977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:1.0374159812927 / seconds
Query Executed:select id FROM `va` where city='Bridgewater' && SIC_code='8661'DB:business_master_new
loadtime:1.0409359931946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:1.0410389900208 / seconds
Query Executed:select id FROM `va` where city='Brightwood' && SIC_code='8661'DB:business_master_new
loadtime:1.0417051315308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:1.0417740345001 / seconds
Query Executed:select id FROM `va` where city='Bristol' && SIC_code='8661'DB:business_master_new
loadtime:1.0693299770355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:1.0695359706879 / seconds
Query Executed:select id FROM `va` where city='Bristow' && SIC_code='8661'DB:business_master_new
loadtime:1.0729839801788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Run' limit 1
loadtime:1.0730769634247 / seconds
Query Executed:select id FROM `va` where city='Broad Run' && SIC_code='8661'DB:business_master_new
loadtime:1.0742661952972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadford' limit 1
loadtime:1.0743370056152 / seconds
Query Executed:select id FROM `va` where city='Broadford' && SIC_code='8661'DB:business_master_new
loadtime:1.0747699737549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:1.0748310089111 / seconds
Query Executed:select id FROM `va` where city='Broadway' && SIC_code='8661'DB:business_master_new
loadtime:1.0785820484161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodnax' limit 1
loadtime:1.0786809921265 / seconds
Query Executed:select id FROM `va` where city='Brodnax' && SIC_code='8661'DB:business_master_new
loadtime:1.080099105835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooke' limit 1
loadtime:1.080185174942 / seconds
Query Executed:select id FROM `va` where city='Brooke' && SIC_code='8661'DB:business_master_new
loadtime:1.0806260108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookneal' limit 1
loadtime:1.0806920528412 / seconds
Query Executed:select id FROM `va` where city='Brookneal' && SIC_code='8661'DB:business_master_new
loadtime:1.0834879875183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsburg' limit 1
loadtime:1.0835950374603 / seconds
Query Executed:select id FROM `va` where city='Brownsburg' && SIC_code='8661'DB:business_master_new
loadtime:1.0840721130371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brucetown' limit 1
loadtime:1.0841290950775 / seconds
Query Executed:select id FROM `va` where city='Brucetown' && SIC_code='8661'DB:business_master_new
loadtime:1.0845229625702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruington' limit 1
loadtime:1.0845739841461 / seconds
Query Executed:select id FROM `va` where city='Bruington' && SIC_code='8661'DB:business_master_new
loadtime:1.0850510597229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:1.0851190090179 / seconds
Query Executed:select id FROM `va` where city='Buchanan' && SIC_code='8661'DB:business_master_new
loadtime:1.0877251625061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:1.0878260135651 / seconds
Query Executed:select id FROM `va` where city='Buckingham' && SIC_code='8661'DB:business_master_new
loadtime:1.0893290042877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:1.0894241333008 / seconds
Query Executed:select id FROM `va` where city='Buena Vista' && SIC_code='8661'DB:business_master_new
loadtime:1.0935649871826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Junction' limit 1
loadtime:1.093682050705 / seconds
Query Executed:select id FROM `va` where city='Buffalo Junction' && SIC_code='8661'DB:business_master_new
loadtime:1.0947420597076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bumpass' limit 1
loadtime:1.0948300361633 / seconds
Query Executed:select id FROM `va` where city='Bumpass' && SIC_code='8661'DB:business_master_new
loadtime:1.0967071056366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgess' limit 1
loadtime:1.0968000888824 / seconds
Query Executed:select id FROM `va` where city='Burgess' && SIC_code='8661'DB:business_master_new
loadtime:1.0981509685516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:1.0982251167297 / seconds
Query Executed:select id FROM `va` where city='Burke' && SIC_code='8661'DB:business_master_new
loadtime:1.1239411830902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkes Garden' limit 1
loadtime:1.1240711212158 / seconds
Query Executed:select id FROM `va` where city='Burkes Garden' && SIC_code='8661'DB:business_master_new
loadtime:1.1245360374451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkeville' limit 1
loadtime:1.124605178833 / seconds
Query Executed:select id FROM `va` where city='Burkeville' && SIC_code='8661'DB:business_master_new
loadtime:1.126079082489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:1.1261651515961 / seconds
Query Executed:select id FROM `va` where city='Burnsville' && SIC_code='8661'DB:business_master_new
loadtime:1.126631975174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Hill' limit 1
loadtime:1.1266989707947 / seconds
Query Executed:select id FROM `va` where city='Burr Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.1272079944611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callands' limit 1
loadtime:1.1272671222687 / seconds
Query Executed:select id FROM `va` where city='Callands' && SIC_code='8661'DB:business_master_new
loadtime:1.128014087677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callao' limit 1
loadtime:1.1280810832977 / seconds
Query Executed:select id FROM `va` where city='Callao' && SIC_code='8661'DB:business_master_new
loadtime:1.130380153656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callaway' limit 1
loadtime:1.1304590702057 / seconds
Query Executed:select id FROM `va` where city='Callaway' && SIC_code='8661'DB:business_master_new
loadtime:1.1314890384674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calverton' limit 1
loadtime:1.1315681934357 / seconds
Query Executed:select id FROM `va` where city='Calverton' && SIC_code='8661'DB:business_master_new
loadtime:1.1323499679565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cana' limit 1
loadtime:1.1324210166931 / seconds
Query Executed:select id FROM `va` where city='Cana' && SIC_code='8661'DB:business_master_new
loadtime:1.1340861320496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Charles' limit 1
loadtime:1.1341691017151 / seconds
Query Executed:select id FROM `va` where city='Cape Charles' && SIC_code='8661'DB:business_master_new
loadtime:1.137540102005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capeville' limit 1
loadtime:1.1376371383667 / seconds
Query Executed:select id FROM `va` where city='Capeville' && SIC_code='8661'DB:business_master_new
loadtime:1.1381030082703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capron' limit 1
loadtime:1.1381721496582 / seconds
Query Executed:select id FROM `va` where city='Capron' && SIC_code='8661'DB:business_master_new
loadtime:1.1392290592194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardinal' limit 1
loadtime:1.1393041610718 / seconds
Query Executed:select id FROM `va` where city='Cardinal' && SIC_code='8661'DB:business_master_new
loadtime:1.1398060321808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caret' limit 1
loadtime:1.1398601531982 / seconds
Query Executed:select id FROM `va` where city='Caret' && SIC_code='8661'DB:business_master_new
loadtime:1.1403391361237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:1.1404101848602 / seconds
Query Executed:select id FROM `va` where city='Carrollton' && SIC_code='8661'DB:business_master_new
loadtime:1.1428751945496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrsville' limit 1
loadtime:1.142961025238 / seconds
Query Executed:select id FROM `va` where city='Carrsville' && SIC_code='8661'DB:business_master_new
loadtime:1.1438150405884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:1.1438870429993 / seconds
Query Executed:select id FROM `va` where city='Carson' && SIC_code='8661'DB:business_master_new
loadtime:1.144711971283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cartersville' limit 1
loadtime:1.1447920799255 / seconds
Query Executed:select id FROM `va` where city='Cartersville' && SIC_code='8661'DB:business_master_new
loadtime:1.145632982254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casanova' limit 1
loadtime:1.1457080841064 / seconds
Query Executed:select id FROM `va` where city='Casanova' && SIC_code='8661'DB:business_master_new
loadtime:1.146252155304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:1.1463220119476 / seconds
Query Executed:select id FROM `va` where city='Cascade' && SIC_code='8661'DB:business_master_new
loadtime:1.1471660137177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:1.147243976593 / seconds
Query Executed:select id FROM `va` where city='Castleton' && SIC_code='8661'DB:business_master_new
loadtime:1.1479451656342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:1.1480190753937 / seconds
Query Executed:select id FROM `va` where city='Castlewood' && SIC_code='8661'DB:business_master_new
loadtime:1.1497721672058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:1.1498560905457 / seconds
Query Executed:select id FROM `va` where city='Catawba' && SIC_code='8661'DB:business_master_new
loadtime:1.1506230831146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharpin' limit 1
loadtime:1.1506931781769 / seconds
Query Executed:select id FROM `va` where city='Catharpin' && SIC_code='8661'DB:business_master_new
loadtime:1.1518561840057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catlett' limit 1
loadtime:1.1519260406494 / seconds
Query Executed:select id FROM `va` where city='Catlett' && SIC_code='8661'DB:business_master_new
loadtime:1.1541090011597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:1.1542010307312 / seconds
Query Executed:select id FROM `va` where city='Cedar Bluff' && SIC_code='8661'DB:business_master_new
loadtime:1.1574041843414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Cross' limit 1
loadtime:1.1575000286102 / seconds
Query Executed:select id FROM `va` where city='Center Cross' && SIC_code='8661'DB:business_master_new
loadtime:1.158194065094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:1.1582741737366 / seconds
Query Executed:select id FROM `va` where city='Centreville' && SIC_code='8661'DB:business_master_new
loadtime:1.1892170906067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceres' limit 1
loadtime:1.1893570423126 / seconds
Query Executed:select id FROM `va` where city='Ceres' && SIC_code='8661'DB:business_master_new
loadtime:1.1899201869965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champlain' limit 1
loadtime:1.1899981498718 / seconds
Query Executed:select id FROM `va` where city='Champlain' && SIC_code='8661'DB:business_master_new
loadtime:1.1905961036682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chantilly' limit 1
loadtime:1.1906640529633 / seconds
Query Executed:select id FROM `va` where city='Chantilly' && SIC_code='8661'DB:business_master_new
loadtime:1.2297630310059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:1.229917049408 / seconds
Query Executed:select id FROM `va` where city='Charles City' && SIC_code='8661'DB:business_master_new
loadtime:1.233011007309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Court House' limit 1
loadtime:1.2331101894379 / seconds
Query Executed:select id FROM `va` where city='Charlotte Court House' && SIC_code='8661'DB:business_master_new
loadtime:1.2346279621124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Ct Hse' limit 1
loadtime:1.2347011566162 / seconds
Query Executed:select id FROM `va` where city='Charlotte Ct Hse' && SIC_code='8661'DB:business_master_new
loadtime:1.2354390621185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlottesville' limit 1
loadtime:1.2355151176453 / seconds
Query Executed:select id FROM `va` where city='Charlottesville' && SIC_code='8661'DB:business_master_new
loadtime:1.3273141384125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase City' limit 1
loadtime:1.3277471065521 / seconds
Query Executed:select id FROM `va` where city='Chase City' && SIC_code='8661'DB:business_master_new
loadtime:1.3317041397095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.3318591117859 / seconds
Query Executed:select id FROM `va` where city='Chatham' && SIC_code='8661'DB:business_master_new
loadtime:1.337366104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Check' limit 1
loadtime:1.3375120162964 / seconds
Query Executed:select id FROM `va` where city='Check' && SIC_code='8661'DB:business_master_new
loadtime:1.3383400440216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheriton' limit 1
loadtime:1.3384130001068 / seconds
Query Executed:select id FROM `va` where city='Cheriton' && SIC_code='8661'DB:business_master_new
loadtime:1.3395121097565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesapeake' limit 1
loadtime:1.3395869731903 / seconds
Query Executed:select id FROM `va` where city='Chesapeake' && SIC_code='8661'DB:business_master_new
loadtime:1.4473659992218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.4481270313263 / seconds
Query Executed:select id FROM `va` where city='Chester' && SIC_code='8661'DB:business_master_new
loadtime:1.5858631134033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester Gap' limit 1
loadtime:1.5861520767212 / seconds
Query Executed:select id FROM `va` where city='Chester Gap' && SIC_code='8661'DB:business_master_new
loadtime:1.5867481231689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.5868291854858 / seconds
Query Executed:select id FROM `va` where city='Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:1.7255799770355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilhowie' limit 1
loadtime:1.7258110046387 / seconds
Query Executed:select id FROM `va` where city='Chilhowie' && SIC_code='8661'DB:business_master_new
loadtime:1.7290079593658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague' limit 1
loadtime:1.7291321754456 / seconds
Query Executed:select id FROM `va` where city='Chincoteague' && SIC_code='8661'DB:business_master_new
loadtime:1.7298340797424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague Island' limit 1
loadtime:1.7298929691315 / seconds
Query Executed:select id FROM `va` where city='Chincoteague Island' && SIC_code='8661'DB:business_master_new
loadtime:1.7339630126953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christchurch' limit 1
loadtime:1.7340381145477 / seconds
Query Executed:select id FROM `va` where city='Christchurch' && SIC_code='8661'DB:business_master_new
loadtime:1.7344751358032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christiansburg' limit 1
loadtime:1.7345290184021 / seconds
Query Executed:select id FROM `va` where city='Christiansburg' && SIC_code='8661'DB:business_master_new
loadtime:1.8727560043335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Road' limit 1
loadtime:1.8730399608612 / seconds
Query Executed:select id FROM `va` where city='Church Road' && SIC_code='8661'DB:business_master_new
loadtime:1.8740601539612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church View' limit 1
loadtime:1.8741500377655 / seconds
Query Executed:select id FROM `va` where city='Church View' && SIC_code='8661'DB:business_master_new
loadtime:1.8747541904449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churchville' limit 1
loadtime:1.8748300075531 / seconds
Query Executed:select id FROM `va` where city='Churchville' && SIC_code='8661'DB:business_master_new
loadtime:1.876492023468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cismont' limit 1
loadtime:1.8765821456909 / seconds
Query Executed:select id FROM `va` where city='Cismont' && SIC_code='8661'DB:business_master_new
loadtime:1.8770501613617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:1.8771181106567 / seconds
Query Executed:select id FROM `va` where city='Claremont' && SIC_code='8661'DB:business_master_new
loadtime:1.8778371810913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:1.877925157547 / seconds
Query Executed:select id FROM `va` where city='Clarksville' && SIC_code='8661'DB:business_master_new
loadtime:1.882003068924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claudville' limit 1
loadtime:1.8821091651917 / seconds
Query Executed:select id FROM `va` where city='Claudville' && SIC_code='8661'DB:business_master_new
loadtime:1.8829669952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Brook' limit 1
loadtime:1.8830451965332 / seconds
Query Executed:select id FROM `va` where city='Clear Brook' && SIC_code='8661'DB:business_master_new
loadtime:1.8845269680023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:1.8846180438995 / seconds
Query Executed:select id FROM `va` where city='Cleveland' && SIC_code='8661'DB:business_master_new
loadtime:1.8854360580444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:1.8855140209198 / seconds
Query Executed:select id FROM `va` where city='Clifford' && SIC_code='8661'DB:business_master_new
loadtime:1.8859779834747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.8860511779785 / seconds
Query Executed:select id FROM `va` where city='Clifton' && SIC_code='8661'DB:business_master_new
loadtime:1.8921871185303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton Forge' limit 1
loadtime:1.89226603508 / seconds
Query Executed:select id FROM `va` where city='Clifton Forge' && SIC_code='8661'DB:business_master_new
loadtime:1.8956801891327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchco' limit 1
loadtime:1.8958201408386 / seconds
Query Executed:select id FROM `va` where city='Clinchco' && SIC_code='8661'DB:business_master_new
loadtime:1.8965690135956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchport' limit 1
loadtime:1.8966510295868 / seconds
Query Executed:select id FROM `va` where city='Clinchport' && SIC_code='8661'DB:business_master_new
loadtime:1.8971180915833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintwood' limit 1
loadtime:1.8971869945526 / seconds
Query Executed:select id FROM `va` where city='Clintwood' && SIC_code='8661'DB:business_master_new
loadtime:1.9004411697388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:1.9005241394043 / seconds
Query Executed:select id FROM `va` where city='Clover' && SIC_code='8661'DB:business_master_new
loadtime:1.9014000892639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:1.9014761447906 / seconds
Query Executed:select id FROM `va` where city='Cloverdale' && SIC_code='8661'DB:business_master_new
loadtime:1.9027299880981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cluster Springs' limit 1
loadtime:1.9028091430664 / seconds
Query Executed:select id FROM `va` where city='Cluster Springs' && SIC_code='8661'DB:business_master_new
loadtime:1.9031920433044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobbs Creek' limit 1
loadtime:1.9032580852509 / seconds
Query Executed:select id FROM `va` where city='Cobbs Creek' && SIC_code='8661'DB:business_master_new
loadtime:1.9040961265564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobham' limit 1
loadtime:1.9041721820831 / seconds
Query Executed:select id FROM `va` where city='Cobham' && SIC_code='8661'DB:business_master_new
loadtime:1.9045581817627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coeburn' limit 1
loadtime:1.9046230316162 / seconds
Query Executed:select id FROM `va` where city='Coeburn' && SIC_code='8661'DB:business_master_new
loadtime:1.908607006073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman Falls' limit 1
loadtime:1.9087131023407 / seconds
Query Executed:select id FROM `va` where city='Coleman Falls' && SIC_code='8661'DB:business_master_new
loadtime:1.909196138382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coles Point' limit 1
loadtime:1.9092540740967 / seconds
Query Executed:select id FROM `va` where city='Coles Point' && SIC_code='8661'DB:business_master_new
loadtime:1.9097280502319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:1.9097800254822 / seconds
Query Executed:select id FROM `va` where city='Collinsville' && SIC_code='8661'DB:business_master_new
loadtime:1.9146649837494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:1.9147760868073 / seconds
Query Executed:select id FROM `va` where city='Cologne' && SIC_code='8661'DB:business_master_new
loadtime:1.9151861667633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Beach' limit 1
loadtime:1.9152569770813 / seconds
Query Executed:select id FROM `va` where city='Colonial Beach' && SIC_code='8661'DB:business_master_new
loadtime:1.9195201396942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Heights' limit 1
loadtime:1.9196071624756 / seconds
Query Executed:select id FROM `va` where city='Colonial Heights' && SIC_code='8661'DB:business_master_new
loadtime:1.9456491470337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:1.9457991123199 / seconds
Query Executed:select id FROM `va` where city='Columbia' && SIC_code='8661'DB:business_master_new
loadtime:1.9466950893402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conaway' limit 1
loadtime:1.9467771053314 / seconds
Query Executed:select id FROM `va` where city='Conaway' && SIC_code='8661'DB:business_master_new
loadtime:1.9471740722656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:1.9472370147705 / seconds
Query Executed:select id FROM `va` where city='Concord' && SIC_code='8661'DB:business_master_new
loadtime:1.9489691257477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Hill' limit 1
loadtime:1.9490571022034 / seconds
Query Executed:select id FROM `va` where city='Copper Hill' && SIC_code='8661'DB:business_master_new
loadtime:1.9500060081482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin' limit 1
loadtime:1.9500789642334 / seconds
Query Executed:select id FROM `va` where city='Corbin' && SIC_code='8661'DB:business_master_new
loadtime:1.9505679607391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:1.9506211280823 / seconds
Query Executed:select id FROM `va` where city='Council' && SIC_code='8661'DB:business_master_new
loadtime:1.9510581493378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:1.9511120319366 / seconds
Query Executed:select id FROM `va` where city='Courtland' && SIC_code='8661'DB:business_master_new
loadtime:1.9537150859833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covesville' limit 1
loadtime:1.9538061618805 / seconds
Query Executed:select id FROM `va` where city='Covesville' && SIC_code='8661'DB:business_master_new
loadtime:1.9544641971588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:1.9545321464539 / seconds
Query Executed:select id FROM `va` where city='Covington' && SIC_code='8661'DB:business_master_new
loadtime:2.091744184494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craddockville' limit 1
loadtime:2.0920519828796 / seconds
Query Executed:select id FROM `va` where city='Craddockville' && SIC_code='8661'DB:business_master_new
loadtime:2.0926270484924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:2.0927040576935 / seconds
Query Executed:select id FROM `va` where city='Craigsville' && SIC_code='8661'DB:business_master_new
loadtime:2.0935690402985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crewe' limit 1
loadtime:2.0936441421509 / seconds
Query Executed:select id FROM `va` where city='Crewe' && SIC_code='8661'DB:business_master_new
loadtime:2.0967690944672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criders' limit 1
loadtime:2.0968840122223 / seconds
Query Executed:select id FROM `va` where city='Criders' && SIC_code='8661'DB:business_master_new
loadtime:2.097393989563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criglersville' limit 1
loadtime:2.0974760055542 / seconds
Query Executed:select id FROM `va` where city='Criglersville' && SIC_code='8661'DB:business_master_new
loadtime:2.0978741645813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crimora' limit 1
loadtime:2.0979290008545 / seconds
Query Executed:select id FROM `va` where city='Crimora' && SIC_code='8661'DB:business_master_new
loadtime:2.098806142807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:2.0988750457764 / seconds
Query Executed:select id FROM `va` where city='Cripple Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.0993111133575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Critz' limit 1
loadtime:2.0993649959564 / seconds
Query Executed:select id FROM `va` where city='Critz' && SIC_code='8661'DB:business_master_new
loadtime:2.0999541282654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crockett' limit 1
loadtime:2.1000289916992 / seconds
Query Executed:select id FROM `va` where city='Crockett' && SIC_code='8661'DB:business_master_new
loadtime:2.1006481647491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Junction' limit 1
loadtime:2.1007151603699 / seconds
Query Executed:select id FROM `va` where city='Cross Junction' && SIC_code='8661'DB:business_master_new
loadtime:2.1020851135254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozet' limit 1
loadtime:2.1021599769592 / seconds
Query Executed:select id FROM `va` where city='Crozet' && SIC_code='8661'DB:business_master_new
loadtime:2.1055791378021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozier' limit 1
loadtime:2.1056699752808 / seconds
Query Executed:select id FROM `va` where city='Crozier' && SIC_code='8661'DB:business_master_new
loadtime:2.1066479682922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Hill' limit 1
loadtime:2.106721162796 / seconds
Query Executed:select id FROM `va` where city='Crystal Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.1072130203247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullen' limit 1
loadtime:2.1072800159454 / seconds
Query Executed:select id FROM `va` where city='Cullen' && SIC_code='8661'DB:business_master_new
loadtime:2.1079070568085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culpeper' limit 1
loadtime:2.1079790592194 / seconds
Query Executed:select id FROM `va` where city='Culpeper' && SIC_code='8661'DB:business_master_new
loadtime:2.1348850727081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:2.1350581645966 / seconds
Query Executed:select id FROM `va` where city='Cumberland' && SIC_code='8661'DB:business_master_new
loadtime:2.1373341083527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dahlgren' limit 1
loadtime:2.137433052063 / seconds
Query Executed:select id FROM `va` where city='Dahlgren' && SIC_code='8661'DB:business_master_new
loadtime:2.1391541957855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale City' limit 1
loadtime:2.1392271518707 / seconds
Query Executed:select id FROM `va` where city='Dale City' && SIC_code='8661'DB:business_master_new
loadtime:2.1399731636047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:2.1400411128998 / seconds
Query Executed:select id FROM `va` where city='Daleville' && SIC_code='8661'DB:business_master_new
loadtime:2.1427049636841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:2.1428010463715 / seconds
Query Executed:select id FROM `va` where city='Damascus' && SIC_code='8661'DB:business_master_new
loadtime:2.1448340415955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:2.1449191570282 / seconds
Query Executed:select id FROM `va` where city='Dante' && SIC_code='8661'DB:business_master_new
loadtime:2.1455540657043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:2.1456241607666 / seconds
Query Executed:select id FROM `va` where city='Danville' && SIC_code='8661'DB:business_master_new
loadtime:2.1928780078888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington Hts' limit 1
loadtime:2.1934080123901 / seconds
Query Executed:select id FROM `va` where city='Darlington Hts' && SIC_code='8661'DB:business_master_new
loadtime:2.1938481330872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:2.1939330101013 / seconds
Query Executed:select id FROM `va` where city='Davenport' && SIC_code='8661'DB:business_master_new
loadtime:2.194461107254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Wharf' limit 1
loadtime:2.1945140361786 / seconds
Query Executed:select id FROM `va` where city='Davis Wharf' && SIC_code='8661'DB:business_master_new
loadtime:2.1949059963226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:2.1949641704559 / seconds
Query Executed:select id FROM `va` where city='Dayton' && SIC_code='8661'DB:business_master_new
loadtime:2.198429107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:2.1985239982605 / seconds
Query Executed:select id FROM `va` where city='Deerfield' && SIC_code='8661'DB:business_master_new
loadtime:2.199047088623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaplane' limit 1
loadtime:2.1991159915924 / seconds
Query Executed:select id FROM `va` where city='Delaplane' && SIC_code='8661'DB:business_master_new
loadtime:2.1999771595001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deltaville' limit 1
loadtime:2.2000501155853 / seconds
Query Executed:select id FROM `va` where city='Deltaville' && SIC_code='8661'DB:business_master_new
loadtime:2.2022910118103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dendron' limit 1
loadtime:2.2023639678955 / seconds
Query Executed:select id FROM `va` where city='Dendron' && SIC_code='8661'DB:business_master_new
loadtime:2.2030851840973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:2.2031610012054 / seconds
Query Executed:select id FROM `va` where city='Dewitt' && SIC_code='8661'DB:business_master_new
loadtime:2.2040581703186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diggs' limit 1
loadtime:2.2041239738464 / seconds
Query Executed:select id FROM `va` where city='Diggs' && SIC_code='8661'DB:business_master_new
loadtime:2.204537153244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillwyn' limit 1
loadtime:2.2046010494232 / seconds
Query Executed:select id FROM `va` where city='Dillwyn' && SIC_code='8661'DB:business_master_new
loadtime:2.2077431678772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinwiddie' limit 1
loadtime:2.207857131958 / seconds
Query Executed:select id FROM `va` where city='Dinwiddie' && SIC_code='8661'DB:business_master_new
loadtime:2.2101061344147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Disputanta' limit 1
loadtime:2.2101900577545 / seconds
Query Executed:select id FROM `va` where city='Disputanta' && SIC_code='8661'DB:business_master_new
loadtime:2.2121820449829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doe Hill' limit 1
loadtime:2.2122800350189 / seconds
Query Executed:select id FROM `va` where city='Doe Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.212776184082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dogue' limit 1
loadtime:2.2128531932831 / seconds
Query Executed:select id FROM `va` where city='Dogue' && SIC_code='8661'DB:business_master_new
loadtime:2.213320016861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolphin' limit 1
loadtime:2.2133750915527 / seconds
Query Executed:select id FROM `va` where city='Dolphin' && SIC_code='8661'DB:business_master_new
loadtime:2.2140130996704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doran' limit 1
loadtime:2.2140810489655 / seconds
Query Executed:select id FROM `va` where city='Doran' && SIC_code='8661'DB:business_master_new
loadtime:2.2147459983826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doswell' limit 1
loadtime:2.2148239612579 / seconds
Query Executed:select id FROM `va` where city='Doswell' && SIC_code='8661'DB:business_master_new
loadtime:2.2164051532745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakes Branch' limit 1
loadtime:2.2164821624756 / seconds
Query Executed:select id FROM `va` where city='Drakes Branch' && SIC_code='8661'DB:business_master_new
loadtime:2.2178239822388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:2.2179040908813 / seconds
Query Executed:select id FROM `va` where city='Draper' && SIC_code='8661'DB:business_master_new
loadtime:2.218729019165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewryville' limit 1
loadtime:2.2188160419464 / seconds
Query Executed:select id FROM `va` where city='Drewryville' && SIC_code='8661'DB:business_master_new
loadtime:2.2194390296936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Fork' limit 1
loadtime:2.2195081710815 / seconds
Query Executed:select id FROM `va` where city='Dry Fork' && SIC_code='8661'DB:business_master_new
loadtime:2.2211670875549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:2.2212660312653 / seconds
Query Executed:select id FROM `va` where city='Dryden' && SIC_code='8661'DB:business_master_new
loadtime:2.2222371101379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:2.2223160266876 / seconds
Query Executed:select id FROM `va` where city='Dublin' && SIC_code='8661'DB:business_master_new
loadtime:2.2276530265808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duffield' limit 1
loadtime:2.2277619838715 / seconds
Query Executed:select id FROM `va` where city='Duffield' && SIC_code='8661'DB:business_master_new
loadtime:2.2297961711884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugspur' limit 1
loadtime:2.2298910617828 / seconds
Query Executed:select id FROM `va` where city='Dugspur' && SIC_code='8661'DB:business_master_new
loadtime:2.2305769920349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulles' limit 1
loadtime:2.2306470870972 / seconds
Query Executed:select id FROM `va` where city='Dulles' && SIC_code='8661'DB:business_master_new
loadtime:2.2314050197601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumfries' limit 1
loadtime:2.2314670085907 / seconds
Query Executed:select id FROM `va` where city='Dumfries' && SIC_code='8661'DB:business_master_new
loadtime:2.2407159805298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundas' limit 1
loadtime:2.2408339977264 / seconds
Query Executed:select id FROM `va` where city='Dundas' && SIC_code='8661'DB:business_master_new
loadtime:2.2414591312408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dungannon' limit 1
loadtime:2.2415370941162 / seconds
Query Executed:select id FROM `va` where city='Dungannon' && SIC_code='8661'DB:business_master_new
loadtime:2.242329120636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn Loring' limit 1
loadtime:2.2424001693726 / seconds
Query Executed:select id FROM `va` where city='Dunn Loring' && SIC_code='8661'DB:business_master_new
loadtime:2.244341135025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunnsville' limit 1
loadtime:2.2444200515747 / seconds
Query Executed:select id FROM `va` where city='Dunnsville' && SIC_code='8661'DB:business_master_new
loadtime:2.245197057724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:2.245274066925 / seconds
Query Executed:select id FROM `va` where city='Dutton' && SIC_code='8661'DB:business_master_new
loadtime:2.245857000351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyke' limit 1
loadtime:2.2459251880646 / seconds
Query Executed:select id FROM `va` where city='Dyke' && SIC_code='8661'DB:business_master_new
loadtime:2.246514081955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:2.2465829849243 / seconds
Query Executed:select id FROM `va` where city='Eagle Rock' && SIC_code='8661'DB:business_master_new
loadtime:2.2474989891052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlysville' limit 1
loadtime:2.2475781440735 / seconds
Query Executed:select id FROM `va` where city='Earlysville' && SIC_code='8661'DB:business_master_new
loadtime:2.2500619888306 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Stone Gap' limit 1
loadtime:2.2501389980316 / seconds
Query Executed:select id FROM `va` where city='East Stone Gap' && SIC_code='8661'DB:business_master_new
loadtime:2.2505731582642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastville' limit 1
loadtime:2.2506401538849 / seconds
Query Executed:select id FROM `va` where city='Eastville' && SIC_code='8661'DB:business_master_new
loadtime:2.2518901824951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ebony' limit 1
loadtime:2.2519631385803 / seconds
Query Executed:select id FROM `va` where city='Ebony' && SIC_code='8661'DB:business_master_new
loadtime:2.2526481151581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:2.2527220249176 / seconds
Query Executed:select id FROM `va` where city='Edinburg' && SIC_code='8661'DB:business_master_new
loadtime:2.2566680908203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:2.2567811012268 / seconds
Query Executed:select id FROM `va` where city='Edwardsville' && SIC_code='8661'DB:business_master_new
loadtime:2.2572391033173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eggleston' limit 1
loadtime:2.2573101520538 / seconds
Query Executed:select id FROM `va` where city='Eggleston' && SIC_code='8661'DB:business_master_new
loadtime:2.2578589916229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:2.2579259872437 / seconds
Query Executed:select id FROM `va` where city='Elberon' && SIC_code='8661'DB:business_master_new
loadtime:2.2585020065308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Creek' limit 1
loadtime:2.258572101593 / seconds
Query Executed:select id FROM `va` where city='Elk Creek' && SIC_code='8661'DB:business_master_new
loadtime:2.2593281269073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:2.2594010829926 / seconds
Query Executed:select id FROM `va` where city='Elk Garden' && SIC_code='8661'DB:business_master_new
loadtime:2.2597851753235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:2.2598540782928 / seconds
Query Executed:select id FROM `va` where city='Elkton' && SIC_code='8661'DB:business_master_new
loadtime:2.264228105545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkwood' limit 1
loadtime:2.2643611431122 / seconds
Query Executed:select id FROM `va` where city='Elkwood' && SIC_code='8661'DB:business_master_new
loadtime:2.2650821208954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliston' limit 1
loadtime:2.2651431560516 / seconds
Query Executed:select id FROM `va` where city='Elliston' && SIC_code='8661'DB:business_master_new
loadtime:2.2664451599121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emory' limit 1
loadtime:2.2665221691132 / seconds
Query Executed:select id FROM `va` where city='Emory' && SIC_code='8661'DB:business_master_new
loadtime:2.2670440673828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:2.2671101093292 / seconds
Query Executed:select id FROM `va` where city='Emporia' && SIC_code='8661'DB:business_master_new
loadtime:2.2754461765289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engleside' limit 1
loadtime:2.2756280899048 / seconds
Query Executed:select id FROM `va` where city='Engleside' && SIC_code='8661'DB:business_master_new
loadtime:2.2762551307678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esmont' limit 1
loadtime:2.276319026947 / seconds
Query Executed:select id FROM `va` where city='Esmont' && SIC_code='8661'DB:business_master_new
loadtime:2.2770020961761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etlan' limit 1
loadtime:2.2770800590515 / seconds
Query Executed:select id FROM `va` where city='Etlan' && SIC_code='8661'DB:business_master_new
loadtime:2.2775230407715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:2.2775781154633 / seconds
Query Executed:select id FROM `va` where city='Ettrick' && SIC_code='8661'DB:business_master_new
loadtime:2.2779650688171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:2.2780210971832 / seconds
Query Executed:select id FROM `va` where city='Evergreen' && SIC_code='8661'DB:business_master_new
loadtime:2.2785141468048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evington' limit 1
loadtime:2.278578042984 / seconds
Query Executed:select id FROM `va` where city='Evington' && SIC_code='8661'DB:business_master_new
loadtime:2.2804710865021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewing' limit 1
loadtime:2.2805650234222 / seconds
Query Executed:select id FROM `va` where city='Ewing' && SIC_code='8661'DB:business_master_new
loadtime:2.2817289829254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exmore' limit 1
loadtime:2.2818191051483 / seconds
Query Executed:select id FROM `va` where city='Exmore' && SIC_code='8661'DB:business_master_new
loadtime:2.2846531867981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faber' limit 1
loadtime:2.2847349643707 / seconds
Query Executed:select id FROM `va` where city='Faber' && SIC_code='8661'DB:business_master_new
loadtime:2.2856390476227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:2.2857160568237 / seconds
Query Executed:select id FROM `va` where city='Fairfax' && SIC_code='8661'DB:business_master_new
loadtime:2.3966829776764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax Station' limit 1
loadtime:2.3970491886139 / seconds
Query Executed:select id FROM `va` where city='Fairfax Station' && SIC_code='8661'DB:business_master_new
loadtime:2.5348470211029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:2.5350601673126 / seconds
Query Executed:select id FROM `va` where city='Fairfield' && SIC_code='8661'DB:business_master_new
loadtime:2.5365471839905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlawn' limit 1
loadtime:2.5366241931915 / seconds
Query Executed:select id FROM `va` where city='Fairlawn' && SIC_code='8661'DB:business_master_new
loadtime:2.5370781421661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Church' limit 1
loadtime:2.5371341705322 / seconds
Query Executed:select id FROM `va` where city='Falls Church' && SIC_code='8661'DB:business_master_new
loadtime:2.617201089859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Mills' limit 1
loadtime:2.6175441741943 / seconds
Query Executed:select id FROM `va` where city='Falls Mills' && SIC_code='8661'DB:business_master_new
loadtime:2.6183290481567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:2.6184241771698 / seconds
Query Executed:select id FROM `va` where city='Falmouth' && SIC_code='8661'DB:business_master_new
loadtime:2.6188151836395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fancy Gap' limit 1
loadtime:2.618870973587 / seconds
Query Executed:select id FROM `va` where city='Fancy Gap' && SIC_code='8661'DB:business_master_new
loadtime:2.6202120780945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:2.6202840805054 / seconds
Query Executed:select id FROM `va` where city='Farmville' && SIC_code='8661'DB:business_master_new
loadtime:2.7574710845947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnham' limit 1
loadtime:2.7577230930328 / seconds
Query Executed:select id FROM `va` where city='Farnham' && SIC_code='8661'DB:business_master_new
loadtime:2.7588889598846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrum' limit 1
loadtime:2.7589910030365 / seconds
Query Executed:select id FROM `va` where city='Ferrum' && SIC_code='8661'DB:business_master_new
loadtime:2.760684967041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldale' limit 1
loadtime:2.7607810497284 / seconds
Query Executed:select id FROM `va` where city='Fieldale' && SIC_code='8661'DB:business_master_new
loadtime:2.7623841762543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:2.7624700069427 / seconds
Query Executed:select id FROM `va` where city='Fife' && SIC_code='8661'DB:business_master_new
loadtime:2.7629029750824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fincastle' limit 1
loadtime:2.7629590034485 / seconds
Query Executed:select id FROM `va` where city='Fincastle' && SIC_code='8661'DB:business_master_new
loadtime:2.7657110691071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishers Hill' limit 1
loadtime:2.7658159732819 / seconds
Query Executed:select id FROM `va` where city='Fishers Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.766252040863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishersville' limit 1
loadtime:2.766321182251 / seconds
Query Executed:select id FROM `va` where city='Fishersville' && SIC_code='8661'DB:business_master_new
loadtime:2.7700309753418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint Hill' limit 1
loadtime:2.7701201438904 / seconds
Query Executed:select id FROM `va` where city='Flint Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.7711300849915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:2.7712030410767 / seconds
Query Executed:select id FROM `va` where city='Floyd' && SIC_code='8661'DB:business_master_new
loadtime:2.7761371135712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foneswood' limit 1
loadtime:2.7762551307678 / seconds
Query Executed:select id FROM `va` where city='Foneswood' && SIC_code='8661'DB:business_master_new
loadtime:2.7766251564026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:2.7767000198364 / seconds
Query Executed:select id FROM `va` where city='Ford' && SIC_code='8661'DB:business_master_new
loadtime:2.7772831916809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:2.7773571014404 / seconds
Query Executed:select id FROM `va` where city='Forest' && SIC_code='8661'DB:business_master_new
loadtime:2.9156401157379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork Union' limit 1
loadtime:2.9158630371094 / seconds
Query Executed:select id FROM `va` where city='Fork Union' && SIC_code='8661'DB:business_master_new
loadtime:2.9172601699829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Belvoir' limit 1
loadtime:2.9173460006714 / seconds
Query Executed:select id FROM `va` where city='Fort Belvoir' && SIC_code='8661'DB:business_master_new
loadtime:2.9199311733246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Blackmore' limit 1
loadtime:2.9200091362 / seconds
Query Executed:select id FROM `va` where city='Fort Blackmore' && SIC_code='8661'DB:business_master_new
loadtime:2.9206011295319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:2.9206659793854 / seconds
Query Executed:select id FROM `va` where city='Fort Defiance' && SIC_code='8661'DB:business_master_new
loadtime:2.9214069843292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Eustis' limit 1
loadtime:2.9214770793915 / seconds
Query Executed:select id FROM `va` where city='Fort Eustis' && SIC_code='8661'DB:business_master_new
loadtime:2.9228780269623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:2.9229500293732 / seconds
Query Executed:select id FROM `va` where city='Fort Lee' && SIC_code='8661'DB:business_master_new
loadtime:2.9241960048676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:2.924262046814 / seconds
Query Executed:select id FROM `va` where city='Fort Mitchell' && SIC_code='8661'DB:business_master_new
loadtime:2.9247100353241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monroe' limit 1
loadtime:2.9247760772705 / seconds
Query Executed:select id FROM `va` where city='Fort Monroe' && SIC_code='8661'DB:business_master_new
loadtime:2.925595998764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Myer' limit 1
loadtime:2.9256641864777 / seconds
Query Executed:select id FROM `va` where city='Fort Myer' && SIC_code='8661'DB:business_master_new
loadtime:2.926530122757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Valley' limit 1
loadtime:2.926586151123 / seconds
Query Executed:select id FROM `va` where city='Fort Valley' && SIC_code='8661'DB:business_master_new
loadtime:2.9275681972504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:2.9276440143585 / seconds
Query Executed:select id FROM `va` where city='Foster' && SIC_code='8661'DB:business_master_new
loadtime:2.9281749725342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:2.9282431602478 / seconds
Query Executed:select id FROM `va` where city='Franconia' && SIC_code='8661'DB:business_master_new
loadtime:2.928719997406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.9287900924683 / seconds
Query Executed:select id FROM `va` where city='Franklin' && SIC_code='8661'DB:business_master_new
loadtime:3.0656890869141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:3.0659620761871 / seconds
Query Executed:select id FROM `va` where city='Franktown' && SIC_code='8661'DB:business_master_new
loadtime:3.0667281150818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:3.0668170452118 / seconds
Query Executed:select id FROM `va` where city='Fredericksburg' && SIC_code='8661'DB:business_master_new
loadtime:3.1517360210419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Union' limit 1
loadtime:3.1521580219269 / seconds
Query Executed:select id FROM `va` where city='Free Union' && SIC_code='8661'DB:business_master_new
loadtime:3.1533119678497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:3.1534061431885 / seconds
Query Executed:select id FROM `va` where city='Freeman' && SIC_code='8661'DB:business_master_new
loadtime:3.154149055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fries' limit 1
loadtime:3.1542270183563 / seconds
Query Executed:select id FROM `va` where city='Fries' && SIC_code='8661'DB:business_master_new
loadtime:3.1555709838867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Front Royal' limit 1
loadtime:3.1556520462036 / seconds
Query Executed:select id FROM `va` where city='Front Royal' && SIC_code='8661'DB:business_master_new
loadtime:3.183384180069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ft Myer' limit 1
loadtime:3.1835789680481 / seconds
Query Executed:select id FROM `va` where city='Ft Myer' && SIC_code='8661'DB:business_master_new
loadtime:3.1839680671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulks Run' limit 1
loadtime:3.1840341091156 / seconds
Query Executed:select id FROM `va` where city='Fulks Run' && SIC_code='8661'DB:business_master_new
loadtime:3.185054063797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:3.1851379871368 / seconds
Query Executed:select id FROM `va` where city='Gainesville' && SIC_code='8661'DB:business_master_new
loadtime:3.3224270343781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galax' limit 1
loadtime:3.322606086731 / seconds
Query Executed:select id FROM `va` where city='Galax' && SIC_code='8661'DB:business_master_new
loadtime:3.4610819816589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrisonville' limit 1
loadtime:3.4613790512085 / seconds
Query Executed:select id FROM `va` where city='Garrisonville' && SIC_code='8661'DB:business_master_new
loadtime:3.4623019695282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gasburg' limit 1
loadtime:3.4623999595642 / seconds
Query Executed:select id FROM `va` where city='Gasburg' && SIC_code='8661'DB:business_master_new
loadtime:3.4633071422577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gate City' limit 1
loadtime:3.4634070396423 / seconds
Query Executed:select id FROM `va` where city='Gate City' && SIC_code='8661'DB:business_master_new
loadtime:3.4674601554871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Hill' limit 1
loadtime:3.4676260948181 / seconds
Query Executed:select id FROM `va` where city='Glade Hill' && SIC_code='8661'DB:business_master_new
loadtime:3.4691619873047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Spring' limit 1
loadtime:3.4692640304565 / seconds
Query Executed:select id FROM `va` where city='Glade Spring' && SIC_code='8661'DB:business_master_new
loadtime:3.471657037735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladehill' limit 1
loadtime:3.4717810153961 / seconds
Query Executed:select id FROM `va` where city='Gladehill' && SIC_code='8661'DB:business_master_new
loadtime:3.4722261428833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:3.4723019599915 / seconds
Query Executed:select id FROM `va` where city='Gladstone' && SIC_code='8661'DB:business_master_new
loadtime:3.473286151886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladys' limit 1
loadtime:3.4733929634094 / seconds
Query Executed:select id FROM `va` where city='Gladys' && SIC_code='8661'DB:business_master_new
loadtime:3.4748630523682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:3.4749820232391 / seconds
Query Executed:select id FROM `va` where city='Glasgow' && SIC_code='8661'DB:business_master_new
loadtime:3.4761819839478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:3.4762811660767 / seconds
Query Executed:select id FROM `va` where city='Glen Allen' && SIC_code='8661'DB:business_master_new
loadtime:3.5124530792236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Lyn' limit 1
loadtime:3.5126571655273 / seconds
Query Executed:select id FROM `va` where city='Glen Lyn' && SIC_code='8661'DB:business_master_new
loadtime:3.5133690834045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Wilton' limit 1
loadtime:3.5134630203247 / seconds
Query Executed:select id FROM `va` where city='Glen Wilton' && SIC_code='8661'DB:business_master_new
loadtime:3.5138721466064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:3.5139400959015 / seconds
Query Executed:select id FROM `va` where city='Gloucester' && SIC_code='8661'DB:business_master_new
loadtime:3.6508891582489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester Point' limit 1
loadtime:3.6511189937592 / seconds
Query Executed:select id FROM `va` where city='Gloucester Point' && SIC_code='8661'DB:business_master_new
loadtime:3.6530699729919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldbond' limit 1
loadtime:3.6531591415405 / seconds
Query Executed:select id FROM `va` where city='Goldbond' && SIC_code='8661'DB:business_master_new
loadtime:3.6535840034485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldvein' limit 1
loadtime:3.6536381244659 / seconds
Query Executed:select id FROM `va` where city='Goldvein' && SIC_code='8661'DB:business_master_new
loadtime:3.6544630527496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goochland' limit 1
loadtime:3.6545381546021 / seconds
Query Executed:select id FROM `va` where city='Goochland' && SIC_code='8661'DB:business_master_new
loadtime:3.6575741767883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goode' limit 1
loadtime:3.6576731204987 / seconds
Query Executed:select id FROM `va` where city='Goode' && SIC_code='8661'DB:business_master_new
loadtime:3.6591529846191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodview' limit 1
loadtime:3.6592350006104 / seconds
Query Executed:select id FROM `va` where city='Goodview' && SIC_code='8661'DB:business_master_new
loadtime:3.6606869697571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordonsville' limit 1
loadtime:3.6607670783997 / seconds
Query Executed:select id FROM `va` where city='Gordonsville' && SIC_code='8661'DB:business_master_new
loadtime:3.6639771461487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore' limit 1
loadtime:3.6640751361847 / seconds
Query Executed:select id FROM `va` where city='Gore' && SIC_code='8661'DB:business_master_new
loadtime:3.6652121543884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:3.6652851104736 / seconds
Query Executed:select id FROM `va` where city='Goshen' && SIC_code='8661'DB:business_master_new
loadtime:3.6661059856415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:3.6661751270294 / seconds
Query Executed:select id FROM `va` where city='Grafton' && SIC_code='8661'DB:business_master_new
loadtime:3.6667129993439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graves Mill' limit 1
loadtime:3.6667649745941 / seconds
Query Executed:select id FROM `va` where city='Graves Mill' && SIC_code='8661'DB:business_master_new
loadtime:3.6671721935272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:3.6672251224518 / seconds
Query Executed:select id FROM `va` where city='Great Falls' && SIC_code='8661'DB:business_master_new
loadtime:3.805370092392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:3.8055281639099 / seconds
Query Executed:select id FROM `va` where city='Green Bay' && SIC_code='8661'DB:business_master_new
loadtime:3.8063349723816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbackville' limit 1
loadtime:3.8064081668854 / seconds
Query Executed:select id FROM `va` where city='Greenbackville' && SIC_code='8661'DB:business_master_new
loadtime:3.8070631027222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:3.8071291446686 / seconds
Query Executed:select id FROM `va` where city='Greenbush' && SIC_code='8661'DB:business_master_new
loadtime:3.8077399730682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:3.807816028595 / seconds
Query Executed:select id FROM `va` where city='Greenville' && SIC_code='8661'DB:business_master_new
loadtime:3.8088810443878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenway' limit 1
loadtime:3.8089570999146 / seconds
Query Executed:select id FROM `va` where city='Greenway' && SIC_code='8661'DB:business_master_new
loadtime:3.8093841075897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:3.8094379901886 / seconds
Query Executed:select id FROM `va` where city='Greenwood' && SIC_code='8661'DB:business_master_new
loadtime:3.8101251125336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gretna' limit 1
loadtime:3.8101971149445 / seconds
Query Executed:select id FROM `va` where city='Gretna' && SIC_code='8661'DB:business_master_new
loadtime:3.8141391277313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimstead' limit 1
loadtime:3.8142931461334 / seconds
Query Executed:select id FROM `va` where city='Grimstead' && SIC_code='8661'DB:business_master_new
loadtime:3.8147761821747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grottoes' limit 1
loadtime:3.8148481845856 / seconds
Query Executed:select id FROM `va` where city='Grottoes' && SIC_code='8661'DB:business_master_new
loadtime:3.8168630599976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy' limit 1
loadtime:3.8169519901276 / seconds
Query Executed:select id FROM `va` where city='Grundy' && SIC_code='8661'DB:business_master_new
loadtime:3.8222570419312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gum Spring' limit 1
loadtime:3.8223550319672 / seconds
Query Executed:select id FROM `va` where city='Gum Spring' && SIC_code='8661'DB:business_master_new
loadtime:3.823292016983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwynn' limit 1
loadtime:3.8233780860901 / seconds
Query Executed:select id FROM `va` where city='Gwynn' && SIC_code='8661'DB:business_master_new
loadtime:3.8239221572876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacksneck' limit 1
loadtime:3.8239960670471 / seconds
Query Executed:select id FROM `va` where city='Hacksneck' && SIC_code='8661'DB:business_master_new
loadtime:3.8244600296021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadensville' limit 1
loadtime:3.8245141506195 / seconds
Query Executed:select id FROM `va` where city='Hadensville' && SIC_code='8661'DB:business_master_new
loadtime:3.8250131607056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hague' limit 1
loadtime:3.8250660896301 / seconds
Query Executed:select id FROM `va` where city='Hague' && SIC_code='8661'DB:business_master_new
loadtime:3.8262071609497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:3.8262829780579 / seconds
Query Executed:select id FROM `va` where city='Halifax' && SIC_code='8661'DB:business_master_new
loadtime:3.8304660320282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallieford' limit 1
loadtime:3.8305881023407 / seconds
Query Executed:select id FROM `va` where city='Hallieford' && SIC_code='8661'DB:business_master_new
loadtime:3.8310670852661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallwood' limit 1
loadtime:3.831127166748 / seconds
Query Executed:select id FROM `va` where city='Hallwood' && SIC_code='8661'DB:business_master_new
loadtime:3.8317379951477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:3.8318150043488 / seconds
Query Executed:select id FROM `va` where city='Hamilton' && SIC_code='8661'DB:business_master_new
loadtime:3.833606004715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden Sydney' limit 1
loadtime:3.8336851596832 / seconds
Query Executed:select id FROM `va` where city='Hampden Sydney' && SIC_code='8661'DB:business_master_new
loadtime:3.8342759609222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:3.8343479633331 / seconds
Query Executed:select id FROM `va` where city='Hampton' && SIC_code='8661'DB:business_master_new
loadtime:3.8992350101471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:3.8997690677643 / seconds
Query Executed:select id FROM `va` where city='Hanover' && SIC_code='8661'DB:business_master_new
loadtime:3.9022870063782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harborton' limit 1
loadtime:3.902407169342 / seconds
Query Executed:select id FROM `va` where city='Harborton' && SIC_code='8661'DB:business_master_new
loadtime:3.9028780460358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:3.902939081192 / seconds
Query Executed:select id FROM `va` where city='Hardy' && SIC_code='8661'DB:business_master_new
loadtime:3.9056870937347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardyville' limit 1
loadtime:3.9057760238647 / seconds
Query Executed:select id FROM `va` where city='Hardyville' && SIC_code='8661'DB:business_master_new
loadtime:3.906357049942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:3.9064140319824 / seconds
Query Executed:select id FROM `va` where city='Harman' && SIC_code='8661'DB:business_master_new
loadtime:3.9068691730499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonburg' limit 1
loadtime:3.9069230556488 / seconds
Query Executed:select id FROM `va` where city='Harrisonburg' && SIC_code='8661'DB:business_master_new
loadtime:3.952819108963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartfield' limit 1
loadtime:3.953134059906 / seconds
Query Executed:select id FROM `va` where city='Hartfield' && SIC_code='8661'DB:business_master_new
loadtime:3.9543781280518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwood' limit 1
loadtime:3.9544680118561 / seconds
Query Executed:select id FROM `va` where city='Hartwood' && SIC_code='8661'DB:business_master_new
loadtime:3.9551060199738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:3.9551620483398 / seconds
Query Executed:select id FROM `va` where city='Hayes' && SIC_code='8661'DB:business_master_new
loadtime:3.9605720043182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haymarket' limit 1
loadtime:3.9606590270996 / seconds
Query Executed:select id FROM `va` where city='Haymarket' && SIC_code='8661'DB:business_master_new
loadtime:3.9670240879059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haynesville' limit 1
loadtime:3.9671101570129 / seconds
Query Executed:select id FROM `va` where city='Haynesville' && SIC_code='8661'DB:business_master_new
loadtime:3.9676430225372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysi' limit 1
loadtime:3.9677109718323 / seconds
Query Executed:select id FROM `va` where city='Haysi' && SIC_code='8661'DB:business_master_new
loadtime:3.9693140983582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:3.9693841934204 / seconds
Query Executed:select id FROM `va` where city='Haywood' && SIC_code='8661'DB:business_master_new
loadtime:3.9699020385742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Head Waters' limit 1
loadtime:3.9699730873108 / seconds
Query Executed:select id FROM `va` where city='Head Waters' && SIC_code='8661'DB:business_master_new
loadtime:3.9703960418701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heathsville' limit 1
loadtime:3.9704489707947 / seconds
Query Executed:select id FROM `va` where city='Heathsville' && SIC_code='8661'DB:business_master_new
loadtime:3.9733250141144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:3.9734191894531 / seconds
Query Executed:select id FROM `va` where city='Henry' && SIC_code='8661'DB:business_master_new
loadtime:3.9743571281433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:3.9744310379028 / seconds
Query Executed:select id FROM `va` where city='Herndon' && SIC_code='8661'DB:business_master_new
loadtime:4.0262351036072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Springs' limit 1
loadtime:4.0264229774475 / seconds
Query Executed:select id FROM `va` where city='Highland Springs' && SIC_code='8661'DB:business_master_new
loadtime:4.0269300937653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightown' limit 1
loadtime:4.0269980430603 / seconds
Query Executed:select id FROM `va` where city='Hightown' && SIC_code='8661'DB:business_master_new
loadtime:4.0273931026459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsville' limit 1
loadtime:4.0274460315704 / seconds
Query Executed:select id FROM `va` where city='Hillsville' && SIC_code='8661'DB:business_master_new
loadtime:4.0332760810852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiltons' limit 1
loadtime:4.0333931446075 / seconds
Query Executed:select id FROM `va` where city='Hiltons' && SIC_code='8661'DB:business_master_new
loadtime:4.0341470241547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:4.0342221260071 / seconds
Query Executed:select id FROM `va` where city='Hinton' && SIC_code='8661'DB:business_master_new
loadtime:4.0349090099335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiwassee' limit 1
loadtime:4.0349819660187 / seconds
Query Executed:select id FROM `va` where city='Hiwassee' && SIC_code='8661'DB:business_master_new
loadtime:4.0357751846313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:4.035856962204 / seconds
Query Executed:select id FROM `va` where city='Hollins' && SIC_code='8661'DB:business_master_new
loadtime:4.0362801551819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaker' limit 1
loadtime:4.0363340377808 / seconds
Query Executed:select id FROM `va` where city='Honaker' && SIC_code='8661'DB:business_master_new
loadtime:4.0383741855621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood' limit 1
loadtime:4.0384559631348 / seconds
Query Executed:select id FROM `va` where city='Hood' && SIC_code='8661'DB:business_master_new
loadtime:4.0389430522919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:4.0390150547028 / seconds
Query Executed:select id FROM `va` where city='Hopewell' && SIC_code='8661'DB:business_master_new
loadtime:4.0601990222931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horntown' limit 1
loadtime:4.0603749752045 / seconds
Query Executed:select id FROM `va` where city='Horntown' && SIC_code='8661'DB:business_master_new
loadtime:4.0609600543976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horsepen' limit 1
loadtime:4.0610389709473 / seconds
Query Executed:select id FROM `va` where city='Horsepen' && SIC_code='8661'DB:business_master_new
loadtime:4.0613839626312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:4.0614380836487 / seconds
Query Executed:select id FROM `va` where city='Hot Springs' && SIC_code='8661'DB:business_master_new
loadtime:4.063579082489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howardsville' limit 1
loadtime:4.0636651515961 / seconds
Query Executed:select id FROM `va` where city='Howardsville' && SIC_code='8661'DB:business_master_new
loadtime:4.0641779899597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howertons' limit 1
loadtime:4.0642449855804 / seconds
Query Executed:select id FROM `va` where city='Howertons' && SIC_code='8661'DB:business_master_new
loadtime:4.0646619796753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huddleston' limit 1
loadtime:4.0647151470184 / seconds
Query Executed:select id FROM `va` where city='Huddleston' && SIC_code='8661'DB:business_master_new
loadtime:4.0664579868317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudgins' limit 1
loadtime:4.0665349960327 / seconds
Query Executed:select id FROM `va` where city='Hudgins' && SIC_code='8661'DB:business_master_new
loadtime:4.0672559738159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hume' limit 1
loadtime:4.0673351287842 / seconds
Query Executed:select id FROM `va` where city='Hume' && SIC_code='8661'DB:business_master_new
loadtime:4.0681540966034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntly' limit 1
loadtime:4.0682191848755 / seconds
Query Executed:select id FROM `va` where city='Huntly' && SIC_code='8661'DB:business_master_new
loadtime:4.0688259601593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:4.0688920021057 / seconds
Query Executed:select id FROM `va` where city='Hurley' && SIC_code='8661'DB:business_master_new
loadtime:4.0698421001434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurt' limit 1
loadtime:4.0699071884155 / seconds
Query Executed:select id FROM `va` where city='Hurt' && SIC_code='8661'DB:business_master_new
loadtime:4.072154045105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustle' limit 1
loadtime:4.0722601413727 / seconds
Query Executed:select id FROM `va` where city='Hustle' && SIC_code='8661'DB:business_master_new
loadtime:4.0727400779724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:4.0728170871735 / seconds
Query Executed:select id FROM `va` where city='Independence' && SIC_code='8661'DB:business_master_new
loadtime:4.0758240222931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Valley' limit 1
loadtime:4.0759091377258 / seconds
Query Executed:select id FROM `va` where city='Indian Valley' && SIC_code='8661'DB:business_master_new
loadtime:4.0763680934906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Gate' limit 1
loadtime:4.0764381885529 / seconds
Query Executed:select id FROM `va` where city='Iron Gate' && SIC_code='8661'DB:business_master_new
loadtime:4.0769469738007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironto' limit 1
loadtime:4.0770361423492 / seconds
Query Executed:select id FROM `va` where city='Ironto' && SIC_code='8661'DB:business_master_new
loadtime:4.0774409770966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:4.0774960517883 / seconds
Query Executed:select id FROM `va` where city='Irvington' && SIC_code='8661'DB:business_master_new
loadtime:4.0790040493011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Wight' limit 1
loadtime:4.0790801048279 / seconds
Query Executed:select id FROM `va` where city='Isle Of Wight' && SIC_code='8661'DB:business_master_new
loadtime:4.0797469615936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:4.0798010826111 / seconds
Query Executed:select id FROM `va` where city='Ivanhoe' && SIC_code='8661'DB:business_master_new
loadtime:4.0804421901703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivor' limit 1
loadtime:4.0805110931396 / seconds
Query Executed:select id FROM `va` where city='Ivor' && SIC_code='8661'DB:business_master_new
loadtime:4.0818440914154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivy' limit 1
loadtime:4.0819389820099 / seconds
Query Executed:select id FROM `va` where city='Ivy' && SIC_code='8661'DB:business_master_new
loadtime:4.0829260349274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:4.0830051898956 / seconds
Query Executed:select id FROM `va` where city='Jamaica' && SIC_code='8661'DB:business_master_new
loadtime:4.0834791660309 / seconds
Query loaded from cache:select * from geodata_geocity where city='James Store' limit 1
loadtime:4.0835449695587 / seconds
Query Executed:select id FROM `va` where city='James Store' && SIC_code='8661'DB:business_master_new
loadtime:4.0839509963989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:4.0840220451355 / seconds
Query Executed:select id FROM `va` where city='Jamestown' && SIC_code='8661'DB:business_master_new
loadtime:4.0844249725342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:4.0844841003418 / seconds
Query Executed:select id FROM `va` where city='Jamesville' && SIC_code='8661'DB:business_master_new
loadtime:4.0849401950836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarratt' limit 1
loadtime:4.0850110054016 / seconds
Query Executed:select id FROM `va` where city='Jarratt' && SIC_code='8661'DB:business_master_new
loadtime:4.0863921642303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:4.0864820480347 / seconds
Query Executed:select id FROM `va` where city='Java' && SIC_code='8661'DB:business_master_new
loadtime:4.0872061252594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonton' limit 1
loadtime:4.0872800350189 / seconds
Query Executed:select id FROM `va` where city='Jeffersonton' && SIC_code='8661'DB:business_master_new
loadtime:4.0882911682129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkins Bridge' limit 1
loadtime:4.0883591175079 / seconds
Query Executed:select id FROM `va` where city='Jenkins Bridge' && SIC_code='8661'DB:business_master_new
loadtime:4.0887331962585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey' limit 1
loadtime:4.0888001918793 / seconds
Query Executed:select id FROM `va` where city='Jersey' && SIC_code='8661'DB:business_master_new
loadtime:4.0892300605774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetersville' limit 1
loadtime:4.0892970561981 / seconds
Query Executed:select id FROM `va` where city='Jetersville' && SIC_code='8661'DB:business_master_new
loadtime:4.0904359817505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell Ridge' limit 1
loadtime:4.0905091762543 / seconds
Query Executed:select id FROM `va` where city='Jewell Ridge' && SIC_code='8661'DB:business_master_new
loadtime:4.0910141468048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:4.091068983078 / seconds
Query Executed:select id FROM `va` where city='Jonesville' && SIC_code='8661'DB:business_master_new
loadtime:4.0937061309814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keeling' limit 1
loadtime:4.0937881469727 / seconds
Query Executed:select id FROM `va` where city='Keeling' && SIC_code='8661'DB:business_master_new
loadtime:4.0945360660553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keen Mountain' limit 1
loadtime:4.0946080684662 / seconds
Query Executed:select id FROM `va` where city='Keen Mountain' && SIC_code='8661'DB:business_master_new
loadtime:4.0952830314636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:4.0953521728516 / seconds
Query Executed:select id FROM `va` where city='Keene' && SIC_code='8661'DB:business_master_new
loadtime:4.0958840847015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keezletown' limit 1
loadtime:4.0959510803223 / seconds
Query Executed:select id FROM `va` where city='Keezletown' && SIC_code='8661'DB:business_master_new
loadtime:4.0967199802399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:4.0967869758606 / seconds
Query Executed:select id FROM `va` where city='Keller' && SIC_code='8661'DB:business_master_new
loadtime:4.0974509716034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenbridge' limit 1
loadtime:4.0975229740143 / seconds
Query Executed:select id FROM `va` where city='Kenbridge' && SIC_code='8661'DB:business_master_new
loadtime:4.1001851558685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kents Store' limit 1
loadtime:4.1002931594849 / seconds
Query Executed:select id FROM `va` where city='Kents Store' && SIC_code='8661'DB:business_master_new
loadtime:4.1011810302734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokee' limit 1
loadtime:4.1012601852417 / seconds
Query Executed:select id FROM `va` where city='Keokee' && SIC_code='8661'DB:business_master_new
loadtime:4.1018071174622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:4.1018869876862 / seconds
Query Executed:select id FROM `va` where city='Keswick' && SIC_code='8661'DB:business_master_new
loadtime:4.1042990684509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keysville' limit 1
loadtime:4.104376077652 / seconds
Query Executed:select id FROM `va` where city='Keysville' && SIC_code='8661'DB:business_master_new
loadtime:4.1071541309357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmarnock' limit 1
loadtime:4.1072521209717 / seconds
Query Executed:select id FROM `va` where city='Kilmarnock' && SIC_code='8661'DB:business_master_new
loadtime:4.2434871196747 / seconds
Query loaded from cache:select * from geodata_geocity where city='King & Queen C H' limit 1
loadtime:4.2436540126801 / seconds
Query Executed:select id FROM `va` where city='King & Queen C H' && SIC_code='8661'DB:business_master_new
loadtime:4.2442350387573 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court Hous' limit 1
loadtime:4.2443029880524 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court Hous' && SIC_code='8661'DB:business_master_new
loadtime:4.2447249889374 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court House' limit 1
loadtime:4.2447791099548 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court House' && SIC_code='8661'DB:business_master_new
loadtime:4.2456340789795 / seconds
Query loaded from cache:select * from geodata_geocity where city='King George' limit 1
loadtime:4.2457020282745 / seconds
Query Executed:select id FROM `va` where city='King George' && SIC_code='8661'DB:business_master_new
loadtime:4.3822381496429 / seconds
Query loaded from cache:select * from geodata_geocity where city='King William' limit 1
loadtime:4.3824300765991 / seconds
Query Executed:select id FROM `va` where city='King William' && SIC_code='8661'DB:business_master_new
loadtime:4.3844840526581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsale' limit 1
loadtime:4.3845860958099 / seconds
Query Executed:select id FROM `va` where city='Kinsale' && SIC_code='8661'DB:business_master_new
loadtime:4.3854460716248 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:4.38551902771 / seconds
Query Executed:select id FROM `va` where city='La Crosse' && SIC_code='8661'DB:business_master_new
loadtime:4.3874251842499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey Spring' limit 1
loadtime:4.3875150680542 / seconds
Query Executed:select id FROM `va` where city='Lacey Spring' && SIC_code='8661'DB:business_master_new
loadtime:4.3879501819611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lackey' limit 1
loadtime:4.3880231380463 / seconds
Query Executed:select id FROM `va` where city='Lackey' && SIC_code='8661'DB:business_master_new
loadtime:4.3884871006012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:4.3885531425476 / seconds
Query Executed:select id FROM `va` where city='Ladysmith' && SIC_code='8661'DB:business_master_new
loadtime:4.3894190788269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:4.3894901275635 / seconds
Query Executed:select id FROM `va` where city='Lafayette' && SIC_code='8661'DB:business_master_new
loadtime:4.389858007431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambsburg' limit 1
loadtime:4.3899130821228 / seconds
Query Executed:select id FROM `va` where city='Lambsburg' && SIC_code='8661'DB:business_master_new
loadtime:4.3904139995575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:4.390468120575 / seconds
Query Executed:select id FROM `va` where city='Lancaster' && SIC_code='8661'DB:business_master_new
loadtime:4.3928411006927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laneview' limit 1
loadtime:4.3929281234741 / seconds
Query Executed:select id FROM `va` where city='Laneview' && SIC_code='8661'DB:business_master_new
loadtime:4.3934140205383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanexa' limit 1
loadtime:4.3934841156006 / seconds
Query Executed:select id FROM `va` where city='Lanexa' && SIC_code='8661'DB:business_master_new
loadtime:4.395122051239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley Afb' limit 1
loadtime:4.3951921463013 / seconds
Query Executed:select id FROM `va` where city='Langley Afb' && SIC_code='8661'DB:business_master_new
loadtime:4.3956851959229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Fork' limit 1
loadtime:4.395740032196 / seconds
Query Executed:select id FROM `va` where city='Laurel Fork' && SIC_code='8661'DB:business_master_new
loadtime:4.3964860439301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:4.3965539932251 / seconds
Query Executed:select id FROM `va` where city='Lawrenceville' && SIC_code='8661'DB:business_master_new
loadtime:4.4007341861725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:4.4008600711823 / seconds
Query Executed:select id FROM `va` where city='Lebanon' && SIC_code='8661'DB:business_master_new
loadtime:4.4065771102905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon Church' limit 1
loadtime:4.4066681861877 / seconds
Query Executed:select id FROM `va` where city='Lebanon Church' && SIC_code='8661'DB:business_master_new
loadtime:4.4070730209351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:4.4071311950684 / seconds
Query Executed:select id FROM `va` where city='Leesburg' && SIC_code='8661'DB:business_master_new
loadtime:4.4506261348724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:4.4508249759674 / seconds
Query Executed:select id FROM `va` where city='Leon' && SIC_code='8661'DB:business_master_new
loadtime:4.4513330459595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:4.4514071941376 / seconds
Query Executed:select id FROM `va` where city='Lexington' && SIC_code='8661'DB:business_master_new
loadtime:4.5896751880646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lightfoot' limit 1
loadtime:4.5899250507355 / seconds
Query Executed:select id FROM `va` where city='Lightfoot' && SIC_code='8661'DB:business_master_new
loadtime:4.5909721851349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lignum' limit 1
loadtime:4.5910470485687 / seconds
Query Executed:select id FROM `va` where city='Lignum' && SIC_code='8661'DB:business_master_new
loadtime:4.5917010307312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:4.5917720794678 / seconds
Query Executed:select id FROM `va` where city='Lincoln' && SIC_code='8661'DB:business_master_new
loadtime:4.5923290252686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:4.592395067215 / seconds
Query Executed:select id FROM `va` where city='Linden' && SIC_code='8661'DB:business_master_new
loadtime:4.5938830375671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:4.5939621925354 / seconds
Query Executed:select id FROM `va` where city='Linville' && SIC_code='8661'DB:business_master_new
loadtime:4.5949289798737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Plymouth' limit 1
loadtime:4.5950140953064 / seconds
Query Executed:select id FROM `va` where city='Little Plymouth' && SIC_code='8661'DB:business_master_new
loadtime:4.5954530239105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lively' limit 1
loadtime:4.5955200195312 / seconds
Query Executed:select id FROM `va` where city='Lively' && SIC_code='8661'DB:business_master_new
loadtime:4.5963270664215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Dale' limit 1
loadtime:4.5963971614838 / seconds
Query Executed:select id FROM `va` where city='Locust Dale' && SIC_code='8661'DB:business_master_new
loadtime:4.5969049930573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Grove' limit 1
loadtime:4.5969681739807 / seconds
Query Executed:select id FROM `va` where city='Locust Grove' && SIC_code='8661'DB:business_master_new
loadtime:4.6008729934692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Hill' limit 1
loadtime:4.6009540557861 / seconds
Query Executed:select id FROM `va` where city='Locust Hill' && SIC_code='8661'DB:business_master_new
loadtime:4.6016800403595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locustville' limit 1
loadtime:4.6017470359802 / seconds
Query Executed:select id FROM `va` where city='Locustville' && SIC_code='8661'DB:business_master_new
loadtime:4.6022791862488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:4.6023330688477 / seconds
Query Executed:select id FROM `va` where city='Long Island' && SIC_code='8661'DB:business_master_new
loadtime:4.6030580997467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:4.6031341552734 / seconds
Query Executed:select id FROM `va` where city='Loretto' && SIC_code='8661'DB:business_master_new
loadtime:4.6035239696503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorton' limit 1
loadtime:4.603590965271 / seconds
Query Executed:select id FROM `va` where city='Lorton' && SIC_code='8661'DB:business_master_new
loadtime:4.6274809837341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lottsburg' limit 1
loadtime:4.6275861263275 / seconds
Query Executed:select id FROM `va` where city='Lottsburg' && SIC_code='8661'DB:business_master_new
loadtime:4.6287980079651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisa' limit 1
loadtime:4.6288721561432 / seconds
Query Executed:select id FROM `va` where city='Louisa' && SIC_code='8661'DB:business_master_new
loadtime:4.6344661712646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovettsville' limit 1
loadtime:4.6345779895782 / seconds
Query Executed:select id FROM `va` where city='Lovettsville' && SIC_code='8661'DB:business_master_new
loadtime:4.6374201774597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovingston' limit 1
loadtime:4.6375031471252 / seconds
Query Executed:select id FROM `va` where city='Lovingston' && SIC_code='8661'DB:business_master_new
loadtime:4.6396241188049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:4.6397061347961 / seconds
Query Executed:select id FROM `va` where city='Low Moor' && SIC_code='8661'DB:business_master_new
loadtime:4.6405770778656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowesville' limit 1
loadtime:4.6406450271606 / seconds
Query Executed:select id FROM `va` where city='Lowesville' && SIC_code='8661'DB:business_master_new
loadtime:4.64102602005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowmoor' limit 1
loadtime:4.6410930156708 / seconds
Query Executed:select id FROM `va` where city='Lowmoor' && SIC_code='8661'DB:business_master_new
loadtime:4.6414389610291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:4.6415030956268 / seconds
Query Executed:select id FROM `va` where city='Lowry' && SIC_code='8661'DB:business_master_new
loadtime:4.641891002655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:4.6419479846954 / seconds
Query Executed:select id FROM `va` where city='Lunenburg' && SIC_code='8661'DB:business_master_new
loadtime:4.6425890922546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:4.6426591873169 / seconds
Query Executed:select id FROM `va` where city='Luray' && SIC_code='8661'DB:business_master_new
loadtime:4.7808060646057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynch Station' limit 1
loadtime:4.7810389995575 / seconds
Query Executed:select id FROM `va` where city='Lynch Station' && SIC_code='8661'DB:business_master_new
loadtime:4.7821660041809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:4.7822680473328 / seconds
Query Executed:select id FROM `va` where city='Lynchburg' && SIC_code='8661'DB:business_master_new
loadtime:4.8474051952362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:4.8479740619659 / seconds
Query Executed:select id FROM `va` where city='Lyndhurst' && SIC_code='8661'DB:business_master_new
loadtime:4.84912109375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Machipongo' limit 1
loadtime:4.849231004715 / seconds
Query Executed:select id FROM `va` where city='Machipongo' && SIC_code='8661'DB:business_master_new
loadtime:4.849995136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:4.8500640392303 / seconds
Query Executed:select id FROM `va` where city='Macon' && SIC_code='8661'DB:business_master_new
loadtime:4.8504600524902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:4.8505141735077 / seconds
Query Executed:select id FROM `va` where city='Madison' && SIC_code='8661'DB:business_master_new
loadtime:4.8545000553131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:4.8545961380005 / seconds
Query Executed:select id FROM `va` where city='Madison Heights' && SIC_code='8661'DB:business_master_new
loadtime:4.8617601394653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Mills' limit 1
loadtime:4.8619019985199 / seconds
Query Executed:select id FROM `va` where city='Madison Mills' && SIC_code='8661'DB:business_master_new
loadtime:4.862380027771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidens' limit 1
loadtime:4.8624520301819 / seconds
Query Executed:select id FROM `va` where city='Maidens' && SIC_code='8661'DB:business_master_new
loadtime:4.8636879920959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manakin Sabot' limit 1
loadtime:4.8637590408325 / seconds
Query Executed:select id FROM `va` where city='Manakin Sabot' && SIC_code='8661'DB:business_master_new
loadtime:4.8671550750732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas' limit 1
loadtime:4.8672471046448 / seconds
Query Executed:select id FROM `va` where city='Manassas' && SIC_code='8661'DB:business_master_new
loadtime:4.9436540603638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas Park' limit 1
loadtime:4.944020986557 / seconds
Query Executed:select id FROM `va` where city='Manassas Park' && SIC_code='8661'DB:business_master_new
loadtime:4.944550037384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mangohick' limit 1
loadtime:4.9446201324463 / seconds
Query Executed:select id FROM `va` where city='Mangohick' && SIC_code='8661'DB:business_master_new
loadtime:4.9449760913849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannboro' limit 1
loadtime:4.9450299739838 / seconds
Query Executed:select id FROM `va` where city='Mannboro' && SIC_code='8661'DB:business_master_new
loadtime:4.9454081058502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manquin' limit 1
loadtime:4.9454741477966 / seconds
Query Executed:select id FROM `va` where city='Manquin' && SIC_code='8661'DB:business_master_new
loadtime:4.946319103241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mappsville' limit 1
loadtime:4.9463901519775 / seconds
Query Executed:select id FROM `va` where city='Mappsville' && SIC_code='8661'DB:business_master_new
loadtime:4.9469821453094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:4.9470551013947 / seconds
Query Executed:select id FROM `va` where city='Marion' && SIC_code='8661'DB:business_master_new
loadtime:5.0850939750671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marionville' limit 1
loadtime:5.0853049755096 / seconds
Query Executed:select id FROM `va` where city='Marionville' && SIC_code='8661'DB:business_master_new
loadtime:5.0858721733093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markham' limit 1
loadtime:5.0859560966492 / seconds
Query Executed:select id FROM `va` where city='Markham' && SIC_code='8661'DB:business_master_new
loadtime:5.0866060256958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:5.0866780281067 / seconds
Query Executed:select id FROM `va` where city='Marshall' && SIC_code='8661'DB:business_master_new
loadtime:5.0912990570068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:5.0913970470428 / seconds
Query Executed:select id FROM `va` where city='Martinsville' && SIC_code='8661'DB:business_master_new
loadtime:5.125678062439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maryus' limit 1
loadtime:5.1260221004486 / seconds
Query Executed:select id FROM `va` where city='Maryus' && SIC_code='8661'DB:business_master_new
loadtime:5.1264820098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mascot' limit 1
loadtime:5.126561164856 / seconds
Query Executed:select id FROM `va` where city='Mascot' && SIC_code='8661'DB:business_master_new
loadtime:5.1269931793213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massies Mill' limit 1
loadtime:5.1270470619202 / seconds
Query Executed:select id FROM `va` where city='Massies Mill' && SIC_code='8661'DB:business_master_new
loadtime:5.1274590492249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:5.1275119781494 / seconds
Query Executed:select id FROM `va` where city='Mathews' && SIC_code='8661'DB:business_master_new
loadtime:5.1306631565094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattaponi' limit 1
loadtime:5.1307461261749 / seconds
Query Executed:select id FROM `va` where city='Mattaponi' && SIC_code='8661'DB:business_master_new
loadtime:5.1315031051636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurertown' limit 1
loadtime:5.1315770149231 / seconds
Query Executed:select id FROM `va` where city='Maurertown' && SIC_code='8661'DB:business_master_new
loadtime:5.1328270435333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mavisdale' limit 1
loadtime:5.1329040527344 / seconds
Query Executed:select id FROM `va` where city='Mavisdale' && SIC_code='8661'DB:business_master_new
loadtime:5.1333181858063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Max Meadows' limit 1
loadtime:5.133385181427 / seconds
Query Executed:select id FROM `va` where city='Max Meadows' && SIC_code='8661'DB:business_master_new
loadtime:5.1357181072235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxie' limit 1
loadtime:5.1358079910278 / seconds
Query Executed:select id FROM `va` where city='Maxie' && SIC_code='8661'DB:business_master_new
loadtime:5.1363320350647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clure' limit 1
loadtime:5.1363871097565 / seconds
Query Executed:select id FROM `va` where city='Mc Clure' && SIC_code='8661'DB:business_master_new
loadtime:5.1368720531464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:5.1369249820709 / seconds
Query Executed:select id FROM `va` where city='Mc Coy' && SIC_code='8661'DB:business_master_new
loadtime:5.1374051570892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Dowell' limit 1
loadtime:5.1374731063843 / seconds
Query Executed:select id FROM `va` where city='Mc Dowell' && SIC_code='8661'DB:business_master_new
loadtime:5.1382360458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gaheysville' limit 1
loadtime:5.1383039951324 / seconds
Query Executed:select id FROM `va` where city='Mc Gaheysville' && SIC_code='8661'DB:business_master_new
loadtime:5.1400580406189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenney' limit 1
loadtime:5.1401350498199 / seconds
Query Executed:select id FROM `va` where city='Mc Kenney' && SIC_code='8661'DB:business_master_new
loadtime:5.1414771080017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lean' limit 1
loadtime:5.1415550708771 / seconds
Query Executed:select id FROM `va` where city='Mc Lean' && SIC_code='8661'DB:business_master_new
loadtime:5.2058889865875 / seconds
Query Executed:select * from geodata_geocity where city='Mckenney' limit 1DB:business_master_new
loadtime:5.2065000534058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mclean' limit 1
loadtime:5.2065691947937 / seconds
Query Executed:select id FROM `va` where city='Mclean' && SIC_code='8661'DB:business_master_new
loadtime:5.2073681354523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows Of Dan' limit 1
loadtime:5.2074310779572 / seconds
Query Executed:select id FROM `va` where city='Meadows Of Dan' && SIC_code='8661'DB:business_master_new
loadtime:5.2086989879608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowview' limit 1
loadtime:5.2087700366974 / seconds
Query Executed:select id FROM `va` where city='Meadowview' && SIC_code='8661'DB:business_master_new
loadtime:5.2105870246887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:5.2106781005859 / seconds
Query Executed:select id FROM `va` where city='Mears' && SIC_code='8661'DB:business_master_new
loadtime:5.2111701965332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:5.2112290859222 / seconds
Query Executed:select id FROM `va` where city='Mechanicsville' && SIC_code='8661'DB:business_master_new
loadtime:5.24680519104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meherrin' limit 1
loadtime:5.2469999790192 / seconds
Query Executed:select id FROM `va` where city='Meherrin' && SIC_code='8661'DB:business_master_new
loadtime:5.2478251457214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melfa' limit 1
loadtime:5.2479090690613 / seconds
Query Executed:select id FROM `va` where city='Melfa' && SIC_code='8661'DB:business_master_new
loadtime:5.2493481636047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendota' limit 1
loadtime:5.2494211196899 / seconds
Query Executed:select id FROM `va` where city='Mendota' && SIC_code='8661'DB:business_master_new
loadtime:5.2499420642853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredithville' limit 1
loadtime:5.2500030994415 / seconds
Query Executed:select id FROM `va` where city='Meredithville' && SIC_code='8661'DB:business_master_new
loadtime:5.2503840923309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrifield' limit 1
loadtime:5.2504351139069 / seconds
Query Executed:select id FROM `va` where city='Merrifield' && SIC_code='8661'DB:business_master_new
loadtime:5.2522740364075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Point' limit 1
loadtime:5.2523410320282 / seconds
Query Executed:select id FROM `va` where city='Merry Point' && SIC_code='8661'DB:business_master_new
loadtime:5.2527661323547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebrook' limit 1
loadtime:5.2528281211853 / seconds
Query Executed:select id FROM `va` where city='Middlebrook' && SIC_code='8661'DB:business_master_new
loadtime:5.2536110877991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:5.2536821365356 / seconds
Query Executed:select id FROM `va` where city='Middleburg' && SIC_code='8661'DB:business_master_new
loadtime:5.2591421604156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:5.2592241764069 / seconds
Query Executed:select id FROM `va` where city='Middletown' && SIC_code='8661'DB:business_master_new
loadtime:5.26118516922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:5.2612700462341 / seconds
Query Executed:select id FROM `va` where city='Midland' && SIC_code='8661'DB:business_master_new
loadtime:5.2629361152649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midlothian' limit 1
loadtime:5.2630240917206 / seconds
Query Executed:select id FROM `va` where city='Midlothian' && SIC_code='8661'DB:business_master_new
loadtime:5.3088641166687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:5.309100151062 / seconds
Query Executed:select id FROM `va` where city='Milford' && SIC_code='8661'DB:business_master_new
loadtime:5.3104929924011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millboro' limit 1
loadtime:5.3105750083923 / seconds
Query Executed:select id FROM `va` where city='Millboro' && SIC_code='8661'DB:business_master_new
loadtime:5.3116781711578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Tavern' limit 1
loadtime:5.311753988266 / seconds
Query Executed:select id FROM `va` where city='Millers Tavern' && SIC_code='8661'DB:business_master_new
loadtime:5.312399148941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:5.312469959259 / seconds
Query Executed:select id FROM `va` where city='Millwood' && SIC_code='8661'DB:business_master_new
loadtime:5.3132040500641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Run' limit 1
loadtime:5.313273191452 / seconds
Query Executed:select id FROM `va` where city='Mine Run' && SIC_code='8661'DB:business_master_new
loadtime:5.3137149810791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:5.3137691020966 / seconds
Query Executed:select id FROM `va` where city='Mineral' && SIC_code='8661'DB:business_master_new
loadtime:5.3174071311951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Spring' limit 1
loadtime:5.3175220489502 / seconds
Query Executed:select id FROM `va` where city='Mint Spring' && SIC_code='8661'DB:business_master_new
loadtime:5.318076133728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchells' limit 1
loadtime:5.3181481361389 / seconds
Query Executed:select id FROM `va` where city='Mitchells' && SIC_code='8661'DB:business_master_new
loadtime:5.318736076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modest Town' limit 1
loadtime:5.318813085556 / seconds
Query Executed:select id FROM `va` where city='Modest Town' && SIC_code='8661'DB:business_master_new
loadtime:5.3192110061646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mollusk' limit 1
loadtime:5.3192801475525 / seconds
Query Executed:select id FROM `va` where city='Mollusk' && SIC_code='8661'DB:business_master_new
loadtime:5.3197250366211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moneta' limit 1
loadtime:5.3197779655457 / seconds
Query Executed:select id FROM `va` where city='Moneta' && SIC_code='8661'DB:business_master_new
loadtime:5.3258171081543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:5.3259270191193 / seconds
Query Executed:select id FROM `va` where city='Monroe' && SIC_code='8661'DB:business_master_new
loadtime:5.3275911808014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montebello' limit 1
loadtime:5.3276879787445 / seconds
Query Executed:select id FROM `va` where city='Montebello' && SIC_code='8661'DB:business_master_new
loadtime:5.3281850814819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:5.3282420635223 / seconds
Query Executed:select id FROM `va` where city='Monterey' && SIC_code='8661'DB:business_master_new
loadtime:5.3303091526031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:5.3303911685944 / seconds
Query Executed:select id FROM `va` where city='Montpelier' && SIC_code='8661'DB:business_master_new
loadtime:5.3331260681152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Sta' limit 1
loadtime:5.3332099914551 / seconds
Query Executed:select id FROM `va` where city='Montpelier Sta' && SIC_code='8661'DB:business_master_new
loadtime:5.3335580825806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Station' limit 1
loadtime:5.3336119651794 / seconds
Query Executed:select id FROM `va` where city='Montpelier Station' && SIC_code='8661'DB:business_master_new
loadtime:5.3340179920197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montross' limit 1
loadtime:5.3340721130371 / seconds
Query Executed:select id FROM `va` where city='Montross' && SIC_code='8661'DB:business_master_new
loadtime:5.3373761177063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:5.3374691009521 / seconds
Query Executed:select id FROM `va` where city='Montvale' && SIC_code='8661'DB:business_master_new
loadtime:5.3386399745941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moon' limit 1
loadtime:5.3387169837952 / seconds
Query Executed:select id FROM `va` where city='Moon' && SIC_code='8661'DB:business_master_new
loadtime:5.3392310142517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morattico' limit 1
loadtime:5.3392870426178 / seconds
Query Executed:select id FROM `va` where city='Morattico' && SIC_code='8661'DB:business_master_new
loadtime:5.3397490978241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:5.3398230075836 / seconds
Query Executed:select id FROM `va` where city='Morrisville' && SIC_code='8661'DB:business_master_new
loadtime:5.3402810096741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moseley' limit 1
loadtime:5.3403470516205 / seconds
Query Executed:select id FROM `va` where city='Moseley' && SIC_code='8661'DB:business_master_new
loadtime:5.3422770500183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Crawford' limit 1
loadtime:5.3423571586609 / seconds
Query Executed:select id FROM `va` where city='Mount Crawford' && SIC_code='8661'DB:business_master_new
loadtime:5.3443450927734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:5.3444249629974 / seconds
Query Executed:select id FROM `va` where city='Mount Holly' && SIC_code='8661'DB:business_master_new
loadtime:5.3450131416321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Jackson' limit 1
loadtime:5.3450691699982 / seconds
Query Executed:select id FROM `va` where city='Mount Jackson' && SIC_code='8661'DB:business_master_new
loadtime:5.3488931655884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sidney' limit 1
loadtime:5.3490011692047 / seconds
Query Executed:select id FROM `va` where city='Mount Sidney' && SIC_code='8661'DB:business_master_new
loadtime:5.3502480983734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Solon' limit 1
loadtime:5.3503241539001 / seconds
Query Executed:select id FROM `va` where city='Mount Solon' && SIC_code='8661'DB:business_master_new
loadtime:5.3516290187836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:5.351704120636 / seconds
Query Executed:select id FROM `va` where city='Mount Vernon' && SIC_code='8661'DB:business_master_new
loadtime:5.3525741100311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mouth Of Wilson' limit 1
loadtime:5.3526420593262 / seconds
Query Executed:select id FROM `va` where city='Mouth Of Wilson' && SIC_code='8661'DB:business_master_new
loadtime:5.3535251617432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Crawford' limit 1
loadtime:5.3535921573639 / seconds
Query Executed:select id FROM `va` where city='Mt Crawford' && SIC_code='8661'DB:business_master_new
loadtime:5.3540480136871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:5.3541150093079 / seconds
Query Executed:select id FROM `va` where city='Mt Holly' && SIC_code='8661'DB:business_master_new
loadtime:5.3544721603394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Jackson' limit 1
loadtime:5.3545250892639 / seconds
Query Executed:select id FROM `va` where city='Mt Jackson' && SIC_code='8661'DB:business_master_new
loadtime:5.3549840450287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sidney' limit 1
loadtime:5.3550369739532 / seconds
Query Executed:select id FROM `va` where city='Mt Sidney' && SIC_code='8661'DB:business_master_new
loadtime:5.3554129600525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Solon' limit 1
loadtime:5.3554639816284 / seconds
Query Executed:select id FROM `va` where city='Mt Solon' && SIC_code='8661'DB:business_master_new
loadtime:5.3558411598206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:5.3558931350708 / seconds
Query Executed:select id FROM `va` where city='Mt Vernon' && SIC_code='8661'DB:business_master_new
loadtime:5.356278181076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mustoe' limit 1
loadtime:5.3563311100006 / seconds
Query Executed:select id FROM `va` where city='Mustoe' && SIC_code='8661'DB:business_master_new
loadtime:5.3567020893097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narrows' limit 1
loadtime:5.3567531108856 / seconds
Query Executed:select id FROM `va` where city='Narrows' && SIC_code='8661'DB:business_master_new
loadtime:5.3588230609894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naruna' limit 1
loadtime:5.3589150905609 / seconds
Query Executed:select id FROM `va` where city='Naruna' && SIC_code='8661'DB:business_master_new
loadtime:5.3594551086426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nassawadox' limit 1
loadtime:5.3595261573792 / seconds
Query Executed:select id FROM `va` where city='Nassawadox' && SIC_code='8661'DB:business_master_new
loadtime:5.3609411716461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathalie' limit 1
loadtime:5.3610181808472 / seconds
Query Executed:select id FROM `va` where city='Nathalie' && SIC_code='8661'DB:business_master_new
loadtime:5.3629701137543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Brdg Sta' limit 1
loadtime:5.3630771636963 / seconds
Query Executed:select id FROM `va` where city='Natural Brdg Sta' && SIC_code='8661'DB:business_master_new
loadtime:5.3634960651398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge' limit 1
loadtime:5.3635520935059 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge' && SIC_code='8661'DB:business_master_new
loadtime:5.3647739887238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge Station' limit 1
loadtime:5.3648581504822 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge Station' && SIC_code='8661'DB:business_master_new
loadtime:5.3658041954041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naval Base' limit 1
loadtime:5.3658759593964 / seconds
Query Executed:select id FROM `va` where city='Naval Base' && SIC_code='8661'DB:business_master_new
loadtime:5.3664531707764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellysford' limit 1
loadtime:5.3665080070496 / seconds
Query Executed:select id FROM `va` where city='Nellysford' && SIC_code='8661'DB:business_master_new
loadtime:5.3683321475983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:5.3684051036835 / seconds
Query Executed:select id FROM `va` where city='Nelson' && SIC_code='8661'DB:business_master_new
loadtime:5.3690090179443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonia' limit 1
loadtime:5.3690810203552 / seconds
Query Executed:select id FROM `va` where city='Nelsonia' && SIC_code='8661'DB:business_master_new
loadtime:5.3696241378784 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canton' limit 1
loadtime:5.3696761131287 / seconds
Query Executed:select id FROM `va` where city='New Canton' && SIC_code='8661'DB:business_master_new
loadtime:5.3705520629883 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:5.3706250190735 / seconds
Query Executed:select id FROM `va` where city='New Castle' && SIC_code='8661'DB:business_master_new
loadtime:5.372584104538 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Church' limit 1
loadtime:5.3726720809937 / seconds
Query Executed:select id FROM `va` where city='New Church' && SIC_code='8661'DB:business_master_new
loadtime:5.3739500045776 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:5.3740310668945 / seconds
Query Executed:select id FROM `va` where city='New Hope' && SIC_code='8661'DB:business_master_new
loadtime:5.3745670318604 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Kent' limit 1
loadtime:5.3746349811554 / seconds
Query Executed:select id FROM `va` where city='New Kent' && SIC_code='8661'DB:business_master_new
loadtime:5.3763401508331 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:5.3764159679413 / seconds
Query Executed:select id FROM `va` where city='New Market' && SIC_code='8661'DB:business_master_new
loadtime:5.3802101612091 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Point' limit 1
loadtime:5.3802981376648 / seconds
Query Executed:select id FROM `va` where city='New Point' && SIC_code='8661'DB:business_master_new
loadtime:5.3807551860809 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:5.3808310031891 / seconds
Query Executed:select id FROM `va` where city='New River' && SIC_code='8661'DB:business_master_new
loadtime:5.3812711238861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:5.3813390731812 / seconds
Query Executed:select id FROM `va` where city='Newbern' && SIC_code='8661'DB:business_master_new
loadtime:5.3818910121918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:5.3819620609283 / seconds
Query Executed:select id FROM `va` where city='Newington' && SIC_code='8661'DB:business_master_new
loadtime:5.3834550380707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:5.3835229873657 / seconds
Query Executed:select id FROM `va` where city='Newport' && SIC_code='8661'DB:business_master_new
loadtime:5.3845121860504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport News' limit 1
loadtime:5.3845829963684 / seconds
Query Executed:select id FROM `va` where city='Newport News' && SIC_code='8661'DB:business_master_new
loadtime:5.4808051586151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newsoms' limit 1
loadtime:5.4814829826355 / seconds
Query Executed:select id FROM `va` where city='Newsoms' && SIC_code='8661'DB:business_master_new
loadtime:5.4824390411377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:5.4825520515442 / seconds
Query Executed:select id FROM `va` where city='Newtown' && SIC_code='8661'DB:business_master_new
loadtime:5.4830591678619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickelsville' limit 1
loadtime:5.4831299781799 / seconds
Query Executed:select id FROM `va` where city='Nickelsville' && SIC_code='8661'DB:business_master_new
loadtime:5.4841539859772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninde' limit 1
loadtime:5.4842190742493 / seconds
Query Executed:select id FROM `va` where city='Ninde' && SIC_code='8661'DB:business_master_new
loadtime:5.484631061554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nokesville' limit 1
loadtime:5.4846830368042 / seconds
Query Executed:select id FROM `va` where city='Nokesville' && SIC_code='8661'DB:business_master_new
loadtime:5.4883341789246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora' limit 1
loadtime:5.488420009613 / seconds
Query Executed:select id FROM `va` where city='Nora' && SIC_code='8661'DB:business_master_new
loadtime:5.488960981369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:5.489030122757 / seconds
Query Executed:select id FROM `va` where city='Norfolk' && SIC_code='8661'DB:business_master_new
loadtime:5.6087641716003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norge' limit 1
loadtime:5.6096911430359 / seconds
Query Executed:select id FROM `va` where city='Norge' && SIC_code='8661'DB:business_master_new
loadtime:5.6103971004486 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:5.6105210781097 / seconds
Query Executed:select id FROM `va` where city='North' && SIC_code='8661'DB:business_master_new
loadtime:5.6112220287323 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Garden' limit 1
loadtime:5.6112880706787 / seconds
Query Executed:select id FROM `va` where city='North Garden' && SIC_code='8661'DB:business_master_new
loadtime:5.6124670505524 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Tazewell' limit 1
loadtime:5.6125459671021 / seconds
Query Executed:select id FROM `va` where city='North Tazewell' && SIC_code='8661'DB:business_master_new
loadtime:5.61510014534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:5.6151909828186 / seconds
Query Executed:select id FROM `va` where city='Norton' && SIC_code='8661'DB:business_master_new
loadtime:5.6209239959717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:5.6210501194 / seconds
Query Executed:select id FROM `va` where city='Norwood' && SIC_code='8661'DB:business_master_new
loadtime:5.6214699745178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottoway' limit 1
loadtime:5.6215369701385 / seconds
Query Executed:select id FROM `va` where city='Nottoway' && SIC_code='8661'DB:business_master_new
loadtime:5.6221840381622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nuttsville' limit 1
loadtime:5.6222491264343 / seconds
Query Executed:select id FROM `va` where city='Nuttsville' && SIC_code='8661'DB:business_master_new
loadtime:5.6226661205292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hall' limit 1
loadtime:5.6227190494537 / seconds
Query Executed:select id FROM `va` where city='Oak Hall' && SIC_code='8661'DB:business_master_new
loadtime:5.6237101554871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakpark' limit 1
loadtime:5.6237761974335 / seconds
Query Executed:select id FROM `va` where city='Oakpark' && SIC_code='8661'DB:business_master_new
loadtime:5.6242430210114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakton' limit 1
loadtime:5.6243109703064 / seconds
Query Executed:select id FROM `va` where city='Oakton' && SIC_code='8661'DB:business_master_new
loadtime:5.7606179714203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakwood' limit 1
loadtime:5.7608079910278 / seconds
Query Executed:select id FROM `va` where city='Oakwood' && SIC_code='8661'DB:business_master_new
loadtime:5.7623910903931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Occoquan' limit 1
loadtime:5.76247215271 / seconds
Query Executed:select id FROM `va` where city='Occoquan' && SIC_code='8661'DB:business_master_new
loadtime:5.764436006546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oilville' limit 1
loadtime:5.7645061016083 / seconds
Query Executed:select id FROM `va` where city='Oilville' && SIC_code='8661'DB:business_master_new
loadtime:5.7658040523529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldhams' limit 1
loadtime:5.7658720016479 / seconds
Query Executed:select id FROM `va` where city='Oldhams' && SIC_code='8661'DB:business_master_new
loadtime:5.7663509845734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onancock' limit 1
loadtime:5.7664210796356 / seconds
Query Executed:select id FROM `va` where city='Onancock' && SIC_code='8661'DB:business_master_new
loadtime:5.7695801258087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onemo' limit 1
loadtime:5.769670009613 / seconds
Query Executed:select id FROM `va` where city='Onemo' && SIC_code='8661'DB:business_master_new
loadtime:5.7701420783997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onley' limit 1
loadtime:5.7702131271362 / seconds
Query Executed:select id FROM `va` where city='Onley' && SIC_code='8661'DB:business_master_new
loadtime:5.7722511291504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophelia' limit 1
loadtime:5.7723271846771 / seconds
Query Executed:select id FROM `va` where city='Ophelia' && SIC_code='8661'DB:business_master_new
loadtime:5.7727580070496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:5.772821187973 / seconds
Query Executed:select id FROM `va` where city='Orange' && SIC_code='8661'DB:business_master_new
loadtime:5.9108390808105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordinary' limit 1
loadtime:5.9110391139984 / seconds
Query Executed:select id FROM `va` where city='Ordinary' && SIC_code='8661'DB:business_master_new
loadtime:5.9117660522461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriskany' limit 1
loadtime:5.9118800163269 / seconds
Query Executed:select id FROM `va` where city='Oriskany' && SIC_code='8661'DB:business_master_new
loadtime:5.9123101234436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orkney Springs' limit 1
loadtime:5.9123649597168 / seconds
Query Executed:select id FROM `va` where city='Orkney Springs' && SIC_code='8661'DB:business_master_new
loadtime:5.9128201007843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlean' limit 1
loadtime:5.9128861427307 / seconds
Query Executed:select id FROM `va` where city='Orlean' && SIC_code='8661'DB:business_master_new
loadtime:5.9134500026703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyster' limit 1
loadtime:5.9135839939117 / seconds
Query Executed:select id FROM `va` where city='Oyster' && SIC_code='8661'DB:business_master_new
loadtime:5.9140260219574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paeonian Springs' limit 1
loadtime:5.9140810966492 / seconds
Query Executed:select id FROM `va` where city='Paeonian Springs' && SIC_code='8661'DB:business_master_new
loadtime:5.9148991107941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Bank' limit 1
loadtime:5.9149529933929 / seconds
Query Executed:select id FROM `va` where city='Paint Bank' && SIC_code='8661'DB:business_master_new
loadtime:5.9154601097107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painter' limit 1
loadtime:5.9155120849609 / seconds
Query Executed:select id FROM `va` where city='Painter' && SIC_code='8661'DB:business_master_new
loadtime:5.9167630672455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:5.9168400764465 / seconds
Query Executed:select id FROM `va` where city='Palmyra' && SIC_code='8661'DB:business_master_new
loadtime:5.9220740795135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplin' limit 1
loadtime:5.9221661090851 / seconds
Query Executed:select id FROM `va` where city='Pamplin' && SIC_code='8661'DB:business_master_new
loadtime:5.9231810569763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:5.9232680797577 / seconds
Query Executed:select id FROM `va` where city='Paris' && SIC_code='8661'DB:business_master_new
loadtime:5.9239001274109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksley' limit 1
loadtime:5.9239730834961 / seconds
Query Executed:select id FROM `va` where city='Parksley' && SIC_code='8661'DB:business_master_new
loadtime:5.9260551929474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrott' limit 1
loadtime:5.926146030426 / seconds
Query Executed:select id FROM `va` where city='Parrott' && SIC_code='8661'DB:business_master_new
loadtime:5.926577091217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partlow' limit 1
loadtime:5.9266321659088 / seconds
Query Executed:select id FROM `va` where city='Partlow' && SIC_code='8661'DB:business_master_new
loadtime:5.9275419712067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick Springs' limit 1
loadtime:5.9276080131531 / seconds
Query Executed:select id FROM `va` where city='Patrick Springs' && SIC_code='8661'DB:business_master_new
loadtime:5.9288740158081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:5.928964138031 / seconds
Query Executed:select id FROM `va` where city='Patterson' && SIC_code='8661'DB:business_master_new
loadtime:5.9293930530548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearisburg' limit 1
loadtime:5.9294590950012 / seconds
Query Executed:select id FROM `va` where city='Pearisburg' && SIC_code='8661'DB:business_master_new
loadtime:5.93346118927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:5.9335629940033 / seconds
Query Executed:select id FROM `va` where city='Pembroke' && SIC_code='8661'DB:business_master_new
loadtime:5.9353330135345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penhook' limit 1
loadtime:5.9354250431061 / seconds
Query Executed:select id FROM `va` where city='Penhook' && SIC_code='8661'DB:business_master_new
loadtime:5.9367980957031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penn Laird' limit 1
loadtime:5.9368829727173 / seconds
Query Executed:select id FROM `va` where city='Penn Laird' && SIC_code='8661'DB:business_master_new
loadtime:5.9379231929779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington Gap' limit 1
loadtime:5.9380049705505 / seconds
Query Executed:select id FROM `va` where city='Pennington Gap' && SIC_code='8661'DB:business_master_new
loadtime:5.9414789676666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:5.9415721893311 / seconds
Query Executed:select id FROM `va` where city='Petersburg' && SIC_code='8661'DB:business_master_new
loadtime:5.9776201248169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix' limit 1
loadtime:5.9779760837555 / seconds
Query Executed:select id FROM `va` where city='Phenix' && SIC_code='8661'DB:business_master_new
loadtime:5.9787390232086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomont' limit 1
loadtime:5.9788379669189 / seconds
Query Executed:select id FROM `va` where city='Philomont' && SIC_code='8661'DB:business_master_new
loadtime:5.9793829917908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilgrims Knob' limit 1
loadtime:5.9794371128082 / seconds
Query Executed:select id FROM `va` where city='Pilgrims Knob' && SIC_code='8661'DB:business_master_new
loadtime:5.9798929691315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot' limit 1
loadtime:5.9799630641937 / seconds
Query Executed:select id FROM `va` where city='Pilot' && SIC_code='8661'DB:business_master_new
loadtime:5.9806959629059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney River' limit 1
loadtime:5.9807660579681 / seconds
Query Executed:select id FROM `va` where city='Piney River' && SIC_code='8661'DB:business_master_new
loadtime:5.9814901351929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:5.9815590381622 / seconds
Query Executed:select id FROM `va` where city='Pittsville' && SIC_code='8661'DB:business_master_new
loadtime:5.9821519851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain View' limit 1
loadtime:5.982253074646 / seconds
Query Executed:select id FROM `va` where city='Plain View' && SIC_code='8661'DB:business_master_new
loadtime:5.9826941490173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:5.9827601909637 / seconds
Query Executed:select id FROM `va` where city='Pleasant Valley' && SIC_code='8661'DB:business_master_new
loadtime:5.9832429885864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:5.9833090305328 / seconds
Query Executed:select id FROM `va` where city='Pocahontas' && SIC_code='8661'DB:business_master_new
loadtime:5.9840660095215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquoson' limit 1
loadtime:5.9841420650482 / seconds
Query Executed:select id FROM `va` where city='Poquoson' && SIC_code='8661'DB:business_master_new
loadtime:5.9890630245209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Haywood' limit 1
loadtime:5.9891510009766 / seconds
Query Executed:select id FROM `va` where city='Port Haywood' && SIC_code='8661'DB:business_master_new
loadtime:5.9898281097412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:5.9898841381073 / seconds
Query Executed:select id FROM `va` where city='Port Republic' && SIC_code='8661'DB:business_master_new
loadtime:5.9908981323242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:5.9909780025482 / seconds
Query Executed:select id FROM `va` where city='Port Royal' && SIC_code='8661'DB:business_master_new
loadtime:5.9918210506439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:5.9918920993805 / seconds
Query Executed:select id FROM `va` where city='Portsmouth' && SIC_code='8661'DB:business_master_new
loadtime:6.0422291755676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:6.0427360534668 / seconds
Query Executed:select id FROM `va` where city='Pound' && SIC_code='8661'DB:business_master_new
loadtime:6.0450730323792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pounding Mill' limit 1
loadtime:6.0452110767365 / seconds
Query Executed:select id FROM `va` where city='Pounding Mill' && SIC_code='8661'DB:business_master_new
loadtime:6.046816110611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:6.0468971729279 / seconds
Query Executed:select id FROM `va` where city='Powhatan' && SIC_code='8661'DB:business_master_new
loadtime:6.0565409660339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratts' limit 1
loadtime:6.0566720962524 / seconds
Query Executed:select id FROM `va` where city='Pratts' && SIC_code='8661'DB:business_master_new
loadtime:6.0572240352631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince George' limit 1
loadtime:6.0572850704193 / seconds
Query Executed:select id FROM `va` where city='Prince George' && SIC_code='8661'DB:business_master_new
loadtime:6.0612001419067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:6.0612921714783 / seconds
Query Executed:select id FROM `va` where city='Prospect' && SIC_code='8661'DB:business_master_new
loadtime:6.0623199939728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence Forge' limit 1
loadtime:6.0624051094055 / seconds
Query Executed:select id FROM `va` where city='Providence Forge' && SIC_code='8661'DB:business_master_new
loadtime:6.0648579597473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:6.0649380683899 / seconds
Query Executed:select id FROM `va` where city='Pulaski' && SIC_code='8661'DB:business_master_new
loadtime:6.0716769695282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pungoteague' limit 1
loadtime:6.0718381404877 / seconds
Query Executed:select id FROM `va` where city='Pungoteague' && SIC_code='8661'DB:business_master_new
loadtime:6.0724391937256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purcellville' limit 1
loadtime:6.072517156601 / seconds
Query Executed:select id FROM `va` where city='Purcellville' && SIC_code='8661'DB:business_master_new
loadtime:6.0814230442047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quantico' limit 1
loadtime:6.0815341472626 / seconds
Query Executed:select id FROM `va` where city='Quantico' && SIC_code='8661'DB:business_master_new
loadtime:6.0842871665955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quicksburg' limit 1
loadtime:6.0843451023102 / seconds
Query Executed:select id FROM `va` where city='Quicksburg' && SIC_code='8661'DB:business_master_new
loadtime:6.085244178772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:6.08531498909 / seconds
Query Executed:select id FROM `va` where city='Quinby' && SIC_code='8661'DB:business_master_new
loadtime:6.0858070850372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinque' limit 1
loadtime:6.085862159729 / seconds
Query Executed:select id FROM `va` where city='Quinque' && SIC_code='8661'DB:business_master_new
loadtime:6.0864260196686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:6.0864939689636 / seconds
Query Executed:select id FROM `va` where city='Quinton' && SIC_code='8661'DB:business_master_new
loadtime:6.0894291400909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radford' limit 1
loadtime:6.0895080566406 / seconds
Query Executed:select id FROM `va` where city='Radford' && SIC_code='8661'DB:business_master_new
loadtime:6.0996870994568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radiant' limit 1
loadtime:6.0998561382294 / seconds
Query Executed:select id FROM `va` where city='Radiant' && SIC_code='8661'DB:business_master_new
loadtime:6.1004061698914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:6.1004819869995 / seconds
Query Executed:select id FROM `va` where city='Randolph' && SIC_code='8661'DB:business_master_new
loadtime:6.1010301113129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raphine' limit 1
loadtime:6.1010971069336 / seconds
Query Executed:select id FROM `va` where city='Raphine' && SIC_code='8661'DB:business_master_new
loadtime:6.1024050712585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapidan' limit 1
loadtime:6.1024770736694 / seconds
Query Executed:select id FROM `va` where city='Rapidan' && SIC_code='8661'DB:business_master_new
loadtime:6.1034550666809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Academy' limit 1
loadtime:6.1035270690918 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Academy' && SIC_code='8661'DB:business_master_new
loadtime:6.1040661334991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Acd' limit 1
loadtime:6.1041209697723 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Acd' && SIC_code='8661'DB:business_master_new
loadtime:6.1045541763306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raven' limit 1
loadtime:6.1046040058136 / seconds
Query Executed:select id FROM `va` where city='Raven' && SIC_code='8661'DB:business_master_new
loadtime:6.1055300235748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlings' limit 1
loadtime:6.1056070327759 / seconds
Query Executed:select id FROM `va` where city='Rawlings' && SIC_code='8661'DB:business_master_new
loadtime:6.1061511039734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rectortown' limit 1
loadtime:6.1062180995941 / seconds
Query Executed:select id FROM `va` where city='Rectortown' && SIC_code='8661'DB:business_master_new
loadtime:6.1066830158234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Ash' limit 1
loadtime:6.1067490577698 / seconds
Query Executed:select id FROM `va` where city='Red Ash' && SIC_code='8661'DB:business_master_new
loadtime:6.1071619987488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:6.1072261333466 / seconds
Query Executed:select id FROM `va` where city='Red House' && SIC_code='8661'DB:business_master_new
loadtime:6.1077761650085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:6.1078541278839 / seconds
Query Executed:select id FROM `va` where city='Red Oak' && SIC_code='8661'DB:business_master_new
loadtime:6.1087021827698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redart' limit 1
loadtime:6.108775138855 / seconds
Query Executed:select id FROM `va` where city='Redart' && SIC_code='8661'DB:business_master_new
loadtime:6.1092250347137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:6.1092801094055 / seconds
Query Executed:select id FROM `va` where city='Redwood' && SIC_code='8661'DB:business_master_new
loadtime:6.1098001003265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedville' limit 1
loadtime:6.1098530292511 / seconds
Query Executed:select id FROM `va` where city='Reedville' && SIC_code='8661'DB:business_master_new
loadtime:6.1116950511932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:6.11177110672 / seconds
Query Executed:select id FROM `va` where city='Reliance' && SIC_code='8661'DB:business_master_new
loadtime:6.1122109889984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remington' limit 1
loadtime:6.1122660636902 / seconds
Query Executed:select id FROM `va` where city='Remington' && SIC_code='8661'DB:business_master_new
loadtime:6.1142010688782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republican Grove' limit 1
loadtime:6.1142790317535 / seconds
Query Executed:select id FROM `va` where city='Republican Grove' && SIC_code='8661'DB:business_master_new
loadtime:6.1147050857544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rescue' limit 1
loadtime:6.1147589683533 / seconds
Query Executed:select id FROM `va` where city='Rescue' && SIC_code='8661'DB:business_master_new
loadtime:6.1152441501617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reston' limit 1
loadtime:6.1153101921082 / seconds
Query Executed:select id FROM `va` where city='Reston' && SIC_code='8661'DB:business_master_new
loadtime:6.166344165802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:6.1665110588074 / seconds
Query Executed:select id FROM `va` where city='Reva' && SIC_code='8661'DB:business_master_new
loadtime:6.1674599647522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhoadesville' limit 1
loadtime:6.1675341129303 / seconds
Query Executed:select id FROM `va` where city='Rhoadesville' && SIC_code='8661'DB:business_master_new
loadtime:6.1685020923615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:6.168576002121 / seconds
Query Executed:select id FROM `va` where city='Rice' && SIC_code='8661'DB:business_master_new
loadtime:6.1694440841675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Creek' limit 1
loadtime:6.1695289611816 / seconds
Query Executed:select id FROM `va` where city='Rich Creek' && SIC_code='8661'DB:business_master_new
loadtime:6.1707201004028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richardsville' limit 1
loadtime:6.1708040237427 / seconds
Query Executed:select id FROM `va` where city='Richardsville' && SIC_code='8661'DB:business_master_new
loadtime:6.1714091300964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:6.1714780330658 / seconds
Query Executed:select id FROM `va` where city='Richlands' && SIC_code='8661'DB:business_master_new
loadtime:6.1769161224365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:6.1770401000977 / seconds
Query Executed:select id FROM `va` where city='Richmond' && SIC_code='8661'DB:business_master_new
loadtime:6.413115978241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:6.4144661426544 / seconds
Query Executed:select id FROM `va` where city='Ridgeway' && SIC_code='8661'DB:business_master_new
loadtime:6.4184000492096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rileyville' limit 1
loadtime:6.4186251163483 / seconds
Query Executed:select id FROM `va` where city='Rileyville' && SIC_code='8661'DB:business_master_new
loadtime:6.4193830490112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riner' limit 1
loadtime:6.419459104538 / seconds
Query Executed:select id FROM `va` where city='Riner' && SIC_code='8661'DB:business_master_new
loadtime:6.4208500385284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringgold' limit 1
loadtime:6.4209361076355 / seconds
Query Executed:select id FROM `va` where city='Ringgold' && SIC_code='8661'DB:business_master_new
loadtime:6.4230329990387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripplemead' limit 1
loadtime:6.4231371879578 / seconds
Query Executed:select id FROM `va` where city='Ripplemead' && SIC_code='8661'DB:business_master_new
loadtime:6.423840045929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:6.4238991737366 / seconds
Query Executed:select id FROM `va` where city='Riverton' && SIC_code='8661'DB:business_master_new
loadtime:6.4243350028992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rixeyville' limit 1
loadtime:6.4243881702423 / seconds
Query Executed:select id FROM `va` where city='Rixeyville' && SIC_code='8661'DB:business_master_new
loadtime:6.4258241653442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:6.4259030818939 / seconds
Query Executed:select id FROM `va` where city='Roanoke' && SIC_code='8661'DB:business_master_new
loadtime:6.5394830703735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle' limit 1
loadtime:6.5403439998627 / seconds
Query Executed:select id FROM `va` where city='Rochelle' && SIC_code='8661'DB:business_master_new
loadtime:6.5412821769714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockbridge Baths' limit 1
loadtime:6.5414021015167 / seconds
Query Executed:select id FROM `va` where city='Rockbridge Baths' && SIC_code='8661'DB:business_master_new
loadtime:6.542090177536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:6.5421571731567 / seconds
Query Executed:select id FROM `va` where city='Rockville' && SIC_code='8661'DB:business_master_new
loadtime:6.5444800853729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Gap' limit 1
loadtime:6.5445551872253 / seconds
Query Executed:select id FROM `va` where city='Rocky Gap' && SIC_code='8661'DB:business_master_new
loadtime:6.5454750061035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:6.5455560684204 / seconds
Query Executed:select id FROM `va` where city='Rocky Mount' && SIC_code='8661'DB:business_master_new
loadtime:6.6840541362762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollins Fork' limit 1
loadtime:6.6843349933624 / seconds
Query Executed:select id FROM `va` where city='Rollins Fork' && SIC_code='8661'DB:business_master_new
loadtime:6.6849050521851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:6.6849751472473 / seconds
Query Executed:select id FROM `va` where city='Rose Hill' && SIC_code='8661'DB:business_master_new
loadtime:6.6862089633942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:6.6862890720367 / seconds
Query Executed:select id FROM `va` where city='Rosedale' && SIC_code='8661'DB:business_master_new
loadtime:6.687304019928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:6.6873769760132 / seconds
Query Executed:select id FROM `va` where city='Roseland' && SIC_code='8661'DB:business_master_new
loadtime:6.6886520385742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Hill' limit 1
loadtime:6.6887321472168 / seconds
Query Executed:select id FROM `va` where city='Round Hill' && SIC_code='8661'DB:business_master_new
loadtime:6.6910481452942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:6.6911311149597 / seconds
Query Executed:select id FROM `va` where city='Rowe' && SIC_code='8661'DB:business_master_new
loadtime:6.6915600299835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:6.6916151046753 / seconds
Query Executed:select id FROM `va` where city='Ruby' && SIC_code='8661'DB:business_master_new
loadtime:6.6920921802521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruckersville' limit 1
loadtime:6.6921451091766 / seconds
Query Executed:select id FROM `va` where city='Ruckersville' && SIC_code='8661'DB:business_master_new
loadtime:6.6966631412506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Retreat' limit 1
loadtime:6.6967670917511 / seconds
Query Executed:select id FROM `va` where city='Rural Retreat' && SIC_code='8661'DB:business_master_new
loadtime:6.6989979743958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rustburg' limit 1
loadtime:6.699079990387 / seconds
Query Executed:select id FROM `va` where city='Rustburg' && SIC_code='8661'DB:business_master_new
loadtime:6.7036900520325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruther Glen' limit 1
loadtime:6.703812122345 / seconds
Query Executed:select id FROM `va` where city='Ruther Glen' && SIC_code='8661'DB:business_master_new
loadtime:6.7073361873627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthville' limit 1
loadtime:6.7074391841888 / seconds
Query Executed:select id FROM `va` where city='Ruthville' && SIC_code='8661'DB:business_master_new
loadtime:6.7079529762268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:6.7080271244049 / seconds
Query Executed:select id FROM `va` where city='Saint Charles' && SIC_code='8661'DB:business_master_new
loadtime:6.7086751461029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:6.7087790966034 / seconds
Query Executed:select id FROM `va` where city='Saint Paul' && SIC_code='8661'DB:business_master_new
loadtime:6.7106170654297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens Church' limit 1
loadtime:6.7107579708099 / seconds
Query Executed:select id FROM `va` where city='Saint Stephens Church' && SIC_code='8661'DB:business_master_new
loadtime:6.7115969657898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:6.7116661071777 / seconds
Query Executed:select id FROM `va` where city='Salem' && SIC_code='8661'DB:business_master_new
loadtime:6.7449631690979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltville' limit 1
loadtime:6.7452261447906 / seconds
Query Executed:select id FROM `va` where city='Saltville' && SIC_code='8661'DB:business_master_new
loadtime:6.7476830482483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:6.7478001117706 / seconds
Query Executed:select id FROM `va` where city='Saluda' && SIC_code='8661'DB:business_master_new
loadtime:6.7505249977112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandston' limit 1
loadtime:6.7506141662598 / seconds
Query Executed:select id FROM `va` where city='Sandston' && SIC_code='8661'DB:business_master_new
loadtime:6.7565050125122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:6.7566010951996 / seconds
Query Executed:select id FROM `va` where city='Sandy Hook' && SIC_code='8661'DB:business_master_new
loadtime:6.7572431564331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Level' limit 1
loadtime:6.757315158844 / seconds
Query Executed:select id FROM `va` where city='Sandy Level' && SIC_code='8661'DB:business_master_new
loadtime:6.7579030990601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Point' limit 1
loadtime:6.7579760551453 / seconds
Query Executed:select id FROM `va` where city='Sandy Point' && SIC_code='8661'DB:business_master_new
loadtime:6.7584340572357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:6.7584881782532 / seconds
Query Executed:select id FROM `va` where city='Sanford' && SIC_code='8661'DB:business_master_new
loadtime:6.7590100765228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxe' limit 1
loadtime:6.7590770721436 / seconds
Query Executed:select id FROM `va` where city='Saxe' && SIC_code='8661'DB:business_master_new
loadtime:6.7596969604492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxis' limit 1
loadtime:6.7597711086273 / seconds
Query Executed:select id FROM `va` where city='Saxis' && SIC_code='8661'DB:business_master_new
loadtime:6.7603340148926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schley' limit 1
loadtime:6.7603871822357 / seconds
Query Executed:select id FROM `va` where city='Schley' && SIC_code='8661'DB:business_master_new
loadtime:6.7608649730682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schuyler' limit 1
loadtime:6.760931968689 / seconds
Query Executed:select id FROM `va` where city='Schuyler' && SIC_code='8661'DB:business_master_new
loadtime:6.7617900371552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:6.761871099472 / seconds
Query Executed:select id FROM `va` where city='Scottsburg' && SIC_code='8661'DB:business_master_new
loadtime:6.7631261348724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsville' limit 1
loadtime:6.7632071971893 / seconds
Query Executed:select id FROM `va` where city='Scottsville' && SIC_code='8661'DB:business_master_new
loadtime:6.7665741443634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaford' limit 1
loadtime:6.766674041748 / seconds
Query Executed:select id FROM `va` where city='Seaford' && SIC_code='8661'DB:business_master_new
loadtime:6.7683310508728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealston' limit 1
loadtime:6.7684099674225 / seconds
Query Executed:select id FROM `va` where city='Sealston' && SIC_code='8661'DB:business_master_new
loadtime:6.7688381671906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:6.7688930034637 / seconds
Query Executed:select id FROM `va` where city='Seaview' && SIC_code='8661'DB:business_master_new
loadtime:6.7693409919739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedley' limit 1
loadtime:6.7693929672241 / seconds
Query Executed:select id FROM `va` where city='Sedley' && SIC_code='8661'DB:business_master_new
loadtime:6.770476102829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:6.7705509662628 / seconds
Query Executed:select id FROM `va` where city='Selma' && SIC_code='8661'DB:business_master_new
loadtime:6.7713260650635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Corners' limit 1
loadtime:6.7713949680328 / seconds
Query Executed:select id FROM `va` where city='Seven Corners' && SIC_code='8661'DB:business_master_new
loadtime:6.7719640731812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Mile Ford' limit 1
loadtime:6.7720220088959 / seconds
Query Executed:select id FROM `va` where city='Seven Mile Ford' && SIC_code='8661'DB:business_master_new
loadtime:6.7725729942322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:6.7726299762726 / seconds
Query Executed:select id FROM `va` where city='Severn' && SIC_code='8661'DB:business_master_new
loadtime:6.7732121944427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shacklefords' limit 1
loadtime:6.7732670307159 / seconds
Query Executed:select id FROM `va` where city='Shacklefords' && SIC_code='8661'DB:business_master_new
loadtime:6.7744941711426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharps' limit 1
loadtime:6.7745640277863 / seconds
Query Executed:select id FROM `va` where city='Sharps' && SIC_code='8661'DB:business_master_new
loadtime:6.7751200199127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawsville' limit 1
loadtime:6.7751870155334 / seconds
Query Executed:select id FROM `va` where city='Shawsville' && SIC_code='8661'DB:business_master_new
loadtime:6.77654504776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:6.7766351699829 / seconds
Query Executed:select id FROM `va` where city='Shelby' && SIC_code='8661'DB:business_master_new
loadtime:6.7771031856537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:6.7772731781006 / seconds
Query Executed:select id FROM `va` where city='Shenandoah' && SIC_code='8661'DB:business_master_new
loadtime:6.7796859741211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Cvrns' limit 1
loadtime:6.779806137085 / seconds
Query Executed:select id FROM `va` where city='Shenandoah Cvrns' && SIC_code='8661'DB:business_master_new
loadtime:6.7802400588989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherando' limit 1
loadtime:6.7802991867065 / seconds
Query Executed:select id FROM `va` where city='Sherando' && SIC_code='8661'DB:business_master_new
loadtime:6.7807471752167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:6.7808129787445 / seconds
Query Executed:select id FROM `va` where city='Shiloh' && SIC_code='8661'DB:business_master_new
loadtime:6.7812311649323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shipman' limit 1
loadtime:6.7812881469727 / seconds
Query Executed:select id FROM `va` where city='Shipman' && SIC_code='8661'DB:business_master_new
loadtime:6.7821500301361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shortt Gap' limit 1
loadtime:6.7822201251984 / seconds
Query Executed:select id FROM `va` where city='Shortt Gap' && SIC_code='8661'DB:business_master_new
loadtime:6.7825930118561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Singers Glen' limit 1
loadtime:6.7826581001282 / seconds
Query Executed:select id FROM `va` where city='Singers Glen' && SIC_code='8661'DB:business_master_new
loadtime:6.78329205513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skippers' limit 1
loadtime:6.7833631038666 / seconds
Query Executed:select id FROM `va` where city='Skippers' && SIC_code='8661'DB:business_master_new
loadtime:6.7843930721283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipwith' limit 1
loadtime:6.7844610214233 / seconds
Query Executed:select id FROM `va` where city='Skipwith' && SIC_code='8661'DB:business_master_new
loadtime:6.7855470180511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:6.7856180667877 / seconds
Query Executed:select id FROM `va` where city='Smithfield' && SIC_code='8661'DB:business_master_new
loadtime:6.9265761375427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snell' limit 1
loadtime:6.926784992218 / seconds
Query Executed:select id FROM `va` where city='Snell' && SIC_code='8661'DB:business_master_new
loadtime:6.9271891117096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:6.9272520542145 / seconds
Query Executed:select id FROM `va` where city='Somerset' && SIC_code='8661'DB:business_master_new
loadtime:6.9278390407562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:6.9279141426086 / seconds
Query Executed:select id FROM `va` where city='Somerville' && SIC_code='8661'DB:business_master_new
loadtime:6.9282891750336 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:6.9283430576324 / seconds
Query Executed:select id FROM `va` where city='South Boston' && SIC_code='8661'DB:business_master_new
loadtime:7.0659351348877 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hill' limit 1
loadtime:7.0662519931793 / seconds
Query Executed:select id FROM `va` where city='South Hill' && SIC_code='8661'DB:business_master_new
loadtime:7.0738730430603 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Riding' limit 1
loadtime:7.0740489959717 / seconds
Query Executed:select id FROM `va` where city='South Riding' && SIC_code='8661'DB:business_master_new
loadtime:7.0745131969452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:7.0745761394501 / seconds
Query Executed:select id FROM `va` where city='Sparta' && SIC_code='8661'DB:business_master_new
loadtime:7.0750381946564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speedwell' limit 1
loadtime:7.0751051902771 / seconds
Query Executed:select id FROM `va` where city='Speedwell' && SIC_code='8661'DB:business_master_new
loadtime:7.0757410526276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:7.0758101940155 / seconds
Query Executed:select id FROM `va` where city='Spencer' && SIC_code='8661'DB:business_master_new
loadtime:7.0769510269165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperryville' limit 1
loadtime:7.0770301818848 / seconds
Query Executed:select id FROM `va` where city='Sperryville' && SIC_code='8661'DB:business_master_new
loadtime:7.0783979892731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotsylvania' limit 1
loadtime:7.07847905159 / seconds
Query Executed:select id FROM `va` where city='Spotsylvania' && SIC_code='8661'DB:business_master_new
loadtime:7.2140901088715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spout Spring' limit 1
loadtime:7.2142989635468 / seconds
Query Executed:select id FROM `va` where city='Spout Spring' && SIC_code='8661'DB:business_master_new
loadtime:7.2153091430664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Grove' limit 1
loadtime:7.2153911590576 / seconds
Query Executed:select id FROM `va` where city='Spring Grove' && SIC_code='8661'DB:business_master_new
loadtime:7.2161619663239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:7.216236114502 / seconds
Query Executed:select id FROM `va` where city='Springfield' && SIC_code='8661'DB:business_master_new
loadtime:7.2762310504913 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:7.2765190601349 / seconds
Query Executed:select id FROM `va` where city='St Charles' && SIC_code='8661'DB:business_master_new
loadtime:7.2770390510559 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:7.2771179676056 / seconds
Query Executed:select id FROM `va` where city='St Paul' && SIC_code='8661'DB:business_master_new
loadtime:7.2775230407715 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens Chr' limit 1
loadtime:7.2775771617889 / seconds
Query Executed:select id FROM `va` where city='St Stephens Chr' && SIC_code='8661'DB:business_master_new
loadtime:7.2779831886292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:7.2780380249023 / seconds
Query Executed:select id FROM `va` where city='Stafford' && SIC_code='8661'DB:business_master_new
loadtime:7.3097500801086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordsville' limit 1
loadtime:7.3099200725555 / seconds
Query Executed:select id FROM `va` where city='Staffordsville' && SIC_code='8661'DB:business_master_new
loadtime:7.3104000091553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanardsville' limit 1
loadtime:7.3104741573334 / seconds
Query Executed:select id FROM `va` where city='Stanardsville' && SIC_code='8661'DB:business_master_new
loadtime:7.3135430812836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:7.3136351108551 / seconds
Query Executed:select id FROM `va` where city='Stanley' && SIC_code='8661'DB:business_master_new
loadtime:7.3162581920624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanleytown' limit 1
loadtime:7.316358089447 / seconds
Query Executed:select id FROM `va` where city='Stanleytown' && SIC_code='8661'DB:business_master_new
loadtime:7.317193031311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Tannery' limit 1
loadtime:7.3172659873962 / seconds
Query Executed:select id FROM `va` where city='Star Tannery' && SIC_code='8661'DB:business_master_new
loadtime:7.3178551197052 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Farm' limit 1
loadtime:7.3179249763489 / seconds
Query Executed:select id FROM `va` where city='State Farm' && SIC_code='8661'DB:business_master_new
loadtime:7.3183960914612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staunton' limit 1
loadtime:7.3184480667114 / seconds
Query Executed:select id FROM `va` where city='Staunton' && SIC_code='8661'DB:business_master_new
loadtime:7.3499441146851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steeles Tavern' limit 1
loadtime:7.3502011299133 / seconds
Query Executed:select id FROM `va` where city='Steeles Tavern' && SIC_code='8661'DB:business_master_new
loadtime:7.3507480621338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephens City' limit 1
loadtime:7.3508310317993 / seconds
Query Executed:select id FROM `va` where city='Stephens City' && SIC_code='8661'DB:business_master_new
loadtime:7.3559131622314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:7.3560121059418 / seconds
Query Executed:select id FROM `va` where city='Stephenson' && SIC_code='8661'DB:business_master_new
loadtime:7.3571140766144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:7.3571891784668 / seconds
Query Executed:select id FROM `va` where city='Sterling' && SIC_code='8661'DB:business_master_new
loadtime:7.4144990444183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensburg' limit 1
loadtime:7.4147109985352 / seconds
Query Executed:select id FROM `va` where city='Stevensburg' && SIC_code='8661'DB:business_master_new
loadtime:7.4152770042419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:7.4153530597687 / seconds
Query Executed:select id FROM `va` where city='Stevensville' && SIC_code='8661'DB:business_master_new
loadtime:7.4157950878143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Ridge' limit 1
loadtime:7.4158601760864 / seconds
Query Executed:select id FROM `va` where city='Stone Ridge' && SIC_code='8661'DB:business_master_new
loadtime:7.4162361621857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonega' limit 1
loadtime:7.4162921905518 / seconds
Query Executed:select id FROM `va` where city='Stonega' && SIC_code='8661'DB:business_master_new
loadtime:7.4166581630707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Creek' limit 1
loadtime:7.4167170524597 / seconds
Query Executed:select id FROM `va` where city='Stony Creek' && SIC_code='8661'DB:business_master_new
loadtime:7.4182970523834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:7.4183871746063 / seconds
Query Executed:select id FROM `va` where city='Strasburg' && SIC_code='8661'DB:business_master_new
loadtime:7.4230890274048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:7.4231970310211 / seconds
Query Executed:select id FROM `va` where city='Stratford' && SIC_code='8661'DB:business_master_new
loadtime:7.4236030578613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:7.4236600399017 / seconds
Query Executed:select id FROM `va` where city='Stuart' && SIC_code='8661'DB:business_master_new
loadtime:7.4288561344147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuarts Draft' limit 1
loadtime:7.4289860725403 / seconds
Query Executed:select id FROM `va` where city='Stuarts Draft' && SIC_code='8661'DB:business_master_new
loadtime:7.4332180023193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:7.433324098587 / seconds
Query Executed:select id FROM `va` where city='Studley' && SIC_code='8661'DB:business_master_new
loadtime:7.4341640472412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffolk' limit 1
loadtime:7.4342350959778 / seconds
Query Executed:select id FROM `va` where city='Suffolk' && SIC_code='8661'DB:business_master_new
loadtime:7.5757219791412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:7.5762021541595 / seconds
Query Executed:select id FROM `va` where city='Sugar Grove' && SIC_code='8661'DB:business_master_new
loadtime:7.5771219730377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerduck' limit 1
loadtime:7.5772190093994 / seconds
Query Executed:select id FROM `va` where city='Sumerduck' && SIC_code='8661'DB:business_master_new
loadtime:7.5781960487366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:7.5782661437988 / seconds
Query Executed:select id FROM `va` where city='Supply' && SIC_code='8661'DB:business_master_new
loadtime:7.5786471366882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:7.5787010192871 / seconds
Query Executed:select id FROM `va` where city='Surry' && SIC_code='8661'DB:business_master_new
loadtime:7.5807440280914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susan' limit 1
loadtime:7.5808529853821 / seconds
Query Executed:select id FROM `va` where city='Susan' && SIC_code='8661'DB:business_master_new
loadtime:7.5813171863556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:7.5813891887665 / seconds
Query Executed:select id FROM `va` where city='Sussex' && SIC_code='8661'DB:business_master_new
loadtime:7.581964969635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:7.5820331573486 / seconds
Query Executed:select id FROM `va` where city='Sutherland' && SIC_code='8661'DB:business_master_new
loadtime:7.5832240581512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:7.5832970142365 / seconds
Query Executed:select id FROM `va` where city='Sutherlin' && SIC_code='8661'DB:business_master_new
loadtime:7.584233045578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Briar' limit 1
loadtime:7.5843081474304 / seconds
Query Executed:select id FROM `va` where city='Sweet Briar' && SIC_code='8661'DB:business_master_new
loadtime:7.5848140716553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swoope' limit 1
loadtime:7.584869146347 / seconds
Query Executed:select id FROM `va` where city='Swoope' && SIC_code='8661'DB:business_master_new
loadtime:7.585764169693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swords Creek' limit 1
loadtime:7.5858430862427 / seconds
Query Executed:select id FROM `va` where city='Swords Creek' && SIC_code='8661'DB:business_master_new
loadtime:7.5866341590881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syria' limit 1
loadtime:7.5867121219635 / seconds
Query Executed:select id FROM `va` where city='Syria' && SIC_code='8661'DB:business_master_new
loadtime:7.5872461795807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syringa' limit 1
loadtime:7.5873010158539 / seconds
Query Executed:select id FROM `va` where city='Syringa' && SIC_code='8661'DB:business_master_new
loadtime:7.5877590179443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabb' limit 1
loadtime:7.5878200531006 / seconds
Query Executed:select id FROM `va` where city='Tabb' && SIC_code='8661'DB:business_master_new
loadtime:7.5883791446686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangier' limit 1
loadtime:7.5884320735931 / seconds
Query Executed:select id FROM `va` where city='Tangier' && SIC_code='8661'DB:business_master_new
loadtime:7.5891480445862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tannersville' limit 1
loadtime:7.5892150402069 / seconds
Query Executed:select id FROM `va` where city='Tannersville' && SIC_code='8661'DB:business_master_new
loadtime:7.5896580219269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tappahannock' limit 1
loadtime:7.589723110199 / seconds
Query Executed:select id FROM `va` where city='Tappahannock' && SIC_code='8661'DB:business_master_new
loadtime:7.5963621139526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tasley' limit 1
loadtime:7.5964641571045 / seconds
Query Executed:select id FROM `va` where city='Tasley' && SIC_code='8661'DB:business_master_new
loadtime:7.5973379611969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tazewell' limit 1
loadtime:7.5974140167236 / seconds
Query Executed:select id FROM `va` where city='Tazewell' && SIC_code='8661'DB:business_master_new
loadtime:7.6020221710205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperanceville' limit 1
loadtime:7.6021339893341 / seconds
Query Executed:select id FROM `va` where city='Temperanceville' && SIC_code='8661'DB:business_master_new
loadtime:7.6030130386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:7.6030950546265 / seconds
Query Executed:select id FROM `va` where city='Thaxton' && SIC_code='8661'DB:business_master_new
loadtime:7.6041760444641 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Plains' limit 1
loadtime:7.6042530536652 / seconds
Query Executed:select id FROM `va` where city='The Plains' && SIC_code='8661'DB:business_master_new
loadtime:7.6062321662903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:7.6063051223755 / seconds
Query Executed:select id FROM `va` where city='Thornburg' && SIC_code='8661'DB:business_master_new
loadtime:7.6071400642395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberville' limit 1
loadtime:7.6071951389313 / seconds
Query Executed:select id FROM `va` where city='Timberville' && SIC_code='8661'DB:business_master_new
loadtime:7.6094169616699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toano' limit 1
loadtime:7.6095089912415 / seconds
Query Executed:select id FROM `va` where city='Toano' && SIC_code='8661'DB:business_master_new
loadtime:7.6123621463776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms Brook' limit 1
loadtime:7.6124451160431 / seconds
Query Executed:select id FROM `va` where city='Toms Brook' && SIC_code='8661'DB:business_master_new
loadtime:7.6136829853058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topping' limit 1
loadtime:7.613765001297 / seconds
Query Executed:select id FROM `va` where city='Topping' && SIC_code='8661'DB:business_master_new
loadtime:7.6149241924286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:7.6150031089783 / seconds
Query Executed:select id FROM `va` where city='Townsend' && SIC_code='8661'DB:business_master_new
loadtime:7.6155171394348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trammel' limit 1
loadtime:7.6155831813812 / seconds
Query Executed:select id FROM `va` where city='Trammel' && SIC_code='8661'DB:business_master_new
loadtime:7.6160380840302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevilians' limit 1
loadtime:7.6160931587219 / seconds
Query Executed:select id FROM `va` where city='Trevilians' && SIC_code='8661'DB:business_master_new
loadtime:7.6165611743927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triangle' limit 1
loadtime:7.6166121959686 / seconds
Query Executed:select id FROM `va` where city='Triangle' && SIC_code='8661'DB:business_master_new
loadtime:7.6194880008698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triplet' limit 1
loadtime:7.6195750236511 / seconds
Query Executed:select id FROM `va` where city='Triplet' && SIC_code='8661'DB:business_master_new
loadtime:7.6199910640717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Dale' limit 1
loadtime:7.6200461387634 / seconds
Query Executed:select id FROM `va` where city='Trout Dale' && SIC_code='8661'DB:business_master_new
loadtime:7.6204409599304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:7.620491027832 / seconds
Query Executed:select id FROM `va` where city='Troutdale' && SIC_code='8661'DB:business_master_new
loadtime:7.6212899684906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutville' limit 1
loadtime:7.6213600635529 / seconds
Query Executed:select id FROM `va` where city='Troutville' && SIC_code='8661'DB:business_master_new
loadtime:7.6251931190491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:7.6252901554108 / seconds
Query Executed:select id FROM `va` where city='Troy' && SIC_code='8661'DB:business_master_new
loadtime:7.6272871494293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:7.6273629665375 / seconds
Query Executed:select id FROM `va` where city='Turbeville' && SIC_code='8661'DB:business_master_new
loadtime:7.6277420520782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:7.6278171539307 / seconds
Query Executed:select id FROM `va` where city='Tyro' && SIC_code='8661'DB:business_master_new
loadtime:7.6282980442047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Hall' limit 1
loadtime:7.6283640861511 / seconds
Query Executed:select id FROM `va` where city='Union Hall' && SIC_code='8661'DB:business_master_new
loadtime:7.6294140815735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:7.6294820308685 / seconds
Query Executed:select id FROM `va` where city='Unionville' && SIC_code='8661'DB:business_master_new
loadtime:7.6306920051575 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Of Richmond' limit 1
loadtime:7.6307671070099 / seconds
Query Executed:select id FROM `va` where city='University Of Richmond' && SIC_code='8661'DB:business_master_new
loadtime:7.6311981678009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperville' limit 1
loadtime:7.6312530040741 / seconds
Query Executed:select id FROM `va` where city='Upperville' && SIC_code='8661'DB:business_master_new
loadtime:7.6325771808624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbanna' limit 1
loadtime:7.6326510906219 / seconds
Query Executed:select id FROM `va` where city='Urbanna' && SIC_code='8661'DB:business_master_new
loadtime:7.6348521709442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentines' limit 1
loadtime:7.6349310874939 / seconds
Query Executed:select id FROM `va` where city='Valentines' && SIC_code='8661'DB:business_master_new
loadtime:7.6355149745941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vansant' limit 1
loadtime:7.6355881690979 / seconds
Query Executed:select id FROM `va` where city='Vansant' && SIC_code='8661'DB:business_master_new
loadtime:7.6375119686127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Hill' limit 1
loadtime:7.6375911235809 / seconds
Query Executed:select id FROM `va` where city='Vernon Hill' && SIC_code='8661'DB:business_master_new
loadtime:7.6382479667664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:7.6383199691772 / seconds
Query Executed:select id FROM `va` where city='Verona' && SIC_code='8661'DB:business_master_new
loadtime:7.6419310569763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesta' limit 1
loadtime:7.6420211791992 / seconds
Query Executed:select id FROM `va` where city='Vesta' && SIC_code='8661'DB:business_master_new
loadtime:7.6425039768219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesuvius' limit 1
loadtime:7.6425580978394 / seconds
Query Executed:select id FROM `va` where city='Vesuvius' && SIC_code='8661'DB:business_master_new
loadtime:7.643177986145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:7.6432461738586 / seconds
Query Executed:select id FROM `va` where city='Victoria' && SIC_code='8661'DB:business_master_new
loadtime:7.6453649997711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:7.6454629898071 / seconds
Query Executed:select id FROM `va` where city='Vienna' && SIC_code='8661'DB:business_master_new
loadtime:7.7082550525665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viewtown' limit 1
loadtime:7.708477973938 / seconds
Query Executed:select id FROM `va` where city='Viewtown' && SIC_code='8661'DB:business_master_new
loadtime:7.7089841365814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village' limit 1
loadtime:7.7090480327606 / seconds
Query Executed:select id FROM `va` where city='Village' && SIC_code='8661'DB:business_master_new
loadtime:7.709545135498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villamont' limit 1
loadtime:7.7096121311188 / seconds
Query Executed:select id FROM `va` where city='Villamont' && SIC_code='8661'DB:business_master_new
loadtime:7.7100021839142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vint Hill Farms' limit 1
loadtime:7.7100560665131 / seconds
Query Executed:select id FROM `va` where city='Vint Hill Farms' && SIC_code='8661'DB:business_master_new
loadtime:7.7104020118713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:7.7104539871216 / seconds
Query Executed:select id FROM `va` where city='Vinton' && SIC_code='8661'DB:business_master_new
loadtime:7.8485469818115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgilina' limit 1
loadtime:7.8487751483917 / seconds
Query Executed:select id FROM `va` where city='Virgilina' && SIC_code='8661'DB:business_master_new
loadtime:7.8500800132751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virginia Beach' limit 1
loadtime:7.8501741886139 / seconds
Query Executed:select id FROM `va` where city='Virginia Beach' && SIC_code='8661'DB:business_master_new
loadtime:8.0629420280457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wachapreague' limit 1
loadtime:8.0638360977173 / seconds
Query Executed:select id FROM `va` where city='Wachapreague' && SIC_code='8661'DB:business_master_new
loadtime:8.0646741390228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake' limit 1
loadtime:8.0648050308228 / seconds
Query Executed:select id FROM `va` where city='Wake' && SIC_code='8661'DB:business_master_new
loadtime:8.0652899742126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:8.0653471946716 / seconds
Query Executed:select id FROM `va` where city='Wakefield' && SIC_code='8661'DB:business_master_new
loadtime:8.0669419765472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerton' limit 1
loadtime:8.0670311450958 / seconds
Query Executed:select id FROM `va` where city='Walkerton' && SIC_code='8661'DB:business_master_new
loadtime:8.0676779747009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallops Island' limit 1
loadtime:8.0677411556244 / seconds
Query Executed:select id FROM `va` where city='Wallops Island' && SIC_code='8661'DB:business_master_new
loadtime:8.0685331821442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walters' limit 1
loadtime:8.0685861110687 / seconds
Query Executed:select id FROM `va` where city='Walters' && SIC_code='8661'DB:business_master_new
loadtime:8.0690221786499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardtown' limit 1
loadtime:8.0690751075745 / seconds
Query Executed:select id FROM `va` where city='Wardtown' && SIC_code='8661'DB:business_master_new
loadtime:8.0694830417633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Neck' limit 1
loadtime:8.0695331096649 / seconds
Query Executed:select id FROM `va` where city='Ware Neck' && SIC_code='8661'DB:business_master_new
loadtime:8.0700659751892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warfield' limit 1
loadtime:8.0701329708099 / seconds
Query Executed:select id FROM `va` where city='Warfield' && SIC_code='8661'DB:business_master_new
loadtime:8.07075715065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:8.0708391666412 / seconds
Query Executed:select id FROM `va` where city='Warm Springs' && SIC_code='8661'DB:business_master_new
loadtime:8.0719661712646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:8.0720381736755 / seconds
Query Executed:select id FROM `va` where city='Warner' && SIC_code='8661'DB:business_master_new
loadtime:8.0724320411682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:8.0724849700928 / seconds
Query Executed:select id FROM `va` where city='Warrenton' && SIC_code='8661'DB:business_master_new
loadtime:8.1038420200348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:8.1039841175079 / seconds
Query Executed:select id FROM `va` where city='Warsaw' && SIC_code='8661'DB:business_master_new
loadtime:8.1089391708374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:8.1090631484985 / seconds
Query Executed:select id FROM `va` where city='Washington' && SIC_code='8661'DB:business_master_new
loadtime:8.1113681793213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water View' limit 1
loadtime:8.1114490032196 / seconds
Query Executed:select id FROM `va` where city='Water View' && SIC_code='8661'DB:business_master_new
loadtime:8.1118910312653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:8.1119470596313 / seconds
Query Executed:select id FROM `va` where city='Waterford' && SIC_code='8661'DB:business_master_new
loadtime:8.1131889820099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:8.1132600307465 / seconds
Query Executed:select id FROM `va` where city='Wattsville' && SIC_code='8661'DB:business_master_new
loadtime:8.1136860847473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:8.1137399673462 / seconds
Query Executed:select id FROM `va` where city='Waverly' && SIC_code='8661'DB:business_master_new
loadtime:8.1160271167755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:8.116119146347 / seconds
Query Executed:select id FROM `va` where city='Waynesboro' && SIC_code='8661'DB:business_master_new
loadtime:8.2539479732513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weber City' limit 1
loadtime:8.2542500495911 / seconds
Query Executed:select id FROM `va` where city='Weber City' && SIC_code='8661'DB:business_master_new
loadtime:8.2562530040741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weems' limit 1
loadtime:8.2563371658325 / seconds
Query Executed:select id FROM `va` where city='Weems' && SIC_code='8661'DB:business_master_new
loadtime:8.2573401927948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirwood' limit 1
loadtime:8.25741314888 / seconds
Query Executed:select id FROM `va` where city='Weirwood' && SIC_code='8661'DB:business_master_new
loadtime:8.2578389644623 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Augusta' limit 1
loadtime:8.2578940391541 / seconds
Query Executed:select id FROM `va` where city='West Augusta' && SIC_code='8661'DB:business_master_new
loadtime:8.2583570480347 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mclean' limit 1
loadtime:8.2584230899811 / seconds
Query Executed:select id FROM `va` where city='West Mclean' && SIC_code='8661'DB:business_master_new
loadtime:8.2591240406036 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:8.2591781616211 / seconds
Query Executed:select id FROM `va` where city='West Point' && SIC_code='8661'DB:business_master_new
loadtime:8.2628090381622 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:8.2629041671753 / seconds
Query Executed:select id FROM `va` where city='West Springfield' && SIC_code='8661'DB:business_master_new
loadtime:8.2633249759674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:8.2633810043335 / seconds
Query Executed:select id FROM `va` where city='Westmoreland' && SIC_code='8661'DB:business_master_new
loadtime:8.2638051509857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyers Cave' limit 1
loadtime:8.2638580799103 / seconds
Query Executed:select id FROM `va` where city='Weyers Cave' && SIC_code='8661'DB:business_master_new
loadtime:8.2658131122589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitacre' limit 1
loadtime:8.2658860683441 / seconds
Query Executed:select id FROM `va` where city='Whitacre' && SIC_code='8661'DB:business_master_new
loadtime:8.2662971019745 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Hall' limit 1
loadtime:8.2663509845734 / seconds
Query Executed:select id FROM `va` where city='White Hall' && SIC_code='8661'DB:business_master_new
loadtime:8.2668211460114 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Marsh' limit 1
loadtime:8.2668740749359 / seconds
Query Executed:select id FROM `va` where city='White Marsh' && SIC_code='8661'DB:business_master_new
loadtime:8.2679390907288 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:8.268012046814 / seconds
Query Executed:select id FROM `va` where city='White Plains' && SIC_code='8661'DB:business_master_new
loadtime:8.2684800624847 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Post' limit 1
loadtime:8.2685430049896 / seconds
Query Executed:select id FROM `va` where city='White Post' && SIC_code='8661'DB:business_master_new
loadtime:8.2697610855103 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:8.2698440551758 / seconds
Query Executed:select id FROM `va` where city='White Stone' && SIC_code='8661'DB:business_master_new
loadtime:8.2722790241241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitetop' limit 1
loadtime:8.2723660469055 / seconds
Query Executed:select id FROM `va` where city='Whitetop' && SIC_code='8661'DB:business_master_new
loadtime:8.2729890346527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:8.2730581760406 / seconds
Query Executed:select id FROM `va` where city='Whitewood' && SIC_code='8661'DB:business_master_new
loadtime:8.2735531330109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico' limit 1
loadtime:8.2736051082611 / seconds
Query Executed:select id FROM `va` where city='Wicomico' && SIC_code='8661'DB:business_master_new
loadtime:8.2741460800171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico Church' limit 1
loadtime:8.2741990089417 / seconds
Query Executed:select id FROM `va` where city='Wicomico Church' && SIC_code='8661'DB:business_master_new
loadtime:8.2748181819916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:8.2748861312866 / seconds
Query Executed:select id FROM `va` where city='Williamsburg' && SIC_code='8661'DB:business_master_new
loadtime:8.325129032135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:8.325376033783 / seconds
Query Executed:select id FROM `va` where city='Williamsville' && SIC_code='8661'DB:business_master_new
loadtime:8.3259789943695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:8.3260459899902 / seconds
Query Executed:select id FROM `va` where city='Willis' && SIC_code='8661'DB:business_master_new
loadtime:8.3273031711578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis Wharf' limit 1
loadtime:8.327378988266 / seconds
Query Executed:select id FROM `va` where city='Willis Wharf' && SIC_code='8661'DB:business_master_new
loadtime:8.327849149704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons' limit 1
loadtime:8.3279039859772 / seconds
Query Executed:select id FROM `va` where city='Wilsons' && SIC_code='8661'DB:business_master_new
loadtime:8.3283710479736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:8.3284239768982 / seconds
Query Executed:select id FROM `va` where city='Winchester' && SIC_code='8661'DB:business_master_new
loadtime:8.3778150081635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:8.3780870437622 / seconds
Query Executed:select id FROM `va` where city='Windsor' && SIC_code='8661'DB:business_master_new
loadtime:8.3810920715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingina' limit 1
loadtime:8.3811950683594 / seconds
Query Executed:select id FROM `va` where city='Wingina' && SIC_code='8661'DB:business_master_new
loadtime:8.3817000389099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wintergreen' limit 1
loadtime:8.3817670345306 / seconds
Query Executed:select id FROM `va` where city='Wintergreen' && SIC_code='8661'DB:business_master_new
loadtime:8.3822221755981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wirtz' limit 1
loadtime:8.3822770118713 / seconds
Query Executed:select id FROM `va` where city='Wirtz' && SIC_code='8661'DB:business_master_new
loadtime:8.3845450878143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:8.3846251964569 / seconds
Query Executed:select id FROM `va` where city='Wise' && SIC_code='8661'DB:business_master_new
loadtime:8.3905301094055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withams' limit 1
loadtime:8.3906421661377 / seconds
Query Executed:select id FROM `va` where city='Withams' && SIC_code='8661'DB:business_master_new
loadtime:8.3911280632019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolford' limit 1
loadtime:8.3912010192871 / seconds
Query Executed:select id FROM `va` where city='Wolford' && SIC_code='8661'DB:business_master_new
loadtime:8.3916661739349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolftown' limit 1
loadtime:8.3917291164398 / seconds
Query Executed:select id FROM `va` where city='Wolftown' && SIC_code='8661'DB:business_master_new
loadtime:8.3923370838165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodberry Forest' limit 1
loadtime:8.3924031257629 / seconds
Query Executed:select id FROM `va` where city='Woodberry Forest' && SIC_code='8661'DB:business_master_new
loadtime:8.3928120136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:8.3928651809692 / seconds
Query Executed:select id FROM `va` where city='Woodbridge' && SIC_code='8661'DB:business_master_new
loadtime:8.4608731269836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:8.4612510204315 / seconds
Query Executed:select id FROM `va` where city='Woodford' && SIC_code='8661'DB:business_master_new
loadtime:8.4629521369934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodlawn' limit 1
loadtime:8.4630551338196 / seconds
Query Executed:select id FROM `va` where city='Woodlawn' && SIC_code='8661'DB:business_master_new
loadtime:8.4648020267487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Rds' limit 1
loadtime:8.4648861885071 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Rds' && SIC_code='8661'DB:business_master_new
loadtime:8.4652781486511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Roads' limit 1
loadtime:8.4653341770172 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Roads' && SIC_code='8661'DB:business_master_new
loadtime:8.4657790660858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:8.4658401012421 / seconds
Query Executed:select id FROM `va` where city='Woodstock' && SIC_code='8661'DB:business_master_new
loadtime:8.4728441238403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:8.4729731082916 / seconds
Query Executed:select id FROM `va` where city='Woodville' && SIC_code='8661'DB:business_master_new
loadtime:8.4736680984497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolwine' limit 1
loadtime:8.4737401008606 / seconds
Query Executed:select id FROM `va` where city='Woolwine' && SIC_code='8661'DB:business_master_new
loadtime:8.4745509624481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wylliesburg' limit 1
loadtime:8.4746191501617 / seconds
Query Executed:select id FROM `va` where city='Wylliesburg' && SIC_code='8661'DB:business_master_new
loadtime:8.4752860069275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wytheville' limit 1
loadtime:8.4753541946411 / seconds
Query Executed:select id FROM `va` where city='Wytheville' && SIC_code='8661'DB:business_master_new
loadtime:8.4862310886383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:8.4863650798798 / seconds
Query Executed:select id FROM `va` where city='Yale' && SIC_code='8661'DB:business_master_new
loadtime:8.4870431423187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:8.4871220588684 / seconds
Query Executed:select id FROM `va` where city='Yorktown' && SIC_code='8661'DB:business_master_new
loadtime:8.6256079673767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zacata' limit 1
loadtime:8.6258780956268 / seconds
Query Executed:select id FROM `va` where city='Zacata' && SIC_code='8661'DB:business_master_new
loadtime:8.6264171600342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zanoni' limit 1
loadtime:8.6264841556549 / seconds
Query Executed:select id FROM `va` where city='Zanoni' && SIC_code='8661'DB:business_master_new
loadtime:8.6270270347595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:8.6270961761475 / seconds
Query Executed:select id FROM `va` where city='Zuni' && SIC_code='8661'DB:business_master_new
loadtime:8.6281561851501 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:8.6283280849457 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:8.6288561820984 / seconds
Operation template executed (chunk cache operation)
loadtime:8.6290240287781 / seconds
template override:Default
loadtime:8.6290671825409 / 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:8.630448102951 / seconds
Template Constructed, Array Rows:49
loadtime:8.6310210227966 / seconds
TOTAL EXECUTION TIME: 8.63054
loadtime:8.6371700763702 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => religious-organizations [stateURLid] => virginia )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:8.6371810436249
TOTAL KEY ARRAYS: 69