Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00025415420532227 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0047359466552734 / seconds
host not found setting manual db connection
loadtime:0.014214992523193 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.014487028121948 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.01466703414917 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.014767169952393 / seconds
zipcode:
loadtime:0.014799118041992 / seconds
Query Executed:select * from search_referrer where page_hash='fa4778e27b851a5243ff0e0173ad63d6' limit 10 DB:ezrox_toadli
loadtime:0.015051126480103 / seconds
Operation header executed (non global)
loadtime:0.015085935592651 / seconds
Operation leaderboard executed (non global)
loadtime:0.015176057815552 / seconds
Operation square executed (non global)
loadtime:0.015218019485474 / seconds
Operation square_bottom executed (non global)
loadtime:0.015249013900757 / seconds
Operation smallsquare executed (non global)
loadtime:0.015275001525879 / seconds
Operation headeradright executed (non global)
loadtime:0.015300035476685 / seconds
Operation google_analytics executed (non global)
loadtime:0.01532506942749 / seconds
Operation topstories executed (non global)
loadtime:0.015350103378296 / seconds
Operation businessnearyou executed (non global)
loadtime:0.015380144119263 / seconds
Operation memberbuscount executed (non global)
loadtime:0.015413045883179 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.015638113021851 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.015865087509155 / seconds
Operation categories executed (global stored into APC)
loadtime:0.015913009643555 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.01599907875061 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.016056060791016 / seconds
Template key: archive_menu pushed
loadtime:0.016065120697021 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.016081094741821 / seconds
Template key: get_gravatar pushed
loadtime:0.016107082366943 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.016117095947266 / seconds
*10)-10)+1 | start:0
loadtime:0.016165971755981 / seconds
Query loaded from cache:select * from categories where cat_URLid='carwashes'
loadtime:0.016239166259766 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.016294956207275 / seconds
DB connected to localhost business_master_new
loadtime:0.016613006591797 / seconds
Query Executed:select * from `nc_catmap` where sic='7542' order by city ascDB:business_master_new
loadtime:0.038958072662354 / seconds
Query stored in cache : _QUERY_www.toadli.com09f54dd29721e59aa52b61e4ca2230d4
loadtime:0.042646169662476 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.04275107383728 / seconds
Query Executed:select sum(totalcount) as totalsum from `nc_catmap` where sic='7542'DB:business_master_new
loadtime:0.047024011611938 / seconds
Query stored in cache : _QUERY_www.toadli.com8515e89c7a1857382942d704ba04763a
loadtime:0.047068119049072 / seconds
820 / 11
loadtime:0.047125101089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.047214984893799 / seconds
Query Executed:select id FROM `nc` where city='Aberdeen' && SIC_code='7542'DB:business_master_new
loadtime:0.064684152603149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Advance' limit 1
loadtime:0.064769983291626 / seconds
Query Executed:select id FROM `nc` where city='Advance' && SIC_code='7542'DB:business_master_new
loadtime:0.073655128479004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahoskie' limit 1
loadtime:0.073732137680054 / seconds
Query Executed:select id FROM `nc` where city='Ahoskie' && SIC_code='7542'DB:business_master_new
loadtime:0.084599018096924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamance' limit 1
loadtime:0.08467698097229 / seconds
Query Executed:select id FROM `nc` where city='Alamance' && SIC_code='7542'DB:business_master_new
loadtime:0.085598945617676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albemarle' limit 1
loadtime:0.085662126541138 / seconds
Query Executed:select id FROM `nc` where city='Albemarle' && SIC_code='7542'DB:business_master_new
loadtime:0.10623002052307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albertson' limit 1
loadtime:0.10631108283997 / seconds
Query Executed:select id FROM `nc` where city='Albertson' && SIC_code='7542'DB:business_master_new
loadtime:0.10730814933777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.10737204551697 / seconds
Query Executed:select id FROM `nc` where city='Alexander' && SIC_code='7542'DB:business_master_new
loadtime:0.10866808891296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexis' limit 1
loadtime:0.10873103141785 / seconds
Query Executed:select id FROM `nc` where city='Alexis' && SIC_code='7542'DB:business_master_new
loadtime:0.10966110229492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alliance' limit 1
loadtime:0.10972309112549 / seconds
Query Executed:select id FROM `nc` where city='Alliance' && SIC_code='7542'DB:business_master_new
loadtime:0.11046004295349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almond' limit 1
loadtime:0.11052012443542 / seconds
Query Executed:select id FROM `nc` where city='Almond' && SIC_code='7542'DB:business_master_new
loadtime:0.11113595962524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamahaw' limit 1
loadtime:0.11119699478149 / seconds
Query Executed:select id FROM `nc` where city='Altamahaw' && SIC_code='7542'DB:business_master_new
loadtime:0.1117889881134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.11184811592102 / seconds
Query Executed:select id FROM `nc` where city='Andrews' && SIC_code='7542'DB:business_master_new
loadtime:0.1179211139679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angier' limit 1
loadtime:0.11799597740173 / seconds
Query Executed:select id FROM `nc` where city='Angier' && SIC_code='7542'DB:business_master_new
loadtime:0.1266450881958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonville' limit 1
loadtime:0.12672114372253 / seconds
Query Executed:select id FROM `nc` where city='Ansonville' && SIC_code='7542'DB:business_master_new
loadtime:0.12780904769897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apex' limit 1
loadtime:0.12787508964539 / seconds
Query Executed:select id FROM `nc` where city='Apex' && SIC_code='7542'DB:business_master_new
loadtime:0.14535093307495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.14553093910217 / seconds
Query Executed:select id FROM `nc` where city='Arapahoe' && SIC_code='7542'DB:business_master_new
loadtime:0.14649605751038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.1465539932251 / seconds
Query Executed:select id FROM `nc` where city='Ararat' && SIC_code='7542'DB:business_master_new
loadtime:0.14783596992493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archdale' limit 1
loadtime:0.14789795875549 / seconds
Query Executed:select id FROM `nc` where city='Archdale' && SIC_code='7542'DB:business_master_new
loadtime:0.1483850479126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arden' limit 1
loadtime:0.14844799041748 / seconds
Query Executed:select id FROM `nc` where city='Arden' && SIC_code='7542'DB:business_master_new
loadtime:0.16383600234985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash' limit 1
loadtime:0.16392803192139 / seconds
Query Executed:select id FROM `nc` where city='Ash' && SIC_code='7542'DB:business_master_new
loadtime:0.16567611694336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheboro' limit 1
loadtime:0.16574001312256 / seconds
Query Executed:select id FROM `nc` where city='Asheboro' && SIC_code='7542'DB:business_master_new
loadtime:0.18002104759216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheville' limit 1
loadtime:0.18011593818665 / seconds
Query Executed:select id FROM `nc` where city='Asheville' && SIC_code='7542'DB:business_master_new
loadtime:0.19420504570007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.19434213638306 / seconds
Query Executed:select id FROM `nc` where city='Atkinson' && SIC_code='7542'DB:business_master_new
loadtime:0.19553112983704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.19559812545776 / seconds
Query Executed:select id FROM `nc` where city='Atlantic' && SIC_code='7542'DB:business_master_new
loadtime:0.19644713401794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.19651103019714 / seconds
Query Executed:select id FROM `nc` where city='Atlantic Beach' && SIC_code='7542'DB:business_master_new
loadtime:0.20360803604126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aulander' limit 1
loadtime:0.20368504524231 / seconds
Query Executed:select id FROM `nc` where city='Aulander' && SIC_code='7542'DB:business_master_new
loadtime:0.20572710037231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.20578908920288 / seconds
Query Executed:select id FROM `nc` where city='Aurora' && SIC_code='7542'DB:business_master_new
loadtime:0.20793604850769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Autryville' limit 1
loadtime:0.20800709724426 / seconds
Query Executed:select id FROM `nc` where city='Autryville' && SIC_code='7542'DB:business_master_new
loadtime:0.21004414558411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.21010494232178 / seconds
Query Executed:select id FROM `nc` where city='Avon' && SIC_code='7542'DB:business_master_new
loadtime:0.21241903305054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayden' limit 1
loadtime:0.21249198913574 / seconds
Query Executed:select id FROM `nc` where city='Ayden' && SIC_code='7542'DB:business_master_new
loadtime:0.21904897689819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aydlett' limit 1
loadtime:0.21912693977356 / seconds
Query Executed:select id FROM `nc` where city='Aydlett' && SIC_code='7542'DB:business_master_new
loadtime:0.2197151184082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badin' limit 1
loadtime:0.2197699546814 / seconds
Query Executed:select id FROM `nc` where city='Badin' && SIC_code='7542'DB:business_master_new
loadtime:0.22086715698242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bahama' limit 1
loadtime:0.22093200683594 / seconds
Query Executed:select id FROM `nc` where city='Bahama' && SIC_code='7542'DB:business_master_new
loadtime:0.22289299964905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.22295498847961 / seconds
Query Executed:select id FROM `nc` where city='Bailey' && SIC_code='7542'DB:business_master_new
loadtime:0.225830078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersville' limit 1
loadtime:0.2258939743042 / seconds
Query Executed:select id FROM `nc` where city='Bakersville' && SIC_code='7542'DB:business_master_new
loadtime:0.22934508323669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bald Head Island' limit 1
loadtime:0.2294180393219 / seconds
Query Executed:select id FROM `nc` where city='Bald Head Island' && SIC_code='7542'DB:business_master_new
loadtime:0.2298059463501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam' limit 1
loadtime:0.22987198829651 / seconds
Query Executed:select id FROM `nc` where city='Balsam' && SIC_code='7542'DB:business_master_new
loadtime:0.2304949760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam Grove' limit 1
loadtime:0.230553150177 / seconds
Query Executed:select id FROM `nc` where city='Balsam Grove' && SIC_code='7542'DB:business_master_new
loadtime:0.23117208480835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banner Elk' limit 1
loadtime:0.23122811317444 / seconds
Query Executed:select id FROM `nc` where city='Banner Elk' && SIC_code='7542'DB:business_master_new
loadtime:0.24218416213989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barco' limit 1
loadtime:0.24226093292236 / seconds
Query Executed:select id FROM `nc` where city='Barco' && SIC_code='7542'DB:business_master_new
loadtime:0.24316096305847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barium Springs' limit 1
loadtime:0.24322199821472 / seconds
Query Executed:select id FROM `nc` where city='Barium Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.24382996559143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnardsville' limit 1
loadtime:0.24389314651489 / seconds
Query Executed:select id FROM `nc` where city='Barnardsville' && SIC_code='7542'DB:business_master_new
loadtime:0.24535608291626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnesville' limit 1
loadtime:0.24541401863098 / seconds
Query Executed:select id FROM `nc` where city='Barnesville' && SIC_code='7542'DB:business_master_new
loadtime:0.24582195281982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bat Cave' limit 1
loadtime:0.24587893486023 / seconds
Query Executed:select id FROM `nc` where city='Bat Cave' && SIC_code='7542'DB:business_master_new
loadtime:0.24658107757568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.24663901329041 / seconds
Query Executed:select id FROM `nc` where city='Bath' && SIC_code='7542'DB:business_master_new
loadtime:0.2486879825592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battleboro' limit 1
loadtime:0.2487621307373 / seconds
Query Executed:select id FROM `nc` where city='Battleboro' && SIC_code='7542'DB:business_master_new
loadtime:0.25173401832581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayboro' limit 1
loadtime:0.25180697441101 / seconds
Query Executed:select id FROM `nc` where city='Bayboro' && SIC_code='7542'DB:business_master_new
loadtime:0.25369906425476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.25378108024597 / seconds
Query Executed:select id FROM `nc` where city='Bear Creek' && SIC_code='7542'DB:business_master_new
loadtime:0.25576996803284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.25582909584045 / seconds
Query Executed:select id FROM `nc` where city='Beaufort' && SIC_code='7542'DB:business_master_new
loadtime:0.26707005500793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Mountain' limit 1
loadtime:0.26714205741882 / seconds
Query Executed:select id FROM `nc` where city='Beech Mountain' && SIC_code='7542'DB:business_master_new
loadtime:0.26755094528198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belews Creek' limit 1
loadtime:0.2676100730896 / seconds
Query Executed:select id FROM `nc` where city='Belews Creek' && SIC_code='7542'DB:business_master_new
loadtime:0.26901197433472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belhaven' limit 1
loadtime:0.26907300949097 / seconds
Query Executed:select id FROM `nc` where city='Belhaven' && SIC_code='7542'DB:business_master_new
loadtime:0.27462410926819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellarthur' limit 1
loadtime:0.27470111846924 / seconds
Query Executed:select id FROM `nc` where city='Bellarthur' && SIC_code='7542'DB:business_master_new
loadtime:0.27523803710938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.27530002593994 / seconds
Query Executed:select id FROM `nc` where city='Belmont' && SIC_code='7542'DB:business_master_new
loadtime:0.28694605827332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.287024974823 / seconds
Query Executed:select id FROM `nc` where city='Belvidere' && SIC_code='7542'DB:business_master_new
loadtime:0.28797602653503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.28803706169128 / seconds
Query Executed:select id FROM `nc` where city='Bennett' && SIC_code='7542'DB:business_master_new
loadtime:0.28939509391785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.28945398330688 / seconds
Query Executed:select id FROM `nc` where city='Benson' && SIC_code='7542'DB:business_master_new
loadtime:0.29981112480164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer City' limit 1
loadtime:0.29989099502563 / seconds
Query Executed:select id FROM `nc` where city='Bessemer City' && SIC_code='7542'DB:business_master_new
loadtime:0.30677008628845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethania' limit 1
loadtime:0.30683302879333 / seconds
Query Executed:select id FROM `nc` where city='Bethania' && SIC_code='7542'DB:business_master_new
loadtime:0.30763912200928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.307697057724 / seconds
Query Executed:select id FROM `nc` where city='Bethel' && SIC_code='7542'DB:business_master_new
loadtime:0.3096489906311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulaville' limit 1
loadtime:0.30970811843872 / seconds
Query Executed:select id FROM `nc` where city='Beulaville' && SIC_code='7542'DB:business_master_new
loadtime:0.31580209732056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biltmore Lake' limit 1
loadtime:0.31587505340576 / seconds
Query Executed:select id FROM `nc` where city='Biltmore Lake' && SIC_code='7542'DB:business_master_new
loadtime:0.31629204750061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biscoe' limit 1
loadtime:0.31636095046997 / seconds
Query Executed:select id FROM `nc` where city='Biscoe' && SIC_code='7542'DB:business_master_new
loadtime:0.31944513320923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Creek' limit 1
loadtime:0.31951498985291 / seconds
Query Executed:select id FROM `nc` where city='Black Creek' && SIC_code='7542'DB:business_master_new
loadtime:0.3202760219574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Mountain' limit 1
loadtime:0.32033801078796 / seconds
Query Executed:select id FROM `nc` where city='Black Mountain' && SIC_code='7542'DB:business_master_new
loadtime:0.3306930065155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bladenboro' limit 1
loadtime:0.33078193664551 / seconds
Query Executed:select id FROM `nc` where city='Bladenboro' && SIC_code='7542'DB:business_master_new
loadtime:0.33633708953857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanch' limit 1
loadtime:0.33641910552979 / seconds
Query Executed:select id FROM `nc` where city='Blanch' && SIC_code='7542'DB:business_master_new
loadtime:0.33733105659485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blounts Creek' limit 1
loadtime:0.3373920917511 / seconds
Query Executed:select id FROM `nc` where city='Blounts Creek' && SIC_code='7542'DB:business_master_new
loadtime:0.33830904960632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blowing Rock' limit 1
loadtime:0.33837914466858 / seconds
Query Executed:select id FROM `nc` where city='Blowing Rock' && SIC_code='7542'DB:business_master_new
loadtime:0.34651494026184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boger City' limit 1
loadtime:0.34657597541809 / seconds
Query Executed:select id FROM `nc` where city='Boger City' && SIC_code='7542'DB:business_master_new
loadtime:0.34697508811951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.34703207015991 / seconds
Query Executed:select id FROM `nc` where city='Boiling Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.34895896911621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolivia' limit 1
loadtime:0.34902095794678 / seconds
Query Executed:select id FROM `nc` where city='Bolivia' && SIC_code='7542'DB:business_master_new
loadtime:0.35408401489258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.35414409637451 / seconds
Query Executed:select id FROM `nc` where city='Bolton' && SIC_code='7542'DB:business_master_new
loadtime:0.35561203956604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonlee' limit 1
loadtime:0.35566711425781 / seconds
Query Executed:select id FROM `nc` where city='Bonlee' && SIC_code='7542'DB:business_master_new
loadtime:0.35636711120605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boomer' limit 1
loadtime:0.35643315315247 / seconds
Query Executed:select id FROM `nc` where city='Boomer' && SIC_code='7542'DB:business_master_new
loadtime:0.35755801200867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.35761713981628 / seconds
Query Executed:select id FROM `nc` where city='Boone' && SIC_code='7542'DB:business_master_new
loadtime:0.37270307540894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boonville' limit 1
loadtime:0.37279605865479 / seconds
Query Executed:select id FROM `nc` where city='Boonville' && SIC_code='7542'DB:business_master_new
loadtime:0.37652206420898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bostic' limit 1
loadtime:0.37659406661987 / seconds
Query Executed:select id FROM `nc` where city='Bostic' && SIC_code='7542'DB:business_master_new
loadtime:0.37871503829956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdens' limit 1
loadtime:0.37878108024597 / seconds
Query Executed:select id FROM `nc` where city='Bowdens' && SIC_code='7542'DB:business_master_new
loadtime:0.37916398048401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brasstown' limit 1
loadtime:0.3792200088501 / seconds
Query Executed:select id FROM `nc` where city='Brasstown' && SIC_code='7542'DB:business_master_new
loadtime:0.38028216362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brevard' limit 1
loadtime:0.38035011291504 / seconds
Query Executed:select id FROM `nc` where city='Brevard' && SIC_code='7542'DB:business_master_new
loadtime:0.39677000045776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeton' limit 1
loadtime:0.39685606956482 / seconds
Query Executed:select id FROM `nc` where city='Bridgeton' && SIC_code='7542'DB:business_master_new
loadtime:0.39798593521118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.39804601669312 / seconds
Query Executed:select id FROM `nc` where city='Broadway' && SIC_code='7542'DB:business_master_new
loadtime:0.40050911903381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browns Summit' limit 1
loadtime:0.40057015419006 / seconds
Query Executed:select id FROM `nc` where city='Browns Summit' && SIC_code='7542'DB:business_master_new
loadtime:0.40536594390869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunswick' limit 1
loadtime:0.40542793273926 / seconds
Query Executed:select id FROM `nc` where city='Brunswick' && SIC_code='7542'DB:business_master_new
loadtime:0.40598797798157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryson City' limit 1
loadtime:0.40604615211487 / seconds
Query Executed:select id FROM `nc` where city='Bryson City' && SIC_code='7542'DB:business_master_new
loadtime:0.41363406181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buies Creek' limit 1
loadtime:0.4136950969696 / seconds
Query Executed:select id FROM `nc` where city='Buies Creek' && SIC_code='7542'DB:business_master_new
loadtime:0.41486597061157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullock' limit 1
loadtime:0.41493010520935 / seconds
Query Executed:select id FROM `nc` where city='Bullock' && SIC_code='7542'DB:business_master_new
loadtime:0.41579699516296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunn' limit 1
loadtime:0.41585612297058 / seconds
Query Executed:select id FROM `nc` where city='Bunn' && SIC_code='7542'DB:business_master_new
loadtime:0.41739797592163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunnlevel' limit 1
loadtime:0.41745805740356 / seconds
Query Executed:select id FROM `nc` where city='Bunnlevel' && SIC_code='7542'DB:business_master_new
loadtime:0.41877007484436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgaw' limit 1
loadtime:0.41882801055908 / seconds
Query Executed:select id FROM `nc` where city='Burgaw' && SIC_code='7542'DB:business_master_new
loadtime:0.42788815498352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.42797112464905 / seconds
Query Executed:select id FROM `nc` where city='Burlington' && SIC_code='7542'DB:business_master_new
loadtime:0.44290494918823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.44301915168762 / seconds
Query Executed:select id FROM `nc` where city='Burnsville' && SIC_code='7542'DB:business_master_new
loadtime:0.45401000976562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butner' limit 1
loadtime:0.45409393310547 / seconds
Query Executed:select id FROM `nc` where city='Butner' && SIC_code='7542'DB:business_master_new
loadtime:0.45682716369629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butters' limit 1
loadtime:0.45690011978149 / seconds
Query Executed:select id FROM `nc` where city='Butters' && SIC_code='7542'DB:business_master_new
loadtime:0.45730209350586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buxton' limit 1
loadtime:0.45737314224243 / seconds
Query Executed:select id FROM `nc` where city='Buxton' && SIC_code='7542'DB:business_master_new
loadtime:0.46046710014343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bynum' limit 1
loadtime:0.46053504943848 / seconds
Query Executed:select id FROM `nc` where city='Bynum' && SIC_code='7542'DB:business_master_new
loadtime:0.46096611022949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calabash' limit 1
loadtime:0.46102905273438 / seconds
Query Executed:select id FROM `nc` where city='Calabash' && SIC_code='7542'DB:business_master_new
loadtime:0.46675610542297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calypso' limit 1
loadtime:0.46684098243713 / seconds
Query Executed:select id FROM `nc` where city='Calypso' && SIC_code='7542'DB:business_master_new
loadtime:0.467689037323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.4677529335022 / seconds
Query Executed:select id FROM `nc` where city='Camden' && SIC_code='7542'DB:business_master_new
loadtime:0.47020602226257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.47027802467346 / seconds
Query Executed:select id FROM `nc` where city='Cameron' && SIC_code='7542'DB:business_master_new
loadtime:0.4732940196991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Lejeune' limit 1
loadtime:0.47337913513184 / seconds
Query Executed:select id FROM `nc` where city='Camp Lejeune' && SIC_code='7542'DB:business_master_new
loadtime:0.47496008872986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candler' limit 1
loadtime:0.47502708435059 / seconds
Query Executed:select id FROM `nc` where city='Candler' && SIC_code='7542'DB:business_master_new
loadtime:0.48579597473145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candor' limit 1
loadtime:0.48588109016418 / seconds
Query Executed:select id FROM `nc` where city='Candor' && SIC_code='7542'DB:business_master_new
loadtime:0.48814511299133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.48821902275085 / seconds
Query Executed:select id FROM `nc` where city='Canton' && SIC_code='7542'DB:business_master_new
loadtime:0.49568200111389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Carteret' limit 1
loadtime:0.49576497077942 / seconds
Query Executed:select id FROM `nc` where city='Cape Carteret' && SIC_code='7542'DB:business_master_new
loadtime:0.49627494812012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caroleen' limit 1
loadtime:0.49634313583374 / seconds
Query Executed:select id FROM `nc` where city='Caroleen' && SIC_code='7542'DB:business_master_new
loadtime:0.49700498580933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Beach' limit 1
loadtime:0.4970691204071 / seconds
Query Executed:select id FROM `nc` where city='Carolina Beach' && SIC_code='7542'DB:business_master_new
loadtime:0.50423502922058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Shores' limit 1
loadtime:0.504310131073 / seconds
Query Executed:select id FROM `nc` where city='Carolina Shores' && SIC_code='7542'DB:business_master_new
loadtime:0.50476503372192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrboro' limit 1
loadtime:0.50482797622681 / seconds
Query Executed:select id FROM `nc` where city='Carrboro' && SIC_code='7542'DB:business_master_new
loadtime:0.51433706283569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.51441407203674 / seconds
Query Executed:select id FROM `nc` where city='Carthage' && SIC_code='7542'DB:business_master_new
loadtime:0.52099609375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:0.52106404304504 / seconds
Query Executed:select id FROM `nc` where city='Cary' && SIC_code='7542'DB:business_master_new
loadtime:0.53611207008362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casar' limit 1
loadtime:0.53621506690979 / seconds
Query Executed:select id FROM `nc` where city='Casar' && SIC_code='7542'DB:business_master_new
loadtime:0.53755712509155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashiers' limit 1
loadtime:0.5376250743866 / seconds
Query Executed:select id FROM `nc` where city='Cashiers' && SIC_code='7542'DB:business_master_new
loadtime:0.54456114768982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:0.54462194442749 / seconds
Query Executed:select id FROM `nc` where city='Castalia' && SIC_code='7542'DB:business_master_new
loadtime:0.54608106613159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Hayne' limit 1
loadtime:0.54615116119385 / seconds
Query Executed:select id FROM `nc` where city='Castle Hayne' && SIC_code='7542'DB:business_master_new
loadtime:0.55057406425476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.55063509941101 / seconds
Query Executed:select id FROM `nc` where city='Catawba' && SIC_code='7542'DB:business_master_new
loadtime:0.55366897583008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:0.55373001098633 / seconds
Query Executed:select id FROM `nc` where city='Cedar Falls' && SIC_code='7542'DB:business_master_new
loadtime:0.55420398712158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:0.55426001548767 / seconds
Query Executed:select id FROM `nc` where city='Cedar Grove' && SIC_code='7542'DB:business_master_new
loadtime:0.55541896820068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Island' limit 1
loadtime:0.55548310279846 / seconds
Query Executed:select id FROM `nc` where city='Cedar Island' && SIC_code='7542'DB:business_master_new
loadtime:0.55619311332703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Mountain' limit 1
loadtime:0.55625009536743 / seconds
Query Executed:select id FROM `nc` where city='Cedar Mountain' && SIC_code='7542'DB:business_master_new
loadtime:0.55743312835693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Point' limit 1
loadtime:0.55750107765198 / seconds
Query Executed:select id FROM `nc` where city='Cedar Point' && SIC_code='7542'DB:business_master_new
loadtime:0.55794715881348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro Gordo' limit 1
loadtime:0.55800795555115 / seconds
Query Executed:select id FROM `nc` where city='Cerro Gordo' && SIC_code='7542'DB:business_master_new
loadtime:0.55924201011658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chadbourn' limit 1
loadtime:0.55930209159851 / seconds
Query Executed:select id FROM `nc` where city='Chadbourn' && SIC_code='7542'DB:business_master_new
loadtime:0.56337404251099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapel Hill' limit 1
loadtime:0.56342911720276 / seconds
Query Executed:select id FROM `nc` where city='Chapel Hill' && SIC_code='7542'DB:business_master_new
loadtime:0.57783603668213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.57791495323181 / seconds
Query Executed:select id FROM `nc` where city='Charlotte' && SIC_code='7542'DB:business_master_new
loadtime:0.59209895133972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.59233498573303 / seconds
Query Executed:select id FROM `nc` where city='Cherokee' && SIC_code='7542'DB:business_master_new
loadtime:0.59833312034607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Point' limit 1
loadtime:0.59841895103455 / seconds
Query Executed:select id FROM `nc` where city='Cherry Point' && SIC_code='7542'DB:business_master_new
loadtime:0.59942507743835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherryville' limit 1
loadtime:0.5995020866394 / seconds
Query Executed:select id FROM `nc` where city='Cherryville' && SIC_code='7542'DB:business_master_new
loadtime:0.6072051525116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimney Rock' limit 1
loadtime:0.60726809501648 / seconds
Query Executed:select id FROM `nc` where city='Chimney Rock' && SIC_code='7542'DB:business_master_new
loadtime:0.60825896263123 / seconds
Query loaded from cache:select * from geodata_geocity where city='China Grove' limit 1
loadtime:0.60832595825195 / seconds
Query Executed:select id FROM `nc` where city='China Grove' && SIC_code='7542'DB:business_master_new
loadtime:0.61659502983093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinquapin' limit 1
loadtime:0.61665606498718 / seconds
Query Executed:select id FROM `nc` where city='Chinquapin' && SIC_code='7542'DB:business_master_new
loadtime:0.61794805526733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocowinity' limit 1
loadtime:0.61800098419189 / seconds
Query Executed:select id FROM `nc` where city='Chocowinity' && SIC_code='7542'DB:business_master_new
loadtime:0.62150311470032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.62156200408936 / seconds
Query Executed:select id FROM `nc` where city='Claremont' && SIC_code='7542'DB:business_master_new
loadtime:0.62707805633545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarendon' limit 1
loadtime:0.62714004516602 / seconds
Query Executed:select id FROM `nc` where city='Clarendon' && SIC_code='7542'DB:business_master_new
loadtime:0.62814903259277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkton' limit 1
loadtime:0.62822294235229 / seconds
Query Executed:select id FROM `nc` where city='Clarkton' && SIC_code='7542'DB:business_master_new
loadtime:0.63111901283264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.63118004798889 / seconds
Query Executed:select id FROM `nc` where city='Clayton' && SIC_code='7542'DB:business_master_new
loadtime:0.65007615089417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemmons' limit 1
loadtime:0.65016794204712 / seconds
Query Executed:select id FROM `nc` where city='Clemmons' && SIC_code='7542'DB:business_master_new
loadtime:0.66630601882935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.66641402244568 / seconds
Query Executed:select id FROM `nc` where city='Cleveland' && SIC_code='7542'DB:business_master_new
loadtime:0.67034912109375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffside' limit 1
loadtime:0.67041611671448 / seconds
Query Executed:select id FROM `nc` where city='Cliffside' && SIC_code='7542'DB:business_master_new
loadtime:0.67109394073486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.67115306854248 / seconds
Query Executed:select id FROM `nc` where city='Climax' && SIC_code='7542'DB:business_master_new
loadtime:0.67324113845825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.67330002784729 / seconds
Query Executed:select id FROM `nc` where city='Clinton' && SIC_code='7542'DB:business_master_new
loadtime:0.68833899497986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:0.68843007087708 / seconds
Query Executed:select id FROM `nc` where city='Clyde' && SIC_code='7542'DB:business_master_new
loadtime:0.69412899017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coats' limit 1
loadtime:0.69420599937439 / seconds
Query Executed:select id FROM `nc` where city='Coats' && SIC_code='7542'DB:business_master_new
loadtime:0.69707012176514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cofield' limit 1
loadtime:0.6971480846405 / seconds
Query Executed:select id FROM `nc` where city='Cofield' && SIC_code='7542'DB:business_master_new
loadtime:0.69795393943787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coinjock' limit 1
loadtime:0.69801902770996 / seconds
Query Executed:select id FROM `nc` where city='Coinjock' && SIC_code='7542'DB:business_master_new
loadtime:0.69933199882507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colerain' limit 1
loadtime:0.69940614700317 / seconds
Query Executed:select id FROM `nc` where city='Colerain' && SIC_code='7542'DB:business_master_new
loadtime:0.70133495330811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleridge' limit 1
loadtime:0.70138907432556 / seconds
Query Executed:select id FROM `nc` where city='Coleridge' && SIC_code='7542'DB:business_master_new
loadtime:0.70184111595154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.7019031047821 / seconds
Query Executed:select id FROM `nc` where city='Colfax' && SIC_code='7542'DB:business_master_new
loadtime:0.70448994636536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collettsville' limit 1
loadtime:0.70455598831177 / seconds
Query Executed:select id FROM `nc` where city='Collettsville' && SIC_code='7542'DB:business_master_new
loadtime:0.70525312423706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.7053210735321 / seconds
Query Executed:select id FROM `nc` where city='Columbia' && SIC_code='7542'DB:business_master_new
loadtime:0.70877599716187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.70885014533997 / seconds
Query Executed:select id FROM `nc` where city='Columbus' && SIC_code='7542'DB:business_master_new
loadtime:0.71428394317627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comfort' limit 1
loadtime:0.71436095237732 / seconds
Query Executed:select id FROM `nc` where city='Comfort' && SIC_code='7542'DB:business_master_new
loadtime:0.71488904953003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.71494197845459 / seconds
Query Executed:select id FROM `nc` where city='Como' && SIC_code='7542'DB:business_master_new
loadtime:0.71571803092957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.71578311920166 / seconds
Query Executed:select id FROM `nc` where city='Concord' && SIC_code='7542'DB:business_master_new
loadtime:0.73014116287231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conetoe' limit 1
loadtime:0.73024702072144 / seconds
Query Executed:select id FROM `nc` where city='Conetoe' && SIC_code='7542'DB:business_master_new
loadtime:0.73098802566528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Spgs' limit 1
loadtime:0.73104500770569 / seconds
Query Executed:select id FROM `nc` where city='Connellys Spgs' && SIC_code='7542'DB:business_master_new
loadtime:0.73152804374695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Springs' limit 1
loadtime:0.7315890789032 / seconds
Query Executed:select id FROM `nc` where city='Connellys Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.73200798034668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conover' limit 1
loadtime:0.73207116127014 / seconds
Query Executed:select id FROM `nc` where city='Conover' && SIC_code='7542'DB:business_master_new
loadtime:0.74630093574524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.74639010429382 / seconds
Query Executed:select id FROM `nc` where city='Conway' && SIC_code='7542'DB:business_master_new
loadtime:0.74815011024475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooleemee' limit 1
loadtime:0.74821305274963 / seconds
Query Executed:select id FROM `nc` where city='Cooleemee' && SIC_code='7542'DB:business_master_new
loadtime:0.74971103668213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corapeake' limit 1
loadtime:0.74977111816406 / seconds
Query Executed:select id FROM `nc` where city='Corapeake' && SIC_code='7542'DB:business_master_new
loadtime:0.75053596496582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.75059413909912 / seconds
Query Executed:select id FROM `nc` where city='Cordova' && SIC_code='7542'DB:business_master_new
loadtime:0.75122714042664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornelius' limit 1
loadtime:0.75128507614136 / seconds
Query Executed:select id FROM `nc` where city='Cornelius' && SIC_code='7542'DB:business_master_new
loadtime:0.76566600799561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corolla' limit 1
loadtime:0.76575303077698 / seconds
Query Executed:select id FROM `nc` where city='Corolla' && SIC_code='7542'DB:business_master_new
loadtime:0.77029609680176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:0.77037310600281 / seconds
Query Executed:select id FROM `nc` where city='Council' && SIC_code='7542'DB:business_master_new
loadtime:0.77136898040771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cove City' limit 1
loadtime:0.77143216133118 / seconds
Query Executed:select id FROM `nc` where city='Cove City' && SIC_code='7542'DB:business_master_new
loadtime:0.7728590965271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cramerton' limit 1
loadtime:0.77292108535767 / seconds
Query Executed:select id FROM `nc` where city='Cramerton' && SIC_code='7542'DB:business_master_new
loadtime:0.77454614639282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creedmoor' limit 1
loadtime:0.7746000289917 / seconds
Query Executed:select id FROM `nc` where city='Creedmoor' && SIC_code='7542'DB:business_master_new
loadtime:0.78172612190247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.78180313110352 / seconds
Query Executed:select id FROM `nc` where city='Creston' && SIC_code='7542'DB:business_master_new
loadtime:0.78285503387451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creswell' limit 1
loadtime:0.78291702270508 / seconds
Query Executed:select id FROM `nc` where city='Creswell' && SIC_code='7542'DB:business_master_new
loadtime:0.78469610214233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossnore' limit 1
loadtime:0.78474998474121 / seconds
Query Executed:select id FROM `nc` where city='Crossnore' && SIC_code='7542'DB:business_master_new
loadtime:0.78561806678772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crouse' limit 1
loadtime:0.7856810092926 / seconds
Query Executed:select id FROM `nc` where city='Crouse' && SIC_code='7542'DB:business_master_new
loadtime:0.78666615486145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crumpler' limit 1
loadtime:0.78673195838928 / seconds
Query Executed:select id FROM `nc` where city='Crumpler' && SIC_code='7542'DB:business_master_new
loadtime:0.78802299499512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culberson' limit 1
loadtime:0.78808116912842 / seconds
Query Executed:select id FROM `nc` where city='Culberson' && SIC_code='7542'DB:business_master_new
loadtime:0.78852009773254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullowhee' limit 1
loadtime:0.78858113288879 / seconds
Query Executed:select id FROM `nc` where city='Cullowhee' && SIC_code='7542'DB:business_master_new
loadtime:0.7915461063385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.79160404205322 / seconds
Query Executed:select id FROM `nc` where city='Cumberland' && SIC_code='7542'DB:business_master_new
loadtime:0.79224300384521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumnock' limit 1
loadtime:0.79230499267578 / seconds
Query Executed:select id FROM `nc` where city='Cumnock' && SIC_code='7542'DB:business_master_new
loadtime:0.79269599914551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currie' limit 1
loadtime:0.79275393486023 / seconds
Query Executed:select id FROM `nc` where city='Currie' && SIC_code='7542'DB:business_master_new
loadtime:0.79387998580933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currituck' limit 1
loadtime:0.79393815994263 / seconds
Query Executed:select id FROM `nc` where city='Currituck' && SIC_code='7542'DB:business_master_new
loadtime:0.79562401771545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.79568314552307 / seconds
Query Executed:select id FROM `nc` where city='Dallas' && SIC_code='7542'DB:business_master_new
loadtime:0.80468511581421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:0.80474615097046 / seconds
Query Executed:select id FROM `nc` where city='Dana' && SIC_code='7542'DB:business_master_new
loadtime:0.80559396743774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.80565905570984 / seconds
Query Executed:select id FROM `nc` where city='Danbury' && SIC_code='7542'DB:business_master_new
loadtime:0.80822706222534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davidson' limit 1
loadtime:0.80829215049744 / seconds
Query Executed:select id FROM `nc` where city='Davidson' && SIC_code='7542'DB:business_master_new
loadtime:0.81858205795288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.81864309310913 / seconds
Query Executed:select id FROM `nc` where city='Davis' && SIC_code='7542'DB:business_master_new
loadtime:0.81927013397217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Gap' limit 1
loadtime:0.81933999061584 / seconds
Query Executed:select id FROM `nc` where city='Deep Gap' && SIC_code='7542'DB:business_master_new
loadtime:0.82088708877563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Run' limit 1
loadtime:0.82096409797668 / seconds
Query Executed:select id FROM `nc` where city='Deep Run' && SIC_code='7542'DB:business_master_new
loadtime:0.82240700721741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delco' limit 1
loadtime:0.82246208190918 / seconds
Query Executed:select id FROM `nc` where city='Delco' && SIC_code='7542'DB:business_master_new
loadtime:0.82404708862305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denton' limit 1
loadtime:0.82410907745361 / seconds
Query Executed:select id FROM `nc` where city='Denton' && SIC_code='7542'DB:business_master_new
loadtime:0.83070206642151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.83077812194824 / seconds
Query Executed:select id FROM `nc` where city='Denver' && SIC_code='7542'DB:business_master_new
loadtime:0.84482598304749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillsboro' limit 1
loadtime:0.84491300582886 / seconds
Query Executed:select id FROM `nc` where city='Dillsboro' && SIC_code='7542'DB:business_master_new
loadtime:0.84661412239075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dobson' limit 1
loadtime:0.8466739654541 / seconds
Query Executed:select id FROM `nc` where city='Dobson' && SIC_code='7542'DB:business_master_new
loadtime:0.85398101806641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.85404109954834 / seconds
Query Executed:select id FROM `nc` where city='Dover' && SIC_code='7542'DB:business_master_new
loadtime:0.8555121421814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drexel' limit 1
loadtime:0.85557293891907 / seconds
Query Executed:select id FROM `nc` where city='Drexel' && SIC_code='7542'DB:business_master_new
loadtime:0.8570830821991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.85715103149414 / seconds
Query Executed:select id FROM `nc` where city='Dublin' && SIC_code='7542'DB:business_master_new
loadtime:0.85830116271973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.85838103294373 / seconds
Query Executed:select id FROM `nc` where city='Dudley' && SIC_code='7542'DB:business_master_new
loadtime:0.86091995239258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn' limit 1
loadtime:0.86099600791931 / seconds
Query Executed:select id FROM `nc` where city='Dunn' && SIC_code='7542'DB:business_master_new
loadtime:0.8806140422821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durants Neck' limit 1
loadtime:0.88070607185364 / seconds
Query Executed:select id FROM `nc` where city='Durants Neck' && SIC_code='7542'DB:business_master_new
loadtime:0.88108110427856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.88114404678345 / seconds
Query Executed:select id FROM `nc` where city='Durham' && SIC_code='7542'DB:business_master_new
loadtime:0.89623498916626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:0.89637303352356 / seconds
Query Executed:select id FROM `nc` where city='Eagle Rock' && SIC_code='7542'DB:business_master_new
loadtime:0.89681911468506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Springs' limit 1
loadtime:0.8968780040741 / seconds
Query Executed:select id FROM `nc` where city='Eagle Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.89790296554565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earl' limit 1
loadtime:0.89796209335327 / seconds
Query Executed:select id FROM `nc` where city='Earl' && SIC_code='7542'DB:business_master_new
loadtime:0.89853715896606 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bend' limit 1
loadtime:0.89859795570374 / seconds
Query Executed:select id FROM `nc` where city='East Bend' && SIC_code='7542'DB:business_master_new
loadtime:0.90222907066345 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fayettevlle' limit 1
loadtime:0.90230798721313 / seconds
Query Executed:select id FROM `nc` where city='East Fayettevlle' && SIC_code='7542'DB:business_master_new
loadtime:0.90271711349487 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Flat Rock' limit 1
loadtime:0.90277504920959 / seconds
Query Executed:select id FROM `nc` where city='East Flat Rock' && SIC_code='7542'DB:business_master_new
loadtime:0.90475606918335 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lake' limit 1
loadtime:0.90482902526855 / seconds
Query Executed:select id FROM `nc` where city='East Lake' && SIC_code='7542'DB:business_master_new
loadtime:0.90521097183228 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Spencer' limit 1
loadtime:0.90527105331421 / seconds
Query Executed:select id FROM `nc` where city='East Spencer' && SIC_code='7542'DB:business_master_new
loadtime:0.90616011619568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.9062180519104 / seconds
Query Executed:select id FROM `nc` where city='Eden' && SIC_code='7542'DB:business_master_new
loadtime:0.92365503311157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenton' limit 1
loadtime:0.92375206947327 / seconds
Query Executed:select id FROM `nc` where city='Edenton' && SIC_code='7542'DB:business_master_new
loadtime:0.93478012084961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edneyville' limit 1
loadtime:0.93484306335449 / seconds
Query Executed:select id FROM `nc` where city='Edneyville' && SIC_code='7542'DB:business_master_new
loadtime:0.93561196327209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edward' limit 1
loadtime:0.93567609786987 / seconds
Query Executed:select id FROM `nc` where city='Edward' && SIC_code='7542'DB:business_master_new
loadtime:0.93633008003235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Efland' limit 1
loadtime:0.93639397621155 / seconds
Query Executed:select id FROM `nc` where city='Efland' && SIC_code='7542'DB:business_master_new
loadtime:0.93855595588684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth City' limit 1
loadtime:0.93861508369446 / seconds
Query Executed:select id FROM `nc` where city='Elizabeth City' && SIC_code='7542'DB:business_master_new
loadtime:0.95334410667419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabethtown' limit 1
loadtime:0.95342993736267 / seconds
Query Executed:select id FROM `nc` where city='Elizabethtown' && SIC_code='7542'DB:business_master_new
loadtime:0.96468305587769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Park' limit 1
loadtime:0.9647741317749 / seconds
Query Executed:select id FROM `nc` where city='Elk Park' && SIC_code='7542'DB:business_master_new
loadtime:0.9664580821991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkin' limit 1
loadtime:0.96652913093567 / seconds
Query Executed:select id FROM `nc` where city='Elkin' && SIC_code='7542'DB:business_master_new
loadtime:0.9769389629364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellenboro' limit 1
loadtime:0.9770200252533 / seconds
Query Executed:select id FROM `nc` where city='Ellenboro' && SIC_code='7542'DB:business_master_new
loadtime:0.97940611839294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellerbe' limit 1
loadtime:0.97946405410767 / seconds
Query Executed:select id FROM `nc` where city='Ellerbe' && SIC_code='7542'DB:business_master_new
loadtime:0.98249506950378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm City' limit 1
loadtime:0.98255896568298 / seconds
Query Executed:select id FROM `nc` where city='Elm City' && SIC_code='7542'DB:business_master_new
loadtime:0.98654103279114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon' limit 1
loadtime:0.98660111427307 / seconds
Query Executed:select id FROM `nc` where city='Elon' && SIC_code='7542'DB:business_master_new
loadtime:0.99100112915039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon College' limit 1
loadtime:0.99106097221375 / seconds
Query Executed:select id FROM `nc` where city='Elon College' && SIC_code='7542'DB:business_master_new
loadtime:0.99176597595215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerald Isle' limit 1
loadtime:0.99184012413025 / seconds
Query Executed:select id FROM `nc` where city='Emerald Isle' && SIC_code='7542'DB:business_master_new
loadtime:0.99644708633423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.99652314186096 / seconds
Query Executed:select id FROM `nc` where city='Enfield' && SIC_code='7542'DB:business_master_new
loadtime:1.0004580020905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engelhard' limit 1
loadtime:1.000540971756 / seconds
Query Executed:select id FROM `nc` where city='Engelhard' && SIC_code='7542'DB:business_master_new
loadtime:1.002023935318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enka' limit 1
loadtime:1.0020971298218 / seconds
Query Executed:select id FROM `nc` where city='Enka' && SIC_code='7542'DB:business_master_new
loadtime:1.0035099983215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ennice' limit 1
loadtime:1.0035719871521 / seconds
Query Executed:select id FROM `nc` where city='Ennice' && SIC_code='7542'DB:business_master_new
loadtime:1.0047471523285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ernul' limit 1
loadtime:1.0048060417175 / seconds
Query Executed:select id FROM `nc` where city='Ernul' && SIC_code='7542'DB:business_master_new
loadtime:1.0055840015411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:1.0056371688843 / seconds
Query Executed:select id FROM `nc` where city='Erwin' && SIC_code='7542'DB:business_master_new
loadtime:1.0097899436951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ether' limit 1
loadtime:1.0098750591278 / seconds
Query Executed:select id FROM `nc` where city='Ether' && SIC_code='7542'DB:business_master_new
loadtime:1.0105500221252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etowah' limit 1
loadtime:1.0106110572815 / seconds
Query Executed:select id FROM `nc` where city='Etowah' && SIC_code='7542'DB:business_master_new
loadtime:1.0129170417786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eure' limit 1
loadtime:1.0129771232605 / seconds
Query Executed:select id FROM `nc` where city='Eure' && SIC_code='7542'DB:business_master_new
loadtime:1.01384806633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:1.0139119625092 / seconds
Query Executed:select id FROM `nc` where city='Eureka' && SIC_code='7542'DB:business_master_new
loadtime:1.0143260955811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everetts' limit 1
loadtime:1.0143840312958 / seconds
Query Executed:select id FROM `nc` where city='Everetts' && SIC_code='7542'DB:business_master_new
loadtime:1.0149919986725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:1.0150489807129 / seconds
Query Executed:select id FROM `nc` where city='Evergreen' && SIC_code='7542'DB:business_master_new
loadtime:1.0160181522369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Bluff' limit 1
loadtime:1.0160870552063 / seconds
Query Executed:select id FROM `nc` where city='Fair Bluff' && SIC_code='7542'DB:business_master_new
loadtime:1.0183320045471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.0184061527252 / seconds
Query Executed:select id FROM `nc` where city='Fairfield' && SIC_code='7542'DB:business_master_new
loadtime:1.0195341110229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairmont' limit 1
loadtime:1.0195970535278 / seconds
Query Executed:select id FROM `nc` where city='Fairmont' && SIC_code='7542'DB:business_master_new
loadtime:1.0240080356598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:1.0240831375122 / seconds
Query Executed:select id FROM `nc` where city='Fairview' && SIC_code='7542'DB:business_master_new
loadtime:1.0292611122131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faison' limit 1
loadtime:1.0293531417847 / seconds
Query Executed:select id FROM `nc` where city='Faison' && SIC_code='7542'DB:business_master_new
loadtime:1.0321340560913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:1.032210111618 / seconds
Query Executed:select id FROM `nc` where city='Faith' && SIC_code='7542'DB:business_master_new
loadtime:1.0332911014557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:1.0333590507507 / seconds
Query Executed:select id FROM `nc` where city='Falcon' && SIC_code='7542'DB:business_master_new
loadtime:1.0341620445251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkland' limit 1
loadtime:1.0342259407043 / seconds
Query Executed:select id FROM `nc` where city='Falkland' && SIC_code='7542'DB:business_master_new
loadtime:1.0349099636078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fallston' limit 1
loadtime:1.0349690914154 / seconds
Query Executed:select id FROM `nc` where city='Fallston' && SIC_code='7542'DB:business_master_new
loadtime:1.0361189842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:1.03617811203 / seconds
Query Executed:select id FROM `nc` where city='Farmville' && SIC_code='7542'DB:business_master_new
loadtime:1.0432829856873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayetteville' limit 1
loadtime:1.0433690547943 / seconds
Query Executed:select id FROM `nc` where city='Fayetteville' && SIC_code='7542'DB:business_master_new
loadtime:1.0585329532623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fearrington Vlg' limit 1
loadtime:1.0586950778961 / seconds
Query Executed:select id FROM `nc` where city='Fearrington Vlg' && SIC_code='7542'DB:business_master_new
loadtime:1.0590801239014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:1.0591480731964 / seconds
Query Executed:select id FROM `nc` where city='Ferguson' && SIC_code='7542'DB:business_master_new
loadtime:1.060446023941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:1.0605089664459 / seconds
Query Executed:select id FROM `nc` where city='Flat Rock' && SIC_code='7542'DB:business_master_new
loadtime:1.0661540031433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fleetwood' limit 1
loadtime:1.0662240982056 / seconds
Query Executed:select id FROM `nc` where city='Fleetwood' && SIC_code='7542'DB:business_master_new
loadtime:1.0678260326385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fletcher' limit 1
loadtime:1.0678870677948 / seconds
Query Executed:select id FROM `nc` where city='Fletcher' && SIC_code='7542'DB:business_master_new
loadtime:1.0794560909271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana Dam' limit 1
loadtime:1.0795421600342 / seconds
Query Executed:select id FROM `nc` where city='Fontana Dam' && SIC_code='7542'DB:business_master_new
loadtime:1.080048084259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:1.0801110267639 / seconds
Query Executed:select id FROM `nc` where city='Forest City' && SIC_code='7542'DB:business_master_new
loadtime:1.094496011734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bragg' limit 1
loadtime:1.0945820808411 / seconds
Query Executed:select id FROM `nc` where city='Fort Bragg' && SIC_code='7542'DB:business_master_new
loadtime:1.0981349945068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:1.0982129573822 / seconds
Query Executed:select id FROM `nc` where city='Fountain' && SIC_code='7542'DB:business_master_new
loadtime:1.0994091033936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Four Oaks' limit 1
loadtime:1.0994689464569 / seconds
Query Executed:select id FROM `nc` where city='Four Oaks' && SIC_code='7542'DB:business_master_new
loadtime:1.1057870388031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.1058621406555 / seconds
Query Executed:select id FROM `nc` where city='Franklin' && SIC_code='7542'DB:business_master_new
loadtime:1.1207981109619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinton' limit 1
loadtime:1.1208901405334 / seconds
Query Executed:select id FROM `nc` where city='Franklinton' && SIC_code='7542'DB:business_master_new
loadtime:1.1257891654968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinville' limit 1
loadtime:1.1258680820465 / seconds
Query Executed:select id FROM `nc` where city='Franklinville' && SIC_code='7542'DB:business_master_new
loadtime:1.1280460357666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:1.1281080245972 / seconds
Query Executed:select id FROM `nc` where city='Fremont' && SIC_code='7542'DB:business_master_new
loadtime:1.1304931640625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco' limit 1
loadtime:1.1305720806122 / seconds
Query Executed:select id FROM `nc` where city='Frisco' && SIC_code='7542'DB:business_master_new
loadtime:1.1321251392365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fuquay Varina' limit 1
loadtime:1.132187128067 / seconds
Query Executed:select id FROM `nc` where city='Fuquay Varina' && SIC_code='7542'DB:business_master_new
loadtime:1.1525211334229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:1.1526050567627 / seconds
Query Executed:select id FROM `nc` where city='Garland' && SIC_code='7542'DB:business_master_new
loadtime:1.1550741195679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:1.1551361083984 / seconds
Query Executed:select id FROM `nc` where city='Garner' && SIC_code='7542'DB:business_master_new
loadtime:1.1698100566864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garysburg' limit 1
loadtime:1.1698911190033 / seconds
Query Executed:select id FROM `nc` where city='Garysburg' && SIC_code='7542'DB:business_master_new
loadtime:1.17103099823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:1.1710939407349 / seconds
Query Executed:select id FROM `nc` where city='Gaston' && SIC_code='7542'DB:business_master_new
loadtime:1.1724021434784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gastonia' limit 1
loadtime:1.1724629402161 / seconds
Query Executed:select id FROM `nc` where city='Gastonia' && SIC_code='7542'DB:business_master_new
loadtime:1.1865630149841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gates' limit 1
loadtime:1.1866569519043 / seconds
Query Executed:select id FROM `nc` where city='Gates' && SIC_code='7542'DB:business_master_new
loadtime:1.1880040168762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gatesville' limit 1
loadtime:1.1880669593811 / seconds
Query Executed:select id FROM `nc` where city='Gatesville' && SIC_code='7542'DB:business_master_new
loadtime:1.1900629997253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germanton' limit 1
loadtime:1.190122127533 / seconds
Query Executed:select id FROM `nc` where city='Germanton' && SIC_code='7542'DB:business_master_new
loadtime:1.19193816185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gerton' limit 1
loadtime:1.1919960975647 / seconds
Query Executed:select id FROM `nc` where city='Gerton' && SIC_code='7542'DB:business_master_new
loadtime:1.1925461292267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:1.1926109790802 / seconds
Query Executed:select id FROM `nc` where city='Gibson' && SIC_code='7542'DB:business_master_new
loadtime:1.1935720443726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibsonville' limit 1
loadtime:1.1936309337616 / seconds
Query Executed:select id FROM `nc` where city='Gibsonville' && SIC_code='7542'DB:business_master_new
loadtime:1.1993980407715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Valley' limit 1
loadtime:1.1994690895081 / seconds
Query Executed:select id FROM `nc` where city='Glade Valley' && SIC_code='7542'DB:business_master_new
loadtime:1.2004179954529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Alpine' limit 1
loadtime:1.2004780769348 / seconds
Query Executed:select id FROM `nc` where city='Glen Alpine' && SIC_code='7542'DB:business_master_new
loadtime:1.2016961574554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Raven' limit 1
loadtime:1.2017590999603 / seconds
Query Executed:select id FROM `nc` where city='Glen Raven' && SIC_code='7542'DB:business_master_new
loadtime:1.2021629810333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale Springs' limit 1
loadtime:1.2022199630737 / seconds
Query Executed:select id FROM `nc` where city='Glendale Springs' && SIC_code='7542'DB:business_master_new
loadtime:1.2028861045837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendon' limit 1
loadtime:1.2029430866241 / seconds
Query Executed:select id FROM `nc` where city='Glendon' && SIC_code='7542'DB:business_master_new
loadtime:1.2033751010895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenville' limit 1
loadtime:1.2034330368042 / seconds
Query Executed:select id FROM `nc` where city='Glenville' && SIC_code='7542'DB:business_master_new
loadtime:1.2047090530396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:1.2047691345215 / seconds
Query Executed:select id FROM `nc` where city='Glenwood' && SIC_code='7542'DB:business_master_new
loadtime:1.2052750587463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:1.2053401470184 / seconds
Query Executed:select id FROM `nc` where city='Gloucester' && SIC_code='7542'DB:business_master_new
loadtime:1.2058990001678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Godwin' limit 1
loadtime:1.2059631347656 / seconds
Query Executed:select id FROM `nc` where city='Godwin' && SIC_code='7542'DB:business_master_new
loadtime:1.2072451114655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gold Hill' limit 1
loadtime:1.2073040008545 / seconds
Query Executed:select id FROM `nc` where city='Gold Hill' && SIC_code='7542'DB:business_master_new
loadtime:1.2089331150055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldsboro' limit 1
loadtime:1.2089850902557 / seconds
Query Executed:select id FROM `nc` where city='Goldsboro' && SIC_code='7542'DB:business_master_new
loadtime:1.2232501506805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldston' limit 1
loadtime:1.223356962204 / seconds
Query Executed:select id FROM `nc` where city='Goldston' && SIC_code='7542'DB:business_master_new
loadtime:1.2250051498413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graham' limit 1
loadtime:1.225063085556 / seconds
Query Executed:select id FROM `nc` where city='Graham' && SIC_code='7542'DB:business_master_new
loadtime:1.2407200336456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandy' limit 1
loadtime:1.2408120632172 / seconds
Query Executed:select id FROM `nc` where city='Grandy' && SIC_code='7542'DB:business_master_new
loadtime:1.2432081699371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Falls' limit 1
loadtime:1.2432701587677 / seconds
Query Executed:select id FROM `nc` where city='Granite Falls' && SIC_code='7542'DB:business_master_new
loadtime:1.2518529891968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Quarry' limit 1
loadtime:1.2519381046295 / seconds
Query Executed:select id FROM `nc` where city='Granite Quarry' && SIC_code='7542'DB:business_master_new
loadtime:1.2534670829773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsboro' limit 1
loadtime:1.2535481452942 / seconds
Query Executed:select id FROM `nc` where city='Grantsboro' && SIC_code='7542'DB:business_master_new
loadtime:1.2546999454498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grassy Creek' limit 1
loadtime:1.2547631263733 / seconds
Query Executed:select id FROM `nc` where city='Grassy Creek' && SIC_code='7542'DB:business_master_new
loadtime:1.2554049491882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:1.2554571628571 / seconds
Query Executed:select id FROM `nc` where city='Green Mountain' && SIC_code='7542'DB:business_master_new
loadtime:1.2562661170959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenmountain' limit 1
loadtime:1.2563331127167 / seconds
Query Executed:select id FROM `nc` where city='Greenmountain' && SIC_code='7542'DB:business_master_new
loadtime:1.2567541599274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:1.2568161487579 / seconds
Query Executed:select id FROM `nc` where city='Greensboro' && SIC_code='7542'DB:business_master_new
loadtime:1.2715330123901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.2717349529266 / seconds
Query Executed:select id FROM `nc` where city='Greenville' && SIC_code='7542'DB:business_master_new
loadtime:1.2858369350433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grifton' limit 1
loadtime:1.2859570980072 / seconds
Query Executed:select id FROM `nc` where city='Grifton' && SIC_code='7542'DB:business_master_new
loadtime:1.2893691062927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimesland' limit 1
loadtime:1.2894451618195 / seconds
Query Executed:select id FROM `nc` where city='Grimesland' && SIC_code='7542'DB:business_master_new
loadtime:1.2917420864105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:1.2918031215668 / seconds
Query Executed:select id FROM `nc` where city='Grover' && SIC_code='7542'DB:business_master_new
loadtime:1.293802022934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulf' limit 1
loadtime:1.2938780784607 / seconds
Query Executed:select id FROM `nc` where city='Gulf' && SIC_code='7542'DB:business_master_new
loadtime:1.2944850921631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:1.2945470809937 / seconds
Query Executed:select id FROM `nc` where city='Halifax' && SIC_code='7542'DB:business_master_new
loadtime:1.2973511219025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallsboro' limit 1
loadtime:1.2974140644073 / seconds
Query Executed:select id FROM `nc` where city='Hallsboro' && SIC_code='7542'DB:business_master_new
loadtime:1.2985081672668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.2985689640045 / seconds
Query Executed:select id FROM `nc` where city='Hamilton' && SIC_code='7542'DB:business_master_new
loadtime:1.2995419502258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlet' limit 1
loadtime:1.2996029853821 / seconds
Query Executed:select id FROM `nc` where city='Hamlet' && SIC_code='7542'DB:business_master_new
loadtime:1.3055119514465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:1.3055670261383 / seconds
Query Executed:select id FROM `nc` where city='Hampstead' && SIC_code='7542'DB:business_master_new
loadtime:1.315169095993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamptonville' limit 1
loadtime:1.3152511119843 / seconds
Query Executed:select id FROM `nc` where city='Hamptonville' && SIC_code='7542'DB:business_master_new
loadtime:1.3181200027466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbinger' limit 1
loadtime:1.3181929588318 / seconds
Query Executed:select id FROM `nc` where city='Harbinger' && SIC_code='7542'DB:business_master_new
loadtime:1.3197801113129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harkers Island' limit 1
loadtime:1.3198480606079 / seconds
Query Executed:select id FROM `nc` where city='Harkers Island' && SIC_code='7542'DB:business_master_new
loadtime:1.3213579654694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harmony' limit 1
loadtime:1.3214161396027 / seconds
Query Executed:select id FROM `nc` where city='Harmony' && SIC_code='7542'DB:business_master_new
loadtime:1.3242130279541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrells' limit 1
loadtime:1.3242771625519 / seconds
Query Executed:select id FROM `nc` where city='Harrells' && SIC_code='7542'DB:business_master_new
loadtime:1.3263220787048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrellsville' limit 1
loadtime:1.3263821601868 / seconds
Query Executed:select id FROM `nc` where city='Harrellsville' && SIC_code='7542'DB:business_master_new
loadtime:1.3272261619568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:1.3272869586945 / seconds
Query Executed:select id FROM `nc` where city='Harris' && SIC_code='7542'DB:business_master_new
loadtime:1.3277530670166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:1.3278141021729 / seconds
Query Executed:select id FROM `nc` where city='Harrisburg' && SIC_code='7542'DB:business_master_new
loadtime:1.3369181156158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hassell' limit 1
loadtime:1.3369960784912 / seconds
Query Executed:select id FROM `nc` where city='Hassell' && SIC_code='7542'DB:business_master_new
loadtime:1.337455034256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatteras' limit 1
loadtime:1.3375220298767 / seconds
Query Executed:select id FROM `nc` where city='Hatteras' && SIC_code='7542'DB:business_master_new
loadtime:1.3396551609039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:1.339714050293 / seconds
Query Executed:select id FROM `nc` where city='Havelock' && SIC_code='7542'DB:business_master_new
loadtime:1.3504230976105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haw River' limit 1
loadtime:1.350515127182 / seconds
Query Executed:select id FROM `nc` where city='Haw River' && SIC_code='7542'DB:business_master_new
loadtime:1.3541910648346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:1.354266166687 / seconds
Query Executed:select id FROM `nc` where city='Hayesville' && SIC_code='7542'DB:business_master_new
loadtime:1.3629031181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hays' limit 1
loadtime:1.3629839420319 / seconds
Query Executed:select id FROM `nc` where city='Hays' && SIC_code='7542'DB:business_master_new
loadtime:1.3647210597992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelwood' limit 1
loadtime:1.3647840023041 / seconds
Query Executed:select id FROM `nc` where city='Hazelwood' && SIC_code='7542'DB:business_master_new
loadtime:1.3655710220337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:1.3656430244446 / seconds
Query Executed:select id FROM `nc` where city='Henderson' && SIC_code='7542'DB:business_master_new
loadtime:1.3806190490723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hendersonville' limit 1
loadtime:1.3807001113892 / seconds
Query Executed:select id FROM `nc` where city='Hendersonville' && SIC_code='7542'DB:business_master_new
loadtime:1.394788980484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrico' limit 1
loadtime:1.3948919773102 / seconds
Query Executed:select id FROM `nc` where city='Henrico' && SIC_code='7542'DB:business_master_new
loadtime:1.3957879543304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrietta' limit 1
loadtime:1.3958530426025 / seconds
Query Executed:select id FROM `nc` where city='Henrietta' && SIC_code='7542'DB:business_master_new
loadtime:1.3965320587158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hertford' limit 1
loadtime:1.3965899944305 / seconds
Query Executed:select id FROM `nc` where city='Hertford' && SIC_code='7542'DB:business_master_new
loadtime:1.4032080173492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:1.4032640457153 / seconds
Query Executed:select id FROM `nc` where city='Hickory' && SIC_code='7542'DB:business_master_new
loadtime:1.4175910949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiddenite' limit 1
loadtime:1.41770195961 / seconds
Query Executed:select id FROM `nc` where city='Hiddenite' && SIC_code='7542'DB:business_master_new
loadtime:1.4199841022491 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Point' limit 1
loadtime:1.420047044754 / seconds
Query Executed:select id FROM `nc` where city='High Point' && SIC_code='7542'DB:business_master_new
loadtime:1.4341640472412 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Shoals' limit 1
loadtime:1.4342670440674 / seconds
Query Executed:select id FROM `nc` where city='High Shoals' && SIC_code='7542'DB:business_master_new
loadtime:1.4348709583282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highfalls' limit 1
loadtime:1.4349329471588 / seconds
Query Executed:select id FROM `nc` where city='Highfalls' && SIC_code='7542'DB:business_master_new
loadtime:1.4355101585388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands' limit 1
loadtime:1.4355750083923 / seconds
Query Executed:select id FROM `nc` where city='Highlands' && SIC_code='7542'DB:business_master_new
loadtime:1.4440219402313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildebran' limit 1
loadtime:1.4440951347351 / seconds
Query Executed:select id FROM `nc` where city='Hildebran' && SIC_code='7542'DB:business_master_new
loadtime:1.447468996048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:1.447555065155 / seconds
Query Executed:select id FROM `nc` where city='Hillsborough' && SIC_code='7542'DB:business_master_new
loadtime:1.4655950069427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbsville' limit 1
loadtime:1.4656851291656 / seconds
Query Executed:select id FROM `nc` where city='Hobbsville' && SIC_code='7542'DB:business_master_new
loadtime:1.4665291309357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobgood' limit 1
loadtime:1.466588973999 / seconds
Query Executed:select id FROM `nc` where city='Hobgood' && SIC_code='7542'DB:business_master_new
loadtime:1.4674110412598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobucken' limit 1
loadtime:1.4674651622772 / seconds
Query Executed:select id FROM `nc` where city='Hobucken' && SIC_code='7542'DB:business_master_new
loadtime:1.4679770469666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoffman' limit 1
loadtime:1.468043088913 / seconds
Query Executed:select id FROM `nc` where city='Hoffman' && SIC_code='7542'DB:business_master_new
loadtime:1.4689400196075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden Beach' limit 1
loadtime:1.4689979553223 / seconds
Query Executed:select id FROM `nc` where city='Holden Beach' && SIC_code='7542'DB:business_master_new
loadtime:1.4696390628815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollister' limit 1
loadtime:1.4696929454803 / seconds
Query Executed:select id FROM `nc` where city='Hollister' && SIC_code='7542'DB:business_master_new
loadtime:1.471039056778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:1.4711191654205 / seconds
Query Executed:select id FROM `nc` where city='Holly Ridge' && SIC_code='7542'DB:business_master_new
loadtime:1.4784650802612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:1.4785399436951 / seconds
Query Executed:select id FROM `nc` where city='Holly Springs' && SIC_code='7542'DB:business_master_new
loadtime:1.4877941608429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hookerton' limit 1
loadtime:1.4878749847412 / seconds
Query Executed:select id FROM `nc` where city='Hookerton' && SIC_code='7542'DB:business_master_new
loadtime:1.4891591072083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope Mills' limit 1
loadtime:1.4892270565033 / seconds
Query Executed:select id FROM `nc` where city='Hope Mills' && SIC_code='7542'DB:business_master_new
loadtime:1.4998860359192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horse Shoe' limit 1
loadtime:1.4999711513519 / seconds
Query Executed:select id FROM `nc` where city='Horse Shoe' && SIC_code='7542'DB:business_master_new
loadtime:1.5039401054382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:1.5040061473846 / seconds
Query Executed:select id FROM `nc` where city='Hot Springs' && SIC_code='7542'DB:business_master_new
loadtime:1.505951166153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubert' limit 1
loadtime:1.5060119628906 / seconds
Query Executed:select id FROM `nc` where city='Hubert' && SIC_code='7542'DB:business_master_new
loadtime:1.5092921257019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.5093610286713 / seconds
Query Executed:select id FROM `nc` where city='Hudson' && SIC_code='7542'DB:business_master_new
loadtime:1.5166449546814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntersville' limit 1
loadtime:1.5167090892792 / seconds
Query Executed:select id FROM `nc` where city='Huntersville' && SIC_code='7542'DB:business_master_new
loadtime:1.5317051410675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurdle Mills' limit 1
loadtime:1.5317749977112 / seconds
Query Executed:select id FROM `nc` where city='Hurdle Mills' && SIC_code='7542'DB:business_master_new
loadtime:1.5335149765015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Icard' limit 1
loadtime:1.5335750579834 / seconds
Query Executed:select id FROM `nc` where city='Icard' && SIC_code='7542'DB:business_master_new
loadtime:1.5344209671021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Trail' limit 1
loadtime:1.5344820022583 / seconds
Query Executed:select id FROM `nc` where city='Indian Trail' && SIC_code='7542'DB:business_master_new
loadtime:1.5484530925751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Station' limit 1
loadtime:1.5485370159149 / seconds
Query Executed:select id FROM `nc` where city='Iron Station' && SIC_code='7542'DB:business_master_new
loadtime:1.5508229732513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:1.5508990287781 / seconds
Query Executed:select id FROM `nc` where city='Ivanhoe' && SIC_code='7542'DB:business_master_new
loadtime:1.5519371032715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.5519990921021 / seconds
Query Executed:select id FROM `nc` where city='Jackson' && SIC_code='7542'DB:business_master_new
loadtime:1.5541379451752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Springs' limit 1
loadtime:1.5541970729828 / seconds
Query Executed:select id FROM `nc` where city='Jackson Springs' && SIC_code='7542'DB:business_master_new
loadtime:1.5552351474762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:1.5553081035614 / seconds
Query Executed:select id FROM `nc` where city='Jacksonville' && SIC_code='7542'DB:business_master_new
loadtime:1.5696640014648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.5697629451752 / seconds
Query Executed:select id FROM `nc` where city='Jamestown' && SIC_code='7542'DB:business_master_new
loadtime:1.5792770385742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:1.579362154007 / seconds
Query Executed:select id FROM `nc` where city='Jamesville' && SIC_code='7542'DB:business_master_new
loadtime:1.5810270309448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarvisburg' limit 1
loadtime:1.5810871124268 / seconds
Query Executed:select id FROM `nc` where city='Jarvisburg' && SIC_code='7542'DB:business_master_new
loadtime:1.5821130275726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.5821681022644 / seconds
Query Executed:select id FROM `nc` where city='Jefferson' && SIC_code='7542'DB:business_master_new
loadtime:1.5883231163025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonas Ridge' limit 1
loadtime:1.5883960723877 / seconds
Query Executed:select id FROM `nc` where city='Jonas Ridge' && SIC_code='7542'DB:business_master_new
loadtime:1.5889940261841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:1.589056968689 / seconds
Query Executed:select id FROM `nc` where city='Jonesville' && SIC_code='7542'DB:business_master_new
loadtime:1.5924401283264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julian' limit 1
loadtime:1.5925190448761 / seconds
Query Executed:select id FROM `nc` where city='Julian' && SIC_code='7542'DB:business_master_new
loadtime:1.5940730571747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kannapolis' limit 1
loadtime:1.5941350460052 / seconds
Query Executed:select id FROM `nc` where city='Kannapolis' && SIC_code='7542'DB:business_master_new
loadtime:1.6086020469666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelford' limit 1
loadtime:1.6086850166321 / seconds
Query Executed:select id FROM `nc` where city='Kelford' && SIC_code='7542'DB:business_master_new
loadtime:1.609265089035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelly' limit 1
loadtime:1.6093320846558 / seconds
Query Executed:select id FROM `nc` where city='Kelly' && SIC_code='7542'DB:business_master_new
loadtime:1.6102311611176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenansville' limit 1
loadtime:1.6102840900421 / seconds
Query Executed:select id FROM `nc` where city='Kenansville' && SIC_code='7542'DB:business_master_new
loadtime:1.6161949634552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenly' limit 1
loadtime:1.6162750720978 / seconds
Query Executed:select id FROM `nc` where city='Kenly' && SIC_code='7542'DB:business_master_new
loadtime:1.6217629909515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kernersville' limit 1
loadtime:1.6218371391296 / seconds
Query Executed:select id FROM `nc` where city='Kernersville' && SIC_code='7542'DB:business_master_new
loadtime:1.6360840797424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kill Devil Hills' limit 1
loadtime:1.6361701488495 / seconds
Query Executed:select id FROM `nc` where city='Kill Devil Hills' && SIC_code='7542'DB:business_master_new
loadtime:1.6505351066589 / seconds
Query loaded from cache:select * from geodata_geocity where city='King' limit 1
loadtime:1.6505999565125 / seconds
Query Executed:select id FROM `nc` where city='King' && SIC_code='7542'DB:business_master_new
loadtime:1.6610040664673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Mountain' limit 1
loadtime:1.661082983017 / seconds
Query Executed:select id FROM `nc` where city='Kings Mountain' && SIC_code='7542'DB:business_master_new
loadtime:1.6743559837341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstown' limit 1
loadtime:1.674446105957 / seconds
Query Executed:select id FROM `nc` where city='Kingstown' && SIC_code='7542'DB:business_master_new
loadtime:1.674901008606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinston' limit 1
loadtime:1.6749701499939 / seconds
Query Executed:select id FROM `nc` where city='Kinston' && SIC_code='7542'DB:business_master_new
loadtime:1.6898519992828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kipling' limit 1
loadtime:1.689934015274 / seconds
Query Executed:select id FROM `nc` where city='Kipling' && SIC_code='7542'DB:business_master_new
loadtime:1.6905219554901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittrell' limit 1
loadtime:1.6905839443207 / seconds
Query Executed:select id FROM `nc` where city='Kittrell' && SIC_code='7542'DB:business_master_new
loadtime:1.6922960281372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kitty Hawk' limit 1
loadtime:1.6923680305481 / seconds
Query Executed:select id FROM `nc` where city='Kitty Hawk' && SIC_code='7542'DB:business_master_new
loadtime:1.7069051265717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knightdale' limit 1
loadtime:1.7069849967957 / seconds
Query Executed:select id FROM `nc` where city='Knightdale' && SIC_code='7542'DB:business_master_new
loadtime:1.717677116394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knotts Island' limit 1
loadtime:1.7177529335022 / seconds
Query Executed:select id FROM `nc` where city='Knotts Island' && SIC_code='7542'DB:business_master_new
loadtime:1.718789100647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kure Beach' limit 1
loadtime:1.7188510894775 / seconds
Query Executed:select id FROM `nc` where city='Kure Beach' && SIC_code='7542'DB:business_master_new
loadtime:1.7209830284119 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Grange' limit 1
loadtime:1.7210440635681 / seconds
Query Executed:select id FROM `nc` where city='La Grange' && SIC_code='7542'DB:business_master_new
loadtime:1.7268459796906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Junaluska' limit 1
loadtime:1.7269160747528 / seconds
Query Executed:select id FROM `nc` where city='Lake Junaluska' && SIC_code='7542'DB:business_master_new
loadtime:1.7280640602112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Lure' limit 1
loadtime:1.7281241416931 / seconds
Query Executed:select id FROM `nc` where city='Lake Lure' && SIC_code='7542'DB:business_master_new
loadtime:1.7309100627899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Santeetlah' limit 1
loadtime:1.7309679985046 / seconds
Query Executed:select id FROM `nc` where city='Lake Santeetlah' && SIC_code='7542'DB:business_master_new
loadtime:1.7313549518585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Toxaway' limit 1
loadtime:1.7314209938049 / seconds
Query Executed:select id FROM `nc` where city='Lake Toxaway' && SIC_code='7542'DB:business_master_new
loadtime:1.7333099842072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Waccamaw' limit 1
loadtime:1.7333779335022 / seconds
Query Executed:select id FROM `nc` where city='Lake Waccamaw' && SIC_code='7542'DB:business_master_new
loadtime:1.7349810600281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:1.7350399494171 / seconds
Query Executed:select id FROM `nc` where city='Lakeview' && SIC_code='7542'DB:business_master_new
loadtime:1.7356970310211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landis' limit 1
loadtime:1.7357590198517 / seconds
Query Executed:select id FROM `nc` where city='Landis' && SIC_code='7542'DB:business_master_new
loadtime:1.7378079891205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:1.737869977951 / seconds
Query Executed:select id FROM `nc` where city='Lansing' && SIC_code='7542'DB:business_master_new
loadtime:1.7395629882812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lasker' limit 1
loadtime:1.7396430969238 / seconds
Query Executed:select id FROM `nc` where city='Lasker' && SIC_code='7542'DB:business_master_new
loadtime:1.7400670051575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lattimore' limit 1
loadtime:1.740128993988 / seconds
Query Executed:select id FROM `nc` where city='Lattimore' && SIC_code='7542'DB:business_master_new
loadtime:1.7409110069275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Hill' limit 1
loadtime:1.7409729957581 / seconds
Query Executed:select id FROM `nc` where city='Laurel Hill' && SIC_code='7542'DB:business_master_new
loadtime:1.7429420948029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Springs' limit 1
loadtime:1.7430181503296 / seconds
Query Executed:select id FROM `nc` where city='Laurel Springs' && SIC_code='7542'DB:business_master_new
loadtime:1.7444479465485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurinburg' limit 1
loadtime:1.7445111274719 / seconds
Query Executed:select id FROM `nc` where city='Laurinburg' && SIC_code='7542'DB:business_master_new
loadtime:1.7611939907074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawndale' limit 1
loadtime:1.7612760066986 / seconds
Query Executed:select id FROM `nc` where city='Lawndale' && SIC_code='7542'DB:business_master_new
loadtime:1.7642850875854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawsonville' limit 1
loadtime:1.7643549442291 / seconds
Query Executed:select id FROM `nc` where city='Lawsonville' && SIC_code='7542'DB:business_master_new
loadtime:1.7654521465302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leasburg' limit 1
loadtime:1.7655160427094 / seconds
Query Executed:select id FROM `nc` where city='Leasburg' && SIC_code='7542'DB:business_master_new
loadtime:1.766529083252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:1.7665920257568 / seconds
Query Executed:select id FROM `nc` where city='Leicester' && SIC_code='7542'DB:business_master_new
loadtime:1.771094083786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:1.7711589336395 / seconds
Query Executed:select id FROM `nc` where city='Leland' && SIC_code='7542'DB:business_master_new
loadtime:1.7806620597839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemon Springs' limit 1
loadtime:1.7807171344757 / seconds
Query Executed:select id FROM `nc` where city='Lemon Springs' && SIC_code='7542'DB:business_master_new
loadtime:1.7813920974731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenoir' limit 1
loadtime:1.7814500331879 / seconds
Query Executed:select id FROM `nc` where city='Lenoir' && SIC_code='7542'DB:business_master_new
loadtime:1.8088381290436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodville' limit 1
loadtime:1.8089399337769 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodville' && SIC_code='7542'DB:business_master_new
loadtime:1.8103499412537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodvl' limit 1
loadtime:1.8104109764099 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodvl' && SIC_code='7542'DB:business_master_new
loadtime:1.8108501434326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewisville' limit 1
loadtime:1.810909986496 / seconds
Query Executed:select id FROM `nc` where city='Lewisville' && SIC_code='7542'DB:business_master_new
loadtime:1.8161180019379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.8161821365356 / seconds
Query Executed:select id FROM `nc` where city='Lexington' && SIC_code='7542'DB:business_master_new
loadtime:1.8312621116638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:1.8313591480255 / seconds
Query Executed:select id FROM `nc` where city='Liberty' && SIC_code='7542'DB:business_master_new
loadtime:1.8392150402069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lilesville' limit 1
loadtime:1.8392901420593 / seconds
Query Executed:select id FROM `nc` where city='Lilesville' && SIC_code='7542'DB:business_master_new
loadtime:1.8408410549164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lillington' limit 1
loadtime:1.8408970832825 / seconds
Query Executed:select id FROM `nc` where city='Lillington' && SIC_code='7542'DB:business_master_new
loadtime:1.8514111042023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnton' limit 1
loadtime:1.8514969348907 / seconds
Query Executed:select id FROM `nc` where city='Lincolnton' && SIC_code='7542'DB:business_master_new
loadtime:1.8717889785767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:1.8718740940094 / seconds
Query Executed:select id FROM `nc` where city='Linden' && SIC_code='7542'DB:business_master_new
loadtime:1.8738059997559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:1.8738629817963 / seconds
Query Executed:select id FROM `nc` where city='Linville' && SIC_code='7542'DB:business_master_new
loadtime:1.8758330345154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville Falls' limit 1
loadtime:1.875892162323 / seconds
Query Executed:select id FROM `nc` where city='Linville Falls' && SIC_code='7542'DB:business_master_new
loadtime:1.8765871524811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.8766460418701 / seconds
Query Executed:select id FROM `nc` where city='Linwood' && SIC_code='7542'DB:business_master_new
loadtime:1.8782589435577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzerland' limit 1
loadtime:1.8783209323883 / seconds
Query Executed:select id FROM `nc` where city='Little Switzerland' && SIC_code='7542'DB:business_master_new
loadtime:1.8790991306305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzrlnd' limit 1
loadtime:1.8791661262512 / seconds
Query Executed:select id FROM `nc` where city='Little Switzrlnd' && SIC_code='7542'DB:business_master_new
loadtime:1.8795399665833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.8796000480652 / seconds
Query Executed:select id FROM `nc` where city='Littleton' && SIC_code='7542'DB:business_master_new
loadtime:1.8857460021973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust' limit 1
loadtime:1.8858060836792 / seconds
Query Executed:select id FROM `nc` where city='Locust' && SIC_code='7542'DB:business_master_new
loadtime:1.8889510631561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longwood' limit 1
loadtime:1.8890080451965 / seconds
Query Executed:select id FROM `nc` where city='Longwood' && SIC_code='7542'DB:business_master_new
loadtime:1.889778137207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisburg' limit 1
loadtime:1.8898410797119 / seconds
Query Executed:select id FROM `nc` where city='Louisburg' && SIC_code='7542'DB:business_master_new
loadtime:1.9026081562042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.9026870727539 / seconds
Query Executed:select id FROM `nc` where city='Lowell' && SIC_code='7542'DB:business_master_new
loadtime:1.9052360057831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowgap' limit 1
loadtime:1.905305147171 / seconds
Query Executed:select id FROM `nc` where city='Lowgap' && SIC_code='7542'DB:business_master_new
loadtime:1.9066481590271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowland' limit 1
loadtime:1.9067080020905 / seconds
Query Executed:select id FROM `nc` where city='Lowland' && SIC_code='7542'DB:business_master_new
loadtime:1.907210111618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucama' limit 1
loadtime:1.9072661399841 / seconds
Query Executed:select id FROM `nc` where city='Lucama' && SIC_code='7542'DB:business_master_new
loadtime:1.9092161655426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumber Bridge' limit 1
loadtime:1.9092781543732 / seconds
Query Executed:select id FROM `nc` where city='Lumber Bridge' && SIC_code='7542'DB:business_master_new
loadtime:1.9104931354523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:1.910551071167 / seconds
Query Executed:select id FROM `nc` where city='Lumberton' && SIC_code='7542'DB:business_master_new
loadtime:1.9256870746613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.9257719516754 / seconds
Query Executed:select id FROM `nc` where city='Lynn' && SIC_code='7542'DB:business_master_new
loadtime:1.9265379905701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macclesfield' limit 1
loadtime:1.9266049861908 / seconds
Query Executed:select id FROM `nc` where city='Macclesfield' && SIC_code='7542'DB:business_master_new
loadtime:1.9281499385834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:1.9282081127167 / seconds
Query Executed:select id FROM `nc` where city='Macon' && SIC_code='7542'DB:business_master_new
loadtime:1.9290931224823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.9291470050812 / seconds
Query Executed:select id FROM `nc` where city='Madison' && SIC_code='7542'DB:business_master_new
loadtime:1.9384219646454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maggie Valley' limit 1
loadtime:1.9385011196136 / seconds
Query Executed:select id FROM `nc` where city='Maggie Valley' && SIC_code='7542'DB:business_master_new
loadtime:1.9427859783173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:1.9428670406342 / seconds
Query Executed:select id FROM `nc` where city='Magnolia' && SIC_code='7542'DB:business_master_new
loadtime:1.9447040557861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maiden' limit 1
loadtime:1.9447660446167 / seconds
Query Executed:select id FROM `nc` where city='Maiden' && SIC_code='7542'DB:business_master_new
loadtime:1.9505231380463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mamers' limit 1
loadtime:1.9505860805511 / seconds
Query Executed:select id FROM `nc` where city='Mamers' && SIC_code='7542'DB:business_master_new
loadtime:1.951131105423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manns Harbor' limit 1
loadtime:1.9511830806732 / seconds
Query Executed:select id FROM `nc` where city='Manns Harbor' && SIC_code='7542'DB:business_master_new
loadtime:1.9522089958191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:1.9522740840912 / seconds
Query Executed:select id FROM `nc` where city='Manson' && SIC_code='7542'DB:business_master_new
loadtime:1.9532740116119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manteo' limit 1
loadtime:1.9533400535583 / seconds
Query Executed:select id FROM `nc` where city='Manteo' && SIC_code='7542'DB:business_master_new
loadtime:1.9614450931549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple' limit 1
loadtime:1.9615349769592 / seconds
Query Executed:select id FROM `nc` where city='Maple' && SIC_code='7542'DB:business_master_new
loadtime:1.9621570110321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Hill' limit 1
loadtime:1.9622120857239 / seconds
Query Executed:select id FROM `nc` where city='Maple Hill' && SIC_code='7542'DB:business_master_new
loadtime:1.9634599685669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble' limit 1
loadtime:1.9635241031647 / seconds
Query Executed:select id FROM `nc` where city='Marble' && SIC_code='7542'DB:business_master_new
loadtime:1.9648649692535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margarettsville' limit 1
loadtime:1.9649269580841 / seconds
Query Executed:select id FROM `nc` where city='Margarettsville' && SIC_code='7542'DB:business_master_new
loadtime:1.9654581546783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:1.9655230045319 / seconds
Query Executed:select id FROM `nc` where city='Marietta' && SIC_code='7542'DB:business_master_new
loadtime:1.9660401344299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.9660980701447 / seconds
Query Executed:select id FROM `nc` where city='Marion' && SIC_code='7542'DB:business_master_new
loadtime:1.9829659461975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mars Hill' limit 1
loadtime:1.9830520153046 / seconds
Query Executed:select id FROM `nc` where city='Mars Hill' && SIC_code='7542'DB:business_master_new
loadtime:1.9874310493469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:1.9875011444092 / seconds
Query Executed:select id FROM `nc` where city='Marshall' && SIC_code='7542'DB:business_master_new
loadtime:1.9931271076202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshallberg' limit 1
loadtime:1.9931881427765 / seconds
Query Executed:select id FROM `nc` where city='Marshallberg' && SIC_code='7542'DB:business_master_new
loadtime:1.9939999580383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshville' limit 1
loadtime:1.9940600395203 / seconds
Query Executed:select id FROM `nc` where city='Marshville' && SIC_code='7542'DB:business_master_new
loadtime:1.99915599823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marston' limit 1
loadtime:1.9992401599884 / seconds
Query Executed:select id FROM `nc` where city='Marston' && SIC_code='7542'DB:business_master_new
loadtime:2.000116109848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matthews' limit 1
loadtime:2.0001859664917 / seconds
Query Executed:select id FROM `nc` where city='Matthews' && SIC_code='7542'DB:business_master_new
loadtime:2.0419490337372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maury' limit 1
loadtime:2.0420610904694 / seconds
Query Executed:select id FROM `nc` where city='Maury' && SIC_code='7542'DB:business_master_new
loadtime:2.0428619384766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxton' limit 1
loadtime:2.0429229736328 / seconds
Query Executed:select id FROM `nc` where city='Maxton' && SIC_code='7542'DB:business_master_new
loadtime:2.0472731590271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayodan' limit 1
loadtime:2.0473420619965 / seconds
Query Executed:select id FROM `nc` where city='Mayodan' && SIC_code='7542'DB:business_master_new
loadtime:2.0498940944672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maysville' limit 1
loadtime:2.0499720573425 / seconds
Query Executed:select id FROM `nc` where city='Maysville' && SIC_code='7542'DB:business_master_new
loadtime:2.0528969764709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adenville' limit 1
loadtime:2.0529520511627 / seconds
Query Executed:select id FROM `nc` where city='Mc Adenville' && SIC_code='7542'DB:business_master_new
loadtime:2.0539450645447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farlan' limit 1
loadtime:2.0540089607239 / seconds
Query Executed:select id FROM `nc` where city='Mc Farlan' && SIC_code='7542'DB:business_master_new
loadtime:2.0545251369476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Grady' limit 1
loadtime:2.0545799732208 / seconds
Query Executed:select id FROM `nc` where city='Mc Grady' && SIC_code='7542'DB:business_master_new
loadtime:2.0552699565887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Leansville' limit 1
loadtime:2.0553350448608 / seconds
Query Executed:select id FROM `nc` where city='Mc Leansville' && SIC_code='7542'DB:business_master_new
loadtime:2.0586731433868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccain' limit 1
loadtime:2.0587511062622 / seconds
Query Executed:select id FROM `nc` where city='Mccain' && SIC_code='7542'DB:business_master_new
loadtime:2.0591650009155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccutcheon Field' limit 1
loadtime:2.0592241287231 / seconds
Query Executed:select id FROM `nc` where city='Mccutcheon Field' && SIC_code='7542'DB:business_master_new
loadtime:2.0597071647644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mebane' limit 1
loadtime:2.0597651004791 / seconds
Query Executed:select id FROM `nc` where city='Mebane' && SIC_code='7542'DB:business_master_new
loadtime:2.0738711357117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:2.0739569664001 / seconds
Query Executed:select id FROM `nc` where city='Merritt' && SIC_code='7542'DB:business_master_new
loadtime:2.0746259689331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Hill' limit 1
loadtime:2.0747010707855 / seconds
Query Executed:select id FROM `nc` where city='Merry Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.0757689476013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micaville' limit 1
loadtime:2.0758290290833 / seconds
Query Executed:select id FROM `nc` where city='Micaville' && SIC_code='7542'DB:business_master_new
loadtime:2.0766749382019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micro' limit 1
loadtime:2.0767350196838 / seconds
Query Executed:select id FROM `nc` where city='Micro' && SIC_code='7542'DB:business_master_new
loadtime:2.0775480270386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:2.0776071548462 / seconds
Query Executed:select id FROM `nc` where city='Middleburg' && SIC_code='7542'DB:business_master_new
loadtime:2.0783021450043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlesex' limit 1
loadtime:2.0783629417419 / seconds
Query Executed:select id FROM `nc` where city='Middlesex' && SIC_code='7542'DB:business_master_new
loadtime:2.0811569690704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:2.0812289714813 / seconds
Query Executed:select id FROM `nc` where city='Midland' && SIC_code='7542'DB:business_master_new
loadtime:2.0859611034393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway Park' limit 1
loadtime:2.0860290527344 / seconds
Query Executed:select id FROM `nc` where city='Midway Park' && SIC_code='7542'DB:business_master_new
loadtime:2.0877680778503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill Spring' limit 1
loadtime:2.0878319740295 / seconds
Query Executed:select id FROM `nc` where city='Mill Spring' && SIC_code='7542'DB:business_master_new
loadtime:2.0897390842438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Creek' limit 1
loadtime:2.0897929668427 / seconds
Query Executed:select id FROM `nc` where city='Millers Creek' && SIC_code='7542'DB:business_master_new
loadtime:2.0927860736847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills River' limit 1
loadtime:2.0928609371185 / seconds
Query Executed:select id FROM `nc` where city='Mills River' && SIC_code='7542'DB:business_master_new
loadtime:2.0933330059052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:2.0933980941772 / seconds
Query Executed:select id FROM `nc` where city='Milton' && SIC_code='7542'DB:business_master_new
loadtime:2.0942621231079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukee' limit 1
loadtime:2.0943410396576 / seconds
Query Executed:select id FROM `nc` where city='Milwaukee' && SIC_code='7542'DB:business_master_new
loadtime:2.094722032547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Springs' limit 1
loadtime:2.0947811603546 / seconds
Query Executed:select id FROM `nc` where city='Mineral Springs' && SIC_code='7542'DB:business_master_new
loadtime:2.0956349372864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minneapolis' limit 1
loadtime:2.095703125 / seconds
Query Executed:select id FROM `nc` where city='Minneapolis' && SIC_code='7542'DB:business_master_new
loadtime:2.0962021350861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Hill' limit 1
loadtime:2.096253156662 / seconds
Query Executed:select id FROM `nc` where city='Mint Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.0967049598694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Misenheimer' limit 1
loadtime:2.0967681407928 / seconds
Query Executed:select id FROM `nc` where city='Misenheimer' && SIC_code='7542'DB:business_master_new
loadtime:2.0973060131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mocksville' limit 1
loadtime:2.0973711013794 / seconds
Query Executed:select id FROM `nc` where city='Mocksville' && SIC_code='7542'DB:business_master_new
loadtime:2.1127619743347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncure' limit 1
loadtime:2.1128449440002 / seconds
Query Executed:select id FROM `nc` where city='Moncure' && SIC_code='7542'DB:business_master_new
loadtime:2.114531993866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.1145939826965 / seconds
Query Executed:select id FROM `nc` where city='Monroe' && SIC_code='7542'DB:business_master_new
loadtime:2.1296780109406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:2.1297750473022 / seconds
Query Executed:select id FROM `nc` where city='Montezuma' && SIC_code='7542'DB:business_master_new
loadtime:2.1302089691162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montreat' limit 1
loadtime:2.1302630901337 / seconds
Query Executed:select id FROM `nc` where city='Montreat' && SIC_code='7542'DB:business_master_new
loadtime:2.1311531066895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresboro' limit 1
loadtime:2.1312160491943 / seconds
Query Executed:select id FROM `nc` where city='Mooresboro' && SIC_code='7542'DB:business_master_new
loadtime:2.1333270072937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresville' limit 1
loadtime:2.1333861351013 / seconds
Query Executed:select id FROM `nc` where city='Mooresville' && SIC_code='7542'DB:business_master_new
loadtime:2.1474750041962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravian Falls' limit 1
loadtime:2.1475739479065 / seconds
Query Executed:select id FROM `nc` where city='Moravian Falls' && SIC_code='7542'DB:business_master_new
loadtime:2.1493520736694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morehead City' limit 1
loadtime:2.1494090557098 / seconds
Query Executed:select id FROM `nc` where city='Morehead City' && SIC_code='7542'DB:business_master_new
loadtime:2.1720170974731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganton' limit 1
loadtime:2.1721150875092 / seconds
Query Executed:select id FROM `nc` where city='Morganton' && SIC_code='7542'DB:business_master_new
loadtime:2.1866071224213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:2.1867020130157 / seconds
Query Executed:select id FROM `nc` where city='Morrisville' && SIC_code='7542'DB:business_master_new
loadtime:2.2047100067139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morven' limit 1
loadtime:2.2047910690308 / seconds
Query Executed:select id FROM `nc` where city='Morven' && SIC_code='7542'DB:business_master_new
loadtime:2.2062571048737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Airy' limit 1
loadtime:2.2063391208649 / seconds
Query Executed:select id FROM `nc` where city='Mount Airy' && SIC_code='7542'DB:business_master_new
loadtime:2.2206881046295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Gilead' limit 1
loadtime:2.2207751274109 / seconds
Query Executed:select id FROM `nc` where city='Mount Gilead' && SIC_code='7542'DB:business_master_new
loadtime:2.2245650291443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:2.2246279716492 / seconds
Query Executed:select id FROM `nc` where city='Mount Holly' && SIC_code='7542'DB:business_master_new
loadtime:2.2340250015259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Mourne' limit 1
loadtime:2.2341129779816 / seconds
Query Executed:select id FROM `nc` where city='Mount Mourne' && SIC_code='7542'DB:business_master_new
loadtime:2.2348389625549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:2.2349081039429 / seconds
Query Executed:select id FROM `nc` where city='Mount Olive' && SIC_code='7542'DB:business_master_new
loadtime:2.2448489665985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:2.244931936264 / seconds
Query Executed:select id FROM `nc` where city='Mount Pleasant' && SIC_code='7542'DB:business_master_new
loadtime:2.2489869594574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ulla' limit 1
loadtime:2.2490630149841 / seconds
Query Executed:select id FROM `nc` where city='Mount Ulla' && SIC_code='7542'DB:business_master_new
loadtime:2.2505879402161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:2.2506489753723 / seconds
Query Executed:select id FROM `nc` where city='Mountain Home' && SIC_code='7542'DB:business_master_new
loadtime:2.2516691684723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moyock' limit 1
loadtime:2.2517280578613 / seconds
Query Executed:select id FROM `nc` where city='Moyock' && SIC_code='7542'DB:business_master_new
loadtime:2.2557089328766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Airy' limit 1
loadtime:2.2557699680328 / seconds
Query Executed:select id FROM `nc` where city='Mt Airy' && SIC_code='7542'DB:business_master_new
loadtime:2.2564649581909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Gilead' limit 1
loadtime:2.2565381526947 / seconds
Query Executed:select id FROM `nc` where city='Mt Gilead' && SIC_code='7542'DB:business_master_new
loadtime:2.2569789886475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:2.2570390701294 / seconds
Query Executed:select id FROM `nc` where city='Mt Holly' && SIC_code='7542'DB:business_master_new
loadtime:2.2579820156097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Mourne' limit 1
loadtime:2.2580440044403 / seconds
Query Executed:select id FROM `nc` where city='Mt Mourne' && SIC_code='7542'DB:business_master_new
loadtime:2.2584719657898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:2.2585361003876 / seconds
Query Executed:select id FROM `nc` where city='Mt Olive' && SIC_code='7542'DB:business_master_new
loadtime:2.2590489387512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:2.259104013443 / seconds
Query Executed:select id FROM `nc` where city='Mt Pleasant' && SIC_code='7542'DB:business_master_new
loadtime:2.2597999572754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ulla' limit 1
loadtime:2.2598540782928 / seconds
Query Executed:select id FROM `nc` where city='Mt Ulla' && SIC_code='7542'DB:business_master_new
loadtime:2.2602250576019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murfreesboro' limit 1
loadtime:2.2602770328522 / seconds
Query Executed:select id FROM `nc` where city='Murfreesboro' && SIC_code='7542'DB:business_master_new
loadtime:2.2640640735626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murphy' limit 1
loadtime:2.2641429901123 / seconds
Query Executed:select id FROM `nc` where city='Murphy' && SIC_code='7542'DB:business_master_new
loadtime:2.2802040576935 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Topsail Beach' limit 1
loadtime:2.2802889347076 / seconds
Query Executed:select id FROM `nc` where city='N Topsail Beach' && SIC_code='7542'DB:business_master_new
loadtime:2.2807259559631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nags Head' limit 1
loadtime:2.2807819843292 / seconds
Query Executed:select id FROM `nc` where city='Nags Head' && SIC_code='7542'DB:business_master_new
loadtime:2.2902381420135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nakina' limit 1
loadtime:2.2903320789337 / seconds
Query Executed:select id FROM `nc` where city='Nakina' && SIC_code='7542'DB:business_master_new
loadtime:2.2913880348206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naples' limit 1
loadtime:2.2914481163025 / seconds
Query Executed:select id FROM `nc` where city='Naples' && SIC_code='7542'DB:business_master_new
loadtime:2.2923409938812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:2.2924101352692 / seconds
Query Executed:select id FROM `nc` where city='Nashville' && SIC_code='7542'DB:business_master_new
loadtime:2.3010630607605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navassa' limit 1
loadtime:2.3011450767517 / seconds
Query Executed:select id FROM `nc` where city='Navassa' && SIC_code='7542'DB:business_master_new
loadtime:2.3016231060028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nebo' limit 1
loadtime:2.3016800880432 / seconds
Query Executed:select id FROM `nc` where city='Nebo' && SIC_code='7542'DB:business_master_new
loadtime:2.3040201663971 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bern' limit 1
loadtime:2.3040840625763 / seconds
Query Executed:select id FROM `nc` where city='New Bern' && SIC_code='7542'DB:business_master_new
loadtime:2.3191080093384 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hill' limit 1
loadtime:2.3192019462585 / seconds
Query Executed:select id FROM `nc` where city='New Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.3206920623779 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:2.3207659721375 / seconds
Query Executed:select id FROM `nc` where city='New London' && SIC_code='7542'DB:business_master_new
loadtime:2.3236041069031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:2.3236689567566 / seconds
Query Executed:select id FROM `nc` where city='Newell' && SIC_code='7542'DB:business_master_new
loadtime:2.3245930671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newland' limit 1
loadtime:2.3246541023254 / seconds
Query Executed:select id FROM `nc` where city='Newland' && SIC_code='7542'DB:business_master_new
loadtime:2.3314249515533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:2.3315091133118 / seconds
Query Executed:select id FROM `nc` where city='Newport' && SIC_code='7542'DB:business_master_new
loadtime:2.3414640426636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:2.3415441513062 / seconds
Query Executed:select id FROM `nc` where city='Newton' && SIC_code='7542'DB:business_master_new
loadtime:2.3590710163116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Grove' limit 1
loadtime:2.3591530323029 / seconds
Query Executed:select id FROM `nc` where city='Newton Grove' && SIC_code='7542'DB:business_master_new
loadtime:2.3628280162811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norlina' limit 1
loadtime:2.3629021644592 / seconds
Query Executed:select id FROM `nc` where city='Norlina' && SIC_code='7542'DB:business_master_new
loadtime:2.3650760650635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norman' limit 1
loadtime:2.365149974823 / seconds
Query Executed:select id FROM `nc` where city='Norman' && SIC_code='7542'DB:business_master_new
loadtime:2.3657381534576 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Wilkesboro' limit 1
loadtime:2.365797996521 / seconds
Query Executed:select id FROM `nc` where city='North Wilkesboro' && SIC_code='7542'DB:business_master_new
loadtime:2.3840141296387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:2.3841180801392 / seconds
Query Executed:select id FROM `nc` where city='Norwood' && SIC_code='7542'DB:business_master_new
loadtime:2.3881289958954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:2.3882160186768 / seconds
Query Executed:select id FROM `nc` where city='Oak City' && SIC_code='7542'DB:business_master_new
loadtime:2.3893699645996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Island' limit 1
loadtime:2.3894290924072 / seconds
Query Executed:select id FROM `nc` where city='Oak Island' && SIC_code='7542'DB:business_master_new
loadtime:2.3954420089722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Ridge' limit 1
loadtime:2.3955190181732 / seconds
Query Executed:select id FROM `nc` where city='Oak Ridge' && SIC_code='7542'DB:business_master_new
loadtime:2.3986101150513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakboro' limit 1
loadtime:2.3986859321594 / seconds
Query Executed:select id FROM `nc` where city='Oakboro' && SIC_code='7542'DB:business_master_new
loadtime:2.4021670818329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Isle Beach' limit 1
loadtime:2.4022409915924 / seconds
Query Executed:select id FROM `nc` where city='Ocean Isle Beach' && SIC_code='7542'DB:business_master_new
loadtime:2.4089779853821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocracoke' limit 1
loadtime:2.4090509414673 / seconds
Query Executed:select id FROM `nc` where city='Ocracoke' && SIC_code='7542'DB:business_master_new
loadtime:2.4118440151215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Fort' limit 1
loadtime:2.4119031429291 / seconds
Query Executed:select id FROM `nc` where city='Old Fort' && SIC_code='7542'DB:business_master_new
loadtime:2.4149329662323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:2.4149961471558 / seconds
Query Executed:select id FROM `nc` where city='Olin' && SIC_code='7542'DB:business_master_new
loadtime:2.4159760475159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivia' limit 1
loadtime:2.4160361289978 / seconds
Query Executed:select id FROM `nc` where city='Olivia' && SIC_code='7542'DB:business_master_new
loadtime:2.417051076889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriental' limit 1
loadtime:2.4171130657196 / seconds
Query Executed:select id FROM `nc` where city='Oriental' && SIC_code='7542'DB:business_master_new
loadtime:2.4193320274353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orrum' limit 1
loadtime:2.4193911552429 / seconds
Query Executed:select id FROM `nc` where city='Orrum' && SIC_code='7542'DB:business_master_new
loadtime:2.4203791618347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otto' limit 1
loadtime:2.4204411506653 / seconds
Query Executed:select id FROM `nc` where city='Otto' && SIC_code='7542'DB:business_master_new
loadtime:2.4216871261597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:2.4217481613159 / seconds
Query Executed:select id FROM `nc` where city='Oxford' && SIC_code='7542'DB:business_master_new
loadtime:2.4375081062317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pantego' limit 1
loadtime:2.4375901222229 / seconds
Query Executed:select id FROM `nc` where city='Pantego' && SIC_code='7542'DB:business_master_new
loadtime:2.4399180412292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkton' limit 1
loadtime:2.4399840831757 / seconds
Query Executed:select id FROM `nc` where city='Parkton' && SIC_code='7542'DB:business_master_new
loadtime:2.4419269561768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmele' limit 1
loadtime:2.4419851303101 / seconds
Query Executed:select id FROM `nc` where city='Parmele' && SIC_code='7542'DB:business_master_new
loadtime:2.4424719810486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:2.442535161972 / seconds
Query Executed:select id FROM `nc` where city='Patterson' && SIC_code='7542'DB:business_master_new
loadtime:2.4432020187378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Creek' limit 1
loadtime:2.4432649612427 / seconds
Query Executed:select id FROM `nc` where city='Paw Creek' && SIC_code='7542'DB:business_master_new
loadtime:2.4444029331207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peachland' limit 1
loadtime:2.444461107254 / seconds
Query Executed:select id FROM `nc` where city='Peachland' && SIC_code='7542'DB:business_master_new
loadtime:2.4462101459503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:2.4462840557098 / seconds
Query Executed:select id FROM `nc` where city='Pelham' && SIC_code='7542'DB:business_master_new
loadtime:2.4476251602173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:2.4476871490479 / seconds
Query Executed:select id FROM `nc` where city='Pembroke' && SIC_code='7542'DB:business_master_new
loadtime:2.4534680843353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:2.4535520076752 / seconds
Query Executed:select id FROM `nc` where city='Pendleton' && SIC_code='7542'DB:business_master_new
loadtime:2.4542379379272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penland' limit 1
loadtime:2.4542989730835 / seconds
Query Executed:select id FROM `nc` where city='Penland' && SIC_code='7542'DB:business_master_new
loadtime:2.4548671245575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penrose' limit 1
loadtime:2.4549291133881 / seconds
Query Executed:select id FROM `nc` where city='Penrose' && SIC_code='7542'DB:business_master_new
loadtime:2.4558861255646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pfafftown' limit 1
loadtime:2.4559481143951 / seconds
Query Executed:select id FROM `nc` where city='Pfafftown' && SIC_code='7542'DB:business_master_new
loadtime:2.4599831104279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pikeville' limit 1
loadtime:2.4600441455841 / seconds
Query Executed:select id FROM `nc` where city='Pikeville' && SIC_code='7542'DB:business_master_new
loadtime:2.462996006012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mountain' limit 1
loadtime:2.4630610942841 / seconds
Query Executed:select id FROM `nc` where city='Pilot Mountain' && SIC_code='7542'DB:business_master_new
loadtime:2.4694521427155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hall' limit 1
loadtime:2.4695341587067 / seconds
Query Executed:select id FROM `nc` where city='Pine Hall' && SIC_code='7542'DB:business_master_new
loadtime:2.4702179431915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Knoll Shrs' limit 1
loadtime:2.4702789783478 / seconds
Query Executed:select id FROM `nc` where city='Pine Knoll Shrs' && SIC_code='7542'DB:business_master_new
loadtime:2.4707119464874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Level' limit 1
loadtime:2.4707770347595 / seconds
Query Executed:select id FROM `nc` where city='Pine Level' && SIC_code='7542'DB:business_master_new
loadtime:2.4721231460571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinebluff' limit 1
loadtime:2.4721820354462 / seconds
Query Executed:select id FROM `nc` where city='Pinebluff' && SIC_code='7542'DB:business_master_new
loadtime:2.4735670089722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:2.4736280441284 / seconds
Query Executed:select id FROM `nc` where city='Pinehurst' && SIC_code='7542'DB:business_master_new
loadtime:2.4857211112976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineola' limit 1
loadtime:2.4857921600342 / seconds
Query Executed:select id FROM `nc` where city='Pineola' && SIC_code='7542'DB:business_master_new
loadtime:2.4866530895233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetops' limit 1
loadtime:2.4867150783539 / seconds
Query Executed:select id FROM `nc` where city='Pinetops' && SIC_code='7542'DB:business_master_new
loadtime:2.4893600940704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetown' limit 1
loadtime:2.4894199371338 / seconds
Query Executed:select id FROM `nc` where city='Pinetown' && SIC_code='7542'DB:business_master_new
loadtime:2.4909889698029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:2.4910490512848 / seconds
Query Executed:select id FROM `nc` where city='Pineville' && SIC_code='7542'DB:business_master_new
loadtime:2.5056240558624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Creek' limit 1
loadtime:2.505707025528 / seconds
Query Executed:select id FROM `nc` where city='Piney Creek' && SIC_code='7542'DB:business_master_new
loadtime:2.5065310001373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pink Hill' limit 1
loadtime:2.5065970420837 / seconds
Query Executed:select id FROM `nc` where city='Pink Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.5103690624237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinnacle' limit 1
loadtime:2.5104501247406 / seconds
Query Executed:select id FROM `nc` where city='Pinnacle' && SIC_code='7542'DB:business_master_new
loadtime:2.5129029750824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah Forest' limit 1
loadtime:2.5129749774933 / seconds
Query Executed:select id FROM `nc` where city='Pisgah Forest' && SIC_code='7542'DB:business_master_new
loadtime:2.5170340538025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:2.5171060562134 / seconds
Query Executed:select id FROM `nc` where city='Pittsboro' && SIC_code='7542'DB:business_master_new
loadtime:2.5294070243835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Garden' limit 1
loadtime:2.5294880867004 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Garden' && SIC_code='7542'DB:business_master_new
loadtime:2.5327320098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:2.5328099727631 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.5334351062775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plumtree' limit 1
loadtime:2.5335111618042 / seconds
Query Executed:select id FROM `nc` where city='Plumtree' && SIC_code='7542'DB:business_master_new
loadtime:2.5341341495514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:2.5341939926147 / seconds
Query Executed:select id FROM `nc` where city='Plymouth' && SIC_code='7542'DB:business_master_new
loadtime:2.5406279563904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Harbor' limit 1
loadtime:2.5406889915466 / seconds
Query Executed:select id FROM `nc` where city='Point Harbor' && SIC_code='7542'DB:business_master_new
loadtime:2.5421941280365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkton' limit 1
loadtime:2.5422530174255 / seconds
Query Executed:select id FROM `nc` where city='Polkton' && SIC_code='7542'DB:business_master_new
loadtime:2.5443270206451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkville' limit 1
loadtime:2.5443861484528 / seconds
Query Executed:select id FROM `nc` where city='Polkville' && SIC_code='7542'DB:business_master_new
loadtime:2.5452151298523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollocksville' limit 1
loadtime:2.5452690124512 / seconds
Query Executed:select id FROM `nc` where city='Pollocksville' && SIC_code='7542'DB:business_master_new
loadtime:2.5470380783081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope A F B' limit 1
loadtime:2.5470991134644 / seconds
Query Executed:select id FROM `nc` where city='Pope A F B' && SIC_code='7542'DB:business_master_new
loadtime:2.5475280284882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope Afb' limit 1
loadtime:2.5475959777832 / seconds
Query Executed:select id FROM `nc` where city='Pope Afb' && SIC_code='7542'DB:business_master_new
loadtime:2.5481250286102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplar Branch' limit 1
loadtime:2.5481841564178 / seconds
Query Executed:select id FROM `nc` where city='Poplar Branch' && SIC_code='7542'DB:business_master_new
loadtime:2.5491211414337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potecasi' limit 1
loadtime:2.5491750240326 / seconds
Query Executed:select id FROM `nc` where city='Potecasi' && SIC_code='7542'DB:business_master_new
loadtime:2.5496759414673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powells Point' limit 1
loadtime:2.5497360229492 / seconds
Query Executed:select id FROM `nc` where city='Powells Point' && SIC_code='7542'DB:business_master_new
loadtime:2.5517721176147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powellsville' limit 1
loadtime:2.5518460273743 / seconds
Query Executed:select id FROM `nc` where city='Powellsville' && SIC_code='7542'DB:business_master_new
loadtime:2.5524389743805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:2.5524990558624 / seconds
Query Executed:select id FROM `nc` where city='Princeton' && SIC_code='7542'DB:business_master_new
loadtime:2.5560829639435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeville' limit 1
loadtime:2.5561611652374 / seconds
Query Executed:select id FROM `nc` where city='Princeville' && SIC_code='7542'DB:business_master_new
loadtime:2.5565700531006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorville' limit 1
loadtime:2.5566289424896 / seconds
Query Executed:select id FROM `nc` where city='Proctorville' && SIC_code='7542'DB:business_master_new
loadtime:2.557177066803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect Hill' limit 1
loadtime:2.5572409629822 / seconds
Query Executed:select id FROM `nc` where city='Prospect Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.5581450462341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:2.5582070350647 / seconds
Query Executed:select id FROM `nc` where city='Providence' && SIC_code='7542'DB:business_master_new
loadtime:2.5594320297241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purlear' limit 1
loadtime:2.5595021247864 / seconds
Query Executed:select id FROM `nc` where city='Purlear' && SIC_code='7542'DB:business_master_new
loadtime:2.5607430934906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raeford' limit 1
loadtime:2.560802936554 / seconds
Query Executed:select id FROM `nc` where city='Raeford' && SIC_code='7542'DB:business_master_new
loadtime:2.5719511508942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:2.5720291137695 / seconds
Query Executed:select id FROM `nc` where city='Raleigh' && SIC_code='7542'DB:business_master_new
loadtime:2.587217092514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramseur' limit 1
loadtime:2.5874440670013 / seconds
Query Executed:select id FROM `nc` where city='Ramseur' && SIC_code='7542'DB:business_master_new
loadtime:2.5929930210114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randleman' limit 1
loadtime:2.5930690765381 / seconds
Query Executed:select id FROM `nc` where city='Randleman' && SIC_code='7542'DB:business_master_new
loadtime:2.6027820110321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:2.6028649806976 / seconds
Query Executed:select id FROM `nc` where city='Red Oak' && SIC_code='7542'DB:business_master_new
loadtime:2.6036870479584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Springs' limit 1
loadtime:2.6037540435791 / seconds
Query Executed:select id FROM `nc` where city='Red Springs' && SIC_code='7542'DB:business_master_new
loadtime:2.6085751056671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidsville' limit 1
loadtime:2.6086530685425 / seconds
Query Executed:select id FROM `nc` where city='Reidsville' && SIC_code='7542'DB:business_master_new
loadtime:2.6309289932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Resrch Trngle Pk' limit 1
loadtime:2.6310260295868 / seconds
Query Executed:select id FROM `nc` where city='Resrch Trngle Pk' && SIC_code='7542'DB:business_master_new
loadtime:2.6316001415253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rex' limit 1
loadtime:2.6316609382629 / seconds
Query Executed:select id FROM `nc` where city='Rex' && SIC_code='7542'DB:business_master_new
loadtime:2.6321380138397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodhiss' limit 1
loadtime:2.6322000026703 / seconds
Query Executed:select id FROM `nc` where city='Rhodhiss' && SIC_code='7542'DB:business_master_new
loadtime:2.6327760219574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Square' limit 1
loadtime:2.6328339576721 / seconds
Query Executed:select id FROM `nc` where city='Rich Square' && SIC_code='7542'DB:business_master_new
loadtime:2.6346960067749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:2.6347560882568 / seconds
Query Executed:select id FROM `nc` where city='Richfield' && SIC_code='7542'DB:business_master_new
loadtime:2.6367061138153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:2.63676404953 / seconds
Query Executed:select id FROM `nc` where city='Richlands' && SIC_code='7542'DB:business_master_new
loadtime:2.6435160636902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgecrest' limit 1
loadtime:2.6435899734497 / seconds
Query Executed:select id FROM `nc` where city='Ridgecrest' && SIC_code='7542'DB:business_master_new
loadtime:2.6442430019379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:2.6443059444427 / seconds
Query Executed:select id FROM `nc` where city='Ridgeway' && SIC_code='7542'DB:business_master_new
loadtime:2.644809961319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riegelwood' limit 1
loadtime:2.6448731422424 / seconds
Query Executed:select id FROM `nc` where city='Riegelwood' && SIC_code='7542'DB:business_master_new
loadtime:2.647262096405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke Rapids' limit 1
loadtime:2.6473309993744 / seconds
Query Executed:select id FROM `nc` where city='Roanoke Rapids' && SIC_code='7542'DB:business_master_new
loadtime:2.6652100086212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring Gap' limit 1
loadtime:2.6652970314026 / seconds
Query Executed:select id FROM `nc` where city='Roaring Gap' && SIC_code='7542'DB:business_master_new
loadtime:2.6662001609802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring River' limit 1
loadtime:2.6662650108337 / seconds
Query Executed:select id FROM `nc` where city='Roaring River' && SIC_code='7542'DB:business_master_new
loadtime:2.6680271625519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbins' limit 1
loadtime:2.6681020259857 / seconds
Query Executed:select id FROM `nc` where city='Robbins' && SIC_code='7542'DB:business_master_new
loadtime:2.6712901592255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbinsville' limit 1
loadtime:2.6713621616364 / seconds
Query Executed:select id FROM `nc` where city='Robbinsville' && SIC_code='7542'DB:business_master_new
loadtime:2.6767740249634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robersonville' limit 1
loadtime:2.676833152771 / seconds
Query Executed:select id FROM `nc` where city='Robersonville' && SIC_code='7542'DB:business_master_new
loadtime:2.6800191402435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockingham' limit 1
loadtime:2.6800811290741 / seconds
Query Executed:select id FROM `nc` where city='Rockingham' && SIC_code='7542'DB:business_master_new
loadtime:2.6975419521332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:2.6976320743561 / seconds
Query Executed:select id FROM `nc` where city='Rockwell' && SIC_code='7542'DB:business_master_new
loadtime:2.701956987381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:2.7020239830017 / seconds
Query Executed:select id FROM `nc` where city='Rocky Mount' && SIC_code='7542'DB:business_master_new
loadtime:2.7174479961395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Point' limit 1
loadtime:2.7175619602203 / seconds
Query Executed:select id FROM `nc` where city='Rocky Point' && SIC_code='7542'DB:business_master_new
loadtime:2.7211439609528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodanthe' limit 1
loadtime:2.7212100028992 / seconds
Query Executed:select id FROM `nc` where city='Rodanthe' && SIC_code='7542'DB:business_master_new
loadtime:2.7225060462952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roduco' limit 1
loadtime:2.7225730419159 / seconds
Query Executed:select id FROM `nc` where city='Roduco' && SIC_code='7542'DB:business_master_new
loadtime:2.723032951355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolesville' limit 1
loadtime:2.7230920791626 / seconds
Query Executed:select id FROM `nc` where city='Rolesville' && SIC_code='7542'DB:business_master_new
loadtime:2.7253260612488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ronda' limit 1
loadtime:2.7254021167755 / seconds
Query Executed:select id FROM `nc` where city='Ronda' && SIC_code='7542'DB:business_master_new
loadtime:2.7272400856018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roper' limit 1
loadtime:2.727324962616 / seconds
Query Executed:select id FROM `nc` where city='Roper' && SIC_code='7542'DB:business_master_new
loadtime:2.7293319702148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:2.7293951511383 / seconds
Query Executed:select id FROM `nc` where city='Rose Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.7339639663696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseboro' limit 1
loadtime:2.7340381145477 / seconds
Query Executed:select id FROM `nc` where city='Roseboro' && SIC_code='7542'DB:business_master_new
loadtime:2.7389290332794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosman' limit 1
loadtime:2.7390069961548 / seconds
Query Executed:select id FROM `nc` where city='Rosman' && SIC_code='7542'DB:business_master_new
loadtime:2.7406530380249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rougemont' limit 1
loadtime:2.7407259941101 / seconds
Query Executed:select id FROM `nc` where city='Rougemont' && SIC_code='7542'DB:business_master_new
loadtime:2.7433960437775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowland' limit 1
loadtime:2.7434740066528 / seconds
Query Executed:select id FROM `nc` where city='Rowland' && SIC_code='7542'DB:business_master_new
loadtime:2.7464201450348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxboro' limit 1
loadtime:2.74649310112 / seconds
Query Executed:select id FROM `nc` where city='Roxboro' && SIC_code='7542'DB:business_master_new
loadtime:2.7655720710754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxobel' limit 1
loadtime:2.7656700611115 / seconds
Query Executed:select id FROM `nc` where city='Roxobel' && SIC_code='7542'DB:business_master_new
loadtime:2.7663950920105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:2.7664580345154 / seconds
Query Executed:select id FROM `nc` where city='Ruffin' && SIC_code='7542'DB:business_master_new
loadtime:2.768049955368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Hall' limit 1
loadtime:2.7681119441986 / seconds
Query Executed:select id FROM `nc` where city='Rural Hall' && SIC_code='7542'DB:business_master_new
loadtime:2.7738449573517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford Clg' limit 1
loadtime:2.7739281654358 / seconds
Query Executed:select id FROM `nc` where city='Rutherford Clg' && SIC_code='7542'DB:business_master_new
loadtime:2.7743849754333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford College' limit 1
loadtime:2.7744469642639 / seconds
Query Executed:select id FROM `nc` where city='Rutherford College' && SIC_code='7542'DB:business_master_new
loadtime:2.7755401134491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherfordton' limit 1
loadtime:2.7756011486053 / seconds
Query Executed:select id FROM `nc` where city='Rutherfordton' && SIC_code='7542'DB:business_master_new
loadtime:2.7868919372559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Pauls' limit 1
loadtime:2.7869720458984 / seconds
Query Executed:select id FROM `nc` where city='Saint Pauls' && SIC_code='7542'DB:business_master_new
loadtime:2.7923901081085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salemburg' limit 1
loadtime:2.7924721240997 / seconds
Query Executed:select id FROM `nc` where city='Salemburg' && SIC_code='7542'DB:business_master_new
loadtime:2.7944600582123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:2.794527053833 / seconds
Query Executed:select id FROM `nc` where city='Salisbury' && SIC_code='7542'DB:business_master_new
loadtime:2.8095030784607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salter Path' limit 1
loadtime:2.8095951080322 / seconds
Query Executed:select id FROM `nc` where city='Salter Path' && SIC_code='7542'DB:business_master_new
loadtime:2.8107769489288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:2.8108329772949 / seconds
Query Executed:select id FROM `nc` where city='Saluda' && SIC_code='7542'DB:business_master_new
loadtime:2.8130769729614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salvo' limit 1
loadtime:2.8131380081177 / seconds
Query Executed:select id FROM `nc` where city='Salvo' && SIC_code='7542'DB:business_master_new
loadtime:2.8138201236725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Ridge' limit 1
loadtime:2.8138780593872 / seconds
Query Executed:select id FROM `nc` where city='Sandy Ridge' && SIC_code='7542'DB:business_master_new
loadtime:2.8152301311493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:2.815288066864 / seconds
Query Executed:select id FROM `nc` where city='Sanford' && SIC_code='7542'DB:business_master_new
loadtime:2.8293690681458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapphire' limit 1
loadtime:2.8294661045074 / seconds
Query Executed:select id FROM `nc` where city='Sapphire' && SIC_code='7542'DB:business_master_new
loadtime:2.8308820724487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga' limit 1
loadtime:2.8309531211853 / seconds
Query Executed:select id FROM `nc` where city='Saratoga' && SIC_code='7542'DB:business_master_new
loadtime:2.8315441608429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxapahaw' limit 1
loadtime:2.8316061496735 / seconds
Query Executed:select id FROM `nc` where city='Saxapahaw' && SIC_code='7542'DB:business_master_new
loadtime:2.832230091095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scaly Mountain' limit 1
loadtime:2.8322861194611 / seconds
Query Executed:select id FROM `nc` where city='Scaly Mountain' && SIC_code='7542'DB:business_master_new
loadtime:2.8331830501556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland Neck' limit 1
loadtime:2.8332450389862 / seconds
Query Executed:select id FROM `nc` where city='Scotland Neck' && SIC_code='7542'DB:business_master_new
loadtime:2.8367471694946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:2.8368010520935 / seconds
Query Executed:select id FROM `nc` where city='Scotts' && SIC_code='7542'DB:business_master_new
loadtime:2.8373351097107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:2.837394952774 / seconds
Query Executed:select id FROM `nc` where city='Scottville' && SIC_code='7542'DB:business_master_new
loadtime:2.8379180431366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:2.8379781246185 / seconds
Query Executed:select id FROM `nc` where city='Scranton' && SIC_code='7542'DB:business_master_new
loadtime:2.8386099338531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaboard' limit 1
loadtime:2.8386790752411 / seconds
Query Executed:select id FROM `nc` where city='Seaboard' && SIC_code='7542'DB:business_master_new
loadtime:2.8398730754852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seagrove' limit 1
loadtime:2.8399319648743 / seconds
Query Executed:select id FROM `nc` where city='Seagrove' && SIC_code='7542'DB:business_master_new
loadtime:2.8434610366821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealevel' limit 1
loadtime:2.8435430526733 / seconds
Query Executed:select id FROM `nc` where city='Sealevel' && SIC_code='7542'DB:business_master_new
loadtime:2.8442370891571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedalia' limit 1
loadtime:2.8442950248718 / seconds
Query Executed:select id FROM `nc` where city='Sedalia' && SIC_code='7542'DB:business_master_new
loadtime:2.8448390960693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:2.8449051380157 / seconds
Query Executed:select id FROM `nc` where city='Selma' && SIC_code='7542'DB:business_master_new
loadtime:2.8536660671234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semora' limit 1
loadtime:2.8537399768829 / seconds
Query Executed:select id FROM `nc` where city='Semora' && SIC_code='7542'DB:business_master_new
loadtime:2.8547899723053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semr Johnson Afb' limit 1
loadtime:2.8548550605774 / seconds
Query Executed:select id FROM `nc` where city='Semr Johnson Afb' && SIC_code='7542'DB:business_master_new
loadtime:2.8552441596985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Devils' limit 1
loadtime:2.8553199768066 / seconds
Query Executed:select id FROM `nc` where city='Seven Devils' && SIC_code='7542'DB:business_master_new
loadtime:2.8556959629059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Springs' limit 1
loadtime:2.8557510375977 / seconds
Query Executed:select id FROM `nc` where city='Seven Springs' && SIC_code='7542'DB:business_master_new
loadtime:2.8573760986328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:2.8574371337891 / seconds
Query Executed:select id FROM `nc` where city='Severn' && SIC_code='7542'DB:business_master_new
loadtime:2.8580329418182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shallotte' limit 1
loadtime:2.8580939769745 / seconds
Query Executed:select id FROM `nc` where city='Shallotte' && SIC_code='7542'DB:business_master_new
loadtime:2.8708951473236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:2.8709859848022 / seconds
Query Executed:select id FROM `nc` where city='Shannon' && SIC_code='7542'DB:business_master_new
loadtime:2.8725340366364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:2.8725979328156 / seconds
Query Executed:select id FROM `nc` where city='Sharpsburg' && SIC_code='7542'DB:business_master_new
loadtime:2.8746731281281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawboro' limit 1
loadtime:2.8747351169586 / seconds
Query Executed:select id FROM `nc` where city='Shawboro' && SIC_code='7542'DB:business_master_new
loadtime:2.8757560253143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:2.8758151531219 / seconds
Query Executed:select id FROM `nc` where city='Shelby' && SIC_code='7542'DB:business_master_new
loadtime:2.9082391262054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrills Ford' limit 1
loadtime:2.9083421230316 / seconds
Query Executed:select id FROM `nc` where city='Sherrills Ford' && SIC_code='7542'DB:business_master_new
loadtime:2.9109590053558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:2.9110181331635 / seconds
Query Executed:select id FROM `nc` where city='Shiloh' && SIC_code='7542'DB:business_master_new
loadtime:2.9119100570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siler City' limit 1
loadtime:2.9119701385498 / seconds
Query Executed:select id FROM `nc` where city='Siler City' && SIC_code='7542'DB:business_master_new
loadtime:2.9235811233521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siloam' limit 1
loadtime:2.9236590862274 / seconds
Query Executed:select id FROM `nc` where city='Siloam' && SIC_code='7542'DB:business_master_new
loadtime:2.9246189594269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpson' limit 1
loadtime:2.924684047699 / seconds
Query Executed:select id FROM `nc` where city='Simpson' && SIC_code='7542'DB:business_master_new
loadtime:2.925411939621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sims' limit 1
loadtime:2.9254660606384 / seconds
Query Executed:select id FROM `nc` where city='Sims' && SIC_code='7542'DB:business_master_new
loadtime:2.9269931316376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skyland' limit 1
loadtime:2.9270679950714 / seconds
Query Executed:select id FROM `nc` where city='Skyland' && SIC_code='7542'DB:business_master_new
loadtime:2.9287450313568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:2.9288070201874 / seconds
Query Executed:select id FROM `nc` where city='Smithfield' && SIC_code='7542'DB:business_master_new
loadtime:2.9489929676056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:2.9490749835968 / seconds
Query Executed:select id FROM `nc` where city='Smyrna' && SIC_code='7542'DB:business_master_new
loadtime:2.9499881267548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sneads Ferry' limit 1
loadtime:2.9500501155853 / seconds
Query Executed:select id FROM `nc` where city='Sneads Ferry' && SIC_code='7542'DB:business_master_new
loadtime:2.9549391269684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Camp' limit 1
loadtime:2.9550139904022 / seconds
Query Executed:select id FROM `nc` where city='Snow Camp' && SIC_code='7542'DB:business_master_new
loadtime:2.9573330879211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Hill' limit 1
loadtime:2.9573979377747 / seconds
Query Executed:select id FROM `nc` where city='Snow Hill' && SIC_code='7542'DB:business_master_new
loadtime:2.9636011123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sophia' limit 1
loadtime:2.9636709690094 / seconds
Query Executed:select id FROM `nc` where city='Sophia' && SIC_code='7542'DB:business_master_new
loadtime:2.9668271541595 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Brunswick' limit 1
loadtime:2.9668879508972 / seconds
Query Executed:select id FROM `nc` where city='South Brunswick' && SIC_code='7542'DB:business_master_new
loadtime:2.9675259590149 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Mills' limit 1
loadtime:2.9675860404968 / seconds
Query Executed:select id FROM `nc` where city='South Mills' && SIC_code='7542'DB:business_master_new
loadtime:2.9689800739288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Pines' limit 1
loadtime:2.9690389633179 / seconds
Query Executed:select id FROM `nc` where city='Southern Pines' && SIC_code='7542'DB:business_master_new
loadtime:2.9852571487427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Shores' limit 1
loadtime:2.9853420257568 / seconds
Query Executed:select id FROM `nc` where city='Southern Shores' && SIC_code='7542'DB:business_master_new
loadtime:2.9858419895172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southmont' limit 1
loadtime:2.9859080314636 / seconds
Query Executed:select id FROM `nc` where city='Southmont' && SIC_code='7542'DB:business_master_new
loadtime:2.9868030548096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:2.9868640899658 / seconds
Query Executed:select id FROM `nc` where city='Southport' && SIC_code='7542'DB:business_master_new
loadtime:3.0013451576233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:3.0014369487762 / seconds
Query Executed:select id FROM `nc` where city='Sparta' && SIC_code='7542'DB:business_master_new
loadtime:3.0089499950409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speed' limit 1
loadtime:3.0090301036835 / seconds
Query Executed:select id FROM `nc` where city='Speed' && SIC_code='7542'DB:business_master_new
loadtime:3.0095450878143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:3.0096070766449 / seconds
Query Executed:select id FROM `nc` where city='Spencer' && SIC_code='7542'DB:business_master_new
loadtime:3.0121109485626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spindale' limit 1
loadtime:3.0121841430664 / seconds
Query Executed:select id FROM `nc` where city='Spindale' && SIC_code='7542'DB:business_master_new
loadtime:3.0163431167603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Hope' limit 1
loadtime:3.0164160728455 / seconds
Query Executed:select id FROM `nc` where city='Spring Hope' && SIC_code='7542'DB:business_master_new
loadtime:3.0206611156464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:3.0207231044769 / seconds
Query Executed:select id FROM `nc` where city='Spring Lake' && SIC_code='7542'DB:business_master_new
loadtime:3.0308859348297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce Pine' limit 1
loadtime:3.0309550762177 / seconds
Query Executed:select id FROM `nc` where city='Spruce Pine' && SIC_code='7542'DB:business_master_new
loadtime:3.040050983429 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Pauls' limit 1
loadtime:3.0401289463043 / seconds
Query Executed:select id FROM `nc` where city='St Pauls' && SIC_code='7542'DB:business_master_new
loadtime:3.0405580997467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacy' limit 1
loadtime:3.0406141281128 / seconds
Query Executed:select id FROM `nc` where city='Stacy' && SIC_code='7542'DB:business_master_new
loadtime:3.0411350727081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staley' limit 1
loadtime:3.0411930084229 / seconds
Query Executed:select id FROM `nc` where city='Staley' && SIC_code='7542'DB:business_master_new
loadtime:3.0429120063782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stallings' limit 1
loadtime:3.0429711341858 / seconds
Query Executed:select id FROM `nc` where city='Stallings' && SIC_code='7542'DB:business_master_new
loadtime:3.0433881282806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:3.0434589385986 / seconds
Query Executed:select id FROM `nc` where city='Stanfield' && SIC_code='7542'DB:business_master_new
loadtime:3.0454230308533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:3.0454969406128 / seconds
Query Executed:select id FROM `nc` where city='Stanley' && SIC_code='7542'DB:business_master_new
loadtime:3.0526781082153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stantonsburg' limit 1
loadtime:3.0527620315552 / seconds
Query Executed:select id FROM `nc` where city='Stantonsburg' && SIC_code='7542'DB:business_master_new
loadtime:3.0544919967651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:3.0545530319214 / seconds
Query Executed:select id FROM `nc` where city='Star' && SIC_code='7542'DB:business_master_new
loadtime:3.0562980175018 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Road' limit 1
loadtime:3.0563831329346 / seconds
Query Executed:select id FROM `nc` where city='State Road' && SIC_code='7542'DB:business_master_new
loadtime:3.0583789348602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Statesville' limit 1
loadtime:3.0584599971771 / seconds
Query Executed:select id FROM `nc` where city='Statesville' && SIC_code='7542'DB:business_master_new
loadtime:3.0735700130463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stedman' limit 1
loadtime:3.0736730098724 / seconds
Query Executed:select id FROM `nc` where city='Stedman' && SIC_code='7542'DB:business_master_new
loadtime:3.0762059688568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stella' limit 1
loadtime:3.0762829780579 / seconds
Query Executed:select id FROM `nc` where city='Stella' && SIC_code='7542'DB:business_master_new
loadtime:3.0770771503448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stem' limit 1
loadtime:3.0771329402924 / seconds
Query Executed:select id FROM `nc` where city='Stem' && SIC_code='7542'DB:business_master_new
loadtime:3.0782649517059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokes' limit 1
loadtime:3.0783309936523 / seconds
Query Executed:select id FROM `nc` where city='Stokes' && SIC_code='7542'DB:business_master_new
loadtime:3.079353094101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokesdale' limit 1
loadtime:3.07941198349 / seconds
Query Executed:select id FROM `nc` where city='Stokesdale' && SIC_code='7542'DB:business_master_new
loadtime:3.0834400653839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:3.0835199356079 / seconds
Query Executed:select id FROM `nc` where city='Stoneville' && SIC_code='7542'DB:business_master_new
loadtime:3.0875980854034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:3.0876820087433 / seconds
Query Executed:select id FROM `nc` where city='Stonewall' && SIC_code='7542'DB:business_master_new
loadtime:3.0882351398468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Point' limit 1
loadtime:3.0882890224457 / seconds
Query Executed:select id FROM `nc` where city='Stony Point' && SIC_code='7542'DB:business_master_new
loadtime:3.0904450416565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stovall' limit 1
loadtime:3.0905129909515 / seconds
Query Executed:select id FROM `nc` where city='Stovall' && SIC_code='7542'DB:business_master_new
loadtime:3.0912189483643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stumpy Point' limit 1
loadtime:3.0912790298462 / seconds
Query Executed:select id FROM `nc` where city='Stumpy Point' && SIC_code='7542'DB:business_master_new
loadtime:3.091854095459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:3.0919139385223 / seconds
Query Executed:select id FROM `nc` where city='Sugar Grove' && SIC_code='7542'DB:business_master_new
loadtime:3.0934760570526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Mountain' limit 1
loadtime:3.0935389995575 / seconds
Query Executed:select id FROM `nc` where city='Sugar Mountain' && SIC_code='7542'DB:business_master_new
loadtime:3.0939121246338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerfield' limit 1
loadtime:3.0939691066742 / seconds
Query Executed:select id FROM `nc` where city='Summerfield' && SIC_code='7542'DB:business_master_new
loadtime:3.1012580394745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunbury' limit 1
loadtime:3.1013259887695 / seconds
Query Executed:select id FROM `nc` where city='Sunbury' && SIC_code='7542'DB:business_master_new
loadtime:3.1027939319611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset Beach' limit 1
loadtime:3.1028571128845 / seconds
Query Executed:select id FROM `nc` where city='Sunset Beach' && SIC_code='7542'DB:business_master_new
loadtime:3.1056950092316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:3.1057670116425 / seconds
Query Executed:select id FROM `nc` where city='Supply' && SIC_code='7542'DB:business_master_new
loadtime:3.1137959957123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surf City' limit 1
loadtime:3.1138639450073 / seconds
Query Executed:select id FROM `nc` where city='Surf City' && SIC_code='7542'DB:business_master_new
loadtime:3.1144001483917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swannanoa' limit 1
loadtime:3.1144580841064 / seconds
Query Executed:select id FROM `nc` where city='Swannanoa' && SIC_code='7542'DB:business_master_new
loadtime:3.1207399368286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanquarter' limit 1
loadtime:3.1208181381226 / seconds
Query Executed:select id FROM `nc` where city='Swanquarter' && SIC_code='7542'DB:business_master_new
loadtime:3.1228089332581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansboro' limit 1
loadtime:3.1228740215302 / seconds
Query Executed:select id FROM `nc` where city='Swansboro' && SIC_code='7542'DB:business_master_new
loadtime:3.1328630447388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swepsonville' limit 1
loadtime:3.1329419612885 / seconds
Query Executed:select id FROM `nc` where city='Swepsonville' && SIC_code='7542'DB:business_master_new
loadtime:3.1336760520935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylva' limit 1
loadtime:3.1337370872498 / seconds
Query Executed:select id FROM `nc` where city='Sylva' && SIC_code='7542'DB:business_master_new
loadtime:3.1461000442505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor City' limit 1
loadtime:3.1461811065674 / seconds
Query Executed:select id FROM `nc` where city='Tabor City' && SIC_code='7542'DB:business_master_new
loadtime:3.1509759426117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tapoco' limit 1
loadtime:3.1510519981384 / seconds
Query Executed:select id FROM `nc` where city='Tapoco' && SIC_code='7542'DB:business_master_new
loadtime:3.1514749526978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tar Heel' limit 1
loadtime:3.1515409946442 / seconds
Query Executed:select id FROM `nc` where city='Tar Heel' && SIC_code='7542'DB:business_master_new
loadtime:3.1528151035309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarawa Terrace' limit 1
loadtime:3.1528730392456 / seconds
Query Executed:select id FROM `nc` where city='Tarawa Terrace' && SIC_code='7542'DB:business_master_new
loadtime:3.1533260345459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarboro' limit 1
loadtime:3.1533880233765 / seconds
Query Executed:select id FROM `nc` where city='Tarboro' && SIC_code='7542'DB:business_master_new
loadtime:3.1650450229645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:3.1651260852814 / seconds
Query Executed:select id FROM `nc` where city='Taylorsville' && SIC_code='7542'DB:business_master_new
loadtime:3.1785590648651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teachey' limit 1
loadtime:3.1786870956421 / seconds
Query Executed:select id FROM `nc` where city='Teachey' && SIC_code='7542'DB:business_master_new
loadtime:3.1797471046448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terrell' limit 1
loadtime:3.179808139801 / seconds
Query Executed:select id FROM `nc` where city='Terrell' && SIC_code='7542'DB:business_master_new
loadtime:3.1810581684113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomasville' limit 1
loadtime:3.1811189651489 / seconds
Query Executed:select id FROM `nc` where city='Thomasville' && SIC_code='7542'DB:business_master_new
loadtime:3.2064390182495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurmond' limit 1
loadtime:3.2068581581116 / seconds
Query Executed:select id FROM `nc` where city='Thurmond' && SIC_code='7542'DB:business_master_new
loadtime:3.2077081203461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillery' limit 1
loadtime:3.2077720165253 / seconds
Query Executed:select id FROM `nc` where city='Tillery' && SIC_code='7542'DB:business_master_new
loadtime:3.2083530426025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberlake' limit 1
loadtime:3.2084131240845 / seconds
Query Executed:select id FROM `nc` where city='Timberlake' && SIC_code='7542'DB:business_master_new
loadtime:3.2105889320374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toast' limit 1
loadtime:3.2106471061707 / seconds
Query Executed:select id FROM `nc` where city='Toast' && SIC_code='7542'DB:business_master_new
loadtime:3.2113010883331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tobaccoville' limit 1
loadtime:3.2113680839539 / seconds
Query Executed:select id FROM `nc` where city='Tobaccoville' && SIC_code='7542'DB:business_master_new
loadtime:3.2127361297607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Todd' limit 1
loadtime:3.2127959728241 / seconds
Query Executed:select id FROM `nc` where city='Todd' && SIC_code='7542'DB:business_master_new
loadtime:3.2138731479645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsail Beach' limit 1
loadtime:3.2139329910278 / seconds
Query Executed:select id FROM `nc` where city='Topsail Beach' && SIC_code='7542'DB:business_master_new
loadtime:3.2146511077881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topton' limit 1
loadtime:3.2147109508514 / seconds
Query Executed:select id FROM `nc` where city='Topton' && SIC_code='7542'DB:business_master_new
loadtime:3.2155780792236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsville' limit 1
loadtime:3.2156381607056 / seconds
Query Executed:select id FROM `nc` where city='Townsville' && SIC_code='7542'DB:business_master_new
loadtime:3.2162261009216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traphill' limit 1
loadtime:3.2162849903107 / seconds
Query Executed:select id FROM `nc` where city='Traphill' && SIC_code='7542'DB:business_master_new
loadtime:3.2173840999603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent Woods' limit 1
loadtime:3.2174439430237 / seconds
Query Executed:select id FROM `nc` where city='Trent Woods' && SIC_code='7542'DB:business_master_new
loadtime:3.2178950309753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:3.2179529666901 / seconds
Query Executed:select id FROM `nc` where city='Trenton' && SIC_code='7542'DB:business_master_new
loadtime:3.2207081317902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinity' limit 1
loadtime:3.2207651138306 / seconds
Query Executed:select id FROM `nc` where city='Trinity' && SIC_code='7542'DB:business_master_new
loadtime:3.2263360023499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutman' limit 1
loadtime:3.2264180183411 / seconds
Query Executed:select id FROM `nc` where city='Troutman' && SIC_code='7542'DB:business_master_new
loadtime:3.2308859825134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:3.2309560775757 / seconds
Query Executed:select id FROM `nc` where city='Troy' && SIC_code='7542'DB:business_master_new
loadtime:3.236230134964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tryon' limit 1
loadtime:3.2362930774689 / seconds
Query Executed:select id FROM `nc` where city='Tryon' && SIC_code='7542'DB:business_master_new
loadtime:3.2404730319977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckasegee' limit 1
loadtime:3.2405569553375 / seconds
Query Executed:select id FROM `nc` where city='Tuckasegee' && SIC_code='7542'DB:business_master_new
loadtime:3.2413101196289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turkey' limit 1
loadtime:3.2413740158081 / seconds
Query Executed:select id FROM `nc` where city='Turkey' && SIC_code='7542'DB:business_master_new
loadtime:3.242730140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turnersburg' limit 1
loadtime:3.2427899837494 / seconds
Query Executed:select id FROM `nc` where city='Turnersburg' && SIC_code='7542'DB:business_master_new
loadtime:3.2432911396027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuxedo' limit 1
loadtime:3.2433569431305 / seconds
Query Executed:select id FROM `nc` where city='Tuxedo' && SIC_code='7542'DB:business_master_new
loadtime:3.2440831661224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyner' limit 1
loadtime:3.2441380023956 / seconds
Query Executed:select id FROM `nc` where city='Tyner' && SIC_code='7542'DB:business_master_new
loadtime:3.2454340457916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:3.245500087738 / seconds
Query Executed:select id FROM `nc` where city='Union Grove' && SIC_code='7542'DB:business_master_new
loadtime:3.2474031448364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Mills' limit 1
loadtime:3.2474610805511 / seconds
Query Executed:select id FROM `nc` where city='Union Mills' && SIC_code='7542'DB:business_master_new
loadtime:3.2486021518707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdese' limit 1
loadtime:3.2486600875854 / seconds
Query Executed:select id FROM `nc` where city='Valdese' && SIC_code='7542'DB:business_master_new
loadtime:3.2541451454163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:3.2542059421539 / seconds
Query Executed:select id FROM `nc` where city='Vale' && SIC_code='7542'DB:business_master_new
loadtime:3.2577021121979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valle Crucis' limit 1
loadtime:3.2577550411224 / seconds
Query Executed:select id FROM `nc` where city='Valle Crucis' && SIC_code='7542'DB:business_master_new
loadtime:3.2585730552673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanceboro' limit 1
loadtime:3.2586369514465 / seconds
Query Executed:select id FROM `nc` where city='Vanceboro' && SIC_code='7542'DB:business_master_new
loadtime:3.2625229358673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandemere' limit 1
loadtime:3.2625889778137 / seconds
Query Executed:select id FROM `nc` where city='Vandemere' && SIC_code='7542'DB:business_master_new
loadtime:3.2631151676178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vass' limit 1
loadtime:3.2631740570068 / seconds
Query Executed:select id FROM `nc` where city='Vass' && SIC_code='7542'DB:business_master_new
loadtime:3.2659440040588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:3.2660069465637 / seconds
Query Executed:select id FROM `nc` where city='Vaughan' && SIC_code='7542'DB:business_master_new
loadtime:3.2665140628815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vilas' limit 1
loadtime:3.2665741443634 / seconds
Query Executed:select id FROM `nc` where city='Vilas' && SIC_code='7542'DB:business_master_new
loadtime:3.2691161632538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waco' limit 1
loadtime:3.2691740989685 / seconds
Query Executed:select id FROM `nc` where city='Waco' && SIC_code='7542'DB:business_master_new
loadtime:3.2697780132294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wade' limit 1
loadtime:3.2698349952698 / seconds
Query Executed:select id FROM `nc` where city='Wade' && SIC_code='7542'DB:business_master_new
loadtime:3.2711780071259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadesboro' limit 1
loadtime:3.2712481021881 / seconds
Query Executed:select id FROM `nc` where city='Wadesboro' && SIC_code='7542'DB:business_master_new
loadtime:3.2814080715179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagram' limit 1
loadtime:3.2814929485321 / seconds
Query Executed:select id FROM `nc` where city='Wagram' && SIC_code='7542'DB:business_master_new
loadtime:3.2827789783478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake Forest' limit 1
loadtime:3.2828421592712 / seconds
Query Executed:select id FROM `nc` where city='Wake Forest' && SIC_code='7542'DB:business_master_new
loadtime:3.2979509830475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkertown' limit 1
loadtime:3.2980329990387 / seconds
Query Executed:select id FROM `nc` where city='Walkertown' && SIC_code='7542'DB:business_master_new
loadtime:3.3027601242065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:3.3028390407562 / seconds
Query Executed:select id FROM `nc` where city='Wallace' && SIC_code='7542'DB:business_master_new
loadtime:3.3112759590149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallburg' limit 1
loadtime:3.3113610744476 / seconds
Query Executed:select id FROM `nc` where city='Wallburg' && SIC_code='7542'DB:business_master_new
loadtime:3.3121089935303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Cove' limit 1
loadtime:3.3121950626373 / seconds
Query Executed:select id FROM `nc` where city='Walnut Cove' && SIC_code='7542'DB:business_master_new
loadtime:3.3183929920197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walstonburg' limit 1
loadtime:3.3184781074524 / seconds
Query Executed:select id FROM `nc` where city='Walstonburg' && SIC_code='7542'DB:business_master_new
loadtime:3.3197140693665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanchese' limit 1
loadtime:3.319787979126 / seconds
Query Executed:select id FROM `nc` where city='Wanchese' && SIC_code='7542'DB:business_master_new
loadtime:3.3216910362244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warne' limit 1
loadtime:3.3217539787292 / seconds
Query Executed:select id FROM `nc` where city='Warne' && SIC_code='7542'DB:business_master_new
loadtime:3.3224530220032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrensville' limit 1
loadtime:3.3225181102753 / seconds
Query Executed:select id FROM `nc` where city='Warrensville' && SIC_code='7542'DB:business_master_new
loadtime:3.3236379623413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:3.3237121105194 / seconds
Query Executed:select id FROM `nc` where city='Warrenton' && SIC_code='7542'DB:business_master_new
loadtime:3.3293280601501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:3.329400062561 / seconds
Query Executed:select id FROM `nc` where city='Warsaw' && SIC_code='7542'DB:business_master_new
loadtime:3.3350729942322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:3.3351500034332 / seconds
Query Executed:select id FROM `nc` where city='Washington' && SIC_code='7542'DB:business_master_new
loadtime:3.3568360805511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watha' limit 1
loadtime:3.3569371700287 / seconds
Query Executed:select id FROM `nc` where city='Watha' && SIC_code='7542'DB:business_master_new
loadtime:3.3573470115662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waves' limit 1
loadtime:3.3574039936066 / seconds
Query Executed:select id FROM `nc` where city='Waves' && SIC_code='7542'DB:business_master_new
loadtime:3.358057975769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waxhaw' limit 1
loadtime:3.3581161499023 / seconds
Query Executed:select id FROM `nc` where city='Waxhaw' && SIC_code='7542'DB:business_master_new
loadtime:3.3691990375519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesville' limit 1
loadtime:3.3692760467529 / seconds
Query Executed:select id FROM `nc` where city='Waynesville' && SIC_code='7542'DB:business_master_new
loadtime:3.3882391452789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weaverville' limit 1
loadtime:3.3883290290833 / seconds
Query Executed:select id FROM `nc` where city='Weaverville' && SIC_code='7542'DB:business_master_new
loadtime:3.3975059986115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:3.3975830078125 / seconds
Query Executed:select id FROM `nc` where city='Webster' && SIC_code='7542'DB:business_master_new
loadtime:3.3982319831848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weddington' limit 1
loadtime:3.3982920646667 / seconds
Query Executed:select id FROM `nc` where city='Weddington' && SIC_code='7542'DB:business_master_new
loadtime:3.3988230228424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welcome' limit 1
loadtime:3.3988771438599 / seconds
Query Executed:select id FROM `nc` where city='Welcome' && SIC_code='7542'DB:business_master_new
loadtime:3.40123295784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:3.4013080596924 / seconds
Query Executed:select id FROM `nc` where city='Weldon' && SIC_code='7542'DB:business_master_new
loadtime:3.40403008461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:3.404107093811 / seconds
Query Executed:select id FROM `nc` where city='Wendell' && SIC_code='7542'DB:business_master_new
loadtime:3.4140131473541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:3.4140951633453 / seconds
Query Executed:select id FROM `nc` where city='Wentworth' && SIC_code='7542'DB:business_master_new
loadtime:3.4155509471893 / seconds
Query loaded from cache:select * from geodata_geocity where city='West End' limit 1
loadtime:3.4156081676483 / seconds
Query Executed:select id FROM `nc` where city='West End' && SIC_code='7542'DB:business_master_new
loadtime:3.4196450710297 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jefferson' limit 1
loadtime:3.4197170734406 / seconds
Query Executed:select id FROM `nc` where city='West Jefferson' && SIC_code='7542'DB:business_master_new
loadtime:3.4274489879608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:3.4275460243225 / seconds
Query Executed:select id FROM `nc` where city='Westfield' && SIC_code='7542'DB:business_master_new
loadtime:3.4291570186615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whispering Pines' limit 1
loadtime:3.4292180538177 / seconds
Query Executed:select id FROM `nc` where city='Whispering Pines' && SIC_code='7542'DB:business_master_new
loadtime:3.4296870231628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitakers' limit 1
loadtime:3.4297490119934 / seconds
Query Executed:select id FROM `nc` where city='Whitakers' && SIC_code='7542'DB:business_master_new
loadtime:3.4321579933167 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Oak' limit 1
loadtime:3.4322190284729 / seconds
Query Executed:select id FROM `nc` where city='White Oak' && SIC_code='7542'DB:business_master_new
loadtime:3.4333910942078 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:3.4334590435028 / seconds
Query Executed:select id FROM `nc` where city='White Plains' && SIC_code='7542'DB:business_master_new
loadtime:3.4339680671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteville' limit 1
loadtime:3.4340240955353 / seconds
Query Executed:select id FROM `nc` where city='Whiteville' && SIC_code='7542'DB:business_master_new
loadtime:3.4496121406555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitsett' limit 1
loadtime:3.4496941566467 / seconds
Query Executed:select id FROM `nc` where city='Whitsett' && SIC_code='7542'DB:business_master_new
loadtime:3.4520721435547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittier' limit 1
loadtime:3.4521501064301 / seconds
Query Executed:select id FROM `nc` where city='Whittier' && SIC_code='7542'DB:business_master_new
loadtime:3.4544811248779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbar' limit 1
loadtime:3.4545440673828 / seconds
Query Executed:select id FROM `nc` where city='Wilbar' && SIC_code='7542'DB:business_master_new
loadtime:3.4549520015717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkesboro' limit 1
loadtime:3.4550161361694 / seconds
Query Executed:select id FROM `nc` where city='Wilkesboro' && SIC_code='7542'DB:business_master_new
loadtime:3.4666090011597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:3.4666900634766 / seconds
Query Executed:select id FROM `nc` where city='Willard' && SIC_code='7542'DB:business_master_new
loadtime:3.468672990799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:3.4687311649323 / seconds
Query Executed:select id FROM `nc` where city='Williamston' && SIC_code='7542'DB:business_master_new
loadtime:3.4803020954132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:3.4803860187531 / seconds
Query Executed:select id FROM `nc` where city='Williston' && SIC_code='7542'DB:business_master_new
loadtime:3.4809410572052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Spring' limit 1
loadtime:3.4810020923615 / seconds
Query Executed:select id FROM `nc` where city='Willow Spring' && SIC_code='7542'DB:business_master_new
loadtime:3.4848971366882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:3.4849579334259 / seconds
Query Executed:select id FROM `nc` where city='Wilmington' && SIC_code='7542'DB:business_master_new
loadtime:3.5000231266022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:3.5001561641693 / seconds
Query Executed:select id FROM `nc` where city='Wilson' && SIC_code='7542'DB:business_master_new
loadtime:3.514230966568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons Mills' limit 1
loadtime:3.5143480300903 / seconds
Query Executed:select id FROM `nc` where city='Wilsons Mills' && SIC_code='7542'DB:business_master_new
loadtime:3.5150139331818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:3.5150799751282 / seconds
Query Executed:select id FROM `nc` where city='Windsor' && SIC_code='7542'DB:business_master_new
loadtime:3.5221049785614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfall' limit 1
loadtime:3.5221779346466 / seconds
Query Executed:select id FROM `nc` where city='Winfall' && SIC_code='7542'DB:business_master_new
loadtime:3.5228731632233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingate' limit 1
loadtime:3.5229330062866 / seconds
Query Executed:select id FROM `nc` where city='Wingate' && SIC_code='7542'DB:business_master_new
loadtime:3.5255401134491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnabow' limit 1
loadtime:3.5256011486053 / seconds
Query Executed:select id FROM `nc` where city='Winnabow' && SIC_code='7542'DB:business_master_new
loadtime:3.5270681381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston Salem' limit 1
loadtime:3.5271301269531 / seconds
Query Executed:select id FROM `nc` where city='Winston Salem' && SIC_code='7542'DB:business_master_new
loadtime:3.5412850379944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:3.5414190292358 / seconds
Query Executed:select id FROM `nc` where city='Winterville' && SIC_code='7542'DB:business_master_new
loadtime:3.5498750209808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winton' limit 1
loadtime:3.549957036972 / seconds
Query Executed:select id FROM `nc` where city='Winton' && SIC_code='7542'DB:business_master_new
loadtime:3.5518519878387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:3.5519080162048 / seconds
Query Executed:select id FROM `nc` where city='Wise' && SIC_code='7542'DB:business_master_new
loadtime:3.5523891448975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:3.5524470806122 / seconds
Query Executed:select id FROM `nc` where city='Woodland' && SIC_code='7542'DB:business_master_new
loadtime:3.5534830093384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodleaf' limit 1
loadtime:3.5535550117493 / seconds
Query Executed:select id FROM `nc` where city='Woodleaf' && SIC_code='7542'DB:business_master_new
loadtime:3.5549099445343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Bch' limit 1
loadtime:3.5549700260162 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Bch' && SIC_code='7542'DB:business_master_new
loadtime:3.5555391311646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Beach' limit 1
loadtime:3.5556011199951 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Beach' && SIC_code='7542'DB:business_master_new
loadtime:3.5598011016846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yadkinville' limit 1
loadtime:3.5598599910736 / seconds
Query Executed:select id FROM `nc` where city='Yadkinville' && SIC_code='7542'DB:business_master_new
loadtime:3.5698790550232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yanceyville' limit 1
loadtime:3.5699689388275 / seconds
Query Executed:select id FROM `nc` where city='Yanceyville' && SIC_code='7542'DB:business_master_new
loadtime:3.5740251541138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:3.5740880966187 / seconds
Query Executed:select id FROM `nc` where city='Youngsville' && SIC_code='7542'DB:business_master_new
loadtime:3.5817270278931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zebulon' limit 1
loadtime:3.58180809021 / seconds
Query Executed:select id FROM `nc` where city='Zebulon' && SIC_code='7542'DB:business_master_new
loadtime:3.592915058136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zionville' limit 1
loadtime:3.5929930210114 / seconds
Query Executed:select id FROM `nc` where city='Zionville' && SIC_code='7542'DB:business_master_new
loadtime:3.5941390991211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zirconia' limit 1
loadtime:3.5942051410675 / seconds
Query Executed:select id FROM `nc` where city='Zirconia' && SIC_code='7542'DB:business_master_new
loadtime:3.595447063446 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:3.5956110954285 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:3.5962290763855 / seconds
Operation template executed (chunk cache operation)
loadtime:3.5964150428772 / seconds
template override:Default
loadtime:3.5964660644531 / 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:3.5984370708466 / seconds
Template Constructed, Array Rows:49
loadtime:3.5990669727325 / seconds
TOTAL EXECUTION TIME: 3.59855
loadtime:3.6020319461823 / 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] => carwashes [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:3.6020441055298
TOTAL KEY ARRAYS: 69