Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.1988830566406E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017549991607666 / seconds
host not found setting manual db connection
loadtime:0.010554075241089 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010810136795044 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010957002639771 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.011019945144653 / seconds
zipcode:
loadtime:0.011047124862671 / seconds
Query Executed:select * from search_referrer where page_hash='16bf0d677a1d8cd0acc923e9b2b3746b' limit 10 DB:ezrox_toadli
loadtime:0.011289119720459 / seconds
Operation header executed (non global)
loadtime:0.011321067810059 / seconds
Operation leaderboard executed (non global)
loadtime:0.011372089385986 / seconds
Operation square executed (non global)
loadtime:0.011402130126953 / seconds
Operation square_bottom executed (non global)
loadtime:0.011436939239502 / seconds
Operation smallsquare executed (non global)
loadtime:0.011466026306152 / seconds
Operation headeradright executed (non global)
loadtime:0.011491060256958 / seconds
Operation google_analytics executed (non global)
loadtime:0.011516094207764 / seconds
Operation topstories executed (non global)
loadtime:0.011541128158569 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011568069458008 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011608123779297 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011868953704834 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.012057065963745 / seconds
Operation categories executed (global stored into APC)
loadtime:0.012102127075195 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.012166023254395 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.012216091156006 / seconds
Template key: archive_menu pushed
loadtime:0.012225151062012 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.012238025665283 / seconds
Template key: get_gravatar pushed
loadtime:0.012244939804077 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.012253999710083 / seconds
*10)-10)+1 | start:0
loadtime:0.012294054031372 / seconds
DB connected to localhost business_master_new
loadtime:0.012535095214844 / seconds
Query Executed:select * from categories where cat_URLid='veterinary-services-for-animal-specialties'DB:business_master_new
loadtime:0.013484001159668 / seconds
Query stored in cache : _QUERY_www.toadli.comec8dbe254f3b2ec70110cc61ac08f3fb
loadtime:0.013553142547607 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.013610124588013 / seconds
Query Executed:select * from `sd_catmap` where sic='0742' order by city ascDB:business_master_new
loadtime:0.10695314407349 / seconds
Query stored in cache : _QUERY_www.toadli.com3c44ce034c238398715cf2bafb38e167
loadtime:0.10861015319824 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.10866904258728 / seconds
Query Executed:select sum(totalcount) as totalsum from `sd_catmap` where sic='0742'DB:business_master_new
loadtime:0.11098098754883 / seconds
Query stored in cache : _QUERY_www.toadli.com5300933c0d6a61b93ddc32cae5c13f2d
loadtime:0.11102104187012 / seconds
410 / 11
loadtime:0.11107897758484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.11115097999573 / seconds
Query Executed:select id FROM `sd` where city='Aberdeen' && SIC_code='0742'DB:business_master_new
loadtime:0.12562203407288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Academy' limit 1
loadtime:0.12570810317993 / seconds
Query Executed:select id FROM `sd` where city='Academy' && SIC_code='0742'DB:business_master_new
loadtime:0.12618803977966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agar' limit 1
loadtime:0.12625598907471 / seconds
Query Executed:select id FROM `sd` where city='Agar' && SIC_code='0742'DB:business_master_new
loadtime:0.12706899642944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akaska' limit 1
loadtime:0.12713098526001 / seconds
Query Executed:select id FROM `sd` where city='Akaska' && SIC_code='0742'DB:business_master_new
loadtime:0.12767601013184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcester' limit 1
loadtime:0.12774300575256 / seconds
Query Executed:select id FROM `sd` where city='Alcester' && SIC_code='0742'DB:business_master_new
loadtime:0.12982511520386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.12989211082458 / seconds
Query Executed:select id FROM `sd` where city='Alexandria' && SIC_code='0742'DB:business_master_new
loadtime:0.13185501098633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.13191795349121 / seconds
Query Executed:select id FROM `sd` where city='Allen' && SIC_code='0742'DB:business_master_new
loadtime:0.13251399993896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.13257598876953 / seconds
Query Executed:select id FROM `sd` where city='Alpena' && SIC_code='0742'DB:business_master_new
loadtime:0.13390898704529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.13397097587585 / seconds
Query Executed:select id FROM `sd` where city='Altamont' && SIC_code='0742'DB:business_master_new
loadtime:0.13438296318054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.13444805145264 / seconds
Query Executed:select id FROM `sd` where city='Amherst' && SIC_code='0742'DB:business_master_new
loadtime:0.1349949836731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.13505601882935 / seconds
Query Executed:select id FROM `sd` where city='Andover' && SIC_code='0742'DB:business_master_new
loadtime:0.13579702377319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ardmore' limit 1
loadtime:0.1358630657196 / seconds
Query Executed:select id FROM `sd` where city='Ardmore' && SIC_code='0742'DB:business_master_new
loadtime:0.13629102706909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.1363570690155 / seconds
Query Executed:select id FROM `sd` where city='Arlington' && SIC_code='0742'DB:business_master_new
loadtime:0.13881206512451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armour' limit 1
loadtime:0.13888001441956 / seconds
Query Executed:select id FROM `sd` where city='Armour' && SIC_code='0742'DB:business_master_new
loadtime:0.14172196388245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesian' limit 1
loadtime:0.14180707931519 / seconds
Query Executed:select id FROM `sd` where city='Artesian' && SIC_code='0742'DB:business_master_new
loadtime:0.14315414428711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.14323210716248 / seconds
Query Executed:select id FROM `sd` where city='Ashton' && SIC_code='0742'DB:business_master_new
loadtime:0.14394402503967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Astoria' limit 1
loadtime:0.14400601387024 / seconds
Query Executed:select id FROM `sd` where city='Astoria' && SIC_code='0742'DB:business_master_new
loadtime:0.14508199691772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.14514398574829 / seconds
Query Executed:select id FROM `sd` where city='Aurora' && SIC_code='0742'DB:business_master_new
loadtime:0.14634895324707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.14640998840332 / seconds
Query Executed:select id FROM `sd` where city='Avon' && SIC_code='0742'DB:business_master_new
loadtime:0.14837598800659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.148442029953 / seconds
Query Executed:select id FROM `sd` where city='Badger' && SIC_code='0742'DB:business_master_new
loadtime:0.14901208877563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.1490740776062 / seconds
Query Executed:select id FROM `sd` where city='Baltic' && SIC_code='0742'DB:business_master_new
loadtime:0.15086793899536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.15093493461609 / seconds
Query Executed:select id FROM `sd` where city='Bancroft' && SIC_code='0742'DB:business_master_new
loadtime:0.15137696266174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.15144300460815 / seconds
Query Executed:select id FROM `sd` where city='Barnard' && SIC_code='0742'DB:business_master_new
loadtime:0.15191411972046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesland' limit 1
loadtime:0.15197491645813 / seconds
Query Executed:select id FROM `sd` where city='Batesland' && SIC_code='0742'DB:business_master_new
loadtime:0.15257596969604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.15264892578125 / seconds
Query Executed:select id FROM `sd` where city='Bath' && SIC_code='0742'DB:business_master_new
loadtime:0.15373802185059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Fourche' limit 1
loadtime:0.15380096435547 / seconds
Query Executed:select id FROM `sd` where city='Belle Fourche' && SIC_code='0742'DB:business_master_new
loadtime:0.15623092651367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.15631294250488 / seconds
Query Executed:select id FROM `sd` where city='Belvidere' && SIC_code='0742'DB:business_master_new
loadtime:0.15697312355042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beresford' limit 1
loadtime:0.15703701972961 / seconds
Query Executed:select id FROM `sd` where city='Beresford' && SIC_code='0742'DB:business_master_new
loadtime:0.15947508811951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone City' limit 1
loadtime:0.15954995155334 / seconds
Query Executed:select id FROM `sd` where city='Big Stone City' && SIC_code='0742'DB:business_master_new
loadtime:0.16120600700378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bison' limit 1
loadtime:0.16126894950867 / seconds
Query Executed:select id FROM `sd` where city='Bison' && SIC_code='0742'DB:business_master_new
loadtime:0.1632080078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.16326999664307 / seconds
Query Executed:select id FROM `sd` where city='Black Hawk' && SIC_code='0742'DB:business_master_new
loadtime:0.16660308837891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blunt' limit 1
loadtime:0.16668200492859 / seconds
Query Executed:select id FROM `sd` where city='Blunt' && SIC_code='0742'DB:business_master_new
loadtime:0.1679539680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonesteel' limit 1
loadtime:0.16802310943604 / seconds
Query Executed:select id FROM `sd` where city='Bonesteel' && SIC_code='0742'DB:business_master_new
loadtime:0.16954612731934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdle' limit 1
loadtime:0.16962003707886 / seconds
Query Executed:select id FROM `sd` where city='Bowdle' && SIC_code='0742'DB:business_master_new
loadtime:0.1715669631958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Box Elder' limit 1
loadtime:0.17166113853455 / seconds
Query Executed:select id FROM `sd` where city='Box Elder' && SIC_code='0742'DB:business_master_new
loadtime:0.17405915260315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.17412209510803 / seconds
Query Executed:select id FROM `sd` where city='Bradley' && SIC_code='0742'DB:business_master_new
loadtime:0.17479610443115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.17486214637756 / seconds
Query Executed:select id FROM `sd` where city='Brandon' && SIC_code='0742'DB:business_master_new
loadtime:0.17724895477295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandt' limit 1
loadtime:0.17732691764832 / seconds
Query Executed:select id FROM `sd` where city='Brandt' && SIC_code='0742'DB:business_master_new
loadtime:0.17836403846741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentford' limit 1
loadtime:0.17843294143677 / seconds
Query Executed:select id FROM `sd` where city='Brentford' && SIC_code='0742'DB:business_master_new
loadtime:0.17897796630859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.17903900146484 / seconds
Query Executed:select id FROM `sd` where city='Bridgewater' && SIC_code='0742'DB:business_master_new
loadtime:0.18085098266602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.18093013763428 / seconds
Query Executed:select id FROM `sd` where city='Bristol' && SIC_code='0742'DB:business_master_new
loadtime:0.18233299255371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.18239712715149 / seconds
Query Executed:select id FROM `sd` where city='Britton' && SIC_code='0742'DB:business_master_new
loadtime:0.18606495857239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookings' limit 1
loadtime:0.18614292144775 / seconds
Query Executed:select id FROM `sd` where city='Brookings' && SIC_code='0742'DB:business_master_new
loadtime:0.18853902816772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.18864107131958 / seconds
Query Executed:select id FROM `sd` where city='Bruce' && SIC_code='0742'DB:business_master_new
loadtime:0.18997311592102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.19003701210022 / seconds
Query Executed:select id FROM `sd` where city='Bryant' && SIC_code='0742'DB:business_master_new
loadtime:0.19142699241638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.19148993492126 / seconds
Query Executed:select id FROM `sd` where city='Buffalo' && SIC_code='0742'DB:business_master_new
loadtime:0.19359707832336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Gap' limit 1
loadtime:0.19367694854736 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Gap' && SIC_code='0742'DB:business_master_new
loadtime:0.19432711601257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Ridge' limit 1
loadtime:0.1943941116333 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Ridge' && SIC_code='0742'DB:business_master_new
loadtime:0.19481801986694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead' limit 1
loadtime:0.19487810134888 / seconds
Query Executed:select id FROM `sd` where city='Bullhead' && SIC_code='0742'DB:business_master_new
loadtime:0.19540309906006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burbank' limit 1
loadtime:0.19546914100647 / seconds
Query Executed:select id FROM `sd` where city='Burbank' && SIC_code='0742'DB:business_master_new
loadtime:0.19616413116455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.19622611999512 / seconds
Query Executed:select id FROM `sd` where city='Burke' && SIC_code='0742'DB:business_master_new
loadtime:0.198979139328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bushnell' limit 1
loadtime:0.19906401634216 / seconds
Query Executed:select id FROM `sd` where city='Bushnell' && SIC_code='0742'DB:business_master_new
loadtime:0.19951605796814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.19958901405334 / seconds
Query Executed:select id FROM `sd` where city='Butler' && SIC_code='0742'DB:business_master_new
loadtime:0.20002698898315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Crook' limit 1
loadtime:0.2000880241394 / seconds
Query Executed:select id FROM `sd` where city='Camp Crook' && SIC_code='0742'DB:business_master_new
loadtime:0.20084714889526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canistota' limit 1
loadtime:0.20090913772583 / seconds
Query Executed:select id FROM `sd` where city='Canistota' && SIC_code='0742'DB:business_master_new
loadtime:0.2031729221344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canova' limit 1
loadtime:0.20328497886658 / seconds
Query Executed:select id FROM `sd` where city='Canova' && SIC_code='0742'DB:business_master_new
loadtime:0.20494699478149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.20501303672791 / seconds
Query Executed:select id FROM `sd` where city='Canton' && SIC_code='0742'DB:business_master_new
loadtime:0.20821905136108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caputa' limit 1
loadtime:0.20829105377197 / seconds
Query Executed:select id FROM `sd` where city='Caputa' && SIC_code='0742'DB:business_master_new
loadtime:0.20885109901428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.20890593528748 / seconds
Query Executed:select id FROM `sd` where city='Carpenter' && SIC_code='0742'DB:business_master_new
loadtime:0.2096951007843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter' limit 1
loadtime:0.20974802970886 / seconds
Query Executed:select id FROM `sd` where city='Carter' && SIC_code='0742'DB:business_master_new
loadtime:0.210116147995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.21017503738403 / seconds
Query Executed:select id FROM `sd` where city='Carthage' && SIC_code='0742'DB:business_master_new
loadtime:0.2108690738678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.21092295646667 / seconds
Query Executed:select id FROM `sd` where city='Castlewood' && SIC_code='0742'DB:business_master_new
loadtime:0.21259093284607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.21264910697937 / seconds
Query Executed:select id FROM `sd` where city='Cavour' && SIC_code='0742'DB:business_master_new
loadtime:0.21348905563354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.21354293823242 / seconds
Query Executed:select id FROM `sd` where city='Centerville' && SIC_code='0742'DB:business_master_new
loadtime:0.21551895141602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.21557307243347 / seconds
Query Executed:select id FROM `sd` where city='Central City' && SIC_code='0742'DB:business_master_new
loadtime:0.21601700782776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberlain' limit 1
loadtime:0.21607494354248 / seconds
Query Executed:select id FROM `sd` where city='Chamberlain' && SIC_code='0742'DB:business_master_new
loadtime:0.21846413612366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chancellor' limit 1
loadtime:0.21853995323181 / seconds
Query Executed:select id FROM `sd` where city='Chancellor' && SIC_code='0742'DB:business_master_new
loadtime:0.2199010848999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.21995496749878 / seconds
Query Executed:select id FROM `sd` where city='Chelsea' && SIC_code='0742'DB:business_master_new
loadtime:0.22037100791931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Creek' limit 1
loadtime:0.22042298316956 / seconds
Query Executed:select id FROM `sd` where city='Cherry Creek' && SIC_code='0742'DB:business_master_new
loadtime:0.22091293334961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.22096705436707 / seconds
Query Executed:select id FROM `sd` where city='Chester' && SIC_code='0742'DB:business_master_new
loadtime:0.22215700149536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claire City' limit 1
loadtime:0.22221493721008 / seconds
Query Executed:select id FROM `sd` where city='Claire City' && SIC_code='0742'DB:business_master_new
loadtime:0.22296214103699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.22301912307739 / seconds
Query Executed:select id FROM `sd` where city='Claremont' && SIC_code='0742'DB:business_master_new
loadtime:0.22427606582642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.22432899475098 / seconds
Query Executed:select id FROM `sd` where city='Clark' && SIC_code='0742'DB:business_master_new
loadtime:0.22746610641479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.2275390625 / seconds
Query Executed:select id FROM `sd` where city='Clear Lake' && SIC_code='0742'DB:business_master_new
loadtime:0.23089003562927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.23095703125 / seconds
Query Executed:select id FROM `sd` where city='Clearfield' && SIC_code='0742'DB:business_master_new
loadtime:0.23138809204102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colman' limit 1
loadtime:0.23145413398743 / seconds
Query Executed:select id FROM `sd` where city='Colman' && SIC_code='0742'DB:business_master_new
loadtime:0.23299503326416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colome' limit 1
loadtime:0.23304891586304 / seconds
Query Executed:select id FROM `sd` where city='Colome' && SIC_code='0742'DB:business_master_new
loadtime:0.23445892333984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colton' limit 1
loadtime:0.23451209068298 / seconds
Query Executed:select id FROM `sd` where city='Colton' && SIC_code='0742'DB:business_master_new
loadtime:0.23627114295959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.23634314537048 / seconds
Query Executed:select id FROM `sd` where city='Columbia' && SIC_code='0742'DB:business_master_new
loadtime:0.23753809928894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conde' limit 1
loadtime:0.23760008811951 / seconds
Query Executed:select id FROM `sd` where city='Conde' && SIC_code='0742'DB:business_master_new
loadtime:0.23886013031006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.23891401290894 / seconds
Query Executed:select id FROM `sd` where city='Corona' && SIC_code='0742'DB:business_master_new
loadtime:0.23994493484497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corsica' limit 1
loadtime:0.24003005027771 / seconds
Query Executed:select id FROM `sd` where city='Corsica' && SIC_code='0742'DB:business_master_new
loadtime:0.24257707595825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creighton' limit 1
loadtime:0.24266695976257 / seconds
Query Executed:select id FROM `sd` where city='Creighton' && SIC_code='0742'DB:business_master_new
loadtime:0.2430579662323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresbard' limit 1
loadtime:0.24311304092407 / seconds
Query Executed:select id FROM `sd` where city='Cresbard' && SIC_code='0742'DB:business_master_new
loadtime:0.24415397644043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocker' limit 1
loadtime:0.2442090511322 / seconds
Query Executed:select id FROM `sd` where city='Crocker' && SIC_code='0742'DB:business_master_new
loadtime:0.24462008476257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crooks' limit 1
loadtime:0.24467301368713 / seconds
Query Executed:select id FROM `sd` where city='Crooks' && SIC_code='0742'DB:business_master_new
loadtime:0.24597406387329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.24602699279785 / seconds
Query Executed:select id FROM `sd` where city='Custer' && SIC_code='0742'DB:business_master_new
loadtime:0.24840402603149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota Dunes' limit 1
loadtime:0.24848604202271 / seconds
Query Executed:select id FROM `sd` where city='Dakota Dunes' && SIC_code='0742'DB:business_master_new
loadtime:0.2488899230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.24895000457764 / seconds
Query Executed:select id FROM `sd` where city='Dallas' && SIC_code='0742'DB:business_master_new
loadtime:0.25004911422729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.25011491775513 / seconds
Query Executed:select id FROM `sd` where city='Dante' && SIC_code='0742'DB:business_master_new
loadtime:0.25076103210449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.2508180141449 / seconds
Query Executed:select id FROM `sd` where city='Davis' && SIC_code='0742'DB:business_master_new
loadtime:0.2526490688324 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Smet' limit 1
loadtime:0.25273704528809 / seconds
Query Executed:select id FROM `sd` where city='De Smet' && SIC_code='0742'DB:business_master_new
loadtime:0.2558650970459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deadwood' limit 1
loadtime:0.25594401359558 / seconds
Query Executed:select id FROM `sd` where city='Deadwood' && SIC_code='0742'DB:business_master_new
loadtime:0.2583179473877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dell Rapids' limit 1
loadtime:0.25839114189148 / seconds
Query Executed:select id FROM `sd` where city='Dell Rapids' && SIC_code='0742'DB:business_master_new
loadtime:0.26079297065735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:0.26086211204529 / seconds
Query Executed:select id FROM `sd` where city='Delmont' && SIC_code='0742'DB:business_master_new
loadtime:0.26225614547729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimock' limit 1
loadtime:0.2623119354248 / seconds
Query Executed:select id FROM `sd` where city='Dimock' && SIC_code='0742'DB:business_master_new
loadtime:0.26345109939575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doland' limit 1
loadtime:0.26350402832031 / seconds
Query Executed:select id FROM `sd` where city='Doland' && SIC_code='0742'DB:business_master_new
loadtime:0.26471710205078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolton' limit 1
loadtime:0.26477599143982 / seconds
Query Executed:select id FROM `sd` where city='Dolton' && SIC_code='0742'DB:business_master_new
loadtime:0.26532292366028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.26537895202637 / seconds
Query Executed:select id FROM `sd` where city='Draper' && SIC_code='0742'DB:business_master_new
loadtime:0.26615715026855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupree' limit 1
loadtime:0.2662091255188 / seconds
Query Executed:select id FROM `sd` where city='Dupree' && SIC_code='0742'DB:business_master_new
loadtime:0.26775193214417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Butte' limit 1
loadtime:0.26780700683594 / seconds
Query Executed:select id FROM `sd` where city='Eagle Butte' && SIC_code='0742'DB:business_master_new
loadtime:0.27016997337341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.27022314071655 / seconds
Query Executed:select id FROM `sd` where city='Eden' && SIC_code='0742'DB:business_master_new
loadtime:0.27096509933472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemont' limit 1
loadtime:0.27101898193359 / seconds
Query Executed:select id FROM `sd` where city='Edgemont' && SIC_code='0742'DB:business_master_new
loadtime:0.27281093597412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egan' limit 1
loadtime:0.27288007736206 / seconds
Query Executed:select id FROM `sd` where city='Egan' && SIC_code='0742'DB:business_master_new
loadtime:0.27360892295837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Point' limit 1
loadtime:0.27367115020752 / seconds
Query Executed:select id FROM `sd` where city='Elk Point' && SIC_code='0742'DB:business_master_new
loadtime:0.27661800384521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.27667307853699 / seconds
Query Executed:select id FROM `sd` where city='Elkton' && SIC_code='0742'DB:business_master_new
loadtime:0.27888894081116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth Afb' limit 1
loadtime:0.27894592285156 / seconds
Query Executed:select id FROM `sd` where city='Ellsworth Afb' && SIC_code='0742'DB:business_master_new
loadtime:0.28007006645203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Springs' limit 1
loadtime:0.28012299537659 / seconds
Query Executed:select id FROM `sd` where city='Elm Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.2805061340332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.28055906295776 / seconds
Query Executed:select id FROM `sd` where city='Emery' && SIC_code='0742'DB:business_master_new
loadtime:0.28209614753723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enning' limit 1
loadtime:0.28215312957764 / seconds
Query Executed:select id FROM `sd` where city='Enning' && SIC_code='0742'DB:business_master_new
loadtime:0.28270101547241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.28276205062866 / seconds
Query Executed:select id FROM `sd` where city='Erwin' && SIC_code='0742'DB:business_master_new
loadtime:0.28333401679993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estelline' limit 1
loadtime:0.28338599205017 / seconds
Query Executed:select id FROM `sd` where city='Estelline' && SIC_code='0742'DB:business_master_new
loadtime:0.28536891937256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethan' limit 1
loadtime:0.28542304039001 / seconds
Query Executed:select id FROM `sd` where city='Ethan' && SIC_code='0742'DB:business_master_new
loadtime:0.2868800163269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.28693413734436 / seconds
Query Executed:select id FROM `sd` where city='Eureka' && SIC_code='0742'DB:business_master_new
loadtime:0.28946495056152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairburn' limit 1
loadtime:0.2895359992981 / seconds
Query Executed:select id FROM `sd` where city='Fairburn' && SIC_code='0742'DB:business_master_new
loadtime:0.28998112678528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.29003596305847 / seconds
Query Executed:select id FROM `sd` where city='Fairfax' && SIC_code='0742'DB:business_master_new
loadtime:0.29074096679688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.29080009460449 / seconds
Query Executed:select id FROM `sd` where city='Fairview' && SIC_code='0742'DB:business_master_new
loadtime:0.29126596450806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.29132199287415 / seconds
Query Executed:select id FROM `sd` where city='Faith' && SIC_code='0742'DB:business_master_new
loadtime:0.29340696334839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faulkton' limit 1
loadtime:0.29348206520081 / seconds
Query Executed:select id FROM `sd` where city='Faulkton' && SIC_code='0742'DB:business_master_new
loadtime:0.29625511169434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fedora' limit 1
loadtime:0.29632210731506 / seconds
Query Executed:select id FROM `sd` where city='Fedora' && SIC_code='0742'DB:business_master_new
loadtime:0.29697608947754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferney' limit 1
loadtime:0.29703092575073 / seconds
Query Executed:select id FROM `sd` where city='Ferney' && SIC_code='0742'DB:business_master_new
loadtime:0.29752492904663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firesteel' limit 1
loadtime:0.29757714271545 / seconds
Query Executed:select id FROM `sd` where city='Firesteel' && SIC_code='0742'DB:business_master_new
loadtime:0.29801607131958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flandreau' limit 1
loadtime:0.29806900024414 / seconds
Query Executed:select id FROM `sd` where city='Flandreau' && SIC_code='0742'DB:business_master_new
loadtime:0.30044507980347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.30051398277283 / seconds
Query Executed:select id FROM `sd` where city='Florence' && SIC_code='0742'DB:business_master_new
loadtime:0.30170893669128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestburg' limit 1
loadtime:0.30176401138306 / seconds
Query Executed:select id FROM `sd` where city='Forestburg' && SIC_code='0742'DB:business_master_new
loadtime:0.30219197273254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Meade' limit 1
loadtime:0.30224394798279 / seconds
Query Executed:select id FROM `sd` where city='Fort Meade' && SIC_code='0742'DB:business_master_new
loadtime:0.30280494689941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Pierre' limit 1
loadtime:0.30285906791687 / seconds
Query Executed:select id FROM `sd` where city='Fort Pierre' && SIC_code='0742'DB:business_master_new
loadtime:0.30523109436035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thompson' limit 1
loadtime:0.30529999732971 / seconds
Query Executed:select id FROM `sd` where city='Fort Thompson' && SIC_code='0742'DB:business_master_new
loadtime:0.30690097808838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.30695605278015 / seconds
Query Executed:select id FROM `sd` where city='Frankfort' && SIC_code='0742'DB:business_master_new
loadtime:0.30766701698303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.30771994590759 / seconds
Query Executed:select id FROM `sd` where city='Frederick' && SIC_code='0742'DB:business_master_new
loadtime:0.30890107154846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.30896902084351 / seconds
Query Executed:select id FROM `sd` where city='Freeman' && SIC_code='0742'DB:business_master_new
loadtime:0.31213808059692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitdale' limit 1
loadtime:0.3122079372406 / seconds
Query Executed:select id FROM `sd` where city='Fruitdale' && SIC_code='0742'DB:business_master_new
loadtime:0.31257891654968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.31264305114746 / seconds
Query Executed:select id FROM `sd` where city='Fulton' && SIC_code='0742'DB:business_master_new
loadtime:0.31325101852417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gann Valley' limit 1
loadtime:0.31330800056458 / seconds
Query Executed:select id FROM `sd` where city='Gann Valley' && SIC_code='0742'DB:business_master_new
loadtime:0.31395792961121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.31401109695435 / seconds
Query Executed:select id FROM `sd` where city='Garden City' && SIC_code='0742'DB:business_master_new
loadtime:0.31458806991577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garretson' limit 1
loadtime:0.31464910507202 / seconds
Query Executed:select id FROM `sd` where city='Garretson' && SIC_code='0742'DB:business_master_new
loadtime:0.3175151348114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gary' limit 1
loadtime:0.31756711006165 / seconds
Query Executed:select id FROM `sd` where city='Gary' && SIC_code='0742'DB:business_master_new
loadtime:0.31905603408813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gayville' limit 1
loadtime:0.31911110877991 / seconds
Query Executed:select id FROM `sd` where city='Gayville' && SIC_code='0742'DB:business_master_new
loadtime:0.32019996643066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geddes' limit 1
loadtime:0.32025814056396 / seconds
Query Executed:select id FROM `sd` where city='Geddes' && SIC_code='0742'DB:business_master_new
loadtime:0.32163596153259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gettysburg' limit 1
loadtime:0.32168912887573 / seconds
Query Executed:select id FROM `sd` where city='Gettysburg' && SIC_code='0742'DB:business_master_new
loadtime:0.32455611228943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glad Valley' limit 1
loadtime:0.32461905479431 / seconds
Query Executed:select id FROM `sd` where city='Glad Valley' && SIC_code='0742'DB:business_master_new
loadtime:0.32501196861267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencross' limit 1
loadtime:0.32506394386292 / seconds
Query Executed:select id FROM `sd` where city='Glencross' && SIC_code='0742'DB:business_master_new
loadtime:0.32549715042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenham' limit 1
loadtime:0.32555413246155 / seconds
Query Executed:select id FROM `sd` where city='Glenham' && SIC_code='0742'DB:business_master_new
loadtime:0.32656097412109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodwin' limit 1
loadtime:0.32662296295166 / seconds
Query Executed:select id FROM `sd` where city='Goodwin' && SIC_code='0742'DB:business_master_new
loadtime:0.32771897315979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:0.32777094841003 / seconds
Query Executed:select id FROM `sd` where city='Gregory' && SIC_code='0742'DB:business_master_new
loadtime:0.33012199401855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.33018803596497 / seconds
Query Executed:select id FROM `sd` where city='Grenville' && SIC_code='0742'DB:business_master_new
loadtime:0.33084106445312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.3308961391449 / seconds
Query Executed:select id FROM `sd` where city='Groton' && SIC_code='0742'DB:business_master_new
loadtime:0.33351802825928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamill' limit 1
loadtime:0.33358407020569 / seconds
Query Executed:select id FROM `sd` where city='Hamill' && SIC_code='0742'DB:business_master_new
loadtime:0.33423399925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.33429312705994 / seconds
Query Executed:select id FROM `sd` where city='Harrisburg' && SIC_code='0742'DB:business_master_new
loadtime:0.33666610717773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:0.33673501014709 / seconds
Query Executed:select id FROM `sd` where city='Harrison' && SIC_code='0742'DB:business_master_new
loadtime:0.33754110336304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrold' limit 1
loadtime:0.3375940322876 / seconds
Query Executed:select id FROM `sd` where city='Harrold' && SIC_code='0742'DB:business_master_new
loadtime:0.3389139175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.33896708488464 / seconds
Query Executed:select id FROM `sd` where city='Hartford' && SIC_code='0742'DB:business_master_new
loadtime:0.34128999710083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.34134793281555 / seconds
Query Executed:select id FROM `sd` where city='Hayes' && SIC_code='0742'DB:business_master_new
loadtime:0.34192514419556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayti' limit 1
loadtime:0.3419771194458 / seconds
Query Executed:select id FROM `sd` where city='Hayti' && SIC_code='0742'DB:business_master_new
loadtime:0.34373712539673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel' limit 1
loadtime:0.34378910064697 / seconds
Query Executed:select id FROM `sd` where city='Hazel' && SIC_code='0742'DB:business_master_new
loadtime:0.34485411643982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hecla' limit 1
loadtime:0.34491109848022 / seconds
Query Executed:select id FROM `sd` where city='Hecla' && SIC_code='0742'DB:business_master_new
loadtime:0.34633994102478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.34639310836792 / seconds
Query Executed:select id FROM `sd` where city='Henry' && SIC_code='0742'DB:business_master_new
loadtime:0.34746909141541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermosa' limit 1
loadtime:0.34752798080444 / seconds
Query Executed:select id FROM `sd` where city='Hermosa' && SIC_code='0742'DB:business_master_new
loadtime:0.34915709495544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herreid' limit 1
loadtime:0.34921407699585 / seconds
Query Executed:select id FROM `sd` where city='Herreid' && SIC_code='0742'DB:business_master_new
loadtime:0.35102510452271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herrick' limit 1
loadtime:0.3510799407959 / seconds
Query Executed:select id FROM `sd` where city='Herrick' && SIC_code='0742'DB:business_master_new
loadtime:0.35176014900208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hetland' limit 1
loadtime:0.35181403160095 / seconds
Query Executed:select id FROM `sd` where city='Hetland' && SIC_code='0742'DB:business_master_new
loadtime:0.35219097137451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highmore' limit 1
loadtime:0.35224413871765 / seconds
Query Executed:select id FROM `sd` where city='Highmore' && SIC_code='0742'DB:business_master_new
loadtime:0.35499405860901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill City' limit 1
loadtime:0.35506391525269 / seconds
Query Executed:select id FROM `sd` where city='Hill City' && SIC_code='0742'DB:business_master_new
loadtime:0.35822415351868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hitchcock' limit 1
loadtime:0.35827898979187 / seconds
Query Executed:select id FROM `sd` where city='Hitchcock' && SIC_code='0742'DB:business_master_new
loadtime:0.359619140625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holabird' limit 1
loadtime:0.35967302322388 / seconds
Query Executed:select id FROM `sd` where city='Holabird' && SIC_code='0742'DB:business_master_new
loadtime:0.36020112037659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hosmer' limit 1
loadtime:0.36025214195251 / seconds
Query Executed:select id FROM `sd` where city='Hosmer' && SIC_code='0742'DB:business_master_new
loadtime:0.36137008666992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.36143898963928 / seconds
Query Executed:select id FROM `sd` where city='Hot Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.36381101608276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.36387991905212 / seconds
Query Executed:select id FROM `sd` where city='Houghton' && SIC_code='0742'DB:business_master_new
loadtime:0.36453914642334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoven' limit 1
loadtime:0.36459302902222 / seconds
Query Executed:select id FROM `sd` where city='Hoven' && SIC_code='0742'DB:business_master_new
loadtime:0.3664219379425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.3664870262146 / seconds
Query Executed:select id FROM `sd` where city='Howard' && SIC_code='0742'DB:business_master_new
loadtime:0.36949014663696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howes' limit 1
loadtime:0.3695650100708 / seconds
Query Executed:select id FROM `sd` where city='Howes' && SIC_code='0742'DB:business_master_new
loadtime:0.37012505531311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.37017798423767 / seconds
Query Executed:select id FROM `sd` where city='Hudson' && SIC_code='0742'DB:business_master_new
loadtime:0.37124395370483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.37129712104797 / seconds
Query Executed:select id FROM `sd` where city='Humboldt' && SIC_code='0742'DB:business_master_new
loadtime:0.37296509742737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.37302303314209 / seconds
Query Executed:select id FROM `sd` where city='Hurley' && SIC_code='0742'DB:business_master_new
loadtime:0.3746509552002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huron' limit 1
loadtime:0.37470507621765 / seconds
Query Executed:select id FROM `sd` where city='Huron' && SIC_code='0742'DB:business_master_new
loadtime:0.37707710266113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ideal' limit 1
loadtime:0.37715005874634 / seconds
Query Executed:select id FROM `sd` where city='Ideal' && SIC_code='0742'DB:business_master_new
loadtime:0.37765312194824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Igloo' limit 1
loadtime:0.37770700454712 / seconds
Query Executed:select id FROM `sd` where city='Igloo' && SIC_code='0742'DB:business_master_new
loadtime:0.37811398506165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interior' limit 1
loadtime:0.37816596031189 / seconds
Query Executed:select id FROM `sd` where city='Interior' && SIC_code='0742'DB:business_master_new
loadtime:0.37893915176392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:0.37899208068848 / seconds
Query Executed:select id FROM `sd` where city='Ipswich' && SIC_code='0742'DB:business_master_new
loadtime:0.38175010681152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irene' limit 1
loadtime:0.3818039894104 / seconds
Query Executed:select id FROM `sd` where city='Irene' && SIC_code='0742'DB:business_master_new
loadtime:0.38353300094604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iroquois' limit 1
loadtime:0.38358807563782 / seconds
Query Executed:select id FROM `sd` where city='Iroquois' && SIC_code='0742'DB:business_master_new
loadtime:0.38475108146667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isabel' limit 1
loadtime:0.38480496406555 / seconds
Query Executed:select id FROM `sd` where city='Isabel' && SIC_code='0742'DB:business_master_new
loadtime:0.38594198226929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.38599514961243 / seconds
Query Executed:select id FROM `sd` where city='Java' && SIC_code='0742'DB:business_master_new
loadtime:0.38673114776611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.38678407669067 / seconds
Query Executed:select id FROM `sd` where city='Jefferson' && SIC_code='0742'DB:business_master_new
loadtime:0.38837814331055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kadoka' limit 1
loadtime:0.38843107223511 / seconds
Query Executed:select id FROM `sd` where city='Kadoka' && SIC_code='0742'DB:business_master_new
loadtime:0.39100408554077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaylor' limit 1
loadtime:0.3910801410675 / seconds
Query Executed:select id FROM `sd` where city='Kaylor' && SIC_code='0742'DB:business_master_new
loadtime:0.39162111282349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keldron' limit 1
loadtime:0.39167499542236 / seconds
Query Executed:select id FROM `sd` where city='Keldron' && SIC_code='0742'DB:business_master_new
loadtime:0.39219212532043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennebec' limit 1
loadtime:0.39224410057068 / seconds
Query Executed:select id FROM `sd` where city='Kennebec' && SIC_code='0742'DB:business_master_new
loadtime:0.3938729763031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.39392614364624 / seconds
Query Executed:select id FROM `sd` where city='Keystone' && SIC_code='0742'DB:business_master_new
loadtime:0.39607310295105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:0.39612698554993 / seconds
Query Executed:select id FROM `sd` where city='Kimball' && SIC_code='0742'DB:business_master_new
loadtime:0.39840292930603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kranzburg' limit 1
loadtime:0.39848303794861 / seconds
Query Executed:select id FROM `sd` where city='Kranzburg' && SIC_code='0742'DB:business_master_new
loadtime:0.39900708198547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kyle' limit 1
loadtime:0.39906096458435 / seconds
Query Executed:select id FROM `sd` where city='Kyle' && SIC_code='0742'DB:business_master_new
loadtime:0.40005803108215 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plant' limit 1
loadtime:0.40011096000671 / seconds
Query Executed:select id FROM `sd` where city='La Plant' && SIC_code='0742'DB:business_master_new
loadtime:0.40057396888733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Labolt' limit 1
loadtime:0.4006359577179 / seconds
Query Executed:select id FROM `sd` where city='Labolt' && SIC_code='0742'DB:business_master_new
loadtime:0.40119194984436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Andes' limit 1
loadtime:0.4012439250946 / seconds
Query Executed:select id FROM `sd` where city='Lake Andes' && SIC_code='0742'DB:business_master_new
loadtime:0.40359306335449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.4036819934845 / seconds
Query Executed:select id FROM `sd` where city='Lake City' && SIC_code='0742'DB:business_master_new
loadtime:0.40425705909729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Norden' limit 1
loadtime:0.40431594848633 / seconds
Query Executed:select id FROM `sd` where city='Lake Norden' && SIC_code='0742'DB:business_master_new
loadtime:0.40594911575317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Preston' limit 1
loadtime:0.4060070514679 / seconds
Query Executed:select id FROM `sd` where city='Lake Preston' && SIC_code='0742'DB:business_master_new
loadtime:0.4078049659729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.40785813331604 / seconds
Query Executed:select id FROM `sd` where city='Lane' && SIC_code='0742'DB:business_master_new
loadtime:0.40827012062073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langford' limit 1
loadtime:0.40832614898682 / seconds
Query Executed:select id FROM `sd` where city='Langford' && SIC_code='0742'DB:business_master_new
loadtime:0.40929794311523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lantry' limit 1
loadtime:0.40935111045837 / seconds
Query Executed:select id FROM `sd` where city='Lantry' && SIC_code='0742'DB:business_master_new
loadtime:0.40983295440674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lead' limit 1
loadtime:0.40988612174988 / seconds
Query Executed:select id FROM `sd` where city='Lead' && SIC_code='0742'DB:business_master_new
loadtime:0.4127459526062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.41281199455261 / seconds
Query Executed:select id FROM `sd` where city='Lebanon' && SIC_code='0742'DB:business_master_new
loadtime:0.41348099708557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemmon' limit 1
loadtime:0.41353511810303 / seconds
Query Executed:select id FROM `sd` where city='Lemmon' && SIC_code='0742'DB:business_master_new
loadtime:0.41662812232971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennox' limit 1
loadtime:0.41668105125427 / seconds
Query Executed:select id FROM `sd` where city='Lennox' && SIC_code='0742'DB:business_master_new
loadtime:0.41972899436951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leola' limit 1
loadtime:0.41979598999023 / seconds
Query Executed:select id FROM `sd` where city='Leola' && SIC_code='0742'DB:business_master_new
loadtime:0.42167210578918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lesterville' limit 1
loadtime:0.42172598838806 / seconds
Query Executed:select id FROM `sd` where city='Lesterville' && SIC_code='0742'DB:business_master_new
loadtime:0.42255806922913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letcher' limit 1
loadtime:0.42262101173401 / seconds
Query Executed:select id FROM `sd` where city='Letcher' && SIC_code='0742'DB:business_master_new
loadtime:0.42405700683594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Eagle' limit 1
loadtime:0.42411708831787 / seconds
Query Executed:select id FROM `sd` where city='Little Eagle' && SIC_code='0742'DB:business_master_new
loadtime:0.42458510398865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodgepole' limit 1
loadtime:0.4246461391449 / seconds
Query Executed:select id FROM `sd` where city='Lodgepole' && SIC_code='0742'DB:business_master_new
loadtime:0.42517113685608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:0.42522692680359 / seconds
Query Executed:select id FROM `sd` where city='Long Valley' && SIC_code='0742'DB:business_master_new
loadtime:0.42578792572021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longlake' limit 1
loadtime:0.42584204673767 / seconds
Query Executed:select id FROM `sd` where city='Longlake' && SIC_code='0742'DB:business_master_new
loadtime:0.42623996734619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longvalley' limit 1
loadtime:0.42629814147949 / seconds
Query Executed:select id FROM `sd` where city='Longvalley' && SIC_code='0742'DB:business_master_new
loadtime:0.42674207687378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Brule' limit 1
loadtime:0.42679500579834 / seconds
Query Executed:select id FROM `sd` where city='Lower Brule' && SIC_code='0742'DB:business_master_new
loadtime:0.42853903770447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.42859196662903 / seconds
Query Executed:select id FROM `sd` where city='Lowry' && SIC_code='0742'DB:business_master_new
loadtime:0.42898607254028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.429044008255 / seconds
Query Executed:select id FROM `sd` where city='Ludlow' && SIC_code='0742'DB:business_master_new
loadtime:0.42960596084595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.42965912818909 / seconds
Query Executed:select id FROM `sd` where city='Lyons' && SIC_code='0742'DB:business_master_new
loadtime:0.43019199371338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.43024897575378 / seconds
Query Executed:select id FROM `sd` where city='Madison' && SIC_code='0742'DB:business_master_new
loadtime:0.43264698982239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manderson' limit 1
loadtime:0.43272113800049 / seconds
Query Executed:select id FROM `sd` where city='Manderson' && SIC_code='0742'DB:business_master_new
loadtime:0.43326997756958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:0.43332195281982 / seconds
Query Executed:select id FROM `sd` where city='Mansfield' && SIC_code='0742'DB:business_master_new
loadtime:0.43405604362488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.43410897254944 / seconds
Query Executed:select id FROM `sd` where city='Marion' && SIC_code='0742'DB:business_master_new
loadtime:0.43632507324219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.43639397621155 / seconds
Query Executed:select id FROM `sd` where city='Martin' && SIC_code='0742'DB:business_master_new
loadtime:0.43894600868225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marty' limit 1
loadtime:0.43901395797729 / seconds
Query Executed:select id FROM `sd` where city='Marty' && SIC_code='0742'DB:business_master_new
loadtime:0.43961906433105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvin' limit 1
loadtime:0.43967413902283 / seconds
Query Executed:select id FROM `sd` where city='Marvin' && SIC_code='0742'DB:business_master_new
loadtime:0.44014811515808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.44019913673401 / seconds
Query Executed:select id FROM `sd` where city='Mc Intosh' && SIC_code='0742'DB:business_master_new
loadtime:0.44123411178589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Laughlin' limit 1
loadtime:0.44128704071045 / seconds
Query Executed:select id FROM `sd` where city='Mc Laughlin' && SIC_code='0742'DB:business_master_new
loadtime:0.44344902038574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.44351506233215 / seconds
Query Executed:select id FROM `sd` where city='Meadow' && SIC_code='0742'DB:business_master_new
loadtime:0.44431209564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meckling' limit 1
loadtime:0.44436502456665 / seconds
Query Executed:select id FROM `sd` where city='Meckling' && SIC_code='0742'DB:business_master_new
loadtime:0.44478702545166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellette' limit 1
loadtime:0.44484114646912 / seconds
Query Executed:select id FROM `sd` where city='Mellette' && SIC_code='0742'DB:business_master_new
loadtime:0.44571495056152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menno' limit 1
loadtime:0.44576692581177 / seconds
Query Executed:select id FROM `sd` where city='Menno' && SIC_code='0742'DB:business_master_new
loadtime:0.44808793067932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.44815397262573 / seconds
Query Executed:select id FROM `sd` where city='Midland' && SIC_code='0742'DB:business_master_new
loadtime:0.44934105873108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milbank' limit 1
loadtime:0.44939494132996 / seconds
Query Executed:select id FROM `sd` where city='Milbank' && SIC_code='0742'DB:business_master_new
loadtime:0.45501613616943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milesville' limit 1
loadtime:0.45508193969727 / seconds
Query Executed:select id FROM `sd` where city='Milesville' && SIC_code='0742'DB:business_master_new
loadtime:0.45570397377014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miller' limit 1
loadtime:0.45577096939087 / seconds
Query Executed:select id FROM `sd` where city='Miller' && SIC_code='0742'DB:business_master_new
loadtime:0.45938801765442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mina' limit 1
loadtime:0.45946097373962 / seconds
Query Executed:select id FROM `sd` where city='Mina' && SIC_code='0742'DB:business_master_new
loadtime:0.45991110801697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miranda' limit 1
loadtime:0.45997095108032 / seconds
Query Executed:select id FROM `sd` where city='Miranda' && SIC_code='0742'DB:business_master_new
loadtime:0.46036601066589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission' limit 1
loadtime:0.46042203903198 / seconds
Query Executed:select id FROM `sd` where city='Mission' && SIC_code='0742'DB:business_master_new
loadtime:0.46304702758789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission Hill' limit 1
loadtime:0.46309995651245 / seconds
Query Executed:select id FROM `sd` where city='Mission Hill' && SIC_code='0742'DB:business_master_new
loadtime:0.46395611763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.46401500701904 / seconds
Query Executed:select id FROM `sd` where city='Mitchell' && SIC_code='0742'DB:business_master_new
loadtime:0.46640396118164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mobridge' limit 1
loadtime:0.46648192405701 / seconds
Query Executed:select id FROM `sd` where city='Mobridge' && SIC_code='0742'DB:business_master_new
loadtime:0.47134494781494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.47141408920288 / seconds
Query Executed:select id FROM `sd` where city='Monroe' && SIC_code='0742'DB:business_master_new
loadtime:0.47209811210632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.47215294837952 / seconds
Query Executed:select id FROM `sd` where city='Montrose' && SIC_code='0742'DB:business_master_new
loadtime:0.47334814071655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.47341394424438 / seconds
Query Executed:select id FROM `sd` where city='Morristown' && SIC_code='0742'DB:business_master_new
loadtime:0.47402906417847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound City' limit 1
loadtime:0.4740879535675 / seconds
Query Executed:select id FROM `sd` where city='Mound City' && SIC_code='0742'DB:business_master_new
loadtime:0.47484493255615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.47490310668945 / seconds
Query Executed:select id FROM `sd` where city='Mount Vernon' && SIC_code='0742'DB:business_master_new
loadtime:0.47641897201538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.47647714614868 / seconds
Query Executed:select id FROM `sd` where city='Mt Vernon' && SIC_code='0742'DB:business_master_new
loadtime:0.4768979549408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mud Butte' limit 1
loadtime:0.47694993019104 / seconds
Query Executed:select id FROM `sd` where city='Mud Butte' && SIC_code='0742'DB:business_master_new
loadtime:0.47745394706726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murdo' limit 1
loadtime:0.4775059223175 / seconds
Query Executed:select id FROM `sd` where city='Murdo' && SIC_code='0742'DB:business_master_new
loadtime:0.47967314720154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemo' limit 1
loadtime:0.47974991798401 / seconds
Query Executed:select id FROM `sd` where city='Nemo' && SIC_code='0742'DB:business_master_new
loadtime:0.48029112815857 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Effington' limit 1
loadtime:0.48034405708313 / seconds
Query Executed:select id FROM `sd` where city='New Effington' && SIC_code='0742'DB:business_master_new
loadtime:0.48139214515686 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holland' limit 1
loadtime:0.4814510345459 / seconds
Query Executed:select id FROM `sd` where city='New Holland' && SIC_code='0742'DB:business_master_new
loadtime:0.48203897476196 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Underwood' limit 1
loadtime:0.4820921421051 / seconds
Query Executed:select id FROM `sd` where city='New Underwood' && SIC_code='0742'DB:business_master_new
loadtime:0.48326301574707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.48331594467163 / seconds
Query Executed:select id FROM `sd` where city='Newell' && SIC_code='0742'DB:business_master_new
loadtime:0.48509907722473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisland' limit 1
loadtime:0.48516702651978 / seconds
Query Executed:select id FROM `sd` where city='Nisland' && SIC_code='0742'DB:business_master_new
loadtime:0.48587203025818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.4859299659729 / seconds
Query Executed:select id FROM `sd` where city='Norris' && SIC_code='0742'DB:business_master_new
loadtime:0.4864821434021 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sioux City' limit 1
loadtime:0.48653507232666 / seconds
Query Executed:select id FROM `sd` where city='North Sioux City' && SIC_code='0742'DB:business_master_new
loadtime:0.49116206169128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:0.4912281036377 / seconds
Query Executed:select id FROM `sd` where city='Northville' && SIC_code='0742'DB:business_master_new
loadtime:0.49203109741211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunda' limit 1
loadtime:0.49208498001099 / seconds
Query Executed:select id FROM `sd` where city='Nunda' && SIC_code='0742'DB:business_master_new
loadtime:0.4927179813385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oacoma' limit 1
loadtime:0.49277114868164 / seconds
Query Executed:select id FROM `sd` where city='Oacoma' && SIC_code='0742'DB:business_master_new
loadtime:0.49356913566589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelrichs' limit 1
loadtime:0.49362993240356 / seconds
Query Executed:select id FROM `sd` where city='Oelrichs' && SIC_code='0742'DB:business_master_new
loadtime:0.49428606033325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oglala' limit 1
loadtime:0.49433708190918 / seconds
Query Executed:select id FROM `sd` where city='Oglala' && SIC_code='0742'DB:business_master_new
loadtime:0.49490904808044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okaton' limit 1
loadtime:0.49496102333069 / seconds
Query Executed:select id FROM `sd` where city='Okaton' && SIC_code='0742'DB:business_master_new
loadtime:0.49540305137634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okreek' limit 1
loadtime:0.49546194076538 / seconds
Query Executed:select id FROM `sd` where city='Okreek' && SIC_code='0742'DB:business_master_new
loadtime:0.49588704109192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldham' limit 1
loadtime:0.49593806266785 / seconds
Query Executed:select id FROM `sd` where city='Oldham' && SIC_code='0742'DB:business_master_new
loadtime:0.49683094024658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:0.49691200256348 / seconds
Query Executed:select id FROM `sd` where city='Olivet' && SIC_code='0742'DB:business_master_new
loadtime:0.4978461265564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaka' limit 1
loadtime:0.49792909622192 / seconds
Query Executed:select id FROM `sd` where city='Onaka' && SIC_code='0742'DB:business_master_new
loadtime:0.49863600730896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onida' limit 1
loadtime:0.49871110916138 / seconds
Query Executed:select id FROM `sd` where city='Onida' && SIC_code='0742'DB:business_master_new
loadtime:0.50172305107117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opal' limit 1
loadtime:0.50178098678589 / seconds
Query Executed:select id FROM `sd` where city='Opal' && SIC_code='0742'DB:business_master_new
loadtime:0.50230503082275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oral' limit 1
loadtime:0.502357006073 / seconds
Query Executed:select id FROM `sd` where city='Oral' && SIC_code='0742'DB:business_master_new
loadtime:0.5031521320343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.50320601463318 / seconds
Query Executed:select id FROM `sd` where city='Orient' && SIC_code='0742'DB:business_master_new
loadtime:0.50445008277893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortley' limit 1
loadtime:0.50450801849365 / seconds
Query Executed:select id FROM `sd` where city='Ortley' && SIC_code='0742'DB:business_master_new
loadtime:0.5052649974823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owanka' limit 1
loadtime:0.50531792640686 / seconds
Query Executed:select id FROM `sd` where city='Owanka' && SIC_code='0742'DB:business_master_new
loadtime:0.50606799125671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.50612497329712 / seconds
Query Executed:select id FROM `sd` where city='Parker' && SIC_code='0742'DB:business_master_new
loadtime:0.51040410995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkston' limit 1
loadtime:0.51047897338867 / seconds
Query Executed:select id FROM `sd` where city='Parkston' && SIC_code='0742'DB:business_master_new
loadtime:0.51371097564697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmelee' limit 1
loadtime:0.51377105712891 / seconds
Query Executed:select id FROM `sd` where city='Parmelee' && SIC_code='0742'DB:business_master_new
loadtime:0.51437711715698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peever' limit 1
loadtime:0.51443409919739 / seconds
Query Executed:select id FROM `sd` where city='Peever' && SIC_code='0742'DB:business_master_new
loadtime:0.51517200469971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philip' limit 1
loadtime:0.51522397994995 / seconds
Query Executed:select id FROM `sd` where city='Philip' && SIC_code='0742'DB:business_master_new
loadtime:0.51804614067078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickstown' limit 1
loadtime:0.51811504364014 / seconds
Query Executed:select id FROM `sd` where city='Pickstown' && SIC_code='0742'DB:business_master_new
loadtime:0.51891493797302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.51897001266479 / seconds
Query Executed:select id FROM `sd` where city='Piedmont' && SIC_code='0742'DB:business_master_new
loadtime:0.52127504348755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierpont' limit 1
loadtime:0.52133512496948 / seconds
Query Executed:select id FROM `sd` where city='Pierpont' && SIC_code='0742'DB:business_master_new
loadtime:0.52198004722595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierre' limit 1
loadtime:0.52203297615051 / seconds
Query Executed:select id FROM `sd` where city='Pierre' && SIC_code='0742'DB:business_master_new
loadtime:0.52451610565186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Ridge' limit 1
loadtime:0.52459311485291 / seconds
Query Executed:select id FROM `sd` where city='Pine Ridge' && SIC_code='0742'DB:business_master_new
loadtime:0.52754092216492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plankinton' limit 1
loadtime:0.52759599685669 / seconds
Query Executed:select id FROM `sd` where city='Plankinton' && SIC_code='0742'DB:business_master_new
loadtime:0.52994513511658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platte' limit 1
loadtime:0.53001308441162 / seconds
Query Executed:select id FROM `sd` where city='Platte' && SIC_code='0742'DB:business_master_new
loadtime:0.53475713729858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollock' limit 1
loadtime:0.53482913970947 / seconds
Query Executed:select id FROM `sd` where city='Pollock' && SIC_code='0742'DB:business_master_new
loadtime:0.53589391708374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porcupine' limit 1
loadtime:0.53594899177551 / seconds
Query Executed:select id FROM `sd` where city='Porcupine' && SIC_code='0742'DB:business_master_new
loadtime:0.53677010536194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.5368230342865 / seconds
Query Executed:select id FROM `sd` where city='Prairie City' && SIC_code='0742'DB:business_master_new
loadtime:0.53752994537354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presho' limit 1
loadtime:0.53758502006531 / seconds
Query Executed:select id FROM `sd` where city='Presho' && SIC_code='0742'DB:business_master_new
loadtime:0.5396249294281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pringle' limit 1
loadtime:0.5396831035614 / seconds
Query Executed:select id FROM `sd` where city='Pringle' && SIC_code='0742'DB:business_master_new
loadtime:0.54026007652283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukwana' limit 1
loadtime:0.54031109809875 / seconds
Query Executed:select id FROM `sd` where city='Pukwana' && SIC_code='0742'DB:business_master_new
loadtime:0.5414559841156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinn' limit 1
loadtime:0.54151010513306 / seconds
Query Executed:select id FROM `sd` where city='Quinn' && SIC_code='0742'DB:business_master_new
loadtime:0.54206800460815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:0.54212093353271 / seconds
Query Executed:select id FROM `sd` where city='Ralph' && SIC_code='0742'DB:business_master_new
loadtime:0.54261493682861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramona' limit 1
loadtime:0.54266810417175 / seconds
Query Executed:select id FROM `sd` where city='Ramona' && SIC_code='0742'DB:business_master_new
loadtime:0.54358410835266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:0.54364514350891 / seconds
Query Executed:select id FROM `sd` where city='Rapid City' && SIC_code='0742'DB:business_master_new
loadtime:0.54603314399719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravinia' limit 1
loadtime:0.54611992835999 / seconds
Query Executed:select id FROM `sd` where city='Ravinia' && SIC_code='0742'DB:business_master_new
loadtime:0.54652214050293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.54657697677612 / seconds
Query Executed:select id FROM `sd` where city='Raymond' && SIC_code='0742'DB:business_master_new
loadtime:0.54720902442932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Owl' limit 1
loadtime:0.54726696014404 / seconds
Query Executed:select id FROM `sd` where city='Red Owl' && SIC_code='0742'DB:business_master_new
loadtime:0.5476701259613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.54772305488586 / seconds
Query Executed:select id FROM `sd` where city='Redfield' && SIC_code='0742'DB:business_master_new
loadtime:0.55166411399841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redig' limit 1
loadtime:0.55173301696777 / seconds
Query Executed:select id FROM `sd` where city='Redig' && SIC_code='0742'DB:business_master_new
loadtime:0.5522141456604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ree Heights' limit 1
loadtime:0.55227303504944 / seconds
Query Executed:select id FROM `sd` where city='Ree Heights' && SIC_code='0742'DB:business_master_new
loadtime:0.55302596092224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.5530800819397 / seconds
Query Executed:select id FROM `sd` where city='Reliance' && SIC_code='0742'DB:business_master_new
loadtime:0.5541090965271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renner' limit 1
loadtime:0.55416297912598 / seconds
Query Executed:select id FROM `sd` where city='Renner' && SIC_code='0742'DB:business_master_new
loadtime:0.55503702163696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.55508995056152 / seconds
Query Executed:select id FROM `sd` where city='Reva' && SIC_code='0742'DB:business_master_new
loadtime:0.55573511123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revillo' limit 1
loadtime:0.55579209327698 / seconds
Query Executed:select id FROM `sd` where city='Revillo' && SIC_code='0742'DB:business_master_new
loadtime:0.55679106712341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeview' limit 1
loadtime:0.55684304237366 / seconds
Query Executed:select id FROM `sd` where city='Ridgeview' && SIC_code='0742'DB:business_master_new
loadtime:0.55731892585754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockham' limit 1
loadtime:0.55736994743347 / seconds
Query Executed:select id FROM `sd` where city='Rockham' && SIC_code='0742'DB:business_master_new
loadtime:0.5579309463501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscoe' limit 1
loadtime:0.55798292160034 / seconds
Query Executed:select id FROM `sd` where city='Roscoe' && SIC_code='0742'DB:business_master_new
loadtime:0.55959105491638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebud' limit 1
loadtime:0.55965113639832 / seconds
Query Executed:select id FROM `sd` where city='Rosebud' && SIC_code='0742'DB:business_master_new
loadtime:0.56170392036438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:0.56175708770752 / seconds
Query Executed:select id FROM `sd` where city='Rosholt' && SIC_code='0742'DB:business_master_new
loadtime:0.56371808052063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslyn' limit 1
loadtime:0.56377100944519 / seconds
Query Executed:select id FROM `sd` where city='Roslyn' && SIC_code='0742'DB:business_master_new
loadtime:0.56463599205017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowena' limit 1
loadtime:0.56468796730042 / seconds
Query Executed:select id FROM `sd` where city='Rowena' && SIC_code='0742'DB:business_master_new
loadtime:0.56513810157776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.56519412994385 / seconds
Query Executed:select id FROM `sd` where city='Rutland' && SIC_code='0742'DB:business_master_new
loadtime:0.5657799243927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.56583309173584 / seconds
Query Executed:select id FROM `sd` where city='Saint Charles' && SIC_code='0742'DB:business_master_new
loadtime:0.56629991531372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Francis' limit 1
loadtime:0.56634998321533 / seconds
Query Executed:select id FROM `sd` where city='Saint Francis' && SIC_code='0742'DB:business_master_new
loadtime:0.567134141922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Lawrence' limit 1
loadtime:0.56719207763672 / seconds
Query Executed:select id FROM `sd` where city='Saint Lawrence' && SIC_code='0742'DB:business_master_new
loadtime:0.56801795959473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Onge' limit 1
loadtime:0.56807494163513 / seconds
Query Executed:select id FROM `sd` where city='Saint Onge' && SIC_code='0742'DB:business_master_new
loadtime:0.56867694854736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.5687301158905 / seconds
Query Executed:select id FROM `sd` where city='Salem' && SIC_code='0742'DB:business_master_new
loadtime:0.57209396362305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scenic' limit 1
loadtime:0.5721640586853 / seconds
Query Executed:select id FROM `sd` where city='Scenic' && SIC_code='0742'DB:business_master_new
loadtime:0.57275104522705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.57280492782593 / seconds
Query Executed:select id FROM `sd` where city='Scotland' && SIC_code='0742'DB:business_master_new
loadtime:0.57525491714478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selby' limit 1
loadtime:0.57531404495239 / seconds
Query Executed:select id FROM `sd` where city='Selby' && SIC_code='0742'DB:business_master_new
loadtime:0.5776150226593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.57768392562866 / seconds
Query Executed:select id FROM `sd` where city='Seneca' && SIC_code='0742'DB:business_master_new
loadtime:0.57834005355835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shadehill' limit 1
loadtime:0.57839202880859 / seconds
Query Executed:select id FROM `sd` where city='Shadehill' && SIC_code='0742'DB:business_master_new
loadtime:0.57886910438538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.5789270401001 / seconds
Query Executed:select id FROM `sd` where city='Sherman' && SIC_code='0742'DB:business_master_new
loadtime:0.57936501502991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.57941794395447 / seconds
Query Executed:select id FROM `sd` where city='Silver City' && SIC_code='0742'DB:business_master_new
loadtime:0.57987594604492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinai' limit 1
loadtime:0.57992911338806 / seconds
Query Executed:select id FROM `sd` where city='Sinai' && SIC_code='0742'DB:business_master_new
loadtime:0.58061599731445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Falls' limit 1
loadtime:0.58066892623901 / seconds
Query Executed:select id FROM `sd` where city='Sioux Falls' && SIC_code='0742'DB:business_master_new
loadtime:0.58314514160156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sisseton' limit 1
loadtime:0.5832359790802 / seconds
Query Executed:select id FROM `sd` where city='Sisseton' && SIC_code='0742'DB:business_master_new
loadtime:0.58828091621399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sky Ranch' limit 1
loadtime:0.58835101127625 / seconds
Query Executed:select id FROM `sd` where city='Sky Ranch' && SIC_code='0742'DB:business_master_new
loadtime:0.58877611160278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithwick' limit 1
loadtime:0.58883500099182 / seconds
Query Executed:select id FROM `sd` where city='Smithwick' && SIC_code='0742'DB:business_master_new
loadtime:0.58924007415771 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Shore' limit 1
loadtime:0.58929896354675 / seconds
Query Executed:select id FROM `sd` where city='South Shore' && SIC_code='0742'DB:business_master_new
loadtime:0.59012198448181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spearfish' limit 1
loadtime:0.59018206596375 / seconds
Query Executed:select id FROM `sd` where city='Spearfish' && SIC_code='0742'DB:business_master_new
loadtime:0.5925829410553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.59266114234924 / seconds
Query Executed:select id FROM `sd` where city='Spencer' && SIC_code='0742'DB:business_master_new
loadtime:0.59346699714661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.59351992607117 / seconds
Query Executed:select id FROM `sd` where city='Springfield' && SIC_code='0742'DB:business_master_new
loadtime:0.59558296203613 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.59564900398254 / seconds
Query Executed:select id FROM `sd` where city='St Charles' && SIC_code='0742'DB:business_master_new
loadtime:0.59608507156372 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:0.59614109992981 / seconds
Query Executed:select id FROM `sd` where city='St Francis' && SIC_code='0742'DB:business_master_new
loadtime:0.59660601615906 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lawrence' limit 1
loadtime:0.59665894508362 / seconds
Query Executed:select id FROM `sd` where city='St Lawrence' && SIC_code='0742'DB:business_master_new
loadtime:0.59712100028992 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Onge' limit 1
loadtime:0.59717297554016 / seconds
Query Executed:select id FROM `sd` where city='St Onge' && SIC_code='0742'DB:business_master_new
loadtime:0.59761905670166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephan' limit 1
loadtime:0.59767603874207 / seconds
Query Executed:select id FROM `sd` where city='Stephan' && SIC_code='0742'DB:business_master_new
loadtime:0.59821891784668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stickney' limit 1
loadtime:0.59827399253845 / seconds
Query Executed:select id FROM `sd` where city='Stickney' && SIC_code='0742'DB:business_master_new
loadtime:0.6000120639801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:0.60006499290466 / seconds
Query Executed:select id FROM `sd` where city='Stockholm' && SIC_code='0742'DB:business_master_new
loadtime:0.60079908370972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strandburg' limit 1
loadtime:0.60085201263428 / seconds
Query Executed:select id FROM `sd` where city='Strandburg' && SIC_code='0742'DB:business_master_new
loadtime:0.60144901275635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.60150194168091 / seconds
Query Executed:select id FROM `sd` where city='Stratford' && SIC_code='0742'DB:business_master_new
loadtime:0.60221910476685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:0.60227108001709 / seconds
Query Executed:select id FROM `sd` where city='Sturgis' && SIC_code='0742'DB:business_master_new
loadtime:0.60915398597717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.60922408103943 / seconds
Query Executed:select id FROM `sd` where city='Summit' && SIC_code='0742'DB:business_master_new
loadtime:0.61017203330994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:0.61022710800171 / seconds
Query Executed:select id FROM `sd` where city='Tabor' && SIC_code='0742'DB:business_master_new
loadtime:0.61156296730042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tea' limit 1
loadtime:0.61162996292114 / seconds
Query Executed:select id FROM `sd` where city='Tea' && SIC_code='0742'DB:business_master_new
loadtime:0.61512494087219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timber Lake' limit 1
loadtime:0.61519408226013 / seconds
Query Executed:select id FROM `sd` where city='Timber Lake' && SIC_code='0742'DB:business_master_new
loadtime:0.61710405349731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolstoy' limit 1
loadtime:0.61716294288635 / seconds
Query Executed:select id FROM `sd` where city='Tolstoy' && SIC_code='0742'DB:business_master_new
loadtime:0.61792802810669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:0.61798095703125 / seconds
Query Executed:select id FROM `sd` where city='Toronto' && SIC_code='0742'DB:business_master_new
loadtime:0.61913204193115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trail City' limit 1
loadtime:0.61918497085571 / seconds
Query Executed:select id FROM `sd` where city='Trail City' && SIC_code='0742'DB:business_master_new
loadtime:0.61970496177673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent' limit 1
loadtime:0.61975812911987 / seconds
Query Executed:select id FROM `sd` where city='Trent' && SIC_code='0742'DB:business_master_new
loadtime:0.62039709091187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripp' limit 1
loadtime:0.62045407295227 / seconds
Query Executed:select id FROM `sd` where city='Tripp' && SIC_code='0742'DB:business_master_new
loadtime:0.62233901023865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tulare' limit 1
loadtime:0.6223931312561 / seconds
Query Executed:select id FROM `sd` where city='Tulare' && SIC_code='0742'DB:business_master_new
loadtime:0.62330603599548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turton' limit 1
loadtime:0.62335896492004 / seconds
Query Executed:select id FROM `sd` where city='Turton' && SIC_code='0742'DB:business_master_new
loadtime:0.62400507926941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuthill' limit 1
loadtime:0.62406206130981 / seconds
Query Executed:select id FROM `sd` where city='Tuthill' && SIC_code='0742'DB:business_master_new
loadtime:0.62457895278931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Brooks' limit 1
loadtime:0.62463998794556 / seconds
Query Executed:select id FROM `sd` where city='Twin Brooks' && SIC_code='0742'DB:business_master_new
loadtime:0.625333070755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyndall' limit 1
loadtime:0.62538599967957 / seconds
Query Executed:select id FROM `sd` where city='Tyndall' && SIC_code='0742'DB:business_master_new
loadtime:0.62841296195984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:0.62849497795105 / seconds
Query Executed:select id FROM `sd` where city='Union Center' && SIC_code='0742'DB:business_master_new
loadtime:0.62921500205994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:0.62926912307739 / seconds
Query Executed:select id FROM `sd` where city='Utica' && SIC_code='0742'DB:business_master_new
loadtime:0.63002896308899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:0.63008594512939 / seconds
Query Executed:select id FROM `sd` where city='Vale' && SIC_code='0742'DB:business_master_new
loadtime:0.63094115257263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Springs' limit 1
loadtime:0.63099408149719 / seconds
Query Executed:select id FROM `sd` where city='Valley Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.63244104385376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veblen' limit 1
loadtime:0.63251399993896 / seconds
Query Executed:select id FROM `sd` where city='Veblen' && SIC_code='0742'DB:business_master_new
loadtime:0.63361692428589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermillion' limit 1
loadtime:0.63367104530334 / seconds
Query Executed:select id FROM `sd` where city='Vermillion' && SIC_code='0742'DB:business_master_new
loadtime:0.64061713218689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viborg' limit 1
loadtime:0.64068412780762 / seconds
Query Executed:select id FROM `sd` where city='Viborg' && SIC_code='0742'DB:business_master_new
loadtime:0.64278602600098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:0.64285492897034 / seconds
Query Executed:select id FROM `sd` where city='Vienna' && SIC_code='0742'DB:business_master_new
loadtime:0.64345908164978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgil' limit 1
loadtime:0.64351296424866 / seconds
Query Executed:select id FROM `sd` where city='Virgil' && SIC_code='0742'DB:business_master_new
loadtime:0.64398002624512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vivian' limit 1
loadtime:0.64403796195984 / seconds
Query Executed:select id FROM `sd` where city='Vivian' && SIC_code='0742'DB:business_master_new
loadtime:0.64478707313538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:0.6448450088501 / seconds
Query Executed:select id FROM `sd` where city='Volga' && SIC_code='0742'DB:business_master_new
loadtime:0.64722895622253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volin' limit 1
loadtime:0.64729714393616 / seconds
Query Executed:select id FROM `sd` where city='Volin' && SIC_code='0742'DB:business_master_new
loadtime:0.64823198318481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagner' limit 1
loadtime:0.64828610420227 / seconds
Query Executed:select id FROM `sd` where city='Wagner' && SIC_code='0742'DB:business_master_new
loadtime:0.65195894241333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakonda' limit 1
loadtime:0.65203213691711 / seconds
Query Executed:select id FROM `sd` where city='Wakonda' && SIC_code='0742'DB:business_master_new
loadtime:0.65328502655029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakpala' limit 1
loadtime:0.65333914756775 / seconds
Query Executed:select id FROM `sd` where city='Wakpala' && SIC_code='0742'DB:business_master_new
loadtime:0.65381598472595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:0.65386915206909 / seconds
Query Executed:select id FROM `sd` where city='Wall' && SIC_code='0742'DB:business_master_new
loadtime:0.6560800075531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:0.65613293647766 / seconds
Query Executed:select id FROM `sd` where city='Wallace' && SIC_code='0742'DB:business_master_new
loadtime:0.65671110153198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanblee' limit 1
loadtime:0.65676403045654 / seconds
Query Executed:select id FROM `sd` where city='Wanblee' && SIC_code='0742'DB:business_master_new
loadtime:0.65737104415894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.65742206573486 / seconds
Query Executed:select id FROM `sd` where city='Ward' && SIC_code='0742'DB:business_master_new
loadtime:0.65785312652588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.65790605545044 / seconds
Query Executed:select id FROM `sd` where city='Warner' && SIC_code='0742'DB:business_master_new
loadtime:0.65871500968933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wasta' limit 1
loadtime:0.65876793861389 / seconds
Query Executed:select id FROM `sd` where city='Wasta' && SIC_code='0742'DB:business_master_new
loadtime:0.65935802459717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watauga' limit 1
loadtime:0.65940809249878 / seconds
Query Executed:select id FROM `sd` where city='Watauga' && SIC_code='0742'DB:business_master_new
loadtime:0.65990400314331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.65995693206787 / seconds
Query Executed:select id FROM `sd` where city='Watertown' && SIC_code='0742'DB:business_master_new
loadtime:0.66239094734192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubay' limit 1
loadtime:0.66247010231018 / seconds
Query Executed:select id FROM `sd` where city='Waubay' && SIC_code='0742'DB:business_master_new
loadtime:0.66429901123047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:0.66435408592224 / seconds
Query Executed:select id FROM `sd` where city='Waverly' && SIC_code='0742'DB:business_master_new
loadtime:0.66473412513733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.66478705406189 / seconds
Query Executed:select id FROM `sd` where city='Webster' && SIC_code='0742'DB:business_master_new
loadtime:0.66712594032288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wecota' limit 1
loadtime:0.6671929359436 / seconds
Query Executed:select id FROM `sd` where city='Wecota' && SIC_code='0742'DB:business_master_new
loadtime:0.66757607460022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.66764402389526 / seconds
Query Executed:select id FROM `sd` where city='Wentworth' && SIC_code='0742'DB:business_master_new
loadtime:0.66894292831421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington' limit 1
loadtime:0.66900110244751 / seconds
Query Executed:select id FROM `sd` where city='Wessington' && SIC_code='0742'DB:business_master_new
loadtime:0.67055010795593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Spgs' limit 1
loadtime:0.67061114311218 / seconds
Query Executed:select id FROM `sd` where city='Wessington Spgs' && SIC_code='0742'DB:business_master_new
loadtime:0.67100596427917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Springs' limit 1
loadtime:0.67106413841248 / seconds
Query Executed:select id FROM `sd` where city='Wessington Springs' && SIC_code='0742'DB:business_master_new
loadtime:0.67387509346008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.67394208908081 / seconds
Query Executed:select id FROM `sd` where city='Westport' && SIC_code='0742'DB:business_master_new
loadtime:0.67465710639954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetonka' limit 1
loadtime:0.67471098899841 / seconds
Query Executed:select id FROM `sd` where city='Wetonka' && SIC_code='0742'DB:business_master_new
loadtime:0.67512893676758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wewela' limit 1
loadtime:0.6751811504364 / seconds
Query Executed:select id FROM `sd` where city='Wewela' && SIC_code='0742'DB:business_master_new
loadtime:0.67561912536621 / seconds
Query loaded from cache:select * from geodata_geocity where city='White' limit 1
loadtime:0.67567300796509 / seconds
Query Executed:select id FROM `sd` where city='White' && SIC_code='0742'DB:business_master_new
loadtime:0.67756795883179 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:0.67764902114868 / seconds
Query Executed:select id FROM `sd` where city='White Lake' && SIC_code='0742'DB:business_master_new
loadtime:0.67928194999695 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Owl' limit 1
loadtime:0.6793360710144 / seconds
Query Executed:select id FROM `sd` where city='White Owl' && SIC_code='0742'DB:business_master_new
loadtime:0.67978310585022 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River' limit 1
loadtime:0.67984104156494 / seconds
Query Executed:select id FROM `sd` where city='White River' && SIC_code='0742'DB:business_master_new
loadtime:0.68165898323059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehorse' limit 1
loadtime:0.68171215057373 / seconds
Query Executed:select id FROM `sd` where city='Whitehorse' && SIC_code='0742'DB:business_master_new
loadtime:0.6821711063385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:0.68222308158875 / seconds
Query Executed:select id FROM `sd` where city='Whitewood' && SIC_code='0742'DB:business_master_new
loadtime:0.68389105796814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Lake' limit 1
loadtime:0.68394899368286 / seconds
Query Executed:select id FROM `sd` where city='Willow Lake' && SIC_code='0742'DB:business_master_new
loadtime:0.68535304069519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.68541097640991 / seconds
Query Executed:select id FROM `sd` where city='Wilmot' && SIC_code='0742'DB:business_master_new
loadtime:0.68722701072693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfred' limit 1
loadtime:0.68729710578918 / seconds
Query Executed:select id FROM `sd` where city='Winfred' && SIC_code='0742'DB:business_master_new
loadtime:0.68838000297546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winner' limit 1
loadtime:0.68843507766724 / seconds
Query Executed:select id FROM `sd` where city='Winner' && SIC_code='0742'DB:business_master_new
loadtime:0.69084501266479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Witten' limit 1
loadtime:0.69091701507568 / seconds
Query Executed:select id FROM `sd` where city='Witten' && SIC_code='0742'DB:business_master_new
loadtime:0.69157195091248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolsey' limit 1
loadtime:0.69163513183594 / seconds
Query Executed:select id FROM `sd` where city='Wolsey' && SIC_code='0742'DB:business_master_new
loadtime:0.69300198554993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood' limit 1
loadtime:0.69306111335754 / seconds
Query Executed:select id FROM `sd` where city='Wood' && SIC_code='0742'DB:business_master_new
loadtime:0.69374704360962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woonsocket' limit 1
loadtime:0.69380497932434 / seconds
Query Executed:select id FROM `sd` where city='Woonsocket' && SIC_code='0742'DB:business_master_new
loadtime:0.69641804695129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthing' limit 1
loadtime:0.69649004936218 / seconds
Query Executed:select id FROM `sd` where city='Worthing' && SIC_code='0742'DB:business_master_new
loadtime:0.69794702529907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wounded Knee' limit 1
loadtime:0.69800114631653 / seconds
Query Executed:select id FROM `sd` where city='Wounded Knee' && SIC_code='0742'DB:business_master_new
loadtime:0.69846296310425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:0.69851613044739 / seconds
Query Executed:select id FROM `sd` where city='Yale' && SIC_code='0742'DB:business_master_new
loadtime:0.69911813735962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yankton' limit 1
loadtime:0.69917511940002 / seconds
Query Executed:select id FROM `sd` where city='Yankton' && SIC_code='0742'DB:business_master_new
loadtime:0.70149898529053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zell' limit 1
loadtime:0.7015700340271 / seconds
Query Executed:select id FROM `sd` where city='Zell' && SIC_code='0742'DB:business_master_new
loadtime:0.702152967453 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.70230007171631 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.70272707939148 / seconds
Operation template executed (chunk cache operation)
loadtime:0.7028911113739 / seconds
template override:Default
loadtime:0.70293211936951 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.70430397987366 / seconds
Template Constructed, Array Rows:49
loadtime:0.70483112335205 / seconds
TOTAL EXECUTION TIME: 0.70439
loadtime:0.70632314682007 / 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] => veterinary-services-for-animal-specialties [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:0.70633292198181
TOTAL KEY ARRAYS: 69