Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:4.8160552978516E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00044894218444824 / seconds
host not found setting manual db connection
loadtime:0.00080204010009766 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010330677032471 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0011510848999023 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0011970996856689 / seconds
zipcode:
loadtime:0.0012140274047852 / seconds
Query Executed:select * from search_referrer where page_hash='3380ae0f121806b72f4047d829e6f172' limit 10 DB:ezrox_toadli
loadtime:0.001845121383667 / seconds
Operation header executed (non global)
loadtime:0.001863956451416 / seconds
Operation leaderboard executed (non global)
loadtime:0.00189208984375 / seconds
Operation square executed (non global)
loadtime:0.0019071102142334 / seconds
Operation square_bottom executed (non global)
loadtime:0.0019209384918213 / seconds
Operation smallsquare executed (non global)
loadtime:0.0019330978393555 / seconds
Operation headeradright executed (non global)
loadtime:0.0019440650939941 / seconds
Operation google_analytics executed (non global)
loadtime:0.0019550323486328 / seconds
Operation topstories executed (non global)
loadtime:0.0019669532775879 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0019791126251221 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0019891262054443 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0022101402282715 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0023541450500488 / seconds
Operation categories executed (global stored into APC)
loadtime:0.002392053604126 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0024521350860596 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0024890899658203 / seconds
Template key: archive_menu pushed
loadtime:0.0024940967559814 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0025010108947754 / seconds
Template key: get_gravatar pushed
loadtime:0.0025041103363037 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0025081634521484 / seconds
*10)-10)+1 | start:0
loadtime:0.0025300979614258 / seconds
Query loaded from cache:select * from categories where cat_URLid='grocery-stores'
loadtime:0.002561092376709 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='kansas'
loadtime:0.0025880336761475 / seconds
DB connected to localhost business_master_new
loadtime:0.002824068069458 / seconds
Query Executed:select * from `ks_catmap` where sic='5411' order by city ascDB:business_master_new
loadtime:0.13611006736755 / seconds
Query stored in cache : _QUERY_www.toadli.combf90e816011eaf32520c68a52911e8bf
loadtime:0.13718795776367 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='kansas'
loadtime:0.13722610473633 / seconds
Query Executed:select sum(totalcount) as totalsum from `ks_catmap` where sic='5411'DB:business_master_new
loadtime:0.14089894294739 / seconds
Query stored in cache : _QUERY_www.toadli.comccb1889e147fc0ccf9d41716d45b644d
loadtime:0.14093613624573 / seconds
705 / 11
loadtime:0.14096999168396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbyville' limit 1
loadtime:0.14101696014404 / seconds
Query Executed:select id FROM `ks` where city='Abbyville' && SIC_code='5411'DB:business_master_new
loadtime:0.14702415466309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abilene' limit 1
loadtime:0.14706015586853 / seconds
Query Executed:select id FROM `ks` where city='Abilene' && SIC_code='5411'DB:business_master_new
loadtime:0.14994502067566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ada' limit 1
loadtime:0.15000700950623 / seconds
Query Executed:select id FROM `ks` where city='Ada' && SIC_code='5411'DB:business_master_new
loadtime:0.15032410621643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Admire' limit 1
loadtime:0.15036511421204 / seconds
Query Executed:select id FROM `ks` where city='Admire' && SIC_code='5411'DB:business_master_new
loadtime:0.1528799533844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agenda' limit 1
loadtime:0.15293002128601 / seconds
Query Executed:select id FROM `ks` where city='Agenda' && SIC_code='5411'DB:business_master_new
loadtime:0.15588903427124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agra' limit 1
loadtime:0.15592503547668 / seconds
Query Executed:select id FROM `ks` where city='Agra' && SIC_code='5411'DB:business_master_new
loadtime:0.16506409645081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamota' limit 1
loadtime:0.16512012481689 / seconds
Query Executed:select id FROM `ks` where city='Alamota' && SIC_code='5411'DB:business_master_new
loadtime:0.16544008255005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albert' limit 1
loadtime:0.16548609733582 / seconds
Query Executed:select id FROM `ks` where city='Albert' && SIC_code='5411'DB:business_master_new
loadtime:0.17084813117981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.17089605331421 / seconds
Query Executed:select id FROM `ks` where city='Alden' && SIC_code='5411'DB:business_master_new
loadtime:0.17621111869812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.17625904083252 / seconds
Query Executed:select id FROM `ks` where city='Alexander' && SIC_code='5411'DB:business_master_new
loadtime:0.17905402183533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.17909502983093 / seconds
Query Executed:select id FROM `ks` where city='Allen' && SIC_code='5411'DB:business_master_new
loadtime:0.18628311157227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.18633604049683 / seconds
Query Executed:select id FROM `ks` where city='Alma' && SIC_code='5411'DB:business_master_new
loadtime:0.18860793113708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almena' limit 1
loadtime:0.1886670589447 / seconds
Query Executed:select id FROM `ks` where city='Almena' && SIC_code='5411'DB:business_master_new
loadtime:0.19564414024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta Vista' limit 1
loadtime:0.19570112228394 / seconds
Query Executed:select id FROM `ks` where city='Alta Vista' && SIC_code='5411'DB:business_master_new
loadtime:0.20861315727234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.20867204666138 / seconds
Query Executed:select id FROM `ks` where city='Altamont' && SIC_code='5411'DB:business_master_new
loadtime:0.21043801307678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.2104959487915 / seconds
Query Executed:select id FROM `ks` where city='Alton' && SIC_code='5411'DB:business_master_new
loadtime:0.21623015403748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.21628904342651 / seconds
Query Executed:select id FROM `ks` where city='Altoona' && SIC_code='5411'DB:business_master_new
loadtime:0.22500801086426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Americus' limit 1
loadtime:0.22506713867188 / seconds
Query Executed:select id FROM `ks` where city='Americus' && SIC_code='5411'DB:business_master_new
loadtime:0.24027800559998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andale' limit 1
loadtime:0.24032592773438 / seconds
Query Executed:select id FROM `ks` where city='Andale' && SIC_code='5411'DB:business_master_new
loadtime:0.25483798980713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.2548999786377 / seconds
Query Executed:select id FROM `ks` where city='Andover' && SIC_code='5411'DB:business_master_new
loadtime:0.25780296325684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthony' limit 1
loadtime:0.25787711143494 / seconds
Query Executed:select id FROM `ks` where city='Anthony' && SIC_code='5411'DB:business_master_new
loadtime:0.26100516319275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.26106905937195 / seconds
Query Executed:select id FROM `ks` where city='Arcadia' && SIC_code='5411'DB:business_master_new
loadtime:0.26647901535034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argonia' limit 1
loadtime:0.26652812957764 / seconds
Query Executed:select id FROM `ks` where city='Argonia' && SIC_code='5411'DB:business_master_new
loadtime:0.26729702949524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkansas City' limit 1
loadtime:0.26733708381653 / seconds
Query Executed:select id FROM `ks` where city='Arkansas City' && SIC_code='5411'DB:business_master_new
loadtime:0.27036809921265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.27043199539185 / seconds
Query Executed:select id FROM `ks` where city='Arlington' && SIC_code='5411'DB:business_master_new
loadtime:0.27927398681641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arma' limit 1
loadtime:0.27933502197266 / seconds
Query Executed:select id FROM `ks` where city='Arma' && SIC_code='5411'DB:business_master_new
loadtime:0.28201603889465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnold' limit 1
loadtime:0.28207802772522 / seconds
Query Executed:select id FROM `ks` where city='Arnold' && SIC_code='5411'DB:business_master_new
loadtime:0.2840051651001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.28405594825745 / seconds
Query Executed:select id FROM `ks` where city='Ashland' && SIC_code='5411'DB:business_master_new
loadtime:0.28559994697571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assaria' limit 1
loadtime:0.28564810752869 / seconds
Query Executed:select id FROM `ks` where city='Assaria' && SIC_code='5411'DB:business_master_new
loadtime:0.30128812789917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atchison' limit 1
loadtime:0.30134201049805 / seconds
Query Executed:select id FROM `ks` where city='Atchison' && SIC_code='5411'DB:business_master_new
loadtime:0.30475997924805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.30483102798462 / seconds
Query Executed:select id FROM `ks` where city='Athol' && SIC_code='5411'DB:business_master_new
loadtime:0.3107271194458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlanta' limit 1
loadtime:0.31077599525452 / seconds
Query Executed:select id FROM `ks` where city='Atlanta' && SIC_code='5411'DB:business_master_new
loadtime:0.31643509864807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attica' limit 1
loadtime:0.3164701461792 / seconds
Query Executed:select id FROM `ks` where city='Attica' && SIC_code='5411'DB:business_master_new
loadtime:0.31795001029968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atwood' limit 1
loadtime:0.31801009178162 / seconds
Query Executed:select id FROM `ks` where city='Atwood' && SIC_code='5411'DB:business_master_new
loadtime:0.31976509094238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.31982398033142 / seconds
Query Executed:select id FROM `ks` where city='Auburn' && SIC_code='5411'DB:business_master_new
loadtime:0.32130694389343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.32135796546936 / seconds
Query Executed:select id FROM `ks` where city='Augusta' && SIC_code='5411'DB:business_master_new
loadtime:0.32348799705505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.3235330581665 / seconds
Query Executed:select id FROM `ks` where city='Aurora' && SIC_code='5411'DB:business_master_new
loadtime:0.32600498199463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axtell' limit 1
loadtime:0.32604002952576 / seconds
Query Executed:select id FROM `ks` where city='Axtell' && SIC_code='5411'DB:business_master_new
loadtime:0.32698011398315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileyville' limit 1
loadtime:0.32702302932739 / seconds
Query Executed:select id FROM `ks` where city='Baileyville' && SIC_code='5411'DB:business_master_new
loadtime:0.33322215080261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin City' limit 1
loadtime:0.33325409889221 / seconds
Query Executed:select id FROM `ks` where city='Baldwin City' && SIC_code='5411'DB:business_master_new
loadtime:0.33482503890991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.33486604690552 / seconds
Query Executed:select id FROM `ks` where city='Barnard' && SIC_code='5411'DB:business_master_new
loadtime:0.33907794952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes' limit 1
loadtime:0.33911609649658 / seconds
Query Executed:select id FROM `ks` where city='Barnes' && SIC_code='5411'DB:business_master_new
loadtime:0.34417200088501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.34421014785767 / seconds
Query Executed:select id FROM `ks` where city='Bartlett' && SIC_code='5411'DB:business_master_new
loadtime:0.34872007369995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basehor' limit 1
loadtime:0.34875011444092 / seconds
Query Executed:select id FROM `ks` where city='Basehor' && SIC_code='5411'DB:business_master_new
loadtime:0.34974312782288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bavaria' limit 1
loadtime:0.34978294372559 / seconds
Query Executed:select id FROM `ks` where city='Bavaria' && SIC_code='5411'DB:business_master_new
loadtime:0.35008215904236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baxter Springs' limit 1
loadtime:0.35010695457458 / seconds
Query Executed:select id FROM `ks` where city='Baxter Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.35226202011108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bazine' limit 1
loadtime:0.35230493545532 / seconds
Query Executed:select id FROM `ks` where city='Bazine' && SIC_code='5411'DB:business_master_new
loadtime:0.36264896392822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beattie' limit 1
loadtime:0.36267399787903 / seconds
Query Executed:select id FROM `ks` where city='Beattie' && SIC_code='5411'DB:business_master_new
loadtime:0.37375998497009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.37382292747498 / seconds
Query Executed:select id FROM `ks` where city='Beaumont' && SIC_code='5411'DB:business_master_new
loadtime:0.37549996376038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beeler' limit 1
loadtime:0.37554812431335 / seconds
Query Executed:select id FROM `ks` where city='Beeler' && SIC_code='5411'DB:business_master_new
loadtime:0.44908714294434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bel Aire' limit 1
loadtime:0.44914507865906 / seconds
Query Executed:select id FROM `ks` where city='Bel Aire' && SIC_code='5411'DB:business_master_new
loadtime:0.44978499412537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Plaine' limit 1
loadtime:0.44983911514282 / seconds
Query Executed:select id FROM `ks` where city='Belle Plaine' && SIC_code='5411'DB:business_master_new
loadtime:0.45196008682251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.45201110839844 / seconds
Query Executed:select id FROM `ks` where city='Belleville' && SIC_code='5411'DB:business_master_new
loadtime:0.45329403877258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beloit' limit 1
loadtime:0.45335292816162 / seconds
Query Executed:select id FROM `ks` where city='Beloit' && SIC_code='5411'DB:business_master_new
loadtime:0.45491313934326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belpre' limit 1
loadtime:0.45494794845581 / seconds
Query Executed:select id FROM `ks` where city='Belpre' && SIC_code='5411'DB:business_master_new
loadtime:0.45840001106262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.45844912528992 / seconds
Query Executed:select id FROM `ks` where city='Belvidere' && SIC_code='5411'DB:business_master_new
loadtime:0.45892906188965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvue' limit 1
loadtime:0.45895600318909 / seconds
Query Executed:select id FROM `ks` where city='Belvue' && SIC_code='5411'DB:business_master_new
loadtime:0.46536493301392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bendena' limit 1
loadtime:0.46541595458984 / seconds
Query Executed:select id FROM `ks` where city='Bendena' && SIC_code='5411'DB:business_master_new
loadtime:0.46999597549438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benedict' limit 1
loadtime:0.47003793716431 / seconds
Query Executed:select id FROM `ks` where city='Benedict' && SIC_code='5411'DB:business_master_new
loadtime:0.47186803817749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.47190713882446 / seconds
Query Executed:select id FROM `ks` where city='Bennington' && SIC_code='5411'DB:business_master_new
loadtime:0.4726300239563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentley' limit 1
loadtime:0.4726550579071 / seconds
Query Executed:select id FROM `ks` where city='Bentley' && SIC_code='5411'DB:business_master_new
loadtime:0.47606897354126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.4761209487915 / seconds
Query Executed:select id FROM `ks` where city='Benton' && SIC_code='5411'DB:business_master_new
loadtime:0.47709202766418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bern' limit 1
loadtime:0.47714900970459 / seconds
Query Executed:select id FROM `ks` where city='Bern' && SIC_code='5411'DB:business_master_new
loadtime:0.48501515388489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berryton' limit 1
loadtime:0.4850709438324 / seconds
Query Executed:select id FROM `ks` where city='Berryton' && SIC_code='5411'DB:business_master_new
loadtime:0.48580312728882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.48584508895874 / seconds
Query Executed:select id FROM `ks` where city='Beverly' && SIC_code='5411'DB:business_master_new
loadtime:0.49004006385803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bird City' limit 1
loadtime:0.49008893966675 / seconds
Query Executed:select id FROM `ks` where city='Bird City' && SIC_code='5411'DB:business_master_new
loadtime:0.4908390045166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bison' limit 1
loadtime:0.49088096618652 / seconds
Query Executed:select id FROM `ks` where city='Bison' && SIC_code='5411'DB:business_master_new
loadtime:0.49649810791016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blaine' limit 1
loadtime:0.49655103683472 / seconds
Query Executed:select id FROM `ks` where city='Blaine' && SIC_code='5411'DB:business_master_new
loadtime:0.4968581199646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloom' limit 1
loadtime:0.49689102172852 / seconds
Query Executed:select id FROM `ks` where city='Bloom' && SIC_code='5411'DB:business_master_new
loadtime:0.49762797355652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Mound' limit 1
loadtime:0.49767804145813 / seconds
Query Executed:select id FROM `ks` where city='Blue Mound' && SIC_code='5411'DB:business_master_new
loadtime:0.50322794914246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Rapids' limit 1
loadtime:0.50327801704407 / seconds
Query Executed:select id FROM `ks` where city='Blue Rapids' && SIC_code='5411'DB:business_master_new
loadtime:0.50431609153748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluff City' limit 1
loadtime:0.50437092781067 / seconds
Query Executed:select id FROM `ks` where city='Bluff City' && SIC_code='5411'DB:business_master_new
loadtime:0.50699615478516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bogue' limit 1
loadtime:0.50703811645508 / seconds
Query Executed:select id FROM `ks` where city='Bogue' && SIC_code='5411'DB:business_master_new
loadtime:0.51295804977417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonner Springs' limit 1
loadtime:0.51299905776978 / seconds
Query Executed:select id FROM `ks` where city='Bonner Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.51515293121338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremen' limit 1
loadtime:0.51521396636963 / seconds
Query Executed:select id FROM `ks` where city='Bremen' && SIC_code='5411'DB:business_master_new
loadtime:0.52154898643494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.52159810066223 / seconds
Query Executed:select id FROM `ks` where city='Brewster' && SIC_code='5411'DB:business_master_new
loadtime:0.5362811088562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.53633713722229 / seconds
Query Executed:select id FROM `ks` where city='Bronson' && SIC_code='5411'DB:business_master_new
loadtime:0.54209613800049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookville' limit 1
loadtime:0.54213094711304 / seconds
Query Executed:select id FROM `ks` where city='Brookville' && SIC_code='5411'DB:business_master_new
loadtime:0.54831600189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownell' limit 1
loadtime:0.54836416244507 / seconds
Query Executed:select id FROM `ks` where city='Brownell' && SIC_code='5411'DB:business_master_new
loadtime:0.55405712127686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bucklin' limit 1
loadtime:0.55410313606262 / seconds
Query Executed:select id FROM `ks` where city='Bucklin' && SIC_code='5411'DB:business_master_new
loadtime:0.55559897422791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bucyrus' limit 1
loadtime:0.55565810203552 / seconds
Query Executed:select id FROM `ks` where city='Bucyrus' && SIC_code='5411'DB:business_master_new
loadtime:0.55641508102417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.55644392967224 / seconds
Query Executed:select id FROM `ks` where city='Buffalo' && SIC_code='5411'DB:business_master_new
loadtime:0.56156516075134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buhler' limit 1
loadtime:0.56159496307373 / seconds
Query Executed:select id FROM `ks` where city='Buhler' && SIC_code='5411'DB:business_master_new
loadtime:0.56260800361633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunker Hill' limit 1
loadtime:0.56265807151794 / seconds
Query Executed:select id FROM `ks` where city='Bunker Hill' && SIC_code='5411'DB:business_master_new
loadtime:0.56561708450317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burden' limit 1
loadtime:0.5656590461731 / seconds
Query Executed:select id FROM `ks` where city='Burden' && SIC_code='5411'DB:business_master_new
loadtime:0.56703305244446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burdett' limit 1
loadtime:0.56706809997559 / seconds
Query Executed:select id FROM `ks` where city='Burdett' && SIC_code='5411'DB:business_master_new
loadtime:0.57458710670471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burdick' limit 1
loadtime:0.57463192939758 / seconds
Query Executed:select id FROM `ks` where city='Burdick' && SIC_code='5411'DB:business_master_new
loadtime:0.57728505134583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlingame' limit 1
loadtime:0.57731509208679 / seconds
Query Executed:select id FROM `ks` where city='Burlingame' && SIC_code='5411'DB:business_master_new
loadtime:0.57853007316589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.57858300209045 / seconds
Query Executed:select id FROM `ks` where city='Burlington' && SIC_code='5411'DB:business_master_new
loadtime:0.58009815216064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burns' limit 1
loadtime:0.58014392852783 / seconds
Query Executed:select id FROM `ks` where city='Burns' && SIC_code='5411'DB:business_master_new
loadtime:0.58766007423401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Oak' limit 1
loadtime:0.58769607543945 / seconds
Query Executed:select id FROM `ks` where city='Burr Oak' && SIC_code='5411'DB:business_master_new
loadtime:0.59510016441345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burrton' limit 1
loadtime:0.59513998031616 / seconds
Query Executed:select id FROM `ks` where city='Burrton' && SIC_code='5411'DB:business_master_new
loadtime:0.59607005119324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bushton' limit 1
loadtime:0.596107006073 / seconds
Query Executed:select id FROM `ks` where city='Bushton' && SIC_code='5411'DB:business_master_new
loadtime:0.60636496543884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byers' limit 1
loadtime:0.60642099380493 / seconds
Query Executed:select id FROM `ks` where city='Byers' && SIC_code='5411'DB:business_master_new
loadtime:0.60884499549866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caldwell' limit 1
loadtime:0.60888814926147 / seconds
Query Executed:select id FROM `ks` where city='Caldwell' && SIC_code='5411'DB:business_master_new
loadtime:0.61030197143555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.6103630065918 / seconds
Query Executed:select id FROM `ks` where city='Cambridge' && SIC_code='5411'DB:business_master_new
loadtime:0.61393094062805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caney' limit 1
loadtime:0.61396503448486 / seconds
Query Executed:select id FROM `ks` where city='Caney' && SIC_code='5411'DB:business_master_new
loadtime:0.61747813224792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.61753797531128 / seconds
Query Executed:select id FROM `ks` where city='Canton' && SIC_code='5411'DB:business_master_new
loadtime:0.61873412132263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbondale' limit 1
loadtime:0.61878108978271 / seconds
Query Executed:select id FROM `ks` where city='Carbondale' && SIC_code='5411'DB:business_master_new
loadtime:0.61992502212524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlton' limit 1
loadtime:0.61996006965637 / seconds
Query Executed:select id FROM `ks` where city='Carlton' && SIC_code='5411'DB:business_master_new
loadtime:0.62115216255188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassoday' limit 1
loadtime:0.62118005752563 / seconds
Query Executed:select id FROM `ks` where city='Cassoday' && SIC_code='5411'DB:business_master_new
loadtime:0.62729096412659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catharine' limit 1
loadtime:0.62734699249268 / seconds
Query Executed:select id FROM `ks` where city='Catharine' && SIC_code='5411'DB:business_master_new
loadtime:0.62766599655151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cawker City' limit 1
loadtime:0.62769412994385 / seconds
Query Executed:select id FROM `ks` where city='Cawker City' && SIC_code='5411'DB:business_master_new
loadtime:0.62841200828552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.6284511089325 / seconds
Query Executed:select id FROM `ks` where city='Cedar' && SIC_code='5411'DB:business_master_new
loadtime:0.62977194786072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Point' limit 1
loadtime:0.62982606887817 / seconds
Query Executed:select id FROM `ks` where city='Cedar Point' && SIC_code='5411'DB:business_master_new
loadtime:0.63264107704163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Vale' limit 1
loadtime:0.63267612457275 / seconds
Query Executed:select id FROM `ks` where city='Cedar Vale' && SIC_code='5411'DB:business_master_new
loadtime:0.63403916358948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.63409304618835 / seconds
Query Executed:select id FROM `ks` where city='Centerville' && SIC_code='5411'DB:business_master_new
loadtime:0.63912296295166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centralia' limit 1
loadtime:0.63916516304016 / seconds
Query Executed:select id FROM `ks` where city='Centralia' && SIC_code='5411'DB:business_master_new
loadtime:0.64014196395874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chanute' limit 1
loadtime:0.64019203186035 / seconds
Query Executed:select id FROM `ks` where city='Chanute' && SIC_code='5411'DB:business_master_new
loadtime:0.64245796203613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapman' limit 1
loadtime:0.64251399040222 / seconds
Query Executed:select id FROM `ks` where city='Chapman' && SIC_code='5411'DB:business_master_new
loadtime:0.64358305931091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase' limit 1
loadtime:0.64363193511963 / seconds
Query Executed:select id FROM `ks` where city='Chase' && SIC_code='5411'DB:business_master_new
loadtime:0.65223407745361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chautauqua' limit 1
loadtime:0.65229511260986 / seconds
Query Executed:select id FROM `ks` where city='Chautauqua' && SIC_code='5411'DB:business_master_new
loadtime:0.65361094474792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheney' limit 1
loadtime:0.65364694595337 / seconds
Query Executed:select id FROM `ks` where city='Cheney' && SIC_code='5411'DB:business_master_new
loadtime:0.65547704696655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.65552616119385 / seconds
Query Executed:select id FROM `ks` where city='Cherokee' && SIC_code='5411'DB:business_master_new
loadtime:0.65682697296143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherryvale' limit 1
loadtime:0.65687394142151 / seconds
Query Executed:select id FROM `ks` where city='Cherryvale' && SIC_code='5411'DB:business_master_new
loadtime:0.65898895263672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chetopa' limit 1
loadtime:0.65902996063232 / seconds
Query Executed:select id FROM `ks` where city='Chetopa' && SIC_code='5411'DB:business_master_new
loadtime:0.66073393821716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cimarron' limit 1
loadtime:0.66077995300293 / seconds
Query Executed:select id FROM `ks` where city='Cimarron' && SIC_code='5411'DB:business_master_new
loadtime:0.66201901435852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Circleville' limit 1
loadtime:0.66206002235413 / seconds
Query Executed:select id FROM `ks` where city='Circleville' && SIC_code='5411'DB:business_master_new
loadtime:0.66752505302429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claflin' limit 1
loadtime:0.66757702827454 / seconds
Query Executed:select id FROM `ks` where city='Claflin' && SIC_code='5411'DB:business_master_new
loadtime:0.66874408721924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay Center' limit 1
loadtime:0.668790102005 / seconds
Query Executed:select id FROM `ks` where city='Clay Center' && SIC_code='5411'DB:business_master_new
loadtime:0.67085099220276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.67090106010437 / seconds
Query Executed:select id FROM `ks` where city='Clayton' && SIC_code='5411'DB:business_master_new
loadtime:0.67400002479553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearview City' limit 1
loadtime:0.67403411865234 / seconds
Query Executed:select id FROM `ks` where city='Clearview City' && SIC_code='5411'DB:business_master_new
loadtime:0.67453193664551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearwater' limit 1
loadtime:0.67457413673401 / seconds
Query Executed:select id FROM `ks` where city='Clearwater' && SIC_code='5411'DB:business_master_new
loadtime:0.67589402198792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.67596101760864 / seconds
Query Executed:select id FROM `ks` where city='Clifton' && SIC_code='5411'DB:business_master_new
loadtime:0.67714405059814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.67719006538391 / seconds
Query Executed:select id FROM `ks` where city='Climax' && SIC_code='5411'DB:business_master_new
loadtime:0.67745208740234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:0.6774890422821 / seconds
Query Executed:select id FROM `ks` where city='Clyde' && SIC_code='5411'DB:business_master_new
loadtime:0.67867207527161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coats' limit 1
loadtime:0.67870998382568 / seconds
Query Executed:select id FROM `ks` where city='Coats' && SIC_code='5411'DB:business_master_new
loadtime:0.68243408203125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Codell' limit 1
loadtime:0.68247294425964 / seconds
Query Executed:select id FROM `ks` where city='Codell' && SIC_code='5411'DB:business_master_new
loadtime:0.68313002586365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coffeyville' limit 1
loadtime:0.68317604064941 / seconds
Query Executed:select id FROM `ks` where city='Coffeyville' && SIC_code='5411'DB:business_master_new
loadtime:0.68766593933105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colby' limit 1
loadtime:0.68772792816162 / seconds
Query Executed:select id FROM `ks` where city='Colby' && SIC_code='5411'DB:business_master_new
loadtime:0.68958902359009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.68964004516602 / seconds
Query Executed:select id FROM `ks` where city='Coldwater' && SIC_code='5411'DB:business_master_new
loadtime:0.69088506698608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collyer' limit 1
loadtime:0.69093012809753 / seconds
Query Executed:select id FROM `ks` where city='Collyer' && SIC_code='5411'DB:business_master_new
loadtime:0.69559812545776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colony' limit 1
loadtime:0.69562602043152 / seconds
Query Executed:select id FROM `ks` where city='Colony' && SIC_code='5411'DB:business_master_new
loadtime:0.7063319683075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.70638799667358 / seconds
Query Executed:select id FROM `ks` where city='Columbus' && SIC_code='5411'DB:business_master_new
loadtime:0.70778107643127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colwich' limit 1
loadtime:0.70784115791321 / seconds
Query Executed:select id FROM `ks` where city='Colwich' && SIC_code='5411'DB:business_master_new
loadtime:0.70888710021973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concordia' limit 1
loadtime:0.70893597602844 / seconds
Query Executed:select id FROM `ks` where city='Concordia' && SIC_code='5411'DB:business_master_new
loadtime:0.71123003959656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.711266040802 / seconds
Query Executed:select id FROM `ks` where city='Conway' && SIC_code='5411'DB:business_master_new
loadtime:0.71243715286255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway Springs' limit 1
loadtime:0.7124719619751 / seconds
Query Executed:select id FROM `ks` where city='Conway Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.71346497535706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1
loadtime:0.71350812911987 / seconds
Query Executed:select id FROM `ks` where city='Coolidge' && SIC_code='5411'DB:business_master_new
loadtime:0.71818208694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copeland' limit 1
loadtime:0.71823215484619 / seconds
Query Executed:select id FROM `ks` where city='Copeland' && SIC_code='5411'DB:business_master_new
loadtime:0.71895408630371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corning' limit 1
loadtime:0.718994140625 / seconds
Query Executed:select id FROM `ks` where city='Corning' && SIC_code='5411'DB:business_master_new
loadtime:0.72714495658875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood Falls' limit 1
loadtime:0.72719502449036 / seconds
Query Executed:select id FROM `ks` where city='Cottonwood Falls' && SIC_code='5411'DB:business_master_new
loadtime:0.72865915298462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council Grove' limit 1
loadtime:0.72871398925781 / seconds
Query Executed:select id FROM `ks` where city='Council Grove' && SIC_code='5411'DB:business_master_new
loadtime:0.72977614402771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.72983908653259 / seconds
Query Executed:select id FROM `ks` where city='Courtland' && SIC_code='5411'DB:business_master_new
loadtime:0.73988509178162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coyville' limit 1
loadtime:0.73993301391602 / seconds
Query Executed:select id FROM `ks` where city='Coyville' && SIC_code='5411'DB:business_master_new
loadtime:0.74066710472107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crestline' limit 1
loadtime:0.74070000648499 / seconds
Query Executed:select id FROM `ks` where city='Crestline' && SIC_code='5411'DB:business_master_new
loadtime:0.74343013763428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.74346995353699 / seconds
Query Executed:select id FROM `ks` where city='Cuba' && SIC_code='5411'DB:business_master_new
loadtime:0.75049614906311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullison' limit 1
loadtime:0.75054407119751 / seconds
Query Executed:select id FROM `ks` where city='Cullison' && SIC_code='5411'DB:business_master_new
loadtime:0.75127506256104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culver' limit 1
loadtime:0.75131011009216 / seconds
Query Executed:select id FROM `ks` where city='Culver' && SIC_code='5411'DB:business_master_new
loadtime:0.75157713890076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummings' limit 1
loadtime:0.75161194801331 / seconds
Query Executed:select id FROM `ks` where city='Cummings' && SIC_code='5411'DB:business_master_new
loadtime:0.75482797622681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cunningham' limit 1
loadtime:0.75486707687378 / seconds
Query Executed:select id FROM `ks` where city='Cunningham' && SIC_code='5411'DB:business_master_new
loadtime:0.75578713417053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Damar' limit 1
loadtime:0.75583815574646 / seconds
Query Executed:select id FROM `ks` where city='Damar' && SIC_code='5411'DB:business_master_new
loadtime:0.76004409790039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.76008796691895 / seconds
Query Executed:select id FROM `ks` where city='Danville' && SIC_code='5411'DB:business_master_new
loadtime:0.7628870010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:0.76292514801025 / seconds
Query Executed:select id FROM `ks` where city='De Soto' && SIC_code='5411'DB:business_master_new
loadtime:0.76394510269165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearing' limit 1
loadtime:0.76399397850037 / seconds
Query Executed:select id FROM `ks` where city='Dearing' && SIC_code='5411'DB:business_master_new
loadtime:0.77091193199158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.77096509933472 / seconds
Query Executed:select id FROM `ks` where city='Deerfield' && SIC_code='5411'DB:business_master_new
loadtime:0.78188514709473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delavan' limit 1
loadtime:0.78193712234497 / seconds
Query Executed:select id FROM `ks` where city='Delavan' && SIC_code='5411'DB:business_master_new
loadtime:0.78287100791931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delia' limit 1
loadtime:0.78291296958923 / seconds
Query Executed:select id FROM `ks` where city='Delia' && SIC_code='5411'DB:business_master_new
loadtime:0.78595995903015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delphos' limit 1
loadtime:0.78600311279297 / seconds
Query Executed:select id FROM `ks` where city='Delphos' && SIC_code='5411'DB:business_master_new
loadtime:0.79738807678223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denison' limit 1
loadtime:0.79746007919312 / seconds
Query Executed:select id FROM `ks` where city='Denison' && SIC_code='5411'DB:business_master_new
loadtime:0.80268812179565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.80273509025574 / seconds
Query Executed:select id FROM `ks` where city='Dennis' && SIC_code='5411'DB:business_master_new
loadtime:0.80385804176331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denton' limit 1
loadtime:0.80389809608459 / seconds
Query Executed:select id FROM `ks` where city='Denton' && SIC_code='5411'DB:business_master_new
loadtime:0.80544209480286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.80548095703125 / seconds
Query Executed:select id FROM `ks` where city='Derby' && SIC_code='5411'DB:business_master_new
loadtime:0.80702495574951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.80707406997681 / seconds
Query Executed:select id FROM `ks` where city='Dexter' && SIC_code='5411'DB:business_master_new
loadtime:0.81093001365662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:0.81098103523254 / seconds
Query Executed:select id FROM `ks` where city='Dighton' && SIC_code='5411'DB:business_master_new
loadtime:0.81275415420532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodge City' limit 1
loadtime:0.81283116340637 / seconds
Query Executed:select id FROM `ks` where city='Dodge City' && SIC_code='5411'DB:business_master_new
loadtime:0.81584000587463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorrance' limit 1
loadtime:0.8159019947052 / seconds
Query Executed:select id FROM `ks` where city='Dorrance' && SIC_code='5411'DB:business_master_new
loadtime:0.81863903999329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglass' limit 1
loadtime:0.81867694854736 / seconds
Query Executed:select id FROM `ks` where city='Douglass' && SIC_code='5411'DB:business_master_new
loadtime:0.8200249671936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.82010102272034 / seconds
Query Executed:select id FROM `ks` where city='Dover' && SIC_code='5411'DB:business_master_new
loadtime:0.82078409194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Downs' limit 1
loadtime:0.82084512710571 / seconds
Query Executed:select id FROM `ks` where city='Downs' && SIC_code='5411'DB:business_master_new
loadtime:0.82165503501892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dresden' limit 1
loadtime:0.82169795036316 / seconds
Query Executed:select id FROM `ks` where city='Dresden' && SIC_code='5411'DB:business_master_new
loadtime:0.82352995872498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.82357811927795 / seconds
Query Executed:select id FROM `ks` where city='Durham' && SIC_code='5411'DB:business_master_new
loadtime:0.82869815826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dwight' limit 1
loadtime:0.82875609397888 / seconds
Query Executed:select id FROM `ks` where city='Dwight' && SIC_code='5411'DB:business_master_new
loadtime:0.83313298225403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastborough' limit 1
loadtime:0.83317995071411 / seconds
Query Executed:select id FROM `ks` where city='Eastborough' && SIC_code='5411'DB:business_master_new
loadtime:0.83353495597839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.83358597755432 / seconds
Query Executed:select id FROM `ks` where city='Easton' && SIC_code='5411'DB:business_master_new
loadtime:0.83432912826538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgerton' limit 1
loadtime:0.8343780040741 / seconds
Query Executed:select id FROM `ks` where city='Edgerton' && SIC_code='5411'DB:business_master_new
loadtime:0.83526110649109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmond' limit 1
loadtime:0.83531713485718 / seconds
Query Executed:select id FROM `ks` where city='Edmond' && SIC_code='5411'DB:business_master_new
loadtime:0.83592104911804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edna' limit 1
loadtime:0.83595609664917 / seconds
Query Executed:select id FROM `ks` where city='Edna' && SIC_code='5411'DB:business_master_new
loadtime:0.83695507049561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edson' limit 1
loadtime:0.83701395988464 / seconds
Query Executed:select id FROM `ks` where city='Edson' && SIC_code='5411'DB:business_master_new
loadtime:0.83976697921753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:0.83982801437378 / seconds
Query Executed:select id FROM `ks` where city='Edwardsville' && SIC_code='5411'DB:business_master_new
loadtime:0.84338998794556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.843425989151 / seconds
Query Executed:select id FROM `ks` where city='Effingham' && SIC_code='5411'DB:business_master_new
loadtime:0.84507703781128 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Dorado' limit 1
loadtime:0.84514808654785 / seconds
Query Executed:select id FROM `ks` where city='El Dorado' && SIC_code='5411'DB:business_master_new
loadtime:0.84756708145142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elbing' limit 1
loadtime:0.84761905670166 / seconds
Query Executed:select id FROM `ks` where city='Elbing' && SIC_code='5411'DB:business_master_new
loadtime:0.84875893592834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk City' limit 1
loadtime:0.84882211685181 / seconds
Query Executed:select id FROM `ks` where city='Elk City' && SIC_code='5411'DB:business_master_new
loadtime:0.85589194297791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Falls' limit 1
loadtime:0.85593509674072 / seconds
Query Executed:select id FROM `ks` where city='Elk Falls' && SIC_code='5411'DB:business_master_new
loadtime:0.85763907432556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart' limit 1
loadtime:0.85768294334412 / seconds
Query Executed:select id FROM `ks` where city='Elkhart' && SIC_code='5411'DB:business_master_new
loadtime:0.85896301269531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellinwood' limit 1
loadtime:0.85901403427124 / seconds
Query Executed:select id FROM `ks` where city='Ellinwood' && SIC_code='5411'DB:business_master_new
loadtime:0.86134314537048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellis' limit 1
loadtime:0.86138510704041 / seconds
Query Executed:select id FROM `ks` where city='Ellis' && SIC_code='5411'DB:business_master_new
loadtime:0.86264204978943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.86269307136536 / seconds
Query Executed:select id FROM `ks` where city='Ellsworth' && SIC_code='5411'DB:business_master_new
loadtime:0.86439108848572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmdale' limit 1
loadtime:0.86443710327148 / seconds
Query Executed:select id FROM `ks` where city='Elmdale' && SIC_code='5411'DB:business_master_new
loadtime:0.86603903770447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsmore' limit 1
loadtime:0.86609506607056 / seconds
Query Executed:select id FROM `ks` where city='Elsmore' && SIC_code='5411'DB:business_master_new
loadtime:0.87028694152832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:0.87032914161682 / seconds
Query Executed:select id FROM `ks` where city='Elwood' && SIC_code='5411'DB:business_master_new
loadtime:0.88396096229553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmett' limit 1
loadtime:0.88399696350098 / seconds
Query Executed:select id FROM `ks` where city='Emmett' && SIC_code='5411'DB:business_master_new
loadtime:0.88577198982239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emporia' limit 1
loadtime:0.88582301139832 / seconds
Query Executed:select id FROM `ks` where city='Emporia' && SIC_code='5411'DB:business_master_new
loadtime:0.89000105857849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood' limit 1
loadtime:0.89006900787354 / seconds
Query Executed:select id FROM `ks` where city='Englewood' && SIC_code='5411'DB:business_master_new
loadtime:0.89148902893066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ensign' limit 1
loadtime:0.89153409004211 / seconds
Query Executed:select id FROM `ks` where city='Ensign' && SIC_code='5411'DB:business_master_new
loadtime:0.89687013626099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.89689993858337 / seconds
Query Executed:select id FROM `ks` where city='Enterprise' && SIC_code='5411'DB:business_master_new
loadtime:0.90460610389709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:0.90465211868286 / seconds
Query Executed:select id FROM `ks` where city='Erie' && SIC_code='5411'DB:business_master_new
loadtime:0.90603399276733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Esbon' limit 1
loadtime:0.90607404708862 / seconds
Query Executed:select id FROM `ks` where city='Esbon' && SIC_code='5411'DB:business_master_new
loadtime:0.9082510471344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eskridge' limit 1
loadtime:0.9082989692688 / seconds
Query Executed:select id FROM `ks` where city='Eskridge' && SIC_code='5411'DB:business_master_new
loadtime:0.90925192832947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eudora' limit 1
loadtime:0.90930104255676 / seconds
Query Executed:select id FROM `ks` where city='Eudora' && SIC_code='5411'DB:business_master_new
loadtime:0.91034698486328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.91041302680969 / seconds
Query Executed:select id FROM `ks` where city='Eureka' && SIC_code='5411'DB:business_master_new
loadtime:0.91238307952881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everest' limit 1
loadtime:0.91243314743042 / seconds
Query Executed:select id FROM `ks` where city='Everest' && SIC_code='5411'DB:business_master_new
loadtime:0.92027711868286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.92032814025879 / seconds
Query Executed:select id FROM `ks` where city='Fairview' && SIC_code='5411'DB:business_master_new
loadtime:0.92710208892822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairway' limit 1
loadtime:0.92713713645935 / seconds
Query Executed:select id FROM `ks` where city='Fairway' && SIC_code='5411'DB:business_master_new
loadtime:0.92751693725586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:0.92755699157715 / seconds
Query Executed:select id FROM `ks` where city='Fall River' && SIC_code='5411'DB:business_master_new
loadtime:0.92979907989502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falun' limit 1
loadtime:0.92985510826111 / seconds
Query Executed:select id FROM `ks` where city='Falun' && SIC_code='5411'DB:business_master_new
loadtime:0.93171501159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farlington' limit 1
loadtime:0.9317581653595 / seconds
Query Executed:select id FROM `ks` where city='Farlington' && SIC_code='5411'DB:business_master_new
loadtime:0.93463611602783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.93467807769775 / seconds
Query Executed:select id FROM `ks` where city='Florence' && SIC_code='5411'DB:business_master_new
loadtime:0.9388861656189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana' limit 1
loadtime:0.93892312049866 / seconds
Query Executed:select id FROM `ks` where city='Fontana' && SIC_code='5411'DB:business_master_new
loadtime:0.9424569606781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ford' limit 1
loadtime:0.94249701499939 / seconds
Query Executed:select id FROM `ks` where city='Ford' && SIC_code='5411'DB:business_master_new
loadtime:0.94741010665894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Formoso' limit 1
loadtime:0.94745302200317 / seconds
Query Executed:select id FROM `ks` where city='Formoso' && SIC_code='5411'DB:business_master_new
loadtime:0.94936895370483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dodge' limit 1
loadtime:0.94941711425781 / seconds
Query Executed:select id FROM `ks` where city='Fort Dodge' && SIC_code='5411'DB:business_master_new
loadtime:0.94996905326843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Leavenworth' limit 1
loadtime:0.95001196861267 / seconds
Query Executed:select id FROM `ks` where city='Fort Leavenworth' && SIC_code='5411'DB:business_master_new
loadtime:0.95074701309204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Riley' limit 1
loadtime:0.95078206062317 / seconds
Query Executed:select id FROM `ks` where city='Fort Riley' && SIC_code='5411'DB:business_master_new
loadtime:0.95156502723694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Scott' limit 1
loadtime:0.95160508155823 / seconds
Query Executed:select id FROM `ks` where city='Fort Scott' && SIC_code='5411'DB:business_master_new
loadtime:0.95406794548035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:0.95412802696228 / seconds
Query Executed:select id FROM `ks` where city='Fostoria' && SIC_code='5411'DB:business_master_new
loadtime:0.95502901077271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:0.95507311820984 / seconds
Query Executed:select id FROM `ks` where city='Fowler' && SIC_code='5411'DB:business_master_new
loadtime:0.95646500587463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.95650196075439 / seconds
Query Executed:select id FROM `ks` where city='Frankfort' && SIC_code='5411'DB:business_master_new
loadtime:0.95726203918457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.95730805397034 / seconds
Query Executed:select id FROM `ks` where city='Franklin' && SIC_code='5411'DB:business_master_new
loadtime:0.95869898796082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:0.95874094963074 / seconds
Query Executed:select id FROM `ks` where city='Fredonia' && SIC_code='5411'DB:business_master_new
loadtime:0.95957612991333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeport' limit 1
loadtime:0.9596209526062 / seconds
Query Executed:select id FROM `ks` where city='Freeport' && SIC_code='5411'DB:business_master_new
loadtime:0.96135210990906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frontenac' limit 1
loadtime:0.96138501167297 / seconds
Query Executed:select id FROM `ks` where city='Frontenac' && SIC_code='5411'DB:business_master_new
loadtime:0.96375393867493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.96380305290222 / seconds
Query Executed:select id FROM `ks` where city='Fulton' && SIC_code='5411'DB:business_master_new
loadtime:0.97087502479553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galatia' limit 1
loadtime:0.97092604637146 / seconds
Query Executed:select id FROM `ks` where city='Galatia' && SIC_code='5411'DB:business_master_new
loadtime:0.97125101089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galena' limit 1
loadtime:0.97129797935486 / seconds
Query Executed:select id FROM `ks` where city='Galena' && SIC_code='5411'DB:business_master_new
loadtime:0.97249913215637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesburg' limit 1
loadtime:0.97254300117493 / seconds
Query Executed:select id FROM `ks` where city='Galesburg' && SIC_code='5411'DB:business_master_new
loadtime:0.97634601593018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galva' limit 1
loadtime:0.97640299797058 / seconds
Query Executed:select id FROM `ks` where city='Galva' && SIC_code='5411'DB:business_master_new
loadtime:0.97716999053955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.97722697257996 / seconds
Query Executed:select id FROM `ks` where city='Garden City' && SIC_code='5411'DB:business_master_new
loadtime:0.9814989566803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden Plain' limit 1
loadtime:0.98156809806824 / seconds
Query Executed:select id FROM `ks` where city='Garden Plain' && SIC_code='5411'DB:business_master_new
loadtime:0.99173903465271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.99179697036743 / seconds
Query Executed:select id FROM `ks` where city='Gardner' && SIC_code='5411'DB:business_master_new
loadtime:0.99290204048157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:0.99295115470886 / seconds
Query Executed:select id FROM `ks` where city='Garfield' && SIC_code='5411'DB:business_master_new
loadtime:0.99389600753784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:0.99392294883728 / seconds
Query Executed:select id FROM `ks` where city='Garland' && SIC_code='5411'DB:business_master_new
loadtime:0.99485397338867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnett' limit 1
loadtime:0.99489307403564 / seconds
Query Executed:select id FROM `ks` where city='Garnett' && SIC_code='5411'DB:business_master_new
loadtime:0.99655914306641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gas' limit 1
loadtime:0.99659705162048 / seconds
Query Executed:select id FROM `ks` where city='Gas' && SIC_code='5411'DB:business_master_new
loadtime:0.99863600730896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylord' limit 1
loadtime:0.99867796897888 / seconds
Query Executed:select id FROM `ks` where city='Gaylord' && SIC_code='5411'DB:business_master_new
loadtime:1.003760099411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gem' limit 1
loadtime:1.0038011074066 / seconds
Query Executed:select id FROM `ks` where city='Gem' && SIC_code='5411'DB:business_master_new
loadtime:1.0056400299072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geneseo' limit 1
loadtime:1.0056891441345 / seconds
Query Executed:select id FROM `ks` where city='Geneseo' && SIC_code='5411'DB:business_master_new
loadtime:1.0094060897827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geuda Springs' limit 1
loadtime:1.0094549655914 / seconds
Query Executed:select id FROM `ks` where city='Geuda Springs' && SIC_code='5411'DB:business_master_new
loadtime:1.0111260414124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Girard' limit 1
loadtime:1.0111739635468 / seconds
Query Executed:select id FROM `ks` where city='Girard' && SIC_code='5411'DB:business_master_new
loadtime:1.0124959945679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade' limit 1
loadtime:1.0125529766083 / seconds
Query Executed:select id FROM `ks` where city='Glade' && SIC_code='5411'DB:business_master_new
loadtime:1.0137839317322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasco' limit 1
loadtime:1.0138440132141 / seconds
Query Executed:select id FROM `ks` where city='Glasco' && SIC_code='5411'DB:business_master_new
loadtime:1.0184781551361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Elder' limit 1
loadtime:1.0185141563416 / seconds
Query Executed:select id FROM `ks` where city='Glen Elder' && SIC_code='5411'DB:business_master_new
loadtime:1.0253419876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goddard' limit 1
loadtime:1.0254011154175 / seconds
Query Executed:select id FROM `ks` where city='Goddard' && SIC_code='5411'DB:business_master_new
loadtime:1.0265159606934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goessel' limit 1
loadtime:1.0265600681305 / seconds
Query Executed:select id FROM `ks` where city='Goessel' && SIC_code='5411'DB:business_master_new
loadtime:1.0300271511078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goff' limit 1
loadtime:1.0300850868225 / seconds
Query Executed:select id FROM `ks` where city='Goff' && SIC_code='5411'DB:business_master_new
loadtime:1.0333249568939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodland' limit 1
loadtime:1.0333750247955 / seconds
Query Executed:select id FROM `ks` where city='Goodland' && SIC_code='5411'DB:business_master_new
loadtime:1.0342819690704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorham' limit 1
loadtime:1.0343210697174 / seconds
Query Executed:select id FROM `ks` where city='Gorham' && SIC_code='5411'DB:business_master_new
loadtime:1.0410039424896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gove' limit 1
loadtime:1.0410630702972 / seconds
Query Executed:select id FROM `ks` where city='Gove' && SIC_code='5411'DB:business_master_new
loadtime:1.0511031150818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grainfield' limit 1
loadtime:1.0511629581451 / seconds
Query Executed:select id FROM `ks` where city='Grainfield' && SIC_code='5411'DB:business_master_new
loadtime:1.0599679946899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantville' limit 1
loadtime:1.0600440502167 / seconds
Query Executed:select id FROM `ks` where city='Grantville' && SIC_code='5411'DB:business_master_new
loadtime:1.0630550384521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Bend' limit 1
loadtime:1.0630910396576 / seconds
Query Executed:select id FROM `ks` where city='Great Bend' && SIC_code='5411'DB:business_master_new
loadtime:1.0647721290588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:1.0648529529572 / seconds
Query Executed:select id FROM `ks` where city='Greeley' && SIC_code='5411'DB:business_master_new
loadtime:1.068675994873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green' limit 1
loadtime:1.0687329769135 / seconds
Query Executed:select id FROM `ks` where city='Green' && SIC_code='5411'DB:business_master_new
loadtime:1.0714130401611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenleaf' limit 1
loadtime:1.0714480876923 / seconds
Query Executed:select id FROM `ks` where city='Greenleaf' && SIC_code='5411'DB:business_master_new
loadtime:1.0778911113739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensburg' limit 1
loadtime:1.0779449939728 / seconds
Query Executed:select id FROM `ks` where city='Greensburg' && SIC_code='5411'DB:business_master_new
loadtime:1.079304933548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:1.0793490409851 / seconds
Query Executed:select id FROM `ks` where city='Greenwich' && SIC_code='5411'DB:business_master_new
loadtime:1.0796649456024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenola' limit 1
loadtime:1.079715013504 / seconds
Query Executed:select id FROM `ks` where city='Grenola' && SIC_code='5411'DB:business_master_new
loadtime:1.0830390453339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gridley' limit 1
loadtime:1.0830750465393 / seconds
Query Executed:select id FROM `ks` where city='Gridley' && SIC_code='5411'DB:business_master_new
loadtime:1.0876159667969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grinnell' limit 1
loadtime:1.0876750946045 / seconds
Query Executed:select id FROM `ks` where city='Grinnell' && SIC_code='5411'DB:business_master_new
loadtime:1.0888519287109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gypsum' limit 1
loadtime:1.0889050960541 / seconds
Query Executed:select id FROM `ks` where city='Gypsum' && SIC_code='5411'DB:business_master_new
loadtime:1.0979430675507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:1.0980000495911 / seconds
Query Executed:select id FROM `ks` where city='Haddam' && SIC_code='5411'DB:business_master_new
loadtime:1.0990180969238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallowell' limit 1
loadtime:1.099053144455 / seconds
Query Executed:select id FROM `ks` where city='Hallowell' && SIC_code='5411'DB:business_master_new
loadtime:1.0993340015411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halstead' limit 1
loadtime:1.099377155304 / seconds
Query Executed:select id FROM `ks` where city='Halstead' && SIC_code='5411'DB:business_master_new
loadtime:1.1001451015472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.100191116333 / seconds
Query Executed:select id FROM `ks` where city='Hamilton' && SIC_code='5411'DB:business_master_new
loadtime:1.1022911071777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.1023271083832 / seconds
Query Executed:select id FROM `ks` where city='Hanover' && SIC_code='5411'DB:business_master_new
loadtime:1.1031129360199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanston' limit 1
loadtime:1.1031620502472 / seconds
Query Executed:select id FROM `ks` where city='Hanston' && SIC_code='5411'DB:business_master_new
loadtime:1.1059019565582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardtner' limit 1
loadtime:1.105936050415 / seconds
Query Executed:select id FROM `ks` where city='Hardtner' && SIC_code='5411'DB:business_master_new
loadtime:1.1096920967102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:1.1097519397736 / seconds
Query Executed:select id FROM `ks` where city='Harper' && SIC_code='5411'DB:business_master_new
loadtime:1.1105589866638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.1106071472168 / seconds
Query Executed:select id FROM `ks` where city='Hartford' && SIC_code='5411'DB:business_master_new
loadtime:1.1134970188141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harveyville' limit 1
loadtime:1.11354804039 / seconds
Query Executed:select id FROM `ks` where city='Harveyville' && SIC_code='5411'DB:business_master_new
loadtime:1.1149189472198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havana' limit 1
loadtime:1.1149759292603 / seconds
Query Executed:select id FROM `ks` where city='Havana' && SIC_code='5411'DB:business_master_new
loadtime:1.1161389350891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haven' limit 1
loadtime:1.1161749362946 / seconds
Query Executed:select id FROM `ks` where city='Haven' && SIC_code='5411'DB:business_master_new
loadtime:1.1169140338898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havensville' limit 1
loadtime:1.116975069046 / seconds
Query Executed:select id FROM `ks` where city='Havensville' && SIC_code='5411'DB:business_master_new
loadtime:1.1184830665588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haviland' limit 1
loadtime:1.1185319423676 / seconds
Query Executed:select id FROM `ks` where city='Haviland' && SIC_code='5411'DB:business_master_new
loadtime:1.1227200031281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hays' limit 1
loadtime:1.1227560043335 / seconds
Query Executed:select id FROM `ks` where city='Hays' && SIC_code='5411'DB:business_master_new
loadtime:1.1253070831299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haysville' limit 1
loadtime:1.1253690719604 / seconds
Query Executed:select id FROM `ks` where city='Haysville' && SIC_code='5411'DB:business_master_new
loadtime:1.1262581348419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelton' limit 1
loadtime:1.1263091564178 / seconds
Query Executed:select id FROM `ks` where city='Hazelton' && SIC_code='5411'DB:business_master_new
loadtime:1.1275341510773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Healy' limit 1
loadtime:1.1275839805603 / seconds
Query Executed:select id FROM `ks` where city='Healy' && SIC_code='5411'DB:business_master_new
loadtime:1.1298921108246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heizer' limit 1
loadtime:1.1299419403076 / seconds
Query Executed:select id FROM `ks` where city='Heizer' && SIC_code='5411'DB:business_master_new
loadtime:1.130429983139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hepler' limit 1
loadtime:1.130481004715 / seconds
Query Executed:select id FROM `ks` where city='Hepler' && SIC_code='5411'DB:business_master_new
loadtime:1.1350860595703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herington' limit 1
loadtime:1.1351211071014 / seconds
Query Executed:select id FROM `ks` where city='Herington' && SIC_code='5411'DB:business_master_new
loadtime:1.1359651088715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herndon' limit 1
loadtime:1.1360211372375 / seconds
Query Executed:select id FROM `ks` where city='Herndon' && SIC_code='5411'DB:business_master_new
loadtime:1.1389980316162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesston' limit 1
loadtime:1.1390459537506 / seconds
Query Executed:select id FROM `ks` where city='Hesston' && SIC_code='5411'DB:business_master_new
loadtime:1.1400310993195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiattville' limit 1
loadtime:1.1400761604309 / seconds
Query Executed:select id FROM `ks` where city='Hiattville' && SIC_code='5411'DB:business_master_new
loadtime:1.1404030323029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:1.1404540538788 / seconds
Query Executed:select id FROM `ks` where city='Hiawatha' && SIC_code='5411'DB:business_master_new
loadtime:1.1415979862213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:1.1416561603546 / seconds
Query Executed:select id FROM `ks` where city='Highland' && SIC_code='5411'DB:business_master_new
loadtime:1.1472239494324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill City' limit 1
loadtime:1.1472690105438 / seconds
Query Executed:select id FROM `ks` where city='Hill City' && SIC_code='5411'DB:business_master_new
loadtime:1.1480529308319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.1481039524078 / seconds
Query Executed:select id FROM `ks` where city='Hillsboro' && SIC_code='5411'DB:business_master_new
loadtime:1.1489419937134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:1.1489901542664 / seconds
Query Executed:select id FROM `ks` where city='Hillsdale' && SIC_code='5411'DB:business_master_new
loadtime:1.1505651473999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoisington' limit 1
loadtime:1.15061211586 / seconds
Query Executed:select id FROM `ks` where city='Hoisington' && SIC_code='5411'DB:business_master_new
loadtime:1.1514110565186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcomb' limit 1
loadtime:1.15145611763 / seconds
Query Executed:select id FROM `ks` where city='Holcomb' && SIC_code='5411'DB:business_master_new
loadtime:1.1528971195221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollenberg' limit 1
loadtime:1.1529560089111 / seconds
Query Executed:select id FROM `ks` where city='Hollenberg' && SIC_code='5411'DB:business_master_new
loadtime:1.1544461250305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holton' limit 1
loadtime:1.1544740200043 / seconds
Query Executed:select id FROM `ks` where city='Holton' && SIC_code='5411'DB:business_master_new
loadtime:1.1557490825653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyrood' limit 1
loadtime:1.1557941436768 / seconds
Query Executed:select id FROM `ks` where city='Holyrood' && SIC_code='5411'DB:business_master_new
loadtime:1.1586010456085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Home' limit 1
loadtime:1.1586511135101 / seconds
Query Executed:select id FROM `ks` where city='Home' && SIC_code='5411'DB:business_master_new
loadtime:1.1613030433655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:1.1613340377808 / seconds
Query Executed:select id FROM `ks` where city='Hope' && SIC_code='5411'DB:business_master_new
loadtime:1.1651151180267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horton' limit 1
loadtime:1.1651589870453 / seconds
Query Executed:select id FROM `ks` where city='Horton' && SIC_code='5411'DB:business_master_new
loadtime:1.1661710739136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:1.1662261486053 / seconds
Query Executed:select id FROM `ks` where city='Howard' && SIC_code='5411'DB:business_master_new
loadtime:1.1669969558716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoxie' limit 1
loadtime:1.1670401096344 / seconds
Query Executed:select id FROM `ks` where city='Hoxie' && SIC_code='5411'DB:business_master_new
loadtime:1.1678249835968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoyt' limit 1
loadtime:1.1678559780121 / seconds
Query Executed:select id FROM `ks` where city='Hoyt' && SIC_code='5411'DB:business_master_new
loadtime:1.1722581386566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.1723010540009 / seconds
Query Executed:select id FROM `ks` where city='Hudson' && SIC_code='5411'DB:business_master_new
loadtime:1.1747181415558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hugoton' limit 1
loadtime:1.1747529506683 / seconds
Query Executed:select id FROM `ks` where city='Hugoton' && SIC_code='5411'DB:business_master_new
loadtime:1.1761250495911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:1.176167011261 / seconds
Query Executed:select id FROM `ks` where city='Humboldt' && SIC_code='5411'DB:business_master_new
loadtime:1.1769349575043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hunnewell' limit 1
loadtime:1.1769800186157 / seconds
Query Executed:select id FROM `ks` where city='Hunnewell' && SIC_code='5411'DB:business_master_new
loadtime:1.1772770881653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hunter' limit 1
loadtime:1.1773059368134 / seconds
Query Executed:select id FROM `ks` where city='Hunter' && SIC_code='5411'DB:business_master_new
loadtime:1.1795110702515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huron' limit 1
loadtime:1.1795520782471 / seconds
Query Executed:select id FROM `ks` where city='Huron' && SIC_code='5411'DB:business_master_new
loadtime:1.181193113327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hutchinson' limit 1
loadtime:1.1812300682068 / seconds
Query Executed:select id FROM `ks` where city='Hutchinson' && SIC_code='5411'DB:business_master_new
loadtime:1.1847760677338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:1.1848440170288 / seconds
Query Executed:select id FROM `ks` where city='Independence' && SIC_code='5411'DB:business_master_new
loadtime:1.1859290599823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingalls' limit 1
loadtime:1.1859700679779 / seconds
Query Executed:select id FROM `ks` where city='Ingalls' && SIC_code='5411'DB:business_master_new
loadtime:1.1893849372864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inman' limit 1
loadtime:1.1894359588623 / seconds
Query Executed:select id FROM `ks` where city='Inman' && SIC_code='5411'DB:business_master_new
loadtime:1.1902260780334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iola' limit 1
loadtime:1.1902689933777 / seconds
Query Executed:select id FROM `ks` where city='Iola' && SIC_code='5411'DB:business_master_new
loadtime:1.1919410228729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isabel' limit 1
loadtime:1.1920030117035 / seconds
Query Executed:select id FROM `ks` where city='Isabel' && SIC_code='5411'DB:business_master_new
loadtime:1.1939561367035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iuka' limit 1
loadtime:1.1940150260925 / seconds
Query Executed:select id FROM `ks` where city='Iuka' && SIC_code='5411'DB:business_master_new
loadtime:1.1956520080566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.1957020759583 / seconds
Query Executed:select id FROM `ks` where city='Jamestown' && SIC_code='5411'DB:business_master_new
loadtime:1.1970601081848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jennings' limit 1
loadtime:1.1971070766449 / seconds
Query Executed:select id FROM `ks` where city='Jennings' && SIC_code='5411'DB:business_master_new
loadtime:1.1995091438293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jetmore' limit 1
loadtime:1.1995511054993 / seconds
Query Executed:select id FROM `ks` where city='Jetmore' && SIC_code='5411'DB:business_master_new
loadtime:1.2007870674133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell' limit 1
loadtime:1.2008631229401 / seconds
Query Executed:select id FROM `ks` where city='Jewell' && SIC_code='5411'DB:business_master_new
loadtime:1.2045011520386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson' limit 1
loadtime:1.2045669555664 / seconds
Query Executed:select id FROM `ks` where city='Johnson' && SIC_code='5411'DB:business_master_new
loadtime:1.2056260108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction City' limit 1
loadtime:1.2056739330292 / seconds
Query Executed:select id FROM `ks` where city='Junction City' && SIC_code='5411'DB:business_master_new
loadtime:1.2091009616852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalvesta' limit 1
loadtime:1.2091479301453 / seconds
Query Executed:select id FROM `ks` where city='Kalvesta' && SIC_code='5411'DB:business_master_new
loadtime:1.2095890045166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanopolis' limit 1
loadtime:1.2096259593964 / seconds
Query Executed:select id FROM `ks` where city='Kanopolis' && SIC_code='5411'DB:business_master_new
loadtime:1.2105481624603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanorado' limit 1
loadtime:1.2105920314789 / seconds
Query Executed:select id FROM `ks` where city='Kanorado' && SIC_code='5411'DB:business_master_new
loadtime:1.2133409976959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kansas City' limit 1
loadtime:1.2133800983429 / seconds
Query Executed:select id FROM `ks` where city='Kansas City' && SIC_code='5411'DB:business_master_new
loadtime:1.2201790809631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kechi' limit 1
loadtime:1.220251083374 / seconds
Query Executed:select id FROM `ks` where city='Kechi' && SIC_code='5411'DB:business_master_new
loadtime:1.2266359329224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:1.2266790866852 / seconds
Query Executed:select id FROM `ks` where city='Kendall' && SIC_code='5411'DB:business_master_new
loadtime:1.2279369831085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:1.2279710769653 / seconds
Query Executed:select id FROM `ks` where city='Kensington' && SIC_code='5411'DB:business_master_new
loadtime:1.2349269390106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kincaid' limit 1
loadtime:1.2349579334259 / seconds
Query Executed:select id FROM `ks` where city='Kincaid' && SIC_code='5411'DB:business_master_new
loadtime:1.2355959415436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1
loadtime:1.2356331348419 / seconds
Query Executed:select id FROM `ks` where city='Kingman' && SIC_code='5411'DB:business_master_new
loadtime:1.2364540100098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsdown' limit 1
loadtime:1.2364890575409 / seconds
Query Executed:select id FROM `ks` where city='Kingsdown' && SIC_code='5411'DB:business_master_new
loadtime:1.2367751598358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsley' limit 1
loadtime:1.2368221282959 / seconds
Query Executed:select id FROM `ks` where city='Kinsley' && SIC_code='5411'DB:business_master_new
loadtime:1.2375910282135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiowa' limit 1
loadtime:1.2376220226288 / seconds
Query Executed:select id FROM `ks` where city='Kiowa' && SIC_code='5411'DB:business_master_new
loadtime:1.2384140491486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirwin' limit 1
loadtime:1.2384550571442 / seconds
Query Executed:select id FROM `ks` where city='Kirwin' && SIC_code='5411'DB:business_master_new
loadtime:1.2394700050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kismet' limit 1
loadtime:1.239511013031 / seconds
Query Executed:select id FROM `ks` where city='Kismet' && SIC_code='5411'DB:business_master_new
loadtime:1.2421300411224 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:1.242171049118 / seconds
Query Executed:select id FROM `ks` where city='La Crosse' && SIC_code='5411'DB:business_master_new
loadtime:1.2435140609741 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Cygne' limit 1
loadtime:1.2435579299927 / seconds
Query Executed:select id FROM `ks` where city='La Cygne' && SIC_code='5411'DB:business_master_new
loadtime:1.243940114975 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Harpe' limit 1
loadtime:1.2439751625061 / seconds
Query Executed:select id FROM `ks` where city='La Harpe' && SIC_code='5411'DB:business_master_new
loadtime:1.2464179992676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacygne' limit 1
loadtime:1.2464470863342 / seconds
Query Executed:select id FROM `ks` where city='Lacygne' && SIC_code='5411'DB:business_master_new
loadtime:1.2474131584167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafontaine' limit 1
loadtime:1.2474570274353 / seconds
Query Executed:select id FROM `ks` where city='Lafontaine' && SIC_code='5411'DB:business_master_new
loadtime:1.2477209568024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:1.2477550506592 / seconds
Query Executed:select id FROM `ks` where city='Lake City' && SIC_code='5411'DB:business_master_new
loadtime:1.2481160163879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Quivira' limit 1
loadtime:1.2481451034546 / seconds
Query Executed:select id FROM `ks` where city='Lake Quivira' && SIC_code='5411'DB:business_master_new
loadtime:1.2484860420227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakin' limit 1
loadtime:1.2485189437866 / seconds
Query Executed:select id FROM `ks` where city='Lakin' && SIC_code='5411'DB:business_master_new
loadtime:1.2493150234222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:1.2493550777435 / seconds
Query Executed:select id FROM `ks` where city='Lamont' && SIC_code='5411'DB:business_master_new
loadtime:1.2496430873871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.2496740818024 / seconds
Query Executed:select id FROM `ks` where city='Lancaster' && SIC_code='5411'DB:business_master_new
loadtime:1.2516491413116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:1.251678943634 / seconds
Query Executed:select id FROM `ks` where city='Lane' && SIC_code='5411'DB:business_master_new
loadtime:1.253436088562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langdon' limit 1
loadtime:1.2534720897675 / seconds
Query Executed:select id FROM `ks` where city='Langdon' && SIC_code='5411'DB:business_master_new
loadtime:1.2541670799255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:1.2542369365692 / seconds
Query Executed:select id FROM `ks` where city='Lansing' && SIC_code='5411'DB:business_master_new
loadtime:1.2553060054779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larned' limit 1
loadtime:1.2553639411926 / seconds
Query Executed:select id FROM `ks` where city='Larned' && SIC_code='5411'DB:business_master_new
loadtime:1.2565839290619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latham' limit 1
loadtime:1.2566430568695 / seconds
Query Executed:select id FROM `ks` where city='Latham' && SIC_code='5411'DB:business_master_new
loadtime:1.2579441070557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.2579920291901 / seconds
Query Executed:select id FROM `ks` where city='Lawrence' && SIC_code='5411'DB:business_master_new
loadtime:1.2613229751587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Roy' limit 1
loadtime:1.2613890171051 / seconds
Query Executed:select id FROM `ks` where city='Le Roy' && SIC_code='5411'DB:business_master_new
loadtime:1.2628450393677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leavenworth' limit 1
loadtime:1.2628951072693 / seconds
Query Executed:select id FROM `ks` where city='Leavenworth' && SIC_code='5411'DB:business_master_new
loadtime:1.2648439407349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leawood' limit 1
loadtime:1.2648949623108 / seconds
Query Executed:select id FROM `ks` where city='Leawood' && SIC_code='5411'DB:business_master_new
loadtime:1.2663271427155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:1.2663910388947 / seconds
Query Executed:select id FROM `ks` where city='Lebanon' && SIC_code='5411'DB:business_master_new
loadtime:1.2686531543732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebo' limit 1
loadtime:1.2687139511108 / seconds
Query Executed:select id FROM `ks` where city='Lebo' && SIC_code='5411'DB:business_master_new
loadtime:1.2694909572601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lecompton' limit 1
loadtime:1.2695341110229 / seconds
Query Executed:select id FROM `ks` where city='Lecompton' && SIC_code='5411'DB:business_master_new
loadtime:1.2702920436859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehigh' limit 1
loadtime:1.2703421115875 / seconds
Query Executed:select id FROM `ks` where city='Lehigh' && SIC_code='5411'DB:business_master_new
loadtime:1.2707481384277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenexa' limit 1
loadtime:1.2707850933075 / seconds
Query Executed:select id FROM `ks` where city='Lenexa' && SIC_code='5411'DB:business_master_new
loadtime:1.2727119922638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenora' limit 1
loadtime:1.2727870941162 / seconds
Query Executed:select id FROM `ks` where city='Lenora' && SIC_code='5411'DB:business_master_new
loadtime:1.2760651111603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:1.2761270999908 / seconds
Query Executed:select id FROM `ks` where city='Leon' && SIC_code='5411'DB:business_master_new
loadtime:1.2774670124054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leona' limit 1
loadtime:1.2775030136108 / seconds
Query Executed:select id FROM `ks` where city='Leona' && SIC_code='5411'DB:business_master_new
loadtime:1.2778029441833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonardville' limit 1
loadtime:1.2778649330139 / seconds
Query Executed:select id FROM `ks` where city='Leonardville' && SIC_code='5411'DB:business_master_new
loadtime:1.2785079479218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leoti' limit 1
loadtime:1.2785501480103 / seconds
Query Executed:select id FROM `ks` where city='Leoti' && SIC_code='5411'DB:business_master_new
loadtime:1.2801251411438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levant' limit 1
loadtime:1.2801830768585 / seconds
Query Executed:select id FROM `ks` where city='Levant' && SIC_code='5411'DB:business_master_new
loadtime:1.2806000709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:1.2806479930878 / seconds
Query Executed:select id FROM `ks` where city='Lewis' && SIC_code='5411'DB:business_master_new
loadtime:1.2822070121765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberal' limit 1
loadtime:1.2822680473328 / seconds
Query Executed:select id FROM `ks` where city='Liberal' && SIC_code='5411'DB:business_master_new
loadtime:1.2842559814453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:1.2843220233917 / seconds
Query Executed:select id FROM `ks` where city='Liberty' && SIC_code='5411'DB:business_master_new
loadtime:1.2855710983276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liebenthal' limit 1
loadtime:1.2856070995331 / seconds
Query Executed:select id FROM `ks` where city='Liebenthal' && SIC_code='5411'DB:business_master_new
loadtime:1.2859680652618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.2860219478607 / seconds
Query Executed:select id FROM `ks` where city='Lincoln' && SIC_code='5411'DB:business_master_new
loadtime:1.2868499755859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnville' limit 1
loadtime:1.2869091033936 / seconds
Query Executed:select id FROM `ks` where city='Lincolnville' && SIC_code='5411'DB:business_master_new
loadtime:1.2882421016693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindsborg' limit 1
loadtime:1.2882900238037 / seconds
Query Executed:select id FROM `ks` where city='Lindsborg' && SIC_code='5411'DB:business_master_new
loadtime:1.2891621589661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linn' limit 1
loadtime:1.2892079353333 / seconds
Query Executed:select id FROM `ks` where city='Linn' && SIC_code='5411'DB:business_master_new
loadtime:1.2899789810181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.2900359630585 / seconds
Query Executed:select id FROM `ks` where city='Linwood' && SIC_code='5411'DB:business_master_new
loadtime:1.2922959327698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little River' limit 1
loadtime:1.2923460006714 / seconds
Query Executed:select id FROM `ks` where city='Little River' && SIC_code='5411'DB:business_master_new
loadtime:1.2930901050568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:1.293154001236 / seconds
Query Executed:select id FROM `ks` where city='Logan' && SIC_code='5411'DB:business_master_new
loadtime:1.2938930988312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Island' limit 1
loadtime:1.2939369678497 / seconds
Query Executed:select id FROM `ks` where city='Long Island' && SIC_code='5411'DB:business_master_new
loadtime:1.2944300174713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longford' limit 1
loadtime:1.2944860458374 / seconds
Query Executed:select id FROM `ks` where city='Longford' && SIC_code='5411'DB:business_master_new
loadtime:1.2951490879059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longton' limit 1
loadtime:1.2951900959015 / seconds
Query Executed:select id FROM `ks` where city='Longton' && SIC_code='5411'DB:business_master_new
loadtime:1.2975080013275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorraine' limit 1
loadtime:1.2975659370422 / seconds
Query Executed:select id FROM `ks` where city='Lorraine' && SIC_code='5411'DB:business_master_new
loadtime:1.298840045929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Springs' limit 1
loadtime:1.2988860607147 / seconds
Query Executed:select id FROM `ks` where city='Lost Springs' && SIC_code='5411'DB:business_master_new
loadtime:1.299947977066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisburg' limit 1
loadtime:1.2999999523163 / seconds
Query Executed:select id FROM `ks` where city='Louisburg' && SIC_code='5411'DB:business_master_new
loadtime:1.3008501529694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:1.3009071350098 / seconds
Query Executed:select id FROM `ks` where city='Louisville' && SIC_code='5411'DB:business_master_new
loadtime:1.3011710643768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucas' limit 1
loadtime:1.3012070655823 / seconds
Query Executed:select id FROM `ks` where city='Lucas' && SIC_code='5411'DB:business_master_new
loadtime:1.301931142807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludell' limit 1
loadtime:1.3019890785217 / seconds
Query Executed:select id FROM `ks` where city='Ludell' && SIC_code='5411'DB:business_master_new
loadtime:1.3029861450195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luray' limit 1
loadtime:1.3030390739441 / seconds
Query Executed:select id FROM `ks` where city='Luray' && SIC_code='5411'DB:business_master_new
loadtime:1.3050701618195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon' limit 1
loadtime:1.3051061630249 / seconds
Query Executed:select id FROM `ks` where city='Lyndon' && SIC_code='5411'DB:business_master_new
loadtime:1.305890083313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:1.3059411048889 / seconds
Query Executed:select id FROM `ks` where city='Lyons' && SIC_code='5411'DB:business_master_new
loadtime:1.3073041439056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macksville' limit 1
loadtime:1.3073501586914 / seconds
Query Executed:select id FROM `ks` where city='Macksville' && SIC_code='5411'DB:business_master_new
loadtime:1.3104219436646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.3104779720306 / seconds
Query Executed:select id FROM `ks` where city='Madison' && SIC_code='5411'DB:business_master_new
loadtime:1.3117051124573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mahaska' limit 1
loadtime:1.3117649555206 / seconds
Query Executed:select id FROM `ks` where city='Mahaska' && SIC_code='5411'DB:business_master_new
loadtime:1.312695980072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maize' limit 1
loadtime:1.3127319812775 / seconds
Query Executed:select id FROM `ks` where city='Maize' && SIC_code='5411'DB:business_master_new
loadtime:1.31405210495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manhattan' limit 1
loadtime:1.314110994339 / seconds
Query Executed:select id FROM `ks` where city='Manhattan' && SIC_code='5411'DB:business_master_new
loadtime:1.3158619403839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mankato' limit 1
loadtime:1.3159260749817 / seconds
Query Executed:select id FROM `ks` where city='Mankato' && SIC_code='5411'DB:business_master_new
loadtime:1.3167021274567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manter' limit 1
loadtime:1.31676197052 / seconds
Query Executed:select id FROM `ks` where city='Manter' && SIC_code='5411'DB:business_master_new
loadtime:1.3178889751434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple City' limit 1
loadtime:1.3179309368134 / seconds
Query Executed:select id FROM `ks` where city='Maple City' && SIC_code='5411'DB:business_master_new
loadtime:1.3182661533356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Hill' limit 1
loadtime:1.3183150291443 / seconds
Query Executed:select id FROM `ks` where city='Maple Hill' && SIC_code='5411'DB:business_master_new
loadtime:1.3206140995026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:1.3206639289856 / seconds
Query Executed:select id FROM `ks` where city='Mapleton' && SIC_code='5411'DB:business_master_new
loadtime:1.3213040828705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marienthal' limit 1
loadtime:1.3213520050049 / seconds
Query Executed:select id FROM `ks` where city='Marienthal' && SIC_code='5411'DB:business_master_new
loadtime:1.3223159313202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.3223640918732 / seconds
Query Executed:select id FROM `ks` where city='Marion' && SIC_code='5411'DB:business_master_new
loadtime:1.3234651088715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:1.323527097702 / seconds
Query Executed:select id FROM `ks` where city='Marquette' && SIC_code='5411'DB:business_master_new
loadtime:1.324294090271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysville' limit 1
loadtime:1.3243491649628 / seconds
Query Executed:select id FROM `ks` where city='Marysville' && SIC_code='5411'DB:business_master_new
loadtime:1.3254959583282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matfield Green' limit 1
loadtime:1.3255550861359 / seconds
Query Executed:select id FROM `ks` where city='Matfield Green' && SIC_code='5411'DB:business_master_new
loadtime:1.3263931274414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayetta' limit 1
loadtime:1.3264291286469 / seconds
Query Executed:select id FROM `ks` where city='Mayetta' && SIC_code='5411'DB:business_master_new
loadtime:1.3272309303284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:1.3272869586945 / seconds
Query Executed:select id FROM `ks` where city='Mayfield' && SIC_code='5411'DB:business_master_new
loadtime:1.3290541172028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cracken' limit 1
loadtime:1.3290979862213 / seconds
Query Executed:select id FROM `ks` where city='Mc Cracken' && SIC_code='5411'DB:business_master_new
loadtime:1.3310899734497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cune' limit 1
loadtime:1.3311409950256 / seconds
Query Executed:select id FROM `ks` where city='Mc Cune' && SIC_code='5411'DB:business_master_new
loadtime:1.3325231075287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Donald' limit 1
loadtime:1.3325660228729 / seconds
Query Executed:select id FROM `ks` where city='Mc Donald' && SIC_code='5411'DB:business_master_new
loadtime:1.333151102066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farland' limit 1
loadtime:1.3332080841064 / seconds
Query Executed:select id FROM `ks` where city='Mc Farland' && SIC_code='5411'DB:business_master_new
loadtime:1.333554983139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Louth' limit 1
loadtime:1.333603143692 / seconds
Query Executed:select id FROM `ks` where city='Mc Louth' && SIC_code='5411'DB:business_master_new
loadtime:1.3343911170959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Pherson' limit 1
loadtime:1.334440946579 / seconds
Query Executed:select id FROM `ks` where city='Mc Pherson' && SIC_code='5411'DB:business_master_new
loadtime:1.3348360061646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcconnell Afb' limit 1
loadtime:1.334881067276 / seconds
Query Executed:select id FROM `ks` where city='Mcconnell Afb' && SIC_code='5411'DB:business_master_new
loadtime:1.3359479904175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcpherson' limit 1
loadtime:1.3359839916229 / seconds
Query Executed:select id FROM `ks` where city='Mcpherson' && SIC_code='5411'DB:business_master_new
loadtime:1.3378579616547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meade' limit 1
loadtime:1.3379189968109 / seconds
Query Executed:select id FROM `ks` where city='Meade' && SIC_code='5411'DB:business_master_new
loadtime:1.3389570713043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medicine Lodge' limit 1
loadtime:1.3390090465546 / seconds
Query Executed:select id FROM `ks` where city='Medicine Lodge' && SIC_code='5411'DB:business_master_new
loadtime:1.3398549556732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvern' limit 1
loadtime:1.3399140834808 / seconds
Query Executed:select id FROM `ks` where city='Melvern' && SIC_code='5411'DB:business_master_new
loadtime:1.3412959575653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menlo' limit 1
loadtime:1.3413460254669 / seconds
Query Executed:select id FROM `ks` where city='Menlo' && SIC_code='5411'DB:business_master_new
loadtime:1.3416590690613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentor' limit 1
loadtime:1.3416950702667 / seconds
Query Executed:select id FROM `ks` where city='Mentor' && SIC_code='5411'DB:business_master_new
loadtime:1.3419780731201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:1.3420259952545 / seconds
Query Executed:select id FROM `ks` where city='Meriden' && SIC_code='5411'DB:business_master_new
loadtime:1.342796087265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merriam' limit 1
loadtime:1.3428750038147 / seconds
Query Executed:select id FROM `ks` where city='Merriam' && SIC_code='5411'DB:business_master_new
loadtime:1.3432719707489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:1.3433210849762 / seconds
Query Executed:select id FROM `ks` where city='Milan' && SIC_code='5411'DB:business_master_new
loadtime:1.3436920642853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.343740940094 / seconds
Query Executed:select id FROM `ks` where city='Milford' && SIC_code='5411'DB:business_master_new
loadtime:1.3453741073608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.3454239368439 / seconds
Query Executed:select id FROM `ks` where city='Milton' && SIC_code='5411'DB:business_master_new
loadtime:1.3475501537323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miltonvale' limit 1
loadtime:1.3475980758667 / seconds
Query Executed:select id FROM `ks` where city='Miltonvale' && SIC_code='5411'DB:business_master_new
loadtime:1.3508410453796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minneapolis' limit 1
loadtime:1.3508851528168 / seconds
Query Executed:select id FROM `ks` where city='Minneapolis' && SIC_code='5411'DB:business_master_new
loadtime:1.3517510890961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minneola' limit 1
loadtime:1.3518221378326 / seconds
Query Executed:select id FROM `ks` where city='Minneola' && SIC_code='5411'DB:business_master_new
loadtime:1.3534519672394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission' limit 1
loadtime:1.3535101413727 / seconds
Query Executed:select id FROM `ks` where city='Mission' && SIC_code='5411'DB:business_master_new
loadtime:1.354984998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission Hills' limit 1
loadtime:1.3550429344177 / seconds
Query Executed:select id FROM `ks` where city='Mission Hills' && SIC_code='5411'DB:business_master_new
loadtime:1.3553500175476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modoc' limit 1
loadtime:1.3554010391235 / seconds
Query Executed:select id FROM `ks` where city='Modoc' && SIC_code='5411'DB:business_master_new
loadtime:1.3556640148163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moline' limit 1
loadtime:1.3556909561157 / seconds
Query Executed:select id FROM `ks` where city='Moline' && SIC_code='5411'DB:business_master_new
loadtime:1.3568470478058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:1.3569030761719 / seconds
Query Executed:select id FROM `ks` where city='Montezuma' && SIC_code='5411'DB:business_master_new
loadtime:1.3576929569244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument' limit 1
loadtime:1.3577461242676 / seconds
Query Executed:select id FROM `ks` where city='Monument' && SIC_code='5411'DB:business_master_new
loadtime:1.3585159778595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moran' limit 1
loadtime:1.3585569858551 / seconds
Query Executed:select id FROM `ks` where city='Moran' && SIC_code='5411'DB:business_master_new
loadtime:1.3593499660492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganville' limit 1
loadtime:1.3594081401825 / seconds
Query Executed:select id FROM `ks` where city='Morganville' && SIC_code='5411'DB:business_master_new
loadtime:1.3598170280457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morland' limit 1
loadtime:1.3598580360413 / seconds
Query Executed:select id FROM `ks` where city='Morland' && SIC_code='5411'DB:business_master_new
loadtime:1.3604950904846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrill' limit 1
loadtime:1.3605380058289 / seconds
Query Executed:select id FROM `ks` where city='Morrill' && SIC_code='5411'DB:business_master_new
loadtime:1.3612971305847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrowville' limit 1
loadtime:1.3613469600677 / seconds
Query Executed:select id FROM `ks` where city='Morrowville' && SIC_code='5411'DB:business_master_new
loadtime:1.3620231151581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:1.3620619773865 / seconds
Query Executed:select id FROM `ks` where city='Moscow' && SIC_code='5411'DB:business_master_new
loadtime:1.3635210990906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound City' limit 1
loadtime:1.363578081131 / seconds
Query Executed:select id FROM `ks` where city='Mound City' && SIC_code='5411'DB:business_master_new
loadtime:1.3643620014191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound Valley' limit 1
loadtime:1.3644111156464 / seconds
Query Executed:select id FROM `ks` where city='Mound Valley' && SIC_code='5411'DB:business_master_new
loadtime:1.3648991584778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moundridge' limit 1
loadtime:1.3649470806122 / seconds
Query Executed:select id FROM `ks` where city='Moundridge' && SIC_code='5411'DB:business_master_new
loadtime:1.3660280704498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Hope' limit 1
loadtime:1.3660719394684 / seconds
Query Executed:select id FROM `ks` where city='Mount Hope' && SIC_code='5411'DB:business_master_new
loadtime:1.3689579963684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Hope' limit 1
loadtime:1.3690130710602 / seconds
Query Executed:select id FROM `ks` where city='Mt Hope' && SIC_code='5411'DB:business_master_new
loadtime:1.3692989349365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulberry' limit 1
loadtime:1.369334936142 / seconds
Query Executed:select id FROM `ks` where city='Mulberry' && SIC_code='5411'DB:business_master_new
loadtime:1.3701090812683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullinville' limit 1
loadtime:1.3701450824738 / seconds
Query Executed:select id FROM `ks` where city='Mullinville' && SIC_code='5411'DB:business_master_new
loadtime:1.3709759712219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulvane' limit 1
loadtime:1.3710300922394 / seconds
Query Executed:select id FROM `ks` where city='Mulvane' && SIC_code='5411'DB:business_master_new
loadtime:1.371838092804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munden' limit 1
loadtime:1.3718950748444 / seconds
Query Executed:select id FROM `ks` where city='Munden' && SIC_code='5411'DB:business_master_new
loadtime:1.3729341030121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murdock' limit 1
loadtime:1.3729701042175 / seconds
Query Executed:select id FROM `ks` where city='Murdock' && SIC_code='5411'DB:business_master_new
loadtime:1.3736391067505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscotah' limit 1
loadtime:1.3736751079559 / seconds
Query Executed:select id FROM `ks` where city='Muscotah' && SIC_code='5411'DB:business_master_new
loadtime:1.3741209506989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Narka' limit 1
loadtime:1.3741719722748 / seconds
Query Executed:select id FROM `ks` where city='Narka' && SIC_code='5411'DB:business_master_new
loadtime:1.3745491504669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:1.3745939731598 / seconds
Query Executed:select id FROM `ks` where city='Nashville' && SIC_code='5411'DB:business_master_new
loadtime:1.3759701251984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natoma' limit 1
loadtime:1.3760061264038 / seconds
Query Executed:select id FROM `ks` where city='Natoma' && SIC_code='5411'DB:business_master_new
loadtime:1.3771650791168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navarre' limit 1
loadtime:1.3772261142731 / seconds
Query Executed:select id FROM `ks` where city='Navarre' && SIC_code='5411'DB:business_master_new
loadtime:1.3775360584259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neal' limit 1
loadtime:1.377583026886 / seconds
Query Executed:select id FROM `ks` where city='Neal' && SIC_code='5411'DB:business_master_new
loadtime:1.378072977066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nekoma' limit 1
loadtime:1.3781080245972 / seconds
Query Executed:select id FROM `ks` where city='Nekoma' && SIC_code='5411'DB:business_master_new
loadtime:1.378438949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neodesha' limit 1
loadtime:1.3784980773926 / seconds
Query Executed:select id FROM `ks` where city='Neodesha' && SIC_code='5411'DB:business_master_new
loadtime:1.3793270587921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neosho Falls' limit 1
loadtime:1.379387140274 / seconds
Query Executed:select id FROM `ks` where city='Neosho Falls' && SIC_code='5411'DB:business_master_new
loadtime:1.3797700405121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neosho Rapids' limit 1
loadtime:1.379802942276 / seconds
Query Executed:select id FROM `ks` where city='Neosho Rapids' && SIC_code='5411'DB:business_master_new
loadtime:1.3802230358124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ness City' limit 1
loadtime:1.3802709579468 / seconds
Query Executed:select id FROM `ks` where city='Ness City' && SIC_code='5411'DB:business_master_new
loadtime:1.3810920715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Netawaka' limit 1
loadtime:1.3811371326447 / seconds
Query Executed:select id FROM `ks` where city='Netawaka' && SIC_code='5411'DB:business_master_new
loadtime:1.3820509910583 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albany' limit 1
loadtime:1.3821020126343 / seconds
Query Executed:select id FROM `ks` where city='New Albany' && SIC_code='5411'DB:business_master_new
loadtime:1.3824491500854 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Cambria' limit 1
loadtime:1.382504940033 / seconds
Query Executed:select id FROM `ks` where city='New Cambria' && SIC_code='5411'DB:business_master_new
loadtime:1.3832180500031 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Century' limit 1
loadtime:1.383269071579 / seconds
Query Executed:select id FROM `ks` where city='New Century' && SIC_code='5411'DB:business_master_new
loadtime:1.3838770389557 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Strawn' limit 1
loadtime:1.3839190006256 / seconds
Query Executed:select id FROM `ks` where city='New Strawn' && SIC_code='5411'DB:business_master_new
loadtime:1.3842279911041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.3842749595642 / seconds
Query Executed:select id FROM `ks` where city='Newton' && SIC_code='5411'DB:business_master_new
loadtime:1.3861119747162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nickerson' limit 1
loadtime:1.3861739635468 / seconds
Query Executed:select id FROM `ks` where city='Nickerson' && SIC_code='5411'DB:business_master_new
loadtime:1.3883790969849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niotaze' limit 1
loadtime:1.3884291648865 / seconds
Query Executed:select id FROM `ks` where city='Niotaze' && SIC_code='5411'DB:business_master_new
loadtime:1.3887839317322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norcatur' limit 1
loadtime:1.3888339996338 / seconds
Query Executed:select id FROM `ks` where city='Norcatur' && SIC_code='5411'DB:business_master_new
loadtime:1.3895061016083 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Newton' limit 1
loadtime:1.3895559310913 / seconds
Query Executed:select id FROM `ks` where city='North Newton' && SIC_code='5411'DB:business_master_new
loadtime:1.3901760578156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:1.3902230262756 / seconds
Query Executed:select id FROM `ks` where city='Norton' && SIC_code='5411'DB:business_master_new
loadtime:1.3913171291351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nortonville' limit 1
loadtime:1.3913750648499 / seconds
Query Executed:select id FROM `ks` where city='Nortonville' && SIC_code='5411'DB:business_master_new
loadtime:1.392804145813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:1.3928689956665 / seconds
Query Executed:select id FROM `ks` where city='Norway' && SIC_code='5411'DB:business_master_new
loadtime:1.393217086792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:1.3932530879974 / seconds
Query Executed:select id FROM `ks` where city='Norwich' && SIC_code='5411'DB:business_master_new
loadtime:1.3941030502319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakhill' limit 1
loadtime:1.3941609859467 / seconds
Query Executed:select id FROM `ks` where city='Oakhill' && SIC_code='5411'DB:business_master_new
loadtime:1.3945989608765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:1.3946349620819 / seconds
Query Executed:select id FROM `ks` where city='Oakley' && SIC_code='5411'DB:business_master_new
loadtime:1.3954939842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oberlin' limit 1
loadtime:1.3955490589142 / seconds
Query Executed:select id FROM `ks` where city='Oberlin' && SIC_code='5411'DB:business_master_new
loadtime:1.3963561058044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odin' limit 1
loadtime:1.3963921070099 / seconds
Query Executed:select id FROM `ks` where city='Odin' && SIC_code='5411'DB:business_master_new
loadtime:1.3966989517212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Offerle' limit 1
loadtime:1.3967390060425 / seconds
Query Executed:select id FROM `ks` where city='Offerle' && SIC_code='5411'DB:business_master_new
loadtime:1.3978409767151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogallah' limit 1
loadtime:1.3979001045227 / seconds
Query Executed:select id FROM `ks` where city='Ogallah' && SIC_code='5411'DB:business_master_new
loadtime:1.3982911109924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:1.3983399868011 / seconds
Query Executed:select id FROM `ks` where city='Ogden' && SIC_code='5411'DB:business_master_new
loadtime:1.3988709449768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oketo' limit 1
loadtime:1.3988981246948 / seconds
Query Executed:select id FROM `ks` where city='Oketo' && SIC_code='5411'DB:business_master_new
loadtime:1.3997840881348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olathe' limit 1
loadtime:1.399847984314 / seconds
Query Executed:select id FROM `ks` where city='Olathe' && SIC_code='5411'DB:business_master_new
loadtime:1.4027171134949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olmitz' limit 1
loadtime:1.4027709960938 / seconds
Query Executed:select id FROM `ks` where city='Olmitz' && SIC_code='5411'DB:business_master_new
loadtime:1.4032039642334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olpe' limit 1
loadtime:1.4032580852509 / seconds
Query Executed:select id FROM `ks` where city='Olpe' && SIC_code='5411'DB:business_master_new
loadtime:1.4042630195618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olsburg' limit 1
loadtime:1.4042990207672 / seconds
Query Executed:select id FROM `ks` where city='Olsburg' && SIC_code='5411'DB:business_master_new
loadtime:1.4050130844116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaga' limit 1
loadtime:1.4050619602203 / seconds
Query Executed:select id FROM `ks` where city='Onaga' && SIC_code='5411'DB:business_master_new
loadtime:1.4058389663696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneida' limit 1
loadtime:1.4058830738068 / seconds
Query Executed:select id FROM `ks` where city='Oneida' && SIC_code='5411'DB:business_master_new
loadtime:1.4066281318665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opolis' limit 1
loadtime:1.4066779613495 / seconds
Query Executed:select id FROM `ks` where city='Opolis' && SIC_code='5411'DB:business_master_new
loadtime:1.406965970993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage City' limit 1
loadtime:1.40700507164 / seconds
Query Executed:select id FROM `ks` where city='Osage City' && SIC_code='5411'DB:business_master_new
loadtime:1.4079079627991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osawatomie' limit 1
loadtime:1.4079570770264 / seconds
Query Executed:select id FROM `ks` where city='Osawatomie' && SIC_code='5411'DB:business_master_new
loadtime:1.409264087677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osborne' limit 1
loadtime:1.409322977066 / seconds
Query Executed:select id FROM `ks` where city='Osborne' && SIC_code='5411'DB:business_master_new
loadtime:1.4101390838623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oskaloosa' limit 1
loadtime:1.410208940506 / seconds
Query Executed:select id FROM `ks` where city='Oskaloosa' && SIC_code='5411'DB:business_master_new
loadtime:1.4109830856323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oswego' limit 1
loadtime:1.4110269546509 / seconds
Query Executed:select id FROM `ks` where city='Oswego' && SIC_code='5411'DB:business_master_new
loadtime:1.4118399620056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:1.4118990898132 / seconds
Query Executed:select id FROM `ks` where city='Otis' && SIC_code='5411'DB:business_master_new
loadtime:1.4125320911407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottawa' limit 1
loadtime:1.4125680923462 / seconds
Query Executed:select id FROM `ks` where city='Ottawa' && SIC_code='5411'DB:business_master_new
loadtime:1.4136581420898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overbrook' limit 1
loadtime:1.4137110710144 / seconds
Query Executed:select id FROM `ks` where city='Overbrook' && SIC_code='5411'DB:business_master_new
loadtime:1.4144721031189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overland Park' limit 1
loadtime:1.4145150184631 / seconds
Query Executed:select id FROM `ks` where city='Overland Park' && SIC_code='5411'DB:business_master_new
loadtime:1.4289929866791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.4290659427643 / seconds
Query Executed:select id FROM `ks` where city='Oxford' && SIC_code='5411'DB:business_master_new
loadtime:1.4298350811005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ozawkie' limit 1
loadtime:1.4298861026764 / seconds
Query Executed:select id FROM `ks` where city='Ozawkie' && SIC_code='5411'DB:business_master_new
loadtime:1.4314379692078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palco' limit 1
loadtime:1.4314949512482 / seconds
Query Executed:select id FROM `ks` where city='Palco' && SIC_code='5411'DB:business_master_new
loadtime:1.4333159923553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.4333729743958 / seconds
Query Executed:select id FROM `ks` where city='Palmer' && SIC_code='5411'DB:business_master_new
loadtime:1.4340460300446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paola' limit 1
loadtime:1.4340889453888 / seconds
Query Executed:select id FROM `ks` where city='Paola' && SIC_code='5411'DB:business_master_new
loadtime:1.4350230693817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:1.4350810050964 / seconds
Query Executed:select id FROM `ks` where city='Paradise' && SIC_code='5411'DB:business_master_new
loadtime:1.4355189800262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park' limit 1
loadtime:1.4355549812317 / seconds
Query Executed:select id FROM `ks` where city='Park' && SIC_code='5411'DB:business_master_new
loadtime:1.4361400604248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park City' limit 1
loadtime:1.4361879825592 / seconds
Query Executed:select id FROM `ks` where city='Park City' && SIC_code='5411'DB:business_master_new
loadtime:1.4365530014038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:1.4365880489349 / seconds
Query Executed:select id FROM `ks` where city='Parker' && SIC_code='5411'DB:business_master_new
loadtime:1.4372870922089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parsons' limit 1
loadtime:1.4373450279236 / seconds
Query Executed:select id FROM `ks` where city='Parsons' && SIC_code='5411'DB:business_master_new
loadtime:1.4387040138245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Partridge' limit 1
loadtime:1.4387669563293 / seconds
Query Executed:select id FROM `ks` where city='Partridge' && SIC_code='5411'DB:business_master_new
loadtime:1.4392490386963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pauline' limit 1
loadtime:1.4392900466919 / seconds
Query Executed:select id FROM `ks` where city='Pauline' && SIC_code='5411'DB:business_master_new
loadtime:1.4396040439606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawnee Rock' limit 1
loadtime:1.4396531581879 / seconds
Query Executed:select id FROM `ks` where city='Pawnee Rock' && SIC_code='5411'DB:business_master_new
loadtime:1.4404139518738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxico' limit 1
loadtime:1.4404549598694 / seconds
Query Executed:select id FROM `ks` where city='Paxico' && SIC_code='5411'DB:business_master_new
loadtime:1.4416241645813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:1.44167304039 / seconds
Query Executed:select id FROM `ks` where city='Peabody' && SIC_code='5411'DB:business_master_new
loadtime:1.4424560070038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peck' limit 1
loadtime:1.4425060749054 / seconds
Query Executed:select id FROM `ks` where city='Peck' && SIC_code='5411'DB:business_master_new
loadtime:1.4433071613312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penalosa' limit 1
loadtime:1.4433641433716 / seconds
Query Executed:select id FROM `ks` where city='Penalosa' && SIC_code='5411'DB:business_master_new
loadtime:1.4436409473419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penokee' limit 1
loadtime:1.4436750411987 / seconds
Query Executed:select id FROM `ks` where city='Penokee' && SIC_code='5411'DB:business_master_new
loadtime:1.4445950984955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:1.4446439743042 / seconds
Query Executed:select id FROM `ks` where city='Perry' && SIC_code='5411'DB:business_master_new
loadtime:1.4454121589661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:1.4454720020294 / seconds
Query Executed:select id FROM `ks` where city='Peru' && SIC_code='5411'DB:business_master_new
loadtime:1.4458520412445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pfeifer' limit 1
loadtime:1.445897102356 / seconds
Query Executed:select id FROM `ks` where city='Pfeifer' && SIC_code='5411'DB:business_master_new
loadtime:1.446170091629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipsburg' limit 1
loadtime:1.4462139606476 / seconds
Query Executed:select id FROM `ks` where city='Phillipsburg' && SIC_code='5411'DB:business_master_new
loadtime:1.4470250606537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:1.4470829963684 / seconds
Query Executed:select id FROM `ks` where city='Piedmont' && SIC_code='5411'DB:business_master_new
loadtime:1.4474370479584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierceville' limit 1
loadtime:1.4474840164185 / seconds
Query Executed:select id FROM `ks` where city='Pierceville' && SIC_code='5411'DB:business_master_new
loadtime:1.4478919506073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piqua' limit 1
loadtime:1.4479191303253 / seconds
Query Executed:select id FROM `ks` where city='Piqua' && SIC_code='5411'DB:business_master_new
loadtime:1.4482989311218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:1.4483449459076 / seconds
Query Executed:select id FROM `ks` where city='Pittsburg' && SIC_code='5411'DB:business_master_new
loadtime:1.4495711326599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plains' limit 1
loadtime:1.4496331214905 / seconds
Query Executed:select id FROM `ks` where city='Plains' && SIC_code='5411'DB:business_master_new
loadtime:1.4504051208496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:1.4504599571228 / seconds
Query Executed:select id FROM `ks` where city='Plainville' && SIC_code='5411'DB:business_master_new
loadtime:1.4512810707092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasanton' limit 1
loadtime:1.451339006424 / seconds
Query Executed:select id FROM `ks` where city='Pleasanton' && SIC_code='5411'DB:business_master_new
loadtime:1.4521250724792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plevna' limit 1
loadtime:1.4521851539612 / seconds
Query Executed:select id FROM `ks` where city='Plevna' && SIC_code='5411'DB:business_master_new
loadtime:1.4526460170746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomona' limit 1
loadtime:1.4526951313019 / seconds
Query Executed:select id FROM `ks` where city='Pomona' && SIC_code='5411'DB:business_master_new
loadtime:1.4534721374512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portis' limit 1
loadtime:1.4535329341888 / seconds
Query Executed:select id FROM `ks` where city='Portis' && SIC_code='5411'DB:business_master_new
loadtime:1.4539270401001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potter' limit 1
loadtime:1.4539549350739 / seconds
Query Executed:select id FROM `ks` where city='Potter' && SIC_code='5411'DB:business_master_new
loadtime:1.4542610645294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potwin' limit 1
loadtime:1.4543099403381 / seconds
Query Executed:select id FROM `ks` where city='Potwin' && SIC_code='5411'DB:business_master_new
loadtime:1.4553170204163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powhattan' limit 1
loadtime:1.4553670883179 / seconds
Query Executed:select id FROM `ks` where city='Powhattan' && SIC_code='5411'DB:business_master_new
loadtime:1.4558260440826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie View' limit 1
loadtime:1.4558680057526 / seconds
Query Executed:select id FROM `ks` where city='Prairie View' && SIC_code='5411'DB:business_master_new
loadtime:1.4563851356506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Village' limit 1
loadtime:1.4564199447632 / seconds
Query Executed:select id FROM `ks` where city='Prairie Village' && SIC_code='5411'DB:business_master_new
loadtime:1.4575419425964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pratt' limit 1
loadtime:1.4576010704041 / seconds
Query Executed:select id FROM `ks` where city='Pratt' && SIC_code='5411'DB:business_master_new
loadtime:1.4585881233215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:1.4586491584778 / seconds
Query Executed:select id FROM `ks` where city='Prescott' && SIC_code='5411'DB:business_master_new
loadtime:1.4592730998993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:1.4593329429626 / seconds
Query Executed:select id FROM `ks` where city='Preston' && SIC_code='5411'DB:business_master_new
loadtime:1.4595971107483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pretty Prairie' limit 1
loadtime:1.4596321582794 / seconds
Query Executed:select id FROM `ks` where city='Pretty Prairie' && SIC_code='5411'DB:business_master_new
loadtime:1.4603531360626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.460401058197 / seconds
Query Executed:select id FROM `ks` where city='Princeton' && SIC_code='5411'DB:business_master_new
loadtime:1.4612970352173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Protection' limit 1
loadtime:1.4613399505615 / seconds
Query Executed:select id FROM `ks` where city='Protection' && SIC_code='5411'DB:business_master_new
loadtime:1.4621119499207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quenemo' limit 1
loadtime:1.4621689319611 / seconds
Query Executed:select id FROM `ks` where city='Quenemo' && SIC_code='5411'DB:business_master_new
loadtime:1.4627110958099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinter' limit 1
loadtime:1.4627530574799 / seconds
Query Executed:select id FROM `ks` where city='Quinter' && SIC_code='5411'DB:business_master_new
loadtime:1.4635181427002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rago' limit 1
loadtime:1.4635751247406 / seconds
Query Executed:select id FROM `ks` where city='Rago' && SIC_code='5411'DB:business_master_new
loadtime:1.4638979434967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramona' limit 1
loadtime:1.4639329910278 / seconds
Query Executed:select id FROM `ks` where city='Ramona' && SIC_code='5411'DB:business_master_new
loadtime:1.4643290042877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randall' limit 1
loadtime:1.464378118515 / seconds
Query Executed:select id FROM `ks` where city='Randall' && SIC_code='5411'DB:business_master_new
loadtime:1.4652280807495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.4652800559998 / seconds
Query Executed:select id FROM `ks` where city='Randolph' && SIC_code='5411'DB:business_master_new
loadtime:1.4658651351929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ransom' limit 1
loadtime:1.4659111499786 / seconds
Query Executed:select id FROM `ks` where city='Ransom' && SIC_code='5411'DB:business_master_new
loadtime:1.4673321247101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rantoul' limit 1
loadtime:1.4673800468445 / seconds
Query Executed:select id FROM `ks` where city='Rantoul' && SIC_code='5411'DB:business_master_new
loadtime:1.4685490131378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.4686019420624 / seconds
Query Executed:select id FROM `ks` where city='Raymond' && SIC_code='5411'DB:business_master_new
loadtime:1.4689929485321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:1.4690289497375 / seconds
Query Executed:select id FROM `ks` where city='Reading' && SIC_code='5411'DB:business_master_new
loadtime:1.4695191383362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:1.4695670604706 / seconds
Query Executed:select id FROM `ks` where city='Redfield' && SIC_code='5411'DB:business_master_new
loadtime:1.470556974411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republic' limit 1
loadtime:1.4706060886383 / seconds
Query Executed:select id FROM `ks` where city='Republic' && SIC_code='5411'DB:business_master_new
loadtime:1.4711191654205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reserve' limit 1
loadtime:1.4711699485779 / seconds
Query Executed:select id FROM `ks` where city='Reserve' && SIC_code='5411'DB:business_master_new
loadtime:1.4717359542847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rexford' limit 1
loadtime:1.471776008606 / seconds
Query Executed:select id FROM `ks` where city='Rexford' && SIC_code='5411'DB:business_master_new
loadtime:1.4726679325104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:1.4727160930634 / seconds
Query Executed:select id FROM `ks` where city='Richfield' && SIC_code='5411'DB:business_master_new
loadtime:1.4732971191406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.4733500480652 / seconds
Query Executed:select id FROM `ks` where city='Richmond' && SIC_code='5411'DB:business_master_new
loadtime:1.4741449356079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riley' limit 1
loadtime:1.474179983139 / seconds
Query Executed:select id FROM `ks` where city='Riley' && SIC_code='5411'DB:business_master_new
loadtime:1.4749231338501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:1.4749820232391 / seconds
Query Executed:select id FROM `ks` where city='Riverton' && SIC_code='5411'DB:business_master_new
loadtime:1.4758350849152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robinson' limit 1
loadtime:1.47589802742 / seconds
Query Executed:select id FROM `ks` where city='Robinson' && SIC_code='5411'DB:business_master_new
loadtime:1.476665019989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock' limit 1
loadtime:1.4767079353333 / seconds
Query Executed:select id FROM `ks` where city='Rock' && SIC_code='5411'DB:business_master_new
loadtime:1.4771571159363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roeland Park' limit 1
loadtime:1.477205991745 / seconds
Query Executed:select id FROM `ks` where city='Roeland Park' && SIC_code='5411'DB:business_master_new
loadtime:1.4776470661163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolla' limit 1
loadtime:1.4776971340179 / seconds
Query Executed:select id FROM `ks` where city='Rolla' && SIC_code='5411'DB:business_master_new
loadtime:1.4784641265869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosalia' limit 1
loadtime:1.4785239696503 / seconds
Query Executed:select id FROM `ks` where city='Rosalia' && SIC_code='5411'DB:business_master_new
loadtime:1.4789819717407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:1.4790201187134 / seconds
Query Executed:select id FROM `ks` where city='Rose Hill' && SIC_code='5411'DB:business_master_new
loadtime:1.4798400402069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rossville' limit 1
loadtime:1.4798989295959 / seconds
Query Executed:select id FROM `ks` where city='Rossville' && SIC_code='5411'DB:business_master_new
loadtime:1.4806580543518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:1.4807021617889 / seconds
Query Executed:select id FROM `ks` where city='Roxbury' && SIC_code='5411'DB:business_master_new
loadtime:1.4811229705811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rozel' limit 1
loadtime:1.481173992157 / seconds
Query Executed:select id FROM `ks` where city='Rozel' && SIC_code='5411'DB:business_master_new
loadtime:1.4816470146179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush Center' limit 1
loadtime:1.4816830158234 / seconds
Query Executed:select id FROM `ks` where city='Rush Center' && SIC_code='5411'DB:business_master_new
loadtime:1.4822161197662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:1.4822659492493 / seconds
Query Executed:select id FROM `ks` where city='Russell' && SIC_code='5411'DB:business_master_new
loadtime:1.4831969738007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sabetha' limit 1
loadtime:1.483255147934 / seconds
Query Executed:select id FROM `ks` where city='Sabetha' && SIC_code='5411'DB:business_master_new
loadtime:1.4840760231018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Francis' limit 1
loadtime:1.4841201305389 / seconds
Query Executed:select id FROM `ks` where city='Saint Francis' && SIC_code='5411'DB:business_master_new
loadtime:1.4849150180817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:1.4849760532379 / seconds
Query Executed:select id FROM `ks` where city='Saint George' && SIC_code='5411'DB:business_master_new
loadtime:1.4858350753784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint John' limit 1
loadtime:1.4858920574188 / seconds
Query Executed:select id FROM `ks` where city='Saint John' && SIC_code='5411'DB:business_master_new
loadtime:1.4867329597473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Marys' limit 1
loadtime:1.4867780208588 / seconds
Query Executed:select id FROM `ks` where city='Saint Marys' && SIC_code='5411'DB:business_master_new
loadtime:1.4875991344452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:1.4876611232758 / seconds
Query Executed:select id FROM `ks` where city='Saint Paul' && SIC_code='5411'DB:business_master_new
loadtime:1.488382101059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salina' limit 1
loadtime:1.4884259700775 / seconds
Query Executed:select id FROM `ks` where city='Salina' && SIC_code='5411'DB:business_master_new
loadtime:1.4901490211487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Satanta' limit 1
loadtime:1.4902250766754 / seconds
Query Executed:select id FROM `ks` where city='Satanta' && SIC_code='5411'DB:business_master_new
loadtime:1.4910309314728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savonburg' limit 1
loadtime:1.4910941123962 / seconds
Query Executed:select id FROM `ks` where city='Savonburg' && SIC_code='5411'DB:business_master_new
loadtime:1.4915380477905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sawyer' limit 1
loadtime:1.491574048996 / seconds
Query Executed:select id FROM `ks` where city='Sawyer' && SIC_code='5411'DB:business_master_new
loadtime:1.4921460151672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scammon' limit 1
loadtime:1.4922020435333 / seconds
Query Executed:select id FROM `ks` where city='Scammon' && SIC_code='5411'DB:business_master_new
loadtime:1.4931530952454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scandia' limit 1
loadtime:1.4932019710541 / seconds
Query Executed:select id FROM `ks` where city='Scandia' && SIC_code='5411'DB:business_master_new
loadtime:1.4938759803772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schoenchen' limit 1
loadtime:1.4939270019531 / seconds
Query Executed:select id FROM `ks` where city='Schoenchen' && SIC_code='5411'DB:business_master_new
loadtime:1.4942979812622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scott City' limit 1
loadtime:1.4943470954895 / seconds
Query Executed:select id FROM `ks` where city='Scott City' && SIC_code='5411'DB:business_master_new
loadtime:1.4952781200409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:1.4953410625458 / seconds
Query Executed:select id FROM `ks` where city='Scranton' && SIC_code='5411'DB:business_master_new
loadtime:1.4960300922394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedan' limit 1
loadtime:1.4960639476776 / seconds
Query Executed:select id FROM `ks` where city='Sedan' && SIC_code='5411'DB:business_master_new
loadtime:1.4968581199646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedgwick' limit 1
loadtime:1.496917963028 / seconds
Query Executed:select id FROM `ks` where city='Sedgwick' && SIC_code='5411'DB:business_master_new
loadtime:1.4976580142975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selden' limit 1
loadtime:1.4977071285248 / seconds
Query Executed:select id FROM `ks` where city='Selden' && SIC_code='5411'DB:business_master_new
loadtime:1.4984350204468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:1.4984970092773 / seconds
Query Executed:select id FROM `ks` where city='Seneca' && SIC_code='5411'DB:business_master_new
loadtime:1.4993870258331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severy' limit 1
loadtime:1.4994449615479 / seconds
Query Executed:select id FROM `ks` where city='Severy' && SIC_code='5411'DB:business_master_new
loadtime:1.5000290870667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seward' limit 1
loadtime:1.5000691413879 / seconds
Query Executed:select id FROM `ks` where city='Seward' && SIC_code='5411'DB:business_master_new
loadtime:1.5004079341888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:1.5004539489746 / seconds
Query Executed:select id FROM `ks` where city='Sharon' && SIC_code='5411'DB:business_master_new
loadtime:1.5009880065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon Springs' limit 1
loadtime:1.5010230541229 / seconds
Query Executed:select id FROM `ks` where city='Sharon Springs' && SIC_code='5411'DB:business_master_new
loadtime:1.5018329620361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawnee' limit 1
loadtime:1.5018899440765 / seconds
Query Executed:select id FROM `ks` where city='Shawnee' && SIC_code='5411'DB:business_master_new
loadtime:1.5034849643707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawnee Mission' limit 1
loadtime:1.5035450458527 / seconds
Query Executed:select id FROM `ks` where city='Shawnee Mission' && SIC_code='5411'DB:business_master_new
loadtime:1.5045781135559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shields' limit 1
loadtime:1.5046379566193 / seconds
Query Executed:select id FROM `ks` where city='Shields' && SIC_code='5411'DB:business_master_new
loadtime:1.504949092865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:1.5049829483032 / seconds
Query Executed:select id FROM `ks` where city='Silver Lake' && SIC_code='5411'DB:business_master_new
loadtime:1.5057981014252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpson' limit 1
loadtime:1.5058720111847 / seconds
Query Executed:select id FROM `ks` where city='Simpson' && SIC_code='5411'DB:business_master_new
loadtime:1.5062899589539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smith Center' limit 1
loadtime:1.5063309669495 / seconds
Query Executed:select id FROM `ks` where city='Smith Center' && SIC_code='5411'DB:business_master_new
loadtime:1.5071511268616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smolan' limit 1
loadtime:1.507208108902 / seconds
Query Executed:select id FROM `ks` where city='Smolan' && SIC_code='5411'DB:business_master_new
loadtime:1.5075471401215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldier' limit 1
loadtime:1.5075919628143 / seconds
Query Executed:select id FROM `ks` where city='Soldier' && SIC_code='5411'DB:business_master_new
loadtime:1.5082449913025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1
loadtime:1.5082800388336 / seconds
Query Executed:select id FROM `ks` where city='Solomon' && SIC_code='5411'DB:business_master_new
loadtime:1.5093669891357 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Haven' limit 1
loadtime:1.5094239711761 / seconds
Query Executed:select id FROM `ks` where city='South Haven' && SIC_code='5411'DB:business_master_new
loadtime:1.510370016098 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hutchinson' limit 1
loadtime:1.51043009758 / seconds
Query Executed:select id FROM `ks` where city='South Hutchinson' && SIC_code='5411'DB:business_master_new
loadtime:1.5112330913544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spearville' limit 1
loadtime:1.5112810134888 / seconds
Query Executed:select id FROM `ks` where city='Spearville' && SIC_code='5411'DB:business_master_new
loadtime:1.512001991272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spivey' limit 1
loadtime:1.5120589733124 / seconds
Query Executed:select id FROM `ks` where city='Spivey' && SIC_code='5411'DB:business_master_new
loadtime:1.5125179290771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Hill' limit 1
loadtime:1.5125620365143 / seconds
Query Executed:select id FROM `ks` where city='Spring Hill' && SIC_code='5411'DB:business_master_new
loadtime:1.513414144516 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:1.513463973999 / seconds
Query Executed:select id FROM `ks` where city='St Francis' && SIC_code='5411'DB:business_master_new
loadtime:1.5137820243835 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:1.513836145401 / seconds
Query Executed:select id FROM `ks` where city='St George' && SIC_code='5411'DB:business_master_new
loadtime:1.5141561031342 / seconds
Query loaded from cache:select * from geodata_geocity where city='St John' limit 1
loadtime:1.5142130851746 / seconds
Query Executed:select id FROM `ks` where city='St John' && SIC_code='5411'DB:business_master_new
loadtime:1.5145530700684 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Marys' limit 1
loadtime:1.5145890712738 / seconds
Query Executed:select id FROM `ks` where city='St Marys' && SIC_code='5411'DB:business_master_new
loadtime:1.5148711204529 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:1.5149159431458 / seconds
Query Executed:select id FROM `ks` where city='St Paul' && SIC_code='5411'DB:business_master_new
loadtime:1.5151860713959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:1.5152170658112 / seconds
Query Executed:select id FROM `ks` where city='Stafford' && SIC_code='5411'DB:business_master_new
loadtime:1.5159709453583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.5160191059113 / seconds
Query Executed:select id FROM `ks` where city='Stanley' && SIC_code='5411'DB:business_master_new
loadtime:1.5164160728455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stark' limit 1
loadtime:1.5164611339569 / seconds
Query Executed:select id FROM `ks` where city='Stark' && SIC_code='5411'DB:business_master_new
loadtime:1.5168340206146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:1.5168769359589 / seconds
Query Executed:select id FROM `ks` where city='Sterling' && SIC_code='5411'DB:business_master_new
loadtime:1.5176720619202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stilwell' limit 1
loadtime:1.5177149772644 / seconds
Query Executed:select id FROM `ks` where city='Stilwell' && SIC_code='5411'DB:business_master_new
loadtime:1.5185821056366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:1.5186369419098 / seconds
Query Executed:select id FROM `ks` where city='Stockton' && SIC_code='5411'DB:business_master_new
loadtime:1.519474029541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strong City' limit 1
loadtime:1.5195331573486 / seconds
Query Executed:select id FROM `ks` where city='Strong City' && SIC_code='5411'DB:business_master_new
loadtime:1.5202209949493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Studley' limit 1
loadtime:1.5202641487122 / seconds
Query Executed:select id FROM `ks` where city='Studley' && SIC_code='5411'DB:business_master_new
loadtime:1.5206210613251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuttgart' limit 1
loadtime:1.5206689834595 / seconds
Query Executed:select id FROM `ks` where city='Stuttgart' && SIC_code='5411'DB:business_master_new
loadtime:1.5209691524506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sublette' limit 1
loadtime:1.52099609375 / seconds
Query Executed:select id FROM `ks` where city='Sublette' && SIC_code='5411'DB:business_master_new
loadtime:1.5218040943146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerfield' limit 1
loadtime:1.5218729972839 / seconds
Query Executed:select id FROM `ks` where city='Summerfield' && SIC_code='5411'DB:business_master_new
loadtime:1.5224289894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1
loadtime:1.5224800109863 / seconds
Query Executed:select id FROM `ks` where city='Sun City' && SIC_code='5411'DB:business_master_new
loadtime:1.5228550434113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Susank' limit 1
loadtime:1.5228979587555 / seconds
Query Executed:select id FROM `ks` where city='Susank' && SIC_code='5411'DB:business_master_new
loadtime:1.5231590270996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sycamore' limit 1
loadtime:1.5231931209564 / seconds
Query Executed:select id FROM `ks` where city='Sycamore' && SIC_code='5411'DB:business_master_new
loadtime:1.5234730243683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvan Grove' limit 1
loadtime:1.5234980583191 / seconds
Query Executed:select id FROM `ks` where city='Sylvan Grove' && SIC_code='5411'DB:business_master_new
loadtime:1.5243470668793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvia' limit 1
loadtime:1.524405002594 / seconds
Query Executed:select id FROM `ks` where city='Sylvia' && SIC_code='5411'DB:business_master_new
loadtime:1.525022983551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syracuse' limit 1
loadtime:1.5250670909882 / seconds
Query Executed:select id FROM `ks` where city='Syracuse' && SIC_code='5411'DB:business_master_new
loadtime:1.5258650779724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talmage' limit 1
loadtime:1.5259261131287 / seconds
Query Executed:select id FROM `ks` where city='Talmage' && SIC_code='5411'DB:business_master_new
loadtime:1.5263409614563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tampa' limit 1
loadtime:1.5263879299164 / seconds
Query Executed:select id FROM `ks` where city='Tampa' && SIC_code='5411'DB:business_master_new
loadtime:1.5268180370331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tecumseh' limit 1
loadtime:1.5268571376801 / seconds
Query Executed:select id FROM `ks` where city='Tecumseh' && SIC_code='5411'DB:business_master_new
loadtime:1.5276200771332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tescott' limit 1
loadtime:1.5276629924774 / seconds
Query Executed:select id FROM `ks` where city='Tescott' && SIC_code='5411'DB:business_master_new
loadtime:1.5283329486847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thayer' limit 1
loadtime:1.528391122818 / seconds
Query Executed:select id FROM `ks` where city='Thayer' && SIC_code='5411'DB:business_master_new
loadtime:1.5290269851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timken' limit 1
loadtime:1.5290739536285 / seconds
Query Executed:select id FROM `ks` where city='Timken' && SIC_code='5411'DB:business_master_new
loadtime:1.5294060707092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:1.529452085495 / seconds
Query Executed:select id FROM `ks` where city='Tipton' && SIC_code='5411'DB:business_master_new
loadtime:1.5300481319427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonganoxie' limit 1
loadtime:1.5300841331482 / seconds
Query Executed:select id FROM `ks` where city='Tonganoxie' && SIC_code='5411'DB:business_master_new
loadtime:1.530935049057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topeka' limit 1
loadtime:1.5309951305389 / seconds
Query Executed:select id FROM `ks` where city='Topeka' && SIC_code='5411'DB:business_master_new
loadtime:1.541011095047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:1.5410950183868 / seconds
Query Executed:select id FROM `ks` where city='Toronto' && SIC_code='5411'DB:business_master_new
loadtime:1.5416779518127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towanda' limit 1
loadtime:1.5417301654816 / seconds
Query Executed:select id FROM `ks` where city='Towanda' && SIC_code='5411'DB:business_master_new
loadtime:1.5425140857697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Treece' limit 1
loadtime:1.5425710678101 / seconds
Query Executed:select id FROM `ks` where city='Treece' && SIC_code='5411'DB:business_master_new
loadtime:1.5429041385651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tribune' limit 1
loadtime:1.5429320335388 / seconds
Query Executed:select id FROM `ks` where city='Tribune' && SIC_code='5411'DB:business_master_new
loadtime:1.5437099933624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.5437660217285 / seconds
Query Executed:select id FROM `ks` where city='Troy' && SIC_code='5411'DB:business_master_new
loadtime:1.5445420742035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turon' limit 1
loadtime:1.5446031093597 / seconds
Query Executed:select id FROM `ks` where city='Turon' && SIC_code='5411'DB:business_master_new
loadtime:1.5453560352325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyro' limit 1
loadtime:1.5454130172729 / seconds
Query Executed:select id FROM `ks` where city='Tyro' && SIC_code='5411'DB:business_master_new
loadtime:1.5458331108093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Udall' limit 1
loadtime:1.5458719730377 / seconds
Query Executed:select id FROM `ks` where city='Udall' && SIC_code='5411'DB:business_master_new
loadtime:1.5466051101685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ulysses' limit 1
loadtime:1.5466530323029 / seconds
Query Executed:select id FROM `ks` where city='Ulysses' && SIC_code='5411'DB:business_master_new
loadtime:1.5476181507111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uniontown' limit 1
loadtime:1.5476751327515 / seconds
Query Executed:select id FROM `ks` where city='Uniontown' && SIC_code='5411'DB:business_master_new
loadtime:1.5483391284943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:1.5483961105347 / seconds
Query Executed:select id FROM `ks` where city='Utica' && SIC_code='5411'DB:business_master_new
loadtime:1.5490200519562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Center' limit 1
loadtime:1.5490591526031 / seconds
Query Executed:select id FROM `ks` where city='Valley Center' && SIC_code='5411'DB:business_master_new
loadtime:1.5499060153961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Falls' limit 1
loadtime:1.5499510765076 / seconds
Query Executed:select id FROM `ks` where city='Valley Falls' && SIC_code='5411'DB:business_master_new
loadtime:1.5507550239563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vassar' limit 1
loadtime:1.5508251190186 / seconds
Query Executed:select id FROM `ks` where city='Vassar' && SIC_code='5411'DB:business_master_new
loadtime:1.5513100624084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermillion' limit 1
loadtime:1.5513520240784 / seconds
Query Executed:select id FROM `ks` where city='Vermillion' && SIC_code='5411'DB:business_master_new
loadtime:1.5518710613251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:1.5519120693207 / seconds
Query Executed:select id FROM `ks` where city='Victoria' && SIC_code='5411'DB:business_master_new
loadtime:1.5526909828186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:1.552747964859 / seconds
Query Executed:select id FROM `ks` where city='Viola' && SIC_code='5411'DB:business_master_new
loadtime:1.5532820224762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgil' limit 1
loadtime:1.5533380508423 / seconds
Query Executed:select id FROM `ks` where city='Virgil' && SIC_code='5411'DB:business_master_new
loadtime:1.553699016571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vliets' limit 1
loadtime:1.5537331104279 / seconds
Query Executed:select id FROM `ks` where city='Vliets' && SIC_code='5411'DB:business_master_new
loadtime:1.554013967514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wa Keeney' limit 1
loadtime:1.5540521144867 / seconds
Query Executed:select id FROM `ks` where city='Wa Keeney' && SIC_code='5411'DB:business_master_new
loadtime:1.55437707901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakarusa' limit 1
loadtime:1.5544221401215 / seconds
Query Executed:select id FROM `ks` where city='Wakarusa' && SIC_code='5411'DB:business_master_new
loadtime:1.5549740791321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakeeney' limit 1
loadtime:1.5550019741058 / seconds
Query Executed:select id FROM `ks` where city='Wakeeney' && SIC_code='5411'DB:business_master_new
loadtime:1.5558440685272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:1.5559041500092 / seconds
Query Executed:select id FROM `ks` where city='Wakefield' && SIC_code='5411'DB:business_master_new
loadtime:1.5566711425781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldo' limit 1
loadtime:1.5567240715027 / seconds
Query Executed:select id FROM `ks` where city='Waldo' && SIC_code='5411'DB:business_master_new
loadtime:1.5571539402008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldron' limit 1
loadtime:1.5572071075439 / seconds
Query Executed:select id FROM `ks` where city='Waldron' && SIC_code='5411'DB:business_master_new
loadtime:1.5575420856476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walker' limit 1
loadtime:1.557578086853 / seconds
Query Executed:select id FROM `ks` where city='Walker' && SIC_code='5411'DB:business_master_new
loadtime:1.55788397789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:1.5579121112823 / seconds
Query Executed:select id FROM `ks` where city='Wallace' && SIC_code='5411'DB:business_master_new
loadtime:1.5583469867706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:1.5584001541138 / seconds
Query Executed:select id FROM `ks` where city='Walnut' && SIC_code='5411'DB:business_master_new
loadtime:1.5589680671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walton' limit 1
loadtime:1.559005022049 / seconds
Query Executed:select id FROM `ks` where city='Walton' && SIC_code='5411'DB:business_master_new
loadtime:1.5595591068268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wamego' limit 1
loadtime:1.5596139431 / seconds
Query Executed:select id FROM `ks` where city='Wamego' && SIC_code='5411'DB:business_master_new
loadtime:1.5606069564819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.5606651306152 / seconds
Query Executed:select id FROM `ks` where city='Washington' && SIC_code='5411'DB:business_master_new
loadtime:1.5614809989929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:1.5615410804749 / seconds
Query Executed:select id FROM `ks` where city='Waterville' && SIC_code='5411'DB:business_master_new
loadtime:1.5623359680176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wathena' limit 1
loadtime:1.5623800754547 / seconds
Query Executed:select id FROM `ks` where city='Wathena' && SIC_code='5411'DB:business_master_new
loadtime:1.563159942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.563215970993 / seconds
Query Executed:select id FROM `ks` where city='Waverly' && SIC_code='5411'DB:business_master_new
loadtime:1.563982963562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webber' limit 1
loadtime:1.5640411376953 / seconds
Query Executed:select id FROM `ks` where city='Webber' && SIC_code='5411'DB:business_master_new
loadtime:1.5644130706787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weir' limit 1
loadtime:1.5644619464874 / seconds
Query Executed:select id FROM `ks` where city='Weir' && SIC_code='5411'DB:business_master_new
loadtime:1.5651500225067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welda' limit 1
loadtime:1.5651979446411 / seconds
Query Executed:select id FROM `ks` where city='Welda' && SIC_code='5411'DB:business_master_new
loadtime:1.5655541419983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:1.565593957901 / seconds
Query Executed:select id FROM `ks` where city='Wellington' && SIC_code='5411'DB:business_master_new
loadtime:1.5665791034698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:1.5666360855103 / seconds
Query Executed:select id FROM `ks` where city='Wells' && SIC_code='5411'DB:business_master_new
loadtime:1.5669391155243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsville' limit 1
loadtime:1.566978931427 / seconds
Query Executed:select id FROM `ks` where city='Wellsville' && SIC_code='5411'DB:business_master_new
loadtime:1.5677609443665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weskan' limit 1
loadtime:1.5678350925446 / seconds
Query Executed:select id FROM `ks` where city='Weskan' && SIC_code='5411'DB:business_master_new
loadtime:1.5683951377869 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mineral' limit 1
loadtime:1.5684311389923 / seconds
Query Executed:select id FROM `ks` where city='West Mineral' && SIC_code='5411'DB:business_master_new
loadtime:1.5688290596008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfall' limit 1
loadtime:1.5688700675964 / seconds
Query Executed:select id FROM `ks` where city='Westfall' && SIC_code='5411'DB:business_master_new
loadtime:1.5691809654236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:1.5692160129547 / seconds
Query Executed:select id FROM `ks` where city='Westmoreland' && SIC_code='5411'DB:business_master_new
loadtime:1.5699679851532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:1.5700180530548 / seconds
Query Executed:select id FROM `ks` where city='Westphalia' && SIC_code='5411'DB:business_master_new
loadtime:1.5705959796906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:1.5706419944763 / seconds
Query Executed:select id FROM `ks` where city='Wetmore' && SIC_code='5411'DB:business_master_new
loadtime:1.5715889930725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheaton' limit 1
loadtime:1.5716459751129 / seconds
Query Executed:select id FROM `ks` where city='Wheaton' && SIC_code='5411'DB:business_master_new
loadtime:1.5719561576843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:1.5719940662384 / seconds
Query Executed:select id FROM `ks` where city='Wheeler' && SIC_code='5411'DB:business_master_new
loadtime:1.5723221302032 / seconds
Query loaded from cache:select * from geodata_geocity where city='White City' limit 1
loadtime:1.5723581314087 / seconds
Query Executed:select id FROM `ks` where city='White City' && SIC_code='5411'DB:business_master_new
loadtime:1.5729169845581 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Cloud' limit 1
loadtime:1.5729570388794 / seconds
Query Executed:select id FROM `ks` where city='White Cloud' && SIC_code='5411'DB:business_master_new
loadtime:1.5734519958496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewater' limit 1
loadtime:1.5735080242157 / seconds
Query Executed:select id FROM `ks` where city='Whitewater' && SIC_code='5411'DB:business_master_new
loadtime:1.574245929718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:1.5743041038513 / seconds
Query Executed:select id FROM `ks` where city='Whiting' && SIC_code='5411'DB:business_master_new
loadtime:1.5747449398041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wichita' limit 1
loadtime:1.5747849941254 / seconds
Query Executed:select id FROM `ks` where city='Wichita' && SIC_code='5411'DB:business_master_new
loadtime:1.5846900939941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.5848309993744 / seconds
Query Executed:select id FROM `ks` where city='Williamsburg' && SIC_code='5411'DB:business_master_new
loadtime:1.5854091644287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:1.5854580402374 / seconds
Query Executed:select id FROM `ks` where city='Willis' && SIC_code='5411'DB:business_master_new
loadtime:1.5857639312744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmore' limit 1
loadtime:1.5858170986176 / seconds
Query Executed:select id FROM `ks` where city='Wilmore' && SIC_code='5411'DB:business_master_new
loadtime:1.5863239765167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsey' limit 1
loadtime:1.5863649845123 / seconds
Query Executed:select id FROM `ks` where city='Wilsey' && SIC_code='5411'DB:business_master_new
loadtime:1.5867750644684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:1.5868270397186 / seconds
Query Executed:select id FROM `ks` where city='Wilson' && SIC_code='5411'DB:business_master_new
loadtime:1.5876221656799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:1.587671995163 / seconds
Query Executed:select id FROM `ks` where city='Winchester' && SIC_code='5411'DB:business_master_new
loadtime:1.5883491039276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windom' limit 1
loadtime:1.5884070396423 / seconds
Query Executed:select id FROM `ks` where city='Windom' && SIC_code='5411'DB:business_master_new
loadtime:1.5888650417328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:1.5889060497284 / seconds
Query Executed:select id FROM `ks` where city='Winfield' && SIC_code='5411'DB:business_master_new
loadtime:1.5899620056152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winona' limit 1
loadtime:1.5900220870972 / seconds
Query Executed:select id FROM `ks` where city='Winona' && SIC_code='5411'DB:business_master_new
loadtime:1.5907039642334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:1.5907530784607 / seconds
Query Executed:select id FROM `ks` where city='Woodbine' && SIC_code='5411'DB:business_master_new
loadtime:1.5911650657654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodston' limit 1
loadtime:1.5912089347839 / seconds
Query Executed:select id FROM `ks` where city='Woodston' && SIC_code='5411'DB:business_master_new
loadtime:1.5915880203247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wright' limit 1
loadtime:1.591637134552 / seconds
Query Executed:select id FROM `ks` where city='Wright' && SIC_code='5411'DB:business_master_new
loadtime:1.592129945755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yates Center' limit 1
loadtime:1.5921790599823 / seconds
Query Executed:select id FROM `ks` where city='Yates Center' && SIC_code='5411'DB:business_master_new
loadtime:1.5929729938507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yoder' limit 1
loadtime:1.5930161476135 / seconds
Query Executed:select id FROM `ks` where city='Yoder' && SIC_code='5411'DB:business_master_new
loadtime:1.5934810638428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zenda' limit 1
loadtime:1.5935380458832 / seconds
Query Executed:select id FROM `ks` where city='Zenda' && SIC_code='5411'DB:business_master_new
loadtime:1.5940301418304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zurich' limit 1
loadtime:1.5940580368042 / seconds
Query Executed:select id FROM `ks` where city='Zurich' && SIC_code='5411'DB:business_master_new
loadtime:1.5944061279297 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.5944910049438 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.5946900844574 / seconds
Operation template executed (chunk cache operation)
loadtime:1.5947699546814 / seconds
template override:Default
loadtime:1.5947890281677 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.5955469608307 / seconds
Template Constructed, Array Rows:49
loadtime:1.5958049297333 / seconds
TOTAL EXECUTION TIME: 1.5956
loadtime:1.5959610939026 / 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] => grocery-stores [stateURLid] => kansas )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.5959680080414
TOTAL KEY ARRAYS: 69