Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.392333984375E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00047397613525391 / seconds
host not found setting manual db connection
loadtime:0.00077295303344727 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010349750518799 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0011520385742188 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0012009143829346 / seconds
zipcode:
loadtime:0.0012309551239014 / seconds
Query Executed:select * from search_referrer where page_hash='98982697efb35222f57b4946c42cbdf4' limit 10 DB:ezrox_toadli
loadtime:0.0014059543609619 / seconds
Operation header executed (non global)
loadtime:0.0014228820800781 / seconds
Operation leaderboard executed (non global)
loadtime:0.0014488697052002 / seconds
Operation square executed (non global)
loadtime:0.0014629364013672 / seconds
Operation square_bottom executed (non global)
loadtime:0.0014748573303223 / seconds
Operation smallsquare executed (non global)
loadtime:0.0014858245849609 / seconds
Operation headeradright executed (non global)
loadtime:0.0014970302581787 / seconds
Operation google_analytics executed (non global)
loadtime:0.001507043838501 / seconds
Operation topstories executed (non global)
loadtime:0.0015189647674561 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0015299320220947 / seconds
Operation memberbuscount executed (non global)
loadtime:0.001539945602417 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001762866973877 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0019099712371826 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0019469261169434 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0020098686218262 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0020468235015869 / seconds
Template key: archive_menu pushed
loadtime:0.002051830291748 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0020580291748047 / seconds
Template key: get_gravatar pushed
loadtime:0.0020618438720703 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0020649433135986 / seconds
*10)-10)+1 | start:0
loadtime:0.002086877822876 / seconds
DB connected to localhost business_master_new
loadtime:0.0023159980773926 / seconds
Query Executed:select * from categories where cat_URLid='religious-organizations'DB:business_master_new
loadtime:0.0028150081634521 / seconds
Query stored in cache : _QUERY_www.toadli.com626ed171a2bc51d93e031e76f350a479
loadtime:0.0028579235076904 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.0028798580169678 / seconds
Query Executed:select * from `ma_catmap` where sic='8661' order by city ascDB:business_master_new
loadtime:0.13728880882263 / seconds
Query stored in cache : _QUERY_www.toadli.com7d520b68baf265d071da4fceacd031d9
loadtime:0.13811683654785 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.13815188407898 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='8661'DB:business_master_new
loadtime:0.14129090309143 / seconds
Query stored in cache : _QUERY_www.toadli.comdb430095546165f8d34d2789c32613a4
loadtime:0.14132285118103 / seconds
559 / 11
loadtime:0.14135503768921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.14139986038208 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='8661'DB:business_master_new
loadtime:0.16999292373657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.17005586624146 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='8661'DB:business_master_new
loadtime:0.17478084564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.17481589317322 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='8661'DB:business_master_new
loadtime:0.18036198616028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.18042397499084 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='8661'DB:business_master_new
loadtime:0.18423104286194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.18427681922913 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='8661'DB:business_master_new
loadtime:0.18761491775513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.18767404556274 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='8661'DB:business_master_new
loadtime:0.19425082206726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.19429898262024 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='8661'DB:business_master_new
loadtime:0.19456195831299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.19460296630859 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='8661'DB:business_master_new
loadtime:0.19934988021851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.19940900802612 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='8661'DB:business_master_new
loadtime:0.20509386062622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.20514297485352 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='8661'DB:business_master_new
loadtime:0.23749995231628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.23756790161133 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='8661'DB:business_master_new
loadtime:0.24708795547485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.24714493751526 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='8661'DB:business_master_new
loadtime:0.24773192405701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.24777984619141 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='8661'DB:business_master_new
loadtime:0.26238083839417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.2624340057373 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='8661'DB:business_master_new
loadtime:0.264408826828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.2644579410553 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='8661'DB:business_master_new
loadtime:0.26480293273926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.26485896110535 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='8661'DB:business_master_new
loadtime:0.36831402778625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.36837601661682 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='8661'DB:business_master_new
loadtime:0.41471695899963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.41477203369141 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='8661'DB:business_master_new
loadtime:0.45869183540344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.45873594284058 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='8661'DB:business_master_new
loadtime:0.4631679058075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.46323680877686 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='8661'DB:business_master_new
loadtime:0.47043991088867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.47048282623291 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='8661'DB:business_master_new
loadtime:0.56356596946716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.56362390518188 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='8661'DB:business_master_new
loadtime:0.57874298095703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.57879400253296 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='8661'DB:business_master_new
loadtime:0.59651303291321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.59658789634705 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='8661'DB:business_master_new
loadtime:0.65140104293823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.6514458656311 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='8661'DB:business_master_new
loadtime:0.66407203674316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.66413497924805 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='8661'DB:business_master_new
loadtime:0.66954398155212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.66960501670837 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='8661'DB:business_master_new
loadtime:0.67458200454712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.67462682723999 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='8661'DB:business_master_new
loadtime:0.68091988563538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.68097996711731 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='8661'DB:business_master_new
loadtime:0.68196988105774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.68200588226318 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='8661'DB:business_master_new
loadtime:0.73055601119995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.73061203956604 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='8661'DB:business_master_new
loadtime:0.73429083824158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.73433494567871 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='8661'DB:business_master_new
loadtime:0.83222699165344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.83228397369385 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='8661'DB:business_master_new
loadtime:0.83288884162903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.83292603492737 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='8661'DB:business_master_new
loadtime:0.85732889175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.85737085342407 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='8661'DB:business_master_new
loadtime:0.86355996131897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.8636200428009 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='8661'DB:business_master_new
loadtime:0.87582683563232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.87587690353394 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='8661'DB:business_master_new
loadtime:0.88122582435608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.88128399848938 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='8661'DB:business_master_new
loadtime:0.90324401855469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.90330386161804 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='8661'DB:business_master_new
loadtime:0.95234203338623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.95240092277527 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='8661'DB:business_master_new
loadtime:0.95589590072632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.95594000816345 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='8661'DB:business_master_new
loadtime:0.99511098861694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.99516582489014 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='8661'DB:business_master_new
loadtime:1.0198290348053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:1.0198848247528 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='8661'DB:business_master_new
loadtime:1.0307779312134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:1.0308330059052 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='8661'DB:business_master_new
loadtime:1.0381729602814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:1.0382490158081 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='8661'DB:business_master_new
loadtime:1.1188139915466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:1.1188609600067 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='8661'DB:business_master_new
loadtime:1.1331009864807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:1.1331579685211 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='8661'DB:business_master_new
loadtime:1.2141318321228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:1.2141790390015 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='8661'DB:business_master_new
loadtime:1.220018863678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:1.2200748920441 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='8661'DB:business_master_new
loadtime:1.2846939563751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:1.2848339080811 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='8661'DB:business_master_new
loadtime:1.3128278255463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:1.3128929138184 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='8661'DB:business_master_new
loadtime:1.4072308540344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:1.4072909355164 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='8661'DB:business_master_new
loadtime:1.4589688777924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:1.4590129852295 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='8661'DB:business_master_new
loadtime:1.5154139995575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:1.5154728889465 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='8661'DB:business_master_new
loadtime:1.516019821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:1.5160558223724 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='8661'DB:business_master_new
loadtime:1.5274589061737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:1.5275259017944 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='8661'DB:business_master_new
loadtime:1.5314178466797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:1.5314538478851 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='8661'DB:business_master_new
loadtime:1.5380439758301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:1.5381038188934 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='8661'DB:business_master_new
loadtime:1.5462648868561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:1.5463190078735 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='8661'DB:business_master_new
loadtime:1.5609970092773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:1.561094045639 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='8661'DB:business_master_new
loadtime:1.6223919391632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:1.6224508285522 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='8661'DB:business_master_new
loadtime:1.6468999385834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:1.6469869613647 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='8661'DB:business_master_new
loadtime:1.6737020015717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:1.6737668514252 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='8661'DB:business_master_new
loadtime:1.683109998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:1.6831669807434 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='8661'DB:business_master_new
loadtime:1.6873409748077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:1.6873888969421 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='8661'DB:business_master_new
loadtime:1.6877119541168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:1.6877470016479 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='8661'DB:business_master_new
loadtime:1.6919000148773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:1.6919460296631 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='8661'DB:business_master_new
loadtime:1.6974558830261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:1.6975100040436 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='8661'DB:business_master_new
loadtime:1.7036709785461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:1.7037210464478 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='8661'DB:business_master_new
loadtime:1.7077150344849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:1.7077748775482 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='8661'DB:business_master_new
loadtime:1.7332208156586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:1.7332668304443 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='8661'DB:business_master_new
loadtime:1.7708468437195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:1.7709679603577 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='8661'DB:business_master_new
loadtime:1.774356842041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:1.7744078636169 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='8661'DB:business_master_new
loadtime:1.8283069133759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:1.8283720016479 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='8661'DB:business_master_new
loadtime:1.8341310024261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:1.8343048095703 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='8661'DB:business_master_new
loadtime:1.8586668968201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:1.8587238788605 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='8661'DB:business_master_new
loadtime:1.8638849258423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:1.8640229701996 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='8661'DB:business_master_new
loadtime:1.8884959220886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:1.8885409832001 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='8661'DB:business_master_new
loadtime:1.8937380313873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:1.8938989639282 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='8661'DB:business_master_new
loadtime:1.9008538722992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:1.9009029865265 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='8661'DB:business_master_new
loadtime:1.9039669036865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:1.9040148258209 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='8661'DB:business_master_new
loadtime:1.905562877655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:1.905604839325 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='8661'DB:business_master_new
loadtime:1.9105069637299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.9105539321899 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='8661'DB:business_master_new
loadtime:1.9165990352631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:1.9166438579559 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='8661'DB:business_master_new
loadtime:1.9250810146332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:1.9251458644867 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='8661'DB:business_master_new
loadtime:1.9337899684906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:1.9339759349823 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='8661'DB:business_master_new
loadtime:1.9577088356018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:1.9577548503876 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='8661'DB:business_master_new
loadtime:1.9808268547058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.9808938503265 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='8661'DB:business_master_new
loadtime:1.9925808906555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.9926249980927 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:2.000314950943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:2.0003628730774 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='8661'DB:business_master_new
loadtime:2.0049068927765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:2.0049500465393 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='8661'DB:business_master_new
loadtime:2.0145888328552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:2.0146589279175 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='8661'DB:business_master_new
loadtime:2.0667798519135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:2.0668268203735 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='8661'DB:business_master_new
loadtime:2.0681619644165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:2.0682208538055 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='8661'DB:business_master_new
loadtime:2.0763649940491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:2.0764780044556 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='8661'DB:business_master_new
loadtime:2.0830459594727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:2.0831739902496 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='8661'DB:business_master_new
loadtime:2.0972418785095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:2.0972979068756 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='8661'DB:business_master_new
loadtime:2.1020908355713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:2.1021389961243 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='8661'DB:business_master_new
loadtime:2.1202390193939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:2.1202988624573 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='8661'DB:business_master_new
loadtime:2.155553817749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:2.1555979251862 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='8661'DB:business_master_new
loadtime:2.1596519947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:2.1597030162811 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='8661'DB:business_master_new
loadtime:2.1703870296478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:2.1704428195953 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='8661'DB:business_master_new
loadtime:2.1714389324188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:2.1714668273926 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='8661'DB:business_master_new
loadtime:2.1759068965912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:2.1760568618774 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='8661'DB:business_master_new
loadtime:2.1836948394775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:2.1837468147278 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='8661'DB:business_master_new
loadtime:2.1883978843689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:2.1884460449219 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='8661'DB:business_master_new
loadtime:2.1990549564362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:2.1991069316864 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='8661'DB:business_master_new
loadtime:2.2101068496704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:2.2101628780365 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='8661'DB:business_master_new
loadtime:2.2123110294342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:2.2123548984528 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='8661'DB:business_master_new
loadtime:2.2160909175873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:2.216148853302 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='8661'DB:business_master_new
loadtime:2.2353808879852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:2.2354378700256 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='8661'DB:business_master_new
loadtime:2.2653369903564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:2.2653868198395 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='8661'DB:business_master_new
loadtime:2.2846188545227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:2.284726858139 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='8661'DB:business_master_new
loadtime:2.2850339412689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:2.2850668430328 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='8661'DB:business_master_new
loadtime:2.2892489433289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:2.2893068790436 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='8661'DB:business_master_new
loadtime:2.3339669704437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:2.3340139389038 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='8661'DB:business_master_new
loadtime:2.3380470275879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:2.3381068706512 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='8661'DB:business_master_new
loadtime:2.3391180038452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:2.3391540050507 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='8661'DB:business_master_new
loadtime:2.3417890071869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:2.3418478965759 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='8661'DB:business_master_new
loadtime:2.3576838970184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:2.3577418327332 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='8661'DB:business_master_new
loadtime:2.3613078594208 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:2.3613569736481 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='8661'DB:business_master_new
loadtime:2.3616700172424 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:2.3617169857025 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='8661'DB:business_master_new
loadtime:2.3735778331757 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:2.3736200332642 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='8661'DB:business_master_new
loadtime:2.377053976059 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:2.377112865448 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='8661'DB:business_master_new
loadtime:2.3971438407898 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:2.3971898555756 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='8661'DB:business_master_new
loadtime:2.4061918258667 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:2.4062588214874 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='8661'DB:business_master_new
loadtime:2.4077949523926 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:2.407833814621 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='8661'DB:business_master_new
loadtime:2.410758972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:2.4108109474182 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='8661'DB:business_master_new
loadtime:2.4136798381805 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:2.4137389659882 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='8661'DB:business_master_new
loadtime:2.4192340373993 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:2.4192869663239 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='8661'DB:business_master_new
loadtime:2.4195969104767 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:2.4196469783783 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='8661'DB:business_master_new
loadtime:2.4369769096375 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:2.4370198249817 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='8661'DB:business_master_new
loadtime:2.4407420158386 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:2.4407889842987 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='8661'DB:business_master_new
loadtime:2.441113948822 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:2.4411499500275 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='8661'DB:business_master_new
loadtime:2.4433770179749 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:2.4434340000153 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='8661'DB:business_master_new
loadtime:2.4685199260712 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:2.4685709476471 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='8661'DB:business_master_new
loadtime:2.4749069213867 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:2.4750628471375 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='8661'DB:business_master_new
loadtime:2.5057590007782 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:2.5058178901672 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='8661'DB:business_master_new
loadtime:2.5479018688202 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:2.547947883606 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='8661'DB:business_master_new
loadtime:2.5519099235535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:2.5519700050354 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='8661'DB:business_master_new
loadtime:2.5544588565826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:2.5545048713684 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='8661'DB:business_master_new
loadtime:2.5573148727417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:2.5573749542236 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='8661'DB:business_master_new
loadtime:2.5634918212891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:2.5635349750519 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='8661'DB:business_master_new
loadtime:2.5676679611206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:2.5677268505096 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='8661'DB:business_master_new
loadtime:2.5682950019836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:2.5683498382568 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='8661'DB:business_master_new
loadtime:2.5725908279419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:2.572625875473 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='8661'DB:business_master_new
loadtime:2.5749449729919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:2.5750029087067 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='8661'DB:business_master_new
loadtime:2.5822749137878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:2.5823309421539 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='8661'DB:business_master_new
loadtime:2.5874669551849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:2.5875298976898 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='8661'DB:business_master_new
loadtime:2.6117088794708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:2.6117918491364 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='8661'DB:business_master_new
loadtime:2.6170558929443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:2.6171209812164 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='8661'DB:business_master_new
loadtime:2.6226069927216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:2.6226439476013 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='8661'DB:business_master_new
loadtime:2.6268398761749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:2.6268990039825 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='8661'DB:business_master_new
loadtime:2.6571140289307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:2.6571669578552 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='8661'DB:business_master_new
loadtime:2.6661469936371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:2.6662268638611 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='8661'DB:business_master_new
loadtime:2.6701250076294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:2.6701879501343 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='8661'DB:business_master_new
loadtime:2.6711549758911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:2.6711909770966 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='8661'DB:business_master_new
loadtime:2.6843988895416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:2.6844549179077 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='8661'DB:business_master_new
loadtime:2.6883800029755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:2.6884279251099 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='8661'DB:business_master_new
loadtime:2.6994519233704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.6995408535004 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='8661'DB:business_master_new
loadtime:2.7039020061493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:2.7039530277252 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='8661'DB:business_master_new
loadtime:2.7091069221497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:2.7091748714447 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='8661'DB:business_master_new
loadtime:2.7094688415527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:2.7095079421997 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='8661'DB:business_master_new
loadtime:2.7123119831085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:2.7123579978943 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='8661'DB:business_master_new
loadtime:2.717875957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:2.7179329395294 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='8661'DB:business_master_new
loadtime:2.7267248630524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:2.7267608642578 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='8661'DB:business_master_new
loadtime:2.7280960083008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:2.7281420230865 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='8661'DB:business_master_new
loadtime:2.7348489761353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:2.7349088191986 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='8661'DB:business_master_new
loadtime:2.7440638542175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:2.7441208362579 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='8661'DB:business_master_new
loadtime:2.748272895813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:2.7483170032501 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='8661'DB:business_master_new
loadtime:2.7523548603058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:2.7524449825287 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='8661'DB:business_master_new
loadtime:2.7642428874969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:2.764298915863 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='8661'DB:business_master_new
loadtime:2.7695260047913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:2.7695770263672 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='8661'DB:business_master_new
loadtime:2.7711498737335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:2.7712128162384 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='8661'DB:business_master_new
loadtime:2.7736639976501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:2.7736978530884 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='8661'DB:business_master_new
loadtime:2.7790489196777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:2.7791159152985 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='8661'DB:business_master_new
loadtime:2.7820258140564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:2.7820730209351 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='8661'DB:business_master_new
loadtime:2.808434009552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:2.8084950447083 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='8661'DB:business_master_new
loadtime:2.8113188743591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:2.8113758563995 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='8661'DB:business_master_new
loadtime:2.836149930954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:2.8361978530884 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='8661'DB:business_master_new
loadtime:2.8404569625854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:2.8405048847198 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='8661'DB:business_master_new
loadtime:2.8432259559631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:2.8432719707489 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='8661'DB:business_master_new
loadtime:2.8474099636078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:2.8474669456482 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='8661'DB:business_master_new
loadtime:2.8514528274536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:2.851557970047 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='8661'DB:business_master_new
loadtime:2.8542058467865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:2.8543388843536 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='8661'DB:business_master_new
loadtime:2.859699010849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:2.8598220348358 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='8661'DB:business_master_new
loadtime:2.8705158233643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:2.8706150054932 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='8661'DB:business_master_new
loadtime:2.8745098114014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:2.8746619224548 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='8661'DB:business_master_new
loadtime:2.8795049190521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:2.8796310424805 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='8661'DB:business_master_new
loadtime:2.9075798988342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:2.9076390266418 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='8661'DB:business_master_new
loadtime:2.9243619441986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:2.9244070053101 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='8661'DB:business_master_new
loadtime:2.9254348278046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:2.9254829883575 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='8661'DB:business_master_new
loadtime:2.9332749843597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:2.9333519935608 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='8661'DB:business_master_new
loadtime:2.9339380264282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:2.934072971344 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='8661'DB:business_master_new
loadtime:2.9474358558655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:2.9474878311157 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='8661'DB:business_master_new
loadtime:2.9495630264282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:2.9496159553528 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='8661'DB:business_master_new
loadtime:2.9564230442047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:2.9564909934998 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='8661'DB:business_master_new
loadtime:2.9643478393555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:2.9643919467926 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='8661'DB:business_master_new
loadtime:2.9669599533081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:2.9670178890228 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='8661'DB:business_master_new
loadtime:2.9703419208527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:2.9703919887543 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='8661'DB:business_master_new
loadtime:2.9776849746704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:2.9777598381042 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='8661'DB:business_master_new
loadtime:2.9807398319244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:2.9807829856873 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='8661'DB:business_master_new
loadtime:2.9903559684753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:2.9904420375824 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='8661'DB:business_master_new
loadtime:2.9922380447388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:2.9922850131989 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='8661'DB:business_master_new
loadtime:2.9959638118744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:2.9960260391235 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='8661'DB:business_master_new
loadtime:3.0020430088043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:3.0020990371704 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='8661'DB:business_master_new
loadtime:3.0150048732758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:3.0150489807129 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='8661'DB:business_master_new
loadtime:3.0175499916077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:3.0176010131836 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='8661'DB:business_master_new
loadtime:3.0212700366974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:3.0213189125061 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='8661'DB:business_master_new
loadtime:3.0219810009003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:3.0220439434052 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='8661'DB:business_master_new
loadtime:3.0339288711548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:3.0339748859406 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='8661'DB:business_master_new
loadtime:3.0392370223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:3.0392978191376 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='8661'DB:business_master_new
loadtime:3.0406968593597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:3.040736913681 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='8661'DB:business_master_new
loadtime:3.1176149845123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:3.1176998615265 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='8661'DB:business_master_new
loadtime:3.1388509273529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:3.1389198303223 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='8661'DB:business_master_new
loadtime:3.1537508964539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:3.1537978649139 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='8661'DB:business_master_new
loadtime:3.1615788936615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:3.1616530418396 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='8661'DB:business_master_new
loadtime:3.1703200340271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:3.17036485672 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='8661'DB:business_master_new
loadtime:3.1734888553619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:3.1735479831696 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='8661'DB:business_master_new
loadtime:3.1741459369659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:3.1741888523102 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='8661'DB:business_master_new
loadtime:3.1761219501495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:3.1761798858643 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='8661'DB:business_master_new
loadtime:3.1964519023895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:3.1965088844299 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='8661'DB:business_master_new
loadtime:3.2161068916321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:3.2161519527435 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='8661'DB:business_master_new
loadtime:3.2232530117035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:3.223347902298 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='8661'DB:business_master_new
loadtime:3.2261569499969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:3.2262079715729 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='8661'DB:business_master_new
loadtime:3.2317209243774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:3.2317769527435 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='8661'DB:business_master_new
loadtime:3.2345988750458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:3.2346458435059 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='8661'DB:business_master_new
loadtime:3.2374498844147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:3.2375078201294 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='8661'DB:business_master_new
loadtime:3.2394318580627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:3.2394688129425 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='8661'DB:business_master_new
loadtime:3.2432539463043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:3.2433228492737 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='8661'DB:business_master_new
loadtime:3.2586660385132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:3.2587289810181 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='8661'DB:business_master_new
loadtime:3.2634110450745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:3.2634599208832 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='8661'DB:business_master_new
loadtime:3.2639269828796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:3.263965845108 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='8661'DB:business_master_new
loadtime:3.2658479213715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:3.2658820152283 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='8661'DB:business_master_new
loadtime:3.2676529884338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:3.2677109241486 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='8661'DB:business_master_new
loadtime:3.2706959247589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:3.270742893219 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='8661'DB:business_master_new
loadtime:3.2730059623718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:3.2730679512024 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='8661'DB:business_master_new
loadtime:3.2808978557587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:3.2809808254242 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='8661'DB:business_master_new
loadtime:3.2836248874664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:3.2836828231812 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='8661'DB:business_master_new
loadtime:3.2855699062347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:3.2856168746948 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='8661'DB:business_master_new
loadtime:3.2925958633423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:3.2926709651947 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='8661'DB:business_master_new
loadtime:3.2952289581299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:3.2952890396118 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='8661'DB:business_master_new
loadtime:3.2992889881134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:3.2993478775024 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='8661'DB:business_master_new
loadtime:3.3002588748932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:3.3003158569336 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='8661'DB:business_master_new
loadtime:3.3028860092163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:3.3029298782349 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='8661'DB:business_master_new
loadtime:3.3091218471527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:3.309180021286 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='8661'DB:business_master_new
loadtime:3.3125579357147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:3.3126168251038 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='8661'DB:business_master_new
loadtime:3.31525182724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:3.3153388500214 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='8661'DB:business_master_new
loadtime:3.3172299861908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:3.3172829151154 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='8661'DB:business_master_new
loadtime:3.336856842041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:3.3369169235229 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='8661'DB:business_master_new
loadtime:3.340696811676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:3.3407590389252 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='8661'DB:business_master_new
loadtime:3.3419368267059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:3.3419849872589 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='8661'DB:business_master_new
loadtime:3.3438849449158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:3.3439338207245 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='8661'DB:business_master_new
loadtime:3.3469400405884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:3.3469858169556 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='8661'DB:business_master_new
loadtime:3.3506088256836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:3.3506789207458 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='8661'DB:business_master_new
loadtime:3.3525669574738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:3.3526139259338 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='8661'DB:business_master_new
loadtime:3.3552968502045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:3.3553459644318 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='8661'DB:business_master_new
loadtime:3.3573000431061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:3.3573570251465 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='8661'DB:business_master_new
loadtime:3.3617470264435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:3.3618049621582 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='8661'DB:business_master_new
loadtime:3.3638288974762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:3.3638808727264 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='8661'DB:business_master_new
loadtime:3.367800951004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:3.36785197258 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='8661'DB:business_master_new
loadtime:3.3706018924713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:3.370659828186 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='8661'DB:business_master_new
loadtime:3.3710408210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:3.3710768222809 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='8661'DB:business_master_new
loadtime:3.3849070072174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:3.3849649429321 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='8661'DB:business_master_new
loadtime:3.3954839706421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:3.395546913147 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='8661'DB:business_master_new
loadtime:3.3985710144043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:3.3986179828644 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='8661'DB:business_master_new
loadtime:3.4000680446625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:3.4001069068909 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='8661'DB:business_master_new
loadtime:3.4021878242493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:3.4022350311279 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='8661'DB:business_master_new
loadtime:3.4059720039368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:3.4060289859772 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='8661'DB:business_master_new
loadtime:3.4078578948975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:3.4078848361969 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='8661'DB:business_master_new
loadtime:3.410945892334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:3.4109959602356 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='8661'DB:business_master_new
loadtime:3.4125230312347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:3.4125559329987 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='8661'DB:business_master_new
loadtime:3.4145488739014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:3.4145908355713 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='8661'DB:business_master_new
loadtime:3.4205369949341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:3.4205830097198 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='8661'DB:business_master_new
loadtime:3.4234719276428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:3.4235169887543 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='8661'DB:business_master_new
loadtime:3.4238510131836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:3.4238958358765 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='8661'DB:business_master_new
loadtime:3.4241869449615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:3.4242248535156 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='8661'DB:business_master_new
loadtime:3.4245100021362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:3.4245438575745 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='8661'DB:business_master_new
loadtime:3.4254088401794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:3.4254369735718 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='8661'DB:business_master_new
loadtime:3.4281749725342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:3.4282488822937 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='8661'DB:business_master_new
loadtime:3.4349880218506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:3.4350368976593 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='8661'DB:business_master_new
loadtime:3.4375970363617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:3.4376509189606 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='8661'DB:business_master_new
loadtime:3.4379689693451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:3.4380140304565 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='8661'DB:business_master_new
loadtime:3.4399719238281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:3.4400069713593 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='8661'DB:business_master_new
loadtime:3.4417488574982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:3.4418070316315 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='8661'DB:business_master_new
loadtime:3.4441368579865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:3.4441869258881 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='8661'DB:business_master_new
loadtime:3.4483850002289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:3.4484558105469 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='8661'DB:business_master_new
loadtime:3.4515328407288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:3.4516069889069 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='8661'DB:business_master_new
loadtime:3.4540448188782 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:3.4541039466858 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='8661'DB:business_master_new
loadtime:3.4546928405762 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:3.4547328948975 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='8661'DB:business_master_new
loadtime:3.4619569778442 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:3.4620468616486 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='8661'DB:business_master_new
loadtime:3.4635388851166 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:3.4635870456696 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='8661'DB:business_master_new
loadtime:3.4647359848022 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:3.4647798538208 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='8661'DB:business_master_new
loadtime:3.4685800075531 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:3.4686329364777 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='8661'DB:business_master_new
loadtime:3.4690608978271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:3.4690909385681 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='8661'DB:business_master_new
loadtime:3.4785268306732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:3.4785759449005 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='8661'DB:business_master_new
loadtime:3.4813499450684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:3.4813938140869 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='8661'DB:business_master_new
loadtime:3.4846639633179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:3.4847228527069 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='8661'DB:business_master_new
loadtime:3.4876658916473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:3.4877169132233 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='8661'DB:business_master_new
loadtime:3.4896869659424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:3.4897308349609 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='8661'DB:business_master_new
loadtime:3.497939825058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:3.4979939460754 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='8661'DB:business_master_new
loadtime:3.4982838630676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:3.49831199646 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='8661'DB:business_master_new
loadtime:3.5001788139343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:3.5002529621124 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='8661'DB:business_master_new
loadtime:3.500519990921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:3.5005478858948 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='8661'DB:business_master_new
loadtime:3.5026779174805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:3.5027379989624 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='8661'DB:business_master_new
loadtime:3.5030829906464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:3.5031189918518 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='8661'DB:business_master_new
loadtime:3.5053880214691 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:3.5054450035095 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='8661'DB:business_master_new
loadtime:3.5085709095001 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:3.5086388587952 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='8661'DB:business_master_new
loadtime:3.509997844696 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:3.5100350379944 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='8661'DB:business_master_new
loadtime:3.5130279064178 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:3.5130879878998 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='8661'DB:business_master_new
loadtime:3.5160758495331 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:3.5161240100861 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='8661'DB:business_master_new
loadtime:3.5185189247131 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:3.5185749530792 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='8661'DB:business_master_new
loadtime:3.5302410125732 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:3.530287027359 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='8661'DB:business_master_new
loadtime:3.5305459499359 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:3.5306189060211 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='8661'DB:business_master_new
loadtime:3.5311980247498 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:3.5312440395355 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='8661'DB:business_master_new
loadtime:3.5323128700256 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:3.5323519706726 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='8661'DB:business_master_new
loadtime:3.5342299938202 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:3.5342788696289 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='8661'DB:business_master_new
loadtime:3.5368709564209 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:3.5369229316711 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='8661'DB:business_master_new
loadtime:3.5420949459076 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:3.542151927948 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='8661'DB:business_master_new
loadtime:3.5496218204498 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:3.5496618747711 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='8661'DB:business_master_new
loadtime:3.5516970157623 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:3.5517578125 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='8661'DB:business_master_new
loadtime:3.552316904068 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:3.5523598194122 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='8661'DB:business_master_new
loadtime:3.5541348457336 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:3.554191827774 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='8661'DB:business_master_new
loadtime:3.5566909313202 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:3.5567488670349 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='8661'DB:business_master_new
loadtime:3.557520866394 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:3.557562828064 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='8661'DB:business_master_new
loadtime:3.5578699111938 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:3.5579278469086 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='8661'DB:business_master_new
loadtime:3.5601408481598 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:3.5601828098297 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='8661'DB:business_master_new
loadtime:3.5605399608612 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:3.5605869293213 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='8661'DB:business_master_new
loadtime:3.5609028339386 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:3.5609378814697 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='8661'DB:business_master_new
loadtime:3.563001871109 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:3.5630609989166 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='8661'DB:business_master_new
loadtime:3.5635178089142 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:3.5635528564453 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='8661'DB:business_master_new
loadtime:3.5663208961487 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:3.566370010376 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='8661'DB:business_master_new
loadtime:3.5675218105316 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:3.5675790309906 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='8661'DB:business_master_new
loadtime:3.5678930282593 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:3.5679278373718 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='8661'DB:business_master_new
loadtime:3.5697538852692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:3.5698118209839 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='8661'DB:business_master_new
loadtime:3.5730228424072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:3.5730729103088 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='8661'DB:business_master_new
loadtime:3.5759289264679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:3.5760369300842 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='8661'DB:business_master_new
loadtime:3.5806539058685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:3.58069896698 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='8661'DB:business_master_new
loadtime:3.5829620361328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:3.5830209255219 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='8661'DB:business_master_new
loadtime:3.5858149528503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:3.5858938694 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='8661'DB:business_master_new
loadtime:3.587956905365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:3.5880148410797 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='8661'DB:business_master_new
loadtime:3.5916049480438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:3.5916709899902 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='8661'DB:business_master_new
loadtime:3.5924139022827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:3.5924499034882 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='8661'DB:business_master_new
loadtime:3.5943210124969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:3.594379901886 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='8661'DB:business_master_new
loadtime:3.5978808403015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:3.59792304039 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='8661'DB:business_master_new
loadtime:3.5982329845428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:3.5982780456543 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='8661'DB:business_master_new
loadtime:3.600250005722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:3.6002848148346 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='8661'DB:business_master_new
loadtime:3.6023938655853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:3.6024408340454 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='8661'DB:business_master_new
loadtime:3.6045129299164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:3.6045470237732 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='8661'DB:business_master_new
loadtime:3.6064448356628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:3.6064889431 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='8661'DB:business_master_new
loadtime:3.6100599765778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:3.6101009845734 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='8661'DB:business_master_new
loadtime:3.6128098964691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:3.6128568649292 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='8661'DB:business_master_new
loadtime:3.6152439117432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:3.6153240203857 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='8661'DB:business_master_new
loadtime:3.619964838028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:3.6199979782104 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='8661'DB:business_master_new
loadtime:3.6227819919586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:3.6228530406952 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='8661'DB:business_master_new
loadtime:3.6231648921967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:3.623193025589 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='8661'DB:business_master_new
loadtime:3.6255478858948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:3.6256058216095 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='8661'DB:business_master_new
loadtime:3.6279158592224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:3.6280000209808 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='8661'DB:business_master_new
loadtime:3.6288590431213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:3.6289069652557 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='8661'DB:business_master_new
loadtime:3.6303238868713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:3.6303839683533 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='8661'DB:business_master_new
loadtime:3.6313178539276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:3.6313478946686 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='8661'DB:business_master_new
loadtime:3.6316549777985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:3.6317009925842 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='8661'DB:business_master_new
loadtime:3.6358678340912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:3.6359858512878 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='8661'DB:business_master_new
loadtime:3.6374099254608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:3.6374640464783 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='8661'DB:business_master_new
loadtime:3.6393179893494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:3.6393618583679 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='8661'DB:business_master_new
loadtime:3.642333984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:3.6424088478088 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='8661'DB:business_master_new
loadtime:3.6465158462524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:3.6465728282928 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='8661'DB:business_master_new
loadtime:3.6501338481903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:3.6501779556274 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='8661'DB:business_master_new
loadtime:3.6507668495178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:3.6508138179779 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='8661'DB:business_master_new
loadtime:3.6543920040131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:3.6544358730316 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='8661'DB:business_master_new
loadtime:3.6564528942108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:3.6565089225769 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='8661'DB:business_master_new
loadtime:3.6603188514709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:3.6603939533234 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='8661'DB:business_master_new
loadtime:3.6625919342041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:3.6627190113068 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='8661'DB:business_master_new
loadtime:3.6648268699646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:3.6649148464203 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='8661'DB:business_master_new
loadtime:3.6657528877258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:3.6658048629761 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='8661'DB:business_master_new
loadtime:3.6683838367462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:3.6684470176697 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='8661'DB:business_master_new
loadtime:3.6689448356628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:3.6689898967743 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='8661'DB:business_master_new
loadtime:3.6709008216858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:3.6710028648376 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='8661'DB:business_master_new
loadtime:3.6733939647675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:3.6734449863434 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='8661'DB:business_master_new
loadtime:3.6763939857483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:3.6764509677887 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='8661'DB:business_master_new
loadtime:3.6774508953094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:3.6774959564209 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='8661'DB:business_master_new
loadtime:3.6809549331665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:3.6810119152069 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='8661'DB:business_master_new
loadtime:3.6833598613739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:3.6834089756012 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='8661'DB:business_master_new
loadtime:3.6853628158569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:3.6854250431061 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='8661'DB:business_master_new
loadtime:3.6876428127289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:3.6877110004425 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='8661'DB:business_master_new
loadtime:3.6882259845734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:3.6882629394531 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='8661'DB:business_master_new
loadtime:3.6904480457306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:3.690505027771 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='8661'DB:business_master_new
loadtime:3.693717956543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:3.693785905838 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='8661'DB:business_master_new
loadtime:3.6957068443298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:3.6957709789276 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='8661'DB:business_master_new
loadtime:3.6964030265808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:3.6964378356934 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='8661'DB:business_master_new
loadtime:3.6976149082184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:3.6976699829102 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='8661'DB:business_master_new
loadtime:3.6994669437408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:3.6995108127594 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='8661'DB:business_master_new
loadtime:3.7011549472809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:3.701201915741 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='8661'DB:business_master_new
loadtime:3.7036728858948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:3.7037279605865 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='8661'DB:business_master_new
loadtime:3.7064189910889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:3.7064759731293 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='8661'DB:business_master_new
loadtime:3.7083919048309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:3.7084519863129 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='8661'DB:business_master_new
loadtime:3.7087619304657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:3.7087979316711 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='8661'DB:business_master_new
loadtime:3.709410905838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:3.7094578742981 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='8661'DB:business_master_new
loadtime:3.7114479541779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:3.7114949226379 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='8661'DB:business_master_new
loadtime:3.713819026947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:3.7138829231262 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='8661'DB:business_master_new
loadtime:3.7145729064941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:3.7146298885345 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='8661'DB:business_master_new
loadtime:3.7167799472809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:3.7168219089508 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='8661'DB:business_master_new
loadtime:3.7188839912415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:3.7189338207245 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='8661'DB:business_master_new
loadtime:3.7210140228271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:3.7210650444031 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='8661'DB:business_master_new
loadtime:3.7229328155518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:3.7229928970337 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='8661'DB:business_master_new
loadtime:3.7248508930206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:3.7248959541321 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='8661'DB:business_master_new
loadtime:3.7256588935852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:3.7257168292999 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='8661'DB:business_master_new
loadtime:3.7287769317627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:3.7288219928741 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='8661'DB:business_master_new
loadtime:3.7316558361053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:3.731714963913 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='8661'DB:business_master_new
loadtime:3.7345080375671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:3.7346198558807 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='8661'DB:business_master_new
loadtime:3.7352528572083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:3.735289812088 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='8661'DB:business_master_new
loadtime:3.736526966095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:3.7365758419037 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='8661'DB:business_master_new
loadtime:3.7368278503418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:3.7368638515472 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='8661'DB:business_master_new
loadtime:3.7388038635254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:3.7388648986816 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='8661'DB:business_master_new
loadtime:3.7423980236053 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:3.7424619197845 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='8661'DB:business_master_new
loadtime:3.7431919574738 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:3.7432639598846 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='8661'DB:business_master_new
loadtime:3.7448298931122 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:3.7448759078979 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='8661'DB:business_master_new
loadtime:3.7453479766846 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:3.745386838913 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='8661'DB:business_master_new
loadtime:3.7462978363037 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:3.746356010437 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='8661'DB:business_master_new
loadtime:3.7466149330139 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:3.7466628551483 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='8661'DB:business_master_new
loadtime:3.7486970424652 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:3.7487568855286 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='8661'DB:business_master_new
loadtime:3.7506649494171 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:3.7507128715515 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='8661'DB:business_master_new
loadtime:3.7525639533997 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:3.7526209354401 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='8661'DB:business_master_new
loadtime:3.7546279430389 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:3.754674911499 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='8661'DB:business_master_new
loadtime:3.7553038597107 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:3.7553589344025 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='8661'DB:business_master_new
loadtime:3.7563288211823 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:3.7563738822937 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='8661'DB:business_master_new
loadtime:3.7590708732605 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:3.7591300010681 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='8661'DB:business_master_new
loadtime:3.7609338760376 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:3.760990858078 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='8661'DB:business_master_new
loadtime:3.7614090442657 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:3.7614378929138 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='8661'DB:business_master_new
loadtime:3.7632539272308 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:3.7633109092712 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='8661'DB:business_master_new
loadtime:3.7637298107147 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:3.7637729644775 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='8661'DB:business_master_new
loadtime:3.7646968364716 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:3.7647399902344 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='8661'DB:business_master_new
loadtime:3.7653298377991 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:3.765380859375 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='8661'DB:business_master_new
loadtime:3.7668018341064 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:3.7668490409851 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='8661'DB:business_master_new
loadtime:3.7688210010529 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:3.7688889503479 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='8661'DB:business_master_new
loadtime:3.7709169387817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:3.7709639072418 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='8661'DB:business_master_new
loadtime:3.7739148139954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:3.7739729881287 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='8661'DB:business_master_new
loadtime:3.7760219573975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:3.7760698795319 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='8661'DB:business_master_new
loadtime:3.7784390449524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:3.7785060405731 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='8661'DB:business_master_new
loadtime:3.7790298461914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:3.7790789604187 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='8661'DB:business_master_new
loadtime:3.7809569835663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:3.7810029983521 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='8661'DB:business_master_new
loadtime:3.7829258441925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:3.7829630374908 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='8661'DB:business_master_new
loadtime:3.7882509231567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:3.7884068489075 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='8661'DB:business_master_new
loadtime:3.7902808189392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:3.7903439998627 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='8661'DB:business_master_new
loadtime:3.7907559871674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:3.7907898426056 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='8661'DB:business_master_new
loadtime:3.7923378944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:3.7923939228058 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='8661'DB:business_master_new
loadtime:3.7945890426636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:3.7946808338165 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='8661'DB:business_master_new
loadtime:3.7970969676971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:3.7971608638763 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='8661'DB:business_master_new
loadtime:3.7989928722382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:3.7990398406982 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='8661'DB:business_master_new
loadtime:3.8009798526764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:3.8010790348053 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='8661'DB:business_master_new
loadtime:3.8032898902893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:3.8033390045166 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='8661'DB:business_master_new
loadtime:3.8047249317169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:3.8047819137573 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='8661'DB:business_master_new
loadtime:3.8067300319672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:3.8067820072174 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='8661'DB:business_master_new
loadtime:3.8087029457092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:3.8087408542633 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='8661'DB:business_master_new
loadtime:3.8108019828796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:3.8108630180359 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='8661'DB:business_master_new
loadtime:3.8135039806366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:3.8135628700256 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='8661'DB:business_master_new
loadtime:3.8138790130615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:3.8139288425446 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='8661'DB:business_master_new
loadtime:3.8157479763031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:3.8158090114594 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='8661'DB:business_master_new
loadtime:3.81804895401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:3.8180999755859 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='8661'DB:business_master_new
loadtime:3.8189070224762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:3.8189508914948 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='8661'DB:business_master_new
loadtime:3.8199229240417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:3.8199789524078 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='8661'DB:business_master_new
loadtime:3.8202660083771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:3.8203039169312 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='8661'DB:business_master_new
loadtime:3.8222348690033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:3.8222799301147 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='8661'DB:business_master_new
loadtime:3.8240518569946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:3.8241069316864 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='8661'DB:business_master_new
loadtime:3.8253529071808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:3.8253970146179 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='8661'DB:business_master_new
loadtime:3.8272349834442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:3.8272938728333 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='8661'DB:business_master_new
loadtime:3.8292529582977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:3.8292980194092 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='8661'DB:business_master_new
loadtime:3.8297648429871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:3.8298199176788 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='8661'DB:business_master_new
loadtime:3.8316519260406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:3.8317320346832 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='8661'DB:business_master_new
loadtime:3.8337149620056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:3.8337948322296 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='8661'DB:business_master_new
loadtime:3.834156036377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:3.8341989517212 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='8661'DB:business_master_new
loadtime:3.8362929821014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:3.8363409042358 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='8661'DB:business_master_new
loadtime:3.8366520404816 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:3.8367428779602 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:3.837103843689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:3.837131023407 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='8661'DB:business_master_new
loadtime:3.8388979434967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:3.8389928340912 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='8661'DB:business_master_new
loadtime:3.8414649963379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:3.8415179252625 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='8661'DB:business_master_new
loadtime:3.8422818183899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:3.842337846756 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='8661'DB:business_master_new
loadtime:3.8444499969482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:3.8445098400116 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='8661'DB:business_master_new
loadtime:3.8478088378906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:3.847883939743 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='8661'DB:business_master_new
loadtime:3.8481500148773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:3.8481788635254 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='8661'DB:business_master_new
loadtime:3.84845495224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:3.8484919071198 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='8661'DB:business_master_new
loadtime:3.8503968715668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:3.8504450321198 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='8661'DB:business_master_new
loadtime:3.8525099754333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:3.8525769710541 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='8661'DB:business_master_new
loadtime:3.8538699150085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:3.8539319038391 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='8661'DB:business_master_new
loadtime:3.8544549942017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:3.8544900417328 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='8661'DB:business_master_new
loadtime:3.8547840118408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:3.8548238277435 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='8661'DB:business_master_new
loadtime:3.8573198318481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:3.8573729991913 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='8661'DB:business_master_new
loadtime:3.8577258586884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:3.8577628135681 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='8661'DB:business_master_new
loadtime:3.8597550392151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:3.8598139286041 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='8661'DB:business_master_new
loadtime:3.8619248867035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:3.8619899749756 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='8661'DB:business_master_new
loadtime:3.8640599250793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:3.8641178607941 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='8661'DB:business_master_new
loadtime:3.8664038181305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:3.8664519786835 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='8661'DB:business_master_new
loadtime:3.8682749271393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:3.8683378696442 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='8661'DB:business_master_new
loadtime:3.8689088821411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:3.8689630031586 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='8661'DB:business_master_new
loadtime:3.8692739009857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:3.8693008422852 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='8661'DB:business_master_new
loadtime:3.8715488910675 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:3.8716039657593 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='8661'DB:business_master_new
loadtime:3.8733749389648 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:3.8734118938446 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='8661'DB:business_master_new
loadtime:3.8737440109253 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:3.8737800121307 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='8661'DB:business_master_new
loadtime:3.875766992569 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:3.875804901123 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='8661'DB:business_master_new
loadtime:3.8777668476105 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:3.8778269290924 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='8661'DB:business_master_new
loadtime:3.8795249462128 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:3.8795828819275 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='8661'DB:business_master_new
loadtime:3.8801708221436 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:3.880206823349 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='8661'DB:business_master_new
loadtime:3.8805680274963 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:3.8806149959564 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='8661'DB:business_master_new
loadtime:3.8809359073639 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:3.880970954895 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='8661'DB:business_master_new
loadtime:3.882513999939 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:3.8826069831848 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='8661'DB:business_master_new
loadtime:3.8833110332489 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:3.88338804245 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='8661'DB:business_master_new
loadtime:3.8838460445404 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:3.8839039802551 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='8661'DB:business_master_new
loadtime:3.8850829601288 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:3.8851408958435 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='8661'DB:business_master_new
loadtime:3.8859169483185 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:3.8859448432922 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='8661'DB:business_master_new
loadtime:3.8863348960876 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:3.8863730430603 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='8661'DB:business_master_new
loadtime:3.8866519927979 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:3.886677980423 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='8661'DB:business_master_new
loadtime:3.8869199752808 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:3.8869528770447 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='8661'DB:business_master_new
loadtime:3.888375043869 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:3.8884079456329 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='8661'DB:business_master_new
loadtime:3.8903968334198 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:3.8904588222504 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='8661'DB:business_master_new
loadtime:3.8925688266754 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:3.8926198482513 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='8661'DB:business_master_new
loadtime:3.8929350376129 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:3.8929839134216 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='8661'DB:business_master_new
loadtime:3.895674943924 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:3.8957488536835 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='8661'DB:business_master_new
loadtime:3.8966720104218 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:3.8967189788818 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='8661'DB:business_master_new
loadtime:3.8988308906555 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:3.8988878726959 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='8661'DB:business_master_new
loadtime:3.8997008800507 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:3.8997378349304 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='8661'DB:business_master_new
loadtime:3.9008188247681 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:3.9008898735046 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='8661'DB:business_master_new
loadtime:3.9015409946442 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:3.9015839099884 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='8661'DB:business_master_new
loadtime:3.9018609523773 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:3.9019010066986 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='8661'DB:business_master_new
loadtime:3.9037439823151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:3.9037868976593 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='8661'DB:business_master_new
loadtime:3.9065809249878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:3.9066429138184 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='8661'DB:business_master_new
loadtime:3.9092910289764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:3.9093630313873 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='8661'DB:business_master_new
loadtime:3.9116218090057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:3.9116749763489 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='8661'DB:business_master_new
loadtime:3.9120018482208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:3.912045955658 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='8661'DB:business_master_new
loadtime:3.9138929843903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:3.91392993927 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='8661'DB:business_master_new
loadtime:3.915843963623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:3.9158940315247 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='8661'DB:business_master_new
loadtime:3.9178609848022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:3.9178960323334 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='8661'DB:business_master_new
loadtime:3.9182658195496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:3.918301820755 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='8661'DB:business_master_new
loadtime:3.920294046402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:3.9203288555145 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='8661'DB:business_master_new
loadtime:3.9222419261932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:3.922287940979 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='8661'DB:business_master_new
loadtime:3.9230298995972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:3.9230690002441 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='8661'DB:business_master_new
loadtime:3.9233899116516 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:3.9234249591827 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='8661'DB:business_master_new
loadtime:3.9236898422241 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:3.9237248897552 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='8661'DB:business_master_new
loadtime:3.924036026001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:3.9240598678589 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='8661'DB:business_master_new
loadtime:3.9259819984436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:3.9260289669037 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='8661'DB:business_master_new
loadtime:3.9279129505157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:3.9279458522797 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='8661'DB:business_master_new
loadtime:3.9298889636993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:3.9299309253693 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='8661'DB:business_master_new
loadtime:3.9301888942719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:3.9302270412445 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='8661'DB:business_master_new
loadtime:3.9315629005432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:3.9316020011902 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='8661'DB:business_master_new
loadtime:3.9335198402405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:3.9335658550262 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='8661'DB:business_master_new
loadtime:3.9357509613037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:3.9357860088348 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='8661'DB:business_master_new
loadtime:3.9376149177551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:3.9376590251923 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='8661'DB:business_master_new
loadtime:3.9379138946533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:3.9379389286041 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='8661'DB:business_master_new
loadtime:3.9382719993591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:3.938304901123 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='8661'DB:business_master_new
loadtime:3.9404809474945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:3.9405169487 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='8661'DB:business_master_new
loadtime:3.9409899711609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:3.941025018692 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='8661'DB:business_master_new
loadtime:3.942981004715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:3.9430229663849 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='8661'DB:business_master_new
loadtime:3.9458868503571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:3.9459538459778 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='8661'DB:business_master_new
loadtime:3.946240901947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:3.9462690353394 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='8661'DB:business_master_new
loadtime:3.9473829269409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:3.9474408626556 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='8661'DB:business_master_new
loadtime:3.9478328227997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:3.9478759765625 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='8661'DB:business_master_new
loadtime:3.9543669223785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:3.9545300006866 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='8661'DB:business_master_new
loadtime:3.9548468589783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:3.9548988342285 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='8661'DB:business_master_new
loadtime:3.9556839466095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:3.9557440280914 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='8661'DB:business_master_new
loadtime:3.9578058719635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:3.957906961441 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='8661'DB:business_master_new
loadtime:3.9598410129547 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:3.9600009918213 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:3.9603159427643 / seconds
Operation template executed (chunk cache operation)
loadtime:3.9603958129883 / seconds
template override:Default
loadtime:3.9604148864746 / 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:3.961236000061 / seconds
Template Constructed, Array Rows:49
loadtime:3.9615139961243 / seconds
TOTAL EXECUTION TIME: 3.96128
loadtime:3.9617018699646 / 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] => religious-organizations [stateURLid] => massachusetts )


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