Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.3936920166016E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00049901008605957 / seconds
host not found setting manual db connection
loadtime:0.00090479850769043 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011518001556396 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.001349925994873 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0014059543609619 / seconds
zipcode:
loadtime:0.0014238357543945 / seconds
Query Executed:select * from search_referrer where page_hash='d9a5193dc6ee83db34ee9f1b4bbf9172' limit 10 DB:ezrox_toadli
loadtime:0.0016589164733887 / seconds
Operation header executed (non global)
loadtime:0.0016789436340332 / seconds
Operation leaderboard executed (non global)
loadtime:0.0017368793487549 / seconds
Operation square executed (non global)
loadtime:0.0017538070678711 / seconds
Operation square_bottom executed (non global)
loadtime:0.0017678737640381 / seconds
Operation smallsquare executed (non global)
loadtime:0.0017797946929932 / seconds
Operation headeradright executed (non global)
loadtime:0.0017919540405273 / seconds
Operation google_analytics executed (non global)
loadtime:0.0018019676208496 / seconds
Operation topstories executed (non global)
loadtime:0.0018138885498047 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0018270015716553 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0018367767333984 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0021388530731201 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0022947788238525 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0023379325866699 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0024058818817139 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0024449825286865 / seconds
Template key: archive_menu pushed
loadtime:0.0024499893188477 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0024559497833252 / seconds
Template key: get_gravatar pushed
loadtime:0.0024600028991699 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0024638175964355 / seconds
*10)-10)+1 | start:0
loadtime:0.0024869441986084 / seconds
DB connected to localhost business_master_new
loadtime:0.0027568340301514 / seconds
Query Executed:select * from categories where cat_URLid='retail-nurseries-lawn-and-garden-supply-stores'DB:business_master_new
loadtime:0.0033237934112549 / seconds
Query stored in cache : _QUERY_www.toadli.com1e9814ae7124e3b8054396375087dfd1
loadtime:0.0033638477325439 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.0034148693084717 / seconds
Query Executed:select * from `va_catmap` where sic='5261' order by city ascDB:business_master_new
loadtime:0.029562950134277 / seconds
Query stored in cache : _QUERY_www.toadli.com24ceadb90bdd12bfaa932c9588dcb916
loadtime:0.031515836715698 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.031646966934204 / seconds
Query Executed:select sum(totalcount) as totalsum from `va_catmap` where sic='5261'DB:business_master_new
loadtime:0.036590814590454 / seconds
Query stored in cache : _QUERY_www.toadli.com70f05290edc2749940660873360dc792
loadtime:0.036695957183838 / seconds
942 / 11
loadtime:0.036774873733521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abingdon' limit 1
loadtime:0.036818981170654 / seconds
Query Executed:select id FROM `va` where city='Abingdon' && SIC_code='5261'DB:business_master_new
loadtime:0.040508985519409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accomac' limit 1
loadtime:0.040568828582764 / seconds
Query Executed:select id FROM `va` where city='Accomac' && SIC_code='5261'DB:business_master_new
loadtime:0.041637897491455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Achilles' limit 1
loadtime:0.041682958602905 / seconds
Query Executed:select id FROM `va` where city='Achilles' && SIC_code='5261'DB:business_master_new
loadtime:0.042267799377441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.04231595993042 / seconds
Query Executed:select id FROM `va` where city='Afton' && SIC_code='5261'DB:business_master_new
loadtime:0.043446779251099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alberta' limit 1
loadtime:0.043503999710083 / seconds
Query Executed:select id FROM `va` where city='Alberta' && SIC_code='5261'DB:business_master_new
loadtime:0.045242786407471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aldie' limit 1
loadtime:0.045286893844604 / seconds
Query Executed:select id FROM `va` where city='Aldie' && SIC_code='5261'DB:business_master_new
loadtime:0.046541929244995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.046597003936768 / seconds
Query Executed:select id FROM `va` where city='Alexandria' && SIC_code='5261'DB:business_master_new
loadtime:0.065250873565674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleghany' limit 1
loadtime:0.065311908721924 / seconds
Query Executed:select id FROM `va` where city='Alleghany' && SIC_code='5261'DB:business_master_new
loadtime:0.065632820129395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allisonia' limit 1
loadtime:0.065669775009155 / seconds
Query Executed:select id FROM `va` where city='Allisonia' && SIC_code='5261'DB:business_master_new
loadtime:0.065929889678955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altavista' limit 1
loadtime:0.065965890884399 / seconds
Query Executed:select id FROM `va` where city='Altavista' && SIC_code='5261'DB:business_master_new
loadtime:0.066819906234741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.066863775253296 / seconds
Query Executed:select id FROM `va` where city='Alton' && SIC_code='5261'DB:business_master_new
loadtime:0.067732810974121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Ridge' limit 1
loadtime:0.06778883934021 / seconds
Query Executed:select id FROM `va` where city='Alum Ridge' && SIC_code='5261'DB:business_master_new
loadtime:0.068034887313843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court House' limit 1
loadtime:0.068062782287598 / seconds
Query Executed:select id FROM `va` where city='Amelia Court House' && SIC_code='5261'DB:business_master_new
loadtime:0.068985939025879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court Hse' limit 1
loadtime:0.06905198097229 / seconds
Query Executed:select id FROM `va` where city='Amelia Court Hse' && SIC_code='5261'DB:business_master_new
loadtime:0.069775819778442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.069823980331421 / seconds
Query Executed:select id FROM `va` where city='Amherst' && SIC_code='5261'DB:business_master_new
loadtime:0.070918798446655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amissville' limit 1
loadtime:0.070966005325317 / seconds
Query Executed:select id FROM `va` where city='Amissville' && SIC_code='5261'DB:business_master_new
loadtime:0.071753978729248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ammon' limit 1
loadtime:0.071807861328125 / seconds
Query Executed:select id FROM `va` where city='Ammon' && SIC_code='5261'DB:business_master_new
loadtime:0.07207179069519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amonate' limit 1
loadtime:0.072098970413208 / seconds
Query Executed:select id FROM `va` where city='Amonate' && SIC_code='5261'DB:business_master_new
loadtime:0.072456836700439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.072500944137573 / seconds
Query Executed:select id FROM `va` where city='Andover' && SIC_code='5261'DB:business_master_new
loadtime:0.072922945022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.072959899902344 / seconds
Query Executed:select id FROM `va` where city='Annandale' && SIC_code='5261'DB:business_master_new
loadtime:0.074959993362427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appalachia' limit 1
loadtime:0.075018882751465 / seconds
Query Executed:select id FROM `va` where city='Appalachia' && SIC_code='5261'DB:business_master_new
loadtime:0.076793909072876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appomattox' limit 1
loadtime:0.076841831207275 / seconds
Query Executed:select id FROM `va` where city='Appomattox' && SIC_code='5261'DB:business_master_new
loadtime:0.077733993530273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.077778816223145 / seconds
Query Executed:select id FROM `va` where city='Ararat' && SIC_code='5261'DB:business_master_new
loadtime:0.078845977783203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.078903913497925 / seconds
Query Executed:select id FROM `va` where city='Arcola' && SIC_code='5261'DB:business_master_new
loadtime:0.0794358253479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ark' limit 1
loadtime:0.079478979110718 / seconds
Query Executed:select id FROM `va` where city='Ark' && SIC_code='5261'DB:business_master_new
loadtime:0.079946994781494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.079986810684204 / seconds
Query Executed:select id FROM `va` where city='Arlington' && SIC_code='5261'DB:business_master_new
loadtime:0.090505838394165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aroda' limit 1
loadtime:0.09056282043457 / seconds
Query Executed:select id FROM `va` where city='Aroda' && SIC_code='5261'DB:business_master_new
loadtime:0.091092824935913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrington' limit 1
loadtime:0.091139793395996 / seconds
Query Executed:select id FROM `va` where city='Arrington' && SIC_code='5261'DB:business_master_new
loadtime:0.092159986495972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvonia' limit 1
loadtime:0.092195987701416 / seconds
Query Executed:select id FROM `va` where city='Arvonia' && SIC_code='5261'DB:business_master_new
loadtime:0.092829942703247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburn' limit 1
loadtime:0.092877864837646 / seconds
Query Executed:select id FROM `va` where city='Ashburn' && SIC_code='5261'DB:business_master_new
loadtime:0.094525814056396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.094582796096802 / seconds
Query Executed:select id FROM `va` where city='Ashland' && SIC_code='5261'DB:business_master_new
loadtime:0.09626579284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assawoman' limit 1
loadtime:0.096314907073975 / seconds
Query Executed:select id FROM `va` where city='Assawoman' && SIC_code='5261'DB:business_master_new
loadtime:0.09663987159729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.096679925918579 / seconds
Query Executed:select id FROM `va` where city='Atkins' && SIC_code='5261'DB:business_master_new
loadtime:0.097784996032715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.097831964492798 / seconds
Query Executed:select id FROM `va` where city='Atlantic' && SIC_code='5261'DB:business_master_new
loadtime:0.098428010940552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta Springs' limit 1
loadtime:0.09847092628479 / seconds
Query Executed:select id FROM `va` where city='Augusta Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.098866939544678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.098906993865967 / seconds
Query Executed:select id FROM `va` where city='Austinville' && SIC_code='5261'DB:business_master_new
loadtime:0.099764823913574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axton' limit 1
loadtime:0.099808931350708 / seconds
Query Executed:select id FROM `va` where city='Axton' && SIC_code='5261'DB:business_master_new
loadtime:0.10054683685303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aylett' limit 1
loadtime:0.1006019115448 / seconds
Query Executed:select id FROM `va` where city='Aylett' && SIC_code='5261'DB:business_master_new
loadtime:0.10153079032898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bacova' limit 1
loadtime:0.10156679153442 / seconds
Query Executed:select id FROM `va` where city='Bacova' && SIC_code='5261'DB:business_master_new
loadtime:0.10188698768616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Crossrds' limit 1
loadtime:0.10192680358887 / seconds
Query Executed:select id FROM `va` where city='Baileys Crossrds' && SIC_code='5261'DB:business_master_new
loadtime:0.10234880447388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banco' limit 1
loadtime:0.102383852005 / seconds
Query Executed:select id FROM `va` where city='Banco' && SIC_code='5261'DB:business_master_new
loadtime:0.10264897346497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bandy' limit 1
loadtime:0.10268378257751 / seconds
Query Executed:select id FROM `va` where city='Bandy' && SIC_code='5261'DB:business_master_new
loadtime:0.10319685935974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barboursville' limit 1
loadtime:0.10323286056519 / seconds
Query Executed:select id FROM `va` where city='Barboursville' && SIC_code='5261'DB:business_master_new
loadtime:0.10403299331665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barhamsville' limit 1
loadtime:0.10407590866089 / seconds
Query Executed:select id FROM `va` where city='Barhamsville' && SIC_code='5261'DB:business_master_new
loadtime:0.10499691963196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barren Springs' limit 1
loadtime:0.10505390167236 / seconds
Query Executed:select id FROM `va` where city='Barren Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.10551500320435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baskerville' limit 1
loadtime:0.10555195808411 / seconds
Query Executed:select id FROM `va` where city='Baskerville' && SIC_code='5261'DB:business_master_new
loadtime:0.10643982887268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.10648679733276 / seconds
Query Executed:select id FROM `va` where city='Bassett' && SIC_code='5261'DB:business_master_new
loadtime:0.10797882080078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bastian' limit 1
loadtime:0.10803484916687 / seconds
Query Executed:select id FROM `va` where city='Bastian' && SIC_code='5261'DB:business_master_new
loadtime:0.10895681381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basye' limit 1
loadtime:0.1089940071106 / seconds
Query Executed:select id FROM `va` where city='Basye' && SIC_code='5261'DB:business_master_new
loadtime:0.11039590835571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.1104428768158 / seconds
Query Executed:select id FROM `va` where city='Batesville' && SIC_code='5261'DB:business_master_new
loadtime:0.11089777946472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battery Park' limit 1
loadtime:0.11093592643738 / seconds
Query Executed:select id FROM `va` where city='Battery Park' && SIC_code='5261'DB:business_master_new
loadtime:0.11128783226013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bavon' limit 1
loadtime:0.11132383346558 / seconds
Query Executed:select id FROM `va` where city='Bavon' && SIC_code='5261'DB:business_master_new
loadtime:0.11159992218018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bealeton' limit 1
loadtime:0.11163592338562 / seconds
Query Executed:select id FROM `va` where city='Bealeton' && SIC_code='5261'DB:business_master_new
loadtime:0.11247777938843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.11253499984741 / seconds
Query Executed:select id FROM `va` where city='Beaumont' && SIC_code='5261'DB:business_master_new
loadtime:0.11284589767456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverdam' limit 1
loadtime:0.11287498474121 / seconds
Query Executed:select id FROM `va` where city='Beaverdam' && SIC_code='5261'DB:business_master_new
loadtime:0.11376285552979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverlett' limit 1
loadtime:0.11381697654724 / seconds
Query Executed:select id FROM `va` where city='Beaverlett' && SIC_code='5261'DB:business_master_new
loadtime:0.11412978172302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.11416482925415 / seconds
Query Executed:select id FROM `va` where city='Bedford' && SIC_code='5261'DB:business_master_new
loadtime:0.11646485328674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bee' limit 1
loadtime:0.11652183532715 / seconds
Query Executed:select id FROM `va` where city='Bee' && SIC_code='5261'DB:business_master_new
loadtime:0.11687278747559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellamy' limit 1
loadtime:0.11690092086792 / seconds
Query Executed:select id FROM `va` where city='Bellamy' && SIC_code='5261'DB:business_master_new
loadtime:0.11720991134644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Haven' limit 1
loadtime:0.11725687980652 / seconds
Query Executed:select id FROM `va` where city='Belle Haven' && SIC_code='5261'DB:business_master_new
loadtime:0.11836695671082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belspring' limit 1
loadtime:0.1184229850769 / seconds
Query Executed:select id FROM `va` where city='Belspring' && SIC_code='5261'DB:business_master_new
loadtime:0.11890697479248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ben Hur' limit 1
loadtime:0.11893582344055 / seconds
Query Executed:select id FROM `va` where city='Ben Hur' && SIC_code='5261'DB:business_master_new
loadtime:0.1195240020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bena' limit 1
loadtime:0.11957192420959 / seconds
Query Executed:select id FROM `va` where city='Bena' && SIC_code='5261'DB:business_master_new
loadtime:0.12026882171631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent Mountain' limit 1
loadtime:0.12030577659607 / seconds
Query Executed:select id FROM `va` where city='Bent Mountain' && SIC_code='5261'DB:business_master_new
loadtime:0.1213059425354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonville' limit 1
loadtime:0.12135291099548 / seconds
Query Executed:select id FROM `va` where city='Bentonville' && SIC_code='5261'DB:business_master_new
loadtime:0.12286281585693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergton' limit 1
loadtime:0.12290477752686 / seconds
Query Executed:select id FROM `va` where city='Bergton' && SIC_code='5261'DB:business_master_new
loadtime:0.12374496459961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berryville' limit 1
loadtime:0.12379384040833 / seconds
Query Executed:select id FROM `va` where city='Berryville' && SIC_code='5261'DB:business_master_new
loadtime:0.1252338886261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Island' limit 1
loadtime:0.12527680397034 / seconds
Query Executed:select id FROM `va` where city='Big Island' && SIC_code='5261'DB:business_master_new
loadtime:0.12679696083069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.12685394287109 / seconds
Query Executed:select id FROM `va` where city='Big Rock' && SIC_code='5261'DB:business_master_new
loadtime:0.12750887870789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone Gap' limit 1
loadtime:0.12755298614502 / seconds
Query Executed:select id FROM `va` where city='Big Stone Gap' && SIC_code='5261'DB:business_master_new
loadtime:0.12875580787659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchleaf' limit 1
loadtime:0.12880277633667 / seconds
Query Executed:select id FROM `va` where city='Birchleaf' && SIC_code='5261'DB:business_master_new
loadtime:0.12924695014954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birdsnest' limit 1
loadtime:0.1292839050293 / seconds
Query Executed:select id FROM `va` where city='Birdsnest' && SIC_code='5261'DB:business_master_new
loadtime:0.12980389595032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishop' limit 1
loadtime:0.12984299659729 / seconds
Query Executed:select id FROM `va` where city='Bishop' && SIC_code='5261'DB:business_master_new
loadtime:0.13032579421997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackridge' limit 1
loadtime:0.1303699016571 / seconds
Query Executed:select id FROM `va` where city='Blackridge' && SIC_code='5261'DB:business_master_new
loadtime:0.1308798789978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:0.13090682029724 / seconds
Query Executed:select id FROM `va` where city='Blacksburg' && SIC_code='5261'DB:business_master_new
loadtime:0.13326478004456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.13332080841064 / seconds
Query Executed:select id FROM `va` where city='Blackstone' && SIC_code='5261'DB:business_master_new
loadtime:0.13494300842285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwater' limit 1
loadtime:0.13498783111572 / seconds
Query Executed:select id FROM `va` where city='Blackwater' && SIC_code='5261'DB:business_master_new
loadtime:0.13560390472412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairs' limit 1
loadtime:0.13565182685852 / seconds
Query Executed:select id FROM `va` where city='Blairs' && SIC_code='5261'DB:business_master_new
loadtime:0.13686084747314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakes' limit 1
loadtime:0.13689589500427 / seconds
Query Executed:select id FROM `va` where city='Blakes' && SIC_code='5261'DB:business_master_new
loadtime:0.13714694976807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bland' limit 1
loadtime:0.13718581199646 / seconds
Query Executed:select id FROM `va` where city='Bland' && SIC_code='5261'DB:business_master_new
loadtime:0.13817596435547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloxom' limit 1
loadtime:0.13822388648987 / seconds
Query Executed:select id FROM `va` where city='Bloxom' && SIC_code='5261'DB:business_master_new
loadtime:0.13910579681396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.13914895057678 / seconds
Query Executed:select id FROM `va` where city='Blue Grass' && SIC_code='5261'DB:business_master_new
loadtime:0.13986992835999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Ridge' limit 1
loadtime:0.13990998268127 / seconds
Query Executed:select id FROM `va` where city='Blue Ridge' && SIC_code='5261'DB:business_master_new
loadtime:0.14095997810364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:0.14100289344788 / seconds
Query Executed:select id FROM `va` where city='Bluefield' && SIC_code='5261'DB:business_master_new
loadtime:0.14239192008972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluemont' limit 1
loadtime:0.1424388885498 / seconds
Query Executed:select id FROM `va` where city='Bluemont' && SIC_code='5261'DB:business_master_new
loadtime:0.14383578300476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bohannon' limit 1
loadtime:0.14387989044189 / seconds
Query Executed:select id FROM `va` where city='Bohannon' && SIC_code='5261'DB:business_master_new
loadtime:0.14423489570618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boissevain' limit 1
loadtime:0.14428281784058 / seconds
Query Executed:select id FROM `va` where city='Boissevain' && SIC_code='5261'DB:business_master_new
loadtime:0.14476799964905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolar' limit 1
loadtime:0.14479494094849 / seconds
Query Executed:select id FROM `va` where city='Bolar' && SIC_code='5261'DB:business_master_new
loadtime:0.14503479003906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:0.14507985115051 / seconds
Query Executed:select id FROM `va` where city='Bon Air' && SIC_code='5261'DB:business_master_new
loadtime:0.14592981338501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boones Mill' limit 1
loadtime:0.14597678184509 / seconds
Query Executed:select id FROM `va` where city='Boones Mill' && SIC_code='5261'DB:business_master_new
loadtime:0.14726090431213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.14730501174927 / seconds
Query Executed:select id FROM `va` where city='Boston' && SIC_code='5261'DB:business_master_new
loadtime:0.14810681343079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:0.14815497398376 / seconds
Query Executed:select id FROM `va` where city='Bowling Green' && SIC_code='5261'DB:business_master_new
loadtime:0.14931583404541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyce' limit 1
loadtime:0.14935183525085 / seconds
Query Executed:select id FROM `va` where city='Boyce' && SIC_code='5261'DB:business_master_new
loadtime:0.15035080909729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boydton' limit 1
loadtime:0.15039896965027 / seconds
Query Executed:select id FROM `va` where city='Boydton' && SIC_code='5261'DB:business_master_new
loadtime:0.1514048576355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykins' limit 1
loadtime:0.15144085884094 / seconds
Query Executed:select id FROM `va` where city='Boykins' && SIC_code='5261'DB:business_master_new
loadtime:0.15271878242493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bracey' limit 1
loadtime:0.15277481079102 / seconds
Query Executed:select id FROM `va` where city='Bracey' && SIC_code='5261'DB:business_master_new
loadtime:0.15377497673035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.15382599830627 / seconds
Query Executed:select id FROM `va` where city='Branchville' && SIC_code='5261'DB:business_master_new
loadtime:0.15455389022827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandy Station' limit 1
loadtime:0.15459895133972 / seconds
Query Executed:select id FROM `va` where city='Brandy Station' && SIC_code='5261'DB:business_master_new
loadtime:0.15635395050049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breaks' limit 1
loadtime:0.15638899803162 / seconds
Query Executed:select id FROM `va` where city='Breaks' && SIC_code='5261'DB:business_master_new
loadtime:0.15681886672974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremo Bluff' limit 1
loadtime:0.15685892105103 / seconds
Query Executed:select id FROM `va` where city='Bremo Bluff' && SIC_code='5261'DB:business_master_new
loadtime:0.15754795074463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.15759992599487 / seconds
Query Executed:select id FROM `va` where city='Bridgewater' && SIC_code='5261'DB:business_master_new
loadtime:0.15911889076233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:0.15916895866394 / seconds
Query Executed:select id FROM `va` where city='Brightwood' && SIC_code='5261'DB:business_master_new
loadtime:0.15988397598267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.15992379188538 / seconds
Query Executed:select id FROM `va` where city='Bristol' && SIC_code='5261'DB:business_master_new
loadtime:0.16241598129272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.16246294975281 / seconds
Query Executed:select id FROM `va` where city='Bristow' && SIC_code='5261'DB:business_master_new
loadtime:0.16389179229736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Run' limit 1
loadtime:0.16394782066345 / seconds
Query Executed:select id FROM `va` where city='Broad Run' && SIC_code='5261'DB:business_master_new
loadtime:0.16493678092957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadford' limit 1
loadtime:0.16497397422791 / seconds
Query Executed:select id FROM `va` where city='Broadford' && SIC_code='5261'DB:business_master_new
loadtime:0.16541695594788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.16546583175659 / seconds
Query Executed:select id FROM `va` where city='Broadway' && SIC_code='5261'DB:business_master_new
loadtime:0.16678500175476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodnax' limit 1
loadtime:0.16683983802795 / seconds
Query Executed:select id FROM `va` where city='Brodnax' && SIC_code='5261'DB:business_master_new
loadtime:0.16793584823608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooke' limit 1
loadtime:0.1679790019989 / seconds
Query Executed:select id FROM `va` where city='Brooke' && SIC_code='5261'DB:business_master_new
loadtime:0.16838097572327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookneal' limit 1
loadtime:0.16842794418335 / seconds
Query Executed:select id FROM `va` where city='Brookneal' && SIC_code='5261'DB:business_master_new
loadtime:0.16957688331604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsburg' limit 1
loadtime:0.16963195800781 / seconds
Query Executed:select id FROM `va` where city='Brownsburg' && SIC_code='5261'DB:business_master_new
loadtime:0.17006087303162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brucetown' limit 1
loadtime:0.17009687423706 / seconds
Query Executed:select id FROM `va` where city='Brucetown' && SIC_code='5261'DB:business_master_new
loadtime:0.17033791542053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruington' limit 1
loadtime:0.17037582397461 / seconds
Query Executed:select id FROM `va` where city='Bruington' && SIC_code='5261'DB:business_master_new
loadtime:0.17075085639954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:0.17078590393066 / seconds
Query Executed:select id FROM `va` where city='Buchanan' && SIC_code='5261'DB:business_master_new
loadtime:0.17175889015198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:0.17179489135742 / seconds
Query Executed:select id FROM `va` where city='Buckingham' && SIC_code='5261'DB:business_master_new
loadtime:0.17244482040405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:0.17249178886414 / seconds
Query Executed:select id FROM `va` where city='Buena Vista' && SIC_code='5261'DB:business_master_new
loadtime:0.17329597473145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Junction' limit 1
loadtime:0.17334294319153 / seconds
Query Executed:select id FROM `va` where city='Buffalo Junction' && SIC_code='5261'DB:business_master_new
loadtime:0.17447996139526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bumpass' limit 1
loadtime:0.17451500892639 / seconds
Query Executed:select id FROM `va` where city='Bumpass' && SIC_code='5261'DB:business_master_new
loadtime:0.17579483985901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgess' limit 1
loadtime:0.17584180831909 / seconds
Query Executed:select id FROM `va` where city='Burgess' && SIC_code='5261'DB:business_master_new
loadtime:0.17688679695129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.17693090438843 / seconds
Query Executed:select id FROM `va` where city='Burke' && SIC_code='5261'DB:business_master_new
loadtime:0.17826294898987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkes Garden' limit 1
loadtime:0.17831778526306 / seconds
Query Executed:select id FROM `va` where city='Burkes Garden' && SIC_code='5261'DB:business_master_new
loadtime:0.17865180969238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkeville' limit 1
loadtime:0.17868685722351 / seconds
Query Executed:select id FROM `va` where city='Burkeville' && SIC_code='5261'DB:business_master_new
loadtime:0.17937684059143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.17942190170288 / seconds
Query Executed:select id FROM `va` where city='Burnsville' && SIC_code='5261'DB:business_master_new
loadtime:0.1797947883606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Hill' limit 1
loadtime:0.17983484268188 / seconds
Query Executed:select id FROM `va` where city='Burr Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.18027496337891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callands' limit 1
loadtime:0.18031191825867 / seconds
Query Executed:select id FROM `va` where city='Callands' && SIC_code='5261'DB:business_master_new
loadtime:0.18125796318054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callao' limit 1
loadtime:0.18130683898926 / seconds
Query Executed:select id FROM `va` where city='Callao' && SIC_code='5261'DB:business_master_new
loadtime:0.18212795257568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callaway' limit 1
loadtime:0.18217492103577 / seconds
Query Executed:select id FROM `va` where city='Callaway' && SIC_code='5261'DB:business_master_new
loadtime:0.18318390846252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calverton' limit 1
loadtime:0.18322777748108 / seconds
Query Executed:select id FROM `va` where city='Calverton' && SIC_code='5261'DB:business_master_new
loadtime:0.18380284309387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cana' limit 1
loadtime:0.18384289741516 / seconds
Query Executed:select id FROM `va` where city='Cana' && SIC_code='5261'DB:business_master_new
loadtime:0.18452191352844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Charles' limit 1
loadtime:0.18456482887268 / seconds
Query Executed:select id FROM `va` where city='Cape Charles' && SIC_code='5261'DB:business_master_new
loadtime:0.18538999557495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capeville' limit 1
loadtime:0.18543481826782 / seconds
Query Executed:select id FROM `va` where city='Capeville' && SIC_code='5261'DB:business_master_new
loadtime:0.18584394454956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capron' limit 1
loadtime:0.18588399887085 / seconds
Query Executed:select id FROM `va` where city='Capron' && SIC_code='5261'DB:business_master_new
loadtime:0.1868908405304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardinal' limit 1
loadtime:0.18692588806152 / seconds
Query Executed:select id FROM `va` where city='Cardinal' && SIC_code='5261'DB:business_master_new
loadtime:0.18735098838806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caret' limit 1
loadtime:0.18739891052246 / seconds
Query Executed:select id FROM `va` where city='Caret' && SIC_code='5261'DB:business_master_new
loadtime:0.18805885314941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.18810796737671 / seconds
Query Executed:select id FROM `va` where city='Carrollton' && SIC_code='5261'DB:business_master_new
loadtime:0.18900084495544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrsville' limit 1
loadtime:0.1890389919281 / seconds
Query Executed:select id FROM `va` where city='Carrsville' && SIC_code='5261'DB:business_master_new
loadtime:0.18984293937683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.18989777565002 / seconds
Query Executed:select id FROM `va` where city='Carson' && SIC_code='5261'DB:business_master_new
loadtime:0.19091796875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cartersville' limit 1
loadtime:0.19097280502319 / seconds
Query Executed:select id FROM `va` where city='Cartersville' && SIC_code='5261'DB:business_master_new
loadtime:0.1919379234314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casanova' limit 1
loadtime:0.19197297096252 / seconds
Query Executed:select id FROM `va` where city='Casanova' && SIC_code='5261'DB:business_master_new
loadtime:0.19251799583435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.19261384010315 / seconds
Query Executed:select id FROM `va` where city='Cascade' && SIC_code='5261'DB:business_master_new
loadtime:0.19338989257812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:0.19343781471252 / seconds
Query Executed:select id FROM `va` where city='Castleton' && SIC_code='5261'DB:business_master_new
loadtime:0.19396781921387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.19400691986084 / seconds
Query Executed:select id FROM `va` where city='Castlewood' && SIC_code='5261'DB:business_master_new
loadtime:0.19466996192932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.19471478462219 / seconds
Query Executed:select id FROM `va` where city='Catawba' && SIC_code='5261'DB:business_master_new
loadtime:0.19532680511475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharpin' limit 1
loadtime:0.1953809261322 / seconds
Query Executed:select id FROM `va` where city='Catharpin' && SIC_code='5261'DB:business_master_new
loadtime:0.1960608959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catlett' limit 1
loadtime:0.19610500335693 / seconds
Query Executed:select id FROM `va` where city='Catlett' && SIC_code='5261'DB:business_master_new
loadtime:0.19677782058716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:0.19681978225708 / seconds
Query Executed:select id FROM `va` where city='Cedar Bluff' && SIC_code='5261'DB:business_master_new
loadtime:0.19754886627197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Cross' limit 1
loadtime:0.19758486747742 / seconds
Query Executed:select id FROM `va` where city='Center Cross' && SIC_code='5261'DB:business_master_new
loadtime:0.19809579849243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.19814300537109 / seconds
Query Executed:select id FROM `va` where city='Centreville' && SIC_code='5261'DB:business_master_new
loadtime:0.19956588745117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceres' limit 1
loadtime:0.19962286949158 / seconds
Query Executed:select id FROM `va` where city='Ceres' && SIC_code='5261'DB:business_master_new
loadtime:0.20006895065308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champlain' limit 1
loadtime:0.20010590553284 / seconds
Query Executed:select id FROM `va` where city='Champlain' && SIC_code='5261'DB:business_master_new
loadtime:0.20054388046265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chantilly' limit 1
loadtime:0.20059585571289 / seconds
Query Executed:select id FROM `va` where city='Chantilly' && SIC_code='5261'DB:business_master_new
loadtime:0.20237994194031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:0.20244383811951 / seconds
Query Executed:select id FROM `va` where city='Charles City' && SIC_code='5261'DB:business_master_new
loadtime:0.20321583747864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Court House' limit 1
loadtime:0.20327281951904 / seconds
Query Executed:select id FROM `va` where city='Charlotte Court House' && SIC_code='5261'DB:business_master_new
loadtime:0.20398283004761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Ct Hse' limit 1
loadtime:0.20403695106506 / seconds
Query Executed:select id FROM `va` where city='Charlotte Ct Hse' && SIC_code='5261'DB:business_master_new
loadtime:0.20458698272705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlottesville' limit 1
loadtime:0.2046229839325 / seconds
Query Executed:select id FROM `va` where city='Charlottesville' && SIC_code='5261'DB:business_master_new
loadtime:0.21314978599548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase City' limit 1
loadtime:0.2132248878479 / seconds
Query Executed:select id FROM `va` where city='Chase City' && SIC_code='5261'DB:business_master_new
loadtime:0.21404099464417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.2140908241272 / seconds
Query Executed:select id FROM `va` where city='Chatham' && SIC_code='5261'DB:business_master_new
loadtime:0.21495890617371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Check' limit 1
loadtime:0.21500682830811 / seconds
Query Executed:select id FROM `va` where city='Check' && SIC_code='5261'DB:business_master_new
loadtime:0.21563291549683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheriton' limit 1
loadtime:0.21567583084106 / seconds
Query Executed:select id FROM `va` where city='Cheriton' && SIC_code='5261'DB:business_master_new
loadtime:0.21654391288757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesapeake' limit 1
loadtime:0.2165858745575 / seconds
Query Executed:select id FROM `va` where city='Chesapeake' && SIC_code='5261'DB:business_master_new
loadtime:0.2247679233551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.22483777999878 / seconds
Query Executed:select id FROM `va` where city='Chester' && SIC_code='5261'DB:business_master_new
loadtime:0.22618985176086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester Gap' limit 1
loadtime:0.22624897956848 / seconds
Query Executed:select id FROM `va` where city='Chester Gap' && SIC_code='5261'DB:business_master_new
loadtime:0.22661685943604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.22665286064148 / seconds
Query Executed:select id FROM `va` where city='Chesterfield' && SIC_code='5261'DB:business_master_new
loadtime:0.22789883613586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilhowie' limit 1
loadtime:0.22793483734131 / seconds
Query Executed:select id FROM `va` where city='Chilhowie' && SIC_code='5261'DB:business_master_new
loadtime:0.22865891456604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague' limit 1
loadtime:0.2287118434906 / seconds
Query Executed:select id FROM `va` where city='Chincoteague' && SIC_code='5261'DB:business_master_new
loadtime:0.2292377948761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague Island' limit 1
loadtime:0.22928094863892 / seconds
Query Executed:select id FROM `va` where city='Chincoteague Island' && SIC_code='5261'DB:business_master_new
loadtime:0.230055809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christchurch' limit 1
loadtime:0.23009181022644 / seconds
Query Executed:select id FROM `va` where city='Christchurch' && SIC_code='5261'DB:business_master_new
loadtime:0.23036599159241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christiansburg' limit 1
loadtime:0.23039889335632 / seconds
Query Executed:select id FROM `va` where city='Christiansburg' && SIC_code='5261'DB:business_master_new
loadtime:0.23177981376648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Road' limit 1
loadtime:0.23181390762329 / seconds
Query Executed:select id FROM `va` where city='Church Road' && SIC_code='5261'DB:business_master_new
loadtime:0.23256087303162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church View' limit 1
loadtime:0.23260378837585 / seconds
Query Executed:select id FROM `va` where city='Church View' && SIC_code='5261'DB:business_master_new
loadtime:0.23303699493408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churchville' limit 1
loadtime:0.23306894302368 / seconds
Query Executed:select id FROM `va` where city='Churchville' && SIC_code='5261'DB:business_master_new
loadtime:0.23370790481567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cismont' limit 1
loadtime:0.23374795913696 / seconds
Query Executed:select id FROM `va` where city='Cismont' && SIC_code='5261'DB:business_master_new
loadtime:0.23402881622314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.23405981063843 / seconds
Query Executed:select id FROM `va` where city='Claremont' && SIC_code='5261'DB:business_master_new
loadtime:0.23458290100098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.23461580276489 / seconds
Query Executed:select id FROM `va` where city='Clarksville' && SIC_code='5261'DB:business_master_new
loadtime:0.2353789806366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claudville' limit 1
loadtime:0.23542785644531 / seconds
Query Executed:select id FROM `va` where city='Claudville' && SIC_code='5261'DB:business_master_new
loadtime:0.23608994483948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Brook' limit 1
loadtime:0.23611497879028 / seconds
Query Executed:select id FROM `va` where city='Clear Brook' && SIC_code='5261'DB:business_master_new
loadtime:0.2367639541626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.23679900169373 / seconds
Query Executed:select id FROM `va` where city='Cleveland' && SIC_code='5261'DB:business_master_new
loadtime:0.23733186721802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:0.2373628616333 / seconds
Query Executed:select id FROM `va` where city='Clifford' && SIC_code='5261'DB:business_master_new
loadtime:0.23765397071838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.23768782615662 / seconds
Query Executed:select id FROM `va` where city='Clifton' && SIC_code='5261'DB:business_master_new
loadtime:0.23855590820312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton Forge' limit 1
loadtime:0.23858785629272 / seconds
Query Executed:select id FROM `va` where city='Clifton Forge' && SIC_code='5261'DB:business_master_new
loadtime:0.23935198783875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchco' limit 1
loadtime:0.23940086364746 / seconds
Query Executed:select id FROM `va` where city='Clinchco' && SIC_code='5261'DB:business_master_new
loadtime:0.24001789093018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchport' limit 1
loadtime:0.24004578590393 / seconds
Query Executed:select id FROM `va` where city='Clinchport' && SIC_code='5261'DB:business_master_new
loadtime:0.24036693572998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintwood' limit 1
loadtime:0.24040293693542 / seconds
Query Executed:select id FROM `va` where city='Clintwood' && SIC_code='5261'DB:business_master_new
loadtime:0.24119091033936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:0.24123477935791 / seconds
Query Executed:select id FROM `va` where city='Clover' && SIC_code='5261'DB:business_master_new
loadtime:0.24196195602417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:0.24200296401978 / seconds
Query Executed:select id FROM `va` where city='Cloverdale' && SIC_code='5261'DB:business_master_new
loadtime:0.24263882637024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cluster Springs' limit 1
loadtime:0.24267101287842 / seconds
Query Executed:select id FROM `va` where city='Cluster Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.24292683601379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobbs Creek' limit 1
loadtime:0.24301290512085 / seconds
Query Executed:select id FROM `va` where city='Cobbs Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.24374985694885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobham' limit 1
loadtime:0.24377584457397 / seconds
Query Executed:select id FROM `va` where city='Cobham' && SIC_code='5261'DB:business_master_new
loadtime:0.24401688575745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coeburn' limit 1
loadtime:0.24404978752136 / seconds
Query Executed:select id FROM `va` where city='Coeburn' && SIC_code='5261'DB:business_master_new
loadtime:0.24479198455811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman Falls' limit 1
loadtime:0.24481582641602 / seconds
Query Executed:select id FROM `va` where city='Coleman Falls' && SIC_code='5261'DB:business_master_new
loadtime:0.2451708316803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coles Point' limit 1
loadtime:0.24521780014038 / seconds
Query Executed:select id FROM `va` where city='Coles Point' && SIC_code='5261'DB:business_master_new
loadtime:0.24556183815002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.24558782577515 / seconds
Query Executed:select id FROM `va` where city='Collinsville' && SIC_code='5261'DB:business_master_new
loadtime:0.24640488624573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:0.24643898010254 / seconds
Query Executed:select id FROM `va` where city='Cologne' && SIC_code='5261'DB:business_master_new
loadtime:0.24669885635376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Beach' limit 1
loadtime:0.24673390388489 / seconds
Query Executed:select id FROM `va` where city='Colonial Beach' && SIC_code='5261'DB:business_master_new
loadtime:0.24750590324402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Heights' limit 1
loadtime:0.24755001068115 / seconds
Query Executed:select id FROM `va` where city='Colonial Heights' && SIC_code='5261'DB:business_master_new
loadtime:0.24882292747498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.24887990951538 / seconds
Query Executed:select id FROM `va` where city='Columbia' && SIC_code='5261'DB:business_master_new
loadtime:0.24961996078491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conaway' limit 1
loadtime:0.24965596199036 / seconds
Query Executed:select id FROM `va` where city='Conaway' && SIC_code='5261'DB:business_master_new
loadtime:0.24991679191589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.2499577999115 / seconds
Query Executed:select id FROM `va` where city='Concord' && SIC_code='5261'DB:business_master_new
loadtime:0.25066900253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Hill' limit 1
loadtime:0.25078392028809 / seconds
Query Executed:select id FROM `va` where city='Copper Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.25149488449097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin' limit 1
loadtime:0.25153994560242 / seconds
Query Executed:select id FROM `va` where city='Corbin' && SIC_code='5261'DB:business_master_new
loadtime:0.25190401077271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:0.25194001197815 / seconds
Query Executed:select id FROM `va` where city='Council' && SIC_code='5261'DB:business_master_new
loadtime:0.25225281715393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.25229978561401 / seconds
Query Executed:select id FROM `va` where city='Courtland' && SIC_code='5261'DB:business_master_new
loadtime:0.25312280654907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covesville' limit 1
loadtime:0.25327587127686 / seconds
Query Executed:select id FROM `va` where city='Covesville' && SIC_code='5261'DB:business_master_new
loadtime:0.25385093688965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:0.25389099121094 / seconds
Query Executed:select id FROM `va` where city='Covington' && SIC_code='5261'DB:business_master_new
loadtime:0.25486588478088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craddockville' limit 1
loadtime:0.25490188598633 / seconds
Query Executed:select id FROM `va` where city='Craddockville' && SIC_code='5261'DB:business_master_new
loadtime:0.25530195236206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:0.25538396835327 / seconds
Query Executed:select id FROM `va` where city='Craigsville' && SIC_code='5261'DB:business_master_new
loadtime:0.25608897209167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crewe' limit 1
loadtime:0.25612592697144 / seconds
Query Executed:select id FROM `va` where city='Crewe' && SIC_code='5261'DB:business_master_new
loadtime:0.25686097145081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criders' limit 1
loadtime:0.25690889358521 / seconds
Query Executed:select id FROM `va` where city='Criders' && SIC_code='5261'DB:business_master_new
loadtime:0.25732278823853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criglersville' limit 1
loadtime:0.25735878944397 / seconds
Query Executed:select id FROM `va` where city='Criglersville' && SIC_code='5261'DB:business_master_new
loadtime:0.25761294364929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crimora' limit 1
loadtime:0.25764894485474 / seconds
Query Executed:select id FROM `va` where city='Crimora' && SIC_code='5261'DB:business_master_new
loadtime:0.25837087631226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:0.25840783119202 / seconds
Query Executed:select id FROM `va` where city='Cripple Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.25868582725525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Critz' limit 1
loadtime:0.25872278213501 / seconds
Query Executed:select id FROM `va` where city='Critz' && SIC_code='5261'DB:business_master_new
loadtime:0.25921487808228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crockett' limit 1
loadtime:0.25934290885925 / seconds
Query Executed:select id FROM `va` where city='Crockett' && SIC_code='5261'DB:business_master_new
loadtime:0.25984692573547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Junction' limit 1
loadtime:0.25988388061523 / seconds
Query Executed:select id FROM `va` where city='Cross Junction' && SIC_code='5261'DB:business_master_new
loadtime:0.26053595542908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozet' limit 1
loadtime:0.26057982444763 / seconds
Query Executed:select id FROM `va` where city='Crozet' && SIC_code='5261'DB:business_master_new
loadtime:0.26138877868652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozier' limit 1
loadtime:0.2614438533783 / seconds
Query Executed:select id FROM `va` where city='Crozier' && SIC_code='5261'DB:business_master_new
loadtime:0.26227688789368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Hill' limit 1
loadtime:0.26235294342041 / seconds
Query Executed:select id FROM `va` where city='Crystal Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.26275777816772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullen' limit 1
loadtime:0.26279282569885 / seconds
Query Executed:select id FROM `va` where city='Cullen' && SIC_code='5261'DB:business_master_new
loadtime:0.26324391365051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culpeper' limit 1
loadtime:0.26334095001221 / seconds
Query Executed:select id FROM `va` where city='Culpeper' && SIC_code='5261'DB:business_master_new
loadtime:0.26471400260925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.26477193832397 / seconds
Query Executed:select id FROM `va` where city='Cumberland' && SIC_code='5261'DB:business_master_new
loadtime:0.265469789505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dahlgren' limit 1
loadtime:0.26551485061646 / seconds
Query Executed:select id FROM `va` where city='Dahlgren' && SIC_code='5261'DB:business_master_new
loadtime:0.26623392105103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale City' limit 1
loadtime:0.26636099815369 / seconds
Query Executed:select id FROM `va` where city='Dale City' && SIC_code='5261'DB:business_master_new
loadtime:0.26705980300903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:0.26709580421448 / seconds
Query Executed:select id FROM `va` where city='Daleville' && SIC_code='5261'DB:business_master_new
loadtime:0.26781392097473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:0.26787281036377 / seconds
Query Executed:select id FROM `va` where city='Damascus' && SIC_code='5261'DB:business_master_new
loadtime:0.26855278015137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.26860094070435 / seconds
Query Executed:select id FROM `va` where city='Dante' && SIC_code='5261'DB:business_master_new
loadtime:0.269122838974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.26916098594666 / seconds
Query Executed:select id FROM `va` where city='Danville' && SIC_code='5261'DB:business_master_new
loadtime:0.27737379074097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington Hts' limit 1
loadtime:0.27742195129395 / seconds
Query Executed:select id FROM `va` where city='Darlington Hts' && SIC_code='5261'DB:business_master_new
loadtime:0.27767395973206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:0.27772283554077 / seconds
Query Executed:select id FROM `va` where city='Davenport' && SIC_code='5261'DB:business_master_new
loadtime:0.27811288833618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Wharf' limit 1
loadtime:0.27814793586731 / seconds
Query Executed:select id FROM `va` where city='Davis Wharf' && SIC_code='5261'DB:business_master_new
loadtime:0.27839183807373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.27842497825623 / seconds
Query Executed:select id FROM `va` where city='Dayton' && SIC_code='5261'DB:business_master_new
loadtime:0.27922987937927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.27928686141968 / seconds
Query Executed:select id FROM `va` where city='Deerfield' && SIC_code='5261'DB:business_master_new
loadtime:0.27967190742493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaplane' limit 1
loadtime:0.27971196174622 / seconds
Query Executed:select id FROM `va` where city='Delaplane' && SIC_code='5261'DB:business_master_new
loadtime:0.28041481971741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deltaville' limit 1
loadtime:0.28046178817749 / seconds
Query Executed:select id FROM `va` where city='Deltaville' && SIC_code='5261'DB:business_master_new
loadtime:0.28119993209839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dendron' limit 1
loadtime:0.28125500679016 / seconds
Query Executed:select id FROM `va` where city='Dendron' && SIC_code='5261'DB:business_master_new
loadtime:0.2818009853363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:0.28182888031006 / seconds
Query Executed:select id FROM `va` where city='Dewitt' && SIC_code='5261'DB:business_master_new
loadtime:0.28253698348999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diggs' limit 1
loadtime:0.28258395195007 / seconds
Query Executed:select id FROM `va` where city='Diggs' && SIC_code='5261'DB:business_master_new
loadtime:0.28288078308105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillwyn' limit 1
loadtime:0.28290987014771 / seconds
Query Executed:select id FROM `va` where city='Dillwyn' && SIC_code='5261'DB:business_master_new
loadtime:0.28365778923035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinwiddie' limit 1
loadtime:0.28372693061829 / seconds
Query Executed:select id FROM `va` where city='Dinwiddie' && SIC_code='5261'DB:business_master_new
loadtime:0.28445291519165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Disputanta' limit 1
loadtime:0.28449678421021 / seconds
Query Executed:select id FROM `va` where city='Disputanta' && SIC_code='5261'DB:business_master_new
loadtime:0.28519487380981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doe Hill' limit 1
loadtime:0.28524994850159 / seconds
Query Executed:select id FROM `va` where city='Doe Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.28565979003906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dogue' limit 1
loadtime:0.2856879234314 / seconds
Query Executed:select id FROM `va` where city='Dogue' && SIC_code='5261'DB:business_master_new
loadtime:0.28596878051758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolphin' limit 1
loadtime:0.28600382804871 / seconds
Query Executed:select id FROM `va` where city='Dolphin' && SIC_code='5261'DB:business_master_new
loadtime:0.28643178939819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doran' limit 1
loadtime:0.28647494316101 / seconds
Query Executed:select id FROM `va` where city='Doran' && SIC_code='5261'DB:business_master_new
loadtime:0.28707790374756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doswell' limit 1
loadtime:0.2871949672699 / seconds
Query Executed:select id FROM `va` where city='Doswell' && SIC_code='5261'DB:business_master_new
loadtime:0.28792500495911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakes Branch' limit 1
loadtime:0.28798294067383 / seconds
Query Executed:select id FROM `va` where city='Drakes Branch' && SIC_code='5261'DB:business_master_new
loadtime:0.28867793083191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.28878593444824 / seconds
Query Executed:select id FROM `va` where city='Draper' && SIC_code='5261'DB:business_master_new
loadtime:0.28946590423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewryville' limit 1
loadtime:0.28952193260193 / seconds
Query Executed:select id FROM `va` where city='Drewryville' && SIC_code='5261'DB:business_master_new
loadtime:0.29001498222351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Fork' limit 1
loadtime:0.29005098342896 / seconds
Query Executed:select id FROM `va` where city='Dry Fork' && SIC_code='5261'DB:business_master_new
loadtime:0.29067182540894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:0.29073095321655 / seconds
Query Executed:select id FROM `va` where city='Dryden' && SIC_code='5261'DB:business_master_new
loadtime:0.29148292541504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.29152894020081 / seconds
Query Executed:select id FROM `va` where city='Dublin' && SIC_code='5261'DB:business_master_new
loadtime:0.29238200187683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duffield' limit 1
loadtime:0.29243683815002 / seconds
Query Executed:select id FROM `va` where city='Duffield' && SIC_code='5261'DB:business_master_new
loadtime:0.29316878318787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugspur' limit 1
loadtime:0.293212890625 / seconds
Query Executed:select id FROM `va` where city='Dugspur' && SIC_code='5261'DB:business_master_new
loadtime:0.29373598098755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulles' limit 1
loadtime:0.29377698898315 / seconds
Query Executed:select id FROM `va` where city='Dulles' && SIC_code='5261'DB:business_master_new
loadtime:0.29432082176208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumfries' limit 1
loadtime:0.29436588287354 / seconds
Query Executed:select id FROM `va` where city='Dumfries' && SIC_code='5261'DB:business_master_new
loadtime:0.29533100128174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundas' limit 1
loadtime:0.29537487030029 / seconds
Query Executed:select id FROM `va` where city='Dundas' && SIC_code='5261'DB:business_master_new
loadtime:0.29578900337219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dungannon' limit 1
loadtime:0.2958288192749 / seconds
Query Executed:select id FROM `va` where city='Dungannon' && SIC_code='5261'DB:business_master_new
loadtime:0.29638290405273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn Loring' limit 1
loadtime:0.2964198589325 / seconds
Query Executed:select id FROM `va` where city='Dunn Loring' && SIC_code='5261'DB:business_master_new
loadtime:0.29716300964355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunnsville' limit 1
loadtime:0.29729080200195 / seconds
Query Executed:select id FROM `va` where city='Dunnsville' && SIC_code='5261'DB:business_master_new
loadtime:0.29799890518188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:0.29804587364197 / seconds
Query Executed:select id FROM `va` where city='Dutton' && SIC_code='5261'DB:business_master_new
loadtime:0.29849886894226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyke' limit 1
loadtime:0.29854679107666 / seconds
Query Executed:select id FROM `va` where city='Dyke' && SIC_code='5261'DB:business_master_new
loadtime:0.29901599884033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:0.29906582832336 / seconds
Query Executed:select id FROM `va` where city='Eagle Rock' && SIC_code='5261'DB:business_master_new
loadtime:0.2997989654541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlysville' limit 1
loadtime:0.29983687400818 / seconds
Query Executed:select id FROM `va` where city='Earlysville' && SIC_code='5261'DB:business_master_new
loadtime:0.3005588054657 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Stone Gap' limit 1
loadtime:0.3006157875061 / seconds
Query Executed:select id FROM `va` where city='East Stone Gap' && SIC_code='5261'DB:business_master_new
loadtime:0.30092978477478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastville' limit 1
loadtime:0.30096697807312 / seconds
Query Executed:select id FROM `va` where city='Eastville' && SIC_code='5261'DB:business_master_new
loadtime:0.30166578292847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ebony' limit 1
loadtime:0.30178189277649 / seconds
Query Executed:select id FROM `va` where city='Ebony' && SIC_code='5261'DB:business_master_new
loadtime:0.30231881141663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:0.3023669719696 / seconds
Query Executed:select id FROM `va` where city='Edinburg' && SIC_code='5261'DB:business_master_new
loadtime:0.3031690120697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:0.30326700210571 / seconds
Query Executed:select id FROM `va` where city='Edwardsville' && SIC_code='5261'DB:business_master_new
loadtime:0.30357789993286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eggleston' limit 1
loadtime:0.30361580848694 / seconds
Query Executed:select id FROM `va` where city='Eggleston' && SIC_code='5261'DB:business_master_new
loadtime:0.30398392677307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:0.30402088165283 / seconds
Query Executed:select id FROM `va` where city='Elberon' && SIC_code='5261'DB:business_master_new
loadtime:0.30448484420776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Creek' limit 1
loadtime:0.30453300476074 / seconds
Query Executed:select id FROM `va` where city='Elk Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.30516290664673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:0.30521082878113 / seconds
Query Executed:select id FROM `va` where city='Elk Garden' && SIC_code='5261'DB:business_master_new
loadtime:0.3054518699646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.30548501014709 / seconds
Query Executed:select id FROM `va` where city='Elkton' && SIC_code='5261'DB:business_master_new
loadtime:0.30633878707886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkwood' limit 1
loadtime:0.30648684501648 / seconds
Query Executed:select id FROM `va` where city='Elkwood' && SIC_code='5261'DB:business_master_new
loadtime:0.30713891983032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliston' limit 1
loadtime:0.30718088150024 / seconds
Query Executed:select id FROM `va` where city='Elliston' && SIC_code='5261'DB:business_master_new
loadtime:0.30780577659607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emory' limit 1
loadtime:0.30785179138184 / seconds
Query Executed:select id FROM `va` where city='Emory' && SIC_code='5261'DB:business_master_new
loadtime:0.30819892883301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:0.30822682380676 / seconds
Query Executed:select id FROM `va` where city='Emporia' && SIC_code='5261'DB:business_master_new
loadtime:0.30926895141602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engleside' limit 1
loadtime:0.3094208240509 / seconds
Query Executed:select id FROM `va` where city='Engleside' && SIC_code='5261'DB:business_master_new
loadtime:0.30990386009216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esmont' limit 1
loadtime:0.30993294715881 / seconds
Query Executed:select id FROM `va` where city='Esmont' && SIC_code='5261'DB:business_master_new
loadtime:0.31045699119568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etlan' limit 1
loadtime:0.31051278114319 / seconds
Query Executed:select id FROM `va` where city='Etlan' && SIC_code='5261'DB:business_master_new
loadtime:0.31082677841187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:0.31086683273315 / seconds
Query Executed:select id FROM `va` where city='Ettrick' && SIC_code='5261'DB:business_master_new
loadtime:0.31110382080078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:0.31114077568054 / seconds
Query Executed:select id FROM `va` where city='Evergreen' && SIC_code='5261'DB:business_master_new
loadtime:0.3114869594574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evington' limit 1
loadtime:0.31152081489563 / seconds
Query Executed:select id FROM `va` where city='Evington' && SIC_code='5261'DB:business_master_new
loadtime:0.31221890449524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewing' limit 1
loadtime:0.31226778030396 / seconds
Query Executed:select id FROM `va` where city='Ewing' && SIC_code='5261'DB:business_master_new
loadtime:0.31327390670776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exmore' limit 1
loadtime:0.31332278251648 / seconds
Query Executed:select id FROM `va` where city='Exmore' && SIC_code='5261'DB:business_master_new
loadtime:0.31415200233459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faber' limit 1
loadtime:0.31427383422852 / seconds
Query Executed:select id FROM `va` where city='Faber' && SIC_code='5261'DB:business_master_new
loadtime:0.31509900093079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.31514883041382 / seconds
Query Executed:select id FROM `va` where city='Fairfax' && SIC_code='5261'DB:business_master_new
loadtime:0.32338500022888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax Station' limit 1
loadtime:0.3234498500824 / seconds
Query Executed:select id FROM `va` where city='Fairfax Station' && SIC_code='5261'DB:business_master_new
loadtime:0.32444787025452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.32450485229492 / seconds
Query Executed:select id FROM `va` where city='Fairfield' && SIC_code='5261'DB:business_master_new
loadtime:0.32519197463989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlawn' limit 1
loadtime:0.32525086402893 / seconds
Query Executed:select id FROM `va` where city='Fairlawn' && SIC_code='5261'DB:business_master_new
loadtime:0.32555079460144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Church' limit 1
loadtime:0.32557988166809 / seconds
Query Executed:select id FROM `va` where city='Falls Church' && SIC_code='5261'DB:business_master_new
loadtime:0.33376097679138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Mills' limit 1
loadtime:0.3338189125061 / seconds
Query Executed:select id FROM `va` where city='Falls Mills' && SIC_code='5261'DB:business_master_new
loadtime:0.33435797691345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.3343939781189 / seconds
Query Executed:select id FROM `va` where city='Falmouth' && SIC_code='5261'DB:business_master_new
loadtime:0.33464694023132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fancy Gap' limit 1
loadtime:0.33468079566956 / seconds
Query Executed:select id FROM `va` where city='Fancy Gap' && SIC_code='5261'DB:business_master_new
loadtime:0.33536887168884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:0.33549690246582 / seconds
Query Executed:select id FROM `va` where city='Farmville' && SIC_code='5261'DB:business_master_new
loadtime:0.33671092987061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnham' limit 1
loadtime:0.33676791191101 / seconds
Query Executed:select id FROM `va` where city='Farnham' && SIC_code='5261'DB:business_master_new
loadtime:0.33760190010071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrum' limit 1
loadtime:0.33765387535095 / seconds
Query Executed:select id FROM `va` where city='Ferrum' && SIC_code='5261'DB:business_master_new
loadtime:0.33842182159424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldale' limit 1
loadtime:0.33855295181274 / seconds
Query Executed:select id FROM `va` where city='Fieldale' && SIC_code='5261'DB:business_master_new
loadtime:0.33931589126587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:0.33936285972595 / seconds
Query Executed:select id FROM `va` where city='Fife' && SIC_code='5261'DB:business_master_new
loadtime:0.33961582183838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fincastle' limit 1
loadtime:0.33964991569519 / seconds
Query Executed:select id FROM `va` where city='Fincastle' && SIC_code='5261'DB:business_master_new
loadtime:0.3403959274292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishers Hill' limit 1
loadtime:0.34043979644775 / seconds
Query Executed:select id FROM `va` where city='Fishers Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.34076499938965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishersville' limit 1
loadtime:0.34080481529236 / seconds
Query Executed:select id FROM `va` where city='Fishersville' && SIC_code='5261'DB:business_master_new
loadtime:0.3416268825531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint Hill' limit 1
loadtime:0.34167194366455 / seconds
Query Executed:select id FROM `va` where city='Flint Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.34254288673401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.3425989151001 / seconds
Query Executed:select id FROM `va` where city='Floyd' && SIC_code='5261'DB:business_master_new
loadtime:0.34352087974548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foneswood' limit 1
loadtime:0.34356689453125 / seconds
Query Executed:select id FROM `va` where city='Foneswood' && SIC_code='5261'DB:business_master_new
loadtime:0.34383487701416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:0.34387588500977 / seconds
Query Executed:select id FROM `va` where city='Ford' && SIC_code='5261'DB:business_master_new
loadtime:0.3443398475647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:0.34438395500183 / seconds
Query Executed:select id FROM `va` where city='Forest' && SIC_code='5261'DB:business_master_new
loadtime:0.34549498558044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork Union' limit 1
loadtime:0.34567379951477 / seconds
Query Executed:select id FROM `va` where city='Fork Union' && SIC_code='5261'DB:business_master_new
loadtime:0.3468279838562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Belvoir' limit 1
loadtime:0.34687185287476 / seconds
Query Executed:select id FROM `va` where city='Fort Belvoir' && SIC_code='5261'DB:business_master_new
loadtime:0.34757781028748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Blackmore' limit 1
loadtime:0.34762787818909 / seconds
Query Executed:select id FROM `va` where city='Fort Blackmore' && SIC_code='5261'DB:business_master_new
loadtime:0.34811687469482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:0.34815382957458 / seconds
Query Executed:select id FROM `va` where city='Fort Defiance' && SIC_code='5261'DB:business_master_new
loadtime:0.34872484207153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Eustis' limit 1
loadtime:0.34878087043762 / seconds
Query Executed:select id FROM `va` where city='Fort Eustis' && SIC_code='5261'DB:business_master_new
loadtime:0.34942889213562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:0.34947299957275 / seconds
Query Executed:select id FROM `va` where city='Fort Lee' && SIC_code='5261'DB:business_master_new
loadtime:0.3505539894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:0.35059285163879 / seconds
Query Executed:select id FROM `va` where city='Fort Mitchell' && SIC_code='5261'DB:business_master_new
loadtime:0.35086297988892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monroe' limit 1
loadtime:0.35090184211731 / seconds
Query Executed:select id FROM `va` where city='Fort Monroe' && SIC_code='5261'DB:business_master_new
loadtime:0.3514997959137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Myer' limit 1
loadtime:0.35154390335083 / seconds
Query Executed:select id FROM `va` where city='Fort Myer' && SIC_code='5261'DB:business_master_new
loadtime:0.35232782363892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Valley' limit 1
loadtime:0.35242486000061 / seconds
Query Executed:select id FROM `va` where city='Fort Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.35327100753784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:0.35332083702087 / seconds
Query Executed:select id FROM `va` where city='Foster' && SIC_code='5261'DB:business_master_new
loadtime:0.35371780395508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.35375595092773 / seconds
Query Executed:select id FROM `va` where city='Franconia' && SIC_code='5261'DB:business_master_new
loadtime:0.35409879684448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.35414385795593 / seconds
Query Executed:select id FROM `va` where city='Franklin' && SIC_code='5261'DB:business_master_new
loadtime:0.35515189170837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:0.35526895523071 / seconds
Query Executed:select id FROM `va` where city='Franktown' && SIC_code='5261'DB:business_master_new
loadtime:0.35581994056702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:0.35586595535278 / seconds
Query Executed:select id FROM `va` where city='Fredericksburg' && SIC_code='5261'DB:business_master_new
loadtime:0.36407399177551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Union' limit 1
loadtime:0.36412882804871 / seconds
Query Executed:select id FROM `va` where city='Free Union' && SIC_code='5261'DB:business_master_new
loadtime:0.36504077911377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.36516094207764 / seconds
Query Executed:select id FROM `va` where city='Freeman' && SIC_code='5261'DB:business_master_new
loadtime:0.36572790145874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fries' limit 1
loadtime:0.36577486991882 / seconds
Query Executed:select id FROM `va` where city='Fries' && SIC_code='5261'DB:business_master_new
loadtime:0.36644101142883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Front Royal' limit 1
loadtime:0.36648488044739 / seconds
Query Executed:select id FROM `va` where city='Front Royal' && SIC_code='5261'DB:business_master_new
loadtime:0.36783480644226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ft Myer' limit 1
loadtime:0.36787986755371 / seconds
Query Executed:select id FROM `va` where city='Ft Myer' && SIC_code='5261'DB:business_master_new
loadtime:0.3681538105011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulks Run' limit 1
loadtime:0.36825895309448 / seconds
Query Executed:select id FROM `va` where city='Fulks Run' && SIC_code='5261'DB:business_master_new
loadtime:0.3691987991333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:0.36934781074524 / seconds
Query Executed:select id FROM `va` where city='Gainesville' && SIC_code='5261'DB:business_master_new
loadtime:0.3703248500824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galax' limit 1
loadtime:0.37036800384521 / seconds
Query Executed:select id FROM `va` where city='Galax' && SIC_code='5261'DB:business_master_new
loadtime:0.37139797210693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrisonville' limit 1
loadtime:0.37145400047302 / seconds
Query Executed:select id FROM `va` where city='Garrisonville' && SIC_code='5261'DB:business_master_new
loadtime:0.37217283248901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gasburg' limit 1
loadtime:0.37229180335999 / seconds
Query Executed:select id FROM `va` where city='Gasburg' && SIC_code='5261'DB:business_master_new
loadtime:0.37313294410706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gate City' limit 1
loadtime:0.37318181991577 / seconds
Query Executed:select id FROM `va` where city='Gate City' && SIC_code='5261'DB:business_master_new
loadtime:0.37399578094482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Hill' limit 1
loadtime:0.37403988838196 / seconds
Query Executed:select id FROM `va` where city='Glade Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.37471580505371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Spring' limit 1
loadtime:0.3747718334198 / seconds
Query Executed:select id FROM `va` where city='Glade Spring' && SIC_code='5261'DB:business_master_new
loadtime:0.37551784515381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladehill' limit 1
loadtime:0.37556886672974 / seconds
Query Executed:select id FROM `va` where city='Gladehill' && SIC_code='5261'DB:business_master_new
loadtime:0.37582397460938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:0.37586283683777 / seconds
Query Executed:select id FROM `va` where city='Gladstone' && SIC_code='5261'DB:business_master_new
loadtime:0.37661981582642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladys' limit 1
loadtime:0.37665581703186 / seconds
Query Executed:select id FROM `va` where city='Gladys' && SIC_code='5261'DB:business_master_new
loadtime:0.37737894058228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:0.37750101089478 / seconds
Query Executed:select id FROM `va` where city='Glasgow' && SIC_code='5261'DB:business_master_new
loadtime:0.37847495079041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:0.3785228729248 / seconds
Query Executed:select id FROM `va` where city='Glen Allen' && SIC_code='5261'DB:business_master_new
loadtime:0.38018989562988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Lyn' limit 1
loadtime:0.38025498390198 / seconds
Query Executed:select id FROM `va` where city='Glen Lyn' && SIC_code='5261'DB:business_master_new
loadtime:0.38080286979675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Wilton' limit 1
loadtime:0.38084292411804 / seconds
Query Executed:select id FROM `va` where city='Glen Wilton' && SIC_code='5261'DB:business_master_new
loadtime:0.38111901283264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.38114380836487 / seconds
Query Executed:select id FROM `va` where city='Gloucester' && SIC_code='5261'DB:business_master_new
loadtime:0.38226389884949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester Point' limit 1
loadtime:0.38232088088989 / seconds
Query Executed:select id FROM `va` where city='Gloucester Point' && SIC_code='5261'DB:business_master_new
loadtime:0.38301777839661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldbond' limit 1
loadtime:0.38305377960205 / seconds
Query Executed:select id FROM `va` where city='Goldbond' && SIC_code='5261'DB:business_master_new
loadtime:0.38330292701721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldvein' limit 1
loadtime:0.38334083557129 / seconds
Query Executed:select id FROM `va` where city='Goldvein' && SIC_code='5261'DB:business_master_new
loadtime:0.38398385047913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goochland' limit 1
loadtime:0.3840389251709 / seconds
Query Executed:select id FROM `va` where city='Goochland' && SIC_code='5261'DB:business_master_new
loadtime:0.38476085662842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goode' limit 1
loadtime:0.38479685783386 / seconds
Query Executed:select id FROM `va` where city='Goode' && SIC_code='5261'DB:business_master_new
loadtime:0.38544082641602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodview' limit 1
loadtime:0.38548898696899 / seconds
Query Executed:select id FROM `va` where city='Goodview' && SIC_code='5261'DB:business_master_new
loadtime:0.38617587089539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordonsville' limit 1
loadtime:0.38623189926147 / seconds
Query Executed:select id FROM `va` where city='Gordonsville' && SIC_code='5261'DB:business_master_new
loadtime:0.38701701164246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore' limit 1
loadtime:0.38706183433533 / seconds
Query Executed:select id FROM `va` where city='Gore' && SIC_code='5261'DB:business_master_new
loadtime:0.38804888725281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.38809585571289 / seconds
Query Executed:select id FROM `va` where city='Goshen' && SIC_code='5261'DB:business_master_new
loadtime:0.38868093490601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.38873100280762 / seconds
Query Executed:select id FROM `va` where city='Grafton' && SIC_code='5261'DB:business_master_new
loadtime:0.38918900489807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graves Mill' limit 1
loadtime:0.38923192024231 / seconds
Query Executed:select id FROM `va` where city='Graves Mill' && SIC_code='5261'DB:business_master_new
loadtime:0.38949680328369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:0.38952779769897 / seconds
Query Executed:select id FROM `va` where city='Great Falls' && SIC_code='5261'DB:business_master_new
loadtime:0.39064288139343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:0.39071178436279 / seconds
Query Executed:select id FROM `va` where city='Green Bay' && SIC_code='5261'DB:business_master_new
loadtime:0.39123487472534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbackville' limit 1
loadtime:0.39128994941711 / seconds
Query Executed:select id FROM `va` where city='Greenbackville' && SIC_code='5261'DB:business_master_new
loadtime:0.39173889160156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:0.39177680015564 / seconds
Query Executed:select id FROM `va` where city='Greenbush' && SIC_code='5261'DB:business_master_new
loadtime:0.39217090606689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.39221596717834 / seconds
Query Executed:select id FROM `va` where city='Greenville' && SIC_code='5261'DB:business_master_new
loadtime:0.39309191703796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenway' limit 1
loadtime:0.39313578605652 / seconds
Query Executed:select id FROM `va` where city='Greenway' && SIC_code='5261'DB:business_master_new
loadtime:0.39343786239624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.39347696304321 / seconds
Query Executed:select id FROM `va` where city='Greenwood' && SIC_code='5261'DB:business_master_new
loadtime:0.3940908908844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gretna' limit 1
loadtime:0.39424180984497 / seconds
Query Executed:select id FROM `va` where city='Gretna' && SIC_code='5261'DB:business_master_new
loadtime:0.39515495300293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimstead' limit 1
loadtime:0.39526700973511 / seconds
Query Executed:select id FROM `va` where city='Grimstead' && SIC_code='5261'DB:business_master_new
loadtime:0.39559578895569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grottoes' limit 1
loadtime:0.39562392234802 / seconds
Query Executed:select id FROM `va` where city='Grottoes' && SIC_code='5261'DB:business_master_new
loadtime:0.39635801315308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy' limit 1
loadtime:0.39650678634644 / seconds
Query Executed:select id FROM `va` where city='Grundy' && SIC_code='5261'DB:business_master_new
loadtime:0.39748597145081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gum Spring' limit 1
loadtime:0.39760184288025 / seconds
Query Executed:select id FROM `va` where city='Gum Spring' && SIC_code='5261'DB:business_master_new
loadtime:0.39846992492676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwynn' limit 1
loadtime:0.39852499961853 / seconds
Query Executed:select id FROM `va` where city='Gwynn' && SIC_code='5261'DB:business_master_new
loadtime:0.39889883995056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacksneck' limit 1
loadtime:0.39892888069153 / seconds
Query Executed:select id FROM `va` where city='Hacksneck' && SIC_code='5261'DB:business_master_new
loadtime:0.39924383163452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadensville' limit 1
loadtime:0.3992908000946 / seconds
Query Executed:select id FROM `va` where city='Hadensville' && SIC_code='5261'DB:business_master_new
loadtime:0.39960789680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hague' limit 1
loadtime:0.39965081214905 / seconds
Query Executed:select id FROM `va` where city='Hague' && SIC_code='5261'DB:business_master_new
loadtime:0.40055298805237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.40058779716492 / seconds
Query Executed:select id FROM `va` where city='Halifax' && SIC_code='5261'DB:business_master_new
loadtime:0.40143585205078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallieford' limit 1
loadtime:0.40149092674255 / seconds
Query Executed:select id FROM `va` where city='Hallieford' && SIC_code='5261'DB:business_master_new
loadtime:0.40181088447571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallwood' limit 1
loadtime:0.40184092521667 / seconds
Query Executed:select id FROM `va` where city='Hallwood' && SIC_code='5261'DB:business_master_new
loadtime:0.40230989456177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.40236783027649 / seconds
Query Executed:select id FROM `va` where city='Hamilton' && SIC_code='5261'DB:business_master_new
loadtime:0.40307879447937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden Sydney' limit 1
loadtime:0.40313482284546 / seconds
Query Executed:select id FROM `va` where city='Hampden Sydney' && SIC_code='5261'DB:business_master_new
loadtime:0.4035530090332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.40359091758728 / seconds
Query Executed:select id FROM `va` where city='Hampton' && SIC_code='5261'DB:business_master_new
loadtime:0.4120659828186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.4121298789978 / seconds
Query Executed:select id FROM `va` where city='Hanover' && SIC_code='5261'DB:business_master_new
loadtime:0.41285991668701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harborton' limit 1
loadtime:0.41290378570557 / seconds
Query Executed:select id FROM `va` where city='Harborton' && SIC_code='5261'DB:business_master_new
loadtime:0.41328978538513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:0.41333699226379 / seconds
Query Executed:select id FROM `va` where city='Hardy' && SIC_code='5261'DB:business_master_new
loadtime:0.41410994529724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardyville' limit 1
loadtime:0.41414785385132 / seconds
Query Executed:select id FROM `va` where city='Hardyville' && SIC_code='5261'DB:business_master_new
loadtime:0.41454195976257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:0.41458988189697 / seconds
Query Executed:select id FROM `va` where city='Harman' && SIC_code='5261'DB:business_master_new
loadtime:0.41487979888916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonburg' limit 1
loadtime:0.41491484642029 / seconds
Query Executed:select id FROM `va` where city='Harrisonburg' && SIC_code='5261'DB:business_master_new
loadtime:0.41691088676453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartfield' limit 1
loadtime:0.41695785522461 / seconds
Query Executed:select id FROM `va` where city='Hartfield' && SIC_code='5261'DB:business_master_new
loadtime:0.41803288459778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwood' limit 1
loadtime:0.41808891296387 / seconds
Query Executed:select id FROM `va` where city='Hartwood' && SIC_code='5261'DB:business_master_new
loadtime:0.4186098575592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.41865396499634 / seconds
Query Executed:select id FROM `va` where city='Hayes' && SIC_code='5261'DB:business_master_new
loadtime:0.4195249080658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haymarket' limit 1
loadtime:0.41958093643188 / seconds
Query Executed:select id FROM `va` where city='Haymarket' && SIC_code='5261'DB:business_master_new
loadtime:0.42053079605103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haynesville' limit 1
loadtime:0.42057681083679 / seconds
Query Executed:select id FROM `va` where city='Haynesville' && SIC_code='5261'DB:business_master_new
loadtime:0.4210319519043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysi' limit 1
loadtime:0.4210958480835 / seconds
Query Executed:select id FROM `va` where city='Haysi' && SIC_code='5261'DB:business_master_new
loadtime:0.42175984382629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:0.42179584503174 / seconds
Query Executed:select id FROM `va` where city='Haywood' && SIC_code='5261'DB:business_master_new
loadtime:0.42213892936707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Head Waters' limit 1
loadtime:0.42218685150146 / seconds
Query Executed:select id FROM `va` where city='Head Waters' && SIC_code='5261'DB:business_master_new
loadtime:0.42250895500183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heathsville' limit 1
loadtime:0.42254185676575 / seconds
Query Executed:select id FROM `va` where city='Heathsville' && SIC_code='5261'DB:business_master_new
loadtime:0.42334294319153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.42344689369202 / seconds
Query Executed:select id FROM `va` where city='Henry' && SIC_code='5261'DB:business_master_new
loadtime:0.4242467880249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:0.42428278923035 / seconds
Query Executed:select id FROM `va` where city='Herndon' && SIC_code='5261'DB:business_master_new
loadtime:0.43249583244324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Springs' limit 1
loadtime:0.43255186080933 / seconds
Query Executed:select id FROM `va` where city='Highland Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.43287777900696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightown' limit 1
loadtime:0.43290495872498 / seconds
Query Executed:select id FROM `va` where city='Hightown' && SIC_code='5261'DB:business_master_new
loadtime:0.43316197395325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsville' limit 1
loadtime:0.4331967830658 / seconds
Query Executed:select id FROM `va` where city='Hillsville' && SIC_code='5261'DB:business_master_new
loadtime:0.43407297134399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiltons' limit 1
loadtime:0.43411588668823 / seconds
Query Executed:select id FROM `va` where city='Hiltons' && SIC_code='5261'DB:business_master_new
loadtime:0.43464589118958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:0.43470788002014 / seconds
Query Executed:select id FROM `va` where city='Hinton' && SIC_code='5261'DB:business_master_new
loadtime:0.4353129863739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiwassee' limit 1
loadtime:0.43542981147766 / seconds
Query Executed:select id FROM `va` where city='Hiwassee' && SIC_code='5261'DB:business_master_new
loadtime:0.43620681762695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:0.43633484840393 / seconds
Query Executed:select id FROM `va` where city='Hollins' && SIC_code='5261'DB:business_master_new
loadtime:0.43665885925293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaker' limit 1
loadtime:0.43670582771301 / seconds
Query Executed:select id FROM `va` where city='Honaker' && SIC_code='5261'DB:business_master_new
loadtime:0.43741178512573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood' limit 1
loadtime:0.43750786781311 / seconds
Query Executed:select id FROM `va` where city='Hood' && SIC_code='5261'DB:business_master_new
loadtime:0.43791079521179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:0.43794989585876 / seconds
Query Executed:select id FROM `va` where city='Hopewell' && SIC_code='5261'DB:business_master_new
loadtime:0.43904781341553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horntown' limit 1
loadtime:0.43909287452698 / seconds
Query Executed:select id FROM `va` where city='Horntown' && SIC_code='5261'DB:business_master_new
loadtime:0.43951082229614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horsepen' limit 1
loadtime:0.43955898284912 / seconds
Query Executed:select id FROM `va` where city='Horsepen' && SIC_code='5261'DB:business_master_new
loadtime:0.43980693817139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.43984580039978 / seconds
Query Executed:select id FROM `va` where city='Hot Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.44050097465515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howardsville' limit 1
loadtime:0.44054388999939 / seconds
Query Executed:select id FROM `va` where city='Howardsville' && SIC_code='5261'DB:business_master_new
loadtime:0.44087696075439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howertons' limit 1
loadtime:0.44090294837952 / seconds
Query Executed:select id FROM `va` where city='Howertons' && SIC_code='5261'DB:business_master_new
loadtime:0.44114995002747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huddleston' limit 1
loadtime:0.44118499755859 / seconds
Query Executed:select id FROM `va` where city='Huddleston' && SIC_code='5261'DB:business_master_new
loadtime:0.44182586669922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudgins' limit 1
loadtime:0.44185996055603 / seconds
Query Executed:select id FROM `va` where city='Hudgins' && SIC_code='5261'DB:business_master_new
loadtime:0.44240593910217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hume' limit 1
loadtime:0.44244980812073 / seconds
Query Executed:select id FROM `va` where city='Hume' && SIC_code='5261'DB:business_master_new
loadtime:0.44309687614441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntly' limit 1
loadtime:0.44313287734985 / seconds
Query Executed:select id FROM `va` where city='Huntly' && SIC_code='5261'DB:business_master_new
loadtime:0.44353580474854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.44357800483704 / seconds
Query Executed:select id FROM `va` where city='Hurley' && SIC_code='5261'DB:business_master_new
loadtime:0.44439888000488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurt' limit 1
loadtime:0.44444584846497 / seconds
Query Executed:select id FROM `va` where city='Hurt' && SIC_code='5261'DB:business_master_new
loadtime:0.44514799118042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustle' limit 1
loadtime:0.44518280029297 / seconds
Query Executed:select id FROM `va` where city='Hustle' && SIC_code='5261'DB:business_master_new
loadtime:0.4455099105835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.44554781913757 / seconds
Query Executed:select id FROM `va` where city='Independence' && SIC_code='5261'DB:business_master_new
loadtime:0.44632792472839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Valley' limit 1
loadtime:0.4463849067688 / seconds
Query Executed:select id FROM `va` where city='Indian Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.44672298431396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Gate' limit 1
loadtime:0.44678378105164 / seconds
Query Executed:select id FROM `va` where city='Iron Gate' && SIC_code='5261'DB:business_master_new
loadtime:0.44729590415955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironto' limit 1
loadtime:0.44742393493652 / seconds
Query Executed:select id FROM `va` where city='Ironto' && SIC_code='5261'DB:business_master_new
loadtime:0.44779396057129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:0.44788599014282 / seconds
Query Executed:select id FROM `va` where city='Irvington' && SIC_code='5261'DB:business_master_new
loadtime:0.4486198425293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Wight' limit 1
loadtime:0.44865489006042 / seconds
Query Executed:select id FROM `va` where city='Isle Of Wight' && SIC_code='5261'DB:business_master_new
loadtime:0.44924592971802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:0.4493408203125 / seconds
Query Executed:select id FROM `va` where city='Ivanhoe' && SIC_code='5261'DB:business_master_new
loadtime:0.44991588592529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivor' limit 1
loadtime:0.44995379447937 / seconds
Query Executed:select id FROM `va` where city='Ivor' && SIC_code='5261'DB:business_master_new
loadtime:0.4505729675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivy' limit 1
loadtime:0.45062494277954 / seconds
Query Executed:select id FROM `va` where city='Ivy' && SIC_code='5261'DB:business_master_new
loadtime:0.45144891738892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.45160794258118 / seconds
Query Executed:select id FROM `va` where city='Jamaica' && SIC_code='5261'DB:business_master_new
loadtime:0.45207500457764 / seconds
Query loaded from cache:select * from geodata_geocity where city='James Store' limit 1
loadtime:0.45210981369019 / seconds
Query Executed:select id FROM `va` where city='James Store' && SIC_code='5261'DB:business_master_new
loadtime:0.45234990119934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.45244884490967 / seconds
Query Executed:select id FROM `va` where city='Jamestown' && SIC_code='5261'DB:business_master_new
loadtime:0.45277786254883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:0.45281291007996 / seconds
Query Executed:select id FROM `va` where city='Jamesville' && SIC_code='5261'DB:business_master_new
loadtime:0.45313382148743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarratt' limit 1
loadtime:0.45316982269287 / seconds
Query Executed:select id FROM `va` where city='Jarratt' && SIC_code='5261'DB:business_master_new
loadtime:0.45378279685974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.45382285118103 / seconds
Query Executed:select id FROM `va` where city='Java' && SIC_code='5261'DB:business_master_new
loadtime:0.4544198513031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonton' limit 1
loadtime:0.45445585250854 / seconds
Query Executed:select id FROM `va` where city='Jeffersonton' && SIC_code='5261'DB:business_master_new
loadtime:0.45533299446106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkins Bridge' limit 1
loadtime:0.45543885231018 / seconds
Query Executed:select id FROM `va` where city='Jenkins Bridge' && SIC_code='5261'DB:business_master_new
loadtime:0.45576691627502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey' limit 1
loadtime:0.45579195022583 / seconds
Query Executed:select id FROM `va` where city='Jersey' && SIC_code='5261'DB:business_master_new
loadtime:0.45609879493713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetersville' limit 1
loadtime:0.45614695549011 / seconds
Query Executed:select id FROM `va` where city='Jetersville' && SIC_code='5261'DB:business_master_new
loadtime:0.45676279067993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell Ridge' limit 1
loadtime:0.45680093765259 / seconds
Query Executed:select id FROM `va` where city='Jewell Ridge' && SIC_code='5261'DB:business_master_new
loadtime:0.45719480514526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.4572389125824 / seconds
Query Executed:select id FROM `va` where city='Jonesville' && SIC_code='5261'DB:business_master_new
loadtime:0.45801281929016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keeling' limit 1
loadtime:0.45811080932617 / seconds
Query Executed:select id FROM `va` where city='Keeling' && SIC_code='5261'DB:business_master_new
loadtime:0.45873188972473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keen Mountain' limit 1
loadtime:0.45876789093018 / seconds
Query Executed:select id FROM `va` where city='Keen Mountain' && SIC_code='5261'DB:business_master_new
loadtime:0.45927286148071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:0.45939493179321 / seconds
Query Executed:select id FROM `va` where city='Keene' && SIC_code='5261'DB:business_master_new
loadtime:0.45988082885742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keezletown' limit 1
loadtime:0.45990896224976 / seconds
Query Executed:select id FROM `va` where city='Keezletown' && SIC_code='5261'DB:business_master_new
loadtime:0.46053791046143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:0.46058392524719 / seconds
Query Executed:select id FROM `va` where city='Keller' && SIC_code='5261'DB:business_master_new
loadtime:0.46111798286438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenbridge' limit 1
loadtime:0.46117281913757 / seconds
Query Executed:select id FROM `va` where city='Kenbridge' && SIC_code='5261'DB:business_master_new
loadtime:0.46187996864319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kents Store' limit 1
loadtime:0.46191477775574 / seconds
Query Executed:select id FROM `va` where city='Kents Store' && SIC_code='5261'DB:business_master_new
loadtime:0.46257495880127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokee' limit 1
loadtime:0.46262192726135 / seconds
Query Executed:select id FROM `va` where city='Keokee' && SIC_code='5261'DB:business_master_new
loadtime:0.46307182312012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:0.46310782432556 / seconds
Query Executed:select id FROM `va` where city='Keswick' && SIC_code='5261'DB:business_master_new
loadtime:0.46381378173828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keysville' limit 1
loadtime:0.46385383605957 / seconds
Query Executed:select id FROM `va` where city='Keysville' && SIC_code='5261'DB:business_master_new
loadtime:0.46458292007446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmarnock' limit 1
loadtime:0.46463489532471 / seconds
Query Executed:select id FROM `va` where city='Kilmarnock' && SIC_code='5261'DB:business_master_new
loadtime:0.46552681922913 / seconds
Query loaded from cache:select * from geodata_geocity where city='King & Queen C H' limit 1
loadtime:0.46556282043457 / seconds
Query Executed:select id FROM `va` where city='King & Queen C H' && SIC_code='5261'DB:business_master_new
loadtime:0.46584892272949 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court Hous' limit 1
loadtime:0.46588587760925 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court Hous' && SIC_code='5261'DB:business_master_new
loadtime:0.46612095832825 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court House' limit 1
loadtime:0.46614599227905 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court House' && SIC_code='5261'DB:business_master_new
loadtime:0.46676397323608 / seconds
Query loaded from cache:select * from geodata_geocity where city='King George' limit 1
loadtime:0.46679878234863 / seconds
Query Executed:select id FROM `va` where city='King George' && SIC_code='5261'DB:business_master_new
loadtime:0.46773481369019 / seconds
Query loaded from cache:select * from geodata_geocity where city='King William' limit 1
loadtime:0.46777987480164 / seconds
Query Executed:select id FROM `va` where city='King William' && SIC_code='5261'DB:business_master_new
loadtime:0.46849894523621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsale' limit 1
loadtime:0.46855497360229 / seconds
Query Executed:select id FROM `va` where city='Kinsale' && SIC_code='5261'DB:business_master_new
loadtime:0.46937680244446 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:0.46953296661377 / seconds
Query Executed:select id FROM `va` where city='La Crosse' && SIC_code='5261'DB:business_master_new
loadtime:0.47037577629089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey Spring' limit 1
loadtime:0.47049283981323 / seconds
Query Executed:select id FROM `va` where city='Lacey Spring' && SIC_code='5261'DB:business_master_new
loadtime:0.47090983390808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lackey' limit 1
loadtime:0.47094893455505 / seconds
Query Executed:select id FROM `va` where city='Lackey' && SIC_code='5261'DB:business_master_new
loadtime:0.47139596939087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:0.47152090072632 / seconds
Query Executed:select id FROM `va` where city='Ladysmith' && SIC_code='5261'DB:business_master_new
loadtime:0.47238087654114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:0.47251582145691 / seconds
Query Executed:select id FROM `va` where city='Lafayette' && SIC_code='5261'DB:business_master_new
loadtime:0.47285389900208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambsburg' limit 1
loadtime:0.47289085388184 / seconds
Query Executed:select id FROM `va` where city='Lambsburg' && SIC_code='5261'DB:business_master_new
loadtime:0.47333979606628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.47345685958862 / seconds
Query Executed:select id FROM `va` where city='Lancaster' && SIC_code='5261'DB:business_master_new
loadtime:0.47425484657288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laneview' limit 1
loadtime:0.474289894104 / seconds
Query Executed:select id FROM `va` where city='Laneview' && SIC_code='5261'DB:business_master_new
loadtime:0.47468185424805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanexa' limit 1
loadtime:0.47473382949829 / seconds
Query Executed:select id FROM `va` where city='Lanexa' && SIC_code='5261'DB:business_master_new
loadtime:0.47545099258423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley Afb' limit 1
loadtime:0.47554779052734 / seconds
Query Executed:select id FROM `va` where city='Langley Afb' && SIC_code='5261'DB:business_master_new
loadtime:0.47599983215332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Fork' limit 1
loadtime:0.4760479927063 / seconds
Query Executed:select id FROM `va` where city='Laurel Fork' && SIC_code='5261'DB:business_master_new
loadtime:0.47660088539124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:0.47663497924805 / seconds
Query Executed:select id FROM `va` where city='Lawrenceville' && SIC_code='5261'DB:business_master_new
loadtime:0.47746300697327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.47751879692078 / seconds
Query Executed:select id FROM `va` where city='Lebanon' && SIC_code='5261'DB:business_master_new
loadtime:0.47840189933777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon Church' limit 1
loadtime:0.47843599319458 / seconds
Query Executed:select id FROM `va` where city='Lebanon Church' && SIC_code='5261'DB:business_master_new
loadtime:0.47866797447205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:0.47871780395508 / seconds
Query Executed:select id FROM `va` where city='Leesburg' && SIC_code='5261'DB:business_master_new
loadtime:0.4870069026947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:0.48706388473511 / seconds
Query Executed:select id FROM `va` where city='Leon' && SIC_code='5261'DB:business_master_new
loadtime:0.48745393753052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.48749780654907 / seconds
Query Executed:select id FROM `va` where city='Lexington' && SIC_code='5261'DB:business_master_new
loadtime:0.48866987228394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lightfoot' limit 1
loadtime:0.48873996734619 / seconds
Query Executed:select id FROM `va` where city='Lightfoot' && SIC_code='5261'DB:business_master_new
loadtime:0.48951387405396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lignum' limit 1
loadtime:0.48955082893372 / seconds
Query Executed:select id FROM `va` where city='Lignum' && SIC_code='5261'DB:business_master_new
loadtime:0.49005579948425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.49011278152466 / seconds
Query Executed:select id FROM `va` where city='Lincoln' && SIC_code='5261'DB:business_master_new
loadtime:0.49057579040527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:0.49062180519104 / seconds
Query Executed:select id FROM `va` where city='Linden' && SIC_code='5261'DB:business_master_new
loadtime:0.49134397506714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:0.49147200584412 / seconds
Query Executed:select id FROM `va` where city='Linville' && SIC_code='5261'DB:business_master_new
loadtime:0.49237680435181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Plymouth' limit 1
loadtime:0.4924738407135 / seconds
Query Executed:select id FROM `va` where city='Little Plymouth' && SIC_code='5261'DB:business_master_new
loadtime:0.4929039478302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lively' limit 1
loadtime:0.49294281005859 / seconds
Query Executed:select id FROM `va` where city='Lively' && SIC_code='5261'DB:business_master_new
loadtime:0.49361681938171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Dale' limit 1
loadtime:0.49365282058716 / seconds
Query Executed:select id FROM `va` where city='Locust Dale' && SIC_code='5261'DB:business_master_new
loadtime:0.49403882026672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Grove' limit 1
loadtime:0.4940869808197 / seconds
Query Executed:select id FROM `va` where city='Locust Grove' && SIC_code='5261'DB:business_master_new
loadtime:0.4948468208313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Hill' limit 1
loadtime:0.49488186836243 / seconds
Query Executed:select id FROM `va` where city='Locust Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.49544787406921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locustville' limit 1
loadtime:0.49550294876099 / seconds
Query Executed:select id FROM `va` where city='Locustville' && SIC_code='5261'DB:business_master_new
loadtime:0.49586296081543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:0.49590682983398 / seconds
Query Executed:select id FROM `va` where city='Long Island' && SIC_code='5261'DB:business_master_new
loadtime:0.49647092819214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:0.49659085273743 / seconds
Query Executed:select id FROM `va` where city='Loretto' && SIC_code='5261'DB:business_master_new
loadtime:0.49699187278748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorton' limit 1
loadtime:0.49702787399292 / seconds
Query Executed:select id FROM `va` where city='Lorton' && SIC_code='5261'DB:business_master_new
loadtime:0.49829292297363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lottsburg' limit 1
loadtime:0.49844598770142 / seconds
Query Executed:select id FROM `va` where city='Lottsburg' && SIC_code='5261'DB:business_master_new
loadtime:0.49955892562866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisa' limit 1
loadtime:0.49959492683411 / seconds
Query Executed:select id FROM `va` where city='Louisa' && SIC_code='5261'DB:business_master_new
loadtime:0.50053000450134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovettsville' limit 1
loadtime:0.50068497657776 / seconds
Query Executed:select id FROM `va` where city='Lovettsville' && SIC_code='5261'DB:business_master_new
loadtime:0.50155878067017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovingston' limit 1
loadtime:0.50167989730835 / seconds
Query Executed:select id FROM `va` where city='Lovingston' && SIC_code='5261'DB:business_master_new
loadtime:0.50245881080627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:0.5025908946991 / seconds
Query Executed:select id FROM `va` where city='Low Moor' && SIC_code='5261'DB:business_master_new
loadtime:0.50336790084839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowesville' limit 1
loadtime:0.50340294837952 / seconds
Query Executed:select id FROM `va` where city='Lowesville' && SIC_code='5261'DB:business_master_new
loadtime:0.50366878509521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowmoor' limit 1
loadtime:0.50371885299683 / seconds
Query Executed:select id FROM `va` where city='Lowmoor' && SIC_code='5261'DB:business_master_new
loadtime:0.50396084785461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.50399589538574 / seconds
Query Executed:select id FROM `va` where city='Lowry' && SIC_code='5261'DB:business_master_new
loadtime:0.50430083274841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:0.50434684753418 / seconds
Query Executed:select id FROM `va` where city='Lunenburg' && SIC_code='5261'DB:business_master_new
loadtime:0.50488090515137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:0.50492787361145 / seconds
Query Executed:select id FROM `va` where city='Luray' && SIC_code='5261'DB:business_master_new
loadtime:0.50591897964478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynch Station' limit 1
loadtime:0.50596499443054 / seconds
Query Executed:select id FROM `va` where city='Lynch Station' && SIC_code='5261'DB:business_master_new
loadtime:0.50676584243774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:0.50682091712952 / seconds
Query Executed:select id FROM `va` where city='Lynchburg' && SIC_code='5261'DB:business_master_new
loadtime:0.51501488685608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:0.51507997512817 / seconds
Query Executed:select id FROM `va` where city='Lyndhurst' && SIC_code='5261'DB:business_master_new
loadtime:0.51601886749268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Machipongo' limit 1
loadtime:0.51606678962708 / seconds
Query Executed:select id FROM `va` where city='Machipongo' && SIC_code='5261'DB:business_master_new
loadtime:0.51667881011963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:0.5167498588562 / seconds
Query Executed:select id FROM `va` where city='Macon' && SIC_code='5261'DB:business_master_new
loadtime:0.51709699630737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.51713180541992 / seconds
Query Executed:select id FROM `va` where city='Madison' && SIC_code='5261'DB:business_master_new
loadtime:0.51791286468506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:0.51803183555603 / seconds
Query Executed:select id FROM `va` where city='Madison Heights' && SIC_code='5261'DB:business_master_new
loadtime:0.51908588409424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Mills' limit 1
loadtime:0.51923680305481 / seconds
Query Executed:select id FROM `va` where city='Madison Mills' && SIC_code='5261'DB:business_master_new
loadtime:0.51962900161743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidens' limit 1
loadtime:0.51965689659119 / seconds
Query Executed:select id FROM `va` where city='Maidens' && SIC_code='5261'DB:business_master_new
loadtime:0.52066898345947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manakin Sabot' limit 1
loadtime:0.52073693275452 / seconds
Query Executed:select id FROM `va` where city='Manakin Sabot' && SIC_code='5261'DB:business_master_new
loadtime:0.52152490615845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas' limit 1
loadtime:0.5215699672699 / seconds
Query Executed:select id FROM `va` where city='Manassas' && SIC_code='5261'DB:business_master_new
loadtime:0.52977085113525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas Park' limit 1
loadtime:0.52983093261719 / seconds
Query Executed:select id FROM `va` where city='Manassas Park' && SIC_code='5261'DB:business_master_new
loadtime:0.53016901016235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mangohick' limit 1
loadtime:0.53026485443115 / seconds
Query Executed:select id FROM `va` where city='Mangohick' && SIC_code='5261'DB:business_master_new
loadtime:0.53058791160583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannboro' limit 1
loadtime:0.53061580657959 / seconds
Query Executed:select id FROM `va` where city='Mannboro' && SIC_code='5261'DB:business_master_new
loadtime:0.53090286254883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manquin' limit 1
loadtime:0.53093886375427 / seconds
Query Executed:select id FROM `va` where city='Manquin' && SIC_code='5261'DB:business_master_new
loadtime:0.53164386749268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mappsville' limit 1
loadtime:0.53168678283691 / seconds
Query Executed:select id FROM `va` where city='Mappsville' && SIC_code='5261'DB:business_master_new
loadtime:0.5321888923645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.53232288360596 / seconds
Query Executed:select id FROM `va` where city='Marion' && SIC_code='5261'DB:business_master_new
loadtime:0.5334198474884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marionville' limit 1
loadtime:0.53347587585449 / seconds
Query Executed:select id FROM `va` where city='Marionville' && SIC_code='5261'DB:business_master_new
loadtime:0.53378295898438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markham' limit 1
loadtime:0.53382778167725 / seconds
Query Executed:select id FROM `va` where city='Markham' && SIC_code='5261'DB:business_master_new
loadtime:0.53431487083435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:0.53436493873596 / seconds
Query Executed:select id FROM `va` where city='Marshall' && SIC_code='5261'DB:business_master_new
loadtime:0.53525996208191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:0.53541779518127 / seconds
Query Executed:select id FROM `va` where city='Martinsville' && SIC_code='5261'DB:business_master_new
loadtime:0.53708481788635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maryus' limit 1
loadtime:0.53713178634644 / seconds
Query Executed:select id FROM `va` where city='Maryus' && SIC_code='5261'DB:business_master_new
loadtime:0.53744792938232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mascot' limit 1
loadtime:0.53749799728394 / seconds
Query Executed:select id FROM `va` where city='Mascot' && SIC_code='5261'DB:business_master_new
loadtime:0.53777480125427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massies Mill' limit 1
loadtime:0.53781199455261 / seconds
Query Executed:select id FROM `va` where city='Massies Mill' && SIC_code='5261'DB:business_master_new
loadtime:0.53806400299072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:0.53809595108032 / seconds
Query Executed:select id FROM `va` where city='Mathews' && SIC_code='5261'DB:business_master_new
loadtime:0.5388457775116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattaponi' limit 1
loadtime:0.53888082504272 / seconds
Query Executed:select id FROM `va` where city='Mattaponi' && SIC_code='5261'DB:business_master_new
loadtime:0.53949189186096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurertown' limit 1
loadtime:0.53954792022705 / seconds
Query Executed:select id FROM `va` where city='Maurertown' && SIC_code='5261'DB:business_master_new
loadtime:0.54059600830078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mavisdale' limit 1
loadtime:0.54063296318054 / seconds
Query Executed:select id FROM `va` where city='Mavisdale' && SIC_code='5261'DB:business_master_new
loadtime:0.54098391532898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Max Meadows' limit 1
loadtime:0.54103088378906 / seconds
Query Executed:select id FROM `va` where city='Max Meadows' && SIC_code='5261'DB:business_master_new
loadtime:0.54175877571106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxie' limit 1
loadtime:0.5417947769165 / seconds
Query Executed:select id FROM `va` where city='Maxie' && SIC_code='5261'DB:business_master_new
loadtime:0.54219579696655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clure' limit 1
loadtime:0.54224395751953 / seconds
Query Executed:select id FROM `va` where city='Mc Clure' && SIC_code='5261'DB:business_master_new
loadtime:0.54270195960999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:0.54273080825806 / seconds
Query Executed:select id FROM `va` where city='Mc Coy' && SIC_code='5261'DB:business_master_new
loadtime:0.54311180114746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Dowell' limit 1
loadtime:0.54324197769165 / seconds
Query Executed:select id FROM `va` where city='Mc Dowell' && SIC_code='5261'DB:business_master_new
loadtime:0.54390001296997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gaheysville' limit 1
loadtime:0.54393887519836 / seconds
Query Executed:select id FROM `va` where city='Mc Gaheysville' && SIC_code='5261'DB:business_master_new
loadtime:0.54461884498596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenney' limit 1
loadtime:0.54465484619141 / seconds
Query Executed:select id FROM `va` where city='Mc Kenney' && SIC_code='5261'DB:business_master_new
loadtime:0.54575800895691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lean' limit 1
loadtime:0.5458128452301 / seconds
Query Executed:select id FROM `va` where city='Mc Lean' && SIC_code='5261'DB:business_master_new
loadtime:0.5540030002594 / seconds
Query Executed:select * from geodata_geocity where city='Mckenney' limit 1DB:business_master_new
loadtime:0.55429577827454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mclean' limit 1
loadtime:0.55432796478271 / seconds
Query Executed:select id FROM `va` where city='Mclean' && SIC_code='5261'DB:business_master_new
loadtime:0.55497884750366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows Of Dan' limit 1
loadtime:0.55502700805664 / seconds
Query Executed:select id FROM `va` where city='Meadows Of Dan' && SIC_code='5261'DB:business_master_new
loadtime:0.55615282058716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowview' limit 1
loadtime:0.55624890327454 / seconds
Query Executed:select id FROM `va` where city='Meadowview' && SIC_code='5261'DB:business_master_new
loadtime:0.55706286430359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:0.55711698532104 / seconds
Query Executed:select id FROM `va` where city='Mears' && SIC_code='5261'DB:business_master_new
loadtime:0.55748295783997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:0.55751800537109 / seconds
Query Executed:select id FROM `va` where city='Mechanicsville' && SIC_code='5261'DB:business_master_new
loadtime:0.55925393104553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meherrin' limit 1
loadtime:0.55931496620178 / seconds
Query Executed:select id FROM `va` where city='Meherrin' && SIC_code='5261'DB:business_master_new
loadtime:0.55999493598938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melfa' limit 1
loadtime:0.56004285812378 / seconds
Query Executed:select id FROM `va` where city='Melfa' && SIC_code='5261'DB:business_master_new
loadtime:0.56073188781738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendota' limit 1
loadtime:0.56078791618347 / seconds
Query Executed:select id FROM `va` where city='Mendota' && SIC_code='5261'DB:business_master_new
loadtime:0.56120800971985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredithville' limit 1
loadtime:0.56125283241272 / seconds
Query Executed:select id FROM `va` where city='Meredithville' && SIC_code='5261'DB:business_master_new
loadtime:0.56149482727051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrifield' limit 1
loadtime:0.56152296066284 / seconds
Query Executed:select id FROM `va` where city='Merrifield' && SIC_code='5261'DB:business_master_new
loadtime:0.56221389770508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Point' limit 1
loadtime:0.56233191490173 / seconds
Query Executed:select id FROM `va` where city='Merry Point' && SIC_code='5261'DB:business_master_new
loadtime:0.56270098686218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebrook' limit 1
loadtime:0.5627269744873 / seconds
Query Executed:select id FROM `va` where city='Middlebrook' && SIC_code='5261'DB:business_master_new
loadtime:0.56334686279297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:0.56339478492737 / seconds
Query Executed:select id FROM `va` where city='Middleburg' && SIC_code='5261'DB:business_master_new
loadtime:0.5643138885498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.56446695327759 / seconds
Query Executed:select id FROM `va` where city='Middletown' && SIC_code='5261'DB:business_master_new
loadtime:0.56524801254272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.56533789634705 / seconds
Query Executed:select id FROM `va` where city='Midland' && SIC_code='5261'DB:business_master_new
loadtime:0.56608486175537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midlothian' limit 1
loadtime:0.56613183021545 / seconds
Query Executed:select id FROM `va` where city='Midlothian' && SIC_code='5261'DB:business_master_new
loadtime:0.57440280914307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.57457089424133 / seconds
Query Executed:select id FROM `va` where city='Milford' && SIC_code='5261'DB:business_master_new
loadtime:0.5753870010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millboro' limit 1
loadtime:0.57552599906921 / seconds
Query Executed:select id FROM `va` where city='Millboro' && SIC_code='5261'DB:business_master_new
loadtime:0.57625198364258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Tavern' limit 1
loadtime:0.57628989219666 / seconds
Query Executed:select id FROM `va` where city='Millers Tavern' && SIC_code='5261'DB:business_master_new
loadtime:0.5767719745636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:0.57681179046631 / seconds
Query Executed:select id FROM `va` where city='Millwood' && SIC_code='5261'DB:business_master_new
loadtime:0.57744288444519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Run' limit 1
loadtime:0.57755899429321 / seconds
Query Executed:select id FROM `va` where city='Mine Run' && SIC_code='5261'DB:business_master_new
loadtime:0.57790899276733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:0.57794880867004 / seconds
Query Executed:select id FROM `va` where city='Mineral' && SIC_code='5261'DB:business_master_new
loadtime:0.57872700691223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Spring' limit 1
loadtime:0.57878398895264 / seconds
Query Executed:select id FROM `va` where city='Mint Spring' && SIC_code='5261'DB:business_master_new
loadtime:0.57923293113708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchells' limit 1
loadtime:0.57933497428894 / seconds
Query Executed:select id FROM `va` where city='Mitchells' && SIC_code='5261'DB:business_master_new
loadtime:0.57983779907227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modest Town' limit 1
loadtime:0.57988595962524 / seconds
Query Executed:select id FROM `va` where city='Modest Town' && SIC_code='5261'DB:business_master_new
loadtime:0.5802218914032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mollusk' limit 1
loadtime:0.58033990859985 / seconds
Query Executed:select id FROM `va` where city='Mollusk' && SIC_code='5261'DB:business_master_new
loadtime:0.58075380325317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moneta' limit 1
loadtime:0.58078193664551 / seconds
Query Executed:select id FROM `va` where city='Moneta' && SIC_code='5261'DB:business_master_new
loadtime:0.58167386054993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.58174896240234 / seconds
Query Executed:select id FROM `va` where city='Monroe' && SIC_code='5261'DB:business_master_new
loadtime:0.58246397972107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montebello' limit 1
loadtime:0.58251786231995 / seconds
Query Executed:select id FROM `va` where city='Montebello' && SIC_code='5261'DB:business_master_new
loadtime:0.58288788795471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:0.58292579650879 / seconds
Query Executed:select id FROM `va` where city='Monterey' && SIC_code='5261'DB:business_master_new
loadtime:0.58361577987671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.58366894721985 / seconds
Query Executed:select id FROM `va` where city='Montpelier' && SIC_code='5261'DB:business_master_new
loadtime:0.58442687988281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Sta' limit 1
loadtime:0.58448195457458 / seconds
Query Executed:select id FROM `va` where city='Montpelier Sta' && SIC_code='5261'DB:business_master_new
loadtime:0.58476090431213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Station' limit 1
loadtime:0.58478879928589 / seconds
Query Executed:select id FROM `va` where city='Montpelier Station' && SIC_code='5261'DB:business_master_new
loadtime:0.58512687683105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montross' limit 1
loadtime:0.58517479896545 / seconds
Query Executed:select id FROM `va` where city='Montross' && SIC_code='5261'DB:business_master_new
loadtime:0.58593082427979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:0.58597898483276 / seconds
Query Executed:select id FROM `va` where city='Montvale' && SIC_code='5261'DB:business_master_new
loadtime:0.58662486076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moon' limit 1
loadtime:0.58666086196899 / seconds
Query Executed:select id FROM `va` where city='Moon' && SIC_code='5261'DB:business_master_new
loadtime:0.58704996109009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morattico' limit 1
loadtime:0.58709788322449 / seconds
Query Executed:select id FROM `va` where city='Morattico' && SIC_code='5261'DB:business_master_new
loadtime:0.58744692802429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:0.58757591247559 / seconds
Query Executed:select id FROM `va` where city='Morrisville' && SIC_code='5261'DB:business_master_new
loadtime:0.58784079551697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moseley' limit 1
loadtime:0.58786797523499 / seconds
Query Executed:select id FROM `va` where city='Moseley' && SIC_code='5261'DB:business_master_new
loadtime:0.58855986595154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Crawford' limit 1
loadtime:0.58861589431763 / seconds
Query Executed:select id FROM `va` where city='Mount Crawford' && SIC_code='5261'DB:business_master_new
loadtime:0.58934378623962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:0.58947992324829 / seconds
Query Executed:select id FROM `va` where city='Mount Holly' && SIC_code='5261'DB:business_master_new
loadtime:0.59001588821411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Jackson' limit 1
loadtime:0.59006285667419 / seconds
Query Executed:select id FROM `va` where city='Mount Jackson' && SIC_code='5261'DB:business_master_new
loadtime:0.59078979492188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sidney' limit 1
loadtime:0.59081888198853 / seconds
Query Executed:select id FROM `va` where city='Mount Sidney' && SIC_code='5261'DB:business_master_new
loadtime:0.59144687652588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Solon' limit 1
loadtime:0.59150290489197 / seconds
Query Executed:select id FROM `va` where city='Mount Solon' && SIC_code='5261'DB:business_master_new
loadtime:0.59218382835388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.59223198890686 / seconds
Query Executed:select id FROM `va` where city='Mount Vernon' && SIC_code='5261'DB:business_master_new
loadtime:0.59285688400269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mouth Of Wilson' limit 1
loadtime:0.59288597106934 / seconds
Query Executed:select id FROM `va` where city='Mouth Of Wilson' && SIC_code='5261'DB:business_master_new
loadtime:0.59362888336182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Crawford' limit 1
loadtime:0.59368586540222 / seconds
Query Executed:select id FROM `va` where city='Mt Crawford' && SIC_code='5261'DB:business_master_new
loadtime:0.59406995773315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:0.59411787986755 / seconds
Query Executed:select id FROM `va` where city='Mt Holly' && SIC_code='5261'DB:business_master_new
loadtime:0.59437990188599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Jackson' limit 1
loadtime:0.59440779685974 / seconds
Query Executed:select id FROM `va` where city='Mt Jackson' && SIC_code='5261'DB:business_master_new
loadtime:0.59475994110107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sidney' limit 1
loadtime:0.5947949886322 / seconds
Query Executed:select id FROM `va` where city='Mt Sidney' && SIC_code='5261'DB:business_master_new
loadtime:0.59510684013367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Solon' limit 1
loadtime:0.59514284133911 / seconds
Query Executed:select id FROM `va` where city='Mt Solon' && SIC_code='5261'DB:business_master_new
loadtime:0.59541583061218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.59544992446899 / seconds
Query Executed:select id FROM `va` where city='Mt Vernon' && SIC_code='5261'DB:business_master_new
loadtime:0.59573578834534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mustoe' limit 1
loadtime:0.59577178955078 / seconds
Query Executed:select id FROM `va` where city='Mustoe' && SIC_code='5261'DB:business_master_new
loadtime:0.59607887268066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narrows' limit 1
loadtime:0.5961217880249 / seconds
Query Executed:select id FROM `va` where city='Narrows' && SIC_code='5261'DB:business_master_new
loadtime:0.59683394432068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naruna' limit 1
loadtime:0.59686994552612 / seconds
Query Executed:select id FROM `va` where city='Naruna' && SIC_code='5261'DB:business_master_new
loadtime:0.59730100631714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nassawadox' limit 1
loadtime:0.59735488891602 / seconds
Query Executed:select id FROM `va` where city='Nassawadox' && SIC_code='5261'DB:business_master_new
loadtime:0.59805083274841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathalie' limit 1
loadtime:0.59809398651123 / seconds
Query Executed:select id FROM `va` where city='Nathalie' && SIC_code='5261'DB:business_master_new
loadtime:0.59877896308899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Brdg Sta' limit 1
loadtime:0.5988187789917 / seconds
Query Executed:select id FROM `va` where city='Natural Brdg Sta' && SIC_code='5261'DB:business_master_new
loadtime:0.59916281700134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge' limit 1
loadtime:0.59925889968872 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge' && SIC_code='5261'DB:business_master_new
loadtime:0.59999895095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge Station' limit 1
loadtime:0.60008382797241 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge Station' && SIC_code='5261'DB:business_master_new
loadtime:0.60084295272827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naval Base' limit 1
loadtime:0.60087084770203 / seconds
Query Executed:select id FROM `va` where city='Naval Base' && SIC_code='5261'DB:business_master_new
loadtime:0.60132884979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellysford' limit 1
loadtime:0.60137581825256 / seconds
Query Executed:select id FROM `va` where city='Nellysford' && SIC_code='5261'DB:business_master_new
loadtime:0.60213398933411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:0.60228300094604 / seconds
Query Executed:select id FROM `va` where city='Nelson' && SIC_code='5261'DB:business_master_new
loadtime:0.60280084609985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonia' limit 1
loadtime:0.60283780097961 / seconds
Query Executed:select id FROM `va` where city='Nelsonia' && SIC_code='5261'DB:business_master_new
loadtime:0.60325598716736 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canton' limit 1
loadtime:0.60330200195312 / seconds
Query Executed:select id FROM `va` where city='New Canton' && SIC_code='5261'DB:business_master_new
loadtime:0.6041259765625 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.60425400733948 / seconds
Query Executed:select id FROM `va` where city='New Castle' && SIC_code='5261'DB:business_master_new
loadtime:0.60505795478821 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Church' limit 1
loadtime:0.60509395599365 / seconds
Query Executed:select id FROM `va` where city='New Church' && SIC_code='5261'DB:business_master_new
loadtime:0.60578894615173 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:0.60584378242493 / seconds
Query Executed:select id FROM `va` where city='New Hope' && SIC_code='5261'DB:business_master_new
loadtime:0.60632681846619 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Kent' limit 1
loadtime:0.6064248085022 / seconds
Query Executed:select id FROM `va` where city='New Kent' && SIC_code='5261'DB:business_master_new
loadtime:0.60722279548645 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:0.6073579788208 / seconds
Query Executed:select id FROM `va` where city='New Market' && SIC_code='5261'DB:business_master_new
loadtime:0.60825395584106 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Point' limit 1
loadtime:0.60840392112732 / seconds
Query Executed:select id FROM `va` where city='New Point' && SIC_code='5261'DB:business_master_new
loadtime:0.60883188247681 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:0.60886979103088 / seconds
Query Executed:select id FROM `va` where city='New River' && SIC_code='5261'DB:business_master_new
loadtime:0.60920596122742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:0.60924887657166 / seconds
Query Executed:select id FROM `va` where city='Newbern' && SIC_code='5261'DB:business_master_new
loadtime:0.60972189903259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.60974884033203 / seconds
Query Executed:select id FROM `va` where city='Newington' && SIC_code='5261'DB:business_master_new
loadtime:0.61040496826172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.6104519367218 / seconds
Query Executed:select id FROM `va` where city='Newport' && SIC_code='5261'DB:business_master_new
loadtime:0.61133599281311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport News' limit 1
loadtime:0.61146378517151 / seconds
Query Executed:select id FROM `va` where city='Newport News' && SIC_code='5261'DB:business_master_new
loadtime:0.61973881721497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newsoms' limit 1
loadtime:0.61980080604553 / seconds
Query Executed:select id FROM `va` where city='Newsoms' && SIC_code='5261'DB:business_master_new
loadtime:0.62050294876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.62055397033691 / seconds
Query Executed:select id FROM `va` where city='Newtown' && SIC_code='5261'DB:business_master_new
loadtime:0.62099289894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickelsville' limit 1
loadtime:0.62102890014648 / seconds
Query Executed:select id FROM `va` where city='Nickelsville' && SIC_code='5261'DB:business_master_new
loadtime:0.62191891670227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninde' limit 1
loadtime:0.62196683883667 / seconds
Query Executed:select id FROM `va` where city='Ninde' && SIC_code='5261'DB:business_master_new
loadtime:0.62233281135559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nokesville' limit 1
loadtime:0.62242984771729 / seconds
Query Executed:select id FROM `va` where city='Nokesville' && SIC_code='5261'DB:business_master_new
loadtime:0.62336087226868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora' limit 1
loadtime:0.62351489067078 / seconds
Query Executed:select id FROM `va` where city='Nora' && SIC_code='5261'DB:business_master_new
loadtime:0.62392997741699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.62395882606506 / seconds
Query Executed:select id FROM `va` where city='Norfolk' && SIC_code='5261'DB:business_master_new
loadtime:0.63214182853699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norge' limit 1
loadtime:0.63220596313477 / seconds
Query Executed:select id FROM `va` where city='Norge' && SIC_code='5261'DB:business_master_new
loadtime:0.63270497322083 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:0.63274383544922 / seconds
Query Executed:select id FROM `va` where city='North' && SIC_code='5261'DB:business_master_new
loadtime:0.63329291343689 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Garden' limit 1
loadtime:0.63333988189697 / seconds
Query Executed:select id FROM `va` where city='North Garden' && SIC_code='5261'DB:business_master_new
loadtime:0.63435983657837 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Tazewell' limit 1
loadtime:0.63441395759583 / seconds
Query Executed:select id FROM `va` where city='North Tazewell' && SIC_code='5261'DB:business_master_new
loadtime:0.63522887229919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:0.63538694381714 / seconds
Query Executed:select id FROM `va` where city='Norton' && SIC_code='5261'DB:business_master_new
loadtime:0.63636994361877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:0.63650679588318 / seconds
Query Executed:select id FROM `va` where city='Norwood' && SIC_code='5261'DB:business_master_new
loadtime:0.63688492774963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottoway' limit 1
loadtime:0.63691186904907 / seconds
Query Executed:select id FROM `va` where city='Nottoway' && SIC_code='5261'DB:business_master_new
loadtime:0.63744783401489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nuttsville' limit 1
loadtime:0.63753581047058 / seconds
Query Executed:select id FROM `va` where city='Nuttsville' && SIC_code='5261'DB:business_master_new
loadtime:0.63782787322998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hall' limit 1
loadtime:0.63785600662231 / seconds
Query Executed:select id FROM `va` where city='Oak Hall' && SIC_code='5261'DB:business_master_new
loadtime:0.63863897323608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakpark' limit 1
loadtime:0.63868594169617 / seconds
Query Executed:select id FROM `va` where city='Oakpark' && SIC_code='5261'DB:business_master_new
loadtime:0.63901281356812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakton' limit 1
loadtime:0.63905000686646 / seconds
Query Executed:select id FROM `va` where city='Oakton' && SIC_code='5261'DB:business_master_new
loadtime:0.64000582695007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakwood' limit 1
loadtime:0.64006280899048 / seconds
Query Executed:select id FROM `va` where city='Oakwood' && SIC_code='5261'DB:business_master_new
loadtime:0.64073395729065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Occoquan' limit 1
loadtime:0.64078998565674 / seconds
Query Executed:select id FROM `va` where city='Occoquan' && SIC_code='5261'DB:business_master_new
loadtime:0.64147877693176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oilville' limit 1
loadtime:0.64151477813721 / seconds
Query Executed:select id FROM `va` where city='Oilville' && SIC_code='5261'DB:business_master_new
loadtime:0.64217185974121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldhams' limit 1
loadtime:0.64221787452698 / seconds
Query Executed:select id FROM `va` where city='Oldhams' && SIC_code='5261'DB:business_master_new
loadtime:0.64256286621094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onancock' limit 1
loadtime:0.64259791374207 / seconds
Query Executed:select id FROM `va` where city='Onancock' && SIC_code='5261'DB:business_master_new
loadtime:0.64341592788696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onemo' limit 1
loadtime:0.64353585243225 / seconds
Query Executed:select id FROM `va` where city='Onemo' && SIC_code='5261'DB:business_master_new
loadtime:0.64389181137085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onley' limit 1
loadtime:0.64393186569214 / seconds
Query Executed:select id FROM `va` where city='Onley' && SIC_code='5261'DB:business_master_new
loadtime:0.64467096328735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophelia' limit 1
loadtime:0.64478278160095 / seconds
Query Executed:select id FROM `va` where city='Ophelia' && SIC_code='5261'DB:business_master_new
loadtime:0.64513397216797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.64518189430237 / seconds
Query Executed:select id FROM `va` where city='Orange' && SIC_code='5261'DB:business_master_new
loadtime:0.64612483978271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordinary' limit 1
loadtime:0.64620685577393 / seconds
Query Executed:select id FROM `va` where city='Ordinary' && SIC_code='5261'DB:business_master_new
loadtime:0.64678883552551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriskany' limit 1
loadtime:0.64682078361511 / seconds
Query Executed:select id FROM `va` where city='Oriskany' && SIC_code='5261'DB:business_master_new
loadtime:0.64716577529907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orkney Springs' limit 1
loadtime:0.64729499816895 / seconds
Query Executed:select id FROM `va` where city='Orkney Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.64769887924194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlean' limit 1
loadtime:0.64772891998291 / seconds
Query Executed:select id FROM `va` where city='Orlean' && SIC_code='5261'DB:business_master_new
loadtime:0.64821696281433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyster' limit 1
loadtime:0.64836883544922 / seconds
Query Executed:select id FROM `va` where city='Oyster' && SIC_code='5261'DB:business_master_new
loadtime:0.64873099327087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paeonian Springs' limit 1
loadtime:0.64876890182495 / seconds
Query Executed:select id FROM `va` where city='Paeonian Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.64945483207703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Bank' limit 1
loadtime:0.64949798583984 / seconds
Query Executed:select id FROM `va` where city='Paint Bank' && SIC_code='5261'DB:business_master_new
loadtime:0.64982485771179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painter' limit 1
loadtime:0.64986491203308 / seconds
Query Executed:select id FROM `va` where city='Painter' && SIC_code='5261'DB:business_master_new
loadtime:0.65049290657043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:0.65053677558899 / seconds
Query Executed:select id FROM `va` where city='Palmyra' && SIC_code='5261'DB:business_master_new
loadtime:0.65141081809998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplin' limit 1
loadtime:0.65145492553711 / seconds
Query Executed:select id FROM `va` where city='Pamplin' && SIC_code='5261'DB:business_master_new
loadtime:0.65236878395081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:0.65251898765564 / seconds
Query Executed:select id FROM `va` where city='Paris' && SIC_code='5261'DB:business_master_new
loadtime:0.65312790870667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksley' limit 1
loadtime:0.65318298339844 / seconds
Query Executed:select id FROM `va` where city='Parksley' && SIC_code='5261'DB:business_master_new
loadtime:0.65386891365051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrott' limit 1
loadtime:0.65389800071716 / seconds
Query Executed:select id FROM `va` where city='Parrott' && SIC_code='5261'DB:business_master_new
loadtime:0.65423083305359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partlow' limit 1
loadtime:0.65435886383057 / seconds
Query Executed:select id FROM `va` where city='Partlow' && SIC_code='5261'DB:business_master_new
loadtime:0.65523481369019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick Springs' limit 1
loadtime:0.65536284446716 / seconds
Query Executed:select id FROM `va` where city='Patrick Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.65610694885254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:0.65615391731262 / seconds
Query Executed:select id FROM `va` where city='Patterson' && SIC_code='5261'DB:business_master_new
loadtime:0.6564519405365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearisburg' limit 1
loadtime:0.65647888183594 / seconds
Query Executed:select id FROM `va` where city='Pearisburg' && SIC_code='5261'DB:business_master_new
loadtime:0.65732192993164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:0.6574718952179 / seconds
Query Executed:select id FROM `va` where city='Pembroke' && SIC_code='5261'DB:business_master_new
loadtime:0.65827393531799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penhook' limit 1
loadtime:0.65837597846985 / seconds
Query Executed:select id FROM `va` where city='Penhook' && SIC_code='5261'DB:business_master_new
loadtime:0.65914583206177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penn Laird' limit 1
loadtime:0.65920186042786 / seconds
Query Executed:select id FROM `va` where city='Penn Laird' && SIC_code='5261'DB:business_master_new
loadtime:0.66010499000549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington Gap' limit 1
loadtime:0.66014790534973 / seconds
Query Executed:select id FROM `va` where city='Pennington Gap' && SIC_code='5261'DB:business_master_new
loadtime:0.6609058380127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:0.66094899177551 / seconds
Query Executed:select id FROM `va` where city='Petersburg' && SIC_code='5261'DB:business_master_new
loadtime:0.6626148223877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix' limit 1
loadtime:0.662672996521 / seconds
Query Executed:select id FROM `va` where city='Phenix' && SIC_code='5261'DB:business_master_new
loadtime:0.66324496269226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomont' limit 1
loadtime:0.66328096389771 / seconds
Query Executed:select id FROM `va` where city='Philomont' && SIC_code='5261'DB:business_master_new
loadtime:0.6637179851532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilgrims Knob' limit 1
loadtime:0.66375780105591 / seconds
Query Executed:select id FROM `va` where city='Pilgrims Knob' && SIC_code='5261'DB:business_master_new
loadtime:0.6640989780426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot' limit 1
loadtime:0.66414189338684 / seconds
Query Executed:select id FROM `va` where city='Pilot' && SIC_code='5261'DB:business_master_new
loadtime:0.66473293304443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney River' limit 1
loadtime:0.66477489471436 / seconds
Query Executed:select id FROM `va` where city='Piney River' && SIC_code='5261'DB:business_master_new
loadtime:0.66534090042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:0.66539597511292 / seconds
Query Executed:select id FROM `va` where city='Pittsville' && SIC_code='5261'DB:business_master_new
loadtime:0.66579580307007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain View' limit 1
loadtime:0.66583395004272 / seconds
Query Executed:select id FROM `va` where city='Plain View' && SIC_code='5261'DB:business_master_new
loadtime:0.66609001159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.66612195968628 / seconds
Query Executed:select id FROM `va` where city='Pleasant Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.66641592979431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:0.66644597053528 / seconds
Query Executed:select id FROM `va` where city='Pocahontas' && SIC_code='5261'DB:business_master_new
loadtime:0.66704797744751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquoson' limit 1
loadtime:0.66714382171631 / seconds
Query Executed:select id FROM `va` where city='Poquoson' && SIC_code='5261'DB:business_master_new
loadtime:0.66810083389282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Haywood' limit 1
loadtime:0.66815590858459 / seconds
Query Executed:select id FROM `va` where city='Port Haywood' && SIC_code='5261'DB:business_master_new
loadtime:0.66864800453186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:0.66868901252747 / seconds
Query Executed:select id FROM `va` where city='Port Republic' && SIC_code='5261'DB:business_master_new
loadtime:0.66948080062866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:0.66953492164612 / seconds
Query Executed:select id FROM `va` where city='Port Royal' && SIC_code='5261'DB:business_master_new
loadtime:0.67028284072876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.67037987709045 / seconds
Query Executed:select id FROM `va` where city='Portsmouth' && SIC_code='5261'DB:business_master_new
loadtime:0.67861485481262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:0.67867398262024 / seconds
Query Executed:select id FROM `va` where city='Pound' && SIC_code='5261'DB:business_master_new
loadtime:0.67990279197693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pounding Mill' limit 1
loadtime:0.67995285987854 / seconds
Query Executed:select id FROM `va` where city='Pounding Mill' && SIC_code='5261'DB:business_master_new
loadtime:0.68094491958618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:0.68097281455994 / seconds
Query Executed:select id FROM `va` where city='Powhatan' && SIC_code='5261'DB:business_master_new
loadtime:0.68260478973389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratts' limit 1
loadtime:0.68266487121582 / seconds
Query Executed:select id FROM `va` where city='Pratts' && SIC_code='5261'DB:business_master_new
loadtime:0.68305587768555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince George' limit 1
loadtime:0.68310499191284 / seconds
Query Executed:select id FROM `va` where city='Prince George' && SIC_code='5261'DB:business_master_new
loadtime:0.68442392349243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.68448090553284 / seconds
Query Executed:select id FROM `va` where city='Prospect' && SIC_code='5261'DB:business_master_new
loadtime:0.68616390228271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence Forge' limit 1
loadtime:0.68619990348816 / seconds
Query Executed:select id FROM `va` where city='Providence Forge' && SIC_code='5261'DB:business_master_new
loadtime:0.68736290931702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:0.68741679191589 / seconds
Query Executed:select id FROM `va` where city='Pulaski' && SIC_code='5261'DB:business_master_new
loadtime:0.6894998550415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pungoteague' limit 1
loadtime:0.6895649433136 / seconds
Query Executed:select id FROM `va` where city='Pungoteague' && SIC_code='5261'DB:business_master_new
loadtime:0.69023489952087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purcellville' limit 1
loadtime:0.69027090072632 / seconds
Query Executed:select id FROM `va` where city='Purcellville' && SIC_code='5261'DB:business_master_new
loadtime:0.69229388237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quantico' limit 1
loadtime:0.69235181808472 / seconds
Query Executed:select id FROM `va` where city='Quantico' && SIC_code='5261'DB:business_master_new
loadtime:0.69349694252014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quicksburg' limit 1
loadtime:0.69353294372559 / seconds
Query Executed:select id FROM `va` where city='Quicksburg' && SIC_code='5261'DB:business_master_new
loadtime:0.69443798065186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:0.69448494911194 / seconds
Query Executed:select id FROM `va` where city='Quinby' && SIC_code='5261'DB:business_master_new
loadtime:0.69492793083191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinque' limit 1
loadtime:0.69495582580566 / seconds
Query Executed:select id FROM `va` where city='Quinque' && SIC_code='5261'DB:business_master_new
loadtime:0.69544291496277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:0.69548988342285 / seconds
Query Executed:select id FROM `va` where city='Quinton' && SIC_code='5261'DB:business_master_new
loadtime:0.69687581062317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radford' limit 1
loadtime:0.69693183898926 / seconds
Query Executed:select id FROM `va` where city='Radford' && SIC_code='5261'DB:business_master_new
loadtime:0.69877290725708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radiant' limit 1
loadtime:0.69882893562317 / seconds
Query Executed:select id FROM `va` where city='Radiant' && SIC_code='5261'DB:business_master_new
loadtime:0.69934797286987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.69939398765564 / seconds
Query Executed:select id FROM `va` where city='Randolph' && SIC_code='5261'DB:business_master_new
loadtime:0.69979691505432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raphine' limit 1
loadtime:0.69982385635376 / seconds
Query Executed:select id FROM `va` where city='Raphine' && SIC_code='5261'DB:business_master_new
loadtime:0.70150589942932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapidan' limit 1
loadtime:0.70155382156372 / seconds
Query Executed:select id FROM `va` where city='Rapidan' && SIC_code='5261'DB:business_master_new
loadtime:0.70280885696411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Academy' limit 1
loadtime:0.70284485816956 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Academy' && SIC_code='5261'DB:business_master_new
loadtime:0.70331978797913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Acd' limit 1
loadtime:0.7033679485321 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Acd' && SIC_code='5261'DB:business_master_new
loadtime:0.70360589027405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raven' limit 1
loadtime:0.7036337852478 / seconds
Query Executed:select id FROM `va` where city='Raven' && SIC_code='5261'DB:business_master_new
loadtime:0.704833984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlings' limit 1
loadtime:0.7048819065094 / seconds
Query Executed:select id FROM `va` where city='Rawlings' && SIC_code='5261'DB:business_master_new
loadtime:0.70530200004578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rectortown' limit 1
loadtime:0.70534586906433 / seconds
Query Executed:select id FROM `va` where city='Rectortown' && SIC_code='5261'DB:business_master_new
loadtime:0.70575594902039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Ash' limit 1
loadtime:0.70578384399414 / seconds
Query Executed:select id FROM `va` where city='Red Ash' && SIC_code='5261'DB:business_master_new
loadtime:0.70604991912842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:0.70608687400818 / seconds
Query Executed:select id FROM `va` where city='Red House' && SIC_code='5261'DB:business_master_new
loadtime:0.70672583580017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:0.70677089691162 / seconds
Query Executed:select id FROM `va` where city='Red Oak' && SIC_code='5261'DB:business_master_new
loadtime:0.70790195465088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redart' limit 1
loadtime:0.70793795585632 / seconds
Query Executed:select id FROM `va` where city='Redart' && SIC_code='5261'DB:business_master_new
loadtime:0.70818090438843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:0.7082188129425 / seconds
Query Executed:select id FROM `va` where city='Redwood' && SIC_code='5261'DB:business_master_new
loadtime:0.70854997634888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedville' limit 1
loadtime:0.708575963974 / seconds
Query Executed:select id FROM `va` where city='Reedville' && SIC_code='5261'DB:business_master_new
loadtime:0.70946192741394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.70951199531555 / seconds
Query Executed:select id FROM `va` where city='Reliance' && SIC_code='5261'DB:business_master_new
loadtime:0.70976901054382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remington' limit 1
loadtime:0.70980596542358 / seconds
Query Executed:select id FROM `va` where city='Remington' && SIC_code='5261'DB:business_master_new
loadtime:0.7108998298645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republican Grove' limit 1
loadtime:0.71093583106995 / seconds
Query Executed:select id FROM `va` where city='Republican Grove' && SIC_code='5261'DB:business_master_new
loadtime:0.71117782592773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rescue' limit 1
loadtime:0.71121692657471 / seconds
Query Executed:select id FROM `va` where city='Rescue' && SIC_code='5261'DB:business_master_new
loadtime:0.71155500411987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reston' limit 1
loadtime:0.71158790588379 / seconds
Query Executed:select id FROM `va` where city='Reston' && SIC_code='5261'DB:business_master_new
loadtime:0.72638392448425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.72643899917603 / seconds
Query Executed:select id FROM `va` where city='Reva' && SIC_code='5261'DB:business_master_new
loadtime:0.7278528213501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhoadesville' limit 1
loadtime:0.72788882255554 / seconds
Query Executed:select id FROM `va` where city='Rhoadesville' && SIC_code='5261'DB:business_master_new
loadtime:0.72917985916138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:0.72923493385315 / seconds
Query Executed:select id FROM `va` where city='Rice' && SIC_code='5261'DB:business_master_new
loadtime:0.7303249835968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Creek' limit 1
loadtime:0.7303729057312 / seconds
Query Executed:select id FROM `va` where city='Rich Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.73227596282959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richardsville' limit 1
loadtime:0.73231196403503 / seconds
Query Executed:select id FROM `va` where city='Richardsville' && SIC_code='5261'DB:business_master_new
loadtime:0.73283100128174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:0.73286986351013 / seconds
Query Executed:select id FROM `va` where city='Richlands' && SIC_code='5261'DB:business_master_new
loadtime:0.73398280143738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.73402881622314 / seconds
Query Executed:select id FROM `va` where city='Richmond' && SIC_code='5261'DB:business_master_new
loadtime:0.74777698516846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.74785184860229 / seconds
Query Executed:select id FROM `va` where city='Ridgeway' && SIC_code='5261'DB:business_master_new
loadtime:0.74918293952942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rileyville' limit 1
loadtime:0.74922895431519 / seconds
Query Executed:select id FROM `va` where city='Rileyville' && SIC_code='5261'DB:business_master_new
loadtime:0.74994492530823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riner' limit 1
loadtime:0.74999284744263 / seconds
Query Executed:select id FROM `va` where city='Riner' && SIC_code='5261'DB:business_master_new
loadtime:0.75092792510986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringgold' limit 1
loadtime:0.75098586082458 / seconds
Query Executed:select id FROM `va` where city='Ringgold' && SIC_code='5261'DB:business_master_new
loadtime:0.7519428730011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripplemead' limit 1
loadtime:0.75198698043823 / seconds
Query Executed:select id FROM `va` where city='Ripplemead' && SIC_code='5261'DB:business_master_new
loadtime:0.75263094902039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.75267887115479 / seconds
Query Executed:select id FROM `va` where city='Riverton' && SIC_code='5261'DB:business_master_new
loadtime:0.75297284126282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rixeyville' limit 1
loadtime:0.75301194190979 / seconds
Query Executed:select id FROM `va` where city='Rixeyville' && SIC_code='5261'DB:business_master_new
loadtime:0.75397181510925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:0.75402593612671 / seconds
Query Executed:select id FROM `va` where city='Roanoke' && SIC_code='5261'DB:business_master_new
loadtime:0.76886892318726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle' limit 1
loadtime:0.76893591880798 / seconds
Query Executed:select id FROM `va` where city='Rochelle' && SIC_code='5261'DB:business_master_new
loadtime:0.76994681358337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockbridge Baths' limit 1
loadtime:0.76999592781067 / seconds
Query Executed:select id FROM `va` where city='Rockbridge Baths' && SIC_code='5261'DB:business_master_new
loadtime:0.7708568572998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:0.77090692520142 / seconds
Query Executed:select id FROM `va` where city='Rockville' && SIC_code='5261'DB:business_master_new
loadtime:0.77197599411011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Gap' limit 1
loadtime:0.77201080322266 / seconds
Query Executed:select id FROM `va` where city='Rocky Gap' && SIC_code='5261'DB:business_master_new
loadtime:0.77320694923401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:0.77325487136841 / seconds
Query Executed:select id FROM `va` where city='Rocky Mount' && SIC_code='5261'DB:business_master_new
loadtime:0.77523183822632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollins Fork' limit 1
loadtime:0.77528786659241 / seconds
Query Executed:select id FROM `va` where city='Rollins Fork' && SIC_code='5261'DB:business_master_new
loadtime:0.77558279037476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:0.77561092376709 / seconds
Query Executed:select id FROM `va` where city='Rose Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.77734684944153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:0.7774019241333 / seconds
Query Executed:select id FROM `va` where city='Rosedale' && SIC_code='5261'DB:business_master_new
loadtime:0.77880787849426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:0.77885890007019 / seconds
Query Executed:select id FROM `va` where city='Roseland' && SIC_code='5261'DB:business_master_new
loadtime:0.78045678138733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Hill' limit 1
loadtime:0.78049278259277 / seconds
Query Executed:select id FROM `va` where city='Round Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.78187799453735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:0.78193497657776 / seconds
Query Executed:select id FROM `va` where city='Rowe' && SIC_code='5261'DB:business_master_new
loadtime:0.78239798545837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:0.78243398666382 / seconds
Query Executed:select id FROM `va` where city='Ruby' && SIC_code='5261'DB:business_master_new
loadtime:0.78297686576843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruckersville' limit 1
loadtime:0.78301596641541 / seconds
Query Executed:select id FROM `va` where city='Ruckersville' && SIC_code='5261'DB:business_master_new
loadtime:0.78438186645508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Retreat' limit 1
loadtime:0.78443789482117 / seconds
Query Executed:select id FROM `va` where city='Rural Retreat' && SIC_code='5261'DB:business_master_new
loadtime:0.78582692146301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rustburg' limit 1
loadtime:0.78587079048157 / seconds
Query Executed:select id FROM `va` where city='Rustburg' && SIC_code='5261'DB:business_master_new
loadtime:0.7873067855835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruther Glen' limit 1
loadtime:0.78737187385559 / seconds
Query Executed:select id FROM `va` where city='Ruther Glen' && SIC_code='5261'DB:business_master_new
loadtime:0.78875494003296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthville' limit 1
loadtime:0.78880095481873 / seconds
Query Executed:select id FROM `va` where city='Ruthville' && SIC_code='5261'DB:business_master_new
loadtime:0.78929281234741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.78934097290039 / seconds
Query Executed:select id FROM `va` where city='Saint Charles' && SIC_code='5261'DB:business_master_new
loadtime:0.78988194465637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:0.78991985321045 / seconds
Query Executed:select id FROM `va` where city='Saint Paul' && SIC_code='5261'DB:business_master_new
loadtime:0.7909529209137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens Church' limit 1
loadtime:0.7910008430481 / seconds
Query Executed:select id FROM `va` where city='Saint Stephens Church' && SIC_code='5261'DB:business_master_new
loadtime:0.79209780693054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.79214477539062 / seconds
Query Executed:select id FROM `va` where city='Salem' && SIC_code='5261'DB:business_master_new
loadtime:0.79419684410095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltville' limit 1
loadtime:0.79424381256104 / seconds
Query Executed:select id FROM `va` where city='Saltville' && SIC_code='5261'DB:business_master_new
loadtime:0.79505181312561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:0.79510688781738 / seconds
Query Executed:select id FROM `va` where city='Saluda' && SIC_code='5261'DB:business_master_new
loadtime:0.79596090316772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandston' limit 1
loadtime:0.79600977897644 / seconds
Query Executed:select id FROM `va` where city='Sandston' && SIC_code='5261'DB:business_master_new
loadtime:0.79711580276489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.79715991020203 / seconds
Query Executed:select id FROM `va` where city='Sandy Hook' && SIC_code='5261'DB:business_master_new
loadtime:0.79772877693176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Level' limit 1
loadtime:0.79776883125305 / seconds
Query Executed:select id FROM `va` where city='Sandy Level' && SIC_code='5261'DB:business_master_new
loadtime:0.79827189445496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Point' limit 1
loadtime:0.7983078956604 / seconds
Query Executed:select id FROM `va` where city='Sandy Point' && SIC_code='5261'DB:business_master_new
loadtime:0.79861378669739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:0.79867196083069 / seconds
Query Executed:select id FROM `va` where city='Sanford' && SIC_code='5261'DB:business_master_new
loadtime:0.79916882514954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxe' limit 1
loadtime:0.79921579360962 / seconds
Query Executed:select id FROM `va` where city='Saxe' && SIC_code='5261'DB:business_master_new
loadtime:0.79972100257874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxis' limit 1
loadtime:0.79974985122681 / seconds
Query Executed:select id FROM `va` where city='Saxis' && SIC_code='5261'DB:business_master_new
loadtime:0.800372838974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schley' limit 1
loadtime:0.80041980743408 / seconds
Query Executed:select id FROM `va` where city='Schley' && SIC_code='5261'DB:business_master_new
loadtime:0.80078291893005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schuyler' limit 1
loadtime:0.80080986022949 / seconds
Query Executed:select id FROM `va` where city='Schuyler' && SIC_code='5261'DB:business_master_new
loadtime:0.80162501335144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:0.80167484283447 / seconds
Query Executed:select id FROM `va` where city='Scottsburg' && SIC_code='5261'DB:business_master_new
loadtime:0.80250382423401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsville' limit 1
loadtime:0.8025529384613 / seconds
Query Executed:select id FROM `va` where city='Scottsville' && SIC_code='5261'DB:business_master_new
loadtime:0.80378699302673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaford' limit 1
loadtime:0.80384278297424 / seconds
Query Executed:select id FROM `va` where city='Seaford' && SIC_code='5261'DB:business_master_new
loadtime:0.80489087104797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealston' limit 1
loadtime:0.80493879318237 / seconds
Query Executed:select id FROM `va` where city='Sealston' && SIC_code='5261'DB:business_master_new
loadtime:0.80529689788818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:0.80534291267395 / seconds
Query Executed:select id FROM `va` where city='Seaview' && SIC_code='5261'DB:business_master_new
loadtime:0.80560779571533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedley' limit 1
loadtime:0.80563497543335 / seconds
Query Executed:select id FROM `va` where city='Sedley' && SIC_code='5261'DB:business_master_new
loadtime:0.80696892738342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:0.8070228099823 / seconds
Query Executed:select id FROM `va` where city='Selma' && SIC_code='5261'DB:business_master_new
loadtime:0.80754494667053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Corners' limit 1
loadtime:0.80758881568909 / seconds
Query Executed:select id FROM `va` where city='Seven Corners' && SIC_code='5261'DB:business_master_new
loadtime:0.80787587165833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Mile Ford' limit 1
loadtime:0.80790495872498 / seconds
Query Executed:select id FROM `va` where city='Seven Mile Ford' && SIC_code='5261'DB:business_master_new
loadtime:0.80816292762756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:0.80819988250732 / seconds
Query Executed:select id FROM `va` where city='Severn' && SIC_code='5261'DB:business_master_new
loadtime:0.80848288536072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shacklefords' limit 1
loadtime:0.80850791931152 / seconds
Query Executed:select id FROM `va` where city='Shacklefords' && SIC_code='5261'DB:business_master_new
loadtime:0.80935096740723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharps' limit 1
loadtime:0.80939698219299 / seconds
Query Executed:select id FROM `va` where city='Sharps' && SIC_code='5261'DB:business_master_new
loadtime:0.80992388725281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawsville' limit 1
loadtime:0.80995297431946 / seconds
Query Executed:select id FROM `va` where city='Shawsville' && SIC_code='5261'DB:business_master_new
loadtime:0.81094694137573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:0.81099390983582 / seconds
Query Executed:select id FROM `va` where city='Shelby' && SIC_code='5261'DB:business_master_new
loadtime:0.81125783920288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:0.81129384040833 / seconds
Query Executed:select id FROM `va` where city='Shenandoah' && SIC_code='5261'DB:business_master_new
loadtime:0.81235980987549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Cvrns' limit 1
loadtime:0.81241393089294 / seconds
Query Executed:select id FROM `va` where city='Shenandoah Cvrns' && SIC_code='5261'DB:business_master_new
loadtime:0.81282877922058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherando' limit 1
loadtime:0.81285786628723 / seconds
Query Executed:select id FROM `va` where city='Sherando' && SIC_code='5261'DB:business_master_new
loadtime:0.8131628036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:0.81321287155151 / seconds
Query Executed:select id FROM `va` where city='Shiloh' && SIC_code='5261'DB:business_master_new
loadtime:0.8134617805481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shipman' limit 1
loadtime:0.81349492073059 / seconds
Query Executed:select id FROM `va` where city='Shipman' && SIC_code='5261'DB:business_master_new
loadtime:0.81454086303711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shortt Gap' limit 1
loadtime:0.81457686424255 / seconds
Query Executed:select id FROM `va` where city='Shortt Gap' && SIC_code='5261'DB:business_master_new
loadtime:0.81483483314514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Singers Glen' limit 1
loadtime:0.81487488746643 / seconds
Query Executed:select id FROM `va` where city='Singers Glen' && SIC_code='5261'DB:business_master_new
loadtime:0.81564688682556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skippers' limit 1
loadtime:0.81568288803101 / seconds
Query Executed:select id FROM `va` where city='Skippers' && SIC_code='5261'DB:business_master_new
loadtime:0.8166868686676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipwith' limit 1
loadtime:0.81675887107849 / seconds
Query Executed:select id FROM `va` where city='Skipwith' && SIC_code='5261'DB:business_master_new
loadtime:0.81758594512939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:0.81763792037964 / seconds
Query Executed:select id FROM `va` where city='Smithfield' && SIC_code='5261'DB:business_master_new
loadtime:0.81963586807251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snell' limit 1
loadtime:0.81967997550964 / seconds
Query Executed:select id FROM `va` where city='Snell' && SIC_code='5261'DB:business_master_new
loadtime:0.8200569152832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:0.82010698318481 / seconds
Query Executed:select id FROM `va` where city='Somerset' && SIC_code='5261'DB:business_master_new
loadtime:0.82084178924561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:0.82088994979858 / seconds
Query Executed:select id FROM `va` where city='Somerville' && SIC_code='5261'DB:business_master_new
loadtime:0.82115793228149 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:0.82119178771973 / seconds
Query Executed:select id FROM `va` where city='South Boston' && SIC_code='5261'DB:business_master_new
loadtime:0.82304692268372 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hill' limit 1
loadtime:0.82310581207275 / seconds
Query Executed:select id FROM `va` where city='South Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.82483983039856 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Riding' limit 1
loadtime:0.82488584518433 / seconds
Query Executed:select id FROM `va` where city='South Riding' && SIC_code='5261'DB:business_master_new
loadtime:0.82522583007812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:0.82527685165405 / seconds
Query Executed:select id FROM `va` where city='Sparta' && SIC_code='5261'DB:business_master_new
loadtime:0.82564091682434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speedwell' limit 1
loadtime:0.82567381858826 / seconds
Query Executed:select id FROM `va` where city='Speedwell' && SIC_code='5261'DB:business_master_new
loadtime:0.82625389099121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.82630181312561 / seconds
Query Executed:select id FROM `va` where city='Spencer' && SIC_code='5261'DB:business_master_new
loadtime:0.82762598991394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperryville' limit 1
loadtime:0.82767391204834 / seconds
Query Executed:select id FROM `va` where city='Sperryville' && SIC_code='5261'DB:business_master_new
loadtime:0.82872986793518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotsylvania' limit 1
loadtime:0.82877278327942 / seconds
Query Executed:select id FROM `va` where city='Spotsylvania' && SIC_code='5261'DB:business_master_new
loadtime:0.83039784431458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spout Spring' limit 1
loadtime:0.8304557800293 / seconds
Query Executed:select id FROM `va` where city='Spout Spring' && SIC_code='5261'DB:business_master_new
loadtime:0.83125495910645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Grove' limit 1
loadtime:0.83131098747253 / seconds
Query Executed:select id FROM `va` where city='Spring Grove' && SIC_code='5261'DB:business_master_new
loadtime:0.83191895484924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.83195686340332 / seconds
Query Executed:select id FROM `va` where city='Springfield' && SIC_code='5261'DB:business_master_new
loadtime:0.84930777549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.84936785697937 / seconds
Query Executed:select id FROM `va` where city='St Charles' && SIC_code='5261'DB:business_master_new
loadtime:0.84975099563599 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:0.84978795051575 / seconds
Query Executed:select id FROM `va` where city='St Paul' && SIC_code='5261'DB:business_master_new
loadtime:0.85018181800842 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens Chr' limit 1
loadtime:0.85021781921387 / seconds
Query Executed:select id FROM `va` where city='St Stephens Chr' && SIC_code='5261'DB:business_master_new
loadtime:0.85057783126831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.85062193870544 / seconds
Query Executed:select id FROM `va` where city='Stafford' && SIC_code='5261'DB:business_master_new
loadtime:0.853022813797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordsville' limit 1
loadtime:0.85309195518494 / seconds
Query Executed:select id FROM `va` where city='Staffordsville' && SIC_code='5261'DB:business_master_new
loadtime:0.85342478752136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanardsville' limit 1
loadtime:0.85346984863281 / seconds
Query Executed:select id FROM `va` where city='Stanardsville' && SIC_code='5261'DB:business_master_new
loadtime:0.85485196113586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:0.85489988327026 / seconds
Query Executed:select id FROM `va` where city='Stanley' && SIC_code='5261'DB:business_master_new
loadtime:0.85612678527832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanleytown' limit 1
loadtime:0.85617184638977 / seconds
Query Executed:select id FROM `va` where city='Stanleytown' && SIC_code='5261'DB:business_master_new
loadtime:0.85698485374451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Tannery' limit 1
loadtime:0.85703277587891 / seconds
Query Executed:select id FROM `va` where city='Star Tannery' && SIC_code='5261'DB:business_master_new
loadtime:0.85775089263916 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Farm' limit 1
loadtime:0.8577868938446 / seconds
Query Executed:select id FROM `va` where city='State Farm' && SIC_code='5261'DB:business_master_new
loadtime:0.85821390151978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staunton' limit 1
loadtime:0.85826182365417 / seconds
Query Executed:select id FROM `va` where city='Staunton' && SIC_code='5261'DB:business_master_new
loadtime:0.86060881614685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steeles Tavern' limit 1
loadtime:0.86065578460693 / seconds
Query Executed:select id FROM `va` where city='Steeles Tavern' && SIC_code='5261'DB:business_master_new
loadtime:0.86135578155518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephens City' limit 1
loadtime:0.86140394210815 / seconds
Query Executed:select id FROM `va` where city='Stephens City' && SIC_code='5261'DB:business_master_new
loadtime:0.86243081092834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:0.86246800422668 / seconds
Query Executed:select id FROM `va` where city='Stephenson' && SIC_code='5261'DB:business_master_new
loadtime:0.86376690864563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.86381387710571 / seconds
Query Executed:select id FROM `va` where city='Sterling' && SIC_code='5261'DB:business_master_new
loadtime:0.87794589996338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensburg' limit 1
loadtime:0.87800693511963 / seconds
Query Executed:select id FROM `va` where city='Stevensburg' && SIC_code='5261'DB:business_master_new
loadtime:0.8786199092865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:0.87866592407227 / seconds
Query Executed:select id FROM `va` where city='Stevensville' && SIC_code='5261'DB:business_master_new
loadtime:0.87909197807312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Ridge' limit 1
loadtime:0.8791389465332 / seconds
Query Executed:select id FROM `va` where city='Stone Ridge' && SIC_code='5261'DB:business_master_new
loadtime:0.87938284873962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonega' limit 1
loadtime:0.87941098213196 / seconds
Query Executed:select id FROM `va` where city='Stonega' && SIC_code='5261'DB:business_master_new
loadtime:0.87964797019958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Creek' limit 1
loadtime:0.8796808719635 / seconds
Query Executed:select id FROM `va` where city='Stony Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.88086700439453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:0.88092184066772 / seconds
Query Executed:select id FROM `va` where city='Strasburg' && SIC_code='5261'DB:business_master_new
loadtime:0.88235592842102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.88241386413574 / seconds
Query Executed:select id FROM `va` where city='Stratford' && SIC_code='5261'DB:business_master_new
loadtime:0.88268494606018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:0.88272595405579 / seconds
Query Executed:select id FROM `va` where city='Stuart' && SIC_code='5261'DB:business_master_new
loadtime:0.88393592834473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuarts Draft' limit 1
loadtime:0.88399291038513 / seconds
Query Executed:select id FROM `va` where city='Stuarts Draft' && SIC_code='5261'DB:business_master_new
loadtime:0.88537788391113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:0.88542199134827 / seconds
Query Executed:select id FROM `va` where city='Studley' && SIC_code='5261'DB:business_master_new
loadtime:0.885910987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffolk' limit 1
loadtime:0.88595080375671 / seconds
Query Executed:select id FROM `va` where city='Suffolk' && SIC_code='5261'DB:business_master_new
loadtime:0.88857793807983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:0.88864088058472 / seconds
Query Executed:select id FROM `va` where city='Sugar Grove' && SIC_code='5261'DB:business_master_new
loadtime:0.88962078094482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerduck' limit 1
loadtime:0.88965797424316 / seconds
Query Executed:select id FROM `va` where city='Sumerduck' && SIC_code='5261'DB:business_master_new
loadtime:0.89066696166992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:0.89072394371033 / seconds
Query Executed:select id FROM `va` where city='Supply' && SIC_code='5261'DB:business_master_new
loadtime:0.89096784591675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:0.89100098609924 / seconds
Query Executed:select id FROM `va` where city='Surry' && SIC_code='5261'DB:business_master_new
loadtime:0.89202189445496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susan' limit 1
loadtime:0.89206600189209 / seconds
Query Executed:select id FROM `va` where city='Susan' && SIC_code='5261'DB:business_master_new
loadtime:0.8925039768219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:0.89255380630493 / seconds
Query Executed:select id FROM `va` where city='Sussex' && SIC_code='5261'DB:business_master_new
loadtime:0.8931028842926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:0.89314985275269 / seconds
Query Executed:select id FROM `va` where city='Sutherland' && SIC_code='5261'DB:business_master_new
loadtime:0.89435791969299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:0.89440488815308 / seconds
Query Executed:select id FROM `va` where city='Sutherlin' && SIC_code='5261'DB:business_master_new
loadtime:0.89518880844116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Briar' limit 1
loadtime:0.89522480964661 / seconds
Query Executed:select id FROM `va` where city='Sweet Briar' && SIC_code='5261'DB:business_master_new
loadtime:0.89575099945068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swoope' limit 1
loadtime:0.89578986167908 / seconds
Query Executed:select id FROM `va` where city='Swoope' && SIC_code='5261'DB:business_master_new
loadtime:0.89680290222168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swords Creek' limit 1
loadtime:0.89683890342712 / seconds
Query Executed:select id FROM `va` where city='Swords Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.89777088165283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syria' limit 1
loadtime:0.89781880378723 / seconds
Query Executed:select id FROM `va` where city='Syria' && SIC_code='5261'DB:business_master_new
loadtime:0.89826393127441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syringa' limit 1
loadtime:0.89829993247986 / seconds
Query Executed:select id FROM `va` where city='Syringa' && SIC_code='5261'DB:business_master_new
loadtime:0.89855289459229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabb' limit 1
loadtime:0.89858889579773 / seconds
Query Executed:select id FROM `va` where city='Tabb' && SIC_code='5261'DB:business_master_new
loadtime:0.89893078804016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangier' limit 1
loadtime:0.8989679813385 / seconds
Query Executed:select id FROM `va` where city='Tangier' && SIC_code='5261'DB:business_master_new
loadtime:0.89953398704529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tannersville' limit 1
loadtime:0.89958500862122 / seconds
Query Executed:select id FROM `va` where city='Tannersville' && SIC_code='5261'DB:business_master_new
loadtime:0.89988279342651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tappahannock' limit 1
loadtime:0.89991188049316 / seconds
Query Executed:select id FROM `va` where city='Tappahannock' && SIC_code='5261'DB:business_master_new
loadtime:0.90126991271973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tasley' limit 1
loadtime:0.90132594108582 / seconds
Query Executed:select id FROM `va` where city='Tasley' && SIC_code='5261'DB:business_master_new
loadtime:0.90221500396729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tazewell' limit 1
loadtime:0.90226483345032 / seconds
Query Executed:select id FROM `va` where city='Tazewell' && SIC_code='5261'DB:business_master_new
loadtime:0.90340781211853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperanceville' limit 1
loadtime:0.90344381332397 / seconds
Query Executed:select id FROM `va` where city='Temperanceville' && SIC_code='5261'DB:business_master_new
loadtime:0.9044349193573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:0.9044828414917 / seconds
Query Executed:select id FROM `va` where city='Thaxton' && SIC_code='5261'DB:business_master_new
loadtime:0.90572595596313 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Plains' limit 1
loadtime:0.90576195716858 / seconds
Query Executed:select id FROM `va` where city='The Plains' && SIC_code='5261'DB:business_master_new
loadtime:0.90678787231445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:0.90684485435486 / seconds
Query Executed:select id FROM `va` where city='Thornburg' && SIC_code='5261'DB:business_master_new
loadtime:0.90791392326355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberville' limit 1
loadtime:0.9079577922821 / seconds
Query Executed:select id FROM `va` where city='Timberville' && SIC_code='5261'DB:business_master_new
loadtime:0.90902280807495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toano' limit 1
loadtime:0.90908789634705 / seconds
Query Executed:select id FROM `va` where city='Toano' && SIC_code='5261'DB:business_master_new
loadtime:0.90996193885803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms Brook' limit 1
loadtime:0.91001677513123 / seconds
Query Executed:select id FROM `va` where city='Toms Brook' && SIC_code='5261'DB:business_master_new
loadtime:0.91145992279053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topping' limit 1
loadtime:0.91150379180908 / seconds
Query Executed:select id FROM `va` where city='Topping' && SIC_code='5261'DB:business_master_new
loadtime:0.91327381134033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:0.91332483291626 / seconds
Query Executed:select id FROM `va` where city='Townsend' && SIC_code='5261'DB:business_master_new
loadtime:0.91365098953247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trammel' limit 1
loadtime:0.9136848449707 / seconds
Query Executed:select id FROM `va` where city='Trammel' && SIC_code='5261'DB:business_master_new
loadtime:0.91393280029297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevilians' limit 1
loadtime:0.91395878791809 / seconds
Query Executed:select id FROM `va` where city='Trevilians' && SIC_code='5261'DB:business_master_new
loadtime:0.91420292854309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triangle' limit 1
loadtime:0.91423678398132 / seconds
Query Executed:select id FROM `va` where city='Triangle' && SIC_code='5261'DB:business_master_new
loadtime:0.91492795944214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triplet' limit 1
loadtime:0.91495299339294 / seconds
Query Executed:select id FROM `va` where city='Triplet' && SIC_code='5261'DB:business_master_new
loadtime:0.91519284248352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Dale' limit 1
loadtime:0.91522479057312 / seconds
Query Executed:select id FROM `va` where city='Trout Dale' && SIC_code='5261'DB:business_master_new
loadtime:0.91545987129211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:0.91549181938171 / seconds
Query Executed:select id FROM `va` where city='Troutdale' && SIC_code='5261'DB:business_master_new
loadtime:0.91640281677246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutville' limit 1
loadtime:0.91645789146423 / seconds
Query Executed:select id FROM `va` where city='Troutville' && SIC_code='5261'DB:business_master_new
loadtime:0.91759896278381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.91765379905701 / seconds
Query Executed:select id FROM `va` where city='Troy' && SIC_code='5261'DB:business_master_new
loadtime:0.91887092590332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:0.91891980171204 / seconds
Query Executed:select id FROM `va` where city='Turbeville' && SIC_code='5261'DB:business_master_new
loadtime:0.91919279098511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:0.91921997070312 / seconds
Query Executed:select id FROM `va` where city='Tyro' && SIC_code='5261'DB:business_master_new
loadtime:0.91965985298157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Hall' limit 1
loadtime:0.9197039604187 / seconds
Query Executed:select id FROM `va` where city='Union Hall' && SIC_code='5261'DB:business_master_new
loadtime:0.92109084129333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.92113900184631 / seconds
Query Executed:select id FROM `va` where city='Unionville' && SIC_code='5261'DB:business_master_new
loadtime:0.92177486419678 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Of Richmond' limit 1
loadtime:0.92180180549622 / seconds
Query Executed:select id FROM `va` where city='University Of Richmond' && SIC_code='5261'DB:business_master_new
loadtime:0.92204999923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperville' limit 1
loadtime:0.9220860004425 / seconds
Query Executed:select id FROM `va` where city='Upperville' && SIC_code='5261'DB:business_master_new
loadtime:0.92284679412842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbanna' limit 1
loadtime:0.92288184165955 / seconds
Query Executed:select id FROM `va` where city='Urbanna' && SIC_code='5261'DB:business_master_new
loadtime:0.92381191253662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentines' limit 1
loadtime:0.9238588809967 / seconds
Query Executed:select id FROM `va` where city='Valentines' && SIC_code='5261'DB:business_master_new
loadtime:0.92442798614502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vansant' limit 1
loadtime:0.92446494102478 / seconds
Query Executed:select id FROM `va` where city='Vansant' && SIC_code='5261'DB:business_master_new
loadtime:0.9255199432373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Hill' limit 1
loadtime:0.9255678653717 / seconds
Query Executed:select id FROM `va` where city='Vernon Hill' && SIC_code='5261'DB:business_master_new
loadtime:0.92633199691772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:0.92638278007507 / seconds
Query Executed:select id FROM `va` where city='Verona' && SIC_code='5261'DB:business_master_new
loadtime:0.92764091491699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesta' limit 1
loadtime:0.92768883705139 / seconds
Query Executed:select id FROM `va` where city='Vesta' && SIC_code='5261'DB:business_master_new
loadtime:0.92820978164673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesuvius' limit 1
loadtime:0.92824578285217 / seconds
Query Executed:select id FROM `va` where city='Vesuvius' && SIC_code='5261'DB:business_master_new
loadtime:0.92885279655457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:0.92889189720154 / seconds
Query Executed:select id FROM `va` where city='Victoria' && SIC_code='5261'DB:business_master_new
loadtime:0.92988896369934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:0.92994379997253 / seconds
Query Executed:select id FROM `va` where city='Vienna' && SIC_code='5261'DB:business_master_new
loadtime:0.94462180137634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viewtown' limit 1
loadtime:0.94468188285828 / seconds
Query Executed:select id FROM `va` where city='Viewtown' && SIC_code='5261'DB:business_master_new
loadtime:0.94507098197937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village' limit 1
loadtime:0.94510889053345 / seconds
Query Executed:select id FROM `va` where city='Village' && SIC_code='5261'DB:business_master_new
loadtime:0.94559979438782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villamont' limit 1
loadtime:0.94564580917358 / seconds
Query Executed:select id FROM `va` where city='Villamont' && SIC_code='5261'DB:business_master_new
loadtime:0.94592595100403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vint Hill Farms' limit 1
loadtime:0.94595289230347 / seconds
Query Executed:select id FROM `va` where city='Vint Hill Farms' && SIC_code='5261'DB:business_master_new
loadtime:0.94618582725525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:0.94622182846069 / seconds
Query Executed:select id FROM `va` where city='Vinton' && SIC_code='5261'DB:business_master_new
loadtime:0.94797897338867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgilina' limit 1
loadtime:0.94803500175476 / seconds
Query Executed:select id FROM `va` where city='Virgilina' && SIC_code='5261'DB:business_master_new
loadtime:0.94941592216492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virginia Beach' limit 1
loadtime:0.94945979118347 / seconds
Query Executed:select id FROM `va` where city='Virginia Beach' && SIC_code='5261'DB:business_master_new
loadtime:0.96641898155212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wachapreague' limit 1
loadtime:0.96649885177612 / seconds
Query Executed:select id FROM `va` where city='Wachapreague' && SIC_code='5261'DB:business_master_new
loadtime:0.96771383285522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake' limit 1
loadtime:0.96776390075684 / seconds
Query Executed:select id FROM `va` where city='Wake' && SIC_code='5261'DB:business_master_new
loadtime:0.96844100952148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:0.96847701072693 / seconds
Query Executed:select id FROM `va` where city='Wakefield' && SIC_code='5261'DB:business_master_new
loadtime:0.96940398216248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerton' limit 1
loadtime:0.96945095062256 / seconds
Query Executed:select id FROM `va` where city='Walkerton' && SIC_code='5261'DB:business_master_new
loadtime:0.97031283378601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallops Island' limit 1
loadtime:0.97034788131714 / seconds
Query Executed:select id FROM `va` where city='Wallops Island' && SIC_code='5261'DB:business_master_new
loadtime:0.97120785713196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walters' limit 1
loadtime:0.97125577926636 / seconds
Query Executed:select id FROM `va` where city='Walters' && SIC_code='5261'DB:business_master_new
loadtime:0.97150087356567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardtown' limit 1
loadtime:0.97152900695801 / seconds
Query Executed:select id FROM `va` where city='Wardtown' && SIC_code='5261'DB:business_master_new
loadtime:0.97187495231628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Neck' limit 1
loadtime:0.97191095352173 / seconds
Query Executed:select id FROM `va` where city='Ware Neck' && SIC_code='5261'DB:business_master_new
loadtime:0.97240400314331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warfield' limit 1
loadtime:0.97244095802307 / seconds
Query Executed:select id FROM `va` where city='Warfield' && SIC_code='5261'DB:business_master_new
loadtime:0.97318983078003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:0.97323679924011 / seconds
Query Executed:select id FROM `va` where city='Warm Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.97422981262207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.97427797317505 / seconds
Query Executed:select id FROM `va` where city='Warner' && SIC_code='5261'DB:business_master_new
loadtime:0.97453379631042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:0.97456789016724 / seconds
Query Executed:select id FROM `va` where city='Warrenton' && SIC_code='5261'DB:business_master_new
loadtime:0.97773480415344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:0.97779488563538 / seconds
Query Executed:select id FROM `va` where city='Warsaw' && SIC_code='5261'DB:business_master_new
loadtime:0.97923278808594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.97929692268372 / seconds
Query Executed:select id FROM `va` where city='Washington' && SIC_code='5261'DB:business_master_new
loadtime:0.98039388656616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water View' limit 1
loadtime:0.98044800758362 / seconds
Query Executed:select id FROM `va` where city='Water View' && SIC_code='5261'DB:business_master_new
loadtime:0.98078584671021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.98082685470581 / seconds
Query Executed:select id FROM `va` where city='Waterford' && SIC_code='5261'DB:business_master_new
loadtime:0.982421875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:0.98245787620544 / seconds
Query Executed:select id FROM `va` where city='Wattsville' && SIC_code='5261'DB:business_master_new
loadtime:0.98289394378662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:0.98293280601501 / seconds
Query Executed:select id FROM `va` where city='Waverly' && SIC_code='5261'DB:business_master_new
loadtime:0.98384881019592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:0.98389792442322 / seconds
Query Executed:select id FROM `va` where city='Waynesboro' && SIC_code='5261'DB:business_master_new
loadtime:0.98562693595886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weber City' limit 1
loadtime:0.9856858253479 / seconds
Query Executed:select id FROM `va` where city='Weber City' && SIC_code='5261'DB:business_master_new
loadtime:0.98689794540405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weems' limit 1
loadtime:0.98694181442261 / seconds
Query Executed:select id FROM `va` where city='Weems' && SIC_code='5261'DB:business_master_new
loadtime:0.98836088180542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirwood' limit 1
loadtime:0.98840880393982 / seconds
Query Executed:select id FROM `va` where city='Weirwood' && SIC_code='5261'DB:business_master_new
loadtime:0.98885893821716 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Augusta' limit 1
loadtime:0.9888858795166 / seconds
Query Executed:select id FROM `va` where city='West Augusta' && SIC_code='5261'DB:business_master_new
loadtime:0.9892258644104 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mclean' limit 1
loadtime:0.9892737865448 / seconds
Query Executed:select id FROM `va` where city='West Mclean' && SIC_code='5261'DB:business_master_new
loadtime:0.98991680145264 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:0.98995685577393 / seconds
Query Executed:select id FROM `va` where city='West Point' && SIC_code='5261'DB:business_master_new
loadtime:0.99119186401367 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:0.99123883247375 / seconds
Query Executed:select id FROM `va` where city='West Springfield' && SIC_code='5261'DB:business_master_new
loadtime:0.99148297309875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:0.9915177822113 / seconds
Query Executed:select id FROM `va` where city='Westmoreland' && SIC_code='5261'DB:business_master_new
loadtime:0.99176597595215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyers Cave' limit 1
loadtime:0.9918007850647 / seconds
Query Executed:select id FROM `va` where city='Weyers Cave' && SIC_code='5261'DB:business_master_new
loadtime:0.99291682243347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitacre' limit 1
loadtime:0.99296092987061 / seconds
Query Executed:select id FROM `va` where city='Whitacre' && SIC_code='5261'DB:business_master_new
loadtime:0.99320793151855 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Hall' limit 1
loadtime:0.99324798583984 / seconds
Query Executed:select id FROM `va` where city='White Hall' && SIC_code='5261'DB:business_master_new
loadtime:0.99362087249756 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Marsh' limit 1
loadtime:0.993647813797 / seconds
Query Executed:select id FROM `va` where city='White Marsh' && SIC_code='5261'DB:business_master_new
loadtime:0.99508690834045 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:0.99514389038086 / seconds
Query Executed:select id FROM `va` where city='White Plains' && SIC_code='5261'DB:business_master_new
loadtime:0.99563384056091 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Post' limit 1
loadtime:0.99566888809204 / seconds
Query Executed:select id FROM `va` where city='White Post' && SIC_code='5261'DB:business_master_new
loadtime:0.997318983078 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:0.9973669052124 / seconds
Query Executed:select id FROM `va` where city='White Stone' && SIC_code='5261'DB:business_master_new
loadtime:0.99848985671997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitetop' limit 1
loadtime:0.99852681159973 / seconds
Query Executed:select id FROM `va` where city='Whitetop' && SIC_code='5261'DB:business_master_new
loadtime:0.99902677536011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:0.9990828037262 / seconds
Query Executed:select id FROM `va` where city='Whitewood' && SIC_code='5261'DB:business_master_new
loadtime:0.99969387054443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico' limit 1
loadtime:0.99976086616516 / seconds
Query Executed:select id FROM `va` where city='Wicomico' && SIC_code='5261'DB:business_master_new
loadtime:1.0004379749298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico Church' limit 1
loadtime:1.0004739761353 / seconds
Query Executed:select id FROM `va` where city='Wicomico Church' && SIC_code='5261'DB:business_master_new
loadtime:1.0012288093567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.0012757778168 / seconds
Query Executed:select id FROM `va` where city='Williamsburg' && SIC_code='5261'DB:business_master_new
loadtime:1.0161988735199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:1.0162568092346 / seconds
Query Executed:select id FROM `va` where city='Williamsville' && SIC_code='5261'DB:business_master_new
loadtime:1.0167179107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:1.0167570114136 / seconds
Query Executed:select id FROM `va` where city='Willis' && SIC_code='5261'DB:business_master_new
loadtime:1.018296957016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis Wharf' limit 1
loadtime:1.0183529853821 / seconds
Query Executed:select id FROM `va` where city='Willis Wharf' && SIC_code='5261'DB:business_master_new
loadtime:1.0187938213348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons' limit 1
loadtime:1.0188229084015 / seconds
Query Executed:select id FROM `va` where city='Wilsons' && SIC_code='5261'DB:business_master_new
loadtime:1.0193498134613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:1.0193989276886 / seconds
Query Executed:select id FROM `va` where city='Winchester' && SIC_code='5261'DB:business_master_new
loadtime:1.03777384758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.0378339290619 / seconds
Query Executed:select id FROM `va` where city='Windsor' && SIC_code='5261'DB:business_master_new
loadtime:1.0390288829803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingina' limit 1
loadtime:1.0390839576721 / seconds
Query Executed:select id FROM `va` where city='Wingina' && SIC_code='5261'DB:business_master_new
loadtime:1.0394518375397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wintergreen' limit 1
loadtime:1.0394878387451 / seconds
Query Executed:select id FROM `va` where city='Wintergreen' && SIC_code='5261'DB:business_master_new
loadtime:1.0398998260498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wirtz' limit 1
loadtime:1.0399389266968 / seconds
Query Executed:select id FROM `va` where city='Wirtz' && SIC_code='5261'DB:business_master_new
loadtime:1.0409939289093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:1.0410377979279 / seconds
Query Executed:select id FROM `va` where city='Wise' && SIC_code='5261'DB:business_master_new
loadtime:1.042564868927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withams' limit 1
loadtime:1.0426208972931 / seconds
Query Executed:select id FROM `va` where city='Withams' && SIC_code='5261'DB:business_master_new
loadtime:1.0429139137268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolford' limit 1
loadtime:1.0429518222809 / seconds
Query Executed:select id FROM `va` where city='Wolford' && SIC_code='5261'DB:business_master_new
loadtime:1.043319940567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolftown' limit 1
loadtime:1.0433559417725 / seconds
Query Executed:select id FROM `va` where city='Wolftown' && SIC_code='5261'DB:business_master_new
loadtime:1.043830871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodberry Forest' limit 1
loadtime:1.0438709259033 / seconds
Query Executed:select id FROM `va` where city='Woodberry Forest' && SIC_code='5261'DB:business_master_new
loadtime:1.0442237854004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:1.0442698001862 / seconds
Query Executed:select id FROM `va` where city='Woodbridge' && SIC_code='5261'DB:business_master_new
loadtime:1.0582499504089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:1.0583097934723 / seconds
Query Executed:select id FROM `va` where city='Woodford' && SIC_code='5261'DB:business_master_new
loadtime:1.0594968795776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodlawn' limit 1
loadtime:1.059553861618 / seconds
Query Executed:select id FROM `va` where city='Woodlawn' && SIC_code='5261'DB:business_master_new
loadtime:1.060831785202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Rds' limit 1
loadtime:1.0608777999878 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Rds' && SIC_code='5261'DB:business_master_new
loadtime:1.0611248016357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Roads' limit 1
loadtime:1.0611639022827 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Roads' && SIC_code='5261'DB:business_master_new
loadtime:1.0615479946136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.0615940093994 / seconds
Query Executed:select id FROM `va` where city='Woodstock' && SIC_code='5261'DB:business_master_new
loadtime:1.0631668567657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:1.0632228851318 / seconds
Query Executed:select id FROM `va` where city='Woodville' && SIC_code='5261'DB:business_master_new
loadtime:1.0638659000397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolwine' limit 1
loadtime:1.0638949871063 / seconds
Query Executed:select id FROM `va` where city='Woolwine' && SIC_code='5261'DB:business_master_new
loadtime:1.0649039745331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wylliesburg' limit 1
loadtime:1.0649509429932 / seconds
Query Executed:select id FROM `va` where city='Wylliesburg' && SIC_code='5261'DB:business_master_new
loadtime:1.0657839775085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wytheville' limit 1
loadtime:1.0658209323883 / seconds
Query Executed:select id FROM `va` where city='Wytheville' && SIC_code='5261'DB:business_master_new
loadtime:1.068018913269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:1.0680749416351 / seconds
Query Executed:select id FROM `va` where city='Yale' && SIC_code='5261'DB:business_master_new
loadtime:1.0687999725342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:1.0688478946686 / seconds
Query Executed:select id FROM `va` where city='Yorktown' && SIC_code='5261'DB:business_master_new
loadtime:1.0717639923096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zacata' limit 1
loadtime:1.0718247890472 / seconds
Query Executed:select id FROM `va` where city='Zacata' && SIC_code='5261'DB:business_master_new
loadtime:1.0721809864044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zanoni' limit 1
loadtime:1.0722289085388 / seconds
Query Executed:select id FROM `va` where city='Zanoni' && SIC_code='5261'DB:business_master_new
loadtime:1.0726079940796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:1.0726358890533 / seconds
Query Executed:select id FROM `va` where city='Zuni' && SIC_code='5261'DB:business_master_new
loadtime:1.0743818283081 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.0744779109955 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.0747079849243 / seconds
Operation template executed (chunk cache operation)
loadtime:1.0747888088226 / seconds
template override:Default
loadtime:1.074807882309 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.076014995575 / seconds
Template Constructed, Array Rows:49
loadtime:1.0762519836426 / seconds
TOTAL EXECUTION TIME: 1.07606
loadtime:1.0763638019562 / 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] => retail-nurseries-lawn-and-garden-supply-stores [stateURLid] => virginia )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.0763688087463
TOTAL KEY ARRAYS: 69