Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.6055526733398E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00056004524230957 / seconds
host not found setting manual db connection
loadtime:0.00092005729675293 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001183032989502 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0013041496276855 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.001352071762085 / seconds
zipcode:
loadtime:0.0013689994812012 / seconds
Query Executed:select * from search_referrer where page_hash='c24986acb7887ee252445b0b52fb8949' limit 10 DB:ezrox_toadli
loadtime:0.0015480518341064 / seconds
Operation header executed (non global)
loadtime:0.0015649795532227 / seconds
Operation leaderboard executed (non global)
loadtime:0.0016019344329834 / seconds
Operation square executed (non global)
loadtime:0.0016160011291504 / seconds
Operation square_bottom executed (non global)
loadtime:0.001629114151001 / seconds
Operation smallsquare executed (non global)
loadtime:0.0016400814056396 / seconds
Operation headeradright executed (non global)
loadtime:0.0016529560089111 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016639232635498 / seconds
Operation topstories executed (non global)
loadtime:0.0016739368438721 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016860961914062 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016970634460449 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00199294090271 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.002140998840332 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0021810531616211 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0022470951080322 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0022821426391602 / seconds
Template key: archive_menu pushed
loadtime:0.0022871494293213 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0022931098937988 / seconds
Template key: get_gravatar pushed
loadtime:0.002295970916748 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0023000240325928 / seconds
*10)-10)+1 | start:0
loadtime:0.0023219585418701 / seconds
DB connected to localhost business_master_new
loadtime:0.0025560855865479 / seconds
Query Executed:select * from categories where cat_URLid='retail-bakeries'DB:business_master_new
loadtime:0.0036230087280273 / seconds
Query stored in cache : _QUERY_www.toadli.com4c1dab8efba749ffdae7a52224d8c45c
loadtime:0.0037040710449219 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.0038211345672607 / seconds
Query Executed:select * from `mi_catmap` where sic='5461' order by city ascDB:business_master_new
loadtime:0.011929988861084 / seconds
Query stored in cache : _QUERY_www.toadli.com8ecaef22153d1099dc423415e2541d32
loadtime:0.015141010284424 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.015181064605713 / seconds
Query Executed:select sum(totalcount) as totalsum from `mi_catmap` where sic='5461'DB:business_master_new
loadtime:0.020487070083618 / seconds
Query stored in cache : _QUERY_www.toadli.com3c3b8843fa86b9b0ce2442552fe09ee5
loadtime:0.020524024963379 / seconds
966 / 11
loadtime:0.02055811882019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acme' limit 1
loadtime:0.020596981048584 / seconds
Query Executed:select id FROM `mi` where city='Acme' && SIC_code='5461'DB:business_master_new
loadtime:0.056713104248047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ada' limit 1
loadtime:0.05682897567749 / seconds
Query Executed:select id FROM `mi` where city='Ada' && SIC_code='5461'DB:business_master_new
loadtime:0.057976007461548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison' limit 1
loadtime:0.058005094528198 / seconds
Query Executed:select id FROM `mi` where city='Addison' && SIC_code='5461'DB:business_master_new
loadtime:0.058548927307129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison Twp' limit 1
loadtime:0.058584928512573 / seconds
Query Executed:select id FROM `mi` where city='Addison Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.061679124832153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adrian' limit 1
loadtime:0.061726093292236 / seconds
Query Executed:select id FROM `mi` where city='Adrian' && SIC_code='5461'DB:business_master_new
loadtime:0.063888072967529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.063936948776245 / seconds
Query Executed:select id FROM `mi` where city='Afton' && SIC_code='5461'DB:business_master_new
loadtime:0.072828054428101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahmeek' limit 1
loadtime:0.072875022888184 / seconds
Query Executed:select id FROM `mi` where city='Ahmeek' && SIC_code='5461'DB:business_master_new
loadtime:0.077783107757568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.077820062637329 / seconds
Query Executed:select id FROM `mi` where city='Akron' && SIC_code='5461'DB:business_master_new
loadtime:0.10572695732117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alanson' limit 1
loadtime:0.10584402084351 / seconds
Query Executed:select id FROM `mi` where city='Alanson' && SIC_code='5461'DB:business_master_new
loadtime:0.1070020198822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alba' limit 1
loadtime:0.10706496238708 / seconds
Query Executed:select id FROM `mi` where city='Alba' && SIC_code='5461'DB:business_master_new
loadtime:0.11371803283691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.11376214027405 / seconds
Query Executed:select id FROM `mi` where city='Albion' && SIC_code='5461'DB:business_master_new
loadtime:0.11451601982117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.11456298828125 / seconds
Query Executed:select id FROM `mi` where city='Alden' && SIC_code='5461'DB:business_master_new
loadtime:0.13984894752502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alger' limit 1
loadtime:0.13996505737305 / seconds
Query Executed:select id FROM `mi` where city='Alger' && SIC_code='5461'DB:business_master_new
loadtime:0.16357898712158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algonac' limit 1
loadtime:0.16364312171936 / seconds
Query Executed:select id FROM `mi` where city='Algonac' && SIC_code='5461'DB:business_master_new
loadtime:0.16447806358337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allegan' limit 1
loadtime:0.16453003883362 / seconds
Query Executed:select id FROM `mi` where city='Allegan' && SIC_code='5461'DB:business_master_new
loadtime:0.16533303260803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.16535997390747 / seconds
Query Executed:select id FROM `mi` where city='Allen' && SIC_code='5461'DB:business_master_new
loadtime:0.17622399330139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen Park' limit 1
loadtime:0.17627596855164 / seconds
Query Executed:select id FROM `mi` where city='Allen Park' && SIC_code='5461'DB:business_master_new
loadtime:0.17724704742432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.17730402946472 / seconds
Query Executed:select id FROM `mi` where city='Allendale' && SIC_code='5461'DB:business_master_new
loadtime:0.17800498008728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenton' limit 1
loadtime:0.17803907394409 / seconds
Query Executed:select id FROM `mi` where city='Allenton' && SIC_code='5461'DB:business_master_new
loadtime:0.21352910995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allouez' limit 1
loadtime:0.21361899375916 / seconds
Query Executed:select id FROM `mi` where city='Allouez' && SIC_code='5461'DB:business_master_new
loadtime:0.2163610458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.21643400192261 / seconds
Query Executed:select id FROM `mi` where city='Alma' && SIC_code='5461'DB:business_master_new
loadtime:0.21724915504456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almont' limit 1
loadtime:0.2173011302948 / seconds
Query Executed:select id FROM `mi` where city='Almont' && SIC_code='5461'DB:business_master_new
loadtime:0.21793508529663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.21798014640808 / seconds
Query Executed:select id FROM `mi` where city='Alpena' && SIC_code='5461'DB:business_master_new
loadtime:0.21932411193848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.21936798095703 / seconds
Query Executed:select id FROM `mi` where city='Alpha' && SIC_code='5461'DB:business_master_new
loadtime:0.22191214561462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.22196197509766 / seconds
Query Executed:select id FROM `mi` where city='Alto' && SIC_code='5461'DB:business_master_new
loadtime:0.2225661277771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amasa' limit 1
loadtime:0.22260594367981 / seconds
Query Executed:select id FROM `mi` where city='Amasa' && SIC_code='5461'DB:business_master_new
loadtime:0.22461700439453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anchorville' limit 1
loadtime:0.22464394569397 / seconds
Query Executed:select id FROM `mi` where city='Anchorville' && SIC_code='5461'DB:business_master_new
loadtime:0.22941112518311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ann Arbor' limit 1
loadtime:0.22947812080383 / seconds
Query Executed:select id FROM `mi` where city='Ann Arbor' && SIC_code='5461'DB:business_master_new
loadtime:0.33271408081055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Applegate' limit 1
loadtime:0.33277893066406 / seconds
Query Executed:select id FROM `mi` where city='Applegate' && SIC_code='5461'DB:business_master_new
loadtime:0.34029006958008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.34034204483032 / seconds
Query Executed:select id FROM `mi` where city='Arcadia' && SIC_code='5461'DB:business_master_new
loadtime:0.34934592247009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.34941792488098 / seconds
Query Executed:select id FROM `mi` where city='Argyle' && SIC_code='5461'DB:business_master_new
loadtime:0.35031604766846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armada' limit 1
loadtime:0.35036897659302 / seconds
Query Executed:select id FROM `mi` where city='Armada' && SIC_code='5461'DB:business_master_new
loadtime:0.35113596916199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnold' limit 1
loadtime:0.3511950969696 / seconds
Query Executed:select id FROM `mi` where city='Arnold' && SIC_code='5461'DB:business_master_new
loadtime:0.35179996490479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley' limit 1
loadtime:0.35182809829712 / seconds
Query Executed:select id FROM `mi` where city='Ashley' && SIC_code='5461'DB:business_master_new
loadtime:0.36287093162537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.36293292045593 / seconds
Query Executed:select id FROM `mi` where city='Athens' && SIC_code='5461'DB:business_master_new
loadtime:0.36357593536377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlanta' limit 1
loadtime:0.36361503601074 / seconds
Query Executed:select id FROM `mi` where city='Atlanta' && SIC_code='5461'DB:business_master_new
loadtime:0.37602996826172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Mine' limit 1
loadtime:0.37609004974365 / seconds
Query Executed:select id FROM `mi` where city='Atlantic Mine' && SIC_code='5461'DB:business_master_new
loadtime:0.38568711280823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlas' limit 1
loadtime:0.3857409954071 / seconds
Query Executed:select id FROM `mi` where city='Atlas' && SIC_code='5461'DB:business_master_new
loadtime:0.38832712173462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attica' limit 1
loadtime:0.38835692405701 / seconds
Query Executed:select id FROM `mi` where city='Attica' && SIC_code='5461'DB:business_master_new
loadtime:0.38900709152222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Gres' limit 1
loadtime:0.38904714584351 / seconds
Query Executed:select id FROM `mi` where city='Au Gres' && SIC_code='5461'DB:business_master_new
loadtime:0.38961791992188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Train' limit 1
loadtime:0.38964605331421 / seconds
Query Executed:select id FROM `mi` where city='Au Train' && SIC_code='5461'DB:business_master_new
loadtime:0.3977689743042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.39781713485718 / seconds
Query Executed:select id FROM `mi` where city='Auburn' && SIC_code='5461'DB:business_master_new
loadtime:0.39862704277039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn Hills' limit 1
loadtime:0.398677110672 / seconds
Query Executed:select id FROM `mi` where city='Auburn Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.39980101585388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.39985799789429 / seconds
Query Executed:select id FROM `mi` where city='Augusta' && SIC_code='5461'DB:business_master_new
loadtime:0.40046691894531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.4005241394043 / seconds
Query Executed:select id FROM `mi` where city='Avoca' && SIC_code='5461'DB:business_master_new
loadtime:0.40108704566956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Azalia' limit 1
loadtime:0.401123046875 / seconds
Query Executed:select id FROM `mi` where city='Azalia' && SIC_code='5461'DB:business_master_new
loadtime:0.40175104141235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bad Axe' limit 1
loadtime:0.40179896354675 / seconds
Query Executed:select id FROM `mi` where city='Bad Axe' && SIC_code='5461'DB:business_master_new
loadtime:0.40255498886108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.40260910987854 / seconds
Query Executed:select id FROM `mi` where city='Bailey' && SIC_code='5461'DB:business_master_new
loadtime:0.40849494934082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.40855002403259 / seconds
Query Executed:select id FROM `mi` where city='Baldwin' && SIC_code='5461'DB:business_master_new
loadtime:0.40917992591858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.40921497344971 / seconds
Query Executed:select id FROM `mi` where city='Bancroft' && SIC_code='5461'DB:business_master_new
loadtime:0.42693305015564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bangor' limit 1
loadtime:0.42702794075012 / seconds
Query Executed:select id FROM `mi` where city='Bangor' && SIC_code='5461'DB:business_master_new
loadtime:0.42775392532349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bannister' limit 1
loadtime:0.42779111862183 / seconds
Query Executed:select id FROM `mi` where city='Bannister' && SIC_code='5461'DB:business_master_new
loadtime:0.43273591995239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baraga' limit 1
loadtime:0.432785987854 / seconds
Query Executed:select id FROM `mi` where city='Baraga' && SIC_code='5461'DB:business_master_new
loadtime:0.43335795402527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barbeau' limit 1
loadtime:0.43339800834656 / seconds
Query Executed:select id FROM `mi` where city='Barbeau' && SIC_code='5461'DB:business_master_new
loadtime:0.43758511543274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bark River' limit 1
loadtime:0.43763613700867 / seconds
Query Executed:select id FROM `mi` where city='Bark River' && SIC_code='5461'DB:business_master_new
loadtime:0.43821597099304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baroda' limit 1
loadtime:0.43825697898865 / seconds
Query Executed:select id FROM `mi` where city='Baroda' && SIC_code='5461'DB:business_master_new
loadtime:0.43884611129761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barryton' limit 1
loadtime:0.43889594078064 / seconds
Query Executed:select id FROM `mi` where city='Barryton' && SIC_code='5461'DB:business_master_new
loadtime:0.43943309783936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton City' limit 1
loadtime:0.43947196006775 / seconds
Query Executed:select id FROM `mi` where city='Barton City' && SIC_code='5461'DB:business_master_new
loadtime:0.44399809837341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.44403314590454 / seconds
Query Executed:select id FROM `mi` where city='Bath' && SIC_code='5461'DB:business_master_new
loadtime:0.44463300704956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.44467306137085 / seconds
Query Executed:select id FROM `mi` where city='Battle Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.46348905563354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.46354794502258 / seconds
Query Executed:select id FROM `mi` where city='Bay City' && SIC_code='5461'DB:business_master_new
loadtime:0.46908903121948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Port' limit 1
loadtime:0.46915698051453 / seconds
Query Executed:select id FROM `mi` where city='Bay Port' && SIC_code='5461'DB:business_master_new
loadtime:0.48424696922302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Shore' limit 1
loadtime:0.48431706428528 / seconds
Query Executed:select id FROM `mi` where city='Bay Shore' && SIC_code='5461'DB:business_master_new
loadtime:0.48483800888062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay View' limit 1
loadtime:0.48489499092102 / seconds
Query Executed:select id FROM `mi` where city='Bay View' && SIC_code='5461'DB:business_master_new
loadtime:0.48559713363647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Lake' limit 1
loadtime:0.48569202423096 / seconds
Query Executed:select id FROM `mi` where city='Bear Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.48737812042236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver Island' limit 1
loadtime:0.48754215240479 / seconds
Query Executed:select id FROM `mi` where city='Beaver Island' && SIC_code='5461'DB:business_master_new
loadtime:0.48832201957703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverton' limit 1
loadtime:0.48837494850159 / seconds
Query Executed:select id FROM `mi` where city='Beaverton' && SIC_code='5461'DB:business_master_new
loadtime:0.48900413513184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.48903894424438 / seconds
Query Executed:select id FROM `mi` where city='Bedford' && SIC_code='5461'DB:business_master_new
loadtime:0.49078297615051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belding' limit 1
loadtime:0.49083113670349 / seconds
Query Executed:select id FROM `mi` where city='Belding' && SIC_code='5461'DB:business_master_new
loadtime:0.49151015281677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellaire' limit 1
loadtime:0.49154615402222 / seconds
Query Executed:select id FROM `mi` where city='Bellaire' && SIC_code='5461'DB:business_master_new
loadtime:0.49221611022949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.49226498603821 / seconds
Query Executed:select id FROM `mi` where city='Belleville' && SIC_code='5461'DB:business_master_new
loadtime:0.49294996261597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.49297714233398 / seconds
Query Executed:select id FROM `mi` where city='Bellevue' && SIC_code='5461'DB:business_master_new
loadtime:0.49355411529541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.49359011650085 / seconds
Query Executed:select id FROM `mi` where city='Belmont' && SIC_code='5461'DB:business_master_new
loadtime:0.49422907829285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentley' limit 1
loadtime:0.49427103996277 / seconds
Query Executed:select id FROM `mi` where city='Bentley' && SIC_code='5461'DB:business_master_new
loadtime:0.49847912788391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton Harbor' limit 1
loadtime:0.49852800369263 / seconds
Query Executed:select id FROM `mi` where city='Benton Harbor' && SIC_code='5461'DB:business_master_new
loadtime:0.49977612495422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benzonia' limit 1
loadtime:0.49983501434326 / seconds
Query Executed:select id FROM `mi` where city='Benzonia' && SIC_code='5461'DB:business_master_new
loadtime:0.50042700767517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergland' limit 1
loadtime:0.50046300888062 / seconds
Query Executed:select id FROM `mi` where city='Bergland' && SIC_code='5461'DB:business_master_new
loadtime:0.50193905830383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.50198793411255 / seconds
Query Executed:select id FROM `mi` where city='Berkley' && SIC_code='5461'DB:business_master_new
loadtime:0.50287413597107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.50292015075684 / seconds
Query Executed:select id FROM `mi` where city='Berlin' && SIC_code='5461'DB:business_master_new
loadtime:0.50373411178589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Center' limit 1
loadtime:0.50379300117493 / seconds
Query Executed:select id FROM `mi` where city='Berrien Center' && SIC_code='5461'DB:business_master_new
loadtime:0.51465511322021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Springs' limit 1
loadtime:0.51470112800598 / seconds
Query Executed:select id FROM `mi` where city='Berrien Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.51550102233887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berville' limit 1
loadtime:0.51556491851807 / seconds
Query Executed:select id FROM `mi` where city='Berville' && SIC_code='5461'DB:business_master_new
loadtime:0.51581001281738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer' limit 1
loadtime:0.51583814620972 / seconds
Query Executed:select id FROM `mi` where city='Bessemer' && SIC_code='5461'DB:business_master_new
loadtime:0.51642608642578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.51647996902466 / seconds
Query Executed:select id FROM `mi` where city='Beulah' && SIC_code='5461'DB:business_master_new
loadtime:0.51709294319153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly Hills' limit 1
loadtime:0.51713895797729 / seconds
Query Executed:select id FROM `mi` where city='Beverly Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.52122712135315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bay' limit 1
loadtime:0.52128005027771 / seconds
Query Executed:select id FROM `mi` where city='Big Bay' && SIC_code='5461'DB:business_master_new
loadtime:0.52442312240601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rapids' limit 1
loadtime:0.52445912361145 / seconds
Query Executed:select id FROM `mi` where city='Big Rapids' && SIC_code='5461'DB:business_master_new
loadtime:0.52542805671692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham Farms' limit 1
loadtime:0.52548599243164 / seconds
Query Executed:select id FROM `mi` where city='Bingham Farms' && SIC_code='5461'DB:business_master_new
loadtime:0.52694797515869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birch Run' limit 1
loadtime:0.52698397636414 / seconds
Query Executed:select id FROM `mi` where city='Birch Run' && SIC_code='5461'DB:business_master_new
loadtime:0.52774715423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.52781414985657 / seconds
Query Executed:select id FROM `mi` where city='Birmingham' && SIC_code='5461'DB:business_master_new
loadtime:0.53368496894836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bitely' limit 1
loadtime:0.53374910354614 / seconds
Query Executed:select id FROM `mi` where city='Bitely' && SIC_code='5461'DB:business_master_new
loadtime:0.54169011116028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River' limit 1
loadtime:0.54172992706299 / seconds
Query Executed:select id FROM `mi` where city='Black River' && SIC_code='5461'DB:business_master_new
loadtime:0.54356598854065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.54361605644226 / seconds
Query Executed:select id FROM `mi` where city='Blanchard' && SIC_code='5461'DB:business_master_new
loadtime:0.54425692558289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blissfield' limit 1
loadtime:0.54430198669434 / seconds
Query Executed:select id FROM `mi` where city='Blissfield' && SIC_code='5461'DB:business_master_new
loadtime:0.54498505592346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Hills' limit 1
loadtime:0.54503393173218 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.55073213577271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Twp' limit 1
loadtime:0.55078911781311 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.55304312705994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingdale' limit 1
loadtime:0.55309295654297 / seconds
Query Executed:select id FROM `mi` where city='Bloomingdale' && SIC_code='5461'DB:business_master_new
loadtime:0.55367994308472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boon' limit 1
loadtime:0.55371403694153 / seconds
Query Executed:select id FROM `mi` where city='Boon' && SIC_code='5461'DB:business_master_new
loadtime:0.55697298049927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne City' limit 1
loadtime:0.55702114105225 / seconds
Query Executed:select id FROM `mi` where city='Boyne City' && SIC_code='5461'DB:business_master_new
loadtime:0.55776596069336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne Falls' limit 1
loadtime:0.55781006813049 / seconds
Query Executed:select id FROM `mi` where city='Boyne Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.55837297439575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.55843305587769 / seconds
Query Executed:select id FROM `mi` where city='Bradley' && SIC_code='5461'DB:business_master_new
loadtime:0.55958294868469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branch' limit 1
loadtime:0.55963015556335 / seconds
Query Executed:select id FROM `mi` where city='Branch' && SIC_code='5461'DB:business_master_new
loadtime:0.56686305999756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant' limit 1
loadtime:0.56690096855164 / seconds
Query Executed:select id FROM `mi` where city='Brant' && SIC_code='5461'DB:business_master_new
loadtime:0.57039904594421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breckenridge' limit 1
loadtime:0.57045102119446 / seconds
Query Executed:select id FROM `mi` where city='Breckenridge' && SIC_code='5461'DB:business_master_new
loadtime:0.57104110717773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breedsville' limit 1
loadtime:0.57108592987061 / seconds
Query Executed:select id FROM `mi` where city='Breedsville' && SIC_code='5461'DB:business_master_new
loadtime:0.57141208648682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brethren' limit 1
loadtime:0.57145094871521 / seconds
Query Executed:select id FROM `mi` where city='Brethren' && SIC_code='5461'DB:business_master_new
loadtime:0.57675313949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.57678914070129 / seconds
Query Executed:select id FROM `mi` where city='Bridgeport' && SIC_code='5461'DB:business_master_new
loadtime:0.57741808891296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.57747793197632 / seconds
Query Executed:select id FROM `mi` where city='Bridgewater' && SIC_code='5461'DB:business_master_new
loadtime:0.57773995399475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgman' limit 1
loadtime:0.57776713371277 / seconds
Query Executed:select id FROM `mi` where city='Bridgman' && SIC_code='5461'DB:business_master_new
loadtime:0.57838106155396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.57845306396484 / seconds
Query Executed:select id FROM `mi` where city='Brighton' && SIC_code='5461'DB:business_master_new
loadtime:0.58427309989929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimley' limit 1
loadtime:0.58433294296265 / seconds
Query Executed:select id FROM `mi` where city='Brimley' && SIC_code='5461'DB:business_master_new
loadtime:0.58491706848145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.58495402336121 / seconds
Query Executed:select id FROM `mi` where city='Britton' && SIC_code='5461'DB:business_master_new
loadtime:0.58548402786255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockway' limit 1
loadtime:0.58552598953247 / seconds
Query Executed:select id FROM `mi` where city='Brockway' && SIC_code='5461'DB:business_master_new
loadtime:0.58577108383179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brohman' limit 1
loadtime:0.5857949256897 / seconds
Query Executed:select id FROM `mi` where city='Brohman' && SIC_code='5461'DB:business_master_new
loadtime:0.58903312683105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.58908295631409 / seconds
Query Executed:select id FROM `mi` where city='Bronson' && SIC_code='5461'DB:business_master_new
loadtime:0.58970499038696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.58975505828857 / seconds
Query Executed:select id FROM `mi` where city='Brooklyn' && SIC_code='5461'DB:business_master_new
loadtime:0.59044194221497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brown City' limit 1
loadtime:0.5904860496521 / seconds
Query Executed:select id FROM `mi` where city='Brown City' && SIC_code='5461'DB:business_master_new
loadtime:0.59109401702881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownstown Twp' limit 1
loadtime:0.5911431312561 / seconds
Query Executed:select id FROM `mi` where city='Brownstown Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.59198498725891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.59202003479004 / seconds
Query Executed:select id FROM `mi` where city='Bruce' && SIC_code='5461'DB:business_master_new
loadtime:0.59246397018433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce Crossing' limit 1
loadtime:0.5925030708313 / seconds
Query Executed:select id FROM `mi` where city='Bruce Crossing' && SIC_code='5461'DB:business_master_new
loadtime:0.5961480140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brutus' limit 1
loadtime:0.59618306159973 / seconds
Query Executed:select id FROM `mi` where city='Brutus' && SIC_code='5461'DB:business_master_new
loadtime:0.60141491889954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:0.60146307945251 / seconds
Query Executed:select id FROM `mi` where city='Buchanan' && SIC_code='5461'DB:business_master_new
loadtime:0.60216403007507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckley' limit 1
loadtime:0.6021990776062 / seconds
Query Executed:select id FROM `mi` where city='Buckley' && SIC_code='5461'DB:business_master_new
loadtime:0.60279297828674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.60283899307251 / seconds
Query Executed:select id FROM `mi` where city='Burlington' && SIC_code='5461'DB:business_master_new
loadtime:0.60786414146423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnips' limit 1
loadtime:0.60791397094727 / seconds
Query Executed:select id FROM `mi` where city='Burnips' && SIC_code='5461'DB:business_master_new
loadtime:0.60872411727905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Oak' limit 1
loadtime:0.60875797271729 / seconds
Query Executed:select id FROM `mi` where city='Burr Oak' && SIC_code='5461'DB:business_master_new
loadtime:0.61372208595276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:0.61377215385437 / seconds
Query Executed:select id FROM `mi` where city='Burt' && SIC_code='5461'DB:business_master_new
loadtime:0.62258100509644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt Lake' limit 1
loadtime:0.62261605262756 / seconds
Query Executed:select id FROM `mi` where city='Burt Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.62328910827637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burtchville' limit 1
loadtime:0.62333703041077 / seconds
Query Executed:select id FROM `mi` where city='Burtchville' && SIC_code='5461'DB:business_master_new
loadtime:0.62448215484619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burton' limit 1
loadtime:0.62451791763306 / seconds
Query Executed:select id FROM `mi` where city='Burton' && SIC_code='5461'DB:business_master_new
loadtime:0.62560892105103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:0.62566804885864 / seconds
Query Executed:select id FROM `mi` where city='Byron' && SIC_code='5461'DB:business_master_new
loadtime:0.62621903419495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron Center' limit 1
loadtime:0.6262469291687 / seconds
Query Executed:select id FROM `mi` where city='Byron Center' && SIC_code='5461'DB:business_master_new
loadtime:0.62706899642944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cadillac' limit 1
loadtime:0.62710499763489 / seconds
Query Executed:select id FROM `mi` where city='Cadillac' && SIC_code='5461'DB:business_master_new
loadtime:0.62811207771301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.62815594673157 / seconds
Query Executed:select id FROM `mi` where city='Caledonia' && SIC_code='5461'DB:business_master_new
loadtime:0.62892007827759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.62895703315735 / seconds
Query Executed:select id FROM `mi` where city='Calumet' && SIC_code='5461'DB:business_master_new
loadtime:0.62961006164551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.62965106964111 / seconds
Query Executed:select id FROM `mi` where city='Camden' && SIC_code='5461'DB:business_master_new
loadtime:0.63015604019165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannonsburg' limit 1
loadtime:0.63018107414246 / seconds
Query Executed:select id FROM `mi` where city='Cannonsburg' && SIC_code='5461'DB:business_master_new
loadtime:0.631511926651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.63155102729797 / seconds
Query Executed:select id FROM `mi` where city='Canton' && SIC_code='5461'DB:business_master_new
loadtime:0.63246893882751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capac' limit 1
loadtime:0.63250494003296 / seconds
Query Executed:select id FROM `mi` where city='Capac' && SIC_code='5461'DB:business_master_new
loadtime:0.63305306434631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carleton' limit 1
loadtime:0.6330771446228 / seconds
Query Executed:select id FROM `mi` where city='Carleton' && SIC_code='5461'DB:business_master_new
loadtime:0.63368701934814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carney' limit 1
loadtime:0.63372206687927 / seconds
Query Executed:select id FROM `mi` where city='Carney' && SIC_code='5461'DB:business_master_new
loadtime:0.63751292228699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caro' limit 1
loadtime:0.63754892349243 / seconds
Query Executed:select id FROM `mi` where city='Caro' && SIC_code='5461'DB:business_master_new
loadtime:0.63831114768982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carp Lake' limit 1
loadtime:0.63835191726685 / seconds
Query Executed:select id FROM `mi` where city='Carp Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.64249515533447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.64254403114319 / seconds
Query Executed:select id FROM `mi` where city='Carrollton' && SIC_code='5461'DB:business_master_new
loadtime:0.64586710929871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson City' limit 1
loadtime:0.64590811729431 / seconds
Query Executed:select id FROM `mi` where city='Carson City' && SIC_code='5461'DB:business_master_new
loadtime:0.64651298522949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carsonville' limit 1
loadtime:0.64654111862183 / seconds
Query Executed:select id FROM `mi` where city='Carsonville' && SIC_code='5461'DB:business_master_new
loadtime:0.64704608917236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casco' limit 1
loadtime:0.64708304405212 / seconds
Query Executed:select id FROM `mi` where city='Casco' && SIC_code='5461'DB:business_master_new
loadtime:0.64762592315674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caseville' limit 1
loadtime:0.64765095710754 / seconds
Query Executed:select id FROM `mi` where city='Caseville' && SIC_code='5461'DB:business_master_new
loadtime:0.64820504188538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casnovia' limit 1
loadtime:0.6482400894165 / seconds
Query Executed:select id FROM `mi` where city='Casnovia' && SIC_code='5461'DB:business_master_new
loadtime:0.65543603897095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caspian' limit 1
loadtime:0.6554651260376 / seconds
Query Executed:select id FROM `mi` where city='Caspian' && SIC_code='5461'DB:business_master_new
loadtime:0.66046404838562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cass City' limit 1
loadtime:0.66051006317139 / seconds
Query Executed:select id FROM `mi` where city='Cass City' && SIC_code='5461'DB:business_master_new
loadtime:0.66114902496338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassopolis' limit 1
loadtime:0.66118001937866 / seconds
Query Executed:select id FROM `mi` where city='Cassopolis' && SIC_code='5461'DB:business_master_new
loadtime:0.66185712814331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.66190004348755 / seconds
Query Executed:select id FROM `mi` where city='Cedar' && SIC_code='5461'DB:business_master_new
loadtime:0.66248202323914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Lake' limit 1
loadtime:0.66251301765442 / seconds
Query Executed:select id FROM `mi` where city='Cedar Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.66393399238586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar River' limit 1
loadtime:0.66397500038147 / seconds
Query Executed:select id FROM `mi` where city='Cedar River' && SIC_code='5461'DB:business_master_new
loadtime:0.66424012184143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Springs' limit 1
loadtime:0.66427707672119 / seconds
Query Executed:select id FROM `mi` where city='Cedar Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.66504001617432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:0.66508102416992 / seconds
Query Executed:select id FROM `mi` where city='Cedarville' && SIC_code='5461'DB:business_master_new
loadtime:0.66565299034119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cement City' limit 1
loadtime:0.665696144104 / seconds
Query Executed:select id FROM `mi` where city='Cement City' && SIC_code='5461'DB:business_master_new
loadtime:0.66621804237366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Line' limit 1
loadtime:0.66624808311462 / seconds
Query Executed:select id FROM `mi` where city='Center Line' && SIC_code='5461'DB:business_master_new
loadtime:0.66694712638855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Lake' limit 1
loadtime:0.66699600219727 / seconds
Query Executed:select id FROM `mi` where city='Central Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.66760802268982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.66764402389526 / seconds
Query Executed:select id FROM `mi` where city='Centreville' && SIC_code='5461'DB:business_master_new
loadtime:0.67789602279663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceresco' limit 1
loadtime:0.67795610427856 / seconds
Query Executed:select id FROM `mi` where city='Ceresco' && SIC_code='5461'DB:business_master_new
loadtime:0.68453693389893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champion' limit 1
loadtime:0.6845850944519 / seconds
Query Executed:select id FROM `mi` where city='Champion' && SIC_code='5461'DB:business_master_new
loadtime:0.69303202629089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Channing' limit 1
loadtime:0.69306898117065 / seconds
Query Executed:select id FROM `mi` where city='Channing' && SIC_code='5461'DB:business_master_new
loadtime:0.69491505622864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlevoix' limit 1
loadtime:0.69496393203735 / seconds
Query Executed:select id FROM `mi` where city='Charlevoix' && SIC_code='5461'DB:business_master_new
loadtime:0.69586706161499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.69591403007507 / seconds
Query Executed:select id FROM `mi` where city='Charlotte' && SIC_code='5461'DB:business_master_new
loadtime:0.69682812690735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase' limit 1
loadtime:0.69688415527344 / seconds
Query Executed:select id FROM `mi` where city='Chase' && SIC_code='5461'DB:business_master_new
loadtime:0.69964504241943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chassell' limit 1
loadtime:0.69969201087952 / seconds
Query Executed:select id FROM `mi` where city='Chassell' && SIC_code='5461'DB:business_master_new
loadtime:0.70026803016663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.70031213760376 / seconds
Query Executed:select id FROM `mi` where city='Chatham' && SIC_code='5461'DB:business_master_new
loadtime:0.7073609828949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheboygan' limit 1
loadtime:0.70741510391235 / seconds
Query Executed:select id FROM `mi` where city='Cheboygan' && SIC_code='5461'DB:business_master_new
loadtime:0.70835900306702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.70843315124512 / seconds
Query Executed:select id FROM `mi` where city='Chelsea' && SIC_code='5461'DB:business_master_new
loadtime:0.70911812782288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesaning' limit 1
loadtime:0.70915412902832 / seconds
Query Executed:select id FROM `mi` where city='Chesaning' && SIC_code='5461'DB:business_master_new
loadtime:0.70984292030334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.70989894866943 / seconds
Query Executed:select id FROM `mi` where city='Chesterfield' && SIC_code='5461'DB:business_master_new
loadtime:0.71340012550354 / seconds
Query loaded from cache:select * from geodata_geocity where city='China' limit 1
loadtime:0.71344900131226 / seconds
Query Executed:select id FROM `mi` where city='China' && SIC_code='5461'DB:business_master_new
loadtime:0.71415400505066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chippewa Lake' limit 1
loadtime:0.71420097351074 / seconds
Query Executed:select id FROM `mi` where city='Chippewa Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.71608400344849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christmas' limit 1
loadtime:0.71611905097961 / seconds
Query Executed:select id FROM `mi` where city='Christmas' && SIC_code='5461'DB:business_master_new
loadtime:0.71640706062317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:0.71644806861877 / seconds
Query Executed:select id FROM `mi` where city='Clare' && SIC_code='5461'DB:business_master_new
loadtime:0.71719598770142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarklake' limit 1
loadtime:0.71723914146423 / seconds
Query Executed:select id FROM `mi` where city='Clarklake' && SIC_code='5461'DB:business_master_new
loadtime:0.71782612800598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:0.71787405014038 / seconds
Query Executed:select id FROM `mi` where city='Clarkston' && SIC_code='5461'DB:business_master_new
loadtime:0.72375011444092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.72382092475891 / seconds
Query Executed:select id FROM `mi` where city='Clarksville' && SIC_code='5461'DB:business_master_new
loadtime:0.73338294029236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clawson' limit 1
loadtime:0.73343014717102 / seconds
Query Executed:select id FROM `mi` where city='Clawson' && SIC_code='5461'DB:business_master_new
loadtime:0.73423409461975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay' limit 1
loadtime:0.73428511619568 / seconds
Query Executed:select id FROM `mi` where city='Clay' && SIC_code='5461'DB:business_master_new
loadtime:0.73564100265503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.73567795753479 / seconds
Query Executed:select id FROM `mi` where city='Clayton' && SIC_code='5461'DB:business_master_new
loadtime:0.74237513542175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:0.74241805076599 / seconds
Query Executed:select id FROM `mi` where city='Clifford' && SIC_code='5461'DB:business_master_new
loadtime:0.7465181350708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.74655413627625 / seconds
Query Executed:select id FROM `mi` where city='Climax' && SIC_code='5461'DB:business_master_new
loadtime:0.74709892272949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.74713110923767 / seconds
Query Executed:select id FROM `mi` where city='Clinton' && SIC_code='5461'DB:business_master_new
loadtime:0.74771308898926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Township' limit 1
loadtime:0.74775004386902 / seconds
Query Executed:select id FROM `mi` where city='Clinton Township' && SIC_code='5461'DB:business_master_new
loadtime:0.75353097915649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Twp' limit 1
loadtime:0.75357508659363 / seconds
Query Executed:select id FROM `mi` where city='Clinton Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.7637939453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.76384115219116 / seconds
Query Executed:select id FROM `mi` where city='Clio' && SIC_code='5461'DB:business_master_new
loadtime:0.76465702056885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:0.76468205451965 / seconds
Query Executed:select id FROM `mi` where city='Cloverdale' && SIC_code='5461'DB:business_master_new
loadtime:0.76536893844604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:0.7654139995575 / seconds
Query Executed:select id FROM `mi` where city='Clyde' && SIC_code='5461'DB:business_master_new
loadtime:0.76589202880859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohoctah' limit 1
loadtime:0.76592397689819 / seconds
Query Executed:select id FROM `mi` where city='Cohoctah' && SIC_code='5461'DB:business_master_new
loadtime:0.76720213890076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.76722598075867 / seconds
Query Executed:select id FROM `mi` where city='Coldwater' && SIC_code='5461'DB:business_master_new
loadtime:0.76824402809143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman' limit 1
loadtime:0.76828598976135 / seconds
Query Executed:select id FROM `mi` where city='Coleman' && SIC_code='5461'DB:business_master_new
loadtime:0.7688729763031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coloma' limit 1
loadtime:0.76890707015991 / seconds
Query Executed:select id FROM `mi` where city='Coloma' && SIC_code='5461'DB:business_master_new
loadtime:0.76960706710815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colon' limit 1
loadtime:0.76963806152344 / seconds
Query Executed:select id FROM `mi` where city='Colon' && SIC_code='5461'DB:business_master_new
loadtime:0.77595806121826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbiaville' limit 1
loadtime:0.77599596977234 / seconds
Query Executed:select id FROM `mi` where city='Columbiaville' && SIC_code='5461'DB:business_master_new
loadtime:0.77659606933594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.77662706375122 / seconds
Query Executed:select id FROM `mi` where city='Columbus' && SIC_code='5461'DB:business_master_new
loadtime:0.77715492248535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comins' limit 1
loadtime:0.77718806266785 / seconds
Query Executed:select id FROM `mi` where city='Comins' && SIC_code='5461'DB:business_master_new
loadtime:0.77986407279968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Township' limit 1
loadtime:0.77990007400513 / seconds
Query Executed:select id FROM `mi` where city='Commerce Township' && SIC_code='5461'DB:business_master_new
loadtime:0.7810230255127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Twp' limit 1
loadtime:0.78108096122742 / seconds
Query Executed:select id FROM `mi` where city='Commerce Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.78397512435913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock' limit 1
loadtime:0.78400993347168 / seconds
Query Executed:select id FROM `mi` where city='Comstock' && SIC_code='5461'DB:business_master_new
loadtime:0.78896403312683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock Park' limit 1
loadtime:0.78901314735413 / seconds
Query Executed:select id FROM `mi` where city='Comstock Park' && SIC_code='5461'DB:business_master_new
loadtime:0.78982210159302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.78987002372742 / seconds
Query Executed:select id FROM `mi` where city='Concord' && SIC_code='5461'DB:business_master_new
loadtime:0.79046010971069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conklin' limit 1
loadtime:0.79049301147461 / seconds
Query Executed:select id FROM `mi` where city='Conklin' && SIC_code='5461'DB:business_master_new
loadtime:0.79101705551147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Constantine' limit 1
loadtime:0.79105401039124 / seconds
Query Executed:select id FROM `mi` where city='Constantine' && SIC_code='5461'DB:business_master_new
loadtime:0.79157209396362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.7916100025177 / seconds
Query Executed:select id FROM `mi` where city='Conway' && SIC_code='5461'DB:business_master_new
loadtime:0.79516315460205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooks' limit 1
loadtime:0.7951979637146 / seconds
Query Executed:select id FROM `mi` where city='Cooks' && SIC_code='5461'DB:business_master_new
loadtime:0.79625296592712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coopersville' limit 1
loadtime:0.79629492759705 / seconds
Query Executed:select id FROM `mi` where city='Coopersville' && SIC_code='5461'DB:business_master_new
loadtime:0.79696893692017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copemish' limit 1
loadtime:0.79700398445129 / seconds
Query Executed:select id FROM `mi` where city='Copemish' && SIC_code='5461'DB:business_master_new
loadtime:0.80241107940674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper City' limit 1
loadtime:0.80245900154114 / seconds
Query Executed:select id FROM `mi` where city='Copper City' && SIC_code='5461'DB:business_master_new
loadtime:0.80277514457703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Harbor' limit 1
loadtime:0.80280995368958 / seconds
Query Executed:select id FROM `mi` where city='Copper Harbor' && SIC_code='5461'DB:business_master_new
loadtime:0.80651211738586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coral' limit 1
loadtime:0.80655908584595 / seconds
Query Executed:select id FROM `mi` where city='Coral' && SIC_code='5461'DB:business_master_new
loadtime:0.81342196464539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornell' limit 1
loadtime:0.81355309486389 / seconds
Query Executed:select id FROM `mi` where city='Cornell' && SIC_code='5461'DB:business_master_new
loadtime:0.81540703773499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corunna' limit 1
loadtime:0.81544303894043 / seconds
Query Executed:select id FROM `mi` where city='Corunna' && SIC_code='5461'DB:business_master_new
loadtime:0.81609797477722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottrellville' limit 1
loadtime:0.81614398956299 / seconds
Query Executed:select id FROM `mi` where city='Cottrellville' && SIC_code='5461'DB:business_master_new
loadtime:0.81641101837158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covert' limit 1
loadtime:0.81643795967102 / seconds
Query Executed:select id FROM `mi` where city='Covert' && SIC_code='5461'DB:business_master_new
loadtime:0.82212114334106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:0.82217812538147 / seconds
Query Executed:select id FROM `mi` where city='Covington' && SIC_code='5461'DB:business_master_new
loadtime:0.82741403579712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Village' limit 1
loadtime:0.82746601104736 / seconds
Query Executed:select id FROM `mi` where city='Cross Village' && SIC_code='5461'DB:business_master_new
loadtime:0.82780814170837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croswell' limit 1
loadtime:0.82784295082092 / seconds
Query Executed:select id FROM `mi` where city='Croswell' && SIC_code='5461'DB:business_master_new
loadtime:0.8284900188446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal' limit 1
loadtime:0.82854914665222 / seconds
Query Executed:select id FROM `mi` where city='Crystal' && SIC_code='5461'DB:business_master_new
loadtime:0.82914209365845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Falls' limit 1
loadtime:0.82917809486389 / seconds
Query Executed:select id FROM `mi` where city='Crystal Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.82985305786133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curran' limit 1
loadtime:0.82990908622742 / seconds
Query Executed:select id FROM `mi` where city='Curran' && SIC_code='5461'DB:business_master_new
loadtime:0.83061814308167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtis' limit 1
loadtime:0.83069801330566 / seconds
Query Executed:select id FROM `mi` where city='Curtis' && SIC_code='5461'DB:business_master_new
loadtime:0.83164501190186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.8316810131073 / seconds
Query Executed:select id FROM `mi` where city='Custer' && SIC_code='5461'DB:business_master_new
loadtime:0.84127902984619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dafter' limit 1
loadtime:0.84133410453796 / seconds
Query Executed:select id FROM `mi` where city='Dafter' && SIC_code='5461'DB:business_master_new
loadtime:0.8455650806427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daggett' limit 1
loadtime:0.84560012817383 / seconds
Query Executed:select id FROM `mi` where city='Daggett' && SIC_code='5461'DB:business_master_new
loadtime:0.84888696670532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dansville' limit 1
loadtime:0.84893393516541 / seconds
Query Executed:select id FROM `mi` where city='Dansville' && SIC_code='5461'DB:business_master_new
loadtime:0.84950113296509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davisburg' limit 1
loadtime:0.84953713417053 / seconds
Query Executed:select id FROM `mi` where city='Davisburg' && SIC_code='5461'DB:business_master_new
loadtime:0.85019111633301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davison' limit 1
loadtime:0.85023808479309 / seconds
Query Executed:select id FROM `mi` where city='Davison' && SIC_code='5461'DB:business_master_new
loadtime:0.85119199752808 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Tour Village' limit 1
loadtime:0.85125494003296 / seconds
Query Executed:select id FROM `mi` where city='De Tour Village' && SIC_code='5461'DB:business_master_new
loadtime:0.86137008666992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn' limit 1
loadtime:0.8614399433136 / seconds
Query Executed:select id FROM `mi` where city='Dearborn' && SIC_code='5461'DB:business_master_new
loadtime:0.86252808570862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn Heights' limit 1
loadtime:0.86256408691406 / seconds
Query Executed:select id FROM `mi` where city='Dearborn Heights' && SIC_code='5461'DB:business_master_new
loadtime:0.86343908309937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.86348700523376 / seconds
Query Executed:select id FROM `mi` where city='Decatur' && SIC_code='5461'DB:business_master_new
loadtime:0.86409401893616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decker' limit 1
loadtime:0.86412906646729 / seconds
Query Executed:select id FROM `mi` where city='Decker' && SIC_code='5461'DB:business_master_new
loadtime:0.86643600463867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deckerville' limit 1
loadtime:0.86648297309875 / seconds
Query Executed:select id FROM `mi` where city='Deckerville' && SIC_code='5461'DB:business_master_new
loadtime:0.86708498001099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.8671281337738 / seconds
Query Executed:select id FROM `mi` where city='Deerfield' && SIC_code='5461'DB:business_master_new
loadtime:0.87464308738708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerton' limit 1
loadtime:0.87468004226685 / seconds
Query Executed:select id FROM `mi` where city='Deerton' && SIC_code='5461'DB:business_master_new
loadtime:0.87615895271301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deford' limit 1
loadtime:0.87620711326599 / seconds
Query Executed:select id FROM `mi` where city='Deford' && SIC_code='5461'DB:business_master_new
loadtime:0.87873601913452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delton' limit 1
loadtime:0.87877106666565 / seconds
Query Executed:select id FROM `mi` where city='Delton' && SIC_code='5461'DB:business_master_new
loadtime:0.87941193580627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Detroit' limit 1
loadtime:0.87945914268494 / seconds
Query Executed:select id FROM `mi` where city='Detroit' && SIC_code='5461'DB:business_master_new
loadtime:0.88541698455811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:0.88549709320068 / seconds
Query Executed:select id FROM `mi` where city='Dewitt' && SIC_code='5461'DB:business_master_new
loadtime:0.88634514808655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.88641309738159 / seconds
Query Executed:select id FROM `mi` where city='Dexter' && SIC_code='5461'DB:business_master_new
loadtime:0.88707494735718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimondale' limit 1
loadtime:0.88710999488831 / seconds
Query Executed:select id FROM `mi` where city='Dimondale' && SIC_code='5461'DB:business_master_new
loadtime:0.88775300979614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodgeville' limit 1
loadtime:0.88782501220703 / seconds
Query Executed:select id FROM `mi` where city='Dodgeville' && SIC_code='5461'DB:business_master_new
loadtime:0.88857102394104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dollar Bay' limit 1
loadtime:0.88860607147217 / seconds
Query Executed:select id FROM `mi` where city='Dollar Bay' && SIC_code='5461'DB:business_master_new
loadtime:0.8921320438385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorr' limit 1
loadtime:0.89217901229858 / seconds
Query Executed:select id FROM `mi` where city='Dorr' && SIC_code='5461'DB:business_master_new
loadtime:0.89282512664795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.89285898208618 / seconds
Query Executed:select id FROM `mi` where city='Douglas' && SIC_code='5461'DB:business_master_new
loadtime:0.89343214035034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowagiac' limit 1
loadtime:0.89347910881042 / seconds
Query Executed:select id FROM `mi` where city='Dowagiac' && SIC_code='5461'DB:business_master_new
loadtime:0.89430713653564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowling' limit 1
loadtime:0.89435315132141 / seconds
Query Executed:select id FROM `mi` where city='Dowling' && SIC_code='5461'DB:business_master_new
loadtime:0.89759397506714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton Plains' limit 1
loadtime:0.89764213562012 / seconds
Query Executed:select id FROM `mi` where city='Drayton Plains' && SIC_code='5461'DB:business_master_new
loadtime:0.9035439491272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drummond Island' limit 1
loadtime:0.90359210968018 / seconds
Query Executed:select id FROM `mi` where city='Drummond Island' && SIC_code='5461'DB:business_master_new
loadtime:0.9044189453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:0.90446209907532 / seconds
Query Executed:select id FROM `mi` where city='Dryden' && SIC_code='5461'DB:business_master_new
loadtime:0.90506196022034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.90511012077332 / seconds
Query Executed:select id FROM `mi` where city='Dundee' && SIC_code='5461'DB:business_master_new
loadtime:0.90576100349426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durand' limit 1
loadtime:0.90579605102539 / seconds
Query Executed:select id FROM `mi` where city='Durand' && SIC_code='5461'DB:business_master_new
loadtime:0.90644907951355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:0.90650606155396 / seconds
Query Executed:select id FROM `mi` where city='Dutton' && SIC_code='5461'DB:business_master_new
loadtime:0.90735411643982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:0.90740394592285 / seconds
Query Executed:select id FROM `mi` where city='Eagle' && SIC_code='5461'DB:business_master_new
loadtime:0.90795707702637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Harbor' limit 1
loadtime:0.90800404548645 / seconds
Query Executed:select id FROM `mi` where city='Eagle Harbor' && SIC_code='5461'DB:business_master_new
loadtime:0.90858697891235 / seconds
Query loaded from cache:select * from geodata_geocity where city='East China' limit 1
loadtime:0.90861511230469 / seconds
Query Executed:select id FROM `mi` where city='East China' && SIC_code='5461'DB:business_master_new
loadtime:0.90924096107483 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Jordan' limit 1
loadtime:0.9092869758606 / seconds
Query Executed:select id FROM `mi` where city='East Jordan' && SIC_code='5461'DB:business_master_new
loadtime:0.90994906425476 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lansing' limit 1
loadtime:0.90999603271484 / seconds
Query Executed:select id FROM `mi` where city='East Lansing' && SIC_code='5461'DB:business_master_new
loadtime:0.91584396362305 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Leroy' limit 1
loadtime:0.91588997840881 / seconds
Query Executed:select id FROM `mi` where city='East Leroy' && SIC_code='5461'DB:business_master_new
loadtime:0.92020797729492 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Tawas' limit 1
loadtime:0.920254945755 / seconds
Query Executed:select id FROM `mi` where city='East Tawas' && SIC_code='5461'DB:business_master_new
loadtime:0.92152214050293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastlake' limit 1
loadtime:0.92155694961548 / seconds
Query Executed:select id FROM `mi` where city='Eastlake' && SIC_code='5461'DB:business_master_new
loadtime:0.9219491481781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastpointe' limit 1
loadtime:0.92198801040649 / seconds
Query Executed:select id FROM `mi` where city='Eastpointe' && SIC_code='5461'DB:business_master_new
loadtime:0.9230329990387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastport' limit 1
loadtime:0.92307901382446 / seconds
Query Executed:select id FROM `mi` where city='Eastport' && SIC_code='5461'DB:business_master_new
loadtime:0.92587113380432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Rapids' limit 1
loadtime:0.92591404914856 / seconds
Query Executed:select id FROM `mi` where city='Eaton Rapids' && SIC_code='5461'DB:business_master_new
loadtime:0.92665815353394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Claire' limit 1
loadtime:0.92670392990112 / seconds
Query Executed:select id FROM `mi` where city='Eau Claire' && SIC_code='5461'DB:business_master_new
loadtime:0.92725706100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eben Junction' limit 1
loadtime:0.92728400230408 / seconds
Query Executed:select id FROM `mi` where city='Eben Junction' && SIC_code='5461'DB:business_master_new
loadtime:0.92843508720398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckerman' limit 1
loadtime:0.92847108840942 / seconds
Query Executed:select id FROM `mi` where city='Eckerman' && SIC_code='5461'DB:business_master_new
loadtime:0.92983794212341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecorse' limit 1
loadtime:0.92986297607422 / seconds
Query Executed:select id FROM `mi` where city='Ecorse' && SIC_code='5461'DB:business_master_new
loadtime:0.93039703369141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenville' limit 1
loadtime:0.93043208122253 / seconds
Query Executed:select id FROM `mi` where city='Edenville' && SIC_code='5461'DB:business_master_new
loadtime:0.93173003196716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmore' limit 1
loadtime:0.93175506591797 / seconds
Query Executed:select id FROM `mi` where city='Edmore' && SIC_code='5461'DB:business_master_new
loadtime:0.93233394622803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsburg' limit 1
loadtime:0.93236899375916 / seconds
Query Executed:select id FROM `mi` where city='Edwardsburg' && SIC_code='5461'DB:business_master_new
loadtime:0.933021068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:0.93305397033691 / seconds
Query Executed:select id FROM `mi` where city='Elberta' && SIC_code='5461'DB:business_master_new
loadtime:0.9348349571228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Rapids' limit 1
loadtime:0.93487095832825 / seconds
Query Executed:select id FROM `mi` where city='Elk Rapids' && SIC_code='5461'DB:business_master_new
loadtime:0.93549013137817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.93552994728088 / seconds
Query Executed:select id FROM `mi` where city='Elkton' && SIC_code='5461'DB:business_master_new
loadtime:0.93609094619751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.936115026474 / seconds
Query Executed:select id FROM `mi` where city='Ellsworth' && SIC_code='5461'DB:business_master_new
loadtime:0.93664407730103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Hall' limit 1
loadtime:0.93667793273926 / seconds
Query Executed:select id FROM `mi` where city='Elm Hall' && SIC_code='5461'DB:business_master_new
loadtime:0.93759894371033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmira' limit 1
loadtime:0.93762302398682 / seconds
Query Executed:select id FROM `mi` where city='Elmira' && SIC_code='5461'DB:business_master_new
loadtime:0.94126200675964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsie' limit 1
loadtime:0.94130897521973 / seconds
Query Executed:select id FROM `mi` where city='Elsie' && SIC_code='5461'DB:business_master_new
loadtime:0.94190812110901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwell' limit 1
loadtime:0.94194293022156 / seconds
Query Executed:select id FROM `mi` where city='Elwell' && SIC_code='5461'DB:business_master_new
loadtime:0.94660997390747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmett' limit 1
loadtime:0.94665598869324 / seconds
Query Executed:select id FROM `mi` where city='Emmett' && SIC_code='5461'DB:business_master_new
loadtime:0.94721603393555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:0.947261095047 / seconds
Query Executed:select id FROM `mi` where city='Empire' && SIC_code='5461'DB:business_master_new
loadtime:0.94789695739746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engadine' limit 1
loadtime:0.94794011116028 / seconds
Query Executed:select id FROM `mi` where city='Engadine' && SIC_code='5461'DB:business_master_new
loadtime:0.95315098762512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:0.95319700241089 / seconds
Query Executed:select id FROM `mi` where city='Erie' && SIC_code='5461'DB:business_master_new
loadtime:0.95384097099304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escanaba' limit 1
loadtime:0.95388793945312 / seconds
Query Executed:select id FROM `mi` where city='Escanaba' && SIC_code='5461'DB:business_master_new
loadtime:0.95488595962524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essexville' limit 1
loadtime:0.95493102073669 / seconds
Query Executed:select id FROM `mi` where city='Essexville' && SIC_code='5461'DB:business_master_new
loadtime:0.9556131362915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.95566701889038 / seconds
Query Executed:select id FROM `mi` where city='Eureka' && SIC_code='5461'DB:business_master_new
loadtime:0.95633006095886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evart' limit 1
loadtime:0.95637392997742 / seconds
Query Executed:select id FROM `mi` where city='Evart' && SIC_code='5461'DB:business_master_new
loadtime:0.95701813697815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewen' limit 1
loadtime:0.95706009864807 / seconds
Query Executed:select id FROM `mi` where city='Ewen' && SIC_code='5461'DB:business_master_new
loadtime:0.95840001106262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.95844697952271 / seconds
Query Executed:select id FROM `mi` where city='Fair Haven' && SIC_code='5461'DB:business_master_new
loadtime:0.95905613899231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairgrove' limit 1
loadtime:0.95909905433655 / seconds
Query Executed:select id FROM `mi` where city='Fairgrove' && SIC_code='5461'DB:business_master_new
loadtime:0.96578693389893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.96583294868469 / seconds
Query Executed:select id FROM `mi` where city='Fairview' && SIC_code='5461'DB:business_master_new
loadtime:0.9664249420166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.96647214889526 / seconds
Query Executed:select id FROM `mi` where city='Falmouth' && SIC_code='5461'DB:business_master_new
loadtime:0.97051310539246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fargo' limit 1
loadtime:0.9705491065979 / seconds
Query Executed:select id FROM `mi` where city='Fargo' && SIC_code='5461'DB:business_master_new
loadtime:0.97079992294312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.9708399772644 / seconds
Query Executed:select id FROM `mi` where city='Farmington' && SIC_code='5461'DB:business_master_new
loadtime:0.97666192054749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington Hills' limit 1
loadtime:0.97672700881958 / seconds
Query Executed:select id FROM `mi` where city='Farmington Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.97732400894165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farwell' limit 1
loadtime:0.9773690700531 / seconds
Query Executed:select id FROM `mi` where city='Farwell' && SIC_code='5461'DB:business_master_new
loadtime:0.97798204421997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Felch' limit 1
loadtime:0.97801613807678 / seconds
Query Executed:select id FROM `mi` where city='Felch' && SIC_code='5461'DB:business_master_new
loadtime:0.98328709602356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fennville' limit 1
loadtime:0.98333406448364 / seconds
Query Executed:select id FROM `mi` where city='Fennville' && SIC_code='5461'DB:business_master_new
loadtime:0.98399901390076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:0.98404002189636 / seconds
Query Executed:select id FROM `mi` where city='Fenton' && SIC_code='5461'DB:business_master_new
loadtime:0.98515200614929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwick' limit 1
loadtime:0.98518896102905 / seconds
Query Executed:select id FROM `mi` where city='Fenwick' && SIC_code='5461'DB:business_master_new
loadtime:0.99253511428833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferndale' limit 1
loadtime:0.99258494377136 / seconds
Query Executed:select id FROM `mi` where city='Ferndale' && SIC_code='5461'DB:business_master_new
loadtime:0.99360203742981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrysburg' limit 1
loadtime:0.99364900588989 / seconds
Query Executed:select id FROM `mi` where city='Ferrysburg' && SIC_code='5461'DB:business_master_new
loadtime:0.99692296981812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife Lake' limit 1
loadtime:0.9969699382782 / seconds
Query Executed:select id FROM `mi` where city='Fife Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.99753904342651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filer City' limit 1
loadtime:0.99756693840027 / seconds
Query Executed:select id FROM `mi` where city='Filer City' && SIC_code='5461'DB:business_master_new
loadtime:0.99809813499451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filion' limit 1
loadtime:0.99814414978027 / seconds
Query Executed:select id FROM `mi` where city='Filion' && SIC_code='5461'DB:business_master_new
loadtime:0.99982905387878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:0.99987602233887 / seconds
Query Executed:select id FROM `mi` where city='Flat Rock' && SIC_code='5461'DB:business_master_new
loadtime:1.0004811286926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint' limit 1
loadtime:1.0005090236664 / seconds
Query Executed:select id FROM `mi` where city='Flint' && SIC_code='5461'DB:business_master_new
loadtime:1.0062839984894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flushing' limit 1
loadtime:1.0063519477844 / seconds
Query Executed:select id FROM `mi` where city='Flushing' && SIC_code='5461'DB:business_master_new
loadtime:1.0072319507599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestville' limit 1
loadtime:1.0072751045227 / seconds
Query Executed:select id FROM `mi` where city='Forestville' && SIC_code='5461'DB:business_master_new
loadtime:1.0083360671997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Gratiot' limit 1
loadtime:1.0083830356598 / seconds
Query Executed:select id FROM `mi` where city='Fort Gratiot' && SIC_code='5461'DB:business_master_new
loadtime:1.0093159675598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster City' limit 1
loadtime:1.0093591213226 / seconds
Query Executed:select id FROM `mi` where city='Foster City' && SIC_code='5461'DB:business_master_new
loadtime:1.014876127243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:1.0149281024933 / seconds
Query Executed:select id FROM `mi` where city='Fostoria' && SIC_code='5461'DB:business_master_new
loadtime:1.020348072052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:1.020406961441 / seconds
Query Executed:select id FROM `mi` where city='Fountain' && SIC_code='5461'DB:business_master_new
loadtime:1.025367975235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:1.025416135788 / seconds
Query Executed:select id FROM `mi` where city='Fowler' && SIC_code='5461'DB:business_master_new
loadtime:1.0260291099548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowlerville' limit 1
loadtime:1.0260760784149 / seconds
Query Executed:select id FROM `mi` where city='Fowlerville' && SIC_code='5461'DB:business_master_new
loadtime:1.0268490314484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankenmuth' limit 1
loadtime:1.0268840789795 / seconds
Query Executed:select id FROM `mi` where city='Frankenmuth' && SIC_code='5461'DB:business_master_new
loadtime:1.0276050567627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:1.0276560783386 / seconds
Query Executed:select id FROM `mi` where city='Frankfort' && SIC_code='5461'DB:business_master_new
loadtime:1.0283160209656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.0283679962158 / seconds
Query Executed:select id FROM `mi` where city='Franklin' && SIC_code='5461'DB:business_master_new
loadtime:1.0293769836426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraser' limit 1
loadtime:1.0294301509857 / seconds
Query Executed:select id FROM `mi` where city='Fraser' && SIC_code='5461'DB:business_master_new
loadtime:1.0302619934082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederic' limit 1
loadtime:1.0303089618683 / seconds
Query Executed:select id FROM `mi` where city='Frederic' && SIC_code='5461'DB:business_master_new
loadtime:1.0364460945129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Soil' limit 1
loadtime:1.0364890098572 / seconds
Query Executed:select id FROM `mi` where city='Free Soil' && SIC_code='5461'DB:business_master_new
loadtime:1.042573928833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeland' limit 1
loadtime:1.0426239967346 / seconds
Query Executed:select id FROM `mi` where city='Freeland' && SIC_code='5461'DB:business_master_new
loadtime:1.043340921402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeport' limit 1
loadtime:1.0433759689331 / seconds
Query Executed:select id FROM `mi` where city='Freeport' && SIC_code='5461'DB:business_master_new
loadtime:1.0480530261993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:1.0480909347534 / seconds
Query Executed:select id FROM `mi` where city='Fremont' && SIC_code='5461'DB:business_master_new
loadtime:1.0488829612732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frontier' limit 1
loadtime:1.0489201545715 / seconds
Query Executed:select id FROM `mi` where city='Frontier' && SIC_code='5461'DB:business_master_new
loadtime:1.0500459671021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitport' limit 1
loadtime:1.0500810146332 / seconds
Query Executed:select id FROM `mi` where city='Fruitport' && SIC_code='5461'DB:business_master_new
loadtime:1.0507619380951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:1.0507969856262 / seconds
Query Executed:select id FROM `mi` where city='Fulton' && SIC_code='5461'DB:business_master_new
loadtime:1.052444934845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaastra' limit 1
loadtime:1.0524699687958 / seconds
Query Executed:select id FROM `mi` where city='Gaastra' && SIC_code='5461'DB:business_master_new
loadtime:1.0540449619293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gagetown' limit 1
loadtime:1.0540771484375 / seconds
Query Executed:select id FROM `mi` where city='Gagetown' && SIC_code='5461'DB:business_master_new
loadtime:1.0583219528198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaines' limit 1
loadtime:1.0583469867706 / seconds
Query Executed:select id FROM `mi` where city='Gaines' && SIC_code='5461'DB:business_master_new
loadtime:1.0588829517365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesburg' limit 1
loadtime:1.0589170455933 / seconds
Query Executed:select id FROM `mi` where city='Galesburg' && SIC_code='5461'DB:business_master_new
loadtime:1.0595009326935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galien' limit 1
loadtime:1.05952501297 / seconds
Query Executed:select id FROM `mi` where city='Galien' && SIC_code='5461'DB:business_master_new
loadtime:1.0673720836639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden' limit 1
loadtime:1.0674369335175 / seconds
Query Executed:select id FROM `mi` where city='Garden' && SIC_code='5461'DB:business_master_new
loadtime:1.0701451301575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:1.0701811313629 / seconds
Query Executed:select id FROM `mi` where city='Garden City' && SIC_code='5461'DB:business_master_new
loadtime:1.070855140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylord' limit 1
loadtime:1.0708899497986 / seconds
Query Executed:select id FROM `mi` where city='Gaylord' && SIC_code='5461'DB:business_master_new
loadtime:1.0716149806976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genesee' limit 1
loadtime:1.0716400146484 / seconds
Query Executed:select id FROM `mi` where city='Genesee' && SIC_code='5461'DB:business_master_new
loadtime:1.0783071517944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germfask' limit 1
loadtime:1.0783669948578 / seconds
Query Executed:select id FROM `mi` where city='Germfask' && SIC_code='5461'DB:business_master_new
loadtime:1.08016705513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:1.0802171230316 / seconds
Query Executed:select id FROM `mi` where city='Gilford' && SIC_code='5461'DB:business_master_new
loadtime:1.0815141201019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.0815529823303 / seconds
Query Executed:select id FROM `mi` where city='Gladstone' && SIC_code='5461'DB:business_master_new
loadtime:1.0822110176086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladwin' limit 1
loadtime:1.0822470188141 / seconds
Query Executed:select id FROM `mi` where city='Gladwin' && SIC_code='5461'DB:business_master_new
loadtime:1.0830459594727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Arbor' limit 1
loadtime:1.0830929279327 / seconds
Query Executed:select id FROM `mi` where city='Glen Arbor' && SIC_code='5461'DB:business_master_new
loadtime:1.0836849212646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn' limit 1
loadtime:1.0837280750275 / seconds
Query Executed:select id FROM `mi` where city='Glenn' && SIC_code='5461'DB:business_master_new
loadtime:1.0848231315613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glennie' limit 1
loadtime:1.0848701000214 / seconds
Query Executed:select id FROM `mi` where city='Glennie' && SIC_code='5461'DB:business_master_new
loadtime:1.0932869911194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gobles' limit 1
loadtime:1.0933220386505 / seconds
Query Executed:select id FROM `mi` where city='Gobles' && SIC_code='5461'DB:business_master_new
loadtime:1.0939469337463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goetzville' limit 1
loadtime:1.0939869880676 / seconds
Query Executed:select id FROM `mi` where city='Goetzville' && SIC_code='5461'DB:business_master_new
loadtime:1.0968351364136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Good Hart' limit 1
loadtime:1.0968749523163 / seconds
Query Executed:select id FROM `mi` where city='Good Hart' && SIC_code='5461'DB:business_master_new
loadtime:1.0973589420319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodells' limit 1
loadtime:1.0973999500275 / seconds
Query Executed:select id FROM `mi` where city='Goodells' && SIC_code='5461'DB:business_master_new
loadtime:1.0979549884796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodrich' limit 1
loadtime:1.0979909896851 / seconds
Query Executed:select id FROM `mi` where city='Goodrich' && SIC_code='5461'DB:business_master_new
loadtime:1.098592042923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gould City' limit 1
loadtime:1.0986361503601 / seconds
Query Executed:select id FROM `mi` where city='Gould City' && SIC_code='5461'DB:business_master_new
loadtime:1.1032750606537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowen' limit 1
loadtime:1.1033101081848 / seconds
Query Executed:select id FROM `mi` where city='Gowen' && SIC_code='5461'DB:business_master_new
loadtime:1.1205229759216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Beach' limit 1
loadtime:1.1206090450287 / seconds
Query Executed:select id FROM `mi` where city='Grand Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.1209931373596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Blanc' limit 1
loadtime:1.1210279464722 / seconds
Query Executed:select id FROM `mi` where city='Grand Blanc' && SIC_code='5461'DB:business_master_new
loadtime:1.122251033783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Haven' limit 1
loadtime:1.1223139762878 / seconds
Query Executed:select id FROM `mi` where city='Grand Haven' && SIC_code='5461'DB:business_master_new
loadtime:1.1234700679779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:1.1235139369965 / seconds
Query Executed:select id FROM `mi` where city='Grand Junction' && SIC_code='5461'DB:business_master_new
loadtime:1.1366670131683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Ledge' limit 1
loadtime:1.1367321014404 / seconds
Query Executed:select id FROM `mi` where city='Grand Ledge' && SIC_code='5461'DB:business_master_new
loadtime:1.1376459598541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Marais' limit 1
loadtime:1.1376929283142 / seconds
Query Executed:select id FROM `mi` where city='Grand Marais' && SIC_code='5461'DB:business_master_new
loadtime:1.14359998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Rapids' limit 1
loadtime:1.143651008606 / seconds
Query Executed:select id FROM `mi` where city='Grand Rapids' && SIC_code='5461'DB:business_master_new
loadtime:1.1495790481567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandville' limit 1
loadtime:1.1496541500092 / seconds
Query Executed:select id FROM `mi` where city='Grandville' && SIC_code='5461'DB:business_master_new
loadtime:1.1507980823517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:1.1508541107178 / seconds
Query Executed:select id FROM `mi` where city='Grant' && SIC_code='5461'DB:business_master_new
loadtime:1.1514499187469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant Twp' limit 1
loadtime:1.1514859199524 / seconds
Query Executed:select id FROM `mi` where city='Grant Twp' && SIC_code='5461'DB:business_master_new
loadtime:1.1517169475555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grass Lake' limit 1
loadtime:1.1517570018768 / seconds
Query Executed:select id FROM `mi` where city='Grass Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.1523990631104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grawn' limit 1
loadtime:1.1524360179901 / seconds
Query Executed:select id FROM `mi` where city='Grawn' && SIC_code='5461'DB:business_master_new
loadtime:1.1530029773712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grayling' limit 1
loadtime:1.1530499458313 / seconds
Query Executed:select id FROM `mi` where city='Grayling' && SIC_code='5461'DB:business_master_new
loadtime:1.1538290977478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.153872013092 / seconds
Query Executed:select id FROM `mi` where city='Greenbush' && SIC_code='5461'DB:business_master_new
loadtime:1.1609230041504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:1.160975933075 / seconds
Query Executed:select id FROM `mi` where city='Greenland' && SIC_code='5461'DB:business_master_new
loadtime:1.1612720489502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.161306142807 / seconds
Query Executed:select id FROM `mi` where city='Greenville' && SIC_code='5461'DB:business_master_new
loadtime:1.1621870994568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.1622440814972 / seconds
Query Executed:select id FROM `mi` where city='Greenwood' && SIC_code='5461'DB:business_master_new
loadtime:1.1625299453735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:1.1625671386719 / seconds
Query Executed:select id FROM `mi` where city='Gregory' && SIC_code='5461'DB:business_master_new
loadtime:1.1631519794464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Ile' limit 1
loadtime:1.1631870269775 / seconds
Query Executed:select id FROM `mi` where city='Grosse Ile' && SIC_code='5461'DB:business_master_new
loadtime:1.163859128952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pointe' limit 1
loadtime:1.1639070510864 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pointe' && SIC_code='5461'DB:business_master_new
loadtime:1.1648781299591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Farms' limit 1
loadtime:1.1649129390717 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Farms' && SIC_code='5461'DB:business_master_new
loadtime:1.1652569770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Park' limit 1
loadtime:1.1652979850769 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Park' && SIC_code='5461'DB:business_master_new
loadtime:1.1655919551849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Woods' limit 1
loadtime:1.1656270027161 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Woods' && SIC_code='5461'DB:business_master_new
loadtime:1.1659359931946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulliver' limit 1
loadtime:1.1659710407257 / seconds
Query Executed:select id FROM `mi` where city='Gulliver' && SIC_code='5461'DB:business_master_new
loadtime:1.1672329902649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwinn' limit 1
loadtime:1.1672811508179 / seconds
Query Executed:select id FROM `mi` where city='Gwinn' && SIC_code='5461'DB:business_master_new
loadtime:1.1679229736328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:1.1679589748383 / seconds
Query Executed:select id FROM `mi` where city='Hadley' && SIC_code='5461'DB:business_master_new
loadtime:1.1715710163116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagar Shores' limit 1
loadtime:1.1716201305389 / seconds
Query Executed:select id FROM `mi` where city='Hagar Shores' && SIC_code='5461'DB:business_master_new
loadtime:1.1719360351562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hale' limit 1
loadtime:1.1719801425934 / seconds
Query Executed:select id FROM `mi` where city='Hale' && SIC_code='5461'DB:business_master_new
loadtime:1.1725881099701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:1.1726250648499 / seconds
Query Executed:select id FROM `mi` where city='Hamburg' && SIC_code='5461'DB:business_master_new
loadtime:1.1731569766998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.1732001304626 / seconds
Query Executed:select id FROM `mi` where city='Hamilton' && SIC_code='5461'DB:business_master_new
loadtime:1.1738450527191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamtramck' limit 1
loadtime:1.1738801002502 / seconds
Query Executed:select id FROM `mi` where city='Hamtramck' && SIC_code='5461'DB:business_master_new
loadtime:1.1744771003723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.1745181083679 / seconds
Query Executed:select id FROM `mi` where city='Hancock' && SIC_code='5461'DB:business_master_new
loadtime:1.1751890182495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.1752319335938 / seconds
Query Executed:select id FROM `mi` where city='Hanover' && SIC_code='5461'DB:business_master_new
loadtime:1.1758029460907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbert' limit 1
loadtime:1.1758511066437 / seconds
Query Executed:select id FROM `mi` where city='Harbert' && SIC_code='5461'DB:business_master_new
loadtime:1.1780569553375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Beach' limit 1
loadtime:1.1781029701233 / seconds
Query Executed:select id FROM `mi` where city='Harbor Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.1787431240082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Springs' limit 1
loadtime:1.1787779331207 / seconds
Query Executed:select id FROM `mi` where city='Harbor Springs' && SIC_code='5461'DB:business_master_new
loadtime:1.1796081066132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper Woods' limit 1
loadtime:1.1796650886536 / seconds
Query Executed:select id FROM `mi` where city='Harper Woods' && SIC_code='5461'DB:business_master_new
loadtime:1.1802799701691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrietta' limit 1
loadtime:1.1803150177002 / seconds
Query Executed:select id FROM `mi` where city='Harrietta' && SIC_code='5461'DB:business_master_new
loadtime:1.1818749904633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:1.1819241046906 / seconds
Query Executed:select id FROM `mi` where city='Harris' && SIC_code='5461'DB:business_master_new
loadtime:1.1838419437408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:1.1838879585266 / seconds
Query Executed:select id FROM `mi` where city='Harrison' && SIC_code='5461'DB:business_master_new
loadtime:1.1846170425415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Township' limit 1
loadtime:1.1846449375153 / seconds
Query Executed:select id FROM `mi` where city='Harrison Township' && SIC_code='5461'DB:business_master_new
loadtime:1.1855149269104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Twp' limit 1
loadtime:1.1855700016022 / seconds
Query Executed:select id FROM `mi` where city='Harrison Twp' && SIC_code='5461'DB:business_master_new
loadtime:1.1874029636383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:1.1874389648438 / seconds
Query Executed:select id FROM `mi` where city='Harrisville' && SIC_code='5461'DB:business_master_new
loadtime:1.1881160736084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harsens Island' limit 1
loadtime:1.1881721019745 / seconds
Query Executed:select id FROM `mi` where city='Harsens Island' && SIC_code='5461'DB:business_master_new
loadtime:1.1943171024323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hart' limit 1
loadtime:1.1943669319153 / seconds
Query Executed:select id FROM `mi` where city='Hart' && SIC_code='5461'DB:business_master_new
loadtime:1.1950769424438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.195111989975 / seconds
Query Executed:select id FROM `mi` where city='Hartford' && SIC_code='5461'DB:business_master_new
loadtime:1.1957890987396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:1.1958429813385 / seconds
Query Executed:select id FROM `mi` where city='Hartland' && SIC_code='5461'DB:business_master_new
loadtime:1.1965000629425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:1.196545124054 / seconds
Query Executed:select id FROM `mi` where city='Harvey' && SIC_code='5461'DB:business_master_new
loadtime:1.1967959403992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haslett' limit 1
loadtime:1.1968219280243 / seconds
Query Executed:select id FROM `mi` where city='Haslett' && SIC_code='5461'DB:business_master_new
loadtime:1.1975090503693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:1.1975440979004 / seconds
Query Executed:select id FROM `mi` where city='Hastings' && SIC_code='5461'DB:business_master_new
loadtime:1.198401927948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawks' limit 1
loadtime:1.1984460353851 / seconds
Query Executed:select id FROM `mi` where city='Hawks' && SIC_code='5461'DB:business_master_new
loadtime:1.2002060413361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Park' limit 1
loadtime:1.2002551555634 / seconds
Query Executed:select id FROM `mi` where city='Hazel Park' && SIC_code='5461'DB:business_master_new
loadtime:1.2013580799103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemlock' limit 1
loadtime:1.2014141082764 / seconds
Query Executed:select id FROM `mi` where city='Hemlock' && SIC_code='5461'DB:business_master_new
loadtime:1.2020161151886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:1.2020630836487 / seconds
Query Executed:select id FROM `mi` where city='Henderson' && SIC_code='5461'DB:business_master_new
loadtime:1.2057039737701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermansville' limit 1
loadtime:1.2057499885559 / seconds
Query Executed:select id FROM `mi` where city='Hermansville' && SIC_code='5461'DB:business_master_new
loadtime:1.2086200714111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herron' limit 1
loadtime:1.2086670398712 / seconds
Query Executed:select id FROM `mi` where city='Herron' && SIC_code='5461'DB:business_master_new
loadtime:1.2134821414948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hersey' limit 1
loadtime:1.2135169506073 / seconds
Query Executed:select id FROM `mi` where city='Hersey' && SIC_code='5461'DB:business_master_new
loadtime:1.2170650959015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesperia' limit 1
loadtime:1.2171039581299 / seconds
Query Executed:select id FROM `mi` where city='Hesperia' && SIC_code='5461'DB:business_master_new
loadtime:1.2176721096039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hessel' limit 1
loadtime:1.217698097229 / seconds
Query Executed:select id FROM `mi` where city='Hessel' && SIC_code='5461'DB:business_master_new
loadtime:1.2219700813293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Corners' limit 1
loadtime:1.2220189571381 / seconds
Query Executed:select id FROM `mi` where city='Hickory Corners' && SIC_code='5461'DB:business_master_new
loadtime:1.2361130714417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higgins Lake' limit 1
loadtime:1.2361559867859 / seconds
Query Executed:select id FROM `mi` where city='Higgins Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.2378299236298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:1.2378740310669 / seconds
Query Executed:select id FROM `mi` where city='Highland' && SIC_code='5461'DB:business_master_new
loadtime:1.2387199401855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Park' limit 1
loadtime:1.2387671470642 / seconds
Query Executed:select id FROM `mi` where city='Highland Park' && SIC_code='5461'DB:business_master_new
loadtime:1.239401102066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillman' limit 1
loadtime:1.2394270896912 / seconds
Query Executed:select id FROM `mi` where city='Hillman' && SIC_code='5461'DB:business_master_new
loadtime:1.2465929985046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:1.2466311454773 / seconds
Query Executed:select id FROM `mi` where city='Hillsdale' && SIC_code='5461'DB:business_master_new
loadtime:1.2474701404572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.2475070953369 / seconds
Query Executed:select id FROM `mi` where city='Holland' && SIC_code='5461'DB:business_master_new
loadtime:1.2533609867096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly' limit 1
loadtime:1.2534141540527 / seconds
Query Executed:select id FROM `mi` where city='Holly' && SIC_code='5461'DB:business_master_new
loadtime:1.2542290687561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holt' limit 1
loadtime:1.2542700767517 / seconds
Query Executed:select id FROM `mi` where city='Holt' && SIC_code='5461'DB:business_master_new
loadtime:1.2550220489502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holton' limit 1
loadtime:1.255056142807 / seconds
Query Executed:select id FROM `mi` where city='Holton' && SIC_code='5461'DB:business_master_new
loadtime:1.2556200027466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homer' limit 1
loadtime:1.2556610107422 / seconds
Query Executed:select id FROM `mi` where city='Homer' && SIC_code='5461'DB:business_master_new
loadtime:1.2562310695648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honor' limit 1
loadtime:1.2562551498413 / seconds
Query Executed:select id FROM `mi` where city='Honor' && SIC_code='5461'DB:business_master_new
loadtime:1.2567999362946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:1.2568330764771 / seconds
Query Executed:select id FROM `mi` where city='Hope' && SIC_code='5461'DB:business_master_new
loadtime:1.2612299919128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:1.2612631320953 / seconds
Query Executed:select id FROM `mi` where city='Hopkins' && SIC_code='5461'DB:business_master_new
loadtime:1.2618489265442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horton' limit 1
loadtime:1.2618820667267 / seconds
Query Executed:select id FROM `mi` where city='Horton' && SIC_code='5461'DB:business_master_new
loadtime:1.262414932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:1.2624380588531 / seconds
Query Executed:select id FROM `mi` where city='Houghton' && SIC_code='5461'DB:business_master_new
loadtime:1.2631261348724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake' limit 1
loadtime:1.2631659507751 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.2638731002808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake Heights' limit 1
loadtime:1.2639081478119 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake Heights' && SIC_code='5461'DB:business_master_new
loadtime:1.264524936676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard City' limit 1
loadtime:1.2645499706268 / seconds
Query Executed:select id FROM `mi` where city='Howard City' && SIC_code='5461'DB:business_master_new
loadtime:1.2651391029358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:1.2651710510254 / seconds
Query Executed:select id FROM `mi` where city='Howell' && SIC_code='5461'DB:business_master_new
loadtime:1.2707340717316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard Lake' limit 1
loadtime:1.2707679271698 / seconds
Query Executed:select id FROM `mi` where city='Hubbard Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.2712690830231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.271301984787 / seconds
Query Executed:select id FROM `mi` where city='Hubbardston' && SIC_code='5461'DB:business_master_new
loadtime:1.2779490947723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbell' limit 1
loadtime:1.2779779434204 / seconds
Query Executed:select id FROM `mi` where city='Hubbell' && SIC_code='5461'DB:business_master_new
loadtime:1.2824051380157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.2824511528015 / seconds
Query Executed:select id FROM `mi` where city='Hudson' && SIC_code='5461'DB:business_master_new
loadtime:1.2830920219421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudsonville' limit 1
loadtime:1.2831220626831 / seconds
Query Executed:select id FROM `mi` where city='Hudsonville' && SIC_code='5461'DB:business_master_new
loadtime:1.2840321063995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hulbert' limit 1
loadtime:1.2840700149536 / seconds
Query Executed:select id FROM `mi` where city='Hulbert' && SIC_code='5461'DB:business_master_new
loadtime:1.2860591411591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington Woods' limit 1
loadtime:1.2860929965973 / seconds
Query Executed:select id FROM `mi` where city='Huntington Woods' && SIC_code='5461'DB:business_master_new
loadtime:1.2867360115051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida' limit 1
loadtime:1.2867691516876 / seconds
Query Executed:select id FROM `mi` where city='Ida' && SIC_code='5461'DB:business_master_new
loadtime:1.2872989177704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idlewild' limit 1
loadtime:1.2873220443726 / seconds
Query Executed:select id FROM `mi` where city='Idlewild' && SIC_code='5461'DB:business_master_new
loadtime:1.2890250682831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imlay City' limit 1
loadtime:1.2890570163727 / seconds
Query Executed:select id FROM `mi` where city='Imlay City' && SIC_code='5461'DB:business_master_new
loadtime:1.2897629737854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian River' limit 1
loadtime:1.2897930145264 / seconds
Query Executed:select id FROM `mi` where city='Indian River' && SIC_code='5461'DB:business_master_new
loadtime:1.2904231548309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingalls' limit 1
loadtime:1.290461063385 / seconds
Query Executed:select id FROM `mi` where city='Ingalls' && SIC_code='5461'DB:business_master_new
loadtime:1.2909510135651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inkster' limit 1
loadtime:1.2909750938416 / seconds
Query Executed:select id FROM `mi` where city='Inkster' && SIC_code='5461'DB:business_master_new
loadtime:1.2915930747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interlochen' limit 1
loadtime:1.2916269302368 / seconds
Query Executed:select id FROM `mi` where city='Interlochen' && SIC_code='5461'DB:business_master_new
loadtime:1.2922389507294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:1.292268037796 / seconds
Query Executed:select id FROM `mi` where city='Ionia' && SIC_code='5461'DB:business_master_new
loadtime:1.293035030365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:1.2930579185486 / seconds
Query Executed:select id FROM `mi` where city='Ira' && SIC_code='5461'DB:business_master_new
loadtime:1.2933239936829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Mountain' limit 1
loadtime:1.2933559417725 / seconds
Query Executed:select id FROM `mi` where city='Iron Mountain' && SIC_code='5461'DB:business_master_new
loadtime:1.2942450046539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron River' limit 1
loadtime:1.2942831516266 / seconds
Query Executed:select id FROM `mi` where city='Iron River' && SIC_code='5461'DB:business_master_new
loadtime:1.2949619293213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irons' limit 1
loadtime:1.2949919700623 / seconds
Query Executed:select id FROM `mi` where city='Irons' && SIC_code='5461'DB:business_master_new
loadtime:1.3063659667969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironwood' limit 1
loadtime:1.3064439296722 / seconds
Query Executed:select id FROM `mi` where city='Ironwood' && SIC_code='5461'DB:business_master_new
loadtime:1.3072891235352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ishpeming' limit 1
loadtime:1.3073239326477 / seconds
Query Executed:select id FROM `mi` where city='Ishpeming' && SIC_code='5461'DB:business_master_new
loadtime:1.3080739974976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ithaca' limit 1
loadtime:1.3081130981445 / seconds
Query Executed:select id FROM `mi` where city='Ithaca' && SIC_code='5461'DB:business_master_new
loadtime:1.3087840080261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.3088250160217 / seconds
Query Executed:select id FROM `mi` where city='Jackson' && SIC_code='5461'DB:business_master_new
loadtime:1.3147010803223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.3147349357605 / seconds
Query Executed:select id FROM `mi` where city='Jamestown' && SIC_code='5461'DB:business_master_new
loadtime:1.3167240619659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jasper' limit 1
loadtime:1.3167569637299 / seconds
Query Executed:select id FROM `mi` where city='Jasper' && SIC_code='5461'DB:business_master_new
loadtime:1.3199770450592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeddo' limit 1
loadtime:1.32000207901 / seconds
Query Executed:select id FROM `mi` where city='Jeddo' && SIC_code='5461'DB:business_master_new
loadtime:1.3260691165924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenison' limit 1
loadtime:1.3261060714722 / seconds
Query Executed:select id FROM `mi` where city='Jenison' && SIC_code='5461'DB:business_master_new
loadtime:1.327005147934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:1.3270449638367 / seconds
Query Executed:select id FROM `mi` where city='Jerome' && SIC_code='5461'DB:business_master_new
loadtime:1.3325660228729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johannesburg' limit 1
loadtime:1.3325910568237 / seconds
Query Executed:select id FROM `mi` where city='Johannesburg' && SIC_code='5461'DB:business_master_new
loadtime:1.3366739749908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jones' limit 1
loadtime:1.3367080688477 / seconds
Query Executed:select id FROM `mi` where city='Jones' && SIC_code='5461'DB:business_master_new
loadtime:1.3409070968628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:1.3409581184387 / seconds
Query Executed:select id FROM `mi` where city='Jonesville' && SIC_code='5461'DB:business_master_new
loadtime:1.3415961265564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalamazoo' limit 1
loadtime:1.3416409492493 / seconds
Query Executed:select id FROM `mi` where city='Kalamazoo' && SIC_code='5461'DB:business_master_new
loadtime:1.3474249839783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaleva' limit 1
loadtime:1.3474869728088 / seconds
Query Executed:select id FROM `mi` where city='Kaleva' && SIC_code='5461'DB:business_master_new
loadtime:1.3583700656891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalkaska' limit 1
loadtime:1.3584229946136 / seconds
Query Executed:select id FROM `mi` where city='Kalkaska' && SIC_code='5461'DB:business_master_new
loadtime:1.3591990470886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Karlin' limit 1
loadtime:1.359246969223 / seconds
Query Executed:select id FROM `mi` where city='Karlin' && SIC_code='5461'DB:business_master_new
loadtime:1.3595230579376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kawkawlin' limit 1
loadtime:1.3595499992371 / seconds
Query Executed:select id FROM `mi` where city='Kawkawlin' && SIC_code='5461'DB:business_master_new
loadtime:1.3601820468903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:1.360228061676 / seconds
Query Executed:select id FROM `mi` where city='Kearsarge' && SIC_code='5461'DB:business_master_new
loadtime:1.36048412323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keego Harbor' limit 1
loadtime:1.3605120182037 / seconds
Query Executed:select id FROM `mi` where city='Keego Harbor' && SIC_code='5461'DB:business_master_new
loadtime:1.361212015152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:1.3612680435181 / seconds
Query Executed:select id FROM `mi` where city='Kendall' && SIC_code='5461'DB:business_master_new
loadtime:1.3615570068359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenockee' limit 1
loadtime:1.3615851402283 / seconds
Query Executed:select id FROM `mi` where city='Kenockee' && SIC_code='5461'DB:business_master_new
loadtime:1.3618140220642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent City' limit 1
loadtime:1.3618490695953 / seconds
Query Executed:select id FROM `mi` where city='Kent City' && SIC_code='5461'DB:business_master_new
loadtime:1.3624079227448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kentwood' limit 1
loadtime:1.3624451160431 / seconds
Query Executed:select id FROM `mi` where city='Kentwood' && SIC_code='5461'DB:business_master_new
loadtime:1.3644189834595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewadin' limit 1
loadtime:1.3644671440125 / seconds
Query Executed:select id FROM `mi` where city='Kewadin' && SIC_code='5461'DB:business_master_new
loadtime:1.3650851249695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keweenaw Bay' limit 1
loadtime:1.3651249408722 / seconds
Query Executed:select id FROM `mi` where city='Keweenaw Bay' && SIC_code='5461'DB:business_master_new
loadtime:1.3662059307098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:1.3662519454956 / seconds
Query Executed:select id FROM `mi` where city='Kimball' && SIC_code='5461'DB:business_master_new
loadtime:1.3668501377106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kincheloe' limit 1
loadtime:1.3668849468231 / seconds
Query Executed:select id FROM `mi` where city='Kincheloe' && SIC_code='5461'DB:business_master_new
loadtime:1.3674130439758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinde' limit 1
loadtime:1.3674521446228 / seconds
Query Executed:select id FROM `mi` where city='Kinde' && SIC_code='5461'DB:business_master_new
loadtime:1.3791079521179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsford' limit 1
loadtime:1.3791470527649 / seconds
Query Executed:select id FROM `mi` where city='Kingsford' && SIC_code='5461'DB:business_master_new
loadtime:1.3798151016235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:1.3798680305481 / seconds
Query Executed:select id FROM `mi` where city='Kingsley' && SIC_code='5461'DB:business_master_new
loadtime:1.3805069923401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.3805429935455 / seconds
Query Executed:select id FROM `mi` where city='Kingston' && SIC_code='5461'DB:business_master_new
loadtime:1.3810589313507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:1.381089925766 / seconds
Query Executed:select id FROM `mi` where city='Kinross' && SIC_code='5461'DB:business_master_new
loadtime:1.3842880725861 / seconds
Query loaded from cache:select * from geodata_geocity where city='L Anse' limit 1
loadtime:1.384318113327 / seconds
Query Executed:select id FROM `mi` where city='L Anse' && SIC_code='5461'DB:business_master_new
loadtime:1.385635137558 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Salle' limit 1
loadtime:1.3856730461121 / seconds
Query Executed:select id FROM `mi` where city='La Salle' && SIC_code='5461'DB:business_master_new
loadtime:1.3862099647522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lachine' limit 1
loadtime:1.386234998703 / seconds
Query Executed:select id FROM `mi` where city='Lachine' && SIC_code='5461'DB:business_master_new
loadtime:1.3936200141907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacota' limit 1
loadtime:1.3936610221863 / seconds
Query Executed:select id FROM `mi` where city='Lacota' && SIC_code='5461'DB:business_master_new
loadtime:1.3940269947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laingsburg' limit 1
loadtime:1.3940529823303 / seconds
Query Executed:select id FROM `mi` where city='Laingsburg' && SIC_code='5461'DB:business_master_new
loadtime:1.3946590423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:1.3946940898895 / seconds
Query Executed:select id FROM `mi` where city='Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.3952331542969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Angelus' limit 1
loadtime:1.3952569961548 / seconds
Query Executed:select id FROM `mi` where city='Lake Angelus' && SIC_code='5461'DB:business_master_new
loadtime:1.3955321311951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Ann' limit 1
loadtime:1.3955659866333 / seconds
Query Executed:select id FROM `mi` where city='Lake Ann' && SIC_code='5461'DB:business_master_new
loadtime:1.3961119651794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:1.3961420059204 / seconds
Query Executed:select id FROM `mi` where city='Lake City' && SIC_code='5461'DB:business_master_new
loadtime:1.3967809677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake George' limit 1
loadtime:1.3968150615692 / seconds
Query Executed:select id FROM `mi` where city='Lake George' && SIC_code='5461'DB:business_master_new
loadtime:1.3997371196747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Leelanau' limit 1
loadtime:1.3997831344604 / seconds
Query Executed:select id FROM `mi` where city='Lake Leelanau' && SIC_code='5461'DB:business_master_new
loadtime:1.4006900787354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Linden' limit 1
loadtime:1.4007151126862 / seconds
Query Executed:select id FROM `mi` where city='Lake Linden' && SIC_code='5461'DB:business_master_new
loadtime:1.4014511108398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Odessa' limit 1
loadtime:1.4014840126038 / seconds
Query Executed:select id FROM `mi` where city='Lake Odessa' && SIC_code='5461'DB:business_master_new
loadtime:1.4020910263062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Orion' limit 1
loadtime:1.4021220207214 / seconds
Query Executed:select id FROM `mi` where city='Lake Orion' && SIC_code='5461'DB:business_master_new
loadtime:1.4032030105591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeland' limit 1
loadtime:1.4032480716705 / seconds
Query Executed:select id FROM `mi` where city='Lakeland' && SIC_code='5461'DB:business_master_new
loadtime:1.4080281257629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeport' limit 1
loadtime:1.4080641269684 / seconds
Query Executed:select id FROM `mi` where city='Lakeport' && SIC_code='5461'DB:business_master_new
loadtime:1.4083120822906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:1.4083359241486 / seconds
Query Executed:select id FROM `mi` where city='Lakeside' && SIC_code='5461'DB:business_master_new
loadtime:1.4116499423981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:1.4116840362549 / seconds
Query Executed:select id FROM `mi` where city='Lakeview' && SIC_code='5461'DB:business_master_new
loadtime:1.4123151302338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.4123449325562 / seconds
Query Executed:select id FROM `mi` where city='Lakeville' && SIC_code='5461'DB:business_master_new
loadtime:1.41339802742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambertville' limit 1
loadtime:1.4134230613708 / seconds
Query Executed:select id FROM `mi` where city='Lambertville' && SIC_code='5461'DB:business_master_new
loadtime:1.414057970047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:1.4140899181366 / seconds
Query Executed:select id FROM `mi` where city='Lamont' && SIC_code='5461'DB:business_master_new
loadtime:1.4143469333649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanse' limit 1
loadtime:1.4143710136414 / seconds
Query Executed:select id FROM `mi` where city='Lanse' && SIC_code='5461'DB:business_master_new
loadtime:1.4149479866028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:1.4149799346924 / seconds
Query Executed:select id FROM `mi` where city='Lansing' && SIC_code='5461'DB:business_master_new
loadtime:1.4208390712738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapeer' limit 1
loadtime:1.4208791255951 / seconds
Query Executed:select id FROM `mi` where city='Lapeer' && SIC_code='5461'DB:business_master_new
loadtime:1.4219510555267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lathrup Village' limit 1
loadtime:1.4219920635223 / seconds
Query Executed:select id FROM `mi` where city='Lathrup Village' && SIC_code='5461'DB:business_master_new
loadtime:1.4235320091248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurium' limit 1
loadtime:1.4235651493073 / seconds
Query Executed:select id FROM `mi` where city='Laurium' && SIC_code='5461'DB:business_master_new
loadtime:1.4239521026611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.4239771366119 / seconds
Query Executed:select id FROM `mi` where city='Lawrence' && SIC_code='5461'DB:business_master_new
loadtime:1.4245600700378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:1.4246001243591 / seconds
Query Executed:select id FROM `mi` where city='Lawton' && SIC_code='5461'DB:business_master_new
loadtime:1.4251670837402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Roy' limit 1
loadtime:1.4251909255981 / seconds
Query Executed:select id FROM `mi` where city='Le Roy' && SIC_code='5461'DB:business_master_new
loadtime:1.4254519939423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:1.4254839420319 / seconds
Query Executed:select id FROM `mi` where city='Leland' && SIC_code='5461'DB:business_master_new
loadtime:1.4260251522064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennon' limit 1
loadtime:1.4260530471802 / seconds
Query Executed:select id FROM `mi` where city='Lennon' && SIC_code='5461'DB:business_master_new
loadtime:1.4381511211395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.4382131099701 / seconds
Query Executed:select id FROM `mi` where city='Lenox' && SIC_code='5461'DB:business_master_new
loadtime:1.4392459392548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonard' limit 1
loadtime:1.4392809867859 / seconds
Query Executed:select id FROM `mi` where city='Leonard' && SIC_code='5461'DB:business_master_new
loadtime:1.4399139881134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonidas' limit 1
loadtime:1.439954996109 / seconds
Query Executed:select id FROM `mi` where city='Leonidas' && SIC_code='5461'DB:business_master_new
loadtime:1.4410209655762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leroy' limit 1
loadtime:1.4410469532013 / seconds
Query Executed:select id FROM `mi` where city='Leroy' && SIC_code='5461'DB:business_master_new
loadtime:1.4500880241394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leslie' limit 1
loadtime:1.4501421451569 / seconds
Query Executed:select id FROM `mi` where city='Leslie' && SIC_code='5461'DB:business_master_new
loadtime:1.4508039951324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levering' limit 1
loadtime:1.4508619308472 / seconds
Query Executed:select id FROM `mi` where city='Levering' && SIC_code='5461'DB:business_master_new
loadtime:1.4593989849091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:1.4594531059265 / seconds
Query Executed:select id FROM `mi` where city='Lewiston' && SIC_code='5461'DB:business_master_new
loadtime:1.4674220085144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.4674680233002 / seconds
Query Executed:select id FROM `mi` where city='Lexington' && SIC_code='5461'DB:business_master_new
loadtime:1.4681510925293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limestone' limit 1
loadtime:1.4681899547577 / seconds
Query Executed:select id FROM `mi` where city='Limestone' && SIC_code='5461'DB:business_master_new
loadtime:1.4684381484985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.4684770107269 / seconds
Query Executed:select id FROM `mi` where city='Lincoln' && SIC_code='5461'DB:business_master_new
loadtime:1.4689950942993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln Park' limit 1
loadtime:1.4690251350403 / seconds
Query Executed:select id FROM `mi` where city='Lincoln Park' && SIC_code='5461'DB:business_master_new
loadtime:1.4696891307831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:1.469712972641 / seconds
Query Executed:select id FROM `mi` where city='Linden' && SIC_code='5461'DB:business_master_new
loadtime:1.4703669548035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.4704110622406 / seconds
Query Executed:select id FROM `mi` where city='Linwood' && SIC_code='5461'DB:business_master_new
loadtime:1.4709701538086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:1.470999956131 / seconds
Query Executed:select id FROM `mi` where city='Litchfield' && SIC_code='5461'DB:business_master_new
loadtime:1.4715509414673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Lake' limit 1
loadtime:1.4715869426727 / seconds
Query Executed:select id FROM `mi` where city='Little Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.4730861186981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livonia' limit 1
loadtime:1.473119020462 / seconds
Query Executed:select id FROM `mi` where city='Livonia' && SIC_code='5461'DB:business_master_new
loadtime:1.4789440631866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Lake' limit 1
loadtime:1.4789760112762 / seconds
Query Executed:select id FROM `mi` where city='Long Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.4805951118469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:1.4806289672852 / seconds
Query Executed:select id FROM `mi` where city='Loretto' && SIC_code='5461'DB:business_master_new
loadtime:1.4809069633484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.4809370040894 / seconds
Query Executed:select id FROM `mi` where city='Lowell' && SIC_code='5461'DB:business_master_new
loadtime:1.481684923172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludington' limit 1
loadtime:1.481714963913 / seconds
Query Executed:select id FROM `mi` where city='Ludington' && SIC_code='5461'DB:business_master_new
loadtime:1.4826390743256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna Pier' limit 1
loadtime:1.482677936554 / seconds
Query Executed:select id FROM `mi` where city='Luna Pier' && SIC_code='5461'DB:business_master_new
loadtime:1.4867150783539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:1.486741065979 / seconds
Query Executed:select id FROM `mi` where city='Lupton' && SIC_code='5461'DB:business_master_new
loadtime:1.4905581474304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:1.4905910491943 / seconds
Query Executed:select id FROM `mi` where city='Luther' && SIC_code='5461'DB:business_master_new
loadtime:1.4955129623413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:1.4955480098724 / seconds
Query Executed:select id FROM `mi` where city='Luzerne' && SIC_code='5461'DB:business_master_new
loadtime:1.4981501102448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.4981980323792 / seconds
Query Executed:select id FROM `mi` where city='Lynn' && SIC_code='5461'DB:business_master_new
loadtime:1.4984619617462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:1.4984900951385 / seconds
Query Executed:select id FROM `mi` where city='Lyons' && SIC_code='5461'DB:business_master_new
loadtime:1.5068681240082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macatawa' limit 1
loadtime:1.5069150924683 / seconds
Query Executed:select id FROM `mi` where city='Macatawa' && SIC_code='5461'DB:business_master_new
loadtime:1.5104761123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinac Island' limit 1
loadtime:1.5105259418488 / seconds
Query Executed:select id FROM `mi` where city='Mackinac Island' && SIC_code='5461'DB:business_master_new
loadtime:1.5111529827118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinaw City' limit 1
loadtime:1.5111880302429 / seconds
Query Executed:select id FROM `mi` where city='Mackinaw City' && SIC_code='5461'DB:business_master_new
loadtime:1.511871099472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macomb' limit 1
loadtime:1.5119321346283 / seconds
Query Executed:select id FROM `mi` where city='Macomb' && SIC_code='5461'DB:business_master_new
loadtime:1.5130181312561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:1.5130751132965 / seconds
Query Executed:select id FROM `mi` where city='Madison Heights' && SIC_code='5461'DB:business_master_new
loadtime:1.5143160820007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mancelona' limit 1
loadtime:1.5143611431122 / seconds
Query Executed:select id FROM `mi` where city='Mancelona' && SIC_code='5461'DB:business_master_new
loadtime:1.5150279998779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.5150821208954 / seconds
Query Executed:select id FROM `mi` where city='Manchester' && SIC_code='5461'DB:business_master_new
loadtime:1.5156879425049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistee' limit 1
loadtime:1.5157339572906 / seconds
Query Executed:select id FROM `mi` where city='Manistee' && SIC_code='5461'DB:business_master_new
loadtime:1.5165691375732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistique' limit 1
loadtime:1.5166120529175 / seconds
Query Executed:select id FROM `mi` where city='Manistique' && SIC_code='5461'DB:business_master_new
loadtime:1.5172049999237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitou Beach' limit 1
loadtime:1.5172519683838 / seconds
Query Executed:select id FROM `mi` where city='Manitou Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.517853975296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manton' limit 1
loadtime:1.5178971290588 / seconds
Query Executed:select id FROM `mi` where city='Manton' && SIC_code='5461'DB:business_master_new
loadtime:1.5184669494629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple City' limit 1
loadtime:1.5185070037842 / seconds
Query Executed:select id FROM `mi` where city='Maple City' && SIC_code='5461'DB:business_master_new
loadtime:1.5190589427948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Rapids' limit 1
loadtime:1.5191030502319 / seconds
Query Executed:select id FROM `mi` where city='Maple Rapids' && SIC_code='5461'DB:business_master_new
loadtime:1.5216319561005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcellus' limit 1
loadtime:1.5216679573059 / seconds
Query Executed:select id FROM `mi` where city='Marcellus' && SIC_code='5461'DB:business_master_new
loadtime:1.5222549438477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marenisco' limit 1
loadtime:1.5223009586334 / seconds
Query Executed:select id FROM `mi` where city='Marenisco' && SIC_code='5461'DB:business_master_new
loadtime:1.5257539749146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marine City' limit 1
loadtime:1.52578997612 / seconds
Query Executed:select id FROM `mi` where city='Marine City' && SIC_code='5461'DB:business_master_new
loadtime:1.5264980792999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.5265560150146 / seconds
Query Executed:select id FROM `mi` where city='Marion' && SIC_code='5461'DB:business_master_new
loadtime:1.5271639823914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlette' limit 1
loadtime:1.5272080898285 / seconds
Query Executed:select id FROM `mi` where city='Marlette' && SIC_code='5461'DB:business_master_new
loadtime:1.5279250144958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:1.5279610157013 / seconds
Query Executed:select id FROM `mi` where city='Marne' && SIC_code='5461'DB:business_master_new
loadtime:1.5285289287567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:1.5285680294037 / seconds
Query Executed:select id FROM `mi` where city='Marquette' && SIC_code='5461'DB:business_master_new
loadtime:1.5297989845276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:1.5298590660095 / seconds
Query Executed:select id FROM `mi` where city='Marshall' && SIC_code='5461'DB:business_master_new
loadtime:1.5307171344757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:1.5307619571686 / seconds
Query Executed:select id FROM `mi` where city='Martin' && SIC_code='5461'DB:business_master_new
loadtime:1.5313241481781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysville' limit 1
loadtime:1.5313711166382 / seconds
Query Executed:select id FROM `mi` where city='Marysville' && SIC_code='5461'DB:business_master_new
loadtime:1.5321280956268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:1.5321850776672 / seconds
Query Executed:select id FROM `mi` where city='Mason' && SIC_code='5461'DB:business_master_new
loadtime:1.5330679416656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mass City' limit 1
loadtime:1.5331120491028 / seconds
Query Executed:select id FROM `mi` where city='Mass City' && SIC_code='5461'DB:business_master_new
loadtime:1.5344891548157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattawan' limit 1
loadtime:1.5345370769501 / seconds
Query Executed:select id FROM `mi` where city='Mattawan' && SIC_code='5461'DB:business_master_new
loadtime:1.5351951122284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybee' limit 1
loadtime:1.5352299213409 / seconds
Query Executed:select id FROM `mi` where city='Maybee' && SIC_code='5461'DB:business_master_new
loadtime:1.5358021259308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:1.5358510017395 / seconds
Query Executed:select id FROM `mi` where city='Mayfield' && SIC_code='5461'DB:business_master_new
loadtime:1.5365159511566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayville' limit 1
loadtime:1.5365509986877 / seconds
Query Executed:select id FROM `mi` where city='Mayville' && SIC_code='5461'DB:business_master_new
loadtime:1.5371279716492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bain' limit 1
loadtime:1.5371749401093 / seconds
Query Executed:select id FROM `mi` where city='Mc Bain' && SIC_code='5461'DB:business_master_new
loadtime:1.5377480983734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Millan' limit 1
loadtime:1.5377950668335 / seconds
Query Executed:select id FROM `mi` where city='Mc Millan' && SIC_code='5461'DB:business_master_new
loadtime:1.542060136795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcbrides' limit 1
loadtime:1.5421061515808 / seconds
Query Executed:select id FROM `mi` where city='Mcbrides' && SIC_code='5461'DB:business_master_new
loadtime:1.5434141159058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:1.5434610843658 / seconds
Query Executed:select id FROM `mi` where city='Mears' && SIC_code='5461'DB:business_master_new
loadtime:1.5440621376038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mecosta' limit 1
loadtime:1.5441129207611 / seconds
Query Executed:select id FROM `mi` where city='Mecosta' && SIC_code='5461'DB:business_master_new
loadtime:1.544723033905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:1.5447659492493 / seconds
Query Executed:select id FROM `mi` where city='Melvin' && SIC_code='5461'DB:business_master_new
loadtime:1.5485589504242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvindale' limit 1
loadtime:1.5486059188843 / seconds
Query Executed:select id FROM `mi` where city='Melvindale' && SIC_code='5461'DB:business_master_new
loadtime:1.5492520332336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Memphis' limit 1
loadtime:1.5492949485779 / seconds
Query Executed:select id FROM `mi` where city='Memphis' && SIC_code='5461'DB:business_master_new
loadtime:1.5499079227448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:1.5499551296234 / seconds
Query Executed:select id FROM `mi` where city='Mendon' && SIC_code='5461'DB:business_master_new
loadtime:1.5567500591278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menominee' limit 1
loadtime:1.5567851066589 / seconds
Query Executed:select id FROM `mi` where city='Menominee' && SIC_code='5461'DB:business_master_new
loadtime:1.5575499534607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:1.5576050281525 / seconds
Query Executed:select id FROM `mi` where city='Merrill' && SIC_code='5461'DB:business_master_new
loadtime:1.5581750869751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:1.5582101345062 / seconds
Query Executed:select id FROM `mi` where city='Merritt' && SIC_code='5461'DB:business_master_new
loadtime:1.5607800483704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesick' limit 1
loadtime:1.5608279705048 / seconds
Query Executed:select id FROM `mi` where city='Mesick' && SIC_code='5461'DB:business_master_new
loadtime:1.5614149570465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metamora' limit 1
loadtime:1.5614619255066 / seconds
Query Executed:select id FROM `mi` where city='Metamora' && SIC_code='5461'DB:business_master_new
loadtime:1.5621120929718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michiana' limit 1
loadtime:1.5621471405029 / seconds
Query Executed:select id FROM `mi` where city='Michiana' && SIC_code='5461'DB:business_master_new
loadtime:1.5623841285706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigamme' limit 1
loadtime:1.5624389648438 / seconds
Query Executed:select id FROM `mi` where city='Michigamme' && SIC_code='5461'DB:business_master_new
loadtime:1.5679171085358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan Center' limit 1
loadtime:1.5679531097412 / seconds
Query Executed:select id FROM `mi` where city='Michigan Center' && SIC_code='5461'DB:business_master_new
loadtime:1.5685529708862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.5685999393463 / seconds
Query Executed:select id FROM `mi` where city='Middleton' && SIC_code='5461'DB:business_master_new
loadtime:1.5743849277496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleville' limit 1
loadtime:1.5744421482086 / seconds
Query Executed:select id FROM `mi` where city='Middleville' && SIC_code='5461'DB:business_master_new
loadtime:1.5751399993896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:1.5751950740814 / seconds
Query Executed:select id FROM `mi` where city='Midland' && SIC_code='5461'DB:business_master_new
loadtime:1.5810980796814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikado' limit 1
loadtime:1.5811579227448 / seconds
Query Executed:select id FROM `mi` where city='Mikado' && SIC_code='5461'DB:business_master_new
loadtime:1.5859000682831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:1.585951089859 / seconds
Query Executed:select id FROM `mi` where city='Milan' && SIC_code='5461'DB:business_master_new
loadtime:1.586550951004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.5865859985352 / seconds
Query Executed:select id FROM `mi` where city='Milford' && SIC_code='5461'DB:business_master_new
loadtime:1.5874760150909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:1.5875310897827 / seconds
Query Executed:select id FROM `mi` where city='Millersburg' && SIC_code='5461'DB:business_master_new
loadtime:1.5928869247437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millington' limit 1
loadtime:1.5929219722748 / seconds
Query Executed:select id FROM `mi` where city='Millington' && SIC_code='5461'DB:business_master_new
loadtime:1.5935750007629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden City' limit 1
loadtime:1.593621969223 / seconds
Query Executed:select id FROM `mi` where city='Minden City' && SIC_code='5461'DB:business_master_new
loadtime:1.5986390113831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mio' limit 1
loadtime:1.5986740589142 / seconds
Query Executed:select id FROM `mi` where city='Mio' && SIC_code='5461'DB:business_master_new
loadtime:1.5993299484253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohawk' limit 1
loadtime:1.5993850231171 / seconds
Query Executed:select id FROM `mi` where city='Mohawk' && SIC_code='5461'DB:business_master_new
loadtime:1.603805065155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moline' limit 1
loadtime:1.6038520336151 / seconds
Query Executed:select id FROM `mi` where city='Moline' && SIC_code='5461'DB:business_master_new
loadtime:1.6068890094757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.606938123703 / seconds
Query Executed:select id FROM `mi` where city='Monroe' && SIC_code='5461'DB:business_master_new
loadtime:1.6126909255981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:1.6127390861511 / seconds
Query Executed:select id FROM `mi` where city='Montague' && SIC_code='5461'DB:business_master_new
loadtime:1.6133720874786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.613431930542 / seconds
Query Executed:select id FROM `mi` where city='Montgomery' && SIC_code='5461'DB:business_master_new
loadtime:1.61985206604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:1.6199021339417 / seconds
Query Executed:select id FROM `mi` where city='Montrose' && SIC_code='5461'DB:business_master_new
loadtime:1.6205761432648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moran' limit 1
loadtime:1.6206319332123 / seconds
Query Executed:select id FROM `mi` where city='Moran' && SIC_code='5461'DB:business_master_new
loadtime:1.6234369277954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:1.6234729290009 / seconds
Query Executed:select id FROM `mi` where city='Morenci' && SIC_code='5461'DB:business_master_new
loadtime:1.6240839958191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:1.6241331100464 / seconds
Query Executed:select id FROM `mi` where city='Morley' && SIC_code='5461'DB:business_master_new
loadtime:1.6313800811768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrice' limit 1
loadtime:1.6314489841461 / seconds
Query Executed:select id FROM `mi` where city='Morrice' && SIC_code='5461'DB:business_master_new
loadtime:1.6320469379425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:1.6320829391479 / seconds
Query Executed:select id FROM `mi` where city='Moscow' && SIC_code='5461'DB:business_master_new
loadtime:1.6325979232788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosherville' limit 1
loadtime:1.6326379776001 / seconds
Query Executed:select id FROM `mi` where city='Mosherville' && SIC_code='5461'DB:business_master_new
loadtime:1.6329710483551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Clemens' limit 1
loadtime:1.6330139636993 / seconds
Query Executed:select id FROM `mi` where city='Mount Clemens' && SIC_code='5461'DB:business_master_new
loadtime:1.6340351104736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Morris' limit 1
loadtime:1.6340789794922 / seconds
Query Executed:select id FROM `mi` where city='Mount Morris' && SIC_code='5461'DB:business_master_new
loadtime:1.6348700523376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:1.6349170207977 / seconds
Query Executed:select id FROM `mi` where city='Mount Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:1.6362340450287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Clemens' limit 1
loadtime:1.6362791061401 / seconds
Query Executed:select id FROM `mi` where city='Mt Clemens' && SIC_code='5461'DB:business_master_new
loadtime:1.6419520378113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Morris' limit 1
loadtime:1.642009973526 / seconds
Query Executed:select id FROM `mi` where city='Mt Morris' && SIC_code='5461'DB:business_master_new
loadtime:1.6427440643311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:1.6427791118622 / seconds
Query Executed:select id FROM `mi` where city='Mt Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:1.6497189998627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muir' limit 1
loadtime:1.6497669219971 / seconds
Query Executed:select id FROM `mi` where city='Muir' && SIC_code='5461'DB:business_master_new
loadtime:1.6530029773712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullett Lake' limit 1
loadtime:1.6530380249023 / seconds
Query Executed:select id FROM `mi` where city='Mullett Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.6533811092377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulliken' limit 1
loadtime:1.6534330844879 / seconds
Query Executed:select id FROM `mi` where city='Mulliken' && SIC_code='5461'DB:business_master_new
loadtime:1.6581079959869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munger' limit 1
loadtime:1.6581559181213 / seconds
Query Executed:select id FROM `mi` where city='Munger' && SIC_code='5461'DB:business_master_new
loadtime:1.6631691455841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munising' limit 1
loadtime:1.6632089614868 / seconds
Query Executed:select id FROM `mi` where city='Munising' && SIC_code='5461'DB:business_master_new
loadtime:1.6640131473541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munith' limit 1
loadtime:1.6640751361847 / seconds
Query Executed:select id FROM `mi` where city='Munith' && SIC_code='5461'DB:business_master_new
loadtime:1.6734309196472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon' limit 1
loadtime:1.6734750270844 / seconds
Query Executed:select id FROM `mi` where city='Muskegon' && SIC_code='5461'DB:business_master_new
loadtime:1.6793510913849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon Heights' limit 1
loadtime:1.6794281005859 / seconds
Query Executed:select id FROM `mi` where city='Muskegon Heights' && SIC_code='5461'DB:business_master_new
loadtime:1.6796960830688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mussey' limit 1
loadtime:1.6797239780426 / seconds
Query Executed:select id FROM `mi` where city='Mussey' && SIC_code='5461'DB:business_master_new
loadtime:1.6799931526184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nadeau' limit 1
loadtime:1.680025100708 / seconds
Query Executed:select id FROM `mi` where city='Nadeau' && SIC_code='5461'DB:business_master_new
loadtime:1.6812989711761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahma' limit 1
loadtime:1.6813349723816 / seconds
Query Executed:select id FROM `mi` where city='Nahma' && SIC_code='5461'DB:business_master_new
loadtime:1.6826510429382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Napoleon' limit 1
loadtime:1.6826989650726 / seconds
Query Executed:select id FROM `mi` where city='Napoleon' && SIC_code='5461'DB:business_master_new
loadtime:1.6900279521942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:1.6900799274445 / seconds
Query Executed:select id FROM `mi` where city='Nashville' && SIC_code='5461'DB:business_master_new
loadtime:1.6911470890045 / seconds
Query loaded from cache:select * from geodata_geocity where city='National City' limit 1
loadtime:1.6911940574646 / seconds
Query Executed:select id FROM `mi` where city='National City' && SIC_code='5461'DB:business_master_new
loadtime:1.6955149173737 / seconds
Query loaded from cache:select * from geodata_geocity where city='National Mine' limit 1
loadtime:1.6955499649048 / seconds
Query Executed:select id FROM `mi` where city='National Mine' && SIC_code='5461'DB:business_master_new
loadtime:1.6957881450653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naubinway' limit 1
loadtime:1.6958270072937 / seconds
Query Executed:select id FROM `mi` where city='Naubinway' && SIC_code='5461'DB:business_master_new
loadtime:1.7019951343536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazareth' limit 1
loadtime:1.7020299434662 / seconds
Query Executed:select id FROM `mi` where city='Nazareth' && SIC_code='5461'DB:business_master_new
loadtime:1.7029690742493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Negaunee' limit 1
loadtime:1.7030160427094 / seconds
Query Executed:select id FROM `mi` where city='Negaunee' && SIC_code='5461'DB:business_master_new
loadtime:1.7037250995636 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Baltimore' limit 1
loadtime:1.703782081604 / seconds
Query Executed:select id FROM `mi` where city='New Baltimore' && SIC_code='5461'DB:business_master_new
loadtime:1.7050189971924 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:1.705078125 / seconds
Query Executed:select id FROM `mi` where city='New Boston' && SIC_code='5461'DB:business_master_new
loadtime:1.7056341171265 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Buffalo' limit 1
loadtime:1.7056720256805 / seconds
Query Executed:select id FROM `mi` where city='New Buffalo' && SIC_code='5461'DB:business_master_new
loadtime:1.7063550949097 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Era' limit 1
loadtime:1.706414937973 / seconds
Query Executed:select id FROM `mi` where city='New Era' && SIC_code='5461'DB:business_master_new
loadtime:1.714448928833 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:1.7145011425018 / seconds
Query Executed:select id FROM `mi` where city='New Haven' && SIC_code='5461'DB:business_master_new
loadtime:1.7151601314545 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hudson' limit 1
loadtime:1.7152121067047 / seconds
Query Executed:select id FROM `mi` where city='New Hudson' && SIC_code='5461'DB:business_master_new
loadtime:1.7158920764923 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lothrop' limit 1
loadtime:1.7159390449524 / seconds
Query Executed:select id FROM `mi` where city='New Lothrop' && SIC_code='5461'DB:business_master_new
loadtime:1.7165069580078 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Troy' limit 1
loadtime:1.7165429592133 / seconds
Query Executed:select id FROM `mi` where city='New Troy' && SIC_code='5461'DB:business_master_new
loadtime:1.7176439762115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newaygo' limit 1
loadtime:1.7176921367645 / seconds
Query Executed:select id FROM `mi` where city='Newaygo' && SIC_code='5461'DB:business_master_new
loadtime:1.7184131145477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:1.7184479236603 / seconds
Query Executed:select id FROM `mi` where city='Newberry' && SIC_code='5461'DB:business_master_new
loadtime:1.7191181182861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.719172000885 / seconds
Query Executed:select id FROM `mi` where city='Newport' && SIC_code='5461'DB:business_master_new
loadtime:1.7197921276093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niles' limit 1
loadtime:1.7198269367218 / seconds
Query Executed:select id FROM `mi` where city='Niles' && SIC_code='5461'DB:business_master_new
loadtime:1.7209029197693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisula' limit 1
loadtime:1.7209579944611 / seconds
Query Executed:select id FROM `mi` where city='Nisula' && SIC_code='5461'DB:business_master_new
loadtime:1.7212650775909 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:1.7212920188904 / seconds
Query Executed:select id FROM `mi` where city='North Adams' && SIC_code='5461'DB:business_master_new
loadtime:1.7309949398041 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branch' limit 1
loadtime:1.73104596138 / seconds
Query Executed:select id FROM `mi` where city='North Branch' && SIC_code='5461'DB:business_master_new
loadtime:1.7317271232605 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Muskegon' limit 1
loadtime:1.7317929267883 / seconds
Query Executed:select id FROM `mi` where city='North Muskegon' && SIC_code='5461'DB:business_master_new
loadtime:1.7320730686188 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Star' limit 1
loadtime:1.7321000099182 / seconds
Query Executed:select id FROM `mi` where city='North Star' && SIC_code='5461'DB:business_master_new
loadtime:1.7331731319427 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Street' limit 1
loadtime:1.7332210540771 / seconds
Query Executed:select id FROM `mi` where city='North Street' && SIC_code='5461'DB:business_master_new
loadtime:1.733834028244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northport' limit 1
loadtime:1.7338690757751 / seconds
Query Executed:select id FROM `mi` where city='Northport' && SIC_code='5461'DB:business_master_new
loadtime:1.7344560623169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:1.7345111370087 / seconds
Query Executed:select id FROM `mi` where city='Northville' && SIC_code='5461'DB:business_master_new
loadtime:1.7352859973907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norvell' limit 1
loadtime:1.7353279590607 / seconds
Query Executed:select id FROM `mi` where city='Norvell' && SIC_code='5461'DB:business_master_new
loadtime:1.736405134201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:1.7364549636841 / seconds
Query Executed:select id FROM `mi` where city='Norway' && SIC_code='5461'DB:business_master_new
loadtime:1.737044095993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottawa' limit 1
loadtime:1.7370879650116 / seconds
Query Executed:select id FROM `mi` where city='Nottawa' && SIC_code='5461'DB:business_master_new
loadtime:1.738049030304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Novi' limit 1
loadtime:1.7380840778351 / seconds
Query Executed:select id FROM `mi` where city='Novi' && SIC_code='5461'DB:business_master_new
loadtime:1.74400806427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunica' limit 1
loadtime:1.7440650463104 / seconds
Query Executed:select id FROM `mi` where city='Nunica' && SIC_code='5461'DB:business_master_new
loadtime:1.7446939945221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Grove' limit 1
loadtime:1.7447440624237 / seconds
Query Executed:select id FROM `mi` where city='Oak Grove' && SIC_code='5461'DB:business_master_new
loadtime:1.745756149292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Park' limit 1
loadtime:1.7457909584045 / seconds
Query Executed:select id FROM `mi` where city='Oak Park' && SIC_code='5461'DB:business_master_new
loadtime:1.7470359802246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:1.7470960617065 / seconds
Query Executed:select id FROM `mi` where city='Oakland' && SIC_code='5461'DB:business_master_new
loadtime:1.7476949691772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland Twp' limit 1
loadtime:1.7477309703827 / seconds
Query Executed:select id FROM `mi` where city='Oakland Twp' && SIC_code='5461'DB:business_master_new
loadtime:1.7484600543976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:1.7485070228577 / seconds
Query Executed:select id FROM `mi` where city='Oakley' && SIC_code='5461'DB:business_master_new
loadtime:1.7557239532471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oden' limit 1
loadtime:1.7557599544525 / seconds
Query Executed:select id FROM `mi` where city='Oden' && SIC_code='5461'DB:business_master_new
loadtime:1.7568399906158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okemos' limit 1
loadtime:1.7568881511688 / seconds
Query Executed:select id FROM `mi` where city='Okemos' && SIC_code='5461'DB:business_master_new
loadtime:1.7580549716949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mission' limit 1
loadtime:1.7581119537354 / seconds
Query Executed:select id FROM `mi` where city='Old Mission' && SIC_code='5461'DB:business_master_new
loadtime:1.7602159976959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:1.7602510452271 / seconds
Query Executed:select id FROM `mi` where city='Olivet' && SIC_code='5461'DB:business_master_new
loadtime:1.760822057724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omena' limit 1
loadtime:1.7608621120453 / seconds
Query Executed:select id FROM `mi` where city='Omena' && SIC_code='5461'DB:business_master_new
loadtime:1.7620830535889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omer' limit 1
loadtime:1.7621121406555 / seconds
Query Executed:select id FROM `mi` where city='Omer' && SIC_code='5461'DB:business_master_new
loadtime:1.7684869766235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaway' limit 1
loadtime:1.7685270309448 / seconds
Query Executed:select id FROM `mi` where city='Onaway' && SIC_code='5461'DB:business_master_new
loadtime:1.7691099643707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onekama' limit 1
loadtime:1.7691359519958 / seconds
Query Executed:select id FROM `mi` where city='Onekama' && SIC_code='5461'DB:business_master_new
loadtime:1.7696931362152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onondaga' limit 1
loadtime:1.7697370052338 / seconds
Query Executed:select id FROM `mi` where city='Onondaga' && SIC_code='5461'DB:business_master_new
loadtime:1.7755870819092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onsted' limit 1
loadtime:1.7756159305573 / seconds
Query Executed:select id FROM `mi` where city='Onsted' && SIC_code='5461'DB:business_master_new
loadtime:1.7762401103973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontonagon' limit 1
loadtime:1.7762761116028 / seconds
Query Executed:select id FROM `mi` where city='Ontonagon' && SIC_code='5461'DB:business_master_new
loadtime:1.776801109314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard Lake' limit 1
loadtime:1.7768359184265 / seconds
Query Executed:select id FROM `mi` where city='Orchard Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.7770991325378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orion' limit 1
loadtime:1.7771229743958 / seconds
Query Executed:select id FROM `mi` where city='Orion' && SIC_code='5461'DB:business_master_new
loadtime:1.7776260375977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:1.7776601314545 / seconds
Query Executed:select id FROM `mi` where city='Orleans' && SIC_code='5461'DB:business_master_new
loadtime:1.7823269367218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortonville' limit 1
loadtime:1.7823519706726 / seconds
Query Executed:select id FROM `mi` where city='Ortonville' && SIC_code='5461'DB:business_master_new
loadtime:1.7830369472504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oscoda' limit 1
loadtime:1.7830710411072 / seconds
Query Executed:select id FROM `mi` where city='Oscoda' && SIC_code='5461'DB:business_master_new
loadtime:1.7837970256805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshtemo' limit 1
loadtime:1.7838289737701 / seconds
Query Executed:select id FROM `mi` where city='Oshtemo' && SIC_code='5461'DB:business_master_new
loadtime:1.7843260765076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osseo' limit 1
loadtime:1.7843599319458 / seconds
Query Executed:select id FROM `mi` where city='Osseo' && SIC_code='5461'DB:business_master_new
loadtime:1.784882068634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossineke' limit 1
loadtime:1.7849071025848 / seconds
Query Executed:select id FROM `mi` where city='Ossineke' && SIC_code='5461'DB:business_master_new
loadtime:1.7854080200195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otisville' limit 1
loadtime:1.7854409217834 / seconds
Query Executed:select id FROM `mi` where city='Otisville' && SIC_code='5461'DB:business_master_new
loadtime:1.7859809398651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otsego' limit 1
loadtime:1.7860109806061 / seconds
Query Executed:select id FROM `mi` where city='Otsego' && SIC_code='5461'DB:business_master_new
loadtime:1.7866439819336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottawa Lake' limit 1
loadtime:1.7866740226746 / seconds
Query Executed:select id FROM `mi` where city='Ottawa Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.7872149944305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otter Lake' limit 1
loadtime:1.787248134613 / seconds
Query Executed:select id FROM `mi` where city='Otter Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.7904150485992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovid' limit 1
loadtime:1.79044008255 / seconds
Query Executed:select id FROM `mi` where city='Ovid' && SIC_code='5461'DB:business_master_new
loadtime:1.791002035141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owendale' limit 1
loadtime:1.7910349369049 / seconds
Query Executed:select id FROM `mi` where city='Owendale' && SIC_code='5461'DB:business_master_new
loadtime:1.7948169708252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owosso' limit 1
loadtime:1.794842004776 / seconds
Query Executed:select id FROM `mi` where city='Owosso' && SIC_code='5461'DB:business_master_new
loadtime:1.7958920001984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.7959380149841 / seconds
Query Executed:select id FROM `mi` where city='Oxford' && SIC_code='5461'DB:business_master_new
loadtime:1.7968580722809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painesdale' limit 1
loadtime:1.7969160079956 / seconds
Query Executed:select id FROM `mi` where city='Painesdale' && SIC_code='5461'DB:business_master_new
loadtime:1.7987401485443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.7987749576569 / seconds
Query Executed:select id FROM `mi` where city='Palmer' && SIC_code='5461'DB:business_master_new
loadtime:1.7999200820923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palms' limit 1
loadtime:1.7999670505524 / seconds
Query Executed:select id FROM `mi` where city='Palms' && SIC_code='5461'DB:business_master_new
loadtime:1.8018860816956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:1.8019349575043 / seconds
Query Executed:select id FROM `mi` where city='Palmyra' && SIC_code='5461'DB:business_master_new
loadtime:1.8067541122437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:1.8068001270294 / seconds
Query Executed:select id FROM `mi` where city='Palo' && SIC_code='5461'DB:business_master_new
loadtime:1.8074491024017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:1.8074791431427 / seconds
Query Executed:select id FROM `mi` where city='Paradise' && SIC_code='5461'DB:business_master_new
loadtime:1.8138771057129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchment' limit 1
loadtime:1.8139300346375 / seconds
Query Executed:select id FROM `mi` where city='Parchment' && SIC_code='5461'DB:business_master_new
loadtime:1.8142220973969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:1.8142499923706 / seconds
Query Executed:select id FROM `mi` where city='Paris' && SIC_code='5461'DB:business_master_new
loadtime:1.8221919536591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parma' limit 1
loadtime:1.8222329616547 / seconds
Query Executed:select id FROM `mi` where city='Parma' && SIC_code='5461'DB:business_master_new
loadtime:1.8228490352631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Paw' limit 1
loadtime:1.8228850364685 / seconds
Query Executed:select id FROM `mi` where city='Paw Paw' && SIC_code='5461'DB:business_master_new
loadtime:1.823634147644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peck' limit 1
loadtime:1.8236720561981 / seconds
Query Executed:select id FROM `mi` where city='Peck' && SIC_code='5461'DB:business_master_new
loadtime:1.8282029628754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelkie' limit 1
loadtime:1.8282370567322 / seconds
Query Executed:select id FROM `mi` where city='Pelkie' && SIC_code='5461'DB:business_master_new
loadtime:1.8343319892883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pellston' limit 1
loadtime:1.8343760967255 / seconds
Query Executed:select id FROM `mi` where city='Pellston' && SIC_code='5461'DB:business_master_new
loadtime:1.8349440097809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pentwater' limit 1
loadtime:1.8349721431732 / seconds
Query Executed:select id FROM `mi` where city='Pentwater' && SIC_code='5461'DB:business_master_new
loadtime:1.8355669975281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkins' limit 1
loadtime:1.8356029987335 / seconds
Query Executed:select id FROM `mi` where city='Perkins' && SIC_code='5461'DB:business_master_new
loadtime:1.8370480537415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perrinton' limit 1
loadtime:1.8370859622955 / seconds
Query Executed:select id FROM `mi` where city='Perrinton' && SIC_code='5461'DB:business_master_new
loadtime:1.841078042984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perronville' limit 1
loadtime:1.8411259651184 / seconds
Query Executed:select id FROM `mi` where city='Perronville' && SIC_code='5461'DB:business_master_new
loadtime:1.8414080142975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:1.8414440155029 / seconds
Query Executed:select id FROM `mi` where city='Perry' && SIC_code='5461'DB:business_master_new
loadtime:1.8420729637146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:1.8421001434326 / seconds
Query Executed:select id FROM `mi` where city='Petersburg' && SIC_code='5461'DB:business_master_new
loadtime:1.842679977417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petoskey' limit 1
loadtime:1.8427169322968 / seconds
Query Executed:select id FROM `mi` where city='Petoskey' && SIC_code='5461'DB:business_master_new
loadtime:1.8438720703125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pewamo' limit 1
loadtime:1.8439149856567 / seconds
Query Executed:select id FROM `mi` where city='Pewamo' && SIC_code='5461'DB:business_master_new
loadtime:1.8489351272583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickford' limit 1
loadtime:1.8489761352539 / seconds
Query Executed:select id FROM `mi` where city='Pickford' && SIC_code='5461'DB:business_master_new
loadtime:1.8560140132904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:1.8560440540314 / seconds
Query Executed:select id FROM `mi` where city='Pierson' && SIC_code='5461'DB:business_master_new
loadtime:1.862517118454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pigeon' limit 1
loadtime:1.8625640869141 / seconds
Query Executed:select id FROM `mi` where city='Pigeon' && SIC_code='5461'DB:business_master_new
loadtime:1.8632681369781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinckney' limit 1
loadtime:1.8633060455322 / seconds
Query Executed:select id FROM `mi` where city='Pinckney' && SIC_code='5461'DB:business_master_new
loadtime:1.8641021251678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinconning' limit 1
loadtime:1.8641459941864 / seconds
Query Executed:select id FROM `mi` where city='Pinconning' && SIC_code='5461'DB:business_master_new
loadtime:1.864825963974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:1.8648679256439 / seconds
Query Executed:select id FROM `mi` where city='Pittsford' && SIC_code='5461'DB:business_master_new
loadtime:1.8721301555634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainwell' limit 1
loadtime:1.8721659183502 / seconds
Query Executed:select id FROM `mi` where city='Plainwell' && SIC_code='5461'DB:business_master_new
loadtime:1.8729779720306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Lake' limit 1
loadtime:1.8730330467224 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.8787970542908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Ridge' limit 1
loadtime:1.8788330554962 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Ridge' && SIC_code='5461'DB:business_master_new
loadtime:1.8793830871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.8794460296631 / seconds
Query Executed:select id FROM `mi` where city='Plymouth' && SIC_code='5461'DB:business_master_new
loadtime:1.8804161548615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pointe Aux Pins' limit 1
loadtime:1.88046002388 / seconds
Query Executed:select id FROM `mi` where city='Pointe Aux Pins' && SIC_code='5461'DB:business_master_new
loadtime:1.8818919658661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompeii' limit 1
loadtime:1.8819401264191 / seconds
Query Executed:select id FROM `mi` where city='Pompeii' && SIC_code='5461'DB:business_master_new
loadtime:1.8825740814209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontiac' limit 1
loadtime:1.8826220035553 / seconds
Query Executed:select id FROM `mi` where city='Pontiac' && SIC_code='5461'DB:business_master_new
loadtime:1.8885450363159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Austin' limit 1
loadtime:1.8886051177979 / seconds
Query Executed:select id FROM `mi` where city='Port Austin' && SIC_code='5461'DB:business_master_new
loadtime:1.8892290592194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Hope' limit 1
loadtime:1.8892719745636 / seconds
Query Executed:select id FROM `mi` where city='Port Hope' && SIC_code='5461'DB:business_master_new
loadtime:1.8986430168152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Huron' limit 1
loadtime:1.8986909389496 / seconds
Query Executed:select id FROM `mi` where city='Port Huron' && SIC_code='5461'DB:business_master_new
loadtime:1.9042930603027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Sanilac' limit 1
loadtime:1.9043390750885 / seconds
Query Executed:select id FROM `mi` where city='Port Sanilac' && SIC_code='5461'DB:business_master_new
loadtime:1.9049561023712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:1.9050099849701 / seconds
Query Executed:select id FROM `mi` where city='Portage' && SIC_code='5461'DB:business_master_new
loadtime:1.9104671478271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:1.9105260372162 / seconds
Query Executed:select id FROM `mi` where city='Portland' && SIC_code='5461'DB:business_master_new
loadtime:1.9112100601196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Posen' limit 1
loadtime:1.9112460613251 / seconds
Query Executed:select id FROM `mi` where city='Posen' && SIC_code='5461'DB:business_master_new
loadtime:1.9228019714355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potterville' limit 1
loadtime:1.9228639602661 / seconds
Query Executed:select id FROM `mi` where city='Potterville' && SIC_code='5461'DB:business_master_new
loadtime:1.9235169887543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers' limit 1
loadtime:1.92356300354 / seconds
Query Executed:select id FROM `mi` where city='Powers' && SIC_code='5461'DB:business_master_new
loadtime:1.9298830032349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:1.9299440383911 / seconds
Query Executed:select id FROM `mi` where city='Prescott' && SIC_code='5461'DB:business_master_new
loadtime:1.9305460453033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presque Isle' limit 1
loadtime:1.9305930137634 / seconds
Query Executed:select id FROM `mi` where city='Presque Isle' && SIC_code='5461'DB:business_master_new
loadtime:1.9365561008453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prudenville' limit 1
loadtime:1.9365930557251 / seconds
Query Executed:select id FROM `mi` where city='Prudenville' && SIC_code='5461'DB:business_master_new
loadtime:1.9371359348297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pullman' limit 1
loadtime:1.9371769428253 / seconds
Query Executed:select id FROM `mi` where city='Pullman' && SIC_code='5461'DB:business_master_new
loadtime:1.94646692276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:1.9465191364288 / seconds
Query Executed:select id FROM `mi` where city='Quincy' && SIC_code='5461'DB:business_master_new
loadtime:1.947142124176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinnesec' limit 1
loadtime:1.9471769332886 / seconds
Query Executed:select id FROM `mi` where city='Quinnesec' && SIC_code='5461'DB:business_master_new
loadtime:1.9518730640411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:1.9519200325012 / seconds
Query Executed:select id FROM `mi` where city='Ralph' && SIC_code='5461'DB:business_master_new
loadtime:1.9522860050201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramsay' limit 1
loadtime:1.9523220062256 / seconds
Query Executed:select id FROM `mi` where city='Ramsay' && SIC_code='5461'DB:business_master_new
loadtime:1.9546730518341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:1.9547200202942 / seconds
Query Executed:select id FROM `mi` where city='Rapid City' && SIC_code='5461'DB:business_master_new
loadtime:1.9553120136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid River' limit 1
loadtime:1.9553470611572 / seconds
Query Executed:select id FROM `mi` where city='Rapid River' && SIC_code='5461'DB:business_master_new
loadtime:1.9559321403503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenna' limit 1
loadtime:1.9559800624847 / seconds
Query Executed:select id FROM `mi` where city='Ravenna' && SIC_code='5461'DB:business_master_new
loadtime:1.9565601348877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ray' limit 1
loadtime:1.9565970897675 / seconds
Query Executed:select id FROM `mi` where city='Ray' && SIC_code='5461'DB:business_master_new
loadtime:1.9571650028229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:1.957200050354 / seconds
Query Executed:select id FROM `mi` where city='Reading' && SIC_code='5461'DB:business_master_new
loadtime:1.9577331542969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redford' limit 1
loadtime:1.9577739238739 / seconds
Query Executed:select id FROM `mi` where city='Redford' && SIC_code='5461'DB:business_master_new
loadtime:1.958603143692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reed City' limit 1
loadtime:1.9586639404297 / seconds
Query Executed:select id FROM `mi` where city='Reed City' && SIC_code='5461'DB:business_master_new
loadtime:1.9593319892883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reese' limit 1
loadtime:1.9593820571899 / seconds
Query Executed:select id FROM `mi` where city='Reese' && SIC_code='5461'DB:business_master_new
loadtime:1.9599781036377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remus' limit 1
loadtime:1.9600250720978 / seconds
Query Executed:select id FROM `mi` where city='Remus' && SIC_code='5461'DB:business_master_new
loadtime:1.9605870246887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republic' limit 1
loadtime:1.9606261253357 / seconds
Query Executed:select id FROM `mi` where city='Republic' && SIC_code='5461'DB:business_master_new
loadtime:1.966903924942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:1.9669411182404 / seconds
Query Executed:select id FROM `mi` where city='Rhodes' && SIC_code='5461'DB:business_master_new
loadtime:1.9712600708008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:1.9713051319122 / seconds
Query Executed:select id FROM `mi` where city='Richland' && SIC_code='5461'DB:business_master_new
loadtime:1.9720740318298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.9721300601959 / seconds
Query Executed:select id FROM `mi` where city='Richmond' && SIC_code='5461'DB:business_master_new
loadtime:1.9728610515594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richville' limit 1
loadtime:1.9729089736938 / seconds
Query Executed:select id FROM `mi` where city='Richville' && SIC_code='5461'DB:business_master_new
loadtime:1.9750850200653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riga' limit 1
loadtime:1.9751210212708 / seconds
Query Executed:select id FROM `mi` where city='Riga' && SIC_code='5461'DB:business_master_new
loadtime:1.9807579517365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riley' limit 1
loadtime:1.9808061122894 / seconds
Query Executed:select id FROM `mi` where city='Riley' && SIC_code='5461'DB:business_master_new
loadtime:1.9816241264343 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Rouge' limit 1
loadtime:1.9816710948944 / seconds
Query Executed:select id FROM `mi` where city='River Rouge' && SIC_code='5461'DB:business_master_new
loadtime:1.987694978714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:1.9877300262451 / seconds
Query Executed:select id FROM `mi` where city='Riverdale' && SIC_code='5461'DB:business_master_new
loadtime:1.9964370727539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:1.9964990615845 / seconds
Query Executed:select id FROM `mi` where city='Riverside' && SIC_code='5461'DB:business_master_new
loadtime:1.9975390434265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverview' limit 1
loadtime:1.9975800514221 / seconds
Query Executed:select id FROM `mi` where city='Riverview' && SIC_code='5461'DB:business_master_new
loadtime:1.9982500076294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rives Junction' limit 1
loadtime:1.9982979297638 / seconds
Query Executed:select id FROM `mi` where city='Rives Junction' && SIC_code='5461'DB:business_master_new
loadtime:2.0084409713745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.0084979534149 / seconds
Query Executed:select id FROM `mi` where city='Rochester' && SIC_code='5461'DB:business_master_new
loadtime:2.0144231319427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester Hills' limit 1
loadtime:2.0144801139832 / seconds
Query Executed:select id FROM `mi` where city='Rochester Hills' && SIC_code='5461'DB:business_master_new
loadtime:2.0205271244049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock' limit 1
loadtime:2.0205841064453 / seconds
Query Executed:select id FROM `mi` where city='Rock' && SIC_code='5461'DB:business_master_new
loadtime:2.0240080356598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:2.0240440368652 / seconds
Query Executed:select id FROM `mi` where city='Rockford' && SIC_code='5461'DB:business_master_new
loadtime:2.0251071453094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.025162935257 / seconds
Query Executed:select id FROM `mi` where city='Rockland' && SIC_code='5461'DB:business_master_new
loadtime:2.0259261131287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwood' limit 1
loadtime:2.0259730815887 / seconds
Query Executed:select id FROM `mi` where city='Rockwood' && SIC_code='5461'DB:business_master_new
loadtime:2.0268731117249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:2.0269110202789 / seconds
Query Executed:select id FROM `mi` where city='Rodney' && SIC_code='5461'DB:business_master_new
loadtime:2.0316920280457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers City' limit 1
loadtime:2.0317399501801 / seconds
Query Executed:select id FROM `mi` where city='Rogers City' && SIC_code='5461'DB:business_master_new
loadtime:2.0324349403381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollin' limit 1
loadtime:2.0324821472168 / seconds
Query Executed:select id FROM `mi` where city='Rollin' && SIC_code='5461'DB:business_master_new
loadtime:2.0327320098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romeo' limit 1
loadtime:2.03276014328 / seconds
Query Executed:select id FROM `mi` where city='Romeo' && SIC_code='5461'DB:business_master_new
loadtime:2.0335080623627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romulus' limit 1
loadtime:2.0335631370544 / seconds
Query Executed:select id FROM `mi` where city='Romulus' && SIC_code='5461'DB:business_master_new
loadtime:2.034245967865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscommon' limit 1
loadtime:2.0342810153961 / seconds
Query Executed:select id FROM `mi` where city='Roscommon' && SIC_code='5461'DB:business_master_new
loadtime:2.0348739624023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose City' limit 1
loadtime:2.0349130630493 / seconds
Query Executed:select id FROM `mi` where city='Rose City' && SIC_code='5461'DB:business_master_new
loadtime:2.0354731082916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebush' limit 1
loadtime:2.0355060100555 / seconds
Query Executed:select id FROM `mi` where city='Rosebush' && SIC_code='5461'DB:business_master_new
loadtime:2.0451381206512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseville' limit 1
loadtime:2.0452020168304 / seconds
Query Executed:select id FROM `mi` where city='Roseville' && SIC_code='5461'DB:business_master_new
loadtime:2.0464940071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rothbury' limit 1
loadtime:2.0465321540833 / seconds
Query Executed:select id FROM `mi` where city='Rothbury' && SIC_code='5461'DB:business_master_new
loadtime:2.0529301166534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal Oak' limit 1
loadtime:2.0529811382294 / seconds
Query Executed:select id FROM `mi` where city='Royal Oak' && SIC_code='5461'DB:business_master_new
loadtime:2.058925151825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:2.0589849948883 / seconds
Query Executed:select id FROM `mi` where city='Ruby' && SIC_code='5461'DB:business_master_new
loadtime:2.0592789649963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudyard' limit 1
loadtime:2.0593130588531 / seconds
Query Executed:select id FROM `mi` where city='Rudyard' && SIC_code='5461'DB:business_master_new
loadtime:2.065719127655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumely' limit 1
loadtime:2.065770149231 / seconds
Query Executed:select id FROM `mi` where city='Rumely' && SIC_code='5461'DB:business_master_new
loadtime:2.0663290023804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell Island' limit 1
loadtime:2.066367149353 / seconds
Query Executed:select id FROM `mi` where city='Russell Island' && SIC_code='5461'DB:business_master_new
loadtime:2.0666210651398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:2.0666589736938 / seconds
Query Executed:select id FROM `mi` where city='Ruth' && SIC_code='5461'DB:business_master_new
loadtime:2.0714499950409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saginaw' limit 1
loadtime:2.0714991092682 / seconds
Query Executed:select id FROM `mi` where city='Saginaw' && SIC_code='5461'DB:business_master_new
loadtime:2.0771889686584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagola' limit 1
loadtime:2.0772540569305 / seconds
Query Executed:select id FROM `mi` where city='Sagola' && SIC_code='5461'DB:business_master_new
loadtime:2.0788991451263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:2.0789461135864 / seconds
Query Executed:select id FROM `mi` where city='Saint Charles' && SIC_code='5461'DB:business_master_new
loadtime:2.0796821117401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair' limit 1
loadtime:2.0797369480133 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair' && SIC_code='5461'DB:business_master_new
loadtime:2.080502986908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair Shores' limit 1
loadtime:2.0805461406708 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair Shores' && SIC_code='5461'DB:business_master_new
loadtime:2.0860910415649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helen' limit 1
loadtime:2.08615899086 / seconds
Query Executed:select id FROM `mi` where city='Saint Helen' && SIC_code='5461'DB:business_master_new
loadtime:2.0894260406494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ignace' limit 1
loadtime:2.0894629955292 / seconds
Query Executed:select id FROM `mi` where city='Saint Ignace' && SIC_code='5461'DB:business_master_new
loadtime:2.0901730060577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:2.0902271270752 / seconds
Query Executed:select id FROM `mi` where city='Saint Johns' && SIC_code='5461'DB:business_master_new
loadtime:2.0911500453949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Joseph' limit 1
loadtime:2.0912070274353 / seconds
Query Executed:select id FROM `mi` where city='Saint Joseph' && SIC_code='5461'DB:business_master_new
loadtime:2.0924191474915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Louis' limit 1
loadtime:2.0924739837646 / seconds
Query Executed:select id FROM `mi` where city='Saint Louis' && SIC_code='5461'DB:business_master_new
loadtime:2.0931489467621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.0932030677795 / seconds
Query Executed:select id FROM `mi` where city='Salem' && SIC_code='5461'DB:business_master_new
loadtime:2.094083070755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saline' limit 1
loadtime:2.0941331386566 / seconds
Query Executed:select id FROM `mi` where city='Saline' && SIC_code='5461'DB:business_master_new
loadtime:2.0948710441589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Samaria' limit 1
loadtime:2.0949139595032 / seconds
Query Executed:select id FROM `mi` where city='Samaria' && SIC_code='5461'DB:business_master_new
loadtime:2.0955641269684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Creek' limit 1
loadtime:2.0956110954285 / seconds
Query Executed:select id FROM `mi` where city='Sand Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.0996370315552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Lake' limit 1
loadtime:2.0996830463409 / seconds
Query Executed:select id FROM `mi` where city='Sand Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.1002810001373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandusky' limit 1
loadtime:2.1003170013428 / seconds
Query Executed:select id FROM `mi` where city='Sandusky' && SIC_code='5461'DB:business_master_new
loadtime:2.1010639667511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:2.1011009216309 / seconds
Query Executed:select id FROM `mi` where city='Sanford' && SIC_code='5461'DB:business_master_new
loadtime:2.1017789840698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saranac' limit 1
loadtime:2.101814031601 / seconds
Query Executed:select id FROM `mi` where city='Saranac' && SIC_code='5461'DB:business_master_new
loadtime:2.1024241447449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugatuck' limit 1
loadtime:2.102471113205 / seconds
Query Executed:select id FROM `mi` where city='Saugatuck' && SIC_code='5461'DB:business_master_new
loadtime:2.1031589508057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Sainte Marie' limit 1
loadtime:2.1031939983368 / seconds
Query Executed:select id FROM `mi` where city='Sault Sainte Marie' && SIC_code='5461'DB:business_master_new
loadtime:2.1042921543121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Ste Marie' limit 1
loadtime:2.1043450832367 / seconds
Query Executed:select id FROM `mi` where city='Sault Ste Marie' && SIC_code='5461'DB:business_master_new
loadtime:2.1082770824432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sawyer' limit 1
loadtime:2.1083130836487 / seconds
Query Executed:select id FROM `mi` where city='Sawyer' && SIC_code='5461'DB:business_master_new
loadtime:2.1093530654907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schoolcraft' limit 1
loadtime:2.1094119548798 / seconds
Query Executed:select id FROM `mi` where city='Schoolcraft' && SIC_code='5461'DB:business_master_new
loadtime:2.1105661392212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:2.1106309890747 / seconds
Query Executed:select id FROM `mi` where city='Scotts' && SIC_code='5461'DB:business_master_new
loadtime:2.1115250587463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:2.1115550994873 / seconds
Query Executed:select id FROM `mi` where city='Scottville' && SIC_code='5461'DB:business_master_new
loadtime:2.1125349998474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sears' limit 1
loadtime:2.1125819683075 / seconds
Query Executed:select id FROM `mi` where city='Sears' && SIC_code='5461'DB:business_master_new
loadtime:2.1157410144806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebewaing' limit 1
loadtime:2.1158111095428 / seconds
Query Executed:select id FROM `mi` where city='Sebewaing' && SIC_code='5461'DB:business_master_new
loadtime:2.1163821220398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selfridge Angb' limit 1
loadtime:2.1164331436157 / seconds
Query Executed:select id FROM `mi` where city='Selfridge Angb' && SIC_code='5461'DB:business_master_new
loadtime:2.1178550720215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:2.1178960800171 / seconds
Query Executed:select id FROM `mi` where city='Seneca' && SIC_code='5461'DB:business_master_new
loadtime:2.1181321144104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seney' limit 1
loadtime:2.1181590557098 / seconds
Query Executed:select id FROM `mi` where city='Seney' && SIC_code='5461'DB:business_master_new
loadtime:2.1191351413727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsburg' limit 1
loadtime:2.1191740036011 / seconds
Query Executed:select id FROM `mi` where city='Shaftsburg' && SIC_code='5461'DB:business_master_new
loadtime:2.1197409629822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:2.1197829246521 / seconds
Query Executed:select id FROM `mi` where city='Shelby' && SIC_code='5461'DB:business_master_new
loadtime:2.1204190254211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby Twp' limit 1
loadtime:2.1204650402069 / seconds
Query Executed:select id FROM `mi` where city='Shelby Twp' && SIC_code='5461'DB:business_master_new
loadtime:2.123703956604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelbyville' limit 1
loadtime:2.1237480640411 / seconds
Query Executed:select id FROM `mi` where city='Shelbyville' && SIC_code='5461'DB:business_master_new
loadtime:2.1243169307709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shepherd' limit 1
loadtime:2.1243600845337 / seconds
Query Executed:select id FROM `mi` where city='Shepherd' && SIC_code='5461'DB:business_master_new
loadtime:2.1249890327454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:2.1250350475311 / seconds
Query Executed:select id FROM `mi` where city='Sheridan' && SIC_code='5461'DB:business_master_new
loadtime:2.1255769729614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:2.1256041526794 / seconds
Query Executed:select id FROM `mi` where city='Sherwood' && SIC_code='5461'DB:business_master_new
loadtime:2.1297800540924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shingleton' limit 1
loadtime:2.1298270225525 / seconds
Query Executed:select id FROM `mi` where city='Shingleton' && SIC_code='5461'DB:business_master_new
loadtime:2.1367409229279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidnaw' limit 1
loadtime:2.1367790699005 / seconds
Query Executed:select id FROM `mi` where city='Sidnaw' && SIC_code='5461'DB:business_master_new
loadtime:2.1376030445099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:2.1376519203186 / seconds
Query Executed:select id FROM `mi` where city='Sidney' && SIC_code='5461'DB:business_master_new
loadtime:2.1402020454407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverwood' limit 1
loadtime:2.1402320861816 / seconds
Query Executed:select id FROM `mi` where city='Silverwood' && SIC_code='5461'DB:business_master_new
loadtime:2.1420431137085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Lakes' limit 1
loadtime:2.1420829296112 / seconds
Query Executed:select id FROM `mi` where city='Six Lakes' && SIC_code='5461'DB:business_master_new
loadtime:2.1426570415497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skandia' limit 1
loadtime:2.1426839828491 / seconds
Query Executed:select id FROM `mi` where city='Skandia' && SIC_code='5461'DB:business_master_new
loadtime:2.1498880386353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skanee' limit 1
loadtime:2.149934053421 / seconds
Query Executed:select id FROM `mi` where city='Skanee' && SIC_code='5461'DB:business_master_new
loadtime:2.150505065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smiths Creek' limit 1
loadtime:2.1505439281464 / seconds
Query Executed:select id FROM `mi` where city='Smiths Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.1512060165405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:2.1512320041656 / seconds
Query Executed:select id FROM `mi` where city='Smyrna' && SIC_code='5461'DB:business_master_new
loadtime:2.151505947113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snover' limit 1
loadtime:2.1515409946442 / seconds
Query Executed:select id FROM `mi` where city='Snover' && SIC_code='5461'DB:business_master_new
loadtime:2.1546521186829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sodus' limit 1
loadtime:2.1546809673309 / seconds
Query Executed:select id FROM `mi` where city='Sodus' && SIC_code='5461'DB:business_master_new
loadtime:2.161276102066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.1613159179688 / seconds
Query Executed:select id FROM `mi` where city='Somerset' && SIC_code='5461'DB:business_master_new
loadtime:2.1617259979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset Center' limit 1
loadtime:2.1617519855499 / seconds
Query Executed:select id FROM `mi` where city='Somerset Center' && SIC_code='5461'DB:business_master_new
loadtime:2.1638419628143 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boardman' limit 1
loadtime:2.1638770103455 / seconds
Query Executed:select id FROM `mi` where city='South Boardman' && SIC_code='5461'DB:business_master_new
loadtime:2.1672060489655 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Branch' limit 1
loadtime:2.1672430038452 / seconds
Query Executed:select id FROM `mi` where city='South Branch' && SIC_code='5461'DB:business_master_new
loadtime:2.1697471141815 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Haven' limit 1
loadtime:2.1697731018066 / seconds
Query Executed:select id FROM `mi` where city='South Haven' && SIC_code='5461'DB:business_master_new
loadtime:2.1706800460815 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyon' limit 1
loadtime:2.1707310676575 / seconds
Query Executed:select id FROM `mi` where city='South Lyon' && SIC_code='5461'DB:business_master_new
loadtime:2.1716251373291 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Range' limit 1
loadtime:2.171658039093 / seconds
Query Executed:select id FROM `mi` where city='South Range' && SIC_code='5461'DB:business_master_new
loadtime:2.1752691268921 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Rockwood' limit 1
loadtime:2.1753051280975 / seconds
Query Executed:select id FROM `mi` where city='South Rockwood' && SIC_code='5461'DB:business_master_new
loadtime:2.181214094162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.1812400817871 / seconds
Query Executed:select id FROM `mi` where city='Southfield' && SIC_code='5461'DB:business_master_new
loadtime:2.1871070861816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southgate' limit 1
loadtime:2.1871590614319 / seconds
Query Executed:select id FROM `mi` where city='Southgate' && SIC_code='5461'DB:business_master_new
loadtime:2.1878550052643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spalding' limit 1
loadtime:2.1878809928894 / seconds
Query Executed:select id FROM `mi` where city='Spalding' && SIC_code='5461'DB:business_master_new
loadtime:2.1905760765076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:2.1906130313873 / seconds
Query Executed:select id FROM `mi` where city='Sparta' && SIC_code='5461'DB:business_master_new
loadtime:2.1913959980011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Arbor' limit 1
loadtime:2.1914370059967 / seconds
Query Executed:select id FROM `mi` where city='Spring Arbor' && SIC_code='5461'DB:business_master_new
loadtime:2.1920111179352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:2.1920399665833 / seconds
Query Executed:select id FROM `mi` where city='Spring Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.1928241252899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.1928679943085 / seconds
Query Executed:select id FROM `mi` where city='Springfield' && SIC_code='5461'DB:business_master_new
loadtime:2.1944470405579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield Twp' limit 1
loadtime:2.1944799423218 / seconds
Query Executed:select id FROM `mi` where city='Springfield Twp' && SIC_code='5461'DB:business_master_new
loadtime:2.1951999664307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springport' limit 1
loadtime:2.1952481269836 / seconds
Query Executed:select id FROM `mi` where city='Springport' && SIC_code='5461'DB:business_master_new
loadtime:2.1958291530609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce' limit 1
loadtime:2.1958639621735 / seconds
Query Executed:select id FROM `mi` where city='Spruce' && SIC_code='5461'DB:business_master_new
loadtime:2.2004959583282 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:2.2005460262299 / seconds
Query Executed:select id FROM `mi` where city='St Charles' && SIC_code='5461'DB:business_master_new
loadtime:2.2010080814362 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair' limit 1
loadtime:2.2010431289673 / seconds
Query Executed:select id FROM `mi` where city='St Clair' && SIC_code='5461'DB:business_master_new
loadtime:2.2026031017303 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair Shores' limit 1
loadtime:2.2026491165161 / seconds
Query Executed:select id FROM `mi` where city='St Clair Shores' && SIC_code='5461'DB:business_master_new
loadtime:2.2055511474609 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ignace' limit 1
loadtime:2.2055859565735 / seconds
Query Executed:select id FROM `mi` where city='St Ignace' && SIC_code='5461'DB:business_master_new
loadtime:2.2058489322662 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:2.2058911323547 / seconds
Query Executed:select id FROM `mi` where city='St Johns' && SIC_code='5461'DB:business_master_new
loadtime:2.207123041153 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Joseph' limit 1
loadtime:2.2071721553802 / seconds
Query Executed:select id FROM `mi` where city='St Joseph' && SIC_code='5461'DB:business_master_new
loadtime:2.2099630832672 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Louis' limit 1
loadtime:2.2100241184235 / seconds
Query Executed:select id FROM `mi` where city='St Louis' && SIC_code='5461'DB:business_master_new
loadtime:2.2103450298309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stalwart' limit 1
loadtime:2.2103841304779 / seconds
Query Executed:select id FROM `mi` where city='Stalwart' && SIC_code='5461'DB:business_master_new
loadtime:2.2106671333313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stambaugh' limit 1
loadtime:2.2107059955597 / seconds
Query Executed:select id FROM `mi` where city='Stambaugh' && SIC_code='5461'DB:business_master_new
loadtime:2.2130920886993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Standish' limit 1
loadtime:2.2131390571594 / seconds
Query Executed:select id FROM `mi` where city='Standish' && SIC_code='5461'DB:business_master_new
loadtime:2.2138600349426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:2.2139050960541 / seconds
Query Executed:select id FROM `mi` where city='Stanton' && SIC_code='5461'DB:business_master_new
loadtime:2.2145781517029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:2.2146189212799 / seconds
Query Executed:select id FROM `mi` where city='Stanwood' && SIC_code='5461'DB:business_master_new
loadtime:2.215215921402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:2.2152631282806 / seconds
Query Executed:select id FROM `mi` where city='Stephenson' && SIC_code='5461'DB:business_master_new
loadtime:2.2158980369568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.215940952301 / seconds
Query Executed:select id FROM `mi` where city='Sterling' && SIC_code='5461'DB:business_master_new
loadtime:2.2224409580231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling Heights' limit 1
loadtime:2.222489118576 / seconds
Query Executed:select id FROM `mi` where city='Sterling Heights' && SIC_code='5461'DB:business_master_new
loadtime:2.2284340858459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:2.2284870147705 / seconds
Query Executed:select id FROM `mi` where city='Stevensville' && SIC_code='5461'DB:business_master_new
loadtime:2.2292921543121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.2293491363525 / seconds
Query Executed:select id FROM `mi` where city='Stockbridge' && SIC_code='5461'DB:business_master_new
loadtime:2.2299890518188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stronach' limit 1
loadtime:2.2300250530243 / seconds
Query Executed:select id FROM `mi` where city='Stronach' && SIC_code='5461'DB:business_master_new
loadtime:2.2305719852448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strongs' limit 1
loadtime:2.2306110858917 / seconds
Query Executed:select id FROM `mi` where city='Strongs' && SIC_code='5461'DB:business_master_new
loadtime:2.2309350967407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:2.230978012085 / seconds
Query Executed:select id FROM `mi` where city='Sturgis' && SIC_code='5461'DB:business_master_new
loadtime:2.2317430973053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:2.2318000793457 / seconds
Query Executed:select id FROM `mi` where city='Sumner' && SIC_code='5461'DB:business_master_new
loadtime:2.2358191013336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunfield' limit 1
loadtime:2.2358541488647 / seconds
Query Executed:select id FROM `mi` where city='Sunfield' && SIC_code='5461'DB:business_master_new
loadtime:2.2363979816437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suttons Bay' limit 1
loadtime:2.2364370822906 / seconds
Query Executed:select id FROM `mi` where city='Suttons Bay' && SIC_code='5461'DB:business_master_new
loadtime:2.2371029853821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swartz Creek' limit 1
loadtime:2.2371361255646 / seconds
Query Executed:select id FROM `mi` where city='Swartz Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.237920999527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvan Lake' limit 1
loadtime:2.2379570007324 / seconds
Query Executed:select id FROM `mi` where city='Sylvan Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.2384459972382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tawas City' limit 1
loadtime:2.238471031189 / seconds
Query Executed:select id FROM `mi` where city='Tawas City' && SIC_code='5461'DB:business_master_new
loadtime:2.2391049861908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:2.2391419410706 / seconds
Query Executed:select id FROM `mi` where city='Taylor' && SIC_code='5461'DB:business_master_new
loadtime:2.2399699687958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tecumseh' limit 1
loadtime:2.2400031089783 / seconds
Query Executed:select id FROM `mi` where city='Tecumseh' && SIC_code='5461'DB:business_master_new
loadtime:2.2407939434052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tekonsha' limit 1
loadtime:2.2408349514008 / seconds
Query Executed:select id FROM `mi` where city='Tekonsha' && SIC_code='5461'DB:business_master_new
loadtime:2.2413721084595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperance' limit 1
loadtime:2.2414240837097 / seconds
Query Executed:select id FROM `mi` where city='Temperance' && SIC_code='5461'DB:business_master_new
loadtime:2.2421469688416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompsonville' limit 1
loadtime:2.2421779632568 / seconds
Query Executed:select id FROM `mi` where city='Thompsonville' && SIC_code='5461'DB:business_master_new
loadtime:2.249342918396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Oaks' limit 1
loadtime:2.2493789196014 / seconds
Query Executed:select id FROM `mi` where city='Three Oaks' && SIC_code='5461'DB:business_master_new
loadtime:2.2500190734863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.2500500679016 / seconds
Query Executed:select id FROM `mi` where city='Three Rivers' && SIC_code='5461'DB:business_master_new
loadtime:2.2506840229034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:2.2507190704346 / seconds
Query Executed:select id FROM `mi` where city='Tipton' && SIC_code='5461'DB:business_master_new
loadtime:2.2604439258575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toivola' limit 1
loadtime:2.2604990005493 / seconds
Query Executed:select id FROM `mi` where city='Toivola' && SIC_code='5461'DB:business_master_new
loadtime:2.2621560096741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topinabee' limit 1
loadtime:2.262186050415 / seconds
Query Executed:select id FROM `mi` where city='Topinabee' && SIC_code='5461'DB:business_master_new
loadtime:2.2634019851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tower' limit 1
loadtime:2.2634410858154 / seconds
Query Executed:select id FROM `mi` where city='Tower' && SIC_code='5461'DB:business_master_new
loadtime:2.2638149261475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traunik' limit 1
loadtime:2.2638421058655 / seconds
Query Executed:select id FROM `mi` where city='Traunik' && SIC_code='5461'DB:business_master_new
loadtime:2.2640881538391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traverse City' limit 1
loadtime:2.264121055603 / seconds
Query Executed:select id FROM `mi` where city='Traverse City' && SIC_code='5461'DB:business_master_new
loadtime:2.270092010498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenary' limit 1
loadtime:2.2701480388641 / seconds
Query Executed:select id FROM `mi` where city='Trenary' && SIC_code='5461'DB:business_master_new
loadtime:2.2725229263306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:2.272567987442 / seconds
Query Executed:select id FROM `mi` where city='Trenton' && SIC_code='5461'DB:business_master_new
loadtime:2.2733149528503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Creek' limit 1
loadtime:2.2733399868011 / seconds
Query Executed:select id FROM `mi` where city='Trout Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.2746639251709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Lake' limit 1
loadtime:2.2747011184692 / seconds
Query Executed:select id FROM `mi` where city='Trout Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.2757530212402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:2.2757980823517 / seconds
Query Executed:select id FROM `mi` where city='Troy' && SIC_code='5461'DB:business_master_new
loadtime:2.2812340259552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trufant' limit 1
loadtime:2.2812740802765 / seconds
Query Executed:select id FROM `mi` where city='Trufant' && SIC_code='5461'DB:business_master_new
loadtime:2.2849440574646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turner' limit 1
loadtime:2.2849841117859 / seconds
Query Executed:select id FROM `mi` where city='Turner' && SIC_code='5461'DB:business_master_new
loadtime:2.2889130115509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuscola' limit 1
loadtime:2.2889430522919 / seconds
Query Executed:select id FROM `mi` where city='Tuscola' && SIC_code='5461'DB:business_master_new
loadtime:2.2895879745483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tustin' limit 1
loadtime:2.2896270751953 / seconds
Query Executed:select id FROM `mi` where city='Tustin' && SIC_code='5461'DB:business_master_new
loadtime:2.2936720848083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lake' limit 1
loadtime:2.2937021255493 / seconds
Query Executed:select id FROM `mi` where city='Twin Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.2943370342255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twining' limit 1
loadtime:2.2943739891052 / seconds
Query Executed:select id FROM `mi` where city='Twining' && SIC_code='5461'DB:business_master_new
loadtime:2.3001141548157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ubly' limit 1
loadtime:2.3001611232758 / seconds
Query Executed:select id FROM `mi` where city='Ubly' && SIC_code='5461'DB:business_master_new
loadtime:2.300763130188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:2.300812959671 / seconds
Query Executed:select id FROM `mi` where city='Union' && SIC_code='5461'DB:business_master_new
loadtime:2.3045880794525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union City' limit 1
loadtime:2.304624080658 / seconds
Query Executed:select id FROM `mi` where city='Union City' && SIC_code='5461'DB:business_master_new
loadtime:2.3051950931549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Lake' limit 1
loadtime:2.3052351474762 / seconds
Query Executed:select id FROM `mi` where city='Union Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.3113429546356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Pier' limit 1
loadtime:2.3113789558411 / seconds
Query Executed:select id FROM `mi` where city='Union Pier' && SIC_code='5461'DB:business_master_new
loadtime:2.324933052063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:2.3249990940094 / seconds
Query Executed:select id FROM `mi` where city='Unionville' && SIC_code='5461'DB:business_master_new
loadtime:2.3255739212036 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Center' limit 1
loadtime:2.325611114502 / seconds
Query Executed:select id FROM `mi` where city='University Center' && SIC_code='5461'DB:business_master_new
loadtime:2.3261699676514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:2.3262159824371 / seconds
Query Executed:select id FROM `mi` where city='Utica' && SIC_code='5461'DB:business_master_new
loadtime:2.3321130275726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandalia' limit 1
loadtime:2.3321731090546 / seconds
Query Executed:select id FROM `mi` where city='Vandalia' && SIC_code='5461'DB:business_master_new
loadtime:2.3358709812164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderbilt' limit 1
loadtime:2.3359141349792 / seconds
Query Executed:select id FROM `mi` where city='Vanderbilt' && SIC_code='5461'DB:business_master_new
loadtime:2.3396019935608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vassar' limit 1
loadtime:2.3396501541138 / seconds
Query Executed:select id FROM `mi` where city='Vassar' && SIC_code='5461'DB:business_master_new
loadtime:2.3403239250183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermontville' limit 1
loadtime:2.340353012085 / seconds
Query Executed:select id FROM `mi` where city='Vermontville' && SIC_code='5461'DB:business_master_new
loadtime:2.3409061431885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:2.3409430980682 / seconds
Query Executed:select id FROM `mi` where city='Vernon' && SIC_code='5461'DB:business_master_new
loadtime:2.3428690433502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vestaburg' limit 1
loadtime:2.3429081439972 / seconds
Query Executed:select id FROM `mi` where city='Vestaburg' && SIC_code='5461'DB:business_master_new
loadtime:2.3495509624481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:2.3495860099792 / seconds
Query Executed:select id FROM `mi` where city='Vicksburg' && SIC_code='5461'DB:business_master_new
loadtime:2.350270986557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vulcan' limit 1
loadtime:2.3503179550171 / seconds
Query Executed:select id FROM `mi` where city='Vulcan' && SIC_code='5461'DB:business_master_new
loadtime:2.3528599739075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.3529059886932 / seconds
Query Executed:select id FROM `mi` where city='Wakefield' && SIC_code='5461'DB:business_master_new
loadtime:2.3534801006317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldron' limit 1
loadtime:2.3535311222076 / seconds
Query Executed:select id FROM `mi` where city='Waldron' && SIC_code='5461'DB:business_master_new
loadtime:2.3570079803467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.3570449352264 / seconds
Query Executed:select id FROM `mi` where city='Wales' && SIC_code='5461'DB:business_master_new
loadtime:2.3572940826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:2.3573200702667 / seconds
Query Executed:select id FROM `mi` where city='Walhalla' && SIC_code='5461'DB:business_master_new
loadtime:2.3598561286926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerville' limit 1
loadtime:2.3598940372467 / seconds
Query Executed:select id FROM `mi` where city='Walkerville' && SIC_code='5461'DB:business_master_new
loadtime:2.3636610507965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:2.3636929988861 / seconds
Query Executed:select id FROM `mi` where city='Wallace' && SIC_code='5461'DB:business_master_new
loadtime:2.3662710189819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walled Lake' limit 1
loadtime:2.366308927536 / seconds
Query Executed:select id FROM `mi` where city='Walled Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.3671500682831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walloon Lake' limit 1
loadtime:2.3671939373016 / seconds
Query Executed:select id FROM `mi` where city='Walloon Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.3704891204834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.3705179691315 / seconds
Query Executed:select id FROM `mi` where city='Warren' && SIC_code='5461'DB:business_master_new
loadtime:2.3763670921326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.3764369487762 / seconds
Query Executed:select id FROM `mi` where city='Washington' && SIC_code='5461'DB:business_master_new
loadtime:2.377256155014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:2.3772959709167 / seconds
Query Executed:select id FROM `mi` where city='Waterford' && SIC_code='5461'DB:business_master_new
loadtime:2.382777929306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waters' limit 1
loadtime:2.3828151226044 / seconds
Query Executed:select id FROM `mi` where city='Waters' && SIC_code='5461'DB:business_master_new
loadtime:2.3832190036774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watersmeet' limit 1
loadtime:2.3832540512085 / seconds
Query Executed:select id FROM `mi` where city='Watersmeet' && SIC_code='5461'DB:business_master_new
loadtime:2.3860120773315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watervliet' limit 1
loadtime:2.3860471248627 / seconds
Query Executed:select id FROM `mi` where city='Watervliet' && SIC_code='5461'DB:business_master_new
loadtime:2.3866879940033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watton' limit 1
loadtime:2.3867361545563 / seconds
Query Executed:select id FROM `mi` where city='Watton' && SIC_code='5461'DB:business_master_new
loadtime:2.3879170417786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.3879599571228 / seconds
Query Executed:select id FROM `mi` where city='Wayland' && SIC_code='5461'DB:business_master_new
loadtime:2.3886649608612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:2.3886909484863 / seconds
Query Executed:select id FROM `mi` where city='Wayne' && SIC_code='5461'DB:business_master_new
loadtime:2.3892860412598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webberville' limit 1
loadtime:2.3893220424652 / seconds
Query Executed:select id FROM `mi` where city='Webberville' && SIC_code='5461'DB:business_master_new
loadtime:2.3899190425873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weidman' limit 1
loadtime:2.3899531364441 / seconds
Query Executed:select id FROM `mi` where city='Weidman' && SIC_code='5461'DB:business_master_new
loadtime:2.3905110359192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:2.39053606987 / seconds
Query Executed:select id FROM `mi` where city='Wells' && SIC_code='5461'DB:business_master_new
loadtime:2.3930349349976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellston' limit 1
loadtime:2.3930809497833 / seconds
Query Executed:select id FROM `mi` where city='Wellston' && SIC_code='5461'DB:business_master_new
loadtime:2.3936381340027 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bloomfield' limit 1
loadtime:2.3936641216278 / seconds
Query Executed:select id FROM `mi` where city='West Bloomfield' && SIC_code='5461'DB:business_master_new
loadtime:2.3992660045624 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:2.3993120193481 / seconds
Query Executed:select id FROM `mi` where city='West Branch' && SIC_code='5461'DB:business_master_new
loadtime:2.400218963623 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Olive' limit 1
loadtime:2.4002530574799 / seconds
Query Executed:select id FROM `mi` where city='West Olive' && SIC_code='5461'DB:business_master_new
loadtime:2.400866985321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westland' limit 1
loadtime:2.4009010791779 / seconds
Query Executed:select id FROM `mi` where city='Westland' && SIC_code='5461'DB:business_master_new
loadtime:2.4017519950867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.4017851352692 / seconds
Query Executed:select id FROM `mi` where city='Weston' && SIC_code='5461'DB:business_master_new
loadtime:2.4033160209656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:2.4033620357513 / seconds
Query Executed:select id FROM `mi` where city='Westphalia' && SIC_code='5461'DB:business_master_new
loadtime:2.411740064621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:2.4117920398712 / seconds
Query Executed:select id FROM `mi` where city='Wetmore' && SIC_code='5461'DB:business_master_new
loadtime:2.4135060310364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:2.4135589599609 / seconds
Query Executed:select id FROM `mi` where city='Wheeler' && SIC_code='5461'DB:business_master_new
loadtime:2.4157450199127 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Cloud' limit 1
loadtime:2.4158020019531 / seconds
Query Executed:select id FROM `mi` where city='White Cloud' && SIC_code='5461'DB:business_master_new
loadtime:2.4165351390839 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:2.4165771007538 / seconds
Query Executed:select id FROM `mi` where city='White Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.4175131320953 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pigeon' limit 1
loadtime:2.4175689220428 / seconds
Query Executed:select id FROM `mi` where city='White Pigeon' && SIC_code='5461'DB:business_master_new
loadtime:2.4181251525879 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pine' limit 1
loadtime:2.4181611537933 / seconds
Query Executed:select id FROM `mi` where city='White Pine' && SIC_code='5461'DB:business_master_new
loadtime:2.4195849895477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehall' limit 1
loadtime:2.4196269512177 / seconds
Query Executed:select id FROM `mi` where city='Whitehall' && SIC_code='5461'DB:business_master_new
loadtime:2.4203569889069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmore Lake' limit 1
loadtime:2.4204051494598 / seconds
Query Executed:select id FROM `mi` where city='Whitmore Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.4210031032562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittaker' limit 1
loadtime:2.4210450649261 / seconds
Query Executed:select id FROM `mi` where city='Whittaker' && SIC_code='5461'DB:business_master_new
loadtime:2.421364068985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:2.4214050769806 / seconds
Query Executed:select id FROM `mi` where city='Whittemore' && SIC_code='5461'DB:business_master_new
loadtime:2.4219360351562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.421972990036 / seconds
Query Executed:select id FROM `mi` where city='Williamsburg' && SIC_code='5461'DB:business_master_new
loadtime:2.4226269721985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:2.422660112381 / seconds
Query Executed:select id FROM `mi` where city='Williamston' && SIC_code='5461'DB:business_master_new
loadtime:2.4234149456024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:2.4234499931335 / seconds
Query Executed:select id FROM `mi` where city='Willis' && SIC_code='5461'DB:business_master_new
loadtime:2.4272029399872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:2.4272520542145 / seconds
Query Executed:select id FROM `mi` where city='Wilson' && SIC_code='5461'DB:business_master_new
loadtime:2.4282031059265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winn' limit 1
loadtime:2.4282381534576 / seconds
Query Executed:select id FROM `mi` where city='Winn' && SIC_code='5461'DB:business_master_new
loadtime:2.4311010837555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wixom' limit 1
loadtime:2.4311480522156 / seconds
Query Executed:select id FROM `mi` where city='Wixom' && SIC_code='5461'DB:business_master_new
loadtime:2.4320471286774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine' limit 1
loadtime:2.4320909976959 / seconds
Query Executed:select id FROM `mi` where city='Wolverine' && SIC_code='5461'DB:business_master_new
loadtime:2.4327049255371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine Lake' limit 1
loadtime:2.4327590465546 / seconds
Query Executed:select id FROM `mi` where city='Wolverine Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.4330761432648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:2.4331121444702 / seconds
Query Executed:select id FROM `mi` where city='Woodland' && SIC_code='5461'DB:business_master_new
loadtime:2.4367959499359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyandotte' limit 1
loadtime:2.4368441104889 / seconds
Query Executed:select id FROM `mi` where city='Wyandotte' && SIC_code='5461'DB:business_master_new
loadtime:2.4376399517059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:2.437686920166 / seconds
Query Executed:select id FROM `mi` where city='Wyoming' && SIC_code='5461'DB:business_master_new
loadtime:2.4435329437256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:2.443578004837 / seconds
Query Executed:select id FROM `mi` where city='Yale' && SIC_code='5461'DB:business_master_new
loadtime:2.4442110061646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ypsilanti' limit 1
loadtime:2.4442660808563 / seconds
Query Executed:select id FROM `mi` where city='Ypsilanti' && SIC_code='5461'DB:business_master_new
loadtime:2.4497201442719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zeeland' limit 1
loadtime:2.4497671127319 / seconds
Query Executed:select id FROM `mi` where city='Zeeland' && SIC_code='5461'DB:business_master_new
loadtime:2.4552130699158 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.4553091526031 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.4555449485779 / seconds
Operation template executed (chunk cache operation)
loadtime:2.4556250572205 / seconds
template override:Default
loadtime:2.4556429386139 / 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.4564490318298 / seconds
Template Constructed, Array Rows:49
loadtime:2.4566869735718 / seconds
TOTAL EXECUTION TIME: 2.4565
loadtime:2.4568049907684 / 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] => retail-bakeries [stateURLid] => michigan )


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