Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.2983245849609E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001878023147583 / seconds
host not found setting manual db connection
loadtime:0.010560989379883 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010899066925049 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.011173963546753 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.011264085769653 / seconds
zipcode:
loadtime:0.011307001113892 / seconds
Query Executed:select * from search_referrer where page_hash='76c69451dc9785273527f0407f9707a9' limit 10 DB:ezrox_toadli
loadtime:0.011699914932251 / seconds
Operation header executed (non global)
loadtime:0.011740922927856 / seconds
Operation leaderboard executed (non global)
loadtime:0.011806964874268 / seconds
Operation square executed (non global)
loadtime:0.011850118637085 / seconds
Operation square_bottom executed (non global)
loadtime:0.011888980865479 / seconds
Operation smallsquare executed (non global)
loadtime:0.011927127838135 / seconds
Operation headeradright executed (non global)
loadtime:0.011961936950684 / seconds
Operation google_analytics executed (non global)
loadtime:0.011996984481812 / seconds
Operation topstories executed (non global)
loadtime:0.012032032012939 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0120689868927 / seconds
Operation memberbuscount executed (non global)
loadtime:0.012104034423828 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.012444972991943 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.012696981430054 / seconds
Operation categories executed (global stored into APC)
loadtime:0.012743949890137 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.012815952301025 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.012876033782959 / seconds
Template key: archive_menu pushed
loadtime:0.012886047363281 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.012900114059448 / seconds
Template key: get_gravatar pushed
loadtime:0.012907028198242 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.012916088104248 / seconds
*10)-10)+1 | start:0
loadtime:0.01295804977417 / seconds
DB connected to localhost business_master_new
loadtime:0.013227939605713 / seconds
Query Executed:select * from categories where cat_URLid='laundry-and-garment-services-nec'DB:business_master_new
loadtime:0.014341115951538 / seconds
Query stored in cache : _QUERY_www.toadli.com37ffabd5182986d214904f494594cd40
loadtime:0.014401912689209 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.014442920684814 / seconds
Query Executed:select * from `nc_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.039550065994263 / seconds
Query stored in cache : _QUERY_www.toadli.comb9e9fcc43730517cb199ce6035ee7f04
loadtime:0.042886972427368 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.042958974838257 / seconds
Query Executed:select sum(totalcount) as totalsum from `nc_catmap` where sic='7219'DB:business_master_new
loadtime:0.047177076339722 / seconds
Query stored in cache : _QUERY_www.toadli.com711eb10bea8d75dae0b459edfc6e699b
loadtime:0.047218084335327 / seconds
820 / 11
loadtime:0.047282934188843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.047359943389893 / seconds
Query Executed:select id FROM `nc` where city='Aberdeen' && SIC_code='7219'DB:business_master_new
loadtime:0.050493955612183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Advance' limit 1
loadtime:0.050571918487549 / seconds
Query Executed:select id FROM `nc` where city='Advance' && SIC_code='7219'DB:business_master_new
loadtime:0.053473949432373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahoskie' limit 1
loadtime:0.053529024124146 / seconds
Query Executed:select id FROM `nc` where city='Ahoskie' && SIC_code='7219'DB:business_master_new
loadtime:0.056462049484253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamance' limit 1
loadtime:0.056519985198975 / seconds
Query Executed:select id FROM `nc` where city='Alamance' && SIC_code='7219'DB:business_master_new
loadtime:0.057399988174438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albemarle' limit 1
loadtime:0.057459115982056 / seconds
Query Executed:select id FROM `nc` where city='Albemarle' && SIC_code='7219'DB:business_master_new
loadtime:0.060367107391357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albertson' limit 1
loadtime:0.06044602394104 / seconds
Query Executed:select id FROM `nc` where city='Albertson' && SIC_code='7219'DB:business_master_new
loadtime:0.061413049697876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.061475992202759 / seconds
Query Executed:select id FROM `nc` where city='Alexander' && SIC_code='7219'DB:business_master_new
loadtime:0.06272292137146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexis' limit 1
loadtime:0.062785148620605 / seconds
Query Executed:select id FROM `nc` where city='Alexis' && SIC_code='7219'DB:business_master_new
loadtime:0.063678979873657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alliance' limit 1
loadtime:0.063733100891113 / seconds
Query Executed:select id FROM `nc` where city='Alliance' && SIC_code='7219'DB:business_master_new
loadtime:0.064429998397827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almond' limit 1
loadtime:0.064487934112549 / seconds
Query Executed:select id FROM `nc` where city='Almond' && SIC_code='7219'DB:business_master_new
loadtime:0.065092086791992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamahaw' limit 1
loadtime:0.065154075622559 / seconds
Query Executed:select id FROM `nc` where city='Altamahaw' && SIC_code='7219'DB:business_master_new
loadtime:0.065710067749023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.065768003463745 / seconds
Query Executed:select id FROM `nc` where city='Andrews' && SIC_code='7219'DB:business_master_new
loadtime:0.068670034408569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angier' limit 1
loadtime:0.068727970123291 / seconds
Query Executed:select id FROM `nc` where city='Angier' && SIC_code='7219'DB:business_master_new
loadtime:0.071593999862671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonville' limit 1
loadtime:0.07166314125061 / seconds
Query Executed:select id FROM `nc` where city='Ansonville' && SIC_code='7219'DB:business_master_new
loadtime:0.074643135070801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apex' limit 1
loadtime:0.074712991714478 / seconds
Query Executed:select id FROM `nc` where city='Apex' && SIC_code='7219'DB:business_master_new
loadtime:0.077777147293091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.077852964401245 / seconds
Query Executed:select id FROM `nc` where city='Arapahoe' && SIC_code='7219'DB:business_master_new
loadtime:0.078794002532959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.078850984573364 / seconds
Query Executed:select id FROM `nc` where city='Ararat' && SIC_code='7219'DB:business_master_new
loadtime:0.080140113830566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archdale' limit 1
loadtime:0.080198049545288 / seconds
Query Executed:select id FROM `nc` where city='Archdale' && SIC_code='7219'DB:business_master_new
loadtime:0.080677032470703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arden' limit 1
loadtime:0.080739974975586 / seconds
Query Executed:select id FROM `nc` where city='Arden' && SIC_code='7219'DB:business_master_new
loadtime:0.08362603187561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash' limit 1
loadtime:0.083709955215454 / seconds
Query Executed:select id FROM `nc` where city='Ash' && SIC_code='7219'DB:business_master_new
loadtime:0.086591958999634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheboro' limit 1
loadtime:0.086651086807251 / seconds
Query Executed:select id FROM `nc` where city='Asheboro' && SIC_code='7219'DB:business_master_new
loadtime:0.08955192565918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheville' limit 1
loadtime:0.089622974395752 / seconds
Query Executed:select id FROM `nc` where city='Asheville' && SIC_code='7219'DB:business_master_new
loadtime:0.092522144317627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.092606067657471 / seconds
Query Executed:select id FROM `nc` where city='Atkinson' && SIC_code='7219'DB:business_master_new
loadtime:0.09550404548645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.095566034317017 / seconds
Query Executed:select id FROM `nc` where city='Atlantic' && SIC_code='7219'DB:business_master_new
loadtime:0.096418142318726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.096476078033447 / seconds
Query Executed:select id FROM `nc` where city='Atlantic Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.099369049072266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aulander' limit 1
loadtime:0.099426031112671 / seconds
Query Executed:select id FROM `nc` where city='Aulander' && SIC_code='7219'DB:business_master_new
loadtime:0.10232210159302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.10239601135254 / seconds
Query Executed:select id FROM `nc` where city='Aurora' && SIC_code='7219'DB:business_master_new
loadtime:0.10528206825256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Autryville' limit 1
loadtime:0.10534906387329 / seconds
Query Executed:select id FROM `nc` where city='Autryville' && SIC_code='7219'DB:business_master_new
loadtime:0.10824799537659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.10832095146179 / seconds
Query Executed:select id FROM `nc` where city='Avon' && SIC_code='7219'DB:business_master_new
loadtime:0.11122798919678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayden' limit 1
loadtime:0.11128807067871 / seconds
Query Executed:select id FROM `nc` where city='Ayden' && SIC_code='7219'DB:business_master_new
loadtime:0.1141939163208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aydlett' limit 1
loadtime:0.11425113677979 / seconds
Query Executed:select id FROM `nc` where city='Aydlett' && SIC_code='7219'DB:business_master_new
loadtime:0.11483192443848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badin' limit 1
loadtime:0.11488604545593 / seconds
Query Executed:select id FROM `nc` where city='Badin' && SIC_code='7219'DB:business_master_new
loadtime:0.11598706245422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bahama' limit 1
loadtime:0.11604595184326 / seconds
Query Executed:select id FROM `nc` where city='Bahama' && SIC_code='7219'DB:business_master_new
loadtime:0.11895895004272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.11901903152466 / seconds
Query Executed:select id FROM `nc` where city='Bailey' && SIC_code='7219'DB:business_master_new
loadtime:0.12191891670227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersville' limit 1
loadtime:0.1219789981842 / seconds
Query Executed:select id FROM `nc` where city='Bakersville' && SIC_code='7219'DB:business_master_new
loadtime:0.12487292289734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bald Head Island' limit 1
loadtime:0.12493014335632 / seconds
Query Executed:select id FROM `nc` where city='Bald Head Island' && SIC_code='7219'DB:business_master_new
loadtime:0.12531208992004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam' limit 1
loadtime:0.12537407875061 / seconds
Query Executed:select id FROM `nc` where city='Balsam' && SIC_code='7219'DB:business_master_new
loadtime:0.12599492073059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam Grove' limit 1
loadtime:0.12605214118958 / seconds
Query Executed:select id FROM `nc` where city='Balsam Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.12667608261108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banner Elk' limit 1
loadtime:0.12672901153564 / seconds
Query Executed:select id FROM `nc` where city='Banner Elk' && SIC_code='7219'DB:business_master_new
loadtime:0.12961792945862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barco' limit 1
loadtime:0.12968301773071 / seconds
Query Executed:select id FROM `nc` where city='Barco' && SIC_code='7219'DB:business_master_new
loadtime:0.13057494163513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barium Springs' limit 1
loadtime:0.13063406944275 / seconds
Query Executed:select id FROM `nc` where city='Barium Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.13124799728394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnardsville' limit 1
loadtime:0.13130593299866 / seconds
Query Executed:select id FROM `nc` where city='Barnardsville' && SIC_code='7219'DB:business_master_new
loadtime:0.1341860294342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnesville' limit 1
loadtime:0.13424301147461 / seconds
Query Executed:select id FROM `nc` where city='Barnesville' && SIC_code='7219'DB:business_master_new
loadtime:0.13464713096619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bat Cave' limit 1
loadtime:0.13471102714539 / seconds
Query Executed:select id FROM `nc` where city='Bat Cave' && SIC_code='7219'DB:business_master_new
loadtime:0.13541793823242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.13547396659851 / seconds
Query Executed:select id FROM `nc` where city='Bath' && SIC_code='7219'DB:business_master_new
loadtime:0.13835310935974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battleboro' limit 1
loadtime:0.13841104507446 / seconds
Query Executed:select id FROM `nc` where city='Battleboro' && SIC_code='7219'DB:business_master_new
loadtime:0.14131593704224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayboro' limit 1
loadtime:0.14137601852417 / seconds
Query Executed:select id FROM `nc` where city='Bayboro' && SIC_code='7219'DB:business_master_new
loadtime:0.14428496360779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.14434695243835 / seconds
Query Executed:select id FROM `nc` where city='Bear Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.14725112915039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.1473069190979 / seconds
Query Executed:select id FROM `nc` where city='Beaufort' && SIC_code='7219'DB:business_master_new
loadtime:0.15019798278809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Mountain' limit 1
loadtime:0.15025997161865 / seconds
Query Executed:select id FROM `nc` where city='Beech Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.15064692497253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belews Creek' limit 1
loadtime:0.15070700645447 / seconds
Query Executed:select id FROM `nc` where city='Belews Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.15359401702881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belhaven' limit 1
loadtime:0.15366101264954 / seconds
Query Executed:select id FROM `nc` where city='Belhaven' && SIC_code='7219'DB:business_master_new
loadtime:0.15655994415283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellarthur' limit 1
loadtime:0.15661692619324 / seconds
Query Executed:select id FROM `nc` where city='Bellarthur' && SIC_code='7219'DB:business_master_new
loadtime:0.15716099739075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.15721297264099 / seconds
Query Executed:select id FROM `nc` where city='Belmont' && SIC_code='7219'DB:business_master_new
loadtime:0.1601550579071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.16021394729614 / seconds
Query Executed:select id FROM `nc` where city='Belvidere' && SIC_code='7219'DB:business_master_new
loadtime:0.16116714477539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.16122603416443 / seconds
Query Executed:select id FROM `nc` where city='Bennett' && SIC_code='7219'DB:business_master_new
loadtime:0.16416001319885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.16421294212341 / seconds
Query Executed:select id FROM `nc` where city='Benson' && SIC_code='7219'DB:business_master_new
loadtime:0.16711711883545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer City' limit 1
loadtime:0.16717791557312 / seconds
Query Executed:select id FROM `nc` where city='Bessemer City' && SIC_code='7219'DB:business_master_new
loadtime:0.170086145401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethania' limit 1
loadtime:0.17014408111572 / seconds
Query Executed:select id FROM `nc` where city='Bethania' && SIC_code='7219'DB:business_master_new
loadtime:0.17093896865845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.17099213600159 / seconds
Query Executed:select id FROM `nc` where city='Bethel' && SIC_code='7219'DB:business_master_new
loadtime:0.17386507987976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulaville' limit 1
loadtime:0.17392206192017 / seconds
Query Executed:select id FROM `nc` where city='Beulaville' && SIC_code='7219'DB:business_master_new
loadtime:0.17681813240051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biltmore Lake' limit 1
loadtime:0.17689514160156 / seconds
Query Executed:select id FROM `nc` where city='Biltmore Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.17730593681335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biscoe' limit 1
loadtime:0.17736291885376 / seconds
Query Executed:select id FROM `nc` where city='Biscoe' && SIC_code='7219'DB:business_master_new
loadtime:0.18025493621826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Creek' limit 1
loadtime:0.18031907081604 / seconds
Query Executed:select id FROM `nc` where city='Black Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.18109512329102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Mountain' limit 1
loadtime:0.18114805221558 / seconds
Query Executed:select id FROM `nc` where city='Black Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.18402099609375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bladenboro' limit 1
loadtime:0.18410110473633 / seconds
Query Executed:select id FROM `nc` where city='Bladenboro' && SIC_code='7219'DB:business_master_new
loadtime:0.1869649887085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanch' limit 1
loadtime:0.18702602386475 / seconds
Query Executed:select id FROM `nc` where city='Blanch' && SIC_code='7219'DB:business_master_new
loadtime:0.18792700767517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blounts Creek' limit 1
loadtime:0.18798613548279 / seconds
Query Executed:select id FROM `nc` where city='Blounts Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.18891406059265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blowing Rock' limit 1
loadtime:0.18897294998169 / seconds
Query Executed:select id FROM `nc` where city='Blowing Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.19187498092651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boger City' limit 1
loadtime:0.1919469833374 / seconds
Query Executed:select id FROM `nc` where city='Boger City' && SIC_code='7219'DB:business_master_new
loadtime:0.19233894348145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.19239497184753 / seconds
Query Executed:select id FROM `nc` where city='Boiling Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.19529008865356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolivia' limit 1
loadtime:0.1953489780426 / seconds
Query Executed:select id FROM `nc` where city='Bolivia' && SIC_code='7219'DB:business_master_new
loadtime:0.19823694229126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.19829392433167 / seconds
Query Executed:select id FROM `nc` where city='Bolton' && SIC_code='7219'DB:business_master_new
loadtime:0.1997389793396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonlee' limit 1
loadtime:0.19979095458984 / seconds
Query Executed:select id FROM `nc` where city='Bonlee' && SIC_code='7219'DB:business_master_new
loadtime:0.20048093795776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boomer' limit 1
loadtime:0.20054006576538 / seconds
Query Executed:select id FROM `nc` where city='Boomer' && SIC_code='7219'DB:business_master_new
loadtime:0.20166802406311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.20172500610352 / seconds
Query Executed:select id FROM `nc` where city='Boone' && SIC_code='7219'DB:business_master_new
loadtime:0.20459604263306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boonville' limit 1
loadtime:0.20467901229858 / seconds
Query Executed:select id FROM `nc` where city='Boonville' && SIC_code='7219'DB:business_master_new
loadtime:0.20755100250244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bostic' limit 1
loadtime:0.20761704444885 / seconds
Query Executed:select id FROM `nc` where city='Bostic' && SIC_code='7219'DB:business_master_new
loadtime:0.21048808097839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdens' limit 1
loadtime:0.2105450630188 / seconds
Query Executed:select id FROM `nc` where city='Bowdens' && SIC_code='7219'DB:business_master_new
loadtime:0.21094298362732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brasstown' limit 1
loadtime:0.21099495887756 / seconds
Query Executed:select id FROM `nc` where city='Brasstown' && SIC_code='7219'DB:business_master_new
loadtime:0.21205711364746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brevard' limit 1
loadtime:0.21211314201355 / seconds
Query Executed:select id FROM `nc` where city='Brevard' && SIC_code='7219'DB:business_master_new
loadtime:0.21500110626221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeton' limit 1
loadtime:0.21507000923157 / seconds
Query Executed:select id FROM `nc` where city='Bridgeton' && SIC_code='7219'DB:business_master_new
loadtime:0.21793699264526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.21798992156982 / seconds
Query Executed:select id FROM `nc` where city='Broadway' && SIC_code='7219'DB:business_master_new
loadtime:0.22087693214417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browns Summit' limit 1
loadtime:0.22093796730042 / seconds
Query Executed:select id FROM `nc` where city='Browns Summit' && SIC_code='7219'DB:business_master_new
loadtime:0.22383499145508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunswick' limit 1
loadtime:0.22388792037964 / seconds
Query Executed:select id FROM `nc` where city='Brunswick' && SIC_code='7219'DB:business_master_new
loadtime:0.22443699836731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryson City' limit 1
loadtime:0.2244930267334 / seconds
Query Executed:select id FROM `nc` where city='Bryson City' && SIC_code='7219'DB:business_master_new
loadtime:0.22737312316895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buies Creek' limit 1
loadtime:0.22743010520935 / seconds
Query Executed:select id FROM `nc` where city='Buies Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.22858905792236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullock' limit 1
loadtime:0.22865009307861 / seconds
Query Executed:select id FROM `nc` where city='Bullock' && SIC_code='7219'DB:business_master_new
loadtime:0.2295229434967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunn' limit 1
loadtime:0.22957491874695 / seconds
Query Executed:select id FROM `nc` where city='Bunn' && SIC_code='7219'DB:business_master_new
loadtime:0.23246192932129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunnlevel' limit 1
loadtime:0.23252010345459 / seconds
Query Executed:select id FROM `nc` where city='Bunnlevel' && SIC_code='7219'DB:business_master_new
loadtime:0.23383212089539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgaw' limit 1
loadtime:0.23388409614563 / seconds
Query Executed:select id FROM `nc` where city='Burgaw' && SIC_code='7219'DB:business_master_new
loadtime:0.23678112030029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.23684692382812 / seconds
Query Executed:select id FROM `nc` where city='Burlington' && SIC_code='7219'DB:business_master_new
loadtime:0.23976111412048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.23984599113464 / seconds
Query Executed:select id FROM `nc` where city='Burnsville' && SIC_code='7219'DB:business_master_new
loadtime:0.24273705482483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butner' limit 1
loadtime:0.24279808998108 / seconds
Query Executed:select id FROM `nc` where city='Butner' && SIC_code='7219'DB:business_master_new
loadtime:0.24568796157837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butters' limit 1
loadtime:0.24574398994446 / seconds
Query Executed:select id FROM `nc` where city='Butters' && SIC_code='7219'DB:business_master_new
loadtime:0.24614810943604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buxton' limit 1
loadtime:0.24620914459229 / seconds
Query Executed:select id FROM `nc` where city='Buxton' && SIC_code='7219'DB:business_master_new
loadtime:0.2491021156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bynum' limit 1
loadtime:0.24916195869446 / seconds
Query Executed:select id FROM `nc` where city='Bynum' && SIC_code='7219'DB:business_master_new
loadtime:0.24958992004395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calabash' limit 1
loadtime:0.24964714050293 / seconds
Query Executed:select id FROM `nc` where city='Calabash' && SIC_code='7219'DB:business_master_new
loadtime:0.25255298614502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calypso' limit 1
loadtime:0.25261497497559 / seconds
Query Executed:select id FROM `nc` where city='Calypso' && SIC_code='7219'DB:business_master_new
loadtime:0.25345492362976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.25351595878601 / seconds
Query Executed:select id FROM `nc` where city='Camden' && SIC_code='7219'DB:business_master_new
loadtime:0.25639510154724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.25644707679749 / seconds
Query Executed:select id FROM `nc` where city='Cameron' && SIC_code='7219'DB:business_master_new
loadtime:0.25934600830078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Lejeune' limit 1
loadtime:0.25940704345703 / seconds
Query Executed:select id FROM `nc` where city='Camp Lejeune' && SIC_code='7219'DB:business_master_new
loadtime:0.26099300384521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candler' limit 1
loadtime:0.26105809211731 / seconds
Query Executed:select id FROM `nc` where city='Candler' && SIC_code='7219'DB:business_master_new
loadtime:0.26395893096924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candor' limit 1
loadtime:0.26401591300964 / seconds
Query Executed:select id FROM `nc` where city='Candor' && SIC_code='7219'DB:business_master_new
loadtime:0.26626992225647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.26632308959961 / seconds
Query Executed:select id FROM `nc` where city='Canton' && SIC_code='7219'DB:business_master_new
loadtime:0.26922798156738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Carteret' limit 1
loadtime:0.26930594444275 / seconds
Query Executed:select id FROM `nc` where city='Cape Carteret' && SIC_code='7219'DB:business_master_new
loadtime:0.26982498168945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caroleen' limit 1
loadtime:0.26988697052002 / seconds
Query Executed:select id FROM `nc` where city='Caroleen' && SIC_code='7219'DB:business_master_new
loadtime:0.27053809165955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Beach' limit 1
loadtime:0.2705979347229 / seconds
Query Executed:select id FROM `nc` where city='Carolina Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.27351999282837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Shores' limit 1
loadtime:0.27357411384583 / seconds
Query Executed:select id FROM `nc` where city='Carolina Shores' && SIC_code='7219'DB:business_master_new
loadtime:0.27403807640076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrboro' limit 1
loadtime:0.27409911155701 / seconds
Query Executed:select id FROM `nc` where city='Carrboro' && SIC_code='7219'DB:business_master_new
loadtime:0.27700114250183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.27707314491272 / seconds
Query Executed:select id FROM `nc` where city='Carthage' && SIC_code='7219'DB:business_master_new
loadtime:0.27997899055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:0.28003907203674 / seconds
Query Executed:select id FROM `nc` where city='Cary' && SIC_code='7219'DB:business_master_new
loadtime:0.28296494483948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casar' limit 1
loadtime:0.28304696083069 / seconds
Query Executed:select id FROM `nc` where city='Casar' && SIC_code='7219'DB:business_master_new
loadtime:0.28436803817749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashiers' limit 1
loadtime:0.28442192077637 / seconds
Query Executed:select id FROM `nc` where city='Cashiers' && SIC_code='7219'DB:business_master_new
loadtime:0.28732204437256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:0.2873740196228 / seconds
Query Executed:select id FROM `nc` where city='Castalia' && SIC_code='7219'DB:business_master_new
loadtime:0.28883600234985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Hayne' limit 1
loadtime:0.28890109062195 / seconds
Query Executed:select id FROM `nc` where city='Castle Hayne' && SIC_code='7219'DB:business_master_new
loadtime:0.29182195663452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.29189705848694 / seconds
Query Executed:select id FROM `nc` where city='Catawba' && SIC_code='7219'DB:business_master_new
loadtime:0.29479908943176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:0.29486107826233 / seconds
Query Executed:select id FROM `nc` where city='Cedar Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.2953360080719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:0.29539203643799 / seconds
Query Executed:select id FROM `nc` where city='Cedar Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.29654598236084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Island' limit 1
loadtime:0.29660391807556 / seconds
Query Executed:select id FROM `nc` where city='Cedar Island' && SIC_code='7219'DB:business_master_new
loadtime:0.29732203483582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Mountain' limit 1
loadtime:0.29737496376038 / seconds
Query Executed:select id FROM `nc` where city='Cedar Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.29854798316956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Point' limit 1
loadtime:0.29860711097717 / seconds
Query Executed:select id FROM `nc` where city='Cedar Point' && SIC_code='7219'DB:business_master_new
loadtime:0.2990620136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro Gordo' limit 1
loadtime:0.29912114143372 / seconds
Query Executed:select id FROM `nc` where city='Cerro Gordo' && SIC_code='7219'DB:business_master_new
loadtime:0.30036306381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chadbourn' limit 1
loadtime:0.30042099952698 / seconds
Query Executed:select id FROM `nc` where city='Chadbourn' && SIC_code='7219'DB:business_master_new
loadtime:0.30335307121277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapel Hill' limit 1
loadtime:0.30340600013733 / seconds
Query Executed:select id FROM `nc` where city='Chapel Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.30633401870728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.30640506744385 / seconds
Query Executed:select id FROM `nc` where city='Charlotte' && SIC_code='7219'DB:business_master_new
loadtime:0.30933809280396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.3094470500946 / seconds
Query Executed:select id FROM `nc` where city='Cherokee' && SIC_code='7219'DB:business_master_new
loadtime:0.31233501434326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Point' limit 1
loadtime:0.31239795684814 / seconds
Query Executed:select id FROM `nc` where city='Cherry Point' && SIC_code='7219'DB:business_master_new
loadtime:0.31339812278748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherryville' limit 1
loadtime:0.31345105171204 / seconds
Query Executed:select id FROM `nc` where city='Cherryville' && SIC_code='7219'DB:business_master_new
loadtime:0.31635594367981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimney Rock' limit 1
loadtime:0.31642603874207 / seconds
Query Executed:select id FROM `nc` where city='Chimney Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.31741714477539 / seconds
Query loaded from cache:select * from geodata_geocity where city='China Grove' limit 1
loadtime:0.31747508049011 / seconds
Query Executed:select id FROM `nc` where city='China Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.32035207748413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinquapin' limit 1
loadtime:0.32040905952454 / seconds
Query Executed:select id FROM `nc` where city='Chinquapin' && SIC_code='7219'DB:business_master_new
loadtime:0.32168412208557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocowinity' limit 1
loadtime:0.32173609733582 / seconds
Query Executed:select id FROM `nc` where city='Chocowinity' && SIC_code='7219'DB:business_master_new
loadtime:0.32463598251343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.32470107078552 / seconds
Query Executed:select id FROM `nc` where city='Claremont' && SIC_code='7219'DB:business_master_new
loadtime:0.3275990486145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarendon' limit 1
loadtime:0.32766914367676 / seconds
Query Executed:select id FROM `nc` where city='Clarendon' && SIC_code='7219'DB:business_master_new
loadtime:0.32866907119751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkton' limit 1
loadtime:0.32872605323792 / seconds
Query Executed:select id FROM `nc` where city='Clarkton' && SIC_code='7219'DB:business_master_new
loadtime:0.3316011428833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.33166813850403 / seconds
Query Executed:select id FROM `nc` where city='Clayton' && SIC_code='7219'DB:business_master_new
loadtime:0.334547996521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemmons' limit 1
loadtime:0.33460593223572 / seconds
Query Executed:select id FROM `nc` where city='Clemmons' && SIC_code='7219'DB:business_master_new
loadtime:0.3374810218811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.33754897117615 / seconds
Query Executed:select id FROM `nc` where city='Cleveland' && SIC_code='7219'DB:business_master_new
loadtime:0.34042096138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffside' limit 1
loadtime:0.34048199653625 / seconds
Query Executed:select id FROM `nc` where city='Cliffside' && SIC_code='7219'DB:business_master_new
loadtime:0.34116792678833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.34122514724731 / seconds
Query Executed:select id FROM `nc` where city='Climax' && SIC_code='7219'DB:business_master_new
loadtime:0.34412598609924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.34418606758118 / seconds
Query Executed:select id FROM `nc` where city='Clinton' && SIC_code='7219'DB:business_master_new
loadtime:0.34707903862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:0.34713792800903 / seconds
Query Executed:select id FROM `nc` where city='Clyde' && SIC_code='7219'DB:business_master_new
loadtime:0.35002112388611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coats' limit 1
loadtime:0.35007905960083 / seconds
Query Executed:select id FROM `nc` where city='Coats' && SIC_code='7219'DB:business_master_new
loadtime:0.35294699668884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cofield' limit 1
loadtime:0.35300707817078 / seconds
Query Executed:select id FROM `nc` where city='Cofield' && SIC_code='7219'DB:business_master_new
loadtime:0.35380697250366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coinjock' limit 1
loadtime:0.35387301445007 / seconds
Query Executed:select id FROM `nc` where city='Coinjock' && SIC_code='7219'DB:business_master_new
loadtime:0.35674405097961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colerain' limit 1
loadtime:0.35679697990417 / seconds
Query Executed:select id FROM `nc` where city='Colerain' && SIC_code='7219'DB:business_master_new
loadtime:0.35967993736267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleridge' limit 1
loadtime:0.35973310470581 / seconds
Query Executed:select id FROM `nc` where city='Coleridge' && SIC_code='7219'DB:business_master_new
loadtime:0.36018800735474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.36024713516235 / seconds
Query Executed:select id FROM `nc` where city='Colfax' && SIC_code='7219'DB:business_master_new
loadtime:0.36314606666565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collettsville' limit 1
loadtime:0.36320900917053 / seconds
Query Executed:select id FROM `nc` where city='Collettsville' && SIC_code='7219'DB:business_master_new
loadtime:0.36391806602478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.3639760017395 / seconds
Query Executed:select id FROM `nc` where city='Columbia' && SIC_code='7219'DB:business_master_new
loadtime:0.3668429851532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.36690092086792 / seconds
Query Executed:select id FROM `nc` where city='Columbus' && SIC_code='7219'DB:business_master_new
loadtime:0.36977910995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comfort' limit 1
loadtime:0.36983609199524 / seconds
Query Executed:select id FROM `nc` where city='Comfort' && SIC_code='7219'DB:business_master_new
loadtime:0.37035012245178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.37040209770203 / seconds
Query Executed:select id FROM `nc` where city='Como' && SIC_code='7219'DB:business_master_new
loadtime:0.37117314338684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.37123394012451 / seconds
Query Executed:select id FROM `nc` where city='Concord' && SIC_code='7219'DB:business_master_new
loadtime:0.37418508529663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conetoe' limit 1
loadtime:0.37434005737305 / seconds
Query Executed:select id FROM `nc` where city='Conetoe' && SIC_code='7219'DB:business_master_new
loadtime:0.37508392333984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Spgs' limit 1
loadtime:0.37514114379883 / seconds
Query Executed:select id FROM `nc` where city='Connellys Spgs' && SIC_code='7219'DB:business_master_new
loadtime:0.37559509277344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Springs' limit 1
loadtime:0.37565493583679 / seconds
Query Executed:select id FROM `nc` where city='Connellys Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.37608098983765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conover' limit 1
loadtime:0.37613892555237 / seconds
Query Executed:select id FROM `nc` where city='Conover' && SIC_code='7219'DB:business_master_new
loadtime:0.37904214859009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.3790979385376 / seconds
Query Executed:select id FROM `nc` where city='Conway' && SIC_code='7219'DB:business_master_new
loadtime:0.38198804855347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooleemee' limit 1
loadtime:0.38204193115234 / seconds
Query Executed:select id FROM `nc` where city='Cooleemee' && SIC_code='7219'DB:business_master_new
loadtime:0.38351106643677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corapeake' limit 1
loadtime:0.38357496261597 / seconds
Query Executed:select id FROM `nc` where city='Corapeake' && SIC_code='7219'DB:business_master_new
loadtime:0.38434505462646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.3844051361084 / seconds
Query Executed:select id FROM `nc` where city='Cordova' && SIC_code='7219'DB:business_master_new
loadtime:0.38504409790039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornelius' limit 1
loadtime:0.38510394096375 / seconds
Query Executed:select id FROM `nc` where city='Cornelius' && SIC_code='7219'DB:business_master_new
loadtime:0.38801097869873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corolla' limit 1
loadtime:0.38809299468994 / seconds
Query Executed:select id FROM `nc` where city='Corolla' && SIC_code='7219'DB:business_master_new
loadtime:0.3909649848938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:0.39102005958557 / seconds
Query Executed:select id FROM `nc` where city='Council' && SIC_code='7219'DB:business_master_new
loadtime:0.39200210571289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cove City' limit 1
loadtime:0.39206194877625 / seconds
Query Executed:select id FROM `nc` where city='Cove City' && SIC_code='7219'DB:business_master_new
loadtime:0.39494895935059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cramerton' limit 1
loadtime:0.39501094818115 / seconds
Query Executed:select id FROM `nc` where city='Cramerton' && SIC_code='7219'DB:business_master_new
loadtime:0.39790105819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creedmoor' limit 1
loadtime:0.39795708656311 / seconds
Query Executed:select id FROM `nc` where city='Creedmoor' && SIC_code='7219'DB:business_master_new
loadtime:0.40083599090576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.40089797973633 / seconds
Query Executed:select id FROM `nc` where city='Creston' && SIC_code='7219'DB:business_master_new
loadtime:0.40193605422974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creswell' limit 1
loadtime:0.40199494361877 / seconds
Query Executed:select id FROM `nc` where city='Creswell' && SIC_code='7219'DB:business_master_new
loadtime:0.40487599372864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossnore' limit 1
loadtime:0.40493297576904 / seconds
Query Executed:select id FROM `nc` where city='Crossnore' && SIC_code='7219'DB:business_master_new
loadtime:0.40578007698059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crouse' limit 1
loadtime:0.40584111213684 / seconds
Query Executed:select id FROM `nc` where city='Crouse' && SIC_code='7219'DB:business_master_new
loadtime:0.40680003166199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crumpler' limit 1
loadtime:0.40685796737671 / seconds
Query Executed:select id FROM `nc` where city='Crumpler' && SIC_code='7219'DB:business_master_new
loadtime:0.40814113616943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culberson' limit 1
loadtime:0.40820002555847 / seconds
Query Executed:select id FROM `nc` where city='Culberson' && SIC_code='7219'DB:business_master_new
loadtime:0.408607006073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullowhee' limit 1
loadtime:0.40866494178772 / seconds
Query Executed:select id FROM `nc` where city='Cullowhee' && SIC_code='7219'DB:business_master_new
loadtime:0.41154313087463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.41160202026367 / seconds
Query Executed:select id FROM `nc` where city='Cumberland' && SIC_code='7219'DB:business_master_new
loadtime:0.41224598884583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumnock' limit 1
loadtime:0.41230702400208 / seconds
Query Executed:select id FROM `nc` where city='Cumnock' && SIC_code='7219'DB:business_master_new
loadtime:0.41266894340515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currie' limit 1
loadtime:0.41273403167725 / seconds
Query Executed:select id FROM `nc` where city='Currie' && SIC_code='7219'DB:business_master_new
loadtime:0.41385102272034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currituck' limit 1
loadtime:0.41390991210938 / seconds
Query Executed:select id FROM `nc` where city='Currituck' && SIC_code='7219'DB:business_master_new
loadtime:0.41679906845093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.41685700416565 / seconds
Query Executed:select id FROM `nc` where city='Dallas' && SIC_code='7219'DB:business_master_new
loadtime:0.41974902153015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:0.41982412338257 / seconds
Query Executed:select id FROM `nc` where city='Dana' && SIC_code='7219'DB:business_master_new
loadtime:0.42064905166626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.4207079410553 / seconds
Query Executed:select id FROM `nc` where city='Danbury' && SIC_code='7219'DB:business_master_new
loadtime:0.42360305786133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davidson' limit 1
loadtime:0.42366409301758 / seconds
Query Executed:select id FROM `nc` where city='Davidson' && SIC_code='7219'DB:business_master_new
loadtime:0.42654895782471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.42662191390991 / seconds
Query Executed:select id FROM `nc` where city='Davis' && SIC_code='7219'DB:business_master_new
loadtime:0.42725014686584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Gap' limit 1
loadtime:0.42731308937073 / seconds
Query Executed:select id FROM `nc` where city='Deep Gap' && SIC_code='7219'DB:business_master_new
loadtime:0.43019795417786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Run' limit 1
loadtime:0.43025994300842 / seconds
Query Executed:select id FROM `nc` where city='Deep Run' && SIC_code='7219'DB:business_master_new
loadtime:0.43314504623413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delco' limit 1
loadtime:0.43319797515869 / seconds
Query Executed:select id FROM `nc` where city='Delco' && SIC_code='7219'DB:business_master_new
loadtime:0.43608808517456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denton' limit 1
loadtime:0.43614912033081 / seconds
Query Executed:select id FROM `nc` where city='Denton' && SIC_code='7219'DB:business_master_new
loadtime:0.43902492523193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.43908500671387 / seconds
Query Executed:select id FROM `nc` where city='Denver' && SIC_code='7219'DB:business_master_new
loadtime:0.44195508956909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillsboro' limit 1
loadtime:0.44201898574829 / seconds
Query Executed:select id FROM `nc` where city='Dillsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.44488406181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dobson' limit 1
loadtime:0.4449450969696 / seconds
Query Executed:select id FROM `nc` where city='Dobson' && SIC_code='7219'DB:business_master_new
loadtime:0.44782400131226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.44787907600403 / seconds
Query Executed:select id FROM `nc` where city='Dover' && SIC_code='7219'DB:business_master_new
loadtime:0.44932198524475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drexel' limit 1
loadtime:0.44937992095947 / seconds
Query Executed:select id FROM `nc` where city='Drexel' && SIC_code='7219'DB:business_master_new
loadtime:0.45088005065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.45094203948975 / seconds
Query Executed:select id FROM `nc` where city='Dublin' && SIC_code='7219'DB:business_master_new
loadtime:0.45207500457764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.45213198661804 / seconds
Query Executed:select id FROM `nc` where city='Dudley' && SIC_code='7219'DB:business_master_new
loadtime:0.4550199508667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn' limit 1
loadtime:0.455078125 / seconds
Query Executed:select id FROM `nc` where city='Dunn' && SIC_code='7219'DB:business_master_new
loadtime:0.45795202255249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durants Neck' limit 1
loadtime:0.45802998542786 / seconds
Query Executed:select id FROM `nc` where city='Durants Neck' && SIC_code='7219'DB:business_master_new
loadtime:0.45838403701782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.45844101905823 / seconds
Query Executed:select id FROM `nc` where city='Durham' && SIC_code='7219'DB:business_master_new
loadtime:0.46133804321289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:0.4614269733429 / seconds
Query Executed:select id FROM `nc` where city='Eagle Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.46185994148254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Springs' limit 1
loadtime:0.46192193031311 / seconds
Query Executed:select id FROM `nc` where city='Eagle Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.46293711662292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earl' limit 1
loadtime:0.46299600601196 / seconds
Query Executed:select id FROM `nc` where city='Earl' && SIC_code='7219'DB:business_master_new
loadtime:0.46354103088379 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bend' limit 1
loadtime:0.46359992027283 / seconds
Query Executed:select id FROM `nc` where city='East Bend' && SIC_code='7219'DB:business_master_new
loadtime:0.46661806106567 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fayettevlle' limit 1
loadtime:0.46668195724487 / seconds
Query Executed:select id FROM `nc` where city='East Fayettevlle' && SIC_code='7219'DB:business_master_new
loadtime:0.4670729637146 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Flat Rock' limit 1
loadtime:0.4671311378479 / seconds
Query Executed:select id FROM `nc` where city='East Flat Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.46999597549438 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lake' limit 1
loadtime:0.47005414962769 / seconds
Query Executed:select id FROM `nc` where city='East Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.47042393684387 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Spencer' limit 1
loadtime:0.47047901153564 / seconds
Query Executed:select id FROM `nc` where city='East Spencer' && SIC_code='7219'DB:business_master_new
loadtime:0.47135710716248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.47141003608704 / seconds
Query Executed:select id FROM `nc` where city='Eden' && SIC_code='7219'DB:business_master_new
loadtime:0.47428393363953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenton' limit 1
loadtime:0.47435808181763 / seconds
Query Executed:select id FROM `nc` where city='Edenton' && SIC_code='7219'DB:business_master_new
loadtime:0.47724914550781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edneyville' limit 1
loadtime:0.47730302810669 / seconds
Query Executed:select id FROM `nc` where city='Edneyville' && SIC_code='7219'DB:business_master_new
loadtime:0.47805309295654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edward' limit 1
loadtime:0.4781129360199 / seconds
Query Executed:select id FROM `nc` where city='Edward' && SIC_code='7219'DB:business_master_new
loadtime:0.47874712944031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Efland' limit 1
loadtime:0.47880697250366 / seconds
Query Executed:select id FROM `nc` where city='Efland' && SIC_code='7219'DB:business_master_new
loadtime:0.48170709609985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth City' limit 1
loadtime:0.48176693916321 / seconds
Query Executed:select id FROM `nc` where city='Elizabeth City' && SIC_code='7219'DB:business_master_new
loadtime:0.48464798927307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabethtown' limit 1
loadtime:0.4847309589386 / seconds
Query Executed:select id FROM `nc` where city='Elizabethtown' && SIC_code='7219'DB:business_master_new
loadtime:0.48760414123535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Park' limit 1
loadtime:0.48766207695007 / seconds
Query Executed:select id FROM `nc` where city='Elk Park' && SIC_code='7219'DB:business_master_new
loadtime:0.4893319606781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkin' limit 1
loadtime:0.48939204216003 / seconds
Query Executed:select id FROM `nc` where city='Elkin' && SIC_code='7219'DB:business_master_new
loadtime:0.49226999282837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellenboro' limit 1
loadtime:0.49232697486877 / seconds
Query Executed:select id FROM `nc` where city='Ellenboro' && SIC_code='7219'DB:business_master_new
loadtime:0.49467492103577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellerbe' limit 1
loadtime:0.49473810195923 / seconds
Query Executed:select id FROM `nc` where city='Ellerbe' && SIC_code='7219'DB:business_master_new
loadtime:0.49763512611389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm City' limit 1
loadtime:0.49769711494446 / seconds
Query Executed:select id FROM `nc` where city='Elm City' && SIC_code='7219'DB:business_master_new
loadtime:0.50061702728271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon' limit 1
loadtime:0.50067901611328 / seconds
Query Executed:select id FROM `nc` where city='Elon' && SIC_code='7219'DB:business_master_new
loadtime:0.50357604026794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon College' limit 1
loadtime:0.50363111495972 / seconds
Query Executed:select id FROM `nc` where city='Elon College' && SIC_code='7219'DB:business_master_new
loadtime:0.50431609153748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerald Isle' limit 1
loadtime:0.50437498092651 / seconds
Query Executed:select id FROM `nc` where city='Emerald Isle' && SIC_code='7219'DB:business_master_new
loadtime:0.50728797912598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.50734210014343 / seconds
Query Executed:select id FROM `nc` where city='Enfield' && SIC_code='7219'DB:business_master_new
loadtime:0.51026010513306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engelhard' limit 1
loadtime:0.51031494140625 / seconds
Query Executed:select id FROM `nc` where city='Engelhard' && SIC_code='7219'DB:business_master_new
loadtime:0.51178407669067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enka' limit 1
loadtime:0.51184105873108 / seconds
Query Executed:select id FROM `nc` where city='Enka' && SIC_code='7219'DB:business_master_new
loadtime:0.5132360458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ennice' limit 1
loadtime:0.51329302787781 / seconds
Query Executed:select id FROM `nc` where city='Ennice' && SIC_code='7219'DB:business_master_new
loadtime:0.51444911956787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ernul' limit 1
loadtime:0.51450204849243 / seconds
Query Executed:select id FROM `nc` where city='Ernul' && SIC_code='7219'DB:business_master_new
loadtime:0.51526999473572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.51532292366028 / seconds
Query Executed:select id FROM `nc` where city='Erwin' && SIC_code='7219'DB:business_master_new
loadtime:0.51822113990784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ether' limit 1
loadtime:0.51828002929688 / seconds
Query Executed:select id FROM `nc` where city='Ether' && SIC_code='7219'DB:business_master_new
loadtime:0.51893401145935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etowah' limit 1
loadtime:0.51898598670959 / seconds
Query Executed:select id FROM `nc` where city='Etowah' && SIC_code='7219'DB:business_master_new
loadtime:0.52129006385803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eure' limit 1
loadtime:0.52134299278259 / seconds
Query Executed:select id FROM `nc` where city='Eure' && SIC_code='7219'DB:business_master_new
loadtime:0.52219700813293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.5222589969635 / seconds
Query Executed:select id FROM `nc` where city='Eureka' && SIC_code='7219'DB:business_master_new
loadtime:0.52264499664307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everetts' limit 1
loadtime:0.52270102500916 / seconds
Query Executed:select id FROM `nc` where city='Everetts' && SIC_code='7219'DB:business_master_new
loadtime:0.52330803871155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:0.52336502075195 / seconds
Query Executed:select id FROM `nc` where city='Evergreen' && SIC_code='7219'DB:business_master_new
loadtime:0.5243239402771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Bluff' limit 1
loadtime:0.52438712120056 / seconds
Query Executed:select id FROM `nc` where city='Fair Bluff' && SIC_code='7219'DB:business_master_new
loadtime:0.52660894393921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.52666091918945 / seconds
Query Executed:select id FROM `nc` where city='Fairfield' && SIC_code='7219'DB:business_master_new
loadtime:0.52777695655823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairmont' limit 1
loadtime:0.52783513069153 / seconds
Query Executed:select id FROM `nc` where city='Fairmont' && SIC_code='7219'DB:business_master_new
loadtime:0.53074312210083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.53080201148987 / seconds
Query Executed:select id FROM `nc` where city='Fairview' && SIC_code='7219'DB:business_master_new
loadtime:0.53369402885437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faison' limit 1
loadtime:0.53376793861389 / seconds
Query Executed:select id FROM `nc` where city='Faison' && SIC_code='7219'DB:business_master_new
loadtime:0.53664708137512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.53670907020569 / seconds
Query Executed:select id FROM `nc` where city='Faith' && SIC_code='7219'DB:business_master_new
loadtime:0.53778910636902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:0.53784704208374 / seconds
Query Executed:select id FROM `nc` where city='Falcon' && SIC_code='7219'DB:business_master_new
loadtime:0.53863501548767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkland' limit 1
loadtime:0.53869891166687 / seconds
Query Executed:select id FROM `nc` where city='Falkland' && SIC_code='7219'DB:business_master_new
loadtime:0.53937411308289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fallston' limit 1
loadtime:0.53943204879761 / seconds
Query Executed:select id FROM `nc` where city='Fallston' && SIC_code='7219'DB:business_master_new
loadtime:0.54056692123413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:0.54062414169312 / seconds
Query Executed:select id FROM `nc` where city='Farmville' && SIC_code='7219'DB:business_master_new
loadtime:0.54354500770569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayetteville' limit 1
loadtime:0.54360508918762 / seconds
Query Executed:select id FROM `nc` where city='Fayetteville' && SIC_code='7219'DB:business_master_new
loadtime:0.54651713371277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fearrington Vlg' limit 1
loadtime:0.54660892486572 / seconds
Query Executed:select id FROM `nc` where city='Fearrington Vlg' && SIC_code='7219'DB:business_master_new
loadtime:0.54697704315186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:0.54703712463379 / seconds
Query Executed:select id FROM `nc` where city='Ferguson' && SIC_code='7219'DB:business_master_new
loadtime:0.54990100860596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:0.54996013641357 / seconds
Query Executed:select id FROM `nc` where city='Flat Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.55283093452454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fleetwood' limit 1
loadtime:0.55288600921631 / seconds
Query Executed:select id FROM `nc` where city='Fleetwood' && SIC_code='7219'DB:business_master_new
loadtime:0.55446100234985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fletcher' limit 1
loadtime:0.55451703071594 / seconds
Query Executed:select id FROM `nc` where city='Fletcher' && SIC_code='7219'DB:business_master_new
loadtime:0.55739593505859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana Dam' limit 1
loadtime:0.55745697021484 / seconds
Query Executed:select id FROM `nc` where city='Fontana Dam' && SIC_code='7219'DB:business_master_new
loadtime:0.55796098709106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:0.55802297592163 / seconds
Query Executed:select id FROM `nc` where city='Forest City' && SIC_code='7219'DB:business_master_new
loadtime:0.56090402603149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bragg' limit 1
loadtime:0.56097602844238 / seconds
Query Executed:select id FROM `nc` where city='Fort Bragg' && SIC_code='7219'DB:business_master_new
loadtime:0.56385397911072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:0.56392502784729 / seconds
Query Executed:select id FROM `nc` where city='Fountain' && SIC_code='7219'DB:business_master_new
loadtime:0.56511092185974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Four Oaks' limit 1
loadtime:0.56516408920288 / seconds
Query Executed:select id FROM `nc` where city='Four Oaks' && SIC_code='7219'DB:business_master_new
loadtime:0.56805014610291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.56811213493347 / seconds
Query Executed:select id FROM `nc` where city='Franklin' && SIC_code='7219'DB:business_master_new
loadtime:0.57099604606628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinton' limit 1
loadtime:0.57105994224548 / seconds
Query Executed:select id FROM `nc` where city='Franklinton' && SIC_code='7219'DB:business_master_new
loadtime:0.57395792007446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinville' limit 1
loadtime:0.57401895523071 / seconds
Query Executed:select id FROM `nc` where city='Franklinville' && SIC_code='7219'DB:business_master_new
loadtime:0.57691812515259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.57697510719299 / seconds
Query Executed:select id FROM `nc` where city='Fremont' && SIC_code='7219'DB:business_master_new
loadtime:0.57986807823181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco' limit 1
loadtime:0.57993602752686 / seconds
Query Executed:select id FROM `nc` where city='Frisco' && SIC_code='7219'DB:business_master_new
loadtime:0.58281993865967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fuquay Varina' limit 1
loadtime:0.58287811279297 / seconds
Query Executed:select id FROM `nc` where city='Fuquay Varina' && SIC_code='7219'DB:business_master_new
loadtime:0.58574414253235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:0.58581614494324 / seconds
Query Executed:select id FROM `nc` where city='Garland' && SIC_code='7219'DB:business_master_new
loadtime:0.58867907524109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:0.58874797821045 / seconds
Query Executed:select id FROM `nc` where city='Garner' && SIC_code='7219'DB:business_master_new
loadtime:0.59163093566895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garysburg' limit 1
loadtime:0.59170699119568 / seconds
Query Executed:select id FROM `nc` where city='Garysburg' && SIC_code='7219'DB:business_master_new
loadtime:0.5928430557251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:0.59290909767151 / seconds
Query Executed:select id FROM `nc` where city='Gaston' && SIC_code='7219'DB:business_master_new
loadtime:0.59420013427734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gastonia' limit 1
loadtime:0.5942599773407 / seconds
Query Executed:select id FROM `nc` where city='Gastonia' && SIC_code='7219'DB:business_master_new
loadtime:0.59715700149536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gates' limit 1
loadtime:0.59722900390625 / seconds
Query Executed:select id FROM `nc` where city='Gates' && SIC_code='7219'DB:business_master_new
loadtime:0.60010099411011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gatesville' limit 1
loadtime:0.60016202926636 / seconds
Query Executed:select id FROM `nc` where city='Gatesville' && SIC_code='7219'DB:business_master_new
loadtime:0.60305309295654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germanton' limit 1
loadtime:0.60311102867126 / seconds
Query Executed:select id FROM `nc` where city='Germanton' && SIC_code='7219'DB:business_master_new
loadtime:0.60600614547729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gerton' limit 1
loadtime:0.60606503486633 / seconds
Query Executed:select id FROM `nc` where city='Gerton' && SIC_code='7219'DB:business_master_new
loadtime:0.60658407211304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:0.60664296150208 / seconds
Query Executed:select id FROM `nc` where city='Gibson' && SIC_code='7219'DB:business_master_new
loadtime:0.60758495330811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibsonville' limit 1
loadtime:0.60764312744141 / seconds
Query Executed:select id FROM `nc` where city='Gibsonville' && SIC_code='7219'DB:business_master_new
loadtime:0.61052203178406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Valley' limit 1
loadtime:0.61059212684631 / seconds
Query Executed:select id FROM `nc` where city='Glade Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.61156010627747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Alpine' limit 1
loadtime:0.61163306236267 / seconds
Query Executed:select id FROM `nc` where city='Glen Alpine' && SIC_code='7219'DB:business_master_new
loadtime:0.61285209655762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Raven' limit 1
loadtime:0.61291599273682 / seconds
Query Executed:select id FROM `nc` where city='Glen Raven' && SIC_code='7219'DB:business_master_new
loadtime:0.61331391334534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale Springs' limit 1
loadtime:0.61336612701416 / seconds
Query Executed:select id FROM `nc` where city='Glendale Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.61401605606079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendon' limit 1
loadtime:0.6140730381012 / seconds
Query Executed:select id FROM `nc` where city='Glendon' && SIC_code='7219'DB:business_master_new
loadtime:0.61448192596436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenville' limit 1
loadtime:0.61453700065613 / seconds
Query Executed:select id FROM `nc` where city='Glenville' && SIC_code='7219'DB:business_master_new
loadtime:0.61580395698547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.61585712432861 / seconds
Query Executed:select id FROM `nc` where city='Glenwood' && SIC_code='7219'DB:business_master_new
loadtime:0.61635613441467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.61640810966492 / seconds
Query Executed:select id FROM `nc` where city='Gloucester' && SIC_code='7219'DB:business_master_new
loadtime:0.6169581413269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Godwin' limit 1
loadtime:0.61702013015747 / seconds
Query Executed:select id FROM `nc` where city='Godwin' && SIC_code='7219'DB:business_master_new
loadtime:0.61829209327698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gold Hill' limit 1
loadtime:0.61834406852722 / seconds
Query Executed:select id FROM `nc` where city='Gold Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.61995410919189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldsboro' limit 1
loadtime:0.62000894546509 / seconds
Query Executed:select id FROM `nc` where city='Goldsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.62289500236511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldston' limit 1
loadtime:0.62296891212463 / seconds
Query Executed:select id FROM `nc` where city='Goldston' && SIC_code='7219'DB:business_master_new
loadtime:0.6245551109314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graham' limit 1
loadtime:0.62460994720459 / seconds
Query Executed:select id FROM `nc` where city='Graham' && SIC_code='7219'DB:business_master_new
loadtime:0.62749004364014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandy' limit 1
loadtime:0.62756109237671 / seconds
Query Executed:select id FROM `nc` where city='Grandy' && SIC_code='7219'DB:business_master_new
loadtime:0.62993407249451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Falls' limit 1
loadtime:0.62999391555786 / seconds
Query Executed:select id FROM `nc` where city='Granite Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.63287305831909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Quarry' limit 1
loadtime:0.63294005393982 / seconds
Query Executed:select id FROM `nc` where city='Granite Quarry' && SIC_code='7219'DB:business_master_new
loadtime:0.6344199180603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsboro' limit 1
loadtime:0.63447904586792 / seconds
Query Executed:select id FROM `nc` where city='Grantsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.63560199737549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grassy Creek' limit 1
loadtime:0.63566112518311 / seconds
Query Executed:select id FROM `nc` where city='Grassy Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.63629412651062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:0.63634610176086 / seconds
Query Executed:select id FROM `nc` where city='Green Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.63715314865112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenmountain' limit 1
loadtime:0.63721108436584 / seconds
Query Executed:select id FROM `nc` where city='Greenmountain' && SIC_code='7219'DB:business_master_new
loadtime:0.637610912323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:0.63766694068909 / seconds
Query Executed:select id FROM `nc` where city='Greensboro' && SIC_code='7219'DB:business_master_new
loadtime:0.64057397842407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.6406729221344 / seconds
Query Executed:select id FROM `nc` where city='Greenville' && SIC_code='7219'DB:business_master_new
loadtime:0.64355993270874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grifton' limit 1
loadtime:0.64363694190979 / seconds
Query Executed:select id FROM `nc` where city='Grifton' && SIC_code='7219'DB:business_master_new
loadtime:0.64653491973877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimesland' limit 1
loadtime:0.64659309387207 / seconds
Query Executed:select id FROM `nc` where city='Grimesland' && SIC_code='7219'DB:business_master_new
loadtime:0.64886713027954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.64893102645874 / seconds
Query Executed:select id FROM `nc` where city='Grover' && SIC_code='7219'DB:business_master_new
loadtime:0.65090608596802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulf' limit 1
loadtime:0.65096402168274 / seconds
Query Executed:select id FROM `nc` where city='Gulf' && SIC_code='7219'DB:business_master_new
loadtime:0.65154194831848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.65159702301025 / seconds
Query Executed:select id FROM `nc` where city='Halifax' && SIC_code='7219'DB:business_master_new
loadtime:0.65438795089722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallsboro' limit 1
loadtime:0.65445899963379 / seconds
Query Executed:select id FROM `nc` where city='Hallsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.65554213523865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.65560293197632 / seconds
Query Executed:select id FROM `nc` where city='Hamilton' && SIC_code='7219'DB:business_master_new
loadtime:0.65656208992004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlet' limit 1
loadtime:0.6566219329834 / seconds
Query Executed:select id FROM `nc` where city='Hamlet' && SIC_code='7219'DB:business_master_new
loadtime:0.65952014923096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.65957403182983 / seconds
Query Executed:select id FROM `nc` where city='Hampstead' && SIC_code='7219'DB:business_master_new
loadtime:0.66247797012329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamptonville' limit 1
loadtime:0.66254091262817 / seconds
Query Executed:select id FROM `nc` where city='Hamptonville' && SIC_code='7219'DB:business_master_new
loadtime:0.66544413566589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbinger' limit 1
loadtime:0.66550302505493 / seconds
Query Executed:select id FROM `nc` where city='Harbinger' && SIC_code='7219'DB:business_master_new
loadtime:0.66707491874695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harkers Island' limit 1
loadtime:0.66713309288025 / seconds
Query Executed:select id FROM `nc` where city='Harkers Island' && SIC_code='7219'DB:business_master_new
loadtime:0.67002201080322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harmony' limit 1
loadtime:0.67007613182068 / seconds
Query Executed:select id FROM `nc` where city='Harmony' && SIC_code='7219'DB:business_master_new
loadtime:0.67298007011414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrells' limit 1
loadtime:0.67305898666382 / seconds
Query Executed:select id FROM `nc` where city='Harrells' && SIC_code='7219'DB:business_master_new
loadtime:0.67597794532776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrellsville' limit 1
loadtime:0.67604303359985 / seconds
Query Executed:select id FROM `nc` where city='Harrellsville' && SIC_code='7219'DB:business_master_new
loadtime:0.67688798904419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:0.67695093154907 / seconds
Query Executed:select id FROM `nc` where city='Harris' && SIC_code='7219'DB:business_master_new
loadtime:0.67739295959473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.6774480342865 / seconds
Query Executed:select id FROM `nc` where city='Harrisburg' && SIC_code='7219'DB:business_master_new
loadtime:0.68030214309692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hassell' limit 1
loadtime:0.68036413192749 / seconds
Query Executed:select id FROM `nc` where city='Hassell' && SIC_code='7219'DB:business_master_new
loadtime:0.68080496788025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatteras' limit 1
loadtime:0.68086409568787 / seconds
Query Executed:select id FROM `nc` where city='Hatteras' && SIC_code='7219'DB:business_master_new
loadtime:0.6837329864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:0.68378806114197 / seconds
Query Executed:select id FROM `nc` where city='Havelock' && SIC_code='7219'DB:business_master_new
loadtime:0.68668508529663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haw River' limit 1
loadtime:0.68677091598511 / seconds
Query Executed:select id FROM `nc` where city='Haw River' && SIC_code='7219'DB:business_master_new
loadtime:0.68966794013977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:0.68973612785339 / seconds
Query Executed:select id FROM `nc` where city='Hayesville' && SIC_code='7219'DB:business_master_new
loadtime:0.69263696670532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hays' limit 1
loadtime:0.69269609451294 / seconds
Query Executed:select id FROM `nc` where city='Hays' && SIC_code='7219'DB:business_master_new
loadtime:0.69560194015503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelwood' limit 1
loadtime:0.69566202163696 / seconds
Query Executed:select id FROM `nc` where city='Hazelwood' && SIC_code='7219'DB:business_master_new
loadtime:0.6964271068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.69648504257202 / seconds
Query Executed:select id FROM `nc` where city='Henderson' && SIC_code='7219'DB:business_master_new
loadtime:0.69940805435181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hendersonville' limit 1
loadtime:0.69948101043701 / seconds
Query Executed:select id FROM `nc` where city='Hendersonville' && SIC_code='7219'DB:business_master_new
loadtime:0.70239591598511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrico' limit 1
loadtime:0.70247006416321 / seconds
Query Executed:select id FROM `nc` where city='Henrico' && SIC_code='7219'DB:business_master_new
loadtime:0.7033519744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrietta' limit 1
loadtime:0.70341491699219 / seconds
Query Executed:select id FROM `nc` where city='Henrietta' && SIC_code='7219'DB:business_master_new
loadtime:0.70407795906067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hertford' limit 1
loadtime:0.70413494110107 / seconds
Query Executed:select id FROM `nc` where city='Hertford' && SIC_code='7219'DB:business_master_new
loadtime:0.70700097084045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:0.70705413818359 / seconds
Query Executed:select id FROM `nc` where city='Hickory' && SIC_code='7219'DB:business_master_new
loadtime:0.70991992950439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiddenite' limit 1
loadtime:0.71000003814697 / seconds
Query Executed:select id FROM `nc` where city='Hiddenite' && SIC_code='7219'DB:business_master_new
loadtime:0.71226596832275 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Point' limit 1
loadtime:0.71232795715332 / seconds
Query Executed:select id FROM `nc` where city='High Point' && SIC_code='7219'DB:business_master_new
loadtime:0.7152259349823 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Shoals' limit 1
loadtime:0.7153000831604 / seconds
Query Executed:select id FROM `nc` where city='High Shoals' && SIC_code='7219'DB:business_master_new
loadtime:0.71589303016663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highfalls' limit 1
loadtime:0.71595406532288 / seconds
Query Executed:select id FROM `nc` where city='Highfalls' && SIC_code='7219'DB:business_master_new
loadtime:0.71650409698486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands' limit 1
loadtime:0.7165629863739 / seconds
Query Executed:select id FROM `nc` where city='Highlands' && SIC_code='7219'DB:business_master_new
loadtime:0.71945405006409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildebran' limit 1
loadtime:0.71952104568481 / seconds
Query Executed:select id FROM `nc` where city='Hildebran' && SIC_code='7219'DB:business_master_new
loadtime:0.72288513183594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.7229471206665 / seconds
Query Executed:select id FROM `nc` where city='Hillsborough' && SIC_code='7219'DB:business_master_new
loadtime:0.725830078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbsville' limit 1
loadtime:0.72590899467468 / seconds
Query Executed:select id FROM `nc` where city='Hobbsville' && SIC_code='7219'DB:business_master_new
loadtime:0.72671794891357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobgood' limit 1
loadtime:0.72677707672119 / seconds
Query Executed:select id FROM `nc` where city='Hobgood' && SIC_code='7219'DB:business_master_new
loadtime:0.72758197784424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobucken' limit 1
loadtime:0.72763609886169 / seconds
Query Executed:select id FROM `nc` where city='Hobucken' && SIC_code='7219'DB:business_master_new
loadtime:0.72815108299255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoffman' limit 1
loadtime:0.7282190322876 / seconds
Query Executed:select id FROM `nc` where city='Hoffman' && SIC_code='7219'DB:business_master_new
loadtime:0.72910094261169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden Beach' limit 1
loadtime:0.72916007041931 / seconds
Query Executed:select id FROM `nc` where city='Holden Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.72978091239929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollister' limit 1
loadtime:0.72983407974243 / seconds
Query Executed:select id FROM `nc` where city='Hollister' && SIC_code='7219'DB:business_master_new
loadtime:0.73116493225098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:0.73122692108154 / seconds
Query Executed:select id FROM `nc` where city='Holly Ridge' && SIC_code='7219'DB:business_master_new
loadtime:0.73411512374878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:0.73416805267334 / seconds
Query Executed:select id FROM `nc` where city='Holly Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.73703193664551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hookerton' limit 1
loadtime:0.73709201812744 / seconds
Query Executed:select id FROM `nc` where city='Hookerton' && SIC_code='7219'DB:business_master_new
loadtime:0.73994994163513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope Mills' limit 1
loadtime:0.74000310897827 / seconds
Query Executed:select id FROM `nc` where city='Hope Mills' && SIC_code='7219'DB:business_master_new
loadtime:0.74286508560181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horse Shoe' limit 1
loadtime:0.74292802810669 / seconds
Query Executed:select id FROM `nc` where city='Horse Shoe' && SIC_code='7219'DB:business_master_new
loadtime:0.74580097198486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.74586510658264 / seconds
Query Executed:select id FROM `nc` where city='Hot Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.74874711036682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubert' limit 1
loadtime:0.74880599975586 / seconds
Query Executed:select id FROM `nc` where city='Hubert' && SIC_code='7219'DB:business_master_new
loadtime:0.75168204307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.75174403190613 / seconds
Query Executed:select id FROM `nc` where city='Hudson' && SIC_code='7219'DB:business_master_new
loadtime:0.75463008880615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntersville' limit 1
loadtime:0.75468897819519 / seconds
Query Executed:select id FROM `nc` where city='Huntersville' && SIC_code='7219'DB:business_master_new
loadtime:0.75758194923401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurdle Mills' limit 1
loadtime:0.75765109062195 / seconds
Query Executed:select id FROM `nc` where city='Hurdle Mills' && SIC_code='7219'DB:business_master_new
loadtime:0.76052212715149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Icard' limit 1
loadtime:0.76058101654053 / seconds
Query Executed:select id FROM `nc` where city='Icard' && SIC_code='7219'DB:business_master_new
loadtime:0.76141810417175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Trail' limit 1
loadtime:0.76147508621216 / seconds
Query Executed:select id FROM `nc` where city='Indian Trail' && SIC_code='7219'DB:business_master_new
loadtime:0.76435112953186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Station' limit 1
loadtime:0.76442408561707 / seconds
Query Executed:select id FROM `nc` where city='Iron Station' && SIC_code='7219'DB:business_master_new
loadtime:0.76731109619141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:0.7673659324646 / seconds
Query Executed:select id FROM `nc` where city='Ivanhoe' && SIC_code='7219'DB:business_master_new
loadtime:0.76839303970337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.7684531211853 / seconds
Query Executed:select id FROM `nc` where city='Jackson' && SIC_code='7219'DB:business_master_new
loadtime:0.77132511138916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Springs' limit 1
loadtime:0.77138209342957 / seconds
Query Executed:select id FROM `nc` where city='Jackson Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.77240300178528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:0.77245593070984 / seconds
Query Executed:select id FROM `nc` where city='Jacksonville' && SIC_code='7219'DB:business_master_new
loadtime:0.77535700798035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:0.77543711662292 / seconds
Query Executed:select id FROM `nc` where city='Jamestown' && SIC_code='7219'DB:business_master_new
loadtime:0.77830004692078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:0.7783739566803 / seconds
Query Executed:select id FROM `nc` where city='Jamesville' && SIC_code='7219'DB:business_master_new
loadtime:0.78123497962952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarvisburg' limit 1
loadtime:0.78129410743713 / seconds
Query Executed:select id FROM `nc` where city='Jarvisburg' && SIC_code='7219'DB:business_master_new
loadtime:0.78229999542236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.78235411643982 / seconds
Query Executed:select id FROM `nc` where city='Jefferson' && SIC_code='7219'DB:business_master_new
loadtime:0.78524112701416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonas Ridge' limit 1
loadtime:0.78529906272888 / seconds
Query Executed:select id FROM `nc` where city='Jonas Ridge' && SIC_code='7219'DB:business_master_new
loadtime:0.785884141922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:0.78594398498535 / seconds
Query Executed:select id FROM `nc` where city='Jonesville' && SIC_code='7219'DB:business_master_new
loadtime:0.78881406784058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julian' limit 1
loadtime:0.78887701034546 / seconds
Query Executed:select id FROM `nc` where city='Julian' && SIC_code='7219'DB:business_master_new
loadtime:0.79040598869324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kannapolis' limit 1
loadtime:0.79046201705933 / seconds
Query Executed:select id FROM `nc` where city='Kannapolis' && SIC_code='7219'DB:business_master_new
loadtime:0.79335904121399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelford' limit 1
loadtime:0.79343295097351 / seconds
Query Executed:select id FROM `nc` where city='Kelford' && SIC_code='7219'DB:business_master_new
loadtime:0.79400992393494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelly' limit 1
loadtime:0.79406905174255 / seconds
Query Executed:select id FROM `nc` where city='Kelly' && SIC_code='7219'DB:business_master_new
loadtime:0.79496312141418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenansville' limit 1
loadtime:0.79501700401306 / seconds
Query Executed:select id FROM `nc` where city='Kenansville' && SIC_code='7219'DB:business_master_new
loadtime:0.79789304733276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenly' limit 1
loadtime:0.7979519367218 / seconds
Query Executed:select id FROM `nc` where city='Kenly' && SIC_code='7219'DB:business_master_new
loadtime:0.80084705352783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kernersville' limit 1
loadtime:0.80090594291687 / seconds
Query Executed:select id FROM `nc` where city='Kernersville' && SIC_code='7219'DB:business_master_new
loadtime:0.80378603935242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kill Devil Hills' limit 1
loadtime:0.80385708808899 / seconds
Query Executed:select id FROM `nc` where city='Kill Devil Hills' && SIC_code='7219'DB:business_master_new
loadtime:0.80672311782837 / seconds
Query loaded from cache:select * from geodata_geocity where city='King' limit 1
loadtime:0.80679392814636 / seconds
Query Executed:select id FROM `nc` where city='King' && SIC_code='7219'DB:business_master_new
loadtime:0.80965709686279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Mountain' limit 1
loadtime:0.80973100662231 / seconds
Query Executed:select id FROM `nc` where city='Kings Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.81263399124146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstown' limit 1
loadtime:0.81272506713867 / seconds
Query Executed:select id FROM `nc` where city='Kingstown' && SIC_code='7219'DB:business_master_new
loadtime:0.81316900253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinston' limit 1
loadtime:0.81323313713074 / seconds
Query Executed:select id FROM `nc` where city='Kinston' && SIC_code='7219'DB:business_master_new
loadtime:0.81614995002747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kipling' limit 1
loadtime:0.81620812416077 / seconds
Query Executed:select id FROM `nc` where city='Kipling' && SIC_code='7219'DB:business_master_new
loadtime:0.8167679309845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittrell' limit 1
loadtime:0.81682705879211 / seconds
Query Executed:select id FROM `nc` where city='Kittrell' && SIC_code='7219'DB:business_master_new
loadtime:0.8185350894928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kitty Hawk' limit 1
loadtime:0.81859302520752 / seconds
Query Executed:select id FROM `nc` where city='Kitty Hawk' && SIC_code='7219'DB:business_master_new
loadtime:0.82148504257202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knightdale' limit 1
loadtime:0.82154512405396 / seconds
Query Executed:select id FROM `nc` where city='Knightdale' && SIC_code='7219'DB:business_master_new
loadtime:0.82445096969604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knotts Island' limit 1
loadtime:0.82452297210693 / seconds
Query Executed:select id FROM `nc` where city='Knotts Island' && SIC_code='7219'DB:business_master_new
loadtime:0.82553601264954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kure Beach' limit 1
loadtime:0.82559704780579 / seconds
Query Executed:select id FROM `nc` where city='Kure Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.82769203186035 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Grange' limit 1
loadtime:0.82775807380676 / seconds
Query Executed:select id FROM `nc` where city='La Grange' && SIC_code='7219'DB:business_master_new
loadtime:0.83061814308167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Junaluska' limit 1
loadtime:0.83067297935486 / seconds
Query Executed:select id FROM `nc` where city='Lake Junaluska' && SIC_code='7219'DB:business_master_new
loadtime:0.83182597160339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Lure' limit 1
loadtime:0.83188891410828 / seconds
Query Executed:select id FROM `nc` where city='Lake Lure' && SIC_code='7219'DB:business_master_new
loadtime:0.83465003967285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Santeetlah' limit 1
loadtime:0.83471512794495 / seconds
Query Executed:select id FROM `nc` where city='Lake Santeetlah' && SIC_code='7219'DB:business_master_new
loadtime:0.83508992195129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Toxaway' limit 1
loadtime:0.83515405654907 / seconds
Query Executed:select id FROM `nc` where city='Lake Toxaway' && SIC_code='7219'DB:business_master_new
loadtime:0.83703994750977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Waccamaw' limit 1
loadtime:0.8371000289917 / seconds
Query Executed:select id FROM `nc` where city='Lake Waccamaw' && SIC_code='7219'DB:business_master_new
loadtime:0.83868312835693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:0.83874797821045 / seconds
Query Executed:select id FROM `nc` where city='Lakeview' && SIC_code='7219'DB:business_master_new
loadtime:0.83938312530518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landis' limit 1
loadtime:0.83944511413574 / seconds
Query Executed:select id FROM `nc` where city='Landis' && SIC_code='7219'DB:business_master_new
loadtime:0.84147810935974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:0.84153914451599 / seconds
Query Executed:select id FROM `nc` where city='Lansing' && SIC_code='7219'DB:business_master_new
loadtime:0.84321093559265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lasker' limit 1
loadtime:0.84327292442322 / seconds
Query Executed:select id FROM `nc` where city='Lasker' && SIC_code='7219'DB:business_master_new
loadtime:0.84368014335632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lattimore' limit 1
loadtime:0.84374809265137 / seconds
Query Executed:select id FROM `nc` where city='Lattimore' && SIC_code='7219'DB:business_master_new
loadtime:0.84451103210449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Hill' limit 1
loadtime:0.84457206726074 / seconds
Query Executed:select id FROM `nc` where city='Laurel Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.84651613235474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Springs' limit 1
loadtime:0.84657597541809 / seconds
Query Executed:select id FROM `nc` where city='Laurel Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.8480019569397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurinburg' limit 1
loadtime:0.848060131073 / seconds
Query Executed:select id FROM `nc` where city='Laurinburg' && SIC_code='7219'DB:business_master_new
loadtime:0.85097694396973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawndale' limit 1
loadtime:0.85105109214783 / seconds
Query Executed:select id FROM `nc` where city='Lawndale' && SIC_code='7219'DB:business_master_new
loadtime:0.8539400100708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawsonville' limit 1
loadtime:0.85399413108826 / seconds
Query Executed:select id FROM `nc` where city='Lawsonville' && SIC_code='7219'DB:business_master_new
loadtime:0.85508012771606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leasburg' limit 1
loadtime:0.85513591766357 / seconds
Query Executed:select id FROM `nc` where city='Leasburg' && SIC_code='7219'DB:business_master_new
loadtime:0.85613012313843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:0.85618805885315 / seconds
Query Executed:select id FROM `nc` where city='Leicester' && SIC_code='7219'DB:business_master_new
loadtime:0.85907196998596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:0.85913610458374 / seconds
Query Executed:select id FROM `nc` where city='Leland' && SIC_code='7219'DB:business_master_new
loadtime:0.86202597618103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemon Springs' limit 1
loadtime:0.86207795143127 / seconds
Query Executed:select id FROM `nc` where city='Lemon Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.86272597312927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenoir' limit 1
loadtime:0.86277794837952 / seconds
Query Executed:select id FROM `nc` where city='Lenoir' && SIC_code='7219'DB:business_master_new
loadtime:0.86568999290466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodville' limit 1
loadtime:0.86577200889587 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodville' && SIC_code='7219'DB:business_master_new
loadtime:0.8671441078186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodvl' limit 1
loadtime:0.86720204353333 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodvl' && SIC_code='7219'DB:business_master_new
loadtime:0.86762499809265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewisville' limit 1
loadtime:0.86768102645874 / seconds
Query Executed:select id FROM `nc` where city='Lewisville' && SIC_code='7219'DB:business_master_new
loadtime:0.87058997154236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.87064909934998 / seconds
Query Executed:select id FROM `nc` where city='Lexington' && SIC_code='7219'DB:business_master_new
loadtime:0.87352800369263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.87360000610352 / seconds
Query Executed:select id FROM `nc` where city='Liberty' && SIC_code='7219'DB:business_master_new
loadtime:0.8764750957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lilesville' limit 1
loadtime:0.87652993202209 / seconds
Query Executed:select id FROM `nc` where city='Lilesville' && SIC_code='7219'DB:business_master_new
loadtime:0.87809491157532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lillington' limit 1
loadtime:0.87815093994141 / seconds
Query Executed:select id FROM `nc` where city='Lillington' && SIC_code='7219'DB:business_master_new
loadtime:0.88102698326111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnton' limit 1
loadtime:0.88108611106873 / seconds
Query Executed:select id FROM `nc` where city='Lincolnton' && SIC_code='7219'DB:business_master_new
loadtime:0.88395595550537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:0.88403105735779 / seconds
Query Executed:select id FROM `nc` where city='Linden' && SIC_code='7219'DB:business_master_new
loadtime:0.88688993453979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:0.88694596290588 / seconds
Query Executed:select id FROM `nc` where city='Linville' && SIC_code='7219'DB:business_master_new
loadtime:0.8898401260376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville Falls' limit 1
loadtime:0.88990211486816 / seconds
Query Executed:select id FROM `nc` where city='Linville Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.89057111740112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:0.89062714576721 / seconds
Query Executed:select id FROM `nc` where city='Linwood' && SIC_code='7219'DB:business_master_new
loadtime:0.8935170173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzerland' limit 1
loadtime:0.89356994628906 / seconds
Query Executed:select id FROM `nc` where city='Little Switzerland' && SIC_code='7219'DB:business_master_new
loadtime:0.89434599876404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzrlnd' limit 1
loadtime:0.89441013336182 / seconds
Query Executed:select id FROM `nc` where city='Little Switzrlnd' && SIC_code='7219'DB:business_master_new
loadtime:0.89475607872009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.89480900764465 / seconds
Query Executed:select id FROM `nc` where city='Littleton' && SIC_code='7219'DB:business_master_new
loadtime:0.89771008491516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust' limit 1
loadtime:0.89776706695557 / seconds
Query Executed:select id FROM `nc` where city='Locust' && SIC_code='7219'DB:business_master_new
loadtime:0.90065097808838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longwood' limit 1
loadtime:0.90071702003479 / seconds
Query Executed:select id FROM `nc` where city='Longwood' && SIC_code='7219'DB:business_master_new
loadtime:0.90146613121033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisburg' limit 1
loadtime:0.90152812004089 / seconds
Query Executed:select id FROM `nc` where city='Louisburg' && SIC_code='7219'DB:business_master_new
loadtime:0.90439510345459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:0.904452085495 / seconds
Query Executed:select id FROM `nc` where city='Lowell' && SIC_code='7219'DB:business_master_new
loadtime:0.907310962677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowgap' limit 1
loadtime:0.90736508369446 / seconds
Query Executed:select id FROM `nc` where city='Lowgap' && SIC_code='7219'DB:business_master_new
loadtime:0.90867114067078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowland' limit 1
loadtime:0.90873503684998 / seconds
Query Executed:select id FROM `nc` where city='Lowland' && SIC_code='7219'DB:business_master_new
loadtime:0.90923404693604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucama' limit 1
loadtime:0.90929198265076 / seconds
Query Executed:select id FROM `nc` where city='Lucama' && SIC_code='7219'DB:business_master_new
loadtime:0.9121880531311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumber Bridge' limit 1
loadtime:0.91224908828735 / seconds
Query Executed:select id FROM `nc` where city='Lumber Bridge' && SIC_code='7219'DB:business_master_new
loadtime:0.9134521484375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:0.91350507736206 / seconds
Query Executed:select id FROM `nc` where city='Lumberton' && SIC_code='7219'DB:business_master_new
loadtime:0.91639614105225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:0.91646909713745 / seconds
Query Executed:select id FROM `nc` where city='Lynn' && SIC_code='7219'DB:business_master_new
loadtime:0.91721606254578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macclesfield' limit 1
loadtime:0.91727805137634 / seconds
Query Executed:select id FROM `nc` where city='Macclesfield' && SIC_code='7219'DB:business_master_new
loadtime:0.91881203651428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:0.91886806488037 / seconds
Query Executed:select id FROM `nc` where city='Macon' && SIC_code='7219'DB:business_master_new
loadtime:0.91973304748535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.91978597640991 / seconds
Query Executed:select id FROM `nc` where city='Madison' && SIC_code='7219'DB:business_master_new
loadtime:0.9226610660553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maggie Valley' limit 1
loadtime:0.92272210121155 / seconds
Query Executed:select id FROM `nc` where city='Maggie Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.92559909820557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:0.92565107345581 / seconds
Query Executed:select id FROM `nc` where city='Magnolia' && SIC_code='7219'DB:business_master_new
loadtime:0.92748093605042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maiden' limit 1
loadtime:0.92753601074219 / seconds
Query Executed:select id FROM `nc` where city='Maiden' && SIC_code='7219'DB:business_master_new
loadtime:0.93039894104004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mamers' limit 1
loadtime:0.93047308921814 / seconds
Query Executed:select id FROM `nc` where city='Mamers' && SIC_code='7219'DB:business_master_new
loadtime:0.93102502822876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manns Harbor' limit 1
loadtime:0.93107914924622 / seconds
Query Executed:select id FROM `nc` where city='Manns Harbor' && SIC_code='7219'DB:business_master_new
loadtime:0.93209314346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:0.93214893341064 / seconds
Query Executed:select id FROM `nc` where city='Manson' && SIC_code='7219'DB:business_master_new
loadtime:0.93314814567566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manteo' limit 1
loadtime:0.93320512771606 / seconds
Query Executed:select id FROM `nc` where city='Manteo' && SIC_code='7219'DB:business_master_new
loadtime:0.93607711791992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple' limit 1
loadtime:0.93613696098328 / seconds
Query Executed:select id FROM `nc` where city='Maple' && SIC_code='7219'DB:business_master_new
loadtime:0.93674492835999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Hill' limit 1
loadtime:0.93679904937744 / seconds
Query Executed:select id FROM `nc` where city='Maple Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.93802809715271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble' limit 1
loadtime:0.93808507919312 / seconds
Query Executed:select id FROM `nc` where city='Marble' && SIC_code='7219'DB:business_master_new
loadtime:0.93939805030823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margarettsville' limit 1
loadtime:0.93945598602295 / seconds
Query Executed:select id FROM `nc` where city='Margarettsville' && SIC_code='7219'DB:business_master_new
loadtime:0.93997812271118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:0.94003510475159 / seconds
Query Executed:select id FROM `nc` where city='Marietta' && SIC_code='7219'DB:business_master_new
loadtime:0.94053602218628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.94059205055237 / seconds
Query Executed:select id FROM `nc` where city='Marion' && SIC_code='7219'DB:business_master_new
loadtime:0.9434769153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mars Hill' limit 1
loadtime:0.94353008270264 / seconds
Query Executed:select id FROM `nc` where city='Mars Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.94642114639282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:0.94648003578186 / seconds
Query Executed:select id FROM `nc` where city='Marshall' && SIC_code='7219'DB:business_master_new
loadtime:0.94938707351685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshallberg' limit 1
loadtime:0.94944596290588 / seconds
Query Executed:select id FROM `nc` where city='Marshallberg' && SIC_code='7219'DB:business_master_new
loadtime:0.95024108886719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshville' limit 1
loadtime:0.95029497146606 / seconds
Query Executed:select id FROM `nc` where city='Marshville' && SIC_code='7219'DB:business_master_new
loadtime:0.95319414138794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marston' limit 1
loadtime:0.95325398445129 / seconds
Query Executed:select id FROM `nc` where city='Marston' && SIC_code='7219'DB:business_master_new
loadtime:0.95411896705627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matthews' limit 1
loadtime:0.95417714118958 / seconds
Query Executed:select id FROM `nc` where city='Matthews' && SIC_code='7219'DB:business_master_new
loadtime:0.95707893371582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maury' limit 1
loadtime:0.95715308189392 / seconds
Query Executed:select id FROM `nc` where city='Maury' && SIC_code='7219'DB:business_master_new
loadtime:0.95789098739624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxton' limit 1
loadtime:0.95795011520386 / seconds
Query Executed:select id FROM `nc` where city='Maxton' && SIC_code='7219'DB:business_master_new
loadtime:0.96083092689514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayodan' limit 1
loadtime:0.96088910102844 / seconds
Query Executed:select id FROM `nc` where city='Mayodan' && SIC_code='7219'DB:business_master_new
loadtime:0.96342206001282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maysville' limit 1
loadtime:0.96349310874939 / seconds
Query Executed:select id FROM `nc` where city='Maysville' && SIC_code='7219'DB:business_master_new
loadtime:0.96640110015869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adenville' limit 1
loadtime:0.96645498275757 / seconds
Query Executed:select id FROM `nc` where city='Mc Adenville' && SIC_code='7219'DB:business_master_new
loadtime:0.96743106842041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farlan' limit 1
loadtime:0.96748995780945 / seconds
Query Executed:select id FROM `nc` where city='Mc Farlan' && SIC_code='7219'DB:business_master_new
loadtime:0.96798896789551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Grady' limit 1
loadtime:0.96804094314575 / seconds
Query Executed:select id FROM `nc` where city='Mc Grady' && SIC_code='7219'DB:business_master_new
loadtime:0.96872591972351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Leansville' limit 1
loadtime:0.96878004074097 / seconds
Query Executed:select id FROM `nc` where city='Mc Leansville' && SIC_code='7219'DB:business_master_new
loadtime:0.97168111801147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccain' limit 1
loadtime:0.97175312042236 / seconds
Query Executed:select id FROM `nc` where city='Mccain' && SIC_code='7219'DB:business_master_new
loadtime:0.97216391563416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccutcheon Field' limit 1
loadtime:0.97222304344177 / seconds
Query Executed:select id FROM `nc` where city='Mccutcheon Field' && SIC_code='7219'DB:business_master_new
loadtime:0.9726779460907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mebane' limit 1
loadtime:0.97273993492126 / seconds
Query Executed:select id FROM `nc` where city='Mebane' && SIC_code='7219'DB:business_master_new
loadtime:0.97561311721802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:0.9756760597229 / seconds
Query Executed:select id FROM `nc` where city='Merritt' && SIC_code='7219'DB:business_master_new
loadtime:0.97631812095642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Hill' limit 1
loadtime:0.97637891769409 / seconds
Query Executed:select id FROM `nc` where city='Merry Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.97742795944214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micaville' limit 1
loadtime:0.97748112678528 / seconds
Query Executed:select id FROM `nc` where city='Micaville' && SIC_code='7219'DB:business_master_new
loadtime:0.97830414772034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micro' limit 1
loadtime:0.97836303710938 / seconds
Query Executed:select id FROM `nc` where city='Micro' && SIC_code='7219'DB:business_master_new
loadtime:0.97916197776794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:0.97921514511108 / seconds
Query Executed:select id FROM `nc` where city='Middleburg' && SIC_code='7219'DB:business_master_new
loadtime:0.97990393638611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlesex' limit 1
loadtime:0.97995710372925 / seconds
Query Executed:select id FROM `nc` where city='Middlesex' && SIC_code='7219'DB:business_master_new
loadtime:0.98273205757141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.98278713226318 / seconds
Query Executed:select id FROM `nc` where city='Midland' && SIC_code='7219'DB:business_master_new
loadtime:0.98568391799927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway Park' limit 1
loadtime:0.98574495315552 / seconds
Query Executed:select id FROM `nc` where city='Midway Park' && SIC_code='7219'DB:business_master_new
loadtime:0.98745703697205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill Spring' limit 1
loadtime:0.98751711845398 / seconds
Query Executed:select id FROM `nc` where city='Mill Spring' && SIC_code='7219'DB:business_master_new
loadtime:0.99039912223816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Creek' limit 1
loadtime:0.99046897888184 / seconds
Query Executed:select id FROM `nc` where city='Millers Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.99336504936218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills River' limit 1
loadtime:0.99343514442444 / seconds
Query Executed:select id FROM `nc` where city='Mills River' && SIC_code='7219'DB:business_master_new
loadtime:0.99390506744385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.99397802352905 / seconds
Query Executed:select id FROM `nc` where city='Milton' && SIC_code='7219'DB:business_master_new
loadtime:0.99484705924988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukee' limit 1
loadtime:0.99492001533508 / seconds
Query Executed:select id FROM `nc` where city='Milwaukee' && SIC_code='7219'DB:business_master_new
loadtime:0.99528193473816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Springs' limit 1
loadtime:0.99535202980042 / seconds
Query Executed:select id FROM `nc` where city='Mineral Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.99620199203491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minneapolis' limit 1
loadtime:0.99627208709717 / seconds
Query Executed:select id FROM `nc` where city='Minneapolis' && SIC_code='7219'DB:business_master_new
loadtime:0.99677491188049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Hill' limit 1
loadtime:0.99684000015259 / seconds
Query Executed:select id FROM `nc` where city='Mint Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.99728107452393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Misenheimer' limit 1
loadtime:0.99735307693481 / seconds
Query Executed:select id FROM `nc` where city='Misenheimer' && SIC_code='7219'DB:business_master_new
loadtime:0.99790000915527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mocksville' limit 1
loadtime:0.99797010421753 / seconds
Query Executed:select id FROM `nc` where city='Mocksville' && SIC_code='7219'DB:business_master_new
loadtime:1.0008659362793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncure' limit 1
loadtime:1.0009429454803 / seconds
Query Executed:select id FROM `nc` where city='Moncure' && SIC_code='7219'DB:business_master_new
loadtime:1.0026030540466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.0026760101318 / seconds
Query Executed:select id FROM `nc` where city='Monroe' && SIC_code='7219'DB:business_master_new
loadtime:1.005558013916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:1.0056600570679 / seconds
Query Executed:select id FROM `nc` where city='Montezuma' && SIC_code='7219'DB:business_master_new
loadtime:1.0060999393463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montreat' limit 1
loadtime:1.0061681270599 / seconds
Query Executed:select id FROM `nc` where city='Montreat' && SIC_code='7219'DB:business_master_new
loadtime:1.00705909729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresboro' limit 1
loadtime:1.0071361064911 / seconds
Query Executed:select id FROM `nc` where city='Mooresboro' && SIC_code='7219'DB:business_master_new
loadtime:1.0100250244141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresville' limit 1
loadtime:1.0100960731506 / seconds
Query Executed:select id FROM `nc` where city='Mooresville' && SIC_code='7219'DB:business_master_new
loadtime:1.0130019187927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravian Falls' limit 1
loadtime:1.0130989551544 / seconds
Query Executed:select id FROM `nc` where city='Moravian Falls' && SIC_code='7219'DB:business_master_new
loadtime:1.0148711204529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morehead City' limit 1
loadtime:1.0149400234222 / seconds
Query Executed:select id FROM `nc` where city='Morehead City' && SIC_code='7219'DB:business_master_new
loadtime:1.0178599357605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganton' limit 1
loadtime:1.0179479122162 / seconds
Query Executed:select id FROM `nc` where city='Morganton' && SIC_code='7219'DB:business_master_new
loadtime:1.0208530426025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:1.020947933197 / seconds
Query Executed:select id FROM `nc` where city='Morrisville' && SIC_code='7219'DB:business_master_new
loadtime:1.0238239765167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morven' limit 1
loadtime:1.0239160060883 / seconds
Query Executed:select id FROM `nc` where city='Morven' && SIC_code='7219'DB:business_master_new
loadtime:1.0267930030823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Airy' limit 1
loadtime:1.0268650054932 / seconds
Query Executed:select id FROM `nc` where city='Mount Airy' && SIC_code='7219'DB:business_master_new
loadtime:1.0297420024872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Gilead' limit 1
loadtime:1.0298271179199 / seconds
Query Executed:select id FROM `nc` where city='Mount Gilead' && SIC_code='7219'DB:business_master_new
loadtime:1.0327310562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:1.0328221321106 / seconds
Query Executed:select id FROM `nc` where city='Mount Holly' && SIC_code='7219'DB:business_master_new
loadtime:1.0357220172882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Mourne' limit 1
loadtime:1.0358009338379 / seconds
Query Executed:select id FROM `nc` where city='Mount Mourne' && SIC_code='7219'DB:business_master_new
loadtime:1.036514043808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:1.036591053009 / seconds
Query Executed:select id FROM `nc` where city='Mount Olive' && SIC_code='7219'DB:business_master_new
loadtime:1.0394730567932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:1.0395429134369 / seconds
Query Executed:select id FROM `nc` where city='Mount Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:1.0424239635468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ulla' limit 1
loadtime:1.0424981117249 / seconds
Query Executed:select id FROM `nc` where city='Mount Ulla' && SIC_code='7219'DB:business_master_new
loadtime:1.045371055603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:1.0454440116882 / seconds
Query Executed:select id FROM `nc` where city='Mountain Home' && SIC_code='7219'DB:business_master_new
loadtime:1.0464551448822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moyock' limit 1
loadtime:1.0465271472931 / seconds
Query Executed:select id FROM `nc` where city='Moyock' && SIC_code='7219'DB:business_master_new
loadtime:1.0494151115417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Airy' limit 1
loadtime:1.0495059490204 / seconds
Query Executed:select id FROM `nc` where city='Mt Airy' && SIC_code='7219'DB:business_master_new
loadtime:1.0502009391785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Gilead' limit 1
loadtime:1.0502691268921 / seconds
Query Executed:select id FROM `nc` where city='Mt Gilead' && SIC_code='7219'DB:business_master_new
loadtime:1.0507011413574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:1.0507829189301 / seconds
Query Executed:select id FROM `nc` where city='Mt Holly' && SIC_code='7219'DB:business_master_new
loadtime:1.051726102829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Mourne' limit 1
loadtime:1.0518009662628 / seconds
Query Executed:select id FROM `nc` where city='Mt Mourne' && SIC_code='7219'DB:business_master_new
loadtime:1.0522220134735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:1.0522940158844 / seconds
Query Executed:select id FROM `nc` where city='Mt Olive' && SIC_code='7219'DB:business_master_new
loadtime:1.0528099536896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:1.0528750419617 / seconds
Query Executed:select id FROM `nc` where city='Mt Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:1.0535559654236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ulla' limit 1
loadtime:1.053619146347 / seconds
Query Executed:select id FROM `nc` where city='Mt Ulla' && SIC_code='7219'DB:business_master_new
loadtime:1.0540030002594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murfreesboro' limit 1
loadtime:1.0540680885315 / seconds
Query Executed:select id FROM `nc` where city='Murfreesboro' && SIC_code='7219'DB:business_master_new
loadtime:1.0569529533386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murphy' limit 1
loadtime:1.0570240020752 / seconds
Query Executed:select id FROM `nc` where city='Murphy' && SIC_code='7219'DB:business_master_new
loadtime:1.0599150657654 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Topsail Beach' limit 1
loadtime:1.059986114502 / seconds
Query Executed:select id FROM `nc` where city='N Topsail Beach' && SIC_code='7219'DB:business_master_new
loadtime:1.0603959560394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nags Head' limit 1
loadtime:1.0604600906372 / seconds
Query Executed:select id FROM `nc` where city='Nags Head' && SIC_code='7219'DB:business_master_new
loadtime:1.0633759498596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nakina' limit 1
loadtime:1.063453912735 / seconds
Query Executed:select id FROM `nc` where city='Nakina' && SIC_code='7219'DB:business_master_new
loadtime:1.0644929409027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naples' limit 1
loadtime:1.064563035965 / seconds
Query Executed:select id FROM `nc` where city='Naples' && SIC_code='7219'DB:business_master_new
loadtime:1.0654480457306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:1.0655131340027 / seconds
Query Executed:select id FROM `nc` where city='Nashville' && SIC_code='7219'DB:business_master_new
loadtime:1.068421125412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navassa' limit 1
loadtime:1.0684869289398 / seconds
Query Executed:select id FROM `nc` where city='Navassa' && SIC_code='7219'DB:business_master_new
loadtime:1.0689549446106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nebo' limit 1
loadtime:1.069020986557 / seconds
Query Executed:select id FROM `nc` where city='Nebo' && SIC_code='7219'DB:business_master_new
loadtime:1.0719249248505 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bern' limit 1
loadtime:1.0720009803772 / seconds
Query Executed:select id FROM `nc` where city='New Bern' && SIC_code='7219'DB:business_master_new
loadtime:1.0748910903931 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hill' limit 1
loadtime:1.0749781131744 / seconds
Query Executed:select id FROM `nc` where city='New Hill' && SIC_code='7219'DB:business_master_new
loadtime:1.0764410495758 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.0765089988708 / seconds
Query Executed:select id FROM `nc` where city='New London' && SIC_code='7219'DB:business_master_new
loadtime:1.0793399810791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:1.0794100761414 / seconds
Query Executed:select id FROM `nc` where city='Newell' && SIC_code='7219'DB:business_master_new
loadtime:1.0803239345551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newland' limit 1
loadtime:1.0803949832916 / seconds
Query Executed:select id FROM `nc` where city='Newland' && SIC_code='7219'DB:business_master_new
loadtime:1.0832829475403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.0833561420441 / seconds
Query Executed:select id FROM `nc` where city='Newport' && SIC_code='7219'DB:business_master_new
loadtime:1.086256980896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.0863449573517 / seconds
Query Executed:select id FROM `nc` where city='Newton' && SIC_code='7219'DB:business_master_new
loadtime:1.0892701148987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Grove' limit 1
loadtime:1.0893421173096 / seconds
Query Executed:select id FROM `nc` where city='Newton Grove' && SIC_code='7219'DB:business_master_new
loadtime:1.0922629833221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norlina' limit 1
loadtime:1.0923380851746 / seconds
Query Executed:select id FROM `nc` where city='Norlina' && SIC_code='7219'DB:business_master_new
loadtime:1.0945029258728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norman' limit 1
loadtime:1.0945761203766 / seconds
Query Executed:select id FROM `nc` where city='Norman' && SIC_code='7219'DB:business_master_new
loadtime:1.0951581001282 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Wilkesboro' limit 1
loadtime:1.0952279567719 / seconds
Query Executed:select id FROM `nc` where city='North Wilkesboro' && SIC_code='7219'DB:business_master_new
loadtime:1.0981569290161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:1.0982360839844 / seconds
Query Executed:select id FROM `nc` where city='Norwood' && SIC_code='7219'DB:business_master_new
loadtime:1.1011710166931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:1.101243019104 / seconds
Query Executed:select id FROM `nc` where city='Oak City' && SIC_code='7219'DB:business_master_new
loadtime:1.1023850440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Island' limit 1
loadtime:1.1024439334869 / seconds
Query Executed:select id FROM `nc` where city='Oak Island' && SIC_code='7219'DB:business_master_new
loadtime:1.1053431034088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Ridge' limit 1
loadtime:1.1054000854492 / seconds
Query Executed:select id FROM `nc` where city='Oak Ridge' && SIC_code='7219'DB:business_master_new
loadtime:1.1083121299744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakboro' limit 1
loadtime:1.1083869934082 / seconds
Query Executed:select id FROM `nc` where city='Oakboro' && SIC_code='7219'DB:business_master_new
loadtime:1.1113309860229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Isle Beach' limit 1
loadtime:1.1114070415497 / seconds
Query Executed:select id FROM `nc` where city='Ocean Isle Beach' && SIC_code='7219'DB:business_master_new
loadtime:1.1143550872803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocracoke' limit 1
loadtime:1.1144139766693 / seconds
Query Executed:select id FROM `nc` where city='Ocracoke' && SIC_code='7219'DB:business_master_new
loadtime:1.1171929836273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Fort' limit 1
loadtime:1.1172459125519 / seconds
Query Executed:select id FROM `nc` where city='Old Fort' && SIC_code='7219'DB:business_master_new
loadtime:1.1201629638672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:1.1202199459076 / seconds
Query Executed:select id FROM `nc` where city='Olin' && SIC_code='7219'DB:business_master_new
loadtime:1.1212041378021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivia' limit 1
loadtime:1.1212611198425 / seconds
Query Executed:select id FROM `nc` where city='Olivia' && SIC_code='7219'DB:business_master_new
loadtime:1.1222839355469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriental' limit 1
loadtime:1.1223449707031 / seconds
Query Executed:select id FROM `nc` where city='Oriental' && SIC_code='7219'DB:business_master_new
loadtime:1.1245589256287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orrum' limit 1
loadtime:1.1246161460876 / seconds
Query Executed:select id FROM `nc` where city='Orrum' && SIC_code='7219'DB:business_master_new
loadtime:1.1255950927734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otto' limit 1
loadtime:1.1256539821625 / seconds
Query Executed:select id FROM `nc` where city='Otto' && SIC_code='7219'DB:business_master_new
loadtime:1.1269021034241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.1269540786743 / seconds
Query Executed:select id FROM `nc` where city='Oxford' && SIC_code='7219'DB:business_master_new
loadtime:1.1298670768738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pantego' limit 1
loadtime:1.1299340724945 / seconds
Query Executed:select id FROM `nc` where city='Pantego' && SIC_code='7219'DB:business_master_new
loadtime:1.1322529315948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkton' limit 1
loadtime:1.1323180198669 / seconds
Query Executed:select id FROM `nc` where city='Parkton' && SIC_code='7219'DB:business_master_new
loadtime:1.1342499256134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmele' limit 1
loadtime:1.1343030929565 / seconds
Query Executed:select id FROM `nc` where city='Parmele' && SIC_code='7219'DB:business_master_new
loadtime:1.1347720623016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:1.134829044342 / seconds
Query Executed:select id FROM `nc` where city='Patterson' && SIC_code='7219'DB:business_master_new
loadtime:1.1354849338531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Creek' limit 1
loadtime:1.1355490684509 / seconds
Query Executed:select id FROM `nc` where city='Paw Creek' && SIC_code='7219'DB:business_master_new
loadtime:1.1366620063782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peachland' limit 1
loadtime:1.1367149353027 / seconds
Query Executed:select id FROM `nc` where city='Peachland' && SIC_code='7219'DB:business_master_new
loadtime:1.1384570598602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.1385140419006 / seconds
Query Executed:select id FROM `nc` where city='Pelham' && SIC_code='7219'DB:business_master_new
loadtime:1.1398351192474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.139899969101 / seconds
Query Executed:select id FROM `nc` where city='Pembroke' && SIC_code='7219'DB:business_master_new
loadtime:1.1428070068359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:1.1428699493408 / seconds
Query Executed:select id FROM `nc` where city='Pendleton' && SIC_code='7219'DB:business_master_new
loadtime:1.1435461044312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penland' limit 1
loadtime:1.1436071395874 / seconds
Query Executed:select id FROM `nc` where city='Penland' && SIC_code='7219'DB:business_master_new
loadtime:1.1441659927368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penrose' limit 1
loadtime:1.1442260742188 / seconds
Query Executed:select id FROM `nc` where city='Penrose' && SIC_code='7219'DB:business_master_new
loadtime:1.1451730728149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pfafftown' limit 1
loadtime:1.1452260017395 / seconds
Query Executed:select id FROM `nc` where city='Pfafftown' && SIC_code='7219'DB:business_master_new
loadtime:1.1481099128723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pikeville' limit 1
loadtime:1.1481671333313 / seconds
Query Executed:select id FROM `nc` where city='Pikeville' && SIC_code='7219'DB:business_master_new
loadtime:1.1510560512543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mountain' limit 1
loadtime:1.1511170864105 / seconds
Query Executed:select id FROM `nc` where city='Pilot Mountain' && SIC_code='7219'DB:business_master_new
loadtime:1.15403008461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hall' limit 1
loadtime:1.1540880203247 / seconds
Query Executed:select id FROM `nc` where city='Pine Hall' && SIC_code='7219'DB:business_master_new
loadtime:1.1547629833221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Knoll Shrs' limit 1
loadtime:1.1548159122467 / seconds
Query Executed:select id FROM `nc` where city='Pine Knoll Shrs' && SIC_code='7219'DB:business_master_new
loadtime:1.1552360057831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Level' limit 1
loadtime:1.1553001403809 / seconds
Query Executed:select id FROM `nc` where city='Pine Level' && SIC_code='7219'DB:business_master_new
loadtime:1.1566319465637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinebluff' limit 1
loadtime:1.156702041626 / seconds
Query Executed:select id FROM `nc` where city='Pinebluff' && SIC_code='7219'DB:business_master_new
loadtime:1.1580851078033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:1.1581461429596 / seconds
Query Executed:select id FROM `nc` where city='Pinehurst' && SIC_code='7219'DB:business_master_new
loadtime:1.161071062088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineola' limit 1
loadtime:1.1611311435699 / seconds
Query Executed:select id FROM `nc` where city='Pineola' && SIC_code='7219'DB:business_master_new
loadtime:1.1619789600372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetops' limit 1
loadtime:1.1620409488678 / seconds
Query Executed:select id FROM `nc` where city='Pinetops' && SIC_code='7219'DB:business_master_new
loadtime:1.1649610996246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetown' limit 1
loadtime:1.1650221347809 / seconds
Query Executed:select id FROM `nc` where city='Pinetown' && SIC_code='7219'DB:business_master_new
loadtime:1.166561126709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:1.1666219234467 / seconds
Query Executed:select id FROM `nc` where city='Pineville' && SIC_code='7219'DB:business_master_new
loadtime:1.1695289611816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Creek' limit 1
loadtime:1.1696040630341 / seconds
Query Executed:select id FROM `nc` where city='Piney Creek' && SIC_code='7219'DB:business_master_new
loadtime:1.1704061031342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pink Hill' limit 1
loadtime:1.170459985733 / seconds
Query Executed:select id FROM `nc` where city='Pink Hill' && SIC_code='7219'DB:business_master_new
loadtime:1.1733400821686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinnacle' limit 1
loadtime:1.1733999252319 / seconds
Query Executed:select id FROM `nc` where city='Pinnacle' && SIC_code='7219'DB:business_master_new
loadtime:1.1758379936218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah Forest' limit 1
loadtime:1.1759021282196 / seconds
Query Executed:select id FROM `nc` where city='Pisgah Forest' && SIC_code='7219'DB:business_master_new
loadtime:1.1788001060486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:1.1788759231567 / seconds
Query Executed:select id FROM `nc` where city='Pittsboro' && SIC_code='7219'DB:business_master_new
loadtime:1.1817979812622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Garden' limit 1
loadtime:1.18186211586 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Garden' && SIC_code='7219'DB:business_master_new
loadtime:1.1847500801086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:1.1848089694977 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Hill' && SIC_code='7219'DB:business_master_new
loadtime:1.1854169368744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plumtree' limit 1
loadtime:1.1854710578918 / seconds
Query Executed:select id FROM `nc` where city='Plumtree' && SIC_code='7219'DB:business_master_new
loadtime:1.1860899925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.1861491203308 / seconds
Query Executed:select id FROM `nc` where city='Plymouth' && SIC_code='7219'DB:business_master_new
loadtime:1.1890580654144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Harbor' limit 1
loadtime:1.1891169548035 / seconds
Query Executed:select id FROM `nc` where city='Point Harbor' && SIC_code='7219'DB:business_master_new
loadtime:1.1906130313873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkton' limit 1
loadtime:1.1906669139862 / seconds
Query Executed:select id FROM `nc` where city='Polkton' && SIC_code='7219'DB:business_master_new
loadtime:1.1927299499512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkville' limit 1
loadtime:1.192852973938 / seconds
Query Executed:select id FROM `nc` where city='Polkville' && SIC_code='7219'DB:business_master_new
loadtime:1.1936819553375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollocksville' limit 1
loadtime:1.193745136261 / seconds
Query Executed:select id FROM `nc` where city='Pollocksville' && SIC_code='7219'DB:business_master_new
loadtime:1.1955120563507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope A F B' limit 1
loadtime:1.1955690383911 / seconds
Query Executed:select id FROM `nc` where city='Pope A F B' && SIC_code='7219'DB:business_master_new
loadtime:1.195986032486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope Afb' limit 1
loadtime:1.1960380077362 / seconds
Query Executed:select id FROM `nc` where city='Pope Afb' && SIC_code='7219'DB:business_master_new
loadtime:1.1965551376343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplar Branch' limit 1
loadtime:1.1966059207916 / seconds
Query Executed:select id FROM `nc` where city='Poplar Branch' && SIC_code='7219'DB:business_master_new
loadtime:1.1975309848785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potecasi' limit 1
loadtime:1.1975820064545 / seconds
Query Executed:select id FROM `nc` where city='Potecasi' && SIC_code='7219'DB:business_master_new
loadtime:1.1980710029602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powells Point' limit 1
loadtime:1.1981279850006 / seconds
Query Executed:select id FROM `nc` where city='Powells Point' && SIC_code='7219'DB:business_master_new
loadtime:1.2001519203186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powellsville' limit 1
loadtime:1.2002060413361 / seconds
Query Executed:select id FROM `nc` where city='Powellsville' && SIC_code='7219'DB:business_master_new
loadtime:1.200788974762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.2008421421051 / seconds
Query Executed:select id FROM `nc` where city='Princeton' && SIC_code='7219'DB:business_master_new
loadtime:1.2037320137024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeville' limit 1
loadtime:1.203794002533 / seconds
Query Executed:select id FROM `nc` where city='Princeville' && SIC_code='7219'DB:business_master_new
loadtime:1.2041821479797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorville' limit 1
loadtime:1.2042350769043 / seconds
Query Executed:select id FROM `nc` where city='Proctorville' && SIC_code='7219'DB:business_master_new
loadtime:1.2047770023346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect Hill' limit 1
loadtime:1.2048380374908 / seconds
Query Executed:select id FROM `nc` where city='Prospect Hill' && SIC_code='7219'DB:business_master_new
loadtime:1.2057249546051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:1.2057819366455 / seconds
Query Executed:select id FROM `nc` where city='Providence' && SIC_code='7219'DB:business_master_new
loadtime:1.206992149353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purlear' limit 1
loadtime:1.207062959671 / seconds
Query Executed:select id FROM `nc` where city='Purlear' && SIC_code='7219'DB:business_master_new
loadtime:1.2082891464233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raeford' limit 1
loadtime:1.2083430290222 / seconds
Query Executed:select id FROM `nc` where city='Raeford' && SIC_code='7219'DB:business_master_new
loadtime:1.2112350463867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:1.2113010883331 / seconds
Query Executed:select id FROM `nc` where city='Raleigh' && SIC_code='7219'DB:business_master_new
loadtime:1.2142050266266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramseur' limit 1
loadtime:1.2143030166626 / seconds
Query Executed:select id FROM `nc` where city='Ramseur' && SIC_code='7219'DB:business_master_new
loadtime:1.2172050476074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randleman' limit 1
loadtime:1.2172679901123 / seconds
Query Executed:select id FROM `nc` where city='Randleman' && SIC_code='7219'DB:business_master_new
loadtime:1.2201640605927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:1.2202279567719 / seconds
Query Executed:select id FROM `nc` where city='Red Oak' && SIC_code='7219'DB:business_master_new
loadtime:1.2210321426392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Springs' limit 1
loadtime:1.2210919857025 / seconds
Query Executed:select id FROM `nc` where city='Red Springs' && SIC_code='7219'DB:business_master_new
loadtime:1.2239811420441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidsville' limit 1
loadtime:1.2240431308746 / seconds
Query Executed:select id FROM `nc` where city='Reidsville' && SIC_code='7219'DB:business_master_new
loadtime:1.2269859313965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Resrch Trngle Pk' limit 1
loadtime:1.2270641326904 / seconds
Query Executed:select id FROM `nc` where city='Resrch Trngle Pk' && SIC_code='7219'DB:business_master_new
loadtime:1.2276039123535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rex' limit 1
loadtime:1.2276599407196 / seconds
Query Executed:select id FROM `nc` where city='Rex' && SIC_code='7219'DB:business_master_new
loadtime:1.2281401157379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodhiss' limit 1
loadtime:1.2281999588013 / seconds
Query Executed:select id FROM `nc` where city='Rhodhiss' && SIC_code='7219'DB:business_master_new
loadtime:1.2287540435791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Square' limit 1
loadtime:1.2288119792938 / seconds
Query Executed:select id FROM `nc` where city='Rich Square' && SIC_code='7219'DB:business_master_new
loadtime:1.2317349910736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:1.2317879199982 / seconds
Query Executed:select id FROM `nc` where city='Richfield' && SIC_code='7219'DB:business_master_new
loadtime:1.2346911430359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:1.2347569465637 / seconds
Query Executed:select id FROM `nc` where city='Richlands' && SIC_code='7219'DB:business_master_new
loadtime:1.2376680374146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgecrest' limit 1
loadtime:1.2377350330353 / seconds
Query Executed:select id FROM `nc` where city='Ridgecrest' && SIC_code='7219'DB:business_master_new
loadtime:1.2383770942688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:1.2384309768677 / seconds
Query Executed:select id FROM `nc` where city='Ridgeway' && SIC_code='7219'DB:business_master_new
loadtime:1.2389180660248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riegelwood' limit 1
loadtime:1.2389769554138 / seconds
Query Executed:select id FROM `nc` where city='Riegelwood' && SIC_code='7219'DB:business_master_new
loadtime:1.2418599128723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke Rapids' limit 1
loadtime:1.2419240474701 / seconds
Query Executed:select id FROM `nc` where city='Roanoke Rapids' && SIC_code='7219'DB:business_master_new
loadtime:1.2448041439056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring Gap' limit 1
loadtime:1.2448661327362 / seconds
Query Executed:select id FROM `nc` where city='Roaring Gap' && SIC_code='7219'DB:business_master_new
loadtime:1.245747089386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring River' limit 1
loadtime:1.2458090782166 / seconds
Query Executed:select id FROM `nc` where city='Roaring River' && SIC_code='7219'DB:business_master_new
loadtime:1.2475490570068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbins' limit 1
loadtime:1.2476010322571 / seconds
Query Executed:select id FROM `nc` where city='Robbins' && SIC_code='7219'DB:business_master_new
loadtime:1.2504920959473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbinsville' limit 1
loadtime:1.2505550384521 / seconds
Query Executed:select id FROM `nc` where city='Robbinsville' && SIC_code='7219'DB:business_master_new
loadtime:1.2534689903259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robersonville' limit 1
loadtime:1.2535269260406 / seconds
Query Executed:select id FROM `nc` where city='Robersonville' && SIC_code='7219'DB:business_master_new
loadtime:1.2564251422882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockingham' limit 1
loadtime:1.2564859390259 / seconds
Query Executed:select id FROM `nc` where city='Rockingham' && SIC_code='7219'DB:business_master_new
loadtime:1.2593801021576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:1.2594399452209 / seconds
Query Executed:select id FROM `nc` where city='Rockwell' && SIC_code='7219'DB:business_master_new
loadtime:1.2623341083527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:1.2623970508575 / seconds
Query Executed:select id FROM `nc` where city='Rocky Mount' && SIC_code='7219'DB:business_master_new
loadtime:1.265300989151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Point' limit 1
loadtime:1.2653751373291 / seconds
Query Executed:select id FROM `nc` where city='Rocky Point' && SIC_code='7219'DB:business_master_new
loadtime:1.2682650089264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodanthe' limit 1
loadtime:1.2683260440826 / seconds
Query Executed:select id FROM `nc` where city='Rodanthe' && SIC_code='7219'DB:business_master_new
loadtime:1.2695989608765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roduco' limit 1
loadtime:1.2696521282196 / seconds
Query Executed:select id FROM `nc` where city='Roduco' && SIC_code='7219'DB:business_master_new
loadtime:1.2701139450073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolesville' limit 1
loadtime:1.2701721191406 / seconds
Query Executed:select id FROM `nc` where city='Rolesville' && SIC_code='7219'DB:business_master_new
loadtime:1.2723889350891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ronda' limit 1
loadtime:1.2724480628967 / seconds
Query Executed:select id FROM `nc` where city='Ronda' && SIC_code='7219'DB:business_master_new
loadtime:1.2742879390717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roper' limit 1
loadtime:1.2743499279022 / seconds
Query Executed:select id FROM `nc` where city='Roper' && SIC_code='7219'DB:business_master_new
loadtime:1.2763390541077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:1.2763929367065 / seconds
Query Executed:select id FROM `nc` where city='Rose Hill' && SIC_code='7219'DB:business_master_new
loadtime:1.2793180942535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseboro' limit 1
loadtime:1.2793750762939 / seconds
Query Executed:select id FROM `nc` where city='Roseboro' && SIC_code='7219'DB:business_master_new
loadtime:1.2822909355164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosman' limit 1
loadtime:1.2823510169983 / seconds
Query Executed:select id FROM `nc` where city='Rosman' && SIC_code='7219'DB:business_master_new
loadtime:1.2839980125427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rougemont' limit 1
loadtime:1.2840571403503 / seconds
Query Executed:select id FROM `nc` where city='Rougemont' && SIC_code='7219'DB:business_master_new
loadtime:1.286728143692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowland' limit 1
loadtime:1.2867920398712 / seconds
Query Executed:select id FROM `nc` where city='Rowland' && SIC_code='7219'DB:business_master_new
loadtime:1.2896730899811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxboro' limit 1
loadtime:1.2897350788116 / seconds
Query Executed:select id FROM `nc` where city='Roxboro' && SIC_code='7219'DB:business_master_new
loadtime:1.2926430702209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxobel' limit 1
loadtime:1.2927250862122 / seconds
Query Executed:select id FROM `nc` where city='Roxobel' && SIC_code='7219'DB:business_master_new
loadtime:1.2934291362762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:1.2934889793396 / seconds
Query Executed:select id FROM `nc` where city='Ruffin' && SIC_code='7219'DB:business_master_new
loadtime:1.2950780391693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Hall' limit 1
loadtime:1.295135974884 / seconds
Query Executed:select id FROM `nc` where city='Rural Hall' && SIC_code='7219'DB:business_master_new
loadtime:1.2980439662933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford Clg' limit 1
loadtime:1.2981021404266 / seconds
Query Executed:select id FROM `nc` where city='Rutherford Clg' && SIC_code='7219'DB:business_master_new
loadtime:1.2985310554504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford College' limit 1
loadtime:1.2985861301422 / seconds
Query Executed:select id FROM `nc` where city='Rutherford College' && SIC_code='7219'DB:business_master_new
loadtime:1.299663066864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherfordton' limit 1
loadtime:1.2997279167175 / seconds
Query Executed:select id FROM `nc` where city='Rutherfordton' && SIC_code='7219'DB:business_master_new
loadtime:1.302638053894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Pauls' limit 1
loadtime:1.3026931285858 / seconds
Query Executed:select id FROM `nc` where city='Saint Pauls' && SIC_code='7219'DB:business_master_new
loadtime:1.3055770397186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salemburg' limit 1
loadtime:1.3056390285492 / seconds
Query Executed:select id FROM `nc` where city='Salemburg' && SIC_code='7219'DB:business_master_new
loadtime:1.3085360527039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:1.3085961341858 / seconds
Query Executed:select id FROM `nc` where city='Salisbury' && SIC_code='7219'DB:business_master_new
loadtime:1.31147813797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salter Path' limit 1
loadtime:1.311558008194 / seconds
Query Executed:select id FROM `nc` where city='Salter Path' && SIC_code='7219'DB:business_master_new
loadtime:1.3144249916077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:1.3144810199738 / seconds
Query Executed:select id FROM `nc` where city='Saluda' && SIC_code='7219'DB:business_master_new
loadtime:1.3173639774323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salvo' limit 1
loadtime:1.3174340724945 / seconds
Query Executed:select id FROM `nc` where city='Salvo' && SIC_code='7219'DB:business_master_new
loadtime:1.3181099891663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Ridge' limit 1
loadtime:1.3181641101837 / seconds
Query Executed:select id FROM `nc` where city='Sandy Ridge' && SIC_code='7219'DB:business_master_new
loadtime:1.3195059299469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:1.3195641040802 / seconds
Query Executed:select id FROM `nc` where city='Sanford' && SIC_code='7219'DB:business_master_new
loadtime:1.3224649429321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapphire' limit 1
loadtime:1.3225440979004 / seconds
Query Executed:select id FROM `nc` where city='Sapphire' && SIC_code='7219'DB:business_master_new
loadtime:1.3239510059357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga' limit 1
loadtime:1.3240129947662 / seconds
Query Executed:select id FROM `nc` where city='Saratoga' && SIC_code='7219'DB:business_master_new
loadtime:1.3245780467987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxapahaw' limit 1
loadtime:1.3246359825134 / seconds
Query Executed:select id FROM `nc` where city='Saxapahaw' && SIC_code='7219'DB:business_master_new
loadtime:1.3252649307251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scaly Mountain' limit 1
loadtime:1.3253231048584 / seconds
Query Executed:select id FROM `nc` where city='Scaly Mountain' && SIC_code='7219'DB:business_master_new
loadtime:1.326208114624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland Neck' limit 1
loadtime:1.3262670040131 / seconds
Query Executed:select id FROM `nc` where city='Scotland Neck' && SIC_code='7219'DB:business_master_new
loadtime:1.3292181491852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:1.3292710781097 / seconds
Query Executed:select id FROM `nc` where city='Scotts' && SIC_code='7219'DB:business_master_new
loadtime:1.3298020362854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:1.3298621177673 / seconds
Query Executed:select id FROM `nc` where city='Scottville' && SIC_code='7219'DB:business_master_new
loadtime:1.330374956131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:1.3304331302643 / seconds
Query Executed:select id FROM `nc` where city='Scranton' && SIC_code='7219'DB:business_master_new
loadtime:1.3310570716858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaboard' limit 1
loadtime:1.3311100006104 / seconds
Query Executed:select id FROM `nc` where city='Seaboard' && SIC_code='7219'DB:business_master_new
loadtime:1.3322939872742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seagrove' limit 1
loadtime:1.3323490619659 / seconds
Query Executed:select id FROM `nc` where city='Seagrove' && SIC_code='7219'DB:business_master_new
loadtime:1.3352370262146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealevel' limit 1
loadtime:1.3352949619293 / seconds
Query Executed:select id FROM `nc` where city='Sealevel' && SIC_code='7219'DB:business_master_new
loadtime:1.3359940052032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedalia' limit 1
loadtime:1.3360469341278 / seconds
Query Executed:select id FROM `nc` where city='Sedalia' && SIC_code='7219'DB:business_master_new
loadtime:1.3365619182587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:1.3366229534149 / seconds
Query Executed:select id FROM `nc` where city='Selma' && SIC_code='7219'DB:business_master_new
loadtime:1.3395299911499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semora' limit 1
loadtime:1.3395879268646 / seconds
Query Executed:select id FROM `nc` where city='Semora' && SIC_code='7219'DB:business_master_new
loadtime:1.340637922287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semr Johnson Afb' limit 1
loadtime:1.3406920433044 / seconds
Query Executed:select id FROM `nc` where city='Semr Johnson Afb' && SIC_code='7219'DB:business_master_new
loadtime:1.3410840034485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Devils' limit 1
loadtime:1.3411459922791 / seconds
Query Executed:select id FROM `nc` where city='Seven Devils' && SIC_code='7219'DB:business_master_new
loadtime:1.3415031433105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Springs' limit 1
loadtime:1.3415560722351 / seconds
Query Executed:select id FROM `nc` where city='Seven Springs' && SIC_code='7219'DB:business_master_new
loadtime:1.344475030899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:1.3445379734039 / seconds
Query Executed:select id FROM `nc` where city='Severn' && SIC_code='7219'DB:business_master_new
loadtime:1.3451581001282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shallotte' limit 1
loadtime:1.3452179431915 / seconds
Query Executed:select id FROM `nc` where city='Shallotte' && SIC_code='7219'DB:business_master_new
loadtime:1.348137140274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:1.3481979370117 / seconds
Query Executed:select id FROM `nc` where city='Shannon' && SIC_code='7219'DB:business_master_new
loadtime:1.3497071266174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:1.3497679233551 / seconds
Query Executed:select id FROM `nc` where city='Sharpsburg' && SIC_code='7219'DB:business_master_new
loadtime:1.3518400192261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawboro' limit 1
loadtime:1.3519339561462 / seconds
Query Executed:select id FROM `nc` where city='Shawboro' && SIC_code='7219'DB:business_master_new
loadtime:1.3529801368713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:1.353068113327 / seconds
Query Executed:select id FROM `nc` where city='Shelby' && SIC_code='7219'DB:business_master_new
loadtime:1.3559799194336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrills Ford' limit 1
loadtime:1.3560590744019 / seconds
Query Executed:select id FROM `nc` where city='Sherrills Ford' && SIC_code='7219'DB:business_master_new
loadtime:1.3586311340332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:1.3586919307709 / seconds
Query Executed:select id FROM `nc` where city='Shiloh' && SIC_code='7219'DB:business_master_new
loadtime:1.3595831394196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siler City' limit 1
loadtime:1.3596639633179 / seconds
Query Executed:select id FROM `nc` where city='Siler City' && SIC_code='7219'DB:business_master_new
loadtime:1.3626029491425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siloam' limit 1
loadtime:1.362713098526 / seconds
Query Executed:select id FROM `nc` where city='Siloam' && SIC_code='7219'DB:business_master_new
loadtime:1.3636860847473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpson' limit 1
loadtime:1.363783121109 / seconds
Query Executed:select id FROM `nc` where city='Simpson' && SIC_code='7219'DB:business_master_new
loadtime:1.3645179271698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sims' limit 1
loadtime:1.3645989894867 / seconds
Query Executed:select id FROM `nc` where city='Sims' && SIC_code='7219'DB:business_master_new
loadtime:1.366152048111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skyland' limit 1
loadtime:1.3662359714508 / seconds
Query Executed:select id FROM `nc` where city='Skyland' && SIC_code='7219'DB:business_master_new
loadtime:1.3679270744324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:1.3680210113525 / seconds
Query Executed:select id FROM `nc` where city='Smithfield' && SIC_code='7219'DB:business_master_new
loadtime:1.3709571361542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:1.3710169792175 / seconds
Query Executed:select id FROM `nc` where city='Smyrna' && SIC_code='7219'DB:business_master_new
loadtime:1.3719239234924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sneads Ferry' limit 1
loadtime:1.3720030784607 / seconds
Query Executed:select id FROM `nc` where city='Sneads Ferry' && SIC_code='7219'DB:business_master_new
loadtime:1.3749461174011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Camp' limit 1
loadtime:1.3750541210175 / seconds
Query Executed:select id FROM `nc` where city='Snow Camp' && SIC_code='7219'DB:business_master_new
loadtime:1.3773670196533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Hill' limit 1
loadtime:1.3774631023407 / seconds
Query Executed:select id FROM `nc` where city='Snow Hill' && SIC_code='7219'DB:business_master_new
loadtime:1.380420923233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sophia' limit 1
loadtime:1.3805050849915 / seconds
Query Executed:select id FROM `nc` where city='Sophia' && SIC_code='7219'DB:business_master_new
loadtime:1.3834381103516 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Brunswick' limit 1
loadtime:1.3835210800171 / seconds
Query Executed:select id FROM `nc` where city='South Brunswick' && SIC_code='7219'DB:business_master_new
loadtime:1.3841710090637 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Mills' limit 1
loadtime:1.3842599391937 / seconds
Query Executed:select id FROM `nc` where city='South Mills' && SIC_code='7219'DB:business_master_new
loadtime:1.3856599330902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Pines' limit 1
loadtime:1.3857309818268 / seconds
Query Executed:select id FROM `nc` where city='Southern Pines' && SIC_code='7219'DB:business_master_new
loadtime:1.3886370658875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Shores' limit 1
loadtime:1.3887560367584 / seconds
Query Executed:select id FROM `nc` where city='Southern Shores' && SIC_code='7219'DB:business_master_new
loadtime:1.3892710208893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southmont' limit 1
loadtime:1.389356136322 / seconds
Query Executed:select id FROM `nc` where city='Southmont' && SIC_code='7219'DB:business_master_new
loadtime:1.3902750015259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:1.3903601169586 / seconds
Query Executed:select id FROM `nc` where city='Southport' && SIC_code='7219'DB:business_master_new
loadtime:1.393324136734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:1.3934090137482 / seconds
Query Executed:select id FROM `nc` where city='Sparta' && SIC_code='7219'DB:business_master_new
loadtime:1.3963611125946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speed' limit 1
loadtime:1.3964650630951 / seconds
Query Executed:select id FROM `nc` where city='Speed' && SIC_code='7219'DB:business_master_new
loadtime:1.3969941139221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:1.3970770835876 / seconds
Query Executed:select id FROM `nc` where city='Spencer' && SIC_code='7219'DB:business_master_new
loadtime:1.4000251293182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spindale' limit 1
loadtime:1.4001131057739 / seconds
Query Executed:select id FROM `nc` where city='Spindale' && SIC_code='7219'DB:business_master_new
loadtime:1.4030339717865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Hope' limit 1
loadtime:1.4031181335449 / seconds
Query Executed:select id FROM `nc` where city='Spring Hope' && SIC_code='7219'DB:business_master_new
loadtime:1.4060211181641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:1.4061059951782 / seconds
Query Executed:select id FROM `nc` where city='Spring Lake' && SIC_code='7219'DB:business_master_new
loadtime:1.4090189933777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce Pine' limit 1
loadtime:1.4091210365295 / seconds
Query Executed:select id FROM `nc` where city='Spruce Pine' && SIC_code='7219'DB:business_master_new
loadtime:1.4120209217072 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Pauls' limit 1
loadtime:1.4121010303497 / seconds
Query Executed:select id FROM `nc` where city='St Pauls' && SIC_code='7219'DB:business_master_new
loadtime:1.4125349521637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacy' limit 1
loadtime:1.4126129150391 / seconds
Query Executed:select id FROM `nc` where city='Stacy' && SIC_code='7219'DB:business_master_new
loadtime:1.4131679534912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staley' limit 1
loadtime:1.4132490158081 / seconds
Query Executed:select id FROM `nc` where city='Staley' && SIC_code='7219'DB:business_master_new
loadtime:1.4161660671234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stallings' limit 1
loadtime:1.4162459373474 / seconds
Query Executed:select id FROM `nc` where city='Stallings' && SIC_code='7219'DB:business_master_new
loadtime:1.4166700839996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:1.4167699813843 / seconds
Query Executed:select id FROM `nc` where city='Stanfield' && SIC_code='7219'DB:business_master_new
loadtime:1.4196610450745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.4197509288788 / seconds
Query Executed:select id FROM `nc` where city='Stanley' && SIC_code='7219'DB:business_master_new
loadtime:1.4226500988007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stantonsburg' limit 1
loadtime:1.4227409362793 / seconds
Query Executed:select id FROM `nc` where city='Stantonsburg' && SIC_code='7219'DB:business_master_new
loadtime:1.4256479740143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:1.4257400035858 / seconds
Query Executed:select id FROM `nc` where city='Star' && SIC_code='7219'DB:business_master_new
loadtime:1.4286329746246 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Road' limit 1
loadtime:1.4287109375 / seconds
Query Executed:select id FROM `nc` where city='State Road' && SIC_code='7219'DB:business_master_new
loadtime:1.4316239356995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Statesville' limit 1
loadtime:1.4317150115967 / seconds
Query Executed:select id FROM `nc` where city='Statesville' && SIC_code='7219'DB:business_master_new
loadtime:1.4346361160278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stedman' limit 1
loadtime:1.4347150325775 / seconds
Query Executed:select id FROM `nc` where city='Stedman' && SIC_code='7219'DB:business_master_new
loadtime:1.4376130104065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stella' limit 1
loadtime:1.4376690387726 / seconds
Query Executed:select id FROM `nc` where city='Stella' && SIC_code='7219'DB:business_master_new
loadtime:1.4384429454803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stem' limit 1
loadtime:1.4384961128235 / seconds
Query Executed:select id FROM `nc` where city='Stem' && SIC_code='7219'DB:business_master_new
loadtime:1.4396140575409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokes' limit 1
loadtime:1.4396669864655 / seconds
Query Executed:select id FROM `nc` where city='Stokes' && SIC_code='7219'DB:business_master_new
loadtime:1.4406630992889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokesdale' limit 1
loadtime:1.4407241344452 / seconds
Query Executed:select id FROM `nc` where city='Stokesdale' && SIC_code='7219'DB:business_master_new
loadtime:1.4437239170074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:1.4437839984894 / seconds
Query Executed:select id FROM `nc` where city='Stoneville' && SIC_code='7219'DB:business_master_new
loadtime:1.4467790126801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:1.4468519687653 / seconds
Query Executed:select id FROM `nc` where city='Stonewall' && SIC_code='7219'DB:business_master_new
loadtime:1.4474229812622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Point' limit 1
loadtime:1.4474761486053 / seconds
Query Executed:select id FROM `nc` where city='Stony Point' && SIC_code='7219'DB:business_master_new
loadtime:1.4504079818726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stovall' limit 1
loadtime:1.4504709243774 / seconds
Query Executed:select id FROM `nc` where city='Stovall' && SIC_code='7219'DB:business_master_new
loadtime:1.4511771202087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stumpy Point' limit 1
loadtime:1.4512379169464 / seconds
Query Executed:select id FROM `nc` where city='Stumpy Point' && SIC_code='7219'DB:business_master_new
loadtime:1.4518051147461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:1.4518580436707 / seconds
Query Executed:select id FROM `nc` where city='Sugar Grove' && SIC_code='7219'DB:business_master_new
loadtime:1.4534060955048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Mountain' limit 1
loadtime:1.4534780979156 / seconds
Query Executed:select id FROM `nc` where city='Sugar Mountain' && SIC_code='7219'DB:business_master_new
loadtime:1.4538519382477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerfield' limit 1
loadtime:1.4539110660553 / seconds
Query Executed:select id FROM `nc` where city='Summerfield' && SIC_code='7219'DB:business_master_new
loadtime:1.4567890167236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunbury' limit 1
loadtime:1.4568419456482 / seconds
Query Executed:select id FROM `nc` where city='Sunbury' && SIC_code='7219'DB:business_master_new
loadtime:1.4582810401917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset Beach' limit 1
loadtime:1.4583449363708 / seconds
Query Executed:select id FROM `nc` where city='Sunset Beach' && SIC_code='7219'DB:business_master_new
loadtime:1.461236000061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:1.4612939357758 / seconds
Query Executed:select id FROM `nc` where city='Supply' && SIC_code='7219'DB:business_master_new
loadtime:1.4641690254211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surf City' limit 1
loadtime:1.4642300605774 / seconds
Query Executed:select id FROM `nc` where city='Surf City' && SIC_code='7219'DB:business_master_new
loadtime:1.4647459983826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swannanoa' limit 1
loadtime:1.4648001194 / seconds
Query Executed:select id FROM `nc` where city='Swannanoa' && SIC_code='7219'DB:business_master_new
loadtime:1.4676530361176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanquarter' limit 1
loadtime:1.4677131175995 / seconds
Query Executed:select id FROM `nc` where city='Swanquarter' && SIC_code='7219'DB:business_master_new
loadtime:1.4705920219421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansboro' limit 1
loadtime:1.4706499576569 / seconds
Query Executed:select id FROM `nc` where city='Swansboro' && SIC_code='7219'DB:business_master_new
loadtime:1.473541021347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swepsonville' limit 1
loadtime:1.4736061096191 / seconds
Query Executed:select id FROM `nc` where city='Swepsonville' && SIC_code='7219'DB:business_master_new
loadtime:1.4743340015411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylva' limit 1
loadtime:1.4743881225586 / seconds
Query Executed:select id FROM `nc` where city='Sylva' && SIC_code='7219'DB:business_master_new
loadtime:1.4772560596466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor City' limit 1
loadtime:1.4773089885712 / seconds
Query Executed:select id FROM `nc` where city='Tabor City' && SIC_code='7219'DB:business_master_new
loadtime:1.48020195961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tapoco' limit 1
loadtime:1.4802551269531 / seconds
Query Executed:select id FROM `nc` where city='Tapoco' && SIC_code='7219'DB:business_master_new
loadtime:1.4806520938873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tar Heel' limit 1
loadtime:1.4807090759277 / seconds
Query Executed:select id FROM `nc` where city='Tar Heel' && SIC_code='7219'DB:business_master_new
loadtime:1.4819369316101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarawa Terrace' limit 1
loadtime:1.4819900989532 / seconds
Query Executed:select id FROM `nc` where city='Tarawa Terrace' && SIC_code='7219'DB:business_master_new
loadtime:1.4824149608612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarboro' limit 1
loadtime:1.4824759960175 / seconds
Query Executed:select id FROM `nc` where city='Tarboro' && SIC_code='7219'DB:business_master_new
loadtime:1.4853730201721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:1.4854490756989 / seconds
Query Executed:select id FROM `nc` where city='Taylorsville' && SIC_code='7219'DB:business_master_new
loadtime:1.4883761405945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teachey' limit 1
loadtime:1.488431930542 / seconds
Query Executed:select id FROM `nc` where city='Teachey' && SIC_code='7219'DB:business_master_new
loadtime:1.4894671440125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terrell' limit 1
loadtime:1.4895250797272 / seconds
Query Executed:select id FROM `nc` where city='Terrell' && SIC_code='7219'DB:business_master_new
loadtime:1.4907650947571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomasville' limit 1
loadtime:1.4908230304718 / seconds
Query Executed:select id FROM `nc` where city='Thomasville' && SIC_code='7219'DB:business_master_new
loadtime:1.4937150478363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurmond' limit 1
loadtime:1.4937961101532 / seconds
Query Executed:select id FROM `nc` where city='Thurmond' && SIC_code='7219'DB:business_master_new
loadtime:1.4945960044861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillery' limit 1
loadtime:1.4946501255035 / seconds
Query Executed:select id FROM `nc` where city='Tillery' && SIC_code='7219'DB:business_master_new
loadtime:1.4952161312103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberlake' limit 1
loadtime:1.495274066925 / seconds
Query Executed:select id FROM `nc` where city='Timberlake' && SIC_code='7219'DB:business_master_new
loadtime:1.49742603302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toast' limit 1
loadtime:1.4974830150604 / seconds
Query Executed:select id FROM `nc` where city='Toast' && SIC_code='7219'DB:business_master_new
loadtime:1.4981350898743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tobaccoville' limit 1
loadtime:1.4981920719147 / seconds
Query Executed:select id FROM `nc` where city='Tobaccoville' && SIC_code='7219'DB:business_master_new
loadtime:1.4995319843292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Todd' limit 1
loadtime:1.4995911121368 / seconds
Query Executed:select id FROM `nc` where city='Todd' && SIC_code='7219'DB:business_master_new
loadtime:1.5006549358368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsail Beach' limit 1
loadtime:1.5007359981537 / seconds
Query Executed:select id FROM `nc` where city='Topsail Beach' && SIC_code='7219'DB:business_master_new
loadtime:1.5014350414276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topton' limit 1
loadtime:1.5014951229095 / seconds
Query Executed:select id FROM `nc` where city='Topton' && SIC_code='7219'DB:business_master_new
loadtime:1.5023491382599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsville' limit 1
loadtime:1.5024089813232 / seconds
Query Executed:select id FROM `nc` where city='Townsville' && SIC_code='7219'DB:business_master_new
loadtime:1.5030009746552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traphill' limit 1
loadtime:1.5030591487885 / seconds
Query Executed:select id FROM `nc` where city='Traphill' && SIC_code='7219'DB:business_master_new
loadtime:1.5041389465332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent Woods' limit 1
loadtime:1.5041971206665 / seconds
Query Executed:select id FROM `nc` where city='Trent Woods' && SIC_code='7219'DB:business_master_new
loadtime:1.5046329498291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:1.5046849250793 / seconds
Query Executed:select id FROM `nc` where city='Trenton' && SIC_code='7219'DB:business_master_new
loadtime:1.5074200630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinity' limit 1
loadtime:1.5074770450592 / seconds
Query Executed:select id FROM `nc` where city='Trinity' && SIC_code='7219'DB:business_master_new
loadtime:1.5103750228882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutman' limit 1
loadtime:1.5104291439056 / seconds
Query Executed:select id FROM `nc` where city='Troutman' && SIC_code='7219'DB:business_master_new
loadtime:1.5133259296417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.5133781433105 / seconds
Query Executed:select id FROM `nc` where city='Troy' && SIC_code='7219'DB:business_master_new
loadtime:1.5162699222565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tryon' limit 1
loadtime:1.5163280963898 / seconds
Query Executed:select id FROM `nc` where city='Tryon' && SIC_code='7219'DB:business_master_new
loadtime:1.5192189216614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckasegee' limit 1
loadtime:1.5192811489105 / seconds
Query Executed:select id FROM `nc` where city='Tuckasegee' && SIC_code='7219'DB:business_master_new
loadtime:1.5200350284576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turkey' limit 1
loadtime:1.5200879573822 / seconds
Query Executed:select id FROM `nc` where city='Turkey' && SIC_code='7219'DB:business_master_new
loadtime:1.5214259624481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turnersburg' limit 1
loadtime:1.5214829444885 / seconds
Query Executed:select id FROM `nc` where city='Turnersburg' && SIC_code='7219'DB:business_master_new
loadtime:1.5219879150391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuxedo' limit 1
loadtime:1.5220439434052 / seconds
Query Executed:select id FROM `nc` where city='Tuxedo' && SIC_code='7219'DB:business_master_new
loadtime:1.5227630138397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyner' limit 1
loadtime:1.52281498909 / seconds
Query Executed:select id FROM `nc` where city='Tyner' && SIC_code='7219'DB:business_master_new
loadtime:1.5240941047668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:1.5241551399231 / seconds
Query Executed:select id FROM `nc` where city='Union Grove' && SIC_code='7219'DB:business_master_new
loadtime:1.5260479450226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Mills' limit 1
loadtime:1.526104927063 / seconds
Query Executed:select id FROM `nc` where city='Union Mills' && SIC_code='7219'DB:business_master_new
loadtime:1.5272240638733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdese' limit 1
loadtime:1.5272769927979 / seconds
Query Executed:select id FROM `nc` where city='Valdese' && SIC_code='7219'DB:business_master_new
loadtime:1.5301661491394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:1.5302240848541 / seconds
Query Executed:select id FROM `nc` where city='Vale' && SIC_code='7219'DB:business_master_new
loadtime:1.533126115799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valle Crucis' limit 1
loadtime:1.5331799983978 / seconds
Query Executed:select id FROM `nc` where city='Valle Crucis' && SIC_code='7219'DB:business_master_new
loadtime:1.5339879989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanceboro' limit 1
loadtime:1.5340459346771 / seconds
Query Executed:select id FROM `nc` where city='Vanceboro' && SIC_code='7219'DB:business_master_new
loadtime:1.5369229316711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandemere' limit 1
loadtime:1.5369839668274 / seconds
Query Executed:select id FROM `nc` where city='Vandemere' && SIC_code='7219'DB:business_master_new
loadtime:1.537495136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vass' limit 1
loadtime:1.5375530719757 / seconds
Query Executed:select id FROM `nc` where city='Vass' && SIC_code='7219'DB:business_master_new
loadtime:1.5404441356659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:1.5405049324036 / seconds
Query Executed:select id FROM `nc` where city='Vaughan' && SIC_code='7219'DB:business_master_new
loadtime:1.5409970283508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vilas' limit 1
loadtime:1.5410559177399 / seconds
Query Executed:select id FROM `nc` where city='Vilas' && SIC_code='7219'DB:business_master_new
loadtime:1.5439541339874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waco' limit 1
loadtime:1.5440340042114 / seconds
Query Executed:select id FROM `nc` where city='Waco' && SIC_code='7219'DB:business_master_new
loadtime:1.5446131229401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wade' limit 1
loadtime:1.5446689128876 / seconds
Query Executed:select id FROM `nc` where city='Wade' && SIC_code='7219'DB:business_master_new
loadtime:1.5460069179535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadesboro' limit 1
loadtime:1.5460669994354 / seconds
Query Executed:select id FROM `nc` where city='Wadesboro' && SIC_code='7219'DB:business_master_new
loadtime:1.5489580631256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagram' limit 1
loadtime:1.5490250587463 / seconds
Query Executed:select id FROM `nc` where city='Wagram' && SIC_code='7219'DB:business_master_new
loadtime:1.5502860546112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake Forest' limit 1
loadtime:1.5503461360931 / seconds
Query Executed:select id FROM `nc` where city='Wake Forest' && SIC_code='7219'DB:business_master_new
loadtime:1.5532579421997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkertown' limit 1
loadtime:1.5533320903778 / seconds
Query Executed:select id FROM `nc` where city='Walkertown' && SIC_code='7219'DB:business_master_new
loadtime:1.5562300682068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:1.5562999248505 / seconds
Query Executed:select id FROM `nc` where city='Wallace' && SIC_code='7219'DB:business_master_new
loadtime:1.5591819286346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallburg' limit 1
loadtime:1.5592410564423 / seconds
Query Executed:select id FROM `nc` where city='Wallburg' && SIC_code='7219'DB:business_master_new
loadtime:1.5599701404572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Cove' limit 1
loadtime:1.5600280761719 / seconds
Query Executed:select id FROM `nc` where city='Walnut Cove' && SIC_code='7219'DB:business_master_new
loadtime:1.5629179477692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walstonburg' limit 1
loadtime:1.5629720687866 / seconds
Query Executed:select id FROM `nc` where city='Walstonburg' && SIC_code='7219'DB:business_master_new
loadtime:1.5641751289368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanchese' limit 1
loadtime:1.5642330646515 / seconds
Query Executed:select id FROM `nc` where city='Wanchese' && SIC_code='7219'DB:business_master_new
loadtime:1.5671300888062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warne' limit 1
loadtime:1.5671899318695 / seconds
Query Executed:select id FROM `nc` where city='Warne' && SIC_code='7219'DB:business_master_new
loadtime:1.56787109375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrensville' limit 1
loadtime:1.5679340362549 / seconds
Query Executed:select id FROM `nc` where city='Warrensville' && SIC_code='7219'DB:business_master_new
loadtime:1.569039106369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:1.5691120624542 / seconds
Query Executed:select id FROM `nc` where city='Warrenton' && SIC_code='7219'DB:business_master_new
loadtime:1.5719990730286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:1.5720570087433 / seconds
Query Executed:select id FROM `nc` where city='Warsaw' && SIC_code='7219'DB:business_master_new
loadtime:1.5749650001526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.5750200748444 / seconds
Query Executed:select id FROM `nc` where city='Washington' && SIC_code='7219'DB:business_master_new
loadtime:1.5779240131378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watha' limit 1
loadtime:1.5780010223389 / seconds
Query Executed:select id FROM `nc` where city='Watha' && SIC_code='7219'DB:business_master_new
loadtime:1.5783789157867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waves' limit 1
loadtime:1.5784311294556 / seconds
Query Executed:select id FROM `nc` where city='Waves' && SIC_code='7219'DB:business_master_new
loadtime:1.5790839195251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waxhaw' limit 1
loadtime:1.5791411399841 / seconds
Query Executed:select id FROM `nc` where city='Waxhaw' && SIC_code='7219'DB:business_master_new
loadtime:1.5820240974426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesville' limit 1
loadtime:1.5820910930634 / seconds
Query Executed:select id FROM `nc` where city='Waynesville' && SIC_code='7219'DB:business_master_new
loadtime:1.5849931240082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weaverville' limit 1
loadtime:1.5850520133972 / seconds
Query Executed:select id FROM `nc` where city='Weaverville' && SIC_code='7219'DB:business_master_new
loadtime:1.5879609584808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.588042974472 / seconds
Query Executed:select id FROM `nc` where city='Webster' && SIC_code='7219'DB:business_master_new
loadtime:1.5886800289154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weddington' limit 1
loadtime:1.5887460708618 / seconds
Query Executed:select id FROM `nc` where city='Weddington' && SIC_code='7219'DB:business_master_new
loadtime:1.5892560482025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welcome' limit 1
loadtime:1.5893080234528 / seconds
Query Executed:select id FROM `nc` where city='Welcome' && SIC_code='7219'DB:business_master_new
loadtime:1.5922019481659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:1.5922601222992 / seconds
Query Executed:select id FROM `nc` where city='Weldon' && SIC_code='7219'DB:business_master_new
loadtime:1.5951499938965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:1.5952110290527 / seconds
Query Executed:select id FROM `nc` where city='Wendell' && SIC_code='7219'DB:business_master_new
loadtime:1.5980911254883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:1.5981669425964 / seconds
Query Executed:select id FROM `nc` where city='Wentworth' && SIC_code='7219'DB:business_master_new
loadtime:1.5995969772339 / seconds
Query loaded from cache:select * from geodata_geocity where city='West End' limit 1
loadtime:1.5996510982513 / seconds
Query Executed:select id FROM `nc` where city='West End' && SIC_code='7219'DB:business_master_new
loadtime:1.6025681495667 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jefferson' limit 1
loadtime:1.6026220321655 / seconds
Query Executed:select id FROM `nc` where city='West Jefferson' && SIC_code='7219'DB:business_master_new
loadtime:1.6055519580841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:1.605612039566 / seconds
Query Executed:select id FROM `nc` where city='Westfield' && SIC_code='7219'DB:business_master_new
loadtime:1.6072270870209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whispering Pines' limit 1
loadtime:1.6072850227356 / seconds
Query Executed:select id FROM `nc` where city='Whispering Pines' && SIC_code='7219'DB:business_master_new
loadtime:1.6077370643616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitakers' limit 1
loadtime:1.6077950000763 / seconds
Query Executed:select id FROM `nc` where city='Whitakers' && SIC_code='7219'DB:business_master_new
loadtime:1.6101999282837 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Oak' limit 1
loadtime:1.6102521419525 / seconds
Query Executed:select id FROM `nc` where city='White Oak' && SIC_code='7219'DB:business_master_new
loadtime:1.6114060878754 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:1.6114580631256 / seconds
Query Executed:select id FROM `nc` where city='White Plains' && SIC_code='7219'DB:business_master_new
loadtime:1.6119570732117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteville' limit 1
loadtime:1.6120100021362 / seconds
Query Executed:select id FROM `nc` where city='Whiteville' && SIC_code='7219'DB:business_master_new
loadtime:1.614893913269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitsett' limit 1
loadtime:1.6149659156799 / seconds
Query Executed:select id FROM `nc` where city='Whitsett' && SIC_code='7219'DB:business_master_new
loadtime:1.6173169612885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittier' limit 1
loadtime:1.6173779964447 / seconds
Query Executed:select id FROM `nc` where city='Whittier' && SIC_code='7219'DB:business_master_new
loadtime:1.6196920871735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbar' limit 1
loadtime:1.619756937027 / seconds
Query Executed:select id FROM `nc` where city='Wilbar' && SIC_code='7219'DB:business_master_new
loadtime:1.6201601028442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkesboro' limit 1
loadtime:1.6202239990234 / seconds
Query Executed:select id FROM `nc` where city='Wilkesboro' && SIC_code='7219'DB:business_master_new
loadtime:1.6231219768524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:1.6231789588928 / seconds
Query Executed:select id FROM `nc` where city='Willard' && SIC_code='7219'DB:business_master_new
loadtime:1.625137090683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:1.6251909732819 / seconds
Query Executed:select id FROM `nc` where city='Williamston' && SIC_code='7219'DB:business_master_new
loadtime:1.6281070709229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:1.6281659603119 / seconds
Query Executed:select id FROM `nc` where city='Williston' && SIC_code='7219'DB:business_master_new
loadtime:1.6286950111389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Spring' limit 1
loadtime:1.6287610530853 / seconds
Query Executed:select id FROM `nc` where city='Willow Spring' && SIC_code='7219'DB:business_master_new
loadtime:1.6316299438477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:1.631688117981 / seconds
Query Executed:select id FROM `nc` where city='Wilmington' && SIC_code='7219'DB:business_master_new
loadtime:1.6345751285553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:1.6346559524536 / seconds
Query Executed:select id FROM `nc` where city='Wilson' && SIC_code='7219'DB:business_master_new
loadtime:1.6375269889832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons Mills' limit 1
loadtime:1.6375980377197 / seconds
Query Executed:select id FROM `nc` where city='Wilsons Mills' && SIC_code='7219'DB:business_master_new
loadtime:1.6382510662079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.6383049488068 / seconds
Query Executed:select id FROM `nc` where city='Windsor' && SIC_code='7219'DB:business_master_new
loadtime:1.6411831378937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfall' limit 1
loadtime:1.6412410736084 / seconds
Query Executed:select id FROM `nc` where city='Winfall' && SIC_code='7219'DB:business_master_new
loadtime:1.641921043396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingate' limit 1
loadtime:1.6419730186462 / seconds
Query Executed:select id FROM `nc` where city='Wingate' && SIC_code='7219'DB:business_master_new
loadtime:1.6448640823364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnabow' limit 1
loadtime:1.6449279785156 / seconds
Query Executed:select id FROM `nc` where city='Winnabow' && SIC_code='7219'DB:business_master_new
loadtime:1.6463799476624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston Salem' limit 1
loadtime:1.6464509963989 / seconds
Query Executed:select id FROM `nc` where city='Winston Salem' && SIC_code='7219'DB:business_master_new
loadtime:1.6493639945984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:1.6494431495667 / seconds
Query Executed:select id FROM `nc` where city='Winterville' && SIC_code='7219'DB:business_master_new
loadtime:1.6523489952087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winton' limit 1
loadtime:1.6524059772491 / seconds
Query Executed:select id FROM `nc` where city='Winton' && SIC_code='7219'DB:business_master_new
loadtime:1.6542861461639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:1.6543381214142 / seconds
Query Executed:select id FROM `nc` where city='Wise' && SIC_code='7219'DB:business_master_new
loadtime:1.6548140048981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:1.6548709869385 / seconds
Query Executed:select id FROM `nc` where city='Woodland' && SIC_code='7219'DB:business_master_new
loadtime:1.6559059619904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodleaf' limit 1
loadtime:1.6559691429138 / seconds
Query Executed:select id FROM `nc` where city='Woodleaf' && SIC_code='7219'DB:business_master_new
loadtime:1.6573071479797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Bch' limit 1
loadtime:1.6573610305786 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Bch' && SIC_code='7219'DB:business_master_new
loadtime:1.6579101085663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Beach' limit 1
loadtime:1.6579639911652 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Beach' && SIC_code='7219'DB:business_master_new
loadtime:1.6608650684357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yadkinville' limit 1
loadtime:1.6609239578247 / seconds
Query Executed:select id FROM `nc` where city='Yadkinville' && SIC_code='7219'DB:business_master_new
loadtime:1.6638331413269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yanceyville' limit 1
loadtime:1.6638970375061 / seconds
Query Executed:select id FROM `nc` where city='Yanceyville' && SIC_code='7219'DB:business_master_new
loadtime:1.6668019294739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:1.6668751239777 / seconds
Query Executed:select id FROM `nc` where city='Youngsville' && SIC_code='7219'DB:business_master_new
loadtime:1.6698009967804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zebulon' limit 1
loadtime:1.6698610782623 / seconds
Query Executed:select id FROM `nc` where city='Zebulon' && SIC_code='7219'DB:business_master_new
loadtime:1.6727690696716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zionville' limit 1
loadtime:1.6728229522705 / seconds
Query Executed:select id FROM `nc` where city='Zionville' && SIC_code='7219'DB:business_master_new
loadtime:1.6739490032196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zirconia' limit 1
loadtime:1.6740069389343 / seconds
Query Executed:select id FROM `nc` where city='Zirconia' && SIC_code='7219'DB:business_master_new
loadtime:1.6768989562988 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.6770560741425 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.6775760650635 / seconds
Operation template executed (chunk cache operation)
loadtime:1.6777560710907 / seconds
template override:Default
loadtime:1.6777999401093 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.6799099445343 / seconds
Template Constructed, Array Rows:49
loadtime:1.6804420948029 / seconds
TOTAL EXECUTION TIME: 1.68
loadtime:1.6820909976959 / 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] => laundry-and-garment-services-nec [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:1.6821019649506
TOTAL KEY ARRAYS: 69