Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.5830688476562E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00052595138549805 / seconds
host not found setting manual db connection
loadtime:0.00092387199401855 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011448860168457 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0013439655303955 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0013940334320068 / seconds
zipcode:
loadtime:0.001410961151123 / seconds
Query Executed:select * from search_referrer where page_hash='7f7931e1ceb1b80d276a4d4445deb03d' limit 10 DB:ezrox_toadli
loadtime:0.0016248226165771 / seconds
Operation header executed (non global)
loadtime:0.0016429424285889 / seconds
Operation leaderboard executed (non global)
loadtime:0.0016829967498779 / seconds
Operation square executed (non global)
loadtime:0.0016980171203613 / seconds
Operation square_bottom executed (non global)
loadtime:0.0017118453979492 / seconds
Operation smallsquare executed (non global)
loadtime:0.0017240047454834 / seconds
Operation headeradright executed (non global)
loadtime:0.0017549991607666 / seconds
Operation google_analytics executed (non global)
loadtime:0.0017759799957275 / seconds
Operation topstories executed (non global)
loadtime:0.0017879009246826 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0018010139465332 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0018119812011719 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0020308494567871 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.002180814743042 / seconds
Operation categories executed (global stored into APC)
loadtime:0.002223014831543 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0023548603057861 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0023930072784424 / seconds
Template key: archive_menu pushed
loadtime:0.0023980140686035 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0024089813232422 / seconds
Template key: get_gravatar pushed
loadtime:0.0024139881134033 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0024178028106689 / seconds
*10)-10)+1 | start:0
loadtime:0.0024399757385254 / seconds
DB connected to localhost business_master_new
loadtime:0.0026710033416748 / seconds
Query Executed:select * from categories where cat_URLid='gasoline-service-station'DB:business_master_new
loadtime:0.0032548904418945 / seconds
Query stored in cache : _QUERY_www.toadli.comae9eaa17c7f2f271be87cf6879e91433
loadtime:0.0032908916473389 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.0033268928527832 / seconds
Query Executed:select * from `ia_catmap` where sic='5541' order by city ascDB:business_master_new
loadtime:0.014973878860474 / seconds
Query stored in cache : _QUERY_www.toadli.comebd760586bfd9270aedf22563bbd86ef
loadtime:0.016434907913208 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.016475915908813 / seconds
Query Executed:select sum(totalcount) as totalsum from `ia_catmap` where sic='5541'DB:business_master_new
loadtime:0.022361993789673 / seconds
Query stored in cache : _QUERY_www.toadli.comeeb947883acddd76754547d53524fa74
loadtime:0.02246880531311 / seconds
981 / 11
loadtime:0.022557020187378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackley' limit 1
loadtime:0.022677898406982 / seconds
Query Executed:select id FROM `ia` where city='Ackley' && SIC_code='5541'DB:business_master_new
loadtime:0.024324893951416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackworth' limit 1
loadtime:0.02439284324646 / seconds
Query Executed:select id FROM `ia` where city='Ackworth' && SIC_code='5541'DB:business_master_new
loadtime:0.025148868560791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adair' limit 1
loadtime:0.025199890136719 / seconds
Query Executed:select id FROM `ia` where city='Adair' && SIC_code='5541'DB:business_master_new
loadtime:0.026054859161377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adel' limit 1
loadtime:0.026131868362427 / seconds
Query Executed:select id FROM `ia` where city='Adel' && SIC_code='5541'DB:business_master_new
loadtime:0.027184963226318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.027241945266724 / seconds
Query Executed:select id FROM `ia` where city='Afton' && SIC_code='5541'DB:business_master_new
loadtime:0.028002977371216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agency' limit 1
loadtime:0.028090953826904 / seconds
Query Executed:select id FROM `ia` where city='Agency' && SIC_code='5541'DB:business_master_new
loadtime:0.028937816619873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ainsworth' limit 1
loadtime:0.029011011123657 / seconds
Query Executed:select id FROM `ia` where city='Ainsworth' && SIC_code='5541'DB:business_master_new
loadtime:0.029850006103516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.029946804046631 / seconds
Query Executed:select id FROM `ia` where city='Akron' && SIC_code='5541'DB:business_master_new
loadtime:0.030803918838501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albert City' limit 1
loadtime:0.030887842178345 / seconds
Query Executed:select id FROM `ia` where city='Albert City' && SIC_code='5541'DB:business_master_new
loadtime:0.031654834747314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albia' limit 1
loadtime:0.031728029251099 / seconds
Query Executed:select id FROM `ia` where city='Albia' && SIC_code='5541'DB:business_master_new
loadtime:0.032805919647217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.032902956008911 / seconds
Query Executed:select id FROM `ia` where city='Albion' && SIC_code='5541'DB:business_master_new
loadtime:0.033959865570068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburnett' limit 1
loadtime:0.03404688835144 / seconds
Query Executed:select id FROM `ia` where city='Alburnett' && SIC_code='5541'DB:business_master_new
loadtime:0.034914016723633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.035003900527954 / seconds
Query Executed:select id FROM `ia` where city='Alden' && SIC_code='5541'DB:business_master_new
loadtime:0.035717010498047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.035856008529663 / seconds
Query Executed:select id FROM `ia` where city='Alexander' && SIC_code='5541'DB:business_master_new
loadtime:0.036880016326904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algona' limit 1
loadtime:0.036968946456909 / seconds
Query Executed:select id FROM `ia` where city='Algona' && SIC_code='5541'DB:business_master_new
loadtime:0.038237810134888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleman' limit 1
loadtime:0.03836989402771 / seconds
Query Executed:select id FROM `ia` where city='Alleman' && SIC_code='5541'DB:business_master_new
loadtime:0.039309978485107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendorf' limit 1
loadtime:0.039450883865356 / seconds
Query Executed:select id FROM `ia` where city='Allendorf' && SIC_code='5541'DB:business_master_new
loadtime:0.039785861968994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allerton' limit 1
loadtime:0.039850950241089 / seconds
Query Executed:select id FROM `ia` where city='Allerton' && SIC_code='5541'DB:business_master_new
loadtime:0.040688037872314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allison' limit 1
loadtime:0.040839910507202 / seconds
Query Executed:select id FROM `ia` where city='Allison' && SIC_code='5541'DB:business_master_new
loadtime:0.042836904525757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.042934894561768 / seconds
Query Executed:select id FROM `ia` where city='Alpha' && SIC_code='5541'DB:business_master_new
loadtime:0.043536901473999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.04365086555481 / seconds
Query Executed:select id FROM `ia` where city='Alta' && SIC_code='5541'DB:business_master_new
loadtime:0.044622898101807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta Vista' limit 1
loadtime:0.044709920883179 / seconds
Query Executed:select id FROM `ia` where city='Alta Vista' && SIC_code='5541'DB:business_master_new
loadtime:0.04570484161377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.045817852020264 / seconds
Query Executed:select id FROM `ia` where city='Alton' && SIC_code='5541'DB:business_master_new
loadtime:0.046727895736694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.046865940093994 / seconds
Query Executed:select id FROM `ia` where city='Altoona' && SIC_code='5541'DB:business_master_new
loadtime:0.048102855682373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvord' limit 1
loadtime:0.04817795753479 / seconds
Query Executed:select id FROM `ia` where city='Alvord' && SIC_code='5541'DB:business_master_new
loadtime:0.049096822738647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amana' limit 1
loadtime:0.04918098449707 / seconds
Query Executed:select id FROM `ia` where city='Amana' && SIC_code='5541'DB:business_master_new
loadtime:0.050091028213501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ames' limit 1
loadtime:0.050182819366455 / seconds
Query Executed:select id FROM `ia` where city='Ames' && SIC_code='5541'DB:business_master_new
loadtime:0.052016973495483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anamosa' limit 1
loadtime:0.05209493637085 / seconds
Query Executed:select id FROM `ia` where city='Anamosa' && SIC_code='5541'DB:business_master_new
loadtime:0.053217887878418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.053323030471802 / seconds
Query Executed:select id FROM `ia` where city='Andover' && SIC_code='5541'DB:business_master_new
loadtime:0.053975820541382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrew' limit 1
loadtime:0.054041862487793 / seconds
Query Executed:select id FROM `ia` where city='Andrew' && SIC_code='5541'DB:business_master_new
loadtime:0.05479884147644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anita' limit 1
loadtime:0.054867029190063 / seconds
Query Executed:select id FROM `ia` where city='Anita' && SIC_code='5541'DB:business_master_new
loadtime:0.055799007415771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ankeny' limit 1
loadtime:0.055888891220093 / seconds
Query Executed:select id FROM `ia` where city='Ankeny' && SIC_code='5541'DB:business_master_new
loadtime:0.057422876358032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthon' limit 1
loadtime:0.057581901550293 / seconds
Query Executed:select id FROM `ia` where city='Anthon' && SIC_code='5541'DB:business_master_new
loadtime:0.05852198600769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aplington' limit 1
loadtime:0.058597803115845 / seconds
Query Executed:select id FROM `ia` where city='Aplington' && SIC_code='5541'DB:business_master_new
loadtime:0.059567928314209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.059705018997192 / seconds
Query Executed:select id FROM `ia` where city='Arcadia' && SIC_code='5541'DB:business_master_new
loadtime:0.060592889785767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archer' limit 1
loadtime:0.060680866241455 / seconds
Query Executed:select id FROM `ia` where city='Archer' && SIC_code='5541'DB:business_master_new
loadtime:0.061612844467163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aredale' limit 1
loadtime:0.061739921569824 / seconds
Query Executed:select id FROM `ia` where city='Aredale' && SIC_code='5541'DB:business_master_new
loadtime:0.062410831451416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.062506914138794 / seconds
Query Executed:select id FROM `ia` where city='Argyle' && SIC_code='5541'DB:business_master_new
loadtime:0.063378810882568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arion' limit 1
loadtime:0.063463926315308 / seconds
Query Executed:select id FROM `ia` where city='Arion' && SIC_code='5541'DB:business_master_new
loadtime:0.064131021499634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arispe' limit 1
loadtime:0.064190864562988 / seconds
Query Executed:select id FROM `ia` where city='Arispe' && SIC_code='5541'DB:business_master_new
loadtime:0.064802885055542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.064884901046753 / seconds
Query Executed:select id FROM `ia` where city='Arlington' && SIC_code='5541'DB:business_master_new
loadtime:0.065696001052856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armstrong' limit 1
loadtime:0.065801858901978 / seconds
Query Executed:select id FROM `ia` where city='Armstrong' && SIC_code='5541'DB:business_master_new
loadtime:0.066661834716797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnolds Park' limit 1
loadtime:0.066771984100342 / seconds
Query Executed:select id FROM `ia` where city='Arnolds Park' && SIC_code='5541'DB:business_master_new
loadtime:0.067706823348999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arthur' limit 1
loadtime:0.067821025848389 / seconds
Query Executed:select id FROM `ia` where city='Arthur' && SIC_code='5541'DB:business_master_new
loadtime:0.068764925003052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.068861961364746 / seconds
Query Executed:select id FROM `ia` where city='Ashton' && SIC_code='5541'DB:business_master_new
loadtime:0.069727897644043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aspinwall' limit 1
loadtime:0.069821834564209 / seconds
Query Executed:select id FROM `ia` where city='Aspinwall' && SIC_code='5541'DB:business_master_new
loadtime:0.070417881011963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atalissa' limit 1
loadtime:0.070550918579102 / seconds
Query Executed:select id FROM `ia` where city='Atalissa' && SIC_code='5541'DB:business_master_new
loadtime:0.071547985076904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.071648836135864 / seconds
Query Executed:select id FROM `ia` where city='Atkins' && SIC_code='5541'DB:business_master_new
loadtime:0.072544813156128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.072640895843506 / seconds
Query Executed:select id FROM `ia` where city='Atlantic' && SIC_code='5541'DB:business_master_new
loadtime:0.073969841003418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.074069023132324 / seconds
Query Executed:select id FROM `ia` where city='Auburn' && SIC_code='5541'DB:business_master_new
loadtime:0.075130939483643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.075215816497803 / seconds
Query Executed:select id FROM `ia` where city='Audubon' && SIC_code='5541'DB:business_master_new
loadtime:0.076283931732178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurelia' limit 1
loadtime:0.076382875442505 / seconds
Query Executed:select id FROM `ia` where city='Aurelia' && SIC_code='5541'DB:business_master_new
loadtime:0.077263832092285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.077347993850708 / seconds
Query Executed:select id FROM `ia` where city='Aurora' && SIC_code='5541'DB:business_master_new
loadtime:0.078495025634766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.07863187789917 / seconds
Query Executed:select id FROM `ia` where city='Austinville' && SIC_code='5541'DB:business_master_new
loadtime:0.079197883605957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.079245805740356 / seconds
Query Executed:select id FROM `ia` where city='Avoca' && SIC_code='5541'DB:business_master_new
loadtime:0.080137014389038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayrshire' limit 1
loadtime:0.080235004425049 / seconds
Query Executed:select id FROM `ia` where city='Ayrshire' && SIC_code='5541'DB:business_master_new
loadtime:0.081135988235474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.081219911575317 / seconds
Query Executed:select id FROM `ia` where city='Badger' && SIC_code='5541'DB:business_master_new
loadtime:0.082209825515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.082293033599854 / seconds
Query Executed:select id FROM `ia` where city='Bagley' && SIC_code='5541'DB:business_master_new
loadtime:0.083163976669312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.083213806152344 / seconds
Query Executed:select id FROM `ia` where city='Baldwin' && SIC_code='5541'DB:business_master_new
loadtime:0.083884954452515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.083985805511475 / seconds
Query Executed:select id FROM `ia` where city='Bancroft' && SIC_code='5541'DB:business_master_new
loadtime:0.084827899932861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes City' limit 1
loadtime:0.084900856018066 / seconds
Query Executed:select id FROM `ia` where city='Barnes City' && SIC_code='5541'DB:business_master_new
loadtime:0.085661888122559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnum' limit 1
loadtime:0.085711002349854 / seconds
Query Executed:select id FROM `ia` where city='Barnum' && SIC_code='5541'DB:business_master_new
loadtime:0.086437940597534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batavia' limit 1
loadtime:0.086565971374512 / seconds
Query Executed:select id FROM `ia` where city='Batavia' && SIC_code='5541'DB:business_master_new
loadtime:0.087540864944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.087693929672241 / seconds
Query Executed:select id FROM `ia` where city='Battle Creek' && SIC_code='5541'DB:business_master_new
loadtime:0.088635921478271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baxter' limit 1
loadtime:0.088820934295654 / seconds
Query Executed:select id FROM `ia` where city='Baxter' && SIC_code='5541'DB:business_master_new
loadtime:0.089718818664551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.089854955673218 / seconds
Query Executed:select id FROM `ia` where city='Bayard' && SIC_code='5541'DB:business_master_new
loadtime:0.090723037719727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon' limit 1
loadtime:0.090876817703247 / seconds
Query Executed:select id FROM `ia` where city='Beacon' && SIC_code='5541'DB:business_master_new
loadtime:0.091614961624146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaconsfield' limit 1
loadtime:0.09171199798584 / seconds
Query Executed:select id FROM `ia` where city='Beaconsfield' && SIC_code='5541'DB:business_master_new
loadtime:0.092258930206299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaman' limit 1
loadtime:0.092341899871826 / seconds
Query Executed:select id FROM `ia` where city='Beaman' && SIC_code='5541'DB:business_master_new
loadtime:0.093228816986084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.093323945999146 / seconds
Query Executed:select id FROM `ia` where city='Beaver' && SIC_code='5541'DB:business_master_new
loadtime:0.093899011611938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.093964815139771 / seconds
Query Executed:select id FROM `ia` where city='Bedford' && SIC_code='5541'DB:business_master_new
loadtime:0.094884872436523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Plaine' limit 1
loadtime:0.094969034194946 / seconds
Query Executed:select id FROM `ia` where city='Belle Plaine' && SIC_code='5541'DB:business_master_new
loadtime:0.095916032791138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.096014976501465 / seconds
Query Executed:select id FROM `ia` where city='Bellevue' && SIC_code='5541'DB:business_master_new
loadtime:0.096989870071411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmond' limit 1
loadtime:0.097064018249512 / seconds
Query Executed:select id FROM `ia` where city='Belmond' && SIC_code='5541'DB:business_master_new
loadtime:0.098030805587769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.098136901855469 / seconds
Query Executed:select id FROM `ia` where city='Bennett' && SIC_code='5541'DB:business_master_new
loadtime:0.099211931228638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.099354028701782 / seconds
Query Executed:select id FROM `ia` where city='Benton' && SIC_code='5541'DB:business_master_new
loadtime:0.10001397132874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernard' limit 1
loadtime:0.10008597373962 / seconds
Query Executed:select id FROM `ia` where city='Bernard' && SIC_code='5541'DB:business_master_new
loadtime:0.1009509563446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berwick' limit 1
loadtime:0.10103797912598 / seconds
Query Executed:select id FROM `ia` where city='Berwick' && SIC_code='5541'DB:business_master_new
loadtime:0.10164785385132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bettendorf' limit 1
loadtime:0.10170984268188 / seconds
Query Executed:select id FROM `ia` where city='Bettendorf' && SIC_code='5541'DB:business_master_new
loadtime:0.10335803031921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bevington' limit 1
loadtime:0.10351490974426 / seconds
Query Executed:select id FROM `ia` where city='Bevington' && SIC_code='5541'DB:business_master_new
loadtime:0.10421299934387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.10429787635803 / seconds
Query Executed:select id FROM `ia` where city='Big Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.10476589202881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.10481190681458 / seconds
Query Executed:select id FROM `ia` where city='Birmingham' && SIC_code='5541'DB:business_master_new
loadtime:0.10578393936157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairsburg' limit 1
loadtime:0.10586786270142 / seconds
Query Executed:select id FROM `ia` where city='Blairsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.106773853302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairstown' limit 1
loadtime:0.10686182975769 / seconds
Query Executed:select id FROM `ia` where city='Blairstown' && SIC_code='5541'DB:business_master_new
loadtime:0.10779500007629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakesburg' limit 1
loadtime:0.10785484313965 / seconds
Query Executed:select id FROM `ia` where city='Blakesburg' && SIC_code='5541'DB:business_master_new
loadtime:0.1088559627533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.10895681381226 / seconds
Query Executed:select id FROM `ia` where city='Blanchard' && SIC_code='5541'DB:business_master_new
loadtime:0.10948586463928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blencoe' limit 1
loadtime:0.10953092575073 / seconds
Query Executed:select id FROM `ia` where city='Blencoe' && SIC_code='5541'DB:business_master_new
loadtime:0.11001491546631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blockton' limit 1
loadtime:0.11009883880615 / seconds
Query Executed:select id FROM `ia` where city='Blockton' && SIC_code='5541'DB:business_master_new
loadtime:0.11077094078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.11087393760681 / seconds
Query Executed:select id FROM `ia` where city='Bloomfield' && SIC_code='5541'DB:business_master_new
loadtime:0.11180090904236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.11187195777893 / seconds
Query Executed:select id FROM `ia` where city='Blue Grass' && SIC_code='5541'DB:business_master_new
loadtime:0.11261391639709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bode' limit 1
loadtime:0.11269998550415 / seconds
Query Executed:select id FROM `ia` where city='Bode' && SIC_code='5541'DB:business_master_new
loadtime:0.11363291740417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonaparte' limit 1
loadtime:0.11370396614075 / seconds
Query Executed:select id FROM `ia` where city='Bonaparte' && SIC_code='5541'DB:business_master_new
loadtime:0.11442589759827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondurant' limit 1
loadtime:0.11455988883972 / seconds
Query Executed:select id FROM `ia` where city='Bondurant' && SIC_code='5541'DB:business_master_new
loadtime:0.11544394493103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.1155698299408 / seconds
Query Executed:select id FROM `ia` where city='Boone' && SIC_code='5541'DB:business_master_new
loadtime:0.11667585372925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booneville' limit 1
loadtime:0.11676788330078 / seconds
Query Executed:select id FROM `ia` where city='Booneville' && SIC_code='5541'DB:business_master_new
loadtime:0.11743783950806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouton' limit 1
loadtime:0.11753392219543 / seconds
Query Executed:select id FROM `ia` where city='Bouton' && SIC_code='5541'DB:business_master_new
loadtime:0.11855483055115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxholm' limit 1
loadtime:0.11867380142212 / seconds
Query Executed:select id FROM `ia` where city='Boxholm' && SIC_code='5541'DB:business_master_new
loadtime:0.11935496330261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyden' limit 1
loadtime:0.11941599845886 / seconds
Query Executed:select id FROM `ia` where city='Boyden' && SIC_code='5541'DB:business_master_new
loadtime:0.12005686759949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braddyville' limit 1
loadtime:0.12014102935791 / seconds
Query Executed:select id FROM `ia` where city='Braddyville' && SIC_code='5541'DB:business_master_new
loadtime:0.12090682983398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.12099695205688 / seconds
Query Executed:select id FROM `ia` where city='Bradford' && SIC_code='5541'DB:business_master_new
loadtime:0.12158489227295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradgate' limit 1
loadtime:0.12164497375488 / seconds
Query Executed:select id FROM `ia` where city='Bradgate' && SIC_code='5541'DB:business_master_new
loadtime:0.12230801582336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.12237787246704 / seconds
Query Executed:select id FROM `ia` where city='Brandon' && SIC_code='5541'DB:business_master_new
loadtime:0.12318181991577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brayton' limit 1
loadtime:0.12321996688843 / seconds
Query Executed:select id FROM `ia` where city='Brayton' && SIC_code='5541'DB:business_master_new
loadtime:0.12394285202026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breda' limit 1
loadtime:0.1240119934082 / seconds
Query Executed:select id FROM `ia` where city='Breda' && SIC_code='5541'DB:business_master_new
loadtime:0.12484002113342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.12493395805359 / seconds
Query Executed:select id FROM `ia` where city='Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:0.12580800056458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.12590289115906 / seconds
Query Executed:select id FROM `ia` where city='Brighton' && SIC_code='5541'DB:business_master_new
loadtime:0.12680101394653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.12690782546997 / seconds
Query Executed:select id FROM `ia` where city='Bristow' && SIC_code='5541'DB:business_master_new
loadtime:0.12775802612305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britt' limit 1
loadtime:0.12784886360168 / seconds
Query Executed:select id FROM `ia` where city='Britt' && SIC_code='5541'DB:business_master_new
loadtime:0.12871289253235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.12877893447876 / seconds
Query Executed:select id FROM `ia` where city='Bronson' && SIC_code='5541'DB:business_master_new
loadtime:0.12933993339539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.12946701049805 / seconds
Query Executed:select id FROM `ia` where city='Brooklyn' && SIC_code='5541'DB:business_master_new
loadtime:0.13023495674133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunsville' limit 1
loadtime:0.13030982017517 / seconds
Query Executed:select id FROM `ia` where city='Brunsville' && SIC_code='5541'DB:business_master_new
loadtime:0.13078594207764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.13085603713989 / seconds
Query Executed:select id FROM `ia` where city='Bryant' && SIC_code='5541'DB:business_master_new
loadtime:0.13152289390564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.13158893585205 / seconds
Query Executed:select id FROM `ia` where city='Buckeye' && SIC_code='5541'DB:business_master_new
loadtime:0.13210988044739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:0.13215589523315 / seconds
Query Executed:select id FROM `ia` where city='Buckingham' && SIC_code='5541'DB:business_master_new
loadtime:0.13282084465027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.13291382789612 / seconds
Query Executed:select id FROM `ia` where city='Buffalo' && SIC_code='5541'DB:business_master_new
loadtime:0.13375782966614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Center' limit 1
loadtime:0.13384485244751 / seconds
Query Executed:select id FROM `ia` where city='Buffalo Center' && SIC_code='5541'DB:business_master_new
loadtime:0.13478589057922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.13488984107971 / seconds
Query Executed:select id FROM `ia` where city='Burlington' && SIC_code='5541'DB:business_master_new
loadtime:0.1363959312439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnside' limit 1
loadtime:0.13648891448975 / seconds
Query Executed:select id FROM `ia` where city='Burnside' && SIC_code='5541'DB:business_master_new
loadtime:0.13695502281189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:0.13702392578125 / seconds
Query Executed:select id FROM `ia` where city='Burt' && SIC_code='5541'DB:business_master_new
loadtime:0.13790082931519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bussey' limit 1
loadtime:0.13800001144409 / seconds
Query Executed:select id FROM `ia` where city='Bussey' && SIC_code='5541'DB:business_master_new
loadtime:0.13879799842834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calamus' limit 1
loadtime:0.13888788223267 / seconds
Query Executed:select id FROM `ia` where city='Calamus' && SIC_code='5541'DB:business_master_new
loadtime:0.13976502418518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callender' limit 1
loadtime:0.13984799385071 / seconds
Query Executed:select id FROM `ia` where city='Callender' && SIC_code='5541'DB:business_master_new
loadtime:0.14075398445129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calmar' limit 1
loadtime:0.14084696769714 / seconds
Query Executed:select id FROM `ia` where city='Calmar' && SIC_code='5541'DB:business_master_new
loadtime:0.14176392555237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.14183282852173 / seconds
Query Executed:select id FROM `ia` where city='Calumet' && SIC_code='5541'DB:business_master_new
loadtime:0.14236998558044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camanche' limit 1
loadtime:0.14245390892029 / seconds
Query Executed:select id FROM `ia` where city='Camanche' && SIC_code='5541'DB:business_master_new
loadtime:0.14337992668152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.1434600353241 / seconds
Query Executed:select id FROM `ia` where city='Cambridge' && SIC_code='5541'DB:business_master_new
loadtime:0.14396500587463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cantril' limit 1
loadtime:0.14399290084839 / seconds
Query Executed:select id FROM `ia` where city='Cantril' && SIC_code='5541'DB:business_master_new
loadtime:0.14484190940857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbon' limit 1
loadtime:0.1449248790741 / seconds
Query Executed:select id FROM `ia` where city='Carbon' && SIC_code='5541'DB:business_master_new
loadtime:0.14539694786072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.14544796943665 / seconds
Query Executed:select id FROM `ia` where city='Carlisle' && SIC_code='5541'DB:business_master_new
loadtime:0.14635181427002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carnarvon' limit 1
loadtime:0.1464409828186 / seconds
Query Executed:select id FROM `ia` where city='Carnarvon' && SIC_code='5541'DB:business_master_new
loadtime:0.14697480201721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.1470148563385 / seconds
Query Executed:select id FROM `ia` where city='Carpenter' && SIC_code='5541'DB:business_master_new
loadtime:0.14753699302673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.14761400222778 / seconds
Query Executed:select id FROM `ia` where city='Carroll' && SIC_code='5541'DB:business_master_new
loadtime:0.14877891540527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.1488618850708 / seconds
Query Executed:select id FROM `ia` where city='Carson' && SIC_code='5541'DB:business_master_new
loadtime:0.14970588684082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter Lake' limit 1
loadtime:0.14979100227356 / seconds
Query Executed:select id FROM `ia` where city='Carter Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.15056395530701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.15066599845886 / seconds
Query Executed:select id FROM `ia` where city='Cascade' && SIC_code='5541'DB:business_master_new
loadtime:0.15165591239929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casey' limit 1
loadtime:0.15178489685059 / seconds
Query Executed:select id FROM `ia` where city='Casey' && SIC_code='5541'DB:business_master_new
loadtime:0.15255784988403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:0.15271091461182 / seconds
Query Executed:select id FROM `ia` where city='Castalia' && SIC_code='5541'DB:business_master_new
loadtime:0.15369391441345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castana' limit 1
loadtime:0.15373587608337 / seconds
Query Executed:select id FROM `ia` where city='Castana' && SIC_code='5541'DB:business_master_new
loadtime:0.15472292900085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.1548638343811 / seconds
Query Executed:select id FROM `ia` where city='Cedar' && SIC_code='5541'DB:business_master_new
loadtime:0.15552592277527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:0.15557289123535 / seconds
Query Executed:select id FROM `ia` where city='Cedar Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.15722298622131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Rapids' limit 1
loadtime:0.15728092193604 / seconds
Query Executed:select id FROM `ia` where city='Cedar Rapids' && SIC_code='5541'DB:business_master_new
loadtime:0.16466283798218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Junction' limit 1
loadtime:0.1647789478302 / seconds
Query Executed:select id FROM `ia` where city='Center Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.1655478477478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Point' limit 1
loadtime:0.16563701629639 / seconds
Query Executed:select id FROM `ia` where city='Center Point' && SIC_code='5541'DB:business_master_new
loadtime:0.16653084754944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.16668295860291 / seconds
Query Executed:select id FROM `ia` where city='Centerville' && SIC_code='5541'DB:business_master_new
loadtime:0.16776895523071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.16786789894104 / seconds
Query Executed:select id FROM `ia` where city='Central City' && SIC_code='5541'DB:business_master_new
loadtime:0.16880488395691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.1689019203186 / seconds
Query Executed:select id FROM `ia` where city='Chapin' && SIC_code='5541'DB:business_master_new
loadtime:0.16936302185059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chariton' limit 1
loadtime:0.16943693161011 / seconds
Query Executed:select id FROM `ia` where city='Chariton' && SIC_code='5541'DB:business_master_new
loadtime:0.17056894302368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:0.17072296142578 / seconds
Query Executed:select id FROM `ia` where city='Charles City' && SIC_code='5541'DB:business_master_new
loadtime:0.17177796363831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.17186594009399 / seconds
Query Executed:select id FROM `ia` where city='Charlotte' && SIC_code='5541'DB:business_master_new
loadtime:0.17280292510986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charter Oak' limit 1
loadtime:0.17289280891418 / seconds
Query Executed:select id FROM `ia` where city='Charter Oak' && SIC_code='5541'DB:business_master_new
loadtime:0.17379999160767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:0.17389702796936 / seconds
Query Executed:select id FROM `ia` where city='Chatsworth' && SIC_code='5541'DB:business_master_new
loadtime:0.17431282997131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.17435598373413 / seconds
Query Executed:select id FROM `ia` where city='Chelsea' && SIC_code='5541'DB:business_master_new
loadtime:0.17540788650513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.17552280426025 / seconds
Query Executed:select id FROM `ia` where city='Cherokee' && SIC_code='5541'DB:business_master_new
loadtime:0.17660284042358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.17679882049561 / seconds
Query Executed:select id FROM `ia` where city='Chester' && SIC_code='5541'DB:business_master_new
loadtime:0.17759799957275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chillicothe' limit 1
loadtime:0.17769694328308 / seconds
Query Executed:select id FROM `ia` where city='Chillicothe' && SIC_code='5541'DB:business_master_new
loadtime:0.17815899848938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churdan' limit 1
loadtime:0.17824792861938 / seconds
Query Executed:select id FROM `ia` where city='Churdan' && SIC_code='5541'DB:business_master_new
loadtime:0.17913103103638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cincinnati' limit 1
loadtime:0.17919182777405 / seconds
Query Executed:select id FROM `ia` where city='Cincinnati' && SIC_code='5541'DB:business_master_new
loadtime:0.17980980873108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:0.17990803718567 / seconds
Query Executed:select id FROM `ia` where city='Clare' && SIC_code='5541'DB:business_master_new
loadtime:0.18094992637634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarence' limit 1
loadtime:0.1810519695282 / seconds
Query Executed:select id FROM `ia` where city='Clarence' && SIC_code='5541'DB:business_master_new
loadtime:0.18178200721741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarinda' limit 1
loadtime:0.18186688423157 / seconds
Query Executed:select id FROM `ia` where city='Clarinda' && SIC_code='5541'DB:business_master_new
loadtime:0.18288898468018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarion' limit 1
loadtime:0.18294382095337 / seconds
Query Executed:select id FROM `ia` where city='Clarion' && SIC_code='5541'DB:business_master_new
loadtime:0.18389797210693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.18398880958557 / seconds
Query Executed:select id FROM `ia` where city='Clarksville' && SIC_code='5541'DB:business_master_new
loadtime:0.18476295471191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.18481993675232 / seconds
Query Executed:select id FROM `ia` where city='Clear Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.18597984313965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.18605899810791 / seconds
Query Executed:select id FROM `ia` where city='Clearfield' && SIC_code='5541'DB:business_master_new
loadtime:0.18701100349426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleghorn' limit 1
loadtime:0.18719696998596 / seconds
Query Executed:select id FROM `ia` where city='Cleghorn' && SIC_code='5541'DB:business_master_new
loadtime:0.18809199333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemons' limit 1
loadtime:0.18814301490784 / seconds
Query Executed:select id FROM `ia` where city='Clemons' && SIC_code='5541'DB:business_master_new
loadtime:0.18887591362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clermont' limit 1
loadtime:0.18893790245056 / seconds
Query Executed:select id FROM `ia` where city='Clermont' && SIC_code='5541'DB:business_master_new
loadtime:0.18977999687195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climbing Hill' limit 1
loadtime:0.18983602523804 / seconds
Query Executed:select id FROM `ia` where city='Climbing Hill' && SIC_code='5541'DB:business_master_new
loadtime:0.19037890434265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.1904628276825 / seconds
Query Executed:select id FROM `ia` where city='Clinton' && SIC_code='5541'DB:business_master_new
loadtime:0.19186401367188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.19192886352539 / seconds
Query Executed:select id FROM `ia` where city='Clio' && SIC_code='5541'DB:business_master_new
loadtime:0.19251799583435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clive' limit 1
loadtime:0.19261598587036 / seconds
Query Executed:select id FROM `ia` where city='Clive' && SIC_code='5541'DB:business_master_new
loadtime:0.19381999969482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clutier' limit 1
loadtime:0.1938898563385 / seconds
Query Executed:select id FROM `ia` where city='Clutier' && SIC_code='5541'DB:business_master_new
loadtime:0.19502997398376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coggon' limit 1
loadtime:0.19513487815857 / seconds
Query Executed:select id FROM `ia` where city='Coggon' && SIC_code='5541'DB:business_master_new
loadtime:0.19602298736572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coin' limit 1
loadtime:0.19612097740173 / seconds
Query Executed:select id FROM `ia` where city='Coin' && SIC_code='5541'DB:business_master_new
loadtime:0.19699788093567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colesburg' limit 1
loadtime:0.19705891609192 / seconds
Query Executed:select id FROM `ia` where city='Colesburg' && SIC_code='5541'DB:business_master_new
loadtime:0.19815397262573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.19828701019287 / seconds
Query Executed:select id FROM `ia` where city='Colfax' && SIC_code='5541'DB:business_master_new
loadtime:0.19929099082947 / seconds
Query loaded from cache:select * from geodata_geocity where city='College Springs' limit 1
loadtime:0.19942593574524 / seconds
Query Executed:select id FROM `ia` where city='College Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.20012402534485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.20021200180054 / seconds
Query Executed:select id FROM `ia` where city='Collins' && SIC_code='5541'DB:business_master_new
loadtime:0.20126390457153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colo' limit 1
loadtime:0.20137286186218 / seconds
Query Executed:select id FROM `ia` where city='Colo' && SIC_code='5541'DB:business_master_new
loadtime:0.20230793952942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.20245003700256 / seconds
Query Executed:select id FROM `ia` where city='Columbia' && SIC_code='5541'DB:business_master_new
loadtime:0.20321083068848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus City' limit 1
loadtime:0.20329785346985 / seconds
Query Executed:select id FROM `ia` where city='Columbus City' && SIC_code='5541'DB:business_master_new
loadtime:0.20396590232849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Jct' limit 1
loadtime:0.20401382446289 / seconds
Query Executed:select id FROM `ia` where city='Columbus Jct' && SIC_code='5541'DB:business_master_new
loadtime:0.20456981658936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Junction' limit 1
loadtime:0.20465683937073 / seconds
Query Executed:select id FROM `ia` where city='Columbus Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.20556688308716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colwell' limit 1
loadtime:0.20565581321716 / seconds
Query Executed:select id FROM `ia` where city='Colwell' && SIC_code='5541'DB:business_master_new
loadtime:0.20622396469116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conesville' limit 1
loadtime:0.20628499984741 / seconds
Query Executed:select id FROM `ia` where city='Conesville' && SIC_code='5541'DB:business_master_new
loadtime:0.20708894729614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrad' limit 1
loadtime:0.2071750164032 / seconds
Query Executed:select id FROM `ia` where city='Conrad' && SIC_code='5541'DB:business_master_new
loadtime:0.20809698104858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conroy' limit 1
loadtime:0.20817899703979 / seconds
Query Executed:select id FROM `ia` where city='Conroy' && SIC_code='5541'DB:business_master_new
loadtime:0.20883989334106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Rapids' limit 1
loadtime:0.20892381668091 / seconds
Query Executed:select id FROM `ia` where city='Coon Rapids' && SIC_code='5541'DB:business_master_new
loadtime:0.20981884002686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooper' limit 1
loadtime:0.20990490913391 / seconds
Query Executed:select id FROM `ia` where city='Cooper' && SIC_code='5541'DB:business_master_new
loadtime:0.21048498153687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coralville' limit 1
loadtime:0.21060085296631 / seconds
Query Executed:select id FROM `ia` where city='Coralville' && SIC_code='5541'DB:business_master_new
loadtime:0.21166300773621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corning' limit 1
loadtime:0.21178197860718 / seconds
Query Executed:select id FROM `ia` where city='Corning' && SIC_code='5541'DB:business_master_new
loadtime:0.21269989013672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Correctionville' limit 1
loadtime:0.21282291412354 / seconds
Query Executed:select id FROM `ia` where city='Correctionville' && SIC_code='5541'DB:business_master_new
loadtime:0.21355891227722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corwith' limit 1
loadtime:0.21367788314819 / seconds
Query Executed:select id FROM `ia` where city='Corwith' && SIC_code='5541'DB:business_master_new
loadtime:0.21464896202087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corydon' limit 1
loadtime:0.21473598480225 / seconds
Query Executed:select id FROM `ia` where city='Corydon' && SIC_code='5541'DB:business_master_new
loadtime:0.21555685997009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coulter' limit 1
loadtime:0.21561694145203 / seconds
Query Executed:select id FROM `ia` where city='Coulter' && SIC_code='5541'DB:business_master_new
loadtime:0.21612787246704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council Bluffs' limit 1
loadtime:0.21616291999817 / seconds
Query Executed:select id FROM `ia` where city='Council Bluffs' && SIC_code='5541'DB:business_master_new
loadtime:0.21816682815552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawfordsville' limit 1
loadtime:0.2182309627533 / seconds
Query Executed:select id FROM `ia` where city='Crawfordsville' && SIC_code='5541'DB:business_master_new
loadtime:0.21922397613525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crescent' limit 1
loadtime:0.21927189826965 / seconds
Query Executed:select id FROM `ia` where city='Crescent' && SIC_code='5541'DB:business_master_new
loadtime:0.22010898590088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresco' limit 1
loadtime:0.22015690803528 / seconds
Query Executed:select id FROM `ia` where city='Cresco' && SIC_code='5541'DB:business_master_new
loadtime:0.22111892700195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.22117900848389 / seconds
Query Executed:select id FROM `ia` where city='Creston' && SIC_code='5541'DB:business_master_new
loadtime:0.22215700149536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.22221803665161 / seconds
Query Executed:select id FROM `ia` where city='Cromwell' && SIC_code='5541'DB:business_master_new
loadtime:0.22277903556824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Lake' limit 1
loadtime:0.22286891937256 / seconds
Query Executed:select id FROM `ia` where city='Crystal Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.22349786758423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.22357392311096 / seconds
Query Executed:select id FROM `ia` where city='Cumberland' && SIC_code='5541'DB:business_master_new
loadtime:0.22466087341309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumming' limit 1
loadtime:0.22472095489502 / seconds
Query Executed:select id FROM `ia` where city='Cumming' && SIC_code='5541'DB:business_master_new
loadtime:0.22558283805847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curlew' limit 1
loadtime:0.22567391395569 / seconds
Query Executed:select id FROM `ia` where city='Curlew' && SIC_code='5541'DB:business_master_new
loadtime:0.22645092010498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:0.22657680511475 / seconds
Query Executed:select id FROM `ia` where city='Cushing' && SIC_code='5541'DB:business_master_new
loadtime:0.2274649143219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cylinder' limit 1
loadtime:0.2276029586792 / seconds
Query Executed:select id FROM `ia` where city='Cylinder' && SIC_code='5541'DB:business_master_new
loadtime:0.22868895530701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota City' limit 1
loadtime:0.22877788543701 / seconds
Query Executed:select id FROM `ia` where city='Dakota City' && SIC_code='5541'DB:business_master_new
loadtime:0.2296359539032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.2298059463501 / seconds
Query Executed:select id FROM `ia` where city='Dallas' && SIC_code='5541'DB:business_master_new
loadtime:0.23035597801208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas Center' limit 1
loadtime:0.23044681549072 / seconds
Query Executed:select id FROM `ia` where city='Dallas Center' && SIC_code='5541'DB:business_master_new
loadtime:0.23127484321594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:0.23132300376892 / seconds
Query Executed:select id FROM `ia` where city='Dana' && SIC_code='5541'DB:business_master_new
loadtime:0.23194098472595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.23200583457947 / seconds
Query Executed:select id FROM `ia` where city='Danbury' && SIC_code='5541'DB:business_master_new
loadtime:0.23286294937134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.23294401168823 / seconds
Query Executed:select id FROM `ia` where city='Danville' && SIC_code='5541'DB:business_master_new
loadtime:0.23361301422119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:0.23365902900696 / seconds
Query Executed:select id FROM `ia` where city='Davenport' && SIC_code='5541'DB:business_master_new
loadtime:0.23967695236206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis City' limit 1
loadtime:0.23981189727783 / seconds
Query Executed:select id FROM `ia` where city='Davis City' && SIC_code='5541'DB:business_master_new
loadtime:0.24057483673096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawson' limit 1
loadtime:0.24065494537354 / seconds
Query Executed:select id FROM `ia` where city='Dawson' && SIC_code='5541'DB:business_master_new
loadtime:0.24125790596008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.24130702018738 / seconds
Query Executed:select id FROM `ia` where city='Dayton' && SIC_code='5541'DB:business_master_new
loadtime:0.2422468662262 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:0.24233102798462 / seconds
Query Executed:select id FROM `ia` where city='De Soto' && SIC_code='5541'DB:business_master_new
loadtime:0.24321985244751 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Witt' limit 1
loadtime:0.24327397346497 / seconds
Query Executed:select id FROM `ia` where city='De Witt' && SIC_code='5541'DB:business_master_new
loadtime:0.24433588981628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.24443101882935 / seconds
Query Executed:select id FROM `ia` where city='Decatur' && SIC_code='5541'DB:business_master_new
loadtime:0.24522399902344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decorah' limit 1
loadtime:0.245285987854 / seconds
Query Executed:select id FROM `ia` where city='Decorah' && SIC_code='5541'DB:business_master_new
loadtime:0.2465980052948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.24669981002808 / seconds
Query Executed:select id FROM `ia` where city='Dedham' && SIC_code='5541'DB:business_master_new
loadtime:0.24748182296753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.24758100509644 / seconds
Query Executed:select id FROM `ia` where city='Deep River' && SIC_code='5541'DB:business_master_new
loadtime:0.24876499176025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Defiance' limit 1
loadtime:0.2488489151001 / seconds
Query Executed:select id FROM `ia` where city='Defiance' && SIC_code='5541'DB:business_master_new
loadtime:0.24994492530823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:0.25000500679016 / seconds
Query Executed:select id FROM `ia` where city='Delaware' && SIC_code='5541'DB:business_master_new
loadtime:0.25059294700623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delhi' limit 1
loadtime:0.25078701972961 / seconds
Query Executed:select id FROM `ia` where city='Delhi' && SIC_code='5541'DB:business_master_new
loadtime:0.25160098075867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmar' limit 1
loadtime:0.25170183181763 / seconds
Query Executed:select id FROM `ia` where city='Delmar' && SIC_code='5541'DB:business_master_new
loadtime:0.25272393226624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deloit' limit 1
loadtime:0.25284600257874 / seconds
Query Executed:select id FROM `ia` where city='Deloit' && SIC_code='5541'DB:business_master_new
loadtime:0.25344085693359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.25350189208984 / seconds
Query Executed:select id FROM `ia` where city='Delta' && SIC_code='5541'DB:business_master_new
loadtime:0.25420689582825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denison' limit 1
loadtime:0.25429081916809 / seconds
Query Executed:select id FROM `ia` where city='Denison' && SIC_code='5541'DB:business_master_new
loadtime:0.25535702705383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.25546097755432 / seconds
Query Executed:select id FROM `ia` where city='Denmark' && SIC_code='5541'DB:business_master_new
loadtime:0.25618195533752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.25623083114624 / seconds
Query Executed:select id FROM `ia` where city='Denver' && SIC_code='5541'DB:business_master_new
loadtime:0.25699090957642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.2570788860321 / seconds
Query Executed:select id FROM `ia` where city='Derby' && SIC_code='5541'DB:business_master_new
loadtime:0.25771999359131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.25782680511475 / seconds
Query Executed:select id FROM `ia` where city='Des Moines' && SIC_code='5541'DB:business_master_new
loadtime:0.26484680175781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewar' limit 1
loadtime:0.26495981216431 / seconds
Query Executed:select id FROM `ia` where city='Dewar' && SIC_code='5541'DB:business_master_new
loadtime:0.26572394371033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.26586580276489 / seconds
Query Executed:select id FROM `ia` where city='Dexter' && SIC_code='5541'DB:business_master_new
loadtime:0.26703000068665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diagonal' limit 1
loadtime:0.26712203025818 / seconds
Query Executed:select id FROM `ia` where city='Diagonal' && SIC_code='5541'DB:business_master_new
loadtime:0.26810383796692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickens' limit 1
loadtime:0.26820683479309 / seconds
Query Executed:select id FROM `ia` where city='Dickens' && SIC_code='5541'DB:business_master_new
loadtime:0.26915597915649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dike' limit 1
loadtime:0.26921582221985 / seconds
Query Executed:select id FROM `ia` where city='Dike' && SIC_code='5541'DB:business_master_new
loadtime:0.26996397972107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.27001595497131 / seconds
Query Executed:select id FROM `ia` where city='Dixon' && SIC_code='5541'DB:business_master_new
loadtime:0.27111792564392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolliver' limit 1
loadtime:0.27116799354553 / seconds
Query Executed:select id FROM `ia` where city='Dolliver' && SIC_code='5541'DB:business_master_new
loadtime:0.27171087265015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donahue' limit 1
loadtime:0.27180290222168 / seconds
Query Executed:select id FROM `ia` where city='Donahue' && SIC_code='5541'DB:business_master_new
loadtime:0.27277898788452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donnellson' limit 1
loadtime:0.27285981178284 / seconds
Query Executed:select id FROM `ia` where city='Donnellson' && SIC_code='5541'DB:business_master_new
loadtime:0.27379989624023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doon' limit 1
loadtime:0.27390480041504 / seconds
Query Executed:select id FROM `ia` where city='Doon' && SIC_code='5541'DB:business_master_new
loadtime:0.27480483055115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.27490186691284 / seconds
Query Executed:select id FROM `ia` where city='Dorchester' && SIC_code='5541'DB:business_master_new
loadtime:0.27580595016479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douds' limit 1
loadtime:0.27587985992432 / seconds
Query Executed:select id FROM `ia` where city='Douds' && SIC_code='5541'DB:business_master_new
loadtime:0.2768669128418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dougherty' limit 1
loadtime:0.27699398994446 / seconds
Query Executed:select id FROM `ia` where city='Dougherty' && SIC_code='5541'DB:business_master_new
loadtime:0.27785396575928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dow City' limit 1
loadtime:0.27798891067505 / seconds
Query Executed:select id FROM `ia` where city='Dow City' && SIC_code='5541'DB:business_master_new
loadtime:0.27922487258911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dows' limit 1
loadtime:0.27926683425903 / seconds
Query Executed:select id FROM `ia` where city='Dows' && SIC_code='5541'DB:business_master_new
loadtime:0.28006386756897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakesville' limit 1
loadtime:0.2801239490509 / seconds
Query Executed:select id FROM `ia` where city='Drakesville' && SIC_code='5541'DB:business_master_new
loadtime:0.28085780143738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dubuque' limit 1
loadtime:0.28091883659363 / seconds
Query Executed:select id FROM `ia` where city='Dubuque' && SIC_code='5541'DB:business_master_new
loadtime:0.28325796127319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:0.28331899642944 / seconds
Query Executed:select id FROM `ia` where city='Dumont' && SIC_code='5541'DB:business_master_new
loadtime:0.28438782691956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncombe' limit 1
loadtime:0.28455281257629 / seconds
Query Executed:select id FROM `ia` where city='Duncombe' && SIC_code='5541'DB:business_master_new
loadtime:0.2857768535614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.28586387634277 / seconds
Query Executed:select id FROM `ia` where city='Dundee' && SIC_code='5541'DB:business_master_new
loadtime:0.28665494918823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunkerton' limit 1
loadtime:0.28672480583191 / seconds
Query Executed:select id FROM `ia` where city='Dunkerton' && SIC_code='5541'DB:business_master_new
loadtime:0.28751683235168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunlap' limit 1
loadtime:0.28759694099426 / seconds
Query Executed:select id FROM `ia` where city='Dunlap' && SIC_code='5541'DB:business_master_new
loadtime:0.28850984573364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:0.28864693641663 / seconds
Query Executed:select id FROM `ia` where city='Durango' && SIC_code='5541'DB:business_master_new
loadtime:0.28975987434387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.28984498977661 / seconds
Query Executed:select id FROM `ia` where city='Durant' && SIC_code='5541'DB:business_master_new
loadtime:0.29062700271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyersville' limit 1
loadtime:0.29072093963623 / seconds
Query Executed:select id FROM `ia` where city='Dyersville' && SIC_code='5541'DB:business_master_new
loadtime:0.29167580604553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dysart' limit 1
loadtime:0.29176998138428 / seconds
Query Executed:select id FROM `ia` where city='Dysart' && SIC_code='5541'DB:business_master_new
loadtime:0.29266285896301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Grove' limit 1
loadtime:0.29277181625366 / seconds
Query Executed:select id FROM `ia` where city='Eagle Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.29375791549683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlham' limit 1
loadtime:0.29381895065308 / seconds
Query Executed:select id FROM `ia` where city='Earlham' && SIC_code='5541'DB:business_master_new
loadtime:0.29472589492798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earling' limit 1
loadtime:0.29484486579895 / seconds
Query Executed:select id FROM `ia` where city='Earling' && SIC_code='5541'DB:business_master_new
loadtime:0.2957170009613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlville' limit 1
loadtime:0.29583382606506 / seconds
Query Executed:select id FROM `ia` where city='Earlville' && SIC_code='5541'DB:business_master_new
loadtime:0.29671883583069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early' limit 1
loadtime:0.29682803153992 / seconds
Query Executed:select id FROM `ia` where city='Early' && SIC_code='5541'DB:business_master_new
loadtime:0.29765486717224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eddyville' limit 1
loadtime:0.29777193069458 / seconds
Query Executed:select id FROM `ia` where city='Eddyville' && SIC_code='5541'DB:business_master_new
loadtime:0.29859590530396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.29867887496948 / seconds
Query Executed:select id FROM `ia` where city='Edgewood' && SIC_code='5541'DB:business_master_new
loadtime:0.29958486557007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:0.29973793029785 / seconds
Query Executed:select id FROM `ia` where city='Elberon' && SIC_code='5541'DB:business_master_new
loadtime:0.30059885978699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldon' limit 1
loadtime:0.30065894126892 / seconds
Query Executed:select id FROM `ia` where city='Eldon' && SIC_code='5541'DB:business_master_new
loadtime:0.30156588554382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldora' limit 1
loadtime:0.30172300338745 / seconds
Query Executed:select id FROM `ia` where city='Eldora' && SIC_code='5541'DB:business_master_new
loadtime:0.30269503593445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:0.3027548789978 / seconds
Query Executed:select id FROM `ia` where city='Eldorado' && SIC_code='5541'DB:business_master_new
loadtime:0.30302500724792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldridge' limit 1
loadtime:0.3030788898468 / seconds
Query Executed:select id FROM `ia` where city='Eldridge' && SIC_code='5541'DB:business_master_new
loadtime:0.30384302139282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.30393886566162 / seconds
Query Executed:select id FROM `ia` where city='Elgin' && SIC_code='5541'DB:business_master_new
loadtime:0.30464291572571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Horn' limit 1
loadtime:0.30472588539124 / seconds
Query Executed:select id FROM `ia` where city='Elk Horn' && SIC_code='5541'DB:business_master_new
loadtime:0.30555081367493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Run Heights' limit 1
loadtime:0.30570602416992 / seconds
Query Executed:select id FROM `ia` where city='Elk Run Heights' && SIC_code='5541'DB:business_master_new
loadtime:0.30621790885925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkader' limit 1
loadtime:0.30626201629639 / seconds
Query Executed:select id FROM `ia` where city='Elkader' && SIC_code='5541'DB:business_master_new
loadtime:0.30716180801392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart' limit 1
loadtime:0.30721092224121 / seconds
Query Executed:select id FROM `ia` where city='Elkhart' && SIC_code='5541'DB:business_master_new
loadtime:0.30801391601562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkport' limit 1
loadtime:0.30809998512268 / seconds
Query Executed:select id FROM `ia` where city='Elkport' && SIC_code='5541'DB:business_master_new
loadtime:0.30872893333435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.30885291099548 / seconds
Query Executed:select id FROM `ia` where city='Elliott' && SIC_code='5541'DB:business_master_new
loadtime:0.30954003334045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellston' limit 1
loadtime:0.30961298942566 / seconds
Query Executed:select id FROM `ia` where city='Ellston' && SIC_code='5541'DB:business_master_new
loadtime:0.31036281585693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.31041502952576 / seconds
Query Executed:select id FROM `ia` where city='Ellsworth' && SIC_code='5541'DB:business_master_new
loadtime:0.31109881401062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elma' limit 1
loadtime:0.31115388870239 / seconds
Query Executed:select id FROM `ia` where city='Elma' && SIC_code='5541'DB:business_master_new
loadtime:0.31188201904297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:0.31198692321777 / seconds
Query Executed:select id FROM `ia` where city='Elwood' && SIC_code='5541'DB:business_master_new
loadtime:0.31244587898254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ely' limit 1
loadtime:0.31256890296936 / seconds
Query Executed:select id FROM `ia` where city='Ely' && SIC_code='5541'DB:business_master_new
loadtime:0.31341290473938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:0.31357002258301 / seconds
Query Executed:select id FROM `ia` where city='Emerson' && SIC_code='5541'DB:business_master_new
loadtime:0.3143298625946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmetsburg' limit 1
loadtime:0.31441283226013 / seconds
Query Executed:select id FROM `ia` where city='Emmetsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.3153920173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epworth' limit 1
loadtime:0.31555199623108 / seconds
Query Executed:select id FROM `ia` where city='Epworth' && SIC_code='5541'DB:business_master_new
loadtime:0.31652283668518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.31668281555176 / seconds
Query Executed:select id FROM `ia` where city='Essex' && SIC_code='5541'DB:business_master_new
loadtime:0.31744790077209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estherville' limit 1
loadtime:0.31754994392395 / seconds
Query Executed:select id FROM `ia` where city='Estherville' && SIC_code='5541'DB:business_master_new
loadtime:0.31867003440857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansdale' limit 1
loadtime:0.31877398490906 / seconds
Query Executed:select id FROM `ia` where city='Evansdale' && SIC_code='5541'DB:business_master_new
loadtime:0.31961989402771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everly' limit 1
loadtime:0.31972694396973 / seconds
Query Executed:select id FROM `ia` where city='Everly' && SIC_code='5541'DB:business_master_new
loadtime:0.32061386108398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exira' limit 1
loadtime:0.32074594497681 / seconds
Query Executed:select id FROM `ia` where city='Exira' && SIC_code='5541'DB:business_master_new
loadtime:0.32166290283203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exline' limit 1
loadtime:0.32178092002869 / seconds
Query Executed:select id FROM `ia` where city='Exline' && SIC_code='5541'DB:business_master_new
loadtime:0.32245302200317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairbank' limit 1
loadtime:0.32252788543701 / seconds
Query Executed:select id FROM `ia` where city='Fairbank' && SIC_code='5541'DB:business_master_new
loadtime:0.32329893112183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.32335090637207 / seconds
Query Executed:select id FROM `ia` where city='Fairfax' && SIC_code='5541'DB:business_master_new
loadtime:0.32425498962402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.32434892654419 / seconds
Query Executed:select id FROM `ia` where city='Fairfield' && SIC_code='5541'DB:business_master_new
loadtime:0.32561302185059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farley' limit 1
loadtime:0.3257999420166 / seconds
Query Executed:select id FROM `ia` where city='Farley' && SIC_code='5541'DB:business_master_new
loadtime:0.32671093940735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmersburg' limit 1
loadtime:0.32682681083679 / seconds
Query Executed:select id FROM `ia` where city='Farmersburg' && SIC_code='5541'DB:business_master_new
loadtime:0.32758402824402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.32772588729858 / seconds
Query Executed:select id FROM `ia` where city='Farmington' && SIC_code='5541'DB:business_master_new
loadtime:0.32865381240845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnhamville' limit 1
loadtime:0.3287718296051 / seconds
Query Executed:select id FROM `ia` where city='Farnhamville' && SIC_code='5541'DB:business_master_new
loadtime:0.32979393005371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farragut' limit 1
loadtime:0.32988595962524 / seconds
Query Executed:select id FROM `ia` where city='Farragut' && SIC_code='5541'DB:business_master_new
loadtime:0.33072280883789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.33086085319519 / seconds
Query Executed:select id FROM `ia` where city='Fayette' && SIC_code='5541'DB:business_master_new
loadtime:0.33163595199585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:0.33172798156738 / seconds
Query Executed:select id FROM `ia` where city='Fenton' && SIC_code='5541'DB:business_master_new
loadtime:0.33264994621277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:0.33272480964661 / seconds
Query Executed:select id FROM `ia` where city='Ferguson' && SIC_code='5541'DB:business_master_new
loadtime:0.33332180976868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fertile' limit 1
loadtime:0.33341002464294 / seconds
Query Executed:select id FROM `ia` where city='Fertile' && SIC_code='5541'DB:business_master_new
loadtime:0.33432197570801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Festina' limit 1
loadtime:0.33442187309265 / seconds
Query Executed:select id FROM `ia` where city='Festina' && SIC_code='5541'DB:business_master_new
loadtime:0.33490395545959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floris' limit 1
loadtime:0.33496689796448 / seconds
Query Executed:select id FROM `ia` where city='Floris' && SIC_code='5541'DB:business_master_new
loadtime:0.33543300628662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.33556485176086 / seconds
Query Executed:select id FROM `ia` where city='Floyd' && SIC_code='5541'DB:business_master_new
loadtime:0.33646297454834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fonda' limit 1
loadtime:0.33656597137451 / seconds
Query Executed:select id FROM `ia` where city='Fonda' && SIC_code='5541'DB:business_master_new
loadtime:0.33752989768982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontanelle' limit 1
loadtime:0.33764100074768 / seconds
Query Executed:select id FROM `ia` where city='Fontanelle' && SIC_code='5541'DB:business_master_new
loadtime:0.33856797218323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:0.33870983123779 / seconds
Query Executed:select id FROM `ia` where city='Forest City' && SIC_code='5541'DB:business_master_new
loadtime:0.33980703353882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:0.3399019241333 / seconds
Query Executed:select id FROM `ia` where city='Fort Atkinson' && SIC_code='5541'DB:business_master_new
loadtime:0.34080600738525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dodge' limit 1
loadtime:0.3408989906311 / seconds
Query Executed:select id FROM `ia` where city='Fort Dodge' && SIC_code='5541'DB:business_master_new
loadtime:0.34267401695251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Madison' limit 1
loadtime:0.34274387359619 / seconds
Query Executed:select id FROM `ia` where city='Fort Madison' && SIC_code='5541'DB:business_master_new
loadtime:0.3439519405365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:0.3440408706665 / seconds
Query Executed:select id FROM `ia` where city='Fostoria' && SIC_code='5541'DB:business_master_new
loadtime:0.34466791152954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:0.34477496147156 / seconds
Query Executed:select id FROM `ia` where city='Fredericksburg' && SIC_code='5541'DB:business_master_new
loadtime:0.34567284584045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederika' limit 1
loadtime:0.34576797485352 / seconds
Query Executed:select id FROM `ia` where city='Frederika' && SIC_code='5541'DB:business_master_new
loadtime:0.34646391868591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.34660196304321 / seconds
Query Executed:select id FROM `ia` where city='Fremont' && SIC_code='5541'DB:business_master_new
loadtime:0.34751391410828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.3476128578186 / seconds
Query Executed:select id FROM `ia` where city='Fruitland' && SIC_code='5541'DB:business_master_new
loadtime:0.34828686714172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galt' limit 1
loadtime:0.34835481643677 / seconds
Query Executed:select id FROM `ia` where city='Galt' && SIC_code='5541'DB:business_master_new
loadtime:0.34889101982117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galva' limit 1
loadtime:0.34894299507141 / seconds
Query Executed:select id FROM `ia` where city='Galva' && SIC_code='5541'DB:business_master_new
loadtime:0.34978294372559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garber' limit 1
loadtime:0.34986901283264 / seconds
Query Executed:select id FROM `ia` where city='Garber' && SIC_code='5541'DB:business_master_new
loadtime:0.35064482688904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.35072803497314 / seconds
Query Executed:select id FROM `ia` where city='Garden City' && SIC_code='5541'DB:business_master_new
loadtime:0.35134601593018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden Grove' limit 1
loadtime:0.35142397880554 / seconds
Query Executed:select id FROM `ia` where city='Garden Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.35214900970459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnavillo' limit 1
loadtime:0.35223197937012 / seconds
Query Executed:select id FROM `ia` where city='Garnavillo' && SIC_code='5541'DB:business_master_new
loadtime:0.35311985015869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:0.35319399833679 / seconds
Query Executed:select id FROM `ia` where city='Garner' && SIC_code='5541'DB:business_master_new
loadtime:0.3541898727417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.3542788028717 / seconds
Query Executed:select id FROM `ia` where city='Garrison' && SIC_code='5541'DB:business_master_new
loadtime:0.35518503189087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwin' limit 1
loadtime:0.35527181625366 / seconds
Query Executed:select id FROM `ia` where city='Garwin' && SIC_code='5541'DB:business_master_new
loadtime:0.35609102249146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geneva' limit 1
loadtime:0.35613894462585 / seconds
Query Executed:select id FROM `ia` where city='Geneva' && SIC_code='5541'DB:business_master_new
loadtime:0.35696887969971 / seconds
Query loaded from cache:select * from geodata_geocity where city='George' limit 1
loadtime:0.3570568561554 / seconds
Query Executed:select id FROM `ia` where city='George' && SIC_code='5541'DB:business_master_new
loadtime:0.35797381401062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:0.35807800292969 / seconds
Query Executed:select id FROM `ia` where city='Gibson' && SIC_code='5541'DB:business_master_new
loadtime:0.3585889339447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.35863494873047 / seconds
Query Executed:select id FROM `ia` where city='Gifford' && SIC_code='5541'DB:business_master_new
loadtime:0.35920596122742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.35928893089294 / seconds
Query Executed:select id FROM `ia` where city='Gilbert' && SIC_code='5541'DB:business_master_new
loadtime:0.36013102531433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.36020183563232 / seconds
Query Executed:select id FROM `ia` where city='Gilbertville' && SIC_code='5541'DB:business_master_new
loadtime:0.36100101470947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett Grove' limit 1
loadtime:0.36107802391052 / seconds
Query Executed:select id FROM `ia` where city='Gillett Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.36175298690796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.36185002326965 / seconds
Query Executed:select id FROM `ia` where city='Gilman' && SIC_code='5541'DB:business_master_new
loadtime:0.36272001266479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmore City' limit 1
loadtime:0.36281299591064 / seconds
Query Executed:select id FROM `ia` where city='Gilmore City' && SIC_code='5541'DB:business_master_new
loadtime:0.36355090141296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladbrook' limit 1
loadtime:0.36365580558777 / seconds
Query Executed:select id FROM `ia` where city='Gladbrook' && SIC_code='5541'DB:business_master_new
loadtime:0.36438083648682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.36444902420044 / seconds
Query Executed:select id FROM `ia` where city='Glenwood' && SIC_code='5541'DB:business_master_new
loadtime:0.36539196968079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:0.36550092697144 / seconds
Query Executed:select id FROM `ia` where city='Glidden' && SIC_code='5541'DB:business_master_new
loadtime:0.36645889282227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldfield' limit 1
loadtime:0.36657094955444 / seconds
Query Executed:select id FROM `ia` where city='Goldfield' && SIC_code='5541'DB:business_master_new
loadtime:0.36755800247192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodell' limit 1
loadtime:0.36771082878113 / seconds
Query Executed:select id FROM `ia` where city='Goodell' && SIC_code='5541'DB:business_master_new
loadtime:0.36844682693481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Lake' limit 1
loadtime:0.36854290962219 / seconds
Query Executed:select id FROM `ia` where city='Goose Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.36961388587952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowrie' limit 1
loadtime:0.36970782279968 / seconds
Query Executed:select id FROM `ia` where city='Gowrie' && SIC_code='5541'DB:business_master_new
loadtime:0.37065982818604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graettinger' limit 1
loadtime:0.3707869052887 / seconds
Query Executed:select id FROM `ia` where city='Graettinger' && SIC_code='5541'DB:business_master_new
loadtime:0.37159180641174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.37174487113953 / seconds
Query Executed:select id FROM `ia` where city='Grafton' && SIC_code='5541'DB:business_master_new
loadtime:0.37267994880676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:0.37277603149414 / seconds
Query Executed:select id FROM `ia` where city='Grand Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.37352180480957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Mound' limit 1
loadtime:0.37357187271118 / seconds
Query Executed:select id FROM `ia` where city='Grand Mound' && SIC_code='5541'DB:business_master_new
loadtime:0.37454080581665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand River' limit 1
loadtime:0.37463784217834 / seconds
Query Executed:select id FROM `ia` where city='Grand River' && SIC_code='5541'DB:business_master_new
loadtime:0.37529802322388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandview' limit 1
loadtime:0.37534689903259 / seconds
Query Executed:select id FROM `ia` where city='Grandview' && SIC_code='5541'DB:business_master_new
loadtime:0.37588500976562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granger' limit 1
loadtime:0.37596297264099 / seconds
Query Executed:select id FROM `ia` where city='Granger' && SIC_code='5541'DB:business_master_new
loadtime:0.37682294845581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:0.37687993049622 / seconds
Query Executed:select id FROM `ia` where city='Grant' && SIC_code='5541'DB:business_master_new
loadtime:0.37730288505554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.37737798690796 / seconds
Query Executed:select id FROM `ia` where city='Granville' && SIC_code='5541'DB:business_master_new
loadtime:0.37819981575012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gravity' limit 1
loadtime:0.37825202941895 / seconds
Query Executed:select id FROM `ia` where city='Gravity' && SIC_code='5541'DB:business_master_new
loadtime:0.37890982627869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray' limit 1
loadtime:0.3789689540863 / seconds
Query Executed:select id FROM `ia` where city='Gray' && SIC_code='5541'DB:business_master_new
loadtime:0.37947487831116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:0.37960696220398 / seconds
Query Executed:select id FROM `ia` where city='Greeley' && SIC_code='5541'DB:business_master_new
loadtime:0.38047790527344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:0.38061094284058 / seconds
Query Executed:select id FROM `ia` where city='Green Mountain' && SIC_code='5541'DB:business_master_new
loadtime:0.38118886947632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greene' limit 1
loadtime:0.38128089904785 / seconds
Query Executed:select id FROM `ia` where city='Greene' && SIC_code='5541'DB:business_master_new
loadtime:0.38195896148682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.38203597068787 / seconds
Query Executed:select id FROM `ia` where city='Greenfield' && SIC_code='5541'DB:business_master_new
loadtime:0.38299989700317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.3830988407135 / seconds
Query Executed:select id FROM `ia` where city='Greenville' && SIC_code='5541'DB:business_master_new
loadtime:0.38369798660278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimes' limit 1
loadtime:0.38383483886719 / seconds
Query Executed:select id FROM `ia` where city='Grimes' && SIC_code='5541'DB:business_master_new
loadtime:0.38490581512451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grinnell' limit 1
loadtime:0.38500595092773 / seconds
Query Executed:select id FROM `ia` where city='Grinnell' && SIC_code='5541'DB:business_master_new
loadtime:0.38603782653809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Griswold' limit 1
loadtime:0.38613891601562 / seconds
Query Executed:select id FROM `ia` where city='Griswold' && SIC_code='5541'DB:business_master_new
loadtime:0.38704180717468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy Center' limit 1
loadtime:0.3871009349823 / seconds
Query Executed:select id FROM `ia` where city='Grundy Center' && SIC_code='5541'DB:business_master_new
loadtime:0.38808298110962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gruver' limit 1
loadtime:0.38818383216858 / seconds
Query Executed:select id FROM `ia` where city='Gruver' && SIC_code='5541'DB:business_master_new
loadtime:0.38871002197266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guernsey' limit 1
loadtime:0.38875889778137 / seconds
Query Executed:select id FROM `ia` where city='Guernsey' && SIC_code='5541'DB:business_master_new
loadtime:0.38947081565857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guthrie Center' limit 1
loadtime:0.38955497741699 / seconds
Query Executed:select id FROM `ia` where city='Guthrie Center' && SIC_code='5541'DB:business_master_new
loadtime:0.39047384262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:0.39050889015198 / seconds
Query Executed:select id FROM `ia` where city='Guttenberg' && SIC_code='5541'DB:business_master_new
loadtime:0.39144802093506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halbur' limit 1
loadtime:0.39157700538635 / seconds
Query Executed:select id FROM `ia` where city='Halbur' && SIC_code='5541'DB:business_master_new
loadtime:0.39224481582642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:0.39230680465698 / seconds
Query Executed:select id FROM `ia` where city='Hamburg' && SIC_code='5541'DB:business_master_new
loadtime:0.39303493499756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.39311099052429 / seconds
Query Executed:select id FROM `ia` where city='Hamilton' && SIC_code='5541'DB:business_master_new
loadtime:0.39359903335571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlin' limit 1
loadtime:0.39367699623108 / seconds
Query Executed:select id FROM `ia` where city='Hamlin' && SIC_code='5541'DB:business_master_new
loadtime:0.39423680305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.39432692527771 / seconds
Query Executed:select id FROM `ia` where city='Hampton' && SIC_code='5541'DB:business_master_new
loadtime:0.39537692070007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.39550995826721 / seconds
Query Executed:select id FROM `ia` where city='Hancock' && SIC_code='5541'DB:business_master_new
loadtime:0.39630103111267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanlontown' limit 1
loadtime:0.39637589454651 / seconds
Query Executed:select id FROM `ia` where city='Hanlontown' && SIC_code='5541'DB:business_master_new
loadtime:0.39725303649902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hansell' limit 1
loadtime:0.39731287956238 / seconds
Query Executed:select id FROM `ia` where city='Hansell' && SIC_code='5541'DB:business_master_new
loadtime:0.39763903617859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harcourt' limit 1
loadtime:0.39769792556763 / seconds
Query Executed:select id FROM `ia` where city='Harcourt' && SIC_code='5541'DB:business_master_new
loadtime:0.39853882789612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:0.39863395690918 / seconds
Query Executed:select id FROM `ia` where city='Hardy' && SIC_code='5541'DB:business_master_new
loadtime:0.39930081367493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harlan' limit 1
loadtime:0.39932799339294 / seconds
Query Executed:select id FROM `ia` where city='Harlan' && SIC_code='5541'DB:business_master_new
loadtime:0.40048384666443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:0.40064287185669 / seconds
Query Executed:select id FROM `ia` where city='Harper' && SIC_code='5541'DB:business_master_new
loadtime:0.40136289596558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harpers Ferry' limit 1
loadtime:0.40142798423767 / seconds
Query Executed:select id FROM `ia` where city='Harpers Ferry' && SIC_code='5541'DB:business_master_new
loadtime:0.40228796005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:0.40239286422729 / seconds
Query Executed:select id FROM `ia` where city='Harris' && SIC_code='5541'DB:business_master_new
loadtime:0.40295481681824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.40301895141602 / seconds
Query Executed:select id FROM `ia` where city='Hartford' && SIC_code='5541'DB:business_master_new
loadtime:0.40359497070312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartley' limit 1
loadtime:0.40372180938721 / seconds
Query Executed:select id FROM `ia` where city='Hartley' && SIC_code='5541'DB:business_master_new
loadtime:0.40459799766541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwick' limit 1
loadtime:0.40468692779541 / seconds
Query Executed:select id FROM `ia` where city='Hartwick' && SIC_code='5541'DB:business_master_new
loadtime:0.40533399581909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:0.40541982650757 / seconds
Query Executed:select id FROM `ia` where city='Harvey' && SIC_code='5541'DB:business_master_new
loadtime:0.40612387657166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:0.40620398521423 / seconds
Query Executed:select id FROM `ia` where city='Hastings' && SIC_code='5541'DB:business_master_new
loadtime:0.4068169593811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:0.40688800811768 / seconds
Query Executed:select id FROM `ia` where city='Havelock' && SIC_code='5541'DB:business_master_new
loadtime:0.40776801109314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.40786981582642 / seconds
Query Executed:select id FROM `ia` where city='Haverhill' && SIC_code='5541'DB:business_master_new
loadtime:0.40849280357361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawarden' limit 1
loadtime:0.40861487388611 / seconds
Query Executed:select id FROM `ia` where city='Hawarden' && SIC_code='5541'DB:business_master_new
loadtime:0.40958881378174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkeye' limit 1
loadtime:0.40967488288879 / seconds
Query Executed:select id FROM `ia` where city='Hawkeye' && SIC_code='5541'DB:business_master_new
loadtime:0.41033887863159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:0.41040992736816 / seconds
Query Executed:select id FROM `ia` where city='Hayesville' && SIC_code='5541'DB:business_master_new
loadtime:0.41072988510132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazleton' limit 1
loadtime:0.41078495979309 / seconds
Query Executed:select id FROM `ia` where city='Hazleton' && SIC_code='5541'DB:business_master_new
loadtime:0.41126990318298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hedrick' limit 1
loadtime:0.41130995750427 / seconds
Query Executed:select id FROM `ia` where city='Hedrick' && SIC_code='5541'DB:business_master_new
loadtime:0.41201400756836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.41209483146667 / seconds
Query Executed:select id FROM `ia` where city='Henderson' && SIC_code='5541'DB:business_master_new
loadtime:0.41277098655701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.41285490989685 / seconds
Query Executed:select id FROM `ia` where city='Hiawatha' && SIC_code='5541'DB:business_master_new
loadtime:0.41370391845703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlandville' limit 1
loadtime:0.41381001472473 / seconds
Query Executed:select id FROM `ia` where city='Highlandville' && SIC_code='5541'DB:business_master_new
loadtime:0.41424703598022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hills' limit 1
loadtime:0.41429281234741 / seconds
Query Executed:select id FROM `ia` where city='Hills' && SIC_code='5541'DB:business_master_new
loadtime:0.4151439666748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.41519284248352 / seconds
Query Executed:select id FROM `ia` where city='Hillsboro' && SIC_code='5541'DB:business_master_new
loadtime:0.41587281227112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:0.41595983505249 / seconds
Query Executed:select id FROM `ia` where city='Hinton' && SIC_code='5541'DB:business_master_new
loadtime:0.41659784317017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:0.41664290428162 / seconds
Query Executed:select id FROM `ia` where city='Holland' && SIC_code='5541'DB:business_master_new
loadtime:0.41743493080139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holstein' limit 1
loadtime:0.41756701469421 / seconds
Query Executed:select id FROM `ia` where city='Holstein' && SIC_code='5541'DB:business_master_new
loadtime:0.41844892501831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holy Cross' limit 1
loadtime:0.41860103607178 / seconds
Query Executed:select id FROM `ia` where city='Holy Cross' && SIC_code='5541'DB:business_master_new
loadtime:0.41940188407898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homestead' limit 1
loadtime:0.41946291923523 / seconds
Query Executed:select id FROM `ia` where city='Homestead' && SIC_code='5541'DB:business_master_new
loadtime:0.42024183273315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:0.42028999328613 / seconds
Query Executed:select id FROM `ia` where city='Honey Creek' && SIC_code='5541'DB:business_master_new
loadtime:0.42122483253479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.42131400108337 / seconds
Query Executed:select id FROM `ia` where city='Hopkinton' && SIC_code='5541'DB:business_master_new
loadtime:0.4219868183136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hornick' limit 1
loadtime:0.42205595970154 / seconds
Query Executed:select id FROM `ia` where city='Hornick' && SIC_code='5541'DB:business_master_new
loadtime:0.42287492752075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hospers' limit 1
loadtime:0.42296195030212 / seconds
Query Executed:select id FROM `ia` where city='Hospers' && SIC_code='5541'DB:business_master_new
loadtime:0.42363882064819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.4237368106842 / seconds
Query Executed:select id FROM `ia` where city='Houghton' && SIC_code='5541'DB:business_master_new
loadtime:0.42459297180176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard' limit 1
loadtime:0.42469692230225 / seconds
Query Executed:select id FROM `ia` where city='Hubbard' && SIC_code='5541'DB:business_master_new
loadtime:0.42548680305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.4255838394165 / seconds
Query Executed:select id FROM `ia` where city='Hudson' && SIC_code='5541'DB:business_master_new
loadtime:0.42662000656128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:0.42671799659729 / seconds
Query Executed:select id FROM `ia` where city='Hull' && SIC_code='5541'DB:business_master_new
loadtime:0.42755794525146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.42771601676941 / seconds
Query Executed:select id FROM `ia` where city='Humboldt' && SIC_code='5541'DB:business_master_new
loadtime:0.42872095108032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humeston' limit 1
loadtime:0.42882800102234 / seconds
Query Executed:select id FROM `ia` where city='Humeston' && SIC_code='5541'DB:business_master_new
loadtime:0.4296658039093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huxley' limit 1
loadtime:0.42977380752563 / seconds
Query Executed:select id FROM `ia` where city='Huxley' && SIC_code='5541'DB:business_master_new
loadtime:0.43061685562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida Grove' limit 1
loadtime:0.43072581291199 / seconds
Query Executed:select id FROM `ia` where city='Ida Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.43176102638245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imogene' limit 1
loadtime:0.43181991577148 / seconds
Query Executed:select id FROM `ia` where city='Imogene' && SIC_code='5541'DB:business_master_new
loadtime:0.43246984481812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.43255686759949 / seconds
Query Executed:select id FROM `ia` where city='Independence' && SIC_code='5541'DB:business_master_new
loadtime:0.43366098403931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:0.43373203277588 / seconds
Query Executed:select id FROM `ia` where city='Indianola' && SIC_code='5541'DB:business_master_new
loadtime:0.4350368976593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inwood' limit 1
loadtime:0.43515491485596 / seconds
Query Executed:select id FROM `ia` where city='Inwood' && SIC_code='5541'DB:business_master_new
loadtime:0.4359278678894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:0.43600988388062 / seconds
Query Executed:select id FROM `ia` where city='Ionia' && SIC_code='5541'DB:business_master_new
loadtime:0.43688797950745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa City' limit 1
loadtime:0.43697285652161 / seconds
Query Executed:select id FROM `ia` where city='Iowa City' && SIC_code='5541'DB:business_master_new
loadtime:0.4434928894043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa Falls' limit 1
loadtime:0.4436559677124 / seconds
Query Executed:select id FROM `ia` where city='Iowa Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.44476580619812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:0.44482898712158 / seconds
Query Executed:select id FROM `ia` where city='Ira' && SIC_code='5541'DB:business_master_new
loadtime:0.44542384147644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ireton' limit 1
loadtime:0.4455578327179 / seconds
Query Executed:select id FROM `ia` where city='Ireton' && SIC_code='5541'DB:business_master_new
loadtime:0.44636797904968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irwin' limit 1
loadtime:0.44646692276001 / seconds
Query Executed:select id FROM `ia` where city='Irwin' && SIC_code='5541'DB:business_master_new
loadtime:0.44738698005676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Junction' limit 1
loadtime:0.44746088981628 / seconds
Query Executed:select id FROM `ia` where city='Jackson Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.44781303405762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.4478600025177 / seconds
Query Executed:select id FROM `ia` where city='Jamaica' && SIC_code='5541'DB:business_master_new
loadtime:0.44847083091736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:0.44859886169434 / seconds
Query Executed:select id FROM `ia` where city='Janesville' && SIC_code='5541'DB:business_master_new
loadtime:0.44948983192444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.44953894615173 / seconds
Query Executed:select id FROM `ia` where city='Jefferson' && SIC_code='5541'DB:business_master_new
loadtime:0.45063591003418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jesup' limit 1
loadtime:0.45072293281555 / seconds
Query Executed:select id FROM `ia` where city='Jesup' && SIC_code='5541'DB:business_master_new
loadtime:0.45159697532654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell' limit 1
loadtime:0.45165801048279 / seconds
Query Executed:select id FROM `ia` where city='Jewell' && SIC_code='5541'DB:business_master_new
loadtime:0.45259881019592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.45273280143738 / seconds
Query Executed:select id FROM `ia` where city='Johnston' && SIC_code='5541'DB:business_master_new
loadtime:0.4537889957428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joice' limit 1
loadtime:0.45385003089905 / seconds
Query Executed:select id FROM `ia` where city='Joice' && SIC_code='5541'DB:business_master_new
loadtime:0.45470380783081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jolley' limit 1
loadtime:0.45477986335754 / seconds
Query Executed:select id FROM `ia` where city='Jolley' && SIC_code='5541'DB:business_master_new
loadtime:0.455482006073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalona' limit 1
loadtime:0.45560789108276 / seconds
Query Executed:select id FROM `ia` where city='Kalona' && SIC_code='5541'DB:business_master_new
loadtime:0.45660996437073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamrar' limit 1
loadtime:0.45664501190186 / seconds
Query Executed:select id FROM `ia` where city='Kamrar' && SIC_code='5541'DB:business_master_new
loadtime:0.45745587348938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanawha' limit 1
loadtime:0.45755481719971 / seconds
Query Executed:select id FROM `ia` where city='Kanawha' && SIC_code='5541'DB:business_master_new
loadtime:0.45836400985718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellerton' limit 1
loadtime:0.45839285850525 / seconds
Query Executed:select id FROM `ia` where city='Kellerton' && SIC_code='5541'DB:business_master_new
loadtime:0.45925784111023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelley' limit 1
loadtime:0.45934081077576 / seconds
Query Executed:select id FROM `ia` where city='Kelley' && SIC_code='5541'DB:business_master_new
loadtime:0.46009993553162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellogg' limit 1
loadtime:0.46015000343323 / seconds
Query Executed:select id FROM `ia` where city='Kellogg' && SIC_code='5541'DB:business_master_new
loadtime:0.46092796325684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensett' limit 1
loadtime:0.46096301078796 / seconds
Query Executed:select id FROM `ia` where city='Kensett' && SIC_code='5541'DB:business_master_new
loadtime:0.46171689033508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.46179986000061 / seconds
Query Executed:select id FROM `ia` where city='Kent' && SIC_code='5541'DB:business_master_new
loadtime:0.46217799186707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokuk' limit 1
loadtime:0.46226096153259 / seconds
Query Executed:select id FROM `ia` where city='Keokuk' && SIC_code='5541'DB:business_master_new
loadtime:0.46355295181274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keosauqua' limit 1
loadtime:0.4635968208313 / seconds
Query Executed:select id FROM `ia` where city='Keosauqua' && SIC_code='5541'DB:business_master_new
loadtime:0.46449089050293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keota' limit 1
loadtime:0.46462488174438 / seconds
Query Executed:select id FROM `ia` where city='Keota' && SIC_code='5541'DB:business_master_new
loadtime:0.46552085876465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kesley' limit 1
loadtime:0.46556282043457 / seconds
Query Executed:select id FROM `ia` where city='Kesley' && SIC_code='5541'DB:business_master_new
loadtime:0.46614384651184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:0.46622681617737 / seconds
Query Executed:select id FROM `ia` where city='Keswick' && SIC_code='5541'DB:business_master_new
loadtime:0.46702003479004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.46710801124573 / seconds
Query Executed:select id FROM `ia` where city='Keystone' && SIC_code='5541'DB:business_master_new
loadtime:0.46780180931091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killduff' limit 1
loadtime:0.46788787841797 / seconds
Query Executed:select id FROM `ia` where city='Killduff' && SIC_code='5541'DB:business_master_new
loadtime:0.4685218334198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimballton' limit 1
loadtime:0.46858286857605 / seconds
Query Executed:select id FROM `ia` where city='Kimballton' && SIC_code='5541'DB:business_master_new
loadtime:0.46933197975159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:0.46944689750671 / seconds
Query Executed:select id FROM `ia` where city='Kingsley' && SIC_code='5541'DB:business_master_new
loadtime:0.47039389610291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:0.47048687934875 / seconds
Query Executed:select id FROM `ia` where city='Kinross' && SIC_code='5541'DB:business_master_new
loadtime:0.47088289260864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkman' limit 1
loadtime:0.47091889381409 / seconds
Query Executed:select id FROM `ia` where city='Kirkman' && SIC_code='5541'DB:business_master_new
loadtime:0.4716329574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkville' limit 1
loadtime:0.47171092033386 / seconds
Query Executed:select id FROM `ia` where city='Kirkville' && SIC_code='5541'DB:business_master_new
loadtime:0.47248983383179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiron' limit 1
loadtime:0.47252488136292 / seconds
Query Executed:select id FROM `ia` where city='Kiron' && SIC_code='5541'DB:business_master_new
loadtime:0.47339701652527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Klemme' limit 1
loadtime:0.47348093986511 / seconds
Query Executed:select id FROM `ia` where city='Klemme' && SIC_code='5541'DB:business_master_new
loadtime:0.47443580627441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knierim' limit 1
loadtime:0.47448396682739 / seconds
Query Executed:select id FROM `ia` where city='Knierim' && SIC_code='5541'DB:business_master_new
loadtime:0.4753258228302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knoxville' limit 1
loadtime:0.47541284561157 / seconds
Query Executed:select id FROM `ia` where city='Knoxville' && SIC_code='5541'DB:business_master_new
loadtime:0.47662496566772 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Motte' limit 1
loadtime:0.47670698165894 / seconds
Query Executed:select id FROM `ia` where city='La Motte' && SIC_code='5541'DB:business_master_new
loadtime:0.47786903381348 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Porte City' limit 1
loadtime:0.47794890403748 / seconds
Query Executed:select id FROM `ia` where city='La Porte City' && SIC_code='5541'DB:business_master_new
loadtime:0.47850394248962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacona' limit 1
loadtime:0.47855687141418 / seconds
Query Executed:select id FROM `ia` where city='Lacona' && SIC_code='5541'DB:business_master_new
loadtime:0.47904992103577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladora' limit 1
loadtime:0.47909498214722 / seconds
Query Executed:select id FROM `ia` where city='Ladora' && SIC_code='5541'DB:business_master_new
loadtime:0.47962403297424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.47967195510864 / seconds
Query Executed:select id FROM `ia` where city='Lake City' && SIC_code='5541'DB:business_master_new
loadtime:0.48023581504822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:0.48029184341431 / seconds
Query Executed:select id FROM `ia` where city='Lake Mills' && SIC_code='5541'DB:business_master_new
loadtime:0.48083400726318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Park' limit 1
loadtime:0.48088192939758 / seconds
Query Executed:select id FROM `ia` where city='Lake Park' && SIC_code='5541'DB:business_master_new
loadtime:0.48137998580933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.48142600059509 / seconds
Query Executed:select id FROM `ia` where city='Lake View' && SIC_code='5541'DB:business_master_new
loadtime:0.4819610118866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakota' limit 1
loadtime:0.48201584815979 / seconds
Query Executed:select id FROM `ia` where city='Lakota' && SIC_code='5541'DB:business_master_new
loadtime:0.4825918674469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamoni' limit 1
loadtime:0.48264098167419 / seconds
Query Executed:select id FROM `ia` where city='Lamoni' && SIC_code='5541'DB:business_master_new
loadtime:0.48319983482361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:0.48325085639954 / seconds
Query Executed:select id FROM `ia` where city='Lamont' && SIC_code='5541'DB:business_master_new
loadtime:0.48371386528015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:0.48375797271729 / seconds
Query Executed:select id FROM `ia` where city='Lanesboro' && SIC_code='5541'DB:business_master_new
loadtime:0.4841148853302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langworthy' limit 1
loadtime:0.48416686058044 / seconds
Query Executed:select id FROM `ia` where city='Langworthy' && SIC_code='5541'DB:business_master_new
loadtime:0.48448085784912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:0.48452591896057 / seconds
Query Executed:select id FROM `ia` where city='Lansing' && SIC_code='5541'DB:business_master_new
loadtime:0.48506093025208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larchwood' limit 1
loadtime:0.48510193824768 / seconds
Query Executed:select id FROM `ia` where city='Larchwood' && SIC_code='5541'DB:business_master_new
loadtime:0.48560190200806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larrabee' limit 1
loadtime:0.48565292358398 / seconds
Query Executed:select id FROM `ia` where city='Larrabee' && SIC_code='5541'DB:business_master_new
loadtime:0.48613691329956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latimer' limit 1
loadtime:0.48618698120117 / seconds
Query Executed:select id FROM `ia` where city='Latimer' && SIC_code='5541'DB:business_master_new
loadtime:0.48672080039978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:0.48679089546204 / seconds
Query Executed:select id FROM `ia` where city='Laurel' && SIC_code='5541'DB:business_master_new
loadtime:0.48736596107483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.48740983009338 / seconds
Query Executed:select id FROM `ia` where city='Laurens' && SIC_code='5541'DB:business_master_new
loadtime:0.48791599273682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawler' limit 1
loadtime:0.48794984817505 / seconds
Query Executed:select id FROM `ia` where city='Lawler' && SIC_code='5541'DB:business_master_new
loadtime:0.48842692375183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:0.48848485946655 / seconds
Query Executed:select id FROM `ia` where city='Lawton' && SIC_code='5541'DB:business_master_new
loadtime:0.48896789550781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Claire' limit 1
loadtime:0.48900580406189 / seconds
Query Executed:select id FROM `ia` where city='Le Claire' && SIC_code='5541'DB:business_master_new
loadtime:0.48955702781677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Grand' limit 1
loadtime:0.48961496353149 / seconds
Query Executed:select id FROM `ia` where city='Le Grand' && SIC_code='5541'DB:business_master_new
loadtime:0.49017095565796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Mars' limit 1
loadtime:0.49021196365356 / seconds
Query Executed:select id FROM `ia` where city='Le Mars' && SIC_code='5541'DB:business_master_new
loadtime:0.49091482162476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.49097490310669 / seconds
Query Executed:select id FROM `ia` where city='Ledyard' && SIC_code='5541'DB:business_master_new
loadtime:0.49149584770203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehigh' limit 1
loadtime:0.49153590202332 / seconds
Query Executed:select id FROM `ia` where city='Lehigh' && SIC_code='5541'DB:business_master_new
loadtime:0.49202680587769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leighton' limit 1
loadtime:0.49207282066345 / seconds
Query Executed:select id FROM `ia` where city='Leighton' && SIC_code='5541'DB:business_master_new
loadtime:0.4926118850708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:0.4926598072052 / seconds
Query Executed:select id FROM `ia` where city='Leland' && SIC_code='5541'DB:business_master_new
loadtime:0.49315786361694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:0.49320888519287 / seconds
Query Executed:select id FROM `ia` where city='Lenox' && SIC_code='5541'DB:business_master_new
loadtime:0.4937310218811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:0.49379897117615 / seconds
Query Executed:select id FROM `ia` where city='Leon' && SIC_code='5541'DB:business_master_new
loadtime:0.49434590339661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lester' limit 1
loadtime:0.49439787864685 / seconds
Query Executed:select id FROM `ia` where city='Lester' && SIC_code='5541'DB:business_master_new
loadtime:0.49487280845642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letts' limit 1
loadtime:0.49491882324219 / seconds
Query Executed:select id FROM `ia` where city='Letts' && SIC_code='5541'DB:business_master_new
loadtime:0.49540591239929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:0.49545383453369 / seconds
Query Executed:select id FROM `ia` where city='Lewis' && SIC_code='5541'DB:business_master_new
loadtime:0.49592280387878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Center' limit 1
loadtime:0.4959499835968 / seconds
Query Executed:select id FROM `ia` where city='Liberty Center' && SIC_code='5541'DB:business_master_new
loadtime:0.49627494812012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Libertyville' limit 1
loadtime:0.49632596969604 / seconds
Query Executed:select id FROM `ia` where city='Libertyville' && SIC_code='5541'DB:business_master_new
loadtime:0.49682998657227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lidderdale' limit 1
loadtime:0.49686980247498 / seconds
Query Executed:select id FROM `ia` where city='Lidderdale' && SIC_code='5541'DB:business_master_new
loadtime:0.49724698066711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Springs' limit 1
loadtime:0.49728083610535 / seconds
Query Executed:select id FROM `ia` where city='Lime Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.49776387214661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.49780893325806 / seconds
Query Executed:select id FROM `ia` where city='Lincoln' && SIC_code='5541'DB:business_master_new
loadtime:0.49824094772339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:0.498291015625 / seconds
Query Executed:select id FROM `ia` where city='Linden' && SIC_code='5541'DB:business_master_new
loadtime:0.49874401092529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lineville' limit 1
loadtime:0.498783826828 / seconds
Query Executed:select id FROM `ia` where city='Lineville' && SIC_code='5541'DB:business_master_new
loadtime:0.49923992156982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linn Grove' limit 1
loadtime:0.49927091598511 / seconds
Query Executed:select id FROM `ia` where city='Linn Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.499755859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.49979090690613 / seconds
Query Executed:select id FROM `ia` where city='Lisbon' && SIC_code='5541'DB:business_master_new
loadtime:0.50028681755066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liscomb' limit 1
loadtime:0.50033187866211 / seconds
Query Executed:select id FROM `ia` where city='Liscomb' && SIC_code='5541'DB:business_master_new
loadtime:0.50076484680176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Cedar' limit 1
loadtime:0.50080680847168 / seconds
Query Executed:select id FROM `ia` where city='Little Cedar' && SIC_code='5541'DB:business_master_new
loadtime:0.50118088722229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.50123000144958 / seconds
Query Executed:select id FROM `ia` where city='Little Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.50174403190613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Sioux' limit 1
loadtime:0.50178289413452 / seconds
Query Executed:select id FROM `ia` where city='Little Sioux' && SIC_code='5541'DB:business_master_new
loadtime:0.50216603279114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:0.50221586227417 / seconds
Query Executed:select id FROM `ia` where city='Livermore' && SIC_code='5541'DB:business_master_new
loadtime:0.50267887115479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockridge' limit 1
loadtime:0.50270700454712 / seconds
Query Executed:select id FROM `ia` where city='Lockridge' && SIC_code='5541'DB:business_master_new
loadtime:0.50326490402222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.50331592559814 / seconds
Query Executed:select id FROM `ia` where city='Logan' && SIC_code='5541'DB:business_master_new
loadtime:0.50384187698364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lohrville' limit 1
loadtime:0.50388503074646 / seconds
Query Executed:select id FROM `ia` where city='Lohrville' && SIC_code='5541'DB:business_master_new
loadtime:0.50438380241394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:0.5044379234314 / seconds
Query Executed:select id FROM `ia` where city='Lone Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.50491881370544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:0.50494599342346 / seconds
Query Executed:select id FROM `ia` where city='Lone Tree' && SIC_code='5541'DB:business_master_new
loadtime:0.50542283058167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Grove' limit 1
loadtime:0.5054759979248 / seconds
Query Executed:select id FROM `ia` where city='Long Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.50596499443054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorimor' limit 1
loadtime:0.50600790977478 / seconds
Query Executed:select id FROM `ia` where city='Lorimor' && SIC_code='5541'DB:business_master_new
loadtime:0.50654888153076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Nation' limit 1
loadtime:0.5065929889679 / seconds
Query Executed:select id FROM `ia` where city='Lost Nation' && SIC_code='5541'DB:business_master_new
loadtime:0.50710201263428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovilia' limit 1
loadtime:0.50714302062988 / seconds
Query Executed:select id FROM `ia` where city='Lovilia' && SIC_code='5541'DB:business_master_new
loadtime:0.50767493247986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:0.50772285461426 / seconds
Query Executed:select id FROM `ia` where city='Low Moor' && SIC_code='5541'DB:business_master_new
loadtime:0.5082368850708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowden' limit 1
loadtime:0.50828790664673 / seconds
Query Executed:select id FROM `ia` where city='Lowden' && SIC_code='5541'DB:business_master_new
loadtime:0.50876688957214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lu Verne' limit 1
loadtime:0.50879883766174 / seconds
Query Executed:select id FROM `ia` where city='Lu Verne' && SIC_code='5541'DB:business_master_new
loadtime:0.509281873703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luana' limit 1
loadtime:0.50934100151062 / seconds
Query Executed:select id FROM `ia` where city='Luana' && SIC_code='5541'DB:business_master_new
loadtime:0.50980591773987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucas' limit 1
loadtime:0.50983381271362 / seconds
Query Executed:select id FROM `ia` where city='Lucas' && SIC_code='5541'DB:business_master_new
loadtime:0.51031088829041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:0.51036190986633 / seconds
Query Executed:select id FROM `ia` where city='Luther' && SIC_code='5541'DB:business_master_new
loadtime:0.51070094108582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:0.51076197624207 / seconds
Query Executed:select id FROM `ia` where city='Luxemburg' && SIC_code='5541'DB:business_master_new
loadtime:0.51115703582764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:0.51119995117188 / seconds
Query Executed:select id FROM `ia` where city='Luzerne' && SIC_code='5541'DB:business_master_new
loadtime:0.5116069316864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnville' limit 1
loadtime:0.51164484024048 / seconds
Query Executed:select id FROM `ia` where city='Lynnville' && SIC_code='5541'DB:business_master_new
loadtime:0.51214599609375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lytton' limit 1
loadtime:0.51219582557678 / seconds
Query Executed:select id FROM `ia` where city='Lytton' && SIC_code='5541'DB:business_master_new
loadtime:0.51266288757324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macedonia' limit 1
loadtime:0.51269698143005 / seconds
Query Executed:select id FROM `ia` where city='Macedonia' && SIC_code='5541'DB:business_master_new
loadtime:0.51321482658386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macksburg' limit 1
loadtime:0.51325488090515 / seconds
Query Executed:select id FROM `ia` where city='Macksburg' && SIC_code='5541'DB:business_master_new
loadtime:0.51366186141968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madrid' limit 1
loadtime:0.51370191574097 / seconds
Query Executed:select id FROM `ia` where city='Madrid' && SIC_code='5541'DB:business_master_new
loadtime:0.51423192024231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:0.51428890228271 / seconds
Query Executed:select id FROM `ia` where city='Magnolia' && SIC_code='5541'DB:business_master_new
loadtime:0.51463294029236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malcom' limit 1
loadtime:0.5146689414978 / seconds
Query Executed:select id FROM `ia` where city='Malcom' && SIC_code='5541'DB:business_master_new
loadtime:0.51520681381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mallard' limit 1
loadtime:0.51524901390076 / seconds
Query Executed:select id FROM `ia` where city='Mallard' && SIC_code='5541'DB:business_master_new
loadtime:0.51571702957153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maloy' limit 1
loadtime:0.51578187942505 / seconds
Query Executed:select id FROM `ia` where city='Maloy' && SIC_code='5541'DB:business_master_new
loadtime:0.51603484153748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malvern' limit 1
loadtime:0.51606488227844 / seconds
Query Executed:select id FROM `ia` where city='Malvern' && SIC_code='5541'DB:business_master_new
loadtime:0.51654887199402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.51659488677979 / seconds
Query Executed:select id FROM `ia` where city='Manchester' && SIC_code='5541'DB:business_master_new
loadtime:0.51727890968323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manilla' limit 1
loadtime:0.51733684539795 / seconds
Query Executed:select id FROM `ia` where city='Manilla' && SIC_code='5541'DB:business_master_new
loadtime:0.51781988143921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manly' limit 1
loadtime:0.51785182952881 / seconds
Query Executed:select id FROM `ia` where city='Manly' && SIC_code='5541'DB:business_master_new
loadtime:0.5183629989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.51840996742249 / seconds
Query Executed:select id FROM `ia` where city='Manning' && SIC_code='5541'DB:business_master_new
loadtime:0.51893401145935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:0.51898503303528 / seconds
Query Executed:select id FROM `ia` where city='Manson' && SIC_code='5541'DB:business_master_new
loadtime:0.51950597763062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.51955580711365 / seconds
Query Executed:select id FROM `ia` where city='Mapleton' && SIC_code='5541'DB:business_master_new
loadtime:0.520103931427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maquoketa' limit 1
loadtime:0.5201518535614 / seconds
Query Executed:select id FROM `ia` where city='Maquoketa' && SIC_code='5541'DB:business_master_new
loadtime:0.5207998752594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:0.52085900306702 / seconds
Query Executed:select id FROM `ia` where city='Marathon' && SIC_code='5541'DB:business_master_new
loadtime:0.52144002914429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Rock' limit 1
loadtime:0.52147603034973 / seconds
Query Executed:select id FROM `ia` where city='Marble Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.52192997932434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcus' limit 1
loadtime:0.52197194099426 / seconds
Query Executed:select id FROM `ia` where city='Marcus' && SIC_code='5541'DB:business_master_new
loadtime:0.52248001098633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:0.52252984046936 / seconds
Query Executed:select id FROM `ia` where city='Marengo' && SIC_code='5541'DB:business_master_new
loadtime:0.52313780784607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.52319288253784 / seconds
Query Executed:select id FROM `ia` where city='Marion' && SIC_code='5541'DB:business_master_new
loadtime:0.52403402328491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:0.52409291267395 / seconds
Query Executed:select id FROM `ia` where city='Marne' && SIC_code='5541'DB:business_master_new
loadtime:0.52458190917969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:0.52462983131409 / seconds
Query Executed:select id FROM `ia` where city='Marquette' && SIC_code='5541'DB:business_master_new
loadtime:0.52514982223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshalltown' limit 1
loadtime:0.52519083023071 / seconds
Query Executed:select id FROM `ia` where city='Marshalltown' && SIC_code='5541'DB:business_master_new
loadtime:0.52612686157227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martelle' limit 1
loadtime:0.52618598937988 / seconds
Query Executed:select id FROM `ia` where city='Martelle' && SIC_code='5541'DB:business_master_new
loadtime:0.52672696113586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martensdale' limit 1
loadtime:0.52678084373474 / seconds
Query Executed:select id FROM `ia` where city='Martensdale' && SIC_code='5541'DB:business_master_new
loadtime:0.52723503112793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsburg' limit 1
loadtime:0.52728199958801 / seconds
Query Executed:select id FROM `ia` where city='Martinsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.52759385108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason City' limit 1
loadtime:0.52763080596924 / seconds
Query Executed:select id FROM `ia` where city='Mason City' && SIC_code='5541'DB:business_master_new
loadtime:0.52863097190857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:0.52868795394897 / seconds
Query Executed:select id FROM `ia` where city='Masonville' && SIC_code='5541'DB:business_master_new
loadtime:0.52927994728088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massena' limit 1
loadtime:0.52933192253113 / seconds
Query Executed:select id FROM `ia` where city='Massena' && SIC_code='5541'DB:business_master_new
loadtime:0.52979683876038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matlock' limit 1
loadtime:0.5298388004303 / seconds
Query Executed:select id FROM `ia` where city='Matlock' && SIC_code='5541'DB:business_master_new
loadtime:0.53019094467163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurice' limit 1
loadtime:0.53023600578308 / seconds
Query Executed:select id FROM `ia` where city='Maurice' && SIC_code='5541'DB:business_master_new
loadtime:0.53070497512817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.53075098991394 / seconds
Query Executed:select id FROM `ia` where city='Maxwell' && SIC_code='5541'DB:business_master_new
loadtime:0.53126096725464 / seconds
Query loaded from cache:select * from geodata_geocity where city='May City' limit 1
loadtime:0.53129982948303 / seconds
Query Executed:select id FROM `ia` where city='May City' && SIC_code='5541'DB:business_master_new
loadtime:0.53155088424683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:0.53158903121948 / seconds
Query Executed:select id FROM `ia` where city='Maynard' && SIC_code='5541'DB:business_master_new
loadtime:0.53207182884216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Callsburg' limit 1
loadtime:0.53211998939514 / seconds
Query Executed:select id FROM `ia` where city='Mc Callsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.53264498710632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Causland' limit 1
loadtime:0.53268980979919 / seconds
Query Executed:select id FROM `ia` where city='Mc Causland' && SIC_code='5541'DB:business_master_new
loadtime:0.53312993049622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clelland' limit 1
loadtime:0.53316497802734 / seconds
Query Executed:select id FROM `ia` where city='Mc Clelland' && SIC_code='5541'DB:business_master_new
loadtime:0.53364491462708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gregor' limit 1
loadtime:0.53369998931885 / seconds
Query Executed:select id FROM `ia` where city='Mc Gregor' && SIC_code='5541'DB:business_master_new
loadtime:0.53422403335571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intire' limit 1
loadtime:0.53427290916443 / seconds
Query Executed:select id FROM `ia` where city='Mc Intire' && SIC_code='5541'DB:business_master_new
loadtime:0.53476786613464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:0.53479385375977 / seconds
Query Executed:select id FROM `ia` where city='Mechanicsville' && SIC_code='5541'DB:business_master_new
loadtime:0.53529191017151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mediapolis' limit 1
loadtime:0.53533983230591 / seconds
Query Executed:select id FROM `ia` where city='Mediapolis' && SIC_code='5541'DB:business_master_new
loadtime:0.53588080406189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melbourne' limit 1
loadtime:0.53591680526733 / seconds
Query Executed:select id FROM `ia` where city='Melbourne' && SIC_code='5541'DB:business_master_new
loadtime:0.53648900985718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melcher' limit 1
loadtime:0.53653788566589 / seconds
Query Executed:select id FROM `ia` where city='Melcher' && SIC_code='5541'DB:business_master_new
loadtime:0.53688883781433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.53693389892578 / seconds
Query Executed:select id FROM `ia` where city='Melrose' && SIC_code='5541'DB:business_master_new
loadtime:0.53738284111023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:0.537428855896 / seconds
Query Executed:select id FROM `ia` where city='Melvin' && SIC_code='5541'DB:business_master_new
loadtime:0.53794288635254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menlo' limit 1
loadtime:0.5379810333252 / seconds
Query Executed:select id FROM `ia` where city='Menlo' && SIC_code='5541'DB:business_master_new
loadtime:0.53846001625061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.53850197792053 / seconds
Query Executed:select id FROM `ia` where city='Meriden' && SIC_code='5541'DB:business_master_new
loadtime:0.53892683982849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:0.53896689414978 / seconds
Query Executed:select id FROM `ia` where city='Merrill' && SIC_code='5541'DB:business_master_new
loadtime:0.53948903083801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meservey' limit 1
loadtime:0.53954100608826 / seconds
Query Executed:select id FROM `ia` where city='Meservey' && SIC_code='5541'DB:business_master_new
loadtime:0.54004502296448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Amana' limit 1
loadtime:0.54008889198303 / seconds
Query Executed:select id FROM `ia` where city='Middle Amana' && SIC_code='5541'DB:business_master_new
loadtime:0.54057693481445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.54062485694885 / seconds
Query Executed:select id FROM `ia` where city='Middletown' && SIC_code='5541'DB:business_master_new
loadtime:0.54108691215515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miles' limit 1
loadtime:0.54113698005676 / seconds
Query Executed:select id FROM `ia` where city='Miles' && SIC_code='5541'DB:business_master_new
loadtime:0.54163599014282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.54169583320618 / seconds
Query Executed:select id FROM `ia` where city='Milford' && SIC_code='5541'DB:business_master_new
loadtime:0.54230380058289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:0.54235196113586 / seconds
Query Executed:select id FROM `ia` where city='Millersburg' && SIC_code='5541'DB:business_master_new
loadtime:0.54277801513672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millerton' limit 1
loadtime:0.54281687736511 / seconds
Query Executed:select id FROM `ia` where city='Millerton' && SIC_code='5541'DB:business_master_new
loadtime:0.54314780235291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milo' limit 1
loadtime:0.54319596290588 / seconds
Query Executed:select id FROM `ia` where city='Milo' && SIC_code='5541'DB:business_master_new
loadtime:0.54367995262146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.5437228679657 / seconds
Query Executed:select id FROM `ia` where city='Milton' && SIC_code='5541'DB:business_master_new
loadtime:0.54427981376648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minburn' limit 1
loadtime:0.54432201385498 / seconds
Query Executed:select id FROM `ia` where city='Minburn' && SIC_code='5541'DB:business_master_new
loadtime:0.54481101036072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden' limit 1
loadtime:0.54485201835632 / seconds
Query Executed:select id FROM `ia` where city='Minden' && SIC_code='5541'DB:business_master_new
loadtime:0.54532480239868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineola' limit 1
loadtime:0.54537081718445 / seconds
Query Executed:select id FROM `ia` where city='Mineola' && SIC_code='5541'DB:business_master_new
loadtime:0.54572486877441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mingo' limit 1
loadtime:0.54580402374268 / seconds
Query Executed:select id FROM `ia` where city='Mingo' && SIC_code='5541'DB:business_master_new
loadtime:0.5462818145752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Missouri Valley' limit 1
loadtime:0.54631781578064 / seconds
Query Executed:select id FROM `ia` where city='Missouri Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.5469069480896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.54695391654968 / seconds
Query Executed:select id FROM `ia` where city='Mitchell' && SIC_code='5541'DB:business_master_new
loadtime:0.54721188545227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchellville' limit 1
loadtime:0.54724597930908 / seconds
Query Executed:select id FROM `ia` where city='Mitchellville' && SIC_code='5541'DB:business_master_new
loadtime:0.5477089881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modale' limit 1
loadtime:0.54775285720825 / seconds
Query Executed:select id FROM `ia` where city='Modale' && SIC_code='5541'DB:business_master_new
loadtime:0.54821991920471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondamin' limit 1
loadtime:0.54825496673584 / seconds
Query Executed:select id FROM `ia` where city='Mondamin' && SIC_code='5541'DB:business_master_new
loadtime:0.54872894287109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth' limit 1
loadtime:0.54878187179565 / seconds
Query Executed:select id FROM `ia` where city='Monmouth' && SIC_code='5541'DB:business_master_new
loadtime:0.54929399490356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:0.5493369102478 / seconds
Query Executed:select id FROM `ia` where city='Monona' && SIC_code='5541'DB:business_master_new
loadtime:0.54984784126282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.5498948097229 / seconds
Query Executed:select id FROM `ia` where city='Monroe' && SIC_code='5541'DB:business_master_new
loadtime:0.55042481422424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.55047583580017 / seconds
Query Executed:select id FROM `ia` where city='Montezuma' && SIC_code='5541'DB:business_master_new
loadtime:0.55104303359985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.55110502243042 / seconds
Query Executed:select id FROM `ia` where city='Monticello' && SIC_code='5541'DB:business_master_new
loadtime:0.55175185203552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montour' limit 1
loadtime:0.55181193351746 / seconds
Query Executed:select id FROM `ia` where city='Montour' && SIC_code='5541'DB:business_master_new
loadtime:0.55224084854126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.55228686332703 / seconds
Query Executed:select id FROM `ia` where city='Montpelier' && SIC_code='5541'DB:business_master_new
loadtime:0.5526008605957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.55262780189514 / seconds
Query Executed:select id FROM `ia` where city='Montrose' && SIC_code='5541'DB:business_master_new
loadtime:0.55312895774841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:0.55317902565002 / seconds
Query Executed:select id FROM `ia` where city='Moorhead' && SIC_code='5541'DB:business_master_new
loadtime:0.55366897583008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorland' limit 1
loadtime:0.55370092391968 / seconds
Query Executed:select id FROM `ia` where city='Moorland' && SIC_code='5541'DB:business_master_new
loadtime:0.5541718006134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravia' limit 1
loadtime:0.5542209148407 / seconds
Query Executed:select id FROM `ia` where city='Moravia' && SIC_code='5541'DB:business_master_new
loadtime:0.55468988418579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:0.55472493171692 / seconds
Query Executed:select id FROM `ia` where city='Morley' && SIC_code='5541'DB:business_master_new
loadtime:0.55509495735168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morning Sun' limit 1
loadtime:0.55513501167297 / seconds
Query Executed:select id FROM `ia` where city='Morning Sun' && SIC_code='5541'DB:business_master_new
loadtime:0.55565881729126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:0.55571699142456 / seconds
Query Executed:select id FROM `ia` where city='Morrison' && SIC_code='5541'DB:business_master_new
loadtime:0.55605483055115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.55610489845276 / seconds
Query Executed:select id FROM `ia` where city='Moscow' && SIC_code='5541'DB:business_master_new
loadtime:0.55655193328857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moulton' limit 1
loadtime:0.55658793449402 / seconds
Query Executed:select id FROM `ia` where city='Moulton' && SIC_code='5541'DB:business_master_new
loadtime:0.55709791183472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Auburn' limit 1
loadtime:0.55715394020081 / seconds
Query Executed:select id FROM `ia` where city='Mount Auburn' && SIC_code='5541'DB:business_master_new
loadtime:0.55760097503662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ayr' limit 1
loadtime:0.55764698982239 / seconds
Query Executed:select id FROM `ia` where city='Mount Ayr' && SIC_code='5541'DB:business_master_new
loadtime:0.55823588371277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.55829691886902 / seconds
Query Executed:select id FROM `ia` where city='Mount Pleasant' && SIC_code='5541'DB:business_master_new
loadtime:0.55905890464783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:0.55912899971008 / seconds
Query Executed:select id FROM `ia` where city='Mount Sterling' && SIC_code='5541'DB:business_master_new
loadtime:0.55952191352844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Union' limit 1
loadtime:0.55956792831421 / seconds
Query Executed:select id FROM `ia` where city='Mount Union' && SIC_code='5541'DB:business_master_new
loadtime:0.56006503105164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.56011080741882 / seconds
Query Executed:select id FROM `ia` where city='Mount Vernon' && SIC_code='5541'DB:business_master_new
loadtime:0.56068301200867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moville' limit 1
loadtime:0.56073093414307 / seconds
Query Executed:select id FROM `ia` where city='Moville' && SIC_code='5541'DB:business_master_new
loadtime:0.56125593185425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Auburn' limit 1
loadtime:0.56131100654602 / seconds
Query Executed:select id FROM `ia` where city='Mt Auburn' && SIC_code='5541'DB:business_master_new
loadtime:0.56157803535461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ayr' limit 1
loadtime:0.56161284446716 / seconds
Query Executed:select id FROM `ia` where city='Mt Ayr' && SIC_code='5541'DB:business_master_new
loadtime:0.56191182136536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.5619490146637 / seconds
Query Executed:select id FROM `ia` where city='Mt Pleasant' && SIC_code='5541'DB:business_master_new
loadtime:0.56240797042847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:0.56245589256287 / seconds
Query Executed:select id FROM `ia` where city='Mt Sterling' && SIC_code='5541'DB:business_master_new
loadtime:0.56275200843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Union' limit 1
loadtime:0.56278395652771 / seconds
Query Executed:select id FROM `ia` where city='Mt Union' && SIC_code='5541'DB:business_master_new
loadtime:0.56316781044006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.56320786476135 / seconds
Query Executed:select id FROM `ia` where city='Mt Vernon' && SIC_code='5541'DB:business_master_new
loadtime:0.56353497505188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:0.56357383728027 / seconds
Query Executed:select id FROM `ia` where city='Murray' && SIC_code='5541'DB:business_master_new
loadtime:0.56405997276306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscatine' limit 1
loadtime:0.56410980224609 / seconds
Query Executed:select id FROM `ia` where city='Muscatine' && SIC_code='5541'DB:business_master_new
loadtime:0.56499695777893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.56504583358765 / seconds
Query Executed:select id FROM `ia` where city='Mystic' && SIC_code='5541'DB:business_master_new
loadtime:0.56555485725403 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Buena Vista' limit 1
loadtime:0.56560492515564 / seconds
Query Executed:select id FROM `ia` where city='N Buena Vista' && SIC_code='5541'DB:business_master_new
loadtime:0.5659008026123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:0.56593990325928 / seconds
Query Executed:select id FROM `ia` where city='Nashua' && SIC_code='5541'DB:business_master_new
loadtime:0.56648588180542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemaha' limit 1
loadtime:0.56654191017151 / seconds
Query Executed:select id FROM `ia` where city='Nemaha' && SIC_code='5541'DB:business_master_new
loadtime:0.56705188751221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:0.56711101531982 / seconds
Query Executed:select id FROM `ia` where city='Neola' && SIC_code='5541'DB:business_master_new
loadtime:0.56763601303101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nevada' limit 1
loadtime:0.56767892837524 / seconds
Query Executed:select id FROM `ia` where city='Nevada' && SIC_code='5541'DB:business_master_new
loadtime:0.56828498840332 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albin' limit 1
loadtime:0.56834101676941 / seconds
Query Executed:select id FROM `ia` where city='New Albin' && SIC_code='5541'DB:business_master_new
loadtime:0.56884384155273 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:0.56888890266418 / seconds
Query Executed:select id FROM `ia` where city='New Hampton' && SIC_code='5541'DB:business_master_new
loadtime:0.56950187683105 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.56955480575562 / seconds
Query Executed:select id FROM `ia` where city='New Hartford' && SIC_code='5541'DB:business_master_new
loadtime:0.57007002830505 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Liberty' limit 1
loadtime:0.57009792327881 / seconds
Query Executed:select id FROM `ia` where city='New Liberty' && SIC_code='5541'DB:business_master_new
loadtime:0.57060194015503 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.57065391540527 / seconds
Query Executed:select id FROM `ia` where city='New London' && SIC_code='5541'DB:business_master_new
loadtime:0.57117986679077 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:0.57121586799622 / seconds
Query Executed:select id FROM `ia` where city='New Market' && SIC_code='5541'DB:business_master_new
loadtime:0.57171893119812 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:0.571781873703 / seconds
Query Executed:select id FROM `ia` where city='New Providence' && SIC_code='5541'DB:business_master_new
loadtime:0.57236289978027 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Sharon' limit 1
loadtime:0.57240295410156 / seconds
Query Executed:select id FROM `ia` where city='New Sharon' && SIC_code='5541'DB:business_master_new
loadtime:0.57291793823242 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vienna' limit 1
loadtime:0.57295799255371 / seconds
Query Executed:select id FROM `ia` where city='New Vienna' && SIC_code='5541'DB:business_master_new
loadtime:0.57345199584961 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Virginia' limit 1
loadtime:0.57349991798401 / seconds
Query Executed:select id FROM `ia` where city='New Virginia' && SIC_code='5541'DB:business_master_new
loadtime:0.57398295402527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.57402682304382 / seconds
Query Executed:select id FROM `ia` where city='Newell' && SIC_code='5541'DB:business_master_new
loadtime:0.57453894615173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhall' limit 1
loadtime:0.57458400726318 / seconds
Query Executed:select id FROM `ia` where city='Newhall' && SIC_code='5541'DB:business_master_new
loadtime:0.57508492469788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.57513284683228 / seconds
Query Executed:select id FROM `ia` where city='Newton' && SIC_code='5541'DB:business_master_new
loadtime:0.57593202590942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:0.57599186897278 / seconds
Query Executed:select id FROM `ia` where city='Nichols' && SIC_code='5541'DB:business_master_new
loadtime:0.57657599449158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nodaway' limit 1
loadtime:0.57661199569702 / seconds
Query Executed:select id FROM `ia` where city='Nodaway' && SIC_code='5541'DB:business_master_new
loadtime:0.57707786560059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora Springs' limit 1
loadtime:0.5771210193634 / seconds
Query Executed:select id FROM `ia` where city='Nora Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.57764482498169 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Buena Vista' limit 1
loadtime:0.57768487930298 / seconds
Query Executed:select id FROM `ia` where city='North Buena Vista' && SIC_code='5541'DB:business_master_new
loadtime:0.57800197601318 / seconds
Query loaded from cache:select * from geodata_geocity where city='North English' limit 1
loadtime:0.57805585861206 / seconds
Query Executed:select id FROM `ia` where city='North English' && SIC_code='5541'DB:business_master_new
loadtime:0.57856702804565 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Liberty' limit 1
loadtime:0.57860684394836 / seconds
Query Executed:select id FROM `ia` where city='North Liberty' && SIC_code='5541'DB:business_master_new
loadtime:0.57921099662781 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Washington' limit 1
loadtime:0.57925796508789 / seconds
Query Executed:select id FROM `ia` where city='North Washington' && SIC_code='5541'DB:business_master_new
loadtime:0.57952880859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northboro' limit 1
loadtime:0.57955503463745 / seconds
Query Executed:select id FROM `ia` where city='Northboro' && SIC_code='5541'DB:business_master_new
loadtime:0.57994198799133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:0.57998180389404 / seconds
Query Executed:select id FROM `ia` where city='Northwood' && SIC_code='5541'DB:business_master_new
loadtime:0.58053588867188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.58057999610901 / seconds
Query Executed:select id FROM `ia` where city='Norwalk' && SIC_code='5541'DB:business_master_new
loadtime:0.58115482330322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:0.5811939239502 / seconds
Query Executed:select id FROM `ia` where city='Norway' && SIC_code='5541'DB:business_master_new
loadtime:0.58167386054993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Numa' limit 1
loadtime:0.58172702789307 / seconds
Query Executed:select id FROM `ia` where city='Numa' && SIC_code='5541'DB:business_master_new
loadtime:0.58200883865356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.58205080032349 / seconds
Query Executed:select id FROM `ia` where city='Oakdale' && SIC_code='5541'DB:business_master_new
loadtime:0.58239102363586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:0.58242583274841 / seconds
Query Executed:select id FROM `ia` where city='Oakland' && SIC_code='5541'DB:business_master_new
loadtime:0.58293390274048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.58298301696777 / seconds
Query Executed:select id FROM `ia` where city='Oakville' && SIC_code='5541'DB:business_master_new
loadtime:0.58353996276855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocheyedan' limit 1
loadtime:0.583575963974 / seconds
Query Executed:select id FROM `ia` where city='Ocheyedan' && SIC_code='5541'DB:business_master_new
loadtime:0.5840790271759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odebolt' limit 1
loadtime:0.58412790298462 / seconds
Query Executed:select id FROM `ia` where city='Odebolt' && SIC_code='5541'DB:business_master_new
loadtime:0.58464598655701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelwein' limit 1
loadtime:0.58468198776245 / seconds
Query Executed:select id FROM `ia` where city='Oelwein' && SIC_code='5541'DB:business_master_new
loadtime:0.58527803421021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:0.58532381057739 / seconds
Query Executed:select id FROM `ia` where city='Ogden' && SIC_code='5541'DB:business_master_new
loadtime:0.58582997322083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okoboji' limit 1
loadtime:0.58586692810059 / seconds
Query Executed:select id FROM `ia` where city='Okoboji' && SIC_code='5541'DB:business_master_new
loadtime:0.58634996414185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olds' limit 1
loadtime:0.58638501167297 / seconds
Query Executed:select id FROM `ia` where city='Olds' && SIC_code='5541'DB:business_master_new
loadtime:0.58676600456238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:0.58680582046509 / seconds
Query Executed:select id FROM `ia` where city='Olin' && SIC_code='5541'DB:business_master_new
loadtime:0.58730292320251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ollie' limit 1
loadtime:0.58733892440796 / seconds
Query Executed:select id FROM `ia` where city='Ollie' && SIC_code='5541'DB:business_master_new
loadtime:0.58785796165466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onawa' limit 1
loadtime:0.58789896965027 / seconds
Query Executed:select id FROM `ia` where city='Onawa' && SIC_code='5541'DB:business_master_new
loadtime:0.58846497535706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onslow' limit 1
loadtime:0.58851790428162 / seconds
Query Executed:select id FROM `ia` where city='Onslow' && SIC_code='5541'DB:business_master_new
loadtime:0.58906698226929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oran' limit 1
loadtime:0.58909797668457 / seconds
Query Executed:select id FROM `ia` where city='Oran' && SIC_code='5541'DB:business_master_new
loadtime:0.5894570350647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange City' limit 1
loadtime:0.58950591087341 / seconds
Query Executed:select id FROM `ia` where city='Orange City' && SIC_code='5541'DB:business_master_new
loadtime:0.59012293815613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:0.59017395973206 / seconds
Query Executed:select id FROM `ia` where city='Orchard' && SIC_code='5541'DB:business_master_new
loadtime:0.59060096740723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.59064698219299 / seconds
Query Executed:select id FROM `ia` where city='Orient' && SIC_code='5541'DB:business_master_new
loadtime:0.59115982055664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage' limit 1
loadtime:0.59120988845825 / seconds
Query Executed:select id FROM `ia` where city='Osage' && SIC_code='5541'DB:business_master_new
loadtime:0.59181189537048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:0.59187197685242 / seconds
Query Executed:select id FROM `ia` where city='Osceola' && SIC_code='5541'DB:business_master_new
loadtime:0.59250998497009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oskaloosa' limit 1
loadtime:0.59256196022034 / seconds
Query Executed:select id FROM `ia` where city='Oskaloosa' && SIC_code='5541'DB:business_master_new
loadtime:0.59329700469971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossian' limit 1
loadtime:0.59334301948547 / seconds
Query Executed:select id FROM `ia` where city='Ossian' && SIC_code='5541'DB:business_master_new
loadtime:0.59382200241089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otho' limit 1
loadtime:0.59384894371033 / seconds
Query Executed:select id FROM `ia` where city='Otho' && SIC_code='5541'DB:business_master_new
loadtime:0.59434390068054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otley' limit 1
loadtime:0.59439396858215 / seconds
Query Executed:select id FROM `ia` where city='Otley' && SIC_code='5541'DB:business_master_new
loadtime:0.5949079990387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oto' limit 1
loadtime:0.59494090080261 / seconds
Query Executed:select id FROM `ia` where city='Oto' && SIC_code='5541'DB:business_master_new
loadtime:0.59539198875427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottosen' limit 1
loadtime:0.59543800354004 / seconds
Query Executed:select id FROM `ia` where city='Ottosen' && SIC_code='5541'DB:business_master_new
loadtime:0.59585881233215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottumwa' limit 1
loadtime:0.59589886665344 / seconds
Query Executed:select id FROM `ia` where city='Ottumwa' && SIC_code='5541'DB:business_master_new
loadtime:0.59682583808899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.59688496589661 / seconds
Query Executed:select id FROM `ia` where city='Oxford' && SIC_code='5541'DB:business_master_new
loadtime:0.5973699092865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford Junction' limit 1
loadtime:0.59741187095642 / seconds
Query Executed:select id FROM `ia` where city='Oxford Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.59788298606873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyens' limit 1
loadtime:0.59792399406433 / seconds
Query Executed:select id FROM `ia` where city='Oyens' && SIC_code='5541'DB:business_master_new
loadtime:0.59827280044556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific Junction' limit 1
loadtime:0.59830784797668 / seconds
Query Executed:select id FROM `ia` where city='Pacific Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.59877800941467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwood' limit 1
loadtime:0.59882092475891 / seconds
Query Executed:select id FROM `ia` where city='Packwood' && SIC_code='5541'DB:business_master_new
loadtime:0.59936189651489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:0.59940695762634 / seconds
Query Executed:select id FROM `ia` where city='Palmer' && SIC_code='5541'DB:business_master_new
loadtime:0.59988594055176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:0.59993481636047 / seconds
Query Executed:select id FROM `ia` where city='Palo' && SIC_code='5541'DB:business_master_new
loadtime:0.60043001174927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panama' limit 1
loadtime:0.60047292709351 / seconds
Query Executed:select id FROM `ia` where city='Panama' && SIC_code='5541'DB:business_master_new
loadtime:0.6010639667511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panora' limit 1
loadtime:0.60110592842102 / seconds
Query Executed:select id FROM `ia` where city='Panora' && SIC_code='5541'DB:business_master_new
loadtime:0.60164284706116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkersburg' limit 1
loadtime:0.6016960144043 / seconds
Query Executed:select id FROM `ia` where city='Parkersburg' && SIC_code='5541'DB:business_master_new
loadtime:0.60222983360291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parnell' limit 1
loadtime:0.60229086875916 / seconds
Query Executed:select id FROM `ia` where city='Parnell' && SIC_code='5541'DB:business_master_new
loadtime:0.60280895233154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paton' limit 1
loadtime:0.60285401344299 / seconds
Query Executed:select id FROM `ia` where city='Paton' && SIC_code='5541'DB:business_master_new
loadtime:0.6033399105072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:0.60338687896729 / seconds
Query Executed:select id FROM `ia` where city='Patterson' && SIC_code='5541'DB:business_master_new
loadtime:0.60368490219116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paullina' limit 1
loadtime:0.60371088981628 / seconds
Query Executed:select id FROM `ia` where city='Paullina' && SIC_code='5541'DB:business_master_new
loadtime:0.60424399375916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pella' limit 1
loadtime:0.60430097579956 / seconds
Query Executed:select id FROM `ia` where city='Pella' && SIC_code='5541'DB:business_master_new
loadtime:0.60494184494019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peosta' limit 1
loadtime:0.60497498512268 / seconds
Query Executed:select id FROM `ia` where city='Peosta' && SIC_code='5541'DB:business_master_new
loadtime:0.60549688339233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Percival' limit 1
loadtime:0.60554885864258 / seconds
Query Executed:select id FROM `ia` where city='Percival' && SIC_code='5541'DB:business_master_new
loadtime:0.6060779094696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:0.60613799095154 / seconds
Query Executed:select id FROM `ia` where city='Perry' && SIC_code='5541'DB:business_master_new
loadtime:0.60676002502441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Persia' limit 1
loadtime:0.60680198669434 / seconds
Query Executed:select id FROM `ia` where city='Persia' && SIC_code='5541'DB:business_master_new
loadtime:0.60732483863831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.60737586021423 / seconds
Query Executed:select id FROM `ia` where city='Peru' && SIC_code='5541'DB:business_master_new
loadtime:0.6077938079834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson' limit 1
loadtime:0.607834815979 / seconds
Query Executed:select id FROM `ia` where city='Peterson' && SIC_code='5541'DB:business_master_new
loadtime:0.60834884643555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:0.60840201377869 / seconds
Query Executed:select id FROM `ia` where city='Pierson' && SIC_code='5541'DB:business_master_new
loadtime:0.60889291763306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Grove' limit 1
loadtime:0.60892486572266 / seconds
Query Executed:select id FROM `ia` where city='Pilot Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.60926294326782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mound' limit 1
loadtime:0.60931181907654 / seconds
Query Executed:select id FROM `ia` where city='Pilot Mound' && SIC_code='5541'DB:business_master_new
loadtime:0.60971903800964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah' limit 1
loadtime:0.60977697372437 / seconds
Query Executed:select id FROM `ia` where city='Pisgah' && SIC_code='5541'DB:business_master_new
loadtime:0.61029601097107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.61034083366394 / seconds
Query Executed:select id FROM `ia` where city='Plainfield' && SIC_code='5541'DB:business_master_new
loadtime:0.61083984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plano' limit 1
loadtime:0.61088681221008 / seconds
Query Executed:select id FROM `ia` where city='Plano' && SIC_code='5541'DB:business_master_new
loadtime:0.61138200759888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:0.61142992973328 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Hill' && SIC_code='5541'DB:business_master_new
loadtime:0.61203503608704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.61208486557007 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.61252284049988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasanton' limit 1
loadtime:0.61257290840149 / seconds
Query Executed:select id FROM `ia` where city='Pleasanton' && SIC_code='5541'DB:business_master_new
loadtime:0.61285996437073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:0.61288690567017 / seconds
Query Executed:select id FROM `ia` where city='Pleasantville' && SIC_code='5541'DB:business_master_new
loadtime:0.61340284347534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:0.61346292495728 / seconds
Query Executed:select id FROM `ia` where city='Plover' && SIC_code='5541'DB:business_master_new
loadtime:0.61382603645325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.61386489868164 / seconds
Query Executed:select id FROM `ia` where city='Plymouth' && SIC_code='5541'DB:business_master_new
loadtime:0.61445999145508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:0.61450290679932 / seconds
Query Executed:select id FROM `ia` where city='Pocahontas' && SIC_code='5541'DB:business_master_new
loadtime:0.61504793167114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polk City' limit 1
loadtime:0.61508989334106 / seconds
Query Executed:select id FROM `ia` where city='Polk City' && SIC_code='5541'DB:business_master_new
loadtime:0.6155948638916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomeroy' limit 1
loadtime:0.6156439781189 / seconds
Query Executed:select id FROM `ia` where city='Pomeroy' && SIC_code='5541'DB:business_master_new
loadtime:0.61617183685303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Popejoy' limit 1
loadtime:0.61621785163879 / seconds
Query Executed:select id FROM `ia` where city='Popejoy' && SIC_code='5541'DB:business_master_new
loadtime:0.6165509223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.61659598350525 / seconds
Query Executed:select id FROM `ia` where city='Portsmouth' && SIC_code='5541'DB:business_master_new
loadtime:0.61711502075195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Postville' limit 1
loadtime:0.61714196205139 / seconds
Query Executed:select id FROM `ia` where city='Postville' && SIC_code='5541'DB:business_master_new
loadtime:0.61769580841064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.61776280403137 / seconds
Query Executed:select id FROM `ia` where city='Prairie City' && SIC_code='5541'DB:business_master_new
loadtime:0.61826181411743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairieburg' limit 1
loadtime:0.61831092834473 / seconds
Query Executed:select id FROM `ia` where city='Prairieburg' && SIC_code='5541'DB:business_master_new
loadtime:0.61868500709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:0.61872482299805 / seconds
Query Executed:select id FROM `ia` where city='Prescott' && SIC_code='5541'DB:business_master_new
loadtime:0.6193528175354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.61940383911133 / seconds
Query Executed:select id FROM `ia` where city='Preston' && SIC_code='5541'DB:business_master_new
loadtime:0.61991190910339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Primghar' limit 1
loadtime:0.61994886398315 / seconds
Query Executed:select id FROM `ia` where city='Primghar' && SIC_code='5541'DB:business_master_new
loadtime:0.62047696113586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:0.62051892280579 / seconds
Query Executed:select id FROM `ia` where city='Princeton' && SIC_code='5541'DB:business_master_new
loadtime:0.62100601196289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prole' limit 1
loadtime:0.6210470199585 / seconds
Query Executed:select id FROM `ia` where city='Prole' && SIC_code='5541'DB:business_master_new
loadtime:0.62152791023254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Promise City' limit 1
loadtime:0.62157082557678 / seconds
Query Executed:select id FROM `ia` where city='Promise City' && SIC_code='5541'DB:business_master_new
loadtime:0.62195301055908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Protivin' limit 1
loadtime:0.621994972229 / seconds
Query Executed:select id FROM `ia` where city='Protivin' && SIC_code='5541'DB:business_master_new
loadtime:0.62244987487793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:0.62250089645386 / seconds
Query Executed:select id FROM `ia` where city='Pulaski' && SIC_code='5541'DB:business_master_new
loadtime:0.62296080589294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quasqueton' limit 1
loadtime:0.62300395965576 / seconds
Query Executed:select id FROM `ia` where city='Quasqueton' && SIC_code='5541'DB:business_master_new
loadtime:0.62344598770142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quimby' limit 1
loadtime:0.62347102165222 / seconds
Query Executed:select id FROM `ia` where city='Quimby' && SIC_code='5541'DB:business_master_new
loadtime:0.62402200698853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radcliffe' limit 1
loadtime:0.62406587600708 / seconds
Query Executed:select id FROM `ia` where city='Radcliffe' && SIC_code='5541'DB:business_master_new
loadtime:0.62456893920898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rake' limit 1
loadtime:0.62461185455322 / seconds
Query Executed:select id FROM `ia` where city='Rake' && SIC_code='5541'DB:business_master_new
loadtime:0.62511491775513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralston' limit 1
loadtime:0.62515902519226 / seconds
Query Executed:select id FROM `ia` where city='Ralston' && SIC_code='5541'DB:business_master_new
loadtime:0.62549090385437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randalia' limit 1
loadtime:0.62554001808167 / seconds
Query Executed:select id FROM `ia` where city='Randalia' && SIC_code='5541'DB:business_master_new
loadtime:0.62593793869019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randall' limit 1
loadtime:0.62597894668579 / seconds
Query Executed:select id FROM `ia` where city='Randall' && SIC_code='5541'DB:business_master_new
loadtime:0.62635087966919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.62638592720032 / seconds
Query Executed:select id FROM `ia` where city='Randolph' && SIC_code='5541'DB:business_master_new
loadtime:0.62679481506348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.62683486938477 / seconds
Query Executed:select id FROM `ia` where city='Raymond' && SIC_code='5541'DB:business_master_new
loadtime:0.62727785110474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readlyn' limit 1
loadtime:0.62731885910034 / seconds
Query Executed:select id FROM `ia` where city='Readlyn' && SIC_code='5541'DB:business_master_new
loadtime:0.62780094146729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reasnor' limit 1
loadtime:0.62784385681152 / seconds
Query Executed:select id FROM `ia` where city='Reasnor' && SIC_code='5541'DB:business_master_new
loadtime:0.62835597991943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:0.62839603424072 / seconds
Query Executed:select id FROM `ia` where city='Red Oak' && SIC_code='5541'DB:business_master_new
loadtime:0.62901401519775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.62906193733215 / seconds
Query Executed:select id FROM `ia` where city='Redding' && SIC_code='5541'DB:business_master_new
loadtime:0.62944602966309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.6294949054718 / seconds
Query Executed:select id FROM `ia` where city='Redfield' && SIC_code='5541'DB:business_master_new
loadtime:0.63005089759827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reinbeck' limit 1
loadtime:0.63008999824524 / seconds
Query Executed:select id FROM `ia` where city='Reinbeck' && SIC_code='5541'DB:business_master_new
loadtime:0.63061189651489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembrandt' limit 1
loadtime:0.6306529045105 / seconds
Query Executed:select id FROM `ia` where city='Rembrandt' && SIC_code='5541'DB:business_master_new
loadtime:0.63117289543152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remsen' limit 1
loadtime:0.63121795654297 / seconds
Query Executed:select id FROM `ia` where city='Remsen' && SIC_code='5541'DB:business_master_new
loadtime:0.63177680969238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renwick' limit 1
loadtime:0.63183403015137 / seconds
Query Executed:select id FROM `ia` where city='Renwick' && SIC_code='5541'DB:business_master_new
loadtime:0.63234686851501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:0.63238286972046 / seconds
Query Executed:select id FROM `ia` where city='Rhodes' && SIC_code='5541'DB:business_master_new
loadtime:0.63280296325684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riceville' limit 1
loadtime:0.63285303115845 / seconds
Query Executed:select id FROM `ia` where city='Riceville' && SIC_code='5541'DB:business_master_new
loadtime:0.63337993621826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.63343095779419 / seconds
Query Executed:select id FROM `ia` where city='Richland' && SIC_code='5541'DB:business_master_new
loadtime:0.63389492034912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ricketts' limit 1
loadtime:0.63392186164856 / seconds
Query Executed:select id FROM `ia` where city='Ricketts' && SIC_code='5541'DB:business_master_new
loadtime:0.63425588607788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.63430500030518 / seconds
Query Executed:select id FROM `ia` where city='Ridgeway' && SIC_code='5541'DB:business_master_new
loadtime:0.63480496406555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringsted' limit 1
loadtime:0.63485193252563 / seconds
Query Executed:select id FROM `ia` where city='Ringsted' && SIC_code='5541'DB:business_master_new
loadtime:0.63534784317017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rippey' limit 1
loadtime:0.63539481163025 / seconds
Query Executed:select id FROM `ia` where city='Rippey' && SIC_code='5541'DB:business_master_new
loadtime:0.63591003417969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:0.6359498500824 / seconds
Query Executed:select id FROM `ia` where city='Riverdale' && SIC_code='5541'DB:business_master_new
loadtime:0.63626885414124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.63631391525269 / seconds
Query Executed:select id FROM `ia` where city='Riverside' && SIC_code='5541'DB:business_master_new
loadtime:0.63682198524475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.63686990737915 / seconds
Query Executed:select id FROM `ia` where city='Riverton' && SIC_code='5541'DB:business_master_new
loadtime:0.63724303245544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robins' limit 1
loadtime:0.63728499412537 / seconds
Query Executed:select id FROM `ia` where city='Robins' && SIC_code='5541'DB:business_master_new
loadtime:0.63775300979614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:0.63779187202454 / seconds
Query Executed:select id FROM `ia` where city='Rock Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.63815784454346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Rapids' limit 1
loadtime:0.63820290565491 / seconds
Query Executed:select id FROM `ia` where city='Rock Rapids' && SIC_code='5541'DB:business_master_new
loadtime:0.63875794410706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Valley' limit 1
loadtime:0.63878393173218 / seconds
Query Executed:select id FROM `ia` where city='Rock Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.63940191268921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:0.63945889472961 / seconds
Query Executed:select id FROM `ia` where city='Rockford' && SIC_code='5541'DB:business_master_new
loadtime:0.63995289802551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:0.63999795913696 / seconds
Query Executed:select id FROM `ia` where city='Rockwell' && SIC_code='5541'DB:business_master_new
loadtime:0.64051294326782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell City' limit 1
loadtime:0.64054894447327 / seconds
Query Executed:select id FROM `ia` where city='Rockwell City' && SIC_code='5541'DB:business_master_new
loadtime:0.64108300209045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:0.64112997055054 / seconds
Query Executed:select id FROM `ia` where city='Rodney' && SIC_code='5541'DB:business_master_new
loadtime:0.64146590232849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roland' limit 1
loadtime:0.6415069103241 / seconds
Query Executed:select id FROM `ia` where city='Roland' && SIC_code='5541'DB:business_master_new
loadtime:0.64196181297302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolfe' limit 1
loadtime:0.64200186729431 / seconds
Query Executed:select id FROM `ia` where city='Rolfe' && SIC_code='5541'DB:business_master_new
loadtime:0.6424720287323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:0.64250683784485 / seconds
Query Executed:select id FROM `ia` where city='Rome' && SIC_code='5541'DB:business_master_new
loadtime:0.64277982711792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:0.64281582832336 / seconds
Query Executed:select id FROM `ia` where city='Rose Hill' && SIC_code='5541'DB:business_master_new
loadtime:0.64326882362366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowan' limit 1
loadtime:0.64331388473511 / seconds
Query Executed:select id FROM `ia` where city='Rowan' && SIC_code='5541'DB:business_master_new
loadtime:0.6436939239502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:0.64372587203979 / seconds
Query Executed:select id FROM `ia` where city='Rowley' && SIC_code='5541'DB:business_master_new
loadtime:0.6441969871521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal' limit 1
loadtime:0.64424681663513 / seconds
Query Executed:select id FROM `ia` where city='Royal' && SIC_code='5541'DB:business_master_new
loadtime:0.64471101760864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudd' limit 1
loadtime:0.64475703239441 / seconds
Query Executed:select id FROM `ia` where city='Rudd' && SIC_code='5541'DB:business_master_new
loadtime:0.64524292945862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnells' limit 1
loadtime:0.64527797698975 / seconds
Query Executed:select id FROM `ia` where city='Runnells' && SIC_code='5541'DB:business_master_new
loadtime:0.64576601982117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:0.64580583572388 / seconds
Query Executed:select id FROM `ia` where city='Russell' && SIC_code='5541'DB:business_master_new
loadtime:0.64638781547546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthven' limit 1
loadtime:0.64643502235413 / seconds
Query Executed:select id FROM `ia` where city='Ruthven' && SIC_code='5541'DB:business_master_new
loadtime:0.64693689346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.64698696136475 / seconds
Query Executed:select id FROM `ia` where city='Rutland' && SIC_code='5541'DB:business_master_new
loadtime:0.64737200737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryan' limit 1
loadtime:0.64741492271423 / seconds
Query Executed:select id FROM `ia` where city='Ryan' && SIC_code='5541'DB:business_master_new
loadtime:0.64787292480469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sabula' limit 1
loadtime:0.64791297912598 / seconds
Query Executed:select id FROM `ia` where city='Sabula' && SIC_code='5541'DB:business_master_new
loadtime:0.64839196205139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sac City' limit 1
loadtime:0.64842796325684 / seconds
Query Executed:select id FROM `ia` where city='Sac City' && SIC_code='5541'DB:business_master_new
loadtime:0.64897990226746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ansgar' limit 1
loadtime:0.64902281761169 / seconds
Query Executed:select id FROM `ia` where city='Saint Ansgar' && SIC_code='5541'DB:business_master_new
loadtime:0.64952683448792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Anthony' limit 1
loadtime:0.64957189559937 / seconds
Query Executed:select id FROM `ia` where city='Saint Anthony' && SIC_code='5541'DB:business_master_new
loadtime:0.6499879360199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.65002489089966 / seconds
Query Executed:select id FROM `ia` where city='Saint Charles' && SIC_code='5541'DB:business_master_new
loadtime:0.65053582191467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Donatus' limit 1
loadtime:0.65057587623596 / seconds
Query Executed:select id FROM `ia` where city='Saint Donatus' && SIC_code='5541'DB:business_master_new
loadtime:0.65095090866089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Marys' limit 1
loadtime:0.65098881721497 / seconds
Query Executed:select id FROM `ia` where city='Saint Marys' && SIC_code='5541'DB:business_master_new
loadtime:0.65138983726501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Olaf' limit 1
loadtime:0.6514368057251 / seconds
Query Executed:select id FROM `ia` where city='Saint Olaf' && SIC_code='5541'DB:business_master_new
loadtime:0.65189599990845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:0.65193700790405 / seconds
Query Executed:select id FROM `ia` where city='Saint Paul' && SIC_code='5541'DB:business_master_new
loadtime:0.65230488777161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.65233993530273 / seconds
Query Executed:select id FROM `ia` where city='Salem' && SIC_code='5541'DB:business_master_new
loadtime:0.65281796455383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salix' limit 1
loadtime:0.65285301208496 / seconds
Query Executed:select id FROM `ia` where city='Salix' && SIC_code='5541'DB:business_master_new
loadtime:0.65333294868469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanborn' limit 1
loadtime:0.65339303016663 / seconds
Query Executed:select id FROM `ia` where city='Sanborn' && SIC_code='5541'DB:business_master_new
loadtime:0.65389084815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scarville' limit 1
loadtime:0.65393280982971 / seconds
Query Executed:select id FROM `ia` where city='Scarville' && SIC_code='5541'DB:business_master_new
loadtime:0.65436697006226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schaller' limit 1
loadtime:0.65440797805786 / seconds
Query Executed:select id FROM `ia` where city='Schaller' && SIC_code='5541'DB:business_master_new
loadtime:0.65488290786743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schleswig' limit 1
loadtime:0.65492296218872 / seconds
Query Executed:select id FROM `ia` where city='Schleswig' && SIC_code='5541'DB:business_master_new
loadtime:0.65542984008789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Grove' limit 1
loadtime:0.65546989440918 / seconds
Query Executed:select id FROM `ia` where city='Scotch Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.6557309627533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:0.65578484535217 / seconds
Query Executed:select id FROM `ia` where city='Scranton' && SIC_code='5541'DB:business_master_new
loadtime:0.65625095367432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Searsboro' limit 1
loadtime:0.6562979221344 / seconds
Query Executed:select id FROM `ia` where city='Searsboro' && SIC_code='5541'DB:business_master_new
loadtime:0.65675401687622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:0.65678095817566 / seconds
Query Executed:select id FROM `ia` where city='Selma' && SIC_code='5541'DB:business_master_new
loadtime:0.65711784362793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeant Bluff' limit 1
loadtime:0.65716695785522 / seconds
Query Executed:select id FROM `ia` where city='Sergeant Bluff' && SIC_code='5541'DB:business_master_new
loadtime:0.65770697593689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.65776085853577 / seconds
Query Executed:select id FROM `ia` where city='Seymour' && SIC_code='5541'DB:business_master_new
loadtime:0.65824484825134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shambaugh' limit 1
loadtime:0.65827989578247 / seconds
Query Executed:select id FROM `ia` where city='Shambaugh' && SIC_code='5541'DB:business_master_new
loadtime:0.65860486030579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon City' limit 1
loadtime:0.65864300727844 / seconds
Query Executed:select id FROM `ia` where city='Shannon City' && SIC_code='5541'DB:business_master_new
loadtime:0.65901899337769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:0.65905499458313 / seconds
Query Executed:select id FROM `ia` where city='Sharpsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.65939998626709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.65944886207581 / seconds
Query Executed:select id FROM `ia` where city='Sheffield' && SIC_code='5541'DB:business_master_new
loadtime:0.6599760055542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:0.66002202033997 / seconds
Query Executed:select id FROM `ia` where city='Shelby' && SIC_code='5541'DB:business_master_new
loadtime:0.66051602363586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldahl' limit 1
loadtime:0.66056680679321 / seconds
Query Executed:select id FROM `ia` where city='Sheldahl' && SIC_code='5541'DB:business_master_new
loadtime:0.66086387634277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.66090488433838 / seconds
Query Executed:select id FROM `ia` where city='Sheldon' && SIC_code='5541'DB:business_master_new
loadtime:0.66150784492493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Rock' limit 1
loadtime:0.6615629196167 / seconds
Query Executed:select id FROM `ia` where city='Shell Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.66210889816284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shellsburg' limit 1
loadtime:0.66215896606445 / seconds
Query Executed:select id FROM `ia` where city='Shellsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.66265892982483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:0.66269493103027 / seconds
Query Executed:select id FROM `ia` where city='Shenandoah' && SIC_code='5541'DB:business_master_new
loadtime:0.6633620262146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrill' limit 1
loadtime:0.66341996192932 / seconds
Query Executed:select id FROM `ia` where city='Sherrill' && SIC_code='5541'DB:business_master_new
loadtime:0.66391587257385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:0.66395783424377 / seconds
Query Executed:select id FROM `ia` where city='Sibley' && SIC_code='5541'DB:business_master_new
loadtime:0.66451382637024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:0.66456985473633 / seconds
Query Executed:select id FROM `ia` where city='Sidney' && SIC_code='5541'DB:business_master_new
loadtime:0.66510081291199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigourney' limit 1
loadtime:0.66514992713928 / seconds
Query Executed:select id FROM `ia` where city='Sigourney' && SIC_code='5541'DB:business_master_new
loadtime:0.66568684577942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.66574501991272 / seconds
Query Executed:select id FROM `ia` where city='Silver City' && SIC_code='5541'DB:business_master_new
loadtime:0.6662130355835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Center' limit 1
loadtime:0.66625285148621 / seconds
Query Executed:select id FROM `ia` where city='Sioux Center' && SIC_code='5541'DB:business_master_new
loadtime:0.66689586639404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux City' limit 1
loadtime:0.66694593429565 / seconds
Query Executed:select id FROM `ia` where city='Sioux City' && SIC_code='5541'DB:business_master_new
loadtime:0.67104291915894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Rapids' limit 1
loadtime:0.67110991477966 / seconds
Query Executed:select id FROM `ia` where city='Sioux Rapids' && SIC_code='5541'DB:business_master_new
loadtime:0.67163395881653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:0.67169189453125 / seconds
Query Executed:select id FROM `ia` where city='Slater' && SIC_code='5541'DB:business_master_new
loadtime:0.67224597930908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sloan' limit 1
loadtime:0.67228984832764 / seconds
Query Executed:select id FROM `ia` where city='Sloan' && SIC_code='5541'DB:business_master_new
loadtime:0.6727659702301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithland' limit 1
loadtime:0.67280888557434 / seconds
Query Executed:select id FROM `ia` where city='Smithland' && SIC_code='5541'DB:business_master_new
loadtime:0.67332792282104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldier' limit 1
loadtime:0.67338490486145 / seconds
Query Executed:select id FROM `ia` where city='Soldier' && SIC_code='5541'DB:business_master_new
loadtime:0.67392301559448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon' limit 1
loadtime:0.67396187782288 / seconds
Query Executed:select id FROM `ia` where city='Solon' && SIC_code='5541'DB:business_master_new
loadtime:0.6745069026947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.67455983161926 / seconds
Query Executed:select id FROM `ia` where city='Somers' && SIC_code='5541'DB:business_master_new
loadtime:0.67505884170532 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amana' limit 1
loadtime:0.67511796951294 / seconds
Query Executed:select id FROM `ia` where city='South Amana' && SIC_code='5541'DB:business_master_new
loadtime:0.67560791969299 / seconds
Query loaded from cache:select * from geodata_geocity where city='South English' limit 1
loadtime:0.67565083503723 / seconds
Query Executed:select id FROM `ia` where city='South English' && SIC_code='5541'DB:business_master_new
loadtime:0.67625689506531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.67631387710571 / seconds
Query Executed:select id FROM `ia` where city='Spencer' && SIC_code='5541'DB:business_master_new
loadtime:0.67707991600037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperry' limit 1
loadtime:0.67712497711182 / seconds
Query Executed:select id FROM `ia` where city='Sperry' && SIC_code='5541'DB:business_master_new
loadtime:0.67770791053772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spillville' limit 1
loadtime:0.67775988578796 / seconds
Query Executed:select id FROM `ia` where city='Spillville' && SIC_code='5541'DB:business_master_new
loadtime:0.67823600769043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spirit Lake' limit 1
loadtime:0.67828702926636 / seconds
Query Executed:select id FROM `ia` where city='Spirit Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.67899084091187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spragueville' limit 1
loadtime:0.67902803421021 / seconds
Query Executed:select id FROM `ia` where city='Spragueville' && SIC_code='5541'DB:business_master_new
loadtime:0.67948293685913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:0.67953181266785 / seconds
Query Executed:select id FROM `ia` where city='Springbrook' && SIC_code='5541'DB:business_master_new
loadtime:0.67992091178894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:0.6799578666687 / seconds
Query Executed:select id FROM `ia` where city='Springville' && SIC_code='5541'DB:business_master_new
loadtime:0.68048787117004 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ansgar' limit 1
loadtime:0.68054294586182 / seconds
Query Executed:select id FROM `ia` where city='St Ansgar' && SIC_code='5541'DB:business_master_new
loadtime:0.68083381652832 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Anthony' limit 1
loadtime:0.68087196350098 / seconds
Query Executed:select id FROM `ia` where city='St Anthony' && SIC_code='5541'DB:business_master_new
loadtime:0.68110990524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.68114185333252 / seconds
Query Executed:select id FROM `ia` where city='St Charles' && SIC_code='5541'DB:business_master_new
loadtime:0.68139982223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Donatus' limit 1
loadtime:0.68142294883728 / seconds
Query Executed:select id FROM `ia` where city='St Donatus' && SIC_code='5541'DB:business_master_new
loadtime:0.68165993690491 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lucas' limit 1
loadtime:0.68169093132019 / seconds
Query Executed:select id FROM `ia` where city='St Lucas' && SIC_code='5541'DB:business_master_new
loadtime:0.68193387985229 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Marys' limit 1
loadtime:0.68196988105774 / seconds
Query Executed:select id FROM `ia` where city='St Marys' && SIC_code='5541'DB:business_master_new
loadtime:0.68219900131226 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Olaf' limit 1
loadtime:0.68222188949585 / seconds
Query Executed:select id FROM `ia` where city='St Olaf' && SIC_code='5541'DB:business_master_new
loadtime:0.68245983123779 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:0.68248987197876 / seconds
Query Executed:select id FROM `ia` where city='St Paul' && SIC_code='5541'DB:business_master_new
loadtime:0.68271899223328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacyville' limit 1
loadtime:0.68276381492615 / seconds
Query Executed:select id FROM `ia` where city='Stacyville' && SIC_code='5541'DB:business_master_new
loadtime:0.68326091766357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:0.68330883979797 / seconds
Query Executed:select id FROM `ia` where city='Stanhope' && SIC_code='5541'DB:business_master_new
loadtime:0.68376302719116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:0.68380784988403 / seconds
Query Executed:select id FROM `ia` where city='Stanley' && SIC_code='5541'DB:business_master_new
loadtime:0.68422698974609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:0.68426895141602 / seconds
Query Executed:select id FROM `ia` where city='Stanton' && SIC_code='5541'DB:business_master_new
loadtime:0.68477702140808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:0.68482899665833 / seconds
Query Executed:select id FROM `ia` where city='Stanwood' && SIC_code='5541'DB:business_master_new
loadtime:0.68541693687439 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Center' limit 1
loadtime:0.68546390533447 / seconds
Query Executed:select id FROM `ia` where city='State Center' && SIC_code='5541'DB:business_master_new
loadtime:0.685959815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Rock' limit 1
loadtime:0.6859929561615 / seconds
Query Executed:select id FROM `ia` where city='Steamboat Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.68656802177429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockport' limit 1
loadtime:0.68661499023438 / seconds
Query Executed:select id FROM `ia` where city='Stockport' && SIC_code='5541'DB:business_master_new
loadtime:0.68708491325378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:0.68712592124939 / seconds
Query Executed:select id FROM `ia` where city='Stockton' && SIC_code='5541'DB:business_master_new
loadtime:0.687668800354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storm Lake' limit 1
loadtime:0.68771600723267 / seconds
Query Executed:select id FROM `ia` where city='Storm Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.68843293190002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Story City' limit 1
loadtime:0.68848299980164 / seconds
Query Executed:select id FROM `ia` where city='Story City' && SIC_code='5541'DB:business_master_new
loadtime:0.68906784057617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stout' limit 1
loadtime:0.68911385536194 / seconds
Query Executed:select id FROM `ia` where city='Stout' && SIC_code='5541'DB:business_master_new
loadtime:0.68943095207214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.68947792053223 / seconds
Query Executed:select id FROM `ia` where city='Stratford' && SIC_code='5541'DB:business_master_new
loadtime:0.68995094299316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry Point' limit 1
loadtime:0.68998193740845 / seconds
Query Executed:select id FROM `ia` where city='Strawberry Point' && SIC_code='5541'DB:business_master_new
loadtime:0.6905198097229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:0.69057583808899 / seconds
Query Executed:select id FROM `ia` where city='Stuart' && SIC_code='5541'DB:business_master_new
loadtime:0.69111585617065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sully' limit 1
loadtime:0.69116282463074 / seconds
Query Executed:select id FROM `ia` where city='Sully' && SIC_code='5541'DB:business_master_new
loadtime:0.69165396690369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:0.69170093536377 / seconds
Query Executed:select id FROM `ia` where city='Sumner' && SIC_code='5541'DB:business_master_new
loadtime:0.69226884841919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.69230389595032 / seconds
Query Executed:select id FROM `ia` where city='Superior' && SIC_code='5541'DB:business_master_new
loadtime:0.69269180297852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:0.69274497032166 / seconds
Query Executed:select id FROM `ia` where city='Sutherland' && SIC_code='5541'DB:business_master_new
loadtime:0.6932578086853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swaledale' limit 1
loadtime:0.69329285621643 / seconds
Query Executed:select id FROM `ia` where city='Swaledale' && SIC_code='5541'DB:business_master_new
loadtime:0.69370603561401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan' limit 1
loadtime:0.69375586509705 / seconds
Query Executed:select id FROM `ia` where city='Swan' && SIC_code='5541'DB:business_master_new
loadtime:0.69408798217773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swea City' limit 1
loadtime:0.69414091110229 / seconds
Query Executed:select id FROM `ia` where city='Swea City' && SIC_code='5541'DB:business_master_new
loadtime:0.69463682174683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesburg' limit 1
loadtime:0.69468092918396 / seconds
Query Executed:select id FROM `ia` where city='Swedesburg' && SIC_code='5541'DB:business_master_new
loadtime:0.69505000114441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swisher' limit 1
loadtime:0.69510197639465 / seconds
Query Executed:select id FROM `ia` where city='Swisher' && SIC_code='5541'DB:business_master_new
loadtime:0.69559502601624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:0.69563698768616 / seconds
Query Executed:select id FROM `ia` where city='Tabor' && SIC_code='5541'DB:business_master_new
loadtime:0.69611001014709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taintor' limit 1
loadtime:0.69615197181702 / seconds
Query Executed:select id FROM `ia` where city='Taintor' && SIC_code='5541'DB:business_master_new
loadtime:0.69642782211304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tama' limit 1
loadtime:0.696457862854 / seconds
Query Executed:select id FROM `ia` where city='Tama' && SIC_code='5541'DB:business_master_new
loadtime:0.69699001312256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teeds Grove' limit 1
loadtime:0.69703483581543 / seconds
Query Executed:select id FROM `ia` where city='Teeds Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.697350025177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:0.69739294052124 / seconds
Query Executed:select id FROM `ia` where city='Templeton' && SIC_code='5541'DB:business_master_new
loadtime:0.69789695739746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennant' limit 1
loadtime:0.69794702529907 / seconds
Query Executed:select id FROM `ia` where city='Tennant' && SIC_code='5541'DB:business_master_new
loadtime:0.69825387001038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terril' limit 1
loadtime:0.69829893112183 / seconds
Query Executed:select id FROM `ia` where city='Terril' && SIC_code='5541'DB:business_master_new
loadtime:0.69876790046692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thayer' limit 1
loadtime:0.69881391525269 / seconds
Query Executed:select id FROM `ia` where city='Thayer' && SIC_code='5541'DB:business_master_new
loadtime:0.69922590255737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.69926190376282 / seconds
Query Executed:select id FROM `ia` where city='Thompson' && SIC_code='5541'DB:business_master_new
loadtime:0.69974589347839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thor' limit 1
loadtime:0.69978785514832 / seconds
Query Executed:select id FROM `ia` where city='Thor' && SIC_code='5541'DB:business_master_new
loadtime:0.70030403137207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:0.70033884048462 / seconds
Query Executed:select id FROM `ia` where city='Thornburg' && SIC_code='5541'DB:business_master_new
loadtime:0.70063900947571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.70067381858826 / seconds
Query Executed:select id FROM `ia` where city='Thornton' && SIC_code='5541'DB:business_master_new
loadtime:0.70115685462952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurman' limit 1
loadtime:0.70120882987976 / seconds
Query Executed:select id FROM `ia` where city='Thurman' && SIC_code='5541'DB:business_master_new
loadtime:0.7016499042511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiffin' limit 1
loadtime:0.70168900489807 / seconds
Query Executed:select id FROM `ia` where city='Tiffin' && SIC_code='5541'DB:business_master_new
loadtime:0.70219492912292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tingley' limit 1
loadtime:0.70225286483765 / seconds
Query Executed:select id FROM `ia` where city='Tingley' && SIC_code='5541'DB:business_master_new
loadtime:0.70264887809753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:0.70268297195435 / seconds
Query Executed:select id FROM `ia` where city='Tipton' && SIC_code='5541'DB:business_master_new
loadtime:0.70330095291138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titonka' limit 1
loadtime:0.70335292816162 / seconds
Query Executed:select id FROM `ia` where city='Titonka' && SIC_code='5541'DB:business_master_new
loadtime:0.70383596420288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toddville' limit 1
loadtime:0.70387387275696 / seconds
Query Executed:select id FROM `ia` where city='Toddville' && SIC_code='5541'DB:business_master_new
loadtime:0.70448589324951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toeterville' limit 1
loadtime:0.70452785491943 / seconds
Query Executed:select id FROM `ia` where city='Toeterville' && SIC_code='5541'DB:business_master_new
loadtime:0.70480680465698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toledo' limit 1
loadtime:0.70485091209412 / seconds
Query Executed:select id FROM `ia` where city='Toledo' && SIC_code='5541'DB:business_master_new
loadtime:0.70538401603699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:0.7054398059845 / seconds
Query Executed:select id FROM `ia` where city='Toronto' && SIC_code='5541'DB:business_master_new
loadtime:0.70569801330566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tracy' limit 1
loadtime:0.70574688911438 / seconds
Query Executed:select id FROM `ia` where city='Tracy' && SIC_code='5541'DB:business_master_new
loadtime:0.70613980293274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traer' limit 1
loadtime:0.70618295669556 / seconds
Query Executed:select id FROM `ia` where city='Traer' && SIC_code='5541'DB:business_master_new
loadtime:0.70669198036194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Treynor' limit 1
loadtime:0.70675492286682 / seconds
Query Executed:select id FROM `ia` where city='Treynor' && SIC_code='5541'DB:business_master_new
loadtime:0.70726180076599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:0.7073118686676 / seconds
Query Executed:select id FROM `ia` where city='Tripoli' && SIC_code='5541'DB:business_master_new
loadtime:0.70781493186951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy Mills' limit 1
loadtime:0.70785689353943 / seconds
Query Executed:select id FROM `ia` where city='Troy Mills' && SIC_code='5541'DB:business_master_new
loadtime:0.70826101303101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truesdale' limit 1
loadtime:0.70830988883972 / seconds
Query Executed:select id FROM `ia` where city='Truesdale' && SIC_code='5541'DB:business_master_new
loadtime:0.70863389968872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:0.70866799354553 / seconds
Query Executed:select id FROM `ia` where city='Truro' && SIC_code='5541'DB:business_master_new
loadtime:0.70914387702942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turin' limit 1
loadtime:0.70918297767639 / seconds
Query Executed:select id FROM `ia` where city='Turin' && SIC_code='5541'DB:business_master_new
loadtime:0.70945000648499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Udell' limit 1
loadtime:0.70948195457458 / seconds
Query Executed:select id FROM `ia` where city='Udell' && SIC_code='5541'DB:business_master_new
loadtime:0.70983982086182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underwood' limit 1
loadtime:0.70987391471863 / seconds
Query Executed:select id FROM `ia` where city='Underwood' && SIC_code='5541'DB:business_master_new
loadtime:0.71035385131836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.71040892601013 / seconds
Query Executed:select id FROM `ia` where city='Union' && SIC_code='5541'DB:business_master_new
loadtime:0.71089887619019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.71093702316284 / seconds
Query Executed:select id FROM `ia` where city='Unionville' && SIC_code='5541'DB:business_master_new
loadtime:0.71131491661072 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Park' limit 1
loadtime:0.71137285232544 / seconds
Query Executed:select id FROM `ia` where city='University Park' && SIC_code='5541'DB:business_master_new
loadtime:0.7116858959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbana' limit 1
loadtime:0.71171689033508 / seconds
Query Executed:select id FROM `ia` where city='Urbana' && SIC_code='5541'DB:business_master_new
loadtime:0.7122118473053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbandale' limit 1
loadtime:0.71226191520691 / seconds
Query Executed:select id FROM `ia` where city='Urbandale' && SIC_code='5541'DB:business_master_new
loadtime:0.71324300765991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute' limit 1
loadtime:0.71329283714294 / seconds
Query Executed:select id FROM `ia` where city='Ute' && SIC_code='5541'DB:business_master_new
loadtime:0.7137668132782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:0.71381402015686 / seconds
Query Executed:select id FROM `ia` where city='Vail' && SIC_code='5541'DB:business_master_new
loadtime:0.7143018245697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Horne' limit 1
loadtime:0.71433687210083 / seconds
Query Executed:select id FROM `ia` where city='Van Horne' && SIC_code='5541'DB:business_master_new
loadtime:0.7148380279541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Meter' limit 1
loadtime:0.71487903594971 / seconds
Query Executed:select id FROM `ia` where city='Van Meter' && SIC_code='5541'DB:business_master_new
loadtime:0.71537780761719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wert' limit 1
loadtime:0.71542000770569 / seconds
Query Executed:select id FROM `ia` where city='Van Wert' && SIC_code='5541'DB:business_master_new
loadtime:0.71579790115356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varina' limit 1
loadtime:0.71583890914917 / seconds
Query Executed:select id FROM `ia` where city='Varina' && SIC_code='5541'DB:business_master_new
loadtime:0.71618700027466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventura' limit 1
loadtime:0.71622800827026 / seconds
Query Executed:select id FROM `ia` where city='Ventura' && SIC_code='5541'DB:business_master_new
loadtime:0.71672296524048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:0.71677780151367 / seconds
Query Executed:select id FROM `ia` where city='Victor' && SIC_code='5541'DB:business_master_new
loadtime:0.71727299690247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villisca' limit 1
loadtime:0.7173159122467 / seconds
Query Executed:select id FROM `ia` where city='Villisca' && SIC_code='5541'DB:business_master_new
loadtime:0.71783089637756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincent' limit 1
loadtime:0.71787095069885 / seconds
Query Executed:select id FROM `ia` where city='Vincent' && SIC_code='5541'DB:business_master_new
loadtime:0.71836996078491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vining' limit 1
loadtime:0.718416929245 / seconds
Query Executed:select id FROM `ia` where city='Vining' && SIC_code='5541'DB:business_master_new
loadtime:0.71872186660767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:0.71876096725464 / seconds
Query Executed:select id FROM `ia` where city='Vinton' && SIC_code='5541'DB:business_master_new
loadtime:0.71938800811768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:0.71943783760071 / seconds
Query Executed:select id FROM `ia` where city='Viola' && SIC_code='5541'DB:business_master_new
loadtime:0.71971893310547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:0.71976900100708 / seconds
Query Executed:select id FROM `ia` where city='Volga' && SIC_code='5541'DB:business_master_new
loadtime:0.72023487091064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadena' limit 1
loadtime:0.72028183937073 / seconds
Query Executed:select id FROM `ia` where city='Wadena' && SIC_code='5541'DB:business_master_new
loadtime:0.72070980072021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walcott' limit 1
loadtime:0.72075581550598 / seconds
Query Executed:select id FROM `ia` where city='Walcott' && SIC_code='5541'DB:business_master_new
loadtime:0.72130799293518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walford' limit 1
loadtime:0.7213659286499 / seconds
Query Executed:select id FROM `ia` where city='Walford' && SIC_code='5541'DB:business_master_new
loadtime:0.72193288803101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walker' limit 1
loadtime:0.72197890281677 / seconds
Query Executed:select id FROM `ia` where city='Walker' && SIC_code='5541'DB:business_master_new
loadtime:0.72248196601868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Lake' limit 1
loadtime:0.7225170135498 / seconds
Query Executed:select id FROM `ia` where city='Wall Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.72301292419434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.72305703163147 / seconds
Query Executed:select id FROM `ia` where city='Wallingford' && SIC_code='5541'DB:business_master_new
loadtime:0.72357296943665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:0.72361993789673 / seconds
Query Executed:select id FROM `ia` where city='Walnut' && SIC_code='5541'DB:business_master_new
loadtime:0.72418880462646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wapello' limit 1
loadtime:0.72423887252808 / seconds
Query Executed:select id FROM `ia` where city='Wapello' && SIC_code='5541'DB:business_master_new
loadtime:0.72476482391357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:0.72480893135071 / seconds
Query Executed:select id FROM `ia` where city='Washburn' && SIC_code='5541'DB:business_master_new
loadtime:0.72511792182922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.72516489028931 / seconds
Query Executed:select id FROM `ia` where city='Washington' && SIC_code='5541'DB:business_master_new
loadtime:0.72583484649658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washta' limit 1
loadtime:0.72587895393372 / seconds
Query Executed:select id FROM `ia` where city='Washta' && SIC_code='5541'DB:business_master_new
loadtime:0.72645282745361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:0.72651100158691 / seconds
Query Executed:select id FROM `ia` where city='Waterloo' && SIC_code='5541'DB:business_master_new
loadtime:0.73056888580322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:0.73061990737915 / seconds
Query Executed:select id FROM `ia` where city='Waterville' && SIC_code='5541'DB:business_master_new
loadtime:0.73124599456787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:0.7312958240509 / seconds
Query Executed:select id FROM `ia` where city='Watkins' && SIC_code='5541'DB:business_master_new
loadtime:0.73176383972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waucoma' limit 1
loadtime:0.73180198669434 / seconds
Query Executed:select id FROM `ia` where city='Waucoma' && SIC_code='5541'DB:business_master_new
loadtime:0.7322838306427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukee' limit 1
loadtime:0.73231887817383 / seconds
Query Executed:select id FROM `ia` where city='Waukee' && SIC_code='5541'DB:business_master_new
loadtime:0.73288583755493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukon' limit 1
loadtime:0.73293399810791 / seconds
Query Executed:select id FROM `ia` where city='Waukon' && SIC_code='5541'DB:business_master_new
loadtime:0.73356199264526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:0.73361301422119 / seconds
Query Executed:select id FROM `ia` where city='Waverly' && SIC_code='5541'DB:business_master_new
loadtime:0.73431897163391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:0.73436784744263 / seconds
Query Executed:select id FROM `ia` where city='Wayland' && SIC_code='5541'DB:business_master_new
loadtime:0.73484802246094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:0.73488998413086 / seconds
Query Executed:select id FROM `ia` where city='Webb' && SIC_code='5541'DB:business_master_new
loadtime:0.73542094230652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.73547792434692 / seconds
Query Executed:select id FROM `ia` where city='Webster' && SIC_code='5541'DB:business_master_new
loadtime:0.73588681221008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster City' limit 1
loadtime:0.73591899871826 / seconds
Query Executed:select id FROM `ia` where city='Webster City' && SIC_code='5541'DB:business_master_new
loadtime:0.73654890060425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:0.73659586906433 / seconds
Query Executed:select id FROM `ia` where city='Weldon' && SIC_code='5541'DB:business_master_new
loadtime:0.73698592185974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellman' limit 1
loadtime:0.73702597618103 / seconds
Query Executed:select id FROM `ia` where city='Wellman' && SIC_code='5541'DB:business_master_new
loadtime:0.73756194114685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsburg' limit 1
loadtime:0.73761987686157 / seconds
Query Executed:select id FROM `ia` where city='Wellsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.73810696601868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welton' limit 1
loadtime:0.73813486099243 / seconds
Query Executed:select id FROM `ia` where city='Welton' && SIC_code='5541'DB:business_master_new
loadtime:0.73846483230591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesley' limit 1
loadtime:0.73850202560425 / seconds
Query Executed:select id FROM `ia` where city='Wesley' && SIC_code='5541'DB:business_master_new
loadtime:0.73900389671326 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Amana' limit 1
loadtime:0.73904180526733 / seconds
Query Executed:select id FROM `ia` where city='West Amana' && SIC_code='5541'DB:business_master_new
loadtime:0.73928689956665 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:0.73931884765625 / seconds
Query Executed:select id FROM `ia` where city='West Bend' && SIC_code='5541'DB:business_master_new
loadtime:0.73979783058167 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:0.73982286453247 / seconds
Query Executed:select id FROM `ia` where city='West Branch' && SIC_code='5541'DB:business_master_new
loadtime:0.74038600921631 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burlington' limit 1
loadtime:0.74044489860535 / seconds
Query Executed:select id FROM `ia` where city='West Burlington' && SIC_code='5541'DB:business_master_new
loadtime:0.74106788635254 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chester' limit 1
loadtime:0.74111485481262 / seconds
Query Executed:select id FROM `ia` where city='West Chester' && SIC_code='5541'DB:business_master_new
loadtime:0.74157381057739 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Des Moines' limit 1
loadtime:0.74160885810852 / seconds
Query Executed:select id FROM `ia` where city='West Des Moines' && SIC_code='5541'DB:business_master_new
loadtime:0.74569797515869 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Grove' limit 1
loadtime:0.74576687812805 / seconds
Query Executed:select id FROM `ia` where city='West Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.74608302116394 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Liberty' limit 1
loadtime:0.7461268901825 / seconds
Query Executed:select id FROM `ia` where city='West Liberty' && SIC_code='5541'DB:business_master_new
loadtime:0.74670386314392 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:0.74677991867065 / seconds
Query Executed:select id FROM `ia` where city='West Point' && SIC_code='5541'DB:business_master_new
loadtime:0.74731492996216 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:0.74736785888672 / seconds
Query Executed:select id FROM `ia` where city='West Union' && SIC_code='5541'DB:business_master_new
loadtime:0.74789881706238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:0.74793887138367 / seconds
Query Executed:select id FROM `ia` where city='Westfield' && SIC_code='5541'DB:business_master_new
loadtime:0.74840903282166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westgate' limit 1
loadtime:0.748459815979 / seconds
Query Executed:select id FROM `ia` where city='Westgate' && SIC_code='5541'DB:business_master_new
loadtime:0.74891901016235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:0.7489538192749 / seconds
Query Executed:select id FROM `ia` where city='Westphalia' && SIC_code='5541'DB:business_master_new
loadtime:0.74932384490967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westside' limit 1
loadtime:0.74937200546265 / seconds
Query Executed:select id FROM `ia` where city='Westside' && SIC_code='5541'DB:business_master_new
loadtime:0.74985194206238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wever' limit 1
loadtime:0.74988603591919 / seconds
Query Executed:select id FROM `ia` where city='Wever' && SIC_code='5541'DB:business_master_new
loadtime:0.75034880638123 / seconds
Query loaded from cache:select * from geodata_geocity where city='What Cheer' limit 1
loadtime:0.75039982795715 / seconds
Query Executed:select id FROM `ia` where city='What Cheer' && SIC_code='5541'DB:business_master_new
loadtime:0.75085783004761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheatland' limit 1
loadtime:0.75089883804321 / seconds
Query Executed:select id FROM `ia` where city='Wheatland' && SIC_code='5541'DB:business_master_new
loadtime:0.75141501426697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:0.75145792961121 / seconds
Query Executed:select id FROM `ia` where city='Whiting' && SIC_code='5541'DB:business_master_new
loadtime:0.75193786621094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:0.75198292732239 / seconds
Query Executed:select id FROM `ia` where city='Whittemore' && SIC_code='5541'DB:business_master_new
loadtime:0.75245881080627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitten' limit 1
loadtime:0.75250101089478 / seconds
Query Executed:select id FROM `ia` where city='Whitten' && SIC_code='5541'DB:business_master_new
loadtime:0.75285601615906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:0.75289583206177 / seconds
Query Executed:select id FROM `ia` where city='Williams' && SIC_code='5541'DB:business_master_new
loadtime:0.75338792800903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:0.75344181060791 / seconds
Query Executed:select id FROM `ia` where city='Williamsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.75406002998352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamson' limit 1
loadtime:0.75410985946655 / seconds
Query Executed:select id FROM `ia` where city='Williamson' && SIC_code='5541'DB:business_master_new
loadtime:0.7544150352478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.7544629573822 / seconds
Query Executed:select id FROM `ia` where city='Wilton' && SIC_code='5541'DB:business_master_new
loadtime:0.75503993034363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Heights' limit 1
loadtime:0.7550938129425 / seconds
Query Executed:select id FROM `ia` where city='Windsor Heights' && SIC_code='5541'DB:business_master_new
loadtime:0.75568985939026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:0.75576090812683 / seconds
Query Executed:select id FROM `ia` where city='Winfield' && SIC_code='5541'DB:business_master_new
loadtime:0.75628089904785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterset' limit 1
loadtime:0.75633001327515 / seconds
Query Executed:select id FROM `ia` where city='Winterset' && SIC_code='5541'DB:business_master_new
loadtime:0.75693702697754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:0.75698399543762 / seconds
Query Executed:select id FROM `ia` where city='Winthrop' && SIC_code='5541'DB:business_master_new
loadtime:0.75747179985046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiota' limit 1
loadtime:0.75751495361328 / seconds
Query Executed:select id FROM `ia` where city='Wiota' && SIC_code='5541'DB:business_master_new
loadtime:0.75797581672668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woden' limit 1
loadtime:0.75801491737366 / seconds
Query Executed:select id FROM `ia` where city='Woden' && SIC_code='5541'DB:business_master_new
loadtime:0.75850391387939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:0.75855803489685 / seconds
Query Executed:select id FROM `ia` where city='Woodbine' && SIC_code='5541'DB:business_master_new
loadtime:0.75907802581787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodburn' limit 1
loadtime:0.7591118812561 / seconds
Query Executed:select id FROM `ia` where city='Woodburn' && SIC_code='5541'DB:business_master_new
loadtime:0.75960683822632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodward' limit 1
loadtime:0.7596538066864 / seconds
Query Executed:select id FROM `ia` where city='Woodward' && SIC_code='5541'DB:business_master_new
loadtime:0.76013588905334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolstock' limit 1
loadtime:0.76017880439758 / seconds
Query Executed:select id FROM `ia` where city='Woolstock' && SIC_code='5541'DB:business_master_new
loadtime:0.76066589355469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:0.7607250213623 / seconds
Query Executed:select id FROM `ia` where city='Worthington' && SIC_code='5541'DB:business_master_new
loadtime:0.76122879981995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:0.76127886772156 / seconds
Query Executed:select id FROM `ia` where city='Wyoming' && SIC_code='5541'DB:business_master_new
loadtime:0.76176500320435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:0.76180386543274 / seconds
Query Executed:select id FROM `ia` where city='Yale' && SIC_code='5541'DB:business_master_new
loadtime:0.76226997375488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth' limit 1
loadtime:0.76231384277344 / seconds
Query Executed:select id FROM `ia` where city='Yarmouth' && SIC_code='5541'DB:business_master_new
loadtime:0.76276397705078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:0.7627968788147 / seconds
Query Executed:select id FROM `ia` where city='Yorktown' && SIC_code='5541'DB:business_master_new
loadtime:0.76310896873474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zearing' limit 1
loadtime:0.76315784454346 / seconds
Query Executed:select id FROM `ia` where city='Zearing' && SIC_code='5541'DB:business_master_new
loadtime:0.76365399360657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zwingle' limit 1
loadtime:0.76369595527649 / seconds
Query Executed:select id FROM `ia` where city='Zwingle' && SIC_code='5541'DB:business_master_new
loadtime:0.76429486274719 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.76443600654602 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.76475286483765 / seconds
Operation template executed (chunk cache operation)
loadtime:0.7648458480835 / seconds
template override:Default
loadtime:0.76486492156982 / 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:0.76605296134949 / seconds
Template Constructed, Array Rows:49
loadtime:0.76635098457336 / seconds
TOTAL EXECUTION TIME: 0.76612
loadtime:0.76652383804321 / 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] => gasoline-service-station [stateURLid] => iowa )


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