Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.7976455688477E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018060207366943 / seconds
host not found setting manual db connection
loadtime:0.0095090866088867 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097301006317139 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099251270294189 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0099990367889404 / seconds
zipcode:
loadtime:0.010029077529907 / seconds
Query Executed:select * from search_referrer where page_hash='f74cb2ba9c157264287409c6b4aea19d' limit 10 DB:ezrox_toadli
loadtime:0.010280132293701 / seconds
Operation header executed (non global)
loadtime:0.010308980941772 / seconds
Operation leaderboard executed (non global)
loadtime:0.010360956192017 / seconds
Operation square executed (non global)
loadtime:0.010390996932983 / seconds
Operation square_bottom executed (non global)
loadtime:0.010417938232422 / seconds
Operation smallsquare executed (non global)
loadtime:0.010443925857544 / seconds
Operation headeradright executed (non global)
loadtime:0.01046895980835 / seconds
Operation google_analytics executed (non global)
loadtime:0.010493993759155 / seconds
Operation topstories executed (non global)
loadtime:0.010519981384277 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010546922683716 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010571956634521 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01079797744751 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010971069335938 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011024951934814 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011096000671387 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011145114898682 / seconds
Template key: archive_menu pushed
loadtime:0.01115894317627 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011176109313965 / seconds
Template key: get_gravatar pushed
loadtime:0.011183023452759 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011192083358765 / seconds
*10)-10)+1 | start:0
loadtime:0.011234998703003 / seconds
Query loaded from cache:select * from categories where cat_URLid='general-medical-and-surgical-hospitals'
loadtime:0.011276006698608 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.011311054229736 / seconds
DB connected to localhost business_master_new
loadtime:0.011560916900635 / seconds
Query Executed:select * from `nc_catmap` where sic='8062' order by city ascDB:business_master_new
loadtime:0.036897897720337 / seconds
Query stored in cache : _QUERY_www.toadli.comd828f45257cff62bda31b1701c6a5240
loadtime:0.040169954299927 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.040242910385132 / seconds
Query Executed:select sum(totalcount) as totalsum from `nc_catmap` where sic='8062'DB:business_master_new
loadtime:0.044493913650513 / seconds
Query stored in cache : _QUERY_www.toadli.com1ffdd12647fee9197b3eed141732ec45
loadtime:0.044536113739014 / seconds
820 / 11
loadtime:0.044593095779419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.044660091400146 / seconds
Query Executed:select id FROM `nc` where city='Aberdeen' && SIC_code='8062'DB:business_master_new
loadtime:0.059394121170044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Advance' limit 1
loadtime:0.05945897102356 / seconds
Query Executed:select id FROM `nc` where city='Advance' && SIC_code='8062'DB:business_master_new
loadtime:0.064613103866577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahoskie' limit 1
loadtime:0.064675092697144 / seconds
Query Executed:select id FROM `nc` where city='Ahoskie' && SIC_code='8062'DB:business_master_new
loadtime:0.070054054260254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamance' limit 1
loadtime:0.070166110992432 / seconds
Query Executed:select id FROM `nc` where city='Alamance' && SIC_code='8062'DB:business_master_new
loadtime:0.071470022201538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albemarle' limit 1
loadtime:0.071538925170898 / seconds
Query Executed:select id FROM `nc` where city='Albemarle' && SIC_code='8062'DB:business_master_new
loadtime:0.077620029449463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albertson' limit 1
loadtime:0.077702045440674 / seconds
Query Executed:select id FROM `nc` where city='Albertson' && SIC_code='8062'DB:business_master_new
loadtime:0.078684091567993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.078740119934082 / seconds
Query Executed:select id FROM `nc` where city='Alexander' && SIC_code='8062'DB:business_master_new
loadtime:0.079991102218628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexis' limit 1
loadtime:0.080053091049194 / seconds
Query Executed:select id FROM `nc` where city='Alexis' && SIC_code='8062'DB:business_master_new
loadtime:0.080950021743774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alliance' limit 1
loadtime:0.081001996994019 / seconds
Query Executed:select id FROM `nc` where city='Alliance' && SIC_code='8062'DB:business_master_new
loadtime:0.081723928451538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almond' limit 1
loadtime:0.081775903701782 / seconds
Query Executed:select id FROM `nc` where city='Almond' && SIC_code='8062'DB:business_master_new
loadtime:0.082395076751709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamahaw' limit 1
loadtime:0.082447052001953 / seconds
Query Executed:select id FROM `nc` where city='Altamahaw' && SIC_code='8062'DB:business_master_new
loadtime:0.083014011383057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.083076000213623 / seconds
Query Executed:select id FROM `nc` where city='Andrews' && SIC_code='8062'DB:business_master_new
loadtime:0.088093996047974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angier' limit 1
loadtime:0.088164091110229 / seconds
Query Executed:select id FROM `nc` where city='Angier' && SIC_code='8062'DB:business_master_new
loadtime:0.093163967132568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonville' limit 1
loadtime:0.093223094940186 / seconds
Query Executed:select id FROM `nc` where city='Ansonville' && SIC_code='8062'DB:business_master_new
loadtime:0.094275951385498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apex' limit 1
loadtime:0.094329118728638 / seconds
Query Executed:select id FROM `nc` where city='Apex' && SIC_code='8062'DB:business_master_new
loadtime:0.099339008331299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.099391937255859 / seconds
Query Executed:select id FROM `nc` where city='Arapahoe' && SIC_code='8062'DB:business_master_new
loadtime:0.10030794143677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.10036110877991 / seconds
Query Executed:select id FROM `nc` where city='Ararat' && SIC_code='8062'DB:business_master_new
loadtime:0.10160803794861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archdale' limit 1
loadtime:0.10166001319885 / seconds
Query Executed:select id FROM `nc` where city='Archdale' && SIC_code='8062'DB:business_master_new
loadtime:0.10214805603027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arden' limit 1
loadtime:0.10220503807068 / seconds
Query Executed:select id FROM `nc` where city='Arden' && SIC_code='8062'DB:business_master_new
loadtime:0.10724401473999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash' limit 1
loadtime:0.1073100566864 / seconds
Query Executed:select id FROM `nc` where city='Ash' && SIC_code='8062'DB:business_master_new
loadtime:0.10898303985596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheboro' limit 1
loadtime:0.10904693603516 / seconds
Query Executed:select id FROM `nc` where city='Asheboro' && SIC_code='8062'DB:business_master_new
loadtime:0.11407899856567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheville' limit 1
loadtime:0.11416006088257 / seconds
Query Executed:select id FROM `nc` where city='Asheville' && SIC_code='8062'DB:business_master_new
loadtime:0.11917400360107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.11925005912781 / seconds
Query Executed:select id FROM `nc` where city='Atkinson' && SIC_code='8062'DB:business_master_new
loadtime:0.12039494514465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.12045097351074 / seconds
Query Executed:select id FROM `nc` where city='Atlantic' && SIC_code='8062'DB:business_master_new
loadtime:0.12128591537476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.1213390827179 / seconds
Query Executed:select id FROM `nc` where city='Atlantic Beach' && SIC_code='8062'DB:business_master_new
loadtime:0.12633490562439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aulander' limit 1
loadtime:0.12638807296753 / seconds
Query Executed:select id FROM `nc` where city='Aulander' && SIC_code='8062'DB:business_master_new
loadtime:0.12836313247681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.12841606140137 / seconds
Query Executed:select id FROM `nc` where city='Aurora' && SIC_code='8062'DB:business_master_new
loadtime:0.1304919719696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Autryville' limit 1
loadtime:0.13055896759033 / seconds
Query Executed:select id FROM `nc` where city='Autryville' && SIC_code='8062'DB:business_master_new
loadtime:0.13253307342529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.13258600234985 / seconds
Query Executed:select id FROM `nc` where city='Avon' && SIC_code='8062'DB:business_master_new
loadtime:0.13477611541748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayden' limit 1
loadtime:0.13482904434204 / seconds
Query Executed:select id FROM `nc` where city='Ayden' && SIC_code='8062'DB:business_master_new
loadtime:0.13983702659607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aydlett' limit 1
loadtime:0.13988995552063 / seconds
Query Executed:select id FROM `nc` where city='Aydlett' && SIC_code='8062'DB:business_master_new
loadtime:0.14046502113342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badin' limit 1
loadtime:0.14051699638367 / seconds
Query Executed:select id FROM `nc` where city='Badin' && SIC_code='8062'DB:business_master_new
loadtime:0.14158511161804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bahama' limit 1
loadtime:0.1416380405426 / seconds
Query Executed:select id FROM `nc` where city='Bahama' && SIC_code='8062'DB:business_master_new
loadtime:0.14353203773499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.14358401298523 / seconds
Query Executed:select id FROM `nc` where city='Bailey' && SIC_code='8062'DB:business_master_new
loadtime:0.14636993408203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersville' limit 1
loadtime:0.14642405509949 / seconds
Query Executed:select id FROM `nc` where city='Bakersville' && SIC_code='8062'DB:business_master_new
loadtime:0.15150690078735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bald Head Island' limit 1
loadtime:0.15156006813049 / seconds
Query Executed:select id FROM `nc` where city='Bald Head Island' && SIC_code='8062'DB:business_master_new
loadtime:0.15194606781006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam' limit 1
loadtime:0.15199589729309 / seconds
Query Executed:select id FROM `nc` where city='Balsam' && SIC_code='8062'DB:business_master_new
loadtime:0.1526141166687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam Grove' limit 1
loadtime:0.15266609191895 / seconds
Query Executed:select id FROM `nc` where city='Balsam Grove' && SIC_code='8062'DB:business_master_new
loadtime:0.15329194068909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banner Elk' limit 1
loadtime:0.15334510803223 / seconds
Query Executed:select id FROM `nc` where city='Banner Elk' && SIC_code='8062'DB:business_master_new
loadtime:0.15833902359009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barco' limit 1
loadtime:0.15839195251465 / seconds
Query Executed:select id FROM `nc` where city='Barco' && SIC_code='8062'DB:business_master_new
loadtime:0.15927290916443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barium Springs' limit 1
loadtime:0.15932607650757 / seconds
Query Executed:select id FROM `nc` where city='Barium Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.15990710258484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnardsville' limit 1
loadtime:0.15995812416077 / seconds
Query Executed:select id FROM `nc` where city='Barnardsville' && SIC_code='8062'DB:business_master_new
loadtime:0.16137909889221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnesville' limit 1
loadtime:0.16143107414246 / seconds
Query Executed:select id FROM `nc` where city='Barnesville' && SIC_code='8062'DB:business_master_new
loadtime:0.1618320941925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bat Cave' limit 1
loadtime:0.16188502311707 / seconds
Query Executed:select id FROM `nc` where city='Bat Cave' && SIC_code='8062'DB:business_master_new
loadtime:0.16256999969482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.16262197494507 / seconds
Query Executed:select id FROM `nc` where city='Bath' && SIC_code='8062'DB:business_master_new
loadtime:0.1646089553833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battleboro' limit 1
loadtime:0.16466093063354 / seconds
Query Executed:select id FROM `nc` where city='Battleboro' && SIC_code='8062'DB:business_master_new
loadtime:0.16968703269958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayboro' limit 1
loadtime:0.16974091529846 / seconds
Query Executed:select id FROM `nc` where city='Bayboro' && SIC_code='8062'DB:business_master_new
loadtime:0.17157411575317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.17162704467773 / seconds
Query Executed:select id FROM `nc` where city='Bear Creek' && SIC_code='8062'DB:business_master_new
loadtime:0.17354798316956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.17360091209412 / seconds
Query Executed:select id FROM `nc` where city='Beaufort' && SIC_code='8062'DB:business_master_new
loadtime:0.17865610122681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Mountain' limit 1
loadtime:0.1787121295929 / seconds
Query Executed:select id FROM `nc` where city='Beech Mountain' && SIC_code='8062'DB:business_master_new
loadtime:0.17911291122437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belews Creek' limit 1
loadtime:0.17916703224182 / seconds
Query Executed:select id FROM `nc` where city='Belews Creek' && SIC_code='8062'DB:business_master_new
loadtime:0.18052911758423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belhaven' limit 1
loadtime:0.18058109283447 / seconds
Query Executed:select id FROM `nc` where city='Belhaven' && SIC_code='8062'DB:business_master_new
loadtime:0.18560600280762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellarthur' limit 1
loadtime:0.18567609786987 / seconds
Query Executed:select id FROM `nc` where city='Bellarthur' && SIC_code='8062'DB:business_master_new
loadtime:0.18622207641602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.18627595901489 / seconds
Query Executed:select id FROM `nc` where city='Belmont' && SIC_code='8062'DB:business_master_new
loadtime:0.19128513336182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.19133901596069 / seconds
Query Executed:select id FROM `nc` where city='Belvidere' && SIC_code='8062'DB:business_master_new
loadtime:0.19226098060608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.19231390953064 / seconds
Query Executed:select id FROM `nc` where city='Bennett' && SIC_code='8062'DB:business_master_new
loadtime:0.19361901283264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.1936719417572 / seconds
Query Executed:select id FROM `nc` where city='Benson' && SIC_code='8062'DB:business_master_new
loadtime:0.19869208335876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer City' limit 1
loadtime:0.19876003265381 / seconds
Query Executed:select id FROM `nc` where city='Bessemer City' && SIC_code='8062'DB:business_master_new
loadtime:0.20378112792969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethania' limit 1
loadtime:0.20383596420288 / seconds
Query Executed:select id FROM `nc` where city='Bethania' && SIC_code='8062'DB:business_master_new
loadtime:0.2046229839325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.20467591285706 / seconds
Query Executed:select id FROM `nc` where city='Bethel' && SIC_code='8062'DB:business_master_new
loadtime:0.20655798912048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulaville' limit 1
loadtime:0.20661091804504 / seconds
Query Executed:select id FROM `nc` where city='Beulaville' && SIC_code='8062'DB:business_master_new
loadtime:0.21163201332092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biltmore Lake' limit 1
loadtime:0.21168494224548 / seconds
Query Executed:select id FROM `nc` where city='Biltmore Lake' && SIC_code='8062'DB:business_master_new
loadtime:0.21211004257202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biscoe' limit 1
loadtime:0.21216201782227 / seconds
Query Executed:select id FROM `nc` where city='Biscoe' && SIC_code='8062'DB:business_master_new
loadtime:0.21514391899109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Creek' limit 1
loadtime:0.21520090103149 / seconds
Query Executed:select id FROM `nc` where city='Black Creek' && SIC_code='8062'DB:business_master_new
loadtime:0.21595096588135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Mountain' limit 1
loadtime:0.21601104736328 / seconds
Query Executed:select id FROM `nc` where city='Black Mountain' && SIC_code='8062'DB:business_master_new
loadtime:0.22102999687195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bladenboro' limit 1
loadtime:0.22108292579651 / seconds
Query Executed:select id FROM `nc` where city='Bladenboro' && SIC_code='8062'DB:business_master_new
loadtime:0.22605299949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanch' limit 1
loadtime:0.2261049747467 / seconds
Query Executed:select id FROM `nc` where city='Blanch' && SIC_code='8062'DB:business_master_new
loadtime:0.22696995735168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blounts Creek' limit 1
loadtime:0.22703194618225 / seconds
Query Executed:select id FROM `nc` where city='Blounts Creek' && SIC_code='8062'DB:business_master_new
loadtime:0.22793412208557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blowing Rock' limit 1
loadtime:0.22798705101013 / seconds
Query Executed:select id FROM `nc` where city='Blowing Rock' && SIC_code='8062'DB:business_master_new
loadtime:0.23302412033081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boger City' limit 1
loadtime:0.23309397697449 / seconds
Query Executed:select id FROM `nc` where city='Boger City' && SIC_code='8062'DB:business_master_new
loadtime:0.23349809646606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.23355197906494 / seconds
Query Executed:select id FROM `nc` where city='Boiling Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.23549604415894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolivia' limit 1
loadtime:0.23554992675781 / seconds
Query Executed:select id FROM `nc` where city='Bolivia' && SIC_code='8062'DB:business_master_new
loadtime:0.24058389663696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.2406370639801 / seconds
Query Executed:select id FROM `nc` where city='Bolton' && SIC_code='8062'DB:business_master_new
loadtime:0.2420380115509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonlee' limit 1
loadtime:0.24209094047546 / seconds
Query Executed:select id FROM `nc` where city='Bonlee' && SIC_code='8062'DB:business_master_new
loadtime:0.24276900291443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boomer' limit 1
loadtime:0.24282193183899 / seconds
Query Executed:select id FROM `nc` where city='Boomer' && SIC_code='8062'DB:business_master_new
loadtime:0.24391102790833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.2439649105072 / seconds
Query Executed:select id FROM `nc` where city='Boone' && SIC_code='8062'DB:business_master_new
loadtime:0.24905204772949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boonville' limit 1
loadtime:0.24912405014038 / seconds
Query Executed:select id FROM `nc` where city='Boonville' && SIC_code='8062'DB:business_master_new
loadtime:0.25410294532776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bostic' limit 1
loadtime:0.25415802001953 / seconds
Query Executed:select id FROM `nc` where city='Bostic' && SIC_code='8062'DB:business_master_new
loadtime:0.25620794296265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdens' limit 1
loadtime:0.2562620639801 / seconds
Query Executed:select id FROM `nc` where city='Bowdens' && SIC_code='8062'DB:business_master_new
loadtime:0.25664591789246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brasstown' limit 1
loadtime:0.25669693946838 / seconds
Query Executed:select id FROM `nc` where city='Brasstown' && SIC_code='8062'DB:business_master_new
loadtime:0.25772595405579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brevard' limit 1
loadtime:0.25777912139893 / seconds
Query Executed:select id FROM `nc` where city='Brevard' && SIC_code='8062'DB:business_master_new
loadtime:0.26277804374695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeton' limit 1
loadtime:0.26284599304199 / seconds
Query Executed:select id FROM `nc` where city='Bridgeton' && SIC_code='8062'DB:business_master_new
loadtime:0.26393389701843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.26398897171021 / seconds
Query Executed:select id FROM `nc` where city='Broadway' && SIC_code='8062'DB:business_master_new
loadtime:0.26899695396423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browns Summit' limit 1
loadtime:0.26905703544617 / seconds
Query Executed:select id FROM `nc` where city='Browns Summit' && SIC_code='8062'DB:business_master_new
loadtime:0.27405691146851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunswick' limit 1
loadtime:0.27411103248596 / seconds
Query Executed:select id FROM `nc` where city='Brunswick' && SIC_code='8062'DB:business_master_new
loadtime:0.27466106414795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryson City' limit 1
loadtime:0.27471303939819 / seconds
Query Executed:select id FROM `nc` where city='Bryson City' && SIC_code='8062'DB:business_master_new
loadtime:0.27971196174622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buies Creek' limit 1
loadtime:0.27977895736694 / seconds
Query Executed:select id FROM `nc` where city='Buies Creek' && SIC_code='8062'DB:business_master_new
loadtime:0.28090906143188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullock' limit 1
loadtime:0.28096508979797 / seconds
Query Executed:select id FROM `nc` where city='Bullock' && SIC_code='8062'DB:business_master_new
loadtime:0.28180503845215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunn' limit 1
loadtime:0.28185701370239 / seconds
Query Executed:select id FROM `nc` where city='Bunn' && SIC_code='8062'DB:business_master_new
loadtime:0.28335690498352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunnlevel' limit 1
loadtime:0.28341007232666 / seconds
Query Executed:select id FROM `nc` where city='Bunnlevel' && SIC_code='8062'DB:business_master_new
loadtime:0.28467798233032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgaw' limit 1
loadtime:0.28473091125488 / seconds
Query Executed:select id FROM `nc` where city='Burgaw' && SIC_code='8062'DB:business_master_new
loadtime:0.28974509239197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.2898108959198 / seconds
Query Executed:select id FROM `nc` where city='Burlington' && SIC_code='8062'DB:business_master_new
loadtime:0.29483699798584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.29490804672241 / seconds
Query Executed:select id FROM `nc` where city='Burnsville' && SIC_code='8062'DB:business_master_new
loadtime:0.29992389678955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butner' limit 1
loadtime:0.29998993873596 / seconds
Query Executed:select id FROM `nc` where city='Butner' && SIC_code='8062'DB:business_master_new
loadtime:0.30262207984924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butters' limit 1
loadtime:0.30269002914429 / seconds
Query Executed:select id FROM `nc` where city='Butters' && SIC_code='8062'DB:business_master_new
loadtime:0.30310297012329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buxton' limit 1
loadtime:0.30315589904785 / seconds
Query Executed:select id FROM `nc` where city='Buxton' && SIC_code='8062'DB:business_master_new
loadtime:0.30613708496094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bynum' limit 1
loadtime:0.30619502067566 / seconds
Query Executed:select id FROM `nc` where city='Bynum' && SIC_code='8062'DB:business_master_new
loadtime:0.30662703514099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calabash' limit 1
loadtime:0.30667901039124 / seconds
Query Executed:select id FROM `nc` where city='Calabash' && SIC_code='8062'DB:business_master_new
loadtime:0.31174302101135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calypso' limit 1
loadtime:0.31179904937744 / seconds
Query Executed:select id FROM `nc` where city='Calypso' && SIC_code='8062'DB:business_master_new
loadtime:0.31262803077698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.31268095970154 / seconds
Query Executed:select id FROM `nc` where city='Camden' && SIC_code='8062'DB:business_master_new
loadtime:0.31504011154175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.31509399414062 / seconds
Query Executed:select id FROM `nc` where city='Cameron' && SIC_code='8062'DB:business_master_new
loadtime:0.3179919719696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Lejeune' limit 1
loadtime:0.31805300712585 / seconds
Query Executed:select id FROM `nc` where city='Camp Lejeune' && SIC_code='8062'DB:business_master_new
loadtime:0.31958699226379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candler' limit 1
loadtime:0.31965398788452 / seconds
Query Executed:select id FROM `nc` where city='Candler' && SIC_code='8062'DB:business_master_new
loadtime:0.32468390464783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candor' limit 1
loadtime:0.32473802566528 / seconds
Query Executed:select id FROM `nc` where city='Candor' && SIC_code='8062'DB:business_master_new
loadtime:0.32691597938538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.32696890830994 / seconds
Query Executed:select id FROM `nc` where city='Canton' && SIC_code='8062'DB:business_master_new
loadtime:0.33197593688965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Carteret' limit 1
loadtime:0.3320369720459 / seconds
Query Executed:select id FROM `nc` where city='Cape Carteret' && SIC_code='8062'DB:business_master_new
loadtime:0.33255290985107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caroleen' limit 1
loadtime:0.33260607719421 / seconds
Query Executed:select id FROM `nc` where city='Caroleen' && SIC_code='8062'DB:business_master_new
loadtime:0.33326601982117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Beach' limit 1
loadtime:0.33331894874573 / seconds
Query Executed:select id FROM `nc` where city='Carolina Beach' && SIC_code='8062'DB:business_master_new
loadtime:0.33835005760193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Shores' limit 1
loadtime:0.33840298652649 / seconds
Query Executed:select id FROM `nc` where city='Carolina Shores' && SIC_code='8062'DB:business_master_new
loadtime:0.33884000778198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrboro' limit 1
loadtime:0.33889198303223 / seconds
Query Executed:select id FROM `nc` where city='Carrboro' && SIC_code='8062'DB:business_master_new
loadtime:0.34391307830811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.34397912025452 / seconds
Query Executed:select id FROM `nc` where city='Carthage' && SIC_code='8062'DB:business_master_new
loadtime:0.34901595115662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:0.34907007217407 / seconds
Query Executed:select id FROM `nc` where city='Cary' && SIC_code='8062'DB:business_master_new
loadtime:0.35423302650452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casar' limit 1
loadtime:0.35430598258972 / seconds
Query Executed:select id FROM `nc` where city='Casar' && SIC_code='8062'DB:business_master_new
loadtime:0.35559105873108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashiers' limit 1
loadtime:0.35564589500427 / seconds
Query Executed:select id FROM `nc` where city='Cashiers' && SIC_code='8062'DB:business_master_new
loadtime:0.36065006256104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:0.36070489883423 / seconds
Query Executed:select id FROM `nc` where city='Castalia' && SIC_code='8062'DB:business_master_new
loadtime:0.36212706565857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Hayne' limit 1
loadtime:0.36218404769897 / seconds
Query Executed:select id FROM `nc` where city='Castle Hayne' && SIC_code='8062'DB:business_master_new
loadtime:0.36641812324524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.36647200584412 / seconds
Query Executed:select id FROM `nc` where city='Catawba' && SIC_code='8062'DB:business_master_new
loadtime:0.36938810348511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:0.36945509910583 / seconds
Query Executed:select id FROM `nc` where city='Cedar Falls' && SIC_code='8062'DB:business_master_new
loadtime:0.36993098258972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:0.36998295783997 / seconds
Query Executed:select id FROM `nc` where city='Cedar Grove' && SIC_code='8062'DB:business_master_new
loadtime:0.37111902236938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Island' limit 1
loadtime:0.37117695808411 / seconds
Query Executed:select id FROM `nc` where city='Cedar Island' && SIC_code='8062'DB:business_master_new
loadtime:0.3718740940094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Mountain' limit 1
loadtime:0.37192606925964 / seconds
Query Executed:select id FROM `nc` where city='Cedar Mountain' && SIC_code='8062'DB:business_master_new
loadtime:0.37308192253113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Point' limit 1
loadtime:0.37313508987427 / seconds
Query Executed:select id FROM `nc` where city='Cedar Point' && SIC_code='8062'DB:business_master_new
loadtime:0.37357997894287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro Gordo' limit 1
loadtime:0.37363195419312 / seconds
Query Executed:select id FROM `nc` where city='Cerro Gordo' && SIC_code='8062'DB:business_master_new
loadtime:0.37483310699463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chadbourn' limit 1
loadtime:0.37488698959351 / seconds
Query Executed:select id FROM `nc` where city='Chadbourn' && SIC_code='8062'DB:business_master_new
loadtime:0.37904810905457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapel Hill' limit 1
loadtime:0.37910199165344 / seconds
Query Executed:select id FROM `nc` where city='Chapel Hill' && SIC_code='8062'DB:business_master_new
loadtime:0.38424301147461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.38433289527893 / seconds
Query Executed:select id FROM `nc` where city='Charlotte' && SIC_code='8062'DB:business_master_new
loadtime:0.38940811157227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.38952612876892 / seconds
Query Executed:select id FROM `nc` where city='Cherokee' && SIC_code='8062'DB:business_master_new
loadtime:0.39454913139343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Point' limit 1
loadtime:0.39461994171143 / seconds
Query Executed:select id FROM `nc` where city='Cherry Point' && SIC_code='8062'DB:business_master_new
loadtime:0.39560008049011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherryville' limit 1
loadtime:0.39567112922668 / seconds
Query Executed:select id FROM `nc` where city='Cherryville' && SIC_code='8062'DB:business_master_new
loadtime:0.40069699287415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimney Rock' limit 1
loadtime:0.40075206756592 / seconds
Query Executed:select id FROM `nc` where city='Chimney Rock' && SIC_code='8062'DB:business_master_new
loadtime:0.40172505378723 / seconds
Query loaded from cache:select * from geodata_geocity where city='China Grove' limit 1
loadtime:0.40177798271179 / seconds
Query Executed:select id FROM `nc` where city='China Grove' && SIC_code='8062'DB:business_master_new
loadtime:0.4067850112915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinquapin' limit 1
loadtime:0.40685105323792 / seconds
Query Executed:select id FROM `nc` where city='Chinquapin' && SIC_code='8062'DB:business_master_new
loadtime:0.40810608863831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocowinity' limit 1
loadtime:0.40815997123718 / seconds
Query Executed:select id FROM `nc` where city='Chocowinity' && SIC_code='8062'DB:business_master_new
loadtime:0.41319799423218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.41325092315674 / seconds
Query Executed:select id FROM `nc` where city='Claremont' && SIC_code='8062'DB:business_master_new
loadtime:0.41828107833862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarendon' limit 1
loadtime:0.41834712028503 / seconds
Query Executed:select id FROM `nc` where city='Clarendon' && SIC_code='8062'DB:business_master_new
loadtime:0.41932797431946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkton' limit 1
loadtime:0.41938304901123 / seconds
Query Executed:select id FROM `nc` where city='Clarkton' && SIC_code='8062'DB:business_master_new
loadtime:0.42215991020203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.42221808433533 / seconds
Query Executed:select id FROM `nc` where city='Clayton' && SIC_code='8062'DB:business_master_new
loadtime:0.42722511291504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemmons' limit 1
loadtime:0.42727899551392 / seconds
Query Executed:select id FROM `nc` where city='Clemmons' && SIC_code='8062'DB:business_master_new
loadtime:0.43227505683899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.43232798576355 / seconds
Query Executed:select id FROM `nc` where city='Cleveland' && SIC_code='8062'DB:business_master_new
loadtime:0.43734407424927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffside' limit 1
loadtime:0.43739795684814 / seconds
Query Executed:select id FROM `nc` where city='Cliffside' && SIC_code='8062'DB:business_master_new
loadtime:0.43806600570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.43811893463135 / seconds
Query Executed:select id FROM `nc` where city='Climax' && SIC_code='8062'DB:business_master_new
loadtime:0.44012594223022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.44018411636353 / seconds
Query Executed:select id FROM `nc` where city='Clinton' && SIC_code='8062'DB:business_master_new
loadtime:0.4452109336853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:0.44527792930603 / seconds
Query Executed:select id FROM `nc` where city='Clyde' && SIC_code='8062'DB:business_master_new
loadtime:0.45035910606384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coats' limit 1
loadtime:0.45042705535889 / seconds
Query Executed:select id FROM `nc` where city='Coats' && SIC_code='8062'DB:business_master_new
loadtime:0.45318293571472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cofield' limit 1
loadtime:0.45323705673218 / seconds
Query Executed:select id FROM `nc` where city='Cofield' && SIC_code='8062'DB:business_master_new
loadtime:0.45402503013611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coinjock' limit 1
loadtime:0.45407795906067 / seconds
Query Executed:select id FROM `nc` where city='Coinjock' && SIC_code='8062'DB:business_master_new
loadtime:0.45533299446106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colerain' limit 1
loadtime:0.45538592338562 / seconds
Query Executed:select id FROM `nc` where city='Colerain' && SIC_code='8062'DB:business_master_new
loadtime:0.45724892616272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleridge' limit 1
loadtime:0.45730304718018 / seconds
Query Executed:select id FROM `nc` where city='Coleridge' && SIC_code='8062'DB:business_master_new
loadtime:0.45775103569031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.45780205726624 / seconds
Query Executed:select id FROM `nc` where city='Colfax' && SIC_code='8062'DB:business_master_new
loadtime:0.4603009223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collettsville' limit 1
loadtime:0.46035504341125 / seconds
Query Executed:select id FROM `nc` where city='Collettsville' && SIC_code='8062'DB:business_master_new
loadtime:0.46105098724365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.4611029624939 / seconds
Query Executed:select id FROM `nc` where city='Columbia' && SIC_code='8062'DB:business_master_new
loadtime:0.46614503860474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.46621608734131 / seconds
Query Executed:select id FROM `nc` where city='Columbus' && SIC_code='8062'DB:business_master_new
loadtime:0.4712450504303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comfort' limit 1
loadtime:0.47131299972534 / seconds
Query Executed:select id FROM `nc` where city='Comfort' && SIC_code='8062'DB:business_master_new
loadtime:0.4718279838562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.47187995910645 / seconds
Query Executed:select id FROM `nc` where city='Como' && SIC_code='8062'DB:business_master_new
loadtime:0.4726459980011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.47270011901855 / seconds
Query Executed:select id FROM `nc` where city='Concord' && SIC_code='8062'DB:business_master_new
loadtime:0.47791004180908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conetoe' limit 1
loadtime:0.4779839515686 / seconds
Query Executed:select id FROM `nc` where city='Conetoe' && SIC_code='8062'DB:business_master_new
loadtime:0.47871208190918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Spgs' limit 1
loadtime:0.47876596450806 / seconds
Query Executed:select id FROM `nc` where city='Connellys Spgs' && SIC_code='8062'DB:business_master_new
loadtime:0.47925090789795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Springs' limit 1
loadtime:0.47930407524109 / seconds
Query Executed:select id FROM `nc` where city='Connellys Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.4797260761261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conover' limit 1
loadtime:0.47977805137634 / seconds
Query Executed:select id FROM `nc` where city='Conover' && SIC_code='8062'DB:business_master_new
loadtime:0.48488903045654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.48495602607727 / seconds
Query Executed:select id FROM `nc` where city='Conway' && SIC_code='8062'DB:business_master_new
loadtime:0.4866669178009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooleemee' limit 1
loadtime:0.48672103881836 / seconds
Query Executed:select id FROM `nc` where city='Cooleemee' && SIC_code='8062'DB:business_master_new
loadtime:0.48835301399231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corapeake' limit 1
loadtime:0.48840594291687 / seconds
Query Executed:select id FROM `nc` where city='Corapeake' && SIC_code='8062'DB:business_master_new
loadtime:0.48915195465088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.48920893669128 / seconds
Query Executed:select id FROM `nc` where city='Cordova' && SIC_code='8062'DB:business_master_new
loadtime:0.48984003067017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornelius' limit 1
loadtime:0.48989105224609 / seconds
Query Executed:select id FROM `nc` where city='Cornelius' && SIC_code='8062'DB:business_master_new
loadtime:0.49491810798645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corolla' limit 1
loadtime:0.49498391151428 / seconds
Query Executed:select id FROM `nc` where city='Corolla' && SIC_code='8062'DB:business_master_new
loadtime:0.49997496604919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:0.50003790855408 / seconds
Query Executed:select id FROM `nc` where city='Council' && SIC_code='8062'DB:business_master_new
loadtime:0.50099802017212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cove City' limit 1
loadtime:0.50105810165405 / seconds
Query Executed:select id FROM `nc` where city='Cove City' && SIC_code='8062'DB:business_master_new
loadtime:0.50244307518005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cramerton' limit 1
loadtime:0.50249600410461 / seconds
Query Executed:select id FROM `nc` where city='Cramerton' && SIC_code='8062'DB:business_master_new
loadtime:0.50406408309937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creedmoor' limit 1
loadtime:0.50411796569824 / seconds
Query Executed:select id FROM `nc` where city='Creedmoor' && SIC_code='8062'DB:business_master_new
loadtime:0.5091381072998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.5092089176178 / seconds
Query Executed:select id FROM `nc` where city='Creston' && SIC_code='8062'DB:business_master_new
loadtime:0.5102391242981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creswell' limit 1
loadtime:0.51029396057129 / seconds
Query Executed:select id FROM `nc` where city='Creswell' && SIC_code='8062'DB:business_master_new
loadtime:0.51201605796814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossnore' limit 1
loadtime:0.51206994056702 / seconds
Query Executed:select id FROM `nc` where city='Crossnore' && SIC_code='8062'DB:business_master_new
loadtime:0.51290392875671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crouse' limit 1
loadtime:0.51295709609985 / seconds
Query Executed:select id FROM `nc` where city='Crouse' && SIC_code='8062'DB:business_master_new
loadtime:0.51390695571899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crumpler' limit 1
loadtime:0.51395893096924 / seconds
Query Executed:select id FROM `nc` where city='Crumpler' && SIC_code='8062'DB:business_master_new
loadtime:0.51522493362427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culberson' limit 1
loadtime:0.51527810096741 / seconds
Query Executed:select id FROM `nc` where city='Culberson' && SIC_code='8062'DB:business_master_new
loadtime:0.51570105552673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullowhee' limit 1
loadtime:0.51575207710266 / seconds
Query Executed:select id FROM `nc` where city='Cullowhee' && SIC_code='8062'DB:business_master_new
loadtime:0.52076005935669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.52081489562988 / seconds
Query Executed:select id FROM `nc` where city='Cumberland' && SIC_code='8062'DB:business_master_new
loadtime:0.52145910263062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumnock' limit 1
loadtime:0.52151298522949 / seconds
Query Executed:select id FROM `nc` where city='Cumnock' && SIC_code='8062'DB:business_master_new
loadtime:0.52188992500305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currie' limit 1
loadtime:0.52194094657898 / seconds
Query Executed:select id FROM `nc` where city='Currie' && SIC_code='8062'DB:business_master_new
loadtime:0.52304100990295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currituck' limit 1
loadtime:0.52309393882751 / seconds
Query Executed:select id FROM `nc` where city='Currituck' && SIC_code='8062'DB:business_master_new
loadtime:0.52471804618835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.52477097511292 / seconds
Query Executed:select id FROM `nc` where city='Dallas' && SIC_code='8062'DB:business_master_new
loadtime:0.52978491783142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:0.52983713150024 / seconds
Query Executed:select id FROM `nc` where city='Dana' && SIC_code='8062'DB:business_master_new
loadtime:0.53066301345825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.53071594238281 / seconds
Query Executed:select id FROM `nc` where city='Danbury' && SIC_code='8062'DB:business_master_new
loadtime:0.53321409225464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davidson' limit 1
loadtime:0.53328609466553 / seconds
Query Executed:select id FROM `nc` where city='Davidson' && SIC_code='8062'DB:business_master_new
loadtime:0.53829097747803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.5383460521698 / seconds
Query Executed:select id FROM `nc` where city='Davis' && SIC_code='8062'DB:business_master_new
loadtime:0.5389621257782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Gap' limit 1
loadtime:0.53902196884155 / seconds
Query Executed:select id FROM `nc` where city='Deep Gap' && SIC_code='8062'DB:business_master_new
loadtime:0.54051995277405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Run' limit 1
loadtime:0.54057312011719 / seconds
Query Executed:select id FROM `nc` where city='Deep Run' && SIC_code='8062'DB:business_master_new
loadtime:0.54196310043335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delco' limit 1
loadtime:0.54202389717102 / seconds
Query Executed:select id FROM `nc` where city='Delco' && SIC_code='8062'DB:business_master_new
loadtime:0.54355907440186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denton' limit 1
loadtime:0.54361200332642 / seconds
Query Executed:select id FROM `nc` where city='Denton' && SIC_code='8062'DB:business_master_new
loadtime:0.54863500595093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.54868793487549 / seconds
Query Executed:select id FROM `nc` where city='Denver' && SIC_code='8062'DB:business_master_new
loadtime:0.55371499061584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillsboro' limit 1
loadtime:0.5537850856781 / seconds
Query Executed:select id FROM `nc` where city='Dillsboro' && SIC_code='8062'DB:business_master_new
loadtime:0.555419921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dobson' limit 1
loadtime:0.55547404289246 / seconds
Query Executed:select id FROM `nc` where city='Dobson' && SIC_code='8062'DB:business_master_new
loadtime:0.56047105789185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.56052494049072 / seconds
Query Executed:select id FROM `nc` where city='Dover' && SIC_code='8062'DB:business_master_new
loadtime:0.56192898750305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drexel' limit 1
loadtime:0.56198191642761 / seconds
Query Executed:select id FROM `nc` where city='Drexel' && SIC_code='8062'DB:business_master_new
loadtime:0.56345701217651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.56350994110107 / seconds
Query Executed:select id FROM `nc` where city='Dublin' && SIC_code='8062'DB:business_master_new
loadtime:0.56462597846985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.56469297409058 / seconds
Query Executed:select id FROM `nc` where city='Dudley' && SIC_code='8062'DB:business_master_new
loadtime:0.56714510917664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn' limit 1
loadtime:0.56720495223999 / seconds
Query Executed:select id FROM `nc` where city='Dunn' && SIC_code='8062'DB:business_master_new
loadtime:0.57221102714539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durants Neck' limit 1
loadtime:0.57228112220764 / seconds
Query Executed:select id FROM `nc` where city='Durants Neck' && SIC_code='8062'DB:business_master_new
loadtime:0.5726490020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.57270312309265 / seconds
Query Executed:select id FROM `nc` where city='Durham' && SIC_code='8062'DB:business_master_new
loadtime:0.5777440071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:0.57784390449524 / seconds
Query Executed:select id FROM `nc` where city='Eagle Rock' && SIC_code='8062'DB:business_master_new
loadtime:0.57829809188843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Springs' limit 1
loadtime:0.57835507392883 / seconds
Query Executed:select id FROM `nc` where city='Eagle Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.57935190200806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earl' limit 1
loadtime:0.57940602302551 / seconds
Query Executed:select id FROM `nc` where city='Earl' && SIC_code='8062'DB:business_master_new
loadtime:0.57995700836182 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bend' limit 1
loadtime:0.58003401756287 / seconds
Query Executed:select id FROM `nc` where city='East Bend' && SIC_code='8062'DB:business_master_new
loadtime:0.58515810966492 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fayettevlle' limit 1
loadtime:0.58523607254028 / seconds
Query Executed:select id FROM `nc` where city='East Fayettevlle' && SIC_code='8062'DB:business_master_new
loadtime:0.58563709259033 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Flat Rock' limit 1
loadtime:0.58569192886353 / seconds
Query Executed:select id FROM `nc` where city='East Flat Rock' && SIC_code='8062'DB:business_master_new
loadtime:0.58760094642639 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lake' limit 1
loadtime:0.58765506744385 / seconds
Query Executed:select id FROM `nc` where city='East Lake' && SIC_code='8062'DB:business_master_new
loadtime:0.58804512023926 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Spencer' limit 1
loadtime:0.58809804916382 / seconds
Query Executed:select id FROM `nc` where city='East Spencer' && SIC_code='8062'DB:business_master_new
loadtime:0.58895993232727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.58902192115784 / seconds
Query Executed:select id FROM `nc` where city='Eden' && SIC_code='8062'DB:business_master_new
loadtime:0.59402799606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenton' limit 1
loadtime:0.59409499168396 / seconds
Query Executed:select id FROM `nc` where city='Edenton' && SIC_code='8062'DB:business_master_new
loadtime:0.59912896156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edneyville' limit 1
loadtime:0.59920406341553 / seconds
Query Executed:select id FROM `nc` where city='Edneyville' && SIC_code='8062'DB:business_master_new
loadtime:0.5999391078949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edward' limit 1
loadtime:0.59999203681946 / seconds
Query Executed:select id FROM `nc` where city='Edward' && SIC_code='8062'DB:business_master_new
loadtime:0.60064005851746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Efland' limit 1
loadtime:0.60069298744202 / seconds
Query Executed:select id FROM `nc` where city='Efland' && SIC_code='8062'DB:business_master_new
loadtime:0.6027729511261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth City' limit 1
loadtime:0.60282611846924 / seconds
Query Executed:select id FROM `nc` where city='Elizabeth City' && SIC_code='8062'DB:business_master_new
loadtime:0.60783791542053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabethtown' limit 1
loadtime:0.60790610313416 / seconds
Query Executed:select id FROM `nc` where city='Elizabethtown' && SIC_code='8062'DB:business_master_new
loadtime:0.6129150390625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Park' limit 1
loadtime:0.61298608779907 / seconds
Query Executed:select id FROM `nc` where city='Elk Park' && SIC_code='8062'DB:business_master_new
loadtime:0.61461091041565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkin' limit 1
loadtime:0.61466503143311 / seconds
Query Executed:select id FROM `nc` where city='Elkin' && SIC_code='8062'DB:business_master_new
loadtime:0.61966991424561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellenboro' limit 1
loadtime:0.61974000930786 / seconds
Query Executed:select id FROM `nc` where city='Ellenboro' && SIC_code='8062'DB:business_master_new
loadtime:0.62201905250549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellerbe' limit 1
loadtime:0.62207412719727 / seconds
Query Executed:select id FROM `nc` where city='Ellerbe' && SIC_code='8062'DB:business_master_new
loadtime:0.62496709823608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm City' limit 1
loadtime:0.62502813339233 / seconds
Query Executed:select id FROM `nc` where city='Elm City' && SIC_code='8062'DB:business_master_new
loadtime:0.62884402275085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon' limit 1
loadtime:0.62889695167542 / seconds
Query Executed:select id FROM `nc` where city='Elon' && SIC_code='8062'DB:business_master_new
loadtime:0.63314509391785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon College' limit 1
loadtime:0.63320398330688 / seconds
Query Executed:select id FROM `nc` where city='Elon College' && SIC_code='8062'DB:business_master_new
loadtime:0.63388299942017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerald Isle' limit 1
loadtime:0.63393402099609 / seconds
Query Executed:select id FROM `nc` where city='Emerald Isle' && SIC_code='8062'DB:business_master_new
loadtime:0.63838505744934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.63843894004822 / seconds
Query Executed:select id FROM `nc` where city='Enfield' && SIC_code='8062'DB:business_master_new
loadtime:0.64221596717834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engelhard' limit 1
loadtime:0.64227104187012 / seconds
Query Executed:select id FROM `nc` where city='Engelhard' && SIC_code='8062'DB:business_master_new
loadtime:0.64369797706604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enka' limit 1
loadtime:0.64374995231628 / seconds
Query Executed:select id FROM `nc` where city='Enka' && SIC_code='8062'DB:business_master_new
loadtime:0.64512395858765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ennice' limit 1
loadtime:0.64518213272095 / seconds
Query Executed:select id FROM `nc` where city='Ennice' && SIC_code='8062'DB:business_master_new
loadtime:0.64632701873779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ernul' limit 1
loadtime:0.64637899398804 / seconds
Query Executed:select id FROM `nc` where city='Ernul' && SIC_code='8062'DB:business_master_new
loadtime:0.64713406562805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.64719104766846 / seconds
Query Executed:select id FROM `nc` where city='Erwin' && SIC_code='8062'DB:business_master_new
loadtime:0.65112495422363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ether' limit 1
loadtime:0.65120196342468 / seconds
Query Executed:select id FROM `nc` where city='Ether' && SIC_code='8062'DB:business_master_new
loadtime:0.65184998512268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etowah' limit 1
loadtime:0.65190196037292 / seconds
Query Executed:select id FROM `nc` where city='Etowah' && SIC_code='8062'DB:business_master_new
loadtime:0.65413308143616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eure' limit 1
loadtime:0.65419006347656 / seconds
Query Executed:select id FROM `nc` where city='Eure' && SIC_code='8062'DB:business_master_new
loadtime:0.65504002571106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.6550920009613 / seconds
Query Executed:select id FROM `nc` where city='Eureka' && SIC_code='8062'DB:business_master_new
loadtime:0.65551996231079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everetts' limit 1
loadtime:0.65557193756104 / seconds
Query Executed:select id FROM `nc` where city='Everetts' && SIC_code='8062'DB:business_master_new
loadtime:0.6561861038208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:0.65623903274536 / seconds
Query Executed:select id FROM `nc` where city='Evergreen' && SIC_code='8062'DB:business_master_new
loadtime:0.65718603134155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Bluff' limit 1
loadtime:0.65723896026611 / seconds
Query Executed:select id FROM `nc` where city='Fair Bluff' && SIC_code='8062'DB:business_master_new
loadtime:0.65938901901245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.6594409942627 / seconds
Query Executed:select id FROM `nc` where city='Fairfield' && SIC_code='8062'DB:business_master_new
loadtime:0.66054105758667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairmont' limit 1
loadtime:0.66059398651123 / seconds
Query Executed:select id FROM `nc` where city='Fairmont' && SIC_code='8062'DB:business_master_new
loadtime:0.66482901573181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.66488289833069 / seconds
Query Executed:select id FROM `nc` where city='Fairview' && SIC_code='8062'DB:business_master_new
loadtime:0.66987895965576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faison' limit 1
loadtime:0.6699321269989 / seconds
Query Executed:select id FROM `nc` where city='Faison' && SIC_code='8062'DB:business_master_new
loadtime:0.67260503768921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.67265796661377 / seconds
Query Executed:select id FROM `nc` where city='Faith' && SIC_code='8062'DB:business_master_new
loadtime:0.67371296882629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:0.67376494407654 / seconds
Query Executed:select id FROM `nc` where city='Falcon' && SIC_code='8062'DB:business_master_new
loadtime:0.674565076828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkland' limit 1
loadtime:0.67461800575256 / seconds
Query Executed:select id FROM `nc` where city='Falkland' && SIC_code='8062'DB:business_master_new
loadtime:0.67529106140137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fallston' limit 1
loadtime:0.67534303665161 / seconds
Query Executed:select id FROM `nc` where city='Fallston' && SIC_code='8062'DB:business_master_new
loadtime:0.67646598815918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:0.67651891708374 / seconds
Query Executed:select id FROM `nc` where city='Farmville' && SIC_code='8062'DB:business_master_new
loadtime:0.68172407150269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayetteville' limit 1
loadtime:0.68177700042725 / seconds
Query Executed:select id FROM `nc` where city='Fayetteville' && SIC_code='8062'DB:business_master_new
loadtime:0.68683290481567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fearrington Vlg' limit 1
loadtime:0.68692708015442 / seconds
Query Executed:select id FROM `nc` where city='Fearrington Vlg' && SIC_code='8062'DB:business_master_new
loadtime:0.68731212615967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:0.68736791610718 / seconds
Query Executed:select id FROM `nc` where city='Ferguson' && SIC_code='8062'DB:business_master_new
loadtime:0.68862295150757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:0.68868899345398 / seconds
Query Executed:select id FROM `nc` where city='Flat Rock' && SIC_code='8062'DB:business_master_new
loadtime:0.69372010231018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fleetwood' limit 1
loadtime:0.69377493858337 / seconds
Query Executed:select id FROM `nc` where city='Fleetwood' && SIC_code='8062'DB:business_master_new
loadtime:0.69532299041748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fletcher' limit 1
loadtime:0.69537591934204 / seconds
Query Executed:select id FROM `nc` where city='Fletcher' && SIC_code='8062'DB:business_master_new
loadtime:0.70039391517639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana Dam' limit 1
loadtime:0.70046401023865 / seconds
Query Executed:select id FROM `nc` where city='Fontana Dam' && SIC_code='8062'DB:business_master_new
loadtime:0.70095992088318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:0.70102190971375 / seconds
Query Executed:select id FROM `nc` where city='Forest City' && SIC_code='8062'DB:business_master_new
loadtime:0.7060329914093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bragg' limit 1
loadtime:0.70608711242676 / seconds
Query Executed:select id FROM `nc` where city='Fort Bragg' && SIC_code='8062'DB:business_master_new
loadtime:0.71108293533325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:0.71114802360535 / seconds
Query Executed:select id FROM `nc` where city='Fountain' && SIC_code='8062'DB:business_master_new
loadtime:0.71230602264404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Four Oaks' limit 1
loadtime:0.7123589515686 / seconds
Query Executed:select id FROM `nc` where city='Four Oaks' && SIC_code='8062'DB:business_master_new
loadtime:0.71738910675049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.71745491027832 / seconds
Query Executed:select id FROM `nc` where city='Franklin' && SIC_code='8062'DB:business_master_new
loadtime:0.72256898880005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinton' limit 1
loadtime:0.72264194488525 / seconds
Query Executed:select id FROM `nc` where city='Franklinton' && SIC_code='8062'DB:business_master_new
loadtime:0.72768712043762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinville' limit 1
loadtime:0.72774195671082 / seconds
Query Executed:select id FROM `nc` where city='Franklinville' && SIC_code='8062'DB:business_master_new
loadtime:0.72983908653259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.72989201545715 / seconds
Query Executed:select id FROM `nc` where city='Fremont' && SIC_code='8062'DB:business_master_new
loadtime:0.73218393325806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco' limit 1
loadtime:0.73224210739136 / seconds
Query Executed:select id FROM `nc` where city='Frisco' && SIC_code='8062'DB:business_master_new
loadtime:0.73375010490417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fuquay Varina' limit 1
loadtime:0.73380398750305 / seconds
Query Executed:select id FROM `nc` where city='Fuquay Varina' && SIC_code='8062'DB:business_master_new
loadtime:0.73878693580627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:0.73884105682373 / seconds
Query Executed:select id FROM `nc` where city='Garland' && SIC_code='8062'DB:business_master_new
loadtime:0.74123907089233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:0.74129199981689 / seconds
Query Executed:select id FROM `nc` where city='Garner' && SIC_code='8062'DB:business_master_new
loadtime:0.74629712104797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garysburg' limit 1
loadtime:0.74635004997253 / seconds
Query Executed:select id FROM `nc` where city='Garysburg' && SIC_code='8062'DB:business_master_new
loadtime:0.74745798110962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:0.74750995635986 / seconds
Query Executed:select id FROM `nc` where city='Gaston' && SIC_code='8062'DB:business_master_new
loadtime:0.74876999855042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gastonia' limit 1
loadtime:0.74882411956787 / seconds
Query Executed:select id FROM `nc` where city='Gastonia' && SIC_code='8062'DB:business_master_new
loadtime:0.75390291213989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gates' limit 1
loadtime:0.75397706031799 / seconds
Query Executed:select id FROM `nc` where city='Gates' && SIC_code='8062'DB:business_master_new
loadtime:0.75529313087463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gatesville' limit 1
loadtime:0.75534892082214 / seconds
Query Executed:select id FROM `nc` where city='Gatesville' && SIC_code='8062'DB:business_master_new
loadtime:0.75727510452271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germanton' limit 1
loadtime:0.7573299407959 / seconds
Query Executed:select id FROM `nc` where city='Germanton' && SIC_code='8062'DB:business_master_new
loadtime:0.75908207893372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gerton' limit 1
loadtime:0.75913500785828 / seconds
Query Executed:select id FROM `nc` where city='Gerton' && SIC_code='8062'DB:business_master_new
loadtime:0.75966596603394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:0.75971698760986 / seconds
Query Executed:select id FROM `nc` where city='Gibson' && SIC_code='8062'DB:business_master_new
loadtime:0.76065301895142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibsonville' limit 1
loadtime:0.76070594787598 / seconds
Query Executed:select id FROM `nc` where city='Gibsonville' && SIC_code='8062'DB:business_master_new
loadtime:0.76575303077698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Valley' limit 1
loadtime:0.76580500602722 / seconds
Query Executed:select id FROM `nc` where city='Glade Valley' && SIC_code='8062'DB:business_master_new
loadtime:0.76672291755676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Alpine' limit 1
loadtime:0.7667760848999 / seconds
Query Executed:select id FROM `nc` where city='Glen Alpine' && SIC_code='8062'DB:business_master_new
loadtime:0.76794505119324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Raven' limit 1
loadtime:0.76799702644348 / seconds
Query Executed:select id FROM `nc` where city='Glen Raven' && SIC_code='8062'DB:business_master_new
loadtime:0.76841711997986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale Springs' limit 1
loadtime:0.76847004890442 / seconds
Query Executed:select id FROM `nc` where city='Glendale Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.7691171169281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendon' limit 1
loadtime:0.76916909217834 / seconds
Query Executed:select id FROM `nc` where city='Glendon' && SIC_code='8062'DB:business_master_new
loadtime:0.76959800720215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenville' limit 1
loadtime:0.76964998245239 / seconds
Query Executed:select id FROM `nc` where city='Glenville' && SIC_code='8062'DB:business_master_new
loadtime:0.77089190483093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.77094912528992 / seconds
Query Executed:select id FROM `nc` where city='Glenwood' && SIC_code='8062'DB:business_master_new
loadtime:0.77146506309509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.77151799201965 / seconds
Query Executed:select id FROM `nc` where city='Gloucester' && SIC_code='8062'DB:business_master_new
loadtime:0.77206993103027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Godwin' limit 1
loadtime:0.77211999893188 / seconds
Query Executed:select id FROM `nc` where city='Godwin' && SIC_code='8062'DB:business_master_new
loadtime:0.77336812019348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gold Hill' limit 1
loadtime:0.77342200279236 / seconds
Query Executed:select id FROM `nc` where city='Gold Hill' && SIC_code='8062'DB:business_master_new
loadtime:0.77498507499695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldsboro' limit 1
loadtime:0.7750449180603 / seconds
Query Executed:select id FROM `nc` where city='Goldsboro' && SIC_code='8062'DB:business_master_new
loadtime:0.78007698059082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldston' limit 1
loadtime:0.78015494346619 / seconds
Query Executed:select id FROM `nc` where city='Goldston' && SIC_code='8062'DB:business_master_new
loadtime:0.78171300888062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graham' limit 1
loadtime:0.78176999092102 / seconds
Query Executed:select id FROM `nc` where city='Graham' && SIC_code='8062'DB:business_master_new
loadtime:0.7867910861969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandy' limit 1
loadtime:0.78685712814331 / seconds
Query Executed:select id FROM `nc` where city='Grandy' && SIC_code='8062'DB:business_master_new
loadtime:0.78916597366333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Falls' limit 1
loadtime:0.78922390937805 / seconds
Query Executed:select id FROM `nc` where city='Granite Falls' && SIC_code='8062'DB:business_master_new
loadtime:0.79424810409546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Quarry' limit 1
loadtime:0.79430103302002 / seconds
Query Executed:select id FROM `nc` where city='Granite Quarry' && SIC_code='8062'DB:business_master_new
loadtime:0.79574704170227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsboro' limit 1
loadtime:0.79579997062683 / seconds
Query Executed:select id FROM `nc` where city='Grantsboro' && SIC_code='8062'DB:business_master_new
loadtime:0.79691195487976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grassy Creek' limit 1
loadtime:0.7969651222229 / seconds
Query Executed:select id FROM `nc` where city='Grassy Creek' && SIC_code='8062'DB:business_master_new
loadtime:0.7975959777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:0.79764795303345 / seconds
Query Executed:select id FROM `nc` where city='Green Mountain' && SIC_code='8062'DB:business_master_new
loadtime:0.79845404624939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenmountain' limit 1
loadtime:0.79850697517395 / seconds
Query Executed:select id FROM `nc` where city='Greenmountain' && SIC_code='8062'DB:business_master_new
loadtime:0.79891991615295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.79897212982178 / seconds
Query Executed:select id FROM `nc` where city='Greensboro' && SIC_code='8062'DB:business_master_new
loadtime:0.80401110649109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.80410408973694 / seconds
Query Executed:select id FROM `nc` where city='Greenville' && SIC_code='8062'DB:business_master_new
loadtime:0.80912899971008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grifton' limit 1
loadtime:0.80921101570129 / seconds
Query Executed:select id FROM `nc` where city='Grifton' && SIC_code='8062'DB:business_master_new
loadtime:0.81248211860657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimesland' limit 1
loadtime:0.81253695487976 / seconds
Query Executed:select id FROM `nc` where city='Grimesland' && SIC_code='8062'DB:business_master_new
loadtime:0.81477403640747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.81482601165771 / seconds
Query Executed:select id FROM `nc` where city='Grover' && SIC_code='8062'DB:business_master_new
loadtime:0.81676602363586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulf' limit 1
loadtime:0.81681990623474 / seconds
Query Executed:select id FROM `nc` where city='Gulf' && SIC_code='8062'DB:business_master_new
loadtime:0.81742596626282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.81747794151306 / seconds
Query Executed:select id FROM `nc` where city='Halifax' && SIC_code='8062'DB:business_master_new
loadtime:0.8201699256897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallsboro' limit 1
loadtime:0.82022905349731 / seconds
Query Executed:select id FROM `nc` where city='Hallsboro' && SIC_code='8062'DB:business_master_new
loadtime:0.82129597663879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.82135009765625 / seconds
Query Executed:select id FROM `nc` where city='Hamilton' && SIC_code='8062'DB:business_master_new
loadtime:0.82230305671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlet' limit 1
loadtime:0.82235503196716 / seconds
Query Executed:select id FROM `nc` where city='Hamlet' && SIC_code='8062'DB:business_master_new
loadtime:0.82808113098145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.82815194129944 / seconds
Query Executed:select id FROM `nc` where city='Hampstead' && SIC_code='8062'DB:business_master_new
loadtime:0.83325600624084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamptonville' limit 1
loadtime:0.83331298828125 / seconds
Query Executed:select id FROM `nc` where city='Hamptonville' && SIC_code='8062'DB:business_master_new
loadtime:0.83605694770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbinger' limit 1
loadtime:0.83611011505127 / seconds
Query Executed:select id FROM `nc` where city='Harbinger' && SIC_code='8062'DB:business_master_new
loadtime:0.8376350402832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harkers Island' limit 1
loadtime:0.83768892288208 / seconds
Query Executed:select id FROM `nc` where city='Harkers Island' && SIC_code='8062'DB:business_master_new
loadtime:0.83914995193481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harmony' limit 1
loadtime:0.83920812606812 / seconds
Query Executed:select id FROM `nc` where city='Harmony' && SIC_code='8062'DB:business_master_new
loadtime:0.84191107749939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrells' limit 1
loadtime:0.84196400642395 / seconds
Query Executed:select id FROM `nc` where city='Harrells' && SIC_code='8062'DB:business_master_new
loadtime:0.84392809867859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrellsville' limit 1
loadtime:0.84398102760315 / seconds
Query Executed:select id FROM `nc` where city='Harrellsville' && SIC_code='8062'DB:business_master_new
loadtime:0.84481906890869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:0.84487104415894 / seconds
Query Executed:select id FROM `nc` where city='Harris' && SIC_code='8062'DB:business_master_new
loadtime:0.8453381061554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.84539294242859 / seconds
Query Executed:select id FROM `nc` where city='Harrisburg' && SIC_code='8062'DB:business_master_new
loadtime:0.85044598579407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hassell' limit 1
loadtime:0.85049891471863 / seconds
Query Executed:select id FROM `nc` where city='Hassell' && SIC_code='8062'DB:business_master_new
loadtime:0.8509418964386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatteras' limit 1
loadtime:0.85099291801453 / seconds
Query Executed:select id FROM `nc` where city='Hatteras' && SIC_code='8062'DB:business_master_new
loadtime:0.85305190086365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:0.85310506820679 / seconds
Query Executed:select id FROM `nc` where city='Havelock' && SIC_code='8062'DB:business_master_new
loadtime:0.85821604728699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haw River' limit 1
loadtime:0.85827612876892 / seconds
Query Executed:select id FROM `nc` where city='Haw River' && SIC_code='8062'DB:business_master_new
loadtime:0.86332893371582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:0.86338305473328 / seconds
Query Executed:select id FROM `nc` where city='Hayesville' && SIC_code='8062'DB:business_master_new
loadtime:0.86843490600586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hays' limit 1
loadtime:0.868488073349 / seconds
Query Executed:select id FROM `nc` where city='Hays' && SIC_code='8062'DB:business_master_new
loadtime:0.87015604972839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelwood' limit 1
loadtime:0.8702130317688 / seconds
Query Executed:select id FROM `nc` where city='Hazelwood' && SIC_code='8062'DB:business_master_new
loadtime:0.87096810340881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.87101912498474 / seconds
Query Executed:select id FROM `nc` where city='Henderson' && SIC_code='8062'DB:business_master_new
loadtime:0.87608909606934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hendersonville' limit 1
loadtime:0.87616109848022 / seconds
Query Executed:select id FROM `nc` where city='Hendersonville' && SIC_code='8062'DB:business_master_new
loadtime:0.88121604919434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrico' limit 1
loadtime:0.88128900527954 / seconds
Query Executed:select id FROM `nc` where city='Henrico' && SIC_code='8062'DB:business_master_new
loadtime:0.88215804100037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrietta' limit 1
loadtime:0.8822181224823 / seconds
Query Executed:select id FROM `nc` where city='Henrietta' && SIC_code='8062'DB:business_master_new
loadtime:0.88287711143494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hertford' limit 1
loadtime:0.88292908668518 / seconds
Query Executed:select id FROM `nc` where city='Hertford' && SIC_code='8062'DB:business_master_new
loadtime:0.88792991638184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:0.88798403739929 / seconds
Query Executed:select id FROM `nc` where city='Hickory' && SIC_code='8062'DB:business_master_new
loadtime:0.89297795295715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiddenite' limit 1
loadtime:0.893070936203 / seconds
Query Executed:select id FROM `nc` where city='Hiddenite' && SIC_code='8062'DB:business_master_new
loadtime:0.89525389671326 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Point' limit 1
loadtime:0.89530992507935 / seconds
Query Executed:select id FROM `nc` where city='High Point' && SIC_code='8062'DB:business_master_new
loadtime:0.90031790733337 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Shoals' limit 1
loadtime:0.90038895606995 / seconds
Query Executed:select id FROM `nc` where city='High Shoals' && SIC_code='8062'DB:business_master_new
loadtime:0.90097498893738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highfalls' limit 1
loadtime:0.90103912353516 / seconds
Query Executed:select id FROM `nc` where city='Highfalls' && SIC_code='8062'DB:business_master_new
loadtime:0.90160512924194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands' limit 1
loadtime:0.9016580581665 / seconds
Query Executed:select id FROM `nc` where city='Highlands' && SIC_code='8062'DB:business_master_new
loadtime:0.90667700767517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildebran' limit 1
loadtime:0.90674495697021 / seconds
Query Executed:select id FROM `nc` where city='Hildebran' && SIC_code='8062'DB:business_master_new
loadtime:0.90999102592468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.91005492210388 / seconds
Query Executed:select id FROM `nc` where city='Hillsborough' && SIC_code='8062'DB:business_master_new
loadtime:0.91506695747375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbsville' limit 1
loadtime:0.91512203216553 / seconds
Query Executed:select id FROM `nc` where city='Hobbsville' && SIC_code='8062'DB:business_master_new
loadtime:0.91592192649841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobgood' limit 1
loadtime:0.91597509384155 / seconds
Query Executed:select id FROM `nc` where city='Hobgood' && SIC_code='8062'DB:business_master_new
loadtime:0.91677308082581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobucken' limit 1
loadtime:0.91682600975037 / seconds
Query Executed:select id FROM `nc` where city='Hobucken' && SIC_code='8062'DB:business_master_new
loadtime:0.91734504699707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoffman' limit 1
loadtime:0.91739797592163 / seconds
Query Executed:select id FROM `nc` where city='Hoffman' && SIC_code='8062'DB:business_master_new
loadtime:0.91826796531677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden Beach' limit 1
loadtime:0.91832208633423 / seconds
Query Executed:select id FROM `nc` where city='Holden Beach' && SIC_code='8062'DB:business_master_new
loadtime:0.9189350605011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollister' limit 1
loadtime:0.91898703575134 / seconds
Query Executed:select id FROM `nc` where city='Hollister' && SIC_code='8062'DB:business_master_new
loadtime:0.92029905319214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:0.9203519821167 / seconds
Query Executed:select id FROM `nc` where city='Holly Ridge' && SIC_code='8062'DB:business_master_new
loadtime:0.92535901069641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:0.92541193962097 / seconds
Query Executed:select id FROM `nc` where city='Holly Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.93040704727173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hookerton' limit 1
loadtime:0.93045997619629 / seconds
Query Executed:select id FROM `nc` where city='Hookerton' && SIC_code='8062'DB:business_master_new
loadtime:0.93170094490051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope Mills' limit 1
loadtime:0.93175292015076 / seconds
Query Executed:select id FROM `nc` where city='Hope Mills' && SIC_code='8062'DB:business_master_new
loadtime:0.93674802780151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horse Shoe' limit 1
loadtime:0.93681406974792 / seconds
Query Executed:select id FROM `nc` where city='Horse Shoe' && SIC_code='8062'DB:business_master_new
loadtime:0.94181990623474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.94187498092651 / seconds
Query Executed:select id FROM `nc` where city='Hot Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.94374990463257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubert' limit 1
loadtime:0.94380307197571 / seconds
Query Executed:select id FROM `nc` where city='Hubert' && SIC_code='8062'DB:business_master_new
loadtime:0.9469780921936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.94704008102417 / seconds
Query Executed:select id FROM `nc` where city='Hudson' && SIC_code='8062'DB:business_master_new
loadtime:0.95214009284973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntersville' limit 1
loadtime:0.95219612121582 / seconds
Query Executed:select id FROM `nc` where city='Huntersville' && SIC_code='8062'DB:business_master_new
loadtime:0.957200050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurdle Mills' limit 1
loadtime:0.95726895332336 / seconds
Query Executed:select id FROM `nc` where city='Hurdle Mills' && SIC_code='8062'DB:business_master_new
loadtime:0.95894002914429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Icard' limit 1
loadtime:0.95899510383606 / seconds
Query Executed:select id FROM `nc` where city='Icard' && SIC_code='8062'DB:business_master_new
loadtime:0.95982789993286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Trail' limit 1
loadtime:0.959881067276 / seconds
Query Executed:select id FROM `nc` where city='Indian Trail' && SIC_code='8062'DB:business_master_new
loadtime:0.96487402915955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Station' limit 1
loadtime:0.96493291854858 / seconds
Query Executed:select id FROM `nc` where city='Iron Station' && SIC_code='8062'DB:business_master_new
loadtime:0.96712899208069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:0.96718192100525 / seconds
Query Executed:select id FROM `nc` where city='Ivanhoe' && SIC_code='8062'DB:business_master_new
loadtime:0.96819996833801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.96825289726257 / seconds
Query Executed:select id FROM `nc` where city='Jackson' && SIC_code='8062'DB:business_master_new
loadtime:0.97029709815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Springs' limit 1
loadtime:0.97035002708435 / seconds
Query Executed:select id FROM `nc` where city='Jackson Springs' && SIC_code='8062'DB:business_master_new
loadtime:0.97135996818542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.97141289710999 / seconds
Query Executed:select id FROM `nc` where city='Jacksonville' && SIC_code='8062'DB:business_master_new
loadtime:0.97645211219788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.9765260219574 / seconds
Query Executed:select id FROM `nc` where city='Jamestown' && SIC_code='8062'DB:business_master_new
loadtime:0.9815399646759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:0.98160791397095 / seconds
Query Executed:select id FROM `nc` where city='Jamesville' && SIC_code='8062'DB:business_master_new
loadtime:0.98321890830994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarvisburg' limit 1
loadtime:0.98327398300171 / seconds
Query Executed:select id FROM `nc` where city='Jarvisburg' && SIC_code='8062'DB:business_master_new
loadtime:0.9842689037323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.98432207107544 / seconds
Query Executed:select id FROM `nc` where city='Jefferson' && SIC_code='8062'DB:business_master_new
loadtime:0.98935294151306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonas Ridge' limit 1
loadtime:0.98942399024963 / seconds
Query Executed:select id FROM `nc` where city='Jonas Ridge' && SIC_code='8062'DB:business_master_new
loadtime:0.99002909660339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.99008297920227 / seconds
Query Executed:select id FROM `nc` where city='Jonesville' && SIC_code='8062'DB:business_master_new
loadtime:0.99329996109009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julian' limit 1
loadtime:0.99335312843323 / seconds
Query Executed:select id FROM `nc` where city='Julian' && SIC_code='8062'DB:business_master_new
loadtime:0.99484705924988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kannapolis' limit 1
loadtime:0.99489998817444 / seconds
Query Executed:select id FROM `nc` where city='Kannapolis' && SIC_code='8062'DB:business_master_new
loadtime:0.99991703033447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelford' limit 1
loadtime:0.99997091293335 / seconds
Query Executed:select id FROM `nc` where city='Kelford' && SIC_code='8062'DB:business_master_new
loadtime:1.0005531311035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelly' limit 1
loadtime:1.0006070137024 / seconds
Query Executed:select id FROM `nc` where city='Kelly' && SIC_code='8062'DB:business_master_new
loadtime:1.0014910697937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenansville' limit 1
loadtime:1.0015439987183 / seconds
Query Executed:select id FROM `nc` where city='Kenansville' && SIC_code='8062'DB:business_master_new
loadtime:1.0065541267395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenly' limit 1
loadtime:1.0066270828247 / seconds
Query Executed:select id FROM `nc` where city='Kenly' && SIC_code='8062'DB:business_master_new
loadtime:1.0116510391235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kernersville' limit 1
loadtime:1.0117061138153 / seconds
Query Executed:select id FROM `nc` where city='Kernersville' && SIC_code='8062'DB:business_master_new
loadtime:1.0167169570923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kill Devil Hills' limit 1
loadtime:1.0167829990387 / seconds
Query Executed:select id FROM `nc` where city='Kill Devil Hills' && SIC_code='8062'DB:business_master_new
loadtime:1.0217649936676 / seconds
Query loaded from cache:select * from geodata_geocity where city='King' limit 1
loadtime:1.0218191146851 / seconds
Query Executed:select id FROM `nc` where city='King' && SIC_code='8062'DB:business_master_new
loadtime:1.0268161296844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Mountain' limit 1
loadtime:1.0268709659576 / seconds
Query Executed:select id FROM `nc` where city='Kings Mountain' && SIC_code='8062'DB:business_master_new
loadtime:1.0319170951843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstown' limit 1
loadtime:1.0319859981537 / seconds
Query Executed:select id FROM `nc` where city='Kingstown' && SIC_code='8062'DB:business_master_new
loadtime:1.0324521064758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinston' limit 1
loadtime:1.032506942749 / seconds
Query Executed:select id FROM `nc` where city='Kinston' && SIC_code='8062'DB:business_master_new
loadtime:1.0376110076904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kipling' limit 1
loadtime:1.0376789569855 / seconds
Query Executed:select id FROM `nc` where city='Kipling' && SIC_code='8062'DB:business_master_new
loadtime:1.0382549762726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittrell' limit 1
loadtime:1.03830909729 / seconds
Query Executed:select id FROM `nc` where city='Kittrell' && SIC_code='8062'DB:business_master_new
loadtime:1.0399560928345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kitty Hawk' limit 1
loadtime:1.0400171279907 / seconds
Query Executed:select id FROM `nc` where city='Kitty Hawk' && SIC_code='8062'DB:business_master_new
loadtime:1.0450239181519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knightdale' limit 1
loadtime:1.045077085495 / seconds
Query Executed:select id FROM `nc` where city='Knightdale' && SIC_code='8062'DB:business_master_new
loadtime:1.0501570701599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knotts Island' limit 1
loadtime:1.0502150058746 / seconds
Query Executed:select id FROM `nc` where city='Knotts Island' && SIC_code='8062'DB:business_master_new
loadtime:1.0512199401855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kure Beach' limit 1
loadtime:1.0512731075287 / seconds
Query Executed:select id FROM `nc` where city='Kure Beach' && SIC_code='8062'DB:business_master_new
loadtime:1.0533220767975 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Grange' limit 1
loadtime:1.053375005722 / seconds
Query Executed:select id FROM `nc` where city='La Grange' && SIC_code='8062'DB:business_master_new
loadtime:1.0589299201965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Junaluska' limit 1
loadtime:1.0589849948883 / seconds
Query Executed:select id FROM `nc` where city='Lake Junaluska' && SIC_code='8062'DB:business_master_new
loadtime:1.060122013092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Lure' limit 1
loadtime:1.0601799488068 / seconds
Query Executed:select id FROM `nc` where city='Lake Lure' && SIC_code='8062'DB:business_master_new
loadtime:1.0628499984741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Santeetlah' limit 1
loadtime:1.0629029273987 / seconds
Query Executed:select id FROM `nc` where city='Lake Santeetlah' && SIC_code='8062'DB:business_master_new
loadtime:1.0632970333099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Toxaway' limit 1
loadtime:1.0633499622345 / seconds
Query Executed:select id FROM `nc` where city='Lake Toxaway' && SIC_code='8062'DB:business_master_new
loadtime:1.0651819705963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Waccamaw' limit 1
loadtime:1.0652348995209 / seconds
Query Executed:select id FROM `nc` where city='Lake Waccamaw' && SIC_code='8062'DB:business_master_new
loadtime:1.0667760372162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:1.0668289661407 / seconds
Query Executed:select id FROM `nc` where city='Lakeview' && SIC_code='8062'DB:business_master_new
loadtime:1.0674760341644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landis' limit 1
loadtime:1.0675280094147 / seconds
Query Executed:select id FROM `nc` where city='Landis' && SIC_code='8062'DB:business_master_new
loadtime:1.0695149898529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:1.0695691108704 / seconds
Query Executed:select id FROM `nc` where city='Lansing' && SIC_code='8062'DB:business_master_new
loadtime:1.0712020397186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lasker' limit 1
loadtime:1.0712540149689 / seconds
Query Executed:select id FROM `nc` where city='Lasker' && SIC_code='8062'DB:business_master_new
loadtime:1.0716760158539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lattimore' limit 1
loadtime:1.0717270374298 / seconds
Query Executed:select id FROM `nc` where city='Lattimore' && SIC_code='8062'DB:business_master_new
loadtime:1.0724980831146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Hill' limit 1
loadtime:1.0725510120392 / seconds
Query Executed:select id FROM `nc` where city='Laurel Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.0744481086731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Springs' limit 1
loadtime:1.0745010375977 / seconds
Query Executed:select id FROM `nc` where city='Laurel Springs' && SIC_code='8062'DB:business_master_new
loadtime:1.0758829116821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurinburg' limit 1
loadtime:1.0759360790253 / seconds
Query Executed:select id FROM `nc` where city='Laurinburg' && SIC_code='8062'DB:business_master_new
loadtime:1.0810360908508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawndale' limit 1
loadtime:1.0811069011688 / seconds
Query Executed:select id FROM `nc` where city='Lawndale' && SIC_code='8062'DB:business_master_new
loadtime:1.0839850902557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawsonville' limit 1
loadtime:1.0840609073639 / seconds
Query Executed:select id FROM `nc` where city='Lawsonville' && SIC_code='8062'DB:business_master_new
loadtime:1.0851271152496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leasburg' limit 1
loadtime:1.085186958313 / seconds
Query Executed:select id FROM `nc` where city='Leasburg' && SIC_code='8062'DB:business_master_new
loadtime:1.0861630439758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:1.0862190723419 / seconds
Query Executed:select id FROM `nc` where city='Leicester' && SIC_code='8062'DB:business_master_new
loadtime:1.0905361175537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:1.0905900001526 / seconds
Query Executed:select id FROM `nc` where city='Leland' && SIC_code='8062'DB:business_master_new
loadtime:1.0955951213837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemon Springs' limit 1
loadtime:1.0956480503082 / seconds
Query Executed:select id FROM `nc` where city='Lemon Springs' && SIC_code='8062'DB:business_master_new
loadtime:1.096312046051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenoir' limit 1
loadtime:1.0963640213013 / seconds
Query Executed:select id FROM `nc` where city='Lenoir' && SIC_code='8062'DB:business_master_new
loadtime:1.101555109024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodville' limit 1
loadtime:1.1016271114349 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodville' && SIC_code='8062'DB:business_master_new
loadtime:1.1029760837555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodvl' limit 1
loadtime:1.1030390262604 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodvl' && SIC_code='8062'DB:business_master_new
loadtime:1.1034910678864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewisville' limit 1
loadtime:1.1035430431366 / seconds
Query Executed:select id FROM `nc` where city='Lewisville' && SIC_code='8062'DB:business_master_new
loadtime:1.1085619926453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.1086161136627 / seconds
Query Executed:select id FROM `nc` where city='Lexington' && SIC_code='8062'DB:business_master_new
loadtime:1.1136300563812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:1.1136980056763 / seconds
Query Executed:select id FROM `nc` where city='Liberty' && SIC_code='8062'DB:business_master_new
loadtime:1.1187260150909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lilesville' limit 1
loadtime:1.1187798976898 / seconds
Query Executed:select id FROM `nc` where city='Lilesville' && SIC_code='8062'DB:business_master_new
loadtime:1.1202700138092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lillington' limit 1
loadtime:1.1203238964081 / seconds
Query Executed:select id FROM `nc` where city='Lillington' && SIC_code='8062'DB:business_master_new
loadtime:1.1253340244293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnton' limit 1
loadtime:1.1253869533539 / seconds
Query Executed:select id FROM `nc` where city='Lincolnton' && SIC_code='8062'DB:business_master_new
loadtime:1.130383014679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:1.1304531097412 / seconds
Query Executed:select id FROM `nc` where city='Linden' && SIC_code='8062'DB:business_master_new
loadtime:1.1323120594025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:1.1323668956757 / seconds
Query Executed:select id FROM `nc` where city='Linville' && SIC_code='8062'DB:business_master_new
loadtime:1.1342630386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville Falls' limit 1
loadtime:1.1343309879303 / seconds
Query Executed:select id FROM `nc` where city='Linville Falls' && SIC_code='8062'DB:business_master_new
loadtime:1.1350169181824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.1350710391998 / seconds
Query Executed:select id FROM `nc` where city='Linwood' && SIC_code='8062'DB:business_master_new
loadtime:1.1366429328918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzerland' limit 1
loadtime:1.136696100235 / seconds
Query Executed:select id FROM `nc` where city='Little Switzerland' && SIC_code='8062'DB:business_master_new
loadtime:1.1374700069427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzrlnd' limit 1
loadtime:1.1375250816345 / seconds
Query Executed:select id FROM `nc` where city='Little Switzrlnd' && SIC_code='8062'DB:business_master_new
loadtime:1.1378819942474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.1379330158234 / seconds
Query Executed:select id FROM `nc` where city='Littleton' && SIC_code='8062'DB:business_master_new
loadtime:1.1429491043091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust' limit 1
loadtime:1.1430110931396 / seconds
Query Executed:select id FROM `nc` where city='Locust' && SIC_code='8062'DB:business_master_new
loadtime:1.1460380554199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longwood' limit 1
loadtime:1.1460919380188 / seconds
Query Executed:select id FROM `nc` where city='Longwood' && SIC_code='8062'DB:business_master_new
loadtime:1.1468350887299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisburg' limit 1
loadtime:1.1468880176544 / seconds
Query Executed:select id FROM `nc` where city='Louisburg' && SIC_code='8062'DB:business_master_new
loadtime:1.1519839763641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.1520619392395 / seconds
Query Executed:select id FROM `nc` where city='Lowell' && SIC_code='8062'DB:business_master_new
loadtime:1.1570410728455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowgap' limit 1
loadtime:1.1570949554443 / seconds
Query Executed:select id FROM `nc` where city='Lowgap' && SIC_code='8062'DB:business_master_new
loadtime:1.158390045166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowland' limit 1
loadtime:1.1584429740906 / seconds
Query Executed:select id FROM `nc` where city='Lowland' && SIC_code='8062'DB:business_master_new
loadtime:1.1589410305023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucama' limit 1
loadtime:1.1589920520782 / seconds
Query Executed:select id FROM `nc` where city='Lucama' && SIC_code='8062'DB:business_master_new
loadtime:1.1608829498291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumber Bridge' limit 1
loadtime:1.1609361171722 / seconds
Query Executed:select id FROM `nc` where city='Lumber Bridge' && SIC_code='8062'DB:business_master_new
loadtime:1.1621220111847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:1.1621789932251 / seconds
Query Executed:select id FROM `nc` where city='Lumberton' && SIC_code='8062'DB:business_master_new
loadtime:1.1672129631042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.1672859191895 / seconds
Query Executed:select id FROM `nc` where city='Lynn' && SIC_code='8062'DB:business_master_new
loadtime:1.168025970459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macclesfield' limit 1
loadtime:1.1680810451508 / seconds
Query Executed:select id FROM `nc` where city='Macclesfield' && SIC_code='8062'DB:business_master_new
loadtime:1.1695699691772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:1.1696228981018 / seconds
Query Executed:select id FROM `nc` where city='Macon' && SIC_code='8062'DB:business_master_new
loadtime:1.1704859733582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.1705379486084 / seconds
Query Executed:select id FROM `nc` where city='Madison' && SIC_code='8062'DB:business_master_new
loadtime:1.1755459308624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maggie Valley' limit 1
loadtime:1.1755990982056 / seconds
Query Executed:select id FROM `nc` where city='Maggie Valley' && SIC_code='8062'DB:business_master_new
loadtime:1.1806020736694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:1.180655002594 / seconds
Query Executed:select id FROM `nc` where city='Magnolia' && SIC_code='8062'DB:business_master_new
loadtime:1.1824429035187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maiden' limit 1
loadtime:1.1824960708618 / seconds
Query Executed:select id FROM `nc` where city='Maiden' && SIC_code='8062'DB:business_master_new
loadtime:1.188029050827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mamers' limit 1
loadtime:1.1880819797516 / seconds
Query Executed:select id FROM `nc` where city='Mamers' && SIC_code='8062'DB:business_master_new
loadtime:1.1886239051819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manns Harbor' limit 1
loadtime:1.188677072525 / seconds
Query Executed:select id FROM `nc` where city='Manns Harbor' && SIC_code='8062'DB:business_master_new
loadtime:1.1896770000458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:1.1897299289703 / seconds
Query Executed:select id FROM `nc` where city='Manson' && SIC_code='8062'DB:business_master_new
loadtime:1.1907179355621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manteo' limit 1
loadtime:1.1907699108124 / seconds
Query Executed:select id FROM `nc` where city='Manteo' && SIC_code='8062'DB:business_master_new
loadtime:1.1957719326019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple' limit 1
loadtime:1.1958250999451 / seconds
Query Executed:select id FROM `nc` where city='Maple' && SIC_code='8062'DB:business_master_new
loadtime:1.1964490413666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Hill' limit 1
loadtime:1.1965019702911 / seconds
Query Executed:select id FROM `nc` where city='Maple Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.1977081298828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble' limit 1
loadtime:1.1977610588074 / seconds
Query Executed:select id FROM `nc` where city='Marble' && SIC_code='8062'DB:business_master_new
loadtime:1.199059009552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margarettsville' limit 1
loadtime:1.1991260051727 / seconds
Query Executed:select id FROM `nc` where city='Margarettsville' && SIC_code='8062'DB:business_master_new
loadtime:1.1996450424194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:1.1996989250183 / seconds
Query Executed:select id FROM `nc` where city='Marietta' && SIC_code='8062'DB:business_master_new
loadtime:1.2002251148224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.2002780437469 / seconds
Query Executed:select id FROM `nc` where city='Marion' && SIC_code='8062'DB:business_master_new
loadtime:1.2053070068359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mars Hill' limit 1
loadtime:1.2053799629211 / seconds
Query Executed:select id FROM `nc` where city='Mars Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.2095699310303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:1.209625005722 / seconds
Query Executed:select id FROM `nc` where city='Marshall' && SIC_code='8062'DB:business_master_new
loadtime:1.215047121048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshallberg' limit 1
loadtime:1.2151129245758 / seconds
Query Executed:select id FROM `nc` where city='Marshallberg' && SIC_code='8062'DB:business_master_new
loadtime:1.2158999443054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshville' limit 1
loadtime:1.2159540653229 / seconds
Query Executed:select id FROM `nc` where city='Marshville' && SIC_code='8062'DB:business_master_new
loadtime:1.2208840847015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marston' limit 1
loadtime:1.2209379673004 / seconds
Query Executed:select id FROM `nc` where city='Marston' && SIC_code='8062'DB:business_master_new
loadtime:1.2217988967896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matthews' limit 1
loadtime:1.221853017807 / seconds
Query Executed:select id FROM `nc` where city='Matthews' && SIC_code='8062'DB:business_master_new
loadtime:1.2269151210785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maury' limit 1
loadtime:1.2269840240479 / seconds
Query Executed:select id FROM `nc` where city='Maury' && SIC_code='8062'DB:business_master_new
loadtime:1.2277369499207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxton' limit 1
loadtime:1.2277910709381 / seconds
Query Executed:select id FROM `nc` where city='Maxton' && SIC_code='8062'DB:business_master_new
loadtime:1.2319660186768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayodan' limit 1
loadtime:1.2320280075073 / seconds
Query Executed:select id FROM `nc` where city='Mayodan' && SIC_code='8062'DB:business_master_new
loadtime:1.2344970703125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maysville' limit 1
loadtime:1.2345509529114 / seconds
Query Executed:select id FROM `nc` where city='Maysville' && SIC_code='8062'DB:business_master_new
loadtime:1.2373769283295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adenville' limit 1
loadtime:1.2374310493469 / seconds
Query Executed:select id FROM `nc` where city='Mc Adenville' && SIC_code='8062'DB:business_master_new
loadtime:1.2383990287781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farlan' limit 1
loadtime:1.2384519577026 / seconds
Query Executed:select id FROM `nc` where city='Mc Farlan' && SIC_code='8062'DB:business_master_new
loadtime:1.2389509677887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Grady' limit 1
loadtime:1.2390120029449 / seconds
Query Executed:select id FROM `nc` where city='Mc Grady' && SIC_code='8062'DB:business_master_new
loadtime:1.2397210597992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Leansville' limit 1
loadtime:1.2397739887238 / seconds
Query Executed:select id FROM `nc` where city='Mc Leansville' && SIC_code='8062'DB:business_master_new
loadtime:1.2429780960083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccain' limit 1
loadtime:1.2430379390717 / seconds
Query Executed:select id FROM `nc` where city='Mccain' && SIC_code='8062'DB:business_master_new
loadtime:1.2434639930725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccutcheon Field' limit 1
loadtime:1.2435169219971 / seconds
Query Executed:select id FROM `nc` where city='Mccutcheon Field' && SIC_code='8062'DB:business_master_new
loadtime:1.2439849376678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mebane' limit 1
loadtime:1.2440469264984 / seconds
Query Executed:select id FROM `nc` where city='Mebane' && SIC_code='8062'DB:business_master_new
loadtime:1.2490649223328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:1.2491180896759 / seconds
Query Executed:select id FROM `nc` where city='Merritt' && SIC_code='8062'DB:business_master_new
loadtime:1.2498121261597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Hill' limit 1
loadtime:1.2498650550842 / seconds
Query Executed:select id FROM `nc` where city='Merry Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.2509009838104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micaville' limit 1
loadtime:1.2509529590607 / seconds
Query Executed:select id FROM `nc` where city='Micaville' && SIC_code='8062'DB:business_master_new
loadtime:1.2517669200897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micro' limit 1
loadtime:1.25181889534 / seconds
Query Executed:select id FROM `nc` where city='Micro' && SIC_code='8062'DB:business_master_new
loadtime:1.2526159286499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:1.252669095993 / seconds
Query Executed:select id FROM `nc` where city='Middleburg' && SIC_code='8062'DB:business_master_new
loadtime:1.2533850669861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlesex' limit 1
loadtime:1.2534379959106 / seconds
Query Executed:select id FROM `nc` where city='Middlesex' && SIC_code='8062'DB:business_master_new
loadtime:1.256129026413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:1.2561860084534 / seconds
Query Executed:select id FROM `nc` where city='Midland' && SIC_code='8062'DB:business_master_new
loadtime:1.2607359886169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway Park' limit 1
loadtime:1.2607889175415 / seconds
Query Executed:select id FROM `nc` where city='Midway Park' && SIC_code='8062'DB:business_master_new
loadtime:1.2624759674072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill Spring' limit 1
loadtime:1.2625288963318 / seconds
Query Executed:select id FROM `nc` where city='Mill Spring' && SIC_code='8062'DB:business_master_new
loadtime:1.2643709182739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Creek' limit 1
loadtime:1.2644391059875 / seconds
Query Executed:select id FROM `nc` where city='Millers Creek' && SIC_code='8062'DB:business_master_new
loadtime:1.2694799900055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills River' limit 1
loadtime:1.2695341110229 / seconds
Query Executed:select id FROM `nc` where city='Mills River' && SIC_code='8062'DB:business_master_new
loadtime:1.2700140476227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.2700660228729 / seconds
Query Executed:select id FROM `nc` where city='Milton' && SIC_code='8062'DB:business_master_new
loadtime:1.2709169387817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukee' limit 1
loadtime:1.270968914032 / seconds
Query Executed:select id FROM `nc` where city='Milwaukee' && SIC_code='8062'DB:business_master_new
loadtime:1.2713439464569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Springs' limit 1
loadtime:1.2713959217072 / seconds
Query Executed:select id FROM `nc` where city='Mineral Springs' && SIC_code='8062'DB:business_master_new
loadtime:1.2722339630127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minneapolis' limit 1
loadtime:1.2722859382629 / seconds
Query Executed:select id FROM `nc` where city='Minneapolis' && SIC_code='8062'DB:business_master_new
loadtime:1.272782087326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Hill' limit 1
loadtime:1.2728340625763 / seconds
Query Executed:select id FROM `nc` where city='Mint Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.2732899188995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Misenheimer' limit 1
loadtime:1.2733421325684 / seconds
Query Executed:select id FROM `nc` where city='Misenheimer' && SIC_code='8062'DB:business_master_new
loadtime:1.2738769054413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mocksville' limit 1
loadtime:1.2739269733429 / seconds
Query Executed:select id FROM `nc` where city='Mocksville' && SIC_code='8062'DB:business_master_new
loadtime:1.2790279388428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncure' limit 1
loadtime:1.2790970802307 / seconds
Query Executed:select id FROM `nc` where city='Moncure' && SIC_code='8062'DB:business_master_new
loadtime:1.28071808815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.2807719707489 / seconds
Query Executed:select id FROM `nc` where city='Monroe' && SIC_code='8062'DB:business_master_new
loadtime:1.2857890129089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:1.2858591079712 / seconds
Query Executed:select id FROM `nc` where city='Montezuma' && SIC_code='8062'DB:business_master_new
loadtime:1.2863059043884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montreat' limit 1
loadtime:1.2863600254059 / seconds
Query Executed:select id FROM `nc` where city='Montreat' && SIC_code='8062'DB:business_master_new
loadtime:1.2872400283813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresboro' limit 1
loadtime:1.2872929573059 / seconds
Query Executed:select id FROM `nc` where city='Mooresboro' && SIC_code='8062'DB:business_master_new
loadtime:1.2893300056458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresville' limit 1
loadtime:1.2893841266632 / seconds
Query Executed:select id FROM `nc` where city='Mooresville' && SIC_code='8062'DB:business_master_new
loadtime:1.2943980693817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravian Falls' limit 1
loadtime:1.2944650650024 / seconds
Query Executed:select id FROM `nc` where city='Moravian Falls' && SIC_code='8062'DB:business_master_new
loadtime:1.2961869239807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morehead City' limit 1
loadtime:1.2962410449982 / seconds
Query Executed:select id FROM `nc` where city='Morehead City' && SIC_code='8062'DB:business_master_new
loadtime:1.3012909889221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganton' limit 1
loadtime:1.301362991333 / seconds
Query Executed:select id FROM `nc` where city='Morganton' && SIC_code='8062'DB:business_master_new
loadtime:1.306401014328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:1.3064749240875 / seconds
Query Executed:select id FROM `nc` where city='Morrisville' && SIC_code='8062'DB:business_master_new
loadtime:1.3114910125732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morven' limit 1
loadtime:1.3115570545197 / seconds
Query Executed:select id FROM `nc` where city='Morven' && SIC_code='8062'DB:business_master_new
loadtime:1.3129689693451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Airy' limit 1
loadtime:1.31303191185 / seconds
Query Executed:select id FROM `nc` where city='Mount Airy' && SIC_code='8062'DB:business_master_new
loadtime:1.318027973175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Gilead' limit 1
loadtime:1.3181021213531 / seconds
Query Executed:select id FROM `nc` where city='Mount Gilead' && SIC_code='8062'DB:business_master_new
loadtime:1.3231189250946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:1.3231790065765 / seconds
Query Executed:select id FROM `nc` where city='Mount Holly' && SIC_code='8062'DB:business_master_new
loadtime:1.3282289505005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Mourne' limit 1
loadtime:1.3282821178436 / seconds
Query Executed:select id FROM `nc` where city='Mount Mourne' && SIC_code='8062'DB:business_master_new
loadtime:1.3289759159088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:1.3290359973907 / seconds
Query Executed:select id FROM `nc` where city='Mount Olive' && SIC_code='8062'DB:business_master_new
loadtime:1.3351759910583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:1.3352310657501 / seconds
Query Executed:select id FROM `nc` where city='Mount Pleasant' && SIC_code='8062'DB:business_master_new
loadtime:1.3412220478058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ulla' limit 1
loadtime:1.3412759304047 / seconds
Query Executed:select id FROM `nc` where city='Mount Ulla' && SIC_code='8062'DB:business_master_new
loadtime:1.3427400588989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:1.3427929878235 / seconds
Query Executed:select id FROM `nc` where city='Mountain Home' && SIC_code='8062'DB:business_master_new
loadtime:1.3437829017639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moyock' limit 1
loadtime:1.3438360691071 / seconds
Query Executed:select id FROM `nc` where city='Moyock' && SIC_code='8062'DB:business_master_new
loadtime:1.3488368988037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Airy' limit 1
loadtime:1.3488900661469 / seconds
Query Executed:select id FROM `nc` where city='Mt Airy' && SIC_code='8062'DB:business_master_new
loadtime:1.3495750427246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Gilead' limit 1
loadtime:1.3496279716492 / seconds
Query Executed:select id FROM `nc` where city='Mt Gilead' && SIC_code='8062'DB:business_master_new
loadtime:1.3500699996948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:1.3501219749451 / seconds
Query Executed:select id FROM `nc` where city='Mt Holly' && SIC_code='8062'DB:business_master_new
loadtime:1.3510389328003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Mourne' limit 1
loadtime:1.3510909080505 / seconds
Query Executed:select id FROM `nc` where city='Mt Mourne' && SIC_code='8062'DB:business_master_new
loadtime:1.3515119552612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:1.3515639305115 / seconds
Query Executed:select id FROM `nc` where city='Mt Olive' && SIC_code='8062'DB:business_master_new
loadtime:1.3521199226379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:1.3521780967712 / seconds
Query Executed:select id FROM `nc` where city='Mt Pleasant' && SIC_code='8062'DB:business_master_new
loadtime:1.3528490066528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ulla' limit 1
loadtime:1.3528990745544 / seconds
Query Executed:select id FROM `nc` where city='Mt Ulla' && SIC_code='8062'DB:business_master_new
loadtime:1.3532869815826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murfreesboro' limit 1
loadtime:1.3533399105072 / seconds
Query Executed:select id FROM `nc` where city='Murfreesboro' && SIC_code='8062'DB:business_master_new
loadtime:1.3583409786224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murphy' limit 1
loadtime:1.3583929538727 / seconds
Query Executed:select id FROM `nc` where city='Murphy' && SIC_code='8062'DB:business_master_new
loadtime:1.3634080886841 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Topsail Beach' limit 1
loadtime:1.3634788990021 / seconds
Query Executed:select id FROM `nc` where city='N Topsail Beach' && SIC_code='8062'DB:business_master_new
loadtime:1.3638889789581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nags Head' limit 1
loadtime:1.3639409542084 / seconds
Query Executed:select id FROM `nc` where city='Nags Head' && SIC_code='8062'DB:business_master_new
loadtime:1.3689589500427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nakina' limit 1
loadtime:1.3690359592438 / seconds
Query Executed:select id FROM `nc` where city='Nakina' && SIC_code='8062'DB:business_master_new
loadtime:1.3700580596924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naples' limit 1
loadtime:1.3701128959656 / seconds
Query Executed:select id FROM `nc` where city='Naples' && SIC_code='8062'DB:business_master_new
loadtime:1.3709709644318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:1.371031999588 / seconds
Query Executed:select id FROM `nc` where city='Nashville' && SIC_code='8062'DB:business_master_new
loadtime:1.3760480880737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navassa' limit 1
loadtime:1.3761010169983 / seconds
Query Executed:select id FROM `nc` where city='Navassa' && SIC_code='8062'DB:business_master_new
loadtime:1.3765621185303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nebo' limit 1
loadtime:1.3766140937805 / seconds
Query Executed:select id FROM `nc` where city='Nebo' && SIC_code='8062'DB:business_master_new
loadtime:1.3788499832153 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bern' limit 1
loadtime:1.3789041042328 / seconds
Query Executed:select id FROM `nc` where city='New Bern' && SIC_code='8062'DB:business_master_new
loadtime:1.3839199542999 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hill' limit 1
loadtime:1.3839910030365 / seconds
Query Executed:select id FROM `nc` where city='New Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.3854229450226 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.3854780197144 / seconds
Query Executed:select id FROM `nc` where city='New London' && SIC_code='8062'DB:business_master_new
loadtime:1.388209104538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:1.3882761001587 / seconds
Query Executed:select id FROM `nc` where city='Newell' && SIC_code='8062'DB:business_master_new
loadtime:1.3891711235046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newland' limit 1
loadtime:1.3892269134521 / seconds
Query Executed:select id FROM `nc` where city='Newland' && SIC_code='8062'DB:business_master_new
loadtime:1.3942339420319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.3942999839783 / seconds
Query Executed:select id FROM `nc` where city='Newport' && SIC_code='8062'DB:business_master_new
loadtime:1.3993039131165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.3993580341339 / seconds
Query Executed:select id FROM `nc` where city='Newton' && SIC_code='8062'DB:business_master_new
loadtime:1.4044198989868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Grove' limit 1
loadtime:1.40447306633 / seconds
Query Executed:select id FROM `nc` where city='Newton Grove' && SIC_code='8062'DB:business_master_new
loadtime:1.407989025116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norlina' limit 1
loadtime:1.4080500602722 / seconds
Query Executed:select id FROM `nc` where city='Norlina' && SIC_code='8062'DB:business_master_new
loadtime:1.4101409912109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norman' limit 1
loadtime:1.4102129936218 / seconds
Query Executed:select id FROM `nc` where city='Norman' && SIC_code='8062'DB:business_master_new
loadtime:1.4107809066772 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Wilkesboro' limit 1
loadtime:1.4108340740204 / seconds
Query Executed:select id FROM `nc` where city='North Wilkesboro' && SIC_code='8062'DB:business_master_new
loadtime:1.4158871173859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:1.4159560203552 / seconds
Query Executed:select id FROM `nc` where city='Norwood' && SIC_code='8062'DB:business_master_new
loadtime:1.419783115387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:1.4198501110077 / seconds
Query Executed:select id FROM `nc` where city='Oak City' && SIC_code='8062'DB:business_master_new
loadtime:1.4209589958191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Island' limit 1
loadtime:1.4210231304169 / seconds
Query Executed:select id FROM `nc` where city='Oak Island' && SIC_code='8062'DB:business_master_new
loadtime:1.4267671108246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Ridge' limit 1
loadtime:1.4268190860748 / seconds
Query Executed:select id FROM `nc` where city='Oak Ridge' && SIC_code='8062'DB:business_master_new
loadtime:1.4298009872437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakboro' limit 1
loadtime:1.4298539161682 / seconds
Query Executed:select id FROM `nc` where city='Oakboro' && SIC_code='8062'DB:business_master_new
loadtime:1.4332220554352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Isle Beach' limit 1
loadtime:1.4332749843597 / seconds
Query Executed:select id FROM `nc` where city='Ocean Isle Beach' && SIC_code='8062'DB:business_master_new
loadtime:1.4397571086884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocracoke' limit 1
loadtime:1.4398109912872 / seconds
Query Executed:select id FROM `nc` where city='Ocracoke' && SIC_code='8062'DB:business_master_new
loadtime:1.4425001144409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Fort' limit 1
loadtime:1.4425530433655 / seconds
Query Executed:select id FROM `nc` where city='Old Fort' && SIC_code='8062'DB:business_master_new
loadtime:1.4454629421234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:1.4455161094666 / seconds
Query Executed:select id FROM `nc` where city='Olin' && SIC_code='8062'DB:business_master_new
loadtime:1.4464740753174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivia' limit 1
loadtime:1.4465270042419 / seconds
Query Executed:select id FROM `nc` where city='Olivia' && SIC_code='8062'DB:business_master_new
loadtime:1.4475209712982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriental' limit 1
loadtime:1.4475739002228 / seconds
Query Executed:select id FROM `nc` where city='Oriental' && SIC_code='8062'DB:business_master_new
loadtime:1.4497020244598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orrum' limit 1
loadtime:1.4497549533844 / seconds
Query Executed:select id FROM `nc` where city='Orrum' && SIC_code='8062'DB:business_master_new
loadtime:1.4507229328156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otto' limit 1
loadtime:1.450777053833 / seconds
Query Executed:select id FROM `nc` where city='Otto' && SIC_code='8062'DB:business_master_new
loadtime:1.4520270824432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.4520809650421 / seconds
Query Executed:select id FROM `nc` where city='Oxford' && SIC_code='8062'DB:business_master_new
loadtime:1.4572279453278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pantego' limit 1
loadtime:1.4572989940643 / seconds
Query Executed:select id FROM `nc` where city='Pantego' && SIC_code='8062'DB:business_master_new
loadtime:1.459538936615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkton' limit 1
loadtime:1.4595959186554 / seconds
Query Executed:select id FROM `nc` where city='Parkton' && SIC_code='8062'DB:business_master_new
loadtime:1.4614779949188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmele' limit 1
loadtime:1.4615309238434 / seconds
Query Executed:select id FROM `nc` where city='Parmele' && SIC_code='8062'DB:business_master_new
loadtime:1.4620249271393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:1.4620769023895 / seconds
Query Executed:select id FROM `nc` where city='Patterson' && SIC_code='8062'DB:business_master_new
loadtime:1.4627571105957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Creek' limit 1
loadtime:1.4628090858459 / seconds
Query Executed:select id FROM `nc` where city='Paw Creek' && SIC_code='8062'DB:business_master_new
loadtime:1.4639120101929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peachland' limit 1
loadtime:1.4639649391174 / seconds
Query Executed:select id FROM `nc` where city='Peachland' && SIC_code='8062'DB:business_master_new
loadtime:1.4656519889832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.4657049179077 / seconds
Query Executed:select id FROM `nc` where city='Pelham' && SIC_code='8062'DB:business_master_new
loadtime:1.4669940471649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.467052936554 / seconds
Query Executed:select id FROM `nc` where city='Pembroke' && SIC_code='8062'DB:business_master_new
loadtime:1.472088098526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:1.4721410274506 / seconds
Query Executed:select id FROM `nc` where city='Pendleton' && SIC_code='8062'DB:business_master_new
loadtime:1.4728190898895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penland' limit 1
loadtime:1.4728710651398 / seconds
Query Executed:select id FROM `nc` where city='Penland' && SIC_code='8062'DB:business_master_new
loadtime:1.4734380245209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penrose' limit 1
loadtime:1.4734909534454 / seconds
Query Executed:select id FROM `nc` where city='Penrose' && SIC_code='8062'DB:business_master_new
loadtime:1.4744279384613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pfafftown' limit 1
loadtime:1.4744811058044 / seconds
Query Executed:select id FROM `nc` where city='Pfafftown' && SIC_code='8062'DB:business_master_new
loadtime:1.4783530235291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pikeville' limit 1
loadtime:1.4784059524536 / seconds
Query Executed:select id FROM `nc` where city='Pikeville' && SIC_code='8062'DB:business_master_new
loadtime:1.4813361167908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mountain' limit 1
loadtime:1.4813990592957 / seconds
Query Executed:select id FROM `nc` where city='Pilot Mountain' && SIC_code='8062'DB:business_master_new
loadtime:1.4864749908447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hall' limit 1
loadtime:1.4865300655365 / seconds
Query Executed:select id FROM `nc` where city='Pine Hall' && SIC_code='8062'DB:business_master_new
loadtime:1.4874150753021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Knoll Shrs' limit 1
loadtime:1.4874680042267 / seconds
Query Executed:select id FROM `nc` where city='Pine Knoll Shrs' && SIC_code='8062'DB:business_master_new
loadtime:1.4879009723663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Level' limit 1
loadtime:1.4879519939423 / seconds
Query Executed:select id FROM `nc` where city='Pine Level' && SIC_code='8062'DB:business_master_new
loadtime:1.489275932312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinebluff' limit 1
loadtime:1.4893290996552 / seconds
Query Executed:select id FROM `nc` where city='Pinebluff' && SIC_code='8062'DB:business_master_new
loadtime:1.4906630516052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:1.4907150268555 / seconds
Query Executed:select id FROM `nc` where city='Pinehurst' && SIC_code='8062'DB:business_master_new
loadtime:1.4957690238953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineola' limit 1
loadtime:1.4958419799805 / seconds
Query Executed:select id FROM `nc` where city='Pineola' && SIC_code='8062'DB:business_master_new
loadtime:1.4966809749603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetops' limit 1
loadtime:1.4967370033264 / seconds
Query Executed:select id FROM `nc` where city='Pinetops' && SIC_code='8062'DB:business_master_new
loadtime:1.4992909431458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetown' limit 1
loadtime:1.4993579387665 / seconds
Query Executed:select id FROM `nc` where city='Pinetown' && SIC_code='8062'DB:business_master_new
loadtime:1.5008699893951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:1.5009229183197 / seconds
Query Executed:select id FROM `nc` where city='Pineville' && SIC_code='8062'DB:business_master_new
loadtime:1.5059769153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Creek' limit 1
loadtime:1.506040096283 / seconds
Query Executed:select id FROM `nc` where city='Piney Creek' && SIC_code='8062'DB:business_master_new
loadtime:1.5068359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pink Hill' limit 1
loadtime:1.5068891048431 / seconds
Query Executed:select id FROM `nc` where city='Pink Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.5105049610138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinnacle' limit 1
loadtime:1.5105581283569 / seconds
Query Executed:select id FROM `nc` where city='Pinnacle' && SIC_code='8062'DB:business_master_new
loadtime:1.5129420757294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah Forest' limit 1
loadtime:1.5129950046539 / seconds
Query Executed:select id FROM `nc` where city='Pisgah Forest' && SIC_code='8062'DB:business_master_new
loadtime:1.5169060230255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:1.5169730186462 / seconds
Query Executed:select id FROM `nc` where city='Pittsboro' && SIC_code='8062'DB:business_master_new
loadtime:1.5220539569855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Garden' limit 1
loadtime:1.5221180915833 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Garden' && SIC_code='8062'DB:business_master_new
loadtime:1.5252361297607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:1.5252909660339 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.5258979797363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plumtree' limit 1
loadtime:1.5259499549866 / seconds
Query Executed:select id FROM `nc` where city='Plumtree' && SIC_code='8062'DB:business_master_new
loadtime:1.5265769958496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.5266311168671 / seconds
Query Executed:select id FROM `nc` where city='Plymouth' && SIC_code='8062'DB:business_master_new
loadtime:1.5316970348358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Harbor' limit 1
loadtime:1.5317690372467 / seconds
Query Executed:select id FROM `nc` where city='Point Harbor' && SIC_code='8062'DB:business_master_new
loadtime:1.5332469940186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkton' limit 1
loadtime:1.5333020687103 / seconds
Query Executed:select id FROM `nc` where city='Polkton' && SIC_code='8062'DB:business_master_new
loadtime:1.5353219509125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkville' limit 1
loadtime:1.535383939743 / seconds
Query Executed:select id FROM `nc` where city='Polkville' && SIC_code='8062'DB:business_master_new
loadtime:1.5362360477448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollocksville' limit 1
loadtime:1.5362949371338 / seconds
Query Executed:select id FROM `nc` where city='Pollocksville' && SIC_code='8062'DB:business_master_new
loadtime:1.5380289554596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope A F B' limit 1
loadtime:1.5380821228027 / seconds
Query Executed:select id FROM `nc` where city='Pope A F B' && SIC_code='8062'DB:business_master_new
loadtime:1.5385069847107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope Afb' limit 1
loadtime:1.5385599136353 / seconds
Query Executed:select id FROM `nc` where city='Pope Afb' && SIC_code='8062'DB:business_master_new
loadtime:1.5390980243683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplar Branch' limit 1
loadtime:1.5391509532928 / seconds
Query Executed:select id FROM `nc` where city='Poplar Branch' && SIC_code='8062'DB:business_master_new
loadtime:1.5400700569153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potecasi' limit 1
loadtime:1.5401220321655 / seconds
Query Executed:select id FROM `nc` where city='Potecasi' && SIC_code='8062'DB:business_master_new
loadtime:1.5406119823456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powells Point' limit 1
loadtime:1.5406639575958 / seconds
Query Executed:select id FROM `nc` where city='Powells Point' && SIC_code='8062'DB:business_master_new
loadtime:1.5426349639893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powellsville' limit 1
loadtime:1.5426881313324 / seconds
Query Executed:select id FROM `nc` where city='Powellsville' && SIC_code='8062'DB:business_master_new
loadtime:1.5432889461517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.5433599948883 / seconds
Query Executed:select id FROM `nc` where city='Princeton' && SIC_code='8062'DB:business_master_new
loadtime:1.5468211174011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeville' limit 1
loadtime:1.5468759536743 / seconds
Query Executed:select id FROM `nc` where city='Princeville' && SIC_code='8062'DB:business_master_new
loadtime:1.547287940979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorville' limit 1
loadtime:1.5473411083221 / seconds
Query Executed:select id FROM `nc` where city='Proctorville' && SIC_code='8062'DB:business_master_new
loadtime:1.5478830337524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect Hill' limit 1
loadtime:1.5479350090027 / seconds
Query Executed:select id FROM `nc` where city='Prospect Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.5488209724426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:1.5488750934601 / seconds
Query Executed:select id FROM `nc` where city='Providence' && SIC_code='8062'DB:business_master_new
loadtime:1.5500690937042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purlear' limit 1
loadtime:1.5501220226288 / seconds
Query Executed:select id FROM `nc` where city='Purlear' && SIC_code='8062'DB:business_master_new
loadtime:1.5513288974762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raeford' limit 1
loadtime:1.5513820648193 / seconds
Query Executed:select id FROM `nc` where city='Raeford' && SIC_code='8062'DB:business_master_new
loadtime:1.5564811229706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:1.5565509796143 / seconds
Query Executed:select id FROM `nc` where city='Raleigh' && SIC_code='8062'DB:business_master_new
loadtime:1.5615930557251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramseur' limit 1
loadtime:1.5616800785065 / seconds
Query Executed:select id FROM `nc` where city='Ramseur' && SIC_code='8062'DB:business_master_new
loadtime:1.5667281150818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randleman' limit 1
loadtime:1.5667839050293 / seconds
Query Executed:select id FROM `nc` where city='Randleman' && SIC_code='8062'DB:business_master_new
loadtime:1.5718219280243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:1.5718851089478 / seconds
Query Executed:select id FROM `nc` where city='Red Oak' && SIC_code='8062'DB:business_master_new
loadtime:1.5726909637451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Springs' limit 1
loadtime:1.5727460384369 / seconds
Query Executed:select id FROM `nc` where city='Red Springs' && SIC_code='8062'DB:business_master_new
loadtime:1.577789068222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidsville' limit 1
loadtime:1.5778429508209 / seconds
Query Executed:select id FROM `nc` where city='Reidsville' && SIC_code='8062'DB:business_master_new
loadtime:1.5828750133514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Resrch Trngle Pk' limit 1
loadtime:1.5829429626465 / seconds
Query Executed:select id FROM `nc` where city='Resrch Trngle Pk' && SIC_code='8062'DB:business_master_new
loadtime:1.5835030078888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rex' limit 1
loadtime:1.5835559368134 / seconds
Query Executed:select id FROM `nc` where city='Rex' && SIC_code='8062'DB:business_master_new
loadtime:1.5840389728546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodhiss' limit 1
loadtime:1.5840919017792 / seconds
Query Executed:select id FROM `nc` where city='Rhodhiss' && SIC_code='8062'DB:business_master_new
loadtime:1.5846509933472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Square' limit 1
loadtime:1.5847039222717 / seconds
Query Executed:select id FROM `nc` where city='Rich Square' && SIC_code='8062'DB:business_master_new
loadtime:1.5865120887756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:1.5865650177002 / seconds
Query Executed:select id FROM `nc` where city='Richfield' && SIC_code='8062'DB:business_master_new
loadtime:1.5884521007538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:1.5885050296783 / seconds
Query Executed:select id FROM `nc` where city='Richlands' && SIC_code='8062'DB:business_master_new
loadtime:1.5935769081116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgecrest' limit 1
loadtime:1.593631029129 / seconds
Query Executed:select id FROM `nc` where city='Ridgecrest' && SIC_code='8062'DB:business_master_new
loadtime:1.5942850112915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:1.5943369865417 / seconds
Query Executed:select id FROM `nc` where city='Ridgeway' && SIC_code='8062'DB:business_master_new
loadtime:1.594820022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riegelwood' limit 1
loadtime:1.5948719978333 / seconds
Query Executed:select id FROM `nc` where city='Riegelwood' && SIC_code='8062'DB:business_master_new
loadtime:1.5971839427948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke Rapids' limit 1
loadtime:1.5972380638123 / seconds
Query Executed:select id FROM `nc` where city='Roanoke Rapids' && SIC_code='8062'DB:business_master_new
loadtime:1.6022439002991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring Gap' limit 1
loadtime:1.6023170948029 / seconds
Query Executed:select id FROM `nc` where city='Roaring Gap' && SIC_code='8062'DB:business_master_new
loadtime:1.603187084198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring River' limit 1
loadtime:1.6032419204712 / seconds
Query Executed:select id FROM `nc` where city='Roaring River' && SIC_code='8062'DB:business_master_new
loadtime:1.6049249172211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbins' limit 1
loadtime:1.6049780845642 / seconds
Query Executed:select id FROM `nc` where city='Robbins' && SIC_code='8062'DB:business_master_new
loadtime:1.6080329418182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbinsville' limit 1
loadtime:1.6080870628357 / seconds
Query Executed:select id FROM `nc` where city='Robbinsville' && SIC_code='8062'DB:business_master_new
loadtime:1.6132619380951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robersonville' limit 1
loadtime:1.6133279800415 / seconds
Query Executed:select id FROM `nc` where city='Robersonville' && SIC_code='8062'DB:business_master_new
loadtime:1.6164059638977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockingham' limit 1
loadtime:1.6164600849152 / seconds
Query Executed:select id FROM `nc` where city='Rockingham' && SIC_code='8062'DB:business_master_new
loadtime:1.621484041214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:1.621551990509 / seconds
Query Executed:select id FROM `nc` where city='Rockwell' && SIC_code='8062'DB:business_master_new
loadtime:1.6256940364838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:1.6257491111755 / seconds
Query Executed:select id FROM `nc` where city='Rocky Mount' && SIC_code='8062'DB:business_master_new
loadtime:1.630793094635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Point' limit 1
loadtime:1.6308701038361 / seconds
Query Executed:select id FROM `nc` where city='Rocky Point' && SIC_code='8062'DB:business_master_new
loadtime:1.6343250274658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodanthe' limit 1
loadtime:1.6343801021576 / seconds
Query Executed:select id FROM `nc` where city='Rodanthe' && SIC_code='8062'DB:business_master_new
loadtime:1.6356229782104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roduco' limit 1
loadtime:1.6356770992279 / seconds
Query Executed:select id FROM `nc` where city='Roduco' && SIC_code='8062'DB:business_master_new
loadtime:1.636146068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolesville' limit 1
loadtime:1.6362040042877 / seconds
Query Executed:select id FROM `nc` where city='Rolesville' && SIC_code='8062'DB:business_master_new
loadtime:1.6383500099182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ronda' limit 1
loadtime:1.6384029388428 / seconds
Query Executed:select id FROM `nc` where city='Ronda' && SIC_code='8062'DB:business_master_new
loadtime:1.6401920318604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roper' limit 1
loadtime:1.6402459144592 / seconds
Query Executed:select id FROM `nc` where city='Roper' && SIC_code='8062'DB:business_master_new
loadtime:1.6421799659729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:1.642233133316 / seconds
Query Executed:select id FROM `nc` where city='Rose Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.6466290950775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseboro' limit 1
loadtime:1.6466820240021 / seconds
Query Executed:select id FROM `nc` where city='Roseboro' && SIC_code='8062'DB:business_master_new
loadtime:1.6514110565186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosman' limit 1
loadtime:1.6514649391174 / seconds
Query Executed:select id FROM `nc` where city='Rosman' && SIC_code='8062'DB:business_master_new
loadtime:1.6530771255493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rougemont' limit 1
loadtime:1.6531300544739 / seconds
Query Executed:select id FROM `nc` where city='Rougemont' && SIC_code='8062'DB:business_master_new
loadtime:1.6556880474091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowland' limit 1
loadtime:1.6557419300079 / seconds
Query Executed:select id FROM `nc` where city='Rowland' && SIC_code='8062'DB:business_master_new
loadtime:1.6585540771484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxboro' limit 1
loadtime:1.6586079597473 / seconds
Query Executed:select id FROM `nc` where city='Roxboro' && SIC_code='8062'DB:business_master_new
loadtime:1.6636800765991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxobel' limit 1
loadtime:1.6637499332428 / seconds
Query Executed:select id FROM `nc` where city='Roxobel' && SIC_code='8062'DB:business_master_new
loadtime:1.6644639968872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:1.6645181179047 / seconds
Query Executed:select id FROM `nc` where city='Ruffin' && SIC_code='8062'DB:business_master_new
loadtime:1.666069984436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Hall' limit 1
loadtime:1.6661229133606 / seconds
Query Executed:select id FROM `nc` where city='Rural Hall' && SIC_code='8062'DB:business_master_new
loadtime:1.6711621284485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford Clg' limit 1
loadtime:1.6712191104889 / seconds
Query Executed:select id FROM `nc` where city='Rutherford Clg' && SIC_code='8062'DB:business_master_new
loadtime:1.6716680526733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford College' limit 1
loadtime:1.6717190742493 / seconds
Query Executed:select id FROM `nc` where city='Rutherford College' && SIC_code='8062'DB:business_master_new
loadtime:1.6727850437164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherfordton' limit 1
loadtime:1.6728370189667 / seconds
Query Executed:select id FROM `nc` where city='Rutherfordton' && SIC_code='8062'DB:business_master_new
loadtime:1.6778891086578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Pauls' limit 1
loadtime:1.6779570579529 / seconds
Query Executed:select id FROM `nc` where city='Saint Pauls' && SIC_code='8062'DB:business_master_new
loadtime:1.6829719543457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salemburg' limit 1
loadtime:1.6830348968506 / seconds
Query Executed:select id FROM `nc` where city='Salemburg' && SIC_code='8062'DB:business_master_new
loadtime:1.684947013855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:1.6850070953369 / seconds
Query Executed:select id FROM `nc` where city='Salisbury' && SIC_code='8062'DB:business_master_new
loadtime:1.6901021003723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salter Path' limit 1
loadtime:1.690220117569 / seconds
Query Executed:select id FROM `nc` where city='Salter Path' && SIC_code='8062'DB:business_master_new
loadtime:1.6914119720459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:1.6914911270142 / seconds
Query Executed:select id FROM `nc` where city='Saluda' && SIC_code='8062'DB:business_master_new
loadtime:1.6937041282654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salvo' limit 1
loadtime:1.6937789916992 / seconds
Query Executed:select id FROM `nc` where city='Salvo' && SIC_code='8062'DB:business_master_new
loadtime:1.6944699287415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Ridge' limit 1
loadtime:1.6945431232452 / seconds
Query Executed:select id FROM `nc` where city='Sandy Ridge' && SIC_code='8062'DB:business_master_new
loadtime:1.6958799362183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:1.6959578990936 / seconds
Query Executed:select id FROM `nc` where city='Sanford' && SIC_code='8062'DB:business_master_new
loadtime:1.7010390758514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapphire' limit 1
loadtime:1.7011420726776 / seconds
Query Executed:select id FROM `nc` where city='Sapphire' && SIC_code='8062'DB:business_master_new
loadtime:1.7025310993195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga' limit 1
loadtime:1.7026090621948 / seconds
Query Executed:select id FROM `nc` where city='Saratoga' && SIC_code='8062'DB:business_master_new
loadtime:1.7032160758972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxapahaw' limit 1
loadtime:1.7032930850983 / seconds
Query Executed:select id FROM `nc` where city='Saxapahaw' && SIC_code='8062'DB:business_master_new
loadtime:1.7039320468903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scaly Mountain' limit 1
loadtime:1.7040159702301 / seconds
Query Executed:select id FROM `nc` where city='Scaly Mountain' && SIC_code='8062'DB:business_master_new
loadtime:1.7049129009247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland Neck' limit 1
loadtime:1.7049911022186 / seconds
Query Executed:select id FROM `nc` where city='Scotland Neck' && SIC_code='8062'DB:business_master_new
loadtime:1.7083880901337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:1.7084701061249 / seconds
Query Executed:select id FROM `nc` where city='Scotts' && SIC_code='8062'DB:business_master_new
loadtime:1.7090349197388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:1.7091109752655 / seconds
Query Executed:select id FROM `nc` where city='Scottville' && SIC_code='8062'DB:business_master_new
loadtime:1.7096500396729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:1.7097289562225 / seconds
Query Executed:select id FROM `nc` where city='Scranton' && SIC_code='8062'DB:business_master_new
loadtime:1.7103741168976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaboard' limit 1
loadtime:1.7104499340057 / seconds
Query Executed:select id FROM `nc` where city='Seaboard' && SIC_code='8062'DB:business_master_new
loadtime:1.7116279602051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seagrove' limit 1
loadtime:1.7117040157318 / seconds
Query Executed:select id FROM `nc` where city='Seagrove' && SIC_code='8062'DB:business_master_new
loadtime:1.715215921402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealevel' limit 1
loadtime:1.715292930603 / seconds
Query Executed:select id FROM `nc` where city='Sealevel' && SIC_code='8062'DB:business_master_new
loadtime:1.7159991264343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedalia' limit 1
loadtime:1.7160820960999 / seconds
Query Executed:select id FROM `nc` where city='Sedalia' && SIC_code='8062'DB:business_master_new
loadtime:1.7166309356689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:1.716705083847 / seconds
Query Executed:select id FROM `nc` where city='Selma' && SIC_code='8062'DB:business_master_new
loadtime:1.7217810153961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semora' limit 1
loadtime:1.7218630313873 / seconds
Query Executed:select id FROM `nc` where city='Semora' && SIC_code='8062'DB:business_master_new
loadtime:1.722904920578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semr Johnson Afb' limit 1
loadtime:1.7229819297791 / seconds
Query Executed:select id FROM `nc` where city='Semr Johnson Afb' && SIC_code='8062'DB:business_master_new
loadtime:1.7234120368958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Devils' limit 1
loadtime:1.7234890460968 / seconds
Query Executed:select id FROM `nc` where city='Seven Devils' && SIC_code='8062'DB:business_master_new
loadtime:1.7238790988922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Springs' limit 1
loadtime:1.723953962326 / seconds
Query Executed:select id FROM `nc` where city='Seven Springs' && SIC_code='8062'DB:business_master_new
loadtime:1.7255439758301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:1.7256200313568 / seconds
Query Executed:select id FROM `nc` where city='Severn' && SIC_code='8062'DB:business_master_new
loadtime:1.7262670993805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shallotte' limit 1
loadtime:1.7263429164886 / seconds
Query Executed:select id FROM `nc` where city='Shallotte' && SIC_code='8062'DB:business_master_new
loadtime:1.7314109802246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:1.7314920425415 / seconds
Query Executed:select id FROM `nc` where city='Shannon' && SIC_code='8062'DB:business_master_new
loadtime:1.7329869270325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:1.7330720424652 / seconds
Query Executed:select id FROM `nc` where city='Sharpsburg' && SIC_code='8062'DB:business_master_new
loadtime:1.7350900173187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawboro' limit 1
loadtime:1.7351670265198 / seconds
Query Executed:select id FROM `nc` where city='Shawboro' && SIC_code='8062'DB:business_master_new
loadtime:1.736181974411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:1.7362589836121 / seconds
Query Executed:select id FROM `nc` where city='Shelby' && SIC_code='8062'DB:business_master_new
loadtime:1.7413530349731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrills Ford' limit 1
loadtime:1.7414290904999 / seconds
Query Executed:select id FROM `nc` where city='Sherrills Ford' && SIC_code='8062'DB:business_master_new
loadtime:1.7439200878143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:1.7439749240875 / seconds
Query Executed:select id FROM `nc` where city='Shiloh' && SIC_code='8062'DB:business_master_new
loadtime:1.7448461055756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siler City' limit 1
loadtime:1.7448999881744 / seconds
Query Executed:select id FROM `nc` where city='Siler City' && SIC_code='8062'DB:business_master_new
loadtime:1.7499449253082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siloam' limit 1
loadtime:1.750020980835 / seconds
Query Executed:select id FROM `nc` where city='Siloam' && SIC_code='8062'DB:business_master_new
loadtime:1.7509479522705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpson' limit 1
loadtime:1.7510089874268 / seconds
Query Executed:select id FROM `nc` where city='Simpson' && SIC_code='8062'DB:business_master_new
loadtime:1.7517220973969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sims' limit 1
loadtime:1.7517759799957 / seconds
Query Executed:select id FROM `nc` where city='Sims' && SIC_code='8062'DB:business_master_new
loadtime:1.7537610530853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skyland' limit 1
loadtime:1.7538139820099 / seconds
Query Executed:select id FROM `nc` where city='Skyland' && SIC_code='8062'DB:business_master_new
loadtime:1.7560889720917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:1.7561419010162 / seconds
Query Executed:select id FROM `nc` where city='Smithfield' && SIC_code='8062'DB:business_master_new
loadtime:1.7618288993835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:1.7618989944458 / seconds
Query Executed:select id FROM `nc` where city='Smyrna' && SIC_code='8062'DB:business_master_new
loadtime:1.7628021240234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sneads Ferry' limit 1
loadtime:1.7628560066223 / seconds
Query Executed:select id FROM `nc` where city='Sneads Ferry' && SIC_code='8062'DB:business_master_new
loadtime:1.767569065094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Camp' limit 1
loadtime:1.7676360607147 / seconds
Query Executed:select id FROM `nc` where city='Snow Camp' && SIC_code='8062'DB:business_master_new
loadtime:1.7698769569397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Hill' limit 1
loadtime:1.7699360847473 / seconds
Query Executed:select id FROM `nc` where city='Snow Hill' && SIC_code='8062'DB:business_master_new
loadtime:1.7758851051331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sophia' limit 1
loadtime:1.7759399414062 / seconds
Query Executed:select id FROM `nc` where city='Sophia' && SIC_code='8062'DB:business_master_new
loadtime:1.7790400981903 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Brunswick' limit 1
loadtime:1.7790949344635 / seconds
Query Executed:select id FROM `nc` where city='South Brunswick' && SIC_code='8062'DB:business_master_new
loadtime:1.7797179222107 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Mills' limit 1
loadtime:1.7797710895538 / seconds
Query Executed:select id FROM `nc` where city='South Mills' && SIC_code='8062'DB:business_master_new
loadtime:1.7811279296875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Pines' limit 1
loadtime:1.781182050705 / seconds
Query Executed:select id FROM `nc` where city='Southern Pines' && SIC_code='8062'DB:business_master_new
loadtime:1.7862439155579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Shores' limit 1
loadtime:1.7863121032715 / seconds
Query Executed:select id FROM `nc` where city='Southern Shores' && SIC_code='8062'DB:business_master_new
loadtime:1.78679895401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southmont' limit 1
loadtime:1.7868521213531 / seconds
Query Executed:select id FROM `nc` where city='Southmont' && SIC_code='8062'DB:business_master_new
loadtime:1.7877309322357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:1.7877840995789 / seconds
Query Executed:select id FROM `nc` where city='Southport' && SIC_code='8062'DB:business_master_new
loadtime:1.7928500175476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:1.792918920517 / seconds
Query Executed:select id FROM `nc` where city='Sparta' && SIC_code='8062'DB:business_master_new
loadtime:1.7979900836945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speed' limit 1
loadtime:1.7980709075928 / seconds
Query Executed:select id FROM `nc` where city='Speed' && SIC_code='8062'DB:business_master_new
loadtime:1.798583984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:1.7986400127411 / seconds
Query Executed:select id FROM `nc` where city='Spencer' && SIC_code='8062'DB:business_master_new
loadtime:1.801078081131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spindale' limit 1
loadtime:1.8011310100555 / seconds
Query Executed:select id FROM `nc` where city='Spindale' && SIC_code='8062'DB:business_master_new
loadtime:1.8061640262604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Hope' limit 1
loadtime:1.8062219619751 / seconds
Query Executed:select id FROM `nc` where city='Spring Hope' && SIC_code='8062'DB:business_master_new
loadtime:1.8113379478455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:1.8113920688629 / seconds
Query Executed:select id FROM `nc` where city='Spring Lake' && SIC_code='8062'DB:business_master_new
loadtime:1.8164360523224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce Pine' limit 1
loadtime:1.8164889812469 / seconds
Query Executed:select id FROM `nc` where city='Spruce Pine' && SIC_code='8062'DB:business_master_new
loadtime:1.8215529918671 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Pauls' limit 1
loadtime:1.821622133255 / seconds
Query Executed:select id FROM `nc` where city='St Pauls' && SIC_code='8062'DB:business_master_new
loadtime:1.8220450878143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacy' limit 1
loadtime:1.8220989704132 / seconds
Query Executed:select id FROM `nc` where city='Stacy' && SIC_code='8062'DB:business_master_new
loadtime:1.8226249217987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staley' limit 1
loadtime:1.8226780891418 / seconds
Query Executed:select id FROM `nc` where city='Staley' && SIC_code='8062'DB:business_master_new
loadtime:1.8243410587311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stallings' limit 1
loadtime:1.8243939876556 / seconds
Query Executed:select id FROM `nc` where city='Stallings' && SIC_code='8062'DB:business_master_new
loadtime:1.8248040676117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:1.8248560428619 / seconds
Query Executed:select id FROM `nc` where city='Stanfield' && SIC_code='8062'DB:business_master_new
loadtime:1.8267560005188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.8268089294434 / seconds
Query Executed:select id FROM `nc` where city='Stanley' && SIC_code='8062'DB:business_master_new
loadtime:1.8318090438843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stantonsburg' limit 1
loadtime:1.8318619728088 / seconds
Query Executed:select id FROM `nc` where city='Stantonsburg' && SIC_code='8062'DB:business_master_new
loadtime:1.8335371017456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:1.8336000442505 / seconds
Query Executed:select id FROM `nc` where city='Star' && SIC_code='8062'DB:business_master_new
loadtime:1.8352990150452 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Road' limit 1
loadtime:1.8353540897369 / seconds
Query Executed:select id FROM `nc` where city='State Road' && SIC_code='8062'DB:business_master_new
loadtime:1.8372809886932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Statesville' limit 1
loadtime:1.8373351097107 / seconds
Query Executed:select id FROM `nc` where city='Statesville' && SIC_code='8062'DB:business_master_new
loadtime:1.8423690795898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stedman' limit 1
loadtime:1.8424470424652 / seconds
Query Executed:select id FROM `nc` where city='Stedman' && SIC_code='8062'DB:business_master_new
loadtime:1.8474609851837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stella' limit 1
loadtime:1.8475301265717 / seconds
Query Executed:select id FROM `nc` where city='Stella' && SIC_code='8062'DB:business_master_new
loadtime:1.8483109474182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stem' limit 1
loadtime:1.84836602211 / seconds
Query Executed:select id FROM `nc` where city='Stem' && SIC_code='8062'DB:business_master_new
loadtime:1.8494699001312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokes' limit 1
loadtime:1.8495230674744 / seconds
Query Executed:select id FROM `nc` where city='Stokes' && SIC_code='8062'DB:business_master_new
loadtime:1.8505170345306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokesdale' limit 1
loadtime:1.8505699634552 / seconds
Query Executed:select id FROM `nc` where city='Stokesdale' && SIC_code='8062'DB:business_master_new
loadtime:1.8556981086731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:1.8557510375977 / seconds
Query Executed:select id FROM `nc` where city='Stoneville' && SIC_code='8062'DB:business_master_new
loadtime:1.8608169555664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:1.8608710765839 / seconds
Query Executed:select id FROM `nc` where city='Stonewall' && SIC_code='8062'DB:business_master_new
loadtime:1.8614361286163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Point' limit 1
loadtime:1.8614890575409 / seconds
Query Executed:select id FROM `nc` where city='Stony Point' && SIC_code='8062'DB:business_master_new
loadtime:1.8635699748993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stovall' limit 1
loadtime:1.8636229038239 / seconds
Query Executed:select id FROM `nc` where city='Stovall' && SIC_code='8062'DB:business_master_new
loadtime:1.8643279075623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stumpy Point' limit 1
loadtime:1.8643820285797 / seconds
Query Executed:select id FROM `nc` where city='Stumpy Point' && SIC_code='8062'DB:business_master_new
loadtime:1.864944934845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:1.8649959564209 / seconds
Query Executed:select id FROM `nc` where city='Sugar Grove' && SIC_code='8062'DB:business_master_new
loadtime:1.8665220737457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Mountain' limit 1
loadtime:1.8665750026703 / seconds
Query Executed:select id FROM `nc` where city='Sugar Mountain' && SIC_code='8062'DB:business_master_new
loadtime:1.8669469356537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerfield' limit 1
loadtime:1.8669979572296 / seconds
Query Executed:select id FROM `nc` where city='Summerfield' && SIC_code='8062'DB:business_master_new
loadtime:1.8720331192017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunbury' limit 1
loadtime:1.8720860481262 / seconds
Query Executed:select id FROM `nc` where city='Sunbury' && SIC_code='8062'DB:business_master_new
loadtime:1.8735039234161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset Beach' limit 1
loadtime:1.8735570907593 / seconds
Query Executed:select id FROM `nc` where city='Sunset Beach' && SIC_code='8062'DB:business_master_new
loadtime:1.87628698349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:1.8763389587402 / seconds
Query Executed:select id FROM `nc` where city='Supply' && SIC_code='8062'DB:business_master_new
loadtime:1.8813569545746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surf City' limit 1
loadtime:1.8814260959625 / seconds
Query Executed:select id FROM `nc` where city='Surf City' && SIC_code='8062'DB:business_master_new
loadtime:1.881942987442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swannanoa' limit 1
loadtime:1.8819959163666 / seconds
Query Executed:select id FROM `nc` where city='Swannanoa' && SIC_code='8062'DB:business_master_new
loadtime:1.8870050907135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanquarter' limit 1
loadtime:1.8870720863342 / seconds
Query Executed:select id FROM `nc` where city='Swanquarter' && SIC_code='8062'DB:business_master_new
loadtime:1.8920619487762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansboro' limit 1
loadtime:1.892117023468 / seconds
Query Executed:select id FROM `nc` where city='Swansboro' && SIC_code='8062'DB:business_master_new
loadtime:1.8971409797668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swepsonville' limit 1
loadtime:1.8971979618073 / seconds
Query Executed:select id FROM `nc` where city='Swepsonville' && SIC_code='8062'DB:business_master_new
loadtime:1.89790391922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylva' limit 1
loadtime:1.8979561328888 / seconds
Query Executed:select id FROM `nc` where city='Sylva' && SIC_code='8062'DB:business_master_new
loadtime:1.902951002121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor City' limit 1
loadtime:1.9030330181122 / seconds
Query Executed:select id FROM `nc` where city='Tabor City' && SIC_code='8062'DB:business_master_new
loadtime:1.9075961112976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tapoco' limit 1
loadtime:1.9076499938965 / seconds
Query Executed:select id FROM `nc` where city='Tapoco' && SIC_code='8062'DB:business_master_new
loadtime:1.9080719947815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tar Heel' limit 1
loadtime:1.9081239700317 / seconds
Query Executed:select id FROM `nc` where city='Tar Heel' && SIC_code='8062'DB:business_master_new
loadtime:1.9093210697174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarawa Terrace' limit 1
loadtime:1.9093730449677 / seconds
Query Executed:select id FROM `nc` where city='Tarawa Terrace' && SIC_code='8062'DB:business_master_new
loadtime:1.9098100662231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarboro' limit 1
loadtime:1.9098620414734 / seconds
Query Executed:select id FROM `nc` where city='Tarboro' && SIC_code='8062'DB:business_master_new
loadtime:1.9148859977722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:1.9149549007416 / seconds
Query Executed:select id FROM `nc` where city='Taylorsville' && SIC_code='8062'DB:business_master_new
loadtime:1.9199900627136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teachey' limit 1
loadtime:1.9200661182404 / seconds
Query Executed:select id FROM `nc` where city='Teachey' && SIC_code='8062'DB:business_master_new
loadtime:1.9210889339447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terrell' limit 1
loadtime:1.9211430549622 / seconds
Query Executed:select id FROM `nc` where city='Terrell' && SIC_code='8062'DB:business_master_new
loadtime:1.9223589897156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomasville' limit 1
loadtime:1.9224119186401 / seconds
Query Executed:select id FROM `nc` where city='Thomasville' && SIC_code='8062'DB:business_master_new
loadtime:1.9274370670319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurmond' limit 1
loadtime:1.9275050163269 / seconds
Query Executed:select id FROM `nc` where city='Thurmond' && SIC_code='8062'DB:business_master_new
loadtime:1.9283130168915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillery' limit 1
loadtime:1.9283668994904 / seconds
Query Executed:select id FROM `nc` where city='Tillery' && SIC_code='8062'DB:business_master_new
loadtime:1.9289290904999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberlake' limit 1
loadtime:1.9289810657501 / seconds
Query Executed:select id FROM `nc` where city='Timberlake' && SIC_code='8062'DB:business_master_new
loadtime:1.9310839176178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toast' limit 1
loadtime:1.9311370849609 / seconds
Query Executed:select id FROM `nc` where city='Toast' && SIC_code='8062'DB:business_master_new
loadtime:1.9317829608917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tobaccoville' limit 1
loadtime:1.9318361282349 / seconds
Query Executed:select id FROM `nc` where city='Tobaccoville' && SIC_code='8062'DB:business_master_new
loadtime:1.9331619739532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Todd' limit 1
loadtime:1.9332189559937 / seconds
Query Executed:select id FROM `nc` where city='Todd' && SIC_code='8062'DB:business_master_new
loadtime:1.9342720508575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsail Beach' limit 1
loadtime:1.9343249797821 / seconds
Query Executed:select id FROM `nc` where city='Topsail Beach' && SIC_code='8062'DB:business_master_new
loadtime:1.9350249767303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topton' limit 1
loadtime:1.9350779056549 / seconds
Query Executed:select id FROM `nc` where city='Topton' && SIC_code='8062'DB:business_master_new
loadtime:1.9359109401703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsville' limit 1
loadtime:1.9359641075134 / seconds
Query Executed:select id FROM `nc` where city='Townsville' && SIC_code='8062'DB:business_master_new
loadtime:1.9365530014038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traphill' limit 1
loadtime:1.9366059303284 / seconds
Query Executed:select id FROM `nc` where city='Traphill' && SIC_code='8062'DB:business_master_new
loadtime:1.9376659393311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent Woods' limit 1
loadtime:1.9377191066742 / seconds
Query Executed:select id FROM `nc` where city='Trent Woods' && SIC_code='8062'DB:business_master_new
loadtime:1.9381799697876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:1.9382340908051 / seconds
Query Executed:select id FROM `nc` where city='Trenton' && SIC_code='8062'DB:business_master_new
loadtime:1.9408769607544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinity' limit 1
loadtime:1.9409310817719 / seconds
Query Executed:select id FROM `nc` where city='Trinity' && SIC_code='8062'DB:business_master_new
loadtime:1.9462809562683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutman' limit 1
loadtime:1.9463341236115 / seconds
Query Executed:select id FROM `nc` where city='Troutman' && SIC_code='8062'DB:business_master_new
loadtime:1.9506549835205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.950709104538 / seconds
Query Executed:select id FROM `nc` where city='Troy' && SIC_code='8062'DB:business_master_new
loadtime:1.9558210372925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tryon' limit 1
loadtime:1.9558911323547 / seconds
Query Executed:select id FROM `nc` where city='Tryon' && SIC_code='8062'DB:business_master_new
loadtime:1.9598970413208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckasegee' limit 1
loadtime:1.9599521160126 / seconds
Query Executed:select id FROM `nc` where city='Tuckasegee' && SIC_code='8062'DB:business_master_new
loadtime:1.9607009887695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turkey' limit 1
loadtime:1.9607539176941 / seconds
Query Executed:select id FROM `nc` where city='Turkey' && SIC_code='8062'DB:business_master_new
loadtime:1.9620769023895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turnersburg' limit 1
loadtime:1.9621291160583 / seconds
Query Executed:select id FROM `nc` where city='Turnersburg' && SIC_code='8062'DB:business_master_new
loadtime:1.9626319408417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuxedo' limit 1
loadtime:1.9626839160919 / seconds
Query Executed:select id FROM `nc` where city='Tuxedo' && SIC_code='8062'DB:business_master_new
loadtime:1.963408946991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyner' limit 1
loadtime:1.9634621143341 / seconds
Query Executed:select id FROM `nc` where city='Tyner' && SIC_code='8062'DB:business_master_new
loadtime:1.9647159576416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:1.9647679328918 / seconds
Query Executed:select id FROM `nc` where city='Union Grove' && SIC_code='8062'DB:business_master_new
loadtime:1.9666121006012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Mills' limit 1
loadtime:1.9666640758514 / seconds
Query Executed:select id FROM `nc` where city='Union Mills' && SIC_code='8062'DB:business_master_new
loadtime:1.9677739143372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdese' limit 1
loadtime:1.9678270816803 / seconds
Query Executed:select id FROM `nc` where city='Valdese' && SIC_code='8062'DB:business_master_new
loadtime:1.9730670452118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:1.9731390476227 / seconds
Query Executed:select id FROM `nc` where city='Vale' && SIC_code='8062'DB:business_master_new
loadtime:1.9764750003815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valle Crucis' limit 1
loadtime:1.9765300750732 / seconds
Query Executed:select id FROM `nc` where city='Valle Crucis' && SIC_code='8062'DB:business_master_new
loadtime:1.9773359298706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanceboro' limit 1
loadtime:1.9773900508881 / seconds
Query Executed:select id FROM `nc` where city='Vanceboro' && SIC_code='8062'DB:business_master_new
loadtime:1.9811239242554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandemere' limit 1
loadtime:1.9811820983887 / seconds
Query Executed:select id FROM `nc` where city='Vandemere' && SIC_code='8062'DB:business_master_new
loadtime:1.9817099571228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vass' limit 1
loadtime:1.9817609786987 / seconds
Query Executed:select id FROM `nc` where city='Vass' && SIC_code='8062'DB:business_master_new
loadtime:1.9844210147858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:1.9844748973846 / seconds
Query Executed:select id FROM `nc` where city='Vaughan' && SIC_code='8062'DB:business_master_new
loadtime:1.9849650859833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vilas' limit 1
loadtime:1.9850249290466 / seconds
Query Executed:select id FROM `nc` where city='Vilas' && SIC_code='8062'DB:business_master_new
loadtime:1.9874939918518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waco' limit 1
loadtime:1.9875459671021 / seconds
Query Executed:select id FROM `nc` where city='Waco' && SIC_code='8062'DB:business_master_new
loadtime:1.9881401062012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wade' limit 1
loadtime:1.9881970882416 / seconds
Query Executed:select id FROM `nc` where city='Wade' && SIC_code='8062'DB:business_master_new
loadtime:1.9895069599152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadesboro' limit 1
loadtime:1.9895601272583 / seconds
Query Executed:select id FROM `nc` where city='Wadesboro' && SIC_code='8062'DB:business_master_new
loadtime:1.9947121143341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagram' limit 1
loadtime:1.9947810173035 / seconds
Query Executed:select id FROM `nc` where city='Wagram' && SIC_code='8062'DB:business_master_new
loadtime:1.9960300922394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake Forest' limit 1
loadtime:1.9960849285126 / seconds
Query Executed:select id FROM `nc` where city='Wake Forest' && SIC_code='8062'DB:business_master_new
loadtime:2.0011529922485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkertown' limit 1
loadtime:2.0012230873108 / seconds
Query Executed:select id FROM `nc` where city='Walkertown' && SIC_code='8062'DB:business_master_new
loadtime:2.0062808990479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:2.0063369274139 / seconds
Query Executed:select id FROM `nc` where city='Wallace' && SIC_code='8062'DB:business_master_new
loadtime:2.0113739967346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallburg' limit 1
loadtime:2.0114281177521 / seconds
Query Executed:select id FROM `nc` where city='Wallburg' && SIC_code='8062'DB:business_master_new
loadtime:2.0121541023254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Cove' limit 1
loadtime:2.0122110843658 / seconds
Query Executed:select id FROM `nc` where city='Walnut Cove' && SIC_code='8062'DB:business_master_new
loadtime:2.0172479152679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walstonburg' limit 1
loadtime:2.0173001289368 / seconds
Query Executed:select id FROM `nc` where city='Walstonburg' && SIC_code='8062'DB:business_master_new
loadtime:2.0184869766235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanchese' limit 1
loadtime:2.0185399055481 / seconds
Query Executed:select id FROM `nc` where city='Wanchese' && SIC_code='8062'DB:business_master_new
loadtime:2.020369052887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warne' limit 1
loadtime:2.0204219818115 / seconds
Query Executed:select id FROM `nc` where city='Warne' && SIC_code='8062'DB:business_master_new
loadtime:2.021106004715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrensville' limit 1
loadtime:2.0211579799652 / seconds
Query Executed:select id FROM `nc` where city='Warrensville' && SIC_code='8062'DB:business_master_new
loadtime:2.0222549438477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:2.0223081111908 / seconds
Query Executed:select id FROM `nc` where city='Warrenton' && SIC_code='8062'DB:business_master_new
loadtime:2.0273439884186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:2.0273969173431 / seconds
Query Executed:select id FROM `nc` where city='Warsaw' && SIC_code='8062'DB:business_master_new
loadtime:2.0324490070343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.0325019359589 / seconds
Query Executed:select id FROM `nc` where city='Washington' && SIC_code='8062'DB:business_master_new
loadtime:2.0375399589539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watha' limit 1
loadtime:2.0376069545746 / seconds
Query Executed:select id FROM `nc` where city='Watha' && SIC_code='8062'DB:business_master_new
loadtime:2.038015127182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waves' limit 1
loadtime:2.0380680561066 / seconds
Query Executed:select id FROM `nc` where city='Waves' && SIC_code='8062'DB:business_master_new
loadtime:2.0387110710144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waxhaw' limit 1
loadtime:2.0387630462646 / seconds
Query Executed:select id FROM `nc` where city='Waxhaw' && SIC_code='8062'DB:business_master_new
loadtime:2.0437910556793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesville' limit 1
loadtime:2.0438439846039 / seconds
Query Executed:select id FROM `nc` where city='Waynesville' && SIC_code='8062'DB:business_master_new
loadtime:2.0488810539246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weaverville' limit 1
loadtime:2.0489339828491 / seconds
Query Executed:select id FROM `nc` where city='Weaverville' && SIC_code='8062'DB:business_master_new
loadtime:2.0540609359741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.0541141033173 / seconds
Query Executed:select id FROM `nc` where city='Webster' && SIC_code='8062'DB:business_master_new
loadtime:2.0547540187836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weddington' limit 1
loadtime:2.0548059940338 / seconds
Query Executed:select id FROM `nc` where city='Weddington' && SIC_code='8062'DB:business_master_new
loadtime:2.055330991745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welcome' limit 1
loadtime:2.0553839206696 / seconds
Query Executed:select id FROM `nc` where city='Welcome' && SIC_code='8062'DB:business_master_new
loadtime:2.0576529502869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:2.05770611763 / seconds
Query Executed:select id FROM `nc` where city='Weldon' && SIC_code='8062'DB:business_master_new
loadtime:2.0603239536285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:2.0603771209717 / seconds
Query Executed:select id FROM `nc` where city='Wendell' && SIC_code='8062'DB:business_master_new
loadtime:2.065395116806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:2.0654480457306 / seconds
Query Executed:select id FROM `nc` where city='Wentworth' && SIC_code='8062'DB:business_master_new
loadtime:2.0668439865112 / seconds
Query loaded from cache:select * from geodata_geocity where city='West End' limit 1
loadtime:2.0669090747833 / seconds
Query Executed:select id FROM `nc` where city='West End' && SIC_code='8062'DB:business_master_new
loadtime:2.0707869529724 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jefferson' limit 1
loadtime:2.0708410739899 / seconds
Query Executed:select id FROM `nc` where city='West Jefferson' && SIC_code='8062'DB:business_master_new
loadtime:2.0758919715881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.0759449005127 / seconds
Query Executed:select id FROM `nc` where city='Westfield' && SIC_code='8062'DB:business_master_new
loadtime:2.0775370597839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whispering Pines' limit 1
loadtime:2.0775899887085 / seconds
Query Executed:select id FROM `nc` where city='Whispering Pines' && SIC_code='8062'DB:business_master_new
loadtime:2.0780470371246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitakers' limit 1
loadtime:2.0780990123749 / seconds
Query Executed:select id FROM `nc` where city='Whitakers' && SIC_code='8062'DB:business_master_new
loadtime:2.0804460048676 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Oak' limit 1
loadtime:2.0804979801178 / seconds
Query Executed:select id FROM `nc` where city='White Oak' && SIC_code='8062'DB:business_master_new
loadtime:2.0816309452057 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:2.0816850662231 / seconds
Query Executed:select id FROM `nc` where city='White Plains' && SIC_code='8062'DB:business_master_new
loadtime:2.0822110176086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteville' limit 1
loadtime:2.0822629928589 / seconds
Query Executed:select id FROM `nc` where city='Whiteville' && SIC_code='8062'DB:business_master_new
loadtime:2.0872790813446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitsett' limit 1
loadtime:2.087347984314 / seconds
Query Executed:select id FROM `nc` where city='Whitsett' && SIC_code='8062'DB:business_master_new
loadtime:2.0896339416504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittier' limit 1
loadtime:2.0896880626678 / seconds
Query Executed:select id FROM `nc` where city='Whittier' && SIC_code='8062'DB:business_master_new
loadtime:2.09193110466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbar' limit 1
loadtime:2.0919830799103 / seconds
Query Executed:select id FROM `nc` where city='Wilbar' && SIC_code='8062'DB:business_master_new
loadtime:2.0924088954926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkesboro' limit 1
loadtime:2.0924620628357 / seconds
Query Executed:select id FROM `nc` where city='Wilkesboro' && SIC_code='8062'DB:business_master_new
loadtime:2.0974979400635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:2.0975499153137 / seconds
Query Executed:select id FROM `nc` where city='Willard' && SIC_code='8062'DB:business_master_new
loadtime:2.0994589328766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:2.0995121002197 / seconds
Query Executed:select id FROM `nc` where city='Williamston' && SIC_code='8062'DB:business_master_new
loadtime:2.1045711040497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:2.104640007019 / seconds
Query Executed:select id FROM `nc` where city='Williston' && SIC_code='8062'DB:business_master_new
loadtime:2.1052000522614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Spring' limit 1
loadtime:2.1052551269531 / seconds
Query Executed:select id FROM `nc` where city='Willow Spring' && SIC_code='8062'DB:business_master_new
loadtime:2.1090180873871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:2.1090710163116 / seconds
Query Executed:select id FROM `nc` where city='Wilmington' && SIC_code='8062'DB:business_master_new
loadtime:2.1140809059143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:2.1141629219055 / seconds
Query Executed:select id FROM `nc` where city='Wilson' && SIC_code='8062'DB:business_master_new
loadtime:2.1191740036011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons Mills' limit 1
loadtime:2.1192450523376 / seconds
Query Executed:select id FROM `nc` where city='Wilsons Mills' && SIC_code='8062'DB:business_master_new
loadtime:2.1198899745941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.1199440956116 / seconds
Query Executed:select id FROM `nc` where city='Windsor' && SIC_code='8062'DB:business_master_new
loadtime:2.1249530315399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfall' limit 1
loadtime:2.1250290870667 / seconds
Query Executed:select id FROM `nc` where city='Winfall' && SIC_code='8062'DB:business_master_new
loadtime:2.1257090568542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingate' limit 1
loadtime:2.125776052475 / seconds
Query Executed:select id FROM `nc` where city='Wingate' && SIC_code='8062'DB:business_master_new
loadtime:2.1282811164856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnabow' limit 1
loadtime:2.1283431053162 / seconds
Query Executed:select id FROM `nc` where city='Winnabow' && SIC_code='8062'DB:business_master_new
loadtime:2.1297609806061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston Salem' limit 1
loadtime:2.1298139095306 / seconds
Query Executed:select id FROM `nc` where city='Winston Salem' && SIC_code='8062'DB:business_master_new
loadtime:2.1348750591278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:2.1349589824677 / seconds
Query Executed:select id FROM `nc` where city='Winterville' && SIC_code='8062'DB:business_master_new
loadtime:2.139997959137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winton' limit 1
loadtime:2.1400609016418 / seconds
Query Executed:select id FROM `nc` where city='Winton' && SIC_code='8062'DB:business_master_new
loadtime:2.1418828964233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:2.1419351100922 / seconds
Query Executed:select id FROM `nc` where city='Wise' && SIC_code='8062'DB:business_master_new
loadtime:2.1424190998077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:2.142471075058 / seconds
Query Executed:select id FROM `nc` where city='Woodland' && SIC_code='8062'DB:business_master_new
loadtime:2.1434829235077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodleaf' limit 1
loadtime:2.1435348987579 / seconds
Query Executed:select id FROM `nc` where city='Woodleaf' && SIC_code='8062'DB:business_master_new
loadtime:2.1448409557343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Bch' limit 1
loadtime:2.1448929309845 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Bch' && SIC_code='8062'DB:business_master_new
loadtime:2.145455121994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Beach' limit 1
loadtime:2.1455080509186 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Beach' && SIC_code='8062'DB:business_master_new
loadtime:2.1495718955994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yadkinville' limit 1
loadtime:2.1496250629425 / seconds
Query Executed:select id FROM `nc` where city='Yadkinville' && SIC_code='8062'DB:business_master_new
loadtime:2.1547079086304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yanceyville' limit 1
loadtime:2.154776096344 / seconds
Query Executed:select id FROM `nc` where city='Yanceyville' && SIC_code='8062'DB:business_master_new
loadtime:2.1586630344391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:2.1587300300598 / seconds
Query Executed:select id FROM `nc` where city='Youngsville' && SIC_code='8062'DB:business_master_new
loadtime:2.1637899875641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zebulon' limit 1
loadtime:2.1638441085815 / seconds
Query Executed:select id FROM `nc` where city='Zebulon' && SIC_code='8062'DB:business_master_new
loadtime:2.1688780784607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zionville' limit 1
loadtime:2.1689460277557 / seconds
Query Executed:select id FROM `nc` where city='Zionville' && SIC_code='8062'DB:business_master_new
loadtime:2.1700599193573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zirconia' limit 1
loadtime:2.1701149940491 / seconds
Query Executed:select id FROM `nc` where city='Zirconia' && SIC_code='8062'DB:business_master_new
loadtime:2.1713130474091 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.1714580059052 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.171952009201 / seconds
Operation template executed (chunk cache operation)
loadtime:2.1721279621124 / seconds
template override:Default
loadtime:2.1721711158752 / 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:2.1739590167999 / seconds
Template Constructed, Array Rows:49
loadtime:2.1744909286499 / seconds
TOTAL EXECUTION TIME: 2.17405
loadtime:2.1762881278992 / 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] => general-medical-and-surgical-hospitals [stateURLid] => north-carolina )


_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:2.1762979030609
TOTAL KEY ARRAYS: 69