Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.392333984375E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00059795379638672 / seconds
host not found setting manual db connection
loadtime:0.0010008811950684 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0013189315795898 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0015649795532227 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0016300678253174 / seconds
zipcode:
loadtime:0.0016489028930664 / seconds
Query Executed:select * from search_referrer where page_hash='5df8fcd6e11b8398b69a3d147e3d6cd1' limit 10 DB:ezrox_toadli
loadtime:0.0018658638000488 / seconds
Operation header executed (non global)
loadtime:0.0018839836120605 / seconds
Operation leaderboard executed (non global)
loadtime:0.0019240379333496 / seconds
Operation square executed (non global)
loadtime:0.0019378662109375 / seconds
Operation square_bottom executed (non global)
loadtime:0.0019509792327881 / seconds
Operation smallsquare executed (non global)
loadtime:0.0019619464874268 / seconds
Operation headeradright executed (non global)
loadtime:0.0019729137420654 / seconds
Operation google_analytics executed (non global)
loadtime:0.0019848346710205 / seconds
Operation topstories executed (non global)
loadtime:0.0019960403442383 / seconds
Operation businessnearyou executed (non global)
loadtime:0.002007007598877 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0020170211791992 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0023078918457031 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0024619102478027 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0025029182434082 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0025708675384521 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0026290416717529 / seconds
Template key: archive_menu pushed
loadtime:0.0026350021362305 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0026469230651855 / seconds
Template key: get_gravatar pushed
loadtime:0.0026509761810303 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.002655029296875 / seconds
*10)-10)+1 | start:0
loadtime:0.0026788711547852 / seconds
DB connected to localhost business_master_new
loadtime:0.0028989315032959 / seconds
Query Executed:select * from categories where cat_URLid='auto-and-home-supply-stores'DB:business_master_new
loadtime:0.003432035446167 / seconds
Query stored in cache : _QUERY_www.toadli.come4f69782081f0ed656ec764576e5695a
loadtime:0.0034699440002441 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.0034999847412109 / seconds
Query Executed:select * from `ia_catmap` where sic='5531' order by city ascDB:business_master_new
loadtime:0.36234498023987 / seconds
Query stored in cache : _QUERY_www.toadli.com19921318f671f5822a5bcc688c6b2409
loadtime:0.36427688598633 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.36432194709778 / seconds
Query Executed:select sum(totalcount) as totalsum from `ia_catmap` where sic='5531'DB:business_master_new
loadtime:0.36945390701294 / seconds
Query stored in cache : _QUERY_www.toadli.come6da7bf4562056c12bb34e6afa270cf7
loadtime:0.36948990821838 / seconds
981 / 11
loadtime:0.3695240020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackley' limit 1
loadtime:0.36957192420959 / seconds
Query Executed:select id FROM `ia` where city='Ackley' && SIC_code='5531'DB:business_master_new
loadtime:0.42933392524719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackworth' limit 1
loadtime:0.4293909072876 / seconds
Query Executed:select id FROM `ia` where city='Ackworth' && SIC_code='5531'DB:business_master_new
loadtime:0.43287587165833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adair' limit 1
loadtime:0.43292784690857 / seconds
Query Executed:select id FROM `ia` where city='Adair' && SIC_code='5531'DB:business_master_new
loadtime:0.43421196937561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adel' limit 1
loadtime:0.43425488471985 / seconds
Query Executed:select id FROM `ia` where city='Adel' && SIC_code='5531'DB:business_master_new
loadtime:0.43544602394104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.43550300598145 / seconds
Query Executed:select id FROM `ia` where city='Afton' && SIC_code='5531'DB:business_master_new
loadtime:0.43634700775146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agency' limit 1
loadtime:0.43645787239075 / seconds
Query Executed:select id FROM `ia` where city='Agency' && SIC_code='5531'DB:business_master_new
loadtime:0.45048999786377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ainsworth' limit 1
loadtime:0.45052599906921 / seconds
Query Executed:select id FROM `ia` where city='Ainsworth' && SIC_code='5531'DB:business_master_new
loadtime:0.45114302635193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.45119595527649 / seconds
Query Executed:select id FROM `ia` where city='Akron' && SIC_code='5531'DB:business_master_new
loadtime:0.45202398300171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albert City' limit 1
loadtime:0.4520800113678 / seconds
Query Executed:select id FROM `ia` where city='Albert City' && SIC_code='5531'DB:business_master_new
loadtime:0.45267295837402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albia' limit 1
loadtime:0.45271396636963 / seconds
Query Executed:select id FROM `ia` where city='Albia' && SIC_code='5531'DB:business_master_new
loadtime:0.45516896247864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.45526504516602 / seconds
Query Executed:select id FROM `ia` where city='Albion' && SIC_code='5531'DB:business_master_new
loadtime:0.46497583389282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburnett' limit 1
loadtime:0.46502590179443 / seconds
Query Executed:select id FROM `ia` where city='Alburnett' && SIC_code='5531'DB:business_master_new
loadtime:0.48031091690063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.48036193847656 / seconds
Query Executed:select id FROM `ia` where city='Alden' && SIC_code='5531'DB:business_master_new
loadtime:0.48097991943359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.48102998733521 / seconds
Query Executed:select id FROM `ia` where city='Alexander' && SIC_code='5531'DB:business_master_new
loadtime:0.49079084396362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algona' limit 1
loadtime:0.49083995819092 / seconds
Query Executed:select id FROM `ia` where city='Algona' && SIC_code='5531'DB:business_master_new
loadtime:0.49266290664673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleman' limit 1
loadtime:0.49270701408386 / seconds
Query Executed:select id FROM `ia` where city='Alleman' && SIC_code='5531'DB:business_master_new
loadtime:0.49844789505005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendorf' limit 1
loadtime:0.49849605560303 / seconds
Query Executed:select id FROM `ia` where city='Allendorf' && SIC_code='5531'DB:business_master_new
loadtime:0.49877500534058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allerton' limit 1
loadtime:0.49881386756897 / seconds
Query Executed:select id FROM `ia` where city='Allerton' && SIC_code='5531'DB:business_master_new
loadtime:0.53220105171204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allison' limit 1
loadtime:0.5322630405426 / seconds
Query Executed:select id FROM `ia` where city='Allison' && SIC_code='5531'DB:business_master_new
loadtime:0.53329586982727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.53339290618896 / seconds
Query Executed:select id FROM `ia` where city='Alpha' && SIC_code='5531'DB:business_master_new
loadtime:0.53428101539612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.53432297706604 / seconds
Query Executed:select id FROM `ia` where city='Alta' && SIC_code='5531'DB:business_master_new
loadtime:0.53496789932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta Vista' limit 1
loadtime:0.53501391410828 / seconds
Query Executed:select id FROM `ia` where city='Alta Vista' && SIC_code='5531'DB:business_master_new
loadtime:0.54251885414124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.54256987571716 / seconds
Query Executed:select id FROM `ia` where city='Alton' && SIC_code='5531'DB:business_master_new
loadtime:0.54339790344238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.54345798492432 / seconds
Query Executed:select id FROM `ia` where city='Altoona' && SIC_code='5531'DB:business_master_new
loadtime:0.54561495780945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvord' limit 1
loadtime:0.54566097259521 / seconds
Query Executed:select id FROM `ia` where city='Alvord' && SIC_code='5531'DB:business_master_new
loadtime:0.55316090583801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amana' limit 1
loadtime:0.55320906639099 / seconds
Query Executed:select id FROM `ia` where city='Amana' && SIC_code='5531'DB:business_master_new
loadtime:0.55380988121033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ames' limit 1
loadtime:0.55385398864746 / seconds
Query Executed:select id FROM `ia` where city='Ames' && SIC_code='5531'DB:business_master_new
loadtime:0.5579400062561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anamosa' limit 1
loadtime:0.5579879283905 / seconds
Query Executed:select id FROM `ia` where city='Anamosa' && SIC_code='5531'DB:business_master_new
loadtime:0.55892205238342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.55898094177246 / seconds
Query Executed:select id FROM `ia` where city='Andover' && SIC_code='5531'DB:business_master_new
loadtime:0.56215906143188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrew' limit 1
loadtime:0.5622079372406 / seconds
Query Executed:select id FROM `ia` where city='Andrew' && SIC_code='5531'DB:business_master_new
loadtime:0.56630897521973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anita' limit 1
loadtime:0.56634902954102 / seconds
Query Executed:select id FROM `ia` where city='Anita' && SIC_code='5531'DB:business_master_new
loadtime:0.56719303131104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ankeny' limit 1
loadtime:0.56725192070007 / seconds
Query Executed:select id FROM `ia` where city='Ankeny' && SIC_code='5531'DB:business_master_new
loadtime:0.57092785835266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthon' limit 1
loadtime:0.57098889350891 / seconds
Query Executed:select id FROM `ia` where city='Anthon' && SIC_code='5531'DB:business_master_new
loadtime:0.57157301902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aplington' limit 1
loadtime:0.5716278553009 / seconds
Query Executed:select id FROM `ia` where city='Aplington' && SIC_code='5531'DB:business_master_new
loadtime:0.57224202156067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.57229089736938 / seconds
Query Executed:select id FROM `ia` where city='Arcadia' && SIC_code='5531'DB:business_master_new
loadtime:0.57284593582153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archer' limit 1
loadtime:0.57288694381714 / seconds
Query Executed:select id FROM `ia` where city='Archer' && SIC_code='5531'DB:business_master_new
loadtime:0.57866883277893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aredale' limit 1
loadtime:0.5787148475647 / seconds
Query Executed:select id FROM `ia` where city='Aredale' && SIC_code='5531'DB:business_master_new
loadtime:0.58015704154968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.58021187782288 / seconds
Query Executed:select id FROM `ia` where city='Argyle' && SIC_code='5531'DB:business_master_new
loadtime:0.58608198165894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arion' limit 1
loadtime:0.58613085746765 / seconds
Query Executed:select id FROM `ia` where city='Arion' && SIC_code='5531'DB:business_master_new
loadtime:0.58811688423157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arispe' limit 1
loadtime:0.5881519317627 / seconds
Query Executed:select id FROM `ia` where city='Arispe' && SIC_code='5531'DB:business_master_new
loadtime:0.59012389183044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.59015893936157 / seconds
Query Executed:select id FROM `ia` where city='Arlington' && SIC_code='5531'DB:business_master_new
loadtime:0.59071803092957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armstrong' limit 1
loadtime:0.59076690673828 / seconds
Query Executed:select id FROM `ia` where city='Armstrong' && SIC_code='5531'DB:business_master_new
loadtime:0.59135890007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnolds Park' limit 1
loadtime:0.59140396118164 / seconds
Query Executed:select id FROM `ia` where city='Arnolds Park' && SIC_code='5531'DB:business_master_new
loadtime:0.59231090545654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arthur' limit 1
loadtime:0.59237003326416 / seconds
Query Executed:select id FROM `ia` where city='Arthur' && SIC_code='5531'DB:business_master_new
loadtime:0.60132384300232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.60137104988098 / seconds
Query Executed:select id FROM `ia` where city='Ashton' && SIC_code='5531'DB:business_master_new
loadtime:0.60198998451233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aspinwall' limit 1
loadtime:0.60203003883362 / seconds
Query Executed:select id FROM `ia` where city='Aspinwall' && SIC_code='5531'DB:business_master_new
loadtime:0.60381293296814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atalissa' limit 1
loadtime:0.60386085510254 / seconds
Query Executed:select id FROM `ia` where city='Atalissa' && SIC_code='5531'DB:business_master_new
loadtime:0.61269283294678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.61274099349976 / seconds
Query Executed:select id FROM `ia` where city='Atkins' && SIC_code='5531'DB:business_master_new
loadtime:0.61334896087646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.61341094970703 / seconds
Query Executed:select id FROM `ia` where city='Atlantic' && SIC_code='5531'DB:business_master_new
loadtime:0.61529803276062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.61540985107422 / seconds
Query Executed:select id FROM `ia` where city='Auburn' && SIC_code='5531'DB:business_master_new
loadtime:0.62314605712891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.62319588661194 / seconds
Query Executed:select id FROM `ia` where city='Audubon' && SIC_code='5531'DB:business_master_new
loadtime:0.62455892562866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurelia' limit 1
loadtime:0.62462902069092 / seconds
Query Executed:select id FROM `ia` where city='Aurelia' && SIC_code='5531'DB:business_master_new
loadtime:0.62524890899658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.62533402442932 / seconds
Query Executed:select id FROM `ia` where city='Aurora' && SIC_code='5531'DB:business_master_new
loadtime:0.63756799697876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.63762283325195 / seconds
Query Executed:select id FROM `ia` where city='Austinville' && SIC_code='5531'DB:business_master_new
loadtime:0.63871097564697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.63875794410706 / seconds
Query Executed:select id FROM `ia` where city='Avoca' && SIC_code='5531'DB:business_master_new
loadtime:0.6400158405304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayrshire' limit 1
loadtime:0.64007306098938 / seconds
Query Executed:select id FROM `ia` where city='Ayrshire' && SIC_code='5531'DB:business_master_new
loadtime:0.6445848941803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.64465594291687 / seconds
Query Executed:select id FROM `ia` where city='Badger' && SIC_code='5531'DB:business_master_new
loadtime:0.65200686454773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.65205502510071 / seconds
Query Executed:select id FROM `ia` where city='Bagley' && SIC_code='5531'DB:business_master_new
loadtime:0.65852189064026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.65857100486755 / seconds
Query Executed:select id FROM `ia` where city='Baldwin' && SIC_code='5531'DB:business_master_new
loadtime:0.6636700630188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.66371893882751 / seconds
Query Executed:select id FROM `ia` where city='Bancroft' && SIC_code='5531'DB:business_master_new
loadtime:0.6646900177002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes City' limit 1
loadtime:0.66472887992859 / seconds
Query Executed:select id FROM `ia` where city='Barnes City' && SIC_code='5531'DB:business_master_new
loadtime:0.67074203491211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnum' limit 1
loadtime:0.67078804969788 / seconds
Query Executed:select id FROM `ia` where city='Barnum' && SIC_code='5531'DB:business_master_new
loadtime:0.67698097229004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batavia' limit 1
loadtime:0.67702794075012 / seconds
Query Executed:select id FROM `ia` where city='Batavia' && SIC_code='5531'DB:business_master_new
loadtime:0.67789387702942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.67794990539551 / seconds
Query Executed:select id FROM `ia` where city='Battle Creek' && SIC_code='5531'DB:business_master_new
loadtime:0.67856097221375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baxter' limit 1
loadtime:0.67866587638855 / seconds
Query Executed:select id FROM `ia` where city='Baxter' && SIC_code='5531'DB:business_master_new
loadtime:0.67952704429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.67958283424377 / seconds
Query Executed:select id FROM `ia` where city='Bayard' && SIC_code='5531'DB:business_master_new
loadtime:0.69729590415955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon' limit 1
loadtime:0.69735097885132 / seconds
Query Executed:select id FROM `ia` where city='Beacon' && SIC_code='5531'DB:business_master_new
loadtime:0.70316195487976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaconsfield' limit 1
loadtime:0.70319700241089 / seconds
Query Executed:select id FROM `ia` where city='Beaconsfield' && SIC_code='5531'DB:business_master_new
loadtime:0.70345187187195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaman' limit 1
loadtime:0.70349287986755 / seconds
Query Executed:select id FROM `ia` where city='Beaman' && SIC_code='5531'DB:business_master_new
loadtime:0.70929193496704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.70934200286865 / seconds
Query Executed:select id FROM `ia` where city='Beaver' && SIC_code='5531'DB:business_master_new
loadtime:0.71174097061157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.71178984642029 / seconds
Query Executed:select id FROM `ia` where city='Bedford' && SIC_code='5531'DB:business_master_new
loadtime:0.71311497688293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Plaine' limit 1
loadtime:0.71317291259766 / seconds
Query Executed:select id FROM `ia` where city='Belle Plaine' && SIC_code='5531'DB:business_master_new
loadtime:0.71427798271179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.71438097953796 / seconds
Query Executed:select id FROM `ia` where city='Bellevue' && SIC_code='5531'DB:business_master_new
loadtime:0.71509289741516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmond' limit 1
loadtime:0.71512889862061 / seconds
Query Executed:select id FROM `ia` where city='Belmond' && SIC_code='5531'DB:business_master_new
loadtime:0.71625399589539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.71635699272156 / seconds
Query Executed:select id FROM `ia` where city='Bennett' && SIC_code='5531'DB:business_master_new
loadtime:0.72598695755005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.72603702545166 / seconds
Query Executed:select id FROM `ia` where city='Benton' && SIC_code='5531'DB:business_master_new
loadtime:0.72712993621826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernard' limit 1
loadtime:0.72718191146851 / seconds
Query Executed:select id FROM `ia` where city='Bernard' && SIC_code='5531'DB:business_master_new
loadtime:0.72776985168457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berwick' limit 1
loadtime:0.72781085968018 / seconds
Query Executed:select id FROM `ia` where city='Berwick' && SIC_code='5531'DB:business_master_new
loadtime:0.72907996177673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bettendorf' limit 1
loadtime:0.72911596298218 / seconds
Query Executed:select id FROM `ia` where city='Bettendorf' && SIC_code='5531'DB:business_master_new
loadtime:0.73179197311401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bevington' limit 1
loadtime:0.73184990882874 / seconds
Query Executed:select id FROM `ia` where city='Bevington' && SIC_code='5531'DB:business_master_new
loadtime:0.73348903656006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.73353886604309 / seconds
Query Executed:select id FROM `ia` where city='Big Rock' && SIC_code='5531'DB:business_master_new
loadtime:0.73380088806152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.73382806777954 / seconds
Query Executed:select id FROM `ia` where city='Birmingham' && SIC_code='5531'DB:business_master_new
loadtime:0.74262285232544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairsburg' limit 1
loadtime:0.7426700592041 / seconds
Query Executed:select id FROM `ia` where city='Blairsburg' && SIC_code='5531'DB:business_master_new
loadtime:0.74949598312378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairstown' limit 1
loadtime:0.74954605102539 / seconds
Query Executed:select id FROM `ia` where city='Blairstown' && SIC_code='5531'DB:business_master_new
loadtime:0.75082802772522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakesburg' limit 1
loadtime:0.75087094306946 / seconds
Query Executed:select id FROM `ia` where city='Blakesburg' && SIC_code='5531'DB:business_master_new
loadtime:0.762531042099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.76258897781372 / seconds
Query Executed:select id FROM `ia` where city='Blanchard' && SIC_code='5531'DB:business_master_new
loadtime:0.76595783233643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blencoe' limit 1
loadtime:0.76599884033203 / seconds
Query Executed:select id FROM `ia` where city='Blencoe' && SIC_code='5531'DB:business_master_new
loadtime:0.77150106430054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blockton' limit 1
loadtime:0.77155494689941 / seconds
Query Executed:select id FROM `ia` where city='Blockton' && SIC_code='5531'DB:business_master_new
loadtime:0.77717185020447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.77722501754761 / seconds
Query Executed:select id FROM `ia` where city='Bloomfield' && SIC_code='5531'DB:business_master_new
loadtime:0.77884387969971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.77889490127563 / seconds
Query Executed:select id FROM `ia` where city='Blue Grass' && SIC_code='5531'DB:business_master_new
loadtime:0.77977585792542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bode' limit 1
loadtime:0.7798318862915 / seconds
Query Executed:select id FROM `ia` where city='Bode' && SIC_code='5531'DB:business_master_new
loadtime:0.80955696105957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonaparte' limit 1
loadtime:0.8095920085907 / seconds
Query Executed:select id FROM `ia` where city='Bonaparte' && SIC_code='5531'DB:business_master_new
loadtime:0.82303595542908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondurant' limit 1
loadtime:0.82309293746948 / seconds
Query Executed:select id FROM `ia` where city='Bondurant' && SIC_code='5531'DB:business_master_new
loadtime:0.82369899749756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.82373785972595 / seconds
Query Executed:select id FROM `ia` where city='Boone' && SIC_code='5531'DB:business_master_new
loadtime:0.82571792602539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booneville' limit 1
loadtime:0.82577705383301 / seconds
Query Executed:select id FROM `ia` where city='Booneville' && SIC_code='5531'DB:business_master_new
loadtime:0.82769989967346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouton' limit 1
loadtime:0.82773685455322 / seconds
Query Executed:select id FROM `ia` where city='Bouton' && SIC_code='5531'DB:business_master_new
loadtime:0.83403897285461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxholm' limit 1
loadtime:0.83409094810486 / seconds
Query Executed:select id FROM `ia` where city='Boxholm' && SIC_code='5531'DB:business_master_new
loadtime:0.83799004554749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyden' limit 1
loadtime:0.83802485466003 / seconds
Query Executed:select id FROM `ia` where city='Boyden' && SIC_code='5531'DB:business_master_new
loadtime:0.83858394622803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braddyville' limit 1
loadtime:0.83863496780396 / seconds
Query Executed:select id FROM `ia` where city='Braddyville' && SIC_code='5531'DB:business_master_new
loadtime:0.84327483177185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.84331583976746 / seconds
Query Executed:select id FROM `ia` where city='Bradford' && SIC_code='5531'DB:business_master_new
loadtime:0.84537196159363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradgate' limit 1
loadtime:0.84540605545044 / seconds
Query Executed:select id FROM `ia` where city='Bradgate' && SIC_code='5531'DB:business_master_new
loadtime:0.84849405288696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.84853100776672 / seconds
Query Executed:select id FROM `ia` where city='Brandon' && SIC_code='5531'DB:business_master_new
loadtime:0.85415291786194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brayton' limit 1
loadtime:0.85419106483459 / seconds
Query Executed:select id FROM `ia` where city='Brayton' && SIC_code='5531'DB:business_master_new
loadtime:0.85906505584717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breda' limit 1
loadtime:0.85910487174988 / seconds
Query Executed:select id FROM `ia` where city='Breda' && SIC_code='5531'DB:business_master_new
loadtime:0.85966801643372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.85970783233643 / seconds
Query Executed:select id FROM `ia` where city='Bridgewater' && SIC_code='5531'DB:business_master_new
loadtime:0.86673283576965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.86678385734558 / seconds
Query Executed:select id FROM `ia` where city='Brighton' && SIC_code='5531'DB:business_master_new
loadtime:0.86738896369934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.86744093894958 / seconds
Query Executed:select id FROM `ia` where city='Bristow' && SIC_code='5531'DB:business_master_new
loadtime:0.87318301200867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britt' limit 1
loadtime:0.87323904037476 / seconds
Query Executed:select id FROM `ia` where city='Britt' && SIC_code='5531'DB:business_master_new
loadtime:0.87482404708862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.87488198280334 / seconds
Query Executed:select id FROM `ia` where city='Bronson' && SIC_code='5531'DB:business_master_new
loadtime:0.87911701202393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.87916803359985 / seconds
Query Executed:select id FROM `ia` where city='Brooklyn' && SIC_code='5531'DB:business_master_new
loadtime:0.88020586967468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunsville' limit 1
loadtime:0.88024997711182 / seconds
Query Executed:select id FROM `ia` where city='Brunsville' && SIC_code='5531'DB:business_master_new
loadtime:0.88259696960449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.8826630115509 / seconds
Query Executed:select id FROM `ia` where city='Bryant' && SIC_code='5531'DB:business_master_new
loadtime:0.88762497901917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.88767290115356 / seconds
Query Executed:select id FROM `ia` where city='Buckeye' && SIC_code='5531'DB:business_master_new
loadtime:0.88818383216858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:0.88821887969971 / seconds
Query Executed:select id FROM `ia` where city='Buckingham' && SIC_code='5531'DB:business_master_new
loadtime:0.89174103736877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.89179491996765 / seconds
Query Executed:select id FROM `ia` where city='Buffalo' && SIC_code='5531'DB:business_master_new
loadtime:0.90075206756592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Center' limit 1
loadtime:0.90080189704895 / seconds
Query Executed:select id FROM `ia` where city='Buffalo Center' && SIC_code='5531'DB:business_master_new
loadtime:0.90211606025696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.90217590332031 / seconds
Query Executed:select id FROM `ia` where city='Burlington' && SIC_code='5531'DB:business_master_new
loadtime:0.9058039188385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnside' limit 1
loadtime:0.90585994720459 / seconds
Query Executed:select id FROM `ia` where city='Burnside' && SIC_code='5531'DB:business_master_new
loadtime:0.9073429107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:0.90742683410645 / seconds
Query Executed:select id FROM `ia` where city='Burt' && SIC_code='5531'DB:business_master_new
loadtime:0.92172384262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bussey' limit 1
loadtime:0.92177295684814 / seconds
Query Executed:select id FROM `ia` where city='Bussey' && SIC_code='5531'DB:business_master_new
loadtime:0.9278290271759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calamus' limit 1
loadtime:0.92788004875183 / seconds
Query Executed:select id FROM `ia` where city='Calamus' && SIC_code='5531'DB:business_master_new
loadtime:0.94281983375549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callender' limit 1
loadtime:0.9428608417511 / seconds
Query Executed:select id FROM `ia` where city='Callender' && SIC_code='5531'DB:business_master_new
loadtime:0.9569718837738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calmar' limit 1
loadtime:0.95702600479126 / seconds
Query Executed:select id FROM `ia` where city='Calmar' && SIC_code='5531'DB:business_master_new
loadtime:0.95764803886414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.95768690109253 / seconds
Query Executed:select id FROM `ia` where city='Calumet' && SIC_code='5531'DB:business_master_new
loadtime:0.9615650177002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camanche' limit 1
loadtime:0.96162295341492 / seconds
Query Executed:select id FROM `ia` where city='Camanche' && SIC_code='5531'DB:business_master_new
loadtime:0.96233797073364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.96238493919373 / seconds
Query Executed:select id FROM `ia` where city='Cambridge' && SIC_code='5531'DB:business_master_new
loadtime:0.97653198242188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cantril' limit 1
loadtime:0.97656893730164 / seconds
Query Executed:select id FROM `ia` where city='Cantril' && SIC_code='5531'DB:business_master_new
loadtime:0.98435997962952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbon' limit 1
loadtime:0.98441195487976 / seconds
Query Executed:select id FROM `ia` where city='Carbon' && SIC_code='5531'DB:business_master_new
loadtime:0.98530793190002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.98535203933716 / seconds
Query Executed:select id FROM `ia` where city='Carlisle' && SIC_code='5531'DB:business_master_new
loadtime:0.98627185821533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carnarvon' limit 1
loadtime:0.9863109588623 / seconds
Query Executed:select id FROM `ia` where city='Carnarvon' && SIC_code='5531'DB:business_master_new
loadtime:0.9871678352356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.98720598220825 / seconds
Query Executed:select id FROM `ia` where city='Carpenter' && SIC_code='5531'DB:business_master_new
loadtime:0.98883700370789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.98887705802917 / seconds
Query Executed:select id FROM `ia` where city='Carroll' && SIC_code='5531'DB:business_master_new
loadtime:0.99082684516907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.99087285995483 / seconds
Query Executed:select id FROM `ia` where city='Carson' && SIC_code='5531'DB:business_master_new
loadtime:0.99142694473267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter Lake' limit 1
loadtime:0.99145197868347 / seconds
Query Executed:select id FROM `ia` where city='Carter Lake' && SIC_code='5531'DB:business_master_new
loadtime:0.99280500411987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.99285006523132 / seconds
Query Executed:select id FROM `ia` where city='Cascade' && SIC_code='5531'DB:business_master_new
loadtime:0.99376201629639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casey' limit 1
loadtime:0.9938018321991 / seconds
Query Executed:select id FROM `ia` where city='Casey' && SIC_code='5531'DB:business_master_new
loadtime:0.99462604522705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:0.99466705322266 / seconds
Query Executed:select id FROM `ia` where city='Castalia' && SIC_code='5531'DB:business_master_new
loadtime:1.0027689933777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castana' limit 1
loadtime:1.0028109550476 / seconds
Query Executed:select id FROM `ia` where city='Castana' && SIC_code='5531'DB:business_master_new
loadtime:1.0135099887848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:1.0135629177094 / seconds
Query Executed:select id FROM `ia` where city='Cedar' && SIC_code='5531'DB:business_master_new
loadtime:1.016902923584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:1.0169439315796 / seconds
Query Executed:select id FROM `ia` where city='Cedar Falls' && SIC_code='5531'DB:business_master_new
loadtime:1.0189578533173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Rapids' limit 1
loadtime:1.0190088748932 / seconds
Query Executed:select id FROM `ia` where city='Cedar Rapids' && SIC_code='5531'DB:business_master_new
loadtime:1.1872758865356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Junction' limit 1
loadtime:1.1874029636383 / seconds
Query Executed:select id FROM `ia` where city='Center Junction' && SIC_code='5531'DB:business_master_new
loadtime:1.1936988830566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Point' limit 1
loadtime:1.1937620639801 / seconds
Query Executed:select id FROM `ia` where city='Center Point' && SIC_code='5531'DB:business_master_new
loadtime:1.1945090293884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:1.1945600509644 / seconds
Query Executed:select id FROM `ia` where city='Centerville' && SIC_code='5531'DB:business_master_new
loadtime:1.1953699588776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:1.1954209804535 / seconds
Query Executed:select id FROM `ia` where city='Central City' && SIC_code='5531'DB:business_master_new
loadtime:1.1960718631744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:1.1961140632629 / seconds
Query Executed:select id FROM `ia` where city='Chapin' && SIC_code='5531'DB:business_master_new
loadtime:1.1979558467865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chariton' limit 1
loadtime:1.1979930400848 / seconds
Query Executed:select id FROM `ia` where city='Chariton' && SIC_code='5531'DB:business_master_new
loadtime:1.1987268924713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:1.1987788677216 / seconds
Query Executed:select id FROM `ia` where city='Charles City' && SIC_code='5531'DB:business_master_new
loadtime:1.1995809078217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:1.1996459960938 / seconds
Query Executed:select id FROM `ia` where city='Charlotte' && SIC_code='5531'DB:business_master_new
loadtime:1.2064089775085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charter Oak' limit 1
loadtime:1.2064549922943 / seconds
Query Executed:select id FROM `ia` where city='Charter Oak' && SIC_code='5531'DB:business_master_new
loadtime:1.2070820331573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:1.2071239948273 / seconds
Query Executed:select id FROM `ia` where city='Chatsworth' && SIC_code='5531'DB:business_master_new
loadtime:1.2073838710785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:1.2074220180511 / seconds
Query Executed:select id FROM `ia` where city='Chelsea' && SIC_code='5531'DB:business_master_new
loadtime:1.2151038646698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:1.2151470184326 / seconds
Query Executed:select id FROM `ia` where city='Cherokee' && SIC_code='5531'DB:business_master_new
loadtime:1.2159349918365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.2159910202026 / seconds
Query Executed:select id FROM `ia` where city='Chester' && SIC_code='5531'DB:business_master_new
loadtime:1.2180309295654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chillicothe' limit 1
loadtime:1.2180778980255 / seconds
Query Executed:select id FROM `ia` where city='Chillicothe' && SIC_code='5531'DB:business_master_new
loadtime:1.2191820144653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churdan' limit 1
loadtime:1.2192258834839 / seconds
Query Executed:select id FROM `ia` where city='Churdan' && SIC_code='5531'DB:business_master_new
loadtime:1.2316238880157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cincinnati' limit 1
loadtime:1.2316608428955 / seconds
Query Executed:select id FROM `ia` where city='Cincinnati' && SIC_code='5531'DB:business_master_new
loadtime:1.2353930473328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:1.2354428768158 / seconds
Query Executed:select id FROM `ia` where city='Clare' && SIC_code='5531'DB:business_master_new
loadtime:1.2425799369812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarence' limit 1
loadtime:1.2426419258118 / seconds
Query Executed:select id FROM `ia` where city='Clarence' && SIC_code='5531'DB:business_master_new
loadtime:1.2432310581207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarinda' limit 1
loadtime:1.2432708740234 / seconds
Query Executed:select id FROM `ia` where city='Clarinda' && SIC_code='5531'DB:business_master_new
loadtime:1.2440478801727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarion' limit 1
loadtime:1.2441010475159 / seconds
Query Executed:select id FROM `ia` where city='Clarion' && SIC_code='5531'DB:business_master_new
loadtime:1.2448229789734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:1.2448759078979 / seconds
Query Executed:select id FROM `ia` where city='Clarksville' && SIC_code='5531'DB:business_master_new
loadtime:1.2454760074615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:1.2455170154572 / seconds
Query Executed:select id FROM `ia` where city='Clear Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.2463510036469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:1.2463910579681 / seconds
Query Executed:select id FROM `ia` where city='Clearfield' && SIC_code='5531'DB:business_master_new
loadtime:1.2556998729706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleghorn' limit 1
loadtime:1.255744934082 / seconds
Query Executed:select id FROM `ia` where city='Cleghorn' && SIC_code='5531'DB:business_master_new
loadtime:1.260792016983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemons' limit 1
loadtime:1.2608380317688 / seconds
Query Executed:select id FROM `ia` where city='Clemons' && SIC_code='5531'DB:business_master_new
loadtime:1.2656829357147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clermont' limit 1
loadtime:1.26571393013 / seconds
Query Executed:select id FROM `ia` where city='Clermont' && SIC_code='5531'DB:business_master_new
loadtime:1.266284942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climbing Hill' limit 1
loadtime:1.2663350105286 / seconds
Query Executed:select id FROM `ia` where city='Climbing Hill' && SIC_code='5531'DB:business_master_new
loadtime:1.2672438621521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:1.2672879695892 / seconds
Query Executed:select id FROM `ia` where city='Clinton' && SIC_code='5531'DB:business_master_new
loadtime:1.2683720588684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:1.2684168815613 / seconds
Query Executed:select id FROM `ia` where city='Clio' && SIC_code='5531'DB:business_master_new
loadtime:1.2696499824524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clive' limit 1
loadtime:1.2696928977966 / seconds
Query Executed:select id FROM `ia` where city='Clive' && SIC_code='5531'DB:business_master_new
loadtime:1.2706160545349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clutier' limit 1
loadtime:1.2706599235535 / seconds
Query Executed:select id FROM `ia` where city='Clutier' && SIC_code='5531'DB:business_master_new
loadtime:1.278678894043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coggon' limit 1
loadtime:1.2787230014801 / seconds
Query Executed:select id FROM `ia` where city='Coggon' && SIC_code='5531'DB:business_master_new
loadtime:1.2793109416962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coin' limit 1
loadtime:1.2793509960175 / seconds
Query Executed:select id FROM `ia` where city='Coin' && SIC_code='5531'DB:business_master_new
loadtime:1.2825169563293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colesburg' limit 1
loadtime:1.2825479507446 / seconds
Query Executed:select id FROM `ia` where city='Colesburg' && SIC_code='5531'DB:business_master_new
loadtime:1.2894039154053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:1.2894599437714 / seconds
Query Executed:select id FROM `ia` where city='Colfax' && SIC_code='5531'DB:business_master_new
loadtime:1.2901229858398 / seconds
Query loaded from cache:select * from geodata_geocity where city='College Springs' limit 1
loadtime:1.2901699542999 / seconds
Query Executed:select id FROM `ia` where city='College Springs' && SIC_code='5531'DB:business_master_new
loadtime:1.2921440601349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:1.292181968689 / seconds
Query Executed:select id FROM `ia` where city='Collins' && SIC_code='5531'DB:business_master_new
loadtime:1.2989828586578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colo' limit 1
loadtime:1.2990279197693 / seconds
Query Executed:select id FROM `ia` where city='Colo' && SIC_code='5531'DB:business_master_new
loadtime:1.2995989322662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:1.2996518611908 / seconds
Query Executed:select id FROM `ia` where city='Columbia' && SIC_code='5531'DB:business_master_new
loadtime:1.3016819953918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus City' limit 1
loadtime:1.3017308712006 / seconds
Query Executed:select id FROM `ia` where city='Columbus City' && SIC_code='5531'DB:business_master_new
loadtime:1.3043818473816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Jct' limit 1
loadtime:1.3044168949127 / seconds
Query Executed:select id FROM `ia` where city='Columbus Jct' && SIC_code='5531'DB:business_master_new
loadtime:1.3047330379486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Junction' limit 1
loadtime:1.3047749996185 / seconds
Query Executed:select id FROM `ia` where city='Columbus Junction' && SIC_code='5531'DB:business_master_new
loadtime:1.3054280281067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colwell' limit 1
loadtime:1.3054809570312 / seconds
Query Executed:select id FROM `ia` where city='Colwell' && SIC_code='5531'DB:business_master_new
loadtime:1.306156873703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conesville' limit 1
loadtime:1.3062539100647 / seconds
Query Executed:select id FROM `ia` where city='Conesville' && SIC_code='5531'DB:business_master_new
loadtime:1.310122013092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrad' limit 1
loadtime:1.3101799488068 / seconds
Query Executed:select id FROM `ia` where city='Conrad' && SIC_code='5531'DB:business_master_new
loadtime:1.3107960224152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conroy' limit 1
loadtime:1.3108358383179 / seconds
Query Executed:select id FROM `ia` where city='Conroy' && SIC_code='5531'DB:business_master_new
loadtime:1.3125309944153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Rapids' limit 1
loadtime:1.3125860691071 / seconds
Query Executed:select id FROM `ia` where city='Coon Rapids' && SIC_code='5531'DB:business_master_new
loadtime:1.3132388591766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooper' limit 1
loadtime:1.313295841217 / seconds
Query Executed:select id FROM `ia` where city='Cooper' && SIC_code='5531'DB:business_master_new
loadtime:1.3141870498657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coralville' limit 1
loadtime:1.3142168521881 / seconds
Query Executed:select id FROM `ia` where city='Coralville' && SIC_code='5531'DB:business_master_new
loadtime:1.3153228759766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corning' limit 1
loadtime:1.3153698444366 / seconds
Query Executed:select id FROM `ia` where city='Corning' && SIC_code='5531'DB:business_master_new
loadtime:1.3160600662231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Correctionville' limit 1
loadtime:1.3161058425903 / seconds
Query Executed:select id FROM `ia` where city='Correctionville' && SIC_code='5531'DB:business_master_new
loadtime:1.31667304039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corwith' limit 1
loadtime:1.3167128562927 / seconds
Query Executed:select id FROM `ia` where city='Corwith' && SIC_code='5531'DB:business_master_new
loadtime:1.3230440616608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corydon' limit 1
loadtime:1.3230838775635 / seconds
Query Executed:select id FROM `ia` where city='Corydon' && SIC_code='5531'DB:business_master_new
loadtime:1.3237538337708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coulter' limit 1
loadtime:1.3238019943237 / seconds
Query Executed:select id FROM `ia` where city='Coulter' && SIC_code='5531'DB:business_master_new
loadtime:1.3271808624268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council Bluffs' limit 1
loadtime:1.3272068500519 / seconds
Query Executed:select id FROM `ia` where city='Council Bluffs' && SIC_code='5531'DB:business_master_new
loadtime:1.3286828994751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawfordsville' limit 1
loadtime:1.3287389278412 / seconds
Query Executed:select id FROM `ia` where city='Crawfordsville' && SIC_code='5531'DB:business_master_new
loadtime:1.3356649875641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crescent' limit 1
loadtime:1.3357019424438 / seconds
Query Executed:select id FROM `ia` where city='Crescent' && SIC_code='5531'DB:business_master_new
loadtime:1.3362579345703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresco' limit 1
loadtime:1.3362939357758 / seconds
Query Executed:select id FROM `ia` where city='Cresco' && SIC_code='5531'DB:business_master_new
loadtime:1.337005853653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:1.3370518684387 / seconds
Query Executed:select id FROM `ia` where city='Creston' && SIC_code='5531'DB:business_master_new
loadtime:1.3378319740295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:1.337877035141 / seconds
Query Executed:select id FROM `ia` where city='Cromwell' && SIC_code='5531'DB:business_master_new
loadtime:1.339292049408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Lake' limit 1
loadtime:1.3393440246582 / seconds
Query Executed:select id FROM `ia` where city='Crystal Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.3409018516541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:1.340961933136 / seconds
Query Executed:select id FROM `ia` where city='Cumberland' && SIC_code='5531'DB:business_master_new
loadtime:1.352411031723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumming' limit 1
loadtime:1.3524458408356 / seconds
Query Executed:select id FROM `ia` where city='Cumming' && SIC_code='5531'DB:business_master_new
loadtime:1.353040933609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curlew' limit 1
loadtime:1.3530859947205 / seconds
Query Executed:select id FROM `ia` where city='Curlew' && SIC_code='5531'DB:business_master_new
loadtime:1.3548049926758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:1.3548419475555 / seconds
Query Executed:select id FROM `ia` where city='Cushing' && SIC_code='5531'DB:business_master_new
loadtime:1.3582019805908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cylinder' limit 1
loadtime:1.3582539558411 / seconds
Query Executed:select id FROM `ia` where city='Cylinder' && SIC_code='5531'DB:business_master_new
loadtime:1.3635818958282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota City' limit 1
loadtime:1.3636448383331 / seconds
Query Executed:select id FROM `ia` where city='Dakota City' && SIC_code='5531'DB:business_master_new
loadtime:1.3702490329742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:1.3702919483185 / seconds
Query Executed:select id FROM `ia` where city='Dallas' && SIC_code='5531'DB:business_master_new
loadtime:1.3735899925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas Center' limit 1
loadtime:1.3736438751221 / seconds
Query Executed:select id FROM `ia` where city='Dallas Center' && SIC_code='5531'DB:business_master_new
loadtime:1.3742249011993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:1.3742589950562 / seconds
Query Executed:select id FROM `ia` where city='Dana' && SIC_code='5531'DB:business_master_new
loadtime:1.3750128746033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:1.3750488758087 / seconds
Query Executed:select id FROM `ia` where city='Danbury' && SIC_code='5531'DB:business_master_new
loadtime:1.3756220340729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:1.3756558895111 / seconds
Query Executed:select id FROM `ia` where city='Danville' && SIC_code='5531'DB:business_master_new
loadtime:1.3762140274048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:1.376247882843 / seconds
Query Executed:select id FROM `ia` where city='Davenport' && SIC_code='5531'DB:business_master_new
loadtime:1.3787798881531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis City' limit 1
loadtime:1.3788368701935 / seconds
Query Executed:select id FROM `ia` where city='Davis City' && SIC_code='5531'DB:business_master_new
loadtime:1.3812608718872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawson' limit 1
loadtime:1.3813028335571 / seconds
Query Executed:select id FROM `ia` where city='Dawson' && SIC_code='5531'DB:business_master_new
loadtime:1.3824388980865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:1.3824758529663 / seconds
Query Executed:select id FROM `ia` where city='Dayton' && SIC_code='5531'DB:business_master_new
loadtime:1.3830809593201 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:1.3831160068512 / seconds
Query Executed:select id FROM `ia` where city='De Soto' && SIC_code='5531'DB:business_master_new
loadtime:1.3886740207672 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Witt' limit 1
loadtime:1.3887989521027 / seconds
Query Executed:select id FROM `ia` where city='De Witt' && SIC_code='5531'DB:business_master_new
loadtime:1.3904328346252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:1.3905470371246 / seconds
Query Executed:select id FROM `ia` where city='Decatur' && SIC_code='5531'DB:business_master_new
loadtime:1.3954529762268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decorah' limit 1
loadtime:1.3955240249634 / seconds
Query Executed:select id FROM `ia` where city='Decorah' && SIC_code='5531'DB:business_master_new
loadtime:1.3979389667511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:1.3980560302734 / seconds
Query Executed:select id FROM `ia` where city='Dedham' && SIC_code='5531'DB:business_master_new
loadtime:1.4037790298462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:1.4038209915161 / seconds
Query Executed:select id FROM `ia` where city='Deep River' && SIC_code='5531'DB:business_master_new
loadtime:1.4106979370117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Defiance' limit 1
loadtime:1.4107458591461 / seconds
Query Executed:select id FROM `ia` where city='Defiance' && SIC_code='5531'DB:business_master_new
loadtime:1.4178009033203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:1.4178359508514 / seconds
Query Executed:select id FROM `ia` where city='Delaware' && SIC_code='5531'DB:business_master_new
loadtime:1.4187519550323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delhi' limit 1
loadtime:1.4187939167023 / seconds
Query Executed:select id FROM `ia` where city='Delhi' && SIC_code='5531'DB:business_master_new
loadtime:1.4194209575653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmar' limit 1
loadtime:1.4194798469543 / seconds
Query Executed:select id FROM `ia` where city='Delmar' && SIC_code='5531'DB:business_master_new
loadtime:1.427218914032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deloit' limit 1
loadtime:1.4272689819336 / seconds
Query Executed:select id FROM `ia` where city='Deloit' && SIC_code='5531'DB:business_master_new
loadtime:1.4324929714203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:1.4325289726257 / seconds
Query Executed:select id FROM `ia` where city='Delta' && SIC_code='5531'DB:business_master_new
loadtime:1.4342470169067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denison' limit 1
loadtime:1.4342958927155 / seconds
Query Executed:select id FROM `ia` where city='Denison' && SIC_code='5531'DB:business_master_new
loadtime:1.4351308345795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:1.4351909160614 / seconds
Query Executed:select id FROM `ia` where city='Denmark' && SIC_code='5531'DB:business_master_new
loadtime:1.4375760555267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:1.4376440048218 / seconds
Query Executed:select id FROM `ia` where city='Denver' && SIC_code='5531'DB:business_master_new
loadtime:1.4382538795471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:1.4383070468903 / seconds
Query Executed:select id FROM `ia` where city='Derby' && SIC_code='5531'DB:business_master_new
loadtime:1.4397389888763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:1.439789056778 / seconds
Query Executed:select id FROM `ia` where city='Des Moines' && SIC_code='5531'DB:business_master_new
loadtime:1.4468019008636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewar' limit 1
loadtime:1.4468939304352 / seconds
Query Executed:select id FROM `ia` where city='Dewar' && SIC_code='5531'DB:business_master_new
loadtime:1.4477980136871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:1.447851896286 / seconds
Query Executed:select id FROM `ia` where city='Dexter' && SIC_code='5531'DB:business_master_new
loadtime:1.4557659626007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diagonal' limit 1
loadtime:1.4558088779449 / seconds
Query Executed:select id FROM `ia` where city='Diagonal' && SIC_code='5531'DB:business_master_new
loadtime:1.4602990150452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickens' limit 1
loadtime:1.4603579044342 / seconds
Query Executed:select id FROM `ia` where city='Dickens' && SIC_code='5531'DB:business_master_new
loadtime:1.4660558700562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dike' limit 1
loadtime:1.4660849571228 / seconds
Query Executed:select id FROM `ia` where city='Dike' && SIC_code='5531'DB:business_master_new
loadtime:1.4730799198151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:1.473119020462 / seconds
Query Executed:select id FROM `ia` where city='Dixon' && SIC_code='5531'DB:business_master_new
loadtime:1.4794008731842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolliver' limit 1
loadtime:1.4794380664825 / seconds
Query Executed:select id FROM `ia` where city='Dolliver' && SIC_code='5531'DB:business_master_new
loadtime:1.4803400039673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donahue' limit 1
loadtime:1.4803810119629 / seconds
Query Executed:select id FROM `ia` where city='Donahue' && SIC_code='5531'DB:business_master_new
loadtime:1.4845509529114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donnellson' limit 1
loadtime:1.4845979213715 / seconds
Query Executed:select id FROM `ia` where city='Donnellson' && SIC_code='5531'DB:business_master_new
loadtime:1.4852819442749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doon' limit 1
loadtime:1.4853408336639 / seconds
Query Executed:select id FROM `ia` where city='Doon' && SIC_code='5531'DB:business_master_new
loadtime:1.493145942688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:1.4931950569153 / seconds
Query Executed:select id FROM `ia` where city='Dorchester' && SIC_code='5531'DB:business_master_new
loadtime:1.4977169036865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douds' limit 1
loadtime:1.4977478981018 / seconds
Query Executed:select id FROM `ia` where city='Douds' && SIC_code='5531'DB:business_master_new
loadtime:1.5013408660889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dougherty' limit 1
loadtime:1.5013790130615 / seconds
Query Executed:select id FROM `ia` where city='Dougherty' && SIC_code='5531'DB:business_master_new
loadtime:1.5045640468597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dow City' limit 1
loadtime:1.5046138763428 / seconds
Query Executed:select id FROM `ia` where city='Dow City' && SIC_code='5531'DB:business_master_new
loadtime:1.5120558738708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dows' limit 1
loadtime:1.5120940208435 / seconds
Query Executed:select id FROM `ia` where city='Dows' && SIC_code='5531'DB:business_master_new
loadtime:1.5126869678497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakesville' limit 1
loadtime:1.5127260684967 / seconds
Query Executed:select id FROM `ia` where city='Drakesville' && SIC_code='5531'DB:business_master_new
loadtime:1.5153908729553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dubuque' limit 1
loadtime:1.5154259204865 / seconds
Query Executed:select id FROM `ia` where city='Dubuque' && SIC_code='5531'DB:business_master_new
loadtime:1.5170938968658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:1.5171608924866 / seconds
Query Executed:select id FROM `ia` where city='Dumont' && SIC_code='5531'DB:business_master_new
loadtime:1.5263209342957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncombe' limit 1
loadtime:1.5263750553131 / seconds
Query Executed:select id FROM `ia` where city='Duncombe' && SIC_code='5531'DB:business_master_new
loadtime:1.5328869819641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:1.5329279899597 / seconds
Query Executed:select id FROM `ia` where city='Dundee' && SIC_code='5531'DB:business_master_new
loadtime:1.536474943161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunkerton' limit 1
loadtime:1.5365219116211 / seconds
Query Executed:select id FROM `ia` where city='Dunkerton' && SIC_code='5531'DB:business_master_new
loadtime:1.5371668338776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunlap' limit 1
loadtime:1.5372149944305 / seconds
Query Executed:select id FROM `ia` where city='Dunlap' && SIC_code='5531'DB:business_master_new
loadtime:1.5378408432007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:1.5378909111023 / seconds
Query Executed:select id FROM `ia` where city='Durango' && SIC_code='5531'DB:business_master_new
loadtime:1.5408470630646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:1.5409288406372 / seconds
Query Executed:select id FROM `ia` where city='Durant' && SIC_code='5531'DB:business_master_new
loadtime:1.5420229434967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyersville' limit 1
loadtime:1.5420680046082 / seconds
Query Executed:select id FROM `ia` where city='Dyersville' && SIC_code='5531'DB:business_master_new
loadtime:1.5432109832764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dysart' limit 1
loadtime:1.5432798862457 / seconds
Query Executed:select id FROM `ia` where city='Dysart' && SIC_code='5531'DB:business_master_new
loadtime:1.5441770553589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Grove' limit 1
loadtime:1.5442519187927 / seconds
Query Executed:select id FROM `ia` where city='Eagle Grove' && SIC_code='5531'DB:business_master_new
loadtime:1.545361995697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlham' limit 1
loadtime:1.5453939437866 / seconds
Query Executed:select id FROM `ia` where city='Earlham' && SIC_code='5531'DB:business_master_new
loadtime:1.5463540554047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earling' limit 1
loadtime:1.5464220046997 / seconds
Query Executed:select id FROM `ia` where city='Earling' && SIC_code='5531'DB:business_master_new
loadtime:1.5472509860992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlville' limit 1
loadtime:1.5473098754883 / seconds
Query Executed:select id FROM `ia` where city='Earlville' && SIC_code='5531'DB:business_master_new
loadtime:1.5482919216156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early' limit 1
loadtime:1.5483429431915 / seconds
Query Executed:select id FROM `ia` where city='Early' && SIC_code='5531'DB:business_master_new
loadtime:1.5491590499878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eddyville' limit 1
loadtime:1.5492160320282 / seconds
Query Executed:select id FROM `ia` where city='Eddyville' && SIC_code='5531'DB:business_master_new
loadtime:1.5506360530853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:1.5506749153137 / seconds
Query Executed:select id FROM `ia` where city='Edgewood' && SIC_code='5531'DB:business_master_new
loadtime:1.5520839691162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:1.5521869659424 / seconds
Query Executed:select id FROM `ia` where city='Elberon' && SIC_code='5531'DB:business_master_new
loadtime:1.5557289123535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldon' limit 1
loadtime:1.5557639598846 / seconds
Query Executed:select id FROM `ia` where city='Eldon' && SIC_code='5531'DB:business_master_new
loadtime:1.5563490390778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldora' limit 1
loadtime:1.5564000606537 / seconds
Query Executed:select id FROM `ia` where city='Eldora' && SIC_code='5531'DB:business_master_new
loadtime:1.5570509433746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:1.5570950508118 / seconds
Query Executed:select id FROM `ia` where city='Eldorado' && SIC_code='5531'DB:business_master_new
loadtime:1.5573539733887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldridge' limit 1
loadtime:1.5573918819427 / seconds
Query Executed:select id FROM `ia` where city='Eldridge' && SIC_code='5531'DB:business_master_new
loadtime:1.5580680370331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:1.5581090450287 / seconds
Query Executed:select id FROM `ia` where city='Elgin' && SIC_code='5531'DB:business_master_new
loadtime:1.5586550235748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Horn' limit 1
loadtime:1.5586860179901 / seconds
Query Executed:select id FROM `ia` where city='Elk Horn' && SIC_code='5531'DB:business_master_new
loadtime:1.559250831604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Run Heights' limit 1
loadtime:1.5592858791351 / seconds
Query Executed:select id FROM `ia` where city='Elk Run Heights' && SIC_code='5531'DB:business_master_new
loadtime:1.5595519542694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkader' limit 1
loadtime:1.5595829486847 / seconds
Query Executed:select id FROM `ia` where city='Elkader' && SIC_code='5531'DB:business_master_new
loadtime:1.5602190494537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart' limit 1
loadtime:1.5602610111237 / seconds
Query Executed:select id FROM `ia` where city='Elkhart' && SIC_code='5531'DB:business_master_new
loadtime:1.5661768913269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkport' limit 1
loadtime:1.5662889480591 / seconds
Query Executed:select id FROM `ia` where city='Elkport' && SIC_code='5531'DB:business_master_new
loadtime:1.5685670375824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:1.5686068534851 / seconds
Query Executed:select id FROM `ia` where city='Elliott' && SIC_code='5531'DB:business_master_new
loadtime:1.5760040283203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellston' limit 1
loadtime:1.5760328769684 / seconds
Query Executed:select id FROM `ia` where city='Ellston' && SIC_code='5531'DB:business_master_new
loadtime:1.5791220664978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:1.5791599750519 / seconds
Query Executed:select id FROM `ia` where city='Ellsworth' && SIC_code='5531'DB:business_master_new
loadtime:1.5797128677368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elma' limit 1
loadtime:1.5797538757324 / seconds
Query Executed:select id FROM `ia` where city='Elma' && SIC_code='5531'DB:business_master_new
loadtime:1.5803339481354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:1.5803680419922 / seconds
Query Executed:select id FROM `ia` where city='Elwood' && SIC_code='5531'DB:business_master_new
loadtime:1.5817799568176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ely' limit 1
loadtime:1.5818159580231 / seconds
Query Executed:select id FROM `ia` where city='Ely' && SIC_code='5531'DB:business_master_new
loadtime:1.5823788642883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:1.5824129581451 / seconds
Query Executed:select id FROM `ia` where city='Emerson' && SIC_code='5531'DB:business_master_new
loadtime:1.5829699039459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmetsburg' limit 1
loadtime:1.5830080509186 / seconds
Query Executed:select id FROM `ia` where city='Emmetsburg' && SIC_code='5531'DB:business_master_new
loadtime:1.5837159156799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epworth' limit 1
loadtime:1.5837600231171 / seconds
Query Executed:select id FROM `ia` where city='Epworth' && SIC_code='5531'DB:business_master_new
loadtime:1.5842978954315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:1.5843319892883 / seconds
Query Executed:select id FROM `ia` where city='Essex' && SIC_code='5531'DB:business_master_new
loadtime:1.5849058628082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estherville' limit 1
loadtime:1.5849409103394 / seconds
Query Executed:select id FROM `ia` where city='Estherville' && SIC_code='5531'DB:business_master_new
loadtime:1.5856850147247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansdale' limit 1
loadtime:1.5857238769531 / seconds
Query Executed:select id FROM `ia` where city='Evansdale' && SIC_code='5531'DB:business_master_new
loadtime:1.5863070487976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everly' limit 1
loadtime:1.586345911026 / seconds
Query Executed:select id FROM `ia` where city='Everly' && SIC_code='5531'DB:business_master_new
loadtime:1.5868809223175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exira' limit 1
loadtime:1.5869090557098 / seconds
Query Executed:select id FROM `ia` where city='Exira' && SIC_code='5531'DB:business_master_new
loadtime:1.5874500274658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exline' limit 1
loadtime:1.5874829292297 / seconds
Query Executed:select id FROM `ia` where city='Exline' && SIC_code='5531'DB:business_master_new
loadtime:1.5886189937592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairbank' limit 1
loadtime:1.58864402771 / seconds
Query Executed:select id FROM `ia` where city='Fairbank' && SIC_code='5531'DB:business_master_new
loadtime:1.5891940593719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:1.5892310142517 / seconds
Query Executed:select id FROM `ia` where city='Fairfax' && SIC_code='5531'DB:business_master_new
loadtime:1.5898020267487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.5898368358612 / seconds
Query Executed:select id FROM `ia` where city='Fairfield' && SIC_code='5531'DB:business_master_new
loadtime:1.5907418727875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farley' limit 1
loadtime:1.5907838344574 / seconds
Query Executed:select id FROM `ia` where city='Farley' && SIC_code='5531'DB:business_master_new
loadtime:1.5913460254669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmersburg' limit 1
loadtime:1.591374874115 / seconds
Query Executed:select id FROM `ia` where city='Farmersburg' && SIC_code='5531'DB:business_master_new
loadtime:1.600692987442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:1.6007308959961 / seconds
Query Executed:select id FROM `ia` where city='Farmington' && SIC_code='5531'DB:business_master_new
loadtime:1.6013119220734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnhamville' limit 1
loadtime:1.6013429164886 / seconds
Query Executed:select id FROM `ia` where city='Farnhamville' && SIC_code='5531'DB:business_master_new
loadtime:1.6063499450684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farragut' limit 1
loadtime:1.6063859462738 / seconds
Query Executed:select id FROM `ia` where city='Farragut' && SIC_code='5531'DB:business_master_new
loadtime:1.6103749275208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:1.6104328632355 / seconds
Query Executed:select id FROM `ia` where city='Fayette' && SIC_code='5531'DB:business_master_new
loadtime:1.6110520362854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:1.611093044281 / seconds
Query Executed:select id FROM `ia` where city='Fenton' && SIC_code='5531'DB:business_master_new
loadtime:1.6116800308228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:1.6117038726807 / seconds
Query Executed:select id FROM `ia` where city='Ferguson' && SIC_code='5531'DB:business_master_new
loadtime:1.6120018959045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fertile' limit 1
loadtime:1.6120369434357 / seconds
Query Executed:select id FROM `ia` where city='Fertile' && SIC_code='5531'DB:business_master_new
loadtime:1.6150789260864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Festina' limit 1
loadtime:1.6151180267334 / seconds
Query Executed:select id FROM `ia` where city='Festina' && SIC_code='5531'DB:business_master_new
loadtime:1.6154088973999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floris' limit 1
loadtime:1.6154420375824 / seconds
Query Executed:select id FROM `ia` where city='Floris' && SIC_code='5531'DB:business_master_new
loadtime:1.6162168979645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:1.6162538528442 / seconds
Query Executed:select id FROM `ia` where city='Floyd' && SIC_code='5531'DB:business_master_new
loadtime:1.6168210506439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fonda' limit 1
loadtime:1.6168620586395 / seconds
Query Executed:select id FROM `ia` where city='Fonda' && SIC_code='5531'DB:business_master_new
loadtime:1.6174600124359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontanelle' limit 1
loadtime:1.6175010204315 / seconds
Query Executed:select id FROM `ia` where city='Fontanelle' && SIC_code='5531'DB:business_master_new
loadtime:1.6180899143219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:1.6181399822235 / seconds
Query Executed:select id FROM `ia` where city='Forest City' && SIC_code='5531'DB:business_master_new
loadtime:1.6188349723816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:1.6188819408417 / seconds
Query Executed:select id FROM `ia` where city='Fort Atkinson' && SIC_code='5531'DB:business_master_new
loadtime:1.6194980144501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dodge' limit 1
loadtime:1.6195459365845 / seconds
Query Executed:select id FROM `ia` where city='Fort Dodge' && SIC_code='5531'DB:business_master_new
loadtime:1.6207509040833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Madison' limit 1
loadtime:1.6208138465881 / seconds
Query Executed:select id FROM `ia` where city='Fort Madison' && SIC_code='5531'DB:business_master_new
loadtime:1.6216650009155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:1.6217198371887 / seconds
Query Executed:select id FROM `ia` where city='Fostoria' && SIC_code='5531'DB:business_master_new
loadtime:1.6232359409332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:1.6232900619507 / seconds
Query Executed:select id FROM `ia` where city='Fredericksburg' && SIC_code='5531'DB:business_master_new
loadtime:1.6242320537567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederika' limit 1
loadtime:1.6243460178375 / seconds
Query Executed:select id FROM `ia` where city='Frederika' && SIC_code='5531'DB:business_master_new
loadtime:1.626886844635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:1.6269378662109 / seconds
Query Executed:select id FROM `ia` where city='Fremont' && SIC_code='5531'DB:business_master_new
loadtime:1.6280620098114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:1.6281850337982 / seconds
Query Executed:select id FROM `ia` where city='Fruitland' && SIC_code='5531'DB:business_master_new
loadtime:1.629812002182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galt' limit 1
loadtime:1.6298558712006 / seconds
Query Executed:select id FROM `ia` where city='Galt' && SIC_code='5531'DB:business_master_new
loadtime:1.6305589675903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galva' limit 1
loadtime:1.6306669712067 / seconds
Query Executed:select id FROM `ia` where city='Galva' && SIC_code='5531'DB:business_master_new
loadtime:1.6318168640137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garber' limit 1
loadtime:1.6319189071655 / seconds
Query Executed:select id FROM `ia` where city='Garber' && SIC_code='5531'DB:business_master_new
loadtime:1.6344108581543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:1.6344518661499 / seconds
Query Executed:select id FROM `ia` where city='Garden City' && SIC_code='5531'DB:business_master_new
loadtime:1.636118888855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden Grove' limit 1
loadtime:1.6361548900604 / seconds
Query Executed:select id FROM `ia` where city='Garden Grove' && SIC_code='5531'DB:business_master_new
loadtime:1.637109041214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnavillo' limit 1
loadtime:1.6371469497681 / seconds
Query Executed:select id FROM `ia` where city='Garnavillo' && SIC_code='5531'DB:business_master_new
loadtime:1.6383218765259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:1.6384048461914 / seconds
Query Executed:select id FROM `ia` where city='Garner' && SIC_code='5531'DB:business_master_new
loadtime:1.6402578353882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:1.6403870582581 / seconds
Query Executed:select id FROM `ia` where city='Garrison' && SIC_code='5531'DB:business_master_new
loadtime:1.6472358703613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwin' limit 1
loadtime:1.6472918987274 / seconds
Query Executed:select id FROM `ia` where city='Garwin' && SIC_code='5531'DB:business_master_new
loadtime:1.6519968509674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geneva' limit 1
loadtime:1.6520760059357 / seconds
Query Executed:select id FROM `ia` where city='Geneva' && SIC_code='5531'DB:business_master_new
loadtime:1.6560978889465 / seconds
Query loaded from cache:select * from geodata_geocity where city='George' limit 1
loadtime:1.6561369895935 / seconds
Query Executed:select id FROM `ia` where city='George' && SIC_code='5531'DB:business_master_new
loadtime:1.6576669216156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:1.6577069759369 / seconds
Query Executed:select id FROM `ia` where city='Gibson' && SIC_code='5531'DB:business_master_new
loadtime:1.6589238643646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:1.658961057663 / seconds
Query Executed:select id FROM `ia` where city='Gifford' && SIC_code='5531'DB:business_master_new
loadtime:1.6594519615173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:1.6594829559326 / seconds
Query Executed:select id FROM `ia` where city='Gilbert' && SIC_code='5531'DB:business_master_new
loadtime:1.6600430011749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:1.6600759029388 / seconds
Query Executed:select id FROM `ia` where city='Gilbertville' && SIC_code='5531'DB:business_master_new
loadtime:1.6625618934631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett Grove' limit 1
loadtime:1.6625988483429 / seconds
Query Executed:select id FROM `ia` where city='Gillett Grove' && SIC_code='5531'DB:business_master_new
loadtime:1.6644749641418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:1.6645109653473 / seconds
Query Executed:select id FROM `ia` where city='Gilman' && SIC_code='5531'DB:business_master_new
loadtime:1.6651139259338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmore City' limit 1
loadtime:1.6651458740234 / seconds
Query Executed:select id FROM `ia` where city='Gilmore City' && SIC_code='5531'DB:business_master_new
loadtime:1.6656930446625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladbrook' limit 1
loadtime:1.6657328605652 / seconds
Query Executed:select id FROM `ia` where city='Gladbrook' && SIC_code='5531'DB:business_master_new
loadtime:1.6663229465485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:1.6663630008698 / seconds
Query Executed:select id FROM `ia` where city='Glenwood' && SIC_code='5531'DB:business_master_new
loadtime:1.6670658588409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:1.6671118736267 / seconds
Query Executed:select id FROM `ia` where city='Glidden' && SIC_code='5531'DB:business_master_new
loadtime:1.6676959991455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldfield' limit 1
loadtime:1.6677219867706 / seconds
Query Executed:select id FROM `ia` where city='Goldfield' && SIC_code='5531'DB:business_master_new
loadtime:1.668261051178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodell' limit 1
loadtime:1.6683008670807 / seconds
Query Executed:select id FROM `ia` where city='Goodell' && SIC_code='5531'DB:business_master_new
loadtime:1.6693508625031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Lake' limit 1
loadtime:1.6693758964539 / seconds
Query Executed:select id FROM `ia` where city='Goose Lake' && SIC_code='5531'DB:business_master_new
loadtime:1.675961971283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowrie' limit 1
loadtime:1.6760029792786 / seconds
Query Executed:select id FROM `ia` where city='Gowrie' && SIC_code='5531'DB:business_master_new
loadtime:1.6766259670258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graettinger' limit 1
loadtime:1.6766679286957 / seconds
Query Executed:select id FROM `ia` where city='Graettinger' && SIC_code='5531'DB:business_master_new
loadtime:1.6772329807281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:1.6772649288177 / seconds
Query Executed:select id FROM `ia` where city='Grafton' && SIC_code='5531'DB:business_master_new
loadtime:1.6809680461884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:1.6809978485107 / seconds
Query Executed:select id FROM `ia` where city='Grand Junction' && SIC_code='5531'DB:business_master_new
loadtime:1.6815340518951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Mound' limit 1
loadtime:1.6815700531006 / seconds
Query Executed:select id FROM `ia` where city='Grand Mound' && SIC_code='5531'DB:business_master_new
loadtime:1.6821219921112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand River' limit 1
loadtime:1.682147026062 / seconds
Query Executed:select id FROM `ia` where city='Grand River' && SIC_code='5531'DB:business_master_new
loadtime:1.6833620071411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandview' limit 1
loadtime:1.6833958625793 / seconds
Query Executed:select id FROM `ia` where city='Grandview' && SIC_code='5531'DB:business_master_new
loadtime:1.6850199699402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granger' limit 1
loadtime:1.6850528717041 / seconds
Query Executed:select id FROM `ia` where city='Granger' && SIC_code='5531'DB:business_master_new
loadtime:1.6856608390808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:1.6856958866119 / seconds
Query Executed:select id FROM `ia` where city='Grant' && SIC_code='5531'DB:business_master_new
loadtime:1.6867828369141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:1.6868300437927 / seconds
Query Executed:select id FROM `ia` where city='Granville' && SIC_code='5531'DB:business_master_new
loadtime:1.6874108314514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gravity' limit 1
loadtime:1.6874589920044 / seconds
Query Executed:select id FROM `ia` where city='Gravity' && SIC_code='5531'DB:business_master_new
loadtime:1.6910200119019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray' limit 1
loadtime:1.691055059433 / seconds
Query Executed:select id FROM `ia` where city='Gray' && SIC_code='5531'DB:business_master_new
loadtime:1.6918580532074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:1.6919050216675 / seconds
Query Executed:select id FROM `ia` where city='Greeley' && SIC_code='5531'DB:business_master_new
loadtime:1.6930620670319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:1.6931109428406 / seconds
Query Executed:select id FROM `ia` where city='Green Mountain' && SIC_code='5531'DB:business_master_new
loadtime:1.6937170028687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greene' limit 1
loadtime:1.6937699317932 / seconds
Query Executed:select id FROM `ia` where city='Greene' && SIC_code='5531'DB:business_master_new
loadtime:1.6943869590759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:1.6944379806519 / seconds
Query Executed:select id FROM `ia` where city='Greenfield' && SIC_code='5531'DB:business_master_new
loadtime:1.6951429843903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.6951999664307 / seconds
Query Executed:select id FROM `ia` where city='Greenville' && SIC_code='5531'DB:business_master_new
loadtime:1.6960668563843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimes' limit 1
loadtime:1.6961109638214 / seconds
Query Executed:select id FROM `ia` where city='Grimes' && SIC_code='5531'DB:business_master_new
loadtime:1.6967868804932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grinnell' limit 1
loadtime:1.6968250274658 / seconds
Query Executed:select id FROM `ia` where city='Grinnell' && SIC_code='5531'DB:business_master_new
loadtime:1.6976249217987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Griswold' limit 1
loadtime:1.6976819038391 / seconds
Query Executed:select id FROM `ia` where city='Griswold' && SIC_code='5531'DB:business_master_new
loadtime:1.6983330249786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy Center' limit 1
loadtime:1.6983768939972 / seconds
Query Executed:select id FROM `ia` where city='Grundy Center' && SIC_code='5531'DB:business_master_new
loadtime:1.6990568637848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gruver' limit 1
loadtime:1.6991159915924 / seconds
Query Executed:select id FROM `ia` where city='Gruver' && SIC_code='5531'DB:business_master_new
loadtime:1.6994340419769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guernsey' limit 1
loadtime:1.6994619369507 / seconds
Query Executed:select id FROM `ia` where city='Guernsey' && SIC_code='5531'DB:business_master_new
loadtime:1.7002148628235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guthrie Center' limit 1
loadtime:1.7002630233765 / seconds
Query Executed:select id FROM `ia` where city='Guthrie Center' && SIC_code='5531'DB:business_master_new
loadtime:1.7009580135345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:1.7010028362274 / seconds
Query Executed:select id FROM `ia` where city='Guttenberg' && SIC_code='5531'DB:business_master_new
loadtime:1.7016508579254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halbur' limit 1
loadtime:1.701712846756 / seconds
Query Executed:select id FROM `ia` where city='Halbur' && SIC_code='5531'DB:business_master_new
loadtime:1.7029860019684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:1.7030329704285 / seconds
Query Executed:select id FROM `ia` where city='Hamburg' && SIC_code='5531'DB:business_master_new
loadtime:1.7036590576172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.7037198543549 / seconds
Query Executed:select id FROM `ia` where city='Hamilton' && SIC_code='5531'DB:business_master_new
loadtime:1.7039680480957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlin' limit 1
loadtime:1.7040028572083 / seconds
Query Executed:select id FROM `ia` where city='Hamlin' && SIC_code='5531'DB:business_master_new
loadtime:1.7052309513092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:1.7052888870239 / seconds
Query Executed:select id FROM `ia` where city='Hampton' && SIC_code='5531'DB:business_master_new
loadtime:1.706001996994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.7060599327087 / seconds
Query Executed:select id FROM `ia` where city='Hancock' && SIC_code='5531'DB:business_master_new
loadtime:1.7076368331909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanlontown' limit 1
loadtime:1.7076950073242 / seconds
Query Executed:select id FROM `ia` where city='Hanlontown' && SIC_code='5531'DB:business_master_new
loadtime:1.7095370292664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hansell' limit 1
loadtime:1.709578037262 / seconds
Query Executed:select id FROM `ia` where city='Hansell' && SIC_code='5531'DB:business_master_new
loadtime:1.7098560333252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harcourt' limit 1
loadtime:1.7099609375 / seconds
Query Executed:select id FROM `ia` where city='Harcourt' && SIC_code='5531'DB:business_master_new
loadtime:1.714460849762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:1.7144958972931 / seconds
Query Executed:select id FROM `ia` where city='Hardy' && SIC_code='5531'DB:business_master_new
loadtime:1.715409040451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harlan' limit 1
loadtime:1.7154450416565 / seconds
Query Executed:select id FROM `ia` where city='Harlan' && SIC_code='5531'DB:business_master_new
loadtime:1.7176539897919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:1.7178199291229 / seconds
Query Executed:select id FROM `ia` where city='Harper' && SIC_code='5531'DB:business_master_new
loadtime:1.7202038764954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harpers Ferry' limit 1
loadtime:1.7202398777008 / seconds
Query Executed:select id FROM `ia` where city='Harpers Ferry' && SIC_code='5531'DB:business_master_new
loadtime:1.7207908630371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:1.7208359241486 / seconds
Query Executed:select id FROM `ia` where city='Harris' && SIC_code='5531'DB:business_master_new
loadtime:1.7239248752594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.7239718437195 / seconds
Query Executed:select id FROM `ia` where city='Hartford' && SIC_code='5531'DB:business_master_new
loadtime:1.7251129150391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartley' limit 1
loadtime:1.7251629829407 / seconds
Query Executed:select id FROM `ia` where city='Hartley' && SIC_code='5531'DB:business_master_new
loadtime:1.7258038520813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwick' limit 1
loadtime:1.7258529663086 / seconds
Query Executed:select id FROM `ia` where city='Hartwick' && SIC_code='5531'DB:business_master_new
loadtime:1.7271389961243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:1.7271890640259 / seconds
Query Executed:select id FROM `ia` where city='Harvey' && SIC_code='5531'DB:business_master_new
loadtime:1.7296628952026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:1.7297098636627 / seconds
Query Executed:select id FROM `ia` where city='Hastings' && SIC_code='5531'DB:business_master_new
loadtime:1.731791973114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:1.7318289279938 / seconds
Query Executed:select id FROM `ia` where city='Havelock' && SIC_code='5531'DB:business_master_new
loadtime:1.7365419864655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:1.7367160320282 / seconds
Query Executed:select id FROM `ia` where city='Haverhill' && SIC_code='5531'DB:business_master_new
loadtime:1.7385790348053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawarden' limit 1
loadtime:1.7386388778687 / seconds
Query Executed:select id FROM `ia` where city='Hawarden' && SIC_code='5531'DB:business_master_new
loadtime:1.739296913147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkeye' limit 1
loadtime:1.7393510341644 / seconds
Query Executed:select id FROM `ia` where city='Hawkeye' && SIC_code='5531'DB:business_master_new
loadtime:1.7399499416351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:1.7399978637695 / seconds
Query Executed:select id FROM `ia` where city='Hayesville' && SIC_code='5531'DB:business_master_new
loadtime:1.7406349182129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazleton' limit 1
loadtime:1.7406840324402 / seconds
Query Executed:select id FROM `ia` where city='Hazleton' && SIC_code='5531'DB:business_master_new
loadtime:1.7422280311584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hedrick' limit 1
loadtime:1.7423570156097 / seconds
Query Executed:select id FROM `ia` where city='Hedrick' && SIC_code='5531'DB:business_master_new
loadtime:1.7439620494843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:1.7440929412842 / seconds
Query Executed:select id FROM `ia` where city='Henderson' && SIC_code='5531'DB:business_master_new
loadtime:1.7488279342651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:1.7488839626312 / seconds
Query Executed:select id FROM `ia` where city='Hiawatha' && SIC_code='5531'DB:business_master_new
loadtime:1.7502899169922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlandville' limit 1
loadtime:1.7503879070282 / seconds
Query Executed:select id FROM `ia` where city='Highlandville' && SIC_code='5531'DB:business_master_new
loadtime:1.7514560222626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hills' limit 1
loadtime:1.7515029907227 / seconds
Query Executed:select id FROM `ia` where city='Hills' && SIC_code='5531'DB:business_master_new
loadtime:1.7554779052734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.7555270195007 / seconds
Query Executed:select id FROM `ia` where city='Hillsboro' && SIC_code='5531'DB:business_master_new
loadtime:1.7581748962402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:1.7582249641418 / seconds
Query Executed:select id FROM `ia` where city='Hinton' && SIC_code='5531'DB:business_master_new
loadtime:1.7587928771973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.7588310241699 / seconds
Query Executed:select id FROM `ia` where city='Holland' && SIC_code='5531'DB:business_master_new
loadtime:1.7604968547821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holstein' limit 1
loadtime:1.7605428695679 / seconds
Query Executed:select id FROM `ia` where city='Holstein' && SIC_code='5531'DB:business_master_new
loadtime:1.7612268924713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holy Cross' limit 1
loadtime:1.7612810134888 / seconds
Query Executed:select id FROM `ia` where city='Holy Cross' && SIC_code='5531'DB:business_master_new
loadtime:1.7618958950043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homestead' limit 1
loadtime:1.7619309425354 / seconds
Query Executed:select id FROM `ia` where city='Homestead' && SIC_code='5531'DB:business_master_new
loadtime:1.765065908432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:1.7651228904724 / seconds
Query Executed:select id FROM `ia` where city='Honey Creek' && SIC_code='5531'DB:business_master_new
loadtime:1.7674589157104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.7675108909607 / seconds
Query Executed:select id FROM `ia` where city='Hopkinton' && SIC_code='5531'DB:business_master_new
loadtime:1.7681109905243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hornick' limit 1
loadtime:1.7681698799133 / seconds
Query Executed:select id FROM `ia` where city='Hornick' && SIC_code='5531'DB:business_master_new
loadtime:1.7687208652496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hospers' limit 1
loadtime:1.7687618732452 / seconds
Query Executed:select id FROM `ia` where city='Hospers' && SIC_code='5531'DB:business_master_new
loadtime:1.7693629264832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:1.7694089412689 / seconds
Query Executed:select id FROM `ia` where city='Houghton' && SIC_code='5531'DB:business_master_new
loadtime:1.7713329792023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard' limit 1
loadtime:1.7713830471039 / seconds
Query Executed:select id FROM `ia` where city='Hubbard' && SIC_code='5531'DB:business_master_new
loadtime:1.7720119953156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.7720470428467 / seconds
Query Executed:select id FROM `ia` where city='Hudson' && SIC_code='5531'DB:business_master_new
loadtime:1.7726829051971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:1.7727429866791 / seconds
Query Executed:select id FROM `ia` where city='Hull' && SIC_code='5531'DB:business_master_new
loadtime:1.7733879089355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:1.7734389305115 / seconds
Query Executed:select id FROM `ia` where city='Humboldt' && SIC_code='5531'DB:business_master_new
loadtime:1.7742018699646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humeston' limit 1
loadtime:1.774246931076 / seconds
Query Executed:select id FROM `ia` where city='Humeston' && SIC_code='5531'DB:business_master_new
loadtime:1.7748119831085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huxley' limit 1
loadtime:1.7748589515686 / seconds
Query Executed:select id FROM `ia` where city='Huxley' && SIC_code='5531'DB:business_master_new
loadtime:1.7754888534546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida Grove' limit 1
loadtime:1.7755370140076 / seconds
Query Executed:select id FROM `ia` where city='Ida Grove' && SIC_code='5531'DB:business_master_new
loadtime:1.7762289047241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imogene' limit 1
loadtime:1.7762889862061 / seconds
Query Executed:select id FROM `ia` where city='Imogene' && SIC_code='5531'DB:business_master_new
loadtime:1.7773489952087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:1.7774019241333 / seconds
Query Executed:select id FROM `ia` where city='Independence' && SIC_code='5531'DB:business_master_new
loadtime:1.7782208919525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:1.7782790660858 / seconds
Query Executed:select id FROM `ia` where city='Indianola' && SIC_code='5531'DB:business_master_new
loadtime:1.7791509628296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inwood' limit 1
loadtime:1.7792098522186 / seconds
Query Executed:select id FROM `ia` where city='Inwood' && SIC_code='5531'DB:business_master_new
loadtime:1.7798409461975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:1.7798838615417 / seconds
Query Executed:select id FROM `ia` where city='Ionia' && SIC_code='5531'DB:business_master_new
loadtime:1.7804548740387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa City' limit 1
loadtime:1.7804958820343 / seconds
Query Executed:select id FROM `ia` where city='Iowa City' && SIC_code='5531'DB:business_master_new
loadtime:1.7829048633575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa Falls' limit 1
loadtime:1.7829668521881 / seconds
Query Executed:select id FROM `ia` where city='Iowa Falls' && SIC_code='5531'DB:business_master_new
loadtime:1.7837879657745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:1.7838380336761 / seconds
Query Executed:select id FROM `ia` where city='Ira' && SIC_code='5531'DB:business_master_new
loadtime:1.784569978714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ireton' limit 1
loadtime:1.7846310138702 / seconds
Query Executed:select id FROM `ia` where city='Ireton' && SIC_code='5531'DB:business_master_new
loadtime:1.7852339744568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irwin' limit 1
loadtime:1.7852840423584 / seconds
Query Executed:select id FROM `ia` where city='Irwin' && SIC_code='5531'DB:business_master_new
loadtime:1.7858190536499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Junction' limit 1
loadtime:1.7858459949493 / seconds
Query Executed:select id FROM `ia` where city='Jackson Junction' && SIC_code='5531'DB:business_master_new
loadtime:1.7861490249634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:1.7862038612366 / seconds
Query Executed:select id FROM `ia` where city='Jamaica' && SIC_code='5531'DB:business_master_new
loadtime:1.7866230010986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:1.7866630554199 / seconds
Query Executed:select id FROM `ia` where city='Janesville' && SIC_code='5531'DB:business_master_new
loadtime:1.7872788906097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.7873289585114 / seconds
Query Executed:select id FROM `ia` where city='Jefferson' && SIC_code='5531'DB:business_master_new
loadtime:1.7881050109863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jesup' limit 1
loadtime:1.7881639003754 / seconds
Query Executed:select id FROM `ia` where city='Jesup' && SIC_code='5531'DB:business_master_new
loadtime:1.7888119220734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell' limit 1
loadtime:1.7888469696045 / seconds
Query Executed:select id FROM `ia` where city='Jewell' && SIC_code='5531'DB:business_master_new
loadtime:1.7894439697266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:1.7894928455353 / seconds
Query Executed:select id FROM `ia` where city='Johnston' && SIC_code='5531'DB:business_master_new
loadtime:1.7902798652649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joice' limit 1
loadtime:1.7903230190277 / seconds
Query Executed:select id FROM `ia` where city='Joice' && SIC_code='5531'DB:business_master_new
loadtime:1.7934989929199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jolley' limit 1
loadtime:1.7935500144958 / seconds
Query Executed:select id FROM `ia` where city='Jolley' && SIC_code='5531'DB:business_master_new
loadtime:1.7951290607452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalona' limit 1
loadtime:1.7951769828796 / seconds
Query Executed:select id FROM `ia` where city='Kalona' && SIC_code='5531'DB:business_master_new
loadtime:1.7958459854126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamrar' limit 1
loadtime:1.795881986618 / seconds
Query Executed:select id FROM `ia` where city='Kamrar' && SIC_code='5531'DB:business_master_new
loadtime:1.7968928813934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanawha' limit 1
loadtime:1.7969329357147 / seconds
Query Executed:select id FROM `ia` where city='Kanawha' && SIC_code='5531'DB:business_master_new
loadtime:1.7975058555603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellerton' limit 1
loadtime:1.7975368499756 / seconds
Query Executed:select id FROM `ia` where city='Kellerton' && SIC_code='5531'DB:business_master_new
loadtime:1.7993750572205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelley' limit 1
loadtime:1.7994139194489 / seconds
Query Executed:select id FROM `ia` where city='Kelley' && SIC_code='5531'DB:business_master_new
loadtime:1.8014080524445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellogg' limit 1
loadtime:1.8014459609985 / seconds
Query Executed:select id FROM `ia` where city='Kellogg' && SIC_code='5531'DB:business_master_new
loadtime:1.8020119667053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensett' limit 1
loadtime:1.8020370006561 / seconds
Query Executed:select id FROM `ia` where city='Kensett' && SIC_code='5531'DB:business_master_new
loadtime:1.8025469779968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:1.8025829792023 / seconds
Query Executed:select id FROM `ia` where city='Kent' && SIC_code='5531'DB:business_master_new
loadtime:1.8028490543365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokuk' limit 1
loadtime:1.8028869628906 / seconds
Query Executed:select id FROM `ia` where city='Keokuk' && SIC_code='5531'DB:business_master_new
loadtime:1.8037168979645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keosauqua' limit 1
loadtime:1.8037528991699 / seconds
Query Executed:select id FROM `ia` where city='Keosauqua' && SIC_code='5531'DB:business_master_new
loadtime:1.8043539524078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keota' limit 1
loadtime:1.8043949604034 / seconds
Query Executed:select id FROM `ia` where city='Keota' && SIC_code='5531'DB:business_master_new
loadtime:1.8049960136414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kesley' limit 1
loadtime:1.8050389289856 / seconds
Query Executed:select id FROM `ia` where city='Kesley' && SIC_code='5531'DB:business_master_new
loadtime:1.8056268692017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:1.8056519031525 / seconds
Query Executed:select id FROM `ia` where city='Keswick' && SIC_code='5531'DB:business_master_new
loadtime:1.8095209598541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:1.8095600605011 / seconds
Query Executed:select id FROM `ia` where city='Keystone' && SIC_code='5531'DB:business_master_new
loadtime:1.8101470470428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killduff' limit 1
loadtime:1.8101880550385 / seconds
Query Executed:select id FROM `ia` where city='Killduff' && SIC_code='5531'DB:business_master_new
loadtime:1.8105120658875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimballton' limit 1
loadtime:1.8105368614197 / seconds
Query Executed:select id FROM `ia` where city='Kimballton' && SIC_code='5531'DB:business_master_new
loadtime:1.8123500347137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:1.8123869895935 / seconds
Query Executed:select id FROM `ia` where city='Kingsley' && SIC_code='5531'DB:business_master_new
loadtime:1.8129839897156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:1.8130078315735 / seconds
Query Executed:select id FROM `ia` where city='Kinross' && SIC_code='5531'DB:business_master_new
loadtime:1.8132748603821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkman' limit 1
loadtime:1.8133089542389 / seconds
Query Executed:select id FROM `ia` where city='Kirkman' && SIC_code='5531'DB:business_master_new
loadtime:1.8137140274048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkville' limit 1
loadtime:1.8137500286102 / seconds
Query Executed:select id FROM `ia` where city='Kirkville' && SIC_code='5531'DB:business_master_new
loadtime:1.8143680095673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiron' limit 1
loadtime:1.8143908977509 / seconds
Query Executed:select id FROM `ia` where city='Kiron' && SIC_code='5531'DB:business_master_new
loadtime:1.8166499137878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Klemme' limit 1
loadtime:1.8166840076447 / seconds
Query Executed:select id FROM `ia` where city='Klemme' && SIC_code='5531'DB:business_master_new
loadtime:1.8188669681549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knierim' limit 1
loadtime:1.8189010620117 / seconds
Query Executed:select id FROM `ia` where city='Knierim' && SIC_code='5531'DB:business_master_new
loadtime:1.8194320201874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knoxville' limit 1
loadtime:1.8194630146027 / seconds
Query Executed:select id FROM `ia` where city='Knoxville' && SIC_code='5531'DB:business_master_new
loadtime:1.8202049732208 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Motte' limit 1
loadtime:1.8202419281006 / seconds
Query Executed:select id FROM `ia` where city='La Motte' && SIC_code='5531'DB:business_master_new
loadtime:1.8207979202271 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Porte City' limit 1
loadtime:1.8208320140839 / seconds
Query Executed:select id FROM `ia` where city='La Porte City' && SIC_code='5531'DB:business_master_new
loadtime:1.8214399814606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacona' limit 1
loadtime:1.821478843689 / seconds
Query Executed:select id FROM `ia` where city='Lacona' && SIC_code='5531'DB:business_master_new
loadtime:1.8220129013062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladora' limit 1
loadtime:1.8220388889313 / seconds
Query Executed:select id FROM `ia` where city='Ladora' && SIC_code='5531'DB:business_master_new
loadtime:1.8233368396759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:1.8233759403229 / seconds
Query Executed:select id FROM `ia` where city='Lake City' && SIC_code='5531'DB:business_master_new
loadtime:1.8239729404449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:1.8240129947662 / seconds
Query Executed:select id FROM `ia` where city='Lake Mills' && SIC_code='5531'DB:business_master_new
loadtime:1.8246290683746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Park' limit 1
loadtime:1.8246710300446 / seconds
Query Executed:select id FROM `ia` where city='Lake Park' && SIC_code='5531'DB:business_master_new
loadtime:1.8252420425415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:1.8252809047699 / seconds
Query Executed:select id FROM `ia` where city='Lake View' && SIC_code='5531'DB:business_master_new
loadtime:1.8258669376373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakota' limit 1
loadtime:1.8259079456329 / seconds
Query Executed:select id FROM `ia` where city='Lakota' && SIC_code='5531'DB:business_master_new
loadtime:1.8295149803162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamoni' limit 1
loadtime:1.8295440673828 / seconds
Query Executed:select id FROM `ia` where city='Lamoni' && SIC_code='5531'DB:business_master_new
loadtime:1.8301410675049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:1.8301808834076 / seconds
Query Executed:select id FROM `ia` where city='Lamont' && SIC_code='5531'DB:business_master_new
loadtime:1.8337709903717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:1.833811044693 / seconds
Query Executed:select id FROM `ia` where city='Lanesboro' && SIC_code='5531'DB:business_master_new
loadtime:1.8341639041901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langworthy' limit 1
loadtime:1.8341979980469 / seconds
Query Executed:select id FROM `ia` where city='Langworthy' && SIC_code='5531'DB:business_master_new
loadtime:1.8344578742981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:1.8344960212708 / seconds
Query Executed:select id FROM `ia` where city='Lansing' && SIC_code='5531'DB:business_master_new
loadtime:1.8350880146027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larchwood' limit 1
loadtime:1.8351218700409 / seconds
Query Executed:select id FROM `ia` where city='Larchwood' && SIC_code='5531'DB:business_master_new
loadtime:1.8356950283051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larrabee' limit 1
loadtime:1.8357360363007 / seconds
Query Executed:select id FROM `ia` where city='Larrabee' && SIC_code='5531'DB:business_master_new
loadtime:1.8391749858856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latimer' limit 1
loadtime:1.83922290802 / seconds
Query Executed:select id FROM `ia` where city='Latimer' && SIC_code='5531'DB:business_master_new
loadtime:1.8398058414459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:1.8398430347443 / seconds
Query Executed:select id FROM `ia` where city='Laurel' && SIC_code='5531'DB:business_master_new
loadtime:1.8413050174713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:1.8413519859314 / seconds
Query Executed:select id FROM `ia` where city='Laurens' && SIC_code='5531'DB:business_master_new
loadtime:1.8419718742371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawler' limit 1
loadtime:1.8420159816742 / seconds
Query Executed:select id FROM `ia` where city='Lawler' && SIC_code='5531'DB:business_master_new
loadtime:1.8425369262695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:1.8425760269165 / seconds
Query Executed:select id FROM `ia` where city='Lawton' && SIC_code='5531'DB:business_master_new
loadtime:1.8431479930878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Claire' limit 1
loadtime:1.8431890010834 / seconds
Query Executed:select id FROM `ia` where city='Le Claire' && SIC_code='5531'DB:business_master_new
loadtime:1.8437838554382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Grand' limit 1
loadtime:1.8438229560852 / seconds
Query Executed:select id FROM `ia` where city='Le Grand' && SIC_code='5531'DB:business_master_new
loadtime:1.8446478843689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Mars' limit 1
loadtime:1.8446838855743 / seconds
Query Executed:select id FROM `ia` where city='Le Mars' && SIC_code='5531'DB:business_master_new
loadtime:1.8455169200897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:1.8455760478973 / seconds
Query Executed:select id FROM `ia` where city='Ledyard' && SIC_code='5531'DB:business_master_new
loadtime:1.8460779190063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehigh' limit 1
loadtime:1.846127986908 / seconds
Query Executed:select id FROM `ia` where city='Lehigh' && SIC_code='5531'DB:business_master_new
loadtime:1.8485698699951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leighton' limit 1
loadtime:1.8486268520355 / seconds
Query Executed:select id FROM `ia` where city='Leighton' && SIC_code='5531'DB:business_master_new
loadtime:1.8647029399872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:1.8647530078888 / seconds
Query Executed:select id FROM `ia` where city='Leland' && SIC_code='5531'DB:business_master_new
loadtime:1.8673920631409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.8674418926239 / seconds
Query Executed:select id FROM `ia` where city='Lenox' && SIC_code='5531'DB:business_master_new
loadtime:1.8681108951569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:1.8681788444519 / seconds
Query Executed:select id FROM `ia` where city='Leon' && SIC_code='5531'DB:business_master_new
loadtime:1.868824005127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lester' limit 1
loadtime:1.8688659667969 / seconds
Query Executed:select id FROM `ia` where city='Lester' && SIC_code='5531'DB:business_master_new
loadtime:1.8701758384705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letts' limit 1
loadtime:1.8702259063721 / seconds
Query Executed:select id FROM `ia` where city='Letts' && SIC_code='5531'DB:business_master_new
loadtime:1.8715128898621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:1.8715648651123 / seconds
Query Executed:select id FROM `ia` where city='Lewis' && SIC_code='5531'DB:business_master_new
loadtime:1.8721439838409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Center' limit 1
loadtime:1.8721799850464 / seconds
Query Executed:select id FROM `ia` where city='Liberty Center' && SIC_code='5531'DB:business_master_new
loadtime:1.8728978633881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Libertyville' limit 1
loadtime:1.8729419708252 / seconds
Query Executed:select id FROM `ia` where city='Libertyville' && SIC_code='5531'DB:business_master_new
loadtime:1.8738598823547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lidderdale' limit 1
loadtime:1.8739018440247 / seconds
Query Executed:select id FROM `ia` where city='Lidderdale' && SIC_code='5531'DB:business_master_new
loadtime:1.8748848438263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Springs' limit 1
loadtime:1.8749248981476 / seconds
Query Executed:select id FROM `ia` where city='Lime Springs' && SIC_code='5531'DB:business_master_new
loadtime:1.8754909038544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.8755340576172 / seconds
Query Executed:select id FROM `ia` where city='Lincoln' && SIC_code='5531'DB:business_master_new
loadtime:1.8762359619141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:1.8762929439545 / seconds
Query Executed:select id FROM `ia` where city='Linden' && SIC_code='5531'DB:business_master_new
loadtime:1.8795430660248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lineville' limit 1
loadtime:1.8795938491821 / seconds
Query Executed:select id FROM `ia` where city='Lineville' && SIC_code='5531'DB:business_master_new
loadtime:1.8814039230347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linn Grove' limit 1
loadtime:1.8814430236816 / seconds
Query Executed:select id FROM `ia` where city='Linn Grove' && SIC_code='5531'DB:business_master_new
loadtime:1.8832468986511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:1.8832960128784 / seconds
Query Executed:select id FROM `ia` where city='Lisbon' && SIC_code='5531'DB:business_master_new
loadtime:1.8839240074158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liscomb' limit 1
loadtime:1.8839778900146 / seconds
Query Executed:select id FROM `ia` where city='Liscomb' && SIC_code='5531'DB:business_master_new
loadtime:1.8856329917908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Cedar' limit 1
loadtime:1.8856840133667 / seconds
Query Executed:select id FROM `ia` where city='Little Cedar' && SIC_code='5531'DB:business_master_new
loadtime:1.8869068622589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:1.886962890625 / seconds
Query Executed:select id FROM `ia` where city='Little Rock' && SIC_code='5531'DB:business_master_new
loadtime:1.8875570297241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Sioux' limit 1
loadtime:1.8875980377197 / seconds
Query Executed:select id FROM `ia` where city='Little Sioux' && SIC_code='5531'DB:business_master_new
loadtime:1.8885629177094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:1.8886308670044 / seconds
Query Executed:select id FROM `ia` where city='Livermore' && SIC_code='5531'DB:business_master_new
loadtime:1.8929309844971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockridge' limit 1
loadtime:1.8929779529572 / seconds
Query Executed:select id FROM `ia` where city='Lockridge' && SIC_code='5531'DB:business_master_new
loadtime:1.8958129882812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:1.8959498405457 / seconds
Query Executed:select id FROM `ia` where city='Logan' && SIC_code='5531'DB:business_master_new
loadtime:1.8975658416748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lohrville' limit 1
loadtime:1.8977599143982 / seconds
Query Executed:select id FROM `ia` where city='Lohrville' && SIC_code='5531'DB:business_master_new
loadtime:1.899365901947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:1.89950299263 / seconds
Query Executed:select id FROM `ia` where city='Lone Rock' && SIC_code='5531'DB:business_master_new
loadtime:1.9022669792175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:1.9023020267487 / seconds
Query Executed:select id FROM `ia` where city='Lone Tree' && SIC_code='5531'DB:business_master_new
loadtime:1.9028968811035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Grove' limit 1
loadtime:1.9029459953308 / seconds
Query Executed:select id FROM `ia` where city='Long Grove' && SIC_code='5531'DB:business_master_new
loadtime:1.9035499095917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorimor' limit 1
loadtime:1.9035968780518 / seconds
Query Executed:select id FROM `ia` where city='Lorimor' && SIC_code='5531'DB:business_master_new
loadtime:1.9046168327332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Nation' limit 1
loadtime:1.9046649932861 / seconds
Query Executed:select id FROM `ia` where city='Lost Nation' && SIC_code='5531'DB:business_master_new
loadtime:1.9052538871765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovilia' limit 1
loadtime:1.9052948951721 / seconds
Query Executed:select id FROM `ia` where city='Lovilia' && SIC_code='5531'DB:business_master_new
loadtime:1.9068150520325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:1.9069700241089 / seconds
Query Executed:select id FROM `ia` where city='Low Moor' && SIC_code='5531'DB:business_master_new
loadtime:1.9089379310608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowden' limit 1
loadtime:1.9090428352356 / seconds
Query Executed:select id FROM `ia` where city='Lowden' && SIC_code='5531'DB:business_master_new
loadtime:1.9112520217896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lu Verne' limit 1
loadtime:1.911365032196 / seconds
Query Executed:select id FROM `ia` where city='Lu Verne' && SIC_code='5531'DB:business_master_new
loadtime:1.9129159450531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luana' limit 1
loadtime:1.9130430221558 / seconds
Query Executed:select id FROM `ia` where city='Luana' && SIC_code='5531'DB:business_master_new
loadtime:1.9147419929504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucas' limit 1
loadtime:1.9148390293121 / seconds
Query Executed:select id FROM `ia` where city='Lucas' && SIC_code='5531'DB:business_master_new
loadtime:1.9179639816284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:1.9181008338928 / seconds
Query Executed:select id FROM `ia` where city='Luther' && SIC_code='5531'DB:business_master_new
loadtime:1.919273853302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:1.9194149971008 / seconds
Query Executed:select id FROM `ia` where city='Luxemburg' && SIC_code='5531'DB:business_master_new
loadtime:1.9207489490509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:1.9208438396454 / seconds
Query Executed:select id FROM `ia` where city='Luzerne' && SIC_code='5531'DB:business_master_new
loadtime:1.9223530292511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnville' limit 1
loadtime:1.9224638938904 / seconds
Query Executed:select id FROM `ia` where city='Lynnville' && SIC_code='5531'DB:business_master_new
loadtime:1.9240920543671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lytton' limit 1
loadtime:1.9242448806763 / seconds
Query Executed:select id FROM `ia` where city='Lytton' && SIC_code='5531'DB:business_master_new
loadtime:1.9255440235138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macedonia' limit 1
loadtime:1.9257118701935 / seconds
Query Executed:select id FROM `ia` where city='Macedonia' && SIC_code='5531'DB:business_master_new
loadtime:1.9275889396667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macksburg' limit 1
loadtime:1.9277319908142 / seconds
Query Executed:select id FROM `ia` where city='Macksburg' && SIC_code='5531'DB:business_master_new
loadtime:1.9295308589935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madrid' limit 1
loadtime:1.9295809268951 / seconds
Query Executed:select id FROM `ia` where city='Madrid' && SIC_code='5531'DB:business_master_new
loadtime:1.931293964386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:1.9314138889313 / seconds
Query Executed:select id FROM `ia` where city='Magnolia' && SIC_code='5531'DB:business_master_new
loadtime:1.9327850341797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malcom' limit 1
loadtime:1.9328298568726 / seconds
Query Executed:select id FROM `ia` where city='Malcom' && SIC_code='5531'DB:business_master_new
loadtime:1.9338479042053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mallard' limit 1
loadtime:1.9339170455933 / seconds
Query Executed:select id FROM `ia` where city='Mallard' && SIC_code='5531'DB:business_master_new
loadtime:1.9391729831696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maloy' limit 1
loadtime:1.9392130374908 / seconds
Query Executed:select id FROM `ia` where city='Maloy' && SIC_code='5531'DB:business_master_new
loadtime:1.9394800662994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malvern' limit 1
loadtime:1.9395089149475 / seconds
Query Executed:select id FROM `ia` where city='Malvern' && SIC_code='5531'DB:business_master_new
loadtime:1.9400999546051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.9401340484619 / seconds
Query Executed:select id FROM `ia` where city='Manchester' && SIC_code='5531'DB:business_master_new
loadtime:1.9409580230713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manilla' limit 1
loadtime:1.9410228729248 / seconds
Query Executed:select id FROM `ia` where city='Manilla' && SIC_code='5531'DB:business_master_new
loadtime:1.9415979385376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manly' limit 1
loadtime:1.9416379928589 / seconds
Query Executed:select id FROM `ia` where city='Manly' && SIC_code='5531'DB:business_master_new
loadtime:1.9422180652618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:1.9422509670258 / seconds
Query Executed:select id FROM `ia` where city='Manning' && SIC_code='5531'DB:business_master_new
loadtime:1.9428789615631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:1.9429240226746 / seconds
Query Executed:select id FROM `ia` where city='Manson' && SIC_code='5531'DB:business_master_new
loadtime:1.9435179233551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:1.9435558319092 / seconds
Query Executed:select id FROM `ia` where city='Mapleton' && SIC_code='5531'DB:business_master_new
loadtime:1.9441900253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maquoketa' limit 1
loadtime:1.944228887558 / seconds
Query Executed:select id FROM `ia` where city='Maquoketa' && SIC_code='5531'DB:business_master_new
loadtime:1.945023059845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:1.9450669288635 / seconds
Query Executed:select id FROM `ia` where city='Marathon' && SIC_code='5531'DB:business_master_new
loadtime:1.9464859962463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Rock' limit 1
loadtime:1.9465119838715 / seconds
Query Executed:select id FROM `ia` where city='Marble Rock' && SIC_code='5531'DB:business_master_new
loadtime:1.9475748538971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcus' limit 1
loadtime:1.9476919174194 / seconds
Query Executed:select id FROM `ia` where city='Marcus' && SIC_code='5531'DB:business_master_new
loadtime:1.9493689537048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:1.9494850635529 / seconds
Query Executed:select id FROM `ia` where city='Marengo' && SIC_code='5531'DB:business_master_new
loadtime:1.951397895813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.9515030384064 / seconds
Query Executed:select id FROM `ia` where city='Marion' && SIC_code='5531'DB:business_master_new
loadtime:1.9542758464813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:1.9543960094452 / seconds
Query Executed:select id FROM `ia` where city='Marne' && SIC_code='5531'DB:business_master_new
loadtime:1.9559199810028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:1.9559578895569 / seconds
Query Executed:select id FROM `ia` where city='Marquette' && SIC_code='5531'DB:business_master_new
loadtime:1.9569380283356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshalltown' limit 1
loadtime:1.9569759368896 / seconds
Query Executed:select id FROM `ia` where city='Marshalltown' && SIC_code='5531'DB:business_master_new
loadtime:1.9590818881989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martelle' limit 1
loadtime:1.9592049121857 / seconds
Query Executed:select id FROM `ia` where city='Martelle' && SIC_code='5531'DB:business_master_new
loadtime:1.961375951767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martensdale' limit 1
loadtime:1.9614758491516 / seconds
Query Executed:select id FROM `ia` where city='Martensdale' && SIC_code='5531'DB:business_master_new
loadtime:1.9627120494843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsburg' limit 1
loadtime:1.9628388881683 / seconds
Query Executed:select id FROM `ia` where city='Martinsburg' && SIC_code='5531'DB:business_master_new
loadtime:1.9637868404388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason City' limit 1
loadtime:1.9639248847961 / seconds
Query Executed:select id FROM `ia` where city='Mason City' && SIC_code='5531'DB:business_master_new
loadtime:1.9669969081879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:1.9671649932861 / seconds
Query Executed:select id FROM `ia` where city='Masonville' && SIC_code='5531'DB:business_master_new
loadtime:1.9690098762512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massena' limit 1
loadtime:1.9690618515015 / seconds
Query Executed:select id FROM `ia` where city='Massena' && SIC_code='5531'DB:business_master_new
loadtime:1.9704608917236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matlock' limit 1
loadtime:1.9705948829651 / seconds
Query Executed:select id FROM `ia` where city='Matlock' && SIC_code='5531'DB:business_master_new
loadtime:1.9715299606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurice' limit 1
loadtime:1.9717059135437 / seconds
Query Executed:select id FROM `ia` where city='Maurice' && SIC_code='5531'DB:business_master_new
loadtime:1.9731168746948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:1.9731650352478 / seconds
Query Executed:select id FROM `ia` where city='Maxwell' && SIC_code='5531'DB:business_master_new
loadtime:1.9747638702393 / seconds
Query loaded from cache:select * from geodata_geocity where city='May City' limit 1
loadtime:1.9748928546906 / seconds
Query Executed:select id FROM `ia` where city='May City' && SIC_code='5531'DB:business_master_new
loadtime:1.975713968277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:1.9758479595184 / seconds
Query Executed:select id FROM `ia` where city='Maynard' && SIC_code='5531'DB:business_master_new
loadtime:1.9772939682007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Callsburg' limit 1
loadtime:1.9774038791656 / seconds
Query Executed:select id FROM `ia` where city='Mc Callsburg' && SIC_code='5531'DB:business_master_new
loadtime:1.9803688526154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Causland' limit 1
loadtime:1.9804179668427 / seconds
Query Executed:select id FROM `ia` where city='Mc Causland' && SIC_code='5531'DB:business_master_new
loadtime:1.9808149337769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clelland' limit 1
loadtime:1.9808468818665 / seconds
Query Executed:select id FROM `ia` where city='Mc Clelland' && SIC_code='5531'DB:business_master_new
loadtime:1.9815549850464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gregor' limit 1
loadtime:1.9816269874573 / seconds
Query Executed:select id FROM `ia` where city='Mc Gregor' && SIC_code='5531'DB:business_master_new
loadtime:1.9822239875793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intire' limit 1
loadtime:1.9822728633881 / seconds
Query Executed:select id FROM `ia` where city='Mc Intire' && SIC_code='5531'DB:business_master_new
loadtime:1.982766866684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:1.9828019142151 / seconds
Query Executed:select id FROM `ia` where city='Mechanicsville' && SIC_code='5531'DB:business_master_new
loadtime:1.983381986618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mediapolis' limit 1
loadtime:1.9834380149841 / seconds
Query Executed:select id FROM `ia` where city='Mediapolis' && SIC_code='5531'DB:business_master_new
loadtime:1.9840898513794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melbourne' limit 1
loadtime:1.9841339588165 / seconds
Query Executed:select id FROM `ia` where city='Melbourne' && SIC_code='5531'DB:business_master_new
loadtime:1.9856798648834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melcher' limit 1
loadtime:1.9858129024506 / seconds
Query Executed:select id FROM `ia` where city='Melcher' && SIC_code='5531'DB:business_master_new
loadtime:1.9873118400574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.9873609542847 / seconds
Query Executed:select id FROM `ia` where city='Melrose' && SIC_code='5531'DB:business_master_new
loadtime:1.9890370368958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:1.9891619682312 / seconds
Query Executed:select id FROM `ia` where city='Melvin' && SIC_code='5531'DB:business_master_new
loadtime:1.9910418987274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menlo' limit 1
loadtime:1.9911689758301 / seconds
Query Executed:select id FROM `ia` where city='Menlo' && SIC_code='5531'DB:business_master_new
loadtime:1.9927799701691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:1.9929089546204 / seconds
Query Executed:select id FROM `ia` where city='Meriden' && SIC_code='5531'DB:business_master_new
loadtime:1.994127035141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:1.9942538738251 / seconds
Query Executed:select id FROM `ia` where city='Merrill' && SIC_code='5531'DB:business_master_new
loadtime:1.9958639144897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meservey' limit 1
loadtime:1.9959969520569 / seconds
Query Executed:select id FROM `ia` where city='Meservey' && SIC_code='5531'DB:business_master_new
loadtime:1.9973800182343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Amana' limit 1
loadtime:1.9975109100342 / seconds
Query Executed:select id FROM `ia` where city='Middle Amana' && SIC_code='5531'DB:business_master_new
loadtime:1.999410867691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:1.999489068985 / seconds
Query Executed:select id FROM `ia` where city='Middletown' && SIC_code='5531'DB:business_master_new
loadtime:2.0006718635559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miles' limit 1
loadtime:2.000804901123 / seconds
Query Executed:select id FROM `ia` where city='Miles' && SIC_code='5531'DB:business_master_new
loadtime:2.0023980140686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:2.0025398731232 / seconds
Query Executed:select id FROM `ia` where city='Milford' && SIC_code='5531'DB:business_master_new
loadtime:2.004467010498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:2.0046000480652 / seconds
Query Executed:select id FROM `ia` where city='Millersburg' && SIC_code='5531'DB:business_master_new
loadtime:2.0054960250854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millerton' limit 1
loadtime:2.0055508613586 / seconds
Query Executed:select id FROM `ia` where city='Millerton' && SIC_code='5531'DB:business_master_new
loadtime:2.0060110092163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milo' limit 1
loadtime:2.0060620307922 / seconds
Query Executed:select id FROM `ia` where city='Milo' && SIC_code='5531'DB:business_master_new
loadtime:2.0073120594025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:2.0074388980865 / seconds
Query Executed:select id FROM `ia` where city='Milton' && SIC_code='5531'DB:business_master_new
loadtime:2.0093698501587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minburn' limit 1
loadtime:2.0094048976898 / seconds
Query Executed:select id FROM `ia` where city='Minburn' && SIC_code='5531'DB:business_master_new
loadtime:2.0105199813843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden' limit 1
loadtime:2.0107309818268 / seconds
Query Executed:select id FROM `ia` where city='Minden' && SIC_code='5531'DB:business_master_new
loadtime:2.0122668743134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineola' limit 1
loadtime:2.0124099254608 / seconds
Query Executed:select id FROM `ia` where city='Mineola' && SIC_code='5531'DB:business_master_new
loadtime:2.0134379863739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mingo' limit 1
loadtime:2.0135698318481 / seconds
Query Executed:select id FROM `ia` where city='Mingo' && SIC_code='5531'DB:business_master_new
loadtime:2.0151870250702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Missouri Valley' limit 1
loadtime:2.015282869339 / seconds
Query Executed:select id FROM `ia` where city='Missouri Valley' && SIC_code='5531'DB:business_master_new
loadtime:2.0172710418701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:2.0174210071564 / seconds
Query Executed:select id FROM `ia` where city='Mitchell' && SIC_code='5531'DB:business_master_new
loadtime:2.0181920528412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchellville' limit 1
loadtime:2.0183248519897 / seconds
Query Executed:select id FROM `ia` where city='Mitchellville' && SIC_code='5531'DB:business_master_new
loadtime:2.0198938846588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modale' limit 1
loadtime:2.020026922226 / seconds
Query Executed:select id FROM `ia` where city='Modale' && SIC_code='5531'DB:business_master_new
loadtime:2.0213298797607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondamin' limit 1
loadtime:2.0214259624481 / seconds
Query Executed:select id FROM `ia` where city='Mondamin' && SIC_code='5531'DB:business_master_new
loadtime:2.0230000019073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth' limit 1
loadtime:2.0231349468231 / seconds
Query Executed:select id FROM `ia` where city='Monmouth' && SIC_code='5531'DB:business_master_new
loadtime:2.0259630680084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:2.0260088443756 / seconds
Query Executed:select id FROM `ia` where city='Monona' && SIC_code='5531'DB:business_master_new
loadtime:2.0266180038452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:2.0266649723053 / seconds
Query Executed:select id FROM `ia` where city='Monroe' && SIC_code='5531'DB:business_master_new
loadtime:2.0272619724274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:2.027302980423 / seconds
Query Executed:select id FROM `ia` where city='Montezuma' && SIC_code='5531'DB:business_master_new
loadtime:2.0279350280762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:2.0279819965363 / seconds
Query Executed:select id FROM `ia` where city='Monticello' && SIC_code='5531'DB:business_master_new
loadtime:2.0287108421326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montour' limit 1
loadtime:2.0287568569183 / seconds
Query Executed:select id FROM `ia` where city='Montour' && SIC_code='5531'DB:business_master_new
loadtime:2.0291500091553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:2.0291829109192 / seconds
Query Executed:select id FROM `ia` where city='Montpelier' && SIC_code='5531'DB:business_master_new
loadtime:2.0294618606567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:2.0294859409332 / seconds
Query Executed:select id FROM `ia` where city='Montrose' && SIC_code='5531'DB:business_master_new
loadtime:2.0314509868622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:2.0314910411835 / seconds
Query Executed:select id FROM `ia` where city='Moorhead' && SIC_code='5531'DB:business_master_new
loadtime:2.0331590175629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorland' limit 1
loadtime:2.0332579612732 / seconds
Query Executed:select id FROM `ia` where city='Moorland' && SIC_code='5531'DB:business_master_new
loadtime:2.0354909896851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravia' limit 1
loadtime:2.035542011261 / seconds
Query Executed:select id FROM `ia` where city='Moravia' && SIC_code='5531'DB:business_master_new
loadtime:2.0360970497131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:2.0361359119415 / seconds
Query Executed:select id FROM `ia` where city='Morley' && SIC_code='5531'DB:business_master_new
loadtime:2.0367150306702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morning Sun' limit 1
loadtime:2.0367460250854 / seconds
Query Executed:select id FROM `ia` where city='Morning Sun' && SIC_code='5531'DB:business_master_new
loadtime:2.037309885025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:2.0373480319977 / seconds
Query Executed:select id FROM `ia` where city='Morrison' && SIC_code='5531'DB:business_master_new
loadtime:2.0377359390259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:2.0377728939056 / seconds
Query Executed:select id FROM `ia` where city='Moscow' && SIC_code='5531'DB:business_master_new
loadtime:2.0386810302734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moulton' limit 1
loadtime:2.0387060642242 / seconds
Query Executed:select id FROM `ia` where city='Moulton' && SIC_code='5531'DB:business_master_new
loadtime:2.0392248630524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Auburn' limit 1
loadtime:2.0392589569092 / seconds
Query Executed:select id FROM `ia` where city='Mount Auburn' && SIC_code='5531'DB:business_master_new
loadtime:2.0396928787231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ayr' limit 1
loadtime:2.03972697258 / seconds
Query Executed:select id FROM `ia` where city='Mount Ayr' && SIC_code='5531'DB:business_master_new
loadtime:2.0403509140015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:2.0403950214386 / seconds
Query Executed:select id FROM `ia` where city='Mount Pleasant' && SIC_code='5531'DB:business_master_new
loadtime:2.0412518978119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:2.0412969589233 / seconds
Query Executed:select id FROM `ia` where city='Mount Sterling' && SIC_code='5531'DB:business_master_new
loadtime:2.0416848659515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Union' limit 1
loadtime:2.0417199134827 / seconds
Query Executed:select id FROM `ia` where city='Mount Union' && SIC_code='5531'DB:business_master_new
loadtime:2.0422139167786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:2.0422439575195 / seconds
Query Executed:select id FROM `ia` where city='Mount Vernon' && SIC_code='5531'DB:business_master_new
loadtime:2.042867898941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moville' limit 1
loadtime:2.0428988933563 / seconds
Query Executed:select id FROM `ia` where city='Moville' && SIC_code='5531'DB:business_master_new
loadtime:2.043447971344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Auburn' limit 1
loadtime:2.0434858798981 / seconds
Query Executed:select id FROM `ia` where city='Mt Auburn' && SIC_code='5531'DB:business_master_new
loadtime:2.0437479019165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ayr' limit 1
loadtime:2.0437829494476 / seconds
Query Executed:select id FROM `ia` where city='Mt Ayr' && SIC_code='5531'DB:business_master_new
loadtime:2.0440430641174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:2.0440719127655 / seconds
Query Executed:select id FROM `ia` where city='Mt Pleasant' && SIC_code='5531'DB:business_master_new
loadtime:2.0444798469543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:2.0445158481598 / seconds
Query Executed:select id FROM `ia` where city='Mt Sterling' && SIC_code='5531'DB:business_master_new
loadtime:2.0447969436646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Union' limit 1
loadtime:2.0448269844055 / seconds
Query Executed:select id FROM `ia` where city='Mt Union' && SIC_code='5531'DB:business_master_new
loadtime:2.045156955719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:2.0451798439026 / seconds
Query Executed:select id FROM `ia` where city='Mt Vernon' && SIC_code='5531'DB:business_master_new
loadtime:2.0454790592194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:2.0455119609833 / seconds
Query Executed:select id FROM `ia` where city='Murray' && SIC_code='5531'DB:business_master_new
loadtime:2.0468089580536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscatine' limit 1
loadtime:2.046844959259 / seconds
Query Executed:select id FROM `ia` where city='Muscatine' && SIC_code='5531'DB:business_master_new
loadtime:2.0479340553284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:2.0479700565338 / seconds
Query Executed:select id FROM `ia` where city='Mystic' && SIC_code='5531'DB:business_master_new
loadtime:2.0484390258789 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Buena Vista' limit 1
loadtime:2.0484750270844 / seconds
Query Executed:select id FROM `ia` where city='N Buena Vista' && SIC_code='5531'DB:business_master_new
loadtime:2.0487508773804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:2.0487849712372 / seconds
Query Executed:select id FROM `ia` where city='Nashua' && SIC_code='5531'DB:business_master_new
loadtime:2.0494048595428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemaha' limit 1
loadtime:2.0494539737701 / seconds
Query Executed:select id FROM `ia` where city='Nemaha' && SIC_code='5531'DB:business_master_new
loadtime:2.0502560138702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:2.050304889679 / seconds
Query Executed:select id FROM `ia` where city='Neola' && SIC_code='5531'DB:business_master_new
loadtime:2.0509328842163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nevada' limit 1
loadtime:2.0509779453278 / seconds
Query Executed:select id FROM `ia` where city='Nevada' && SIC_code='5531'DB:business_master_new
loadtime:2.0516669750214 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albin' limit 1
loadtime:2.0517239570618 / seconds
Query Executed:select id FROM `ia` where city='New Albin' && SIC_code='5531'DB:business_master_new
loadtime:2.0523040294647 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:2.0523500442505 / seconds
Query Executed:select id FROM `ia` where city='New Hampton' && SIC_code='5531'DB:business_master_new
loadtime:2.0530669689178 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:2.0531229972839 / seconds
Query Executed:select id FROM `ia` where city='New Hartford' && SIC_code='5531'DB:business_master_new
loadtime:2.053701877594 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Liberty' limit 1
loadtime:2.0537300109863 / seconds
Query Executed:select id FROM `ia` where city='New Liberty' && SIC_code='5531'DB:business_master_new
loadtime:2.0542159080505 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:2.0542678833008 / seconds
Query Executed:select id FROM `ia` where city='New London' && SIC_code='5531'DB:business_master_new
loadtime:2.0548460483551 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:2.0548830032349 / seconds
Query Executed:select id FROM `ia` where city='New Market' && SIC_code='5531'DB:business_master_new
loadtime:2.0560309886932 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:2.0560898780823 / seconds
Query Executed:select id FROM `ia` where city='New Providence' && SIC_code='5531'DB:business_master_new
loadtime:2.0567209720612 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Sharon' limit 1
loadtime:2.0567538738251 / seconds
Query Executed:select id FROM `ia` where city='New Sharon' && SIC_code='5531'DB:business_master_new
loadtime:2.0573699474335 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vienna' limit 1
loadtime:2.0574209690094 / seconds
Query Executed:select id FROM `ia` where city='New Vienna' && SIC_code='5531'DB:business_master_new
loadtime:2.0580348968506 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Virginia' limit 1
loadtime:2.058070898056 / seconds
Query Executed:select id FROM `ia` where city='New Virginia' && SIC_code='5531'DB:business_master_new
loadtime:2.059494972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:2.0596859455109 / seconds
Query Executed:select id FROM `ia` where city='Newell' && SIC_code='5531'DB:business_master_new
loadtime:2.0611548423767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhall' limit 1
loadtime:2.0612120628357 / seconds
Query Executed:select id FROM `ia` where city='Newhall' && SIC_code='5531'DB:business_master_new
loadtime:2.0627179145813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:2.0628459453583 / seconds
Query Executed:select id FROM `ia` where city='Newton' && SIC_code='5531'DB:business_master_new
loadtime:2.065153837204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:2.0652680397034 / seconds
Query Executed:select id FROM `ia` where city='Nichols' && SIC_code='5531'DB:business_master_new
loadtime:2.0671629905701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nodaway' limit 1
loadtime:2.0672390460968 / seconds
Query Executed:select id FROM `ia` where city='Nodaway' && SIC_code='5531'DB:business_master_new
loadtime:2.0684449672699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora Springs' limit 1
loadtime:2.0685820579529 / seconds
Query Executed:select id FROM `ia` where city='Nora Springs' && SIC_code='5531'DB:business_master_new
loadtime:2.069965839386 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Buena Vista' limit 1
loadtime:2.0700829029083 / seconds
Query Executed:select id FROM `ia` where city='North Buena Vista' && SIC_code='5531'DB:business_master_new
loadtime:2.0708680152893 / seconds
Query loaded from cache:select * from geodata_geocity where city='North English' limit 1
loadtime:2.0709829330444 / seconds
Query Executed:select id FROM `ia` where city='North English' && SIC_code='5531'DB:business_master_new
loadtime:2.0725998878479 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Liberty' limit 1
loadtime:2.0727410316467 / seconds
Query Executed:select id FROM `ia` where city='North Liberty' && SIC_code='5531'DB:business_master_new
loadtime:2.0742838382721 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Washington' limit 1
loadtime:2.0744378566742 / seconds
Query Executed:select id FROM `ia` where city='North Washington' && SIC_code='5531'DB:business_master_new
loadtime:2.0752499103546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northboro' limit 1
loadtime:2.0753479003906 / seconds
Query Executed:select id FROM `ia` where city='Northboro' && SIC_code='5531'DB:business_master_new
loadtime:2.0764238834381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:2.0765500068665 / seconds
Query Executed:select id FROM `ia` where city='Northwood' && SIC_code='5531'DB:business_master_new
loadtime:2.0780289173126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:2.0781779289246 / seconds
Query Executed:select id FROM `ia` where city='Norwalk' && SIC_code='5531'DB:business_master_new
loadtime:2.0801010131836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:2.0802528858185 / seconds
Query Executed:select id FROM `ia` where city='Norway' && SIC_code='5531'DB:business_master_new
loadtime:2.0818688869476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Numa' limit 1
loadtime:2.0820038318634 / seconds
Query Executed:select id FROM `ia` where city='Numa' && SIC_code='5531'DB:business_master_new
loadtime:2.0828430652618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:2.0829820632935 / seconds
Query Executed:select id FROM `ia` where city='Oakdale' && SIC_code='5531'DB:business_master_new
loadtime:2.0838949680328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:2.0839910507202 / seconds
Query Executed:select id FROM `ia` where city='Oakland' && SIC_code='5531'DB:business_master_new
loadtime:2.0850958824158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:2.0851519107819 / seconds
Query Executed:select id FROM `ia` where city='Oakville' && SIC_code='5531'DB:business_master_new
loadtime:2.0863449573517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocheyedan' limit 1
loadtime:2.0864429473877 / seconds
Query Executed:select id FROM `ia` where city='Ocheyedan' && SIC_code='5531'DB:business_master_new
loadtime:2.0880558490753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odebolt' limit 1
loadtime:2.0881650447845 / seconds
Query Executed:select id FROM `ia` where city='Odebolt' && SIC_code='5531'DB:business_master_new
loadtime:2.0894720554352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelwein' limit 1
loadtime:2.089567899704 / seconds
Query Executed:select id FROM `ia` where city='Oelwein' && SIC_code='5531'DB:business_master_new
loadtime:2.0915548801422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:2.0917420387268 / seconds
Query Executed:select id FROM `ia` where city='Ogden' && SIC_code='5531'DB:business_master_new
loadtime:2.0931739807129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okoboji' limit 1
loadtime:2.093288898468 / seconds
Query Executed:select id FROM `ia` where city='Okoboji' && SIC_code='5531'DB:business_master_new
loadtime:2.0949120521545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olds' limit 1
loadtime:2.0950078964233 / seconds
Query Executed:select id FROM `ia` where city='Olds' && SIC_code='5531'DB:business_master_new
loadtime:2.0960810184479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:2.096214056015 / seconds
Query Executed:select id FROM `ia` where city='Olin' && SIC_code='5531'DB:business_master_new
loadtime:2.0975210666656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ollie' limit 1
loadtime:2.0976538658142 / seconds
Query Executed:select id FROM `ia` where city='Ollie' && SIC_code='5531'DB:business_master_new
loadtime:2.099534034729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onawa' limit 1
loadtime:2.0996968746185 / seconds
Query Executed:select id FROM `ia` where city='Onawa' && SIC_code='5531'DB:business_master_new
loadtime:2.1010620594025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onslow' limit 1
loadtime:2.1011199951172 / seconds
Query Executed:select id FROM `ia` where city='Onslow' && SIC_code='5531'DB:business_master_new
loadtime:2.1026439666748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oran' limit 1
loadtime:2.102756023407 / seconds
Query Executed:select id FROM `ia` where city='Oran' && SIC_code='5531'DB:business_master_new
loadtime:2.1041059494019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange City' limit 1
loadtime:2.1041560173035 / seconds
Query Executed:select id FROM `ia` where city='Orange City' && SIC_code='5531'DB:business_master_new
loadtime:2.1057200431824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:2.1058719158173 / seconds
Query Executed:select id FROM `ia` where city='Orchard' && SIC_code='5531'DB:business_master_new
loadtime:2.1074318885803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:2.1074810028076 / seconds
Query Executed:select id FROM `ia` where city='Orient' && SIC_code='5531'DB:business_master_new
loadtime:2.1092798709869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage' limit 1
loadtime:2.1093318462372 / seconds
Query Executed:select id FROM `ia` where city='Osage' && SIC_code='5531'DB:business_master_new
loadtime:2.110132932663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:2.1101908683777 / seconds
Query Executed:select id FROM `ia` where city='Osceola' && SIC_code='5531'DB:business_master_new
loadtime:2.1109590530396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oskaloosa' limit 1
loadtime:2.1110138893127 / seconds
Query Executed:select id FROM `ia` where city='Oskaloosa' && SIC_code='5531'DB:business_master_new
loadtime:2.1119239330292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossian' limit 1
loadtime:2.1119818687439 / seconds
Query Executed:select id FROM `ia` where city='Ossian' && SIC_code='5531'DB:business_master_new
loadtime:2.1125679016113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otho' limit 1
loadtime:2.112625837326 / seconds
Query Executed:select id FROM `ia` where city='Otho' && SIC_code='5531'DB:business_master_new
loadtime:2.1131448745728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otley' limit 1
loadtime:2.1131930351257 / seconds
Query Executed:select id FROM `ia` where city='Otley' && SIC_code='5531'DB:business_master_new
loadtime:2.1152548789978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oto' limit 1
loadtime:2.1152908802032 / seconds
Query Executed:select id FROM `ia` where city='Oto' && SIC_code='5531'DB:business_master_new
loadtime:2.1165268421173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottosen' limit 1
loadtime:2.116574048996 / seconds
Query Executed:select id FROM `ia` where city='Ottosen' && SIC_code='5531'DB:business_master_new
loadtime:2.1170179843903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottumwa' limit 1
loadtime:2.1170690059662 / seconds
Query Executed:select id FROM `ia` where city='Ottumwa' && SIC_code='5531'DB:business_master_new
loadtime:2.1181440353394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:2.1182038784027 / seconds
Query Executed:select id FROM `ia` where city='Oxford' && SIC_code='5531'DB:business_master_new
loadtime:2.1187670230865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford Junction' limit 1
loadtime:2.1188080310822 / seconds
Query Executed:select id FROM `ia` where city='Oxford Junction' && SIC_code='5531'DB:business_master_new
loadtime:2.1204879283905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyens' limit 1
loadtime:2.1205370426178 / seconds
Query Executed:select id FROM `ia` where city='Oyens' && SIC_code='5531'DB:business_master_new
loadtime:2.1208958625793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific Junction' limit 1
loadtime:2.1209318637848 / seconds
Query Executed:select id FROM `ia` where city='Pacific Junction' && SIC_code='5531'DB:business_master_new
loadtime:2.1218328475952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwood' limit 1
loadtime:2.1219708919525 / seconds
Query Executed:select id FROM `ia` where city='Packwood' && SIC_code='5531'DB:business_master_new
loadtime:2.1237120628357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:2.1238389015198 / seconds
Query Executed:select id FROM `ia` where city='Palmer' && SIC_code='5531'DB:business_master_new
loadtime:2.1259770393372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:2.1261129379272 / seconds
Query Executed:select id FROM `ia` where city='Palo' && SIC_code='5531'DB:business_master_new
loadtime:2.1277940273285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panama' limit 1
loadtime:2.1279208660126 / seconds
Query Executed:select id FROM `ia` where city='Panama' && SIC_code='5531'DB:business_master_new
loadtime:2.1305558681488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panora' limit 1
loadtime:2.1306879520416 / seconds
Query Executed:select id FROM `ia` where city='Panora' && SIC_code='5531'DB:business_master_new
loadtime:2.1324899196625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkersburg' limit 1
loadtime:2.132688999176 / seconds
Query Executed:select id FROM `ia` where city='Parkersburg' && SIC_code='5531'DB:business_master_new
loadtime:2.1340620517731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parnell' limit 1
loadtime:2.134222984314 / seconds
Query Executed:select id FROM `ia` where city='Parnell' && SIC_code='5531'DB:business_master_new
loadtime:2.1354908943176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paton' limit 1
loadtime:2.1355409622192 / seconds
Query Executed:select id FROM `ia` where city='Paton' && SIC_code='5531'DB:business_master_new
loadtime:2.1364469528198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:2.1366360187531 / seconds
Query Executed:select id FROM `ia` where city='Patterson' && SIC_code='5531'DB:business_master_new
loadtime:2.1371788978577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paullina' limit 1
loadtime:2.1372299194336 / seconds
Query Executed:select id FROM `ia` where city='Paullina' && SIC_code='5531'DB:business_master_new
loadtime:2.1388759613037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pella' limit 1
loadtime:2.1390080451965 / seconds
Query Executed:select id FROM `ia` where city='Pella' && SIC_code='5531'DB:business_master_new
loadtime:2.1411008834839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peosta' limit 1
loadtime:2.1411468982697 / seconds
Query Executed:select id FROM `ia` where city='Peosta' && SIC_code='5531'DB:business_master_new
loadtime:2.1427390575409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Percival' limit 1
loadtime:2.1428818702698 / seconds
Query Executed:select id FROM `ia` where city='Percival' && SIC_code='5531'DB:business_master_new
loadtime:2.1447339057922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:2.1447868347168 / seconds
Query Executed:select id FROM `ia` where city='Perry' && SIC_code='5531'DB:business_master_new
loadtime:2.1455528736115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Persia' limit 1
loadtime:2.1455969810486 / seconds
Query Executed:select id FROM `ia` where city='Persia' && SIC_code='5531'DB:business_master_new
loadtime:2.1461629867554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:2.1462199687958 / seconds
Query Executed:select id FROM `ia` where city='Peru' && SIC_code='5531'DB:business_master_new
loadtime:2.1466369628906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson' limit 1
loadtime:2.1466798782349 / seconds
Query Executed:select id FROM `ia` where city='Peterson' && SIC_code='5531'DB:business_master_new
loadtime:2.1472609043121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:2.1473150253296 / seconds
Query Executed:select id FROM `ia` where city='Pierson' && SIC_code='5531'DB:business_master_new
loadtime:2.1480040550232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Grove' limit 1
loadtime:2.1480450630188 / seconds
Query Executed:select id FROM `ia` where city='Pilot Grove' && SIC_code='5531'DB:business_master_new
loadtime:2.1483750343323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mound' limit 1
loadtime:2.1484248638153 / seconds
Query Executed:select id FROM `ia` where city='Pilot Mound' && SIC_code='5531'DB:business_master_new
loadtime:2.1488299369812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah' limit 1
loadtime:2.1488678455353 / seconds
Query Executed:select id FROM `ia` where city='Pisgah' && SIC_code='5531'DB:business_master_new
loadtime:2.1497728824615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:2.1498229503632 / seconds
Query Executed:select id FROM `ia` where city='Plainfield' && SIC_code='5531'DB:business_master_new
loadtime:2.1503899097443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plano' limit 1
loadtime:2.1504340171814 / seconds
Query Executed:select id FROM `ia` where city='Plano' && SIC_code='5531'DB:business_master_new
loadtime:2.1510050296783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:2.1510510444641 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Hill' && SIC_code='5531'DB:business_master_new
loadtime:2.1517310142517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:2.1517798900604 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Valley' && SIC_code='5531'DB:business_master_new
loadtime:2.1522219181061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasanton' limit 1
loadtime:2.1522660255432 / seconds
Query Executed:select id FROM `ia` where city='Pleasanton' && SIC_code='5531'DB:business_master_new
loadtime:2.1525230407715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:2.1525490283966 / seconds
Query Executed:select id FROM `ia` where city='Pleasantville' && SIC_code='5531'DB:business_master_new
loadtime:2.1531660556793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:2.1532249450684 / seconds
Query Executed:select id FROM `ia` where city='Plover' && SIC_code='5531'DB:business_master_new
loadtime:2.15389585495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:2.1539459228516 / seconds
Query Executed:select id FROM `ia` where city='Plymouth' && SIC_code='5531'DB:business_master_new
loadtime:2.1556358337402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:2.1557660102844 / seconds
Query Executed:select id FROM `ia` where city='Pocahontas' && SIC_code='5531'DB:business_master_new
loadtime:2.1570730209351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polk City' limit 1
loadtime:2.1571218967438 / seconds
Query Executed:select id FROM `ia` where city='Polk City' && SIC_code='5531'DB:business_master_new
loadtime:2.1580979824066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomeroy' limit 1
loadtime:2.1581480503082 / seconds
Query Executed:select id FROM `ia` where city='Pomeroy' && SIC_code='5531'DB:business_master_new
loadtime:2.1597399711609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Popejoy' limit 1
loadtime:2.1598720550537 / seconds
Query Executed:select id FROM `ia` where city='Popejoy' && SIC_code='5531'DB:business_master_new
loadtime:2.1608300209045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:2.1609408855438 / seconds
Query Executed:select id FROM `ia` where city='Portsmouth' && SIC_code='5531'DB:business_master_new
loadtime:2.161957025528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Postville' limit 1
loadtime:2.1619999408722 / seconds
Query Executed:select id FROM `ia` where city='Postville' && SIC_code='5531'DB:business_master_new
loadtime:2.1626238822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:2.1626689434052 / seconds
Query Executed:select id FROM `ia` where city='Prairie City' && SIC_code='5531'DB:business_master_new
loadtime:2.1632349491119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairieburg' limit 1
loadtime:2.1632668972015 / seconds
Query Executed:select id FROM `ia` where city='Prairieburg' && SIC_code='5531'DB:business_master_new
loadtime:2.1640498638153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:2.1640999317169 / seconds
Query Executed:select id FROM `ia` where city='Prescott' && SIC_code='5531'DB:business_master_new
loadtime:2.1650550365448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:2.1651060581207 / seconds
Query Executed:select id FROM `ia` where city='Preston' && SIC_code='5531'DB:business_master_new
loadtime:2.1665160655975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Primghar' limit 1
loadtime:2.1666510105133 / seconds
Query Executed:select id FROM `ia` where city='Primghar' && SIC_code='5531'DB:business_master_new
loadtime:2.168310880661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:2.1683459281921 / seconds
Query Executed:select id FROM `ia` where city='Princeton' && SIC_code='5531'DB:business_master_new
loadtime:2.1695909500122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prole' limit 1
loadtime:2.1697590351105 / seconds
Query Executed:select id FROM `ia` where city='Prole' && SIC_code='5531'DB:business_master_new
loadtime:2.1716339588165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Promise City' limit 1
loadtime:2.1717488765717 / seconds
Query Executed:select id FROM `ia` where city='Promise City' && SIC_code='5531'DB:business_master_new
loadtime:2.1727950572968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Protivin' limit 1
loadtime:2.1729328632355 / seconds
Query Executed:select id FROM `ia` where city='Protivin' && SIC_code='5531'DB:business_master_new
loadtime:2.1738328933716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:2.1739609241486 / seconds
Query Executed:select id FROM `ia` where city='Pulaski' && SIC_code='5531'DB:business_master_new
loadtime:2.1752409934998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quasqueton' limit 1
loadtime:2.1753790378571 / seconds
Query Executed:select id FROM `ia` where city='Quasqueton' && SIC_code='5531'DB:business_master_new
loadtime:2.1767718791962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quimby' limit 1
loadtime:2.1768078804016 / seconds
Query Executed:select id FROM `ia` where city='Quimby' && SIC_code='5531'DB:business_master_new
loadtime:2.1799378395081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radcliffe' limit 1
loadtime:2.1799938678741 / seconds
Query Executed:select id FROM `ia` where city='Radcliffe' && SIC_code='5531'DB:business_master_new
loadtime:2.1805779933929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rake' limit 1
loadtime:2.1806309223175 / seconds
Query Executed:select id FROM `ia` where city='Rake' && SIC_code='5531'DB:business_master_new
loadtime:2.1813218593597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralston' limit 1
loadtime:2.1814608573914 / seconds
Query Executed:select id FROM `ia` where city='Ralston' && SIC_code='5531'DB:business_master_new
loadtime:2.1824150085449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randalia' limit 1
loadtime:2.1825530529022 / seconds
Query Executed:select id FROM `ia` where city='Randalia' && SIC_code='5531'DB:business_master_new
loadtime:2.1837170124054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randall' limit 1
loadtime:2.1838488578796 / seconds
Query Executed:select id FROM `ia` where city='Randall' && SIC_code='5531'DB:business_master_new
loadtime:2.1846950054169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:2.184730052948 / seconds
Query Executed:select id FROM `ia` where city='Randolph' && SIC_code='5531'DB:business_master_new
loadtime:2.1851780414581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:2.1853079795837 / seconds
Query Executed:select id FROM `ia` where city='Raymond' && SIC_code='5531'DB:business_master_new
loadtime:2.1865119934082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readlyn' limit 1
loadtime:2.1866779327393 / seconds
Query Executed:select id FROM `ia` where city='Readlyn' && SIC_code='5531'DB:business_master_new
loadtime:2.1883299350739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reasnor' limit 1
loadtime:2.1884870529175 / seconds
Query Executed:select id FROM `ia` where city='Reasnor' && SIC_code='5531'DB:business_master_new
loadtime:2.1897599697113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:2.1898720264435 / seconds
Query Executed:select id FROM `ia` where city='Red Oak' && SIC_code='5531'DB:business_master_new
loadtime:2.1919469833374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:2.192106962204 / seconds
Query Executed:select id FROM `ia` where city='Redding' && SIC_code='5531'DB:business_master_new
loadtime:2.1931068897247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:2.193167924881 / seconds
Query Executed:select id FROM `ia` where city='Redfield' && SIC_code='5531'DB:business_master_new
loadtime:2.1946759223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reinbeck' limit 1
loadtime:2.1948099136353 / seconds
Query Executed:select id FROM `ia` where city='Reinbeck' && SIC_code='5531'DB:business_master_new
loadtime:2.1965680122375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembrandt' limit 1
loadtime:2.1967358589172 / seconds
Query Executed:select id FROM `ia` where city='Rembrandt' && SIC_code='5531'DB:business_master_new
loadtime:2.1978590488434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remsen' limit 1
loadtime:2.1980049610138 / seconds
Query Executed:select id FROM `ia` where city='Remsen' && SIC_code='5531'DB:business_master_new
loadtime:2.1998360157013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renwick' limit 1
loadtime:2.1999909877777 / seconds
Query Executed:select id FROM `ia` where city='Renwick' && SIC_code='5531'DB:business_master_new
loadtime:2.2017228603363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:2.2018020153046 / seconds
Query Executed:select id FROM `ia` where city='Rhodes' && SIC_code='5531'DB:business_master_new
loadtime:2.2029809951782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riceville' limit 1
loadtime:2.2031278610229 / seconds
Query Executed:select id FROM `ia` where city='Riceville' && SIC_code='5531'DB:business_master_new
loadtime:2.2048530578613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:2.205267906189 / seconds
Query Executed:select id FROM `ia` where city='Richland' && SIC_code='5531'DB:business_master_new
loadtime:2.2065749168396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ricketts' limit 1
loadtime:2.2067248821259 / seconds
Query Executed:select id FROM `ia` where city='Ricketts' && SIC_code='5531'DB:business_master_new
loadtime:2.2075889110565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:2.2077689170837 / seconds
Query Executed:select id FROM `ia` where city='Ridgeway' && SIC_code='5531'DB:business_master_new
loadtime:2.2093749046326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringsted' limit 1
loadtime:2.2095098495483 / seconds
Query Executed:select id FROM `ia` where city='Ringsted' && SIC_code='5531'DB:business_master_new
loadtime:2.2111179828644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rippey' limit 1
loadtime:2.2112510204315 / seconds
Query Executed:select id FROM `ia` where city='Rippey' && SIC_code='5531'DB:business_master_new
loadtime:2.2127230167389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:2.2128548622131 / seconds
Query Executed:select id FROM `ia` where city='Riverdale' && SIC_code='5531'DB:business_master_new
loadtime:2.2137808799744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:2.2139089107513 / seconds
Query Executed:select id FROM `ia` where city='Riverside' && SIC_code='5531'DB:business_master_new
loadtime:2.2156529426575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:2.2158060073853 / seconds
Query Executed:select id FROM `ia` where city='Riverton' && SIC_code='5531'DB:business_master_new
loadtime:2.2168090343475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robins' limit 1
loadtime:2.2169070243835 / seconds
Query Executed:select id FROM `ia` where city='Robins' && SIC_code='5531'DB:business_master_new
loadtime:2.2181849479675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:2.2182319164276 / seconds
Query Executed:select id FROM `ia` where city='Rock Falls' && SIC_code='5531'DB:business_master_new
loadtime:2.2188289165497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Rapids' limit 1
loadtime:2.2189290523529 / seconds
Query Executed:select id FROM `ia` where city='Rock Rapids' && SIC_code='5531'DB:business_master_new
loadtime:2.2207679748535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Valley' limit 1
loadtime:2.2208869457245 / seconds
Query Executed:select id FROM `ia` where city='Rock Valley' && SIC_code='5531'DB:business_master_new
loadtime:2.2224929332733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:2.2226819992065 / seconds
Query Executed:select id FROM `ia` where city='Rockford' && SIC_code='5531'DB:business_master_new
loadtime:2.2243330478668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:2.224485874176 / seconds
Query Executed:select id FROM `ia` where city='Rockwell' && SIC_code='5531'DB:business_master_new
loadtime:2.226222038269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell City' limit 1
loadtime:2.2263538837433 / seconds
Query Executed:select id FROM `ia` where city='Rockwell City' && SIC_code='5531'DB:business_master_new
loadtime:2.2281708717346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:2.228325843811 / seconds
Query Executed:select id FROM `ia` where city='Rodney' && SIC_code='5531'DB:business_master_new
loadtime:2.2292869091034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roland' limit 1
loadtime:2.2293980121613 / seconds
Query Executed:select id FROM `ia` where city='Roland' && SIC_code='5531'DB:business_master_new
loadtime:2.2311279773712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolfe' limit 1
loadtime:2.2312638759613 / seconds
Query Executed:select id FROM `ia` where city='Rolfe' && SIC_code='5531'DB:business_master_new
loadtime:2.2328958511353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:2.2330770492554 / seconds
Query Executed:select id FROM `ia` where city='Rome' && SIC_code='5531'DB:business_master_new
loadtime:2.2338469028473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:2.2339539527893 / seconds
Query Executed:select id FROM `ia` where city='Rose Hill' && SIC_code='5531'DB:business_master_new
loadtime:2.2351298332214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowan' limit 1
loadtime:2.2352628707886 / seconds
Query Executed:select id FROM `ia` where city='Rowan' && SIC_code='5531'DB:business_master_new
loadtime:2.2363178730011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:2.2364280223846 / seconds
Query Executed:select id FROM `ia` where city='Rowley' && SIC_code='5531'DB:business_master_new
loadtime:2.2386560440063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal' limit 1
loadtime:2.2387080192566 / seconds
Query Executed:select id FROM `ia` where city='Royal' && SIC_code='5531'DB:business_master_new
loadtime:2.2392630577087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudd' limit 1
loadtime:2.2393100261688 / seconds
Query Executed:select id FROM `ia` where city='Rudd' && SIC_code='5531'DB:business_master_new
loadtime:2.2398948669434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnells' limit 1
loadtime:2.2399299144745 / seconds
Query Executed:select id FROM `ia` where city='Runnells' && SIC_code='5531'DB:business_master_new
loadtime:2.2405219078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:2.2405710220337 / seconds
Query Executed:select id FROM `ia` where city='Russell' && SIC_code='5531'DB:business_master_new
loadtime:2.2411940097809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthven' limit 1
loadtime:2.2412519454956 / seconds
Query Executed:select id FROM `ia` where city='Ruthven' && SIC_code='5531'DB:business_master_new
loadtime:2.241828918457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:2.2418689727783 / seconds
Query Executed:select id FROM `ia` where city='Rutland' && SIC_code='5531'DB:business_master_new
loadtime:2.2427089214325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryan' limit 1
loadtime:2.2427449226379 / seconds
Query Executed:select id FROM `ia` where city='Ryan' && SIC_code='5531'DB:business_master_new
loadtime:2.2434198856354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sabula' limit 1
loadtime:2.2434689998627 / seconds
Query Executed:select id FROM `ia` where city='Sabula' && SIC_code='5531'DB:business_master_new
loadtime:2.2440509796143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sac City' limit 1
loadtime:2.2440869808197 / seconds
Query Executed:select id FROM `ia` where city='Sac City' && SIC_code='5531'DB:business_master_new
loadtime:2.2447409629822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ansgar' limit 1
loadtime:2.2447929382324 / seconds
Query Executed:select id FROM `ia` where city='Saint Ansgar' && SIC_code='5531'DB:business_master_new
loadtime:2.2454040050507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Anthony' limit 1
loadtime:2.2454569339752 / seconds
Query Executed:select id FROM `ia` where city='Saint Anthony' && SIC_code='5531'DB:business_master_new
loadtime:2.2459359169006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:2.2459828853607 / seconds
Query Executed:select id FROM `ia` where city='Saint Charles' && SIC_code='5531'DB:business_master_new
loadtime:2.2465839385986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Donatus' limit 1
loadtime:2.2466368675232 / seconds
Query Executed:select id FROM `ia` where city='Saint Donatus' && SIC_code='5531'DB:business_master_new
loadtime:2.2470059394836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Marys' limit 1
loadtime:2.2470529079437 / seconds
Query Executed:select id FROM `ia` where city='Saint Marys' && SIC_code='5531'DB:business_master_new
loadtime:2.2474150657654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Olaf' limit 1
loadtime:2.2474520206451 / seconds
Query Executed:select id FROM `ia` where city='Saint Olaf' && SIC_code='5531'DB:business_master_new
loadtime:2.247918844223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:2.247969865799 / seconds
Query Executed:select id FROM `ia` where city='Saint Paul' && SIC_code='5531'DB:business_master_new
loadtime:2.2483260631561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.2483608722687 / seconds
Query Executed:select id FROM `ia` where city='Salem' && SIC_code='5531'DB:business_master_new
loadtime:2.2489569187164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salix' limit 1
loadtime:2.2489929199219 / seconds
Query Executed:select id FROM `ia` where city='Salix' && SIC_code='5531'DB:business_master_new
loadtime:2.2495410442352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanborn' limit 1
loadtime:2.2495939731598 / seconds
Query Executed:select id FROM `ia` where city='Sanborn' && SIC_code='5531'DB:business_master_new
loadtime:2.2502119541168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scarville' limit 1
loadtime:2.2502708435059 / seconds
Query Executed:select id FROM `ia` where city='Scarville' && SIC_code='5531'DB:business_master_new
loadtime:2.2506718635559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schaller' limit 1
loadtime:2.2506999969482 / seconds
Query Executed:select id FROM `ia` where city='Schaller' && SIC_code='5531'DB:business_master_new
loadtime:2.2512910366058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schleswig' limit 1
loadtime:2.2513480186462 / seconds
Query Executed:select id FROM `ia` where city='Schleswig' && SIC_code='5531'DB:business_master_new
loadtime:2.2519450187683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Grove' limit 1
loadtime:2.2519869804382 / seconds
Query Executed:select id FROM `ia` where city='Scotch Grove' && SIC_code='5531'DB:business_master_new
loadtime:2.2522299289703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:2.2522718906403 / seconds
Query Executed:select id FROM `ia` where city='Scranton' && SIC_code='5531'DB:business_master_new
loadtime:2.2528069019318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Searsboro' limit 1
loadtime:2.2528438568115 / seconds
Query Executed:select id FROM `ia` where city='Searsboro' && SIC_code='5531'DB:business_master_new
loadtime:2.2532908916473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:2.2533268928528 / seconds
Query Executed:select id FROM `ia` where city='Selma' && SIC_code='5531'DB:business_master_new
loadtime:2.253634929657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeant Bluff' limit 1
loadtime:2.2536778450012 / seconds
Query Executed:select id FROM `ia` where city='Sergeant Bluff' && SIC_code='5531'DB:business_master_new
loadtime:2.2542939186096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:2.2543368339539 / seconds
Query Executed:select id FROM `ia` where city='Seymour' && SIC_code='5531'DB:business_master_new
loadtime:2.2549378871918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shambaugh' limit 1
loadtime:2.2549810409546 / seconds
Query Executed:select id FROM `ia` where city='Shambaugh' && SIC_code='5531'DB:business_master_new
loadtime:2.2553000450134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon City' limit 1
loadtime:2.2553498744965 / seconds
Query Executed:select id FROM `ia` where city='Shannon City' && SIC_code='5531'DB:business_master_new
loadtime:2.2558538913727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:2.2558920383453 / seconds
Query Executed:select id FROM `ia` where city='Sharpsburg' && SIC_code='5531'DB:business_master_new
loadtime:2.256217956543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:2.2562639713287 / seconds
Query Executed:select id FROM `ia` where city='Sheffield' && SIC_code='5531'DB:business_master_new
loadtime:2.2569110393524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:2.2569580078125 / seconds
Query Executed:select id FROM `ia` where city='Shelby' && SIC_code='5531'DB:business_master_new
loadtime:2.2575159072876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldahl' limit 1
loadtime:2.2575569152832 / seconds
Query Executed:select id FROM `ia` where city='Sheldahl' && SIC_code='5531'DB:business_master_new
loadtime:2.2578489780426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:2.2578859329224 / seconds
Query Executed:select id FROM `ia` where city='Sheldon' && SIC_code='5531'DB:business_master_new
loadtime:2.2585780620575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Rock' limit 1
loadtime:2.258651971817 / seconds
Query Executed:select id FROM `ia` where city='Shell Rock' && SIC_code='5531'DB:business_master_new
loadtime:2.2592539787292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shellsburg' limit 1
loadtime:2.2593009471893 / seconds
Query Executed:select id FROM `ia` where city='Shellsburg' && SIC_code='5531'DB:business_master_new
loadtime:2.2598929405212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:2.2599289417267 / seconds
Query Executed:select id FROM `ia` where city='Shenandoah' && SIC_code='5531'DB:business_master_new
loadtime:2.2606589794159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrill' limit 1
loadtime:2.2607178688049 / seconds
Query Executed:select id FROM `ia` where city='Sherrill' && SIC_code='5531'DB:business_master_new
loadtime:2.2613258361816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:2.2613739967346 / seconds
Query Executed:select id FROM `ia` where city='Sibley' && SIC_code='5531'DB:business_master_new
loadtime:2.2620320320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:2.2620918750763 / seconds
Query Executed:select id FROM `ia` where city='Sidney' && SIC_code='5531'DB:business_master_new
loadtime:2.2626760005951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigourney' limit 1
loadtime:2.2627198696136 / seconds
Query Executed:select id FROM `ia` where city='Sigourney' && SIC_code='5531'DB:business_master_new
loadtime:2.2633650302887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:2.2634198665619 / seconds
Query Executed:select id FROM `ia` where city='Silver City' && SIC_code='5531'DB:business_master_new
loadtime:2.2638850212097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Center' limit 1
loadtime:2.2639219760895 / seconds
Query Executed:select id FROM `ia` where city='Sioux Center' && SIC_code='5531'DB:business_master_new
loadtime:2.2646489143372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux City' limit 1
loadtime:2.2647058963776 / seconds
Query Executed:select id FROM `ia` where city='Sioux City' && SIC_code='5531'DB:business_master_new
loadtime:2.2679018974304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Rapids' limit 1
loadtime:2.2680718898773 / seconds
Query Executed:select id FROM `ia` where city='Sioux Rapids' && SIC_code='5531'DB:business_master_new
loadtime:2.2690989971161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:2.2691569328308 / seconds
Query Executed:select id FROM `ia` where city='Slater' && SIC_code='5531'DB:business_master_new
loadtime:2.2704570293427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sloan' limit 1
loadtime:2.2705008983612 / seconds
Query Executed:select id FROM `ia` where city='Sloan' && SIC_code='5531'DB:business_master_new
loadtime:2.2720310688019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithland' limit 1
loadtime:2.2720868587494 / seconds
Query Executed:select id FROM `ia` where city='Smithland' && SIC_code='5531'DB:business_master_new
loadtime:2.273120880127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldier' limit 1
loadtime:2.2731719017029 / seconds
Query Executed:select id FROM `ia` where city='Soldier' && SIC_code='5531'DB:business_master_new
loadtime:2.2741420269012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon' limit 1
loadtime:2.2741830348969 / seconds
Query Executed:select id FROM `ia` where city='Solon' && SIC_code='5531'DB:business_master_new
loadtime:2.2748169898987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:2.2748608589172 / seconds
Query Executed:select id FROM `ia` where city='Somers' && SIC_code='5531'DB:business_master_new
loadtime:2.2753410339355 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amana' limit 1
loadtime:2.2753880023956 / seconds
Query Executed:select id FROM `ia` where city='South Amana' && SIC_code='5531'DB:business_master_new
loadtime:2.2758958339691 / seconds
Query loaded from cache:select * from geodata_geocity where city='South English' limit 1
loadtime:2.2759318351746 / seconds
Query Executed:select id FROM `ia` where city='South English' && SIC_code='5531'DB:business_master_new
loadtime:2.2765378952026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.2765860557556 / seconds
Query Executed:select id FROM `ia` where city='Spencer' && SIC_code='5531'DB:business_master_new
loadtime:2.2775149345398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperry' limit 1
loadtime:2.2777190208435 / seconds
Query Executed:select id FROM `ia` where city='Sperry' && SIC_code='5531'DB:business_master_new
loadtime:2.278872013092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spillville' limit 1
loadtime:2.2789130210876 / seconds
Query Executed:select id FROM `ia` where city='Spillville' && SIC_code='5531'DB:business_master_new
loadtime:2.2800278663635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spirit Lake' limit 1
loadtime:2.2801229953766 / seconds
Query Executed:select id FROM `ia` where city='Spirit Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.2819180488586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spragueville' limit 1
loadtime:2.2819650173187 / seconds
Query Executed:select id FROM `ia` where city='Spragueville' && SIC_code='5531'DB:business_master_new
loadtime:2.2830469608307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:2.2831799983978 / seconds
Query Executed:select id FROM `ia` where city='Springbrook' && SIC_code='5531'DB:business_master_new
loadtime:2.2838790416718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:2.2839820384979 / seconds
Query Executed:select id FROM `ia` where city='Springville' && SIC_code='5531'DB:business_master_new
loadtime:2.2853238582611 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ansgar' limit 1
loadtime:2.2854290008545 / seconds
Query Executed:select id FROM `ia` where city='St Ansgar' && SIC_code='5531'DB:business_master_new
loadtime:2.2862510681152 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Anthony' limit 1
loadtime:2.2863829135895 / seconds
Query Executed:select id FROM `ia` where city='St Anthony' && SIC_code='5531'DB:business_master_new
loadtime:2.2869639396667 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:2.287013053894 / seconds
Query Executed:select id FROM `ia` where city='St Charles' && SIC_code='5531'DB:business_master_new
loadtime:2.2876670360565 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Donatus' limit 1
loadtime:2.2877628803253 / seconds
Query Executed:select id FROM `ia` where city='St Donatus' && SIC_code='5531'DB:business_master_new
loadtime:2.2884569168091 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lucas' limit 1
loadtime:2.2885630130768 / seconds
Query Executed:select id FROM `ia` where city='St Lucas' && SIC_code='5531'DB:business_master_new
loadtime:2.2888519763947 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Marys' limit 1
loadtime:2.2889938354492 / seconds
Query Executed:select id FROM `ia` where city='St Marys' && SIC_code='5531'DB:business_master_new
loadtime:2.2892098426819 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Olaf' limit 1
loadtime:2.2892789840698 / seconds
Query Executed:select id FROM `ia` where city='St Olaf' && SIC_code='5531'DB:business_master_new
loadtime:2.2900068759918 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:2.2901389598846 / seconds
Query Executed:select id FROM `ia` where city='St Paul' && SIC_code='5531'DB:business_master_new
loadtime:2.2904229164124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacyville' limit 1
loadtime:2.2905130386353 / seconds
Query Executed:select id FROM `ia` where city='Stacyville' && SIC_code='5531'DB:business_master_new
loadtime:2.2919449806213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:2.2919809818268 / seconds
Query Executed:select id FROM `ia` where city='Stanhope' && SIC_code='5531'DB:business_master_new
loadtime:2.293566942215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:2.2936508655548 / seconds
Query Executed:select id FROM `ia` where city='Stanley' && SIC_code='5531'DB:business_master_new
loadtime:2.2944400310516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:2.2945568561554 / seconds
Query Executed:select id FROM `ia` where city='Stanton' && SIC_code='5531'DB:business_master_new
loadtime:2.2958559989929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:2.2959969043732 / seconds
Query Executed:select id FROM `ia` where city='Stanwood' && SIC_code='5531'DB:business_master_new
loadtime:2.2978558540344 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Center' limit 1
loadtime:2.2979068756104 / seconds
Query Executed:select id FROM `ia` where city='State Center' && SIC_code='5531'DB:business_master_new
loadtime:2.2990999221802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Rock' limit 1
loadtime:2.299213886261 / seconds
Query Executed:select id FROM `ia` where city='Steamboat Rock' && SIC_code='5531'DB:business_master_new
loadtime:2.3004319667816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockport' limit 1
loadtime:2.3005659580231 / seconds
Query Executed:select id FROM `ia` where city='Stockport' && SIC_code='5531'DB:business_master_new
loadtime:2.3020889759064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:2.3022398948669 / seconds
Query Executed:select id FROM `ia` where city='Stockton' && SIC_code='5531'DB:business_master_new
loadtime:2.3036448955536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storm Lake' limit 1
loadtime:2.3036959171295 / seconds
Query Executed:select id FROM `ia` where city='Storm Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.3053598403931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Story City' limit 1
loadtime:2.3055109977722 / seconds
Query Executed:select id FROM `ia` where city='Story City' && SIC_code='5531'DB:business_master_new
loadtime:2.3070888519287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stout' limit 1
loadtime:2.3072500228882 / seconds
Query Executed:select id FROM `ia` where city='Stout' && SIC_code='5531'DB:business_master_new
loadtime:2.3080940246582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:2.3082048892975 / seconds
Query Executed:select id FROM `ia` where city='Stratford' && SIC_code='5531'DB:business_master_new
loadtime:2.3094580173492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry Point' limit 1
loadtime:2.3095889091492 / seconds
Query Executed:select id FROM `ia` where city='Strawberry Point' && SIC_code='5531'DB:business_master_new
loadtime:2.3109629154205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:2.3110918998718 / seconds
Query Executed:select id FROM `ia` where city='Stuart' && SIC_code='5531'DB:business_master_new
loadtime:2.3124029636383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sully' limit 1
loadtime:2.3125219345093 / seconds
Query Executed:select id FROM `ia` where city='Sully' && SIC_code='5531'DB:business_master_new
loadtime:2.3137629032135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:2.3139119148254 / seconds
Query Executed:select id FROM `ia` where city='Sumner' && SIC_code='5531'DB:business_master_new
loadtime:2.31547498703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:2.315593957901 / seconds
Query Executed:select id FROM `ia` where city='Superior' && SIC_code='5531'DB:business_master_new
loadtime:2.3166930675507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:2.3167638778687 / seconds
Query Executed:select id FROM `ia` where city='Sutherland' && SIC_code='5531'DB:business_master_new
loadtime:2.3181159496307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swaledale' limit 1
loadtime:2.3182339668274 / seconds
Query Executed:select id FROM `ia` where city='Swaledale' && SIC_code='5531'DB:business_master_new
loadtime:2.3189640045166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan' limit 1
loadtime:2.3190760612488 / seconds
Query Executed:select id FROM `ia` where city='Swan' && SIC_code='5531'DB:business_master_new
loadtime:2.3199150562286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swea City' limit 1
loadtime:2.3200469017029 / seconds
Query Executed:select id FROM `ia` where city='Swea City' && SIC_code='5531'DB:business_master_new
loadtime:2.3211090564728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesburg' limit 1
loadtime:2.3211460113525 / seconds
Query Executed:select id FROM `ia` where city='Swedesburg' && SIC_code='5531'DB:business_master_new
loadtime:2.3218338489532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swisher' limit 1
loadtime:2.3218770027161 / seconds
Query Executed:select id FROM `ia` where city='Swisher' && SIC_code='5531'DB:business_master_new
loadtime:2.3233609199524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:2.323401927948 / seconds
Query Executed:select id FROM `ia` where city='Tabor' && SIC_code='5531'DB:business_master_new
loadtime:2.3247179985046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taintor' limit 1
loadtime:2.3248748779297 / seconds
Query Executed:select id FROM `ia` where city='Taintor' && SIC_code='5531'DB:business_master_new
loadtime:2.325325012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tama' limit 1
loadtime:2.3254408836365 / seconds
Query Executed:select id FROM `ia` where city='Tama' && SIC_code='5531'DB:business_master_new
loadtime:2.3268809318542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teeds Grove' limit 1
loadtime:2.3270418643951 / seconds
Query Executed:select id FROM `ia` where city='Teeds Grove' && SIC_code='5531'DB:business_master_new
loadtime:2.3278739452362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:2.3279910087585 / seconds
Query Executed:select id FROM `ia` where city='Templeton' && SIC_code='5531'DB:business_master_new
loadtime:2.3297228813171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennant' limit 1
loadtime:2.3298609256744 / seconds
Query Executed:select id FROM `ia` where city='Tennant' && SIC_code='5531'DB:business_master_new
loadtime:2.330491065979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terril' limit 1
loadtime:2.3306498527527 / seconds
Query Executed:select id FROM `ia` where city='Terril' && SIC_code='5531'DB:business_master_new
loadtime:2.3322138786316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thayer' limit 1
loadtime:2.3323409557343 / seconds
Query Executed:select id FROM `ia` where city='Thayer' && SIC_code='5531'DB:business_master_new
loadtime:2.3330938816071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:2.3331909179688 / seconds
Query Executed:select id FROM `ia` where city='Thompson' && SIC_code='5531'DB:business_master_new
loadtime:2.3348948955536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thor' limit 1
loadtime:2.3350319862366 / seconds
Query Executed:select id FROM `ia` where city='Thor' && SIC_code='5531'DB:business_master_new
loadtime:2.3364789485931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:2.3365888595581 / seconds
Query Executed:select id FROM `ia` where city='Thornburg' && SIC_code='5531'DB:business_master_new
loadtime:2.3374350070953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:2.3375608921051 / seconds
Query Executed:select id FROM `ia` where city='Thornton' && SIC_code='5531'DB:business_master_new
loadtime:2.3393490314484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurman' limit 1
loadtime:2.3394830226898 / seconds
Query Executed:select id FROM `ia` where city='Thurman' && SIC_code='5531'DB:business_master_new
loadtime:2.3407380580902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiffin' limit 1
loadtime:2.340833902359 / seconds
Query Executed:select id FROM `ia` where city='Tiffin' && SIC_code='5531'DB:business_master_new
loadtime:2.3423390388489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tingley' limit 1
loadtime:2.342465877533 / seconds
Query Executed:select id FROM `ia` where city='Tingley' && SIC_code='5531'DB:business_master_new
loadtime:2.3435909748077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:2.3437359333038 / seconds
Query Executed:select id FROM `ia` where city='Tipton' && SIC_code='5531'DB:business_master_new
loadtime:2.3457250595093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titonka' limit 1
loadtime:2.3458859920502 / seconds
Query Executed:select id FROM `ia` where city='Titonka' && SIC_code='5531'DB:business_master_new
loadtime:2.3476378917694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toddville' limit 1
loadtime:2.3477759361267 / seconds
Query Executed:select id FROM `ia` where city='Toddville' && SIC_code='5531'DB:business_master_new
loadtime:2.3494849205017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toeterville' limit 1
loadtime:2.3495829105377 / seconds
Query Executed:select id FROM `ia` where city='Toeterville' && SIC_code='5531'DB:business_master_new
loadtime:2.3503730297089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toledo' limit 1
loadtime:2.3505139350891 / seconds
Query Executed:select id FROM `ia` where city='Toledo' && SIC_code='5531'DB:business_master_new
loadtime:2.3522870540619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:2.3524479866028 / seconds
Query Executed:select id FROM `ia` where city='Toronto' && SIC_code='5531'DB:business_master_new
loadtime:2.3532619476318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tracy' limit 1
loadtime:2.3533990383148 / seconds
Query Executed:select id FROM `ia` where city='Tracy' && SIC_code='5531'DB:business_master_new
loadtime:2.3544600009918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traer' limit 1
loadtime:2.3545548915863 / seconds
Query Executed:select id FROM `ia` where city='Traer' && SIC_code='5531'DB:business_master_new
loadtime:2.3556008338928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Treynor' limit 1
loadtime:2.3556699752808 / seconds
Query Executed:select id FROM `ia` where city='Treynor' && SIC_code='5531'DB:business_master_new
loadtime:2.3572409152985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:2.3573980331421 / seconds
Query Executed:select id FROM `ia` where city='Tripoli' && SIC_code='5531'DB:business_master_new
loadtime:2.35910987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy Mills' limit 1
loadtime:2.3592278957367 / seconds
Query Executed:select id FROM `ia` where city='Troy Mills' && SIC_code='5531'DB:business_master_new
loadtime:2.3602240085602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truesdale' limit 1
loadtime:2.3602728843689 / seconds
Query Executed:select id FROM `ia` where city='Truesdale' && SIC_code='5531'DB:business_master_new
loadtime:2.3607580661774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:2.3608338832855 / seconds
Query Executed:select id FROM `ia` where city='Truro' && SIC_code='5531'DB:business_master_new
loadtime:2.3622758388519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turin' limit 1
loadtime:2.362410068512 / seconds
Query Executed:select id FROM `ia` where city='Turin' && SIC_code='5531'DB:business_master_new
loadtime:2.363226890564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Udell' limit 1
loadtime:2.3633580207825 / seconds
Query Executed:select id FROM `ia` where city='Udell' && SIC_code='5531'DB:business_master_new
loadtime:2.3644380569458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underwood' limit 1
loadtime:2.3645689487457 / seconds
Query Executed:select id FROM `ia` where city='Underwood' && SIC_code='5531'DB:business_master_new
loadtime:2.3657200336456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:2.3658578395844 / seconds
Query Executed:select id FROM `ia` where city='Union' && SIC_code='5531'DB:business_master_new
loadtime:2.367527961731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:2.3676860332489 / seconds
Query Executed:select id FROM `ia` where city='Unionville' && SIC_code='5531'DB:business_master_new
loadtime:2.3687219619751 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Park' limit 1
loadtime:2.3688659667969 / seconds
Query Executed:select id FROM `ia` where city='University Park' && SIC_code='5531'DB:business_master_new
loadtime:2.3695380687714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbana' limit 1
loadtime:2.3696758747101 / seconds
Query Executed:select id FROM `ia` where city='Urbana' && SIC_code='5531'DB:business_master_new
loadtime:2.3714878559113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbandale' limit 1
loadtime:2.3716559410095 / seconds
Query Executed:select id FROM `ia` where city='Urbandale' && SIC_code='5531'DB:business_master_new
loadtime:2.374321937561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute' limit 1
loadtime:2.3744440078735 / seconds
Query Executed:select id FROM `ia` where city='Ute' && SIC_code='5531'DB:business_master_new
loadtime:2.3758959770203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:2.3760268688202 / seconds
Query Executed:select id FROM `ia` where city='Vail' && SIC_code='5531'DB:business_master_new
loadtime:2.3775708675385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Horne' limit 1
loadtime:2.3777070045471 / seconds
Query Executed:select id FROM `ia` where city='Van Horne' && SIC_code='5531'DB:business_master_new
loadtime:2.3794028759003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Meter' limit 1
loadtime:2.3795390129089 / seconds
Query Executed:select id FROM `ia` where city='Van Meter' && SIC_code='5531'DB:business_master_new
loadtime:2.3807129859924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wert' limit 1
loadtime:2.3808269500732 / seconds
Query Executed:select id FROM `ia` where city='Van Wert' && SIC_code='5531'DB:business_master_new
loadtime:2.3814890384674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varina' limit 1
loadtime:2.3816568851471 / seconds
Query Executed:select id FROM `ia` where city='Varina' && SIC_code='5531'DB:business_master_new
loadtime:2.3825500011444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventura' limit 1
loadtime:2.3827040195465 / seconds
Query Executed:select id FROM `ia` where city='Ventura' && SIC_code='5531'DB:business_master_new
loadtime:2.3843150138855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:2.3844480514526 / seconds
Query Executed:select id FROM `ia` where city='Victor' && SIC_code='5531'DB:business_master_new
loadtime:2.3858299255371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villisca' limit 1
loadtime:2.3859798908234 / seconds
Query Executed:select id FROM `ia` where city='Villisca' && SIC_code='5531'DB:business_master_new
loadtime:2.3878509998322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincent' limit 1
loadtime:2.3880009651184 / seconds
Query Executed:select id FROM `ia` where city='Vincent' && SIC_code='5531'DB:business_master_new
loadtime:2.3891758918762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vining' limit 1
loadtime:2.3892600536346 / seconds
Query Executed:select id FROM `ia` where city='Vining' && SIC_code='5531'DB:business_master_new
loadtime:2.3901319503784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:2.3902289867401 / seconds
Query Executed:select id FROM `ia` where city='Vinton' && SIC_code='5531'DB:business_master_new
loadtime:2.392413854599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:2.3925819396973 / seconds
Query Executed:select id FROM `ia` where city='Viola' && SIC_code='5531'DB:business_master_new
loadtime:2.3931660652161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:2.3932468891144 / seconds
Query Executed:select id FROM `ia` where city='Volga' && SIC_code='5531'DB:business_master_new
loadtime:2.3945620059967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadena' limit 1
loadtime:2.3947319984436 / seconds
Query Executed:select id FROM `ia` where city='Wadena' && SIC_code='5531'DB:business_master_new
loadtime:2.3959150314331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walcott' limit 1
loadtime:2.3960299491882 / seconds
Query Executed:select id FROM `ia` where city='Walcott' && SIC_code='5531'DB:business_master_new
loadtime:2.3973660469055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walford' limit 1
loadtime:2.3974988460541 / seconds
Query Executed:select id FROM `ia` where city='Walford' && SIC_code='5531'DB:business_master_new
loadtime:2.399050951004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walker' limit 1
loadtime:2.3991830348969 / seconds
Query Executed:select id FROM `ia` where city='Walker' && SIC_code='5531'DB:business_master_new
loadtime:2.40096783638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Lake' limit 1
loadtime:2.4010300636292 / seconds
Query Executed:select id FROM `ia` where city='Wall Lake' && SIC_code='5531'DB:business_master_new
loadtime:2.4023158550262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:2.4023728370667 / seconds
Query Executed:select id FROM `ia` where city='Wallingford' && SIC_code='5531'DB:business_master_new
loadtime:2.4035358428955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:2.4036989212036 / seconds
Query Executed:select id FROM `ia` where city='Walnut' && SIC_code='5531'DB:business_master_new
loadtime:2.4047999382019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wapello' limit 1
loadtime:2.404846906662 / seconds
Query Executed:select id FROM `ia` where city='Wapello' && SIC_code='5531'DB:business_master_new
loadtime:2.4057309627533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:2.4058940410614 / seconds
Query Executed:select id FROM `ia` where city='Washburn' && SIC_code='5531'DB:business_master_new
loadtime:2.4064419269562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.4065718650818 / seconds
Query Executed:select id FROM `ia` where city='Washington' && SIC_code='5531'DB:business_master_new
loadtime:2.4084539413452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washta' limit 1
loadtime:2.408576965332 / seconds
Query Executed:select id FROM `ia` where city='Washta' && SIC_code='5531'DB:business_master_new
loadtime:2.4097199440002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:2.4098479747772 / seconds
Query Executed:select id FROM `ia` where city='Waterloo' && SIC_code='5531'DB:business_master_new
loadtime:2.4133520126343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:2.4134180545807 / seconds
Query Executed:select id FROM `ia` where city='Waterville' && SIC_code='5531'DB:business_master_new
loadtime:2.415139913559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:2.4151899814606 / seconds
Query Executed:select id FROM `ia` where city='Watkins' && SIC_code='5531'DB:business_master_new
loadtime:2.415699005127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waucoma' limit 1
loadtime:2.4157378673553 / seconds
Query Executed:select id FROM `ia` where city='Waucoma' && SIC_code='5531'DB:business_master_new
loadtime:2.4163348674774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukee' limit 1
loadtime:2.4163780212402 / seconds
Query Executed:select id FROM `ia` where city='Waukee' && SIC_code='5531'DB:business_master_new
loadtime:2.417062997818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukon' limit 1
loadtime:2.4171190261841 / seconds
Query Executed:select id FROM `ia` where city='Waukon' && SIC_code='5531'DB:business_master_new
loadtime:2.4178938865662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:2.4179508686066 / seconds
Query Executed:select id FROM `ia` where city='Waverly' && SIC_code='5531'DB:business_master_new
loadtime:2.4187638759613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.4188208580017 / seconds
Query Executed:select id FROM `ia` where city='Wayland' && SIC_code='5531'DB:business_master_new
loadtime:2.4193930625916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:2.4194419384003 / seconds
Query Executed:select id FROM `ia` where city='Webb' && SIC_code='5531'DB:business_master_new
loadtime:2.4200148582458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.4200639724731 / seconds
Query Executed:select id FROM `ia` where city='Webster' && SIC_code='5531'DB:business_master_new
loadtime:2.4204938411713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster City' limit 1
loadtime:2.4205338954926 / seconds
Query Executed:select id FROM `ia` where city='Webster City' && SIC_code='5531'DB:business_master_new
loadtime:2.4212999343872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:2.4213559627533 / seconds
Query Executed:select id FROM `ia` where city='Weldon' && SIC_code='5531'DB:business_master_new
loadtime:2.4217188358307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellman' limit 1
loadtime:2.4217638969421 / seconds
Query Executed:select id FROM `ia` where city='Wellman' && SIC_code='5531'DB:business_master_new
loadtime:2.422397851944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsburg' limit 1
loadtime:2.4224569797516 / seconds
Query Executed:select id FROM `ia` where city='Wellsburg' && SIC_code='5531'DB:business_master_new
loadtime:2.4230449199677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welton' limit 1
loadtime:2.4230890274048 / seconds
Query Executed:select id FROM `ia` where city='Welton' && SIC_code='5531'DB:business_master_new
loadtime:2.4234218597412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesley' limit 1
loadtime:2.4234628677368 / seconds
Query Executed:select id FROM `ia` where city='Wesley' && SIC_code='5531'DB:business_master_new
loadtime:2.4240479469299 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Amana' limit 1
loadtime:2.4240989685059 / seconds
Query Executed:select id FROM `ia` where city='West Amana' && SIC_code='5531'DB:business_master_new
loadtime:2.4243278503418 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:2.4243628978729 / seconds
Query Executed:select id FROM `ia` where city='West Bend' && SIC_code='5531'DB:business_master_new
loadtime:2.4249799251556 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:2.4250240325928 / seconds
Query Executed:select id FROM `ia` where city='West Branch' && SIC_code='5531'DB:business_master_new
loadtime:2.4256529808044 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burlington' limit 1
loadtime:2.4257030487061 / seconds
Query Executed:select id FROM `ia` where city='West Burlington' && SIC_code='5531'DB:business_master_new
loadtime:2.4263918399811 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chester' limit 1
loadtime:2.4264400005341 / seconds
Query Executed:select id FROM `ia` where city='West Chester' && SIC_code='5531'DB:business_master_new
loadtime:2.4269199371338 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Des Moines' limit 1
loadtime:2.4269540309906 / seconds
Query Executed:select id FROM `ia` where city='West Des Moines' && SIC_code='5531'DB:business_master_new
loadtime:2.4336609840393 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Grove' limit 1
loadtime:2.4337179660797 / seconds
Query Executed:select id FROM `ia` where city='West Grove' && SIC_code='5531'DB:business_master_new
loadtime:2.4339849948883 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Liberty' limit 1
loadtime:2.4340188503265 / seconds
Query Executed:select id FROM `ia` where city='West Liberty' && SIC_code='5531'DB:business_master_new
loadtime:2.4346978664398 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:2.4347598552704 / seconds
Query Executed:select id FROM `ia` where city='West Point' && SIC_code='5531'DB:business_master_new
loadtime:2.435359954834 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:2.4354100227356 / seconds
Query Executed:select id FROM `ia` where city='West Union' && SIC_code='5531'DB:business_master_new
loadtime:2.4360690116882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.4361259937286 / seconds
Query Executed:select id FROM `ia` where city='Westfield' && SIC_code='5531'DB:business_master_new
loadtime:2.4365890026093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westgate' limit 1
loadtime:2.4366369247437 / seconds
Query Executed:select id FROM `ia` where city='Westgate' && SIC_code='5531'DB:business_master_new
loadtime:2.4371299743652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:2.437166929245 / seconds
Query Executed:select id FROM `ia` where city='Westphalia' && SIC_code='5531'DB:business_master_new
loadtime:2.4374990463257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westside' limit 1
loadtime:2.4375360012054 / seconds
Query Executed:select id FROM `ia` where city='Westside' && SIC_code='5531'DB:business_master_new
loadtime:2.4381170272827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wever' limit 1
loadtime:2.4381589889526 / seconds
Query Executed:select id FROM `ia` where city='Wever' && SIC_code='5531'DB:business_master_new
loadtime:2.4386930465698 / seconds
Query loaded from cache:select * from geodata_geocity where city='What Cheer' limit 1
loadtime:2.4387359619141 / seconds
Query Executed:select id FROM `ia` where city='What Cheer' && SIC_code='5531'DB:business_master_new
loadtime:2.4392819404602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheatland' limit 1
loadtime:2.4393310546875 / seconds
Query Executed:select id FROM `ia` where city='Wheatland' && SIC_code='5531'DB:business_master_new
loadtime:2.4399359226227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:2.4399788379669 / seconds
Query Executed:select id FROM `ia` where city='Whiting' && SIC_code='5531'DB:business_master_new
loadtime:2.4405479431152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:2.4405980110168 / seconds
Query Executed:select id FROM `ia` where city='Whittemore' && SIC_code='5531'DB:business_master_new
loadtime:2.4411940574646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitten' limit 1
loadtime:2.4412438869476 / seconds
Query Executed:select id FROM `ia` where city='Whitten' && SIC_code='5531'DB:business_master_new
loadtime:2.4415888786316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:2.4416389465332 / seconds
Query Executed:select id FROM `ia` where city='Williams' && SIC_code='5531'DB:business_master_new
loadtime:2.4421968460083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.442244052887 / seconds
Query Executed:select id FROM `ia` where city='Williamsburg' && SIC_code='5531'DB:business_master_new
loadtime:2.4429378509521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamson' limit 1
loadtime:2.4429888725281 / seconds
Query Executed:select id FROM `ia` where city='Williamson' && SIC_code='5531'DB:business_master_new
loadtime:2.4433059692383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:2.4433538913727 / seconds
Query Executed:select id FROM `ia` where city='Wilton' && SIC_code='5531'DB:business_master_new
loadtime:2.4440078735352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Heights' limit 1
loadtime:2.4440588951111 / seconds
Query Executed:select id FROM `ia` where city='Windsor Heights' && SIC_code='5531'DB:business_master_new
loadtime:2.4447109699249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:2.4447569847107 / seconds
Query Executed:select id FROM `ia` where city='Winfield' && SIC_code='5531'DB:business_master_new
loadtime:2.4453558921814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterset' limit 1
loadtime:2.4454040527344 / seconds
Query Executed:select id FROM `ia` where city='Winterset' && SIC_code='5531'DB:business_master_new
loadtime:2.4461669921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.4462258815765 / seconds
Query Executed:select id FROM `ia` where city='Winthrop' && SIC_code='5531'DB:business_master_new
loadtime:2.4467949867249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiota' limit 1
loadtime:2.4468278884888 / seconds
Query Executed:select id FROM `ia` where city='Wiota' && SIC_code='5531'DB:business_master_new
loadtime:2.4473938941956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woden' limit 1
loadtime:2.447448015213 / seconds
Query Executed:select id FROM `ia` where city='Woden' && SIC_code='5531'DB:business_master_new
loadtime:2.4480559825897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:2.4481129646301 / seconds
Query Executed:select id FROM `ia` where city='Woodbine' && SIC_code='5531'DB:business_master_new
loadtime:2.4487040042877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodburn' limit 1
loadtime:2.448737859726 / seconds
Query Executed:select id FROM `ia` where city='Woodburn' && SIC_code='5531'DB:business_master_new
loadtime:2.4492468833923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodward' limit 1
loadtime:2.4492969512939 / seconds
Query Executed:select id FROM `ia` where city='Woodward' && SIC_code='5531'DB:business_master_new
loadtime:2.4498400688171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolstock' limit 1
loadtime:2.4498748779297 / seconds
Query Executed:select id FROM `ia` where city='Woolstock' && SIC_code='5531'DB:business_master_new
loadtime:2.4504299163818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:2.4504818916321 / seconds
Query Executed:select id FROM `ia` where city='Worthington' && SIC_code='5531'DB:business_master_new
loadtime:2.4510679244995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:2.4511170387268 / seconds
Query Executed:select id FROM `ia` where city='Wyoming' && SIC_code='5531'DB:business_master_new
loadtime:2.4517068862915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:2.4517529010773 / seconds
Query Executed:select id FROM `ia` where city='Yale' && SIC_code='5531'DB:business_master_new
loadtime:2.4522478580475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth' limit 1
loadtime:2.4522929191589 / seconds
Query Executed:select id FROM `ia` where city='Yarmouth' && SIC_code='5531'DB:business_master_new
loadtime:2.4527268409729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:2.4527599811554 / seconds
Query Executed:select id FROM `ia` where city='Yorktown' && SIC_code='5531'DB:business_master_new
loadtime:2.4530680179596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zearing' limit 1
loadtime:2.453115940094 / seconds
Query Executed:select id FROM `ia` where city='Zearing' && SIC_code='5531'DB:business_master_new
loadtime:2.4536910057068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zwingle' limit 1
loadtime:2.4537360668182 / seconds
Query Executed:select id FROM `ia` where city='Zwingle' && SIC_code='5531'DB:business_master_new
loadtime:2.4542758464813 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.4543600082397 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.4545738697052 / seconds
Operation template executed (chunk cache operation)
loadtime:2.4546699523926 / seconds
template override:Default
loadtime:2.4546909332275 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:2.4554300308228 / seconds
Template Constructed, Array Rows:49
loadtime:2.455689907074 / seconds
TOTAL EXECUTION TIME: 2.45548
loadtime:2.4558088779449 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => auto-and-home-supply-stores [stateURLid] => 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:2.4558138847351
TOTAL KEY ARRAYS: 69