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.0017540454864502 / seconds
host not found setting manual db connection
loadtime:0.0094640254974365 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0096900463104248 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.009821891784668 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.009876012802124 / seconds
zipcode:
loadtime:0.0099029541015625 / seconds
Query Executed:select * from search_referrer where page_hash='3f31fba0c1334a35826a60a89fe64e8b' limit 10 DB:ezrox_toadli
loadtime:0.010117053985596 / seconds
Operation header executed (non global)
loadtime:0.010156869888306 / seconds
Operation leaderboard executed (non global)
loadtime:0.010206937789917 / seconds
Operation square executed (non global)
loadtime:0.010236024856567 / seconds
Operation square_bottom executed (non global)
loadtime:0.010263919830322 / seconds
Operation smallsquare executed (non global)
loadtime:0.010288953781128 / seconds
Operation headeradright executed (non global)
loadtime:0.010313987731934 / seconds
Operation google_analytics executed (non global)
loadtime:0.010339021682739 / seconds
Operation topstories executed (non global)
loadtime:0.010364055633545 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010390043258667 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010414838790894 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010678052902222 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010863065719604 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01090407371521 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.010972023010254 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011023044586182 / seconds
Template key: archive_menu pushed
loadtime:0.011031866073608 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011044979095459 / seconds
Template key: get_gravatar pushed
loadtime:0.011051893234253 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011060953140259 / seconds
*10)-10)+1 | start:0
loadtime:0.011101007461548 / seconds
Query loaded from cache:select * from categories where cat_URLid='real-estate-agents-and-managers'
loadtime:0.011157989501953 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.011198043823242 / seconds
DB connected to localhost business_master_new
loadtime:0.011435985565186 / seconds
Query Executed:select * from `ms_catmap` where sic='6531' order by city ascDB:business_master_new
loadtime:0.020407915115356 / seconds
Query stored in cache : _QUERY_www.toadli.com5dbc31a43dd60422d88477c1e9aa76a4
loadtime:0.022247076034546 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.022305965423584 / seconds
Query Executed:select sum(totalcount) as totalsum from `ms_catmap` where sic='6531'DB:business_master_new
loadtime:0.024783849716187 / seconds
Query stored in cache : _QUERY_www.toadli.com42ff8ffe0096fd2a19c06860dcbc58a4
loadtime:0.024826049804688 / seconds
463 / 11
loadtime:0.024883985519409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbeville' limit 1
loadtime:0.024949073791504 / seconds
Query Executed:select id FROM `ms` where city='Abbeville' && SIC_code='6531'DB:business_master_new
loadtime:0.025593996047974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.025655031204224 / seconds
Query Executed:select id FROM `ms` where city='Aberdeen' && SIC_code='6531'DB:business_master_new
loadtime:0.04702091217041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ackerman' limit 1
loadtime:0.047111034393311 / seconds
Query Executed:select id FROM `ms` where city='Ackerman' && SIC_code='6531'DB:business_master_new
loadtime:0.067154884338379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agricola' limit 1
loadtime:0.067234992980957 / seconds
Query Executed:select id FROM `ms` where city='Agricola' && SIC_code='6531'DB:business_master_new
loadtime:0.067623853683472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcorn State' limit 1
loadtime:0.067685842514038 / seconds
Query Executed:select id FROM `ms` where city='Alcorn State' && SIC_code='6531'DB:business_master_new
loadtime:0.068078994750977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Algoma' limit 1
loadtime:0.068150997161865 / seconds
Query Executed:select id FROM `ms` where city='Algoma' && SIC_code='6531'DB:business_master_new
loadtime:0.068583011627197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alligator' limit 1
loadtime:0.068642854690552 / seconds
Query Executed:select id FROM `ms` where city='Alligator' && SIC_code='6531'DB:business_master_new
loadtime:0.069252967834473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amory' limit 1
loadtime:0.069313049316406 / seconds
Query Executed:select id FROM `ms` where city='Amory' && SIC_code='6531'DB:business_master_new
loadtime:0.076952934265137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anguilla' limit 1
loadtime:0.077044010162354 / seconds
Query Executed:select id FROM `ms` where city='Anguilla' && SIC_code='6531'DB:business_master_new
loadtime:0.077812910079956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.077874898910522 / seconds
Query Executed:select id FROM `ms` where city='Arcola' && SIC_code='6531'DB:business_master_new
loadtime:0.07853102684021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arkabutla' limit 1
loadtime:0.078590869903564 / seconds
Query Executed:select id FROM `ms` where city='Arkabutla' && SIC_code='6531'DB:business_master_new
loadtime:0.079035997390747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.079097986221313 / seconds
Query Executed:select id FROM `ms` where city='Artesia' && SIC_code='6531'DB:business_master_new
loadtime:0.079664945602417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.079725027084351 / seconds
Query Executed:select id FROM `ms` where city='Ashland' && SIC_code='6531'DB:business_master_new
loadtime:0.081634998321533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.081712961196899 / seconds
Query Executed:select id FROM `ms` where city='Avalon' && SIC_code='6531'DB:business_master_new
loadtime:0.082085847854614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.082159042358398 / seconds
Query Executed:select id FROM `ms` where city='Avon' && SIC_code='6531'DB:business_master_new
loadtime:0.08265495300293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.08271598815918 / seconds
Query Executed:select id FROM `ms` where city='Bailey' && SIC_code='6531'DB:business_master_new
loadtime:0.083448886871338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwyn' limit 1
loadtime:0.083509922027588 / seconds
Query Executed:select id FROM `ms` where city='Baldwyn' && SIC_code='6531'DB:business_master_new
loadtime:0.10364294052124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banner' limit 1
loadtime:0.10370492935181 / seconds
Query Executed:select id FROM `ms` where city='Banner' && SIC_code='6531'DB:business_master_new
loadtime:0.10416984558105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bassfield' limit 1
loadtime:0.1042308807373 / seconds
Query Executed:select id FROM `ms` where city='Bassfield' && SIC_code='6531'DB:business_master_new
loadtime:0.1055109500885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.10557198524475 / seconds
Query Executed:select id FROM `ms` where city='Batesville' && SIC_code='6531'DB:business_master_new
loadtime:0.11623096466064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Saint Louis' limit 1
loadtime:0.11632394790649 / seconds
Query Executed:select id FROM `ms` where city='Bay Saint Louis' && SIC_code='6531'DB:business_master_new
loadtime:0.12824106216431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Springs' limit 1
loadtime:0.12836885452271 / seconds
Query Executed:select id FROM `ms` where city='Bay Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.14894104003906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay St Louis' limit 1
loadtime:0.14902901649475 / seconds
Query Executed:select id FROM `ms` where city='Bay St Louis' && SIC_code='6531'DB:business_master_new
loadtime:0.14997792243958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.15005803108215 / seconds
Query Executed:select id FROM `ms` where city='Beaumont' && SIC_code='6531'DB:business_master_new
loadtime:0.15099191665649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becker' limit 1
loadtime:0.15105390548706 / seconds
Query Executed:select id FROM `ms` where city='Becker' && SIC_code='6531'DB:business_master_new
loadtime:0.15149784088135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belden' limit 1
loadtime:0.1515588760376 / seconds
Query Executed:select id FROM `ms` where city='Belden' && SIC_code='6531'DB:business_master_new
loadtime:0.15287899971008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belen' limit 1
loadtime:0.15295386314392 / seconds
Query Executed:select id FROM `ms` where city='Belen' && SIC_code='6531'DB:business_master_new
loadtime:0.15336489677429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellefontaine' limit 1
loadtime:0.15342593193054 / seconds
Query Executed:select id FROM `ms` where city='Bellefontaine' && SIC_code='6531'DB:business_master_new
loadtime:0.15385699272156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.15391707420349 / seconds
Query Executed:select id FROM `ms` where city='Belmont' && SIC_code='6531'DB:business_master_new
loadtime:0.17395186424255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belzoni' limit 1
loadtime:0.17403292655945 / seconds
Query Executed:select id FROM `ms` where city='Belzoni' && SIC_code='6531'DB:business_master_new
loadtime:0.19417905807495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benoit' limit 1
loadtime:0.19426107406616 / seconds
Query Executed:select id FROM `ms` where city='Benoit' && SIC_code='6531'DB:business_master_new
loadtime:0.19507789611816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.19516587257385 / seconds
Query Executed:select id FROM `ms` where city='Benton' && SIC_code='6531'DB:business_master_new
loadtime:0.19616603851318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bentonia' limit 1
loadtime:0.19622802734375 / seconds
Query Executed:select id FROM `ms` where city='Bentonia' && SIC_code='6531'DB:business_master_new
loadtime:0.19741487503052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.19747591018677 / seconds
Query Executed:select id FROM `ms` where city='Beulah' && SIC_code='6531'DB:business_master_new
loadtime:0.19795083999634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Creek' limit 1
loadtime:0.19801592826843 / seconds
Query Executed:select id FROM `ms` where city='Big Creek' && SIC_code='6531'DB:business_master_new
loadtime:0.19853687286377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biloxi' limit 1
loadtime:0.1985969543457 / seconds
Query Executed:select id FROM `ms` where city='Biloxi' && SIC_code='6531'DB:business_master_new
loadtime:0.22925186157227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Mountain' limit 1
loadtime:0.22947287559509 / seconds
Query Executed:select id FROM `ms` where city='Blue Mountain' && SIC_code='6531'DB:business_master_new
loadtime:0.23060989379883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Springs' limit 1
loadtime:0.23069596290588 / seconds
Query Executed:select id FROM `ms` where city='Blue Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.23157286643982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bogue Chitto' limit 1
loadtime:0.23163390159607 / seconds
Query Executed:select id FROM `ms` where city='Bogue Chitto' && SIC_code='6531'DB:business_master_new
loadtime:0.2328929901123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.23297786712646 / seconds
Query Executed:select id FROM `ms` where city='Bolton' && SIC_code='6531'DB:business_master_new
loadtime:0.23441696166992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booneville' limit 1
loadtime:0.23449397087097 / seconds
Query Executed:select id FROM `ms` where city='Booneville' && SIC_code='6531'DB:business_master_new
loadtime:0.24400687217712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boyle' limit 1
loadtime:0.24409699440002 / seconds
Query Executed:select id FROM `ms` where city='Boyle' && SIC_code='6531'DB:business_master_new
loadtime:0.24524402618408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.24530696868896 / seconds
Query Executed:select id FROM `ms` where city='Brandon' && SIC_code='6531'DB:business_master_new
loadtime:0.26860594749451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braxton' limit 1
loadtime:0.26879286766052 / seconds
Query Executed:select id FROM `ms` where city='Braxton' && SIC_code='6531'DB:business_master_new
loadtime:0.2695369720459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookhaven' limit 1
loadtime:0.26961994171143 / seconds
Query Executed:select id FROM `ms` where city='Brookhaven' && SIC_code='6531'DB:business_master_new
loadtime:0.28359889984131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.28370904922485 / seconds
Query Executed:select id FROM `ms` where city='Brooklyn' && SIC_code='6531'DB:business_master_new
loadtime:0.28459787368774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooksville' limit 1
loadtime:0.28466296195984 / seconds
Query Executed:select id FROM `ms` where city='Brooksville' && SIC_code='6531'DB:business_master_new
loadtime:0.2858419418335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.28590297698975 / seconds
Query Executed:select id FROM `ms` where city='Bruce' && SIC_code='6531'DB:business_master_new
loadtime:0.288419008255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckatunna' limit 1
loadtime:0.28848099708557 / seconds
Query Executed:select id FROM `ms` where city='Buckatunna' && SIC_code='6531'DB:business_master_new
loadtime:0.28936886787415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bude' limit 1
loadtime:0.28942894935608 / seconds
Query Executed:select id FROM `ms` where city='Bude' && SIC_code='6531'DB:business_master_new
loadtime:0.29053688049316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.2906129360199 / seconds
Query Executed:select id FROM `ms` where city='Burnsville' && SIC_code='6531'DB:business_master_new
loadtime:0.29175305366516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byhalia' limit 1
loadtime:0.291827917099 / seconds
Query Executed:select id FROM `ms` where city='Byhalia' && SIC_code='6531'DB:business_master_new
loadtime:0.31278085708618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byram' limit 1
loadtime:0.31284594535828 / seconds
Query Executed:select id FROM `ms` where city='Byram' && SIC_code='6531'DB:business_master_new
loadtime:0.3195948600769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.3196918964386 / seconds
Query Executed:select id FROM `ms` where city='Caledonia' && SIC_code='6531'DB:business_master_new
loadtime:0.32106494903564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhoun City' limit 1
loadtime:0.32115602493286 / seconds
Query Executed:select id FROM `ms` where city='Calhoun City' && SIC_code='6531'DB:business_master_new
loadtime:0.34122705459595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.34130787849426 / seconds
Query Executed:select id FROM `ms` where city='Camden' && SIC_code='6531'DB:business_master_new
loadtime:0.34190106391907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.34196400642395 / seconds
Query Executed:select id FROM `ms` where city='Canton' && SIC_code='6531'DB:business_master_new
loadtime:0.35164499282837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carriere' limit 1
loadtime:0.35173797607422 / seconds
Query Executed:select id FROM `ms` where city='Carriere' && SIC_code='6531'DB:business_master_new
loadtime:0.3718409538269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.37192487716675 / seconds
Query Executed:select id FROM `ms` where city='Carrollton' && SIC_code='6531'DB:business_master_new
loadtime:0.37318587303162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.37324905395508 / seconds
Query Executed:select id FROM `ms` where city='Carson' && SIC_code='6531'DB:business_master_new
loadtime:0.37388801574707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.37394785881042 / seconds
Query Executed:select id FROM `ms` where city='Carthage' && SIC_code='6531'DB:business_master_new
loadtime:0.38108205795288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:0.38117504119873 / seconds
Query Executed:select id FROM `ms` where city='Cary' && SIC_code='6531'DB:business_master_new
loadtime:0.38183903694153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascilla' limit 1
loadtime:0.38190197944641 / seconds
Query Executed:select id FROM `ms` where city='Cascilla' && SIC_code='6531'DB:business_master_new
loadtime:0.38243103027344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarbluff' limit 1
loadtime:0.38249206542969 / seconds
Query Executed:select id FROM `ms` where city='Cedarbluff' && SIC_code='6531'DB:business_master_new
loadtime:0.38305902481079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.38311886787415 / seconds
Query Executed:select id FROM `ms` where city='Centreville' && SIC_code='6531'DB:business_master_new
loadtime:0.38488292694092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.38495993614197 / seconds
Query Executed:select id FROM `ms` where city='Charleston' && SIC_code='6531'DB:business_master_new
loadtime:0.40520286560059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatawa' limit 1
loadtime:0.40527987480164 / seconds
Query Executed:select id FROM `ms` where city='Chatawa' && SIC_code='6531'DB:business_master_new
loadtime:0.40571188926697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.40577387809753 / seconds
Query Executed:select id FROM `ms` where city='Chatham' && SIC_code='6531'DB:business_master_new
loadtime:0.40624785423279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Choctaw' limit 1
loadtime:0.40630793571472 / seconds
Query Executed:select id FROM `ms` where city='Choctaw' && SIC_code='6531'DB:business_master_new
loadtime:0.40668797492981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chunky' limit 1
loadtime:0.40674686431885 / seconds
Query Executed:select id FROM `ms` where city='Chunky' && SIC_code='6531'DB:business_master_new
loadtime:0.40734601020813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clara' limit 1
loadtime:0.40742087364197 / seconds
Query Executed:select id FROM `ms` where city='Clara' && SIC_code='6531'DB:business_master_new
loadtime:0.40791893005371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksdale' limit 1
loadtime:0.40798592567444 / seconds
Query Executed:select id FROM `ms` where city='Clarksdale' && SIC_code='6531'DB:business_master_new
loadtime:0.42120289802551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.42129802703857 / seconds
Query Executed:select id FROM `ms` where city='Cleveland' && SIC_code='6531'DB:business_master_new
loadtime:0.43338084220886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.43347907066345 / seconds
Query Executed:select id FROM `ms` where city='Clinton' && SIC_code='6531'DB:business_master_new
loadtime:0.44533705711365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coahoma' limit 1
loadtime:0.44545984268188 / seconds
Query Executed:select id FROM `ms` where city='Coahoma' && SIC_code='6531'DB:business_master_new
loadtime:0.44604802131653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coffeeville' limit 1
loadtime:0.44611406326294 / seconds
Query Executed:select id FROM `ms` where city='Coffeeville' && SIC_code='6531'DB:business_master_new
loadtime:0.44793200492859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coila' limit 1
loadtime:0.447998046875 / seconds
Query Executed:select id FROM `ms` where city='Coila' && SIC_code='6531'DB:business_master_new
loadtime:0.44854497909546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.44860601425171 / seconds
Query Executed:select id FROM `ms` where city='Coldwater' && SIC_code='6531'DB:business_master_new
loadtime:0.46927189826965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.46933603286743 / seconds
Query Executed:select id FROM `ms` where city='Collins' && SIC_code='6531'DB:business_master_new
loadtime:0.48963594436646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.4897198677063 / seconds
Query Executed:select id FROM `ms` where city='Collinsville' && SIC_code='6531'DB:business_master_new
loadtime:0.49135589599609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.49141883850098 / seconds
Query Executed:select id FROM `ms` where city='Columbia' && SIC_code='6531'DB:business_master_new
loadtime:0.50168204307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.50177407264709 / seconds
Query Executed:select id FROM `ms` where city='Columbus' && SIC_code='6531'DB:business_master_new
loadtime:0.53007984161377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Afb' limit 1
loadtime:0.53025007247925 / seconds
Query Executed:select id FROM `ms` where city='Columbus Afb' && SIC_code='6531'DB:business_master_new
loadtime:0.53080296516418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.53086996078491 / seconds
Query Executed:select id FROM `ms` where city='Como' && SIC_code='6531'DB:business_master_new
loadtime:0.5323760509491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conehatta' limit 1
loadtime:0.53245091438293 / seconds
Query Executed:select id FROM `ms` where city='Conehatta' && SIC_code='6531'DB:business_master_new
loadtime:0.53307104110718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.5331449508667 / seconds
Query Executed:select id FROM `ms` where city='Corinth' && SIC_code='6531'DB:business_master_new
loadtime:0.55014085769653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.55024385452271 / seconds
Query Executed:select id FROM `ms` where city='Courtland' && SIC_code='6531'DB:business_master_new
loadtime:0.55085802078247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:0.55092191696167 / seconds
Query Executed:select id FROM `ms` where city='Crawford' && SIC_code='6531'DB:business_master_new
loadtime:0.55182886123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crenshaw' limit 1
loadtime:0.55188989639282 / seconds
Query Executed:select id FROM `ms` where city='Crenshaw' && SIC_code='6531'DB:business_master_new
loadtime:0.55270600318909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crosby' limit 1
loadtime:0.55276584625244 / seconds
Query Executed:select id FROM `ms` where city='Crosby' && SIC_code='6531'DB:business_master_new
loadtime:0.55349588394165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowder' limit 1
loadtime:0.5535569190979 / seconds
Query Executed:select id FROM `ms` where city='Crowder' && SIC_code='6531'DB:business_master_new
loadtime:0.55407691001892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cruger' limit 1
loadtime:0.55414795875549 / seconds
Query Executed:select id FROM `ms` where city='Cruger' && SIC_code='6531'DB:business_master_new
loadtime:0.55466890335083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Springs' limit 1
loadtime:0.55474495887756 / seconds
Query Executed:select id FROM `ms` where city='Crystal Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.57564401626587 / seconds
Query loaded from cache:select * from geodata_geocity where city='D Lo' limit 1
loadtime:0.57572984695435 / seconds
Query Executed:select id FROM `ms` where city='D Lo' && SIC_code='6531'DB:business_master_new
loadtime:0.57640385627747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:0.57646703720093 / seconds
Query Executed:select id FROM `ms` where city='Daleville' && SIC_code='6531'DB:business_master_new
loadtime:0.57697892189026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darling' limit 1
loadtime:0.57703995704651 / seconds
Query Executed:select id FROM `ms` where city='Darling' && SIC_code='6531'DB:business_master_new
loadtime:0.57744598388672 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Kalb' limit 1
loadtime:0.57750701904297 / seconds
Query Executed:select id FROM `ms` where city='De Kalb' && SIC_code='6531'DB:business_master_new
loadtime:0.59746694564819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.59752893447876 / seconds
Query Executed:select id FROM `ms` where city='Decatur' && SIC_code='6531'DB:business_master_new
loadtime:0.59919285774231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta City' limit 1
loadtime:0.59926795959473 / seconds
Query Executed:select id FROM `ms` where city='Delta City' && SIC_code='6531'DB:business_master_new
loadtime:0.59969592094421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.59975695610046 / seconds
Query Executed:select id FROM `ms` where city='Dennis' && SIC_code='6531'DB:business_master_new
loadtime:0.60054898262024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derma' limit 1
loadtime:0.60060906410217 / seconds
Query Executed:select id FROM `ms` where city='Derma' && SIC_code='6531'DB:business_master_new
loadtime:0.60123085975647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamondhead' limit 1
loadtime:0.60129189491272 / seconds
Query Executed:select id FROM `ms` where city='Diamondhead' && SIC_code='6531'DB:business_master_new
loadtime:0.62141990661621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diberville' limit 1
loadtime:0.62152194976807 / seconds
Query Executed:select id FROM `ms` where city='Diberville' && SIC_code='6531'DB:business_master_new
loadtime:0.62838506698608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doddsville' limit 1
loadtime:0.62847185134888 / seconds
Query Executed:select id FROM `ms` where city='Doddsville' && SIC_code='6531'DB:business_master_new
loadtime:0.62899494171143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drew' limit 1
loadtime:0.62907004356384 / seconds
Query Executed:select id FROM `ms` where city='Drew' && SIC_code='6531'DB:business_master_new
loadtime:0.65318989753723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.65326595306396 / seconds
Query Executed:select id FROM `ms` where city='Dublin' && SIC_code='6531'DB:business_master_new
loadtime:0.65374898910522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Hill' limit 1
loadtime:0.65381097793579 / seconds
Query Executed:select id FROM `ms` where city='Duck Hill' && SIC_code='6531'DB:business_master_new
loadtime:0.65473985671997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumas' limit 1
loadtime:0.6547999382019 / seconds
Query Executed:select id FROM `ms` where city='Dumas' && SIC_code='6531'DB:business_master_new
loadtime:0.65536785125732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.65542793273926 / seconds
Query Executed:select id FROM `ms` where city='Duncan' && SIC_code='6531'DB:business_master_new
loadtime:0.65593385696411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.65599989891052 / seconds
Query Executed:select id FROM `ms` where city='Dundee' && SIC_code='6531'DB:business_master_new
loadtime:0.65670895576477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.6567850112915 / seconds
Query Executed:select id FROM `ms` where city='Durant' && SIC_code='6531'DB:business_master_new
loadtime:0.6588408946991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastabuchie' limit 1
loadtime:0.65890288352966 / seconds
Query Executed:select id FROM `ms` where city='Eastabuchie' && SIC_code='6531'DB:business_master_new
loadtime:0.65935301780701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecru' limit 1
loadtime:0.65941405296326 / seconds
Query Executed:select id FROM `ms` where city='Ecru' && SIC_code='6531'DB:business_master_new
loadtime:0.66072201728821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:0.66078305244446 / seconds
Query Executed:select id FROM `ms` where city='Edinburg' && SIC_code='6531'DB:business_master_new
loadtime:0.66116690635681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwards' limit 1
loadtime:0.66122698783875 / seconds
Query Executed:select id FROM `ms` where city='Edwards' && SIC_code='6531'DB:business_master_new
loadtime:0.66269493103027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.66277194023132 / seconds
Query Executed:select id FROM `ms` where city='Elliott' && SIC_code='6531'DB:business_master_new
loadtime:0.66328096389771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellisville' limit 1
loadtime:0.66334390640259 / seconds
Query Executed:select id FROM `ms` where city='Ellisville' && SIC_code='6531'DB:business_master_new
loadtime:0.66900300979614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enid' limit 1
loadtime:0.66908001899719 / seconds
Query Executed:select id FROM `ms` where city='Enid' && SIC_code='6531'DB:business_master_new
loadtime:0.66963887214661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.66969990730286 / seconds
Query Executed:select id FROM `ms` where city='Enterprise' && SIC_code='6531'DB:business_master_new
loadtime:0.67079091072083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escatawpa' limit 1
loadtime:0.67085194587708 / seconds
Query Executed:select id FROM `ms` where city='Escatawpa' && SIC_code='6531'DB:business_master_new
loadtime:0.67178392410278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethel' limit 1
loadtime:0.67185807228088 / seconds
Query Executed:select id FROM `ms` where city='Ethel' && SIC_code='6531'DB:business_master_new
loadtime:0.67252397537231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etta' limit 1
loadtime:0.67258405685425 / seconds
Query Executed:select id FROM `ms` where city='Etta' && SIC_code='6531'DB:business_master_new
loadtime:0.67322087287903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eupora' limit 1
loadtime:0.67328095436096 / seconds
Query Executed:select id FROM `ms` where city='Eupora' && SIC_code='6531'DB:business_master_new
loadtime:0.693608045578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:0.69368696212769 / seconds
Query Executed:select id FROM `ms` where city='Falcon' && SIC_code='6531'DB:business_master_new
loadtime:0.69408702850342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkner' limit 1
loadtime:0.69416093826294 / seconds
Query Executed:select id FROM `ms` where city='Falkner' && SIC_code='6531'DB:business_master_new
loadtime:0.69492602348328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farrell' limit 1
loadtime:0.69498991966248 / seconds
Query Executed:select id FROM `ms` where city='Farrell' && SIC_code='6531'DB:business_master_new
loadtime:0.69543099403381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.69549107551575 / seconds
Query Executed:select id FROM `ms` where city='Fayette' && SIC_code='6531'DB:business_master_new
loadtime:0.69774794578552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fernwood' limit 1
loadtime:0.69782304763794 / seconds
Query Executed:select id FROM `ms` where city='Fernwood' && SIC_code='6531'DB:business_master_new
loadtime:0.69843292236328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora' limit 1
loadtime:0.69849395751953 / seconds
Query Executed:select id FROM `ms` where city='Flora' && SIC_code='6531'DB:business_master_new
loadtime:0.71844005584717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.71852087974548 / seconds
Query Executed:select id FROM `ms` where city='Florence' && SIC_code='6531'DB:business_master_new
loadtime:0.72551584243774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flowood' limit 1
loadtime:0.72560501098633 / seconds
Query Executed:select id FROM `ms` where city='Flowood' && SIC_code='6531'DB:business_master_new
loadtime:0.73659300804138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:0.73669505119324 / seconds
Query Executed:select id FROM `ms` where city='Forest' && SIC_code='6531'DB:business_master_new
loadtime:0.75736904144287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxworth' limit 1
loadtime:0.75745606422424 / seconds
Query Executed:select id FROM `ms` where city='Foxworth' && SIC_code='6531'DB:business_master_new
loadtime:0.75915694236755 / seconds
Query loaded from cache:select * from geodata_geocity where city='French Camp' limit 1
loadtime:0.75921988487244 / seconds
Query Executed:select id FROM `ms` where city='French Camp' && SIC_code='6531'DB:business_master_new
loadtime:0.75979995727539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friars Point' limit 1
loadtime:0.75986003875732 / seconds
Query Executed:select id FROM `ms` where city='Friars Point' && SIC_code='6531'DB:business_master_new
loadtime:0.76064395904541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.76072096824646 / seconds
Query Executed:select id FROM `ms` where city='Fulton' && SIC_code='6531'DB:business_master_new
loadtime:0.78112506866455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallman' limit 1
loadtime:0.78122186660767 / seconds
Query Executed:select id FROM `ms` where city='Gallman' && SIC_code='6531'DB:business_master_new
loadtime:0.78179097175598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gattman' limit 1
loadtime:0.78185391426086 / seconds
Query Executed:select id FROM `ms` where city='Gattman' && SIC_code='6531'DB:business_master_new
loadtime:0.78239488601685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gautier' limit 1
loadtime:0.7824559211731 / seconds
Query Executed:select id FROM `ms` where city='Gautier' && SIC_code='6531'DB:business_master_new
loadtime:0.79076099395752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.79085898399353 / seconds
Query Executed:select id FROM `ms` where city='Georgetown' && SIC_code='6531'DB:business_master_new
loadtime:0.7915370464325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.79161596298218 / seconds
Query Executed:select id FROM `ms` where city='Glen' && SIC_code='6531'DB:business_master_new
loadtime:0.79236388206482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allan' limit 1
loadtime:0.79242587089539 / seconds
Query Executed:select id FROM `ms` where city='Glen Allan' && SIC_code='6531'DB:business_master_new
loadtime:0.79325103759766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendora' limit 1
loadtime:0.79331207275391 / seconds
Query Executed:select id FROM `ms` where city='Glendora' && SIC_code='6531'DB:business_master_new
loadtime:0.7938768863678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloster' limit 1
loadtime:0.79393696784973 / seconds
Query Executed:select id FROM `ms` where city='Gloster' && SIC_code='6531'DB:business_master_new
loadtime:0.79573893547058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden' limit 1
loadtime:0.79581594467163 / seconds
Query Executed:select id FROM `ms` where city='Golden' && SIC_code='6531'DB:business_master_new
loadtime:0.79711294174194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodman' limit 1
loadtime:0.79718494415283 / seconds
Query Executed:select id FROM `ms` where city='Goodman' && SIC_code='6531'DB:business_master_new
loadtime:0.79805898666382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore Springs' limit 1
loadtime:0.79811906814575 / seconds
Query Executed:select id FROM `ms` where city='Gore Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.79878187179565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grace' limit 1
loadtime:0.79885506629944 / seconds
Query Executed:select id FROM `ms` where city='Grace' && SIC_code='6531'DB:business_master_new
loadtime:0.79936695098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.79942798614502 / seconds
Query Executed:select id FROM `ms` where city='Greenville' && SIC_code='6531'DB:business_master_new
loadtime:0.82351493835449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.82365202903748 / seconds
Query Executed:select id FROM `ms` where city='Greenwood' && SIC_code='6531'DB:business_master_new
loadtime:0.83935904502869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Spgs' limit 1
loadtime:0.83949089050293 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Spgs' && SIC_code='6531'DB:business_master_new
loadtime:0.8399178981781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Springs' limit 1
loadtime:0.83998894691467 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Springs' && SIC_code='6531'DB:business_master_new
loadtime:0.84056687355042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenada' limit 1
loadtime:0.84063005447388 / seconds
Query Executed:select id FROM `ms` where city='Grenada' && SIC_code='6531'DB:business_master_new
loadtime:0.85456705093384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulfport' limit 1
loadtime:0.85466599464417 / seconds
Query Executed:select id FROM `ms` where city='Gulfport' && SIC_code='6531'DB:business_master_new
loadtime:0.90224695205688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.90255689620972 / seconds
Query Executed:select id FROM `ms` where city='Gunnison' && SIC_code='6531'DB:business_master_new
loadtime:0.90322494506836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guntown' limit 1
loadtime:0.90330195426941 / seconds
Query Executed:select id FROM `ms` where city='Guntown' && SIC_code='6531'DB:business_master_new
loadtime:0.90471386909485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.9047749042511 / seconds
Query Executed:select id FROM `ms` where city='Hamilton' && SIC_code='6531'DB:business_master_new
loadtime:0.90607500076294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harperville' limit 1
loadtime:0.90614604949951 / seconds
Query Executed:select id FROM `ms` where city='Harperville' && SIC_code='6531'DB:business_master_new
loadtime:0.90666699409485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harriston' limit 1
loadtime:0.90672707557678 / seconds
Query Executed:select id FROM `ms` where city='Harriston' && SIC_code='6531'DB:business_master_new
loadtime:0.90710186958313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.90717506408691 / seconds
Query Executed:select id FROM `ms` where city='Harrisville' && SIC_code='6531'DB:business_master_new
loadtime:0.90769290924072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hattiesburg' limit 1
loadtime:0.90775299072266 / seconds
Query Executed:select id FROM `ms` where city='Hattiesburg' && SIC_code='6531'DB:business_master_new
loadtime:0.95343995094299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazlehurst' limit 1
loadtime:0.95371103286743 / seconds
Query Executed:select id FROM `ms` where city='Hazlehurst' && SIC_code='6531'DB:business_master_new
loadtime:0.97490501403809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heidelberg' limit 1
loadtime:0.97500705718994 / seconds
Query Executed:select id FROM `ms` where city='Heidelberg' && SIC_code='6531'DB:business_master_new
loadtime:0.97694993019104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermanville' limit 1
loadtime:0.97701907157898 / seconds
Query Executed:select id FROM `ms` where city='Hermanville' && SIC_code='6531'DB:business_master_new
loadtime:0.97780895233154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernando' limit 1
loadtime:0.97786903381348 / seconds
Query Executed:select id FROM `ms` where city='Hernando' && SIC_code='6531'DB:business_master_new
loadtime:0.98749399185181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:0.98760890960693 / seconds
Query Executed:select id FROM `ms` where city='Hickory' && SIC_code='6531'DB:business_master_new
loadtime:0.98844599723816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Flat' limit 1
loadtime:0.98851203918457 / seconds
Query Executed:select id FROM `ms` where city='Hickory Flat' && SIC_code='6531'DB:business_master_new
loadtime:0.98930692672729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.98936986923218 / seconds
Query Executed:select id FROM `ms` where city='Hillsboro' && SIC_code='6531'DB:business_master_new
loadtime:0.9897940158844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcomb' limit 1
loadtime:0.98985385894775 / seconds
Query Executed:select id FROM `ms` where city='Holcomb' && SIC_code='6531'DB:business_master_new
loadtime:0.99061393737793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollandale' limit 1
loadtime:0.99067401885986 / seconds
Query Executed:select id FROM `ms` where city='Hollandale' && SIC_code='6531'DB:business_master_new
loadtime:0.99285197257996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Bluff' limit 1
loadtime:0.99292898178101 / seconds
Query Executed:select id FROM `ms` where city='Holly Bluff' && SIC_code='6531'DB:business_master_new
loadtime:0.99369692802429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:0.99375891685486 / seconds
Query Executed:select id FROM `ms` where city='Holly Ridge' && SIC_code='6531'DB:business_master_new
loadtime:0.99422192573547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:0.99428296089172 / seconds
Query Executed:select id FROM `ms` where city='Holly Springs' && SIC_code='6531'DB:business_master_new
loadtime:1.0022869110107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horn Lake' limit 1
loadtime:1.0023839473724 / seconds
Query Executed:select id FROM `ms` where city='Horn Lake' && SIC_code='6531'DB:business_master_new
loadtime:1.009309053421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houlka' limit 1
loadtime:1.0093970298767 / seconds
Query Executed:select id FROM `ms` where city='Houlka' && SIC_code='6531'DB:business_master_new
loadtime:1.0107998847961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houston' limit 1
loadtime:1.0108630657196 / seconds
Query Executed:select id FROM `ms` where city='Houston' && SIC_code='6531'DB:business_master_new
loadtime:1.0316870212555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:1.0317749977112 / seconds
Query Executed:select id FROM `ms` where city='Hurley' && SIC_code='6531'DB:business_master_new
loadtime:1.0328290462494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:1.0329060554504 / seconds
Query Executed:select id FROM `ms` where city='Independence' && SIC_code='6531'DB:business_master_new
loadtime:1.0334990024567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:1.033576965332 / seconds
Query Executed:select id FROM `ms` where city='Indianola' && SIC_code='6531'DB:business_master_new
loadtime:1.0418338775635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inverness' limit 1
loadtime:1.0419209003448 / seconds
Query Executed:select id FROM `ms` where city='Inverness' && SIC_code='6531'DB:business_master_new
loadtime:1.0432360172272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isola' limit 1
loadtime:1.0433208942413 / seconds
Query Executed:select id FROM `ms` where city='Isola' && SIC_code='6531'DB:business_master_new
loadtime:1.0444369316101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Itta Bena' limit 1
loadtime:1.0444989204407 / seconds
Query Executed:select id FROM `ms` where city='Itta Bena' && SIC_code='6531'DB:business_master_new
loadtime:1.0459599494934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iuka' limit 1
loadtime:1.0460250377655 / seconds
Query Executed:select id FROM `ms` where city='Iuka' && SIC_code='6531'DB:business_master_new
loadtime:1.066437959671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.066526889801 / seconds
Query Executed:select id FROM `ms` where city='Jackson' && SIC_code='6531'DB:business_master_new
loadtime:1.0895550251007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jayess' limit 1
loadtime:1.0900678634644 / seconds
Query Executed:select id FROM `ms` where city='Jayess' && SIC_code='6531'DB:business_master_new
loadtime:1.0913729667664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonestown' limit 1
loadtime:1.0914669036865 / seconds
Query Executed:select id FROM `ms` where city='Jonestown' && SIC_code='6531'DB:business_master_new
loadtime:1.0922019481659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keesler Afb' limit 1
loadtime:1.0922629833221 / seconds
Query Executed:select id FROM `ms` where city='Keesler Afb' && SIC_code='6531'DB:business_master_new
loadtime:1.0928609371185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmichael' limit 1
loadtime:1.0929219722748 / seconds
Query Executed:select id FROM `ms` where city='Kilmichael' && SIC_code='6531'DB:business_master_new
loadtime:1.093859910965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiln' limit 1
loadtime:1.0939209461212 / seconds
Query Executed:select id FROM `ms` where city='Kiln' && SIC_code='6531'DB:business_master_new
loadtime:1.1139109134674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kokomo' limit 1
loadtime:1.1139979362488 / seconds
Query Executed:select id FROM `ms` where city='Kokomo' && SIC_code='6531'DB:business_master_new
loadtime:1.1146819591522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kosciusko' limit 1
loadtime:1.1147449016571 / seconds
Query Executed:select id FROM `ms` where city='Kosciusko' && SIC_code='6531'DB:business_master_new
loadtime:1.1235439777374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kossuth' limit 1
loadtime:1.1236329078674 / seconds
Query Executed:select id FROM `ms` where city='Kossuth' && SIC_code='6531'DB:business_master_new
loadtime:1.124048948288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kreole' limit 1
loadtime:1.1241118907928 / seconds
Query Executed:select id FROM `ms` where city='Kreole' && SIC_code='6531'DB:business_master_new
loadtime:1.1245338916779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:1.1245949268341 / seconds
Query Executed:select id FROM `ms` where city='Lake' && SIC_code='6531'DB:business_master_new
loadtime:1.1256849765778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Cormorant' limit 1
loadtime:1.1257598400116 / seconds
Query Executed:select id FROM `ms` where city='Lake Cormorant' && SIC_code='6531'DB:business_master_new
loadtime:1.1266758441925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeshore' limit 1
loadtime:1.1267528533936 / seconds
Query Executed:select id FROM `ms` where city='Lakeshore' && SIC_code='6531'DB:business_master_new
loadtime:1.1273210048676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:1.1273829936981 / seconds
Query Executed:select id FROM `ms` where city='Lamar' && SIC_code='6531'DB:business_master_new
loadtime:1.1280219554901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambert' limit 1
loadtime:1.128082036972 / seconds
Query Executed:select id FROM `ms` where city='Lambert' && SIC_code='6531'DB:business_master_new
loadtime:1.1290349960327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lauderdale' limit 1
loadtime:1.1291098594666 / seconds
Query Executed:select id FROM `ms` where city='Lauderdale' && SIC_code='6531'DB:business_master_new
loadtime:1.1300230026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:1.1300990581512 / seconds
Query Executed:select id FROM `ms` where city='Laurel' && SIC_code='6531'DB:business_master_new
loadtime:1.151515007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.1516280174255 / seconds
Query Executed:select id FROM `ms` where city='Lawrence' && SIC_code='6531'DB:business_master_new
loadtime:1.1522419452667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leakesville' limit 1
loadtime:1.1523070335388 / seconds
Query Executed:select id FROM `ms` where city='Leakesville' && SIC_code='6531'DB:business_master_new
loadtime:1.172926902771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Learned' limit 1
loadtime:1.1730129718781 / seconds
Query Executed:select id FROM `ms` where city='Learned' && SIC_code='6531'DB:business_master_new
loadtime:1.1734209060669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:1.1734819412231 / seconds
Query Executed:select id FROM `ms` where city='Leland' && SIC_code='6531'DB:business_master_new
loadtime:1.1937260627747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lena' limit 1
loadtime:1.193806886673 / seconds
Query Executed:select id FROM `ms` where city='Lena' && SIC_code='6531'DB:business_master_new
loadtime:1.1946609020233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.1947238445282 / seconds
Query Executed:select id FROM `ms` where city='Lexington' && SIC_code='6531'DB:business_master_new
loadtime:1.214733839035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:1.2148129940033 / seconds
Query Executed:select id FROM `ms` where city='Liberty' && SIC_code='6531'DB:business_master_new
loadtime:1.2173910140991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:1.2174699306488 / seconds
Query Executed:select id FROM `ms` where city='Little Rock' && SIC_code='6531'DB:business_master_new
loadtime:1.218111038208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:1.2181839942932 / seconds
Query Executed:select id FROM `ms` where city='Long Beach' && SIC_code='6531'DB:business_master_new
loadtime:1.2272160053253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorman' limit 1
loadtime:1.2273190021515 / seconds
Query Executed:select id FROM `ms` where city='Lorman' && SIC_code='6531'DB:business_master_new
loadtime:1.228010892868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louin' limit 1
loadtime:1.2280750274658 / seconds
Query Executed:select id FROM `ms` where city='Louin' && SIC_code='6531'DB:business_master_new
loadtime:1.22882604599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louise' limit 1
loadtime:1.2289009094238 / seconds
Query Executed:select id FROM `ms` where city='Louise' && SIC_code='6531'DB:business_master_new
loadtime:1.2297189235687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:1.229779958725 / seconds
Query Executed:select id FROM `ms` where city='Louisville' && SIC_code='6531'DB:business_master_new
loadtime:1.2385568618774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucedale' limit 1
loadtime:1.238646030426 / seconds
Query Executed:select id FROM `ms` where city='Lucedale' && SIC_code='6531'DB:business_master_new
loadtime:1.2480900287628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:1.2481958866119 / seconds
Query Executed:select id FROM `ms` where city='Ludlow' && SIC_code='6531'DB:business_master_new
loadtime:1.2486100196838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lula' limit 1
loadtime:1.2486729621887 / seconds
Query Executed:select id FROM `ms` where city='Lula' && SIC_code='6531'DB:business_master_new
loadtime:1.2493760585785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:1.2494368553162 / seconds
Query Executed:select id FROM `ms` where city='Lumberton' && SIC_code='6531'DB:business_master_new
loadtime:1.2697839736938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyon' limit 1
loadtime:1.269868850708 / seconds
Query Executed:select id FROM `ms` where city='Lyon' && SIC_code='6531'DB:business_master_new
loadtime:1.2706739902496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maben' limit 1
loadtime:1.2707369327545 / seconds
Query Executed:select id FROM `ms` where city='Maben' && SIC_code='6531'DB:business_master_new
loadtime:1.2719309329987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:1.2719969749451 / seconds
Query Executed:select id FROM `ms` where city='Macon' && SIC_code='6531'DB:business_master_new
loadtime:1.2921040058136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madden' limit 1
loadtime:1.2921960353851 / seconds
Query Executed:select id FROM `ms` where city='Madden' && SIC_code='6531'DB:business_master_new
loadtime:1.29270195961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.2927649021149 / seconds
Query Executed:select id FROM `ms` where city='Madison' && SIC_code='6531'DB:business_master_new
loadtime:1.305988073349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magee' limit 1
loadtime:1.3062169551849 / seconds
Query Executed:select id FROM `ms` where city='Magee' && SIC_code='6531'DB:business_master_new
loadtime:1.3265879154205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:1.3266868591309 / seconds
Query Executed:select id FROM `ms` where city='Magnolia' && SIC_code='6531'DB:business_master_new
loadtime:1.3466360569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantachie' limit 1
loadtime:1.346715927124 / seconds
Query Executed:select id FROM `ms` where city='Mantachie' && SIC_code='6531'DB:business_master_new
loadtime:1.3665289878845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantee' limit 1
loadtime:1.3666059970856 / seconds
Query Executed:select id FROM `ms` where city='Mantee' && SIC_code='6531'DB:business_master_new
loadtime:1.3672690391541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:1.3673310279846 / seconds
Query Executed:select id FROM `ms` where city='Marietta' && SIC_code='6531'DB:business_master_new
loadtime:1.368106842041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.3681788444519 / seconds
Query Executed:select id FROM `ms` where city='Marion' && SIC_code='6531'DB:business_master_new
loadtime:1.369106054306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marks' limit 1
loadtime:1.3691790103912 / seconds
Query Executed:select id FROM `ms` where city='Marks' && SIC_code='6531'DB:business_master_new
loadtime:1.3891830444336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathiston' limit 1
loadtime:1.3892629146576 / seconds
Query Executed:select id FROM `ms` where city='Mathiston' && SIC_code='6531'DB:business_master_new
loadtime:1.3903419971466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattson' limit 1
loadtime:1.3904190063477 / seconds
Query Executed:select id FROM `ms` where city='Mattson' && SIC_code='6531'DB:business_master_new
loadtime:1.3908648490906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayersville' limit 1
loadtime:1.3909258842468 / seconds
Query Executed:select id FROM `ms` where city='Mayersville' && SIC_code='6531'DB:business_master_new
loadtime:1.3916718959808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhew' limit 1
loadtime:1.3917319774628 / seconds
Query Executed:select id FROM `ms` where city='Mayhew' && SIC_code='6531'DB:business_master_new
loadtime:1.3922400474548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adams' limit 1
loadtime:1.3923008441925 / seconds
Query Executed:select id FROM `ms` where city='Mc Adams' && SIC_code='6531'DB:business_master_new
loadtime:1.3927340507507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Call Creek' limit 1
loadtime:1.3927948474884 / seconds
Query Executed:select id FROM `ms` where city='Mc Call Creek' && SIC_code='6531'DB:business_master_new
loadtime:1.393413066864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Carley' limit 1
loadtime:1.3934719562531 / seconds
Query Executed:select id FROM `ms` where city='Mc Carley' && SIC_code='6531'DB:business_master_new
loadtime:1.3939030170441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Comb' limit 1
loadtime:1.3939640522003 / seconds
Query Executed:select id FROM `ms` where city='Mc Comb' && SIC_code='6531'DB:business_master_new
loadtime:1.3946049213409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cool' limit 1
loadtime:1.3946659564972 / seconds
Query Executed:select id FROM `ms` where city='Mc Cool' && SIC_code='6531'DB:business_master_new
loadtime:1.3953449726105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Henry' limit 1
loadtime:1.3954050540924 / seconds
Query Executed:select id FROM `ms` where city='Mc Henry' && SIC_code='6531'DB:business_master_new
loadtime:1.3960869312286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lain' limit 1
loadtime:1.3961589336395 / seconds
Query Executed:select id FROM `ms` where city='Mc Lain' && SIC_code='6531'DB:business_master_new
loadtime:1.3969159126282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neill' limit 1
loadtime:1.3969819545746 / seconds
Query Executed:select id FROM `ms` where city='Mc Neill' && SIC_code='6531'DB:business_master_new
loadtime:1.397598028183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccomb' limit 1
loadtime:1.3976578712463 / seconds
Query Executed:select id FROM `ms` where city='Mccomb' && SIC_code='6531'DB:business_master_new
loadtime:1.4135839939117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadville' limit 1
loadtime:1.4137048721313 / seconds
Query Executed:select id FROM `ms` where city='Meadville' && SIC_code='6531'DB:business_master_new
loadtime:1.4339289665222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendenhall' limit 1
loadtime:1.4340188503265 / seconds
Query Executed:select id FROM `ms` where city='Mendenhall' && SIC_code='6531'DB:business_master_new
loadtime:1.4542369842529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meridian' limit 1
loadtime:1.4543249607086 / seconds
Query Executed:select id FROM `ms` where city='Meridian' && SIC_code='6531'DB:business_master_new
loadtime:1.488461971283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merigold' limit 1
loadtime:1.4886360168457 / seconds
Query Executed:select id FROM `ms` where city='Merigold' && SIC_code='6531'DB:business_master_new
loadtime:1.4896018505096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metcalfe' limit 1
loadtime:1.4896719455719 / seconds
Query Executed:select id FROM `ms` where city='Metcalfe' && SIC_code='6531'DB:business_master_new
loadtime:1.4902470111847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan City' limit 1
loadtime:1.4903080463409 / seconds
Query Executed:select id FROM `ms` where city='Michigan City' && SIC_code='6531'DB:business_master_new
loadtime:1.490788936615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midnight' limit 1
loadtime:1.4908499717712 / seconds
Query Executed:select id FROM `ms` where city='Midnight' && SIC_code='6531'DB:business_master_new
loadtime:1.4912929534912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Wells' limit 1
loadtime:1.4913530349731 / seconds
Query Executed:select id FROM `ms` where city='Mineral Wells' && SIC_code='6531'DB:business_master_new
loadtime:1.4917378425598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minter City' limit 1
loadtime:1.4917988777161 / seconds
Query Executed:select id FROM `ms` where city='Minter City' && SIC_code='6531'DB:business_master_new
loadtime:1.4924058914185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miss State' limit 1
loadtime:1.4924659729004 / seconds
Query Executed:select id FROM `ms` where city='Miss State' && SIC_code='6531'DB:business_master_new
loadtime:1.4928419589996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mississippi State' limit 1
loadtime:1.4929020404816 / seconds
Query Executed:select id FROM `ms` where city='Mississippi State' && SIC_code='6531'DB:business_master_new
loadtime:1.4948110580444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mize' limit 1
loadtime:1.4948868751526 / seconds
Query Executed:select id FROM `ms` where city='Mize' && SIC_code='6531'DB:business_master_new
loadtime:1.4959120750427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Money' limit 1
loadtime:1.4959790706635 / seconds
Query Executed:select id FROM `ms` where city='Money' && SIC_code='6531'DB:business_master_new
loadtime:1.4963729381561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:1.4964339733124 / seconds
Query Executed:select id FROM `ms` where city='Monticello' && SIC_code='6531'DB:business_master_new
loadtime:1.5170860290527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:1.5171618461609 / seconds
Query Executed:select id FROM `ms` where city='Montpelier' && SIC_code='6531'DB:business_master_new
loadtime:1.5175788402557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooreville' limit 1
loadtime:1.517639875412 / seconds
Query Executed:select id FROM `ms` where city='Mooreville' && SIC_code='6531'DB:business_master_new
loadtime:1.5185849666595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:1.5186629295349 / seconds
Query Executed:select id FROM `ms` where city='Moorhead' && SIC_code='6531'DB:business_master_new
loadtime:1.5196740627289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan City' limit 1
loadtime:1.5197360515594 / seconds
Query Executed:select id FROM `ms` where city='Morgan City' && SIC_code='6531'DB:business_master_new
loadtime:1.5202848911285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morton' limit 1
loadtime:1.5203440189362 / seconds
Query Executed:select id FROM `ms` where city='Morton' && SIC_code='6531'DB:business_master_new
loadtime:1.5404720306396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moselle' limit 1
loadtime:1.5405540466309 / seconds
Query Executed:select id FROM `ms` where city='Moselle' && SIC_code='6531'DB:business_master_new
loadtime:1.5415589809418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss' limit 1
loadtime:1.5416209697723 / seconds
Query Executed:select id FROM `ms` where city='Moss' && SIC_code='6531'DB:business_master_new
loadtime:1.5420799255371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss Point' limit 1
loadtime:1.542151927948 / seconds
Query Executed:select id FROM `ms` where city='Moss Point' && SIC_code='6531'DB:business_master_new
loadtime:1.5519759654999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound Bayou' limit 1
loadtime:1.5520930290222 / seconds
Query Executed:select id FROM `ms` where city='Mound Bayou' && SIC_code='6531'DB:business_master_new
loadtime:1.553503036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:1.5535809993744 / seconds
Query Executed:select id FROM `ms` where city='Mount Olive' && SIC_code='6531'DB:business_master_new
loadtime:1.5552349090576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:1.5552968978882 / seconds
Query Executed:select id FROM `ms` where city='Mount Pleasant' && SIC_code='6531'DB:business_master_new
loadtime:1.5557749271393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:1.5558359622955 / seconds
Query Executed:select id FROM `ms` where city='Mt Olive' && SIC_code='6531'DB:business_master_new
loadtime:1.5562469959259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:1.5563080310822 / seconds
Query Executed:select id FROM `ms` where city='Mt Pleasant' && SIC_code='6531'DB:business_master_new
loadtime:1.5566840171814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle' limit 1
loadtime:1.5567438602448 / seconds
Query Executed:select id FROM `ms` where city='Myrtle' && SIC_code='6531'DB:business_master_new
loadtime:1.557874917984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nas Meridian' limit 1
loadtime:1.5579340457916 / seconds
Query Executed:select id FROM `ms` where city='Nas Meridian' && SIC_code='6531'DB:business_master_new
loadtime:1.5583639144897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natchez' limit 1
loadtime:1.5584239959717 / seconds
Query Executed:select id FROM `ms` where city='Natchez' && SIC_code='6531'DB:business_master_new
loadtime:1.5800559520721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neely' limit 1
loadtime:1.5801908969879 / seconds
Query Executed:select id FROM `ms` where city='Neely' && SIC_code='6531'DB:business_master_new
loadtime:1.5807240009308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesbit' limit 1
loadtime:1.5807909965515 / seconds
Query Executed:select id FROM `ms` where city='Nesbit' && SIC_code='6531'DB:business_master_new
loadtime:1.6012949943542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nettleton' limit 1
loadtime:1.6013760566711 / seconds
Query Executed:select id FROM `ms` where city='Nettleton' && SIC_code='6531'DB:business_master_new
loadtime:1.6212620735168 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albany' limit 1
loadtime:1.6213400363922 / seconds
Query Executed:select id FROM `ms` where city='New Albany' && SIC_code='6531'DB:business_master_new
loadtime:1.6315090656281 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Augusta' limit 1
loadtime:1.6316120624542 / seconds
Query Executed:select id FROM `ms` where city='New Augusta' && SIC_code='6531'DB:business_master_new
loadtime:1.6329720020294 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Site' limit 1
loadtime:1.6330509185791 / seconds
Query Executed:select id FROM `ms` where city='New Site' && SIC_code='6531'DB:business_master_new
loadtime:1.6336688995361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhebron' limit 1
loadtime:1.6337299346924 / seconds
Query Executed:select id FROM `ms` where city='Newhebron' && SIC_code='6531'DB:business_master_new
loadtime:1.634948015213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.6350128650665 / seconds
Query Executed:select id FROM `ms` where city='Newton' && SIC_code='6531'DB:business_master_new
loadtime:1.655170917511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nicholson' limit 1
loadtime:1.6552538871765 / seconds
Query Executed:select id FROM `ms` where city='Nicholson' && SIC_code='6531'DB:business_master_new
loadtime:1.655827999115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nitta Yuma' limit 1
loadtime:1.6558899879456 / seconds
Query Executed:select id FROM `ms` where city='Nitta Yuma' && SIC_code='6531'DB:business_master_new
loadtime:1.6563000679016 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carrollton' limit 1
loadtime:1.6563608646393 / seconds
Query Executed:select id FROM `ms` where city='North Carrollton' && SIC_code='6531'DB:business_master_new
loadtime:1.6570818424225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Noxapater' limit 1
loadtime:1.6571550369263 / seconds
Query Executed:select id FROM `ms` where city='Noxapater' && SIC_code='6531'DB:business_master_new
loadtime:1.6582019329071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Vale' limit 1
loadtime:1.6582629680634 / seconds
Query Executed:select id FROM `ms` where city='Oak Vale' && SIC_code='6531'DB:business_master_new
loadtime:1.6588439941406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:1.6589050292969 / seconds
Query Executed:select id FROM `ms` where city='Oakland' && SIC_code='6531'DB:business_master_new
loadtime:1.6599509716034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Springs' limit 1
loadtime:1.6600179672241 / seconds
Query Executed:select id FROM `ms` where city='Ocean Springs' && SIC_code='6531'DB:business_master_new
loadtime:1.6756918430328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okolona' limit 1
loadtime:1.6758399009705 / seconds
Query Executed:select id FROM `ms` where city='Okolona' && SIC_code='6531'DB:business_master_new
loadtime:1.6804480552673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olive Branch' limit 1
loadtime:1.6805300712585 / seconds
Query Executed:select id FROM `ms` where city='Olive Branch' && SIC_code='6531'DB:business_master_new
loadtime:1.6958248615265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osyka' limit 1
loadtime:1.695955991745 / seconds
Query Executed:select id FROM `ms` where city='Osyka' && SIC_code='6531'DB:business_master_new
loadtime:1.6971640586853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovett' limit 1
loadtime:1.6972329616547 / seconds
Query Executed:select id FROM `ms` where city='Ovett' && SIC_code='6531'DB:business_master_new
loadtime:1.6979839801788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.6980459690094 / seconds
Query Executed:select id FROM `ms` where city='Oxford' && SIC_code='6531'DB:business_master_new
loadtime:1.7149369716644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pace' limit 1
loadtime:1.7150909900665 / seconds
Query Executed:select id FROM `ms` where city='Pace' && SIC_code='6531'DB:business_master_new
loadtime:1.7156548500061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pachuta' limit 1
loadtime:1.715723991394 / seconds
Query Executed:select id FROM `ms` where city='Pachuta' && SIC_code='6531'DB:business_master_new
loadtime:1.7164330482483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panther Burn' limit 1
loadtime:1.7165088653564 / seconds
Query Executed:select id FROM `ms` where city='Panther Burn' && SIC_code='6531'DB:business_master_new
loadtime:1.7169120311737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchman' limit 1
loadtime:1.7169799804688 / seconds
Query Executed:select id FROM `ms` where city='Parchman' && SIC_code='6531'DB:business_master_new
loadtime:1.7174129486084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:1.7174739837646 / seconds
Query Executed:select id FROM `ms` where city='Paris' && SIC_code='6531'DB:business_master_new
loadtime:1.7178699970245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pascagoula' limit 1
loadtime:1.7179298400879 / seconds
Query Executed:select id FROM `ms` where city='Pascagoula' && SIC_code='6531'DB:business_master_new
loadtime:1.7343678474426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pass Christian' limit 1
loadtime:1.734482049942 / seconds
Query Executed:select id FROM `ms` where city='Pass Christian' && SIC_code='6531'DB:business_master_new
loadtime:1.742390871048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pattison' limit 1
loadtime:1.7425050735474 / seconds
Query Executed:select id FROM `ms` where city='Pattison' && SIC_code='6531'DB:business_master_new
loadtime:1.7431080341339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulding' limit 1
loadtime:1.743185043335 / seconds
Query Executed:select id FROM `ms` where city='Paulding' && SIC_code='6531'DB:business_master_new
loadtime:1.7436490058899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl' limit 1
loadtime:1.7437088489532 / seconds
Query Executed:select id FROM `ms` where city='Pearl' && SIC_code='6531'DB:business_master_new
loadtime:1.7585120201111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearlington' limit 1
loadtime:1.7586209774017 / seconds
Query Executed:select id FROM `ms` where city='Pearlington' && SIC_code='6531'DB:business_master_new
loadtime:1.759528875351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelahatchie' limit 1
loadtime:1.7596080303192 / seconds
Query Executed:select id FROM `ms` where city='Pelahatchie' && SIC_code='6531'DB:business_master_new
loadtime:1.7805390357971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinston' limit 1
loadtime:1.7806198596954 / seconds
Query Executed:select id FROM `ms` where city='Perkinston' && SIC_code='6531'DB:business_master_new
loadtime:1.7821559906006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petal' limit 1
loadtime:1.7822329998016 / seconds
Query Executed:select id FROM `ms` where city='Petal' && SIC_code='6531'DB:business_master_new
loadtime:1.7901589870453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pheba' limit 1
loadtime:1.7902460098267 / seconds
Query Executed:select id FROM `ms` where city='Pheba' && SIC_code='6531'DB:business_master_new
loadtime:1.7908959388733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philadelphia' limit 1
loadtime:1.7909588813782 / seconds
Query Executed:select id FROM `ms` where city='Philadelphia' && SIC_code='6531'DB:business_master_new
loadtime:1.801894903183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philipp' limit 1
loadtime:1.8019969463348 / seconds
Query Executed:select id FROM `ms` where city='Philipp' && SIC_code='6531'DB:business_master_new
loadtime:1.8025419712067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picayune' limit 1
loadtime:1.8026070594788 / seconds
Query Executed:select id FROM `ms` where city='Picayune' && SIC_code='6531'DB:business_master_new
loadtime:1.8163619041443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:1.8164808750153 / seconds
Query Executed:select id FROM `ms` where city='Pickens' && SIC_code='6531'DB:business_master_new
loadtime:1.8175809383392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Woods' limit 1
loadtime:1.81764793396 / seconds
Query Executed:select id FROM `ms` where city='Piney Woods' && SIC_code='6531'DB:business_master_new
loadtime:1.818067073822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinola' limit 1
loadtime:1.81813788414 / seconds
Query Executed:select id FROM `ms` where city='Pinola' && SIC_code='6531'DB:business_master_new
loadtime:1.8188169002533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:1.8188779354095 / seconds
Query Executed:select id FROM `ms` where city='Pittsboro' && SIC_code='6531'DB:business_master_new
loadtime:1.8197309970856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantersville' limit 1
loadtime:1.8197908401489 / seconds
Query Executed:select id FROM `ms` where city='Plantersville' && SIC_code='6531'DB:business_master_new
loadtime:1.8207969665527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:1.8208570480347 / seconds
Query Executed:select id FROM `ms` where city='Pocahontas' && SIC_code='6531'DB:business_master_new
loadtime:1.8212368488312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontotoc' limit 1
loadtime:1.8212969303131 / seconds
Query Executed:select id FROM `ms` where city='Pontotoc' && SIC_code='6531'DB:business_master_new
loadtime:1.8311369419098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope' limit 1
loadtime:1.8312320709229 / seconds
Query Executed:select id FROM `ms` where city='Pope' && SIC_code='6531'DB:business_master_new
loadtime:1.8319149017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplarville' limit 1
loadtime:1.8319840431213 / seconds
Query Executed:select id FROM `ms` where city='Poplarville' && SIC_code='6531'DB:business_master_new
loadtime:1.8384609222412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Gibson' limit 1
loadtime:1.8385479450226 / seconds
Query Executed:select id FROM `ms` where city='Port Gibson' && SIC_code='6531'DB:business_master_new
loadtime:1.8595149517059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porterville' limit 1
loadtime:1.8596000671387 / seconds
Query Executed:select id FROM `ms` where city='Porterville' && SIC_code='6531'DB:business_master_new
loadtime:1.8601229190826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potts Camp' limit 1
loadtime:1.8601958751678 / seconds
Query Executed:select id FROM `ms` where city='Potts Camp' && SIC_code='6531'DB:business_master_new
loadtime:1.8613140583038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie' limit 1
loadtime:1.861389875412 / seconds
Query Executed:select id FROM `ms` where city='Prairie' && SIC_code='6531'DB:business_master_new
loadtime:1.8621129989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prentiss' limit 1
loadtime:1.8621850013733 / seconds
Query Executed:select id FROM `ms` where city='Prentiss' && SIC_code='6531'DB:business_master_new
loadtime:1.8826768398285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:1.8827538490295 / seconds
Query Executed:select id FROM `ms` where city='Preston' && SIC_code='6531'DB:business_master_new
loadtime:1.8834810256958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puckett' limit 1
loadtime:1.8835558891296 / seconds
Query Executed:select id FROM `ms` where city='Puckett' && SIC_code='6531'DB:business_master_new
loadtime:1.884192943573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:1.8842539787292 / seconds
Query Executed:select id FROM `ms` where city='Pulaski' && SIC_code='6531'DB:business_master_new
loadtime:1.8847930431366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purvis' limit 1
loadtime:1.8848538398743 / seconds
Query Executed:select id FROM `ms` where city='Purvis' && SIC_code='6531'DB:business_master_new
loadtime:1.9049918651581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quitman' limit 1
loadtime:1.9050750732422 / seconds
Query Executed:select id FROM `ms` where city='Quitman' && SIC_code='6531'DB:business_master_new
loadtime:1.9251959323883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:1.9252779483795 / seconds
Query Executed:select id FROM `ms` where city='Raleigh' && SIC_code='6531'DB:business_master_new
loadtime:1.9274060726166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.9274690151215 / seconds
Query Executed:select id FROM `ms` where city='Randolph' && SIC_code='6531'DB:business_master_new
loadtime:1.9280860424042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:1.9281580448151 / seconds
Query Executed:select id FROM `ms` where city='Raymond' && SIC_code='6531'DB:business_master_new
loadtime:1.9483439922333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Banks' limit 1
loadtime:1.9484279155731 / seconds
Query Executed:select id FROM `ms` where city='Red Banks' && SIC_code='6531'DB:business_master_new
loadtime:1.949156999588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:1.9492340087891 / seconds
Query Executed:select id FROM `ms` where city='Redwood' && SIC_code='6531'DB:business_master_new
loadtime:1.949805021286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rena Lara' limit 1
loadtime:1.9498660564423 / seconds
Query Executed:select id FROM `ms` where city='Rena Lara' && SIC_code='6531'DB:business_master_new
loadtime:1.950404882431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:1.9504659175873 / seconds
Query Executed:select id FROM `ms` where city='Richland' && SIC_code='6531'DB:business_master_new
loadtime:1.9569809436798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richton' limit 1
loadtime:1.9570639133453 / seconds
Query Executed:select id FROM `ms` where city='Richton' && SIC_code='6531'DB:business_master_new
loadtime:1.9772109985352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:1.9772908687592 / seconds
Query Executed:select id FROM `ms` where city='Ridgeland' && SIC_code='6531'DB:business_master_new
loadtime:1.9972870349884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rienzi' limit 1
loadtime:1.9974699020386 / seconds
Query Executed:select id FROM `ms` where city='Rienzi' && SIC_code='6531'DB:business_master_new
loadtime:1.9987359046936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripley' limit 1
loadtime:1.9988059997559 / seconds
Query Executed:select id FROM `ms` where city='Ripley' && SIC_code='6531'DB:business_master_new
loadtime:2.0066039562225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robinsonville' limit 1
loadtime:2.0066919326782 / seconds
Query Executed:select id FROM `ms` where city='Robinsonville' && SIC_code='6531'DB:business_master_new
loadtime:2.0270738601685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolling Fork' limit 1
loadtime:2.027163028717 / seconds
Query Executed:select id FROM `ms` where city='Rolling Fork' && SIC_code='6531'DB:business_master_new
loadtime:2.0472168922424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:2.0472810268402 / seconds
Query Executed:select id FROM `ms` where city='Rome' && SIC_code='6531'DB:business_master_new
loadtime:2.0477368831635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:2.047798871994 / seconds
Query Executed:select id FROM `ms` where city='Rose Hill' && SIC_code='6531'DB:business_master_new
loadtime:2.0484440326691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:2.0485050678253 / seconds
Query Executed:select id FROM `ms` where city='Rosedale' && SIC_code='6531'DB:business_master_new
loadtime:2.0499498844147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxie' limit 1
loadtime:2.0500159263611 / seconds
Query Executed:select id FROM `ms` where city='Roxie' && SIC_code='6531'DB:business_master_new
loadtime:2.0508308410645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruleville' limit 1
loadtime:2.0508909225464 / seconds
Query Executed:select id FROM `ms` where city='Ruleville' && SIC_code='6531'DB:business_master_new
loadtime:2.0527248382568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:2.0527849197388 / seconds
Query Executed:select id FROM `ms` where city='Ruth' && SIC_code='6531'DB:business_master_new
loadtime:2.0534698963165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sallis' limit 1
loadtime:2.0535309314728 / seconds
Query Executed:select id FROM `ms` where city='Sallis' && SIC_code='6531'DB:business_master_new
loadtime:2.054249048233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltillo' limit 1
loadtime:2.0543098449707 / seconds
Query Executed:select id FROM `ms` where city='Saltillo' && SIC_code='6531'DB:business_master_new
loadtime:2.0743749141693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanatorium' limit 1
loadtime:2.0744528770447 / seconds
Query Executed:select id FROM `ms` where city='Sanatorium' && SIC_code='6531'DB:business_master_new
loadtime:2.0748510360718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandersville' limit 1
loadtime:2.0749130249023 / seconds
Query Executed:select id FROM `ms` where city='Sandersville' && SIC_code='6531'DB:business_master_new
loadtime:2.0757369995117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandhill' limit 1
loadtime:2.075798034668 / seconds
Query Executed:select id FROM `ms` where city='Sandhill' && SIC_code='6531'DB:business_master_new
loadtime:2.0762510299683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:2.0763108730316 / seconds
Query Executed:select id FROM `ms` where city='Sandy Hook' && SIC_code='6531'DB:business_master_new
loadtime:2.077113866806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanitorium' limit 1
loadtime:2.0771980285645 / seconds
Query Executed:select id FROM `ms` where city='Sanitorium' && SIC_code='6531'DB:business_master_new
loadtime:2.0775878429413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarah' limit 1
loadtime:2.0776479244232 / seconds
Query Executed:select id FROM `ms` where city='Sarah' && SIC_code='6531'DB:business_master_new
loadtime:2.0783479213715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardis' limit 1
loadtime:2.0784089565277 / seconds
Query Executed:select id FROM `ms` where city='Sardis' && SIC_code='6531'DB:business_master_new
loadtime:2.0809080600739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Satartia' limit 1
loadtime:2.0809900760651 / seconds
Query Executed:select id FROM `ms` where city='Satartia' && SIC_code='6531'DB:business_master_new
loadtime:2.081503868103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saucier' limit 1
loadtime:2.0815658569336 / seconds
Query Executed:select id FROM `ms` where city='Saucier' && SIC_code='6531'DB:business_master_new
loadtime:2.1016979217529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schlater' limit 1
loadtime:2.10178399086 / seconds
Query Executed:select id FROM `ms` where city='Schlater' && SIC_code='6531'DB:business_master_new
loadtime:2.1024780273438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scobey' limit 1
loadtime:2.1025550365448 / seconds
Query Executed:select id FROM `ms` where city='Scobey' && SIC_code='6531'DB:business_master_new
loadtime:2.1030740737915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scooba' limit 1
loadtime:2.1031470298767 / seconds
Query Executed:select id FROM `ms` where city='Scooba' && SIC_code='6531'DB:business_master_new
loadtime:2.1039249897003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scott' limit 1
loadtime:2.1040060520172 / seconds
Query Executed:select id FROM `ms` where city='Scott' && SIC_code='6531'DB:business_master_new
loadtime:2.1045649051666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebastopol' limit 1
loadtime:2.1046268939972 / seconds
Query Executed:select id FROM `ms` where city='Sebastopol' && SIC_code='6531'DB:business_master_new
loadtime:2.1055579185486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seminary' limit 1
loadtime:2.1056189537048 / seconds
Query Executed:select id FROM `ms` where city='Seminary' && SIC_code='6531'DB:business_master_new
loadtime:2.1073880195618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Senatobia' limit 1
loadtime:2.1074478626251 / seconds
Query Executed:select id FROM `ms` where city='Senatobia' && SIC_code='6531'DB:business_master_new
loadtime:2.1158559322357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:2.1159639358521 / seconds
Query Executed:select id FROM `ms` where city='Shannon' && SIC_code='6531'DB:business_master_new
loadtime:2.1178760528564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.1179540157318 / seconds
Query Executed:select id FROM `ms` where city='Sharon' && SIC_code='6531'DB:business_master_new
loadtime:2.1183819770813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw' limit 1
loadtime:2.1184439659119 / seconds
Query Executed:select id FROM `ms` where city='Shaw' && SIC_code='6531'DB:business_master_new
loadtime:2.1384148597717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:2.1384768486023 / seconds
Query Executed:select id FROM `ms` where city='Shelby' && SIC_code='6531'DB:business_master_new
loadtime:2.1398818492889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherard' limit 1
loadtime:2.1399569511414 / seconds
Query Executed:select id FROM `ms` where city='Sherard' && SIC_code='6531'DB:business_master_new
loadtime:2.140419960022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:2.1404819488525 / seconds
Query Executed:select id FROM `ms` where city='Sherman' && SIC_code='6531'DB:business_master_new
loadtime:2.1412558555603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shubuta' limit 1
loadtime:2.1413159370422 / seconds
Query Executed:select id FROM `ms` where city='Shubuta' && SIC_code='6531'DB:business_master_new
loadtime:2.1425218582153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shuqualak' limit 1
loadtime:2.1425828933716 / seconds
Query Executed:select id FROM `ms` where city='Shuqualak' && SIC_code='6531'DB:business_master_new
loadtime:2.1434030532837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:2.1434638500214 / seconds
Query Executed:select id FROM `ms` where city='Sibley' && SIC_code='6531'DB:business_master_new
loadtime:2.143914937973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidon' limit 1
loadtime:2.1439809799194 / seconds
Query Executed:select id FROM `ms` where city='Sidon' && SIC_code='6531'DB:business_master_new
loadtime:2.1445589065552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:2.1446189880371 / seconds
Query Executed:select id FROM `ms` where city='Silver City' && SIC_code='6531'DB:business_master_new
loadtime:2.1451609134674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Creek' limit 1
loadtime:2.1452209949493 / seconds
Query Executed:select id FROM `ms` where city='Silver Creek' && SIC_code='6531'DB:business_master_new
loadtime:2.1461219787598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slate Spring' limit 1
loadtime:2.1461939811707 / seconds
Query Executed:select id FROM `ms` where city='Slate Spring' && SIC_code='6531'DB:business_master_new
loadtime:2.1466040611267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sledge' limit 1
loadtime:2.1466639041901 / seconds
Query Executed:select id FROM `ms` where city='Sledge' && SIC_code='6531'DB:business_master_new
loadtime:2.1474230289459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithdale' limit 1
loadtime:2.1474828720093 / seconds
Query Executed:select id FROM `ms` where city='Smithdale' && SIC_code='6531'DB:business_master_new
loadtime:2.1482110023499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:2.1482708454132 / seconds
Query Executed:select id FROM `ms` where city='Smithville' && SIC_code='6531'DB:business_master_new
loadtime:2.1496300697327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sontag' limit 1
loadtime:2.1496908664703 / seconds
Query Executed:select id FROM `ms` where city='Sontag' && SIC_code='6531'DB:business_master_new
loadtime:2.1503038406372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soso' limit 1
loadtime:2.1503639221191 / seconds
Query Executed:select id FROM `ms` where city='Soso' && SIC_code='6531'DB:business_master_new
loadtime:2.1514730453491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southaven' limit 1
loadtime:2.1515338420868 / seconds
Query Executed:select id FROM `ms` where city='Southaven' && SIC_code='6531'DB:business_master_new
loadtime:2.169401884079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:2.1695709228516 / seconds
Query Executed:select id FROM `ms` where city='Star' && SIC_code='6531'DB:business_master_new
loadtime:2.1701390743256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starkville' limit 1
loadtime:2.1702098846436 / seconds
Query Executed:select id FROM `ms` where city='Starkville' && SIC_code='6531'DB:business_master_new
loadtime:2.1859638690948 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Line' limit 1
loadtime:2.1860959529877 / seconds
Query Executed:select id FROM `ms` where city='State Line' && SIC_code='6531'DB:business_master_new
loadtime:2.1873650550842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steens' limit 1
loadtime:2.1874330043793 / seconds
Query Executed:select id FROM `ms` where city='Steens' && SIC_code='6531'DB:business_master_new
loadtime:2.1884489059448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Space Center' limit 1
loadtime:2.1885240077972 / seconds
Query Executed:select id FROM `ms` where city='Stennis Space Center' && SIC_code='6531'DB:business_master_new
loadtime:2.1891548633575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Spc Ctr' limit 1
loadtime:2.1892290115356 / seconds
Query Executed:select id FROM `ms` where city='Stennis Spc Ctr' && SIC_code='6531'DB:business_master_new
loadtime:2.1896438598633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewart' limit 1
loadtime:2.1897048950195 / seconds
Query Executed:select id FROM `ms` where city='Stewart' && SIC_code='6531'DB:business_master_new
loadtime:2.1902379989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:2.1902990341187 / seconds
Query Executed:select id FROM `ms` where city='Stoneville' && SIC_code='6531'DB:business_master_new
loadtime:2.1910078525543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:2.1910820007324 / seconds
Query Executed:select id FROM `ms` where city='Stonewall' && SIC_code='6531'DB:business_master_new
loadtime:2.1918339729309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stringer' limit 1
loadtime:2.1918950080872 / seconds
Query Executed:select id FROM `ms` where city='Stringer' && SIC_code='6531'DB:business_master_new
loadtime:2.1926810741425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:2.1927559375763 / seconds
Query Executed:select id FROM `ms` where city='Sturgis' && SIC_code='6531'DB:business_master_new
loadtime:2.1937170028687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:2.1937789916992 / seconds
Query Executed:select id FROM `ms` where city='Summit' && SIC_code='6531'DB:business_master_new
loadtime:2.2145738601685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:2.2146558761597 / seconds
Query Executed:select id FROM `ms` where city='Sumner' && SIC_code='6531'DB:business_master_new
loadtime:2.215714931488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumrall' limit 1
loadtime:2.2157900333405 / seconds
Query Executed:select id FROM `ms` where city='Sumrall' && SIC_code='6531'DB:business_master_new
loadtime:2.2355408668518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunflower' limit 1
loadtime:2.2356040477753 / seconds
Query Executed:select id FROM `ms` where city='Sunflower' && SIC_code='6531'DB:business_master_new
loadtime:2.2366318702698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan Lake' limit 1
loadtime:2.2367069721222 / seconds
Query Executed:select id FROM `ms` where city='Swan Lake' && SIC_code='6531'DB:business_master_new
loadtime:2.237114906311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swiftown' limit 1
loadtime:2.2371859550476 / seconds
Query Executed:select id FROM `ms` where city='Swiftown' && SIC_code='6531'DB:business_master_new
loadtime:2.2375819683075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:2.2376420497894 / seconds
Query Executed:select id FROM `ms` where city='Taylor' && SIC_code='6531'DB:business_master_new
loadtime:2.238175868988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:2.2382369041443 / seconds
Query Executed:select id FROM `ms` where city='Taylorsville' && SIC_code='6531'DB:business_master_new
loadtime:2.2403268814087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tchula' limit 1
loadtime:2.2404048442841 / seconds
Query Executed:select id FROM `ms` where city='Tchula' && SIC_code='6531'DB:business_master_new
loadtime:2.2416858673096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terry' limit 1
loadtime:2.241760969162 / seconds
Query Executed:select id FROM `ms` where city='Terry' && SIC_code='6531'DB:business_master_new
loadtime:2.2618288993835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:2.2619140148163 / seconds
Query Executed:select id FROM `ms` where city='Thaxton' && SIC_code='6531'DB:business_master_new
loadtime:2.2625348567963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomastown' limit 1
loadtime:2.2625980377197 / seconds
Query Executed:select id FROM `ms` where city='Thomastown' && SIC_code='6531'DB:business_master_new
loadtime:2.2630360126495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tie Plant' limit 1
loadtime:2.2630958557129 / seconds
Query Executed:select id FROM `ms` where city='Tie Plant' && SIC_code='6531'DB:business_master_new
loadtime:2.2634968757629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillatoba' limit 1
loadtime:2.2635579109192 / seconds
Query Executed:select id FROM `ms` where city='Tillatoba' && SIC_code='6531'DB:business_master_new
loadtime:2.2641010284424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinsley' limit 1
loadtime:2.2641730308533 / seconds
Query Executed:select id FROM `ms` where city='Tinsley' && SIC_code='6531'DB:business_master_new
loadtime:2.2646100521088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiplersville' limit 1
loadtime:2.2646698951721 / seconds
Query Executed:select id FROM `ms` where city='Tiplersville' && SIC_code='6531'DB:business_master_new
loadtime:2.2651970386505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tippo' limit 1
loadtime:2.2652568817139 / seconds
Query Executed:select id FROM `ms` where city='Tippo' && SIC_code='6531'DB:business_master_new
loadtime:2.2657308578491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tishomingo' limit 1
loadtime:2.2657909393311 / seconds
Query Executed:select id FROM `ms` where city='Tishomingo' && SIC_code='6531'DB:business_master_new
loadtime:2.2671120166779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toccopola' limit 1
loadtime:2.2671840190887 / seconds
Query Executed:select id FROM `ms` where city='Toccopola' && SIC_code='6531'DB:business_master_new
loadtime:2.2676088809967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toomsuba' limit 1
loadtime:2.2676689624786 / seconds
Query Executed:select id FROM `ms` where city='Toomsuba' && SIC_code='6531'DB:business_master_new
loadtime:2.268846988678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tougaloo' limit 1
loadtime:2.2689080238342 / seconds
Query Executed:select id FROM `ms` where city='Tougaloo' && SIC_code='6531'DB:business_master_new
loadtime:2.2695250511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trebloc' limit 1
loadtime:2.2695989608765 / seconds
Query Executed:select id FROM `ms` where city='Trebloc' && SIC_code='6531'DB:business_master_new
loadtime:2.2700018882751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremont' limit 1
loadtime:2.2700619697571 / seconds
Query Executed:select id FROM `ms` where city='Tremont' && SIC_code='6531'DB:business_master_new
loadtime:2.2707810401917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tula' limit 1
loadtime:2.2708559036255 / seconds
Query Executed:select id FROM `ms` where city='Tula' && SIC_code='6531'DB:business_master_new
loadtime:2.27126288414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunica' limit 1
loadtime:2.2713239192963 / seconds
Query Executed:select id FROM `ms` where city='Tunica' && SIC_code='6531'DB:business_master_new
loadtime:2.2916660308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tupelo' limit 1
loadtime:2.2917518615723 / seconds
Query Executed:select id FROM `ms` where city='Tupelo' && SIC_code='6531'DB:business_master_new
loadtime:2.3247759342194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tutwiler' limit 1
loadtime:2.3249459266663 / seconds
Query Executed:select id FROM `ms` where city='Tutwiler' && SIC_code='6531'DB:business_master_new
loadtime:2.3259019851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tylertown' limit 1
loadtime:2.3259780406952 / seconds
Query Executed:select id FROM `ms` where city='Tylertown' && SIC_code='6531'DB:business_master_new
loadtime:2.3467679023743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:2.3468508720398 / seconds
Query Executed:select id FROM `ms` where city='Union' && SIC_code='6531'DB:business_master_new
loadtime:2.3490998744965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Church' limit 1
loadtime:2.3491899967194 / seconds
Query Executed:select id FROM `ms` where city='Union Church' && SIC_code='6531'DB:business_master_new
loadtime:2.3497278690338 / seconds
Query loaded from cache:select * from geodata_geocity where city='University' limit 1
loadtime:2.3497898578644 / seconds
Query Executed:select id FROM `ms` where city='University' && SIC_code='6531'DB:business_master_new
loadtime:2.350781917572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:2.3508560657501 / seconds
Query Executed:select id FROM `ms` where city='Utica' && SIC_code='6531'DB:business_master_new
loadtime:2.3525688648224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaiden' limit 1
loadtime:2.3526449203491 / seconds
Query Executed:select id FROM `ms` where city='Vaiden' && SIC_code='6531'DB:business_master_new
loadtime:2.3539929389954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Park' limit 1
loadtime:2.3540549278259 / seconds
Query Executed:select id FROM `ms` where city='Valley Park' && SIC_code='6531'DB:business_master_new
loadtime:2.3545429706573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Vleet' limit 1
loadtime:2.3546049594879 / seconds
Query Executed:select id FROM `ms` where city='Van Vleet' && SIC_code='6531'DB:business_master_new
loadtime:2.3550798892975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:2.3551509380341 / seconds
Query Executed:select id FROM `ms` where city='Vance' && SIC_code='6531'DB:business_master_new
loadtime:2.355623960495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vancleave' limit 1
loadtime:2.3556849956512 / seconds
Query Executed:select id FROM `ms` where city='Vancleave' && SIC_code='6531'DB:business_master_new
loadtime:2.3757429122925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vardaman' limit 1
loadtime:2.3758249282837 / seconds
Query Executed:select id FROM `ms` where city='Vardaman' && SIC_code='6531'DB:business_master_new
loadtime:2.3772280216217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:2.3772900104523 / seconds
Query Executed:select id FROM `ms` where city='Vaughan' && SIC_code='6531'DB:business_master_new
loadtime:2.3778998851776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:2.3779799938202 / seconds
Query Executed:select id FROM `ms` where city='Verona' && SIC_code='6531'DB:business_master_new
loadtime:2.3798830509186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:2.3799669742584 / seconds
Query Executed:select id FROM `ms` where city='Vicksburg' && SIC_code='6531'DB:business_master_new
loadtime:2.4057440757751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:2.4058849811554 / seconds
Query Executed:select id FROM `ms` where city='Victoria' && SIC_code='6531'DB:business_master_new
loadtime:2.406506061554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vossburg' limit 1
loadtime:2.4065730571747 / seconds
Query Executed:select id FROM `ms` where city='Vossburg' && SIC_code='6531'DB:business_master_new
loadtime:2.4071578979492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walls' limit 1
loadtime:2.4072189331055 / seconds
Query Executed:select id FROM `ms` where city='Walls' && SIC_code='6531'DB:business_master_new
loadtime:2.4088709354401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:2.4089460372925 / seconds
Query Executed:select id FROM `ms` where city='Walnut' && SIC_code='6531'DB:business_master_new
loadtime:2.4292778968811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Grove' limit 1
loadtime:2.429358959198 / seconds
Query Executed:select id FROM `ms` where city='Walnut Grove' && SIC_code='6531'DB:business_master_new
loadtime:2.4304368495941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walthall' limit 1
loadtime:2.4305000305176 / seconds
Query Executed:select id FROM `ms` where city='Walthall' && SIC_code='6531'DB:business_master_new
loadtime:2.431058883667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.4311189651489 / seconds
Query Executed:select id FROM `ms` where city='Washington' && SIC_code='6531'DB:business_master_new
loadtime:2.4317660331726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water Valley' limit 1
loadtime:2.431825876236 / seconds
Query Executed:select id FROM `ms` where city='Water Valley' && SIC_code='6531'DB:business_master_new
loadtime:2.4520220756531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:2.4521110057831 / seconds
Query Executed:select id FROM `ms` where city='Waterford' && SIC_code='6531'DB:business_master_new
loadtime:2.4527769088745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waveland' limit 1
loadtime:2.4528398513794 / seconds
Query Executed:select id FROM `ms` where city='Waveland' && SIC_code='6531'DB:business_master_new
loadtime:2.472913980484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:2.4730079174042 / seconds
Query Executed:select id FROM `ms` where city='Waynesboro' && SIC_code='6531'DB:business_master_new
loadtime:2.4817900657654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayside' limit 1
loadtime:2.4818739891052 / seconds
Query Executed:select id FROM `ms` where city='Wayside' && SIC_code='6531'DB:business_master_new
loadtime:2.4823269844055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:2.4823889732361 / seconds
Query Executed:select id FROM `ms` where city='Webb' && SIC_code='6531'DB:business_master_new
loadtime:2.4831719398499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weir' limit 1
loadtime:2.4832470417023 / seconds
Query Executed:select id FROM `ms` where city='Weir' && SIC_code='6531'DB:business_master_new
loadtime:2.483962059021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesson' limit 1
loadtime:2.4840278625488 / seconds
Query Executed:select id FROM `ms` where city='Wesson' && SIC_code='6531'DB:business_master_new
loadtime:2.4857230186462 / seconds
Query loaded from cache:select * from geodata_geocity where city='West' limit 1
loadtime:2.4857828617096 / seconds
Query Executed:select id FROM `ms` where city='West' && SIC_code='6531'DB:business_master_new
loadtime:2.486496925354 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:2.4865570068359 / seconds
Query Executed:select id FROM `ms` where city='West Point' && SIC_code='6531'DB:business_master_new
loadtime:2.4969749450684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:2.4970948696136 / seconds
Query Executed:select id FROM `ms` where city='Wheeler' && SIC_code='6531'DB:business_master_new
loadtime:2.4975910186768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitfield' limit 1
loadtime:2.497654914856 / seconds
Query Executed:select id FROM `ms` where city='Whitfield' && SIC_code='6531'DB:business_master_new
loadtime:2.4981069564819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiggins' limit 1
loadtime:2.4981789588928 / seconds
Query Executed:select id FROM `ms` where city='Wiggins' && SIC_code='6531'DB:business_master_new
loadtime:2.5049960613251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winona' limit 1
loadtime:2.5050828456879 / seconds
Query Executed:select id FROM `ms` where city='Winona' && SIC_code='6531'DB:business_master_new
loadtime:2.5108230113983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winstonville' limit 1
loadtime:2.5109059810638 / seconds
Query Executed:select id FROM `ms` where city='Winstonville' && SIC_code='6531'DB:business_master_new
loadtime:2.511353969574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:2.5114169120789 / seconds
Query Executed:select id FROM `ms` where city='Winterville' && SIC_code='6531'DB:business_master_new
loadtime:2.5118360519409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:2.5118958950043 / seconds
Query Executed:select id FROM `ms` where city='Woodland' && SIC_code='6531'DB:business_master_new
loadtime:2.5127170085907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.5127768516541 / seconds
Query Executed:select id FROM `ms` where city='Woodville' && SIC_code='6531'DB:business_master_new
loadtime:2.5333380699158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yazoo City' limit 1
loadtime:2.5334210395813 / seconds
Query Executed:select id FROM `ms` where city='Yazoo City' && SIC_code='6531'DB:business_master_new
loadtime:2.5433969497681 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.5435829162598 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.5440258979797 / seconds
Operation template executed (chunk cache operation)
loadtime:2.544203042984 / seconds
template override:Default
loadtime:2.5442459583282 / 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:2.545520067215 / seconds
Template Constructed, Array Rows:49
loadtime:2.5460569858551 / seconds
TOTAL EXECUTION TIME: 2.54561
loadtime:2.5480480194092 / 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] => real-estate-agents-and-managers [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:2.5480580329895
TOTAL KEY ARRAYS: 69