Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.6041946411133E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017530918121338 / seconds
host not found setting manual db connection
loadtime:0.0094931125640869 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097379684448242 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099329948425293 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.009998083114624 / seconds
zipcode:
loadtime:0.010025978088379 / seconds
Query Executed:select * from search_referrer where page_hash='a860c7ae857fffde29d6fc017366109f' limit 10 DB:ezrox_toadli
loadtime:0.010272979736328 / seconds
Operation header executed (non global)
loadtime:0.010304927825928 / seconds
Operation leaderboard executed (non global)
loadtime:0.010355949401855 / seconds
Operation square executed (non global)
loadtime:0.010385990142822 / seconds
Operation square_bottom executed (non global)
loadtime:0.010412931442261 / seconds
Operation smallsquare executed (non global)
loadtime:0.010438919067383 / seconds
Operation headeradright executed (non global)
loadtime:0.010464906692505 / seconds
Operation google_analytics executed (non global)
loadtime:0.010489940643311 / seconds
Operation topstories executed (non global)
loadtime:0.010514974594116 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010541915893555 / seconds
Operation memberbuscount executed (non global)
loadtime:0.01056694984436 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010828971862793 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011027097702026 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011068105697632 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011127948760986 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011177062988281 / seconds
Template key: archive_menu pushed
loadtime:0.011184930801392 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011198997497559 / seconds
Template key: get_gravatar pushed
loadtime:0.011205911636353 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011214971542358 / seconds
*10)-10)+1 | start:0
loadtime:0.011255025863647 / seconds
Query loaded from cache:select * from categories where cat_URLid='auto-and-home-supply-stores'
loadtime:0.011296987533569 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.011332035064697 / seconds
DB connected to localhost business_master_new
loadtime:0.011598110198975 / seconds
Query Executed:select * from `mi_catmap` where sic='5531' order by city ascDB:business_master_new
loadtime:0.04896092414856 / seconds
Query stored in cache : _QUERY_www.toadli.com75ae0d8a74f70d2c4c6586bf903228e3
loadtime:0.052737951278687 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='michigan'
loadtime:0.052812099456787 / seconds
Query Executed:select sum(totalcount) as totalsum from `mi_catmap` where sic='5531'DB:business_master_new
loadtime:0.057646036148071 / seconds
Query stored in cache : _QUERY_www.toadli.comf95bf74a02c5e5b79af1e98488ddd031
loadtime:0.057687997817993 / seconds
966 / 11
loadtime:0.057751893997192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acme' limit 1
loadtime:0.057820081710815 / seconds
Query Executed:select id FROM `mi` where city='Acme' && SIC_code='5531'DB:business_master_new
loadtime:0.058851003646851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ada' limit 1
loadtime:0.058923959732056 / seconds
Query Executed:select id FROM `mi` where city='Ada' && SIC_code='5531'DB:business_master_new
loadtime:0.066838026046753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison' limit 1
loadtime:0.066927909851074 / seconds
Query Executed:select id FROM `mi` where city='Addison' && SIC_code='5531'DB:business_master_new
loadtime:0.068716049194336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison Twp' limit 1
loadtime:0.068783044815063 / seconds
Query Executed:select id FROM `mi` where city='Addison Twp' && SIC_code='5531'DB:business_master_new
loadtime:0.069262981414795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adrian' limit 1
loadtime:0.069323062896729 / seconds
Query Executed:select id FROM `mi` where city='Adrian' && SIC_code='5531'DB:business_master_new
loadtime:0.087728023529053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.08784008026123 / seconds
Query Executed:select id FROM `mi` where city='Afton' && SIC_code='5531'DB:business_master_new
loadtime:0.088540077209473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahmeek' limit 1
loadtime:0.088603019714355 / seconds
Query Executed:select id FROM `mi` where city='Ahmeek' && SIC_code='5531'DB:business_master_new
loadtime:0.089126110076904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.089186906814575 / seconds
Query Executed:select id FROM `mi` where city='Akron' && SIC_code='5531'DB:business_master_new
loadtime:0.090049028396606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alanson' limit 1
loadtime:0.090111017227173 / seconds
Query Executed:select id FROM `mi` where city='Alanson' && SIC_code='5531'DB:business_master_new
loadtime:0.092621088027954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alba' limit 1
loadtime:0.092698097229004 / seconds
Query Executed:select id FROM `mi` where city='Alba' && SIC_code='5531'DB:business_master_new
loadtime:0.093341112136841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.093401908874512 / seconds
Query Executed:select id FROM `mi` where city='Albion' && SIC_code='5531'DB:business_master_new
loadtime:0.10017991065979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.100261926651 / seconds
Query Executed:select id FROM `mi` where city='Alden' && SIC_code='5531'DB:business_master_new
loadtime:0.1012909412384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alger' limit 1
loadtime:0.10135293006897 / seconds
Query Executed:select id FROM `mi` where city='Alger' && SIC_code='5531'DB:business_master_new
loadtime:0.10252809524536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algonac' limit 1
loadtime:0.10258793830872 / seconds
Query Executed:select id FROM `mi` where city='Algonac' && SIC_code='5531'DB:business_master_new
loadtime:0.1084520816803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allegan' limit 1
loadtime:0.1085319519043 / seconds
Query Executed:select id FROM `mi` where city='Allegan' && SIC_code='5531'DB:business_master_new
loadtime:0.11775898933411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.11785101890564 / seconds
Query Executed:select id FROM `mi` where city='Allen' && SIC_code='5531'DB:business_master_new
loadtime:0.11885595321655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen Park' limit 1
loadtime:0.11894392967224 / seconds
Query Executed:select id FROM `mi` where city='Allen Park' && SIC_code='5531'DB:business_master_new
loadtime:0.12456107139587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.12463903427124 / seconds
Query Executed:select id FROM `mi` where city='Allendale' && SIC_code='5531'DB:business_master_new
loadtime:0.1297869682312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenton' limit 1
loadtime:0.12986612319946 / seconds
Query Executed:select id FROM `mi` where city='Allenton' && SIC_code='5531'DB:business_master_new
loadtime:0.13112902641296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allouez' limit 1
loadtime:0.13120603561401 / seconds
Query Executed:select id FROM `mi` where city='Allouez' && SIC_code='5531'DB:business_master_new
loadtime:0.13175296783447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.13181710243225 / seconds
Query Executed:select id FROM `mi` where city='Alma' && SIC_code='5531'DB:business_master_new
loadtime:0.13939809799194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almont' limit 1
loadtime:0.1394829750061 / seconds
Query Executed:select id FROM `mi` where city='Almont' && SIC_code='5531'DB:business_master_new
loadtime:0.14216208457947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.14223909378052 / seconds
Query Executed:select id FROM `mi` where city='Alpena' && SIC_code='5531'DB:business_master_new
loadtime:0.15695595741272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.15704298019409 / seconds
Query Executed:select id FROM `mi` where city='Alpha' && SIC_code='5531'DB:business_master_new
loadtime:0.15755796432495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alto' limit 1
loadtime:0.15762090682983 / seconds
Query Executed:select id FROM `mi` where city='Alto' && SIC_code='5531'DB:business_master_new
loadtime:0.16018509864807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amasa' limit 1
loadtime:0.16024708747864 / seconds
Query Executed:select id FROM `mi` where city='Amasa' && SIC_code='5531'DB:business_master_new
loadtime:0.16075491905212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anchorville' limit 1
loadtime:0.16081690788269 / seconds
Query Executed:select id FROM `mi` where city='Anchorville' && SIC_code='5531'DB:business_master_new
loadtime:0.16133999824524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ann Arbor' limit 1
loadtime:0.16140007972717 / seconds
Query Executed:select id FROM `mi` where city='Ann Arbor' && SIC_code='5531'DB:business_master_new
loadtime:0.20308399200439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Applegate' limit 1
loadtime:0.20320105552673 / seconds
Query Executed:select id FROM `mi` where city='Applegate' && SIC_code='5531'DB:business_master_new
loadtime:0.20413899421692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.20420098304749 / seconds
Query Executed:select id FROM `mi` where city='Arcadia' && SIC_code='5531'DB:business_master_new
loadtime:0.20516300201416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.20523810386658 / seconds
Query Executed:select id FROM `mi` where city='Argyle' && SIC_code='5531'DB:business_master_new
loadtime:0.20567893981934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armada' limit 1
loadtime:0.20574712753296 / seconds
Query Executed:select id FROM `mi` where city='Armada' && SIC_code='5531'DB:business_master_new
loadtime:0.20856404304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnold' limit 1
loadtime:0.20863890647888 / seconds
Query Executed:select id FROM `mi` where city='Arnold' && SIC_code='5531'DB:business_master_new
loadtime:0.2091429233551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley' limit 1
loadtime:0.20921301841736 / seconds
Query Executed:select id FROM `mi` where city='Ashley' && SIC_code='5531'DB:business_master_new
loadtime:0.21020698547363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.21026802062988 / seconds
Query Executed:select id FROM `mi` where city='Athens' && SIC_code='5531'DB:business_master_new
loadtime:0.21158289909363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlanta' limit 1
loadtime:0.21165704727173 / seconds
Query Executed:select id FROM `mi` where city='Atlanta' && SIC_code='5531'DB:business_master_new
loadtime:0.21282005310059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Mine' limit 1
loadtime:0.21289491653442 / seconds
Query Executed:select id FROM `mi` where city='Atlantic Mine' && SIC_code='5531'DB:business_master_new
loadtime:0.21376204490662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlas' limit 1
loadtime:0.2138249874115 / seconds
Query Executed:select id FROM `mi` where city='Atlas' && SIC_code='5531'DB:business_master_new
loadtime:0.21438097953796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attica' limit 1
loadtime:0.21444201469421 / seconds
Query Executed:select id FROM `mi` where city='Attica' && SIC_code='5531'DB:business_master_new
loadtime:0.21615290641785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Gres' limit 1
loadtime:0.2162139415741 / seconds
Query Executed:select id FROM `mi` where city='Au Gres' && SIC_code='5531'DB:business_master_new
loadtime:0.2183690071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Au Train' limit 1
loadtime:0.21844506263733 / seconds
Query Executed:select id FROM `mi` where city='Au Train' && SIC_code='5531'DB:business_master_new
loadtime:0.21921491622925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.2192759513855 / seconds
Query Executed:select id FROM `mi` where city='Auburn' && SIC_code='5531'DB:business_master_new
loadtime:0.22231197357178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn Hills' limit 1
loadtime:0.22238612174988 / seconds
Query Executed:select id FROM `mi` where city='Auburn Hills' && SIC_code='5531'DB:business_master_new
loadtime:0.23909711837769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.23918795585632 / seconds
Query Executed:select id FROM `mi` where city='Augusta' && SIC_code='5531'DB:business_master_new
loadtime:0.24132394790649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.24138689041138 / seconds
Query Executed:select id FROM `mi` where city='Avoca' && SIC_code='5531'DB:business_master_new
loadtime:0.24287605285645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Azalia' limit 1
loadtime:0.24294805526733 / seconds
Query Executed:select id FROM `mi` where city='Azalia' && SIC_code='5531'DB:business_master_new
loadtime:0.24338006973267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bad Axe' limit 1
loadtime:0.24344611167908 / seconds
Query Executed:select id FROM `mi` where city='Bad Axe' && SIC_code='5531'DB:business_master_new
loadtime:0.25111603736877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.25119805335999 / seconds
Query Executed:select id FROM `mi` where city='Bailey' && SIC_code='5531'DB:business_master_new
loadtime:0.25192403793335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.25198602676392 / seconds
Query Executed:select id FROM `mi` where city='Baldwin' && SIC_code='5531'DB:business_master_new
loadtime:0.25501203536987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.25508809089661 / seconds
Query Executed:select id FROM `mi` where city='Bancroft' && SIC_code='5531'DB:business_master_new
loadtime:0.25624895095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bangor' limit 1
loadtime:0.2563099861145 / seconds
Query Executed:select id FROM `mi` where city='Bangor' && SIC_code='5531'DB:business_master_new
loadtime:0.25914907455444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bannister' limit 1
loadtime:0.25922608375549 / seconds
Query Executed:select id FROM `mi` where city='Bannister' && SIC_code='5531'DB:business_master_new
loadtime:0.25998711585999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baraga' limit 1
loadtime:0.26004910469055 / seconds
Query Executed:select id FROM `mi` where city='Baraga' && SIC_code='5531'DB:business_master_new
loadtime:0.26182103157043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barbeau' limit 1
loadtime:0.26190900802612 / seconds
Query Executed:select id FROM `mi` where city='Barbeau' && SIC_code='5531'DB:business_master_new
loadtime:0.26251411437988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bark River' limit 1
loadtime:0.26257610321045 / seconds
Query Executed:select id FROM `mi` where city='Bark River' && SIC_code='5531'DB:business_master_new
loadtime:0.26394891738892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baroda' limit 1
loadtime:0.26400995254517 / seconds
Query Executed:select id FROM `mi` where city='Baroda' && SIC_code='5531'DB:business_master_new
loadtime:0.26588892936707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barryton' limit 1
loadtime:0.26596093177795 / seconds
Query Executed:select id FROM `mi` where city='Barryton' && SIC_code='5531'DB:business_master_new
loadtime:0.26725196838379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barton City' limit 1
loadtime:0.26732802391052 / seconds
Query Executed:select id FROM `mi` where city='Barton City' && SIC_code='5531'DB:business_master_new
loadtime:0.26797699928284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.26803994178772 / seconds
Query Executed:select id FROM `mi` where city='Bath' && SIC_code='5531'DB:business_master_new
loadtime:0.27005195617676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.27012705802917 / seconds
Query Executed:select id FROM `mi` where city='Battle Creek' && SIC_code='5531'DB:business_master_new
loadtime:0.30918312072754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay City' limit 1
loadtime:0.30931806564331 / seconds
Query Executed:select id FROM `mi` where city='Bay City' && SIC_code='5531'DB:business_master_new
loadtime:0.34167504310608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Port' limit 1
loadtime:0.34180498123169 / seconds
Query Executed:select id FROM `mi` where city='Bay Port' && SIC_code='5531'DB:business_master_new
loadtime:0.34286499023438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Shore' limit 1
loadtime:0.34294390678406 / seconds
Query Executed:select id FROM `mi` where city='Bay Shore' && SIC_code='5531'DB:business_master_new
loadtime:0.34341597557068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay View' limit 1
loadtime:0.34347891807556 / seconds
Query Executed:select id FROM `mi` where city='Bay View' && SIC_code='5531'DB:business_master_new
loadtime:0.34392499923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Lake' limit 1
loadtime:0.34398603439331 / seconds
Query Executed:select id FROM `mi` where city='Bear Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.34583711624146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver Island' limit 1
loadtime:0.34592509269714 / seconds
Query Executed:select id FROM `mi` where city='Beaver Island' && SIC_code='5531'DB:business_master_new
loadtime:0.34740400314331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverton' limit 1
loadtime:0.34747409820557 / seconds
Query Executed:select id FROM `mi` where city='Beaverton' && SIC_code='5531'DB:business_master_new
loadtime:0.35065507888794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.35071611404419 / seconds
Query Executed:select id FROM `mi` where city='Bedford' && SIC_code='5531'DB:business_master_new
loadtime:0.35124897956848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belding' limit 1
loadtime:0.35131502151489 / seconds
Query Executed:select id FROM `mi` where city='Belding' && SIC_code='5531'DB:business_master_new
loadtime:0.35702204704285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellaire' limit 1
loadtime:0.35710406303406 / seconds
Query Executed:select id FROM `mi` where city='Bellaire' && SIC_code='5531'DB:business_master_new
loadtime:0.36217594146729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.36225509643555 / seconds
Query Executed:select id FROM `mi` where city='Belleville' && SIC_code='5531'DB:business_master_new
loadtime:0.36860990524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.36868906021118 / seconds
Query Executed:select id FROM `mi` where city='Bellevue' && SIC_code='5531'DB:business_master_new
loadtime:0.37077593803406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.37085199356079 / seconds
Query Executed:select id FROM `mi` where city='Belmont' && SIC_code='5531'DB:business_master_new
loadtime:0.37416911125183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentley' limit 1
loadtime:0.3742311000824 / seconds
Query Executed:select id FROM `mi` where city='Bentley' && SIC_code='5531'DB:business_master_new
loadtime:0.37484693527222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton Harbor' limit 1
loadtime:0.37491893768311 / seconds
Query Executed:select id FROM `mi` where city='Benton Harbor' && SIC_code='5531'DB:business_master_new
loadtime:0.39263606071472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benzonia' limit 1
loadtime:0.39273309707642 / seconds
Query Executed:select id FROM `mi` where city='Benzonia' && SIC_code='5531'DB:business_master_new
loadtime:0.3946430683136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergland' limit 1
loadtime:0.39472198486328 / seconds
Query Executed:select id FROM `mi` where city='Bergland' && SIC_code='5531'DB:business_master_new
loadtime:0.39527893066406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.39534211158752 / seconds
Query Executed:select id FROM `mi` where city='Berkley' && SIC_code='5531'DB:business_master_new
loadtime:0.40400910377502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.40408897399902 / seconds
Query Executed:select id FROM `mi` where city='Berlin' && SIC_code='5531'DB:business_master_new
loadtime:0.40452790260315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Center' limit 1
loadtime:0.40458989143372 / seconds
Query Executed:select id FROM `mi` where city='Berrien Center' && SIC_code='5531'DB:business_master_new
loadtime:0.40562701225281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berrien Springs' limit 1
loadtime:0.40568804740906 / seconds
Query Executed:select id FROM `mi` where city='Berrien Springs' && SIC_code='5531'DB:business_master_new
loadtime:0.41236090660095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berville' limit 1
loadtime:0.41244006156921 / seconds
Query Executed:select id FROM `mi` where city='Berville' && SIC_code='5531'DB:business_master_new
loadtime:0.41290497779846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer' limit 1
loadtime:0.41296792030334 / seconds
Query Executed:select id FROM `mi` where city='Bessemer' && SIC_code='5531'DB:business_master_new
loadtime:0.41499590873718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.41505694389343 / seconds
Query Executed:select id FROM `mi` where city='Beulah' && SIC_code='5531'DB:business_master_new
loadtime:0.41801500320435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly Hills' limit 1
loadtime:0.41809010505676 / seconds
Query Executed:select id FROM `mi` where city='Beverly Hills' && SIC_code='5531'DB:business_master_new
loadtime:0.41875290870667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Bay' limit 1
loadtime:0.41881799697876 / seconds
Query Executed:select id FROM `mi` where city='Big Bay' && SIC_code='5531'DB:business_master_new
loadtime:0.41951894760132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rapids' limit 1
loadtime:0.41957998275757 / seconds
Query Executed:select id FROM `mi` where city='Big Rapids' && SIC_code='5531'DB:business_master_new
loadtime:0.43006110191345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham Farms' limit 1
loadtime:0.43014812469482 / seconds
Query Executed:select id FROM `mi` where city='Bingham Farms' && SIC_code='5531'DB:business_master_new
loadtime:0.43061304092407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birch Run' limit 1
loadtime:0.43067598342896 / seconds
Query Executed:select id FROM `mi` where city='Birch Run' && SIC_code='5531'DB:business_master_new
loadtime:0.43637204170227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.43645405769348 / seconds
Query Executed:select id FROM `mi` where city='Birmingham' && SIC_code='5531'DB:business_master_new
loadtime:0.46184706687927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bitely' limit 1
loadtime:0.46194791793823 / seconds
Query Executed:select id FROM `mi` where city='Bitely' && SIC_code='5531'DB:business_master_new
loadtime:0.46283292770386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black River' limit 1
loadtime:0.46291995048523 / seconds
Query Executed:select id FROM `mi` where city='Black River' && SIC_code='5531'DB:business_master_new
loadtime:0.46348404884338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.46354603767395 / seconds
Query Executed:select id FROM `mi` where city='Blanchard' && SIC_code='5531'DB:business_master_new
loadtime:0.46496605873108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blissfield' limit 1
loadtime:0.46504402160645 / seconds
Query Executed:select id FROM `mi` where city='Blissfield' && SIC_code='5531'DB:business_master_new
loadtime:0.46832799911499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Hills' limit 1
loadtime:0.4684100151062 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Hills' && SIC_code='5531'DB:business_master_new
loadtime:0.49994707107544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield Twp' limit 1
loadtime:0.50004291534424 / seconds
Query Executed:select id FROM `mi` where city='Bloomfield Twp' && SIC_code='5531'DB:business_master_new
loadtime:0.50062799453735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingdale' limit 1
loadtime:0.50069093704224 / seconds
Query Executed:select id FROM `mi` where city='Bloomingdale' && SIC_code='5531'DB:business_master_new
loadtime:0.50210690498352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boon' limit 1
loadtime:0.50216794013977 / seconds
Query Executed:select id FROM `mi` where city='Boon' && SIC_code='5531'DB:business_master_new
loadtime:0.50281190872192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne City' limit 1
loadtime:0.50288009643555 / seconds
Query Executed:select id FROM `mi` where city='Boyne City' && SIC_code='5531'DB:business_master_new
loadtime:0.50919795036316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyne Falls' limit 1
loadtime:0.50928092002869 / seconds
Query Executed:select id FROM `mi` where city='Boyne Falls' && SIC_code='5531'DB:business_master_new
loadtime:0.5106029510498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.5106680393219 / seconds
Query Executed:select id FROM `mi` where city='Bradley' && SIC_code='5531'DB:business_master_new
loadtime:0.51115489006042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branch' limit 1
loadtime:0.51121807098389 / seconds
Query Executed:select id FROM `mi` where city='Branch' && SIC_code='5531'DB:business_master_new
loadtime:0.51208996772766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant' limit 1
loadtime:0.51215600967407 / seconds
Query Executed:select id FROM `mi` where city='Brant' && SIC_code='5531'DB:business_master_new
loadtime:0.51299905776978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breckenridge' limit 1
loadtime:0.51306009292603 / seconds
Query Executed:select id FROM `mi` where city='Breckenridge' && SIC_code='5531'DB:business_master_new
loadtime:0.51464509963989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breedsville' limit 1
loadtime:0.51472306251526 / seconds
Query Executed:select id FROM `mi` where city='Breedsville' && SIC_code='5531'DB:business_master_new
loadtime:0.51520705223083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brethren' limit 1
loadtime:0.51527094841003 / seconds
Query Executed:select id FROM `mi` where city='Brethren' && SIC_code='5531'DB:business_master_new
loadtime:0.51614809036255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.51621103286743 / seconds
Query Executed:select id FROM `mi` where city='Bridgeport' && SIC_code='5531'DB:business_master_new
loadtime:0.51866507530212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.51874494552612 / seconds
Query Executed:select id FROM `mi` where city='Bridgewater' && SIC_code='5531'DB:business_master_new
loadtime:0.51923799514771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgman' limit 1
loadtime:0.51930093765259 / seconds
Query Executed:select id FROM `mi` where city='Bridgman' && SIC_code='5531'DB:business_master_new
loadtime:0.52241706848145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.52249693870544 / seconds
Query Executed:select id FROM `mi` where city='Brighton' && SIC_code='5531'DB:business_master_new
loadtime:0.54845094680786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimley' limit 1
loadtime:0.54855895042419 / seconds
Query Executed:select id FROM `mi` where city='Brimley' && SIC_code='5531'DB:business_master_new
loadtime:0.55006098747253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.5501389503479 / seconds
Query Executed:select id FROM `mi` where city='Britton' && SIC_code='5531'DB:business_master_new
loadtime:0.55169296264648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockway' limit 1
loadtime:0.55175995826721 / seconds
Query Executed:select id FROM `mi` where city='Brockway' && SIC_code='5531'DB:business_master_new
loadtime:0.55218601226807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brohman' limit 1
loadtime:0.55224704742432 / seconds
Query Executed:select id FROM `mi` where city='Brohman' && SIC_code='5531'DB:business_master_new
loadtime:0.55279111862183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.5528519153595 / seconds
Query Executed:select id FROM `mi` where city='Bronson' && SIC_code='5531'DB:business_master_new
loadtime:0.55531191825867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.55537295341492 / seconds
Query Executed:select id FROM `mi` where city='Brooklyn' && SIC_code='5531'DB:business_master_new
loadtime:0.56133103370667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brown City' limit 1
loadtime:0.56141209602356 / seconds
Query Executed:select id FROM `mi` where city='Brown City' && SIC_code='5531'DB:business_master_new
loadtime:0.56503891944885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownstown Twp' limit 1
loadtime:0.56511807441711 / seconds
Query Executed:select id FROM `mi` where city='Brownstown Twp' && SIC_code='5531'DB:business_master_new
loadtime:0.56562089920044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.5656840801239 / seconds
Query Executed:select id FROM `mi` where city='Bruce' && SIC_code='5531'DB:business_master_new
loadtime:0.56613492965698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce Crossing' limit 1
loadtime:0.56620192527771 / seconds
Query Executed:select id FROM `mi` where city='Bruce Crossing' && SIC_code='5531'DB:business_master_new
loadtime:0.56693196296692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brutus' limit 1
loadtime:0.56699299812317 / seconds
Query Executed:select id FROM `mi` where city='Brutus' && SIC_code='5531'DB:business_master_new
loadtime:0.56789112091064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buchanan' limit 1
loadtime:0.56796407699585 / seconds
Query Executed:select id FROM `mi` where city='Buchanan' && SIC_code='5531'DB:business_master_new
loadtime:0.57361102104187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckley' limit 1
loadtime:0.57368993759155 / seconds
Query Executed:select id FROM `mi` where city='Buckley' && SIC_code='5531'DB:business_master_new
loadtime:0.5751678943634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.57524299621582 / seconds
Query Executed:select id FROM `mi` where city='Burlington' && SIC_code='5531'DB:business_master_new
loadtime:0.57624912261963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnips' limit 1
loadtime:0.57631206512451 / seconds
Query Executed:select id FROM `mi` where city='Burnips' && SIC_code='5531'DB:business_master_new
loadtime:0.57684993743896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burr Oak' limit 1
loadtime:0.57692408561707 / seconds
Query Executed:select id FROM `mi` where city='Burr Oak' && SIC_code='5531'DB:business_master_new
loadtime:0.57772493362427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:0.57779097557068 / seconds
Query Executed:select id FROM `mi` where city='Burt' && SIC_code='5531'DB:business_master_new
loadtime:0.57891607284546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt Lake' limit 1
loadtime:0.57897710800171 / seconds
Query Executed:select id FROM `mi` where city='Burt Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.57948398590088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burtchville' limit 1
loadtime:0.57954502105713 / seconds
Query Executed:select id FROM `mi` where city='Burtchville' && SIC_code='5531'DB:business_master_new
loadtime:0.58004903793335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burton' limit 1
loadtime:0.58011102676392 / seconds
Query Executed:select id FROM `mi` where city='Burton' && SIC_code='5531'DB:business_master_new
loadtime:0.59382700920105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:0.59392809867859 / seconds
Query Executed:select id FROM `mi` where city='Byron' && SIC_code='5531'DB:business_master_new
loadtime:0.59586095809937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron Center' limit 1
loadtime:0.59595108032227 / seconds
Query Executed:select id FROM `mi` where city='Byron Center' && SIC_code='5531'DB:business_master_new
loadtime:0.60470104217529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cadillac' limit 1
loadtime:0.60478591918945 / seconds
Query Executed:select id FROM `mi` where city='Cadillac' && SIC_code='5531'DB:business_master_new
loadtime:0.61816811561584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.61825799942017 / seconds
Query Executed:select id FROM `mi` where city='Caledonia' && SIC_code='5531'DB:business_master_new
loadtime:0.62635612487793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.62643599510193 / seconds
Query Executed:select id FROM `mi` where city='Calumet' && SIC_code='5531'DB:business_master_new
loadtime:0.63183093070984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.63192701339722 / seconds
Query Executed:select id FROM `mi` where city='Camden' && SIC_code='5531'DB:business_master_new
loadtime:0.63320994377136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannonsburg' limit 1
loadtime:0.6332859992981 / seconds
Query Executed:select id FROM `mi` where city='Cannonsburg' && SIC_code='5531'DB:business_master_new
loadtime:0.6338369846344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.63391709327698 / seconds
Query Executed:select id FROM `mi` where city='Canton' && SIC_code='5531'DB:business_master_new
loadtime:0.64510703086853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capac' limit 1
loadtime:0.64518308639526 / seconds
Query Executed:select id FROM `mi` where city='Capac' && SIC_code='5531'DB:business_master_new
loadtime:0.64744806289673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carleton' limit 1
loadtime:0.64752602577209 / seconds
Query Executed:select id FROM `mi` where city='Carleton' && SIC_code='5531'DB:business_master_new
loadtime:0.65104699134827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carney' limit 1
loadtime:0.65110993385315 / seconds
Query Executed:select id FROM `mi` where city='Carney' && SIC_code='5531'DB:business_master_new
loadtime:0.65185594558716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caro' limit 1
loadtime:0.65193009376526 / seconds
Query Executed:select id FROM `mi` where city='Caro' && SIC_code='5531'DB:business_master_new
loadtime:0.66034412384033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carp Lake' limit 1
loadtime:0.66042709350586 / seconds
Query Executed:select id FROM `mi` where city='Carp Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.66122794151306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.66129112243652 / seconds
Query Executed:select id FROM `mi` where city='Carrollton' && SIC_code='5531'DB:business_master_new
loadtime:0.66198706626892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson City' limit 1
loadtime:0.66204905509949 / seconds
Query Executed:select id FROM `mi` where city='Carson City' && SIC_code='5531'DB:business_master_new
loadtime:0.66445112228394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carsonville' limit 1
loadtime:0.6645290851593 / seconds
Query Executed:select id FROM `mi` where city='Carsonville' && SIC_code='5531'DB:business_master_new
loadtime:0.66609907150269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casco' limit 1
loadtime:0.66617703437805 / seconds
Query Executed:select id FROM `mi` where city='Casco' && SIC_code='5531'DB:business_master_new
loadtime:0.66779708862305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caseville' limit 1
loadtime:0.6678729057312 / seconds
Query Executed:select id FROM `mi` where city='Caseville' && SIC_code='5531'DB:business_master_new
loadtime:0.66978001594543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casnovia' limit 1
loadtime:0.66984295845032 / seconds
Query Executed:select id FROM `mi` where city='Casnovia' && SIC_code='5531'DB:business_master_new
loadtime:0.67077589035034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caspian' limit 1
loadtime:0.67083692550659 / seconds
Query Executed:select id FROM `mi` where city='Caspian' && SIC_code='5531'DB:business_master_new
loadtime:0.6720130443573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cass City' limit 1
loadtime:0.67207503318787 / seconds
Query Executed:select id FROM `mi` where city='Cass City' && SIC_code='5531'DB:business_master_new
loadtime:0.67662692070007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cassopolis' limit 1
loadtime:0.67670893669128 / seconds
Query Executed:select id FROM `mi` where city='Cassopolis' && SIC_code='5531'DB:business_master_new
loadtime:0.68163704872131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.68171691894531 / seconds
Query Executed:select id FROM `mi` where city='Cedar' && SIC_code='5531'DB:business_master_new
loadtime:0.68345808982849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Lake' limit 1
loadtime:0.68352007865906 / seconds
Query Executed:select id FROM `mi` where city='Cedar Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.68407011032104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar River' limit 1
loadtime:0.68413209915161 / seconds
Query Executed:select id FROM `mi` where city='Cedar River' && SIC_code='5531'DB:business_master_new
loadtime:0.6845691204071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Springs' limit 1
loadtime:0.68462896347046 / seconds
Query Executed:select id FROM `mi` where city='Cedar Springs' && SIC_code='5531'DB:business_master_new
loadtime:0.69103908538818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:0.69111704826355 / seconds
Query Executed:select id FROM `mi` where city='Cedarville' && SIC_code='5531'DB:business_master_new
loadtime:0.69279599189758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cement City' limit 1
loadtime:0.69287109375 / seconds
Query Executed:select id FROM `mi` where city='Cement City' && SIC_code='5531'DB:business_master_new
loadtime:0.69421410560608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Line' limit 1
loadtime:0.69428992271423 / seconds
Query Executed:select id FROM `mi` where city='Center Line' && SIC_code='5531'DB:business_master_new
loadtime:0.69931411743164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Lake' limit 1
loadtime:0.69939398765564 / seconds
Query Executed:select id FROM `mi` where city='Central Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.70143890380859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.70150208473206 / seconds
Query Executed:select id FROM `mi` where city='Centreville' && SIC_code='5531'DB:business_master_new
loadtime:0.7026059627533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ceresco' limit 1
loadtime:0.70266795158386 / seconds
Query Executed:select id FROM `mi` where city='Ceresco' && SIC_code='5531'DB:business_master_new
loadtime:0.70357990264893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Champion' limit 1
loadtime:0.70364189147949 / seconds
Query Executed:select id FROM `mi` where city='Champion' && SIC_code='5531'DB:business_master_new
loadtime:0.70461201667786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Channing' limit 1
loadtime:0.70467305183411 / seconds
Query Executed:select id FROM `mi` where city='Channing' && SIC_code='5531'DB:business_master_new
loadtime:0.70532894134521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlevoix' limit 1
loadtime:0.70540595054626 / seconds
Query Executed:select id FROM `mi` where city='Charlevoix' && SIC_code='5531'DB:business_master_new
loadtime:0.71432590484619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.71440505981445 / seconds
Query Executed:select id FROM `mi` where city='Charlotte' && SIC_code='5531'DB:business_master_new
loadtime:0.72530508041382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chase' limit 1
loadtime:0.72539305686951 / seconds
Query Executed:select id FROM `mi` where city='Chase' && SIC_code='5531'DB:business_master_new
loadtime:0.7261369228363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chassell' limit 1
loadtime:0.72620010375977 / seconds
Query Executed:select id FROM `mi` where city='Chassell' && SIC_code='5531'DB:business_master_new
loadtime:0.72759795188904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.72767901420593 / seconds
Query Executed:select id FROM `mi` where city='Chatham' && SIC_code='5531'DB:business_master_new
loadtime:0.72867798805237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheboygan' limit 1
loadtime:0.7287449836731 / seconds
Query Executed:select id FROM `mi` where city='Cheboygan' && SIC_code='5531'DB:business_master_new
loadtime:0.73896408081055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.73905205726624 / seconds
Query Executed:select id FROM `mi` where city='Chelsea' && SIC_code='5531'DB:business_master_new
loadtime:0.74384689331055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesaning' limit 1
loadtime:0.7439239025116 / seconds
Query Executed:select id FROM `mi` where city='Chesaning' && SIC_code='5531'DB:business_master_new
loadtime:0.74762201309204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.74770092964172 / seconds
Query Executed:select id FROM `mi` where city='Chesterfield' && SIC_code='5531'DB:business_master_new
loadtime:0.74854207038879 / seconds
Query loaded from cache:select * from geodata_geocity where city='China' limit 1
loadtime:0.74860405921936 / seconds
Query Executed:select id FROM `mi` where city='China' && SIC_code='5531'DB:business_master_new
loadtime:0.74904298782349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chippewa Lake' limit 1
loadtime:0.74910402297974 / seconds
Query Executed:select id FROM `mi` where city='Chippewa Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.74962997436523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Christmas' limit 1
loadtime:0.74969005584717 / seconds
Query Executed:select id FROM `mi` where city='Christmas' && SIC_code='5531'DB:business_master_new
loadtime:0.75013303756714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:0.75019407272339 / seconds
Query Executed:select id FROM `mi` where city='Clare' && SIC_code='5531'DB:business_master_new
loadtime:0.7569100856781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarklake' limit 1
loadtime:0.7569899559021 / seconds
Query Executed:select id FROM `mi` where city='Clarklake' && SIC_code='5531'DB:business_master_new
loadtime:0.75847196578979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:0.75853490829468 / seconds
Query Executed:select id FROM `mi` where city='Clarkston' && SIC_code='5531'DB:business_master_new
loadtime:0.77882695198059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.7789249420166 / seconds
Query Executed:select id FROM `mi` where city='Clarksville' && SIC_code='5531'DB:business_master_new
loadtime:0.7800829410553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clawson' limit 1
loadtime:0.78014707565308 / seconds
Query Executed:select id FROM `mi` where city='Clawson' && SIC_code='5531'DB:business_master_new
loadtime:0.78791904449463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay' limit 1
loadtime:0.78800511360168 / seconds
Query Executed:select id FROM `mi` where city='Clay' && SIC_code='5531'DB:business_master_new
loadtime:0.78849196434021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.78855490684509 / seconds
Query Executed:select id FROM `mi` where city='Clayton' && SIC_code='5531'DB:business_master_new
loadtime:0.789626121521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifford' limit 1
loadtime:0.78970098495483 / seconds
Query Executed:select id FROM `mi` where city='Clifford' && SIC_code='5531'DB:business_master_new
loadtime:0.79046511650085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:0.79052710533142 / seconds
Query Executed:select id FROM `mi` where city='Climax' && SIC_code='5531'DB:business_master_new
loadtime:0.7919340133667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.79199504852295 / seconds
Query Executed:select id FROM `mi` where city='Clinton' && SIC_code='5531'DB:business_master_new
loadtime:0.79477000236511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Township' limit 1
loadtime:0.79484701156616 / seconds
Query Executed:select id FROM `mi` where city='Clinton Township' && SIC_code='5531'DB:business_master_new
loadtime:0.83355093002319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton Twp' limit 1
loadtime:0.83367109298706 / seconds
Query Executed:select id FROM `mi` where city='Clinton Twp' && SIC_code='5531'DB:business_master_new
loadtime:0.83491706848145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.83498406410217 / seconds
Query Executed:select id FROM `mi` where city='Clio' && SIC_code='5531'DB:business_master_new
loadtime:0.84397292137146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cloverdale' limit 1
loadtime:0.84405708312988 / seconds
Query Executed:select id FROM `mi` where city='Cloverdale' && SIC_code='5531'DB:business_master_new
loadtime:0.84455108642578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:0.84461402893066 / seconds
Query Executed:select id FROM `mi` where city='Clyde' && SIC_code='5531'DB:business_master_new
loadtime:0.84508609771729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohoctah' limit 1
loadtime:0.84514904022217 / seconds
Query Executed:select id FROM `mi` where city='Cohoctah' && SIC_code='5531'DB:business_master_new
loadtime:0.84565997123718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.84572005271912 / seconds
Query Executed:select id FROM `mi` where city='Coldwater' && SIC_code='5531'DB:business_master_new
loadtime:0.85927605628967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleman' limit 1
loadtime:0.85936403274536 / seconds
Query Executed:select id FROM `mi` where city='Coleman' && SIC_code='5531'DB:business_master_new
loadtime:0.86188101768494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coloma' limit 1
loadtime:0.86199998855591 / seconds
Query Executed:select id FROM `mi` where city='Coloma' && SIC_code='5531'DB:business_master_new
loadtime:0.8676609992981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colon' limit 1
loadtime:0.86774396896362 / seconds
Query Executed:select id FROM `mi` where city='Colon' && SIC_code='5531'DB:business_master_new
loadtime:0.86880397796631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbiaville' limit 1
loadtime:0.86887311935425 / seconds
Query Executed:select id FROM `mi` where city='Columbiaville' && SIC_code='5531'DB:business_master_new
loadtime:0.87104511260986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.87110710144043 / seconds
Query Executed:select id FROM `mi` where city='Columbus' && SIC_code='5531'DB:business_master_new
loadtime:0.87259411811829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comins' limit 1
loadtime:0.87265491485596 / seconds
Query Executed:select id FROM `mi` where city='Comins' && SIC_code='5531'DB:business_master_new
loadtime:0.87341403961182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Township' limit 1
loadtime:0.87347507476807 / seconds
Query Executed:select id FROM `mi` where city='Commerce Township' && SIC_code='5531'DB:business_master_new
loadtime:0.88817191123962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Commerce Twp' limit 1
loadtime:0.88826107978821 / seconds
Query Executed:select id FROM `mi` where city='Commerce Twp' && SIC_code='5531'DB:business_master_new
loadtime:0.8891339302063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock' limit 1
loadtime:0.88919711112976 / seconds
Query Executed:select id FROM `mi` where city='Comstock' && SIC_code='5531'DB:business_master_new
loadtime:0.89010810852051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comstock Park' limit 1
loadtime:0.89017009735107 / seconds
Query Executed:select id FROM `mi` where city='Comstock Park' && SIC_code='5531'DB:business_master_new
loadtime:0.89810395240784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.89819097518921 / seconds
Query Executed:select id FROM `mi` where city='Concord' && SIC_code='5531'DB:business_master_new
loadtime:0.89996790885925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conklin' limit 1
loadtime:0.90004706382751 / seconds
Query Executed:select id FROM `mi` where city='Conklin' && SIC_code='5531'DB:business_master_new
loadtime:0.90134811401367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Constantine' limit 1
loadtime:0.90141105651855 / seconds
Query Executed:select id FROM `mi` where city='Constantine' && SIC_code='5531'DB:business_master_new
loadtime:0.90274596214294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.90280890464783 / seconds
Query Executed:select id FROM `mi` where city='Conway' && SIC_code='5531'DB:business_master_new
loadtime:0.90354609489441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooks' limit 1
loadtime:0.90360808372498 / seconds
Query Executed:select id FROM `mi` where city='Cooks' && SIC_code='5531'DB:business_master_new
loadtime:0.90408611297607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coopersville' limit 1
loadtime:0.90414810180664 / seconds
Query Executed:select id FROM `mi` where city='Coopersville' && SIC_code='5531'DB:business_master_new
loadtime:0.90940499305725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copemish' limit 1
loadtime:0.90948510169983 / seconds
Query Executed:select id FROM `mi` where city='Copemish' && SIC_code='5531'DB:business_master_new
loadtime:0.91043210029602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper City' limit 1
loadtime:0.9104950428009 / seconds
Query Executed:select id FROM `mi` where city='Copper City' && SIC_code='5531'DB:business_master_new
loadtime:0.91095089912415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Copper Harbor' limit 1
loadtime:0.91101408004761 / seconds
Query Executed:select id FROM `mi` where city='Copper Harbor' && SIC_code='5531'DB:business_master_new
loadtime:0.91175508499146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coral' limit 1
loadtime:0.91181898117065 / seconds
Query Executed:select id FROM `mi` where city='Coral' && SIC_code='5531'DB:business_master_new
loadtime:0.9125509262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornell' limit 1
loadtime:0.91261196136475 / seconds
Query Executed:select id FROM `mi` where city='Cornell' && SIC_code='5531'DB:business_master_new
loadtime:0.91329002380371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corunna' limit 1
loadtime:0.91335105895996 / seconds
Query Executed:select id FROM `mi` where city='Corunna' && SIC_code='5531'DB:business_master_new
loadtime:0.9162540435791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottrellville' limit 1
loadtime:0.91631507873535 / seconds
Query Executed:select id FROM `mi` where city='Cottrellville' && SIC_code='5531'DB:business_master_new
loadtime:0.91673994064331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covert' limit 1
loadtime:0.91682100296021 / seconds
Query Executed:select id FROM `mi` where city='Covert' && SIC_code='5531'DB:business_master_new
loadtime:0.91792392730713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Covington' limit 1
loadtime:0.91798496246338 / seconds
Query Executed:select id FROM `mi` where city='Covington' && SIC_code='5531'DB:business_master_new
loadtime:0.91860198974609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cross Village' limit 1
loadtime:0.91866302490234 / seconds
Query Executed:select id FROM `mi` where city='Cross Village' && SIC_code='5531'DB:business_master_new
loadtime:0.91919708251953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croswell' limit 1
loadtime:0.91925692558289 / seconds
Query Executed:select id FROM `mi` where city='Croswell' && SIC_code='5531'DB:business_master_new
loadtime:0.92239308357239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal' limit 1
loadtime:0.9224750995636 / seconds
Query Executed:select id FROM `mi` where city='Crystal' && SIC_code='5531'DB:business_master_new
loadtime:0.92395901679993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Falls' limit 1
loadtime:0.92403602600098 / seconds
Query Executed:select id FROM `mi` where city='Crystal Falls' && SIC_code='5531'DB:business_master_new
loadtime:0.92682504653931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curran' limit 1
loadtime:0.92691206932068 / seconds
Query Executed:select id FROM `mi` where city='Curran' && SIC_code='5531'DB:business_master_new
loadtime:0.92744898796082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curtis' limit 1
loadtime:0.92751312255859 / seconds
Query Executed:select id FROM `mi` where city='Curtis' && SIC_code='5531'DB:business_master_new
loadtime:0.92871189117432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.92879199981689 / seconds
Query Executed:select id FROM `mi` where city='Custer' && SIC_code='5531'DB:business_master_new
loadtime:0.92988109588623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dafter' limit 1
loadtime:0.9299681186676 / seconds
Query Executed:select id FROM `mi` where city='Dafter' && SIC_code='5531'DB:business_master_new
loadtime:0.93075704574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daggett' limit 1
loadtime:0.93082404136658 / seconds
Query Executed:select id FROM `mi` where city='Daggett' && SIC_code='5531'DB:business_master_new
loadtime:0.93160891532898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dansville' limit 1
loadtime:0.93166899681091 / seconds
Query Executed:select id FROM `mi` where city='Dansville' && SIC_code='5531'DB:business_master_new
loadtime:0.933109998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davisburg' limit 1
loadtime:0.93318605422974 / seconds
Query Executed:select id FROM `mi` where city='Davisburg' && SIC_code='5531'DB:business_master_new
loadtime:0.93623900413513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davison' limit 1
loadtime:0.93631410598755 / seconds
Query Executed:select id FROM `mi` where city='Davison' && SIC_code='5531'DB:business_master_new
loadtime:0.94807910919189 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Tour Village' limit 1
loadtime:0.94816589355469 / seconds
Query Executed:select id FROM `mi` where city='De Tour Village' && SIC_code='5531'DB:business_master_new
loadtime:0.94930100440979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn' limit 1
loadtime:0.94936490058899 / seconds
Query Executed:select id FROM `mi` where city='Dearborn' && SIC_code='5531'DB:business_master_new
loadtime:0.96580195426941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dearborn Heights' limit 1
loadtime:0.96588110923767 / seconds
Query Executed:select id FROM `mi` where city='Dearborn Heights' && SIC_code='5531'DB:business_master_new
loadtime:0.97383403778076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.97392201423645 / seconds
Query Executed:select id FROM `mi` where city='Decatur' && SIC_code='5531'DB:business_master_new
loadtime:0.97643399238586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decker' limit 1
loadtime:0.97651100158691 / seconds
Query Executed:select id FROM `mi` where city='Decker' && SIC_code='5531'DB:business_master_new
loadtime:0.97717189788818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deckerville' limit 1
loadtime:0.97723507881165 / seconds
Query Executed:select id FROM `mi` where city='Deckerville' && SIC_code='5531'DB:business_master_new
loadtime:0.97934794425964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.97943305969238 / seconds
Query Executed:select id FROM `mi` where city='Deerfield' && SIC_code='5531'DB:business_master_new
loadtime:0.980633020401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerton' limit 1
loadtime:0.9806981086731 / seconds
Query Executed:select id FROM `mi` where city='Deerton' && SIC_code='5531'DB:business_master_new
loadtime:0.98130297660828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deford' limit 1
loadtime:0.98136305809021 / seconds
Query Executed:select id FROM `mi` where city='Deford' && SIC_code='5531'DB:business_master_new
loadtime:0.98219203948975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delton' limit 1
loadtime:0.98225498199463 / seconds
Query Executed:select id FROM `mi` where city='Delton' && SIC_code='5531'DB:business_master_new
loadtime:0.98645210266113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Detroit' limit 1
loadtime:0.9865300655365 / seconds
Query Executed:select id FROM `mi` where city='Detroit' && SIC_code='5531'DB:business_master_new
loadtime:1.0109829902649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewitt' limit 1
loadtime:1.0110840797424 / seconds
Query Executed:select id FROM `mi` where city='Dewitt' && SIC_code='5531'DB:business_master_new
loadtime:1.0183880329132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:1.0184531211853 / seconds
Query Executed:select id FROM `mi` where city='Dexter' && SIC_code='5531'DB:business_master_new
loadtime:1.0216670036316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimondale' limit 1
loadtime:1.0217289924622 / seconds
Query Executed:select id FROM `mi` where city='Dimondale' && SIC_code='5531'DB:business_master_new
loadtime:1.024199962616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dodgeville' limit 1
loadtime:1.0242619514465 / seconds
Query Executed:select id FROM `mi` where city='Dodgeville' && SIC_code='5531'DB:business_master_new
loadtime:1.0247619152069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dollar Bay' limit 1
loadtime:1.0248229503632 / seconds
Query Executed:select id FROM `mi` where city='Dollar Bay' && SIC_code='5531'DB:business_master_new
loadtime:1.0256259441376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorr' limit 1
loadtime:1.0256879329681 / seconds
Query Executed:select id FROM `mi` where city='Dorr' && SIC_code='5531'DB:business_master_new
loadtime:1.0286099910736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:1.0286860466003 / seconds
Query Executed:select id FROM `mi` where city='Douglas' && SIC_code='5531'DB:business_master_new
loadtime:1.0306479930878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowagiac' limit 1
loadtime:1.0307099819183 / seconds
Query Executed:select id FROM `mi` where city='Dowagiac' && SIC_code='5531'DB:business_master_new
loadtime:1.0389549732208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dowling' limit 1
loadtime:1.039036989212 / seconds
Query Executed:select id FROM `mi` where city='Dowling' && SIC_code='5531'DB:business_master_new
loadtime:1.0399780273438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drayton Plains' limit 1
loadtime:1.0400431156158 / seconds
Query Executed:select id FROM `mi` where city='Drayton Plains' && SIC_code='5531'DB:business_master_new
loadtime:1.0409340858459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drummond Island' limit 1
loadtime:1.0409951210022 / seconds
Query Executed:select id FROM `mi` where city='Drummond Island' && SIC_code='5531'DB:business_master_new
loadtime:1.0425040721893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dryden' limit 1
loadtime:1.0425779819489 / seconds
Query Executed:select id FROM `mi` where city='Dryden' && SIC_code='5531'DB:business_master_new
loadtime:1.0448849201202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:1.044958114624 / seconds
Query Executed:select id FROM `mi` where city='Dundee' && SIC_code='5531'DB:business_master_new
loadtime:1.0481429100037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durand' limit 1
loadtime:1.0482220649719 / seconds
Query Executed:select id FROM `mi` where city='Durand' && SIC_code='5531'DB:business_master_new
loadtime:1.0519700050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:1.0520479679108 / seconds
Query Executed:select id FROM `mi` where city='Dutton' && SIC_code='5531'DB:business_master_new
loadtime:1.0525450706482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle' limit 1
loadtime:1.0526080131531 / seconds
Query Executed:select id FROM `mi` where city='Eagle' && SIC_code='5531'DB:business_master_new
loadtime:1.0539219379425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Harbor' limit 1
loadtime:1.0539960861206 / seconds
Query Executed:select id FROM `mi` where city='Eagle Harbor' && SIC_code='5531'DB:business_master_new
loadtime:1.0544950962067 / seconds
Query loaded from cache:select * from geodata_geocity where city='East China' limit 1
loadtime:1.0545558929443 / seconds
Query Executed:select id FROM `mi` where city='East China' && SIC_code='5531'DB:business_master_new
loadtime:1.0575749874115 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Jordan' limit 1
loadtime:1.0576519966125 / seconds
Query Executed:select id FROM `mi` where city='East Jordan' && SIC_code='5531'DB:business_master_new
loadtime:1.0611410140991 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lansing' limit 1
loadtime:1.0612170696259 / seconds
Query Executed:select id FROM `mi` where city='East Lansing' && SIC_code='5531'DB:business_master_new
loadtime:1.0846860408783 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Leroy' limit 1
loadtime:1.0847749710083 / seconds
Query Executed:select id FROM `mi` where city='East Leroy' && SIC_code='5531'DB:business_master_new
loadtime:1.085736989975 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Tawas' limit 1
loadtime:1.0858130455017 / seconds
Query Executed:select id FROM `mi` where city='East Tawas' && SIC_code='5531'DB:business_master_new
loadtime:1.0908570289612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastlake' limit 1
loadtime:1.090950012207 / seconds
Query Executed:select id FROM `mi` where city='Eastlake' && SIC_code='5531'DB:business_master_new
loadtime:1.0914299488068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastpointe' limit 1
loadtime:1.0914928913116 / seconds
Query Executed:select id FROM `mi` where city='Eastpointe' && SIC_code='5531'DB:business_master_new
loadtime:1.1039769649506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastport' limit 1
loadtime:1.1040699481964 / seconds
Query Executed:select id FROM `mi` where city='Eastport' && SIC_code='5531'DB:business_master_new
loadtime:1.1047420501709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Rapids' limit 1
loadtime:1.1048069000244 / seconds
Query Executed:select id FROM `mi` where city='Eaton Rapids' && SIC_code='5531'DB:business_master_new
loadtime:1.1115601062775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eau Claire' limit 1
loadtime:1.1116409301758 / seconds
Query Executed:select id FROM `mi` where city='Eau Claire' && SIC_code='5531'DB:business_master_new
loadtime:1.1137719154358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eben Junction' limit 1
loadtime:1.1138339042664 / seconds
Query Executed:select id FROM `mi` where city='Eben Junction' && SIC_code='5531'DB:business_master_new
loadtime:1.1146440505981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eckerman' limit 1
loadtime:1.1147050857544 / seconds
Query Executed:select id FROM `mi` where city='Eckerman' && SIC_code='5531'DB:business_master_new
loadtime:1.1154170036316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecorse' limit 1
loadtime:1.1154780387878 / seconds
Query Executed:select id FROM `mi` where city='Ecorse' && SIC_code='5531'DB:business_master_new
loadtime:1.116856098175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenville' limit 1
loadtime:1.1169519424438 / seconds
Query Executed:select id FROM `mi` where city='Edenville' && SIC_code='5531'DB:business_master_new
loadtime:1.1175448894501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edmore' limit 1
loadtime:1.1176071166992 / seconds
Query Executed:select id FROM `mi` where city='Edmore' && SIC_code='5531'DB:business_master_new
loadtime:1.1199939250946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsburg' limit 1
loadtime:1.1200759410858 / seconds
Query Executed:select id FROM `mi` where city='Edwardsburg' && SIC_code='5531'DB:business_master_new
loadtime:1.1236259937286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:1.123703956604 / seconds
Query Executed:select id FROM `mi` where city='Elberta' && SIC_code='5531'DB:business_master_new
loadtime:1.1243600845337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Rapids' limit 1
loadtime:1.1244230270386 / seconds
Query Executed:select id FROM `mi` where city='Elk Rapids' && SIC_code='5531'DB:business_master_new
loadtime:1.1275010108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:1.1275770664215 / seconds
Query Executed:select id FROM `mi` where city='Elkton' && SIC_code='5531'DB:business_master_new
loadtime:1.1289420127869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:1.1290190219879 / seconds
Query Executed:select id FROM `mi` where city='Ellsworth' && SIC_code='5531'DB:business_master_new
loadtime:1.1302759647369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Hall' limit 1
loadtime:1.1303379535675 / seconds
Query Executed:select id FROM `mi` where city='Elm Hall' && SIC_code='5531'DB:business_master_new
loadtime:1.1307799816132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmira' limit 1
loadtime:1.1308660507202 / seconds
Query Executed:select id FROM `mi` where city='Elmira' && SIC_code='5531'DB:business_master_new
loadtime:1.1316449642181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsie' limit 1
loadtime:1.1317059993744 / seconds
Query Executed:select id FROM `mi` where city='Elsie' && SIC_code='5531'DB:business_master_new
loadtime:1.1334900856018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwell' limit 1
loadtime:1.1335520744324 / seconds
Query Executed:select id FROM `mi` where city='Elwell' && SIC_code='5531'DB:business_master_new
loadtime:1.1343929767609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmett' limit 1
loadtime:1.1344540119171 / seconds
Query Executed:select id FROM `mi` where city='Emmett' && SIC_code='5531'DB:business_master_new
loadtime:1.135822057724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:1.1358830928802 / seconds
Query Executed:select id FROM `mi` where city='Empire' && SIC_code='5531'DB:business_master_new
loadtime:1.1374540328979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engadine' limit 1
loadtime:1.1375169754028 / seconds
Query Executed:select id FROM `mi` where city='Engadine' && SIC_code='5531'DB:business_master_new
loadtime:1.1383979320526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erie' limit 1
loadtime:1.1384739875793 / seconds
Query Executed:select id FROM `mi` where city='Erie' && SIC_code='5531'DB:business_master_new
loadtime:1.1407809257507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escanaba' limit 1
loadtime:1.1408650875092 / seconds
Query Executed:select id FROM `mi` where city='Escanaba' && SIC_code='5531'DB:business_master_new
loadtime:1.1534030437469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essexville' limit 1
loadtime:1.1534969806671 / seconds
Query Executed:select id FROM `mi` where city='Essexville' && SIC_code='5531'DB:business_master_new
loadtime:1.1574189662933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:1.1575000286102 / seconds
Query Executed:select id FROM `mi` where city='Eureka' && SIC_code='5531'DB:business_master_new
loadtime:1.1580328941345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evart' limit 1
loadtime:1.1580951213837 / seconds
Query Executed:select id FROM `mi` where city='Evart' && SIC_code='5531'DB:business_master_new
loadtime:1.1612191200256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewen' limit 1
loadtime:1.1612958908081 / seconds
Query Executed:select id FROM `mi` where city='Ewen' && SIC_code='5531'DB:business_master_new
loadtime:1.1618549823761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:1.1619279384613 / seconds
Query Executed:select id FROM `mi` where city='Fair Haven' && SIC_code='5531'DB:business_master_new
loadtime:1.1645069122314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairgrove' limit 1
loadtime:1.1645839214325 / seconds
Query Executed:select id FROM `mi` where city='Fairgrove' && SIC_code='5531'DB:business_master_new
loadtime:1.1657240390778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:1.1657910346985 / seconds
Query Executed:select id FROM `mi` where city='Fairview' && SIC_code='5531'DB:business_master_new
loadtime:1.1670649051666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:1.1671259403229 / seconds
Query Executed:select id FROM `mi` where city='Falmouth' && SIC_code='5531'DB:business_master_new
loadtime:1.1679921150208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fargo' limit 1
loadtime:1.1680550575256 / seconds
Query Executed:select id FROM `mi` where city='Fargo' && SIC_code='5531'DB:business_master_new
loadtime:1.1684799194336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:1.1685400009155 / seconds
Query Executed:select id FROM `mi` where city='Farmington' && SIC_code='5531'DB:business_master_new
loadtime:1.187155008316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington Hills' limit 1
loadtime:1.187264919281 / seconds
Query Executed:select id FROM `mi` where city='Farmington Hills' && SIC_code='5531'DB:business_master_new
loadtime:1.1889879703522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farwell' limit 1
loadtime:1.1890709400177 / seconds
Query Executed:select id FROM `mi` where city='Farwell' && SIC_code='5531'DB:business_master_new
loadtime:1.1915180683136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Felch' limit 1
loadtime:1.1915941238403 / seconds
Query Executed:select id FROM `mi` where city='Felch' && SIC_code='5531'DB:business_master_new
loadtime:1.1923289299011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fennville' limit 1
loadtime:1.1923909187317 / seconds
Query Executed:select id FROM `mi` where city='Fennville' && SIC_code='5531'DB:business_master_new
loadtime:1.1958739757538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:1.1959619522095 / seconds
Query Executed:select id FROM `mi` where city='Fenton' && SIC_code='5531'DB:business_master_new
loadtime:1.2127010822296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenwick' limit 1
loadtime:1.2128000259399 / seconds
Query Executed:select id FROM `mi` where city='Fenwick' && SIC_code='5531'DB:business_master_new
loadtime:1.2138130664825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferndale' limit 1
loadtime:1.2138891220093 / seconds
Query Executed:select id FROM `mi` where city='Ferndale' && SIC_code='5531'DB:business_master_new
loadtime:1.2266409397125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferrysburg' limit 1
loadtime:1.2267320156097 / seconds
Query Executed:select id FROM `mi` where city='Ferrysburg' && SIC_code='5531'DB:business_master_new
loadtime:1.2275938987732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fife Lake' limit 1
loadtime:1.2276589870453 / seconds
Query Executed:select id FROM `mi` where city='Fife Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.2292261123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filer City' limit 1
loadtime:1.2292869091034 / seconds
Query Executed:select id FROM `mi` where city='Filer City' && SIC_code='5531'DB:business_master_new
loadtime:1.2297730445862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Filion' limit 1
loadtime:1.2298350334167 / seconds
Query Executed:select id FROM `mi` where city='Filion' && SIC_code='5531'DB:business_master_new
loadtime:1.230712890625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:1.2307810783386 / seconds
Query Executed:select id FROM `mi` where city='Flat Rock' && SIC_code='5531'DB:business_master_new
loadtime:1.2333750724792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flint' limit 1
loadtime:1.2334520816803 / seconds
Query Executed:select id FROM `mi` where city='Flint' && SIC_code='5531'DB:business_master_new
loadtime:1.2520251274109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flushing' limit 1
loadtime:1.2521910667419 / seconds
Query Executed:select id FROM `mi` where city='Flushing' && SIC_code='5531'DB:business_master_new
loadtime:1.2626180648804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestville' limit 1
loadtime:1.2627100944519 / seconds
Query Executed:select id FROM `mi` where city='Forestville' && SIC_code='5531'DB:business_master_new
loadtime:1.2631978988647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Gratiot' limit 1
loadtime:1.2632610797882 / seconds
Query Executed:select id FROM `mi` where city='Fort Gratiot' && SIC_code='5531'DB:business_master_new
loadtime:1.2715859413147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foster City' limit 1
loadtime:1.2716701030731 / seconds
Query Executed:select id FROM `mi` where city='Foster City' && SIC_code='5531'DB:business_master_new
loadtime:1.272176027298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:1.2722470760345 / seconds
Query Executed:select id FROM `mi` where city='Fostoria' && SIC_code='5531'DB:business_master_new
loadtime:1.27312707901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:1.2731890678406 / seconds
Query Executed:select id FROM `mi` where city='Fountain' && SIC_code='5531'DB:business_master_new
loadtime:1.2741169929504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowler' limit 1
loadtime:1.274178981781 / seconds
Query Executed:select id FROM `mi` where city='Fowler' && SIC_code='5531'DB:business_master_new
loadtime:1.2758100032806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fowlerville' limit 1
loadtime:1.2758851051331 / seconds
Query Executed:select id FROM `mi` where city='Fowlerville' && SIC_code='5531'DB:business_master_new
loadtime:1.2828049659729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankenmuth' limit 1
loadtime:1.2828850746155 / seconds
Query Executed:select id FROM `mi` where city='Frankenmuth' && SIC_code='5531'DB:business_master_new
loadtime:1.2890679836273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:1.2891449928284 / seconds
Query Executed:select id FROM `mi` where city='Frankfort' && SIC_code='5531'DB:business_master_new
loadtime:1.2920548915863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.292130947113 / seconds
Query Executed:select id FROM `mi` where city='Franklin' && SIC_code='5531'DB:business_master_new
loadtime:1.3063390254974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fraser' limit 1
loadtime:1.3064179420471 / seconds
Query Executed:select id FROM `mi` where city='Fraser' && SIC_code='5531'DB:business_master_new
loadtime:1.3155310153961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederic' limit 1
loadtime:1.315614938736 / seconds
Query Executed:select id FROM `mi` where city='Frederic' && SIC_code='5531'DB:business_master_new
loadtime:1.3165490627289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Free Soil' limit 1
loadtime:1.3166120052338 / seconds
Query Executed:select id FROM `mi` where city='Free Soil' && SIC_code='5531'DB:business_master_new
loadtime:1.3175799846649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeland' limit 1
loadtime:1.3176419734955 / seconds
Query Executed:select id FROM `mi` where city='Freeland' && SIC_code='5531'DB:business_master_new
loadtime:1.3238320350647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeport' limit 1
loadtime:1.3239240646362 / seconds
Query Executed:select id FROM `mi` where city='Freeport' && SIC_code='5531'DB:business_master_new
loadtime:1.3249719142914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:1.3250350952148 / seconds
Query Executed:select id FROM `mi` where city='Fremont' && SIC_code='5531'DB:business_master_new
loadtime:1.3330368995667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frontier' limit 1
loadtime:1.333123922348 / seconds
Query Executed:select id FROM `mi` where city='Frontier' && SIC_code='5531'DB:business_master_new
loadtime:1.3336260318756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitport' limit 1
loadtime:1.3336899280548 / seconds
Query Executed:select id FROM `mi` where city='Fruitport' && SIC_code='5531'DB:business_master_new
loadtime:1.336795091629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:1.3368690013885 / seconds
Query Executed:select id FROM `mi` where city='Fulton' && SIC_code='5531'DB:business_master_new
loadtime:1.3376641273499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaastra' limit 1
loadtime:1.3377270698547 / seconds
Query Executed:select id FROM `mi` where city='Gaastra' && SIC_code='5531'DB:business_master_new
loadtime:1.3383169174194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gagetown' limit 1
loadtime:1.33837890625 / seconds
Query Executed:select id FROM `mi` where city='Gagetown' && SIC_code='5531'DB:business_master_new
loadtime:1.3392970561981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaines' limit 1
loadtime:1.3393580913544 / seconds
Query Executed:select id FROM `mi` where city='Gaines' && SIC_code='5531'DB:business_master_new
loadtime:1.3405549526215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galesburg' limit 1
loadtime:1.3406159877777 / seconds
Query Executed:select id FROM `mi` where city='Galesburg' && SIC_code='5531'DB:business_master_new
loadtime:1.3433079719543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galien' limit 1
loadtime:1.3433880805969 / seconds
Query Executed:select id FROM `mi` where city='Galien' && SIC_code='5531'DB:business_master_new
loadtime:1.3445401191711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden' limit 1
loadtime:1.344603061676 / seconds
Query Executed:select id FROM `mi` where city='Garden' && SIC_code='5531'DB:business_master_new
loadtime:1.3454959392548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:1.3455579280853 / seconds
Query Executed:select id FROM `mi` where city='Garden City' && SIC_code='5531'DB:business_master_new
loadtime:1.3510630130768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylord' limit 1
loadtime:1.3511419296265 / seconds
Query Executed:select id FROM `mi` where city='Gaylord' && SIC_code='5531'DB:business_master_new
loadtime:1.3578379154205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genesee' limit 1
loadtime:1.3579139709473 / seconds
Query Executed:select id FROM `mi` where city='Genesee' && SIC_code='5531'DB:business_master_new
loadtime:1.358922958374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germfask' limit 1
loadtime:1.3589980602264 / seconds
Query Executed:select id FROM `mi` where city='Germfask' && SIC_code='5531'DB:business_master_new
loadtime:1.3595790863037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:1.35964012146 / seconds
Query Executed:select id FROM `mi` where city='Gilford' && SIC_code='5531'DB:business_master_new
loadtime:1.3601150512695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.3601760864258 / seconds
Query Executed:select id FROM `mi` where city='Gladstone' && SIC_code='5531'DB:business_master_new
loadtime:1.3653519153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladwin' limit 1
loadtime:1.3654310703278 / seconds
Query Executed:select id FROM `mi` where city='Gladwin' && SIC_code='5531'DB:business_master_new
loadtime:1.373526096344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Arbor' limit 1
loadtime:1.3736090660095 / seconds
Query Executed:select id FROM `mi` where city='Glen Arbor' && SIC_code='5531'DB:business_master_new
loadtime:1.3754069805145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenn' limit 1
loadtime:1.3754689693451 / seconds
Query Executed:select id FROM `mi` where city='Glenn' && SIC_code='5531'DB:business_master_new
loadtime:1.3759980201721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glennie' limit 1
loadtime:1.3760600090027 / seconds
Query Executed:select id FROM `mi` where city='Glennie' && SIC_code='5531'DB:business_master_new
loadtime:1.3771870136261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gobles' limit 1
loadtime:1.3772621154785 / seconds
Query Executed:select id FROM `mi` where city='Gobles' && SIC_code='5531'DB:business_master_new
loadtime:1.3795800209045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goetzville' limit 1
loadtime:1.379655122757 / seconds
Query Executed:select id FROM `mi` where city='Goetzville' && SIC_code='5531'DB:business_master_new
loadtime:1.380362033844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Good Hart' limit 1
loadtime:1.3804240226746 / seconds
Query Executed:select id FROM `mi` where city='Good Hart' && SIC_code='5531'DB:business_master_new
loadtime:1.3808770179749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodells' limit 1
loadtime:1.3809490203857 / seconds
Query Executed:select id FROM `mi` where city='Goodells' && SIC_code='5531'DB:business_master_new
loadtime:1.3822319507599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodrich' limit 1
loadtime:1.3822939395905 / seconds
Query Executed:select id FROM `mi` where city='Goodrich' && SIC_code='5531'DB:business_master_new
loadtime:1.3849349021912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gould City' limit 1
loadtime:1.3850140571594 / seconds
Query Executed:select id FROM `mi` where city='Gould City' && SIC_code='5531'DB:business_master_new
loadtime:1.3856639862061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowen' limit 1
loadtime:1.3857259750366 / seconds
Query Executed:select id FROM `mi` where city='Gowen' && SIC_code='5531'DB:business_master_new
loadtime:1.3869609832764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Beach' limit 1
loadtime:1.3870370388031 / seconds
Query Executed:select id FROM `mi` where city='Grand Beach' && SIC_code='5531'DB:business_master_new
loadtime:1.3874800205231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Blanc' limit 1
loadtime:1.3875420093536 / seconds
Query Executed:select id FROM `mi` where city='Grand Blanc' && SIC_code='5531'DB:business_master_new
loadtime:1.4044809341431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Haven' limit 1
loadtime:1.4045588970184 / seconds
Query Executed:select id FROM `mi` where city='Grand Haven' && SIC_code='5531'DB:business_master_new
loadtime:1.4216649532318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:1.4217579364777 / seconds
Query Executed:select id FROM `mi` where city='Grand Junction' && SIC_code='5531'DB:business_master_new
loadtime:1.4230189323425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Ledge' limit 1
loadtime:1.4230840206146 / seconds
Query Executed:select id FROM `mi` where city='Grand Ledge' && SIC_code='5531'DB:business_master_new
loadtime:1.4321210384369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Marais' limit 1
loadtime:1.4321990013123 / seconds
Query Executed:select id FROM `mi` where city='Grand Marais' && SIC_code='5531'DB:business_master_new
loadtime:1.4331641197205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Rapids' limit 1
loadtime:1.4332361221313 / seconds
Query Executed:select id FROM `mi` where city='Grand Rapids' && SIC_code='5531'DB:business_master_new
loadtime:1.4520580768585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandville' limit 1
loadtime:1.4522581100464 / seconds
Query Executed:select id FROM `mi` where city='Grandville' && SIC_code='5531'DB:business_master_new
loadtime:1.4677309989929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:1.4678308963776 / seconds
Query Executed:select id FROM `mi` where city='Grant' && SIC_code='5531'DB:business_master_new
loadtime:1.4706649780273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant Twp' limit 1
loadtime:1.4707500934601 / seconds
Query Executed:select id FROM `mi` where city='Grant Twp' && SIC_code='5531'DB:business_master_new
loadtime:1.4712369441986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grass Lake' limit 1
loadtime:1.4713060855865 / seconds
Query Executed:select id FROM `mi` where city='Grass Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.4746239185333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grawn' limit 1
loadtime:1.4746849536896 / seconds
Query Executed:select id FROM `mi` where city='Grawn' && SIC_code='5531'DB:business_master_new
loadtime:1.4764089584351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grayling' limit 1
loadtime:1.4764699935913 / seconds
Query Executed:select id FROM `mi` where city='Grayling' && SIC_code='5531'DB:business_master_new
loadtime:1.4839370250702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.4840190410614 / seconds
Query Executed:select id FROM `mi` where city='Greenbush' && SIC_code='5531'DB:business_master_new
loadtime:1.4849619865417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:1.4850261211395 / seconds
Query Executed:select id FROM `mi` where city='Greenland' && SIC_code='5531'DB:business_master_new
loadtime:1.4855201244354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.4855809211731 / seconds
Query Executed:select id FROM `mi` where city='Greenville' && SIC_code='5531'DB:business_master_new
loadtime:1.4953970909119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.4954841136932 / seconds
Query Executed:select id FROM `mi` where city='Greenwood' && SIC_code='5531'DB:business_master_new
loadtime:1.4959471225739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:1.4960150718689 / seconds
Query Executed:select id FROM `mi` where city='Gregory' && SIC_code='5531'DB:business_master_new
loadtime:1.4978940486908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Ile' limit 1
loadtime:1.4979801177979 / seconds
Query Executed:select id FROM `mi` where city='Grosse Ile' && SIC_code='5531'DB:business_master_new
loadtime:1.5001480579376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pointe' limit 1
loadtime:1.5002241134644 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pointe' && SIC_code='5531'DB:business_master_new
loadtime:1.5121660232544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Farms' limit 1
loadtime:1.5122299194336 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Farms' && SIC_code='5531'DB:business_master_new
loadtime:1.5127580165863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Park' limit 1
loadtime:1.5128200054169 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Park' && SIC_code='5531'DB:business_master_new
loadtime:1.5133519172668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosse Pte Woods' limit 1
loadtime:1.5134129524231 / seconds
Query Executed:select id FROM `mi` where city='Grosse Pte Woods' && SIC_code='5531'DB:business_master_new
loadtime:1.5139620304108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulliver' limit 1
loadtime:1.514023065567 / seconds
Query Executed:select id FROM `mi` where city='Gulliver' && SIC_code='5531'DB:business_master_new
loadtime:1.5146129131317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gwinn' limit 1
loadtime:1.514673948288 / seconds
Query Executed:select id FROM `mi` where city='Gwinn' && SIC_code='5531'DB:business_master_new
loadtime:1.5187969207764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:1.5188729763031 / seconds
Query Executed:select id FROM `mi` where city='Hadley' && SIC_code='5531'DB:business_master_new
loadtime:1.5196459293365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hagar Shores' limit 1
loadtime:1.5197079181671 / seconds
Query Executed:select id FROM `mi` where city='Hagar Shores' && SIC_code='5531'DB:business_master_new
loadtime:1.5201380252838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hale' limit 1
loadtime:1.5201990604401 / seconds
Query Executed:select id FROM `mi` where city='Hale' && SIC_code='5531'DB:business_master_new
loadtime:1.5225369930267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:1.5226140022278 / seconds
Query Executed:select id FROM `mi` where city='Hamburg' && SIC_code='5531'DB:business_master_new
loadtime:1.5239369869232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.5239989757538 / seconds
Query Executed:select id FROM `mi` where city='Hamilton' && SIC_code='5531'DB:business_master_new
loadtime:1.5269861221313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamtramck' limit 1
loadtime:1.527046918869 / seconds
Query Executed:select id FROM `mi` where city='Hamtramck' && SIC_code='5531'DB:business_master_new
loadtime:1.530168056488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.5302329063416 / seconds
Query Executed:select id FROM `mi` where city='Hancock' && SIC_code='5531'DB:business_master_new
loadtime:1.535197019577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.5352749824524 / seconds
Query Executed:select id FROM `mi` where city='Hanover' && SIC_code='5531'DB:business_master_new
loadtime:1.5366051197052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbert' limit 1
loadtime:1.5366671085358 / seconds
Query Executed:select id FROM `mi` where city='Harbert' && SIC_code='5531'DB:business_master_new
loadtime:1.5372741222382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Beach' limit 1
loadtime:1.5373411178589 / seconds
Query Executed:select id FROM `mi` where city='Harbor Beach' && SIC_code='5531'DB:business_master_new
loadtime:1.5401849746704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbor Springs' limit 1
loadtime:1.5402619838715 / seconds
Query Executed:select id FROM `mi` where city='Harbor Springs' && SIC_code='5531'DB:business_master_new
loadtime:1.5480649471283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper Woods' limit 1
loadtime:1.5481278896332 / seconds
Query Executed:select id FROM `mi` where city='Harper Woods' && SIC_code='5531'DB:business_master_new
loadtime:1.5507509708405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrietta' limit 1
loadtime:1.5508139133453 / seconds
Query Executed:select id FROM `mi` where city='Harrietta' && SIC_code='5531'DB:business_master_new
loadtime:1.5514678955078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:1.5515279769897 / seconds
Query Executed:select id FROM `mi` where city='Harris' && SIC_code='5531'DB:business_master_new
loadtime:1.5520579814911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:1.5521190166473 / seconds
Query Executed:select id FROM `mi` where city='Harrison' && SIC_code='5531'DB:business_master_new
loadtime:1.5586369037628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Township' limit 1
loadtime:1.5587179660797 / seconds
Query Executed:select id FROM `mi` where city='Harrison Township' && SIC_code='5531'DB:business_master_new
loadtime:1.5680630207062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison Twp' limit 1
loadtime:1.5681490898132 / seconds
Query Executed:select id FROM `mi` where city='Harrison Twp' && SIC_code='5531'DB:business_master_new
loadtime:1.5687730312347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:1.5688359737396 / seconds
Query Executed:select id FROM `mi` where city='Harrisville' && SIC_code='5531'DB:business_master_new
loadtime:1.5717530250549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harsens Island' limit 1
loadtime:1.5718159675598 / seconds
Query Executed:select id FROM `mi` where city='Harsens Island' && SIC_code='5531'DB:business_master_new
loadtime:1.5728399753571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hart' limit 1
loadtime:1.5729160308838 / seconds
Query Executed:select id FROM `mi` where city='Hart' && SIC_code='5531'DB:business_master_new
loadtime:1.5781290531158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.5782070159912 / seconds
Query Executed:select id FROM `mi` where city='Hartford' && SIC_code='5531'DB:business_master_new
loadtime:1.580845117569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartland' limit 1
loadtime:1.5809359550476 / seconds
Query Executed:select id FROM `mi` where city='Hartland' && SIC_code='5531'DB:business_master_new
loadtime:1.5846300125122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:1.5846929550171 / seconds
Query Executed:select id FROM `mi` where city='Harvey' && SIC_code='5531'DB:business_master_new
loadtime:1.5851380825043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haslett' limit 1
loadtime:1.5851991176605 / seconds
Query Executed:select id FROM `mi` where city='Haslett' && SIC_code='5531'DB:business_master_new
loadtime:1.5915529727936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:1.5916290283203 / seconds
Query Executed:select id FROM `mi` where city='Hastings' && SIC_code='5531'DB:business_master_new
loadtime:1.6012489795685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawks' limit 1
loadtime:1.6013340950012 / seconds
Query Executed:select id FROM `mi` where city='Hawks' && SIC_code='5531'DB:business_master_new
loadtime:1.6020419597626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Park' limit 1
loadtime:1.6021049022675 / seconds
Query Executed:select id FROM `mi` where city='Hazel Park' && SIC_code='5531'DB:business_master_new
loadtime:1.6098940372467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hemlock' limit 1
loadtime:1.6099879741669 / seconds
Query Executed:select id FROM `mi` where city='Hemlock' && SIC_code='5531'DB:business_master_new
loadtime:1.6126420497894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:1.6127181053162 / seconds
Query Executed:select id FROM `mi` where city='Henderson' && SIC_code='5531'DB:business_master_new
loadtime:1.6134510040283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermansville' limit 1
loadtime:1.6135129928589 / seconds
Query Executed:select id FROM `mi` where city='Hermansville' && SIC_code='5531'DB:business_master_new
loadtime:1.6142120361328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herron' limit 1
loadtime:1.6142730712891 / seconds
Query Executed:select id FROM `mi` where city='Herron' && SIC_code='5531'DB:business_master_new
loadtime:1.6150441169739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hersey' limit 1
loadtime:1.6151130199432 / seconds
Query Executed:select id FROM `mi` where city='Hersey' && SIC_code='5531'DB:business_master_new
loadtime:1.6161069869995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hesperia' limit 1
loadtime:1.6161689758301 / seconds
Query Executed:select id FROM `mi` where city='Hesperia' && SIC_code='5531'DB:business_master_new
loadtime:1.6181080341339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hessel' limit 1
loadtime:1.6181890964508 / seconds
Query Executed:select id FROM `mi` where city='Hessel' && SIC_code='5531'DB:business_master_new
loadtime:1.619115114212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Corners' limit 1
loadtime:1.6191771030426 / seconds
Query Executed:select id FROM `mi` where city='Hickory Corners' && SIC_code='5531'DB:business_master_new
loadtime:1.6202890872955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higgins Lake' limit 1
loadtime:1.6203489303589 / seconds
Query Executed:select id FROM `mi` where city='Higgins Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.6209111213684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:1.6209709644318 / seconds
Query Executed:select id FROM `mi` where city='Highland' && SIC_code='5531'DB:business_master_new
loadtime:1.6300790309906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Park' limit 1
loadtime:1.6301560401917 / seconds
Query Executed:select id FROM `mi` where city='Highland Park' && SIC_code='5531'DB:business_master_new
loadtime:1.6338629722595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillman' limit 1
loadtime:1.6339559555054 / seconds
Query Executed:select id FROM `mi` where city='Hillman' && SIC_code='5531'DB:business_master_new
loadtime:1.6351320743561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:1.6351940631866 / seconds
Query Executed:select id FROM `mi` where city='Hillsdale' && SIC_code='5531'DB:business_master_new
loadtime:1.6443819999695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.644464969635 / seconds
Query Executed:select id FROM `mi` where city='Holland' && SIC_code='5531'DB:business_master_new
loadtime:1.6838719844818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly' limit 1
loadtime:1.6840190887451 / seconds
Query Executed:select id FROM `mi` where city='Holly' && SIC_code='5531'DB:business_master_new
loadtime:1.693244934082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holt' limit 1
loadtime:1.6933250427246 / seconds
Query Executed:select id FROM `mi` where city='Holt' && SIC_code='5531'DB:business_master_new
loadtime:1.701719045639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holton' limit 1
loadtime:1.7018051147461 / seconds
Query Executed:select id FROM `mi` where city='Holton' && SIC_code='5531'DB:business_master_new
loadtime:1.7032639980316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homer' limit 1
loadtime:1.7033400535583 / seconds
Query Executed:select id FROM `mi` where city='Homer' && SIC_code='5531'DB:business_master_new
loadtime:1.7055599689484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honor' limit 1
loadtime:1.7056379318237 / seconds
Query Executed:select id FROM `mi` where city='Honor' && SIC_code='5531'DB:business_master_new
loadtime:1.7073059082031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:1.7073819637299 / seconds
Query Executed:select id FROM `mi` where city='Hope' && SIC_code='5531'DB:business_master_new
loadtime:1.708368062973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkins' limit 1
loadtime:1.7084310054779 / seconds
Query Executed:select id FROM `mi` where city='Hopkins' && SIC_code='5531'DB:business_master_new
loadtime:1.7102060317993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horton' limit 1
loadtime:1.7102680206299 / seconds
Query Executed:select id FROM `mi` where city='Horton' && SIC_code='5531'DB:business_master_new
loadtime:1.711699962616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:1.7117650508881 / seconds
Query Executed:select id FROM `mi` where city='Houghton' && SIC_code='5531'DB:business_master_new
loadtime:1.7182519435883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake' limit 1
loadtime:1.7183330059052 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.7208859920502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton Lake Heights' limit 1
loadtime:1.7209730148315 / seconds
Query Executed:select id FROM `mi` where city='Houghton Lake Heights' && SIC_code='5531'DB:business_master_new
loadtime:1.7214870452881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard City' limit 1
loadtime:1.7215490341187 / seconds
Query Executed:select id FROM `mi` where city='Howard City' && SIC_code='5531'DB:business_master_new
loadtime:1.7245941162109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:1.7246730327606 / seconds
Query Executed:select id FROM `mi` where city='Howell' && SIC_code='5531'DB:business_master_new
loadtime:1.7481670379639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard Lake' limit 1
loadtime:1.7482709884644 / seconds
Query Executed:select id FROM `mi` where city='Hubbard Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.74964594841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.7497088909149 / seconds
Query Executed:select id FROM `mi` where city='Hubbardston' && SIC_code='5531'DB:business_master_new
loadtime:1.7504329681396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbell' limit 1
loadtime:1.7504959106445 / seconds
Query Executed:select id FROM `mi` where city='Hubbell' && SIC_code='5531'DB:business_master_new
loadtime:1.7511811256409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.7512431144714 / seconds
Query Executed:select id FROM `mi` where city='Hudson' && SIC_code='5531'DB:business_master_new
loadtime:1.7541420459747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudsonville' limit 1
loadtime:1.7542169094086 / seconds
Query Executed:select id FROM `mi` where city='Hudsonville' && SIC_code='5531'DB:business_master_new
loadtime:1.7651929855347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hulbert' limit 1
loadtime:1.7652730941772 / seconds
Query Executed:select id FROM `mi` where city='Hulbert' && SIC_code='5531'DB:business_master_new
loadtime:1.7659320831299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington Woods' limit 1
loadtime:1.7659950256348 / seconds
Query Executed:select id FROM `mi` where city='Huntington Woods' && SIC_code='5531'DB:business_master_new
loadtime:1.7692561149597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida' limit 1
loadtime:1.7693319320679 / seconds
Query Executed:select id FROM `mi` where city='Ida' && SIC_code='5531'DB:business_master_new
loadtime:1.7709729671478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Idlewild' limit 1
loadtime:1.7710359096527 / seconds
Query Executed:select id FROM `mi` where city='Idlewild' && SIC_code='5531'DB:business_master_new
loadtime:1.771721124649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imlay City' limit 1
loadtime:1.7717890739441 / seconds
Query Executed:select id FROM `mi` where city='Imlay City' && SIC_code='5531'DB:business_master_new
loadtime:1.7778549194336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian River' limit 1
loadtime:1.7779459953308 / seconds
Query Executed:select id FROM `mi` where city='Indian River' && SIC_code='5531'DB:business_master_new
loadtime:1.7815680503845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ingalls' limit 1
loadtime:1.7816479206085 / seconds
Query Executed:select id FROM `mi` where city='Ingalls' && SIC_code='5531'DB:business_master_new
loadtime:1.7821481227875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inkster' limit 1
loadtime:1.7822110652924 / seconds
Query Executed:select id FROM `mi` where city='Inkster' && SIC_code='5531'DB:business_master_new
loadtime:1.7852458953857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interlochen' limit 1
loadtime:1.7853219509125 / seconds
Query Executed:select id FROM `mi` where city='Interlochen' && SIC_code='5531'DB:business_master_new
loadtime:1.788204908371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:1.7882809638977 / seconds
Query Executed:select id FROM `mi` where city='Ionia' && SIC_code='5531'DB:business_master_new
loadtime:1.796854019165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:1.7969529628754 / seconds
Query Executed:select id FROM `mi` where city='Ira' && SIC_code='5531'DB:business_master_new
loadtime:1.7974779605865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Mountain' limit 1
loadtime:1.7975430488586 / seconds
Query Executed:select id FROM `mi` where city='Iron Mountain' && SIC_code='5531'DB:business_master_new
loadtime:1.808219909668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron River' limit 1
loadtime:1.8083081245422 / seconds
Query Executed:select id FROM `mi` where city='Iron River' && SIC_code='5531'DB:business_master_new
loadtime:1.812273979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irons' limit 1
loadtime:1.8123559951782 / seconds
Query Executed:select id FROM `mi` where city='Irons' && SIC_code='5531'DB:business_master_new
loadtime:1.8134639263153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironwood' limit 1
loadtime:1.8135271072388 / seconds
Query Executed:select id FROM `mi` where city='Ironwood' && SIC_code='5531'DB:business_master_new
loadtime:1.8203749656677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ishpeming' limit 1
loadtime:1.8204569816589 / seconds
Query Executed:select id FROM `mi` where city='Ishpeming' && SIC_code='5531'DB:business_master_new
loadtime:1.8263521194458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ithaca' limit 1
loadtime:1.8264360427856 / seconds
Query Executed:select id FROM `mi` where city='Ithaca' && SIC_code='5531'DB:business_master_new
loadtime:1.8312120437622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.8313241004944 / seconds
Query Executed:select id FROM `mi` where city='Jackson' && SIC_code='5531'DB:business_master_new
loadtime:1.8736040592194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:1.8737421035767 / seconds
Query Executed:select id FROM `mi` where city='Jamestown' && SIC_code='5531'DB:business_master_new
loadtime:1.874361038208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jasper' limit 1
loadtime:1.8744211196899 / seconds
Query Executed:select id FROM `mi` where city='Jasper' && SIC_code='5531'DB:business_master_new
loadtime:1.8752279281616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeddo' limit 1
loadtime:1.8752820491791 / seconds
Query Executed:select id FROM `mi` where city='Jeddo' && SIC_code='5531'DB:business_master_new
loadtime:1.8764410018921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jenison' limit 1
loadtime:1.8764951229095 / seconds
Query Executed:select id FROM `mi` where city='Jenison' && SIC_code='5531'DB:business_master_new
loadtime:1.8873410224915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:1.8874199390411 / seconds
Query Executed:select id FROM `mi` where city='Jerome' && SIC_code='5531'DB:business_master_new
loadtime:1.8885231018066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johannesburg' limit 1
loadtime:1.8886320590973 / seconds
Query Executed:select id FROM `mi` where city='Johannesburg' && SIC_code='5531'DB:business_master_new
loadtime:1.8892660140991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jones' limit 1
loadtime:1.8893489837646 / seconds
Query Executed:select id FROM `mi` where city='Jones' && SIC_code='5531'DB:business_master_new
loadtime:1.8902680873871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:1.8903489112854 / seconds
Query Executed:select id FROM `mi` where city='Jonesville' && SIC_code='5531'DB:business_master_new
loadtime:1.8935809135437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalamazoo' limit 1
loadtime:1.8936550617218 / seconds
Query Executed:select id FROM `mi` where city='Kalamazoo' && SIC_code='5531'DB:business_master_new
loadtime:1.9124460220337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaleva' limit 1
loadtime:1.9125699996948 / seconds
Query Executed:select id FROM `mi` where city='Kaleva' && SIC_code='5531'DB:business_master_new
loadtime:1.9138901233673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalkaska' limit 1
loadtime:1.9139540195465 / seconds
Query Executed:select id FROM `mi` where city='Kalkaska' && SIC_code='5531'DB:business_master_new
loadtime:1.9205338954926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Karlin' limit 1
loadtime:1.9206058979034 / seconds
Query Executed:select id FROM `mi` where city='Karlin' && SIC_code='5531'DB:business_master_new
loadtime:1.9210469722748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kawkawlin' limit 1
loadtime:1.9211030006409 / seconds
Query Executed:select id FROM `mi` where city='Kawkawlin' && SIC_code='5531'DB:business_master_new
loadtime:1.9234850406647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:1.9235510826111 / seconds
Query Executed:select id FROM `mi` where city='Kearsarge' && SIC_code='5531'DB:business_master_new
loadtime:1.9239630699158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keego Harbor' limit 1
loadtime:1.9240159988403 / seconds
Query Executed:select id FROM `mi` where city='Keego Harbor' && SIC_code='5531'DB:business_master_new
loadtime:1.9297919273376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall' limit 1
loadtime:1.9298639297485 / seconds
Query Executed:select id FROM `mi` where city='Kendall' && SIC_code='5531'DB:business_master_new
loadtime:1.9302849769592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenockee' limit 1
loadtime:1.9303390979767 / seconds
Query Executed:select id FROM `mi` where city='Kenockee' && SIC_code='5531'DB:business_master_new
loadtime:1.9307210445404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent City' limit 1
loadtime:1.930783033371 / seconds
Query Executed:select id FROM `mi` where city='Kent City' && SIC_code='5531'DB:business_master_new
loadtime:1.9326930046082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kentwood' limit 1
loadtime:1.9327459335327 / seconds
Query Executed:select id FROM `mi` where city='Kentwood' && SIC_code='5531'DB:business_master_new
loadtime:1.9333279132843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kewadin' limit 1
loadtime:1.9333820343018 / seconds
Query Executed:select id FROM `mi` where city='Kewadin' && SIC_code='5531'DB:business_master_new
loadtime:1.9346139431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keweenaw Bay' limit 1
loadtime:1.934681892395 / seconds
Query Executed:select id FROM `mi` where city='Keweenaw Bay' && SIC_code='5531'DB:business_master_new
loadtime:1.9351351261139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:1.9351890087128 / seconds
Query Executed:select id FROM `mi` where city='Kimball' && SIC_code='5531'DB:business_master_new
loadtime:1.9356329441071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kincheloe' limit 1
loadtime:1.935683965683 / seconds
Query Executed:select id FROM `mi` where city='Kincheloe' && SIC_code='5531'DB:business_master_new
loadtime:1.9369781017303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinde' limit 1
loadtime:1.9370439052582 / seconds
Query Executed:select id FROM `mi` where city='Kinde' && SIC_code='5531'DB:business_master_new
loadtime:1.9381189346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsford' limit 1
loadtime:1.9381880760193 / seconds
Query Executed:select id FROM `mi` where city='Kingsford' && SIC_code='5531'DB:business_master_new
loadtime:1.9415669441223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:1.9416379928589 / seconds
Query Executed:select id FROM `mi` where city='Kingsley' && SIC_code='5531'DB:business_master_new
loadtime:1.9445719718933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.9446420669556 / seconds
Query Executed:select id FROM `mi` where city='Kingston' && SIC_code='5531'DB:business_master_new
loadtime:1.9460039138794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:1.9460589885712 / seconds
Query Executed:select id FROM `mi` where city='Kinross' && SIC_code='5531'DB:business_master_new
loadtime:1.946818113327 / seconds
Query loaded from cache:select * from geodata_geocity where city='L Anse' limit 1
loadtime:1.9468700885773 / seconds
Query Executed:select id FROM `mi` where city='L Anse' && SIC_code='5531'DB:business_master_new
loadtime:1.947340965271 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Salle' limit 1
loadtime:1.9473950862885 / seconds
Query Executed:select id FROM `mi` where city='La Salle' && SIC_code='5531'DB:business_master_new
loadtime:1.948755979538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lachine' limit 1
loadtime:1.9488170146942 / seconds
Query Executed:select id FROM `mi` where city='Lachine' && SIC_code='5531'DB:business_master_new
loadtime:1.9499320983887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacota' limit 1
loadtime:1.9499909877777 / seconds
Query Executed:select id FROM `mi` where city='Lacota' && SIC_code='5531'DB:business_master_new
loadtime:1.9504189491272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laingsburg' limit 1
loadtime:1.9504709243774 / seconds
Query Executed:select id FROM `mi` where city='Laingsburg' && SIC_code='5531'DB:business_master_new
loadtime:1.9532520771027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:1.9533219337463 / seconds
Query Executed:select id FROM `mi` where city='Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.9547259807587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Angelus' limit 1
loadtime:1.9548010826111 / seconds
Query Executed:select id FROM `mi` where city='Lake Angelus' && SIC_code='5531'DB:business_master_new
loadtime:1.9552450180054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Ann' limit 1
loadtime:1.9552989006042 / seconds
Query Executed:select id FROM `mi` where city='Lake Ann' && SIC_code='5531'DB:business_master_new
loadtime:1.9567348957062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:1.9567959308624 / seconds
Query Executed:select id FROM `mi` where city='Lake City' && SIC_code='5531'DB:business_master_new
loadtime:1.960529088974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake George' limit 1
loadtime:1.9606049060822 / seconds
Query Executed:select id FROM `mi` where city='Lake George' && SIC_code='5531'DB:business_master_new
loadtime:1.9612019062042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Leelanau' limit 1
loadtime:1.961256980896 / seconds
Query Executed:select id FROM `mi` where city='Lake Leelanau' && SIC_code='5531'DB:business_master_new
loadtime:1.9628899097443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Linden' limit 1
loadtime:1.9629619121552 / seconds
Query Executed:select id FROM `mi` where city='Lake Linden' && SIC_code='5531'DB:business_master_new
loadtime:1.9643459320068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Odessa' limit 1
loadtime:1.9644000530243 / seconds
Query Executed:select id FROM `mi` where city='Lake Odessa' && SIC_code='5531'DB:business_master_new
loadtime:1.9672780036926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Orion' limit 1
loadtime:1.9673459529877 / seconds
Query Executed:select id FROM `mi` where city='Lake Orion' && SIC_code='5531'DB:business_master_new
loadtime:1.9817929267883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeland' limit 1
loadtime:1.9818820953369 / seconds
Query Executed:select id FROM `mi` where city='Lakeland' && SIC_code='5531'DB:business_master_new
loadtime:1.9828341007233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeport' limit 1
loadtime:1.9828898906708 / seconds
Query Executed:select id FROM `mi` where city='Lakeport' && SIC_code='5531'DB:business_master_new
loadtime:1.9834361076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:1.9834890365601 / seconds
Query Executed:select id FROM `mi` where city='Lakeside' && SIC_code='5531'DB:business_master_new
loadtime:1.984472990036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:1.9845249652863 / seconds
Query Executed:select id FROM `mi` where city='Lakeview' && SIC_code='5531'DB:business_master_new
loadtime:1.9879200458527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.9880061149597 / seconds
Query Executed:select id FROM `mi` where city='Lakeville' && SIC_code='5531'DB:business_master_new
loadtime:1.9885809421539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambertville' limit 1
loadtime:1.9886360168457 / seconds
Query Executed:select id FROM `mi` where city='Lambertville' && SIC_code='5531'DB:business_master_new
loadtime:1.9936950206757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:1.993772983551 / seconds
Query Executed:select id FROM `mi` where city='Lamont' && SIC_code='5531'DB:business_master_new
loadtime:1.9942660331726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanse' limit 1
loadtime:1.9943199157715 / seconds
Query Executed:select id FROM `mi` where city='Lanse' && SIC_code='5531'DB:business_master_new
loadtime:1.9973409175873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:1.9974110126495 / seconds
Query Executed:select id FROM `mi` where city='Lansing' && SIC_code='5531'DB:business_master_new
loadtime:2.0164079666138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapeer' limit 1
loadtime:2.0165491104126 / seconds
Query Executed:select id FROM `mi` where city='Lapeer' && SIC_code='5531'DB:business_master_new
loadtime:2.0325949192047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lathrup Village' limit 1
loadtime:2.0326819419861 / seconds
Query Executed:select id FROM `mi` where city='Lathrup Village' && SIC_code='5531'DB:business_master_new
loadtime:2.0337219238281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurium' limit 1
loadtime:2.0337870121002 / seconds
Query Executed:select id FROM `mi` where city='Laurium' && SIC_code='5531'DB:business_master_new
loadtime:2.0342619419098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:2.0343151092529 / seconds
Query Executed:select id FROM `mi` where city='Lawrence' && SIC_code='5531'DB:business_master_new
loadtime:2.036062002182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:2.0361149311066 / seconds
Query Executed:select id FROM `mi` where city='Lawton' && SIC_code='5531'DB:business_master_new
loadtime:2.0384349822998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Roy' limit 1
loadtime:2.0384891033173 / seconds
Query Executed:select id FROM `mi` where city='Le Roy' && SIC_code='5531'DB:business_master_new
loadtime:2.0388920307159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:2.0389499664307 / seconds
Query Executed:select id FROM `mi` where city='Leland' && SIC_code='5531'DB:business_master_new
loadtime:2.0404419898987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennon' limit 1
loadtime:2.0404949188232 / seconds
Query Executed:select id FROM `mi` where city='Lennon' && SIC_code='5531'DB:business_master_new
loadtime:2.04181599617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:2.0418701171875 / seconds
Query Executed:select id FROM `mi` where city='Lenox' && SIC_code='5531'DB:business_master_new
loadtime:2.0424299240112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonard' limit 1
loadtime:2.0424830913544 / seconds
Query Executed:select id FROM `mi` where city='Leonard' && SIC_code='5531'DB:business_master_new
loadtime:2.0443859100342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonidas' limit 1
loadtime:2.0444390773773 / seconds
Query Executed:select id FROM `mi` where city='Leonidas' && SIC_code='5531'DB:business_master_new
loadtime:2.0449879169464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leroy' limit 1
loadtime:2.0450420379639 / seconds
Query Executed:select id FROM `mi` where city='Leroy' && SIC_code='5531'DB:business_master_new
loadtime:2.0462651252747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leslie' limit 1
loadtime:2.0463321208954 / seconds
Query Executed:select id FROM `mi` where city='Leslie' && SIC_code='5531'DB:business_master_new
loadtime:2.0490849018097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levering' limit 1
loadtime:2.0491540431976 / seconds
Query Executed:select id FROM `mi` where city='Levering' && SIC_code='5531'DB:business_master_new
loadtime:2.0501849651337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:2.0502529144287 / seconds
Query Executed:select id FROM `mi` where city='Lewiston' && SIC_code='5531'DB:business_master_new
loadtime:2.051342010498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:2.0513970851898 / seconds
Query Executed:select id FROM `mi` where city='Lexington' && SIC_code='5531'DB:business_master_new
loadtime:2.0542590618134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Limestone' limit 1
loadtime:2.0543129444122 / seconds
Query Executed:select id FROM `mi` where city='Limestone' && SIC_code='5531'DB:business_master_new
loadtime:2.0546779632568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:2.0547289848328 / seconds
Query Executed:select id FROM `mi` where city='Lincoln' && SIC_code='5531'DB:business_master_new
loadtime:2.056333065033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln Park' limit 1
loadtime:2.0563869476318 / seconds
Query Executed:select id FROM `mi` where city='Lincoln Park' && SIC_code='5531'DB:business_master_new
loadtime:2.0618500709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:2.0619220733643 / seconds
Query Executed:select id FROM `mi` where city='Linden' && SIC_code='5531'DB:business_master_new
loadtime:2.0676538944244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:2.0677089691162 / seconds
Query Executed:select id FROM `mi` where city='Linwood' && SIC_code='5531'DB:business_master_new
loadtime:2.0697939395905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:2.0698621273041 / seconds
Query Executed:select id FROM `mi` where city='Litchfield' && SIC_code='5531'DB:business_master_new
loadtime:2.0716578960419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Lake' limit 1
loadtime:2.0717120170593 / seconds
Query Executed:select id FROM `mi` where city='Little Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.072231054306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livonia' limit 1
loadtime:2.0722839832306 / seconds
Query Executed:select id FROM `mi` where city='Livonia' && SIC_code='5531'DB:business_master_new
loadtime:2.0949809551239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Lake' limit 1
loadtime:2.095055103302 / seconds
Query Executed:select id FROM `mi` where city='Long Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.0955429077148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loretto' limit 1
loadtime:2.0956070423126 / seconds
Query Executed:select id FROM `mi` where city='Loretto' && SIC_code='5531'DB:business_master_new
loadtime:2.0960650444031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:2.0961179733276 / seconds
Query Executed:select id FROM `mi` where city='Lowell' && SIC_code='5531'DB:business_master_new
loadtime:2.1037108898163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludington' limit 1
loadtime:2.1037909984589 / seconds
Query Executed:select id FROM `mi` where city='Ludington' && SIC_code='5531'DB:business_master_new
loadtime:2.1153469085693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luna Pier' limit 1
loadtime:2.1154189109802 / seconds
Query Executed:select id FROM `mi` where city='Luna Pier' && SIC_code='5531'DB:business_master_new
loadtime:2.1162149906158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:2.1162700653076 / seconds
Query Executed:select id FROM `mi` where city='Lupton' && SIC_code='5531'DB:business_master_new
loadtime:2.1171560287476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:2.1172089576721 / seconds
Query Executed:select id FROM `mi` where city='Luther' && SIC_code='5531'DB:business_master_new
loadtime:2.1180679798126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:2.1181209087372 / seconds
Query Executed:select id FROM `mi` where city='Luzerne' && SIC_code='5531'DB:business_master_new
loadtime:2.1187679767609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:2.1188199520111 / seconds
Query Executed:select id FROM `mi` where city='Lynn' && SIC_code='5531'DB:business_master_new
loadtime:2.1192190647125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:2.1192729473114 / seconds
Query Executed:select id FROM `mi` where city='Lyons' && SIC_code='5531'DB:business_master_new
loadtime:2.1201779842377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macatawa' limit 1
loadtime:2.1202299594879 / seconds
Query Executed:select id FROM `mi` where city='Macatawa' && SIC_code='5531'DB:business_master_new
loadtime:2.1207818984985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinac Island' limit 1
loadtime:2.1208341121674 / seconds
Query Executed:select id FROM `mi` where city='Mackinac Island' && SIC_code='5531'DB:business_master_new
loadtime:2.1230449676514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mackinaw City' limit 1
loadtime:2.1230978965759 / seconds
Query Executed:select id FROM `mi` where city='Mackinaw City' && SIC_code='5531'DB:business_master_new
loadtime:2.1262359619141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macomb' limit 1
loadtime:2.1262879371643 / seconds
Query Executed:select id FROM `mi` where city='Macomb' && SIC_code='5531'DB:business_master_new
loadtime:2.1407630443573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison Heights' limit 1
loadtime:2.1408369541168 / seconds
Query Executed:select id FROM `mi` where city='Madison Heights' && SIC_code='5531'DB:business_master_new
loadtime:2.1591689586639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mancelona' limit 1
loadtime:2.1592619419098 / seconds
Query Executed:select id FROM `mi` where city='Mancelona' && SIC_code='5531'DB:business_master_new
loadtime:2.1635739803314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:2.163645029068 / seconds
Query Executed:select id FROM `mi` where city='Manchester' && SIC_code='5531'DB:business_master_new
loadtime:2.1658051013947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistee' limit 1
loadtime:2.1658589839935 / seconds
Query Executed:select id FROM `mi` where city='Manistee' && SIC_code='5531'DB:business_master_new
loadtime:2.1750891208649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manistique' limit 1
loadtime:2.1751599311829 / seconds
Query Executed:select id FROM `mi` where city='Manistique' && SIC_code='5531'DB:business_master_new
loadtime:2.1769680976868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manitou Beach' limit 1
loadtime:2.1770350933075 / seconds
Query Executed:select id FROM `mi` where city='Manitou Beach' && SIC_code='5531'DB:business_master_new
loadtime:2.1784949302673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manton' limit 1
loadtime:2.1785480976105 / seconds
Query Executed:select id FROM `mi` where city='Manton' && SIC_code='5531'DB:business_master_new
loadtime:2.180673122406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple City' limit 1
loadtime:2.1807420253754 / seconds
Query Executed:select id FROM `mi` where city='Maple City' && SIC_code='5531'DB:business_master_new
loadtime:2.1823089122772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Rapids' limit 1
loadtime:2.1823630332947 / seconds
Query Executed:select id FROM `mi` where city='Maple Rapids' && SIC_code='5531'DB:business_master_new
loadtime:2.1830489635468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcellus' limit 1
loadtime:2.183100938797 / seconds
Query Executed:select id FROM `mi` where city='Marcellus' && SIC_code='5531'DB:business_master_new
loadtime:2.1850769519806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marenisco' limit 1
loadtime:2.1851460933685 / seconds
Query Executed:select id FROM `mi` where city='Marenisco' && SIC_code='5531'DB:business_master_new
loadtime:2.1858711242676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marine City' limit 1
loadtime:2.1859290599823 / seconds
Query Executed:select id FROM `mi` where city='Marine City' && SIC_code='5531'DB:business_master_new
loadtime:2.191447019577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:2.1915171146393 / seconds
Query Executed:select id FROM `mi` where city='Marion' && SIC_code='5531'DB:business_master_new
loadtime:2.1936230659485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlette' limit 1
loadtime:2.1936891078949 / seconds
Query Executed:select id FROM `mi` where city='Marlette' && SIC_code='5531'DB:business_master_new
loadtime:2.1985259056091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:2.1985960006714 / seconds
Query Executed:select id FROM `mi` where city='Marne' && SIC_code='5531'DB:business_master_new
loadtime:2.2005059719086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:2.2005729675293 / seconds
Query Executed:select id FROM `mi` where city='Marquette' && SIC_code='5531'DB:business_master_new
loadtime:2.2191829681396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:2.2192668914795 / seconds
Query Executed:select id FROM `mi` where city='Marshall' && SIC_code='5531'DB:business_master_new
loadtime:2.2290449142456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:2.2291219234467 / seconds
Query Executed:select id FROM `mi` where city='Martin' && SIC_code='5531'DB:business_master_new
loadtime:2.2304780483246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysville' limit 1
loadtime:2.2305319309235 / seconds
Query Executed:select id FROM `mi` where city='Marysville' && SIC_code='5531'DB:business_master_new
loadtime:2.2363970279694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:2.2364671230316 / seconds
Query Executed:select id FROM `mi` where city='Mason' && SIC_code='5531'DB:business_master_new
loadtime:2.2466280460358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mass City' limit 1
loadtime:2.2467060089111 / seconds
Query Executed:select id FROM `mi` where city='Mass City' && SIC_code='5531'DB:business_master_new
loadtime:2.2472081184387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattawan' limit 1
loadtime:2.2472629547119 / seconds
Query Executed:select id FROM `mi` where city='Mattawan' && SIC_code='5531'DB:business_master_new
loadtime:2.2506079673767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maybee' limit 1
loadtime:2.250678062439 / seconds
Query Executed:select id FROM `mi` where city='Maybee' && SIC_code='5531'DB:business_master_new
loadtime:2.2520139217377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:2.2520899772644 / seconds
Query Executed:select id FROM `mi` where city='Mayfield' && SIC_code='5531'DB:business_master_new
loadtime:2.2525749206543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayville' limit 1
loadtime:2.2526268959045 / seconds
Query Executed:select id FROM `mi` where city='Mayville' && SIC_code='5531'DB:business_master_new
loadtime:2.2544169425964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Bain' limit 1
loadtime:2.2544829845428 / seconds
Query Executed:select id FROM `mi` where city='Mc Bain' && SIC_code='5531'DB:business_master_new
loadtime:2.2563591003418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Millan' limit 1
loadtime:2.2564270496368 / seconds
Query Executed:select id FROM `mi` where city='Mc Millan' && SIC_code='5531'DB:business_master_new
loadtime:2.2572901248932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcbrides' limit 1
loadtime:2.2573449611664 / seconds
Query Executed:select id FROM `mi` where city='Mcbrides' && SIC_code='5531'DB:business_master_new
loadtime:2.2579019069672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mears' limit 1
loadtime:2.2579591274261 / seconds
Query Executed:select id FROM `mi` where city='Mears' && SIC_code='5531'DB:business_master_new
loadtime:2.2591729164124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mecosta' limit 1
loadtime:2.259241104126 / seconds
Query Executed:select id FROM `mi` where city='Mecosta' && SIC_code='5531'DB:business_master_new
loadtime:2.260792016983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:2.2608590126038 / seconds
Query Executed:select id FROM `mi` where city='Melvin' && SIC_code='5531'DB:business_master_new
loadtime:2.2616291046143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvindale' limit 1
loadtime:2.2616829872131 / seconds
Query Executed:select id FROM `mi` where city='Melvindale' && SIC_code='5531'DB:business_master_new
loadtime:2.2634520530701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Memphis' limit 1
loadtime:2.2635049819946 / seconds
Query Executed:select id FROM `mi` where city='Memphis' && SIC_code='5531'DB:business_master_new
loadtime:2.265566110611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:2.265634059906 / seconds
Query Executed:select id FROM `mi` where city='Mendon' && SIC_code='5531'DB:business_master_new
loadtime:2.2666430473328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menominee' limit 1
loadtime:2.2666981220245 / seconds
Query Executed:select id FROM `mi` where city='Menominee' && SIC_code='5531'DB:business_master_new
loadtime:2.2739050388336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:2.2739770412445 / seconds
Query Executed:select id FROM `mi` where city='Merrill' && SIC_code='5531'DB:business_master_new
loadtime:2.2756218910217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:2.2756900787354 / seconds
Query Executed:select id FROM `mi` where city='Merritt' && SIC_code='5531'DB:business_master_new
loadtime:2.276328086853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesick' limit 1
loadtime:2.2763819694519 / seconds
Query Executed:select id FROM `mi` where city='Mesick' && SIC_code='5531'DB:business_master_new
loadtime:2.2782919406891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metamora' limit 1
loadtime:2.2783589363098 / seconds
Query Executed:select id FROM `mi` where city='Metamora' && SIC_code='5531'DB:business_master_new
loadtime:2.2819390296936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michiana' limit 1
loadtime:2.2819941043854 / seconds
Query Executed:select id FROM `mi` where city='Michiana' && SIC_code='5531'DB:business_master_new
loadtime:2.2823650836945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigamme' limit 1
loadtime:2.2824170589447 / seconds
Query Executed:select id FROM `mi` where city='Michigamme' && SIC_code='5531'DB:business_master_new
loadtime:2.2831680774689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan Center' limit 1
loadtime:2.2832210063934 / seconds
Query Executed:select id FROM `mi` where city='Michigan Center' && SIC_code='5531'DB:business_master_new
loadtime:2.2852890491486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:2.285355091095 / seconds
Query Executed:select id FROM `mi` where city='Middleton' && SIC_code='5531'DB:business_master_new
loadtime:2.2861258983612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleville' limit 1
loadtime:2.2861800193787 / seconds
Query Executed:select id FROM `mi` where city='Middleville' && SIC_code='5531'DB:business_master_new
loadtime:2.2910749912262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:2.2911438941956 / seconds
Query Executed:select id FROM `mi` where city='Midland' && SIC_code='5531'DB:business_master_new
loadtime:2.318363904953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mikado' limit 1
loadtime:2.3184559345245 / seconds
Query Executed:select id FROM `mi` where city='Mikado' && SIC_code='5531'DB:business_master_new
loadtime:2.3194019794464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:2.3194580078125 / seconds
Query Executed:select id FROM `mi` where city='Milan' && SIC_code='5531'DB:business_master_new
loadtime:2.3219299316406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:2.3219840526581 / seconds
Query Executed:select id FROM `mi` where city='Milford' && SIC_code='5531'DB:business_master_new
loadtime:2.3343539237976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:2.3344240188599 / seconds
Query Executed:select id FROM `mi` where city='Millersburg' && SIC_code='5531'DB:business_master_new
loadtime:2.3357660770416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millington' limit 1
loadtime:2.3358209133148 / seconds
Query Executed:select id FROM `mi` where city='Millington' && SIC_code='5531'DB:business_master_new
loadtime:2.3421990871429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden City' limit 1
loadtime:2.3422689437866 / seconds
Query Executed:select id FROM `mi` where city='Minden City' && SIC_code='5531'DB:business_master_new
loadtime:2.3434109687805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mio' limit 1
loadtime:2.3434660434723 / seconds
Query Executed:select id FROM `mi` where city='Mio' && SIC_code='5531'DB:business_master_new
loadtime:2.3485279083252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohawk' limit 1
loadtime:2.3486111164093 / seconds
Query Executed:select id FROM `mi` where city='Mohawk' && SIC_code='5531'DB:business_master_new
loadtime:2.3495359420776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moline' limit 1
loadtime:2.3495919704437 / seconds
Query Executed:select id FROM `mi` where city='Moline' && SIC_code='5531'DB:business_master_new
loadtime:2.3502089977264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.3502631187439 / seconds
Query Executed:select id FROM `mi` where city='Monroe' && SIC_code='5531'DB:business_master_new
loadtime:2.3729639053345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:2.3730580806732 / seconds
Query Executed:select id FROM `mi` where city='Montague' && SIC_code='5531'DB:business_master_new
loadtime:2.3761179447174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:2.376188993454 / seconds
Query Executed:select id FROM `mi` where city='Montgomery' && SIC_code='5531'DB:business_master_new
loadtime:2.3770940303802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:2.3771500587463 / seconds
Query Executed:select id FROM `mi` where city='Montrose' && SIC_code='5531'DB:business_master_new
loadtime:2.380175113678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moran' limit 1
loadtime:2.3802449703217 / seconds
Query Executed:select id FROM `mi` where city='Moran' && SIC_code='5531'DB:business_master_new
loadtime:2.3809719085693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:2.3810389041901 / seconds
Query Executed:select id FROM `mi` where city='Morenci' && SIC_code='5531'DB:business_master_new
loadtime:2.382926940918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:2.3830010890961 / seconds
Query Executed:select id FROM `mi` where city='Morley' && SIC_code='5531'DB:business_master_new
loadtime:2.38423204422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrice' limit 1
loadtime:2.3842990398407 / seconds
Query Executed:select id FROM `mi` where city='Morrice' && SIC_code='5531'DB:business_master_new
loadtime:2.3856570720673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:2.3857109546661 / seconds
Query Executed:select id FROM `mi` where city='Moscow' && SIC_code='5531'DB:business_master_new
loadtime:2.3862020969391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mosherville' limit 1
loadtime:2.3862550258636 / seconds
Query Executed:select id FROM `mi` where city='Mosherville' && SIC_code='5531'DB:business_master_new
loadtime:2.3867471218109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Clemens' limit 1
loadtime:2.3868079185486 / seconds
Query Executed:select id FROM `mi` where city='Mount Clemens' && SIC_code='5531'DB:business_master_new
loadtime:2.4007370471954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Morris' limit 1
loadtime:2.4008250236511 / seconds
Query Executed:select id FROM `mi` where city='Mount Morris' && SIC_code='5531'DB:business_master_new
loadtime:2.4088070392609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:2.4088840484619 / seconds
Query Executed:select id FROM `mi` where city='Mount Pleasant' && SIC_code='5531'DB:business_master_new
loadtime:2.4286379814148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Clemens' limit 1
loadtime:2.4287259578705 / seconds
Query Executed:select id FROM `mi` where city='Mt Clemens' && SIC_code='5531'DB:business_master_new
loadtime:2.4295229911804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Morris' limit 1
loadtime:2.4295799732208 / seconds
Query Executed:select id FROM `mi` where city='Mt Morris' && SIC_code='5531'DB:business_master_new
loadtime:2.4300210475922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:2.4300739765167 / seconds
Query Executed:select id FROM `mi` where city='Mt Pleasant' && SIC_code='5531'DB:business_master_new
loadtime:2.4311990737915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muir' limit 1
loadtime:2.4312520027161 / seconds
Query Executed:select id FROM `mi` where city='Muir' && SIC_code='5531'DB:business_master_new
loadtime:2.4320390224457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullett Lake' limit 1
loadtime:2.4320929050446 / seconds
Query Executed:select id FROM `mi` where city='Mullett Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.4324939250946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulliken' limit 1
loadtime:2.4325459003448 / seconds
Query Executed:select id FROM `mi` where city='Mulliken' && SIC_code='5531'DB:business_master_new
loadtime:2.4335179328918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munger' limit 1
loadtime:2.4335849285126 / seconds
Query Executed:select id FROM `mi` where city='Munger' && SIC_code='5531'DB:business_master_new
loadtime:2.4344899654388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munising' limit 1
loadtime:2.4345440864563 / seconds
Query Executed:select id FROM `mi` where city='Munising' && SIC_code='5531'DB:business_master_new
loadtime:2.4395430088043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munith' limit 1
loadtime:2.4396131038666 / seconds
Query Executed:select id FROM `mi` where city='Munith' && SIC_code='5531'DB:business_master_new
loadtime:2.4408810138702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon' limit 1
loadtime:2.4409539699554 / seconds
Query Executed:select id FROM `mi` where city='Muskegon' && SIC_code='5531'DB:business_master_new
loadtime:2.459587097168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muskegon Heights' limit 1
loadtime:2.4596951007843 / seconds
Query Executed:select id FROM `mi` where city='Muskegon Heights' && SIC_code='5531'DB:business_master_new
loadtime:2.4601380825043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mussey' limit 1
loadtime:2.4601950645447 / seconds
Query Executed:select id FROM `mi` where city='Mussey' && SIC_code='5531'DB:business_master_new
loadtime:2.4606099128723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nadeau' limit 1
loadtime:2.4606621265411 / seconds
Query Executed:select id FROM `mi` where city='Nadeau' && SIC_code='5531'DB:business_master_new
loadtime:2.4611349105835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahma' limit 1
loadtime:2.4611880779266 / seconds
Query Executed:select id FROM `mi` where city='Nahma' && SIC_code='5531'DB:business_master_new
loadtime:2.4616351127625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Napoleon' limit 1
loadtime:2.461688041687 / seconds
Query Executed:select id FROM `mi` where city='Napoleon' && SIC_code='5531'DB:business_master_new
loadtime:2.4626688957214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:2.4627239704132 / seconds
Query Executed:select id FROM `mi` where city='Nashville' && SIC_code='5531'DB:business_master_new
loadtime:2.4646229743958 / seconds
Query loaded from cache:select * from geodata_geocity where city='National City' limit 1
loadtime:2.4646909236908 / seconds
Query Executed:select id FROM `mi` where city='National City' && SIC_code='5531'DB:business_master_new
loadtime:2.4656019210815 / seconds
Query loaded from cache:select * from geodata_geocity where city='National Mine' limit 1
loadtime:2.465656042099 / seconds
Query Executed:select id FROM `mi` where city='National Mine' && SIC_code='5531'DB:business_master_new
loadtime:2.4660708904266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naubinway' limit 1
loadtime:2.4661250114441 / seconds
Query Executed:select id FROM `mi` where city='Naubinway' && SIC_code='5531'DB:business_master_new
loadtime:2.4670190811157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazareth' limit 1
loadtime:2.467071056366 / seconds
Query Executed:select id FROM `mi` where city='Nazareth' && SIC_code='5531'DB:business_master_new
loadtime:2.4675669670105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Negaunee' limit 1
loadtime:2.4676179885864 / seconds
Query Executed:select id FROM `mi` where city='Negaunee' && SIC_code='5531'DB:business_master_new
loadtime:2.4710729122162 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Baltimore' limit 1
loadtime:2.4711561203003 / seconds
Query Executed:select id FROM `mi` where city='New Baltimore' && SIC_code='5531'DB:business_master_new
loadtime:2.4894449710846 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:2.4895339012146 / seconds
Query Executed:select id FROM `mi` where city='New Boston' && SIC_code='5531'DB:business_master_new
loadtime:2.4909820556641 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Buffalo' limit 1
loadtime:2.4910390377045 / seconds
Query Executed:select id FROM `mi` where city='New Buffalo' && SIC_code='5531'DB:business_master_new
loadtime:2.4965279102325 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Era' limit 1
loadtime:2.4965960979462 / seconds
Query Executed:select id FROM `mi` where city='New Era' && SIC_code='5531'DB:business_master_new
loadtime:2.4977989196777 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:2.4978549480438 / seconds
Query Executed:select id FROM `mi` where city='New Haven' && SIC_code='5531'DB:business_master_new
loadtime:2.5008230209351 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hudson' limit 1
loadtime:2.5008931159973 / seconds
Query Executed:select id FROM `mi` where city='New Hudson' && SIC_code='5531'DB:business_master_new
loadtime:2.50368309021 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lothrop' limit 1
loadtime:2.5037620067596 / seconds
Query Executed:select id FROM `mi` where city='New Lothrop' && SIC_code='5531'DB:business_master_new
loadtime:2.505136013031 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Troy' limit 1
loadtime:2.5052030086517 / seconds
Query Executed:select id FROM `mi` where city='New Troy' && SIC_code='5531'DB:business_master_new
loadtime:2.505774974823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newaygo' limit 1
loadtime:2.5058400630951 / seconds
Query Executed:select id FROM `mi` where city='Newaygo' && SIC_code='5531'DB:business_master_new
loadtime:2.5119359493256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newberry' limit 1
loadtime:2.5120069980621 / seconds
Query Executed:select id FROM `mi` where city='Newberry' && SIC_code='5531'DB:business_master_new
loadtime:2.5156810283661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:2.515762090683 / seconds
Query Executed:select id FROM `mi` where city='Newport' && SIC_code='5531'DB:business_master_new
loadtime:2.5183680057526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niles' limit 1
loadtime:2.5184381008148 / seconds
Query Executed:select id FROM `mi` where city='Niles' && SIC_code='5531'DB:business_master_new
loadtime:2.5343070030212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisula' limit 1
loadtime:2.534392118454 / seconds
Query Executed:select id FROM `mi` where city='Nisula' && SIC_code='5531'DB:business_master_new
loadtime:2.5348429679871 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:2.5348989963531 / seconds
Query Executed:select id FROM `mi` where city='North Adams' && SIC_code='5531'DB:business_master_new
loadtime:2.5359790325165 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branch' limit 1
loadtime:2.5360460281372 / seconds
Query Executed:select id FROM `mi` where city='North Branch' && SIC_code='5531'DB:business_master_new
loadtime:2.5402810573578 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Muskegon' limit 1
loadtime:2.5403490066528 / seconds
Query Executed:select id FROM `mi` where city='North Muskegon' && SIC_code='5531'DB:business_master_new
loadtime:2.5407750606537 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Star' limit 1
loadtime:2.5408289432526 / seconds
Query Executed:select id FROM `mi` where city='North Star' && SIC_code='5531'DB:business_master_new
loadtime:2.5412490367889 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Street' limit 1
loadtime:2.5413029193878 / seconds
Query Executed:select id FROM `mi` where city='North Street' && SIC_code='5531'DB:business_master_new
loadtime:2.5430829524994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northport' limit 1
loadtime:2.5431370735168 / seconds
Query Executed:select id FROM `mi` where city='Northport' && SIC_code='5531'DB:business_master_new
loadtime:2.5448439121246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:2.5448970794678 / seconds
Query Executed:select id FROM `mi` where city='Northville' && SIC_code='5531'DB:business_master_new
loadtime:2.5527410507202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norvell' limit 1
loadtime:2.5528171062469 / seconds
Query Executed:select id FROM `mi` where city='Norvell' && SIC_code='5531'DB:business_master_new
loadtime:2.5532710552216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:2.5533249378204 / seconds
Query Executed:select id FROM `mi` where city='Norway' && SIC_code='5531'DB:business_master_new
loadtime:2.5555920600891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottawa' limit 1
loadtime:2.5556631088257 / seconds
Query Executed:select id FROM `mi` where city='Nottawa' && SIC_code='5531'DB:business_master_new
loadtime:2.55610704422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Novi' limit 1
loadtime:2.5561621189117 / seconds
Query Executed:select id FROM `mi` where city='Novi' && SIC_code='5531'DB:business_master_new
loadtime:2.581864118576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunica' limit 1
loadtime:2.5819549560547 / seconds
Query Executed:select id FROM `mi` where city='Nunica' && SIC_code='5531'DB:business_master_new
loadtime:2.5839359760284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Grove' limit 1
loadtime:2.5840039253235 / seconds
Query Executed:select id FROM `mi` where city='Oak Grove' && SIC_code='5531'DB:business_master_new
loadtime:2.5844030380249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Park' limit 1
loadtime:2.5844550132751 / seconds
Query Executed:select id FROM `mi` where city='Oak Park' && SIC_code='5531'DB:business_master_new
loadtime:2.5987339019775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:2.5988159179688 / seconds
Query Executed:select id FROM `mi` where city='Oakland' && SIC_code='5531'DB:business_master_new
loadtime:2.6007699966431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland Twp' limit 1
loadtime:2.6008260250092 / seconds
Query Executed:select id FROM `mi` where city='Oakland Twp' && SIC_code='5531'DB:business_master_new
loadtime:2.601243019104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:2.6012959480286 / seconds
Query Executed:select id FROM `mi` where city='Oakley' && SIC_code='5531'DB:business_master_new
loadtime:2.6023099422455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oden' limit 1
loadtime:2.6023631095886 / seconds
Query Executed:select id FROM `mi` where city='Oden' && SIC_code='5531'DB:business_master_new
loadtime:2.6028881072998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okemos' limit 1
loadtime:2.6029450893402 / seconds
Query Executed:select id FROM `mi` where city='Okemos' && SIC_code='5531'DB:business_master_new
loadtime:2.6189000606537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mission' limit 1
loadtime:2.6189820766449 / seconds
Query Executed:select id FROM `mi` where city='Old Mission' && SIC_code='5531'DB:business_master_new
loadtime:2.6195430755615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:2.6195969581604 / seconds
Query Executed:select id FROM `mi` where city='Olivet' && SIC_code='5531'DB:business_master_new
loadtime:2.6212480068207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omena' limit 1
loadtime:2.6213140487671 / seconds
Query Executed:select id FROM `mi` where city='Omena' && SIC_code='5531'DB:business_master_new
loadtime:2.6218430995941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Omer' limit 1
loadtime:2.6218960285187 / seconds
Query Executed:select id FROM `mi` where city='Omer' && SIC_code='5531'DB:business_master_new
loadtime:2.6228809356689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaway' limit 1
loadtime:2.6229519844055 / seconds
Query Executed:select id FROM `mi` where city='Onaway' && SIC_code='5531'DB:business_master_new
loadtime:2.625333070755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onekama' limit 1
loadtime:2.6254050731659 / seconds
Query Executed:select id FROM `mi` where city='Onekama' && SIC_code='5531'DB:business_master_new
loadtime:2.6268289089203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onondaga' limit 1
loadtime:2.6268839836121 / seconds
Query Executed:select id FROM `mi` where city='Onondaga' && SIC_code='5531'DB:business_master_new
loadtime:2.6278789043427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onsted' limit 1
loadtime:2.6279389858246 / seconds
Query Executed:select id FROM `mi` where city='Onsted' && SIC_code='5531'DB:business_master_new
loadtime:2.630569934845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ontonagon' limit 1
loadtime:2.6306428909302 / seconds
Query Executed:select id FROM `mi` where city='Ontonagon' && SIC_code='5531'DB:business_master_new
loadtime:2.6320259571075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard Lake' limit 1
loadtime:2.632091999054 / seconds
Query Executed:select id FROM `mi` where city='Orchard Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.6324949264526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orion' limit 1
loadtime:2.6325480937958 / seconds
Query Executed:select id FROM `mi` where city='Orion' && SIC_code='5531'DB:business_master_new
loadtime:2.6329829692841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:2.6330370903015 / seconds
Query Executed:select id FROM `mi` where city='Orleans' && SIC_code='5531'DB:business_master_new
loadtime:2.6338419914246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortonville' limit 1
loadtime:2.6338939666748 / seconds
Query Executed:select id FROM `mi` where city='Ortonville' && SIC_code='5531'DB:business_master_new
loadtime:2.6407248973846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oscoda' limit 1
loadtime:2.6408040523529 / seconds
Query Executed:select id FROM `mi` where city='Oscoda' && SIC_code='5531'DB:business_master_new
loadtime:2.6477808952332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshtemo' limit 1
loadtime:2.6478540897369 / seconds
Query Executed:select id FROM `mi` where city='Oshtemo' && SIC_code='5531'DB:business_master_new
loadtime:2.6490890979767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osseo' limit 1
loadtime:2.6491560935974 / seconds
Query Executed:select id FROM `mi` where city='Osseo' && SIC_code='5531'DB:business_master_new
loadtime:2.6503989696503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossineke' limit 1
loadtime:2.650465965271 / seconds
Query Executed:select id FROM `mi` where city='Ossineke' && SIC_code='5531'DB:business_master_new
loadtime:2.6517810821533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otisville' limit 1
loadtime:2.6518490314484 / seconds
Query Executed:select id FROM `mi` where city='Otisville' && SIC_code='5531'DB:business_master_new
loadtime:2.6536910533905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otsego' limit 1
loadtime:2.6537680625916 / seconds
Query Executed:select id FROM `mi` where city='Otsego' && SIC_code='5531'DB:business_master_new
loadtime:2.6573359966278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottawa Lake' limit 1
loadtime:2.6574048995972 / seconds
Query Executed:select id FROM `mi` where city='Ottawa Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.6595981121063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otter Lake' limit 1
loadtime:2.6596651077271 / seconds
Query Executed:select id FROM `mi` where city='Otter Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.6605129241943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovid' limit 1
loadtime:2.6605679988861 / seconds
Query Executed:select id FROM `mi` where city='Ovid' && SIC_code='5531'DB:business_master_new
loadtime:2.66246509552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owendale' limit 1
loadtime:2.6625320911407 / seconds
Query Executed:select id FROM `mi` where city='Owendale' && SIC_code='5531'DB:business_master_new
loadtime:2.6633780002594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owosso' limit 1
loadtime:2.6634321212769 / seconds
Query Executed:select id FROM `mi` where city='Owosso' && SIC_code='5531'DB:business_master_new
loadtime:2.677768945694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:2.6778490543365 / seconds
Query Executed:select id FROM `mi` where city='Oxford' && SIC_code='5531'DB:business_master_new
loadtime:2.6890530586243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Painesdale' limit 1
loadtime:2.6891269683838 / seconds
Query Executed:select id FROM `mi` where city='Painesdale' && SIC_code='5531'DB:business_master_new
loadtime:2.6896650791168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:2.6897189617157 / seconds
Query Executed:select id FROM `mi` where city='Palmer' && SIC_code='5531'DB:business_master_new
loadtime:2.6902520656586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palms' limit 1
loadtime:2.6903049945831 / seconds
Query Executed:select id FROM `mi` where city='Palms' && SIC_code='5531'DB:business_master_new
loadtime:2.6908769607544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:2.6909370422363 / seconds
Query Executed:select id FROM `mi` where city='Palmyra' && SIC_code='5531'DB:business_master_new
loadtime:2.6916661262512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:2.6917319297791 / seconds
Query Executed:select id FROM `mi` where city='Palo' && SIC_code='5531'DB:business_master_new
loadtime:2.6921598911285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:2.692214012146 / seconds
Query Executed:select id FROM `mi` where city='Paradise' && SIC_code='5531'DB:business_master_new
loadtime:2.6932609081268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchment' limit 1
loadtime:2.69331407547 / seconds
Query Executed:select id FROM `mi` where city='Parchment' && SIC_code='5531'DB:business_master_new
loadtime:2.6937210559845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:2.6937820911407 / seconds
Query Executed:select id FROM `mi` where city='Paris' && SIC_code='5531'DB:business_master_new
loadtime:2.6949200630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parma' limit 1
loadtime:2.6949760913849 / seconds
Query Executed:select id FROM `mi` where city='Parma' && SIC_code='5531'DB:business_master_new
loadtime:2.6970589160919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Paw' limit 1
loadtime:2.6971120834351 / seconds
Query Executed:select id FROM `mi` where city='Paw Paw' && SIC_code='5531'DB:business_master_new
loadtime:2.7049369812012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peck' limit 1
loadtime:2.7050108909607 / seconds
Query Executed:select id FROM `mi` where city='Peck' && SIC_code='5531'DB:business_master_new
loadtime:2.7059910297394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelkie' limit 1
loadtime:2.7060589790344 / seconds
Query Executed:select id FROM `mi` where city='Pelkie' && SIC_code='5531'DB:business_master_new
loadtime:2.7066879272461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pellston' limit 1
loadtime:2.7067410945892 / seconds
Query Executed:select id FROM `mi` where city='Pellston' && SIC_code='5531'DB:business_master_new
loadtime:2.7080700397491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pentwater' limit 1
loadtime:2.7081780433655 / seconds
Query Executed:select id FROM `mi` where city='Pentwater' && SIC_code='5531'DB:business_master_new
loadtime:2.7103180885315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkins' limit 1
loadtime:2.7103719711304 / seconds
Query Executed:select id FROM `mi` where city='Perkins' && SIC_code='5531'DB:business_master_new
loadtime:2.7108809947968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perrinton' limit 1
loadtime:2.7109401226044 / seconds
Query Executed:select id FROM `mi` where city='Perrinton' && SIC_code='5531'DB:business_master_new
loadtime:2.7120039463043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perronville' limit 1
loadtime:2.712070941925 / seconds
Query Executed:select id FROM `mi` where city='Perronville' && SIC_code='5531'DB:business_master_new
loadtime:2.7124750614166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:2.7125270366669 / seconds
Query Executed:select id FROM `mi` where city='Perry' && SIC_code='5531'DB:business_master_new
loadtime:2.716943025589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersburg' limit 1
loadtime:2.71702003479 / seconds
Query Executed:select id FROM `mi` where city='Petersburg' && SIC_code='5531'DB:business_master_new
loadtime:2.7192380428314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petoskey' limit 1
loadtime:2.7193078994751 / seconds
Query Executed:select id FROM `mi` where city='Petoskey' && SIC_code='5531'DB:business_master_new
loadtime:2.7363629341125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pewamo' limit 1
loadtime:2.7364358901978 / seconds
Query Executed:select id FROM `mi` where city='Pewamo' && SIC_code='5531'DB:business_master_new
loadtime:2.7373559474945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickford' limit 1
loadtime:2.7374110221863 / seconds
Query Executed:select id FROM `mi` where city='Pickford' && SIC_code='5531'DB:business_master_new
loadtime:2.7385280132294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:2.7385931015015 / seconds
Query Executed:select id FROM `mi` where city='Pierson' && SIC_code='5531'DB:business_master_new
loadtime:2.7395749092102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pigeon' limit 1
loadtime:2.7396290302277 / seconds
Query Executed:select id FROM `mi` where city='Pigeon' && SIC_code='5531'DB:business_master_new
loadtime:2.742301940918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinckney' limit 1
loadtime:2.7423539161682 / seconds
Query Executed:select id FROM `mi` where city='Pinckney' && SIC_code='5531'DB:business_master_new
loadtime:2.7499289512634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinconning' limit 1
loadtime:2.7499990463257 / seconds
Query Executed:select id FROM `mi` where city='Pinconning' && SIC_code='5531'DB:business_master_new
loadtime:2.7549750804901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsford' limit 1
loadtime:2.7550439834595 / seconds
Query Executed:select id FROM `mi` where city='Pittsford' && SIC_code='5531'DB:business_master_new
loadtime:2.7562229633331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainwell' limit 1
loadtime:2.7562880516052 / seconds
Query Executed:select id FROM `mi` where city='Plainwell' && SIC_code='5531'DB:business_master_new
loadtime:2.7637770175934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Lake' limit 1
loadtime:2.7638490200043 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.764820098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Ridge' limit 1
loadtime:2.7648870944977 / seconds
Query Executed:select id FROM `mi` where city='Pleasant Ridge' && SIC_code='5531'DB:business_master_new
loadtime:2.7666549682617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:2.7667090892792 / seconds
Query Executed:select id FROM `mi` where city='Plymouth' && SIC_code='5531'DB:business_master_new
loadtime:2.7782690525055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pointe Aux Pins' limit 1
loadtime:2.7783401012421 / seconds
Query Executed:select id FROM `mi` where city='Pointe Aux Pins' && SIC_code='5531'DB:business_master_new
loadtime:2.7788939476013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompeii' limit 1
loadtime:2.7789599895477 / seconds
Query Executed:select id FROM `mi` where city='Pompeii' && SIC_code='5531'DB:business_master_new
loadtime:2.7793550491333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontiac' limit 1
loadtime:2.7794060707092 / seconds
Query Executed:select id FROM `mi` where city='Pontiac' && SIC_code='5531'DB:business_master_new
loadtime:2.8038821220398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Austin' limit 1
loadtime:2.8039810657501 / seconds
Query Executed:select id FROM `mi` where city='Port Austin' && SIC_code='5531'DB:business_master_new
loadtime:2.8059830665588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Hope' limit 1
loadtime:2.8060529232025 / seconds
Query Executed:select id FROM `mi` where city='Port Hope' && SIC_code='5531'DB:business_master_new
loadtime:2.807107925415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Huron' limit 1
loadtime:2.8071739673615 / seconds
Query Executed:select id FROM `mi` where city='Port Huron' && SIC_code='5531'DB:business_master_new
loadtime:2.8288550376892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Sanilac' limit 1
loadtime:2.8289430141449 / seconds
Query Executed:select id FROM `mi` where city='Port Sanilac' && SIC_code='5531'DB:business_master_new
loadtime:2.8304359912872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:2.830491065979 / seconds
Query Executed:select id FROM `mi` where city='Portage' && SIC_code='5531'DB:business_master_new
loadtime:2.8552050590515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:2.8552930355072 / seconds
Query Executed:select id FROM `mi` where city='Portland' && SIC_code='5531'DB:business_master_new
loadtime:2.86057305336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Posen' limit 1
loadtime:2.8606441020966 / seconds
Query Executed:select id FROM `mi` where city='Posen' && SIC_code='5531'DB:business_master_new
loadtime:2.8618249893188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potterville' limit 1
loadtime:2.8618810176849 / seconds
Query Executed:select id FROM `mi` where city='Potterville' && SIC_code='5531'DB:business_master_new
loadtime:2.8634839057922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powers' limit 1
loadtime:2.8635380268097 / seconds
Query Executed:select id FROM `mi` where city='Powers' && SIC_code='5531'DB:business_master_new
loadtime:2.8644881248474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:2.8645401000977 / seconds
Query Executed:select id FROM `mi` where city='Prescott' && SIC_code='5531'DB:business_master_new
loadtime:2.8662259578705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presque Isle' limit 1
loadtime:2.8662800788879 / seconds
Query Executed:select id FROM `mi` where city='Presque Isle' && SIC_code='5531'DB:business_master_new
loadtime:2.8672668933868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prudenville' limit 1
loadtime:2.8673341274261 / seconds
Query Executed:select id FROM `mi` where city='Prudenville' && SIC_code='5531'DB:business_master_new
loadtime:2.8685500621796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pullman' limit 1
loadtime:2.8686039447784 / seconds
Query Executed:select id FROM `mi` where city='Pullman' && SIC_code='5531'DB:business_master_new
loadtime:2.8697400093079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:2.8698010444641 / seconds
Query Executed:select id FROM `mi` where city='Quincy' && SIC_code='5531'DB:business_master_new
loadtime:2.8723258972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinnesec' limit 1
loadtime:2.8723950386047 / seconds
Query Executed:select id FROM `mi` where city='Quinnesec' && SIC_code='5531'DB:business_master_new
loadtime:2.8733410835266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:2.8733949661255 / seconds
Query Executed:select id FROM `mi` where city='Ralph' && SIC_code='5531'DB:business_master_new
loadtime:2.8738551139832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramsay' limit 1
loadtime:2.8739080429077 / seconds
Query Executed:select id FROM `mi` where city='Ramsay' && SIC_code='5531'DB:business_master_new
loadtime:2.8745009899139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:2.8745539188385 / seconds
Query Executed:select id FROM `mi` where city='Rapid City' && SIC_code='5531'DB:business_master_new
loadtime:2.8761110305786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid River' limit 1
loadtime:2.8761649131775 / seconds
Query Executed:select id FROM `mi` where city='Rapid River' && SIC_code='5531'DB:business_master_new
loadtime:2.8777430057526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravenna' limit 1
loadtime:2.8778169155121 / seconds
Query Executed:select id FROM `mi` where city='Ravenna' && SIC_code='5531'DB:business_master_new
loadtime:2.880049943924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ray' limit 1
loadtime:2.8801200389862 / seconds
Query Executed:select id FROM `mi` where city='Ray' && SIC_code='5531'DB:business_master_new
loadtime:2.8818681240082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:2.8819270133972 / seconds
Query Executed:select id FROM `mi` where city='Reading' && SIC_code='5531'DB:business_master_new
loadtime:2.8834240436554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redford' limit 1
loadtime:2.8834779262543 / seconds
Query Executed:select id FROM `mi` where city='Redford' && SIC_code='5531'DB:business_master_new
loadtime:2.8918569087982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reed City' limit 1
loadtime:2.8919351100922 / seconds
Query Executed:select id FROM `mi` where city='Reed City' && SIC_code='5531'DB:business_master_new
loadtime:2.8969299793243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reese' limit 1
loadtime:2.8970000743866 / seconds
Query Executed:select id FROM `mi` where city='Reese' && SIC_code='5531'DB:business_master_new
loadtime:2.8990259170532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remus' limit 1
loadtime:2.8990941047668 / seconds
Query Executed:select id FROM `mi` where city='Remus' && SIC_code='5531'DB:business_master_new
loadtime:2.9008700847626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Republic' limit 1
loadtime:2.9009439945221 / seconds
Query Executed:select id FROM `mi` where city='Republic' && SIC_code='5531'DB:business_master_new
loadtime:2.9017989635468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:2.9018518924713 / seconds
Query Executed:select id FROM `mi` where city='Rhodes' && SIC_code='5531'DB:business_master_new
loadtime:2.9025740623474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:2.9026260375977 / seconds
Query Executed:select id FROM `mi` where city='Richland' && SIC_code='5531'DB:business_master_new
loadtime:2.907567024231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:2.9076340198517 / seconds
Query Executed:select id FROM `mi` where city='Richmond' && SIC_code='5531'DB:business_master_new
loadtime:2.9135980606079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richville' limit 1
loadtime:2.9136691093445 / seconds
Query Executed:select id FROM `mi` where city='Richville' && SIC_code='5531'DB:business_master_new
loadtime:2.9142150878906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riga' limit 1
loadtime:2.9142699241638 / seconds
Query Executed:select id FROM `mi` where city='Riga' && SIC_code='5531'DB:business_master_new
loadtime:2.9150800704956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riley' limit 1
loadtime:2.9151329994202 / seconds
Query Executed:select id FROM `mi` where city='Riley' && SIC_code='5531'DB:business_master_new
loadtime:2.9155271053314 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Rouge' limit 1
loadtime:2.9155781269073 / seconds
Query Executed:select id FROM `mi` where city='River Rouge' && SIC_code='5531'DB:business_master_new
loadtime:2.9166939258575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:2.9167470932007 / seconds
Query Executed:select id FROM `mi` where city='Riverdale' && SIC_code='5531'DB:business_master_new
loadtime:2.91779088974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:2.9178450107574 / seconds
Query Executed:select id FROM `mi` where city='Riverside' && SIC_code='5531'DB:business_master_new
loadtime:2.9182949066162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverview' limit 1
loadtime:2.918347120285 / seconds
Query Executed:select id FROM `mi` where city='Riverview' && SIC_code='5531'DB:business_master_new
loadtime:2.9206380844116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rives Junction' limit 1
loadtime:2.9206900596619 / seconds
Query Executed:select id FROM `mi` where city='Rives Junction' && SIC_code='5531'DB:business_master_new
loadtime:2.9219670295715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.9220190048218 / seconds
Query Executed:select id FROM `mi` where city='Rochester' && SIC_code='5531'DB:business_master_new
loadtime:2.9652950763702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester Hills' limit 1
loadtime:2.9654030799866 / seconds
Query Executed:select id FROM `mi` where city='Rochester Hills' && SIC_code='5531'DB:business_master_new
loadtime:2.9666359424591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock' limit 1
loadtime:2.9667029380798 / seconds
Query Executed:select id FROM `mi` where city='Rock' && SIC_code='5531'DB:business_master_new
loadtime:2.9673681259155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:2.9674229621887 / seconds
Query Executed:select id FROM `mi` where city='Rockford' && SIC_code='5531'DB:business_master_new
loadtime:2.9806969165802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.9807801246643 / seconds
Query Executed:select id FROM `mi` where city='Rockland' && SIC_code='5531'DB:business_master_new
loadtime:2.9812579154968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwood' limit 1
loadtime:2.9813120365143 / seconds
Query Executed:select id FROM `mi` where city='Rockwood' && SIC_code='5531'DB:business_master_new
loadtime:2.9828159809113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:2.982871055603 / seconds
Query Executed:select id FROM `mi` where city='Rodney' && SIC_code='5531'DB:business_master_new
loadtime:2.9837338924408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers City' limit 1
loadtime:2.9837970733643 / seconds
Query Executed:select id FROM `mi` where city='Rogers City' && SIC_code='5531'DB:business_master_new
loadtime:2.987606048584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollin' limit 1
loadtime:2.9876770973206 / seconds
Query Executed:select id FROM `mi` where city='Rollin' && SIC_code='5531'DB:business_master_new
loadtime:2.9881389141083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romeo' limit 1
loadtime:2.9881939888 / seconds
Query Executed:select id FROM `mi` where city='Romeo' && SIC_code='5531'DB:business_master_new
loadtime:2.9956130981445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Romulus' limit 1
loadtime:2.9956839084625 / seconds
Query Executed:select id FROM `mi` where city='Romulus' && SIC_code='5531'DB:business_master_new
loadtime:3.0012340545654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscommon' limit 1
loadtime:3.0013039112091 / seconds
Query Executed:select id FROM `mi` where city='Roscommon' && SIC_code='5531'DB:business_master_new
loadtime:3.0035829544067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose City' limit 1
loadtime:3.0036499500275 / seconds
Query Executed:select id FROM `mi` where city='Rose City' && SIC_code='5531'DB:business_master_new
loadtime:3.0056760311127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebush' limit 1
loadtime:3.0057461261749 / seconds
Query Executed:select id FROM `mi` where city='Rosebush' && SIC_code='5531'DB:business_master_new
loadtime:3.0068719387054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseville' limit 1
loadtime:3.0069320201874 / seconds
Query Executed:select id FROM `mi` where city='Roseville' && SIC_code='5531'DB:business_master_new
loadtime:3.0259571075439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rothbury' limit 1
loadtime:3.0260589122772 / seconds
Query Executed:select id FROM `mi` where city='Rothbury' && SIC_code='5531'DB:business_master_new
loadtime:3.0270221233368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal Oak' limit 1
loadtime:3.0270941257477 / seconds
Query Executed:select id FROM `mi` where city='Royal Oak' && SIC_code='5531'DB:business_master_new
loadtime:3.0573320388794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruby' limit 1
loadtime:3.0574200153351 / seconds
Query Executed:select id FROM `mi` where city='Ruby' && SIC_code='5531'DB:business_master_new
loadtime:3.0578560829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudyard' limit 1
loadtime:3.0579130649567 / seconds
Query Executed:select id FROM `mi` where city='Rudyard' && SIC_code='5531'DB:business_master_new
loadtime:3.059051990509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumely' limit 1
loadtime:3.0591049194336 / seconds
Query Executed:select id FROM `mi` where city='Rumely' && SIC_code='5531'DB:business_master_new
loadtime:3.0596270561218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell Island' limit 1
loadtime:3.0596780776978 / seconds
Query Executed:select id FROM `mi` where city='Russell Island' && SIC_code='5531'DB:business_master_new
loadtime:3.0600941181183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:3.0601460933685 / seconds
Query Executed:select id FROM `mi` where city='Ruth' && SIC_code='5531'DB:business_master_new
loadtime:3.060986995697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saginaw' limit 1
loadtime:3.0610399246216 / seconds
Query Executed:select id FROM `mi` where city='Saginaw' && SIC_code='5531'DB:business_master_new
loadtime:3.0796480178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagola' limit 1
loadtime:3.0797710418701 / seconds
Query Executed:select id FROM `mi` where city='Sagola' && SIC_code='5531'DB:business_master_new
loadtime:3.0803549289703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:3.0804119110107 / seconds
Query Executed:select id FROM `mi` where city='Saint Charles' && SIC_code='5531'DB:business_master_new
loadtime:3.0830459594727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair' limit 1
loadtime:3.0831129550934 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair' && SIC_code='5531'DB:business_master_new
loadtime:3.0901570320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Clair Shores' limit 1
loadtime:3.0902109146118 / seconds
Query Executed:select id FROM `mi` where city='Saint Clair Shores' && SIC_code='5531'DB:business_master_new
loadtime:3.1153380870819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Helen' limit 1
loadtime:3.1154239177704 / seconds
Query Executed:select id FROM `mi` where city='Saint Helen' && SIC_code='5531'DB:business_master_new
loadtime:3.116378068924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ignace' limit 1
loadtime:3.11643409729 / seconds
Query Executed:select id FROM `mi` where city='Saint Ignace' && SIC_code='5531'DB:business_master_new
loadtime:3.1216280460358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:3.1216950416565 / seconds
Query Executed:select id FROM `mi` where city='Saint Johns' && SIC_code='5531'DB:business_master_new
loadtime:3.131630897522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Joseph' limit 1
loadtime:3.1317090988159 / seconds
Query Executed:select id FROM `mi` where city='Saint Joseph' && SIC_code='5531'DB:business_master_new
loadtime:3.1486570835114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Louis' limit 1
loadtime:3.1487329006195 / seconds
Query Executed:select id FROM `mi` where city='Saint Louis' && SIC_code='5531'DB:business_master_new
loadtime:3.1535420417786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:3.1536130905151 / seconds
Query Executed:select id FROM `mi` where city='Salem' && SIC_code='5531'DB:business_master_new
loadtime:3.1541221141815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saline' limit 1
loadtime:3.1541759967804 / seconds
Query Executed:select id FROM `mi` where city='Saline' && SIC_code='5531'DB:business_master_new
loadtime:3.1602849960327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Samaria' limit 1
loadtime:3.1603510379791 / seconds
Query Executed:select id FROM `mi` where city='Samaria' && SIC_code='5531'DB:business_master_new
loadtime:3.1607971191406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Creek' limit 1
loadtime:3.1608510017395 / seconds
Query Executed:select id FROM `mi` where city='Sand Creek' && SIC_code='5531'DB:business_master_new
loadtime:3.1615619659424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sand Lake' limit 1
loadtime:3.1616148948669 / seconds
Query Executed:select id FROM `mi` where city='Sand Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.163556098938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandusky' limit 1
loadtime:3.1636259555817 / seconds
Query Executed:select id FROM `mi` where city='Sandusky' && SIC_code='5531'DB:business_master_new
loadtime:3.1699409484863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:3.1700110435486 / seconds
Query Executed:select id FROM `mi` where city='Sanford' && SIC_code='5531'DB:business_master_new
loadtime:3.1732530593872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saranac' limit 1
loadtime:3.1733219623566 / seconds
Query Executed:select id FROM `mi` where city='Saranac' && SIC_code='5531'DB:business_master_new
loadtime:3.175409078598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugatuck' limit 1
loadtime:3.1754770278931 / seconds
Query Executed:select id FROM `mi` where city='Saugatuck' && SIC_code='5531'DB:business_master_new
loadtime:3.1790339946747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Sainte Marie' limit 1
loadtime:3.1791009902954 / seconds
Query Executed:select id FROM `mi` where city='Sault Sainte Marie' && SIC_code='5531'DB:business_master_new
loadtime:3.1917119026184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sault Ste Marie' limit 1
loadtime:3.1917989253998 / seconds
Query Executed:select id FROM `mi` where city='Sault Ste Marie' && SIC_code='5531'DB:business_master_new
loadtime:3.192577123642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sawyer' limit 1
loadtime:3.1926319599152 / seconds
Query Executed:select id FROM `mi` where city='Sawyer' && SIC_code='5531'DB:business_master_new
loadtime:3.194179058075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schoolcraft' limit 1
loadtime:3.1942501068115 / seconds
Query Executed:select id FROM `mi` where city='Schoolcraft' && SIC_code='5531'DB:business_master_new
loadtime:3.1973519325256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:3.1974201202393 / seconds
Query Executed:select id FROM `mi` where city='Scotts' && SIC_code='5531'DB:business_master_new
loadtime:3.1987180709839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:3.1987941265106 / seconds
Query Executed:select id FROM `mi` where city='Scottville' && SIC_code='5531'DB:business_master_new
loadtime:3.2014129161835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sears' limit 1
loadtime:3.2014820575714 / seconds
Query Executed:select id FROM `mi` where city='Sears' && SIC_code='5531'DB:business_master_new
loadtime:3.2022280693054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebewaing' limit 1
loadtime:3.2022819519043 / seconds
Query Executed:select id FROM `mi` where city='Sebewaing' && SIC_code='5531'DB:business_master_new
loadtime:3.2045841217041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selfridge Angb' limit 1
loadtime:3.2046489715576 / seconds
Query Executed:select id FROM `mi` where city='Selfridge Angb' && SIC_code='5531'DB:business_master_new
loadtime:3.205127954483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:3.2051820755005 / seconds
Query Executed:select id FROM `mi` where city='Seneca' && SIC_code='5531'DB:business_master_new
loadtime:3.2055459022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seney' limit 1
loadtime:3.2055969238281 / seconds
Query Executed:select id FROM `mi` where city='Seney' && SIC_code='5531'DB:business_master_new
loadtime:3.2060270309448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaftsburg' limit 1
loadtime:3.2060799598694 / seconds
Query Executed:select id FROM `mi` where city='Shaftsburg' && SIC_code='5531'DB:business_master_new
loadtime:3.2065711021423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:3.2066209316254 / seconds
Query Executed:select id FROM `mi` where city='Shelby' && SIC_code='5531'DB:business_master_new
loadtime:3.2108430862427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby Twp' limit 1
loadtime:3.2109100818634 / seconds
Query Executed:select id FROM `mi` where city='Shelby Twp' && SIC_code='5531'DB:business_master_new
loadtime:3.2117159366608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelbyville' limit 1
loadtime:3.2117800712585 / seconds
Query Executed:select id FROM `mi` where city='Shelbyville' && SIC_code='5531'DB:business_master_new
loadtime:3.2132089138031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shepherd' limit 1
loadtime:3.2132630348206 / seconds
Query Executed:select id FROM `mi` where city='Shepherd' && SIC_code='5531'DB:business_master_new
loadtime:3.2156150341034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:3.2156670093536 / seconds
Query Executed:select id FROM `mi` where city='Sheridan' && SIC_code='5531'DB:business_master_new
loadtime:3.2174859046936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherwood' limit 1
loadtime:3.2175600528717 / seconds
Query Executed:select id FROM `mi` where city='Sherwood' && SIC_code='5531'DB:business_master_new
loadtime:3.2183120250702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shingleton' limit 1
loadtime:3.2183659076691 / seconds
Query Executed:select id FROM `mi` where city='Shingleton' && SIC_code='5531'DB:business_master_new
loadtime:3.2190380096436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidnaw' limit 1
loadtime:3.2190909385681 / seconds
Query Executed:select id FROM `mi` where city='Sidnaw' && SIC_code='5531'DB:business_master_new
loadtime:3.2195329666138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:3.2195839881897 / seconds
Query Executed:select id FROM `mi` where city='Sidney' && SIC_code='5531'DB:business_master_new
loadtime:3.220202922821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverwood' limit 1
loadtime:3.2202548980713 / seconds
Query Executed:select id FROM `mi` where city='Silverwood' && SIC_code='5531'DB:business_master_new
loadtime:3.2209830284119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Six Lakes' limit 1
loadtime:3.2210350036621 / seconds
Query Executed:select id FROM `mi` where city='Six Lakes' && SIC_code='5531'DB:business_master_new
loadtime:3.2222609519958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skandia' limit 1
loadtime:3.222314119339 / seconds
Query Executed:select id FROM `mi` where city='Skandia' && SIC_code='5531'DB:business_master_new
loadtime:3.223424911499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skanee' limit 1
loadtime:3.2234771251678 / seconds
Query Executed:select id FROM `mi` where city='Skanee' && SIC_code='5531'DB:business_master_new
loadtime:3.2239689826965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smiths Creek' limit 1
loadtime:3.2240219116211 / seconds
Query Executed:select id FROM `mi` where city='Smiths Creek' && SIC_code='5531'DB:business_master_new
loadtime:3.2276840209961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:3.2277629375458 / seconds
Query Executed:select id FROM `mi` where city='Smyrna' && SIC_code='5531'DB:business_master_new
loadtime:3.2281510829926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snover' limit 1
loadtime:3.2282049655914 / seconds
Query Executed:select id FROM `mi` where city='Snover' && SIC_code='5531'DB:business_master_new
loadtime:3.2292859554291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sodus' limit 1
loadtime:3.2293400764465 / seconds
Query Executed:select id FROM `mi` where city='Sodus' && SIC_code='5531'DB:business_master_new
loadtime:3.2302720546722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:3.2303249835968 / seconds
Query Executed:select id FROM `mi` where city='Somerset' && SIC_code='5531'DB:business_master_new
loadtime:3.2308559417725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset Center' limit 1
loadtime:3.2309079170227 / seconds
Query Executed:select id FROM `mi` where city='Somerset Center' && SIC_code='5531'DB:business_master_new
loadtime:3.2317008972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boardman' limit 1
loadtime:3.2317609786987 / seconds
Query Executed:select id FROM `mi` where city='South Boardman' && SIC_code='5531'DB:business_master_new
loadtime:3.2326939105988 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Branch' limit 1
loadtime:3.2327461242676 / seconds
Query Executed:select id FROM `mi` where city='South Branch' && SIC_code='5531'DB:business_master_new
loadtime:3.2334640026093 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Haven' limit 1
loadtime:3.2335169315338 / seconds
Query Executed:select id FROM `mi` where city='South Haven' && SIC_code='5531'DB:business_master_new
loadtime:3.2432179450989 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyon' limit 1
loadtime:3.243292093277 / seconds
Query Executed:select id FROM `mi` where city='South Lyon' && SIC_code='5531'DB:business_master_new
loadtime:3.2540199756622 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Range' limit 1
loadtime:3.2540910243988 / seconds
Query Executed:select id FROM `mi` where city='South Range' && SIC_code='5531'DB:business_master_new
loadtime:3.2549021244049 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Rockwood' limit 1
loadtime:3.2549619674683 / seconds
Query Executed:select id FROM `mi` where city='South Rockwood' && SIC_code='5531'DB:business_master_new
loadtime:3.2561850547791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:3.2562389373779 / seconds
Query Executed:select id FROM `mi` where city='Southfield' && SIC_code='5531'DB:business_master_new
loadtime:3.274885892868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southgate' limit 1
loadtime:3.2749950885773 / seconds
Query Executed:select id FROM `mi` where city='Southgate' && SIC_code='5531'DB:business_master_new
loadtime:3.2806930541992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spalding' limit 1
loadtime:3.2807729244232 / seconds
Query Executed:select id FROM `mi` where city='Spalding' && SIC_code='5531'DB:business_master_new
loadtime:3.2814209461212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:3.281476020813 / seconds
Query Executed:select id FROM `mi` where city='Sparta' && SIC_code='5531'DB:business_master_new
loadtime:3.2878549098969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Arbor' limit 1
loadtime:3.2879359722137 / seconds
Query Executed:select id FROM `mi` where city='Spring Arbor' && SIC_code='5531'DB:business_master_new
loadtime:3.2896149158478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:3.2896699905396 / seconds
Query Executed:select id FROM `mi` where city='Spring Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.2975680828094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:3.2976429462433 / seconds
Query Executed:select id FROM `mi` where city='Springfield' && SIC_code='5531'DB:business_master_new
loadtime:3.2981669902802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield Twp' limit 1
loadtime:3.2982230186462 / seconds
Query Executed:select id FROM `mi` where city='Springfield Twp' && SIC_code='5531'DB:business_master_new
loadtime:3.2986381053925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springport' limit 1
loadtime:3.2986891269684 / seconds
Query Executed:select id FROM `mi` where city='Springport' && SIC_code='5531'DB:business_master_new
loadtime:3.3001379966736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce' limit 1
loadtime:3.3001899719238 / seconds
Query Executed:select id FROM `mi` where city='Spruce' && SIC_code='5531'DB:business_master_new
loadtime:3.3012199401855 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:3.3012731075287 / seconds
Query Executed:select id FROM `mi` where city='St Charles' && SIC_code='5531'DB:business_master_new
loadtime:3.3016600608826 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair' limit 1
loadtime:3.3017120361328 / seconds
Query Executed:select id FROM `mi` where city='St Clair' && SIC_code='5531'DB:business_master_new
loadtime:3.3021991252899 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Clair Shores' limit 1
loadtime:3.3022520542145 / seconds
Query Executed:select id FROM `mi` where city='St Clair Shores' && SIC_code='5531'DB:business_master_new
loadtime:3.3030080795288 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ignace' limit 1
loadtime:3.3030600547791 / seconds
Query Executed:select id FROM `mi` where city='St Ignace' && SIC_code='5531'DB:business_master_new
loadtime:3.3034429550171 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:3.303493976593 / seconds
Query Executed:select id FROM `mi` where city='St Johns' && SIC_code='5531'DB:business_master_new
loadtime:3.3039870262146 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Joseph' limit 1
loadtime:3.3040390014648 / seconds
Query Executed:select id FROM `mi` where city='St Joseph' && SIC_code='5531'DB:business_master_new
loadtime:3.3046820163727 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Louis' limit 1
loadtime:3.3047320842743 / seconds
Query Executed:select id FROM `mi` where city='St Louis' && SIC_code='5531'DB:business_master_new
loadtime:3.3051509857178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stalwart' limit 1
loadtime:3.305202960968 / seconds
Query Executed:select id FROM `mi` where city='Stalwart' && SIC_code='5531'DB:business_master_new
loadtime:3.3055849075317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stambaugh' limit 1
loadtime:3.305634021759 / seconds
Query Executed:select id FROM `mi` where city='Stambaugh' && SIC_code='5531'DB:business_master_new
loadtime:3.3063359260559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Standish' limit 1
loadtime:3.3063869476318 / seconds
Query Executed:select id FROM `mi` where city='Standish' && SIC_code='5531'DB:business_master_new
loadtime:3.3113970756531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:3.3114659786224 / seconds
Query Executed:select id FROM `mi` where city='Stanton' && SIC_code='5531'DB:business_master_new
loadtime:3.3161790370941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:3.3162488937378 / seconds
Query Executed:select id FROM `mi` where city='Stanwood' && SIC_code='5531'DB:business_master_new
loadtime:3.3183529376984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephenson' limit 1
loadtime:3.3184080123901 / seconds
Query Executed:select id FROM `mi` where city='Stephenson' && SIC_code='5531'DB:business_master_new
loadtime:3.3200480937958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:3.3201019763947 / seconds
Query Executed:select id FROM `mi` where city='Sterling' && SIC_code='5531'DB:business_master_new
loadtime:3.3213489055634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling Heights' limit 1
loadtime:3.3214149475098 / seconds
Query Executed:select id FROM `mi` where city='Sterling Heights' && SIC_code='5531'DB:business_master_new
loadtime:3.3398001194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevensville' limit 1
loadtime:3.33988904953 / seconds
Query Executed:select id FROM `mi` where city='Stevensville' && SIC_code='5531'DB:business_master_new
loadtime:3.3462910652161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:3.3463609218597 / seconds
Query Executed:select id FROM `mi` where city='Stockbridge' && SIC_code='5531'DB:business_master_new
loadtime:3.3491830825806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stronach' limit 1
loadtime:3.3492519855499 / seconds
Query Executed:select id FROM `mi` where city='Stronach' && SIC_code='5531'DB:business_master_new
loadtime:3.3496580123901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strongs' limit 1
loadtime:3.3497109413147 / seconds
Query Executed:select id FROM `mi` where city='Strongs' && SIC_code='5531'DB:business_master_new
loadtime:3.3501319885254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:3.35018491745 / seconds
Query Executed:select id FROM `mi` where city='Sturgis' && SIC_code='5531'DB:business_master_new
loadtime:3.35586810112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:3.3559238910675 / seconds
Query Executed:select id FROM `mi` where city='Sumner' && SIC_code='5531'DB:business_master_new
loadtime:3.3567299842834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunfield' limit 1
loadtime:3.3567941188812 / seconds
Query Executed:select id FROM `mi` where city='Sunfield' && SIC_code='5531'DB:business_master_new
loadtime:3.3579859733582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suttons Bay' limit 1
loadtime:3.3580520153046 / seconds
Query Executed:select id FROM `mi` where city='Suttons Bay' && SIC_code='5531'DB:business_master_new
loadtime:3.3629519939423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swartz Creek' limit 1
loadtime:3.363018989563 / seconds
Query Executed:select id FROM `mi` where city='Swartz Creek' && SIC_code='5531'DB:business_master_new
loadtime:3.3713190555573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvan Lake' limit 1
loadtime:3.3713889122009 / seconds
Query Executed:select id FROM `mi` where city='Sylvan Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.3718109130859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tawas City' limit 1
loadtime:3.3718640804291 / seconds
Query Executed:select id FROM `mi` where city='Tawas City' && SIC_code='5531'DB:business_master_new
loadtime:3.3766829967499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:3.3767600059509 / seconds
Query Executed:select id FROM `mi` where city='Taylor' && SIC_code='5531'DB:business_master_new
loadtime:3.3862819671631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tecumseh' limit 1
loadtime:3.386353969574 / seconds
Query Executed:select id FROM `mi` where city='Tecumseh' && SIC_code='5531'DB:business_master_new
loadtime:3.3942589759827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tekonsha' limit 1
loadtime:3.3943319320679 / seconds
Query Executed:select id FROM `mi` where city='Tekonsha' && SIC_code='5531'DB:business_master_new
loadtime:3.3957970142365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temperance' limit 1
loadtime:3.3958659172058 / seconds
Query Executed:select id FROM `mi` where city='Temperance' && SIC_code='5531'DB:business_master_new
loadtime:3.4030470848083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompsonville' limit 1
loadtime:3.4031159877777 / seconds
Query Executed:select id FROM `mi` where city='Thompsonville' && SIC_code='5531'DB:business_master_new
loadtime:3.404088973999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Oaks' limit 1
loadtime:3.4041440486908 / seconds
Query Executed:select id FROM `mi` where city='Three Oaks' && SIC_code='5531'DB:business_master_new
loadtime:3.4067649841309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:3.4068310260773 / seconds
Query Executed:select id FROM `mi` where city='Three Rivers' && SIC_code='5531'DB:business_master_new
loadtime:3.4107310771942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:3.4108068943024 / seconds
Query Executed:select id FROM `mi` where city='Tipton' && SIC_code='5531'DB:business_master_new
loadtime:3.4119961261749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toivola' limit 1
loadtime:3.4120509624481 / seconds
Query Executed:select id FROM `mi` where city='Toivola' && SIC_code='5531'DB:business_master_new
loadtime:3.4126460552216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topinabee' limit 1
loadtime:3.4126970767975 / seconds
Query Executed:select id FROM `mi` where city='Topinabee' && SIC_code='5531'DB:business_master_new
loadtime:3.4132149219513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tower' limit 1
loadtime:3.4132680892944 / seconds
Query Executed:select id FROM `mi` where city='Tower' && SIC_code='5531'DB:business_master_new
loadtime:3.4137780666351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traunik' limit 1
loadtime:3.4138309955597 / seconds
Query Executed:select id FROM `mi` where city='Traunik' && SIC_code='5531'DB:business_master_new
loadtime:3.4142169952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traverse City' limit 1
loadtime:3.4142699241638 / seconds
Query Executed:select id FROM `mi` where city='Traverse City' && SIC_code='5531'DB:business_master_new
loadtime:3.4328091144562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenary' limit 1
loadtime:3.4329080581665 / seconds
Query Executed:select id FROM `mi` where city='Trenary' && SIC_code='5531'DB:business_master_new
loadtime:3.433746099472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:3.4338119029999 / seconds
Query Executed:select id FROM `mi` where city='Trenton' && SIC_code='5531'DB:business_master_new
loadtime:3.4410660266876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Creek' limit 1
loadtime:3.4411361217499 / seconds
Query Executed:select id FROM `mi` where city='Trout Creek' && SIC_code='5531'DB:business_master_new
loadtime:3.4416561126709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trout Lake' limit 1
loadtime:3.4417090415955 / seconds
Query Executed:select id FROM `mi` where city='Trout Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.442332983017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:3.4423849582672 / seconds
Query Executed:select id FROM `mi` where city='Troy' && SIC_code='5531'DB:business_master_new
loadtime:3.4602150917053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trufant' limit 1
loadtime:3.4603209495544 / seconds
Query Executed:select id FROM `mi` where city='Trufant' && SIC_code='5531'DB:business_master_new
loadtime:3.4611139297485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turner' limit 1
loadtime:3.4611730575562 / seconds
Query Executed:select id FROM `mi` where city='Turner' && SIC_code='5531'DB:business_master_new
loadtime:3.4618608951569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuscola' limit 1
loadtime:3.4619131088257 / seconds
Query Executed:select id FROM `mi` where city='Tuscola' && SIC_code='5531'DB:business_master_new
loadtime:3.4622941017151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tustin' limit 1
loadtime:3.4623460769653 / seconds
Query Executed:select id FROM `mi` where city='Tustin' && SIC_code='5531'DB:business_master_new
loadtime:3.4634349346161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Lake' limit 1
loadtime:3.4634881019592 / seconds
Query Executed:select id FROM `mi` where city='Twin Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.4660310745239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twining' limit 1
loadtime:3.4660980701447 / seconds
Query Executed:select id FROM `mi` where city='Twining' && SIC_code='5531'DB:business_master_new
loadtime:3.4669389724731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ubly' limit 1
loadtime:3.4669940471649 / seconds
Query Executed:select id FROM `mi` where city='Ubly' && SIC_code='5531'DB:business_master_new
loadtime:3.4687039852142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:3.468780040741 / seconds
Query Executed:select id FROM `mi` where city='Union' && SIC_code='5531'DB:business_master_new
loadtime:3.4699249267578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union City' limit 1
loadtime:3.4699931144714 / seconds
Query Executed:select id FROM `mi` where city='Union City' && SIC_code='5531'DB:business_master_new
loadtime:3.4720849990845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Lake' limit 1
loadtime:3.4721510410309 / seconds
Query Executed:select id FROM `mi` where city='Union Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.4730110168457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Pier' limit 1
loadtime:3.4730780124664 / seconds
Query Executed:select id FROM `mi` where city='Union Pier' && SIC_code='5531'DB:business_master_new
loadtime:3.4741320610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:3.4741868972778 / seconds
Query Executed:select id FROM `mi` where city='Unionville' && SIC_code='5531'DB:business_master_new
loadtime:3.4755439758301 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Center' limit 1
loadtime:3.4755969047546 / seconds
Query Executed:select id FROM `mi` where city='University Center' && SIC_code='5531'DB:business_master_new
loadtime:3.4760410785675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:3.4760940074921 / seconds
Query Executed:select id FROM `mi` where city='Utica' && SIC_code='5531'DB:business_master_new
loadtime:3.5071249008179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandalia' limit 1
loadtime:3.5072259902954 / seconds
Query Executed:select id FROM `mi` where city='Vandalia' && SIC_code='5531'DB:business_master_new
loadtime:3.5081779956818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanderbilt' limit 1
loadtime:3.5082340240479 / seconds
Query Executed:select id FROM `mi` where city='Vanderbilt' && SIC_code='5531'DB:business_master_new
loadtime:3.5089399814606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vassar' limit 1
loadtime:3.508994102478 / seconds
Query Executed:select id FROM `mi` where city='Vassar' && SIC_code='5531'DB:business_master_new
loadtime:3.5138449668884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermontville' limit 1
loadtime:3.5139141082764 / seconds
Query Executed:select id FROM `mi` where city='Vermontville' && SIC_code='5531'DB:business_master_new
loadtime:3.5153639316559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:3.5154190063477 / seconds
Query Executed:select id FROM `mi` where city='Vernon' && SIC_code='5531'DB:business_master_new
loadtime:3.5161669254303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vestaburg' limit 1
loadtime:3.5162210464478 / seconds
Query Executed:select id FROM `mi` where city='Vestaburg' && SIC_code='5531'DB:business_master_new
loadtime:3.5175468921661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:3.5176169872284 / seconds
Query Executed:select id FROM `mi` where city='Vicksburg' && SIC_code='5531'DB:business_master_new
loadtime:3.5229940414429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vulcan' limit 1
loadtime:3.5230610370636 / seconds
Query Executed:select id FROM `mi` where city='Vulcan' && SIC_code='5531'DB:business_master_new
loadtime:3.5239291191101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:3.523983001709 / seconds
Query Executed:select id FROM `mi` where city='Wakefield' && SIC_code='5531'DB:business_master_new
loadtime:3.5254340171814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldron' limit 1
loadtime:3.5254859924316 / seconds
Query Executed:select id FROM `mi` where city='Waldron' && SIC_code='5531'DB:business_master_new
loadtime:3.5264799594879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:3.5265331268311 / seconds
Query Executed:select id FROM `mi` where city='Wales' && SIC_code='5531'DB:business_master_new
loadtime:3.5269749164581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walhalla' limit 1
loadtime:3.5270280838013 / seconds
Query Executed:select id FROM `mi` where city='Walhalla' && SIC_code='5531'DB:business_master_new
loadtime:3.5276000499725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkerville' limit 1
loadtime:3.5276520252228 / seconds
Query Executed:select id FROM `mi` where city='Walkerville' && SIC_code='5531'DB:business_master_new
loadtime:3.5286180973053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:3.5286710262299 / seconds
Query Executed:select id FROM `mi` where city='Wallace' && SIC_code='5531'DB:business_master_new
loadtime:3.52947306633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walled Lake' limit 1
loadtime:3.5295269489288 / seconds
Query Executed:select id FROM `mi` where city='Walled Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.5388400554657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walloon Lake' limit 1
loadtime:3.5389139652252 / seconds
Query Executed:select id FROM `mi` where city='Walloon Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.5397419929504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:3.5398061275482 / seconds
Query Executed:select id FROM `mi` where city='Warren' && SIC_code='5531'DB:business_master_new
loadtime:3.5583770275116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:3.5584919452667 / seconds
Query Executed:select id FROM `mi` where city='Washington' && SIC_code='5531'DB:business_master_new
loadtime:3.5665121078491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:3.5665860176086 / seconds
Query Executed:select id FROM `mi` where city='Waterford' && SIC_code='5531'DB:business_master_new
loadtime:3.599846124649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waters' limit 1
loadtime:3.5999689102173 / seconds
Query Executed:select id FROM `mi` where city='Waters' && SIC_code='5531'DB:business_master_new
loadtime:3.6005210876465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watersmeet' limit 1
loadtime:3.6005771160126 / seconds
Query Executed:select id FROM `mi` where city='Watersmeet' && SIC_code='5531'DB:business_master_new
loadtime:3.6016380786896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watervliet' limit 1
loadtime:3.6016919612885 / seconds
Query Executed:select id FROM `mi` where city='Watervliet' && SIC_code='5531'DB:business_master_new
loadtime:3.6045989990234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watton' limit 1
loadtime:3.6046659946442 / seconds
Query Executed:select id FROM `mi` where city='Watton' && SIC_code='5531'DB:business_master_new
loadtime:3.6051440238953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:3.6051979064941 / seconds
Query Executed:select id FROM `mi` where city='Wayland' && SIC_code='5531'DB:business_master_new
loadtime:3.6112079620361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:3.6112780570984 / seconds
Query Executed:select id FROM `mi` where city='Wayne' && SIC_code='5531'DB:business_master_new
loadtime:3.6142580509186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webberville' limit 1
loadtime:3.6143250465393 / seconds
Query Executed:select id FROM `mi` where city='Webberville' && SIC_code='5531'DB:business_master_new
loadtime:3.6165590286255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weidman' limit 1
loadtime:3.6166141033173 / seconds
Query Executed:select id FROM `mi` where city='Weidman' && SIC_code='5531'DB:business_master_new
loadtime:3.6183080673218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wells' limit 1
loadtime:3.6183750629425 / seconds
Query Executed:select id FROM `mi` where city='Wells' && SIC_code='5531'DB:business_master_new
loadtime:3.6190059185028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellston' limit 1
loadtime:3.6190609931946 / seconds
Query Executed:select id FROM `mi` where city='Wellston' && SIC_code='5531'DB:business_master_new
loadtime:3.620393037796 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bloomfield' limit 1
loadtime:3.6204590797424 / seconds
Query Executed:select id FROM `mi` where city='West Bloomfield' && SIC_code='5531'DB:business_master_new
loadtime:3.6498401165009 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:3.6499199867249 / seconds
Query Executed:select id FROM `mi` where city='West Branch' && SIC_code='5531'DB:business_master_new
loadtime:3.6589660644531 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Olive' limit 1
loadtime:3.659038066864 / seconds
Query Executed:select id FROM `mi` where city='West Olive' && SIC_code='5531'DB:business_master_new
loadtime:3.6621129512787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westland' limit 1
loadtime:3.6621809005737 / seconds
Query Executed:select id FROM `mi` where city='Westland' && SIC_code='5531'DB:business_master_new
loadtime:3.6721370220184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:3.6722059249878 / seconds
Query Executed:select id FROM `mi` where city='Weston' && SIC_code='5531'DB:business_master_new
loadtime:3.6727209091187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:3.6727859973907 / seconds
Query Executed:select id FROM `mi` where city='Westphalia' && SIC_code='5531'DB:business_master_new
loadtime:3.6737160682678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetmore' limit 1
loadtime:3.6737790107727 / seconds
Query Executed:select id FROM `mi` where city='Wetmore' && SIC_code='5531'DB:business_master_new
loadtime:3.6746001243591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:3.6746520996094 / seconds
Query Executed:select id FROM `mi` where city='Wheeler' && SIC_code='5531'DB:business_master_new
loadtime:3.6754701137543 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Cloud' limit 1
loadtime:3.6755239963531 / seconds
Query Executed:select id FROM `mi` where city='White Cloud' && SIC_code='5531'DB:business_master_new
loadtime:3.6788439750671 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:3.6789100170135 / seconds
Query Executed:select id FROM `mi` where city='White Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.688549041748 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pigeon' limit 1
loadtime:3.6886160373688 / seconds
Query Executed:select id FROM `mi` where city='White Pigeon' && SIC_code='5531'DB:business_master_new
loadtime:3.6900660991669 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Pine' limit 1
loadtime:3.6901190280914 / seconds
Query Executed:select id FROM `mi` where city='White Pine' && SIC_code='5531'DB:business_master_new
loadtime:3.6906011104584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehall' limit 1
loadtime:3.6906530857086 / seconds
Query Executed:select id FROM `mi` where city='Whitehall' && SIC_code='5531'DB:business_master_new
loadtime:3.6952390670776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitmore Lake' limit 1
loadtime:3.695307970047 / seconds
Query Executed:select id FROM `mi` where city='Whitmore Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.6980221271515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittaker' limit 1
loadtime:3.6980879306793 / seconds
Query Executed:select id FROM `mi` where city='Whittaker' && SIC_code='5531'DB:business_master_new
loadtime:3.6985440254211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:3.6985960006714 / seconds
Query Executed:select id FROM `mi` where city='Whittemore' && SIC_code='5531'DB:business_master_new
loadtime:3.699805021286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:3.6998720169067 / seconds
Query Executed:select id FROM `mi` where city='Williamsburg' && SIC_code='5531'DB:business_master_new
loadtime:3.7038879394531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:3.703959941864 / seconds
Query Executed:select id FROM `mi` where city='Williamston' && SIC_code='5531'DB:business_master_new
loadtime:3.7111809253693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willis' limit 1
loadtime:3.7112510204315 / seconds
Query Executed:select id FROM `mi` where city='Willis' && SIC_code='5531'DB:business_master_new
loadtime:3.7120659351349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:3.7121200561523 / seconds
Query Executed:select id FROM `mi` where city='Wilson' && SIC_code='5531'DB:business_master_new
loadtime:3.7128279209137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winn' limit 1
loadtime:3.7128810882568 / seconds
Query Executed:select id FROM `mi` where city='Winn' && SIC_code='5531'DB:business_master_new
loadtime:3.713455915451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wixom' limit 1
loadtime:3.7135100364685 / seconds
Query Executed:select id FROM `mi` where city='Wixom' && SIC_code='5531'DB:business_master_new
loadtime:3.7232189178467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine' limit 1
loadtime:3.7232930660248 / seconds
Query Executed:select id FROM `mi` where city='Wolverine' && SIC_code='5531'DB:business_master_new
loadtime:3.7248299121857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolverine Lake' limit 1
loadtime:3.7249000072479 / seconds
Query Executed:select id FROM `mi` where city='Wolverine Lake' && SIC_code='5531'DB:business_master_new
loadtime:3.7253379821777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:3.7253921031952 / seconds
Query Executed:select id FROM `mi` where city='Woodland' && SIC_code='5531'DB:business_master_new
loadtime:3.7263629436493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyandotte' limit 1
loadtime:3.7264161109924 / seconds
Query Executed:select id FROM `mi` where city='Wyandotte' && SIC_code='5531'DB:business_master_new
loadtime:3.7321910858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:3.7322459220886 / seconds
Query Executed:select id FROM `mi` where city='Wyoming' && SIC_code='5531'DB:business_master_new
loadtime:3.7496659755707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:3.7497489452362 / seconds
Query Executed:select id FROM `mi` where city='Yale' && SIC_code='5531'DB:business_master_new
loadtime:3.7524559497833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ypsilanti' limit 1
loadtime:3.7525310516357 / seconds
Query Executed:select id FROM `mi` where city='Ypsilanti' && SIC_code='5531'DB:business_master_new
loadtime:3.7669811248779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zeeland' limit 1
loadtime:3.7670500278473 / seconds
Query Executed:select id FROM `mi` where city='Zeeland' && SIC_code='5531'DB:business_master_new
loadtime:3.7795300483704 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:3.7797179222107 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:3.780256986618 / seconds
Operation template executed (chunk cache operation)
loadtime:3.7804200649261 / seconds
template override:Default
loadtime:3.7804629802704 / 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:3.7819600105286 / seconds
Template Constructed, Array Rows:49
loadtime:3.7824831008911 / seconds
TOTAL EXECUTION TIME: 3.78204
loadtime:3.7863719463348 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => auto-and-home-supply-stores [stateURLid] => michigan )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:3.7863829135895
TOTAL KEY ARRAYS: 69