Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.3896179199219E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00047492980957031 / seconds
host not found setting manual db connection
loadtime:0.00089406967163086 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0012350082397461 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0013840198516846 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0014369487762451 / seconds
zipcode:
loadtime:0.0014538764953613 / seconds
Query Executed:select * from search_referrer where page_hash='89478bdb4c7c76414033823d72aaa743' limit 10 DB:ezrox_toadli
loadtime:0.0016529560089111 / seconds
Operation header executed (non global)
loadtime:0.0016689300537109 / seconds
Operation leaderboard executed (non global)
loadtime:0.0017008781433105 / seconds
Operation square executed (non global)
loadtime:0.0017149448394775 / seconds
Operation square_bottom executed (non global)
loadtime:0.0017271041870117 / seconds
Operation smallsquare executed (non global)
loadtime:0.0017390251159668 / seconds
Operation headeradright executed (non global)
loadtime:0.0017499923706055 / seconds
Operation google_analytics executed (non global)
loadtime:0.0017600059509277 / seconds
Operation topstories executed (non global)
loadtime:0.0017719268798828 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0017828941345215 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0017929077148438 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0020840167999268 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0022470951080322 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0022859573364258 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0023510456085205 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0023930072784424 / seconds
Template key: archive_menu pushed
loadtime:0.0023980140686035 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0024049282073975 / seconds
Template key: get_gravatar pushed
loadtime:0.0024080276489258 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0024120807647705 / seconds
*10)-10)+1 | start:0
loadtime:0.0024349689483643 / seconds
Query loaded from cache:select * from categories where cat_URLid='hotels-and-motels'
loadtime:0.0024659633636475 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.0024969577789307 / seconds
DB connected to localhost business_master_new
loadtime:0.0027279853820801 / seconds
Query Executed:select * from `ia_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.090391874313354 / seconds
Query stored in cache : _QUERY_www.toadli.com0746dd6c125e074d1dccf74ada0ddc9d
loadtime:0.091919898986816 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.091979026794434 / seconds
Query Executed:select sum(totalcount) as totalsum from `ia_catmap` where sic='7011'DB:business_master_new
loadtime:0.10421705245972 / seconds
Query stored in cache : _QUERY_www.toadli.com43fec5b41d57a4450674007b3fe19f12
loadtime:0.10430097579956 / seconds
981 / 11
loadtime:0.10439801216125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackley' limit 1
loadtime:0.10453200340271 / seconds
Query Executed:select id FROM `ia` where city='Ackley' && SIC_code='7011'DB:business_master_new
loadtime:0.10858392715454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackworth' limit 1
loadtime:0.10866403579712 / seconds
Query Executed:select id FROM `ia` where city='Ackworth' && SIC_code='7011'DB:business_master_new
loadtime:0.10930895805359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adair' limit 1
loadtime:0.10942387580872 / seconds
Query Executed:select id FROM `ia` where city='Adair' && SIC_code='7011'DB:business_master_new
loadtime:0.11059403419495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adel' limit 1
loadtime:0.11074709892273 / seconds
Query Executed:select id FROM `ia` where city='Adel' && SIC_code='7011'DB:business_master_new
loadtime:0.11246299743652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.11259794235229 / seconds
Query Executed:select id FROM `ia` where city='Afton' && SIC_code='7011'DB:business_master_new
loadtime:0.11382699012756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agency' limit 1
loadtime:0.11386704444885 / seconds
Query Executed:select id FROM `ia` where city='Agency' && SIC_code='7011'DB:business_master_new
loadtime:0.11505889892578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ainsworth' limit 1
loadtime:0.11523103713989 / seconds
Query Executed:select id FROM `ia` where city='Ainsworth' && SIC_code='7011'DB:business_master_new
loadtime:0.11658096313477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.11671590805054 / seconds
Query Executed:select id FROM `ia` where city='Akron' && SIC_code='7011'DB:business_master_new
loadtime:0.11788105964661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albert City' limit 1
loadtime:0.11801195144653 / seconds
Query Executed:select id FROM `ia` where city='Albert City' && SIC_code='7011'DB:business_master_new
loadtime:0.1194589138031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albia' limit 1
loadtime:0.1196129322052 / seconds
Query Executed:select id FROM `ia` where city='Albia' && SIC_code='7011'DB:business_master_new
loadtime:0.12092900276184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.12102389335632 / seconds
Query Executed:select id FROM `ia` where city='Albion' && SIC_code='7011'DB:business_master_new
loadtime:0.12224888801575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburnett' limit 1
loadtime:0.12229108810425 / seconds
Query Executed:select id FROM `ia` where city='Alburnett' && SIC_code='7011'DB:business_master_new
loadtime:0.12363004684448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.12370109558105 / seconds
Query Executed:select id FROM `ia` where city='Alden' && SIC_code='7011'DB:business_master_new
loadtime:0.12513303756714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.12518787384033 / seconds
Query Executed:select id FROM `ia` where city='Alexander' && SIC_code='7011'DB:business_master_new
loadtime:0.12664890289307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algona' limit 1
loadtime:0.12678289413452 / seconds
Query Executed:select id FROM `ia` where city='Algona' && SIC_code='7011'DB:business_master_new
loadtime:0.12865400314331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleman' limit 1
loadtime:0.12879705429077 / seconds
Query Executed:select id FROM `ia` where city='Alleman' && SIC_code='7011'DB:business_master_new
loadtime:0.12926697731018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendorf' limit 1
loadtime:0.12929606437683 / seconds
Query Executed:select id FROM `ia` where city='Allendorf' && SIC_code='7011'DB:business_master_new
loadtime:0.12955594062805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allerton' limit 1
loadtime:0.1295919418335 / seconds
Query Executed:select id FROM `ia` where city='Allerton' && SIC_code='7011'DB:business_master_new
loadtime:0.13022494316101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allison' limit 1
loadtime:0.13026595115662 / seconds
Query Executed:select id FROM `ia` where city='Allison' && SIC_code='7011'DB:business_master_new
loadtime:0.13096499443054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.13102197647095 / seconds
Query Executed:select id FROM `ia` where city='Alpha' && SIC_code='7011'DB:business_master_new
loadtime:0.13132095336914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.13136100769043 / seconds
Query Executed:select id FROM `ia` where city='Alta' && SIC_code='7011'DB:business_master_new
loadtime:0.13202500343323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta Vista' limit 1
loadtime:0.13207197189331 / seconds
Query Executed:select id FROM `ia` where city='Alta Vista' && SIC_code='7011'DB:business_master_new
loadtime:0.13265204429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.13269901275635 / seconds
Query Executed:select id FROM `ia` where city='Alton' && SIC_code='7011'DB:business_master_new
loadtime:0.13364100456238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.13369798660278 / seconds
Query Executed:select id FROM `ia` where city='Altoona' && SIC_code='7011'DB:business_master_new
loadtime:0.13567900657654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvord' limit 1
loadtime:0.13584494590759 / seconds
Query Executed:select id FROM `ia` where city='Alvord' && SIC_code='7011'DB:business_master_new
loadtime:0.13694310188293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amana' limit 1
loadtime:0.13697910308838 / seconds
Query Executed:select id FROM `ia` where city='Amana' && SIC_code='7011'DB:business_master_new
loadtime:0.1386079788208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ames' limit 1
loadtime:0.13866710662842 / seconds
Query Executed:select id FROM `ia` where city='Ames' && SIC_code='7011'DB:business_master_new
loadtime:0.14191794395447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anamosa' limit 1
loadtime:0.14198708534241 / seconds
Query Executed:select id FROM `ia` where city='Anamosa' && SIC_code='7011'DB:business_master_new
loadtime:0.14385390281677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.14401888847351 / seconds
Query Executed:select id FROM `ia` where city='Andover' && SIC_code='7011'DB:business_master_new
loadtime:0.14489889144897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrew' limit 1
loadtime:0.14494800567627 / seconds
Query Executed:select id FROM `ia` where city='Andrew' && SIC_code='7011'DB:business_master_new
loadtime:0.14576506614685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anita' limit 1
loadtime:0.14590096473694 / seconds
Query Executed:select id FROM `ia` where city='Anita' && SIC_code='7011'DB:business_master_new
loadtime:0.14745402336121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ankeny' limit 1
loadtime:0.14757490158081 / seconds
Query Executed:select id FROM `ia` where city='Ankeny' && SIC_code='7011'DB:business_master_new
loadtime:0.1500129699707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthon' limit 1
loadtime:0.15018200874329 / seconds
Query Executed:select id FROM `ia` where city='Anthon' && SIC_code='7011'DB:business_master_new
loadtime:0.15135502815247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aplington' limit 1
loadtime:0.1514720916748 / seconds
Query Executed:select id FROM `ia` where city='Aplington' && SIC_code='7011'DB:business_master_new
loadtime:0.15286803245544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.15291500091553 / seconds
Query Executed:select id FROM `ia` where city='Arcadia' && SIC_code='7011'DB:business_master_new
loadtime:0.15391802787781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archer' limit 1
loadtime:0.15402793884277 / seconds
Query Executed:select id FROM `ia` where city='Archer' && SIC_code='7011'DB:business_master_new
loadtime:0.15504288673401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aredale' limit 1
loadtime:0.15517902374268 / seconds
Query Executed:select id FROM `ia` where city='Aredale' && SIC_code='7011'DB:business_master_new
loadtime:0.15579509735107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.15589904785156 / seconds
Query Executed:select id FROM `ia` where city='Argyle' && SIC_code='7011'DB:business_master_new
loadtime:0.15697407722473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arion' limit 1
loadtime:0.15702295303345 / seconds
Query Executed:select id FROM `ia` where city='Arion' && SIC_code='7011'DB:business_master_new
loadtime:0.15802693367004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arispe' limit 1
loadtime:0.15815901756287 / seconds
Query Executed:select id FROM `ia` where city='Arispe' && SIC_code='7011'DB:business_master_new
loadtime:0.15878009796143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.15891289710999 / seconds
Query Executed:select id FROM `ia` where city='Arlington' && SIC_code='7011'DB:business_master_new
loadtime:0.16018605232239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armstrong' limit 1
loadtime:0.16032195091248 / seconds
Query Executed:select id FROM `ia` where city='Armstrong' && SIC_code='7011'DB:business_master_new
loadtime:0.16160798072815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnolds Park' limit 1
loadtime:0.16166090965271 / seconds
Query Executed:select id FROM `ia` where city='Arnolds Park' && SIC_code='7011'DB:business_master_new
loadtime:0.16337108612061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arthur' limit 1
loadtime:0.16353893280029 / seconds
Query Executed:select id FROM `ia` where city='Arthur' && SIC_code='7011'DB:business_master_new
loadtime:0.1649329662323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.16498494148254 / seconds
Query Executed:select id FROM `ia` where city='Ashton' && SIC_code='7011'DB:business_master_new
loadtime:0.16658902168274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aspinwall' limit 1
loadtime:0.16669893264771 / seconds
Query Executed:select id FROM `ia` where city='Aspinwall' && SIC_code='7011'DB:business_master_new
loadtime:0.16765999794006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atalissa' limit 1
loadtime:0.1677930355072 / seconds
Query Executed:select id FROM `ia` where city='Atalissa' && SIC_code='7011'DB:business_master_new
loadtime:0.1688449382782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.16888689994812 / seconds
Query Executed:select id FROM `ia` where city='Atkins' && SIC_code='7011'DB:business_master_new
loadtime:0.17019104957581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.17032790184021 / seconds
Query Executed:select id FROM `ia` where city='Atlantic' && SIC_code='7011'DB:business_master_new
loadtime:0.17267608642578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.17281293869019 / seconds
Query Executed:select id FROM `ia` where city='Auburn' && SIC_code='7011'DB:business_master_new
loadtime:0.1741669178009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.17426490783691 / seconds
Query Executed:select id FROM `ia` where city='Audubon' && SIC_code='7011'DB:business_master_new
loadtime:0.17602801322937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurelia' limit 1
loadtime:0.17608404159546 / seconds
Query Executed:select id FROM `ia` where city='Aurelia' && SIC_code='7011'DB:business_master_new
loadtime:0.17718291282654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.177325963974 / seconds
Query Executed:select id FROM `ia` where city='Aurora' && SIC_code='7011'DB:business_master_new
loadtime:0.17880296707153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.17895197868347 / seconds
Query Executed:select id FROM `ia` where city='Austinville' && SIC_code='7011'DB:business_master_new
loadtime:0.1795449256897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.17962694168091 / seconds
Query Executed:select id FROM `ia` where city='Avoca' && SIC_code='7011'DB:business_master_new
loadtime:0.18108892440796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayrshire' limit 1
loadtime:0.18115091323853 / seconds
Query Executed:select id FROM `ia` where city='Ayrshire' && SIC_code='7011'DB:business_master_new
loadtime:0.18244600296021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.1825840473175 / seconds
Query Executed:select id FROM `ia` where city='Badger' && SIC_code='7011'DB:business_master_new
loadtime:0.18383097648621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.18397188186646 / seconds
Query Executed:select id FROM `ia` where city='Bagley' && SIC_code='7011'DB:business_master_new
loadtime:0.18489694595337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.1849479675293 / seconds
Query Executed:select id FROM `ia` where city='Baldwin' && SIC_code='7011'DB:business_master_new
loadtime:0.18616509437561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.18630695343018 / seconds
Query Executed:select id FROM `ia` where city='Bancroft' && SIC_code='7011'DB:business_master_new
loadtime:0.18776202201843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes City' limit 1
loadtime:0.18787407875061 / seconds
Query Executed:select id FROM `ia` where city='Barnes City' && SIC_code='7011'DB:business_master_new
loadtime:0.18885707855225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnum' limit 1
loadtime:0.18899393081665 / seconds
Query Executed:select id FROM `ia` where city='Barnum' && SIC_code='7011'DB:business_master_new
loadtime:0.18954992294312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batavia' limit 1
loadtime:0.1895899772644 / seconds
Query Executed:select id FROM `ia` where city='Batavia' && SIC_code='7011'DB:business_master_new
loadtime:0.19086503982544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.19097590446472 / seconds
Query Executed:select id FROM `ia` where city='Battle Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.1924250125885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baxter' limit 1
loadtime:0.19258403778076 / seconds
Query Executed:select id FROM `ia` where city='Baxter' && SIC_code='7011'DB:business_master_new
loadtime:0.19390797615051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.19407296180725 / seconds
Query Executed:select id FROM `ia` where city='Bayard' && SIC_code='7011'DB:business_master_new
loadtime:0.19559693336487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon' limit 1
loadtime:0.1957380771637 / seconds
Query Executed:select id FROM `ia` where city='Beacon' && SIC_code='7011'DB:business_master_new
loadtime:0.19662594795227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaconsfield' limit 1
loadtime:0.19672298431396 / seconds
Query Executed:select id FROM `ia` where city='Beaconsfield' && SIC_code='7011'DB:business_master_new
loadtime:0.19735097885132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaman' limit 1
loadtime:0.1974630355835 / seconds
Query Executed:select id FROM `ia` where city='Beaman' && SIC_code='7011'DB:business_master_new
loadtime:0.1985011100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.19864010810852 / seconds
Query Executed:select id FROM `ia` where city='Beaver' && SIC_code='7011'DB:business_master_new
loadtime:0.19975805282593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.19985008239746 / seconds
Query Executed:select id FROM `ia` where city='Bedford' && SIC_code='7011'DB:business_master_new
loadtime:0.20093488693237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Plaine' limit 1
loadtime:0.20099306106567 / seconds
Query Executed:select id FROM `ia` where city='Belle Plaine' && SIC_code='7011'DB:business_master_new
loadtime:0.20258593559265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.20271396636963 / seconds
Query Executed:select id FROM `ia` where city='Bellevue' && SIC_code='7011'DB:business_master_new
loadtime:0.20445489883423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmond' limit 1
loadtime:0.2046000957489 / seconds
Query Executed:select id FROM `ia` where city='Belmond' && SIC_code='7011'DB:business_master_new
loadtime:0.20636010169983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.20653605461121 / seconds
Query Executed:select id FROM `ia` where city='Bennett' && SIC_code='7011'DB:business_master_new
loadtime:0.2078709602356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.20800590515137 / seconds
Query Executed:select id FROM `ia` where city='Benton' && SIC_code='7011'DB:business_master_new
loadtime:0.20889687538147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernard' limit 1
loadtime:0.2089478969574 / seconds
Query Executed:select id FROM `ia` where city='Bernard' && SIC_code='7011'DB:business_master_new
loadtime:0.21076393127441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berwick' limit 1
loadtime:0.21091294288635 / seconds
Query Executed:select id FROM `ia` where city='Berwick' && SIC_code='7011'DB:business_master_new
loadtime:0.21194410324097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bettendorf' limit 1
loadtime:0.21205496788025 / seconds
Query Executed:select id FROM `ia` where city='Bettendorf' && SIC_code='7011'DB:business_master_new
loadtime:0.2145459651947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bevington' limit 1
loadtime:0.21471309661865 / seconds
Query Executed:select id FROM `ia` where city='Bevington' && SIC_code='7011'DB:business_master_new
loadtime:0.21584606170654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.21598100662231 / seconds
Query Executed:select id FROM `ia` where city='Big Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.21680188179016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.21684908866882 / seconds
Query Executed:select id FROM `ia` where city='Birmingham' && SIC_code='7011'DB:business_master_new
loadtime:0.21821188926697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairsburg' limit 1
loadtime:0.21832704544067 / seconds
Query Executed:select id FROM `ia` where city='Blairsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.21988391876221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairstown' limit 1
loadtime:0.22001910209656 / seconds
Query Executed:select id FROM `ia` where city='Blairstown' && SIC_code='7011'DB:business_master_new
loadtime:0.22164702415466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakesburg' limit 1
loadtime:0.22178602218628 / seconds
Query Executed:select id FROM `ia` where city='Blakesburg' && SIC_code='7011'DB:business_master_new
loadtime:0.22341394424438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.22354507446289 / seconds
Query Executed:select id FROM `ia` where city='Blanchard' && SIC_code='7011'DB:business_master_new
loadtime:0.22452092170715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blencoe' limit 1
loadtime:0.22463202476501 / seconds
Query Executed:select id FROM `ia` where city='Blencoe' && SIC_code='7011'DB:business_master_new
loadtime:0.22571301460266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blockton' limit 1
loadtime:0.22585391998291 / seconds
Query Executed:select id FROM `ia` where city='Blockton' && SIC_code='7011'DB:business_master_new
loadtime:0.22723007202148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.22736001014709 / seconds
Query Executed:select id FROM `ia` where city='Bloomfield' && SIC_code='7011'DB:business_master_new
loadtime:0.22948789596558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.2296130657196 / seconds
Query Executed:select id FROM `ia` where city='Blue Grass' && SIC_code='7011'DB:business_master_new
loadtime:0.23157501220703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bode' limit 1
loadtime:0.23173308372498 / seconds
Query Executed:select id FROM `ia` where city='Bode' && SIC_code='7011'DB:business_master_new
loadtime:0.2334930896759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonaparte' limit 1
loadtime:0.2336049079895 / seconds
Query Executed:select id FROM `ia` where city='Bonaparte' && SIC_code='7011'DB:business_master_new
loadtime:0.2353150844574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondurant' limit 1
loadtime:0.2354519367218 / seconds
Query Executed:select id FROM `ia` where city='Bondurant' && SIC_code='7011'DB:business_master_new
loadtime:0.23744106292725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.23758006095886 / seconds
Query Executed:select id FROM `ia` where city='Boone' && SIC_code='7011'DB:business_master_new
loadtime:0.24023199081421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booneville' limit 1
loadtime:0.24038696289062 / seconds
Query Executed:select id FROM `ia` where city='Booneville' && SIC_code='7011'DB:business_master_new
loadtime:0.24145698547363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouton' limit 1
loadtime:0.24155592918396 / seconds
Query Executed:select id FROM `ia` where city='Bouton' && SIC_code='7011'DB:business_master_new
loadtime:0.24308109283447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxholm' limit 1
loadtime:0.24327993392944 / seconds
Query Executed:select id FROM `ia` where city='Boxholm' && SIC_code='7011'DB:business_master_new
loadtime:0.24435591697693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyden' limit 1
loadtime:0.24444103240967 / seconds
Query Executed:select id FROM `ia` where city='Boyden' && SIC_code='7011'DB:business_master_new
loadtime:0.24618697166443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braddyville' limit 1
loadtime:0.24628400802612 / seconds
Query Executed:select id FROM `ia` where city='Braddyville' && SIC_code='7011'DB:business_master_new
loadtime:0.24755907058716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.24769306182861 / seconds
Query Executed:select id FROM `ia` where city='Bradford' && SIC_code='7011'DB:business_master_new
loadtime:0.24832510948181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradgate' limit 1
loadtime:0.24836587905884 / seconds
Query Executed:select id FROM `ia` where city='Bradgate' && SIC_code='7011'DB:business_master_new
loadtime:0.24920010566711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.24924898147583 / seconds
Query Executed:select id FROM `ia` where city='Brandon' && SIC_code='7011'DB:business_master_new
loadtime:0.25030708312988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brayton' limit 1
loadtime:0.25041890144348 / seconds
Query Executed:select id FROM `ia` where city='Brayton' && SIC_code='7011'DB:business_master_new
loadtime:0.25170588493347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breda' limit 1
loadtime:0.25185990333557 / seconds
Query Executed:select id FROM `ia` where city='Breda' && SIC_code='7011'DB:business_master_new
loadtime:0.25368404388428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.25382399559021 / seconds
Query Executed:select id FROM `ia` where city='Bridgewater' && SIC_code='7011'DB:business_master_new
loadtime:0.25515794754028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.25525498390198 / seconds
Query Executed:select id FROM `ia` where city='Brighton' && SIC_code='7011'DB:business_master_new
loadtime:0.25709891319275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.25727009773254 / seconds
Query Executed:select id FROM `ia` where city='Bristow' && SIC_code='7011'DB:business_master_new
loadtime:0.25859189033508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britt' limit 1
loadtime:0.25870800018311 / seconds
Query Executed:select id FROM `ia` where city='Britt' && SIC_code='7011'DB:business_master_new
loadtime:0.26065587997437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.26081609725952 / seconds
Query Executed:select id FROM `ia` where city='Bronson' && SIC_code='7011'DB:business_master_new
loadtime:0.26217198371887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.26230502128601 / seconds
Query Executed:select id FROM `ia` where city='Brooklyn' && SIC_code='7011'DB:business_master_new
loadtime:0.26424908638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunsville' limit 1
loadtime:0.26440787315369 / seconds
Query Executed:select id FROM `ia` where city='Brunsville' && SIC_code='7011'DB:business_master_new
loadtime:0.26537799835205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.26552295684814 / seconds
Query Executed:select id FROM `ia` where city='Bryant' && SIC_code='7011'DB:business_master_new
loadtime:0.26676607131958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.26681590080261 / seconds
Query Executed:select id FROM `ia` where city='Buckeye' && SIC_code='7011'DB:business_master_new
loadtime:0.26710510253906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:0.26714396476746 / seconds
Query Executed:select id FROM `ia` where city='Buckingham' && SIC_code='7011'DB:business_master_new
loadtime:0.26803588867188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.2680881023407 / seconds
Query Executed:select id FROM `ia` where city='Buffalo' && SIC_code='7011'DB:business_master_new
loadtime:0.26915597915649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Center' limit 1
loadtime:0.26929497718811 / seconds
Query Executed:select id FROM `ia` where city='Buffalo Center' && SIC_code='7011'DB:business_master_new
loadtime:0.2712459564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.27138805389404 / seconds
Query Executed:select id FROM `ia` where city='Burlington' && SIC_code='7011'DB:business_master_new
loadtime:0.27477407455444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnside' limit 1
loadtime:0.27487897872925 / seconds
Query Executed:select id FROM `ia` where city='Burnside' && SIC_code='7011'DB:business_master_new
loadtime:0.27586603164673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:0.27600693702698 / seconds
Query Executed:select id FROM `ia` where city='Burt' && SIC_code='7011'DB:business_master_new
loadtime:0.27809810638428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bussey' limit 1
loadtime:0.27824306488037 / seconds
Query Executed:select id FROM `ia` where city='Bussey' && SIC_code='7011'DB:business_master_new
loadtime:0.27970504760742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calamus' limit 1
loadtime:0.27983808517456 / seconds
Query Executed:select id FROM `ia` where city='Calamus' && SIC_code='7011'DB:business_master_new
loadtime:0.28181505203247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callender' limit 1
loadtime:0.28190994262695 / seconds
Query Executed:select id FROM `ia` where city='Callender' && SIC_code='7011'DB:business_master_new
loadtime:0.28358387947083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calmar' limit 1
loadtime:0.28372406959534 / seconds
Query Executed:select id FROM `ia` where city='Calmar' && SIC_code='7011'DB:business_master_new
loadtime:0.28530788421631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.28544187545776 / seconds
Query Executed:select id FROM `ia` where city='Calumet' && SIC_code='7011'DB:business_master_new
loadtime:0.28660106658936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camanche' limit 1
loadtime:0.28674697875977 / seconds
Query Executed:select id FROM `ia` where city='Camanche' && SIC_code='7011'DB:business_master_new
loadtime:0.28870391845703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.2888650894165 / seconds
Query Executed:select id FROM `ia` where city='Cambridge' && SIC_code='7011'DB:business_master_new
loadtime:0.29006791114807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cantril' limit 1
loadtime:0.29015803337097 / seconds
Query Executed:select id FROM `ia` where city='Cantril' && SIC_code='7011'DB:business_master_new
loadtime:0.29132103919983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbon' limit 1
loadtime:0.2914879322052 / seconds
Query Executed:select id FROM `ia` where city='Carbon' && SIC_code='7011'DB:business_master_new
loadtime:0.2923219203949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.29245495796204 / seconds
Query Executed:select id FROM `ia` where city='Carlisle' && SIC_code='7011'DB:business_master_new
loadtime:0.29406404495239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carnarvon' limit 1
loadtime:0.29423403739929 / seconds
Query Executed:select id FROM `ia` where city='Carnarvon' && SIC_code='7011'DB:business_master_new
loadtime:0.29504489898682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.29515600204468 / seconds
Query Executed:select id FROM `ia` where city='Carpenter' && SIC_code='7011'DB:business_master_new
loadtime:0.29609394073486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.29625797271729 / seconds
Query Executed:select id FROM `ia` where city='Carroll' && SIC_code='7011'DB:business_master_new
loadtime:0.29869508743286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.29885506629944 / seconds
Query Executed:select id FROM `ia` where city='Carson' && SIC_code='7011'DB:business_master_new
loadtime:0.30087399482727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter Lake' limit 1
loadtime:0.30092310905457 / seconds
Query Executed:select id FROM `ia` where city='Carter Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.30281805992126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.30297708511353 / seconds
Query Executed:select id FROM `ia` where city='Cascade' && SIC_code='7011'DB:business_master_new
loadtime:0.30485796928406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casey' limit 1
loadtime:0.30489301681519 / seconds
Query Executed:select id FROM `ia` where city='Casey' && SIC_code='7011'DB:business_master_new
loadtime:0.30644202232361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:0.30659699440002 / seconds
Query Executed:select id FROM `ia` where city='Castalia' && SIC_code='7011'DB:business_master_new
loadtime:0.30821704864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castana' limit 1
loadtime:0.30836200714111 / seconds
Query Executed:select id FROM `ia` where city='Castana' && SIC_code='7011'DB:business_master_new
loadtime:0.3102650642395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.31042194366455 / seconds
Query Executed:select id FROM `ia` where city='Cedar' && SIC_code='7011'DB:business_master_new
loadtime:0.31167602539062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:0.31177687644958 / seconds
Query Executed:select id FROM `ia` where city='Cedar Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.31531500816345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Rapids' limit 1
loadtime:0.31542992591858 / seconds
Query Executed:select id FROM `ia` where city='Cedar Rapids' && SIC_code='7011'DB:business_master_new
loadtime:0.33594989776611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Junction' limit 1
loadtime:0.33611798286438 / seconds
Query Executed:select id FROM `ia` where city='Center Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.33697700500488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Point' limit 1
loadtime:0.33703088760376 / seconds
Query Executed:select id FROM `ia` where city='Center Point' && SIC_code='7011'DB:business_master_new
loadtime:0.33844208717346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.33855295181274 / seconds
Query Executed:select id FROM `ia` where city='Centerville' && SIC_code='7011'DB:business_master_new
loadtime:0.34040307998657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.34049201011658 / seconds
Query Executed:select id FROM `ia` where city='Central City' && SIC_code='7011'DB:business_master_new
loadtime:0.3419029712677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.34195303916931 / seconds
Query Executed:select id FROM `ia` where city='Chapin' && SIC_code='7011'DB:business_master_new
loadtime:0.34253001213074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chariton' limit 1
loadtime:0.34256505966187 / seconds
Query Executed:select id FROM `ia` where city='Chariton' && SIC_code='7011'DB:business_master_new
loadtime:0.34413290023804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:0.34421896934509 / seconds
Query Executed:select id FROM `ia` where city='Charles City' && SIC_code='7011'DB:business_master_new
loadtime:0.34619307518005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.34633302688599 / seconds
Query Executed:select id FROM `ia` where city='Charlotte' && SIC_code='7011'DB:business_master_new
loadtime:0.34776902198792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charter Oak' limit 1
loadtime:0.34790587425232 / seconds
Query Executed:select id FROM `ia` where city='Charter Oak' && SIC_code='7011'DB:business_master_new
loadtime:0.34944891929626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:0.34956192970276 / seconds
Query Executed:select id FROM `ia` where city='Chatsworth' && SIC_code='7011'DB:business_master_new
loadtime:0.35031390190125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.35036301612854 / seconds
Query Executed:select id FROM `ia` where city='Chelsea' && SIC_code='7011'DB:business_master_new
loadtime:0.35171389579773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.35187888145447 / seconds
Query Executed:select id FROM `ia` where city='Cherokee' && SIC_code='7011'DB:business_master_new
loadtime:0.35382795333862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.35388898849487 / seconds
Query Executed:select id FROM `ia` where city='Chester' && SIC_code='7011'DB:business_master_new
loadtime:0.35486793518066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chillicothe' limit 1
loadtime:0.35499691963196 / seconds
Query Executed:select id FROM `ia` where city='Chillicothe' && SIC_code='7011'DB:business_master_new
loadtime:0.35576009750366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churdan' limit 1
loadtime:0.35580992698669 / seconds
Query Executed:select id FROM `ia` where city='Churdan' && SIC_code='7011'DB:business_master_new
loadtime:0.35739207267761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cincinnati' limit 1
loadtime:0.35743808746338 / seconds
Query Executed:select id FROM `ia` where city='Cincinnati' && SIC_code='7011'DB:business_master_new
loadtime:0.35864806175232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:0.35874199867249 / seconds
Query Executed:select id FROM `ia` where city='Clare' && SIC_code='7011'DB:business_master_new
loadtime:0.36005687713623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarence' limit 1
loadtime:0.36022996902466 / seconds
Query Executed:select id FROM `ia` where city='Clarence' && SIC_code='7011'DB:business_master_new
loadtime:0.36166501045227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarinda' limit 1
loadtime:0.36180090904236 / seconds
Query Executed:select id FROM `ia` where city='Clarinda' && SIC_code='7011'DB:business_master_new
loadtime:0.36381006240845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarion' limit 1
loadtime:0.36397194862366 / seconds
Query Executed:select id FROM `ia` where city='Clarion' && SIC_code='7011'DB:business_master_new
loadtime:0.36571907997131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.36585593223572 / seconds
Query Executed:select id FROM `ia` where city='Clarksville' && SIC_code='7011'DB:business_master_new
loadtime:0.36725091934204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.36730194091797 / seconds
Query Executed:select id FROM `ia` where city='Clear Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.36951088905334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.36967897415161 / seconds
Query Executed:select id FROM `ia` where city='Clearfield' && SIC_code='7011'DB:business_master_new
loadtime:0.37110805511475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleghorn' limit 1
loadtime:0.37124300003052 / seconds
Query Executed:select id FROM `ia` where city='Cleghorn' && SIC_code='7011'DB:business_master_new
loadtime:0.37240505218506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemons' limit 1
loadtime:0.3725380897522 / seconds
Query Executed:select id FROM `ia` where city='Clemons' && SIC_code='7011'DB:business_master_new
loadtime:0.37326598167419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clermont' limit 1
loadtime:0.37331390380859 / seconds
Query Executed:select id FROM `ia` where city='Clermont' && SIC_code='7011'DB:business_master_new
loadtime:0.37505793571472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climbing Hill' limit 1
loadtime:0.37510204315186 / seconds
Query Executed:select id FROM `ia` where city='Climbing Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.37596797943115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.37605309486389 / seconds
Query Executed:select id FROM `ia` where city='Clinton' && SIC_code='7011'DB:business_master_new
loadtime:0.37843203544617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.37850999832153 / seconds
Query Executed:select id FROM `ia` where city='Clio' && SIC_code='7011'DB:business_master_new
loadtime:0.37943196296692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clive' limit 1
loadtime:0.37954688072205 / seconds
Query Executed:select id FROM `ia` where city='Clive' && SIC_code='7011'DB:business_master_new
loadtime:0.38186192512512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clutier' limit 1
loadtime:0.38192200660706 / seconds
Query Executed:select id FROM `ia` where city='Clutier' && SIC_code='7011'DB:business_master_new
loadtime:0.38361001014709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coggon' limit 1
loadtime:0.38364791870117 / seconds
Query Executed:select id FROM `ia` where city='Coggon' && SIC_code='7011'DB:business_master_new
loadtime:0.38529205322266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coin' limit 1
loadtime:0.38534092903137 / seconds
Query Executed:select id FROM `ia` where city='Coin' && SIC_code='7011'DB:business_master_new
loadtime:0.38644099235535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colesburg' limit 1
loadtime:0.3865749835968 / seconds
Query Executed:select id FROM `ia` where city='Colesburg' && SIC_code='7011'DB:business_master_new
loadtime:0.38791608810425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.38805389404297 / seconds
Query Executed:select id FROM `ia` where city='Colfax' && SIC_code='7011'DB:business_master_new
loadtime:0.38923096656799 / seconds
Query loaded from cache:select * from geodata_geocity where city='College Springs' limit 1
loadtime:0.38935399055481 / seconds
Query Executed:select id FROM `ia` where city='College Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.38976693153381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.38981604576111 / seconds
Query Executed:select id FROM `ia` where city='Collins' && SIC_code='7011'DB:business_master_new
loadtime:0.39041709899902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colo' limit 1
loadtime:0.39046788215637 / seconds
Query Executed:select id FROM `ia` where city='Colo' && SIC_code='7011'DB:business_master_new
loadtime:0.39116406440735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.39121389389038 / seconds
Query Executed:select id FROM `ia` where city='Columbia' && SIC_code='7011'DB:business_master_new
loadtime:0.39160394668579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus City' limit 1
loadtime:0.39164710044861 / seconds
Query Executed:select id FROM `ia` where city='Columbus City' && SIC_code='7011'DB:business_master_new
loadtime:0.39204096794128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Jct' limit 1
loadtime:0.39208006858826 / seconds
Query Executed:select id FROM `ia` where city='Columbus Jct' && SIC_code='7011'DB:business_master_new
loadtime:0.39242696762085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Junction' limit 1
loadtime:0.39246296882629 / seconds
Query Executed:select id FROM `ia` where city='Columbus Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.3931450843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colwell' limit 1
loadtime:0.39320397377014 / seconds
Query Executed:select id FROM `ia` where city='Colwell' && SIC_code='7011'DB:business_master_new
loadtime:0.39353108406067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conesville' limit 1
loadtime:0.39357709884644 / seconds
Query Executed:select id FROM `ia` where city='Conesville' && SIC_code='7011'DB:business_master_new
loadtime:0.3940269947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrad' limit 1
loadtime:0.39405798912048 / seconds
Query Executed:select id FROM `ia` where city='Conrad' && SIC_code='7011'DB:business_master_new
loadtime:0.39474487304688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conroy' limit 1
loadtime:0.3947970867157 / seconds
Query Executed:select id FROM `ia` where city='Conroy' && SIC_code='7011'DB:business_master_new
loadtime:0.39517593383789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Rapids' limit 1
loadtime:0.39521598815918 / seconds
Query Executed:select id FROM `ia` where city='Coon Rapids' && SIC_code='7011'DB:business_master_new
loadtime:0.39589405059814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooper' limit 1
loadtime:0.39594101905823 / seconds
Query Executed:select id FROM `ia` where city='Cooper' && SIC_code='7011'DB:business_master_new
loadtime:0.3962550163269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coralville' limit 1
loadtime:0.39630103111267 / seconds
Query Executed:select id FROM `ia` where city='Coralville' && SIC_code='7011'DB:business_master_new
loadtime:0.39732503890991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corning' limit 1
loadtime:0.39738607406616 / seconds
Query Executed:select id FROM `ia` where city='Corning' && SIC_code='7011'DB:business_master_new
loadtime:0.39815402030945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Correctionville' limit 1
loadtime:0.398197889328 / seconds
Query Executed:select id FROM `ia` where city='Correctionville' && SIC_code='7011'DB:business_master_new
loadtime:0.39885497093201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corwith' limit 1
loadtime:0.39891695976257 / seconds
Query Executed:select id FROM `ia` where city='Corwith' && SIC_code='7011'DB:business_master_new
loadtime:0.39955997467041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corydon' limit 1
loadtime:0.39961194992065 / seconds
Query Executed:select id FROM `ia` where city='Corydon' && SIC_code='7011'DB:business_master_new
loadtime:0.40031290054321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coulter' limit 1
loadtime:0.4003529548645 / seconds
Query Executed:select id FROM `ia` where city='Coulter' && SIC_code='7011'DB:business_master_new
loadtime:0.40079188346863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council Bluffs' limit 1
loadtime:0.40084195137024 / seconds
Query Executed:select id FROM `ia` where city='Council Bluffs' && SIC_code='7011'DB:business_master_new
loadtime:0.40248394012451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawfordsville' limit 1
loadtime:0.40254807472229 / seconds
Query Executed:select id FROM `ia` where city='Crawfordsville' && SIC_code='7011'DB:business_master_new
loadtime:0.40316104888916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crescent' limit 1
loadtime:0.40321397781372 / seconds
Query Executed:select id FROM `ia` where city='Crescent' && SIC_code='7011'DB:business_master_new
loadtime:0.40399289131165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresco' limit 1
loadtime:0.40402889251709 / seconds
Query Executed:select id FROM `ia` where city='Cresco' && SIC_code='7011'DB:business_master_new
loadtime:0.40484690666199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.40490293502808 / seconds
Query Executed:select id FROM `ia` where city='Creston' && SIC_code='7011'DB:business_master_new
loadtime:0.40579605102539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.40585589408875 / seconds
Query Executed:select id FROM `ia` where city='Cromwell' && SIC_code='7011'DB:business_master_new
loadtime:0.40618109703064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Lake' limit 1
loadtime:0.40622210502625 / seconds
Query Executed:select id FROM `ia` where city='Crystal Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.40667009353638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.40672206878662 / seconds
Query Executed:select id FROM `ia` where city='Cumberland' && SIC_code='7011'DB:business_master_new
loadtime:0.40732598304749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumming' limit 1
loadtime:0.40735387802124 / seconds
Query Executed:select id FROM `ia` where city='Cumming' && SIC_code='7011'DB:business_master_new
loadtime:0.40799188613892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curlew' limit 1
loadtime:0.40804409980774 / seconds
Query Executed:select id FROM `ia` where city='Curlew' && SIC_code='7011'DB:business_master_new
loadtime:0.4084849357605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:0.40853190422058 / seconds
Query Executed:select id FROM `ia` where city='Cushing' && SIC_code='7011'DB:business_master_new
loadtime:0.40906500816345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cylinder' limit 1
loadtime:0.40912508964539 / seconds
Query Executed:select id FROM `ia` where city='Cylinder' && SIC_code='7011'DB:business_master_new
loadtime:0.40972995758057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota City' limit 1
loadtime:0.40978097915649 / seconds
Query Executed:select id FROM `ia` where city='Dakota City' && SIC_code='7011'DB:business_master_new
loadtime:0.41045808792114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.41050696372986 / seconds
Query Executed:select id FROM `ia` where city='Dallas' && SIC_code='7011'DB:business_master_new
loadtime:0.41082310676575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas Center' limit 1
loadtime:0.41086602210999 / seconds
Query Executed:select id FROM `ia` where city='Dallas Center' && SIC_code='7011'DB:business_master_new
loadtime:0.41153597831726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:0.41158294677734 / seconds
Query Executed:select id FROM `ia` where city='Dana' && SIC_code='7011'DB:business_master_new
loadtime:0.41194605827332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.41197299957275 / seconds
Query Executed:select id FROM `ia` where city='Danbury' && SIC_code='7011'DB:business_master_new
loadtime:0.41280102729797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.41284799575806 / seconds
Query Executed:select id FROM `ia` where city='Danville' && SIC_code='7011'DB:business_master_new
loadtime:0.41352200508118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:0.41356897354126 / seconds
Query Executed:select id FROM `ia` where city='Davenport' && SIC_code='7011'DB:business_master_new
loadtime:0.41568899154663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis City' limit 1
loadtime:0.41575503349304 / seconds
Query Executed:select id FROM `ia` where city='Davis City' && SIC_code='7011'DB:business_master_new
loadtime:0.41626691818237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawson' limit 1
loadtime:0.41630697250366 / seconds
Query Executed:select id FROM `ia` where city='Dawson' && SIC_code='7011'DB:business_master_new
loadtime:0.41670298576355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.41675591468811 / seconds
Query Executed:select id FROM `ia` where city='Dayton' && SIC_code='7011'DB:business_master_new
loadtime:0.41748094558716 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:0.41753602027893 / seconds
Query Executed:select id FROM `ia` where city='De Soto' && SIC_code='7011'DB:business_master_new
loadtime:0.41806888580322 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Witt' limit 1
loadtime:0.41813397407532 / seconds
Query Executed:select id FROM `ia` where city='De Witt' && SIC_code='7011'DB:business_master_new
loadtime:0.41892790794373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.41898488998413 / seconds
Query Executed:select id FROM `ia` where city='Decatur' && SIC_code='7011'DB:business_master_new
loadtime:0.41944193840027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decorah' limit 1
loadtime:0.41948390007019 / seconds
Query Executed:select id FROM `ia` where city='Decorah' && SIC_code='7011'DB:business_master_new
loadtime:0.42046308517456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.42052602767944 / seconds
Query Executed:select id FROM `ia` where city='Dedham' && SIC_code='7011'DB:business_master_new
loadtime:0.42103695869446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.42108488082886 / seconds
Query Executed:select id FROM `ia` where city='Deep River' && SIC_code='7011'DB:business_master_new
loadtime:0.42174291610718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Defiance' limit 1
loadtime:0.42178988456726 / seconds
Query Executed:select id FROM `ia` where city='Defiance' && SIC_code='7011'DB:business_master_new
loadtime:0.42246007919312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:0.42249488830566 / seconds
Query Executed:select id FROM `ia` where city='Delaware' && SIC_code='7011'DB:business_master_new
loadtime:0.42282009124756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delhi' limit 1
loadtime:0.42286896705627 / seconds
Query Executed:select id FROM `ia` where city='Delhi' && SIC_code='7011'DB:business_master_new
loadtime:0.42354893684387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmar' limit 1
loadtime:0.42360305786133 / seconds
Query Executed:select id FROM `ia` where city='Delmar' && SIC_code='7011'DB:business_master_new
loadtime:0.42418003082275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deloit' limit 1
loadtime:0.4242160320282 / seconds
Query Executed:select id FROM `ia` where city='Deloit' && SIC_code='7011'DB:business_master_new
loadtime:0.424565076828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.42461490631104 / seconds
Query Executed:select id FROM `ia` where city='Delta' && SIC_code='7011'DB:business_master_new
loadtime:0.42501187324524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denison' limit 1
loadtime:0.42504906654358 / seconds
Query Executed:select id FROM `ia` where city='Denison' && SIC_code='7011'DB:business_master_new
loadtime:0.42597198486328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.42603302001953 / seconds
Query Executed:select id FROM `ia` where city='Denmark' && SIC_code='7011'DB:business_master_new
loadtime:0.42646193504333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.42651891708374 / seconds
Query Executed:select id FROM `ia` where city='Denver' && SIC_code='7011'DB:business_master_new
loadtime:0.42716598510742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.42720293998718 / seconds
Query Executed:select id FROM `ia` where city='Derby' && SIC_code='7011'DB:business_master_new
loadtime:0.42758297920227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.42762994766235 / seconds
Query Executed:select id FROM `ia` where city='Des Moines' && SIC_code='7011'DB:business_master_new
loadtime:0.43502688407898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewar' limit 1
loadtime:0.43512296676636 / seconds
Query Executed:select id FROM `ia` where city='Dewar' && SIC_code='7011'DB:business_master_new
loadtime:0.43552207946777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.43557596206665 / seconds
Query Executed:select id FROM `ia` where city='Dexter' && SIC_code='7011'DB:business_master_new
loadtime:0.43624591827393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diagonal' limit 1
loadtime:0.4362781047821 / seconds
Query Executed:select id FROM `ia` where city='Diagonal' && SIC_code='7011'DB:business_master_new
loadtime:0.4368360042572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickens' limit 1
loadtime:0.43688797950745 / seconds
Query Executed:select id FROM `ia` where city='Dickens' && SIC_code='7011'DB:business_master_new
loadtime:0.43743991851807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dike' limit 1
loadtime:0.43747591972351 / seconds
Query Executed:select id FROM `ia` where city='Dike' && SIC_code='7011'DB:business_master_new
loadtime:0.43821907043457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.43826603889465 / seconds
Query Executed:select id FROM `ia` where city='Dixon' && SIC_code='7011'DB:business_master_new
loadtime:0.43890309333801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolliver' limit 1
loadtime:0.43895292282104 / seconds
Query Executed:select id FROM `ia` where city='Dolliver' && SIC_code='7011'DB:business_master_new
loadtime:0.43931603431702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donahue' limit 1
loadtime:0.43935990333557 / seconds
Query Executed:select id FROM `ia` where city='Donahue' && SIC_code='7011'DB:business_master_new
loadtime:0.4399209022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donnellson' limit 1
loadtime:0.4399619102478 / seconds
Query Executed:select id FROM `ia` where city='Donnellson' && SIC_code='7011'DB:business_master_new
loadtime:0.4406909942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doon' limit 1
loadtime:0.44076299667358 / seconds
Query Executed:select id FROM `ia` where city='Doon' && SIC_code='7011'DB:business_master_new
loadtime:0.44162702560425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.44167399406433 / seconds
Query Executed:select id FROM `ia` where city='Dorchester' && SIC_code='7011'DB:business_master_new
loadtime:0.4422459602356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douds' limit 1
loadtime:0.44228291511536 / seconds
Query Executed:select id FROM `ia` where city='Douds' && SIC_code='7011'DB:business_master_new
loadtime:0.44284987449646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dougherty' limit 1
loadtime:0.44289994239807 / seconds
Query Executed:select id FROM `ia` where city='Dougherty' && SIC_code='7011'DB:business_master_new
loadtime:0.4434061050415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dow City' limit 1
loadtime:0.44344592094421 / seconds
Query Executed:select id FROM `ia` where city='Dow City' && SIC_code='7011'DB:business_master_new
loadtime:0.44496989250183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dows' limit 1
loadtime:0.44508409500122 / seconds
Query Executed:select id FROM `ia` where city='Dows' && SIC_code='7011'DB:business_master_new
loadtime:0.44736504554749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakesville' limit 1
loadtime:0.44748687744141 / seconds
Query Executed:select id FROM `ia` where city='Drakesville' && SIC_code='7011'DB:business_master_new
loadtime:0.44877910614014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dubuque' limit 1
loadtime:0.44882988929749 / seconds
Query Executed:select id FROM `ia` where city='Dubuque' && SIC_code='7011'DB:business_master_new
loadtime:0.45308589935303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:0.45327496528625 / seconds
Query Executed:select id FROM `ia` where city='Dumont' && SIC_code='7011'DB:business_master_new
loadtime:0.45560193061829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncombe' limit 1
loadtime:0.45571804046631 / seconds
Query Executed:select id FROM `ia` where city='Duncombe' && SIC_code='7011'DB:business_master_new
loadtime:0.45723009109497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.45736408233643 / seconds
Query Executed:select id FROM `ia` where city='Dundee' && SIC_code='7011'DB:business_master_new
loadtime:0.45876407623291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunkerton' limit 1
loadtime:0.45891809463501 / seconds
Query Executed:select id FROM `ia` where city='Dunkerton' && SIC_code='7011'DB:business_master_new
loadtime:0.46107888221741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunlap' limit 1
loadtime:0.46122598648071 / seconds
Query Executed:select id FROM `ia` where city='Dunlap' && SIC_code='7011'DB:business_master_new
loadtime:0.46316504478455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:0.46332192420959 / seconds
Query Executed:select id FROM `ia` where city='Durango' && SIC_code='7011'DB:business_master_new
loadtime:0.46503400802612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.46522808074951 / seconds
Query Executed:select id FROM `ia` where city='Durant' && SIC_code='7011'DB:business_master_new
loadtime:0.46705603599548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyersville' limit 1
loadtime:0.46720695495605 / seconds
Query Executed:select id FROM `ia` where city='Dyersville' && SIC_code='7011'DB:business_master_new
loadtime:0.46914196014404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dysart' limit 1
loadtime:0.46922492980957 / seconds
Query Executed:select id FROM `ia` where city='Dysart' && SIC_code='7011'DB:business_master_new
loadtime:0.47110199928284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Grove' limit 1
loadtime:0.47127103805542 / seconds
Query Executed:select id FROM `ia` where city='Eagle Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.4727840423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlham' limit 1
loadtime:0.4728319644928 / seconds
Query Executed:select id FROM `ia` where city='Earlham' && SIC_code='7011'DB:business_master_new
loadtime:0.47457695007324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earling' limit 1
loadtime:0.47470498085022 / seconds
Query Executed:select id FROM `ia` where city='Earling' && SIC_code='7011'DB:business_master_new
loadtime:0.4760890007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlville' limit 1
loadtime:0.47620606422424 / seconds
Query Executed:select id FROM `ia` where city='Earlville' && SIC_code='7011'DB:business_master_new
loadtime:0.47729206085205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early' limit 1
loadtime:0.47742199897766 / seconds
Query Executed:select id FROM `ia` where city='Early' && SIC_code='7011'DB:business_master_new
loadtime:0.47929000854492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eddyville' limit 1
loadtime:0.47944808006287 / seconds
Query Executed:select id FROM `ia` where city='Eddyville' && SIC_code='7011'DB:business_master_new
loadtime:0.48098587989807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.48117899894714 / seconds
Query Executed:select id FROM `ia` where city='Edgewood' && SIC_code='7011'DB:business_master_new
loadtime:0.48299503326416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:0.48316693305969 / seconds
Query Executed:select id FROM `ia` where city='Elberon' && SIC_code='7011'DB:business_master_new
loadtime:0.48444604873657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldon' limit 1
loadtime:0.48458003997803 / seconds
Query Executed:select id FROM `ia` where city='Eldon' && SIC_code='7011'DB:business_master_new
loadtime:0.48567700386047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldora' limit 1
loadtime:0.48580098152161 / seconds
Query Executed:select id FROM `ia` where city='Eldora' && SIC_code='7011'DB:business_master_new
loadtime:0.48776388168335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:0.48791909217834 / seconds
Query Executed:select id FROM `ia` where city='Eldorado' && SIC_code='7011'DB:business_master_new
loadtime:0.48879408836365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldridge' limit 1
loadtime:0.48884105682373 / seconds
Query Executed:select id FROM `ia` where city='Eldridge' && SIC_code='7011'DB:business_master_new
loadtime:0.49040007591248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.4905469417572 / seconds
Query Executed:select id FROM `ia` where city='Elgin' && SIC_code='7011'DB:business_master_new
loadtime:0.49186301231384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Horn' limit 1
loadtime:0.49191188812256 / seconds
Query Executed:select id FROM `ia` where city='Elk Horn' && SIC_code='7011'DB:business_master_new
loadtime:0.49308204650879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Run Heights' limit 1
loadtime:0.49315500259399 / seconds
Query Executed:select id FROM `ia` where city='Elk Run Heights' && SIC_code='7011'DB:business_master_new
loadtime:0.49353003501892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkader' limit 1
loadtime:0.49358296394348 / seconds
Query Executed:select id FROM `ia` where city='Elkader' && SIC_code='7011'DB:business_master_new
loadtime:0.49527788162231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart' limit 1
loadtime:0.49543309211731 / seconds
Query Executed:select id FROM `ia` where city='Elkhart' && SIC_code='7011'DB:business_master_new
loadtime:0.49656891822815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkport' limit 1
loadtime:0.49661898612976 / seconds
Query Executed:select id FROM `ia` where city='Elkport' && SIC_code='7011'DB:business_master_new
loadtime:0.49704098701477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.49718308448792 / seconds
Query Executed:select id FROM `ia` where city='Elliott' && SIC_code='7011'DB:business_master_new
loadtime:0.49852108955383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellston' limit 1
loadtime:0.49860310554504 / seconds
Query Executed:select id FROM `ia` where city='Ellston' && SIC_code='7011'DB:business_master_new
loadtime:0.49980497360229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.49995493888855 / seconds
Query Executed:select id FROM `ia` where city='Ellsworth' && SIC_code='7011'DB:business_master_new
loadtime:0.50104403495789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elma' limit 1
loadtime:0.50120496749878 / seconds
Query Executed:select id FROM `ia` where city='Elma' && SIC_code='7011'DB:business_master_new
loadtime:0.50264406204224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:0.50277805328369 / seconds
Query Executed:select id FROM `ia` where city='Elwood' && SIC_code='7011'DB:business_master_new
loadtime:0.50350689888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ely' limit 1
loadtime:0.50354409217834 / seconds
Query Executed:select id FROM `ia` where city='Ely' && SIC_code='7011'DB:business_master_new
loadtime:0.50501298904419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:0.50506711006165 / seconds
Query Executed:select id FROM `ia` where city='Emerson' && SIC_code='7011'DB:business_master_new
loadtime:0.5061891078949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmetsburg' limit 1
loadtime:0.50622391700745 / seconds
Query Executed:select id FROM `ia` where city='Emmetsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.50758600234985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epworth' limit 1
loadtime:0.5077600479126 / seconds
Query Executed:select id FROM `ia` where city='Epworth' && SIC_code='7011'DB:business_master_new
loadtime:0.50894808769226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.50899696350098 / seconds
Query Executed:select id FROM `ia` where city='Essex' && SIC_code='7011'DB:business_master_new
loadtime:0.51048493385315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estherville' limit 1
loadtime:0.51060700416565 / seconds
Query Executed:select id FROM `ia` where city='Estherville' && SIC_code='7011'DB:business_master_new
loadtime:0.51250696182251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansdale' limit 1
loadtime:0.51264190673828 / seconds
Query Executed:select id FROM `ia` where city='Evansdale' && SIC_code='7011'DB:business_master_new
loadtime:0.51403307914734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everly' limit 1
loadtime:0.51411700248718 / seconds
Query Executed:select id FROM `ia` where city='Everly' && SIC_code='7011'DB:business_master_new
loadtime:0.51578307151794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exira' limit 1
loadtime:0.51581788063049 / seconds
Query Executed:select id FROM `ia` where city='Exira' && SIC_code='7011'DB:business_master_new
loadtime:0.5171480178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exline' limit 1
loadtime:0.51729106903076 / seconds
Query Executed:select id FROM `ia` where city='Exline' && SIC_code='7011'DB:business_master_new
loadtime:0.51789593696594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairbank' limit 1
loadtime:0.51800608634949 / seconds
Query Executed:select id FROM `ia` where city='Fairbank' && SIC_code='7011'DB:business_master_new
loadtime:0.51945495605469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.51959705352783 / seconds
Query Executed:select id FROM `ia` where city='Fairfax' && SIC_code='7011'DB:business_master_new
loadtime:0.52119588851929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.52133107185364 / seconds
Query Executed:select id FROM `ia` where city='Fairfield' && SIC_code='7011'DB:business_master_new
loadtime:0.52392888069153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farley' limit 1
loadtime:0.52406907081604 / seconds
Query Executed:select id FROM `ia` where city='Farley' && SIC_code='7011'DB:business_master_new
loadtime:0.52523708343506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmersburg' limit 1
loadtime:0.52538108825684 / seconds
Query Executed:select id FROM `ia` where city='Farmersburg' && SIC_code='7011'DB:business_master_new
loadtime:0.52674388885498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.52690410614014 / seconds
Query Executed:select id FROM `ia` where city='Farmington' && SIC_code='7011'DB:business_master_new
loadtime:0.52832698822021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnhamville' limit 1
loadtime:0.52844595909119 / seconds
Query Executed:select id FROM `ia` where city='Farnhamville' && SIC_code='7011'DB:business_master_new
loadtime:0.53006100654602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farragut' limit 1
loadtime:0.53012609481812 / seconds
Query Executed:select id FROM `ia` where city='Farragut' && SIC_code='7011'DB:business_master_new
loadtime:0.53167104721069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.53179907798767 / seconds
Query Executed:select id FROM `ia` where city='Fayette' && SIC_code='7011'DB:business_master_new
loadtime:0.53337907791138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:0.53353595733643 / seconds
Query Executed:select id FROM `ia` where city='Fenton' && SIC_code='7011'DB:business_master_new
loadtime:0.53499794006348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:0.5351459980011 / seconds
Query Executed:select id FROM `ia` where city='Ferguson' && SIC_code='7011'DB:business_master_new
loadtime:0.53575110435486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fertile' limit 1
loadtime:0.53588891029358 / seconds
Query Executed:select id FROM `ia` where city='Fertile' && SIC_code='7011'DB:business_master_new
loadtime:0.53734397888184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Festina' limit 1
loadtime:0.53738689422607 / seconds
Query Executed:select id FROM `ia` where city='Festina' && SIC_code='7011'DB:business_master_new
loadtime:0.53781199455261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floris' limit 1
loadtime:0.53790187835693 / seconds
Query Executed:select id FROM `ia` where city='Floris' && SIC_code='7011'DB:business_master_new
loadtime:0.53902387619019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.53915810585022 / seconds
Query Executed:select id FROM `ia` where city='Floyd' && SIC_code='7011'DB:business_master_new
loadtime:0.54056787490845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fonda' limit 1
loadtime:0.54066300392151 / seconds
Query Executed:select id FROM `ia` where city='Fonda' && SIC_code='7011'DB:business_master_new
loadtime:0.54218006134033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontanelle' limit 1
loadtime:0.54231309890747 / seconds
Query Executed:select id FROM `ia` where city='Fontanelle' && SIC_code='7011'DB:business_master_new
loadtime:0.54372191429138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:0.54383206367493 / seconds
Query Executed:select id FROM `ia` where city='Forest City' && SIC_code='7011'DB:business_master_new
loadtime:0.54542708396912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:0.5455949306488 / seconds
Query Executed:select id FROM `ia` where city='Fort Atkinson' && SIC_code='7011'DB:business_master_new
loadtime:0.54719090461731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dodge' limit 1
loadtime:0.5473370552063 / seconds
Query Executed:select id FROM `ia` where city='Fort Dodge' && SIC_code='7011'DB:business_master_new
loadtime:0.55025005340576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Madison' limit 1
loadtime:0.55041289329529 / seconds
Query Executed:select id FROM `ia` where city='Fort Madison' && SIC_code='7011'DB:business_master_new
loadtime:0.55301690101624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:0.55321788787842 / seconds
Query Executed:select id FROM `ia` where city='Fostoria' && SIC_code='7011'DB:business_master_new
loadtime:0.55421996116638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:0.55435800552368 / seconds
Query Executed:select id FROM `ia` where city='Fredericksburg' && SIC_code='7011'DB:business_master_new
loadtime:0.55636501312256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederika' limit 1
loadtime:0.55651903152466 / seconds
Query Executed:select id FROM `ia` where city='Frederika' && SIC_code='7011'DB:business_master_new
loadtime:0.55722594261169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.55736303329468 / seconds
Query Executed:select id FROM `ia` where city='Fremont' && SIC_code='7011'DB:business_master_new
loadtime:0.55901193618774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.55919098854065 / seconds
Query Executed:select id FROM `ia` where city='Fruitland' && SIC_code='7011'DB:business_master_new
loadtime:0.56024408340454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galt' limit 1
loadtime:0.56033992767334 / seconds
Query Executed:select id FROM `ia` where city='Galt' && SIC_code='7011'DB:business_master_new
loadtime:0.56096601486206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galva' limit 1
loadtime:0.56108999252319 / seconds
Query Executed:select id FROM `ia` where city='Galva' && SIC_code='7011'DB:business_master_new
loadtime:0.56291389465332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garber' limit 1
loadtime:0.56305599212646 / seconds
Query Executed:select id FROM `ia` where city='Garber' && SIC_code='7011'DB:business_master_new
loadtime:0.56393098831177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.56404805183411 / seconds
Query Executed:select id FROM `ia` where city='Garden City' && SIC_code='7011'DB:business_master_new
loadtime:0.56501507759094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden Grove' limit 1
loadtime:0.5651650428772 / seconds
Query Executed:select id FROM `ia` where city='Garden Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.56622409820557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnavillo' limit 1
loadtime:0.56635808944702 / seconds
Query Executed:select id FROM `ia` where city='Garnavillo' && SIC_code='7011'DB:business_master_new
loadtime:0.56823587417603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:0.56833910942078 / seconds
Query Executed:select id FROM `ia` where city='Garner' && SIC_code='7011'DB:business_master_new
loadtime:0.57039499282837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.57054996490479 / seconds
Query Executed:select id FROM `ia` where city='Garrison' && SIC_code='7011'DB:business_master_new
loadtime:0.57232689857483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwin' limit 1
loadtime:0.57246804237366 / seconds
Query Executed:select id FROM `ia` where city='Garwin' && SIC_code='7011'DB:business_master_new
loadtime:0.57436800003052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geneva' limit 1
loadtime:0.57452297210693 / seconds
Query Executed:select id FROM `ia` where city='Geneva' && SIC_code='7011'DB:business_master_new
loadtime:0.5759220123291 / seconds
Query loaded from cache:select * from geodata_geocity where city='George' limit 1
loadtime:0.57606887817383 / seconds
Query Executed:select id FROM `ia` where city='George' && SIC_code='7011'DB:business_master_new
loadtime:0.57799792289734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:0.57818102836609 / seconds
Query Executed:select id FROM `ia` where city='Gibson' && SIC_code='7011'DB:business_master_new
loadtime:0.5789749622345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.57908797264099 / seconds
Query Executed:select id FROM `ia` where city='Gifford' && SIC_code='7011'DB:business_master_new
loadtime:0.57999992370605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.5801739692688 / seconds
Query Executed:select id FROM `ia` where city='Gilbert' && SIC_code='7011'DB:business_master_new
loadtime:0.58192610740662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.58205795288086 / seconds
Query Executed:select id FROM `ia` where city='Gilbertville' && SIC_code='7011'DB:business_master_new
loadtime:0.58298301696777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett Grove' limit 1
loadtime:0.58314990997314 / seconds
Query Executed:select id FROM `ia` where city='Gillett Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.58421111106873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.5843460559845 / seconds
Query Executed:select id FROM `ia` where city='Gilman' && SIC_code='7011'DB:business_master_new
loadtime:0.58630108833313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmore City' limit 1
loadtime:0.58641695976257 / seconds
Query Executed:select id FROM `ia` where city='Gilmore City' && SIC_code='7011'DB:business_master_new
loadtime:0.58825302124023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladbrook' limit 1
loadtime:0.58830308914185 / seconds
Query Executed:select id FROM `ia` where city='Gladbrook' && SIC_code='7011'DB:business_master_new
loadtime:0.58944702148438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.58959102630615 / seconds
Query Executed:select id FROM `ia` where city='Glenwood' && SIC_code='7011'DB:business_master_new
loadtime:0.59151792526245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:0.59157800674438 / seconds
Query Executed:select id FROM `ia` where city='Glidden' && SIC_code='7011'DB:business_master_new
loadtime:0.59293603897095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldfield' limit 1
loadtime:0.59297204017639 / seconds
Query Executed:select id FROM `ia` where city='Goldfield' && SIC_code='7011'DB:business_master_new
loadtime:0.59477090835571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodell' limit 1
loadtime:0.59490394592285 / seconds
Query Executed:select id FROM `ia` where city='Goodell' && SIC_code='7011'DB:business_master_new
loadtime:0.59599804878235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Lake' limit 1
loadtime:0.59609603881836 / seconds
Query Executed:select id FROM `ia` where city='Goose Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.59740400314331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowrie' limit 1
loadtime:0.59753799438477 / seconds
Query Executed:select id FROM `ia` where city='Gowrie' && SIC_code='7011'DB:business_master_new
loadtime:0.59940695762634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graettinger' limit 1
loadtime:0.59955596923828 / seconds
Query Executed:select id FROM `ia` where city='Graettinger' && SIC_code='7011'DB:business_master_new
loadtime:0.60117697715759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.60131907463074 / seconds
Query Executed:select id FROM `ia` where city='Grafton' && SIC_code='7011'DB:business_master_new
loadtime:0.6027250289917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:0.60276889801025 / seconds
Query Executed:select id FROM `ia` where city='Grand Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.60460591316223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Mound' limit 1
loadtime:0.60479593276978 / seconds
Query Executed:select id FROM `ia` where city='Grand Mound' && SIC_code='7011'DB:business_master_new
loadtime:0.60629510879517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand River' limit 1
loadtime:0.6064510345459 / seconds
Query Executed:select id FROM `ia` where city='Grand River' && SIC_code='7011'DB:business_master_new
loadtime:0.607745885849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandview' limit 1
loadtime:0.6078839302063 / seconds
Query Executed:select id FROM `ia` where city='Grandview' && SIC_code='7011'DB:business_master_new
loadtime:0.60887598991394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granger' limit 1
loadtime:0.60892295837402 / seconds
Query Executed:select id FROM `ia` where city='Granger' && SIC_code='7011'DB:business_master_new
loadtime:0.61077904701233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:0.61091494560242 / seconds
Query Executed:select id FROM `ia` where city='Grant' && SIC_code='7011'DB:business_master_new
loadtime:0.61189007759094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.61202192306519 / seconds
Query Executed:select id FROM `ia` where city='Granville' && SIC_code='7011'DB:business_master_new
loadtime:0.6136109828949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gravity' limit 1
loadtime:0.61372590065002 / seconds
Query Executed:select id FROM `ia` where city='Gravity' && SIC_code='7011'DB:business_master_new
loadtime:0.61487507820129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray' limit 1
loadtime:0.61496996879578 / seconds
Query Executed:select id FROM `ia` where city='Gray' && SIC_code='7011'DB:business_master_new
loadtime:0.61591506004333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:0.61604595184326 / seconds
Query Executed:select id FROM `ia` where city='Greeley' && SIC_code='7011'DB:business_master_new
loadtime:0.61691999435425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:0.61696791648865 / seconds
Query Executed:select id FROM `ia` where city='Green Mountain' && SIC_code='7011'DB:business_master_new
loadtime:0.61778593063354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greene' limit 1
loadtime:0.61792802810669 / seconds
Query Executed:select id FROM `ia` where city='Greene' && SIC_code='7011'DB:business_master_new
loadtime:0.61966896057129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.61980199813843 / seconds
Query Executed:select id FROM `ia` where city='Greenfield' && SIC_code='7011'DB:business_master_new
loadtime:0.62197208404541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.62215709686279 / seconds
Query Executed:select id FROM `ia` where city='Greenville' && SIC_code='7011'DB:business_master_new
loadtime:0.62324500083923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimes' limit 1
loadtime:0.62336897850037 / seconds
Query Executed:select id FROM `ia` where city='Grimes' && SIC_code='7011'DB:business_master_new
loadtime:0.62555503845215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grinnell' limit 1
loadtime:0.62570905685425 / seconds
Query Executed:select id FROM `ia` where city='Grinnell' && SIC_code='7011'DB:business_master_new
loadtime:0.62838506698608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Griswold' limit 1
loadtime:0.62856197357178 / seconds
Query Executed:select id FROM `ia` where city='Griswold' && SIC_code='7011'DB:business_master_new
loadtime:0.63060998916626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy Center' limit 1
loadtime:0.63075804710388 / seconds
Query Executed:select id FROM `ia` where city='Grundy Center' && SIC_code='7011'DB:business_master_new
loadtime:0.63288807868958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gruver' limit 1
loadtime:0.63304591178894 / seconds
Query Executed:select id FROM `ia` where city='Gruver' && SIC_code='7011'DB:business_master_new
loadtime:0.63362193107605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guernsey' limit 1
loadtime:0.63375902175903 / seconds
Query Executed:select id FROM `ia` where city='Guernsey' && SIC_code='7011'DB:business_master_new
loadtime:0.63500189781189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guthrie Center' limit 1
loadtime:0.63516592979431 / seconds
Query Executed:select id FROM `ia` where city='Guthrie Center' && SIC_code='7011'DB:business_master_new
loadtime:0.63722896575928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:0.63734793663025 / seconds
Query Executed:select id FROM `ia` where city='Guttenberg' && SIC_code='7011'DB:business_master_new
loadtime:0.63906288146973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halbur' limit 1
loadtime:0.63921189308167 / seconds
Query Executed:select id FROM `ia` where city='Halbur' && SIC_code='7011'DB:business_master_new
loadtime:0.64039897918701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:0.64054107666016 / seconds
Query Executed:select id FROM `ia` where city='Hamburg' && SIC_code='7011'DB:business_master_new
loadtime:0.64220905303955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.64236187934875 / seconds
Query Executed:select id FROM `ia` where city='Hamilton' && SIC_code='7011'DB:business_master_new
loadtime:0.64325594902039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlin' limit 1
loadtime:0.64329695701599 / seconds
Query Executed:select id FROM `ia` where city='Hamlin' && SIC_code='7011'DB:business_master_new
loadtime:0.64408087730408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.6442539691925 / seconds
Query Executed:select id FROM `ia` where city='Hampton' && SIC_code='7011'DB:business_master_new
loadtime:0.64604306221008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.64623999595642 / seconds
Query Executed:select id FROM `ia` where city='Hancock' && SIC_code='7011'DB:business_master_new
loadtime:0.6478579044342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanlontown' limit 1
loadtime:0.64797687530518 / seconds
Query Executed:select id FROM `ia` where city='Hanlontown' && SIC_code='7011'DB:business_master_new
loadtime:0.64906787872314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hansell' limit 1
loadtime:0.64917206764221 / seconds
Query Executed:select id FROM `ia` where city='Hansell' && SIC_code='7011'DB:business_master_new
loadtime:0.64992904663086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harcourt' limit 1
loadtime:0.65003895759583 / seconds
Query Executed:select id FROM `ia` where city='Harcourt' && SIC_code='7011'DB:business_master_new
loadtime:0.65123701095581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:0.65136408805847 / seconds
Query Executed:select id FROM `ia` where city='Hardy' && SIC_code='7011'DB:business_master_new
loadtime:0.65243887901306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harlan' limit 1
loadtime:0.65257596969604 / seconds
Query Executed:select id FROM `ia` where city='Harlan' && SIC_code='7011'DB:business_master_new
loadtime:0.65414500236511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:0.65431499481201 / seconds
Query Executed:select id FROM `ia` where city='Harper' && SIC_code='7011'DB:business_master_new
loadtime:0.6555860042572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harpers Ferry' limit 1
loadtime:0.65572094917297 / seconds
Query Executed:select id FROM `ia` where city='Harpers Ferry' && SIC_code='7011'DB:business_master_new
loadtime:0.65725493431091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:0.65738892555237 / seconds
Query Executed:select id FROM `ia` where city='Harris' && SIC_code='7011'DB:business_master_new
loadtime:0.65876007080078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.65890192985535 / seconds
Query Executed:select id FROM `ia` where city='Hartford' && SIC_code='7011'DB:business_master_new
loadtime:0.65966796875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartley' limit 1
loadtime:0.65980100631714 / seconds
Query Executed:select id FROM `ia` where city='Hartley' && SIC_code='7011'DB:business_master_new
loadtime:0.66143608093262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwick' limit 1
loadtime:0.66155004501343 / seconds
Query Executed:select id FROM `ia` where city='Hartwick' && SIC_code='7011'DB:business_master_new
loadtime:0.66261601448059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:0.66274499893188 / seconds
Query Executed:select id FROM `ia` where city='Harvey' && SIC_code='7011'DB:business_master_new
loadtime:0.66391396522522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:0.66404795646667 / seconds
Query Executed:select id FROM `ia` where city='Hastings' && SIC_code='7011'DB:business_master_new
loadtime:0.66484189033508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:0.66489100456238 / seconds
Query Executed:select id FROM `ia` where city='Havelock' && SIC_code='7011'DB:business_master_new
loadtime:0.66629695892334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.66643500328064 / seconds
Query Executed:select id FROM `ia` where city='Haverhill' && SIC_code='7011'DB:business_master_new
loadtime:0.66771101951599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawarden' limit 1
loadtime:0.66780710220337 / seconds
Query Executed:select id FROM `ia` where city='Hawarden' && SIC_code='7011'DB:business_master_new
loadtime:0.66937708854675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkeye' limit 1
loadtime:0.66947603225708 / seconds
Query Executed:select id FROM `ia` where city='Hawkeye' && SIC_code='7011'DB:business_master_new
loadtime:0.67123508453369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:0.67139196395874 / seconds
Query Executed:select id FROM `ia` where city='Hayesville' && SIC_code='7011'DB:business_master_new
loadtime:0.67233490943909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazleton' limit 1
loadtime:0.67246294021606 / seconds
Query Executed:select id FROM `ia` where city='Hazleton' && SIC_code='7011'DB:business_master_new
loadtime:0.67397904396057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hedrick' limit 1
loadtime:0.6741681098938 / seconds
Query Executed:select id FROM `ia` where city='Hedrick' && SIC_code='7011'DB:business_master_new
loadtime:0.67598390579224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.67617011070251 / seconds
Query Executed:select id FROM `ia` where city='Henderson' && SIC_code='7011'DB:business_master_new
loadtime:0.6775050163269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.67763996124268 / seconds
Query Executed:select id FROM `ia` where city='Hiawatha' && SIC_code='7011'DB:business_master_new
loadtime:0.6795380115509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlandville' limit 1
loadtime:0.6795859336853 / seconds
Query Executed:select id FROM `ia` where city='Highlandville' && SIC_code='7011'DB:business_master_new
loadtime:0.68038392066956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hills' limit 1
loadtime:0.68048501014709 / seconds
Query Executed:select id FROM `ia` where city='Hills' && SIC_code='7011'DB:business_master_new
loadtime:0.68210291862488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.68227100372314 / seconds
Query Executed:select id FROM `ia` where city='Hillsboro' && SIC_code='7011'DB:business_master_new
loadtime:0.68344902992249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:0.68354988098145 / seconds
Query Executed:select id FROM `ia` where city='Hinton' && SIC_code='7011'DB:business_master_new
loadtime:0.68535590171814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:0.68548893928528 / seconds
Query Executed:select id FROM `ia` where city='Holland' && SIC_code='7011'DB:business_master_new
loadtime:0.68695998191833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holstein' limit 1
loadtime:0.68709492683411 / seconds
Query Executed:select id FROM `ia` where city='Holstein' && SIC_code='7011'DB:business_master_new
loadtime:0.68910193443298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holy Cross' limit 1
loadtime:0.68927097320557 / seconds
Query Executed:select id FROM `ia` where city='Holy Cross' && SIC_code='7011'DB:business_master_new
loadtime:0.69074106216431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homestead' limit 1
loadtime:0.69087505340576 / seconds
Query Executed:select id FROM `ia` where city='Homestead' && SIC_code='7011'DB:business_master_new
loadtime:0.69172191619873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:0.69181394577026 / seconds
Query Executed:select id FROM `ia` where city='Honey Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.69303202629089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.69321298599243 / seconds
Query Executed:select id FROM `ia` where city='Hopkinton' && SIC_code='7011'DB:business_master_new
loadtime:0.69497299194336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hornick' limit 1
loadtime:0.69508409500122 / seconds
Query Executed:select id FROM `ia` where city='Hornick' && SIC_code='7011'DB:business_master_new
loadtime:0.6964590549469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hospers' limit 1
loadtime:0.69659209251404 / seconds
Query Executed:select id FROM `ia` where city='Hospers' && SIC_code='7011'DB:business_master_new
loadtime:0.69819307327271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.69833302497864 / seconds
Query Executed:select id FROM `ia` where city='Houghton' && SIC_code='7011'DB:business_master_new
loadtime:0.69973802566528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard' limit 1
loadtime:0.69982409477234 / seconds
Query Executed:select id FROM `ia` where city='Hubbard' && SIC_code='7011'DB:business_master_new
loadtime:0.70135307312012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.70148706436157 / seconds
Query Executed:select id FROM `ia` where city='Hudson' && SIC_code='7011'DB:business_master_new
loadtime:0.70347595214844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:0.70362901687622 / seconds
Query Executed:select id FROM `ia` where city='Hull' && SIC_code='7011'DB:business_master_new
loadtime:0.70527410507202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.70540404319763 / seconds
Query Executed:select id FROM `ia` where city='Humboldt' && SIC_code='7011'DB:business_master_new
loadtime:0.70777797698975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humeston' limit 1
loadtime:0.70789694786072 / seconds
Query Executed:select id FROM `ia` where city='Humeston' && SIC_code='7011'DB:business_master_new
loadtime:0.70977592468262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huxley' limit 1
loadtime:0.70987391471863 / seconds
Query Executed:select id FROM `ia` where city='Huxley' && SIC_code='7011'DB:business_master_new
loadtime:0.71178603172302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida Grove' limit 1
loadtime:0.71189999580383 / seconds
Query Executed:select id FROM `ia` where city='Ida Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.71399807929993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imogene' limit 1
loadtime:0.71418905258179 / seconds
Query Executed:select id FROM `ia` where city='Imogene' && SIC_code='7011'DB:business_master_new
loadtime:0.71537709236145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.71551299095154 / seconds
Query Executed:select id FROM `ia` where city='Independence' && SIC_code='7011'DB:business_master_new
loadtime:0.7181670665741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:0.71832895278931 / seconds
Query Executed:select id FROM `ia` where city='Indianola' && SIC_code='7011'DB:business_master_new
loadtime:0.72095489501953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inwood' limit 1
loadtime:0.72110104560852 / seconds
Query Executed:select id FROM `ia` where city='Inwood' && SIC_code='7011'DB:business_master_new
loadtime:0.72283101081848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:0.72288107872009 / seconds
Query Executed:select id FROM `ia` where city='Ionia' && SIC_code='7011'DB:business_master_new
loadtime:0.7246630191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa City' limit 1
loadtime:0.72479605674744 / seconds
Query Executed:select id FROM `ia` where city='Iowa City' && SIC_code='7011'DB:business_master_new
loadtime:0.72893404960632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa Falls' limit 1
loadtime:0.72905302047729 / seconds
Query Executed:select id FROM `ia` where city='Iowa Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.73095202445984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:0.73116707801819 / seconds
Query Executed:select id FROM `ia` where city='Ira' && SIC_code='7011'DB:business_master_new
loadtime:0.73204898834229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ireton' limit 1
loadtime:0.73218488693237 / seconds
Query Executed:select id FROM `ia` where city='Ireton' && SIC_code='7011'DB:business_master_new
loadtime:0.73363304138184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irwin' limit 1
loadtime:0.73376798629761 / seconds
Query Executed:select id FROM `ia` where city='Irwin' && SIC_code='7011'DB:business_master_new
loadtime:0.73567891120911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Junction' limit 1
loadtime:0.73581194877625 / seconds
Query Executed:select id FROM `ia` where city='Jackson Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.73672199249268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.73680400848389 / seconds
Query Executed:select id FROM `ia` where city='Jamaica' && SIC_code='7011'DB:business_master_new
loadtime:0.73758292198181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:0.73771095275879 / seconds
Query Executed:select id FROM `ia` where city='Janesville' && SIC_code='7011'DB:business_master_new
loadtime:0.73962998390198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.73977208137512 / seconds
Query Executed:select id FROM `ia` where city='Jefferson' && SIC_code='7011'DB:business_master_new
loadtime:0.74204111099243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jesup' limit 1
loadtime:0.74223303794861 / seconds
Query Executed:select id FROM `ia` where city='Jesup' && SIC_code='7011'DB:business_master_new
loadtime:0.74423694610596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell' limit 1
loadtime:0.74439311027527 / seconds
Query Executed:select id FROM `ia` where city='Jewell' && SIC_code='7011'DB:business_master_new
loadtime:0.74580788612366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.74594807624817 / seconds
Query Executed:select id FROM `ia` where city='Johnston' && SIC_code='7011'DB:business_master_new
loadtime:0.74805808067322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joice' limit 1
loadtime:0.74823498725891 / seconds
Query Executed:select id FROM `ia` where city='Joice' && SIC_code='7011'DB:business_master_new
loadtime:0.74943804740906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jolley' limit 1
loadtime:0.74948787689209 / seconds
Query Executed:select id FROM `ia` where city='Jolley' && SIC_code='7011'DB:business_master_new
loadtime:0.75017094612122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalona' limit 1
loadtime:0.75026702880859 / seconds
Query Executed:select id FROM `ia` where city='Kalona' && SIC_code='7011'DB:business_master_new
loadtime:0.75195097923279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamrar' limit 1
loadtime:0.75207090377808 / seconds
Query Executed:select id FROM `ia` where city='Kamrar' && SIC_code='7011'DB:business_master_new
loadtime:0.7529149055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanawha' limit 1
loadtime:0.75296401977539 / seconds
Query Executed:select id FROM `ia` where city='Kanawha' && SIC_code='7011'DB:business_master_new
loadtime:0.75444507598877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellerton' limit 1
loadtime:0.75456190109253 / seconds
Query Executed:select id FROM `ia` where city='Kellerton' && SIC_code='7011'DB:business_master_new
loadtime:0.75580096244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelley' limit 1
loadtime:0.75585007667542 / seconds
Query Executed:select id FROM `ia` where city='Kelley' && SIC_code='7011'DB:business_master_new
loadtime:0.75689291954041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellogg' limit 1
loadtime:0.75692987442017 / seconds
Query Executed:select id FROM `ia` where city='Kellogg' && SIC_code='7011'DB:business_master_new
loadtime:0.75841498374939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensett' limit 1
loadtime:0.75854897499084 / seconds
Query Executed:select id FROM `ia` where city='Kensett' && SIC_code='7011'DB:business_master_new
loadtime:0.76009893417358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.76026701927185 / seconds
Query Executed:select id FROM `ia` where city='Kent' && SIC_code='7011'DB:business_master_new
loadtime:0.76091909408569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokuk' limit 1
loadtime:0.76095509529114 / seconds
Query Executed:select id FROM `ia` where city='Keokuk' && SIC_code='7011'DB:business_master_new
loadtime:0.76294589042664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keosauqua' limit 1
loadtime:0.76310896873474 / seconds
Query Executed:select id FROM `ia` where city='Keosauqua' && SIC_code='7011'DB:business_master_new
loadtime:0.76491808891296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keota' limit 1
loadtime:0.76505899429321 / seconds
Query Executed:select id FROM `ia` where city='Keota' && SIC_code='7011'DB:business_master_new
loadtime:0.76621699333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kesley' limit 1
loadtime:0.76632905006409 / seconds
Query Executed:select id FROM `ia` where city='Kesley' && SIC_code='7011'DB:business_master_new
loadtime:0.76725101470947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:0.76738810539246 / seconds
Query Executed:select id FROM `ia` where city='Keswick' && SIC_code='7011'DB:business_master_new
loadtime:0.76865696907043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.76883006095886 / seconds
Query Executed:select id FROM `ia` where city='Keystone' && SIC_code='7011'DB:business_master_new
loadtime:0.77034497261047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killduff' limit 1
loadtime:0.77045607566833 / seconds
Query Executed:select id FROM `ia` where city='Killduff' && SIC_code='7011'DB:business_master_new
loadtime:0.77130198478699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimballton' limit 1
loadtime:0.77143096923828 / seconds
Query Executed:select id FROM `ia` where city='Kimballton' && SIC_code='7011'DB:business_master_new
loadtime:0.77277088165283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:0.77288103103638 / seconds
Query Executed:select id FROM `ia` where city='Kingsley' && SIC_code='7011'DB:business_master_new
loadtime:0.77432298660278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:0.77446007728577 / seconds
Query Executed:select id FROM `ia` where city='Kinross' && SIC_code='7011'DB:business_master_new
loadtime:0.775141954422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkman' limit 1
loadtime:0.77518391609192 / seconds
Query Executed:select id FROM `ia` where city='Kirkman' && SIC_code='7011'DB:business_master_new
loadtime:0.77634501457214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkville' limit 1
loadtime:0.7764790058136 / seconds
Query Executed:select id FROM `ia` where city='Kirkville' && SIC_code='7011'DB:business_master_new
loadtime:0.77705502510071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiron' limit 1
loadtime:0.77722001075745 / seconds
Query Executed:select id FROM `ia` where city='Kiron' && SIC_code='7011'DB:business_master_new
loadtime:0.77870297431946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Klemme' limit 1
loadtime:0.77874302864075 / seconds
Query Executed:select id FROM `ia` where city='Klemme' && SIC_code='7011'DB:business_master_new
loadtime:0.7802369594574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knierim' limit 1
loadtime:0.78037691116333 / seconds
Query Executed:select id FROM `ia` where city='Knierim' && SIC_code='7011'DB:business_master_new
loadtime:0.78089594841003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knoxville' limit 1
loadtime:0.78099799156189 / seconds
Query Executed:select id FROM `ia` where city='Knoxville' && SIC_code='7011'DB:business_master_new
loadtime:0.78239607810974 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Motte' limit 1
loadtime:0.78244590759277 / seconds
Query Executed:select id FROM `ia` where city='La Motte' && SIC_code='7011'DB:business_master_new
loadtime:0.78380703926086 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Porte City' limit 1
loadtime:0.78394198417664 / seconds
Query Executed:select id FROM `ia` where city='La Porte City' && SIC_code='7011'DB:business_master_new
loadtime:0.78563594818115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacona' limit 1
loadtime:0.78575706481934 / seconds
Query Executed:select id FROM `ia` where city='Lacona' && SIC_code='7011'DB:business_master_new
loadtime:0.78723692893982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladora' limit 1
loadtime:0.78737497329712 / seconds
Query Executed:select id FROM `ia` where city='Ladora' && SIC_code='7011'DB:business_master_new
loadtime:0.78842306137085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.78856301307678 / seconds
Query Executed:select id FROM `ia` where city='Lake City' && SIC_code='7011'DB:business_master_new
loadtime:0.79016208648682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:0.79030299186707 / seconds
Query Executed:select id FROM `ia` where city='Lake Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.79157400131226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Park' limit 1
loadtime:0.79162287712097 / seconds
Query Executed:select id FROM `ia` where city='Lake Park' && SIC_code='7011'DB:business_master_new
loadtime:0.79292893409729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.79298496246338 / seconds
Query Executed:select id FROM `ia` where city='Lake View' && SIC_code='7011'DB:business_master_new
loadtime:0.79472303390503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakota' limit 1
loadtime:0.79478096961975 / seconds
Query Executed:select id FROM `ia` where city='Lakota' && SIC_code='7011'DB:business_master_new
loadtime:0.79625010490417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamoni' limit 1
loadtime:0.79630398750305 / seconds
Query Executed:select id FROM `ia` where city='Lamoni' && SIC_code='7011'DB:business_master_new
loadtime:0.79779696464539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:0.79794597625732 / seconds
Query Executed:select id FROM `ia` where city='Lamont' && SIC_code='7011'DB:business_master_new
loadtime:0.7992570400238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:0.79939699172974 / seconds
Query Executed:select id FROM `ia` where city='Lanesboro' && SIC_code='7011'DB:business_master_new
loadtime:0.8000819683075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langworthy' limit 1
loadtime:0.80016207695007 / seconds
Query Executed:select id FROM `ia` where city='Langworthy' && SIC_code='7011'DB:business_master_new
loadtime:0.80087900161743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:0.80092906951904 / seconds
Query Executed:select id FROM `ia` where city='Lansing' && SIC_code='7011'DB:business_master_new
loadtime:0.80239105224609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larchwood' limit 1
loadtime:0.80255699157715 / seconds
Query Executed:select id FROM `ia` where city='Larchwood' && SIC_code='7011'DB:business_master_new
loadtime:0.80404806137085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larrabee' limit 1
loadtime:0.80421495437622 / seconds
Query Executed:select id FROM `ia` where city='Larrabee' && SIC_code='7011'DB:business_master_new
loadtime:0.80521392822266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latimer' limit 1
loadtime:0.80534887313843 / seconds
Query Executed:select id FROM `ia` where city='Latimer' && SIC_code='7011'DB:business_master_new
loadtime:0.80691409111023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:0.80704092979431 / seconds
Query Executed:select id FROM `ia` where city='Laurel' && SIC_code='7011'DB:business_master_new
loadtime:0.80820608139038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.8083028793335 / seconds
Query Executed:select id FROM `ia` where city='Laurens' && SIC_code='7011'DB:business_master_new
loadtime:0.80980396270752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawler' limit 1
loadtime:0.80993890762329 / seconds
Query Executed:select id FROM `ia` where city='Lawler' && SIC_code='7011'DB:business_master_new
loadtime:0.81122207641602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:0.81127595901489 / seconds
Query Executed:select id FROM `ia` where city='Lawton' && SIC_code='7011'DB:business_master_new
loadtime:0.81276988983154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Claire' limit 1
loadtime:0.81281089782715 / seconds
Query Executed:select id FROM `ia` where city='Le Claire' && SIC_code='7011'DB:business_master_new
loadtime:0.81464004516602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Grand' limit 1
loadtime:0.81469702720642 / seconds
Query Executed:select id FROM `ia` where city='Le Grand' && SIC_code='7011'DB:business_master_new
loadtime:0.81595706939697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Mars' limit 1
loadtime:0.81614708900452 / seconds
Query Executed:select id FROM `ia` where city='Le Mars' && SIC_code='7011'DB:business_master_new
loadtime:0.81829500198364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.81834697723389 / seconds
Query Executed:select id FROM `ia` where city='Ledyard' && SIC_code='7011'DB:business_master_new
loadtime:0.81944298744202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehigh' limit 1
loadtime:0.81957292556763 / seconds
Query Executed:select id FROM `ia` where city='Lehigh' && SIC_code='7011'DB:business_master_new
loadtime:0.82092094421387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leighton' limit 1
loadtime:0.82108592987061 / seconds
Query Executed:select id FROM `ia` where city='Leighton' && SIC_code='7011'DB:business_master_new
loadtime:0.82201600074768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:0.82206702232361 / seconds
Query Executed:select id FROM `ia` where city='Leland' && SIC_code='7011'DB:business_master_new
loadtime:0.8231360912323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:0.82327604293823 / seconds
Query Executed:select id FROM `ia` where city='Lenox' && SIC_code='7011'DB:business_master_new
loadtime:0.82483601570129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:0.82489609718323 / seconds
Query Executed:select id FROM `ia` where city='Leon' && SIC_code='7011'DB:business_master_new
loadtime:0.82635593414307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lester' limit 1
loadtime:0.82650709152222 / seconds
Query Executed:select id FROM `ia` where city='Lester' && SIC_code='7011'DB:business_master_new
loadtime:0.82757091522217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letts' limit 1
loadtime:0.82770895957947 / seconds
Query Executed:select id FROM `ia` where city='Letts' && SIC_code='7011'DB:business_master_new
loadtime:0.82903289794922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:0.8291699886322 / seconds
Query Executed:select id FROM `ia` where city='Lewis' && SIC_code='7011'DB:business_master_new
loadtime:0.83072209358215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Center' limit 1
loadtime:0.83076906204224 / seconds
Query Executed:select id FROM `ia` where city='Liberty Center' && SIC_code='7011'DB:business_master_new
loadtime:0.83155798912048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Libertyville' limit 1
loadtime:0.83166909217834 / seconds
Query Executed:select id FROM `ia` where city='Libertyville' && SIC_code='7011'DB:business_master_new
loadtime:0.83279299736023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lidderdale' limit 1
loadtime:0.83284401893616 / seconds
Query Executed:select id FROM `ia` where city='Lidderdale' && SIC_code='7011'DB:business_master_new
loadtime:0.8336489200592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Springs' limit 1
loadtime:0.83378195762634 / seconds
Query Executed:select id FROM `ia` where city='Lime Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.83517289161682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.83528399467468 / seconds
Query Executed:select id FROM `ia` where city='Lincoln' && SIC_code='7011'DB:business_master_new
loadtime:0.83621692657471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:0.836256980896 / seconds
Query Executed:select id FROM `ia` where city='Linden' && SIC_code='7011'DB:business_master_new
loadtime:0.83705496788025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lineville' limit 1
loadtime:0.83720898628235 / seconds
Query Executed:select id FROM `ia` where city='Lineville' && SIC_code='7011'DB:business_master_new
loadtime:0.83840894699097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linn Grove' limit 1
loadtime:0.83854389190674 / seconds
Query Executed:select id FROM `ia` where city='Linn Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.83993411064148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.84002208709717 / seconds
Query Executed:select id FROM `ia` where city='Lisbon' && SIC_code='7011'DB:business_master_new
loadtime:0.84122395515442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liscomb' limit 1
loadtime:0.84136009216309 / seconds
Query Executed:select id FROM `ia` where city='Liscomb' && SIC_code='7011'DB:business_master_new
loadtime:0.84220290184021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Cedar' limit 1
loadtime:0.84231400489807 / seconds
Query Executed:select id FROM `ia` where city='Little Cedar' && SIC_code='7011'DB:business_master_new
loadtime:0.84333610534668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.84345388412476 / seconds
Query Executed:select id FROM `ia` where city='Little Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.84485507011414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Sioux' limit 1
loadtime:0.84490489959717 / seconds
Query Executed:select id FROM `ia` where city='Little Sioux' && SIC_code='7011'DB:business_master_new
loadtime:0.84571099281311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:0.84575200080872 / seconds
Query Executed:select id FROM `ia` where city='Livermore' && SIC_code='7011'DB:business_master_new
loadtime:0.84736800193787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockridge' limit 1
loadtime:0.84745192527771 / seconds
Query Executed:select id FROM `ia` where city='Lockridge' && SIC_code='7011'DB:business_master_new
loadtime:0.84852004051208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.84864902496338 / seconds
Query Executed:select id FROM `ia` where city='Logan' && SIC_code='7011'DB:business_master_new
loadtime:0.85037302970886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lohrville' limit 1
loadtime:0.850506067276 / seconds
Query Executed:select id FROM `ia` where city='Lohrville' && SIC_code='7011'DB:business_master_new
loadtime:0.85186004638672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:0.85201191902161 / seconds
Query Executed:select id FROM `ia` where city='Lone Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.85335803031921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:0.85348892211914 / seconds
Query Executed:select id FROM `ia` where city='Lone Tree' && SIC_code='7011'DB:business_master_new
loadtime:0.85508394241333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Grove' limit 1
loadtime:0.85513496398926 / seconds
Query Executed:select id FROM `ia` where city='Long Grove' && SIC_code='7011'DB:business_master_new
loadtime:0.85690093040466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorimor' limit 1
loadtime:0.85694789886475 / seconds
Query Executed:select id FROM `ia` where city='Lorimor' && SIC_code='7011'DB:business_master_new
loadtime:0.85822701454163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Nation' limit 1
loadtime:0.85838103294373 / seconds
Query Executed:select id FROM `ia` where city='Lost Nation' && SIC_code='7011'DB:business_master_new
loadtime:0.8598039150238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovilia' limit 1
loadtime:0.85991501808167 / seconds
Query Executed:select id FROM `ia` where city='Lovilia' && SIC_code='7011'DB:business_master_new
loadtime:0.86104798316956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:0.86122107505798 / seconds
Query Executed:select id FROM `ia` where city='Low Moor' && SIC_code='7011'DB:business_master_new
loadtime:0.86240792274475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowden' limit 1
loadtime:0.8625168800354 / seconds
Query Executed:select id FROM `ia` where city='Lowden' && SIC_code='7011'DB:business_master_new
loadtime:0.86392092704773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lu Verne' limit 1
loadtime:0.864089012146 / seconds
Query Executed:select id FROM `ia` where city='Lu Verne' && SIC_code='7011'DB:business_master_new
loadtime:0.86547088623047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luana' limit 1
loadtime:0.86558890342712 / seconds
Query Executed:select id FROM `ia` where city='Luana' && SIC_code='7011'DB:business_master_new
loadtime:0.8670380115509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucas' limit 1
loadtime:0.86721992492676 / seconds
Query Executed:select id FROM `ia` where city='Lucas' && SIC_code='7011'DB:business_master_new
loadtime:0.86860108375549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:0.8687961101532 / seconds
Query Executed:select id FROM `ia` where city='Luther' && SIC_code='7011'DB:business_master_new
loadtime:0.86979794502258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:0.86993193626404 / seconds
Query Executed:select id FROM `ia` where city='Luxemburg' && SIC_code='7011'DB:business_master_new
loadtime:0.87064409255981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:0.87077307701111 / seconds
Query Executed:select id FROM `ia` where city='Luzerne' && SIC_code='7011'DB:business_master_new
loadtime:0.87189388275146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnville' limit 1
loadtime:0.87197995185852 / seconds
Query Executed:select id FROM `ia` where city='Lynnville' && SIC_code='7011'DB:business_master_new
loadtime:0.87344789505005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lytton' limit 1
loadtime:0.87357902526855 / seconds
Query Executed:select id FROM `ia` where city='Lytton' && SIC_code='7011'DB:business_master_new
loadtime:0.87507891654968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macedonia' limit 1
loadtime:0.87526202201843 / seconds
Query Executed:select id FROM `ia` where city='Macedonia' && SIC_code='7011'DB:business_master_new
loadtime:0.87622690200806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macksburg' limit 1
loadtime:0.87636089324951 / seconds
Query Executed:select id FROM `ia` where city='Macksburg' && SIC_code='7011'DB:business_master_new
loadtime:0.87767910957336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madrid' limit 1
loadtime:0.87777209281921 / seconds
Query Executed:select id FROM `ia` where city='Madrid' && SIC_code='7011'DB:business_master_new
loadtime:0.87931108474731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:0.87945199012756 / seconds
Query Executed:select id FROM `ia` where city='Magnolia' && SIC_code='7011'DB:business_master_new
loadtime:0.88017106056213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malcom' limit 1
loadtime:0.88028693199158 / seconds
Query Executed:select id FROM `ia` where city='Malcom' && SIC_code='7011'DB:business_master_new
loadtime:0.88185596466064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mallard' limit 1
loadtime:0.88195705413818 / seconds
Query Executed:select id FROM `ia` where city='Mallard' && SIC_code='7011'DB:business_master_new
loadtime:0.88343095779419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maloy' limit 1
loadtime:0.88347291946411 / seconds
Query Executed:select id FROM `ia` where city='Maloy' && SIC_code='7011'DB:business_master_new
loadtime:0.88404607772827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malvern' limit 1
loadtime:0.88421702384949 / seconds
Query Executed:select id FROM `ia` where city='Malvern' && SIC_code='7011'DB:business_master_new
loadtime:0.88523387908936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.88528609275818 / seconds
Query Executed:select id FROM `ia` where city='Manchester' && SIC_code='7011'DB:business_master_new
loadtime:0.88722610473633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manilla' limit 1
loadtime:0.88728189468384 / seconds
Query Executed:select id FROM `ia` where city='Manilla' && SIC_code='7011'DB:business_master_new
loadtime:0.88904309272766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manly' limit 1
loadtime:0.88909292221069 / seconds
Query Executed:select id FROM `ia` where city='Manly' && SIC_code='7011'DB:business_master_new
loadtime:0.89054489135742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.89067387580872 / seconds
Query Executed:select id FROM `ia` where city='Manning' && SIC_code='7011'DB:business_master_new
loadtime:0.89173293113708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:0.89179706573486 / seconds
Query Executed:select id FROM `ia` where city='Manson' && SIC_code='7011'DB:business_master_new
loadtime:0.89293503761292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.89298701286316 / seconds
Query Executed:select id FROM `ia` where city='Mapleton' && SIC_code='7011'DB:business_master_new
loadtime:0.8949339389801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maquoketa' limit 1
loadtime:0.89506697654724 / seconds
Query Executed:select id FROM `ia` where city='Maquoketa' && SIC_code='7011'DB:business_master_new
loadtime:0.8970799446106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:0.89728188514709 / seconds
Query Executed:select id FROM `ia` where city='Marathon' && SIC_code='7011'DB:business_master_new
loadtime:0.89888310432434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Rock' limit 1
loadtime:0.89901399612427 / seconds
Query Executed:select id FROM `ia` where city='Marble Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.90068197250366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcus' limit 1
loadtime:0.90079593658447 / seconds
Query Executed:select id FROM `ia` where city='Marcus' && SIC_code='7011'DB:business_master_new
loadtime:0.90226101875305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:0.90232300758362 / seconds
Query Executed:select id FROM `ia` where city='Marengo' && SIC_code='7011'DB:business_master_new
loadtime:0.90443396568298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.90458488464355 / seconds
Query Executed:select id FROM `ia` where city='Marion' && SIC_code='7011'DB:business_master_new
loadtime:0.90724492073059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:0.90740489959717 / seconds
Query Executed:select id FROM `ia` where city='Marne' && SIC_code='7011'DB:business_master_new
loadtime:0.9088020324707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:0.90885090827942 / seconds
Query Executed:select id FROM `ia` where city='Marquette' && SIC_code='7011'DB:business_master_new
loadtime:0.9100170135498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshalltown' limit 1
loadtime:0.91017389297485 / seconds
Query Executed:select id FROM `ia` where city='Marshalltown' && SIC_code='7011'DB:business_master_new
loadtime:0.9128749370575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martelle' limit 1
loadtime:0.91294002532959 / seconds
Query Executed:select id FROM `ia` where city='Martelle' && SIC_code='7011'DB:business_master_new
loadtime:0.91435289382935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martensdale' limit 1
loadtime:0.91447591781616 / seconds
Query Executed:select id FROM `ia` where city='Martensdale' && SIC_code='7011'DB:business_master_new
loadtime:0.91568088531494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsburg' limit 1
loadtime:0.91581702232361 / seconds
Query Executed:select id FROM `ia` where city='Martinsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.91678190231323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason City' limit 1
loadtime:0.9169180393219 / seconds
Query Executed:select id FROM `ia` where city='Mason City' && SIC_code='7011'DB:business_master_new
loadtime:0.92044305801392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:0.92058706283569 / seconds
Query Executed:select id FROM `ia` where city='Masonville' && SIC_code='7011'DB:business_master_new
loadtime:0.92222094535828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massena' limit 1
loadtime:0.92236995697021 / seconds
Query Executed:select id FROM `ia` where city='Massena' && SIC_code='7011'DB:business_master_new
loadtime:0.92417097091675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matlock' limit 1
loadtime:0.92433094978333 / seconds
Query Executed:select id FROM `ia` where city='Matlock' && SIC_code='7011'DB:business_master_new
loadtime:0.92541790008545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurice' limit 1
loadtime:0.92555904388428 / seconds
Query Executed:select id FROM `ia` where city='Maurice' && SIC_code='7011'DB:business_master_new
loadtime:0.92741394042969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.92755508422852 / seconds
Query Executed:select id FROM `ia` where city='Maxwell' && SIC_code='7011'DB:business_master_new
loadtime:0.9294159412384 / seconds
Query loaded from cache:select * from geodata_geocity where city='May City' limit 1
loadtime:0.92952609062195 / seconds
Query Executed:select id FROM `ia` where city='May City' && SIC_code='7011'DB:business_master_new
loadtime:0.93027901649475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:0.93041801452637 / seconds
Query Executed:select id FROM `ia` where city='Maynard' && SIC_code='7011'DB:business_master_new
loadtime:0.93205094337463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Callsburg' limit 1
loadtime:0.93222403526306 / seconds
Query Executed:select id FROM `ia` where city='Mc Callsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.93350791931152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Causland' limit 1
loadtime:0.93360590934753 / seconds
Query Executed:select id FROM `ia` where city='Mc Causland' && SIC_code='7011'DB:business_master_new
loadtime:0.93478798866272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clelland' limit 1
loadtime:0.93493103981018 / seconds
Query Executed:select id FROM `ia` where city='Mc Clelland' && SIC_code='7011'DB:business_master_new
loadtime:0.93625402450562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gregor' limit 1
loadtime:0.93638396263123 / seconds
Query Executed:select id FROM `ia` where city='Mc Gregor' && SIC_code='7011'DB:business_master_new
loadtime:0.93848490715027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intire' limit 1
loadtime:0.93862199783325 / seconds
Query Executed:select id FROM `ia` where city='Mc Intire' && SIC_code='7011'DB:business_master_new
loadtime:0.94006896018982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:0.94023990631104 / seconds
Query Executed:select id FROM `ia` where city='Mechanicsville' && SIC_code='7011'DB:business_master_new
loadtime:0.94205904006958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mediapolis' limit 1
loadtime:0.94221687316895 / seconds
Query Executed:select id FROM `ia` where city='Mediapolis' && SIC_code='7011'DB:business_master_new
loadtime:0.94397902488708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melbourne' limit 1
loadtime:0.9441499710083 / seconds
Query Executed:select id FROM `ia` where city='Melbourne' && SIC_code='7011'DB:business_master_new
loadtime:0.9457790851593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melcher' limit 1
loadtime:0.94591307640076 / seconds
Query Executed:select id FROM `ia` where city='Melcher' && SIC_code='7011'DB:business_master_new
loadtime:0.94695401191711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.94709491729736 / seconds
Query Executed:select id FROM `ia` where city='Melrose' && SIC_code='7011'DB:business_master_new
loadtime:0.94833397865295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:0.94845294952393 / seconds
Query Executed:select id FROM `ia` where city='Melvin' && SIC_code='7011'DB:business_master_new
loadtime:0.94995403289795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menlo' limit 1
loadtime:0.95008897781372 / seconds
Query Executed:select id FROM `ia` where city='Menlo' && SIC_code='7011'DB:business_master_new
loadtime:0.9519190788269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.9520149230957 / seconds
Query Executed:select id FROM `ia` where city='Meriden' && SIC_code='7011'DB:business_master_new
loadtime:0.95311093330383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:0.95328807830811 / seconds
Query Executed:select id FROM `ia` where city='Merrill' && SIC_code='7011'DB:business_master_new
loadtime:0.95514392852783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meservey' limit 1
loadtime:0.9552788734436 / seconds
Query Executed:select id FROM `ia` where city='Meservey' && SIC_code='7011'DB:business_master_new
loadtime:0.95661687850952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Amana' limit 1
loadtime:0.95675992965698 / seconds
Query Executed:select id FROM `ia` where city='Middle Amana' && SIC_code='7011'DB:business_master_new
loadtime:0.95817708969116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.95832991600037 / seconds
Query Executed:select id FROM `ia` where city='Middletown' && SIC_code='7011'DB:business_master_new
loadtime:0.95968699455261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miles' limit 1
loadtime:0.95982503890991 / seconds
Query Executed:select id FROM `ia` where city='Miles' && SIC_code='7011'DB:business_master_new
loadtime:0.96140599250793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.96145606040955 / seconds
Query Executed:select id FROM `ia` where city='Milford' && SIC_code='7011'DB:business_master_new
loadtime:0.96344399452209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:0.96359705924988 / seconds
Query Executed:select id FROM `ia` where city='Millersburg' && SIC_code='7011'DB:business_master_new
loadtime:0.96487903594971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millerton' limit 1
loadtime:0.96497488021851 / seconds
Query Executed:select id FROM `ia` where city='Millerton' && SIC_code='7011'DB:business_master_new
loadtime:0.96587896347046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milo' limit 1
loadtime:0.96601605415344 / seconds
Query Executed:select id FROM `ia` where city='Milo' && SIC_code='7011'DB:business_master_new
loadtime:0.96778297424316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.9679229259491 / seconds
Query Executed:select id FROM `ia` where city='Milton' && SIC_code='7011'DB:business_master_new
loadtime:0.96951103210449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minburn' limit 1
loadtime:0.9696090221405 / seconds
Query Executed:select id FROM `ia` where city='Minburn' && SIC_code='7011'DB:business_master_new
loadtime:0.97159194946289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden' limit 1
loadtime:0.97172904014587 / seconds
Query Executed:select id FROM `ia` where city='Minden' && SIC_code='7011'DB:business_master_new
loadtime:0.97343397140503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineola' limit 1
loadtime:0.97353601455688 / seconds
Query Executed:select id FROM `ia` where city='Mineola' && SIC_code='7011'DB:business_master_new
loadtime:0.97440505027771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mingo' limit 1
loadtime:0.974534034729 / seconds
Query Executed:select id FROM `ia` where city='Mingo' && SIC_code='7011'DB:business_master_new
loadtime:0.9761528968811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Missouri Valley' limit 1
loadtime:0.97624206542969 / seconds
Query Executed:select id FROM `ia` where city='Missouri Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.97819304466248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.97831201553345 / seconds
Query Executed:select id FROM `ia` where city='Mitchell' && SIC_code='7011'DB:business_master_new
loadtime:0.97906589508057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchellville' limit 1
loadtime:0.97917890548706 / seconds
Query Executed:select id FROM `ia` where city='Mitchellville' && SIC_code='7011'DB:business_master_new
loadtime:0.98081994056702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modale' limit 1
loadtime:0.98093605041504 / seconds
Query Executed:select id FROM `ia` where city='Modale' && SIC_code='7011'DB:business_master_new
loadtime:0.98215103149414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondamin' limit 1
loadtime:0.9822850227356 / seconds
Query Executed:select id FROM `ia` where city='Mondamin' && SIC_code='7011'DB:business_master_new
loadtime:0.98395109176636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth' limit 1
loadtime:0.98404693603516 / seconds
Query Executed:select id FROM `ia` where city='Monmouth' && SIC_code='7011'DB:business_master_new
loadtime:0.98510694503784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:0.98516488075256 / seconds
Query Executed:select id FROM `ia` where city='Monona' && SIC_code='7011'DB:business_master_new
loadtime:0.98599195480347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.98618602752686 / seconds
Query Executed:select id FROM `ia` where city='Monroe' && SIC_code='7011'DB:business_master_new
loadtime:0.98807191848755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.98823404312134 / seconds
Query Executed:select id FROM `ia` where city='Montezuma' && SIC_code='7011'DB:business_master_new
loadtime:0.9899640083313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.99017906188965 / seconds
Query Executed:select id FROM `ia` where city='Monticello' && SIC_code='7011'DB:business_master_new
loadtime:0.99198389053345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montour' limit 1
loadtime:0.9921760559082 / seconds
Query Executed:select id FROM `ia` where city='Montour' && SIC_code='7011'DB:business_master_new
loadtime:0.99306797981262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.99320507049561 / seconds
Query Executed:select id FROM `ia` where city='Montpelier' && SIC_code='7011'DB:business_master_new
loadtime:0.99395799636841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.99408888816833 / seconds
Query Executed:select id FROM `ia` where city='Montrose' && SIC_code='7011'DB:business_master_new
loadtime:0.99581289291382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:0.99597001075745 / seconds
Query Executed:select id FROM `ia` where city='Moorhead' && SIC_code='7011'DB:business_master_new
loadtime:0.99694991111755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorland' limit 1
loadtime:0.99710702896118 / seconds
Query Executed:select id FROM `ia` where city='Moorland' && SIC_code='7011'DB:business_master_new
loadtime:0.99876594543457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravia' limit 1
loadtime:0.99886393547058 / seconds
Query Executed:select id FROM `ia` where city='Moravia' && SIC_code='7011'DB:business_master_new
loadtime:1.0007860660553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:1.00084400177 / seconds
Query Executed:select id FROM `ia` where city='Morley' && SIC_code='7011'DB:business_master_new
loadtime:1.0016660690308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morning Sun' limit 1
loadtime:1.0018060207367 / seconds
Query Executed:select id FROM `ia` where city='Morning Sun' && SIC_code='7011'DB:business_master_new
loadtime:1.0036211013794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:1.0037150382996 / seconds
Query Executed:select id FROM `ia` where city='Morrison' && SIC_code='7011'DB:business_master_new
loadtime:1.004646062851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:1.0047919750214 / seconds
Query Executed:select id FROM `ia` where city='Moscow' && SIC_code='7011'DB:business_master_new
loadtime:1.0054938793182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moulton' limit 1
loadtime:1.0055348873138 / seconds
Query Executed:select id FROM `ia` where city='Moulton' && SIC_code='7011'DB:business_master_new
loadtime:1.0068109035492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Auburn' limit 1
loadtime:1.0069079399109 / seconds
Query Executed:select id FROM `ia` where city='Mount Auburn' && SIC_code='7011'DB:business_master_new
loadtime:1.0081510543823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ayr' limit 1
loadtime:1.0082919597626 / seconds
Query Executed:select id FROM `ia` where city='Mount Ayr' && SIC_code='7011'DB:business_master_new
loadtime:1.0100450515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:1.0102410316467 / seconds
Query Executed:select id FROM `ia` where city='Mount Pleasant' && SIC_code='7011'DB:business_master_new
loadtime:1.0128259658813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:1.0128829479218 / seconds
Query Executed:select id FROM `ia` where city='Mount Sterling' && SIC_code='7011'DB:business_master_new
loadtime:1.0137040615082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Union' limit 1
loadtime:1.0137920379639 / seconds
Query Executed:select id FROM `ia` where city='Mount Union' && SIC_code='7011'DB:business_master_new
loadtime:1.0151679515839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:1.0152640342712 / seconds
Query Executed:select id FROM `ia` where city='Mount Vernon' && SIC_code='7011'DB:business_master_new
loadtime:1.0170419216156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moville' limit 1
loadtime:1.0172040462494 / seconds
Query Executed:select id FROM `ia` where city='Moville' && SIC_code='7011'DB:business_master_new
loadtime:1.0190029144287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Auburn' limit 1
loadtime:1.0191700458527 / seconds
Query Executed:select id FROM `ia` where city='Mt Auburn' && SIC_code='7011'DB:business_master_new
loadtime:1.0199620723724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ayr' limit 1
loadtime:1.0200901031494 / seconds
Query Executed:select id FROM `ia` where city='Mt Ayr' && SIC_code='7011'DB:business_master_new
loadtime:1.0208649635315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:1.0209128856659 / seconds
Query Executed:select id FROM `ia` where city='Mt Pleasant' && SIC_code='7011'DB:business_master_new
loadtime:1.0220639705658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:1.0222449302673 / seconds
Query Executed:select id FROM `ia` where city='Mt Sterling' && SIC_code='7011'DB:business_master_new
loadtime:1.0230910778046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Union' limit 1
loadtime:1.0232479572296 / seconds
Query Executed:select id FROM `ia` where city='Mt Union' && SIC_code='7011'DB:business_master_new
loadtime:1.02414894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:1.0242779254913 / seconds
Query Executed:select id FROM `ia` where city='Mt Vernon' && SIC_code='7011'DB:business_master_new
loadtime:1.024955034256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:1.0250549316406 / seconds
Query Executed:select id FROM `ia` where city='Murray' && SIC_code='7011'DB:business_master_new
loadtime:1.0268058776855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscatine' limit 1
loadtime:1.0268778800964 / seconds
Query Executed:select id FROM `ia` where city='Muscatine' && SIC_code='7011'DB:business_master_new
loadtime:1.0292789936066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:1.0294499397278 / seconds
Query Executed:select id FROM `ia` where city='Mystic' && SIC_code='7011'DB:business_master_new
loadtime:1.030965089798 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Buena Vista' limit 1
loadtime:1.0311050415039 / seconds
Query Executed:select id FROM `ia` where city='N Buena Vista' && SIC_code='7011'DB:business_master_new
loadtime:1.0319800376892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:1.0320909023285 / seconds
Query Executed:select id FROM `ia` where city='Nashua' && SIC_code='7011'DB:business_master_new
loadtime:1.0338039398193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemaha' limit 1
loadtime:1.0339028835297 / seconds
Query Executed:select id FROM `ia` where city='Nemaha' && SIC_code='7011'DB:business_master_new
loadtime:1.0348260402679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:1.0349540710449 / seconds
Query Executed:select id FROM `ia` where city='Neola' && SIC_code='7011'DB:business_master_new
loadtime:1.0365109443665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nevada' limit 1
loadtime:1.0366449356079 / seconds
Query Executed:select id FROM `ia` where city='Nevada' && SIC_code='7011'DB:business_master_new
loadtime:1.0380508899689 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albin' limit 1
loadtime:1.0381970405579 / seconds
Query Executed:select id FROM `ia` where city='New Albin' && SIC_code='7011'DB:business_master_new
loadtime:1.0401439666748 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:1.0402839183807 / seconds
Query Executed:select id FROM `ia` where city='New Hampton' && SIC_code='7011'DB:business_master_new
loadtime:1.0422101020813 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:1.0423491001129 / seconds
Query Executed:select id FROM `ia` where city='New Hartford' && SIC_code='7011'DB:business_master_new
loadtime:1.0442008972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Liberty' limit 1
loadtime:1.0443379878998 / seconds
Query Executed:select id FROM `ia` where city='New Liberty' && SIC_code='7011'DB:business_master_new
loadtime:1.0454790592194 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.0456080436707 / seconds
Query Executed:select id FROM `ia` where city='New London' && SIC_code='7011'DB:business_master_new
loadtime:1.0475869178772 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:1.047749042511 / seconds
Query Executed:select id FROM `ia` where city='New Market' && SIC_code='7011'DB:business_master_new
loadtime:1.04927110672 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:1.0494101047516 / seconds
Query Executed:select id FROM `ia` where city='New Providence' && SIC_code='7011'DB:business_master_new
loadtime:1.0509879589081 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Sharon' limit 1
loadtime:1.0510849952698 / seconds
Query Executed:select id FROM `ia` where city='New Sharon' && SIC_code='7011'DB:business_master_new
loadtime:1.0530269145966 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vienna' limit 1
loadtime:1.0531868934631 / seconds
Query Executed:select id FROM `ia` where city='New Vienna' && SIC_code='7011'DB:business_master_new
loadtime:1.0548310279846 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Virginia' limit 1
loadtime:1.0549640655518 / seconds
Query Executed:select id FROM `ia` where city='New Virginia' && SIC_code='7011'DB:business_master_new
loadtime:1.0567939281464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:1.0569059848785 / seconds
Query Executed:select id FROM `ia` where city='Newell' && SIC_code='7011'DB:business_master_new
loadtime:1.0588080883026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhall' limit 1
loadtime:1.0589420795441 / seconds
Query Executed:select id FROM `ia` where city='Newhall' && SIC_code='7011'DB:business_master_new
loadtime:1.0607709884644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.0609040260315 / seconds
Query Executed:select id FROM `ia` where city='Newton' && SIC_code='7011'DB:business_master_new
loadtime:1.0638289451599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:1.0639939308167 / seconds
Query Executed:select id FROM `ia` where city='Nichols' && SIC_code='7011'DB:business_master_new
loadtime:1.0655450820923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nodaway' limit 1
loadtime:1.0656430721283 / seconds
Query Executed:select id FROM `ia` where city='Nodaway' && SIC_code='7011'DB:business_master_new
loadtime:1.0670220851898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora Springs' limit 1
loadtime:1.0671889781952 / seconds
Query Executed:select id FROM `ia` where city='Nora Springs' && SIC_code='7011'DB:business_master_new
loadtime:1.069207906723 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Buena Vista' limit 1
loadtime:1.0693290233612 / seconds
Query Executed:select id FROM `ia` where city='North Buena Vista' && SIC_code='7011'DB:business_master_new
loadtime:1.0702729225159 / seconds
Query loaded from cache:select * from geodata_geocity where city='North English' limit 1
loadtime:1.0704159736633 / seconds
Query Executed:select id FROM `ia` where city='North English' && SIC_code='7011'DB:business_master_new
loadtime:1.0723550319672 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Liberty' limit 1
loadtime:1.0724840164185 / seconds
Query Executed:select id FROM `ia` where city='North Liberty' && SIC_code='7011'DB:business_master_new
loadtime:1.0745298862457 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Washington' limit 1
loadtime:1.0746839046478 / seconds
Query Executed:select id FROM `ia` where city='North Washington' && SIC_code='7011'DB:business_master_new
loadtime:1.0755729675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northboro' limit 1
loadtime:1.0756840705872 / seconds
Query Executed:select id FROM `ia` where city='Northboro' && SIC_code='7011'DB:business_master_new
loadtime:1.0768439769745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:1.0769710540771 / seconds
Query Executed:select id FROM `ia` where city='Northwood' && SIC_code='7011'DB:business_master_new
loadtime:1.0790350437164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:1.0792179107666 / seconds
Query Executed:select id FROM `ia` where city='Norwalk' && SIC_code='7011'DB:business_master_new
loadtime:1.0813128948212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:1.081465959549 / seconds
Query Executed:select id FROM `ia` where city='Norway' && SIC_code='7011'DB:business_master_new
loadtime:1.0833630561829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Numa' limit 1
loadtime:1.0835061073303 / seconds
Query Executed:select id FROM `ia` where city='Numa' && SIC_code='7011'DB:business_master_new
loadtime:1.0844180583954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:1.0845079421997 / seconds
Query Executed:select id FROM `ia` where city='Oakdale' && SIC_code='7011'DB:business_master_new
loadtime:1.0853610038757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:1.0854909420013 / seconds
Query Executed:select id FROM `ia` where city='Oakland' && SIC_code='7011'DB:business_master_new
loadtime:1.0874190330505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:1.0875859260559 / seconds
Query Executed:select id FROM `ia` where city='Oakville' && SIC_code='7011'DB:business_master_new
loadtime:1.0891020298004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocheyedan' limit 1
loadtime:1.089231967926 / seconds
Query Executed:select id FROM `ia` where city='Ocheyedan' && SIC_code='7011'DB:business_master_new
loadtime:1.0908620357513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odebolt' limit 1
loadtime:1.0910000801086 / seconds
Query Executed:select id FROM `ia` where city='Odebolt' && SIC_code='7011'DB:business_master_new
loadtime:1.0919070243835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelwein' limit 1
loadtime:1.091943025589 / seconds
Query Executed:select id FROM `ia` where city='Oelwein' && SIC_code='7011'DB:business_master_new
loadtime:1.0927600860596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:1.0928170681 / seconds
Query Executed:select id FROM `ia` where city='Ogden' && SIC_code='7011'DB:business_master_new
loadtime:1.093535900116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okoboji' limit 1
loadtime:1.0935940742493 / seconds
Query Executed:select id FROM `ia` where city='Okoboji' && SIC_code='7011'DB:business_master_new
loadtime:1.094279050827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olds' limit 1
loadtime:1.094330072403 / seconds
Query Executed:select id FROM `ia` where city='Olds' && SIC_code='7011'DB:business_master_new
loadtime:1.0947329998016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:1.0947830677032 / seconds
Query Executed:select id FROM `ia` where city='Olin' && SIC_code='7011'DB:business_master_new
loadtime:1.0954508781433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ollie' limit 1
loadtime:1.0955009460449 / seconds
Query Executed:select id FROM `ia` where city='Ollie' && SIC_code='7011'DB:business_master_new
loadtime:1.0960431098938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onawa' limit 1
loadtime:1.0960791110992 / seconds
Query Executed:select id FROM `ia` where city='Onawa' && SIC_code='7011'DB:business_master_new
loadtime:1.0968270301819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onslow' limit 1
loadtime:1.0968880653381 / seconds
Query Executed:select id FROM `ia` where city='Onslow' && SIC_code='7011'DB:business_master_new
loadtime:1.0974740982056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oran' limit 1
loadtime:1.097510099411 / seconds
Query Executed:select id FROM `ia` where city='Oran' && SIC_code='7011'DB:business_master_new
loadtime:1.0978679656982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange City' limit 1
loadtime:1.0979170799255 / seconds
Query Executed:select id FROM `ia` where city='Orange City' && SIC_code='7011'DB:business_master_new
loadtime:1.0987129211426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:1.0987479686737 / seconds
Query Executed:select id FROM `ia` where city='Orchard' && SIC_code='7011'DB:business_master_new
loadtime:1.0991449356079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:1.0991840362549 / seconds
Query Executed:select id FROM `ia` where city='Orient' && SIC_code='7011'DB:business_master_new
loadtime:1.0998439788818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage' limit 1
loadtime:1.0999009609222 / seconds
Query Executed:select id FROM `ia` where city='Osage' && SIC_code='7011'DB:business_master_new
loadtime:1.1007199287415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:1.1007878780365 / seconds
Query Executed:select id FROM `ia` where city='Osceola' && SIC_code='7011'DB:business_master_new
loadtime:1.1016530990601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oskaloosa' limit 1
loadtime:1.1017150878906 / seconds
Query Executed:select id FROM `ia` where city='Oskaloosa' && SIC_code='7011'DB:business_master_new
loadtime:1.1027119159698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossian' limit 1
loadtime:1.1027729511261 / seconds
Query Executed:select id FROM `ia` where city='Ossian' && SIC_code='7011'DB:business_master_new
loadtime:1.1034469604492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otho' limit 1
loadtime:1.1034970283508 / seconds
Query Executed:select id FROM `ia` where city='Otho' && SIC_code='7011'DB:business_master_new
loadtime:1.1040060520172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otley' limit 1
loadtime:1.1040470600128 / seconds
Query Executed:select id FROM `ia` where city='Otley' && SIC_code='7011'DB:business_master_new
loadtime:1.1045949459076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oto' limit 1
loadtime:1.1046550273895 / seconds
Query Executed:select id FROM `ia` where city='Oto' && SIC_code='7011'DB:business_master_new
loadtime:1.1050999164581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottosen' limit 1
loadtime:1.1051518917084 / seconds
Query Executed:select id FROM `ia` where city='Ottosen' && SIC_code='7011'DB:business_master_new
loadtime:1.1055800914764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottumwa' limit 1
loadtime:1.1056160926819 / seconds
Query Executed:select id FROM `ia` where city='Ottumwa' && SIC_code='7011'DB:business_master_new
loadtime:1.1067469120026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.1068110466003 / seconds
Query Executed:select id FROM `ia` where city='Oxford' && SIC_code='7011'DB:business_master_new
loadtime:1.1074740886688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford Junction' limit 1
loadtime:1.1075251102448 / seconds
Query Executed:select id FROM `ia` where city='Oxford Junction' && SIC_code='7011'DB:business_master_new
loadtime:1.1081409454346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyens' limit 1
loadtime:1.1081819534302 / seconds
Query Executed:select id FROM `ia` where city='Oyens' && SIC_code='7011'DB:business_master_new
loadtime:1.1085300445557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific Junction' limit 1
loadtime:1.1085798740387 / seconds
Query Executed:select id FROM `ia` where city='Pacific Junction' && SIC_code='7011'DB:business_master_new
loadtime:1.1091740131378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwood' limit 1
loadtime:1.1092159748077 / seconds
Query Executed:select id FROM `ia` where city='Packwood' && SIC_code='7011'DB:business_master_new
loadtime:1.1097409725189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.1097769737244 / seconds
Query Executed:select id FROM `ia` where city='Palmer' && SIC_code='7011'DB:business_master_new
loadtime:1.110426902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:1.1104760169983 / seconds
Query Executed:select id FROM `ia` where city='Palo' && SIC_code='7011'DB:business_master_new
loadtime:1.1111369132996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panama' limit 1
loadtime:1.1111869812012 / seconds
Query Executed:select id FROM `ia` where city='Panama' && SIC_code='7011'DB:business_master_new
loadtime:1.1117639541626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panora' limit 1
loadtime:1.1118059158325 / seconds
Query Executed:select id FROM `ia` where city='Panora' && SIC_code='7011'DB:business_master_new
loadtime:1.1125299930573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkersburg' limit 1
loadtime:1.112587928772 / seconds
Query Executed:select id FROM `ia` where city='Parkersburg' && SIC_code='7011'DB:business_master_new
loadtime:1.1132600307465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parnell' limit 1
loadtime:1.1133050918579 / seconds
Query Executed:select id FROM `ia` where city='Parnell' && SIC_code='7011'DB:business_master_new
loadtime:1.1138401031494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paton' limit 1
loadtime:1.1138858795166 / seconds
Query Executed:select id FROM `ia` where city='Paton' && SIC_code='7011'DB:business_master_new
loadtime:1.1145310401917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:1.114578962326 / seconds
Query Executed:select id FROM `ia` where city='Patterson' && SIC_code='7011'DB:business_master_new
loadtime:1.1148750782013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paullina' limit 1
loadtime:1.1149079799652 / seconds
Query Executed:select id FROM `ia` where city='Paullina' && SIC_code='7011'DB:business_master_new
loadtime:1.1155850887299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pella' limit 1
loadtime:1.1156330108643 / seconds
Query Executed:select id FROM `ia` where city='Pella' && SIC_code='7011'DB:business_master_new
loadtime:1.1165471076965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peosta' limit 1
loadtime:1.1165878772736 / seconds
Query Executed:select id FROM `ia` where city='Peosta' && SIC_code='7011'DB:business_master_new
loadtime:1.1172749996185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Percival' limit 1
loadtime:1.1173219680786 / seconds
Query Executed:select id FROM `ia` where city='Percival' && SIC_code='7011'DB:business_master_new
loadtime:1.1178290843964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:1.1178820133209 / seconds
Query Executed:select id FROM `ia` where city='Perry' && SIC_code='7011'DB:business_master_new
loadtime:1.1186950206757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Persia' limit 1
loadtime:1.1187460422516 / seconds
Query Executed:select id FROM `ia` where city='Persia' && SIC_code='7011'DB:business_master_new
loadtime:1.1192400455475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:1.1192829608917 / seconds
Query Executed:select id FROM `ia` where city='Peru' && SIC_code='7011'DB:business_master_new
loadtime:1.1197180747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson' limit 1
loadtime:1.1197640895844 / seconds
Query Executed:select id FROM `ia` where city='Peterson' && SIC_code='7011'DB:business_master_new
loadtime:1.1204290390015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:1.1204779148102 / seconds
Query Executed:select id FROM `ia` where city='Pierson' && SIC_code='7011'DB:business_master_new
loadtime:1.1211400032043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Grove' limit 1
loadtime:1.1211769580841 / seconds
Query Executed:select id FROM `ia` where city='Pilot Grove' && SIC_code='7011'DB:business_master_new
loadtime:1.1215169429779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mound' limit 1
loadtime:1.1215670108795 / seconds
Query Executed:select id FROM `ia` where city='Pilot Mound' && SIC_code='7011'DB:business_master_new
loadtime:1.1219699382782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah' limit 1
loadtime:1.122004032135 / seconds
Query Executed:select id FROM `ia` where city='Pisgah' && SIC_code='7011'DB:business_master_new
loadtime:1.1225399971008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.1225910186768 / seconds
Query Executed:select id FROM `ia` where city='Plainfield' && SIC_code='7011'DB:business_master_new
loadtime:1.12322306633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plano' limit 1
loadtime:1.1232619285583 / seconds
Query Executed:select id FROM `ia` where city='Plano' && SIC_code='7011'DB:business_master_new
loadtime:1.1237490177155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:1.1237950325012 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Hill' && SIC_code='7011'DB:business_master_new
loadtime:1.1245510578156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:1.124587059021 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Valley' && SIC_code='7011'DB:business_master_new
loadtime:1.1250219345093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasanton' limit 1
loadtime:1.1250629425049 / seconds
Query Executed:select id FROM `ia` where city='Pleasanton' && SIC_code='7011'DB:business_master_new
loadtime:1.1253380775452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:1.1253740787506 / seconds
Query Executed:select id FROM `ia` where city='Pleasantville' && SIC_code='7011'DB:business_master_new
loadtime:1.1260368824005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:1.1260879039764 / seconds
Query Executed:select id FROM `ia` where city='Plover' && SIC_code='7011'DB:business_master_new
loadtime:1.1264810562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.1265299320221 / seconds
Query Executed:select id FROM `ia` where city='Plymouth' && SIC_code='7011'DB:business_master_new
loadtime:1.1271269321442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:1.1271669864655 / seconds
Query Executed:select id FROM `ia` where city='Pocahontas' && SIC_code='7011'DB:business_master_new
loadtime:1.1278901100159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polk City' limit 1
loadtime:1.1279439926147 / seconds
Query Executed:select id FROM `ia` where city='Polk City' && SIC_code='7011'DB:business_master_new
loadtime:1.1286199092865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomeroy' limit 1
loadtime:1.1286668777466 / seconds
Query Executed:select id FROM `ia` where city='Pomeroy' && SIC_code='7011'DB:business_master_new
loadtime:1.1293308734894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Popejoy' limit 1
loadtime:1.1293590068817 / seconds
Query Executed:select id FROM `ia` where city='Popejoy' && SIC_code='7011'DB:business_master_new
loadtime:1.1296899318695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:1.1297369003296 / seconds
Query Executed:select id FROM `ia` where city='Portsmouth' && SIC_code='7011'DB:business_master_new
loadtime:1.1302359104156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Postville' limit 1
loadtime:1.1302759647369 / seconds
Query Executed:select id FROM `ia` where city='Postville' && SIC_code='7011'DB:business_master_new
loadtime:1.1309928894043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:1.1310489177704 / seconds
Query Executed:select id FROM `ia` where city='Prairie City' && SIC_code='7011'DB:business_master_new
loadtime:1.1317369937897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairieburg' limit 1
loadtime:1.1317811012268 / seconds
Query Executed:select id FROM `ia` where city='Prairieburg' && SIC_code='7011'DB:business_master_new
loadtime:1.1321430206299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:1.1321830749512 / seconds
Query Executed:select id FROM `ia` where city='Prescott' && SIC_code='7011'DB:business_master_new
loadtime:1.1327970027924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:1.1328439712524 / seconds
Query Executed:select id FROM `ia` where city='Preston' && SIC_code='7011'DB:business_master_new
loadtime:1.1335170269012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Primghar' limit 1
loadtime:1.1335670948029 / seconds
Query Executed:select id FROM `ia` where city='Primghar' && SIC_code='7011'DB:business_master_new
loadtime:1.1342480182648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.1342968940735 / seconds
Query Executed:select id FROM `ia` where city='Princeton' && SIC_code='7011'DB:business_master_new
loadtime:1.1351459026337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prole' limit 1
loadtime:1.135195016861 / seconds
Query Executed:select id FROM `ia` where city='Prole' && SIC_code='7011'DB:business_master_new
loadtime:1.1357479095459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Promise City' limit 1
loadtime:1.1357789039612 / seconds
Query Executed:select id FROM `ia` where city='Promise City' && SIC_code='7011'DB:business_master_new
loadtime:1.1361989974976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Protivin' limit 1
loadtime:1.1362419128418 / seconds
Query Executed:select id FROM `ia` where city='Protivin' && SIC_code='7011'DB:business_master_new
loadtime:1.1366989612579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:1.1367609500885 / seconds
Query Executed:select id FROM `ia` where city='Pulaski' && SIC_code='7011'DB:business_master_new
loadtime:1.1372439861298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quasqueton' limit 1
loadtime:1.1372740268707 / seconds
Query Executed:select id FROM `ia` where city='Quasqueton' && SIC_code='7011'DB:business_master_new
loadtime:1.1377060413361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quimby' limit 1
loadtime:1.1377470493317 / seconds
Query Executed:select id FROM `ia` where city='Quimby' && SIC_code='7011'DB:business_master_new
loadtime:1.1382811069489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radcliffe' limit 1
loadtime:1.1383109092712 / seconds
Query Executed:select id FROM `ia` where city='Radcliffe' && SIC_code='7011'DB:business_master_new
loadtime:1.1389389038086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rake' limit 1
loadtime:1.1389739513397 / seconds
Query Executed:select id FROM `ia` where city='Rake' && SIC_code='7011'DB:business_master_new
loadtime:1.1395790576935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralston' limit 1
loadtime:1.1396179199219 / seconds
Query Executed:select id FROM `ia` where city='Ralston' && SIC_code='7011'DB:business_master_new
loadtime:1.1399230957031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randalia' limit 1
loadtime:1.1399478912354 / seconds
Query Executed:select id FROM `ia` where city='Randalia' && SIC_code='7011'DB:business_master_new
loadtime:1.1403450965881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randall' limit 1
loadtime:1.1403849124908 / seconds
Query Executed:select id FROM `ia` where city='Randall' && SIC_code='7011'DB:business_master_new
loadtime:1.1407399177551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.1407721042633 / seconds
Query Executed:select id FROM `ia` where city='Randolph' && SIC_code='7011'DB:business_master_new
loadtime:1.1411890983582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.1412260532379 / seconds
Query Executed:select id FROM `ia` where city='Raymond' && SIC_code='7011'DB:business_master_new
loadtime:1.1416449546814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readlyn' limit 1
loadtime:1.141676902771 / seconds
Query Executed:select id FROM `ia` where city='Readlyn' && SIC_code='7011'DB:business_master_new
loadtime:1.1423060894012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reasnor' limit 1
loadtime:1.142343044281 / seconds
Query Executed:select id FROM `ia` where city='Reasnor' && SIC_code='7011'DB:business_master_new
loadtime:1.1428298950195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:1.142853975296 / seconds
Query Executed:select id FROM `ia` where city='Red Oak' && SIC_code='7011'DB:business_master_new
loadtime:1.1436479091644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:1.1436910629272 / seconds
Query Executed:select id FROM `ia` where city='Redding' && SIC_code='7011'DB:business_master_new
loadtime:1.1440529823303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:1.1440880298615 / seconds
Query Executed:select id FROM `ia` where city='Redfield' && SIC_code='7011'DB:business_master_new
loadtime:1.1446409225464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reinbeck' limit 1
loadtime:1.1446650028229 / seconds
Query Executed:select id FROM `ia` where city='Reinbeck' && SIC_code='7011'DB:business_master_new
loadtime:1.1453409194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembrandt' limit 1
loadtime:1.1453750133514 / seconds
Query Executed:select id FROM `ia` where city='Rembrandt' && SIC_code='7011'DB:business_master_new
loadtime:1.1458690166473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remsen' limit 1
loadtime:1.1458969116211 / seconds
Query Executed:select id FROM `ia` where city='Remsen' && SIC_code='7011'DB:business_master_new
loadtime:1.1465990543365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renwick' limit 1
loadtime:1.1466429233551 / seconds
Query Executed:select id FROM `ia` where city='Renwick' && SIC_code='7011'DB:business_master_new
loadtime:1.1471350193024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:1.1471650600433 / seconds
Query Executed:select id FROM `ia` where city='Rhodes' && SIC_code='7011'DB:business_master_new
loadtime:1.1475620269775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riceville' limit 1
loadtime:1.1475908756256 / seconds
Query Executed:select id FROM `ia` where city='Riceville' && SIC_code='7011'DB:business_master_new
loadtime:1.1482388973236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:1.1482729911804 / seconds
Query Executed:select id FROM `ia` where city='Richland' && SIC_code='7011'DB:business_master_new
loadtime:1.1489059925079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ricketts' limit 1
loadtime:1.1489429473877 / seconds
Query Executed:select id FROM `ia` where city='Ricketts' && SIC_code='7011'DB:business_master_new
loadtime:1.1492838859558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:1.1493279933929 / seconds
Query Executed:select id FROM `ia` where city='Ridgeway' && SIC_code='7011'DB:business_master_new
loadtime:1.1499669551849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringsted' limit 1
loadtime:1.1500010490417 / seconds
Query Executed:select id FROM `ia` where city='Ringsted' && SIC_code='7011'DB:business_master_new
loadtime:1.1506330966949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rippey' limit 1
loadtime:1.1506860256195 / seconds
Query Executed:select id FROM `ia` where city='Rippey' && SIC_code='7011'DB:business_master_new
loadtime:1.151230096817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:1.1512739658356 / seconds
Query Executed:select id FROM `ia` where city='Riverdale' && SIC_code='7011'DB:business_master_new
loadtime:1.1517488956451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:1.1518249511719 / seconds
Query Executed:select id FROM `ia` where city='Riverside' && SIC_code='7011'DB:business_master_new
loadtime:1.1533079147339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:1.1533451080322 / seconds
Query Executed:select id FROM `ia` where city='Riverton' && SIC_code='7011'DB:business_master_new
loadtime:1.1537179946899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robins' limit 1
loadtime:1.1537520885468 / seconds
Query Executed:select id FROM `ia` where city='Robins' && SIC_code='7011'DB:business_master_new
loadtime:1.1543340682983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:1.1543700695038 / seconds
Query Executed:select id FROM `ia` where city='Rock Falls' && SIC_code='7011'DB:business_master_new
loadtime:1.1547200679779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Rapids' limit 1
loadtime:1.1547529697418 / seconds
Query Executed:select id FROM `ia` where city='Rock Rapids' && SIC_code='7011'DB:business_master_new
loadtime:1.1555030345917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Valley' limit 1
loadtime:1.1555469036102 / seconds
Query Executed:select id FROM `ia` where city='Rock Valley' && SIC_code='7011'DB:business_master_new
loadtime:1.1562869548798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:1.1563329696655 / seconds
Query Executed:select id FROM `ia` where city='Rockford' && SIC_code='7011'DB:business_master_new
loadtime:1.1569919586182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:1.1570398807526 / seconds
Query Executed:select id FROM `ia` where city='Rockwell' && SIC_code='7011'DB:business_master_new
loadtime:1.1577250957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell City' limit 1
loadtime:1.1577820777893 / seconds
Query Executed:select id FROM `ia` where city='Rockwell City' && SIC_code='7011'DB:business_master_new
loadtime:1.1585130691528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:1.1585559844971 / seconds
Query Executed:select id FROM `ia` where city='Rodney' && SIC_code='7011'DB:business_master_new
loadtime:1.1588840484619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roland' limit 1
loadtime:1.1589250564575 / seconds
Query Executed:select id FROM `ia` where city='Roland' && SIC_code='7011'DB:business_master_new
loadtime:1.1595840454102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolfe' limit 1
loadtime:1.1596260070801 / seconds
Query Executed:select id FROM `ia` where city='Rolfe' && SIC_code='7011'DB:business_master_new
loadtime:1.1602718830109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:1.1603140830994 / seconds
Query Executed:select id FROM `ia` where city='Rome' && SIC_code='7011'DB:business_master_new
loadtime:1.1605789661407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:1.1606121063232 / seconds
Query Executed:select id FROM `ia` where city='Rose Hill' && SIC_code='7011'DB:business_master_new
loadtime:1.1610538959503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowan' limit 1
loadtime:1.1610929965973 / seconds
Query Executed:select id FROM `ia` where city='Rowan' && SIC_code='7011'DB:business_master_new
loadtime:1.1614820957184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:1.1615190505981 / seconds
Query Executed:select id FROM `ia` where city='Rowley' && SIC_code='7011'DB:business_master_new
loadtime:1.1620600223541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal' limit 1
loadtime:1.1620938777924 / seconds
Query Executed:select id FROM `ia` where city='Royal' && SIC_code='7011'DB:business_master_new
loadtime:1.1627519130707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudd' limit 1
loadtime:1.1627790927887 / seconds
Query Executed:select id FROM `ia` where city='Rudd' && SIC_code='7011'DB:business_master_new
loadtime:1.1638379096985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnells' limit 1
loadtime:1.1639709472656 / seconds
Query Executed:select id FROM `ia` where city='Runnells' && SIC_code='7011'DB:business_master_new
loadtime:1.1651089191437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:1.1651699542999 / seconds
Query Executed:select id FROM `ia` where city='Russell' && SIC_code='7011'DB:business_master_new
loadtime:1.1659650802612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthven' limit 1
loadtime:1.1660459041595 / seconds
Query Executed:select id FROM `ia` where city='Ruthven' && SIC_code='7011'DB:business_master_new
loadtime:1.1672859191895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:1.1673440933228 / seconds
Query Executed:select id FROM `ia` where city='Rutland' && SIC_code='7011'DB:business_master_new
loadtime:1.1682040691376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryan' limit 1
loadtime:1.1682538986206 / seconds
Query Executed:select id FROM `ia` where city='Ryan' && SIC_code='7011'DB:business_master_new
loadtime:1.1691739559174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sabula' limit 1
loadtime:1.1692230701447 / seconds
Query Executed:select id FROM `ia` where city='Sabula' && SIC_code='7011'DB:business_master_new
loadtime:1.1703629493713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sac City' limit 1
loadtime:1.1704440116882 / seconds
Query Executed:select id FROM `ia` where city='Sac City' && SIC_code='7011'DB:business_master_new
loadtime:1.1721770763397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ansgar' limit 1
loadtime:1.1722369194031 / seconds
Query Executed:select id FROM `ia` where city='Saint Ansgar' && SIC_code='7011'DB:business_master_new
loadtime:1.1732180118561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Anthony' limit 1
loadtime:1.1732730865479 / seconds
Query Executed:select id FROM `ia` where city='Saint Anthony' && SIC_code='7011'DB:business_master_new
loadtime:1.17391705513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:1.1740410327911 / seconds
Query Executed:select id FROM `ia` where city='Saint Charles' && SIC_code='7011'DB:business_master_new
loadtime:1.1752760410309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Donatus' limit 1
loadtime:1.1753129959106 / seconds
Query Executed:select id FROM `ia` where city='Saint Donatus' && SIC_code='7011'DB:business_master_new
loadtime:1.1758420467377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Marys' limit 1
loadtime:1.1759970188141 / seconds
Query Executed:select id FROM `ia` where city='Saint Marys' && SIC_code='7011'DB:business_master_new
loadtime:1.1766951084137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Olaf' limit 1
loadtime:1.1768929958344 / seconds
Query Executed:select id FROM `ia` where city='Saint Olaf' && SIC_code='7011'DB:business_master_new
loadtime:1.1777338981628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:1.1778779029846 / seconds
Query Executed:select id FROM `ia` where city='Saint Paul' && SIC_code='7011'DB:business_master_new
loadtime:1.1785740852356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.1786670684814 / seconds
Query Executed:select id FROM `ia` where city='Salem' && SIC_code='7011'DB:business_master_new
loadtime:1.1796278953552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salix' limit 1
loadtime:1.1797380447388 / seconds
Query Executed:select id FROM `ia` where city='Salix' && SIC_code='7011'DB:business_master_new
loadtime:1.1810240745544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanborn' limit 1
loadtime:1.181077003479 / seconds
Query Executed:select id FROM `ia` where city='Sanborn' && SIC_code='7011'DB:business_master_new
loadtime:1.1822950839996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scarville' limit 1
loadtime:1.1823439598083 / seconds
Query Executed:select id FROM `ia` where city='Scarville' && SIC_code='7011'DB:business_master_new
loadtime:1.1830680370331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schaller' limit 1
loadtime:1.1831879615784 / seconds
Query Executed:select id FROM `ia` where city='Schaller' && SIC_code='7011'DB:business_master_new
loadtime:1.1845378875732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schleswig' limit 1
loadtime:1.1845889091492 / seconds
Query Executed:select id FROM `ia` where city='Schleswig' && SIC_code='7011'DB:business_master_new
loadtime:1.1855731010437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Grove' limit 1
loadtime:1.1856250762939 / seconds
Query Executed:select id FROM `ia` where city='Scotch Grove' && SIC_code='7011'DB:business_master_new
loadtime:1.1858880519867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:1.1859240531921 / seconds
Query Executed:select id FROM `ia` where city='Scranton' && SIC_code='7011'DB:business_master_new
loadtime:1.1865530014038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Searsboro' limit 1
loadtime:1.1865830421448 / seconds
Query Executed:select id FROM `ia` where city='Searsboro' && SIC_code='7011'DB:business_master_new
loadtime:1.187038898468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:1.1870889663696 / seconds
Query Executed:select id FROM `ia` where city='Selma' && SIC_code='7011'DB:business_master_new
loadtime:1.1874370574951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeant Bluff' limit 1
loadtime:1.187488079071 / seconds
Query Executed:select id FROM `ia` where city='Sergeant Bluff' && SIC_code='7011'DB:business_master_new
loadtime:1.1884360313416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:1.1885619163513 / seconds
Query Executed:select id FROM `ia` where city='Seymour' && SIC_code='7011'DB:business_master_new
loadtime:1.1900219917297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shambaugh' limit 1
loadtime:1.190052986145 / seconds
Query Executed:select id FROM `ia` where city='Shambaugh' && SIC_code='7011'DB:business_master_new
loadtime:1.1904399394989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon City' limit 1
loadtime:1.1905379295349 / seconds
Query Executed:select id FROM `ia` where city='Shannon City' && SIC_code='7011'DB:business_master_new
loadtime:1.1913259029388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:1.1913731098175 / seconds
Query Executed:select id FROM `ia` where city='Sharpsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.1917479038239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:1.1917939186096 / seconds
Query Executed:select id FROM `ia` where city='Sheffield' && SIC_code='7011'DB:business_master_new
loadtime:1.1929190158844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:1.1929578781128 / seconds
Query Executed:select id FROM `ia` where city='Shelby' && SIC_code='7011'DB:business_master_new
loadtime:1.1941909790039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldahl' limit 1
loadtime:1.194226026535 / seconds
Query Executed:select id FROM `ia` where city='Sheldahl' && SIC_code='7011'DB:business_master_new
loadtime:1.1945359706879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:1.1946408748627 / seconds
Query Executed:select id FROM `ia` where city='Sheldon' && SIC_code='7011'DB:business_master_new
loadtime:1.1961760520935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Rock' limit 1
loadtime:1.1962358951569 / seconds
Query Executed:select id FROM `ia` where city='Shell Rock' && SIC_code='7011'DB:business_master_new
loadtime:1.1972711086273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shellsburg' limit 1
loadtime:1.1973130702972 / seconds
Query Executed:select id FROM `ia` where city='Shellsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.1987550258636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:1.1988019943237 / seconds
Query Executed:select id FROM `ia` where city='Shenandoah' && SIC_code='7011'DB:business_master_new
loadtime:1.2003200054169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrill' limit 1
loadtime:1.2003700733185 / seconds
Query Executed:select id FROM `ia` where city='Sherrill' && SIC_code='7011'DB:business_master_new
loadtime:1.201721906662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:1.2018849849701 / seconds
Query Executed:select id FROM `ia` where city='Sibley' && SIC_code='7011'DB:business_master_new
loadtime:1.2032780647278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:1.2033319473267 / seconds
Query Executed:select id FROM `ia` where city='Sidney' && SIC_code='7011'DB:business_master_new
loadtime:1.2047500610352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigourney' limit 1
loadtime:1.2048089504242 / seconds
Query Executed:select id FROM `ia` where city='Sigourney' && SIC_code='7011'DB:business_master_new
loadtime:1.2057900428772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:1.2058529853821 / seconds
Query Executed:select id FROM `ia` where city='Silver City' && SIC_code='7011'DB:business_master_new
loadtime:1.2068099975586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Center' limit 1
loadtime:1.2069489955902 / seconds
Query Executed:select id FROM `ia` where city='Sioux Center' && SIC_code='7011'DB:business_master_new
loadtime:1.2085061073303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux City' limit 1
loadtime:1.2086420059204 / seconds
Query Executed:select id FROM `ia` where city='Sioux City' && SIC_code='7011'DB:business_master_new
loadtime:1.2122509479523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Rapids' limit 1
loadtime:1.212317943573 / seconds
Query Executed:select id FROM `ia` where city='Sioux Rapids' && SIC_code='7011'DB:business_master_new
loadtime:1.2141370773315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:1.2142019271851 / seconds
Query Executed:select id FROM `ia` where city='Slater' && SIC_code='7011'DB:business_master_new
loadtime:1.215362071991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sloan' limit 1
loadtime:1.2154800891876 / seconds
Query Executed:select id FROM `ia` where city='Sloan' && SIC_code='7011'DB:business_master_new
loadtime:1.2171928882599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithland' limit 1
loadtime:1.2172560691833 / seconds
Query Executed:select id FROM `ia` where city='Smithland' && SIC_code='7011'DB:business_master_new
loadtime:1.2182509899139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldier' limit 1
loadtime:1.2183010578156 / seconds
Query Executed:select id FROM `ia` where city='Soldier' && SIC_code='7011'DB:business_master_new
loadtime:1.2196950912476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon' limit 1
loadtime:1.2197918891907 / seconds
Query Executed:select id FROM `ia` where city='Solon' && SIC_code='7011'DB:business_master_new
loadtime:1.2212700843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:1.2213258743286 / seconds
Query Executed:select id FROM `ia` where city='Somers' && SIC_code='7011'DB:business_master_new
loadtime:1.2225708961487 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amana' limit 1
loadtime:1.222687959671 / seconds
Query Executed:select id FROM `ia` where city='South Amana' && SIC_code='7011'DB:business_master_new
loadtime:1.2236430644989 / seconds
Query loaded from cache:select * from geodata_geocity where city='South English' limit 1
loadtime:1.223799943924 / seconds
Query Executed:select id FROM `ia` where city='South English' && SIC_code='7011'DB:business_master_new
loadtime:1.2251679897308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:1.2253088951111 / seconds
Query Executed:select id FROM `ia` where city='Spencer' && SIC_code='7011'DB:business_master_new
loadtime:1.2273089885712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperry' limit 1
loadtime:1.2273600101471 / seconds
Query Executed:select id FROM `ia` where city='Sperry' && SIC_code='7011'DB:business_master_new
loadtime:1.2289390563965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spillville' limit 1
loadtime:1.2290740013123 / seconds
Query Executed:select id FROM `ia` where city='Spillville' && SIC_code='7011'DB:business_master_new
loadtime:1.2299840450287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spirit Lake' limit 1
loadtime:1.2301681041718 / seconds
Query Executed:select id FROM `ia` where city='Spirit Lake' && SIC_code='7011'DB:business_master_new
loadtime:1.2320630550385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spragueville' limit 1
loadtime:1.2322781085968 / seconds
Query Executed:select id FROM `ia` where city='Spragueville' && SIC_code='7011'DB:business_master_new
loadtime:1.2332921028137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:1.2333409786224 / seconds
Query Executed:select id FROM `ia` where city='Springbrook' && SIC_code='7011'DB:business_master_new
loadtime:1.2342209815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:1.2342760562897 / seconds
Query Executed:select id FROM `ia` where city='Springville' && SIC_code='7011'DB:business_master_new
loadtime:1.2359590530396 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ansgar' limit 1
loadtime:1.2360329627991 / seconds
Query Executed:select id FROM `ia` where city='St Ansgar' && SIC_code='7011'DB:business_master_new
loadtime:1.2364730834961 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Anthony' limit 1
loadtime:1.2366008758545 / seconds
Query Executed:select id FROM `ia` where city='St Anthony' && SIC_code='7011'DB:business_master_new
loadtime:1.2372360229492 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:1.2372748851776 / seconds
Query Executed:select id FROM `ia` where city='St Charles' && SIC_code='7011'DB:business_master_new
loadtime:1.2378580570221 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Donatus' limit 1
loadtime:1.2379820346832 / seconds
Query Executed:select id FROM `ia` where city='St Donatus' && SIC_code='7011'DB:business_master_new
loadtime:1.2387669086456 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lucas' limit 1
loadtime:1.2389070987701 / seconds
Query Executed:select id FROM `ia` where city='St Lucas' && SIC_code='7011'DB:business_master_new
loadtime:1.2393269538879 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Marys' limit 1
loadtime:1.2393670082092 / seconds
Query Executed:select id FROM `ia` where city='St Marys' && SIC_code='7011'DB:business_master_new
loadtime:1.2400209903717 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Olaf' limit 1
loadtime:1.2401599884033 / seconds
Query Executed:select id FROM `ia` where city='St Olaf' && SIC_code='7011'DB:business_master_new
loadtime:1.2404561042786 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:1.2405660152435 / seconds
Query Executed:select id FROM `ia` where city='St Paul' && SIC_code='7011'DB:business_master_new
loadtime:1.2409598827362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacyville' limit 1
loadtime:1.2409930229187 / seconds
Query Executed:select id FROM `ia` where city='Stacyville' && SIC_code='7011'DB:business_master_new
loadtime:1.2423470020294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:1.2423830032349 / seconds
Query Executed:select id FROM `ia` where city='Stanhope' && SIC_code='7011'DB:business_master_new
loadtime:1.2437560558319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.2438929080963 / seconds
Query Executed:select id FROM `ia` where city='Stanley' && SIC_code='7011'DB:business_master_new
loadtime:1.2450869083405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:1.2451980113983 / seconds
Query Executed:select id FROM `ia` where city='Stanton' && SIC_code='7011'DB:business_master_new
loadtime:1.2463300228119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:1.2464129924774 / seconds
Query Executed:select id FROM `ia` where city='Stanwood' && SIC_code='7011'DB:business_master_new
loadtime:1.2480249404907 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Center' limit 1
loadtime:1.2481770515442 / seconds
Query Executed:select id FROM `ia` where city='State Center' && SIC_code='7011'DB:business_master_new
loadtime:1.2493319511414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Rock' limit 1
loadtime:1.2493810653687 / seconds
Query Executed:select id FROM `ia` where city='Steamboat Rock' && SIC_code='7011'DB:business_master_new
loadtime:1.2503869533539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockport' limit 1
loadtime:1.2505269050598 / seconds
Query Executed:select id FROM `ia` where city='Stockport' && SIC_code='7011'DB:business_master_new
loadtime:1.2518489360809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:1.2519819736481 / seconds
Query Executed:select id FROM `ia` where city='Stockton' && SIC_code='7011'DB:business_master_new
loadtime:1.2531609535217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storm Lake' limit 1
loadtime:1.2532711029053 / seconds
Query Executed:select id FROM `ia` where city='Storm Lake' && SIC_code='7011'DB:business_master_new
loadtime:1.2552978992462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Story City' limit 1
loadtime:1.2553570270538 / seconds
Query Executed:select id FROM `ia` where city='Story City' && SIC_code='7011'DB:business_master_new
loadtime:1.2572500705719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stout' limit 1
loadtime:1.2573070526123 / seconds
Query Executed:select id FROM `ia` where city='Stout' && SIC_code='7011'DB:business_master_new
loadtime:1.2580070495605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:1.2581760883331 / seconds
Query Executed:select id FROM `ia` where city='Stratford' && SIC_code='7011'DB:business_master_new
loadtime:1.2596340179443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry Point' limit 1
loadtime:1.2597908973694 / seconds
Query Executed:select id FROM `ia` where city='Strawberry Point' && SIC_code='7011'DB:business_master_new
loadtime:1.2612869739532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:1.2613310813904 / seconds
Query Executed:select id FROM `ia` where city='Stuart' && SIC_code='7011'DB:business_master_new
loadtime:1.2632019519806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sully' limit 1
loadtime:1.2632610797882 / seconds
Query Executed:select id FROM `ia` where city='Sully' && SIC_code='7011'DB:business_master_new
loadtime:1.2643840312958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:1.2645180225372 / seconds
Query Executed:select id FROM `ia` where city='Sumner' && SIC_code='7011'DB:business_master_new
loadtime:1.2663490772247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:1.2664070129395 / seconds
Query Executed:select id FROM `ia` where city='Superior' && SIC_code='7011'DB:business_master_new
loadtime:1.2672739028931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:1.2673170566559 / seconds
Query Executed:select id FROM `ia` where city='Sutherland' && SIC_code='7011'DB:business_master_new
loadtime:1.2681550979614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swaledale' limit 1
loadtime:1.2682058811188 / seconds
Query Executed:select id FROM `ia` where city='Swaledale' && SIC_code='7011'DB:business_master_new
loadtime:1.2692198753357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan' limit 1
loadtime:1.2692558765411 / seconds
Query Executed:select id FROM `ia` where city='Swan' && SIC_code='7011'DB:business_master_new
loadtime:1.2699620723724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swea City' limit 1
loadtime:1.2701010704041 / seconds
Query Executed:select id FROM `ia` where city='Swea City' && SIC_code='7011'DB:business_master_new
loadtime:1.2715718746185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesburg' limit 1
loadtime:1.271684885025 / seconds
Query Executed:select id FROM `ia` where city='Swedesburg' && SIC_code='7011'DB:business_master_new
loadtime:1.2723569869995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swisher' limit 1
loadtime:1.2723989486694 / seconds
Query Executed:select id FROM `ia` where city='Swisher' && SIC_code='7011'DB:business_master_new
loadtime:1.2738509178162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:1.2739799022675 / seconds
Query Executed:select id FROM `ia` where city='Tabor' && SIC_code='7011'DB:business_master_new
loadtime:1.2754189968109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taintor' limit 1
loadtime:1.2755169868469 / seconds
Query Executed:select id FROM `ia` where city='Taintor' && SIC_code='7011'DB:business_master_new
loadtime:1.2762219905853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tama' limit 1
loadtime:1.2762749195099 / seconds
Query Executed:select id FROM `ia` where city='Tama' && SIC_code='7011'DB:business_master_new
loadtime:1.2775709629059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teeds Grove' limit 1
loadtime:1.2776689529419 / seconds
Query Executed:select id FROM `ia` where city='Teeds Grove' && SIC_code='7011'DB:business_master_new
loadtime:1.2783029079437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:1.2783489227295 / seconds
Query Executed:select id FROM `ia` where city='Templeton' && SIC_code='7011'DB:business_master_new
loadtime:1.2797789573669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennant' limit 1
loadtime:1.2799170017242 / seconds
Query Executed:select id FROM `ia` where city='Tennant' && SIC_code='7011'DB:business_master_new
loadtime:1.2807860374451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terril' limit 1
loadtime:1.2808289527893 / seconds
Query Executed:select id FROM `ia` where city='Terril' && SIC_code='7011'DB:business_master_new
loadtime:1.2818648815155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thayer' limit 1
loadtime:1.2819969654083 / seconds
Query Executed:select id FROM `ia` where city='Thayer' && SIC_code='7011'DB:business_master_new
loadtime:1.2827548980713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:1.2828900814056 / seconds
Query Executed:select id FROM `ia` where city='Thompson' && SIC_code='7011'DB:business_master_new
loadtime:1.2843930721283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thor' limit 1
loadtime:1.284548997879 / seconds
Query Executed:select id FROM `ia` where city='Thor' && SIC_code='7011'DB:business_master_new
loadtime:1.285336971283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:1.2853889465332 / seconds
Query Executed:select id FROM `ia` where city='Thornburg' && SIC_code='7011'DB:business_master_new
loadtime:1.2862169742584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:1.28635597229 / seconds
Query Executed:select id FROM `ia` where city='Thornton' && SIC_code='7011'DB:business_master_new
loadtime:1.2877559661865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurman' limit 1
loadtime:1.2878909111023 / seconds
Query Executed:select id FROM `ia` where city='Thurman' && SIC_code='7011'DB:business_master_new
loadtime:1.2887940406799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiffin' limit 1
loadtime:1.2888479232788 / seconds
Query Executed:select id FROM `ia` where city='Tiffin' && SIC_code='7011'DB:business_master_new
loadtime:1.2902228832245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tingley' limit 1
loadtime:1.2902588844299 / seconds
Query Executed:select id FROM `ia` where city='Tingley' && SIC_code='7011'DB:business_master_new
loadtime:1.291100025177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:1.2911920547485 / seconds
Query Executed:select id FROM `ia` where city='Tipton' && SIC_code='7011'DB:business_master_new
loadtime:1.2923541069031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titonka' limit 1
loadtime:1.2925128936768 / seconds
Query Executed:select id FROM `ia` where city='Titonka' && SIC_code='7011'DB:business_master_new
loadtime:1.2936570644379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toddville' limit 1
loadtime:1.2937850952148 / seconds
Query Executed:select id FROM `ia` where city='Toddville' && SIC_code='7011'DB:business_master_new
loadtime:1.2950580120087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toeterville' limit 1
loadtime:1.2951669692993 / seconds
Query Executed:select id FROM `ia` where city='Toeterville' && SIC_code='7011'DB:business_master_new
loadtime:1.2955830097198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toledo' limit 1
loadtime:1.2957139015198 / seconds
Query Executed:select id FROM `ia` where city='Toledo' && SIC_code='7011'DB:business_master_new
loadtime:1.2972619533539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:1.2973198890686 / seconds
Query Executed:select id FROM `ia` where city='Toronto' && SIC_code='7011'DB:business_master_new
loadtime:1.2979609966278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tracy' limit 1
loadtime:1.2980949878693 / seconds
Query Executed:select id FROM `ia` where city='Tracy' && SIC_code='7011'DB:business_master_new
loadtime:1.2988090515137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traer' limit 1
loadtime:1.2989420890808 / seconds
Query Executed:select id FROM `ia` where city='Traer' && SIC_code='7011'DB:business_master_new
loadtime:1.3004550933838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Treynor' limit 1
loadtime:1.3005731105804 / seconds
Query Executed:select id FROM `ia` where city='Treynor' && SIC_code='7011'DB:business_master_new
loadtime:1.3017671108246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:1.301913022995 / seconds
Query Executed:select id FROM `ia` where city='Tripoli' && SIC_code='7011'DB:business_master_new
loadtime:1.3034009933472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy Mills' limit 1
loadtime:1.3035709857941 / seconds
Query Executed:select id FROM `ia` where city='Troy Mills' && SIC_code='7011'DB:business_master_new
loadtime:1.3043539524078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truesdale' limit 1
loadtime:1.3044190406799 / seconds
Query Executed:select id FROM `ia` where city='Truesdale' && SIC_code='7011'DB:business_master_new
loadtime:1.3050010204315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:1.3051800727844 / seconds
Query Executed:select id FROM `ia` where city='Truro' && SIC_code='7011'DB:business_master_new
loadtime:1.3066499233246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turin' limit 1
loadtime:1.3067560195923 / seconds
Query Executed:select id FROM `ia` where city='Turin' && SIC_code='7011'DB:business_master_new
loadtime:1.3072690963745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Udell' limit 1
loadtime:1.3073079586029 / seconds
Query Executed:select id FROM `ia` where city='Udell' && SIC_code='7011'DB:business_master_new
loadtime:1.3082160949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underwood' limit 1
loadtime:1.3083429336548 / seconds
Query Executed:select id FROM `ia` where city='Underwood' && SIC_code='7011'DB:business_master_new
loadtime:1.309534072876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:1.3096890449524 / seconds
Query Executed:select id FROM `ia` where city='Union' && SIC_code='7011'DB:business_master_new
loadtime:1.3110918998718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:1.311224937439 / seconds
Query Executed:select id FROM `ia` where city='Unionville' && SIC_code='7011'DB:business_master_new
loadtime:1.3121929168701 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Park' limit 1
loadtime:1.3122470378876 / seconds
Query Executed:select id FROM `ia` where city='University Park' && SIC_code='7011'DB:business_master_new
loadtime:1.3128349781036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbana' limit 1
loadtime:1.3128778934479 / seconds
Query Executed:select id FROM `ia` where city='Urbana' && SIC_code='7011'DB:business_master_new
loadtime:1.3141770362854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbandale' limit 1
loadtime:1.3142960071564 / seconds
Query Executed:select id FROM `ia` where city='Urbandale' && SIC_code='7011'DB:business_master_new
loadtime:1.3168931007385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute' limit 1
loadtime:1.3169519901276 / seconds
Query Executed:select id FROM `ia` where city='Ute' && SIC_code='7011'DB:business_master_new
loadtime:1.3183720111847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:1.3184559345245 / seconds
Query Executed:select id FROM `ia` where city='Vail' && SIC_code='7011'DB:business_master_new
loadtime:1.3199009895325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Horne' limit 1
loadtime:1.3199980258942 / seconds
Query Executed:select id FROM `ia` where city='Van Horne' && SIC_code='7011'DB:business_master_new
loadtime:1.3213160037994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Meter' limit 1
loadtime:1.3213670253754 / seconds
Query Executed:select id FROM `ia` where city='Van Meter' && SIC_code='7011'DB:business_master_new
loadtime:1.3227200508118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wert' limit 1
loadtime:1.3228540420532 / seconds
Query Executed:select id FROM `ia` where city='Van Wert' && SIC_code='7011'DB:business_master_new
loadtime:1.3237419128418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varina' limit 1
loadtime:1.3237779140472 / seconds
Query Executed:select id FROM `ia` where city='Varina' && SIC_code='7011'DB:business_master_new
loadtime:1.3243041038513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventura' limit 1
loadtime:1.3243460655212 / seconds
Query Executed:select id FROM `ia` where city='Ventura' && SIC_code='7011'DB:business_master_new
loadtime:1.325385093689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:1.3255190849304 / seconds
Query Executed:select id FROM `ia` where city='Victor' && SIC_code='7011'DB:business_master_new
loadtime:1.3271920681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villisca' limit 1
loadtime:1.3272440433502 / seconds
Query Executed:select id FROM `ia` where city='Villisca' && SIC_code='7011'DB:business_master_new
loadtime:1.3285520076752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincent' limit 1
loadtime:1.3287000656128 / seconds
Query Executed:select id FROM `ia` where city='Vincent' && SIC_code='7011'DB:business_master_new
loadtime:1.3298559188843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vining' limit 1
loadtime:1.3299889564514 / seconds
Query Executed:select id FROM `ia` where city='Vining' && SIC_code='7011'DB:business_master_new
loadtime:1.3305099010468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:1.3306379318237 / seconds
Query Executed:select id FROM `ia` where city='Vinton' && SIC_code='7011'DB:business_master_new
loadtime:1.3325710296631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:1.3327660560608 / seconds
Query Executed:select id FROM `ia` where city='Viola' && SIC_code='7011'DB:business_master_new
loadtime:1.3332009315491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:1.3332419395447 / seconds
Query Executed:select id FROM `ia` where city='Volga' && SIC_code='7011'DB:business_master_new
loadtime:1.334184885025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadena' limit 1
loadtime:1.3342320919037 / seconds
Query Executed:select id FROM `ia` where city='Wadena' && SIC_code='7011'DB:business_master_new
loadtime:1.3351860046387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walcott' limit 1
loadtime:1.3353219032288 / seconds
Query Executed:select id FROM `ia` where city='Walcott' && SIC_code='7011'DB:business_master_new
loadtime:1.3368349075317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walford' limit 1
loadtime:1.3368790149689 / seconds
Query Executed:select id FROM `ia` where city='Walford' && SIC_code='7011'DB:business_master_new
loadtime:1.337898015976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walker' limit 1
loadtime:1.3380420207977 / seconds
Query Executed:select id FROM `ia` where city='Walker' && SIC_code='7011'DB:business_master_new
loadtime:1.3390650749207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Lake' limit 1
loadtime:1.3391909599304 / seconds
Query Executed:select id FROM `ia` where city='Wall Lake' && SIC_code='7011'DB:business_master_new
loadtime:1.3403310775757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:1.3403649330139 / seconds
Query Executed:select id FROM `ia` where city='Wallingford' && SIC_code='7011'DB:business_master_new
loadtime:1.3417689800262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:1.3419070243835 / seconds
Query Executed:select id FROM `ia` where city='Walnut' && SIC_code='7011'DB:business_master_new
loadtime:1.3433198928833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wapello' limit 1
loadtime:1.3433790206909 / seconds
Query Executed:select id FROM `ia` where city='Wapello' && SIC_code='7011'DB:business_master_new
loadtime:1.3452610969543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:1.3453190326691 / seconds
Query Executed:select id FROM `ia` where city='Washburn' && SIC_code='7011'DB:business_master_new
loadtime:1.3460218906403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.3461680412292 / seconds
Query Executed:select id FROM `ia` where city='Washington' && SIC_code='7011'DB:business_master_new
loadtime:1.3480129241943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washta' limit 1
loadtime:1.3481690883636 / seconds
Query Executed:select id FROM `ia` where city='Washta' && SIC_code='7011'DB:business_master_new
loadtime:1.349221944809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:1.3492701053619 / seconds
Query Executed:select id FROM `ia` where city='Waterloo' && SIC_code='7011'DB:business_master_new
loadtime:1.3529169559479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:1.3530919551849 / seconds
Query Executed:select id FROM `ia` where city='Waterville' && SIC_code='7011'DB:business_master_new
loadtime:1.354367017746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:1.3544449806213 / seconds
Query Executed:select id FROM `ia` where city='Watkins' && SIC_code='7011'DB:business_master_new
loadtime:1.3553760051727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waucoma' limit 1
loadtime:1.3554780483246 / seconds
Query Executed:select id FROM `ia` where city='Waucoma' && SIC_code='7011'DB:business_master_new
loadtime:1.3572449684143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukee' limit 1
loadtime:1.3572800159454 / seconds
Query Executed:select id FROM `ia` where city='Waukee' && SIC_code='7011'DB:business_master_new
loadtime:1.3586919307709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukon' limit 1
loadtime:1.3588469028473 / seconds
Query Executed:select id FROM `ia` where city='Waukon' && SIC_code='7011'DB:business_master_new
loadtime:1.3603620529175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.3604578971863 / seconds
Query Executed:select id FROM `ia` where city='Waverly' && SIC_code='7011'DB:business_master_new
loadtime:1.3625419139862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:1.3626968860626 / seconds
Query Executed:select id FROM `ia` where city='Wayland' && SIC_code='7011'DB:business_master_new
loadtime:1.3641669750214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:1.3642289638519 / seconds
Query Executed:select id FROM `ia` where city='Webb' && SIC_code='7011'DB:business_master_new
loadtime:1.3657579421997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.3658909797668 / seconds
Query Executed:select id FROM `ia` where city='Webster' && SIC_code='7011'DB:business_master_new
loadtime:1.3666679859161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster City' limit 1
loadtime:1.3668210506439 / seconds
Query Executed:select id FROM `ia` where city='Webster City' && SIC_code='7011'DB:business_master_new
loadtime:1.3686470985413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:1.3688309192657 / seconds
Query Executed:select id FROM `ia` where city='Weldon' && SIC_code='7011'DB:business_master_new
loadtime:1.369560956955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellman' limit 1
loadtime:1.3696959018707 / seconds
Query Executed:select id FROM `ia` where city='Wellman' && SIC_code='7011'DB:business_master_new
loadtime:1.3712739944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsburg' limit 1
loadtime:1.3714048862457 / seconds
Query Executed:select id FROM `ia` where city='Wellsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.3729128837585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welton' limit 1
loadtime:1.3730499744415 / seconds
Query Executed:select id FROM `ia` where city='Welton' && SIC_code='7011'DB:business_master_new
loadtime:1.3736650943756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesley' limit 1
loadtime:1.3737618923187 / seconds
Query Executed:select id FROM `ia` where city='Wesley' && SIC_code='7011'DB:business_master_new
loadtime:1.3753440380096 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Amana' limit 1
loadtime:1.3753950595856 / seconds
Query Executed:select id FROM `ia` where city='West Amana' && SIC_code='7011'DB:business_master_new
loadtime:1.3761560916901 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:1.3762040138245 / seconds
Query Executed:select id FROM `ia` where city='West Bend' && SIC_code='7011'DB:business_master_new
loadtime:1.3776910305023 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:1.3777649402618 / seconds
Query Executed:select id FROM `ia` where city='West Branch' && SIC_code='7011'DB:business_master_new
loadtime:1.37926197052 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burlington' limit 1
loadtime:1.3793210983276 / seconds
Query Executed:select id FROM `ia` where city='West Burlington' && SIC_code='7011'DB:business_master_new
loadtime:1.3813440799713 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chester' limit 1
loadtime:1.3814001083374 / seconds
Query Executed:select id FROM `ia` where city='West Chester' && SIC_code='7011'DB:business_master_new
loadtime:1.3823499679565 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Des Moines' limit 1
loadtime:1.3824360370636 / seconds
Query Executed:select id FROM `ia` where city='West Des Moines' && SIC_code='7011'DB:business_master_new
loadtime:1.3861439228058 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Grove' limit 1
loadtime:1.3862969875336 / seconds
Query Executed:select id FROM `ia` where city='West Grove' && SIC_code='7011'DB:business_master_new
loadtime:1.3871610164642 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Liberty' limit 1
loadtime:1.3872129917145 / seconds
Query Executed:select id FROM `ia` where city='West Liberty' && SIC_code='7011'DB:business_master_new
loadtime:1.388386964798 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:1.388552904129 / seconds
Query Executed:select id FROM `ia` where city='West Point' && SIC_code='7011'DB:business_master_new
loadtime:1.3902990818024 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:1.3903510570526 / seconds
Query Executed:select id FROM `ia` where city='West Union' && SIC_code='7011'DB:business_master_new
loadtime:1.3916339874268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:1.3916919231415 / seconds
Query Executed:select id FROM `ia` where city='Westfield' && SIC_code='7011'DB:business_master_new
loadtime:1.3921539783478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westgate' limit 1
loadtime:1.3922040462494 / seconds
Query Executed:select id FROM `ia` where city='Westgate' && SIC_code='7011'DB:business_master_new
loadtime:1.392697095871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:1.3927528858185 / seconds
Query Executed:select id FROM `ia` where city='Westphalia' && SIC_code='7011'DB:business_master_new
loadtime:1.3931050300598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westside' limit 1
loadtime:1.3931438922882 / seconds
Query Executed:select id FROM `ia` where city='Westside' && SIC_code='7011'DB:business_master_new
loadtime:1.3938810825348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wever' limit 1
loadtime:1.3940370082855 / seconds
Query Executed:select id FROM `ia` where city='Wever' && SIC_code='7011'DB:business_master_new
loadtime:1.395220041275 / seconds
Query loaded from cache:select * from geodata_geocity where city='What Cheer' limit 1
loadtime:1.3952569961548 / seconds
Query Executed:select id FROM `ia` where city='What Cheer' && SIC_code='7011'DB:business_master_new
loadtime:1.3967850208282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheatland' limit 1
loadtime:1.3968350887299 / seconds
Query Executed:select id FROM `ia` where city='Wheatland' && SIC_code='7011'DB:business_master_new
loadtime:1.3979449272156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:1.3980259895325 / seconds
Query Executed:select id FROM `ia` where city='Whiting' && SIC_code='7011'DB:business_master_new
loadtime:1.399425983429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:1.3995890617371 / seconds
Query Executed:select id FROM `ia` where city='Whittemore' && SIC_code='7011'DB:business_master_new
loadtime:1.4008750915527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitten' limit 1
loadtime:1.4009230136871 / seconds
Query Executed:select id FROM `ia` where city='Whitten' && SIC_code='7011'DB:business_master_new
loadtime:1.401458978653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:1.4015638828278 / seconds
Query Executed:select id FROM `ia` where city='Williams' && SIC_code='7011'DB:business_master_new
loadtime:1.4029829502106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.403165102005 / seconds
Query Executed:select id FROM `ia` where city='Williamsburg' && SIC_code='7011'DB:business_master_new
loadtime:1.4047119617462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamson' limit 1
loadtime:1.4048290252686 / seconds
Query Executed:select id FROM `ia` where city='Williamson' && SIC_code='7011'DB:business_master_new
loadtime:1.4053709506989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.405473947525 / seconds
Query Executed:select id FROM `ia` where city='Wilton' && SIC_code='7011'DB:business_master_new
loadtime:1.4070799350739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Heights' limit 1
loadtime:1.4071969985962 / seconds
Query Executed:select id FROM `ia` where city='Windsor Heights' && SIC_code='7011'DB:business_master_new
loadtime:1.4088060855865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:1.4088659286499 / seconds
Query Executed:select id FROM `ia` where city='Winfield' && SIC_code='7011'DB:business_master_new
loadtime:1.4101419448853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterset' limit 1
loadtime:1.4102039337158 / seconds
Query Executed:select id FROM `ia` where city='Winterset' && SIC_code='7011'DB:business_master_new
loadtime:1.4120900630951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:1.4122068881989 / seconds
Query Executed:select id FROM `ia` where city='Winthrop' && SIC_code='7011'DB:business_master_new
loadtime:1.4132120609283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiota' limit 1
loadtime:1.4132640361786 / seconds
Query Executed:select id FROM `ia` where city='Wiota' && SIC_code='7011'DB:business_master_new
loadtime:1.4144079685211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woden' limit 1
loadtime:1.4144489765167 / seconds
Query Executed:select id FROM `ia` where city='Woden' && SIC_code='7011'DB:business_master_new
loadtime:1.4156088829041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:1.4157381057739 / seconds
Query Executed:select id FROM `ia` where city='Woodbine' && SIC_code='7011'DB:business_master_new
loadtime:1.4165759086609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodburn' limit 1
loadtime:1.4166369438171 / seconds
Query Executed:select id FROM `ia` where city='Woodburn' && SIC_code='7011'DB:business_master_new
loadtime:1.4171469211578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodward' limit 1
loadtime:1.4171938896179 / seconds
Query Executed:select id FROM `ia` where city='Woodward' && SIC_code='7011'DB:business_master_new
loadtime:1.4178318977356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolstock' limit 1
loadtime:1.4178791046143 / seconds
Query Executed:select id FROM `ia` where city='Woolstock' && SIC_code='7011'DB:business_master_new
loadtime:1.4184329509735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:1.4184799194336 / seconds
Query Executed:select id FROM `ia` where city='Worthington' && SIC_code='7011'DB:business_master_new
loadtime:1.4191319942474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:1.4191811084747 / seconds
Query Executed:select id FROM `ia` where city='Wyoming' && SIC_code='7011'DB:business_master_new
loadtime:1.4198660850525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:1.4199199676514 / seconds
Query Executed:select id FROM `ia` where city='Yale' && SIC_code='7011'DB:business_master_new
loadtime:1.4204409122467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth' limit 1
loadtime:1.420490026474 / seconds
Query Executed:select id FROM `ia` where city='Yarmouth' && SIC_code='7011'DB:business_master_new
loadtime:1.4209740161896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:1.421019077301 / seconds
Query Executed:select id FROM `ia` where city='Yorktown' && SIC_code='7011'DB:business_master_new
loadtime:1.4213199615479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zearing' limit 1
loadtime:1.4213531017303 / seconds
Query Executed:select id FROM `ia` where city='Zearing' && SIC_code='7011'DB:business_master_new
loadtime:1.422003030777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zwingle' limit 1
loadtime:1.4220540523529 / seconds
Query Executed:select id FROM `ia` where city='Zwingle' && SIC_code='7011'DB:business_master_new
loadtime:1.4226849079132 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.4227678775787 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.4229741096497 / seconds
Operation template executed (chunk cache operation)
loadtime:1.4230399131775 / seconds
template override:Default
loadtime:1.4230570793152 / 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:1.4237909317017 / seconds
Template Constructed, Array Rows:49
loadtime:1.4240279197693 / seconds
TOTAL EXECUTION TIME: 1.42384
loadtime:1.4243500232697 / 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] => hotels-and-motels [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:1.4243578910828
TOTAL KEY ARRAYS: 69