Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.6069107055664E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018420219421387 / seconds
host not found setting manual db connection
loadtime:0.0096280574798584 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0098440647125244 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010048151016235 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010112047195435 / seconds
zipcode:
loadtime:0.010140180587769 / seconds
Query Executed:select * from search_referrer where page_hash='99b00e6bc914ec1cddabd1733d34e9be' limit 10 DB:ezrox_toadli
loadtime:0.010387182235718 / seconds
Operation header executed (non global)
loadtime:0.010416030883789 / seconds
Operation leaderboard executed (non global)
loadtime:0.010468006134033 / seconds
Operation square executed (non global)
loadtime:0.010497093200684 / seconds
Operation square_bottom executed (non global)
loadtime:0.010524988174438 / seconds
Operation smallsquare executed (non global)
loadtime:0.01055121421814 / seconds
Operation headeradright executed (non global)
loadtime:0.010576009750366 / seconds
Operation google_analytics executed (non global)
loadtime:0.010600090026855 / seconds
Operation topstories executed (non global)
loadtime:0.010625123977661 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0106520652771 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010677099227905 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010909080505371 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011076211929321 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01111102104187 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011171102523804 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011229991912842 / seconds
Template key: archive_menu pushed
loadtime:0.011240005493164 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011254072189331 / seconds
Template key: get_gravatar pushed
loadtime:0.011260986328125 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011270046234131 / seconds
*10)-10)+1 | start:0
loadtime:0.011311054229736 / seconds
Query loaded from cache:select * from categories where cat_URLid='grocery-stores'
loadtime:0.011353015899658 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wisconsin'
loadtime:0.011399030685425 / seconds
DB connected to localhost business_master_new
loadtime:0.011627197265625 / seconds
Query Executed:select * from `wi_catmap` where sic='5411' order by city ascDB:business_master_new
loadtime:0.041303157806396 / seconds
Query stored in cache : _QUERY_www.toadli.comab52c7d6270f5bb51dff764682cef100
loadtime:0.044604063034058 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wisconsin'
loadtime:0.044687986373901 / seconds
Query Executed:select sum(totalcount) as totalsum from `wi_catmap` where sic='5411'DB:business_master_new
loadtime:0.048895120620728 / seconds
Query stored in cache : _QUERY_www.toadli.com920429c6e7dd81a5fefc6e4bc238a059
loadtime:0.048933029174805 / seconds
820 / 11
loadtime:0.048995018005371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbotsford' limit 1
loadtime:0.049061059951782 / seconds
Query Executed:select id FROM `wi` where city='Abbotsford' && SIC_code='5411'DB:business_master_new
loadtime:0.054419994354248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abrams' limit 1
loadtime:0.05449914932251 / seconds
Query Executed:select id FROM `wi` where city='Abrams' && SIC_code='5411'DB:business_master_new
loadtime:0.056335210800171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.056408166885376 / seconds
Query Executed:select id FROM `wi` where city='Adams' && SIC_code='5411'DB:business_master_new
loadtime:0.059068202972412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adell' limit 1
loadtime:0.059140205383301 / seconds
Query Executed:select id FROM `wi` where city='Adell' && SIC_code='5411'DB:business_master_new
loadtime:0.060600996017456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.060656070709229 / seconds
Query Executed:select id FROM `wi` where city='Afton' && SIC_code='5411'DB:business_master_new
loadtime:0.061160087585449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.061212062835693 / seconds
Query Executed:select id FROM `wi` where city='Albany' && SIC_code='5411'DB:business_master_new
loadtime:0.062905073165894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algoma' limit 1
loadtime:0.062973022460938 / seconds
Query Executed:select id FROM `wi` where city='Algoma' && SIC_code='5411'DB:business_master_new
loadtime:0.066915035247803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenton' limit 1
loadtime:0.066989183425903 / seconds
Query Executed:select id FROM `wi` where city='Allenton' && SIC_code='5411'DB:business_master_new
loadtime:0.068968057632446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allouez' limit 1
loadtime:0.069038152694702 / seconds
Query Executed:select id FROM `wi` where city='Allouez' && SIC_code='5411'DB:business_master_new
loadtime:0.069433212280273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.06948709487915 / seconds
Query Executed:select id FROM `wi` where city='Alma' && SIC_code='5411'DB:business_master_new
loadtime:0.072025060653687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma Center' limit 1
loadtime:0.072094202041626 / seconds
Query Executed:select id FROM `wi` where city='Alma Center' && SIC_code='5411'DB:business_master_new
loadtime:0.073283195495605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almena' limit 1
loadtime:0.073354005813599 / seconds
Query Executed:select id FROM `wi` where city='Almena' && SIC_code='5411'DB:business_master_new
loadtime:0.074850082397461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almond' limit 1
loadtime:0.074918985366821 / seconds
Query Executed:select id FROM `wi` where city='Almond' && SIC_code='5411'DB:business_master_new
loadtime:0.076368093490601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.076450109481812 / seconds
Query Executed:select id FROM `wi` where city='Altoona' && SIC_code='5411'DB:business_master_new
loadtime:0.080275058746338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amberg' limit 1
loadtime:0.080347061157227 / seconds
Query Executed:select id FROM `wi` where city='Amberg' && SIC_code='5411'DB:business_master_new
loadtime:0.081110000610352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amery' limit 1
loadtime:0.081165075302124 / seconds
Query Executed:select id FROM `wi` where city='Amery' && SIC_code='5411'DB:business_master_new
loadtime:0.087042093276978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.087122201919556 / seconds
Query Executed:select id FROM `wi` where city='Amherst' && SIC_code='5411'DB:business_master_new
loadtime:0.089790105819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst Junction' limit 1
loadtime:0.089862108230591 / seconds
Query Executed:select id FROM `wi` where city='Amherst Junction' && SIC_code='5411'DB:business_master_new
loadtime:0.091305017471313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aniwa' limit 1
loadtime:0.091360092163086 / seconds
Query Executed:select id FROM `wi` where city='Aniwa' && SIC_code='5411'DB:business_master_new
loadtime:0.09237003326416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antigo' limit 1
loadtime:0.09244704246521 / seconds
Query Executed:select id FROM `wi` where city='Antigo' && SIC_code='5411'DB:business_master_new
loadtime:0.10808801651001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appleton' limit 1
loadtime:0.10817313194275 / seconds
Query Executed:select id FROM `wi` where city='Appleton' && SIC_code='5411'DB:business_master_new
loadtime:0.17300701141357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.17325615882874 / seconds
Query Executed:select id FROM `wi` where city='Arcadia' && SIC_code='5411'DB:business_master_new
loadtime:0.17696905136108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arena' limit 1
loadtime:0.17705202102661 / seconds
Query Executed:select id FROM `wi` where city='Arena' && SIC_code='5411'DB:business_master_new
loadtime:0.17842316627502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argonne' limit 1
loadtime:0.17849016189575 / seconds
Query Executed:select id FROM `wi` where city='Argonne' && SIC_code='5411'DB:business_master_new
loadtime:0.17966508865356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.17973709106445 / seconds
Query Executed:select id FROM `wi` where city='Argyle' && SIC_code='5411'DB:business_master_new
loadtime:0.18154406547546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkansaw' limit 1
loadtime:0.18161106109619 / seconds
Query Executed:select id FROM `wi` where city='Arkansaw' && SIC_code='5411'DB:business_master_new
loadtime:0.18276119232178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkdale' limit 1
loadtime:0.18281507492065 / seconds
Query Executed:select id FROM `wi` where city='Arkdale' && SIC_code='5411'DB:business_master_new
loadtime:0.18408608436584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.18415403366089 / seconds
Query Executed:select id FROM `wi` where city='Arlington' && SIC_code='5411'DB:business_master_new
loadtime:0.18545913696289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armstrong Creek' limit 1
loadtime:0.18552899360657 / seconds
Query Executed:select id FROM `wi` where city='Armstrong Creek' && SIC_code='5411'DB:business_master_new
loadtime:0.18634414672852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arpin' limit 1
loadtime:0.18641805648804 / seconds
Query Executed:select id FROM `wi` where city='Arpin' && SIC_code='5411'DB:business_master_new
loadtime:0.1877121925354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashippun' limit 1
loadtime:0.18777918815613 / seconds
Query Executed:select id FROM `wi` where city='Ashippun' && SIC_code='5411'DB:business_master_new
loadtime:0.1885871887207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.18865513801575 / seconds
Query Executed:select id FROM `wi` where city='Ashland' && SIC_code='5411'DB:business_master_new
loadtime:0.20018911361694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athelstane' limit 1
loadtime:0.20028018951416 / seconds
Query Executed:select id FROM `wi` where city='Athelstane' && SIC_code='5411'DB:business_master_new
loadtime:0.20122814178467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.20130920410156 / seconds
Query Executed:select id FROM `wi` where city='Athens' && SIC_code='5411'DB:business_master_new
loadtime:0.20444011688232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.20451402664185 / seconds
Query Executed:select id FROM `wi` where city='Auburndale' && SIC_code='5411'DB:business_master_new
loadtime:0.2061460018158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.20621514320374 / seconds
Query Executed:select id FROM `wi` where city='Augusta' && SIC_code='5411'DB:business_master_new
loadtime:0.20848703384399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.20855712890625 / seconds
Query Executed:select id FROM `wi` where city='Avalon' && SIC_code='5411'DB:business_master_new
loadtime:0.2092080116272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.20927119255066 / seconds
Query Executed:select id FROM `wi` where city='Avoca' && SIC_code='5411'DB:business_master_new
loadtime:0.21017503738403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babcock' limit 1
loadtime:0.21025204658508 / seconds
Query Executed:select id FROM `wi` where city='Babcock' && SIC_code='5411'DB:business_master_new
loadtime:0.21083521842957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.21088910102844 / seconds
Query Executed:select id FROM `wi` where city='Bagley' && SIC_code='5411'DB:business_master_new
loadtime:0.21184420585632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Harbor' limit 1
loadtime:0.21191120147705 / seconds
Query Executed:select id FROM `wi` where city='Baileys Harbor' && SIC_code='5411'DB:business_master_new
loadtime:0.21389102935791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.21396207809448 / seconds
Query Executed:select id FROM `wi` where city='Baldwin' && SIC_code='5411'DB:business_master_new
loadtime:0.2209620475769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam Lake' limit 1
loadtime:0.22103905677795 / seconds
Query Executed:select id FROM `wi` where city='Balsam Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.22349309921265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.22356605529785 / seconds
Query Executed:select id FROM `wi` where city='Bancroft' && SIC_code='5411'DB:business_master_new
loadtime:0.22481203079224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bangor' limit 1
loadtime:0.2248911857605 / seconds
Query Executed:select id FROM `wi` where city='Bangor' && SIC_code='5411'DB:business_master_new
loadtime:0.22694706916809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baraboo' limit 1
loadtime:0.22701811790466 / seconds
Query Executed:select id FROM `wi` where city='Baraboo' && SIC_code='5411'DB:business_master_new
loadtime:0.24324202537537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes' limit 1
loadtime:0.24333715438843 / seconds
Query Executed:select id FROM `wi` where city='Barnes' && SIC_code='5411'DB:business_master_new
loadtime:0.24380111694336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barneveld' limit 1
loadtime:0.24385714530945 / seconds
Query Executed:select id FROM `wi` where city='Barneveld' && SIC_code='5411'DB:business_master_new
loadtime:0.2455141544342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barron' limit 1
loadtime:0.24558520317078 / seconds
Query Executed:select id FROM `wi` where city='Barron' && SIC_code='5411'DB:business_master_new
loadtime:0.25222706794739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barronett' limit 1
loadtime:0.25231003761292 / seconds
Query Executed:select id FROM `wi` where city='Barronett' && SIC_code='5411'DB:business_master_new
loadtime:0.25308418273926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.25314021110535 / seconds
Query Executed:select id FROM `wi` where city='Bassett' && SIC_code='5411'DB:business_master_new
loadtime:0.25368213653564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.25373601913452 / seconds
Query Executed:select id FROM `wi` where city='Bay City' && SIC_code='5411'DB:business_master_new
loadtime:0.2548291683197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayfield' limit 1
loadtime:0.25489711761475 / seconds
Query Executed:select id FROM `wi` where city='Bayfield' && SIC_code='5411'DB:business_master_new
loadtime:0.28747415542603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.28757119178772 / seconds
Query Executed:select id FROM `wi` where city='Bear Creek' && SIC_code='5411'DB:business_master_new
loadtime:0.28864407539368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.28871417045593 / seconds
Query Executed:select id FROM `wi` where city='Beaver' && SIC_code='5411'DB:business_master_new
loadtime:0.2891411781311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver Dam' limit 1
loadtime:0.28919506072998 / seconds
Query Executed:select id FROM `wi` where city='Beaver Dam' && SIC_code='5411'DB:business_master_new
loadtime:0.30431318283081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beetown' limit 1
loadtime:0.30439805984497 / seconds
Query Executed:select id FROM `wi` where city='Beetown' && SIC_code='5411'DB:business_master_new
loadtime:0.3049840927124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beldenville' limit 1
loadtime:0.30505108833313 / seconds
Query Executed:select id FROM `wi` where city='Beldenville' && SIC_code='5411'DB:business_master_new
loadtime:0.30604910850525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belgium' limit 1
loadtime:0.30610418319702 / seconds
Query Executed:select id FROM `wi` where city='Belgium' && SIC_code='5411'DB:business_master_new
loadtime:0.30818510055542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.30826306343079 / seconds
Query Executed:select id FROM `wi` where city='Belleville' && SIC_code='5411'DB:business_master_new
loadtime:0.31153202056885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.31161117553711 / seconds
Query Executed:select id FROM `wi` where city='Belmont' && SIC_code='5411'DB:business_master_new
loadtime:0.31311416625977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beloit' limit 1
loadtime:0.31318211555481 / seconds
Query Executed:select id FROM `wi` where city='Beloit' && SIC_code='5411'DB:business_master_new
loadtime:0.33647799491882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benet Lake' limit 1
loadtime:0.33660006523132 / seconds
Query Executed:select id FROM `wi` where city='Benet Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.33706521987915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.33712315559387 / seconds
Query Executed:select id FROM `wi` where city='Bennett' && SIC_code='5411'DB:business_master_new
loadtime:0.33755421638489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benoit' limit 1
loadtime:0.33760714530945 / seconds
Query Executed:select id FROM `wi` where city='Benoit' && SIC_code='5411'DB:business_master_new
loadtime:0.33807611465454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.33814215660095 / seconds
Query Executed:select id FROM `wi` where city='Benton' && SIC_code='5411'DB:business_master_new
loadtime:0.33941912651062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.33948612213135 / seconds
Query Executed:select id FROM `wi` where city='Berlin' && SIC_code='5411'DB:business_master_new
loadtime:0.3495831489563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bend' limit 1
loadtime:0.34967803955078 / seconds
Query Executed:select id FROM `wi` where city='Big Bend' && SIC_code='5411'DB:business_master_new
loadtime:0.35297918319702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Falls' limit 1
loadtime:0.35304999351501 / seconds
Query Executed:select id FROM `wi` where city='Big Falls' && SIC_code='5411'DB:business_master_new
loadtime:0.35350298881531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchwood' limit 1
loadtime:0.3535590171814 / seconds
Query Executed:select id FROM `wi` where city='Birchwood' && SIC_code='5411'DB:business_master_new
loadtime:0.35552310943604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birnamwood' limit 1
loadtime:0.35559606552124 / seconds
Query Executed:select id FROM `wi` where city='Birnamwood' && SIC_code='5411'DB:business_master_new
loadtime:0.35748720169067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Creek' limit 1
loadtime:0.35755610466003 / seconds
Query Executed:select id FROM `wi` where city='Black Creek' && SIC_code='5411'DB:business_master_new
loadtime:0.36031103134155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Earth' limit 1
loadtime:0.36038398742676 / seconds
Query Executed:select id FROM `wi` where city='Black Earth' && SIC_code='5411'DB:business_master_new
loadtime:0.36247301101685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River Falls' limit 1
loadtime:0.36254501342773 / seconds
Query Executed:select id FROM `wi` where city='Black River Falls' && SIC_code='5411'DB:business_master_new
loadtime:0.37260913848877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River Fls' limit 1
loadtime:0.37270021438599 / seconds
Query Executed:select id FROM `wi` where city='Black River Fls' && SIC_code='5411'DB:business_master_new
loadtime:0.37328314781189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.37334108352661 / seconds
Query Executed:select id FROM `wi` where city='Blair' && SIC_code='5411'DB:business_master_new
loadtime:0.37520599365234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchardville' limit 1
loadtime:0.37528419494629 / seconds
Query Executed:select id FROM `wi` where city='Blanchardville' && SIC_code='5411'DB:business_master_new
loadtime:0.37712121009827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blenker' limit 1
loadtime:0.37719106674194 / seconds
Query Executed:select id FROM `wi` where city='Blenker' && SIC_code='5411'DB:business_master_new
loadtime:0.3777060508728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomer' limit 1
loadtime:0.37776112556458 / seconds
Query Executed:select id FROM `wi` where city='Bloomer' && SIC_code='5411'DB:business_master_new
loadtime:0.383141040802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomington' limit 1
loadtime:0.38322806358337 / seconds
Query Executed:select id FROM `wi` where city='Bloomington' && SIC_code='5411'DB:business_master_new
loadtime:0.38474011421204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Mounds' limit 1
loadtime:0.38480710983276 / seconds
Query Executed:select id FROM `wi` where city='Blue Mounds' && SIC_code='5411'DB:business_master_new
loadtime:0.38618302345276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue River' limit 1
loadtime:0.38625907897949 / seconds
Query Executed:select id FROM `wi` where city='Blue River' && SIC_code='5411'DB:business_master_new
loadtime:0.3877580165863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonduel' limit 1
loadtime:0.38782715797424 / seconds
Query Executed:select id FROM `wi` where city='Bonduel' && SIC_code='5411'DB:business_master_new
loadtime:0.39064502716064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscobel' limit 1
loadtime:0.39072203636169 / seconds
Query Executed:select id FROM `wi` where city='Boscobel' && SIC_code='5411'DB:business_master_new
loadtime:0.39445900917053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder Junction' limit 1
loadtime:0.39452910423279 / seconds
Query Executed:select id FROM `wi` where city='Boulder Junction' && SIC_code='5411'DB:business_master_new
loadtime:0.39668703079224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowler' limit 1
loadtime:0.39675807952881 / seconds
Query Executed:select id FROM `wi` where city='Bowler' && SIC_code='5411'DB:business_master_new
loadtime:0.39794206619263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyceville' limit 1
loadtime:0.39801120758057 / seconds
Query Executed:select id FROM `wi` where city='Boyceville' && SIC_code='5411'DB:business_master_new
loadtime:0.39983701705933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyd' limit 1
loadtime:0.39990520477295 / seconds
Query Executed:select id FROM `wi` where city='Boyd' && SIC_code='5411'DB:business_master_new
loadtime:0.40136218070984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.40143799781799 / seconds
Query Executed:select id FROM `wi` where city='Brandon' && SIC_code='5411'DB:business_master_new
loadtime:0.40312600135803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brantwood' limit 1
loadtime:0.40319418907166 / seconds
Query Executed:select id FROM `wi` where city='Brantwood' && SIC_code='5411'DB:business_master_new
loadtime:0.40377521514893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Briggsville' limit 1
loadtime:0.4038290977478 / seconds
Query Executed:select id FROM `wi` where city='Briggsville' && SIC_code='5411'DB:business_master_new
loadtime:0.4046311378479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brill' limit 1
loadtime:0.40468406677246 / seconds
Query Executed:select id FROM `wi` where city='Brill' && SIC_code='5411'DB:business_master_new
loadtime:0.40515112876892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brillion' limit 1
loadtime:0.40520310401917 / seconds
Query Executed:select id FROM `wi` where city='Brillion' && SIC_code='5411'DB:business_master_new
loadtime:0.40844106674194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.40851616859436 / seconds
Query Executed:select id FROM `wi` where city='Bristol' && SIC_code='5411'DB:business_master_new
loadtime:0.41155600547791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodhead' limit 1
loadtime:0.41162705421448 / seconds
Query Executed:select id FROM `wi` where city='Brodhead' && SIC_code='5411'DB:business_master_new
loadtime:0.41588521003723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brokaw' limit 1
loadtime:0.41595602035522 / seconds
Query Executed:select id FROM `wi` where city='Brokaw' && SIC_code='5411'DB:business_master_new
loadtime:0.4165210723877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.4165780544281 / seconds
Query Executed:select id FROM `wi` where city='Brookfield' && SIC_code='5411'DB:business_master_new
loadtime:0.46376609802246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.46390199661255 / seconds
Query Executed:select id FROM `wi` where city='Brooklyn' && SIC_code='5411'DB:business_master_new
loadtime:0.46628403663635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:0.4663610458374 / seconds
Query Executed:select id FROM `wi` where city='Brownsville' && SIC_code='5411'DB:business_master_new
loadtime:0.46783208847046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browntown' limit 1
loadtime:0.4679000377655 / seconds
Query Executed:select id FROM `wi` where city='Browntown' && SIC_code='5411'DB:business_master_new
loadtime:0.46923303604126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.46928811073303 / seconds
Query Executed:select id FROM `wi` where city='Bruce' && SIC_code='5411'DB:business_master_new
loadtime:0.47126817703247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brule' limit 1
loadtime:0.47134017944336 / seconds
Query Executed:select id FROM `wi` where city='Brule' && SIC_code='5411'DB:business_master_new
loadtime:0.47246599197388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brussels' limit 1
loadtime:0.47253608703613 / seconds
Query Executed:select id FROM `wi` where city='Brussels' && SIC_code='5411'DB:business_master_new
loadtime:0.47410202026367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.47417402267456 / seconds
Query Executed:select id FROM `wi` where city='Bryant' && SIC_code='5411'DB:business_master_new
loadtime:0.47510099411011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo City' limit 1
loadtime:0.47515606880188 / seconds
Query Executed:select id FROM `wi` where city='Buffalo City' && SIC_code='5411'DB:business_master_new
loadtime:0.4756281375885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.47568106651306 / seconds
Query Executed:select id FROM `wi` where city='Burlington' && SIC_code='5411'DB:business_master_new
loadtime:0.49352121353149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnett' limit 1
loadtime:0.49363803863525 / seconds
Query Executed:select id FROM `wi` where city='Burnett' && SIC_code='5411'DB:business_master_new
loadtime:0.49458599090576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.49464201927185 / seconds
Query Executed:select id FROM `wi` where city='Butler' && SIC_code='5411'DB:business_master_new
loadtime:0.49898815155029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butte Des Morts' limit 1
loadtime:0.49904298782349 / seconds
Query Executed:select id FROM `wi` where city='Butte Des Morts' && SIC_code='5411'DB:business_master_new
loadtime:0.49959707260132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butternut' limit 1
loadtime:0.49964904785156 / seconds
Query Executed:select id FROM `wi` where city='Butternut' && SIC_code='5411'DB:business_master_new
loadtime:0.50110006332397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:0.5011670589447 / seconds
Query Executed:select id FROM `wi` where city='Byron' && SIC_code='5411'DB:business_master_new
loadtime:0.50157713890076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cable' limit 1
loadtime:0.50163006782532 / seconds
Query Executed:select id FROM `wi` where city='Cable' && SIC_code='5411'DB:business_master_new
loadtime:0.5042781829834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cadott' limit 1
loadtime:0.50434803962708 / seconds
Query Executed:select id FROM `wi` where city='Cadott' && SIC_code='5411'DB:business_master_new
loadtime:0.50752401351929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.50759410858154 / seconds
Query Executed:select id FROM `wi` where city='Caledonia' && SIC_code='5411'DB:business_master_new
loadtime:0.51011610031128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambria' limit 1
loadtime:0.51017117500305 / seconds
Query Executed:select id FROM `wi` where city='Cambria' && SIC_code='5411'DB:business_master_new
loadtime:0.51174521446228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.51181221008301 / seconds
Query Executed:select id FROM `wi` where city='Cambridge' && SIC_code='5411'DB:business_master_new
loadtime:0.51592803001404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.51599717140198 / seconds
Query Executed:select id FROM `wi` where city='Cameron' && SIC_code='5411'DB:business_master_new
loadtime:0.51882815361023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Douglas' limit 1
loadtime:0.51890206336975 / seconds
Query Executed:select id FROM `wi` where city='Camp Douglas' && SIC_code='5411'DB:business_master_new
loadtime:0.52079200744629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Lake' limit 1
loadtime:0.52086305618286 / seconds
Query Executed:select id FROM `wi` where city='Camp Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.52143907546997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campbellsport' limit 1
loadtime:0.5215060710907 / seconds
Query Executed:select id FROM `wi` where city='Campbellsport' && SIC_code='5411'DB:business_master_new
loadtime:0.52580499649048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caroline' limit 1
loadtime:0.52588200569153 / seconds
Query Executed:select id FROM `wi` where city='Caroline' && SIC_code='5411'DB:business_master_new
loadtime:0.52641820907593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.52648520469666 / seconds
Query Executed:select id FROM `wi` where city='Cascade' && SIC_code='5411'DB:business_master_new
loadtime:0.52779316902161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casco' limit 1
loadtime:0.52786111831665 / seconds
Query Executed:select id FROM `wi` where city='Casco' && SIC_code='5411'DB:business_master_new
loadtime:0.52967500686646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashton' limit 1
loadtime:0.52974605560303 / seconds
Query Executed:select id FROM `wi` where city='Cashton' && SIC_code='5411'DB:business_master_new
loadtime:0.53222608566284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassville' limit 1
loadtime:0.5322961807251 / seconds
Query Executed:select id FROM `wi` where city='Cassville' && SIC_code='5411'DB:business_master_new
loadtime:0.5343279838562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataract' limit 1
loadtime:0.53440499305725 / seconds
Query Executed:select id FROM `wi` where city='Cataract' && SIC_code='5411'DB:business_master_new
loadtime:0.53490614891052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:0.5349600315094 / seconds
Query Executed:select id FROM `wi` where city='Catawba' && SIC_code='5411'DB:business_master_new
loadtime:0.53573513031006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cato' limit 1
loadtime:0.53578805923462 / seconds
Query Executed:select id FROM `wi` where city='Cato' && SIC_code='5411'DB:business_master_new
loadtime:0.53615212440491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.53620409965515 / seconds
Query Executed:select id FROM `wi` where city='Cavour' && SIC_code='5411'DB:business_master_new
loadtime:0.53659319877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cazenovia' limit 1
loadtime:0.53664708137512 / seconds
Query Executed:select id FROM `wi` where city='Cazenovia' && SIC_code='5411'DB:business_master_new
loadtime:0.53783202171326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cecil' limit 1
loadtime:0.5379011631012 / seconds
Query Executed:select id FROM `wi` where city='Cecil' && SIC_code='5411'DB:business_master_new
loadtime:0.53955006599426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:0.53962111473083 / seconds
Query Executed:select id FROM `wi` where city='Cedar Grove' && SIC_code='5411'DB:business_master_new
loadtime:0.54153609275818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarburg' limit 1
loadtime:0.54160809516907 / seconds
Query Executed:select id FROM `wi` where city='Cedarburg' && SIC_code='5411'DB:business_master_new
loadtime:0.55522513389587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centuria' limit 1
loadtime:0.55530214309692 / seconds
Query Executed:select id FROM `wi` where city='Centuria' && SIC_code='5411'DB:business_master_new
loadtime:0.55686712265015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaseburg' limit 1
loadtime:0.55693316459656 / seconds
Query Executed:select id FROM `wi` where city='Chaseburg' && SIC_code='5411'DB:business_master_new
loadtime:0.5578920841217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chetek' limit 1
loadtime:0.55794620513916 / seconds
Query Executed:select id FROM `wi` where city='Chetek' && SIC_code='5411'DB:business_master_new
loadtime:0.56268811225891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chili' limit 1
loadtime:0.56275701522827 / seconds
Query Executed:select id FROM `wi` where city='Chili' && SIC_code='5411'DB:business_master_new
loadtime:0.56385898590088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilton' limit 1
loadtime:0.56392812728882 / seconds
Query Executed:select id FROM `wi` where city='Chilton' && SIC_code='5411'DB:business_master_new
loadtime:0.59683418273926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chippewa Falls' limit 1
loadtime:0.59693217277527 / seconds
Query Executed:select id FROM `wi` where city='Chippewa Falls' && SIC_code='5411'DB:business_master_new
loadtime:0.61636400222778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clam Falls' limit 1
loadtime:0.61647701263428 / seconds
Query Executed:select id FROM `wi` where city='Clam Falls' && SIC_code='5411'DB:business_master_new
loadtime:0.61692309379578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clam Lake' limit 1
loadtime:0.61697912216187 / seconds
Query Executed:select id FROM `wi` where city='Clam Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.61765313148499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.61772108078003 / seconds
Query Executed:select id FROM `wi` where city='Clayton' && SIC_code='5411'DB:business_master_new
loadtime:0.61934304237366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.61941409111023 / seconds
Query Executed:select id FROM `wi` where city='Clear Lake' && SIC_code='5411'DB:business_master_new
loadtime:0.62197113037109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.62204313278198 / seconds
Query Executed:select id FROM `wi` where city='Cleveland' && SIC_code='5411'DB:business_master_new
loadtime:0.6239230632782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.62399315834045 / seconds
Query Executed:select id FROM `wi` where city='Clinton' && SIC_code='5411'DB:business_master_new
loadtime:0.62682414054871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintonville' limit 1
loadtime:0.62689805030823 / seconds
Query Executed:select id FROM `wi` where city='Clintonville' && SIC_code='5411'DB:business_master_new
loadtime:0.66149806976318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyman' limit 1
loadtime:0.66162705421448 / seconds
Query Executed:select id FROM `wi` where city='Clyman' && SIC_code='5411'DB:business_master_new
loadtime:0.66233801841736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobb' limit 1
loadtime:0.66239619255066 / seconds
Query Executed:select id FROM `wi` where city='Cobb' && SIC_code='5411'DB:business_master_new
loadtime:0.66340708732605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochrane' limit 1
loadtime:0.66347718238831 / seconds
Query Executed:select id FROM `wi` where city='Cochrane' && SIC_code='5411'DB:business_master_new
loadtime:0.66535615921021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colby' limit 1
loadtime:0.66543817520142 / seconds
Query Executed:select id FROM `wi` where city='Colby' && SIC_code='5411'DB:business_master_new
loadtime:0.66783499717712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman' limit 1
loadtime:0.66790819168091 / seconds
Query Executed:select id FROM `wi` where city='Coleman' && SIC_code='5411'DB:business_master_new
loadtime:0.66984701156616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.66991400718689 / seconds
Query Executed:select id FROM `wi` where city='Colfax' && SIC_code='5411'DB:business_master_new
loadtime:0.67269015312195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colgate' limit 1
loadtime:0.67276501655579 / seconds
Query Executed:select id FROM `wi` where city='Colgate' && SIC_code='5411'DB:business_master_new
loadtime:0.67475914955139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.67481517791748 / seconds
Query Executed:select id FROM `wi` where city='Collins' && SIC_code='5411'DB:business_master_new
loadtime:0.67542910575867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coloma' limit 1
loadtime:0.67548203468323 / seconds
Query Executed:select id FROM `wi` where city='Coloma' && SIC_code='5411'DB:business_master_new
loadtime:0.67709398269653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.67716312408447 / seconds
Query Executed:select id FROM `wi` where city='Columbus' && SIC_code='5411'DB:business_master_new
loadtime:0.68279314041138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Combined Locks' limit 1
loadtime:0.68287301063538 / seconds
Query Executed:select id FROM `wi` where city='Combined Locks' && SIC_code='5411'DB:business_master_new
loadtime:0.68415307998657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock' limit 1
loadtime:0.68420910835266 / seconds
Query Executed:select id FROM `wi` where city='Comstock' && SIC_code='5411'DB:business_master_new
loadtime:0.68494200706482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conover' limit 1
loadtime:0.68499612808228 / seconds
Query Executed:select id FROM `wi` where city='Conover' && SIC_code='5411'DB:business_master_new
loadtime:0.68638706207275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrath' limit 1
loadtime:0.68646001815796 / seconds
Query Executed:select id FROM `wi` where city='Conrath' && SIC_code='5411'DB:business_master_new
loadtime:0.68726110458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Valley' limit 1
loadtime:0.687331199646 / seconds
Query Executed:select id FROM `wi` where city='Coon Valley' && SIC_code='5411'DB:business_master_new
loadtime:0.68913602828979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornell' limit 1
loadtime:0.68920707702637 / seconds
Query Executed:select id FROM `wi` where city='Cornell' && SIC_code='5411'DB:business_master_new
loadtime:0.69152212142944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornucopia' limit 1
loadtime:0.69159317016602 / seconds
Query Executed:select id FROM `wi` where city='Cornucopia' && SIC_code='5411'DB:business_master_new
loadtime:0.6923131942749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottage Grove' limit 1
loadtime:0.69238114356995 / seconds
Query Executed:select id FROM `wi` where city='Cottage Grove' && SIC_code='5411'DB:business_master_new
loadtime:0.69718718528748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Couderay' limit 1
loadtime:0.69727301597595 / seconds
Query Executed:select id FROM `wi` where city='Couderay' && SIC_code='5411'DB:business_master_new
loadtime:0.69800615310669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crandon' limit 1
loadtime:0.69806098937988 / seconds
Query Executed:select id FROM `wi` where city='Crandon' && SIC_code='5411'DB:business_master_new
loadtime:0.70214509963989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crivitz' limit 1
loadtime:0.7022180557251 / seconds
Query Executed:select id FROM `wi` where city='Crivitz' && SIC_code='5411'DB:business_master_new
loadtime:0.70931601524353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Plains' limit 1
loadtime:0.70939111709595 / seconds
Query Executed:select id FROM `wi` where city='Cross Plains' && SIC_code='5411'DB:business_master_new
loadtime:0.74172115325928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba City' limit 1
loadtime:0.7418110370636 / seconds
Query Executed:select id FROM `wi` where city='Cuba City' && SIC_code='5411'DB:business_master_new
loadtime:0.74527406692505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cudahy' limit 1
loadtime:0.74534320831299 / seconds
Query Executed:select id FROM `wi` where city='Cudahy' && SIC_code='5411'DB:business_master_new
loadtime:0.7553870677948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.75546908378601 / seconds
Query Executed:select id FROM `wi` where city='Cumberland' && SIC_code='5411'DB:business_master_new
loadtime:0.78773021697998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtiss' limit 1
loadtime:0.78790402412415 / seconds
Query Executed:select id FROM `wi` where city='Curtiss' && SIC_code='5411'DB:business_master_new
loadtime:0.78903198242188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:0.78910613059998 / seconds
Query Executed:select id FROM `wi` where city='Cushing' && SIC_code='5411'DB:business_master_new
loadtime:0.79016518592834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.79024505615234 / seconds
Query Executed:select id FROM `wi` where city='Custer' && SIC_code='5411'DB:business_master_new
loadtime:0.79192900657654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dairyland' limit 1
loadtime:0.79199600219727 / seconds
Query Executed:select id FROM `wi` where city='Dairyland' && SIC_code='5411'DB:business_master_new
loadtime:0.79243612289429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:0.79249119758606 / seconds
Query Executed:select id FROM `wi` where city='Dale' && SIC_code='5411'DB:business_master_new
loadtime:0.79341816902161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.79348516464233 / seconds
Query Executed:select id FROM `wi` where city='Dallas' && SIC_code='5411'DB:business_master_new
loadtime:0.7947690486908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.79482316970825 / seconds
Query Executed:select id FROM `wi` where city='Dalton' && SIC_code='5411'DB:business_master_new
loadtime:0.79575419425964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.7958071231842 / seconds
Query Executed:select id FROM `wi` where city='Danbury' && SIC_code='5411'DB:business_master_new
loadtime:0.79812598228455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dane' limit 1
loadtime:0.79820013046265 / seconds
Query Executed:select id FROM `wi` where city='Dane' && SIC_code='5411'DB:business_master_new
loadtime:0.79996609687805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.80003714561462 / seconds
Query Executed:select id FROM `wi` where city='Darien' && SIC_code='5411'DB:business_master_new
loadtime:0.80199813842773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington' limit 1
loadtime:0.80206418037415 / seconds
Query Executed:select id FROM `wi` where city='Darlington' && SIC_code='5411'DB:business_master_new
loadtime:0.80901408195496 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Forest' limit 1
loadtime:0.80908513069153 / seconds
Query Executed:select id FROM `wi` where city='De Forest' && SIC_code='5411'DB:business_master_new
loadtime:0.8186891078949 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Pere' limit 1
loadtime:0.81877112388611 / seconds
Query Executed:select id FROM `wi` where city='De Pere' && SIC_code='5411'DB:business_master_new
loadtime:0.8391580581665 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:0.839280128479 / seconds
Query Executed:select id FROM `wi` where city='De Soto' && SIC_code='5411'DB:business_master_new
loadtime:0.84077119827271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Park' limit 1
loadtime:0.84084320068359 / seconds
Query Executed:select id FROM `wi` where city='Deer Park' && SIC_code='5411'DB:business_master_new
loadtime:0.84196710586548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerbrook' limit 1
loadtime:0.84202098846436 / seconds
Query Executed:select id FROM `wi` where city='Deerbrook' && SIC_code='5411'DB:business_master_new
loadtime:0.84318113327026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.843257188797 / seconds
Query Executed:select id FROM `wi` where city='Deerfield' && SIC_code='5411'DB:business_master_new
loadtime:0.84602808952332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delafield' limit 1
loadtime:0.84610104560852 / seconds
Query Executed:select id FROM `wi` where city='Delafield' && SIC_code='5411'DB:business_master_new
loadtime:0.85458207130432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delavan' limit 1
loadtime:0.85465908050537 / seconds
Query Executed:select id FROM `wi` where city='Delavan' && SIC_code='5411'DB:business_master_new
loadtime:0.86727905273438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dellwood' limit 1
loadtime:0.86736607551575 / seconds
Query Executed:select id FROM `wi` where city='Dellwood' && SIC_code='5411'DB:business_master_new
loadtime:0.86783909797668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.86790704727173 / seconds
Query Executed:select id FROM `wi` where city='Denmark' && SIC_code='5411'DB:business_master_new
loadtime:0.9004762172699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickeyville' limit 1
loadtime:0.90057921409607 / seconds
Query Executed:select id FROM `wi` where city='Dickeyville' && SIC_code='5411'DB:business_master_new
loadtime:0.90188813209534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodge' limit 1
loadtime:0.90195918083191 / seconds
Query Executed:select id FROM `wi` where city='Dodge' && SIC_code='5411'DB:business_master_new
loadtime:0.90252900123596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodgeville' limit 1
loadtime:0.90258502960205 / seconds
Query Executed:select id FROM `wi` where city='Dodgeville' && SIC_code='5411'DB:business_master_new
loadtime:0.91111302375793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.91118907928467 / seconds
Query Executed:select id FROM `wi` where city='Dorchester' && SIC_code='5411'DB:business_master_new
loadtime:0.91299200057983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dousman' limit 1
loadtime:0.91306114196777 / seconds
Query Executed:select id FROM `wi` where city='Dousman' && SIC_code='5411'DB:business_master_new
loadtime:0.91618919372559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Downing' limit 1
loadtime:0.9162712097168 / seconds
Query Executed:select id FROM `wi` where city='Downing' && SIC_code='5411'DB:business_master_new
loadtime:0.9171130657196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Downsville' limit 1
loadtime:0.91718220710754 / seconds
Query Executed:select id FROM `wi` where city='Downsville' && SIC_code='5411'DB:business_master_new
loadtime:0.91781401634216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doylestown' limit 1
loadtime:0.91788220405579 / seconds
Query Executed:select id FROM `wi` where city='Doylestown' && SIC_code='5411'DB:business_master_new
loadtime:0.91838312149048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dresser' limit 1
loadtime:0.91844415664673 / seconds
Query Executed:select id FROM `wi` where city='Dresser' && SIC_code='5411'DB:business_master_new
loadtime:0.9199640750885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drummond' limit 1
loadtime:0.92003321647644 / seconds
Query Executed:select id FROM `wi` where city='Drummond' && SIC_code='5411'DB:business_master_new
loadtime:0.92097401618958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbar' limit 1
loadtime:0.92104315757751 / seconds
Query Executed:select id FROM `wi` where city='Dunbar' && SIC_code='5411'DB:business_master_new
loadtime:0.92167210578918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durand' limit 1
loadtime:0.92172908782959 / seconds
Query Executed:select id FROM `wi` where city='Durand' && SIC_code='5411'DB:business_master_new
loadtime:0.95552206039429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:0.95565009117126 / seconds
Query Executed:select id FROM `wi` where city='Eagle' && SIC_code='5411'DB:business_master_new
loadtime:0.95848202705383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle River' limit 1
loadtime:0.95855903625488 / seconds
Query Executed:select id FROM `wi` where city='Eagle River' && SIC_code='5411'DB:business_master_new
loadtime:0.97026801109314 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ellsworth' limit 1
loadtime:0.97035121917725 / seconds
Query Executed:select id FROM `wi` where city='East Ellsworth' && SIC_code='5411'DB:business_master_new
loadtime:0.97089815139771 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Troy' limit 1
loadtime:0.97095608711243 / seconds
Query Executed:select id FROM `wi` where city='East Troy' && SIC_code='5411'DB:business_master_new
loadtime:0.9786491394043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastman' limit 1
loadtime:0.97872114181519 / seconds
Query Executed:select id FROM `wi` where city='Eastman' && SIC_code='5411'DB:business_master_new
loadtime:0.97985100746155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Claire' limit 1
loadtime:0.9799211025238 / seconds
Query Executed:select id FROM `wi` where city='Eau Claire' && SIC_code='5411'DB:business_master_new
loadtime:1.0262169837952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Galle' limit 1
loadtime:1.026447057724 / seconds
Query Executed:select id FROM `wi` where city='Eau Galle' && SIC_code='5411'DB:business_master_new
loadtime:1.0273621082306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:1.0274431705475 / seconds
Query Executed:select id FROM `wi` where city='Eden' && SIC_code='5411'DB:business_master_new
loadtime:1.0290260314941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgar' limit 1
loadtime:1.0290961265564 / seconds
Query Executed:select id FROM `wi` where city='Edgar' && SIC_code='5411'DB:business_master_new
loadtime:1.0317370891571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgerton' limit 1
loadtime:1.0318071842194 / seconds
Query Executed:select id FROM `wi` where city='Edgerton' && SIC_code='5411'DB:business_master_new
loadtime:1.039724111557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:1.0397980213165 / seconds
Query Executed:select id FROM `wi` where city='Edgewater' && SIC_code='5411'DB:business_master_new
loadtime:1.0402321815491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmund' limit 1
loadtime:1.0402979850769 / seconds
Query Executed:select id FROM `wi` where city='Edmund' && SIC_code='5411'DB:business_master_new
loadtime:1.0407040119171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor' limit 1
loadtime:1.0407609939575 / seconds
Query Executed:select id FROM `wi` where city='Egg Harbor' && SIC_code='5411'DB:business_master_new
loadtime:1.0732941627502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eland' limit 1
loadtime:1.0733931064606 / seconds
Query Executed:select id FROM `wi` where city='Eland' && SIC_code='5411'DB:business_master_new
loadtime:1.0743191242218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elcho' limit 1
loadtime:1.0743730068207 / seconds
Query Executed:select id FROM `wi` where city='Elcho' && SIC_code='5411'DB:business_master_new
loadtime:1.0756561756134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elderon' limit 1
loadtime:1.0757250785828 / seconds
Query Executed:select id FROM `wi` where city='Elderon' && SIC_code='5411'DB:business_master_new
loadtime:1.0762732028961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:1.076339006424 / seconds
Query Executed:select id FROM `wi` where city='Eldorado' && SIC_code='5411'DB:business_master_new
loadtime:1.0772950649261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eleva' limit 1
loadtime:1.0773501396179 / seconds
Query Executed:select id FROM `wi` where city='Eleva' && SIC_code='5411'DB:business_master_new
loadtime:1.0794730186462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Mound' limit 1
loadtime:1.079540014267 / seconds
Query Executed:select id FROM `wi` where city='Elk Mound' && SIC_code='5411'DB:business_master_new
loadtime:1.0819020271301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart Lake' limit 1
loadtime:1.0819702148438 / seconds
Query Executed:select id FROM `wi` where city='Elkhart Lake' && SIC_code='5411'DB:business_master_new
loadtime:1.084892988205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhorn' limit 1
loadtime:1.0849630832672 / seconds
Query Executed:select id FROM `wi` where city='Elkhorn' && SIC_code='5411'DB:business_master_new
loadtime:1.099739074707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellison Bay' limit 1
loadtime:1.099828004837 / seconds
Query Executed:select id FROM `wi` where city='Ellison Bay' && SIC_code='5411'DB:business_master_new
loadtime:1.1013472080231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:1.1014070510864 / seconds
Query Executed:select id FROM `wi` where city='Ellsworth' && SIC_code='5411'DB:business_master_new
loadtime:1.1080861091614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Grove' limit 1
loadtime:1.1081600189209 / seconds
Query Executed:select id FROM `wi` where city='Elm Grove' && SIC_code='5411'DB:business_master_new
loadtime:1.1168332099915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:1.1169030666351 / seconds
Query Executed:select id FROM `wi` where city='Elmwood' && SIC_code='5411'DB:business_master_new
loadtime:1.1187829971313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elroy' limit 1
loadtime:1.1188521385193 / seconds
Query Executed:select id FROM `wi` where city='Elroy' && SIC_code='5411'DB:business_master_new
loadtime:1.1211061477661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elton' limit 1
loadtime:1.1211750507355 / seconds
Query Executed:select id FROM `wi` where city='Elton' && SIC_code='5411'DB:business_master_new
loadtime:1.1216781139374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embarrass' limit 1
loadtime:1.1217441558838 / seconds
Query Executed:select id FROM `wi` where city='Embarrass' && SIC_code='5411'DB:business_master_new
loadtime:1.1224460601807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerald' limit 1
loadtime:1.1225140094757 / seconds
Query Executed:select id FROM `wi` where city='Emerald' && SIC_code='5411'DB:business_master_new
loadtime:1.1229150295258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Endeavor' limit 1
loadtime:1.1229681968689 / seconds
Query Executed:select id FROM `wi` where city='Endeavor' && SIC_code='5411'DB:business_master_new
loadtime:1.1240181922913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephraim' limit 1
loadtime:1.1240830421448 / seconds
Query Executed:select id FROM `wi` where city='Ephraim' && SIC_code='5411'DB:business_master_new
loadtime:1.1256852149963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:1.1257522106171 / seconds
Query Executed:select id FROM `wi` where city='Ettrick' && SIC_code='5411'DB:business_master_new
loadtime:1.1273331642151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:1.1274030208588 / seconds
Query Executed:select id FROM `wi` where city='Eureka' && SIC_code='5411'DB:business_master_new
loadtime:1.1278660297394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansville' limit 1
loadtime:1.1279180049896 / seconds
Query Executed:select id FROM `wi` where city='Evansville' && SIC_code='5411'DB:business_master_new
loadtime:1.1348230838776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeland' limit 1
loadtime:1.1348969936371 / seconds
Query Executed:select id FROM `wi` where city='Exeland' && SIC_code='5411'DB:business_master_new
loadtime:1.1359691619873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Water' limit 1
loadtime:1.1360371112823 / seconds
Query Executed:select id FROM `wi` where city='Fair Water' && SIC_code='5411'DB:business_master_new
loadtime:1.1364350318909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairchild' limit 1
loadtime:1.136491060257 / seconds
Query Executed:select id FROM `wi` where city='Fairchild' && SIC_code='5411'DB:business_master_new
loadtime:1.1375041007996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairwater' limit 1
loadtime:1.1375730037689 / seconds
Query Executed:select id FROM `wi` where city='Fairwater' && SIC_code='5411'DB:business_master_new
loadtime:1.1382360458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall Creek' limit 1
loadtime:1.1383020877838 / seconds
Query Executed:select id FROM `wi` where city='Fall Creek' && SIC_code='5411'DB:business_master_new
loadtime:1.1409289836884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:1.1410021781921 / seconds
Query Executed:select id FROM `wi` where city='Fall River' && SIC_code='5411'DB:business_master_new
loadtime:1.142566204071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence' limit 1
loadtime:1.1426210403442 / seconds
Query Executed:select id FROM `wi` where city='Fence' && SIC_code='5411'DB:business_master_new
loadtime:1.1432650089264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fennimore' limit 1
loadtime:1.14333319664 / seconds
Query Executed:select id FROM `wi` where city='Fennimore' && SIC_code='5411'DB:business_master_new
loadtime:1.1756081581116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwood' limit 1
loadtime:1.1756951808929 / seconds
Query Executed:select id FROM `wi` where city='Fenwood' && SIC_code='5411'DB:business_master_new
loadtime:1.1761541366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferryville' limit 1
loadtime:1.1762080192566 / seconds
Query Executed:select id FROM `wi` where city='Ferryville' && SIC_code='5411'DB:business_master_new
loadtime:1.1773600578308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fifield' limit 1
loadtime:1.1774191856384 / seconds
Query Executed:select id FROM `wi` where city='Fifield' && SIC_code='5411'DB:business_master_new
loadtime:1.1782660484314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fish Creek' limit 1
loadtime:1.1783351898193 / seconds
Query Executed:select id FROM `wi` where city='Fish Creek' && SIC_code='5411'DB:business_master_new
loadtime:1.1812272071838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:1.1812980175018 / seconds
Query Executed:select id FROM `wi` where city='Fitchburg' && SIC_code='5411'DB:business_master_new
loadtime:1.1818830966949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.1819372177124 / seconds
Query Executed:select id FROM `wi` where city='Florence' && SIC_code='5411'DB:business_master_new
loadtime:1.1847159862518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fond Du Lac' limit 1
loadtime:1.1847901344299 / seconds
Query Executed:select id FROM `wi` where city='Fond Du Lac' && SIC_code='5411'DB:business_master_new
loadtime:1.2179532051086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana' limit 1
loadtime:1.2180972099304 / seconds
Query Executed:select id FROM `wi` where city='Fontana' && SIC_code='5411'DB:business_master_new
loadtime:1.2199470996857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Footville' limit 1
loadtime:1.2200191020966 / seconds
Query Executed:select id FROM `wi` where city='Footville' && SIC_code='5411'DB:business_master_new
loadtime:1.2210350036621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Junction' limit 1
loadtime:1.22110414505 / seconds
Query Executed:select id FROM `wi` where city='Forest Junction' && SIC_code='5411'DB:business_master_new
loadtime:1.2217609882355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestville' limit 1
loadtime:1.2218301296234 / seconds
Query Executed:select id FROM `wi` where city='Forestville' && SIC_code='5411'DB:business_master_new
loadtime:1.2229030132294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:1.2229700088501 / seconds
Query Executed:select id FROM `wi` where city='Fort Atkinson' && SIC_code='5411'DB:business_master_new
loadtime:1.2361030578613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mccoy' limit 1
loadtime:1.2361841201782 / seconds
Query Executed:select id FROM `wi` where city='Fort Mccoy' && SIC_code='5411'DB:business_master_new
loadtime:1.2366859912872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain City' limit 1
loadtime:1.2367420196533 / seconds
Query Executed:select id FROM `wi` where city='Fountain City' && SIC_code='5411'DB:business_master_new
loadtime:1.2388482093811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fox Lake' limit 1
loadtime:1.2389371395111 / seconds
Query Executed:select id FROM `wi` where city='Fox Lake' && SIC_code='5411'DB:business_master_new
loadtime:1.2412571907043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:1.2413311004639 / seconds
Query Executed:select id FROM `wi` where city='Foxboro' && SIC_code='5411'DB:business_master_new
loadtime:1.2421610355377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francis Creek' limit 1
loadtime:1.2422270774841 / seconds
Query Executed:select id FROM `wi` where city='Francis Creek' && SIC_code='5411'DB:business_master_new
loadtime:1.2430942058563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.2431480884552 / seconds
Query Executed:select id FROM `wi` where city='Franklin' && SIC_code='5411'DB:business_master_new
loadtime:1.2595059871674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franksville' limit 1
loadtime:1.2596151828766 / seconds
Query Executed:select id FROM `wi` where city='Franksville' && SIC_code='5411'DB:business_master_new
loadtime:1.266508102417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederic' limit 1
loadtime:1.266585111618 / seconds
Query Executed:select id FROM `wi` where city='Frederic' && SIC_code='5411'DB:business_master_new
loadtime:1.2721240520477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:1.2721970081329 / seconds
Query Executed:select id FROM `wi` where city='Fredonia' && SIC_code='5411'DB:business_master_new
loadtime:1.274854183197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:1.274924993515 / seconds
Query Executed:select id FROM `wi` where city='Freedom' && SIC_code='5411'DB:business_master_new
loadtime:1.2753829956055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:1.2754402160645 / seconds
Query Executed:select id FROM `wi` where city='Fremont' && SIC_code='5411'DB:business_master_new
loadtime:1.2779982089996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friendship' limit 1
loadtime:1.2780661582947 / seconds
Query Executed:select id FROM `wi` where city='Friendship' && SIC_code='5411'DB:business_master_new
loadtime:1.2809731960297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friesland' limit 1
loadtime:1.2810521125793 / seconds
Query Executed:select id FROM `wi` where city='Friesland' && SIC_code='5411'DB:business_master_new
loadtime:1.2818241119385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesville' limit 1
loadtime:1.281898021698 / seconds
Query Executed:select id FROM `wi` where city='Galesville' && SIC_code='5411'DB:business_master_new
loadtime:1.2847640514374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galloway' limit 1
loadtime:1.284882068634 / seconds
Query Executed:select id FROM `wi` where city='Galloway' && SIC_code='5411'DB:business_master_new
loadtime:1.2853350639343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gays Mills' limit 1
loadtime:1.2854161262512 / seconds
Query Executed:select id FROM `wi` where city='Gays Mills' && SIC_code='5411'DB:business_master_new
loadtime:1.2872791290283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genesee Depot' limit 1
loadtime:1.2873821258545 / seconds
Query Executed:select id FROM `wi` where city='Genesee Depot' && SIC_code='5411'DB:business_master_new
loadtime:1.2884600162506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa' limit 1
loadtime:1.2885580062866 / seconds
Query Executed:select id FROM `wi` where city='Genoa' && SIC_code='5411'DB:business_master_new
loadtime:1.2897551059723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa City' limit 1
loadtime:1.2898530960083 / seconds
Query Executed:select id FROM `wi` where city='Genoa City' && SIC_code='5411'DB:business_master_new
loadtime:1.2928040027618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germantown' limit 1
loadtime:1.2929031848907 / seconds
Query Executed:select id FROM `wi` where city='Germantown' && SIC_code='5411'DB:business_master_new
loadtime:1.3057870864868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gile' limit 1
loadtime:1.3058700561523 / seconds
Query Executed:select id FROM `wi` where city='Gile' && SIC_code='5411'DB:business_master_new
loadtime:1.3063540458679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett' limit 1
loadtime:1.3064150810242 / seconds
Query Executed:select id FROM `wi` where city='Gillett' && SIC_code='5411'DB:business_master_new
loadtime:1.3387031555176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:1.3387930393219 / seconds
Query Executed:select id FROM `wi` where city='Gilman' && SIC_code='5411'DB:business_master_new
loadtime:1.3404331207275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:1.3405091762543 / seconds
Query Executed:select id FROM `wi` where city='Gilmanton' && SIC_code='5411'DB:business_master_new
loadtime:1.3410370349884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gleason' limit 1
loadtime:1.3411040306091 / seconds
Query Executed:select id FROM `wi` where city='Gleason' && SIC_code='5411'DB:business_master_new
loadtime:1.3424670696259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Flora' limit 1
loadtime:1.3425362110138 / seconds
Query Executed:select id FROM `wi` where city='Glen Flora' && SIC_code='5411'DB:business_master_new
loadtime:1.3433771133423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Haven' limit 1
loadtime:1.3434491157532 / seconds
Query Executed:select id FROM `wi` where city='Glen Haven' && SIC_code='5411'DB:business_master_new
loadtime:1.3444130420685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenbeulah' limit 1
loadtime:1.3444671630859 / seconds
Query Executed:select id FROM `wi` where city='Glenbeulah' && SIC_code='5411'DB:business_master_new
loadtime:1.3455150127411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood City' limit 1
loadtime:1.3455681800842 / seconds
Query Executed:select id FROM `wi` where city='Glenwood City' && SIC_code='5411'DB:business_master_new
loadtime:1.376433134079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:1.37651014328 / seconds
Query Executed:select id FROM `wi` where city='Glidden' && SIC_code='5411'DB:business_master_new
loadtime:1.3776631355286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodman' limit 1
loadtime:1.3777341842651 / seconds
Query Executed:select id FROM `wi` where city='Goodman' && SIC_code='5411'DB:business_master_new
loadtime:1.378564119339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordon' limit 1
loadtime:1.3786191940308 / seconds
Query Executed:select id FROM `wi` where city='Gordon' && SIC_code='5411'DB:business_master_new
loadtime:1.3798182010651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gotham' limit 1
loadtime:1.3798861503601 / seconds
Query Executed:select id FROM `wi` where city='Gotham' && SIC_code='5411'DB:business_master_new
loadtime:1.3803980350494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:1.3804631233215 / seconds
Query Executed:select id FROM `wi` where city='Grafton' && SIC_code='5411'DB:business_master_new
loadtime:1.3919131755829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Marsh' limit 1
loadtime:1.3919861316681 / seconds
Query Executed:select id FROM `wi` where city='Grand Marsh' && SIC_code='5411'DB:business_master_new
loadtime:1.3930051326752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand View' limit 1
loadtime:1.393079996109 / seconds
Query Executed:select id FROM `wi` where city='Grand View' && SIC_code='5411'DB:business_master_new
loadtime:1.3937401771545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granton' limit 1
loadtime:1.3938081264496 / seconds
Query Executed:select id FROM `wi` where city='Granton' && SIC_code='5411'DB:business_master_new
loadtime:1.39515209198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsburg' limit 1
loadtime:1.3952341079712 / seconds
Query Executed:select id FROM `wi` where city='Grantsburg' && SIC_code='5411'DB:business_master_new
loadtime:1.3986752033234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gratiot' limit 1
loadtime:1.3987522125244 / seconds
Query Executed:select id FROM `wi` where city='Gratiot' && SIC_code='5411'DB:business_master_new
loadtime:1.3999571800232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:1.4000251293182 / seconds
Query Executed:select id FROM `wi` where city='Green Bay' && SIC_code='5411'DB:business_master_new
loadtime:1.4350981712341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Lake' limit 1
loadtime:1.4353461265564 / seconds
Query Executed:select id FROM `wi` where city='Green Lake' && SIC_code='5411'DB:business_master_new
loadtime:1.4664280414581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:1.4665150642395 / seconds
Query Executed:select id FROM `wi` where city='Green Valley' && SIC_code='5411'DB:business_master_new
loadtime:1.4670121669769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.4670670032501 / seconds
Query Executed:select id FROM `wi` where city='Greenbush' && SIC_code='5411'DB:business_master_new
loadtime:1.4676320552826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greendale' limit 1
loadtime:1.4676871299744 / seconds
Query Executed:select id FROM `wi` where city='Greendale' && SIC_code='5411'DB:business_master_new
loadtime:1.4768731594086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:1.4769451618195 / seconds
Query Executed:select id FROM `wi` where city='Greenfield' && SIC_code='5411'DB:business_master_new
loadtime:1.4775581359863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenleaf' limit 1
loadtime:1.4776132106781 / seconds
Query Executed:select id FROM `wi` where city='Greenleaf' && SIC_code='5411'DB:business_master_new
loadtime:1.4802551269531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.4803230762482 / seconds
Query Executed:select id FROM `wi` where city='Greenville' && SIC_code='5411'DB:business_master_new
loadtime:1.5126070976257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.5127391815186 / seconds
Query Executed:select id FROM `wi` where city='Greenwood' && SIC_code='5411'DB:business_master_new
loadtime:1.5152781009674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:1.5153481960297 / seconds
Query Executed:select id FROM `wi` where city='Gresham' && SIC_code='5411'DB:business_master_new
loadtime:1.5167300701141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hager City' limit 1
loadtime:1.5168001651764 / seconds
Query Executed:select id FROM `wi` where city='Hager City' && SIC_code='5411'DB:business_master_new
loadtime:1.5182301998138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Corners' limit 1
loadtime:1.5182991027832 / seconds
Query Executed:select id FROM `wi` where city='Hales Corners' && SIC_code='5411'DB:business_master_new
loadtime:1.5273911952972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:1.5274651050568 / seconds
Query Executed:select id FROM `wi` where city='Hamburg' && SIC_code='5411'DB:business_master_new
loadtime:1.5278360843658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hammond' limit 1
loadtime:1.5278890132904 / seconds
Query Executed:select id FROM `wi` where city='Hammond' && SIC_code='5411'DB:business_master_new
loadtime:1.5296170711517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.5296700000763 / seconds
Query Executed:select id FROM `wi` where city='Hancock' && SIC_code='5411'DB:business_master_new
loadtime:1.5310001373291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hannibal' limit 1
loadtime:1.5310699939728 / seconds
Query Executed:select id FROM `wi` where city='Hannibal' && SIC_code='5411'DB:business_master_new
loadtime:1.531503200531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.5315570831299 / seconds
Query Executed:select id FROM `wi` where city='Hanover' && SIC_code='5411'DB:business_master_new
loadtime:1.531975030899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harshaw' limit 1
loadtime:1.5320291519165 / seconds
Query Executed:select id FROM `wi` where city='Harshaw' && SIC_code='5411'DB:business_master_new
loadtime:1.5329461097717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.5330140590668 / seconds
Query Executed:select id FROM `wi` where city='Hartford' && SIC_code='5411'DB:business_master_new
loadtime:1.5477252006531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:1.5478332042694 / seconds
Query Executed:select id FROM `wi` where city='Hartland' && SIC_code='5411'DB:business_master_new
loadtime:1.5620729923248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatley' limit 1
loadtime:1.562164068222 / seconds
Query Executed:select id FROM `wi` where city='Hatley' && SIC_code='5411'DB:business_master_new
loadtime:1.5640060901642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haugen' limit 1
loadtime:1.5640780925751 / seconds
Query Executed:select id FROM `wi` where city='Haugen' && SIC_code='5411'DB:business_master_new
loadtime:1.5647580623627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkins' limit 1
loadtime:1.5648272037506 / seconds
Query Executed:select id FROM `wi` where city='Hawkins' && SIC_code='5411'DB:business_master_new
loadtime:1.5656530857086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawthorne' limit 1
loadtime:1.5657210350037 / seconds
Query Executed:select id FROM `wi` where city='Hawthorne' && SIC_code='5411'DB:business_master_new
loadtime:1.5663390159607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayward' limit 1
loadtime:1.5664100646973 / seconds
Query Executed:select id FROM `wi` where city='Hayward' && SIC_code='5411'DB:business_master_new
loadtime:1.5818710327148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Green' limit 1
loadtime:1.5819821357727 / seconds
Query Executed:select id FROM `wi` where city='Hazel Green' && SIC_code='5411'DB:business_master_new
loadtime:1.5839631557465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelhurst' limit 1
loadtime:1.584037065506 / seconds
Query Executed:select id FROM `wi` where city='Hazelhurst' && SIC_code='5411'DB:business_master_new
loadtime:1.5855782032013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heafford Jct' limit 1
loadtime:1.585648059845 / seconds
Query Executed:select id FROM `wi` where city='Heafford Jct' && SIC_code='5411'DB:business_master_new
loadtime:1.5860650539398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heafford Junction' limit 1
loadtime:1.5861191749573 / seconds
Query Executed:select id FROM `wi` where city='Heafford Junction' && SIC_code='5411'DB:business_master_new
loadtime:1.5865921974182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helenville' limit 1
loadtime:1.5866591930389 / seconds
Query Executed:select id FROM `wi` where city='Helenville' && SIC_code='5411'DB:business_master_new
loadtime:1.5879402160645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herbster' limit 1
loadtime:1.5880081653595 / seconds
Query Executed:select id FROM `wi` where city='Herbster' && SIC_code='5411'DB:business_master_new
loadtime:1.5887031555176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hertel' limit 1
loadtime:1.588769197464 / seconds
Query Executed:select id FROM `wi` where city='Hertel' && SIC_code='5411'DB:business_master_new
loadtime:1.5893380641937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hewitt' limit 1
loadtime:1.5894041061401 / seconds
Query Executed:select id FROM `wi` where city='Hewitt' && SIC_code='5411'DB:business_master_new
loadtime:1.5900900363922 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Bridge' limit 1
loadtime:1.5901432037354 / seconds
Query Executed:select id FROM `wi` where city='High Bridge' && SIC_code='5411'DB:business_master_new
loadtime:1.5907330513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:1.5907890796661 / seconds
Query Executed:select id FROM `wi` where city='Highland' && SIC_code='5411'DB:business_master_new
loadtime:1.5925672054291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilbert' limit 1
loadtime:1.5926361083984 / seconds
Query Executed:select id FROM `wi` where city='Hilbert' && SIC_code='5411'DB:business_master_new
loadtime:1.5951280593872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillpoint' limit 1
loadtime:1.5951950550079 / seconds
Query Executed:select id FROM `wi` where city='Hillpoint' && SIC_code='5411'DB:business_master_new
loadtime:1.5961811542511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.59623503685 / seconds
Query Executed:select id FROM `wi` where city='Hillsboro' && SIC_code='5411'DB:business_master_new
loadtime:1.5993051528931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:1.5993762016296 / seconds
Query Executed:select id FROM `wi` where city='Hillsdale' && SIC_code='5411'DB:business_master_new
loadtime:1.5998191833496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:1.5998740196228 / seconds
Query Executed:select id FROM `wi` where city='Hingham' && SIC_code='5411'DB:business_master_new
loadtime:1.6004900932312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hixton' limit 1
loadtime:1.6005561351776 / seconds
Query Executed:select id FROM `wi` where city='Hixton' && SIC_code='5411'DB:business_master_new
loadtime:1.6021230220795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcombe' limit 1
loadtime:1.6021931171417 / seconds
Query Executed:select id FROM `wi` where city='Holcombe' && SIC_code='5411'DB:business_master_new
loadtime:1.6040081977844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollandale' limit 1
loadtime:1.6040771007538 / seconds
Query Executed:select id FROM `wi` where city='Hollandale' && SIC_code='5411'DB:business_master_new
loadtime:1.6051270961761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holmen' limit 1
loadtime:1.6051950454712 / seconds
Query Executed:select id FROM `wi` where city='Holmen' && SIC_code='5411'DB:business_master_new
loadtime:1.6129031181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:1.6129770278931 / seconds
Query Executed:select id FROM `wi` where city='Honey Creek' && SIC_code='5411'DB:business_master_new
loadtime:1.6135351657867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horicon' limit 1
loadtime:1.6135900020599 / seconds
Query Executed:select id FROM `wi` where city='Horicon' && SIC_code='5411'DB:business_master_new
loadtime:1.616660118103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hortonville' limit 1
loadtime:1.6167330741882 / seconds
Query Executed:select id FROM `wi` where city='Hortonville' && SIC_code='5411'DB:business_master_new
loadtime:1.6233401298523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houlton' limit 1
loadtime:1.6234140396118 / seconds
Query Executed:select id FROM `wi` where city='Houlton' && SIC_code='5411'DB:business_master_new
loadtime:1.6244661808014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howards Grove' limit 1
loadtime:1.6245331764221 / seconds
Query Executed:select id FROM `wi` where city='Howards Grove' && SIC_code='5411'DB:business_master_new
loadtime:1.6249580383301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubertus' limit 1
loadtime:1.6250231266022 / seconds
Query Executed:select id FROM `wi` where city='Hubertus' && SIC_code='5411'DB:business_master_new
loadtime:1.6276710033417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.6277401447296 / seconds
Query Executed:select id FROM `wi` where city='Hudson' && SIC_code='5411'DB:business_master_new
loadtime:1.6466159820557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humbird' limit 1
loadtime:1.6467001438141 / seconds
Query Executed:select id FROM `wi` where city='Humbird' && SIC_code='5411'DB:business_master_new
loadtime:1.6474130153656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:1.6474740505219 / seconds
Query Executed:select id FROM `wi` where city='Hurley' && SIC_code='5411'DB:business_master_new
loadtime:1.6505360603333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustisford' limit 1
loadtime:1.6506080627441 / seconds
Query Executed:select id FROM `wi` where city='Hustisford' && SIC_code='5411'DB:business_master_new
loadtime:1.6519911289215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustler' limit 1
loadtime:1.6520621776581 / seconds
Query Executed:select id FROM `wi` where city='Hustler' && SIC_code='5411'DB:business_master_new
loadtime:1.652626991272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:1.6526811122894 / seconds
Query Executed:select id FROM `wi` where city='Independence' && SIC_code='5411'DB:business_master_new
loadtime:1.6551551818848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingram' limit 1
loadtime:1.6552259922028 / seconds
Query Executed:select id FROM `wi` where city='Ingram' && SIC_code='5411'DB:business_master_new
loadtime:1.6556119918823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iola' limit 1
loadtime:1.6556661128998 / seconds
Query Executed:select id FROM `wi` where city='Iola' && SIC_code='5411'DB:business_master_new
loadtime:1.6582272052765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irma' limit 1
loadtime:1.6583030223846 / seconds
Query Executed:select id FROM `wi` where city='Irma' && SIC_code='5411'DB:business_master_new
loadtime:1.6591441631317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Belt' limit 1
loadtime:1.6591980457306 / seconds
Query Executed:select id FROM `wi` where city='Iron Belt' && SIC_code='5411'DB:business_master_new
loadtime:1.6597011089325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Ridge' limit 1
loadtime:1.6597540378571 / seconds
Query Executed:select id FROM `wi` where city='Iron Ridge' && SIC_code='5411'DB:business_master_new
loadtime:1.6612370014191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron River' limit 1
loadtime:1.6613121032715 / seconds
Query Executed:select id FROM `wi` where city='Iron River' && SIC_code='5411'DB:business_master_new
loadtime:1.6640641689301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ixonia' limit 1
loadtime:1.6641330718994 / seconds
Query Executed:select id FROM `wi` where city='Ixonia' && SIC_code='5411'DB:business_master_new
loadtime:1.6661911010742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.6662690639496 / seconds
Query Executed:select id FROM `wi` where city='Jackson' && SIC_code='5411'DB:business_master_new
loadtime:1.6728491783142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:1.6729221343994 / seconds
Query Executed:select id FROM `wi` where city='Janesville' && SIC_code='5411'DB:business_master_new
loadtime:1.7135901451111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.7137451171875 / seconds
Query Executed:select id FROM `wi` where city='Jefferson' && SIC_code='5411'DB:business_master_new
loadtime:1.7225761413574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jim Falls' limit 1
loadtime:1.7226622104645 / seconds
Query Executed:select id FROM `wi` where city='Jim Falls' && SIC_code='5411'DB:business_master_new
loadtime:1.7236030101776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson Creek' limit 1
loadtime:1.7236711978912 / seconds
Query Executed:select id FROM `wi` where city='Johnson Creek' && SIC_code='5411'DB:business_master_new
loadtime:1.7269840240479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juda' limit 1
loadtime:1.7270531654358 / seconds
Query Executed:select id FROM `wi` where city='Juda' && SIC_code='5411'DB:business_master_new
loadtime:1.7283680438995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jump River' limit 1
loadtime:1.7284409999847 / seconds
Query Executed:select id FROM `wi` where city='Jump River' && SIC_code='5411'DB:business_master_new
loadtime:1.7289199829102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction City' limit 1
loadtime:1.7289860248566 / seconds
Query Executed:select id FROM `wi` where city='Junction City' && SIC_code='5411'DB:business_master_new
loadtime:1.7305281162262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juneau' limit 1
loadtime:1.7305982112885 / seconds
Query Executed:select id FROM `wi` where city='Juneau' && SIC_code='5411'DB:business_master_new
loadtime:1.7337291240692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kansasville' limit 1
loadtime:1.7338020801544 / seconds
Query Executed:select id FROM `wi` where city='Kansasville' && SIC_code='5411'DB:business_master_new
loadtime:1.7355811595917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaukauna' limit 1
loadtime:1.7356491088867 / seconds
Query Executed:select id FROM `wi` where city='Kaukauna' && SIC_code='5411'DB:business_master_new
loadtime:1.749281167984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellnersville' limit 1
loadtime:1.749361038208 / seconds
Query Executed:select id FROM `wi` where city='Kellnersville' && SIC_code='5411'DB:business_master_new
loadtime:1.7498750686646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:1.7499442100525 / seconds
Query Executed:select id FROM `wi` where city='Kendall' && SIC_code='5411'DB:business_master_new
loadtime:1.7514221668243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennan' limit 1
loadtime:1.7514941692352 / seconds
Query Executed:select id FROM `wi` where city='Kennan' && SIC_code='5411'DB:business_master_new
loadtime:1.7521750926971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenosha' limit 1
loadtime:1.7522292137146 / seconds
Query Executed:select id FROM `wi` where city='Kenosha' && SIC_code='5411'DB:business_master_new
loadtime:1.7960760593414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keshena' limit 1
loadtime:1.7962851524353 / seconds
Query Executed:select id FROM `wi` where city='Keshena' && SIC_code='5411'DB:business_master_new
loadtime:1.797993183136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewaskum' limit 1
loadtime:1.7980751991272 / seconds
Query Executed:select id FROM `wi` where city='Kewaskum' && SIC_code='5411'DB:business_master_new
loadtime:1.830726146698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewaunee' limit 1
loadtime:1.8308100700378 / seconds
Query Executed:select id FROM `wi` where city='Kewaunee' && SIC_code='5411'DB:business_master_new
loadtime:1.8643221855164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiel' limit 1
loadtime:1.8644151687622 / seconds
Query Executed:select id FROM `wi` where city='Kiel' && SIC_code='5411'DB:business_master_new
loadtime:1.8960361480713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kieler' limit 1
loadtime:1.8961260318756 / seconds
Query Executed:select id FROM `wi` where city='Kieler' && SIC_code='5411'DB:business_master_new
loadtime:1.8971581459045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimberly' limit 1
loadtime:1.8972251415253 / seconds
Query Executed:select id FROM `wi` where city='Kimberly' && SIC_code='5411'DB:business_master_new
loadtime:1.9003291130066 / seconds
Query loaded from cache:select * from geodata_geocity where city='King' limit 1
loadtime:1.9004030227661 / seconds
Query Executed:select id FROM `wi` where city='King' && SIC_code='5411'DB:business_master_new
loadtime:1.9009680747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.9010231494904 / seconds
Query Executed:select id FROM `wi` where city='Kingston' && SIC_code='5411'DB:business_master_new
loadtime:1.9016411304474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knapp' limit 1
loadtime:1.9016940593719 / seconds
Query Executed:select id FROM `wi` where city='Knapp' && SIC_code='5411'DB:business_master_new
loadtime:1.9026610851288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knowles' limit 1
loadtime:1.9027299880981 / seconds
Query Executed:select id FROM `wi` where city='Knowles' && SIC_code='5411'DB:business_master_new
loadtime:1.9031140804291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kohler' limit 1
loadtime:1.9031682014465 / seconds
Query Executed:select id FROM `wi` where city='Kohler' && SIC_code='5411'DB:business_master_new
loadtime:1.9048871994019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Krakow' limit 1
loadtime:1.9049561023712 / seconds
Query Executed:select id FROM `wi` where city='Krakow' && SIC_code='5411'DB:business_master_new
loadtime:1.9057772159576 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:1.9058442115784 / seconds
Query Executed:select id FROM `wi` where city='La Crosse' && SIC_code='5411'DB:business_master_new
loadtime:1.9444510936737 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Farge' limit 1
loadtime:1.9445950984955 / seconds
Query Executed:select id FROM `wi` where city='La Farge' && SIC_code='5411'DB:business_master_new
loadtime:1.9465692043304 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Pointe' limit 1
loadtime:1.9466450214386 / seconds
Query Executed:select id FROM `wi` where city='La Pointe' && SIC_code='5411'DB:business_master_new
loadtime:1.9479842185974 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Valle' limit 1
loadtime:1.9480531215668 / seconds
Query Executed:select id FROM `wi` where city='La Valle' && SIC_code='5411'DB:business_master_new
loadtime:1.9500501155853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lac Du Flambeau' limit 1
loadtime:1.9501190185547 / seconds
Query Executed:select id FROM `wi` where city='Lac Du Flambeau' && SIC_code='5411'DB:business_master_new
loadtime:1.9518849849701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:1.9519560337067 / seconds
Query Executed:select id FROM `wi` where city='Ladysmith' && SIC_code='5411'DB:business_master_new
loadtime:1.9595341682434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Delton' limit 1
loadtime:1.9596090316772 / seconds
Query Executed:select id FROM `wi` where city='Lake Delton' && SIC_code='5411'DB:business_master_new
loadtime:1.9614861011505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Geneva' limit 1
loadtime:1.9615571498871 / seconds
Query Executed:select id FROM `wi` where city='Lake Geneva' && SIC_code='5411'DB:business_master_new
loadtime:1.9773731231689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:1.9774692058563 / seconds
Query Executed:select id FROM `wi` where city='Lake Mills' && SIC_code='5411'DB:business_master_new
loadtime:1.9846980571747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Nebagamon' limit 1
loadtime:1.9847772121429 / seconds
Query Executed:select id FROM `wi` where city='Lake Nebagamon' && SIC_code='5411'DB:business_master_new
loadtime:1.9861490726471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Tomahawk' limit 1
loadtime:1.9862201213837 / seconds
Query Executed:select id FROM `wi` where city='Lake Tomahawk' && SIC_code='5411'DB:business_master_new
loadtime:1.9875659942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:1.9876329898834 / seconds
Query Executed:select id FROM `wi` where city='Lakewood' && SIC_code='5411'DB:business_master_new
loadtime:1.9894971847534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.9895670413971 / seconds
Query Executed:select id FROM `wi` where city='Lancaster' && SIC_code='5411'DB:business_master_new
loadtime:1.9978811740875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Land O Lakes' limit 1
loadtime:1.9979560375214 / seconds
Query Executed:select id FROM `wi` where city='Land O Lakes' && SIC_code='5411'DB:business_master_new
loadtime:1.9999251365662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lannon' limit 1
loadtime:1.9999961853027 / seconds
Query Executed:select id FROM `wi` where city='Lannon' && SIC_code='5411'DB:business_master_new
loadtime:2.0016400814056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laona' limit 1
loadtime:2.001697063446 / seconds
Query Executed:select id FROM `wi` where city='Laona' && SIC_code='5411'DB:business_master_new
loadtime:2.0031681060791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larsen' limit 1
loadtime:2.0032370090485 / seconds
Query Executed:select id FROM `wi` where city='Larsen' && SIC_code='5411'DB:business_master_new
loadtime:2.004753112793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:2.0048232078552 / seconds
Query Executed:select id FROM `wi` where city='Lebanon' && SIC_code='5411'DB:business_master_new
loadtime:2.005389213562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lena' limit 1
loadtime:2.0054471492767 / seconds
Query Executed:select id FROM `wi` where city='Lena' && SIC_code='5411'DB:business_master_new
loadtime:2.0076611042023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leopolis' limit 1
loadtime:2.0077311992645 / seconds
Query Executed:select id FROM `wi` where city='Leopolis' && SIC_code='5411'DB:business_master_new
loadtime:2.0083301067352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:2.008385181427 / seconds
Query Executed:select id FROM `wi` where city='Lewis' && SIC_code='5411'DB:business_master_new
loadtime:2.0088171958923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lily' limit 1
loadtime:2.0088710784912 / seconds
Query Executed:select id FROM `wi` where city='Lily' && SIC_code='5411'DB:business_master_new
loadtime:2.0093061923981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Ridge' limit 1
loadtime:2.0093581676483 / seconds
Query Executed:select id FROM `wi` where city='Lime Ridge' && SIC_code='5411'DB:business_master_new
loadtime:2.0099201202393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limeridge' limit 1
loadtime:2.0099730491638 / seconds
Query Executed:select id FROM `wi` where city='Limeridge' && SIC_code='5411'DB:business_master_new
loadtime:2.0103430747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:2.0103950500488 / seconds
Query Executed:select id FROM `wi` where city='Linden' && SIC_code='5411'DB:business_master_new
loadtime:2.0109841823578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Chute' limit 1
loadtime:2.011036157608 / seconds
Query Executed:select id FROM `wi` where city='Little Chute' && SIC_code='5411'DB:business_master_new
loadtime:2.0177240371704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Suamico' limit 1
loadtime:2.0177960395813 / seconds
Query Executed:select id FROM `wi` where city='Little Suamico' && SIC_code='5411'DB:business_master_new
loadtime:2.0191900730133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:2.0192451477051 / seconds
Query Executed:select id FROM `wi` where city='Livingston' && SIC_code='5411'DB:business_master_new
loadtime:2.0204331874847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodi' limit 1
loadtime:2.0205030441284 / seconds
Query Executed:select id FROM `wi` where city='Lodi' && SIC_code='5411'DB:business_master_new
loadtime:2.0279591083527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loganville' limit 1
loadtime:2.0280342102051 / seconds
Query Executed:select id FROM `wi` where city='Loganville' && SIC_code='5411'DB:business_master_new
loadtime:2.0293080806732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lomira' limit 1
loadtime:2.0293800830841 / seconds
Query Executed:select id FROM `wi` where city='Lomira' && SIC_code='5411'DB:business_master_new
loadtime:2.0316259860992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:2.0316932201385 / seconds
Query Executed:select id FROM `wi` where city='Lone Rock' && SIC_code='5411'DB:business_master_new
loadtime:2.0332071781158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Lake' limit 1
loadtime:2.0332951545715 / seconds
Query Executed:select id FROM `wi` where city='Long Lake' && SIC_code='5411'DB:business_master_new
loadtime:2.0341210365295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretta' limit 1
loadtime:2.0341889858246 / seconds
Query Executed:select id FROM `wi` where city='Loretta' && SIC_code='5411'DB:business_master_new
loadtime:2.0346291065216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:2.0346841812134 / seconds
Query Executed:select id FROM `wi` where city='Lowell' && SIC_code='5411'DB:business_master_new
loadtime:2.0353760719299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loyal' limit 1
loadtime:2.0354340076447 / seconds
Query Executed:select id FROM `wi` where city='Loyal' && SIC_code='5411'DB:business_master_new
loadtime:2.0377039909363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lublin' limit 1
loadtime:2.0377750396729 / seconds
Query Executed:select id FROM `wi` where city='Lublin' && SIC_code='5411'DB:business_master_new
loadtime:2.0384590625763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luck' limit 1
loadtime:2.0385141372681 / seconds
Query Executed:select id FROM `wi` where city='Luck' && SIC_code='5411'DB:business_master_new
loadtime:2.041451215744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:2.0415241718292 / seconds
Query Executed:select id FROM `wi` where city='Luxemburg' && SIC_code='5411'DB:business_master_new
loadtime:2.074187040329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Station' limit 1
loadtime:2.074294090271 / seconds
Query Executed:select id FROM `wi` where city='Lyndon Station' && SIC_code='5411'DB:business_master_new
loadtime:2.0758330821991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynxville' limit 1
loadtime:2.0759010314941 / seconds
Query Executed:select id FROM `wi` where city='Lynxville' && SIC_code='5411'DB:business_master_new
loadtime:2.0763700008392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:2.0764281749725 / seconds
Query Executed:select id FROM `wi` where city='Lyons' && SIC_code='5411'DB:business_master_new
loadtime:2.0771501064301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:2.0772161483765 / seconds
Query Executed:select id FROM `wi` where city='Madison' && SIC_code='5411'DB:business_master_new
loadtime:2.1118500232697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maiden Rock' limit 1
loadtime:2.1121711730957 / seconds
Query Executed:select id FROM `wi` where city='Maiden Rock' && SIC_code='5411'DB:business_master_new
loadtime:2.113352060318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malone' limit 1
loadtime:2.1134300231934 / seconds
Query Executed:select id FROM `wi` where city='Malone' && SIC_code='5411'DB:business_master_new
loadtime:2.1149530410767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manawa' limit 1
loadtime:2.1150200366974 / seconds
Query Executed:select id FROM `wi` where city='Manawa' && SIC_code='5411'DB:business_master_new
loadtime:2.1178500652313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:2.1179242134094 / seconds
Query Executed:select id FROM `wi` where city='Manchester' && SIC_code='5411'DB:business_master_new
loadtime:2.1183431148529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowish Waters' limit 1
loadtime:2.1183981895447 / seconds
Query Executed:select id FROM `wi` where city='Manitowish Waters' && SIC_code='5411'DB:business_master_new
loadtime:2.1203510761261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowish Wtrs' limit 1
loadtime:2.1204240322113 / seconds
Query Executed:select id FROM `wi` where city='Manitowish Wtrs' && SIC_code='5411'DB:business_master_new
loadtime:2.120857000351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowoc' limit 1
loadtime:2.120913028717 / seconds
Query Executed:select id FROM `wi` where city='Manitowoc' && SIC_code='5411'DB:business_master_new
loadtime:2.1482632160187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple' limit 1
loadtime:2.1483881473541 / seconds
Query Executed:select id FROM `wi` where city='Maple' && SIC_code='5411'DB:business_master_new
loadtime:2.1493971347809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplewood' limit 1
loadtime:2.1494610309601 / seconds
Query Executed:select id FROM `wi` where city='Maplewood' && SIC_code='5411'DB:business_master_new
loadtime:2.1499791145325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:2.1500310897827 / seconds
Query Executed:select id FROM `wi` where city='Marathon' && SIC_code='5411'DB:business_master_new
loadtime:2.1532111167908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:2.1532981395721 / seconds
Query Executed:select id FROM `wi` where city='Marengo' && SIC_code='5411'DB:business_master_new
loadtime:2.1541121006012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maribel' limit 1
loadtime:2.154167175293 / seconds
Query Executed:select id FROM `wi` where city='Maribel' && SIC_code='5411'DB:business_master_new
loadtime:2.1554880142212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marinette' limit 1
loadtime:2.1555562019348 / seconds
Query Executed:select id FROM `wi` where city='Marinette' && SIC_code='5411'DB:business_master_new
loadtime:2.1684801578522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:2.1685659885406 / seconds
Query Executed:select id FROM `wi` where city='Marion' && SIC_code='5411'DB:business_master_new
loadtime:2.1711890697479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markesan' limit 1
loadtime:2.1712729930878 / seconds
Query Executed:select id FROM `wi` where city='Markesan' && SIC_code='5411'DB:business_master_new
loadtime:2.1743211746216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:2.1743931770325 / seconds
Query Executed:select id FROM `wi` where city='Marquette' && SIC_code='5411'DB:business_master_new
loadtime:2.1749920845032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:2.1750471591949 / seconds
Query Executed:select id FROM `wi` where city='Marshall' && SIC_code='5411'DB:business_master_new
loadtime:2.1781470775604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:2.1782190799713 / seconds
Query Executed:select id FROM `wi` where city='Marshfield' && SIC_code='5411'DB:business_master_new
loadtime:2.1963791847229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:2.196485042572 / seconds
Query Executed:select id FROM `wi` where city='Mason' && SIC_code='5411'DB:business_master_new
loadtime:2.1978321075439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mather' limit 1
loadtime:2.1979022026062 / seconds
Query Executed:select id FROM `wi` where city='Mather' && SIC_code='5411'DB:business_master_new
loadtime:2.1984131336212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattoon' limit 1
loadtime:2.1984732151031 / seconds
Query Executed:select id FROM `wi` where city='Mattoon' && SIC_code='5411'DB:business_master_new
loadtime:2.1992011070251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauston' limit 1
loadtime:2.1992771625519 / seconds
Query Executed:select id FROM `wi` where city='Mauston' && SIC_code='5411'DB:business_master_new
loadtime:2.20774102211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayville' limit 1
loadtime:2.2078201770782 / seconds
Query Executed:select id FROM `wi` where city='Mayville' && SIC_code='5411'DB:business_master_new
loadtime:2.2403240203857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mazomanie' limit 1
loadtime:2.2404110431671 / seconds
Query Executed:select id FROM `wi` where city='Mazomanie' && SIC_code='5411'DB:business_master_new
loadtime:2.2430090904236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farland' limit 1
loadtime:2.2430791854858 / seconds
Query Executed:select id FROM `wi` where city='Mc Farland' && SIC_code='5411'DB:business_master_new
loadtime:2.2507960796356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Naughton' limit 1
loadtime:2.250871181488 / seconds
Query Executed:select id FROM `wi` where city='Mc Naughton' && SIC_code='5411'DB:business_master_new
loadtime:2.2513370513916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:2.2513921260834 / seconds
Query Executed:select id FROM `wi` where city='Medford' && SIC_code='5411'DB:business_master_new
loadtime:2.2620160579681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellen' limit 1
loadtime:2.2620921134949 / seconds
Query Executed:select id FROM `wi` where city='Mellen' && SIC_code='5411'DB:business_master_new
loadtime:2.2633361816406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:2.263414144516 / seconds
Query Executed:select id FROM `wi` where city='Melrose' && SIC_code='5411'DB:business_master_new
loadtime:2.2650179862976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menasha' limit 1
loadtime:2.2651090621948 / seconds
Query Executed:select id FROM `wi` where city='Menasha' && SIC_code='5411'DB:business_master_new
loadtime:2.2778060436249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menomonee Falls' limit 1
loadtime:2.2778921127319 / seconds
Query Executed:select id FROM `wi` where city='Menomonee Falls' && SIC_code='5411'DB:business_master_new
loadtime:2.3012900352478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menomonie' limit 1
loadtime:2.301390171051 / seconds
Query Executed:select id FROM `wi` where city='Menomonie' && SIC_code='5411'DB:business_master_new
loadtime:2.3190820217133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mequon' limit 1
loadtime:2.3192591667175 / seconds
Query Executed:select id FROM `wi` where city='Mequon' && SIC_code='5411'DB:business_master_new
loadtime:2.3458290100098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mercer' limit 1
loadtime:2.3459320068359 / seconds
Query Executed:select id FROM `wi` where city='Mercer' && SIC_code='5411'DB:business_master_new
loadtime:2.3482220172882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:2.3483049869537 / seconds
Query Executed:select id FROM `wi` where city='Merrill' && SIC_code='5411'DB:business_master_new
loadtime:2.3609371185303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrillan' limit 1
loadtime:2.3610241413116 / seconds
Query Executed:select id FROM `wi` where city='Merrillan' && SIC_code='5411'DB:business_master_new
loadtime:2.3622860908508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:2.3623621463776 / seconds
Query Executed:select id FROM `wi` where city='Merrimac' && SIC_code='5411'DB:business_master_new
loadtime:2.363517999649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merton' limit 1
loadtime:2.3635880947113 / seconds
Query Executed:select id FROM `wi` where city='Merton' && SIC_code='5411'DB:business_master_new
loadtime:2.3644411563873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Inlet' limit 1
loadtime:2.3644959926605 / seconds
Query Executed:select id FROM `wi` where city='Middle Inlet' && SIC_code='5411'DB:business_master_new
loadtime:2.3648970127106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:2.3649621009827 / seconds
Query Executed:select id FROM `wi` where city='Middleton' && SIC_code='5411'DB:business_master_new
loadtime:2.3858079910278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikana' limit 1
loadtime:2.3859121799469 / seconds
Query Executed:select id FROM `wi` where city='Mikana' && SIC_code='5411'DB:business_master_new
loadtime:2.3865261077881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:2.3866050243378 / seconds
Query Executed:select id FROM `wi` where city='Milan' && SIC_code='5411'DB:business_master_new
loadtime:2.3870711326599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milladore' limit 1
loadtime:2.3871359825134 / seconds
Query Executed:select id FROM `wi` where city='Milladore' && SIC_code='5411'DB:business_master_new
loadtime:2.3882920742035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millston' limit 1
loadtime:2.3883681297302 / seconds
Query Executed:select id FROM `wi` where city='Millston' && SIC_code='5411'DB:business_master_new
loadtime:2.3889191150665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milltown' limit 1
loadtime:2.3889942169189 / seconds
Query Executed:select id FROM `wi` where city='Milltown' && SIC_code='5411'DB:business_master_new
loadtime:2.3909530639648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:2.3910341262817 / seconds
Query Executed:select id FROM `wi` where city='Milton' && SIC_code='5411'DB:business_master_new
loadtime:2.3987231254578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukee' limit 1
loadtime:2.3988091945648 / seconds
Query Executed:select id FROM `wi` where city='Milwaukee' && SIC_code='5411'DB:business_master_new
loadtime:2.4348201751709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mindoro' limit 1
loadtime:2.4357440471649 / seconds
Query Executed:select id FROM `wi` where city='Mindoro' && SIC_code='5411'DB:business_master_new
loadtime:2.4369060993195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Point' limit 1
loadtime:2.4370331764221 / seconds
Query Executed:select id FROM `wi` where city='Mineral Point' && SIC_code='5411'DB:business_master_new
loadtime:2.4411160945892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minocqua' limit 1
loadtime:2.4411962032318 / seconds
Query Executed:select id FROM `wi` where city='Minocqua' && SIC_code='5411'DB:business_master_new
loadtime:2.4520151615143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minong' limit 1
loadtime:2.4521090984344 / seconds
Query Executed:select id FROM `wi` where city='Minong' && SIC_code='5411'DB:business_master_new
loadtime:2.4542729854584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mishicot' limit 1
loadtime:2.4543550014496 / seconds
Query Executed:select id FROM `wi` where city='Mishicot' && SIC_code='5411'DB:business_master_new
loadtime:2.4564120769501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modena' limit 1
loadtime:2.456493139267 / seconds
Query Executed:select id FROM `wi` where city='Modena' && SIC_code='5411'DB:business_master_new
loadtime:2.4569430351257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondovi' limit 1
loadtime:2.4570062160492 / seconds
Query Executed:select id FROM `wi` where city='Mondovi' && SIC_code='5411'DB:business_master_new
loadtime:2.4898710250854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monico' limit 1
loadtime:2.4900031089783 / seconds
Query Executed:select id FROM `wi` where city='Monico' && SIC_code='5411'DB:business_master_new
loadtime:2.490599155426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:2.490700006485 / seconds
Query Executed:select id FROM `wi` where city='Monona' && SIC_code='5411'DB:business_master_new
loadtime:2.491277217865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.4913401603699 / seconds
Query Executed:select id FROM `wi` where city='Monroe' && SIC_code='5411'DB:business_master_new
loadtime:2.5096971988678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montello' limit 1
loadtime:2.5098230838776 / seconds
Query Executed:select id FROM `wi` where city='Montello' && SIC_code='5411'DB:business_master_new
loadtime:2.543074131012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montfort' limit 1
loadtime:2.543154001236 / seconds
Query Executed:select id FROM `wi` where city='Montfort' && SIC_code='5411'DB:business_master_new
loadtime:2.5445241928101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:2.5445940494537 / seconds
Query Executed:select id FROM `wi` where city='Monticello' && SIC_code='5411'DB:business_master_new
loadtime:2.5467450618744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montreal' limit 1
loadtime:2.546816110611 / seconds
Query Executed:select id FROM `wi` where city='Montreal' && SIC_code='5411'DB:business_master_new
loadtime:2.5475521087646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisonville' limit 1
loadtime:2.5476090908051 / seconds
Query Executed:select id FROM `wi` where city='Morrisonville' && SIC_code='5411'DB:business_master_new
loadtime:2.5481951236725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosinee' limit 1
loadtime:2.5482521057129 / seconds
Query Executed:select id FROM `wi` where city='Mosinee' && SIC_code='5411'DB:business_master_new
loadtime:2.5595531463623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Calvary' limit 1
loadtime:2.5596342086792 / seconds
Query Executed:select id FROM `wi` where city='Mount Calvary' && SIC_code='5411'DB:business_master_new
loadtime:2.5611472129822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Hope' limit 1
loadtime:2.5612151622772 / seconds
Query Executed:select id FROM `wi` where city='Mount Hope' && SIC_code='5411'DB:business_master_new
loadtime:2.5621321201324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Horeb' limit 1
loadtime:2.5621860027313 / seconds
Query Executed:select id FROM `wi` where city='Mount Horeb' && SIC_code='5411'DB:business_master_new
loadtime:2.5715939998627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:2.5716681480408 / seconds
Query Executed:select id FROM `wi` where city='Mount Sterling' && SIC_code='5411'DB:business_master_new
loadtime:2.5721261501312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain' limit 1
loadtime:2.5721800327301 / seconds
Query Executed:select id FROM `wi` where city='Mountain' && SIC_code='5411'DB:business_master_new
loadtime:2.573655128479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Calvary' limit 1
loadtime:2.573723077774 / seconds
Query Executed:select id FROM `wi` where city='Mt Calvary' && SIC_code='5411'DB:business_master_new
loadtime:2.5741240978241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Hope' limit 1
loadtime:2.5741770267487 / seconds
Query Executed:select id FROM `wi` where city='Mt Hope' && SIC_code='5411'DB:business_master_new
loadtime:2.5745670795441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Horeb' limit 1
loadtime:2.5746200084686 / seconds
Query Executed:select id FROM `wi` where city='Mt Horeb' && SIC_code='5411'DB:business_master_new
loadtime:2.5751340389252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:2.5751850605011 / seconds
Query Executed:select id FROM `wi` where city='Mt Sterling' && SIC_code='5411'DB:business_master_new
loadtime:2.5756270885468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mukwonago' limit 1
loadtime:2.5756800174713 / seconds
Query Executed:select id FROM `wi` where city='Mukwonago' && SIC_code='5411'DB:business_master_new
loadtime:2.5865061283112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscoda' limit 1
loadtime:2.5865821838379 / seconds
Query Executed:select id FROM `wi` where city='Muscoda' && SIC_code='5411'DB:business_master_new
loadtime:2.5891301631927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskego' limit 1
loadtime:2.5892131328583 / seconds
Query Executed:select id FROM `wi` where city='Muskego' && SIC_code='5411'DB:business_master_new
loadtime:2.6015791893005 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Fond Du Lac' limit 1
loadtime:2.6016581058502 / seconds
Query Executed:select id FROM `wi` where city='N Fond Du Lac' && SIC_code='5411'DB:business_master_new
loadtime:2.6020591259003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashotah' limit 1
loadtime:2.6021130084991 / seconds
Query Executed:select id FROM `wi` where city='Nashotah' && SIC_code='5411'DB:business_master_new
loadtime:2.6040530204773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navarino' limit 1
loadtime:2.604120016098 / seconds
Query Executed:select id FROM `wi` where city='Navarino' && SIC_code='5411'DB:business_master_new
loadtime:2.6045391559601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Necedah' limit 1
loadtime:2.6045939922333 / seconds
Query Executed:select id FROM `wi` where city='Necedah' && SIC_code='5411'DB:business_master_new
loadtime:2.6070230007172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neenah' limit 1
loadtime:2.6070940494537 / seconds
Query Executed:select id FROM `wi` where city='Neenah' && SIC_code='5411'DB:business_master_new
loadtime:2.6299409866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neillsville' limit 1
loadtime:2.630035161972 / seconds
Query Executed:select id FROM `wi` where city='Neillsville' && SIC_code='5411'DB:business_master_new
loadtime:2.6376161575317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nekoosa' limit 1
loadtime:2.6376931667328 / seconds
Query Executed:select id FROM `wi` where city='Nekoosa' && SIC_code='5411'DB:business_master_new
loadtime:2.670746088028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:2.6708190441132 / seconds
Query Executed:select id FROM `wi` where city='Nelson' && SIC_code='5411'DB:business_master_new
loadtime:2.6719381809235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonville' limit 1
loadtime:2.6720051765442 / seconds
Query Executed:select id FROM `wi` where city='Nelsonville' && SIC_code='5411'DB:business_master_new
loadtime:2.6725761890411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neopit' limit 1
loadtime:2.672641992569 / seconds
Query Executed:select id FROM `wi` where city='Neopit' && SIC_code='5411'DB:business_master_new
loadtime:2.6732220649719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neosho' limit 1
loadtime:2.67329621315 / seconds
Query Executed:select id FROM `wi` where city='Neosho' && SIC_code='5411'DB:business_master_new
loadtime:2.6746320724487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neshkoro' limit 1
loadtime:2.6747012138367 / seconds
Query Executed:select id FROM `wi` where city='Neshkoro' && SIC_code='5411'DB:business_master_new
loadtime:2.6764030456543 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Auburn' limit 1
loadtime:2.6764731407166 / seconds
Query Executed:select id FROM `wi` where city='New Auburn' && SIC_code='5411'DB:business_master_new
loadtime:2.6789660453796 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Berlin' limit 1
loadtime:2.6790540218353 / seconds
Query Executed:select id FROM `wi` where city='New Berlin' && SIC_code='5411'DB:business_master_new
loadtime:2.7024760246277 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Franken' limit 1
loadtime:2.7025640010834 / seconds
Query Executed:select id FROM `wi` where city='New Franken' && SIC_code='5411'DB:business_master_new
loadtime:2.7051219940186 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Glarus' limit 1
loadtime:2.7051930427551 / seconds
Query Executed:select id FROM `wi` where city='New Glarus' && SIC_code='5411'DB:business_master_new
loadtime:2.7082891464233 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holstein' limit 1
loadtime:2.7083570957184 / seconds
Query Executed:select id FROM `wi` where city='New Holstein' && SIC_code='5411'DB:business_master_new
loadtime:2.7114291191101 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lisbon' limit 1
loadtime:2.7115020751953 / seconds
Query Executed:select id FROM `wi` where city='New Lisbon' && SIC_code='5411'DB:business_master_new
loadtime:2.7142491340637 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:2.7143220901489 / seconds
Query Executed:select id FROM `wi` where city='New London' && SIC_code='5411'DB:business_master_new
loadtime:2.7241160869598 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Munster' limit 1
loadtime:2.7242012023926 / seconds
Query Executed:select id FROM `wi` where city='New Munster' && SIC_code='5411'DB:business_master_new
loadtime:2.7248380184174 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Richmond' limit 1
loadtime:2.724906206131 / seconds
Query Executed:select id FROM `wi` where city='New Richmond' && SIC_code='5411'DB:business_master_new
loadtime:2.7363860607147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newald' limit 1
loadtime:2.7364740371704 / seconds
Query Executed:select id FROM `wi` where city='Newald' && SIC_code='5411'DB:business_master_new
loadtime:2.7368831634521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburg' limit 1
loadtime:2.7369401454926 / seconds
Query Executed:select id FROM `wi` where city='Newburg' && SIC_code='5411'DB:business_master_new
loadtime:2.7377440929413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:2.7377982139587 / seconds
Query Executed:select id FROM `wi` where city='Newton' && SIC_code='5411'DB:business_master_new
loadtime:2.7391521930695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niagara' limit 1
loadtime:2.7392120361328 / seconds
Query Executed:select id FROM `wi` where city='Niagara' && SIC_code='5411'DB:business_master_new
loadtime:2.7419102191925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:2.7419810295105 / seconds
Query Executed:select id FROM `wi` where city='Nichols' && SIC_code='5411'DB:business_master_new
loadtime:2.7425601482391 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Freedom' limit 1
loadtime:2.7426280975342 / seconds
Query Executed:select id FROM `wi` where city='North Freedom' && SIC_code='5411'DB:business_master_new
loadtime:2.744148015976 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Lake' limit 1
loadtime:2.7442162036896 / seconds
Query Executed:select id FROM `wi` where city='North Lake' && SIC_code='5411'DB:business_master_new
loadtime:2.7450950145721 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Prairie' limit 1
loadtime:2.7451610565186 / seconds
Query Executed:select id FROM `wi` where city='North Prairie' && SIC_code='5411'DB:business_master_new
loadtime:2.7470860481262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:2.7471530437469 / seconds
Query Executed:select id FROM `wi` where city='Norwalk' && SIC_code='5411'DB:business_master_new
loadtime:2.748633146286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Creek' limit 1
loadtime:2.7487041950226 / seconds
Query Executed:select id FROM `wi` where city='Oak Creek' && SIC_code='5411'DB:business_master_new
loadtime:2.7631130218506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:2.7632031440735 / seconds
Query Executed:select id FROM `wi` where city='Oakdale' && SIC_code='5411'DB:business_master_new
loadtime:2.7639601230621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakfield' limit 1
loadtime:2.7640290260315 / seconds
Query Executed:select id FROM `wi` where city='Oakfield' && SIC_code='5411'DB:business_master_new
loadtime:2.7654931545258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconomowoc' limit 1
loadtime:2.7655601501465 / seconds
Query Executed:select id FROM `wi` where city='Oconomowoc' && SIC_code='5411'DB:business_master_new
loadtime:2.7860751152039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconto' limit 1
loadtime:2.7861700057983 / seconds
Query Executed:select id FROM `wi` where city='Oconto' && SIC_code='5411'DB:business_master_new
loadtime:2.7933812141418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconto Falls' limit 1
loadtime:2.7934761047363 / seconds
Query Executed:select id FROM `wi` where city='Oconto Falls' && SIC_code='5411'DB:business_master_new
loadtime:2.8261201381683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odanah' limit 1
loadtime:2.8262150287628 / seconds
Query Executed:select id FROM `wi` where city='Odanah' && SIC_code='5411'DB:business_master_new
loadtime:2.8271970748901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogdensburg' limit 1
loadtime:2.8272709846497 / seconds
Query Executed:select id FROM `wi` where city='Ogdensburg' && SIC_code='5411'DB:business_master_new
loadtime:2.8282940387726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogema' limit 1
loadtime:2.8283619880676 / seconds
Query Executed:select id FROM `wi` where city='Ogema' && SIC_code='5411'DB:business_master_new
loadtime:2.8294370174408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojibwa' limit 1
loadtime:2.8295061588287 / seconds
Query Executed:select id FROM `wi` where city='Ojibwa' && SIC_code='5411'DB:business_master_new
loadtime:2.8301270008087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okauchee' limit 1
loadtime:2.8301811218262 / seconds
Query Executed:select id FROM `wi` where city='Okauchee' && SIC_code='5411'DB:business_master_new
loadtime:2.8313610553741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omro' limit 1
loadtime:2.8314380645752 / seconds
Query Executed:select id FROM `wi` where city='Omro' && SIC_code='5411'DB:business_master_new
loadtime:2.8630740642548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onalaska' limit 1
loadtime:2.8631551265717 / seconds
Query Executed:select id FROM `wi` where city='Onalaska' && SIC_code='5411'DB:business_master_new
loadtime:2.8767731189728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneida' limit 1
loadtime:2.8768620491028 / seconds
Query Executed:select id FROM `wi` where city='Oneida' && SIC_code='5411'DB:business_master_new
loadtime:2.8798091411591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontario' limit 1
loadtime:2.8798811435699 / seconds
Query Executed:select id FROM `wi` where city='Ontario' && SIC_code='5411'DB:business_master_new
loadtime:2.8811521530151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oostburg' limit 1
loadtime:2.8812251091003 / seconds
Query Executed:select id FROM `wi` where city='Oostburg' && SIC_code='5411'DB:business_master_new
loadtime:2.8841550350189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oregon' limit 1
loadtime:2.8842251300812 / seconds
Query Executed:select id FROM `wi` where city='Oregon' && SIC_code='5411'DB:business_master_new
loadtime:2.8937129974365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orfordville' limit 1
loadtime:2.8937911987305 / seconds
Query Executed:select id FROM `wi` where city='Orfordville' && SIC_code='5411'DB:business_master_new
loadtime:2.8952631950378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:2.8953301906586 / seconds
Query Executed:select id FROM `wi` where city='Osceola' && SIC_code='5411'DB:business_master_new
loadtime:2.9275410175323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshkosh' limit 1
loadtime:2.9276280403137 / seconds
Query Executed:select id FROM `wi` where city='Oshkosh' && SIC_code='5411'DB:business_master_new
loadtime:2.9695889949799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osseo' limit 1
loadtime:2.9697341918945 / seconds
Query Executed:select id FROM `wi` where city='Osseo' && SIC_code='5411'DB:business_master_new
loadtime:3.0019261837006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owen' limit 1
loadtime:3.0020170211792 / seconds
Query Executed:select id FROM `wi` where city='Owen' && SIC_code='5411'DB:business_master_new
loadtime:3.0039031505585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:3.0039730072021 / seconds
Query Executed:select id FROM `wi` where city='Oxford' && SIC_code='5411'DB:business_master_new
loadtime:3.0062210559845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwaukee' limit 1
loadtime:3.0062952041626 / seconds
Query Executed:select id FROM `wi` where city='Packwaukee' && SIC_code='5411'DB:business_master_new
loadtime:3.0068800449371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:3.0069479942322 / seconds
Query Executed:select id FROM `wi` where city='Palmyra' && SIC_code='5411'DB:business_master_new
loadtime:3.0090870857239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pardeeville' limit 1
loadtime:3.0091550350189 / seconds
Query Executed:select id FROM `wi` where city='Pardeeville' && SIC_code='5411'DB:business_master_new
loadtime:3.0404710769653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Falls' limit 1
loadtime:3.040549993515 / seconds
Query Executed:select id FROM `wi` where city='Park Falls' && SIC_code='5411'DB:business_master_new
loadtime:3.0474720001221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patch Grove' limit 1
loadtime:3.0475521087646 / seconds
Query Executed:select id FROM `wi` where city='Patch Grove' && SIC_code='5411'DB:business_master_new
loadtime:3.0481090545654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearson' limit 1
loadtime:3.0481641292572 / seconds
Query Executed:select id FROM `wi` where city='Pearson' && SIC_code='5411'DB:business_master_new
loadtime:3.0486941337585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelican Lake' limit 1
loadtime:3.0487630367279 / seconds
Query Executed:select id FROM `wi` where city='Pelican Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.049681186676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pell Lake' limit 1
loadtime:3.0497481822968 / seconds
Query Executed:select id FROM `wi` where city='Pell Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.050549030304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembine' limit 1
loadtime:3.0506172180176 / seconds
Query Executed:select id FROM `wi` where city='Pembine' && SIC_code='5411'DB:business_master_new
loadtime:3.0519230365753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pence' limit 1
loadtime:3.0519940853119 / seconds
Query Executed:select id FROM `wi` where city='Pence' && SIC_code='5411'DB:business_master_new
loadtime:3.0524251461029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepin' limit 1
loadtime:3.0524799823761 / seconds
Query Executed:select id FROM `wi` where city='Pepin' && SIC_code='5411'DB:business_master_new
loadtime:3.0543591976166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peshtigo' limit 1
loadtime:3.0544440746307 / seconds
Query Executed:select id FROM `wi` where city='Peshtigo' && SIC_code='5411'DB:business_master_new
loadtime:3.0877130031586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pewaukee' limit 1
loadtime:3.0878121852875 / seconds
Query Executed:select id FROM `wi` where city='Pewaukee' && SIC_code='5411'DB:business_master_new
loadtime:3.1049280166626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phelps' limit 1
loadtime:3.1050310134888 / seconds
Query Executed:select id FROM `wi` where city='Phelps' && SIC_code='5411'DB:business_master_new
loadtime:3.1065101623535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillips' limit 1
loadtime:3.1065831184387 / seconds
Query Executed:select id FROM `wi` where city='Phillips' && SIC_code='5411'DB:business_master_new
loadtime:3.1141891479492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phlox' limit 1
loadtime:3.1142661571503 / seconds
Query Executed:select id FROM `wi` where city='Phlox' && SIC_code='5411'DB:business_master_new
loadtime:3.1147570610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickerel' limit 1
loadtime:3.114823102951 / seconds
Query Executed:select id FROM `wi` where city='Pickerel' && SIC_code='5411'DB:business_master_new
loadtime:3.1157610416412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickett' limit 1
loadtime:3.115828037262 / seconds
Query Executed:select id FROM `wi` where city='Pickett' && SIC_code='5411'DB:business_master_new
loadtime:3.1169900894165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pigeon Falls' limit 1
loadtime:3.117044210434 / seconds
Query Executed:select id FROM `wi` where city='Pigeon Falls' && SIC_code='5411'DB:business_master_new
loadtime:3.1177871227264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine River' limit 1
loadtime:3.1178550720215 / seconds
Query Executed:select id FROM `wi` where city='Pine River' && SIC_code='5411'DB:business_master_new
loadtime:3.1187260150909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:3.1187801361084 / seconds
Query Executed:select id FROM `wi` where city='Pittsville' && SIC_code='5411'DB:business_master_new
loadtime:3.1207640171051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain' limit 1
loadtime:3.120833158493 / seconds
Query Executed:select id FROM `wi` where city='Plain' && SIC_code='5411'DB:business_master_new
loadtime:3.1223649978638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:3.122444152832 / seconds
Query Executed:select id FROM `wi` where city='Plainfield' && SIC_code='5411'DB:business_master_new
loadtime:3.1245770454407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platteville' limit 1
loadtime:3.124655008316 / seconds
Query Executed:select id FROM `wi` where city='Platteville' && SIC_code='5411'DB:business_master_new
loadtime:3.1357200145721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Prairie' limit 1
loadtime:3.1357970237732 / seconds
Query Executed:select id FROM `wi` where city='Pleasant Prairie' && SIC_code='5411'DB:business_master_new
loadtime:3.1442301273346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:3.1443049907684 / seconds
Query Executed:select id FROM `wi` where city='Plover' && SIC_code='5411'DB:business_master_new
loadtime:3.1536900997162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plum City' limit 1
loadtime:3.1537721157074 / seconds
Query Executed:select id FROM `wi` where city='Plum City' && SIC_code='5411'DB:business_master_new
loadtime:3.1551990509033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:3.1552751064301 / seconds
Query Executed:select id FROM `wi` where city='Plymouth' && SIC_code='5411'DB:business_master_new
loadtime:3.1667931079865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplar' limit 1
loadtime:3.1668720245361 / seconds
Query Executed:select id FROM `wi` where city='Poplar' && SIC_code='5411'DB:business_master_new
loadtime:3.1680071353912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Edwards' limit 1
loadtime:3.168074131012 / seconds
Query Executed:select id FROM `wi` where city='Port Edwards' && SIC_code='5411'DB:business_master_new
loadtime:3.1693069934845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Washington' limit 1
loadtime:3.1693739891052 / seconds
Query Executed:select id FROM `wi` where city='Port Washington' && SIC_code='5411'DB:business_master_new
loadtime:3.1796162128448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Wing' limit 1
loadtime:3.1796882152557 / seconds
Query Executed:select id FROM `wi` where city='Port Wing' && SIC_code='5411'DB:business_master_new
loadtime:3.1806790828705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:3.1807470321655 / seconds
Query Executed:select id FROM `wi` where city='Portage' && SIC_code='5411'DB:business_master_new
loadtime:3.1937971115112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porterfield' limit 1
loadtime:3.1938772201538 / seconds
Query Executed:select id FROM `wi` where city='Porterfield' && SIC_code='5411'DB:business_master_new
loadtime:3.194895029068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poskin' limit 1
loadtime:3.1949510574341 / seconds
Query Executed:select id FROM `wi` where city='Poskin' && SIC_code='5411'DB:business_master_new
loadtime:3.1954131126404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potosi' limit 1
loadtime:3.1954660415649 / seconds
Query Executed:select id FROM `wi` where city='Potosi' && SIC_code='5411'DB:business_master_new
loadtime:3.1976611614227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potter' limit 1
loadtime:3.1977331638336 / seconds
Query Executed:select id FROM `wi` where city='Potter' && SIC_code='5411'DB:business_master_new
loadtime:3.1983320713043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:3.1983871459961 / seconds
Query Executed:select id FROM `wi` where city='Pound' && SIC_code='5411'DB:business_master_new
loadtime:3.2002670764923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers Lake' limit 1
loadtime:3.2003381252289 / seconds
Query Executed:select id FROM `wi` where city='Powers Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.2008910179138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poy Sippi' limit 1
loadtime:3.200944185257 / seconds
Query Executed:select id FROM `wi` where city='Poy Sippi' && SIC_code='5411'DB:business_master_new
loadtime:3.2018830776215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poynette' limit 1
loadtime:3.2019510269165 / seconds
Query Executed:select id FROM `wi` where city='Poynette' && SIC_code='5411'DB:business_master_new
loadtime:3.2079811096191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Du Chien' limit 1
loadtime:3.20805311203 / seconds
Query Executed:select id FROM `wi` where city='Prairie Du Chien' && SIC_code='5411'DB:business_master_new
loadtime:3.2176361083984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Du Sac' limit 1
loadtime:3.2177131175995 / seconds
Query Executed:select id FROM `wi` where city='Prairie Du Sac' && SIC_code='5411'DB:business_master_new
loadtime:3.2241480350494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Farm' limit 1
loadtime:3.2242171764374 / seconds
Query Executed:select id FROM `wi` where city='Prairie Farm' && SIC_code='5411'DB:business_master_new
loadtime:3.2255640029907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prentice' limit 1
loadtime:3.2256331443787 / seconds
Query Executed:select id FROM `wi` where city='Prentice' && SIC_code='5411'DB:business_master_new
loadtime:3.2272880077362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:3.2273581027985 / seconds
Query Executed:select id FROM `wi` where city='Prescott' && SIC_code='5411'DB:business_master_new
loadtime:3.2307231426239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presque Isle' limit 1
loadtime:3.2307951450348 / seconds
Query Executed:select id FROM `wi` where city='Presque Isle' && SIC_code='5411'DB:business_master_new
loadtime:3.2321190834045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:3.2321741580963 / seconds
Query Executed:select id FROM `wi` where city='Princeton' && SIC_code='5411'DB:business_master_new
loadtime:3.2350921630859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:3.2351641654968 / seconds
Query Executed:select id FROM `wi` where city='Pulaski' && SIC_code='5411'DB:business_master_new
loadtime:3.2401921749115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulcifer' limit 1
loadtime:3.2402710914612 / seconds
Query Executed:select id FROM `wi` where city='Pulcifer' && SIC_code='5411'DB:business_master_new
loadtime:3.2407162189484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Racine' limit 1
loadtime:3.2407701015472 / seconds
Query Executed:select id FROM `wi` where city='Racine' && SIC_code='5411'DB:business_master_new
loadtime:3.2963280677795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radisson' limit 1
loadtime:3.2965230941772 / seconds
Query Executed:select id FROM `wi` where city='Radisson' && SIC_code='5411'DB:business_master_new
loadtime:3.2974231243134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:3.2974851131439 / seconds
Query Executed:select id FROM `wi` where city='Randolph' && SIC_code='5411'DB:business_master_new
loadtime:3.3002870082855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Random Lake' limit 1
loadtime:3.3003571033478 / seconds
Query Executed:select id FROM `wi` where city='Random Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.3028612136841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readfield' limit 1
loadtime:3.3029310703278 / seconds
Query Executed:select id FROM `wi` where city='Readfield' && SIC_code='5411'DB:business_master_new
loadtime:3.3035831451416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readstown' limit 1
loadtime:3.3036391735077 / seconds
Query Executed:select id FROM `wi` where city='Readstown' && SIC_code='5411'DB:business_master_new
loadtime:3.3046770095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redgranite' limit 1
loadtime:3.3047430515289 / seconds
Query Executed:select id FROM `wi` where city='Redgranite' && SIC_code='5411'DB:business_master_new
loadtime:3.3063230514526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsburg' limit 1
loadtime:3.3063931465149 / seconds
Query Executed:select id FROM `wi` where city='Reedsburg' && SIC_code='5411'DB:business_master_new
loadtime:3.3400111198425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsville' limit 1
loadtime:3.3400900363922 / seconds
Query Executed:select id FROM `wi` where city='Reedsville' && SIC_code='5411'DB:business_master_new
loadtime:3.3430850505829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reeseville' limit 1
loadtime:3.3431520462036 / seconds
Query Executed:select id FROM `wi` where city='Reeseville' && SIC_code='5411'DB:business_master_new
loadtime:3.3446700572968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rewey' limit 1
loadtime:3.3447391986847 / seconds
Query Executed:select id FROM `wi` where city='Rewey' && SIC_code='5411'DB:business_master_new
loadtime:3.3454811573029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhinelander' limit 1
loadtime:3.3455350399017 / seconds
Query Executed:select id FROM `wi` where city='Rhinelander' && SIC_code='5411'DB:business_master_new
loadtime:3.364166021347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rib Lake' limit 1
loadtime:3.364265203476 / seconds
Query Executed:select id FROM `wi` where city='Rib Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.3659629821777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice Lake' limit 1
loadtime:3.3660371303558 / seconds
Query Executed:select id FROM `wi` where city='Rice Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.3806531429291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:3.3807392120361 / seconds
Query Executed:select id FROM `wi` where city='Richfield' && SIC_code='5411'DB:business_master_new
loadtime:3.384003162384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland Center' limit 1
loadtime:3.3840711116791 / seconds
Query Executed:select id FROM `wi` where city='Richland Center' && SIC_code='5411'DB:business_master_new
loadtime:3.4172620773315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:3.4173450469971 / seconds
Query Executed:select id FROM `wi` where city='Ridgeland' && SIC_code='5411'DB:business_master_new
loadtime:3.4187841415405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:3.4188561439514 / seconds
Query Executed:select id FROM `wi` where city='Ridgeway' && SIC_code='5411'DB:business_master_new
loadtime:3.4200332164764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringle' limit 1
loadtime:3.4201040267944 / seconds
Query Executed:select id FROM `wi` where city='Ringle' && SIC_code='5411'DB:business_master_new
loadtime:3.4212770462036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio' limit 1
loadtime:3.4213321208954 / seconds
Query Executed:select id FROM `wi` where city='Rio' && SIC_code='5411'DB:business_master_new
loadtime:3.4235680103302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripon' limit 1
loadtime:3.4236350059509 / seconds
Query Executed:select id FROM `wi` where city='Ripon' && SIC_code='5411'DB:business_master_new
loadtime:3.4554531574249 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Falls' limit 1
loadtime:3.4555330276489 / seconds
Query Executed:select id FROM `wi` where city='River Falls' && SIC_code='5411'DB:business_master_new
loadtime:3.4680271148682 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Hills' limit 1
loadtime:3.4681091308594 / seconds
Query Executed:select id FROM `wi` where city='River Hills' && SIC_code='5411'DB:business_master_new
loadtime:3.4685130119324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roberts' limit 1
loadtime:3.4685690402985 / seconds
Query Executed:select id FROM `wi` where city='Roberts' && SIC_code='5411'DB:business_master_new
loadtime:3.4706311225891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:3.470703125 / seconds
Query Executed:select id FROM `wi` where city='Rochester' && SIC_code='5411'DB:business_master_new
loadtime:3.4716420173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:3.4717080593109 / seconds
Query Executed:select id FROM `wi` where city='Rock Falls' && SIC_code='5411'DB:business_master_new
loadtime:3.4721879959106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Springs' limit 1
loadtime:3.4722461700439 / seconds
Query Executed:select id FROM `wi` where city='Rock Springs' && SIC_code='5411'DB:business_master_new
loadtime:3.4732530117035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:3.4733190536499 / seconds
Query Executed:select id FROM `wi` where city='Rockland' && SIC_code='5411'DB:business_master_new
loadtime:3.4740750789642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosendale' limit 1
loadtime:3.4741411209106 / seconds
Query Executed:select id FROM `wi` where city='Rosendale' && SIC_code='5411'DB:business_master_new
loadtime:3.475378036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:3.4754559993744 / seconds
Query Executed:select id FROM `wi` where city='Rosholt' && SIC_code='5411'DB:business_master_new
loadtime:3.477334022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rothschild' limit 1
loadtime:3.4774160385132 / seconds
Query Executed:select id FROM `wi` where city='Rothschild' && SIC_code='5411'DB:business_master_new
loadtime:3.4799010753632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalton' limit 1
loadtime:3.4799690246582 / seconds
Query Executed:select id FROM `wi` where city='Royalton' && SIC_code='5411'DB:business_master_new
loadtime:3.4803750514984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rubicon' limit 1
loadtime:3.4804379940033 / seconds
Query Executed:select id FROM `wi` where city='Rubicon' && SIC_code='5411'DB:business_master_new
loadtime:3.4816331863403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudolph' limit 1
loadtime:3.4817011356354 / seconds
Query Executed:select id FROM `wi` where city='Rudolph' && SIC_code='5411'DB:business_master_new
loadtime:3.483108997345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Cloud' limit 1
loadtime:3.4831781387329 / seconds
Query Executed:select id FROM `wi` where city='Saint Cloud' && SIC_code='5411'DB:business_master_new
loadtime:3.4843690395355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Croix Falls' limit 1
loadtime:3.4844481945038 / seconds
Query Executed:select id FROM `wi` where city='Saint Croix Falls' && SIC_code='5411'DB:business_master_new
loadtime:3.489226102829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Germain' limit 1
loadtime:3.4893050193787 / seconds
Query Executed:select id FROM `wi` where city='Saint Germain' && SIC_code='5411'DB:business_master_new
loadtime:3.4921560287476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Nazianz' limit 1
loadtime:3.4922339916229 / seconds
Query Executed:select id FROM `wi` where city='Saint Nazianz' && SIC_code='5411'DB:business_master_new
loadtime:3.4931871891022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:3.4932579994202 / seconds
Query Executed:select id FROM `wi` where city='Salem' && SIC_code='5411'DB:business_master_new
loadtime:3.4971261024475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Creek' limit 1
loadtime:3.497200012207 / seconds
Query Executed:select id FROM `wi` where city='Sand Creek' && SIC_code='5411'DB:business_master_new
loadtime:3.4978721141815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarona' limit 1
loadtime:3.4979281425476 / seconds
Query Executed:select id FROM `wi` where city='Sarona' && SIC_code='5411'DB:business_master_new
loadtime:3.4993081092834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sauk City' limit 1
loadtime:3.4993631839752 / seconds
Query Executed:select id FROM `wi` where city='Sauk City' && SIC_code='5411'DB:business_master_new
loadtime:3.5035500526428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saukville' limit 1
loadtime:3.503623008728 / seconds
Query Executed:select id FROM `wi` where city='Saukville' && SIC_code='5411'DB:business_master_new
loadtime:3.507392168045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxeville' limit 1
loadtime:3.5074691772461 / seconds
Query Executed:select id FROM `wi` where city='Saxeville' && SIC_code='5411'DB:business_master_new
loadtime:3.5079641342163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxon' limit 1
loadtime:3.5080180168152 / seconds
Query Executed:select id FROM `wi` where city='Saxon' && SIC_code='5411'DB:business_master_new
loadtime:3.5087471008301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sayner' limit 1
loadtime:3.5088000297546 / seconds
Query Executed:select id FROM `wi` where city='Sayner' && SIC_code='5411'DB:business_master_new
loadtime:3.5098910331726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scandinavia' limit 1
loadtime:3.5099442005157 / seconds
Query Executed:select id FROM `wi` where city='Scandinavia' && SIC_code='5411'DB:business_master_new
loadtime:3.5110330581665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield' limit 1
loadtime:3.5111010074615 / seconds
Query Executed:select id FROM `wi` where city='Schofield' && SIC_code='5411'DB:business_master_new
loadtime:3.5234730243683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:3.5235500335693 / seconds
Query Executed:select id FROM `wi` where city='Seneca' && SIC_code='5411'DB:business_master_new
loadtime:3.5241961479187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sextonville' limit 1
loadtime:3.5242540836334 / seconds
Query Executed:select id FROM `wi` where city='Sextonville' && SIC_code='5411'DB:business_master_new
loadtime:3.5247600078583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:3.5248131752014 / seconds
Query Executed:select id FROM `wi` where city='Seymour' && SIC_code='5411'DB:business_master_new
loadtime:3.5294830799103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:3.5295550823212 / seconds
Query Executed:select id FROM `wi` where city='Sharon' && SIC_code='5411'DB:business_master_new
loadtime:3.5313501358032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawano' limit 1
loadtime:3.5314249992371 / seconds
Query Executed:select id FROM `wi` where city='Shawano' && SIC_code='5411'DB:business_master_new
loadtime:3.5459229946136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheboygan' limit 1
loadtime:3.5460131168365 / seconds
Query Executed:select id FROM `wi` where city='Sheboygan' && SIC_code='5411'DB:business_master_new
loadtime:3.5791480541229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheboygan Falls' limit 1
loadtime:3.5792870521545 / seconds
Query Executed:select id FROM `wi` where city='Sheboygan Falls' && SIC_code='5411'DB:business_master_new
loadtime:3.6124820709229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:3.6125631332397 / seconds
Query Executed:select id FROM `wi` where city='Sheldon' && SIC_code='5411'DB:business_master_new
loadtime:3.6140120029449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Lake' limit 1
loadtime:3.6140840053558 / seconds
Query Executed:select id FROM `wi` where city='Shell Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.6169381141663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:3.6170091629028 / seconds
Query Executed:select id FROM `wi` where city='Sherwood' && SIC_code='5411'DB:business_master_new
loadtime:3.6187250614166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiocton' limit 1
loadtime:3.6187930107117 / seconds
Query Executed:select id FROM `wi` where city='Shiocton' && SIC_code='5411'DB:business_master_new
loadtime:3.6206221580505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shorewood' limit 1
loadtime:3.6206910610199 / seconds
Query Executed:select id FROM `wi` where city='Shorewood' && SIC_code='5411'DB:business_master_new
loadtime:3.6211659908295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shullsburg' limit 1
loadtime:3.6212201118469 / seconds
Query Executed:select id FROM `wi` where city='Shullsburg' && SIC_code='5411'DB:business_master_new
loadtime:3.6526160240173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:3.6526892185211 / seconds
Query Executed:select id FROM `wi` where city='Silver Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.6541240215302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinsinawa' limit 1
loadtime:3.6541950702667 / seconds
Query Executed:select id FROM `wi` where city='Sinsinawa' && SIC_code='5411'DB:business_master_new
loadtime:3.6546821594238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siren' limit 1
loadtime:3.654736995697 / seconds
Query Executed:select id FROM `wi` where city='Siren' && SIC_code='5411'DB:business_master_new
loadtime:3.6859831809998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sister Bay' limit 1
loadtime:3.686065196991 / seconds
Query Executed:select id FROM `wi` where city='Sister Bay' && SIC_code='5411'DB:business_master_new
loadtime:3.7172741889954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slinger' limit 1
loadtime:3.7174110412598 / seconds
Query Executed:select id FROM `wi` where city='Slinger' && SIC_code='5411'DB:business_master_new
loadtime:3.7250440120697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sobieski' limit 1
loadtime:3.7251591682434 / seconds
Query Executed:select id FROM `wi` where city='Sobieski' && SIC_code='5411'DB:business_master_new
loadtime:3.7269990444183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldiers Grove' limit 1
loadtime:3.7270820140839 / seconds
Query Executed:select id FROM `wi` where city='Soldiers Grove' && SIC_code='5411'DB:business_master_new
loadtime:3.729373216629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon Springs' limit 1
loadtime:3.7294859886169 / seconds
Query Executed:select id FROM `wi` where city='Solon Springs' && SIC_code='5411'DB:business_master_new
loadtime:3.7326622009277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:3.7327752113342 / seconds
Query Executed:select id FROM `wi` where city='Somers' && SIC_code='5411'DB:business_master_new
loadtime:3.7337951660156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:3.7339010238647 / seconds
Query Executed:select id FROM `wi` where city='Somerset' && SIC_code='5411'DB:business_master_new
loadtime:3.7421350479126 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Byron' limit 1
loadtime:3.7422430515289 / seconds
Query Executed:select id FROM `wi` where city='South Byron' && SIC_code='5411'DB:business_master_new
loadtime:3.7428140640259 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Milwaukee' limit 1
loadtime:3.7428960800171 / seconds
Query Executed:select id FROM `wi` where city='South Milwaukee' && SIC_code='5411'DB:business_master_new
loadtime:3.7544372081757 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Range' limit 1
loadtime:3.7545471191406 / seconds
Query Executed:select id FROM `wi` where city='South Range' && SIC_code='5411'DB:business_master_new
loadtime:3.7564871311188 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wayne' limit 1
loadtime:3.7565901279449 / seconds
Query Executed:select id FROM `wi` where city='South Wayne' && SIC_code='5411'DB:business_master_new
loadtime:3.7583801746368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:3.7584941387177 / seconds
Query Executed:select id FROM `wi` where city='Sparta' && SIC_code='5411'DB:business_master_new
loadtime:3.7714710235596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:3.7716121673584 / seconds
Query Executed:select id FROM `wi` where city='Spencer' && SIC_code='5411'DB:business_master_new
loadtime:3.7740621566772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spooner' limit 1
loadtime:3.7741761207581 / seconds
Query Executed:select id FROM `wi` where city='Spooner' && SIC_code='5411'DB:business_master_new
loadtime:3.7832841873169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Green' limit 1
loadtime:3.7834141254425 / seconds
Query Executed:select id FROM `wi` where city='Spring Green' && SIC_code='5411'DB:business_master_new
loadtime:3.8162469863892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Valley' limit 1
loadtime:3.8163549900055 / seconds
Query Executed:select id FROM `wi` where city='Spring Valley' && SIC_code='5411'DB:business_master_new
loadtime:3.8191211223602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:3.8192272186279 / seconds
Query Executed:select id FROM `wi` where city='Springbrook' && SIC_code='5411'DB:business_master_new
loadtime:3.8202991485596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:3.8203790187836 / seconds
Query Executed:select id FROM `wi` where city='Springfield' && SIC_code='5411'DB:business_master_new
loadtime:3.8208839893341 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Cloud' limit 1
loadtime:3.8209621906281 / seconds
Query Executed:select id FROM `wi` where city='St Cloud' && SIC_code='5411'DB:business_master_new
loadtime:3.8213851451874 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Croix Falls' limit 1
loadtime:3.8214750289917 / seconds
Query Executed:select id FROM `wi` where city='St Croix Falls' && SIC_code='5411'DB:business_master_new
loadtime:3.8218920230865 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:3.8219699859619 / seconds
Query Executed:select id FROM `wi` where city='St Francis' && SIC_code='5411'DB:business_master_new
loadtime:3.8223941326141 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Germain' limit 1
loadtime:3.8224821090698 / seconds
Query Executed:select id FROM `wi` where city='St Germain' && SIC_code='5411'DB:business_master_new
loadtime:3.8228921890259 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Nazianz' limit 1
loadtime:3.8229701519012 / seconds
Query Executed:select id FROM `wi` where city='St Nazianz' && SIC_code='5411'DB:business_master_new
loadtime:3.8233780860901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:3.823468208313 / seconds
Query Executed:select id FROM `wi` where city='Stanley' && SIC_code='5411'DB:business_master_new
loadtime:3.8558721542358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Lake' limit 1
loadtime:3.8560311794281 / seconds
Query Executed:select id FROM `wi` where city='Star Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.8566210269928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Prairie' limit 1
loadtime:3.8567221164703 / seconds
Query Executed:select id FROM `wi` where city='Star Prairie' && SIC_code='5411'DB:business_master_new
loadtime:3.8580272197723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stetsonville' limit 1
loadtime:3.8581290245056 / seconds
Query Executed:select id FROM `wi` where city='Stetsonville' && SIC_code='5411'DB:business_master_new
loadtime:3.8594341278076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steuben' limit 1
loadtime:3.8595361709595 / seconds
Query Executed:select id FROM `wi` where city='Steuben' && SIC_code='5411'DB:business_master_new
loadtime:3.8601791858673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevens Point' limit 1
loadtime:3.8602600097656 / seconds
Query Executed:select id FROM `wi` where city='Stevens Point' && SIC_code='5411'DB:business_master_new
loadtime:3.8843080997467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stitzer' limit 1
loadtime:3.8844811916351 / seconds
Query Executed:select id FROM `wi` where city='Stitzer' && SIC_code='5411'DB:business_master_new
loadtime:3.8853662014008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:3.8854610919952 / seconds
Query Executed:select id FROM `wi` where city='Stockbridge' && SIC_code='5411'DB:business_master_new
loadtime:3.8862600326538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:3.88636302948 / seconds
Query Executed:select id FROM `wi` where city='Stockholm' && SIC_code='5411'DB:business_master_new
loadtime:3.8872880935669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:3.8873691558838 / seconds
Query Executed:select id FROM `wi` where city='Stoddard' && SIC_code='5411'DB:business_master_new
loadtime:3.8891270160675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Lake' limit 1
loadtime:3.8892261981964 / seconds
Query Executed:select id FROM `wi` where city='Stone Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.8910391330719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:3.8911490440369 / seconds
Query Executed:select id FROM `wi` where city='Stoughton' && SIC_code='5411'DB:business_master_new
loadtime:3.9041850566864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:3.9043099880219 / seconds
Query Executed:select id FROM `wi` where city='Stratford' && SIC_code='5411'DB:business_master_new
loadtime:3.9072070121765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strum' limit 1
loadtime:3.9073181152344 / seconds
Query Executed:select id FROM `wi` where city='Strum' && SIC_code='5411'DB:business_master_new
loadtime:3.9090800285339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgeon Bay' limit 1
loadtime:3.9091939926147 / seconds
Query Executed:select id FROM `wi` where city='Sturgeon Bay' && SIC_code='5411'DB:business_master_new
loadtime:3.9273631572723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturtevant' limit 1
loadtime:3.9275190830231 / seconds
Query Executed:select id FROM `wi` where city='Sturtevant' && SIC_code='5411'DB:business_master_new
loadtime:3.9352550506592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suamico' limit 1
loadtime:3.9353721141815 / seconds
Query Executed:select id FROM `wi` where city='Suamico' && SIC_code='5411'DB:business_master_new
loadtime:3.9378230571747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:3.9379050731659 / seconds
Query Executed:select id FROM `wi` where city='Sullivan' && SIC_code='5411'DB:business_master_new
loadtime:3.9398701190948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit Lake' limit 1
loadtime:3.9399790763855 / seconds
Query Executed:select id FROM `wi` where city='Summit Lake' && SIC_code='5411'DB:business_master_new
loadtime:3.9406640529633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Prairie' limit 1
loadtime:3.9407451152802 / seconds
Query Executed:select id FROM `wi` where city='Sun Prairie' && SIC_code='5411'DB:business_master_new
loadtime:3.9581460952759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:3.9582741260529 / seconds
Query Executed:select id FROM `wi` where city='Superior' && SIC_code='5411'DB:business_master_new
loadtime:3.9784231185913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suring' limit 1
loadtime:3.9785461425781 / seconds
Query Executed:select id FROM `wi` where city='Suring' && SIC_code='5411'DB:business_master_new
loadtime:3.9807851314545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:3.9808599948883 / seconds
Query Executed:select id FROM `wi` where city='Sussex' && SIC_code='5411'DB:business_master_new
loadtime:3.9902260303497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:3.9903030395508 / seconds
Query Executed:select id FROM `wi` where city='Taylor' && SIC_code='5411'DB:business_master_new
loadtime:3.9914112091064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Theresa' limit 1
loadtime:3.9914810657501 / seconds
Query Executed:select id FROM `wi` where city='Theresa' && SIC_code='5411'DB:business_master_new
loadtime:3.9927861690521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thiensville' limit 1
loadtime:3.9928531646729 / seconds
Query Executed:select id FROM `wi` where city='Thiensville' && SIC_code='5411'DB:business_master_new
loadtime:3.9939701557159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorp' limit 1
loadtime:3.994038105011 / seconds
Query Executed:select id FROM `wi` where city='Thorp' && SIC_code='5411'DB:business_master_new
loadtime:3.999941110611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Lakes' limit 1
loadtime:4.000018119812 / seconds
Query Executed:select id FROM `wi` where city='Three Lakes' && SIC_code='5411'DB:business_master_new
loadtime:4.0027730464935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigerton' limit 1
loadtime:4.0028431415558 / seconds
Query Executed:select id FROM `wi` where city='Tigerton' && SIC_code='5411'DB:business_master_new
loadtime:4.004595041275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilleda' limit 1
loadtime:4.004664182663 / seconds
Query Executed:select id FROM `wi` where city='Tilleda' && SIC_code='5411'DB:business_master_new
loadtime:4.0052461624146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipler' limit 1
loadtime:4.0053009986877 / seconds
Query Executed:select id FROM `wi` where city='Tipler' && SIC_code='5411'DB:business_master_new
loadtime:4.0057020187378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tisch Mills' limit 1
loadtime:4.0057561397552 / seconds
Query Executed:select id FROM `wi` where city='Tisch Mills' && SIC_code='5411'DB:business_master_new
loadtime:4.0062301158905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tomah' limit 1
loadtime:4.0062870979309 / seconds
Query Executed:select id FROM `wi` where city='Tomah' && SIC_code='5411'DB:business_master_new
loadtime:4.0184471607208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tomahawk' limit 1
loadtime:4.0185279846191 / seconds
Query Executed:select id FROM `wi` where city='Tomahawk' && SIC_code='5411'DB:business_master_new
loadtime:4.0282161235809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tony' limit 1
loadtime:4.0283041000366 / seconds
Query Executed:select id FROM `wi` where city='Tony' && SIC_code='5411'DB:business_master_new
loadtime:4.0290701389313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:4.029137134552 / seconds
Query Executed:select id FROM `wi` where city='Townsend' && SIC_code='5411'DB:business_master_new
loadtime:4.0303151607513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trego' limit 1
loadtime:4.0303831100464 / seconds
Query Executed:select id FROM `wi` where city='Trego' && SIC_code='5411'DB:business_master_new
loadtime:4.0319790840149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trempealeau' limit 1
loadtime:4.0320491790771 / seconds
Query Executed:select id FROM `wi` where city='Trempealeau' && SIC_code='5411'DB:business_master_new
loadtime:4.0340030193329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevor' limit 1
loadtime:4.0340740680695 / seconds
Query Executed:select id FROM `wi` where city='Trevor' && SIC_code='5411'DB:business_master_new
loadtime:4.0359539985657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:4.0360231399536 / seconds
Query Executed:select id FROM `wi` where city='Tripoli' && SIC_code='5411'DB:business_master_new
loadtime:4.0366270542145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunnel City' limit 1
loadtime:4.0366811752319 / seconds
Query Executed:select id FROM `wi` where city='Tunnel City' && SIC_code='5411'DB:business_master_new
loadtime:4.0371301174164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turtle Lake' limit 1
loadtime:4.0371820926666 / seconds
Query Executed:select id FROM `wi` where city='Turtle Lake' && SIC_code='5411'DB:business_master_new
loadtime:4.0396511554718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lakes' limit 1
loadtime:4.0397281646729 / seconds
Query Executed:select id FROM `wi` where city='Twin Lakes' && SIC_code='5411'DB:business_master_new
loadtime:4.0727159976959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Two Rivers' limit 1
loadtime:4.0727870464325 / seconds
Query Executed:select id FROM `wi` where city='Two Rivers' && SIC_code='5411'DB:business_master_new
loadtime:4.082022190094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:4.0820980072021 / seconds
Query Executed:select id FROM `wi` where city='Union Center' && SIC_code='5411'DB:business_master_new
loadtime:4.0828042030334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:4.0828740596771 / seconds
Query Executed:select id FROM `wi` where city='Union Grove' && SIC_code='5411'DB:business_master_new
loadtime:4.0904719829559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unity' limit 1
loadtime:4.0905470848083 / seconds
Query Executed:select id FROM `wi` where city='Unity' && SIC_code='5411'DB:business_master_new
loadtime:4.0916891098022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upson' limit 1
loadtime:4.091756105423 / seconds
Query Executed:select id FROM `wi` where city='Upson' && SIC_code='5411'DB:business_master_new
loadtime:4.0922820568085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valders' limit 1
loadtime:4.0923361778259 / seconds
Query Executed:select id FROM `wi` where city='Valders' && SIC_code='5411'DB:business_master_new
loadtime:4.0943582057953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Dyne' limit 1
loadtime:4.0944390296936 / seconds
Query Executed:select id FROM `wi` where city='Van Dyne' && SIC_code='5411'DB:business_master_new
loadtime:4.0957992076874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:4.0958690643311 / seconds
Query Executed:select id FROM `wi` where city='Verona' && SIC_code='5411'DB:business_master_new
loadtime:4.1082060337067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesper' limit 1
loadtime:4.1082870960236 / seconds
Query Executed:select id FROM `wi` where city='Vesper' && SIC_code='5411'DB:business_master_new
loadtime:4.1096382141113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:4.109708070755 / seconds
Query Executed:select id FROM `wi` where city='Viola' && SIC_code='5411'DB:business_master_new
loadtime:4.1113431453705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viroqua' limit 1
loadtime:4.1114230155945 / seconds
Query Executed:select id FROM `wi` where city='Viroqua' && SIC_code='5411'DB:business_master_new
loadtime:4.1215491294861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wabeno' limit 1
loadtime:4.1216289997101 / seconds
Query Executed:select id FROM `wi` where city='Wabeno' && SIC_code='5411'DB:business_master_new
loadtime:4.1230990886688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldo' limit 1
loadtime:4.1231710910797 / seconds
Query Executed:select id FROM `wi` where city='Waldo' && SIC_code='5411'DB:business_master_new
loadtime:4.1243121623993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:4.1243669986725 / seconds
Query Executed:select id FROM `wi` where city='Wales' && SIC_code='5411'DB:business_master_new
loadtime:4.1267681121826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walworth' limit 1
loadtime:4.1268420219421 / seconds
Query Executed:select id FROM `wi` where city='Walworth' && SIC_code='5411'DB:business_master_new
loadtime:4.1303441524506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrens' limit 1
loadtime:4.1304280757904 / seconds
Query Executed:select id FROM `wi` where city='Warrens' && SIC_code='5411'DB:business_master_new
loadtime:4.1321930885315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wascott' limit 1
loadtime:4.1322531700134 / seconds
Query Executed:select id FROM `wi` where city='Wascott' && SIC_code='5411'DB:business_master_new
loadtime:4.1327321529388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:4.1327841281891 / seconds
Query Executed:select id FROM `wi` where city='Washburn' && SIC_code='5411'DB:business_master_new
loadtime:4.1360092163086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Island' limit 1
loadtime:4.1360800266266 / seconds
Query Executed:select id FROM `wi` where city='Washington Island' && SIC_code='5411'DB:business_master_new
loadtime:4.1376230716705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Isle' limit 1
loadtime:4.1376791000366 / seconds
Query Executed:select id FROM `wi` where city='Washington Isle' && SIC_code='5411'DB:business_master_new
loadtime:4.1380891799927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:4.1381411552429 / seconds
Query Executed:select id FROM `wi` where city='Waterford' && SIC_code='5411'DB:business_master_new
loadtime:4.1488540172577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:4.1489281654358 / seconds
Query Executed:select id FROM `wi` where city='Waterloo' && SIC_code='5411'DB:business_master_new
loadtime:4.1520280838013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:4.1521000862122 / seconds
Query Executed:select id FROM `wi` where city='Watertown' && SIC_code='5411'DB:business_master_new
loadtime:4.1698951721191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubeka' limit 1
loadtime:4.169979095459 / seconds
Query Executed:select id FROM `wi` where city='Waubeka' && SIC_code='5411'DB:business_master_new
loadtime:4.1704211235046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukau' limit 1
loadtime:4.1704771518707 / seconds
Query Executed:select id FROM `wi` where city='Waukau' && SIC_code='5411'DB:business_master_new
loadtime:4.1710081100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukesha' limit 1
loadtime:4.1710600852966 / seconds
Query Executed:select id FROM `wi` where city='Waukesha' && SIC_code='5411'DB:business_master_new
loadtime:4.2274460792542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waumandee' limit 1
loadtime:4.2275631427765 / seconds
Query Executed:select id FROM `wi` where city='Waumandee' && SIC_code='5411'DB:business_master_new
loadtime:4.2280070781708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waunakee' limit 1
loadtime:4.2280662059784 / seconds
Query Executed:select id FROM `wi` where city='Waunakee' && SIC_code='5411'DB:business_master_new
loadtime:4.239422082901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waupaca' limit 1
loadtime:4.2394971847534 / seconds
Query Executed:select id FROM `wi` where city='Waupaca' && SIC_code='5411'DB:business_master_new
loadtime:4.2524302005768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waupun' limit 1
loadtime:4.2525081634521 / seconds
Query Executed:select id FROM `wi` where city='Waupun' && SIC_code='5411'DB:business_master_new
loadtime:4.2609851360321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wausau' limit 1
loadtime:4.2610650062561 / seconds
Query Executed:select id FROM `wi` where city='Wausau' && SIC_code='5411'DB:business_master_new
loadtime:4.2983520030975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wausaukee' limit 1
loadtime:4.298492193222 / seconds
Query Executed:select id FROM `wi` where city='Wausaukee' && SIC_code='5411'DB:business_master_new
loadtime:4.3005290031433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wautoma' limit 1
loadtime:4.30060505867 / seconds
Query Executed:select id FROM `wi` where city='Wautoma' && SIC_code='5411'DB:business_master_new
loadtime:4.3088531494141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauwatosa' limit 1
loadtime:4.3089330196381 / seconds
Query Executed:select id FROM `wi` where city='Wauwatosa' && SIC_code='5411'DB:business_master_new
loadtime:4.3098750114441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauzeka' limit 1
loadtime:4.3099319934845 / seconds
Query Executed:select id FROM `wi` where city='Wauzeka' && SIC_code='5411'DB:business_master_new
loadtime:4.3115739822388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb Lake' limit 1
loadtime:4.311644077301 / seconds
Query Executed:select id FROM `wi` where city='Webb Lake' && SIC_code='5411'DB:business_master_new
loadtime:4.3122050762177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:4.3122630119324 / seconds
Query Executed:select id FROM `wi` where city='Webster' && SIC_code='5411'DB:business_master_new
loadtime:4.3457510471344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:4.345890045166 / seconds
Query Executed:select id FROM `wi` where city='Wentworth' && SIC_code='5411'DB:business_master_new
loadtime:4.3464071750641 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Allis' limit 1
loadtime:4.3464901447296 / seconds
Query Executed:select id FROM `wi` where city='West Allis' && SIC_code='5411'DB:business_master_new
loadtime:4.347088098526 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:4.3471660614014 / seconds
Query Executed:select id FROM `wi` where city='West Bend' && SIC_code='5411'DB:business_master_new
loadtime:4.3729691505432 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Salem' limit 1
loadtime:4.3731200695038 / seconds
Query Executed:select id FROM `wi` where city='West Salem' && SIC_code='5411'DB:business_master_new
loadtime:4.3798131942749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westboro' limit 1
loadtime:4.37992811203 / seconds
Query Executed:select id FROM `wi` where city='Westboro' && SIC_code='5411'DB:business_master_new
loadtime:4.3807530403137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westby' limit 1
loadtime:4.3808341026306 / seconds
Query Executed:select id FROM `wi` where city='Westby' && SIC_code='5411'DB:business_master_new
loadtime:4.3846001625061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:4.3847091197968 / seconds
Query Executed:select id FROM `wi` where city='Westfield' && SIC_code='5411'DB:business_master_new
loadtime:4.4174540042877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:4.4175581932068 / seconds
Query Executed:select id FROM `wi` where city='Weston' && SIC_code='5411'DB:business_master_new
loadtime:4.418023109436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:4.4181020259857 / seconds
Query Executed:select id FROM `wi` where city='Westport' && SIC_code='5411'DB:business_master_new
loadtime:4.4185330867767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyauwega' limit 1
loadtime:4.4186110496521 / seconds
Query Executed:select id FROM `wi` where city='Weyauwega' && SIC_code='5411'DB:business_master_new
loadtime:4.4218971729279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyerhaeuser' limit 1
loadtime:4.4220089912415 / seconds
Query Executed:select id FROM `wi` where city='Weyerhaeuser' && SIC_code='5411'DB:business_master_new
loadtime:4.4232351779938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:4.4233419895172 / seconds
Query Executed:select id FROM `wi` where city='Wheeler' && SIC_code='5411'DB:business_master_new
loadtime:4.4243412017822 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:4.4244542121887 / seconds
Query Executed:select id FROM `wi` where city='White Lake' && SIC_code='5411'DB:business_master_new
loadtime:4.4257681369781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehall' limit 1
loadtime:4.4258761405945 / seconds
Query Executed:select id FROM `wi` where city='Whitehall' && SIC_code='5411'DB:business_master_new
loadtime:4.4286301136017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitelaw' limit 1
loadtime:4.4287440776825 / seconds
Query Executed:select id FROM `wi` where city='Whitelaw' && SIC_code='5411'DB:business_master_new
loadtime:4.4301800727844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewater' limit 1
loadtime:4.4302840232849 / seconds
Query Executed:select id FROM `wi` where city='Whitewater' && SIC_code='5411'DB:business_master_new
loadtime:4.4407360553741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wild Rose' limit 1
loadtime:4.4408640861511 / seconds
Query Executed:select id FROM `wi` where city='Wild Rose' && SIC_code='5411'DB:business_master_new
loadtime:4.443332195282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:4.4434530735016 / seconds
Query Executed:select id FROM `wi` where city='Willard' && SIC_code='5411'DB:business_master_new
loadtime:4.4444241523743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams Bay' limit 1
loadtime:4.4445061683655 / seconds
Query Executed:select id FROM `wi` where city='Williams Bay' && SIC_code='5411'DB:business_master_new
loadtime:4.4469940662384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:4.4470970630646 / seconds
Query Executed:select id FROM `wi` where city='Wilmot' && SIC_code='5411'DB:business_master_new
loadtime:4.448135137558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:4.4482381343842 / seconds
Query Executed:select id FROM `wi` where city='Wilson' && SIC_code='5411'DB:business_master_new
loadtime:4.4492681026459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:4.4493470191956 / seconds
Query Executed:select id FROM `wi` where city='Wilton' && SIC_code='5411'DB:business_master_new
loadtime:4.4506731033325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:4.4507791996002 / seconds
Query Executed:select id FROM `wi` where city='Winchester' && SIC_code='5411'DB:business_master_new
loadtime:4.4513192176819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wind Lake' limit 1
loadtime:4.4514071941376 / seconds
Query Executed:select id FROM `wi` where city='Wind Lake' && SIC_code='5411'DB:business_master_new
loadtime:4.4519250392914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:4.4520020484924 / seconds
Query Executed:select id FROM `wi` where city='Windsor' && SIC_code='5411'DB:business_master_new
loadtime:4.453693151474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnebago' limit 1
loadtime:4.4537951946259 / seconds
Query Executed:select id FROM `wi` where city='Winnebago' && SIC_code='5411'DB:business_master_new
loadtime:4.4545230865479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winneconne' limit 1
loadtime:4.4546051025391 / seconds
Query Executed:select id FROM `wi` where city='Winneconne' && SIC_code='5411'DB:business_master_new
loadtime:4.4576961994171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winter' limit 1
loadtime:4.4578042030334 / seconds
Query Executed:select id FROM `wi` where city='Winter' && SIC_code='5411'DB:business_master_new
loadtime:4.4598741531372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wisconsin Dells' limit 1
loadtime:4.4599781036377 / seconds
Query Executed:select id FROM `wi` where city='Wisconsin Dells' && SIC_code='5411'DB:business_master_new
loadtime:4.4733121395111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wisconsin Rapids' limit 1
loadtime:4.4734721183777 / seconds
Query Executed:select id FROM `wi` where city='Wisconsin Rapids' && SIC_code='5411'DB:business_master_new
loadtime:4.4970550537109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withee' limit 1
loadtime:4.4972372055054 / seconds
Query Executed:select id FROM `wi` where city='Withee' && SIC_code='5411'DB:business_master_new
loadtime:4.499055147171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittenberg' limit 1
loadtime:4.4991610050201 / seconds
Query Executed:select id FROM `wi` where city='Wittenberg' && SIC_code='5411'DB:business_master_new
loadtime:4.5020661354065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonewoc' limit 1
loadtime:4.5021781921387 / seconds
Query Executed:select id FROM `wi` where city='Wonewoc' && SIC_code='5411'DB:business_master_new
loadtime:4.5039591789246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:4.5040609836578 / seconds
Query Executed:select id FROM `wi` where city='Woodford' && SIC_code='5411'DB:business_master_new
loadtime:4.5045821666718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:4.504664182663 / seconds
Query Executed:select id FROM `wi` where city='Woodland' && SIC_code='5411'DB:business_master_new
loadtime:4.5051681995392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodman' limit 1
loadtime:4.5052452087402 / seconds
Query Executed:select id FROM `wi` where city='Woodman' && SIC_code='5411'DB:business_master_new
loadtime:4.5058560371399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:4.5059351921082 / seconds
Query Executed:select id FROM `wi` where city='Woodruff' && SIC_code='5411'DB:business_master_new
loadtime:4.5135831832886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:4.5136930942535 / seconds
Query Executed:select id FROM `wi` where city='Woodville' && SIC_code='5411'DB:business_master_new
loadtime:4.5181021690369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodworth' limit 1
loadtime:4.5182070732117 / seconds
Query Executed:select id FROM `wi` where city='Woodworth' && SIC_code='5411'DB:business_master_new
loadtime:4.518678188324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightstown' limit 1
loadtime:4.5187571048737 / seconds
Query Executed:select id FROM `wi` where city='Wrightstown' && SIC_code='5411'DB:business_master_new
loadtime:4.5228631496429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyeville' limit 1
loadtime:4.522970199585 / seconds
Query Executed:select id FROM `wi` where city='Wyeville' && SIC_code='5411'DB:business_master_new
loadtime:4.5234541893005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyocena' limit 1
loadtime:4.5235350131989 / seconds
Query Executed:select id FROM `wi` where city='Wyocena' && SIC_code='5411'DB:business_master_new
loadtime:4.526515007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuba' limit 1
loadtime:4.5266180038452 / seconds
Query Executed:select id FROM `wi` where city='Yuba' && SIC_code='5411'DB:business_master_new
loadtime:4.5270390510559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zachow' limit 1
loadtime:4.5271170139313 / seconds
Query Executed:select id FROM `wi` where city='Zachow' && SIC_code='5411'DB:business_master_new
loadtime:4.5275762081146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zenda' limit 1
loadtime:4.52765417099 / seconds
Query Executed:select id FROM `wi` where city='Zenda' && SIC_code='5411'DB:business_master_new
loadtime:4.5589032173157 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:4.5591340065002 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:4.5600070953369 / seconds
Operation template executed (chunk cache operation)
loadtime:4.5602650642395 / seconds
template override:Default
loadtime:4.5603270530701 / 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:4.5617752075195 / seconds
Template Constructed, Array Rows:49
loadtime:4.562607049942 / seconds
TOTAL EXECUTION TIME: 4.5619
loadtime:4.5686361789703 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => grocery-stores [stateURLid] => 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:4.5686490535736
TOTAL KEY ARRAYS: 69