Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.9870223999023E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0024688243865967 / seconds
host not found setting manual db connection
loadtime:0.010540008544922 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010808944702148 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.01097583770752 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.011032819747925 / seconds
zipcode:
loadtime:0.011059999465942 / seconds
Query Executed:select * from search_referrer where page_hash='06ceb57ce4176d618084f021a6a2fd91' limit 10 DB:ezrox_toadli
loadtime:0.011293888092041 / seconds
Operation header executed (non global)
loadtime:0.011323928833008 / seconds
Operation leaderboard executed (non global)
loadtime:0.011374950408936 / seconds
Operation square executed (non global)
loadtime:0.011404991149902 / seconds
Operation square_bottom executed (non global)
loadtime:0.011432886123657 / seconds
Operation smallsquare executed (non global)
loadtime:0.011462926864624 / seconds
Operation headeradright executed (non global)
loadtime:0.011492967605591 / seconds
Operation google_analytics executed (non global)
loadtime:0.011518001556396 / seconds
Operation topstories executed (non global)
loadtime:0.011545896530151 / seconds
Operation businessnearyou executed (non global)
loadtime:0.01157283782959 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011597871780396 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011883974075317 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.012076854705811 / seconds
Operation categories executed (global stored into APC)
loadtime:0.012118816375732 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.012180805206299 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.012229919433594 / seconds
Template key: archive_menu pushed
loadtime:0.0122389793396 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.012251853942871 / seconds
Template key: get_gravatar pushed
loadtime:0.012259006500244 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.012267827987671 / seconds
*10)-10)+1 | start:0
loadtime:0.012312889099121 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.012356996536255 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wisconsin'
loadtime:0.012392997741699 / seconds
DB connected to localhost business_master_new
loadtime:0.012674808502197 / seconds
Query Executed:select * from `wi_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.018294811248779 / seconds
Query stored in cache : _QUERY_www.toadli.com8331afa67d69f32df9f8c8e6f73a2fe0
loadtime:0.021543025970459 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wisconsin'
loadtime:0.021623849868774 / seconds
Query Executed:select sum(totalcount) as totalsum from `wi_catmap` where sic='7231'DB:business_master_new
loadtime:0.025871992111206 / seconds
Query stored in cache : _QUERY_www.toadli.com31fc81f1dc756e8f8260098831999e07
loadtime:0.025933027267456 / seconds
820 / 11
loadtime:0.026005983352661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbotsford' limit 1
loadtime:0.02608585357666 / seconds
Query Executed:select id FROM `wi` where city='Abbotsford' && SIC_code='7231'DB:business_master_new
loadtime:0.02908992767334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abrams' limit 1
loadtime:0.0291748046875 / seconds
Query Executed:select id FROM `wi` where city='Abrams' && SIC_code='7231'DB:business_master_new
loadtime:0.031031847000122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.0311119556427 / seconds
Query Executed:select id FROM `wi` where city='Adams' && SIC_code='7231'DB:business_master_new
loadtime:0.033792972564697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adell' limit 1
loadtime:0.033870935440063 / seconds
Query Executed:select id FROM `wi` where city='Adell' && SIC_code='7231'DB:business_master_new
loadtime:0.035356998443604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.035432815551758 / seconds
Query Executed:select id FROM `wi` where city='Afton' && SIC_code='7231'DB:business_master_new
loadtime:0.035982847213745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.036046028137207 / seconds
Query Executed:select id FROM `wi` where city='Albany' && SIC_code='7231'DB:business_master_new
loadtime:0.037796020507812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algoma' limit 1
loadtime:0.037875890731812 / seconds
Query Executed:select id FROM `wi` where city='Algoma' && SIC_code='7231'DB:business_master_new
loadtime:0.041908979415894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenton' limit 1
loadtime:0.041998863220215 / seconds
Query Executed:select id FROM `wi` where city='Allenton' && SIC_code='7231'DB:business_master_new
loadtime:0.044000864028931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allouez' limit 1
loadtime:0.044082880020142 / seconds
Query Executed:select id FROM `wi` where city='Allouez' && SIC_code='7231'DB:business_master_new
loadtime:0.044523000717163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.044584989547729 / seconds
Query Executed:select id FROM `wi` where city='Alma' && SIC_code='7231'DB:business_master_new
loadtime:0.047180891036987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma Center' limit 1
loadtime:0.047261953353882 / seconds
Query Executed:select id FROM `wi` where city='Alma Center' && SIC_code='7231'DB:business_master_new
loadtime:0.048511981964111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almena' limit 1
loadtime:0.048589944839478 / seconds
Query Executed:select id FROM `wi` where city='Almena' && SIC_code='7231'DB:business_master_new
loadtime:0.050140857696533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almond' limit 1
loadtime:0.05021595954895 / seconds
Query Executed:select id FROM `wi` where city='Almond' && SIC_code='7231'DB:business_master_new
loadtime:0.051723003387451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.051800966262817 / seconds
Query Executed:select id FROM `wi` where city='Altoona' && SIC_code='7231'DB:business_master_new
loadtime:0.055717945098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amberg' limit 1
loadtime:0.055797815322876 / seconds
Query Executed:select id FROM `wi` where city='Amberg' && SIC_code='7231'DB:business_master_new
loadtime:0.056624889373779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amery' limit 1
loadtime:0.056686878204346 / seconds
Query Executed:select id FROM `wi` where city='Amery' && SIC_code='7231'DB:business_master_new
loadtime:0.062606811523438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.062700986862183 / seconds
Query Executed:select id FROM `wi` where city='Amherst' && SIC_code='7231'DB:business_master_new
loadtime:0.06538987159729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst Junction' limit 1
loadtime:0.065474987030029 / seconds
Query Executed:select id FROM `wi` where city='Amherst Junction' && SIC_code='7231'DB:business_master_new
loadtime:0.066951990127563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aniwa' limit 1
loadtime:0.067030906677246 / seconds
Query Executed:select id FROM `wi` where city='Aniwa' && SIC_code='7231'DB:business_master_new
loadtime:0.068086862564087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antigo' limit 1
loadtime:0.068161964416504 / seconds
Query Executed:select id FROM `wi` where city='Antigo' && SIC_code='7231'DB:business_master_new
loadtime:0.12981700897217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appleton' limit 1
loadtime:0.12997102737427 / seconds
Query Executed:select id FROM `wi` where city='Appleton' && SIC_code='7231'DB:business_master_new
loadtime:0.19897890090942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.19927501678467 / seconds
Query Executed:select id FROM `wi` where city='Arcadia' && SIC_code='7231'DB:business_master_new
loadtime:0.20309090614319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arena' limit 1
loadtime:0.20318984985352 / seconds
Query Executed:select id FROM `wi` where city='Arena' && SIC_code='7231'DB:business_master_new
loadtime:0.2046070098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argonne' limit 1
loadtime:0.20467090606689 / seconds
Query Executed:select id FROM `wi` where city='Argonne' && SIC_code='7231'DB:business_master_new
loadtime:0.20589089393616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.20596981048584 / seconds
Query Executed:select id FROM `wi` where city='Argyle' && SIC_code='7231'DB:business_master_new
loadtime:0.20783090591431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkansaw' limit 1
loadtime:0.20790982246399 / seconds
Query Executed:select id FROM `wi` where city='Arkansaw' && SIC_code='7231'DB:business_master_new
loadtime:0.20911192893982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkdale' limit 1
loadtime:0.20917391777039 / seconds
Query Executed:select id FROM `wi` where city='Arkdale' && SIC_code='7231'DB:business_master_new
loadtime:0.21051096916199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.2105917930603 / seconds
Query Executed:select id FROM `wi` where city='Arlington' && SIC_code='7231'DB:business_master_new
loadtime:0.21194696426392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armstrong Creek' limit 1
loadtime:0.21202301979065 / seconds
Query Executed:select id FROM `wi` where city='Armstrong Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.2128918170929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arpin' limit 1
loadtime:0.21296691894531 / seconds
Query Executed:select id FROM `wi` where city='Arpin' && SIC_code='7231'DB:business_master_new
loadtime:0.21428298950195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashippun' limit 1
loadtime:0.21435594558716 / seconds
Query Executed:select id FROM `wi` where city='Ashippun' && SIC_code='7231'DB:business_master_new
loadtime:0.21520400047302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.21527791023254 / seconds
Query Executed:select id FROM `wi` where city='Ashland' && SIC_code='7231'DB:business_master_new
loadtime:0.27640700340271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athelstane' limit 1
loadtime:0.27656483650208 / seconds
Query Executed:select id FROM `wi` where city='Athelstane' && SIC_code='7231'DB:business_master_new
loadtime:0.27764487266541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.27772188186646 / seconds
Query Executed:select id FROM `wi` where city='Athens' && SIC_code='7231'DB:business_master_new
loadtime:0.28093886375427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.28102087974548 / seconds
Query Executed:select id FROM `wi` where city='Auburndale' && SIC_code='7231'DB:business_master_new
loadtime:0.2827308177948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.28280901908875 / seconds
Query Executed:select id FROM `wi` where city='Augusta' && SIC_code='7231'DB:business_master_new
loadtime:0.28514695167542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.28522801399231 / seconds
Query Executed:select id FROM `wi` where city='Avalon' && SIC_code='7231'DB:business_master_new
loadtime:0.28612685203552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.28620290756226 / seconds
Query Executed:select id FROM `wi` where city='Avoca' && SIC_code='7231'DB:business_master_new
loadtime:0.28717184066772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babcock' limit 1
loadtime:0.28724694252014 / seconds
Query Executed:select id FROM `wi` where city='Babcock' && SIC_code='7231'DB:business_master_new
loadtime:0.28787302970886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.28793501853943 / seconds
Query Executed:select id FROM `wi` where city='Bagley' && SIC_code='7231'DB:business_master_new
loadtime:0.28894686698914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Harbor' limit 1
loadtime:0.2890088558197 / seconds
Query Executed:select id FROM `wi` where city='Baileys Harbor' && SIC_code='7231'DB:business_master_new
loadtime:0.29104900360107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.29111099243164 / seconds
Query Executed:select id FROM `wi` where city='Baldwin' && SIC_code='7231'DB:business_master_new
loadtime:0.3514997959137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam Lake' limit 1
loadtime:0.35163593292236 / seconds
Query Executed:select id FROM `wi` where city='Balsam Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.35419988632202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.3542799949646 / seconds
Query Executed:select id FROM `wi` where city='Bancroft' && SIC_code='7231'DB:business_master_new
loadtime:0.35560584068298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bangor' limit 1
loadtime:0.35568785667419 / seconds
Query Executed:select id FROM `wi` where city='Bangor' && SIC_code='7231'DB:business_master_new
loadtime:0.35780787467957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baraboo' limit 1
loadtime:0.35788798332214 / seconds
Query Executed:select id FROM `wi` where city='Baraboo' && SIC_code='7231'DB:business_master_new
loadtime:0.37641000747681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes' limit 1
loadtime:0.37654399871826 / seconds
Query Executed:select id FROM `wi` where city='Barnes' && SIC_code='7231'DB:business_master_new
loadtime:0.37703800201416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barneveld' limit 1
loadtime:0.37710380554199 / seconds
Query Executed:select id FROM `wi` where city='Barneveld' && SIC_code='7231'DB:business_master_new
loadtime:0.37880897521973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barron' limit 1
loadtime:0.37888693809509 / seconds
Query Executed:select id FROM `wi` where city='Barron' && SIC_code='7231'DB:business_master_new
loadtime:0.43931889533997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barronett' limit 1
loadtime:0.43945002555847 / seconds
Query Executed:select id FROM `wi` where city='Barronett' && SIC_code='7231'DB:business_master_new
loadtime:0.44036793708801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.4404308795929 / seconds
Query Executed:select id FROM `wi` where city='Bassett' && SIC_code='7231'DB:business_master_new
loadtime:0.44101095199585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.44107389450073 / seconds
Query Executed:select id FROM `wi` where city='Bay City' && SIC_code='7231'DB:business_master_new
loadtime:0.44221901893616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayfield' limit 1
loadtime:0.44230484962463 / seconds
Query Executed:select id FROM `wi` where city='Bayfield' && SIC_code='7231'DB:business_master_new
loadtime:0.44564986228943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.44572782516479 / seconds
Query Executed:select id FROM `wi` where city='Bear Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.44679999351501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.44686484336853 / seconds
Query Executed:select id FROM `wi` where city='Beaver' && SIC_code='7231'DB:business_master_new
loadtime:0.447340965271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver Dam' limit 1
loadtime:0.44740080833435 / seconds
Query Executed:select id FROM `wi` where city='Beaver Dam' && SIC_code='7231'DB:business_master_new
loadtime:0.46492481231689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beetown' limit 1
loadtime:0.46504092216492 / seconds
Query Executed:select id FROM `wi` where city='Beetown' && SIC_code='7231'DB:business_master_new
loadtime:0.46567702293396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beldenville' limit 1
loadtime:0.46574282646179 / seconds
Query Executed:select id FROM `wi` where city='Beldenville' && SIC_code='7231'DB:business_master_new
loadtime:0.46678781509399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belgium' limit 1
loadtime:0.46684885025024 / seconds
Query Executed:select id FROM `wi` where city='Belgium' && SIC_code='7231'DB:business_master_new
loadtime:0.46898293495178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.46906185150146 / seconds
Query Executed:select id FROM `wi` where city='Belleville' && SIC_code='7231'DB:business_master_new
loadtime:0.47241282463074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.47250080108643 / seconds
Query Executed:select id FROM `wi` where city='Belmont' && SIC_code='7231'DB:business_master_new
loadtime:0.47405982017517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beloit' limit 1
loadtime:0.47413992881775 / seconds
Query Executed:select id FROM `wi` where city='Beloit' && SIC_code='7231'DB:business_master_new
loadtime:0.49904799461365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benet Lake' limit 1
loadtime:0.49919581413269 / seconds
Query Executed:select id FROM `wi` where city='Benet Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.49969482421875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.49976587295532 / seconds
Query Executed:select id FROM `wi` where city='Bennett' && SIC_code='7231'DB:business_master_new
loadtime:0.50022387504578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benoit' limit 1
loadtime:0.50029397010803 / seconds
Query Executed:select id FROM `wi` where city='Benoit' && SIC_code='7231'DB:business_master_new
loadtime:0.50081491470337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.50087690353394 / seconds
Query Executed:select id FROM `wi` where city='Benton' && SIC_code='7231'DB:business_master_new
loadtime:0.50201082229614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.50209188461304 / seconds
Query Executed:select id FROM `wi` where city='Berlin' && SIC_code='7231'DB:business_master_new
loadtime:0.56282687187195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bend' limit 1
loadtime:0.56297302246094 / seconds
Query Executed:select id FROM `wi` where city='Big Bend' && SIC_code='7231'DB:business_master_new
loadtime:0.56647896766663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Falls' limit 1
loadtime:0.56656289100647 / seconds
Query Executed:select id FROM `wi` where city='Big Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.56703901290894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchwood' limit 1
loadtime:0.56710290908813 / seconds
Query Executed:select id FROM `wi` where city='Birchwood' && SIC_code='7231'DB:business_master_new
loadtime:0.56912684440613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birnamwood' limit 1
loadtime:0.56920790672302 / seconds
Query Executed:select id FROM `wi` where city='Birnamwood' && SIC_code='7231'DB:business_master_new
loadtime:0.57115197181702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Creek' limit 1
loadtime:0.57123184204102 / seconds
Query Executed:select id FROM `wi` where city='Black Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.57405281066895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Earth' limit 1
loadtime:0.57413482666016 / seconds
Query Executed:select id FROM `wi` where city='Black Earth' && SIC_code='7231'DB:business_master_new
loadtime:0.57627487182617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River Falls' limit 1
loadtime:0.57636094093323 / seconds
Query Executed:select id FROM `wi` where city='Black River Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.58868980407715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River Fls' limit 1
loadtime:0.58878898620605 / seconds
Query Executed:select id FROM `wi` where city='Black River Fls' && SIC_code='7231'DB:business_master_new
loadtime:0.58942079544067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.58949089050293 / seconds
Query Executed:select id FROM `wi` where city='Blair' && SIC_code='7231'DB:business_master_new
loadtime:0.5914318561554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchardville' limit 1
loadtime:0.59152579307556 / seconds
Query Executed:select id FROM `wi` where city='Blanchardville' && SIC_code='7231'DB:business_master_new
loadtime:0.59343290328979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blenker' limit 1
loadtime:0.59351992607117 / seconds
Query Executed:select id FROM `wi` where city='Blenker' && SIC_code='7231'DB:business_master_new
loadtime:0.59406685829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomer' limit 1
loadtime:0.59412884712219 / seconds
Query Executed:select id FROM `wi` where city='Bloomer' && SIC_code='7231'DB:business_master_new
loadtime:0.59964489936829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomington' limit 1
loadtime:0.59973192214966 / seconds
Query Executed:select id FROM `wi` where city='Bloomington' && SIC_code='7231'DB:business_master_new
loadtime:0.60130596160889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Mounds' limit 1
loadtime:0.60139083862305 / seconds
Query Executed:select id FROM `wi` where city='Blue Mounds' && SIC_code='7231'DB:business_master_new
loadtime:0.6028299331665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue River' limit 1
loadtime:0.60290479660034 / seconds
Query Executed:select id FROM `wi` where city='Blue River' && SIC_code='7231'DB:business_master_new
loadtime:0.6044328212738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonduel' limit 1
loadtime:0.60451793670654 / seconds
Query Executed:select id FROM `wi` where city='Bonduel' && SIC_code='7231'DB:business_master_new
loadtime:0.60738396644592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscobel' limit 1
loadtime:0.6074697971344 / seconds
Query Executed:select id FROM `wi` where city='Boscobel' && SIC_code='7231'DB:business_master_new
loadtime:0.61128282546997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder Junction' limit 1
loadtime:0.61137580871582 / seconds
Query Executed:select id FROM `wi` where city='Boulder Junction' && SIC_code='7231'DB:business_master_new
loadtime:0.61361002922058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowler' limit 1
loadtime:0.61368799209595 / seconds
Query Executed:select id FROM `wi` where city='Bowler' && SIC_code='7231'DB:business_master_new
loadtime:0.61492896080017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyceville' limit 1
loadtime:0.61499094963074 / seconds
Query Executed:select id FROM `wi` where city='Boyceville' && SIC_code='7231'DB:business_master_new
loadtime:0.61687183380127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyd' limit 1
loadtime:0.61695098876953 / seconds
Query Executed:select id FROM `wi` where city='Boyd' && SIC_code='7231'DB:business_master_new
loadtime:0.6184389591217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.61852383613586 / seconds
Query Executed:select id FROM `wi` where city='Brandon' && SIC_code='7231'DB:business_master_new
loadtime:0.6202609539032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brantwood' limit 1
loadtime:0.62035298347473 / seconds
Query Executed:select id FROM `wi` where city='Brantwood' && SIC_code='7231'DB:business_master_new
loadtime:0.62097096443176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Briggsville' limit 1
loadtime:0.62103486061096 / seconds
Query Executed:select id FROM `wi` where city='Briggsville' && SIC_code='7231'DB:business_master_new
loadtime:0.62188982963562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brill' limit 1
loadtime:0.62195181846619 / seconds
Query Executed:select id FROM `wi` where city='Brill' && SIC_code='7231'DB:business_master_new
loadtime:0.62247395515442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brillion' limit 1
loadtime:0.62253594398499 / seconds
Query Executed:select id FROM `wi` where city='Brillion' && SIC_code='7231'DB:business_master_new
loadtime:0.62582683563232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.62590885162354 / seconds
Query Executed:select id FROM `wi` where city='Bristol' && SIC_code='7231'DB:business_master_new
loadtime:0.62901997566223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodhead' limit 1
loadtime:0.62909889221191 / seconds
Query Executed:select id FROM `wi` where city='Brodhead' && SIC_code='7231'DB:business_master_new
loadtime:0.63344979286194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brokaw' limit 1
loadtime:0.63353800773621 / seconds
Query Executed:select id FROM `wi` where city='Brokaw' && SIC_code='7231'DB:business_master_new
loadtime:0.63413286209106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.63419699668884 / seconds
Query Executed:select id FROM `wi` where city='Brookfield' && SIC_code='7231'DB:business_master_new
loadtime:0.6858549118042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.68628191947937 / seconds
Query Executed:select id FROM `wi` where city='Brooklyn' && SIC_code='7231'DB:business_master_new
loadtime:0.68885493278503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.68895292282104 / seconds
Query Executed:select id FROM `wi` where city='Brownsville' && SIC_code='7231'DB:business_master_new
loadtime:0.69049787521362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browntown' limit 1
loadtime:0.69055485725403 / seconds
Query Executed:select id FROM `wi` where city='Browntown' && SIC_code='7231'DB:business_master_new
loadtime:0.69190788269043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.69197583198547 / seconds
Query Executed:select id FROM `wi` where city='Bruce' && SIC_code='7231'DB:business_master_new
loadtime:0.69400787353516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brule' limit 1
loadtime:0.69408297538757 / seconds
Query Executed:select id FROM `wi` where city='Brule' && SIC_code='7231'DB:business_master_new
loadtime:0.69523000717163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brussels' limit 1
loadtime:0.695307970047 / seconds
Query Executed:select id FROM `wi` where city='Brussels' && SIC_code='7231'DB:business_master_new
loadtime:0.69691586494446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.6969838142395 / seconds
Query Executed:select id FROM `wi` where city='Bryant' && SIC_code='7231'DB:business_master_new
loadtime:0.69794988632202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo City' limit 1
loadtime:0.69800496101379 / seconds
Query Executed:select id FROM `wi` where city='Buffalo City' && SIC_code='7231'DB:business_master_new
loadtime:0.69849491119385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.69854784011841 / seconds
Query Executed:select id FROM `wi` where city='Burlington' && SIC_code='7231'DB:business_master_new
loadtime:0.71858096122742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnett' limit 1
loadtime:0.71868085861206 / seconds
Query Executed:select id FROM `wi` where city='Burnett' && SIC_code='7231'DB:business_master_new
loadtime:0.71962380409241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.7196798324585 / seconds
Query Executed:select id FROM `wi` where city='Butler' && SIC_code='7231'DB:business_master_new
loadtime:0.72409582138062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butte Des Morts' limit 1
loadtime:0.72416496276855 / seconds
Query Executed:select id FROM `wi` where city='Butte Des Morts' && SIC_code='7231'DB:business_master_new
loadtime:0.72473692893982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butternut' limit 1
loadtime:0.72479295730591 / seconds
Query Executed:select id FROM `wi` where city='Butternut' && SIC_code='7231'DB:business_master_new
loadtime:0.72626996040344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:0.72634792327881 / seconds
Query Executed:select id FROM `wi` where city='Byron' && SIC_code='7231'DB:business_master_new
loadtime:0.72677493095398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cable' limit 1
loadtime:0.72682881355286 / seconds
Query Executed:select id FROM `wi` where city='Cable' && SIC_code='7231'DB:business_master_new
loadtime:0.72951889038086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cadott' limit 1
loadtime:0.7295868396759 / seconds
Query Executed:select id FROM `wi` where city='Cadott' && SIC_code='7231'DB:business_master_new
loadtime:0.73278498649597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.73285794258118 / seconds
Query Executed:select id FROM `wi` where city='Caledonia' && SIC_code='7231'DB:business_master_new
loadtime:0.73541784286499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambria' limit 1
loadtime:0.73548984527588 / seconds
Query Executed:select id FROM `wi` where city='Cambria' && SIC_code='7231'DB:business_master_new
loadtime:0.73708486557007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.73715281486511 / seconds
Query Executed:select id FROM `wi` where city='Cambridge' && SIC_code='7231'DB:business_master_new
loadtime:0.74130296707153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.7413809299469 / seconds
Query Executed:select id FROM `wi` where city='Cameron' && SIC_code='7231'DB:business_master_new
loadtime:0.74422693252563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Douglas' limit 1
loadtime:0.74430894851685 / seconds
Query Executed:select id FROM `wi` where city='Camp Douglas' && SIC_code='7231'DB:business_master_new
loadtime:0.74622583389282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Lake' limit 1
loadtime:0.74630188941956 / seconds
Query Executed:select id FROM `wi` where city='Camp Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.74689388275146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campbellsport' limit 1
loadtime:0.74694991111755 / seconds
Query Executed:select id FROM `wi` where city='Campbellsport' && SIC_code='7231'DB:business_master_new
loadtime:0.75129795074463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caroline' limit 1
loadtime:0.75137281417847 / seconds
Query Executed:select id FROM `wi` where city='Caroline' && SIC_code='7231'DB:business_master_new
loadtime:0.75191688537598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.7519838809967 / seconds
Query Executed:select id FROM `wi` where city='Cascade' && SIC_code='7231'DB:business_master_new
loadtime:0.75330996513367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casco' limit 1
loadtime:0.75338101387024 / seconds
Query Executed:select id FROM `wi` where city='Casco' && SIC_code='7231'DB:business_master_new
loadtime:0.75521683692932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashton' limit 1
loadtime:0.75529885292053 / seconds
Query Executed:select id FROM `wi` where city='Cashton' && SIC_code='7231'DB:business_master_new
loadtime:0.757817029953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassville' limit 1
loadtime:0.75788593292236 / seconds
Query Executed:select id FROM `wi` where city='Cassville' && SIC_code='7231'DB:business_master_new
loadtime:0.7599618434906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataract' limit 1
loadtime:0.76003289222717 / seconds
Query Executed:select id FROM `wi` where city='Cataract' && SIC_code='7231'DB:business_master_new
loadtime:0.76056385040283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.76061987876892 / seconds
Query Executed:select id FROM `wi` where city='Catawba' && SIC_code='7231'DB:business_master_new
loadtime:0.76141285896301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cato' limit 1
loadtime:0.7614848613739 / seconds
Query Executed:select id FROM `wi` where city='Cato' && SIC_code='7231'DB:business_master_new
loadtime:0.76186990737915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.76192402839661 / seconds
Query Executed:select id FROM `wi` where city='Cavour' && SIC_code='7231'DB:business_master_new
loadtime:0.76231288909912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cazenovia' limit 1
loadtime:0.76236581802368 / seconds
Query Executed:select id FROM `wi` where city='Cazenovia' && SIC_code='7231'DB:business_master_new
loadtime:0.76357984542847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cecil' limit 1
loadtime:0.76364588737488 / seconds
Query Executed:select id FROM `wi` where city='Cecil' && SIC_code='7231'DB:business_master_new
loadtime:0.76525497436523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:0.76533389091492 / seconds
Query Executed:select id FROM `wi` where city='Cedar Grove' && SIC_code='7231'DB:business_master_new
loadtime:0.76726293563843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarburg' limit 1
loadtime:0.76733899116516 / seconds
Query Executed:select id FROM `wi` where city='Cedarburg' && SIC_code='7231'DB:business_master_new
loadtime:0.82955288887024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centuria' limit 1
loadtime:0.82964396476746 / seconds
Query Executed:select id FROM `wi` where city='Centuria' && SIC_code='7231'DB:business_master_new
loadtime:0.83129596710205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaseburg' limit 1
loadtime:0.83136487007141 / seconds
Query Executed:select id FROM `wi` where city='Chaseburg' && SIC_code='7231'DB:business_master_new
loadtime:0.83233094215393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chetek' limit 1
loadtime:0.83238482475281 / seconds
Query Executed:select id FROM `wi` where city='Chetek' && SIC_code='7231'DB:business_master_new
loadtime:0.83718991279602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chili' limit 1
loadtime:0.83726382255554 / seconds
Query Executed:select id FROM `wi` where city='Chili' && SIC_code='7231'DB:business_master_new
loadtime:0.83839797973633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilton' limit 1
loadtime:0.83845400810242 / seconds
Query Executed:select id FROM `wi` where city='Chilton' && SIC_code='7231'DB:business_master_new
loadtime:0.84451079368591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chippewa Falls' limit 1
loadtime:0.84458780288696 / seconds
Query Executed:select id FROM `wi` where city='Chippewa Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.86665296554565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clam Falls' limit 1
loadtime:0.8667619228363 / seconds
Query Executed:select id FROM `wi` where city='Clam Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.86723184585571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clam Lake' limit 1
loadtime:0.86729788780212 / seconds
Query Executed:select id FROM `wi` where city='Clam Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.86797595024109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.86802887916565 / seconds
Query Executed:select id FROM `wi` where city='Clayton' && SIC_code='7231'DB:business_master_new
loadtime:0.86966681480408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.86973285675049 / seconds
Query Executed:select id FROM `wi` where city='Clear Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.87231683731079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.87238383293152 / seconds
Query Executed:select id FROM `wi` where city='Cleveland' && SIC_code='7231'DB:business_master_new
loadtime:0.87429690361023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.87436294555664 / seconds
Query Executed:select id FROM `wi` where city='Clinton' && SIC_code='7231'DB:business_master_new
loadtime:0.87723183631897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintonville' limit 1
loadtime:0.87731695175171 / seconds
Query Executed:select id FROM `wi` where city='Clintonville' && SIC_code='7231'DB:business_master_new
loadtime:0.8833270072937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyman' limit 1
loadtime:0.88340997695923 / seconds
Query Executed:select id FROM `wi` where city='Clyman' && SIC_code='7231'DB:business_master_new
loadtime:0.88401389122009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobb' limit 1
loadtime:0.8840708732605 / seconds
Query Executed:select id FROM `wi` where city='Cobb' && SIC_code='7231'DB:business_master_new
loadtime:0.88508081436157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochrane' limit 1
loadtime:0.88514685630798 / seconds
Query Executed:select id FROM `wi` where city='Cochrane' && SIC_code='7231'DB:business_master_new
loadtime:0.88703584671021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colby' limit 1
loadtime:0.88710284233093 / seconds
Query Executed:select id FROM `wi` where city='Colby' && SIC_code='7231'DB:business_master_new
loadtime:0.8895378112793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman' limit 1
loadtime:0.88961291313171 / seconds
Query Executed:select id FROM `wi` where city='Coleman' && SIC_code='7231'DB:business_master_new
loadtime:0.89157295227051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.89164280891418 / seconds
Query Executed:select id FROM `wi` where city='Colfax' && SIC_code='7231'DB:business_master_new
loadtime:0.89443802833557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colgate' limit 1
loadtime:0.89451193809509 / seconds
Query Executed:select id FROM `wi` where city='Colgate' && SIC_code='7231'DB:business_master_new
loadtime:0.8965208530426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.89658880233765 / seconds
Query Executed:select id FROM `wi` where city='Collins' && SIC_code='7231'DB:business_master_new
loadtime:0.89734196662903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coloma' limit 1
loadtime:0.89739584922791 / seconds
Query Executed:select id FROM `wi` where city='Coloma' && SIC_code='7231'DB:business_master_new
loadtime:0.89951801300049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.89958596229553 / seconds
Query Executed:select id FROM `wi` where city='Columbus' && SIC_code='7231'DB:business_master_new
loadtime:0.9060959815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Combined Locks' limit 1
loadtime:0.90617394447327 / seconds
Query Executed:select id FROM `wi` where city='Combined Locks' && SIC_code='7231'DB:business_master_new
loadtime:0.90748691558838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock' limit 1
loadtime:0.90754294395447 / seconds
Query Executed:select id FROM `wi` where city='Comstock' && SIC_code='7231'DB:business_master_new
loadtime:0.90832185745239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conover' limit 1
loadtime:0.90837502479553 / seconds
Query Executed:select id FROM `wi` where city='Conover' && SIC_code='7231'DB:business_master_new
loadtime:0.90978598594666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrath' limit 1
loadtime:0.90984082221985 / seconds
Query Executed:select id FROM `wi` where city='Conrath' && SIC_code='7231'DB:business_master_new
loadtime:0.91063690185547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Valley' limit 1
loadtime:0.91069102287292 / seconds
Query Executed:select id FROM `wi` where city='Coon Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.91253590583801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornell' limit 1
loadtime:0.91260480880737 / seconds
Query Executed:select id FROM `wi` where city='Cornell' && SIC_code='7231'DB:business_master_new
loadtime:0.91492199897766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornucopia' limit 1
loadtime:0.9149968624115 / seconds
Query Executed:select id FROM `wi` where city='Cornucopia' && SIC_code='7231'DB:business_master_new
loadtime:0.91574001312256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottage Grove' limit 1
loadtime:0.91579580307007 / seconds
Query Executed:select id FROM `wi` where city='Cottage Grove' && SIC_code='7231'DB:business_master_new
loadtime:0.92085599899292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Couderay' limit 1
loadtime:0.92093181610107 / seconds
Query Executed:select id FROM `wi` where city='Couderay' && SIC_code='7231'DB:business_master_new
loadtime:0.92170190811157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crandon' limit 1
loadtime:0.92177081108093 / seconds
Query Executed:select id FROM `wi` where city='Crandon' && SIC_code='7231'DB:business_master_new
loadtime:0.92594289779663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crivitz' limit 1
loadtime:0.92602300643921 / seconds
Query Executed:select id FROM `wi` where city='Crivitz' && SIC_code='7231'DB:business_master_new
loadtime:0.98749780654907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Plains' limit 1
loadtime:0.98761987686157 / seconds
Query Executed:select id FROM `wi` where city='Cross Plains' && SIC_code='7231'DB:business_master_new
loadtime:0.99175596237183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba City' limit 1
loadtime:0.99183487892151 / seconds
Query Executed:select id FROM `wi` where city='Cuba City' && SIC_code='7231'DB:business_master_new
loadtime:0.99527597427368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cudahy' limit 1
loadtime:0.99536085128784 / seconds
Query Executed:select id FROM `wi` where city='Cudahy' && SIC_code='7231'DB:business_master_new
loadtime:1.0075988769531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:1.0076878070831 / seconds
Query Executed:select id FROM `wi` where city='Cumberland' && SIC_code='7231'DB:business_master_new
loadtime:1.0106220245361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtiss' limit 1
loadtime:1.0106959342957 / seconds
Query Executed:select id FROM `wi` where city='Curtiss' && SIC_code='7231'DB:business_master_new
loadtime:1.0116829872131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:1.0117478370667 / seconds
Query Executed:select id FROM `wi` where city='Cushing' && SIC_code='7231'DB:business_master_new
loadtime:1.0128169059753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:1.0128819942474 / seconds
Query Executed:select id FROM `wi` where city='Custer' && SIC_code='7231'DB:business_master_new
loadtime:1.0145769119263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dairyland' limit 1
loadtime:1.014643907547 / seconds
Query Executed:select id FROM `wi` where city='Dairyland' && SIC_code='7231'DB:business_master_new
loadtime:1.0150818824768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:1.0151360034943 / seconds
Query Executed:select id FROM `wi` where city='Dale' && SIC_code='7231'DB:business_master_new
loadtime:1.0160729885101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:1.0161399841309 / seconds
Query Executed:select id FROM `wi` where city='Dallas' && SIC_code='7231'DB:business_master_new
loadtime:1.0174388885498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:1.0174980163574 / seconds
Query Executed:select id FROM `wi` where city='Dalton' && SIC_code='7231'DB:business_master_new
loadtime:1.0184450149536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:1.0185170173645 / seconds
Query Executed:select id FROM `wi` where city='Danbury' && SIC_code='7231'DB:business_master_new
loadtime:1.020810842514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dane' limit 1
loadtime:1.020879983902 / seconds
Query Executed:select id FROM `wi` where city='Dane' && SIC_code='7231'DB:business_master_new
loadtime:1.0226638317108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:1.0227298736572 / seconds
Query Executed:select id FROM `wi` where city='Darien' && SIC_code='7231'DB:business_master_new
loadtime:1.0247099399567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington' limit 1
loadtime:1.0247809886932 / seconds
Query Executed:select id FROM `wi` where city='Darlington' && SIC_code='7231'DB:business_master_new
loadtime:1.0866918563843 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Forest' limit 1
loadtime:1.0867857933044 / seconds
Query Executed:select id FROM `wi` where city='De Forest' && SIC_code='7231'DB:business_master_new
loadtime:1.1476728916168 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Pere' limit 1
loadtime:1.1478188037872 / seconds
Query Executed:select id FROM `wi` where city='De Pere' && SIC_code='7231'DB:business_master_new
loadtime:1.1706509590149 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:1.1707668304443 / seconds
Query Executed:select id FROM `wi` where city='De Soto' && SIC_code='7231'DB:business_master_new
loadtime:1.1722989082336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Park' limit 1
loadtime:1.1723690032959 / seconds
Query Executed:select id FROM `wi` where city='Deer Park' && SIC_code='7231'DB:business_master_new
loadtime:1.1734688282013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerbrook' limit 1
loadtime:1.1735258102417 / seconds
Query Executed:select id FROM `wi` where city='Deerbrook' && SIC_code='7231'DB:business_master_new
loadtime:1.1747097969055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:1.1747748851776 / seconds
Query Executed:select id FROM `wi` where city='Deerfield' && SIC_code='7231'DB:business_master_new
loadtime:1.1775898933411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delafield' limit 1
loadtime:1.1776609420776 / seconds
Query Executed:select id FROM `wi` where city='Delafield' && SIC_code='7231'DB:business_master_new
loadtime:1.1884219646454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delavan' limit 1
loadtime:1.1885268688202 / seconds
Query Executed:select id FROM `wi` where city='Delavan' && SIC_code='7231'DB:business_master_new
loadtime:1.2033088207245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dellwood' limit 1
loadtime:1.2034158706665 / seconds
Query Executed:select id FROM `wi` where city='Dellwood' && SIC_code='7231'DB:business_master_new
loadtime:1.2039108276367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:1.2039668560028 / seconds
Query Executed:select id FROM `wi` where city='Denmark' && SIC_code='7231'DB:business_master_new
loadtime:1.2643449306488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickeyville' limit 1
loadtime:1.2644758224487 / seconds
Query Executed:select id FROM `wi` where city='Dickeyville' && SIC_code='7231'DB:business_master_new
loadtime:1.2658379077911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodge' limit 1
loadtime:1.2659108638763 / seconds
Query Executed:select id FROM `wi` where city='Dodge' && SIC_code='7231'DB:business_master_new
loadtime:1.2664849758148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodgeville' limit 1
loadtime:1.2665419578552 / seconds
Query Executed:select id FROM `wi` where city='Dodgeville' && SIC_code='7231'DB:business_master_new
loadtime:1.326947927475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:1.327085018158 / seconds
Query Executed:select id FROM `wi` where city='Dorchester' && SIC_code='7231'DB:business_master_new
loadtime:1.3290169239044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dousman' limit 1
loadtime:1.3290908336639 / seconds
Query Executed:select id FROM `wi` where city='Dousman' && SIC_code='7231'DB:business_master_new
loadtime:1.3322520256042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Downing' limit 1
loadtime:1.3323318958282 / seconds
Query Executed:select id FROM `wi` where city='Downing' && SIC_code='7231'DB:business_master_new
loadtime:1.3331878185272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Downsville' limit 1
loadtime:1.3332419395447 / seconds
Query Executed:select id FROM `wi` where city='Downsville' && SIC_code='7231'DB:business_master_new
loadtime:1.3338918685913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doylestown' limit 1
loadtime:1.3339447975159 / seconds
Query Executed:select id FROM `wi` where city='Doylestown' && SIC_code='7231'DB:business_master_new
loadtime:1.3344559669495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dresser' limit 1
loadtime:1.334527015686 / seconds
Query Executed:select id FROM `wi` where city='Dresser' && SIC_code='7231'DB:business_master_new
loadtime:1.3360738754272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drummond' limit 1
loadtime:1.3361449241638 / seconds
Query Executed:select id FROM `wi` where city='Drummond' && SIC_code='7231'DB:business_master_new
loadtime:1.3370978832245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbar' limit 1
loadtime:1.3371658325195 / seconds
Query Executed:select id FROM `wi` where city='Dunbar' && SIC_code='7231'DB:business_master_new
loadtime:1.3378038406372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durand' limit 1
loadtime:1.3378570079803 / seconds
Query Executed:select id FROM `wi` where city='Durand' && SIC_code='7231'DB:business_master_new
loadtime:1.3976600170135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:1.3977909088135 / seconds
Query Executed:select id FROM `wi` where city='Eagle' && SIC_code='7231'DB:business_master_new
loadtime:1.4006237983704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle River' limit 1
loadtime:1.4006998538971 / seconds
Query Executed:select id FROM `wi` where city='Eagle River' && SIC_code='7231'DB:business_master_new
loadtime:1.4146399497986 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ellsworth' limit 1
loadtime:1.4147279262543 / seconds
Query Executed:select id FROM `wi` where city='East Ellsworth' && SIC_code='7231'DB:business_master_new
loadtime:1.4153409004211 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Troy' limit 1
loadtime:1.4154078960419 / seconds
Query Executed:select id FROM `wi` where city='East Troy' && SIC_code='7231'DB:business_master_new
loadtime:1.4779298305511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastman' limit 1
loadtime:1.4780678749084 / seconds
Query Executed:select id FROM `wi` where city='Eastman' && SIC_code='7231'DB:business_master_new
loadtime:1.4793419837952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Claire' limit 1
loadtime:1.4793999195099 / seconds
Query Executed:select id FROM `wi` where city='Eau Claire' && SIC_code='7231'DB:business_master_new
loadtime:1.5287959575653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Galle' limit 1
loadtime:1.5290479660034 / seconds
Query Executed:select id FROM `wi` where city='Eau Galle' && SIC_code='7231'DB:business_master_new
loadtime:1.5299959182739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:1.5300629138947 / seconds
Query Executed:select id FROM `wi` where city='Eden' && SIC_code='7231'DB:business_master_new
loadtime:1.5316798686981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgar' limit 1
loadtime:1.5317490100861 / seconds
Query Executed:select id FROM `wi` where city='Edgar' && SIC_code='7231'DB:business_master_new
loadtime:1.5344159603119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgerton' limit 1
loadtime:1.5344908237457 / seconds
Query Executed:select id FROM `wi` where city='Edgerton' && SIC_code='7231'DB:business_master_new
loadtime:1.5970478057861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:1.5971720218658 / seconds
Query Executed:select id FROM `wi` where city='Edgewater' && SIC_code='7231'DB:business_master_new
loadtime:1.5977478027344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmund' limit 1
loadtime:1.5978038311005 / seconds
Query Executed:select id FROM `wi` where city='Edmund' && SIC_code='7231'DB:business_master_new
loadtime:1.598217010498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor' limit 1
loadtime:1.5982699394226 / seconds
Query Executed:select id FROM `wi` where city='Egg Harbor' && SIC_code='7231'DB:business_master_new
loadtime:1.6010708808899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eland' limit 1
loadtime:1.6011509895325 / seconds
Query Executed:select id FROM `wi` where city='Eland' && SIC_code='7231'DB:business_master_new
loadtime:1.602059841156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elcho' limit 1
loadtime:1.6021268367767 / seconds
Query Executed:select id FROM `wi` where city='Elcho' && SIC_code='7231'DB:business_master_new
loadtime:1.6034619808197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elderon' limit 1
loadtime:1.6035377979279 / seconds
Query Executed:select id FROM `wi` where city='Elderon' && SIC_code='7231'DB:business_master_new
loadtime:1.6040918827057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:1.6041569709778 / seconds
Query Executed:select id FROM `wi` where city='Eldorado' && SIC_code='7231'DB:business_master_new
loadtime:1.6051340103149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eleva' limit 1
loadtime:1.6051998138428 / seconds
Query Executed:select id FROM `wi` where city='Eleva' && SIC_code='7231'DB:business_master_new
loadtime:1.6073589324951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Mound' limit 1
loadtime:1.6074290275574 / seconds
Query Executed:select id FROM `wi` where city='Elk Mound' && SIC_code='7231'DB:business_master_new
loadtime:1.6098239421844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart Lake' limit 1
loadtime:1.609894990921 / seconds
Query Executed:select id FROM `wi` where city='Elkhart Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.6128768920898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhorn' limit 1
loadtime:1.6129469871521 / seconds
Query Executed:select id FROM `wi` where city='Elkhorn' && SIC_code='7231'DB:business_master_new
loadtime:1.6298768520355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellison Bay' limit 1
loadtime:1.6299738883972 / seconds
Query Executed:select id FROM `wi` where city='Ellison Bay' && SIC_code='7231'DB:business_master_new
loadtime:1.6315279006958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:1.6315848827362 / seconds
Query Executed:select id FROM `wi` where city='Ellsworth' && SIC_code='7231'DB:business_master_new
loadtime:1.6923608779907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Grove' limit 1
loadtime:1.6924908161163 / seconds
Query Executed:select id FROM `wi` where city='Elm Grove' && SIC_code='7231'DB:business_master_new
loadtime:1.7035329341888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:1.7036190032959 / seconds
Query Executed:select id FROM `wi` where city='Elmwood' && SIC_code='7231'DB:business_master_new
loadtime:1.7055180072784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elroy' limit 1
loadtime:1.7055909633636 / seconds
Query Executed:select id FROM `wi` where city='Elroy' && SIC_code='7231'DB:business_master_new
loadtime:1.7078838348389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elton' limit 1
loadtime:1.7079529762268 / seconds
Query Executed:select id FROM `wi` where city='Elton' && SIC_code='7231'DB:business_master_new
loadtime:1.7084808349609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embarrass' limit 1
loadtime:1.708536863327 / seconds
Query Executed:select id FROM `wi` where city='Embarrass' && SIC_code='7231'DB:business_master_new
loadtime:1.7092390060425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerald' limit 1
loadtime:1.7093138694763 / seconds
Query Executed:select id FROM `wi` where city='Emerald' && SIC_code='7231'DB:business_master_new
loadtime:1.7097380161285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Endeavor' limit 1
loadtime:1.7097918987274 / seconds
Query Executed:select id FROM `wi` where city='Endeavor' && SIC_code='7231'DB:business_master_new
loadtime:1.7108550071716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephraim' limit 1
loadtime:1.7109079360962 / seconds
Query Executed:select id FROM `wi` where city='Ephraim' && SIC_code='7231'DB:business_master_new
loadtime:1.7125279903412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:1.712593793869 / seconds
Query Executed:select id FROM `wi` where city='Ettrick' && SIC_code='7231'DB:business_master_new
loadtime:1.7141969203949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:1.7142648696899 / seconds
Query Executed:select id FROM `wi` where city='Eureka' && SIC_code='7231'DB:business_master_new
loadtime:1.714742898941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansville' limit 1
loadtime:1.7147979736328 / seconds
Query Executed:select id FROM `wi` where city='Evansville' && SIC_code='7231'DB:business_master_new
loadtime:1.7755358219147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeland' limit 1
loadtime:1.7756559848785 / seconds
Query Executed:select id FROM `wi` where city='Exeland' && SIC_code='7231'DB:business_master_new
loadtime:1.7768218517303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Water' limit 1
loadtime:1.7768919467926 / seconds
Query Executed:select id FROM `wi` where city='Fair Water' && SIC_code='7231'DB:business_master_new
loadtime:1.7772929668427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairchild' limit 1
loadtime:1.7773578166962 / seconds
Query Executed:select id FROM `wi` where city='Fairchild' && SIC_code='7231'DB:business_master_new
loadtime:1.7783839702606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairwater' limit 1
loadtime:1.7784569263458 / seconds
Query Executed:select id FROM `wi` where city='Fairwater' && SIC_code='7231'DB:business_master_new
loadtime:1.7791178226471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall Creek' limit 1
loadtime:1.7791728973389 / seconds
Query Executed:select id FROM `wi` where city='Fall Creek' && SIC_code='7231'DB:business_master_new
loadtime:1.7818479537964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:1.7819168567657 / seconds
Query Executed:select id FROM `wi` where city='Fall River' && SIC_code='7231'DB:business_master_new
loadtime:1.7835409641266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence' limit 1
loadtime:1.7836089134216 / seconds
Query Executed:select id FROM `wi` where city='Fence' && SIC_code='7231'DB:business_master_new
loadtime:1.7842438220978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fennimore' limit 1
loadtime:1.784295797348 / seconds
Query Executed:select id FROM `wi` where city='Fennimore' && SIC_code='7231'DB:business_master_new
loadtime:1.7878279685974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwood' limit 1
loadtime:1.7879009246826 / seconds
Query Executed:select id FROM `wi` where city='Fenwood' && SIC_code='7231'DB:business_master_new
loadtime:1.7883429527283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferryville' limit 1
loadtime:1.78839802742 / seconds
Query Executed:select id FROM `wi` where city='Ferryville' && SIC_code='7231'DB:business_master_new
loadtime:1.7895679473877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fifield' limit 1
loadtime:1.7896368503571 / seconds
Query Executed:select id FROM `wi` where city='Fifield' && SIC_code='7231'DB:business_master_new
loadtime:1.7905008792877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fish Creek' limit 1
loadtime:1.7905550003052 / seconds
Query Executed:select id FROM `wi` where city='Fish Creek' && SIC_code='7231'DB:business_master_new
loadtime:1.7934939861298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:1.7935647964478 / seconds
Query Executed:select id FROM `wi` where city='Fitchburg' && SIC_code='7231'DB:business_master_new
loadtime:1.7941529750824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.794205904007 / seconds
Query Executed:select id FROM `wi` where city='Florence' && SIC_code='7231'DB:business_master_new
loadtime:1.7970418930054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fond Du Lac' limit 1
loadtime:1.7971129417419 / seconds
Query Executed:select id FROM `wi` where city='Fond Du Lac' && SIC_code='7231'DB:business_master_new
loadtime:1.8331878185272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana' limit 1
loadtime:1.8334069252014 / seconds
Query Executed:select id FROM `wi` where city='Fontana' && SIC_code='7231'DB:business_master_new
loadtime:1.835254907608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Footville' limit 1
loadtime:1.8353409767151 / seconds
Query Executed:select id FROM `wi` where city='Footville' && SIC_code='7231'DB:business_master_new
loadtime:1.8363888263702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Junction' limit 1
loadtime:1.8364570140839 / seconds
Query Executed:select id FROM `wi` where city='Forest Junction' && SIC_code='7231'DB:business_master_new
loadtime:1.8371088504791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestville' limit 1
loadtime:1.8371629714966 / seconds
Query Executed:select id FROM `wi` where city='Forestville' && SIC_code='7231'DB:business_master_new
loadtime:1.8382468223572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:1.8383238315582 / seconds
Query Executed:select id FROM `wi` where city='Fort Atkinson' && SIC_code='7231'DB:business_master_new
loadtime:1.8536329269409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mccoy' limit 1
loadtime:1.8537278175354 / seconds
Query Executed:select id FROM `wi` where city='Fort Mccoy' && SIC_code='7231'DB:business_master_new
loadtime:1.8542609214783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain City' limit 1
loadtime:1.8543269634247 / seconds
Query Executed:select id FROM `wi` where city='Fountain City' && SIC_code='7231'DB:business_master_new
loadtime:1.8564410209656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fox Lake' limit 1
loadtime:1.8565158843994 / seconds
Query Executed:select id FROM `wi` where city='Fox Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.8587698936462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:1.8588438034058 / seconds
Query Executed:select id FROM `wi` where city='Foxboro' && SIC_code='7231'DB:business_master_new
loadtime:1.8595998287201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francis Creek' limit 1
loadtime:1.8596549034119 / seconds
Query Executed:select id FROM `wi` where city='Francis Creek' && SIC_code='7231'DB:business_master_new
loadtime:1.8603370189667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.8604028224945 / seconds
Query Executed:select id FROM `wi` where city='Franklin' && SIC_code='7231'DB:business_master_new
loadtime:1.8776938915253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franksville' limit 1
loadtime:1.8777918815613 / seconds
Query Executed:select id FROM `wi` where city='Franksville' && SIC_code='7231'DB:business_master_new
loadtime:1.9405097961426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederic' limit 1
loadtime:1.9406459331512 / seconds
Query Executed:select id FROM `wi` where city='Frederic' && SIC_code='7231'DB:business_master_new
loadtime:2.0017309188843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:2.0018858909607 / seconds
Query Executed:select id FROM `wi` where city='Fredonia' && SIC_code='7231'DB:business_master_new
loadtime:2.0046889781952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:2.0047678947449 / seconds
Query Executed:select id FROM `wi` where city='Freedom' && SIC_code='7231'DB:business_master_new
loadtime:2.0052258968353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:2.0052819252014 / seconds
Query Executed:select id FROM `wi` where city='Fremont' && SIC_code='7231'DB:business_master_new
loadtime:2.0078899860382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friendship' limit 1
loadtime:2.0079579353333 / seconds
Query Executed:select id FROM `wi` where city='Friendship' && SIC_code='7231'DB:business_master_new
loadtime:2.0108919143677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friesland' limit 1
loadtime:2.0109639167786 / seconds
Query Executed:select id FROM `wi` where city='Friesland' && SIC_code='7231'DB:business_master_new
loadtime:2.0117318630219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesville' limit 1
loadtime:2.0117998123169 / seconds
Query Executed:select id FROM `wi` where city='Galesville' && SIC_code='7231'DB:business_master_new
loadtime:2.0146818161011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galloway' limit 1
loadtime:2.0147528648376 / seconds
Query Executed:select id FROM `wi` where city='Galloway' && SIC_code='7231'DB:business_master_new
loadtime:2.01518201828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gays Mills' limit 1
loadtime:2.0152359008789 / seconds
Query Executed:select id FROM `wi` where city='Gays Mills' && SIC_code='7231'DB:business_master_new
loadtime:2.0171189308167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genesee Depot' limit 1
loadtime:2.0171909332275 / seconds
Query Executed:select id FROM `wi` where city='Genesee Depot' && SIC_code='7231'DB:business_master_new
loadtime:2.0183780193329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa' limit 1
loadtime:2.0184509754181 / seconds
Query Executed:select id FROM `wi` where city='Genoa' && SIC_code='7231'DB:business_master_new
loadtime:2.0196568965912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa City' limit 1
loadtime:2.0197257995605 / seconds
Query Executed:select id FROM `wi` where city='Genoa City' && SIC_code='7231'DB:business_master_new
loadtime:2.0226888656616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germantown' limit 1
loadtime:2.0227608680725 / seconds
Query Executed:select id FROM `wi` where city='Germantown' && SIC_code='7231'DB:business_master_new
loadtime:2.0379869937897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gile' limit 1
loadtime:2.0380959510803 / seconds
Query Executed:select id FROM `wi` where city='Gile' && SIC_code='7231'DB:business_master_new
loadtime:2.0386250019073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett' limit 1
loadtime:2.0386829376221 / seconds
Query Executed:select id FROM `wi` where city='Gillett' && SIC_code='7231'DB:business_master_new
loadtime:2.0413019657135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:2.041375875473 / seconds
Query Executed:select id FROM `wi` where city='Gilman' && SIC_code='7231'DB:business_master_new
loadtime:2.043004989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:2.043075799942 / seconds
Query Executed:select id FROM `wi` where city='Gilmanton' && SIC_code='7231'DB:business_master_new
loadtime:2.0436298847198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gleason' limit 1
loadtime:2.0436859130859 / seconds
Query Executed:select id FROM `wi` where city='Gleason' && SIC_code='7231'DB:business_master_new
loadtime:2.0449860095978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Flora' limit 1
loadtime:2.0450539588928 / seconds
Query Executed:select id FROM `wi` where city='Glen Flora' && SIC_code='7231'DB:business_master_new
loadtime:2.045914888382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Haven' limit 1
loadtime:2.0459678173065 / seconds
Query Executed:select id FROM `wi` where city='Glen Haven' && SIC_code='7231'DB:business_master_new
loadtime:2.0469529628754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenbeulah' limit 1
loadtime:2.0470199584961 / seconds
Query Executed:select id FROM `wi` where city='Glenbeulah' && SIC_code='7231'DB:business_master_new
loadtime:2.0480868816376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood City' limit 1
loadtime:2.0481419563293 / seconds
Query Executed:select id FROM `wi` where city='Glenwood City' && SIC_code='7231'DB:business_master_new
loadtime:2.1088578701019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:2.1089839935303 / seconds
Query Executed:select id FROM `wi` where city='Glidden' && SIC_code='7231'DB:business_master_new
loadtime:2.1102089881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodman' limit 1
loadtime:2.1102797985077 / seconds
Query Executed:select id FROM `wi` where city='Goodman' && SIC_code='7231'DB:business_master_new
loadtime:2.1111569404602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordon' limit 1
loadtime:2.111212015152 / seconds
Query Executed:select id FROM `wi` where city='Gordon' && SIC_code='7231'DB:business_master_new
loadtime:2.1124379634857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gotham' limit 1
loadtime:2.1124978065491 / seconds
Query Executed:select id FROM `wi` where city='Gotham' && SIC_code='7231'DB:business_master_new
loadtime:2.1130130290985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:2.1130650043488 / seconds
Query Executed:select id FROM `wi` where city='Grafton' && SIC_code='7231'DB:business_master_new
loadtime:2.1269149780273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Marsh' limit 1
loadtime:2.127005815506 / seconds
Query Executed:select id FROM `wi` where city='Grand Marsh' && SIC_code='7231'DB:business_master_new
loadtime:2.1280529499054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand View' limit 1
loadtime:2.1281118392944 / seconds
Query Executed:select id FROM `wi` where city='Grand View' && SIC_code='7231'DB:business_master_new
loadtime:2.128791809082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granton' limit 1
loadtime:2.1288588047028 / seconds
Query Executed:select id FROM `wi` where city='Granton' && SIC_code='7231'DB:business_master_new
loadtime:2.1302289962769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsburg' limit 1
loadtime:2.1303079128265 / seconds
Query Executed:select id FROM `wi` where city='Grantsburg' && SIC_code='7231'DB:business_master_new
loadtime:2.1337959766388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gratiot' limit 1
loadtime:2.1338670253754 / seconds
Query Executed:select id FROM `wi` where city='Gratiot' && SIC_code='7231'DB:business_master_new
loadtime:2.1351058483124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:2.1351749897003 / seconds
Query Executed:select id FROM `wi` where city='Green Bay' && SIC_code='7231'DB:business_master_new
loadtime:2.2354419231415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Lake' limit 1
loadtime:2.2358148097992 / seconds
Query Executed:select id FROM `wi` where city='Green Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.2395470142365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:2.2396428585052 / seconds
Query Executed:select id FROM `wi` where city='Green Valley' && SIC_code='7231'DB:business_master_new
loadtime:2.240140914917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:2.2401969432831 / seconds
Query Executed:select id FROM `wi` where city='Greenbush' && SIC_code='7231'DB:business_master_new
loadtime:2.2407779693604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greendale' limit 1
loadtime:2.2408328056335 / seconds
Query Executed:select id FROM `wi` where city='Greendale' && SIC_code='7231'DB:business_master_new
loadtime:2.3026158809662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:2.3027708530426 / seconds
Query Executed:select id FROM `wi` where city='Greenfield' && SIC_code='7231'DB:business_master_new
loadtime:2.3034780025482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenleaf' limit 1
loadtime:2.3035368919373 / seconds
Query Executed:select id FROM `wi` where city='Greenleaf' && SIC_code='7231'DB:business_master_new
loadtime:2.3062148094177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:2.3062949180603 / seconds
Query Executed:select id FROM `wi` where city='Greenville' && SIC_code='7231'DB:business_master_new
loadtime:2.3100538253784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:2.310122013092 / seconds
Query Executed:select id FROM `wi` where city='Greenwood' && SIC_code='7231'DB:business_master_new
loadtime:2.3127789497375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:2.3128538131714 / seconds
Query Executed:select id FROM `wi` where city='Gresham' && SIC_code='7231'DB:business_master_new
loadtime:2.3142650127411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hager City' limit 1
loadtime:2.3143420219421 / seconds
Query Executed:select id FROM `wi` where city='Hager City' && SIC_code='7231'DB:business_master_new
loadtime:2.3158059120178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Corners' limit 1
loadtime:2.3158609867096 / seconds
Query Executed:select id FROM `wi` where city='Hales Corners' && SIC_code='7231'DB:business_master_new
loadtime:2.3279988765717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:2.3281598091125 / seconds
Query Executed:select id FROM `wi` where city='Hamburg' && SIC_code='7231'DB:business_master_new
loadtime:2.3285598754883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hammond' limit 1
loadtime:2.3286218643188 / seconds
Query Executed:select id FROM `wi` where city='Hammond' && SIC_code='7231'DB:business_master_new
loadtime:2.3303809165955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:2.3304510116577 / seconds
Query Executed:select id FROM `wi` where city='Hancock' && SIC_code='7231'DB:business_master_new
loadtime:2.3318150043488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hannibal' limit 1
loadtime:2.3318839073181 / seconds
Query Executed:select id FROM `wi` where city='Hannibal' && SIC_code='7231'DB:business_master_new
loadtime:2.3323240280151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:2.3323769569397 / seconds
Query Executed:select id FROM `wi` where city='Hanover' && SIC_code='7231'DB:business_master_new
loadtime:2.3328108787537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harshaw' limit 1
loadtime:2.3328638076782 / seconds
Query Executed:select id FROM `wi` where city='Harshaw' && SIC_code='7231'DB:business_master_new
loadtime:2.3338198661804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:2.333872795105 / seconds
Query Executed:select id FROM `wi` where city='Hartford' && SIC_code='7231'DB:business_master_new
loadtime:2.3493628501892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:2.3494539260864 / seconds
Query Executed:select id FROM `wi` where city='Hartland' && SIC_code='7231'DB:business_master_new
loadtime:2.3660209178925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatley' limit 1
loadtime:2.3661589622498 / seconds
Query Executed:select id FROM `wi` where city='Hatley' && SIC_code='7231'DB:business_master_new
loadtime:2.368026971817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haugen' limit 1
loadtime:2.368106842041 / seconds
Query Executed:select id FROM `wi` where city='Haugen' && SIC_code='7231'DB:business_master_new
loadtime:2.3687918186188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkins' limit 1
loadtime:2.3688478469849 / seconds
Query Executed:select id FROM `wi` where city='Hawkins' && SIC_code='7231'DB:business_master_new
loadtime:2.3696868419647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawthorne' limit 1
loadtime:2.3697409629822 / seconds
Query Executed:select id FROM `wi` where city='Hawthorne' && SIC_code='7231'DB:business_master_new
loadtime:2.3703708648682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayward' limit 1
loadtime:2.3704237937927 / seconds
Query Executed:select id FROM `wi` where city='Hayward' && SIC_code='7231'DB:business_master_new
loadtime:2.3902180194855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Green' limit 1
loadtime:2.3903329372406 / seconds
Query Executed:select id FROM `wi` where city='Hazel Green' && SIC_code='7231'DB:business_master_new
loadtime:2.3923678398132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelhurst' limit 1
loadtime:2.3924407958984 / seconds
Query Executed:select id FROM `wi` where city='Hazelhurst' && SIC_code='7231'DB:business_master_new
loadtime:2.3939828872681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heafford Jct' limit 1
loadtime:2.3940379619598 / seconds
Query Executed:select id FROM `wi` where city='Heafford Jct' && SIC_code='7231'DB:business_master_new
loadtime:2.3944809436798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heafford Junction' limit 1
loadtime:2.3945338726044 / seconds
Query Executed:select id FROM `wi` where city='Heafford Junction' && SIC_code='7231'DB:business_master_new
loadtime:2.3949990272522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helenville' limit 1
loadtime:2.3950510025024 / seconds
Query Executed:select id FROM `wi` where city='Helenville' && SIC_code='7231'DB:business_master_new
loadtime:2.3963589668274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herbster' limit 1
loadtime:2.3964128494263 / seconds
Query Executed:select id FROM `wi` where city='Herbster' && SIC_code='7231'DB:business_master_new
loadtime:2.3971018791199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hertel' limit 1
loadtime:2.3971538543701 / seconds
Query Executed:select id FROM `wi` where city='Hertel' && SIC_code='7231'DB:business_master_new
loadtime:2.3977379798889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hewitt' limit 1
loadtime:2.3977909088135 / seconds
Query Executed:select id FROM `wi` where city='Hewitt' && SIC_code='7231'DB:business_master_new
loadtime:2.3984999656677 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Bridge' limit 1
loadtime:2.3985528945923 / seconds
Query Executed:select id FROM `wi` where city='High Bridge' && SIC_code='7231'DB:business_master_new
loadtime:2.3991370201111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:2.3991889953613 / seconds
Query Executed:select id FROM `wi` where city='Highland' && SIC_code='7231'DB:business_master_new
loadtime:2.4009909629822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilbert' limit 1
loadtime:2.4010570049286 / seconds
Query Executed:select id FROM `wi` where city='Hilbert' && SIC_code='7231'DB:business_master_new
loadtime:2.4035868644714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillpoint' limit 1
loadtime:2.4036548137665 / seconds
Query Executed:select id FROM `wi` where city='Hillpoint' && SIC_code='7231'DB:business_master_new
loadtime:2.4046688079834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:2.4047238826752 / seconds
Query Executed:select id FROM `wi` where city='Hillsboro' && SIC_code='7231'DB:business_master_new
loadtime:2.4078319072723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:2.4079079627991 / seconds
Query Executed:select id FROM `wi` where city='Hillsdale' && SIC_code='7231'DB:business_master_new
loadtime:2.4083700180054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:2.4084258079529 / seconds
Query Executed:select id FROM `wi` where city='Hingham' && SIC_code='7231'DB:business_master_new
loadtime:2.4090428352356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hixton' limit 1
loadtime:2.4090948104858 / seconds
Query Executed:select id FROM `wi` where city='Hixton' && SIC_code='7231'DB:business_master_new
loadtime:2.4107220172882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcombe' limit 1
loadtime:2.4107928276062 / seconds
Query Executed:select id FROM `wi` where city='Holcombe' && SIC_code='7231'DB:business_master_new
loadtime:2.41264295578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollandale' limit 1
loadtime:2.4127149581909 / seconds
Query Executed:select id FROM `wi` where city='Hollandale' && SIC_code='7231'DB:business_master_new
loadtime:2.4137868881226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holmen' limit 1
loadtime:2.4138538837433 / seconds
Query Executed:select id FROM `wi` where city='Holmen' && SIC_code='7231'DB:business_master_new
loadtime:2.47474193573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:2.474879026413 / seconds
Query Executed:select id FROM `wi` where city='Honey Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.4755690097809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horicon' limit 1
loadtime:2.4756247997284 / seconds
Query Executed:select id FROM `wi` where city='Horicon' && SIC_code='7231'DB:business_master_new
loadtime:2.4787378311157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hortonville' limit 1
loadtime:2.4788060188293 / seconds
Query Executed:select id FROM `wi` where city='Hortonville' && SIC_code='7231'DB:business_master_new
loadtime:2.5394608974457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houlton' limit 1
loadtime:2.5395967960358 / seconds
Query Executed:select id FROM `wi` where city='Houlton' && SIC_code='7231'DB:business_master_new
loadtime:2.5407748222351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howards Grove' limit 1
loadtime:2.5408318042755 / seconds
Query Executed:select id FROM `wi` where city='Howards Grove' && SIC_code='7231'DB:business_master_new
loadtime:2.541268825531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubertus' limit 1
loadtime:2.5413308143616 / seconds
Query Executed:select id FROM `wi` where city='Hubertus' && SIC_code='7231'DB:business_master_new
loadtime:2.5440289974213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:2.5441029071808 / seconds
Query Executed:select id FROM `wi` where city='Hudson' && SIC_code='7231'DB:business_master_new
loadtime:2.5653958320618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humbird' limit 1
loadtime:2.5655248165131 / seconds
Query Executed:select id FROM `wi` where city='Humbird' && SIC_code='7231'DB:business_master_new
loadtime:2.5662579536438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:2.5663390159607 / seconds
Query Executed:select id FROM `wi` where city='Hurley' && SIC_code='7231'DB:business_master_new
loadtime:2.5694499015808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustisford' limit 1
loadtime:2.5695238113403 / seconds
Query Executed:select id FROM `wi` where city='Hustisford' && SIC_code='7231'DB:business_master_new
loadtime:2.570928812027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustler' limit 1
loadtime:2.5709989070892 / seconds
Query Executed:select id FROM `wi` where city='Hustler' && SIC_code='7231'DB:business_master_new
loadtime:2.5715818405151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:2.5716369152069 / seconds
Query Executed:select id FROM `wi` where city='Independence' && SIC_code='7231'DB:business_master_new
loadtime:2.5741648674011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingram' limit 1
loadtime:2.5742409229279 / seconds
Query Executed:select id FROM `wi` where city='Ingram' && SIC_code='7231'DB:business_master_new
loadtime:2.5746328830719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iola' limit 1
loadtime:2.5746870040894 / seconds
Query Executed:select id FROM `wi` where city='Iola' && SIC_code='7231'DB:business_master_new
loadtime:2.577271938324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irma' limit 1
loadtime:2.577360868454 / seconds
Query Executed:select id FROM `wi` where city='Irma' && SIC_code='7231'DB:business_master_new
loadtime:2.5782148838043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Belt' limit 1
loadtime:2.5782709121704 / seconds
Query Executed:select id FROM `wi` where city='Iron Belt' && SIC_code='7231'DB:business_master_new
loadtime:2.5787949562073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Ridge' limit 1
loadtime:2.5788478851318 / seconds
Query Executed:select id FROM `wi` where city='Iron Ridge' && SIC_code='7231'DB:business_master_new
loadtime:2.5803558826447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron River' limit 1
loadtime:2.5804088115692 / seconds
Query Executed:select id FROM `wi` where city='Iron River' && SIC_code='7231'DB:business_master_new
loadtime:2.5831899642944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ixonia' limit 1
loadtime:2.5832648277283 / seconds
Query Executed:select id FROM `wi` where city='Ixonia' && SIC_code='7231'DB:business_master_new
loadtime:2.5853400230408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:2.5854089260101 / seconds
Query Executed:select id FROM `wi` where city='Jackson' && SIC_code='7231'DB:business_master_new
loadtime:2.646152973175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:2.6462798118591 / seconds
Query Executed:select id FROM `wi` where city='Janesville' && SIC_code='7231'DB:business_master_new
loadtime:2.6903100013733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:2.6905570030212 / seconds
Query Executed:select id FROM `wi` where city='Jefferson' && SIC_code='7231'DB:business_master_new
loadtime:2.7517240047455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jim Falls' limit 1
loadtime:2.7518858909607 / seconds
Query Executed:select id FROM `wi` where city='Jim Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.7528738975525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson Creek' limit 1
loadtime:2.7529428005219 / seconds
Query Executed:select id FROM `wi` where city='Johnson Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.7563149929047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juda' limit 1
loadtime:2.7563939094543 / seconds
Query Executed:select id FROM `wi` where city='Juda' && SIC_code='7231'DB:business_master_new
loadtime:2.7577078342438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jump River' limit 1
loadtime:2.7577760219574 / seconds
Query Executed:select id FROM `wi` where city='Jump River' && SIC_code='7231'DB:business_master_new
loadtime:2.758260011673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction City' limit 1
loadtime:2.7583220005035 / seconds
Query Executed:select id FROM `wi` where city='Junction City' && SIC_code='7231'DB:business_master_new
loadtime:2.7598748207092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juneau' limit 1
loadtime:2.7599289417267 / seconds
Query Executed:select id FROM `wi` where city='Juneau' && SIC_code='7231'DB:business_master_new
loadtime:2.7630929946899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kansasville' limit 1
loadtime:2.7631678581238 / seconds
Query Executed:select id FROM `wi` where city='Kansasville' && SIC_code='7231'DB:business_master_new
loadtime:2.7649788856506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaukauna' limit 1
loadtime:2.7650349140167 / seconds
Query Executed:select id FROM `wi` where city='Kaukauna' && SIC_code='7231'DB:business_master_new
loadtime:2.7809598445892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellnersville' limit 1
loadtime:2.7810578346252 / seconds
Query Executed:select id FROM `wi` where city='Kellnersville' && SIC_code='7231'DB:business_master_new
loadtime:2.7815978527069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:2.781665802002 / seconds
Query Executed:select id FROM `wi` where city='Kendall' && SIC_code='7231'DB:business_master_new
loadtime:2.7831528186798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennan' limit 1
loadtime:2.7832219600677 / seconds
Query Executed:select id FROM `wi` where city='Kennan' && SIC_code='7231'DB:business_master_new
loadtime:2.7839360237122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenosha' limit 1
loadtime:2.78400182724 / seconds
Query Executed:select id FROM `wi` where city='Kenosha' && SIC_code='7231'DB:business_master_new
loadtime:2.8313448429108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keshena' limit 1
loadtime:2.8316168785095 / seconds
Query Executed:select id FROM `wi` where city='Keshena' && SIC_code='7231'DB:business_master_new
loadtime:2.8333668708801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewaskum' limit 1
loadtime:2.8334469795227 / seconds
Query Executed:select id FROM `wi` where city='Kewaskum' && SIC_code='7231'DB:business_master_new
loadtime:2.8393130302429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewaunee' limit 1
loadtime:2.8393919467926 / seconds
Query Executed:select id FROM `wi` where city='Kewaunee' && SIC_code='7231'DB:business_master_new
loadtime:2.8443958759308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiel' limit 1
loadtime:2.8444948196411 / seconds
Query Executed:select id FROM `wi` where city='Kiel' && SIC_code='7231'DB:business_master_new
loadtime:2.8486378192902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kieler' limit 1
loadtime:2.8487148284912 / seconds
Query Executed:select id FROM `wi` where city='Kieler' && SIC_code='7231'DB:business_master_new
loadtime:2.8497409820557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimberly' limit 1
loadtime:2.8497970104218 / seconds
Query Executed:select id FROM `wi` where city='Kimberly' && SIC_code='7231'DB:business_master_new
loadtime:2.8529269695282 / seconds
Query loaded from cache:select * from geodata_geocity where city='King' limit 1
loadtime:2.8530039787292 / seconds
Query Executed:select id FROM `wi` where city='King' && SIC_code='7231'DB:business_master_new
loadtime:2.8535950183868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:2.8536508083344 / seconds
Query Executed:select id FROM `wi` where city='Kingston' && SIC_code='7231'DB:business_master_new
loadtime:2.8542649745941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knapp' limit 1
loadtime:2.8543410301208 / seconds
Query Executed:select id FROM `wi` where city='Knapp' && SIC_code='7231'DB:business_master_new
loadtime:2.8553278446198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knowles' limit 1
loadtime:2.8553957939148 / seconds
Query Executed:select id FROM `wi` where city='Knowles' && SIC_code='7231'DB:business_master_new
loadtime:2.8557968139648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kohler' limit 1
loadtime:2.8558509349823 / seconds
Query Executed:select id FROM `wi` where city='Kohler' && SIC_code='7231'DB:business_master_new
loadtime:2.8576059341431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Krakow' limit 1
loadtime:2.8576729297638 / seconds
Query Executed:select id FROM `wi` where city='Krakow' && SIC_code='7231'DB:business_master_new
loadtime:2.8585059642792 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:2.8585598468781 / seconds
Query Executed:select id FROM `wi` where city='La Crosse' && SIC_code='7231'DB:business_master_new
loadtime:2.9001369476318 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Farge' limit 1
loadtime:2.9003798961639 / seconds
Query Executed:select id FROM `wi` where city='La Farge' && SIC_code='7231'DB:business_master_new
loadtime:2.9024348258972 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Pointe' limit 1
loadtime:2.9025249481201 / seconds
Query Executed:select id FROM `wi` where city='La Pointe' && SIC_code='7231'DB:business_master_new
loadtime:2.9038848876953 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Valle' limit 1
loadtime:2.9039399623871 / seconds
Query Executed:select id FROM `wi` where city='La Valle' && SIC_code='7231'DB:business_master_new
loadtime:2.9059720039368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lac Du Flambeau' limit 1
loadtime:2.9060389995575 / seconds
Query Executed:select id FROM `wi` where city='Lac Du Flambeau' && SIC_code='7231'DB:business_master_new
loadtime:2.9078178405762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:2.9078729152679 / seconds
Query Executed:select id FROM `wi` where city='Ladysmith' && SIC_code='7231'DB:business_master_new
loadtime:2.9689888954163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Delton' limit 1
loadtime:2.9691298007965 / seconds
Query Executed:select id FROM `wi` where city='Lake Delton' && SIC_code='7231'DB:business_master_new
loadtime:2.971177816391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Geneva' limit 1
loadtime:2.9712479114532 / seconds
Query Executed:select id FROM `wi` where city='Lake Geneva' && SIC_code='7231'DB:business_master_new
loadtime:2.9895858764648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:2.9896998405457 / seconds
Query Executed:select id FROM `wi` where city='Lake Mills' && SIC_code='7231'DB:business_master_new
loadtime:3.0506088733673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Nebagamon' limit 1
loadtime:3.0507469177246 / seconds
Query Executed:select id FROM `wi` where city='Lake Nebagamon' && SIC_code='7231'DB:business_master_new
loadtime:3.0522549152374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Tomahawk' limit 1
loadtime:3.0523328781128 / seconds
Query Executed:select id FROM `wi` where city='Lake Tomahawk' && SIC_code='7231'DB:business_master_new
loadtime:3.0536918640137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:3.0537579059601 / seconds
Query Executed:select id FROM `wi` where city='Lakewood' && SIC_code='7231'DB:business_master_new
loadtime:3.0556428432465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:3.0557107925415 / seconds
Query Executed:select id FROM `wi` where city='Lancaster' && SIC_code='7231'DB:business_master_new
loadtime:3.1162049770355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Land O Lakes' limit 1
loadtime:3.1163589954376 / seconds
Query Executed:select id FROM `wi` where city='Land O Lakes' && SIC_code='7231'DB:business_master_new
loadtime:3.1184179782867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lannon' limit 1
loadtime:3.1184937953949 / seconds
Query Executed:select id FROM `wi` where city='Lannon' && SIC_code='7231'DB:business_master_new
loadtime:3.1202068328857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laona' limit 1
loadtime:3.1202750205994 / seconds
Query Executed:select id FROM `wi` where city='Laona' && SIC_code='7231'DB:business_master_new
loadtime:3.1217739582062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larsen' limit 1
loadtime:3.1218409538269 / seconds
Query Executed:select id FROM `wi` where city='Larsen' && SIC_code='7231'DB:business_master_new
loadtime:3.123370885849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:3.123438835144 / seconds
Query Executed:select id FROM `wi` where city='Lebanon' && SIC_code='7231'DB:business_master_new
loadtime:3.1240108013153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lena' limit 1
loadtime:3.1240658760071 / seconds
Query Executed:select id FROM `wi` where city='Lena' && SIC_code='7231'DB:business_master_new
loadtime:3.1263198852539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leopolis' limit 1
loadtime:3.1263918876648 / seconds
Query Executed:select id FROM `wi` where city='Leopolis' && SIC_code='7231'DB:business_master_new
loadtime:3.1269979476929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:3.1270530223846 / seconds
Query Executed:select id FROM `wi` where city='Lewis' && SIC_code='7231'DB:business_master_new
loadtime:3.1275098323822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lily' limit 1
loadtime:3.127564907074 / seconds
Query Executed:select id FROM `wi` where city='Lily' && SIC_code='7231'DB:business_master_new
loadtime:3.1280019283295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Ridge' limit 1
loadtime:3.1280539035797 / seconds
Query Executed:select id FROM `wi` where city='Lime Ridge' && SIC_code='7231'DB:business_master_new
loadtime:3.128643989563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limeridge' limit 1
loadtime:3.1286959648132 / seconds
Query Executed:select id FROM `wi` where city='Limeridge' && SIC_code='7231'DB:business_master_new
loadtime:3.1290678977966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:3.1291189193726 / seconds
Query Executed:select id FROM `wi` where city='Linden' && SIC_code='7231'DB:business_master_new
loadtime:3.1297287940979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Chute' limit 1
loadtime:3.1297810077667 / seconds
Query Executed:select id FROM `wi` where city='Little Chute' && SIC_code='7231'DB:business_master_new
loadtime:3.1901597976685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Suamico' limit 1
loadtime:3.1903069019318 / seconds
Query Executed:select id FROM `wi` where city='Little Suamico' && SIC_code='7231'DB:business_master_new
loadtime:3.1917779445648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:3.1918699741364 / seconds
Query Executed:select id FROM `wi` where city='Livingston' && SIC_code='7231'DB:business_master_new
loadtime:3.193060874939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodi' limit 1
loadtime:3.1931278705597 / seconds
Query Executed:select id FROM `wi` where city='Lodi' && SIC_code='7231'DB:business_master_new
loadtime:3.2542448043823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loganville' limit 1
loadtime:3.2544128894806 / seconds
Query Executed:select id FROM `wi` where city='Loganville' && SIC_code='7231'DB:business_master_new
loadtime:3.2558948993683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lomira' limit 1
loadtime:3.2559638023376 / seconds
Query Executed:select id FROM `wi` where city='Lomira' && SIC_code='7231'DB:business_master_new
loadtime:3.2582468986511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:3.258327960968 / seconds
Query Executed:select id FROM `wi` where city='Lone Rock' && SIC_code='7231'DB:business_master_new
loadtime:3.2598669528961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Lake' limit 1
loadtime:3.2599229812622 / seconds
Query Executed:select id FROM `wi` where city='Long Lake' && SIC_code='7231'DB:business_master_new
loadtime:3.2607748508453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretta' limit 1
loadtime:3.2608299255371 / seconds
Query Executed:select id FROM `wi` where city='Loretta' && SIC_code='7231'DB:business_master_new
loadtime:3.2613208293915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:3.2613799571991 / seconds
Query Executed:select id FROM `wi` where city='Lowell' && SIC_code='7231'DB:business_master_new
loadtime:3.2620859146118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loyal' limit 1
loadtime:3.2621548175812 / seconds
Query Executed:select id FROM `wi` where city='Loyal' && SIC_code='7231'DB:business_master_new
loadtime:3.2644689083099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lublin' limit 1
loadtime:3.2645409107208 / seconds
Query Executed:select id FROM `wi` where city='Lublin' && SIC_code='7231'DB:business_master_new
loadtime:3.2652199268341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luck' limit 1
loadtime:3.265273809433 / seconds
Query Executed:select id FROM `wi` where city='Luck' && SIC_code='7231'DB:business_master_new
loadtime:3.2682459354401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:3.2683370113373 / seconds
Query Executed:select id FROM `wi` where city='Luxemburg' && SIC_code='7231'DB:business_master_new
loadtime:3.2728369235992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Station' limit 1
loadtime:3.2729158401489 / seconds
Query Executed:select id FROM `wi` where city='Lyndon Station' && SIC_code='7231'DB:business_master_new
loadtime:3.2744338512421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynxville' limit 1
loadtime:3.274505853653 / seconds
Query Executed:select id FROM `wi` where city='Lynxville' && SIC_code='7231'DB:business_master_new
loadtime:3.2749719619751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:3.2750248908997 / seconds
Query Executed:select id FROM `wi` where city='Lyons' && SIC_code='7231'DB:business_master_new
loadtime:3.2757709026337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:3.2758238315582 / seconds
Query Executed:select id FROM `wi` where city='Madison' && SIC_code='7231'DB:business_master_new
loadtime:3.4509990215302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maiden Rock' limit 1
loadtime:3.4517288208008 / seconds
Query Executed:select id FROM `wi` where city='Maiden Rock' && SIC_code='7231'DB:business_master_new
loadtime:3.453076839447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malone' limit 1
loadtime:3.4531819820404 / seconds
Query Executed:select id FROM `wi` where city='Malone' && SIC_code='7231'DB:business_master_new
loadtime:3.4547688961029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manawa' limit 1
loadtime:3.4548239707947 / seconds
Query Executed:select id FROM `wi` where city='Manawa' && SIC_code='7231'DB:business_master_new
loadtime:3.4577028751373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:3.4577758312225 / seconds
Query Executed:select id FROM `wi` where city='Manchester' && SIC_code='7231'DB:business_master_new
loadtime:3.4581968784332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowish Waters' limit 1
loadtime:3.4582509994507 / seconds
Query Executed:select id FROM `wi` where city='Manitowish Waters' && SIC_code='7231'DB:business_master_new
loadtime:3.4602329730988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowish Wtrs' limit 1
loadtime:3.4603109359741 / seconds
Query Executed:select id FROM `wi` where city='Manitowish Wtrs' && SIC_code='7231'DB:business_master_new
loadtime:3.4607608318329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowoc' limit 1
loadtime:3.4608159065247 / seconds
Query Executed:select id FROM `wi` where city='Manitowoc' && SIC_code='7231'DB:business_master_new
loadtime:3.4888799190521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple' limit 1
loadtime:3.4890348911285 / seconds
Query Executed:select id FROM `wi` where city='Maple' && SIC_code='7231'DB:business_master_new
loadtime:3.49001288414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplewood' limit 1
loadtime:3.4900858402252 / seconds
Query Executed:select id FROM `wi` where city='Maplewood' && SIC_code='7231'DB:business_master_new
loadtime:3.4906299114227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:3.4906849861145 / seconds
Query Executed:select id FROM `wi` where city='Marathon' && SIC_code='7231'DB:business_master_new
loadtime:3.493882894516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:3.4939589500427 / seconds
Query Executed:select id FROM `wi` where city='Marengo' && SIC_code='7231'DB:business_master_new
loadtime:3.4947969913483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maribel' limit 1
loadtime:3.4948508739471 / seconds
Query Executed:select id FROM `wi` where city='Maribel' && SIC_code='7231'DB:business_master_new
loadtime:3.4961738586426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marinette' limit 1
loadtime:3.49622797966 / seconds
Query Executed:select id FROM `wi` where city='Marinette' && SIC_code='7231'DB:business_master_new
loadtime:3.5575590133667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:3.5577239990234 / seconds
Query Executed:select id FROM `wi` where city='Marion' && SIC_code='7231'DB:business_master_new
loadtime:3.5604209899902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markesan' limit 1
loadtime:3.5605030059814 / seconds
Query Executed:select id FROM `wi` where city='Markesan' && SIC_code='7231'DB:business_master_new
loadtime:3.5635960102081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:3.563670873642 / seconds
Query Executed:select id FROM `wi` where city='Marquette' && SIC_code='7231'DB:business_master_new
loadtime:3.56427693367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:3.5643429756165 / seconds
Query Executed:select id FROM `wi` where city='Marshall' && SIC_code='7231'DB:business_master_new
loadtime:3.567489862442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:3.5675640106201 / seconds
Query Executed:select id FROM `wi` where city='Marshfield' && SIC_code='7231'DB:business_master_new
loadtime:3.6300888061523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:3.6302759647369 / seconds
Query Executed:select id FROM `wi` where city='Mason' && SIC_code='7231'DB:business_master_new
loadtime:3.6317708492279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mather' limit 1
loadtime:3.6318328380585 / seconds
Query Executed:select id FROM `wi` where city='Mather' && SIC_code='7231'DB:business_master_new
loadtime:3.6323490142822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattoon' limit 1
loadtime:3.6324028968811 / seconds
Query Executed:select id FROM `wi` where city='Mattoon' && SIC_code='7231'DB:business_master_new
loadtime:3.633152961731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauston' limit 1
loadtime:3.6332190036774 / seconds
Query Executed:select id FROM `wi` where city='Mauston' && SIC_code='7231'DB:business_master_new
loadtime:3.6947629451752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayville' limit 1
loadtime:3.6949307918549 / seconds
Query Executed:select id FROM `wi` where city='Mayville' && SIC_code='7231'DB:business_master_new
loadtime:3.7558720111847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mazomanie' limit 1
loadtime:3.7559609413147 / seconds
Query Executed:select id FROM `wi` where city='Mazomanie' && SIC_code='7231'DB:business_master_new
loadtime:3.7586178779602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farland' limit 1
loadtime:3.7586889266968 / seconds
Query Executed:select id FROM `wi` where city='Mc Farland' && SIC_code='7231'DB:business_master_new
loadtime:3.8196649551392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Naughton' limit 1
loadtime:3.8197638988495 / seconds
Query Executed:select id FROM `wi` where city='Mc Naughton' && SIC_code='7231'DB:business_master_new
loadtime:3.8202998638153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:3.8203649520874 / seconds
Query Executed:select id FROM `wi` where city='Medford' && SIC_code='7231'DB:business_master_new
loadtime:3.8332300186157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellen' limit 1
loadtime:3.8333249092102 / seconds
Query Executed:select id FROM `wi` where city='Mellen' && SIC_code='7231'DB:business_master_new
loadtime:3.8345899581909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:3.834657907486 / seconds
Query Executed:select id FROM `wi` where city='Melrose' && SIC_code='7231'DB:business_master_new
loadtime:3.8362798690796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menasha' limit 1
loadtime:3.836354970932 / seconds
Query Executed:select id FROM `wi` where city='Menasha' && SIC_code='7231'DB:business_master_new
loadtime:3.8512318134308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menomonee Falls' limit 1
loadtime:3.8513498306274 / seconds
Query Executed:select id FROM `wi` where city='Menomonee Falls' && SIC_code='7231'DB:business_master_new
loadtime:3.8777158260345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menomonie' limit 1
loadtime:3.8779218196869 / seconds
Query Executed:select id FROM `wi` where city='Menomonie' && SIC_code='7231'DB:business_master_new
loadtime:3.8961408138275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mequon' limit 1
loadtime:3.8962459564209 / seconds
Query Executed:select id FROM `wi` where city='Mequon' && SIC_code='7231'DB:business_master_new
loadtime:3.9254109859467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mercer' limit 1
loadtime:3.9256799221039 / seconds
Query Executed:select id FROM `wi` where city='Mercer' && SIC_code='7231'DB:business_master_new
loadtime:3.9280149936676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:3.9280948638916 / seconds
Query Executed:select id FROM `wi` where city='Merrill' && SIC_code='7231'DB:business_master_new
loadtime:3.9430108070374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrillan' limit 1
loadtime:3.943107843399 / seconds
Query Executed:select id FROM `wi` where city='Merrillan' && SIC_code='7231'DB:business_master_new
loadtime:3.9443869590759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:3.9444618225098 / seconds
Query Executed:select id FROM `wi` where city='Merrimac' && SIC_code='7231'DB:business_master_new
loadtime:3.9456369876862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merton' limit 1
loadtime:3.9457058906555 / seconds
Query Executed:select id FROM `wi` where city='Merton' && SIC_code='7231'DB:business_master_new
loadtime:3.9465699195862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Inlet' limit 1
loadtime:3.9466359615326 / seconds
Query Executed:select id FROM `wi` where city='Middle Inlet' && SIC_code='7231'DB:business_master_new
loadtime:3.947037935257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:3.9470918178558 / seconds
Query Executed:select id FROM `wi` where city='Middleton' && SIC_code='7231'DB:business_master_new
loadtime:3.969263792038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikana' limit 1
loadtime:3.9694108963013 / seconds
Query Executed:select id FROM `wi` where city='Mikana' && SIC_code='7231'DB:business_master_new
loadtime:3.9699859619141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:3.9700458049774 / seconds
Query Executed:select id FROM `wi` where city='Milan' && SIC_code='7231'DB:business_master_new
loadtime:3.9704599380493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milladore' limit 1
loadtime:3.9705128669739 / seconds
Query Executed:select id FROM `wi` where city='Milladore' && SIC_code='7231'DB:business_master_new
loadtime:3.9716358184814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millston' limit 1
loadtime:3.9717049598694 / seconds
Query Executed:select id FROM `wi` where city='Millston' && SIC_code='7231'DB:business_master_new
loadtime:3.9722199440002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milltown' limit 1
loadtime:3.9722728729248 / seconds
Query Executed:select id FROM `wi` where city='Milltown' && SIC_code='7231'DB:business_master_new
loadtime:3.974200963974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:3.9742698669434 / seconds
Query Executed:select id FROM `wi` where city='Milton' && SIC_code='7231'DB:business_master_new
loadtime:4.0355608463287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukee' limit 1
loadtime:4.0357308387756 / seconds
Query Executed:select id FROM `wi` where city='Milwaukee' && SIC_code='7231'DB:business_master_new
loadtime:4.1040668487549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mindoro' limit 1
loadtime:4.1059830188751 / seconds
Query Executed:select id FROM `wi` where city='Mindoro' && SIC_code='7231'DB:business_master_new
loadtime:4.1071448326111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Point' limit 1
loadtime:4.107321023941 / seconds
Query Executed:select id FROM `wi` where city='Mineral Point' && SIC_code='7231'DB:business_master_new
loadtime:4.1114108562469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minocqua' limit 1
loadtime:4.1115019321442 / seconds
Query Executed:select id FROM `wi` where city='Minocqua' && SIC_code='7231'DB:business_master_new
loadtime:4.172385931015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minong' limit 1
loadtime:4.1725409030914 / seconds
Query Executed:select id FROM `wi` where city='Minong' && SIC_code='7231'DB:business_master_new
loadtime:4.1747570037842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mishicot' limit 1
loadtime:4.1748278141022 / seconds
Query Executed:select id FROM `wi` where city='Mishicot' && SIC_code='7231'DB:business_master_new
loadtime:4.1768438816071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modena' limit 1
loadtime:4.1769139766693 / seconds
Query Executed:select id FROM `wi` where city='Modena' && SIC_code='7231'DB:business_master_new
loadtime:4.1773359775543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondovi' limit 1
loadtime:4.1773998737335 / seconds
Query Executed:select id FROM `wi` where city='Mondovi' && SIC_code='7231'DB:business_master_new
loadtime:4.2382488250732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monico' limit 1
loadtime:4.2384099960327 / seconds
Query Executed:select id FROM `wi` where city='Monico' && SIC_code='7231'DB:business_master_new
loadtime:4.2388689517975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:4.2389719486237 / seconds
Query Executed:select id FROM `wi` where city='Monona' && SIC_code='7231'DB:business_master_new
loadtime:4.2394728660583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:4.2395288944244 / seconds
Query Executed:select id FROM `wi` where city='Monroe' && SIC_code='7231'DB:business_master_new
loadtime:4.2566118240356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montello' limit 1
loadtime:4.2567439079285 / seconds
Query Executed:select id FROM `wi` where city='Montello' && SIC_code='7231'DB:business_master_new
loadtime:4.261011838913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montfort' limit 1
loadtime:4.2610929012299 / seconds
Query Executed:select id FROM `wi` where city='Montfort' && SIC_code='7231'DB:business_master_new
loadtime:4.2624168395996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:4.2624888420105 / seconds
Query Executed:select id FROM `wi` where city='Monticello' && SIC_code='7231'DB:business_master_new
loadtime:4.2646288871765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montreal' limit 1
loadtime:4.264702796936 / seconds
Query Executed:select id FROM `wi` where city='Montreal' && SIC_code='7231'DB:business_master_new
loadtime:4.2654228210449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisonville' limit 1
loadtime:4.265478849411 / seconds
Query Executed:select id FROM `wi` where city='Morrisonville' && SIC_code='7231'DB:business_master_new
loadtime:4.2660648822784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosinee' limit 1
loadtime:4.266117811203 / seconds
Query Executed:select id FROM `wi` where city='Mosinee' && SIC_code='7231'DB:business_master_new
loadtime:4.279412984848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Calvary' limit 1
loadtime:4.2794978618622 / seconds
Query Executed:select id FROM `wi` where city='Mount Calvary' && SIC_code='7231'DB:business_master_new
loadtime:4.2810080051422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Hope' limit 1
loadtime:4.2810769081116 / seconds
Query Executed:select id FROM `wi` where city='Mount Hope' && SIC_code='7231'DB:business_master_new
loadtime:4.2819838523865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Horeb' limit 1
loadtime:4.2820389270782 / seconds
Query Executed:select id FROM `wi` where city='Mount Horeb' && SIC_code='7231'DB:business_master_new
loadtime:4.2934868335724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:4.2935798168182 / seconds
Query Executed:select id FROM `wi` where city='Mount Sterling' && SIC_code='7231'DB:business_master_new
loadtime:4.2940428256989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain' limit 1
loadtime:4.2940988540649 / seconds
Query Executed:select id FROM `wi` where city='Mountain' && SIC_code='7231'DB:business_master_new
loadtime:4.2955129146576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Calvary' limit 1
loadtime:4.2955858707428 / seconds
Query Executed:select id FROM `wi` where city='Mt Calvary' && SIC_code='7231'DB:business_master_new
loadtime:4.2959849834442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Hope' limit 1
loadtime:4.2960379123688 / seconds
Query Executed:select id FROM `wi` where city='Mt Hope' && SIC_code='7231'DB:business_master_new
loadtime:4.296413898468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Horeb' limit 1
loadtime:4.2964658737183 / seconds
Query Executed:select id FROM `wi` where city='Mt Horeb' && SIC_code='7231'DB:business_master_new
loadtime:4.2969799041748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:4.297031879425 / seconds
Query Executed:select id FROM `wi` where city='Mt Sterling' && SIC_code='7231'DB:business_master_new
loadtime:4.2974679470062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mukwonago' limit 1
loadtime:4.2975208759308 / seconds
Query Executed:select id FROM `wi` where city='Mukwonago' && SIC_code='7231'DB:business_master_new
loadtime:4.3104088306427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscoda' limit 1
loadtime:4.3104948997498 / seconds
Query Executed:select id FROM `wi` where city='Muscoda' && SIC_code='7231'DB:business_master_new
loadtime:4.3130309581757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskego' limit 1
loadtime:4.3131048679352 / seconds
Query Executed:select id FROM `wi` where city='Muskego' && SIC_code='7231'DB:business_master_new
loadtime:4.3278329372406 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Fond Du Lac' limit 1
loadtime:4.3279638290405 / seconds
Query Executed:select id FROM `wi` where city='N Fond Du Lac' && SIC_code='7231'DB:business_master_new
loadtime:4.3283648490906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashotah' limit 1
loadtime:4.3284358978271 / seconds
Query Executed:select id FROM `wi` where city='Nashotah' && SIC_code='7231'DB:business_master_new
loadtime:4.3303849697113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navarino' limit 1
loadtime:4.3304698467255 / seconds
Query Executed:select id FROM `wi` where city='Navarino' && SIC_code='7231'DB:business_master_new
loadtime:4.3308708667755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Necedah' limit 1
loadtime:4.3309259414673 / seconds
Query Executed:select id FROM `wi` where city='Necedah' && SIC_code='7231'DB:business_master_new
loadtime:4.3333330154419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neenah' limit 1
loadtime:4.33340883255 / seconds
Query Executed:select id FROM `wi` where city='Neenah' && SIC_code='7231'DB:business_master_new
loadtime:4.3583779335022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neillsville' limit 1
loadtime:4.3585088253021 / seconds
Query Executed:select id FROM `wi` where city='Neillsville' && SIC_code='7231'DB:business_master_new
loadtime:4.419793844223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nekoosa' limit 1
loadtime:4.4199368953705 / seconds
Query Executed:select id FROM `wi` where city='Nekoosa' && SIC_code='7231'DB:business_master_new
loadtime:4.4242858886719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:4.4243659973145 / seconds
Query Executed:select id FROM `wi` where city='Nelson' && SIC_code='7231'DB:business_master_new
loadtime:4.4254548549652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonville' limit 1
loadtime:4.4255108833313 / seconds
Query Executed:select id FROM `wi` where city='Nelsonville' && SIC_code='7231'DB:business_master_new
loadtime:4.4260649681091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neopit' limit 1
loadtime:4.4261178970337 / seconds
Query Executed:select id FROM `wi` where city='Neopit' && SIC_code='7231'DB:business_master_new
loadtime:4.4267070293427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neosho' limit 1
loadtime:4.4267609119415 / seconds
Query Executed:select id FROM `wi` where city='Neosho' && SIC_code='7231'DB:business_master_new
loadtime:4.4280769824982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neshkoro' limit 1
loadtime:4.4281458854675 / seconds
Query Executed:select id FROM `wi` where city='Neshkoro' && SIC_code='7231'DB:business_master_new
loadtime:4.4298357963562 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Auburn' limit 1
loadtime:4.4299058914185 / seconds
Query Executed:select id FROM `wi` where city='New Auburn' && SIC_code='7231'DB:business_master_new
loadtime:4.4323928356171 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Berlin' limit 1
loadtime:4.4324660301208 / seconds
Query Executed:select id FROM `wi` where city='New Berlin' && SIC_code='7231'DB:business_master_new
loadtime:4.4581179618835 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Franken' limit 1
loadtime:4.4582719802856 / seconds
Query Executed:select id FROM `wi` where city='New Franken' && SIC_code='7231'DB:business_master_new
loadtime:4.4608359336853 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Glarus' limit 1
loadtime:4.460911989212 / seconds
Query Executed:select id FROM `wi` where city='New Glarus' && SIC_code='7231'DB:business_master_new
loadtime:4.4639918804169 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holstein' limit 1
loadtime:4.4640688896179 / seconds
Query Executed:select id FROM `wi` where city='New Holstein' && SIC_code='7231'DB:business_master_new
loadtime:4.4671308994293 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lisbon' limit 1
loadtime:4.4672038555145 / seconds
Query Executed:select id FROM `wi` where city='New Lisbon' && SIC_code='7231'DB:business_master_new
loadtime:4.4699440002441 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:4.4700169563293 / seconds
Query Executed:select id FROM `wi` where city='New London' && SIC_code='7231'DB:business_master_new
loadtime:4.531772851944 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Munster' limit 1
loadtime:4.5319359302521 / seconds
Query Executed:select id FROM `wi` where city='New Munster' && SIC_code='7231'DB:business_master_new
loadtime:4.5326619148254 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Richmond' limit 1
loadtime:4.5327198505402 / seconds
Query Executed:select id FROM `wi` where city='New Richmond' && SIC_code='7231'DB:business_master_new
loadtime:4.5464069843292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newald' limit 1
loadtime:4.546511888504 / seconds
Query Executed:select id FROM `wi` where city='Newald' && SIC_code='7231'DB:business_master_new
loadtime:4.5469260215759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburg' limit 1
loadtime:4.5469839572906 / seconds
Query Executed:select id FROM `wi` where city='Newburg' && SIC_code='7231'DB:business_master_new
loadtime:4.5477879047394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:4.5478420257568 / seconds
Query Executed:select id FROM `wi` where city='Newton' && SIC_code='7231'DB:business_master_new
loadtime:4.5491960048676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niagara' limit 1
loadtime:4.5492548942566 / seconds
Query Executed:select id FROM `wi` where city='Niagara' && SIC_code='7231'DB:business_master_new
loadtime:4.551962852478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:4.5520348548889 / seconds
Query Executed:select id FROM `wi` where city='Nichols' && SIC_code='7231'DB:business_master_new
loadtime:4.5526080131531 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Freedom' limit 1
loadtime:4.5526628494263 / seconds
Query Executed:select id FROM `wi` where city='North Freedom' && SIC_code='7231'DB:business_master_new
loadtime:4.5541779994965 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Lake' limit 1
loadtime:4.5542459487915 / seconds
Query Executed:select id FROM `wi` where city='North Lake' && SIC_code='7231'DB:business_master_new
loadtime:4.5551178455353 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Prairie' limit 1
loadtime:4.5551719665527 / seconds
Query Executed:select id FROM `wi` where city='North Prairie' && SIC_code='7231'DB:business_master_new
loadtime:4.5571119785309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:4.5571959018707 / seconds
Query Executed:select id FROM `wi` where city='Norwalk' && SIC_code='7231'DB:business_master_new
loadtime:4.5586769580841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Creek' limit 1
loadtime:4.5587468147278 / seconds
Query Executed:select id FROM `wi` where city='Oak Creek' && SIC_code='7231'DB:business_master_new
loadtime:4.5753149986267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:4.5754888057709 / seconds
Query Executed:select id FROM `wi` where city='Oakdale' && SIC_code='7231'DB:business_master_new
loadtime:4.5762138366699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakfield' limit 1
loadtime:4.5762720108032 / seconds
Query Executed:select id FROM `wi` where city='Oakfield' && SIC_code='7231'DB:business_master_new
loadtime:4.5777599811554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconomowoc' limit 1
loadtime:4.5778298377991 / seconds
Query Executed:select id FROM `wi` where city='Oconomowoc' && SIC_code='7231'DB:business_master_new
loadtime:4.6008179187775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconto' limit 1
loadtime:4.6009860038757 / seconds
Query Executed:select id FROM `wi` where city='Oconto' && SIC_code='7231'DB:business_master_new
loadtime:4.6623849868774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconto Falls' limit 1
loadtime:4.6625490188599 / seconds
Query Executed:select id FROM `wi` where city='Oconto Falls' && SIC_code='7231'DB:business_master_new
loadtime:4.6665890216827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odanah' limit 1
loadtime:4.6666719913483 / seconds
Query Executed:select id FROM `wi` where city='Odanah' && SIC_code='7231'DB:business_master_new
loadtime:4.6676068305969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogdensburg' limit 1
loadtime:4.667662858963 / seconds
Query Executed:select id FROM `wi` where city='Ogdensburg' && SIC_code='7231'DB:business_master_new
loadtime:4.6686890125275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogema' limit 1
loadtime:4.6687569618225 / seconds
Query Executed:select id FROM `wi` where city='Ogema' && SIC_code='7231'DB:business_master_new
loadtime:4.6698429584503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojibwa' limit 1
loadtime:4.6699109077454 / seconds
Query Executed:select id FROM `wi` where city='Ojibwa' && SIC_code='7231'DB:business_master_new
loadtime:4.6705558300018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okauchee' limit 1
loadtime:4.6706099510193 / seconds
Query Executed:select id FROM `wi` where city='Okauchee' && SIC_code='7231'DB:business_master_new
loadtime:4.6717917919159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omro' limit 1
loadtime:4.6718599796295 / seconds
Query Executed:select id FROM `wi` where city='Omro' && SIC_code='7231'DB:business_master_new
loadtime:4.6756029129028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onalaska' limit 1
loadtime:4.6757040023804 / seconds
Query Executed:select id FROM `wi` where city='Onalaska' && SIC_code='7231'DB:business_master_new
loadtime:4.69153881073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneida' limit 1
loadtime:4.6916539669037 / seconds
Query Executed:select id FROM `wi` where city='Oneida' && SIC_code='7231'DB:business_master_new
loadtime:4.6946158409119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontario' limit 1
loadtime:4.6946749687195 / seconds
Query Executed:select id FROM `wi` where city='Ontario' && SIC_code='7231'DB:business_master_new
loadtime:4.6959588527679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oostburg' limit 1
loadtime:4.6960129737854 / seconds
Query Executed:select id FROM `wi` where city='Oostburg' && SIC_code='7231'DB:business_master_new
loadtime:4.6989769935608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oregon' limit 1
loadtime:4.699049949646 / seconds
Query Executed:select id FROM `wi` where city='Oregon' && SIC_code='7231'DB:business_master_new
loadtime:4.7604198455811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orfordville' limit 1
loadtime:4.7605748176575 / seconds
Query Executed:select id FROM `wi` where city='Orfordville' && SIC_code='7231'DB:business_master_new
loadtime:4.7621328830719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:4.7622058391571 / seconds
Query Executed:select id FROM `wi` where city='Osceola' && SIC_code='7231'DB:business_master_new
loadtime:4.8230979442596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshkosh' limit 1
loadtime:4.8232378959656 / seconds
Query Executed:select id FROM `wi` where city='Oshkosh' && SIC_code='7231'DB:business_master_new
loadtime:4.8680260181427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osseo' limit 1
loadtime:4.868264913559 / seconds
Query Executed:select id FROM `wi` where city='Osseo' && SIC_code='7231'DB:business_master_new
loadtime:4.8718299865723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owen' limit 1
loadtime:4.8719148635864 / seconds
Query Executed:select id FROM `wi` where city='Owen' && SIC_code='7231'DB:business_master_new
loadtime:4.873792886734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:4.8738639354706 / seconds
Query Executed:select id FROM `wi` where city='Oxford' && SIC_code='7231'DB:business_master_new
loadtime:4.8761248588562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwaukee' limit 1
loadtime:4.8761949539185 / seconds
Query Executed:select id FROM `wi` where city='Packwaukee' && SIC_code='7231'DB:business_master_new
loadtime:4.8768010139465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:4.8768689632416 / seconds
Query Executed:select id FROM `wi` where city='Palmyra' && SIC_code='7231'DB:business_master_new
loadtime:4.8790309429169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pardeeville' limit 1
loadtime:4.8790988922119 / seconds
Query Executed:select id FROM `wi` where city='Pardeeville' && SIC_code='7231'DB:business_master_new
loadtime:4.8824479579926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Falls' limit 1
loadtime:4.8825218677521 / seconds
Query Executed:select id FROM `wi` where city='Park Falls' && SIC_code='7231'DB:business_master_new
loadtime:4.9438858032227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patch Grove' limit 1
loadtime:4.9440338611603 / seconds
Query Executed:select id FROM `wi` where city='Patch Grove' && SIC_code='7231'DB:business_master_new
loadtime:4.944659948349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearson' limit 1
loadtime:4.944727897644 / seconds
Query Executed:select id FROM `wi` where city='Pearson' && SIC_code='7231'DB:business_master_new
loadtime:4.945259809494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelican Lake' limit 1
loadtime:4.9453129768372 / seconds
Query Executed:select id FROM `wi` where city='Pelican Lake' && SIC_code='7231'DB:business_master_new
loadtime:4.9462440013885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pell Lake' limit 1
loadtime:4.9463148117065 / seconds
Query Executed:select id FROM `wi` where city='Pell Lake' && SIC_code='7231'DB:business_master_new
loadtime:4.9471249580383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembine' limit 1
loadtime:4.9471788406372 / seconds
Query Executed:select id FROM `wi` where city='Pembine' && SIC_code='7231'DB:business_master_new
loadtime:4.9484949111938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pence' limit 1
loadtime:4.9485659599304 / seconds
Query Executed:select id FROM `wi` where city='Pence' && SIC_code='7231'DB:business_master_new
loadtime:4.9489870071411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepin' limit 1
loadtime:4.94904088974 / seconds
Query Executed:select id FROM `wi` where city='Pepin' && SIC_code='7231'DB:business_master_new
loadtime:4.9505729675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peshtigo' limit 1
loadtime:4.9506449699402 / seconds
Query Executed:select id FROM `wi` where city='Peshtigo' && SIC_code='7231'DB:business_master_new
loadtime:4.9541459083557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pewaukee' limit 1
loadtime:4.9542238712311 / seconds
Query Executed:select id FROM `wi` where city='Pewaukee' && SIC_code='7231'DB:business_master_new
loadtime:4.9735538959503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phelps' limit 1
loadtime:4.9736928939819 / seconds
Query Executed:select id FROM `wi` where city='Phelps' && SIC_code='7231'DB:business_master_new
loadtime:4.9751570224762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillips' limit 1
loadtime:4.9752168655396 / seconds
Query Executed:select id FROM `wi` where city='Phillips' && SIC_code='7231'DB:business_master_new
loadtime:5.0364668369293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phlox' limit 1
loadtime:5.0366208553314 / seconds
Query Executed:select id FROM `wi` where city='Phlox' && SIC_code='7231'DB:business_master_new
loadtime:5.0371668338776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickerel' limit 1
loadtime:5.0372250080109 / seconds
Query Executed:select id FROM `wi` where city='Pickerel' && SIC_code='7231'DB:business_master_new
loadtime:5.0381729602814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickett' limit 1
loadtime:5.0382277965546 / seconds
Query Executed:select id FROM `wi` where city='Pickett' && SIC_code='7231'DB:business_master_new
loadtime:5.0394048690796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pigeon Falls' limit 1
loadtime:5.0394718647003 / seconds
Query Executed:select id FROM `wi` where city='Pigeon Falls' && SIC_code='7231'DB:business_master_new
loadtime:5.0402119159698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine River' limit 1
loadtime:5.0402829647064 / seconds
Query Executed:select id FROM `wi` where city='Pine River' && SIC_code='7231'DB:business_master_new
loadtime:5.041158914566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:5.0412139892578 / seconds
Query Executed:select id FROM `wi` where city='Pittsville' && SIC_code='7231'DB:business_master_new
loadtime:5.0432178974152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain' limit 1
loadtime:5.0432918071747 / seconds
Query Executed:select id FROM `wi` where city='Plain' && SIC_code='7231'DB:business_master_new
loadtime:5.0448489189148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:5.0449159145355 / seconds
Query Executed:select id FROM `wi` where city='Plainfield' && SIC_code='7231'DB:business_master_new
loadtime:5.0470628738403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platteville' limit 1
loadtime:5.0471348762512 / seconds
Query Executed:select id FROM `wi` where city='Platteville' && SIC_code='7231'DB:business_master_new
loadtime:5.0602948665619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Prairie' limit 1
loadtime:5.0603959560394 / seconds
Query Executed:select id FROM `wi` where city='Pleasant Prairie' && SIC_code='7231'DB:business_master_new
loadtime:5.1215798854828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:5.1217069625854 / seconds
Query Executed:select id FROM `wi` where city='Plover' && SIC_code='7231'DB:business_master_new
loadtime:5.1826798915863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plum City' limit 1
loadtime:5.1828308105469 / seconds
Query Executed:select id FROM `wi` where city='Plum City' && SIC_code='7231'DB:business_master_new
loadtime:5.1843128204346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:5.1843960285187 / seconds
Query Executed:select id FROM `wi` where city='Plymouth' && SIC_code='7231'DB:business_master_new
loadtime:5.198038816452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplar' limit 1
loadtime:5.1981358528137 / seconds
Query Executed:select id FROM `wi` where city='Poplar' && SIC_code='7231'DB:business_master_new
loadtime:5.1992537975311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Edwards' limit 1
loadtime:5.1993110179901 / seconds
Query Executed:select id FROM `wi` where city='Port Edwards' && SIC_code='7231'DB:business_master_new
loadtime:5.2005388736725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Washington' limit 1
loadtime:5.2006099224091 / seconds
Query Executed:select id FROM `wi` where city='Port Washington' && SIC_code='7231'DB:business_master_new
loadtime:5.2129139900208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Wing' limit 1
loadtime:5.2130010128021 / seconds
Query Executed:select id FROM `wi` where city='Port Wing' && SIC_code='7231'DB:business_master_new
loadtime:5.2139749526978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:5.2140319347382 / seconds
Query Executed:select id FROM `wi` where city='Portage' && SIC_code='7231'DB:business_master_new
loadtime:5.2291009426117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porterfield' limit 1
loadtime:5.2291929721832 / seconds
Query Executed:select id FROM `wi` where city='Porterfield' && SIC_code='7231'DB:business_master_new
loadtime:5.2302098274231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poskin' limit 1
loadtime:5.2302668094635 / seconds
Query Executed:select id FROM `wi` where city='Poskin' && SIC_code='7231'DB:business_master_new
loadtime:5.230724811554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potosi' limit 1
loadtime:5.2307798862457 / seconds
Query Executed:select id FROM `wi` where city='Potosi' && SIC_code='7231'DB:business_master_new
loadtime:5.2329649925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potter' limit 1
loadtime:5.2330358028412 / seconds
Query Executed:select id FROM `wi` where city='Potter' && SIC_code='7231'DB:business_master_new
loadtime:5.2336428165436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:5.2337110042572 / seconds
Query Executed:select id FROM `wi` where city='Pound' && SIC_code='7231'DB:business_master_new
loadtime:5.2355799674988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers Lake' limit 1
loadtime:5.2356498241425 / seconds
Query Executed:select id FROM `wi` where city='Powers Lake' && SIC_code='7231'DB:business_master_new
loadtime:5.2361948490143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poy Sippi' limit 1
loadtime:5.2362480163574 / seconds
Query Executed:select id FROM `wi` where city='Poy Sippi' && SIC_code='7231'DB:business_master_new
loadtime:5.2371869087219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poynette' limit 1
loadtime:5.2372539043427 / seconds
Query Executed:select id FROM `wi` where city='Poynette' && SIC_code='7231'DB:business_master_new
loadtime:5.2981758117676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Du Chien' limit 1
loadtime:5.2983078956604 / seconds
Query Executed:select id FROM `wi` where city='Prairie Du Chien' && SIC_code='7231'DB:business_master_new
loadtime:5.3100869655609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Du Sac' limit 1
loadtime:5.3101818561554 / seconds
Query Executed:select id FROM `wi` where city='Prairie Du Sac' && SIC_code='7231'DB:business_master_new
loadtime:5.3709969520569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Farm' limit 1
loadtime:5.371129989624 / seconds
Query Executed:select id FROM `wi` where city='Prairie Farm' && SIC_code='7231'DB:business_master_new
loadtime:5.3725309371948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prentice' limit 1
loadtime:5.3726029396057 / seconds
Query Executed:select id FROM `wi` where city='Prentice' && SIC_code='7231'DB:business_master_new
loadtime:5.3742568492889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:5.3743278980255 / seconds
Query Executed:select id FROM `wi` where city='Prescott' && SIC_code='7231'DB:business_master_new
loadtime:5.3776860237122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presque Isle' limit 1
loadtime:5.377758026123 / seconds
Query Executed:select id FROM `wi` where city='Presque Isle' && SIC_code='7231'DB:business_master_new
loadtime:5.3790788650513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:5.3791358470917 / seconds
Query Executed:select id FROM `wi` where city='Princeton' && SIC_code='7231'DB:business_master_new
loadtime:5.3820478916168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:5.3821229934692 / seconds
Query Executed:select id FROM `wi` where city='Pulaski' && SIC_code='7231'DB:business_master_new
loadtime:5.3871269226074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulcifer' limit 1
loadtime:5.3872079849243 / seconds
Query Executed:select id FROM `wi` where city='Pulcifer' && SIC_code='7231'DB:business_master_new
loadtime:5.3876619338989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Racine' limit 1
loadtime:5.3877189159393 / seconds
Query Executed:select id FROM `wi` where city='Racine' && SIC_code='7231'DB:business_master_new
loadtime:5.4457030296326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radisson' limit 1
loadtime:5.4460458755493 / seconds
Query Executed:select id FROM `wi` where city='Radisson' && SIC_code='7231'DB:business_master_new
loadtime:5.4469327926636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:5.4470188617706 / seconds
Query Executed:select id FROM `wi` where city='Randolph' && SIC_code='7231'DB:business_master_new
loadtime:5.4498038291931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Random Lake' limit 1
loadtime:5.4498779773712 / seconds
Query Executed:select id FROM `wi` where city='Random Lake' && SIC_code='7231'DB:business_master_new
loadtime:5.4523859024048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readfield' limit 1
loadtime:5.452455997467 / seconds
Query Executed:select id FROM `wi` where city='Readfield' && SIC_code='7231'DB:business_master_new
loadtime:5.4530968666077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readstown' limit 1
loadtime:5.4531638622284 / seconds
Query Executed:select id FROM `wi` where city='Readstown' && SIC_code='7231'DB:business_master_new
loadtime:5.4542000293732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redgranite' limit 1
loadtime:5.4542689323425 / seconds
Query Executed:select id FROM `wi` where city='Redgranite' && SIC_code='7231'DB:business_master_new
loadtime:5.4558568000793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsburg' limit 1
loadtime:5.4559278488159 / seconds
Query Executed:select id FROM `wi` where city='Reedsburg' && SIC_code='7231'DB:business_master_new
loadtime:5.4644989967346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsville' limit 1
loadtime:5.4645888805389 / seconds
Query Executed:select id FROM `wi` where city='Reedsville' && SIC_code='7231'DB:business_master_new
loadtime:5.4675388336182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reeseville' limit 1
loadtime:5.4676098823547 / seconds
Query Executed:select id FROM `wi` where city='Reeseville' && SIC_code='7231'DB:business_master_new
loadtime:5.4691050052643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rewey' limit 1
loadtime:5.4691779613495 / seconds
Query Executed:select id FROM `wi` where city='Rewey' && SIC_code='7231'DB:business_master_new
loadtime:5.4699149131775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhinelander' limit 1
loadtime:5.4699709415436 / seconds
Query Executed:select id FROM `wi` where city='Rhinelander' && SIC_code='7231'DB:business_master_new
loadtime:5.4906527996063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rib Lake' limit 1
loadtime:5.4907557964325 / seconds
Query Executed:select id FROM `wi` where city='Rib Lake' && SIC_code='7231'DB:business_master_new
loadtime:5.4924509525299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice Lake' limit 1
loadtime:5.4925239086151 / seconds
Query Executed:select id FROM `wi` where city='Rice Lake' && SIC_code='7231'DB:business_master_new
loadtime:5.5546967983246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:5.5548689365387 / seconds
Query Executed:select id FROM `wi` where city='Richfield' && SIC_code='7231'DB:business_master_new
loadtime:5.5581569671631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland Center' limit 1
loadtime:5.5582280158997 / seconds
Query Executed:select id FROM `wi` where city='Richland Center' && SIC_code='7231'DB:business_master_new
loadtime:5.5665500164032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:5.5666358470917 / seconds
Query Executed:select id FROM `wi` where city='Ridgeland' && SIC_code='7231'DB:business_master_new
loadtime:5.5680439472198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:5.5681178569794 / seconds
Query Executed:select id FROM `wi` where city='Ridgeway' && SIC_code='7231'DB:business_master_new
loadtime:5.5692780017853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringle' limit 1
loadtime:5.5693428516388 / seconds
Query Executed:select id FROM `wi` where city='Ringle' && SIC_code='7231'DB:business_master_new
loadtime:5.5705180168152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio' limit 1
loadtime:5.5705778598785 / seconds
Query Executed:select id FROM `wi` where city='Rio' && SIC_code='7231'DB:business_master_new
loadtime:5.5728049278259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripon' limit 1
loadtime:5.572872877121 / seconds
Query Executed:select id FROM `wi` where city='Ripon' && SIC_code='7231'DB:business_master_new
loadtime:5.5806329250336 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Falls' limit 1
loadtime:5.5807249546051 / seconds
Query Executed:select id FROM `wi` where city='River Falls' && SIC_code='7231'DB:business_master_new
loadtime:5.642776966095 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Hills' limit 1
loadtime:5.6429438591003 / seconds
Query Executed:select id FROM `wi` where city='River Hills' && SIC_code='7231'DB:business_master_new
loadtime:5.6434359550476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roberts' limit 1
loadtime:5.6434979438782 / seconds
Query Executed:select id FROM `wi` where city='Roberts' && SIC_code='7231'DB:business_master_new
loadtime:5.6455578804016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:5.6456339359283 / seconds
Query Executed:select id FROM `wi` where city='Rochester' && SIC_code='7231'DB:business_master_new
loadtime:5.6465668678284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:5.6466388702393 / seconds
Query Executed:select id FROM `wi` where city='Rock Falls' && SIC_code='7231'DB:business_master_new
loadtime:5.6471168994904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Springs' limit 1
loadtime:5.6471710205078 / seconds
Query Executed:select id FROM `wi` where city='Rock Springs' && SIC_code='7231'DB:business_master_new
loadtime:5.6481738090515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:5.6482429504395 / seconds
Query Executed:select id FROM `wi` where city='Rockland' && SIC_code='7231'DB:business_master_new
loadtime:5.6490068435669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosendale' limit 1
loadtime:5.6490747928619 / seconds
Query Executed:select id FROM `wi` where city='Rosendale' && SIC_code='7231'DB:business_master_new
loadtime:5.6506929397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:5.6507608890533 / seconds
Query Executed:select id FROM `wi` where city='Rosholt' && SIC_code='7231'DB:business_master_new
loadtime:5.6526470184326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rothschild' limit 1
loadtime:5.6527240276337 / seconds
Query Executed:select id FROM `wi` where city='Rothschild' && SIC_code='7231'DB:business_master_new
loadtime:5.655210018158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalton' limit 1
loadtime:5.6552958488464 / seconds
Query Executed:select id FROM `wi` where city='Royalton' && SIC_code='7231'DB:business_master_new
loadtime:5.6557059288025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rubicon' limit 1
loadtime:5.6557629108429 / seconds
Query Executed:select id FROM `wi` where city='Rubicon' && SIC_code='7231'DB:business_master_new
loadtime:5.6569538116455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudolph' limit 1
loadtime:5.6570069789886 / seconds
Query Executed:select id FROM `wi` where city='Rudolph' && SIC_code='7231'DB:business_master_new
loadtime:5.6584179401398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Cloud' limit 1
loadtime:5.6584877967834 / seconds
Query Executed:select id FROM `wi` where city='Saint Cloud' && SIC_code='7231'DB:business_master_new
loadtime:5.6596729755402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Croix Falls' limit 1
loadtime:5.6597418785095 / seconds
Query Executed:select id FROM `wi` where city='Saint Croix Falls' && SIC_code='7231'DB:business_master_new
loadtime:5.6645238399506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Germain' limit 1
loadtime:5.6646039485931 / seconds
Query Executed:select id FROM `wi` where city='Saint Germain' && SIC_code='7231'DB:business_master_new
loadtime:5.6674468517303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Nazianz' limit 1
loadtime:5.6675209999084 / seconds
Query Executed:select id FROM `wi` where city='Saint Nazianz' && SIC_code='7231'DB:business_master_new
loadtime:5.6684708595276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:5.6685400009155 / seconds
Query Executed:select id FROM `wi` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:5.6724078655243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Creek' limit 1
loadtime:5.6724870204926 / seconds
Query Executed:select id FROM `wi` where city='Sand Creek' && SIC_code='7231'DB:business_master_new
loadtime:5.6731448173523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarona' limit 1
loadtime:5.673211812973 / seconds
Query Executed:select id FROM `wi` where city='Sarona' && SIC_code='7231'DB:business_master_new
loadtime:5.6746008396149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sauk City' limit 1
loadtime:5.6746690273285 / seconds
Query Executed:select id FROM `wi` where city='Sauk City' && SIC_code='7231'DB:business_master_new
loadtime:5.6788449287415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saukville' limit 1
loadtime:5.678927898407 / seconds
Query Executed:select id FROM `wi` where city='Saukville' && SIC_code='7231'DB:business_master_new
loadtime:5.6826918125153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxeville' limit 1
loadtime:5.6827659606934 / seconds
Query Executed:select id FROM `wi` where city='Saxeville' && SIC_code='7231'DB:business_master_new
loadtime:5.6832599639893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxon' limit 1
loadtime:5.6833238601685 / seconds
Query Executed:select id FROM `wi` where city='Saxon' && SIC_code='7231'DB:business_master_new
loadtime:5.6840410232544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sayner' limit 1
loadtime:5.6840949058533 / seconds
Query Executed:select id FROM `wi` where city='Sayner' && SIC_code='7231'DB:business_master_new
loadtime:5.6851828098297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scandinavia' limit 1
loadtime:5.6852498054504 / seconds
Query Executed:select id FROM `wi` where city='Scandinavia' && SIC_code='7231'DB:business_master_new
loadtime:5.6863279342651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield' limit 1
loadtime:5.686381816864 / seconds
Query Executed:select id FROM `wi` where city='Schofield' && SIC_code='7231'DB:business_master_new
loadtime:5.7482528686523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:5.7484200000763 / seconds
Query Executed:select id FROM `wi` where city='Seneca' && SIC_code='7231'DB:business_master_new
loadtime:5.7491459846497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sextonville' limit 1
loadtime:5.7492158412933 / seconds
Query Executed:select id FROM `wi` where city='Sextonville' && SIC_code='7231'DB:business_master_new
loadtime:5.7497289180756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:5.7497839927673 / seconds
Query Executed:select id FROM `wi` where city='Seymour' && SIC_code='7231'DB:business_master_new
loadtime:5.7544360160828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:5.7545068264008 / seconds
Query Executed:select id FROM `wi` where city='Sharon' && SIC_code='7231'DB:business_master_new
loadtime:5.7562878131866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawano' limit 1
loadtime:5.7563579082489 / seconds
Query Executed:select id FROM `wi` where city='Shawano' && SIC_code='7231'DB:business_master_new
loadtime:5.8181848526001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheboygan' limit 1
loadtime:5.8183608055115 / seconds
Query Executed:select id FROM `wi` where city='Sheboygan' && SIC_code='7231'DB:business_master_new
loadtime:5.8538269996643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheboygan Falls' limit 1
loadtime:5.8540368080139 / seconds
Query Executed:select id FROM `wi` where city='Sheboygan Falls' && SIC_code='7231'DB:business_master_new
loadtime:5.8600058555603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:5.8601009845734 / seconds
Query Executed:select id FROM `wi` where city='Sheldon' && SIC_code='7231'DB:business_master_new
loadtime:5.861526966095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Lake' limit 1
loadtime:5.8616030216217 / seconds
Query Executed:select id FROM `wi` where city='Shell Lake' && SIC_code='7231'DB:business_master_new
loadtime:5.8644289970398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:5.8644988536835 / seconds
Query Executed:select id FROM `wi` where city='Sherwood' && SIC_code='7231'DB:business_master_new
loadtime:5.8661909103394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiocton' limit 1
loadtime:5.8662588596344 / seconds
Query Executed:select id FROM `wi` where city='Shiocton' && SIC_code='7231'DB:business_master_new
loadtime:5.8680830001831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shorewood' limit 1
loadtime:5.8681519031525 / seconds
Query Executed:select id FROM `wi` where city='Shorewood' && SIC_code='7231'DB:business_master_new
loadtime:5.8686399459839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shullsburg' limit 1
loadtime:5.8686950206757 / seconds
Query Executed:select id FROM `wi` where city='Shullsburg' && SIC_code='7231'DB:business_master_new
loadtime:5.8708488941193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:5.8709189891815 / seconds
Query Executed:select id FROM `wi` where city='Silver Lake' && SIC_code='7231'DB:business_master_new
loadtime:5.8723227977753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinsinawa' limit 1
loadtime:5.8724019527435 / seconds
Query Executed:select id FROM `wi` where city='Sinsinawa' && SIC_code='7231'DB:business_master_new
loadtime:5.8728790283203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siren' limit 1
loadtime:5.8729338645935 / seconds
Query Executed:select id FROM `wi` where city='Siren' && SIC_code='7231'DB:business_master_new
loadtime:5.9340460300446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sister Bay' limit 1
loadtime:5.9341809749603 / seconds
Query Executed:select id FROM `wi` where city='Sister Bay' && SIC_code='7231'DB:business_master_new
loadtime:5.9947838783264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slinger' limit 1
loadtime:5.9949219226837 / seconds
Query Executed:select id FROM `wi` where city='Slinger' && SIC_code='7231'DB:business_master_new
loadtime:6.0556538105011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sobieski' limit 1
loadtime:6.0557999610901 / seconds
Query Executed:select id FROM `wi` where city='Sobieski' && SIC_code='7231'DB:business_master_new
loadtime:6.0573120117188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldiers Grove' limit 1
loadtime:6.0573828220367 / seconds
Query Executed:select id FROM `wi` where city='Soldiers Grove' && SIC_code='7231'DB:business_master_new
loadtime:6.0592048168182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon Springs' limit 1
loadtime:6.0592739582062 / seconds
Query Executed:select id FROM `wi` where city='Solon Springs' && SIC_code='7231'DB:business_master_new
loadtime:6.0618078708649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:6.0618770122528 / seconds
Query Executed:select id FROM `wi` where city='Somers' && SIC_code='7231'DB:business_master_new
loadtime:6.0626618862152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:6.0627279281616 / seconds
Query Executed:select id FROM `wi` where city='Somerset' && SIC_code='7231'DB:business_master_new
loadtime:6.1233010292053 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Byron' limit 1
loadtime:6.1234459877014 / seconds
Query Executed:select id FROM `wi` where city='South Byron' && SIC_code='7231'DB:business_master_new
loadtime:6.1239337921143 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Milwaukee' limit 1
loadtime:6.1239910125732 / seconds
Query Executed:select id FROM `wi` where city='South Milwaukee' && SIC_code='7231'DB:business_master_new
loadtime:6.1349170207977 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Range' limit 1
loadtime:6.1350069046021 / seconds
Query Executed:select id FROM `wi` where city='South Range' && SIC_code='7231'DB:business_master_new
loadtime:6.136531829834 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wayne' limit 1
loadtime:6.1365909576416 / seconds
Query Executed:select id FROM `wi` where city='South Wayne' && SIC_code='7231'DB:business_master_new
loadtime:6.1381509304047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:6.1382188796997 / seconds
Query Executed:select id FROM `wi` where city='Sparta' && SIC_code='7231'DB:business_master_new
loadtime:6.1531238555908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:6.1532099246979 / seconds
Query Executed:select id FROM `wi` where city='Spencer' && SIC_code='7231'DB:business_master_new
loadtime:6.1556448936462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spooner' limit 1
loadtime:6.1557168960571 / seconds
Query Executed:select id FROM `wi` where city='Spooner' && SIC_code='7231'DB:business_master_new
loadtime:6.2169308662415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Green' limit 1
loadtime:6.2170748710632 / seconds
Query Executed:select id FROM `wi` where city='Spring Green' && SIC_code='7231'DB:business_master_new
loadtime:6.2776508331299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Valley' limit 1
loadtime:6.2777879238129 / seconds
Query Executed:select id FROM `wi` where city='Spring Valley' && SIC_code='7231'DB:business_master_new
loadtime:6.2804458141327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:6.2805159091949 / seconds
Query Executed:select id FROM `wi` where city='Springbrook' && SIC_code='7231'DB:business_master_new
loadtime:6.2815699577332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:6.2816369533539 / seconds
Query Executed:select id FROM `wi` where city='Springfield' && SIC_code='7231'DB:business_master_new
loadtime:6.2821128368378 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Cloud' limit 1
loadtime:6.2821669578552 / seconds
Query Executed:select id FROM `wi` where city='St Cloud' && SIC_code='7231'DB:business_master_new
loadtime:6.2825767993927 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Croix Falls' limit 1
loadtime:6.2826309204102 / seconds
Query Executed:select id FROM `wi` where city='St Croix Falls' && SIC_code='7231'DB:business_master_new
loadtime:6.283029794693 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:6.2830808162689 / seconds
Query Executed:select id FROM `wi` where city='St Francis' && SIC_code='7231'DB:business_master_new
loadtime:6.2834839820862 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Germain' limit 1
loadtime:6.2835359573364 / seconds
Query Executed:select id FROM `wi` where city='St Germain' && SIC_code='7231'DB:business_master_new
loadtime:6.2839388847351 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Nazianz' limit 1
loadtime:6.2839939594269 / seconds
Query Executed:select id FROM `wi` where city='St Nazianz' && SIC_code='7231'DB:business_master_new
loadtime:6.2843818664551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:6.2844429016113 / seconds
Query Executed:select id FROM `wi` where city='Stanley' && SIC_code='7231'DB:business_master_new
loadtime:6.3451178073883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Lake' limit 1
loadtime:6.3452517986298 / seconds
Query Executed:select id FROM `wi` where city='Star Lake' && SIC_code='7231'DB:business_master_new
loadtime:6.3458178043365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Prairie' limit 1
loadtime:6.3458769321442 / seconds
Query Executed:select id FROM `wi` where city='Star Prairie' && SIC_code='7231'DB:business_master_new
loadtime:6.3471670150757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stetsonville' limit 1
loadtime:6.347235918045 / seconds
Query Executed:select id FROM `wi` where city='Stetsonville' && SIC_code='7231'DB:business_master_new
loadtime:6.348522901535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steuben' limit 1
loadtime:6.3485980033875 / seconds
Query Executed:select id FROM `wi` where city='Steuben' && SIC_code='7231'DB:business_master_new
loadtime:6.3492298126221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevens Point' limit 1
loadtime:6.3492839336395 / seconds
Query Executed:select id FROM `wi` where city='Stevens Point' && SIC_code='7231'DB:business_master_new
loadtime:6.3757679462433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stitzer' limit 1
loadtime:6.3759260177612 / seconds
Query Executed:select id FROM `wi` where city='Stitzer' && SIC_code='7231'DB:business_master_new
loadtime:6.376767873764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:6.3768298625946 / seconds
Query Executed:select id FROM `wi` where city='Stockbridge' && SIC_code='7231'DB:business_master_new
loadtime:6.3776099681854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:6.3776748180389 / seconds
Query Executed:select id FROM `wi` where city='Stockholm' && SIC_code='7231'DB:business_master_new
loadtime:6.3785738945007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:6.3786280155182 / seconds
Query Executed:select id FROM `wi` where city='Stoddard' && SIC_code='7231'DB:business_master_new
loadtime:6.3803269863129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Lake' limit 1
loadtime:6.3804068565369 / seconds
Query Executed:select id FROM `wi` where city='Stone Lake' && SIC_code='7231'DB:business_master_new
loadtime:6.382171869278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:6.3822410106659 / seconds
Query Executed:select id FROM `wi` where city='Stoughton' && SIC_code='7231'DB:business_master_new
loadtime:6.3973469734192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:6.3974637985229 / seconds
Query Executed:select id FROM `wi` where city='Stratford' && SIC_code='7231'DB:business_master_new
loadtime:6.4003329277039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strum' limit 1
loadtime:6.4004240036011 / seconds
Query Executed:select id FROM `wi` where city='Strum' && SIC_code='7231'DB:business_master_new
loadtime:6.4021489620209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgeon Bay' limit 1
loadtime:6.4022209644318 / seconds
Query Executed:select id FROM `wi` where city='Sturgeon Bay' && SIC_code='7231'DB:business_master_new
loadtime:6.4223170280457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturtevant' limit 1
loadtime:6.4224219322205 / seconds
Query Executed:select id FROM `wi` where city='Sturtevant' && SIC_code='7231'DB:business_master_new
loadtime:6.4838109016418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suamico' limit 1
loadtime:6.4839549064636 / seconds
Query Executed:select id FROM `wi` where city='Suamico' && SIC_code='7231'DB:business_master_new
loadtime:6.4864068031311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:6.4864768981934 / seconds
Query Executed:select id FROM `wi` where city='Sullivan' && SIC_code='7231'DB:business_master_new
loadtime:6.4884037971497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit Lake' limit 1
loadtime:6.4884719848633 / seconds
Query Executed:select id FROM `wi` where city='Summit Lake' && SIC_code='7231'DB:business_master_new
loadtime:6.4891138076782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Prairie' limit 1
loadtime:6.48916888237 / seconds
Query Executed:select id FROM `wi` where city='Sun Prairie' && SIC_code='7231'DB:business_master_new
loadtime:6.5089099407196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:6.5090398788452 / seconds
Query Executed:select id FROM `wi` where city='Superior' && SIC_code='7231'DB:business_master_new
loadtime:6.5311889648438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suring' limit 1
loadtime:6.5313329696655 / seconds
Query Executed:select id FROM `wi` where city='Suring' && SIC_code='7231'DB:business_master_new
loadtime:6.5335609912872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:6.5336458683014 / seconds
Query Executed:select id FROM `wi` where city='Sussex' && SIC_code='7231'DB:business_master_new
loadtime:6.5450878143311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:6.5451710224152 / seconds
Query Executed:select id FROM `wi` where city='Taylor' && SIC_code='7231'DB:business_master_new
loadtime:6.5462629795074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Theresa' limit 1
loadtime:6.5463318824768 / seconds
Query Executed:select id FROM `wi` where city='Theresa' && SIC_code='7231'DB:business_master_new
loadtime:6.5476298332214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thiensville' limit 1
loadtime:6.5476968288422 / seconds
Query Executed:select id FROM `wi` where city='Thiensville' && SIC_code='7231'DB:business_master_new
loadtime:6.5488088130951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorp' limit 1
loadtime:6.5488739013672 / seconds
Query Executed:select id FROM `wi` where city='Thorp' && SIC_code='7231'DB:business_master_new
loadtime:6.6099598407745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Lakes' limit 1
loadtime:6.6101109981537 / seconds
Query Executed:select id FROM `wi` where city='Three Lakes' && SIC_code='7231'DB:business_master_new
loadtime:6.6129670143127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigerton' limit 1
loadtime:6.6130368709564 / seconds
Query Executed:select id FROM `wi` where city='Tigerton' && SIC_code='7231'DB:business_master_new
loadtime:6.6147909164429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilleda' limit 1
loadtime:6.6148648262024 / seconds
Query Executed:select id FROM `wi` where city='Tilleda' && SIC_code='7231'DB:business_master_new
loadtime:6.6154499053955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipler' limit 1
loadtime:6.6155049800873 / seconds
Query Executed:select id FROM `wi` where city='Tipler' && SIC_code='7231'DB:business_master_new
loadtime:6.6158969402313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tisch Mills' limit 1
loadtime:6.6159508228302 / seconds
Query Executed:select id FROM `wi` where city='Tisch Mills' && SIC_code='7231'DB:business_master_new
loadtime:6.6164319515228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tomah' limit 1
loadtime:6.6164839267731 / seconds
Query Executed:select id FROM `wi` where city='Tomah' && SIC_code='7231'DB:business_master_new
loadtime:6.6308360099792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tomahawk' limit 1
loadtime:6.6309378147125 / seconds
Query Executed:select id FROM `wi` where city='Tomahawk' && SIC_code='7231'DB:business_master_new
loadtime:6.6923189163208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tony' limit 1
loadtime:6.6924858093262 / seconds
Query Executed:select id FROM `wi` where city='Tony' && SIC_code='7231'DB:business_master_new
loadtime:6.6932828426361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:6.6933529376984 / seconds
Query Executed:select id FROM `wi` where city='Townsend' && SIC_code='7231'DB:business_master_new
loadtime:6.6945118904114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trego' limit 1
loadtime:6.6945819854736 / seconds
Query Executed:select id FROM `wi` where city='Trego' && SIC_code='7231'DB:business_master_new
loadtime:6.6961607933044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trempealeau' limit 1
loadtime:6.6962308883667 / seconds
Query Executed:select id FROM `wi` where city='Trempealeau' && SIC_code='7231'DB:business_master_new
loadtime:6.6981868743896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevor' limit 1
loadtime:6.6982598304749 / seconds
Query Executed:select id FROM `wi` where city='Trevor' && SIC_code='7231'DB:business_master_new
loadtime:6.7001299858093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:6.7001979351044 / seconds
Query Executed:select id FROM `wi` where city='Tripoli' && SIC_code='7231'DB:business_master_new
loadtime:6.7007977962494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunnel City' limit 1
loadtime:6.7008519172668 / seconds
Query Executed:select id FROM `wi` where city='Tunnel City' && SIC_code='7231'DB:business_master_new
loadtime:6.701299905777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turtle Lake' limit 1
loadtime:6.7013518810272 / seconds
Query Executed:select id FROM `wi` where city='Turtle Lake' && SIC_code='7231'DB:business_master_new
loadtime:6.7038109302521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lakes' limit 1
loadtime:6.7038848400116 / seconds
Query Executed:select id FROM `wi` where city='Twin Lakes' && SIC_code='7231'DB:business_master_new
loadtime:6.7077720165253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Two Rivers' limit 1
loadtime:6.7078528404236 / seconds
Query Executed:select id FROM `wi` where city='Two Rivers' && SIC_code='7231'DB:business_master_new
loadtime:6.7693428993225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:6.7695119380951 / seconds
Query Executed:select id FROM `wi` where city='Union Center' && SIC_code='7231'DB:business_master_new
loadtime:6.7702507972717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:6.770308971405 / seconds
Query Executed:select id FROM `wi` where city='Union Grove' && SIC_code='7231'DB:business_master_new
loadtime:6.8313097953796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unity' limit 1
loadtime:6.8314638137817 / seconds
Query Executed:select id FROM `wi` where city='Unity' && SIC_code='7231'DB:business_master_new
loadtime:6.8326418399811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upson' limit 1
loadtime:6.8326988220215 / seconds
Query Executed:select id FROM `wi` where city='Upson' && SIC_code='7231'DB:business_master_new
loadtime:6.833221912384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valders' limit 1
loadtime:6.8332738876343 / seconds
Query Executed:select id FROM `wi` where city='Valders' && SIC_code='7231'DB:business_master_new
loadtime:6.8352818489075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Dyne' limit 1
loadtime:6.8353509902954 / seconds
Query Executed:select id FROM `wi` where city='Van Dyne' && SIC_code='7231'DB:business_master_new
loadtime:6.836709022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:6.8367779254913 / seconds
Query Executed:select id FROM `wi` where city='Verona' && SIC_code='7231'DB:business_master_new
loadtime:6.8513200283051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesper' limit 1
loadtime:6.85142993927 / seconds
Query Executed:select id FROM `wi` where city='Vesper' && SIC_code='7231'DB:business_master_new
loadtime:6.8527708053589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:6.8528418540955 / seconds
Query Executed:select id FROM `wi` where city='Viola' && SIC_code='7231'DB:business_master_new
loadtime:6.8544659614563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viroqua' limit 1
loadtime:6.8545348644257 / seconds
Query Executed:select id FROM `wi` where city='Viroqua' && SIC_code='7231'DB:business_master_new
loadtime:6.9156889915466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wabeno' limit 1
loadtime:6.9158279895782 / seconds
Query Executed:select id FROM `wi` where city='Wabeno' && SIC_code='7231'DB:business_master_new
loadtime:6.9173679351807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldo' limit 1
loadtime:6.917445898056 / seconds
Query Executed:select id FROM `wi` where city='Waldo' && SIC_code='7231'DB:business_master_new
loadtime:6.9185829162598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:6.9186389446259 / seconds
Query Executed:select id FROM `wi` where city='Wales' && SIC_code='7231'DB:business_master_new
loadtime:6.9210369586945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walworth' limit 1
loadtime:6.9211299419403 / seconds
Query Executed:select id FROM `wi` where city='Walworth' && SIC_code='7231'DB:business_master_new
loadtime:6.924623966217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrens' limit 1
loadtime:6.9247009754181 / seconds
Query Executed:select id FROM `wi` where city='Warrens' && SIC_code='7231'DB:business_master_new
loadtime:6.9264788627625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wascott' limit 1
loadtime:6.9265549182892 / seconds
Query Executed:select id FROM `wi` where city='Wascott' && SIC_code='7231'DB:business_master_new
loadtime:6.9270370006561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:6.9270930290222 / seconds
Query Executed:select id FROM `wi` where city='Washburn' && SIC_code='7231'DB:business_master_new
loadtime:6.9302988052368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Island' limit 1
loadtime:6.9303829669952 / seconds
Query Executed:select id FROM `wi` where city='Washington Island' && SIC_code='7231'DB:business_master_new
loadtime:6.931923866272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Isle' limit 1
loadtime:6.9319939613342 / seconds
Query Executed:select id FROM `wi` where city='Washington Isle' && SIC_code='7231'DB:business_master_new
loadtime:6.9324119091034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:6.9324669837952 / seconds
Query Executed:select id FROM `wi` where city='Waterford' && SIC_code='7231'DB:business_master_new
loadtime:6.9453549385071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:6.9454588890076 / seconds
Query Executed:select id FROM `wi` where city='Waterloo' && SIC_code='7231'DB:business_master_new
loadtime:6.9485399723053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:6.9486138820648 / seconds
Query Executed:select id FROM `wi` where city='Watertown' && SIC_code='7231'DB:business_master_new
loadtime:6.9684908390045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubeka' limit 1
loadtime:6.9686069488525 / seconds
Query Executed:select id FROM `wi` where city='Waubeka' && SIC_code='7231'DB:business_master_new
loadtime:6.9690389633179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukau' limit 1
loadtime:6.9690959453583 / seconds
Query Executed:select id FROM `wi` where city='Waukau' && SIC_code='7231'DB:business_master_new
loadtime:6.9696419239044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukesha' limit 1
loadtime:6.9696969985962 / seconds
Query Executed:select id FROM `wi` where city='Waukesha' && SIC_code='7231'DB:business_master_new
loadtime:7.0284509658813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waumandee' limit 1
loadtime:7.0287299156189 / seconds
Query Executed:select id FROM `wi` where city='Waumandee' && SIC_code='7231'DB:business_master_new
loadtime:7.0291860103607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waunakee' limit 1
loadtime:7.0292530059814 / seconds
Query Executed:select id FROM `wi` where city='Waunakee' && SIC_code='7231'DB:business_master_new
loadtime:7.0427348613739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waupaca' limit 1
loadtime:7.0428199768066 / seconds
Query Executed:select id FROM `wi` where city='Waupaca' && SIC_code='7231'DB:business_master_new
loadtime:7.0578110218048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waupun' limit 1
loadtime:7.0578989982605 / seconds
Query Executed:select id FROM `wi` where city='Waupun' && SIC_code='7231'DB:business_master_new
loadtime:7.1194708347321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wausau' limit 1
loadtime:7.119619846344 / seconds
Query Executed:select id FROM `wi` where city='Wausau' && SIC_code='7231'DB:business_master_new
loadtime:7.1593189239502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wausaukee' limit 1
loadtime:7.159551858902 / seconds
Query Executed:select id FROM `wi` where city='Wausaukee' && SIC_code='7231'DB:business_master_new
loadtime:7.1615719795227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wautoma' limit 1
loadtime:7.1616508960724 / seconds
Query Executed:select id FROM `wi` where city='Wautoma' && SIC_code='7231'DB:business_master_new
loadtime:7.223014831543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauwatosa' limit 1
loadtime:7.2231688499451 / seconds
Query Executed:select id FROM `wi` where city='Wauwatosa' && SIC_code='7231'DB:business_master_new
loadtime:7.2238399982452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauzeka' limit 1
loadtime:7.22389793396 / seconds
Query Executed:select id FROM `wi` where city='Wauzeka' && SIC_code='7231'DB:business_master_new
loadtime:7.2250308990479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb Lake' limit 1
loadtime:7.2251029014587 / seconds
Query Executed:select id FROM `wi` where city='Webb Lake' && SIC_code='7231'DB:business_master_new
loadtime:7.2255120277405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:7.2255840301514 / seconds
Query Executed:select id FROM `wi` where city='Webster' && SIC_code='7231'DB:business_master_new
loadtime:7.2287700176239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:7.2288389205933 / seconds
Query Executed:select id FROM `wi` where city='Wentworth' && SIC_code='7231'DB:business_master_new
loadtime:7.2292199134827 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Allis' limit 1
loadtime:7.2292737960815 / seconds
Query Executed:select id FROM `wi` where city='West Allis' && SIC_code='7231'DB:business_master_new
loadtime:7.2298328876495 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:7.2298858165741 / seconds
Query Executed:select id FROM `wi` where city='West Bend' && SIC_code='7231'DB:business_master_new
loadtime:7.2584989070892 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Salem' limit 1
loadtime:7.2586908340454 / seconds
Query Executed:select id FROM `wi` where city='West Salem' && SIC_code='7231'DB:business_master_new
loadtime:7.31977891922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westboro' limit 1
loadtime:7.3199319839478 / seconds
Query Executed:select id FROM `wi` where city='Westboro' && SIC_code='7231'DB:business_master_new
loadtime:7.3207998275757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westby' limit 1
loadtime:7.3208668231964 / seconds
Query Executed:select id FROM `wi` where city='Westby' && SIC_code='7231'DB:business_master_new
loadtime:7.3245959281921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:7.3246669769287 / seconds
Query Executed:select id FROM `wi` where city='Westfield' && SIC_code='7231'DB:business_master_new
loadtime:7.3273339271545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:7.3274149894714 / seconds
Query Executed:select id FROM `wi` where city='Weston' && SIC_code='7231'DB:business_master_new
loadtime:7.3278439044952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:7.3278980255127 / seconds
Query Executed:select id FROM `wi` where city='Westport' && SIC_code='7231'DB:business_master_new
loadtime:7.3282828330994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyauwega' limit 1
loadtime:7.3283360004425 / seconds
Query Executed:select id FROM `wi` where city='Weyauwega' && SIC_code='7231'DB:business_master_new
loadtime:7.331563949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyerhaeuser' limit 1
loadtime:7.3316349983215 / seconds
Query Executed:select id FROM `wi` where city='Weyerhaeuser' && SIC_code='7231'DB:business_master_new
loadtime:7.3328278064728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:7.3328948020935 / seconds
Query Executed:select id FROM `wi` where city='Wheeler' && SIC_code='7231'DB:business_master_new
loadtime:7.3338689804077 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:7.3339378833771 / seconds
Query Executed:select id FROM `wi` where city='White Lake' && SIC_code='7231'DB:business_master_new
loadtime:7.3352119922638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehall' limit 1
loadtime:7.3352789878845 / seconds
Query Executed:select id FROM `wi` where city='Whitehall' && SIC_code='7231'DB:business_master_new
loadtime:7.3379948139191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitelaw' limit 1
loadtime:7.3380708694458 / seconds
Query Executed:select id FROM `wi` where city='Whitelaw' && SIC_code='7231'DB:business_master_new
loadtime:7.3394749164581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewater' limit 1
loadtime:7.3395488262177 / seconds
Query Executed:select id FROM `wi` where city='Whitewater' && SIC_code='7231'DB:business_master_new
loadtime:7.3520638942719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wild Rose' limit 1
loadtime:7.3521540164948 / seconds
Query Executed:select id FROM `wi` where city='Wild Rose' && SIC_code='7231'DB:business_master_new
loadtime:7.3546068668365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:7.3546829223633 / seconds
Query Executed:select id FROM `wi` where city='Willard' && SIC_code='7231'DB:business_master_new
loadtime:7.3556189537048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams Bay' limit 1
loadtime:7.3556869029999 / seconds
Query Executed:select id FROM `wi` where city='Williams Bay' && SIC_code='7231'DB:business_master_new
loadtime:7.3581428527832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:7.3582119941711 / seconds
Query Executed:select id FROM `wi` where city='Wilmot' && SIC_code='7231'DB:business_master_new
loadtime:7.3592128753662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:7.359267950058 / seconds
Query Executed:select id FROM `wi` where city='Wilson' && SIC_code='7231'DB:business_master_new
loadtime:7.3602728843689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:7.3603258132935 / seconds
Query Executed:select id FROM `wi` where city='Wilton' && SIC_code='7231'DB:business_master_new
loadtime:7.3616199493408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:7.3616869449615 / seconds
Query Executed:select id FROM `wi` where city='Winchester' && SIC_code='7231'DB:business_master_new
loadtime:7.3621950149536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wind Lake' limit 1
loadtime:7.3622598648071 / seconds
Query Executed:select id FROM `wi` where city='Wind Lake' && SIC_code='7231'DB:business_master_new
loadtime:7.3627638816833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:7.3628189563751 / seconds
Query Executed:select id FROM `wi` where city='Windsor' && SIC_code='7231'DB:business_master_new
loadtime:7.3644669055939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnebago' limit 1
loadtime:7.3645329475403 / seconds
Query Executed:select id FROM `wi` where city='Winnebago' && SIC_code='7231'DB:business_master_new
loadtime:7.3652229309082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winneconne' limit 1
loadtime:7.3652758598328 / seconds
Query Executed:select id FROM `wi` where city='Winneconne' && SIC_code='7231'DB:business_master_new
loadtime:7.3683269023895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winter' limit 1
loadtime:7.3684148788452 / seconds
Query Executed:select id FROM `wi` where city='Winter' && SIC_code='7231'DB:business_master_new
loadtime:7.3704679012299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wisconsin Dells' limit 1
loadtime:7.3705480098724 / seconds
Query Executed:select id FROM `wi` where city='Wisconsin Dells' && SIC_code='7231'DB:business_master_new
loadtime:7.3858189582825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wisconsin Rapids' limit 1
loadtime:7.3859059810638 / seconds
Query Executed:select id FROM `wi` where city='Wisconsin Rapids' && SIC_code='7231'DB:business_master_new
loadtime:7.4116139411926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withee' limit 1
loadtime:7.4117670059204 / seconds
Query Executed:select id FROM `wi` where city='Withee' && SIC_code='7231'DB:business_master_new
loadtime:7.4135749340057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittenberg' limit 1
loadtime:7.4136478900909 / seconds
Query Executed:select id FROM `wi` where city='Wittenberg' && SIC_code='7231'DB:business_master_new
loadtime:7.4165019989014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonewoc' limit 1
loadtime:7.4165799617767 / seconds
Query Executed:select id FROM `wi` where city='Wonewoc' && SIC_code='7231'DB:business_master_new
loadtime:7.4183189868927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:7.4183969497681 / seconds
Query Executed:select id FROM `wi` where city='Woodford' && SIC_code='7231'DB:business_master_new
loadtime:7.4188838005066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:7.418937921524 / seconds
Query Executed:select id FROM `wi` where city='Woodland' && SIC_code='7231'DB:business_master_new
loadtime:7.4194259643555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodman' limit 1
loadtime:7.4194808006287 / seconds
Query Executed:select id FROM `wi` where city='Woodman' && SIC_code='7231'DB:business_master_new
loadtime:7.4200549125671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:7.4201078414917 / seconds
Query Executed:select id FROM `wi` where city='Woodruff' && SIC_code='7231'DB:business_master_new
loadtime:7.4297800064087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:7.429860830307 / seconds
Query Executed:select id FROM `wi` where city='Woodville' && SIC_code='7231'DB:business_master_new
loadtime:7.4362809658051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodworth' limit 1
loadtime:7.4363529682159 / seconds
Query Executed:select id FROM `wi` where city='Woodworth' && SIC_code='7231'DB:business_master_new
loadtime:7.4368009567261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightstown' limit 1
loadtime:7.436854839325 / seconds
Query Executed:select id FROM `wi` where city='Wrightstown' && SIC_code='7231'DB:business_master_new
loadtime:7.4429159164429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyeville' limit 1
loadtime:7.4429898262024 / seconds
Query Executed:select id FROM `wi` where city='Wyeville' && SIC_code='7231'DB:business_master_new
loadtime:7.4434490203857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyocena' limit 1
loadtime:7.4435038566589 / seconds
Query Executed:select id FROM `wi` where city='Wyocena' && SIC_code='7231'DB:business_master_new
loadtime:7.5011019706726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuba' limit 1
loadtime:7.5012278556824 / seconds
Query Executed:select id FROM `wi` where city='Yuba' && SIC_code='7231'DB:business_master_new
loadtime:7.5017077922821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zachow' limit 1
loadtime:7.5017650127411 / seconds
Query Executed:select id FROM `wi` where city='Zachow' && SIC_code='7231'DB:business_master_new
loadtime:7.5021779537201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zenda' limit 1
loadtime:7.5022299289703 / seconds
Query Executed:select id FROM `wi` where city='Zenda' && SIC_code='7231'DB:business_master_new
loadtime:7.5600378513336 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:7.560231924057 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:7.5607738494873 / seconds
Operation template executed (chunk cache operation)
loadtime:7.5609359741211 / seconds
template override:Default
loadtime:7.560977935791 / 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:7.5622689723969 / seconds
Template Constructed, Array Rows:49
loadtime:7.5628437995911 / seconds
TOTAL EXECUTION TIME: 7.56238
loadtime:7.5670897960663 / 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] => beauty-shops [stateURLid] => wisconsin )


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