Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.5088272094727E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017709732055664 / seconds
host not found setting manual db connection
loadtime:0.0096330642700195 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0098910331726074 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010057926177979 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010117053985596 / seconds
zipcode:
loadtime:0.010145902633667 / seconds
Query Executed:select * from search_referrer where page_hash='7f7931e1ceb1b80d276a4d4445deb03d' limit 10 DB:ezrox_toadli
loadtime:0.010379076004028 / seconds
Operation header executed (non global)
loadtime:0.0104079246521 / seconds
Operation leaderboard executed (non global)
loadtime:0.0104660987854 / seconds
Operation square executed (non global)
loadtime:0.010497093200684 / seconds
Operation square_bottom executed (non global)
loadtime:0.010524034500122 / seconds
Operation smallsquare executed (non global)
loadtime:0.010549068450928 / seconds
Operation headeradright executed (non global)
loadtime:0.010574102401733 / seconds
Operation google_analytics executed (non global)
loadtime:0.01059889793396 / seconds
Operation topstories executed (non global)
loadtime:0.010623931884766 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010651111602783 / seconds
Operation memberbuscount executed (non global)
loadtime:0.01067590713501 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010922908782959 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.01109504699707 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011130094528198 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.01118803024292 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011236906051636 / seconds
Template key: archive_menu pushed
loadtime:0.011259078979492 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011275053024292 / seconds
Template key: get_gravatar pushed
loadtime:0.011281967163086 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011291027069092 / seconds
*10)-10)+1 | start:0
loadtime:0.01133394241333 / seconds
DB connected to localhost business_master_new
loadtime:0.01158595085144 / seconds
Query Executed:select * from categories where cat_URLid='gasoline-service-station'DB:business_master_new
loadtime:0.012568950653076 / seconds
Query stored in cache : _QUERY_www.toadli.comae9eaa17c7f2f271be87cf6879e91433
loadtime:0.012628078460693 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.012667894363403 / seconds
Query Executed:select * from `ia_catmap` where sic='5541' order by city ascDB:business_master_new
loadtime:0.037354946136475 / seconds
Query stored in cache : _QUERY_www.toadli.comebd760586bfd9270aedf22563bbd86ef
loadtime:0.041197061538696 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.041276931762695 / seconds
Query Executed:select sum(totalcount) as totalsum from `ia_catmap` where sic='5541'DB:business_master_new
loadtime:0.046138048171997 / seconds
Query stored in cache : _QUERY_www.toadli.comeeb947883acddd76754547d53524fa74
loadtime:0.046174049377441 / seconds
981 / 11
loadtime:0.046228885650635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackley' limit 1
loadtime:0.046303987503052 / seconds
Query Executed:select id FROM `ia` where city='Ackley' && SIC_code='5541'DB:business_master_new
loadtime:0.051721096038818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackworth' limit 1
loadtime:0.05177903175354 / seconds
Query Executed:select id FROM `ia` where city='Ackworth' && SIC_code='5541'DB:business_master_new
loadtime:0.05233907699585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adair' limit 1
loadtime:0.052392959594727 / seconds
Query Executed:select id FROM `ia` where city='Adair' && SIC_code='5541'DB:business_master_new
loadtime:0.054162979125977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adel' limit 1
loadtime:0.054234027862549 / seconds
Query Executed:select id FROM `ia` where city='Adel' && SIC_code='5541'DB:business_master_new
loadtime:0.057575941085815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.057642936706543 / seconds
Query Executed:select id FROM `ia` where city='Afton' && SIC_code='5541'DB:business_master_new
loadtime:0.058720111846924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agency' limit 1
loadtime:0.058773994445801 / seconds
Query Executed:select id FROM `ia` where city='Agency' && SIC_code='5541'DB:business_master_new
loadtime:0.059619903564453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ainsworth' limit 1
loadtime:0.059686899185181 / seconds
Query Executed:select id FROM `ia` where city='Ainsworth' && SIC_code='5541'DB:business_master_new
loadtime:0.060595035552979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.060650110244751 / seconds
Query Executed:select id FROM `ia` where city='Akron' && SIC_code='5541'DB:business_master_new
loadtime:0.062182903289795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albert City' limit 1
loadtime:0.062236070632935 / seconds
Query Executed:select id FROM `ia` where city='Albert City' && SIC_code='5541'DB:business_master_new
loadtime:0.063486099243164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albia' limit 1
loadtime:0.063539028167725 / seconds
Query Executed:select id FROM `ia` where city='Albia' && SIC_code='5541'DB:business_master_new
loadtime:0.06704306602478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albion' limit 1
loadtime:0.067109107971191 / seconds
Query Executed:select id FROM `ia` where city='Albion' && SIC_code='5541'DB:business_master_new
loadtime:0.067940950393677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alburnett' limit 1
loadtime:0.067995071411133 / seconds
Query Executed:select id FROM `ia` where city='Alburnett' && SIC_code='5541'DB:business_master_new
loadtime:0.068934917449951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.068986892700195 / seconds
Query Executed:select id FROM `ia` where city='Alden' && SIC_code='5541'DB:business_master_new
loadtime:0.070143938064575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.070195913314819 / seconds
Query Executed:select id FROM `ia` where city='Alexander' && SIC_code='5541'DB:business_master_new
loadtime:0.070995092391968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algona' limit 1
loadtime:0.071047067642212 / seconds
Query Executed:select id FROM `ia` where city='Algona' && SIC_code='5541'DB:business_master_new
loadtime:0.0764319896698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alleman' limit 1
loadtime:0.076499938964844 / seconds
Query Executed:select id FROM `ia` where city='Alleman' && SIC_code='5541'DB:business_master_new
loadtime:0.077125072479248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendorf' limit 1
loadtime:0.077178001403809 / seconds
Query Executed:select id FROM `ia` where city='Allendorf' && SIC_code='5541'DB:business_master_new
loadtime:0.077590942382812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allerton' limit 1
loadtime:0.077646017074585 / seconds
Query Executed:select id FROM `ia` where city='Allerton' && SIC_code='5541'DB:business_master_new
loadtime:0.078455924987793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allison' limit 1
loadtime:0.078510046005249 / seconds
Query Executed:select id FROM `ia` where city='Allison' && SIC_code='5541'DB:business_master_new
loadtime:0.080506086349487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.080574035644531 / seconds
Query Executed:select id FROM `ia` where city='Alpha' && SIC_code='5541'DB:business_master_new
loadtime:0.080996036529541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.081048011779785 / seconds
Query Executed:select id FROM `ia` where city='Alta' && SIC_code='5541'DB:business_master_new
loadtime:0.08276891708374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta Vista' limit 1
loadtime:0.082823038101196 / seconds
Query Executed:select id FROM `ia` where city='Alta Vista' && SIC_code='5541'DB:business_master_new
loadtime:0.083559036254883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.083611965179443 / seconds
Query Executed:select id FROM `ia` where city='Alton' && SIC_code='5541'DB:business_master_new
loadtime:0.085369110107422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.085427045822144 / seconds
Query Executed:select id FROM `ia` where city='Altoona' && SIC_code='5541'DB:business_master_new
loadtime:0.089709043502808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alvord' limit 1
loadtime:0.089778900146484 / seconds
Query Executed:select id FROM `ia` where city='Alvord' && SIC_code='5541'DB:business_master_new
loadtime:0.090512037277222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amana' limit 1
loadtime:0.090565919876099 / seconds
Query Executed:select id FROM `ia` where city='Amana' && SIC_code='5541'DB:business_master_new
loadtime:0.092449903488159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ames' limit 1
loadtime:0.092503070831299 / seconds
Query Executed:select id FROM `ia` where city='Ames' && SIC_code='5541'DB:business_master_new
loadtime:0.097711086273193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anamosa' limit 1
loadtime:0.097783088684082 / seconds
Query Executed:select id FROM `ia` where city='Anamosa' && SIC_code='5541'DB:business_master_new
loadtime:0.10148501396179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.10155296325684 / seconds
Query Executed:select id FROM `ia` where city='Andover' && SIC_code='5541'DB:business_master_new
loadtime:0.1020929813385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrew' limit 1
loadtime:0.10214495658875 / seconds
Query Executed:select id FROM `ia` where city='Andrew' && SIC_code='5541'DB:business_master_new
loadtime:0.10275411605835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anita' limit 1
loadtime:0.10280704498291 / seconds
Query Executed:select id FROM `ia` where city='Anita' && SIC_code='5541'DB:business_master_new
loadtime:0.10417199134827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ankeny' limit 1
loadtime:0.10422492027283 / seconds
Query Executed:select id FROM `ia` where city='Ankeny' && SIC_code='5541'DB:business_master_new
loadtime:0.11494588851929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthon' limit 1
loadtime:0.11501502990723 / seconds
Query Executed:select id FROM `ia` where city='Anthon' && SIC_code='5541'DB:business_master_new
loadtime:0.11610102653503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aplington' limit 1
loadtime:0.11616802215576 / seconds
Query Executed:select id FROM `ia` where city='Aplington' && SIC_code='5541'DB:business_master_new
loadtime:0.11755800247192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.1176118850708 / seconds
Query Executed:select id FROM `ia` where city='Arcadia' && SIC_code='5541'DB:business_master_new
loadtime:0.11864495277405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archer' limit 1
loadtime:0.11869812011719 / seconds
Query Executed:select id FROM `ia` where city='Archer' && SIC_code='5541'DB:business_master_new
loadtime:0.11943793296814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aredale' limit 1
loadtime:0.1194920539856 / seconds
Query Executed:select id FROM `ia` where city='Aredale' && SIC_code='5541'DB:business_master_new
loadtime:0.11998510360718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.12003588676453 / seconds
Query Executed:select id FROM `ia` where city='Argyle' && SIC_code='5541'DB:business_master_new
loadtime:0.12066793441772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arion' limit 1
loadtime:0.12071990966797 / seconds
Query Executed:select id FROM `ia` where city='Arion' && SIC_code='5541'DB:business_master_new
loadtime:0.1212329864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arispe' limit 1
loadtime:0.12129306793213 / seconds
Query Executed:select id FROM `ia` where city='Arispe' && SIC_code='5541'DB:business_master_new
loadtime:0.1217930316925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.12186002731323 / seconds
Query Executed:select id FROM `ia` where city='Arlington' && SIC_code='5541'DB:business_master_new
loadtime:0.12286496162415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armstrong' limit 1
loadtime:0.1229259967804 / seconds
Query Executed:select id FROM `ia` where city='Armstrong' && SIC_code='5541'DB:business_master_new
loadtime:0.12463092803955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arnolds Park' limit 1
loadtime:0.12468409538269 / seconds
Query Executed:select id FROM `ia` where city='Arnolds Park' && SIC_code='5541'DB:business_master_new
loadtime:0.12656497955322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arthur' limit 1
loadtime:0.12661695480347 / seconds
Query Executed:select id FROM `ia` where city='Arthur' && SIC_code='5541'DB:business_master_new
loadtime:0.12734699249268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.12741303443909 / seconds
Query Executed:select id FROM `ia` where city='Ashton' && SIC_code='5541'DB:business_master_new
loadtime:0.12833404541016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aspinwall' limit 1
loadtime:0.12838697433472 / seconds
Query Executed:select id FROM `ia` where city='Aspinwall' && SIC_code='5541'DB:business_master_new
loadtime:0.12888789176941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atalissa' limit 1
loadtime:0.12894105911255 / seconds
Query Executed:select id FROM `ia` where city='Atalissa' && SIC_code='5541'DB:business_master_new
loadtime:0.12967491149902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkins' limit 1
loadtime:0.12973999977112 / seconds
Query Executed:select id FROM `ia` where city='Atkins' && SIC_code='5541'DB:business_master_new
loadtime:0.13081502914429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.13086795806885 / seconds
Query Executed:select id FROM `ia` where city='Atlantic' && SIC_code='5541'DB:business_master_new
loadtime:0.13646197319031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.13653206825256 / seconds
Query Executed:select id FROM `ia` where city='Auburn' && SIC_code='5541'DB:business_master_new
loadtime:0.13739609718323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.13745498657227 / seconds
Query Executed:select id FROM `ia` where city='Audubon' && SIC_code='5541'DB:business_master_new
loadtime:0.14085006713867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurelia' limit 1
loadtime:0.14099097251892 / seconds
Query Executed:select id FROM `ia` where city='Aurelia' && SIC_code='5541'DB:business_master_new
loadtime:0.14230608940125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.14236903190613 / seconds
Query Executed:select id FROM `ia` where city='Aurora' && SIC_code='5541'DB:business_master_new
loadtime:0.14314889907837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Austinville' limit 1
loadtime:0.14322805404663 / seconds
Query Executed:select id FROM `ia` where city='Austinville' && SIC_code='5541'DB:business_master_new
loadtime:0.14369988441467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.14375305175781 / seconds
Query Executed:select id FROM `ia` where city='Avoca' && SIC_code='5541'DB:business_master_new
loadtime:0.14589095115662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayrshire' limit 1
loadtime:0.14596009254456 / seconds
Query Executed:select id FROM `ia` where city='Ayrshire' && SIC_code='5541'DB:business_master_new
loadtime:0.14661693572998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.14667105674744 / seconds
Query Executed:select id FROM `ia` where city='Badger' && SIC_code='5541'DB:business_master_new
loadtime:0.14739894866943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.14745211601257 / seconds
Query Executed:select id FROM `ia` where city='Bagley' && SIC_code='5541'DB:business_master_new
loadtime:0.14808797836304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.14813899993896 / seconds
Query Executed:select id FROM `ia` where city='Baldwin' && SIC_code='5541'DB:business_master_new
loadtime:0.1487181186676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.14878511428833 / seconds
Query Executed:select id FROM `ia` where city='Bancroft' && SIC_code='5541'DB:business_master_new
loadtime:0.1500198841095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnes City' limit 1
loadtime:0.15007305145264 / seconds
Query Executed:select id FROM `ia` where city='Barnes City' && SIC_code='5541'DB:business_master_new
loadtime:0.15070390701294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnum' limit 1
loadtime:0.1507580280304 / seconds
Query Executed:select id FROM `ia` where city='Barnum' && SIC_code='5541'DB:business_master_new
loadtime:0.15138292312622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batavia' limit 1
loadtime:0.15143609046936 / seconds
Query Executed:select id FROM `ia` where city='Batavia' && SIC_code='5541'DB:business_master_new
loadtime:0.15241503715515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battle Creek' limit 1
loadtime:0.15248107910156 / seconds
Query Executed:select id FROM `ia` where city='Battle Creek' && SIC_code='5541'DB:business_master_new
loadtime:0.15355205535889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baxter' limit 1
loadtime:0.1536169052124 / seconds
Query Executed:select id FROM `ia` where city='Baxter' && SIC_code='5541'DB:business_master_new
loadtime:0.15467500686646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayard' limit 1
loadtime:0.15472888946533 / seconds
Query Executed:select id FROM `ia` where city='Bayard' && SIC_code='5541'DB:business_master_new
loadtime:0.15556788444519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon' limit 1
loadtime:0.15563297271729 / seconds
Query Executed:select id FROM `ia` where city='Beacon' && SIC_code='5541'DB:business_master_new
loadtime:0.15617108345032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaconsfield' limit 1
loadtime:0.15623211860657 / seconds
Query Executed:select id FROM `ia` where city='Beaconsfield' && SIC_code='5541'DB:business_master_new
loadtime:0.15666198730469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaman' limit 1
loadtime:0.15671491622925 / seconds
Query Executed:select id FROM `ia` where city='Beaman' && SIC_code='5541'DB:business_master_new
loadtime:0.15740704536438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.15745902061462 / seconds
Query Executed:select id FROM `ia` where city='Beaver' && SIC_code='5541'DB:business_master_new
loadtime:0.1579270362854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.15797710418701 / seconds
Query Executed:select id FROM `ia` where city='Bedford' && SIC_code='5541'DB:business_master_new
loadtime:0.16030597686768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Plaine' limit 1
loadtime:0.16036510467529 / seconds
Query Executed:select id FROM `ia` where city='Belle Plaine' && SIC_code='5541'DB:business_master_new
loadtime:0.16202998161316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellevue' limit 1
loadtime:0.16209602355957 / seconds
Query Executed:select id FROM `ia` where city='Bellevue' && SIC_code='5541'DB:business_master_new
loadtime:0.16500306129456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmond' limit 1
loadtime:0.16506910324097 / seconds
Query Executed:select id FROM `ia` where city='Belmond' && SIC_code='5541'DB:business_master_new
loadtime:0.16746997833252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.16753792762756 / seconds
Query Executed:select id FROM `ia` where city='Bennett' && SIC_code='5541'DB:business_master_new
loadtime:0.16828608512878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.16833996772766 / seconds
Query Executed:select id FROM `ia` where city='Benton' && SIC_code='5541'DB:business_master_new
loadtime:0.16882491111755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernard' limit 1
loadtime:0.1688768863678 / seconds
Query Executed:select id FROM `ia` where city='Bernard' && SIC_code='5541'DB:business_master_new
loadtime:0.16989207267761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berwick' limit 1
loadtime:0.16994404792786 / seconds
Query Executed:select id FROM `ia` where city='Berwick' && SIC_code='5541'DB:business_master_new
loadtime:0.17043900489807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bettendorf' limit 1
loadtime:0.17049193382263 / seconds
Query Executed:select id FROM `ia` where city='Bettendorf' && SIC_code='5541'DB:business_master_new
loadtime:0.17555689811707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bevington' limit 1
loadtime:0.17562794685364 / seconds
Query Executed:select id FROM `ia` where city='Bevington' && SIC_code='5541'DB:business_master_new
loadtime:0.17611002922058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Rock' limit 1
loadtime:0.17616295814514 / seconds
Query Executed:select id FROM `ia` where city='Big Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.17658495903015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.1766369342804 / seconds
Query Executed:select id FROM `ia` where city='Birmingham' && SIC_code='5541'DB:business_master_new
loadtime:0.17735910415649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairsburg' limit 1
loadtime:0.17741203308105 / seconds
Query Executed:select id FROM `ia` where city='Blairsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.1780800819397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairstown' limit 1
loadtime:0.17813205718994 / seconds
Query Executed:select id FROM `ia` where city='Blairstown' && SIC_code='5541'DB:business_master_new
loadtime:0.17970895767212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blakesburg' limit 1
loadtime:0.17976498603821 / seconds
Query Executed:select id FROM `ia` where city='Blakesburg' && SIC_code='5541'DB:business_master_new
loadtime:0.18056607246399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanchard' limit 1
loadtime:0.18063306808472 / seconds
Query Executed:select id FROM `ia` where city='Blanchard' && SIC_code='5541'DB:business_master_new
loadtime:0.18114495277405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blencoe' limit 1
loadtime:0.1812059879303 / seconds
Query Executed:select id FROM `ia` where city='Blencoe' && SIC_code='5541'DB:business_master_new
loadtime:0.18182396888733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blockton' limit 1
loadtime:0.18187689781189 / seconds
Query Executed:select id FROM `ia` where city='Blockton' && SIC_code='5541'DB:business_master_new
loadtime:0.18254590034485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.18261194229126 / seconds
Query Executed:select id FROM `ia` where city='Bloomfield' && SIC_code='5541'DB:business_master_new
loadtime:0.18656396865845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Grass' limit 1
loadtime:0.1866180896759 / seconds
Query Executed:select id FROM `ia` where city='Blue Grass' && SIC_code='5541'DB:business_master_new
loadtime:0.18809199333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bode' limit 1
loadtime:0.18814492225647 / seconds
Query Executed:select id FROM `ia` where city='Bode' && SIC_code='5541'DB:business_master_new
loadtime:0.18896293640137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonaparte' limit 1
loadtime:0.18901610374451 / seconds
Query Executed:select id FROM `ia` where city='Bonaparte' && SIC_code='5541'DB:business_master_new
loadtime:0.18990206718445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondurant' limit 1
loadtime:0.18995594978333 / seconds
Query Executed:select id FROM `ia` where city='Bondurant' && SIC_code='5541'DB:business_master_new
loadtime:0.1914050579071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.19147205352783 / seconds
Query Executed:select id FROM `ia` where city='Boone' && SIC_code='5541'DB:business_master_new
loadtime:0.19849395751953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booneville' limit 1
loadtime:0.19856309890747 / seconds
Query Executed:select id FROM `ia` where city='Booneville' && SIC_code='5541'DB:business_master_new
loadtime:0.19904804229736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouton' limit 1
loadtime:0.19910097122192 / seconds
Query Executed:select id FROM `ia` where city='Bouton' && SIC_code='5541'DB:business_master_new
loadtime:0.19978189468384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxholm' limit 1
loadtime:0.19983506202698 / seconds
Query Executed:select id FROM `ia` where city='Boxholm' && SIC_code='5541'DB:business_master_new
loadtime:0.20042204856873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyden' limit 1
loadtime:0.2004759311676 / seconds
Query Executed:select id FROM `ia` where city='Boyden' && SIC_code='5541'DB:business_master_new
loadtime:0.20152592658997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braddyville' limit 1
loadtime:0.20159196853638 / seconds
Query Executed:select id FROM `ia` where city='Braddyville' && SIC_code='5541'DB:business_master_new
loadtime:0.2022008895874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.20225501060486 / seconds
Query Executed:select id FROM `ia` where city='Bradford' && SIC_code='5541'DB:business_master_new
loadtime:0.20273900032043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradgate' limit 1
loadtime:0.20279097557068 / seconds
Query Executed:select id FROM `ia` where city='Bradgate' && SIC_code='5541'DB:business_master_new
loadtime:0.20329904556274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.20335292816162 / seconds
Query Executed:select id FROM `ia` where city='Brandon' && SIC_code='5541'DB:business_master_new
loadtime:0.20395493507385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brayton' limit 1
loadtime:0.20400595664978 / seconds
Query Executed:select id FROM `ia` where city='Brayton' && SIC_code='5541'DB:business_master_new
loadtime:0.20463609695435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Breda' limit 1
loadtime:0.20468997955322 / seconds
Query Executed:select id FROM `ia` where city='Breda' && SIC_code='5541'DB:business_master_new
loadtime:0.20571208000183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.20577788352966 / seconds
Query Executed:select id FROM `ia` where city='Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:0.20645904541016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.2065110206604 / seconds
Query Executed:select id FROM `ia` where city='Brighton' && SIC_code='5541'DB:business_master_new
loadtime:0.20791411399841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristow' limit 1
loadtime:0.20798110961914 / seconds
Query Executed:select id FROM `ia` where city='Bristow' && SIC_code='5541'DB:business_master_new
loadtime:0.20865297317505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britt' limit 1
loadtime:0.2087070941925 / seconds
Query Executed:select id FROM `ia` where city='Britt' && SIC_code='5541'DB:business_master_new
loadtime:0.21110510826111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.21115708351135 / seconds
Query Executed:select id FROM `ia` where city='Bronson' && SIC_code='5541'DB:business_master_new
loadtime:0.21182703971863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.21187901496887 / seconds
Query Executed:select id FROM `ia` where city='Brooklyn' && SIC_code='5541'DB:business_master_new
loadtime:0.2140040397644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunsville' limit 1
loadtime:0.21407198905945 / seconds
Query Executed:select id FROM `ia` where city='Brunsville' && SIC_code='5541'DB:business_master_new
loadtime:0.21460700035095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.21465992927551 / seconds
Query Executed:select id FROM `ia` where city='Bryant' && SIC_code='5541'DB:business_master_new
loadtime:0.21524000167847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.21529293060303 / seconds
Query Executed:select id FROM `ia` where city='Buckeye' && SIC_code='5541'DB:business_master_new
loadtime:0.21572709083557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckingham' limit 1
loadtime:0.21578001976013 / seconds
Query Executed:select id FROM `ia` where city='Buckingham' && SIC_code='5541'DB:business_master_new
loadtime:0.2163200378418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.2163770198822 / seconds
Query Executed:select id FROM `ia` where city='Buffalo' && SIC_code='5541'DB:business_master_new
loadtime:0.21710801124573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Center' limit 1
loadtime:0.21715903282166 / seconds
Query Executed:select id FROM `ia` where city='Buffalo Center' && SIC_code='5541'DB:business_master_new
loadtime:0.21867609024048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.21874189376831 / seconds
Query Executed:select id FROM `ia` where city='Burlington' && SIC_code='5541'DB:business_master_new
loadtime:0.23001909255981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnside' limit 1
loadtime:0.23009300231934 / seconds
Query Executed:select id FROM `ia` where city='Burnside' && SIC_code='5541'DB:business_master_new
loadtime:0.23067498207092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burt' limit 1
loadtime:0.23072910308838 / seconds
Query Executed:select id FROM `ia` where city='Burt' && SIC_code='5541'DB:business_master_new
loadtime:0.23174691200256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bussey' limit 1
loadtime:0.23181295394897 / seconds
Query Executed:select id FROM `ia` where city='Bussey' && SIC_code='5541'DB:business_master_new
loadtime:0.23253703117371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calamus' limit 1
loadtime:0.23259091377258 / seconds
Query Executed:select id FROM `ia` where city='Calamus' && SIC_code='5541'DB:business_master_new
loadtime:0.2335090637207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Callender' limit 1
loadtime:0.23357605934143 / seconds
Query Executed:select id FROM `ia` where city='Callender' && SIC_code='5541'DB:business_master_new
loadtime:0.23440408706665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calmar' limit 1
loadtime:0.23445701599121 / seconds
Query Executed:select id FROM `ia` where city='Calmar' && SIC_code='5541'DB:business_master_new
loadtime:0.23572611808777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.2357919216156 / seconds
Query Executed:select id FROM `ia` where city='Calumet' && SIC_code='5541'DB:business_master_new
loadtime:0.23634195327759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camanche' limit 1
loadtime:0.23640108108521 / seconds
Query Executed:select id FROM `ia` where city='Camanche' && SIC_code='5541'DB:business_master_new
loadtime:0.23801803588867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.23807001113892 / seconds
Query Executed:select id FROM `ia` where city='Cambridge' && SIC_code='5541'DB:business_master_new
loadtime:0.23894906044006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cantril' limit 1
loadtime:0.23900198936462 / seconds
Query Executed:select id FROM `ia` where city='Cantril' && SIC_code='5541'DB:business_master_new
loadtime:0.23969006538391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbon' limit 1
loadtime:0.23975801467896 / seconds
Query Executed:select id FROM `ia` where city='Carbon' && SIC_code='5541'DB:business_master_new
loadtime:0.24024605751038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.24029898643494 / seconds
Query Executed:select id FROM `ia` where city='Carlisle' && SIC_code='5541'DB:business_master_new
loadtime:0.24263191223145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carnarvon' limit 1
loadtime:0.24268388748169 / seconds
Query Executed:select id FROM `ia` where city='Carnarvon' && SIC_code='5541'DB:business_master_new
loadtime:0.24311900138855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.24317002296448 / seconds
Query Executed:select id FROM `ia` where city='Carpenter' && SIC_code='5541'DB:business_master_new
loadtime:0.24365901947021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.24371290206909 / seconds
Query Executed:select id FROM `ia` where city='Carroll' && SIC_code='5541'DB:business_master_new
loadtime:0.25137495994568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.25144195556641 / seconds
Query Executed:select id FROM `ia` where city='Carson' && SIC_code='5541'DB:business_master_new
loadtime:0.25239610671997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter Lake' limit 1
loadtime:0.25244903564453 / seconds
Query Executed:select id FROM `ia` where city='Carter Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.25410389900208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.2541708946228 / seconds
Query Executed:select id FROM `ia` where city='Cascade' && SIC_code='5541'DB:business_master_new
loadtime:0.25674390792847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casey' limit 1
loadtime:0.25681090354919 / seconds
Query Executed:select id FROM `ia` where city='Casey' && SIC_code='5541'DB:business_master_new
loadtime:0.25786399841309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:0.2579300403595 / seconds
Query Executed:select id FROM `ia` where city='Castalia' && SIC_code='5541'DB:business_master_new
loadtime:0.25866293907166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castana' limit 1
loadtime:0.25871801376343 / seconds
Query Executed:select id FROM `ia` where city='Castana' && SIC_code='5541'DB:business_master_new
loadtime:0.25951910018921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.25957202911377 / seconds
Query Executed:select id FROM `ia` where city='Cedar' && SIC_code='5541'DB:business_master_new
loadtime:0.26014804840088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:0.26020789146423 / seconds
Query Executed:select id FROM `ia` where city='Cedar Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.26530694961548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Rapids' limit 1
loadtime:0.26538109779358 / seconds
Query Executed:select id FROM `ia` where city='Cedar Rapids' && SIC_code='5541'DB:business_master_new
loadtime:0.27032089233398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Junction' limit 1
loadtime:0.27041506767273 / seconds
Query Executed:select id FROM `ia` where city='Center Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.27104496955872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Point' limit 1
loadtime:0.27109909057617 / seconds
Query Executed:select id FROM `ia` where city='Center Point' && SIC_code='5541'DB:business_master_new
loadtime:0.27322602272034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.27329111099243 / seconds
Query Executed:select id FROM `ia` where city='Centerville' && SIC_code='5541'DB:business_master_new
loadtime:0.27784609794617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.27791309356689 / seconds
Query Executed:select id FROM `ia` where city='Central City' && SIC_code='5541'DB:business_master_new
loadtime:0.27951312065125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.27958106994629 / seconds
Query Executed:select id FROM `ia` where city='Chapin' && SIC_code='5541'DB:business_master_new
loadtime:0.28004503250122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chariton' limit 1
loadtime:0.28009700775146 / seconds
Query Executed:select id FROM `ia` where city='Chariton' && SIC_code='5541'DB:business_master_new
loadtime:0.28368997573853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:0.28375601768494 / seconds
Query Executed:select id FROM `ia` where city='Charles City' && SIC_code='5541'DB:business_master_new
loadtime:0.2891309261322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.2892119884491 / seconds
Query Executed:select id FROM `ia` where city='Charlotte' && SIC_code='5541'DB:business_master_new
loadtime:0.29001498222351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charter Oak' limit 1
loadtime:0.29006910324097 / seconds
Query Executed:select id FROM `ia` where city='Charter Oak' && SIC_code='5541'DB:business_master_new
loadtime:0.29111289978027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:0.29117894172668 / seconds
Query Executed:select id FROM `ia` where city='Chatsworth' && SIC_code='5541'DB:business_master_new
loadtime:0.29168701171875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.29173898696899 / seconds
Query Executed:select id FROM `ia` where city='Chelsea' && SIC_code='5541'DB:business_master_new
loadtime:0.29259395599365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.29264807701111 / seconds
Query Executed:select id FROM `ia` where city='Cherokee' && SIC_code='5541'DB:business_master_new
loadtime:0.29696393013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.29703211784363 / seconds
Query Executed:select id FROM `ia` where city='Chester' && SIC_code='5541'DB:business_master_new
loadtime:0.29764294624329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chillicothe' limit 1
loadtime:0.29769611358643 / seconds
Query Executed:select id FROM `ia` where city='Chillicothe' && SIC_code='5541'DB:business_master_new
loadtime:0.29815793037415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churdan' limit 1
loadtime:0.29821705818176 / seconds
Query Executed:select id FROM `ia` where city='Churdan' && SIC_code='5541'DB:business_master_new
loadtime:0.29914808273315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cincinnati' limit 1
loadtime:0.29921007156372 / seconds
Query Executed:select id FROM `ia` where city='Cincinnati' && SIC_code='5541'DB:business_master_new
loadtime:0.29986596107483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:0.29991698265076 / seconds
Query Executed:select id FROM `ia` where city='Clare' && SIC_code='5541'DB:business_master_new
loadtime:0.30077195167542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarence' limit 1
loadtime:0.30083990097046 / seconds
Query Executed:select id FROM `ia` where city='Clarence' && SIC_code='5541'DB:business_master_new
loadtime:0.3020191192627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarinda' limit 1
loadtime:0.30207300186157 / seconds
Query Executed:select id FROM `ia` where city='Clarinda' && SIC_code='5541'DB:business_master_new
loadtime:0.30607199668884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarion' limit 1
loadtime:0.30613803863525 / seconds
Query Executed:select id FROM `ia` where city='Clarion' && SIC_code='5541'DB:business_master_new
loadtime:0.30920505523682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.30925893783569 / seconds
Query Executed:select id FROM `ia` where city='Clarksville' && SIC_code='5541'DB:business_master_new
loadtime:0.31069493293762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.31076312065125 / seconds
Query Executed:select id FROM `ia` where city='Clear Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.31664204597473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.31671404838562 / seconds
Query Executed:select id FROM `ia` where city='Clearfield' && SIC_code='5541'DB:business_master_new
loadtime:0.31753206253052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleghorn' limit 1
loadtime:0.31759905815125 / seconds
Query Executed:select id FROM `ia` where city='Cleghorn' && SIC_code='5541'DB:business_master_new
loadtime:0.31829595565796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemons' limit 1
loadtime:0.31835103034973 / seconds
Query Executed:select id FROM `ia` where city='Clemons' && SIC_code='5541'DB:business_master_new
loadtime:0.31896591186523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clermont' limit 1
loadtime:0.31901788711548 / seconds
Query Executed:select id FROM `ia` where city='Clermont' && SIC_code='5541'DB:business_master_new
loadtime:0.31998991966248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climbing Hill' limit 1
loadtime:0.32005405426025 / seconds
Query Executed:select id FROM `ia` where city='Climbing Hill' && SIC_code='5541'DB:business_master_new
loadtime:0.32055902481079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.32061290740967 / seconds
Query Executed:select id FROM `ia` where city='Clinton' && SIC_code='5541'DB:business_master_new
loadtime:0.33092093467712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.33099508285522 / seconds
Query Executed:select id FROM `ia` where city='Clio' && SIC_code='5541'DB:business_master_new
loadtime:0.33150911331177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clive' limit 1
loadtime:0.3315761089325 / seconds
Query Executed:select id FROM `ia` where city='Clive' && SIC_code='5541'DB:business_master_new
loadtime:0.33962392807007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clutier' limit 1
loadtime:0.33969497680664 / seconds
Query Executed:select id FROM `ia` where city='Clutier' && SIC_code='5541'DB:business_master_new
loadtime:0.34060311317444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coggon' limit 1
loadtime:0.34065794944763 / seconds
Query Executed:select id FROM `ia` where city='Coggon' && SIC_code='5541'DB:business_master_new
loadtime:0.34168291091919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coin' limit 1
loadtime:0.3417489528656 / seconds
Query Executed:select id FROM `ia` where city='Coin' && SIC_code='5541'DB:business_master_new
loadtime:0.34243011474609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colesburg' limit 1
loadtime:0.34248495101929 / seconds
Query Executed:select id FROM `ia` where city='Colesburg' && SIC_code='5541'DB:business_master_new
loadtime:0.34328198432922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.34333395957947 / seconds
Query Executed:select id FROM `ia` where city='Colfax' && SIC_code='5541'DB:business_master_new
loadtime:0.345046043396 / seconds
Query loaded from cache:select * from geodata_geocity where city='College Springs' limit 1
loadtime:0.34511399269104 / seconds
Query Executed:select id FROM `ia` where city='College Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.34562492370605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.34567904472351 / seconds
Query Executed:select id FROM `ia` where city='Collins' && SIC_code='5541'DB:business_master_new
loadtime:0.34643507003784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colo' limit 1
loadtime:0.34648895263672 / seconds
Query Executed:select id FROM `ia` where city='Colo' && SIC_code='5541'DB:business_master_new
loadtime:0.34740591049194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.34745907783508 / seconds
Query Executed:select id FROM `ia` where city='Columbia' && SIC_code='5541'DB:business_master_new
loadtime:0.34796690940857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus City' limit 1
loadtime:0.3480179309845 / seconds
Query Executed:select id FROM `ia` where city='Columbus City' && SIC_code='5541'DB:business_master_new
loadtime:0.34856390953064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Jct' limit 1
loadtime:0.34861707687378 / seconds
Query Executed:select id FROM `ia` where city='Columbus Jct' && SIC_code='5541'DB:business_master_new
loadtime:0.34906506538391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Junction' limit 1
loadtime:0.34911608695984 / seconds
Query Executed:select id FROM `ia` where city='Columbus Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.35123109817505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colwell' limit 1
loadtime:0.35128402709961 / seconds
Query Executed:select id FROM `ia` where city='Colwell' && SIC_code='5541'DB:business_master_new
loadtime:0.3517119884491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conesville' limit 1
loadtime:0.35176396369934 / seconds
Query Executed:select id FROM `ia` where city='Conesville' && SIC_code='5541'DB:business_master_new
loadtime:0.35235190391541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrad' limit 1
loadtime:0.35240888595581 / seconds
Query Executed:select id FROM `ia` where city='Conrad' && SIC_code='5541'DB:business_master_new
loadtime:0.35396695137024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conroy' limit 1
loadtime:0.35402011871338 / seconds
Query Executed:select id FROM `ia` where city='Conroy' && SIC_code='5541'DB:business_master_new
loadtime:0.35457396507263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Rapids' limit 1
loadtime:0.35462689399719 / seconds
Query Executed:select id FROM `ia` where city='Coon Rapids' && SIC_code='5541'DB:business_master_new
loadtime:0.35635590553284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooper' limit 1
loadtime:0.35641002655029 / seconds
Query Executed:select id FROM `ia` where city='Cooper' && SIC_code='5541'DB:business_master_new
loadtime:0.35688900947571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coralville' limit 1
loadtime:0.35694003105164 / seconds
Query Executed:select id FROM `ia` where city='Coralville' && SIC_code='5541'DB:business_master_new
loadtime:0.36400198936462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corning' limit 1
loadtime:0.3640730381012 / seconds
Query Executed:select id FROM `ia` where city='Corning' && SIC_code='5541'DB:business_master_new
loadtime:0.36715888977051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Correctionville' limit 1
loadtime:0.36723709106445 / seconds
Query Executed:select id FROM `ia` where city='Correctionville' && SIC_code='5541'DB:business_master_new
loadtime:0.3683009147644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corwith' limit 1
loadtime:0.36836004257202 / seconds
Query Executed:select id FROM `ia` where city='Corwith' && SIC_code='5541'DB:business_master_new
loadtime:0.36920809745789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corydon' limit 1
loadtime:0.36926007270813 / seconds
Query Executed:select id FROM `ia` where city='Corydon' && SIC_code='5541'DB:business_master_new
loadtime:0.37157297134399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coulter' limit 1
loadtime:0.37164402008057 / seconds
Query Executed:select id FROM `ia` where city='Coulter' && SIC_code='5541'DB:business_master_new
loadtime:0.37228608131409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council Bluffs' limit 1
loadtime:0.37234091758728 / seconds
Query Executed:select id FROM `ia` where city='Council Bluffs' && SIC_code='5541'DB:business_master_new
loadtime:0.37749004364014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawfordsville' limit 1
loadtime:0.37756991386414 / seconds
Query Executed:select id FROM `ia` where city='Crawfordsville' && SIC_code='5541'DB:business_master_new
loadtime:0.37839603424072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crescent' limit 1
loadtime:0.37846302986145 / seconds
Query Executed:select id FROM `ia` where city='Crescent' && SIC_code='5541'DB:business_master_new
loadtime:0.37943506240845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresco' limit 1
loadtime:0.37948894500732 / seconds
Query Executed:select id FROM `ia` where city='Cresco' && SIC_code='5541'DB:business_master_new
loadtime:0.3831000328064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.38316702842712 / seconds
Query Executed:select id FROM `ia` where city='Creston' && SIC_code='5541'DB:business_master_new
loadtime:0.38851809501648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.38858699798584 / seconds
Query Executed:select id FROM `ia` where city='Cromwell' && SIC_code='5541'DB:business_master_new
loadtime:0.38909912109375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Lake' limit 1
loadtime:0.38915109634399 / seconds
Query Executed:select id FROM `ia` where city='Crystal Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.38979005813599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.38984298706055 / seconds
Query Executed:select id FROM `ia` where city='Cumberland' && SIC_code='5541'DB:business_master_new
loadtime:0.39064192771912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumming' limit 1
loadtime:0.39069509506226 / seconds
Query Executed:select id FROM `ia` where city='Cumming' && SIC_code='5541'DB:business_master_new
loadtime:0.3917019367218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curlew' limit 1
loadtime:0.39175510406494 / seconds
Query Executed:select id FROM `ia` where city='Curlew' && SIC_code='5541'DB:business_master_new
loadtime:0.39235401153564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:0.39240908622742 / seconds
Query Executed:select id FROM `ia` where city='Cushing' && SIC_code='5541'DB:business_master_new
loadtime:0.39310789108276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cylinder' limit 1
loadtime:0.39316010475159 / seconds
Query Executed:select id FROM `ia` where city='Cylinder' && SIC_code='5541'DB:business_master_new
loadtime:0.393963098526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota City' limit 1
loadtime:0.39401698112488 / seconds
Query Executed:select id FROM `ia` where city='Dakota City' && SIC_code='5541'DB:business_master_new
loadtime:0.39485788345337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.39491105079651 / seconds
Query Executed:select id FROM `ia` where city='Dallas' && SIC_code='5541'DB:business_master_new
loadtime:0.39537906646729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas Center' limit 1
loadtime:0.39543199539185 / seconds
Query Executed:select id FROM `ia` where city='Dallas Center' && SIC_code='5541'DB:business_master_new
loadtime:0.39659190177917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:0.39664602279663 / seconds
Query Executed:select id FROM `ia` where city='Dana' && SIC_code='5541'DB:business_master_new
loadtime:0.39714598655701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.39720606803894 / seconds
Query Executed:select id FROM `ia` where city='Danbury' && SIC_code='5541'DB:business_master_new
loadtime:0.39824199676514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.3982949256897 / seconds
Query Executed:select id FROM `ia` where city='Danville' && SIC_code='5541'DB:business_master_new
loadtime:0.39953708648682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:0.39958906173706 / seconds
Query Executed:select id FROM `ia` where city='Davenport' && SIC_code='5541'DB:business_master_new
loadtime:0.40453290939331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis City' limit 1
loadtime:0.40462207794189 / seconds
Query Executed:select id FROM `ia` where city='Davis City' && SIC_code='5541'DB:business_master_new
loadtime:0.40527009963989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawson' limit 1
loadtime:0.4053258895874 / seconds
Query Executed:select id FROM `ia` where city='Dawson' && SIC_code='5541'DB:business_master_new
loadtime:0.40582990646362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.40588092803955 / seconds
Query Executed:select id FROM `ia` where city='Dayton' && SIC_code='5541'DB:business_master_new
loadtime:0.40710711479187 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:0.40716004371643 / seconds
Query Executed:select id FROM `ia` where city='De Soto' && SIC_code='5541'DB:business_master_new
loadtime:0.40786910057068 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Witt' limit 1
loadtime:0.40792107582092 / seconds
Query Executed:select id FROM `ia` where city='De Witt' && SIC_code='5541'DB:business_master_new
loadtime:0.41190004348755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.41196799278259 / seconds
Query Executed:select id FROM `ia` where city='Decatur' && SIC_code='5541'DB:business_master_new
loadtime:0.41256809234619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decorah' limit 1
loadtime:0.41262197494507 / seconds
Query Executed:select id FROM `ia` where city='Decorah' && SIC_code='5541'DB:business_master_new
loadtime:0.41951990127563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.41959190368652 / seconds
Query Executed:select id FROM `ia` where city='Dedham' && SIC_code='5541'DB:business_master_new
loadtime:0.4203360080719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.42039608955383 / seconds
Query Executed:select id FROM `ia` where city='Deep River' && SIC_code='5541'DB:business_master_new
loadtime:0.421217918396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Defiance' limit 1
loadtime:0.42126989364624 / seconds
Query Executed:select id FROM `ia` where city='Defiance' && SIC_code='5541'DB:business_master_new
loadtime:0.4221019744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:0.42215490341187 / seconds
Query Executed:select id FROM `ia` where city='Delaware' && SIC_code='5541'DB:business_master_new
loadtime:0.42269611358643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delhi' limit 1
loadtime:0.42276191711426 / seconds
Query Executed:select id FROM `ia` where city='Delhi' && SIC_code='5541'DB:business_master_new
loadtime:0.42397499084473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmar' limit 1
loadtime:0.42404294013977 / seconds
Query Executed:select id FROM `ia` where city='Delmar' && SIC_code='5541'DB:business_master_new
loadtime:0.4248149394989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deloit' limit 1
loadtime:0.42488288879395 / seconds
Query Executed:select id FROM `ia` where city='Deloit' && SIC_code='5541'DB:business_master_new
loadtime:0.42539811134338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.42545199394226 / seconds
Query Executed:select id FROM `ia` where city='Delta' && SIC_code='5541'DB:business_master_new
loadtime:0.42600393295288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denison' limit 1
loadtime:0.42605495452881 / seconds
Query Executed:select id FROM `ia` where city='Denison' && SIC_code='5541'DB:business_master_new
loadtime:0.43120098114014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.43126797676086 / seconds
Query Executed:select id FROM `ia` where city='Denmark' && SIC_code='5541'DB:business_master_new
loadtime:0.43186807632446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.43192100524902 / seconds
Query Executed:select id FROM `ia` where city='Denver' && SIC_code='5541'DB:business_master_new
loadtime:0.43347191810608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.43352603912354 / seconds
Query Executed:select id FROM `ia` where city='Derby' && SIC_code='5541'DB:business_master_new
loadtime:0.43406701087952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.43411803245544 / seconds
Query Executed:select id FROM `ia` where city='Des Moines' && SIC_code='5541'DB:business_master_new
loadtime:0.43912696838379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewar' limit 1
loadtime:0.43922901153564 / seconds
Query Executed:select id FROM `ia` where city='Dewar' && SIC_code='5541'DB:business_master_new
loadtime:0.43980002403259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.43985509872437 / seconds
Query Executed:select id FROM `ia` where city='Dexter' && SIC_code='5541'DB:business_master_new
loadtime:0.44076299667358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diagonal' limit 1
loadtime:0.44081711769104 / seconds
Query Executed:select id FROM `ia` where city='Diagonal' && SIC_code='5541'DB:business_master_new
loadtime:0.44159507751465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickens' limit 1
loadtime:0.44166207313538 / seconds
Query Executed:select id FROM `ia` where city='Dickens' && SIC_code='5541'DB:business_master_new
loadtime:0.44232797622681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dike' limit 1
loadtime:0.44238710403442 / seconds
Query Executed:select id FROM `ia` where city='Dike' && SIC_code='5541'DB:business_master_new
loadtime:0.44336009025574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.4434130191803 / seconds
Query Executed:select id FROM `ia` where city='Dixon' && SIC_code='5541'DB:business_master_new
loadtime:0.44423389434814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolliver' limit 1
loadtime:0.44428610801697 / seconds
Query Executed:select id FROM `ia` where city='Dolliver' && SIC_code='5541'DB:business_master_new
loadtime:0.44481492042542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donahue' limit 1
loadtime:0.44486904144287 / seconds
Query Executed:select id FROM `ia` where city='Donahue' && SIC_code='5541'DB:business_master_new
loadtime:0.44562196731567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donnellson' limit 1
loadtime:0.44567394256592 / seconds
Query Executed:select id FROM `ia` where city='Donnellson' && SIC_code='5541'DB:business_master_new
loadtime:0.44729495048523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doon' limit 1
loadtime:0.4473659992218 / seconds
Query Executed:select id FROM `ia` where city='Doon' && SIC_code='5541'DB:business_master_new
loadtime:0.44844007492065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.4485080242157 / seconds
Query Executed:select id FROM `ia` where city='Dorchester' && SIC_code='5541'DB:business_master_new
loadtime:0.4492781162262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douds' limit 1
loadtime:0.44933104515076 / seconds
Query Executed:select id FROM `ia` where city='Douds' && SIC_code='5541'DB:business_master_new
loadtime:0.45014810562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dougherty' limit 1
loadtime:0.4502100944519 / seconds
Query Executed:select id FROM `ia` where city='Dougherty' && SIC_code='5541'DB:business_master_new
loadtime:0.45083904266357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dow City' limit 1
loadtime:0.45089197158813 / seconds
Query Executed:select id FROM `ia` where city='Dow City' && SIC_code='5541'DB:business_master_new
loadtime:0.45179796218872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dows' limit 1
loadtime:0.45186400413513 / seconds
Query Executed:select id FROM `ia` where city='Dows' && SIC_code='5541'DB:business_master_new
loadtime:0.45298504829407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakesville' limit 1
loadtime:0.45305299758911 / seconds
Query Executed:select id FROM `ia` where city='Drakesville' && SIC_code='5541'DB:business_master_new
loadtime:0.45374202728271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dubuque' limit 1
loadtime:0.45379590988159 / seconds
Query Executed:select id FROM `ia` where city='Dubuque' && SIC_code='5541'DB:business_master_new
loadtime:0.45877695083618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:0.45885491371155 / seconds
Query Executed:select id FROM `ia` where city='Dumont' && SIC_code='5541'DB:business_master_new
loadtime:0.45993304252625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncombe' limit 1
loadtime:0.46000409126282 / seconds
Query Executed:select id FROM `ia` where city='Duncombe' && SIC_code='5541'DB:business_master_new
loadtime:0.46089291572571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.46094703674316 / seconds
Query Executed:select id FROM `ia` where city='Dundee' && SIC_code='5541'DB:business_master_new
loadtime:0.46158003807068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunkerton' limit 1
loadtime:0.46163296699524 / seconds
Query Executed:select id FROM `ia` where city='Dunkerton' && SIC_code='5541'DB:business_master_new
loadtime:0.46273589134216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunlap' limit 1
loadtime:0.4627890586853 / seconds
Query Executed:select id FROM `ia` where city='Dunlap' && SIC_code='5541'DB:business_master_new
loadtime:0.4642128944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:0.46426606178284 / seconds
Query Executed:select id FROM `ia` where city='Durango' && SIC_code='5541'DB:business_master_new
loadtime:0.46505093574524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.46510291099548 / seconds
Query Executed:select id FROM `ia` where city='Durant' && SIC_code='5541'DB:business_master_new
loadtime:0.46665692329407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyersville' limit 1
loadtime:0.46672296524048 / seconds
Query Executed:select id FROM `ia` where city='Dyersville' && SIC_code='5541'DB:business_master_new
loadtime:0.4702320098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dysart' limit 1
loadtime:0.47028803825378 / seconds
Query Executed:select id FROM `ia` where city='Dysart' && SIC_code='5541'DB:business_master_new
loadtime:0.47205090522766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Grove' limit 1
loadtime:0.4721040725708 / seconds
Query Executed:select id FROM `ia` where city='Eagle Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.47427105903625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlham' limit 1
loadtime:0.47432589530945 / seconds
Query Executed:select id FROM `ia` where city='Earlham' && SIC_code='5541'DB:business_master_new
loadtime:0.47571396827698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earling' limit 1
loadtime:0.47578096389771 / seconds
Query Executed:select id FROM `ia` where city='Earling' && SIC_code='5541'DB:business_master_new
loadtime:0.47682094573975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlville' limit 1
loadtime:0.47688698768616 / seconds
Query Executed:select id FROM `ia` where city='Earlville' && SIC_code='5541'DB:business_master_new
loadtime:0.47796010971069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early' limit 1
loadtime:0.47802495956421 / seconds
Query Executed:select id FROM `ia` where city='Early' && SIC_code='5541'DB:business_master_new
loadtime:0.47902894020081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eddyville' limit 1
loadtime:0.47909498214722 / seconds
Query Executed:select id FROM `ia` where city='Eddyville' && SIC_code='5541'DB:business_master_new
loadtime:0.48032689094543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.48038601875305 / seconds
Query Executed:select id FROM `ia` where city='Edgewood' && SIC_code='5541'DB:business_master_new
loadtime:0.48179697990417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:0.48186492919922 / seconds
Query Executed:select id FROM `ia` where city='Elberon' && SIC_code='5541'DB:business_master_new
loadtime:0.48252511024475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldon' limit 1
loadtime:0.48257803916931 / seconds
Query Executed:select id FROM `ia` where city='Eldon' && SIC_code='5541'DB:business_master_new
loadtime:0.48350501060486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldora' limit 1
loadtime:0.48357009887695 / seconds
Query Executed:select id FROM `ia` where city='Eldora' && SIC_code='5541'DB:business_master_new
loadtime:0.48574495315552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:0.48580002784729 / seconds
Query Executed:select id FROM `ia` where city='Eldorado' && SIC_code='5541'DB:business_master_new
loadtime:0.48627090454102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldridge' limit 1
loadtime:0.48632407188416 / seconds
Query Executed:select id FROM `ia` where city='Eldridge' && SIC_code='5541'DB:business_master_new
loadtime:0.48955988883972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.48962593078613 / seconds
Query Executed:select id FROM `ia` where city='Elgin' && SIC_code='5541'DB:business_master_new
loadtime:0.49062204360962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Horn' limit 1
loadtime:0.49068808555603 / seconds
Query Executed:select id FROM `ia` where city='Elk Horn' && SIC_code='5541'DB:business_master_new
loadtime:0.49197006225586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Run Heights' limit 1
loadtime:0.49203705787659 / seconds
Query Executed:select id FROM `ia` where city='Elk Run Heights' && SIC_code='5541'DB:business_master_new
loadtime:0.49252796173096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkader' limit 1
loadtime:0.49258208274841 / seconds
Query Executed:select id FROM `ia` where city='Elkader' && SIC_code='5541'DB:business_master_new
loadtime:0.4953179359436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart' limit 1
loadtime:0.49537491798401 / seconds
Query Executed:select id FROM `ia` where city='Elkhart' && SIC_code='5541'DB:business_master_new
loadtime:0.49603796005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkport' limit 1
loadtime:0.49608898162842 / seconds
Query Executed:select id FROM `ia` where city='Elkport' && SIC_code='5541'DB:business_master_new
loadtime:0.49660611152649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.49667191505432 / seconds
Query Executed:select id FROM `ia` where city='Elliott' && SIC_code='5541'DB:business_master_new
loadtime:0.49749994277954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellston' limit 1
loadtime:0.49755311012268 / seconds
Query Executed:select id FROM `ia` where city='Ellston' && SIC_code='5541'DB:business_master_new
loadtime:0.49816393852234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.49822592735291 / seconds
Query Executed:select id FROM `ia` where city='Ellsworth' && SIC_code='5541'DB:business_master_new
loadtime:0.4991021156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elma' limit 1
loadtime:0.49915409088135 / seconds
Query Executed:select id FROM `ia` where city='Elma' && SIC_code='5541'DB:business_master_new
loadtime:0.50031900405884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:0.50039100646973 / seconds
Query Executed:select id FROM `ia` where city='Elwood' && SIC_code='5541'DB:business_master_new
loadtime:0.5008430480957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ely' limit 1
loadtime:0.50089502334595 / seconds
Query Executed:select id FROM `ia` where city='Ely' && SIC_code='5541'DB:business_master_new
loadtime:0.50242495536804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:0.50249004364014 / seconds
Query Executed:select id FROM `ia` where city='Emerson' && SIC_code='5541'DB:business_master_new
loadtime:0.5035080909729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmetsburg' limit 1
loadtime:0.50356101989746 / seconds
Query Executed:select id FROM `ia` where city='Emmetsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.50700092315674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epworth' limit 1
loadtime:0.50707006454468 / seconds
Query Executed:select id FROM `ia` where city='Epworth' && SIC_code='5541'DB:business_master_new
loadtime:0.50821900367737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.50828504562378 / seconds
Query Executed:select id FROM `ia` where city='Essex' && SIC_code='5541'DB:business_master_new
loadtime:0.50927495956421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estherville' limit 1
loadtime:0.5093400478363 / seconds
Query Executed:select id FROM `ia` where city='Estherville' && SIC_code='5541'DB:business_master_new
loadtime:0.51374006271362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansdale' limit 1
loadtime:0.51380896568298 / seconds
Query Executed:select id FROM `ia` where city='Evansdale' && SIC_code='5541'DB:business_master_new
loadtime:0.51626896858215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everly' limit 1
loadtime:0.5163369178772 / seconds
Query Executed:select id FROM `ia` where city='Everly' && SIC_code='5541'DB:business_master_new
loadtime:0.51724600791931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exira' limit 1
loadtime:0.51731109619141 / seconds
Query Executed:select id FROM `ia` where city='Exira' && SIC_code='5541'DB:business_master_new
loadtime:0.51903390884399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exline' limit 1
loadtime:0.51910090446472 / seconds
Query Executed:select id FROM `ia` where city='Exline' && SIC_code='5541'DB:business_master_new
loadtime:0.51962900161743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairbank' limit 1
loadtime:0.51968288421631 / seconds
Query Executed:select id FROM `ia` where city='Fairbank' && SIC_code='5541'DB:business_master_new
loadtime:0.52144503593445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.52149796485901 / seconds
Query Executed:select id FROM `ia` where city='Fairfax' && SIC_code='5541'DB:business_master_new
loadtime:0.52323007583618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.52328300476074 / seconds
Query Executed:select id FROM `ia` where city='Fairfield' && SIC_code='5541'DB:business_master_new
loadtime:0.53195405006409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farley' limit 1
loadtime:0.53202199935913 / seconds
Query Executed:select id FROM `ia` where city='Farley' && SIC_code='5541'DB:business_master_new
loadtime:0.53365802764893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmersburg' limit 1
loadtime:0.53372502326965 / seconds
Query Executed:select id FROM `ia` where city='Farmersburg' && SIC_code='5541'DB:business_master_new
loadtime:0.53448700904846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.53454089164734 / seconds
Query Executed:select id FROM `ia` where city='Farmington' && SIC_code='5541'DB:business_master_new
loadtime:0.53561806678772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnhamville' limit 1
loadtime:0.53568506240845 / seconds
Query Executed:select id FROM `ia` where city='Farnhamville' && SIC_code='5541'DB:business_master_new
loadtime:0.53644204139709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farragut' limit 1
loadtime:0.53649711608887 / seconds
Query Executed:select id FROM `ia` where city='Farragut' && SIC_code='5541'DB:business_master_new
loadtime:0.53730010986328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.53735399246216 / seconds
Query Executed:select id FROM `ia` where city='Fayette' && SIC_code='5541'DB:business_master_new
loadtime:0.53873205184937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:0.53880095481873 / seconds
Query Executed:select id FROM `ia` where city='Fenton' && SIC_code='5541'DB:business_master_new
loadtime:0.53969788551331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:0.53976607322693 / seconds
Query Executed:select id FROM `ia` where city='Ferguson' && SIC_code='5541'DB:business_master_new
loadtime:0.54028606414795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fertile' limit 1
loadtime:0.54033994674683 / seconds
Query Executed:select id FROM `ia` where city='Fertile' && SIC_code='5541'DB:business_master_new
loadtime:0.54108095169067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Festina' limit 1
loadtime:0.54115104675293 / seconds
Query Executed:select id FROM `ia` where city='Festina' && SIC_code='5541'DB:business_master_new
loadtime:0.54163408279419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floris' limit 1
loadtime:0.54168701171875 / seconds
Query Executed:select id FROM `ia` where city='Floris' && SIC_code='5541'DB:business_master_new
loadtime:0.54228806495667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.54234194755554 / seconds
Query Executed:select id FROM `ia` where city='Floyd' && SIC_code='5541'DB:business_master_new
loadtime:0.54332089424133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fonda' limit 1
loadtime:0.54337692260742 / seconds
Query Executed:select id FROM `ia` where city='Fonda' && SIC_code='5541'DB:business_master_new
loadtime:0.5443971157074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontanelle' limit 1
loadtime:0.54445099830627 / seconds
Query Executed:select id FROM `ia` where city='Fontanelle' && SIC_code='5541'DB:business_master_new
loadtime:0.54546689987183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:0.54551911354065 / seconds
Query Executed:select id FROM `ia` where city='Forest City' && SIC_code='5541'DB:business_master_new
loadtime:0.54890894889832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:0.54897499084473 / seconds
Query Executed:select id FROM `ia` where city='Fort Atkinson' && SIC_code='5541'DB:business_master_new
loadtime:0.5506649017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dodge' limit 1
loadtime:0.55071902275085 / seconds
Query Executed:select id FROM `ia` where city='Fort Dodge' && SIC_code='5541'DB:business_master_new
loadtime:0.55583500862122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Madison' limit 1
loadtime:0.55590891838074 / seconds
Query Executed:select id FROM `ia` where city='Fort Madison' && SIC_code='5541'DB:business_master_new
loadtime:0.56147503852844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:0.56154489517212 / seconds
Query Executed:select id FROM `ia` where city='Fostoria' && SIC_code='5541'DB:business_master_new
loadtime:0.56202507019043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:0.56207704544067 / seconds
Query Executed:select id FROM `ia` where city='Fredericksburg' && SIC_code='5541'DB:business_master_new
loadtime:0.56335711479187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederika' limit 1
loadtime:0.56341004371643 / seconds
Query Executed:select id FROM `ia` where city='Frederika' && SIC_code='5541'DB:business_master_new
loadtime:0.5639750957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.56402611732483 / seconds
Query Executed:select id FROM `ia` where city='Fremont' && SIC_code='5541'DB:business_master_new
loadtime:0.56490898132324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.5649619102478 / seconds
Query Executed:select id FROM `ia` where city='Fruitland' && SIC_code='5541'DB:business_master_new
loadtime:0.56554508209229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galt' limit 1
loadtime:0.56559896469116 / seconds
Query Executed:select id FROM `ia` where city='Galt' && SIC_code='5541'DB:business_master_new
loadtime:0.56612491607666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galva' limit 1
loadtime:0.56617593765259 / seconds
Query Executed:select id FROM `ia` where city='Galva' && SIC_code='5541'DB:business_master_new
loadtime:0.56702399253845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garber' limit 1
loadtime:0.5670759677887 / seconds
Query Executed:select id FROM `ia` where city='Garber' && SIC_code='5541'DB:business_master_new
loadtime:0.56767010688782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.56772303581238 / seconds
Query Executed:select id FROM `ia` where city='Garden City' && SIC_code='5541'DB:business_master_new
loadtime:0.56822609901428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden Grove' limit 1
loadtime:0.56827712059021 / seconds
Query Executed:select id FROM `ia` where city='Garden Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.56886100769043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnavillo' limit 1
loadtime:0.56891298294067 / seconds
Query Executed:select id FROM `ia` where city='Garnavillo' && SIC_code='5541'DB:business_master_new
loadtime:0.57011795043945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:0.57019209861755 / seconds
Query Executed:select id FROM `ia` where city='Garner' && SIC_code='5541'DB:business_master_new
loadtime:0.57308888435364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.57314205169678 / seconds
Query Executed:select id FROM `ia` where city='Garrison' && SIC_code='5541'DB:business_master_new
loadtime:0.57391905784607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwin' limit 1
loadtime:0.57397103309631 / seconds
Query Executed:select id FROM `ia` where city='Garwin' && SIC_code='5541'DB:business_master_new
loadtime:0.57482695579529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geneva' limit 1
loadtime:0.57487893104553 / seconds
Query Executed:select id FROM `ia` where city='Geneva' && SIC_code='5541'DB:business_master_new
loadtime:0.57558107376099 / seconds
Query loaded from cache:select * from geodata_geocity where city='George' limit 1
loadtime:0.57563304901123 / seconds
Query Executed:select id FROM `ia` where city='George' && SIC_code='5541'DB:business_master_new
loadtime:0.57762694358826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:0.57769298553467 / seconds
Query Executed:select id FROM `ia` where city='Gibson' && SIC_code='5541'DB:business_master_new
loadtime:0.5781569480896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.57821893692017 / seconds
Query Executed:select id FROM `ia` where city='Gifford' && SIC_code='5541'DB:business_master_new
loadtime:0.57867789268494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.57873010635376 / seconds
Query Executed:select id FROM `ia` where city='Gilbert' && SIC_code='5541'DB:business_master_new
loadtime:0.57954001426697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.57959198951721 / seconds
Query Executed:select id FROM `ia` where city='Gilbertville' && SIC_code='5541'DB:business_master_new
loadtime:0.58023595809937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett Grove' limit 1
loadtime:0.58029007911682 / seconds
Query Executed:select id FROM `ia` where city='Gillett Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.5807900428772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.58085608482361 / seconds
Query Executed:select id FROM `ia` where city='Gilman' && SIC_code='5541'DB:business_master_new
loadtime:0.5822069644928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmore City' limit 1
loadtime:0.58225989341736 / seconds
Query Executed:select id FROM `ia` where city='Gilmore City' && SIC_code='5541'DB:business_master_new
loadtime:0.58310890197754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladbrook' limit 1
loadtime:0.58317494392395 / seconds
Query Executed:select id FROM `ia` where city='Gladbrook' && SIC_code='5541'DB:business_master_new
loadtime:0.58486390113831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.58491706848145 / seconds
Query Executed:select id FROM `ia` where city='Glenwood' && SIC_code='5541'DB:business_master_new
loadtime:0.58859395980835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:0.58866095542908 / seconds
Query Executed:select id FROM `ia` where city='Glidden' && SIC_code='5541'DB:business_master_new
loadtime:0.59024596214294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldfield' limit 1
loadtime:0.5902988910675 / seconds
Query Executed:select id FROM `ia` where city='Goldfield' && SIC_code='5541'DB:business_master_new
loadtime:0.59126806259155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodell' limit 1
loadtime:0.59133410453796 / seconds
Query Executed:select id FROM `ia` where city='Goodell' && SIC_code='5541'DB:business_master_new
loadtime:0.59185910224915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Lake' limit 1
loadtime:0.59191203117371 / seconds
Query Executed:select id FROM `ia` where city='Goose Lake' && SIC_code='5541'DB:business_master_new
loadtime:0.59268999099731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowrie' limit 1
loadtime:0.59274411201477 / seconds
Query Executed:select id FROM `ia` where city='Gowrie' && SIC_code='5541'DB:business_master_new
loadtime:0.59413599967957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graettinger' limit 1
loadtime:0.5942120552063 / seconds
Query Executed:select id FROM `ia` where city='Graettinger' && SIC_code='5541'DB:business_master_new
loadtime:0.5953950881958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.59546089172363 / seconds
Query Executed:select id FROM `ia` where city='Grafton' && SIC_code='5541'DB:business_master_new
loadtime:0.59620690345764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:0.59626007080078 / seconds
Query Executed:select id FROM `ia` where city='Grand Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.5972158908844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Mound' limit 1
loadtime:0.59726905822754 / seconds
Query Executed:select id FROM `ia` where city='Grand Mound' && SIC_code='5541'DB:business_master_new
loadtime:0.59824895858765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand River' limit 1
loadtime:0.59830093383789 / seconds
Query Executed:select id FROM `ia` where city='Grand River' && SIC_code='5541'DB:business_master_new
loadtime:0.5988450050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandview' limit 1
loadtime:0.59889793395996 / seconds
Query Executed:select id FROM `ia` where city='Grandview' && SIC_code='5541'DB:business_master_new
loadtime:0.59946799278259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granger' limit 1
loadtime:0.599534034729 / seconds
Query Executed:select id FROM `ia` where city='Granger' && SIC_code='5541'DB:business_master_new
loadtime:0.60072493553162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:0.60079288482666 / seconds
Query Executed:select id FROM `ia` where city='Grant' && SIC_code='5541'DB:business_master_new
loadtime:0.60132598876953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.60138392448425 / seconds
Query Executed:select id FROM `ia` where city='Granville' && SIC_code='5541'DB:business_master_new
loadtime:0.60246992111206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gravity' limit 1
loadtime:0.6025230884552 / seconds
Query Executed:select id FROM `ia` where city='Gravity' && SIC_code='5541'DB:business_master_new
loadtime:0.60304594039917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray' limit 1
loadtime:0.60309600830078 / seconds
Query Executed:select id FROM `ia` where city='Gray' && SIC_code='5541'DB:business_master_new
loadtime:0.60356688499451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:0.60362005233765 / seconds
Query Executed:select id FROM `ia` where city='Greeley' && SIC_code='5541'DB:business_master_new
loadtime:0.60427594184875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:0.604327917099 / seconds
Query Executed:select id FROM `ia` where city='Green Mountain' && SIC_code='5541'DB:business_master_new
loadtime:0.60478210449219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greene' limit 1
loadtime:0.60483407974243 / seconds
Query Executed:select id FROM `ia` where city='Greene' && SIC_code='5541'DB:business_master_new
loadtime:0.60642600059509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.6064920425415 / seconds
Query Executed:select id FROM `ia` where city='Greenfield' && SIC_code='5541'DB:business_master_new
loadtime:0.60915493965149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.60921812057495 / seconds
Query Executed:select id FROM `ia` where city='Greenville' && SIC_code='5541'DB:business_master_new
loadtime:0.60977506637573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimes' limit 1
loadtime:0.60982799530029 / seconds
Query Executed:select id FROM `ia` where city='Grimes' && SIC_code='5541'DB:business_master_new
loadtime:0.61295008659363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grinnell' limit 1
loadtime:0.61301898956299 / seconds
Query Executed:select id FROM `ia` where city='Grinnell' && SIC_code='5541'DB:business_master_new
loadtime:0.61813402175903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Griswold' limit 1
loadtime:0.61821293830872 / seconds
Query Executed:select id FROM `ia` where city='Griswold' && SIC_code='5541'DB:business_master_new
loadtime:0.6204240322113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy Center' limit 1
loadtime:0.62049102783203 / seconds
Query Executed:select id FROM `ia` where city='Grundy Center' && SIC_code='5541'DB:business_master_new
loadtime:0.6231861114502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gruver' limit 1
loadtime:0.62325501441956 / seconds
Query Executed:select id FROM `ia` where city='Gruver' && SIC_code='5541'DB:business_master_new
loadtime:0.62372899055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guernsey' limit 1
loadtime:0.62378191947937 / seconds
Query Executed:select id FROM `ia` where city='Guernsey' && SIC_code='5541'DB:business_master_new
loadtime:0.62436008453369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guthrie Center' limit 1
loadtime:0.62441396713257 / seconds
Query Executed:select id FROM `ia` where city='Guthrie Center' && SIC_code='5541'DB:business_master_new
loadtime:0.62732911109924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:0.62739992141724 / seconds
Query Executed:select id FROM `ia` where city='Guttenberg' && SIC_code='5541'DB:business_master_new
loadtime:0.63001704216003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halbur' limit 1
loadtime:0.63008308410645 / seconds
Query Executed:select id FROM `ia` where city='Halbur' && SIC_code='5541'DB:business_master_new
loadtime:0.63074207305908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:0.63079595565796 / seconds
Query Executed:select id FROM `ia` where city='Hamburg' && SIC_code='5541'DB:business_master_new
loadtime:0.63262295722961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.63268899917603 / seconds
Query Executed:select id FROM `ia` where city='Hamilton' && SIC_code='5541'DB:business_master_new
loadtime:0.63311910629272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlin' limit 1
loadtime:0.63317203521729 / seconds
Query Executed:select id FROM `ia` where city='Hamlin' && SIC_code='5541'DB:business_master_new
loadtime:0.63374304771423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.63379502296448 / seconds
Query Executed:select id FROM `ia` where city='Hampton' && SIC_code='5541'DB:business_master_new
loadtime:0.63757491111755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.63764095306396 / seconds
Query Executed:select id FROM `ia` where city='Hancock' && SIC_code='5541'DB:business_master_new
loadtime:0.63836789131165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanlontown' limit 1
loadtime:0.63843393325806 / seconds
Query Executed:select id FROM `ia` where city='Hanlontown' && SIC_code='5541'DB:business_master_new
loadtime:0.63913011550903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hansell' limit 1
loadtime:0.63920497894287 / seconds
Query Executed:select id FROM `ia` where city='Hansell' && SIC_code='5541'DB:business_master_new
loadtime:0.63962292671204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harcourt' limit 1
loadtime:0.63967609405518 / seconds
Query Executed:select id FROM `ia` where city='Harcourt' && SIC_code='5541'DB:business_master_new
loadtime:0.64042901992798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:0.64048194885254 / seconds
Query Executed:select id FROM `ia` where city='Hardy' && SIC_code='5541'DB:business_master_new
loadtime:0.64101505279541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harlan' limit 1
loadtime:0.64106607437134 / seconds
Query Executed:select id FROM `ia` where city='Harlan' && SIC_code='5541'DB:business_master_new
loadtime:0.64591503143311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:0.64598298072815 / seconds
Query Executed:select id FROM `ia` where city='Harper' && SIC_code='5541'DB:business_master_new
loadtime:0.64658403396606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harpers Ferry' limit 1
loadtime:0.64663791656494 / seconds
Query Executed:select id FROM `ia` where city='Harpers Ferry' && SIC_code='5541'DB:business_master_new
loadtime:0.64762401580811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:0.64769005775452 / seconds
Query Executed:select id FROM `ia` where city='Harris' && SIC_code='5541'DB:business_master_new
loadtime:0.6482949256897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.64834904670715 / seconds
Query Executed:select id FROM `ia` where city='Hartford' && SIC_code='5541'DB:business_master_new
loadtime:0.64890909194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartley' limit 1
loadtime:0.64896106719971 / seconds
Query Executed:select id FROM `ia` where city='Hartley' && SIC_code='5541'DB:business_master_new
loadtime:0.65125489234924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwick' limit 1
loadtime:0.65132188796997 / seconds
Query Executed:select id FROM `ia` where city='Hartwick' && SIC_code='5541'DB:business_master_new
loadtime:0.65182399749756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:0.65187692642212 / seconds
Query Executed:select id FROM `ia` where city='Harvey' && SIC_code='5541'DB:business_master_new
loadtime:0.65244102478027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:0.65250706672668 / seconds
Query Executed:select id FROM `ia` where city='Hastings' && SIC_code='5541'DB:business_master_new
loadtime:0.65312099456787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:0.65317296981812 / seconds
Query Executed:select id FROM `ia` where city='Havelock' && SIC_code='5541'DB:business_master_new
loadtime:0.65388989448547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.65394306182861 / seconds
Query Executed:select id FROM `ia` where city='Haverhill' && SIC_code='5541'DB:business_master_new
loadtime:0.65453696250916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawarden' limit 1
loadtime:0.65458989143372 / seconds
Query Executed:select id FROM `ia` where city='Hawarden' && SIC_code='5541'DB:business_master_new
loadtime:0.65687894821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkeye' limit 1
loadtime:0.65693211555481 / seconds
Query Executed:select id FROM `ia` where city='Hawkeye' && SIC_code='5541'DB:business_master_new
loadtime:0.65788507461548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:0.65793704986572 / seconds
Query Executed:select id FROM `ia` where city='Hayesville' && SIC_code='5541'DB:business_master_new
loadtime:0.6584300994873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazleton' limit 1
loadtime:0.65848398208618 / seconds
Query Executed:select id FROM `ia` where city='Hazleton' && SIC_code='5541'DB:business_master_new
loadtime:0.65950608253479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hedrick' limit 1
loadtime:0.65955805778503 / seconds
Query Executed:select id FROM `ia` where city='Hedrick' && SIC_code='5541'DB:business_master_new
loadtime:0.66057205200195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.66062307357788 / seconds
Query Executed:select id FROM `ia` where city='Henderson' && SIC_code='5541'DB:business_master_new
loadtime:0.66128206253052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.66133403778076 / seconds
Query Executed:select id FROM `ia` where city='Hiawatha' && SIC_code='5541'DB:business_master_new
loadtime:0.66460490226746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlandville' limit 1
loadtime:0.66467189788818 / seconds
Query Executed:select id FROM `ia` where city='Highlandville' && SIC_code='5541'DB:business_master_new
loadtime:0.66511201858521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hills' limit 1
loadtime:0.66516494750977 / seconds
Query Executed:select id FROM `ia` where city='Hills' && SIC_code='5541'DB:business_master_new
loadtime:0.66594099998474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.6659939289093 / seconds
Query Executed:select id FROM `ia` where city='Hillsboro' && SIC_code='5541'DB:business_master_new
loadtime:0.66657900810242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:0.66663908958435 / seconds
Query Executed:select id FROM `ia` where city='Hinton' && SIC_code='5541'DB:business_master_new
loadtime:0.66780996322632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:0.66786193847656 / seconds
Query Executed:select id FROM `ia` where city='Holland' && SIC_code='5541'DB:business_master_new
loadtime:0.66860198974609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holstein' limit 1
loadtime:0.66865491867065 / seconds
Query Executed:select id FROM `ia` where city='Holstein' && SIC_code='5541'DB:business_master_new
loadtime:0.67031788825989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holy Cross' limit 1
loadtime:0.67038893699646 / seconds
Query Executed:select id FROM `ia` where city='Holy Cross' && SIC_code='5541'DB:business_master_new
loadtime:0.67131090164185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homestead' limit 1
loadtime:0.67136788368225 / seconds
Query Executed:select id FROM `ia` where city='Homestead' && SIC_code='5541'DB:business_master_new
loadtime:0.67214393615723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:0.67220401763916 / seconds
Query Executed:select id FROM `ia` where city='Honey Creek' && SIC_code='5541'DB:business_master_new
loadtime:0.67288088798523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.67293310165405 / seconds
Query Executed:select id FROM `ia` where city='Hopkinton' && SIC_code='5541'DB:business_master_new
loadtime:0.67398500442505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hornick' limit 1
loadtime:0.67403697967529 / seconds
Query Executed:select id FROM `ia` where city='Hornick' && SIC_code='5541'DB:business_master_new
loadtime:0.67495799064636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hospers' limit 1
loadtime:0.67501091957092 / seconds
Query Executed:select id FROM `ia` where city='Hospers' && SIC_code='5541'DB:business_master_new
loadtime:0.67635011672974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.67642092704773 / seconds
Query Executed:select id FROM `ia` where city='Houghton' && SIC_code='5541'DB:business_master_new
loadtime:0.67708206176758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard' limit 1
loadtime:0.67714595794678 / seconds
Query Executed:select id FROM `ia` where city='Hubbard' && SIC_code='5541'DB:business_master_new
loadtime:0.67845797538757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.67851209640503 / seconds
Query Executed:select id FROM `ia` where city='Hudson' && SIC_code='5541'DB:business_master_new
loadtime:0.68039703369141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:0.68046307563782 / seconds
Query Executed:select id FROM `ia` where city='Hull' && SIC_code='5541'DB:business_master_new
loadtime:0.68280696868896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.6828761100769 / seconds
Query Executed:select id FROM `ia` where city='Humboldt' && SIC_code='5541'DB:business_master_new
loadtime:0.68693995475769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humeston' limit 1
loadtime:0.68700790405273 / seconds
Query Executed:select id FROM `ia` where city='Humeston' && SIC_code='5541'DB:business_master_new
loadtime:0.68793392181396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huxley' limit 1
loadtime:0.68798899650574 / seconds
Query Executed:select id FROM `ia` where city='Huxley' && SIC_code='5541'DB:business_master_new
loadtime:0.6896378993988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida Grove' limit 1
loadtime:0.68969202041626 / seconds
Query Executed:select id FROM `ia` where city='Ida Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.69253611564636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imogene' limit 1
loadtime:0.69260191917419 / seconds
Query Executed:select id FROM `ia` where city='Imogene' && SIC_code='5541'DB:business_master_new
loadtime:0.69325089454651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.69330406188965 / seconds
Query Executed:select id FROM `ia` where city='Independence' && SIC_code='5541'DB:business_master_new
loadtime:0.69848489761353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:0.69855308532715 / seconds
Query Executed:select id FROM `ia` where city='Indianola' && SIC_code='5541'DB:business_master_new
loadtime:0.70533108711243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inwood' limit 1
loadtime:0.70540690422058 / seconds
Query Executed:select id FROM `ia` where city='Inwood' && SIC_code='5541'DB:business_master_new
loadtime:0.70700788497925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:0.7070620059967 / seconds
Query Executed:select id FROM `ia` where city='Ionia' && SIC_code='5541'DB:business_master_new
loadtime:0.7081151008606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa City' limit 1
loadtime:0.70818996429443 / seconds
Query Executed:select id FROM `ia` where city='Iowa City' && SIC_code='5541'DB:business_master_new
loadtime:0.71336889266968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa Falls' limit 1
loadtime:0.71344304084778 / seconds
Query Executed:select id FROM `ia` where city='Iowa Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.71783900260925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:0.71789503097534 / seconds
Query Executed:select id FROM `ia` where city='Ira' && SIC_code='5541'DB:business_master_new
loadtime:0.71835803985596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ireton' limit 1
loadtime:0.71841096878052 / seconds
Query Executed:select id FROM `ia` where city='Ireton' && SIC_code='5541'DB:business_master_new
loadtime:0.71996903419495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irwin' limit 1
loadtime:0.72003507614136 / seconds
Query Executed:select id FROM `ia` where city='Irwin' && SIC_code='5541'DB:business_master_new
loadtime:0.72087407112122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Junction' limit 1
loadtime:0.72094106674194 / seconds
Query Executed:select id FROM `ia` where city='Jackson Junction' && SIC_code='5541'DB:business_master_new
loadtime:0.72139096260071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.72144508361816 / seconds
Query Executed:select id FROM `ia` where city='Jamaica' && SIC_code='5541'DB:business_master_new
loadtime:0.72198009490967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:0.72203207015991 / seconds
Query Executed:select id FROM `ia` where city='Janesville' && SIC_code='5541'DB:business_master_new
loadtime:0.72322607040405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.72327899932861 / seconds
Query Executed:select id FROM `ia` where city='Jefferson' && SIC_code='5541'DB:business_master_new
loadtime:0.72795295715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jesup' limit 1
loadtime:0.72800588607788 / seconds
Query Executed:select id FROM `ia` where city='Jesup' && SIC_code='5541'DB:business_master_new
loadtime:0.730712890625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell' limit 1
loadtime:0.73076605796814 / seconds
Query Executed:select id FROM `ia` where city='Jewell' && SIC_code='5541'DB:business_master_new
loadtime:0.7319700717926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.73202395439148 / seconds
Query Executed:select id FROM `ia` where city='Johnston' && SIC_code='5541'DB:business_master_new
loadtime:0.73722910881042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joice' limit 1
loadtime:0.73728489875793 / seconds
Query Executed:select id FROM `ia` where city='Joice' && SIC_code='5541'DB:business_master_new
loadtime:0.73808002471924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jolley' limit 1
loadtime:0.7381329536438 / seconds
Query Executed:select id FROM `ia` where city='Jolley' && SIC_code='5541'DB:business_master_new
loadtime:0.73877692222595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalona' limit 1
loadtime:0.73883008956909 / seconds
Query Executed:select id FROM `ia` where city='Kalona' && SIC_code='5541'DB:business_master_new
loadtime:0.74225807189941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamrar' limit 1
loadtime:0.74232506752014 / seconds
Query Executed:select id FROM `ia` where city='Kamrar' && SIC_code='5541'DB:business_master_new
loadtime:0.74300599098206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanawha' limit 1
loadtime:0.74306011199951 / seconds
Query Executed:select id FROM `ia` where city='Kanawha' && SIC_code='5541'DB:business_master_new
loadtime:0.74476909637451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellerton' limit 1
loadtime:0.74482297897339 / seconds
Query Executed:select id FROM `ia` where city='Kellerton' && SIC_code='5541'DB:business_master_new
loadtime:0.74550104141235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelley' limit 1
loadtime:0.74555492401123 / seconds
Query Executed:select id FROM `ia` where city='Kelley' && SIC_code='5541'DB:business_master_new
loadtime:0.74632096290588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellogg' limit 1
loadtime:0.74637794494629 / seconds
Query Executed:select id FROM `ia` where city='Kellogg' && SIC_code='5541'DB:business_master_new
loadtime:0.74751996994019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensett' limit 1
loadtime:0.74757289886475 / seconds
Query Executed:select id FROM `ia` where city='Kensett' && SIC_code='5541'DB:business_master_new
loadtime:0.74842190742493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.74847507476807 / seconds
Query Executed:select id FROM `ia` where city='Kent' && SIC_code='5541'DB:business_master_new
loadtime:0.7489230632782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokuk' limit 1
loadtime:0.74897408485413 / seconds
Query Executed:select id FROM `ia` where city='Keokuk' && SIC_code='5541'DB:business_master_new
loadtime:0.75538396835327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keosauqua' limit 1
loadtime:0.75545310974121 / seconds
Query Executed:select id FROM `ia` where city='Keosauqua' && SIC_code='5541'DB:business_master_new
loadtime:0.75775408744812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keota' limit 1
loadtime:0.757807970047 / seconds
Query Executed:select id FROM `ia` where city='Keota' && SIC_code='5541'DB:business_master_new
loadtime:0.75915002822876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kesley' limit 1
loadtime:0.75921201705933 / seconds
Query Executed:select id FROM `ia` where city='Kesley' && SIC_code='5541'DB:business_master_new
loadtime:0.7597119808197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:0.75976490974426 / seconds
Query Executed:select id FROM `ia` where city='Keswick' && SIC_code='5541'DB:business_master_new
loadtime:0.76051902770996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.76057195663452 / seconds
Query Executed:select id FROM `ia` where city='Keystone' && SIC_code='5541'DB:business_master_new
loadtime:0.76159310340881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killduff' limit 1
loadtime:0.76164603233337 / seconds
Query Executed:select id FROM `ia` where city='Killduff' && SIC_code='5541'DB:business_master_new
loadtime:0.76220393180847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimballton' limit 1
loadtime:0.76225590705872 / seconds
Query Executed:select id FROM `ia` where city='Kimballton' && SIC_code='5541'DB:business_master_new
loadtime:0.7630980014801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:0.76315093040466 / seconds
Query Executed:select id FROM `ia` where city='Kingsley' && SIC_code='5541'DB:business_master_new
loadtime:0.76473593711853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:0.76480197906494 / seconds
Query Executed:select id FROM `ia` where city='Kinross' && SIC_code='5541'DB:business_master_new
loadtime:0.76530003547668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkman' limit 1
loadtime:0.76536011695862 / seconds
Query Executed:select id FROM `ia` where city='Kirkman' && SIC_code='5541'DB:business_master_new
loadtime:0.76597595214844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkville' limit 1
loadtime:0.76602792739868 / seconds
Query Executed:select id FROM `ia` where city='Kirkville' && SIC_code='5541'DB:business_master_new
loadtime:0.76655292510986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiron' limit 1
loadtime:0.766606092453 / seconds
Query Executed:select id FROM `ia` where city='Kiron' && SIC_code='5541'DB:business_master_new
loadtime:0.76749801635742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Klemme' limit 1
loadtime:0.76754999160767 / seconds
Query Executed:select id FROM `ia` where city='Klemme' && SIC_code='5541'DB:business_master_new
loadtime:0.76830506324768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knierim' limit 1
loadtime:0.76836204528809 / seconds
Query Executed:select id FROM `ia` where city='Knierim' && SIC_code='5541'DB:business_master_new
loadtime:0.76886105537415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knoxville' limit 1
loadtime:0.76891207695007 / seconds
Query Executed:select id FROM `ia` where city='Knoxville' && SIC_code='5541'DB:business_master_new
loadtime:0.77341890335083 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Motte' limit 1
loadtime:0.77348709106445 / seconds
Query Executed:select id FROM `ia` where city='La Motte' && SIC_code='5541'DB:business_master_new
loadtime:0.77445507049561 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Porte City' limit 1
loadtime:0.77452206611633 / seconds
Query Executed:select id FROM `ia` where city='La Porte City' && SIC_code='5541'DB:business_master_new
loadtime:0.77697896957397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacona' limit 1
loadtime:0.7770459651947 / seconds
Query Executed:select id FROM `ia` where city='Lacona' && SIC_code='5541'DB:business_master_new
loadtime:0.77797889709473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladora' limit 1
loadtime:0.7780339717865 / seconds
Query Executed:select id FROM `ia` where city='Ladora' && SIC_code='5541'DB:business_master_new
loadtime:0.77873802185059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.77879095077515 / seconds
Query Executed:select id FROM `ia` where city='Lake City' && SIC_code='5541'DB:business_master_new
loadtime:0.78091812133789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:0.78098607063293 / seconds
Query Executed:select id FROM `ia` where city='Lake Mills' && SIC_code='5541'DB:business_master_new
loadtime:0.78349804878235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Park' limit 1
loadtime:0.78356599807739 / seconds
Query Executed:select id FROM `ia` where city='Lake Park' && SIC_code='5541'DB:business_master_new
loadtime:0.78517508506775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.78523707389832 / seconds
Query Executed:select id FROM `ia` where city='Lake View' && SIC_code='5541'DB:business_master_new
loadtime:0.78708600997925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakota' limit 1
loadtime:0.78715395927429 / seconds
Query Executed:select id FROM `ia` where city='Lakota' && SIC_code='5541'DB:business_master_new
loadtime:0.7879159450531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamoni' limit 1
loadtime:0.78798198699951 / seconds
Query Executed:select id FROM `ia` where city='Lamoni' && SIC_code='5541'DB:business_master_new
loadtime:0.78982210159302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:0.78987598419189 / seconds
Query Executed:select id FROM `ia` where city='Lamont' && SIC_code='5541'DB:business_master_new
loadtime:0.7906699180603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:0.79072308540344 / seconds
Query Executed:select id FROM `ia` where city='Lanesboro' && SIC_code='5541'DB:business_master_new
loadtime:0.7912220954895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langworthy' limit 1
loadtime:0.79127407073975 / seconds
Query Executed:select id FROM `ia` where city='Langworthy' && SIC_code='5541'DB:business_master_new
loadtime:0.79171705245972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:0.79176902770996 / seconds
Query Executed:select id FROM `ia` where city='Lansing' && SIC_code='5541'DB:business_master_new
loadtime:0.79365801811218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larchwood' limit 1
loadtime:0.79371094703674 / seconds
Query Executed:select id FROM `ia` where city='Larchwood' && SIC_code='5541'DB:business_master_new
loadtime:0.79500293731689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larrabee' limit 1
loadtime:0.79505705833435 / seconds
Query Executed:select id FROM `ia` where city='Larrabee' && SIC_code='5541'DB:business_master_new
loadtime:0.79570889472961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latimer' limit 1
loadtime:0.79576110839844 / seconds
Query Executed:select id FROM `ia` where city='Latimer' && SIC_code='5541'DB:business_master_new
loadtime:0.79672408103943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:0.79679298400879 / seconds
Query Executed:select id FROM `ia` where city='Laurel' && SIC_code='5541'DB:business_master_new
loadtime:0.79752612113953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.7975800037384 / seconds
Query Executed:select id FROM `ia` where city='Laurens' && SIC_code='5541'DB:business_master_new
loadtime:0.79907011985779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawler' limit 1
loadtime:0.79913592338562 / seconds
Query Executed:select id FROM `ia` where city='Lawler' && SIC_code='5541'DB:business_master_new
loadtime:0.80014705657959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:0.80022311210632 / seconds
Query Executed:select id FROM `ia` where city='Lawton' && SIC_code='5541'DB:business_master_new
loadtime:0.80133891105652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Claire' limit 1
loadtime:0.80140900611877 / seconds
Query Executed:select id FROM `ia` where city='Le Claire' && SIC_code='5541'DB:business_master_new
loadtime:0.80359697341919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Grand' limit 1
loadtime:0.80366396903992 / seconds
Query Executed:select id FROM `ia` where city='Le Grand' && SIC_code='5541'DB:business_master_new
loadtime:0.80438804626465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Mars' limit 1
loadtime:0.80444312095642 / seconds
Query Executed:select id FROM `ia` where city='Le Mars' && SIC_code='5541'DB:business_master_new
loadtime:0.81087899208069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.81094694137573 / seconds
Query Executed:select id FROM `ia` where city='Ledyard' && SIC_code='5541'DB:business_master_new
loadtime:0.81170105934143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehigh' limit 1
loadtime:0.81175494194031 / seconds
Query Executed:select id FROM `ia` where city='Lehigh' && SIC_code='5541'DB:business_master_new
loadtime:0.81262111663818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leighton' limit 1
loadtime:0.81267499923706 / seconds
Query Executed:select id FROM `ia` where city='Leighton' && SIC_code='5541'DB:business_master_new
loadtime:0.8133909702301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:0.81344294548035 / seconds
Query Executed:select id FROM `ia` where city='Leland' && SIC_code='5541'DB:business_master_new
loadtime:0.81423211097717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:0.81428289413452 / seconds
Query Executed:select id FROM `ia` where city='Lenox' && SIC_code='5541'DB:business_master_new
loadtime:0.81591701507568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:0.81596899032593 / seconds
Query Executed:select id FROM `ia` where city='Leon' && SIC_code='5541'DB:business_master_new
loadtime:0.81802701950073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lester' limit 1
loadtime:0.81809496879578 / seconds
Query Executed:select id FROM `ia` where city='Lester' && SIC_code='5541'DB:business_master_new
loadtime:0.81874489784241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letts' limit 1
loadtime:0.8188099861145 / seconds
Query Executed:select id FROM `ia` where city='Letts' && SIC_code='5541'DB:business_master_new
loadtime:0.81959199905396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:0.81964612007141 / seconds
Query Executed:select id FROM `ia` where city='Lewis' && SIC_code='5541'DB:business_master_new
loadtime:0.82052993774414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Center' limit 1
loadtime:0.82058310508728 / seconds
Query Executed:select id FROM `ia` where city='Liberty Center' && SIC_code='5541'DB:business_master_new
loadtime:0.82102394104004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Libertyville' limit 1
loadtime:0.82107496261597 / seconds
Query Executed:select id FROM `ia` where city='Libertyville' && SIC_code='5541'DB:business_master_new
loadtime:0.82174205780029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lidderdale' limit 1
loadtime:0.82179498672485 / seconds
Query Executed:select id FROM `ia` where city='Lidderdale' && SIC_code='5541'DB:business_master_new
loadtime:0.82236909866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Springs' limit 1
loadtime:0.82242107391357 / seconds
Query Executed:select id FROM `ia` where city='Lime Springs' && SIC_code='5541'DB:business_master_new
loadtime:0.82351803779602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.82357096672058 / seconds
Query Executed:select id FROM `ia` where city='Lincoln' && SIC_code='5541'DB:business_master_new
loadtime:0.8242130279541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:0.82426595687866 / seconds
Query Executed:select id FROM `ia` where city='Linden' && SIC_code='5541'DB:business_master_new
loadtime:0.82489204406738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lineville' limit 1
loadtime:0.82494497299194 / seconds
Query Executed:select id FROM `ia` where city='Lineville' && SIC_code='5541'DB:business_master_new
loadtime:0.82571792602539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linn Grove' limit 1
loadtime:0.82577109336853 / seconds
Query Executed:select id FROM `ia` where city='Linn Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.82650589942932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.82655811309814 / seconds
Query Executed:select id FROM `ia` where city='Lisbon' && SIC_code='5541'DB:business_master_new
loadtime:0.82804393768311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liscomb' limit 1
loadtime:0.82809805870056 / seconds
Query Executed:select id FROM `ia` where city='Liscomb' && SIC_code='5541'DB:business_master_new
loadtime:0.82873702049255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Cedar' limit 1
loadtime:0.82878994941711 / seconds
Query Executed:select id FROM `ia` where city='Little Cedar' && SIC_code='5541'DB:business_master_new
loadtime:0.82934188842773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.82939791679382 / seconds
Query Executed:select id FROM `ia` where city='Little Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.8303210735321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Sioux' limit 1
loadtime:0.83039498329163 / seconds
Query Executed:select id FROM `ia` where city='Little Sioux' && SIC_code='5541'DB:business_master_new
loadtime:0.83091902732849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:0.83097100257874 / seconds
Query Executed:select id FROM `ia` where city='Livermore' && SIC_code='5541'DB:business_master_new
loadtime:0.83175992965698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockridge' limit 1
loadtime:0.83181309700012 / seconds
Query Executed:select id FROM `ia` where city='Lockridge' && SIC_code='5541'DB:business_master_new
loadtime:0.83253788948059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.83259010314941 / seconds
Query Executed:select id FROM `ia` where city='Logan' && SIC_code='5541'DB:business_master_new
loadtime:0.83492398262024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lohrville' limit 1
loadtime:0.8349781036377 / seconds
Query Executed:select id FROM `ia` where city='Lohrville' && SIC_code='5541'DB:business_master_new
loadtime:0.83591103553772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:0.83597707748413 / seconds
Query Executed:select id FROM `ia` where city='Lone Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.83678698539734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:0.83684110641479 / seconds
Query Executed:select id FROM `ia` where city='Lone Tree' && SIC_code='5541'DB:business_master_new
loadtime:0.83800292015076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Grove' limit 1
loadtime:0.838054895401 / seconds
Query Executed:select id FROM `ia` where city='Long Grove' && SIC_code='5541'DB:business_master_new
loadtime:0.83965611457825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorimor' limit 1
loadtime:0.83970904350281 / seconds
Query Executed:select id FROM `ia` where city='Lorimor' && SIC_code='5541'DB:business_master_new
loadtime:0.84044408798218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Nation' limit 1
loadtime:0.84049701690674 / seconds
Query Executed:select id FROM `ia` where city='Lost Nation' && SIC_code='5541'DB:business_master_new
loadtime:0.84157395362854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovilia' limit 1
loadtime:0.841628074646 / seconds
Query Executed:select id FROM `ia` where city='Lovilia' && SIC_code='5541'DB:business_master_new
loadtime:0.84233903884888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:0.84239792823792 / seconds
Query Executed:select id FROM `ia` where city='Low Moor' && SIC_code='5541'DB:business_master_new
loadtime:0.84307503700256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowden' limit 1
loadtime:0.84312605857849 / seconds
Query Executed:select id FROM `ia` where city='Lowden' && SIC_code='5541'DB:business_master_new
loadtime:0.84398198127747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lu Verne' limit 1
loadtime:0.84403610229492 / seconds
Query Executed:select id FROM `ia` where city='Lu Verne' && SIC_code='5541'DB:business_master_new
loadtime:0.84501910209656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luana' limit 1
loadtime:0.84508609771729 / seconds
Query Executed:select id FROM `ia` where city='Luana' && SIC_code='5541'DB:business_master_new
loadtime:0.84593796730042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucas' limit 1
loadtime:0.84599208831787 / seconds
Query Executed:select id FROM `ia` where city='Lucas' && SIC_code='5541'DB:business_master_new
loadtime:0.84682202339172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:0.84688210487366 / seconds
Query Executed:select id FROM `ia` where city='Luther' && SIC_code='5541'DB:business_master_new
loadtime:0.84733510017395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:0.84740495681763 / seconds
Query Executed:select id FROM `ia` where city='Luxemburg' && SIC_code='5541'DB:business_master_new
loadtime:0.84794211387634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:0.8480110168457 / seconds
Query Executed:select id FROM `ia` where city='Luzerne' && SIC_code='5541'DB:business_master_new
loadtime:0.84859895706177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnville' limit 1
loadtime:0.84865188598633 / seconds
Query Executed:select id FROM `ia` where city='Lynnville' && SIC_code='5541'DB:business_master_new
loadtime:0.84966993331909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lytton' limit 1
loadtime:0.84972310066223 / seconds
Query Executed:select id FROM `ia` where city='Lytton' && SIC_code='5541'DB:business_master_new
loadtime:0.85055303573608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macedonia' limit 1
loadtime:0.85060501098633 / seconds
Query Executed:select id FROM `ia` where city='Macedonia' && SIC_code='5541'DB:business_master_new
loadtime:0.85128688812256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macksburg' limit 1
loadtime:0.85133790969849 / seconds
Query Executed:select id FROM `ia` where city='Macksburg' && SIC_code='5541'DB:business_master_new
loadtime:0.85191988945007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madrid' limit 1
loadtime:0.851970911026 / seconds
Query Executed:select id FROM `ia` where city='Madrid' && SIC_code='5541'DB:business_master_new
loadtime:0.85408306121826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:0.85415005683899 / seconds
Query Executed:select id FROM `ia` where city='Magnolia' && SIC_code='5541'DB:business_master_new
loadtime:0.85461091995239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malcom' limit 1
loadtime:0.85466408729553 / seconds
Query Executed:select id FROM `ia` where city='Malcom' && SIC_code='5541'DB:business_master_new
loadtime:0.85555291175842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mallard' limit 1
loadtime:0.85561895370483 / seconds
Query Executed:select id FROM `ia` where city='Mallard' && SIC_code='5541'DB:business_master_new
loadtime:0.85641002655029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maloy' limit 1
loadtime:0.85647511482239 / seconds
Query Executed:select id FROM `ia` where city='Maloy' && SIC_code='5541'DB:business_master_new
loadtime:0.85688591003418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malvern' limit 1
loadtime:0.85693693161011 / seconds
Query Executed:select id FROM `ia` where city='Malvern' && SIC_code='5541'DB:business_master_new
loadtime:0.85810494422913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.85815691947937 / seconds
Query Executed:select id FROM `ia` where city='Manchester' && SIC_code='5541'DB:business_master_new
loadtime:0.86283898353577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manilla' limit 1
loadtime:0.86290597915649 / seconds
Query Executed:select id FROM `ia` where city='Manilla' && SIC_code='5541'DB:business_master_new
loadtime:0.86429905891418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manly' limit 1
loadtime:0.86435890197754 / seconds
Query Executed:select id FROM `ia` where city='Manly' && SIC_code='5541'DB:business_master_new
loadtime:0.86544895172119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.86550307273865 / seconds
Query Executed:select id FROM `ia` where city='Manning' && SIC_code='5541'DB:business_master_new
loadtime:0.86786389350891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:0.86793088912964 / seconds
Query Executed:select id FROM `ia` where city='Manson' && SIC_code='5541'DB:business_master_new
loadtime:0.86977005004883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.86982393264771 / seconds
Query Executed:select id FROM `ia` where city='Mapleton' && SIC_code='5541'DB:business_master_new
loadtime:0.87141990661621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maquoketa' limit 1
loadtime:0.87147307395935 / seconds
Query Executed:select id FROM `ia` where city='Maquoketa' && SIC_code='5541'DB:business_master_new
loadtime:0.87621808052063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:0.87628388404846 / seconds
Query Executed:select id FROM `ia` where city='Marathon' && SIC_code='5541'DB:business_master_new
loadtime:0.87703800201416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Rock' limit 1
loadtime:0.87709188461304 / seconds
Query Executed:select id FROM `ia` where city='Marble Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.87792110443115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcus' limit 1
loadtime:0.87797403335571 / seconds
Query Executed:select id FROM `ia` where city='Marcus' && SIC_code='5541'DB:business_master_new
loadtime:0.87996506690979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:0.88001799583435 / seconds
Query Executed:select id FROM `ia` where city='Marengo' && SIC_code='5541'DB:business_master_new
loadtime:0.88268899917603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.88275694847107 / seconds
Query Executed:select id FROM `ia` where city='Marion' && SIC_code='5541'DB:business_master_new
loadtime:0.89206695556641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:0.89213609695435 / seconds
Query Executed:select id FROM `ia` where city='Marne' && SIC_code='5541'DB:business_master_new
loadtime:0.89279794692993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:0.89285802841187 / seconds
Query Executed:select id FROM `ia` where city='Marquette' && SIC_code='5541'DB:business_master_new
loadtime:0.89353704452515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshalltown' limit 1
loadtime:0.89358997344971 / seconds
Query Executed:select id FROM `ia` where city='Marshalltown' && SIC_code='5541'DB:business_master_new
loadtime:0.90506792068481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martelle' limit 1
loadtime:0.9051411151886 / seconds
Query Executed:select id FROM `ia` where city='Martelle' && SIC_code='5541'DB:business_master_new
loadtime:0.90593290328979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martensdale' limit 1
loadtime:0.90598893165588 / seconds
Query Executed:select id FROM `ia` where city='Martensdale' && SIC_code='5541'DB:business_master_new
loadtime:0.9066948890686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsburg' limit 1
loadtime:0.90674710273743 / seconds
Query Executed:select id FROM `ia` where city='Martinsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.90721988677979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason City' limit 1
loadtime:0.90727400779724 / seconds
Query Executed:select id FROM `ia` where city='Mason City' && SIC_code='5541'DB:business_master_new
loadtime:0.91243696212769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:0.91250491142273 / seconds
Query Executed:select id FROM `ia` where city='Masonville' && SIC_code='5541'DB:business_master_new
loadtime:0.91325688362122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massena' limit 1
loadtime:0.91331005096436 / seconds
Query Executed:select id FROM `ia` where city='Massena' && SIC_code='5541'DB:business_master_new
loadtime:0.91443610191345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matlock' limit 1
loadtime:0.91448903083801 / seconds
Query Executed:select id FROM `ia` where city='Matlock' && SIC_code='5541'DB:business_master_new
loadtime:0.91496300697327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurice' limit 1
loadtime:0.91501402854919 / seconds
Query Executed:select id FROM `ia` where city='Maurice' && SIC_code='5541'DB:business_master_new
loadtime:0.91591501235962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.91596698760986 / seconds
Query Executed:select id FROM `ia` where city='Maxwell' && SIC_code='5541'DB:business_master_new
loadtime:0.91706109046936 / seconds
Query loaded from cache:select * from geodata_geocity where city='May City' limit 1
loadtime:0.91711401939392 / seconds
Query Executed:select id FROM `ia` where city='May City' && SIC_code='5541'DB:business_master_new
loadtime:0.91758489608765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:0.91763806343079 / seconds
Query Executed:select id FROM `ia` where city='Maynard' && SIC_code='5541'DB:business_master_new
loadtime:0.91846489906311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Callsburg' limit 1
loadtime:0.91851902008057 / seconds
Query Executed:select id FROM `ia` where city='Mc Callsburg' && SIC_code='5541'DB:business_master_new
loadtime:0.91916990280151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Causland' limit 1
loadtime:0.91922903060913 / seconds
Query Executed:select id FROM `ia` where city='Mc Causland' && SIC_code='5541'DB:business_master_new
loadtime:0.91978693008423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clelland' limit 1
loadtime:0.91984009742737 / seconds
Query Executed:select id FROM `ia` where city='Mc Clelland' && SIC_code='5541'DB:business_master_new
loadtime:0.92048311233521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gregor' limit 1
loadtime:0.92053699493408 / seconds
Query Executed:select id FROM `ia` where city='Mc Gregor' && SIC_code='5541'DB:business_master_new
loadtime:0.92201495170593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intire' limit 1
loadtime:0.92206692695618 / seconds
Query Executed:select id FROM `ia` where city='Mc Intire' && SIC_code='5541'DB:business_master_new
loadtime:0.92276906967163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:0.92282199859619 / seconds
Query Executed:select id FROM `ia` where city='Mechanicsville' && SIC_code='5541'DB:business_master_new
loadtime:0.92392206192017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mediapolis' limit 1
loadtime:0.92397403717041 / seconds
Query Executed:select id FROM `ia` where city='Mediapolis' && SIC_code='5541'DB:business_master_new
loadtime:0.92598605155945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melbourne' limit 1
loadtime:0.92605304718018 / seconds
Query Executed:select id FROM `ia` where city='Melbourne' && SIC_code='5541'DB:business_master_new
loadtime:0.92681288719177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melcher' limit 1
loadtime:0.92686700820923 / seconds
Query Executed:select id FROM `ia` where city='Melcher' && SIC_code='5541'DB:business_master_new
loadtime:0.92738890647888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.92745494842529 / seconds
Query Executed:select id FROM `ia` where city='Melrose' && SIC_code='5541'DB:business_master_new
loadtime:0.92810988426208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:0.9281690120697 / seconds
Query Executed:select id FROM `ia` where city='Melvin' && SIC_code='5541'DB:business_master_new
loadtime:0.92894196510315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menlo' limit 1
loadtime:0.92899489402771 / seconds
Query Executed:select id FROM `ia` where city='Menlo' && SIC_code='5541'DB:business_master_new
loadtime:0.92992496490479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.92997789382935 / seconds
Query Executed:select id FROM `ia` where city='Meriden' && SIC_code='5541'DB:business_master_new
loadtime:0.93058395385742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:0.93063592910767 / seconds
Query Executed:select id FROM `ia` where city='Merrill' && SIC_code='5541'DB:business_master_new
loadtime:0.93166303634644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meservey' limit 1
loadtime:0.93173098564148 / seconds
Query Executed:select id FROM `ia` where city='Meservey' && SIC_code='5541'DB:business_master_new
loadtime:0.93242692947388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Amana' limit 1
loadtime:0.93248009681702 / seconds
Query Executed:select id FROM `ia` where city='Middle Amana' && SIC_code='5541'DB:business_master_new
loadtime:0.93319797515869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.93324995040894 / seconds
Query Executed:select id FROM `ia` where city='Middletown' && SIC_code='5541'DB:business_master_new
loadtime:0.93382906913757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miles' limit 1
loadtime:0.93388104438782 / seconds
Query Executed:select id FROM `ia` where city='Miles' && SIC_code='5541'DB:business_master_new
loadtime:0.93477296829224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.93483901023865 / seconds
Query Executed:select id FROM `ia` where city='Milford' && SIC_code='5541'DB:business_master_new
loadtime:0.93802404403687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:0.93809103965759 / seconds
Query Executed:select id FROM `ia` where city='Millersburg' && SIC_code='5541'DB:business_master_new
loadtime:0.93870997428894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millerton' limit 1
loadtime:0.9387629032135 / seconds
Query Executed:select id FROM `ia` where city='Millerton' && SIC_code='5541'DB:business_master_new
loadtime:0.93923497200012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milo' limit 1
loadtime:0.93928790092468 / seconds
Query Executed:select id FROM `ia` where city='Milo' && SIC_code='5541'DB:business_master_new
loadtime:0.94026398658752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.94031691551208 / seconds
Query Executed:select id FROM `ia` where city='Milton' && SIC_code='5541'DB:business_master_new
loadtime:0.94102501869202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minburn' limit 1
loadtime:0.94107794761658 / seconds
Query Executed:select id FROM `ia` where city='Minburn' && SIC_code='5541'DB:business_master_new
loadtime:0.9419949054718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden' limit 1
loadtime:0.94204711914062 / seconds
Query Executed:select id FROM `ia` where city='Minden' && SIC_code='5541'DB:business_master_new
loadtime:0.9429988861084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineola' limit 1
loadtime:0.94305109977722 / seconds
Query Executed:select id FROM `ia` where city='Mineola' && SIC_code='5541'DB:business_master_new
loadtime:0.9435670375824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mingo' limit 1
loadtime:0.94361901283264 / seconds
Query Executed:select id FROM `ia` where city='Mingo' && SIC_code='5541'DB:business_master_new
loadtime:0.94441604614258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Missouri Valley' limit 1
loadtime:0.94446897506714 / seconds
Query Executed:select id FROM `ia` where city='Missouri Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.94749093055725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.94756007194519 / seconds
Query Executed:select id FROM `ia` where city='Mitchell' && SIC_code='5541'DB:business_master_new
loadtime:0.9480299949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchellville' limit 1
loadtime:0.94808292388916 / seconds
Query Executed:select id FROM `ia` where city='Mitchellville' && SIC_code='5541'DB:business_master_new
loadtime:0.94926190376282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modale' limit 1
loadtime:0.94931411743164 / seconds
Query Executed:select id FROM `ia` where city='Modale' && SIC_code='5541'DB:business_master_new
loadtime:0.94991302490234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondamin' limit 1
loadtime:0.9499659538269 / seconds
Query Executed:select id FROM `ia` where city='Mondamin' && SIC_code='5541'DB:business_master_new
loadtime:0.95080995559692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth' limit 1
loadtime:0.95086193084717 / seconds
Query Executed:select id FROM `ia` where city='Monmouth' && SIC_code='5541'DB:business_master_new
loadtime:0.95154404640198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:0.95159602165222 / seconds
Query Executed:select id FROM `ia` where city='Monona' && SIC_code='5541'DB:business_master_new
loadtime:0.95374393463135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.95380997657776 / seconds
Query Executed:select id FROM `ia` where city='Monroe' && SIC_code='5541'DB:business_master_new
loadtime:0.95522689819336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.95529389381409 / seconds
Query Executed:select id FROM `ia` where city='Montezuma' && SIC_code='5541'DB:business_master_new
loadtime:0.95795702934265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.95801091194153 / seconds
Query Executed:select id FROM `ia` where city='Monticello' && SIC_code='5541'DB:business_master_new
loadtime:0.96197104454041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montour' limit 1
loadtime:0.96203994750977 / seconds
Query Executed:select id FROM `ia` where city='Montour' && SIC_code='5541'DB:business_master_new
loadtime:0.96270489692688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.96275806427002 / seconds
Query Executed:select id FROM `ia` where city='Montpelier' && SIC_code='5541'DB:business_master_new
loadtime:0.96320390701294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.96325612068176 / seconds
Query Executed:select id FROM `ia` where city='Montrose' && SIC_code='5541'DB:business_master_new
loadtime:0.96401500701904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:0.96406698226929 / seconds
Query Executed:select id FROM `ia` where city='Moorhead' && SIC_code='5541'DB:business_master_new
loadtime:0.96497011184692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorland' limit 1
loadtime:0.96502304077148 / seconds
Query Executed:select id FROM `ia` where city='Moorland' && SIC_code='5541'DB:business_master_new
loadtime:0.96579003334045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravia' limit 1
loadtime:0.9658420085907 / seconds
Query Executed:select id FROM `ia` where city='Moravia' && SIC_code='5541'DB:business_master_new
loadtime:0.96727609634399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:0.96732997894287 / seconds
Query Executed:select id FROM `ia` where city='Morley' && SIC_code='5541'DB:business_master_new
loadtime:0.96781706809998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morning Sun' limit 1
loadtime:0.96786999702454 / seconds
Query Executed:select id FROM `ia` where city='Morning Sun' && SIC_code='5541'DB:business_master_new
loadtime:0.96936202049255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:0.96942806243896 / seconds
Query Executed:select id FROM `ia` where city='Morrison' && SIC_code='5541'DB:business_master_new
loadtime:0.96988606452942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.96994304656982 / seconds
Query Executed:select id FROM `ia` where city='Moscow' && SIC_code='5541'DB:business_master_new
loadtime:0.97056102752686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moulton' limit 1
loadtime:0.97061610221863 / seconds
Query Executed:select id FROM `ia` where city='Moulton' && SIC_code='5541'DB:business_master_new
loadtime:0.97149896621704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Auburn' limit 1
loadtime:0.97156596183777 / seconds
Query Executed:select id FROM `ia` where city='Mount Auburn' && SIC_code='5541'DB:business_master_new
loadtime:0.9721519947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ayr' limit 1
loadtime:0.97221302986145 / seconds
Query Executed:select id FROM `ia` where city='Mount Ayr' && SIC_code='5541'DB:business_master_new
loadtime:0.9747109413147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.97477793693542 / seconds
Query Executed:select id FROM `ia` where city='Mount Pleasant' && SIC_code='5541'DB:business_master_new
loadtime:0.98088788986206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:0.98095798492432 / seconds
Query Executed:select id FROM `ia` where city='Mount Sterling' && SIC_code='5541'DB:business_master_new
loadtime:0.9814920425415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Union' limit 1
loadtime:0.98154711723328 / seconds
Query Executed:select id FROM `ia` where city='Mount Union' && SIC_code='5541'DB:business_master_new
loadtime:0.98215889930725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.98221898078918 / seconds
Query Executed:select id FROM `ia` where city='Mount Vernon' && SIC_code='5541'DB:business_master_new
loadtime:0.98498797416687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moville' limit 1
loadtime:0.98505711555481 / seconds
Query Executed:select id FROM `ia` where city='Moville' && SIC_code='5541'DB:business_master_new
loadtime:0.98678803443909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Auburn' limit 1
loadtime:0.98685503005981 / seconds
Query Executed:select id FROM `ia` where city='Mt Auburn' && SIC_code='5541'DB:business_master_new
loadtime:0.98726797103882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ayr' limit 1
loadtime:0.98732089996338 / seconds
Query Executed:select id FROM `ia` where city='Mt Ayr' && SIC_code='5541'DB:business_master_new
loadtime:0.98773694038391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.98779010772705 / seconds
Query Executed:select id FROM `ia` where city='Mt Pleasant' && SIC_code='5541'DB:business_master_new
loadtime:0.98838400840759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:0.98843598365784 / seconds
Query Executed:select id FROM `ia` where city='Mt Sterling' && SIC_code='5541'DB:business_master_new
loadtime:0.98886108398438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Union' limit 1
loadtime:0.98891496658325 / seconds
Query Executed:select id FROM `ia` where city='Mt Union' && SIC_code='5541'DB:business_master_new
loadtime:0.98942494392395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.98947691917419 / seconds
Query Executed:select id FROM `ia` where city='Mt Vernon' && SIC_code='5541'DB:business_master_new
loadtime:0.98992490768433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:0.98997592926025 / seconds
Query Executed:select id FROM `ia` where city='Murray' && SIC_code='5541'DB:business_master_new
loadtime:0.99083709716797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscatine' limit 1
loadtime:0.99089002609253 / seconds
Query Executed:select id FROM `ia` where city='Muscatine' && SIC_code='5541'DB:business_master_new
loadtime:1.0012500286102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:1.0013220310211 / seconds
Query Executed:select id FROM `ia` where city='Mystic' && SIC_code='5541'DB:business_master_new
loadtime:1.0019750595093 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Buena Vista' limit 1
loadtime:1.0020298957825 / seconds
Query Executed:select id FROM `ia` where city='N Buena Vista' && SIC_code='5541'DB:business_master_new
loadtime:1.0024769306183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:1.0025310516357 / seconds
Query Executed:select id FROM `ia` where city='Nashua' && SIC_code='5541'DB:business_master_new
loadtime:1.0040159225464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemaha' limit 1
loadtime:1.0040819644928 / seconds
Query Executed:select id FROM `ia` where city='Nemaha' && SIC_code='5541'DB:business_master_new
loadtime:1.0048069953918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:1.0048611164093 / seconds
Query Executed:select id FROM `ia` where city='Neola' && SIC_code='5541'DB:business_master_new
loadtime:1.0059790611267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nevada' limit 1
loadtime:1.0060451030731 / seconds
Query Executed:select id FROM `ia` where city='Nevada' && SIC_code='5541'DB:business_master_new
loadtime:1.0096409320831 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albin' limit 1
loadtime:1.0097069740295 / seconds
Query Executed:select id FROM `ia` where city='New Albin' && SIC_code='5541'DB:business_master_new
loadtime:1.0105929374695 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:1.0106589794159 / seconds
Query Executed:select id FROM `ia` where city='New Hampton' && SIC_code='5541'DB:business_master_new
loadtime:1.0145189762115 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:1.0145950317383 / seconds
Query Executed:select id FROM `ia` where city='New Hartford' && SIC_code='5541'DB:business_master_new
loadtime:1.0154819488525 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Liberty' limit 1
loadtime:1.01553606987 / seconds
Query Executed:select id FROM `ia` where city='New Liberty' && SIC_code='5541'DB:business_master_new
loadtime:1.0162489414215 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:1.0163009166718 / seconds
Query Executed:select id FROM `ia` where city='New London' && SIC_code='5541'DB:business_master_new
loadtime:1.0180900096893 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:1.0181438922882 / seconds
Query Executed:select id FROM `ia` where city='New Market' && SIC_code='5541'DB:business_master_new
loadtime:1.0189759731293 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:1.0190289020538 / seconds
Query Executed:select id FROM `ia` where city='New Providence' && SIC_code='5541'DB:business_master_new
loadtime:1.0198249816895 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Sharon' limit 1
loadtime:1.0198769569397 / seconds
Query Executed:select id FROM `ia` where city='New Sharon' && SIC_code='5541'DB:business_master_new
loadtime:1.0215950012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vienna' limit 1
loadtime:1.0216479301453 / seconds
Query Executed:select id FROM `ia` where city='New Vienna' && SIC_code='5541'DB:business_master_new
loadtime:1.0226900577545 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Virginia' limit 1
loadtime:1.0227560997009 / seconds
Query Executed:select id FROM `ia` where city='New Virginia' && SIC_code='5541'DB:business_master_new
loadtime:1.0237131118774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:1.0237669944763 / seconds
Query Executed:select id FROM `ia` where city='Newell' && SIC_code='5541'DB:business_master_new
loadtime:1.0252459049225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhall' limit 1
loadtime:1.0252990722656 / seconds
Query Executed:select id FROM `ia` where city='Newhall' && SIC_code='5541'DB:business_master_new
loadtime:1.0262339115143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.0262999534607 / seconds
Query Executed:select id FROM `ia` where city='Newton' && SIC_code='5541'DB:business_master_new
loadtime:1.0341498851776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:1.0342330932617 / seconds
Query Executed:select id FROM `ia` where city='Nichols' && SIC_code='5541'DB:business_master_new
loadtime:1.0350260734558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nodaway' limit 1
loadtime:1.035080909729 / seconds
Query Executed:select id FROM `ia` where city='Nodaway' && SIC_code='5541'DB:business_master_new
loadtime:1.0357029438019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora Springs' limit 1
loadtime:1.035756111145 / seconds
Query Executed:select id FROM `ia` where city='Nora Springs' && SIC_code='5541'DB:business_master_new
loadtime:1.0372560024261 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Buena Vista' limit 1
loadtime:1.037309885025 / seconds
Query Executed:select id FROM `ia` where city='North Buena Vista' && SIC_code='5541'DB:business_master_new
loadtime:1.0378220081329 / seconds
Query loaded from cache:select * from geodata_geocity where city='North English' limit 1
loadtime:1.0378890037537 / seconds
Query Executed:select id FROM `ia` where city='North English' && SIC_code='5541'DB:business_master_new
loadtime:1.0392520427704 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Liberty' limit 1
loadtime:1.0393059253693 / seconds
Query Executed:select id FROM `ia` where city='North Liberty' && SIC_code='5541'DB:business_master_new
loadtime:1.0429539680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Washington' limit 1
loadtime:1.0430190563202 / seconds
Query Executed:select id FROM `ia` where city='North Washington' && SIC_code='5541'DB:business_master_new
loadtime:1.043445110321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northboro' limit 1
loadtime:1.0434999465942 / seconds
Query Executed:select id FROM `ia` where city='Northboro' && SIC_code='5541'DB:business_master_new
loadtime:1.0440230369568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:1.0440878868103 / seconds
Query Executed:select id FROM `ia` where city='Northwood' && SIC_code='5541'DB:business_master_new
loadtime:1.0466749668121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:1.0467300415039 / seconds
Query Executed:select id FROM `ia` where city='Norwalk' && SIC_code='5541'DB:business_master_new
loadtime:1.049712896347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:1.0497670173645 / seconds
Query Executed:select id FROM `ia` where city='Norway' && SIC_code='5541'DB:business_master_new
loadtime:1.0506861209869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Numa' limit 1
loadtime:1.0507531166077 / seconds
Query Executed:select id FROM `ia` where city='Numa' && SIC_code='5541'DB:business_master_new
loadtime:1.051206111908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:1.0512599945068 / seconds
Query Executed:select id FROM `ia` where city='Oakdale' && SIC_code='5541'DB:business_master_new
loadtime:1.0517420768738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:1.051794052124 / seconds
Query Executed:select id FROM `ia` where city='Oakland' && SIC_code='5541'DB:business_master_new
loadtime:1.0538070201874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:1.0538730621338 / seconds
Query Executed:select id FROM `ia` where city='Oakville' && SIC_code='5541'DB:business_master_new
loadtime:1.0546228885651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocheyedan' limit 1
loadtime:1.0546770095825 / seconds
Query Executed:select id FROM `ia` where city='Ocheyedan' && SIC_code='5541'DB:business_master_new
loadtime:1.0557570457458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odebolt' limit 1
loadtime:1.0558259487152 / seconds
Query Executed:select id FROM `ia` where city='Odebolt' && SIC_code='5541'DB:business_master_new
loadtime:1.0573270320892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelwein' limit 1
loadtime:1.0574169158936 / seconds
Query Executed:select id FROM `ia` where city='Oelwein' && SIC_code='5541'DB:business_master_new
loadtime:1.0614199638367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:1.0615830421448 / seconds
Query Executed:select id FROM `ia` where city='Ogden' && SIC_code='5541'DB:business_master_new
loadtime:1.06422996521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okoboji' limit 1
loadtime:1.0643260478973 / seconds
Query Executed:select id FROM `ia` where city='Okoboji' && SIC_code='5541'DB:business_master_new
loadtime:1.0658869743347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olds' limit 1
loadtime:1.0659461021423 / seconds
Query Executed:select id FROM `ia` where city='Olds' && SIC_code='5541'DB:business_master_new
loadtime:1.0665109157562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:1.0665650367737 / seconds
Query Executed:select id FROM `ia` where city='Olin' && SIC_code='5541'DB:business_master_new
loadtime:1.0676319599152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ollie' limit 1
loadtime:1.0676848888397 / seconds
Query Executed:select id FROM `ia` where city='Ollie' && SIC_code='5541'DB:business_master_new
loadtime:1.068372964859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onawa' limit 1
loadtime:1.0684270858765 / seconds
Query Executed:select id FROM `ia` where city='Onawa' && SIC_code='5541'DB:business_master_new
loadtime:1.0714249610901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onslow' limit 1
loadtime:1.0714979171753 / seconds
Query Executed:select id FROM `ia` where city='Onslow' && SIC_code='5541'DB:business_master_new
loadtime:1.072273015976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oran' limit 1
loadtime:1.0723268985748 / seconds
Query Executed:select id FROM `ia` where city='Oran' && SIC_code='5541'DB:business_master_new
loadtime:1.0728709697723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange City' limit 1
loadtime:1.0729238986969 / seconds
Query Executed:select id FROM `ia` where city='Orange City' && SIC_code='5541'DB:business_master_new
loadtime:1.0768859386444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:1.0769560337067 / seconds
Query Executed:select id FROM `ia` where city='Orchard' && SIC_code='5541'DB:business_master_new
loadtime:1.0775310993195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:1.0775849819183 / seconds
Query Executed:select id FROM `ia` where city='Orient' && SIC_code='5541'DB:business_master_new
loadtime:1.078460931778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage' limit 1
loadtime:1.0785279273987 / seconds
Query Executed:select id FROM `ia` where city='Osage' && SIC_code='5541'DB:business_master_new
loadtime:1.0822250843048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:1.0822920799255 / seconds
Query Executed:select id FROM `ia` where city='Osceola' && SIC_code='5541'DB:business_master_new
loadtime:1.0864999294281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oskaloosa' limit 1
loadtime:1.0865700244904 / seconds
Query Executed:select id FROM `ia` where city='Oskaloosa' && SIC_code='5541'DB:business_master_new
loadtime:1.0937530994415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossian' limit 1
loadtime:1.0938220024109 / seconds
Query Executed:select id FROM `ia` where city='Ossian' && SIC_code='5541'DB:business_master_new
loadtime:1.0955550670624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otho' limit 1
loadtime:1.0956099033356 / seconds
Query Executed:select id FROM `ia` where city='Otho' && SIC_code='5541'DB:business_master_new
loadtime:1.0962679386139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otley' limit 1
loadtime:1.096321105957 / seconds
Query Executed:select id FROM `ia` where city='Otley' && SIC_code='5541'DB:business_master_new
loadtime:1.0970289707184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oto' limit 1
loadtime:1.0970818996429 / seconds
Query Executed:select id FROM `ia` where city='Oto' && SIC_code='5541'DB:business_master_new
loadtime:1.0976688861847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottosen' limit 1
loadtime:1.0977230072021 / seconds
Query Executed:select id FROM `ia` where city='Ottosen' && SIC_code='5541'DB:business_master_new
loadtime:1.0983428955078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottumwa' limit 1
loadtime:1.0984001159668 / seconds
Query Executed:select id FROM `ia` where city='Ottumwa' && SIC_code='5541'DB:business_master_new
loadtime:1.103579044342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.1036601066589 / seconds
Query Executed:select id FROM `ia` where city='Oxford' && SIC_code='5541'DB:business_master_new
loadtime:1.1048519611359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford Junction' limit 1
loadtime:1.104907989502 / seconds
Query Executed:select id FROM `ia` where city='Oxford Junction' && SIC_code='5541'DB:business_master_new
loadtime:1.1057560443878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyens' limit 1
loadtime:1.1058089733124 / seconds
Query Executed:select id FROM `ia` where city='Oyens' && SIC_code='5541'DB:business_master_new
loadtime:1.1063559055328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific Junction' limit 1
loadtime:1.1064100265503 / seconds
Query Executed:select id FROM `ia` where city='Pacific Junction' && SIC_code='5541'DB:business_master_new
loadtime:1.1072559356689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwood' limit 1
loadtime:1.1073100566864 / seconds
Query Executed:select id FROM `ia` where city='Packwood' && SIC_code='5541'DB:business_master_new
loadtime:1.1079790592194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.1080310344696 / seconds
Query Executed:select id FROM `ia` where city='Palmer' && SIC_code='5541'DB:business_master_new
loadtime:1.1088829040527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:1.1089510917664 / seconds
Query Executed:select id FROM `ia` where city='Palo' && SIC_code='5541'DB:business_master_new
loadtime:1.1102180480957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panama' limit 1
loadtime:1.1102719306946 / seconds
Query Executed:select id FROM `ia` where city='Panama' && SIC_code='5541'DB:business_master_new
loadtime:1.1109919548035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panora' limit 1
loadtime:1.1110579967499 / seconds
Query Executed:select id FROM `ia` where city='Panora' && SIC_code='5541'DB:business_master_new
loadtime:1.1137390136719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkersburg' limit 1
loadtime:1.1137928962708 / seconds
Query Executed:select id FROM `ia` where city='Parkersburg' && SIC_code='5541'DB:business_master_new
loadtime:1.1154389381409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parnell' limit 1
loadtime:1.1155059337616 / seconds
Query Executed:select id FROM `ia` where city='Parnell' && SIC_code='5541'DB:business_master_new
loadtime:1.1161699295044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paton' limit 1
loadtime:1.1162440776825 / seconds
Query Executed:select id FROM `ia` where city='Paton' && SIC_code='5541'DB:business_master_new
loadtime:1.1171629428864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:1.1172249317169 / seconds
Query Executed:select id FROM `ia` where city='Patterson' && SIC_code='5541'DB:business_master_new
loadtime:1.1177051067352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paullina' limit 1
loadtime:1.1177589893341 / seconds
Query Executed:select id FROM `ia` where city='Paullina' && SIC_code='5541'DB:business_master_new
loadtime:1.1193509101868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pella' limit 1
loadtime:1.1194190979004 / seconds
Query Executed:select id FROM `ia` where city='Pella' && SIC_code='5541'DB:business_master_new
loadtime:1.1248230934143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peosta' limit 1
loadtime:1.124890089035 / seconds
Query Executed:select id FROM `ia` where city='Peosta' && SIC_code='5541'DB:business_master_new
loadtime:1.1268579959869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Percival' limit 1
loadtime:1.1269130706787 / seconds
Query Executed:select id FROM `ia` where city='Percival' && SIC_code='5541'DB:business_master_new
loadtime:1.1276340484619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:1.1277010440826 / seconds
Query Executed:select id FROM `ia` where city='Perry' && SIC_code='5541'DB:business_master_new
loadtime:1.1315240859985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Persia' limit 1
loadtime:1.1315910816193 / seconds
Query Executed:select id FROM `ia` where city='Persia' && SIC_code='5541'DB:business_master_new
loadtime:1.132297039032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:1.1323509216309 / seconds
Query Executed:select id FROM `ia` where city='Peru' && SIC_code='5541'DB:business_master_new
loadtime:1.1329140663147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson' limit 1
loadtime:1.1329669952393 / seconds
Query Executed:select id FROM `ia` where city='Peterson' && SIC_code='5541'DB:business_master_new
loadtime:1.1339409351349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:1.1340088844299 / seconds
Query Executed:select id FROM `ia` where city='Pierson' && SIC_code='5541'DB:business_master_new
loadtime:1.1347990036011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Grove' limit 1
loadtime:1.1348540782928 / seconds
Query Executed:select id FROM `ia` where city='Pilot Grove' && SIC_code='5541'DB:business_master_new
loadtime:1.1353440284729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mound' limit 1
loadtime:1.1354010105133 / seconds
Query Executed:select id FROM `ia` where city='Pilot Mound' && SIC_code='5541'DB:business_master_new
loadtime:1.1359689235687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah' limit 1
loadtime:1.1360330581665 / seconds
Query Executed:select id FROM `ia` where city='Pisgah' && SIC_code='5541'DB:business_master_new
loadtime:1.136745929718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.1368010044098 / seconds
Query Executed:select id FROM `ia` where city='Plainfield' && SIC_code='5541'DB:business_master_new
loadtime:1.1376900672913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plano' limit 1
loadtime:1.1377549171448 / seconds
Query Executed:select id FROM `ia` where city='Plano' && SIC_code='5541'DB:business_master_new
loadtime:1.1384220123291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:1.138482093811 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Hill' && SIC_code='5541'DB:business_master_new
loadtime:1.141242980957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:1.1412959098816 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.141891002655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasanton' limit 1
loadtime:1.1419570446014 / seconds
Query Executed:select id FROM `ia` where city='Pleasanton' && SIC_code='5541'DB:business_master_new
loadtime:1.142410993576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:1.1424660682678 / seconds
Query Executed:select id FROM `ia` where city='Pleasantville' && SIC_code='5541'DB:business_master_new
loadtime:1.144278049469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:1.1443428993225 / seconds
Query Executed:select id FROM `ia` where city='Plover' && SIC_code='5541'DB:business_master_new
loadtime:1.1448640823364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.1449160575867 / seconds
Query Executed:select id FROM `ia` where city='Plymouth' && SIC_code='5541'DB:business_master_new
loadtime:1.1456570625305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:1.1457099914551 / seconds
Query Executed:select id FROM `ia` where city='Pocahontas' && SIC_code='5541'DB:business_master_new
loadtime:1.1483030319214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polk City' limit 1
loadtime:1.1483619213104 / seconds
Query Executed:select id FROM `ia` where city='Polk City' && SIC_code='5541'DB:business_master_new
loadtime:1.1501009464264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomeroy' limit 1
loadtime:1.1501541137695 / seconds
Query Executed:select id FROM `ia` where city='Pomeroy' && SIC_code='5541'DB:business_master_new
loadtime:1.1511681079865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Popejoy' limit 1
loadtime:1.1512439250946 / seconds
Query Executed:select id FROM `ia` where city='Popejoy' && SIC_code='5541'DB:business_master_new
loadtime:1.1517260074615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:1.1517789363861 / seconds
Query Executed:select id FROM `ia` where city='Portsmouth' && SIC_code='5541'DB:business_master_new
loadtime:1.1524739265442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Postville' limit 1
loadtime:1.1525270938873 / seconds
Query Executed:select id FROM `ia` where city='Postville' && SIC_code='5541'DB:business_master_new
loadtime:1.1550679206848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:1.1551330089569 / seconds
Query Executed:select id FROM `ia` where city='Prairie City' && SIC_code='5541'DB:business_master_new
loadtime:1.1562550067902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairieburg' limit 1
loadtime:1.1563100814819 / seconds
Query Executed:select id FROM `ia` where city='Prairieburg' && SIC_code='5541'DB:business_master_new
loadtime:1.1568789482117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:1.1569321155548 / seconds
Query Executed:select id FROM `ia` where city='Prescott' && SIC_code='5541'DB:business_master_new
loadtime:1.1577579975128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:1.1578109264374 / seconds
Query Executed:select id FROM `ia` where city='Preston' && SIC_code='5541'DB:business_master_new
loadtime:1.159276008606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Primghar' limit 1
loadtime:1.1593430042267 / seconds
Query Executed:select id FROM `ia` where city='Primghar' && SIC_code='5541'DB:business_master_new
loadtime:1.1610629558563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.1611299514771 / seconds
Query Executed:select id FROM `ia` where city='Princeton' && SIC_code='5541'DB:business_master_new
loadtime:1.1619911193848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prole' limit 1
loadtime:1.1620450019836 / seconds
Query Executed:select id FROM `ia` where city='Prole' && SIC_code='5541'DB:business_master_new
loadtime:1.1627991199493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Promise City' limit 1
loadtime:1.1628520488739 / seconds
Query Executed:select id FROM `ia` where city='Promise City' && SIC_code='5541'DB:business_master_new
loadtime:1.1633939743042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Protivin' limit 1
loadtime:1.1634459495544 / seconds
Query Executed:select id FROM `ia` where city='Protivin' && SIC_code='5541'DB:business_master_new
loadtime:1.1640450954437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:1.1641089916229 / seconds
Query Executed:select id FROM `ia` where city='Pulaski' && SIC_code='5541'DB:business_master_new
loadtime:1.1647570133209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quasqueton' limit 1
loadtime:1.1648108959198 / seconds
Query Executed:select id FROM `ia` where city='Quasqueton' && SIC_code='5541'DB:business_master_new
loadtime:1.1654489040375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quimby' limit 1
loadtime:1.1655011177063 / seconds
Query Executed:select id FROM `ia` where city='Quimby' && SIC_code='5541'DB:business_master_new
loadtime:1.16623711586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radcliffe' limit 1
loadtime:1.1663019657135 / seconds
Query Executed:select id FROM `ia` where city='Radcliffe' && SIC_code='5541'DB:business_master_new
loadtime:1.1674330234528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rake' limit 1
loadtime:1.1674981117249 / seconds
Query Executed:select id FROM `ia` where city='Rake' && SIC_code='5541'DB:business_master_new
loadtime:1.1683130264282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralston' limit 1
loadtime:1.1683709621429 / seconds
Query Executed:select id FROM `ia` where city='Ralston' && SIC_code='5541'DB:business_master_new
loadtime:1.1688311100006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randalia' limit 1
loadtime:1.168881893158 / seconds
Query Executed:select id FROM `ia` where city='Randalia' && SIC_code='5541'DB:business_master_new
loadtime:1.1694519519806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randall' limit 1
loadtime:1.1695039272308 / seconds
Query Executed:select id FROM `ia` where city='Randall' && SIC_code='5541'DB:business_master_new
loadtime:1.1700189113617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.1700689792633 / seconds
Query Executed:select id FROM `ia` where city='Randolph' && SIC_code='5541'DB:business_master_new
loadtime:1.1706559658051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.1707079410553 / seconds
Query Executed:select id FROM `ia` where city='Raymond' && SIC_code='5541'DB:business_master_new
loadtime:1.1713140010834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readlyn' limit 1
loadtime:1.1713700294495 / seconds
Query Executed:select id FROM `ia` where city='Readlyn' && SIC_code='5541'DB:business_master_new
loadtime:1.1728599071503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reasnor' limit 1
loadtime:1.1729121208191 / seconds
Query Executed:select id FROM `ia` where city='Reasnor' && SIC_code='5541'DB:business_master_new
loadtime:1.1736080646515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:1.1736600399017 / seconds
Query Executed:select id FROM `ia` where city='Red Oak' && SIC_code='5541'DB:business_master_new
loadtime:1.178092956543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:1.1781659126282 / seconds
Query Executed:select id FROM `ia` where city='Redding' && SIC_code='5541'DB:business_master_new
loadtime:1.1787331104279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:1.1787860393524 / seconds
Query Executed:select id FROM `ia` where city='Redfield' && SIC_code='5541'DB:business_master_new
loadtime:1.1795589923859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reinbeck' limit 1
loadtime:1.1796131134033 / seconds
Query Executed:select id FROM `ia` where city='Reinbeck' && SIC_code='5541'DB:business_master_new
loadtime:1.1811549663544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembrandt' limit 1
loadtime:1.1812169551849 / seconds
Query Executed:select id FROM `ia` where city='Rembrandt' && SIC_code='5541'DB:business_master_new
loadtime:1.1819128990173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remsen' limit 1
loadtime:1.1819651126862 / seconds
Query Executed:select id FROM `ia` where city='Remsen' && SIC_code='5541'DB:business_master_new
loadtime:1.1846261024475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renwick' limit 1
loadtime:1.1846969127655 / seconds
Query Executed:select id FROM `ia` where city='Renwick' && SIC_code='5541'DB:business_master_new
loadtime:1.1854200363159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:1.1854739189148 / seconds
Query Executed:select id FROM `ia` where city='Rhodes' && SIC_code='5541'DB:business_master_new
loadtime:1.1860899925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riceville' limit 1
loadtime:1.1861538887024 / seconds
Query Executed:select id FROM `ia` where city='Riceville' && SIC_code='5541'DB:business_master_new
loadtime:1.1880719661713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:1.1881380081177 / seconds
Query Executed:select id FROM `ia` where city='Richland' && SIC_code='5541'DB:business_master_new
loadtime:1.1891150474548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ricketts' limit 1
loadtime:1.1891679763794 / seconds
Query Executed:select id FROM `ia` where city='Ricketts' && SIC_code='5541'DB:business_master_new
loadtime:1.189649105072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:1.1897029876709 / seconds
Query Executed:select id FROM `ia` where city='Ridgeway' && SIC_code='5541'DB:business_master_new
loadtime:1.1906011104584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringsted' limit 1
loadtime:1.1906681060791 / seconds
Query Executed:select id FROM `ia` where city='Ringsted' && SIC_code='5541'DB:business_master_new
loadtime:1.1916260719299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rippey' limit 1
loadtime:1.1916799545288 / seconds
Query Executed:select id FROM `ia` where city='Rippey' && SIC_code='5541'DB:business_master_new
loadtime:1.1923890113831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:1.1924419403076 / seconds
Query Executed:select id FROM `ia` where city='Riverdale' && SIC_code='5541'DB:business_master_new
loadtime:1.1929380893707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:1.1929891109467 / seconds
Query Executed:select id FROM `ia` where city='Riverside' && SIC_code='5541'DB:business_master_new
loadtime:1.1948640346527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:1.1949300765991 / seconds
Query Executed:select id FROM `ia` where city='Riverton' && SIC_code='5541'DB:business_master_new
loadtime:1.1954751014709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robins' limit 1
loadtime:1.1955289840698 / seconds
Query Executed:select id FROM `ia` where city='Robins' && SIC_code='5541'DB:business_master_new
loadtime:1.1963090896606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:1.196368932724 / seconds
Query Executed:select id FROM `ia` where city='Rock Falls' && SIC_code='5541'DB:business_master_new
loadtime:1.19690990448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Rapids' limit 1
loadtime:1.1969621181488 / seconds
Query Executed:select id FROM `ia` where city='Rock Rapids' && SIC_code='5541'DB:business_master_new
loadtime:1.1998529434204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Valley' limit 1
loadtime:1.1999061107635 / seconds
Query Executed:select id FROM `ia` where city='Rock Valley' && SIC_code='5541'DB:business_master_new
loadtime:1.2031450271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:1.2032239437103 / seconds
Query Executed:select id FROM `ia` where city='Rockford' && SIC_code='5541'DB:business_master_new
loadtime:1.2049989700317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:1.2050669193268 / seconds
Query Executed:select id FROM `ia` where city='Rockwell' && SIC_code='5541'DB:business_master_new
loadtime:1.2063889503479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell City' limit 1
loadtime:1.2064440250397 / seconds
Query Executed:select id FROM `ia` where city='Rockwell City' && SIC_code='5541'DB:business_master_new
loadtime:1.2090570926666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:1.2091240882874 / seconds
Query Executed:select id FROM `ia` where city='Rodney' && SIC_code='5541'DB:business_master_new
loadtime:1.209625005722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roland' limit 1
loadtime:1.2096788883209 / seconds
Query Executed:select id FROM `ia` where city='Roland' && SIC_code='5541'DB:business_master_new
loadtime:1.2105250358582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolfe' limit 1
loadtime:1.210578918457 / seconds
Query Executed:select id FROM `ia` where city='Rolfe' && SIC_code='5541'DB:business_master_new
loadtime:1.2116000652313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:1.2116520404816 / seconds
Query Executed:select id FROM `ia` where city='Rome' && SIC_code='5541'DB:business_master_new
loadtime:1.2121350765228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:1.2121961116791 / seconds
Query Executed:select id FROM `ia` where city='Rose Hill' && SIC_code='5541'DB:business_master_new
loadtime:1.2128269672394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowan' limit 1
loadtime:1.2128798961639 / seconds
Query Executed:select id FROM `ia` where city='Rowan' && SIC_code='5541'DB:business_master_new
loadtime:1.2135150432587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:1.2135679721832 / seconds
Query Executed:select id FROM `ia` where city='Rowley' && SIC_code='5541'DB:business_master_new
loadtime:1.2143170833588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal' limit 1
loadtime:1.2143740653992 / seconds
Query Executed:select id FROM `ia` where city='Royal' && SIC_code='5541'DB:business_master_new
loadtime:1.2152390480042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudd' limit 1
loadtime:1.215292930603 / seconds
Query Executed:select id FROM `ia` where city='Rudd' && SIC_code='5541'DB:business_master_new
loadtime:1.2162849903107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnells' limit 1
loadtime:1.2163369655609 / seconds
Query Executed:select id FROM `ia` where city='Runnells' && SIC_code='5541'DB:business_master_new
loadtime:1.2176439762115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:1.2176969051361 / seconds
Query Executed:select id FROM `ia` where city='Russell' && SIC_code='5541'DB:business_master_new
loadtime:1.2184710502625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthven' limit 1
loadtime:1.2185258865356 / seconds
Query Executed:select id FROM `ia` where city='Ruthven' && SIC_code='5541'DB:business_master_new
loadtime:1.2197940349579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:1.2198600769043 / seconds
Query Executed:select id FROM `ia` where city='Rutland' && SIC_code='5541'DB:business_master_new
loadtime:1.2203810214996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryan' limit 1
loadtime:1.2204349040985 / seconds
Query Executed:select id FROM `ia` where city='Ryan' && SIC_code='5541'DB:business_master_new
loadtime:1.2212390899658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sabula' limit 1
loadtime:1.2212910652161 / seconds
Query Executed:select id FROM `ia` where city='Sabula' && SIC_code='5541'DB:business_master_new
loadtime:1.2222020626068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sac City' limit 1
loadtime:1.2222540378571 / seconds
Query Executed:select id FROM `ia` where city='Sac City' && SIC_code='5541'DB:business_master_new
loadtime:1.2251999378204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ansgar' limit 1
loadtime:1.2252531051636 / seconds
Query Executed:select id FROM `ia` where city='Saint Ansgar' && SIC_code='5541'DB:business_master_new
loadtime:1.2272899150848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Anthony' limit 1
loadtime:1.2273440361023 / seconds
Query Executed:select id FROM `ia` where city='Saint Anthony' && SIC_code='5541'DB:business_master_new
loadtime:1.227961063385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:1.2280120849609 / seconds
Query Executed:select id FROM `ia` where city='Saint Charles' && SIC_code='5541'DB:business_master_new
loadtime:1.2292380332947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Donatus' limit 1
loadtime:1.2292900085449 / seconds
Query Executed:select id FROM `ia` where city='Saint Donatus' && SIC_code='5541'DB:business_master_new
loadtime:1.2298269271851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Marys' limit 1
loadtime:1.2298800945282 / seconds
Query Executed:select id FROM `ia` where city='Saint Marys' && SIC_code='5541'DB:business_master_new
loadtime:1.2304480075836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Olaf' limit 1
loadtime:1.2305009365082 / seconds
Query Executed:select id FROM `ia` where city='Saint Olaf' && SIC_code='5541'DB:business_master_new
loadtime:1.2311611175537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:1.2312200069427 / seconds
Query Executed:select id FROM `ia` where city='Saint Paul' && SIC_code='5541'DB:business_master_new
loadtime:1.2317600250244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.2318120002747 / seconds
Query Executed:select id FROM `ia` where city='Salem' && SIC_code='5541'DB:business_master_new
loadtime:1.2326760292053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salix' limit 1
loadtime:1.2327420711517 / seconds
Query Executed:select id FROM `ia` where city='Salix' && SIC_code='5541'DB:business_master_new
loadtime:1.2336840629578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanborn' limit 1
loadtime:1.2337510585785 / seconds
Query Executed:select id FROM `ia` where city='Sanborn' && SIC_code='5541'DB:business_master_new
loadtime:1.2357869148254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scarville' limit 1
loadtime:1.2358419895172 / seconds
Query Executed:select id FROM `ia` where city='Scarville' && SIC_code='5541'DB:business_master_new
loadtime:1.2365229129791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schaller' limit 1
loadtime:1.2365760803223 / seconds
Query Executed:select id FROM `ia` where city='Schaller' && SIC_code='5541'DB:business_master_new
loadtime:1.2378380298615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schleswig' limit 1
loadtime:1.2378919124603 / seconds
Query Executed:select id FROM `ia` where city='Schleswig' && SIC_code='5541'DB:business_master_new
loadtime:1.2389869689941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Grove' limit 1
loadtime:1.2390398979187 / seconds
Query Executed:select id FROM `ia` where city='Scotch Grove' && SIC_code='5541'DB:business_master_new
loadtime:1.2395389080048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:1.2395920753479 / seconds
Query Executed:select id FROM `ia` where city='Scranton' && SIC_code='5541'DB:business_master_new
loadtime:1.2410159111023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Searsboro' limit 1
loadtime:1.2410690784454 / seconds
Query Executed:select id FROM `ia` where city='Searsboro' && SIC_code='5541'DB:business_master_new
loadtime:1.2416961193085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:1.241749048233 / seconds
Query Executed:select id FROM `ia` where city='Selma' && SIC_code='5541'DB:business_master_new
loadtime:1.2422559261322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeant Bluff' limit 1
loadtime:1.2423090934753 / seconds
Query Executed:select id FROM `ia` where city='Sergeant Bluff' && SIC_code='5541'DB:business_master_new
loadtime:1.2445969581604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:1.2446639537811 / seconds
Query Executed:select id FROM `ia` where city='Seymour' && SIC_code='5541'DB:business_master_new
loadtime:1.2455449104309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shambaugh' limit 1
loadtime:1.245598077774 / seconds
Query Executed:select id FROM `ia` where city='Shambaugh' && SIC_code='5541'DB:business_master_new
loadtime:1.2460460662842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon City' limit 1
loadtime:1.2460980415344 / seconds
Query Executed:select id FROM `ia` where city='Shannon City' && SIC_code='5541'DB:business_master_new
loadtime:1.2466330528259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:1.2466859817505 / seconds
Query Executed:select id FROM `ia` where city='Sharpsburg' && SIC_code='5541'DB:business_master_new
loadtime:1.2471449375153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:1.2472040653229 / seconds
Query Executed:select id FROM `ia` where city='Sheffield' && SIC_code='5541'DB:business_master_new
loadtime:1.2489860057831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:1.2490510940552 / seconds
Query Executed:select id FROM `ia` where city='Shelby' && SIC_code='5541'DB:business_master_new
loadtime:1.2504470348358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldahl' limit 1
loadtime:1.2505140304565 / seconds
Query Executed:select id FROM `ia` where city='Sheldahl' && SIC_code='5541'DB:business_master_new
loadtime:1.250981092453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:1.2510349750519 / seconds
Query Executed:select id FROM `ia` where city='Sheldon' && SIC_code='5541'DB:business_master_new
loadtime:1.2549939155579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Rock' limit 1
loadtime:1.2550630569458 / seconds
Query Executed:select id FROM `ia` where city='Shell Rock' && SIC_code='5541'DB:business_master_new
loadtime:1.256364107132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shellsburg' limit 1
loadtime:1.2564249038696 / seconds
Query Executed:select id FROM `ia` where city='Shellsburg' && SIC_code='5541'DB:business_master_new
loadtime:1.2576050758362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:1.2576580047607 / seconds
Query Executed:select id FROM `ia` where city='Shenandoah' && SIC_code='5541'DB:business_master_new
loadtime:1.2618029117584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrill' limit 1
loadtime:1.2618720531464 / seconds
Query Executed:select id FROM `ia` where city='Sherrill' && SIC_code='5541'DB:business_master_new
loadtime:1.2629420757294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:1.2629959583282 / seconds
Query Executed:select id FROM `ia` where city='Sibley' && SIC_code='5541'DB:business_master_new
loadtime:1.2658550739288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:1.2659211158752 / seconds
Query Executed:select id FROM `ia` where city='Sidney' && SIC_code='5541'DB:business_master_new
loadtime:1.2677218914032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigourney' limit 1
loadtime:1.267776966095 / seconds
Query Executed:select id FROM `ia` where city='Sigourney' && SIC_code='5541'DB:business_master_new
loadtime:1.2705190181732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:1.2705719470978 / seconds
Query Executed:select id FROM `ia` where city='Silver City' && SIC_code='5541'DB:business_master_new
loadtime:1.2712919712067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Center' limit 1
loadtime:1.2713439464569 / seconds
Query Executed:select id FROM `ia` where city='Sioux Center' && SIC_code='5541'DB:business_master_new
loadtime:1.2758901119232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux City' limit 1
loadtime:1.2759590148926 / seconds
Query Executed:select id FROM `ia` where city='Sioux City' && SIC_code='5541'DB:business_master_new
loadtime:1.2811360359192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Rapids' limit 1
loadtime:1.281229019165 / seconds
Query Executed:select id FROM `ia` where city='Sioux Rapids' && SIC_code='5541'DB:business_master_new
loadtime:1.2824599742889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:1.2825291156769 / seconds
Query Executed:select id FROM `ia` where city='Slater' && SIC_code='5541'DB:business_master_new
loadtime:1.283597946167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sloan' limit 1
loadtime:1.283665895462 / seconds
Query Executed:select id FROM `ia` where city='Sloan' && SIC_code='5541'DB:business_master_new
loadtime:1.2848739624023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithland' limit 1
loadtime:1.2849290370941 / seconds
Query Executed:select id FROM `ia` where city='Smithland' && SIC_code='5541'DB:business_master_new
loadtime:1.2856130599976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldier' limit 1
loadtime:1.2856779098511 / seconds
Query Executed:select id FROM `ia` where city='Soldier' && SIC_code='5541'DB:business_master_new
loadtime:1.2864179611206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon' limit 1
loadtime:1.286484003067 / seconds
Query Executed:select id FROM `ia` where city='Solon' && SIC_code='5541'DB:business_master_new
loadtime:1.2884080410004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:1.2884619235992 / seconds
Query Executed:select id FROM `ia` where city='Somers' && SIC_code='5541'DB:business_master_new
loadtime:1.2890980243683 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amana' limit 1
loadtime:1.2891490459442 / seconds
Query Executed:select id FROM `ia` where city='South Amana' && SIC_code='5541'DB:business_master_new
loadtime:1.2898108959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='South English' limit 1
loadtime:1.2898759841919 / seconds
Query Executed:select id FROM `ia` where city='South English' && SIC_code='5541'DB:business_master_new
loadtime:1.2906799316406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:1.290745973587 / seconds
Query Executed:select id FROM `ia` where city='Spencer' && SIC_code='5541'DB:business_master_new
loadtime:1.2984640598297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperry' limit 1
loadtime:1.2985310554504 / seconds
Query Executed:select id FROM `ia` where city='Sperry' && SIC_code='5541'DB:business_master_new
loadtime:1.2993309497833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spillville' limit 1
loadtime:1.299388885498 / seconds
Query Executed:select id FROM `ia` where city='Spillville' && SIC_code='5541'DB:business_master_new
loadtime:1.3000149726868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spirit Lake' limit 1
loadtime:1.300066947937 / seconds
Query Executed:select id FROM `ia` where city='Spirit Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.3057289123535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spragueville' limit 1
loadtime:1.3057980537415 / seconds
Query Executed:select id FROM `ia` where city='Spragueville' && SIC_code='5541'DB:business_master_new
loadtime:1.3065130710602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:1.3065679073334 / seconds
Query Executed:select id FROM `ia` where city='Springbrook' && SIC_code='5541'DB:business_master_new
loadtime:1.3071100711823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:1.3071630001068 / seconds
Query Executed:select id FROM `ia` where city='Springville' && SIC_code='5541'DB:business_master_new
loadtime:1.3085141181946 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ansgar' limit 1
loadtime:1.3085799217224 / seconds
Query Executed:select id FROM `ia` where city='St Ansgar' && SIC_code='5541'DB:business_master_new
loadtime:1.3090798854828 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Anthony' limit 1
loadtime:1.3091320991516 / seconds
Query Executed:select id FROM `ia` where city='St Anthony' && SIC_code='5541'DB:business_master_new
loadtime:1.3096148967743 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:1.3096671104431 / seconds
Query Executed:select id FROM `ia` where city='St Charles' && SIC_code='5541'DB:business_master_new
loadtime:1.3101589679718 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Donatus' limit 1
loadtime:1.3102200031281 / seconds
Query Executed:select id FROM `ia` where city='St Donatus' && SIC_code='5541'DB:business_master_new
loadtime:1.310714006424 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lucas' limit 1
loadtime:1.3107678890228 / seconds
Query Executed:select id FROM `ia` where city='St Lucas' && SIC_code='5541'DB:business_master_new
loadtime:1.3112471103668 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Marys' limit 1
loadtime:1.3112990856171 / seconds
Query Executed:select id FROM `ia` where city='St Marys' && SIC_code='5541'DB:business_master_new
loadtime:1.3117709159851 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Olaf' limit 1
loadtime:1.3118278980255 / seconds
Query Executed:select id FROM `ia` where city='St Olaf' && SIC_code='5541'DB:business_master_new
loadtime:1.3123180866241 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:1.3123741149902 / seconds
Query Executed:select id FROM `ia` where city='St Paul' && SIC_code='5541'DB:business_master_new
loadtime:1.3128480911255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacyville' limit 1
loadtime:1.31290102005 / seconds
Query Executed:select id FROM `ia` where city='Stacyville' && SIC_code='5541'DB:business_master_new
loadtime:1.313863992691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:1.3139309883118 / seconds
Query Executed:select id FROM `ia` where city='Stanhope' && SIC_code='5541'DB:business_master_new
loadtime:1.3147699832916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:1.3148229122162 / seconds
Query Executed:select id FROM `ia` where city='Stanley' && SIC_code='5541'DB:business_master_new
loadtime:1.3154129981995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:1.3154649734497 / seconds
Query Executed:select id FROM `ia` where city='Stanton' && SIC_code='5541'DB:business_master_new
loadtime:1.3166439533234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:1.3167109489441 / seconds
Query Executed:select id FROM `ia` where city='Stanwood' && SIC_code='5541'DB:business_master_new
loadtime:1.3175189495087 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Center' limit 1
loadtime:1.3175730705261 / seconds
Query Executed:select id FROM `ia` where city='State Center' && SIC_code='5541'DB:business_master_new
loadtime:1.3193230628967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Rock' limit 1
loadtime:1.3193790912628 / seconds
Query Executed:select id FROM `ia` where city='Steamboat Rock' && SIC_code='5541'DB:business_master_new
loadtime:1.3201448917389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockport' limit 1
loadtime:1.3202059268951 / seconds
Query Executed:select id FROM `ia` where city='Stockport' && SIC_code='5541'DB:business_master_new
loadtime:1.3210608959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:1.3211131095886 / seconds
Query Executed:select id FROM `ia` where city='Stockton' && SIC_code='5541'DB:business_master_new
loadtime:1.3218500614166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storm Lake' limit 1
loadtime:1.3219020366669 / seconds
Query Executed:select id FROM `ia` where city='Storm Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.3281729221344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Story City' limit 1
loadtime:1.3282489776611 / seconds
Query Executed:select id FROM `ia` where city='Story City' && SIC_code='5541'DB:business_master_new
loadtime:1.3311400413513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stout' limit 1
loadtime:1.3312170505524 / seconds
Query Executed:select id FROM `ia` where city='Stout' && SIC_code='5541'DB:business_master_new
loadtime:1.3317530155182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:1.3318059444427 / seconds
Query Executed:select id FROM `ia` where city='Stratford' && SIC_code='5541'DB:business_master_new
loadtime:1.333065032959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry Point' limit 1
loadtime:1.3331179618835 / seconds
Query Executed:select id FROM `ia` where city='Strawberry Point' && SIC_code='5541'DB:business_master_new
loadtime:1.334862947464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:1.3349289894104 / seconds
Query Executed:select id FROM `ia` where city='Stuart' && SIC_code='5541'DB:business_master_new
loadtime:1.3365519046783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sully' limit 1
loadtime:1.336620092392 / seconds
Query Executed:select id FROM `ia` where city='Sully' && SIC_code='5541'DB:business_master_new
loadtime:1.3380229473114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:1.3380761146545 / seconds
Query Executed:select id FROM `ia` where city='Sumner' && SIC_code='5541'DB:business_master_new
loadtime:1.3409099578857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:1.3409640789032 / seconds
Query Executed:select id FROM `ia` where city='Superior' && SIC_code='5541'DB:business_master_new
loadtime:1.3415269851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:1.341579914093 / seconds
Query Executed:select id FROM `ia` where city='Sutherland' && SIC_code='5541'DB:business_master_new
loadtime:1.3428099155426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swaledale' limit 1
loadtime:1.3428618907928 / seconds
Query Executed:select id FROM `ia` where city='Swaledale' && SIC_code='5541'DB:business_master_new
loadtime:1.3435258865356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan' limit 1
loadtime:1.3435781002045 / seconds
Query Executed:select id FROM `ia` where city='Swan' && SIC_code='5541'DB:business_master_new
loadtime:1.344034910202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swea City' limit 1
loadtime:1.3440868854523 / seconds
Query Executed:select id FROM `ia` where city='Swea City' && SIC_code='5541'DB:business_master_new
loadtime:1.3451590538025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesburg' limit 1
loadtime:1.3452210426331 / seconds
Query Executed:select id FROM `ia` where city='Swedesburg' && SIC_code='5541'DB:business_master_new
loadtime:1.3457539081573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swisher' limit 1
loadtime:1.3458080291748 / seconds
Query Executed:select id FROM `ia` where city='Swisher' && SIC_code='5541'DB:business_master_new
loadtime:1.3473219871521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:1.3473780155182 / seconds
Query Executed:select id FROM `ia` where city='Tabor' && SIC_code='5541'DB:business_master_new
loadtime:1.3483159542084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taintor' limit 1
loadtime:1.3483729362488 / seconds
Query Executed:select id FROM `ia` where city='Taintor' && SIC_code='5541'DB:business_master_new
loadtime:1.3488140106201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tama' limit 1
loadtime:1.3488659858704 / seconds
Query Executed:select id FROM `ia` where city='Tama' && SIC_code='5541'DB:business_master_new
loadtime:1.3512120246887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teeds Grove' limit 1
loadtime:1.3512780666351 / seconds
Query Executed:select id FROM `ia` where city='Teeds Grove' && SIC_code='5541'DB:business_master_new
loadtime:1.3517329692841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:1.3517870903015 / seconds
Query Executed:select id FROM `ia` where city='Templeton' && SIC_code='5541'DB:business_master_new
loadtime:1.3526771068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennant' limit 1
loadtime:1.3527460098267 / seconds
Query Executed:select id FROM `ia` where city='Tennant' && SIC_code='5541'DB:business_master_new
loadtime:1.353178024292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terril' limit 1
loadtime:1.3532400131226 / seconds
Query Executed:select id FROM `ia` where city='Terril' && SIC_code='5541'DB:business_master_new
loadtime:1.3541390895844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thayer' limit 1
loadtime:1.3542139530182 / seconds
Query Executed:select id FROM `ia` where city='Thayer' && SIC_code='5541'DB:business_master_new
loadtime:1.3547561168671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:1.3548099994659 / seconds
Query Executed:select id FROM `ia` where city='Thompson' && SIC_code='5541'DB:business_master_new
loadtime:1.3558340072632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thor' limit 1
loadtime:1.3558869361877 / seconds
Query Executed:select id FROM `ia` where city='Thor' && SIC_code='5541'DB:business_master_new
loadtime:1.356565952301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:1.3566191196442 / seconds
Query Executed:select id FROM `ia` where city='Thornburg' && SIC_code='5541'DB:business_master_new
loadtime:1.3571019172668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:1.3571579456329 / seconds
Query Executed:select id FROM `ia` where city='Thornton' && SIC_code='5541'DB:business_master_new
loadtime:1.3580410480499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurman' limit 1
loadtime:1.3580939769745 / seconds
Query Executed:select id FROM `ia` where city='Thurman' && SIC_code='5541'DB:business_master_new
loadtime:1.3587799072266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiffin' limit 1
loadtime:1.3588449954987 / seconds
Query Executed:select id FROM `ia` where city='Tiffin' && SIC_code='5541'DB:business_master_new
loadtime:1.3596549034119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tingley' limit 1
loadtime:1.359719991684 / seconds
Query Executed:select id FROM `ia` where city='Tingley' && SIC_code='5541'DB:business_master_new
loadtime:1.3602828979492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:1.3603489398956 / seconds
Query Executed:select id FROM `ia` where city='Tipton' && SIC_code='5541'DB:business_master_new
loadtime:1.3640110492706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titonka' limit 1
loadtime:1.3640649318695 / seconds
Query Executed:select id FROM `ia` where city='Titonka' && SIC_code='5541'DB:business_master_new
loadtime:1.3652091026306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toddville' limit 1
loadtime:1.3652629852295 / seconds
Query Executed:select id FROM `ia` where city='Toddville' && SIC_code='5541'DB:business_master_new
loadtime:1.3660469055176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toeterville' limit 1
loadtime:1.3661000728607 / seconds
Query Executed:select id FROM `ia` where city='Toeterville' && SIC_code='5541'DB:business_master_new
loadtime:1.3665950298309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toledo' limit 1
loadtime:1.3666479587555 / seconds
Query Executed:select id FROM `ia` where city='Toledo' && SIC_code='5541'DB:business_master_new
loadtime:1.3690159320831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:1.3690869808197 / seconds
Query Executed:select id FROM `ia` where city='Toronto' && SIC_code='5541'DB:business_master_new
loadtime:1.3695709705353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tracy' limit 1
loadtime:1.3696238994598 / seconds
Query Executed:select id FROM `ia` where city='Tracy' && SIC_code='5541'DB:business_master_new
loadtime:1.3702189922333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traer' limit 1
loadtime:1.3702850341797 / seconds
Query Executed:select id FROM `ia` where city='Traer' && SIC_code='5541'DB:business_master_new
loadtime:1.3719220161438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Treynor' limit 1
loadtime:1.3719899654388 / seconds
Query Executed:select id FROM `ia` where city='Treynor' && SIC_code='5541'DB:business_master_new
loadtime:1.3728590011597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:1.3729140758514 / seconds
Query Executed:select id FROM `ia` where city='Tripoli' && SIC_code='5541'DB:business_master_new
loadtime:1.3747630119324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy Mills' limit 1
loadtime:1.3748300075531 / seconds
Query Executed:select id FROM `ia` where city='Troy Mills' && SIC_code='5541'DB:business_master_new
loadtime:1.3753790855408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truesdale' limit 1
loadtime:1.3754329681396 / seconds
Query Executed:select id FROM `ia` where city='Truesdale' && SIC_code='5541'DB:business_master_new
loadtime:1.3759019374847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:1.3759529590607 / seconds
Query Executed:select id FROM `ia` where city='Truro' && SIC_code='5541'DB:business_master_new
loadtime:1.3768200874329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turin' limit 1
loadtime:1.3768720626831 / seconds
Query Executed:select id FROM `ia` where city='Turin' && SIC_code='5541'DB:business_master_new
loadtime:1.3773119449615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Udell' limit 1
loadtime:1.3773701190948 / seconds
Query Executed:select id FROM `ia` where city='Udell' && SIC_code='5541'DB:business_master_new
loadtime:1.3778998851776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underwood' limit 1
loadtime:1.3779499530792 / seconds
Query Executed:select id FROM `ia` where city='Underwood' && SIC_code='5541'DB:business_master_new
loadtime:1.3788731098175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:1.3789389133453 / seconds
Query Executed:select id FROM `ia` where city='Union' && SIC_code='5541'DB:business_master_new
loadtime:1.3798279762268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:1.3798809051514 / seconds
Query Executed:select id FROM `ia` where city='Unionville' && SIC_code='5541'DB:business_master_new
loadtime:1.3804030418396 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Park' limit 1
loadtime:1.380469083786 / seconds
Query Executed:select id FROM `ia` where city='University Park' && SIC_code='5541'DB:business_master_new
loadtime:1.3809480667114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbana' limit 1
loadtime:1.3809990882874 / seconds
Query Executed:select id FROM `ia` where city='Urbana' && SIC_code='5541'DB:business_master_new
loadtime:1.3818221092224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbandale' limit 1
loadtime:1.3818740844727 / seconds
Query Executed:select id FROM `ia` where city='Urbandale' && SIC_code='5541'DB:business_master_new
loadtime:1.387001991272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute' limit 1
loadtime:1.3870689868927 / seconds
Query Executed:select id FROM `ia` where city='Ute' && SIC_code='5541'DB:business_master_new
loadtime:1.3879289627075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:1.3879950046539 / seconds
Query Executed:select id FROM `ia` where city='Vail' && SIC_code='5541'DB:business_master_new
loadtime:1.3889019489288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Horne' limit 1
loadtime:1.3889570236206 / seconds
Query Executed:select id FROM `ia` where city='Van Horne' && SIC_code='5541'DB:business_master_new
loadtime:1.390105009079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Meter' limit 1
loadtime:1.3901588916779 / seconds
Query Executed:select id FROM `ia` where city='Van Meter' && SIC_code='5541'DB:business_master_new
loadtime:1.3911700248718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wert' limit 1
loadtime:1.3912360668182 / seconds
Query Executed:select id FROM `ia` where city='Van Wert' && SIC_code='5541'DB:business_master_new
loadtime:1.3918468952179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varina' limit 1
loadtime:1.391900062561 / seconds
Query Executed:select id FROM `ia` where city='Varina' && SIC_code='5541'DB:business_master_new
loadtime:1.3923890590668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventura' limit 1
loadtime:1.3924419879913 / seconds
Query Executed:select id FROM `ia` where city='Ventura' && SIC_code='5541'DB:business_master_new
loadtime:1.3933598995209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:1.393413066864 / seconds
Query Executed:select id FROM `ia` where city='Victor' && SIC_code='5541'DB:business_master_new
loadtime:1.3948979377747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villisca' limit 1
loadtime:1.3949499130249 / seconds
Query Executed:select id FROM `ia` where city='Villisca' && SIC_code='5541'DB:business_master_new
loadtime:1.3970029354095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincent' limit 1
loadtime:1.3970561027527 / seconds
Query Executed:select id FROM `ia` where city='Vincent' && SIC_code='5541'DB:business_master_new
loadtime:1.3977739810944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vining' limit 1
loadtime:1.3978259563446 / seconds
Query Executed:select id FROM `ia` where city='Vining' && SIC_code='5541'DB:business_master_new
loadtime:1.3983390331268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:1.3983979225159 / seconds
Query Executed:select id FROM `ia` where city='Vinton' && SIC_code='5541'DB:business_master_new
loadtime:1.4026679992676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:1.402722120285 / seconds
Query Executed:select id FROM `ia` where city='Viola' && SIC_code='5541'DB:business_master_new
loadtime:1.4032299518585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:1.4032819271088 / seconds
Query Executed:select id FROM `ia` where city='Volga' && SIC_code='5541'DB:business_master_new
loadtime:1.4039740562439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadena' limit 1
loadtime:1.4040250778198 / seconds
Query Executed:select id FROM `ia` where city='Wadena' && SIC_code='5541'DB:business_master_new
loadtime:1.4046230316162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walcott' limit 1
loadtime:1.4046759605408 / seconds
Query Executed:select id FROM `ia` where city='Walcott' && SIC_code='5541'DB:business_master_new
loadtime:1.4060070514679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walford' limit 1
loadtime:1.4060769081116 / seconds
Query Executed:select id FROM `ia` where city='Walford' && SIC_code='5541'DB:business_master_new
loadtime:1.4068810939789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walker' limit 1
loadtime:1.4069499969482 / seconds
Query Executed:select id FROM `ia` where city='Walker' && SIC_code='5541'DB:business_master_new
loadtime:1.4080469608307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Lake' limit 1
loadtime:1.4081010818481 / seconds
Query Executed:select id FROM `ia` where city='Wall Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.4094839096069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:1.4095370769501 / seconds
Query Executed:select id FROM `ia` where city='Wallingford' && SIC_code='5541'DB:business_master_new
loadtime:1.4102790355682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:1.4103319644928 / seconds
Query Executed:select id FROM `ia` where city='Walnut' && SIC_code='5541'DB:business_master_new
loadtime:1.4118499755859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wapello' limit 1
loadtime:1.4119200706482 / seconds
Query Executed:select id FROM `ia` where city='Wapello' && SIC_code='5541'DB:business_master_new
loadtime:1.4143340587616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:1.4144070148468 / seconds
Query Executed:select id FROM `ia` where city='Washburn' && SIC_code='5541'DB:business_master_new
loadtime:1.4148399829865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.4148941040039 / seconds
Query Executed:select id FROM `ia` where city='Washington' && SIC_code='5541'DB:business_master_new
loadtime:1.4200370311737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washta' limit 1
loadtime:1.4201068878174 / seconds
Query Executed:select id FROM `ia` where city='Washta' && SIC_code='5541'DB:business_master_new
loadtime:1.4208409786224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:1.4209089279175 / seconds
Query Executed:select id FROM `ia` where city='Waterloo' && SIC_code='5541'DB:business_master_new
loadtime:1.4259629249573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:1.4260449409485 / seconds
Query Executed:select id FROM `ia` where city='Waterville' && SIC_code='5541'DB:business_master_new
loadtime:1.4268600940704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:1.4269170761108 / seconds
Query Executed:select id FROM `ia` where city='Watkins' && SIC_code='5541'DB:business_master_new
loadtime:1.4275588989258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waucoma' limit 1
loadtime:1.4276130199432 / seconds
Query Executed:select id FROM `ia` where city='Waucoma' && SIC_code='5541'DB:business_master_new
loadtime:1.4287400245667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukee' limit 1
loadtime:1.4287939071655 / seconds
Query Executed:select id FROM `ia` where city='Waukee' && SIC_code='5541'DB:business_master_new
loadtime:1.4320430755615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukon' limit 1
loadtime:1.432107925415 / seconds
Query Executed:select id FROM `ia` where city='Waukon' && SIC_code='5541'DB:business_master_new
loadtime:1.4360649585724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.4361329078674 / seconds
Query Executed:select id FROM `ia` where city='Waverly' && SIC_code='5541'DB:business_master_new
loadtime:1.4416189193726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:1.44167304039 / seconds
Query Executed:select id FROM `ia` where city='Wayland' && SIC_code='5541'DB:business_master_new
loadtime:1.4434599876404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:1.4435119628906 / seconds
Query Executed:select id FROM `ia` where city='Webb' && SIC_code='5541'DB:business_master_new
loadtime:1.4443440437317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.4444179534912 / seconds
Query Executed:select id FROM `ia` where city='Webster' && SIC_code='5541'DB:business_master_new
loadtime:1.4449560642242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster City' limit 1
loadtime:1.4450089931488 / seconds
Query Executed:select id FROM `ia` where city='Webster City' && SIC_code='5541'DB:business_master_new
loadtime:1.4499280452728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:1.4499809741974 / seconds
Query Executed:select id FROM `ia` where city='Weldon' && SIC_code='5541'DB:business_master_new
loadtime:1.450581073761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellman' limit 1
loadtime:1.4506349563599 / seconds
Query Executed:select id FROM `ia` where city='Wellman' && SIC_code='5541'DB:business_master_new
loadtime:1.4526228904724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsburg' limit 1
loadtime:1.4526889324188 / seconds
Query Executed:select id FROM `ia` where city='Wellsburg' && SIC_code='5541'DB:business_master_new
loadtime:1.4537250995636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welton' limit 1
loadtime:1.4537780284882 / seconds
Query Executed:select id FROM `ia` where city='Welton' && SIC_code='5541'DB:business_master_new
loadtime:1.4543480873108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesley' limit 1
loadtime:1.4544041156769 / seconds
Query Executed:select id FROM `ia` where city='Wesley' && SIC_code='5541'DB:business_master_new
loadtime:1.4554340839386 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Amana' limit 1
loadtime:1.4554860591888 / seconds
Query Executed:select id FROM `ia` where city='West Amana' && SIC_code='5541'DB:business_master_new
loadtime:1.4558999538422 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:1.4559509754181 / seconds
Query Executed:select id FROM `ia` where city='West Bend' && SIC_code='5541'DB:business_master_new
loadtime:1.4579470157623 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:1.4580008983612 / seconds
Query Executed:select id FROM `ia` where city='West Branch' && SIC_code='5541'DB:business_master_new
loadtime:1.4606230258942 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burlington' limit 1
loadtime:1.4606900215149 / seconds
Query Executed:select id FROM `ia` where city='West Burlington' && SIC_code='5541'DB:business_master_new
loadtime:1.4641768932343 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chester' limit 1
loadtime:1.4642519950867 / seconds
Query Executed:select id FROM `ia` where city='West Chester' && SIC_code='5541'DB:business_master_new
loadtime:1.4649279117584 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Des Moines' limit 1
loadtime:1.4649829864502 / seconds
Query Executed:select id FROM `ia` where city='West Des Moines' && SIC_code='5541'DB:business_master_new
loadtime:1.4700300693512 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Grove' limit 1
loadtime:1.4701011180878 / seconds
Query Executed:select id FROM `ia` where city='West Grove' && SIC_code='5541'DB:business_master_new
loadtime:1.4705839157104 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Liberty' limit 1
loadtime:1.4706399440765 / seconds
Query Executed:select id FROM `ia` where city='West Liberty' && SIC_code='5541'DB:business_master_new
loadtime:1.4734470844269 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:1.4735128879547 / seconds
Query Executed:select id FROM `ia` where city='West Point' && SIC_code='5541'DB:business_master_new
loadtime:1.4750380516052 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:1.4750909805298 / seconds
Query Executed:select id FROM `ia` where city='West Union' && SIC_code='5541'DB:business_master_new
loadtime:1.4777929782867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:1.4778470993042 / seconds
Query Executed:select id FROM `ia` where city='Westfield' && SIC_code='5541'DB:business_master_new
loadtime:1.4784960746765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westgate' limit 1
loadtime:1.4785621166229 / seconds
Query Executed:select id FROM `ia` where city='Westgate' && SIC_code='5541'DB:business_master_new
loadtime:1.4792370796204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:1.4792909622192 / seconds
Query Executed:select id FROM `ia` where city='Westphalia' && SIC_code='5541'DB:business_master_new
loadtime:1.4797859191895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westside' limit 1
loadtime:1.4798378944397 / seconds
Query Executed:select id FROM `ia` where city='Westside' && SIC_code='5541'DB:business_master_new
loadtime:1.4807651042938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wever' limit 1
loadtime:1.4808180332184 / seconds
Query Executed:select id FROM `ia` where city='Wever' && SIC_code='5541'DB:business_master_new
loadtime:1.4816579818726 / seconds
Query loaded from cache:select * from geodata_geocity where city='What Cheer' limit 1
loadtime:1.48171210289 / seconds
Query Executed:select id FROM `ia` where city='What Cheer' && SIC_code='5541'DB:business_master_new
loadtime:1.4825260639191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheatland' limit 1
loadtime:1.4825789928436 / seconds
Query Executed:select id FROM `ia` where city='Wheatland' && SIC_code='5541'DB:business_master_new
loadtime:1.4838531017303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:1.4839189052582 / seconds
Query Executed:select id FROM `ia` where city='Whiting' && SIC_code='5541'DB:business_master_new
loadtime:1.4847218990326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:1.48477602005 / seconds
Query Executed:select id FROM `ia` where city='Whittemore' && SIC_code='5541'DB:business_master_new
loadtime:1.4857089519501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitten' limit 1
loadtime:1.4857621192932 / seconds
Query Executed:select id FROM `ia` where city='Whitten' && SIC_code='5541'DB:business_master_new
loadtime:1.4863660335541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:1.4864189624786 / seconds
Query Executed:select id FROM `ia` where city='Williams' && SIC_code='5541'DB:business_master_new
loadtime:1.4873089790344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.4873790740967 / seconds
Query Executed:select id FROM `ia` where city='Williamsburg' && SIC_code='5541'DB:business_master_new
loadtime:1.4906029701233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamson' limit 1
loadtime:1.4906709194183 / seconds
Query Executed:select id FROM `ia` where city='Williamson' && SIC_code='5541'DB:business_master_new
loadtime:1.4911189079285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.4911711215973 / seconds
Query Executed:select id FROM `ia` where city='Wilton' && SIC_code='5541'DB:business_master_new
loadtime:1.4935491085052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Heights' limit 1
loadtime:1.4936199188232 / seconds
Query Executed:select id FROM `ia` where city='Windsor Heights' && SIC_code='5541'DB:business_master_new
loadtime:1.4967529773712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:1.4968240261078 / seconds
Query Executed:select id FROM `ia` where city='Winfield' && SIC_code='5541'DB:business_master_new
loadtime:1.4981060028076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterset' limit 1
loadtime:1.4981598854065 / seconds
Query Executed:select id FROM `ia` where city='Winterset' && SIC_code='5541'DB:business_master_new
loadtime:1.5024540424347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:1.5025210380554 / seconds
Query Executed:select id FROM `ia` where city='Winthrop' && SIC_code='5541'DB:business_master_new
loadtime:1.5041179656982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiota' limit 1
loadtime:1.5041739940643 / seconds
Query Executed:select id FROM `ia` where city='Wiota' && SIC_code='5541'DB:business_master_new
loadtime:1.5049331188202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woden' limit 1
loadtime:1.5049850940704 / seconds
Query Executed:select id FROM `ia` where city='Woden' && SIC_code='5541'DB:business_master_new
loadtime:1.5058600902557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:1.5059270858765 / seconds
Query Executed:select id FROM `ia` where city='Woodbine' && SIC_code='5541'DB:business_master_new
loadtime:1.5080211162567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodburn' limit 1
loadtime:1.5080881118774 / seconds
Query Executed:select id FROM `ia` where city='Woodburn' && SIC_code='5541'DB:business_master_new
loadtime:1.5087320804596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodward' limit 1
loadtime:1.5087859630585 / seconds
Query Executed:select id FROM `ia` where city='Woodward' && SIC_code='5541'DB:business_master_new
loadtime:1.5103080272675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolstock' limit 1
loadtime:1.5103659629822 / seconds
Query Executed:select id FROM `ia` where city='Woolstock' && SIC_code='5541'DB:business_master_new
loadtime:1.5110731124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:1.511137008667 / seconds
Query Executed:select id FROM `ia` where city='Worthington' && SIC_code='5541'DB:business_master_new
loadtime:1.5120799541473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:1.5121331214905 / seconds
Query Executed:select id FROM `ia` where city='Wyoming' && SIC_code='5541'DB:business_master_new
loadtime:1.5133559703827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:1.5134088993073 / seconds
Query Executed:select id FROM `ia` where city='Yale' && SIC_code='5541'DB:business_master_new
loadtime:1.514111995697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth' limit 1
loadtime:1.5141630172729 / seconds
Query Executed:select id FROM `ia` where city='Yarmouth' && SIC_code='5541'DB:business_master_new
loadtime:1.5148589611053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:1.5149130821228 / seconds
Query Executed:select id FROM `ia` where city='Yorktown' && SIC_code='5541'DB:business_master_new
loadtime:1.5154349803925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zearing' limit 1
loadtime:1.5154869556427 / seconds
Query Executed:select id FROM `ia` where city='Zearing' && SIC_code='5541'DB:business_master_new
loadtime:1.5165579319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zwingle' limit 1
loadtime:1.5166110992432 / seconds
Query Executed:select id FROM `ia` where city='Zwingle' && SIC_code='5541'DB:business_master_new
loadtime:1.5173869132996 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.517529964447 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.5180420875549 / seconds
Operation template executed (chunk cache operation)
loadtime:1.5182158946991 / seconds
template override:Default
loadtime:1.5182580947876 / 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.5195341110229 / seconds
Template Constructed, Array Rows:49
loadtime:1.5200679302216 / seconds
TOTAL EXECUTION TIME: 1.51962
loadtime:1.5229020118713 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => gasoline-service-station [stateURLid] => iowa )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.522912979126
TOTAL KEY ARRAYS: 69