Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.793571472168E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00044584274291992 / seconds
host not found setting manual db connection
loadtime:0.00078487396240234 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00098299980163574 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0011048316955566 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0011518001556396 / seconds
zipcode:
loadtime:0.001168966293335 / seconds
Query Executed:select * from search_referrer where page_hash='a860c7ae857fffde29d6fc017366109f' limit 10 DB:ezrox_toadli
loadtime:0.0013439655303955 / seconds
Operation header executed (non global)
loadtime:0.0013618469238281 / seconds
Operation leaderboard executed (non global)
loadtime:0.0013918876647949 / seconds
Operation square executed (non global)
loadtime:0.0014059543609619 / seconds
Operation square_bottom executed (non global)
loadtime:0.0014188289642334 / seconds
Operation smallsquare executed (non global)
loadtime:0.0014297962188721 / seconds
Operation headeradright executed (non global)
loadtime:0.0014410018920898 / seconds
Operation google_analytics executed (non global)
loadtime:0.0014519691467285 / seconds
Operation topstories executed (non global)
loadtime:0.0014629364013672 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0014739036560059 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0014839172363281 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017609596252441 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0019118785858154 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0019528865814209 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.002004861831665 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0020558834075928 / seconds
Template key: archive_menu pushed
loadtime:0.0020599365234375 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.002065896987915 / seconds
Template key: get_gravatar pushed
loadtime:0.0020699501037598 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0020740032196045 / seconds
*10)-10)+1 | start:0
loadtime:0.0020959377288818 / seconds
DB connected to localhost business_master_new
loadtime:0.0023629665374756 / seconds
Query Executed:select * from categories where cat_URLid='auto-and-home-supply-stores'DB:business_master_new
loadtime:0.0028848648071289 / seconds
Query stored in cache : _QUERY_www.toadli.come4f69782081f0ed656ec764576e5695a
loadtime:0.0029208660125732 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.0029559135437012 / seconds
Query Executed:select * from `mi_catmap` where sic='5531' order by city ascDB:business_master_new
loadtime:0.22988390922546 / seconds
Query stored in cache : _QUERY_www.toadli.com75ae0d8a74f70d2c4c6586bf903228e3
loadtime:0.23211884498596 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.23216986656189 / seconds
Query Executed:select sum(totalcount) as totalsum from `mi_catmap` where sic='5531'DB:business_master_new
loadtime:0.24259781837463 / seconds
Query stored in cache : _QUERY_www.toadli.comf95bf74a02c5e5b79af1e98488ddd031
loadtime:0.24271178245544 / seconds
966 / 11
loadtime:0.24279880523682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acme' limit 1
loadtime:0.24288892745972 / seconds
Query Executed:select id FROM `mi` where city='Acme' && SIC_code='5531'DB:business_master_new
loadtime:0.26496481895447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ada' limit 1
loadtime:0.26501178741455 / seconds
Query Executed:select id FROM `mi` where city='Ada' && SIC_code='5531'DB:business_master_new
loadtime:0.26667881011963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison' limit 1
loadtime:0.26672196388245 / seconds
Query Executed:select id FROM `mi` where city='Addison' && SIC_code='5531'DB:business_master_new
loadtime:0.26756978034973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison Twp' limit 1
loadtime:0.26761078834534 / seconds
Query Executed:select id FROM `mi` where city='Addison Twp' && SIC_code='5531'DB:business_master_new
loadtime:0.26963186264038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adrian' limit 1
loadtime:0.2696738243103 / seconds
Query Executed:select id FROM `mi` where city='Adrian' && SIC_code='5531'DB:business_master_new
loadtime:0.27853798866272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.27871584892273 / seconds
Query Executed:select id FROM `mi` where city='Afton' && SIC_code='5531'DB:business_master_new
loadtime:0.28857898712158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahmeek' limit 1
loadtime:0.28863883018494 / seconds
Query Executed:select id FROM `mi` where city='Ahmeek' && SIC_code='5531'DB:business_master_new
loadtime:0.29363989830017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.2936749458313 / seconds
Query Executed:select id FROM `mi` where city='Akron' && SIC_code='5531'DB:business_master_new
loadtime:0.31085586547852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alanson' limit 1
loadtime:0.31090188026428 / seconds
Query Executed:select id FROM `mi` where city='Alanson' && SIC_code='5531'DB:business_master_new
loadtime:0.31306290626526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alba' limit 1
loadtime:0.31313490867615 / seconds
Query Executed:select id FROM `mi` where city='Alba' && SIC_code='5531'DB:business_master_new
loadtime:0.32131195068359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.32135891914368 / seconds
Query Executed:select id FROM `mi` where city='Albion' && SIC_code='5531'DB:business_master_new
loadtime:0.32320189476013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.32324194908142 / seconds
Query Executed:select id FROM `mi` where city='Alden' && SIC_code='5531'DB:business_master_new
loadtime:0.34530878067017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alger' limit 1
loadtime:0.34543490409851 / seconds
Query Executed:select id FROM `mi` where city='Alger' && SIC_code='5531'DB:business_master_new
loadtime:0.376797914505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algonac' limit 1
loadtime:0.37684679031372 / seconds
Query Executed:select id FROM `mi` where city='Algonac' && SIC_code='5531'DB:business_master_new
loadtime:0.37958192825317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allegan' limit 1
loadtime:0.37964081764221 / seconds
Query Executed:select id FROM `mi` where city='Allegan' && SIC_code='5531'DB:business_master_new
loadtime:0.3871169090271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.38717699050903 / seconds
Query Executed:select id FROM `mi` where city='Allen' && SIC_code='5531'DB:business_master_new
loadtime:0.40375900268555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen Park' limit 1
loadtime:0.40383386611938 / seconds
Query Executed:select id FROM `mi` where city='Allen Park' && SIC_code='5531'DB:business_master_new
loadtime:0.4058678150177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.40592288970947 / seconds
Query Executed:select id FROM `mi` where city='Allendale' && SIC_code='5531'DB:business_master_new
loadtime:0.40955686569214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenton' limit 1
loadtime:0.40959978103638 / seconds
Query Executed:select id FROM `mi` where city='Allenton' && SIC_code='5531'DB:business_master_new
loadtime:0.43596076965332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allouez' limit 1
loadtime:0.43601489067078 / seconds
Query Executed:select id FROM `mi` where city='Allouez' && SIC_code='5531'DB:business_master_new
loadtime:0.43934798240662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.43938279151917 / seconds
Query Executed:select id FROM `mi` where city='Alma' && SIC_code='5531'DB:business_master_new
loadtime:0.44294786453247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almont' limit 1
loadtime:0.44300079345703 / seconds
Query Executed:select id FROM `mi` where city='Almont' && SIC_code='5531'DB:business_master_new
loadtime:0.44467186927795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.44472098350525 / seconds
Query Executed:select id FROM `mi` where city='Alpena' && SIC_code='5531'DB:business_master_new
loadtime:0.44793295860291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.44797396659851 / seconds
Query Executed:select id FROM `mi` where city='Alpha' && SIC_code='5531'DB:business_master_new
loadtime:0.4510669708252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.45110988616943 / seconds
Query Executed:select id FROM `mi` where city='Alto' && SIC_code='5531'DB:business_master_new
loadtime:0.45202994346619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amasa' limit 1
loadtime:0.45205998420715 / seconds
Query Executed:select id FROM `mi` where city='Amasa' && SIC_code='5531'DB:business_master_new
loadtime:0.45652198791504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anchorville' limit 1
loadtime:0.45656394958496 / seconds
Query Executed:select id FROM `mi` where city='Anchorville' && SIC_code='5531'DB:business_master_new
loadtime:0.46067094802856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ann Arbor' limit 1
loadtime:0.46070098876953 / seconds
Query Executed:select id FROM `mi` where city='Ann Arbor' && SIC_code='5531'DB:business_master_new
loadtime:0.46489095687866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Applegate' limit 1
loadtime:0.46494293212891 / seconds
Query Executed:select id FROM `mi` where city='Applegate' && SIC_code='5531'DB:business_master_new
loadtime:0.47797584533691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.4780068397522 / seconds
Query Executed:select id FROM `mi` where city='Arcadia' && SIC_code='5531'DB:business_master_new
loadtime:0.4922308921814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.49228382110596 / seconds
Query Executed:select id FROM `mi` where city='Argyle' && SIC_code='5531'DB:business_master_new
loadtime:0.49320077896118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armada' limit 1
loadtime:0.49324083328247 / seconds
Query Executed:select id FROM `mi` where city='Armada' && SIC_code='5531'DB:business_master_new
loadtime:0.49446582794189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnold' limit 1
loadtime:0.49450397491455 / seconds
Query Executed:select id FROM `mi` where city='Arnold' && SIC_code='5531'DB:business_master_new
loadtime:0.49665379524231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley' limit 1
loadtime:0.49670195579529 / seconds
Query Executed:select id FROM `mi` where city='Ashley' && SIC_code='5531'DB:business_master_new
loadtime:0.51781892776489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.51785397529602 / seconds
Query Executed:select id FROM `mi` where city='Athens' && SIC_code='5531'DB:business_master_new
loadtime:0.54930281639099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlanta' limit 1
loadtime:0.5493528842926 / seconds
Query Executed:select id FROM `mi` where city='Atlanta' && SIC_code='5531'DB:business_master_new
loadtime:0.57269477844238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Mine' limit 1
loadtime:0.57273483276367 / seconds
Query Executed:select id FROM `mi` where city='Atlantic Mine' && SIC_code='5531'DB:business_master_new
loadtime:0.58688187599182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlas' limit 1
loadtime:0.5869288444519 / seconds
Query Executed:select id FROM `mi` where city='Atlas' && SIC_code='5531'DB:business_master_new
loadtime:0.59106588363647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attica' limit 1
loadtime:0.59109783172607 / seconds
Query Executed:select id FROM `mi` where city='Attica' && SIC_code='5531'DB:business_master_new
loadtime:0.59231281280518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Gres' limit 1
loadtime:0.59235286712646 / seconds
Query Executed:select id FROM `mi` where city='Au Gres' && SIC_code='5531'DB:business_master_new
loadtime:0.5949718952179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Train' limit 1
loadtime:0.59502696990967 / seconds
Query Executed:select id FROM `mi` where city='Au Train' && SIC_code='5531'DB:business_master_new
loadtime:0.60664892196655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.60668182373047 / seconds
Query Executed:select id FROM `mi` where city='Auburn' && SIC_code='5531'DB:business_master_new
loadtime:0.60794591903687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn Hills' limit 1
loadtime:0.60799598693848 / seconds
Query Executed:select id FROM `mi` where city='Auburn Hills' && SIC_code='5531'DB:business_master_new
loadtime:0.61260581016541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.61266398429871 / seconds
Query Executed:select id FROM `mi` where city='Augusta' && SIC_code='5531'DB:business_master_new
loadtime:0.61355590820312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.61359786987305 / seconds
Query Executed:select id FROM `mi` where city='Avoca' && SIC_code='5531'DB:business_master_new
loadtime:0.65106081962585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Azalia' limit 1
loadtime:0.65109586715698 / seconds
Query Executed:select id FROM `mi` where city='Azalia' && SIC_code='5531'DB:business_master_new
loadtime:0.65192198753357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bad Axe' limit 1
loadtime:0.65196490287781 / seconds
Query Executed:select id FROM `mi` where city='Bad Axe' && SIC_code='5531'DB:business_master_new
loadtime:0.65600895881653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.65606379508972 / seconds
Query Executed:select id FROM `mi` where city='Bailey' && SIC_code='5531'DB:business_master_new
loadtime:0.6659460067749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.66598796844482 / seconds
Query Executed:select id FROM `mi` where city='Baldwin' && SIC_code='5531'DB:business_master_new
loadtime:0.6674587726593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.6675078868866 / seconds
Query Executed:select id FROM `mi` where city='Bancroft' && SIC_code='5531'DB:business_master_new
loadtime:0.69294285774231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bangor' limit 1
loadtime:0.69298577308655 / seconds
Query Executed:select id FROM `mi` where city='Bangor' && SIC_code='5531'DB:business_master_new
loadtime:0.69470977783203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bannister' limit 1
loadtime:0.69477891921997 / seconds
Query Executed:select id FROM `mi` where city='Bannister' && SIC_code='5531'DB:business_master_new
loadtime:0.70461487770081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baraga' limit 1
loadtime:0.70465683937073 / seconds
Query Executed:select id FROM `mi` where city='Baraga' && SIC_code='5531'DB:business_master_new
loadtime:0.70596694946289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barbeau' limit 1
loadtime:0.70602297782898 / seconds
Query Executed:select id FROM `mi` where city='Barbeau' && SIC_code='5531'DB:business_master_new
loadtime:0.71266484260559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bark River' limit 1
loadtime:0.71270084381104 / seconds
Query Executed:select id FROM `mi` where city='Bark River' && SIC_code='5531'DB:business_master_new
loadtime:0.73999500274658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baroda' limit 1
loadtime:0.74004292488098 / seconds
Query Executed:select id FROM `mi` where city='Baroda' && SIC_code='5531'DB:business_master_new
loadtime:0.74099087715149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barryton' limit 1
loadtime:0.74103784561157 / seconds
Query Executed:select id FROM `mi` where city='Barryton' && SIC_code='5531'DB:business_master_new
loadtime:0.76420783996582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton City' limit 1
loadtime:0.76425194740295 / seconds
Query Executed:select id FROM `mi` where city='Barton City' && SIC_code='5531'DB:business_master_new
loadtime:0.77150988578796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.77155780792236 / seconds
Query Executed:select id FROM `mi` where city='Bath' && SIC_code='5531'DB:business_master_new
loadtime:0.77298784255981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.77303099632263 / seconds
Query Executed:select id FROM `mi` where city='Battle Creek' && SIC_code='5531'DB:business_master_new
loadtime:0.78399896621704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.78406691551208 / seconds
Query Executed:select id FROM `mi` where city='Bay City' && SIC_code='5531'DB:business_master_new
loadtime:0.79299283027649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Port' limit 1
loadtime:0.79304885864258 / seconds
Query Executed:select id FROM `mi` where city='Bay Port' && SIC_code='5531'DB:business_master_new
loadtime:0.81210780143738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Shore' limit 1
loadtime:0.81215691566467 / seconds
Query Executed:select id FROM `mi` where city='Bay Shore' && SIC_code='5531'DB:business_master_new
loadtime:0.81431984901428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay View' limit 1
loadtime:0.81435489654541 / seconds
Query Executed:select id FROM `mi` where city='Bay View' && SIC_code='5531'DB:business_master_new
loadtime:0.81917190551758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Lake' limit 1
loadtime:0.81921887397766 / seconds
Query Executed:select id FROM `mi` where city='Bear Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.82175278663635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver Island' limit 1
loadtime:0.82180786132812 / seconds
Query Executed:select id FROM `mi` where city='Beaver Island' && SIC_code='5531'DB:business_master_new
loadtime:0.85782384872437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverton' limit 1
loadtime:0.85786080360413 / seconds
Query Executed:select id FROM `mi` where city='Beaverton' && SIC_code='5531'DB:business_master_new
loadtime:0.85887289047241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.8589198589325 / seconds
Query Executed:select id FROM `mi` where city='Bedford' && SIC_code='5531'DB:business_master_new
loadtime:0.86230278015137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belding' limit 1
loadtime:0.86233878135681 / seconds
Query Executed:select id FROM `mi` where city='Belding' && SIC_code='5531'DB:business_master_new
loadtime:0.86483883857727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellaire' limit 1
loadtime:0.86489677429199 / seconds
Query Executed:select id FROM `mi` where city='Bellaire' && SIC_code='5531'DB:business_master_new
loadtime:0.86636877059937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.8664128780365 / seconds
Query Executed:select id FROM `mi` where city='Belleville' && SIC_code='5531'DB:business_master_new
loadtime:0.86835193634033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.86840581893921 / seconds
Query Executed:select id FROM `mi` where city='Bellevue' && SIC_code='5531'DB:business_master_new
loadtime:0.86966490745544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.86971879005432 / seconds
Query Executed:select id FROM `mi` where city='Belmont' && SIC_code='5531'DB:business_master_new
loadtime:0.87073183059692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentley' limit 1
loadtime:0.87076783180237 / seconds
Query Executed:select id FROM `mi` where city='Bentley' && SIC_code='5531'DB:business_master_new
loadtime:0.87664699554443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton Harbor' limit 1
loadtime:0.87669396400452 / seconds
Query Executed:select id FROM `mi` where city='Benton Harbor' && SIC_code='5531'DB:business_master_new
loadtime:0.88248300552368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benzonia' limit 1
loadtime:0.88253784179688 / seconds
Query Executed:select id FROM `mi` where city='Benzonia' && SIC_code='5531'DB:business_master_new
loadtime:0.88398289680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergland' limit 1
loadtime:0.88403797149658 / seconds
Query Executed:select id FROM `mi` where city='Bergland' && SIC_code='5531'DB:business_master_new
loadtime:0.88743686676025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.8874728679657 / seconds
Query Executed:select id FROM `mi` where city='Berkley' && SIC_code='5531'DB:business_master_new
loadtime:0.88940191268921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.8894579410553 / seconds
Query Executed:select id FROM `mi` where city='Berlin' && SIC_code='5531'DB:business_master_new
loadtime:0.89035892486572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Center' limit 1
loadtime:0.89039492607117 / seconds
Query Executed:select id FROM `mi` where city='Berrien Center' && SIC_code='5531'DB:business_master_new
loadtime:0.90666794776917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Springs' limit 1
loadtime:0.9068329334259 / seconds
Query Executed:select id FROM `mi` where city='Berrien Springs' && SIC_code='5531'DB:business_master_new
loadtime:0.91035795211792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berville' limit 1
loadtime:0.91041493415833 / seconds
Query Executed:select id FROM `mi` where city='Berville' && SIC_code='5531'DB:business_master_new
loadtime:0.91067790985107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer' limit 1
loadtime:0.91070580482483 / seconds
Query Executed:select id FROM `mi` where city='Bessemer' && SIC_code='5531'DB:business_master_new
loadtime:0.91163682937622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.9116837978363 / seconds
Query Executed:select id FROM `mi` where city='Beulah' && SIC_code='5531'DB:business_master_new
loadtime:0.912841796875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly Hills' limit 1
loadtime:0.9128839969635 / seconds
Query Executed:select id FROM `mi` where city='Beverly Hills' && SIC_code='5531'DB:business_master_new
loadtime:0.91472387313843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bay' limit 1
loadtime:0.91477394104004 / seconds
Query Executed:select id FROM `mi` where city='Big Bay' && SIC_code='5531'DB:business_master_new
loadtime:0.92411398887634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rapids' limit 1
loadtime:0.92414999008179 / seconds
Query Executed:select id FROM `mi` where city='Big Rapids' && SIC_code='5531'DB:business_master_new
loadtime:0.92834496498108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham Farms' limit 1
loadtime:0.9284029006958 / seconds
Query Executed:select id FROM `mi` where city='Bingham Farms' && SIC_code='5531'DB:business_master_new
loadtime:0.92969584465027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birch Run' limit 1
loadtime:0.92973184585571 / seconds
Query Executed:select id FROM `mi` where city='Birch Run' && SIC_code='5531'DB:business_master_new
loadtime:0.93159699440002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.93166589736938 / seconds
Query Executed:select id FROM `mi` where city='Birmingham' && SIC_code='5531'DB:business_master_new
loadtime:0.93446278572083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bitely' limit 1
loadtime:0.93452191352844 / seconds
Query Executed:select id FROM `mi` where city='Bitely' && SIC_code='5531'DB:business_master_new
loadtime:0.94560289382935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River' limit 1
loadtime:0.94565892219543 / seconds
Query Executed:select id FROM `mi` where city='Black River' && SIC_code='5531'DB:business_master_new
loadtime:0.95618295669556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.95623397827148 / seconds
Query Executed:select id FROM `mi` where city='Blanchard' && SIC_code='5531'DB:business_master_new
loadtime:0.98954176902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blissfield' limit 1
loadtime:0.98958587646484 / seconds
Query Executed:select id FROM `mi` where city='Blissfield' && SIC_code='5531'DB:business_master_new
loadtime:0.99209094047546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Hills' limit 1
loadtime:0.99214792251587 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Hills' && SIC_code='5531'DB:business_master_new
loadtime:0.99499678611755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Twp' limit 1
loadtime:0.99504089355469 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Twp' && SIC_code='5531'DB:business_master_new
loadtime:0.99778485298157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingdale' limit 1
loadtime:0.99783277511597 / seconds
Query Executed:select id FROM `mi` where city='Bloomingdale' && SIC_code='5531'DB:business_master_new
loadtime:1.0376598834991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boon' limit 1
loadtime:1.0376958847046 / seconds
Query Executed:select id FROM `mi` where city='Boon' && SIC_code='5531'DB:business_master_new
loadtime:1.0430028438568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne City' limit 1
loadtime:1.0430519580841 / seconds
Query Executed:select id FROM `mi` where city='Boyne City' && SIC_code='5531'DB:business_master_new
loadtime:1.045637845993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne Falls' limit 1
loadtime:1.0457189083099 / seconds
Query Executed:select id FROM `mi` where city='Boyne Falls' && SIC_code='5531'DB:business_master_new
loadtime:1.0845849514008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:1.0846438407898 / seconds
Query Executed:select id FROM `mi` where city='Bradley' && SIC_code='5531'DB:business_master_new
loadtime:1.0871119499207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branch' limit 1
loadtime:1.0871539115906 / seconds
Query Executed:select id FROM `mi` where city='Branch' && SIC_code='5531'DB:business_master_new
loadtime:1.1053078174591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant' limit 1
loadtime:1.1053349971771 / seconds
Query Executed:select id FROM `mi` where city='Brant' && SIC_code='5531'DB:business_master_new
loadtime:1.1189579963684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breckenridge' limit 1
loadtime:1.1190068721771 / seconds
Query Executed:select id FROM `mi` where city='Breckenridge' && SIC_code='5531'DB:business_master_new
loadtime:1.1210157871246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breedsville' limit 1
loadtime:1.1210608482361 / seconds
Query Executed:select id FROM `mi` where city='Breedsville' && SIC_code='5531'DB:business_master_new
loadtime:1.123263835907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brethren' limit 1
loadtime:1.1233108043671 / seconds
Query Executed:select id FROM `mi` where city='Brethren' && SIC_code='5531'DB:business_master_new
loadtime:1.1362488269806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:1.1362979412079 / seconds
Query Executed:select id FROM `mi` where city='Bridgeport' && SIC_code='5531'DB:business_master_new
loadtime:1.1375048160553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:1.137542963028 / seconds
Query Executed:select id FROM `mi` where city='Bridgewater' && SIC_code='5531'DB:business_master_new
loadtime:1.1382789611816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgman' limit 1
loadtime:1.1383168697357 / seconds
Query Executed:select id FROM `mi` where city='Bridgman' && SIC_code='5531'DB:business_master_new
loadtime:1.1402418613434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:1.1402847766876 / seconds
Query Executed:select id FROM `mi` where city='Brighton' && SIC_code='5531'DB:business_master_new
loadtime:1.147097826004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimley' limit 1
loadtime:1.1471657752991 / seconds
Query Executed:select id FROM `mi` where city='Brimley' && SIC_code='5531'DB:business_master_new
loadtime:1.1777729988098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:1.1778118610382 / seconds
Query Executed:select id FROM `mi` where city='Britton' && SIC_code='5531'DB:business_master_new
loadtime:1.211886882782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockway' limit 1
loadtime:1.2119319438934 / seconds
Query Executed:select id FROM `mi` where city='Brockway' && SIC_code='5531'DB:business_master_new
loadtime:1.2122068405151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brohman' limit 1
loadtime:1.2122349739075 / seconds
Query Executed:select id FROM `mi` where city='Brohman' && SIC_code='5531'DB:business_master_new
loadtime:1.2165758609772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:1.2166349887848 / seconds
Query Executed:select id FROM `mi` where city='Bronson' && SIC_code='5531'DB:business_master_new
loadtime:1.2175898551941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:1.2176489830017 / seconds
Query Executed:select id FROM `mi` where city='Brooklyn' && SIC_code='5531'DB:business_master_new
loadtime:1.2191598415375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brown City' limit 1
loadtime:1.2192039489746 / seconds
Query Executed:select id FROM `mi` where city='Brown City' && SIC_code='5531'DB:business_master_new
loadtime:1.2206428050995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownstown Twp' limit 1
loadtime:1.2206988334656 / seconds
Query Executed:select id FROM `mi` where city='Brownstown Twp' && SIC_code='5531'DB:business_master_new
loadtime:1.2210748195648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:1.2211108207703 / seconds
Query Executed:select id FROM `mi` where city='Bruce' && SIC_code='5531'DB:business_master_new
loadtime:1.2218267917633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce Crossing' limit 1
loadtime:1.221864938736 / seconds
Query Executed:select id FROM `mi` where city='Bruce Crossing' && SIC_code='5531'DB:business_master_new
loadtime:1.2304828166962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brutus' limit 1
loadtime:1.2305178642273 / seconds
Query Executed:select id FROM `mi` where city='Brutus' && SIC_code='5531'DB:business_master_new
loadtime:1.2442479133606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:1.2442948818207 / seconds
Query Executed:select id FROM `mi` where city='Buchanan' && SIC_code='5531'DB:business_master_new
loadtime:1.2461268901825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckley' limit 1
loadtime:1.2461698055267 / seconds
Query Executed:select id FROM `mi` where city='Buckley' && SIC_code='5531'DB:business_master_new
loadtime:1.2805399894714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:1.280592918396 / seconds
Query Executed:select id FROM `mi` where city='Burlington' && SIC_code='5531'DB:business_master_new
loadtime:1.294068813324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnips' limit 1
loadtime:1.2941138744354 / seconds
Query Executed:select id FROM `mi` where city='Burnips' && SIC_code='5531'DB:business_master_new
loadtime:1.297070980072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Oak' limit 1
loadtime:1.2971019744873 / seconds
Query Executed:select id FROM `mi` where city='Burr Oak' && SIC_code='5531'DB:business_master_new
loadtime:1.3073928356171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:1.3074359893799 / seconds
Query Executed:select id FROM `mi` where city='Burt' && SIC_code='5531'DB:business_master_new
loadtime:1.3272888660431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt Lake' limit 1
loadtime:1.3273198604584 / seconds
Query Executed:select id FROM `mi` where city='Burt Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.3290538787842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burtchville' limit 1
loadtime:1.3290939331055 / seconds
Query Executed:select id FROM `mi` where city='Burtchville' && SIC_code='5531'DB:business_master_new
loadtime:1.3299160003662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burton' limit 1
loadtime:1.3299458026886 / seconds
Query Executed:select id FROM `mi` where city='Burton' && SIC_code='5531'DB:business_master_new
loadtime:1.3337109088898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:1.3337638378143 / seconds
Query Executed:select id FROM `mi` where city='Byron' && SIC_code='5531'DB:business_master_new
loadtime:1.3349108695984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron Center' limit 1
loadtime:1.3349487781525 / seconds
Query Executed:select id FROM `mi` where city='Byron Center' && SIC_code='5531'DB:business_master_new
loadtime:1.3365759849548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cadillac' limit 1
loadtime:1.3366417884827 / seconds
Query Executed:select id FROM `mi` where city='Cadillac' && SIC_code='5531'DB:business_master_new
loadtime:1.3405909538269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:1.3406620025635 / seconds
Query Executed:select id FROM `mi` where city='Caledonia' && SIC_code='5531'DB:business_master_new
loadtime:1.3422219753265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:1.3422718048096 / seconds
Query Executed:select id FROM `mi` where city='Calumet' && SIC_code='5531'DB:business_master_new
loadtime:1.3445799350739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:1.3446469306946 / seconds
Query Executed:select id FROM `mi` where city='Camden' && SIC_code='5531'DB:business_master_new
loadtime:1.3666768074036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannonsburg' limit 1
loadtime:1.3667199611664 / seconds
Query Executed:select id FROM `mi` where city='Cannonsburg' && SIC_code='5531'DB:business_master_new
loadtime:1.3685638904572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:1.3686079978943 / seconds
Query Executed:select id FROM `mi` where city='Canton' && SIC_code='5531'DB:business_master_new
loadtime:1.3701558113098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capac' limit 1
loadtime:1.3701949119568 / seconds
Query Executed:select id FROM `mi` where city='Capac' && SIC_code='5531'DB:business_master_new
loadtime:1.3720548152924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carleton' limit 1
loadtime:1.3721058368683 / seconds
Query Executed:select id FROM `mi` where city='Carleton' && SIC_code='5531'DB:business_master_new
loadtime:1.3730978965759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carney' limit 1
loadtime:1.3731338977814 / seconds
Query Executed:select id FROM `mi` where city='Carney' && SIC_code='5531'DB:business_master_new
loadtime:1.3808288574219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caro' limit 1
loadtime:1.3808708190918 / seconds
Query Executed:select id FROM `mi` where city='Caro' && SIC_code='5531'DB:business_master_new
loadtime:1.3831009864807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carp Lake' limit 1
loadtime:1.383152961731 / seconds
Query Executed:select id FROM `mi` where city='Carp Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.3910689353943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:1.3910977840424 / seconds
Query Executed:select id FROM `mi` where city='Carrollton' && SIC_code='5531'DB:business_master_new
loadtime:1.3985588550568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson City' limit 1
loadtime:1.3986079692841 / seconds
Query Executed:select id FROM `mi` where city='Carson City' && SIC_code='5531'DB:business_master_new
loadtime:1.4000298976898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carsonville' limit 1
loadtime:1.4000728130341 / seconds
Query Executed:select id FROM `mi` where city='Carsonville' && SIC_code='5531'DB:business_master_new
loadtime:1.4482328891754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casco' limit 1
loadtime:1.4482879638672 / seconds
Query Executed:select id FROM `mi` where city='Casco' && SIC_code='5531'DB:business_master_new
loadtime:1.4497039318085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caseville' limit 1
loadtime:1.449747800827 / seconds
Query Executed:select id FROM `mi` where city='Caseville' && SIC_code='5531'DB:business_master_new
loadtime:1.4506559371948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casnovia' limit 1
loadtime:1.4507038593292 / seconds
Query Executed:select id FROM `mi` where city='Casnovia' && SIC_code='5531'DB:business_master_new
loadtime:1.4660649299622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caspian' limit 1
loadtime:1.4661138057709 / seconds
Query Executed:select id FROM `mi` where city='Caspian' && SIC_code='5531'DB:business_master_new
loadtime:1.4781939983368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cass City' limit 1
loadtime:1.4782288074493 / seconds
Query Executed:select id FROM `mi` where city='Cass City' && SIC_code='5531'DB:business_master_new
loadtime:1.4802558422089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassopolis' limit 1
loadtime:1.4803137779236 / seconds
Query Executed:select id FROM `mi` where city='Cassopolis' && SIC_code='5531'DB:business_master_new
loadtime:1.4823958873749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:1.4824388027191 / seconds
Query Executed:select id FROM `mi` where city='Cedar' && SIC_code='5531'DB:business_master_new
loadtime:1.4833629131317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Lake' limit 1
loadtime:1.4834098815918 / seconds
Query Executed:select id FROM `mi` where city='Cedar Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.4862167835236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar River' limit 1
loadtime:1.4862518310547 / seconds
Query Executed:select id FROM `mi` where city='Cedar River' && SIC_code='5531'DB:business_master_new
loadtime:1.486930847168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Springs' limit 1
loadtime:1.4869778156281 / seconds
Query Executed:select id FROM `mi` where city='Cedar Springs' && SIC_code='5531'DB:business_master_new
loadtime:1.4884769916534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:1.4885199069977 / seconds
Query Executed:select id FROM `mi` where city='Cedarville' && SIC_code='5531'DB:business_master_new
loadtime:1.4896728992462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cement City' limit 1
loadtime:1.4897267818451 / seconds
Query Executed:select id FROM `mi` where city='Cement City' && SIC_code='5531'DB:business_master_new
loadtime:1.519119977951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Line' limit 1
loadtime:1.5191779136658 / seconds
Query Executed:select id FROM `mi` where city='Center Line' && SIC_code='5531'DB:business_master_new
loadtime:1.5209238529205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Lake' limit 1
loadtime:1.520968914032 / seconds
Query Executed:select id FROM `mi` where city='Central Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.521919965744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:1.5219678878784 / seconds
Query Executed:select id FROM `mi` where city='Centreville' && SIC_code='5531'DB:business_master_new
loadtime:1.5380299091339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceresco' limit 1
loadtime:1.5380709171295 / seconds
Query Executed:select id FROM `mi` where city='Ceresco' && SIC_code='5531'DB:business_master_new
loadtime:1.5497689247131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champion' limit 1
loadtime:1.5498149394989 / seconds
Query Executed:select id FROM `mi` where city='Champion' && SIC_code='5531'DB:business_master_new
loadtime:1.5620470046997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Channing' limit 1
loadtime:1.5620830059052 / seconds
Query Executed:select id FROM `mi` where city='Channing' && SIC_code='5531'DB:business_master_new
loadtime:1.5666778087616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlevoix' limit 1
loadtime:1.5667259693146 / seconds
Query Executed:select id FROM `mi` where city='Charlevoix' && SIC_code='5531'DB:business_master_new
loadtime:1.5681478977203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:1.5681869983673 / seconds
Query Executed:select id FROM `mi` where city='Charlotte' && SIC_code='5531'DB:business_master_new
loadtime:1.5720388889313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase' limit 1
loadtime:1.5720977783203 / seconds
Query Executed:select id FROM `mi` where city='Chase' && SIC_code='5531'DB:business_master_new
loadtime:1.5800628662109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chassell' limit 1
loadtime:1.5801088809967 / seconds
Query Executed:select id FROM `mi` where city='Chassell' && SIC_code='5531'DB:business_master_new
loadtime:1.6102468967438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.6102888584137 / seconds
Query Executed:select id FROM `mi` where city='Chatham' && SIC_code='5531'DB:business_master_new
loadtime:1.6239337921143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheboygan' limit 1
loadtime:1.6239819526672 / seconds
Query Executed:select id FROM `mi` where city='Cheboygan' && SIC_code='5531'DB:business_master_new
loadtime:1.627448797226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:1.6274960041046 / seconds
Query Executed:select id FROM `mi` where city='Chelsea' && SIC_code='5531'DB:business_master_new
loadtime:1.6285219192505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesaning' limit 1
loadtime:1.6285688877106 / seconds
Query Executed:select id FROM `mi` where city='Chesaning' && SIC_code='5531'DB:business_master_new
loadtime:1.6304588317871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.6305029392242 / seconds
Query Executed:select id FROM `mi` where city='Chesterfield' && SIC_code='5531'DB:business_master_new
loadtime:1.6395390033722 / seconds
Query loaded from cache:select * from geodata_geocity where city='China' limit 1
loadtime:1.6395869255066 / seconds
Query Executed:select id FROM `mi` where city='China' && SIC_code='5531'DB:business_master_new
loadtime:1.6404368877411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chippewa Lake' limit 1
loadtime:1.6404638290405 / seconds
Query Executed:select id FROM `mi` where city='Chippewa Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.6443150043488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christmas' limit 1
loadtime:1.6443619728088 / seconds
Query Executed:select id FROM `mi` where city='Christmas' && SIC_code='5531'DB:business_master_new
loadtime:1.6450369358063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:1.645082950592 / seconds
Query Executed:select id FROM `mi` where city='Clare' && SIC_code='5531'DB:business_master_new
loadtime:1.6474628448486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarklake' limit 1
loadtime:1.6475119590759 / seconds
Query Executed:select id FROM `mi` where city='Clarklake' && SIC_code='5531'DB:business_master_new
loadtime:1.6793918609619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:1.6794378757477 / seconds
Query Executed:select id FROM `mi` where city='Clarkston' && SIC_code='5531'DB:business_master_new
loadtime:1.6826817989349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:1.6827228069305 / seconds
Query Executed:select id FROM `mi` where city='Clarksville' && SIC_code='5531'DB:business_master_new
loadtime:1.701367855072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clawson' limit 1
loadtime:1.7014129161835 / seconds
Query Executed:select id FROM `mi` where city='Clawson' && SIC_code='5531'DB:business_master_new
loadtime:1.7047388553619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay' limit 1
loadtime:1.7047798633575 / seconds
Query Executed:select id FROM `mi` where city='Clay' && SIC_code='5531'DB:business_master_new
loadtime:1.7072658538818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:1.7073040008545 / seconds
Query Executed:select id FROM `mi` where city='Clayton' && SIC_code='5531'DB:business_master_new
loadtime:1.7256817817688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:1.7257258892059 / seconds
Query Executed:select id FROM `mi` where city='Clifford' && SIC_code='5531'DB:business_master_new
loadtime:1.7359609603882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:1.7359879016876 / seconds
Query Executed:select id FROM `mi` where city='Climax' && SIC_code='5531'DB:business_master_new
loadtime:1.7650439739227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:1.7650818824768 / seconds
Query Executed:select id FROM `mi` where city='Clinton' && SIC_code='5531'DB:business_master_new
loadtime:1.7663888931274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Township' limit 1
loadtime:1.7664217948914 / seconds
Query Executed:select id FROM `mi` where city='Clinton Township' && SIC_code='5531'DB:business_master_new
loadtime:1.7736978530884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Twp' limit 1
loadtime:1.773756980896 / seconds
Query Executed:select id FROM `mi` where city='Clinton Twp' && SIC_code='5531'DB:business_master_new
loadtime:1.79150390625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:1.791533946991 / seconds
Query Executed:select id FROM `mi` where city='Clio' && SIC_code='5531'DB:business_master_new
loadtime:1.7940039634705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:1.794068813324 / seconds
Query Executed:select id FROM `mi` where city='Cloverdale' && SIC_code='5531'DB:business_master_new
loadtime:1.795706987381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:1.7957367897034 / seconds
Query Executed:select id FROM `mi` where city='Clyde' && SIC_code='5531'DB:business_master_new
loadtime:1.7963528633118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohoctah' limit 1
loadtime:1.7963898181915 / seconds
Query Executed:select id FROM `mi` where city='Cohoctah' && SIC_code='5531'DB:business_master_new
loadtime:1.7983248233795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:1.7983617782593 / seconds
Query Executed:select id FROM `mi` where city='Coldwater' && SIC_code='5531'DB:business_master_new
loadtime:1.8021337985992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman' limit 1
loadtime:1.8021697998047 / seconds
Query Executed:select id FROM `mi` where city='Coleman' && SIC_code='5531'DB:business_master_new
loadtime:1.8033249378204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coloma' limit 1
loadtime:1.8033678531647 / seconds
Query Executed:select id FROM `mi` where city='Coloma' && SIC_code='5531'DB:business_master_new
loadtime:1.8049077987671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colon' limit 1
loadtime:1.8049409389496 / seconds
Query Executed:select id FROM `mi` where city='Colon' && SIC_code='5531'DB:business_master_new
loadtime:1.820004940033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbiaville' limit 1
loadtime:1.8200409412384 / seconds
Query Executed:select id FROM `mi` where city='Columbiaville' && SIC_code='5531'DB:business_master_new
loadtime:1.8209578990936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:1.8209829330444 / seconds
Query Executed:select id FROM `mi` where city='Columbus' && SIC_code='5531'DB:business_master_new
loadtime:1.8533959388733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comins' limit 1
loadtime:1.853444814682 / seconds
Query Executed:select id FROM `mi` where city='Comins' && SIC_code='5531'DB:business_master_new
loadtime:1.861900806427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Township' limit 1
loadtime:1.8619358539581 / seconds
Query Executed:select id FROM `mi` where city='Commerce Township' && SIC_code='5531'DB:business_master_new
loadtime:1.8656458854675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Twp' limit 1
loadtime:1.8657038211823 / seconds
Query Executed:select id FROM `mi` where city='Commerce Twp' && SIC_code='5531'DB:business_master_new
loadtime:1.8750998973846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock' limit 1
loadtime:1.8751509189606 / seconds
Query Executed:select id FROM `mi` where city='Comstock' && SIC_code='5531'DB:business_master_new
loadtime:1.8915379047394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock Park' limit 1
loadtime:1.8915729522705 / seconds
Query Executed:select id FROM `mi` where city='Comstock Park' && SIC_code='5531'DB:business_master_new
loadtime:1.8946418762207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:1.8946998119354 / seconds
Query Executed:select id FROM `mi` where city='Concord' && SIC_code='5531'DB:business_master_new
loadtime:1.8959128856659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conklin' limit 1
loadtime:1.8959558010101 / seconds
Query Executed:select id FROM `mi` where city='Conklin' && SIC_code='5531'DB:business_master_new
loadtime:1.9221777915955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Constantine' limit 1
loadtime:1.9222269058228 / seconds
Query Executed:select id FROM `mi` where city='Constantine' && SIC_code='5531'DB:business_master_new
loadtime:1.943431854248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:1.9434669017792 / seconds
Query Executed:select id FROM `mi` where city='Conway' && SIC_code='5531'DB:business_master_new
loadtime:1.951831817627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooks' limit 1
loadtime:1.9518809318542 / seconds
Query Executed:select id FROM `mi` where city='Cooks' && SIC_code='5531'DB:business_master_new
loadtime:1.953507900238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coopersville' limit 1
loadtime:1.9535429477692 / seconds
Query Executed:select id FROM `mi` where city='Coopersville' && SIC_code='5531'DB:business_master_new
loadtime:1.9552907943726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copemish' limit 1
loadtime:1.955347776413 / seconds
Query Executed:select id FROM `mi` where city='Copemish' && SIC_code='5531'DB:business_master_new
loadtime:1.967878818512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper City' limit 1
loadtime:1.9679148197174 / seconds
Query Executed:select id FROM `mi` where city='Copper City' && SIC_code='5531'DB:business_master_new
loadtime:1.9687559604645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Harbor' limit 1
loadtime:1.968790769577 / seconds
Query Executed:select id FROM `mi` where city='Copper Harbor' && SIC_code='5531'DB:business_master_new
loadtime:1.9769489765167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coral' limit 1
loadtime:1.9770028591156 / seconds
Query Executed:select id FROM `mi` where city='Coral' && SIC_code='5531'DB:business_master_new
loadtime:1.9844388961792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornell' limit 1
loadtime:1.9844789505005 / seconds
Query Executed:select id FROM `mi` where city='Cornell' && SIC_code='5531'DB:business_master_new
loadtime:1.9883329868317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corunna' limit 1
loadtime:1.9883718490601 / seconds
Query Executed:select id FROM `mi` where city='Corunna' && SIC_code='5531'DB:business_master_new
loadtime:1.9893658161163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottrellville' limit 1
loadtime:1.9894008636475 / seconds
Query Executed:select id FROM `mi` where city='Cottrellville' && SIC_code='5531'DB:business_master_new
loadtime:1.9899508953094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covert' limit 1
loadtime:1.9900009632111 / seconds
Query Executed:select id FROM `mi` where city='Covert' && SIC_code='5531'DB:business_master_new
loadtime:2.0068438053131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:2.0068860054016 / seconds
Query Executed:select id FROM `mi` where city='Covington' && SIC_code='5531'DB:business_master_new
loadtime:2.0121510028839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Village' limit 1
loadtime:2.012179851532 / seconds
Query Executed:select id FROM `mi` where city='Cross Village' && SIC_code='5531'DB:business_master_new
loadtime:2.0146789550781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croswell' limit 1
loadtime:2.0147199630737 / seconds
Query Executed:select id FROM `mi` where city='Croswell' && SIC_code='5531'DB:business_master_new
loadtime:2.0173978805542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal' limit 1
loadtime:2.0174548625946 / seconds
Query Executed:select id FROM `mi` where city='Crystal' && SIC_code='5531'DB:business_master_new
loadtime:2.0468819141388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Falls' limit 1
loadtime:2.0469307899475 / seconds
Query Executed:select id FROM `mi` where city='Crystal Falls' && SIC_code='5531'DB:business_master_new
loadtime:2.0479228496552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curran' limit 1
loadtime:2.0479559898376 / seconds
Query Executed:select id FROM `mi` where city='Curran' && SIC_code='5531'DB:business_master_new
loadtime:2.0495648384094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtis' limit 1
loadtime:2.0496017932892 / seconds
Query Executed:select id FROM `mi` where city='Curtis' && SIC_code='5531'DB:business_master_new
loadtime:2.0710690021515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:2.0711028575897 / seconds
Query Executed:select id FROM `mi` where city='Custer' && SIC_code='5531'DB:business_master_new
loadtime:2.0896918773651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dafter' limit 1
loadtime:2.089733839035 / seconds
Query Executed:select id FROM `mi` where city='Dafter' && SIC_code='5531'DB:business_master_new
loadtime:2.1013159751892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daggett' limit 1
loadtime:2.1013548374176 / seconds
Query Executed:select id FROM `mi` where city='Daggett' && SIC_code='5531'DB:business_master_new
loadtime:2.1099939346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dansville' limit 1
loadtime:2.1100299358368 / seconds
Query Executed:select id FROM `mi` where city='Dansville' && SIC_code='5531'DB:business_master_new
loadtime:2.1383059024811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davisburg' limit 1
loadtime:2.1383528709412 / seconds
Query Executed:select id FROM `mi` where city='Davisburg' && SIC_code='5531'DB:business_master_new
loadtime:2.1395819187164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davison' limit 1
loadtime:2.1396148204803 / seconds
Query Executed:select id FROM `mi` where city='Davison' && SIC_code='5531'DB:business_master_new
loadtime:2.1422688961029 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Tour Village' limit 1
loadtime:2.1423199176788 / seconds
Query Executed:select id FROM `mi` where city='De Tour Village' && SIC_code='5531'DB:business_master_new
loadtime:2.1595408916473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn' limit 1
loadtime:2.1595659255981 / seconds
Query Executed:select id FROM `mi` where city='Dearborn' && SIC_code='5531'DB:business_master_new
loadtime:2.161584854126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn Heights' limit 1
loadtime:2.1616377830505 / seconds
Query Executed:select id FROM `mi` where city='Dearborn Heights' && SIC_code='5531'DB:business_master_new
loadtime:2.1630318164825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:2.1630618572235 / seconds
Query Executed:select id FROM `mi` where city='Decatur' && SIC_code='5531'DB:business_master_new
loadtime:2.1644868850708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decker' limit 1
loadtime:2.1645278930664 / seconds
Query Executed:select id FROM `mi` where city='Decker' && SIC_code='5531'DB:business_master_new
loadtime:2.173182964325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deckerville' limit 1
loadtime:2.1732277870178 / seconds
Query Executed:select id FROM `mi` where city='Deckerville' && SIC_code='5531'DB:business_master_new
loadtime:2.1750907897949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:2.1751229763031 / seconds
Query Executed:select id FROM `mi` where city='Deerfield' && SIC_code='5531'DB:business_master_new
loadtime:2.1911478042603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerton' limit 1
loadtime:2.1911959648132 / seconds
Query Executed:select id FROM `mi` where city='Deerton' && SIC_code='5531'DB:business_master_new
loadtime:2.1936409473419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deford' limit 1
loadtime:2.1936659812927 / seconds
Query Executed:select id FROM `mi` where city='Deford' && SIC_code='5531'DB:business_master_new
loadtime:2.2053668498993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delton' limit 1
loadtime:2.2054018974304 / seconds
Query Executed:select id FROM `mi` where city='Delton' && SIC_code='5531'DB:business_master_new
loadtime:2.2079138755798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Detroit' limit 1
loadtime:2.2079439163208 / seconds
Query Executed:select id FROM `mi` where city='Detroit' && SIC_code='5531'DB:business_master_new
loadtime:2.6721088886261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:2.6722528934479 / seconds
Query Executed:select id FROM `mi` where city='Dewitt' && SIC_code='5531'DB:business_master_new
loadtime:2.6736028194427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:2.673654794693 / seconds
Query Executed:select id FROM `mi` where city='Dexter' && SIC_code='5531'DB:business_master_new
loadtime:2.6746587753296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimondale' limit 1
loadtime:2.6747069358826 / seconds
Query Executed:select id FROM `mi` where city='Dimondale' && SIC_code='5531'DB:business_master_new
loadtime:2.6756417751312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodgeville' limit 1
loadtime:2.6756908893585 / seconds
Query Executed:select id FROM `mi` where city='Dodgeville' && SIC_code='5531'DB:business_master_new
loadtime:2.6770238876343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dollar Bay' limit 1
loadtime:2.6770598888397 / seconds
Query Executed:select id FROM `mi` where city='Dollar Bay' && SIC_code='5531'DB:business_master_new
loadtime:2.6893589496613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorr' limit 1
loadtime:2.6894087791443 / seconds
Query Executed:select id FROM `mi` where city='Dorr' && SIC_code='5531'DB:business_master_new
loadtime:2.6903948783875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:2.6904528141022 / seconds
Query Executed:select id FROM `mi` where city='Douglas' && SIC_code='5531'DB:business_master_new
loadtime:2.6913709640503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowagiac' limit 1
loadtime:2.6914157867432 / seconds
Query Executed:select id FROM `mi` where city='Dowagiac' && SIC_code='5531'DB:business_master_new
loadtime:2.6926069259644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowling' limit 1
loadtime:2.6926598548889 / seconds
Query Executed:select id FROM `mi` where city='Dowling' && SIC_code='5531'DB:business_master_new
loadtime:2.704363822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton Plains' limit 1
loadtime:2.70441198349 / seconds
Query Executed:select id FROM `mi` where city='Drayton Plains' && SIC_code='5531'DB:business_master_new
loadtime:2.7159810066223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drummond Island' limit 1
loadtime:2.7160289287567 / seconds
Query Executed:select id FROM `mi` where city='Drummond Island' && SIC_code='5531'DB:business_master_new
loadtime:2.7394318580627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:2.7394778728485 / seconds
Query Executed:select id FROM `mi` where city='Dryden' && SIC_code='5531'DB:business_master_new
loadtime:2.7404577732086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:2.7405078411102 / seconds
Query Executed:select id FROM `mi` where city='Dundee' && SIC_code='5531'DB:business_master_new
loadtime:2.7415399551392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durand' limit 1
loadtime:2.741584777832 / seconds
Query Executed:select id FROM `mi` where city='Durand' && SIC_code='5531'DB:business_master_new
loadtime:2.7426338195801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:2.7426919937134 / seconds
Query Executed:select id FROM `mi` where city='Dutton' && SIC_code='5531'DB:business_master_new
loadtime:2.7440469264984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:2.7440829277039 / seconds
Query Executed:select id FROM `mi` where city='Eagle' && SIC_code='5531'DB:business_master_new
loadtime:2.7642078399658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Harbor' limit 1
loadtime:2.7642657756805 / seconds
Query Executed:select id FROM `mi` where city='Eagle Harbor' && SIC_code='5531'DB:business_master_new
loadtime:2.7647378444672 / seconds
Query loaded from cache:select * from geodata_geocity where city='East China' limit 1
loadtime:2.7647659778595 / seconds
Query Executed:select id FROM `mi` where city='East China' && SIC_code='5531'DB:business_master_new
loadtime:2.7657458782196 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Jordan' limit 1
loadtime:2.7658019065857 / seconds
Query Executed:select id FROM `mi` where city='East Jordan' && SIC_code='5531'DB:business_master_new
loadtime:2.7668099403381 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lansing' limit 1
loadtime:2.7668659687042 / seconds
Query Executed:select id FROM `mi` where city='East Lansing' && SIC_code='5531'DB:business_master_new
loadtime:2.7686998844147 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Leroy' limit 1
loadtime:2.7687439918518 / seconds
Query Executed:select id FROM `mi` where city='East Leroy' && SIC_code='5531'DB:business_master_new
loadtime:2.7777497768402 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Tawas' limit 1
loadtime:2.7779757976532 / seconds
Query Executed:select id FROM `mi` where city='East Tawas' && SIC_code='5531'DB:business_master_new
loadtime:2.7792727947235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastlake' limit 1
loadtime:2.7793819904327 / seconds
Query Executed:select id FROM `mi` where city='Eastlake' && SIC_code='5531'DB:business_master_new
loadtime:2.782096862793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastpointe' limit 1
loadtime:2.7821559906006 / seconds
Query Executed:select id FROM `mi` where city='Eastpointe' && SIC_code='5531'DB:business_master_new
loadtime:2.785651922226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastport' limit 1
loadtime:2.7857029438019 / seconds
Query Executed:select id FROM `mi` where city='Eastport' && SIC_code='5531'DB:business_master_new
loadtime:2.7911949157715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Rapids' limit 1
loadtime:2.7912428379059 / seconds
Query Executed:select id FROM `mi` where city='Eaton Rapids' && SIC_code='5531'DB:business_master_new
loadtime:2.7924129962921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Claire' limit 1
loadtime:2.792457818985 / seconds
Query Executed:select id FROM `mi` where city='Eau Claire' && SIC_code='5531'DB:business_master_new
loadtime:2.7934157848358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eben Junction' limit 1
loadtime:2.7934648990631 / seconds
Query Executed:select id FROM `mi` where city='Eben Junction' && SIC_code='5531'DB:business_master_new
loadtime:2.7984449863434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckerman' limit 1
loadtime:2.7984938621521 / seconds
Query Executed:select id FROM `mi` where city='Eckerman' && SIC_code='5531'DB:business_master_new
loadtime:2.8067278862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecorse' limit 1
loadtime:2.8067638874054 / seconds
Query Executed:select id FROM `mi` where city='Ecorse' && SIC_code='5531'DB:business_master_new
loadtime:2.8310499191284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenville' limit 1
loadtime:2.8311059474945 / seconds
Query Executed:select id FROM `mi` where city='Edenville' && SIC_code='5531'DB:business_master_new
loadtime:2.8377349376678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmore' limit 1
loadtime:2.8378348350525 / seconds
Query Executed:select id FROM `mi` where city='Edmore' && SIC_code='5531'DB:business_master_new
loadtime:2.8405799865723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsburg' limit 1
loadtime:2.8406507968903 / seconds
Query Executed:select id FROM `mi` where city='Edwardsburg' && SIC_code='5531'DB:business_master_new
loadtime:2.8417658805847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:2.8418838977814 / seconds
Query Executed:select id FROM `mi` where city='Elberta' && SIC_code='5531'DB:business_master_new
loadtime:2.8463528156281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Rapids' limit 1
loadtime:2.8464109897614 / seconds
Query Executed:select id FROM `mi` where city='Elk Rapids' && SIC_code='5531'DB:business_master_new
loadtime:2.8492448329926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:2.8492889404297 / seconds
Query Executed:select id FROM `mi` where city='Elkton' && SIC_code='5531'DB:business_master_new
loadtime:2.8781158924103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:2.8781747817993 / seconds
Query Executed:select id FROM `mi` where city='Ellsworth' && SIC_code='5531'DB:business_master_new
loadtime:2.8986749649048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Hall' limit 1
loadtime:2.8987228870392 / seconds
Query Executed:select id FROM `mi` where city='Elm Hall' && SIC_code='5531'DB:business_master_new
loadtime:2.8995378017426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmira' limit 1
loadtime:2.8995668888092 / seconds
Query Executed:select id FROM `mi` where city='Elmira' && SIC_code='5531'DB:business_master_new
loadtime:2.9055829048157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsie' limit 1
loadtime:2.9056379795074 / seconds
Query Executed:select id FROM `mi` where city='Elsie' && SIC_code='5531'DB:business_master_new
loadtime:2.9065690040588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwell' limit 1
loadtime:2.9065968990326 / seconds
Query Executed:select id FROM `mi` where city='Elwell' && SIC_code='5531'DB:business_master_new
loadtime:2.9150137901306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmett' limit 1
loadtime:2.9150609970093 / seconds
Query Executed:select id FROM `mi` where city='Emmett' && SIC_code='5531'DB:business_master_new
loadtime:2.9352588653564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:2.9352958202362 / seconds
Query Executed:select id FROM `mi` where city='Empire' && SIC_code='5531'DB:business_master_new
loadtime:2.9362318515778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engadine' limit 1
loadtime:2.9362728595734 / seconds
Query Executed:select id FROM `mi` where city='Engadine' && SIC_code='5531'DB:business_master_new
loadtime:2.9442369937897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:2.9442949295044 / seconds
Query Executed:select id FROM `mi` where city='Erie' && SIC_code='5531'DB:business_master_new
loadtime:2.945286989212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escanaba' limit 1
loadtime:2.9453299045563 / seconds
Query Executed:select id FROM `mi` where city='Escanaba' && SIC_code='5531'DB:business_master_new
loadtime:2.9467749595642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essexville' limit 1
loadtime:2.9468369483948 / seconds
Query Executed:select id FROM `mi` where city='Essexville' && SIC_code='5531'DB:business_master_new
loadtime:2.9478688240051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:2.9479138851166 / seconds
Query Executed:select id FROM `mi` where city='Eureka' && SIC_code='5531'DB:business_master_new
loadtime:2.9490208625793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evart' limit 1
loadtime:2.9490678310394 / seconds
Query Executed:select id FROM `mi` where city='Evart' && SIC_code='5531'DB:business_master_new
loadtime:2.9500617980957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewen' limit 1
loadtime:2.9501049518585 / seconds
Query Executed:select id FROM `mi` where city='Ewen' && SIC_code='5531'DB:business_master_new
loadtime:2.9534358978271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:2.9534819126129 / seconds
Query Executed:select id FROM `mi` where city='Fair Haven' && SIC_code='5531'DB:business_master_new
loadtime:2.9544699192047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairgrove' limit 1
loadtime:2.9545078277588 / seconds
Query Executed:select id FROM `mi` where city='Fairgrove' && SIC_code='5531'DB:business_master_new
loadtime:2.967503786087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:2.9675459861755 / seconds
Query Executed:select id FROM `mi` where city='Fairview' && SIC_code='5531'DB:business_master_new
loadtime:2.9847218990326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:2.9847629070282 / seconds
Query Executed:select id FROM `mi` where city='Falmouth' && SIC_code='5531'DB:business_master_new
loadtime:2.995059967041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fargo' limit 1
loadtime:2.9950919151306 / seconds
Query Executed:select id FROM `mi` where city='Fargo' && SIC_code='5531'DB:business_master_new
loadtime:2.995356798172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:2.9953939914703 / seconds
Query Executed:select id FROM `mi` where city='Farmington' && SIC_code='5531'DB:business_master_new
loadtime:2.9989759922028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington Hills' limit 1
loadtime:2.9990298748016 / seconds
Query Executed:select id FROM `mi` where city='Farmington Hills' && SIC_code='5531'DB:business_master_new
loadtime:3.0237159729004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farwell' limit 1
loadtime:3.0237729549408 / seconds
Query Executed:select id FROM `mi` where city='Farwell' && SIC_code='5531'DB:business_master_new
loadtime:3.0247287750244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Felch' limit 1
loadtime:3.0247628688812 / seconds
Query Executed:select id FROM `mi` where city='Felch' && SIC_code='5531'DB:business_master_new
loadtime:3.0298309326172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fennville' limit 1
loadtime:3.0298709869385 / seconds
Query Executed:select id FROM `mi` where city='Fennville' && SIC_code='5531'DB:business_master_new
loadtime:3.0309438705444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:3.0309829711914 / seconds
Query Executed:select id FROM `mi` where city='Fenton' && SIC_code='5531'DB:business_master_new
loadtime:3.0325858592987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwick' limit 1
loadtime:3.0326519012451 / seconds
Query Executed:select id FROM `mi` where city='Fenwick' && SIC_code='5531'DB:business_master_new
loadtime:3.0439729690552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferndale' limit 1
loadtime:3.0440239906311 / seconds
Query Executed:select id FROM `mi` where city='Ferndale' && SIC_code='5531'DB:business_master_new
loadtime:3.0454390048981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrysburg' limit 1
loadtime:3.0454778671265 / seconds
Query Executed:select id FROM `mi` where city='Ferrysburg' && SIC_code='5531'DB:business_master_new
loadtime:3.0571959018707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife Lake' limit 1
loadtime:3.0572509765625 / seconds
Query Executed:select id FROM `mi` where city='Fife Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.0826139450073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filer City' limit 1
loadtime:3.0826618671417 / seconds
Query Executed:select id FROM `mi` where city='Filer City' && SIC_code='5531'DB:business_master_new
loadtime:3.0833148956299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filion' limit 1
loadtime:3.0833559036255 / seconds
Query Executed:select id FROM `mi` where city='Filion' && SIC_code='5531'DB:business_master_new
loadtime:3.0904188156128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:3.0904488563538 / seconds
Query Executed:select id FROM `mi` where city='Flat Rock' && SIC_code='5531'DB:business_master_new
loadtime:3.0914559364319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint' limit 1
loadtime:3.0915038585663 / seconds
Query Executed:select id FROM `mi` where city='Flint' && SIC_code='5531'DB:business_master_new
loadtime:3.108158826828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flushing' limit 1
loadtime:3.1082577705383 / seconds
Query Executed:select id FROM `mi` where city='Flushing' && SIC_code='5531'DB:business_master_new
loadtime:3.1095178127289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestville' limit 1
loadtime:3.1095638275146 / seconds
Query Executed:select id FROM `mi` where city='Forestville' && SIC_code='5531'DB:business_master_new
loadtime:3.1101758480072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Gratiot' limit 1
loadtime:3.1102228164673 / seconds
Query Executed:select id FROM `mi` where city='Fort Gratiot' && SIC_code='5531'DB:business_master_new
loadtime:3.1114649772644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster City' limit 1
loadtime:3.1115097999573 / seconds
Query Executed:select id FROM `mi` where city='Foster City' && SIC_code='5531'DB:business_master_new
loadtime:3.1133699417114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:3.1134169101715 / seconds
Query Executed:select id FROM `mi` where city='Fostoria' && SIC_code='5531'DB:business_master_new
loadtime:3.1224579811096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:3.1224889755249 / seconds
Query Executed:select id FROM `mi` where city='Fountain' && SIC_code='5531'DB:business_master_new
loadtime:3.1298298835754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:3.1298718452454 / seconds
Query Executed:select id FROM `mi` where city='Fowler' && SIC_code='5531'DB:business_master_new
loadtime:3.130795955658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowlerville' limit 1
loadtime:3.1308310031891 / seconds
Query Executed:select id FROM `mi` where city='Fowlerville' && SIC_code='5531'DB:business_master_new
loadtime:3.1319539546967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankenmuth' limit 1
loadtime:3.1320259571075 / seconds
Query Executed:select id FROM `mi` where city='Frankenmuth' && SIC_code='5531'DB:business_master_new
loadtime:3.1330969333649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:3.1331369876862 / seconds
Query Executed:select id FROM `mi` where city='Frankfort' && SIC_code='5531'DB:business_master_new
loadtime:3.1340889930725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:3.1341209411621 / seconds
Query Executed:select id FROM `mi` where city='Franklin' && SIC_code='5531'DB:business_master_new
loadtime:3.1355378627777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraser' limit 1
loadtime:3.1355929374695 / seconds
Query Executed:select id FROM `mi` where city='Fraser' && SIC_code='5531'DB:business_master_new
loadtime:3.1368448734283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederic' limit 1
loadtime:3.1368908882141 / seconds
Query Executed:select id FROM `mi` where city='Frederic' && SIC_code='5531'DB:business_master_new
loadtime:3.14488697052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Soil' limit 1
loadtime:3.1449339389801 / seconds
Query Executed:select id FROM `mi` where city='Free Soil' && SIC_code='5531'DB:business_master_new
loadtime:3.1567869186401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeland' limit 1
loadtime:3.1568198204041 / seconds
Query Executed:select id FROM `mi` where city='Freeland' && SIC_code='5531'DB:business_master_new
loadtime:3.1579079627991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeport' limit 1
loadtime:3.1579558849335 / seconds
Query Executed:select id FROM `mi` where city='Freeport' && SIC_code='5531'DB:business_master_new
loadtime:3.168869972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:3.1689059734344 / seconds
Query Executed:select id FROM `mi` where city='Fremont' && SIC_code='5531'DB:business_master_new
loadtime:3.1701519489288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frontier' limit 1
loadtime:3.1702017784119 / seconds
Query Executed:select id FROM `mi` where city='Frontier' && SIC_code='5531'DB:business_master_new
loadtime:3.1730999946594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitport' limit 1
loadtime:3.1733858585358 / seconds
Query Executed:select id FROM `mi` where city='Fruitport' && SIC_code='5531'DB:business_master_new
loadtime:3.1744549274445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:3.1744909286499 / seconds
Query Executed:select id FROM `mi` where city='Fulton' && SIC_code='5531'DB:business_master_new
loadtime:3.1790537834167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaastra' limit 1
loadtime:3.1791138648987 / seconds
Query Executed:select id FROM `mi` where city='Gaastra' && SIC_code='5531'DB:business_master_new
loadtime:3.1826748847961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gagetown' limit 1
loadtime:3.1827058792114 / seconds
Query Executed:select id FROM `mi` where city='Gagetown' && SIC_code='5531'DB:business_master_new
loadtime:3.1902258396149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaines' limit 1
loadtime:3.1902658939362 / seconds
Query Executed:select id FROM `mi` where city='Gaines' && SIC_code='5531'DB:business_master_new
loadtime:3.2011759281158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesburg' limit 1
loadtime:3.2012059688568 / seconds
Query Executed:select id FROM `mi` where city='Galesburg' && SIC_code='5531'DB:business_master_new
loadtime:3.2022199630737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galien' limit 1
loadtime:3.2022697925568 / seconds
Query Executed:select id FROM `mi` where city='Galien' && SIC_code='5531'DB:business_master_new
loadtime:3.2100839614868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden' limit 1
loadtime:3.2101209163666 / seconds
Query Executed:select id FROM `mi` where city='Garden' && SIC_code='5531'DB:business_master_new
loadtime:3.2157289981842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:3.2157700061798 / seconds
Query Executed:select id FROM `mi` where city='Garden City' && SIC_code='5531'DB:business_master_new
loadtime:3.2168247699738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylord' limit 1
loadtime:3.2168719768524 / seconds
Query Executed:select id FROM `mi` where city='Gaylord' && SIC_code='5531'DB:business_master_new
loadtime:3.2179698944092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genesee' limit 1
loadtime:3.2179977893829 / seconds
Query Executed:select id FROM `mi` where city='Genesee' && SIC_code='5531'DB:business_master_new
loadtime:3.2256968021393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germfask' limit 1
loadtime:3.2257468700409 / seconds
Query Executed:select id FROM `mi` where city='Germfask' && SIC_code='5531'DB:business_master_new
loadtime:3.2274749279022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:3.2275228500366 / seconds
Query Executed:select id FROM `mi` where city='Gilford' && SIC_code='5531'DB:business_master_new
loadtime:3.2292878627777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:3.2293407917023 / seconds
Query Executed:select id FROM `mi` where city='Gladstone' && SIC_code='5531'DB:business_master_new
loadtime:3.2303938865662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladwin' limit 1
loadtime:3.2304289340973 / seconds
Query Executed:select id FROM `mi` where city='Gladwin' && SIC_code='5531'DB:business_master_new
loadtime:3.2315819263458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Arbor' limit 1
loadtime:3.2316370010376 / seconds
Query Executed:select id FROM `mi` where city='Glen Arbor' && SIC_code='5531'DB:business_master_new
loadtime:3.2324907779694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn' limit 1
loadtime:3.2325158119202 / seconds
Query Executed:select id FROM `mi` where city='Glenn' && SIC_code='5531'DB:business_master_new
loadtime:3.2342758178711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glennie' limit 1
loadtime:3.2343399524689 / seconds
Query Executed:select id FROM `mi` where city='Glennie' && SIC_code='5531'DB:business_master_new
loadtime:3.2467849254608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gobles' limit 1
loadtime:3.2468400001526 / seconds
Query Executed:select id FROM `mi` where city='Gobles' && SIC_code='5531'DB:business_master_new
loadtime:3.2477979660034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goetzville' limit 1
loadtime:3.2478339672089 / seconds
Query Executed:select id FROM `mi` where city='Goetzville' && SIC_code='5531'DB:business_master_new
loadtime:3.2519629001617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Good Hart' limit 1
loadtime:3.2520189285278 / seconds
Query Executed:select id FROM `mi` where city='Good Hart' && SIC_code='5531'DB:business_master_new
loadtime:3.2524647712708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodells' limit 1
loadtime:3.2524938583374 / seconds
Query Executed:select id FROM `mi` where city='Goodells' && SIC_code='5531'DB:business_master_new
loadtime:3.2641048431396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodrich' limit 1
loadtime:3.2641508579254 / seconds
Query Executed:select id FROM `mi` where city='Goodrich' && SIC_code='5531'DB:business_master_new
loadtime:3.2651648521423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gould City' limit 1
loadtime:3.2652039527893 / seconds
Query Executed:select id FROM `mi` where city='Gould City' && SIC_code='5531'DB:business_master_new
loadtime:3.2694218158722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowen' limit 1
loadtime:3.269476890564 / seconds
Query Executed:select id FROM `mi` where city='Gowen' && SIC_code='5531'DB:business_master_new
loadtime:3.2843379974365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Beach' limit 1
loadtime:3.2843899726868 / seconds
Query Executed:select id FROM `mi` where city='Grand Beach' && SIC_code='5531'DB:business_master_new
loadtime:3.284777879715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Blanc' limit 1
loadtime:3.2848057746887 / seconds
Query Executed:select id FROM `mi` where city='Grand Blanc' && SIC_code='5531'DB:business_master_new
loadtime:3.287398815155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Haven' limit 1
loadtime:3.2874448299408 / seconds
Query Executed:select id FROM `mi` where city='Grand Haven' && SIC_code='5531'DB:business_master_new
loadtime:3.2900128364563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:3.2900619506836 / seconds
Query Executed:select id FROM `mi` where city='Grand Junction' && SIC_code='5531'DB:business_master_new
loadtime:3.3072109222412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Ledge' limit 1
loadtime:3.3072609901428 / seconds
Query Executed:select id FROM `mi` where city='Grand Ledge' && SIC_code='5531'DB:business_master_new
loadtime:3.3084588050842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Marais' limit 1
loadtime:3.3084959983826 / seconds
Query Executed:select id FROM `mi` where city='Grand Marais' && SIC_code='5531'DB:business_master_new
loadtime:3.3154318332672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Rapids' limit 1
loadtime:3.31547498703 / seconds
Query Executed:select id FROM `mi` where city='Grand Rapids' && SIC_code='5531'DB:business_master_new
loadtime:3.3324389457703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandville' limit 1
loadtime:3.3325378894806 / seconds
Query Executed:select id FROM `mi` where city='Grandville' && SIC_code='5531'DB:business_master_new
loadtime:3.3347079753876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:3.3347728252411 / seconds
Query Executed:select id FROM `mi` where city='Grant' && SIC_code='5531'DB:business_master_new
loadtime:3.3360598087311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant Twp' limit 1
loadtime:3.3361098766327 / seconds
Query Executed:select id FROM `mi` where city='Grant Twp' && SIC_code='5531'DB:business_master_new
loadtime:3.336797952652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grass Lake' limit 1
loadtime:3.3368389606476 / seconds
Query Executed:select id FROM `mi` where city='Grass Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.3381268978119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grawn' limit 1
loadtime:3.338173866272 / seconds
Query Executed:select id FROM `mi` where city='Grawn' && SIC_code='5531'DB:business_master_new
loadtime:3.3392989635468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grayling' limit 1
loadtime:3.3393387794495 / seconds
Query Executed:select id FROM `mi` where city='Grayling' && SIC_code='5531'DB:business_master_new
loadtime:3.3410549163818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:3.3411159515381 / seconds
Query Executed:select id FROM `mi` where city='Greenbush' && SIC_code='5531'DB:business_master_new
loadtime:3.3491368293762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:3.3491687774658 / seconds
Query Executed:select id FROM `mi` where city='Greenland' && SIC_code='5531'DB:business_master_new
loadtime:3.3497889041901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:3.3498299121857 / seconds
Query Executed:select id FROM `mi` where city='Greenville' && SIC_code='5531'DB:business_master_new
loadtime:3.3511228561401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:3.3511610031128 / seconds
Query Executed:select id FROM `mi` where city='Greenwood' && SIC_code='5531'DB:business_master_new
loadtime:3.3514318466187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:3.3514709472656 / seconds
Query Executed:select id FROM `mi` where city='Gregory' && SIC_code='5531'DB:business_master_new
loadtime:3.3523848056793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Ile' limit 1
loadtime:3.3524289131165 / seconds
Query Executed:select id FROM `mi` where city='Grosse Ile' && SIC_code='5531'DB:business_master_new
loadtime:3.3534708023071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pointe' limit 1
loadtime:3.3535130023956 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pointe' && SIC_code='5531'DB:business_master_new
loadtime:3.3548769950867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Farms' limit 1
loadtime:3.3549258708954 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Farms' && SIC_code='5531'DB:business_master_new
loadtime:3.3552968502045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Park' limit 1
loadtime:3.3553318977356 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Park' && SIC_code='5531'DB:business_master_new
loadtime:3.3556339740753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Woods' limit 1
loadtime:3.3556749820709 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Woods' && SIC_code='5531'DB:business_master_new
loadtime:3.3559989929199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulliver' limit 1
loadtime:3.3560349941254 / seconds
Query Executed:select id FROM `mi` where city='Gulliver' && SIC_code='5531'DB:business_master_new
loadtime:3.3584849834442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwinn' limit 1
loadtime:3.3585269451141 / seconds
Query Executed:select id FROM `mi` where city='Gwinn' && SIC_code='5531'DB:business_master_new
loadtime:3.3594608306885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:3.3594999313354 / seconds
Query Executed:select id FROM `mi` where city='Hadley' && SIC_code='5531'DB:business_master_new
loadtime:3.3627867698669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagar Shores' limit 1
loadtime:3.3628258705139 / seconds
Query Executed:select id FROM `mi` where city='Hagar Shores' && SIC_code='5531'DB:business_master_new
loadtime:3.3630878925323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hale' limit 1
loadtime:3.3631229400635 / seconds
Query Executed:select id FROM `mi` where city='Hale' && SIC_code='5531'DB:business_master_new
loadtime:3.3640658855438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:3.3640987873077 / seconds
Query Executed:select id FROM `mi` where city='Hamburg' && SIC_code='5531'DB:business_master_new
loadtime:3.3835248947144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:3.3835699558258 / seconds
Query Executed:select id FROM `mi` where city='Hamilton' && SIC_code='5531'DB:business_master_new
loadtime:3.3845508098602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamtramck' limit 1
loadtime:3.3845779895782 / seconds
Query Executed:select id FROM `mi` where city='Hamtramck' && SIC_code='5531'DB:business_master_new
loadtime:3.3855159282684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:3.3855547904968 / seconds
Query Executed:select id FROM `mi` where city='Hancock' && SIC_code='5531'DB:business_master_new
loadtime:3.3865649700165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:3.3865988254547 / seconds
Query Executed:select id FROM `mi` where city='Hanover' && SIC_code='5531'DB:business_master_new
loadtime:3.400671005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbert' limit 1
loadtime:3.4007139205933 / seconds
Query Executed:select id FROM `mi` where city='Harbert' && SIC_code='5531'DB:business_master_new
loadtime:3.4029819965363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Beach' limit 1
loadtime:3.4030230045319 / seconds
Query Executed:select id FROM `mi` where city='Harbor Beach' && SIC_code='5531'DB:business_master_new
loadtime:3.4039809703827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Springs' limit 1
loadtime:3.4040148258209 / seconds
Query Executed:select id FROM `mi` where city='Harbor Springs' && SIC_code='5531'DB:business_master_new
loadtime:3.405158996582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper Woods' limit 1
loadtime:3.4051969051361 / seconds
Query Executed:select id FROM `mi` where city='Harper Woods' && SIC_code='5531'DB:business_master_new
loadtime:3.4061138629913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrietta' limit 1
loadtime:3.4061388969421 / seconds
Query Executed:select id FROM `mi` where city='Harrietta' && SIC_code='5531'DB:business_master_new
loadtime:3.4078989028931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:3.4079477787018 / seconds
Query Executed:select id FROM `mi` where city='Harris' && SIC_code='5531'DB:business_master_new
loadtime:3.4089977741241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:3.4090268611908 / seconds
Query Executed:select id FROM `mi` where city='Harrison' && SIC_code='5531'DB:business_master_new
loadtime:3.4101388454437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Township' limit 1
loadtime:3.410187959671 / seconds
Query Executed:select id FROM `mi` where city='Harrison Township' && SIC_code='5531'DB:business_master_new
loadtime:3.4114339351654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Twp' limit 1
loadtime:3.4114768505096 / seconds
Query Executed:select id FROM `mi` where city='Harrison Twp' && SIC_code='5531'DB:business_master_new
loadtime:3.4154369831085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:3.415492773056 / seconds
Query Executed:select id FROM `mi` where city='Harrisville' && SIC_code='5531'DB:business_master_new
loadtime:3.4169108867645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harsens Island' limit 1
loadtime:3.4169518947601 / seconds
Query Executed:select id FROM `mi` where city='Harsens Island' && SIC_code='5531'DB:business_master_new
loadtime:3.4258999824524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hart' limit 1
loadtime:3.4259309768677 / seconds
Query Executed:select id FROM `mi` where city='Hart' && SIC_code='5531'DB:business_master_new
loadtime:3.4273009300232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:3.4273488521576 / seconds
Query Executed:select id FROM `mi` where city='Hartford' && SIC_code='5531'DB:business_master_new
loadtime:3.4283668994904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:3.4284019470215 / seconds
Query Executed:select id FROM `mi` where city='Hartland' && SIC_code='5531'DB:business_master_new
loadtime:3.4304168224335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:3.4304568767548 / seconds
Query Executed:select id FROM `mi` where city='Harvey' && SIC_code='5531'DB:business_master_new
loadtime:3.4308178424835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haslett' limit 1
loadtime:3.4308459758759 / seconds
Query Executed:select id FROM `mi` where city='Haslett' && SIC_code='5531'DB:business_master_new
loadtime:3.4328727722168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:3.4329419136047 / seconds
Query Executed:select id FROM `mi` where city='Hastings' && SIC_code='5531'DB:business_master_new
loadtime:3.4354619979858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawks' limit 1
loadtime:3.4355869293213 / seconds
Query Executed:select id FROM `mi` where city='Hawks' && SIC_code='5531'DB:business_master_new
loadtime:3.4377808570862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Park' limit 1
loadtime:3.4378309249878 / seconds
Query Executed:select id FROM `mi` where city='Hazel Park' && SIC_code='5531'DB:business_master_new
loadtime:3.4403328895569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemlock' limit 1
loadtime:3.4404909610748 / seconds
Query Executed:select id FROM `mi` where city='Hemlock' && SIC_code='5531'DB:business_master_new
loadtime:3.442174911499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:3.4422318935394 / seconds
Query Executed:select id FROM `mi` where city='Henderson' && SIC_code='5531'DB:business_master_new
loadtime:3.4465329647064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermansville' limit 1
loadtime:3.4465939998627 / seconds
Query Executed:select id FROM `mi` where city='Hermansville' && SIC_code='5531'DB:business_master_new
loadtime:3.4521899223328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herron' limit 1
loadtime:3.452220916748 / seconds
Query Executed:select id FROM `mi` where city='Herron' && SIC_code='5531'DB:business_master_new
loadtime:3.4563717842102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hersey' limit 1
loadtime:3.4564139842987 / seconds
Query Executed:select id FROM `mi` where city='Hersey' && SIC_code='5531'DB:business_master_new
loadtime:3.4632439613342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesperia' limit 1
loadtime:3.4632740020752 / seconds
Query Executed:select id FROM `mi` where city='Hesperia' && SIC_code='5531'DB:business_master_new
loadtime:3.4642028808594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hessel' limit 1
loadtime:3.4642508029938 / seconds
Query Executed:select id FROM `mi` where city='Hessel' && SIC_code='5531'DB:business_master_new
loadtime:3.4733018875122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Corners' limit 1
loadtime:3.4733510017395 / seconds
Query Executed:select id FROM `mi` where city='Hickory Corners' && SIC_code='5531'DB:business_master_new
loadtime:3.4895379543304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higgins Lake' limit 1
loadtime:3.4896678924561 / seconds
Query Executed:select id FROM `mi` where city='Higgins Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.4916579723358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:3.4918019771576 / seconds
Query Executed:select id FROM `mi` where city='Highland' && SIC_code='5531'DB:business_master_new
loadtime:3.4950919151306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Park' limit 1
loadtime:3.4951889514923 / seconds
Query Executed:select id FROM `mi` where city='Highland Park' && SIC_code='5531'DB:business_master_new
loadtime:3.4962828159332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillman' limit 1
loadtime:3.496328830719 / seconds
Query Executed:select id FROM `mi` where city='Hillman' && SIC_code='5531'DB:business_master_new
loadtime:3.5073699951172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:3.5073997974396 / seconds
Query Executed:select id FROM `mi` where city='Hillsdale' && SIC_code='5531'DB:business_master_new
loadtime:3.5086688995361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:3.5087177753448 / seconds
Query Executed:select id FROM `mi` where city='Holland' && SIC_code='5531'DB:business_master_new
loadtime:3.5112648010254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly' limit 1
loadtime:3.5113229751587 / seconds
Query Executed:select id FROM `mi` where city='Holly' && SIC_code='5531'DB:business_master_new
loadtime:3.5125417709351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holt' limit 1
loadtime:3.512598991394 / seconds
Query Executed:select id FROM `mi` where city='Holt' && SIC_code='5531'DB:business_master_new
loadtime:3.5137767791748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holton' limit 1
loadtime:3.5138268470764 / seconds
Query Executed:select id FROM `mi` where city='Holton' && SIC_code='5531'DB:business_master_new
loadtime:3.5274398326874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homer' limit 1
loadtime:3.5274939537048 / seconds
Query Executed:select id FROM `mi` where city='Homer' && SIC_code='5531'DB:business_master_new
loadtime:3.5284698009491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honor' limit 1
loadtime:3.5285167694092 / seconds
Query Executed:select id FROM `mi` where city='Honor' && SIC_code='5531'DB:business_master_new
loadtime:3.5409548282623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:3.540992975235 / seconds
Query Executed:select id FROM `mi` where city='Hope' && SIC_code='5531'DB:business_master_new
loadtime:3.5463478565216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:3.5463898181915 / seconds
Query Executed:select id FROM `mi` where city='Hopkins' && SIC_code='5531'DB:business_master_new
loadtime:3.5473167896271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horton' limit 1
loadtime:3.5473439693451 / seconds
Query Executed:select id FROM `mi` where city='Horton' && SIC_code='5531'DB:business_master_new
loadtime:3.5596950054169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:3.5597379207611 / seconds
Query Executed:select id FROM `mi` where city='Houghton' && SIC_code='5531'DB:business_master_new
loadtime:3.5608229637146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake' limit 1
loadtime:3.5608599185944 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.561824798584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake Heights' limit 1
loadtime:3.5618689060211 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake Heights' && SIC_code='5531'DB:business_master_new
loadtime:3.5626268386841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard City' limit 1
loadtime:3.5626769065857 / seconds
Query Executed:select id FROM `mi` where city='Howard City' && SIC_code='5531'DB:business_master_new
loadtime:3.5636808872223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:3.5637238025665 / seconds
Query Executed:select id FROM `mi` where city='Howell' && SIC_code='5531'DB:business_master_new
loadtime:3.5657858848572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard Lake' limit 1
loadtime:3.5658459663391 / seconds
Query Executed:select id FROM `mi` where city='Hubbard Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.5812540054321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:3.5813069343567 / seconds
Query Executed:select id FROM `mi` where city='Hubbardston' && SIC_code='5531'DB:business_master_new
loadtime:3.5859289169312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbell' limit 1
loadtime:3.5859718322754 / seconds
Query Executed:select id FROM `mi` where city='Hubbell' && SIC_code='5531'DB:business_master_new
loadtime:3.5908939838409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:3.5909237861633 / seconds
Query Executed:select id FROM `mi` where city='Hudson' && SIC_code='5531'DB:business_master_new
loadtime:3.5919268131256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudsonville' limit 1
loadtime:3.5919749736786 / seconds
Query Executed:select id FROM `mi` where city='Hudsonville' && SIC_code='5531'DB:business_master_new
loadtime:3.5932807922363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hulbert' limit 1
loadtime:3.5933158397675 / seconds
Query Executed:select id FROM `mi` where city='Hulbert' && SIC_code='5531'DB:business_master_new
loadtime:3.5950798988342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington Woods' limit 1
loadtime:3.5951278209686 / seconds
Query Executed:select id FROM `mi` where city='Huntington Woods' && SIC_code='5531'DB:business_master_new
loadtime:3.5961298942566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida' limit 1
loadtime:3.5961768627167 / seconds
Query Executed:select id FROM `mi` where city='Ida' && SIC_code='5531'DB:business_master_new
loadtime:3.6126430034637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idlewild' limit 1
loadtime:3.6126759052277 / seconds
Query Executed:select id FROM `mi` where city='Idlewild' && SIC_code='5531'DB:business_master_new
loadtime:3.6151459217072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imlay City' limit 1
loadtime:3.6151888370514 / seconds
Query Executed:select id FROM `mi` where city='Imlay City' && SIC_code='5531'DB:business_master_new
loadtime:3.6162648200989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian River' limit 1
loadtime:3.6163008213043 / seconds
Query Executed:select id FROM `mi` where city='Indian River' && SIC_code='5531'DB:business_master_new
loadtime:3.6173129081726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingalls' limit 1
loadtime:3.6173598766327 / seconds
Query Executed:select id FROM `mi` where city='Ingalls' && SIC_code='5531'DB:business_master_new
loadtime:3.618273973465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inkster' limit 1
loadtime:3.6183099746704 / seconds
Query Executed:select id FROM `mi` where city='Inkster' && SIC_code='5531'DB:business_master_new
loadtime:3.6200878620148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interlochen' limit 1
loadtime:3.6202409267426 / seconds
Query Executed:select id FROM `mi` where city='Interlochen' && SIC_code='5531'DB:business_master_new
loadtime:3.6222598552704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:3.6223139762878 / seconds
Query Executed:select id FROM `mi` where city='Ionia' && SIC_code='5531'DB:business_master_new
loadtime:3.625207901001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:3.6252748966217 / seconds
Query Executed:select id FROM `mi` where city='Ira' && SIC_code='5531'DB:business_master_new
loadtime:3.6256768703461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Mountain' limit 1
loadtime:3.6257839202881 / seconds
Query Executed:select id FROM `mi` where city='Iron Mountain' && SIC_code='5531'DB:business_master_new
loadtime:3.6292629241943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron River' limit 1
loadtime:3.6293909549713 / seconds
Query Executed:select id FROM `mi` where city='Iron River' && SIC_code='5531'DB:business_master_new
loadtime:3.6313138008118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irons' limit 1
loadtime:3.6313719749451 / seconds
Query Executed:select id FROM `mi` where city='Irons' && SIC_code='5531'DB:business_master_new
loadtime:3.6388108730316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironwood' limit 1
loadtime:3.6388468742371 / seconds
Query Executed:select id FROM `mi` where city='Ironwood' && SIC_code='5531'DB:business_master_new
loadtime:3.6399879455566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ishpeming' limit 1
loadtime:3.6400399208069 / seconds
Query Executed:select id FROM `mi` where city='Ishpeming' && SIC_code='5531'DB:business_master_new
loadtime:3.6411418914795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ithaca' limit 1
loadtime:3.6411778926849 / seconds
Query Executed:select id FROM `mi` where city='Ithaca' && SIC_code='5531'DB:business_master_new
loadtime:3.6422379016876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:3.642285823822 / seconds
Query Executed:select id FROM `mi` where city='Jackson' && SIC_code='5531'DB:business_master_new
loadtime:3.6449859142303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:3.6450598239899 / seconds
Query Executed:select id FROM `mi` where city='Jamestown' && SIC_code='5531'DB:business_master_new
loadtime:3.6466608047485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jasper' limit 1
loadtime:3.646696805954 / seconds
Query Executed:select id FROM `mi` where city='Jasper' && SIC_code='5531'DB:business_master_new
loadtime:3.6514158248901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeddo' limit 1
loadtime:3.6514718532562 / seconds
Query Executed:select id FROM `mi` where city='Jeddo' && SIC_code='5531'DB:business_master_new
loadtime:3.6591739654541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenison' limit 1
loadtime:3.6592059135437 / seconds
Query Executed:select id FROM `mi` where city='Jenison' && SIC_code='5531'DB:business_master_new
loadtime:3.66060090065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:3.6606659889221 / seconds
Query Executed:select id FROM `mi` where city='Jerome' && SIC_code='5531'DB:business_master_new
loadtime:3.6669609546661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johannesburg' limit 1
loadtime:3.6670138835907 / seconds
Query Executed:select id FROM `mi` where city='Johannesburg' && SIC_code='5531'DB:business_master_new
loadtime:3.6684889793396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jones' limit 1
loadtime:3.6685378551483 / seconds
Query Executed:select id FROM `mi` where city='Jones' && SIC_code='5531'DB:business_master_new
loadtime:3.6729078292847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:3.6729369163513 / seconds
Query Executed:select id FROM `mi` where city='Jonesville' && SIC_code='5531'DB:business_master_new
loadtime:3.6739549636841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalamazoo' limit 1
loadtime:3.6740028858185 / seconds
Query Executed:select id FROM `mi` where city='Kalamazoo' && SIC_code='5531'DB:business_master_new
loadtime:3.6900708675385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaleva' limit 1
loadtime:3.6901478767395 / seconds
Query Executed:select id FROM `mi` where city='Kaleva' && SIC_code='5531'DB:business_master_new
loadtime:3.6985599994659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalkaska' limit 1
loadtime:3.6985969543457 / seconds
Query Executed:select id FROM `mi` where city='Kalkaska' && SIC_code='5531'DB:business_master_new
loadtime:3.6997277736664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Karlin' limit 1
loadtime:3.6997799873352 / seconds
Query Executed:select id FROM `mi` where city='Karlin' && SIC_code='5531'DB:business_master_new
loadtime:3.7000408172607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kawkawlin' limit 1
loadtime:3.7000679969788 / seconds
Query Executed:select id FROM `mi` where city='Kawkawlin' && SIC_code='5531'DB:business_master_new
loadtime:3.7010269165039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:3.7010729312897 / seconds
Query Executed:select id FROM `mi` where city='Kearsarge' && SIC_code='5531'DB:business_master_new
loadtime:3.7015857696533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keego Harbor' limit 1
loadtime:3.7016289234161 / seconds
Query Executed:select id FROM `mi` where city='Keego Harbor' && SIC_code='5531'DB:business_master_new
loadtime:3.7027018070221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:3.7027509212494 / seconds
Query Executed:select id FROM `mi` where city='Kendall' && SIC_code='5531'DB:business_master_new
loadtime:3.703421831131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenockee' limit 1
loadtime:3.7034487724304 / seconds
Query Executed:select id FROM `mi` where city='Kenockee' && SIC_code='5531'DB:business_master_new
loadtime:3.7037189006805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent City' limit 1
loadtime:3.7037568092346 / seconds
Query Executed:select id FROM `mi` where city='Kent City' && SIC_code='5531'DB:business_master_new
loadtime:3.7046449184418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kentwood' limit 1
loadtime:3.7046809196472 / seconds
Query Executed:select id FROM `mi` where city='Kentwood' && SIC_code='5531'DB:business_master_new
loadtime:3.7075369358063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewadin' limit 1
loadtime:3.7075638771057 / seconds
Query Executed:select id FROM `mi` where city='Kewadin' && SIC_code='5531'DB:business_master_new
loadtime:3.7219579219818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keweenaw Bay' limit 1
loadtime:3.7220098972321 / seconds
Query Executed:select id FROM `mi` where city='Keweenaw Bay' && SIC_code='5531'DB:business_master_new
loadtime:3.7223289012909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:3.7223567962646 / seconds
Query Executed:select id FROM `mi` where city='Kimball' && SIC_code='5531'DB:business_master_new
loadtime:3.7231919765472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kincheloe' limit 1
loadtime:3.7232308387756 / seconds
Query Executed:select id FROM `mi` where city='Kincheloe' && SIC_code='5531'DB:business_master_new
loadtime:3.7394418716431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinde' limit 1
loadtime:3.7394828796387 / seconds
Query Executed:select id FROM `mi` where city='Kinde' && SIC_code='5531'DB:business_master_new
loadtime:3.7483189105988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsford' limit 1
loadtime:3.7483718395233 / seconds
Query Executed:select id FROM `mi` where city='Kingsford' && SIC_code='5531'DB:business_master_new
loadtime:3.7493839263916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:3.7494177818298 / seconds
Query Executed:select id FROM `mi` where city='Kingsley' && SIC_code='5531'DB:business_master_new
loadtime:3.7504639625549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:3.7505218982697 / seconds
Query Executed:select id FROM `mi` where city='Kingston' && SIC_code='5531'DB:business_master_new
loadtime:3.7632949352264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:3.7633438110352 / seconds
Query Executed:select id FROM `mi` where city='Kinross' && SIC_code='5531'DB:business_master_new
loadtime:3.7669839859009 / seconds
Query loaded from cache:select * from geodata_geocity where city='L Anse' limit 1
loadtime:3.7670149803162 / seconds
Query Executed:select id FROM `mi` where city='L Anse' && SIC_code='5531'DB:business_master_new
loadtime:3.7677009105682 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Salle' limit 1
loadtime:3.7677419185638 / seconds
Query Executed:select id FROM `mi` where city='La Salle' && SIC_code='5531'DB:business_master_new
loadtime:3.7756268978119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lachine' limit 1
loadtime:3.7756569385529 / seconds
Query Executed:select id FROM `mi` where city='Lachine' && SIC_code='5531'DB:business_master_new
loadtime:3.7813668251038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacota' limit 1
loadtime:3.7814078330994 / seconds
Query Executed:select id FROM `mi` where city='Lacota' && SIC_code='5531'DB:business_master_new
loadtime:3.7817008495331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laingsburg' limit 1
loadtime:3.7817277908325 / seconds
Query Executed:select id FROM `mi` where city='Laingsburg' && SIC_code='5531'DB:business_master_new
loadtime:3.7827308177948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:3.7827808856964 / seconds
Query Executed:select id FROM `mi` where city='Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.7939219474792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Angelus' limit 1
loadtime:3.7939667701721 / seconds
Query Executed:select id FROM `mi` where city='Lake Angelus' && SIC_code='5531'DB:business_master_new
loadtime:3.7944598197937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Ann' limit 1
loadtime:3.7945008277893 / seconds
Query Executed:select id FROM `mi` where city='Lake Ann' && SIC_code='5531'DB:business_master_new
loadtime:3.8098728656769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:3.8099157810211 / seconds
Query Executed:select id FROM `mi` where city='Lake City' && SIC_code='5531'DB:business_master_new
loadtime:3.8110089302063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake George' limit 1
loadtime:3.8110449314117 / seconds
Query Executed:select id FROM `mi` where city='Lake George' && SIC_code='5531'DB:business_master_new
loadtime:3.81334400177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Leelanau' limit 1
loadtime:3.8133838176727 / seconds
Query Executed:select id FROM `mi` where city='Lake Leelanau' && SIC_code='5531'DB:business_master_new
loadtime:3.8143239021301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Linden' limit 1
loadtime:3.8143579959869 / seconds
Query Executed:select id FROM `mi` where city='Lake Linden' && SIC_code='5531'DB:business_master_new
loadtime:3.826132774353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Odessa' limit 1
loadtime:3.8261749744415 / seconds
Query Executed:select id FROM `mi` where city='Lake Odessa' && SIC_code='5531'DB:business_master_new
loadtime:3.8271780014038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Orion' limit 1
loadtime:3.8272228240967 / seconds
Query Executed:select id FROM `mi` where city='Lake Orion' && SIC_code='5531'DB:business_master_new
loadtime:3.8288707733154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeland' limit 1
loadtime:3.8289217948914 / seconds
Query Executed:select id FROM `mi` where city='Lakeland' && SIC_code='5531'DB:business_master_new
loadtime:3.8314838409424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeport' limit 1
loadtime:3.8315138816833 / seconds
Query Executed:select id FROM `mi` where city='Lakeport' && SIC_code='5531'DB:business_master_new
loadtime:3.8318018913269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:3.8318378925323 / seconds
Query Executed:select id FROM `mi` where city='Lakeside' && SIC_code='5531'DB:business_master_new
loadtime:3.8338859081268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:3.8339228630066 / seconds
Query Executed:select id FROM `mi` where city='Lakeview' && SIC_code='5531'DB:business_master_new
loadtime:3.8349409103394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:3.8349759578705 / seconds
Query Executed:select id FROM `mi` where city='Lakeville' && SIC_code='5531'DB:business_master_new
loadtime:3.8364357948303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambertville' limit 1
loadtime:3.836473941803 / seconds
Query Executed:select id FROM `mi` where city='Lambertville' && SIC_code='5531'DB:business_master_new
loadtime:3.8375179767609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:3.8375508785248 / seconds
Query Executed:select id FROM `mi` where city='Lamont' && SIC_code='5531'DB:business_master_new
loadtime:3.8380358219147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanse' limit 1
loadtime:3.8380799293518 / seconds
Query Executed:select id FROM `mi` where city='Lanse' && SIC_code='5531'DB:business_master_new
loadtime:3.8390929698944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:3.8391299247742 / seconds
Query Executed:select id FROM `mi` where city='Lansing' && SIC_code='5531'DB:business_master_new
loadtime:3.8556928634644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapeer' limit 1
loadtime:3.8557798862457 / seconds
Query Executed:select id FROM `mi` where city='Lapeer' && SIC_code='5531'DB:business_master_new
loadtime:3.8573999404907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lathrup Village' limit 1
loadtime:3.8574819564819 / seconds
Query Executed:select id FROM `mi` where city='Lathrup Village' && SIC_code='5531'DB:business_master_new
loadtime:3.8619568347931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurium' limit 1
loadtime:3.8619937896729 / seconds
Query Executed:select id FROM `mi` where city='Laurium' && SIC_code='5531'DB:business_master_new
loadtime:3.8628997802734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:3.8629429340363 / seconds
Query Executed:select id FROM `mi` where city='Lawrence' && SIC_code='5531'DB:business_master_new
loadtime:3.8795409202576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:3.8795728683472 / seconds
Query Executed:select id FROM `mi` where city='Lawton' && SIC_code='5531'DB:business_master_new
loadtime:3.8805568218231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Roy' limit 1
loadtime:3.8805978298187 / seconds
Query Executed:select id FROM `mi` where city='Le Roy' && SIC_code='5531'DB:business_master_new
loadtime:3.8809089660645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:3.8809359073639 / seconds
Query Executed:select id FROM `mi` where city='Leland' && SIC_code='5531'DB:business_master_new
loadtime:3.8957087993622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennon' limit 1
loadtime:3.8957538604736 / seconds
Query Executed:select id FROM `mi` where city='Lennon' && SIC_code='5531'DB:business_master_new
loadtime:3.9015538692474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:3.9015839099884 / seconds
Query Executed:select id FROM `mi` where city='Lenox' && SIC_code='5531'DB:business_master_new
loadtime:3.9021978378296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonard' limit 1
loadtime:3.9022378921509 / seconds
Query Executed:select id FROM `mi` where city='Leonard' && SIC_code='5531'DB:business_master_new
loadtime:3.9032309055328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonidas' limit 1
loadtime:3.9032688140869 / seconds
Query Executed:select id FROM `mi` where city='Leonidas' && SIC_code='5531'DB:business_master_new
loadtime:3.9040739536285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leroy' limit 1
loadtime:3.9041068553925 / seconds
Query Executed:select id FROM `mi` where city='Leroy' && SIC_code='5531'DB:business_master_new
loadtime:3.9157338142395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leslie' limit 1
loadtime:3.9157919883728 / seconds
Query Executed:select id FROM `mi` where city='Leslie' && SIC_code='5531'DB:business_master_new
loadtime:3.9168307781219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levering' limit 1
loadtime:3.9168689250946 / seconds
Query Executed:select id FROM `mi` where city='Levering' && SIC_code='5531'DB:business_master_new
loadtime:3.921642780304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:3.9217088222504 / seconds
Query Executed:select id FROM `mi` where city='Lewiston' && SIC_code='5531'DB:business_master_new
loadtime:3.9303228855133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:3.9303569793701 / seconds
Query Executed:select id FROM `mi` where city='Lexington' && SIC_code='5531'DB:business_master_new
loadtime:3.9313778877258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limestone' limit 1
loadtime:3.931421995163 / seconds
Query Executed:select id FROM `mi` where city='Limestone' && SIC_code='5531'DB:business_master_new
loadtime:3.9317228794098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:3.9317488670349 / seconds
Query Executed:select id FROM `mi` where city='Lincoln' && SIC_code='5531'DB:business_master_new
loadtime:3.9434218406677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln Park' limit 1
loadtime:3.9434788227081 / seconds
Query Executed:select id FROM `mi` where city='Lincoln Park' && SIC_code='5531'DB:business_master_new
loadtime:3.9445858001709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:3.9446458816528 / seconds
Query Executed:select id FROM `mi` where city='Linden' && SIC_code='5531'DB:business_master_new
loadtime:3.9457018375397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:3.945729970932 / seconds
Query Executed:select id FROM `mi` where city='Linwood' && SIC_code='5531'DB:business_master_new
loadtime:3.9467039108276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:3.9467599391937 / seconds
Query Executed:select id FROM `mi` where city='Litchfield' && SIC_code='5531'DB:business_master_new
loadtime:3.9476809501648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Lake' limit 1
loadtime:3.9477109909058 / seconds
Query Executed:select id FROM `mi` where city='Little Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.949364900589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livonia' limit 1
loadtime:3.9494128227234 / seconds
Query Executed:select id FROM `mi` where city='Livonia' && SIC_code='5531'DB:business_master_new
loadtime:3.9512178897858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Lake' limit 1
loadtime:3.9512557983398 / seconds
Query Executed:select id FROM `mi` where city='Long Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.9520897865295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:3.9521508216858 / seconds
Query Executed:select id FROM `mi` where city='Loretto' && SIC_code='5531'DB:business_master_new
loadtime:3.9524707794189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:3.9525058269501 / seconds
Query Executed:select id FROM `mi` where city='Lowell' && SIC_code='5531'DB:business_master_new
loadtime:3.9536848068237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludington' limit 1
loadtime:3.9537258148193 / seconds
Query Executed:select id FROM `mi` where city='Ludington' && SIC_code='5531'DB:business_master_new
loadtime:3.9551079273224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna Pier' limit 1
loadtime:3.9551558494568 / seconds
Query Executed:select id FROM `mi` where city='Luna Pier' && SIC_code='5531'DB:business_master_new
loadtime:3.961877822876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:3.9619147777557 / seconds
Query Executed:select id FROM `mi` where city='Lupton' && SIC_code='5531'DB:business_master_new
loadtime:3.9639599323273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:3.9640028476715 / seconds
Query Executed:select id FROM `mi` where city='Luther' && SIC_code='5531'DB:business_master_new
loadtime:3.9680647850037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:3.9680948257446 / seconds
Query Executed:select id FROM `mi` where city='Luzerne' && SIC_code='5531'DB:business_master_new
loadtime:3.970538854599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:3.9705858230591 / seconds
Query Executed:select id FROM `mi` where city='Lynn' && SIC_code='5531'DB:business_master_new
loadtime:3.9708938598633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:3.9709198474884 / seconds
Query Executed:select id FROM `mi` where city='Lyons' && SIC_code='5531'DB:business_master_new
loadtime:3.9749619960785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macatawa' limit 1
loadtime:3.9750008583069 / seconds
Query Executed:select id FROM `mi` where city='Macatawa' && SIC_code='5531'DB:business_master_new
loadtime:3.9778017997742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinac Island' limit 1
loadtime:3.9778418540955 / seconds
Query Executed:select id FROM `mi` where city='Mackinac Island' && SIC_code='5531'DB:business_master_new
loadtime:3.9787878990173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinaw City' limit 1
loadtime:3.9788138866425 / seconds
Query Executed:select id FROM `mi` where city='Mackinaw City' && SIC_code='5531'DB:business_master_new
loadtime:3.9797899723053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macomb' limit 1
loadtime:3.979829788208 / seconds
Query Executed:select id FROM `mi` where city='Macomb' && SIC_code='5531'DB:business_master_new
loadtime:3.9813230037689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:3.9813590049744 / seconds
Query Executed:select id FROM `mi` where city='Madison Heights' && SIC_code='5531'DB:business_master_new
loadtime:3.9831578731537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mancelona' limit 1
loadtime:3.9832489490509 / seconds
Query Executed:select id FROM `mi` where city='Mancelona' && SIC_code='5531'DB:business_master_new
loadtime:3.9842758178711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:3.9843258857727 / seconds
Query Executed:select id FROM `mi` where city='Manchester' && SIC_code='5531'DB:business_master_new
loadtime:3.985298871994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistee' limit 1
loadtime:3.9853568077087 / seconds
Query Executed:select id FROM `mi` where city='Manistee' && SIC_code='5531'DB:business_master_new
loadtime:3.9866688251495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistique' limit 1
loadtime:3.986713886261 / seconds
Query Executed:select id FROM `mi` where city='Manistique' && SIC_code='5531'DB:business_master_new
loadtime:3.9876477718353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitou Beach' limit 1
loadtime:3.9877038002014 / seconds
Query Executed:select id FROM `mi` where city='Manitou Beach' && SIC_code='5531'DB:business_master_new
loadtime:4.001030921936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manton' limit 1
loadtime:4.0010797977448 / seconds
Query Executed:select id FROM `mi` where city='Manton' && SIC_code='5531'DB:business_master_new
loadtime:4.0020778179169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple City' limit 1
loadtime:4.0021169185638 / seconds
Query Executed:select id FROM `mi` where city='Maple City' && SIC_code='5531'DB:business_master_new
loadtime:4.0030488967896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Rapids' limit 1
loadtime:4.0030908584595 / seconds
Query Executed:select id FROM `mi` where city='Maple Rapids' && SIC_code='5531'DB:business_master_new
loadtime:4.0057878494263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcellus' limit 1
loadtime:4.0058169364929 / seconds
Query Executed:select id FROM `mi` where city='Marcellus' && SIC_code='5531'DB:business_master_new
loadtime:4.0067839622498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marenisco' limit 1
loadtime:4.0068538188934 / seconds
Query Executed:select id FROM `mi` where city='Marenisco' && SIC_code='5531'DB:business_master_new
loadtime:4.0099918842316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marine City' limit 1
loadtime:4.010036945343 / seconds
Query Executed:select id FROM `mi` where city='Marine City' && SIC_code='5531'DB:business_master_new
loadtime:4.0111157894135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:4.0111649036407 / seconds
Query Executed:select id FROM `mi` where city='Marion' && SIC_code='5531'DB:business_master_new
loadtime:4.0121479034424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlette' limit 1
loadtime:4.0121898651123 / seconds
Query Executed:select id FROM `mi` where city='Marlette' && SIC_code='5531'DB:business_master_new
loadtime:4.0132868289948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:4.0133349895477 / seconds
Query Executed:select id FROM `mi` where city='Marne' && SIC_code='5531'DB:business_master_new
loadtime:4.0143427848816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:4.0143988132477 / seconds
Query Executed:select id FROM `mi` where city='Marquette' && SIC_code='5531'DB:business_master_new
loadtime:4.0161199569702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:4.0161678791046 / seconds
Query Executed:select id FROM `mi` where city='Marshall' && SIC_code='5531'DB:business_master_new
loadtime:4.0174949169159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:4.0175549983978 / seconds
Query Executed:select id FROM `mi` where city='Martin' && SIC_code='5531'DB:business_master_new
loadtime:4.0245068073273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysville' limit 1
loadtime:4.0245440006256 / seconds
Query Executed:select id FROM `mi` where city='Marysville' && SIC_code='5531'DB:business_master_new
loadtime:4.0256350040436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:4.0256857872009 / seconds
Query Executed:select id FROM `mi` where city='Mason' && SIC_code='5531'DB:business_master_new
loadtime:4.0270328521729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mass City' limit 1
loadtime:4.0270738601685 / seconds
Query Executed:select id FROM `mi` where city='Mass City' && SIC_code='5531'DB:business_master_new
loadtime:4.0283558368683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattawan' limit 1
loadtime:4.0284068584442 / seconds
Query Executed:select id FROM `mi` where city='Mattawan' && SIC_code='5531'DB:business_master_new
loadtime:4.0295128822327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybee' limit 1
loadtime:4.0295698642731 / seconds
Query Executed:select id FROM `mi` where city='Maybee' && SIC_code='5531'DB:business_master_new
loadtime:4.0370228290558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:4.0370738506317 / seconds
Query Executed:select id FROM `mi` where city='Mayfield' && SIC_code='5531'DB:business_master_new
loadtime:4.0378708839417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayville' limit 1
loadtime:4.0379309654236 / seconds
Query Executed:select id FROM `mi` where city='Mayville' && SIC_code='5531'DB:business_master_new
loadtime:4.0388829708099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bain' limit 1
loadtime:4.0389189720154 / seconds
Query Executed:select id FROM `mi` where city='Mc Bain' && SIC_code='5531'DB:business_master_new
loadtime:4.0398418903351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Millan' limit 1
loadtime:4.0398910045624 / seconds
Query Executed:select id FROM `mi` where city='Mc Millan' && SIC_code='5531'DB:business_master_new
loadtime:4.044056892395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcbrides' limit 1
loadtime:4.0440948009491 / seconds
Query Executed:select id FROM `mi` where city='Mcbrides' && SIC_code='5531'DB:business_master_new
loadtime:4.0458929538727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:4.0459339618683 / seconds
Query Executed:select id FROM `mi` where city='Mears' && SIC_code='5531'DB:business_master_new
loadtime:4.0502889156342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mecosta' limit 1
loadtime:4.0503468513489 / seconds
Query Executed:select id FROM `mi` where city='Mecosta' && SIC_code='5531'DB:business_master_new
loadtime:4.0513730049133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:4.051421880722 / seconds
Query Executed:select id FROM `mi` where city='Melvin' && SIC_code='5531'DB:business_master_new
loadtime:4.0531618595123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvindale' limit 1
loadtime:4.0532088279724 / seconds
Query Executed:select id FROM `mi` where city='Melvindale' && SIC_code='5531'DB:business_master_new
loadtime:4.0541768074036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Memphis' limit 1
loadtime:4.0542078018188 / seconds
Query Executed:select id FROM `mi` where city='Memphis' && SIC_code='5531'DB:business_master_new
loadtime:4.055205821991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:4.055252790451 / seconds
Query Executed:select id FROM `mi` where city='Mendon' && SIC_code='5531'DB:business_master_new
loadtime:4.0597319602966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menominee' limit 1
loadtime:4.0597639083862 / seconds
Query Executed:select id FROM `mi` where city='Menominee' && SIC_code='5531'DB:business_master_new
loadtime:4.0608909130096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:4.0609359741211 / seconds
Query Executed:select id FROM `mi` where city='Merrill' && SIC_code='5531'DB:business_master_new
loadtime:4.0618498325348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:4.0618839263916 / seconds
Query Executed:select id FROM `mi` where city='Merritt' && SIC_code='5531'DB:business_master_new
loadtime:4.0638608932495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesick' limit 1
loadtime:4.0638988018036 / seconds
Query Executed:select id FROM `mi` where city='Mesick' && SIC_code='5531'DB:business_master_new
loadtime:4.0648210048676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metamora' limit 1
loadtime:4.0648539066315 / seconds
Query Executed:select id FROM `mi` where city='Metamora' && SIC_code='5531'DB:business_master_new
loadtime:4.0658488273621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michiana' limit 1
loadtime:4.065887928009 / seconds
Query Executed:select id FROM `mi` where city='Michiana' && SIC_code='5531'DB:business_master_new
loadtime:4.0661518573761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigamme' limit 1
loadtime:4.066193819046 / seconds
Query Executed:select id FROM `mi` where city='Michigamme' && SIC_code='5531'DB:business_master_new
loadtime:4.0677897930145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan Center' limit 1
loadtime:4.067822933197 / seconds
Query Executed:select id FROM `mi` where city='Michigan Center' && SIC_code='5531'DB:business_master_new
loadtime:4.0687668323517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:4.0688099861145 / seconds
Query Executed:select id FROM `mi` where city='Middleton' && SIC_code='5531'DB:business_master_new
loadtime:4.0707128047943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleville' limit 1
loadtime:4.0707399845123 / seconds
Query Executed:select id FROM `mi` where city='Middleville' && SIC_code='5531'DB:business_master_new
loadtime:4.0717849731445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:4.0718278884888 / seconds
Query Executed:select id FROM `mi` where city='Midland' && SIC_code='5531'DB:business_master_new
loadtime:4.0738849639893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikado' limit 1
loadtime:4.0739259719849 / seconds
Query Executed:select id FROM `mi` where city='Mikado' && SIC_code='5531'DB:business_master_new
loadtime:4.0786318778992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:4.0786728858948 / seconds
Query Executed:select id FROM `mi` where city='Milan' && SIC_code='5531'DB:business_master_new
loadtime:4.0795948505402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:4.0796349048615 / seconds
Query Executed:select id FROM `mi` where city='Milford' && SIC_code='5531'DB:business_master_new
loadtime:4.0809469223022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:4.0809919834137 / seconds
Query Executed:select id FROM `mi` where city='Millersburg' && SIC_code='5531'DB:business_master_new
loadtime:4.0836567878723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millington' limit 1
loadtime:4.0836958885193 / seconds
Query Executed:select id FROM `mi` where city='Millington' && SIC_code='5531'DB:business_master_new
loadtime:4.08473777771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden City' limit 1
loadtime:4.0847718715668 / seconds
Query Executed:select id FROM `mi` where city='Minden City' && SIC_code='5531'DB:business_master_new
loadtime:4.0879778862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mio' limit 1
loadtime:4.0880188941956 / seconds
Query Executed:select id FROM `mi` where city='Mio' && SIC_code='5531'DB:business_master_new
loadtime:4.0890169143677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohawk' limit 1
loadtime:4.0890529155731 / seconds
Query Executed:select id FROM `mi` where city='Mohawk' && SIC_code='5531'DB:business_master_new
loadtime:4.0907340049744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moline' limit 1
loadtime:4.0907869338989 / seconds
Query Executed:select id FROM `mi` where city='Moline' && SIC_code='5531'DB:business_master_new
loadtime:4.0918369293213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:4.0918629169464 / seconds
Query Executed:select id FROM `mi` where city='Monroe' && SIC_code='5531'DB:business_master_new
loadtime:4.093761920929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:4.0938138961792 / seconds
Query Executed:select id FROM `mi` where city='Montague' && SIC_code='5531'DB:business_master_new
loadtime:4.0947999954224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:4.0948448181152 / seconds
Query Executed:select id FROM `mi` where city='Montgomery' && SIC_code='5531'DB:business_master_new
loadtime:4.0993158817291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:4.0993909835815 / seconds
Query Executed:select id FROM `mi` where city='Montrose' && SIC_code='5531'DB:business_master_new
loadtime:4.1004889011383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moran' limit 1
loadtime:4.1005408763885 / seconds
Query Executed:select id FROM `mi` where city='Moran' && SIC_code='5531'DB:business_master_new
loadtime:4.1018958091736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:4.1019389629364 / seconds
Query Executed:select id FROM `mi` where city='Morenci' && SIC_code='5531'DB:business_master_new
loadtime:4.1029009819031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:4.1029479503632 / seconds
Query Executed:select id FROM `mi` where city='Morley' && SIC_code='5531'DB:business_master_new
loadtime:4.108726978302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrice' limit 1
loadtime:4.1087639331818 / seconds
Query Executed:select id FROM `mi` where city='Morrice' && SIC_code='5531'DB:business_master_new
loadtime:4.1141917705536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:4.1142489910126 / seconds
Query Executed:select id FROM `mi` where city='Moscow' && SIC_code='5531'DB:business_master_new
loadtime:4.1145889759064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosherville' limit 1
loadtime:4.1146278381348 / seconds
Query Executed:select id FROM `mi` where city='Mosherville' && SIC_code='5531'DB:business_master_new
loadtime:4.1149988174438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Clemens' limit 1
loadtime:4.1150419712067 / seconds
Query Executed:select id FROM `mi` where city='Mount Clemens' && SIC_code='5531'DB:business_master_new
loadtime:4.1165459156036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Morris' limit 1
loadtime:4.116602897644 / seconds
Query Executed:select id FROM `mi` where city='Mount Morris' && SIC_code='5531'DB:business_master_new
loadtime:4.1178147792816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:4.1178529262543 / seconds
Query Executed:select id FROM `mi` where city='Mount Pleasant' && SIC_code='5531'DB:business_master_new
loadtime:4.119687795639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Clemens' limit 1
loadtime:4.1197509765625 / seconds
Query Executed:select id FROM `mi` where city='Mt Clemens' && SIC_code='5531'DB:business_master_new
loadtime:4.1230828762054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Morris' limit 1
loadtime:4.1231198310852 / seconds
Query Executed:select id FROM `mi` where city='Mt Morris' && SIC_code='5531'DB:business_master_new
loadtime:4.1234438419342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:4.1234948635101 / seconds
Query Executed:select id FROM `mi` where city='Mt Pleasant' && SIC_code='5531'DB:business_master_new
loadtime:4.1295819282532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muir' limit 1
loadtime:4.1296129226685 / seconds
Query Executed:select id FROM `mi` where city='Muir' && SIC_code='5531'DB:business_master_new
loadtime:4.1318209171295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullett Lake' limit 1
loadtime:4.1318769454956 / seconds
Query Executed:select id FROM `mi` where city='Mullett Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.1321759223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulliken' limit 1
loadtime:4.1322159767151 / seconds
Query Executed:select id FROM `mi` where city='Mulliken' && SIC_code='5531'DB:business_master_new
loadtime:4.1351327896118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munger' limit 1
loadtime:4.1351869106293 / seconds
Query Executed:select id FROM `mi` where city='Munger' && SIC_code='5531'DB:business_master_new
loadtime:4.1391019821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munising' limit 1
loadtime:4.1391429901123 / seconds
Query Executed:select id FROM `mi` where city='Munising' && SIC_code='5531'DB:business_master_new
loadtime:4.1402168273926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munith' limit 1
loadtime:4.1402537822723 / seconds
Query Executed:select id FROM `mi` where city='Munith' && SIC_code='5531'DB:business_master_new
loadtime:4.1480708122253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon' limit 1
loadtime:4.1481227874756 / seconds
Query Executed:select id FROM `mi` where city='Muskegon' && SIC_code='5531'DB:business_master_new
loadtime:4.1512179374695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon Heights' limit 1
loadtime:4.151270866394 / seconds
Query Executed:select id FROM `mi` where city='Muskegon Heights' && SIC_code='5531'DB:business_master_new
loadtime:4.1520659923553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mussey' limit 1
loadtime:4.1521089076996 / seconds
Query Executed:select id FROM `mi` where city='Mussey' && SIC_code='5531'DB:business_master_new
loadtime:4.1524357795715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nadeau' limit 1
loadtime:4.1524620056152 / seconds
Query Executed:select id FROM `mi` where city='Nadeau' && SIC_code='5531'DB:business_master_new
loadtime:4.1532378196716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahma' limit 1
loadtime:4.1533010005951 / seconds
Query Executed:select id FROM `mi` where city='Nahma' && SIC_code='5531'DB:business_master_new
loadtime:4.1536459922791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Napoleon' limit 1
loadtime:4.1536738872528 / seconds
Query Executed:select id FROM `mi` where city='Napoleon' && SIC_code='5531'DB:business_master_new
loadtime:4.1607069969177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:4.1607489585876 / seconds
Query Executed:select id FROM `mi` where city='Nashville' && SIC_code='5531'DB:business_master_new
loadtime:4.1617109775543 / seconds
Query loaded from cache:select * from geodata_geocity where city='National City' limit 1
loadtime:4.1617579460144 / seconds
Query Executed:select id FROM `mi` where city='National City' && SIC_code='5531'DB:business_master_new
loadtime:4.1649677753448 / seconds
Query loaded from cache:select * from geodata_geocity where city='National Mine' limit 1
loadtime:4.1649978160858 / seconds
Query Executed:select id FROM `mi` where city='National Mine' && SIC_code='5531'DB:business_master_new
loadtime:4.1653017997742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naubinway' limit 1
loadtime:4.1653490066528 / seconds
Query Executed:select id FROM `mi` where city='Naubinway' && SIC_code='5531'DB:business_master_new
loadtime:4.1678287982941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazareth' limit 1
loadtime:4.1678688526154 / seconds
Query Executed:select id FROM `mi` where city='Nazareth' && SIC_code='5531'DB:business_master_new
loadtime:4.1684730052948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Negaunee' limit 1
loadtime:4.1685168743134 / seconds
Query Executed:select id FROM `mi` where city='Negaunee' && SIC_code='5531'DB:business_master_new
loadtime:4.1695599555969 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Baltimore' limit 1
loadtime:4.1695950031281 / seconds
Query Executed:select id FROM `mi` where city='New Baltimore' && SIC_code='5531'DB:business_master_new
loadtime:4.1713778972626 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:4.1714417934418 / seconds
Query Executed:select id FROM `mi` where city='New Boston' && SIC_code='5531'DB:business_master_new
loadtime:4.1875019073486 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Buffalo' limit 1
loadtime:4.1875519752502 / seconds
Query Executed:select id FROM `mi` where city='New Buffalo' && SIC_code='5531'DB:business_master_new
loadtime:4.1886270046234 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Era' limit 1
loadtime:4.1886658668518 / seconds
Query Executed:select id FROM `mi` where city='New Era' && SIC_code='5531'DB:business_master_new
loadtime:4.1950869560242 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:4.1951298713684 / seconds
Query Executed:select id FROM `mi` where city='New Haven' && SIC_code='5531'DB:business_master_new
loadtime:4.1961817741394 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hudson' limit 1
loadtime:4.1962189674377 / seconds
Query Executed:select id FROM `mi` where city='New Hudson' && SIC_code='5531'DB:business_master_new
loadtime:4.1973338127136 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lothrop' limit 1
loadtime:4.1973819732666 / seconds
Query Executed:select id FROM `mi` where city='New Lothrop' && SIC_code='5531'DB:business_master_new
loadtime:4.2047238349915 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Troy' limit 1
loadtime:4.2047629356384 / seconds
Query Executed:select id FROM `mi` where city='New Troy' && SIC_code='5531'DB:business_master_new
loadtime:4.2060627937317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newaygo' limit 1
loadtime:4.2061109542847 / seconds
Query Executed:select id FROM `mi` where city='Newaygo' && SIC_code='5531'DB:business_master_new
loadtime:4.2072169780731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:4.2072529792786 / seconds
Query Executed:select id FROM `mi` where city='Newberry' && SIC_code='5531'DB:business_master_new
loadtime:4.2083230018616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:4.2083699703217 / seconds
Query Executed:select id FROM `mi` where city='Newport' && SIC_code='5531'DB:business_master_new
loadtime:4.2093358039856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niles' limit 1
loadtime:4.2093799114227 / seconds
Query Executed:select id FROM `mi` where city='Niles' && SIC_code='5531'DB:business_master_new
loadtime:4.2110049724579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisula' limit 1
loadtime:4.2110538482666 / seconds
Query Executed:select id FROM `mi` where city='Nisula' && SIC_code='5531'DB:business_master_new
loadtime:4.2113869190216 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:4.2114357948303 / seconds
Query Executed:select id FROM `mi` where city='North Adams' && SIC_code='5531'DB:business_master_new
loadtime:4.2145779132843 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branch' limit 1
loadtime:4.2146289348602 / seconds
Query Executed:select id FROM `mi` where city='North Branch' && SIC_code='5531'DB:business_master_new
loadtime:4.2156019210815 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Muskegon' limit 1
loadtime:4.2156608104706 / seconds
Query Executed:select id FROM `mi` where city='North Muskegon' && SIC_code='5531'DB:business_master_new
loadtime:4.2159388065338 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Star' limit 1
loadtime:4.2159647941589 / seconds
Query Executed:select id FROM `mi` where city='North Star' && SIC_code='5531'DB:business_master_new
loadtime:4.2165389060974 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Street' limit 1
loadtime:4.2165739536285 / seconds
Query Executed:select id FROM `mi` where city='North Street' && SIC_code='5531'DB:business_master_new
loadtime:4.2174777984619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northport' limit 1
loadtime:4.2175049781799 / seconds
Query Executed:select id FROM `mi` where city='Northport' && SIC_code='5531'DB:business_master_new
loadtime:4.218446969986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:4.2184958457947 / seconds
Query Executed:select id FROM `mi` where city='Northville' && SIC_code='5531'DB:business_master_new
loadtime:4.2196707725525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norvell' limit 1
loadtime:4.2197279930115 / seconds
Query Executed:select id FROM `mi` where city='Norvell' && SIC_code='5531'DB:business_master_new
loadtime:4.2203619480133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:4.2204048633575 / seconds
Query Executed:select id FROM `mi` where city='Norway' && SIC_code='5531'DB:business_master_new
loadtime:4.221382856369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottawa' limit 1
loadtime:4.2214457988739 / seconds
Query Executed:select id FROM `mi` where city='Nottawa' && SIC_code='5531'DB:business_master_new
loadtime:4.2217538356781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Novi' limit 1
loadtime:4.2217819690704 / seconds
Query Executed:select id FROM `mi` where city='Novi' && SIC_code='5531'DB:business_master_new
loadtime:4.2237567901611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunica' limit 1
loadtime:4.2238187789917 / seconds
Query Executed:select id FROM `mi` where city='Nunica' && SIC_code='5531'DB:business_master_new
loadtime:4.2247719764709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Grove' limit 1
loadtime:4.2248089313507 / seconds
Query Executed:select id FROM `mi` where city='Oak Grove' && SIC_code='5531'DB:business_master_new
loadtime:4.2251238822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Park' limit 1
loadtime:4.2251617908478 / seconds
Query Executed:select id FROM `mi` where city='Oak Park' && SIC_code='5531'DB:business_master_new
loadtime:4.2266609668732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:4.226705789566 / seconds
Query Executed:select id FROM `mi` where city='Oakland' && SIC_code='5531'DB:business_master_new
loadtime:4.2276298999786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland Twp' limit 1
loadtime:4.2276799678802 / seconds
Query Executed:select id FROM `mi` where city='Oakland Twp' && SIC_code='5531'DB:business_master_new
loadtime:4.2279808521271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:4.2280178070068 / seconds
Query Executed:select id FROM `mi` where city='Oakley' && SIC_code='5531'DB:business_master_new
loadtime:4.2313048839569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oden' limit 1
loadtime:4.231339931488 / seconds
Query Executed:select id FROM `mi` where city='Oden' && SIC_code='5531'DB:business_master_new
loadtime:4.23197889328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okemos' limit 1
loadtime:4.2320218086243 / seconds
Query Executed:select id FROM `mi` where city='Okemos' && SIC_code='5531'DB:business_master_new
loadtime:4.2335908412933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mission' limit 1
loadtime:4.2336459159851 / seconds
Query Executed:select id FROM `mi` where city='Old Mission' && SIC_code='5531'DB:business_master_new
loadtime:4.234053850174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:4.2340958118439 / seconds
Query Executed:select id FROM `mi` where city='Olivet' && SIC_code='5531'DB:business_master_new
loadtime:4.2349817752838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omena' limit 1
loadtime:4.2350149154663 / seconds
Query Executed:select id FROM `mi` where city='Omena' && SIC_code='5531'DB:business_master_new
loadtime:4.2359139919281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omer' limit 1
loadtime:4.2359528541565 / seconds
Query Executed:select id FROM `mi` where city='Omer' && SIC_code='5531'DB:business_master_new
loadtime:4.2389168739319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaway' limit 1
loadtime:4.2389559745789 / seconds
Query Executed:select id FROM `mi` where city='Onaway' && SIC_code='5531'DB:business_master_new
loadtime:4.2399289608002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onekama' limit 1
loadtime:4.2399749755859 / seconds
Query Executed:select id FROM `mi` where city='Onekama' && SIC_code='5531'DB:business_master_new
loadtime:4.2451529502869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onondaga' limit 1
loadtime:4.2452127933502 / seconds
Query Executed:select id FROM `mi` where city='Onondaga' && SIC_code='5531'DB:business_master_new
loadtime:4.2490057945251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onsted' limit 1
loadtime:4.2490358352661 / seconds
Query Executed:select id FROM `mi` where city='Onsted' && SIC_code='5531'DB:business_master_new
loadtime:4.250040769577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontonagon' limit 1
loadtime:4.2500967979431 / seconds
Query Executed:select id FROM `mi` where city='Ontonagon' && SIC_code='5531'DB:business_master_new
loadtime:4.2578148841858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard Lake' limit 1
loadtime:4.2578527927399 / seconds
Query Executed:select id FROM `mi` where city='Orchard Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.2581429481506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orion' limit 1
loadtime:4.258181810379 / seconds
Query Executed:select id FROM `mi` where city='Orion' && SIC_code='5531'DB:business_master_new
loadtime:4.2584729194641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:4.2584989070892 / seconds
Query Executed:select id FROM `mi` where city='Orleans' && SIC_code='5531'DB:business_master_new
loadtime:4.2599649429321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortonville' limit 1
loadtime:4.2600049972534 / seconds
Query Executed:select id FROM `mi` where city='Ortonville' && SIC_code='5531'DB:business_master_new
loadtime:4.261100769043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oscoda' limit 1
loadtime:4.2611479759216 / seconds
Query Executed:select id FROM `mi` where city='Oscoda' && SIC_code='5531'DB:business_master_new
loadtime:4.2622628211975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshtemo' limit 1
loadtime:4.2623119354248 / seconds
Query Executed:select id FROM `mi` where city='Oshtemo' && SIC_code='5531'DB:business_master_new
loadtime:4.265567779541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osseo' limit 1
loadtime:4.265645980835 / seconds
Query Executed:select id FROM `mi` where city='Osseo' && SIC_code='5531'DB:business_master_new
loadtime:4.2690908908844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossineke' limit 1
loadtime:4.2691259384155 / seconds
Query Executed:select id FROM `mi` where city='Ossineke' && SIC_code='5531'DB:business_master_new
loadtime:4.2729849815369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otisville' limit 1
loadtime:4.2730329036713 / seconds
Query Executed:select id FROM `mi` where city='Otisville' && SIC_code='5531'DB:business_master_new
loadtime:4.2739548683167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otsego' limit 1
loadtime:4.2739889621735 / seconds
Query Executed:select id FROM `mi` where city='Otsego' && SIC_code='5531'DB:business_master_new
loadtime:4.2750298976898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottawa Lake' limit 1
loadtime:4.2750759124756 / seconds
Query Executed:select id FROM `mi` where city='Ottawa Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.2760248184204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otter Lake' limit 1
loadtime:4.2760667800903 / seconds
Query Executed:select id FROM `mi` where city='Otter Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.2769968509674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovid' limit 1
loadtime:4.2770528793335 / seconds
Query Executed:select id FROM `mi` where city='Ovid' && SIC_code='5531'DB:business_master_new
loadtime:4.2779958248138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owendale' limit 1
loadtime:4.2780699729919 / seconds
Query Executed:select id FROM `mi` where city='Owendale' && SIC_code='5531'DB:business_master_new
loadtime:4.2840328216553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owosso' limit 1
loadtime:4.2840778827667 / seconds
Query Executed:select id FROM `mi` where city='Owosso' && SIC_code='5531'DB:business_master_new
loadtime:4.2856779098511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:4.2857429981232 / seconds
Query Executed:select id FROM `mi` where city='Oxford' && SIC_code='5531'DB:business_master_new
loadtime:4.2870769500732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painesdale' limit 1
loadtime:4.2871158123016 / seconds
Query Executed:select id FROM `mi` where city='Painesdale' && SIC_code='5531'DB:business_master_new
loadtime:4.2882528305054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:4.2882928848267 / seconds
Query Executed:select id FROM `mi` where city='Palmer' && SIC_code='5531'DB:business_master_new
loadtime:4.2886989116669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palms' limit 1
loadtime:4.288724899292 / seconds
Query Executed:select id FROM `mi` where city='Palms' && SIC_code='5531'DB:business_master_new
loadtime:4.2891747951508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:4.2892107963562 / seconds
Query Executed:select id FROM `mi` where city='Palmyra' && SIC_code='5531'DB:business_master_new
loadtime:4.2906799316406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:4.2907128334045 / seconds
Query Executed:select id FROM `mi` where city='Palo' && SIC_code='5531'DB:business_master_new
loadtime:4.2909948825836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:4.2910318374634 / seconds
Query Executed:select id FROM `mi` where city='Paradise' && SIC_code='5531'DB:business_master_new
loadtime:4.2931959629059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchment' limit 1
loadtime:4.29323387146 / seconds
Query Executed:select id FROM `mi` where city='Parchment' && SIC_code='5531'DB:business_master_new
loadtime:4.2935168743134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:4.2935409545898 / seconds
Query Executed:select id FROM `mi` where city='Paris' && SIC_code='5531'DB:business_master_new
loadtime:4.2953670024872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parma' limit 1
loadtime:4.2954049110413 / seconds
Query Executed:select id FROM `mi` where city='Parma' && SIC_code='5531'DB:business_master_new
loadtime:4.2963149547577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Paw' limit 1
loadtime:4.2963418960571 / seconds
Query Executed:select id FROM `mi` where city='Paw Paw' && SIC_code='5531'DB:business_master_new
loadtime:4.2974979877472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peck' limit 1
loadtime:4.2975468635559 / seconds
Query Executed:select id FROM `mi` where city='Peck' && SIC_code='5531'DB:business_master_new
loadtime:4.2992329597473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelkie' limit 1
loadtime:4.2992677688599 / seconds
Query Executed:select id FROM `mi` where city='Pelkie' && SIC_code='5531'DB:business_master_new
loadtime:4.3001029491425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pellston' limit 1
loadtime:4.3001568317413 / seconds
Query Executed:select id FROM `mi` where city='Pellston' && SIC_code='5531'DB:business_master_new
loadtime:4.3026437759399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pentwater' limit 1
loadtime:4.3026759624481 / seconds
Query Executed:select id FROM `mi` where city='Pentwater' && SIC_code='5531'DB:business_master_new
loadtime:4.3035869598389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkins' limit 1
loadtime:4.3036358356476 / seconds
Query Executed:select id FROM `mi` where city='Perkins' && SIC_code='5531'DB:business_master_new
loadtime:4.305704832077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perrinton' limit 1
loadtime:4.305743932724 / seconds
Query Executed:select id FROM `mi` where city='Perrinton' && SIC_code='5531'DB:business_master_new
loadtime:4.3084797859192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perronville' limit 1
loadtime:4.3085248470306 / seconds
Query Executed:select id FROM `mi` where city='Perronville' && SIC_code='5531'DB:business_master_new
loadtime:4.308819770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:4.3088557720184 / seconds
Query Executed:select id FROM `mi` where city='Perry' && SIC_code='5531'DB:business_master_new
loadtime:4.3098528385162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:4.309886932373 / seconds
Query Executed:select id FROM `mi` where city='Petersburg' && SIC_code='5531'DB:business_master_new
loadtime:4.3108329772949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petoskey' limit 1
loadtime:4.3108777999878 / seconds
Query Executed:select id FROM `mi` where city='Petoskey' && SIC_code='5531'DB:business_master_new
loadtime:4.3124458789825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pewamo' limit 1
loadtime:4.3124799728394 / seconds
Query Executed:select id FROM `mi` where city='Pewamo' && SIC_code='5531'DB:business_master_new
loadtime:4.314032793045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickford' limit 1
loadtime:4.3140828609467 / seconds
Query Executed:select id FROM `mi` where city='Pickford' && SIC_code='5531'DB:business_master_new
loadtime:4.3181967735291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:4.3182590007782 / seconds
Query Executed:select id FROM `mi` where city='Pierson' && SIC_code='5531'DB:business_master_new
loadtime:4.3207139968872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pigeon' limit 1
loadtime:4.3207478523254 / seconds
Query Executed:select id FROM `mi` where city='Pigeon' && SIC_code='5531'DB:business_master_new
loadtime:4.3217117786407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinckney' limit 1
loadtime:4.3217527866364 / seconds
Query Executed:select id FROM `mi` where city='Pinckney' && SIC_code='5531'DB:business_master_new
loadtime:4.3229079246521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinconning' limit 1
loadtime:4.3229429721832 / seconds
Query Executed:select id FROM `mi` where city='Pinconning' && SIC_code='5531'DB:business_master_new
loadtime:4.3239719867706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:4.3240149021149 / seconds
Query Executed:select id FROM `mi` where city='Pittsford' && SIC_code='5531'DB:business_master_new
loadtime:4.3274478912354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainwell' limit 1
loadtime:4.3274939060211 / seconds
Query Executed:select id FROM `mi` where city='Plainwell' && SIC_code='5531'DB:business_master_new
loadtime:4.3287007808685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Lake' limit 1
loadtime:4.3287489414215 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.3297519683838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Ridge' limit 1
loadtime:4.3297848701477 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Ridge' && SIC_code='5531'DB:business_master_new
loadtime:4.3306789398193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:4.3307168483734 / seconds
Query Executed:select id FROM `mi` where city='Plymouth' && SIC_code='5531'DB:business_master_new
loadtime:4.332062959671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pointe Aux Pins' limit 1
loadtime:4.3321089744568 / seconds
Query Executed:select id FROM `mi` where city='Pointe Aux Pins' && SIC_code='5531'DB:business_master_new
loadtime:4.332515001297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompeii' limit 1
loadtime:4.3325409889221 / seconds
Query Executed:select id FROM `mi` where city='Pompeii' && SIC_code='5531'DB:business_master_new
loadtime:4.3328418731689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontiac' limit 1
loadtime:4.3328778743744 / seconds
Query Executed:select id FROM `mi` where city='Pontiac' && SIC_code='5531'DB:business_master_new
loadtime:4.3347949981689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Austin' limit 1
loadtime:4.3348469734192 / seconds
Query Executed:select id FROM `mi` where city='Port Austin' && SIC_code='5531'DB:business_master_new
loadtime:4.3357989788055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Hope' limit 1
loadtime:4.3358559608459 / seconds
Query Executed:select id FROM `mi` where city='Port Hope' && SIC_code='5531'DB:business_master_new
loadtime:4.3378617763519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Huron' limit 1
loadtime:4.3379049301147 / seconds
Query Executed:select id FROM `mi` where city='Port Huron' && SIC_code='5531'DB:business_master_new
loadtime:4.3397748470306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Sanilac' limit 1
loadtime:4.3398289680481 / seconds
Query Executed:select id FROM `mi` where city='Port Sanilac' && SIC_code='5531'DB:business_master_new
loadtime:4.3423268795013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:4.3423569202423 / seconds
Query Executed:select id FROM `mi` where city='Portage' && SIC_code='5531'DB:business_master_new
loadtime:4.3442809581757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:4.3443348407745 / seconds
Query Executed:select id FROM `mi` where city='Portland' && SIC_code='5531'DB:business_master_new
loadtime:4.3453497886658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Posen' limit 1
loadtime:4.3453938961029 / seconds
Query Executed:select id FROM `mi` where city='Posen' && SIC_code='5531'DB:business_master_new
loadtime:4.3498029708862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potterville' limit 1
loadtime:4.3498439788818 / seconds
Query Executed:select id FROM `mi` where city='Potterville' && SIC_code='5531'DB:business_master_new
loadtime:4.3507997989655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers' limit 1
loadtime:4.3508408069611 / seconds
Query Executed:select id FROM `mi` where city='Powers' && SIC_code='5531'DB:business_master_new
loadtime:4.35178399086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:4.3518109321594 / seconds
Query Executed:select id FROM `mi` where city='Prescott' && SIC_code='5531'DB:business_master_new
loadtime:4.3526818752289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presque Isle' limit 1
loadtime:4.3527209758759 / seconds
Query Executed:select id FROM `mi` where city='Presque Isle' && SIC_code='5531'DB:business_master_new
loadtime:4.3539788722992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prudenville' limit 1
loadtime:4.3540329933167 / seconds
Query Executed:select id FROM `mi` where city='Prudenville' && SIC_code='5531'DB:business_master_new
loadtime:4.3572249412537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pullman' limit 1
loadtime:4.3572738170624 / seconds
Query Executed:select id FROM `mi` where city='Pullman' && SIC_code='5531'DB:business_master_new
loadtime:4.3593618869781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:4.3593928813934 / seconds
Query Executed:select id FROM `mi` where city='Quincy' && SIC_code='5531'DB:business_master_new
loadtime:4.3603348731995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinnesec' limit 1
loadtime:4.3603827953339 / seconds
Query Executed:select id FROM `mi` where city='Quinnesec' && SIC_code='5531'DB:business_master_new
loadtime:4.3612639904022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:4.3613038063049 / seconds
Query Executed:select id FROM `mi` where city='Ralph' && SIC_code='5531'DB:business_master_new
loadtime:4.361585855484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramsay' limit 1
loadtime:4.3616118431091 / seconds
Query Executed:select id FROM `mi` where city='Ramsay' && SIC_code='5531'DB:business_master_new
loadtime:4.3620657920837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:4.3621029853821 / seconds
Query Executed:select id FROM `mi` where city='Rapid City' && SIC_code='5531'DB:business_master_new
loadtime:4.3647108078003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid River' limit 1
loadtime:4.3647389411926 / seconds
Query Executed:select id FROM `mi` where city='Rapid River' && SIC_code='5531'DB:business_master_new
loadtime:4.3656408786774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenna' limit 1
loadtime:4.3656859397888 / seconds
Query Executed:select id FROM `mi` where city='Ravenna' && SIC_code='5531'DB:business_master_new
loadtime:4.3666059970856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ray' limit 1
loadtime:4.3666498661041 / seconds
Query Executed:select id FROM `mi` where city='Ray' && SIC_code='5531'DB:business_master_new
loadtime:4.3675220012665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:4.3675599098206 / seconds
Query Executed:select id FROM `mi` where city='Reading' && SIC_code='5531'DB:business_master_new
loadtime:4.3694109916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redford' limit 1
loadtime:4.3694479465485 / seconds
Query Executed:select id FROM `mi` where city='Redford' && SIC_code='5531'DB:business_master_new
loadtime:4.3706569671631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reed City' limit 1
loadtime:4.370689868927 / seconds
Query Executed:select id FROM `mi` where city='Reed City' && SIC_code='5531'DB:business_master_new
loadtime:4.3717257976532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reese' limit 1
loadtime:4.3717818260193 / seconds
Query Executed:select id FROM `mi` where city='Reese' && SIC_code='5531'DB:business_master_new
loadtime:4.3727188110352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remus' limit 1
loadtime:4.372761964798 / seconds
Query Executed:select id FROM `mi` where city='Remus' && SIC_code='5531'DB:business_master_new
loadtime:4.3736979961395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republic' limit 1
loadtime:4.3737549781799 / seconds
Query Executed:select id FROM `mi` where city='Republic' && SIC_code='5531'DB:business_master_new
loadtime:4.375412940979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:4.3754489421844 / seconds
Query Executed:select id FROM `mi` where city='Rhodes' && SIC_code='5531'DB:business_master_new
loadtime:4.377133846283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:4.3771848678589 / seconds
Query Executed:select id FROM `mi` where city='Richland' && SIC_code='5531'DB:business_master_new
loadtime:4.3782539367676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:4.3783059120178 / seconds
Query Executed:select id FROM `mi` where city='Richmond' && SIC_code='5531'DB:business_master_new
loadtime:4.3794119358063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richville' limit 1
loadtime:4.379460811615 / seconds
Query Executed:select id FROM `mi` where city='Richville' && SIC_code='5531'DB:business_master_new
loadtime:4.3798949718475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riga' limit 1
loadtime:4.3799498081207 / seconds
Query Executed:select id FROM `mi` where city='Riga' && SIC_code='5531'DB:business_master_new
loadtime:4.380676984787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riley' limit 1
loadtime:4.3807117938995 / seconds
Query Executed:select id FROM `mi` where city='Riley' && SIC_code='5531'DB:business_master_new
loadtime:4.3809859752655 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Rouge' limit 1
loadtime:4.3810257911682 / seconds
Query Executed:select id FROM `mi` where city='River Rouge' && SIC_code='5531'DB:business_master_new
loadtime:4.3824229240417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:4.3824517726898 / seconds
Query Executed:select id FROM `mi` where city='Riverdale' && SIC_code='5531'DB:business_master_new
loadtime:4.3835518360138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:4.3835909366608 / seconds
Query Executed:select id FROM `mi` where city='Riverside' && SIC_code='5531'DB:business_master_new
loadtime:4.3841829299927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverview' limit 1
loadtime:4.3842179775238 / seconds
Query Executed:select id FROM `mi` where city='Riverview' && SIC_code='5531'DB:business_master_new
loadtime:4.3852069377899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rives Junction' limit 1
loadtime:4.3852529525757 / seconds
Query Executed:select id FROM `mi` where city='Rives Junction' && SIC_code='5531'DB:business_master_new
loadtime:4.3878309726715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:4.3878607749939 / seconds
Query Executed:select id FROM `mi` where city='Rochester' && SIC_code='5531'DB:business_master_new
loadtime:4.3905308246613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester Hills' limit 1
loadtime:4.3905940055847 / seconds
Query Executed:select id FROM `mi` where city='Rochester Hills' && SIC_code='5531'DB:business_master_new
loadtime:4.3934938907623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock' limit 1
loadtime:4.3935508728027 / seconds
Query Executed:select id FROM `mi` where city='Rock' && SIC_code='5531'DB:business_master_new
loadtime:4.3946709632874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:4.3947138786316 / seconds
Query Executed:select id FROM `mi` where city='Rockford' && SIC_code='5531'DB:business_master_new
loadtime:4.3961658477783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:4.3962149620056 / seconds
Query Executed:select id FROM `mi` where city='Rockland' && SIC_code='5531'DB:business_master_new
loadtime:4.3969888687134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwood' limit 1
loadtime:4.3970267772675 / seconds
Query Executed:select id FROM `mi` where city='Rockwood' && SIC_code='5531'DB:business_master_new
loadtime:4.3990468978882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:4.3990910053253 / seconds
Query Executed:select id FROM `mi` where city='Rodney' && SIC_code='5531'DB:business_master_new
loadtime:4.4000959396362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers City' limit 1
loadtime:4.40012383461 / seconds
Query Executed:select id FROM `mi` where city='Rogers City' && SIC_code='5531'DB:business_master_new
loadtime:4.4011979103088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollin' limit 1
loadtime:4.4012479782104 / seconds
Query Executed:select id FROM `mi` where city='Rollin' && SIC_code='5531'DB:business_master_new
loadtime:4.4015238285065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romeo' limit 1
loadtime:4.4015519618988 / seconds
Query Executed:select id FROM `mi` where city='Romeo' && SIC_code='5531'DB:business_master_new
loadtime:4.4027488231659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romulus' limit 1
loadtime:4.4031689167023 / seconds
Query Executed:select id FROM `mi` where city='Romulus' && SIC_code='5531'DB:business_master_new
loadtime:4.4042539596558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscommon' limit 1
loadtime:4.4043118953705 / seconds
Query Executed:select id FROM `mi` where city='Roscommon' && SIC_code='5531'DB:business_master_new
loadtime:4.4053049087524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose City' limit 1
loadtime:4.4053437709808 / seconds
Query Executed:select id FROM `mi` where city='Rose City' && SIC_code='5531'DB:business_master_new
loadtime:4.4063987731934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebush' limit 1
loadtime:4.4064629077911 / seconds
Query Executed:select id FROM `mi` where city='Rosebush' && SIC_code='5531'DB:business_master_new
loadtime:4.4075589179993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseville' limit 1
loadtime:4.4076068401337 / seconds
Query Executed:select id FROM `mi` where city='Roseville' && SIC_code='5531'DB:business_master_new
loadtime:4.4095637798309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rothbury' limit 1
loadtime:4.409646987915 / seconds
Query Executed:select id FROM `mi` where city='Rothbury' && SIC_code='5531'DB:business_master_new
loadtime:4.4110279083252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal Oak' limit 1
loadtime:4.4110929965973 / seconds
Query Executed:select id FROM `mi` where city='Royal Oak' && SIC_code='5531'DB:business_master_new
loadtime:4.4134237766266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:4.4134919643402 / seconds
Query Executed:select id FROM `mi` where city='Ruby' && SIC_code='5531'DB:business_master_new
loadtime:4.4137918949127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudyard' limit 1
loadtime:4.4138247966766 / seconds
Query Executed:select id FROM `mi` where city='Rudyard' && SIC_code='5531'DB:business_master_new
loadtime:4.4148218631744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumely' limit 1
loadtime:4.4148697853088 / seconds
Query Executed:select id FROM `mi` where city='Rumely' && SIC_code='5531'DB:business_master_new
loadtime:4.4154739379883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell Island' limit 1
loadtime:4.4155128002167 / seconds
Query Executed:select id FROM `mi` where city='Russell Island' && SIC_code='5531'DB:business_master_new
loadtime:4.4157857894897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:4.415825843811 / seconds
Query Executed:select id FROM `mi` where city='Ruth' && SIC_code='5531'DB:business_master_new
loadtime:4.4168748855591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saginaw' limit 1
loadtime:4.4169127941132 / seconds
Query Executed:select id FROM `mi` where city='Saginaw' && SIC_code='5531'DB:business_master_new
loadtime:4.4201288223267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagola' limit 1
loadtime:4.4201879501343 / seconds
Query Executed:select id FROM `mi` where city='Sagola' && SIC_code='5531'DB:business_master_new
loadtime:4.4206299781799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:4.4206719398499 / seconds
Query Executed:select id FROM `mi` where city='Saint Charles' && SIC_code='5531'DB:business_master_new
loadtime:4.421642780304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair' limit 1
loadtime:4.4216778278351 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair' && SIC_code='5531'DB:business_master_new
loadtime:4.4227697849274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair Shores' limit 1
loadtime:4.422819852829 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair Shores' && SIC_code='5531'DB:business_master_new
loadtime:4.4248797893524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helen' limit 1
loadtime:4.4249408245087 / seconds
Query Executed:select id FROM `mi` where city='Saint Helen' && SIC_code='5531'DB:business_master_new
loadtime:4.4267239570618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ignace' limit 1
loadtime:4.4267568588257 / seconds
Query Executed:select id FROM `mi` where city='Saint Ignace' && SIC_code='5531'DB:business_master_new
loadtime:4.4278609752655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:4.4279098510742 / seconds
Query Executed:select id FROM `mi` where city='Saint Johns' && SIC_code='5531'DB:business_master_new
loadtime:4.4292957782745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Joseph' limit 1
loadtime:4.4293479919434 / seconds
Query Executed:select id FROM `mi` where city='Saint Joseph' && SIC_code='5531'DB:business_master_new
loadtime:4.4310009479523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Louis' limit 1
loadtime:4.4310488700867 / seconds
Query Executed:select id FROM `mi` where city='Saint Louis' && SIC_code='5531'DB:business_master_new
loadtime:4.4321029186249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:4.4321389198303 / seconds
Query Executed:select id FROM `mi` where city='Salem' && SIC_code='5531'DB:business_master_new
loadtime:4.4324507713318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saline' limit 1
loadtime:4.4325029850006 / seconds
Query Executed:select id FROM `mi` where city='Saline' && SIC_code='5531'DB:business_master_new
loadtime:4.4335958957672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Samaria' limit 1
loadtime:4.4336459636688 / seconds
Query Executed:select id FROM `mi` where city='Samaria' && SIC_code='5531'DB:business_master_new
loadtime:4.4339787960052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Creek' limit 1
loadtime:4.4340398311615 / seconds
Query Executed:select id FROM `mi` where city='Sand Creek' && SIC_code='5531'DB:business_master_new
loadtime:4.4350349903107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Lake' limit 1
loadtime:4.435065984726 / seconds
Query Executed:select id FROM `mi` where city='Sand Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.4360418319702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandusky' limit 1
loadtime:4.4360888004303 / seconds
Query Executed:select id FROM `mi` where city='Sandusky' && SIC_code='5531'DB:business_master_new
loadtime:4.4372317790985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:4.4372899532318 / seconds
Query Executed:select id FROM `mi` where city='Sanford' && SIC_code='5531'DB:business_master_new
loadtime:4.4383478164673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saranac' limit 1
loadtime:4.4383809566498 / seconds
Query Executed:select id FROM `mi` where city='Saranac' && SIC_code='5531'DB:business_master_new
loadtime:4.4393467903137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugatuck' limit 1
loadtime:4.4394598007202 / seconds
Query Executed:select id FROM `mi` where city='Saugatuck' && SIC_code='5531'DB:business_master_new
loadtime:4.4404819011688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Sainte Marie' limit 1
loadtime:4.4405128955841 / seconds
Query Executed:select id FROM `mi` where city='Sault Sainte Marie' && SIC_code='5531'DB:business_master_new
loadtime:4.441990852356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Ste Marie' limit 1
loadtime:4.4420478343964 / seconds
Query Executed:select id FROM `mi` where city='Sault Ste Marie' && SIC_code='5531'DB:business_master_new
loadtime:4.4427418708801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sawyer' limit 1
loadtime:4.4428389072418 / seconds
Query Executed:select id FROM `mi` where city='Sawyer' && SIC_code='5531'DB:business_master_new
loadtime:4.4446449279785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schoolcraft' limit 1
loadtime:4.4448029994965 / seconds
Query Executed:select id FROM `mi` where city='Schoolcraft' && SIC_code='5531'DB:business_master_new
loadtime:4.4459068775177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:4.4460508823395 / seconds
Query Executed:select id FROM `mi` where city='Scotts' && SIC_code='5531'DB:business_master_new
loadtime:4.4476449489594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:4.4477019309998 / seconds
Query Executed:select id FROM `mi` where city='Scottville' && SIC_code='5531'DB:business_master_new
loadtime:4.4486508369446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sears' limit 1
loadtime:4.4486978054047 / seconds
Query Executed:select id FROM `mi` where city='Sears' && SIC_code='5531'DB:business_master_new
loadtime:4.4497678279877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebewaing' limit 1
loadtime:4.449866771698 / seconds
Query Executed:select id FROM `mi` where city='Sebewaing' && SIC_code='5531'DB:business_master_new
loadtime:4.450835943222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selfridge Angb' limit 1
loadtime:4.4508819580078 / seconds
Query Executed:select id FROM `mi` where city='Selfridge Angb' && SIC_code='5531'DB:business_master_new
loadtime:4.4512348175049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:4.4512689113617 / seconds
Query Executed:select id FROM `mi` where city='Seneca' && SIC_code='5531'DB:business_master_new
loadtime:4.4515328407288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seney' limit 1
loadtime:4.4515659809113 / seconds
Query Executed:select id FROM `mi` where city='Seney' && SIC_code='5531'DB:business_master_new
loadtime:4.4518549442291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsburg' limit 1
loadtime:4.4518799781799 / seconds
Query Executed:select id FROM `mi` where city='Shaftsburg' && SIC_code='5531'DB:business_master_new
loadtime:4.4522199630737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:4.4522547721863 / seconds
Query Executed:select id FROM `mi` where city='Shelby' && SIC_code='5531'DB:business_master_new
loadtime:4.4531919956207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby Twp' limit 1
loadtime:4.4532279968262 / seconds
Query Executed:select id FROM `mi` where city='Shelby Twp' && SIC_code='5531'DB:business_master_new
loadtime:4.4543328285217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelbyville' limit 1
loadtime:4.4544298648834 / seconds
Query Executed:select id FROM `mi` where city='Shelbyville' && SIC_code='5531'DB:business_master_new
loadtime:4.4562618732452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shepherd' limit 1
loadtime:4.4563179016113 / seconds
Query Executed:select id FROM `mi` where city='Shepherd' && SIC_code='5531'DB:business_master_new
loadtime:4.4573547840118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:4.4573848247528 / seconds
Query Executed:select id FROM `mi` where city='Sheridan' && SIC_code='5531'DB:business_master_new
loadtime:4.4582757949829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:4.458331823349 / seconds
Query Executed:select id FROM `mi` where city='Sherwood' && SIC_code='5531'DB:business_master_new
loadtime:4.4592468738556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shingleton' limit 1
loadtime:4.4592759609222 / seconds
Query Executed:select id FROM `mi` where city='Shingleton' && SIC_code='5531'DB:business_master_new
loadtime:4.4598288536072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidnaw' limit 1
loadtime:4.4598658084869 / seconds
Query Executed:select id FROM `mi` where city='Sidnaw' && SIC_code='5531'DB:business_master_new
loadtime:4.4601669311523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:4.4601919651031 / seconds
Query Executed:select id FROM `mi` where city='Sidney' && SIC_code='5531'DB:business_master_new
loadtime:4.4606919288635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverwood' limit 1
loadtime:4.460727930069 / seconds
Query Executed:select id FROM `mi` where city='Silverwood' && SIC_code='5531'DB:business_master_new
loadtime:4.4613049030304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Lakes' limit 1
loadtime:4.4613389968872 / seconds
Query Executed:select id FROM `mi` where city='Six Lakes' && SIC_code='5531'DB:business_master_new
loadtime:4.4636428356171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skandia' limit 1
loadtime:4.4637138843536 / seconds
Query Executed:select id FROM `mi` where city='Skandia' && SIC_code='5531'DB:business_master_new
loadtime:4.4650678634644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skanee' limit 1
loadtime:4.4651107788086 / seconds
Query Executed:select id FROM `mi` where city='Skanee' && SIC_code='5531'DB:business_master_new
loadtime:4.4655249118805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smiths Creek' limit 1
loadtime:4.4655947685242 / seconds
Query Executed:select id FROM `mi` where city='Smiths Creek' && SIC_code='5531'DB:business_master_new
loadtime:4.4667048454285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:4.4667530059814 / seconds
Query Executed:select id FROM `mi` where city='Smyrna' && SIC_code='5531'DB:business_master_new
loadtime:4.4670648574829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snover' limit 1
loadtime:4.4671268463135 / seconds
Query Executed:select id FROM `mi` where city='Snover' && SIC_code='5531'DB:business_master_new
loadtime:4.469025850296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sodus' limit 1
loadtime:4.4690799713135 / seconds
Query Executed:select id FROM `mi` where city='Sodus' && SIC_code='5531'DB:business_master_new
loadtime:4.4701337814331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:4.4701709747314 / seconds
Query Executed:select id FROM `mi` where city='Somerset' && SIC_code='5531'DB:business_master_new
loadtime:4.4706089496613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset Center' limit 1
loadtime:4.4706959724426 / seconds
Query Executed:select id FROM `mi` where city='Somerset Center' && SIC_code='5531'DB:business_master_new
loadtime:4.4713599681854 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boardman' limit 1
loadtime:4.471403837204 / seconds
Query Executed:select id FROM `mi` where city='South Boardman' && SIC_code='5531'DB:business_master_new
loadtime:4.472904920578 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Branch' limit 1
loadtime:4.4729537963867 / seconds
Query Executed:select id FROM `mi` where city='South Branch' && SIC_code='5531'DB:business_master_new
loadtime:4.4735448360443 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Haven' limit 1
loadtime:4.4735867977142 / seconds
Query Executed:select id FROM `mi` where city='South Haven' && SIC_code='5531'DB:business_master_new
loadtime:4.4748888015747 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyon' limit 1
loadtime:4.4749279022217 / seconds
Query Executed:select id FROM `mi` where city='South Lyon' && SIC_code='5531'DB:business_master_new
loadtime:4.4763000011444 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Range' limit 1
loadtime:4.4763479232788 / seconds
Query Executed:select id FROM `mi` where city='South Range' && SIC_code='5531'DB:business_master_new
loadtime:4.4770929813385 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Rockwood' limit 1
loadtime:4.4771409034729 / seconds
Query Executed:select id FROM `mi` where city='South Rockwood' && SIC_code='5531'DB:business_master_new
loadtime:4.4784429073334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:4.4784817695618 / seconds
Query Executed:select id FROM `mi` where city='Southfield' && SIC_code='5531'DB:business_master_new
loadtime:4.4946818351746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southgate' limit 1
loadtime:4.4947748184204 / seconds
Query Executed:select id FROM `mi` where city='Southgate' && SIC_code='5531'DB:business_master_new
loadtime:4.4958558082581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spalding' limit 1
loadtime:4.495954990387 / seconds
Query Executed:select id FROM `mi` where city='Spalding' && SIC_code='5531'DB:business_master_new
loadtime:4.4968738555908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:4.4969239234924 / seconds
Query Executed:select id FROM `mi` where city='Sparta' && SIC_code='5531'DB:business_master_new
loadtime:4.4980568885803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Arbor' limit 1
loadtime:4.4980959892273 / seconds
Query Executed:select id FROM `mi` where city='Spring Arbor' && SIC_code='5531'DB:business_master_new
loadtime:4.4990968704224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:4.4991819858551 / seconds
Query Executed:select id FROM `mi` where city='Spring Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.5004949569702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:4.5005729198456 / seconds
Query Executed:select id FROM `mi` where city='Springfield' && SIC_code='5531'DB:business_master_new
loadtime:4.5010139942169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield Twp' limit 1
loadtime:4.5010569095612 / seconds
Query Executed:select id FROM `mi` where city='Springfield Twp' && SIC_code='5531'DB:business_master_new
loadtime:4.5013749599457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springport' limit 1
loadtime:4.5014188289642 / seconds
Query Executed:select id FROM `mi` where city='Springport' && SIC_code='5531'DB:business_master_new
loadtime:4.5028758049011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce' limit 1
loadtime:4.5029239654541 / seconds
Query Executed:select id FROM `mi` where city='Spruce' && SIC_code='5531'DB:business_master_new
loadtime:4.5041959285736 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:4.5042378902435 / seconds
Query Executed:select id FROM `mi` where city='St Charles' && SIC_code='5531'DB:business_master_new
loadtime:4.5045368671417 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair' limit 1
loadtime:4.5045809745789 / seconds
Query Executed:select id FROM `mi` where city='St Clair' && SIC_code='5531'DB:business_master_new
loadtime:4.5049328804016 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair Shores' limit 1
loadtime:4.5049707889557 / seconds
Query Executed:select id FROM `mi` where city='St Clair Shores' && SIC_code='5531'DB:business_master_new
loadtime:4.5055289268494 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ignace' limit 1
loadtime:4.5055539608002 / seconds
Query Executed:select id FROM `mi` where city='St Ignace' && SIC_code='5531'DB:business_master_new
loadtime:4.5058197975159 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:4.5058557987213 / seconds
Query Executed:select id FROM `mi` where city='St Johns' && SIC_code='5531'DB:business_master_new
loadtime:4.5062108039856 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Joseph' limit 1
loadtime:4.5062358379364 / seconds
Query Executed:select id FROM `mi` where city='St Joseph' && SIC_code='5531'DB:business_master_new
loadtime:4.5067567825317 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Louis' limit 1
loadtime:4.5067939758301 / seconds
Query Executed:select id FROM `mi` where city='St Louis' && SIC_code='5531'DB:business_master_new
loadtime:4.5070848464966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stalwart' limit 1
loadtime:4.5071268081665 / seconds
Query Executed:select id FROM `mi` where city='Stalwart' && SIC_code='5531'DB:business_master_new
loadtime:4.5073938369751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stambaugh' limit 1
loadtime:4.5074889659882 / seconds
Query Executed:select id FROM `mi` where city='Stambaugh' && SIC_code='5531'DB:business_master_new
loadtime:4.508113861084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Standish' limit 1
loadtime:4.5081658363342 / seconds
Query Executed:select id FROM `mi` where city='Standish' && SIC_code='5531'DB:business_master_new
loadtime:4.5091948509216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:4.5092389583588 / seconds
Query Executed:select id FROM `mi` where city='Stanton' && SIC_code='5531'DB:business_master_new
loadtime:4.5102388858795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:4.5102818012238 / seconds
Query Executed:select id FROM `mi` where city='Stanwood' && SIC_code='5531'DB:business_master_new
loadtime:4.5113439559937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:4.5114419460297 / seconds
Query Executed:select id FROM `mi` where city='Stephenson' && SIC_code='5531'DB:business_master_new
loadtime:4.5124218463898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:4.5124697685242 / seconds
Query Executed:select id FROM `mi` where city='Sterling' && SIC_code='5531'DB:business_master_new
loadtime:4.5137147903442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling Heights' limit 1
loadtime:4.5138309001923 / seconds
Query Executed:select id FROM `mi` where city='Sterling Heights' && SIC_code='5531'DB:business_master_new
loadtime:4.5167109966278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:4.5168828964233 / seconds
Query Executed:select id FROM `mi` where city='Stevensville' && SIC_code='5531'DB:business_master_new
loadtime:4.5181159973145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:4.5181617736816 / seconds
Query Executed:select id FROM `mi` where city='Stockbridge' && SIC_code='5531'DB:business_master_new
loadtime:4.5192899703979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stronach' limit 1
loadtime:4.5194489955902 / seconds
Query Executed:select id FROM `mi` where city='Stronach' && SIC_code='5531'DB:business_master_new
loadtime:4.5198547840118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strongs' limit 1
loadtime:4.5199418067932 / seconds
Query Executed:select id FROM `mi` where city='Strongs' && SIC_code='5531'DB:business_master_new
loadtime:4.5202879905701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:4.5203747749329 / seconds
Query Executed:select id FROM `mi` where city='Sturgis' && SIC_code='5531'DB:business_master_new
loadtime:4.5215208530426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:4.5216858386993 / seconds
Query Executed:select id FROM `mi` where city='Sumner' && SIC_code='5531'DB:business_master_new
loadtime:4.5224928855896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunfield' limit 1
loadtime:4.522528886795 / seconds
Query Executed:select id FROM `mi` where city='Sunfield' && SIC_code='5531'DB:business_master_new
loadtime:4.5237519741058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suttons Bay' limit 1
loadtime:4.523827791214 / seconds
Query Executed:select id FROM `mi` where city='Suttons Bay' && SIC_code='5531'DB:business_master_new
loadtime:4.5249099731445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swartz Creek' limit 1
loadtime:4.5249478816986 / seconds
Query Executed:select id FROM `mi` where city='Swartz Creek' && SIC_code='5531'DB:business_master_new
loadtime:4.5261688232422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvan Lake' limit 1
loadtime:4.5262258052826 / seconds
Query Executed:select id FROM `mi` where city='Sylvan Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.5265460014343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tawas City' limit 1
loadtime:4.5265738964081 / seconds
Query Executed:select id FROM `mi` where city='Tawas City' && SIC_code='5531'DB:business_master_new
loadtime:4.5276129245758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:4.5276708602905 / seconds
Query Executed:select id FROM `mi` where city='Taylor' && SIC_code='5531'DB:business_master_new
loadtime:4.5289399623871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tecumseh' limit 1
loadtime:4.52898478508 / seconds
Query Executed:select id FROM `mi` where city='Tecumseh' && SIC_code='5531'DB:business_master_new
loadtime:4.5302398204803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tekonsha' limit 1
loadtime:4.5303108692169 / seconds
Query Executed:select id FROM `mi` where city='Tekonsha' && SIC_code='5531'DB:business_master_new
loadtime:4.5319709777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperance' limit 1
loadtime:4.5320219993591 / seconds
Query Executed:select id FROM `mi` where city='Temperance' && SIC_code='5531'DB:business_master_new
loadtime:4.5331938266754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompsonville' limit 1
loadtime:4.5332288742065 / seconds
Query Executed:select id FROM `mi` where city='Thompsonville' && SIC_code='5531'DB:business_master_new
loadtime:4.5340719223022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Oaks' limit 1
loadtime:4.5341119766235 / seconds
Query Executed:select id FROM `mi` where city='Three Oaks' && SIC_code='5531'DB:business_master_new
loadtime:4.5350937843323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:4.5351259708405 / seconds
Query Executed:select id FROM `mi` where city='Three Rivers' && SIC_code='5531'DB:business_master_new
loadtime:4.536159992218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:4.5362358093262 / seconds
Query Executed:select id FROM `mi` where city='Tipton' && SIC_code='5531'DB:business_master_new
loadtime:4.5377278327942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toivola' limit 1
loadtime:4.5377609729767 / seconds
Query Executed:select id FROM `mi` where city='Toivola' && SIC_code='5531'DB:business_master_new
loadtime:4.5382738113403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topinabee' limit 1
loadtime:4.5383110046387 / seconds
Query Executed:select id FROM `mi` where city='Topinabee' && SIC_code='5531'DB:business_master_new
loadtime:4.5387108325958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tower' limit 1
loadtime:4.5387558937073 / seconds
Query Executed:select id FROM `mi` where city='Tower' && SIC_code='5531'DB:business_master_new
loadtime:4.5392007827759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traunik' limit 1
loadtime:4.539244890213 / seconds
Query Executed:select id FROM `mi` where city='Traunik' && SIC_code='5531'DB:business_master_new
loadtime:4.5395178794861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traverse City' limit 1
loadtime:4.5395579338074 / seconds
Query Executed:select id FROM `mi` where city='Traverse City' && SIC_code='5531'DB:business_master_new
loadtime:4.5427589416504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenary' limit 1
loadtime:4.5428009033203 / seconds
Query Executed:select id FROM `mi` where city='Trenary' && SIC_code='5531'DB:business_master_new
loadtime:4.5442028045654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:4.5443508625031 / seconds
Query Executed:select id FROM `mi` where city='Trenton' && SIC_code='5531'DB:business_master_new
loadtime:4.5456008911133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Creek' limit 1
loadtime:4.5457589626312 / seconds
Query Executed:select id FROM `mi` where city='Trout Creek' && SIC_code='5531'DB:business_master_new
loadtime:4.5461668968201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Lake' limit 1
loadtime:4.5462169647217 / seconds
Query Executed:select id FROM `mi` where city='Trout Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.5468018054962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:4.5468878746033 / seconds
Query Executed:select id FROM `mi` where city='Troy' && SIC_code='5531'DB:business_master_new
loadtime:4.5505290031433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trufant' limit 1
loadtime:4.5505979061127 / seconds
Query Executed:select id FROM `mi` where city='Trufant' && SIC_code='5531'DB:business_master_new
loadtime:4.5512487888336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turner' limit 1
loadtime:4.5512998104095 / seconds
Query Executed:select id FROM `mi` where city='Turner' && SIC_code='5531'DB:business_master_new
loadtime:4.5524837970734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuscola' limit 1
loadtime:4.5525119304657 / seconds
Query Executed:select id FROM `mi` where city='Tuscola' && SIC_code='5531'DB:business_master_new
loadtime:4.5528178215027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tustin' limit 1
loadtime:4.5528829097748 / seconds
Query Executed:select id FROM `mi` where city='Tustin' && SIC_code='5531'DB:business_master_new
loadtime:4.5539548397064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lake' limit 1
loadtime:4.5539929866791 / seconds
Query Executed:select id FROM `mi` where city='Twin Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.5550539493561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twining' limit 1
loadtime:4.5550999641418 / seconds
Query Executed:select id FROM `mi` where city='Twining' && SIC_code='5531'DB:business_master_new
loadtime:4.5561709403992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ubly' limit 1
loadtime:4.5561978816986 / seconds
Query Executed:select id FROM `mi` where city='Ubly' && SIC_code='5531'DB:business_master_new
loadtime:4.5579957962036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:4.5580589771271 / seconds
Query Executed:select id FROM `mi` where city='Union' && SIC_code='5531'DB:business_master_new
loadtime:4.5592138767242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union City' limit 1
loadtime:4.55925989151 / seconds
Query Executed:select id FROM `mi` where city='Union City' && SIC_code='5531'DB:business_master_new
loadtime:4.5602028369904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Lake' limit 1
loadtime:4.5602509975433 / seconds
Query Executed:select id FROM `mi` where city='Union Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.5610368251801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Pier' limit 1
loadtime:4.561096906662 / seconds
Query Executed:select id FROM `mi` where city='Union Pier' && SIC_code='5531'DB:business_master_new
loadtime:4.5623469352722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:4.562374830246 / seconds
Query Executed:select id FROM `mi` where city='Unionville' && SIC_code='5531'DB:business_master_new
loadtime:4.5635249614716 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Center' limit 1
loadtime:4.5635628700256 / seconds
Query Executed:select id FROM `mi` where city='University Center' && SIC_code='5531'DB:business_master_new
loadtime:4.5638768672943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:4.5639028549194 / seconds
Query Executed:select id FROM `mi` where city='Utica' && SIC_code='5531'DB:business_master_new
loadtime:4.5660510063171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandalia' limit 1
loadtime:4.5661089420319 / seconds
Query Executed:select id FROM `mi` where city='Vandalia' && SIC_code='5531'DB:business_master_new
loadtime:4.5669138431549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderbilt' limit 1
loadtime:4.566948890686 / seconds
Query Executed:select id FROM `mi` where city='Vanderbilt' && SIC_code='5531'DB:business_master_new
loadtime:4.5675477981567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vassar' limit 1
loadtime:4.567587852478 / seconds
Query Executed:select id FROM `mi` where city='Vassar' && SIC_code='5531'DB:business_master_new
loadtime:4.5686309337616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermontville' limit 1
loadtime:4.5686748027802 / seconds
Query Executed:select id FROM `mi` where city='Vermontville' && SIC_code='5531'DB:business_master_new
loadtime:4.5699028968811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:4.5699298381805 / seconds
Query Executed:select id FROM `mi` where city='Vernon' && SIC_code='5531'DB:business_master_new
loadtime:4.5705409049988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vestaburg' limit 1
loadtime:4.5705828666687 / seconds
Query Executed:select id FROM `mi` where city='Vestaburg' && SIC_code='5531'DB:business_master_new
loadtime:4.5717329978943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:4.5717689990997 / seconds
Query Executed:select id FROM `mi` where city='Vicksburg' && SIC_code='5531'DB:business_master_new
loadtime:4.5728118419647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vulcan' limit 1
loadtime:4.5728549957275 / seconds
Query Executed:select id FROM `mi` where city='Vulcan' && SIC_code='5531'DB:business_master_new
loadtime:4.5735278129578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:4.5735528469086 / seconds
Query Executed:select id FROM `mi` where city='Wakefield' && SIC_code='5531'DB:business_master_new
loadtime:4.5749168395996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldron' limit 1
loadtime:4.5749788284302 / seconds
Query Executed:select id FROM `mi` where city='Waldron' && SIC_code='5531'DB:business_master_new
loadtime:4.5759389400482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:4.5759649276733 / seconds
Query Executed:select id FROM `mi` where city='Wales' && SIC_code='5531'DB:business_master_new
loadtime:4.5762259960175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:4.5762619972229 / seconds
Query Executed:select id FROM `mi` where city='Walhalla' && SIC_code='5531'DB:business_master_new
loadtime:4.5766639709473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerville' limit 1
loadtime:4.5766999721527 / seconds
Query Executed:select id FROM `mi` where city='Walkerville' && SIC_code='5531'DB:business_master_new
loadtime:4.5775067806244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:4.5775330066681 / seconds
Query Executed:select id FROM `mi` where city='Wallace' && SIC_code='5531'DB:business_master_new
loadtime:4.5782339572906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walled Lake' limit 1
loadtime:4.5782699584961 / seconds
Query Executed:select id FROM `mi` where city='Walled Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.5795278549194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walloon Lake' limit 1
loadtime:4.5795619487762 / seconds
Query Executed:select id FROM `mi` where city='Walloon Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.5802249908447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:4.5802619457245 / seconds
Query Executed:select id FROM `mi` where city='Warren' && SIC_code='5531'DB:business_master_new
loadtime:4.5832087993622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:4.583263874054 / seconds
Query Executed:select id FROM `mi` where city='Washington' && SIC_code='5531'DB:business_master_new
loadtime:4.5844628810883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:4.5845267772675 / seconds
Query Executed:select id FROM `mi` where city='Waterford' && SIC_code='5531'DB:business_master_new
loadtime:4.5870168209076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waters' limit 1
loadtime:4.587082862854 / seconds
Query Executed:select id FROM `mi` where city='Waters' && SIC_code='5531'DB:business_master_new
loadtime:4.5874588489532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watersmeet' limit 1
loadtime:4.5875058174133 / seconds
Query Executed:select id FROM `mi` where city='Watersmeet' && SIC_code='5531'DB:business_master_new
loadtime:4.5885138511658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watervliet' limit 1
loadtime:4.5885808467865 / seconds
Query Executed:select id FROM `mi` where city='Watervliet' && SIC_code='5531'DB:business_master_new
loadtime:4.589558839798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watton' limit 1
loadtime:4.5895948410034 / seconds
Query Executed:select id FROM `mi` where city='Watton' && SIC_code='5531'DB:business_master_new
loadtime:4.5899319648743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:4.589971780777 / seconds
Query Executed:select id FROM `mi` where city='Wayland' && SIC_code='5531'DB:business_master_new
loadtime:4.5910618305206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:4.5910959243774 / seconds
Query Executed:select id FROM `mi` where city='Wayne' && SIC_code='5531'DB:business_master_new
loadtime:4.592052936554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webberville' limit 1
loadtime:4.5920968055725 / seconds
Query Executed:select id FROM `mi` where city='Webberville' && SIC_code='5531'DB:business_master_new
loadtime:4.5930368900299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weidman' limit 1
loadtime:4.593062877655 / seconds
Query Executed:select id FROM `mi` where city='Weidman' && SIC_code='5531'DB:business_master_new
loadtime:4.5939998626709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:4.5940787792206 / seconds
Query Executed:select id FROM `mi` where city='Wells' && SIC_code='5531'DB:business_master_new
loadtime:4.5946378707886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellston' limit 1
loadtime:4.5946888923645 / seconds
Query Executed:select id FROM `mi` where city='Wellston' && SIC_code='5531'DB:business_master_new
loadtime:4.5962569713593 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bloomfield' limit 1
loadtime:4.5963180065155 / seconds
Query Executed:select id FROM `mi` where city='West Bloomfield' && SIC_code='5531'DB:business_master_new
loadtime:4.5985038280487 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:4.5985629558563 / seconds
Query Executed:select id FROM `mi` where city='West Branch' && SIC_code='5531'DB:business_master_new
loadtime:4.5998528003693 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Olive' limit 1
loadtime:4.5998919010162 / seconds
Query Executed:select id FROM `mi` where city='West Olive' && SIC_code='5531'DB:business_master_new
loadtime:4.6008949279785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westland' limit 1
loadtime:4.6009409427643 / seconds
Query Executed:select id FROM `mi` where city='Westland' && SIC_code='5531'DB:business_master_new
loadtime:4.6022379398346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:4.602283000946 / seconds
Query Executed:select id FROM `mi` where city='Weston' && SIC_code='5531'DB:business_master_new
loadtime:4.6026909351349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:4.6027338504791 / seconds
Query Executed:select id FROM `mi` where city='Westphalia' && SIC_code='5531'DB:business_master_new
loadtime:4.6035978794098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:4.6036379337311 / seconds
Query Executed:select id FROM `mi` where city='Wetmore' && SIC_code='5531'DB:business_master_new
loadtime:4.604306936264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:4.6043438911438 / seconds
Query Executed:select id FROM `mi` where city='Wheeler' && SIC_code='5531'DB:business_master_new
loadtime:4.6050548553467 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Cloud' limit 1
loadtime:4.6050930023193 / seconds
Query Executed:select id FROM `mi` where city='White Cloud' && SIC_code='5531'DB:business_master_new
loadtime:4.606113910675 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:4.6061480045319 / seconds
Query Executed:select id FROM `mi` where city='White Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.6074059009552 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pigeon' limit 1
loadtime:4.6074528694153 / seconds
Query Executed:select id FROM `mi` where city='White Pigeon' && SIC_code='5531'DB:business_master_new
loadtime:4.6091389656067 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pine' limit 1
loadtime:4.6091778278351 / seconds
Query Executed:select id FROM `mi` where city='White Pine' && SIC_code='5531'DB:business_master_new
loadtime:4.6095159053802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehall' limit 1
loadtime:4.6095588207245 / seconds
Query Executed:select id FROM `mi` where city='Whitehall' && SIC_code='5531'DB:business_master_new
loadtime:4.6106808185577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmore Lake' limit 1
loadtime:4.6107308864594 / seconds
Query Executed:select id FROM `mi` where city='Whitmore Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.6116909980774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittaker' limit 1
loadtime:4.6117417812347 / seconds
Query Executed:select id FROM `mi` where city='Whittaker' && SIC_code='5531'DB:business_master_new
loadtime:4.6121428012848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:4.6121687889099 / seconds
Query Executed:select id FROM `mi` where city='Whittemore' && SIC_code='5531'DB:business_master_new
loadtime:4.6132209300995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:4.6132829189301 / seconds
Query Executed:select id FROM `mi` where city='Williamsburg' && SIC_code='5531'DB:business_master_new
loadtime:4.6143338680267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:4.614376783371 / seconds
Query Executed:select id FROM `mi` where city='Williamston' && SIC_code='5531'DB:business_master_new
loadtime:4.6155297756195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:4.615562915802 / seconds
Query Executed:select id FROM `mi` where city='Willis' && SIC_code='5531'DB:business_master_new
loadtime:4.6162738800049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:4.6163129806519 / seconds
Query Executed:select id FROM `mi` where city='Wilson' && SIC_code='5531'DB:business_master_new
loadtime:4.6168868541718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winn' limit 1
loadtime:4.6169209480286 / seconds
Query Executed:select id FROM `mi` where city='Winn' && SIC_code='5531'DB:business_master_new
loadtime:4.6173839569092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wixom' limit 1
loadtime:4.6174199581146 / seconds
Query Executed:select id FROM `mi` where city='Wixom' && SIC_code='5531'DB:business_master_new
loadtime:4.6186938285828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine' limit 1
loadtime:4.6187388896942 / seconds
Query Executed:select id FROM `mi` where city='Wolverine' && SIC_code='5531'DB:business_master_new
loadtime:4.6201739311218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine Lake' limit 1
loadtime:4.6203019618988 / seconds
Query Executed:select id FROM `mi` where city='Wolverine Lake' && SIC_code='5531'DB:business_master_new
loadtime:4.6205928325653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:4.6206459999084 / seconds
Query Executed:select id FROM `mi` where city='Woodland' && SIC_code='5531'DB:business_master_new
loadtime:4.6215128898621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyandotte' limit 1
loadtime:4.6216139793396 / seconds
Query Executed:select id FROM `mi` where city='Wyandotte' && SIC_code='5531'DB:business_master_new
loadtime:4.6227979660034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:4.6229288578033 / seconds
Query Executed:select id FROM `mi` where city='Wyoming' && SIC_code='5531'DB:business_master_new
loadtime:4.62473487854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:4.62486577034 / seconds
Query Executed:select id FROM `mi` where city='Yale' && SIC_code='5531'DB:business_master_new
loadtime:4.625935792923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ypsilanti' limit 1
loadtime:4.6260797977448 / seconds
Query Executed:select id FROM `mi` where city='Ypsilanti' && SIC_code='5531'DB:business_master_new
loadtime:4.6276178359985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zeeland' limit 1
loadtime:4.627769947052 / seconds
Query Executed:select id FROM `mi` where city='Zeeland' && SIC_code='5531'DB:business_master_new
loadtime:4.6291539669037 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:4.6294198036194 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:4.6299479007721 / seconds
Operation template executed (chunk cache operation)
loadtime:4.6301188468933 / seconds
template override:Default
loadtime:4.6301398277283 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:4.6313269138336 / seconds
Template Constructed, Array Rows:49
loadtime:4.6319899559021 / seconds
TOTAL EXECUTION TIME: 4.63141
loadtime:4.6322529315948 / 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] => auto-and-home-supply-stores [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:4.6322619915009
TOTAL KEY ARRAYS: 69