Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.793571472168E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00041007995605469 / seconds
host not found setting manual db connection
loadtime:0.00074100494384766 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010430812835693 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.001162052154541 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0012071132659912 / seconds
zipcode:
loadtime:0.0012240409851074 / seconds
Query Executed:select * from search_referrer where page_hash='e11eb243f1bc6f671bd10f02f9ee5a63' limit 10 DB:ezrox_toadli
loadtime:0.0013971328735352 / seconds
Operation header executed (non global)
loadtime:0.001413106918335 / seconds
Operation leaderboard executed (non global)
loadtime:0.0014410018920898 / seconds
Operation square executed (non global)
loadtime:0.0014550685882568 / seconds
Operation square_bottom executed (non global)
loadtime:0.0014669895172119 / seconds
Operation smallsquare executed (non global)
loadtime:0.0014779567718506 / seconds
Operation headeradright executed (non global)
loadtime:0.0014889240264893 / seconds
Operation google_analytics executed (non global)
loadtime:0.001500129699707 / seconds
Operation topstories executed (non global)
loadtime:0.0015120506286621 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0015230178833008 / seconds
Operation memberbuscount executed (non global)
loadtime:0.001533031463623 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017600059509277 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0019190311431885 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0019600391387939 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0020210742950439 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0020570755004883 / seconds
Template key: archive_menu pushed
loadtime:0.0020620822906494 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0020689964294434 / seconds
Template key: get_gravatar pushed
loadtime:0.0020730495452881 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0020761489868164 / seconds
*10)-10)+1 | start:0
loadtime:0.0020971298217773 / seconds
Query loaded from cache:select * from categories where cat_URLid='veterinary-services-for-animal-specialties'
loadtime:0.002129077911377 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.0021660327911377 / seconds
DB connected to localhost business_master_new
loadtime:0.002392053604126 / seconds
Query Executed:select * from `va_catmap` where sic='0742' order by city ascDB:business_master_new
loadtime:0.22127294540405 / seconds
Query stored in cache : _QUERY_www.toadli.come3f9cf4910a021615ea43a9f5d672856
loadtime:0.225417137146 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='virginia'
loadtime:0.22546195983887 / seconds
Query Executed:select sum(totalcount) as totalsum from `va_catmap` where sic='0742'DB:business_master_new
loadtime:0.23047399520874 / seconds
Query stored in cache : _QUERY_www.toadli.com4a3d8e0c1df157e78df515c63bf0f171
loadtime:0.23050498962402 / seconds
942 / 11
loadtime:0.23053812980652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abingdon' limit 1
loadtime:0.23058795928955 / seconds
Query Executed:select id FROM `va` where city='Abingdon' && SIC_code='0742'DB:business_master_new
loadtime:0.2376070022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accomac' limit 1
loadtime:0.23767304420471 / seconds
Query Executed:select id FROM `va` where city='Accomac' && SIC_code='0742'DB:business_master_new
loadtime:0.23838114738464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Achilles' limit 1
loadtime:0.23843002319336 / seconds
Query Executed:select id FROM `va` where city='Achilles' && SIC_code='0742'DB:business_master_new
loadtime:0.24207401275635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.24212503433228 / seconds
Query Executed:select id FROM `va` where city='Afton' && SIC_code='0742'DB:business_master_new
loadtime:0.24276995658875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alberta' limit 1
loadtime:0.24280595779419 / seconds
Query Executed:select id FROM `va` where city='Alberta' && SIC_code='0742'DB:business_master_new
loadtime:0.26180911064148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aldie' limit 1
loadtime:0.26185202598572 / seconds
Query Executed:select id FROM `va` where city='Aldie' && SIC_code='0742'DB:business_master_new
loadtime:0.26254296302795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.26258206367493 / seconds
Query Executed:select id FROM `va` where city='Alexandria' && SIC_code='0742'DB:business_master_new
loadtime:0.65175199508667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleghany' limit 1
loadtime:0.65187692642212 / seconds
Query Executed:select id FROM `va` where city='Alleghany' && SIC_code='0742'DB:business_master_new
loadtime:0.65323805809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allisonia' limit 1
loadtime:0.65328097343445 / seconds
Query Executed:select id FROM `va` where city='Allisonia' && SIC_code='0742'DB:business_master_new
loadtime:0.6535279750824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altavista' limit 1
loadtime:0.653568983078 / seconds
Query Executed:select id FROM `va` where city='Altavista' && SIC_code='0742'DB:business_master_new
loadtime:0.65440511703491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.65445303916931 / seconds
Query Executed:select id FROM `va` where city='Alton' && SIC_code='0742'DB:business_master_new
loadtime:0.67343091964722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alum Ridge' limit 1
loadtime:0.67347812652588 / seconds
Query Executed:select id FROM `va` where city='Alum Ridge' && SIC_code='0742'DB:business_master_new
loadtime:0.67372298240662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court House' limit 1
loadtime:0.6737539768219 / seconds
Query Executed:select id FROM `va` where city='Amelia Court House' && SIC_code='0742'DB:business_master_new
loadtime:0.67468309402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amelia Court Hse' limit 1
loadtime:0.67474603652954 / seconds
Query Executed:select id FROM `va` where city='Amelia Court Hse' && SIC_code='0742'DB:business_master_new
loadtime:0.6807849407196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.68083596229553 / seconds
Query Executed:select id FROM `va` where city='Amherst' && SIC_code='0742'DB:business_master_new
loadtime:0.68173599243164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amissville' limit 1
loadtime:0.68178105354309 / seconds
Query Executed:select id FROM `va` where city='Amissville' && SIC_code='0742'DB:business_master_new
loadtime:0.68252611160278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ammon' limit 1
loadtime:0.68257904052734 / seconds
Query Executed:select id FROM `va` where city='Ammon' && SIC_code='0742'DB:business_master_new
loadtime:0.68283700942993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amonate' limit 1
loadtime:0.68288111686707 / seconds
Query Executed:select id FROM `va` where city='Amonate' && SIC_code='0742'DB:business_master_new
loadtime:0.68426203727722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.68430399894714 / seconds
Query Executed:select id FROM `va` where city='Andover' && SIC_code='0742'DB:business_master_new
loadtime:0.6861310005188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.68617606163025 / seconds
Query Executed:select id FROM `va` where city='Annandale' && SIC_code='0742'DB:business_master_new
loadtime:0.68798303604126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appalachia' limit 1
loadtime:0.68804812431335 / seconds
Query Executed:select id FROM `va` where city='Appalachia' && SIC_code='0742'DB:business_master_new
loadtime:0.72522497177124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appomattox' limit 1
loadtime:0.72527313232422 / seconds
Query Executed:select id FROM `va` where city='Appomattox' && SIC_code='0742'DB:business_master_new
loadtime:0.72610998153687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.72615504264832 / seconds
Query Executed:select id FROM `va` where city='Ararat' && SIC_code='0742'DB:business_master_new
loadtime:0.74930000305176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.74934697151184 / seconds
Query Executed:select id FROM `va` where city='Arcola' && SIC_code='0742'DB:business_master_new
loadtime:0.75787997245789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ark' limit 1
loadtime:0.75794792175293 / seconds
Query Executed:select id FROM `va` where city='Ark' && SIC_code='0742'DB:business_master_new
loadtime:0.76217794418335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.76222205162048 / seconds
Query Executed:select id FROM `va` where city='Arlington' && SIC_code='0742'DB:business_master_new
loadtime:0.77136993408203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aroda' limit 1
loadtime:0.77142810821533 / seconds
Query Executed:select id FROM `va` where city='Aroda' && SIC_code='0742'DB:business_master_new
loadtime:0.77866911888123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arrington' limit 1
loadtime:0.77871799468994 / seconds
Query Executed:select id FROM `va` where city='Arrington' && SIC_code='0742'DB:business_master_new
loadtime:0.80722904205322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvonia' limit 1
loadtime:0.8072829246521 / seconds
Query Executed:select id FROM `va` where city='Arvonia' && SIC_code='0742'DB:business_master_new
loadtime:0.81836414337158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburn' limit 1
loadtime:0.81841397285461 / seconds
Query Executed:select id FROM `va` where city='Ashburn' && SIC_code='0742'DB:business_master_new
loadtime:0.81977415084839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.81982898712158 / seconds
Query Executed:select id FROM `va` where city='Ashland' && SIC_code='0742'DB:business_master_new
loadtime:0.82130002975464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assawoman' limit 1
loadtime:0.82135200500488 / seconds
Query Executed:select id FROM `va` where city='Assawoman' && SIC_code='0742'DB:business_master_new
loadtime:0.82278299331665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.8228280544281 / seconds
Query Executed:select id FROM `va` where city='Atkins' && SIC_code='0742'DB:business_master_new
loadtime:0.85334610939026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.85339093208313 / seconds
Query Executed:select id FROM `va` where city='Atlantic' && SIC_code='0742'DB:business_master_new
loadtime:0.86408710479736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta Springs' limit 1
loadtime:0.86413812637329 / seconds
Query Executed:select id FROM `va` where city='Augusta Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.8652651309967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.86530613899231 / seconds
Query Executed:select id FROM `va` where city='Austinville' && SIC_code='0742'DB:business_master_new
loadtime:0.88273596763611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axton' limit 1
loadtime:0.88278603553772 / seconds
Query Executed:select id FROM `va` where city='Axton' && SIC_code='0742'DB:business_master_new
loadtime:0.88352513313293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aylett' limit 1
loadtime:0.8835780620575 / seconds
Query Executed:select id FROM `va` where city='Aylett' && SIC_code='0742'DB:business_master_new
loadtime:0.88432502746582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bacova' limit 1
loadtime:0.88436508178711 / seconds
Query Executed:select id FROM `va` where city='Bacova' && SIC_code='0742'DB:business_master_new
loadtime:0.88552904129028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Crossrds' limit 1
loadtime:0.88558101654053 / seconds
Query Executed:select id FROM `va` where city='Baileys Crossrds' && SIC_code='0742'DB:business_master_new
loadtime:0.88920211791992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banco' limit 1
loadtime:0.88924193382263 / seconds
Query Executed:select id FROM `va` where city='Banco' && SIC_code='0742'DB:business_master_new
loadtime:0.89032912254333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bandy' limit 1
loadtime:0.89038014411926 / seconds
Query Executed:select id FROM `va` where city='Bandy' && SIC_code='0742'DB:business_master_new
loadtime:0.89298701286316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barboursville' limit 1
loadtime:0.89303493499756 / seconds
Query Executed:select id FROM `va` where city='Barboursville' && SIC_code='0742'DB:business_master_new
loadtime:0.89369606971741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barhamsville' limit 1
loadtime:0.89374494552612 / seconds
Query Executed:select id FROM `va` where city='Barhamsville' && SIC_code='0742'DB:business_master_new
loadtime:1.0141069889069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barren Springs' limit 1
loadtime:1.0141611099243 / seconds
Query Executed:select id FROM `va` where city='Barren Springs' && SIC_code='0742'DB:business_master_new
loadtime:1.0165770053864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baskerville' limit 1
loadtime:1.0166211128235 / seconds
Query Executed:select id FROM `va` where city='Baskerville' && SIC_code='0742'DB:business_master_new
loadtime:1.0261099338531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:1.0261480808258 / seconds
Query Executed:select id FROM `va` where city='Bassett' && SIC_code='0742'DB:business_master_new
loadtime:1.0269999504089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bastian' limit 1
loadtime:1.0270309448242 / seconds
Query Executed:select id FROM `va` where city='Bastian' && SIC_code='0742'DB:business_master_new
loadtime:1.0385739803314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basye' limit 1
loadtime:1.0386140346527 / seconds
Query Executed:select id FROM `va` where city='Basye' && SIC_code='0742'DB:business_master_new
loadtime:1.0580871105194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:1.0581340789795 / seconds
Query Executed:select id FROM `va` where city='Batesville' && SIC_code='0742'DB:business_master_new
loadtime:1.0619051456451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battery Park' limit 1
loadtime:1.0619549751282 / seconds
Query Executed:select id FROM `va` where city='Battery Park' && SIC_code='0742'DB:business_master_new
loadtime:1.0643711090088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bavon' limit 1
loadtime:1.0644159317017 / seconds
Query Executed:select id FROM `va` where city='Bavon' && SIC_code='0742'DB:business_master_new
loadtime:1.0648920536041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bealeton' limit 1
loadtime:1.0649390220642 / seconds
Query Executed:select id FROM `va` where city='Bealeton' && SIC_code='0742'DB:business_master_new
loadtime:1.0656540393829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:1.0657050609589 / seconds
Query Executed:select id FROM `va` where city='Beaumont' && SIC_code='0742'DB:business_master_new
loadtime:1.0672690868378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverdam' limit 1
loadtime:1.0673060417175 / seconds
Query Executed:select id FROM `va` where city='Beaverdam' && SIC_code='0742'DB:business_master_new
loadtime:1.0679950714111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverlett' limit 1
loadtime:1.0680379867554 / seconds
Query Executed:select id FROM `va` where city='Beaverlett' && SIC_code='0742'DB:business_master_new
loadtime:1.0685701370239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:1.0686020851135 / seconds
Query Executed:select id FROM `va` where city='Bedford' && SIC_code='0742'DB:business_master_new
loadtime:1.0697300434113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bee' limit 1
loadtime:1.0697801113129 / seconds
Query Executed:select id FROM `va` where city='Bee' && SIC_code='0742'DB:business_master_new
loadtime:1.0721471309662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellamy' limit 1
loadtime:1.0721819400787 / seconds
Query Executed:select id FROM `va` where city='Bellamy' && SIC_code='0742'DB:business_master_new
loadtime:1.0724499225616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Haven' limit 1
loadtime:1.0725009441376 / seconds
Query Executed:select id FROM `va` where city='Belle Haven' && SIC_code='0742'DB:business_master_new
loadtime:1.0731511116028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belspring' limit 1
loadtime:1.0731790065765 / seconds
Query Executed:select id FROM `va` where city='Belspring' && SIC_code='0742'DB:business_master_new
loadtime:1.0749881267548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ben Hur' limit 1
loadtime:1.0750319957733 / seconds
Query Executed:select id FROM `va` where city='Ben Hur' && SIC_code='0742'DB:business_master_new
loadtime:1.0787799358368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bena' limit 1
loadtime:1.0788171291351 / seconds
Query Executed:select id FROM `va` where city='Bena' && SIC_code='0742'DB:business_master_new
loadtime:1.0845279693604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bent Mountain' limit 1
loadtime:1.0845611095428 / seconds
Query Executed:select id FROM `va` where city='Bent Mountain' && SIC_code='0742'DB:business_master_new
loadtime:1.1019201278687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonville' limit 1
loadtime:1.1019661426544 / seconds
Query Executed:select id FROM `va` where city='Bentonville' && SIC_code='0742'DB:business_master_new
loadtime:1.1240699291229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergton' limit 1
loadtime:1.1241230964661 / seconds
Query Executed:select id FROM `va` where city='Bergton' && SIC_code='0742'DB:business_master_new
loadtime:1.1319401264191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berryville' limit 1
loadtime:1.1319980621338 / seconds
Query Executed:select id FROM `va` where city='Berryville' && SIC_code='0742'DB:business_master_new
loadtime:1.1329419612885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Island' limit 1
loadtime:1.1330001354218 / seconds
Query Executed:select id FROM `va` where city='Big Island' && SIC_code='0742'DB:business_master_new
loadtime:1.1540801525116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:1.1541330814362 / seconds
Query Executed:select id FROM `va` where city='Big Rock' && SIC_code='0742'DB:business_master_new
loadtime:1.1661441326141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone Gap' limit 1
loadtime:1.1661999225616 / seconds
Query Executed:select id FROM `va` where city='Big Stone Gap' && SIC_code='0742'DB:business_master_new
loadtime:1.1670660972595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchleaf' limit 1
loadtime:1.1671090126038 / seconds
Query Executed:select id FROM `va` where city='Birchleaf' && SIC_code='0742'DB:business_master_new
loadtime:1.1731810569763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birdsnest' limit 1
loadtime:1.1732349395752 / seconds
Query Executed:select id FROM `va` where city='Birdsnest' && SIC_code='0742'DB:business_master_new
loadtime:1.1787650585175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bishop' limit 1
loadtime:1.1788139343262 / seconds
Query Executed:select id FROM `va` where city='Bishop' && SIC_code='0742'DB:business_master_new
loadtime:1.1816821098328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackridge' limit 1
loadtime:1.1817231178284 / seconds
Query Executed:select id FROM `va` where city='Blackridge' && SIC_code='0742'DB:business_master_new
loadtime:1.1831939220428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blacksburg' limit 1
loadtime:1.1832430362701 / seconds
Query Executed:select id FROM `va` where city='Blacksburg' && SIC_code='0742'DB:business_master_new
loadtime:1.1847951412201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:1.1848559379578 / seconds
Query Executed:select id FROM `va` where city='Blackstone' && SIC_code='0742'DB:business_master_new
loadtime:1.1857280731201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwater' limit 1
loadtime:1.1857800483704 / seconds
Query Executed:select id FROM `va` where city='Blackwater' && SIC_code='0742'DB:business_master_new
loadtime:1.1908669471741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairs' limit 1
loadtime:1.1909329891205 / seconds
Query Executed:select id FROM `va` where city='Blairs' && SIC_code='0742'DB:business_master_new
loadtime:1.1916379928589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakes' limit 1
loadtime:1.1916790008545 / seconds
Query Executed:select id FROM `va` where city='Blakes' && SIC_code='0742'DB:business_master_new
loadtime:1.1919310092926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bland' limit 1
loadtime:1.191997051239 / seconds
Query Executed:select id FROM `va` where city='Bland' && SIC_code='0742'DB:business_master_new
loadtime:1.192656993866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloxom' limit 1
loadtime:1.1927161216736 / seconds
Query Executed:select id FROM `va` where city='Bloxom' && SIC_code='0742'DB:business_master_new
loadtime:1.2067749500275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:1.2068099975586 / seconds
Query Executed:select id FROM `va` where city='Blue Grass' && SIC_code='0742'DB:business_master_new
loadtime:1.2134990692139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Ridge' limit 1
loadtime:1.2135500907898 / seconds
Query Executed:select id FROM `va` where city='Blue Ridge' && SIC_code='0742'DB:business_master_new
loadtime:1.214271068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluefield' limit 1
loadtime:1.2143239974976 / seconds
Query Executed:select id FROM `va` where city='Bluefield' && SIC_code='0742'DB:business_master_new
loadtime:1.2151660919189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluemont' limit 1
loadtime:1.2152171134949 / seconds
Query Executed:select id FROM `va` where city='Bluemont' && SIC_code='0742'DB:business_master_new
loadtime:1.2158899307251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bohannon' limit 1
loadtime:1.2159731388092 / seconds
Query Executed:select id FROM `va` where city='Bohannon' && SIC_code='0742'DB:business_master_new
loadtime:1.2181160449982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boissevain' limit 1
loadtime:1.2181940078735 / seconds
Query Executed:select id FROM `va` where city='Boissevain' && SIC_code='0742'DB:business_master_new
loadtime:1.2224991321564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolar' limit 1
loadtime:1.2225451469421 / seconds
Query Executed:select id FROM `va` where city='Bolar' && SIC_code='0742'DB:business_master_new
loadtime:1.2235140800476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:1.2235660552979 / seconds
Query Executed:select id FROM `va` where city='Bon Air' && SIC_code='0742'DB:business_master_new
loadtime:1.2265031337738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boones Mill' limit 1
loadtime:1.2265450954437 / seconds
Query Executed:select id FROM `va` where city='Boones Mill' && SIC_code='0742'DB:business_master_new
loadtime:1.2273020744324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:1.2273559570312 / seconds
Query Executed:select id FROM `va` where city='Boston' && SIC_code='0742'DB:business_master_new
loadtime:1.2366709709167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowling Green' limit 1
loadtime:1.236720085144 / seconds
Query Executed:select id FROM `va` where city='Bowling Green' && SIC_code='0742'DB:business_master_new
loadtime:1.2378549575806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyce' limit 1
loadtime:1.2379839420319 / seconds
Query Executed:select id FROM `va` where city='Boyce' && SIC_code='0742'DB:business_master_new
loadtime:1.2390739917755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boydton' limit 1
loadtime:1.2391259670258 / seconds
Query Executed:select id FROM `va` where city='Boydton' && SIC_code='0742'DB:business_master_new
loadtime:1.2403120994568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykins' limit 1
loadtime:1.2403969764709 / seconds
Query Executed:select id FROM `va` where city='Boykins' && SIC_code='0742'DB:business_master_new
loadtime:1.241012096405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bracey' limit 1
loadtime:1.2410569190979 / seconds
Query Executed:select id FROM `va` where city='Bracey' && SIC_code='0742'DB:business_master_new
loadtime:1.241730928421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:1.2417891025543 / seconds
Query Executed:select id FROM `va` where city='Branchville' && SIC_code='0742'DB:business_master_new
loadtime:1.2485239505768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandy Station' limit 1
loadtime:1.248603105545 / seconds
Query Executed:select id FROM `va` where city='Brandy Station' && SIC_code='0742'DB:business_master_new
loadtime:1.2710709571838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breaks' limit 1
loadtime:1.2711279392242 / seconds
Query Executed:select id FROM `va` where city='Breaks' && SIC_code='0742'DB:business_master_new
loadtime:1.2750151157379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremo Bluff' limit 1
loadtime:1.2750689983368 / seconds
Query Executed:select id FROM `va` where city='Bremo Bluff' && SIC_code='0742'DB:business_master_new
loadtime:1.2802369594574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:1.2802901268005 / seconds
Query Executed:select id FROM `va` where city='Bridgewater' && SIC_code='0742'DB:business_master_new
loadtime:1.2810361385345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brightwood' limit 1
loadtime:1.2810900211334 / seconds
Query Executed:select id FROM `va` where city='Brightwood' && SIC_code='0742'DB:business_master_new
loadtime:1.2929530143738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:1.293004989624 / seconds
Query Executed:select id FROM `va` where city='Bristol' && SIC_code='0742'DB:business_master_new
loadtime:1.2942879199982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:1.2943451404572 / seconds
Query Executed:select id FROM `va` where city='Bristow' && SIC_code='0742'DB:business_master_new
loadtime:1.2950930595398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Run' limit 1
loadtime:1.2951591014862 / seconds
Query Executed:select id FROM `va` where city='Broad Run' && SIC_code='0742'DB:business_master_new
loadtime:1.2957890033722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadford' limit 1
loadtime:1.2958319187164 / seconds
Query Executed:select id FROM `va` where city='Broadford' && SIC_code='0742'DB:business_master_new
loadtime:1.2988860607147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:1.2989499568939 / seconds
Query Executed:select id FROM `va` where city='Broadway' && SIC_code='0742'DB:business_master_new
loadtime:1.2997231483459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodnax' limit 1
loadtime:1.2997679710388 / seconds
Query Executed:select id FROM `va` where city='Brodnax' && SIC_code='0742'DB:business_master_new
loadtime:1.3006010055542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooke' limit 1
loadtime:1.3006749153137 / seconds
Query Executed:select id FROM `va` where city='Brooke' && SIC_code='0742'DB:business_master_new
loadtime:1.3040249347687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookneal' limit 1
loadtime:1.3040730953217 / seconds
Query Executed:select id FROM `va` where city='Brookneal' && SIC_code='0742'DB:business_master_new
loadtime:1.3047931194305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsburg' limit 1
loadtime:1.304829120636 / seconds
Query Executed:select id FROM `va` where city='Brownsburg' && SIC_code='0742'DB:business_master_new
loadtime:1.3063910007477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brucetown' limit 1
loadtime:1.306440114975 / seconds
Query Executed:select id FROM `va` where city='Brucetown' && SIC_code='0742'DB:business_master_new
loadtime:1.3068559169769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruington' limit 1
loadtime:1.3069491386414 / seconds
Query Executed:select id FROM `va` where city='Bruington' && SIC_code='0742'DB:business_master_new
loadtime:1.3090350627899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:1.3090951442719 / seconds
Query Executed:select id FROM `va` where city='Buchanan' && SIC_code='0742'DB:business_master_new
loadtime:1.3103449344635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:1.3104500770569 / seconds
Query Executed:select id FROM `va` where city='Buckingham' && SIC_code='0742'DB:business_master_new
loadtime:1.3115849494934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena Vista' limit 1
loadtime:1.3116760253906 / seconds
Query Executed:select id FROM `va` where city='Buena Vista' && SIC_code='0742'DB:business_master_new
loadtime:1.3130710124969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Junction' limit 1
loadtime:1.3131589889526 / seconds
Query Executed:select id FROM `va` where city='Buffalo Junction' && SIC_code='0742'DB:business_master_new
loadtime:1.3323159217834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bumpass' limit 1
loadtime:1.3323659896851 / seconds
Query Executed:select id FROM `va` where city='Bumpass' && SIC_code='0742'DB:business_master_new
loadtime:1.3330390453339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgess' limit 1
loadtime:1.3330850601196 / seconds
Query Executed:select id FROM `va` where city='Burgess' && SIC_code='0742'DB:business_master_new
loadtime:1.3337199687958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:1.3337681293488 / seconds
Query Executed:select id FROM `va` where city='Burke' && SIC_code='0742'DB:business_master_new
loadtime:1.335077047348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkes Garden' limit 1
loadtime:1.3351449966431 / seconds
Query Executed:select id FROM `va` where city='Burkes Garden' && SIC_code='0742'DB:business_master_new
loadtime:1.3375470638275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkeville' limit 1
loadtime:1.3376131057739 / seconds
Query Executed:select id FROM `va` where city='Burkeville' && SIC_code='0742'DB:business_master_new
loadtime:1.3382740020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:1.3383281230927 / seconds
Query Executed:select id FROM `va` where city='Burnsville' && SIC_code='0742'DB:business_master_new
loadtime:1.340371131897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Hill' limit 1
loadtime:1.3404150009155 / seconds
Query Executed:select id FROM `va` where city='Burr Hill' && SIC_code='0742'DB:business_master_new
loadtime:1.3423271179199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callands' limit 1
loadtime:1.3423790931702 / seconds
Query Executed:select id FROM `va` where city='Callands' && SIC_code='0742'DB:business_master_new
loadtime:1.3571600914001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callao' limit 1
loadtime:1.3571951389313 / seconds
Query Executed:select id FROM `va` where city='Callao' && SIC_code='0742'DB:business_master_new
loadtime:1.3578979969025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callaway' limit 1
loadtime:1.3579530715942 / seconds
Query Executed:select id FROM `va` where city='Callaway' && SIC_code='0742'DB:business_master_new
loadtime:1.3783841133118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calverton' limit 1
loadtime:1.3784260749817 / seconds
Query Executed:select id FROM `va` where city='Calverton' && SIC_code='0742'DB:business_master_new
loadtime:1.3888080120087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cana' limit 1
loadtime:1.3888580799103 / seconds
Query Executed:select id FROM `va` where city='Cana' && SIC_code='0742'DB:business_master_new
loadtime:1.3895421028137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Charles' limit 1
loadtime:1.389585018158 / seconds
Query Executed:select id FROM `va` where city='Cape Charles' && SIC_code='0742'DB:business_master_new
loadtime:1.3903329372406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capeville' limit 1
loadtime:1.3903679847717 / seconds
Query Executed:select id FROM `va` where city='Capeville' && SIC_code='0742'DB:business_master_new
loadtime:1.3915390968323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capron' limit 1
loadtime:1.3915989398956 / seconds
Query Executed:select id FROM `va` where city='Capron' && SIC_code='0742'DB:business_master_new
loadtime:1.4133570194244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardinal' limit 1
loadtime:1.4134020805359 / seconds
Query Executed:select id FROM `va` where city='Cardinal' && SIC_code='0742'DB:business_master_new
loadtime:1.4166231155396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caret' limit 1
loadtime:1.4166550636292 / seconds
Query Executed:select id FROM `va` where city='Caret' && SIC_code='0742'DB:business_master_new
loadtime:1.4202511310577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:1.4202921390533 / seconds
Query Executed:select id FROM `va` where city='Carrollton' && SIC_code='0742'DB:business_master_new
loadtime:1.4209771156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrsville' limit 1
loadtime:1.4210140705109 / seconds
Query Executed:select id FROM `va` where city='Carrsville' && SIC_code='0742'DB:business_master_new
loadtime:1.4355001449585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:1.4355361461639 / seconds
Query Executed:select id FROM `va` where city='Carson' && SIC_code='0742'DB:business_master_new
loadtime:1.4494659900665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cartersville' limit 1
loadtime:1.4495129585266 / seconds
Query Executed:select id FROM `va` where city='Cartersville' && SIC_code='0742'DB:business_master_new
loadtime:1.4613790512085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casanova' limit 1
loadtime:1.4614191055298 / seconds
Query Executed:select id FROM `va` where city='Casanova' && SIC_code='0742'DB:business_master_new
loadtime:1.4667689800262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:1.4668290615082 / seconds
Query Executed:select id FROM `va` where city='Cascade' && SIC_code='0742'DB:business_master_new
loadtime:1.4828491210938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleton' limit 1
loadtime:1.482901096344 / seconds
Query Executed:select id FROM `va` where city='Castleton' && SIC_code='0742'DB:business_master_new
loadtime:1.4922370910645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:1.4922840595245 / seconds
Query Executed:select id FROM `va` where city='Castlewood' && SIC_code='0742'DB:business_master_new
loadtime:1.4929809570312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:1.4930229187012 / seconds
Query Executed:select id FROM `va` where city='Catawba' && SIC_code='0742'DB:business_master_new
loadtime:1.5038969516754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharpin' limit 1
loadtime:1.5039479732513 / seconds
Query Executed:select id FROM `va` where city='Catharpin' && SIC_code='0742'DB:business_master_new
loadtime:1.5045840740204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catlett' limit 1
loadtime:1.5046229362488 / seconds
Query Executed:select id FROM `va` where city='Catlett' && SIC_code='0742'DB:business_master_new
loadtime:1.5053160190582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:1.5053660869598 / seconds
Query Executed:select id FROM `va` where city='Cedar Bluff' && SIC_code='0742'DB:business_master_new
loadtime:1.5061039924622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Cross' limit 1
loadtime:1.5061430931091 / seconds
Query Executed:select id FROM `va` where city='Center Cross' && SIC_code='0742'DB:business_master_new
loadtime:1.5135390758514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:1.5135841369629 / seconds
Query Executed:select id FROM `va` where city='Centreville' && SIC_code='0742'DB:business_master_new
loadtime:1.5150420665741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceres' limit 1
loadtime:1.5150940418243 / seconds
Query Executed:select id FROM `va` where city='Ceres' && SIC_code='0742'DB:business_master_new
loadtime:1.5214800834656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champlain' limit 1
loadtime:1.5215239524841 / seconds
Query Executed:select id FROM `va` where city='Champlain' && SIC_code='0742'DB:business_master_new
loadtime:1.5273299217224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chantilly' limit 1
loadtime:1.5273671150208 / seconds
Query Executed:select id FROM `va` where city='Chantilly' && SIC_code='0742'DB:business_master_new
loadtime:1.529107093811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:1.5291569232941 / seconds
Query Executed:select id FROM `va` where city='Charles City' && SIC_code='0742'DB:business_master_new
loadtime:1.5298490524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Court House' limit 1
loadtime:1.5298781394958 / seconds
Query Executed:select id FROM `va` where city='Charlotte Court House' && SIC_code='0742'DB:business_master_new
loadtime:1.5305559635162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte Ct Hse' limit 1
loadtime:1.5305979251862 / seconds
Query Executed:select id FROM `va` where city='Charlotte Ct Hse' && SIC_code='0742'DB:business_master_new
loadtime:1.5391080379486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlottesville' limit 1
loadtime:1.5391509532928 / seconds
Query Executed:select id FROM `va` where city='Charlottesville' && SIC_code='0742'DB:business_master_new
loadtime:1.5491261482239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase City' limit 1
loadtime:1.5492780208588 / seconds
Query Executed:select id FROM `va` where city='Chase City' && SIC_code='0742'DB:business_master_new
loadtime:1.5514919757843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.551628112793 / seconds
Query Executed:select id FROM `va` where city='Chatham' && SIC_code='0742'DB:business_master_new
loadtime:1.5527410507202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Check' limit 1
loadtime:1.5527930259705 / seconds
Query Executed:select id FROM `va` where city='Check' && SIC_code='0742'DB:business_master_new
loadtime:1.5660750865936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheriton' limit 1
loadtime:1.5661201477051 / seconds
Query Executed:select id FROM `va` where city='Cheriton' && SIC_code='0742'DB:business_master_new
loadtime:1.5901191234589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesapeake' limit 1
loadtime:1.5901651382446 / seconds
Query Executed:select id FROM `va` where city='Chesapeake' && SIC_code='0742'DB:business_master_new
loadtime:1.5989739894867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.5990419387817 / seconds
Query Executed:select id FROM `va` where city='Chester' && SIC_code='0742'DB:business_master_new
loadtime:1.6003980636597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester Gap' limit 1
loadtime:1.6004600524902 / seconds
Query Executed:select id FROM `va` where city='Chester Gap' && SIC_code='0742'DB:business_master_new
loadtime:1.6042540073395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.604306936264 / seconds
Query Executed:select id FROM `va` where city='Chesterfield' && SIC_code='0742'DB:business_master_new
loadtime:1.6055629253387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilhowie' limit 1
loadtime:1.6056079864502 / seconds
Query Executed:select id FROM `va` where city='Chilhowie' && SIC_code='0742'DB:business_master_new
loadtime:1.6063959598541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague' limit 1
loadtime:1.6064689159393 / seconds
Query Executed:select id FROM `va` where city='Chincoteague' && SIC_code='0742'DB:business_master_new
loadtime:1.614963054657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chincoteague Island' limit 1
loadtime:1.6150031089783 / seconds
Query Executed:select id FROM `va` where city='Chincoteague Island' && SIC_code='0742'DB:business_master_new
loadtime:1.6157789230347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christchurch' limit 1
loadtime:1.6158230304718 / seconds
Query Executed:select id FROM `va` where city='Christchurch' && SIC_code='0742'DB:business_master_new
loadtime:1.6171469688416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christiansburg' limit 1
loadtime:1.6171879768372 / seconds
Query Executed:select id FROM `va` where city='Christiansburg' && SIC_code='0742'DB:business_master_new
loadtime:1.6185641288757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church Road' limit 1
loadtime:1.6186151504517 / seconds
Query Executed:select id FROM `va` where city='Church Road' && SIC_code='0742'DB:business_master_new
loadtime:1.6364591121674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Church View' limit 1
loadtime:1.6365120410919 / seconds
Query Executed:select id FROM `va` where city='Church View' && SIC_code='0742'DB:business_master_new
loadtime:1.6410090923309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churchville' limit 1
loadtime:1.6410620212555 / seconds
Query Executed:select id FROM `va` where city='Churchville' && SIC_code='0742'DB:business_master_new
loadtime:1.6417241096497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cismont' limit 1
loadtime:1.6417701244354 / seconds
Query Executed:select id FROM `va` where city='Cismont' && SIC_code='0742'DB:business_master_new
loadtime:1.6423151493073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:1.6423659324646 / seconds
Query Executed:select id FROM `va` where city='Claremont' && SIC_code='0742'DB:business_master_new
loadtime:1.6498410701752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:1.6498930454254 / seconds
Query Executed:select id FROM `va` where city='Clarksville' && SIC_code='0742'DB:business_master_new
loadtime:1.6507239341736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claudville' limit 1
loadtime:1.6507720947266 / seconds
Query Executed:select id FROM `va` where city='Claudville' && SIC_code='0742'DB:business_master_new
loadtime:1.6680641174316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Brook' limit 1
loadtime:1.6681160926819 / seconds
Query Executed:select id FROM `va` where city='Clear Brook' && SIC_code='0742'DB:business_master_new
loadtime:1.6688270568848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:1.6688799858093 / seconds
Query Executed:select id FROM `va` where city='Cleveland' && SIC_code='0742'DB:business_master_new
loadtime:1.6769540309906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:1.676990032196 / seconds
Query Executed:select id FROM `va` where city='Clifford' && SIC_code='0742'DB:business_master_new
loadtime:1.6783490180969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.6783969402313 / seconds
Query Executed:select id FROM `va` where city='Clifton' && SIC_code='0742'DB:business_master_new
loadtime:1.6793310642242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton Forge' limit 1
loadtime:1.6793899536133 / seconds
Query Executed:select id FROM `va` where city='Clifton Forge' && SIC_code='0742'DB:business_master_new
loadtime:1.6801500320435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchco' limit 1
loadtime:1.6801929473877 / seconds
Query Executed:select id FROM `va` where city='Clinchco' && SIC_code='0742'DB:business_master_new
loadtime:1.6902101039886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinchport' limit 1
loadtime:1.6902599334717 / seconds
Query Executed:select id FROM `va` where city='Clinchport' && SIC_code='0742'DB:business_master_new
loadtime:1.6927161216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintwood' limit 1
loadtime:1.692773103714 / seconds
Query Executed:select id FROM `va` where city='Clintwood' && SIC_code='0742'DB:business_master_new
loadtime:1.6935470104218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clover' limit 1
loadtime:1.6935830116272 / seconds
Query Executed:select id FROM `va` where city='Clover' && SIC_code='0742'DB:business_master_new
loadtime:1.7077860832214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:1.7078349590302 / seconds
Query Executed:select id FROM `va` where city='Cloverdale' && SIC_code='0742'DB:business_master_new
loadtime:1.7084929943085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cluster Springs' limit 1
loadtime:1.7085361480713 / seconds
Query Executed:select id FROM `va` where city='Cluster Springs' && SIC_code='0742'DB:business_master_new
loadtime:1.7092161178589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobbs Creek' limit 1
loadtime:1.7092499732971 / seconds
Query Executed:select id FROM `va` where city='Cobbs Creek' && SIC_code='0742'DB:business_master_new
loadtime:1.7232151031494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobham' limit 1
loadtime:1.7232761383057 / seconds
Query Executed:select id FROM `va` where city='Cobham' && SIC_code='0742'DB:business_master_new
loadtime:1.7237751483917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coeburn' limit 1
loadtime:1.7238111495972 / seconds
Query Executed:select id FROM `va` where city='Coeburn' && SIC_code='0742'DB:business_master_new
loadtime:1.7246029376984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman Falls' limit 1
loadtime:1.7246530056 / seconds
Query Executed:select id FROM `va` where city='Coleman Falls' && SIC_code='0742'DB:business_master_new
loadtime:1.7264490127563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coles Point' limit 1
loadtime:1.7264840602875 / seconds
Query Executed:select id FROM `va` where city='Coles Point' && SIC_code='0742'DB:business_master_new
loadtime:1.7290999889374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:1.7291431427002 / seconds
Query Executed:select id FROM `va` where city='Collinsville' && SIC_code='0742'DB:business_master_new
loadtime:1.7299830913544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:1.7300369739532 / seconds
Query Executed:select id FROM `va` where city='Cologne' && SIC_code='0742'DB:business_master_new
loadtime:1.7305290699005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Beach' limit 1
loadtime:1.7305669784546 / seconds
Query Executed:select id FROM `va` where city='Colonial Beach' && SIC_code='0742'DB:business_master_new
loadtime:1.7313959598541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonial Heights' limit 1
loadtime:1.7314460277557 / seconds
Query Executed:select id FROM `va` where city='Colonial Heights' && SIC_code='0742'DB:business_master_new
loadtime:1.7327370643616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:1.732794046402 / seconds
Query Executed:select id FROM `va` where city='Columbia' && SIC_code='0742'DB:business_master_new
loadtime:1.7469561100006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conaway' limit 1
loadtime:1.7470049858093 / seconds
Query Executed:select id FROM `va` where city='Conaway' && SIC_code='0742'DB:business_master_new
loadtime:1.7475090026855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:1.7475509643555 / seconds
Query Executed:select id FROM `va` where city='Concord' && SIC_code='0742'DB:business_master_new
loadtime:1.7482600212097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Hill' limit 1
loadtime:1.7483060359955 / seconds
Query Executed:select id FROM `va` where city='Copper Hill' && SIC_code='0742'DB:business_master_new
loadtime:1.7616560459137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin' limit 1
loadtime:1.7617080211639 / seconds
Query Executed:select id FROM `va` where city='Corbin' && SIC_code='0742'DB:business_master_new
loadtime:1.7653050422668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:1.7653429508209 / seconds
Query Executed:select id FROM `va` where city='Council' && SIC_code='0742'DB:business_master_new
loadtime:1.7669439315796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:1.7669811248779 / seconds
Query Executed:select id FROM `va` where city='Courtland' && SIC_code='0742'DB:business_master_new
loadtime:1.7676651477814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covesville' limit 1
loadtime:1.7676961421967 / seconds
Query Executed:select id FROM `va` where city='Covesville' && SIC_code='0742'DB:business_master_new
loadtime:1.7748849391937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:1.7749359607697 / seconds
Query Executed:select id FROM `va` where city='Covington' && SIC_code='0742'DB:business_master_new
loadtime:1.7759821414948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craddockville' limit 1
loadtime:1.7760350704193 / seconds
Query Executed:select id FROM `va` where city='Craddockville' && SIC_code='0742'DB:business_master_new
loadtime:1.7784719467163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Craigsville' limit 1
loadtime:1.7785029411316 / seconds
Query Executed:select id FROM `va` where city='Craigsville' && SIC_code='0742'DB:business_master_new
loadtime:1.7902729511261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crewe' limit 1
loadtime:1.7903110980988 / seconds
Query Executed:select id FROM `va` where city='Crewe' && SIC_code='0742'DB:business_master_new
loadtime:1.7910571098328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criders' limit 1
loadtime:1.7911040782928 / seconds
Query Executed:select id FROM `va` where city='Criders' && SIC_code='0742'DB:business_master_new
loadtime:1.7939889431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Criglersville' limit 1
loadtime:1.7940270900726 / seconds
Query Executed:select id FROM `va` where city='Criglersville' && SIC_code='0742'DB:business_master_new
loadtime:1.7944729328156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crimora' limit 1
loadtime:1.794508934021 / seconds
Query Executed:select id FROM `va` where city='Crimora' && SIC_code='0742'DB:business_master_new
loadtime:1.8108279705048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cripple Creek' limit 1
loadtime:1.8108661174774 / seconds
Query Executed:select id FROM `va` where city='Cripple Creek' && SIC_code='0742'DB:business_master_new
loadtime:1.8119671344757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Critz' limit 1
loadtime:1.8119990825653 / seconds
Query Executed:select id FROM `va` where city='Critz' && SIC_code='0742'DB:business_master_new
loadtime:1.8166069984436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crockett' limit 1
loadtime:1.8166401386261 / seconds
Query Executed:select id FROM `va` where city='Crockett' && SIC_code='0742'DB:business_master_new
loadtime:1.8224020004272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Junction' limit 1
loadtime:1.8224411010742 / seconds
Query Executed:select id FROM `va` where city='Cross Junction' && SIC_code='0742'DB:business_master_new
loadtime:1.8230791091919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozet' limit 1
loadtime:1.8231120109558 / seconds
Query Executed:select id FROM `va` where city='Crozet' && SIC_code='0742'DB:business_master_new
loadtime:1.8238661289215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crozier' limit 1
loadtime:1.8239190578461 / seconds
Query Executed:select id FROM `va` where city='Crozier' && SIC_code='0742'DB:business_master_new
loadtime:1.8411290645599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Hill' limit 1
loadtime:1.8411679267883 / seconds
Query Executed:select id FROM `va` where city='Crystal Hill' && SIC_code='0742'DB:business_master_new
loadtime:1.8450090885162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullen' limit 1
loadtime:1.8450450897217 / seconds
Query Executed:select id FROM `va` where city='Cullen' && SIC_code='0742'DB:business_master_new
loadtime:1.8568470478058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culpeper' limit 1
loadtime:1.8568930625916 / seconds
Query Executed:select id FROM `va` where city='Culpeper' && SIC_code='0742'DB:business_master_new
loadtime:1.8585109710693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:1.8585541248322 / seconds
Query Executed:select id FROM `va` where city='Cumberland' && SIC_code='0742'DB:business_master_new
loadtime:1.8592391014099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dahlgren' limit 1
loadtime:1.8592801094055 / seconds
Query Executed:select id FROM `va` where city='Dahlgren' && SIC_code='0742'DB:business_master_new
loadtime:1.8599030971527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale City' limit 1
loadtime:1.8599390983582 / seconds
Query Executed:select id FROM `va` where city='Dale City' && SIC_code='0742'DB:business_master_new
loadtime:1.8687529563904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:1.8687920570374 / seconds
Query Executed:select id FROM `va` where city='Daleville' && SIC_code='0742'DB:business_master_new
loadtime:1.8695349693298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damascus' limit 1
loadtime:1.8695781230927 / seconds
Query Executed:select id FROM `va` where city='Damascus' && SIC_code='0742'DB:business_master_new
loadtime:1.870255947113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:1.8702900409698 / seconds
Query Executed:select id FROM `va` where city='Dante' && SIC_code='0742'DB:business_master_new
loadtime:1.8764541149139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:1.8764901161194 / seconds
Query Executed:select id FROM `va` where city='Danville' && SIC_code='0742'DB:business_master_new
loadtime:1.8784470558167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington Hts' limit 1
loadtime:1.8784909248352 / seconds
Query Executed:select id FROM `va` where city='Darlington Hts' && SIC_code='0742'DB:business_master_new
loadtime:1.87873005867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:1.8787651062012 / seconds
Query Executed:select id FROM `va` where city='Davenport' && SIC_code='0742'DB:business_master_new
loadtime:1.8846480846405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Wharf' limit 1
loadtime:1.8846781253815 / seconds
Query Executed:select id FROM `va` where city='Davis Wharf' && SIC_code='0742'DB:business_master_new
loadtime:1.8849301338196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:1.8849639892578 / seconds
Query Executed:select id FROM `va` where city='Dayton' && SIC_code='0742'DB:business_master_new
loadtime:1.8857100009918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:1.8857491016388 / seconds
Query Executed:select id FROM `va` where city='Deerfield' && SIC_code='0742'DB:business_master_new
loadtime:1.8907129764557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaplane' limit 1
loadtime:1.8907489776611 / seconds
Query Executed:select id FROM `va` where city='Delaplane' && SIC_code='0742'DB:business_master_new
loadtime:1.9075391292572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deltaville' limit 1
loadtime:1.9075739383698 / seconds
Query Executed:select id FROM `va` where city='Deltaville' && SIC_code='0742'DB:business_master_new
loadtime:1.9082689285278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dendron' limit 1
loadtime:1.9083070755005 / seconds
Query Executed:select id FROM `va` where city='Dendron' && SIC_code='0742'DB:business_master_new
loadtime:1.9162700176239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:1.916314125061 / seconds
Query Executed:select id FROM `va` where city='Dewitt' && SIC_code='0742'DB:business_master_new
loadtime:1.9268629550934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diggs' limit 1
loadtime:1.9269020557404 / seconds
Query Executed:select id FROM `va` where city='Diggs' && SIC_code='0742'DB:business_master_new
loadtime:1.9284639358521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillwyn' limit 1
loadtime:1.9285039901733 / seconds
Query Executed:select id FROM `va` where city='Dillwyn' && SIC_code='0742'DB:business_master_new
loadtime:1.9292249679565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dinwiddie' limit 1
loadtime:1.9292681217194 / seconds
Query Executed:select id FROM `va` where city='Dinwiddie' && SIC_code='0742'DB:business_master_new
loadtime:1.9299530982971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Disputanta' limit 1
loadtime:1.9299881458282 / seconds
Query Executed:select id FROM `va` where city='Disputanta' && SIC_code='0742'DB:business_master_new
loadtime:1.9306480884552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doe Hill' limit 1
loadtime:1.9306919574738 / seconds
Query Executed:select id FROM `va` where city='Doe Hill' && SIC_code='0742'DB:business_master_new
loadtime:1.9333479404449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dogue' limit 1
loadtime:1.9333779811859 / seconds
Query Executed:select id FROM `va` where city='Dogue' && SIC_code='0742'DB:business_master_new
loadtime:1.9346849918365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolphin' limit 1
loadtime:1.9347231388092 / seconds
Query Executed:select id FROM `va` where city='Dolphin' && SIC_code='0742'DB:business_master_new
loadtime:1.9396860599518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doran' limit 1
loadtime:1.9397299289703 / seconds
Query Executed:select id FROM `va` where city='Doran' && SIC_code='0742'DB:business_master_new
loadtime:1.9483821392059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doswell' limit 1
loadtime:1.9484131336212 / seconds
Query Executed:select id FROM `va` where city='Doswell' && SIC_code='0742'DB:business_master_new
loadtime:1.9490599632263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakes Branch' limit 1
loadtime:1.9491059780121 / seconds
Query Executed:select id FROM `va` where city='Drakes Branch' && SIC_code='0742'DB:business_master_new
loadtime:1.9497060775757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:1.9497439861298 / seconds
Query Executed:select id FROM `va` where city='Draper' && SIC_code='0742'DB:business_master_new
loadtime:1.9631080627441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewryville' limit 1
loadtime:1.9631569385529 / seconds
Query Executed:select id FROM `va` where city='Drewryville' && SIC_code='0742'DB:business_master_new
loadtime:1.9692749977112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dry Fork' limit 1
loadtime:1.9693150520325 / seconds
Query Executed:select id FROM `va` where city='Dry Fork' && SIC_code='0742'DB:business_master_new
loadtime:1.9699320793152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:1.9699730873108 / seconds
Query Executed:select id FROM `va` where city='Dryden' && SIC_code='0742'DB:business_master_new
loadtime:1.987133026123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:1.9871730804443 / seconds
Query Executed:select id FROM `va` where city='Dublin' && SIC_code='0742'DB:business_master_new
loadtime:1.9880340099335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duffield' limit 1
loadtime:1.9880740642548 / seconds
Query Executed:select id FROM `va` where city='Duffield' && SIC_code='0742'DB:business_master_new
loadtime:1.9887540340424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugspur' limit 1
loadtime:1.9887969493866 / seconds
Query Executed:select id FROM `va` where city='Dugspur' && SIC_code='0742'DB:business_master_new
loadtime:1.9951479434967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dulles' limit 1
loadtime:1.9951829910278 / seconds
Query Executed:select id FROM `va` where city='Dulles' && SIC_code='0742'DB:business_master_new
loadtime:2.0051250457764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumfries' limit 1
loadtime:2.0051620006561 / seconds
Query Executed:select id FROM `va` where city='Dumfries' && SIC_code='0742'DB:business_master_new
loadtime:2.006119966507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundas' limit 1
loadtime:2.0061650276184 / seconds
Query Executed:select id FROM `va` where city='Dundas' && SIC_code='0742'DB:business_master_new
loadtime:2.0103840827942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dungannon' limit 1
loadtime:2.0104191303253 / seconds
Query Executed:select id FROM `va` where city='Dungannon' && SIC_code='0742'DB:business_master_new
loadtime:2.019364118576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn Loring' limit 1
loadtime:2.01939702034 / seconds
Query Executed:select id FROM `va` where city='Dunn Loring' && SIC_code='0742'DB:business_master_new
loadtime:2.0200951099396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunnsville' limit 1
loadtime:2.0201411247253 / seconds
Query Executed:select id FROM `va` where city='Dunnsville' && SIC_code='0742'DB:business_master_new
loadtime:2.0291180610657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:2.0291519165039 / seconds
Query Executed:select id FROM `va` where city='Dutton' && SIC_code='0742'DB:business_master_new
loadtime:2.0368070602417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyke' limit 1
loadtime:2.0368430614471 / seconds
Query Executed:select id FROM `va` where city='Dyke' && SIC_code='0742'DB:business_master_new
loadtime:2.0417160987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:2.0417461395264 / seconds
Query Executed:select id FROM `va` where city='Eagle Rock' && SIC_code='0742'DB:business_master_new
loadtime:2.0540809631348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlysville' limit 1
loadtime:2.0541229248047 / seconds
Query Executed:select id FROM `va` where city='Earlysville' && SIC_code='0742'DB:business_master_new
loadtime:2.0548391342163 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Stone Gap' limit 1
loadtime:2.0548739433289 / seconds
Query Executed:select id FROM `va` where city='East Stone Gap' && SIC_code='0742'DB:business_master_new
loadtime:2.0566680431366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastville' limit 1
loadtime:2.0567059516907 / seconds
Query Executed:select id FROM `va` where city='Eastville' && SIC_code='0742'DB:business_master_new
loadtime:2.0573189258575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ebony' limit 1
loadtime:2.057354927063 / seconds
Query Executed:select id FROM `va` where city='Ebony' && SIC_code='0742'DB:business_master_new
loadtime:2.0653820037842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:2.0654201507568 / seconds
Query Executed:select id FROM `va` where city='Edinburg' && SIC_code='0742'DB:business_master_new
loadtime:2.0661880970001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:2.06623005867 / seconds
Query Executed:select id FROM `va` where city='Edwardsville' && SIC_code='0742'DB:business_master_new
loadtime:2.0664639472961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eggleston' limit 1
loadtime:2.0664970874786 / seconds
Query Executed:select id FROM `va` where city='Eggleston' && SIC_code='0742'DB:business_master_new
loadtime:2.0685720443726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:2.0686130523682 / seconds
Query Executed:select id FROM `va` where city='Elberon' && SIC_code='0742'DB:business_master_new
loadtime:2.0734441280365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Creek' limit 1
loadtime:2.0734729766846 / seconds
Query Executed:select id FROM `va` where city='Elk Creek' && SIC_code='0742'DB:business_master_new
loadtime:2.0843350887299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Garden' limit 1
loadtime:2.0843820571899 / seconds
Query Executed:select id FROM `va` where city='Elk Garden' && SIC_code='0742'DB:business_master_new
loadtime:2.0846190452576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:2.0846500396729 / seconds
Query Executed:select id FROM `va` where city='Elkton' && SIC_code='0742'DB:business_master_new
loadtime:2.0854201316833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkwood' limit 1
loadtime:2.0854439735413 / seconds
Query Executed:select id FROM `va` where city='Elkwood' && SIC_code='0742'DB:business_master_new
loadtime:2.0937089920044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliston' limit 1
loadtime:2.0937430858612 / seconds
Query Executed:select id FROM `va` where city='Elliston' && SIC_code='0742'DB:business_master_new
loadtime:2.118889093399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emory' limit 1
loadtime:2.1189379692078 / seconds
Query Executed:select id FROM `va` where city='Emory' && SIC_code='0742'DB:business_master_new
loadtime:2.1229190826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:2.12295794487 / seconds
Query Executed:select id FROM `va` where city='Emporia' && SIC_code='0742'DB:business_master_new
loadtime:2.1239061355591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engleside' limit 1
loadtime:2.1239759922028 / seconds
Query Executed:select id FROM `va` where city='Engleside' && SIC_code='0742'DB:business_master_new
loadtime:2.1274521350861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esmont' limit 1
loadtime:2.12748503685 / seconds
Query Executed:select id FROM `va` where city='Esmont' && SIC_code='0742'DB:business_master_new
loadtime:2.137069940567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etlan' limit 1
loadtime:2.1371200084686 / seconds
Query Executed:select id FROM `va` where city='Etlan' && SIC_code='0742'DB:business_master_new
loadtime:2.1397790908813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:2.1398251056671 / seconds
Query Executed:select id FROM `va` where city='Ettrick' && SIC_code='0742'DB:business_master_new
loadtime:2.1400909423828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:2.1401281356812 / seconds
Query Executed:select id FROM `va` where city='Evergreen' && SIC_code='0742'DB:business_master_new
loadtime:2.1427400112152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evington' limit 1
loadtime:2.1427760124207 / seconds
Query Executed:select id FROM `va` where city='Evington' && SIC_code='0742'DB:business_master_new
loadtime:2.1434609889984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewing' limit 1
loadtime:2.1435101032257 / seconds
Query Executed:select id FROM `va` where city='Ewing' && SIC_code='0742'DB:business_master_new
loadtime:2.1649241447449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exmore' limit 1
loadtime:2.1649799346924 / seconds
Query Executed:select id FROM `va` where city='Exmore' && SIC_code='0742'DB:business_master_new
loadtime:2.1657381057739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faber' limit 1
loadtime:2.1657700538635 / seconds
Query Executed:select id FROM `va` where city='Faber' && SIC_code='0742'DB:business_master_new
loadtime:2.1800861358643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:2.1801209449768 / seconds
Query Executed:select id FROM `va` where city='Fairfax' && SIC_code='0742'DB:business_master_new
loadtime:2.1895260810852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax Station' limit 1
loadtime:2.1895909309387 / seconds
Query Executed:select id FROM `va` where city='Fairfax Station' && SIC_code='0742'DB:business_master_new
loadtime:2.1905701160431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:2.1906161308289 / seconds
Query Executed:select id FROM `va` where city='Fairfield' && SIC_code='0742'DB:business_master_new
loadtime:2.1912641525269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairlawn' limit 1
loadtime:2.1913049221039 / seconds
Query Executed:select id FROM `va` where city='Fairlawn' && SIC_code='0742'DB:business_master_new
loadtime:2.1921679973602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Church' limit 1
loadtime:2.1921970844269 / seconds
Query Executed:select id FROM `va` where city='Falls Church' && SIC_code='0742'DB:business_master_new
loadtime:2.2008609771729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Mills' limit 1
loadtime:2.2009191513062 / seconds
Query Executed:select id FROM `va` where city='Falls Mills' && SIC_code='0742'DB:business_master_new
loadtime:2.2074210643768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:2.2074639797211 / seconds
Query Executed:select id FROM `va` where city='Falmouth' && SIC_code='0742'DB:business_master_new
loadtime:2.2081921100616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fancy Gap' limit 1
loadtime:2.2082171440125 / seconds
Query Executed:select id FROM `va` where city='Fancy Gap' && SIC_code='0742'DB:business_master_new
loadtime:2.2393870353699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:2.2394361495972 / seconds
Query Executed:select id FROM `va` where city='Farmville' && SIC_code='0742'DB:business_master_new
loadtime:2.2404980659485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnham' limit 1
loadtime:2.2405369281769 / seconds
Query Executed:select id FROM `va` where city='Farnham' && SIC_code='0742'DB:business_master_new
loadtime:2.2658350467682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrum' limit 1
loadtime:2.2659029960632 / seconds
Query Executed:select id FROM `va` where city='Ferrum' && SIC_code='0742'DB:business_master_new
loadtime:2.2666280269623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldale' limit 1
loadtime:2.2666680812836 / seconds
Query Executed:select id FROM `va` where city='Fieldale' && SIC_code='0742'DB:business_master_new
loadtime:2.2673389911652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife' limit 1
loadtime:2.2673780918121 / seconds
Query Executed:select id FROM `va` where city='Fife' && SIC_code='0742'DB:business_master_new
loadtime:2.267853975296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fincastle' limit 1
loadtime:2.2678959369659 / seconds
Query Executed:select id FROM `va` where city='Fincastle' && SIC_code='0742'DB:business_master_new
loadtime:2.2686309814453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishers Hill' limit 1
loadtime:2.2686841487885 / seconds
Query Executed:select id FROM `va` where city='Fishers Hill' && SIC_code='0742'DB:business_master_new
loadtime:2.2710399627686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fishersville' limit 1
loadtime:2.271073102951 / seconds
Query Executed:select id FROM `va` where city='Fishersville' && SIC_code='0742'DB:business_master_new
loadtime:2.2718629837036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint Hill' limit 1
loadtime:2.2719209194183 / seconds
Query Executed:select id FROM `va` where city='Flint Hill' && SIC_code='0742'DB:business_master_new
loadtime:2.2878670692444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:2.2879359722137 / seconds
Query Executed:select id FROM `va` where city='Floyd' && SIC_code='0742'DB:business_master_new
loadtime:2.2888360023499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foneswood' limit 1
loadtime:2.2888860702515 / seconds
Query Executed:select id FROM `va` where city='Foneswood' && SIC_code='0742'DB:business_master_new
loadtime:2.2891440391541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:2.2891941070557 / seconds
Query Executed:select id FROM `va` where city='Ford' && SIC_code='0742'DB:business_master_new
loadtime:2.302542924881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:2.3025860786438 / seconds
Query Executed:select id FROM `va` where city='Forest' && SIC_code='0742'DB:business_master_new
loadtime:2.3036739826202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fork Union' limit 1
loadtime:2.3037331104279 / seconds
Query Executed:select id FROM `va` where city='Fork Union' && SIC_code='0742'DB:business_master_new
loadtime:2.3227579593658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Belvoir' limit 1
loadtime:2.3228189945221 / seconds
Query Executed:select id FROM `va` where city='Fort Belvoir' && SIC_code='0742'DB:business_master_new
loadtime:2.3235449790955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Blackmore' limit 1
loadtime:2.3235769271851 / seconds
Query Executed:select id FROM `va` where city='Fort Blackmore' && SIC_code='0742'DB:business_master_new
loadtime:2.3305671215057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:2.3306181430817 / seconds
Query Executed:select id FROM `va` where city='Fort Defiance' && SIC_code='0742'DB:business_master_new
loadtime:2.338329076767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Eustis' limit 1
loadtime:2.3383729457855 / seconds
Query Executed:select id FROM `va` where city='Fort Eustis' && SIC_code='0742'DB:business_master_new
loadtime:2.3390030860901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:2.3390369415283 / seconds
Query Executed:select id FROM `va` where city='Fort Lee' && SIC_code='0742'DB:business_master_new
loadtime:2.3624539375305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:2.3625011444092 / seconds
Query Executed:select id FROM `va` where city='Fort Mitchell' && SIC_code='0742'DB:business_master_new
loadtime:2.3629851341248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monroe' limit 1
loadtime:2.3630261421204 / seconds
Query Executed:select id FROM `va` where city='Fort Monroe' && SIC_code='0742'DB:business_master_new
loadtime:2.3731880187988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Myer' limit 1
loadtime:2.37322306633 / seconds
Query Executed:select id FROM `va` where city='Fort Myer' && SIC_code='0742'DB:business_master_new
loadtime:2.3842380046844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Valley' limit 1
loadtime:2.3842890262604 / seconds
Query Executed:select id FROM `va` where city='Fort Valley' && SIC_code='0742'DB:business_master_new
loadtime:2.3979370594025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster' limit 1
loadtime:2.3979840278625 / seconds
Query Executed:select id FROM `va` where city='Foster' && SIC_code='0742'DB:business_master_new
loadtime:2.4028470516205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:2.4028861522675 / seconds
Query Executed:select id FROM `va` where city='Franconia' && SIC_code='0742'DB:business_master_new
loadtime:2.404746055603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.4047839641571 / seconds
Query Executed:select id FROM `va` where city='Franklin' && SIC_code='0742'DB:business_master_new
loadtime:2.405748128891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franktown' limit 1
loadtime:2.4057941436768 / seconds
Query Executed:select id FROM `va` where city='Franktown' && SIC_code='0742'DB:business_master_new
loadtime:2.415274143219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:2.415323972702 / seconds
Query Executed:select id FROM `va` where city='Fredericksburg' && SIC_code='0742'DB:business_master_new
loadtime:2.4247391223907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Union' limit 1
loadtime:2.4248139858246 / seconds
Query Executed:select id FROM `va` where city='Free Union' && SIC_code='0742'DB:business_master_new
loadtime:2.4387440681458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:2.4387910366058 / seconds
Query Executed:select id FROM `va` where city='Freeman' && SIC_code='0742'DB:business_master_new
loadtime:2.4465999603271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fries' limit 1
loadtime:2.4466419219971 / seconds
Query Executed:select id FROM `va` where city='Fries' && SIC_code='0742'DB:business_master_new
loadtime:2.4473440647125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Front Royal' limit 1
loadtime:2.4473991394043 / seconds
Query Executed:select id FROM `va` where city='Front Royal' && SIC_code='0742'DB:business_master_new
loadtime:2.44877409935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ft Myer' limit 1
loadtime:2.4488270282745 / seconds
Query Executed:select id FROM `va` where city='Ft Myer' && SIC_code='0742'DB:business_master_new
loadtime:2.4491019248962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulks Run' limit 1
loadtime:2.4491419792175 / seconds
Query Executed:select id FROM `va` where city='Fulks Run' && SIC_code='0742'DB:business_master_new
loadtime:2.4667410850525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:2.4667921066284 / seconds
Query Executed:select id FROM `va` where city='Gainesville' && SIC_code='0742'DB:business_master_new
loadtime:2.4677360057831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galax' limit 1
loadtime:2.4677810668945 / seconds
Query Executed:select id FROM `va` where city='Galax' && SIC_code='0742'DB:business_master_new
loadtime:2.4688560962677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrisonville' limit 1
loadtime:2.4689321517944 / seconds
Query Executed:select id FROM `va` where city='Garrisonville' && SIC_code='0742'DB:business_master_new
loadtime:2.4782569408417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gasburg' limit 1
loadtime:2.478306055069 / seconds
Query Executed:select id FROM `va` where city='Gasburg' && SIC_code='0742'DB:business_master_new
loadtime:2.4962990283966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gate City' limit 1
loadtime:2.4963610172272 / seconds
Query Executed:select id FROM `va` where city='Gate City' && SIC_code='0742'DB:business_master_new
loadtime:2.4972169399261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Hill' limit 1
loadtime:2.4972760677338 / seconds
Query Executed:select id FROM `va` where city='Glade Hill' && SIC_code='0742'DB:business_master_new
loadtime:2.4979491233826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Spring' limit 1
loadtime:2.4980010986328 / seconds
Query Executed:select id FROM `va` where city='Glade Spring' && SIC_code='0742'DB:business_master_new
loadtime:2.4987590312958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladehill' limit 1
loadtime:2.4988150596619 / seconds
Query Executed:select id FROM `va` where city='Gladehill' && SIC_code='0742'DB:business_master_new
loadtime:2.4990670681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:2.4991090297699 / seconds
Query Executed:select id FROM `va` where city='Gladstone' && SIC_code='0742'DB:business_master_new
loadtime:2.5112669467926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladys' limit 1
loadtime:2.5113101005554 / seconds
Query Executed:select id FROM `va` where city='Gladys' && SIC_code='0742'DB:business_master_new
loadtime:2.5119910240173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgow' limit 1
loadtime:2.5120470523834 / seconds
Query Executed:select id FROM `va` where city='Glasgow' && SIC_code='0742'DB:business_master_new
loadtime:2.5276210308075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:2.5277049541473 / seconds
Query Executed:select id FROM `va` where city='Glen Allen' && SIC_code='0742'DB:business_master_new
loadtime:2.5297980308533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Lyn' limit 1
loadtime:2.5298550128937 / seconds
Query Executed:select id FROM `va` where city='Glen Lyn' && SIC_code='0742'DB:business_master_new
loadtime:2.5356011390686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Wilton' limit 1
loadtime:2.5356531143188 / seconds
Query Executed:select id FROM `va` where city='Glen Wilton' && SIC_code='0742'DB:business_master_new
loadtime:2.5364520549774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:2.5364940166473 / seconds
Query Executed:select id FROM `va` where city='Gloucester' && SIC_code='0742'DB:business_master_new
loadtime:2.5375819206238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester Point' limit 1
loadtime:2.5376410484314 / seconds
Query Executed:select id FROM `va` where city='Gloucester Point' && SIC_code='0742'DB:business_master_new
loadtime:2.5383539199829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldbond' limit 1
loadtime:2.5384161472321 / seconds
Query Executed:select id FROM `va` where city='Goldbond' && SIC_code='0742'DB:business_master_new
loadtime:2.5391590595245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldvein' limit 1
loadtime:2.5391869544983 / seconds
Query Executed:select id FROM `va` where city='Goldvein' && SIC_code='0742'DB:business_master_new
loadtime:2.5469880104065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goochland' limit 1
loadtime:2.5470480918884 / seconds
Query Executed:select id FROM `va` where city='Goochland' && SIC_code='0742'DB:business_master_new
loadtime:2.5478000640869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goode' limit 1
loadtime:2.5478439331055 / seconds
Query Executed:select id FROM `va` where city='Goode' && SIC_code='0742'DB:business_master_new
loadtime:2.54851603508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodview' limit 1
loadtime:2.5485670566559 / seconds
Query Executed:select id FROM `va` where city='Goodview' && SIC_code='0742'DB:business_master_new
loadtime:2.549250125885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordonsville' limit 1
loadtime:2.5493011474609 / seconds
Query Executed:select id FROM `va` where city='Gordonsville' && SIC_code='0742'DB:business_master_new
loadtime:2.5500619411469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore' limit 1
loadtime:2.5501070022583 / seconds
Query Executed:select id FROM `va` where city='Gore' && SIC_code='0742'DB:business_master_new
loadtime:2.5690281391144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:2.5690789222717 / seconds
Query Executed:select id FROM `va` where city='Goshen' && SIC_code='0742'DB:business_master_new
loadtime:2.5772190093994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:2.5772659778595 / seconds
Query Executed:select id FROM `va` where city='Grafton' && SIC_code='0742'DB:business_master_new
loadtime:2.5858540534973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graves Mill' limit 1
loadtime:2.5859000682831 / seconds
Query Executed:select id FROM `va` where city='Graves Mill' && SIC_code='0742'DB:business_master_new
loadtime:2.586795091629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Falls' limit 1
loadtime:2.5868330001831 / seconds
Query Executed:select id FROM `va` where city='Great Falls' && SIC_code='0742'DB:business_master_new
loadtime:2.5880179405212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:2.5880689620972 / seconds
Query Executed:select id FROM `va` where city='Green Bay' && SIC_code='0742'DB:business_master_new
loadtime:2.593691110611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbackville' limit 1
loadtime:2.5937371253967 / seconds
Query Executed:select id FROM `va` where city='Greenbackville' && SIC_code='0742'DB:business_master_new
loadtime:2.5984799861908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:2.5985240936279 / seconds
Query Executed:select id FROM `va` where city='Greenbush' && SIC_code='0742'DB:business_master_new
loadtime:2.6003260612488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:2.6003770828247 / seconds
Query Executed:select id FROM `va` where city='Greenville' && SIC_code='0742'DB:business_master_new
loadtime:2.6133229732513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenway' limit 1
loadtime:2.6133599281311 / seconds
Query Executed:select id FROM `va` where city='Greenway' && SIC_code='0742'DB:business_master_new
loadtime:2.6142499446869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:2.6142780780792 / seconds
Query Executed:select id FROM `va` where city='Greenwood' && SIC_code='0742'DB:business_master_new
loadtime:2.6206481456757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gretna' limit 1
loadtime:2.6206920146942 / seconds
Query Executed:select id FROM `va` where city='Gretna' && SIC_code='0742'DB:business_master_new
loadtime:2.6215970516205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimstead' limit 1
loadtime:2.6216459274292 / seconds
Query Executed:select id FROM `va` where city='Grimstead' && SIC_code='0742'DB:business_master_new
loadtime:2.623183965683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grottoes' limit 1
loadtime:2.6232190132141 / seconds
Query Executed:select id FROM `va` where city='Grottoes' && SIC_code='0742'DB:business_master_new
loadtime:2.6238870620728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy' limit 1
loadtime:2.6239459514618 / seconds
Query Executed:select id FROM `va` where city='Grundy' && SIC_code='0742'DB:business_master_new
loadtime:2.6247611045837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gum Spring' limit 1
loadtime:2.6248021125793 / seconds
Query Executed:select id FROM `va` where city='Gum Spring' && SIC_code='0742'DB:business_master_new
loadtime:2.63676404953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwynn' limit 1
loadtime:2.6368191242218 / seconds
Query Executed:select id FROM `va` where city='Gwynn' && SIC_code='0742'DB:business_master_new
loadtime:2.640506029129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hacksneck' limit 1
loadtime:2.6405501365662 / seconds
Query Executed:select id FROM `va` where city='Hacksneck' && SIC_code='0742'DB:business_master_new
loadtime:2.6412460803986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadensville' limit 1
loadtime:2.641273021698 / seconds
Query Executed:select id FROM `va` where city='Hadensville' && SIC_code='0742'DB:business_master_new
loadtime:2.6425960063934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hague' limit 1
loadtime:2.6426329612732 / seconds
Query Executed:select id FROM `va` where city='Hague' && SIC_code='0742'DB:business_master_new
loadtime:2.6547241210938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:2.6547679901123 / seconds
Query Executed:select id FROM `va` where city='Halifax' && SIC_code='0742'DB:business_master_new
loadtime:2.6556010246277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallieford' limit 1
loadtime:2.6556370258331 / seconds
Query Executed:select id FROM `va` where city='Hallieford' && SIC_code='0742'DB:business_master_new
loadtime:2.6573810577393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallwood' limit 1
loadtime:2.657427072525 / seconds
Query Executed:select id FROM `va` where city='Hallwood' && SIC_code='0742'DB:business_master_new
loadtime:2.6632070541382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:2.6632521152496 / seconds
Query Executed:select id FROM `va` where city='Hamilton' && SIC_code='0742'DB:business_master_new
loadtime:2.6639821529388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden Sydney' limit 1
loadtime:2.6640360355377 / seconds
Query Executed:select id FROM `va` where city='Hampden Sydney' && SIC_code='0742'DB:business_master_new
loadtime:2.6675951480865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:2.6676340103149 / seconds
Query Executed:select id FROM `va` where city='Hampton' && SIC_code='0742'DB:business_master_new
loadtime:2.6841540336609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:2.6842150688171 / seconds
Query Executed:select id FROM `va` where city='Hanover' && SIC_code='0742'DB:business_master_new
loadtime:2.6849410533905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harborton' limit 1
loadtime:2.6849920749664 / seconds
Query Executed:select id FROM `va` where city='Harborton' && SIC_code='0742'DB:business_master_new
loadtime:2.6876659393311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:2.6877770423889 / seconds
Query Executed:select id FROM `va` where city='Hardy' && SIC_code='0742'DB:business_master_new
loadtime:2.689777135849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardyville' limit 1
loadtime:2.6899049282074 / seconds
Query Executed:select id FROM `va` where city='Hardyville' && SIC_code='0742'DB:business_master_new
loadtime:2.6942961215973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harman' limit 1
loadtime:2.6943259239197 / seconds
Query Executed:select id FROM `va` where city='Harman' && SIC_code='0742'DB:business_master_new
loadtime:2.6956000328064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonburg' limit 1
loadtime:2.6956570148468 / seconds
Query Executed:select id FROM `va` where city='Harrisonburg' && SIC_code='0742'DB:business_master_new
loadtime:2.6978430747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartfield' limit 1
loadtime:2.697900056839 / seconds
Query Executed:select id FROM `va` where city='Hartfield' && SIC_code='0742'DB:business_master_new
loadtime:2.7163519859314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwood' limit 1
loadtime:2.7163910865784 / seconds
Query Executed:select id FROM `va` where city='Hartwood' && SIC_code='0742'DB:business_master_new
loadtime:2.7216050624847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:2.7216520309448 / seconds
Query Executed:select id FROM `va` where city='Hayes' && SIC_code='0742'DB:business_master_new
loadtime:2.7224860191345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haymarket' limit 1
loadtime:2.7225289344788 / seconds
Query Executed:select id FROM `va` where city='Haymarket' && SIC_code='0742'DB:business_master_new
loadtime:2.7234539985657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haynesville' limit 1
loadtime:2.7235000133514 / seconds
Query Executed:select id FROM `va` where city='Haynesville' && SIC_code='0742'DB:business_master_new
loadtime:2.7272970676422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysi' limit 1
loadtime:2.7273321151733 / seconds
Query Executed:select id FROM `va` where city='Haysi' && SIC_code='0742'DB:business_master_new
loadtime:2.7280130386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haywood' limit 1
loadtime:2.728049993515 / seconds
Query Executed:select id FROM `va` where city='Haywood' && SIC_code='0742'DB:business_master_new
loadtime:2.7293679714203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Head Waters' limit 1
loadtime:2.7294039726257 / seconds
Query Executed:select id FROM `va` where city='Head Waters' && SIC_code='0742'DB:business_master_new
loadtime:2.7306389808655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heathsville' limit 1
loadtime:2.7306931018829 / seconds
Query Executed:select id FROM `va` where city='Heathsville' && SIC_code='0742'DB:business_master_new
loadtime:2.7314291000366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:2.7314689159393 / seconds
Query Executed:select id FROM `va` where city='Henry' && SIC_code='0742'DB:business_master_new
loadtime:2.7447290420532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:2.7447741031647 / seconds
Query Executed:select id FROM `va` where city='Herndon' && SIC_code='0742'DB:business_master_new
loadtime:2.7470171451569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Springs' limit 1
loadtime:2.7470710277557 / seconds
Query Executed:select id FROM `va` where city='Highland Springs' && SIC_code='0742'DB:business_master_new
loadtime:2.7487809658051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightown' limit 1
loadtime:2.7488169670105 / seconds
Query Executed:select id FROM `va` where city='Hightown' && SIC_code='0742'DB:business_master_new
loadtime:2.7492780685425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsville' limit 1
loadtime:2.7493181228638 / seconds
Query Executed:select id FROM `va` where city='Hillsville' && SIC_code='0742'DB:business_master_new
loadtime:2.7501549720764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiltons' limit 1
loadtime:2.7501919269562 / seconds
Query Executed:select id FROM `va` where city='Hiltons' && SIC_code='0742'DB:business_master_new
loadtime:2.7610070705414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:2.7610809803009 / seconds
Query Executed:select id FROM `va` where city='Hinton' && SIC_code='0742'DB:business_master_new
loadtime:2.7665040493011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiwassee' limit 1
loadtime:2.7665419578552 / seconds
Query Executed:select id FROM `va` where city='Hiwassee' && SIC_code='0742'DB:business_master_new
loadtime:2.7762920856476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:2.776337146759 / seconds
Query Executed:select id FROM `va` where city='Hollins' && SIC_code='0742'DB:business_master_new
loadtime:2.7768371105194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaker' limit 1
loadtime:2.7768790721893 / seconds
Query Executed:select id FROM `va` where city='Honaker' && SIC_code='0742'DB:business_master_new
loadtime:2.7775540351868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hood' limit 1
loadtime:2.7775881290436 / seconds
Query Executed:select id FROM `va` where city='Hood' && SIC_code='0742'DB:business_master_new
loadtime:2.7794530391693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:2.7794930934906 / seconds
Query Executed:select id FROM `va` where city='Hopewell' && SIC_code='0742'DB:business_master_new
loadtime:2.7805390357971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horntown' limit 1
loadtime:2.7805860042572 / seconds
Query Executed:select id FROM `va` where city='Horntown' && SIC_code='0742'DB:business_master_new
loadtime:2.7836930751801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horsepen' limit 1
loadtime:2.7837340831757 / seconds
Query Executed:select id FROM `va` where city='Horsepen' && SIC_code='0742'DB:business_master_new
loadtime:2.7839879989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:2.7840249538422 / seconds
Query Executed:select id FROM `va` where city='Hot Springs' && SIC_code='0742'DB:business_master_new
loadtime:2.784677028656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howardsville' limit 1
loadtime:2.7847130298615 / seconds
Query Executed:select id FROM `va` where city='Howardsville' && SIC_code='0742'DB:business_master_new
loadtime:2.7867109775543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howertons' limit 1
loadtime:2.7867379188538 / seconds
Query Executed:select id FROM `va` where city='Howertons' && SIC_code='0742'DB:business_master_new
loadtime:2.7871761322021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huddleston' limit 1
loadtime:2.7872180938721 / seconds
Query Executed:select id FROM `va` where city='Huddleston' && SIC_code='0742'DB:business_master_new
loadtime:2.7878570556641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudgins' limit 1
loadtime:2.7878921031952 / seconds
Query Executed:select id FROM `va` where city='Hudgins' && SIC_code='0742'DB:business_master_new
loadtime:2.7941391468048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hume' limit 1
loadtime:2.7941780090332 / seconds
Query Executed:select id FROM `va` where city='Hume' && SIC_code='0742'DB:business_master_new
loadtime:2.8032851219177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntly' limit 1
loadtime:2.8033270835876 / seconds
Query Executed:select id FROM `va` where city='Huntly' && SIC_code='0742'DB:business_master_new
loadtime:2.8064639568329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:2.8065021038055 / seconds
Query Executed:select id FROM `va` where city='Hurley' && SIC_code='0742'DB:business_master_new
loadtime:2.8265879154205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurt' limit 1
loadtime:2.8266429901123 / seconds
Query Executed:select id FROM `va` where city='Hurt' && SIC_code='0742'DB:business_master_new
loadtime:2.8273460865021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustle' limit 1
loadtime:2.8273830413818 / seconds
Query Executed:select id FROM `va` where city='Hustle' && SIC_code='0742'DB:business_master_new
loadtime:2.828577041626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:2.8286180496216 / seconds
Query Executed:select id FROM `va` where city='Independence' && SIC_code='0742'DB:business_master_new
loadtime:2.8293261528015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Valley' limit 1
loadtime:2.8293650150299 / seconds
Query Executed:select id FROM `va` where city='Indian Valley' && SIC_code='0742'DB:business_master_new
loadtime:2.8307499885559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Gate' limit 1
loadtime:2.8307809829712 / seconds
Query Executed:select id FROM `va` where city='Iron Gate' && SIC_code='0742'DB:business_master_new
loadtime:2.8343899250031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironto' limit 1
loadtime:2.8344321250916 / seconds
Query Executed:select id FROM `va` where city='Ironto' && SIC_code='0742'DB:business_master_new
loadtime:2.8355579376221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:2.835597038269 / seconds
Query Executed:select id FROM `va` where city='Irvington' && SIC_code='0742'DB:business_master_new
loadtime:2.8362691402435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isle Of Wight' limit 1
loadtime:2.8362951278687 / seconds
Query Executed:select id FROM `va` where city='Isle Of Wight' && SIC_code='0742'DB:business_master_new
loadtime:2.8434529304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:2.8434989452362 / seconds
Query Executed:select id FROM `va` where city='Ivanhoe' && SIC_code='0742'DB:business_master_new
loadtime:2.8479831218719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivor' limit 1
loadtime:2.8480350971222 / seconds
Query Executed:select id FROM `va` where city='Ivor' && SIC_code='0742'DB:business_master_new
loadtime:2.848650932312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivy' limit 1
loadtime:2.8486769199371 / seconds
Query Executed:select id FROM `va` where city='Ivy' && SIC_code='0742'DB:business_master_new
loadtime:2.8628170490265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:2.8628740310669 / seconds
Query Executed:select id FROM `va` where city='Jamaica' && SIC_code='0742'DB:business_master_new
loadtime:2.8648629188538 / seconds
Query loaded from cache:select * from geodata_geocity where city='James Store' limit 1
loadtime:2.8649289608002 / seconds
Query Executed:select id FROM `va` where city='James Store' && SIC_code='0742'DB:business_master_new
loadtime:2.8651859760284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:2.8652241230011 / seconds
Query Executed:select id FROM `va` where city='Jamestown' && SIC_code='0742'DB:business_master_new
loadtime:2.8656740188599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:2.8657100200653 / seconds
Query Executed:select id FROM `va` where city='Jamesville' && SIC_code='0742'DB:business_master_new
loadtime:2.8673229217529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarratt' limit 1
loadtime:2.8673670291901 / seconds
Query Executed:select id FROM `va` where city='Jarratt' && SIC_code='0742'DB:business_master_new
loadtime:2.8679990768433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:2.8680310249329 / seconds
Query Executed:select id FROM `va` where city='Java' && SIC_code='0742'DB:business_master_new
loadtime:2.8741610050201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffersonton' limit 1
loadtime:2.8742010593414 / seconds
Query Executed:select id FROM `va` where city='Jeffersonton' && SIC_code='0742'DB:business_master_new
loadtime:2.8863260746002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenkins Bridge' limit 1
loadtime:2.8863611221313 / seconds
Query Executed:select id FROM `va` where city='Jenkins Bridge' && SIC_code='0742'DB:business_master_new
loadtime:2.8866200447083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey' limit 1
loadtime:2.8866641521454 / seconds
Query Executed:select id FROM `va` where city='Jersey' && SIC_code='0742'DB:business_master_new
loadtime:2.8878901004791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetersville' limit 1
loadtime:2.8879499435425 / seconds
Query Executed:select id FROM `va` where city='Jetersville' && SIC_code='0742'DB:business_master_new
loadtime:2.888592004776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell Ridge' limit 1
loadtime:2.8886201381683 / seconds
Query Executed:select id FROM `va` where city='Jewell Ridge' && SIC_code='0742'DB:business_master_new
loadtime:2.8904359340668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:2.8904790878296 / seconds
Query Executed:select id FROM `va` where city='Jonesville' && SIC_code='0742'DB:business_master_new
loadtime:2.891214132309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keeling' limit 1
loadtime:2.8912620544434 / seconds
Query Executed:select id FROM `va` where city='Keeling' && SIC_code='0742'DB:business_master_new
loadtime:2.8967230319977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keen Mountain' limit 1
loadtime:2.8967659473419 / seconds
Query Executed:select id FROM `va` where city='Keen Mountain' && SIC_code='0742'DB:business_master_new
loadtime:2.9012949466705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:2.9013409614563 / seconds
Query Executed:select id FROM `va` where city='Keene' && SIC_code='0742'DB:business_master_new
loadtime:2.9033470153809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keezletown' limit 1
loadtime:2.9033989906311 / seconds
Query Executed:select id FROM `va` where city='Keezletown' && SIC_code='0742'DB:business_master_new
loadtime:2.9113430976868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keller' limit 1
loadtime:2.9113960266113 / seconds
Query Executed:select id FROM `va` where city='Keller' && SIC_code='0742'DB:business_master_new
loadtime:2.9240379333496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenbridge' limit 1
loadtime:2.9240880012512 / seconds
Query Executed:select id FROM `va` where city='Kenbridge' && SIC_code='0742'DB:business_master_new
loadtime:2.9248061180115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kents Store' limit 1
loadtime:2.92484998703 / seconds
Query Executed:select id FROM `va` where city='Kents Store' && SIC_code='0742'DB:business_master_new
loadtime:2.9309210777283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokee' limit 1
loadtime:2.9309620857239 / seconds
Query Executed:select id FROM `va` where city='Keokee' && SIC_code='0742'DB:business_master_new
loadtime:2.9331419467926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:2.9331741333008 / seconds
Query Executed:select id FROM `va` where city='Keswick' && SIC_code='0742'DB:business_master_new
loadtime:2.9338920116425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keysville' limit 1
loadtime:2.9339561462402 / seconds
Query Executed:select id FROM `va` where city='Keysville' && SIC_code='0742'DB:business_master_new
loadtime:2.9346470832825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmarnock' limit 1
loadtime:2.9346871376038 / seconds
Query Executed:select id FROM `va` where city='Kilmarnock' && SIC_code='0742'DB:business_master_new
loadtime:2.9355230331421 / seconds
Query loaded from cache:select * from geodata_geocity where city='King & Queen C H' limit 1
loadtime:2.9355549812317 / seconds
Query Executed:select id FROM `va` where city='King & Queen C H' && SIC_code='0742'DB:business_master_new
loadtime:2.9366631507874 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court Hous' limit 1
loadtime:2.9367029666901 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court Hous' && SIC_code='0742'DB:business_master_new
loadtime:2.9369370937347 / seconds
Query loaded from cache:select * from geodata_geocity where city='King And Queen Court House' limit 1
loadtime:2.9369699954987 / seconds
Query Executed:select id FROM `va` where city='King And Queen Court House' && SIC_code='0742'DB:business_master_new
loadtime:2.9474580287933 / seconds
Query loaded from cache:select * from geodata_geocity where city='King George' limit 1
loadtime:2.9475030899048 / seconds
Query Executed:select id FROM `va` where city='King George' && SIC_code='0742'DB:business_master_new
loadtime:2.9484930038452 / seconds
Query loaded from cache:select * from geodata_geocity where city='King William' limit 1
loadtime:2.9485399723053 / seconds
Query Executed:select id FROM `va` where city='King William' && SIC_code='0742'DB:business_master_new
loadtime:2.9492421150208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsale' limit 1
loadtime:2.9492800235748 / seconds
Query Executed:select id FROM `va` where city='Kinsale' && SIC_code='0742'DB:business_master_new
loadtime:2.9585390090942 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:2.9585840702057 / seconds
Query Executed:select id FROM `va` where city='La Crosse' && SIC_code='0742'DB:business_master_new
loadtime:2.9592781066895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacey Spring' limit 1
loadtime:2.959321975708 / seconds
Query Executed:select id FROM `va` where city='Lacey Spring' && SIC_code='0742'DB:business_master_new
loadtime:2.9612009525299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lackey' limit 1
loadtime:2.9612419605255 / seconds
Query Executed:select id FROM `va` where city='Lackey' && SIC_code='0742'DB:business_master_new
loadtime:2.9640729427338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:2.9641020298004 / seconds
Query Executed:select id FROM `va` where city='Ladysmith' && SIC_code='0742'DB:business_master_new
loadtime:2.9760141372681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:2.976056098938 / seconds
Query Executed:select id FROM `va` where city='Lafayette' && SIC_code='0742'DB:business_master_new
loadtime:2.9768600463867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambsburg' limit 1
loadtime:2.976900100708 / seconds
Query Executed:select id FROM `va` where city='Lambsburg' && SIC_code='0742'DB:business_master_new
loadtime:2.9789249897003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:2.9789640903473 / seconds
Query Executed:select id FROM `va` where city='Lancaster' && SIC_code='0742'DB:business_master_new
loadtime:2.9796409606934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laneview' limit 1
loadtime:2.9796719551086 / seconds
Query Executed:select id FROM `va` where city='Laneview' && SIC_code='0742'DB:business_master_new
loadtime:2.9821739196777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanexa' limit 1
loadtime:2.9822170734406 / seconds
Query Executed:select id FROM `va` where city='Lanexa' && SIC_code='0742'DB:business_master_new
loadtime:2.9828901290894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langley Afb' limit 1
loadtime:2.9829499721527 / seconds
Query Executed:select id FROM `va` where city='Langley Afb' && SIC_code='0742'DB:business_master_new
loadtime:2.9845769405365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Fork' limit 1
loadtime:2.9846091270447 / seconds
Query Executed:select id FROM `va` where city='Laurel Fork' && SIC_code='0742'DB:business_master_new
loadtime:2.9903390407562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:2.9903869628906 / seconds
Query Executed:select id FROM `va` where city='Lawrenceville' && SIC_code='0742'DB:business_master_new
loadtime:2.9911940097809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:2.991240978241 / seconds
Query Executed:select id FROM `va` where city='Lebanon' && SIC_code='0742'DB:business_master_new
loadtime:2.9921300411224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon Church' limit 1
loadtime:2.9921760559082 / seconds
Query Executed:select id FROM `va` where city='Lebanon Church' && SIC_code='0742'DB:business_master_new
loadtime:2.9924039840698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:2.9924371242523 / seconds
Query Executed:select id FROM `va` where city='Leesburg' && SIC_code='0742'DB:business_master_new
loadtime:2.9944341182709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:2.9945020675659 / seconds
Query Executed:select id FROM `va` where city='Leon' && SIC_code='0742'DB:business_master_new
loadtime:2.9969251155853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:2.9969871044159 / seconds
Query Executed:select id FROM `va` where city='Lexington' && SIC_code='0742'DB:business_master_new
loadtime:2.9981369972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lightfoot' limit 1
loadtime:2.9981739521027 / seconds
Query Executed:select id FROM `va` where city='Lightfoot' && SIC_code='0742'DB:business_master_new
loadtime:3.0079729557037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lignum' limit 1
loadtime:3.0080161094666 / seconds
Query Executed:select id FROM `va` where city='Lignum' && SIC_code='0742'DB:business_master_new
loadtime:3.015753030777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:3.0157959461212 / seconds
Query Executed:select id FROM `va` where city='Lincoln' && SIC_code='0742'DB:business_master_new
loadtime:3.0188579559326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:3.018942117691 / seconds
Query Executed:select id FROM `va` where city='Linden' && SIC_code='0742'DB:business_master_new
loadtime:3.0196371078491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:3.0196671485901 / seconds
Query Executed:select id FROM `va` where city='Linville' && SIC_code='0742'DB:business_master_new
loadtime:3.0316300392151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Plymouth' limit 1
loadtime:3.031702041626 / seconds
Query Executed:select id FROM `va` where city='Little Plymouth' && SIC_code='0742'DB:business_master_new
loadtime:3.0328850746155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lively' limit 1
loadtime:3.0329351425171 / seconds
Query Executed:select id FROM `va` where city='Lively' && SIC_code='0742'DB:business_master_new
loadtime:3.0400741100311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Dale' limit 1
loadtime:3.0401139259338 / seconds
Query Executed:select id FROM `va` where city='Locust Dale' && SIC_code='0742'DB:business_master_new
loadtime:3.0420470237732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Grove' limit 1
loadtime:3.0420899391174 / seconds
Query Executed:select id FROM `va` where city='Locust Grove' && SIC_code='0742'DB:business_master_new
loadtime:3.0428659915924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Hill' limit 1
loadtime:3.0429289340973 / seconds
Query Executed:select id FROM `va` where city='Locust Hill' && SIC_code='0742'DB:business_master_new
loadtime:3.0497720241547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locustville' limit 1
loadtime:3.0498230457306 / seconds
Query Executed:select id FROM `va` where city='Locustville' && SIC_code='0742'DB:business_master_new
loadtime:3.0512931346893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:3.0513370037079 / seconds
Query Executed:select id FROM `va` where city='Long Island' && SIC_code='0742'DB:business_master_new
loadtime:3.0591149330139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:3.0591599941254 / seconds
Query Executed:select id FROM `va` where city='Loretto' && SIC_code='0742'DB:business_master_new
loadtime:3.0605580806732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorton' limit 1
loadtime:3.060595035553 / seconds
Query Executed:select id FROM `va` where city='Lorton' && SIC_code='0742'DB:business_master_new
loadtime:3.0617759227753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lottsburg' limit 1
loadtime:3.0618169307709 / seconds
Query Executed:select id FROM `va` where city='Lottsburg' && SIC_code='0742'DB:business_master_new
loadtime:3.0761771202087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisa' limit 1
loadtime:3.0762281417847 / seconds
Query Executed:select id FROM `va` where city='Louisa' && SIC_code='0742'DB:business_master_new
loadtime:3.0771400928497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovettsville' limit 1
loadtime:3.0772020816803 / seconds
Query Executed:select id FROM `va` where city='Lovettsville' && SIC_code='0742'DB:business_master_new
loadtime:3.0779550075531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovingston' limit 1
loadtime:3.077996969223 / seconds
Query Executed:select id FROM `va` where city='Lovingston' && SIC_code='0742'DB:business_master_new
loadtime:3.0786950588226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:3.0787420272827 / seconds
Query Executed:select id FROM `va` where city='Low Moor' && SIC_code='0742'DB:business_master_new
loadtime:3.0891060829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowesville' limit 1
loadtime:3.0891389846802 / seconds
Query Executed:select id FROM `va` where city='Lowesville' && SIC_code='0742'DB:business_master_new
loadtime:3.0896730422974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowmoor' limit 1
loadtime:3.0897150039673 / seconds
Query Executed:select id FROM `va` where city='Lowmoor' && SIC_code='0742'DB:business_master_new
loadtime:3.0899770259857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:3.0900020599365 / seconds
Query Executed:select id FROM `va` where city='Lowry' && SIC_code='0742'DB:business_master_new
loadtime:3.0908350944519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:3.0908830165863 / seconds
Query Executed:select id FROM `va` where city='Lunenburg' && SIC_code='0742'DB:business_master_new
loadtime:3.097748041153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:3.0977890491486 / seconds
Query Executed:select id FROM `va` where city='Luray' && SIC_code='0742'DB:business_master_new
loadtime:3.098776102066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynch Station' limit 1
loadtime:3.0988209247589 / seconds
Query Executed:select id FROM `va` where city='Lynch Station' && SIC_code='0742'DB:business_master_new
loadtime:3.1086740493774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynchburg' limit 1
loadtime:3.1087250709534 / seconds
Query Executed:select id FROM `va` where city='Lynchburg' && SIC_code='0742'DB:business_master_new
loadtime:3.1184740066528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:3.1185319423676 / seconds
Query Executed:select id FROM `va` where city='Lyndhurst' && SIC_code='0742'DB:business_master_new
loadtime:3.1289811134338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Machipongo' limit 1
loadtime:3.1290230751038 / seconds
Query Executed:select id FROM `va` where city='Machipongo' && SIC_code='0742'DB:business_master_new
loadtime:3.1351909637451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:3.1352441310883 / seconds
Query Executed:select id FROM `va` where city='Macon' && SIC_code='0742'DB:business_master_new
loadtime:3.1363730430603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:3.1364130973816 / seconds
Query Executed:select id FROM `va` where city='Madison' && SIC_code='0742'DB:business_master_new
loadtime:3.1372599601746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:3.1373181343079 / seconds
Query Executed:select id FROM `va` where city='Madison Heights' && SIC_code='0742'DB:business_master_new
loadtime:3.1382539272308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Mills' limit 1
loadtime:3.1382989883423 / seconds
Query Executed:select id FROM `va` where city='Madison Mills' && SIC_code='0742'DB:business_master_new
loadtime:3.1391220092773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maidens' limit 1
loadtime:3.1391630172729 / seconds
Query Executed:select id FROM `va` where city='Maidens' && SIC_code='0742'DB:business_master_new
loadtime:3.1513669490814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manakin Sabot' limit 1
loadtime:3.1514151096344 / seconds
Query Executed:select id FROM `va` where city='Manakin Sabot' && SIC_code='0742'DB:business_master_new
loadtime:3.1522541046143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas' limit 1
loadtime:3.1523139476776 / seconds
Query Executed:select id FROM `va` where city='Manassas' && SIC_code='0742'DB:business_master_new
loadtime:3.161150932312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manassas Park' limit 1
loadtime:3.1612200737 / seconds
Query Executed:select id FROM `va` where city='Manassas Park' && SIC_code='0742'DB:business_master_new
loadtime:3.1632370948792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mangohick' limit 1
loadtime:3.1632900238037 / seconds
Query Executed:select id FROM `va` where city='Mangohick' && SIC_code='0742'DB:business_master_new
loadtime:3.1635301113129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mannboro' limit 1
loadtime:3.163556098938 / seconds
Query Executed:select id FROM `va` where city='Mannboro' && SIC_code='0742'DB:business_master_new
loadtime:3.1647191047668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manquin' limit 1
loadtime:3.1647570133209 / seconds
Query Executed:select id FROM `va` where city='Manquin' && SIC_code='0742'DB:business_master_new
loadtime:3.1738059520721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mappsville' limit 1
loadtime:3.1738500595093 / seconds
Query Executed:select id FROM `va` where city='Mappsville' && SIC_code='0742'DB:business_master_new
loadtime:3.177267074585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:3.1773059368134 / seconds
Query Executed:select id FROM `va` where city='Marion' && SIC_code='0742'DB:business_master_new
loadtime:3.17830991745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marionville' limit 1
loadtime:3.1783790588379 / seconds
Query Executed:select id FROM `va` where city='Marionville' && SIC_code='0742'DB:business_master_new
loadtime:3.1786870956421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markham' limit 1
loadtime:3.1787230968475 / seconds
Query Executed:select id FROM `va` where city='Markham' && SIC_code='0742'DB:business_master_new
loadtime:3.1830489635468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:3.1831021308899 / seconds
Query Executed:select id FROM `va` where city='Marshall' && SIC_code='0742'DB:business_master_new
loadtime:3.1840031147003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:3.1840670108795 / seconds
Query Executed:select id FROM `va` where city='Martinsville' && SIC_code='0742'DB:business_master_new
loadtime:3.1856069564819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maryus' limit 1
loadtime:3.1856589317322 / seconds
Query Executed:select id FROM `va` where city='Maryus' && SIC_code='0742'DB:business_master_new
loadtime:3.1864099502563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mascot' limit 1
loadtime:3.1864631175995 / seconds
Query Executed:select id FROM `va` where city='Mascot' && SIC_code='0742'DB:business_master_new
loadtime:3.1890230178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massies Mill' limit 1
loadtime:3.1890621185303 / seconds
Query Executed:select id FROM `va` where city='Massies Mill' && SIC_code='0742'DB:business_master_new
loadtime:3.1894481182098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:3.189474105835 / seconds
Query Executed:select id FROM `va` where city='Mathews' && SIC_code='0742'DB:business_master_new
loadtime:3.1908669471741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattaponi' limit 1
loadtime:3.1909279823303 / seconds
Query Executed:select id FROM `va` where city='Mattaponi' && SIC_code='0742'DB:business_master_new
loadtime:3.1989359855652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurertown' limit 1
loadtime:3.1989970207214 / seconds
Query Executed:select id FROM `va` where city='Maurertown' && SIC_code='0742'DB:business_master_new
loadtime:3.2153351306915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mavisdale' limit 1
loadtime:3.2153799533844 / seconds
Query Executed:select id FROM `va` where city='Mavisdale' && SIC_code='0742'DB:business_master_new
loadtime:3.2168431282043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Max Meadows' limit 1
loadtime:3.2168900966644 / seconds
Query Executed:select id FROM `va` where city='Max Meadows' && SIC_code='0742'DB:business_master_new
loadtime:3.2176289558411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxie' limit 1
loadtime:3.2176649570465 / seconds
Query Executed:select id FROM `va` where city='Maxie' && SIC_code='0742'DB:business_master_new
loadtime:3.2193241119385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clure' limit 1
loadtime:3.2193651199341 / seconds
Query Executed:select id FROM `va` where city='Mc Clure' && SIC_code='0742'DB:business_master_new
loadtime:3.2209179401398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Coy' limit 1
loadtime:3.2209570407867 / seconds
Query Executed:select id FROM `va` where city='Mc Coy' && SIC_code='0742'DB:business_master_new
loadtime:3.2220649719238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Dowell' limit 1
loadtime:3.2221009731293 / seconds
Query Executed:select id FROM `va` where city='Mc Dowell' && SIC_code='0742'DB:business_master_new
loadtime:3.2285721302032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gaheysville' limit 1
loadtime:3.228639125824 / seconds
Query Executed:select id FROM `va` where city='Mc Gaheysville' && SIC_code='0742'DB:business_master_new
loadtime:3.2293131351471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenney' limit 1
loadtime:3.2293469905853 / seconds
Query Executed:select id FROM `va` where city='Mc Kenney' && SIC_code='0742'DB:business_master_new
loadtime:3.2471461296082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lean' limit 1
loadtime:3.2472031116486 / seconds
Query Executed:select id FROM `va` where city='Mc Lean' && SIC_code='0742'DB:business_master_new
loadtime:3.2565190792084 / seconds
Query Executed:select * from geodata_geocity where city='Mckenney' limit 1DB:business_master_new
loadtime:3.2568550109863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mclean' limit 1
loadtime:3.2569041252136 / seconds
Query Executed:select id FROM `va` where city='Mclean' && SIC_code='0742'DB:business_master_new
loadtime:3.2575459480286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows Of Dan' limit 1
loadtime:3.2576019763947 / seconds
Query Executed:select id FROM `va` where city='Meadows Of Dan' && SIC_code='0742'DB:business_master_new
loadtime:3.2730569839478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadowview' limit 1
loadtime:3.273108959198 / seconds
Query Executed:select id FROM `va` where city='Meadowview' && SIC_code='0742'DB:business_master_new
loadtime:3.2738220691681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:3.2738609313965 / seconds
Query Executed:select id FROM `va` where city='Mears' && SIC_code='0742'DB:business_master_new
loadtime:3.2749071121216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:3.2749669551849 / seconds
Query Executed:select id FROM `va` where city='Mechanicsville' && SIC_code='0742'DB:business_master_new
loadtime:3.2767210006714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meherrin' limit 1
loadtime:3.2767729759216 / seconds
Query Executed:select id FROM `va` where city='Meherrin' && SIC_code='0742'DB:business_master_new
loadtime:3.2829959392548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melfa' limit 1
loadtime:3.2830481529236 / seconds
Query Executed:select id FROM `va` where city='Melfa' && SIC_code='0742'DB:business_master_new
loadtime:3.2836909294128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendota' limit 1
loadtime:3.283725976944 / seconds
Query Executed:select id FROM `va` where city='Mendota' && SIC_code='0742'DB:business_master_new
loadtime:3.2861139774323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredithville' limit 1
loadtime:3.2861459255219 / seconds
Query Executed:select id FROM `va` where city='Meredithville' && SIC_code='0742'DB:business_master_new
loadtime:3.2863819599152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrifield' limit 1
loadtime:3.2864210605621 / seconds
Query Executed:select id FROM `va` where city='Merrifield' && SIC_code='0742'DB:business_master_new
loadtime:3.2870690822601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Point' limit 1
loadtime:3.2871069908142 / seconds
Query Executed:select id FROM `va` where city='Merry Point' && SIC_code='0742'DB:business_master_new
loadtime:3.2894420623779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebrook' limit 1
loadtime:3.2894849777222 / seconds
Query Executed:select id FROM `va` where city='Middlebrook' && SIC_code='0742'DB:business_master_new
loadtime:3.2972860336304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:3.2973351478577 / seconds
Query Executed:select id FROM `va` where city='Middleburg' && SIC_code='0742'DB:business_master_new
loadtime:3.2982549667358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:3.2983109951019 / seconds
Query Executed:select id FROM `va` where city='Middletown' && SIC_code='0742'DB:business_master_new
loadtime:3.2989981174469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:3.2990329265594 / seconds
Query Executed:select id FROM `va` where city='Midland' && SIC_code='0742'DB:business_master_new
loadtime:3.2996499538422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midlothian' limit 1
loadtime:3.2996909618378 / seconds
Query Executed:select id FROM `va` where city='Midlothian' && SIC_code='0742'DB:business_master_new
loadtime:3.3017611503601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:3.3018109798431 / seconds
Query Executed:select id FROM `va` where city='Milford' && SIC_code='0742'DB:business_master_new
loadtime:3.3024880886078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millboro' limit 1
loadtime:3.3025410175323 / seconds
Query Executed:select id FROM `va` where city='Millboro' && SIC_code='0742'DB:business_master_new
loadtime:3.316465139389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Tavern' limit 1
loadtime:3.3165171146393 / seconds
Query Executed:select id FROM `va` where city='Millers Tavern' && SIC_code='0742'DB:business_master_new
loadtime:3.3182780742645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millwood' limit 1
loadtime:3.3183240890503 / seconds
Query Executed:select id FROM `va` where city='Millwood' && SIC_code='0742'DB:business_master_new
loadtime:3.3254179954529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Run' limit 1
loadtime:3.3254461288452 / seconds
Query Executed:select id FROM `va` where city='Mine Run' && SIC_code='0742'DB:business_master_new
loadtime:3.3261001110077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral' limit 1
loadtime:3.3261399269104 / seconds
Query Executed:select id FROM `va` where city='Mineral' && SIC_code='0742'DB:business_master_new
loadtime:3.3268511295319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Spring' limit 1
loadtime:3.3268890380859 / seconds
Query Executed:select id FROM `va` where city='Mint Spring' && SIC_code='0742'DB:business_master_new
loadtime:3.3300640583038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchells' limit 1
loadtime:3.3301110267639 / seconds
Query Executed:select id FROM `va` where city='Mitchells' && SIC_code='0742'DB:business_master_new
loadtime:3.3326230049133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modest Town' limit 1
loadtime:3.3326730728149 / seconds
Query Executed:select id FROM `va` where city='Modest Town' && SIC_code='0742'DB:business_master_new
loadtime:3.3337960243225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mollusk' limit 1
loadtime:3.3338251113892 / seconds
Query Executed:select id FROM `va` where city='Mollusk' && SIC_code='0742'DB:business_master_new
loadtime:3.3352711200714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moneta' limit 1
loadtime:3.335324048996 / seconds
Query Executed:select id FROM `va` where city='Moneta' && SIC_code='0742'DB:business_master_new
loadtime:3.3362591266632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:3.3363149166107 / seconds
Query Executed:select id FROM `va` where city='Monroe' && SIC_code='0742'DB:business_master_new
loadtime:3.3370089530945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montebello' limit 1
loadtime:3.3370499610901 / seconds
Query Executed:select id FROM `va` where city='Montebello' && SIC_code='0742'DB:business_master_new
loadtime:3.3400859832764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:3.3401291370392 / seconds
Query Executed:select id FROM `va` where city='Monterey' && SIC_code='0742'DB:business_master_new
loadtime:3.3408200740814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:3.3408639431 / seconds
Query Executed:select id FROM `va` where city='Montpelier' && SIC_code='0742'DB:business_master_new
loadtime:3.3416240215302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Sta' limit 1
loadtime:3.341686964035 / seconds
Query Executed:select id FROM `va` where city='Montpelier Sta' && SIC_code='0742'DB:business_master_new
loadtime:3.3419549465179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier Station' limit 1
loadtime:3.3419959545135 / seconds
Query Executed:select id FROM `va` where city='Montpelier Station' && SIC_code='0742'DB:business_master_new
loadtime:3.3434181213379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montross' limit 1
loadtime:3.3434610366821 / seconds
Query Executed:select id FROM `va` where city='Montross' && SIC_code='0742'DB:business_master_new
loadtime:3.3442261219025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:3.3442721366882 / seconds
Query Executed:select id FROM `va` where city='Montvale' && SIC_code='0742'DB:business_master_new
loadtime:3.3586161136627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moon' limit 1
loadtime:3.3586480617523 / seconds
Query Executed:select id FROM `va` where city='Moon' && SIC_code='0742'DB:business_master_new
loadtime:3.3596320152283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morattico' limit 1
loadtime:3.3596711158752 / seconds
Query Executed:select id FROM `va` where city='Morattico' && SIC_code='0742'DB:business_master_new
loadtime:3.3605010509491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:3.3605389595032 / seconds
Query Executed:select id FROM `va` where city='Morrisville' && SIC_code='0742'DB:business_master_new
loadtime:3.3610970973969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moseley' limit 1
loadtime:3.3611280918121 / seconds
Query Executed:select id FROM `va` where city='Moseley' && SIC_code='0742'DB:business_master_new
loadtime:3.361841917038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Crawford' limit 1
loadtime:3.3618869781494 / seconds
Query Executed:select id FROM `va` where city='Mount Crawford' && SIC_code='0742'DB:business_master_new
loadtime:3.3625590801239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:3.362596988678 / seconds
Query Executed:select id FROM `va` where city='Mount Holly' && SIC_code='0742'DB:business_master_new
loadtime:3.3651130199432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Jackson' limit 1
loadtime:3.3651490211487 / seconds
Query Executed:select id FROM `va` where city='Mount Jackson' && SIC_code='0742'DB:business_master_new
loadtime:3.365875005722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sidney' limit 1
loadtime:3.365926027298 / seconds
Query Executed:select id FROM `va` where city='Mount Sidney' && SIC_code='0742'DB:business_master_new
loadtime:3.3776731491089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Solon' limit 1
loadtime:3.3777139186859 / seconds
Query Executed:select id FROM `va` where city='Mount Solon' && SIC_code='0742'DB:business_master_new
loadtime:3.3783841133118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:3.3784260749817 / seconds
Query Executed:select id FROM `va` where city='Mount Vernon' && SIC_code='0742'DB:business_master_new
loadtime:3.385556936264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mouth Of Wilson' limit 1
loadtime:3.3855969905853 / seconds
Query Executed:select id FROM `va` where city='Mouth Of Wilson' && SIC_code='0742'DB:business_master_new
loadtime:3.3950850963593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Crawford' limit 1
loadtime:3.3951299190521 / seconds
Query Executed:select id FROM `va` where city='Mt Crawford' && SIC_code='0742'DB:business_master_new
loadtime:3.3962359428406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:3.3962781429291 / seconds
Query Executed:select id FROM `va` where city='Mt Holly' && SIC_code='0742'DB:business_master_new
loadtime:3.3965380191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Jackson' limit 1
loadtime:3.3965680599213 / seconds
Query Executed:select id FROM `va` where city='Mt Jackson' && SIC_code='0742'DB:business_master_new
loadtime:3.3987190723419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sidney' limit 1
loadtime:3.3987641334534 / seconds
Query Executed:select id FROM `va` where city='Mt Sidney' && SIC_code='0742'DB:business_master_new
loadtime:3.3992941379547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Solon' limit 1
loadtime:3.3993260860443 / seconds
Query Executed:select id FROM `va` where city='Mt Solon' && SIC_code='0742'DB:business_master_new
loadtime:3.3998141288757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:3.3998489379883 / seconds
Query Executed:select id FROM `va` where city='Mt Vernon' && SIC_code='0742'DB:business_master_new
loadtime:3.4006569385529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mustoe' limit 1
loadtime:3.4006969928741 / seconds
Query Executed:select id FROM `va` where city='Mustoe' && SIC_code='0742'DB:business_master_new
loadtime:3.4014019966125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narrows' limit 1
loadtime:3.4014599323273 / seconds
Query Executed:select id FROM `va` where city='Narrows' && SIC_code='0742'DB:business_master_new
loadtime:3.4021570682526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naruna' limit 1
loadtime:3.402184009552 / seconds
Query Executed:select id FROM `va` where city='Naruna' && SIC_code='0742'DB:business_master_new
loadtime:3.4055590629578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nassawadox' limit 1
loadtime:3.4056029319763 / seconds
Query Executed:select id FROM `va` where city='Nassawadox' && SIC_code='0742'DB:business_master_new
loadtime:3.4062480926514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nathalie' limit 1
loadtime:3.4062740802765 / seconds
Query Executed:select id FROM `va` where city='Nathalie' && SIC_code='0742'DB:business_master_new
loadtime:3.4069359302521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Brdg Sta' limit 1
loadtime:3.4069731235504 / seconds
Query Executed:select id FROM `va` where city='Natural Brdg Sta' && SIC_code='0742'DB:business_master_new
loadtime:3.4072420597076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge' limit 1
loadtime:3.4072740077972 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge' && SIC_code='0742'DB:business_master_new
loadtime:3.4079201221466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natural Bridge Station' limit 1
loadtime:3.4079561233521 / seconds
Query Executed:select id FROM `va` where city='Natural Bridge Station' && SIC_code='0742'DB:business_master_new
loadtime:3.4126510620117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naval Base' limit 1
loadtime:3.4127020835876 / seconds
Query Executed:select id FROM `va` where city='Naval Base' && SIC_code='0742'DB:business_master_new
loadtime:3.4160261154175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nellysford' limit 1
loadtime:3.4160690307617 / seconds
Query Executed:select id FROM `va` where city='Nellysford' && SIC_code='0742'DB:business_master_new
loadtime:3.4167511463165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:3.4167940616608 / seconds
Query Executed:select id FROM `va` where city='Nelson' && SIC_code='0742'DB:business_master_new
loadtime:3.4199900627136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonia' limit 1
loadtime:3.4200401306152 / seconds
Query Executed:select id FROM `va` where city='Nelsonia' && SIC_code='0742'DB:business_master_new
loadtime:3.4220271110535 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canton' limit 1
loadtime:3.4220681190491 / seconds
Query Executed:select id FROM `va` where city='New Canton' && SIC_code='0742'DB:business_master_new
loadtime:3.4321370124817 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:3.4321799278259 / seconds
Query Executed:select id FROM `va` where city='New Castle' && SIC_code='0742'DB:business_master_new
loadtime:3.4328730106354 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Church' limit 1
loadtime:3.4329199790955 / seconds
Query Executed:select id FROM `va` where city='New Church' && SIC_code='0742'DB:business_master_new
loadtime:3.433562040329 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:3.4335970878601 / seconds
Query Executed:select id FROM `va` where city='New Hope' && SIC_code='0742'DB:business_master_new
loadtime:3.4370601177216 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Kent' limit 1
loadtime:3.4370930194855 / seconds
Query Executed:select id FROM `va` where city='New Kent' && SIC_code='0742'DB:business_master_new
loadtime:3.437756061554 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:3.4377949237823 / seconds
Query Executed:select id FROM `va` where city='New Market' && SIC_code='0742'DB:business_master_new
loadtime:3.4385590553284 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Point' limit 1
loadtime:3.4386050701141 / seconds
Query Executed:select id FROM `va` where city='New Point' && SIC_code='0742'DB:business_master_new
loadtime:3.4407849311829 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:3.44082903862 / seconds
Query Executed:select id FROM `va` where city='New River' && SIC_code='0742'DB:business_master_new
loadtime:3.4422690868378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:3.442312002182 / seconds
Query Executed:select id FROM `va` where city='Newbern' && SIC_code='0742'DB:business_master_new
loadtime:3.4463310241699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:3.4463770389557 / seconds
Query Executed:select id FROM `va` where city='Newington' && SIC_code='0742'DB:business_master_new
loadtime:3.4470391273499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:3.4470739364624 / seconds
Query Executed:select id FROM `va` where city='Newport' && SIC_code='0742'DB:business_master_new
loadtime:3.4611959457397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport News' limit 1
loadtime:3.4612331390381 / seconds
Query Executed:select id FROM `va` where city='Newport News' && SIC_code='0742'DB:business_master_new
loadtime:3.4710960388184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newsoms' limit 1
loadtime:3.4711630344391 / seconds
Query Executed:select id FROM `va` where city='Newsoms' && SIC_code='0742'DB:business_master_new
loadtime:3.477509021759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:3.4775459766388 / seconds
Query Executed:select id FROM `va` where city='Newtown' && SIC_code='0742'DB:business_master_new
loadtime:3.4799420833588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickelsville' limit 1
loadtime:3.4800181388855 / seconds
Query Executed:select id FROM `va` where city='Nickelsville' && SIC_code='0742'DB:business_master_new
loadtime:3.4917230606079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninde' limit 1
loadtime:3.4917681217194 / seconds
Query Executed:select id FROM `va` where city='Ninde' && SIC_code='0742'DB:business_master_new
loadtime:3.493968963623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nokesville' limit 1
loadtime:3.4940090179443 / seconds
Query Executed:select id FROM `va` where city='Nokesville' && SIC_code='0742'DB:business_master_new
loadtime:3.4947769641876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora' limit 1
loadtime:3.4948251247406 / seconds
Query Executed:select id FROM `va` where city='Nora' && SIC_code='0742'DB:business_master_new
loadtime:3.4987490177155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:3.4988069534302 / seconds
Query Executed:select id FROM `va` where city='Norfolk' && SIC_code='0742'DB:business_master_new
loadtime:3.5075650215149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norge' limit 1
loadtime:3.507621049881 / seconds
Query Executed:select id FROM `va` where city='Norge' && SIC_code='0742'DB:business_master_new
loadtime:3.511225938797 / seconds
Query loaded from cache:select * from geodata_geocity where city='North' limit 1
loadtime:3.5112791061401 / seconds
Query Executed:select id FROM `va` where city='North' && SIC_code='0742'DB:business_master_new
loadtime:3.5151870250702 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Garden' limit 1
loadtime:3.5152399539948 / seconds
Query Executed:select id FROM `va` where city='North Garden' && SIC_code='0742'DB:business_master_new
loadtime:3.530198097229 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Tazewell' limit 1
loadtime:3.5302350521088 / seconds
Query Executed:select id FROM `va` where city='North Tazewell' && SIC_code='0742'DB:business_master_new
loadtime:3.5309569835663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:3.5310130119324 / seconds
Query Executed:select id FROM `va` where city='Norton' && SIC_code='0742'DB:business_master_new
loadtime:3.5318689346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:3.5319309234619 / seconds
Query Executed:select id FROM `va` where city='Norwood' && SIC_code='0742'DB:business_master_new
loadtime:3.5328850746155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottoway' limit 1
loadtime:3.5329461097717 / seconds
Query Executed:select id FROM `va` where city='Nottoway' && SIC_code='0742'DB:business_master_new
loadtime:3.5369379520416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nuttsville' limit 1
loadtime:3.53697514534 / seconds
Query Executed:select id FROM `va` where city='Nuttsville' && SIC_code='0742'DB:business_master_new
loadtime:3.5377290248871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hall' limit 1
loadtime:3.5377819538116 / seconds
Query Executed:select id FROM `va` where city='Oak Hall' && SIC_code='0742'DB:business_master_new
loadtime:3.5451319217682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakpark' limit 1
loadtime:3.5451829433441 / seconds
Query Executed:select id FROM `va` where city='Oakpark' && SIC_code='0742'DB:business_master_new
loadtime:3.547217130661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakton' limit 1
loadtime:3.5472550392151 / seconds
Query Executed:select id FROM `va` where city='Oakton' && SIC_code='0742'DB:business_master_new
loadtime:3.5482439994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakwood' limit 1
loadtime:3.548299074173 / seconds
Query Executed:select id FROM `va` where city='Oakwood' && SIC_code='0742'DB:business_master_new
loadtime:3.5489521026611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Occoquan' limit 1
loadtime:3.5490009784698 / seconds
Query Executed:select id FROM `va` where city='Occoquan' && SIC_code='0742'DB:business_master_new
loadtime:3.5496821403503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oilville' limit 1
loadtime:3.5497260093689 / seconds
Query Executed:select id FROM `va` where city='Oilville' && SIC_code='0742'DB:business_master_new
loadtime:3.5503771305084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldhams' limit 1
loadtime:3.5504260063171 / seconds
Query Executed:select id FROM `va` where city='Oldhams' && SIC_code='0742'DB:business_master_new
loadtime:3.5518960952759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onancock' limit 1
loadtime:3.5519549846649 / seconds
Query Executed:select id FROM `va` where city='Onancock' && SIC_code='0742'DB:business_master_new
loadtime:3.5527119636536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onemo' limit 1
loadtime:3.5527639389038 / seconds
Query Executed:select id FROM `va` where city='Onemo' && SIC_code='0742'DB:business_master_new
loadtime:3.5537829399109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onley' limit 1
loadtime:3.5538339614868 / seconds
Query Executed:select id FROM `va` where city='Onley' && SIC_code='0742'DB:business_master_new
loadtime:3.5545320510864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ophelia' limit 1
loadtime:3.554582118988 / seconds
Query Executed:select id FROM `va` where city='Ophelia' && SIC_code='0742'DB:business_master_new
loadtime:3.5554509162903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:3.5555040836334 / seconds
Query Executed:select id FROM `va` where city='Orange' && SIC_code='0742'DB:business_master_new
loadtime:3.5564439296722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ordinary' limit 1
loadtime:3.5565040111542 / seconds
Query Executed:select id FROM `va` where city='Ordinary' && SIC_code='0742'DB:business_master_new
loadtime:3.5623779296875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriskany' limit 1
loadtime:3.5624301433563 / seconds
Query Executed:select id FROM `va` where city='Oriskany' && SIC_code='0742'DB:business_master_new
loadtime:3.5633869171143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orkney Springs' limit 1
loadtime:3.5634279251099 / seconds
Query Executed:select id FROM `va` where city='Orkney Springs' && SIC_code='0742'DB:business_master_new
loadtime:3.5644030570984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orlean' limit 1
loadtime:3.5644540786743 / seconds
Query Executed:select id FROM `va` where city='Orlean' && SIC_code='0742'DB:business_master_new
loadtime:3.5674669742584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyster' limit 1
loadtime:3.5675089359283 / seconds
Query Executed:select id FROM `va` where city='Oyster' && SIC_code='0742'DB:business_master_new
loadtime:3.5682511329651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paeonian Springs' limit 1
loadtime:3.5683000087738 / seconds
Query Executed:select id FROM `va` where city='Paeonian Springs' && SIC_code='0742'DB:business_master_new
loadtime:3.5749831199646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Bank' limit 1
loadtime:3.5750350952148 / seconds
Query Executed:select id FROM `va` where city='Paint Bank' && SIC_code='0742'DB:business_master_new
loadtime:3.5760519504547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painter' limit 1
loadtime:3.5761089324951 / seconds
Query Executed:select id FROM `va` where city='Painter' && SIC_code='0742'DB:business_master_new
loadtime:3.5888180732727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:3.588879108429 / seconds
Query Executed:select id FROM `va` where city='Palmyra' && SIC_code='0742'DB:business_master_new
loadtime:3.5897259712219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pamplin' limit 1
loadtime:3.5897810459137 / seconds
Query Executed:select id FROM `va` where city='Pamplin' && SIC_code='0742'DB:business_master_new
loadtime:3.6021580696106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:3.6022200584412 / seconds
Query Executed:select id FROM `va` where city='Paris' && SIC_code='0742'DB:business_master_new
loadtime:3.6047811508179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parksley' limit 1
loadtime:3.6048109531403 / seconds
Query Executed:select id FROM `va` where city='Parksley' && SIC_code='0742'DB:business_master_new
loadtime:3.605553150177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrott' limit 1
loadtime:3.6056129932404 / seconds
Query Executed:select id FROM `va` where city='Parrott' && SIC_code='0742'DB:business_master_new
loadtime:3.6059379577637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partlow' limit 1
loadtime:3.6059799194336 / seconds
Query Executed:select id FROM `va` where city='Partlow' && SIC_code='0742'DB:business_master_new
loadtime:3.6127109527588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patrick Springs' limit 1
loadtime:3.6127460002899 / seconds
Query Executed:select id FROM `va` where city='Patrick Springs' && SIC_code='0742'DB:business_master_new
loadtime:3.6134970188141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:3.6135399341583 / seconds
Query Executed:select id FROM `va` where city='Patterson' && SIC_code='0742'DB:business_master_new
loadtime:3.6140699386597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearisburg' limit 1
loadtime:3.6141149997711 / seconds
Query Executed:select id FROM `va` where city='Pearisburg' && SIC_code='0742'DB:business_master_new
loadtime:3.6148941516876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:3.6149599552155 / seconds
Query Executed:select id FROM `va` where city='Pembroke' && SIC_code='0742'DB:business_master_new
loadtime:3.6157851219177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penhook' limit 1
loadtime:3.6158139705658 / seconds
Query Executed:select id FROM `va` where city='Penhook' && SIC_code='0742'DB:business_master_new
loadtime:3.6165881156921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penn Laird' limit 1
loadtime:3.6166279315948 / seconds
Query Executed:select id FROM `va` where city='Penn Laird' && SIC_code='0742'DB:business_master_new
loadtime:3.6324920654297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington Gap' limit 1
loadtime:3.6325359344482 / seconds
Query Executed:select id FROM `va` where city='Pennington Gap' && SIC_code='0742'DB:business_master_new
loadtime:3.6333229541779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:3.6333899497986 / seconds
Query Executed:select id FROM `va` where city='Petersburg' && SIC_code='0742'DB:business_master_new
loadtime:3.6350440979004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix' limit 1
loadtime:3.6351010799408 / seconds
Query Executed:select id FROM `va` where city='Phenix' && SIC_code='0742'DB:business_master_new
loadtime:3.6411831378937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philomont' limit 1
loadtime:3.6412310600281 / seconds
Query Executed:select id FROM `va` where city='Philomont' && SIC_code='0742'DB:business_master_new
loadtime:3.6438391208649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilgrims Knob' limit 1
loadtime:3.6438760757446 / seconds
Query Executed:select id FROM `va` where city='Pilgrims Knob' && SIC_code='0742'DB:business_master_new
loadtime:3.6448040008545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot' limit 1
loadtime:3.6448500156403 / seconds
Query Executed:select id FROM `va` where city='Pilot' && SIC_code='0742'DB:business_master_new
loadtime:3.6518640518188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney River' limit 1
loadtime:3.6519050598145 / seconds
Query Executed:select id FROM `va` where city='Piney River' && SIC_code='0742'DB:business_master_new
loadtime:3.6580920219421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:3.6581470966339 / seconds
Query Executed:select id FROM `va` where city='Pittsville' && SIC_code='0742'DB:business_master_new
loadtime:3.6608140468597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain View' limit 1
loadtime:3.6608679294586 / seconds
Query Executed:select id FROM `va` where city='Plain View' && SIC_code='0742'DB:business_master_new
loadtime:3.6615121364594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:3.6615710258484 / seconds
Query Executed:select id FROM `va` where city='Pleasant Valley' && SIC_code='0742'DB:business_master_new
loadtime:3.6623640060425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:3.6624081134796 / seconds
Query Executed:select id FROM `va` where city='Pocahontas' && SIC_code='0742'DB:business_master_new
loadtime:3.6658771038055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquoson' limit 1
loadtime:3.6659300327301 / seconds
Query Executed:select id FROM `va` where city='Poquoson' && SIC_code='0742'DB:business_master_new
loadtime:3.6667580604553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Haywood' limit 1
loadtime:3.6668150424957 / seconds
Query Executed:select id FROM `va` where city='Port Haywood' && SIC_code='0742'DB:business_master_new
loadtime:3.6707949638367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:3.6708540916443 / seconds
Query Executed:select id FROM `va` where city='Port Republic' && SIC_code='0742'DB:business_master_new
loadtime:3.6781470775604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Royal' limit 1
loadtime:3.678190946579 / seconds
Query Executed:select id FROM `va` where city='Port Royal' && SIC_code='0742'DB:business_master_new
loadtime:3.6878881454468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:3.6879649162292 / seconds
Query Executed:select id FROM `va` where city='Portsmouth' && SIC_code='0742'DB:business_master_new
loadtime:3.6906471252441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:3.6907029151917 / seconds
Query Executed:select id FROM `va` where city='Pound' && SIC_code='0742'DB:business_master_new
loadtime:3.6914079189301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pounding Mill' limit 1
loadtime:3.6914539337158 / seconds
Query Executed:select id FROM `va` where city='Pounding Mill' && SIC_code='0742'DB:business_master_new
loadtime:3.6921000480652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhatan' limit 1
loadtime:3.6921451091766 / seconds
Query Executed:select id FROM `va` where city='Powhatan' && SIC_code='0742'DB:business_master_new
loadtime:3.6932139396667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratts' limit 1
loadtime:3.6932690143585 / seconds
Query Executed:select id FROM `va` where city='Pratts' && SIC_code='0742'DB:business_master_new
loadtime:3.6956241130829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prince George' limit 1
loadtime:3.6956701278687 / seconds
Query Executed:select id FROM `va` where city='Prince George' && SIC_code='0742'DB:business_master_new
loadtime:3.6964619159698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:3.6965179443359 / seconds
Query Executed:select id FROM `va` where city='Prospect' && SIC_code='0742'DB:business_master_new
loadtime:3.7091641426086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence Forge' limit 1
loadtime:3.709214925766 / seconds
Query Executed:select id FROM `va` where city='Providence Forge' && SIC_code='0742'DB:business_master_new
loadtime:3.7100839614868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:3.7101309299469 / seconds
Query Executed:select id FROM `va` where city='Pulaski' && SIC_code='0742'DB:business_master_new
loadtime:3.7112641334534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pungoteague' limit 1
loadtime:3.7113349437714 / seconds
Query Executed:select id FROM `va` where city='Pungoteague' && SIC_code='0742'DB:business_master_new
loadtime:3.7151770591736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purcellville' limit 1
loadtime:3.7152209281921 / seconds
Query Executed:select id FROM `va` where city='Purcellville' && SIC_code='0742'DB:business_master_new
loadtime:3.7165589332581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quantico' limit 1
loadtime:3.7166230678558 / seconds
Query Executed:select id FROM `va` where city='Quantico' && SIC_code='0742'DB:business_master_new
loadtime:3.7174949645996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quicksburg' limit 1
loadtime:3.7175540924072 / seconds
Query Executed:select id FROM `va` where city='Quicksburg' && SIC_code='0742'DB:business_master_new
loadtime:3.7264020442963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinby' limit 1
loadtime:3.7264430522919 / seconds
Query Executed:select id FROM `va` where city='Quinby' && SIC_code='0742'DB:business_master_new
loadtime:3.7275841236115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinque' limit 1
loadtime:3.7276380062103 / seconds
Query Executed:select id FROM `va` where city='Quinque' && SIC_code='0742'DB:business_master_new
loadtime:3.7317349910736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:3.7317719459534 / seconds
Query Executed:select id FROM `va` where city='Quinton' && SIC_code='0742'DB:business_master_new
loadtime:3.7325029373169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radford' limit 1
loadtime:3.7325570583344 / seconds
Query Executed:select id FROM `va` where city='Radford' && SIC_code='0742'DB:business_master_new
loadtime:3.7336959838867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radiant' limit 1
loadtime:3.7337429523468 / seconds
Query Executed:select id FROM `va` where city='Radiant' && SIC_code='0742'DB:business_master_new
loadtime:3.7355690002441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:3.7356119155884 / seconds
Query Executed:select id FROM `va` where city='Randolph' && SIC_code='0742'DB:business_master_new
loadtime:3.7381310462952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raphine' limit 1
loadtime:3.7381749153137 / seconds
Query Executed:select id FROM `va` where city='Raphine' && SIC_code='0742'DB:business_master_new
loadtime:3.7510840892792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapidan' limit 1
loadtime:3.7511379718781 / seconds
Query Executed:select id FROM `va` where city='Rapidan' && SIC_code='0742'DB:business_master_new
loadtime:3.758474111557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Academy' limit 1
loadtime:3.7585301399231 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Academy' && SIC_code='0742'DB:business_master_new
loadtime:3.7595880031586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rappahannock Acd' limit 1
loadtime:3.7596340179443 / seconds
Query Executed:select id FROM `va` where city='Rappahannock Acd' && SIC_code='0742'DB:business_master_new
loadtime:3.7598791122437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raven' limit 1
loadtime:3.7599720954895 / seconds
Query Executed:select id FROM `va` where city='Raven' && SIC_code='0742'DB:business_master_new
loadtime:3.766793012619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlings' limit 1
loadtime:3.7668359279633 / seconds
Query Executed:select id FROM `va` where city='Rawlings' && SIC_code='0742'DB:business_master_new
loadtime:3.7717010974884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rectortown' limit 1
loadtime:3.7717590332031 / seconds
Query Executed:select id FROM `va` where city='Rectortown' && SIC_code='0742'DB:business_master_new
loadtime:3.7729759216309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Ash' limit 1
loadtime:3.7730419635773 / seconds
Query Executed:select id FROM `va` where city='Red Ash' && SIC_code='0742'DB:business_master_new
loadtime:3.7733111381531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red House' limit 1
loadtime:3.7733700275421 / seconds
Query Executed:select id FROM `va` where city='Red House' && SIC_code='0742'DB:business_master_new
loadtime:3.7752349376678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:3.7752759456635 / seconds
Query Executed:select id FROM `va` where city='Red Oak' && SIC_code='0742'DB:business_master_new
loadtime:3.7828090190887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redart' limit 1
loadtime:3.7828450202942 / seconds
Query Executed:select id FROM `va` where city='Redart' && SIC_code='0742'DB:business_master_new
loadtime:3.7831039428711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:3.7831490039825 / seconds
Query Executed:select id FROM `va` where city='Redwood' && SIC_code='0742'DB:business_master_new
loadtime:3.7838010787964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedville' limit 1
loadtime:3.7838430404663 / seconds
Query Executed:select id FROM `va` where city='Reedville' && SIC_code='0742'DB:business_master_new
loadtime:3.7845311164856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:3.78457903862 / seconds
Query Executed:select id FROM `va` where city='Reliance' && SIC_code='0742'DB:business_master_new
loadtime:3.7848119735718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remington' limit 1
loadtime:3.7848651409149 / seconds
Query Executed:select id FROM `va` where city='Remington' && SIC_code='0742'DB:business_master_new
loadtime:3.7856800556183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republican Grove' limit 1
loadtime:3.7857179641724 / seconds
Query Executed:select id FROM `va` where city='Republican Grove' && SIC_code='0742'DB:business_master_new
loadtime:3.7859630584717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rescue' limit 1
loadtime:3.7860100269318 / seconds
Query Executed:select id FROM `va` where city='Rescue' && SIC_code='0742'DB:business_master_new
loadtime:3.7870991230011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reston' limit 1
loadtime:3.7871329784393 / seconds
Query Executed:select id FROM `va` where city='Reston' && SIC_code='0742'DB:business_master_new
loadtime:3.7892649173737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:3.7893249988556 / seconds
Query Executed:select id FROM `va` where city='Reva' && SIC_code='0742'DB:business_master_new
loadtime:3.797758102417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhoadesville' limit 1
loadtime:3.7977900505066 / seconds
Query Executed:select id FROM `va` where city='Rhoadesville' && SIC_code='0742'DB:business_master_new
loadtime:3.8118360042572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice' limit 1
loadtime:3.8118929862976 / seconds
Query Executed:select id FROM `va` where city='Rice' && SIC_code='0742'DB:business_master_new
loadtime:3.8176939487457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Creek' limit 1
loadtime:3.817752122879 / seconds
Query Executed:select id FROM `va` where city='Rich Creek' && SIC_code='0742'DB:business_master_new
loadtime:3.8288540840149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richardsville' limit 1
loadtime:3.8288910388947 / seconds
Query Executed:select id FROM `va` where city='Richardsville' && SIC_code='0742'DB:business_master_new
loadtime:3.831787109375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:3.8318281173706 / seconds
Query Executed:select id FROM `va` where city='Richlands' && SIC_code='0742'DB:business_master_new
loadtime:3.8328940868378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:3.8329451084137 / seconds
Query Executed:select id FROM `va` where city='Richmond' && SIC_code='0742'DB:business_master_new
loadtime:3.8441541194916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:3.8442430496216 / seconds
Query Executed:select id FROM `va` where city='Ridgeway' && SIC_code='0742'DB:business_master_new
loadtime:3.8451640605927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rileyville' limit 1
loadtime:3.8452129364014 / seconds
Query Executed:select id FROM `va` where city='Rileyville' && SIC_code='0742'DB:business_master_new
loadtime:3.8518409729004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riner' limit 1
loadtime:3.851881980896 / seconds
Query Executed:select id FROM `va` where city='Riner' && SIC_code='0742'DB:business_master_new
loadtime:3.8525919914246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringgold' limit 1
loadtime:3.8526470661163 / seconds
Query Executed:select id FROM `va` where city='Ringgold' && SIC_code='0742'DB:business_master_new
loadtime:3.8533189296722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripplemead' limit 1
loadtime:3.8533599376678 / seconds
Query Executed:select id FROM `va` where city='Ripplemead' && SIC_code='0742'DB:business_master_new
loadtime:3.8568170070648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:3.8568639755249 / seconds
Query Executed:select id FROM `va` where city='Riverton' && SIC_code='0742'DB:business_master_new
loadtime:3.8571510314941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rixeyville' limit 1
loadtime:3.8571870326996 / seconds
Query Executed:select id FROM `va` where city='Rixeyville' && SIC_code='0742'DB:business_master_new
loadtime:3.8724751472473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:3.8725399971008 / seconds
Query Executed:select id FROM `va` where city='Roanoke' && SIC_code='0742'DB:business_master_new
loadtime:3.8815240859985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle' limit 1
loadtime:3.8816051483154 / seconds
Query Executed:select id FROM `va` where city='Rochelle' && SIC_code='0742'DB:business_master_new
loadtime:3.8888671398163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockbridge Baths' limit 1
loadtime:3.8889350891113 / seconds
Query Executed:select id FROM `va` where city='Rockbridge Baths' && SIC_code='0742'DB:business_master_new
loadtime:3.8918380737305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:3.8918769359589 / seconds
Query Executed:select id FROM `va` where city='Rockville' && SIC_code='0742'DB:business_master_new
loadtime:3.8926420211792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Gap' limit 1
loadtime:3.892688035965 / seconds
Query Executed:select id FROM `va` where city='Rocky Gap' && SIC_code='0742'DB:business_master_new
loadtime:3.9003341197968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:3.9003810882568 / seconds
Query Executed:select id FROM `va` where city='Rocky Mount' && SIC_code='0742'DB:business_master_new
loadtime:3.9015810489655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollins Fork' limit 1
loadtime:3.9016361236572 / seconds
Query Executed:select id FROM `va` where city='Rollins Fork' && SIC_code='0742'DB:business_master_new
loadtime:3.9023230075836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:3.9023690223694 / seconds
Query Executed:select id FROM `va` where city='Rose Hill' && SIC_code='0742'DB:business_master_new
loadtime:3.9193210601807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:3.9193761348724 / seconds
Query Executed:select id FROM `va` where city='Rosedale' && SIC_code='0742'DB:business_master_new
loadtime:3.9272789955139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:3.9273331165314 / seconds
Query Executed:select id FROM `va` where city='Roseland' && SIC_code='0742'DB:business_master_new
loadtime:3.9407291412354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Hill' limit 1
loadtime:3.9407920837402 / seconds
Query Executed:select id FROM `va` where city='Round Hill' && SIC_code='0742'DB:business_master_new
loadtime:3.9418489933014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:3.9418969154358 / seconds
Query Executed:select id FROM `va` where city='Rowe' && SIC_code='0742'DB:business_master_new
loadtime:3.9425659179688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:3.9426031112671 / seconds
Query Executed:select id FROM `va` where city='Ruby' && SIC_code='0742'DB:business_master_new
loadtime:3.9435410499573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruckersville' limit 1
loadtime:3.9435760974884 / seconds
Query Executed:select id FROM `va` where city='Ruckersville' && SIC_code='0742'DB:business_master_new
loadtime:3.9445149898529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Retreat' limit 1
loadtime:3.9445559978485 / seconds
Query Executed:select id FROM `va` where city='Rural Retreat' && SIC_code='0742'DB:business_master_new
loadtime:3.9454641342163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rustburg' limit 1
loadtime:3.945513010025 / seconds
Query Executed:select id FROM `va` where city='Rustburg' && SIC_code='0742'DB:business_master_new
loadtime:3.9464571475983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruther Glen' limit 1
loadtime:3.9464859962463 / seconds
Query Executed:select id FROM `va` where city='Ruther Glen' && SIC_code='0742'DB:business_master_new
loadtime:3.9474220275879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthville' limit 1
loadtime:3.9474771022797 / seconds
Query Executed:select id FROM `va` where city='Ruthville' && SIC_code='0742'DB:business_master_new
loadtime:3.9480769634247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:3.9481201171875 / seconds
Query Executed:select id FROM `va` where city='Saint Charles' && SIC_code='0742'DB:business_master_new
loadtime:3.9505939483643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:3.9506371021271 / seconds
Query Executed:select id FROM `va` where city='Saint Paul' && SIC_code='0742'DB:business_master_new
loadtime:3.9514420032501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens Church' limit 1
loadtime:3.9514739513397 / seconds
Query Executed:select id FROM `va` where city='Saint Stephens Church' && SIC_code='0742'DB:business_master_new
loadtime:3.9572529792786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:3.957307100296 / seconds
Query Executed:select id FROM `va` where city='Salem' && SIC_code='0742'DB:business_master_new
loadtime:3.959156036377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltville' limit 1
loadtime:3.9592220783234 / seconds
Query Executed:select id FROM `va` where city='Saltville' && SIC_code='0742'DB:business_master_new
loadtime:3.9600880146027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:3.9601409435272 / seconds
Query Executed:select id FROM `va` where city='Saluda' && SIC_code='0742'DB:business_master_new
loadtime:3.9609940052032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandston' limit 1
loadtime:3.9610381126404 / seconds
Query Executed:select id FROM `va` where city='Sandston' && SIC_code='0742'DB:business_master_new
loadtime:3.9622149467468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:3.96226811409 / seconds
Query Executed:select id FROM `va` where city='Sandy Hook' && SIC_code='0742'DB:business_master_new
loadtime:3.9659569263458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Level' limit 1
loadtime:3.9660069942474 / seconds
Query Executed:select id FROM `va` where city='Sandy Level' && SIC_code='0742'DB:business_master_new
loadtime:3.967983007431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Point' limit 1
loadtime:3.968022108078 / seconds
Query Executed:select id FROM `va` where city='Sandy Point' && SIC_code='0742'DB:business_master_new
loadtime:3.9687299728394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:3.9687659740448 / seconds
Query Executed:select id FROM `va` where city='Sanford' && SIC_code='0742'DB:business_master_new
loadtime:3.9704239368439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxe' limit 1
loadtime:3.9704489707947 / seconds
Query Executed:select id FROM `va` where city='Saxe' && SIC_code='0742'DB:business_master_new
loadtime:3.9732830524445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxis' limit 1
loadtime:3.973335981369 / seconds
Query Executed:select id FROM `va` where city='Saxis' && SIC_code='0742'DB:business_master_new
loadtime:3.9762670993805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schley' limit 1
loadtime:3.976310968399 / seconds
Query Executed:select id FROM `va` where city='Schley' && SIC_code='0742'DB:business_master_new
loadtime:3.9774091243744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schuyler' limit 1
loadtime:3.9774601459503 / seconds
Query Executed:select id FROM `va` where city='Schuyler' && SIC_code='0742'DB:business_master_new
loadtime:3.987496137619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsburg' limit 1
loadtime:3.9875500202179 / seconds
Query Executed:select id FROM `va` where city='Scottsburg' && SIC_code='0742'DB:business_master_new
loadtime:4.0020620822906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsville' limit 1
loadtime:4.002110004425 / seconds
Query Executed:select id FROM `va` where city='Scottsville' && SIC_code='0742'DB:business_master_new
loadtime:4.0030450820923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaford' limit 1
loadtime:4.0030951499939 / seconds
Query Executed:select id FROM `va` where city='Seaford' && SIC_code='0742'DB:business_master_new
loadtime:4.0038230419159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealston' limit 1
loadtime:4.0038509368896 / seconds
Query Executed:select id FROM `va` where city='Sealston' && SIC_code='0742'DB:business_master_new
loadtime:4.0049319267273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaview' limit 1
loadtime:4.0049729347229 / seconds
Query Executed:select id FROM `va` where city='Seaview' && SIC_code='0742'DB:business_master_new
loadtime:4.0057220458984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedley' limit 1
loadtime:4.0057599544525 / seconds
Query Executed:select id FROM `va` where city='Sedley' && SIC_code='0742'DB:business_master_new
loadtime:4.0127611160278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:4.0128149986267 / seconds
Query Executed:select id FROM `va` where city='Selma' && SIC_code='0742'DB:business_master_new
loadtime:4.0140340328217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Corners' limit 1
loadtime:4.0140700340271 / seconds
Query Executed:select id FROM `va` where city='Seven Corners' && SIC_code='0742'DB:business_master_new
loadtime:4.0143921375275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Mile Ford' limit 1
loadtime:4.0144419670105 / seconds
Query Executed:select id FROM `va` where city='Seven Mile Ford' && SIC_code='0742'DB:business_master_new
loadtime:4.0147459506989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:4.0147800445557 / seconds
Query Executed:select id FROM `va` where city='Severn' && SIC_code='0742'DB:business_master_new
loadtime:4.0150859355927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shacklefords' limit 1
loadtime:4.0151269435883 / seconds
Query Executed:select id FROM `va` where city='Shacklefords' && SIC_code='0742'DB:business_master_new
loadtime:4.0197439193726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharps' limit 1
loadtime:4.0197789669037 / seconds
Query Executed:select id FROM `va` where city='Sharps' && SIC_code='0742'DB:business_master_new
loadtime:4.0212750434875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawsville' limit 1
loadtime:4.0213310718536 / seconds
Query Executed:select id FROM `va` where city='Shawsville' && SIC_code='0742'DB:business_master_new
loadtime:4.0220310688019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:4.0220720767975 / seconds
Query Executed:select id FROM `va` where city='Shelby' && SIC_code='0742'DB:business_master_new
loadtime:4.0225131511688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:4.0225539207458 / seconds
Query Executed:select id FROM `va` where city='Shenandoah' && SIC_code='0742'DB:business_master_new
loadtime:4.0233490467072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah Cvrns' limit 1
loadtime:4.0233910083771 / seconds
Query Executed:select id FROM `va` where city='Shenandoah Cvrns' && SIC_code='0742'DB:business_master_new
loadtime:4.0236439704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherando' limit 1
loadtime:4.0236790180206 / seconds
Query Executed:select id FROM `va` where city='Sherando' && SIC_code='0742'DB:business_master_new
loadtime:4.0239539146423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:4.0240039825439 / seconds
Query Executed:select id FROM `va` where city='Shiloh' && SIC_code='0742'DB:business_master_new
loadtime:4.024246931076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shipman' limit 1
loadtime:4.0242819786072 / seconds
Query Executed:select id FROM `va` where city='Shipman' && SIC_code='0742'DB:business_master_new
loadtime:4.0290169715881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shortt Gap' limit 1
loadtime:4.0290451049805 / seconds
Query Executed:select id FROM `va` where city='Shortt Gap' && SIC_code='0742'DB:business_master_new
loadtime:4.0293409824371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Singers Glen' limit 1
loadtime:4.0293819904327 / seconds
Query Executed:select id FROM `va` where city='Singers Glen' && SIC_code='0742'DB:business_master_new
loadtime:4.032576084137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skippers' limit 1
loadtime:4.0326130390167 / seconds
Query Executed:select id FROM `va` where city='Skippers' && SIC_code='0742'DB:business_master_new
loadtime:4.0364010334015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipwith' limit 1
loadtime:4.036453962326 / seconds
Query Executed:select id FROM `va` where city='Skipwith' && SIC_code='0742'DB:business_master_new
loadtime:4.0441000461578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:4.0441470146179 / seconds
Query Executed:select id FROM `va` where city='Smithfield' && SIC_code='0742'DB:business_master_new
loadtime:4.0454061031342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snell' limit 1
loadtime:4.0454559326172 / seconds
Query Executed:select id FROM `va` where city='Snell' && SIC_code='0742'DB:business_master_new
loadtime:4.0458590984344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:4.0459001064301 / seconds
Query Executed:select id FROM `va` where city='Somerset' && SIC_code='0742'DB:business_master_new
loadtime:4.0489029884338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:4.0489649772644 / seconds
Query Executed:select id FROM `va` where city='Somerville' && SIC_code='0742'DB:business_master_new
loadtime:4.0492920875549 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:4.0493431091309 / seconds
Query Executed:select id FROM `va` where city='South Boston' && SIC_code='0742'DB:business_master_new
loadtime:4.0507040023804 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hill' limit 1
loadtime:4.0507531166077 / seconds
Query Executed:select id FROM `va` where city='South Hill' && SIC_code='0742'DB:business_master_new
loadtime:4.0519230365753 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Riding' limit 1
loadtime:4.0519909858704 / seconds
Query Executed:select id FROM `va` where city='South Riding' && SIC_code='0742'DB:business_master_new
loadtime:4.0535061359406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:4.0535719394684 / seconds
Query Executed:select id FROM `va` where city='Sparta' && SIC_code='0742'DB:business_master_new
loadtime:4.0546729564667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speedwell' limit 1
loadtime:4.0547170639038 / seconds
Query Executed:select id FROM `va` where city='Speedwell' && SIC_code='0742'DB:business_master_new
loadtime:4.0568640232086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:4.0569040775299 / seconds
Query Executed:select id FROM `va` where city='Spencer' && SIC_code='0742'DB:business_master_new
loadtime:4.0665469169617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperryville' limit 1
loadtime:4.0665991306305 / seconds
Query Executed:select id FROM `va` where city='Sperryville' && SIC_code='0742'DB:business_master_new
loadtime:4.0674040317535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotsylvania' limit 1
loadtime:4.0674350261688 / seconds
Query Executed:select id FROM `va` where city='Spotsylvania' && SIC_code='0742'DB:business_master_new
loadtime:4.0687611103058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spout Spring' limit 1
loadtime:4.0688099861145 / seconds
Query Executed:select id FROM `va` where city='Spout Spring' && SIC_code='0742'DB:business_master_new
loadtime:4.0727100372314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Grove' limit 1
loadtime:4.0727670192719 / seconds
Query Executed:select id FROM `va` where city='Spring Grove' && SIC_code='0742'DB:business_master_new
loadtime:4.0800430774689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:4.0800919532776 / seconds
Query Executed:select id FROM `va` where city='Springfield' && SIC_code='0742'DB:business_master_new
loadtime:4.0910229682922 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:4.0910980701447 / seconds
Query Executed:select id FROM `va` where city='St Charles' && SIC_code='0742'DB:business_master_new
loadtime:4.0916700363159 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:4.091717004776 / seconds
Query Executed:select id FROM `va` where city='St Paul' && SIC_code='0742'DB:business_master_new
loadtime:4.092080116272 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens Chr' limit 1
loadtime:4.0921070575714 / seconds
Query Executed:select id FROM `va` where city='St Stephens Chr' && SIC_code='0742'DB:business_master_new
loadtime:4.0925600528717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:4.0926120281219 / seconds
Query Executed:select id FROM `va` where city='Stafford' && SIC_code='0742'DB:business_master_new
loadtime:4.0942051410675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordsville' limit 1
loadtime:4.0942630767822 / seconds
Query Executed:select id FROM `va` where city='Staffordsville' && SIC_code='0742'DB:business_master_new
loadtime:4.0951449871063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanardsville' limit 1
loadtime:4.0951931476593 / seconds
Query Executed:select id FROM `va` where city='Stanardsville' && SIC_code='0742'DB:business_master_new
loadtime:4.0961301326752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:4.0961780548096 / seconds
Query Executed:select id FROM `va` where city='Stanley' && SIC_code='0742'DB:business_master_new
loadtime:4.0968899726868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanleytown' limit 1
loadtime:4.0969431400299 / seconds
Query Executed:select id FROM `va` where city='Stanleytown' && SIC_code='0742'DB:business_master_new
loadtime:4.1018271446228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Tannery' limit 1
loadtime:4.1018669605255 / seconds
Query Executed:select id FROM `va` where city='Star Tannery' && SIC_code='0742'DB:business_master_new
loadtime:4.1033930778503 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Farm' limit 1
loadtime:4.1034381389618 / seconds
Query Executed:select id FROM `va` where city='State Farm' && SIC_code='0742'DB:business_master_new
loadtime:4.1044390201569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staunton' limit 1
loadtime:4.1044859886169 / seconds
Query Executed:select id FROM `va` where city='Staunton' && SIC_code='0742'DB:business_master_new
loadtime:4.1063239574432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steeles Tavern' limit 1
loadtime:4.1063690185547 / seconds
Query Executed:select id FROM `va` where city='Steeles Tavern' && SIC_code='0742'DB:business_master_new
loadtime:4.1099569797516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephens City' limit 1
loadtime:4.1100170612335 / seconds
Query Executed:select id FROM `va` where city='Stephens City' && SIC_code='0742'DB:business_master_new
loadtime:4.1110870838165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:4.1111330986023 / seconds
Query Executed:select id FROM `va` where city='Stephenson' && SIC_code='0742'DB:business_master_new
loadtime:4.120621919632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:4.1206710338593 / seconds
Query Executed:select id FROM `va` where city='Sterling' && SIC_code='0742'DB:business_master_new
loadtime:4.1316080093384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensburg' limit 1
loadtime:4.1316690444946 / seconds
Query Executed:select id FROM `va` where city='Stevensburg' && SIC_code='0742'DB:business_master_new
loadtime:4.1328890323639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:4.1329381465912 / seconds
Query Executed:select id FROM `va` where city='Stevensville' && SIC_code='0742'DB:business_master_new
loadtime:4.133994102478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Ridge' limit 1
loadtime:4.1340401172638 / seconds
Query Executed:select id FROM `va` where city='Stone Ridge' && SIC_code='0742'DB:business_master_new
loadtime:4.1343071460724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonega' limit 1
loadtime:4.1343460083008 / seconds
Query Executed:select id FROM `va` where city='Stonega' && SIC_code='0742'DB:business_master_new
loadtime:4.1345729827881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Creek' limit 1
loadtime:4.1346089839935 / seconds
Query Executed:select id FROM `va` where city='Stony Creek' && SIC_code='0742'DB:business_master_new
loadtime:4.1352751255035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strasburg' limit 1
loadtime:4.1353170871735 / seconds
Query Executed:select id FROM `va` where city='Strasburg' && SIC_code='0742'DB:business_master_new
loadtime:4.1363470554352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:4.136402130127 / seconds
Query Executed:select id FROM `va` where city='Stratford' && SIC_code='0742'DB:business_master_new
loadtime:4.1366970539093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:4.1367330551147 / seconds
Query Executed:select id FROM `va` where city='Stuart' && SIC_code='0742'DB:business_master_new
loadtime:4.1377820968628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuarts Draft' limit 1
loadtime:4.1378269195557 / seconds
Query Executed:select id FROM `va` where city='Stuarts Draft' && SIC_code='0742'DB:business_master_new
loadtime:4.1387760639191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:4.1388320922852 / seconds
Query Executed:select id FROM `va` where city='Studley' && SIC_code='0742'DB:business_master_new
loadtime:4.1399490833282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffolk' limit 1
loadtime:4.140016078949 / seconds
Query Executed:select id FROM `va` where city='Suffolk' && SIC_code='0742'DB:business_master_new
loadtime:4.1417639255524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:4.1418340206146 / seconds
Query Executed:select id FROM `va` where city='Sugar Grove' && SIC_code='0742'DB:business_master_new
loadtime:4.1460011005402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumerduck' limit 1
loadtime:4.1460480690002 / seconds
Query Executed:select id FROM `va` where city='Sumerduck' && SIC_code='0742'DB:business_master_new
loadtime:4.1555471420288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:4.1555891036987 / seconds
Query Executed:select id FROM `va` where city='Supply' && SIC_code='0742'DB:business_master_new
loadtime:4.1559081077576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:4.155974149704 / seconds
Query Executed:select id FROM `va` where city='Surry' && SIC_code='0742'DB:business_master_new
loadtime:4.1568150520325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susan' limit 1
loadtime:4.1568529605865 / seconds
Query Executed:select id FROM `va` where city='Susan' && SIC_code='0742'DB:business_master_new
loadtime:4.1574800014496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:4.1575269699097 / seconds
Query Executed:select id FROM `va` where city='Sussex' && SIC_code='0742'DB:business_master_new
loadtime:4.1600151062012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:4.1600689888 / seconds
Query Executed:select id FROM `va` where city='Sutherland' && SIC_code='0742'DB:business_master_new
loadtime:4.1697900295258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherlin' limit 1
loadtime:4.1698551177979 / seconds
Query Executed:select id FROM `va` where city='Sutherlin' && SIC_code='0742'DB:business_master_new
loadtime:4.1735999584198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Briar' limit 1
loadtime:4.1736481189728 / seconds
Query Executed:select id FROM `va` where city='Sweet Briar' && SIC_code='0742'DB:business_master_new
loadtime:4.1755630970001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swoope' limit 1
loadtime:4.175614118576 / seconds
Query Executed:select id FROM `va` where city='Swoope' && SIC_code='0742'DB:business_master_new
loadtime:4.1817100048065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swords Creek' limit 1
loadtime:4.1817469596863 / seconds
Query Executed:select id FROM `va` where city='Swords Creek' && SIC_code='0742'DB:business_master_new
loadtime:4.1866209506989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syria' limit 1
loadtime:4.1866710186005 / seconds
Query Executed:select id FROM `va` where city='Syria' && SIC_code='0742'DB:business_master_new
loadtime:4.1874930858612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syringa' limit 1
loadtime:4.1875340938568 / seconds
Query Executed:select id FROM `va` where city='Syringa' && SIC_code='0742'DB:business_master_new
loadtime:4.1877961158752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabb' limit 1
loadtime:4.1878259181976 / seconds
Query Executed:select id FROM `va` where city='Tabb' && SIC_code='0742'DB:business_master_new
loadtime:4.189423084259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tangier' limit 1
loadtime:4.1894669532776 / seconds
Query Executed:select id FROM `va` where city='Tangier' && SIC_code='0742'DB:business_master_new
loadtime:4.1926901340485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tannersville' limit 1
loadtime:4.192734003067 / seconds
Query Executed:select id FROM `va` where city='Tannersville' && SIC_code='0742'DB:business_master_new
loadtime:4.1930871009827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tappahannock' limit 1
loadtime:4.1931159496307 / seconds
Query Executed:select id FROM `va` where city='Tappahannock' && SIC_code='0742'DB:business_master_new
loadtime:4.1942050457001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tasley' limit 1
loadtime:4.1942579746246 / seconds
Query Executed:select id FROM `va` where city='Tasley' && SIC_code='0742'DB:business_master_new
loadtime:4.1983671188354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tazewell' limit 1
loadtime:4.1984169483185 / seconds
Query Executed:select id FROM `va` where city='Tazewell' && SIC_code='0742'DB:business_master_new
loadtime:4.1999521255493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperanceville' limit 1
loadtime:4.2000119686127 / seconds
Query Executed:select id FROM `va` where city='Temperanceville' && SIC_code='0742'DB:business_master_new
loadtime:4.2050430774689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:4.2051050662994 / seconds
Query Executed:select id FROM `va` where city='Thaxton' && SIC_code='0742'DB:business_master_new
loadtime:4.2118790149689 / seconds
Query loaded from cache:select * from geodata_geocity where city='The Plains' limit 1
loadtime:4.2119390964508 / seconds
Query Executed:select id FROM `va` where city='The Plains' && SIC_code='0742'DB:business_master_new
loadtime:4.2126989364624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:4.2127439975739 / seconds
Query Executed:select id FROM `va` where city='Thornburg' && SIC_code='0742'DB:business_master_new
loadtime:4.2189390659332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberville' limit 1
loadtime:4.2189891338348 / seconds
Query Executed:select id FROM `va` where city='Timberville' && SIC_code='0742'DB:business_master_new
loadtime:4.2198059558868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toano' limit 1
loadtime:4.2198519706726 / seconds
Query Executed:select id FROM `va` where city='Toano' && SIC_code='0742'DB:business_master_new
loadtime:4.2206239700317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms Brook' limit 1
loadtime:4.2206690311432 / seconds
Query Executed:select id FROM `va` where city='Toms Brook' && SIC_code='0742'DB:business_master_new
loadtime:4.2292759418488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topping' limit 1
loadtime:4.2293210029602 / seconds
Query Executed:select id FROM `va` where city='Topping' && SIC_code='0742'DB:business_master_new
loadtime:4.2370040416718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:4.2370710372925 / seconds
Query Executed:select id FROM `va` where city='Townsend' && SIC_code='0742'DB:business_master_new
loadtime:4.2381570339203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trammel' limit 1
loadtime:4.2382011413574 / seconds
Query Executed:select id FROM `va` where city='Trammel' && SIC_code='0742'DB:business_master_new
loadtime:4.2387781143188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevilians' limit 1
loadtime:4.2388520240784 / seconds
Query Executed:select id FROM `va` where city='Trevilians' && SIC_code='0742'DB:business_master_new
loadtime:4.2391221523285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triangle' limit 1
loadtime:4.2391519546509 / seconds
Query Executed:select id FROM `va` where city='Triangle' && SIC_code='0742'DB:business_master_new
loadtime:4.2398431301117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Triplet' limit 1
loadtime:4.2398989200592 / seconds
Query Executed:select id FROM `va` where city='Triplet' && SIC_code='0742'DB:business_master_new
loadtime:4.2402069568634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Dale' limit 1
loadtime:4.2402589321136 / seconds
Query Executed:select id FROM `va` where city='Trout Dale' && SIC_code='0742'DB:business_master_new
loadtime:4.2405109405518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutdale' limit 1
loadtime:4.2405951023102 / seconds
Query Executed:select id FROM `va` where city='Troutdale' && SIC_code='0742'DB:business_master_new
loadtime:4.2442240715027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutville' limit 1
loadtime:4.2442741394043 / seconds
Query Executed:select id FROM `va` where city='Troutville' && SIC_code='0742'DB:business_master_new
loadtime:4.2454121112823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:4.2454690933228 / seconds
Query Executed:select id FROM `va` where city='Troy' && SIC_code='0742'DB:business_master_new
loadtime:4.2463121414185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turbeville' limit 1
loadtime:4.2463531494141 / seconds
Query Executed:select id FROM `va` where city='Turbeville' && SIC_code='0742'DB:business_master_new
loadtime:4.2466609477997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:4.2466950416565 / seconds
Query Executed:select id FROM `va` where city='Tyro' && SIC_code='0742'DB:business_master_new
loadtime:4.2476921081543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Hall' limit 1
loadtime:4.2477369308472 / seconds
Query Executed:select id FROM `va` where city='Union Hall' && SIC_code='0742'DB:business_master_new
loadtime:4.2554271221161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:4.2554879188538 / seconds
Query Executed:select id FROM `va` where city='Unionville' && SIC_code='0742'DB:business_master_new
loadtime:4.2661731243134 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Of Richmond' limit 1
loadtime:4.2662320137024 / seconds
Query Executed:select id FROM `va` where city='University Of Richmond' && SIC_code='0742'DB:business_master_new
loadtime:4.2665250301361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upperville' limit 1
loadtime:4.266566991806 / seconds
Query Executed:select id FROM `va` where city='Upperville' && SIC_code='0742'DB:business_master_new
loadtime:4.2672550678253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbanna' limit 1
loadtime:4.267324924469 / seconds
Query Executed:select id FROM `va` where city='Urbanna' && SIC_code='0742'DB:business_master_new
loadtime:4.2680339813232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentines' limit 1
loadtime:4.268070936203 / seconds
Query Executed:select id FROM `va` where city='Valentines' && SIC_code='0742'DB:business_master_new
loadtime:4.2705600261688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vansant' limit 1
loadtime:4.2706079483032 / seconds
Query Executed:select id FROM `va` where city='Vansant' && SIC_code='0742'DB:business_master_new
loadtime:4.2712850570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Hill' limit 1
loadtime:4.2713489532471 / seconds
Query Executed:select id FROM `va` where city='Vernon Hill' && SIC_code='0742'DB:business_master_new
loadtime:4.2739219665527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:4.2739651203156 / seconds
Query Executed:select id FROM `va` where city='Verona' && SIC_code='0742'DB:business_master_new
loadtime:4.2749171257019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesta' limit 1
loadtime:4.2749741077423 / seconds
Query Executed:select id FROM `va` where city='Vesta' && SIC_code='0742'DB:business_master_new
loadtime:4.2763359546661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesuvius' limit 1
loadtime:4.2763769626617 / seconds
Query Executed:select id FROM `va` where city='Vesuvius' && SIC_code='0742'DB:business_master_new
loadtime:4.2790689468384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:4.2791180610657 / seconds
Query Executed:select id FROM `va` where city='Victoria' && SIC_code='0742'DB:business_master_new
loadtime:4.2800641059875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:4.2801060676575 / seconds
Query Executed:select id FROM `va` where city='Vienna' && SIC_code='0742'DB:business_master_new
loadtime:4.2910690307617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viewtown' limit 1
loadtime:4.2911350727081 / seconds
Query Executed:select id FROM `va` where city='Viewtown' && SIC_code='0742'DB:business_master_new
loadtime:4.291445016861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village' limit 1
loadtime:4.2914841175079 / seconds
Query Executed:select id FROM `va` where city='Village' && SIC_code='0742'DB:business_master_new
loadtime:4.2923939228058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villamont' limit 1
loadtime:4.2924349308014 / seconds
Query Executed:select id FROM `va` where city='Villamont' && SIC_code='0742'DB:business_master_new
loadtime:4.2933440208435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vint Hill Farms' limit 1
loadtime:4.2933809757233 / seconds
Query Executed:select id FROM `va` where city='Vint Hill Farms' && SIC_code='0742'DB:business_master_new
loadtime:4.2936251163483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:4.2936611175537 / seconds
Query Executed:select id FROM `va` where city='Vinton' && SIC_code='0742'DB:business_master_new
loadtime:4.2946529388428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgilina' limit 1
loadtime:4.2947061061859 / seconds
Query Executed:select id FROM `va` where city='Virgilina' && SIC_code='0742'DB:business_master_new
loadtime:4.3008029460907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virginia Beach' limit 1
loadtime:4.3008480072021 / seconds
Query Executed:select id FROM `va` where city='Virginia Beach' && SIC_code='0742'DB:business_master_new
loadtime:4.3097219467163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wachapreague' limit 1
loadtime:4.3098649978638 / seconds
Query Executed:select id FROM `va` where city='Wachapreague' && SIC_code='0742'DB:business_master_new
loadtime:4.3129301071167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake' limit 1
loadtime:4.3129849433899 / seconds
Query Executed:select id FROM `va` where city='Wake' && SIC_code='0742'DB:business_master_new
loadtime:4.3137099742889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:4.3137509822845 / seconds
Query Executed:select id FROM `va` where city='Wakefield' && SIC_code='0742'DB:business_master_new
loadtime:4.3144879341125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerton' limit 1
loadtime:4.3145179748535 / seconds
Query Executed:select id FROM `va` where city='Walkerton' && SIC_code='0742'DB:business_master_new
loadtime:4.3176760673523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallops Island' limit 1
loadtime:4.3177189826965 / seconds
Query Executed:select id FROM `va` where city='Wallops Island' && SIC_code='0742'DB:business_master_new
loadtime:4.3207869529724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walters' limit 1
loadtime:4.320827960968 / seconds
Query Executed:select id FROM `va` where city='Walters' && SIC_code='0742'DB:business_master_new
loadtime:4.3211319446564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wardtown' limit 1
loadtime:4.3211641311646 / seconds
Query Executed:select id FROM `va` where city='Wardtown' && SIC_code='0742'DB:business_master_new
loadtime:4.3214299678802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware Neck' limit 1
loadtime:4.3214700222015 / seconds
Query Executed:select id FROM `va` where city='Ware Neck' && SIC_code='0742'DB:business_master_new
loadtime:4.3220069408417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warfield' limit 1
loadtime:4.3220541477203 / seconds
Query Executed:select id FROM `va` where city='Warfield' && SIC_code='0742'DB:business_master_new
loadtime:4.3238041400909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warm Springs' limit 1
loadtime:4.3238749504089 / seconds
Query Executed:select id FROM `va` where city='Warm Springs' && SIC_code='0742'DB:business_master_new
loadtime:4.3299610614777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:4.3300211429596 / seconds
Query Executed:select id FROM `va` where city='Warner' && SIC_code='0742'DB:business_master_new
loadtime:4.3302919864655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:4.3303380012512 / seconds
Query Executed:select id FROM `va` where city='Warrenton' && SIC_code='0742'DB:business_master_new
loadtime:4.3318920135498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:4.3320360183716 / seconds
Query Executed:select id FROM `va` where city='Warsaw' && SIC_code='0742'DB:business_master_new
loadtime:4.333722114563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:4.3337740898132 / seconds
Query Executed:select id FROM `va` where city='Washington' && SIC_code='0742'DB:business_master_new
loadtime:4.3345210552216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water View' limit 1
loadtime:4.3345649242401 / seconds
Query Executed:select id FROM `va` where city='Water View' && SIC_code='0742'DB:business_master_new
loadtime:4.3350579738617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:4.3351149559021 / seconds
Query Executed:select id FROM `va` where city='Waterford' && SIC_code='0742'DB:business_master_new
loadtime:4.342483997345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:4.3425319194794 / seconds
Query Executed:select id FROM `va` where city='Wattsville' && SIC_code='0742'DB:business_master_new
loadtime:4.3431060314178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:4.3431649208069 / seconds
Query Executed:select id FROM `va` where city='Waverly' && SIC_code='0742'DB:business_master_new
loadtime:4.3438899517059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:4.3439660072327 / seconds
Query Executed:select id FROM `va` where city='Waynesboro' && SIC_code='0742'DB:business_master_new
loadtime:4.3452401161194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weber City' limit 1
loadtime:4.3452889919281 / seconds
Query Executed:select id FROM `va` where city='Weber City' && SIC_code='0742'DB:business_master_new
loadtime:4.3459811210632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weems' limit 1
loadtime:4.3460509777069 / seconds
Query Executed:select id FROM `va` where city='Weems' && SIC_code='0742'DB:business_master_new
loadtime:4.3517460823059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weirwood' limit 1
loadtime:4.3517949581146 / seconds
Query Executed:select id FROM `va` where city='Weirwood' && SIC_code='0742'DB:business_master_new
loadtime:4.3523070812225 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Augusta' limit 1
loadtime:4.352343082428 / seconds
Query Executed:select id FROM `va` where city='West Augusta' && SIC_code='0742'DB:business_master_new
loadtime:4.3528981208801 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mclean' limit 1
loadtime:4.3529570102692 / seconds
Query Executed:select id FROM `va` where city='West Mclean' && SIC_code='0742'DB:business_master_new
loadtime:4.3553109169006 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:4.3553550243378 / seconds
Query Executed:select id FROM `va` where city='West Point' && SIC_code='0742'DB:business_master_new
loadtime:4.35631108284 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:4.3563570976257 / seconds
Query Executed:select id FROM `va` where city='West Springfield' && SIC_code='0742'DB:business_master_new
loadtime:4.3566110134125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:4.3566379547119 / seconds
Query Executed:select id FROM `va` where city='Westmoreland' && SIC_code='0742'DB:business_master_new
loadtime:4.3569021224976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyers Cave' limit 1
loadtime:4.3569440841675 / seconds
Query Executed:select id FROM `va` where city='Weyers Cave' && SIC_code='0742'DB:business_master_new
loadtime:4.3579440116882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitacre' limit 1
loadtime:4.3579890727997 / seconds
Query Executed:select id FROM `va` where city='Whitacre' && SIC_code='0742'DB:business_master_new
loadtime:4.358598947525 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Hall' limit 1
loadtime:4.3586399555206 / seconds
Query Executed:select id FROM `va` where city='White Hall' && SIC_code='0742'DB:business_master_new
loadtime:4.3589570522308 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Marsh' limit 1
loadtime:4.3590049743652 / seconds
Query Executed:select id FROM `va` where city='White Marsh' && SIC_code='0742'DB:business_master_new
loadtime:4.3644020557404 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:4.3644509315491 / seconds
Query Executed:select id FROM `va` where city='White Plains' && SIC_code='0742'DB:business_master_new
loadtime:4.3652760982513 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Post' limit 1
loadtime:4.3653230667114 / seconds
Query Executed:select id FROM `va` where city='White Post' && SIC_code='0742'DB:business_master_new
loadtime:4.3737320899963 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Stone' limit 1
loadtime:4.3737909793854 / seconds
Query Executed:select id FROM `va` where city='White Stone' && SIC_code='0742'DB:business_master_new
loadtime:4.3746430873871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitetop' limit 1
loadtime:4.3747079372406 / seconds
Query Executed:select id FROM `va` where city='Whitetop' && SIC_code='0742'DB:business_master_new
loadtime:4.3758299350739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:4.3758840560913 / seconds
Query Executed:select id FROM `va` where city='Whitewood' && SIC_code='0742'DB:business_master_new
loadtime:4.3776149749756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico' limit 1
loadtime:4.3776519298553 / seconds
Query Executed:select id FROM `va` where city='Wicomico' && SIC_code='0742'DB:business_master_new
loadtime:4.3795239925385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wicomico Church' limit 1
loadtime:4.3795700073242 / seconds
Query Executed:select id FROM `va` where city='Wicomico Church' && SIC_code='0742'DB:business_master_new
loadtime:4.3823499679565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:4.382395029068 / seconds
Query Executed:select id FROM `va` where city='Williamsburg' && SIC_code='0742'DB:business_master_new
loadtime:4.3849489688873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsville' limit 1
loadtime:4.3850059509277 / seconds
Query Executed:select id FROM `va` where city='Williamsville' && SIC_code='0742'DB:business_master_new
loadtime:4.386116027832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:4.386157989502 / seconds
Query Executed:select id FROM `va` where city='Willis' && SIC_code='0742'DB:business_master_new
loadtime:4.396693944931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis Wharf' limit 1
loadtime:4.3967480659485 / seconds
Query Executed:select id FROM `va` where city='Willis Wharf' && SIC_code='0742'DB:business_master_new
loadtime:4.3991560935974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons' limit 1
loadtime:4.3992209434509 / seconds
Query Executed:select id FROM `va` where city='Wilsons' && SIC_code='0742'DB:business_master_new
loadtime:4.3997309207916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:4.3997740745544 / seconds
Query Executed:select id FROM `va` where city='Winchester' && SIC_code='0742'DB:business_master_new
loadtime:4.4030849933624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:4.4031491279602 / seconds
Query Executed:select id FROM `va` where city='Windsor' && SIC_code='0742'DB:business_master_new
loadtime:4.4038751125336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingina' limit 1
loadtime:4.4039361476898 / seconds
Query Executed:select id FROM `va` where city='Wingina' && SIC_code='0742'DB:business_master_new
loadtime:4.4048879146576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wintergreen' limit 1
loadtime:4.4049501419067 / seconds
Query Executed:select id FROM `va` where city='Wintergreen' && SIC_code='0742'DB:business_master_new
loadtime:4.4053440093994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wirtz' limit 1
loadtime:4.4053890705109 / seconds
Query Executed:select id FROM `va` where city='Wirtz' && SIC_code='0742'DB:business_master_new
loadtime:4.4060709476471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:4.4061131477356 / seconds
Query Executed:select id FROM `va` where city='Wise' && SIC_code='0742'DB:business_master_new
loadtime:4.4069640636444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withams' limit 1
loadtime:4.4070291519165 / seconds
Query Executed:select id FROM `va` where city='Withams' && SIC_code='0742'DB:business_master_new
loadtime:4.4073660373688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolford' limit 1
loadtime:4.4073989391327 / seconds
Query Executed:select id FROM `va` where city='Wolford' && SIC_code='0742'DB:business_master_new
loadtime:4.4085190296173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolftown' limit 1
loadtime:4.4085829257965 / seconds
Query Executed:select id FROM `va` where city='Wolftown' && SIC_code='0742'DB:business_master_new
loadtime:4.4100580215454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodberry Forest' limit 1
loadtime:4.4100949764252 / seconds
Query Executed:select id FROM `va` where city='Woodberry Forest' && SIC_code='0742'DB:business_master_new
loadtime:4.4106440544128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:4.4106850624084 / seconds
Query Executed:select id FROM `va` where city='Woodbridge' && SIC_code='0742'DB:business_master_new
loadtime:4.420028924942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:4.4201121330261 / seconds
Query Executed:select id FROM `va` where city='Woodford' && SIC_code='0742'DB:business_master_new
loadtime:4.4207861423492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodlawn' limit 1
loadtime:4.4208390712738 / seconds
Query Executed:select id FROM `va` where city='Woodlawn' && SIC_code='0742'DB:business_master_new
loadtime:4.4215130805969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Rds' limit 1
loadtime:4.4215750694275 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Rds' && SIC_code='0742'DB:business_master_new
loadtime:4.4218051433563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross Roads' limit 1
loadtime:4.4218571186066 / seconds
Query Executed:select id FROM `va` where city='Woods Cross Roads' && SIC_code='0742'DB:business_master_new
loadtime:4.4223480224609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:4.4223880767822 / seconds
Query Executed:select id FROM `va` where city='Woodstock' && SIC_code='0742'DB:business_master_new
loadtime:4.4237480163574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:4.4237959384918 / seconds
Query Executed:select id FROM `va` where city='Woodville' && SIC_code='0742'DB:business_master_new
loadtime:4.4247260093689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolwine' limit 1
loadtime:4.4247660636902 / seconds
Query Executed:select id FROM `va` where city='Woolwine' && SIC_code='0742'DB:business_master_new
loadtime:4.4300360679626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wylliesburg' limit 1
loadtime:4.430104970932 / seconds
Query Executed:select id FROM `va` where city='Wylliesburg' && SIC_code='0742'DB:business_master_new
loadtime:4.4312810897827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wytheville' limit 1
loadtime:4.4313180446625 / seconds
Query Executed:select id FROM `va` where city='Wytheville' && SIC_code='0742'DB:business_master_new
loadtime:4.432461977005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:4.4325151443481 / seconds
Query Executed:select id FROM `va` where city='Yale' && SIC_code='0742'DB:business_master_new
loadtime:4.434100151062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:4.4341480731964 / seconds
Query Executed:select id FROM `va` where city='Yorktown' && SIC_code='0742'DB:business_master_new
loadtime:4.4360809326172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zacata' limit 1
loadtime:4.4361441135406 / seconds
Query Executed:select id FROM `va` where city='Zacata' && SIC_code='0742'DB:business_master_new
loadtime:4.4367251396179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zanoni' limit 1
loadtime:4.4367589950562 / seconds
Query Executed:select id FROM `va` where city='Zanoni' && SIC_code='0742'DB:business_master_new
loadtime:4.4379420280457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zuni' limit 1
loadtime:4.4379980564117 / seconds
Query Executed:select id FROM `va` where city='Zuni' && SIC_code='0742'DB:business_master_new
loadtime:4.4438910484314 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:4.444020986557 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:4.4442970752716 / seconds
Operation template executed (chunk cache operation)
loadtime:4.4443929195404 / seconds
template override:Default
loadtime:4.444412946701 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:4.4452950954437 / seconds
Template Constructed, Array Rows:49
loadtime:4.4455320835114 / seconds
TOTAL EXECUTION TIME: 4.44534
loadtime:4.4456450939178 / 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] => veterinary-services-for-animal-specialties [stateURLid] => virginia )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:4.445650100708
TOTAL KEY ARRAYS: 69