Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.0108642578125E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0025041103363037 / seconds
host not found setting manual db connection
loadtime:0.010485172271729 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010755062103271 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.01093316078186 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010995149612427 / seconds
zipcode:
loadtime:0.011022090911865 / seconds
Query Executed:select * from search_referrer where page_hash='4578be08870e9ff0c7a22c4b853f537c' limit 10 DB:ezrox_toadli
loadtime:0.011270046234131 / seconds
Operation header executed (non global)
loadtime:0.011312007904053 / seconds
Operation leaderboard executed (non global)
loadtime:0.011364221572876 / seconds
Operation square executed (non global)
loadtime:0.011394023895264 / seconds
Operation square_bottom executed (non global)
loadtime:0.011421203613281 / seconds
Operation smallsquare executed (non global)
loadtime:0.011447191238403 / seconds
Operation headeradright executed (non global)
loadtime:0.011472225189209 / seconds
Operation google_analytics executed (non global)
loadtime:0.011497020721436 / seconds
Operation topstories executed (non global)
loadtime:0.011523008346558 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011550188064575 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011575222015381 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011856079101562 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.01202917098999 / seconds
Operation categories executed (global stored into APC)
loadtime:0.012064218521118 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.012123107910156 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.012181043624878 / seconds
Template key: archive_menu pushed
loadtime:0.0121910572052 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.012205123901367 / seconds
Template key: get_gravatar pushed
loadtime:0.012212038040161 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.012221097946167 / seconds
*10)-10)+1 | start:0
loadtime:0.012262105941772 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.012314081192017 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.012353181838989 / seconds
DB connected to localhost business_master_new
loadtime:0.012630224227905 / seconds
Query Executed:select * from `sd_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.022705078125 / seconds
Query stored in cache : _QUERY_www.toadli.comd5a023d8e55d727bf4cd4f61ea7f180f
loadtime:0.024336099624634 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.024393081665039 / seconds
Query Executed:select sum(totalcount) as totalsum from `sd_catmap` where sic='7231'DB:business_master_new
loadtime:0.026634216308594 / seconds
Query stored in cache : _QUERY_www.toadli.com798d196f0d900f862c278810401e5e40
loadtime:0.026675224304199 / seconds
410 / 11
loadtime:0.026731014251709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.02679705619812 / seconds
Query Executed:select id FROM `sd` where city='Aberdeen' && SIC_code='7231'DB:business_master_new
loadtime:0.037668228149414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Academy' limit 1
loadtime:0.037799119949341 / seconds
Query Executed:select id FROM `sd` where city='Academy' && SIC_code='7231'DB:business_master_new
loadtime:0.038302183151245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agar' limit 1
loadtime:0.038367033004761 / seconds
Query Executed:select id FROM `sd` where city='Agar' && SIC_code='7231'DB:business_master_new
loadtime:0.039124011993408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akaska' limit 1
loadtime:0.039188146591187 / seconds
Query Executed:select id FROM `sd` where city='Akaska' && SIC_code='7231'DB:business_master_new
loadtime:0.039720058441162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcester' limit 1
loadtime:0.039781093597412 / seconds
Query Executed:select id FROM `sd` where city='Alcester' && SIC_code='7231'DB:business_master_new
loadtime:0.042452096939087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.042533159255981 / seconds
Query Executed:select id FROM `sd` where city='Alexandria' && SIC_code='7231'DB:business_master_new
loadtime:0.045093059539795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.045181035995483 / seconds
Query Executed:select id FROM `sd` where city='Allen' && SIC_code='7231'DB:business_master_new
loadtime:0.045783996582031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.045846223831177 / seconds
Query Executed:select id FROM `sd` where city='Alpena' && SIC_code='7231'DB:business_master_new
loadtime:0.055389165878296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.055466175079346 / seconds
Query Executed:select id FROM `sd` where city='Altamont' && SIC_code='7231'DB:business_master_new
loadtime:0.055872201919556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.055925130844116 / seconds
Query Executed:select id FROM `sd` where city='Amherst' && SIC_code='7231'DB:business_master_new
loadtime:0.05646014213562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.056513071060181 / seconds
Query Executed:select id FROM `sd` where city='Andover' && SIC_code='7231'DB:business_master_new
loadtime:0.057231187820435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ardmore' limit 1
loadtime:0.057284116744995 / seconds
Query Executed:select id FROM `sd` where city='Ardmore' && SIC_code='7231'DB:business_master_new
loadtime:0.057700157165527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.057752132415771 / seconds
Query Executed:select id FROM `sd` where city='Arlington' && SIC_code='7231'DB:business_master_new
loadtime:0.060825109481812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armour' limit 1
loadtime:0.060893058776855 / seconds
Query Executed:select id FROM `sd` where city='Armour' && SIC_code='7231'DB:business_master_new
loadtime:0.0643470287323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesian' limit 1
loadtime:0.064423084259033 / seconds
Query Executed:select id FROM `sd` where city='Artesian' && SIC_code='7231'DB:business_master_new
loadtime:0.07400918006897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.074064016342163 / seconds
Query Executed:select id FROM `sd` where city='Ashton' && SIC_code='7231'DB:business_master_new
loadtime:0.074761152267456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Astoria' limit 1
loadtime:0.0748131275177 / seconds
Query Executed:select id FROM `sd` where city='Astoria' && SIC_code='7231'DB:business_master_new
loadtime:0.075628042221069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.075695037841797 / seconds
Query Executed:select id FROM `sd` where city='Aurora' && SIC_code='7231'DB:business_master_new
loadtime:0.076669216156006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.076722145080566 / seconds
Query Executed:select id FROM `sd` where city='Avon' && SIC_code='7231'DB:business_master_new
loadtime:0.079237222671509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.079313993453979 / seconds
Query Executed:select id FROM `sd` where city='Badger' && SIC_code='7231'DB:business_master_new
loadtime:0.07986307144165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.079928159713745 / seconds
Query Executed:select id FROM `sd` where city='Baltic' && SIC_code='7231'DB:business_master_new
loadtime:0.082273006439209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.082349061965942 / seconds
Query Executed:select id FROM `sd` where city='Bancroft' && SIC_code='7231'DB:business_master_new
loadtime:0.082767009735107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.082818031311035 / seconds
Query Executed:select id FROM `sd` where city='Barnard' && SIC_code='7231'DB:business_master_new
loadtime:0.083261013031006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesland' limit 1
loadtime:0.083321094512939 / seconds
Query Executed:select id FROM `sd` where city='Batesland' && SIC_code='7231'DB:business_master_new
loadtime:0.083895206451416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.08394718170166 / seconds
Query Executed:select id FROM `sd` where city='Bath' && SIC_code='7231'DB:business_master_new
loadtime:0.084772109985352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Fourche' limit 1
loadtime:0.084824085235596 / seconds
Query Executed:select id FROM `sd` where city='Belle Fourche' && SIC_code='7231'DB:business_master_new
loadtime:0.091434001922607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.091510057449341 / seconds
Query Executed:select id FROM `sd` where city='Belvidere' && SIC_code='7231'DB:business_master_new
loadtime:0.0921311378479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beresford' limit 1
loadtime:0.092187166213989 / seconds
Query Executed:select id FROM `sd` where city='Beresford' && SIC_code='7231'DB:business_master_new
loadtime:0.096864223480225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone City' limit 1
loadtime:0.096943140029907 / seconds
Query Executed:select id FROM `sd` where city='Big Stone City' && SIC_code='7231'DB:business_master_new
loadtime:0.099117040634155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bison' limit 1
loadtime:0.099177122116089 / seconds
Query Executed:select id FROM `sd` where city='Bison' && SIC_code='7231'DB:business_master_new
loadtime:0.10170221328735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.10177421569824 / seconds
Query Executed:select id FROM `sd` where city='Black Hawk' && SIC_code='7231'DB:business_master_new
loadtime:0.10569214820862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blunt' limit 1
loadtime:0.10576415061951 / seconds
Query Executed:select id FROM `sd` where city='Blunt' && SIC_code='7231'DB:business_master_new
loadtime:0.11505103111267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonesteel' limit 1
loadtime:0.11511611938477 / seconds
Query Executed:select id FROM `sd` where city='Bonesteel' && SIC_code='7231'DB:business_master_new
loadtime:0.12428617477417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdle' limit 1
loadtime:0.12435913085938 / seconds
Query Executed:select id FROM `sd` where city='Bowdle' && SIC_code='7231'DB:business_master_new
loadtime:0.12684011459351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Box Elder' limit 1
loadtime:0.12691020965576 / seconds
Query Executed:select id FROM `sd` where city='Box Elder' && SIC_code='7231'DB:business_master_new
loadtime:0.12992310523987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.12999415397644 / seconds
Query Executed:select id FROM `sd` where city='Bradley' && SIC_code='7231'DB:business_master_new
loadtime:0.13065814971924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.1307110786438 / seconds
Query Executed:select id FROM `sd` where city='Brandon' && SIC_code='7231'DB:business_master_new
loadtime:0.13714003562927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandt' limit 1
loadtime:0.13721513748169 / seconds
Query Executed:select id FROM `sd` where city='Brandt' && SIC_code='7231'DB:business_master_new
loadtime:0.14654922485352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentford' limit 1
loadtime:0.14661908149719 / seconds
Query Executed:select id FROM `sd` where city='Brentford' && SIC_code='7231'DB:business_master_new
loadtime:0.14713621139526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.1472020149231 / seconds
Query Executed:select id FROM `sd` where city='Bridgewater' && SIC_code='7231'DB:business_master_new
loadtime:0.14954710006714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.14961409568787 / seconds
Query Executed:select id FROM `sd` where city='Bristol' && SIC_code='7231'DB:business_master_new
loadtime:0.15872716903687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.15879416465759 / seconds
Query Executed:select id FROM `sd` where city='Britton' && SIC_code='7231'DB:business_master_new
loadtime:0.16307520866394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookings' limit 1
loadtime:0.16315507888794 / seconds
Query Executed:select id FROM `sd` where city='Brookings' && SIC_code='7231'DB:business_master_new
loadtime:0.17325305938721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.17335820198059 / seconds
Query Executed:select id FROM `sd` where city='Bruce' && SIC_code='7231'DB:business_master_new
loadtime:0.17519402503967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.17525100708008 / seconds
Query Executed:select id FROM `sd` where city='Bryant' && SIC_code='7231'DB:business_master_new
loadtime:0.18448615074158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.18453907966614 / seconds
Query Executed:select id FROM `sd` where city='Buffalo' && SIC_code='7231'DB:business_master_new
loadtime:0.18716716766357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Gap' limit 1
loadtime:0.18723821640015 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Gap' && SIC_code='7231'DB:business_master_new
loadtime:0.18787717819214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Ridge' limit 1
loadtime:0.18793106079102 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Ridge' && SIC_code='7231'DB:business_master_new
loadtime:0.18832516670227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead' limit 1
loadtime:0.18837714195251 / seconds
Query Executed:select id FROM `sd` where city='Bullhead' && SIC_code='7231'DB:business_master_new
loadtime:0.18887615203857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burbank' limit 1
loadtime:0.18892621994019 / seconds
Query Executed:select id FROM `sd` where city='Burbank' && SIC_code='7231'DB:business_master_new
loadtime:0.18961405754089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.18966603279114 / seconds
Query Executed:select id FROM `sd` where city='Burke' && SIC_code='7231'DB:business_master_new
loadtime:0.19300603866577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bushnell' limit 1
loadtime:0.19307613372803 / seconds
Query Executed:select id FROM `sd` where city='Bushnell' && SIC_code='7231'DB:business_master_new
loadtime:0.19351005554199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.19356322288513 / seconds
Query Executed:select id FROM `sd` where city='Butler' && SIC_code='7231'DB:business_master_new
loadtime:0.19397115707397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Crook' limit 1
loadtime:0.19402313232422 / seconds
Query Executed:select id FROM `sd` where city='Camp Crook' && SIC_code='7231'DB:business_master_new
loadtime:0.19473600387573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canistota' limit 1
loadtime:0.19480013847351 / seconds
Query Executed:select id FROM `sd` where city='Canistota' && SIC_code='7231'DB:business_master_new
loadtime:0.19710612297058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canova' limit 1
loadtime:0.1971800327301 / seconds
Query Executed:select id FROM `sd` where city='Canova' && SIC_code='7231'DB:business_master_new
loadtime:0.19807004928589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.19812321662903 / seconds
Query Executed:select id FROM `sd` where city='Canton' && SIC_code='7231'DB:business_master_new
loadtime:0.20265913009644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caputa' limit 1
loadtime:0.2027280330658 / seconds
Query Executed:select id FROM `sd` where city='Caputa' && SIC_code='7231'DB:business_master_new
loadtime:0.20328521728516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.20334815979004 / seconds
Query Executed:select id FROM `sd` where city='Carpenter' && SIC_code='7231'DB:business_master_new
loadtime:0.20412802696228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter' limit 1
loadtime:0.20418214797974 / seconds
Query Executed:select id FROM `sd` where city='Carter' && SIC_code='7231'DB:business_master_new
loadtime:0.20456409454346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.20461511611938 / seconds
Query Executed:select id FROM `sd` where city='Carthage' && SIC_code='7231'DB:business_master_new
loadtime:0.20531821250916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.2053701877594 / seconds
Query Executed:select id FROM `sd` where city='Castlewood' && SIC_code='7231'DB:business_master_new
loadtime:0.20759606361389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.20766401290894 / seconds
Query Executed:select id FROM `sd` where city='Cavour' && SIC_code='7231'DB:business_master_new
loadtime:0.20852017402649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.20857310295105 / seconds
Query Executed:select id FROM `sd` where city='Centerville' && SIC_code='7231'DB:business_master_new
loadtime:0.21118521690369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.21125602722168 / seconds
Query Executed:select id FROM `sd` where city='Central City' && SIC_code='7231'DB:business_master_new
loadtime:0.21170616149902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberlain' limit 1
loadtime:0.2117600440979 / seconds
Query Executed:select id FROM `sd` where city='Chamberlain' && SIC_code='7231'DB:business_master_new
loadtime:0.21738719940186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chancellor' limit 1
loadtime:0.21746015548706 / seconds
Query Executed:select id FROM `sd` where city='Chancellor' && SIC_code='7231'DB:business_master_new
loadtime:0.22678422927856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.22685313224792 / seconds
Query Executed:select id FROM `sd` where city='Chelsea' && SIC_code='7231'DB:business_master_new
loadtime:0.22728800773621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Creek' limit 1
loadtime:0.22734904289246 / seconds
Query Executed:select id FROM `sd` where city='Cherry Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.22782921791077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.2278790473938 / seconds
Query Executed:select id FROM `sd` where city='Chester' && SIC_code='7231'DB:business_master_new
loadtime:0.22884011268616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claire City' limit 1
loadtime:0.22890615463257 / seconds
Query Executed:select id FROM `sd` where city='Claire City' && SIC_code='7231'DB:business_master_new
loadtime:0.22966408729553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.22972917556763 / seconds
Query Executed:select id FROM `sd` where city='Claremont' && SIC_code='7231'DB:business_master_new
loadtime:0.23878717422485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.23884010314941 / seconds
Query Executed:select id FROM `sd` where city='Clark' && SIC_code='7231'DB:business_master_new
loadtime:0.2426130771637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.24268412590027 / seconds
Query Executed:select id FROM `sd` where city='Clear Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.24672603607178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.24680304527283 / seconds
Query Executed:select id FROM `sd` where city='Clearfield' && SIC_code='7231'DB:business_master_new
loadtime:0.24725103378296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colman' limit 1
loadtime:0.24732208251953 / seconds
Query Executed:select id FROM `sd` where city='Colman' && SIC_code='7231'DB:business_master_new
loadtime:0.25669407844543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colome' limit 1
loadtime:0.25684404373169 / seconds
Query Executed:select id FROM `sd` where city='Colome' && SIC_code='7231'DB:business_master_new
loadtime:0.26606106758118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colton' limit 1
loadtime:0.26613116264343 / seconds
Query Executed:select id FROM `sd` where city='Colton' && SIC_code='7231'DB:business_master_new
loadtime:0.26844716072083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.26852107048035 / seconds
Query Executed:select id FROM `sd` where city='Columbia' && SIC_code='7231'DB:business_master_new
loadtime:0.27761602401733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conde' limit 1
loadtime:0.27767109870911 / seconds
Query Executed:select id FROM `sd` where city='Conde' && SIC_code='7231'DB:business_master_new
loadtime:0.28690409660339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.28695702552795 / seconds
Query Executed:select id FROM `sd` where city='Corona' && SIC_code='7231'DB:business_master_new
loadtime:0.28773903846741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corsica' limit 1
loadtime:0.28779220581055 / seconds
Query Executed:select id FROM `sd` where city='Corsica' && SIC_code='7231'DB:business_master_new
loadtime:0.29093313217163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creighton' limit 1
loadtime:0.2910041809082 / seconds
Query Executed:select id FROM `sd` where city='Creighton' && SIC_code='7231'DB:business_master_new
loadtime:0.2913990020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresbard' limit 1
loadtime:0.29145407676697 / seconds
Query Executed:select id FROM `sd` where city='Cresbard' && SIC_code='7231'DB:business_master_new
loadtime:0.29225015640259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocker' limit 1
loadtime:0.29230213165283 / seconds
Query Executed:select id FROM `sd` where city='Crocker' && SIC_code='7231'DB:business_master_new
loadtime:0.29269909858704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crooks' limit 1
loadtime:0.2927520275116 / seconds
Query Executed:select id FROM `sd` where city='Crooks' && SIC_code='7231'DB:business_master_new
loadtime:0.30191802978516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.3019871711731 / seconds
Query Executed:select id FROM `sd` where city='Custer' && SIC_code='7231'DB:business_master_new
loadtime:0.30857110023499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota Dunes' limit 1
loadtime:0.30864906311035 / seconds
Query Executed:select id FROM `sd` where city='Dakota Dunes' && SIC_code='7231'DB:business_master_new
loadtime:0.30904221534729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.30909514427185 / seconds
Query Executed:select id FROM `sd` where city='Dallas' && SIC_code='7231'DB:business_master_new
loadtime:0.31816220283508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.31823801994324 / seconds
Query Executed:select id FROM `sd` where city='Dante' && SIC_code='7231'DB:business_master_new
loadtime:0.31884622573853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.3189001083374 / seconds
Query Executed:select id FROM `sd` where city='Davis' && SIC_code='7231'DB:business_master_new
loadtime:0.31965112686157 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Smet' limit 1
loadtime:0.31970405578613 / seconds
Query Executed:select id FROM `sd` where city='De Smet' && SIC_code='7231'DB:business_master_new
loadtime:0.32337117195129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deadwood' limit 1
loadtime:0.32344102859497 / seconds
Query Executed:select id FROM `sd` where city='Deadwood' && SIC_code='7231'DB:business_master_new
loadtime:0.32763004302979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dell Rapids' limit 1
loadtime:0.32770609855652 / seconds
Query Executed:select id FROM `sd` where city='Dell Rapids' && SIC_code='7231'DB:business_master_new
loadtime:0.3323700428009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:0.33244919776917 / seconds
Query Executed:select id FROM `sd` where city='Delmont' && SIC_code='7231'DB:business_master_new
loadtime:0.34176921844482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimock' limit 1
loadtime:0.34182405471802 / seconds
Query Executed:select id FROM `sd` where city='Dimock' && SIC_code='7231'DB:business_master_new
loadtime:0.35016703605652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doland' limit 1
loadtime:0.35025906562805 / seconds
Query Executed:select id FROM `sd` where city='Doland' && SIC_code='7231'DB:business_master_new
loadtime:0.35915803909302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolton' limit 1
loadtime:0.35923504829407 / seconds
Query Executed:select id FROM `sd` where city='Dolton' && SIC_code='7231'DB:business_master_new
loadtime:0.35979413986206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.35986018180847 / seconds
Query Executed:select id FROM `sd` where city='Draper' && SIC_code='7231'DB:business_master_new
loadtime:0.36064314842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupree' limit 1
loadtime:0.36069703102112 / seconds
Query Executed:select id FROM `sd` where city='Dupree' && SIC_code='7231'DB:business_master_new
loadtime:0.36280918121338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Butte' limit 1
loadtime:0.36287617683411 / seconds
Query Executed:select id FROM `sd` where city='Eagle Butte' && SIC_code='7231'DB:business_master_new
loadtime:0.36737012863159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.36744809150696 / seconds
Query Executed:select id FROM `sd` where city='Eden' && SIC_code='7231'DB:business_master_new
loadtime:0.36818504333496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemont' limit 1
loadtime:0.36824822425842 / seconds
Query Executed:select id FROM `sd` where city='Edgemont' && SIC_code='7231'DB:business_master_new
loadtime:0.37059903144836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egan' limit 1
loadtime:0.37066602706909 / seconds
Query Executed:select id FROM `sd` where city='Egan' && SIC_code='7231'DB:business_master_new
loadtime:0.37140011787415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Point' limit 1
loadtime:0.37146711349487 / seconds
Query Executed:select id FROM `sd` where city='Elk Point' && SIC_code='7231'DB:business_master_new
loadtime:0.37501811981201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.37508702278137 / seconds
Query Executed:select id FROM `sd` where city='Elkton' && SIC_code='7231'DB:business_master_new
loadtime:0.37791013717651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth Afb' limit 1
loadtime:0.37798118591309 / seconds
Query Executed:select id FROM `sd` where city='Ellsworth Afb' && SIC_code='7231'DB:business_master_new
loadtime:0.37890720367432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Springs' limit 1
loadtime:0.37896108627319 / seconds
Query Executed:select id FROM `sd` where city='Elm Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.3793420791626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.379399061203 / seconds
Query Executed:select id FROM `sd` where city='Emery' && SIC_code='7231'DB:business_master_new
loadtime:0.38149499893188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enning' limit 1
loadtime:0.38156318664551 / seconds
Query Executed:select id FROM `sd` where city='Enning' && SIC_code='7231'DB:business_master_new
loadtime:0.38209319114685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.38214612007141 / seconds
Query Executed:select id FROM `sd` where city='Erwin' && SIC_code='7231'DB:business_master_new
loadtime:0.38273310661316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estelline' limit 1
loadtime:0.38278603553772 / seconds
Query Executed:select id FROM `sd` where city='Estelline' && SIC_code='7231'DB:business_master_new
loadtime:0.38536214828491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethan' limit 1
loadtime:0.38544011116028 / seconds
Query Executed:select id FROM `sd` where city='Ethan' && SIC_code='7231'DB:business_master_new
loadtime:0.38744521141052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.3874990940094 / seconds
Query Executed:select id FROM `sd` where city='Eureka' && SIC_code='7231'DB:business_master_new
loadtime:0.39061117172241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairburn' limit 1
loadtime:0.39068102836609 / seconds
Query Executed:select id FROM `sd` where city='Fairburn' && SIC_code='7231'DB:business_master_new
loadtime:0.3911190032959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.39117217063904 / seconds
Query Executed:select id FROM `sd` where city='Fairfax' && SIC_code='7231'DB:business_master_new
loadtime:0.39187622070312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.39194321632385 / seconds
Query Executed:select id FROM `sd` where city='Fairview' && SIC_code='7231'DB:business_master_new
loadtime:0.39242601394653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.39247918128967 / seconds
Query Executed:select id FROM `sd` where city='Faith' && SIC_code='7231'DB:business_master_new
loadtime:0.39513206481934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faulkton' limit 1
loadtime:0.39520311355591 / seconds
Query Executed:select id FROM `sd` where city='Faulkton' && SIC_code='7231'DB:business_master_new
loadtime:0.39862608909607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fedora' limit 1
loadtime:0.39869999885559 / seconds
Query Executed:select id FROM `sd` where city='Fedora' && SIC_code='7231'DB:business_master_new
loadtime:0.39935302734375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferney' limit 1
loadtime:0.39942407608032 / seconds
Query Executed:select id FROM `sd` where city='Ferney' && SIC_code='7231'DB:business_master_new
loadtime:0.39991021156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firesteel' limit 1
loadtime:0.39996099472046 / seconds
Query Executed:select id FROM `sd` where city='Firesteel' && SIC_code='7231'DB:business_master_new
loadtime:0.40040111541748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flandreau' limit 1
loadtime:0.40045404434204 / seconds
Query Executed:select id FROM `sd` where city='Flandreau' && SIC_code='7231'DB:business_master_new
loadtime:0.40448999404907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.40456104278564 / seconds
Query Executed:select id FROM `sd` where city='Florence' && SIC_code='7231'DB:business_master_new
loadtime:0.41380906105042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestburg' limit 1
loadtime:0.41386604309082 / seconds
Query Executed:select id FROM `sd` where city='Forestburg' && SIC_code='7231'DB:business_master_new
loadtime:0.41430401802063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Meade' limit 1
loadtime:0.41435599327087 / seconds
Query Executed:select id FROM `sd` where city='Fort Meade' && SIC_code='7231'DB:business_master_new
loadtime:0.41490721702576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Pierre' limit 1
loadtime:0.41496014595032 / seconds
Query Executed:select id FROM `sd` where city='Fort Pierre' && SIC_code='7231'DB:business_master_new
loadtime:0.41937017440796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thompson' limit 1
loadtime:0.41944622993469 / seconds
Query Executed:select id FROM `sd` where city='Fort Thompson' && SIC_code='7231'DB:business_master_new
loadtime:0.42158818244934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.42164301872253 / seconds
Query Executed:select id FROM `sd` where city='Frankfort' && SIC_code='7231'DB:business_master_new
loadtime:0.42235708236694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.42241406440735 / seconds
Query Executed:select id FROM `sd` where city='Frederick' && SIC_code='7231'DB:business_master_new
loadtime:0.43152713775635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.43158006668091 / seconds
Query Executed:select id FROM `sd` where city='Freeman' && SIC_code='7231'DB:business_master_new
loadtime:0.43537616729736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitdale' limit 1
loadtime:0.43545317649841 / seconds
Query Executed:select id FROM `sd` where city='Fruitdale' && SIC_code='7231'DB:business_master_new
loadtime:0.43581104278564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.43586421012878 / seconds
Query Executed:select id FROM `sd` where city='Fulton' && SIC_code='7231'DB:business_master_new
loadtime:0.43648910522461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gann Valley' limit 1
loadtime:0.43655514717102 / seconds
Query Executed:select id FROM `sd` where city='Gann Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.43719410896301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.43725609779358 / seconds
Query Executed:select id FROM `sd` where city='Garden City' && SIC_code='7231'DB:business_master_new
loadtime:0.43783020973206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garretson' limit 1
loadtime:0.43788123130798 / seconds
Query Executed:select id FROM `sd` where city='Garretson' && SIC_code='7231'DB:business_master_new
loadtime:0.44139909744263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gary' limit 1
loadtime:0.44146800041199 / seconds
Query Executed:select id FROM `sd` where city='Gary' && SIC_code='7231'DB:business_master_new
loadtime:0.44353604316711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gayville' limit 1
loadtime:0.44360613822937 / seconds
Query Executed:select id FROM `sd` where city='Gayville' && SIC_code='7231'DB:business_master_new
loadtime:0.44446420669556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geddes' limit 1
loadtime:0.4445321559906 / seconds
Query Executed:select id FROM `sd` where city='Geddes' && SIC_code='7231'DB:business_master_new
loadtime:0.45374917984009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gettysburg' limit 1
loadtime:0.45381617546082 / seconds
Query Executed:select id FROM `sd` where city='Gettysburg' && SIC_code='7231'DB:business_master_new
loadtime:0.45728921890259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glad Valley' limit 1
loadtime:0.45735716819763 / seconds
Query Executed:select id FROM `sd` where city='Glad Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.4577522277832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencross' limit 1
loadtime:0.45780515670776 / seconds
Query Executed:select id FROM `sd` where city='Glencross' && SIC_code='7231'DB:business_master_new
loadtime:0.45823407173157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenham' limit 1
loadtime:0.45828700065613 / seconds
Query Executed:select id FROM `sd` where city='Glenham' && SIC_code='7231'DB:business_master_new
loadtime:0.45904517173767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodwin' limit 1
loadtime:0.45911002159119 / seconds
Query Executed:select id FROM `sd` where city='Goodwin' && SIC_code='7231'DB:business_master_new
loadtime:0.45996999740601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:0.46003603935242 / seconds
Query Executed:select id FROM `sd` where city='Gregory' && SIC_code='7231'DB:business_master_new
loadtime:0.46397614479065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.46404814720154 / seconds
Query Executed:select id FROM `sd` where city='Grenville' && SIC_code='7231'DB:business_master_new
loadtime:0.46470618247986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.46476006507874 / seconds
Query Executed:select id FROM `sd` where city='Groton' && SIC_code='7231'DB:business_master_new
loadtime:0.46798706054688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamill' limit 1
loadtime:0.46805500984192 / seconds
Query Executed:select id FROM `sd` where city='Hamill' && SIC_code='7231'DB:business_master_new
loadtime:0.46871304512024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.46876621246338 / seconds
Query Executed:select id FROM `sd` where city='Harrisburg' && SIC_code='7231'DB:business_master_new
loadtime:0.47170305252075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:0.47177004814148 / seconds
Query Executed:select id FROM `sd` where city='Harrison' && SIC_code='7231'DB:business_master_new
loadtime:0.47233510017395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrold' limit 1
loadtime:0.47239303588867 / seconds
Query Executed:select id FROM `sd` where city='Harrold' && SIC_code='7231'DB:business_master_new
loadtime:0.47423505783081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.47428917884827 / seconds
Query Executed:select id FROM `sd` where city='Hartford' && SIC_code='7231'DB:business_master_new
loadtime:0.47794413566589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.47801303863525 / seconds
Query Executed:select id FROM `sd` where city='Hayes' && SIC_code='7231'DB:business_master_new
loadtime:0.47860217094421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayti' limit 1
loadtime:0.47865605354309 / seconds
Query Executed:select id FROM `sd` where city='Hayti' && SIC_code='7231'DB:business_master_new
loadtime:0.48100519180298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel' limit 1
loadtime:0.48107409477234 / seconds
Query Executed:select id FROM `sd` where city='Hazel' && SIC_code='7231'DB:business_master_new
loadtime:0.48190307617188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hecla' limit 1
loadtime:0.48195910453796 / seconds
Query Executed:select id FROM `sd` where city='Hecla' && SIC_code='7231'DB:business_master_new
loadtime:0.48399019241333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.48406100273132 / seconds
Query Executed:select id FROM `sd` where city='Henry' && SIC_code='7231'DB:business_master_new
loadtime:0.48490810394287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermosa' limit 1
loadtime:0.48497414588928 / seconds
Query Executed:select id FROM `sd` where city='Hermosa' && SIC_code='7231'DB:business_master_new
loadtime:0.48717713356018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herreid' limit 1
loadtime:0.48725199699402 / seconds
Query Executed:select id FROM `sd` where city='Herreid' && SIC_code='7231'DB:business_master_new
loadtime:0.48965716362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herrick' limit 1
loadtime:0.48972606658936 / seconds
Query Executed:select id FROM `sd` where city='Herrick' && SIC_code='7231'DB:business_master_new
loadtime:0.49042010307312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hetland' limit 1
loadtime:0.49047422409058 / seconds
Query Executed:select id FROM `sd` where city='Hetland' && SIC_code='7231'DB:business_master_new
loadtime:0.49085021018982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highmore' limit 1
loadtime:0.49090099334717 / seconds
Query Executed:select id FROM `sd` where city='Highmore' && SIC_code='7231'DB:business_master_new
loadtime:0.49427914619446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill City' limit 1
loadtime:0.49434900283813 / seconds
Query Executed:select id FROM `sd` where city='Hill City' && SIC_code='7231'DB:business_master_new
loadtime:0.49817109107971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hitchcock' limit 1
loadtime:0.49825310707092 / seconds
Query Executed:select id FROM `sd` where city='Hitchcock' && SIC_code='7231'DB:business_master_new
loadtime:0.50012922286987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holabird' limit 1
loadtime:0.50019717216492 / seconds
Query Executed:select id FROM `sd` where city='Holabird' && SIC_code='7231'DB:business_master_new
loadtime:0.50074410438538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hosmer' limit 1
loadtime:0.50079822540283 / seconds
Query Executed:select id FROM `sd` where city='Hosmer' && SIC_code='7231'DB:business_master_new
loadtime:0.50247311592102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.50254511833191 / seconds
Query Executed:select id FROM `sd` where city='Hot Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.50883913040161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.50892114639282 / seconds
Query Executed:select id FROM `sd` where city='Houghton' && SIC_code='7231'DB:business_master_new
loadtime:0.5095911026001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoven' limit 1
loadtime:0.50965905189514 / seconds
Query Executed:select id FROM `sd` where city='Hoven' && SIC_code='7231'DB:business_master_new
loadtime:0.51207113265991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.51213717460632 / seconds
Query Executed:select id FROM `sd` where city='Howard' && SIC_code='7231'DB:business_master_new
loadtime:0.51579809188843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howes' limit 1
loadtime:0.51587104797363 / seconds
Query Executed:select id FROM `sd` where city='Howes' && SIC_code='7231'DB:business_master_new
loadtime:0.51644802093506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.51650214195251 / seconds
Query Executed:select id FROM `sd` where city='Hudson' && SIC_code='7231'DB:business_master_new
loadtime:0.51758313179016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.51764917373657 / seconds
Query Executed:select id FROM `sd` where city='Humboldt' && SIC_code='7231'DB:business_master_new
loadtime:0.5271110534668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.52718210220337 / seconds
Query Executed:select id FROM `sd` where city='Hurley' && SIC_code='7231'DB:business_master_new
loadtime:0.52859616279602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huron' limit 1
loadtime:0.5286660194397 / seconds
Query Executed:select id FROM `sd` where city='Huron' && SIC_code='7231'DB:business_master_new
loadtime:0.54172205924988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ideal' limit 1
loadtime:0.54182505607605 / seconds
Query Executed:select id FROM `sd` where city='Ideal' && SIC_code='7231'DB:business_master_new
loadtime:0.54233121871948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Igloo' limit 1
loadtime:0.54239201545715 / seconds
Query Executed:select id FROM `sd` where city='Igloo' && SIC_code='7231'DB:business_master_new
loadtime:0.54280018806458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interior' limit 1
loadtime:0.54285407066345 / seconds
Query Executed:select id FROM `sd` where city='Interior' && SIC_code='7231'DB:business_master_new
loadtime:0.54362916946411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:0.54368209838867 / seconds
Query Executed:select id FROM `sd` where city='Ipswich' && SIC_code='7231'DB:business_master_new
loadtime:0.54705715179443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irene' limit 1
loadtime:0.54712510108948 / seconds
Query Executed:select id FROM `sd` where city='Irene' && SIC_code='7231'DB:business_master_new
loadtime:0.55632400512695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iroquois' limit 1
loadtime:0.55639505386353 / seconds
Query Executed:select id FROM `sd` where city='Iroquois' && SIC_code='7231'DB:business_master_new
loadtime:0.55756211280823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isabel' limit 1
loadtime:0.55761504173279 / seconds
Query Executed:select id FROM `sd` where city='Isabel' && SIC_code='7231'DB:business_master_new
loadtime:0.55876708030701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.55883312225342 / seconds
Query Executed:select id FROM `sd` where city='Java' && SIC_code='7231'DB:business_master_new
loadtime:0.55957007408142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.55962300300598 / seconds
Query Executed:select id FROM `sd` where city='Jefferson' && SIC_code='7231'DB:business_master_new
loadtime:0.56099104881287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kadoka' limit 1
loadtime:0.56105899810791 / seconds
Query Executed:select id FROM `sd` where city='Kadoka' && SIC_code='7231'DB:business_master_new
loadtime:0.56425809860229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaylor' limit 1
loadtime:0.56433701515198 / seconds
Query Executed:select id FROM `sd` where city='Kaylor' && SIC_code='7231'DB:business_master_new
loadtime:0.56487703323364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keldron' limit 1
loadtime:0.56493210792542 / seconds
Query Executed:select id FROM `sd` where city='Keldron' && SIC_code='7231'DB:business_master_new
loadtime:0.56546401977539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennebec' limit 1
loadtime:0.56551718711853 / seconds
Query Executed:select id FROM `sd` where city='Kennebec' && SIC_code='7231'DB:business_master_new
loadtime:0.56692409515381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.56699013710022 / seconds
Query Executed:select id FROM `sd` where city='Keystone' && SIC_code='7231'DB:business_master_new
loadtime:0.57633709907532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:0.57639503479004 / seconds
Query Executed:select id FROM `sd` where city='Kimball' && SIC_code='7231'DB:business_master_new
loadtime:0.58565306663513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kranzburg' limit 1
loadtime:0.58572506904602 / seconds
Query Executed:select id FROM `sd` where city='Kranzburg' && SIC_code='7231'DB:business_master_new
loadtime:0.5862500667572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kyle' limit 1
loadtime:0.58630514144897 / seconds
Query Executed:select id FROM `sd` where city='Kyle' && SIC_code='7231'DB:business_master_new
loadtime:0.58731603622437 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plant' limit 1
loadtime:0.5873692035675 / seconds
Query Executed:select id FROM `sd` where city='La Plant' && SIC_code='7231'DB:business_master_new
loadtime:0.58782720565796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Labolt' limit 1
loadtime:0.5878791809082 / seconds
Query Executed:select id FROM `sd` where city='Labolt' && SIC_code='7231'DB:business_master_new
loadtime:0.58844804763794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Andes' limit 1
loadtime:0.58850002288818 / seconds
Query Executed:select id FROM `sd` where city='Lake Andes' && SIC_code='7231'DB:business_master_new
loadtime:0.59144401550293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.59151315689087 / seconds
Query Executed:select id FROM `sd` where city='Lake City' && SIC_code='7231'DB:business_master_new
loadtime:0.59208703041077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Norden' limit 1
loadtime:0.59214019775391 / seconds
Query Executed:select id FROM `sd` where city='Lake Norden' && SIC_code='7231'DB:business_master_new
loadtime:0.59356117248535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Preston' limit 1
loadtime:0.59361410140991 / seconds
Query Executed:select id FROM `sd` where city='Lake Preston' && SIC_code='7231'DB:business_master_new
loadtime:0.60294008255005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.60300803184509 / seconds
Query Executed:select id FROM `sd` where city='Lane' && SIC_code='7231'DB:business_master_new
loadtime:0.60343718528748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langford' limit 1
loadtime:0.60349106788635 / seconds
Query Executed:select id FROM `sd` where city='Langford' && SIC_code='7231'DB:business_master_new
loadtime:0.6044750213623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lantry' limit 1
loadtime:0.60452914237976 / seconds
Query Executed:select id FROM `sd` where city='Lantry' && SIC_code='7231'DB:business_master_new
loadtime:0.60499215126038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lead' limit 1
loadtime:0.6050431728363 / seconds
Query Executed:select id FROM `sd` where city='Lead' && SIC_code='7231'DB:business_master_new
loadtime:0.60855603218079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.6086311340332 / seconds
Query Executed:select id FROM `sd` where city='Lebanon' && SIC_code='7231'DB:business_master_new
loadtime:0.60930919647217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemmon' limit 1
loadtime:0.60937809944153 / seconds
Query Executed:select id FROM `sd` where city='Lemmon' && SIC_code='7231'DB:business_master_new
loadtime:0.61313819885254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennox' limit 1
loadtime:0.61322021484375 / seconds
Query Executed:select id FROM `sd` where city='Lennox' && SIC_code='7231'DB:business_master_new
loadtime:0.6168692111969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leola' limit 1
loadtime:0.61694002151489 / seconds
Query Executed:select id FROM `sd` where city='Leola' && SIC_code='7231'DB:business_master_new
loadtime:0.62631106376648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lesterville' limit 1
loadtime:0.62637615203857 / seconds
Query Executed:select id FROM `sd` where city='Lesterville' && SIC_code='7231'DB:business_master_new
loadtime:0.62720704078674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letcher' limit 1
loadtime:0.62728214263916 / seconds
Query Executed:select id FROM `sd` where city='Letcher' && SIC_code='7231'DB:business_master_new
loadtime:0.62849307060242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Eagle' limit 1
loadtime:0.62856101989746 / seconds
Query Executed:select id FROM `sd` where city='Little Eagle' && SIC_code='7231'DB:business_master_new
loadtime:0.62901401519775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodgepole' limit 1
loadtime:0.62906622886658 / seconds
Query Executed:select id FROM `sd` where city='Lodgepole' && SIC_code='7231'DB:business_master_new
loadtime:0.62960910797119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:0.62966203689575 / seconds
Query Executed:select id FROM `sd` where city='Long Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.63019418716431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longlake' limit 1
loadtime:0.63025403022766 / seconds
Query Executed:select id FROM `sd` where city='Longlake' && SIC_code='7231'DB:business_master_new
loadtime:0.63066101074219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longvalley' limit 1
loadtime:0.63071322441101 / seconds
Query Executed:select id FROM `sd` where city='Longvalley' && SIC_code='7231'DB:business_master_new
loadtime:0.63113522529602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Brule' limit 1
loadtime:0.63118600845337 / seconds
Query Executed:select id FROM `sd` where city='Lower Brule' && SIC_code='7231'DB:business_master_new
loadtime:0.64042901992798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.64048099517822 / seconds
Query Executed:select id FROM `sd` where city='Lowry' && SIC_code='7231'DB:business_master_new
loadtime:0.64086318016052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.64091300964355 / seconds
Query Executed:select id FROM `sd` where city='Ludlow' && SIC_code='7231'DB:business_master_new
loadtime:0.64147710800171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.64153003692627 / seconds
Query Executed:select id FROM `sd` where city='Lyons' && SIC_code='7231'DB:business_master_new
loadtime:0.64206314086914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.64211320877075 / seconds
Query Executed:select id FROM `sd` where city='Madison' && SIC_code='7231'DB:business_master_new
loadtime:0.65008521080017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manderson' limit 1
loadtime:0.65016222000122 / seconds
Query Executed:select id FROM `sd` where city='Manderson' && SIC_code='7231'DB:business_master_new
loadtime:0.65072202682495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:0.65077614784241 / seconds
Query Executed:select id FROM `sd` where city='Mansfield' && SIC_code='7231'DB:business_master_new
loadtime:0.65150904655457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.65156221389771 / seconds
Query Executed:select id FROM `sd` where city='Marion' && SIC_code='7231'DB:business_master_new
loadtime:0.66094708442688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.66101622581482 / seconds
Query Executed:select id FROM `sd` where city='Martin' && SIC_code='7231'DB:business_master_new
loadtime:0.66413712501526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marty' limit 1
loadtime:0.6642050743103 / seconds
Query Executed:select id FROM `sd` where city='Marty' && SIC_code='7231'DB:business_master_new
loadtime:0.66481304168701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvin' limit 1
loadtime:0.66486716270447 / seconds
Query Executed:select id FROM `sd` where city='Marvin' && SIC_code='7231'DB:business_master_new
loadtime:0.66535115242004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.66540813446045 / seconds
Query Executed:select id FROM `sd` where city='Mc Intosh' && SIC_code='7231'DB:business_master_new
loadtime:0.66646003723145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Laughlin' limit 1
loadtime:0.6665301322937 / seconds
Query Executed:select id FROM `sd` where city='Mc Laughlin' && SIC_code='7231'DB:business_master_new
loadtime:0.67580914497375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.67586612701416 / seconds
Query Executed:select id FROM `sd` where city='Meadow' && SIC_code='7231'DB:business_master_new
loadtime:0.6766791343689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meckling' limit 1
loadtime:0.67673206329346 / seconds
Query Executed:select id FROM `sd` where city='Meckling' && SIC_code='7231'DB:business_master_new
loadtime:0.67713308334351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellette' limit 1
loadtime:0.67718410491943 / seconds
Query Executed:select id FROM `sd` where city='Mellette' && SIC_code='7231'DB:business_master_new
loadtime:0.6780641078949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menno' limit 1
loadtime:0.67811822891235 / seconds
Query Executed:select id FROM `sd` where city='Menno' && SIC_code='7231'DB:business_master_new
loadtime:0.68102717399597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.68109607696533 / seconds
Query Executed:select id FROM `sd` where city='Midland' && SIC_code='7231'DB:business_master_new
loadtime:0.68231010437012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milbank' limit 1
loadtime:0.68236517906189 / seconds
Query Executed:select id FROM `sd` where city='Milbank' && SIC_code='7231'DB:business_master_new
loadtime:0.68877506256104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milesville' limit 1
loadtime:0.68886113166809 / seconds
Query Executed:select id FROM `sd` where city='Milesville' && SIC_code='7231'DB:business_master_new
loadtime:0.68948602676392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miller' limit 1
loadtime:0.68954110145569 / seconds
Query Executed:select id FROM `sd` where city='Miller' && SIC_code='7231'DB:business_master_new
loadtime:0.69385600090027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mina' limit 1
loadtime:0.69393515586853 / seconds
Query Executed:select id FROM `sd` where city='Mina' && SIC_code='7231'DB:business_master_new
loadtime:0.69439005851746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miranda' limit 1
loadtime:0.69444513320923 / seconds
Query Executed:select id FROM `sd` where city='Miranda' && SIC_code='7231'DB:business_master_new
loadtime:0.6948390007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission' limit 1
loadtime:0.69489002227783 / seconds
Query Executed:select id FROM `sd` where city='Mission' && SIC_code='7231'DB:business_master_new
loadtime:0.69811415672302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission Hill' limit 1
loadtime:0.69816613197327 / seconds
Query Executed:select id FROM `sd` where city='Mission Hill' && SIC_code='7231'DB:business_master_new
loadtime:0.69902110099792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.69907522201538 / seconds
Query Executed:select id FROM `sd` where city='Mitchell' && SIC_code='7231'DB:business_master_new
loadtime:0.71499919891357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mobridge' limit 1
loadtime:0.7151210308075 / seconds
Query Executed:select id FROM `sd` where city='Mobridge' && SIC_code='7231'DB:business_master_new
loadtime:0.72074103355408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.72082209587097 / seconds
Query Executed:select id FROM `sd` where city='Monroe' && SIC_code='7231'DB:business_master_new
loadtime:0.72152018547058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.72157502174377 / seconds
Query Executed:select id FROM `sd` where city='Montrose' && SIC_code='7231'DB:business_master_new
loadtime:0.7227840423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.72285103797913 / seconds
Query Executed:select id FROM `sd` where city='Morristown' && SIC_code='7231'DB:business_master_new
loadtime:0.72347211837769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound City' limit 1
loadtime:0.7235381603241 / seconds
Query Executed:select id FROM `sd` where city='Mound City' && SIC_code='7231'DB:business_master_new
loadtime:0.72429609298706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.72436022758484 / seconds
Query Executed:select id FROM `sd` where city='Mount Vernon' && SIC_code='7231'DB:business_master_new
loadtime:0.72566604614258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.72573399543762 / seconds
Query Executed:select id FROM `sd` where city='Mt Vernon' && SIC_code='7231'DB:business_master_new
loadtime:0.72614002227783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mud Butte' limit 1
loadtime:0.72619199752808 / seconds
Query Executed:select id FROM `sd` where city='Mud Butte' && SIC_code='7231'DB:business_master_new
loadtime:0.72671008110046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murdo' limit 1
loadtime:0.72676205635071 / seconds
Query Executed:select id FROM `sd` where city='Murdo' && SIC_code='7231'DB:business_master_new
loadtime:0.73637104034424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemo' limit 1
loadtime:0.73644304275513 / seconds
Query Executed:select id FROM `sd` where city='Nemo' && SIC_code='7231'DB:business_master_new
loadtime:0.73699116706848 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Effington' limit 1
loadtime:0.73705506324768 / seconds
Query Executed:select id FROM `sd` where city='New Effington' && SIC_code='7231'DB:business_master_new
loadtime:0.73811817169189 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holland' limit 1
loadtime:0.73818612098694 / seconds
Query Executed:select id FROM `sd` where city='New Holland' && SIC_code='7231'DB:business_master_new
loadtime:0.73878312110901 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Underwood' limit 1
loadtime:0.73885107040405 / seconds
Query Executed:select id FROM `sd` where city='New Underwood' && SIC_code='7231'DB:business_master_new
loadtime:0.74004006385803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.74009323120117 / seconds
Query Executed:select id FROM `sd` where city='Newell' && SIC_code='7231'DB:business_master_new
loadtime:0.74925899505615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisland' limit 1
loadtime:0.74933218955994 / seconds
Query Executed:select id FROM `sd` where city='Nisland' && SIC_code='7231'DB:business_master_new
loadtime:0.75000309944153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.75005722045898 / seconds
Query Executed:select id FROM `sd` where city='Norris' && SIC_code='7231'DB:business_master_new
loadtime:0.7506160736084 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sioux City' limit 1
loadtime:0.75066900253296 / seconds
Query Executed:select id FROM `sd` where city='North Sioux City' && SIC_code='7231'DB:business_master_new
loadtime:0.75599813461304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:0.75606918334961 / seconds
Query Executed:select id FROM `sd` where city='Northville' && SIC_code='7231'DB:business_master_new
loadtime:0.75688219070435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunda' limit 1
loadtime:0.75693607330322 / seconds
Query Executed:select id FROM `sd` where city='Nunda' && SIC_code='7231'DB:business_master_new
loadtime:0.75756907463074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oacoma' limit 1
loadtime:0.7576220035553 / seconds
Query Executed:select id FROM `sd` where city='Oacoma' && SIC_code='7231'DB:business_master_new
loadtime:0.75843501091003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelrichs' limit 1
loadtime:0.75848722457886 / seconds
Query Executed:select id FROM `sd` where city='Oelrichs' && SIC_code='7231'DB:business_master_new
loadtime:0.75914716720581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oglala' limit 1
loadtime:0.75919818878174 / seconds
Query Executed:select id FROM `sd` where city='Oglala' && SIC_code='7231'DB:business_master_new
loadtime:0.75977516174316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okaton' limit 1
loadtime:0.75982713699341 / seconds
Query Executed:select id FROM `sd` where city='Okaton' && SIC_code='7231'DB:business_master_new
loadtime:0.76027917861938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okreek' limit 1
loadtime:0.76033210754395 / seconds
Query Executed:select id FROM `sd` where city='Okreek' && SIC_code='7231'DB:business_master_new
loadtime:0.76074814796448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldham' limit 1
loadtime:0.76080012321472 / seconds
Query Executed:select id FROM `sd` where city='Oldham' && SIC_code='7231'DB:business_master_new
loadtime:0.76168704032898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:0.76173901557922 / seconds
Query Executed:select id FROM `sd` where city='Olivet' && SIC_code='7231'DB:business_master_new
loadtime:0.76264500617981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaka' limit 1
loadtime:0.7627100944519 / seconds
Query Executed:select id FROM `sd` where city='Onaka' && SIC_code='7231'DB:business_master_new
loadtime:0.76341414451599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onida' limit 1
loadtime:0.76346611976624 / seconds
Query Executed:select id FROM `sd` where city='Onida' && SIC_code='7231'DB:business_master_new
loadtime:0.77283215522766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opal' limit 1
loadtime:0.77290201187134 / seconds
Query Executed:select id FROM `sd` where city='Opal' && SIC_code='7231'DB:business_master_new
loadtime:0.77329301834106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oral' limit 1
loadtime:0.77334809303284 / seconds
Query Executed:select id FROM `sd` where city='Oral' && SIC_code='7231'DB:business_master_new
loadtime:0.7738950252533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.77394819259644 / seconds
Query Executed:select id FROM `sd` where city='Orient' && SIC_code='7231'DB:business_master_new
loadtime:0.77480912208557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortley' limit 1
loadtime:0.77486109733582 / seconds
Query Executed:select id FROM `sd` where city='Ortley' && SIC_code='7231'DB:business_master_new
loadtime:0.7753791809082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owanka' limit 1
loadtime:0.7754340171814 / seconds
Query Executed:select id FROM `sd` where city='Owanka' && SIC_code='7231'DB:business_master_new
loadtime:0.77592921257019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.77597904205322 / seconds
Query Executed:select id FROM `sd` where city='Parker' && SIC_code='7231'DB:business_master_new
loadtime:0.77979612350464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkston' limit 1
loadtime:0.77986812591553 / seconds
Query Executed:select id FROM `sd` where city='Parkston' && SIC_code='7231'DB:business_master_new
loadtime:0.78375220298767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmelee' limit 1
loadtime:0.78382420539856 / seconds
Query Executed:select id FROM `sd` where city='Parmelee' && SIC_code='7231'DB:business_master_new
loadtime:0.78444719314575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peever' limit 1
loadtime:0.78450107574463 / seconds
Query Executed:select id FROM `sd` where city='Peever' && SIC_code='7231'DB:business_master_new
loadtime:0.78523421287537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philip' limit 1
loadtime:0.7853000164032 / seconds
Query Executed:select id FROM `sd` where city='Philip' && SIC_code='7231'DB:business_master_new
loadtime:0.78870320320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickstown' limit 1
loadtime:0.78877305984497 / seconds
Query Executed:select id FROM `sd` where city='Pickstown' && SIC_code='7231'DB:business_master_new
loadtime:0.7895770072937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.78963208198547 / seconds
Query Executed:select id FROM `sd` where city='Piedmont' && SIC_code='7231'DB:business_master_new
loadtime:0.79894709587097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierpont' limit 1
loadtime:0.79901504516602 / seconds
Query Executed:select id FROM `sd` where city='Pierpont' && SIC_code='7231'DB:business_master_new
loadtime:0.7996551990509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierre' limit 1
loadtime:0.7997100353241 / seconds
Query Executed:select id FROM `sd` where city='Pierre' && SIC_code='7231'DB:business_master_new
loadtime:0.81757211685181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Ridge' limit 1
loadtime:0.81767702102661 / seconds
Query Executed:select id FROM `sd` where city='Pine Ridge' && SIC_code='7231'DB:business_master_new
loadtime:0.82115817070007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plankinton' limit 1
loadtime:0.82123899459839 / seconds
Query Executed:select id FROM `sd` where city='Plankinton' && SIC_code='7231'DB:business_master_new
loadtime:0.83070302009583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platte' limit 1
loadtime:0.83077311515808 / seconds
Query Executed:select id FROM `sd` where city='Platte' && SIC_code='7231'DB:business_master_new
loadtime:0.83615708351135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollock' limit 1
loadtime:0.83623719215393 / seconds
Query Executed:select id FROM `sd` where city='Pollock' && SIC_code='7231'DB:business_master_new
loadtime:0.83730816841125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porcupine' limit 1
loadtime:0.83736300468445 / seconds
Query Executed:select id FROM `sd` where city='Porcupine' && SIC_code='7231'DB:business_master_new
loadtime:0.83818221092224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.83824300765991 / seconds
Query Executed:select id FROM `sd` where city='Prairie City' && SIC_code='7231'DB:business_master_new
loadtime:0.83894920349121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presho' limit 1
loadtime:0.83900117874146 / seconds
Query Executed:select id FROM `sd` where city='Presho' && SIC_code='7231'DB:business_master_new
loadtime:0.84834718704224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pringle' limit 1
loadtime:0.84842300415039 / seconds
Query Executed:select id FROM `sd` where city='Pringle' && SIC_code='7231'DB:business_master_new
loadtime:0.84899806976318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukwana' limit 1
loadtime:0.84905004501343 / seconds
Query Executed:select id FROM `sd` where city='Pukwana' && SIC_code='7231'DB:business_master_new
loadtime:0.85017609596252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinn' limit 1
loadtime:0.85025000572205 / seconds
Query Executed:select id FROM `sd` where city='Quinn' && SIC_code='7231'DB:business_master_new
loadtime:0.85081100463867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:0.85086512565613 / seconds
Query Executed:select id FROM `sd` where city='Ralph' && SIC_code='7231'DB:business_master_new
loadtime:0.85135221481323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramona' limit 1
loadtime:0.85140705108643 / seconds
Query Executed:select id FROM `sd` where city='Ramona' && SIC_code='7231'DB:business_master_new
loadtime:0.85232901573181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:0.8523850440979 / seconds
Query Executed:select id FROM `sd` where city='Rapid City' && SIC_code='7231'DB:business_master_new
loadtime:0.86250615119934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravinia' limit 1
loadtime:0.86271214485168 / seconds
Query Executed:select id FROM `sd` where city='Ravinia' && SIC_code='7231'DB:business_master_new
loadtime:0.86310315132141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.86316609382629 / seconds
Query Executed:select id FROM `sd` where city='Raymond' && SIC_code='7231'DB:business_master_new
loadtime:0.86380004882812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Owl' limit 1
loadtime:0.8638551235199 / seconds
Query Executed:select id FROM `sd` where city='Red Owl' && SIC_code='7231'DB:business_master_new
loadtime:0.86424517631531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.86429810523987 / seconds
Query Executed:select id FROM `sd` where city='Redfield' && SIC_code='7231'DB:business_master_new
loadtime:0.86882901191711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redig' limit 1
loadtime:0.86889600753784 / seconds
Query Executed:select id FROM `sd` where city='Redig' && SIC_code='7231'DB:business_master_new
loadtime:0.86938905715942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ree Heights' limit 1
loadtime:0.8694441318512 / seconds
Query Executed:select id FROM `sd` where city='Ree Heights' && SIC_code='7231'DB:business_master_new
loadtime:0.87018322944641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.87024307250977 / seconds
Query Executed:select id FROM `sd` where city='Reliance' && SIC_code='7231'DB:business_master_new
loadtime:0.87128806114197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renner' limit 1
loadtime:0.8713390827179 / seconds
Query Executed:select id FROM `sd` where city='Renner' && SIC_code='7231'DB:business_master_new
loadtime:0.8722071647644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.87226605415344 / seconds
Query Executed:select id FROM `sd` where city='Reva' && SIC_code='7231'DB:business_master_new
loadtime:0.87290120124817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revillo' limit 1
loadtime:0.8729522228241 / seconds
Query Executed:select id FROM `sd` where city='Revillo' && SIC_code='7231'DB:business_master_new
loadtime:0.87395405769348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeview' limit 1
loadtime:0.87400722503662 / seconds
Query Executed:select id FROM `sd` where city='Ridgeview' && SIC_code='7231'DB:business_master_new
loadtime:0.87449622154236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockham' limit 1
loadtime:0.87454700469971 / seconds
Query Executed:select id FROM `sd` where city='Rockham' && SIC_code='7231'DB:business_master_new
loadtime:0.87512302398682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscoe' limit 1
loadtime:0.87517905235291 / seconds
Query Executed:select id FROM `sd` where city='Roscoe' && SIC_code='7231'DB:business_master_new
loadtime:0.87655520439148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebud' limit 1
loadtime:0.87662410736084 / seconds
Query Executed:select id FROM `sd` where city='Rosebud' && SIC_code='7231'DB:business_master_new
loadtime:0.88598608970642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:0.88604116439819 / seconds
Query Executed:select id FROM `sd` where city='Rosholt' && SIC_code='7231'DB:business_master_new
loadtime:0.88762807846069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslyn' limit 1
loadtime:0.88769817352295 / seconds
Query Executed:select id FROM `sd` where city='Roslyn' && SIC_code='7231'DB:business_master_new
loadtime:0.88855409622192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowena' limit 1
loadtime:0.88860821723938 / seconds
Query Executed:select id FROM `sd` where city='Rowena' && SIC_code='7231'DB:business_master_new
loadtime:0.88904500007629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.88909602165222 / seconds
Query Executed:select id FROM `sd` where city='Rutland' && SIC_code='7231'DB:business_master_new
loadtime:0.88966917991638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.88972210884094 / seconds
Query Executed:select id FROM `sd` where city='Saint Charles' && SIC_code='7231'DB:business_master_new
loadtime:0.8901801109314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Francis' limit 1
loadtime:0.89023900032043 / seconds
Query Executed:select id FROM `sd` where city='Saint Francis' && SIC_code='7231'DB:business_master_new
loadtime:0.89100503921509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Lawrence' limit 1
loadtime:0.89105606079102 / seconds
Query Executed:select id FROM `sd` where city='Saint Lawrence' && SIC_code='7231'DB:business_master_new
loadtime:0.89187002182007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Onge' limit 1
loadtime:0.89192199707031 / seconds
Query Executed:select id FROM `sd` where city='Saint Onge' && SIC_code='7231'DB:business_master_new
loadtime:0.89251518249512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.89256620407104 / seconds
Query Executed:select id FROM `sd` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:0.89654517173767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scenic' limit 1
loadtime:0.89662599563599 / seconds
Query Executed:select id FROM `sd` where city='Scenic' && SIC_code='7231'DB:business_master_new
loadtime:0.89718508720398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.89724707603455 / seconds
Query Executed:select id FROM `sd` where city='Scotland' && SIC_code='7231'DB:business_master_new
loadtime:0.90669322013855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selby' limit 1
loadtime:0.90676712989807 / seconds
Query Executed:select id FROM `sd` where city='Selby' && SIC_code='7231'DB:business_master_new
loadtime:0.91612815856934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.91620016098022 / seconds
Query Executed:select id FROM `sd` where city='Seneca' && SIC_code='7231'DB:business_master_new
loadtime:0.91686415672302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shadehill' limit 1
loadtime:0.9169180393219 / seconds
Query Executed:select id FROM `sd` where city='Shadehill' && SIC_code='7231'DB:business_master_new
loadtime:0.91737914085388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.91743612289429 / seconds
Query Executed:select id FROM `sd` where city='Sherman' && SIC_code='7231'DB:business_master_new
loadtime:0.91786408424377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.91791415214539 / seconds
Query Executed:select id FROM `sd` where city='Silver City' && SIC_code='7231'DB:business_master_new
loadtime:0.9183521270752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinai' limit 1
loadtime:0.9184091091156 / seconds
Query Executed:select id FROM `sd` where city='Sinai' && SIC_code='7231'DB:business_master_new
loadtime:0.91907119750977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Falls' limit 1
loadtime:0.9191210269928 / seconds
Query Executed:select id FROM `sd` where city='Sioux Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.92925405502319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sisseton' limit 1
loadtime:0.92953014373779 / seconds
Query Executed:select id FROM `sd` where city='Sisseton' && SIC_code='7231'DB:business_master_new
loadtime:0.93523907661438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sky Ranch' limit 1
loadtime:0.93533611297607 / seconds
Query Executed:select id FROM `sd` where city='Sky Ranch' && SIC_code='7231'DB:business_master_new
loadtime:0.93573713302612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithwick' limit 1
loadtime:0.93579006195068 / seconds
Query Executed:select id FROM `sd` where city='Smithwick' && SIC_code='7231'DB:business_master_new
loadtime:0.93618607521057 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Shore' limit 1
loadtime:0.93624806404114 / seconds
Query Executed:select id FROM `sd` where city='South Shore' && SIC_code='7231'DB:business_master_new
loadtime:0.93705821037292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spearfish' limit 1
loadtime:0.9371120929718 / seconds
Query Executed:select id FROM `sd` where city='Spearfish' && SIC_code='7231'DB:business_master_new
loadtime:0.94847917556763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.94857311248779 / seconds
Query Executed:select id FROM `sd` where city='Spencer' && SIC_code='7231'DB:business_master_new
loadtime:0.94939303398132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.9494640827179 / seconds
Query Executed:select id FROM `sd` where city='Springfield' && SIC_code='7231'DB:business_master_new
loadtime:0.95130014419556 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.95137000083923 / seconds
Query Executed:select id FROM `sd` where city='St Charles' && SIC_code='7231'DB:business_master_new
loadtime:0.95179915428162 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:0.95185112953186 / seconds
Query Executed:select id FROM `sd` where city='St Francis' && SIC_code='7231'DB:business_master_new
loadtime:0.95229601860046 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lawrence' limit 1
loadtime:0.95234704017639 / seconds
Query Executed:select id FROM `sd` where city='St Lawrence' && SIC_code='7231'DB:business_master_new
loadtime:0.95280313491821 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Onge' limit 1
loadtime:0.95285511016846 / seconds
Query Executed:select id FROM `sd` where city='St Onge' && SIC_code='7231'DB:business_master_new
loadtime:0.95328807830811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephan' limit 1
loadtime:0.95334100723267 / seconds
Query Executed:select id FROM `sd` where city='Stephan' && SIC_code='7231'DB:business_master_new
loadtime:0.9538791179657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stickney' limit 1
loadtime:0.95393109321594 / seconds
Query Executed:select id FROM `sd` where city='Stickney' && SIC_code='7231'DB:business_master_new
loadtime:0.95542311668396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:0.95549416542053 / seconds
Query Executed:select id FROM `sd` where city='Stockholm' && SIC_code='7231'DB:business_master_new
loadtime:0.95620012283325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strandburg' limit 1
loadtime:0.95627307891846 / seconds
Query Executed:select id FROM `sd` where city='Strandburg' && SIC_code='7231'DB:business_master_new
loadtime:0.95686721801758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.95692014694214 / seconds
Query Executed:select id FROM `sd` where city='Stratford' && SIC_code='7231'DB:business_master_new
loadtime:0.95763516426086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:0.95768809318542 / seconds
Query Executed:select id FROM `sd` where city='Sturgis' && SIC_code='7231'DB:business_master_new
loadtime:0.96532821655273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.96541118621826 / seconds
Query Executed:select id FROM `sd` where city='Summit' && SIC_code='7231'DB:business_master_new
loadtime:0.96634817123413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:0.96640706062317 / seconds
Query Executed:select id FROM `sd` where city='Tabor' && SIC_code='7231'DB:business_master_new
loadtime:0.96774315834045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tea' limit 1
loadtime:0.96781206130981 / seconds
Query Executed:select id FROM `sd` where city='Tea' && SIC_code='7231'DB:business_master_new
loadtime:0.97194600105286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timber Lake' limit 1
loadtime:0.97202205657959 / seconds
Query Executed:select id FROM `sd` where city='Timber Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.97370409965515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolstoy' limit 1
loadtime:0.97377705574036 / seconds
Query Executed:select id FROM `sd` where city='Tolstoy' && SIC_code='7231'DB:business_master_new
loadtime:0.97453308105469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:0.97460007667542 / seconds
Query Executed:select id FROM `sd` where city='Toronto' && SIC_code='7231'DB:business_master_new
loadtime:0.97575807571411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trail City' limit 1
loadtime:0.97582411766052 / seconds
Query Executed:select id FROM `sd` where city='Trail City' && SIC_code='7231'DB:business_master_new
loadtime:0.97632908821106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent' limit 1
loadtime:0.97638511657715 / seconds
Query Executed:select id FROM `sd` where city='Trent' && SIC_code='7231'DB:business_master_new
loadtime:0.97702312469482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripp' limit 1
loadtime:0.97707509994507 / seconds
Query Executed:select id FROM `sd` where city='Tripp' && SIC_code='7231'DB:business_master_new
loadtime:0.9787220954895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tulare' limit 1
loadtime:0.97879099845886 / seconds
Query Executed:select id FROM `sd` where city='Tulare' && SIC_code='7231'DB:business_master_new
loadtime:0.97969913482666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turton' limit 1
loadtime:0.97976517677307 / seconds
Query Executed:select id FROM `sd` where city='Turton' && SIC_code='7231'DB:business_master_new
loadtime:0.9804060459137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuthill' limit 1
loadtime:0.98045921325684 / seconds
Query Executed:select id FROM `sd` where city='Tuthill' && SIC_code='7231'DB:business_master_new
loadtime:0.98095417022705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Brooks' limit 1
loadtime:0.98100519180298 / seconds
Query Executed:select id FROM `sd` where city='Twin Brooks' && SIC_code='7231'DB:business_master_new
loadtime:0.98170399665833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyndall' limit 1
loadtime:0.98175811767578 / seconds
Query Executed:select id FROM `sd` where city='Tyndall' && SIC_code='7231'DB:business_master_new
loadtime:0.9853880405426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:0.98546314239502 / seconds
Query Executed:select id FROM `sd` where city='Union Center' && SIC_code='7231'DB:business_master_new
loadtime:0.98616814613342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:0.98623013496399 / seconds
Query Executed:select id FROM `sd` where city='Utica' && SIC_code='7231'DB:business_master_new
loadtime:0.98697710037231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:0.98703002929688 / seconds
Query Executed:select id FROM `sd` where city='Vale' && SIC_code='7231'DB:business_master_new
loadtime:0.98787021636963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Springs' limit 1
loadtime:0.98792314529419 / seconds
Query Executed:select id FROM `sd` where city='Valley Springs' && SIC_code='7231'DB:business_master_new
loadtime:0.98938822746277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veblen' limit 1
loadtime:0.98944115638733 / seconds
Query Executed:select id FROM `sd` where city='Veblen' && SIC_code='7231'DB:business_master_new
loadtime:0.99054217338562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermillion' limit 1
loadtime:0.99060916900635 / seconds
Query Executed:select id FROM `sd` where city='Vermillion' && SIC_code='7231'DB:business_master_new
loadtime:0.99834322929382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viborg' limit 1
loadtime:0.99842715263367 / seconds
Query Executed:select id FROM `sd` where city='Viborg' && SIC_code='7231'DB:business_master_new
loadtime:1.0002911090851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:1.0003590583801 / seconds
Query Executed:select id FROM `sd` where city='Vienna' && SIC_code='7231'DB:business_master_new
loadtime:1.0009551048279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgil' limit 1
loadtime:1.0010070800781 / seconds
Query Executed:select id FROM `sd` where city='Virgil' && SIC_code='7231'DB:business_master_new
loadtime:1.0014750957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vivian' limit 1
loadtime:1.0015280246735 / seconds
Query Executed:select id FROM `sd` where city='Vivian' && SIC_code='7231'DB:business_master_new
loadtime:1.0022621154785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:1.0023140907288 / seconds
Query Executed:select id FROM `sd` where city='Volga' && SIC_code='7231'DB:business_master_new
loadtime:1.012050151825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volin' limit 1
loadtime:1.0121231079102 / seconds
Query Executed:select id FROM `sd` where city='Volin' && SIC_code='7231'DB:business_master_new
loadtime:1.0130481719971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagner' limit 1
loadtime:1.0131020545959 / seconds
Query Executed:select id FROM `sd` where city='Wagner' && SIC_code='7231'DB:business_master_new
loadtime:1.0173981189728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakonda' limit 1
loadtime:1.0174701213837 / seconds
Query Executed:select id FROM `sd` where city='Wakonda' && SIC_code='7231'DB:business_master_new
loadtime:1.0187270641327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakpala' limit 1
loadtime:1.0187950134277 / seconds
Query Executed:select id FROM `sd` where city='Wakpala' && SIC_code='7231'DB:business_master_new
loadtime:1.0192580223083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:1.0193130970001 / seconds
Query Executed:select id FROM `sd` where city='Wall' && SIC_code='7231'DB:business_master_new
loadtime:1.0285542011261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:1.0286211967468 / seconds
Query Executed:select id FROM `sd` where city='Wallace' && SIC_code='7231'DB:business_master_new
loadtime:1.0291750431061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanblee' limit 1
loadtime:1.0292370319366 / seconds
Query Executed:select id FROM `sd` where city='Wanblee' && SIC_code='7231'DB:business_master_new
loadtime:1.0298500061035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:1.0299031734467 / seconds
Query Executed:select id FROM `sd` where city='Ward' && SIC_code='7231'DB:business_master_new
loadtime:1.0303151607513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:1.0303671360016 / seconds
Query Executed:select id FROM `sd` where city='Warner' && SIC_code='7231'DB:business_master_new
loadtime:1.0311541557312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wasta' limit 1
loadtime:1.0312051773071 / seconds
Query Executed:select id FROM `sd` where city='Wasta' && SIC_code='7231'DB:business_master_new
loadtime:1.0318050384521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watauga' limit 1
loadtime:1.0318601131439 / seconds
Query Executed:select id FROM `sd` where city='Watauga' && SIC_code='7231'DB:business_master_new
loadtime:1.032341003418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:1.0323970317841 / seconds
Query Executed:select id FROM `sd` where city='Watertown' && SIC_code='7231'DB:business_master_new
loadtime:1.0536651611328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubay' limit 1
loadtime:1.0537960529327 / seconds
Query Executed:select id FROM `sd` where city='Waubay' && SIC_code='7231'DB:business_master_new
loadtime:1.0562031269073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.0562841892242 / seconds
Query Executed:select id FROM `sd` where city='Waverly' && SIC_code='7231'DB:business_master_new
loadtime:1.056648015976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.0567021369934 / seconds
Query Executed:select id FROM `sd` where city='Webster' && SIC_code='7231'DB:business_master_new
loadtime:1.0617280006409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wecota' limit 1
loadtime:1.0618040561676 / seconds
Query Executed:select id FROM `sd` where city='Wecota' && SIC_code='7231'DB:business_master_new
loadtime:1.0621712207794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:1.0622341632843 / seconds
Query Executed:select id FROM `sd` where city='Wentworth' && SIC_code='7231'DB:business_master_new
loadtime:1.0640640258789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington' limit 1
loadtime:1.064129114151 / seconds
Query Executed:select id FROM `sd` where city='Wessington' && SIC_code='7231'DB:business_master_new
loadtime:1.0662441253662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Spgs' limit 1
loadtime:1.0663161277771 / seconds
Query Executed:select id FROM `sd` where city='Wessington Spgs' && SIC_code='7231'DB:business_master_new
loadtime:1.0667061805725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Springs' limit 1
loadtime:1.0667591094971 / seconds
Query Executed:select id FROM `sd` where city='Wessington Springs' && SIC_code='7231'DB:business_master_new
loadtime:1.0701520442963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:1.070228099823 / seconds
Query Executed:select id FROM `sd` where city='Westport' && SIC_code='7231'DB:business_master_new
loadtime:1.07093501091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetonka' limit 1
loadtime:1.0709881782532 / seconds
Query Executed:select id FROM `sd` where city='Wetonka' && SIC_code='7231'DB:business_master_new
loadtime:1.0714111328125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wewela' limit 1
loadtime:1.0714640617371 / seconds
Query Executed:select id FROM `sd` where city='Wewela' && SIC_code='7231'DB:business_master_new
loadtime:1.0718770027161 / seconds
Query loaded from cache:select * from geodata_geocity where city='White' limit 1
loadtime:1.071928024292 / seconds
Query Executed:select id FROM `sd` where city='White' && SIC_code='7231'DB:business_master_new
loadtime:1.0744020938873 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:1.0744731426239 / seconds
Query Executed:select id FROM `sd` where city='White Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.0766911506653 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Owl' limit 1
loadtime:1.076761007309 / seconds
Query Executed:select id FROM `sd` where city='White Owl' && SIC_code='7231'DB:business_master_new
loadtime:1.077183008194 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River' limit 1
loadtime:1.0772449970245 / seconds
Query Executed:select id FROM `sd` where city='White River' && SIC_code='7231'DB:business_master_new
loadtime:1.0796291828156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehorse' limit 1
loadtime:1.0796980857849 / seconds
Query Executed:select id FROM `sd` where city='Whitehorse' && SIC_code='7231'DB:business_master_new
loadtime:1.0801491737366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:1.0802011489868 / seconds
Query Executed:select id FROM `sd` where city='Whitewood' && SIC_code='7231'DB:business_master_new
loadtime:1.0824210643768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Lake' limit 1
loadtime:1.0824880599976 / seconds
Query Executed:select id FROM `sd` where city='Willow Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.084459066391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:1.084527015686 / seconds
Query Executed:select id FROM `sd` where city='Wilmot' && SIC_code='7231'DB:business_master_new
loadtime:1.0868780612946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfred' limit 1
loadtime:1.0869450569153 / seconds
Query Executed:select id FROM `sd` where city='Winfred' && SIC_code='7231'DB:business_master_new
loadtime:1.0877890586853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winner' limit 1
loadtime:1.0878422260284 / seconds
Query Executed:select id FROM `sd` where city='Winner' && SIC_code='7231'DB:business_master_new
loadtime:1.094918012619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Witten' limit 1
loadtime:1.0949940681458 / seconds
Query Executed:select id FROM `sd` where city='Witten' && SIC_code='7231'DB:business_master_new
loadtime:1.0956501960754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolsey' limit 1
loadtime:1.0957050323486 / seconds
Query Executed:select id FROM `sd` where city='Wolsey' && SIC_code='7231'DB:business_master_new
loadtime:1.0976500511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood' limit 1
loadtime:1.0977191925049 / seconds
Query Executed:select id FROM `sd` where city='Wood' && SIC_code='7231'DB:business_master_new
loadtime:1.0983991622925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woonsocket' limit 1
loadtime:1.0984530448914 / seconds
Query Executed:select id FROM `sd` where city='Woonsocket' && SIC_code='7231'DB:business_master_new
loadtime:1.1016712188721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthing' limit 1
loadtime:1.101743221283 / seconds
Query Executed:select id FROM `sd` where city='Worthing' && SIC_code='7231'DB:business_master_new
loadtime:1.1037471294403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wounded Knee' limit 1
loadtime:1.1038131713867 / seconds
Query Executed:select id FROM `sd` where city='Wounded Knee' && SIC_code='7231'DB:business_master_new
loadtime:1.1042771339417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:1.1043310165405 / seconds
Query Executed:select id FROM `sd` where city='Yale' && SIC_code='7231'DB:business_master_new
loadtime:1.1049230098724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yankton' limit 1
loadtime:1.1049761772156 / seconds
Query Executed:select id FROM `sd` where city='Yankton' && SIC_code='7231'DB:business_master_new
loadtime:1.1155140399933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zell' limit 1
loadtime:1.1156380176544 / seconds
Query Executed:select id FROM `sd` where city='Zell' && SIC_code='7231'DB:business_master_new
loadtime:1.1159851551056 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.1161410808563 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.1165931224823 / seconds
Operation template executed (chunk cache operation)
loadtime:1.1167550086975 / seconds
template override:Default
loadtime:1.1167981624603 / 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.1183571815491 / seconds
Template Constructed, Array Rows:49
loadtime:1.1189022064209 / seconds
TOTAL EXECUTION TIME: 1.11845
loadtime:1.1207020282745 / 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] => beauty-shops [stateURLid] => south-dakota )


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