Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.7036361694336E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00054597854614258 / seconds
host not found setting manual db connection
loadtime:0.00093793869018555 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011529922485352 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0013618469238281 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0014219284057617 / seconds
zipcode:
loadtime:0.0014400482177734 / seconds
Query Executed:select * from search_referrer where page_hash='06ceb57ce4176d618084f021a6a2fd91' limit 10 DB:ezrox_toadli
loadtime:0.0016460418701172 / seconds
Operation header executed (non global)
loadtime:0.0016629695892334 / seconds
Operation leaderboard executed (non global)
loadtime:0.0017058849334717 / seconds
Operation square executed (non global)
loadtime:0.0017189979553223 / seconds
Operation square_bottom executed (non global)
loadtime:0.0017318725585938 / seconds
Operation smallsquare executed (non global)
loadtime:0.0017449855804443 / seconds
Operation headeradright executed (non global)
loadtime:0.001755952835083 / seconds
Operation google_analytics executed (non global)
loadtime:0.0017659664154053 / seconds
Operation topstories executed (non global)
loadtime:0.0017778873443604 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0017900466918945 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0017998218536377 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0020408630371094 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0021939277648926 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0022280216217041 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0022890567779541 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0023269653320312 / seconds
Template key: archive_menu pushed
loadtime:0.0023329257965088 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0023579597473145 / seconds
Template key: get_gravatar pushed
loadtime:0.0023658275604248 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0023729801177979 / seconds
*10)-10)+1 | start:0
loadtime:0.0024018287658691 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.0024368762969971 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wisconsin'
loadtime:0.0024650096893311 / seconds
DB connected to localhost business_master_new
loadtime:0.0027358531951904 / seconds
Query Executed:select * from `wi_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.056404829025269 / seconds
Query stored in cache : _QUERY_www.toadli.com8331afa67d69f32df9f8c8e6f73a2fe0
loadtime:0.057703018188477 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wisconsin'
loadtime:0.057759046554565 / seconds
Query Executed:select sum(totalcount) as totalsum from `wi_catmap` where sic='7231'DB:business_master_new
loadtime:0.062302827835083 / seconds
Query stored in cache : _QUERY_www.toadli.com31fc81f1dc756e8f8260098831999e07
loadtime:0.062329053878784 / seconds
820 / 11
loadtime:0.062386989593506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbotsford' limit 1
loadtime:0.06243896484375 / seconds
Query Executed:select id FROM `wi` where city='Abbotsford' && SIC_code='7231'DB:business_master_new
loadtime:0.13361787796021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abrams' limit 1
loadtime:0.1337628364563 / seconds
Query Executed:select id FROM `wi` where city='Abrams' && SIC_code='7231'DB:business_master_new
loadtime:0.16674494743347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.16684103012085 / seconds
Query Executed:select id FROM `wi` where city='Adams' && SIC_code='7231'DB:business_master_new
loadtime:0.21756482124329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adell' limit 1
loadtime:0.21768283843994 / seconds
Query Executed:select id FROM `wi` where city='Adell' && SIC_code='7231'DB:business_master_new
loadtime:0.23705291748047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.23713397979736 / seconds
Query Executed:select id FROM `wi` where city='Afton' && SIC_code='7231'DB:business_master_new
loadtime:0.23969292640686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.23973488807678 / seconds
Query Executed:select id FROM `wi` where city='Albany' && SIC_code='7231'DB:business_master_new
loadtime:0.26084589958191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algoma' limit 1
loadtime:0.26091504096985 / seconds
Query Executed:select id FROM `wi` where city='Algoma' && SIC_code='7231'DB:business_master_new
loadtime:0.26688599586487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenton' limit 1
loadtime:0.2669529914856 / seconds
Query Executed:select id FROM `wi` where city='Allenton' && SIC_code='7231'DB:business_master_new
loadtime:0.29488086700439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allouez' limit 1
loadtime:0.29495882987976 / seconds
Query Executed:select id FROM `wi` where city='Allouez' && SIC_code='7231'DB:business_master_new
loadtime:0.29527187347412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.29531288146973 / seconds
Query Executed:select id FROM `wi` where city='Alma' && SIC_code='7231'DB:business_master_new
loadtime:0.33263802528381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma Center' limit 1
loadtime:0.33273386955261 / seconds
Query Executed:select id FROM `wi` where city='Alma Center' && SIC_code='7231'DB:business_master_new
loadtime:0.34563589096069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almena' limit 1
loadtime:0.34570288658142 / seconds
Query Executed:select id FROM `wi` where city='Almena' && SIC_code='7231'DB:business_master_new
loadtime:0.36979699134827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almond' limit 1
loadtime:0.36985993385315 / seconds
Query Executed:select id FROM `wi` where city='Almond' && SIC_code='7231'DB:business_master_new
loadtime:0.38537096977234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.38545298576355 / seconds
Query Executed:select id FROM `wi` where city='Altoona' && SIC_code='7231'DB:business_master_new
loadtime:0.38875484466553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amberg' limit 1
loadtime:0.38879585266113 / seconds
Query Executed:select id FROM `wi` where city='Amberg' && SIC_code='7231'DB:business_master_new
loadtime:0.3940908908844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amery' limit 1
loadtime:0.39413785934448 / seconds
Query Executed:select id FROM `wi` where city='Amery' && SIC_code='7231'DB:business_master_new
loadtime:0.40111684799194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.40118002891541 / seconds
Query Executed:select id FROM `wi` where city='Amherst' && SIC_code='7231'DB:business_master_new
loadtime:0.43593502044678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst Junction' limit 1
loadtime:0.43601703643799 / seconds
Query Executed:select id FROM `wi` where city='Amherst Junction' && SIC_code='7231'DB:business_master_new
loadtime:0.44742488861084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aniwa' limit 1
loadtime:0.44748783111572 / seconds
Query Executed:select id FROM `wi` where city='Aniwa' && SIC_code='7231'DB:business_master_new
loadtime:0.456218957901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antigo' limit 1
loadtime:0.45626592636108 / seconds
Query Executed:select id FROM `wi` where city='Antigo' && SIC_code='7231'DB:business_master_new
loadtime:0.46450901031494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Appleton' limit 1
loadtime:0.46457695960999 / seconds
Query Executed:select id FROM `wi` where city='Appleton' && SIC_code='7231'DB:business_master_new
loadtime:0.4937150478363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.49385190010071 / seconds
Query Executed:select id FROM `wi` where city='Arcadia' && SIC_code='7231'DB:business_master_new
loadtime:0.49835991859436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arena' limit 1
loadtime:0.49843001365662 / seconds
Query Executed:select id FROM `wi` where city='Arena' && SIC_code='7231'DB:business_master_new
loadtime:0.50963687896729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argonne' limit 1
loadtime:0.50967288017273 / seconds
Query Executed:select id FROM `wi` where city='Argonne' && SIC_code='7231'DB:business_master_new
loadtime:0.5161190032959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.51618385314941 / seconds
Query Executed:select id FROM `wi` where city='Argyle' && SIC_code='7231'DB:business_master_new
loadtime:0.53233504295349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkansaw' limit 1
loadtime:0.53240394592285 / seconds
Query Executed:select id FROM `wi` where city='Arkansaw' && SIC_code='7231'DB:business_master_new
loadtime:0.54066491127014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkdale' limit 1
loadtime:0.54070687294006 / seconds
Query Executed:select id FROM `wi` where city='Arkdale' && SIC_code='7231'DB:business_master_new
loadtime:0.55155301094055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.55160689353943 / seconds
Query Executed:select id FROM `wi` where city='Arlington' && SIC_code='7231'DB:business_master_new
loadtime:0.56374192237854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armstrong Creek' limit 1
loadtime:0.56378698348999 / seconds
Query Executed:select id FROM `wi` where city='Armstrong Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.5694899559021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arpin' limit 1
loadtime:0.56955099105835 / seconds
Query Executed:select id FROM `wi` where city='Arpin' && SIC_code='7231'DB:business_master_new
loadtime:0.58309888839722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashippun' limit 1
loadtime:0.58314204216003 / seconds
Query Executed:select id FROM `wi` where city='Ashippun' && SIC_code='7231'DB:business_master_new
loadtime:0.58606886863708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.58612585067749 / seconds
Query Executed:select id FROM `wi` where city='Ashland' && SIC_code='7231'DB:business_master_new
loadtime:0.59437584877014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athelstane' limit 1
loadtime:0.59443783760071 / seconds
Query Executed:select id FROM `wi` where city='Athelstane' && SIC_code='7231'DB:business_master_new
loadtime:0.5996880531311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.59974598884583 / seconds
Query Executed:select id FROM `wi` where city='Athens' && SIC_code='7231'DB:business_master_new
loadtime:0.60318303108215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.60322999954224 / seconds
Query Executed:select id FROM `wi` where city='Auburndale' && SIC_code='7231'DB:business_master_new
loadtime:0.61810183525085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.61816000938416 / seconds
Query Executed:select id FROM `wi` where city='Augusta' && SIC_code='7231'DB:business_master_new
loadtime:0.6430459022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.64311003684998 / seconds
Query Executed:select id FROM `wi` where city='Avalon' && SIC_code='7231'DB:business_master_new
loadtime:0.64880704879761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.64886593818665 / seconds
Query Executed:select id FROM `wi` where city='Avoca' && SIC_code='7231'DB:business_master_new
loadtime:0.65777993202209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babcock' limit 1
loadtime:0.65783095359802 / seconds
Query Executed:select id FROM `wi` where city='Babcock' && SIC_code='7231'DB:business_master_new
loadtime:0.65977001190186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.65979886054993 / seconds
Query Executed:select id FROM `wi` where city='Bagley' && SIC_code='7231'DB:business_master_new
loadtime:0.66493487358093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileys Harbor' limit 1
loadtime:0.66498589515686 / seconds
Query Executed:select id FROM `wi` where city='Baileys Harbor' && SIC_code='7231'DB:business_master_new
loadtime:0.69001889228821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.69012689590454 / seconds
Query Executed:select id FROM `wi` where city='Baldwin' && SIC_code='7231'DB:business_master_new
loadtime:0.69501686096191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam Lake' limit 1
loadtime:0.69506883621216 / seconds
Query Executed:select id FROM `wi` where city='Balsam Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.72702503204346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.72712898254395 / seconds
Query Executed:select id FROM `wi` where city='Bancroft' && SIC_code='7231'DB:business_master_new
loadtime:0.73981285095215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bangor' limit 1
loadtime:0.73986792564392 / seconds
Query Executed:select id FROM `wi` where city='Bangor' && SIC_code='7231'DB:business_master_new
loadtime:0.76012301445007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baraboo' limit 1
loadtime:0.7601900100708 / seconds
Query Executed:select id FROM `wi` where city='Baraboo' && SIC_code='7231'DB:business_master_new
loadtime:0.7694628238678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes' limit 1
loadtime:0.76954483985901 / seconds
Query Executed:select id FROM `wi` where city='Barnes' && SIC_code='7231'DB:business_master_new
loadtime:0.77078700065613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barneveld' limit 1
loadtime:0.77083492279053 / seconds
Query Executed:select id FROM `wi` where city='Barneveld' && SIC_code='7231'DB:business_master_new
loadtime:0.78354001045227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barron' limit 1
loadtime:0.78359198570251 / seconds
Query Executed:select id FROM `wi` where city='Barron' && SIC_code='7231'DB:business_master_new
loadtime:0.78739190101624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barronett' limit 1
loadtime:0.78745102882385 / seconds
Query Executed:select id FROM `wi` where city='Barronett' && SIC_code='7231'DB:business_master_new
loadtime:0.79151391983032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassett' limit 1
loadtime:0.79154682159424 / seconds
Query Executed:select id FROM `wi` where city='Bassett' && SIC_code='7231'DB:business_master_new
loadtime:0.79515600204468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.79520702362061 / seconds
Query Executed:select id FROM `wi` where city='Bay City' && SIC_code='7231'DB:business_master_new
loadtime:0.80091094970703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayfield' limit 1
loadtime:0.80095291137695 / seconds
Query Executed:select id FROM `wi` where city='Bayfield' && SIC_code='7231'DB:business_master_new
loadtime:0.80359292030334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.80364990234375 / seconds
Query Executed:select id FROM `wi` where city='Bear Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.80977082252502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.80981802940369 / seconds
Query Executed:select id FROM `wi` where city='Beaver' && SIC_code='7231'DB:business_master_new
loadtime:0.8101110458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver Dam' limit 1
loadtime:0.81014084815979 / seconds
Query Executed:select id FROM `wi` where city='Beaver Dam' && SIC_code='7231'DB:business_master_new
loadtime:0.82107090950012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beetown' limit 1
loadtime:0.82114601135254 / seconds
Query Executed:select id FROM `wi` where city='Beetown' && SIC_code='7231'DB:business_master_new
loadtime:0.82376003265381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beldenville' limit 1
loadtime:0.82380795478821 / seconds
Query Executed:select id FROM `wi` where city='Beldenville' && SIC_code='7231'DB:business_master_new
loadtime:0.82929801940918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belgium' limit 1
loadtime:0.82932996749878 / seconds
Query Executed:select id FROM `wi` where city='Belgium' && SIC_code='7231'DB:business_master_new
loadtime:0.85556483268738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.85565185546875 / seconds
Query Executed:select id FROM `wi` where city='Belleville' && SIC_code='7231'DB:business_master_new
loadtime:0.85866403579712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.85872101783752 / seconds
Query Executed:select id FROM `wi` where city='Belmont' && SIC_code='7231'DB:business_master_new
loadtime:0.86837196350098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beloit' limit 1
loadtime:0.86843299865723 / seconds
Query Executed:select id FROM `wi` where city='Beloit' && SIC_code='7231'DB:business_master_new
loadtime:0.8809130191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benet Lake' limit 1
loadtime:0.8809928894043 / seconds
Query Executed:select id FROM `wi` where city='Benet Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.88158297538757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.88165187835693 / seconds
Query Executed:select id FROM `wi` where city='Bennett' && SIC_code='7231'DB:business_master_new
loadtime:0.88236594200134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benoit' limit 1
loadtime:0.8824028968811 / seconds
Query Executed:select id FROM `wi` where city='Benoit' && SIC_code='7231'DB:business_master_new
loadtime:0.88481593132019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.88485383987427 / seconds
Query Executed:select id FROM `wi` where city='Benton' && SIC_code='7231'DB:business_master_new
loadtime:0.89494585990906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.89500689506531 / seconds
Query Executed:select id FROM `wi` where city='Berlin' && SIC_code='7231'DB:business_master_new
loadtime:0.89890289306641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bend' limit 1
loadtime:0.89895987510681 / seconds
Query Executed:select id FROM `wi` where city='Big Bend' && SIC_code='7231'DB:business_master_new
loadtime:0.90264892578125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Falls' limit 1
loadtime:0.90269589424133 / seconds
Query Executed:select id FROM `wi` where city='Big Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.90597105026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birchwood' limit 1
loadtime:0.9060218334198 / seconds
Query Executed:select id FROM `wi` where city='Birchwood' && SIC_code='7231'DB:business_master_new
loadtime:0.91441583633423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birnamwood' limit 1
loadtime:0.91446900367737 / seconds
Query Executed:select id FROM `wi` where city='Birnamwood' && SIC_code='7231'DB:business_master_new
loadtime:0.93090391159058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Creek' limit 1
loadtime:0.93096804618835 / seconds
Query Executed:select id FROM `wi` where city='Black Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.93386793136597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Earth' limit 1
loadtime:0.93392086029053 / seconds
Query Executed:select id FROM `wi` where city='Black Earth' && SIC_code='7231'DB:business_master_new
loadtime:0.95458388328552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River Falls' limit 1
loadtime:0.95463395118713 / seconds
Query Executed:select id FROM `wi` where city='Black River Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.95990800857544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River Fls' limit 1
loadtime:0.95998191833496 / seconds
Query Executed:select id FROM `wi` where city='Black River Fls' && SIC_code='7231'DB:business_master_new
loadtime:0.96062898635864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blair' limit 1
loadtime:0.96066904067993 / seconds
Query Executed:select id FROM `wi` where city='Blair' && SIC_code='7231'DB:business_master_new
loadtime:0.97393584251404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchardville' limit 1
loadtime:0.97400784492493 / seconds
Query Executed:select id FROM `wi` where city='Blanchardville' && SIC_code='7231'DB:business_master_new
loadtime:0.98386788368225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blenker' limit 1
loadtime:0.98392486572266 / seconds
Query Executed:select id FROM `wi` where city='Blenker' && SIC_code='7231'DB:business_master_new
loadtime:0.98453593254089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomer' limit 1
loadtime:0.98458099365234 / seconds
Query Executed:select id FROM `wi` where city='Bloomer' && SIC_code='7231'DB:business_master_new
loadtime:0.98798298835754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomington' limit 1
loadtime:0.98803901672363 / seconds
Query Executed:select id FROM `wi` where city='Bloomington' && SIC_code='7231'DB:business_master_new
loadtime:1.0029268264771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Mounds' limit 1
loadtime:1.0029919147491 / seconds
Query Executed:select id FROM `wi` where city='Blue Mounds' && SIC_code='7231'DB:business_master_new
loadtime:1.0100359916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue River' limit 1
loadtime:1.0100920200348 / seconds
Query Executed:select id FROM `wi` where city='Blue River' && SIC_code='7231'DB:business_master_new
loadtime:1.0156488418579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonduel' limit 1
loadtime:1.015704870224 / seconds
Query Executed:select id FROM `wi` where city='Bonduel' && SIC_code='7231'DB:business_master_new
loadtime:1.0188179016113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscobel' limit 1
loadtime:1.0188670158386 / seconds
Query Executed:select id FROM `wi` where city='Boscobel' && SIC_code='7231'DB:business_master_new
loadtime:1.021919965744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder Junction' limit 1
loadtime:1.0219850540161 / seconds
Query Executed:select id FROM `wi` where city='Boulder Junction' && SIC_code='7231'DB:business_master_new
loadtime:1.0317618846893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowler' limit 1
loadtime:1.0318160057068 / seconds
Query Executed:select id FROM `wi` where city='Bowler' && SIC_code='7231'DB:business_master_new
loadtime:1.0412318706512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyceville' limit 1
loadtime:1.0412859916687 / seconds
Query Executed:select id FROM `wi` where city='Boyceville' && SIC_code='7231'DB:business_master_new
loadtime:1.0510718822479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyd' limit 1
loadtime:1.0511338710785 / seconds
Query Executed:select id FROM `wi` where city='Boyd' && SIC_code='7231'DB:business_master_new
loadtime:1.0601580142975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:1.0602169036865 / seconds
Query Executed:select id FROM `wi` where city='Brandon' && SIC_code='7231'DB:business_master_new
loadtime:1.0719628334045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brantwood' limit 1
loadtime:1.072028875351 / seconds
Query Executed:select id FROM `wi` where city='Brantwood' && SIC_code='7231'DB:business_master_new
loadtime:1.0743198394775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Briggsville' limit 1
loadtime:1.0743730068207 / seconds
Query Executed:select id FROM `wi` where city='Briggsville' && SIC_code='7231'DB:business_master_new
loadtime:1.0782709121704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brill' limit 1
loadtime:1.0783159732819 / seconds
Query Executed:select id FROM `wi` where city='Brill' && SIC_code='7231'DB:business_master_new
loadtime:1.078626871109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brillion' limit 1
loadtime:1.0786578655243 / seconds
Query Executed:select id FROM `wi` where city='Brillion' && SIC_code='7231'DB:business_master_new
loadtime:1.0816378593445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:1.0816919803619 / seconds
Query Executed:select id FROM `wi` where city='Bristol' && SIC_code='7231'DB:business_master_new
loadtime:1.0844819545746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brodhead' limit 1
loadtime:1.0845379829407 / seconds
Query Executed:select id FROM `wi` where city='Brodhead' && SIC_code='7231'DB:business_master_new
loadtime:1.087947845459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brokaw' limit 1
loadtime:1.0879900455475 / seconds
Query Executed:select id FROM `wi` where city='Brokaw' && SIC_code='7231'DB:business_master_new
loadtime:1.089026927948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:1.0890698432922 / seconds
Query Executed:select id FROM `wi` where city='Brookfield' && SIC_code='7231'DB:business_master_new
loadtime:1.1193239688873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:1.1195359230042 / seconds
Query Executed:select id FROM `wi` where city='Brooklyn' && SIC_code='7231'DB:business_master_new
loadtime:1.1352009773254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsville' limit 1
loadtime:1.1352670192719 / seconds
Query Executed:select id FROM `wi` where city='Brownsville' && SIC_code='7231'DB:business_master_new
loadtime:1.1415219306946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browntown' limit 1
loadtime:1.141566991806 / seconds
Query Executed:select id FROM `wi` where city='Browntown' && SIC_code='7231'DB:business_master_new
loadtime:1.1491889953613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:1.1492450237274 / seconds
Query Executed:select id FROM `wi` where city='Bruce' && SIC_code='7231'DB:business_master_new
loadtime:1.1619160175323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brule' limit 1
loadtime:1.1619889736176 / seconds
Query Executed:select id FROM `wi` where city='Brule' && SIC_code='7231'DB:business_master_new
loadtime:1.1658568382263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brussels' limit 1
loadtime:1.1659100055695 / seconds
Query Executed:select id FROM `wi` where city='Brussels' && SIC_code='7231'DB:business_master_new
loadtime:1.1720678806305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:1.1721339225769 / seconds
Query Executed:select id FROM `wi` where city='Bryant' && SIC_code='7231'DB:business_master_new
loadtime:1.1751699447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo City' limit 1
loadtime:1.1752128601074 / seconds
Query Executed:select id FROM `wi` where city='Buffalo City' && SIC_code='7231'DB:business_master_new
loadtime:1.1757290363312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:1.175773859024 / seconds
Query Executed:select id FROM `wi` where city='Burlington' && SIC_code='7231'DB:business_master_new
loadtime:1.1807279586792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnett' limit 1
loadtime:1.1807818412781 / seconds
Query Executed:select id FROM `wi` where city='Burnett' && SIC_code='7231'DB:business_master_new
loadtime:1.184562921524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:1.1846120357513 / seconds
Query Executed:select id FROM `wi` where city='Butler' && SIC_code='7231'DB:business_master_new
loadtime:1.1871628761292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butte Des Morts' limit 1
loadtime:1.1872198581696 / seconds
Query Executed:select id FROM `wi` where city='Butte Des Morts' && SIC_code='7231'DB:business_master_new
loadtime:1.1879699230194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butternut' limit 1
loadtime:1.1880118846893 / seconds
Query Executed:select id FROM `wi` where city='Butternut' && SIC_code='7231'DB:business_master_new
loadtime:1.195063829422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:1.1951179504395 / seconds
Query Executed:select id FROM `wi` where city='Byron' && SIC_code='7231'DB:business_master_new
loadtime:1.1954250335693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cable' limit 1
loadtime:1.1954669952393 / seconds
Query Executed:select id FROM `wi` where city='Cable' && SIC_code='7231'DB:business_master_new
loadtime:1.2143568992615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cadott' limit 1
loadtime:1.2144048213959 / seconds
Query Executed:select id FROM `wi` where city='Cadott' && SIC_code='7231'DB:business_master_new
loadtime:1.2169189453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:1.2169740200043 / seconds
Query Executed:select id FROM `wi` where city='Caledonia' && SIC_code='7231'DB:business_master_new
loadtime:1.2299489974976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambria' limit 1
loadtime:1.2300138473511 / seconds
Query Executed:select id FROM `wi` where city='Cambria' && SIC_code='7231'DB:business_master_new
loadtime:1.2375040054321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:1.2375569343567 / seconds
Query Executed:select id FROM `wi` where city='Cambridge' && SIC_code='7231'DB:business_master_new
loadtime:1.2404248714447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:1.2404799461365 / seconds
Query Executed:select id FROM `wi` where city='Cameron' && SIC_code='7231'DB:business_master_new
loadtime:1.2437930107117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Douglas' limit 1
loadtime:1.2438340187073 / seconds
Query Executed:select id FROM `wi` where city='Camp Douglas' && SIC_code='7231'DB:business_master_new
loadtime:1.2517578601837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Lake' limit 1
loadtime:1.2518110275269 / seconds
Query Executed:select id FROM `wi` where city='Camp Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.2523670196533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campbellsport' limit 1
loadtime:1.2524108886719 / seconds
Query Executed:select id FROM `wi` where city='Campbellsport' && SIC_code='7231'DB:business_master_new
loadtime:1.2552919387817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caroline' limit 1
loadtime:1.2553670406342 / seconds
Query Executed:select id FROM `wi` where city='Caroline' && SIC_code='7231'DB:business_master_new
loadtime:1.2560729980469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:1.2561268806458 / seconds
Query Executed:select id FROM `wi` where city='Cascade' && SIC_code='7231'DB:business_master_new
loadtime:1.261195898056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casco' limit 1
loadtime:1.2612538337708 / seconds
Query Executed:select id FROM `wi` where city='Casco' && SIC_code='7231'DB:business_master_new
loadtime:1.2715489864349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashton' limit 1
loadtime:1.2716038227081 / seconds
Query Executed:select id FROM `wi` where city='Cashton' && SIC_code='7231'DB:business_master_new
loadtime:1.2848260402679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassville' limit 1
loadtime:1.2848830223083 / seconds
Query Executed:select id FROM `wi` where city='Cassville' && SIC_code='7231'DB:business_master_new
loadtime:1.2954540252686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataract' limit 1
loadtime:1.2955119609833 / seconds
Query Executed:select id FROM `wi` where city='Cataract' && SIC_code='7231'DB:business_master_new
loadtime:1.2960269451141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:1.2960669994354 / seconds
Query Executed:select id FROM `wi` where city='Catawba' && SIC_code='7231'DB:business_master_new
loadtime:1.2985908985138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cato' limit 1
loadtime:1.2986388206482 / seconds
Query Executed:select id FROM `wi` where city='Cato' && SIC_code='7231'DB:business_master_new
loadtime:1.29891705513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:1.2989599704742 / seconds
Query Executed:select id FROM `wi` where city='Cavour' && SIC_code='7231'DB:business_master_new
loadtime:1.2992389202118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cazenovia' limit 1
loadtime:1.2992758750916 / seconds
Query Executed:select id FROM `wi` where city='Cazenovia' && SIC_code='7231'DB:business_master_new
loadtime:1.3048138618469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cecil' limit 1
loadtime:1.3048689365387 / seconds
Query Executed:select id FROM `wi` where city='Cecil' && SIC_code='7231'DB:business_master_new
loadtime:1.3105518817902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:1.3106138706207 / seconds
Query Executed:select id FROM `wi` where city='Cedar Grove' && SIC_code='7231'DB:business_master_new
loadtime:1.3178019523621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarburg' limit 1
loadtime:1.3178579807281 / seconds
Query Executed:select id FROM `wi` where city='Cedarburg' && SIC_code='7231'DB:business_master_new
loadtime:1.321634054184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centuria' limit 1
loadtime:1.3216798305511 / seconds
Query Executed:select id FROM `wi` where city='Centuria' && SIC_code='7231'DB:business_master_new
loadtime:1.3270699977875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaseburg' limit 1
loadtime:1.3271219730377 / seconds
Query Executed:select id FROM `wi` where city='Chaseburg' && SIC_code='7231'DB:business_master_new
loadtime:1.3314418792725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chetek' limit 1
loadtime:1.3314769268036 / seconds
Query Executed:select id FROM `wi` where city='Chetek' && SIC_code='7231'DB:business_master_new
loadtime:1.3349089622498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chili' limit 1
loadtime:1.3349640369415 / seconds
Query Executed:select id FROM `wi` where city='Chili' && SIC_code='7231'DB:business_master_new
loadtime:1.3370850086212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilton' limit 1
loadtime:1.3371279239655 / seconds
Query Executed:select id FROM `wi` where city='Chilton' && SIC_code='7231'DB:business_master_new
loadtime:1.3419079780579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chippewa Falls' limit 1
loadtime:1.3419749736786 / seconds
Query Executed:select id FROM `wi` where city='Chippewa Falls' && SIC_code='7231'DB:business_master_new
loadtime:1.3472969532013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clam Falls' limit 1
loadtime:1.3473708629608 / seconds
Query Executed:select id FROM `wi` where city='Clam Falls' && SIC_code='7231'DB:business_master_new
loadtime:1.3476328849792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clam Lake' limit 1
loadtime:1.3476779460907 / seconds
Query Executed:select id FROM `wi` where city='Clam Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.3481278419495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:1.3481650352478 / seconds
Query Executed:select id FROM `wi` where city='Clayton' && SIC_code='7231'DB:business_master_new
loadtime:1.3538229465485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:1.3538680076599 / seconds
Query Executed:select id FROM `wi` where city='Clear Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.3729939460754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:1.3730540275574 / seconds
Query Executed:select id FROM `wi` where city='Cleveland' && SIC_code='7231'DB:business_master_new
loadtime:1.3780579566956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:1.3781259059906 / seconds
Query Executed:select id FROM `wi` where city='Clinton' && SIC_code='7231'DB:business_master_new
loadtime:1.3818159103394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clintonville' limit 1
loadtime:1.3818678855896 / seconds
Query Executed:select id FROM `wi` where city='Clintonville' && SIC_code='7231'DB:business_master_new
loadtime:1.3857879638672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyman' limit 1
loadtime:1.385833978653 / seconds
Query Executed:select id FROM `wi` where city='Clyman' && SIC_code='7231'DB:business_master_new
loadtime:1.3870048522949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobb' limit 1
loadtime:1.3870508670807 / seconds
Query Executed:select id FROM `wi` where city='Cobb' && SIC_code='7231'DB:business_master_new
loadtime:1.3892738819122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochrane' limit 1
loadtime:1.389310836792 / seconds
Query Executed:select id FROM `wi` where city='Cochrane' && SIC_code='7231'DB:business_master_new
loadtime:1.4000639915466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colby' limit 1
loadtime:1.4001150131226 / seconds
Query Executed:select id FROM `wi` where city='Colby' && SIC_code='7231'DB:business_master_new
loadtime:1.4090139865875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman' limit 1
loadtime:1.4090778827667 / seconds
Query Executed:select id FROM `wi` where city='Coleman' && SIC_code='7231'DB:business_master_new
loadtime:1.418468952179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:1.4185240268707 / seconds
Query Executed:select id FROM `wi` where city='Colfax' && SIC_code='7231'DB:business_master_new
loadtime:1.4209878444672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colgate' limit 1
loadtime:1.4210329055786 / seconds
Query Executed:select id FROM `wi` where city='Colgate' && SIC_code='7231'DB:business_master_new
loadtime:1.430783033371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:1.4308388233185 / seconds
Query Executed:select id FROM `wi` where city='Collins' && SIC_code='7231'DB:business_master_new
loadtime:1.4314858913422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coloma' limit 1
loadtime:1.4315328598022 / seconds
Query Executed:select id FROM `wi` where city='Coloma' && SIC_code='7231'DB:business_master_new
loadtime:1.4384398460388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:1.4384958744049 / seconds
Query Executed:select id FROM `wi` where city='Columbus' && SIC_code='7231'DB:business_master_new
loadtime:1.44269490242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Combined Locks' limit 1
loadtime:1.4427428245544 / seconds
Query Executed:select id FROM `wi` where city='Combined Locks' && SIC_code='7231'DB:business_master_new
loadtime:1.4470298290253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock' limit 1
loadtime:1.4470798969269 / seconds
Query Executed:select id FROM `wi` where city='Comstock' && SIC_code='7231'DB:business_master_new
loadtime:1.4491448402405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conover' limit 1
loadtime:1.449187040329 / seconds
Query Executed:select id FROM `wi` where city='Conover' && SIC_code='7231'DB:business_master_new
loadtime:1.452085018158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrath' limit 1
loadtime:1.4521219730377 / seconds
Query Executed:select id FROM `wi` where city='Conrath' && SIC_code='7231'DB:business_master_new
loadtime:1.4537689685822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Valley' limit 1
loadtime:1.4538149833679 / seconds
Query Executed:select id FROM `wi` where city='Coon Valley' && SIC_code='7231'DB:business_master_new
loadtime:1.4616520404816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornell' limit 1
loadtime:1.4616930484772 / seconds
Query Executed:select id FROM `wi` where city='Cornell' && SIC_code='7231'DB:business_master_new
loadtime:1.474378824234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornucopia' limit 1
loadtime:1.4744529724121 / seconds
Query Executed:select id FROM `wi` where city='Cornucopia' && SIC_code='7231'DB:business_master_new
loadtime:1.4761519432068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottage Grove' limit 1
loadtime:1.4761829376221 / seconds
Query Executed:select id FROM `wi` where city='Cottage Grove' && SIC_code='7231'DB:business_master_new
loadtime:1.4806430339813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Couderay' limit 1
loadtime:1.4807000160217 / seconds
Query Executed:select id FROM `wi` where city='Couderay' && SIC_code='7231'DB:business_master_new
loadtime:1.4832170009613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crandon' limit 1
loadtime:1.4832739830017 / seconds
Query Executed:select id FROM `wi` where city='Crandon' && SIC_code='7231'DB:business_master_new
loadtime:1.4860029220581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crivitz' limit 1
loadtime:1.4860508441925 / seconds
Query Executed:select id FROM `wi` where city='Crivitz' && SIC_code='7231'DB:business_master_new
loadtime:1.4894850254059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Plains' limit 1
loadtime:1.4895489215851 / seconds
Query Executed:select id FROM `wi` where city='Cross Plains' && SIC_code='7231'DB:business_master_new
loadtime:1.4926419258118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba City' limit 1
loadtime:1.4926948547363 / seconds
Query Executed:select id FROM `wi` where city='Cuba City' && SIC_code='7231'DB:business_master_new
loadtime:1.4956068992615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cudahy' limit 1
loadtime:1.4956588745117 / seconds
Query Executed:select id FROM `wi` where city='Cudahy' && SIC_code='7231'DB:business_master_new
loadtime:1.499568939209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:1.4996299743652 / seconds
Query Executed:select id FROM `wi` where city='Cumberland' && SIC_code='7231'DB:business_master_new
loadtime:1.5032079219818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtiss' limit 1
loadtime:1.5032670497894 / seconds
Query Executed:select id FROM `wi` where city='Curtiss' && SIC_code='7231'DB:business_master_new
loadtime:1.5076379776001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:1.5076818466187 / seconds
Query Executed:select id FROM `wi` where city='Cushing' && SIC_code='7231'DB:business_master_new
loadtime:1.51109790802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:1.5111489295959 / seconds
Query Executed:select id FROM `wi` where city='Custer' && SIC_code='7231'DB:business_master_new
loadtime:1.5191268920898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dairyland' limit 1
loadtime:1.5191669464111 / seconds
Query Executed:select id FROM `wi` where city='Dairyland' && SIC_code='7231'DB:business_master_new
loadtime:1.519474029541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dale' limit 1
loadtime:1.5195188522339 / seconds
Query Executed:select id FROM `wi` where city='Dale' && SIC_code='7231'DB:business_master_new
loadtime:1.5213959217072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:1.5214600563049 / seconds
Query Executed:select id FROM `wi` where city='Dallas' && SIC_code='7231'DB:business_master_new
loadtime:1.530455827713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:1.5305049419403 / seconds
Query Executed:select id FROM `wi` where city='Dalton' && SIC_code='7231'DB:business_master_new
loadtime:1.5336680412292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:1.5337309837341 / seconds
Query Executed:select id FROM `wi` where city='Danbury' && SIC_code='7231'DB:business_master_new
loadtime:1.54354596138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dane' limit 1
loadtime:1.5435979366302 / seconds
Query Executed:select id FROM `wi` where city='Dane' && SIC_code='7231'DB:business_master_new
loadtime:1.5498039722443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:1.549870967865 / seconds
Query Executed:select id FROM `wi` where city='Darien' && SIC_code='7231'DB:business_master_new
loadtime:1.5551760196686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darlington' limit 1
loadtime:1.5552380084991 / seconds
Query Executed:select id FROM `wi` where city='Darlington' && SIC_code='7231'DB:business_master_new
loadtime:1.558534860611 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Forest' limit 1
loadtime:1.5585858821869 / seconds
Query Executed:select id FROM `wi` where city='De Forest' && SIC_code='7231'DB:business_master_new
loadtime:1.5626199245453 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Pere' limit 1
loadtime:1.56267786026 / seconds
Query Executed:select id FROM `wi` where city='De Pere' && SIC_code='7231'DB:business_master_new
loadtime:1.5672228336334 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:1.5672898292542 / seconds
Query Executed:select id FROM `wi` where city='De Soto' && SIC_code='7231'DB:business_master_new
loadtime:1.5722768306732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deer Park' limit 1
loadtime:1.5723350048065 / seconds
Query Executed:select id FROM `wi` where city='Deer Park' && SIC_code='7231'DB:business_master_new
loadtime:1.5782749652863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerbrook' limit 1
loadtime:1.5783188343048 / seconds
Query Executed:select id FROM `wi` where city='Deerbrook' && SIC_code='7231'DB:business_master_new
loadtime:1.5855100154877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:1.5855638980865 / seconds
Query Executed:select id FROM `wi` where city='Deerfield' && SIC_code='7231'DB:business_master_new
loadtime:1.5880780220032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delafield' limit 1
loadtime:1.5881309509277 / seconds
Query Executed:select id FROM `wi` where city='Delafield' && SIC_code='7231'DB:business_master_new
loadtime:1.5923929214478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delavan' limit 1
loadtime:1.5924608707428 / seconds
Query Executed:select id FROM `wi` where city='Delavan' && SIC_code='7231'DB:business_master_new
loadtime:1.5966420173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dellwood' limit 1
loadtime:1.5966999530792 / seconds
Query Executed:select id FROM `wi` where city='Dellwood' && SIC_code='7231'DB:business_master_new
loadtime:1.5974938869476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:1.5975379943848 / seconds
Query Executed:select id FROM `wi` where city='Denmark' && SIC_code='7231'DB:business_master_new
loadtime:1.6002449989319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickeyville' limit 1
loadtime:1.600301027298 / seconds
Query Executed:select id FROM `wi` where city='Dickeyville' && SIC_code='7231'DB:business_master_new
loadtime:1.603227853775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodge' limit 1
loadtime:1.6032929420471 / seconds
Query Executed:select id FROM `wi` where city='Dodge' && SIC_code='7231'DB:business_master_new
loadtime:1.6041779518127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodgeville' limit 1
loadtime:1.6042199134827 / seconds
Query Executed:select id FROM `wi` where city='Dodgeville' && SIC_code='7231'DB:business_master_new
loadtime:1.6088089942932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:1.6088669300079 / seconds
Query Executed:select id FROM `wi` where city='Dorchester' && SIC_code='7231'DB:business_master_new
loadtime:1.6160278320312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dousman' limit 1
loadtime:1.6160888671875 / seconds
Query Executed:select id FROM `wi` where city='Dousman' && SIC_code='7231'DB:business_master_new
loadtime:1.6185898780823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Downing' limit 1
loadtime:1.618635892868 / seconds
Query Executed:select id FROM `wi` where city='Downing' && SIC_code='7231'DB:business_master_new
loadtime:1.6215209960938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Downsville' limit 1
loadtime:1.6215720176697 / seconds
Query Executed:select id FROM `wi` where city='Downsville' && SIC_code='7231'DB:business_master_new
loadtime:1.6230669021606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doylestown' limit 1
loadtime:1.6231088638306 / seconds
Query Executed:select id FROM `wi` where city='Doylestown' && SIC_code='7231'DB:business_master_new
loadtime:1.6238939762115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dresser' limit 1
loadtime:1.6239469051361 / seconds
Query Executed:select id FROM `wi` where city='Dresser' && SIC_code='7231'DB:business_master_new
loadtime:1.6280479431152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drummond' limit 1
loadtime:1.628096818924 / seconds
Query Executed:select id FROM `wi` where city='Drummond' && SIC_code='7231'DB:business_master_new
loadtime:1.6303648948669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbar' limit 1
loadtime:1.6304190158844 / seconds
Query Executed:select id FROM `wi` where city='Dunbar' && SIC_code='7231'DB:business_master_new
loadtime:1.631520986557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durand' limit 1
loadtime:1.6315639019012 / seconds
Query Executed:select id FROM `wi` where city='Durand' && SIC_code='7231'DB:business_master_new
loadtime:1.6343810558319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:1.6344230175018 / seconds
Query Executed:select id FROM `wi` where city='Eagle' && SIC_code='7231'DB:business_master_new
loadtime:1.6484308242798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle River' limit 1
loadtime:1.6484889984131 / seconds
Query Executed:select id FROM `wi` where city='Eagle River' && SIC_code='7231'DB:business_master_new
loadtime:1.6516938209534 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Ellsworth' limit 1
loadtime:1.6517469882965 / seconds
Query Executed:select id FROM `wi` where city='East Ellsworth' && SIC_code='7231'DB:business_master_new
loadtime:1.6524498462677 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Troy' limit 1
loadtime:1.6525008678436 / seconds
Query Executed:select id FROM `wi` where city='East Troy' && SIC_code='7231'DB:business_master_new
loadtime:1.6557168960571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastman' limit 1
loadtime:1.6557688713074 / seconds
Query Executed:select id FROM `wi` where city='Eastman' && SIC_code='7231'DB:business_master_new
loadtime:1.6582629680634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Claire' limit 1
loadtime:1.6583089828491 / seconds
Query Executed:select id FROM `wi` where city='Eau Claire' && SIC_code='7231'DB:business_master_new
loadtime:1.6680529117584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Galle' limit 1
loadtime:1.6681599617004 / seconds
Query Executed:select id FROM `wi` where city='Eau Galle' && SIC_code='7231'DB:business_master_new
loadtime:1.6700110435486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:1.6700618267059 / seconds
Query Executed:select id FROM `wi` where city='Eden' && SIC_code='7231'DB:business_master_new
loadtime:1.6752078533173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgar' limit 1
loadtime:1.6752648353577 / seconds
Query Executed:select id FROM `wi` where city='Edgar' && SIC_code='7231'DB:business_master_new
loadtime:1.6818070411682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgerton' limit 1
loadtime:1.6818659305573 / seconds
Query Executed:select id FROM `wi` where city='Edgerton' && SIC_code='7231'DB:business_master_new
loadtime:1.6875109672546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:1.687579870224 / seconds
Query Executed:select id FROM `wi` where city='Edgewater' && SIC_code='7231'DB:business_master_new
loadtime:1.6879048347473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmund' limit 1
loadtime:1.6879448890686 / seconds
Query Executed:select id FROM `wi` where city='Edmund' && SIC_code='7231'DB:business_master_new
loadtime:1.6885159015656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor' limit 1
loadtime:1.6885540485382 / seconds
Query Executed:select id FROM `wi` where city='Egg Harbor' && SIC_code='7231'DB:business_master_new
loadtime:1.6910109519958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eland' limit 1
loadtime:1.6910729408264 / seconds
Query Executed:select id FROM `wi` where city='Eland' && SIC_code='7231'DB:business_master_new
loadtime:1.6928558349609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elcho' limit 1
loadtime:1.6928949356079 / seconds
Query Executed:select id FROM `wi` where city='Elcho' && SIC_code='7231'DB:business_master_new
loadtime:1.6956799030304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elderon' limit 1
loadtime:1.6957318782806 / seconds
Query Executed:select id FROM `wi` where city='Elderon' && SIC_code='7231'DB:business_master_new
loadtime:1.6963889598846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:1.6964390277863 / seconds
Query Executed:select id FROM `wi` where city='Eldorado' && SIC_code='7231'DB:business_master_new
loadtime:1.7010679244995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eleva' limit 1
loadtime:1.7011070251465 / seconds
Query Executed:select id FROM `wi` where city='Eleva' && SIC_code='7231'DB:business_master_new
loadtime:1.7140488624573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Mound' limit 1
loadtime:1.7141149044037 / seconds
Query Executed:select id FROM `wi` where city='Elk Mound' && SIC_code='7231'DB:business_master_new
loadtime:1.7250499725342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart Lake' limit 1
loadtime:1.7251038551331 / seconds
Query Executed:select id FROM `wi` where city='Elkhart Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.7276108264923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhorn' limit 1
loadtime:1.7276630401611 / seconds
Query Executed:select id FROM `wi` where city='Elkhorn' && SIC_code='7231'DB:business_master_new
loadtime:1.7315640449524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellison Bay' limit 1
loadtime:1.7316310405731 / seconds
Query Executed:select id FROM `wi` where city='Ellison Bay' && SIC_code='7231'DB:business_master_new
loadtime:1.7372460365295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:1.7372939586639 / seconds
Query Executed:select id FROM `wi` where city='Ellsworth' && SIC_code='7231'DB:business_master_new
loadtime:1.7406558990479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Grove' limit 1
loadtime:1.7407200336456 / seconds
Query Executed:select id FROM `wi` where city='Elm Grove' && SIC_code='7231'DB:business_master_new
loadtime:1.7444820404053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:1.7445418834686 / seconds
Query Executed:select id FROM `wi` where city='Elmwood' && SIC_code='7231'DB:business_master_new
loadtime:1.7488160133362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elroy' limit 1
loadtime:1.7488570213318 / seconds
Query Executed:select id FROM `wi` where city='Elroy' && SIC_code='7231'DB:business_master_new
loadtime:1.7571058273315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elton' limit 1
loadtime:1.7571568489075 / seconds
Query Executed:select id FROM `wi` where city='Elton' && SIC_code='7231'DB:business_master_new
loadtime:1.7575900554657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Embarrass' limit 1
loadtime:1.7576339244843 / seconds
Query Executed:select id FROM `wi` where city='Embarrass' && SIC_code='7231'DB:business_master_new
loadtime:1.7581958770752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerald' limit 1
loadtime:1.7582440376282 / seconds
Query Executed:select id FROM `wi` where city='Emerald' && SIC_code='7231'DB:business_master_new
loadtime:1.7585270404816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Endeavor' limit 1
loadtime:1.7585690021515 / seconds
Query Executed:select id FROM `wi` where city='Endeavor' && SIC_code='7231'DB:business_master_new
loadtime:1.7602889537811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephraim' limit 1
loadtime:1.7603328227997 / seconds
Query Executed:select id FROM `wi` where city='Ephraim' && SIC_code='7231'DB:business_master_new
loadtime:1.7632758617401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ettrick' limit 1
loadtime:1.76331782341 / seconds
Query Executed:select id FROM `wi` where city='Ettrick' && SIC_code='7231'DB:business_master_new
loadtime:1.7680358886719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:1.768089056015 / seconds
Query Executed:select id FROM `wi` where city='Eureka' && SIC_code='7231'DB:business_master_new
loadtime:1.7695119380951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansville' limit 1
loadtime:1.7695589065552 / seconds
Query Executed:select id FROM `wi` where city='Evansville' && SIC_code='7231'DB:business_master_new
loadtime:1.7721638679504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeland' limit 1
loadtime:1.7722189426422 / seconds
Query Executed:select id FROM `wi` where city='Exeland' && SIC_code='7231'DB:business_master_new
loadtime:1.773206949234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Water' limit 1
loadtime:1.7732448577881 / seconds
Query Executed:select id FROM `wi` where city='Fair Water' && SIC_code='7231'DB:business_master_new
loadtime:1.7735838890076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairchild' limit 1
loadtime:1.7736270427704 / seconds
Query Executed:select id FROM `wi` where city='Fairchild' && SIC_code='7231'DB:business_master_new
loadtime:1.7752578258514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairwater' limit 1
loadtime:1.7753109931946 / seconds
Query Executed:select id FROM `wi` where city='Fairwater' && SIC_code='7231'DB:business_master_new
loadtime:1.7757868766785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall Creek' limit 1
loadtime:1.7758169174194 / seconds
Query Executed:select id FROM `wi` where city='Fall Creek' && SIC_code='7231'DB:business_master_new
loadtime:1.7831518650055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:1.783215045929 / seconds
Query Executed:select id FROM `wi` where city='Fall River' && SIC_code='7231'DB:business_master_new
loadtime:1.786435842514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fence' limit 1
loadtime:1.7864880561829 / seconds
Query Executed:select id FROM `wi` where city='Fence' && SIC_code='7231'DB:business_master_new
loadtime:1.7873759269714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fennimore' limit 1
loadtime:1.7874119281769 / seconds
Query Executed:select id FROM `wi` where city='Fennimore' && SIC_code='7231'DB:business_master_new
loadtime:1.7901539802551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwood' limit 1
loadtime:1.7902090549469 / seconds
Query Executed:select id FROM `wi` where city='Fenwood' && SIC_code='7231'DB:business_master_new
loadtime:1.7905049324036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferryville' limit 1
loadtime:1.7905359268188 / seconds
Query Executed:select id FROM `wi` where city='Ferryville' && SIC_code='7231'DB:business_master_new
loadtime:1.7922699451447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fifield' limit 1
loadtime:1.7923238277435 / seconds
Query Executed:select id FROM `wi` where city='Fifield' && SIC_code='7231'DB:business_master_new
loadtime:1.7935788631439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fish Creek' limit 1
loadtime:1.7936229705811 / seconds
Query Executed:select id FROM `wi` where city='Fish Creek' && SIC_code='7231'DB:business_master_new
loadtime:1.7960848808289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:1.7961390018463 / seconds
Query Executed:select id FROM `wi` where city='Fitchburg' && SIC_code='7231'DB:business_master_new
loadtime:1.7971398830414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.797171831131 / seconds
Query Executed:select id FROM `wi` where city='Florence' && SIC_code='7231'DB:business_master_new
loadtime:1.7997250556946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fond Du Lac' limit 1
loadtime:1.7997648715973 / seconds
Query Executed:select id FROM `wi` where city='Fond Du Lac' && SIC_code='7231'DB:business_master_new
loadtime:1.8057188987732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana' limit 1
loadtime:1.8058199882507 / seconds
Query Executed:select id FROM `wi` where city='Fontana' && SIC_code='7231'DB:business_master_new
loadtime:1.8091309070587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Footville' limit 1
loadtime:1.8091878890991 / seconds
Query Executed:select id FROM `wi` where city='Footville' && SIC_code='7231'DB:business_master_new
loadtime:1.8101818561554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Junction' limit 1
loadtime:1.8102190494537 / seconds
Query Executed:select id FROM `wi` where city='Forest Junction' && SIC_code='7231'DB:business_master_new
loadtime:1.8107440471649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestville' limit 1
loadtime:1.8107898235321 / seconds
Query Executed:select id FROM `wi` where city='Forestville' && SIC_code='7231'DB:business_master_new
loadtime:1.8124239444733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:1.812472820282 / seconds
Query Executed:select id FROM `wi` where city='Fort Atkinson' && SIC_code='7231'DB:business_master_new
loadtime:1.8158679008484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mccoy' limit 1
loadtime:1.81591796875 / seconds
Query Executed:select id FROM `wi` where city='Fort Mccoy' && SIC_code='7231'DB:business_master_new
loadtime:1.8162360191345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain City' limit 1
loadtime:1.8162829875946 / seconds
Query Executed:select id FROM `wi` where city='Fountain City' && SIC_code='7231'DB:business_master_new
loadtime:1.8203608989716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fox Lake' limit 1
loadtime:1.8204188346863 / seconds
Query Executed:select id FROM `wi` where city='Fox Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.8286299705505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:1.8286888599396 / seconds
Query Executed:select id FROM `wi` where city='Foxboro' && SIC_code='7231'DB:business_master_new
loadtime:1.8296010494232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francis Creek' limit 1
loadtime:1.829638004303 / seconds
Query Executed:select id FROM `wi` where city='Francis Creek' && SIC_code='7231'DB:business_master_new
loadtime:1.8304090499878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.8304588794708 / seconds
Query Executed:select id FROM `wi` where city='Franklin' && SIC_code='7231'DB:business_master_new
loadtime:1.8343629837036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franksville' limit 1
loadtime:1.8344328403473 / seconds
Query Executed:select id FROM `wi` where city='Franksville' && SIC_code='7231'DB:business_master_new
loadtime:1.8369648456573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederic' limit 1
loadtime:1.8370189666748 / seconds
Query Executed:select id FROM `wi` where city='Frederic' && SIC_code='7231'DB:business_master_new
loadtime:1.8395869731903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:1.8396408557892 / seconds
Query Executed:select id FROM `wi` where city='Fredonia' && SIC_code='7231'DB:business_master_new
loadtime:1.8454079627991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:1.845468044281 / seconds
Query Executed:select id FROM `wi` where city='Freedom' && SIC_code='7231'DB:business_master_new
loadtime:1.8458240032196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:1.8458650112152 / seconds
Query Executed:select id FROM `wi` where city='Fremont' && SIC_code='7231'DB:business_master_new
loadtime:1.8497059345245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friendship' limit 1
loadtime:1.8497560024261 / seconds
Query Executed:select id FROM `wi` where city='Friendship' && SIC_code='7231'DB:business_master_new
loadtime:1.8523058891296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friesland' limit 1
loadtime:1.8523700237274 / seconds
Query Executed:select id FROM `wi` where city='Friesland' && SIC_code='7231'DB:business_master_new
loadtime:1.853257894516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesville' limit 1
loadtime:1.8533108234406 / seconds
Query Executed:select id FROM `wi` where city='Galesville' && SIC_code='7231'DB:business_master_new
loadtime:1.8558089733124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galloway' limit 1
loadtime:1.8558599948883 / seconds
Query Executed:select id FROM `wi` where city='Galloway' && SIC_code='7231'DB:business_master_new
loadtime:1.8561370372772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gays Mills' limit 1
loadtime:1.8561768531799 / seconds
Query Executed:select id FROM `wi` where city='Gays Mills' && SIC_code='7231'DB:business_master_new
loadtime:1.8588309288025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genesee Depot' limit 1
loadtime:1.8588750362396 / seconds
Query Executed:select id FROM `wi` where city='Genesee Depot' && SIC_code='7231'DB:business_master_new
loadtime:1.8613300323486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa' limit 1
loadtime:1.8614058494568 / seconds
Query Executed:select id FROM `wi` where city='Genoa' && SIC_code='7231'DB:business_master_new
loadtime:1.8631880283356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genoa City' limit 1
loadtime:1.8632428646088 / seconds
Query Executed:select id FROM `wi` where city='Genoa City' && SIC_code='7231'DB:business_master_new
loadtime:1.8657748699188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germantown' limit 1
loadtime:1.8658289909363 / seconds
Query Executed:select id FROM `wi` where city='Germantown' && SIC_code='7231'DB:business_master_new
loadtime:1.869393825531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gile' limit 1
loadtime:1.8694489002228 / seconds
Query Executed:select id FROM `wi` where city='Gile' && SIC_code='7231'DB:business_master_new
loadtime:1.869775056839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett' limit 1
loadtime:1.8698189258575 / seconds
Query Executed:select id FROM `wi` where city='Gillett' && SIC_code='7231'DB:business_master_new
loadtime:1.8735978603363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:1.8736460208893 / seconds
Query Executed:select id FROM `wi` where city='Gilman' && SIC_code='7231'DB:business_master_new
loadtime:1.8757638931274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:1.8758180141449 / seconds
Query Executed:select id FROM `wi` where city='Gilmanton' && SIC_code='7231'DB:business_master_new
loadtime:1.8761918544769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gleason' limit 1
loadtime:1.8762319087982 / seconds
Query Executed:select id FROM `wi` where city='Gleason' && SIC_code='7231'DB:business_master_new
loadtime:1.8789179325104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Flora' limit 1
loadtime:1.8789629936218 / seconds
Query Executed:select id FROM `wi` where city='Glen Flora' && SIC_code='7231'DB:business_master_new
loadtime:1.8805258274078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Haven' limit 1
loadtime:1.8805708885193 / seconds
Query Executed:select id FROM `wi` where city='Glen Haven' && SIC_code='7231'DB:business_master_new
loadtime:1.8813638687134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenbeulah' limit 1
loadtime:1.8814029693604 / seconds
Query Executed:select id FROM `wi` where city='Glenbeulah' && SIC_code='7231'DB:business_master_new
loadtime:1.8827309608459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood City' limit 1
loadtime:1.8827760219574 / seconds
Query Executed:select id FROM `wi` where city='Glenwood City' && SIC_code='7231'DB:business_master_new
loadtime:1.8866560459137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:1.8867018222809 / seconds
Query Executed:select id FROM `wi` where city='Glidden' && SIC_code='7231'DB:business_master_new
loadtime:1.8893649578094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodman' limit 1
loadtime:1.889417886734 / seconds
Query Executed:select id FROM `wi` where city='Goodman' && SIC_code='7231'DB:business_master_new
loadtime:1.8902189731598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordon' limit 1
loadtime:1.8902640342712 / seconds
Query Executed:select id FROM `wi` where city='Gordon' && SIC_code='7231'DB:business_master_new
loadtime:1.8918159008026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gotham' limit 1
loadtime:1.8918590545654 / seconds
Query Executed:select id FROM `wi` where city='Gotham' && SIC_code='7231'DB:business_master_new
loadtime:1.8924579620361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:1.8925018310547 / seconds
Query Executed:select id FROM `wi` where city='Grafton' && SIC_code='7231'DB:business_master_new
loadtime:1.8959808349609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Marsh' limit 1
loadtime:1.8960409164429 / seconds
Query Executed:select id FROM `wi` where city='Grand Marsh' && SIC_code='7231'DB:business_master_new
loadtime:1.8976218700409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand View' limit 1
loadtime:1.8976528644562 / seconds
Query Executed:select id FROM `wi` where city='Grand View' && SIC_code='7231'DB:business_master_new
loadtime:1.8986179828644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granton' limit 1
loadtime:1.898668050766 / seconds
Query Executed:select id FROM `wi` where city='Granton' && SIC_code='7231'DB:business_master_new
loadtime:1.8998880386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsburg' limit 1
loadtime:1.8999400138855 / seconds
Query Executed:select id FROM `wi` where city='Grantsburg' && SIC_code='7231'DB:business_master_new
loadtime:1.9024930000305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gratiot' limit 1
loadtime:1.9025459289551 / seconds
Query Executed:select id FROM `wi` where city='Gratiot' && SIC_code='7231'DB:business_master_new
loadtime:1.9065048694611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Bay' limit 1
loadtime:1.9065499305725 / seconds
Query Executed:select id FROM `wi` where city='Green Bay' && SIC_code='7231'DB:business_master_new
loadtime:1.916925907135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Lake' limit 1
loadtime:1.9170858860016 / seconds
Query Executed:select id FROM `wi` where city='Green Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.9201219081879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:1.9201848506927 / seconds
Query Executed:select id FROM `wi` where city='Green Valley' && SIC_code='7231'DB:business_master_new
loadtime:1.9205470085144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.9205918312073 / seconds
Query Executed:select id FROM `wi` where city='Greenbush' && SIC_code='7231'DB:business_master_new
loadtime:1.920982837677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greendale' limit 1
loadtime:1.9210200309753 / seconds
Query Executed:select id FROM `wi` where city='Greendale' && SIC_code='7231'DB:business_master_new
loadtime:1.9254419803619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:1.9254989624023 / seconds
Query Executed:select id FROM `wi` where city='Greenfield' && SIC_code='7231'DB:business_master_new
loadtime:1.9264059066772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenleaf' limit 1
loadtime:1.9264509677887 / seconds
Query Executed:select id FROM `wi` where city='Greenleaf' && SIC_code='7231'DB:business_master_new
loadtime:1.9296548366547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.929703950882 / seconds
Query Executed:select id FROM `wi` where city='Greenville' && SIC_code='7231'DB:business_master_new
loadtime:1.9322228431702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.9322848320007 / seconds
Query Executed:select id FROM `wi` where city='Greenwood' && SIC_code='7231'DB:business_master_new
loadtime:1.937068939209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gresham' limit 1
loadtime:1.9371228218079 / seconds
Query Executed:select id FROM `wi` where city='Gresham' && SIC_code='7231'DB:business_master_new
loadtime:1.9385998249054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hager City' limit 1
loadtime:1.9386548995972 / seconds
Query Executed:select id FROM `wi` where city='Hager City' && SIC_code='7231'DB:business_master_new
loadtime:1.9405009746552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Corners' limit 1
loadtime:1.9405338764191 / seconds
Query Executed:select id FROM `wi` where city='Hales Corners' && SIC_code='7231'DB:business_master_new
loadtime:1.9447710514069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:1.9448599815369 / seconds
Query Executed:select id FROM `wi` where city='Hamburg' && SIC_code='7231'DB:business_master_new
loadtime:1.9451339244843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hammond' limit 1
loadtime:1.9451758861542 / seconds
Query Executed:select id FROM `wi` where city='Hammond' && SIC_code='7231'DB:business_master_new
loadtime:1.9480128288269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.9480650424957 / seconds
Query Executed:select id FROM `wi` where city='Hancock' && SIC_code='7231'DB:business_master_new
loadtime:1.949481010437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hannibal' limit 1
loadtime:1.9495339393616 / seconds
Query Executed:select id FROM `wi` where city='Hannibal' && SIC_code='7231'DB:business_master_new
loadtime:1.9498698711395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.9499089717865 / seconds
Query Executed:select id FROM `wi` where city='Hanover' && SIC_code='7231'DB:business_master_new
loadtime:1.9502379894257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harshaw' limit 1
loadtime:1.9502780437469 / seconds
Query Executed:select id FROM `wi` where city='Harshaw' && SIC_code='7231'DB:business_master_new
loadtime:1.9518539905548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.9518990516663 / seconds
Query Executed:select id FROM `wi` where city='Hartford' && SIC_code='7231'DB:business_master_new
loadtime:1.9555490016937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:1.9556088447571 / seconds
Query Executed:select id FROM `wi` where city='Hartland' && SIC_code='7231'DB:business_master_new
loadtime:1.9591989517212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatley' limit 1
loadtime:1.9592640399933 / seconds
Query Executed:select id FROM `wi` where city='Hatley' && SIC_code='7231'DB:business_master_new
loadtime:1.9610488414764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haugen' limit 1
loadtime:1.9611039161682 / seconds
Query Executed:select id FROM `wi` where city='Haugen' && SIC_code='7231'DB:business_master_new
loadtime:1.9618010520935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkins' limit 1
loadtime:1.9618330001831 / seconds
Query Executed:select id FROM `wi` where city='Hawkins' && SIC_code='7231'DB:business_master_new
loadtime:1.9629349708557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawthorne' limit 1
loadtime:1.9629819393158 / seconds
Query Executed:select id FROM `wi` where city='Hawthorne' && SIC_code='7231'DB:business_master_new
loadtime:1.9634709358215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayward' limit 1
loadtime:1.9635019302368 / seconds
Query Executed:select id FROM `wi` where city='Hayward' && SIC_code='7231'DB:business_master_new
loadtime:1.967111825943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Green' limit 1
loadtime:1.9671759605408 / seconds
Query Executed:select id FROM `wi` where city='Hazel Green' && SIC_code='7231'DB:business_master_new
loadtime:1.9693210124969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelhurst' limit 1
loadtime:1.9693830013275 / seconds
Query Executed:select id FROM `wi` where city='Hazelhurst' && SIC_code='7231'DB:business_master_new
loadtime:1.9724729061127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heafford Jct' limit 1
loadtime:1.9725239276886 / seconds
Query Executed:select id FROM `wi` where city='Heafford Jct' && SIC_code='7231'DB:business_master_new
loadtime:1.9728100299835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heafford Junction' limit 1
loadtime:1.9728510379791 / seconds
Query Executed:select id FROM `wi` where city='Heafford Junction' && SIC_code='7231'DB:business_master_new
loadtime:1.9731628894806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helenville' limit 1
loadtime:1.9731979370117 / seconds
Query Executed:select id FROM `wi` where city='Helenville' && SIC_code='7231'DB:business_master_new
loadtime:1.9742348194122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herbster' limit 1
loadtime:1.974277973175 / seconds
Query Executed:select id FROM `wi` where city='Herbster' && SIC_code='7231'DB:business_master_new
loadtime:1.9748129844666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hertel' limit 1
loadtime:1.9748430252075 / seconds
Query Executed:select id FROM `wi` where city='Hertel' && SIC_code='7231'DB:business_master_new
loadtime:1.975301027298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hewitt' limit 1
loadtime:1.9753639698029 / seconds
Query Executed:select id FROM `wi` where city='Hewitt' && SIC_code='7231'DB:business_master_new
loadtime:1.9765288829803 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Bridge' limit 1
loadtime:1.9765658378601 / seconds
Query Executed:select id FROM `wi` where city='High Bridge' && SIC_code='7231'DB:business_master_new
loadtime:1.9769849777222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:1.9770288467407 / seconds
Query Executed:select id FROM `wi` where city='Highland' && SIC_code='7231'DB:business_master_new
loadtime:1.9789068698883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilbert' limit 1
loadtime:1.9789578914642 / seconds
Query Executed:select id FROM `wi` where city='Hilbert' && SIC_code='7231'DB:business_master_new
loadtime:1.9824960231781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillpoint' limit 1
loadtime:1.9825358390808 / seconds
Query Executed:select id FROM `wi` where city='Hillpoint' && SIC_code='7231'DB:business_master_new
loadtime:1.9833068847656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.9833660125732 / seconds
Query Executed:select id FROM `wi` where city='Hillsboro' && SIC_code='7231'DB:business_master_new
loadtime:1.985860824585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:1.9859180450439 / seconds
Query Executed:select id FROM `wi` where city='Hillsdale' && SIC_code='7231'DB:business_master_new
loadtime:1.9862158298492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:1.9862549304962 / seconds
Query Executed:select id FROM `wi` where city='Hingham' && SIC_code='7231'DB:business_master_new
loadtime:1.9867029190063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hixton' limit 1
loadtime:1.9867470264435 / seconds
Query Executed:select id FROM `wi` where city='Hixton' && SIC_code='7231'DB:business_master_new
loadtime:1.9890599250793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcombe' limit 1
loadtime:1.989119052887 / seconds
Query Executed:select id FROM `wi` where city='Holcombe' && SIC_code='7231'DB:business_master_new
loadtime:1.9915909767151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollandale' limit 1
loadtime:1.9916470050812 / seconds
Query Executed:select id FROM `wi` where city='Hollandale' && SIC_code='7231'DB:business_master_new
loadtime:1.9928169250488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holmen' limit 1
loadtime:1.9928619861603 / seconds
Query Executed:select id FROM `wi` where city='Holmen' && SIC_code='7231'DB:business_master_new
loadtime:1.9954750537872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:1.9955270290375 / seconds
Query Executed:select id FROM `wi` where city='Honey Creek' && SIC_code='7231'DB:business_master_new
loadtime:1.995903968811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horicon' limit 1
loadtime:1.9959349632263 / seconds
Query Executed:select id FROM `wi` where city='Horicon' && SIC_code='7231'DB:business_master_new
loadtime:1.998419046402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hortonville' limit 1
loadtime:1.9984738826752 / seconds
Query Executed:select id FROM `wi` where city='Hortonville' && SIC_code='7231'DB:business_master_new
loadtime:2.0012600421906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houlton' limit 1
loadtime:2.0013048648834 / seconds
Query Executed:select id FROM `wi` where city='Houlton' && SIC_code='7231'DB:business_master_new
loadtime:2.0024499893188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howards Grove' limit 1
loadtime:2.0024960041046 / seconds
Query Executed:select id FROM `wi` where city='Howards Grove' && SIC_code='7231'DB:business_master_new
loadtime:2.0028228759766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubertus' limit 1
loadtime:2.0028569698334 / seconds
Query Executed:select id FROM `wi` where city='Hubertus' && SIC_code='7231'DB:business_master_new
loadtime:2.0058770179749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:2.0059299468994 / seconds
Query Executed:select id FROM `wi` where city='Hudson' && SIC_code='7231'DB:business_master_new
loadtime:2.0100979804993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humbird' limit 1
loadtime:2.0101628303528 / seconds
Query Executed:select id FROM `wi` where city='Humbird' && SIC_code='7231'DB:business_master_new
loadtime:2.0107698440552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:2.0108189582825 / seconds
Query Executed:select id FROM `wi` where city='Hurley' && SIC_code='7231'DB:business_master_new
loadtime:2.0132818222046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustisford' limit 1
loadtime:2.0133528709412 / seconds
Query Executed:select id FROM `wi` where city='Hustisford' && SIC_code='7231'DB:business_master_new
loadtime:2.0151128768921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hustler' limit 1
loadtime:2.0151579380035 / seconds
Query Executed:select id FROM `wi` where city='Hustler' && SIC_code='7231'DB:business_master_new
loadtime:2.015576839447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:2.0156199932098 / seconds
Query Executed:select id FROM `wi` where city='Independence' && SIC_code='7231'DB:business_master_new
loadtime:2.0190229415894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingram' limit 1
loadtime:2.0190780162811 / seconds
Query Executed:select id FROM `wi` where city='Ingram' && SIC_code='7231'DB:business_master_new
loadtime:2.0193610191345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iola' limit 1
loadtime:2.0194079875946 / seconds
Query Executed:select id FROM `wi` where city='Iola' && SIC_code='7231'DB:business_master_new
loadtime:2.0222458839417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irma' limit 1
loadtime:2.0222978591919 / seconds
Query Executed:select id FROM `wi` where city='Irma' && SIC_code='7231'DB:business_master_new
loadtime:2.0234608650208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Belt' limit 1
loadtime:2.0235090255737 / seconds
Query Executed:select id FROM `wi` where city='Iron Belt' && SIC_code='7231'DB:business_master_new
loadtime:2.0239000320435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Ridge' limit 1
loadtime:2.0239298343658 / seconds
Query Executed:select id FROM `wi` where city='Iron Ridge' && SIC_code='7231'DB:business_master_new
loadtime:2.0259149074554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron River' limit 1
loadtime:2.02596783638 / seconds
Query Executed:select id FROM `wi` where city='Iron River' && SIC_code='7231'DB:business_master_new
loadtime:2.0284678936005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ixonia' limit 1
loadtime:2.0285239219666 / seconds
Query Executed:select id FROM `wi` where city='Ixonia' && SIC_code='7231'DB:business_master_new
loadtime:2.0310618877411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:2.0311119556427 / seconds
Query Executed:select id FROM `wi` where city='Jackson' && SIC_code='7231'DB:business_master_new
loadtime:2.0336899757385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:2.0337369441986 / seconds
Query Executed:select id FROM `wi` where city='Janesville' && SIC_code='7231'DB:business_master_new
loadtime:2.0390908718109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:2.0391988754272 / seconds
Query Executed:select id FROM `wi` where city='Jefferson' && SIC_code='7231'DB:business_master_new
loadtime:2.0423119068146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jim Falls' limit 1
loadtime:2.0423970222473 / seconds
Query Executed:select id FROM `wi` where city='Jim Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.0435259342194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnson Creek' limit 1
loadtime:2.0435688495636 / seconds
Query Executed:select id FROM `wi` where city='Johnson Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.0461230278015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juda' limit 1
loadtime:2.0461778640747 / seconds
Query Executed:select id FROM `wi` where city='Juda' && SIC_code='7231'DB:business_master_new
loadtime:2.0473539829254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jump River' limit 1
loadtime:2.047394990921 / seconds
Query Executed:select id FROM `wi` where city='Jump River' && SIC_code='7231'DB:business_master_new
loadtime:2.0477669239044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction City' limit 1
loadtime:2.0478119850159 / seconds
Query Executed:select id FROM `wi` where city='Junction City' && SIC_code='7231'DB:business_master_new
loadtime:2.0495738983154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juneau' limit 1
loadtime:2.0496189594269 / seconds
Query Executed:select id FROM `wi` where city='Juneau' && SIC_code='7231'DB:business_master_new
loadtime:2.0521168708801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kansasville' limit 1
loadtime:2.0521578788757 / seconds
Query Executed:select id FROM `wi` where city='Kansasville' && SIC_code='7231'DB:business_master_new
loadtime:2.0540568828583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaukauna' limit 1
loadtime:2.054102897644 / seconds
Query Executed:select id FROM `wi` where city='Kaukauna' && SIC_code='7231'DB:business_master_new
loadtime:2.057315826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellnersville' limit 1
loadtime:2.0574018955231 / seconds
Query Executed:select id FROM `wi` where city='Kellnersville' && SIC_code='7231'DB:business_master_new
loadtime:2.057797908783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:2.057844877243 / seconds
Query Executed:select id FROM `wi` where city='Kendall' && SIC_code='7231'DB:business_master_new
loadtime:2.0594909191132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennan' limit 1
loadtime:2.0595369338989 / seconds
Query Executed:select id FROM `wi` where city='Kennan' && SIC_code='7231'DB:business_master_new
loadtime:2.0600638389587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenosha' limit 1
loadtime:2.0601119995117 / seconds
Query Executed:select id FROM `wi` where city='Kenosha' && SIC_code='7231'DB:business_master_new
loadtime:2.0653829574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keshena' limit 1
loadtime:2.0654799938202 / seconds
Query Executed:select id FROM `wi` where city='Keshena' && SIC_code='7231'DB:business_master_new
loadtime:2.0671780109406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewaskum' limit 1
loadtime:2.067234992981 / seconds
Query Executed:select id FROM `wi` where city='Kewaskum' && SIC_code='7231'DB:business_master_new
loadtime:2.0698230266571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewaunee' limit 1
loadtime:2.069864988327 / seconds
Query Executed:select id FROM `wi` where city='Kewaunee' && SIC_code='7231'DB:business_master_new
loadtime:2.0732219219208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiel' limit 1
loadtime:2.0732760429382 / seconds
Query Executed:select id FROM `wi` where city='Kiel' && SIC_code='7231'DB:business_master_new
loadtime:2.0758619308472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kieler' limit 1
loadtime:2.0759029388428 / seconds
Query Executed:select id FROM `wi` where city='Kieler' && SIC_code='7231'DB:business_master_new
loadtime:2.0773479938507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimberly' limit 1
loadtime:2.0773968696594 / seconds
Query Executed:select id FROM `wi` where city='Kimberly' && SIC_code='7231'DB:business_master_new
loadtime:2.0799758434296 / seconds
Query loaded from cache:select * from geodata_geocity where city='King' limit 1
loadtime:2.08003282547 / seconds
Query Executed:select id FROM `wi` where city='King' && SIC_code='7231'DB:business_master_new
loadtime:2.0804789066315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:2.0805089473724 / seconds
Query Executed:select id FROM `wi` where city='Kingston' && SIC_code='7231'DB:business_master_new
loadtime:2.0809729099274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knapp' limit 1
loadtime:2.0810148715973 / seconds
Query Executed:select id FROM `wi` where city='Knapp' && SIC_code='7231'DB:business_master_new
loadtime:2.081750869751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knowles' limit 1
loadtime:2.0818018913269 / seconds
Query Executed:select id FROM `wi` where city='Knowles' && SIC_code='7231'DB:business_master_new
loadtime:2.0820829868317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kohler' limit 1
loadtime:2.0821180343628 / seconds
Query Executed:select id FROM `wi` where city='Kohler' && SIC_code='7231'DB:business_master_new
loadtime:2.0841679573059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Krakow' limit 1
loadtime:2.0842299461365 / seconds
Query Executed:select id FROM `wi` where city='Krakow' && SIC_code='7231'DB:business_master_new
loadtime:2.0849568843842 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Crosse' limit 1
loadtime:2.0850028991699 / seconds
Query Executed:select id FROM `wi` where city='La Crosse' && SIC_code='7231'DB:business_master_new
loadtime:2.0899398326874 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Farge' limit 1
loadtime:2.0900340080261 / seconds
Query Executed:select id FROM `wi` where city='La Farge' && SIC_code='7231'DB:business_master_new
loadtime:2.0917959213257 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Pointe' limit 1
loadtime:2.0918538570404 / seconds
Query Executed:select id FROM `wi` where city='La Pointe' && SIC_code='7231'DB:business_master_new
loadtime:2.0930008888245 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Valle' limit 1
loadtime:2.0930368900299 / seconds
Query Executed:select id FROM `wi` where city='La Valle' && SIC_code='7231'DB:business_master_new
loadtime:2.094801902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lac Du Flambeau' limit 1
loadtime:2.0948498249054 / seconds
Query Executed:select id FROM `wi` where city='Lac Du Flambeau' && SIC_code='7231'DB:business_master_new
loadtime:2.0963599681854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladysmith' limit 1
loadtime:2.0964059829712 / seconds
Query Executed:select id FROM `wi` where city='Ladysmith' && SIC_code='7231'DB:business_master_new
loadtime:2.099102973938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Delton' limit 1
loadtime:2.0991518497467 / seconds
Query Executed:select id FROM `wi` where city='Lake Delton' && SIC_code='7231'DB:business_master_new
loadtime:2.1010718345642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Geneva' limit 1
loadtime:2.1011250019073 / seconds
Query Executed:select id FROM `wi` where city='Lake Geneva' && SIC_code='7231'DB:business_master_new
loadtime:2.1044049263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:2.1044628620148 / seconds
Query Executed:select id FROM `wi` where city='Lake Mills' && SIC_code='7231'DB:business_master_new
loadtime:2.1071438789368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Nebagamon' limit 1
loadtime:2.1072039604187 / seconds
Query Executed:select id FROM `wi` where city='Lake Nebagamon' && SIC_code='7231'DB:business_master_new
loadtime:2.1083469390869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Tomahawk' limit 1
loadtime:2.1083920001984 / seconds
Query Executed:select id FROM `wi` where city='Lake Tomahawk' && SIC_code='7231'DB:business_master_new
loadtime:2.1095039844513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:2.1095540523529 / seconds
Query Executed:select id FROM `wi` where city='Lakewood' && SIC_code='7231'DB:business_master_new
loadtime:2.1111328601837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:2.1111838817596 / seconds
Query Executed:select id FROM `wi` where city='Lancaster' && SIC_code='7231'DB:business_master_new
loadtime:2.113981962204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Land O Lakes' limit 1
loadtime:2.1140449047089 / seconds
Query Executed:select id FROM `wi` where city='Land O Lakes' && SIC_code='7231'DB:business_master_new
loadtime:2.1166310310364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lannon' limit 1
loadtime:2.1166839599609 / seconds
Query Executed:select id FROM `wi` where city='Lannon' && SIC_code='7231'DB:business_master_new
loadtime:2.1183519363403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laona' limit 1
loadtime:2.1183948516846 / seconds
Query Executed:select id FROM `wi` where city='Laona' && SIC_code='7231'DB:business_master_new
loadtime:2.1200020313263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larsen' limit 1
loadtime:2.1200540065765 / seconds
Query Executed:select id FROM `wi` where city='Larsen' && SIC_code='7231'DB:business_master_new
loadtime:2.1218478679657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:2.1219019889832 / seconds
Query Executed:select id FROM `wi` where city='Lebanon' && SIC_code='7231'DB:business_master_new
loadtime:2.1223719120026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lena' limit 1
loadtime:2.1224148273468 / seconds
Query Executed:select id FROM `wi` where city='Lena' && SIC_code='7231'DB:business_master_new
loadtime:2.1242759227753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leopolis' limit 1
loadtime:2.1243169307709 / seconds
Query Executed:select id FROM `wi` where city='Leopolis' && SIC_code='7231'DB:business_master_new
loadtime:2.124755859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:2.1248018741608 / seconds
Query Executed:select id FROM `wi` where city='Lewis' && SIC_code='7231'DB:business_master_new
loadtime:2.1250858306885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lily' limit 1
loadtime:2.1251168251038 / seconds
Query Executed:select id FROM `wi` where city='Lily' && SIC_code='7231'DB:business_master_new
loadtime:2.1254169940948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Ridge' limit 1
loadtime:2.1254529953003 / seconds
Query Executed:select id FROM `wi` where city='Lime Ridge' && SIC_code='7231'DB:business_master_new
loadtime:2.1258549690247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limeridge' limit 1
loadtime:2.1258959770203 / seconds
Query Executed:select id FROM `wi` where city='Limeridge' && SIC_code='7231'DB:business_master_new
loadtime:2.1261529922485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:2.1261930465698 / seconds
Query Executed:select id FROM `wi` where city='Linden' && SIC_code='7231'DB:business_master_new
loadtime:2.1270129680634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Chute' limit 1
loadtime:2.1270430088043 / seconds
Query Executed:select id FROM `wi` where city='Little Chute' && SIC_code='7231'DB:business_master_new
loadtime:2.1296968460083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Suamico' limit 1
loadtime:2.1297559738159 / seconds
Query Executed:select id FROM `wi` where city='Little Suamico' && SIC_code='7231'DB:business_master_new
loadtime:2.1309218406677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:2.1309909820557 / seconds
Query Executed:select id FROM `wi` where city='Livingston' && SIC_code='7231'DB:business_master_new
loadtime:2.1322379112244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodi' limit 1
loadtime:2.1322870254517 / seconds
Query Executed:select id FROM `wi` where city='Lodi' && SIC_code='7231'DB:business_master_new
loadtime:2.1349658966064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loganville' limit 1
loadtime:2.1350250244141 / seconds
Query Executed:select id FROM `wi` where city='Loganville' && SIC_code='7231'DB:business_master_new
loadtime:2.1361029148102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lomira' limit 1
loadtime:2.1361408233643 / seconds
Query Executed:select id FROM `wi` where city='Lomira' && SIC_code='7231'DB:business_master_new
loadtime:2.1390450000763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:2.1391038894653 / seconds
Query Executed:select id FROM `wi` where city='Lone Rock' && SIC_code='7231'DB:business_master_new
loadtime:2.1404190063477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Lake' limit 1
loadtime:2.1404509544373 / seconds
Query Executed:select id FROM `wi` where city='Long Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.1414248943329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretta' limit 1
loadtime:2.1414799690247 / seconds
Query Executed:select id FROM `wi` where city='Loretta' && SIC_code='7231'DB:business_master_new
loadtime:2.1419038772583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:2.1419789791107 / seconds
Query Executed:select id FROM `wi` where city='Lowell' && SIC_code='7231'DB:business_master_new
loadtime:2.1425080299377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loyal' limit 1
loadtime:2.1425518989563 / seconds
Query Executed:select id FROM `wi` where city='Loyal' && SIC_code='7231'DB:business_master_new
loadtime:2.1448068618774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lublin' limit 1
loadtime:2.1448719501495 / seconds
Query Executed:select id FROM `wi` where city='Lublin' && SIC_code='7231'DB:business_master_new
loadtime:2.1454119682312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luck' limit 1
loadtime:2.1454479694366 / seconds
Query Executed:select id FROM `wi` where city='Luck' && SIC_code='7231'DB:business_master_new
loadtime:2.1488120555878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:2.1488928794861 / seconds
Query Executed:select id FROM `wi` where city='Luxemburg' && SIC_code='7231'DB:business_master_new
loadtime:2.1524379253387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndon Station' limit 1
loadtime:2.152510881424 / seconds
Query Executed:select id FROM `wi` where city='Lyndon Station' && SIC_code='7231'DB:business_master_new
loadtime:2.1542799472809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynxville' limit 1
loadtime:2.1543250083923 / seconds
Query Executed:select id FROM `wi` where city='Lynxville' && SIC_code='7231'DB:business_master_new
loadtime:2.15469789505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:2.1547558307648 / seconds
Query Executed:select id FROM `wi` where city='Lyons' && SIC_code='7231'DB:business_master_new
loadtime:2.1553268432617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:2.155387878418 / seconds
Query Executed:select id FROM `wi` where city='Madison' && SIC_code='7231'DB:business_master_new
loadtime:2.1778600215912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maiden Rock' limit 1
loadtime:2.1781899929047 / seconds
Query Executed:select id FROM `wi` where city='Maiden Rock' && SIC_code='7231'DB:business_master_new
loadtime:2.1791770458221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malone' limit 1
loadtime:2.1792500019073 / seconds
Query Executed:select id FROM `wi` where city='Malone' && SIC_code='7231'DB:business_master_new
loadtime:2.1806688308716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manawa' limit 1
loadtime:2.1807239055634 / seconds
Query Executed:select id FROM `wi` where city='Manawa' && SIC_code='7231'DB:business_master_new
loadtime:2.1838319301605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:2.1839048862457 / seconds
Query Executed:select id FROM `wi` where city='Manchester' && SIC_code='7231'DB:business_master_new
loadtime:2.1842098236084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowish Waters' limit 1
loadtime:2.1842479705811 / seconds
Query Executed:select id FROM `wi` where city='Manitowish Waters' && SIC_code='7231'DB:business_master_new
loadtime:2.1894199848175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowish Wtrs' limit 1
loadtime:2.1894779205322 / seconds
Query Executed:select id FROM `wi` where city='Manitowish Wtrs' && SIC_code='7231'DB:business_master_new
loadtime:2.1898519992828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitowoc' limit 1
loadtime:2.1898968219757 / seconds
Query Executed:select id FROM `wi` where city='Manitowoc' && SIC_code='7231'DB:business_master_new
loadtime:2.1940069198608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple' limit 1
loadtime:2.1940948963165 / seconds
Query Executed:select id FROM `wi` where city='Maple' && SIC_code='7231'DB:business_master_new
loadtime:2.1948380470276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplewood' limit 1
loadtime:2.1948928833008 / seconds
Query Executed:select id FROM `wi` where city='Maplewood' && SIC_code='7231'DB:business_master_new
loadtime:2.1952250003815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:2.1952619552612 / seconds
Query Executed:select id FROM `wi` where city='Marathon' && SIC_code='7231'DB:business_master_new
loadtime:2.1981279850006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:2.1981689929962 / seconds
Query Executed:select id FROM `wi` where city='Marengo' && SIC_code='7231'DB:business_master_new
loadtime:2.1993749141693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maribel' limit 1
loadtime:2.1994228363037 / seconds
Query Executed:select id FROM `wi` where city='Maribel' && SIC_code='7231'DB:business_master_new
loadtime:2.2004058361053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marinette' limit 1
loadtime:2.2004380226135 / seconds
Query Executed:select id FROM `wi` where city='Marinette' && SIC_code='7231'DB:business_master_new
loadtime:2.2034430503845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:2.2034978866577 / seconds
Query Executed:select id FROM `wi` where city='Marion' && SIC_code='7231'DB:business_master_new
loadtime:2.2061150074005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Markesan' limit 1
loadtime:2.2061610221863 / seconds
Query Executed:select id FROM `wi` where city='Markesan' && SIC_code='7231'DB:business_master_new
loadtime:2.2090950012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:2.2091469764709 / seconds
Query Executed:select id FROM `wi` where city='Marquette' && SIC_code='7231'DB:business_master_new
loadtime:2.209578037262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:2.209615945816 / seconds
Query Executed:select id FROM `wi` where city='Marshall' && SIC_code='7231'DB:business_master_new
loadtime:2.2126598358154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:2.2127039432526 / seconds
Query Executed:select id FROM `wi` where city='Marshfield' && SIC_code='7231'DB:business_master_new
loadtime:2.2167990207672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:2.2168719768524 / seconds
Query Executed:select id FROM `wi` where city='Mason' && SIC_code='7231'DB:business_master_new
loadtime:2.2185928821564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mather' limit 1
loadtime:2.2186229228973 / seconds
Query Executed:select id FROM `wi` where city='Mather' && SIC_code='7231'DB:business_master_new
loadtime:2.2189419269562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattoon' limit 1
loadtime:2.2189798355103 / seconds
Query Executed:select id FROM `wi` where city='Mattoon' && SIC_code='7231'DB:business_master_new
loadtime:2.2195279598236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauston' limit 1
loadtime:2.2195599079132 / seconds
Query Executed:select id FROM `wi` where city='Mauston' && SIC_code='7231'DB:business_master_new
loadtime:2.2224080562592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayville' limit 1
loadtime:2.2224700450897 / seconds
Query Executed:select id FROM `wi` where city='Mayville' && SIC_code='7231'DB:business_master_new
loadtime:2.2252080440521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mazomanie' limit 1
loadtime:2.2252569198608 / seconds
Query Executed:select id FROM `wi` where city='Mazomanie' && SIC_code='7231'DB:business_master_new
loadtime:2.2275669574738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farland' limit 1
loadtime:2.2276120185852 / seconds
Query Executed:select id FROM `wi` where city='Mc Farland' && SIC_code='7231'DB:business_master_new
loadtime:2.2304840087891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Naughton' limit 1
loadtime:2.2305328845978 / seconds
Query Executed:select id FROM `wi` where city='Mc Naughton' && SIC_code='7231'DB:business_master_new
loadtime:2.2308888435364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:2.2309260368347 / seconds
Query Executed:select id FROM `wi` where city='Medford' && SIC_code='7231'DB:business_master_new
loadtime:2.2339148521423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellen' limit 1
loadtime:2.2339589595795 / seconds
Query Executed:select id FROM `wi` where city='Mellen' && SIC_code='7231'DB:business_master_new
loadtime:2.2349760532379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:2.2350430488586 / seconds
Query Executed:select id FROM `wi` where city='Melrose' && SIC_code='7231'DB:business_master_new
loadtime:2.236428976059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menasha' limit 1
loadtime:2.2365028858185 / seconds
Query Executed:select id FROM `wi` where city='Menasha' && SIC_code='7231'DB:business_master_new
loadtime:2.2396309375763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menomonee Falls' limit 1
loadtime:2.2396898269653 / seconds
Query Executed:select id FROM `wi` where city='Menomonee Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.2438499927521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menomonie' limit 1
loadtime:2.2439520359039 / seconds
Query Executed:select id FROM `wi` where city='Menomonie' && SIC_code='7231'DB:business_master_new
loadtime:2.2471458911896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mequon' limit 1
loadtime:2.2471950054169 / seconds
Query Executed:select id FROM `wi` where city='Mequon' && SIC_code='7231'DB:business_master_new
loadtime:2.25137591362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mercer' limit 1
loadtime:2.2514660358429 / seconds
Query Executed:select id FROM `wi` where city='Mercer' && SIC_code='7231'DB:business_master_new
loadtime:2.2534239292145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:2.2534708976746 / seconds
Query Executed:select id FROM `wi` where city='Merrill' && SIC_code='7231'DB:business_master_new
loadtime:2.2564778327942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrillan' limit 1
loadtime:2.2565219402313 / seconds
Query Executed:select id FROM `wi` where city='Merrillan' && SIC_code='7231'DB:business_master_new
loadtime:2.257896900177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:2.2579610347748 / seconds
Query Executed:select id FROM `wi` where city='Merrimac' && SIC_code='7231'DB:business_master_new
loadtime:2.2591919898987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merton' limit 1
loadtime:2.2592430114746 / seconds
Query Executed:select id FROM `wi` where city='Merton' && SIC_code='7231'DB:business_master_new
loadtime:2.2599709033966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Inlet' limit 1
loadtime:2.2600200176239 / seconds
Query Executed:select id FROM `wi` where city='Middle Inlet' && SIC_code='7231'DB:business_master_new
loadtime:2.2603249549866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:2.2603769302368 / seconds
Query Executed:select id FROM `wi` where city='Middleton' && SIC_code='7231'DB:business_master_new
loadtime:2.2642159461975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikana' limit 1
loadtime:2.2642738819122 / seconds
Query Executed:select id FROM `wi` where city='Mikana' && SIC_code='7231'DB:business_master_new
loadtime:2.2646789550781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:2.2647240161896 / seconds
Query Executed:select id FROM `wi` where city='Milan' && SIC_code='7231'DB:business_master_new
loadtime:2.2650058269501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milladore' limit 1
loadtime:2.2650408744812 / seconds
Query Executed:select id FROM `wi` where city='Milladore' && SIC_code='7231'DB:business_master_new
loadtime:2.2659919261932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millston' limit 1
loadtime:2.2660279273987 / seconds
Query Executed:select id FROM `wi` where city='Millston' && SIC_code='7231'DB:business_master_new
loadtime:2.2664270401001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milltown' limit 1
loadtime:2.2664709091187 / seconds
Query Executed:select id FROM `wi` where city='Milltown' && SIC_code='7231'DB:business_master_new
loadtime:2.2681088447571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:2.2681620121002 / seconds
Query Executed:select id FROM `wi` where city='Milton' && SIC_code='7231'DB:business_master_new
loadtime:2.2709200382233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukee' limit 1
loadtime:2.2709808349609 / seconds
Query Executed:select id FROM `wi` where city='Milwaukee' && SIC_code='7231'DB:business_master_new
loadtime:2.3571639060974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mindoro' limit 1
loadtime:2.3581428527832 / seconds
Query Executed:select id FROM `wi` where city='Mindoro' && SIC_code='7231'DB:business_master_new
loadtime:2.3596048355103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Point' limit 1
loadtime:2.3597009181976 / seconds
Query Executed:select id FROM `wi` where city='Mineral Point' && SIC_code='7231'DB:business_master_new
loadtime:2.3633639812469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minocqua' limit 1
loadtime:2.3634178638458 / seconds
Query Executed:select id FROM `wi` where city='Minocqua' && SIC_code='7231'DB:business_master_new
loadtime:2.3674960136414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minong' limit 1
loadtime:2.3675539493561 / seconds
Query Executed:select id FROM `wi` where city='Minong' && SIC_code='7231'DB:business_master_new
loadtime:2.3700938224792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mishicot' limit 1
loadtime:2.3701429367065 / seconds
Query Executed:select id FROM `wi` where city='Mishicot' && SIC_code='7231'DB:business_master_new
loadtime:2.3719639778137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modena' limit 1
loadtime:2.372006893158 / seconds
Query Executed:select id FROM `wi` where city='Modena' && SIC_code='7231'DB:business_master_new
loadtime:2.3722748756409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondovi' limit 1
loadtime:2.3723058700562 / seconds
Query Executed:select id FROM `wi` where city='Mondovi' && SIC_code='7231'DB:business_master_new
loadtime:2.3750619888306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monico' limit 1
loadtime:2.375109910965 / seconds
Query Executed:select id FROM `wi` where city='Monico' && SIC_code='7231'DB:business_master_new
loadtime:2.3754088878632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:2.3754658699036 / seconds
Query Executed:select id FROM `wi` where city='Monona' && SIC_code='7231'DB:business_master_new
loadtime:2.3759188652039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.3759639263153 / seconds
Query Executed:select id FROM `wi` where city='Monroe' && SIC_code='7231'DB:business_master_new
loadtime:2.3793489933014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montello' limit 1
loadtime:2.3794209957123 / seconds
Query Executed:select id FROM `wi` where city='Montello' && SIC_code='7231'DB:business_master_new
loadtime:2.3819789886475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montfort' limit 1
loadtime:2.3820199966431 / seconds
Query Executed:select id FROM `wi` where city='Montfort' && SIC_code='7231'DB:business_master_new
loadtime:2.383092880249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:2.3831448554993 / seconds
Query Executed:select id FROM `wi` where city='Monticello' && SIC_code='7231'DB:business_master_new
loadtime:2.3849349021912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montreal' limit 1
loadtime:2.3849809169769 / seconds
Query Executed:select id FROM `wi` where city='Montreal' && SIC_code='7231'DB:business_master_new
loadtime:2.3855078220367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisonville' limit 1
loadtime:2.3855359554291 / seconds
Query Executed:select id FROM `wi` where city='Morrisonville' && SIC_code='7231'DB:business_master_new
loadtime:2.3859119415283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosinee' limit 1
loadtime:2.3859658241272 / seconds
Query Executed:select id FROM `wi` where city='Mosinee' && SIC_code='7231'DB:business_master_new
loadtime:2.3887858390808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Calvary' limit 1
loadtime:2.3888740539551 / seconds
Query Executed:select id FROM `wi` where city='Mount Calvary' && SIC_code='7231'DB:business_master_new
loadtime:2.3900740146637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Hope' limit 1
loadtime:2.3901319503784 / seconds
Query Executed:select id FROM `wi` where city='Mount Hope' && SIC_code='7231'DB:business_master_new
loadtime:2.3908569812775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Horeb' limit 1
loadtime:2.3908979892731 / seconds
Query Executed:select id FROM `wi` where city='Mount Horeb' && SIC_code='7231'DB:business_master_new
loadtime:2.3943798542023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:2.3944389820099 / seconds
Query Executed:select id FROM `wi` where city='Mount Sterling' && SIC_code='7231'DB:business_master_new
loadtime:2.3947839736938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain' limit 1
loadtime:2.3948240280151 / seconds
Query Executed:select id FROM `wi` where city='Mountain' && SIC_code='7231'DB:business_master_new
loadtime:2.3960208892822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Calvary' limit 1
loadtime:2.3960950374603 / seconds
Query Executed:select id FROM `wi` where city='Mt Calvary' && SIC_code='7231'DB:business_master_new
loadtime:2.396388053894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Hope' limit 1
loadtime:2.396430015564 / seconds
Query Executed:select id FROM `wi` where city='Mt Hope' && SIC_code='7231'DB:business_master_new
loadtime:2.3966808319092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Horeb' limit 1
loadtime:2.396733045578 / seconds
Query Executed:select id FROM `wi` where city='Mt Horeb' && SIC_code='7231'DB:business_master_new
loadtime:2.3972129821777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:2.3972508907318 / seconds
Query Executed:select id FROM `wi` where city='Mt Sterling' && SIC_code='7231'DB:business_master_new
loadtime:2.3976199626923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mukwonago' limit 1
loadtime:2.3976600170135 / seconds
Query Executed:select id FROM `wi` where city='Mukwonago' && SIC_code='7231'DB:business_master_new
loadtime:2.4015688896179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscoda' limit 1
loadtime:2.4016180038452 / seconds
Query Executed:select id FROM `wi` where city='Muscoda' && SIC_code='7231'DB:business_master_new
loadtime:2.4044959545135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskego' limit 1
loadtime:2.4045579433441 / seconds
Query Executed:select id FROM `wi` where city='Muskego' && SIC_code='7231'DB:business_master_new
loadtime:2.4077458381653 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Fond Du Lac' limit 1
loadtime:2.4078109264374 / seconds
Query Executed:select id FROM `wi` where city='N Fond Du Lac' && SIC_code='7231'DB:business_master_new
loadtime:2.4080798625946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashotah' limit 1
loadtime:2.4081258773804 / seconds
Query Executed:select id FROM `wi` where city='Nashotah' && SIC_code='7231'DB:business_master_new
loadtime:2.4098179340363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navarino' limit 1
loadtime:2.4098799228668 / seconds
Query Executed:select id FROM `wi` where city='Navarino' && SIC_code='7231'DB:business_master_new
loadtime:2.4101538658142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Necedah' limit 1
loadtime:2.410190820694 / seconds
Query Executed:select id FROM `wi` where city='Necedah' && SIC_code='7231'DB:business_master_new
loadtime:2.4122409820557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neenah' limit 1
loadtime:2.4122929573059 / seconds
Query Executed:select id FROM `wi` where city='Neenah' && SIC_code='7231'DB:business_master_new
loadtime:2.415981054306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neillsville' limit 1
loadtime:2.4160449504852 / seconds
Query Executed:select id FROM `wi` where city='Neillsville' && SIC_code='7231'DB:business_master_new
loadtime:2.418664932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nekoosa' limit 1
loadtime:2.4187459945679 / seconds
Query Executed:select id FROM `wi` where city='Nekoosa' && SIC_code='7231'DB:business_master_new
loadtime:2.4212999343872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:2.4213650226593 / seconds
Query Executed:select id FROM `wi` where city='Nelson' && SIC_code='7231'DB:business_master_new
loadtime:2.4222989082336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelsonville' limit 1
loadtime:2.4223518371582 / seconds
Query Executed:select id FROM `wi` where city='Nelsonville' && SIC_code='7231'DB:business_master_new
loadtime:2.4227340221405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neopit' limit 1
loadtime:2.4227609634399 / seconds
Query Executed:select id FROM `wi` where city='Neopit' && SIC_code='7231'DB:business_master_new
loadtime:2.4231598377228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neosho' limit 1
loadtime:2.4231958389282 / seconds
Query Executed:select id FROM `wi` where city='Neosho' && SIC_code='7231'DB:business_master_new
loadtime:2.4243538379669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neshkoro' limit 1
loadtime:2.4243998527527 / seconds
Query Executed:select id FROM `wi` where city='Neshkoro' && SIC_code='7231'DB:business_master_new
loadtime:2.425833940506 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Auburn' limit 1
loadtime:2.4258790016174 / seconds
Query Executed:select id FROM `wi` where city='New Auburn' && SIC_code='7231'DB:business_master_new
loadtime:2.4280409812927 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Berlin' limit 1
loadtime:2.4280920028687 / seconds
Query Executed:select id FROM `wi` where city='New Berlin' && SIC_code='7231'DB:business_master_new
loadtime:2.4319460391998 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Franken' limit 1
loadtime:2.4320268630981 / seconds
Query Executed:select id FROM `wi` where city='New Franken' && SIC_code='7231'DB:business_master_new
loadtime:2.4342000484467 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Glarus' limit 1
loadtime:2.4342398643494 / seconds
Query Executed:select id FROM `wi` where city='New Glarus' && SIC_code='7231'DB:business_master_new
loadtime:2.4367489814758 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holstein' limit 1
loadtime:2.4368000030518 / seconds
Query Executed:select id FROM `wi` where city='New Holstein' && SIC_code='7231'DB:business_master_new
loadtime:2.4393060207367 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lisbon' limit 1
loadtime:2.4393649101257 / seconds
Query Executed:select id FROM `wi` where city='New Lisbon' && SIC_code='7231'DB:business_master_new
loadtime:2.4416918754578 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:2.4417359828949 / seconds
Query Executed:select id FROM `wi` where city='New London' && SIC_code='7231'DB:business_master_new
loadtime:2.4446699619293 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Munster' limit 1
loadtime:2.4447169303894 / seconds
Query Executed:select id FROM `wi` where city='New Munster' && SIC_code='7231'DB:business_master_new
loadtime:2.4451780319214 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Richmond' limit 1
loadtime:2.4452178478241 / seconds
Query Executed:select id FROM `wi` where city='New Richmond' && SIC_code='7231'DB:business_master_new
loadtime:2.4481568336487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newald' limit 1
loadtime:2.4482100009918 / seconds
Query Executed:select id FROM `wi` where city='Newald' && SIC_code='7231'DB:business_master_new
loadtime:2.4485008716583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburg' limit 1
loadtime:2.448539018631 / seconds
Query Executed:select id FROM `wi` where city='Newburg' && SIC_code='7231'DB:business_master_new
loadtime:2.4491589069366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:2.4491989612579 / seconds
Query Executed:select id FROM `wi` where city='Newton' && SIC_code='7231'DB:business_master_new
loadtime:2.4502878189087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niagara' limit 1
loadtime:2.4503128528595 / seconds
Query Executed:select id FROM `wi` where city='Niagara' && SIC_code='7231'DB:business_master_new
loadtime:2.4527819156647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:2.4528229236603 / seconds
Query Executed:select id FROM `wi` where city='Nichols' && SIC_code='7231'DB:business_master_new
loadtime:2.4532680511475 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Freedom' limit 1
loadtime:2.4533100128174 / seconds
Query Executed:select id FROM `wi` where city='North Freedom' && SIC_code='7231'DB:business_master_new
loadtime:2.4545769691467 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Lake' limit 1
loadtime:2.4546208381653 / seconds
Query Executed:select id FROM `wi` where city='North Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.4552688598633 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Prairie' limit 1
loadtime:2.4552989006042 / seconds
Query Executed:select id FROM `wi` where city='North Prairie' && SIC_code='7231'DB:business_master_new
loadtime:2.4569039344788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:2.4569509029388 / seconds
Query Executed:select id FROM `wi` where city='Norwalk' && SIC_code='7231'DB:business_master_new
loadtime:2.4581940174103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Creek' limit 1
loadtime:2.4582369327545 / seconds
Query Executed:select id FROM `wi` where city='Oak Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.4613230228424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:2.4614038467407 / seconds
Query Executed:select id FROM `wi` where city='Oakdale' && SIC_code='7231'DB:business_master_new
loadtime:2.4619090557098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakfield' limit 1
loadtime:2.4619569778442 / seconds
Query Executed:select id FROM `wi` where city='Oakfield' && SIC_code='7231'DB:business_master_new
loadtime:2.4632618427277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconomowoc' limit 1
loadtime:2.4633219242096 / seconds
Query Executed:select id FROM `wi` where city='Oconomowoc' && SIC_code='7231'DB:business_master_new
loadtime:2.467031955719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconto' limit 1
loadtime:2.467111825943 / seconds
Query Executed:select id FROM `wi` where city='Oconto' && SIC_code='7231'DB:business_master_new
loadtime:2.4697890281677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oconto Falls' limit 1
loadtime:2.4698660373688 / seconds
Query Executed:select id FROM `wi` where city='Oconto Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.4725179672241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odanah' limit 1
loadtime:2.4725668430328 / seconds
Query Executed:select id FROM `wi` where city='Odanah' && SIC_code='7231'DB:business_master_new
loadtime:2.4732978343964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogdensburg' limit 1
loadtime:2.4733610153198 / seconds
Query Executed:select id FROM `wi` where city='Ogdensburg' && SIC_code='7231'DB:business_master_new
loadtime:2.4742460250854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogema' limit 1
loadtime:2.4743089675903 / seconds
Query Executed:select id FROM `wi` where city='Ogema' && SIC_code='7231'DB:business_master_new
loadtime:2.4752259254456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ojibwa' limit 1
loadtime:2.4752788543701 / seconds
Query Executed:select id FROM `wi` where city='Ojibwa' && SIC_code='7231'DB:business_master_new
loadtime:2.4757430553436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okauchee' limit 1
loadtime:2.4757919311523 / seconds
Query Executed:select id FROM `wi` where city='Okauchee' && SIC_code='7231'DB:business_master_new
loadtime:2.4768559932709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omro' limit 1
loadtime:2.4769010543823 / seconds
Query Executed:select id FROM `wi` where city='Omro' && SIC_code='7231'DB:business_master_new
loadtime:2.4795598983765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onalaska' limit 1
loadtime:2.4796450138092 / seconds
Query Executed:select id FROM `wi` where city='Onalaska' && SIC_code='7231'DB:business_master_new
loadtime:2.4827678203583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneida' limit 1
loadtime:2.4828360080719 / seconds
Query Executed:select id FROM `wi` where city='Oneida' && SIC_code='7231'DB:business_master_new
loadtime:2.4853558540344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontario' limit 1
loadtime:2.4854068756104 / seconds
Query Executed:select id FROM `wi` where city='Ontario' && SIC_code='7231'DB:business_master_new
loadtime:2.4865498542786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oostburg' limit 1
loadtime:2.486585855484 / seconds
Query Executed:select id FROM `wi` where city='Oostburg' && SIC_code='7231'DB:business_master_new
loadtime:2.4892749786377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oregon' limit 1
loadtime:2.4893338680267 / seconds
Query Executed:select id FROM `wi` where city='Oregon' && SIC_code='7231'DB:business_master_new
loadtime:2.4923150539398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orfordville' limit 1
loadtime:2.4923918247223 / seconds
Query Executed:select id FROM `wi` where city='Orfordville' && SIC_code='7231'DB:business_master_new
loadtime:2.4936800003052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:2.4937319755554 / seconds
Query Executed:select id FROM `wi` where city='Osceola' && SIC_code='7231'DB:business_master_new
loadtime:2.4963870048523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshkosh' limit 1
loadtime:2.4964418411255 / seconds
Query Executed:select id FROM `wi` where city='Oshkosh' && SIC_code='7231'DB:business_master_new
loadtime:2.5014250278473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osseo' limit 1
loadtime:2.5015308856964 / seconds
Query Executed:select id FROM `wi` where city='Osseo' && SIC_code='7231'DB:business_master_new
loadtime:2.5040650367737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owen' limit 1
loadtime:2.5041279792786 / seconds
Query Executed:select id FROM `wi` where city='Owen' && SIC_code='7231'DB:business_master_new
loadtime:2.5058150291443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:2.5058670043945 / seconds
Query Executed:select id FROM `wi` where city='Oxford' && SIC_code='7231'DB:business_master_new
loadtime:2.5078029632568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwaukee' limit 1
loadtime:2.5078549385071 / seconds
Query Executed:select id FROM `wi` where city='Packwaukee' && SIC_code='7231'DB:business_master_new
loadtime:2.5082969665527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:2.508358001709 / seconds
Query Executed:select id FROM `wi` where city='Palmyra' && SIC_code='7231'DB:business_master_new
loadtime:2.5103118419647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pardeeville' limit 1
loadtime:2.5103919506073 / seconds
Query Executed:select id FROM `wi` where city='Pardeeville' && SIC_code='7231'DB:business_master_new
loadtime:2.5129020214081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Falls' limit 1
loadtime:2.5129599571228 / seconds
Query Executed:select id FROM `wi` where city='Park Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.5155520439148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patch Grove' limit 1
loadtime:2.515615940094 / seconds
Query Executed:select id FROM `wi` where city='Patch Grove' && SIC_code='7231'DB:business_master_new
loadtime:2.5160658359528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearson' limit 1
loadtime:2.5161080360413 / seconds
Query Executed:select id FROM `wi` where city='Pearson' && SIC_code='7231'DB:business_master_new
loadtime:2.5164709091187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelican Lake' limit 1
loadtime:2.5165138244629 / seconds
Query Executed:select id FROM `wi` where city='Pelican Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.5172209739685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pell Lake' limit 1
loadtime:2.5172669887543 / seconds
Query Executed:select id FROM `wi` where city='Pell Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.5178589820862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembine' limit 1
loadtime:2.5178878307343 / seconds
Query Executed:select id FROM `wi` where city='Pembine' && SIC_code='7231'DB:business_master_new
loadtime:2.5190448760986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pence' limit 1
loadtime:2.5190880298615 / seconds
Query Executed:select id FROM `wi` where city='Pence' && SIC_code='7231'DB:business_master_new
loadtime:2.519348859787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepin' limit 1
loadtime:2.5193920135498 / seconds
Query Executed:select id FROM `wi` where city='Pepin' && SIC_code='7231'DB:business_master_new
loadtime:2.5205998420715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peshtigo' limit 1
loadtime:2.520635843277 / seconds
Query Executed:select id FROM `wi` where city='Peshtigo' && SIC_code='7231'DB:business_master_new
loadtime:2.5231740474701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pewaukee' limit 1
loadtime:2.5232348442078 / seconds
Query Executed:select id FROM `wi` where city='Pewaukee' && SIC_code='7231'DB:business_master_new
loadtime:2.5267150402069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phelps' limit 1
loadtime:2.526782989502 / seconds
Query Executed:select id FROM `wi` where city='Phelps' && SIC_code='7231'DB:business_master_new
loadtime:2.5280408859253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillips' limit 1
loadtime:2.5280978679657 / seconds
Query Executed:select id FROM `wi` where city='Phillips' && SIC_code='7231'DB:business_master_new
loadtime:2.530711889267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phlox' limit 1
loadtime:2.5307579040527 / seconds
Query Executed:select id FROM `wi` where city='Phlox' && SIC_code='7231'DB:business_master_new
loadtime:2.5311019420624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickerel' limit 1
loadtime:2.531152009964 / seconds
Query Executed:select id FROM `wi` where city='Pickerel' && SIC_code='7231'DB:business_master_new
loadtime:2.5318930149078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickett' limit 1
loadtime:2.5319459438324 / seconds
Query Executed:select id FROM `wi` where city='Pickett' && SIC_code='7231'DB:business_master_new
loadtime:2.5328550338745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pigeon Falls' limit 1
loadtime:2.5329029560089 / seconds
Query Executed:select id FROM `wi` where city='Pigeon Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.533490896225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine River' limit 1
loadtime:2.5335409641266 / seconds
Query Executed:select id FROM `wi` where city='Pine River' && SIC_code='7231'DB:business_master_new
loadtime:2.5342268943787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsville' limit 1
loadtime:2.534276008606 / seconds
Query Executed:select id FROM `wi` where city='Pittsville' && SIC_code='7231'DB:business_master_new
loadtime:2.5359530448914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plain' limit 1
loadtime:2.5359988212585 / seconds
Query Executed:select id FROM `wi` where city='Plain' && SIC_code='7231'DB:business_master_new
loadtime:2.5372550487518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:2.5373129844666 / seconds
Query Executed:select id FROM `wi` where city='Plainfield' && SIC_code='7231'DB:business_master_new
loadtime:2.5391819477081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platteville' limit 1
loadtime:2.5392420291901 / seconds
Query Executed:select id FROM `wi` where city='Platteville' && SIC_code='7231'DB:business_master_new
loadtime:2.5421469211578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Prairie' limit 1
loadtime:2.5422129631042 / seconds
Query Executed:select id FROM `wi` where city='Pleasant Prairie' && SIC_code='7231'DB:business_master_new
loadtime:2.5449149608612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:2.5449738502502 / seconds
Query Executed:select id FROM `wi` where city='Plover' && SIC_code='7231'DB:business_master_new
loadtime:2.5478799343109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plum City' limit 1
loadtime:2.547945022583 / seconds
Query Executed:select id FROM `wi` where city='Plum City' && SIC_code='7231'DB:business_master_new
loadtime:2.5490939617157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:2.5491449832916 / seconds
Query Executed:select id FROM `wi` where city='Plymouth' && SIC_code='7231'DB:business_master_new
loadtime:2.5521819591522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplar' limit 1
loadtime:2.5522458553314 / seconds
Query Executed:select id FROM `wi` where city='Poplar' && SIC_code='7231'DB:business_master_new
loadtime:2.5532038211823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Edwards' limit 1
loadtime:2.5532610416412 / seconds
Query Executed:select id FROM `wi` where city='Port Edwards' && SIC_code='7231'DB:business_master_new
loadtime:2.5542678833008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Washington' limit 1
loadtime:2.5543220043182 / seconds
Query Executed:select id FROM `wi` where city='Port Washington' && SIC_code='7231'DB:business_master_new
loadtime:2.5572378635406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Wing' limit 1
loadtime:2.5572929382324 / seconds
Query Executed:select id FROM `wi` where city='Port Wing' && SIC_code='7231'DB:business_master_new
loadtime:2.5580840110779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:2.5581269264221 / seconds
Query Executed:select id FROM `wi` where city='Portage' && SIC_code='7231'DB:business_master_new
loadtime:2.5612108707428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porterfield' limit 1
loadtime:2.5612788200378 / seconds
Query Executed:select id FROM `wi` where city='Porterfield' && SIC_code='7231'DB:business_master_new
loadtime:2.5621089935303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poskin' limit 1
loadtime:2.56214594841 / seconds
Query Executed:select id FROM `wi` where city='Poskin' && SIC_code='7231'DB:business_master_new
loadtime:2.5624279975891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potosi' limit 1
loadtime:2.5624680519104 / seconds
Query Executed:select id FROM `wi` where city='Potosi' && SIC_code='7231'DB:business_master_new
loadtime:2.5643818378448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potter' limit 1
loadtime:2.5644450187683 / seconds
Query Executed:select id FROM `wi` where city='Potter' && SIC_code='7231'DB:business_master_new
loadtime:2.5648548603058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pound' limit 1
loadtime:2.5649008750916 / seconds
Query Executed:select id FROM `wi` where city='Pound' && SIC_code='7231'DB:business_master_new
loadtime:2.5665190219879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers Lake' limit 1
loadtime:2.5665738582611 / seconds
Query Executed:select id FROM `wi` where city='Powers Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.5669779777527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poy Sippi' limit 1
loadtime:2.5670268535614 / seconds
Query Executed:select id FROM `wi` where city='Poy Sippi' && SIC_code='7231'DB:business_master_new
loadtime:2.5677518844604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poynette' limit 1
loadtime:2.5677978992462 / seconds
Query Executed:select id FROM `wi` where city='Poynette' && SIC_code='7231'DB:business_master_new
loadtime:2.5704278945923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Du Chien' limit 1
loadtime:2.5704729557037 / seconds
Query Executed:select id FROM `wi` where city='Prairie Du Chien' && SIC_code='7231'DB:business_master_new
loadtime:2.573371887207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Du Sac' limit 1
loadtime:2.5734279155731 / seconds
Query Executed:select id FROM `wi` where city='Prairie Du Sac' && SIC_code='7231'DB:business_master_new
loadtime:2.5760190486908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie Farm' limit 1
loadtime:2.5760550498962 / seconds
Query Executed:select id FROM `wi` where city='Prairie Farm' && SIC_code='7231'DB:business_master_new
loadtime:2.5771470069885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prentice' limit 1
loadtime:2.5771918296814 / seconds
Query Executed:select id FROM `wi` where city='Prentice' && SIC_code='7231'DB:business_master_new
loadtime:2.5785689353943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:2.5786108970642 / seconds
Query Executed:select id FROM `wi` where city='Prescott' && SIC_code='7231'DB:business_master_new
loadtime:2.5811040401459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presque Isle' limit 1
loadtime:2.5811538696289 / seconds
Query Executed:select id FROM `wi` where city='Presque Isle' && SIC_code='7231'DB:business_master_new
loadtime:2.5823040008545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:2.5823509693146 / seconds
Query Executed:select id FROM `wi` where city='Princeton' && SIC_code='7231'DB:business_master_new
loadtime:2.584892988205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:2.5849368572235 / seconds
Query Executed:select id FROM `wi` where city='Pulaski' && SIC_code='7231'DB:business_master_new
loadtime:2.5876989364624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulcifer' limit 1
loadtime:2.5877549648285 / seconds
Query Executed:select id FROM `wi` where city='Pulcifer' && SIC_code='7231'DB:business_master_new
loadtime:2.5880270004272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Racine' limit 1
loadtime:2.5880739688873 / seconds
Query Executed:select id FROM `wi` where city='Racine' && SIC_code='7231'DB:business_master_new
loadtime:2.5945320129395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radisson' limit 1
loadtime:2.5946688652039 / seconds
Query Executed:select id FROM `wi` where city='Radisson' && SIC_code='7231'DB:business_master_new
loadtime:2.595330953598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:2.5953919887543 / seconds
Query Executed:select id FROM `wi` where city='Randolph' && SIC_code='7231'DB:business_master_new
loadtime:2.5979290008545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Random Lake' limit 1
loadtime:2.597972869873 / seconds
Query Executed:select id FROM `wi` where city='Random Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.6001398563385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readfield' limit 1
loadtime:2.6001868247986 / seconds
Query Executed:select id FROM `wi` where city='Readfield' && SIC_code='7231'DB:business_master_new
loadtime:2.6006438732147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readstown' limit 1
loadtime:2.6006889343262 / seconds
Query Executed:select id FROM `wi` where city='Readstown' && SIC_code='7231'DB:business_master_new
loadtime:2.6014869213104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redgranite' limit 1
loadtime:2.6015229225159 / seconds
Query Executed:select id FROM `wi` where city='Redgranite' && SIC_code='7231'DB:business_master_new
loadtime:2.6028878688812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsburg' limit 1
loadtime:2.6029288768768 / seconds
Query Executed:select id FROM `wi` where city='Reedsburg' && SIC_code='7231'DB:business_master_new
loadtime:2.6058449745178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reedsville' limit 1
loadtime:2.605908870697 / seconds
Query Executed:select id FROM `wi` where city='Reedsville' && SIC_code='7231'DB:business_master_new
loadtime:2.608482837677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reeseville' limit 1
loadtime:2.6085469722748 / seconds
Query Executed:select id FROM `wi` where city='Reeseville' && SIC_code='7231'DB:business_master_new
loadtime:2.6097738742828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rewey' limit 1
loadtime:2.6098299026489 / seconds
Query Executed:select id FROM `wi` where city='Rewey' && SIC_code='7231'DB:business_master_new
loadtime:2.6103730201721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhinelander' limit 1
loadtime:2.6104099750519 / seconds
Query Executed:select id FROM `wi` where city='Rhinelander' && SIC_code='7231'DB:business_master_new
loadtime:2.6137459278107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rib Lake' limit 1
loadtime:2.613844871521 / seconds
Query Executed:select id FROM `wi` where city='Rib Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.6153018474579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rice Lake' limit 1
loadtime:2.6153619289398 / seconds
Query Executed:select id FROM `wi` where city='Rice Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.6186099052429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:2.6186809539795 / seconds
Query Executed:select id FROM `wi` where city='Richfield' && SIC_code='7231'DB:business_master_new
loadtime:2.6211869716644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland Center' limit 1
loadtime:2.6212470531464 / seconds
Query Executed:select id FROM `wi` where city='Richland Center' && SIC_code='7231'DB:business_master_new
loadtime:2.6241488456726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:2.6242158412933 / seconds
Query Executed:select id FROM `wi` where city='Ridgeland' && SIC_code='7231'DB:business_master_new
loadtime:2.6253700256348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:2.6254270076752 / seconds
Query Executed:select id FROM `wi` where city='Ridgeway' && SIC_code='7231'DB:business_master_new
loadtime:2.626384973526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringle' limit 1
loadtime:2.6264469623566 / seconds
Query Executed:select id FROM `wi` where city='Ringle' && SIC_code='7231'DB:business_master_new
loadtime:2.6273720264435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio' limit 1
loadtime:2.6274199485779 / seconds
Query Executed:select id FROM `wi` where city='Rio' && SIC_code='7231'DB:business_master_new
loadtime:2.6293640136719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripon' limit 1
loadtime:2.6294209957123 / seconds
Query Executed:select id FROM `wi` where city='Ripon' && SIC_code='7231'DB:business_master_new
loadtime:2.6322159767151 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Falls' limit 1
loadtime:2.63227891922 / seconds
Query Executed:select id FROM `wi` where city='River Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.6353938579559 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Hills' limit 1
loadtime:2.6354529857635 / seconds
Query Executed:select id FROM `wi` where city='River Hills' && SIC_code='7231'DB:business_master_new
loadtime:2.6357069015503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roberts' limit 1
loadtime:2.6357519626617 / seconds
Query Executed:select id FROM `wi` where city='Roberts' && SIC_code='7231'DB:business_master_new
loadtime:2.6375489234924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.6376049518585 / seconds
Query Executed:select id FROM `wi` where city='Rochester' && SIC_code='7231'DB:business_master_new
loadtime:2.6383728981018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:2.6384298801422 / seconds
Query Executed:select id FROM `wi` where city='Rock Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.6387569904327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Springs' limit 1
loadtime:2.6388030052185 / seconds
Query Executed:select id FROM `wi` where city='Rock Springs' && SIC_code='7231'DB:business_master_new
loadtime:2.6395628452301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.6396198272705 / seconds
Query Executed:select id FROM `wi` where city='Rockland' && SIC_code='7231'DB:business_master_new
loadtime:2.6402158737183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosendale' limit 1
loadtime:2.6402719020844 / seconds
Query Executed:select id FROM `wi` where city='Rosendale' && SIC_code='7231'DB:business_master_new
loadtime:2.6412768363953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:2.6413109302521 / seconds
Query Executed:select id FROM `wi` where city='Rosholt' && SIC_code='7231'DB:business_master_new
loadtime:2.6429760456085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rothschild' limit 1
loadtime:2.6430349349976 / seconds
Query Executed:select id FROM `wi` where city='Rothschild' && SIC_code='7231'DB:business_master_new
loadtime:2.6454429626465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalton' limit 1
loadtime:2.6456270217896 / seconds
Query Executed:select id FROM `wi` where city='Royalton' && SIC_code='7231'DB:business_master_new
loadtime:2.6461639404297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rubicon' limit 1
loadtime:2.6462638378143 / seconds
Query Executed:select id FROM `wi` where city='Rubicon' && SIC_code='7231'DB:business_master_new
loadtime:2.6481289863586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudolph' limit 1
loadtime:2.6482548713684 / seconds
Query Executed:select id FROM `wi` where city='Rudolph' && SIC_code='7231'DB:business_master_new
loadtime:2.6499888896942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Cloud' limit 1
loadtime:2.6501150131226 / seconds
Query Executed:select id FROM `wi` where city='Saint Cloud' && SIC_code='7231'DB:business_master_new
loadtime:2.6514730453491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Croix Falls' limit 1
loadtime:2.6515338420868 / seconds
Query Executed:select id FROM `wi` where city='Saint Croix Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.6549229621887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Germain' limit 1
loadtime:2.6549699306488 / seconds
Query Executed:select id FROM `wi` where city='Saint Germain' && SIC_code='7231'DB:business_master_new
loadtime:2.6579060554504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Nazianz' limit 1
loadtime:2.6579768657684 / seconds
Query Executed:select id FROM `wi` where city='Saint Nazianz' && SIC_code='7231'DB:business_master_new
loadtime:2.6587820053101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.6588430404663 / seconds
Query Executed:select id FROM `wi` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:2.6614689826965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Creek' limit 1
loadtime:2.6615169048309 / seconds
Query Executed:select id FROM `wi` where city='Sand Creek' && SIC_code='7231'DB:business_master_new
loadtime:2.6620299816132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarona' limit 1
loadtime:2.6620969772339 / seconds
Query Executed:select id FROM `wi` where city='Sarona' && SIC_code='7231'DB:business_master_new
loadtime:2.6632280349731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sauk City' limit 1
loadtime:2.6632719039917 / seconds
Query Executed:select id FROM `wi` where city='Sauk City' && SIC_code='7231'DB:business_master_new
loadtime:2.6659998893738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saukville' limit 1
loadtime:2.6660678386688 / seconds
Query Executed:select id FROM `wi` where city='Saukville' && SIC_code='7231'DB:business_master_new
loadtime:2.6691088676453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxeville' limit 1
loadtime:2.669154882431 / seconds
Query Executed:select id FROM `wi` where city='Saxeville' && SIC_code='7231'DB:business_master_new
loadtime:2.6695139408112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxon' limit 1
loadtime:2.6695659160614 / seconds
Query Executed:select id FROM `wi` where city='Saxon' && SIC_code='7231'DB:business_master_new
loadtime:2.6701118946075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sayner' limit 1
loadtime:2.6701610088348 / seconds
Query Executed:select id FROM `wi` where city='Sayner' && SIC_code='7231'DB:business_master_new
loadtime:2.6712918281555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scandinavia' limit 1
loadtime:2.6713569164276 / seconds
Query Executed:select id FROM `wi` where city='Scandinavia' && SIC_code='7231'DB:business_master_new
loadtime:2.672425031662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield' limit 1
loadtime:2.672474861145 / seconds
Query Executed:select id FROM `wi` where city='Schofield' && SIC_code='7231'DB:business_master_new
loadtime:2.6765999794006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:2.6766648292542 / seconds
Query Executed:select id FROM `wi` where city='Seneca' && SIC_code='7231'DB:business_master_new
loadtime:2.6772630214691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sextonville' limit 1
loadtime:2.6774258613586 / seconds
Query Executed:select id FROM `wi` where city='Sextonville' && SIC_code='7231'DB:business_master_new
loadtime:2.6778779029846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:2.677925825119 / seconds
Query Executed:select id FROM `wi` where city='Seymour' && SIC_code='7231'DB:business_master_new
loadtime:2.6818308830261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.6818928718567 / seconds
Query Executed:select id FROM `wi` where city='Sharon' && SIC_code='7231'DB:business_master_new
loadtime:2.6835000514984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawano' limit 1
loadtime:2.6835598945618 / seconds
Query Executed:select id FROM `wi` where city='Shawano' && SIC_code='7231'DB:business_master_new
loadtime:2.6874058246613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheboygan' limit 1
loadtime:2.6874668598175 / seconds
Query Executed:select id FROM `wi` where city='Sheboygan' && SIC_code='7231'DB:business_master_new
loadtime:2.6920728683472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheboygan Falls' limit 1
loadtime:2.6921768188477 / seconds
Query Executed:select id FROM `wi` where city='Sheboygan Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.6950678825378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:2.6951339244843 / seconds
Query Executed:select id FROM `wi` where city='Sheldon' && SIC_code='7231'DB:business_master_new
loadtime:2.6963019371033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Lake' limit 1
loadtime:2.6963729858398 / seconds
Query Executed:select id FROM `wi` where city='Shell Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.6991138458252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:2.6991708278656 / seconds
Query Executed:select id FROM `wi` where city='Sherwood' && SIC_code='7231'DB:business_master_new
loadtime:2.7006058692932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiocton' limit 1
loadtime:2.7006559371948 / seconds
Query Executed:select id FROM `wi` where city='Shiocton' && SIC_code='7231'DB:business_master_new
loadtime:2.7021918296814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shorewood' limit 1
loadtime:2.7022609710693 / seconds
Query Executed:select id FROM `wi` where city='Shorewood' && SIC_code='7231'DB:business_master_new
loadtime:2.7026259899139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shullsburg' limit 1
loadtime:2.7026669979095 / seconds
Query Executed:select id FROM `wi` where city='Shullsburg' && SIC_code='7231'DB:business_master_new
loadtime:2.7046639919281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:2.7047200202942 / seconds
Query Executed:select id FROM `wi` where city='Silver Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.7059729099274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinsinawa' limit 1
loadtime:2.7060248851776 / seconds
Query Executed:select id FROM `wi` where city='Sinsinawa' && SIC_code='7231'DB:business_master_new
loadtime:2.7063620090485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siren' limit 1
loadtime:2.7064049243927 / seconds
Query Executed:select id FROM `wi` where city='Siren' && SIC_code='7231'DB:business_master_new
loadtime:2.7090539932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sister Bay' limit 1
loadtime:2.7091000080109 / seconds
Query Executed:select id FROM `wi` where city='Sister Bay' && SIC_code='7231'DB:business_master_new
loadtime:2.7117738723755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slinger' limit 1
loadtime:2.7118339538574 / seconds
Query Executed:select id FROM `wi` where city='Slinger' && SIC_code='7231'DB:business_master_new
loadtime:2.714663028717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sobieski' limit 1
loadtime:2.7147119045258 / seconds
Query Executed:select id FROM `wi` where city='Sobieski' && SIC_code='7231'DB:business_master_new
loadtime:2.7159729003906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldiers Grove' limit 1
loadtime:2.7160308361053 / seconds
Query Executed:select id FROM `wi` where city='Soldiers Grove' && SIC_code='7231'DB:business_master_new
loadtime:2.7175228595734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon Springs' limit 1
loadtime:2.717581987381 / seconds
Query Executed:select id FROM `wi` where city='Solon Springs' && SIC_code='7231'DB:business_master_new
loadtime:2.7200138568878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:2.7200629711151 / seconds
Query Executed:select id FROM `wi` where city='Somers' && SIC_code='7231'DB:business_master_new
loadtime:2.7207479476929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.7208049297333 / seconds
Query Executed:select id FROM `wi` where city='Somerset' && SIC_code='7231'DB:business_master_new
loadtime:2.72345495224 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Byron' limit 1
loadtime:2.7235159873962 / seconds
Query Executed:select id FROM `wi` where city='South Byron' && SIC_code='7231'DB:business_master_new
loadtime:2.7238328456879 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Milwaukee' limit 1
loadtime:2.7238750457764 / seconds
Query Executed:select id FROM `wi` where city='South Milwaukee' && SIC_code='7231'DB:business_master_new
loadtime:2.7267639636993 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Range' limit 1
loadtime:2.7268309593201 / seconds
Query Executed:select id FROM `wi` where city='South Range' && SIC_code='7231'DB:business_master_new
loadtime:2.7281529903412 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wayne' limit 1
loadtime:2.7281899452209 / seconds
Query Executed:select id FROM `wi` where city='South Wayne' && SIC_code='7231'DB:business_master_new
loadtime:2.7294838428497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:2.7295408248901 / seconds
Query Executed:select id FROM `wi` where city='Sparta' && SIC_code='7231'DB:business_master_new
loadtime:2.7325708866119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.7326378822327 / seconds
Query Executed:select id FROM `wi` where city='Spencer' && SIC_code='7231'DB:business_master_new
loadtime:2.7347128391266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spooner' limit 1
loadtime:2.7347738742828 / seconds
Query Executed:select id FROM `wi` where city='Spooner' && SIC_code='7231'DB:business_master_new
loadtime:2.737685918808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Green' limit 1
loadtime:2.7377369403839 / seconds
Query Executed:select id FROM `wi` where city='Spring Green' && SIC_code='7231'DB:business_master_new
loadtime:2.7403779029846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Valley' limit 1
loadtime:2.7404379844666 / seconds
Query Executed:select id FROM `wi` where city='Spring Valley' && SIC_code='7231'DB:business_master_new
loadtime:2.7426970005035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:2.7427558898926 / seconds
Query Executed:select id FROM `wi` where city='Springbrook' && SIC_code='7231'DB:business_master_new
loadtime:2.7436058521271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.7436490058899 / seconds
Query Executed:select id FROM `wi` where city='Springfield' && SIC_code='7231'DB:business_master_new
loadtime:2.7440228462219 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Cloud' limit 1
loadtime:2.7440798282623 / seconds
Query Executed:select id FROM `wi` where city='St Cloud' && SIC_code='7231'DB:business_master_new
loadtime:2.7443640232086 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Croix Falls' limit 1
loadtime:2.7443909645081 / seconds
Query Executed:select id FROM `wi` where city='St Croix Falls' && SIC_code='7231'DB:business_master_new
loadtime:2.744647026062 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:2.7446818351746 / seconds
Query Executed:select id FROM `wi` where city='St Francis' && SIC_code='7231'DB:business_master_new
loadtime:2.7449400424957 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Germain' limit 1
loadtime:2.7449760437012 / seconds
Query Executed:select id FROM `wi` where city='St Germain' && SIC_code='7231'DB:business_master_new
loadtime:2.7452230453491 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Nazianz' limit 1
loadtime:2.7452518939972 / seconds
Query Executed:select id FROM `wi` where city='St Nazianz' && SIC_code='7231'DB:business_master_new
loadtime:2.7455399036407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:2.7455809116364 / seconds
Query Executed:select id FROM `wi` where city='Stanley' && SIC_code='7231'DB:business_master_new
loadtime:2.7481319904327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Lake' limit 1
loadtime:2.748193025589 / seconds
Query Executed:select id FROM `wi` where city='Star Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.7485408782959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star Prairie' limit 1
loadtime:2.7485699653625 / seconds
Query Executed:select id FROM `wi` where city='Star Prairie' && SIC_code='7231'DB:business_master_new
loadtime:2.7496449947357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stetsonville' limit 1
loadtime:2.749706029892 / seconds
Query Executed:select id FROM `wi` where city='Stetsonville' && SIC_code='7231'DB:business_master_new
loadtime:2.7508308887482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steuben' limit 1
loadtime:2.7508809566498 / seconds
Query Executed:select id FROM `wi` where city='Steuben' && SIC_code='7231'DB:business_master_new
loadtime:2.7513630390167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevens Point' limit 1
loadtime:2.7514069080353 / seconds
Query Executed:select id FROM `wi` where city='Stevens Point' && SIC_code='7231'DB:business_master_new
loadtime:2.7554178237915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stitzer' limit 1
loadtime:2.7555069923401 / seconds
Query Executed:select id FROM `wi` where city='Stitzer' && SIC_code='7231'DB:business_master_new
loadtime:2.7561209201813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.756166934967 / seconds
Query Executed:select id FROM `wi` where city='Stockbridge' && SIC_code='7231'DB:business_master_new
loadtime:2.756814956665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:2.7568588256836 / seconds
Query Executed:select id FROM `wi` where city='Stockholm' && SIC_code='7231'DB:business_master_new
loadtime:2.7575998306274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:2.7576420307159 / seconds
Query Executed:select id FROM `wi` where city='Stoddard' && SIC_code='7231'DB:business_master_new
loadtime:2.7591278553009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Lake' limit 1
loadtime:2.759171962738 / seconds
Query Executed:select id FROM `wi` where city='Stone Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.7607028484344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:2.7607588768005 / seconds
Query Executed:select id FROM `wi` where city='Stoughton' && SIC_code='7231'DB:business_master_new
loadtime:2.7638819217682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:2.7639558315277 / seconds
Query Executed:select id FROM `wi` where city='Stratford' && SIC_code='7231'DB:business_master_new
loadtime:2.766608953476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strum' limit 1
loadtime:2.7666618824005 / seconds
Query Executed:select id FROM `wi` where city='Strum' && SIC_code='7231'DB:business_master_new
loadtime:2.7681448459625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgeon Bay' limit 1
loadtime:2.7682049274445 / seconds
Query Executed:select id FROM `wi` where city='Sturgeon Bay' && SIC_code='7231'DB:business_master_new
loadtime:2.7714958190918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturtevant' limit 1
loadtime:2.7715549468994 / seconds
Query Executed:select id FROM `wi` where city='Sturtevant' && SIC_code='7231'DB:business_master_new
loadtime:2.7742009162903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suamico' limit 1
loadtime:2.7742600440979 / seconds
Query Executed:select id FROM `wi` where city='Suamico' && SIC_code='7231'DB:business_master_new
loadtime:2.7762999534607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:2.7763700485229 / seconds
Query Executed:select id FROM `wi` where city='Sullivan' && SIC_code='7231'DB:business_master_new
loadtime:2.778030872345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit Lake' limit 1
loadtime:2.7780878543854 / seconds
Query Executed:select id FROM `wi` where city='Summit Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.7785680294037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Prairie' limit 1
loadtime:2.7785968780518 / seconds
Query Executed:select id FROM `wi` where city='Sun Prairie' && SIC_code='7231'DB:business_master_new
loadtime:2.7820818424225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:2.7821588516235 / seconds
Query Executed:select id FROM `wi` where city='Superior' && SIC_code='7231'DB:business_master_new
loadtime:2.7857129573822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suring' limit 1
loadtime:2.7857949733734 / seconds
Query Executed:select id FROM `wi` where city='Suring' && SIC_code='7231'DB:business_master_new
loadtime:2.7877609729767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:2.7878170013428 / seconds
Query Executed:select id FROM `wi` where city='Sussex' && SIC_code='7231'DB:business_master_new
loadtime:2.7905769348145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:2.790638923645 / seconds
Query Executed:select id FROM `wi` where city='Taylor' && SIC_code='7231'DB:business_master_new
loadtime:2.7915399074554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Theresa' limit 1
loadtime:2.7915990352631 / seconds
Query Executed:select id FROM `wi` where city='Theresa' && SIC_code='7231'DB:business_master_new
loadtime:2.7926778793335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thiensville' limit 1
loadtime:2.7927229404449 / seconds
Query Executed:select id FROM `wi` where city='Thiensville' && SIC_code='7231'DB:business_master_new
loadtime:2.7936398983002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorp' limit 1
loadtime:2.7936978340149 / seconds
Query Executed:select id FROM `wi` where city='Thorp' && SIC_code='7231'DB:business_master_new
loadtime:2.7962548732758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Lakes' limit 1
loadtime:2.796315908432 / seconds
Query Executed:select id FROM `wi` where city='Three Lakes' && SIC_code='7231'DB:business_master_new
loadtime:2.7987668514252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tigerton' limit 1
loadtime:2.7988119125366 / seconds
Query Executed:select id FROM `wi` where city='Tigerton' && SIC_code='7231'DB:business_master_new
loadtime:2.8002798557281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilleda' limit 1
loadtime:2.8003580570221 / seconds
Query Executed:select id FROM `wi` where city='Tilleda' && SIC_code='7231'DB:business_master_new
loadtime:2.8008298873901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipler' limit 1
loadtime:2.8008668422699 / seconds
Query Executed:select id FROM `wi` where city='Tipler' && SIC_code='7231'DB:business_master_new
loadtime:2.8011238574982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tisch Mills' limit 1
loadtime:2.8011648654938 / seconds
Query Executed:select id FROM `wi` where city='Tisch Mills' && SIC_code='7231'DB:business_master_new
loadtime:2.8015010356903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tomah' limit 1
loadtime:2.8015308380127 / seconds
Query Executed:select id FROM `wi` where city='Tomah' && SIC_code='7231'DB:business_master_new
loadtime:2.8045709133148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tomahawk' limit 1
loadtime:2.8046460151672 / seconds
Query Executed:select id FROM `wi` where city='Tomahawk' && SIC_code='7231'DB:business_master_new
loadtime:2.8074908256531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tony' limit 1
loadtime:2.8075489997864 / seconds
Query Executed:select id FROM `wi` where city='Tony' && SIC_code='7231'DB:business_master_new
loadtime:2.8081860542297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.8082418441772 / seconds
Query Executed:select id FROM `wi` where city='Townsend' && SIC_code='7231'DB:business_master_new
loadtime:2.8091719150543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trego' limit 1
loadtime:2.8092329502106 / seconds
Query Executed:select id FROM `wi` where city='Trego' && SIC_code='7231'DB:business_master_new
loadtime:2.8106868267059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trempealeau' limit 1
loadtime:2.8107469081879 / seconds
Query Executed:select id FROM `wi` where city='Trempealeau' && SIC_code='7231'DB:business_master_new
loadtime:2.8124058246613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trevor' limit 1
loadtime:2.8124508857727 / seconds
Query Executed:select id FROM `wi` where city='Trevor' && SIC_code='7231'DB:business_master_new
loadtime:2.8140909671783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:2.8141498565674 / seconds
Query Executed:select id FROM `wi` where city='Tripoli' && SIC_code='7231'DB:business_master_new
loadtime:2.8146319389343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunnel City' limit 1
loadtime:2.8146760463715 / seconds
Query Executed:select id FROM `wi` where city='Tunnel City' && SIC_code='7231'DB:business_master_new
loadtime:2.8150260448456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turtle Lake' limit 1
loadtime:2.8150749206543 / seconds
Query Executed:select id FROM `wi` where city='Turtle Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.8171980381012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lakes' limit 1
loadtime:2.8172619342804 / seconds
Query Executed:select id FROM `wi` where city='Twin Lakes' && SIC_code='7231'DB:business_master_new
loadtime:2.8199388980865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Two Rivers' limit 1
loadtime:2.8200030326843 / seconds
Query Executed:select id FROM `wi` where city='Two Rivers' && SIC_code='7231'DB:business_master_new
loadtime:2.8229420185089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:2.8230009078979 / seconds
Query Executed:select id FROM `wi` where city='Union Center' && SIC_code='7231'DB:business_master_new
loadtime:2.8235409259796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:2.8235869407654 / seconds
Query Executed:select id FROM `wi` where city='Union Grove' && SIC_code='7231'DB:business_master_new
loadtime:2.8263289928436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unity' limit 1
loadtime:2.8264088630676 / seconds
Query Executed:select id FROM `wi` where city='Unity' && SIC_code='7231'DB:business_master_new
loadtime:2.8273279666901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upson' limit 1
loadtime:2.8273768424988 / seconds
Query Executed:select id FROM `wi` where city='Upson' && SIC_code='7231'DB:business_master_new
loadtime:2.8277578353882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valders' limit 1
loadtime:2.8278079032898 / seconds
Query Executed:select id FROM `wi` where city='Valders' && SIC_code='7231'DB:business_master_new
loadtime:2.8294508457184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Dyne' limit 1
loadtime:2.8295109272003 / seconds
Query Executed:select id FROM `wi` where city='Van Dyne' && SIC_code='7231'DB:business_master_new
loadtime:2.8307058811188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:2.8307609558105 / seconds
Query Executed:select id FROM `wi` where city='Verona' && SIC_code='7231'DB:business_master_new
loadtime:2.8338458538055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vesper' limit 1
loadtime:2.8339009284973 / seconds
Query Executed:select id FROM `wi` where city='Vesper' && SIC_code='7231'DB:business_master_new
loadtime:2.8350470066071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:2.8351080417633 / seconds
Query Executed:select id FROM `wi` where city='Viola' && SIC_code='7231'DB:business_master_new
loadtime:2.8364999294281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viroqua' limit 1
loadtime:2.8365578651428 / seconds
Query Executed:select id FROM `wi` where city='Viroqua' && SIC_code='7231'DB:business_master_new
loadtime:2.8393669128418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wabeno' limit 1
loadtime:2.8394160270691 / seconds
Query Executed:select id FROM `wi` where city='Wabeno' && SIC_code='7231'DB:business_master_new
loadtime:2.8406820297241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldo' limit 1
loadtime:2.8407418727875 / seconds
Query Executed:select id FROM `wi` where city='Waldo' && SIC_code='7231'DB:business_master_new
loadtime:2.8416440486908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.8416938781738 / seconds
Query Executed:select id FROM `wi` where city='Wales' && SIC_code='7231'DB:business_master_new
loadtime:2.8437600135803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walworth' limit 1
loadtime:2.8438260555267 / seconds
Query Executed:select id FROM `wi` where city='Walworth' && SIC_code='7231'DB:business_master_new
loadtime:2.84641289711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrens' limit 1
loadtime:2.8464648723602 / seconds
Query Executed:select id FROM `wi` where city='Warrens' && SIC_code='7231'DB:business_master_new
loadtime:2.8483309745789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wascott' limit 1
loadtime:2.8484058380127 / seconds
Query Executed:select id FROM `wi` where city='Wascott' && SIC_code='7231'DB:business_master_new
loadtime:2.8487508296967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:2.8487989902496 / seconds
Query Executed:select id FROM `wi` where city='Washburn' && SIC_code='7231'DB:business_master_new
loadtime:2.8512940406799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Island' limit 1
loadtime:2.8513588905334 / seconds
Query Executed:select id FROM `wi` where city='Washington Island' && SIC_code='7231'DB:business_master_new
loadtime:2.8527529239655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Isle' limit 1
loadtime:2.8528108596802 / seconds
Query Executed:select id FROM `wi` where city='Washington Isle' && SIC_code='7231'DB:business_master_new
loadtime:2.8530869483948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:2.8531248569489 / seconds
Query Executed:select id FROM `wi` where city='Waterford' && SIC_code='7231'DB:business_master_new
loadtime:2.8561069965363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:2.8561608791351 / seconds
Query Executed:select id FROM `wi` where city='Waterloo' && SIC_code='7231'DB:business_master_new
loadtime:2.8591659069061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.8592269420624 / seconds
Query Executed:select id FROM `wi` where city='Watertown' && SIC_code='7231'DB:business_master_new
loadtime:2.8626580238342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubeka' limit 1
loadtime:2.8627259731293 / seconds
Query Executed:select id FROM `wi` where city='Waubeka' && SIC_code='7231'DB:business_master_new
loadtime:2.863009929657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukau' limit 1
loadtime:2.8630449771881 / seconds
Query Executed:select id FROM `wi` where city='Waukau' && SIC_code='7231'DB:business_master_new
loadtime:2.8634350299835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukesha' limit 1
loadtime:2.8634748458862 / seconds
Query Executed:select id FROM `wi` where city='Waukesha' && SIC_code='7231'DB:business_master_new
loadtime:2.8691530227661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waumandee' limit 1
loadtime:2.8692598342896 / seconds
Query Executed:select id FROM `wi` where city='Waumandee' && SIC_code='7231'DB:business_master_new
loadtime:2.869551897049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waunakee' limit 1
loadtime:2.8695998191833 / seconds
Query Executed:select id FROM `wi` where city='Waunakee' && SIC_code='7231'DB:business_master_new
loadtime:2.8724999427795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waupaca' limit 1
loadtime:2.8725500106812 / seconds
Query Executed:select id FROM `wi` where city='Waupaca' && SIC_code='7231'DB:business_master_new
loadtime:2.8755559921265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waupun' limit 1
loadtime:2.8756279945374 / seconds
Query Executed:select id FROM `wi` where city='Waupun' && SIC_code='7231'DB:business_master_new
loadtime:2.8783819675446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wausau' limit 1
loadtime:2.8784458637238 / seconds
Query Executed:select id FROM `wi` where city='Wausau' && SIC_code='7231'DB:business_master_new
loadtime:2.8832218647003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wausaukee' limit 1
loadtime:2.8833060264587 / seconds
Query Executed:select id FROM `wi` where city='Wausaukee' && SIC_code='7231'DB:business_master_new
loadtime:2.885046005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wautoma' limit 1
loadtime:2.8851089477539 / seconds
Query Executed:select id FROM `wi` where city='Wautoma' && SIC_code='7231'DB:business_master_new
loadtime:2.8878788948059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauwatosa' limit 1
loadtime:2.887934923172 / seconds
Query Executed:select id FROM `wi` where city='Wauwatosa' && SIC_code='7231'DB:business_master_new
loadtime:2.8884069919586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauzeka' limit 1
loadtime:2.8884580135345 / seconds
Query Executed:select id FROM `wi` where city='Wauzeka' && SIC_code='7231'DB:business_master_new
loadtime:2.8894469738007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb Lake' limit 1
loadtime:2.8894908428192 / seconds
Query Executed:select id FROM `wi` where city='Webb Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.8898088932037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.8898649215698 / seconds
Query Executed:select id FROM `wi` where city='Webster' && SIC_code='7231'DB:business_master_new
loadtime:2.8923888206482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:2.8924489021301 / seconds
Query Executed:select id FROM `wi` where city='Wentworth' && SIC_code='7231'DB:business_master_new
loadtime:2.8927199840546 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Allis' limit 1
loadtime:2.8927528858185 / seconds
Query Executed:select id FROM `wi` where city='West Allis' && SIC_code='7231'DB:business_master_new
loadtime:2.8931879997253 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:2.8932340145111 / seconds
Query Executed:select id FROM `wi` where city='West Bend' && SIC_code='7231'DB:business_master_new
loadtime:2.8974058628082 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Salem' limit 1
loadtime:2.8974978923798 / seconds
Query Executed:select id FROM `wi` where city='West Salem' && SIC_code='7231'DB:business_master_new
loadtime:2.9001278877258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westboro' limit 1
loadtime:2.9001898765564 / seconds
Query Executed:select id FROM `wi` where city='Westboro' && SIC_code='7231'DB:business_master_new
loadtime:2.900869846344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westby' limit 1
loadtime:2.9009289741516 / seconds
Query Executed:select id FROM `wi` where city='Westby' && SIC_code='7231'DB:business_master_new
loadtime:2.9035580158234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.9036149978638 / seconds
Query Executed:select id FROM `wi` where city='Westfield' && SIC_code='7231'DB:business_master_new
loadtime:2.9059958457947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.9060559272766 / seconds
Query Executed:select id FROM `wi` where city='Weston' && SIC_code='7231'DB:business_master_new
loadtime:2.906357049942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.9063968658447 / seconds
Query Executed:select id FROM `wi` where city='Westport' && SIC_code='7231'DB:business_master_new
loadtime:2.9066319465637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyauwega' limit 1
loadtime:2.9066648483276 / seconds
Query Executed:select id FROM `wi` where city='Weyauwega' && SIC_code='7231'DB:business_master_new
loadtime:2.9092259407043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weyerhaeuser' limit 1
loadtime:2.9092710018158 / seconds
Query Executed:select id FROM `wi` where city='Weyerhaeuser' && SIC_code='7231'DB:business_master_new
loadtime:2.9102728366852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:2.9103469848633 / seconds
Query Executed:select id FROM `wi` where city='Wheeler' && SIC_code='7231'DB:business_master_new
loadtime:2.9110758304596 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:2.9111349582672 / seconds
Query Executed:select id FROM `wi` where city='White Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.912232875824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehall' limit 1
loadtime:2.9122869968414 / seconds
Query Executed:select id FROM `wi` where city='Whitehall' && SIC_code='7231'DB:business_master_new
loadtime:2.9148678779602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitelaw' limit 1
loadtime:2.914913892746 / seconds
Query Executed:select id FROM `wi` where city='Whitelaw' && SIC_code='7231'DB:business_master_new
loadtime:2.9161748886108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewater' limit 1
loadtime:2.9162349700928 / seconds
Query Executed:select id FROM `wi` where city='Whitewater' && SIC_code='7231'DB:business_master_new
loadtime:2.9192118644714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wild Rose' limit 1
loadtime:2.9192759990692 / seconds
Query Executed:select id FROM `wi` where city='Wild Rose' && SIC_code='7231'DB:business_master_new
loadtime:2.9214119911194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:2.9214708805084 / seconds
Query Executed:select id FROM `wi` where city='Willard' && SIC_code='7231'DB:business_master_new
loadtime:2.9223079681396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams Bay' limit 1
loadtime:2.9223730564117 / seconds
Query Executed:select id FROM `wi` where city='Williams Bay' && SIC_code='7231'DB:business_master_new
loadtime:2.9246549606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:2.924703836441 / seconds
Query Executed:select id FROM `wi` where city='Wilmot' && SIC_code='7231'DB:business_master_new
loadtime:2.9255468845367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:2.9255950450897 / seconds
Query Executed:select id FROM `wi` where city='Wilson' && SIC_code='7231'DB:business_master_new
loadtime:2.9263789653778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:2.9264259338379 / seconds
Query Executed:select id FROM `wi` where city='Wilton' && SIC_code='7231'DB:business_master_new
loadtime:2.9275469779968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.9276049137115 / seconds
Query Executed:select id FROM `wi` where city='Winchester' && SIC_code='7231'DB:business_master_new
loadtime:2.927973985672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wind Lake' limit 1
loadtime:2.9280269145966 / seconds
Query Executed:select id FROM `wi` where city='Wind Lake' && SIC_code='7231'DB:business_master_new
loadtime:2.9283618927002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.9283909797668 / seconds
Query Executed:select id FROM `wi` where city='Windsor' && SIC_code='7231'DB:business_master_new
loadtime:2.9297969341278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnebago' limit 1
loadtime:2.9298529624939 / seconds
Query Executed:select id FROM `wi` where city='Winnebago' && SIC_code='7231'DB:business_master_new
loadtime:2.9303948879242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winneconne' limit 1
loadtime:2.930449962616 / seconds
Query Executed:select id FROM `wi` where city='Winneconne' && SIC_code='7231'DB:business_master_new
loadtime:2.9335169792175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winter' limit 1
loadtime:2.9335598945618 / seconds
Query Executed:select id FROM `wi` where city='Winter' && SIC_code='7231'DB:business_master_new
loadtime:2.9353568553925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wisconsin Dells' limit 1
loadtime:2.9354088306427 / seconds
Query Executed:select id FROM `wi` where city='Wisconsin Dells' && SIC_code='7231'DB:business_master_new
loadtime:2.9385569095612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wisconsin Rapids' limit 1
loadtime:2.9385969638824 / seconds
Query Executed:select id FROM `wi` where city='Wisconsin Rapids' && SIC_code='7231'DB:business_master_new
loadtime:2.9425768852234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Withee' limit 1
loadtime:2.942656993866 / seconds
Query Executed:select id FROM `wi` where city='Withee' && SIC_code='7231'DB:business_master_new
loadtime:2.9451088905334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittenberg' limit 1
loadtime:2.9451489448547 / seconds
Query Executed:select id FROM `wi` where city='Wittenberg' && SIC_code='7231'DB:business_master_new
loadtime:2.9489839076996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonewoc' limit 1
loadtime:2.949028968811 / seconds
Query Executed:select id FROM `wi` where city='Wonewoc' && SIC_code='7231'DB:business_master_new
loadtime:2.9526519775391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodford' limit 1
loadtime:2.9526908397675 / seconds
Query Executed:select id FROM `wi` where city='Woodford' && SIC_code='7231'DB:business_master_new
loadtime:2.9534289836884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:2.9534678459167 / seconds
Query Executed:select id FROM `wi` where city='Woodland' && SIC_code='7231'DB:business_master_new
loadtime:2.9541268348694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodman' limit 1
loadtime:2.9541628360748 / seconds
Query Executed:select id FROM `wi` where city='Woodman' && SIC_code='7231'DB:business_master_new
loadtime:2.954910993576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:2.9549469947815 / seconds
Query Executed:select id FROM `wi` where city='Woodruff' && SIC_code='7231'DB:business_master_new
loadtime:2.9598178863525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.9599258899689 / seconds
Query Executed:select id FROM `wi` where city='Woodville' && SIC_code='7231'DB:business_master_new
loadtime:2.9632170200348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodworth' limit 1
loadtime:2.9632768630981 / seconds
Query Executed:select id FROM `wi` where city='Woodworth' && SIC_code='7231'DB:business_master_new
loadtime:2.9640259742737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightstown' limit 1
loadtime:2.9641079902649 / seconds
Query Executed:select id FROM `wi` where city='Wrightstown' && SIC_code='7231'DB:business_master_new
loadtime:2.9684858322144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyeville' limit 1
loadtime:2.968535900116 / seconds
Query Executed:select id FROM `wi` where city='Wyeville' && SIC_code='7231'DB:business_master_new
loadtime:2.9687688350677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyocena' limit 1
loadtime:2.9688048362732 / seconds
Query Executed:select id FROM `wi` where city='Wyocena' && SIC_code='7231'DB:business_master_new
loadtime:2.972156047821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuba' limit 1
loadtime:2.9721930027008 / seconds
Query Executed:select id FROM `wi` where city='Yuba' && SIC_code='7231'DB:business_master_new
loadtime:2.9725518226624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zachow' limit 1
loadtime:2.9725909233093 / seconds
Query Executed:select id FROM `wi` where city='Zachow' && SIC_code='7231'DB:business_master_new
loadtime:2.9728720188141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zenda' limit 1
loadtime:2.9729068279266 / seconds
Query Executed:select id FROM `wi` where city='Zenda' && SIC_code='7231'DB:business_master_new
loadtime:2.9736030101776 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.9738080501556 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.9740970134735 / seconds
Operation template executed (chunk cache operation)
loadtime:2.9741768836975 / seconds
template override:Default
loadtime:2.9741959571838 / 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:2.9752039909363 / seconds
Template Constructed, Array Rows:49
loadtime:2.9755189418793 / seconds
TOTAL EXECUTION TIME: 2.97524
loadtime:2.975870847702 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => beauty-shops [stateURLid] => wisconsin )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:2.9758758544922
TOTAL KEY ARRAYS: 69