Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.7976455688477E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00075697898864746 / seconds
host not found setting manual db connection
loadtime:0.0014750957489014 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017151832580566 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0019121170043945 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0019681453704834 / seconds
zipcode:
loadtime:0.001986026763916 / seconds
Query Executed:select * from search_referrer where page_hash='3cf590df4e06586358b3716d9bca6f25' limit 10 DB:ezrox_toadli
loadtime:0.0021951198577881 / seconds
Operation header executed (non global)
loadtime:0.0022439956665039 / seconds
Operation leaderboard executed (non global)
loadtime:0.0023281574249268 / seconds
Operation square executed (non global)
loadtime:0.0023660659790039 / seconds
Operation square_bottom executed (non global)
loadtime:0.0024011135101318 / seconds
Operation smallsquare executed (non global)
loadtime:0.0024731159210205 / seconds
Operation headeradright executed (non global)
loadtime:0.0024890899658203 / seconds
Operation google_analytics executed (non global)
loadtime:0.002500057220459 / seconds
Operation topstories executed (non global)
loadtime:0.0025110244750977 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0025231838226318 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0025341510772705 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0027601718902588 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0029101371765137 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0029549598693848 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0030250549316406 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0030601024627686 / seconds
Template key: archive_menu pushed
loadtime:0.0030651092529297 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0030710697174072 / seconds
Template key: get_gravatar pushed
loadtime:0.003075122833252 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0030791759490967 / seconds
*10)-10)+1 | start:0
loadtime:0.0031020641326904 / seconds
Query loaded from cache:select * from categories where cat_URLid='hotels-and-motels'
loadtime:0.0031290054321289 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.0031590461730957 / seconds
DB connected to localhost business_master_new
loadtime:0.0033950805664062 / seconds
Query Executed:select * from `sd_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.10364007949829 / seconds
Query stored in cache : _QUERY_www.toadli.com9146ae9400065a441c354596fbda00a7
loadtime:0.10431909561157 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='south-dakota'
loadtime:0.1043529510498 / seconds
Query Executed:select sum(totalcount) as totalsum from `sd_catmap` where sic='7011'DB:business_master_new
loadtime:0.10833716392517 / seconds
Query stored in cache : _QUERY_www.toadli.comdf53101c73ec3efffc20f39080002579
loadtime:0.10836315155029 / seconds
410 / 11
loadtime:0.10839509963989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.10846209526062 / seconds
Query Executed:select id FROM `sd` where city='Aberdeen' && SIC_code='7011'DB:business_master_new
loadtime:0.11345815658569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Academy' limit 1
loadtime:0.11353802680969 / seconds
Query Executed:select id FROM `sd` where city='Academy' && SIC_code='7011'DB:business_master_new
loadtime:0.11377906799316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agar' limit 1
loadtime:0.11382818222046 / seconds
Query Executed:select id FROM `sd` where city='Agar' && SIC_code='7011'DB:business_master_new
loadtime:0.11448311805725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akaska' limit 1
loadtime:0.11452007293701 / seconds
Query Executed:select id FROM `sd` where city='Akaska' && SIC_code='7011'DB:business_master_new
loadtime:0.1151020526886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcester' limit 1
loadtime:0.11516118049622 / seconds
Query Executed:select id FROM `sd` where city='Alcester' && SIC_code='7011'DB:business_master_new
loadtime:0.11622905731201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.1162850856781 / seconds
Query Executed:select id FROM `sd` where city='Alexandria' && SIC_code='7011'DB:business_master_new
loadtime:0.11728501319885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allen' limit 1
loadtime:0.11733198165894 / seconds
Query Executed:select id FROM `sd` where city='Allen' && SIC_code='7011'DB:business_master_new
loadtime:0.11795401573181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpena' limit 1
loadtime:0.11799502372742 / seconds
Query Executed:select id FROM `sd` where city='Alpena' && SIC_code='7011'DB:business_master_new
loadtime:0.11890506744385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.11895513534546 / seconds
Query Executed:select id FROM `sd` where city='Altamont' && SIC_code='7011'DB:business_master_new
loadtime:0.11920404434204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.11924004554749 / seconds
Query Executed:select id FROM `sd` where city='Amherst' && SIC_code='7011'DB:business_master_new
loadtime:0.1196141242981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.11964917182922 / seconds
Query Executed:select id FROM `sd` where city='Andover' && SIC_code='7011'DB:business_master_new
loadtime:0.12038803100586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ardmore' limit 1
loadtime:0.12046098709106 / seconds
Query Executed:select id FROM `sd` where city='Ardmore' && SIC_code='7011'DB:business_master_new
loadtime:0.12071108818054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.12074398994446 / seconds
Query Executed:select id FROM `sd` where city='Arlington' && SIC_code='7011'DB:business_master_new
loadtime:0.12176203727722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Armour' limit 1
loadtime:0.12182712554932 / seconds
Query Executed:select id FROM `sd` where city='Armour' && SIC_code='7011'DB:business_master_new
loadtime:0.12305498123169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesian' limit 1
loadtime:0.12311410903931 / seconds
Query Executed:select id FROM `sd` where city='Artesian' && SIC_code='7011'DB:business_master_new
loadtime:0.12423610687256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashton' limit 1
loadtime:0.12428307533264 / seconds
Query Executed:select id FROM `sd` where city='Ashton' && SIC_code='7011'DB:business_master_new
loadtime:0.12494111061096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Astoria' limit 1
loadtime:0.12499117851257 / seconds
Query Executed:select id FROM `sd` where city='Astoria' && SIC_code='7011'DB:business_master_new
loadtime:0.12593698501587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.12598609924316 / seconds
Query Executed:select id FROM `sd` where city='Aurora' && SIC_code='7011'DB:business_master_new
loadtime:0.12701296806335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.12706017494202 / seconds
Query Executed:select id FROM `sd` where city='Avon' && SIC_code='7011'DB:business_master_new
loadtime:0.12813401222229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.1281909942627 / seconds
Query Executed:select id FROM `sd` where city='Badger' && SIC_code='7011'DB:business_master_new
loadtime:0.12884306907654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.12889814376831 / seconds
Query Executed:select id FROM `sd` where city='Baltic' && SIC_code='7011'DB:business_master_new
loadtime:0.12997603416443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bancroft' limit 1
loadtime:0.13002300262451 / seconds
Query Executed:select id FROM `sd` where city='Bancroft' && SIC_code='7011'DB:business_master_new
loadtime:0.13029098510742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnard' limit 1
loadtime:0.13032412528992 / seconds
Query Executed:select id FROM `sd` where city='Barnard' && SIC_code='7011'DB:business_master_new
loadtime:0.13061308860779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesland' limit 1
loadtime:0.13064408302307 / seconds
Query Executed:select id FROM `sd` where city='Batesland' && SIC_code='7011'DB:business_master_new
loadtime:0.13135313987732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.13143014907837 / seconds
Query Executed:select id FROM `sd` where city='Bath' && SIC_code='7011'DB:business_master_new
loadtime:0.13237404823303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Fourche' limit 1
loadtime:0.13241004943848 / seconds
Query Executed:select id FROM `sd` where city='Belle Fourche' && SIC_code='7011'DB:business_master_new
loadtime:0.13402104377747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.1340811252594 / seconds
Query Executed:select id FROM `sd` where city='Belvidere' && SIC_code='7011'DB:business_master_new
loadtime:0.13459706306458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beresford' limit 1
loadtime:0.13464403152466 / seconds
Query Executed:select id FROM `sd` where city='Beresford' && SIC_code='7011'DB:business_master_new
loadtime:0.13591003417969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Stone City' limit 1
loadtime:0.1359601020813 / seconds
Query Executed:select id FROM `sd` where city='Big Stone City' && SIC_code='7011'DB:business_master_new
loadtime:0.13682317733765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bison' limit 1
loadtime:0.13688111305237 / seconds
Query Executed:select id FROM `sd` where city='Bison' && SIC_code='7011'DB:business_master_new
loadtime:0.1378071308136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Hawk' limit 1
loadtime:0.13786315917969 / seconds
Query Executed:select id FROM `sd` where city='Black Hawk' && SIC_code='7011'DB:business_master_new
loadtime:0.13916516304016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blunt' limit 1
loadtime:0.1392080783844 / seconds
Query Executed:select id FROM `sd` where city='Blunt' && SIC_code='7011'DB:business_master_new
loadtime:0.14043498039246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonesteel' limit 1
loadtime:0.14048314094543 / seconds
Query Executed:select id FROM `sd` where city='Bonesteel' && SIC_code='7011'DB:business_master_new
loadtime:0.14152407646179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdle' limit 1
loadtime:0.14157915115356 / seconds
Query Executed:select id FROM `sd` where city='Bowdle' && SIC_code='7011'DB:business_master_new
loadtime:0.14254903793335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Box Elder' limit 1
loadtime:0.14260601997375 / seconds
Query Executed:select id FROM `sd` where city='Box Elder' && SIC_code='7011'DB:business_master_new
loadtime:0.14373207092285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley' limit 1
loadtime:0.14379000663757 / seconds
Query Executed:select id FROM `sd` where city='Bradley' && SIC_code='7011'DB:business_master_new
loadtime:0.14453601837158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.14459109306335 / seconds
Query Executed:select id FROM `sd` where city='Brandon' && SIC_code='7011'DB:business_master_new
loadtime:0.14590406417847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandt' limit 1
loadtime:0.14594912528992 / seconds
Query Executed:select id FROM `sd` where city='Brandt' && SIC_code='7011'DB:business_master_new
loadtime:0.1469099521637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentford' limit 1
loadtime:0.14696097373962 / seconds
Query Executed:select id FROM `sd` where city='Brentford' && SIC_code='7011'DB:business_master_new
loadtime:0.14734697341919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.147381067276 / seconds
Query Executed:select id FROM `sd` where city='Bridgewater' && SIC_code='7011'DB:business_master_new
loadtime:0.14831113815308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.14836716651917 / seconds
Query Executed:select id FROM `sd` where city='Bristol' && SIC_code='7011'DB:business_master_new
loadtime:0.14923715591431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britton' limit 1
loadtime:0.14929604530334 / seconds
Query Executed:select id FROM `sd` where city='Britton' && SIC_code='7011'DB:business_master_new
loadtime:0.15062403678894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookings' limit 1
loadtime:0.15067505836487 / seconds
Query Executed:select id FROM `sd` where city='Brookings' && SIC_code='7011'DB:business_master_new
loadtime:0.15251517295837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.15258097648621 / seconds
Query Executed:select id FROM `sd` where city='Bruce' && SIC_code='7011'DB:business_master_new
loadtime:0.1535210609436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.15357112884521 / seconds
Query Executed:select id FROM `sd` where city='Bryant' && SIC_code='7011'DB:business_master_new
loadtime:0.15464210510254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.15470314025879 / seconds
Query Executed:select id FROM `sd` where city='Buffalo' && SIC_code='7011'DB:business_master_new
loadtime:0.15560507774353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Gap' limit 1
loadtime:0.15566205978394 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Gap' && SIC_code='7011'DB:business_master_new
loadtime:0.15624618530273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo Ridge' limit 1
loadtime:0.15628910064697 / seconds
Query Executed:select id FROM `sd` where city='Buffalo Ridge' && SIC_code='7011'DB:business_master_new
loadtime:0.15654611587524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead' limit 1
loadtime:0.15659713745117 / seconds
Query Executed:select id FROM `sd` where city='Bullhead' && SIC_code='7011'DB:business_master_new
loadtime:0.15704703330994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burbank' limit 1
loadtime:0.15708708763123 / seconds
Query Executed:select id FROM `sd` where city='Burbank' && SIC_code='7011'DB:business_master_new
loadtime:0.15790915489197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burke' limit 1
loadtime:0.15796113014221 / seconds
Query Executed:select id FROM `sd` where city='Burke' && SIC_code='7011'DB:business_master_new
loadtime:0.15906000137329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bushnell' limit 1
loadtime:0.15912008285522 / seconds
Query Executed:select id FROM `sd` where city='Bushnell' && SIC_code='7011'DB:business_master_new
loadtime:0.15937805175781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.1594250202179 / seconds
Query Executed:select id FROM `sd` where city='Butler' && SIC_code='7011'DB:business_master_new
loadtime:0.15967297554016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Crook' limit 1
loadtime:0.15971207618713 / seconds
Query Executed:select id FROM `sd` where city='Camp Crook' && SIC_code='7011'DB:business_master_new
loadtime:0.16048407554626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canistota' limit 1
loadtime:0.16053199768066 / seconds
Query Executed:select id FROM `sd` where city='Canistota' && SIC_code='7011'DB:business_master_new
loadtime:0.16163206100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canova' limit 1
loadtime:0.16169714927673 / seconds
Query Executed:select id FROM `sd` where city='Canova' && SIC_code='7011'DB:business_master_new
loadtime:0.16252207756042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.16257405281067 / seconds
Query Executed:select id FROM `sd` where city='Canton' && SIC_code='7011'DB:business_master_new
loadtime:0.16353917121887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caputa' limit 1
loadtime:0.16358709335327 / seconds
Query Executed:select id FROM `sd` where city='Caputa' && SIC_code='7011'DB:business_master_new
loadtime:0.16405415534973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.16410112380981 / seconds
Query Executed:select id FROM `sd` where city='Carpenter' && SIC_code='7011'DB:business_master_new
loadtime:0.1649911403656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carter' limit 1
loadtime:0.16504311561584 / seconds
Query Executed:select id FROM `sd` where city='Carter' && SIC_code='7011'DB:business_master_new
loadtime:0.16530013084412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.16533303260803 / seconds
Query Executed:select id FROM `sd` where city='Carthage' && SIC_code='7011'DB:business_master_new
loadtime:0.16608715057373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castlewood' limit 1
loadtime:0.16613817214966 / seconds
Query Executed:select id FROM `sd` where city='Castlewood' && SIC_code='7011'DB:business_master_new
loadtime:0.16708397865295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cavour' limit 1
loadtime:0.16714000701904 / seconds
Query Executed:select id FROM `sd` where city='Cavour' && SIC_code='7011'DB:business_master_new
loadtime:0.16848611831665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.16853308677673 / seconds
Query Executed:select id FROM `sd` where city='Centerville' && SIC_code='7011'DB:business_master_new
loadtime:0.16947317123413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.1695191860199 / seconds
Query Executed:select id FROM `sd` where city='Central City' && SIC_code='7011'DB:business_master_new
loadtime:0.16988301277161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chamberlain' limit 1
loadtime:0.16993117332458 / seconds
Query Executed:select id FROM `sd` where city='Chamberlain' && SIC_code='7011'DB:business_master_new
loadtime:0.17166018486023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chancellor' limit 1
loadtime:0.17172408103943 / seconds
Query Executed:select id FROM `sd` where city='Chancellor' && SIC_code='7011'DB:business_master_new
loadtime:0.17270016670227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.1727499961853 / seconds
Query Executed:select id FROM `sd` where city='Chelsea' && SIC_code='7011'DB:business_master_new
loadtime:0.1730260848999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Creek' limit 1
loadtime:0.17305898666382 / seconds
Query Executed:select id FROM `sd` where city='Cherry Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.17348003387451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.17352318763733 / seconds
Query Executed:select id FROM `sd` where city='Chester' && SIC_code='7011'DB:business_master_new
loadtime:0.1746289730072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claire City' limit 1
loadtime:0.17468118667603 / seconds
Query Executed:select id FROM `sd` where city='Claire City' && SIC_code='7011'DB:business_master_new
loadtime:0.17560601234436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.17565703392029 / seconds
Query Executed:select id FROM `sd` where city='Claremont' && SIC_code='7011'DB:business_master_new
loadtime:0.17665600776672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.17670202255249 / seconds
Query Executed:select id FROM `sd` where city='Clark' && SIC_code='7011'DB:business_master_new
loadtime:0.17765998840332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.17770910263062 / seconds
Query Executed:select id FROM `sd` where city='Clear Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.17902612686157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.17909002304077 / seconds
Query Executed:select id FROM `sd` where city='Clearfield' && SIC_code='7011'DB:business_master_new
loadtime:0.17957210540771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colman' limit 1
loadtime:0.179612159729 / seconds
Query Executed:select id FROM `sd` where city='Colman' && SIC_code='7011'DB:business_master_new
loadtime:0.18066716194153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colome' limit 1
loadtime:0.18071699142456 / seconds
Query Executed:select id FROM `sd` where city='Colome' && SIC_code='7011'DB:business_master_new
loadtime:0.18156695365906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colton' limit 1
loadtime:0.1816029548645 / seconds
Query Executed:select id FROM `sd` where city='Colton' && SIC_code='7011'DB:business_master_new
loadtime:0.18267512321472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.18272399902344 / seconds
Query Executed:select id FROM `sd` where city='Columbia' && SIC_code='7011'DB:business_master_new
loadtime:0.18378901481628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conde' limit 1
loadtime:0.18384909629822 / seconds
Query Executed:select id FROM `sd` where city='Conde' && SIC_code='7011'DB:business_master_new
loadtime:0.18483400344849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corona' limit 1
loadtime:0.18487596511841 / seconds
Query Executed:select id FROM `sd` where city='Corona' && SIC_code='7011'DB:business_master_new
loadtime:0.18585515022278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corsica' limit 1
loadtime:0.18590712547302 / seconds
Query Executed:select id FROM `sd` where city='Corsica' && SIC_code='7011'DB:business_master_new
loadtime:0.18706202507019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creighton' limit 1
loadtime:0.18711996078491 / seconds
Query Executed:select id FROM `sd` where city='Creighton' && SIC_code='7011'DB:business_master_new
loadtime:0.18756103515625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresbard' limit 1
loadtime:0.18760204315186 / seconds
Query Executed:select id FROM `sd` where city='Cresbard' && SIC_code='7011'DB:business_master_new
loadtime:0.18864107131958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crocker' limit 1
loadtime:0.18869495391846 / seconds
Query Executed:select id FROM `sd` where city='Crocker' && SIC_code='7011'DB:business_master_new
loadtime:0.18895816802979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crooks' limit 1
loadtime:0.18899297714233 / seconds
Query Executed:select id FROM `sd` where city='Crooks' && SIC_code='7011'DB:business_master_new
loadtime:0.18992900848389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Custer' limit 1
loadtime:0.18997502326965 / seconds
Query Executed:select id FROM `sd` where city='Custer' && SIC_code='7011'DB:business_master_new
loadtime:0.19233107566833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota Dunes' limit 1
loadtime:0.19239616394043 / seconds
Query Executed:select id FROM `sd` where city='Dakota Dunes' && SIC_code='7011'DB:business_master_new
loadtime:0.19272208213806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.19277715682983 / seconds
Query Executed:select id FROM `sd` where city='Dallas' && SIC_code='7011'DB:business_master_new
loadtime:0.19368004798889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dante' limit 1
loadtime:0.19373607635498 / seconds
Query Executed:select id FROM `sd` where city='Dante' && SIC_code='7011'DB:business_master_new
loadtime:0.1944899559021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:0.19453811645508 / seconds
Query Executed:select id FROM `sd` where city='Davis' && SIC_code='7011'DB:business_master_new
loadtime:0.19559717178345 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Smet' limit 1
loadtime:0.1956479549408 / seconds
Query Executed:select id FROM `sd` where city='De Smet' && SIC_code='7011'DB:business_master_new
loadtime:0.1970911026001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deadwood' limit 1
loadtime:0.19714498519897 / seconds
Query Executed:select id FROM `sd` where city='Deadwood' && SIC_code='7011'DB:business_master_new
loadtime:0.19949197769165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dell Rapids' limit 1
loadtime:0.1995701789856 / seconds
Query Executed:select id FROM `sd` where city='Dell Rapids' && SIC_code='7011'DB:business_master_new
loadtime:0.20102310180664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:0.20108318328857 / seconds
Query Executed:select id FROM `sd` where city='Delmont' && SIC_code='7011'DB:business_master_new
loadtime:0.2021210193634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dimock' limit 1
loadtime:0.20216107368469 / seconds
Query Executed:select id FROM `sd` where city='Dimock' && SIC_code='7011'DB:business_master_new
loadtime:0.2034170627594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doland' limit 1
loadtime:0.20346617698669 / seconds
Query Executed:select id FROM `sd` where city='Doland' && SIC_code='7011'DB:business_master_new
loadtime:0.20459008216858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolton' limit 1
loadtime:0.20464897155762 / seconds
Query Executed:select id FROM `sd` where city='Dolton' && SIC_code='7011'DB:business_master_new
loadtime:0.20531511306763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.20538306236267 / seconds
Query Executed:select id FROM `sd` where city='Draper' && SIC_code='7011'DB:business_master_new
loadtime:0.20649218559265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dupree' limit 1
loadtime:0.20652914047241 / seconds
Query Executed:select id FROM `sd` where city='Dupree' && SIC_code='7011'DB:business_master_new
loadtime:0.20763397216797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Butte' limit 1
loadtime:0.2076940536499 / seconds
Query Executed:select id FROM `sd` where city='Eagle Butte' && SIC_code='7011'DB:business_master_new
loadtime:0.20912909507751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.2092010974884 / seconds
Query Executed:select id FROM `sd` where city='Eden' && SIC_code='7011'DB:business_master_new
loadtime:0.20998907089233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgemont' limit 1
loadtime:0.21003818511963 / seconds
Query Executed:select id FROM `sd` where city='Edgemont' && SIC_code='7011'DB:business_master_new
loadtime:0.21103501319885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egan' limit 1
loadtime:0.21109795570374 / seconds
Query Executed:select id FROM `sd` where city='Egan' && SIC_code='7011'DB:business_master_new
loadtime:0.21205306053162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Point' limit 1
loadtime:0.21211004257202 / seconds
Query Executed:select id FROM `sd` where city='Elk Point' && SIC_code='7011'DB:business_master_new
loadtime:0.21329402923584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkton' limit 1
loadtime:0.21335005760193 / seconds
Query Executed:select id FROM `sd` where city='Elkton' && SIC_code='7011'DB:business_master_new
loadtime:0.21446895599365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth Afb' limit 1
loadtime:0.21450996398926 / seconds
Query Executed:select id FROM `sd` where city='Ellsworth Afb' && SIC_code='7011'DB:business_master_new
loadtime:0.21560597419739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm Springs' limit 1
loadtime:0.21566009521484 / seconds
Query Executed:select id FROM `sd` where city='Elm Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.21590495109558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.21593999862671 / seconds
Query Executed:select id FROM `sd` where city='Emery' && SIC_code='7011'DB:business_master_new
loadtime:0.21696996688843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enning' limit 1
loadtime:0.21703410148621 / seconds
Query Executed:select id FROM `sd` where city='Enning' && SIC_code='7011'DB:business_master_new
loadtime:0.21751809120178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:0.21755599975586 / seconds
Query Executed:select id FROM `sd` where city='Erwin' && SIC_code='7011'DB:business_master_new
loadtime:0.21825814247131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estelline' limit 1
loadtime:0.21829915046692 / seconds
Query Executed:select id FROM `sd` where city='Estelline' && SIC_code='7011'DB:business_master_new
loadtime:0.21977114677429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethan' limit 1
loadtime:0.21983003616333 / seconds
Query Executed:select id FROM `sd` where city='Ethan' && SIC_code='7011'DB:business_master_new
loadtime:0.22091603279114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.22098016738892 / seconds
Query Executed:select id FROM `sd` where city='Eureka' && SIC_code='7011'DB:business_master_new
loadtime:0.22218108177185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairburn' limit 1
loadtime:0.22223901748657 / seconds
Query Executed:select id FROM `sd` where city='Fairburn' && SIC_code='7011'DB:business_master_new
loadtime:0.22256398200989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.22260117530823 / seconds
Query Executed:select id FROM `sd` where city='Fairfax' && SIC_code='7011'DB:business_master_new
loadtime:0.2235209941864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.22357296943665 / seconds
Query Executed:select id FROM `sd` where city='Fairview' && SIC_code='7011'DB:business_master_new
loadtime:0.22404503822327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:0.22409009933472 / seconds
Query Executed:select id FROM `sd` where city='Faith' && SIC_code='7011'DB:business_master_new
loadtime:0.2253589630127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faulkton' limit 1
loadtime:0.22542095184326 / seconds
Query Executed:select id FROM `sd` where city='Faulkton' && SIC_code='7011'DB:business_master_new
loadtime:0.22669100761414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fedora' limit 1
loadtime:0.22675013542175 / seconds
Query Executed:select id FROM `sd` where city='Fedora' && SIC_code='7011'DB:business_master_new
loadtime:0.22751617431641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferney' limit 1
loadtime:0.22756814956665 / seconds
Query Executed:select id FROM `sd` where city='Ferney' && SIC_code='7011'DB:business_master_new
loadtime:0.2280421257019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Firesteel' limit 1
loadtime:0.22807812690735 / seconds
Query Executed:select id FROM `sd` where city='Firesteel' && SIC_code='7011'DB:business_master_new
loadtime:0.22834205627441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flandreau' limit 1
loadtime:0.22837996482849 / seconds
Query Executed:select id FROM `sd` where city='Flandreau' && SIC_code='7011'DB:business_master_new
loadtime:0.22956299781799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.22961902618408 / seconds
Query Executed:select id FROM `sd` where city='Florence' && SIC_code='7011'DB:business_master_new
loadtime:0.23050713539124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestburg' limit 1
loadtime:0.23054218292236 / seconds
Query Executed:select id FROM `sd` where city='Forestburg' && SIC_code='7011'DB:business_master_new
loadtime:0.23081612586975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Meade' limit 1
loadtime:0.2308611869812 / seconds
Query Executed:select id FROM `sd` where city='Fort Meade' && SIC_code='7011'DB:business_master_new
loadtime:0.23145818710327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Pierre' limit 1
loadtime:0.23149299621582 / seconds
Query Executed:select id FROM `sd` where city='Fort Pierre' && SIC_code='7011'DB:business_master_new
loadtime:0.23307514190674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thompson' limit 1
loadtime:0.23312711715698 / seconds
Query Executed:select id FROM `sd` where city='Fort Thompson' && SIC_code='7011'DB:business_master_new
loadtime:0.23463106155396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frankfort' limit 1
loadtime:0.23468208312988 / seconds
Query Executed:select id FROM `sd` where city='Frankfort' && SIC_code='7011'DB:business_master_new
loadtime:0.23549795150757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederick' limit 1
loadtime:0.23554611206055 / seconds
Query Executed:select id FROM `sd` where city='Frederick' && SIC_code='7011'DB:business_master_new
loadtime:0.23661017417908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freeman' limit 1
loadtime:0.23665595054626 / seconds
Query Executed:select id FROM `sd` where city='Freeman' && SIC_code='7011'DB:business_master_new
loadtime:0.23765516281128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitdale' limit 1
loadtime:0.23770999908447 / seconds
Query Executed:select id FROM `sd` where city='Fruitdale' && SIC_code='7011'DB:business_master_new
loadtime:0.23794317245483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.23798012733459 / seconds
Query Executed:select id FROM `sd` where city='Fulton' && SIC_code='7011'DB:business_master_new
loadtime:0.23859810829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gann Valley' limit 1
loadtime:0.23863101005554 / seconds
Query Executed:select id FROM `sd` where city='Gann Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.239501953125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.23955512046814 / seconds
Query Executed:select id FROM `sd` where city='Garden City' && SIC_code='7011'DB:business_master_new
loadtime:0.24026107788086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garretson' limit 1
loadtime:0.24030804634094 / seconds
Query Executed:select id FROM `sd` where city='Garretson' && SIC_code='7011'DB:business_master_new
loadtime:0.24162316322327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gary' limit 1
loadtime:0.2416820526123 / seconds
Query Executed:select id FROM `sd` where city='Gary' && SIC_code='7011'DB:business_master_new
loadtime:0.24287009239197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gayville' limit 1
loadtime:0.24293518066406 / seconds
Query Executed:select id FROM `sd` where city='Gayville' && SIC_code='7011'DB:business_master_new
loadtime:0.24390912055969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geddes' limit 1
loadtime:0.2439501285553 / seconds
Query Executed:select id FROM `sd` where city='Geddes' && SIC_code='7011'DB:business_master_new
loadtime:0.24498701095581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gettysburg' limit 1
loadtime:0.24503803253174 / seconds
Query Executed:select id FROM `sd` where city='Gettysburg' && SIC_code='7011'DB:business_master_new
loadtime:0.2464451789856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glad Valley' limit 1
loadtime:0.24649715423584 / seconds
Query Executed:select id FROM `sd` where city='Glad Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.24675512313843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencross' limit 1
loadtime:0.24679803848267 / seconds
Query Executed:select id FROM `sd` where city='Glencross' && SIC_code='7011'DB:business_master_new
loadtime:0.24715495109558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenham' limit 1
loadtime:0.24719500541687 / seconds
Query Executed:select id FROM `sd` where city='Glenham' && SIC_code='7011'DB:business_master_new
loadtime:0.24848914146423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodwin' limit 1
loadtime:0.24854707717896 / seconds
Query Executed:select id FROM `sd` where city='Goodwin' && SIC_code='7011'DB:business_master_new
loadtime:0.2496190071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gregory' limit 1
loadtime:0.24966216087341 / seconds
Query Executed:select id FROM `sd` where city='Gregory' && SIC_code='7011'DB:business_master_new
loadtime:0.25106501579285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenville' limit 1
loadtime:0.25113010406494 / seconds
Query Executed:select id FROM `sd` where city='Grenville' && SIC_code='7011'DB:business_master_new
loadtime:0.25205516815186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.25211715698242 / seconds
Query Executed:select id FROM `sd` where city='Groton' && SIC_code='7011'DB:business_master_new
loadtime:0.25354599952698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamill' limit 1
loadtime:0.25359511375427 / seconds
Query Executed:select id FROM `sd` where city='Hamill' && SIC_code='7011'DB:business_master_new
loadtime:0.25446105003357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:0.25450897216797 / seconds
Query Executed:select id FROM `sd` where city='Harrisburg' && SIC_code='7011'DB:business_master_new
loadtime:0.2556471824646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:0.25570106506348 / seconds
Query Executed:select id FROM `sd` where city='Harrison' && SIC_code='7011'DB:business_master_new
loadtime:0.25645613670349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrold' limit 1
loadtime:0.25650715827942 / seconds
Query Executed:select id FROM `sd` where city='Harrold' && SIC_code='7011'DB:business_master_new
loadtime:0.2576150894165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.25767111778259 / seconds
Query Executed:select id FROM `sd` where city='Hartford' && SIC_code='7011'DB:business_master_new
loadtime:0.25887012481689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayes' limit 1
loadtime:0.25892305374146 / seconds
Query Executed:select id FROM `sd` where city='Hayes' && SIC_code='7011'DB:business_master_new
loadtime:0.25954914093018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayti' limit 1
loadtime:0.25959706306458 / seconds
Query Executed:select id FROM `sd` where city='Hayti' && SIC_code='7011'DB:business_master_new
loadtime:0.26064896583557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel' limit 1
loadtime:0.26070117950439 / seconds
Query Executed:select id FROM `sd` where city='Hazel' && SIC_code='7011'DB:business_master_new
loadtime:0.26168513298035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hecla' limit 1
loadtime:0.2617290019989 / seconds
Query Executed:select id FROM `sd` where city='Hecla' && SIC_code='7011'DB:business_master_new
loadtime:0.26269817352295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henry' limit 1
loadtime:0.26275897026062 / seconds
Query Executed:select id FROM `sd` where city='Henry' && SIC_code='7011'DB:business_master_new
loadtime:0.26368713378906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermosa' limit 1
loadtime:0.26373600959778 / seconds
Query Executed:select id FROM `sd` where city='Hermosa' && SIC_code='7011'DB:business_master_new
loadtime:0.26491403579712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herreid' limit 1
loadtime:0.26497507095337 / seconds
Query Executed:select id FROM `sd` where city='Herreid' && SIC_code='7011'DB:business_master_new
loadtime:0.26617908477783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herrick' limit 1
loadtime:0.2662410736084 / seconds
Query Executed:select id FROM `sd` where city='Herrick' && SIC_code='7011'DB:business_master_new
loadtime:0.26704406738281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hetland' limit 1
loadtime:0.26708102226257 / seconds
Query Executed:select id FROM `sd` where city='Hetland' && SIC_code='7011'DB:business_master_new
loadtime:0.26732802391052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highmore' limit 1
loadtime:0.26737213134766 / seconds
Query Executed:select id FROM `sd` where city='Highmore' && SIC_code='7011'DB:business_master_new
loadtime:0.26864910125732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill City' limit 1
loadtime:0.26870918273926 / seconds
Query Executed:select id FROM `sd` where city='Hill City' && SIC_code='7011'DB:business_master_new
loadtime:0.27100300788879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hitchcock' limit 1
loadtime:0.27108097076416 / seconds
Query Executed:select id FROM `sd` where city='Hitchcock' && SIC_code='7011'DB:business_master_new
loadtime:0.27208113670349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holabird' limit 1
loadtime:0.27213311195374 / seconds
Query Executed:select id FROM `sd` where city='Holabird' && SIC_code='7011'DB:business_master_new
loadtime:0.27280807495117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hosmer' limit 1
loadtime:0.2728590965271 / seconds
Query Executed:select id FROM `sd` where city='Hosmer' && SIC_code='7011'DB:business_master_new
loadtime:0.27387714385986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:0.27392315864563 / seconds
Query Executed:select id FROM `sd` where city='Hot Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.27568507194519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.27574610710144 / seconds
Query Executed:select id FROM `sd` where city='Houghton' && SIC_code='7011'DB:business_master_new
loadtime:0.2765371799469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoven' limit 1
loadtime:0.27659106254578 / seconds
Query Executed:select id FROM `sd` where city='Hoven' && SIC_code='7011'DB:business_master_new
loadtime:0.277508020401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howard' limit 1
loadtime:0.27756595611572 / seconds
Query Executed:select id FROM `sd` where city='Howard' && SIC_code='7011'DB:business_master_new
loadtime:0.27859902381897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howes' limit 1
loadtime:0.27864909172058 / seconds
Query Executed:select id FROM `sd` where city='Howes' && SIC_code='7011'DB:business_master_new
loadtime:0.27907395362854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.2791211605072 / seconds
Query Executed:select id FROM `sd` where city='Hudson' && SIC_code='7011'DB:business_master_new
loadtime:0.28015613555908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.28020215034485 / seconds
Query Executed:select id FROM `sd` where city='Humboldt' && SIC_code='7011'DB:business_master_new
loadtime:0.28118205070496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.28123116493225 / seconds
Query Executed:select id FROM `sd` where city='Hurley' && SIC_code='7011'DB:business_master_new
loadtime:0.2822961807251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huron' limit 1
loadtime:0.28235197067261 / seconds
Query Executed:select id FROM `sd` where city='Huron' && SIC_code='7011'DB:business_master_new
loadtime:0.28465795516968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ideal' limit 1
loadtime:0.28472304344177 / seconds
Query Executed:select id FROM `sd` where city='Ideal' && SIC_code='7011'DB:business_master_new
loadtime:0.28510212898254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Igloo' limit 1
loadtime:0.28516006469727 / seconds
Query Executed:select id FROM `sd` where city='Igloo' && SIC_code='7011'DB:business_master_new
loadtime:0.28558802604675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interior' limit 1
loadtime:0.28561997413635 / seconds
Query Executed:select id FROM `sd` where city='Interior' && SIC_code='7011'DB:business_master_new
loadtime:0.28657913208008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:0.28664016723633 / seconds
Query Executed:select id FROM `sd` where city='Ipswich' && SIC_code='7011'DB:business_master_new
loadtime:0.28787112236023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irene' limit 1
loadtime:0.28792715072632 / seconds
Query Executed:select id FROM `sd` where city='Irene' && SIC_code='7011'DB:business_master_new
loadtime:0.28896307945251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iroquois' limit 1
loadtime:0.28900718688965 / seconds
Query Executed:select id FROM `sd` where city='Iroquois' && SIC_code='7011'DB:business_master_new
loadtime:0.29003810882568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isabel' limit 1
loadtime:0.29008603096008 / seconds
Query Executed:select id FROM `sd` where city='Isabel' && SIC_code='7011'DB:business_master_new
loadtime:0.29111313819885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Java' limit 1
loadtime:0.29117107391357 / seconds
Query Executed:select id FROM `sd` where city='Java' && SIC_code='7011'DB:business_master_new
loadtime:0.29224896430969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.29229807853699 / seconds
Query Executed:select id FROM `sd` where city='Jefferson' && SIC_code='7011'DB:business_master_new
loadtime:0.29352307319641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kadoka' limit 1
loadtime:0.29357218742371 / seconds
Query Executed:select id FROM `sd` where city='Kadoka' && SIC_code='7011'DB:business_master_new
loadtime:0.29514002799988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaylor' limit 1
loadtime:0.29519104957581 / seconds
Query Executed:select id FROM `sd` where city='Kaylor' && SIC_code='7011'DB:business_master_new
loadtime:0.2958550453186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keldron' limit 1
loadtime:0.29590797424316 / seconds
Query Executed:select id FROM `sd` where city='Keldron' && SIC_code='7011'DB:business_master_new
loadtime:0.29647612571716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennebec' limit 1
loadtime:0.29650902748108 / seconds
Query Executed:select id FROM `sd` where city='Kennebec' && SIC_code='7011'DB:business_master_new
loadtime:0.29770302772522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.29775905609131 / seconds
Query Executed:select id FROM `sd` where city='Keystone' && SIC_code='7011'DB:business_master_new
loadtime:0.29966711997986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimball' limit 1
loadtime:0.29974317550659 / seconds
Query Executed:select id FROM `sd` where city='Kimball' && SIC_code='7011'DB:business_master_new
loadtime:0.30113005638123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kranzburg' limit 1
loadtime:0.30119299888611 / seconds
Query Executed:select id FROM `sd` where city='Kranzburg' && SIC_code='7011'DB:business_master_new
loadtime:0.30183100700378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kyle' limit 1
loadtime:0.30188512802124 / seconds
Query Executed:select id FROM `sd` where city='Kyle' && SIC_code='7011'DB:business_master_new
loadtime:0.30293011665344 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Plant' limit 1
loadtime:0.30297207832336 / seconds
Query Executed:select id FROM `sd` where city='La Plant' && SIC_code='7011'DB:business_master_new
loadtime:0.30338406562805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Labolt' limit 1
loadtime:0.30343508720398 / seconds
Query Executed:select id FROM `sd` where city='Labolt' && SIC_code='7011'DB:business_master_new
loadtime:0.30408000946045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Andes' limit 1
loadtime:0.30412817001343 / seconds
Query Executed:select id FROM `sd` where city='Lake Andes' && SIC_code='7011'DB:business_master_new
loadtime:0.30558896064758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.30564498901367 / seconds
Query Executed:select id FROM `sd` where city='Lake City' && SIC_code='7011'DB:business_master_new
loadtime:0.30635499954224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Norden' limit 1
loadtime:0.30642509460449 / seconds
Query Executed:select id FROM `sd` where city='Lake Norden' && SIC_code='7011'DB:business_master_new
loadtime:0.30763912200928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Preston' limit 1
loadtime:0.30770015716553 / seconds
Query Executed:select id FROM `sd` where city='Lake Preston' && SIC_code='7011'DB:business_master_new
loadtime:0.30879712104797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lane' limit 1
loadtime:0.30885696411133 / seconds
Query Executed:select id FROM `sd` where city='Lane' && SIC_code='7011'DB:business_master_new
loadtime:0.30914711952209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langford' limit 1
loadtime:0.30918002128601 / seconds
Query Executed:select id FROM `sd` where city='Langford' && SIC_code='7011'DB:business_master_new
loadtime:0.3100311756134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lantry' limit 1
loadtime:0.31008195877075 / seconds
Query Executed:select id FROM `sd` where city='Lantry' && SIC_code='7011'DB:business_master_new
loadtime:0.31061005592346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lead' limit 1
loadtime:0.3106369972229 / seconds
Query Executed:select id FROM `sd` where city='Lead' && SIC_code='7011'DB:business_master_new
loadtime:0.31188797950745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.31195211410522 / seconds
Query Executed:select id FROM `sd` where city='Lebanon' && SIC_code='7011'DB:business_master_new
loadtime:0.31259703636169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemmon' limit 1
loadtime:0.31263995170593 / seconds
Query Executed:select id FROM `sd` where city='Lemmon' && SIC_code='7011'DB:business_master_new
loadtime:0.3136100769043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lennox' limit 1
loadtime:0.3136739730835 / seconds
Query Executed:select id FROM `sd` where city='Lennox' && SIC_code='7011'DB:business_master_new
loadtime:0.31467008590698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leola' limit 1
loadtime:0.31472301483154 / seconds
Query Executed:select id FROM `sd` where city='Leola' && SIC_code='7011'DB:business_master_new
loadtime:0.31590414047241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lesterville' limit 1
loadtime:0.31596112251282 / seconds
Query Executed:select id FROM `sd` where city='Lesterville' && SIC_code='7011'DB:business_master_new
loadtime:0.31695699691772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letcher' limit 1
loadtime:0.31700611114502 / seconds
Query Executed:select id FROM `sd` where city='Letcher' && SIC_code='7011'DB:business_master_new
loadtime:0.31810617446899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Eagle' limit 1
loadtime:0.31816601753235 / seconds
Query Executed:select id FROM `sd` where city='Little Eagle' && SIC_code='7011'DB:business_master_new
loadtime:0.31863903999329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodgepole' limit 1
loadtime:0.31868410110474 / seconds
Query Executed:select id FROM `sd` where city='Lodgepole' && SIC_code='7011'DB:business_master_new
loadtime:0.31928205490112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:0.31933116912842 / seconds
Query Executed:select id FROM `sd` where city='Long Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.31992816925049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longlake' limit 1
loadtime:0.31996917724609 / seconds
Query Executed:select id FROM `sd` where city='Longlake' && SIC_code='7011'DB:business_master_new
loadtime:0.3202121257782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longvalley' limit 1
loadtime:0.32025218009949 / seconds
Query Executed:select id FROM `sd` where city='Longvalley' && SIC_code='7011'DB:business_master_new
loadtime:0.32052898406982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Brule' limit 1
loadtime:0.32056307792664 / seconds
Query Executed:select id FROM `sd` where city='Lower Brule' && SIC_code='7011'DB:business_master_new
loadtime:0.32155108451843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowry' limit 1
loadtime:0.32161211967468 / seconds
Query Executed:select id FROM `sd` where city='Lowry' && SIC_code='7011'DB:business_master_new
loadtime:0.32185506820679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.32189106941223 / seconds
Query Executed:select id FROM `sd` where city='Ludlow' && SIC_code='7011'DB:business_master_new
loadtime:0.32248616218567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:0.3225200176239 / seconds
Query Executed:select id FROM `sd` where city='Lyons' && SIC_code='7011'DB:business_master_new
loadtime:0.32312607765198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.32317018508911 / seconds
Query Executed:select id FROM `sd` where city='Madison' && SIC_code='7011'DB:business_master_new
loadtime:0.32468795776367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manderson' limit 1
loadtime:0.32474803924561 / seconds
Query Executed:select id FROM `sd` where city='Manderson' && SIC_code='7011'DB:business_master_new
loadtime:0.32517910003662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:0.32521510124207 / seconds
Query Executed:select id FROM `sd` where city='Mansfield' && SIC_code='7011'DB:business_master_new
loadtime:0.32609009742737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.32613897323608 / seconds
Query Executed:select id FROM `sd` where city='Marion' && SIC_code='7011'DB:business_master_new
loadtime:0.3275511264801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martin' limit 1
loadtime:0.32760810852051 / seconds
Query Executed:select id FROM `sd` where city='Martin' && SIC_code='7011'DB:business_master_new
loadtime:0.32892918586731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marty' limit 1
loadtime:0.3289840221405 / seconds
Query Executed:select id FROM `sd` where city='Marty' && SIC_code='7011'DB:business_master_new
loadtime:0.32955718040466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marvin' limit 1
loadtime:0.32959699630737 / seconds
Query Executed:select id FROM `sd` where city='Marvin' && SIC_code='7011'DB:business_master_new
loadtime:0.33005213737488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:0.33010101318359 / seconds
Query Executed:select id FROM `sd` where city='Mc Intosh' && SIC_code='7011'DB:business_master_new
loadtime:0.33123898506165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Laughlin' limit 1
loadtime:0.33127808570862 / seconds
Query Executed:select id FROM `sd` where city='Mc Laughlin' && SIC_code='7011'DB:business_master_new
loadtime:0.33252716064453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.33257102966309 / seconds
Query Executed:select id FROM `sd` where city='Meadow' && SIC_code='7011'DB:business_master_new
loadtime:0.33336114883423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meckling' limit 1
loadtime:0.33342599868774 / seconds
Query Executed:select id FROM `sd` where city='Meckling' && SIC_code='7011'DB:business_master_new
loadtime:0.33370304107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mellette' limit 1
loadtime:0.33373498916626 / seconds
Query Executed:select id FROM `sd` where city='Mellette' && SIC_code='7011'DB:business_master_new
loadtime:0.33466506004333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menno' limit 1
loadtime:0.33471512794495 / seconds
Query Executed:select id FROM `sd` where city='Menno' && SIC_code='7011'DB:business_master_new
loadtime:0.33581495285034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:0.33586502075195 / seconds
Query Executed:select id FROM `sd` where city='Midland' && SIC_code='7011'DB:business_master_new
loadtime:0.33683800697327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milbank' limit 1
loadtime:0.33688306808472 / seconds
Query Executed:select id FROM `sd` where city='Milbank' && SIC_code='7011'DB:business_master_new
loadtime:0.3380970954895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milesville' limit 1
loadtime:0.33816504478455 / seconds
Query Executed:select id FROM `sd` where city='Milesville' && SIC_code='7011'DB:business_master_new
loadtime:0.33892917633057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miller' limit 1
loadtime:0.33897995948792 / seconds
Query Executed:select id FROM `sd` where city='Miller' && SIC_code='7011'DB:business_master_new
loadtime:0.34014010429382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mina' limit 1
loadtime:0.34018707275391 / seconds
Query Executed:select id FROM `sd` where city='Mina' && SIC_code='7011'DB:business_master_new
loadtime:0.34062314033508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miranda' limit 1
loadtime:0.34066700935364 / seconds
Query Executed:select id FROM `sd` where city='Miranda' && SIC_code='7011'DB:business_master_new
loadtime:0.34090614318848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission' limit 1
loadtime:0.34095406532288 / seconds
Query Executed:select id FROM `sd` where city='Mission' && SIC_code='7011'DB:business_master_new
loadtime:0.34228610992432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mission Hill' limit 1
loadtime:0.34234499931335 / seconds
Query Executed:select id FROM `sd` where city='Mission Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.34319615364075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.34324908256531 / seconds
Query Executed:select id FROM `sd` where city='Mitchell' && SIC_code='7011'DB:business_master_new
loadtime:0.34564208984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mobridge' limit 1
loadtime:0.34570217132568 / seconds
Query Executed:select id FROM `sd` where city='Mobridge' && SIC_code='7011'DB:business_master_new
loadtime:0.347323179245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.34738612174988 / seconds
Query Executed:select id FROM `sd` where city='Monroe' && SIC_code='7011'DB:business_master_new
loadtime:0.3481559753418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.34820318222046 / seconds
Query Executed:select id FROM `sd` where city='Montrose' && SIC_code='7011'DB:business_master_new
loadtime:0.34919500350952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.34924101829529 / seconds
Query Executed:select id FROM `sd` where city='Morristown' && SIC_code='7011'DB:business_master_new
loadtime:0.34999799728394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound City' limit 1
loadtime:0.35004496574402 / seconds
Query Executed:select id FROM `sd` where city='Mound City' && SIC_code='7011'DB:business_master_new
loadtime:0.35086703300476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.35091805458069 / seconds
Query Executed:select id FROM `sd` where city='Mount Vernon' && SIC_code='7011'DB:business_master_new
loadtime:0.35190200805664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.35195517539978 / seconds
Query Executed:select id FROM `sd` where city='Mt Vernon' && SIC_code='7011'DB:business_master_new
loadtime:0.35223412513733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mud Butte' limit 1
loadtime:0.35227108001709 / seconds
Query Executed:select id FROM `sd` where city='Mud Butte' && SIC_code='7011'DB:business_master_new
loadtime:0.35282897949219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murdo' limit 1
loadtime:0.352872133255 / seconds
Query Executed:select id FROM `sd` where city='Murdo' && SIC_code='7011'DB:business_master_new
loadtime:0.35437297821045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemo' limit 1
loadtime:0.35445308685303 / seconds
Query Executed:select id FROM `sd` where city='Nemo' && SIC_code='7011'DB:business_master_new
loadtime:0.35505104064941 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Effington' limit 1
loadtime:0.35510206222534 / seconds
Query Executed:select id FROM `sd` where city='New Effington' && SIC_code='7011'DB:business_master_new
loadtime:0.3560311794281 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Holland' limit 1
loadtime:0.35608005523682 / seconds
Query Executed:select id FROM `sd` where city='New Holland' && SIC_code='7011'DB:business_master_new
loadtime:0.35681104660034 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Underwood' limit 1
loadtime:0.35685110092163 / seconds
Query Executed:select id FROM `sd` where city='New Underwood' && SIC_code='7011'DB:business_master_new
loadtime:0.35786914825439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.35792517662048 / seconds
Query Executed:select id FROM `sd` where city='Newell' && SIC_code='7011'DB:business_master_new
loadtime:0.35898518562317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nisland' limit 1
loadtime:0.35904717445374 / seconds
Query Executed:select id FROM `sd` where city='Nisland' && SIC_code='7011'DB:business_master_new
loadtime:0.35957813262939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norris' limit 1
loadtime:0.35961508750916 / seconds
Query Executed:select id FROM `sd` where city='Norris' && SIC_code='7011'DB:business_master_new
loadtime:0.36025404930115 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sioux City' limit 1
loadtime:0.36029505729675 / seconds
Query Executed:select id FROM `sd` where city='North Sioux City' && SIC_code='7011'DB:business_master_new
loadtime:0.36196208000183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northville' limit 1
loadtime:0.36202311515808 / seconds
Query Executed:select id FROM `sd` where city='Northville' && SIC_code='7011'DB:business_master_new
loadtime:0.36296415328979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nunda' limit 1
loadtime:0.36300015449524 / seconds
Query Executed:select id FROM `sd` where city='Nunda' && SIC_code='7011'DB:business_master_new
loadtime:0.36359095573425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oacoma' limit 1
loadtime:0.36362910270691 / seconds
Query Executed:select id FROM `sd` where city='Oacoma' && SIC_code='7011'DB:business_master_new
loadtime:0.3646080493927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelrichs' limit 1
loadtime:0.36466097831726 / seconds
Query Executed:select id FROM `sd` where city='Oelrichs' && SIC_code='7011'DB:business_master_new
loadtime:0.36530113220215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oglala' limit 1
loadtime:0.36536502838135 / seconds
Query Executed:select id FROM `sd` where city='Oglala' && SIC_code='7011'DB:business_master_new
loadtime:0.36607718467712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okaton' limit 1
loadtime:0.36613202095032 / seconds
Query Executed:select id FROM `sd` where city='Okaton' && SIC_code='7011'DB:business_master_new
loadtime:0.36661911010742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okreek' limit 1
loadtime:0.36664605140686 / seconds
Query Executed:select id FROM `sd` where city='Okreek' && SIC_code='7011'DB:business_master_new
loadtime:0.36699604988098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldham' limit 1
loadtime:0.36704707145691 / seconds
Query Executed:select id FROM `sd` where city='Oldham' && SIC_code='7011'DB:business_master_new
loadtime:0.3679940700531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivet' limit 1
loadtime:0.36803698539734 / seconds
Query Executed:select id FROM `sd` where city='Olivet' && SIC_code='7011'DB:business_master_new
loadtime:0.36884999275208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onaka' limit 1
loadtime:0.36889100074768 / seconds
Query Executed:select id FROM `sd` where city='Onaka' && SIC_code='7011'DB:business_master_new
loadtime:0.36957812309265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onida' limit 1
loadtime:0.36960411071777 / seconds
Query Executed:select id FROM `sd` where city='Onida' && SIC_code='7011'DB:business_master_new
loadtime:0.37057399749756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opal' limit 1
loadtime:0.37063097953796 / seconds
Query Executed:select id FROM `sd` where city='Opal' && SIC_code='7011'DB:business_master_new
loadtime:0.37088418006897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oral' limit 1
loadtime:0.37091612815857 / seconds
Query Executed:select id FROM `sd` where city='Oral' && SIC_code='7011'DB:business_master_new
loadtime:0.37149715423584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.37153601646423 / seconds
Query Executed:select id FROM `sd` where city='Orient' && SIC_code='7011'DB:business_master_new
loadtime:0.37248396873474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ortley' limit 1
loadtime:0.37253904342651 / seconds
Query Executed:select id FROM `sd` where city='Ortley' && SIC_code='7011'DB:business_master_new
loadtime:0.37299513816833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owanka' limit 1
loadtime:0.37303113937378 / seconds
Query Executed:select id FROM `sd` where city='Owanka' && SIC_code='7011'DB:business_master_new
loadtime:0.37348198890686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.37352108955383 / seconds
Query Executed:select id FROM `sd` where city='Parker' && SIC_code='7011'DB:business_master_new
loadtime:0.3747091293335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkston' limit 1
loadtime:0.37475800514221 / seconds
Query Executed:select id FROM `sd` where city='Parkston' && SIC_code='7011'DB:business_master_new
loadtime:0.37581515312195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmelee' limit 1
loadtime:0.37584710121155 / seconds
Query Executed:select id FROM `sd` where city='Parmelee' && SIC_code='7011'DB:business_master_new
loadtime:0.37651610374451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peever' limit 1
loadtime:0.37655305862427 / seconds
Query Executed:select id FROM `sd` where city='Peever' && SIC_code='7011'DB:business_master_new
loadtime:0.37720203399658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philip' limit 1
loadtime:0.3772439956665 / seconds
Query Executed:select id FROM `sd` where city='Philip' && SIC_code='7011'DB:business_master_new
loadtime:0.37853908538818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickstown' limit 1
loadtime:0.37860012054443 / seconds
Query Executed:select id FROM `sd` where city='Pickstown' && SIC_code='7011'DB:business_master_new
loadtime:0.37960195541382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:0.37966203689575 / seconds
Query Executed:select id FROM `sd` where city='Piedmont' && SIC_code='7011'DB:business_master_new
loadtime:0.3809130191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierpont' limit 1
loadtime:0.38097810745239 / seconds
Query Executed:select id FROM `sd` where city='Pierpont' && SIC_code='7011'DB:business_master_new
loadtime:0.38158106803894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierre' limit 1
loadtime:0.38162398338318 / seconds
Query Executed:select id FROM `sd` where city='Pierre' && SIC_code='7011'DB:business_master_new
loadtime:0.38465118408203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Ridge' limit 1
loadtime:0.38472604751587 / seconds
Query Executed:select id FROM `sd` where city='Pine Ridge' && SIC_code='7011'DB:business_master_new
loadtime:0.38578009605408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plankinton' limit 1
loadtime:0.38583612442017 / seconds
Query Executed:select id FROM `sd` where city='Plankinton' && SIC_code='7011'DB:business_master_new
loadtime:0.3868989944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Platte' limit 1
loadtime:0.38695311546326 / seconds
Query Executed:select id FROM `sd` where city='Platte' && SIC_code='7011'DB:business_master_new
loadtime:0.38810896873474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollock' limit 1
loadtime:0.38816809654236 / seconds
Query Executed:select id FROM `sd` where city='Pollock' && SIC_code='7011'DB:business_master_new
loadtime:0.38922309875488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porcupine' limit 1
loadtime:0.38928198814392 / seconds
Query Executed:select id FROM `sd` where city='Porcupine' && SIC_code='7011'DB:business_master_new
loadtime:0.39007711410522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.39012718200684 / seconds
Query Executed:select id FROM `sd` where city='Prairie City' && SIC_code='7011'DB:business_master_new
loadtime:0.39118409156799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Presho' limit 1
loadtime:0.39123106002808 / seconds
Query Executed:select id FROM `sd` where city='Presho' && SIC_code='7011'DB:business_master_new
loadtime:0.39249706268311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pringle' limit 1
loadtime:0.39254808425903 / seconds
Query Executed:select id FROM `sd` where city='Pringle' && SIC_code='7011'DB:business_master_new
loadtime:0.39310908317566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukwana' limit 1
loadtime:0.39315700531006 / seconds
Query Executed:select id FROM `sd` where city='Pukwana' && SIC_code='7011'DB:business_master_new
loadtime:0.39447402954102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinn' limit 1
loadtime:0.39452409744263 / seconds
Query Executed:select id FROM `sd` where city='Quinn' && SIC_code='7011'DB:business_master_new
loadtime:0.3952009677887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:0.39525008201599 / seconds
Query Executed:select id FROM `sd` where city='Ralph' && SIC_code='7011'DB:business_master_new
loadtime:0.3955500125885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramona' limit 1
loadtime:0.39559006690979 / seconds
Query Executed:select id FROM `sd` where city='Ramona' && SIC_code='7011'DB:business_master_new
loadtime:0.396644115448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rapid City' limit 1
loadtime:0.39669513702393 / seconds
Query Executed:select id FROM `sd` where city='Rapid City' && SIC_code='7011'DB:business_master_new
loadtime:0.41545104980469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ravinia' limit 1
loadtime:0.41557598114014 / seconds
Query Executed:select id FROM `sd` where city='Ravinia' && SIC_code='7011'DB:business_master_new
loadtime:0.41589713096619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.41594505310059 / seconds
Query Executed:select id FROM `sd` where city='Raymond' && SIC_code='7011'DB:business_master_new
loadtime:0.41662406921387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Owl' limit 1
loadtime:0.41665601730347 / seconds
Query Executed:select id FROM `sd` where city='Red Owl' && SIC_code='7011'DB:business_master_new
loadtime:0.41688299179077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.41692304611206 / seconds
Query Executed:select id FROM `sd` where city='Redfield' && SIC_code='7011'DB:business_master_new
loadtime:0.41828918457031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redig' limit 1
loadtime:0.41835117340088 / seconds
Query Executed:select id FROM `sd` where city='Redig' && SIC_code='7011'DB:business_master_new
loadtime:0.41878509521484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ree Heights' limit 1
loadtime:0.41882801055908 / seconds
Query Executed:select id FROM `sd` where city='Ree Heights' && SIC_code='7011'DB:business_master_new
loadtime:0.41963005065918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.4196879863739 / seconds
Query Executed:select id FROM `sd` where city='Reliance' && SIC_code='7011'DB:business_master_new
loadtime:0.42065811157227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renner' limit 1
loadtime:0.42070913314819 / seconds
Query Executed:select id FROM `sd` where city='Renner' && SIC_code='7011'DB:business_master_new
loadtime:0.42153716087341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reva' limit 1
loadtime:0.42158603668213 / seconds
Query Executed:select id FROM `sd` where city='Reva' && SIC_code='7011'DB:business_master_new
loadtime:0.42242217063904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revillo' limit 1
loadtime:0.42246508598328 / seconds
Query Executed:select id FROM `sd` where city='Revillo' && SIC_code='7011'DB:business_master_new
loadtime:0.42360210418701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeview' limit 1
loadtime:0.42365097999573 / seconds
Query Executed:select id FROM `sd` where city='Ridgeview' && SIC_code='7011'DB:business_master_new
loadtime:0.42416906356812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockham' limit 1
loadtime:0.42421507835388 / seconds
Query Executed:select id FROM `sd` where city='Rockham' && SIC_code='7011'DB:business_master_new
loadtime:0.42462110519409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roscoe' limit 1
loadtime:0.42466115951538 / seconds
Query Executed:select id FROM `sd` where city='Roscoe' && SIC_code='7011'DB:business_master_new
loadtime:0.42551612854004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosebud' limit 1
loadtime:0.42554211616516 / seconds
Query Executed:select id FROM `sd` where city='Rosebud' && SIC_code='7011'DB:business_master_new
loadtime:0.42647099494934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosholt' limit 1
loadtime:0.42651295661926 / seconds
Query Executed:select id FROM `sd` where city='Rosholt' && SIC_code='7011'DB:business_master_new
loadtime:0.42750811576843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslyn' limit 1
loadtime:0.42756605148315 / seconds
Query Executed:select id FROM `sd` where city='Roslyn' && SIC_code='7011'DB:business_master_new
loadtime:0.42850399017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowena' limit 1
loadtime:0.42856311798096 / seconds
Query Executed:select id FROM `sd` where city='Rowena' && SIC_code='7011'DB:business_master_new
loadtime:0.42886900901794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.42890214920044 / seconds
Query Executed:select id FROM `sd` where city='Rutland' && SIC_code='7011'DB:business_master_new
loadtime:0.42930102348328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.42933797836304 / seconds
Query Executed:select id FROM `sd` where city='Saint Charles' && SIC_code='7011'DB:business_master_new
loadtime:0.42964911460876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Francis' limit 1
loadtime:0.42967414855957 / seconds
Query Executed:select id FROM `sd` where city='Saint Francis' && SIC_code='7011'DB:business_master_new
loadtime:0.43025517463684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Lawrence' limit 1
loadtime:0.43028998374939 / seconds
Query Executed:select id FROM `sd` where city='Saint Lawrence' && SIC_code='7011'DB:business_master_new
loadtime:0.43085908889771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Onge' limit 1
loadtime:0.43088412284851 / seconds
Query Executed:select id FROM `sd` where city='Saint Onge' && SIC_code='7011'DB:business_master_new
loadtime:0.43129396438599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.43133115768433 / seconds
Query Executed:select id FROM `sd` where city='Salem' && SIC_code='7011'DB:business_master_new
loadtime:0.43213295936584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scenic' limit 1
loadtime:0.43219208717346 / seconds
Query Executed:select id FROM `sd` where city='Scenic' && SIC_code='7011'DB:business_master_new
loadtime:0.43259406089783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.43264317512512 / seconds
Query Executed:select id FROM `sd` where city='Scotland' && SIC_code='7011'DB:business_master_new
loadtime:0.43337416648865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selby' limit 1
loadtime:0.4334180355072 / seconds
Query Executed:select id FROM `sd` where city='Selby' && SIC_code='7011'DB:business_master_new
loadtime:0.43416595458984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seneca' limit 1
loadtime:0.43422603607178 / seconds
Query Executed:select id FROM `sd` where city='Seneca' && SIC_code='7011'DB:business_master_new
loadtime:0.43473601341248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shadehill' limit 1
loadtime:0.43479204177856 / seconds
Query Executed:select id FROM `sd` where city='Shadehill' && SIC_code='7011'DB:business_master_new
loadtime:0.43504405021667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.43508410453796 / seconds
Query Executed:select id FROM `sd` where city='Sherman' && SIC_code='7011'DB:business_master_new
loadtime:0.43531513214111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.43535399436951 / seconds
Query Executed:select id FROM `sd` where city='Silver City' && SIC_code='7011'DB:business_master_new
loadtime:0.43559217453003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinai' limit 1
loadtime:0.43562817573547 / seconds
Query Executed:select id FROM `sd` where city='Sinai' && SIC_code='7011'DB:business_master_new
loadtime:0.43607902526855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Falls' limit 1
loadtime:0.43612003326416 / seconds
Query Executed:select id FROM `sd` where city='Sioux Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.44467210769653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sisseton' limit 1
loadtime:0.44478106498718 / seconds
Query Executed:select id FROM `sd` where city='Sisseton' && SIC_code='7011'DB:business_master_new
loadtime:0.44571900367737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sky Ranch' limit 1
loadtime:0.44577503204346 / seconds
Query Executed:select id FROM `sd` where city='Sky Ranch' && SIC_code='7011'DB:business_master_new
loadtime:0.44604301452637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithwick' limit 1
loadtime:0.44615316390991 / seconds
Query Executed:select id FROM `sd` where city='Smithwick' && SIC_code='7011'DB:business_master_new
loadtime:0.44649696350098 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Shore' limit 1
loadtime:0.44654107093811 / seconds
Query Executed:select id FROM `sd` where city='South Shore' && SIC_code='7011'DB:business_master_new
loadtime:0.44718909263611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spearfish' limit 1
loadtime:0.44723415374756 / seconds
Query Executed:select id FROM `sd` where city='Spearfish' && SIC_code='7011'DB:business_master_new
loadtime:0.44862604141235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.44869709014893 / seconds
Query Executed:select id FROM `sd` where city='Spencer' && SIC_code='7011'DB:business_master_new
loadtime:0.44929695129395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.44934511184692 / seconds
Query Executed:select id FROM `sd` where city='Springfield' && SIC_code='7011'DB:business_master_new
loadtime:0.45012402534485 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.45028710365295 / seconds
Query Executed:select id FROM `sd` where city='St Charles' && SIC_code='7011'DB:business_master_new
loadtime:0.4506139755249 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Francis' limit 1
loadtime:0.45064496994019 / seconds
Query Executed:select id FROM `sd` where city='St Francis' && SIC_code='7011'DB:business_master_new
loadtime:0.45088601112366 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lawrence' limit 1
loadtime:0.45092415809631 / seconds
Query Executed:select id FROM `sd` where city='St Lawrence' && SIC_code='7011'DB:business_master_new
loadtime:0.45117497444153 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Onge' limit 1
loadtime:0.45119905471802 / seconds
Query Executed:select id FROM `sd` where city='St Onge' && SIC_code='7011'DB:business_master_new
loadtime:0.45142316818237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stephan' limit 1
loadtime:0.45145606994629 / seconds
Query Executed:select id FROM `sd` where city='Stephan' && SIC_code='7011'DB:business_master_new
loadtime:0.45181107521057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stickney' limit 1
loadtime:0.45185899734497 / seconds
Query Executed:select id FROM `sd` where city='Stickney' && SIC_code='7011'DB:business_master_new
loadtime:0.45253610610962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:0.45258498191833 / seconds
Query Executed:select id FROM `sd` where city='Stockholm' && SIC_code='7011'DB:business_master_new
loadtime:0.45315217971802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strandburg' limit 1
loadtime:0.45318818092346 / seconds
Query Executed:select id FROM `sd` where city='Strandburg' && SIC_code='7011'DB:business_master_new
loadtime:0.45362114906311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.45367312431335 / seconds
Query Executed:select id FROM `sd` where city='Stratford' && SIC_code='7011'DB:business_master_new
loadtime:0.45418906211853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:0.45423817634583 / seconds
Query Executed:select id FROM `sd` where city='Sturgis' && SIC_code='7011'DB:business_master_new
loadtime:0.45529413223267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.45535802841187 / seconds
Query Executed:select id FROM `sd` where city='Summit' && SIC_code='7011'DB:business_master_new
loadtime:0.4560661315918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:0.45620799064636 / seconds
Query Executed:select id FROM `sd` where city='Tabor' && SIC_code='7011'DB:business_master_new
loadtime:0.45704197883606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tea' limit 1
loadtime:0.45716214179993 / seconds
Query Executed:select id FROM `sd` where city='Tea' && SIC_code='7011'DB:business_master_new
loadtime:0.45809197425842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timber Lake' limit 1
loadtime:0.45824217796326 / seconds
Query Executed:select id FROM `sd` where city='Timber Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.4590311050415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolstoy' limit 1
loadtime:0.4590790271759 / seconds
Query Executed:select id FROM `sd` where city='Tolstoy' && SIC_code='7011'DB:business_master_new
loadtime:0.45969796180725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:0.45975208282471 / seconds
Query Executed:select id FROM `sd` where city='Toronto' && SIC_code='7011'DB:business_master_new
loadtime:0.46042108535767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trail City' limit 1
loadtime:0.46046900749207 / seconds
Query Executed:select id FROM `sd` where city='Trail City' && SIC_code='7011'DB:business_master_new
loadtime:0.46085810661316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent' limit 1
loadtime:0.46089315414429 / seconds
Query Executed:select id FROM `sd` where city='Trent' && SIC_code='7011'DB:business_master_new
loadtime:0.46138310432434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripp' limit 1
loadtime:0.46143412590027 / seconds
Query Executed:select id FROM `sd` where city='Tripp' && SIC_code='7011'DB:business_master_new
loadtime:0.46214008331299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tulare' limit 1
loadtime:0.46218514442444 / seconds
Query Executed:select id FROM `sd` where city='Tulare' && SIC_code='7011'DB:business_master_new
loadtime:0.46286916732788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turton' limit 1
loadtime:0.46291303634644 / seconds
Query Executed:select id FROM `sd` where city='Turton' && SIC_code='7011'DB:business_master_new
loadtime:0.46339011192322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuthill' limit 1
loadtime:0.46344399452209 / seconds
Query Executed:select id FROM `sd` where city='Tuthill' && SIC_code='7011'DB:business_master_new
loadtime:0.46381115913391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Brooks' limit 1
loadtime:0.46385216712952 / seconds
Query Executed:select id FROM `sd` where city='Twin Brooks' && SIC_code='7011'DB:business_master_new
loadtime:0.46438312530518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyndall' limit 1
loadtime:0.46443605422974 / seconds
Query Executed:select id FROM `sd` where city='Tyndall' && SIC_code='7011'DB:business_master_new
loadtime:0.46520018577576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Center' limit 1
loadtime:0.46524310112 / seconds
Query Executed:select id FROM `sd` where city='Union Center' && SIC_code='7011'DB:business_master_new
loadtime:0.46584510803223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:0.46597814559937 / seconds
Query Executed:select id FROM `sd` where city='Utica' && SIC_code='7011'DB:business_master_new
loadtime:0.46663308143616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:0.46667313575745 / seconds
Query Executed:select id FROM `sd` where city='Vale' && SIC_code='7011'DB:business_master_new
loadtime:0.46734595298767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Springs' limit 1
loadtime:0.46739196777344 / seconds
Query Executed:select id FROM `sd` where city='Valley Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.46808314323425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veblen' limit 1
loadtime:0.46812510490417 / seconds
Query Executed:select id FROM `sd` where city='Veblen' && SIC_code='7011'DB:business_master_new
loadtime:0.46887803077698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vermillion' limit 1
loadtime:0.46904516220093 / seconds
Query Executed:select id FROM `sd` where city='Vermillion' && SIC_code='7011'DB:business_master_new
loadtime:0.47015810012817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viborg' limit 1
loadtime:0.47021913528442 / seconds
Query Executed:select id FROM `sd` where city='Viborg' && SIC_code='7011'DB:business_master_new
loadtime:0.47099804878235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:0.47114610671997 / seconds
Query Executed:select id FROM `sd` where city='Vienna' && SIC_code='7011'DB:business_master_new
loadtime:0.47170114517212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgil' limit 1
loadtime:0.47175097465515 / seconds
Query Executed:select id FROM `sd` where city='Virgil' && SIC_code='7011'DB:business_master_new
loadtime:0.47213506698608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vivian' limit 1
loadtime:0.4722580909729 / seconds
Query Executed:select id FROM `sd` where city='Vivian' && SIC_code='7011'DB:business_master_new
loadtime:0.47293210029602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:0.47299408912659 / seconds
Query Executed:select id FROM `sd` where city='Volga' && SIC_code='7011'DB:business_master_new
loadtime:0.47374796867371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volin' limit 1
loadtime:0.47378897666931 / seconds
Query Executed:select id FROM `sd` where city='Volin' && SIC_code='7011'DB:business_master_new
loadtime:0.4745180606842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagner' limit 1
loadtime:0.47456908226013 / seconds
Query Executed:select id FROM `sd` where city='Wagner' && SIC_code='7011'DB:business_master_new
loadtime:0.47538018226624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakonda' limit 1
loadtime:0.47543907165527 / seconds
Query Executed:select id FROM `sd` where city='Wakonda' && SIC_code='7011'DB:business_master_new
loadtime:0.47616314888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakpala' limit 1
loadtime:0.47622299194336 / seconds
Query Executed:select id FROM `sd` where city='Wakpala' && SIC_code='7011'DB:business_master_new
loadtime:0.47656011581421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:0.4765989780426 / seconds
Query Executed:select id FROM `sd` where city='Wall' && SIC_code='7011'DB:business_master_new
loadtime:0.47746801376343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:0.47753500938416 / seconds
Query Executed:select id FROM `sd` where city='Wallace' && SIC_code='7011'DB:business_master_new
loadtime:0.47796702384949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanblee' limit 1
loadtime:0.47800898551941 / seconds
Query Executed:select id FROM `sd` where city='Wanblee' && SIC_code='7011'DB:business_master_new
loadtime:0.47846913337708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:0.47851014137268 / seconds
Query Executed:select id FROM `sd` where city='Ward' && SIC_code='7011'DB:business_master_new
loadtime:0.4787609577179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.47884702682495 / seconds
Query Executed:select id FROM `sd` where city='Warner' && SIC_code='7011'DB:business_master_new
loadtime:0.47951817512512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wasta' limit 1
loadtime:0.4795560836792 / seconds
Query Executed:select id FROM `sd` where city='Wasta' && SIC_code='7011'DB:business_master_new
loadtime:0.47999405860901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watauga' limit 1
loadtime:0.48004412651062 / seconds
Query Executed:select id FROM `sd` where city='Watauga' && SIC_code='7011'DB:business_master_new
loadtime:0.48035216331482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.48039603233337 / seconds
Query Executed:select id FROM `sd` where city='Watertown' && SIC_code='7011'DB:business_master_new
loadtime:0.4820351600647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waubay' limit 1
loadtime:0.48210310935974 / seconds
Query Executed:select id FROM `sd` where city='Waubay' && SIC_code='7011'DB:business_master_new
loadtime:0.4828929901123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:0.48295307159424 / seconds
Query Executed:select id FROM `sd` where city='Waverly' && SIC_code='7011'DB:business_master_new
loadtime:0.48319101333618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.48322701454163 / seconds
Query Executed:select id FROM `sd` where city='Webster' && SIC_code='7011'DB:business_master_new
loadtime:0.48416209220886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wecota' limit 1
loadtime:0.48423004150391 / seconds
Query Executed:select id FROM `sd` where city='Wecota' && SIC_code='7011'DB:business_master_new
loadtime:0.48449015617371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.48459196090698 / seconds
Query Executed:select id FROM `sd` where city='Wentworth' && SIC_code='7011'DB:business_master_new
loadtime:0.48536205291748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington' limit 1
loadtime:0.4854199886322 / seconds
Query Executed:select id FROM `sd` where city='Wessington' && SIC_code='7011'DB:business_master_new
loadtime:0.48612308502197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Spgs' limit 1
loadtime:0.48618102073669 / seconds
Query Executed:select id FROM `sd` where city='Wessington Spgs' && SIC_code='7011'DB:business_master_new
loadtime:0.48644804954529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wessington Springs' limit 1
loadtime:0.48647999763489 / seconds
Query Executed:select id FROM `sd` where city='Wessington Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.4872579574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.4873161315918 / seconds
Query Executed:select id FROM `sd` where city='Westport' && SIC_code='7011'DB:business_master_new
loadtime:0.48802709579468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetonka' limit 1
loadtime:0.48816514015198 / seconds
Query Executed:select id FROM `sd` where city='Wetonka' && SIC_code='7011'DB:business_master_new
loadtime:0.48852205276489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wewela' limit 1
loadtime:0.48855304718018 / seconds
Query Executed:select id FROM `sd` where city='Wewela' && SIC_code='7011'DB:business_master_new
loadtime:0.4888219833374 / seconds
Query loaded from cache:select * from geodata_geocity where city='White' limit 1
loadtime:0.48892211914062 / seconds
Query Executed:select id FROM `sd` where city='White' && SIC_code='7011'DB:business_master_new
loadtime:0.48973298072815 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Lake' limit 1
loadtime:0.48978495597839 / seconds
Query Executed:select id FROM `sd` where city='White Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.49049711227417 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Owl' limit 1
loadtime:0.49054908752441 / seconds
Query Executed:select id FROM `sd` where city='White Owl' && SIC_code='7011'DB:business_master_new
loadtime:0.49092316627502 / seconds
Query loaded from cache:select * from geodata_geocity where city='White River' limit 1
loadtime:0.49104404449463 / seconds
Query Executed:select id FROM `sd` where city='White River' && SIC_code='7011'DB:business_master_new
loadtime:0.49190211296082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehorse' limit 1
loadtime:0.49205708503723 / seconds
Query Executed:select id FROM `sd` where city='Whitehorse' && SIC_code='7011'DB:business_master_new
loadtime:0.49240708351135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitewood' limit 1
loadtime:0.49245095252991 / seconds
Query Executed:select id FROM `sd` where city='Whitewood' && SIC_code='7011'DB:business_master_new
loadtime:0.49315500259399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Lake' limit 1
loadtime:0.49320507049561 / seconds
Query Executed:select id FROM `sd` where city='Willow Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.49394702911377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.49410510063171 / seconds
Query Executed:select id FROM `sd` where city='Wilmot' && SIC_code='7011'DB:business_master_new
loadtime:0.494873046875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfred' limit 1
loadtime:0.49490904808044 / seconds
Query Executed:select id FROM `sd` where city='Winfred' && SIC_code='7011'DB:business_master_new
loadtime:0.49554109573364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winner' limit 1
loadtime:0.4955849647522 / seconds
Query Executed:select id FROM `sd` where city='Winner' && SIC_code='7011'DB:business_master_new
loadtime:0.49655318260193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Witten' limit 1
loadtime:0.49660706520081 / seconds
Query Executed:select id FROM `sd` where city='Witten' && SIC_code='7011'DB:business_master_new
loadtime:0.49705910682678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolsey' limit 1
loadtime:0.49711012840271 / seconds
Query Executed:select id FROM `sd` where city='Wolsey' && SIC_code='7011'DB:business_master_new
loadtime:0.49784398078918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood' limit 1
loadtime:0.49793195724487 / seconds
Query Executed:select id FROM `sd` where city='Wood' && SIC_code='7011'DB:business_master_new
loadtime:0.49858498573303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woonsocket' limit 1
loadtime:0.49862003326416 / seconds
Query Executed:select id FROM `sd` where city='Woonsocket' && SIC_code='7011'DB:business_master_new
loadtime:0.49940896034241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthing' limit 1
loadtime:0.49947309494019 / seconds
Query Executed:select id FROM `sd` where city='Worthing' && SIC_code='7011'DB:business_master_new
loadtime:0.50013017654419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wounded Knee' limit 1
loadtime:0.50017309188843 / seconds
Query Executed:select id FROM `sd` where city='Wounded Knee' && SIC_code='7011'DB:business_master_new
loadtime:0.50050210952759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:0.50054097175598 / seconds
Query Executed:select id FROM `sd` where city='Yale' && SIC_code='7011'DB:business_master_new
loadtime:0.50119495391846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yankton' limit 1
loadtime:0.50124216079712 / seconds
Query Executed:select id FROM `sd` where city='Yankton' && SIC_code='7011'DB:business_master_new
loadtime:0.5026261806488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zell' limit 1
loadtime:0.50267696380615 / seconds
Query Executed:select id FROM `sd` where city='Zell' && SIC_code='7011'DB:business_master_new
loadtime:0.50291895866394 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.50299310684204 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.50316095352173 / seconds
Operation template executed (chunk cache operation)
loadtime:0.50323295593262 / seconds
template override:Default
loadtime:0.50325107574463 / 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.50403308868408 / seconds
Template Constructed, Array Rows:49
loadtime:0.50426697731018 / seconds
TOTAL EXECUTION TIME: 0.50408
loadtime:0.50436496734619 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => hotels-and-motels [stateURLid] => 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.50436997413635
TOTAL KEY ARRAYS: 69