Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00010395050048828 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0023798942565918 / seconds
host not found setting manual db connection
loadtime:0.010151863098145 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010412931442261 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010641813278198 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010710954666138 / seconds
zipcode:
loadtime:0.010738849639893 / seconds
Query Executed:select * from search_referrer where page_hash='c24986acb7887ee252445b0b52fb8949' limit 10 DB:ezrox_toadli
loadtime:0.011010885238647 / seconds
Operation header executed (non global)
loadtime:0.011043787002563 / seconds
Operation leaderboard executed (non global)
loadtime:0.011096000671387 / seconds
Operation square executed (non global)
loadtime:0.011124849319458 / seconds
Operation square_bottom executed (non global)
loadtime:0.011152982711792 / seconds
Operation smallsquare executed (non global)
loadtime:0.011177778244019 / seconds
Operation headeradright executed (non global)
loadtime:0.011202812194824 / seconds
Operation google_analytics executed (non global)
loadtime:0.01122784614563 / seconds
Operation topstories executed (non global)
loadtime:0.011252880096436 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011279821395874 / seconds
Operation memberbuscount executed (non global)
loadtime:0.01130485534668 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01157283782959 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011761903762817 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011817932128906 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011891841888428 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011941909790039 / seconds
Template key: archive_menu pushed
loadtime:0.011951923370361 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011964797973633 / seconds
Template key: get_gravatar pushed
loadtime:0.011971950531006 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011980772018433 / seconds
*10)-10)+1 | start:0
loadtime:0.012021780014038 / seconds
Query loaded from cache:select * from categories where cat_URLid='retail-bakeries'
loadtime:0.012061834335327 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.012097835540771 / seconds
DB connected to localhost business_master_new
loadtime:0.012367963790894 / seconds
Query Executed:select * from `mi_catmap` where sic='5461' order by city ascDB:business_master_new
loadtime:0.04590892791748 / seconds
Query stored in cache : _QUERY_www.toadli.com8ecaef22153d1099dc423415e2541d32
loadtime:0.049723863601685 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.049798965454102 / seconds
Query Executed:select sum(totalcount) as totalsum from `mi_catmap` where sic='5461'DB:business_master_new
loadtime:0.055570840835571 / seconds
Query stored in cache : _QUERY_www.toadli.com3c3b8843fa86b9b0ce2442552fe09ee5
loadtime:0.055615901947021 / seconds
966 / 11
loadtime:0.055677890777588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acme' limit 1
loadtime:0.055744886398315 / seconds
Query Executed:select id FROM `mi` where city='Acme' && SIC_code='5461'DB:business_master_new
loadtime:0.07113790512085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ada' limit 1
loadtime:0.071201801300049 / seconds
Query Executed:select id FROM `mi` where city='Ada' && SIC_code='5461'DB:business_master_new
loadtime:0.078473806381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison' limit 1
loadtime:0.078540802001953 / seconds
Query Executed:select id FROM `mi` where city='Addison' && SIC_code='5461'DB:business_master_new
loadtime:0.080347776412964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison Twp' limit 1
loadtime:0.080410003662109 / seconds
Query Executed:select id FROM `mi` where city='Addison Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.080883979797363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adrian' limit 1
loadtime:0.080944776535034 / seconds
Query Executed:select id FROM `mi` where city='Adrian' && SIC_code='5461'DB:business_master_new
loadtime:0.089630842208862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.089721918106079 / seconds
Query Executed:select id FROM `mi` where city='Afton' && SIC_code='5461'DB:business_master_new
loadtime:0.09040093421936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahmeek' limit 1
loadtime:0.09046483039856 / seconds
Query Executed:select id FROM `mi` where city='Ahmeek' && SIC_code='5461'DB:business_master_new
loadtime:0.090966939926147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.091028928756714 / seconds
Query Executed:select id FROM `mi` where city='Akron' && SIC_code='5461'DB:business_master_new
loadtime:0.091888904571533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alanson' limit 1
loadtime:0.0919508934021 / seconds
Query Executed:select id FROM `mi` where city='Alanson' && SIC_code='5461'DB:business_master_new
loadtime:0.094484806060791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alba' limit 1
loadtime:0.094560861587524 / seconds
Query Executed:select id FROM `mi` where city='Alba' && SIC_code='5461'DB:business_master_new
loadtime:0.095195770263672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.095256805419922 / seconds
Query Executed:select id FROM `mi` where city='Albion' && SIC_code='5461'DB:business_master_new
loadtime:0.10122895240784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.10129380226135 / seconds
Query Executed:select id FROM `mi` where city='Alden' && SIC_code='5461'DB:business_master_new
loadtime:0.10231900215149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alger' limit 1
loadtime:0.10239481925964 / seconds
Query Executed:select id FROM `mi` where city='Alger' && SIC_code='5461'DB:business_master_new
loadtime:0.10356879234314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algonac' limit 1
loadtime:0.10363698005676 / seconds
Query Executed:select id FROM `mi` where city='Algonac' && SIC_code='5461'DB:business_master_new
loadtime:0.10881686210632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allegan' limit 1
loadtime:0.1088809967041 / seconds
Query Executed:select id FROM `mi` where city='Allegan' && SIC_code='5461'DB:business_master_new
loadtime:0.11753582954407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.11759877204895 / seconds
Query Executed:select id FROM `mi` where city='Allen' && SIC_code='5461'DB:business_master_new
loadtime:0.11866188049316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen Park' limit 1
loadtime:0.11871695518494 / seconds
Query Executed:select id FROM `mi` where city='Allen Park' && SIC_code='5461'DB:business_master_new
loadtime:0.12361693382263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.12368893623352 / seconds
Query Executed:select id FROM `mi` where city='Allendale' && SIC_code='5461'DB:business_master_new
loadtime:0.12812781333923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenton' limit 1
loadtime:0.12819600105286 / seconds
Query Executed:select id FROM `mi` where city='Allenton' && SIC_code='5461'DB:business_master_new
loadtime:0.12942290306091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allouez' limit 1
loadtime:0.12947797775269 / seconds
Query Executed:select id FROM `mi` where city='Allouez' && SIC_code='5461'DB:business_master_new
loadtime:0.12999892234802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.13005089759827 / seconds
Query Executed:select id FROM `mi` where city='Alma' && SIC_code='5461'DB:business_master_new
loadtime:0.13692998886108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almont' limit 1
loadtime:0.13699889183044 / seconds
Query Executed:select id FROM `mi` where city='Almont' && SIC_code='5461'DB:business_master_new
loadtime:0.13965892791748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.13972592353821 / seconds
Query Executed:select id FROM `mi` where city='Alpena' && SIC_code='5461'DB:business_master_new
loadtime:0.15385293960571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.15392279624939 / seconds
Query Executed:select id FROM `mi` where city='Alpha' && SIC_code='5461'DB:business_master_new
loadtime:0.15439486503601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.15444898605347 / seconds
Query Executed:select id FROM `mi` where city='Alto' && SIC_code='5461'DB:business_master_new
loadtime:0.15699696540833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amasa' limit 1
loadtime:0.15705299377441 / seconds
Query Executed:select id FROM `mi` where city='Amasa' && SIC_code='5461'DB:business_master_new
loadtime:0.15751695632935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anchorville' limit 1
loadtime:0.15756893157959 / seconds
Query Executed:select id FROM `mi` where city='Anchorville' && SIC_code='5461'DB:business_master_new
loadtime:0.15806078910828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ann Arbor' limit 1
loadtime:0.15811491012573 / seconds
Query Executed:select id FROM `mi` where city='Ann Arbor' && SIC_code='5461'DB:business_master_new
loadtime:0.16573786735535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Applegate' limit 1
loadtime:0.16581892967224 / seconds
Query Executed:select id FROM `mi` where city='Applegate' && SIC_code='5461'DB:business_master_new
loadtime:0.16663885116577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.16669178009033 / seconds
Query Executed:select id FROM `mi` where city='Arcadia' && SIC_code='5461'DB:business_master_new
loadtime:0.1675968170166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.16765379905701 / seconds
Query Executed:select id FROM `mi` where city='Argyle' && SIC_code='5461'DB:business_master_new
loadtime:0.16805386543274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armada' limit 1
loadtime:0.16810584068298 / seconds
Query Executed:select id FROM `mi` where city='Armada' && SIC_code='5461'DB:business_master_new
loadtime:0.17092394828796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnold' limit 1
loadtime:0.17098999023438 / seconds
Query Executed:select id FROM `mi` where city='Arnold' && SIC_code='5461'DB:business_master_new
loadtime:0.17143177986145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley' limit 1
loadtime:0.17148399353027 / seconds
Query Executed:select id FROM `mi` where city='Ashley' && SIC_code='5461'DB:business_master_new
loadtime:0.17243599891663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.17248797416687 / seconds
Query Executed:select id FROM `mi` where city='Athens' && SIC_code='5461'DB:business_master_new
loadtime:0.17378497123718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlanta' limit 1
loadtime:0.17383694648743 / seconds
Query Executed:select id FROM `mi` where city='Atlanta' && SIC_code='5461'DB:business_master_new
loadtime:0.17496180534363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Mine' limit 1
loadtime:0.17501592636108 / seconds
Query Executed:select id FROM `mi` where city='Atlantic Mine' && SIC_code='5461'DB:business_master_new
loadtime:0.17584085464478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlas' limit 1
loadtime:0.17589378356934 / seconds
Query Executed:select id FROM `mi` where city='Atlas' && SIC_code='5461'DB:business_master_new
loadtime:0.17639684677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attica' limit 1
loadtime:0.17644786834717 / seconds
Query Executed:select id FROM `mi` where city='Attica' && SIC_code='5461'DB:business_master_new
loadtime:0.17814183235168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Gres' limit 1
loadtime:0.17819499969482 / seconds
Query Executed:select id FROM `mi` where city='Au Gres' && SIC_code='5461'DB:business_master_new
loadtime:0.18035483360291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Train' limit 1
loadtime:0.18040800094604 / seconds
Query Executed:select id FROM `mi` where city='Au Train' && SIC_code='5461'DB:business_master_new
loadtime:0.18113684654236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.1811888217926 / seconds
Query Executed:select id FROM `mi` where city='Auburn' && SIC_code='5461'DB:business_master_new
loadtime:0.18423295021057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn Hills' limit 1
loadtime:0.18430089950562 / seconds
Query Executed:select id FROM `mi` where city='Auburn Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.19158387184143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.191654920578 / seconds
Query Executed:select id FROM `mi` where city='Augusta' && SIC_code='5461'DB:business_master_new
loadtime:0.19378280639648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.1938488483429 / seconds
Query Executed:select id FROM `mi` where city='Avoca' && SIC_code='5461'DB:business_master_new
loadtime:0.19529700279236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Azalia' limit 1
loadtime:0.19535183906555 / seconds
Query Executed:select id FROM `mi` where city='Azalia' && SIC_code='5461'DB:business_master_new
loadtime:0.19574594497681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bad Axe' limit 1
loadtime:0.19580698013306 / seconds
Query Executed:select id FROM `mi` where city='Bad Axe' && SIC_code='5461'DB:business_master_new
loadtime:0.20279598236084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.20286297798157 / seconds
Query Executed:select id FROM `mi` where city='Bailey' && SIC_code='5461'DB:business_master_new
loadtime:0.20353388786316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.20359897613525 / seconds
Query Executed:select id FROM `mi` where city='Baldwin' && SIC_code='5461'DB:business_master_new
loadtime:0.20663380622864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.20668888092041 / seconds
Query Executed:select id FROM `mi` where city='Bancroft' && SIC_code='5461'DB:business_master_new
loadtime:0.20781993865967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bangor' limit 1
loadtime:0.20787382125854 / seconds
Query Executed:select id FROM `mi` where city='Bangor' && SIC_code='5461'DB:business_master_new
loadtime:0.21070384979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bannister' limit 1
loadtime:0.21075677871704 / seconds
Query Executed:select id FROM `mi` where city='Bannister' && SIC_code='5461'DB:business_master_new
loadtime:0.21147489547729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baraga' limit 1
loadtime:0.21152782440186 / seconds
Query Executed:select id FROM `mi` where city='Baraga' && SIC_code='5461'DB:business_master_new
loadtime:0.21328783035278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barbeau' limit 1
loadtime:0.21334099769592 / seconds
Query Executed:select id FROM `mi` where city='Barbeau' && SIC_code='5461'DB:business_master_new
loadtime:0.21391987800598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bark River' limit 1
loadtime:0.21397590637207 / seconds
Query Executed:select id FROM `mi` where city='Bark River' && SIC_code='5461'DB:business_master_new
loadtime:0.21530485153198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baroda' limit 1
loadtime:0.21537184715271 / seconds
Query Executed:select id FROM `mi` where city='Baroda' && SIC_code='5461'DB:business_master_new
loadtime:0.21726083755493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barryton' limit 1
loadtime:0.2173159122467 / seconds
Query Executed:select id FROM `mi` where city='Barryton' && SIC_code='5461'DB:business_master_new
loadtime:0.21856999397278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton City' limit 1
loadtime:0.21862578392029 / seconds
Query Executed:select id FROM `mi` where city='Barton City' && SIC_code='5461'DB:business_master_new
loadtime:0.21923398971558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.21928477287292 / seconds
Query Executed:select id FROM `mi` where city='Bath' && SIC_code='5461'DB:business_master_new
loadtime:0.22128677368164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.22133994102478 / seconds
Query Executed:select id FROM `mi` where city='Battle Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.22874593734741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.22883296012878 / seconds
Query Executed:select id FROM `mi` where city='Bay City' && SIC_code='5461'DB:business_master_new
loadtime:0.23610997200012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Port' limit 1
loadtime:0.23619079589844 / seconds
Query Executed:select id FROM `mi` where city='Bay Port' && SIC_code='5461'DB:business_master_new
loadtime:0.2371928691864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Shore' limit 1
loadtime:0.23726081848145 / seconds
Query Executed:select id FROM `mi` where city='Bay Shore' && SIC_code='5461'DB:business_master_new
loadtime:0.23768091201782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay View' limit 1
loadtime:0.23773598670959 / seconds
Query Executed:select id FROM `mi` where city='Bay View' && SIC_code='5461'DB:business_master_new
loadtime:0.2381157875061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Lake' limit 1
loadtime:0.23816895484924 / seconds
Query Executed:select id FROM `mi` where city='Bear Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.24001288414001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver Island' limit 1
loadtime:0.24006795883179 / seconds
Query Executed:select id FROM `mi` where city='Beaver Island' && SIC_code='5461'DB:business_master_new
loadtime:0.24152398109436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverton' limit 1
loadtime:0.24158978462219 / seconds
Query Executed:select id FROM `mi` where city='Beaverton' && SIC_code='5461'DB:business_master_new
loadtime:0.24478697776794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.24484086036682 / seconds
Query Executed:select id FROM `mi` where city='Bedford' && SIC_code='5461'DB:business_master_new
loadtime:0.24531483650208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belding' limit 1
loadtime:0.24536800384521 / seconds
Query Executed:select id FROM `mi` where city='Belding' && SIC_code='5461'DB:business_master_new
loadtime:0.25029492378235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellaire' limit 1
loadtime:0.25034880638123 / seconds
Query Executed:select id FROM `mi` where city='Bellaire' && SIC_code='5461'DB:business_master_new
loadtime:0.25472378730774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.2547869682312 / seconds
Query Executed:select id FROM `mi` where city='Belleville' && SIC_code='5461'DB:business_master_new
loadtime:0.26042890548706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.26048278808594 / seconds
Query Executed:select id FROM `mi` where city='Bellevue' && SIC_code='5461'DB:business_master_new
loadtime:0.2625777721405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.26263499259949 / seconds
Query Executed:select id FROM `mi` where city='Belmont' && SIC_code='5461'DB:business_master_new
loadtime:0.26597881317139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentley' limit 1
loadtime:0.26603293418884 / seconds
Query Executed:select id FROM `mi` where city='Bentley' && SIC_code='5461'DB:business_master_new
loadtime:0.26659393310547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton Harbor' limit 1
loadtime:0.26665186882019 / seconds
Query Executed:select id FROM `mi` where city='Benton Harbor' && SIC_code='5461'DB:business_master_new
loadtime:0.27407193183899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benzonia' limit 1
loadtime:0.27414393424988 / seconds
Query Executed:select id FROM `mi` where city='Benzonia' && SIC_code='5461'DB:business_master_new
loadtime:0.2760329246521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergland' limit 1
loadtime:0.27608799934387 / seconds
Query Executed:select id FROM `mi` where city='Bergland' && SIC_code='5461'DB:business_master_new
loadtime:0.27658796310425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.27664589881897 / seconds
Query Executed:select id FROM `mi` where city='Berkley' && SIC_code='5461'DB:business_master_new
loadtime:0.28457379341125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.28465580940247 / seconds
Query Executed:select id FROM `mi` where city='Berlin' && SIC_code='5461'DB:business_master_new
loadtime:0.28505897521973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Center' limit 1
loadtime:0.28511595726013 / seconds
Query Executed:select id FROM `mi` where city='Berrien Center' && SIC_code='5461'DB:business_master_new
loadtime:0.28609800338745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Springs' limit 1
loadtime:0.28615093231201 / seconds
Query Executed:select id FROM `mi` where city='Berrien Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.29211378097534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berville' limit 1
loadtime:0.29217982292175 / seconds
Query Executed:select id FROM `mi` where city='Berville' && SIC_code='5461'DB:business_master_new
loadtime:0.29257798194885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer' limit 1
loadtime:0.29263591766357 / seconds
Query Executed:select id FROM `mi` where city='Bessemer' && SIC_code='5461'DB:business_master_new
loadtime:0.29463982582092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.29470777511597 / seconds
Query Executed:select id FROM `mi` where city='Beulah' && SIC_code='5461'DB:business_master_new
loadtime:0.29816579818726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly Hills' limit 1
loadtime:0.29821991920471 / seconds
Query Executed:select id FROM `mi` where city='Beverly Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.29886484146118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bay' limit 1
loadtime:0.29891777038574 / seconds
Query Executed:select id FROM `mi` where city='Big Bay' && SIC_code='5461'DB:business_master_new
loadtime:0.29957580566406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rapids' limit 1
loadtime:0.29963183403015 / seconds
Query Executed:select id FROM `mi` where city='Big Rapids' && SIC_code='5461'DB:business_master_new
loadtime:0.30945086479187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham Farms' limit 1
loadtime:0.30952095985413 / seconds
Query Executed:select id FROM `mi` where city='Bingham Farms' && SIC_code='5461'DB:business_master_new
loadtime:0.30995893478394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birch Run' limit 1
loadtime:0.31001377105713 / seconds
Query Executed:select id FROM `mi` where city='Birch Run' && SIC_code='5461'DB:business_master_new
loadtime:0.31500792503357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.31507396697998 / seconds
Query Executed:select id FROM `mi` where city='Birmingham' && SIC_code='5461'DB:business_master_new
loadtime:0.32255291938782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bitely' limit 1
loadtime:0.32263684272766 / seconds
Query Executed:select id FROM `mi` where city='Bitely' && SIC_code='5461'DB:business_master_new
loadtime:0.32345986366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River' limit 1
loadtime:0.32351493835449 / seconds
Query Executed:select id FROM `mi` where city='Black River' && SIC_code='5461'DB:business_master_new
loadtime:0.32404685020447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.32409882545471 / seconds
Query Executed:select id FROM `mi` where city='Blanchard' && SIC_code='5461'DB:business_master_new
loadtime:0.32547283172607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blissfield' limit 1
loadtime:0.32552599906921 / seconds
Query Executed:select id FROM `mi` where city='Blissfield' && SIC_code='5461'DB:business_master_new
loadtime:0.32881283760071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Hills' limit 1
loadtime:0.32887887954712 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.33615899085999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Twp' limit 1
loadtime:0.33622884750366 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.33673882484436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingdale' limit 1
loadtime:0.33680081367493 / seconds
Query Executed:select id FROM `mi` where city='Bloomingdale' && SIC_code='5461'DB:business_master_new
loadtime:0.3381769657135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boon' limit 1
loadtime:0.33823084831238 / seconds
Query Executed:select id FROM `mi` where city='Boon' && SIC_code='5461'DB:business_master_new
loadtime:0.33880996704102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne City' limit 1
loadtime:0.33886384963989 / seconds
Query Executed:select id FROM `mi` where city='Boyne City' && SIC_code='5461'DB:business_master_new
loadtime:0.3444287776947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne Falls' limit 1
loadtime:0.34449696540833 / seconds
Query Executed:select id FROM `mi` where city='Boyne Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.3457989692688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.34585380554199 / seconds
Query Executed:select id FROM `mi` where city='Bradley' && SIC_code='5461'DB:business_master_new
loadtime:0.3462769985199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branch' limit 1
loadtime:0.34632778167725 / seconds
Query Executed:select id FROM `mi` where city='Branch' && SIC_code='5461'DB:business_master_new
loadtime:0.34716176986694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant' limit 1
loadtime:0.3472158908844 / seconds
Query Executed:select id FROM `mi` where city='Brant' && SIC_code='5461'DB:business_master_new
loadtime:0.34802389144897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breckenridge' limit 1
loadtime:0.34807682037354 / seconds
Query Executed:select id FROM `mi` where city='Breckenridge' && SIC_code='5461'DB:business_master_new
loadtime:0.34963488578796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breedsville' limit 1
loadtime:0.34968781471252 / seconds
Query Executed:select id FROM `mi` where city='Breedsville' && SIC_code='5461'DB:business_master_new
loadtime:0.35011887550354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brethren' limit 1
loadtime:0.35017085075378 / seconds
Query Executed:select id FROM `mi` where city='Brethren' && SIC_code='5461'DB:business_master_new
loadtime:0.35100483894348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.35105800628662 / seconds
Query Executed:select id FROM `mi` where city='Bridgeport' && SIC_code='5461'DB:business_master_new
loadtime:0.35351586341858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.35358190536499 / seconds
Query Executed:select id FROM `mi` where city='Bridgewater' && SIC_code='5461'DB:business_master_new
loadtime:0.35403800010681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgman' limit 1
loadtime:0.35409283638 / seconds
Query Executed:select id FROM `mi` where city='Bridgman' && SIC_code='5461'DB:business_master_new
loadtime:0.35719394683838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.35724687576294 / seconds
Query Executed:select id FROM `mi` where city='Brighton' && SIC_code='5461'DB:business_master_new
loadtime:0.36455583572388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimley' limit 1
loadtime:0.36463379859924 / seconds
Query Executed:select id FROM `mi` where city='Brimley' && SIC_code='5461'DB:business_master_new
loadtime:0.36606097221375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.36611890792847 / seconds
Query Executed:select id FROM `mi` where city='Britton' && SIC_code='5461'DB:business_master_new
loadtime:0.36764478683472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockway' limit 1
loadtime:0.36769795417786 / seconds
Query Executed:select id FROM `mi` where city='Brockway' && SIC_code='5461'DB:business_master_new
loadtime:0.36807298660278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brohman' limit 1
loadtime:0.36812686920166 / seconds
Query Executed:select id FROM `mi` where city='Brohman' && SIC_code='5461'DB:business_master_new
loadtime:0.3686158657074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.36866879463196 / seconds
Query Executed:select id FROM `mi` where city='Bronson' && SIC_code='5461'DB:business_master_new
loadtime:0.37114381790161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.37119698524475 / seconds
Query Executed:select id FROM `mi` where city='Brooklyn' && SIC_code='5461'DB:business_master_new
loadtime:0.37647080421448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brown City' limit 1
loadtime:0.37653994560242 / seconds
Query Executed:select id FROM `mi` where city='Brown City' && SIC_code='5461'DB:business_master_new
loadtime:0.37941384315491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownstown Twp' limit 1
loadtime:0.37946891784668 / seconds
Query Executed:select id FROM `mi` where city='Brownstown Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.3799409866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.37999486923218 / seconds
Query Executed:select id FROM `mi` where city='Bruce' && SIC_code='5461'DB:business_master_new
loadtime:0.38037586212158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce Crossing' limit 1
loadtime:0.38042783737183 / seconds
Query Executed:select id FROM `mi` where city='Bruce Crossing' && SIC_code='5461'DB:business_master_new
loadtime:0.38112187385559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brutus' limit 1
loadtime:0.38117384910583 / seconds
Query Executed:select id FROM `mi` where city='Brutus' && SIC_code='5461'DB:business_master_new
loadtime:0.38203382492065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:0.38208794593811 / seconds
Query Executed:select id FROM `mi` where city='Buchanan' && SIC_code='5461'DB:business_master_new
loadtime:0.38700985908508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckley' limit 1
loadtime:0.38706278800964 / seconds
Query Executed:select id FROM `mi` where city='Buckley' && SIC_code='5461'DB:business_master_new
loadtime:0.38849496841431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.38854789733887 / seconds
Query Executed:select id FROM `mi` where city='Burlington' && SIC_code='5461'DB:business_master_new
loadtime:0.38951396942139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnips' limit 1
loadtime:0.38956689834595 / seconds
Query Executed:select id FROM `mi` where city='Burnips' && SIC_code='5461'DB:business_master_new
loadtime:0.39006686210632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Oak' limit 1
loadtime:0.39011979103088 / seconds
Query Executed:select id FROM `mi` where city='Burr Oak' && SIC_code='5461'DB:business_master_new
loadtime:0.39089584350586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:0.39094877243042 / seconds
Query Executed:select id FROM `mi` where city='Burt' && SIC_code='5461'DB:business_master_new
loadtime:0.39204096794128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt Lake' limit 1
loadtime:0.39209389686584 / seconds
Query Executed:select id FROM `mi` where city='Burt Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.39255499839783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burtchville' limit 1
loadtime:0.39261078834534 / seconds
Query Executed:select id FROM `mi` where city='Burtchville' && SIC_code='5461'DB:business_master_new
loadtime:0.39306998252869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burton' limit 1
loadtime:0.39312291145325 / seconds
Query Executed:select id FROM `mi` where city='Burton' && SIC_code='5461'DB:business_master_new
loadtime:0.40620279312134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:0.40627384185791 / seconds
Query Executed:select id FROM `mi` where city='Byron' && SIC_code='5461'DB:business_master_new
loadtime:0.40819597244263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron Center' limit 1
loadtime:0.40825080871582 / seconds
Query Executed:select id FROM `mi` where city='Byron Center' && SIC_code='5461'DB:business_master_new
loadtime:0.41627287864685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cadillac' limit 1
loadtime:0.41632699966431 / seconds
Query Executed:select id FROM `mi` where city='Cadillac' && SIC_code='5461'DB:business_master_new
loadtime:0.42915391921997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.42922186851501 / seconds
Query Executed:select id FROM `mi` where city='Caledonia' && SIC_code='5461'DB:business_master_new
loadtime:0.43664193153381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.43669581413269 / seconds
Query Executed:select id FROM `mi` where city='Calumet' && SIC_code='5461'DB:business_master_new
loadtime:0.44136381149292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.44142985343933 / seconds
Query Executed:select id FROM `mi` where city='Camden' && SIC_code='5461'DB:business_master_new
loadtime:0.44268178939819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannonsburg' limit 1
loadtime:0.44273591041565 / seconds
Query Executed:select id FROM `mi` where city='Cannonsburg' && SIC_code='5461'DB:business_master_new
loadtime:0.4432327747345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.44328498840332 / seconds
Query Executed:select id FROM `mi` where city='Canton' && SIC_code='5461'DB:business_master_new
loadtime:0.45384097099304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capac' limit 1
loadtime:0.4538938999176 / seconds
Query Executed:select id FROM `mi` where city='Capac' && SIC_code='5461'DB:business_master_new
loadtime:0.45615792274475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carleton' limit 1
loadtime:0.45621180534363 / seconds
Query Executed:select id FROM `mi` where city='Carleton' && SIC_code='5461'DB:business_master_new
loadtime:0.45974087715149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carney' limit 1
loadtime:0.45980286598206 / seconds
Query Executed:select id FROM `mi` where city='Carney' && SIC_code='5461'DB:business_master_new
loadtime:0.46049785614014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caro' limit 1
loadtime:0.46054887771606 / seconds
Query Executed:select id FROM `mi` where city='Caro' && SIC_code='5461'DB:business_master_new
loadtime:0.46824193000793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carp Lake' limit 1
loadtime:0.46829390525818 / seconds
Query Executed:select id FROM `mi` where city='Carp Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.46905398368835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.4691059589386 / seconds
Query Executed:select id FROM `mi` where city='Carrollton' && SIC_code='5461'DB:business_master_new
loadtime:0.46975183486938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson City' limit 1
loadtime:0.46981477737427 / seconds
Query Executed:select id FROM `mi` where city='Carson City' && SIC_code='5461'DB:business_master_new
loadtime:0.47217679023743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carsonville' limit 1
loadtime:0.47222995758057 / seconds
Query Executed:select id FROM `mi` where city='Carsonville' && SIC_code='5461'DB:business_master_new
loadtime:0.47377586364746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casco' limit 1
loadtime:0.47382879257202 / seconds
Query Executed:select id FROM `mi` where city='Casco' && SIC_code='5461'DB:business_master_new
loadtime:0.47540998458862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caseville' limit 1
loadtime:0.47546195983887 / seconds
Query Executed:select id FROM `mi` where city='Caseville' && SIC_code='5461'DB:business_master_new
loadtime:0.47735285758972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casnovia' limit 1
loadtime:0.47740578651428 / seconds
Query Executed:select id FROM `mi` where city='Casnovia' && SIC_code='5461'DB:business_master_new
loadtime:0.47830891609192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caspian' limit 1
loadtime:0.47836399078369 / seconds
Query Executed:select id FROM `mi` where city='Caspian' && SIC_code='5461'DB:business_master_new
loadtime:0.47926688194275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cass City' limit 1
loadtime:0.47931885719299 / seconds
Query Executed:select id FROM `mi` where city='Cass City' && SIC_code='5461'DB:business_master_new
loadtime:0.48315978050232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassopolis' limit 1
loadtime:0.48321390151978 / seconds
Query Executed:select id FROM `mi` where city='Cassopolis' && SIC_code='5461'DB:business_master_new
loadtime:0.48740482330322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.48745799064636 / seconds
Query Executed:select id FROM `mi` where city='Cedar' && SIC_code='5461'DB:business_master_new
loadtime:0.4892258644104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Lake' limit 1
loadtime:0.48927783966064 / seconds
Query Executed:select id FROM `mi` where city='Cedar Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.4898099899292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar River' limit 1
loadtime:0.48986291885376 / seconds
Query Executed:select id FROM `mi` where city='Cedar River' && SIC_code='5461'DB:business_master_new
loadtime:0.49024891853333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Springs' limit 1
loadtime:0.4903028011322 / seconds
Query Executed:select id FROM `mi` where city='Cedar Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.496013879776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:0.49608278274536 / seconds
Query Executed:select id FROM `mi` where city='Cedarville' && SIC_code='5461'DB:business_master_new
loadtime:0.49774384498596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cement City' limit 1
loadtime:0.49780678749084 / seconds
Query Executed:select id FROM `mi` where city='Cement City' && SIC_code='5461'DB:business_master_new
loadtime:0.49927282333374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Line' limit 1
loadtime:0.4993360042572 / seconds
Query Executed:select id FROM `mi` where city='Center Line' && SIC_code='5461'DB:business_master_new
loadtime:0.50372385978699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Lake' limit 1
loadtime:0.5038149356842 / seconds
Query Executed:select id FROM `mi` where city='Central Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.50579786300659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.50587391853333 / seconds
Query Executed:select id FROM `mi` where city='Centreville' && SIC_code='5461'DB:business_master_new
loadtime:0.50698399543762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceresco' limit 1
loadtime:0.50705885887146 / seconds
Query Executed:select id FROM `mi` where city='Ceresco' && SIC_code='5461'DB:business_master_new
loadtime:0.50796580314636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champion' limit 1
loadtime:0.50802779197693 / seconds
Query Executed:select id FROM `mi` where city='Champion' && SIC_code='5461'DB:business_master_new
loadtime:0.50899577140808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Channing' limit 1
loadtime:0.50905799865723 / seconds
Query Executed:select id FROM `mi` where city='Channing' && SIC_code='5461'DB:business_master_new
loadtime:0.50969290733337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlevoix' limit 1
loadtime:0.50975394248962 / seconds
Query Executed:select id FROM `mi` where city='Charlevoix' && SIC_code='5461'DB:business_master_new
loadtime:0.51810383796692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.5181839466095 / seconds
Query Executed:select id FROM `mi` where city='Charlotte' && SIC_code='5461'DB:business_master_new
loadtime:0.52841997146606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase' limit 1
loadtime:0.52850079536438 / seconds
Query Executed:select id FROM `mi` where city='Chase' && SIC_code='5461'DB:business_master_new
loadtime:0.52923798561096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chassell' limit 1
loadtime:0.52930092811584 / seconds
Query Executed:select id FROM `mi` where city='Chassell' && SIC_code='5461'DB:business_master_new
loadtime:0.5307137966156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.53078579902649 / seconds
Query Executed:select id FROM `mi` where city='Chatham' && SIC_code='5461'DB:business_master_new
loadtime:0.53178095817566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheboygan' limit 1
loadtime:0.53184294700623 / seconds
Query Executed:select id FROM `mi` where city='Cheboygan' && SIC_code='5461'DB:business_master_new
loadtime:0.54137277603149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.5414559841156 / seconds
Query Executed:select id FROM `mi` where city='Chelsea' && SIC_code='5461'DB:business_master_new
loadtime:0.5455858707428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesaning' limit 1
loadtime:0.54565596580505 / seconds
Query Executed:select id FROM `mi` where city='Chesaning' && SIC_code='5461'DB:business_master_new
loadtime:0.54939293861389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.54946899414062 / seconds
Query Executed:select id FROM `mi` where city='Chesterfield' && SIC_code='5461'DB:business_master_new
loadtime:0.55030298233032 / seconds
Query loaded from cache:select * from geodata_geocity where city='China' limit 1
loadtime:0.55036497116089 / seconds
Query Executed:select id FROM `mi` where city='China' && SIC_code='5461'DB:business_master_new
loadtime:0.55078792572021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chippewa Lake' limit 1
loadtime:0.55084991455078 / seconds
Query Executed:select id FROM `mi` where city='Chippewa Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.55135893821716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christmas' limit 1
loadtime:0.55141878128052 / seconds
Query Executed:select id FROM `mi` where city='Christmas' && SIC_code='5461'DB:business_master_new
loadtime:0.55184483528137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:0.55190587043762 / seconds
Query Executed:select id FROM `mi` where city='Clare' && SIC_code='5461'DB:business_master_new
loadtime:0.55791783332825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarklake' limit 1
loadtime:0.55801296234131 / seconds
Query Executed:select id FROM `mi` where city='Clarklake' && SIC_code='5461'DB:business_master_new
loadtime:0.5595018863678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:0.55956387519836 / seconds
Query Executed:select id FROM `mi` where city='Clarkston' && SIC_code='5461'DB:business_master_new
loadtime:0.56729388237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.56737589836121 / seconds
Query Executed:select id FROM `mi` where city='Clarksville' && SIC_code='5461'DB:business_master_new
loadtime:0.5685179233551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clawson' limit 1
loadtime:0.56858086585999 / seconds
Query Executed:select id FROM `mi` where city='Clawson' && SIC_code='5461'DB:business_master_new
loadtime:0.57569098472595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay' limit 1
loadtime:0.57578182220459 / seconds
Query Executed:select id FROM `mi` where city='Clay' && SIC_code='5461'DB:business_master_new
loadtime:0.57625079154968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.57631397247314 / seconds
Query Executed:select id FROM `mi` where city='Clayton' && SIC_code='5461'DB:business_master_new
loadtime:0.57737493515015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:0.5774359703064 / seconds
Query Executed:select id FROM `mi` where city='Clifford' && SIC_code='5461'DB:business_master_new
loadtime:0.57819199562073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.5782527923584 / seconds
Query Executed:select id FROM `mi` where city='Climax' && SIC_code='5461'DB:business_master_new
loadtime:0.57965183258057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.57971286773682 / seconds
Query Executed:select id FROM `mi` where city='Clinton' && SIC_code='5461'DB:business_master_new
loadtime:0.58250379562378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Township' limit 1
loadtime:0.58256697654724 / seconds
Query Executed:select id FROM `mi` where city='Clinton Township' && SIC_code='5461'DB:business_master_new
loadtime:0.58995079994202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Twp' limit 1
loadtime:0.59004592895508 / seconds
Query Executed:select id FROM `mi` where city='Clinton Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.59123992919922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.59130477905273 / seconds
Query Executed:select id FROM `mi` where city='Clio' && SIC_code='5461'DB:business_master_new
loadtime:0.59962177276611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:0.59968590736389 / seconds
Query Executed:select id FROM `mi` where city='Cloverdale' && SIC_code='5461'DB:business_master_new
loadtime:0.60016298294067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:0.60022377967834 / seconds
Query Executed:select id FROM `mi` where city='Clyde' && SIC_code='5461'DB:business_master_new
loadtime:0.60066890716553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohoctah' limit 1
loadtime:0.60073089599609 / seconds
Query Executed:select id FROM `mi` where city='Cohoctah' && SIC_code='5461'DB:business_master_new
loadtime:0.60121893882751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.6012818813324 / seconds
Query Executed:select id FROM `mi` where city='Coldwater' && SIC_code='5461'DB:business_master_new
loadtime:0.6142258644104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman' limit 1
loadtime:0.61430692672729 / seconds
Query Executed:select id FROM `mi` where city='Coleman' && SIC_code='5461'DB:business_master_new
loadtime:0.616858959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coloma' limit 1
loadtime:0.61692190170288 / seconds
Query Executed:select id FROM `mi` where city='Coloma' && SIC_code='5461'DB:business_master_new
loadtime:0.62194895744324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colon' limit 1
loadtime:0.62202787399292 / seconds
Query Executed:select id FROM `mi` where city='Colon' && SIC_code='5461'DB:business_master_new
loadtime:0.62307786941528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbiaville' limit 1
loadtime:0.62313985824585 / seconds
Query Executed:select id FROM `mi` where city='Columbiaville' && SIC_code='5461'DB:business_master_new
loadtime:0.62532186508179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.6253969669342 / seconds
Query Executed:select id FROM `mi` where city='Columbus' && SIC_code='5461'DB:business_master_new
loadtime:0.62690877914429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comins' limit 1
loadtime:0.62696981430054 / seconds
Query Executed:select id FROM `mi` where city='Comins' && SIC_code='5461'DB:business_master_new
loadtime:0.62770986557007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Township' limit 1
loadtime:0.62778282165527 / seconds
Query Executed:select id FROM `mi` where city='Commerce Township' && SIC_code='5461'DB:business_master_new
loadtime:0.63529086112976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Twp' limit 1
loadtime:0.6353747844696 / seconds
Query Executed:select id FROM `mi` where city='Commerce Twp' && SIC_code='5461'DB:business_master_new
loadtime:0.63622999191284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock' limit 1
loadtime:0.63629388809204 / seconds
Query Executed:select id FROM `mi` where city='Comstock' && SIC_code='5461'DB:business_master_new
loadtime:0.63719582557678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock Park' limit 1
loadtime:0.63725781440735 / seconds
Query Executed:select id FROM `mi` where city='Comstock Park' && SIC_code='5461'DB:business_master_new
loadtime:0.64455580711365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.64464092254639 / seconds
Query Executed:select id FROM `mi` where city='Concord' && SIC_code='5461'DB:business_master_new
loadtime:0.64636898040771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conklin' limit 1
loadtime:0.64644694328308 / seconds
Query Executed:select id FROM `mi` where city='Conklin' && SIC_code='5461'DB:business_master_new
loadtime:0.64773988723755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Constantine' limit 1
loadtime:0.64781188964844 / seconds
Query Executed:select id FROM `mi` where city='Constantine' && SIC_code='5461'DB:business_master_new
loadtime:0.64914679527283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.64920783042908 / seconds
Query Executed:select id FROM `mi` where city='Conway' && SIC_code='5461'DB:business_master_new
loadtime:0.64994192123413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooks' limit 1
loadtime:0.65000486373901 / seconds
Query Executed:select id FROM `mi` where city='Cooks' && SIC_code='5461'DB:business_master_new
loadtime:0.65044784545898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coopersville' limit 1
loadtime:0.65050983428955 / seconds
Query Executed:select id FROM `mi` where city='Coopersville' && SIC_code='5461'DB:business_master_new
loadtime:0.65508484840393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copemish' limit 1
loadtime:0.65516185760498 / seconds
Query Executed:select id FROM `mi` where city='Copemish' && SIC_code='5461'DB:business_master_new
loadtime:0.65610098838806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper City' limit 1
loadtime:0.65616297721863 / seconds
Query Executed:select id FROM `mi` where city='Copper City' && SIC_code='5461'DB:business_master_new
loadtime:0.65658283233643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Harbor' limit 1
loadtime:0.65664982795715 / seconds
Query Executed:select id FROM `mi` where city='Copper Harbor' && SIC_code='5461'DB:business_master_new
loadtime:0.65738391876221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coral' limit 1
loadtime:0.65744495391846 / seconds
Query Executed:select id FROM `mi` where city='Coral' && SIC_code='5461'DB:business_master_new
loadtime:0.65818095207214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornell' limit 1
loadtime:0.65824198722839 / seconds
Query Executed:select id FROM `mi` where city='Cornell' && SIC_code='5461'DB:business_master_new
loadtime:0.65890383720398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corunna' limit 1
loadtime:0.65896391868591 / seconds
Query Executed:select id FROM `mi` where city='Corunna' && SIC_code='5461'DB:business_master_new
loadtime:0.66191387176514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottrellville' limit 1
loadtime:0.6619758605957 / seconds
Query Executed:select id FROM `mi` where city='Cottrellville' && SIC_code='5461'DB:business_master_new
loadtime:0.66238188743591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covert' limit 1
loadtime:0.66244387626648 / seconds
Query Executed:select id FROM `mi` where city='Covert' && SIC_code='5461'DB:business_master_new
loadtime:0.66353178024292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:0.66360998153687 / seconds
Query Executed:select id FROM `mi` where city='Covington' && SIC_code='5461'DB:business_master_new
loadtime:0.66422581672668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Village' limit 1
loadtime:0.66428899765015 / seconds
Query Executed:select id FROM `mi` where city='Cross Village' && SIC_code='5461'DB:business_master_new
loadtime:0.66480493545532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croswell' limit 1
loadtime:0.66486597061157 / seconds
Query Executed:select id FROM `mi` where city='Croswell' && SIC_code='5461'DB:business_master_new
loadtime:0.66804194450378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal' limit 1
loadtime:0.66811680793762 / seconds
Query Executed:select id FROM `mi` where city='Crystal' && SIC_code='5461'DB:business_master_new
loadtime:0.66958999633789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Falls' limit 1
loadtime:0.66965794563293 / seconds
Query Executed:select id FROM `mi` where city='Crystal Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.67248582839966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curran' limit 1
loadtime:0.67256188392639 / seconds
Query Executed:select id FROM `mi` where city='Curran' && SIC_code='5461'DB:business_master_new
loadtime:0.67309498786926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtis' limit 1
loadtime:0.67315697669983 / seconds
Query Executed:select id FROM `mi` where city='Curtis' && SIC_code='5461'DB:business_master_new
loadtime:0.67434978485107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.67441082000732 / seconds
Query Executed:select id FROM `mi` where city='Custer' && SIC_code='5461'DB:business_master_new
loadtime:0.67549395561218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dafter' limit 1
loadtime:0.67555499076843 / seconds
Query Executed:select id FROM `mi` where city='Dafter' && SIC_code='5461'DB:business_master_new
loadtime:0.67634391784668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daggett' limit 1
loadtime:0.67640495300293 / seconds
Query Executed:select id FROM `mi` where city='Daggett' && SIC_code='5461'DB:business_master_new
loadtime:0.67719388008118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dansville' limit 1
loadtime:0.67725491523743 / seconds
Query Executed:select id FROM `mi` where city='Dansville' && SIC_code='5461'DB:business_master_new
loadtime:0.6786937713623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davisburg' limit 1
loadtime:0.67875695228577 / seconds
Query Executed:select id FROM `mi` where city='Davisburg' && SIC_code='5461'DB:business_master_new
loadtime:0.68183493614197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davison' limit 1
loadtime:0.68189597129822 / seconds
Query Executed:select id FROM `mi` where city='Davison' && SIC_code='5461'DB:business_master_new
loadtime:0.69302487373352 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Tour Village' limit 1
loadtime:0.69310879707336 / seconds
Query Executed:select id FROM `mi` where city='De Tour Village' && SIC_code='5461'DB:business_master_new
loadtime:0.69424200057983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn' limit 1
loadtime:0.6943039894104 / seconds
Query Executed:select id FROM `mi` where city='Dearborn' && SIC_code='5461'DB:business_master_new
loadtime:0.70191597938538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn Heights' limit 1
loadtime:0.70197892189026 / seconds
Query Executed:select id FROM `mi` where city='Dearborn Heights' && SIC_code='5461'DB:business_master_new
loadtime:0.70927381515503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.70933699607849 / seconds
Query Executed:select id FROM `mi` where city='Decatur' && SIC_code='5461'DB:business_master_new
loadtime:0.71188998222351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decker' limit 1
loadtime:0.71195197105408 / seconds
Query Executed:select id FROM `mi` where city='Decker' && SIC_code='5461'DB:business_master_new
loadtime:0.71257781982422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deckerville' limit 1
loadtime:0.71264481544495 / seconds
Query Executed:select id FROM `mi` where city='Deckerville' && SIC_code='5461'DB:business_master_new
loadtime:0.71477890014648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.71484088897705 / seconds
Query Executed:select id FROM `mi` where city='Deerfield' && SIC_code='5461'DB:business_master_new
loadtime:0.71599984169006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerton' limit 1
loadtime:0.71606183052063 / seconds
Query Executed:select id FROM `mi` where city='Deerton' && SIC_code='5461'DB:business_master_new
loadtime:0.71664094924927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deford' limit 1
loadtime:0.71670198440552 / seconds
Query Executed:select id FROM `mi` where city='Deford' && SIC_code='5461'DB:business_master_new
loadtime:0.71750688552856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delton' limit 1
loadtime:0.71756887435913 / seconds
Query Executed:select id FROM `mi` where city='Delton' && SIC_code='5461'DB:business_master_new
loadtime:0.72105097770691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Detroit' limit 1
loadtime:0.72111487388611 / seconds
Query Executed:select id FROM `mi` where city='Detroit' && SIC_code='5461'DB:business_master_new
loadtime:0.72847986221313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:0.72856187820435 / seconds
Query Executed:select id FROM `mi` where city='Dewitt' && SIC_code='5461'DB:business_master_new
loadtime:0.73523283004761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.73530983924866 / seconds
Query Executed:select id FROM `mi` where city='Dexter' && SIC_code='5461'DB:business_master_new
loadtime:0.73855781555176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimondale' limit 1
loadtime:0.7386269569397 / seconds
Query Executed:select id FROM `mi` where city='Dimondale' && SIC_code='5461'DB:business_master_new
loadtime:0.74112486839294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodgeville' limit 1
loadtime:0.74119997024536 / seconds
Query Executed:select id FROM `mi` where city='Dodgeville' && SIC_code='5461'DB:business_master_new
loadtime:0.74169278144836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dollar Bay' limit 1
loadtime:0.74175477027893 / seconds
Query Executed:select id FROM `mi` where city='Dollar Bay' && SIC_code='5461'DB:business_master_new
loadtime:0.7425549030304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorr' limit 1
loadtime:0.74262285232544 / seconds
Query Executed:select id FROM `mi` where city='Dorr' && SIC_code='5461'DB:business_master_new
loadtime:0.74556994438171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.74563479423523 / seconds
Query Executed:select id FROM `mi` where city='Douglas' && SIC_code='5461'DB:business_master_new
loadtime:0.74759387969971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowagiac' limit 1
loadtime:0.74765992164612 / seconds
Query Executed:select id FROM `mi` where city='Dowagiac' && SIC_code='5461'DB:business_master_new
loadtime:0.75525879859924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowling' limit 1
loadtime:0.75534081459045 / seconds
Query Executed:select id FROM `mi` where city='Dowling' && SIC_code='5461'DB:business_master_new
loadtime:0.75624990463257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton Plains' limit 1
loadtime:0.75631380081177 / seconds
Query Executed:select id FROM `mi` where city='Drayton Plains' && SIC_code='5461'DB:business_master_new
loadtime:0.75719499588013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drummond Island' limit 1
loadtime:0.75725698471069 / seconds
Query Executed:select id FROM `mi` where city='Drummond Island' && SIC_code='5461'DB:business_master_new
loadtime:0.75878882408142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:0.75886392593384 / seconds
Query Executed:select id FROM `mi` where city='Dryden' && SIC_code='5461'DB:business_master_new
loadtime:0.76118087768555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.76124382019043 / seconds
Query Executed:select id FROM `mi` where city='Dundee' && SIC_code='5461'DB:business_master_new
loadtime:0.76445889472961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durand' limit 1
loadtime:0.76451992988586 / seconds
Query Executed:select id FROM `mi` where city='Durand' && SIC_code='5461'DB:business_master_new
loadtime:0.76876282691956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:0.76885199546814 / seconds
Query Executed:select id FROM `mi` where city='Dutton' && SIC_code='5461'DB:business_master_new
loadtime:0.76933693885803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:0.7693989276886 / seconds
Query Executed:select id FROM `mi` where city='Eagle' && SIC_code='5461'DB:business_master_new
loadtime:0.77069783210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Harbor' limit 1
loadtime:0.77076077461243 / seconds
Query Executed:select id FROM `mi` where city='Eagle Harbor' && SIC_code='5461'DB:business_master_new
loadtime:0.77124977111816 / seconds
Query loaded from cache:select * from geodata_geocity where city='East China' limit 1
loadtime:0.77131199836731 / seconds
Query Executed:select id FROM `mi` where city='East China' && SIC_code='5461'DB:business_master_new
loadtime:0.77433180809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Jordan' limit 1
loadtime:0.77439284324646 / seconds
Query Executed:select id FROM `mi` where city='East Jordan' && SIC_code='5461'DB:business_master_new
loadtime:0.77791690826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lansing' limit 1
loadtime:0.77797889709473 / seconds
Query Executed:select id FROM `mi` where city='East Lansing' && SIC_code='5461'DB:business_master_new
loadtime:0.78553581237793 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Leroy' limit 1
loadtime:0.78562378883362 / seconds
Query Executed:select id FROM `mi` where city='East Leroy' && SIC_code='5461'DB:business_master_new
loadtime:0.78656888008118 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Tawas' limit 1
loadtime:0.78663492202759 / seconds
Query Executed:select id FROM `mi` where city='East Tawas' && SIC_code='5461'DB:business_master_new
loadtime:0.79095482826233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastlake' limit 1
loadtime:0.79101777076721 / seconds
Query Executed:select id FROM `mi` where city='Eastlake' && SIC_code='5461'DB:business_master_new
loadtime:0.79147696495056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastpointe' limit 1
loadtime:0.79153895378113 / seconds
Query Executed:select id FROM `mi` where city='Eastpointe' && SIC_code='5461'DB:business_master_new
loadtime:0.79891777038574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastport' limit 1
loadtime:0.79900479316711 / seconds
Query Executed:select id FROM `mi` where city='Eastport' && SIC_code='5461'DB:business_master_new
loadtime:0.79968285560608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Rapids' limit 1
loadtime:0.79974699020386 / seconds
Query Executed:select id FROM `mi` where city='Eaton Rapids' && SIC_code='5461'DB:business_master_new
loadtime:0.80586886405945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Claire' limit 1
loadtime:0.8059458732605 / seconds
Query Executed:select id FROM `mi` where city='Eau Claire' && SIC_code='5461'DB:business_master_new
loadtime:0.80809283256531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eben Junction' limit 1
loadtime:0.80815696716309 / seconds
Query Executed:select id FROM `mi` where city='Eben Junction' && SIC_code='5461'DB:business_master_new
loadtime:0.80878281593323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckerman' limit 1
loadtime:0.80884480476379 / seconds
Query Executed:select id FROM `mi` where city='Eckerman' && SIC_code='5461'DB:business_master_new
loadtime:0.8095338344574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecorse' limit 1
loadtime:0.80959582328796 / seconds
Query Executed:select id FROM `mi` where city='Ecorse' && SIC_code='5461'DB:business_master_new
loadtime:0.8109769821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenville' limit 1
loadtime:0.81103777885437 / seconds
Query Executed:select id FROM `mi` where city='Edenville' && SIC_code='5461'DB:business_master_new
loadtime:0.81161594390869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmore' limit 1
loadtime:0.81167793273926 / seconds
Query Executed:select id FROM `mi` where city='Edmore' && SIC_code='5461'DB:business_master_new
loadtime:0.81407499313354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsburg' limit 1
loadtime:0.81414079666138 / seconds
Query Executed:select id FROM `mi` where city='Edwardsburg' && SIC_code='5461'DB:business_master_new
loadtime:0.81774187088013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:0.81783199310303 / seconds
Query Executed:select id FROM `mi` where city='Elberta' && SIC_code='5461'DB:business_master_new
loadtime:0.81846690177917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Rapids' limit 1
loadtime:0.81853079795837 / seconds
Query Executed:select id FROM `mi` where city='Elk Rapids' && SIC_code='5461'DB:business_master_new
loadtime:0.82166481018066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.82173991203308 / seconds
Query Executed:select id FROM `mi` where city='Elkton' && SIC_code='5461'DB:business_master_new
loadtime:0.82310581207275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.82316780090332 / seconds
Query Executed:select id FROM `mi` where city='Ellsworth' && SIC_code='5461'DB:business_master_new
loadtime:0.82441878318787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Hall' limit 1
loadtime:0.82448077201843 / seconds
Query Executed:select id FROM `mi` where city='Elm Hall' && SIC_code='5461'DB:business_master_new
loadtime:0.82491278648376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmira' limit 1
loadtime:0.82497477531433 / seconds
Query Executed:select id FROM `mi` where city='Elmira' && SIC_code='5461'DB:business_master_new
loadtime:0.82574200630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsie' limit 1
loadtime:0.82581186294556 / seconds
Query Executed:select id FROM `mi` where city='Elsie' && SIC_code='5461'DB:business_master_new
loadtime:0.82760787010193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwell' limit 1
loadtime:0.82768297195435 / seconds
Query Executed:select id FROM `mi` where city='Elwell' && SIC_code='5461'DB:business_master_new
loadtime:0.82850980758667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmett' limit 1
loadtime:0.82857084274292 / seconds
Query Executed:select id FROM `mi` where city='Emmett' && SIC_code='5461'DB:business_master_new
loadtime:0.82995295524597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:0.83001494407654 / seconds
Query Executed:select id FROM `mi` where city='Empire' && SIC_code='5461'DB:business_master_new
loadtime:0.83158898353577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engadine' limit 1
loadtime:0.83166980743408 / seconds
Query Executed:select id FROM `mi` where city='Engadine' && SIC_code='5461'DB:business_master_new
loadtime:0.83253383636475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:0.832594871521 / seconds
Query Executed:select id FROM `mi` where city='Erie' && SIC_code='5461'DB:business_master_new
loadtime:0.83493494987488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escanaba' limit 1
loadtime:0.83499598503113 / seconds
Query Executed:select id FROM `mi` where city='Escanaba' && SIC_code='5461'DB:business_master_new
loadtime:0.84691786766052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essexville' limit 1
loadtime:0.84700489044189 / seconds
Query Executed:select id FROM `mi` where city='Essexville' && SIC_code='5461'DB:business_master_new
loadtime:0.85101389884949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.85109400749207 / seconds
Query Executed:select id FROM `mi` where city='Eureka' && SIC_code='5461'DB:business_master_new
loadtime:0.85159397125244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evart' limit 1
loadtime:0.85166096687317 / seconds
Query Executed:select id FROM `mi` where city='Evart' && SIC_code='5461'DB:business_master_new
loadtime:0.85482788085938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewen' limit 1
loadtime:0.85490489006042 / seconds
Query Executed:select id FROM `mi` where city='Ewen' && SIC_code='5461'DB:business_master_new
loadtime:0.8554368019104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:0.85549879074097 / seconds
Query Executed:select id FROM `mi` where city='Fair Haven' && SIC_code='5461'DB:business_master_new
loadtime:0.85804295539856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairgrove' limit 1
loadtime:0.85811877250671 / seconds
Query Executed:select id FROM `mi` where city='Fairgrove' && SIC_code='5461'DB:business_master_new
loadtime:0.85925388336182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.85931491851807 / seconds
Query Executed:select id FROM `mi` where city='Fairview' && SIC_code='5461'DB:business_master_new
loadtime:0.86059498786926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.86065983772278 / seconds
Query Executed:select id FROM `mi` where city='Falmouth' && SIC_code='5461'DB:business_master_new
loadtime:0.86150193214417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fargo' limit 1
loadtime:0.86156487464905 / seconds
Query Executed:select id FROM `mi` where city='Fargo' && SIC_code='5461'DB:business_master_new
loadtime:0.8619818687439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.86204195022583 / seconds
Query Executed:select id FROM `mi` where city='Farmington' && SIC_code='5461'DB:business_master_new
loadtime:0.86978697776794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington Hills' limit 1
loadtime:0.86988282203674 / seconds
Query Executed:select id FROM `mi` where city='Farmington Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.87160491943359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farwell' limit 1
loadtime:0.87167286872864 / seconds
Query Executed:select id FROM `mi` where city='Farwell' && SIC_code='5461'DB:business_master_new
loadtime:0.87414979934692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Felch' limit 1
loadtime:0.87421083450317 / seconds
Query Executed:select id FROM `mi` where city='Felch' && SIC_code='5461'DB:business_master_new
loadtime:0.87493300437927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fennville' limit 1
loadtime:0.87499380111694 / seconds
Query Executed:select id FROM `mi` where city='Fennville' && SIC_code='5461'DB:business_master_new
loadtime:0.87853384017944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:0.87859487533569 / seconds
Query Executed:select id FROM `mi` where city='Fenton' && SIC_code='5461'DB:business_master_new
loadtime:0.88595986366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwick' limit 1
loadtime:0.8860399723053 / seconds
Query Executed:select id FROM `mi` where city='Fenwick' && SIC_code='5461'DB:business_master_new
loadtime:0.88703989982605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferndale' limit 1
loadtime:0.88710284233093 / seconds
Query Executed:select id FROM `mi` where city='Ferndale' && SIC_code='5461'DB:business_master_new
loadtime:0.89445686340332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrysburg' limit 1
loadtime:0.89454293251038 / seconds
Query Executed:select id FROM `mi` where city='Ferrysburg' && SIC_code='5461'DB:business_master_new
loadtime:0.89539480209351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife Lake' limit 1
loadtime:0.89545798301697 / seconds
Query Executed:select id FROM `mi` where city='Fife Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.8970057964325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filer City' limit 1
loadtime:0.89706778526306 / seconds
Query Executed:select id FROM `mi` where city='Filer City' && SIC_code='5461'DB:business_master_new
loadtime:0.89752888679504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filion' limit 1
loadtime:0.89758992195129 / seconds
Query Executed:select id FROM `mi` where city='Filion' && SIC_code='5461'DB:business_master_new
loadtime:0.89828777313232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:0.89835000038147 / seconds
Query Executed:select id FROM `mi` where city='Flat Rock' && SIC_code='5461'DB:business_master_new
loadtime:0.90097880363464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint' limit 1
loadtime:0.90104079246521 / seconds
Query Executed:select id FROM `mi` where city='Flint' && SIC_code='5461'DB:business_master_new
loadtime:0.90839290618896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flushing' limit 1
loadtime:0.90849781036377 / seconds
Query Executed:select id FROM `mi` where city='Flushing' && SIC_code='5461'DB:business_master_new
loadtime:0.91839385032654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestville' limit 1
loadtime:0.91848182678223 / seconds
Query Executed:select id FROM `mi` where city='Forestville' && SIC_code='5461'DB:business_master_new
loadtime:0.91897988319397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Gratiot' limit 1
loadtime:0.91904187202454 / seconds
Query Executed:select id FROM `mi` where city='Fort Gratiot' && SIC_code='5461'DB:business_master_new
loadtime:0.926677942276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster City' limit 1
loadtime:0.9267578125 / seconds
Query Executed:select id FROM `mi` where city='Foster City' && SIC_code='5461'DB:business_master_new
loadtime:0.92724180221558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:0.92730379104614 / seconds
Query Executed:select id FROM `mi` where city='Fostoria' && SIC_code='5461'DB:business_master_new
loadtime:0.92817378044128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:0.92823600769043 / seconds
Query Executed:select id FROM `mi` where city='Fountain' && SIC_code='5461'DB:business_master_new
loadtime:0.92915391921997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:0.92921495437622 / seconds
Query Executed:select id FROM `mi` where city='Fowler' && SIC_code='5461'DB:business_master_new
loadtime:0.93086099624634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowlerville' limit 1
loadtime:0.9309229850769 / seconds
Query Executed:select id FROM `mi` where city='Fowlerville' && SIC_code='5461'DB:business_master_new
loadtime:0.93722581863403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankenmuth' limit 1
loadtime:0.9372889995575 / seconds
Query Executed:select id FROM `mi` where city='Frankenmuth' && SIC_code='5461'DB:business_master_new
loadtime:0.94281578063965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.94289493560791 / seconds
Query Executed:select id FROM `mi` where city='Frankfort' && SIC_code='5461'DB:business_master_new
loadtime:0.94586277008057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.94593977928162 / seconds
Query Executed:select id FROM `mi` where city='Franklin' && SIC_code='5461'DB:business_master_new
loadtime:0.95354294776917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraser' limit 1
loadtime:0.95361280441284 / seconds
Query Executed:select id FROM `mi` where city='Fraser' && SIC_code='5461'DB:business_master_new
loadtime:0.96205377578735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederic' limit 1
loadtime:0.9621160030365 / seconds
Query Executed:select id FROM `mi` where city='Frederic' && SIC_code='5461'DB:business_master_new
loadtime:0.96304392814636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Soil' limit 1
loadtime:0.96310591697693 / seconds
Query Executed:select id FROM `mi` where city='Free Soil' && SIC_code='5461'DB:business_master_new
loadtime:0.96406292915344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeland' limit 1
loadtime:0.96412396430969 / seconds
Query Executed:select id FROM `mi` where city='Freeland' && SIC_code='5461'DB:business_master_new
loadtime:0.96959686279297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeport' limit 1
loadtime:0.9696638584137 / seconds
Query Executed:select id FROM `mi` where city='Freeport' && SIC_code='5461'DB:business_master_new
loadtime:0.97069883346558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.97075986862183 / seconds
Query Executed:select id FROM `mi` where city='Fremont' && SIC_code='5461'DB:business_master_new
loadtime:0.97806191444397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frontier' limit 1
loadtime:0.97814083099365 / seconds
Query Executed:select id FROM `mi` where city='Frontier' && SIC_code='5461'DB:business_master_new
loadtime:0.97862887382507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitport' limit 1
loadtime:0.97869181632996 / seconds
Query Executed:select id FROM `mi` where city='Fruitport' && SIC_code='5461'DB:business_master_new
loadtime:0.98181796073914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.98187899589539 / seconds
Query Executed:select id FROM `mi` where city='Fulton' && SIC_code='5461'DB:business_master_new
loadtime:0.98266291618347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaastra' limit 1
loadtime:0.98272490501404 / seconds
Query Executed:select id FROM `mi` where city='Gaastra' && SIC_code='5461'DB:business_master_new
loadtime:0.98328495025635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gagetown' limit 1
loadtime:0.98334693908691 / seconds
Query Executed:select id FROM `mi` where city='Gagetown' && SIC_code='5461'DB:business_master_new
loadtime:0.98426485061646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaines' limit 1
loadtime:0.98432683944702 / seconds
Query Executed:select id FROM `mi` where city='Gaines' && SIC_code='5461'DB:business_master_new
loadtime:0.98552799224854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesburg' limit 1
loadtime:0.98558878898621 / seconds
Query Executed:select id FROM `mi` where city='Galesburg' && SIC_code='5461'DB:business_master_new
loadtime:0.98830580711365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galien' limit 1
loadtime:0.98836779594421 / seconds
Query Executed:select id FROM `mi` where city='Galien' && SIC_code='5461'DB:business_master_new
loadtime:0.98951482772827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden' limit 1
loadtime:0.98957681655884 / seconds
Query Executed:select id FROM `mi` where city='Garden' && SIC_code='5461'DB:business_master_new
loadtime:0.99044990539551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.99051189422607 / seconds
Query Executed:select id FROM `mi` where city='Garden City' && SIC_code='5461'DB:business_master_new
loadtime:0.99533200263977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylord' limit 1
loadtime:0.99539494514465 / seconds
Query Executed:select id FROM `mi` where city='Gaylord' && SIC_code='5461'DB:business_master_new
loadtime:1.0014469623566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genesee' limit 1
loadtime:1.0015099048615 / seconds
Query Executed:select id FROM `mi` where city='Genesee' && SIC_code='5461'DB:business_master_new
loadtime:1.0025019645691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germfask' limit 1
loadtime:1.0025789737701 / seconds
Query Executed:select id FROM `mi` where city='Germfask' && SIC_code='5461'DB:business_master_new
loadtime:1.00315284729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:1.0032148361206 / seconds
Query Executed:select id FROM `mi` where city='Gilford' && SIC_code='5461'DB:business_master_new
loadtime:1.0036659240723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.0037279129028 / seconds
Query Executed:select id FROM `mi` where city='Gladstone' && SIC_code='5461'DB:business_master_new
loadtime:1.0081758499146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladwin' limit 1
loadtime:1.0082559585571 / seconds
Query Executed:select id FROM `mi` where city='Gladwin' && SIC_code='5461'DB:business_master_new
loadtime:1.0156908035278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Arbor' limit 1
loadtime:1.0157558917999 / seconds
Query Executed:select id FROM `mi` where city='Glen Arbor' && SIC_code='5461'DB:business_master_new
loadtime:1.0175628662109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn' limit 1
loadtime:1.0176429748535 / seconds
Query Executed:select id FROM `mi` where city='Glenn' && SIC_code='5461'DB:business_master_new
loadtime:1.0181419849396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glennie' limit 1
loadtime:1.0182039737701 / seconds
Query Executed:select id FROM `mi` where city='Glennie' && SIC_code='5461'DB:business_master_new
loadtime:1.0193319320679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gobles' limit 1
loadtime:1.0193939208984 / seconds
Query Executed:select id FROM `mi` where city='Gobles' && SIC_code='5461'DB:business_master_new
loadtime:1.0217528343201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goetzville' limit 1
loadtime:1.0218238830566 / seconds
Query Executed:select id FROM `mi` where city='Goetzville' && SIC_code='5461'DB:business_master_new
loadtime:1.0225009918213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Good Hart' limit 1
loadtime:1.022561788559 / seconds
Query Executed:select id FROM `mi` where city='Good Hart' && SIC_code='5461'DB:business_master_new
loadtime:1.0230000019073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodells' limit 1
loadtime:1.0230629444122 / seconds
Query Executed:select id FROM `mi` where city='Goodells' && SIC_code='5461'DB:business_master_new
loadtime:1.0243439674377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodrich' limit 1
loadtime:1.0244069099426 / seconds
Query Executed:select id FROM `mi` where city='Goodrich' && SIC_code='5461'DB:business_master_new
loadtime:1.0270819664001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gould City' limit 1
loadtime:1.0271589756012 / seconds
Query Executed:select id FROM `mi` where city='Gould City' && SIC_code='5461'DB:business_master_new
loadtime:1.0278098583221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowen' limit 1
loadtime:1.0278718471527 / seconds
Query Executed:select id FROM `mi` where city='Gowen' && SIC_code='5461'DB:business_master_new
loadtime:1.0290939807892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Beach' limit 1
loadtime:1.0291569232941 / seconds
Query Executed:select id FROM `mi` where city='Grand Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.0295789241791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Blanc' limit 1
loadtime:1.0296459197998 / seconds
Query Executed:select id FROM `mi` where city='Grand Blanc' && SIC_code='5461'DB:business_master_new
loadtime:1.0373067855835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Haven' limit 1
loadtime:1.0373909473419 / seconds
Query Executed:select id FROM `mi` where city='Grand Haven' && SIC_code='5461'DB:business_master_new
loadtime:1.0447499752045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:1.0448389053345 / seconds
Query Executed:select id FROM `mi` where city='Grand Junction' && SIC_code='5461'DB:business_master_new
loadtime:1.0460848808289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Ledge' limit 1
loadtime:1.0461478233337 / seconds
Query Executed:select id FROM `mi` where city='Grand Ledge' && SIC_code='5461'DB:business_master_new
loadtime:1.0545909404755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Marais' limit 1
loadtime:1.0546720027924 / seconds
Query Executed:select id FROM `mi` where city='Grand Marais' && SIC_code='5461'DB:business_master_new
loadtime:1.0556218624115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Rapids' limit 1
loadtime:1.0556848049164 / seconds
Query Executed:select id FROM `mi` where city='Grand Rapids' && SIC_code='5461'DB:business_master_new
loadtime:1.0631079673767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandville' limit 1
loadtime:1.0632197856903 / seconds
Query Executed:select id FROM `mi` where city='Grandville' && SIC_code='5461'DB:business_master_new
loadtime:1.07821393013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:1.0783009529114 / seconds
Query Executed:select id FROM `mi` where city='Grant' && SIC_code='5461'DB:business_master_new
loadtime:1.0811769962311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant Twp' limit 1
loadtime:1.081239938736 / seconds
Query Executed:select id FROM `mi` where city='Grant Twp' && SIC_code='5461'DB:business_master_new
loadtime:1.0817079544067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grass Lake' limit 1
loadtime:1.0817809104919 / seconds
Query Executed:select id FROM `mi` where city='Grass Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.085147857666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grawn' limit 1
loadtime:1.0852108001709 / seconds
Query Executed:select id FROM `mi` where city='Grawn' && SIC_code='5461'DB:business_master_new
loadtime:1.0869338512421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grayling' limit 1
loadtime:1.0869967937469 / seconds
Query Executed:select id FROM `mi` where city='Grayling' && SIC_code='5461'DB:business_master_new
loadtime:1.0937829017639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.0938589572906 / seconds
Query Executed:select id FROM `mi` where city='Greenbush' && SIC_code='5461'DB:business_master_new
loadtime:1.0947959423065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:1.0948579311371 / seconds
Query Executed:select id FROM `mi` where city='Greenland' && SIC_code='5461'DB:business_master_new
loadtime:1.095333814621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.0953948497772 / seconds
Query Executed:select id FROM `mi` where city='Greenville' && SIC_code='5461'DB:business_master_new
loadtime:1.1045367717743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.1046249866486 / seconds
Query Executed:select id FROM `mi` where city='Greenwood' && SIC_code='5461'DB:business_master_new
loadtime:1.1050729751587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:1.1051349639893 / seconds
Query Executed:select id FROM `mi` where city='Gregory' && SIC_code='5461'DB:business_master_new
loadtime:1.1070289611816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Ile' limit 1
loadtime:1.1070909500122 / seconds
Query Executed:select id FROM `mi` where city='Grosse Ile' && SIC_code='5461'DB:business_master_new
loadtime:1.1092658042908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pointe' limit 1
loadtime:1.1093289852142 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pointe' && SIC_code='5461'DB:business_master_new
loadtime:1.1208238601685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Farms' limit 1
loadtime:1.1208848953247 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Farms' && SIC_code='5461'DB:business_master_new
loadtime:1.1214318275452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Park' limit 1
loadtime:1.1214849948883 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Park' && SIC_code='5461'DB:business_master_new
loadtime:1.1219840049744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Woods' limit 1
loadtime:1.1220378875732 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Woods' && SIC_code='5461'DB:business_master_new
loadtime:1.1225199699402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulliver' limit 1
loadtime:1.1225728988647 / seconds
Query Executed:select id FROM `mi` where city='Gulliver' && SIC_code='5461'DB:business_master_new
loadtime:1.12313580513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwinn' limit 1
loadtime:1.1231908798218 / seconds
Query Executed:select id FROM `mi` where city='Gwinn' && SIC_code='5461'DB:business_master_new
loadtime:1.1265828609467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:1.1266419887543 / seconds
Query Executed:select id FROM `mi` where city='Hadley' && SIC_code='5461'DB:business_master_new
loadtime:1.1273748874664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagar Shores' limit 1
loadtime:1.1274268627167 / seconds
Query Executed:select id FROM `mi` where city='Hagar Shores' && SIC_code='5461'DB:business_master_new
loadtime:1.1278109550476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hale' limit 1
loadtime:1.1278638839722 / seconds
Query Executed:select id FROM `mi` where city='Hale' && SIC_code='5461'DB:business_master_new
loadtime:1.1302139759064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:1.1302678585052 / seconds
Query Executed:select id FROM `mi` where city='Hamburg' && SIC_code='5461'DB:business_master_new
loadtime:1.1315588951111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.1316168308258 / seconds
Query Executed:select id FROM `mi` where city='Hamilton' && SIC_code='5461'DB:business_master_new
loadtime:1.134624004364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamtramck' limit 1
loadtime:1.1346778869629 / seconds
Query Executed:select id FROM `mi` where city='Hamtramck' && SIC_code='5461'DB:business_master_new
loadtime:1.1382420063019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.1382949352264 / seconds
Query Executed:select id FROM `mi` where city='Hancock' && SIC_code='5461'DB:business_master_new
loadtime:1.1425638198853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.1426358222961 / seconds
Query Executed:select id FROM `mi` where city='Hanover' && SIC_code='5461'DB:business_master_new
loadtime:1.1439487934113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbert' limit 1
loadtime:1.144003868103 / seconds
Query Executed:select id FROM `mi` where city='Harbert' && SIC_code='5461'DB:business_master_new
loadtime:1.1445508003235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Beach' limit 1
loadtime:1.1446049213409 / seconds
Query Executed:select id FROM `mi` where city='Harbor Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.1474637985229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Springs' limit 1
loadtime:1.1475188732147 / seconds
Query Executed:select id FROM `mi` where city='Harbor Springs' && SIC_code='5461'DB:business_master_new
loadtime:1.154727935791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper Woods' limit 1
loadtime:1.154807806015 / seconds
Query Executed:select id FROM `mi` where city='Harper Woods' && SIC_code='5461'DB:business_master_new
loadtime:1.1574199199677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrietta' limit 1
loadtime:1.1574759483337 / seconds
Query Executed:select id FROM `mi` where city='Harrietta' && SIC_code='5461'DB:business_master_new
loadtime:1.1580967903137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:1.1581499576569 / seconds
Query Executed:select id FROM `mi` where city='Harris' && SIC_code='5461'DB:business_master_new
loadtime:1.158618927002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:1.1586699485779 / seconds
Query Executed:select id FROM `mi` where city='Harrison' && SIC_code='5461'DB:business_master_new
loadtime:1.1644577980042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Township' limit 1
loadtime:1.1645119190216 / seconds
Query Executed:select id FROM `mi` where city='Harrison Township' && SIC_code='5461'DB:business_master_new
loadtime:1.1732478141785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Twp' limit 1
loadtime:1.1733160018921 / seconds
Query Executed:select id FROM `mi` where city='Harrison Twp' && SIC_code='5461'DB:business_master_new
loadtime:1.1739089488983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:1.1739637851715 / seconds
Query Executed:select id FROM `mi` where city='Harrisville' && SIC_code='5461'DB:business_master_new
loadtime:1.1763098239899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harsens Island' limit 1
loadtime:1.1763768196106 / seconds
Query Executed:select id FROM `mi` where city='Harsens Island' && SIC_code='5461'DB:business_master_new
loadtime:1.1773679256439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hart' limit 1
loadtime:1.1774218082428 / seconds
Query Executed:select id FROM `mi` where city='Hart' && SIC_code='5461'DB:business_master_new
loadtime:1.1819379329681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.1819908618927 / seconds
Query Executed:select id FROM `mi` where city='Hartford' && SIC_code='5461'DB:business_master_new
loadtime:1.1846239566803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:1.1846899986267 / seconds
Query Executed:select id FROM `mi` where city='Hartland' && SIC_code='5461'DB:business_master_new
loadtime:1.1888999938965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:1.1889688968658 / seconds
Query Executed:select id FROM `mi` where city='Harvey' && SIC_code='5461'DB:business_master_new
loadtime:1.1893579959869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haslett' limit 1
loadtime:1.1894109249115 / seconds
Query Executed:select id FROM `mi` where city='Haslett' && SIC_code='5461'DB:business_master_new
loadtime:1.1950869560242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:1.1951398849487 / seconds
Query Executed:select id FROM `mi` where city='Hastings' && SIC_code='5461'DB:business_master_new
loadtime:1.2040848731995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawks' limit 1
loadtime:1.2041518688202 / seconds
Query Executed:select id FROM `mi` where city='Hawks' && SIC_code='5461'DB:business_master_new
loadtime:1.2047410011292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Park' limit 1
loadtime:1.2048048973083 / seconds
Query Executed:select id FROM `mi` where city='Hazel Park' && SIC_code='5461'DB:business_master_new
loadtime:1.2118988037109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemlock' limit 1
loadtime:1.2119648456573 / seconds
Query Executed:select id FROM `mi` where city='Hemlock' && SIC_code='5461'DB:business_master_new
loadtime:1.2146298885345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:1.2146828174591 / seconds
Query Executed:select id FROM `mi` where city='Henderson' && SIC_code='5461'DB:business_master_new
loadtime:1.2153677940369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermansville' limit 1
loadtime:1.21542096138 / seconds
Query Executed:select id FROM `mi` where city='Hermansville' && SIC_code='5461'DB:business_master_new
loadtime:1.2160789966583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herron' limit 1
loadtime:1.2161319255829 / seconds
Query Executed:select id FROM `mi` where city='Herron' && SIC_code='5461'DB:business_master_new
loadtime:1.2168579101562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hersey' limit 1
loadtime:1.2169117927551 / seconds
Query Executed:select id FROM `mi` where city='Hersey' && SIC_code='5461'DB:business_master_new
loadtime:1.2178618907928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesperia' limit 1
loadtime:1.2179148197174 / seconds
Query Executed:select id FROM `mi` where city='Hesperia' && SIC_code='5461'DB:business_master_new
loadtime:1.2198209762573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hessel' limit 1
loadtime:1.2198739051819 / seconds
Query Executed:select id FROM `mi` where city='Hessel' && SIC_code='5461'DB:business_master_new
loadtime:1.220752954483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Corners' limit 1
loadtime:1.2208287715912 / seconds
Query Executed:select id FROM `mi` where city='Hickory Corners' && SIC_code='5461'DB:business_master_new
loadtime:1.2219078540802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higgins Lake' limit 1
loadtime:1.2219619750977 / seconds
Query Executed:select id FROM `mi` where city='Higgins Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.2224559783936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:1.2225079536438 / seconds
Query Executed:select id FROM `mi` where city='Highland' && SIC_code='5461'DB:business_master_new
loadtime:1.2310090065002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Park' limit 1
loadtime:1.2310779094696 / seconds
Query Executed:select id FROM `mi` where city='Highland Park' && SIC_code='5461'DB:business_master_new
loadtime:1.2352237701416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillman' limit 1
loadtime:1.2352788448334 / seconds
Query Executed:select id FROM `mi` where city='Hillman' && SIC_code='5461'DB:business_master_new
loadtime:1.2364249229431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:1.2364778518677 / seconds
Query Executed:select id FROM `mi` where city='Hillsdale' && SIC_code='5461'DB:business_master_new
loadtime:1.2450699806213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.2451229095459 / seconds
Query Executed:select id FROM `mi` where city='Holland' && SIC_code='5461'DB:business_master_new
loadtime:1.2528049945831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly' limit 1
loadtime:1.2528867721558 / seconds
Query Executed:select id FROM `mi` where city='Holly' && SIC_code='5461'DB:business_master_new
loadtime:1.2613849639893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holt' limit 1
loadtime:1.2614538669586 / seconds
Query Executed:select id FROM `mi` where city='Holt' && SIC_code='5461'DB:business_master_new
loadtime:1.2692229747772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holton' limit 1
loadtime:1.2692778110504 / seconds
Query Executed:select id FROM `mi` where city='Holton' && SIC_code='5461'DB:business_master_new
loadtime:1.2707109451294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homer' limit 1
loadtime:1.2707889080048 / seconds
Query Executed:select id FROM `mi` where city='Homer' && SIC_code='5461'DB:business_master_new
loadtime:1.2729938030243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honor' limit 1
loadtime:1.2730488777161 / seconds
Query Executed:select id FROM `mi` where city='Honor' && SIC_code='5461'DB:business_master_new
loadtime:1.2746779918671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:1.2747309207916 / seconds
Query Executed:select id FROM `mi` where city='Hope' && SIC_code='5461'DB:business_master_new
loadtime:1.275661945343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:1.2757148742676 / seconds
Query Executed:select id FROM `mi` where city='Hopkins' && SIC_code='5461'DB:business_master_new
loadtime:1.2774629592896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horton' limit 1
loadtime:1.2775168418884 / seconds
Query Executed:select id FROM `mi` where city='Horton' && SIC_code='5461'DB:business_master_new
loadtime:1.2789309024811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:1.27898478508 / seconds
Query Executed:select id FROM `mi` where city='Houghton' && SIC_code='5461'DB:business_master_new
loadtime:1.2847788333893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake' limit 1
loadtime:1.2848479747772 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.2873778343201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake Heights' limit 1
loadtime:1.2874329090118 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake Heights' && SIC_code='5461'DB:business_master_new
loadtime:1.2879159450531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard City' limit 1
loadtime:1.287969827652 / seconds
Query Executed:select id FROM `mi` where city='Howard City' && SIC_code='5461'DB:business_master_new
loadtime:1.2910017967224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:1.2910559177399 / seconds
Query Executed:select id FROM `mi` where city='Howell' && SIC_code='5461'DB:business_master_new
loadtime:1.298476934433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard Lake' limit 1
loadtime:1.2985508441925 / seconds
Query Executed:select id FROM `mi` where city='Hubbard Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.2998929023743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.2999489307404 / seconds
Query Executed:select id FROM `mi` where city='Hubbardston' && SIC_code='5461'DB:business_master_new
loadtime:1.3006179332733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbell' limit 1
loadtime:1.3006718158722 / seconds
Query Executed:select id FROM `mi` where city='Hubbell' && SIC_code='5461'DB:business_master_new
loadtime:1.3012979030609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.3013639450073 / seconds
Query Executed:select id FROM `mi` where city='Hudson' && SIC_code='5461'DB:business_master_new
loadtime:1.304260969162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudsonville' limit 1
loadtime:1.304328918457 / seconds
Query Executed:select id FROM `mi` where city='Hudsonville' && SIC_code='5461'DB:business_master_new
loadtime:1.314680814743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hulbert' limit 1
loadtime:1.314749956131 / seconds
Query Executed:select id FROM `mi` where city='Hulbert' && SIC_code='5461'DB:business_master_new
loadtime:1.3153488636017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington Woods' limit 1
loadtime:1.3154039382935 / seconds
Query Executed:select id FROM `mi` where city='Huntington Woods' && SIC_code='5461'DB:business_master_new
loadtime:1.3191659450531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida' limit 1
loadtime:1.319219827652 / seconds
Query Executed:select id FROM `mi` where city='Ida' && SIC_code='5461'DB:business_master_new
loadtime:1.3208348751068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idlewild' limit 1
loadtime:1.3208889961243 / seconds
Query Executed:select id FROM `mi` where city='Idlewild' && SIC_code='5461'DB:business_master_new
loadtime:1.3215298652649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imlay City' limit 1
loadtime:1.3215818405151 / seconds
Query Executed:select id FROM `mi` where city='Imlay City' && SIC_code='5461'DB:business_master_new
loadtime:1.3269529342651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian River' limit 1
loadtime:1.3270189762115 / seconds
Query Executed:select id FROM `mi` where city='Indian River' && SIC_code='5461'DB:business_master_new
loadtime:1.3306498527527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingalls' limit 1
loadtime:1.3307168483734 / seconds
Query Executed:select id FROM `mi` where city='Ingalls' && SIC_code='5461'DB:business_master_new
loadtime:1.3311619758606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inkster' limit 1
loadtime:1.3312158584595 / seconds
Query Executed:select id FROM `mi` where city='Inkster' && SIC_code='5461'DB:business_master_new
loadtime:1.3342249393463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interlochen' limit 1
loadtime:1.3342788219452 / seconds
Query Executed:select id FROM `mi` where city='Interlochen' && SIC_code='5461'DB:business_master_new
loadtime:1.3371558189392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:1.3372089862823 / seconds
Query Executed:select id FROM `mi` where city='Ionia' && SIC_code='5461'DB:business_master_new
loadtime:1.3449699878693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:1.3450238704681 / seconds
Query Executed:select id FROM `mi` where city='Ira' && SIC_code='5461'DB:business_master_new
loadtime:1.3454968929291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Mountain' limit 1
loadtime:1.3455488681793 / seconds
Query Executed:select id FROM `mi` where city='Iron Mountain' && SIC_code='5461'DB:business_master_new
loadtime:1.3554258346558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron River' limit 1
loadtime:1.3554949760437 / seconds
Query Executed:select id FROM `mi` where city='Iron River' && SIC_code='5461'DB:business_master_new
loadtime:1.3594629764557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irons' limit 1
loadtime:1.359531879425 / seconds
Query Executed:select id FROM `mi` where city='Irons' && SIC_code='5461'DB:business_master_new
loadtime:1.3606050014496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironwood' limit 1
loadtime:1.3606629371643 / seconds
Query Executed:select id FROM `mi` where city='Ironwood' && SIC_code='5461'DB:business_master_new
loadtime:1.3668179512024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ishpeming' limit 1
loadtime:1.366888999939 / seconds
Query Executed:select id FROM `mi` where city='Ishpeming' && SIC_code='5461'DB:business_master_new
loadtime:1.3720479011536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ithaca' limit 1
loadtime:1.3721158504486 / seconds
Query Executed:select id FROM `mi` where city='Ithaca' && SIC_code='5461'DB:business_master_new
loadtime:1.3758668899536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.3759329319 / seconds
Query Executed:select id FROM `mi` where city='Jackson' && SIC_code='5461'DB:business_master_new
loadtime:1.3835408687592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.383621931076 / seconds
Query Executed:select id FROM `mi` where city='Jamestown' && SIC_code='5461'DB:business_master_new
loadtime:1.3841779232025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jasper' limit 1
loadtime:1.3842318058014 / seconds
Query Executed:select id FROM `mi` where city='Jasper' && SIC_code='5461'DB:business_master_new
loadtime:1.385018825531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeddo' limit 1
loadtime:1.3850729465485 / seconds
Query Executed:select id FROM `mi` where city='Jeddo' && SIC_code='5461'DB:business_master_new
loadtime:1.386225938797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenison' limit 1
loadtime:1.3862788677216 / seconds
Query Executed:select id FROM `mi` where city='Jenison' && SIC_code='5461'DB:business_master_new
loadtime:1.3962519168854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:1.3963217735291 / seconds
Query Executed:select id FROM `mi` where city='Jerome' && SIC_code='5461'DB:business_master_new
loadtime:1.3973867893219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johannesburg' limit 1
loadtime:1.3974418640137 / seconds
Query Executed:select id FROM `mi` where city='Johannesburg' && SIC_code='5461'DB:business_master_new
loadtime:1.3980309963226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jones' limit 1
loadtime:1.3980848789215 / seconds
Query Executed:select id FROM `mi` where city='Jones' && SIC_code='5461'DB:business_master_new
loadtime:1.3989608287811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:1.3990139961243 / seconds
Query Executed:select id FROM `mi` where city='Jonesville' && SIC_code='5461'DB:business_master_new
loadtime:1.402242898941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalamazoo' limit 1
loadtime:1.4023098945618 / seconds
Query Executed:select id FROM `mi` where city='Kalamazoo' && SIC_code='5461'DB:business_master_new
loadtime:1.4096138477325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaleva' limit 1
loadtime:1.4096968173981 / seconds
Query Executed:select id FROM `mi` where city='Kaleva' && SIC_code='5461'DB:business_master_new
loadtime:1.4111328125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalkaska' limit 1
loadtime:1.4111979007721 / seconds
Query Executed:select id FROM `mi` where city='Kalkaska' && SIC_code='5461'DB:business_master_new
loadtime:1.417130947113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Karlin' limit 1
loadtime:1.4171929359436 / seconds
Query Executed:select id FROM `mi` where city='Karlin' && SIC_code='5461'DB:business_master_new
loadtime:1.4176299571991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kawkawlin' limit 1
loadtime:1.417692899704 / seconds
Query Executed:select id FROM `mi` where city='Kawkawlin' && SIC_code='5461'DB:business_master_new
loadtime:1.4201319217682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:1.4201939105988 / seconds
Query Executed:select id FROM `mi` where city='Kearsarge' && SIC_code='5461'DB:business_master_new
loadtime:1.4206008911133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keego Harbor' limit 1
loadtime:1.4206659793854 / seconds
Query Executed:select id FROM `mi` where city='Keego Harbor' && SIC_code='5461'DB:business_master_new
loadtime:1.425803899765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:1.4258849620819 / seconds
Query Executed:select id FROM `mi` where city='Kendall' && SIC_code='5461'DB:business_master_new
loadtime:1.4263207912445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenockee' limit 1
loadtime:1.426383972168 / seconds
Query Executed:select id FROM `mi` where city='Kenockee' && SIC_code='5461'DB:business_master_new
loadtime:1.4267988204956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent City' limit 1
loadtime:1.4268598556519 / seconds
Query Executed:select id FROM `mi` where city='Kent City' && SIC_code='5461'DB:business_master_new
loadtime:1.4288418292999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kentwood' limit 1
loadtime:1.4289038181305 / seconds
Query Executed:select id FROM `mi` where city='Kentwood' && SIC_code='5461'DB:business_master_new
loadtime:1.4294970035553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewadin' limit 1
loadtime:1.429557800293 / seconds
Query Executed:select id FROM `mi` where city='Kewadin' && SIC_code='5461'DB:business_master_new
loadtime:1.4308359622955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keweenaw Bay' limit 1
loadtime:1.4308989048004 / seconds
Query Executed:select id FROM `mi` where city='Keweenaw Bay' && SIC_code='5461'DB:business_master_new
loadtime:1.4313549995422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:1.4314157962799 / seconds
Query Executed:select id FROM `mi` where city='Kimball' && SIC_code='5461'DB:business_master_new
loadtime:1.4318947792053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kincheloe' limit 1
loadtime:1.4319570064545 / seconds
Query Executed:select id FROM `mi` where city='Kincheloe' && SIC_code='5461'DB:business_master_new
loadtime:1.4332828521729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinde' limit 1
loadtime:1.4333457946777 / seconds
Query Executed:select id FROM `mi` where city='Kinde' && SIC_code='5461'DB:business_master_new
loadtime:1.434455871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsford' limit 1
loadtime:1.434515953064 / seconds
Query Executed:select id FROM `mi` where city='Kingsford' && SIC_code='5461'DB:business_master_new
loadtime:1.4380168914795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:1.4380919933319 / seconds
Query Executed:select id FROM `mi` where city='Kingsley' && SIC_code='5461'DB:business_master_new
loadtime:1.4415829181671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.4416508674622 / seconds
Query Executed:select id FROM `mi` where city='Kingston' && SIC_code='5461'DB:business_master_new
loadtime:1.4430530071259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:1.4431149959564 / seconds
Query Executed:select id FROM `mi` where city='Kinross' && SIC_code='5461'DB:business_master_new
loadtime:1.4439089298248 / seconds
Query loaded from cache:select * from geodata_geocity where city='L Anse' limit 1
loadtime:1.4439699649811 / seconds
Query Executed:select id FROM `mi` where city='L Anse' && SIC_code='5461'DB:business_master_new
loadtime:1.4444580078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Salle' limit 1
loadtime:1.4445188045502 / seconds
Query Executed:select id FROM `mi` where city='La Salle' && SIC_code='5461'DB:business_master_new
loadtime:1.4459300041199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lachine' limit 1
loadtime:1.4459929466248 / seconds
Query Executed:select id FROM `mi` where city='Lachine' && SIC_code='5461'DB:business_master_new
loadtime:1.4471287727356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacota' limit 1
loadtime:1.4471909999847 / seconds
Query Executed:select id FROM `mi` where city='Lacota' && SIC_code='5461'DB:business_master_new
loadtime:1.4476418495178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laingsburg' limit 1
loadtime:1.4477038383484 / seconds
Query Executed:select id FROM `mi` where city='Laingsburg' && SIC_code='5461'DB:business_master_new
loadtime:1.4505729675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:1.4506378173828 / seconds
Query Executed:select id FROM `mi` where city='Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.4520888328552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Angelus' limit 1
loadtime:1.4521508216858 / seconds
Query Executed:select id FROM `mi` where city='Lake Angelus' && SIC_code='5461'DB:business_master_new
loadtime:1.4526069164276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Ann' limit 1
loadtime:1.4526817798615 / seconds
Query Executed:select id FROM `mi` where city='Lake Ann' && SIC_code='5461'DB:business_master_new
loadtime:1.4541759490967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:1.4542369842529 / seconds
Query Executed:select id FROM `mi` where city='Lake City' && SIC_code='5461'DB:business_master_new
loadtime:1.4580678939819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake George' limit 1
loadtime:1.4581439495087 / seconds
Query Executed:select id FROM `mi` where city='Lake George' && SIC_code='5461'DB:business_master_new
loadtime:1.4587588310242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Leelanau' limit 1
loadtime:1.4588317871094 / seconds
Query Executed:select id FROM `mi` where city='Lake Leelanau' && SIC_code='5461'DB:business_master_new
loadtime:1.460510969162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Linden' limit 1
loadtime:1.4605720043182 / seconds
Query Executed:select id FROM `mi` where city='Lake Linden' && SIC_code='5461'DB:business_master_new
loadtime:1.4619998931885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Odessa' limit 1
loadtime:1.462061882019 / seconds
Query Executed:select id FROM `mi` where city='Lake Odessa' && SIC_code='5461'DB:business_master_new
loadtime:1.4650149345398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Orion' limit 1
loadtime:1.4650909900665 / seconds
Query Executed:select id FROM `mi` where city='Lake Orion' && SIC_code='5461'DB:business_master_new
loadtime:1.4789898395538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeland' limit 1
loadtime:1.4790778160095 / seconds
Query Executed:select id FROM `mi` where city='Lakeland' && SIC_code='5461'DB:business_master_new
loadtime:1.4798269271851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeport' limit 1
loadtime:1.4798908233643 / seconds
Query Executed:select id FROM `mi` where city='Lakeport' && SIC_code='5461'DB:business_master_new
loadtime:1.4803028106689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:1.4803628921509 / seconds
Query Executed:select id FROM `mi` where city='Lakeside' && SIC_code='5461'DB:business_master_new
loadtime:1.4810748100281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:1.4811358451843 / seconds
Query Executed:select id FROM `mi` where city='Lakeview' && SIC_code='5461'DB:business_master_new
loadtime:1.4838709831238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.4839317798615 / seconds
Query Executed:select id FROM `mi` where city='Lakeville' && SIC_code='5461'DB:business_master_new
loadtime:1.4845027923584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambertville' limit 1
loadtime:1.4845638275146 / seconds
Query Executed:select id FROM `mi` where city='Lambertville' && SIC_code='5461'DB:business_master_new
loadtime:1.4889268875122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:1.4889888763428 / seconds
Query Executed:select id FROM `mi` where city='Lamont' && SIC_code='5461'DB:business_master_new
loadtime:1.489471912384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanse' limit 1
loadtime:1.4895329475403 / seconds
Query Executed:select id FROM `mi` where city='Lanse' && SIC_code='5461'DB:business_master_new
loadtime:1.4926278591156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:1.4926898479462 / seconds
Query Executed:select id FROM `mi` where city='Lansing' && SIC_code='5461'DB:business_master_new
loadtime:1.5003638267517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapeer' limit 1
loadtime:1.5004599094391 / seconds
Query Executed:select id FROM `mi` where city='Lapeer' && SIC_code='5461'DB:business_master_new
loadtime:1.5159838199615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lathrup Village' limit 1
loadtime:1.5160708427429 / seconds
Query Executed:select id FROM `mi` where city='Lathrup Village' && SIC_code='5461'DB:business_master_new
loadtime:1.5171368122101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurium' limit 1
loadtime:1.5171999931335 / seconds
Query Executed:select id FROM `mi` where city='Laurium' && SIC_code='5461'DB:business_master_new
loadtime:1.5176889896393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.517749786377 / seconds
Query Executed:select id FROM `mi` where city='Lawrence' && SIC_code='5461'DB:business_master_new
loadtime:1.5195407867432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:1.5196228027344 / seconds
Query Executed:select id FROM `mi` where city='Lawton' && SIC_code='5461'DB:business_master_new
loadtime:1.5220038890839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Roy' limit 1
loadtime:1.5220658779144 / seconds
Query Executed:select id FROM `mi` where city='Le Roy' && SIC_code='5461'DB:business_master_new
loadtime:1.5224750041962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:1.5225358009338 / seconds
Query Executed:select id FROM `mi` where city='Leland' && SIC_code='5461'DB:business_master_new
loadtime:1.5240747928619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennon' limit 1
loadtime:1.52414894104 / seconds
Query Executed:select id FROM `mi` where city='Lennon' && SIC_code='5461'DB:business_master_new
loadtime:1.5254998207092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.5255749225616 / seconds
Query Executed:select id FROM `mi` where city='Lenox' && SIC_code='5461'DB:business_master_new
loadtime:1.526163816452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonard' limit 1
loadtime:1.5262258052826 / seconds
Query Executed:select id FROM `mi` where city='Leonard' && SIC_code='5461'DB:business_master_new
loadtime:1.5281858444214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonidas' limit 1
loadtime:1.5282609462738 / seconds
Query Executed:select id FROM `mi` where city='Leonidas' && SIC_code='5461'DB:business_master_new
loadtime:1.5288310050964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leroy' limit 1
loadtime:1.528892993927 / seconds
Query Executed:select id FROM `mi` where city='Leroy' && SIC_code='5461'DB:business_master_new
loadtime:1.5301539897919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leslie' limit 1
loadtime:1.5302147865295 / seconds
Query Executed:select id FROM `mi` where city='Leslie' && SIC_code='5461'DB:business_master_new
loadtime:1.5330557823181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levering' limit 1
loadtime:1.5331327915192 / seconds
Query Executed:select id FROM `mi` where city='Levering' && SIC_code='5461'DB:business_master_new
loadtime:1.5341808795929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:1.5342428684235 / seconds
Query Executed:select id FROM `mi` where city='Lewiston' && SIC_code='5461'DB:business_master_new
loadtime:1.5353639125824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.5354249477386 / seconds
Query Executed:select id FROM `mi` where city='Lexington' && SIC_code='5461'DB:business_master_new
loadtime:1.5383780002594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limestone' limit 1
loadtime:1.5384519100189 / seconds
Query Executed:select id FROM `mi` where city='Limestone' && SIC_code='5461'DB:business_master_new
loadtime:1.5388488769531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.5389108657837 / seconds
Query Executed:select id FROM `mi` where city='Lincoln' && SIC_code='5461'DB:business_master_new
loadtime:1.5405459403992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln Park' limit 1
loadtime:1.5406098365784 / seconds
Query Executed:select id FROM `mi` where city='Lincoln Park' && SIC_code='5461'DB:business_master_new
loadtime:1.5454030036926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:1.5454649925232 / seconds
Query Executed:select id FROM `mi` where city='Linden' && SIC_code='5461'DB:business_master_new
loadtime:1.550577878952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.5506458282471 / seconds
Query Executed:select id FROM `mi` where city='Linwood' && SIC_code='5461'DB:business_master_new
loadtime:1.5528049468994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:1.5529539585114 / seconds
Query Executed:select id FROM `mi` where city='Litchfield' && SIC_code='5461'DB:business_master_new
loadtime:1.5547938346863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Lake' limit 1
loadtime:1.5548567771912 / seconds
Query Executed:select id FROM `mi` where city='Little Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.5553629398346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livonia' limit 1
loadtime:1.5554149150848 / seconds
Query Executed:select id FROM `mi` where city='Livonia' && SIC_code='5461'DB:business_master_new
loadtime:1.5630819797516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Lake' limit 1
loadtime:1.5631518363953 / seconds
Query Executed:select id FROM `mi` where city='Long Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.5636208057404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:1.5636839866638 / seconds
Query Executed:select id FROM `mi` where city='Loretto' && SIC_code='5461'DB:business_master_new
loadtime:1.5641207695007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.5641748905182 / seconds
Query Executed:select id FROM `mi` where city='Lowell' && SIC_code='5461'DB:business_master_new
loadtime:1.5709989070892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludington' limit 1
loadtime:1.5710709095001 / seconds
Query Executed:select id FROM `mi` where city='Ludington' && SIC_code='5461'DB:business_master_new
loadtime:1.582083940506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna Pier' limit 1
loadtime:1.5821619033813 / seconds
Query Executed:select id FROM `mi` where city='Luna Pier' && SIC_code='5461'DB:business_master_new
loadtime:1.5829858779907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:1.5830478668213 / seconds
Query Executed:select id FROM `mi` where city='Lupton' && SIC_code='5461'DB:business_master_new
loadtime:1.5839569568634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:1.584018945694 / seconds
Query Executed:select id FROM `mi` where city='Luther' && SIC_code='5461'DB:business_master_new
loadtime:1.5848999023438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:1.5849628448486 / seconds
Query Executed:select id FROM `mi` where city='Luzerne' && SIC_code='5461'DB:business_master_new
loadtime:1.5856158733368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.5856838226318 / seconds
Query Executed:select id FROM `mi` where city='Lynn' && SIC_code='5461'DB:business_master_new
loadtime:1.5860958099365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:1.5861568450928 / seconds
Query Executed:select id FROM `mi` where city='Lyons' && SIC_code='5461'DB:business_master_new
loadtime:1.5870859622955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macatawa' limit 1
loadtime:1.5871469974518 / seconds
Query Executed:select id FROM `mi` where city='Macatawa' && SIC_code='5461'DB:business_master_new
loadtime:1.5877139568329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinac Island' limit 1
loadtime:1.5877759456635 / seconds
Query Executed:select id FROM `mi` where city='Mackinac Island' && SIC_code='5461'DB:business_master_new
loadtime:1.5900309085846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinaw City' limit 1
loadtime:1.5900938510895 / seconds
Query Executed:select id FROM `mi` where city='Mackinaw City' && SIC_code='5461'DB:business_master_new
loadtime:1.5932919979095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macomb' limit 1
loadtime:1.5933690071106 / seconds
Query Executed:select id FROM `mi` where city='Macomb' && SIC_code='5461'DB:business_master_new
loadtime:1.6008448600769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:1.6009268760681 / seconds
Query Executed:select id FROM `mi` where city='Madison Heights' && SIC_code='5461'DB:business_master_new
loadtime:1.6082170009613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mancelona' limit 1
loadtime:1.6082999706268 / seconds
Query Executed:select id FROM `mi` where city='Mancelona' && SIC_code='5461'DB:business_master_new
loadtime:1.6119389533997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.612016916275 / seconds
Query Executed:select id FROM `mi` where city='Manchester' && SIC_code='5461'DB:business_master_new
loadtime:1.6146428585052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistee' limit 1
loadtime:1.6147129535675 / seconds
Query Executed:select id FROM `mi` where city='Manistee' && SIC_code='5461'DB:business_master_new
loadtime:1.6232788562775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistique' limit 1
loadtime:1.62335896492 / seconds
Query Executed:select id FROM `mi` where city='Manistique' && SIC_code='5461'DB:business_master_new
loadtime:1.6251969337463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitou Beach' limit 1
loadtime:1.6252608299255 / seconds
Query Executed:select id FROM `mi` where city='Manitou Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.6267688274384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manton' limit 1
loadtime:1.6268548965454 / seconds
Query Executed:select id FROM `mi` where city='Manton' && SIC_code='5461'DB:business_master_new
loadtime:1.6290419101715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple City' limit 1
loadtime:1.6291038990021 / seconds
Query Executed:select id FROM `mi` where city='Maple City' && SIC_code='5461'DB:business_master_new
loadtime:1.6307039260864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Rapids' limit 1
loadtime:1.630765914917 / seconds
Query Executed:select id FROM `mi` where city='Maple Rapids' && SIC_code='5461'DB:business_master_new
loadtime:1.6314558982849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcellus' limit 1
loadtime:1.6315188407898 / seconds
Query Executed:select id FROM `mi` where city='Marcellus' && SIC_code='5461'DB:business_master_new
loadtime:1.6335299015045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marenisco' limit 1
loadtime:1.6335918903351 / seconds
Query Executed:select id FROM `mi` where city='Marenisco' && SIC_code='5461'DB:business_master_new
loadtime:1.634349822998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marine City' limit 1
loadtime:1.6344108581543 / seconds
Query Executed:select id FROM `mi` where city='Marine City' && SIC_code='5461'DB:business_master_new
loadtime:1.6393008232117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.6393809318542 / seconds
Query Executed:select id FROM `mi` where city='Marion' && SIC_code='5461'DB:business_master_new
loadtime:1.6415469646454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlette' limit 1
loadtime:1.6416099071503 / seconds
Query Executed:select id FROM `mi` where city='Marlette' && SIC_code='5461'DB:business_master_new
loadtime:1.6457698345184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:1.6458439826965 / seconds
Query Executed:select id FROM `mi` where city='Marne' && SIC_code='5461'DB:business_master_new
loadtime:1.6477890014648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:1.6478610038757 / seconds
Query Executed:select id FROM `mi` where city='Marquette' && SIC_code='5461'DB:business_master_new
loadtime:1.6553308963776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:1.6554188728333 / seconds
Query Executed:select id FROM `mi` where city='Marshall' && SIC_code='5461'DB:business_master_new
loadtime:1.6645438671112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:1.664627790451 / seconds
Query Executed:select id FROM `mi` where city='Martin' && SIC_code='5461'DB:business_master_new
loadtime:1.6660299301147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysville' limit 1
loadtime:1.6660928726196 / seconds
Query Executed:select id FROM `mi` where city='Marysville' && SIC_code='5461'DB:business_master_new
loadtime:1.6713049411774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:1.6713860034943 / seconds
Query Executed:select id FROM `mi` where city='Mason' && SIC_code='5461'DB:business_master_new
loadtime:1.6808929443359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mass City' limit 1
loadtime:1.6809759140015 / seconds
Query Executed:select id FROM `mi` where city='Mass City' && SIC_code='5461'DB:business_master_new
loadtime:1.6814849376678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattawan' limit 1
loadtime:1.6815478801727 / seconds
Query Executed:select id FROM `mi` where city='Mattawan' && SIC_code='5461'DB:business_master_new
loadtime:1.6850349903107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybee' limit 1
loadtime:1.6850969791412 / seconds
Query Executed:select id FROM `mi` where city='Maybee' && SIC_code='5461'DB:business_master_new
loadtime:1.6864528656006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:1.6865139007568 / seconds
Query Executed:select id FROM `mi` where city='Mayfield' && SIC_code='5461'DB:business_master_new
loadtime:1.6870288848877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayville' limit 1
loadtime:1.6870908737183 / seconds
Query Executed:select id FROM `mi` where city='Mayville' && SIC_code='5461'DB:business_master_new
loadtime:1.6889328956604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bain' limit 1
loadtime:1.6889958381653 / seconds
Query Executed:select id FROM `mi` where city='Mc Bain' && SIC_code='5461'DB:business_master_new
loadtime:1.6909267902374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Millan' limit 1
loadtime:1.690988779068 / seconds
Query Executed:select id FROM `mi` where city='Mc Millan' && SIC_code='5461'DB:business_master_new
loadtime:1.6918768882751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcbrides' limit 1
loadtime:1.6919388771057 / seconds
Query Executed:select id FROM `mi` where city='Mcbrides' && SIC_code='5461'DB:business_master_new
loadtime:1.6925039291382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:1.6925659179688 / seconds
Query Executed:select id FROM `mi` where city='Mears' && SIC_code='5461'DB:business_master_new
loadtime:1.6938118934631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mecosta' limit 1
loadtime:1.6938967704773 / seconds
Query Executed:select id FROM `mi` where city='Mecosta' && SIC_code='5461'DB:business_master_new
loadtime:1.6954889297485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:1.6955649852753 / seconds
Query Executed:select id FROM `mi` where city='Melvin' && SIC_code='5461'DB:business_master_new
loadtime:1.6963698863983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvindale' limit 1
loadtime:1.6964328289032 / seconds
Query Executed:select id FROM `mi` where city='Melvindale' && SIC_code='5461'DB:business_master_new
loadtime:1.6982538700104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Memphis' limit 1
loadtime:1.6983149051666 / seconds
Query Executed:select id FROM `mi` where city='Memphis' && SIC_code='5461'DB:business_master_new
loadtime:1.7004249095917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:1.7004859447479 / seconds
Query Executed:select id FROM `mi` where city='Mendon' && SIC_code='5461'DB:business_master_new
loadtime:1.7015209197998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menominee' limit 1
loadtime:1.7015829086304 / seconds
Query Executed:select id FROM `mi` where city='Menominee' && SIC_code='5461'DB:business_master_new
loadtime:1.7081799507141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:1.7082588672638 / seconds
Query Executed:select id FROM `mi` where city='Merrill' && SIC_code='5461'DB:business_master_new
loadtime:1.7099609375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:1.7100238800049 / seconds
Query Executed:select id FROM `mi` where city='Merritt' && SIC_code='5461'DB:business_master_new
loadtime:1.7106668949127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesick' limit 1
loadtime:1.7107338905334 / seconds
Query Executed:select id FROM `mi` where city='Mesick' && SIC_code='5461'DB:business_master_new
loadtime:1.7127048969269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metamora' limit 1
loadtime:1.7127668857574 / seconds
Query Executed:select id FROM `mi` where city='Metamora' && SIC_code='5461'DB:business_master_new
loadtime:1.7164499759674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michiana' limit 1
loadtime:1.7165129184723 / seconds
Query Executed:select id FROM `mi` where city='Michiana' && SIC_code='5461'DB:business_master_new
loadtime:1.716912984848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigamme' limit 1
loadtime:1.7169759273529 / seconds
Query Executed:select id FROM `mi` where city='Michigamme' && SIC_code='5461'DB:business_master_new
loadtime:1.7177248001099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan Center' limit 1
loadtime:1.7177867889404 / seconds
Query Executed:select id FROM `mi` where city='Michigan Center' && SIC_code='5461'DB:business_master_new
loadtime:1.7199189662933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.7199809551239 / seconds
Query Executed:select id FROM `mi` where city='Middleton' && SIC_code='5461'DB:business_master_new
loadtime:1.7207689285278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleville' limit 1
loadtime:1.720841884613 / seconds
Query Executed:select id FROM `mi` where city='Middleville' && SIC_code='5461'DB:business_master_new
loadtime:1.7250978946686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:1.7251758575439 / seconds
Query Executed:select id FROM `mi` where city='Midland' && SIC_code='5461'DB:business_master_new
loadtime:1.7328219413757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikado' limit 1
loadtime:1.7329199314117 / seconds
Query Executed:select id FROM `mi` where city='Mikado' && SIC_code='5461'DB:business_master_new
loadtime:1.733874797821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:1.7339389324188 / seconds
Query Executed:select id FROM `mi` where city='Milan' && SIC_code='5461'DB:business_master_new
loadtime:1.7364568710327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.7365188598633 / seconds
Query Executed:select id FROM `mi` where city='Milford' && SIC_code='5461'DB:business_master_new
loadtime:1.7469389438629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:1.7470178604126 / seconds
Query Executed:select id FROM `mi` where city='Millersburg' && SIC_code='5461'DB:business_master_new
loadtime:1.7480399608612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millington' limit 1
loadtime:1.7481029033661 / seconds
Query Executed:select id FROM `mi` where city='Millington' && SIC_code='5461'DB:business_master_new
loadtime:1.7521259784698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden City' limit 1
loadtime:1.7521917819977 / seconds
Query Executed:select id FROM `mi` where city='Minden City' && SIC_code='5461'DB:business_master_new
loadtime:1.7530229091644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mio' limit 1
loadtime:1.7530868053436 / seconds
Query Executed:select id FROM `mi` where city='Mio' && SIC_code='5461'DB:business_master_new
loadtime:1.7567808628082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohawk' limit 1
loadtime:1.7568688392639 / seconds
Query Executed:select id FROM `mi` where city='Mohawk' && SIC_code='5461'DB:business_master_new
loadtime:1.7577919960022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moline' limit 1
loadtime:1.7578649520874 / seconds
Query Executed:select id FROM `mi` where city='Moline' && SIC_code='5461'DB:business_master_new
loadtime:1.7584838867188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:1.7585468292236 / seconds
Query Executed:select id FROM `mi` where city='Monroe' && SIC_code='5461'DB:business_master_new
loadtime:1.7659718990326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:1.7660608291626 / seconds
Query Executed:select id FROM `mi` where city='Montague' && SIC_code='5461'DB:business_master_new
loadtime:1.7697489261627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.7698128223419 / seconds
Query Executed:select id FROM `mi` where city='Montgomery' && SIC_code='5461'DB:business_master_new
loadtime:1.7707438468933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:1.7708067893982 / seconds
Query Executed:select id FROM `mi` where city='Montrose' && SIC_code='5461'DB:business_master_new
loadtime:1.7739238739014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moran' limit 1
loadtime:1.7740018367767 / seconds
Query Executed:select id FROM `mi` where city='Moran' && SIC_code='5461'DB:business_master_new
loadtime:1.774749994278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:1.7748129367828 / seconds
Query Executed:select id FROM `mi` where city='Morenci' && SIC_code='5461'DB:business_master_new
loadtime:1.7767508029938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:1.7768127918243 / seconds
Query Executed:select id FROM `mi` where city='Morley' && SIC_code='5461'DB:business_master_new
loadtime:1.7780809402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrice' limit 1
loadtime:1.7781569957733 / seconds
Query Executed:select id FROM `mi` where city='Morrice' && SIC_code='5461'DB:business_master_new
loadtime:1.7795569896698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:1.7796177864075 / seconds
Query Executed:select id FROM `mi` where city='Moscow' && SIC_code='5461'DB:business_master_new
loadtime:1.7800719738007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosherville' limit 1
loadtime:1.7801349163055 / seconds
Query Executed:select id FROM `mi` where city='Mosherville' && SIC_code='5461'DB:business_master_new
loadtime:1.7805829048157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Clemens' limit 1
loadtime:1.7806439399719 / seconds
Query Executed:select id FROM `mi` where city='Mount Clemens' && SIC_code='5461'DB:business_master_new
loadtime:1.7880098819733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Morris' limit 1
loadtime:1.7880878448486 / seconds
Query Executed:select id FROM `mi` where city='Mount Morris' && SIC_code='5461'DB:business_master_new
loadtime:1.7952618598938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:1.7953269481659 / seconds
Query Executed:select id FROM `mi` where city='Mount Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:1.8026659488678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Clemens' limit 1
loadtime:1.8027498722076 / seconds
Query Executed:select id FROM `mi` where city='Mt Clemens' && SIC_code='5461'DB:business_master_new
loadtime:1.8035569190979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Morris' limit 1
loadtime:1.8036198616028 / seconds
Query Executed:select id FROM `mi` where city='Mt Morris' && SIC_code='5461'DB:business_master_new
loadtime:1.8040719032288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:1.8041338920593 / seconds
Query Executed:select id FROM `mi` where city='Mt Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:1.8052887916565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muir' limit 1
loadtime:1.8053498268127 / seconds
Query Executed:select id FROM `mi` where city='Muir' && SIC_code='5461'DB:business_master_new
loadtime:1.8061628341675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullett Lake' limit 1
loadtime:1.806224822998 / seconds
Query Executed:select id FROM `mi` where city='Mullett Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.8066418170929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulliken' limit 1
loadtime:1.8067100048065 / seconds
Query Executed:select id FROM `mi` where city='Mulliken' && SIC_code='5461'DB:business_master_new
loadtime:1.8076808452606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munger' limit 1
loadtime:1.8077449798584 / seconds
Query Executed:select id FROM `mi` where city='Munger' && SIC_code='5461'DB:business_master_new
loadtime:1.8086597919464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munising' limit 1
loadtime:1.8087258338928 / seconds
Query Executed:select id FROM `mi` where city='Munising' && SIC_code='5461'DB:business_master_new
loadtime:1.8130428791046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munith' limit 1
loadtime:1.81312084198 / seconds
Query Executed:select id FROM `mi` where city='Munith' && SIC_code='5461'DB:business_master_new
loadtime:1.8144087791443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon' limit 1
loadtime:1.814484834671 / seconds
Query Executed:select id FROM `mi` where city='Muskegon' && SIC_code='5461'DB:business_master_new
loadtime:1.8218247890472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon Heights' limit 1
loadtime:1.8219239711761 / seconds
Query Executed:select id FROM `mi` where city='Muskegon Heights' && SIC_code='5461'DB:business_master_new
loadtime:1.8223598003387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mussey' limit 1
loadtime:1.8224229812622 / seconds
Query Executed:select id FROM `mi` where city='Mussey' && SIC_code='5461'DB:business_master_new
loadtime:1.8228669166565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nadeau' limit 1
loadtime:1.8229298591614 / seconds
Query Executed:select id FROM `mi` where city='Nadeau' && SIC_code='5461'DB:business_master_new
loadtime:1.8234009742737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahma' limit 1
loadtime:1.8234629631042 / seconds
Query Executed:select id FROM `mi` where city='Nahma' && SIC_code='5461'DB:business_master_new
loadtime:1.8239409923553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Napoleon' limit 1
loadtime:1.824001789093 / seconds
Query Executed:select id FROM `mi` where city='Napoleon' && SIC_code='5461'DB:business_master_new
loadtime:1.8250079154968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:1.8250699043274 / seconds
Query Executed:select id FROM `mi` where city='Nashville' && SIC_code='5461'DB:business_master_new
loadtime:1.8270108699799 / seconds
Query loaded from cache:select * from geodata_geocity where city='National City' limit 1
loadtime:1.8270728588104 / seconds
Query Executed:select id FROM `mi` where city='National City' && SIC_code='5461'DB:business_master_new
loadtime:1.8280138969421 / seconds
Query loaded from cache:select * from geodata_geocity where city='National Mine' limit 1
loadtime:1.8280758857727 / seconds
Query Executed:select id FROM `mi` where city='National Mine' && SIC_code='5461'DB:business_master_new
loadtime:1.8284878730774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naubinway' limit 1
loadtime:1.828549861908 / seconds
Query Executed:select id FROM `mi` where city='Naubinway' && SIC_code='5461'DB:business_master_new
loadtime:1.8294718265533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazareth' limit 1
loadtime:1.8295328617096 / seconds
Query Executed:select id FROM `mi` where city='Nazareth' && SIC_code='5461'DB:business_master_new
loadtime:1.8300647735596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Negaunee' limit 1
loadtime:1.8301270008087 / seconds
Query Executed:select id FROM `mi` where city='Negaunee' && SIC_code='5461'DB:business_master_new
loadtime:1.8336308002472 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Baltimore' limit 1
loadtime:1.8337128162384 / seconds
Query Executed:select id FROM `mi` where city='New Baltimore' && SIC_code='5461'DB:business_master_new
loadtime:1.8410449028015 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:1.8411297798157 / seconds
Query Executed:select id FROM `mi` where city='New Boston' && SIC_code='5461'DB:business_master_new
loadtime:1.8425979614258 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Buffalo' limit 1
loadtime:1.8426628112793 / seconds
Query Executed:select id FROM `mi` where city='New Buffalo' && SIC_code='5461'DB:business_master_new
loadtime:1.8475198745728 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Era' limit 1
loadtime:1.8475978374481 / seconds
Query Executed:select id FROM `mi` where city='New Era' && SIC_code='5461'DB:business_master_new
loadtime:1.8488237857819 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:1.8488957881927 / seconds
Query Executed:select id FROM `mi` where city='New Haven' && SIC_code='5461'DB:business_master_new
loadtime:1.8519289493561 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hudson' limit 1
loadtime:1.8520088195801 / seconds
Query Executed:select id FROM `mi` where city='New Hudson' && SIC_code='5461'DB:business_master_new
loadtime:1.8548648357391 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lothrop' limit 1
loadtime:1.8549289703369 / seconds
Query Executed:select id FROM `mi` where city='New Lothrop' && SIC_code='5461'DB:business_master_new
loadtime:1.8562889099121 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Troy' limit 1
loadtime:1.856351852417 / seconds
Query Executed:select id FROM `mi` where city='New Troy' && SIC_code='5461'DB:business_master_new
loadtime:1.8569397926331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newaygo' limit 1
loadtime:1.8570029735565 / seconds
Query Executed:select id FROM `mi` where city='Newaygo' && SIC_code='5461'DB:business_master_new
loadtime:1.8624517917633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:1.8625149726868 / seconds
Query Executed:select id FROM `mi` where city='Newberry' && SIC_code='5461'DB:business_master_new
loadtime:1.8662569522858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:1.8663368225098 / seconds
Query Executed:select id FROM `mi` where city='Newport' && SIC_code='5461'DB:business_master_new
loadtime:1.8694808483124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niles' limit 1
loadtime:1.8695468902588 / seconds
Query Executed:select id FROM `mi` where city='Niles' && SIC_code='5461'DB:business_master_new
loadtime:1.876975774765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisula' limit 1
loadtime:1.8770558834076 / seconds
Query Executed:select id FROM `mi` where city='Nisula' && SIC_code='5461'DB:business_master_new
loadtime:1.8775079250336 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:1.8775718212128 / seconds
Query Executed:select id FROM `mi` where city='North Adams' && SIC_code='5461'DB:business_master_new
loadtime:1.8786699771881 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branch' limit 1
loadtime:1.8787457942963 / seconds
Query Executed:select id FROM `mi` where city='North Branch' && SIC_code='5461'DB:business_master_new
loadtime:1.8823058605194 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Muskegon' limit 1
loadtime:1.8823838233948 / seconds
Query Executed:select id FROM `mi` where city='North Muskegon' && SIC_code='5461'DB:business_master_new
loadtime:1.8828229904175 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Star' limit 1
loadtime:1.8828938007355 / seconds
Query Executed:select id FROM `mi` where city='North Star' && SIC_code='5461'DB:business_master_new
loadtime:1.8833248615265 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Street' limit 1
loadtime:1.8833878040314 / seconds
Query Executed:select id FROM `mi` where city='North Street' && SIC_code='5461'DB:business_master_new
loadtime:1.8852069377899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northport' limit 1
loadtime:1.8852698802948 / seconds
Query Executed:select id FROM `mi` where city='Northport' && SIC_code='5461'DB:business_master_new
loadtime:1.8870258331299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:1.8871028423309 / seconds
Query Executed:select id FROM `mi` where city='Northville' && SIC_code='5461'DB:business_master_new
loadtime:1.8943178653717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norvell' limit 1
loadtime:1.8943979740143 / seconds
Query Executed:select id FROM `mi` where city='Norvell' && SIC_code='5461'DB:business_master_new
loadtime:1.8948698043823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:1.8949329853058 / seconds
Query Executed:select id FROM `mi` where city='Norway' && SIC_code='5461'DB:business_master_new
loadtime:1.8972418308258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottawa' limit 1
loadtime:1.8973047733307 / seconds
Query Executed:select id FROM `mi` where city='Nottawa' && SIC_code='5461'DB:business_master_new
loadtime:1.897754907608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Novi' limit 1
loadtime:1.8978168964386 / seconds
Query Executed:select id FROM `mi` where city='Novi' && SIC_code='5461'DB:business_master_new
loadtime:1.9051737785339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunica' limit 1
loadtime:1.9052557945251 / seconds
Query Executed:select id FROM `mi` where city='Nunica' && SIC_code='5461'DB:business_master_new
loadtime:1.9072568416595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Grove' limit 1
loadtime:1.9073197841644 / seconds
Query Executed:select id FROM `mi` where city='Oak Grove' && SIC_code='5461'DB:business_master_new
loadtime:1.9077417850494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Park' limit 1
loadtime:1.90780377388 / seconds
Query Executed:select id FROM `mi` where city='Oak Park' && SIC_code='5461'DB:business_master_new
loadtime:1.9151248931885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:1.9152147769928 / seconds
Query Executed:select id FROM `mi` where city='Oakland' && SIC_code='5461'DB:business_master_new
loadtime:1.9172158241272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland Twp' limit 1
loadtime:1.917279958725 / seconds
Query Executed:select id FROM `mi` where city='Oakland Twp' && SIC_code='5461'DB:business_master_new
loadtime:1.9177157878876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:1.9177777767181 / seconds
Query Executed:select id FROM `mi` where city='Oakley' && SIC_code='5461'DB:business_master_new
loadtime:1.9188039302826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oden' limit 1
loadtime:1.9188759326935 / seconds
Query Executed:select id FROM `mi` where city='Oden' && SIC_code='5461'DB:business_master_new
loadtime:1.9194059371948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okemos' limit 1
loadtime:1.9194679260254 / seconds
Query Executed:select id FROM `mi` where city='Okemos' && SIC_code='5461'DB:business_master_new
loadtime:1.9267728328705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mission' limit 1
loadtime:1.9268658161163 / seconds
Query Executed:select id FROM `mi` where city='Old Mission' && SIC_code='5461'DB:business_master_new
loadtime:1.9274368286133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:1.9275009632111 / seconds
Query Executed:select id FROM `mi` where city='Olivet' && SIC_code='5461'DB:business_master_new
loadtime:1.9291858673096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omena' limit 1
loadtime:1.9292478561401 / seconds
Query Executed:select id FROM `mi` where city='Omena' && SIC_code='5461'DB:business_master_new
loadtime:1.9297909736633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omer' limit 1
loadtime:1.9298629760742 / seconds
Query Executed:select id FROM `mi` where city='Omer' && SIC_code='5461'DB:business_master_new
loadtime:1.9308698177338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaway' limit 1
loadtime:1.9309318065643 / seconds
Query Executed:select id FROM `mi` where city='Onaway' && SIC_code='5461'DB:business_master_new
loadtime:1.933376789093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onekama' limit 1
loadtime:1.9334387779236 / seconds
Query Executed:select id FROM `mi` where city='Onekama' && SIC_code='5461'DB:business_master_new
loadtime:1.9349029064178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onondaga' limit 1
loadtime:1.9349789619446 / seconds
Query Executed:select id FROM `mi` where city='Onondaga' && SIC_code='5461'DB:business_master_new
loadtime:1.936007976532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onsted' limit 1
loadtime:1.9360699653625 / seconds
Query Executed:select id FROM `mi` where city='Onsted' && SIC_code='5461'DB:business_master_new
loadtime:1.938766002655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontonagon' limit 1
loadtime:1.9388279914856 / seconds
Query Executed:select id FROM `mi` where city='Ontonagon' && SIC_code='5461'DB:business_master_new
loadtime:1.9402449131012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard Lake' limit 1
loadtime:1.9403088092804 / seconds
Query Executed:select id FROM `mi` where city='Orchard Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.9407329559326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orion' limit 1
loadtime:1.9407958984375 / seconds
Query Executed:select id FROM `mi` where city='Orion' && SIC_code='5461'DB:business_master_new
loadtime:1.9412279129028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:1.9412899017334 / seconds
Query Executed:select id FROM `mi` where city='Orleans' && SIC_code='5461'DB:business_master_new
loadtime:1.9421238899231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortonville' limit 1
loadtime:1.942186832428 / seconds
Query Executed:select id FROM `mi` where city='Ortonville' && SIC_code='5461'DB:business_master_new
loadtime:1.948380947113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oscoda' limit 1
loadtime:1.9484438896179 / seconds
Query Executed:select id FROM `mi` where city='Oscoda' && SIC_code='5461'DB:business_master_new
loadtime:1.9546477794647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshtemo' limit 1
loadtime:1.9547328948975 / seconds
Query Executed:select id FROM `mi` where city='Oshtemo' && SIC_code='5461'DB:business_master_new
loadtime:1.9559988975525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osseo' limit 1
loadtime:1.9560627937317 / seconds
Query Executed:select id FROM `mi` where city='Osseo' && SIC_code='5461'DB:business_master_new
loadtime:1.957338809967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossineke' limit 1
loadtime:1.9574007987976 / seconds
Query Executed:select id FROM `mi` where city='Ossineke' && SIC_code='5461'DB:business_master_new
loadtime:1.9587519168854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otisville' limit 1
loadtime:1.9588129520416 / seconds
Query Executed:select id FROM `mi` where city='Otisville' && SIC_code='5461'DB:business_master_new
loadtime:1.9606959819794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otsego' limit 1
loadtime:1.9607589244843 / seconds
Query Executed:select id FROM `mi` where city='Otsego' && SIC_code='5461'DB:business_master_new
loadtime:1.9648649692535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottawa Lake' limit 1
loadtime:1.9649438858032 / seconds
Query Executed:select id FROM `mi` where city='Ottawa Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.9672048091888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otter Lake' limit 1
loadtime:1.9672679901123 / seconds
Query Executed:select id FROM `mi` where city='Otter Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.9681417942047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovid' limit 1
loadtime:1.968202829361 / seconds
Query Executed:select id FROM `mi` where city='Ovid' && SIC_code='5461'DB:business_master_new
loadtime:1.9701528549194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owendale' limit 1
loadtime:1.97021484375 / seconds
Query Executed:select id FROM `mi` where city='Owendale' && SIC_code='5461'DB:business_master_new
loadtime:1.9710669517517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owosso' limit 1
loadtime:1.971127986908 / seconds
Query Executed:select id FROM `mi` where city='Owosso' && SIC_code='5461'DB:business_master_new
loadtime:1.9848568439484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.9849429130554 / seconds
Query Executed:select id FROM `mi` where city='Oxford' && SIC_code='5461'DB:business_master_new
loadtime:1.9954428672791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painesdale' limit 1
loadtime:1.9955468177795 / seconds
Query Executed:select id FROM `mi` where city='Painesdale' && SIC_code='5461'DB:business_master_new
loadtime:1.9961369037628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.9961998462677 / seconds
Query Executed:select id FROM `mi` where city='Palmer' && SIC_code='5461'DB:business_master_new
loadtime:1.996750831604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palms' limit 1
loadtime:1.9968128204346 / seconds
Query Executed:select id FROM `mi` where city='Palms' && SIC_code='5461'DB:business_master_new
loadtime:1.9973998069763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:1.9974608421326 / seconds
Query Executed:select id FROM `mi` where city='Palmyra' && SIC_code='5461'DB:business_master_new
loadtime:1.9982178211212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:1.9982788562775 / seconds
Query Executed:select id FROM `mi` where city='Palo' && SIC_code='5461'DB:business_master_new
loadtime:1.9987099170685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:1.9987709522247 / seconds
Query Executed:select id FROM `mi` where city='Paradise' && SIC_code='5461'DB:business_master_new
loadtime:2.0000898838043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchment' limit 1
loadtime:2.0001668930054 / seconds
Query Executed:select id FROM `mi` where city='Parchment' && SIC_code='5461'DB:business_master_new
loadtime:2.0005919933319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:2.0006539821625 / seconds
Query Executed:select id FROM `mi` where city='Paris' && SIC_code='5461'DB:business_master_new
loadtime:2.0018179416656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parma' limit 1
loadtime:2.0018908977509 / seconds
Query Executed:select id FROM `mi` where city='Parma' && SIC_code='5461'DB:business_master_new
loadtime:2.0040249824524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Paw' limit 1
loadtime:2.0041029453278 / seconds
Query Executed:select id FROM `mi` where city='Paw Paw' && SIC_code='5461'DB:business_master_new
loadtime:2.011255979538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peck' limit 1
loadtime:2.0113198757172 / seconds
Query Executed:select id FROM `mi` where city='Peck' && SIC_code='5461'DB:business_master_new
loadtime:2.0123198032379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelkie' limit 1
loadtime:2.0123817920685 / seconds
Query Executed:select id FROM `mi` where city='Pelkie' && SIC_code='5461'DB:business_master_new
loadtime:2.0130438804626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pellston' limit 1
loadtime:2.0131058692932 / seconds
Query Executed:select id FROM `mi` where city='Pellston' && SIC_code='5461'DB:business_master_new
loadtime:2.0144469738007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pentwater' limit 1
loadtime:2.0145089626312 / seconds
Query Executed:select id FROM `mi` where city='Pentwater' && SIC_code='5461'DB:business_master_new
loadtime:2.0166819095612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkins' limit 1
loadtime:2.0167438983917 / seconds
Query Executed:select id FROM `mi` where city='Perkins' && SIC_code='5461'DB:business_master_new
loadtime:2.0172629356384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perrinton' limit 1
loadtime:2.0173239707947 / seconds
Query Executed:select id FROM `mi` where city='Perrinton' && SIC_code='5461'DB:business_master_new
loadtime:2.0184087753296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perronville' limit 1
loadtime:2.018483877182 / seconds
Query Executed:select id FROM `mi` where city='Perronville' && SIC_code='5461'DB:business_master_new
loadtime:2.0189218521118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:2.0189838409424 / seconds
Query Executed:select id FROM `mi` where city='Perry' && SIC_code='5461'DB:business_master_new
loadtime:2.0227220058441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:2.0227839946747 / seconds
Query Executed:select id FROM `mi` where city='Petersburg' && SIC_code='5461'DB:business_master_new
loadtime:2.0250318050385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petoskey' limit 1
loadtime:2.0250949859619 / seconds
Query Executed:select id FROM `mi` where city='Petoskey' && SIC_code='5461'DB:business_master_new
loadtime:2.0327908992767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pewamo' limit 1
loadtime:2.0328838825226 / seconds
Query Executed:select id FROM `mi` where city='Pewamo' && SIC_code='5461'DB:business_master_new
loadtime:2.03382396698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickford' limit 1
loadtime:2.0338969230652 / seconds
Query Executed:select id FROM `mi` where city='Pickford' && SIC_code='5461'DB:business_master_new
loadtime:2.0350408554077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:2.0351028442383 / seconds
Query Executed:select id FROM `mi` where city='Pierson' && SIC_code='5461'DB:business_master_new
loadtime:2.0361099243164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pigeon' limit 1
loadtime:2.036171913147 / seconds
Query Executed:select id FROM `mi` where city='Pigeon' && SIC_code='5461'DB:business_master_new
loadtime:2.0388979911804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinckney' limit 1
loadtime:2.0389738082886 / seconds
Query Executed:select id FROM `mi` where city='Pinckney' && SIC_code='5461'DB:business_master_new
loadtime:2.0459318161011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinconning' limit 1
loadtime:2.0460097789764 / seconds
Query Executed:select id FROM `mi` where city='Pinconning' && SIC_code='5461'DB:business_master_new
loadtime:2.050351858139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:2.0504288673401 / seconds
Query Executed:select id FROM `mi` where city='Pittsford' && SIC_code='5461'DB:business_master_new
loadtime:2.0516378879547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainwell' limit 1
loadtime:2.0517058372498 / seconds
Query Executed:select id FROM `mi` where city='Plainwell' && SIC_code='5461'DB:business_master_new
loadtime:2.0585639476776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Lake' limit 1
loadtime:2.0586409568787 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.0596358776093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Ridge' limit 1
loadtime:2.05970287323 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Ridge' && SIC_code='5461'DB:business_master_new
loadtime:2.0615170001984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:2.0615789890289 / seconds
Query Executed:select id FROM `mi` where city='Plymouth' && SIC_code='5461'DB:business_master_new
loadtime:2.0725708007812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pointe Aux Pins' limit 1
loadtime:2.0726518630981 / seconds
Query Executed:select id FROM `mi` where city='Pointe Aux Pins' && SIC_code='5461'DB:business_master_new
loadtime:2.0732269287109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompeii' limit 1
loadtime:2.0732917785645 / seconds
Query Executed:select id FROM `mi` where city='Pompeii' && SIC_code='5461'DB:business_master_new
loadtime:2.0737040042877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontiac' limit 1
loadtime:2.0737659931183 / seconds
Query Executed:select id FROM `mi` where city='Pontiac' && SIC_code='5461'DB:business_master_new
loadtime:2.0812318325043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Austin' limit 1
loadtime:2.0813210010529 / seconds
Query Executed:select id FROM `mi` where city='Port Austin' && SIC_code='5461'DB:business_master_new
loadtime:2.0833568572998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Hope' limit 1
loadtime:2.0834338665009 / seconds
Query Executed:select id FROM `mi` where city='Port Hope' && SIC_code='5461'DB:business_master_new
loadtime:2.0845158100128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Huron' limit 1
loadtime:2.0845777988434 / seconds
Query Executed:select id FROM `mi` where city='Port Huron' && SIC_code='5461'DB:business_master_new
loadtime:2.0919017791748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Sanilac' limit 1
loadtime:2.0919828414917 / seconds
Query Executed:select id FROM `mi` where city='Port Sanilac' && SIC_code='5461'DB:business_master_new
loadtime:2.0935018062592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:2.0935778617859 / seconds
Query Executed:select id FROM `mi` where city='Portage' && SIC_code='5461'DB:business_master_new
loadtime:2.1009068489075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:2.100989818573 / seconds
Query Executed:select id FROM `mi` where city='Portland' && SIC_code='5461'DB:business_master_new
loadtime:2.105584859848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Posen' limit 1
loadtime:2.1056509017944 / seconds
Query Executed:select id FROM `mi` where city='Posen' && SIC_code='5461'DB:business_master_new
loadtime:2.1068658828735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potterville' limit 1
loadtime:2.1069288253784 / seconds
Query Executed:select id FROM `mi` where city='Potterville' && SIC_code='5461'DB:business_master_new
loadtime:2.1085557937622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers' limit 1
loadtime:2.1086328029633 / seconds
Query Executed:select id FROM `mi` where city='Powers' && SIC_code='5461'DB:business_master_new
loadtime:2.1095998287201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:2.109662771225 / seconds
Query Executed:select id FROM `mi` where city='Prescott' && SIC_code='5461'DB:business_master_new
loadtime:2.1113948822021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presque Isle' limit 1
loadtime:2.111457824707 / seconds
Query Executed:select id FROM `mi` where city='Presque Isle' && SIC_code='5461'DB:business_master_new
loadtime:2.1124668121338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prudenville' limit 1
loadtime:2.1125299930573 / seconds
Query Executed:select id FROM `mi` where city='Prudenville' && SIC_code='5461'DB:business_master_new
loadtime:2.1137969493866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pullman' limit 1
loadtime:2.1138679981232 / seconds
Query Executed:select id FROM `mi` where city='Pullman' && SIC_code='5461'DB:business_master_new
loadtime:2.115033864975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:2.1150949001312 / seconds
Query Executed:select id FROM `mi` where city='Quincy' && SIC_code='5461'DB:business_master_new
loadtime:2.1181819438934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinnesec' limit 1
loadtime:2.118243932724 / seconds
Query Executed:select id FROM `mi` where city='Quinnesec' && SIC_code='5461'DB:business_master_new
loadtime:2.1192147731781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:2.1192770004272 / seconds
Query Executed:select id FROM `mi` where city='Ralph' && SIC_code='5461'DB:business_master_new
loadtime:2.1197488307953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramsay' limit 1
loadtime:2.1198108196259 / seconds
Query Executed:select id FROM `mi` where city='Ramsay' && SIC_code='5461'DB:business_master_new
loadtime:2.1204259395599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:2.1204869747162 / seconds
Query Executed:select id FROM `mi` where city='Rapid City' && SIC_code='5461'DB:business_master_new
loadtime:2.1220729351044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid River' limit 1
loadtime:2.1221358776093 / seconds
Query Executed:select id FROM `mi` where city='Rapid River' && SIC_code='5461'DB:business_master_new
loadtime:2.123762845993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenna' limit 1
loadtime:2.1238248348236 / seconds
Query Executed:select id FROM `mi` where city='Ravenna' && SIC_code='5461'DB:business_master_new
loadtime:2.1261079311371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ray' limit 1
loadtime:2.1261689662933 / seconds
Query Executed:select id FROM `mi` where city='Ray' && SIC_code='5461'DB:business_master_new
loadtime:2.1279728412628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:2.1280338764191 / seconds
Query Executed:select id FROM `mi` where city='Reading' && SIC_code='5461'DB:business_master_new
loadtime:2.129567861557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redford' limit 1
loadtime:2.1296288967133 / seconds
Query Executed:select id FROM `mi` where city='Redford' && SIC_code='5461'DB:business_master_new
loadtime:2.1371209621429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reed City' limit 1
loadtime:2.1371989250183 / seconds
Query Executed:select id FROM `mi` where city='Reed City' && SIC_code='5461'DB:business_master_new
loadtime:2.1415147781372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reese' limit 1
loadtime:2.1415917873383 / seconds
Query Executed:select id FROM `mi` where city='Reese' && SIC_code='5461'DB:business_master_new
loadtime:2.143670797348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remus' limit 1
loadtime:2.143748998642 / seconds
Query Executed:select id FROM `mi` where city='Remus' && SIC_code='5461'DB:business_master_new
loadtime:2.1455698013306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republic' limit 1
loadtime:2.1456308364868 / seconds
Query Executed:select id FROM `mi` where city='Republic' && SIC_code='5461'DB:business_master_new
loadtime:2.146500825882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:2.1465618610382 / seconds
Query Executed:select id FROM `mi` where city='Rhodes' && SIC_code='5461'DB:business_master_new
loadtime:2.1473178863525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:2.1473779678345 / seconds
Query Executed:select id FROM `mi` where city='Richland' && SIC_code='5461'DB:business_master_new
loadtime:2.1516239643097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:2.151704788208 / seconds
Query Executed:select id FROM `mi` where city='Richmond' && SIC_code='5461'DB:business_master_new
loadtime:2.157016992569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richville' limit 1
loadtime:2.1570808887482 / seconds
Query Executed:select id FROM `mi` where city='Richville' && SIC_code='5461'DB:business_master_new
loadtime:2.15762591362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riga' limit 1
loadtime:2.1576919555664 / seconds
Query Executed:select id FROM `mi` where city='Riga' && SIC_code='5461'DB:business_master_new
loadtime:2.1585149765015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riley' limit 1
loadtime:2.1585757732391 / seconds
Query Executed:select id FROM `mi` where city='Riley' && SIC_code='5461'DB:business_master_new
loadtime:2.1589999198914 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Rouge' limit 1
loadtime:2.1590619087219 / seconds
Query Executed:select id FROM `mi` where city='River Rouge' && SIC_code='5461'DB:business_master_new
loadtime:2.1602149009705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:2.160276889801 / seconds
Query Executed:select id FROM `mi` where city='Riverdale' && SIC_code='5461'DB:business_master_new
loadtime:2.1613299846649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:2.1613898277283 / seconds
Query Executed:select id FROM `mi` where city='Riverside' && SIC_code='5461'DB:business_master_new
loadtime:2.1618649959564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverview' limit 1
loadtime:2.161926984787 / seconds
Query Executed:select id FROM `mi` where city='Riverview' && SIC_code='5461'DB:business_master_new
loadtime:2.1647219657898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rives Junction' limit 1
loadtime:2.1647989749908 / seconds
Query Executed:select id FROM `mi` where city='Rives Junction' && SIC_code='5461'DB:business_master_new
loadtime:2.1661078929901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.1661698818207 / seconds
Query Executed:select id FROM `mi` where city='Rochester' && SIC_code='5461'DB:business_master_new
loadtime:2.1737949848175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester Hills' limit 1
loadtime:2.1738998889923 / seconds
Query Executed:select id FROM `mi` where city='Rochester Hills' && SIC_code='5461'DB:business_master_new
loadtime:2.1751158237457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock' limit 1
loadtime:2.1751928329468 / seconds
Query Executed:select id FROM `mi` where city='Rock' && SIC_code='5461'DB:business_master_new
loadtime:2.1758828163147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:2.1759448051453 / seconds
Query Executed:select id FROM `mi` where city='Rockford' && SIC_code='5461'DB:business_master_new
loadtime:2.1832637786865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.1833407878876 / seconds
Query Executed:select id FROM `mi` where city='Rockland' && SIC_code='5461'DB:business_master_new
loadtime:2.1838397979736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwood' limit 1
loadtime:2.1839029788971 / seconds
Query Executed:select id FROM `mi` where city='Rockwood' && SIC_code='5461'DB:business_master_new
loadtime:2.1854329109192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:2.1854939460754 / seconds
Query Executed:select id FROM `mi` where city='Rodney' && SIC_code='5461'DB:business_master_new
loadtime:2.1863849163055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers City' limit 1
loadtime:2.1864459514618 / seconds
Query Executed:select id FROM `mi` where city='Rogers City' && SIC_code='5461'DB:business_master_new
loadtime:2.1903369426727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollin' limit 1
loadtime:2.1904129981995 / seconds
Query Executed:select id FROM `mi` where city='Rollin' && SIC_code='5461'DB:business_master_new
loadtime:2.1908819675446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romeo' limit 1
loadtime:2.1909449100494 / seconds
Query Executed:select id FROM `mi` where city='Romeo' && SIC_code='5461'DB:business_master_new
loadtime:2.1976828575134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romulus' limit 1
loadtime:2.1977608203888 / seconds
Query Executed:select id FROM `mi` where city='Romulus' && SIC_code='5461'DB:business_master_new
loadtime:2.2026529312134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscommon' limit 1
loadtime:2.2027199268341 / seconds
Query Executed:select id FROM `mi` where city='Roscommon' && SIC_code='5461'DB:business_master_new
loadtime:2.2050349712372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose City' limit 1
loadtime:2.2050969600677 / seconds
Query Executed:select id FROM `mi` where city='Rose City' && SIC_code='5461'DB:business_master_new
loadtime:2.2071068286896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebush' limit 1
loadtime:2.2071688175201 / seconds
Query Executed:select id FROM `mi` where city='Rosebush' && SIC_code='5461'DB:business_master_new
loadtime:2.2083139419556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseville' limit 1
loadtime:2.2083888053894 / seconds
Query Executed:select id FROM `mi` where city='Roseville' && SIC_code='5461'DB:business_master_new
loadtime:2.2157747745514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rothbury' limit 1
loadtime:2.2158689498901 / seconds
Query Executed:select id FROM `mi` where city='Rothbury' && SIC_code='5461'DB:business_master_new
loadtime:2.2168428897858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal Oak' limit 1
loadtime:2.2169079780579 / seconds
Query Executed:select id FROM `mi` where city='Royal Oak' && SIC_code='5461'DB:business_master_new
loadtime:2.2242238521576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:2.2243077754974 / seconds
Query Executed:select id FROM `mi` where city='Ruby' && SIC_code='5461'DB:business_master_new
loadtime:2.2247359752655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudyard' limit 1
loadtime:2.2247998714447 / seconds
Query Executed:select id FROM `mi` where city='Rudyard' && SIC_code='5461'DB:business_master_new
loadtime:2.2259709835052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumely' limit 1
loadtime:2.2260339260101 / seconds
Query Executed:select id FROM `mi` where city='Rumely' && SIC_code='5461'DB:business_master_new
loadtime:2.2265739440918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell Island' limit 1
loadtime:2.226634979248 / seconds
Query Executed:select id FROM `mi` where city='Russell Island' && SIC_code='5461'DB:business_master_new
loadtime:2.2270529270172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:2.2271139621735 / seconds
Query Executed:select id FROM `mi` where city='Ruth' && SIC_code='5461'DB:business_master_new
loadtime:2.2279789447784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saginaw' limit 1
loadtime:2.2280399799347 / seconds
Query Executed:select id FROM `mi` where city='Saginaw' && SIC_code='5461'DB:business_master_new
loadtime:2.2353630065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagola' limit 1
loadtime:2.235456943512 / seconds
Query Executed:select id FROM `mi` where city='Sagola' && SIC_code='5461'DB:business_master_new
loadtime:2.2360558509827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:2.2361209392548 / seconds
Query Executed:select id FROM `mi` where city='Saint Charles' && SIC_code='5461'DB:business_master_new
loadtime:2.2388257980347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair' limit 1
loadtime:2.2389090061188 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair' && SIC_code='5461'DB:business_master_new
loadtime:2.2453079223633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair Shores' limit 1
loadtime:2.2453877925873 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair Shores' && SIC_code='5461'DB:business_master_new
loadtime:2.2527749538422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helen' limit 1
loadtime:2.2528748512268 / seconds
Query Executed:select id FROM `mi` where city='Saint Helen' && SIC_code='5461'DB:business_master_new
loadtime:2.253839969635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ignace' limit 1
loadtime:2.2539048194885 / seconds
Query Executed:select id FROM `mi` where city='Saint Ignace' && SIC_code='5461'DB:business_master_new
loadtime:2.2584328651428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:2.2585089206696 / seconds
Query Executed:select id FROM `mi` where city='Saint Johns' && SIC_code='5461'DB:business_master_new
loadtime:2.267847776413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Joseph' limit 1
loadtime:2.2679259777069 / seconds
Query Executed:select id FROM `mi` where city='Saint Joseph' && SIC_code='5461'DB:business_master_new
loadtime:2.2752938270569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Louis' limit 1
loadtime:2.2753739356995 / seconds
Query Executed:select id FROM `mi` where city='Saint Louis' && SIC_code='5461'DB:business_master_new
loadtime:2.2795069217682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.2795839309692 / seconds
Query Executed:select id FROM `mi` where city='Salem' && SIC_code='5461'DB:business_master_new
loadtime:2.2800829410553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saline' limit 1
loadtime:2.2801458835602 / seconds
Query Executed:select id FROM `mi` where city='Saline' && SIC_code='5461'DB:business_master_new
loadtime:2.2856059074402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Samaria' limit 1
loadtime:2.2856888771057 / seconds
Query Executed:select id FROM `mi` where city='Samaria' && SIC_code='5461'DB:business_master_new
loadtime:2.2861478328705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Creek' limit 1
loadtime:2.2862107753754 / seconds
Query Executed:select id FROM `mi` where city='Sand Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.2869508266449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Lake' limit 1
loadtime:2.2870118618011 / seconds
Query Executed:select id FROM `mi` where city='Sand Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.2889809608459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandusky' limit 1
loadtime:2.2890567779541 / seconds
Query Executed:select id FROM `mi` where city='Sandusky' && SIC_code='5461'DB:business_master_new
loadtime:2.2947208881378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:2.2947859764099 / seconds
Query Executed:select id FROM `mi` where city='Sanford' && SIC_code='5461'DB:business_master_new
loadtime:2.2981188297272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saranac' limit 1
loadtime:2.2981808185577 / seconds
Query Executed:select id FROM `mi` where city='Saranac' && SIC_code='5461'DB:business_master_new
loadtime:2.3003239631653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugatuck' limit 1
loadtime:2.3004019260406 / seconds
Query Executed:select id FROM `mi` where city='Saugatuck' && SIC_code='5461'DB:business_master_new
loadtime:2.3044419288635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Sainte Marie' limit 1
loadtime:2.3045058250427 / seconds
Query Executed:select id FROM `mi` where city='Sault Sainte Marie' && SIC_code='5461'DB:business_master_new
loadtime:2.3165278434753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Ste Marie' limit 1
loadtime:2.3166079521179 / seconds
Query Executed:select id FROM `mi` where city='Sault Ste Marie' && SIC_code='5461'DB:business_master_new
loadtime:2.317409992218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sawyer' limit 1
loadtime:2.3174729347229 / seconds
Query Executed:select id FROM `mi` where city='Sawyer' && SIC_code='5461'DB:business_master_new
loadtime:2.3190569877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schoolcraft' limit 1
loadtime:2.319121837616 / seconds
Query Executed:select id FROM `mi` where city='Schoolcraft' && SIC_code='5461'DB:business_master_new
loadtime:2.322812795639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:2.3229007720947 / seconds
Query Executed:select id FROM `mi` where city='Scotts' && SIC_code='5461'DB:business_master_new
loadtime:2.3242428302765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:2.3243048191071 / seconds
Query Executed:select id FROM `mi` where city='Scottville' && SIC_code='5461'DB:business_master_new
loadtime:2.3270077705383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sears' limit 1
loadtime:2.3270847797394 / seconds
Query Executed:select id FROM `mi` where city='Sears' && SIC_code='5461'DB:business_master_new
loadtime:2.3278667926788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebewaing' limit 1
loadtime:2.3279438018799 / seconds
Query Executed:select id FROM `mi` where city='Sebewaing' && SIC_code='5461'DB:business_master_new
loadtime:2.3302268981934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selfridge Angb' limit 1
loadtime:2.3302907943726 / seconds
Query Executed:select id FROM `mi` where city='Selfridge Angb' && SIC_code='5461'DB:business_master_new
loadtime:2.3307819366455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:2.3308548927307 / seconds
Query Executed:select id FROM `mi` where city='Seneca' && SIC_code='5461'DB:business_master_new
loadtime:2.3312408924103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seney' limit 1
loadtime:2.3313028812408 / seconds
Query Executed:select id FROM `mi` where city='Seney' && SIC_code='5461'DB:business_master_new
loadtime:2.3317477703094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsburg' limit 1
loadtime:2.3318109512329 / seconds
Query Executed:select id FROM `mi` where city='Shaftsburg' && SIC_code='5461'DB:business_master_new
loadtime:2.3323378562927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:2.332398891449 / seconds
Query Executed:select id FROM `mi` where city='Shelby' && SIC_code='5461'DB:business_master_new
loadtime:2.3362329006195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby Twp' limit 1
loadtime:2.3362967967987 / seconds
Query Executed:select id FROM `mi` where city='Shelby Twp' && SIC_code='5461'DB:business_master_new
loadtime:2.3371298313141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelbyville' limit 1
loadtime:2.3371918201447 / seconds
Query Executed:select id FROM `mi` where city='Shelbyville' && SIC_code='5461'DB:business_master_new
loadtime:2.3386468887329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shepherd' limit 1
loadtime:2.3387138843536 / seconds
Query Executed:select id FROM `mi` where city='Shepherd' && SIC_code='5461'DB:business_master_new
loadtime:2.3411219120026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:2.3411839008331 / seconds
Query Executed:select id FROM `mi` where city='Sheridan' && SIC_code='5461'DB:business_master_new
loadtime:2.3430328369141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:2.3430938720703 / seconds
Query Executed:select id FROM `mi` where city='Sherwood' && SIC_code='5461'DB:business_master_new
loadtime:2.3438649177551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shingleton' limit 1
loadtime:2.3439259529114 / seconds
Query Executed:select id FROM `mi` where city='Shingleton' && SIC_code='5461'DB:business_master_new
loadtime:2.3446009159088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidnaw' limit 1
loadtime:2.3446629047394 / seconds
Query Executed:select id FROM `mi` where city='Sidnaw' && SIC_code='5461'DB:business_master_new
loadtime:2.3451337814331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:2.3451948165894 / seconds
Query Executed:select id FROM `mi` where city='Sidney' && SIC_code='5461'DB:business_master_new
loadtime:2.3458278179169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverwood' limit 1
loadtime:2.3458969593048 / seconds
Query Executed:select id FROM `mi` where city='Silverwood' && SIC_code='5461'DB:business_master_new
loadtime:2.3466258049011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Lakes' limit 1
loadtime:2.3466918468475 / seconds
Query Executed:select id FROM `mi` where city='Six Lakes' && SIC_code='5461'DB:business_master_new
loadtime:2.3479678630829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skandia' limit 1
loadtime:2.3480308055878 / seconds
Query Executed:select id FROM `mi` where city='Skandia' && SIC_code='5461'DB:business_master_new
loadtime:2.3491749763489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skanee' limit 1
loadtime:2.3492379188538 / seconds
Query Executed:select id FROM `mi` where city='Skanee' && SIC_code='5461'DB:business_master_new
loadtime:2.3497397899628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smiths Creek' limit 1
loadtime:2.349800825119 / seconds
Query Executed:select id FROM `mi` where city='Smiths Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.3540477752686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:2.354110956192 / seconds
Query Executed:select id FROM `mi` where city='Smyrna' && SIC_code='5461'DB:business_master_new
loadtime:2.3545029163361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snover' limit 1
loadtime:2.3545639514923 / seconds
Query Executed:select id FROM `mi` where city='Snover' && SIC_code='5461'DB:business_master_new
loadtime:2.3556749820709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sodus' limit 1
loadtime:2.355751991272 / seconds
Query Executed:select id FROM `mi` where city='Sodus' && SIC_code='5461'DB:business_master_new
loadtime:2.3567128181458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.3567748069763 / seconds
Query Executed:select id FROM `mi` where city='Somerset' && SIC_code='5461'DB:business_master_new
loadtime:2.3573169708252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset Center' limit 1
loadtime:2.3573789596558 / seconds
Query Executed:select id FROM `mi` where city='Somerset Center' && SIC_code='5461'DB:business_master_new
loadtime:2.3582038879395 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boardman' limit 1
loadtime:2.35826587677 / seconds
Query Executed:select id FROM `mi` where city='South Boardman' && SIC_code='5461'DB:business_master_new
loadtime:2.3592269420624 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Branch' limit 1
loadtime:2.3592889308929 / seconds
Query Executed:select id FROM `mi` where city='South Branch' && SIC_code='5461'DB:business_master_new
loadtime:2.3600258827209 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Haven' limit 1
loadtime:2.3600869178772 / seconds
Query Executed:select id FROM `mi` where city='South Haven' && SIC_code='5461'DB:business_master_new
loadtime:2.3692228794098 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyon' limit 1
loadtime:2.3693039417267 / seconds
Query Executed:select id FROM `mi` where city='South Lyon' && SIC_code='5461'DB:business_master_new
loadtime:2.3794689178467 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Range' limit 1
loadtime:2.3795487880707 / seconds
Query Executed:select id FROM `mi` where city='South Range' && SIC_code='5461'DB:business_master_new
loadtime:2.3803808689117 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Rockwood' limit 1
loadtime:2.3804450035095 / seconds
Query Executed:select id FROM `mi` where city='South Rockwood' && SIC_code='5461'DB:business_master_new
loadtime:2.3817028999329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.3817648887634 / seconds
Query Executed:select id FROM `mi` where city='Southfield' && SIC_code='5461'DB:business_master_new
loadtime:2.389476776123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southgate' limit 1
loadtime:2.389575958252 / seconds
Query Executed:select id FROM `mi` where city='Southgate' && SIC_code='5461'DB:business_master_new
loadtime:2.3946177959442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spalding' limit 1
loadtime:2.3946878910065 / seconds
Query Executed:select id FROM `mi` where city='Spalding' && SIC_code='5461'DB:business_master_new
loadtime:2.3953559398651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:2.3954179286957 / seconds
Query Executed:select id FROM `mi` where city='Sparta' && SIC_code='5461'DB:business_master_new
loadtime:2.4011099338531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Arbor' limit 1
loadtime:2.4011898040771 / seconds
Query Executed:select id FROM `mi` where city='Spring Arbor' && SIC_code='5461'DB:business_master_new
loadtime:2.4029259681702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:2.402988910675 / seconds
Query Executed:select id FROM `mi` where city='Spring Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.4103009700775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.4103808403015 / seconds
Query Executed:select id FROM `mi` where city='Springfield' && SIC_code='5461'DB:business_master_new
loadtime:2.4109239578247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield Twp' limit 1
loadtime:2.4109878540039 / seconds
Query Executed:select id FROM `mi` where city='Springfield Twp' && SIC_code='5461'DB:business_master_new
loadtime:2.4114179611206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springport' limit 1
loadtime:2.4114799499512 / seconds
Query Executed:select id FROM `mi` where city='Springport' && SIC_code='5461'DB:business_master_new
loadtime:2.412969827652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce' limit 1
loadtime:2.4130349159241 / seconds
Query Executed:select id FROM `mi` where city='Spruce' && SIC_code='5461'DB:business_master_new
loadtime:2.4140889644623 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:2.4141499996185 / seconds
Query Executed:select id FROM `mi` where city='St Charles' && SIC_code='5461'DB:business_master_new
loadtime:2.4145538806915 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair' limit 1
loadtime:2.4146149158478 / seconds
Query Executed:select id FROM `mi` where city='St Clair' && SIC_code='5461'DB:business_master_new
loadtime:2.4151268005371 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair Shores' limit 1
loadtime:2.4151878356934 / seconds
Query Executed:select id FROM `mi` where city='St Clair Shores' && SIC_code='5461'DB:business_master_new
loadtime:2.4159638881683 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ignace' limit 1
loadtime:2.4160258769989 / seconds
Query Executed:select id FROM `mi` where city='St Ignace' && SIC_code='5461'DB:business_master_new
loadtime:2.4164218902588 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:2.4164819717407 / seconds
Query Executed:select id FROM `mi` where city='St Johns' && SIC_code='5461'DB:business_master_new
loadtime:2.4169929027557 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Joseph' limit 1
loadtime:2.417053937912 / seconds
Query Executed:select id FROM `mi` where city='St Joseph' && SIC_code='5461'DB:business_master_new
loadtime:2.4177258014679 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Louis' limit 1
loadtime:2.4177868366241 / seconds
Query Executed:select id FROM `mi` where city='St Louis' && SIC_code='5461'DB:business_master_new
loadtime:2.4182047843933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stalwart' limit 1
loadtime:2.4182658195496 / seconds
Query Executed:select id FROM `mi` where city='Stalwart' && SIC_code='5461'DB:business_master_new
loadtime:2.4187138080597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stambaugh' limit 1
loadtime:2.4187757968903 / seconds
Query Executed:select id FROM `mi` where city='Stambaugh' && SIC_code='5461'DB:business_master_new
loadtime:2.419517993927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Standish' limit 1
loadtime:2.4195728302002 / seconds
Query Executed:select id FROM `mi` where city='Standish' && SIC_code='5461'DB:business_master_new
loadtime:2.4239809513092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:2.4240357875824 / seconds
Query Executed:select id FROM `mi` where city='Stanton' && SIC_code='5461'DB:business_master_new
loadtime:2.4281148910522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:2.4281849861145 / seconds
Query Executed:select id FROM `mi` where city='Stanwood' && SIC_code='5461'DB:business_master_new
loadtime:2.430342912674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:2.4303998947144 / seconds
Query Executed:select id FROM `mi` where city='Stephenson' && SIC_code='5461'DB:business_master_new
loadtime:2.4320647716522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.4321320056915 / seconds
Query Executed:select id FROM `mi` where city='Sterling' && SIC_code='5461'DB:business_master_new
loadtime:2.433394908905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling Heights' limit 1
loadtime:2.4334487915039 / seconds
Query Executed:select id FROM `mi` where city='Sterling Heights' && SIC_code='5461'DB:business_master_new
loadtime:2.4411649703979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:2.441253900528 / seconds
Query Executed:select id FROM `mi` where city='Stevensville' && SIC_code='5461'DB:business_master_new
loadtime:2.4470698833466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.4471459388733 / seconds
Query Executed:select id FROM `mi` where city='Stockbridge' && SIC_code='5461'DB:business_master_new
loadtime:2.4500308036804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stronach' limit 1
loadtime:2.4500868320465 / seconds
Query Executed:select id FROM `mi` where city='Stronach' && SIC_code='5461'DB:business_master_new
loadtime:2.4504849910736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strongs' limit 1
loadtime:2.4505379199982 / seconds
Query Executed:select id FROM `mi` where city='Strongs' && SIC_code='5461'DB:business_master_new
loadtime:2.4509558677673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:2.4511408805847 / seconds
Query Executed:select id FROM `mi` where city='Sturgis' && SIC_code='5461'DB:business_master_new
loadtime:2.4561879634857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:2.4562427997589 / seconds
Query Executed:select id FROM `mi` where city='Sumner' && SIC_code='5461'DB:business_master_new
loadtime:2.4570598602295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunfield' limit 1
loadtime:2.4571158885956 / seconds
Query Executed:select id FROM `mi` where city='Sunfield' && SIC_code='5461'DB:business_master_new
loadtime:2.4583189487457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suttons Bay' limit 1
loadtime:2.4583728313446 / seconds
Query Executed:select id FROM `mi` where city='Suttons Bay' && SIC_code='5461'DB:business_master_new
loadtime:2.4626948833466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swartz Creek' limit 1
loadtime:2.4627637863159 / seconds
Query Executed:select id FROM `mi` where city='Swartz Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.4698739051819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvan Lake' limit 1
loadtime:2.4699289798737 / seconds
Query Executed:select id FROM `mi` where city='Sylvan Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.4703319072723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tawas City' limit 1
loadtime:2.4703838825226 / seconds
Query Executed:select id FROM `mi` where city='Tawas City' && SIC_code='5461'DB:business_master_new
loadtime:2.4745287895203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:2.4745810031891 / seconds
Query Executed:select id FROM `mi` where city='Taylor' && SIC_code='5461'DB:business_master_new
loadtime:2.4834439754486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tecumseh' limit 1
loadtime:2.4834969043732 / seconds
Query Executed:select id FROM `mi` where city='Tecumseh' && SIC_code='5461'DB:business_master_new
loadtime:2.4907310009003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tekonsha' limit 1
loadtime:2.4907989501953 / seconds
Query Executed:select id FROM `mi` where city='Tekonsha' && SIC_code='5461'DB:business_master_new
loadtime:2.4923329353333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperance' limit 1
loadtime:2.4924108982086 / seconds
Query Executed:select id FROM `mi` where city='Temperance' && SIC_code='5461'DB:business_master_new
loadtime:2.4990179538727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompsonville' limit 1
loadtime:2.4990978240967 / seconds
Query Executed:select id FROM `mi` where city='Thompsonville' && SIC_code='5461'DB:business_master_new
loadtime:2.500097990036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Oaks' limit 1
loadtime:2.5001618862152 / seconds
Query Executed:select id FROM `mi` where city='Three Oaks' && SIC_code='5461'DB:business_master_new
loadtime:2.502769947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.5028579235077 / seconds
Query Executed:select id FROM `mi` where city='Three Rivers' && SIC_code='5461'DB:business_master_new
loadtime:2.5068898200989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:2.5069539546967 / seconds
Query Executed:select id FROM `mi` where city='Tipton' && SIC_code='5461'DB:business_master_new
loadtime:2.5081698894501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toivola' limit 1
loadtime:2.508232831955 / seconds
Query Executed:select id FROM `mi` where city='Toivola' && SIC_code='5461'DB:business_master_new
loadtime:2.5088608264923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topinabee' limit 1
loadtime:2.5089228153229 / seconds
Query Executed:select id FROM `mi` where city='Topinabee' && SIC_code='5461'DB:business_master_new
loadtime:2.5094428062439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tower' limit 1
loadtime:2.5095047950745 / seconds
Query Executed:select id FROM `mi` where city='Tower' && SIC_code='5461'DB:business_master_new
loadtime:2.5100259780884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traunik' limit 1
loadtime:2.5100879669189 / seconds
Query Executed:select id FROM `mi` where city='Traunik' && SIC_code='5461'DB:business_master_new
loadtime:2.5104818344116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traverse City' limit 1
loadtime:2.5105438232422 / seconds
Query Executed:select id FROM `mi` where city='Traverse City' && SIC_code='5461'DB:business_master_new
loadtime:2.5182268619537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenary' limit 1
loadtime:2.5183248519897 / seconds
Query Executed:select id FROM `mi` where city='Trenary' && SIC_code='5461'DB:business_master_new
loadtime:2.5191948413849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:2.5192739963531 / seconds
Query Executed:select id FROM `mi` where city='Trenton' && SIC_code='5461'DB:business_master_new
loadtime:2.5259158611298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Creek' limit 1
loadtime:2.5259809494019 / seconds
Query Executed:select id FROM `mi` where city='Trout Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.5265128612518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Lake' limit 1
loadtime:2.5265758037567 / seconds
Query Executed:select id FROM `mi` where city='Trout Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.527224779129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:2.5272870063782 / seconds
Query Executed:select id FROM `mi` where city='Troy' && SIC_code='5461'DB:business_master_new
loadtime:2.5346279144287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trufant' limit 1
loadtime:2.5347328186035 / seconds
Query Executed:select id FROM `mi` where city='Trufant' && SIC_code='5461'DB:business_master_new
loadtime:2.535532951355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turner' limit 1
loadtime:2.5355968475342 / seconds
Query Executed:select id FROM `mi` where city='Turner' && SIC_code='5461'DB:business_master_new
loadtime:2.5363099575043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuscola' limit 1
loadtime:2.5363719463348 / seconds
Query Executed:select id FROM `mi` where city='Tuscola' && SIC_code='5461'DB:business_master_new
loadtime:2.5367708206177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tustin' limit 1
loadtime:2.5368409156799 / seconds
Query Executed:select id FROM `mi` where city='Tustin' && SIC_code='5461'DB:business_master_new
loadtime:2.5379598140717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lake' limit 1
loadtime:2.5380229949951 / seconds
Query Executed:select id FROM `mi` where city='Twin Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.5411629676819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twining' limit 1
loadtime:2.5412259101868 / seconds
Query Executed:select id FROM `mi` where city='Twining' && SIC_code='5461'DB:business_master_new
loadtime:2.5420918464661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ubly' limit 1
loadtime:2.5421478748322 / seconds
Query Executed:select id FROM `mi` where city='Ubly' && SIC_code='5461'DB:business_master_new
loadtime:2.5439178943634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:2.5439729690552 / seconds
Query Executed:select id FROM `mi` where city='Union' && SIC_code='5461'DB:business_master_new
loadtime:2.5451288223267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union City' limit 1
loadtime:2.5451829433441 / seconds
Query Executed:select id FROM `mi` where city='Union City' && SIC_code='5461'DB:business_master_new
loadtime:2.5473299026489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Lake' limit 1
loadtime:2.5473849773407 / seconds
Query Executed:select id FROM `mi` where city='Union Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.5482499599457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Pier' limit 1
loadtime:2.5483038425446 / seconds
Query Executed:select id FROM `mi` where city='Union Pier' && SIC_code='5461'DB:business_master_new
loadtime:2.5493738651276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:2.5494430065155 / seconds
Query Executed:select id FROM `mi` where city='Unionville' && SIC_code='5461'DB:business_master_new
loadtime:2.5508389472961 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Center' limit 1
loadtime:2.5508959293365 / seconds
Query Executed:select id FROM `mi` where city='University Center' && SIC_code='5461'DB:business_master_new
loadtime:2.5513157844543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:2.5513679981232 / seconds
Query Executed:select id FROM `mi` where city='Utica' && SIC_code='5461'DB:business_master_new
loadtime:2.5592319965363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandalia' limit 1
loadtime:2.5593149662018 / seconds
Query Executed:select id FROM `mi` where city='Vandalia' && SIC_code='5461'DB:business_master_new
loadtime:2.5602538585663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderbilt' limit 1
loadtime:2.560320854187 / seconds
Query Executed:select id FROM `mi` where city='Vanderbilt' && SIC_code='5461'DB:business_master_new
loadtime:2.5610239505768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vassar' limit 1
loadtime:2.56107878685 / seconds
Query Executed:select id FROM `mi` where city='Vassar' && SIC_code='5461'DB:business_master_new
loadtime:2.5653219223022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermontville' limit 1
loadtime:2.5653758049011 / seconds
Query Executed:select id FROM `mi` where city='Vermontville' && SIC_code='5461'DB:business_master_new
loadtime:2.5668458938599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:2.5668997764587 / seconds
Query Executed:select id FROM `mi` where city='Vernon' && SIC_code='5461'DB:business_master_new
loadtime:2.5676608085632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vestaburg' limit 1
loadtime:2.5677168369293 / seconds
Query Executed:select id FROM `mi` where city='Vestaburg' && SIC_code='5461'DB:business_master_new
loadtime:2.5690588951111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:2.5691118240356 / seconds
Query Executed:select id FROM `mi` where city='Vicksburg' && SIC_code='5461'DB:business_master_new
loadtime:2.5738418102264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vulcan' limit 1
loadtime:2.5738978385925 / seconds
Query Executed:select id FROM `mi` where city='Vulcan' && SIC_code='5461'DB:business_master_new
loadtime:2.5747609138489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.5748147964478 / seconds
Query Executed:select id FROM `mi` where city='Wakefield' && SIC_code='5461'DB:business_master_new
loadtime:2.5762929916382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldron' limit 1
loadtime:2.5763599872589 / seconds
Query Executed:select id FROM `mi` where city='Waldron' && SIC_code='5461'DB:business_master_new
loadtime:2.5773549079895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.5774099826813 / seconds
Query Executed:select id FROM `mi` where city='Wales' && SIC_code='5461'DB:business_master_new
loadtime:2.5778529644012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:2.5779068470001 / seconds
Query Executed:select id FROM `mi` where city='Walhalla' && SIC_code='5461'DB:business_master_new
loadtime:2.5784728527069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerville' limit 1
loadtime:2.5785307884216 / seconds
Query Executed:select id FROM `mi` where city='Walkerville' && SIC_code='5461'DB:business_master_new
loadtime:2.5794990062714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:2.5795528888702 / seconds
Query Executed:select id FROM `mi` where city='Wallace' && SIC_code='5461'DB:business_master_new
loadtime:2.580353975296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walled Lake' limit 1
loadtime:2.5804100036621 / seconds
Query Executed:select id FROM `mi` where city='Walled Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.589094877243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walloon Lake' limit 1
loadtime:2.5891637802124 / seconds
Query Executed:select id FROM `mi` where city='Walloon Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.5900058746338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.5900599956512 / seconds
Query Executed:select id FROM `mi` where city='Warren' && SIC_code='5461'DB:business_master_new
loadtime:2.5974578857422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.5975477695465 / seconds
Query Executed:select id FROM `mi` where city='Washington' && SIC_code='5461'DB:business_master_new
loadtime:2.6049389839172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:2.6050078868866 / seconds
Query Executed:select id FROM `mi` where city='Waterford' && SIC_code='5461'DB:business_master_new
loadtime:2.6123588085175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waters' limit 1
loadtime:2.6124379634857 / seconds
Query Executed:select id FROM `mi` where city='Waters' && SIC_code='5461'DB:business_master_new
loadtime:2.6129739284515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watersmeet' limit 1
loadtime:2.6130299568176 / seconds
Query Executed:select id FROM `mi` where city='Watersmeet' && SIC_code='5461'DB:business_master_new
loadtime:2.6140909194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watervliet' limit 1
loadtime:2.6141438484192 / seconds
Query Executed:select id FROM `mi` where city='Watervliet' && SIC_code='5461'DB:business_master_new
loadtime:2.6170918941498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watton' limit 1
loadtime:2.6171598434448 / seconds
Query Executed:select id FROM `mi` where city='Watton' && SIC_code='5461'DB:business_master_new
loadtime:2.6176238059998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.6176807880402 / seconds
Query Executed:select id FROM `mi` where city='Wayland' && SIC_code='5461'DB:business_master_new
loadtime:2.6229507923126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:2.6230039596558 / seconds
Query Executed:select id FROM `mi` where city='Wayne' && SIC_code='5461'DB:business_master_new
loadtime:2.6260387897491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webberville' limit 1
loadtime:2.6260998249054 / seconds
Query Executed:select id FROM `mi` where city='Webberville' && SIC_code='5461'DB:business_master_new
loadtime:2.6283679008484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weidman' limit 1
loadtime:2.6284229755402 / seconds
Query Executed:select id FROM `mi` where city='Weidman' && SIC_code='5461'DB:business_master_new
loadtime:2.6301348209381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:2.6301879882812 / seconds
Query Executed:select id FROM `mi` where city='Wells' && SIC_code='5461'DB:business_master_new
loadtime:2.6308178901672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellston' limit 1
loadtime:2.6308929920197 / seconds
Query Executed:select id FROM `mi` where city='Wellston' && SIC_code='5461'DB:business_master_new
loadtime:2.6322419643402 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bloomfield' limit 1
loadtime:2.6322958469391 / seconds
Query Executed:select id FROM `mi` where city='West Bloomfield' && SIC_code='5461'DB:business_master_new
loadtime:2.6396868228912 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:2.6397638320923 / seconds
Query Executed:select id FROM `mi` where city='West Branch' && SIC_code='5461'DB:business_master_new
loadtime:2.648185968399 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Olive' limit 1
loadtime:2.6482598781586 / seconds
Query Executed:select id FROM `mi` where city='West Olive' && SIC_code='5461'DB:business_master_new
loadtime:2.6513929367065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westland' limit 1
loadtime:2.651458978653 / seconds
Query Executed:select id FROM `mi` where city='Westland' && SIC_code='5461'DB:business_master_new
loadtime:2.6628789901733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.6629369258881 / seconds
Query Executed:select id FROM `mi` where city='Weston' && SIC_code='5461'DB:business_master_new
loadtime:2.6634738445282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:2.6635267734528 / seconds
Query Executed:select id FROM `mi` where city='Westphalia' && SIC_code='5461'DB:business_master_new
loadtime:2.6644718647003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:2.6645259857178 / seconds
Query Executed:select id FROM `mi` where city='Wetmore' && SIC_code='5461'DB:business_master_new
loadtime:2.6653578281403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:2.6654269695282 / seconds
Query Executed:select id FROM `mi` where city='Wheeler' && SIC_code='5461'DB:business_master_new
loadtime:2.6662518978119 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Cloud' limit 1
loadtime:2.6663057804108 / seconds
Query Executed:select id FROM `mi` where city='White Cloud' && SIC_code='5461'DB:business_master_new
loadtime:2.6697177886963 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:2.6697859764099 / seconds
Query Executed:select id FROM `mi` where city='White Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.6789479255676 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pigeon' limit 1
loadtime:2.6790199279785 / seconds
Query Executed:select id FROM `mi` where city='White Pigeon' && SIC_code='5461'DB:business_master_new
loadtime:2.680478811264 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pine' limit 1
loadtime:2.6805338859558 / seconds
Query Executed:select id FROM `mi` where city='White Pine' && SIC_code='5461'DB:business_master_new
loadtime:2.6810247898102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehall' limit 1
loadtime:2.6810779571533 / seconds
Query Executed:select id FROM `mi` where city='Whitehall' && SIC_code='5461'DB:business_master_new
loadtime:2.686126947403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmore Lake' limit 1
loadtime:2.686194896698 / seconds
Query Executed:select id FROM `mi` where city='Whitmore Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.6889898777008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittaker' limit 1
loadtime:2.6890568733215 / seconds
Query Executed:select id FROM `mi` where city='Whittaker' && SIC_code='5461'DB:business_master_new
loadtime:2.689505815506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:2.6895589828491 / seconds
Query Executed:select id FROM `mi` where city='Whittemore' && SIC_code='5461'DB:business_master_new
loadtime:2.690780878067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.6908428668976 / seconds
Query Executed:select id FROM `mi` where city='Williamsburg' && SIC_code='5461'DB:business_master_new
loadtime:2.6950287818909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:2.6950829029083 / seconds
Query Executed:select id FROM `mi` where city='Williamston' && SIC_code='5461'DB:business_master_new
loadtime:2.7016098499298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:2.7016627788544 / seconds
Query Executed:select id FROM `mi` where city='Willis' && SIC_code='5461'DB:business_master_new
loadtime:2.7024757862091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:2.7025299072266 / seconds
Query Executed:select id FROM `mi` where city='Wilson' && SIC_code='5461'DB:business_master_new
loadtime:2.7032427787781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winn' limit 1
loadtime:2.7032959461212 / seconds
Query Executed:select id FROM `mi` where city='Winn' && SIC_code='5461'DB:business_master_new
loadtime:2.7038798332214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wixom' limit 1
loadtime:2.7039339542389 / seconds
Query Executed:select id FROM `mi` where city='Wixom' && SIC_code='5461'DB:business_master_new
loadtime:2.7130978107452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine' limit 1
loadtime:2.7131669521332 / seconds
Query Executed:select id FROM `mi` where city='Wolverine' && SIC_code='5461'DB:business_master_new
loadtime:2.7147388458252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine Lake' limit 1
loadtime:2.7148079872131 / seconds
Query Executed:select id FROM `mi` where city='Wolverine Lake' && SIC_code='5461'DB:business_master_new
loadtime:2.7152438163757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:2.7152979373932 / seconds
Query Executed:select id FROM `mi` where city='Woodland' && SIC_code='5461'DB:business_master_new
loadtime:2.716285943985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyandotte' limit 1
loadtime:2.7163388729095 / seconds
Query Executed:select id FROM `mi` where city='Wyandotte' && SIC_code='5461'DB:business_master_new
loadtime:2.7214729785919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:2.7215268611908 / seconds
Query Executed:select id FROM `mi` where city='Wyoming' && SIC_code='5461'DB:business_master_new
loadtime:2.7292468547821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:2.7293198108673 / seconds
Query Executed:select id FROM `mi` where city='Yale' && SIC_code='5461'DB:business_master_new
loadtime:2.7320728302002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ypsilanti' limit 1
loadtime:2.7321407794952 / seconds
Query Executed:select id FROM `mi` where city='Ypsilanti' && SIC_code='5461'DB:business_master_new
loadtime:2.7460827827454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zeeland' limit 1
loadtime:2.7461388111115 / seconds
Query Executed:select id FROM `mi` where city='Zeeland' && SIC_code='5461'DB:business_master_new
loadtime:2.756199836731 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.7563610076904 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.7569229602814 / seconds
Operation template executed (chunk cache operation)
loadtime:2.7570788860321 / seconds
template override:Default
loadtime:2.757120847702 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:2.7588198184967 / seconds
Template Constructed, Array Rows:49
loadtime:2.7593579292297 / seconds
TOTAL EXECUTION TIME: 2.75891
loadtime:2.7619018554688 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => retail-bakeries [stateURLid] => michigan )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:2.7619137763977
TOTAL KEY ARRAYS: 69