Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.9843063354492E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017528533935547 / seconds
host not found setting manual db connection
loadtime:0.0094690322875977 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097370147705078 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099060535430908 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0099680423736572 / seconds
zipcode:
loadtime:0.0099949836730957 / seconds
Query Executed:select * from search_referrer where page_hash='b707f4f364f8ac4f0746340a68f3efde' limit 10 DB:ezrox_toadli
loadtime:0.010241985321045 / seconds
Operation header executed (non global)
loadtime:0.010273933410645 / seconds
Operation leaderboard executed (non global)
loadtime:0.010324954986572 / seconds
Operation square executed (non global)
loadtime:0.010354995727539 / seconds
Operation square_bottom executed (non global)
loadtime:0.010381937026978 / seconds
Operation smallsquare executed (non global)
loadtime:0.0104079246521 / seconds
Operation headeradright executed (non global)
loadtime:0.010432958602905 / seconds
Operation google_analytics executed (non global)
loadtime:0.010457992553711 / seconds
Operation topstories executed (non global)
loadtime:0.010483026504517 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010509967803955 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010535001754761 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010781049728394 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010948896408081 / seconds
Operation categories executed (global stored into APC)
loadtime:0.010985851287842 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011044025421143 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011090993881226 / seconds
Template key: archive_menu pushed
loadtime:0.011100053787231 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011113882064819 / seconds
Template key: get_gravatar pushed
loadtime:0.011119842529297 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011128902435303 / seconds
*10)-10)+1 | start:0
loadtime:0.011168956756592 / seconds
Query loaded from cache:select * from categories where cat_URLid='furniture-stores'
loadtime:0.011209964752197 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.011245012283325 / seconds
DB connected to localhost business_master_new
loadtime:0.01147985458374 / seconds
Query Executed:select * from `ms_catmap` where sic='5712' order by city ascDB:business_master_new
loadtime:0.028535842895508 / seconds
Query stored in cache : _QUERY_www.toadli.coma8047f50a82f9559a997b7eac2d5fad8
loadtime:0.030400037765503 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.030457019805908 / seconds
Query Executed:select sum(totalcount) as totalsum from `ms_catmap` where sic='5712'DB:business_master_new
loadtime:0.032928943634033 / seconds
Query stored in cache : _QUERY_www.toadli.comc04d6d2d6a9bb9e54b0d6ac975f3ea20
loadtime:0.032968997955322 / seconds
463 / 11
loadtime:0.033025026321411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbeville' limit 1
loadtime:0.033092021942139 / seconds
Query Executed:select id FROM `ms` where city='Abbeville' && SIC_code='5712'DB:business_master_new
loadtime:0.0434889793396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.043572902679443 / seconds
Query Executed:select id FROM `ms` where city='Aberdeen' && SIC_code='5712'DB:business_master_new
loadtime:0.049474954605103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackerman' limit 1
loadtime:0.049556970596313 / seconds
Query Executed:select id FROM `ms` where city='Ackerman' && SIC_code='5712'DB:business_master_new
loadtime:0.053186893463135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agricola' limit 1
loadtime:0.053264856338501 / seconds
Query Executed:select id FROM `ms` where city='Agricola' && SIC_code='5712'DB:business_master_new
loadtime:0.0536949634552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcorn State' limit 1
loadtime:0.053766965866089 / seconds
Query Executed:select id FROM `ms` where city='Alcorn State' && SIC_code='5712'DB:business_master_new
loadtime:0.054179906845093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algoma' limit 1
loadtime:0.054239988327026 / seconds
Query Executed:select id FROM `ms` where city='Algoma' && SIC_code='5712'DB:business_master_new
loadtime:0.054711818695068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alligator' limit 1
loadtime:0.054783821105957 / seconds
Query Executed:select id FROM `ms` where city='Alligator' && SIC_code='5712'DB:business_master_new
loadtime:0.055408954620361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amory' limit 1
loadtime:0.055469036102295 / seconds
Query Executed:select id FROM `ms` where city='Amory' && SIC_code='5712'DB:business_master_new
loadtime:0.062119007110596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anguilla' limit 1
loadtime:0.062201023101807 / seconds
Query Executed:select id FROM `ms` where city='Anguilla' && SIC_code='5712'DB:business_master_new
loadtime:0.063010931015015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.063072919845581 / seconds
Query Executed:select id FROM `ms` where city='Arcola' && SIC_code='5712'DB:business_master_new
loadtime:0.063755035400391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkabutla' limit 1
loadtime:0.063815832138062 / seconds
Query Executed:select id FROM `ms` where city='Arkabutla' && SIC_code='5712'DB:business_master_new
loadtime:0.064280033111572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.064342975616455 / seconds
Query Executed:select id FROM `ms` where city='Artesia' && SIC_code='5712'DB:business_master_new
loadtime:0.064949989318848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.065011024475098 / seconds
Query Executed:select id FROM `ms` where city='Ashland' && SIC_code='5712'DB:business_master_new
loadtime:0.067605972290039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.067667961120605 / seconds
Query Executed:select id FROM `ms` where city='Avalon' && SIC_code='5712'DB:business_master_new
loadtime:0.06806492805481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.06812596321106 / seconds
Query Executed:select id FROM `ms` where city='Avon' && SIC_code='5712'DB:business_master_new
loadtime:0.068662881851196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.068734884262085 / seconds
Query Executed:select id FROM `ms` where city='Bailey' && SIC_code='5712'DB:business_master_new
loadtime:0.069476842880249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwyn' limit 1
loadtime:0.06955099105835 / seconds
Query Executed:select id FROM `ms` where city='Baldwyn' && SIC_code='5712'DB:business_master_new
loadtime:0.073660850524902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banner' limit 1
loadtime:0.07375693321228 / seconds
Query Executed:select id FROM `ms` where city='Banner' && SIC_code='5712'DB:business_master_new
loadtime:0.074244022369385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassfield' limit 1
loadtime:0.074306011199951 / seconds
Query Executed:select id FROM `ms` where city='Bassfield' && SIC_code='5712'DB:business_master_new
loadtime:0.075623035430908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.075683832168579 / seconds
Query Executed:select id FROM `ms` where city='Batesville' && SIC_code='5712'DB:business_master_new
loadtime:0.085392951965332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Saint Louis' limit 1
loadtime:0.085479974746704 / seconds
Query Executed:select id FROM `ms` where city='Bay Saint Louis' && SIC_code='5712'DB:business_master_new
loadtime:0.096266984939575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Springs' limit 1
loadtime:0.096353054046631 / seconds
Query Executed:select id FROM `ms` where city='Bay Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.099812030792236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay St Louis' limit 1
loadtime:0.099889039993286 / seconds
Query Executed:select id FROM `ms` where city='Bay St Louis' && SIC_code='5712'DB:business_master_new
loadtime:0.10087585449219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.10093903541565 / seconds
Query Executed:select id FROM `ms` where city='Beaumont' && SIC_code='5712'DB:business_master_new
loadtime:0.10190296173096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becker' limit 1
loadtime:0.10196399688721 / seconds
Query Executed:select id FROM `ms` where city='Becker' && SIC_code='5712'DB:business_master_new
loadtime:0.1024329662323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belden' limit 1
loadtime:0.10249400138855 / seconds
Query Executed:select id FROM `ms` where city='Belden' && SIC_code='5712'DB:business_master_new
loadtime:0.10449194908142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.10457396507263 / seconds
Query Executed:select id FROM `ms` where city='Belen' && SIC_code='5712'DB:business_master_new
loadtime:0.10501503944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellefontaine' limit 1
loadtime:0.10507702827454 / seconds
Query Executed:select id FROM `ms` where city='Bellefontaine' && SIC_code='5712'DB:business_master_new
loadtime:0.10553693771362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.10560297966003 / seconds
Query Executed:select id FROM `ms` where city='Belmont' && SIC_code='5712'DB:business_master_new
loadtime:0.10833883285522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belzoni' limit 1
loadtime:0.10841584205627 / seconds
Query Executed:select id FROM `ms` where city='Belzoni' && SIC_code='5712'DB:business_master_new
loadtime:0.11260986328125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benoit' limit 1
loadtime:0.11268997192383 / seconds
Query Executed:select id FROM `ms` where city='Benoit' && SIC_code='5712'DB:business_master_new
loadtime:0.11352682113647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.1135950088501 / seconds
Query Executed:select id FROM `ms` where city='Benton' && SIC_code='5712'DB:business_master_new
loadtime:0.11462092399597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonia' limit 1
loadtime:0.11468100547791 / seconds
Query Executed:select id FROM `ms` where city='Bentonia' && SIC_code='5712'DB:business_master_new
loadtime:0.11589384078979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.11595582962036 / seconds
Query Executed:select id FROM `ms` where city='Beulah' && SIC_code='5712'DB:business_master_new
loadtime:0.11646294593811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Creek' limit 1
loadtime:0.11652183532715 / seconds
Query Executed:select id FROM `ms` where city='Big Creek' && SIC_code='5712'DB:business_master_new
loadtime:0.11707782745361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biloxi' limit 1
loadtime:0.11713790893555 / seconds
Query Executed:select id FROM `ms` where city='Biloxi' && SIC_code='5712'DB:business_master_new
loadtime:0.12483501434326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Mountain' limit 1
loadtime:0.12492895126343 / seconds
Query Executed:select id FROM `ms` where city='Blue Mountain' && SIC_code='5712'DB:business_master_new
loadtime:0.12604594230652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Springs' limit 1
loadtime:0.12612390518188 / seconds
Query Executed:select id FROM `ms` where city='Blue Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.12702488899231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bogue Chitto' limit 1
loadtime:0.12708592414856 / seconds
Query Executed:select id FROM `ms` where city='Bogue Chitto' && SIC_code='5712'DB:business_master_new
loadtime:0.12836098670959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.12842202186584 / seconds
Query Executed:select id FROM `ms` where city='Bolton' && SIC_code='5712'DB:business_master_new
loadtime:0.12988901138306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booneville' limit 1
loadtime:0.12995004653931 / seconds
Query Executed:select id FROM `ms` where city='Booneville' && SIC_code='5712'DB:business_master_new
loadtime:0.13851284980774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyle' limit 1
loadtime:0.1386079788208 / seconds
Query Executed:select id FROM `ms` where city='Boyle' && SIC_code='5712'DB:business_master_new
loadtime:0.13977289199829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.13983583450317 / seconds
Query Executed:select id FROM `ms` where city='Brandon' && SIC_code='5712'DB:business_master_new
loadtime:0.14717388153076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braxton' limit 1
loadtime:0.14725685119629 / seconds
Query Executed:select id FROM `ms` where city='Braxton' && SIC_code='5712'DB:business_master_new
loadtime:0.1480119228363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookhaven' limit 1
loadtime:0.14807391166687 / seconds
Query Executed:select id FROM `ms` where city='Brookhaven' && SIC_code='5712'DB:business_master_new
loadtime:0.16084289550781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.16093587875366 / seconds
Query Executed:select id FROM `ms` where city='Brooklyn' && SIC_code='5712'DB:business_master_new
loadtime:0.16185402870178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooksville' limit 1
loadtime:0.16191792488098 / seconds
Query Executed:select id FROM `ms` where city='Brooksville' && SIC_code='5712'DB:business_master_new
loadtime:0.16312599182129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.16318702697754 / seconds
Query Executed:select id FROM `ms` where city='Bruce' && SIC_code='5712'DB:business_master_new
loadtime:0.16633486747742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckatunna' limit 1
loadtime:0.16641092300415 / seconds
Query Executed:select id FROM `ms` where city='Buckatunna' && SIC_code='5712'DB:business_master_new
loadtime:0.16733002662659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bude' limit 1
loadtime:0.16739201545715 / seconds
Query Executed:select id FROM `ms` where city='Bude' && SIC_code='5712'DB:business_master_new
loadtime:0.16852402687073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.16858887672424 / seconds
Query Executed:select id FROM `ms` where city='Burnsville' && SIC_code='5712'DB:business_master_new
loadtime:0.17040586471558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byhalia' limit 1
loadtime:0.17048096656799 / seconds
Query Executed:select id FROM `ms` where city='Byhalia' && SIC_code='5712'DB:business_master_new
loadtime:0.17449498176575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byram' limit 1
loadtime:0.17457890510559 / seconds
Query Executed:select id FROM `ms` where city='Byram' && SIC_code='5712'DB:business_master_new
loadtime:0.18022584915161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.18028903007507 / seconds
Query Executed:select id FROM `ms` where city='Caledonia' && SIC_code='5712'DB:business_master_new
loadtime:0.18167781829834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhoun City' limit 1
loadtime:0.18175196647644 / seconds
Query Executed:select id FROM `ms` where city='Calhoun City' && SIC_code='5712'DB:business_master_new
loadtime:0.18544888496399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.18552994728088 / seconds
Query Executed:select id FROM `ms` where city='Camden' && SIC_code='5712'DB:business_master_new
loadtime:0.18616199493408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.18622398376465 / seconds
Query Executed:select id FROM `ms` where city='Canton' && SIC_code='5712'DB:business_master_new
loadtime:0.19486904144287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carriere' limit 1
loadtime:0.19495391845703 / seconds
Query Executed:select id FROM `ms` where city='Carriere' && SIC_code='5712'DB:business_master_new
loadtime:0.19839692115784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.19847393035889 / seconds
Query Executed:select id FROM `ms` where city='Carrollton' && SIC_code='5712'DB:business_master_new
loadtime:0.19976091384888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.19982290267944 / seconds
Query Executed:select id FROM `ms` where city='Carson' && SIC_code='5712'DB:business_master_new
loadtime:0.20049285888672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.20055389404297 / seconds
Query Executed:select id FROM `ms` where city='Carthage' && SIC_code='5712'DB:business_master_new
loadtime:0.20667195320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:0.20676684379578 / seconds
Query Executed:select id FROM `ms` where city='Cary' && SIC_code='5712'DB:business_master_new
loadtime:0.20745992660522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascilla' limit 1
loadtime:0.20752286911011 / seconds
Query Executed:select id FROM `ms` where city='Cascilla' && SIC_code='5712'DB:business_master_new
loadtime:0.20807886123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarbluff' limit 1
loadtime:0.20813989639282 / seconds
Query Executed:select id FROM `ms` where city='Cedarbluff' && SIC_code='5712'DB:business_master_new
loadtime:0.20893883705139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.20899987220764 / seconds
Query Executed:select id FROM `ms` where city='Centreville' && SIC_code='5712'DB:business_master_new
loadtime:0.21141195297241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.21147394180298 / seconds
Query Executed:select id FROM `ms` where city='Charleston' && SIC_code='5712'DB:business_master_new
loadtime:0.21508097648621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatawa' limit 1
loadtime:0.21516084671021 / seconds
Query Executed:select id FROM `ms` where city='Chatawa' && SIC_code='5712'DB:business_master_new
loadtime:0.21563696861267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.21569895744324 / seconds
Query Executed:select id FROM `ms` where city='Chatham' && SIC_code='5712'DB:business_master_new
loadtime:0.2161979675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Choctaw' limit 1
loadtime:0.21625804901123 / seconds
Query Executed:select id FROM `ms` where city='Choctaw' && SIC_code='5712'DB:business_master_new
loadtime:0.21667885780334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chunky' limit 1
loadtime:0.21675086021423 / seconds
Query Executed:select id FROM `ms` where city='Chunky' && SIC_code='5712'DB:business_master_new
loadtime:0.21736001968384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clara' limit 1
loadtime:0.21741986274719 / seconds
Query Executed:select id FROM `ms` where city='Clara' && SIC_code='5712'DB:business_master_new
loadtime:0.21796894073486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksdale' limit 1
loadtime:0.21802997589111 / seconds
Query Executed:select id FROM `ms` where city='Clarksdale' && SIC_code='5712'DB:business_master_new
loadtime:0.2302348613739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.23032999038696 / seconds
Query Executed:select id FROM `ms` where city='Cleveland' && SIC_code='5712'DB:business_master_new
loadtime:0.24141788482666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.24151396751404 / seconds
Query Executed:select id FROM `ms` where city='Clinton' && SIC_code='5712'DB:business_master_new
loadtime:0.25213289260864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coahoma' limit 1
loadtime:0.25221586227417 / seconds
Query Executed:select id FROM `ms` where city='Coahoma' && SIC_code='5712'DB:business_master_new
loadtime:0.25284504890442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coffeeville' limit 1
loadtime:0.25290703773499 / seconds
Query Executed:select id FROM `ms` where city='Coffeeville' && SIC_code='5712'DB:business_master_new
loadtime:0.25475382804871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coila' limit 1
loadtime:0.25481486320496 / seconds
Query Executed:select id FROM `ms` where city='Coila' && SIC_code='5712'DB:business_master_new
loadtime:0.25537896156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.25543999671936 / seconds
Query Executed:select id FROM `ms` where city='Coldwater' && SIC_code='5712'DB:business_master_new
loadtime:0.25901389122009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.25909090042114 / seconds
Query Executed:select id FROM `ms` where city='Collins' && SIC_code='5712'DB:business_master_new
loadtime:0.2643940448761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.26447105407715 / seconds
Query Executed:select id FROM `ms` where city='Collinsville' && SIC_code='5712'DB:business_master_new
loadtime:0.26613283157349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.26620984077454 / seconds
Query Executed:select id FROM `ms` where city='Columbia' && SIC_code='5712'DB:business_master_new
loadtime:0.27544283866882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.27552485466003 / seconds
Query Executed:select id FROM `ms` where city='Columbus' && SIC_code='5712'DB:business_master_new
loadtime:0.28320693969727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Afb' limit 1
loadtime:0.28330993652344 / seconds
Query Executed:select id FROM `ms` where city='Columbus Afb' && SIC_code='5712'DB:business_master_new
loadtime:0.28388690948486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.28395199775696 / seconds
Query Executed:select id FROM `ms` where city='Como' && SIC_code='5712'DB:business_master_new
loadtime:0.28546786308289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conehatta' limit 1
loadtime:0.28554391860962 / seconds
Query Executed:select id FROM `ms` where city='Conehatta' && SIC_code='5712'DB:business_master_new
loadtime:0.28619599342346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.28625798225403 / seconds
Query Executed:select id FROM `ms` where city='Corinth' && SIC_code='5712'DB:business_master_new
loadtime:0.30208086967468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.3021719455719 / seconds
Query Executed:select id FROM `ms` where city='Courtland' && SIC_code='5712'DB:business_master_new
loadtime:0.30282998085022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:0.30289387702942 / seconds
Query Executed:select id FROM `ms` where city='Crawford' && SIC_code='5712'DB:business_master_new
loadtime:0.30382990837097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crenshaw' limit 1
loadtime:0.30389189720154 / seconds
Query Executed:select id FROM `ms` where city='Crenshaw' && SIC_code='5712'DB:business_master_new
loadtime:0.3047399520874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crosby' limit 1
loadtime:0.30481386184692 / seconds
Query Executed:select id FROM `ms` where city='Crosby' && SIC_code='5712'DB:business_master_new
loadtime:0.30555105209351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowder' limit 1
loadtime:0.30561590194702 / seconds
Query Executed:select id FROM `ms` where city='Crowder' && SIC_code='5712'DB:business_master_new
loadtime:0.30615997314453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cruger' limit 1
loadtime:0.30622100830078 / seconds
Query Executed:select id FROM `ms` where city='Cruger' && SIC_code='5712'DB:business_master_new
loadtime:0.30678296089172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Springs' limit 1
loadtime:0.30684399604797 / seconds
Query Executed:select id FROM `ms` where city='Crystal Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.31153702735901 / seconds
Query loaded from cache:select * from geodata_geocity where city='D Lo' limit 1
loadtime:0.31162190437317 / seconds
Query Executed:select id FROM `ms` where city='D Lo' && SIC_code='5712'DB:business_master_new
loadtime:0.31225204467773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:0.3123140335083 / seconds
Query Executed:select id FROM `ms` where city='Daleville' && SIC_code='5712'DB:business_master_new
loadtime:0.3128719329834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darling' limit 1
loadtime:0.31293296813965 / seconds
Query Executed:select id FROM `ms` where city='Darling' && SIC_code='5712'DB:business_master_new
loadtime:0.31338286399841 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Kalb' limit 1
loadtime:0.31344389915466 / seconds
Query Executed:select id FROM `ms` where city='De Kalb' && SIC_code='5712'DB:business_master_new
loadtime:0.31656193733215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.31666088104248 / seconds
Query Executed:select id FROM `ms` where city='Decatur' && SIC_code='5712'DB:business_master_new
loadtime:0.3183388710022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta City' limit 1
loadtime:0.31840205192566 / seconds
Query Executed:select id FROM `ms` where city='Delta City' && SIC_code='5712'DB:business_master_new
loadtime:0.31887793540955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.3189389705658 / seconds
Query Executed:select id FROM `ms` where city='Dennis' && SIC_code='5712'DB:business_master_new
loadtime:0.31975603103638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derma' limit 1
loadtime:0.31981682777405 / seconds
Query Executed:select id FROM `ms` where city='Derma' && SIC_code='5712'DB:business_master_new
loadtime:0.32045197486877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamondhead' limit 1
loadtime:0.32051301002502 / seconds
Query Executed:select id FROM `ms` where city='Diamondhead' && SIC_code='5712'DB:business_master_new
loadtime:0.32403802871704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diberville' limit 1
loadtime:0.32411503791809 / seconds
Query Executed:select id FROM `ms` where city='Diberville' && SIC_code='5712'DB:business_master_new
loadtime:0.32998585700989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doddsville' limit 1
loadtime:0.33006286621094 / seconds
Query Executed:select id FROM `ms` where city='Doddsville' && SIC_code='5712'DB:business_master_new
loadtime:0.33062100410461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drew' limit 1
loadtime:0.33068299293518 / seconds
Query Executed:select id FROM `ms` where city='Drew' && SIC_code='5712'DB:business_master_new
loadtime:0.33291697502136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.3329918384552 / seconds
Query Executed:select id FROM `ms` where city='Dublin' && SIC_code='5712'DB:business_master_new
loadtime:0.33350300788879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Hill' limit 1
loadtime:0.33357000350952 / seconds
Query Executed:select id FROM `ms` where city='Duck Hill' && SIC_code='5712'DB:business_master_new
loadtime:0.33450102806091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumas' limit 1
loadtime:0.33456683158875 / seconds
Query Executed:select id FROM `ms` where city='Dumas' && SIC_code='5712'DB:business_master_new
loadtime:0.33515691757202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.33521795272827 / seconds
Query Executed:select id FROM `ms` where city='Duncan' && SIC_code='5712'DB:business_master_new
loadtime:0.33576488494873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.33582496643066 / seconds
Query Executed:select id FROM `ms` where city='Dundee' && SIC_code='5712'DB:business_master_new
loadtime:0.33655285835266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.33661794662476 / seconds
Query Executed:select id FROM `ms` where city='Durant' && SIC_code='5712'DB:business_master_new
loadtime:0.33936595916748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastabuchie' limit 1
loadtime:0.33944702148438 / seconds
Query Executed:select id FROM `ms` where city='Eastabuchie' && SIC_code='5712'DB:business_master_new
loadtime:0.33993601799011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecru' limit 1
loadtime:0.339998960495 / seconds
Query Executed:select id FROM `ms` where city='Ecru' && SIC_code='5712'DB:business_master_new
loadtime:0.3413348197937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:0.34141302108765 / seconds
Query Executed:select id FROM `ms` where city='Edinburg' && SIC_code='5712'DB:business_master_new
loadtime:0.34183502197266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwards' limit 1
loadtime:0.34189701080322 / seconds
Query Executed:select id FROM `ms` where city='Edwards' && SIC_code='5712'DB:business_master_new
loadtime:0.34338593482971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.34344792366028 / seconds
Query Executed:select id FROM `ms` where city='Elliott' && SIC_code='5712'DB:business_master_new
loadtime:0.34398889541626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellisville' limit 1
loadtime:0.34404993057251 / seconds
Query Executed:select id FROM `ms` where city='Ellisville' && SIC_code='5712'DB:business_master_new
loadtime:0.34879398345947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enid' limit 1
loadtime:0.34887003898621 / seconds
Query Executed:select id FROM `ms` where city='Enid' && SIC_code='5712'DB:business_master_new
loadtime:0.34945893287659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.34952187538147 / seconds
Query Executed:select id FROM `ms` where city='Enterprise' && SIC_code='5712'DB:business_master_new
loadtime:0.35127592086792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escatawpa' limit 1
loadtime:0.35133790969849 / seconds
Query Executed:select id FROM `ms` where city='Escatawpa' && SIC_code='5712'DB:business_master_new
loadtime:0.35230088233948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethel' limit 1
loadtime:0.35237789154053 / seconds
Query Executed:select id FROM `ms` where city='Ethel' && SIC_code='5712'DB:business_master_new
loadtime:0.35307383537292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etta' limit 1
loadtime:0.35315203666687 / seconds
Query Executed:select id FROM `ms` where city='Etta' && SIC_code='5712'DB:business_master_new
loadtime:0.35382103919983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eupora' limit 1
loadtime:0.3538830280304 / seconds
Query Executed:select id FROM `ms` where city='Eupora' && SIC_code='5712'DB:business_master_new
loadtime:0.35771489143372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:0.35780382156372 / seconds
Query Executed:select id FROM `ms` where city='Falcon' && SIC_code='5712'DB:business_master_new
loadtime:0.35822486877441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkner' limit 1
loadtime:0.35828685760498 / seconds
Query Executed:select id FROM `ms` where city='Falkner' && SIC_code='5712'DB:business_master_new
loadtime:0.35910201072693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farrell' limit 1
loadtime:0.35916304588318 / seconds
Query Executed:select id FROM `ms` where city='Farrell' && SIC_code='5712'DB:business_master_new
loadtime:0.35965490341187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.35972785949707 / seconds
Query Executed:select id FROM `ms` where city='Fayette' && SIC_code='5712'DB:business_master_new
loadtime:0.36263990402222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fernwood' limit 1
loadtime:0.36270189285278 / seconds
Query Executed:select id FROM `ms` where city='Fernwood' && SIC_code='5712'DB:business_master_new
loadtime:0.36334085464478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora' limit 1
loadtime:0.36340093612671 / seconds
Query Executed:select id FROM `ms` where city='Flora' && SIC_code='5712'DB:business_master_new
loadtime:0.36641001701355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.36648797988892 / seconds
Query Executed:select id FROM `ms` where city='Florence' && SIC_code='5712'DB:business_master_new
loadtime:0.37246584892273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flowood' limit 1
loadtime:0.37254285812378 / seconds
Query Executed:select id FROM `ms` where city='Flowood' && SIC_code='5712'DB:business_master_new
loadtime:0.38251805305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:0.3826048374176 / seconds
Query Executed:select id FROM `ms` where city='Forest' && SIC_code='5712'DB:business_master_new
loadtime:0.38955998420715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxworth' limit 1
loadtime:0.38966298103333 / seconds
Query Executed:select id FROM `ms` where city='Foxworth' && SIC_code='5712'DB:business_master_new
loadtime:0.39139604568481 / seconds
Query loaded from cache:select * from geodata_geocity where city='French Camp' limit 1
loadtime:0.39147400856018 / seconds
Query Executed:select id FROM `ms` where city='French Camp' && SIC_code='5712'DB:business_master_new
loadtime:0.39210796356201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friars Point' limit 1
loadtime:0.39216899871826 / seconds
Query Executed:select id FROM `ms` where city='Friars Point' && SIC_code='5712'DB:business_master_new
loadtime:0.39298295974731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.39305686950684 / seconds
Query Executed:select id FROM `ms` where city='Fulton' && SIC_code='5712'DB:business_master_new
loadtime:0.39994692802429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallman' limit 1
loadtime:0.4000289440155 / seconds
Query Executed:select id FROM `ms` where city='Gallman' && SIC_code='5712'DB:business_master_new
loadtime:0.40063881874084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gattman' limit 1
loadtime:0.40070295333862 / seconds
Query Executed:select id FROM `ms` where city='Gattman' && SIC_code='5712'DB:business_master_new
loadtime:0.40126800537109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gautier' limit 1
loadtime:0.40132999420166 / seconds
Query Executed:select id FROM `ms` where city='Gautier' && SIC_code='5712'DB:business_master_new
loadtime:0.40856790542603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.40864896774292 / seconds
Query Executed:select id FROM `ms` where city='Georgetown' && SIC_code='5712'DB:business_master_new
loadtime:0.40934085845947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.40940284729004 / seconds
Query Executed:select id FROM `ms` where city='Glen' && SIC_code='5712'DB:business_master_new
loadtime:0.41017985343933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allan' limit 1
loadtime:0.4102418422699 / seconds
Query Executed:select id FROM `ms` where city='Glen Allan' && SIC_code='5712'DB:business_master_new
loadtime:0.41109800338745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendora' limit 1
loadtime:0.4111590385437 / seconds
Query Executed:select id FROM `ms` where city='Glendora' && SIC_code='5712'DB:business_master_new
loadtime:0.41176795959473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloster' limit 1
loadtime:0.41182994842529 / seconds
Query Executed:select id FROM `ms` where city='Gloster' && SIC_code='5712'DB:business_master_new
loadtime:0.41366195678711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden' limit 1
loadtime:0.41374897956848 / seconds
Query Executed:select id FROM `ms` where city='Golden' && SIC_code='5712'DB:business_master_new
loadtime:0.41507983207703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodman' limit 1
loadtime:0.41515803337097 / seconds
Query Executed:select id FROM `ms` where city='Goodman' && SIC_code='5712'DB:business_master_new
loadtime:0.4160840511322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore Springs' limit 1
loadtime:0.41614699363708 / seconds
Query Executed:select id FROM `ms` where city='Gore Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.41684603691101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grace' limit 1
loadtime:0.41690683364868 / seconds
Query Executed:select id FROM `ms` where city='Grace' && SIC_code='5712'DB:business_master_new
loadtime:0.41743302345276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.41749286651611 / seconds
Query Executed:select id FROM `ms` where city='Greenville' && SIC_code='5712'DB:business_master_new
loadtime:0.42520904541016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.42530584335327 / seconds
Query Executed:select id FROM `ms` where city='Greenwood' && SIC_code='5712'DB:business_master_new
loadtime:0.43981695175171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Spgs' limit 1
loadtime:0.43991804122925 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Spgs' && SIC_code='5712'DB:business_master_new
loadtime:0.44037985801697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Springs' limit 1
loadtime:0.44044303894043 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.44107484817505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenada' limit 1
loadtime:0.44113683700562 / seconds
Query Executed:select id FROM `ms` where city='Grenada' && SIC_code='5712'DB:business_master_new
loadtime:0.45387291908264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulfport' limit 1
loadtime:0.45395588874817 / seconds
Query Executed:select id FROM `ms` where city='Gulfport' && SIC_code='5712'DB:business_master_new
loadtime:0.46145296096802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.46158885955811 / seconds
Query Executed:select id FROM `ms` where city='Gunnison' && SIC_code='5712'DB:business_master_new
loadtime:0.46222686767578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guntown' limit 1
loadtime:0.4622950553894 / seconds
Query Executed:select id FROM `ms` where city='Guntown' && SIC_code='5712'DB:business_master_new
loadtime:0.46375298500061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.46382904052734 / seconds
Query Executed:select id FROM `ms` where city='Hamilton' && SIC_code='5712'DB:business_master_new
loadtime:0.46514987945557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harperville' limit 1
loadtime:0.46522498130798 / seconds
Query Executed:select id FROM `ms` where city='Harperville' && SIC_code='5712'DB:business_master_new
loadtime:0.4657928943634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harriston' limit 1
loadtime:0.46585392951965 / seconds
Query Executed:select id FROM `ms` where city='Harriston' && SIC_code='5712'DB:business_master_new
loadtime:0.46624803543091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.46630787849426 / seconds
Query Executed:select id FROM `ms` where city='Harrisville' && SIC_code='5712'DB:business_master_new
loadtime:0.46687293052673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hattiesburg' limit 1
loadtime:0.46693396568298 / seconds
Query Executed:select id FROM `ms` where city='Hattiesburg' && SIC_code='5712'DB:business_master_new
loadtime:0.47428488731384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazlehurst' limit 1
loadtime:0.4744029045105 / seconds
Query Executed:select id FROM `ms` where city='Hazlehurst' && SIC_code='5712'DB:business_master_new
loadtime:0.47976088523865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heidelberg' limit 1
loadtime:0.47984504699707 / seconds
Query Executed:select id FROM `ms` where city='Heidelberg' && SIC_code='5712'DB:business_master_new
loadtime:0.48231983184814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermanville' limit 1
loadtime:0.48238396644592 / seconds
Query Executed:select id FROM `ms` where city='Hermanville' && SIC_code='5712'DB:business_master_new
loadtime:0.48321795463562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernando' limit 1
loadtime:0.48327898979187 / seconds
Query Executed:select id FROM `ms` where city='Hernando' && SIC_code='5712'DB:business_master_new
loadtime:0.49180293083191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:0.49187994003296 / seconds
Query Executed:select id FROM `ms` where city='Hickory' && SIC_code='5712'DB:business_master_new
loadtime:0.49274897575378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Flat' limit 1
loadtime:0.49282693862915 / seconds
Query Executed:select id FROM `ms` where city='Hickory Flat' && SIC_code='5712'DB:business_master_new
loadtime:0.49365282058716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.4937150478363 / seconds
Query Executed:select id FROM `ms` where city='Hillsboro' && SIC_code='5712'DB:business_master_new
loadtime:0.4941828250885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcomb' limit 1
loadtime:0.49424386024475 / seconds
Query Executed:select id FROM `ms` where city='Holcomb' && SIC_code='5712'DB:business_master_new
loadtime:0.49503898620605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollandale' limit 1
loadtime:0.49510097503662 / seconds
Query Executed:select id FROM `ms` where city='Hollandale' && SIC_code='5712'DB:business_master_new
loadtime:0.49790287017822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Bluff' limit 1
loadtime:0.49798083305359 / seconds
Query Executed:select id FROM `ms` where city='Holly Bluff' && SIC_code='5712'DB:business_master_new
loadtime:0.49878883361816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:0.49885082244873 / seconds
Query Executed:select id FROM `ms` where city='Holly Ridge' && SIC_code='5712'DB:business_master_new
loadtime:0.49933099746704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:0.4993908405304 / seconds
Query Executed:select id FROM `ms` where city='Holly Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.50632882118225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horn Lake' limit 1
loadtime:0.50640892982483 / seconds
Query Executed:select id FROM `ms` where city='Horn Lake' && SIC_code='5712'DB:business_master_new
loadtime:0.5123188495636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houlka' limit 1
loadtime:0.51240181922913 / seconds
Query Executed:select id FROM `ms` where city='Houlka' && SIC_code='5712'DB:business_master_new
loadtime:0.51384687423706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houston' limit 1
loadtime:0.51392102241516 / seconds
Query Executed:select id FROM `ms` where city='Houston' && SIC_code='5712'DB:business_master_new
loadtime:0.51986384391785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.51994585990906 / seconds
Query Executed:select id FROM `ms` where city='Hurley' && SIC_code='5712'DB:business_master_new
loadtime:0.52164101600647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.52170491218567 / seconds
Query Executed:select id FROM `ms` where city='Independence' && SIC_code='5712'DB:business_master_new
loadtime:0.5223228931427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:0.52238392829895 / seconds
Query Executed:select id FROM `ms` where city='Indianola' && SIC_code='5712'DB:business_master_new
loadtime:0.52967691421509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inverness' limit 1
loadtime:0.52977204322815 / seconds
Query Executed:select id FROM `ms` where city='Inverness' && SIC_code='5712'DB:business_master_new
loadtime:0.53173184394836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isola' limit 1
loadtime:0.53180885314941 / seconds
Query Executed:select id FROM `ms` where city='Isola' && SIC_code='5712'DB:business_master_new
loadtime:0.5329430103302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Itta Bena' limit 1
loadtime:0.53300499916077 / seconds
Query Executed:select id FROM `ms` where city='Itta Bena' && SIC_code='5712'DB:business_master_new
loadtime:0.53452491760254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iuka' limit 1
loadtime:0.53460788726807 / seconds
Query Executed:select id FROM `ms` where city='Iuka' && SIC_code='5712'DB:business_master_new
loadtime:0.53985691070557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.53993487358093 / seconds
Query Executed:select id FROM `ms` where city='Jackson' && SIC_code='5712'DB:business_master_new
loadtime:0.54759287834167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jayess' limit 1
loadtime:0.54775500297546 / seconds
Query Executed:select id FROM `ms` where city='Jayess' && SIC_code='5712'DB:business_master_new
loadtime:0.54883289337158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonestown' limit 1
loadtime:0.54890084266663 / seconds
Query Executed:select id FROM `ms` where city='Jonestown' && SIC_code='5712'DB:business_master_new
loadtime:0.54965686798096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keesler Afb' limit 1
loadtime:0.54972791671753 / seconds
Query Executed:select id FROM `ms` where city='Keesler Afb' && SIC_code='5712'DB:business_master_new
loadtime:0.55036187171936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmichael' limit 1
loadtime:0.55042290687561 / seconds
Query Executed:select id FROM `ms` where city='Kilmichael' && SIC_code='5712'DB:business_master_new
loadtime:0.5514018535614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiln' limit 1
loadtime:0.55147886276245 / seconds
Query Executed:select id FROM `ms` where city='Kiln' && SIC_code='5712'DB:business_master_new
loadtime:0.55430698394775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kokomo' limit 1
loadtime:0.55436897277832 / seconds
Query Executed:select id FROM `ms` where city='Kokomo' && SIC_code='5712'DB:business_master_new
loadtime:0.5550708770752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kosciusko' limit 1
loadtime:0.55513381958008 / seconds
Query Executed:select id FROM `ms` where city='Kosciusko' && SIC_code='5712'DB:business_master_new
loadtime:0.56293201446533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kossuth' limit 1
loadtime:0.56301784515381 / seconds
Query Executed:select id FROM `ms` where city='Kossuth' && SIC_code='5712'DB:business_master_new
loadtime:0.56345391273499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kreole' limit 1
loadtime:0.56351804733276 / seconds
Query Executed:select id FROM `ms` where city='Kreole' && SIC_code='5712'DB:business_master_new
loadtime:0.56397294998169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:0.56403398513794 / seconds
Query Executed:select id FROM `ms` where city='Lake' && SIC_code='5712'DB:business_master_new
loadtime:0.56515002250671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Cormorant' limit 1
loadtime:0.56521081924438 / seconds
Query Executed:select id FROM `ms` where city='Lake Cormorant' && SIC_code='5712'DB:business_master_new
loadtime:0.56615996360779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeshore' limit 1
loadtime:0.56622004508972 / seconds
Query Executed:select id FROM `ms` where city='Lakeshore' && SIC_code='5712'DB:business_master_new
loadtime:0.56681990623474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.56688094139099 / seconds
Query Executed:select id FROM `ms` where city='Lamar' && SIC_code='5712'DB:business_master_new
loadtime:0.5675368309021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambert' limit 1
loadtime:0.56760382652283 / seconds
Query Executed:select id FROM `ms` where city='Lambert' && SIC_code='5712'DB:business_master_new
loadtime:0.56857395172119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lauderdale' limit 1
loadtime:0.56863498687744 / seconds
Query Executed:select id FROM `ms` where city='Lauderdale' && SIC_code='5712'DB:business_master_new
loadtime:0.56955003738403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:0.56961393356323 / seconds
Query Executed:select id FROM `ms` where city='Laurel' && SIC_code='5712'DB:business_master_new
loadtime:0.57698583602905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:0.57708191871643 / seconds
Query Executed:select id FROM `ms` where city='Lawrence' && SIC_code='5712'DB:business_master_new
loadtime:0.57770895957947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leakesville' limit 1
loadtime:0.57778286933899 / seconds
Query Executed:select id FROM `ms` where city='Leakesville' && SIC_code='5712'DB:business_master_new
loadtime:0.58097004890442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Learned' limit 1
loadtime:0.58104991912842 / seconds
Query Executed:select id FROM `ms` where city='Learned' && SIC_code='5712'DB:business_master_new
loadtime:0.58147382736206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:0.58153605461121 / seconds
Query Executed:select id FROM `ms` where city='Leland' && SIC_code='5712'DB:business_master_new
loadtime:0.5858588218689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lena' limit 1
loadtime:0.58593392372131 / seconds
Query Executed:select id FROM `ms` where city='Lena' && SIC_code='5712'DB:business_master_new
loadtime:0.58684301376343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.58690500259399 / seconds
Query Executed:select id FROM `ms` where city='Lexington' && SIC_code='5712'DB:business_master_new
loadtime:0.59111404418945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.59119200706482 / seconds
Query Executed:select id FROM `ms` where city='Liberty' && SIC_code='5712'DB:business_master_new
loadtime:0.59437084197998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.59444999694824 / seconds
Query Executed:select id FROM `ms` where city='Little Rock' && SIC_code='5712'DB:business_master_new
loadtime:0.59513187408447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:0.59519290924072 / seconds
Query Executed:select id FROM `ms` where city='Long Beach' && SIC_code='5712'DB:business_master_new
loadtime:0.60316300392151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorman' limit 1
loadtime:0.60324597358704 / seconds
Query Executed:select id FROM `ms` where city='Lorman' && SIC_code='5712'DB:business_master_new
loadtime:0.60397887229919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louin' limit 1
loadtime:0.60404300689697 / seconds
Query Executed:select id FROM `ms` where city='Louin' && SIC_code='5712'DB:business_master_new
loadtime:0.60484099388123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louise' limit 1
loadtime:0.60490298271179 / seconds
Query Executed:select id FROM `ms` where city='Louise' && SIC_code='5712'DB:business_master_new
loadtime:0.60575294494629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:0.60581398010254 / seconds
Query Executed:select id FROM `ms` where city='Louisville' && SIC_code='5712'DB:business_master_new
loadtime:0.61356592178345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucedale' limit 1
loadtime:0.61364889144897 / seconds
Query Executed:select id FROM `ms` where city='Lucedale' && SIC_code='5712'DB:business_master_new
loadtime:0.62202596664429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.62211203575134 / seconds
Query Executed:select id FROM `ms` where city='Ludlow' && SIC_code='5712'DB:business_master_new
loadtime:0.62255597114563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lula' limit 1
loadtime:0.62263488769531 / seconds
Query Executed:select id FROM `ms` where city='Lula' && SIC_code='5712'DB:business_master_new
loadtime:0.62335991859436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:0.62342190742493 / seconds
Query Executed:select id FROM `ms` where city='Lumberton' && SIC_code='5712'DB:business_master_new
loadtime:0.62657189369202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyon' limit 1
loadtime:0.62663388252258 / seconds
Query Executed:select id FROM `ms` where city='Lyon' && SIC_code='5712'DB:business_master_new
loadtime:0.62744498252869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maben' limit 1
loadtime:0.62751984596252 / seconds
Query Executed:select id FROM `ms` where city='Maben' && SIC_code='5712'DB:business_master_new
loadtime:0.62875986099243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:0.628821849823 / seconds
Query Executed:select id FROM `ms` where city='Macon' && SIC_code='5712'DB:business_master_new
loadtime:0.63317704200745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madden' limit 1
loadtime:0.63324093818665 / seconds
Query Executed:select id FROM `ms` where city='Madden' && SIC_code='5712'DB:business_master_new
loadtime:0.63379096984863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.63385105133057 / seconds
Query Executed:select id FROM `ms` where city='Madison' && SIC_code='5712'DB:business_master_new
loadtime:0.64550995826721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magee' limit 1
loadtime:0.64559292793274 / seconds
Query Executed:select id FROM `ms` where city='Magee' && SIC_code='5712'DB:business_master_new
loadtime:0.65158581733704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:0.65166902542114 / seconds
Query Executed:select id FROM `ms` where city='Magnolia' && SIC_code='5712'DB:business_master_new
loadtime:0.65541887283325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantachie' limit 1
loadtime:0.65549492835999 / seconds
Query Executed:select id FROM `ms` where city='Mantachie' && SIC_code='5712'DB:business_master_new
loadtime:0.65805697441101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantee' limit 1
loadtime:0.65813493728638 / seconds
Query Executed:select id FROM `ms` where city='Mantee' && SIC_code='5712'DB:business_master_new
loadtime:0.6588339805603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:0.65890789031982 / seconds
Query Executed:select id FROM `ms` where city='Marietta' && SIC_code='5712'DB:business_master_new
loadtime:0.65973091125488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.65979290008545 / seconds
Query Executed:select id FROM `ms` where city='Marion' && SIC_code='5712'DB:business_master_new
loadtime:0.66075992584229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marks' limit 1
loadtime:0.66083598136902 / seconds
Query Executed:select id FROM `ms` where city='Marks' && SIC_code='5712'DB:business_master_new
loadtime:0.66410994529724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathiston' limit 1
loadtime:0.66417288780212 / seconds
Query Executed:select id FROM `ms` where city='Mathiston' && SIC_code='5712'DB:business_master_new
loadtime:0.6652820110321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattson' limit 1
loadtime:0.66534185409546 / seconds
Query Executed:select id FROM `ms` where city='Mattson' && SIC_code='5712'DB:business_master_new
loadtime:0.66583395004272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayersville' limit 1
loadtime:0.66589593887329 / seconds
Query Executed:select id FROM `ms` where city='Mayersville' && SIC_code='5712'DB:business_master_new
loadtime:0.66666793823242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhew' limit 1
loadtime:0.66674184799194 / seconds
Query Executed:select id FROM `ms` where city='Mayhew' && SIC_code='5712'DB:business_master_new
loadtime:0.66726684570312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adams' limit 1
loadtime:0.66734290122986 / seconds
Query Executed:select id FROM `ms` where city='Mc Adams' && SIC_code='5712'DB:business_master_new
loadtime:0.66782593727112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Call Creek' limit 1
loadtime:0.66788792610168 / seconds
Query Executed:select id FROM `ms` where city='Mc Call Creek' && SIC_code='5712'DB:business_master_new
loadtime:0.66852188110352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Carley' limit 1
loadtime:0.66858696937561 / seconds
Query Executed:select id FROM `ms` where city='Mc Carley' && SIC_code='5712'DB:business_master_new
loadtime:0.66905784606934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Comb' limit 1
loadtime:0.66911888122559 / seconds
Query Executed:select id FROM `ms` where city='Mc Comb' && SIC_code='5712'DB:business_master_new
loadtime:0.66979098320007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cool' limit 1
loadtime:0.66985201835632 / seconds
Query Executed:select id FROM `ms` where city='Mc Cool' && SIC_code='5712'DB:business_master_new
loadtime:0.67054390907288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Henry' limit 1
loadtime:0.67060899734497 / seconds
Query Executed:select id FROM `ms` where city='Mc Henry' && SIC_code='5712'DB:business_master_new
loadtime:0.67131400108337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lain' limit 1
loadtime:0.67137503623962 / seconds
Query Executed:select id FROM `ms` where city='Mc Lain' && SIC_code='5712'DB:business_master_new
loadtime:0.67216992378235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neill' limit 1
loadtime:0.67223286628723 / seconds
Query Executed:select id FROM `ms` where city='Mc Neill' && SIC_code='5712'DB:business_master_new
loadtime:0.67288684844971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccomb' limit 1
loadtime:0.67294788360596 / seconds
Query Executed:select id FROM `ms` where city='Mccomb' && SIC_code='5712'DB:business_master_new
loadtime:0.68761491775513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadville' limit 1
loadtime:0.68769884109497 / seconds
Query Executed:select id FROM `ms` where city='Meadville' && SIC_code='5712'DB:business_master_new
loadtime:0.6906909942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendenhall' limit 1
loadtime:0.69078183174133 / seconds
Query Executed:select id FROM `ms` where city='Mendenhall' && SIC_code='5712'DB:business_master_new
loadtime:0.69570803642273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meridian' limit 1
loadtime:0.69578194618225 / seconds
Query Executed:select id FROM `ms` where city='Meridian' && SIC_code='5712'DB:business_master_new
loadtime:0.70346403121948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merigold' limit 1
loadtime:0.70357990264893 / seconds
Query Executed:select id FROM `ms` where city='Merigold' && SIC_code='5712'DB:business_master_new
loadtime:0.70452189445496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metcalfe' limit 1
loadtime:0.70458984375 / seconds
Query Executed:select id FROM `ms` where city='Metcalfe' && SIC_code='5712'DB:business_master_new
loadtime:0.70518589019775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan City' limit 1
loadtime:0.70524597167969 / seconds
Query Executed:select id FROM `ms` where city='Michigan City' && SIC_code='5712'DB:business_master_new
loadtime:0.70577096939087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midnight' limit 1
loadtime:0.7058310508728 / seconds
Query Executed:select id FROM `ms` where city='Midnight' && SIC_code='5712'DB:business_master_new
loadtime:0.70628595352173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Wells' limit 1
loadtime:0.70634603500366 / seconds
Query Executed:select id FROM `ms` where city='Mineral Wells' && SIC_code='5712'DB:business_master_new
loadtime:0.70677804946899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minter City' limit 1
loadtime:0.70683884620667 / seconds
Query Executed:select id FROM `ms` where city='Minter City' && SIC_code='5712'DB:business_master_new
loadtime:0.70745992660522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miss State' limit 1
loadtime:0.70752191543579 / seconds
Query Executed:select id FROM `ms` where city='Miss State' && SIC_code='5712'DB:business_master_new
loadtime:0.70793986320496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mississippi State' limit 1
loadtime:0.70800089836121 / seconds
Query Executed:select id FROM `ms` where city='Mississippi State' && SIC_code='5712'DB:business_master_new
loadtime:0.71055483818054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mize' limit 1
loadtime:0.71062088012695 / seconds
Query Executed:select id FROM `ms` where city='Mize' && SIC_code='5712'DB:business_master_new
loadtime:0.71166896820068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Money' limit 1
loadtime:0.71174192428589 / seconds
Query Executed:select id FROM `ms` where city='Money' && SIC_code='5712'DB:business_master_new
loadtime:0.7121570110321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.71221685409546 / seconds
Query Executed:select id FROM `ms` where city='Monticello' && SIC_code='5712'DB:business_master_new
loadtime:0.71615791320801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.71623396873474 / seconds
Query Executed:select id FROM `ms` where city='Montpelier' && SIC_code='5712'DB:business_master_new
loadtime:0.71669387817383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooreville' limit 1
loadtime:0.71676683425903 / seconds
Query Executed:select id FROM `ms` where city='Mooreville' && SIC_code='5712'DB:business_master_new
loadtime:0.71774697303772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:0.71780705451965 / seconds
Query Executed:select id FROM `ms` where city='Moorhead' && SIC_code='5712'DB:business_master_new
loadtime:0.71885299682617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan City' limit 1
loadtime:0.71891403198242 / seconds
Query Executed:select id FROM `ms` where city='Morgan City' && SIC_code='5712'DB:business_master_new
loadtime:0.71947383880615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morton' limit 1
loadtime:0.71953392028809 / seconds
Query Executed:select id FROM `ms` where city='Morton' && SIC_code='5712'DB:business_master_new
loadtime:0.72325301170349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moselle' limit 1
loadtime:0.72333192825317 / seconds
Query Executed:select id FROM `ms` where city='Moselle' && SIC_code='5712'DB:business_master_new
loadtime:0.72436690330505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss' limit 1
loadtime:0.72442984580994 / seconds
Query Executed:select id FROM `ms` where city='Moss' && SIC_code='5712'DB:business_master_new
loadtime:0.72493004798889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss Point' limit 1
loadtime:0.72499084472656 / seconds
Query Executed:select id FROM `ms` where city='Moss Point' && SIC_code='5712'DB:business_master_new
loadtime:0.73369097709656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound Bayou' limit 1
loadtime:0.73377990722656 / seconds
Query Executed:select id FROM `ms` where city='Mound Bayou' && SIC_code='5712'DB:business_master_new
loadtime:0.73520994186401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:0.73528385162354 / seconds
Query Executed:select id FROM `ms` where city='Mount Olive' && SIC_code='5712'DB:business_master_new
loadtime:0.73696494102478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.73704385757446 / seconds
Query Executed:select id FROM `ms` where city='Mount Pleasant' && SIC_code='5712'DB:business_master_new
loadtime:0.73755383491516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:0.73761892318726 / seconds
Query Executed:select id FROM `ms` where city='Mt Olive' && SIC_code='5712'DB:business_master_new
loadtime:0.73804593086243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.73810696601868 / seconds
Query Executed:select id FROM `ms` where city='Mt Pleasant' && SIC_code='5712'DB:business_master_new
loadtime:0.73851490020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle' limit 1
loadtime:0.73857998847961 / seconds
Query Executed:select id FROM `ms` where city='Myrtle' && SIC_code='5712'DB:business_master_new
loadtime:0.73975586891174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nas Meridian' limit 1
loadtime:0.73983287811279 / seconds
Query Executed:select id FROM `ms` where city='Nas Meridian' && SIC_code='5712'DB:business_master_new
loadtime:0.7402880191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natchez' limit 1
loadtime:0.74035000801086 / seconds
Query Executed:select id FROM `ms` where city='Natchez' && SIC_code='5712'DB:business_master_new
loadtime:0.74779582023621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neely' limit 1
loadtime:0.74788784980774 / seconds
Query Executed:select id FROM `ms` where city='Neely' && SIC_code='5712'DB:business_master_new
loadtime:0.74846291542053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesbit' limit 1
loadtime:0.74852585792542 / seconds
Query Executed:select id FROM `ms` where city='Nesbit' && SIC_code='5712'DB:business_master_new
loadtime:0.75093293190002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nettleton' limit 1
loadtime:0.75101184844971 / seconds
Query Executed:select id FROM `ms` where city='Nettleton' && SIC_code='5712'DB:business_master_new
loadtime:0.75375604629517 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albany' limit 1
loadtime:0.75383305549622 / seconds
Query Executed:select id FROM `ms` where city='New Albany' && SIC_code='5712'DB:business_master_new
loadtime:0.76296997070312 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Augusta' limit 1
loadtime:0.76306796073914 / seconds
Query Executed:select id FROM `ms` where city='New Augusta' && SIC_code='5712'DB:business_master_new
loadtime:0.76446199417114 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Site' limit 1
loadtime:0.76452684402466 / seconds
Query Executed:select id FROM `ms` where city='New Site' && SIC_code='5712'DB:business_master_new
loadtime:0.76517796516418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhebron' limit 1
loadtime:0.76524090766907 / seconds
Query Executed:select id FROM `ms` where city='Newhebron' && SIC_code='5712'DB:business_master_new
loadtime:0.76649403572083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.76657700538635 / seconds
Query Executed:select id FROM `ms` where city='Newton' && SIC_code='5712'DB:business_master_new
loadtime:0.77051496505737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nicholson' limit 1
loadtime:0.77059888839722 / seconds
Query Executed:select id FROM `ms` where city='Nicholson' && SIC_code='5712'DB:business_master_new
loadtime:0.77120995521545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nitta Yuma' limit 1
loadtime:0.77127289772034 / seconds
Query Executed:select id FROM `ms` where city='Nitta Yuma' && SIC_code='5712'DB:business_master_new
loadtime:0.77170896530151 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carrollton' limit 1
loadtime:0.7717809677124 / seconds
Query Executed:select id FROM `ms` where city='North Carrollton' && SIC_code='5712'DB:business_master_new
loadtime:0.77254104614258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Noxapater' limit 1
loadtime:0.77260804176331 / seconds
Query Executed:select id FROM `ms` where city='Noxapater' && SIC_code='5712'DB:business_master_new
loadtime:0.7736828327179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Vale' limit 1
loadtime:0.77375602722168 / seconds
Query Executed:select id FROM `ms` where city='Oak Vale' && SIC_code='5712'DB:business_master_new
loadtime:0.77437090873718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:0.77443099021912 / seconds
Query Executed:select id FROM `ms` where city='Oakland' && SIC_code='5712'DB:business_master_new
loadtime:0.77550888061523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Springs' limit 1
loadtime:0.77557587623596 / seconds
Query Executed:select id FROM `ms` where city='Ocean Springs' && SIC_code='5712'DB:business_master_new
loadtime:0.78989791870117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okolona' limit 1
loadtime:0.78998589515686 / seconds
Query Executed:select id FROM `ms` where city='Okolona' && SIC_code='5712'DB:business_master_new
loadtime:0.79371404647827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olive Branch' limit 1
loadtime:0.79381704330444 / seconds
Query Executed:select id FROM `ms` where city='Olive Branch' && SIC_code='5712'DB:business_master_new
loadtime:0.80132794380188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osyka' limit 1
loadtime:0.80140900611877 / seconds
Query Executed:select id FROM `ms` where city='Osyka' && SIC_code='5712'DB:business_master_new
loadtime:0.80326294898987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovett' limit 1
loadtime:0.80332684516907 / seconds
Query Executed:select id FROM `ms` where city='Ovett' && SIC_code='5712'DB:business_master_new
loadtime:0.80412697792053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.80418682098389 / seconds
Query Executed:select id FROM `ms` where city='Oxford' && SIC_code='5712'DB:business_master_new
loadtime:0.81154894828796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pace' limit 1
loadtime:0.81163883209229 / seconds
Query Executed:select id FROM `ms` where city='Pace' && SIC_code='5712'DB:business_master_new
loadtime:0.81223392486572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pachuta' limit 1
loadtime:0.81229686737061 / seconds
Query Executed:select id FROM `ms` where city='Pachuta' && SIC_code='5712'DB:business_master_new
loadtime:0.81303286552429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panther Burn' limit 1
loadtime:0.81309390068054 / seconds
Query Executed:select id FROM `ms` where city='Panther Burn' && SIC_code='5712'DB:business_master_new
loadtime:0.81352591514587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchman' limit 1
loadtime:0.81359100341797 / seconds
Query Executed:select id FROM `ms` where city='Parchman' && SIC_code='5712'DB:business_master_new
loadtime:0.81405401229858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:0.81411504745483 / seconds
Query Executed:select id FROM `ms` where city='Paris' && SIC_code='5712'DB:business_master_new
loadtime:0.81454205513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pascagoula' limit 1
loadtime:0.81460690498352 / seconds
Query Executed:select id FROM `ms` where city='Pascagoula' && SIC_code='5712'DB:business_master_new
loadtime:0.82978296279907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pass Christian' limit 1
loadtime:0.82986903190613 / seconds
Query Executed:select id FROM `ms` where city='Pass Christian' && SIC_code='5712'DB:business_master_new
loadtime:0.83661198616028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pattison' limit 1
loadtime:0.83667588233948 / seconds
Query Executed:select id FROM `ms` where city='Pattison' && SIC_code='5712'DB:business_master_new
loadtime:0.8373019695282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulding' limit 1
loadtime:0.83736205101013 / seconds
Query Executed:select id FROM `ms` where city='Paulding' && SIC_code='5712'DB:business_master_new
loadtime:0.83787202835083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl' limit 1
loadtime:0.8379328250885 / seconds
Query Executed:select id FROM `ms` where city='Pearl' && SIC_code='5712'DB:business_master_new
loadtime:0.85157585144043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearlington' limit 1
loadtime:0.85167193412781 / seconds
Query Executed:select id FROM `ms` where city='Pearlington' && SIC_code='5712'DB:business_master_new
loadtime:0.85260391235352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelahatchie' limit 1
loadtime:0.85266900062561 / seconds
Query Executed:select id FROM `ms` where city='Pelahatchie' && SIC_code='5712'DB:business_master_new
loadtime:0.85550093650818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinston' limit 1
loadtime:0.85556983947754 / seconds
Query Executed:select id FROM `ms` where city='Perkinston' && SIC_code='5712'DB:business_master_new
loadtime:0.85712099075317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petal' limit 1
loadtime:0.85719895362854 / seconds
Query Executed:select id FROM `ms` where city='Petal' && SIC_code='5712'DB:business_master_new
loadtime:0.8641209602356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pheba' limit 1
loadtime:0.86420202255249 / seconds
Query Executed:select id FROM `ms` where city='Pheba' && SIC_code='5712'DB:business_master_new
loadtime:0.86490082740784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philadelphia' limit 1
loadtime:0.86496305465698 / seconds
Query Executed:select id FROM `ms` where city='Philadelphia' && SIC_code='5712'DB:business_master_new
loadtime:0.8748300075531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philipp' limit 1
loadtime:0.87491393089294 / seconds
Query Executed:select id FROM `ms` where city='Philipp' && SIC_code='5712'DB:business_master_new
loadtime:0.87548184394836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picayune' limit 1
loadtime:0.87555885314941 / seconds
Query Executed:select id FROM `ms` where city='Picayune' && SIC_code='5712'DB:business_master_new
loadtime:0.88809585571289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:0.88819098472595 / seconds
Query Executed:select id FROM `ms` where city='Pickens' && SIC_code='5712'DB:business_master_new
loadtime:0.88938593864441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Woods' limit 1
loadtime:0.88946604728699 / seconds
Query Executed:select id FROM `ms` where city='Piney Woods' && SIC_code='5712'DB:business_master_new
loadtime:0.88992404937744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinola' limit 1
loadtime:0.88998794555664 / seconds
Query Executed:select id FROM `ms` where city='Pinola' && SIC_code='5712'DB:business_master_new
loadtime:0.89070701599121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:0.8907790184021 / seconds
Query Executed:select id FROM `ms` where city='Pittsboro' && SIC_code='5712'DB:business_master_new
loadtime:0.89165186882019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantersville' limit 1
loadtime:0.89171290397644 / seconds
Query Executed:select id FROM `ms` where city='Plantersville' && SIC_code='5712'DB:business_master_new
loadtime:0.89275884628296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:0.89283394813538 / seconds
Query Executed:select id FROM `ms` where city='Pocahontas' && SIC_code='5712'DB:business_master_new
loadtime:0.89322805404663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontotoc' limit 1
loadtime:0.8932900428772 / seconds
Query Executed:select id FROM `ms` where city='Pontotoc' && SIC_code='5712'DB:business_master_new
loadtime:0.90208792686462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope' limit 1
loadtime:0.90218186378479 / seconds
Query Executed:select id FROM `ms` where city='Pope' && SIC_code='5712'DB:business_master_new
loadtime:0.90290594100952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplarville' limit 1
loadtime:0.90297102928162 / seconds
Query Executed:select id FROM `ms` where city='Poplarville' && SIC_code='5712'DB:business_master_new
loadtime:0.90856003761292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Gibson' limit 1
loadtime:0.90866494178772 / seconds
Query Executed:select id FROM `ms` where city='Port Gibson' && SIC_code='5712'DB:business_master_new
loadtime:0.91284894943237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porterville' limit 1
loadtime:0.91291284561157 / seconds
Query Executed:select id FROM `ms` where city='Porterville' && SIC_code='5712'DB:business_master_new
loadtime:0.91345191001892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potts Camp' limit 1
loadtime:0.91351199150085 / seconds
Query Executed:select id FROM `ms` where city='Potts Camp' && SIC_code='5712'DB:business_master_new
loadtime:0.91466689109802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie' limit 1
loadtime:0.91473984718323 / seconds
Query Executed:select id FROM `ms` where city='Prairie' && SIC_code='5712'DB:business_master_new
loadtime:0.91548299789429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prentiss' limit 1
loadtime:0.91554403305054 / seconds
Query Executed:select id FROM `ms` where city='Prentiss' && SIC_code='5712'DB:business_master_new
loadtime:0.91933584213257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.91941285133362 / seconds
Query Executed:select id FROM `ms` where city='Preston' && SIC_code='5712'DB:business_master_new
loadtime:0.92017292976379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puckett' limit 1
loadtime:0.92024898529053 / seconds
Query Executed:select id FROM `ms` where city='Puckett' && SIC_code='5712'DB:business_master_new
loadtime:0.92092299461365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:0.92098498344421 / seconds
Query Executed:select id FROM `ms` where city='Pulaski' && SIC_code='5712'DB:business_master_new
loadtime:0.92155289649963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purvis' limit 1
loadtime:0.92161703109741 / seconds
Query Executed:select id FROM `ms` where city='Purvis' && SIC_code='5712'DB:business_master_new
loadtime:0.92611384391785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quitman' limit 1
loadtime:0.92619395256042 / seconds
Query Executed:select id FROM `ms` where city='Quitman' && SIC_code='5712'DB:business_master_new
loadtime:0.93077492713928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:0.93085384368896 / seconds
Query Executed:select id FROM `ms` where city='Raleigh' && SIC_code='5712'DB:business_master_new
loadtime:0.93363285064697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.93369698524475 / seconds
Query Executed:select id FROM `ms` where city='Randolph' && SIC_code='5712'DB:business_master_new
loadtime:0.93435001373291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.93442583084106 / seconds
Query Executed:select id FROM `ms` where city='Raymond' && SIC_code='5712'DB:business_master_new
loadtime:0.93857598304749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Banks' limit 1
loadtime:0.9386420249939 / seconds
Query Executed:select id FROM `ms` where city='Red Banks' && SIC_code='5712'DB:business_master_new
loadtime:0.93938183784485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:0.93945789337158 / seconds
Query Executed:select id FROM `ms` where city='Redwood' && SIC_code='5712'DB:business_master_new
loadtime:0.94007682800293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rena Lara' limit 1
loadtime:0.94013905525208 / seconds
Query Executed:select id FROM `ms` where city='Rena Lara' && SIC_code='5712'DB:business_master_new
loadtime:0.94070792198181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.9407799243927 / seconds
Query Executed:select id FROM `ms` where city='Richland' && SIC_code='5712'DB:business_master_new
loadtime:0.94635486602783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richton' limit 1
loadtime:0.94643092155457 / seconds
Query Executed:select id FROM `ms` where city='Richton' && SIC_code='5712'DB:business_master_new
loadtime:0.94984483718872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:0.94992303848267 / seconds
Query Executed:select id FROM `ms` where city='Ridgeland' && SIC_code='5712'DB:business_master_new
loadtime:0.95766282081604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rienzi' limit 1
loadtime:0.95776581764221 / seconds
Query Executed:select id FROM `ms` where city='Rienzi' && SIC_code='5712'DB:business_master_new
loadtime:0.95908188819885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripley' limit 1
loadtime:0.95916104316711 / seconds
Query Executed:select id FROM `ms` where city='Ripley' && SIC_code='5712'DB:business_master_new
loadtime:0.96600604057312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robinsonville' limit 1
loadtime:0.96609592437744 / seconds
Query Executed:select id FROM `ms` where city='Robinsonville' && SIC_code='5712'DB:business_master_new
loadtime:0.96847295761108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolling Fork' limit 1
loadtime:0.96853685379028 / seconds
Query Executed:select id FROM `ms` where city='Rolling Fork' && SIC_code='5712'DB:business_master_new
loadtime:0.97173190116882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:0.97180795669556 / seconds
Query Executed:select id FROM `ms` where city='Rome' && SIC_code='5712'DB:business_master_new
loadtime:0.97229599952698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:0.97235703468323 / seconds
Query Executed:select id FROM `ms` where city='Rose Hill' && SIC_code='5712'DB:business_master_new
loadtime:0.97303295135498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:0.97309303283691 / seconds
Query Executed:select id FROM `ms` where city='Rosedale' && SIC_code='5712'DB:business_master_new
loadtime:0.97457003593445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxie' limit 1
loadtime:0.9746458530426 / seconds
Query Executed:select id FROM `ms` where city='Roxie' && SIC_code='5712'DB:business_master_new
loadtime:0.97548890113831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruleville' limit 1
loadtime:0.97555088996887 / seconds
Query Executed:select id FROM `ms` where city='Ruleville' && SIC_code='5712'DB:business_master_new
loadtime:0.97803592681885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:0.9781129360199 / seconds
Query Executed:select id FROM `ms` where city='Ruth' && SIC_code='5712'DB:business_master_new
loadtime:0.97883796691895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sallis' limit 1
loadtime:0.97891592979431 / seconds
Query Executed:select id FROM `ms` where city='Sallis' && SIC_code='5712'DB:business_master_new
loadtime:0.97966194152832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltillo' limit 1
loadtime:0.97973489761353 / seconds
Query Executed:select id FROM `ms` where city='Saltillo' && SIC_code='5712'DB:business_master_new
loadtime:0.98343300819397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanatorium' limit 1
loadtime:0.98350787162781 / seconds
Query Executed:select id FROM `ms` where city='Sanatorium' && SIC_code='5712'DB:business_master_new
loadtime:0.98395395278931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandersville' limit 1
loadtime:0.98401498794556 / seconds
Query Executed:select id FROM `ms` where city='Sandersville' && SIC_code='5712'DB:business_master_new
loadtime:0.98487401008606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandhill' limit 1
loadtime:0.98493504524231 / seconds
Query Executed:select id FROM `ms` where city='Sandhill' && SIC_code='5712'DB:business_master_new
loadtime:0.98540282249451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.98546385765076 / seconds
Query Executed:select id FROM `ms` where city='Sandy Hook' && SIC_code='5712'DB:business_master_new
loadtime:0.98629093170166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanitorium' limit 1
loadtime:0.98635196685791 / seconds
Query Executed:select id FROM `ms` where city='Sanitorium' && SIC_code='5712'DB:business_master_new
loadtime:0.98679184913635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarah' limit 1
loadtime:0.9868528842926 / seconds
Query Executed:select id FROM `ms` where city='Sarah' && SIC_code='5712'DB:business_master_new
loadtime:0.98756694793701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardis' limit 1
loadtime:0.98762798309326 / seconds
Query Executed:select id FROM `ms` where city='Sardis' && SIC_code='5712'DB:business_master_new
loadtime:0.99082088470459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Satartia' limit 1
loadtime:0.99090099334717 / seconds
Query Executed:select id FROM `ms` where city='Satartia' && SIC_code='5712'DB:business_master_new
loadtime:0.99143886566162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saucier' limit 1
loadtime:0.99150204658508 / seconds
Query Executed:select id FROM `ms` where city='Saucier' && SIC_code='5712'DB:business_master_new
loadtime:0.99528694152832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schlater' limit 1
loadtime:0.99536490440369 / seconds
Query Executed:select id FROM `ms` where city='Schlater' && SIC_code='5712'DB:business_master_new
loadtime:0.99608087539673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scobey' limit 1
loadtime:0.99614286422729 / seconds
Query Executed:select id FROM `ms` where city='Scobey' && SIC_code='5712'DB:business_master_new
loadtime:0.99669599533081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scooba' limit 1
loadtime:0.9967679977417 / seconds
Query Executed:select id FROM `ms` where city='Scooba' && SIC_code='5712'DB:business_master_new
loadtime:0.99757504463196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scott' limit 1
loadtime:0.9976499080658 / seconds
Query Executed:select id FROM `ms` where city='Scott' && SIC_code='5712'DB:business_master_new
loadtime:0.99823689460754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebastopol' limit 1
loadtime:0.99829792976379 / seconds
Query Executed:select id FROM `ms` where city='Sebastopol' && SIC_code='5712'DB:business_master_new
loadtime:0.99926805496216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seminary' limit 1
loadtime:0.99934482574463 / seconds
Query Executed:select id FROM `ms` where city='Seminary' && SIC_code='5712'DB:business_master_new
loadtime:1.0017778873444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Senatobia' limit 1
loadtime:1.0018539428711 / seconds
Query Executed:select id FROM `ms` where city='Senatobia' && SIC_code='5712'DB:business_master_new
loadtime:1.0091278553009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:1.0092079639435 / seconds
Query Executed:select id FROM `ms` where city='Shannon' && SIC_code='5712'DB:business_master_new
loadtime:1.0117039680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:1.0117788314819 / seconds
Query Executed:select id FROM `ms` where city='Sharon' && SIC_code='5712'DB:business_master_new
loadtime:1.012228012085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw' limit 1
loadtime:1.0122890472412 / seconds
Query Executed:select id FROM `ms` where city='Shaw' && SIC_code='5712'DB:business_master_new
loadtime:1.0145039558411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:1.014585018158 / seconds
Query Executed:select id FROM `ms` where city='Shelby' && SIC_code='5712'DB:business_master_new
loadtime:1.0166139602661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherard' limit 1
loadtime:1.0166778564453 / seconds
Query Executed:select id FROM `ms` where city='Sherard' && SIC_code='5712'DB:business_master_new
loadtime:1.0171618461609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:1.0172228813171 / seconds
Query Executed:select id FROM `ms` where city='Sherman' && SIC_code='5712'DB:business_master_new
loadtime:1.0180280208588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shubuta' limit 1
loadtime:1.0180900096893 / seconds
Query Executed:select id FROM `ms` where city='Shubuta' && SIC_code='5712'DB:business_master_new
loadtime:1.0199580192566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shuqualak' limit 1
loadtime:1.0200200080872 / seconds
Query Executed:select id FROM `ms` where city='Shuqualak' && SIC_code='5712'DB:business_master_new
loadtime:1.020870923996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:1.0209538936615 / seconds
Query Executed:select id FROM `ms` where city='Sibley' && SIC_code='5712'DB:business_master_new
loadtime:1.0214400291443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidon' limit 1
loadtime:1.021500825882 / seconds
Query Executed:select id FROM `ms` where city='Sidon' && SIC_code='5712'DB:business_master_new
loadtime:1.0221199989319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:1.0221810340881 / seconds
Query Executed:select id FROM `ms` where city='Silver City' && SIC_code='5712'DB:business_master_new
loadtime:1.0227539539337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Creek' limit 1
loadtime:1.02281498909 / seconds
Query Executed:select id FROM `ms` where city='Silver Creek' && SIC_code='5712'DB:business_master_new
loadtime:1.0237588882446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slate Spring' limit 1
loadtime:1.023833990097 / seconds
Query Executed:select id FROM `ms` where city='Slate Spring' && SIC_code='5712'DB:business_master_new
loadtime:1.0242779254913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sledge' limit 1
loadtime:1.0243389606476 / seconds
Query Executed:select id FROM `ms` where city='Sledge' && SIC_code='5712'DB:business_master_new
loadtime:1.0251309871674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithdale' limit 1
loadtime:1.0251920223236 / seconds
Query Executed:select id FROM `ms` where city='Smithdale' && SIC_code='5712'DB:business_master_new
loadtime:1.0259499549866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:1.0260109901428 / seconds
Query Executed:select id FROM `ms` where city='Smithville' && SIC_code='5712'DB:business_master_new
loadtime:1.0274038314819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sontag' limit 1
loadtime:1.02747797966 / seconds
Query Executed:select id FROM `ms` where city='Sontag' && SIC_code='5712'DB:business_master_new
loadtime:1.0281028747559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soso' limit 1
loadtime:1.0281648635864 / seconds
Query Executed:select id FROM `ms` where city='Soso' && SIC_code='5712'DB:business_master_new
loadtime:1.0293049812317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southaven' limit 1
loadtime:1.0293798446655 / seconds
Query Executed:select id FROM `ms` where city='Southaven' && SIC_code='5712'DB:business_master_new
loadtime:1.0369310379028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:1.0370299816132 / seconds
Query Executed:select id FROM `ms` where city='Star' && SIC_code='5712'DB:business_master_new
loadtime:1.0376188755035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starkville' limit 1
loadtime:1.0376980304718 / seconds
Query Executed:select id FROM `ms` where city='Starkville' && SIC_code='5712'DB:business_master_new
loadtime:1.0521988868713 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Line' limit 1
loadtime:1.0522949695587 / seconds
Query Executed:select id FROM `ms` where city='State Line' && SIC_code='5712'DB:business_master_new
loadtime:1.053594827652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steens' limit 1
loadtime:1.0536589622498 / seconds
Query Executed:select id FROM `ms` where city='Steens' && SIC_code='5712'DB:business_master_new
loadtime:1.0549879074097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Space Center' limit 1
loadtime:1.0550649166107 / seconds
Query Executed:select id FROM `ms` where city='Stennis Space Center' && SIC_code='5712'DB:business_master_new
loadtime:1.0557260513306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Spc Ctr' limit 1
loadtime:1.0557889938354 / seconds
Query Executed:select id FROM `ms` where city='Stennis Spc Ctr' && SIC_code='5712'DB:business_master_new
loadtime:1.0562369823456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewart' limit 1
loadtime:1.0562968254089 / seconds
Query Executed:select id FROM `ms` where city='Stewart' && SIC_code='5712'DB:business_master_new
loadtime:1.0568590164185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:1.0569200515747 / seconds
Query Executed:select id FROM `ms` where city='Stoneville' && SIC_code='5712'DB:business_master_new
loadtime:1.0576589107513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:1.0577299594879 / seconds
Query Executed:select id FROM `ms` where city='Stonewall' && SIC_code='5712'DB:business_master_new
loadtime:1.058513879776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stringer' limit 1
loadtime:1.0585799217224 / seconds
Query Executed:select id FROM `ms` where city='Stringer' && SIC_code='5712'DB:business_master_new
loadtime:1.0593869686127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:1.0594470500946 / seconds
Query Executed:select id FROM `ms` where city='Sturgis' && SIC_code='5712'DB:business_master_new
loadtime:1.0604300498962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:1.0604920387268 / seconds
Query Executed:select id FROM `ms` where city='Summit' && SIC_code='5712'DB:business_master_new
loadtime:1.0646569728851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:1.0647459030151 / seconds
Query Executed:select id FROM `ms` where city='Sumner' && SIC_code='5712'DB:business_master_new
loadtime:1.0664570331573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumrall' limit 1
loadtime:1.0665218830109 / seconds
Query Executed:select id FROM `ms` where city='Sumrall' && SIC_code='5712'DB:business_master_new
loadtime:1.069454908371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunflower' limit 1
loadtime:1.0695178508759 / seconds
Query Executed:select id FROM `ms` where city='Sunflower' && SIC_code='5712'DB:business_master_new
loadtime:1.0705690383911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan Lake' limit 1
loadtime:1.070631980896 / seconds
Query Executed:select id FROM `ms` where city='Swan Lake' && SIC_code='5712'DB:business_master_new
loadtime:1.0710618495941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swiftown' limit 1
loadtime:1.0711228847504 / seconds
Query Executed:select id FROM `ms` where city='Swiftown' && SIC_code='5712'DB:business_master_new
loadtime:1.0715489387512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:1.0716149806976 / seconds
Query Executed:select id FROM `ms` where city='Taylor' && SIC_code='5712'DB:business_master_new
loadtime:1.0721719264984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:1.0722320079803 / seconds
Query Executed:select id FROM `ms` where city='Taylorsville' && SIC_code='5712'DB:business_master_new
loadtime:1.0749909877777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tchula' limit 1
loadtime:1.0750699043274 / seconds
Query Executed:select id FROM `ms` where city='Tchula' && SIC_code='5712'DB:business_master_new
loadtime:1.0763728618622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terry' limit 1
loadtime:1.0764348506927 / seconds
Query Executed:select id FROM `ms` where city='Terry' && SIC_code='5712'DB:business_master_new
loadtime:1.0797970294952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:1.0798599720001 / seconds
Query Executed:select id FROM `ms` where city='Thaxton' && SIC_code='5712'DB:business_master_new
loadtime:1.0804908275604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomastown' limit 1
loadtime:1.0805540084839 / seconds
Query Executed:select id FROM `ms` where city='Thomastown' && SIC_code='5712'DB:business_master_new
loadtime:1.0810258388519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tie Plant' limit 1
loadtime:1.0810878276825 / seconds
Query Executed:select id FROM `ms` where city='Tie Plant' && SIC_code='5712'DB:business_master_new
loadtime:1.0815138816833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillatoba' limit 1
loadtime:1.0815808773041 / seconds
Query Executed:select id FROM `ms` where city='Tillatoba' && SIC_code='5712'DB:business_master_new
loadtime:1.0821549892426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinsley' limit 1
loadtime:1.0822160243988 / seconds
Query Executed:select id FROM `ms` where city='Tinsley' && SIC_code='5712'DB:business_master_new
loadtime:1.0826978683472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiplersville' limit 1
loadtime:1.0827698707581 / seconds
Query Executed:select id FROM `ms` where city='Tiplersville' && SIC_code='5712'DB:business_master_new
loadtime:1.0833129882812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tippo' limit 1
loadtime:1.0833749771118 / seconds
Query Executed:select id FROM `ms` where city='Tippo' && SIC_code='5712'DB:business_master_new
loadtime:1.0838990211487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tishomingo' limit 1
loadtime:1.0839610099792 / seconds
Query Executed:select id FROM `ms` where city='Tishomingo' && SIC_code='5712'DB:business_master_new
loadtime:1.085942029953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toccopola' limit 1
loadtime:1.0860178470612 / seconds
Query Executed:select id FROM `ms` where city='Toccopola' && SIC_code='5712'DB:business_master_new
loadtime:1.0864799022675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toomsuba' limit 1
loadtime:1.086541891098 / seconds
Query Executed:select id FROM `ms` where city='Toomsuba' && SIC_code='5712'DB:business_master_new
loadtime:1.0881478786469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tougaloo' limit 1
loadtime:1.0882258415222 / seconds
Query Executed:select id FROM `ms` where city='Tougaloo' && SIC_code='5712'DB:business_master_new
loadtime:1.0888798236847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trebloc' limit 1
loadtime:1.0889420509338 / seconds
Query Executed:select id FROM `ms` where city='Trebloc' && SIC_code='5712'DB:business_master_new
loadtime:1.0893709659576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremont' limit 1
loadtime:1.0894320011139 / seconds
Query Executed:select id FROM `ms` where city='Tremont' && SIC_code='5712'DB:business_master_new
loadtime:1.0901958942413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tula' limit 1
loadtime:1.0902709960938 / seconds
Query Executed:select id FROM `ms` where city='Tula' && SIC_code='5712'DB:business_master_new
loadtime:1.0907108783722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunica' limit 1
loadtime:1.0907828807831 / seconds
Query Executed:select id FROM `ms` where city='Tunica' && SIC_code='5712'DB:business_master_new
loadtime:1.0957870483398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tupelo' limit 1
loadtime:1.0958678722382 / seconds
Query Executed:select id FROM `ms` where city='Tupelo' && SIC_code='5712'DB:business_master_new
loadtime:1.1034409999847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tutwiler' limit 1
loadtime:1.103572845459 / seconds
Query Executed:select id FROM `ms` where city='Tutwiler' && SIC_code='5712'DB:business_master_new
loadtime:1.1045248508453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tylertown' limit 1
loadtime:1.1045968532562 / seconds
Query Executed:select id FROM `ms` where city='Tylertown' && SIC_code='5712'DB:business_master_new
loadtime:1.1102018356323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:1.1102809906006 / seconds
Query Executed:select id FROM `ms` where city='Union' && SIC_code='5712'DB:business_master_new
loadtime:1.1132009029388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Church' limit 1
loadtime:1.1132788658142 / seconds
Query Executed:select id FROM `ms` where city='Union Church' && SIC_code='5712'DB:business_master_new
loadtime:1.1138670444489 / seconds
Query loaded from cache:select * from geodata_geocity where city='University' limit 1
loadtime:1.1139290332794 / seconds
Query Executed:select id FROM `ms` where city='University' && SIC_code='5712'DB:business_master_new
loadtime:1.1149559020996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:1.1150169372559 / seconds
Query Executed:select id FROM `ms` where city='Utica' && SIC_code='5712'DB:business_master_new
loadtime:1.1167559623718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaiden' limit 1
loadtime:1.1168298721313 / seconds
Query Executed:select id FROM `ms` where city='Vaiden' && SIC_code='5712'DB:business_master_new
loadtime:1.1182079315186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Park' limit 1
loadtime:1.1182849407196 / seconds
Query Executed:select id FROM `ms` where city='Valley Park' && SIC_code='5712'DB:business_master_new
loadtime:1.1188189983368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Vleet' limit 1
loadtime:1.1188809871674 / seconds
Query Executed:select id FROM `ms` where city='Van Vleet' && SIC_code='5712'DB:business_master_new
loadtime:1.1193809509277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:1.1194410324097 / seconds
Query Executed:select id FROM `ms` where city='Vance' && SIC_code='5712'DB:business_master_new
loadtime:1.1199610233307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vancleave' limit 1
loadtime:1.1200218200684 / seconds
Query Executed:select id FROM `ms` where city='Vancleave' && SIC_code='5712'DB:business_master_new
loadtime:1.1240458488464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vardaman' limit 1
loadtime:1.124125957489 / seconds
Query Executed:select id FROM `ms` where city='Vardaman' && SIC_code='5712'DB:business_master_new
loadtime:1.125540971756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:1.1256198883057 / seconds
Query Executed:select id FROM `ms` where city='Vaughan' && SIC_code='5712'DB:business_master_new
loadtime:1.1262629032135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:1.1263229846954 / seconds
Query Executed:select id FROM `ms` where city='Verona' && SIC_code='5712'DB:business_master_new
loadtime:1.1282298564911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:1.1283078193665 / seconds
Query Executed:select id FROM `ms` where city='Vicksburg' && SIC_code='5712'DB:business_master_new
loadtime:1.1357588768005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:1.1358489990234 / seconds
Query Executed:select id FROM `ms` where city='Victoria' && SIC_code='5712'DB:business_master_new
loadtime:1.1364629268646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vossburg' limit 1
loadtime:1.1365268230438 / seconds
Query Executed:select id FROM `ms` where city='Vossburg' && SIC_code='5712'DB:business_master_new
loadtime:1.1371350288391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walls' limit 1
loadtime:1.1371958255768 / seconds
Query Executed:select id FROM `ms` where city='Walls' && SIC_code='5712'DB:business_master_new
loadtime:1.1394758224487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:1.1395380496979 / seconds
Query Executed:select id FROM `ms` where city='Walnut' && SIC_code='5712'DB:business_master_new
loadtime:1.1419148445129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Grove' limit 1
loadtime:1.141991853714 / seconds
Query Executed:select id FROM `ms` where city='Walnut Grove' && SIC_code='5712'DB:business_master_new
loadtime:1.1430938243866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walthall' limit 1
loadtime:1.1431698799133 / seconds
Query Executed:select id FROM `ms` where city='Walthall' && SIC_code='5712'DB:business_master_new
loadtime:1.1437668800354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.143828868866 / seconds
Query Executed:select id FROM `ms` where city='Washington' && SIC_code='5712'DB:business_master_new
loadtime:1.1445000171661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water Valley' limit 1
loadtime:1.144565820694 / seconds
Query Executed:select id FROM `ms` where city='Water Valley' && SIC_code='5712'DB:business_master_new
loadtime:1.1488139629364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:1.1488900184631 / seconds
Query Executed:select id FROM `ms` where city='Waterford' && SIC_code='5712'DB:business_master_new
loadtime:1.1495769023895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waveland' limit 1
loadtime:1.1496448516846 / seconds
Query Executed:select id FROM `ms` where city='Waveland' && SIC_code='5712'DB:business_master_new
loadtime:1.1542799472809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:1.1543629169464 / seconds
Query Executed:select id FROM `ms` where city='Waynesboro' && SIC_code='5712'DB:business_master_new
loadtime:1.1621880531311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayside' limit 1
loadtime:1.1622729301453 / seconds
Query Executed:select id FROM `ms` where city='Wayside' && SIC_code='5712'DB:business_master_new
loadtime:1.1627559661865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:1.1628179550171 / seconds
Query Executed:select id FROM `ms` where city='Webb' && SIC_code='5712'DB:business_master_new
loadtime:1.1636168956757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weir' limit 1
loadtime:1.1636788845062 / seconds
Query Executed:select id FROM `ms` where city='Weir' && SIC_code='5712'DB:business_master_new
loadtime:1.1644208431244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesson' limit 1
loadtime:1.1644809246063 / seconds
Query Executed:select id FROM `ms` where city='Wesson' && SIC_code='5712'DB:business_master_new
loadtime:1.1668839454651 / seconds
Query loaded from cache:select * from geodata_geocity where city='West' limit 1
loadtime:1.1669628620148 / seconds
Query Executed:select id FROM `ms` where city='West' && SIC_code='5712'DB:business_master_new
loadtime:1.1677048206329 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:1.1677768230438 / seconds
Query Executed:select id FROM `ms` where city='West Point' && SIC_code='5712'DB:business_master_new
loadtime:1.1771569252014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:1.1772499084473 / seconds
Query Executed:select id FROM `ms` where city='Wheeler' && SIC_code='5712'DB:business_master_new
loadtime:1.1777739524841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitfield' limit 1
loadtime:1.1778500080109 / seconds
Query Executed:select id FROM `ms` where city='Whitfield' && SIC_code='5712'DB:business_master_new
loadtime:1.1783249378204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiggins' limit 1
loadtime:1.1783950328827 / seconds
Query Executed:select id FROM `ms` where city='Wiggins' && SIC_code='5712'DB:business_master_new
loadtime:1.1842739582062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winona' limit 1
loadtime:1.1843559741974 / seconds
Query Executed:select id FROM `ms` where city='Winona' && SIC_code='5712'DB:business_master_new
loadtime:1.189208984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winstonville' limit 1
loadtime:1.1892910003662 / seconds
Query Executed:select id FROM `ms` where city='Winstonville' && SIC_code='5712'DB:business_master_new
loadtime:1.1897649765015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:1.1898279190063 / seconds
Query Executed:select id FROM `ms` where city='Winterville' && SIC_code='5712'DB:business_master_new
loadtime:1.1902780532837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:1.1903388500214 / seconds
Query Executed:select id FROM `ms` where city='Woodland' && SIC_code='5712'DB:business_master_new
loadtime:1.1911950111389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:1.1912560462952 / seconds
Query Executed:select id FROM `ms` where city='Woodville' && SIC_code='5712'DB:business_master_new
loadtime:1.1947929859161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yazoo City' limit 1
loadtime:1.1948709487915 / seconds
Query Executed:select id FROM `ms` where city='Yazoo City' && SIC_code='5712'DB:business_master_new
loadtime:1.2037580013275 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.2039308547974 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.2043569087982 / seconds
Operation template executed (chunk cache operation)
loadtime:1.2045209407806 / seconds
template override:Default
loadtime:1.2045660018921 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.2057640552521 / seconds
Template Constructed, Array Rows:49
loadtime:1.2062859535217 / seconds
TOTAL EXECUTION TIME: 1.20586
loadtime:1.2081508636475 / 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] => furniture-stores [stateURLid] => mississippi )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.2081618309021
TOTAL KEY ARRAYS: 69