Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.1988830566406E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00042605400085449 / seconds
host not found setting manual db connection
loadtime:0.00088691711425781 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011060237884521 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012309551239014 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0012788772583008 / seconds
zipcode:
loadtime:0.0012948513031006 / seconds
Query Executed:select * from search_referrer where page_hash='9dd2e576f167e96387e7388145d7eb01' limit 10 DB:ezrox_toadli
loadtime:0.0014638900756836 / seconds
Operation header executed (non global)
loadtime:0.0014810562133789 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015108585357666 / seconds
Operation square executed (non global)
loadtime:0.0015249252319336 / seconds
Operation square_bottom executed (non global)
loadtime:0.0015368461608887 / seconds
Operation smallsquare executed (non global)
loadtime:0.0015480518341064 / seconds
Operation headeradright executed (non global)
loadtime:0.0015590190887451 / seconds
Operation google_analytics executed (non global)
loadtime:0.0015699863433838 / seconds
Operation topstories executed (non global)
loadtime:0.0015809535980225 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0015919208526611 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016028881072998 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018310546875 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0019750595092773 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0020129680633545 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0020709037780762 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0021049976348877 / seconds
Template key: archive_menu pushed
loadtime:0.0021100044250488 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0021209716796875 / seconds
Template key: get_gravatar pushed
loadtime:0.0021250247955322 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0021300315856934 / seconds
*10)-10)+1 | start:0
loadtime:0.0021519660949707 / seconds
Query loaded from cache:select * from categories where cat_URLid='child-day-care-services'
loadtime:0.0021839141845703 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.0022139549255371 / seconds
DB connected to localhost business_master_new
loadtime:0.0027658939361572 / seconds
Query Executed:select * from `ma_catmap` where sic='8351' order by city ascDB:business_master_new
loadtime:0.072077989578247 / seconds
Query stored in cache : _QUERY_www.toadli.com4c2bd20ec1d3a58e40e9690064ec8372
loadtime:0.073000907897949 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.073047876358032 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='8351'DB:business_master_new
loadtime:0.076169013977051 / seconds
Query stored in cache : _QUERY_www.toadli.comebf528c40e43866fc62668d6ad48c496
loadtime:0.076195001602173 / seconds
559 / 11
loadtime:0.076233863830566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.076283931732178 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='8351'DB:business_master_new
loadtime:0.082082986831665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.082144975662231 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='8351'DB:business_master_new
loadtime:0.086717844009399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.086767911911011 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='8351'DB:business_master_new
loadtime:0.091887950897217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.091943025588989 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='8351'DB:business_master_new
loadtime:0.095046043395996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.095175981521606 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='8351'DB:business_master_new
loadtime:0.098055839538574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.098145961761475 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='8351'DB:business_master_new
loadtime:0.1020359992981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.10209703445435 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='8351'DB:business_master_new
loadtime:0.10236287117004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.10239601135254 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='8351'DB:business_master_new
loadtime:0.1054379940033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.10559701919556 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='8351'DB:business_master_new
loadtime:0.1110098361969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.11106991767883 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='8351'DB:business_master_new
loadtime:0.11643695831299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.11649894714355 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='8351'DB:business_master_new
loadtime:0.12244391441345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.12249684333801 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='8351'DB:business_master_new
loadtime:0.12297987937927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.12301993370056 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='8351'DB:business_master_new
loadtime:0.1296648979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.1297299861908 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='8351'DB:business_master_new
loadtime:0.13090991973877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.13094592094421 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='8351'DB:business_master_new
loadtime:0.1312530040741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.13129591941833 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='8351'DB:business_master_new
loadtime:0.13354086875916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.13369488716125 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='8351'DB:business_master_new
loadtime:0.13547801971436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.13554000854492 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='8351'DB:business_master_new
loadtime:0.15953397750854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.15959000587463 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='8351'DB:business_master_new
loadtime:0.16399598121643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.16409397125244 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='8351'DB:business_master_new
loadtime:0.17016696929932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.17021894454956 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='8351'DB:business_master_new
loadtime:0.17162394523621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.17172598838806 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='8351'DB:business_master_new
loadtime:0.1749439239502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.17499685287476 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='8351'DB:business_master_new
loadtime:0.18367385864258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.18374490737915 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='8351'DB:business_master_new
loadtime:0.18492388725281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.18498206138611 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='8351'DB:business_master_new
loadtime:0.18901205062866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.18907785415649 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='8351'DB:business_master_new
loadtime:0.19166493415833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.19176697731018 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='8351'DB:business_master_new
loadtime:0.19413590431213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.19423604011536 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='8351'DB:business_master_new
loadtime:0.19694495201111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.19705104827881 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='8351'DB:business_master_new
loadtime:0.19868206977844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.1987190246582 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='8351'DB:business_master_new
loadtime:0.2444109916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.24446296691895 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='8351'DB:business_master_new
loadtime:0.2454879283905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.24552392959595 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='8351'DB:business_master_new
loadtime:0.24863600730896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.24869990348816 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='8351'DB:business_master_new
loadtime:0.24933791160583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.2493908405304 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='8351'DB:business_master_new
loadtime:0.28631401062012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.2863609790802 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='8351'DB:business_master_new
loadtime:0.29107284545898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.29117584228516 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='8351'DB:business_master_new
loadtime:0.29412889480591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.29423189163208 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='8351'DB:business_master_new
loadtime:0.29728603363037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.29738306999207 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='8351'DB:business_master_new
loadtime:0.30544686317444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.30551886558533 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='8351'DB:business_master_new
loadtime:0.30650186538696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.30655789375305 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='8351'DB:business_master_new
loadtime:0.30929589271545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.30934286117554 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='8351'DB:business_master_new
loadtime:0.37050294876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.37054586410522 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='8351'DB:business_master_new
loadtime:0.39649391174316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.39655303955078 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='8351'DB:business_master_new
loadtime:0.40270185470581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:0.40277004241943 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='8351'DB:business_master_new
loadtime:0.40699005126953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.4070508480072 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='8351'DB:business_master_new
loadtime:0.40878796577454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:0.4088568687439 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='8351'DB:business_master_new
loadtime:0.42227005958557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.42232799530029 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='8351'DB:business_master_new
loadtime:0.42379283905029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:0.42386603355408 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='8351'DB:business_master_new
loadtime:0.43097901344299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.4310359954834 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='8351'DB:business_master_new
loadtime:1.174968957901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:1.1751539707184 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='8351'DB:business_master_new
loadtime:1.1885259151459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:1.1885850429535 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='8351'DB:business_master_new
loadtime:1.1896958351135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:1.1897599697113 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='8351'DB:business_master_new
loadtime:1.1907858848572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:1.1908509731293 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='8351'DB:business_master_new
loadtime:1.1918330192566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:1.1918859481812 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='8351'DB:business_master_new
loadtime:1.1925630569458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:1.1926119327545 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='8351'DB:business_master_new
loadtime:1.1943910121918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:1.1944470405579 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='8351'DB:business_master_new
loadtime:1.1987769603729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:1.1988439559937 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='8351'DB:business_master_new
loadtime:1.2000050544739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:1.2000629901886 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='8351'DB:business_master_new
loadtime:1.2012760639191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:1.2013349533081 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='8351'DB:business_master_new
loadtime:1.2027740478516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:1.2028398513794 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='8351'DB:business_master_new
loadtime:1.203822851181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:1.2038848400116 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='8351'DB:business_master_new
loadtime:1.2060668468475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:1.2061400413513 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:1.2517499923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:1.2517938613892 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='8351'DB:business_master_new
loadtime:1.2537229061127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:1.2537820339203 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='8351'DB:business_master_new
loadtime:1.2574770450592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:1.2575309276581 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='8351'DB:business_master_new
loadtime:1.2578258514404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:1.2578608989716 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='8351'DB:business_master_new
loadtime:1.2626068592072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:1.2626578807831 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='8351'DB:business_master_new
loadtime:1.269012928009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:1.269063949585 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='8351'DB:business_master_new
loadtime:1.2707600593567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:1.2708339691162 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='8351'DB:business_master_new
loadtime:1.27201795578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:1.2720808982849 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='8351'DB:business_master_new
loadtime:1.3326089382172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:1.3326640129089 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='8351'DB:business_master_new
loadtime:1.3358459472656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:1.3359198570251 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='8351'DB:business_master_new
loadtime:1.3373458385468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:1.3374149799347 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='8351'DB:business_master_new
loadtime:1.3384749889374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:1.3385329246521 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='8351'DB:business_master_new
loadtime:1.3396768569946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:1.3397319316864 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='8351'DB:business_master_new
loadtime:1.3822958469391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:1.3824338912964 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='8351'DB:business_master_new
loadtime:1.3849530220032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:1.3850140571594 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='8351'DB:business_master_new
loadtime:1.4044299125671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:1.4044828414917 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='8351'DB:business_master_new
loadtime:1.4070608615875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:1.4071350097656 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='8351'DB:business_master_new
loadtime:1.4082639217377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:1.4083149433136 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='8351'DB:business_master_new
loadtime:1.4124639034271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:1.4125218391418 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='8351'DB:business_master_new
loadtime:1.4140188694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:1.4140620231628 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='8351'DB:business_master_new
loadtime:1.4174008369446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.4174380302429 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='8351'DB:business_master_new
loadtime:1.4185650348663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:1.4186170101166 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='8351'DB:business_master_new
loadtime:1.420156955719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:1.4202189445496 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='8351'DB:business_master_new
loadtime:1.4215829372406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:1.4216389656067 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='8351'DB:business_master_new
loadtime:1.4361410140991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:1.4361939430237 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='8351'DB:business_master_new
loadtime:1.4633929729462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.463455915451 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='8351'DB:business_master_new
loadtime:1.4750959873199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.4751439094543 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='8351'DB:business_master_new
loadtime:1.4814839363098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:1.4815449714661 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='8351'DB:business_master_new
loadtime:1.4838738441467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:1.4839189052582 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='8351'DB:business_master_new
loadtime:1.4869089126587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:1.4869809150696 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='8351'DB:business_master_new
loadtime:1.4887390136719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:1.4887809753418 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='8351'DB:business_master_new
loadtime:1.4905250072479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:1.490574836731 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='8351'DB:business_master_new
loadtime:1.4926679134369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:1.4927248954773 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='8351'DB:business_master_new
loadtime:1.4947910308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:1.494863986969 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='8351'DB:business_master_new
loadtime:1.5098469257355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:1.5099020004272 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='8351'DB:business_master_new
loadtime:1.5114419460297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:1.5114960670471 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='8351'DB:business_master_new
loadtime:1.5272438526154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:1.527281999588 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='8351'DB:business_master_new
loadtime:1.5282590389252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:1.5283110141754 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='8351'DB:business_master_new
loadtime:1.532026052475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:1.5320720672607 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='8351'DB:business_master_new
loadtime:1.542270898819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:1.5423200130463 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='8351'DB:business_master_new
loadtime:1.5439569950104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:1.5440080165863 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='8351'DB:business_master_new
loadtime:1.5450129508972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:1.5450739860535 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='8351'DB:business_master_new
loadtime:1.546648979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:1.5467090606689 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='8351'DB:business_master_new
loadtime:1.5521099567413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:1.5521688461304 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='8351'DB:business_master_new
loadtime:1.5536029338837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:1.5536530017853 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='8351'DB:business_master_new
loadtime:1.5638580322266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:1.563915014267 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='8351'DB:business_master_new
loadtime:1.5649590492249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:1.5650110244751 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='8351'DB:business_master_new
loadtime:1.5659959316254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:1.5660529136658 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='8351'DB:business_master_new
loadtime:1.5838668346405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:1.5839190483093 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='8351'DB:business_master_new
loadtime:1.5849080085754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:1.5849649906158 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='8351'DB:business_master_new
loadtime:1.586865901947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:1.5869438648224 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='8351'DB:business_master_new
loadtime:1.5880508422852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:1.588103055954 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='8351'DB:business_master_new
loadtime:1.589115858078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:1.5891718864441 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='8351'DB:business_master_new
loadtime:1.5902500152588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:1.5902960300446 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='8351'DB:business_master_new
loadtime:1.5917248725891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:1.5918049812317 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='8351'DB:business_master_new
loadtime:1.593024969101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:1.5930700302124 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='8351'DB:business_master_new
loadtime:1.5941560268402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:1.5942170619965 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='8351'DB:business_master_new
loadtime:1.6117570400238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:1.6118259429932 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='8351'DB:business_master_new
loadtime:1.6130349636078 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:1.6130740642548 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='8351'DB:business_master_new
loadtime:1.6133639812469 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:1.6134068965912 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='8351'DB:business_master_new
loadtime:1.6251628398895 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:1.6251938343048 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='8351'DB:business_master_new
loadtime:1.6263558864594 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:1.6264228820801 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:1.642961025238 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:1.6429970264435 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='8351'DB:business_master_new
loadtime:1.6536190509796 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:1.6536688804626 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='8351'DB:business_master_new
loadtime:1.6546878814697 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:1.6547298431396 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:1.655993938446 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:1.6560549736023 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='8351'DB:business_master_new
loadtime:1.6570720672607 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:1.6571290493011 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='8351'DB:business_master_new
loadtime:1.6584310531616 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:1.6584939956665 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='8351'DB:business_master_new
loadtime:1.6587529182434 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:1.6587870121002 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='8351'DB:business_master_new
loadtime:1.6680388450623 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:1.6680970191956 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='8351'DB:business_master_new
loadtime:1.6721670627594 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:1.6722118854523 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='8351'DB:business_master_new
loadtime:1.6724829673767 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:1.6725268363953 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='8351'DB:business_master_new
loadtime:1.6735599040985 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:1.6736040115356 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='8351'DB:business_master_new
loadtime:1.6745960712433 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:1.674654006958 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='8351'DB:business_master_new
loadtime:1.6795029640198 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:1.6795558929443 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='8351'DB:business_master_new
loadtime:1.6805949211121 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:1.6806509494781 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='8351'DB:business_master_new
loadtime:1.6816470623016 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:1.6817119121552 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:1.682904958725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:1.6829578876495 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='8351'DB:business_master_new
loadtime:1.683944940567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:1.6840059757233 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='8351'DB:business_master_new
loadtime:1.6852359771729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:1.6852939128876 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='8351'DB:business_master_new
loadtime:1.6908428668976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:1.6908938884735 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='8351'DB:business_master_new
loadtime:1.6920430660248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:1.6921000480652 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='8351'DB:business_master_new
loadtime:1.6929278373718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:1.692981004715 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='8351'DB:business_master_new
loadtime:1.6991329193115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:1.6991829872131 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='8351'DB:business_master_new
loadtime:1.7002260684967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:1.7002859115601 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='8351'DB:business_master_new
loadtime:1.7016930580139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:1.7017450332642 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='8351'DB:business_master_new
loadtime:1.7029440402985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:1.7030048370361 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='8351'DB:business_master_new
loadtime:1.7051949501038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:1.705265045166 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:1.7066040039062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:1.7066650390625 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='8351'DB:business_master_new
loadtime:1.7111809253693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:1.7112329006195 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='8351'DB:business_master_new
loadtime:1.7123429775238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:1.7124049663544 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='8351'DB:business_master_new
loadtime:1.7134239673615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:1.7134828567505 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='8351'DB:business_master_new
loadtime:1.7151069641113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.7151908874512 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='8351'DB:business_master_new
loadtime:1.7163078784943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:1.716372013092 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='8351'DB:business_master_new
loadtime:1.7174718379974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:1.7175149917603 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='8351'DB:business_master_new
loadtime:1.7318260669708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:1.7318749427795 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='8351'DB:business_master_new
loadtime:1.7331609725952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:1.7332229614258 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='8351'DB:business_master_new
loadtime:1.7355208396912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.7355909347534 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='8351'DB:business_master_new
loadtime:1.7370178699493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:1.7370839118958 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='8351'DB:business_master_new
loadtime:1.7383089065552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:1.7383549213409 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='8351'DB:business_master_new
loadtime:1.7391698360443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:1.7392108440399 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='8351'DB:business_master_new
loadtime:1.7407319545746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:1.7407908439636 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='8351'DB:business_master_new
loadtime:1.7492969036102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:1.7493460178375 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='8351'DB:business_master_new
loadtime:1.7580900192261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:1.7581520080566 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='8351'DB:business_master_new
loadtime:1.7595388889313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:1.7595808506012 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='8351'DB:business_master_new
loadtime:1.7611720561981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:1.7612309455872 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='8351'DB:business_master_new
loadtime:1.7660059928894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:1.7660448551178 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='8351'DB:business_master_new
loadtime:1.7671279907227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:1.7671740055084 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='8351'DB:business_master_new
loadtime:1.7682168483734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:1.7682628631592 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='8351'DB:business_master_new
loadtime:1.7836010456085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:1.7836439609528 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='8351'DB:business_master_new
loadtime:1.7849369049072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:1.7849760055542 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='8351'DB:business_master_new
loadtime:1.7884068489075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.7884459495544 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='8351'DB:business_master_new
loadtime:1.7897229194641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:1.7897629737854 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='8351'DB:business_master_new
loadtime:1.7911269664764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:1.7911739349365 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='8351'DB:business_master_new
loadtime:1.7922699451447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:1.7923190593719 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='8351'DB:business_master_new
loadtime:1.7933158874512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:1.7933578491211 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='8351'DB:business_master_new
loadtime:1.7944009304047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:1.7944378852844 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='8351'DB:business_master_new
loadtime:1.7954578399658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.7955029010773 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='8351'DB:business_master_new
loadtime:1.8022449016571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:1.8022818565369 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='8351'DB:business_master_new
loadtime:1.8032460212708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.8032920360565 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='8351'DB:business_master_new
loadtime:1.8073010444641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.8073589801788 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='8351'DB:business_master_new
loadtime:1.8087298870087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:1.8087909221649 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='8351'DB:business_master_new
loadtime:1.8137359619141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:1.8137879371643 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='8351'DB:business_master_new
loadtime:1.815731048584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:1.8159379959106 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='8351'DB:business_master_new
loadtime:1.8236470222473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:1.823704957962 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='8351'DB:business_master_new
loadtime:1.824765920639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:1.8248360157013 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='8351'DB:business_master_new
loadtime:1.8263468742371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:1.8263919353485 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='8351'DB:business_master_new
loadtime:1.8282599449158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:1.8284258842468 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='8351'DB:business_master_new
loadtime:1.8526089191437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:1.8526680469513 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='8351'DB:business_master_new
loadtime:1.8535499572754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:1.8536088466644 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='8351'DB:business_master_new
loadtime:1.8554918766022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:1.855565071106 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='8351'DB:business_master_new
loadtime:1.8562660217285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:1.8563189506531 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='8351'DB:business_master_new
loadtime:1.8685200214386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:1.8685748577118 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='8351'DB:business_master_new
loadtime:1.8722238540649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:1.8722808361053 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='8351'DB:business_master_new
loadtime:1.8745920658112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:1.8746528625488 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='8351'DB:business_master_new
loadtime:1.8950629234314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:1.8951148986816 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='8351'DB:business_master_new
loadtime:1.8968708515167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:1.896931886673 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='8351'DB:business_master_new
loadtime:1.898421049118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.8984789848328 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='8351'DB:business_master_new
loadtime:1.907320022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:1.9073839187622 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='8351'DB:business_master_new
loadtime:1.9094409942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:1.9094989299774 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='8351'DB:business_master_new
loadtime:1.912337064743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:1.9124040603638 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='8351'DB:business_master_new
loadtime:1.9140589237213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.9141218662262 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='8351'DB:business_master_new
loadtime:1.9161870479584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:1.9162368774414 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='8351'DB:business_master_new
loadtime:1.9326908588409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.9327428340912 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='8351'DB:business_master_new
loadtime:1.9337298870087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.9337658882141 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='8351'DB:business_master_new
loadtime:1.9350688457489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:1.9351298809052 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='8351'DB:business_master_new
loadtime:1.936215877533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:1.9362709522247 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='8351'DB:business_master_new
loadtime:1.9383919239044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:1.938441991806 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='8351'DB:business_master_new
loadtime:1.9625618457794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:1.9626128673553 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='8351'DB:business_master_new
loadtime:1.9643740653992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:1.9644370079041 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='8351'DB:business_master_new
loadtime:1.9668538570404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:1.9669060707092 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='8351'DB:business_master_new
loadtime:1.9682269096375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:1.9682879447937 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='8351'DB:business_master_new
loadtime:1.9693870544434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:1.9694330692291 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='8351'DB:business_master_new
loadtime:1.9706439971924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:1.9707028865814 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='8351'DB:business_master_new
loadtime:1.9722058773041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.9722678661346 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='8351'DB:business_master_new
loadtime:1.9834320545197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.9834899902344 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='8351'DB:business_master_new
loadtime:1.9847369194031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:1.9848110675812 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='8351'DB:business_master_new
loadtime:1.9851739406586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.9852230548859 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='8351'DB:business_master_new
loadtime:1.9868290424347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.9868879318237 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='8351'DB:business_master_new
loadtime:1.9882960319519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:1.988352060318 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='8351'DB:business_master_new
loadtime:1.9897220134735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.9897730350494 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='8351'DB:business_master_new
loadtime:1.9925730228424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:1.9926390647888 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='8351'DB:business_master_new
loadtime:1.9941799640656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:1.9942419528961 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='8351'DB:business_master_new
loadtime:2.0088770389557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:2.0089359283447 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='8351'DB:business_master_new
loadtime:2.010027885437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:2.0100929737091 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='8351'DB:business_master_new
loadtime:2.0111989974976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:2.0112500190735 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='8351'DB:business_master_new
loadtime:2.0156848430634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:2.0157380104065 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='8351'DB:business_master_new
loadtime:2.0174589157104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:2.0175189971924 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='8351'DB:business_master_new
loadtime:2.027713060379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:2.0277719497681 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='8351'DB:business_master_new
loadtime:2.0293910503387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:2.0294580459595 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='8351'DB:business_master_new
loadtime:2.029935836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:2.0299758911133 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='8351'DB:business_master_new
loadtime:2.0310208797455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:2.0310778617859 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='8351'DB:business_master_new
loadtime:2.0369589328766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:2.0370180606842 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='8351'DB:business_master_new
loadtime:2.03817486763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:2.038468837738 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='8351'DB:business_master_new
loadtime:2.0396449565887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:2.0397038459778 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='8351'DB:business_master_new
loadtime:2.0418560504913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:2.0419199466705 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='8351'DB:business_master_new
loadtime:2.0431768894196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:2.0432369709015 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='8351'DB:business_master_new
loadtime:2.0443558692932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:2.0444149971008 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='8351'DB:business_master_new
loadtime:2.0463039875031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:2.0463669300079 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='8351'DB:business_master_new
loadtime:2.0475308895111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:2.0475919246674 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='8351'DB:business_master_new
loadtime:2.0492780208588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:2.0493428707123 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='8351'DB:business_master_new
loadtime:2.0518388748169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:2.0518898963928 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='8351'DB:business_master_new
loadtime:2.0529079437256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:2.0529508590698 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='8351'DB:business_master_new
loadtime:2.0612699985504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:2.0613238811493 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='8351'DB:business_master_new
loadtime:2.0626699924469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:2.0627360343933 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='8351'DB:business_master_new
loadtime:2.0641820430756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:2.0642459392548 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='8351'DB:business_master_new
loadtime:2.0652978420258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:2.0653560161591 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='8351'DB:business_master_new
loadtime:2.0670809745789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:2.0671579837799 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='8351'DB:business_master_new
loadtime:2.0685060024261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:2.0685608386993 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='8351'DB:business_master_new
loadtime:2.0713620185852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:2.0714130401611 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='8351'DB:business_master_new
loadtime:2.0725409984589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:2.0725939273834 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='8351'DB:business_master_new
loadtime:2.0738348960876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:2.0738959312439 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='8351'DB:business_master_new
loadtime:2.0751039981842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:2.0751779079437 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='8351'DB:business_master_new
loadtime:2.0762670040131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:2.0763249397278 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='8351'DB:business_master_new
loadtime:2.0774328708649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:2.0774838924408 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='8351'DB:business_master_new
loadtime:2.0786519050598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:2.0787129402161 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='8351'DB:business_master_new
loadtime:2.0804588794708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:2.0805289745331 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='8351'DB:business_master_new
loadtime:2.081670999527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:2.0817308425903 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='8351'DB:business_master_new
loadtime:2.0830500125885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:2.0831320285797 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='8351'DB:business_master_new
loadtime:2.0841529369354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:2.0841970443726 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='8351'DB:business_master_new
loadtime:2.0855860710144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:2.0856380462646 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='8351'DB:business_master_new
loadtime:2.0866439342499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:2.0867080688477 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='8351'DB:business_master_new
loadtime:2.0882868766785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:2.0883450508118 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='8351'DB:business_master_new
loadtime:2.0896370410919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:2.0897099971771 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='8351'DB:business_master_new
loadtime:2.0926508903503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:2.092700958252 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='8351'DB:business_master_new
loadtime:2.09383893013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:2.0938999652863 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='8351'DB:business_master_new
loadtime:2.0954329967499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:2.0954918861389 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='8351'DB:business_master_new
loadtime:2.0989038944244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:2.0989580154419 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='8351'DB:business_master_new
loadtime:2.1001510620117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:2.1002099514008 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='8351'DB:business_master_new
loadtime:2.1064269542694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:2.1064698696136 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='8351'DB:business_master_new
loadtime:2.1075880527496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:2.1076438426971 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='8351'DB:business_master_new
loadtime:2.1166410446167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:2.1166920661926 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='8351'DB:business_master_new
loadtime:2.1179850101471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:2.1180498600006 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='8351'DB:business_master_new
loadtime:2.119518995285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:2.1195559501648 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='8351'DB:business_master_new
loadtime:2.1198389530182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:2.1198830604553 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='8351'DB:business_master_new
loadtime:2.1201529502869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:2.1201798915863 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='8351'DB:business_master_new
loadtime:2.1216728687286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:2.1217238903046 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='8351'DB:business_master_new
loadtime:2.1228139400482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:2.1228659152985 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='8351'DB:business_master_new
loadtime:2.1527609825134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:2.1528348922729 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='8351'DB:business_master_new
loadtime:2.1574308872223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:2.1574690341949 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='8351'DB:business_master_new
loadtime:2.1581609249115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:2.1582078933716 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.1634700298309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:2.163519859314 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='8351'DB:business_master_new
loadtime:2.1645150184631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:2.1645669937134 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='8351'DB:business_master_new
loadtime:2.1660490036011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:2.1661159992218 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='8351'DB:business_master_new
loadtime:2.167858839035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:2.1679110527039 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='8351'DB:business_master_new
loadtime:2.1692669391632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:2.1693329811096 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='8351'DB:business_master_new
loadtime:2.1706409454346 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:2.1706938743591 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='8351'DB:business_master_new
loadtime:2.1713750362396 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:2.1714279651642 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='8351'DB:business_master_new
loadtime:2.1737530231476 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:2.1738450527191 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='8351'DB:business_master_new
loadtime:2.1836960315704 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:2.1837480068207 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='8351'DB:business_master_new
loadtime:2.1850910186768 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:2.1851449012756 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='8351'DB:business_master_new
loadtime:2.189444065094 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:2.1894810199738 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='8351'DB:business_master_new
loadtime:2.1919548511505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:2.1920030117035 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='8351'DB:business_master_new
loadtime:2.192981004715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:2.1930389404297 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='8351'DB:business_master_new
loadtime:2.194550037384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:2.1946098804474 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='8351'DB:business_master_new
loadtime:2.1959960460663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:2.1960489749908 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='8351'DB:business_master_new
loadtime:2.1974859237671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:2.197548866272 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='8351'DB:business_master_new
loadtime:2.1998670101166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:2.199914932251 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='8351'DB:business_master_new
loadtime:2.2018558979034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:2.2019150257111 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='8351'DB:business_master_new
loadtime:2.2021968364716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:2.2022318840027 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='8351'DB:business_master_new
loadtime:2.2038779258728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:2.2039420604706 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='8351'DB:business_master_new
loadtime:2.2042238712311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:2.2042648792267 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='8351'DB:business_master_new
loadtime:2.205983877182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:2.2060489654541 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='8351'DB:business_master_new
loadtime:2.2063679695129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:2.2064259052277 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='8351'DB:business_master_new
loadtime:2.208135843277 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:2.2081859111786 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='8351'DB:business_master_new
loadtime:2.210343837738 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:2.2104070186615 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='8351'DB:business_master_new
loadtime:2.2136600017548 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:2.2136969566345 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='8351'DB:business_master_new
loadtime:2.2151620388031 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:2.2152218818665 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='8351'DB:business_master_new
loadtime:2.217649936676 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:2.2177050113678 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='8351'DB:business_master_new
loadtime:2.2200589179993 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:2.2201218605042 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:2.2218780517578 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:2.2219369411469 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='8351'DB:business_master_new
loadtime:2.2221848964691 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:2.2222168445587 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='8351'DB:business_master_new
loadtime:2.2235050201416 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:2.2235629558563 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='8351'DB:business_master_new
loadtime:2.233500957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:2.2335519790649 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='8351'DB:business_master_new
loadtime:2.2357740402222 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:2.2358498573303 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.2384009361267 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:2.238450050354 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='8351'DB:business_master_new
loadtime:2.2540500164032 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:2.2541029453278 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='8351'DB:business_master_new
loadtime:2.2688510417938 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:2.2688870429993 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='8351'DB:business_master_new
loadtime:2.2700159549713 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:2.2700779438019 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='8351'DB:business_master_new
loadtime:2.2713358402252 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:2.2713730335236 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.2724049091339 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:2.2724640369415 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='8351'DB:business_master_new
loadtime:2.2735300064087 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:2.2735829353333 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='8351'DB:business_master_new
loadtime:2.2751560211182 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:2.2752048969269 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='8351'DB:business_master_new
loadtime:2.2760000228882 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:2.2760510444641 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='8351'DB:business_master_new
loadtime:2.2769780158997 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:2.2770228385925 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='8351'DB:business_master_new
loadtime:2.2789549827576 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:2.2790069580078 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='8351'DB:business_master_new
loadtime:2.2800049781799 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:2.2800409793854 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='8351'DB:business_master_new
loadtime:2.2812860012054 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:2.281347990036 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='8351'DB:business_master_new
loadtime:2.282516002655 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:2.2825639247894 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='8351'DB:business_master_new
loadtime:2.2937309741974 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:2.2937848567963 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.2972538471222 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:2.2972919940948 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='8351'DB:business_master_new
loadtime:2.2977910041809 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:2.2978549003601 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.2988698482513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:2.2989208698273 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='8351'DB:business_master_new
loadtime:2.3005020618439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:2.3005559444427 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='8351'DB:business_master_new
loadtime:2.3019659519196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:2.3020348548889 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.3030209541321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:2.3030769824982 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='8351'DB:business_master_new
loadtime:2.3185498714447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:2.3185830116272 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='8351'DB:business_master_new
loadtime:2.3198080062866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:2.3198750019073 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='8351'DB:business_master_new
loadtime:2.3211150169373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:2.3211688995361 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='8351'DB:business_master_new
loadtime:2.3227679729462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:2.322830915451 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='8351'DB:business_master_new
loadtime:2.3239719867706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:2.3240399360657 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='8351'DB:business_master_new
loadtime:2.3251399993896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:2.3251929283142 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='8351'DB:business_master_new
loadtime:2.3390679359436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:2.3391108512878 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='8351'DB:business_master_new
loadtime:2.3395700454712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:2.3396129608154 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='8351'DB:business_master_new
loadtime:2.3527488708496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:2.3528108596802 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='8351'DB:business_master_new
loadtime:2.3539009094238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:2.3539519309998 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='8351'DB:business_master_new
loadtime:2.3552100658417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:2.3552520275116 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='8351'DB:business_master_new
loadtime:2.3570649623871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:2.3571400642395 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='8351'DB:business_master_new
loadtime:2.3631410598755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:2.3631868362427 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='8351'DB:business_master_new
loadtime:2.3649840354919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:2.3650579452515 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='8351'DB:business_master_new
loadtime:2.3670170307159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:2.3670899868011 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='8351'DB:business_master_new
loadtime:2.3687469959259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:2.3688418865204 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='8351'DB:business_master_new
loadtime:2.3717749118805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:2.3718700408936 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='8351'DB:business_master_new
loadtime:2.3735439777374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:2.3735809326172 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='8351'DB:business_master_new
loadtime:2.376592874527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:2.3766720294952 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='8351'DB:business_master_new
loadtime:2.3792650699615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:2.379369020462 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='8351'DB:business_master_new
loadtime:2.3808460235596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:2.3808979988098 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='8351'DB:business_master_new
loadtime:2.39097905159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:2.3910210132599 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='8351'DB:business_master_new
loadtime:2.3923509120941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:2.3924059867859 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='8351'DB:business_master_new
loadtime:2.393413066864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:2.393462896347 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='8351'DB:business_master_new
loadtime:2.3955929279327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:2.3956890106201 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='8351'DB:business_master_new
loadtime:2.3990800380707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:2.3991429805756 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='8351'DB:business_master_new
loadtime:2.4002549648285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:2.4003150463104 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.4022278785706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:2.4022960662842 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='8351'DB:business_master_new
loadtime:2.4032649993896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:2.4033169746399 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='8351'DB:business_master_new
loadtime:2.4043140411377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:2.4043729305267 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='8351'DB:business_master_new
loadtime:2.4067070484161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:2.4067540168762 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='8351'DB:business_master_new
loadtime:2.4087028503418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:2.4087910652161 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='8351'DB:business_master_new
loadtime:2.4112989902496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:2.4113528728485 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='8351'DB:business_master_new
loadtime:2.4166948795319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:2.4168329238892 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='8351'DB:business_master_new
loadtime:2.4198639392853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:2.4199779033661 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='8351'DB:business_master_new
loadtime:2.4229369163513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:2.4230198860168 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='8351'DB:business_master_new
loadtime:2.425253868103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:2.4253058433533 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='8351'DB:business_master_new
loadtime:2.4266278743744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:2.4266910552979 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='8351'DB:business_master_new
loadtime:2.4284248352051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:2.4284670352936 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='8351'DB:business_master_new
loadtime:2.4295818805695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:2.4296450614929 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='8351'DB:business_master_new
loadtime:2.43110704422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:2.4311800003052 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='8351'DB:business_master_new
loadtime:2.4439208507538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:2.4439759254456 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='8351'DB:business_master_new
loadtime:2.4515089988708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.4515650272369 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='8351'DB:business_master_new
loadtime:2.4526059627533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.4526648521423 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='8351'DB:business_master_new
loadtime:2.4538910388947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:2.4539499282837 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='8351'DB:business_master_new
loadtime:2.455039024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:2.4551010131836 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='8351'DB:business_master_new
loadtime:2.4564728736877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:2.4565260410309 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='8351'DB:business_master_new
loadtime:2.4594068527222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:2.4594569206238 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='8351'DB:business_master_new
loadtime:2.4605259895325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:2.4605839252472 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='8351'DB:business_master_new
loadtime:2.4618878364563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:2.4619560241699 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='8351'DB:business_master_new
loadtime:2.4630060195923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:2.4630529880524 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='8351'DB:business_master_new
loadtime:2.4686779975891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:2.4687309265137 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='8351'DB:business_master_new
loadtime:2.4751958847046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:2.4752459526062 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='8351'DB:business_master_new
loadtime:2.4762790203094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:2.4763369560242 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='8351'DB:business_master_new
loadtime:2.4834868907928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:2.4835238456726 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.4845209121704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.4845759868622 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='8351'DB:business_master_new
loadtime:2.4862880706787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:2.4863529205322 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='8351'DB:business_master_new
loadtime:2.48752784729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:2.4875888824463 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.4878768920898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:2.487920999527 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='8351'DB:business_master_new
loadtime:2.4939348697662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:2.4939880371094 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='8351'DB:business_master_new
loadtime:2.495197057724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:2.4952490329742 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='8351'DB:business_master_new
loadtime:2.4966058731079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:2.4966669082642 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='8351'DB:business_master_new
loadtime:2.4987268447876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:2.4987900257111 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='8351'DB:business_master_new
loadtime:2.5000140666962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:2.5000610351562 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='8351'DB:business_master_new
loadtime:2.5013308525085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.5013830661774 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='8351'DB:business_master_new
loadtime:2.5025880336761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:2.5026428699493 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='8351'DB:business_master_new
loadtime:2.5036380290985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:2.5036828517914 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='8351'DB:business_master_new
loadtime:2.5046908855438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:2.5047240257263 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='8351'DB:business_master_new
loadtime:2.5062530040741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:2.5062968730927 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='8351'DB:business_master_new
loadtime:2.5072810649872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:2.5073289871216 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='8351'DB:business_master_new
loadtime:2.5083320140839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:2.5083630084991 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='8351'DB:business_master_new
loadtime:2.5098578929901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:2.5099070072174 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='8351'DB:business_master_new
loadtime:2.514860868454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:2.514899969101 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='8351'DB:business_master_new
loadtime:2.5178308486938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:2.5178580284119 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.5181038379669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.5181379318237 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='8351'DB:business_master_new
loadtime:2.5192520618439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:2.5192959308624 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='8351'DB:business_master_new
loadtime:2.5211079120636 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:2.521143913269 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='8351'DB:business_master_new
loadtime:2.523913860321 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:2.523952960968 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='8351'DB:business_master_new
loadtime:2.5264759063721 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:2.5264999866486 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='8351'DB:business_master_new
loadtime:2.5303280353546 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:2.530375957489 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='8351'DB:business_master_new
loadtime:2.5587210655212 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:2.558758020401 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='8351'DB:business_master_new
loadtime:2.559054851532 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:2.5590989589691 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.5602428913116 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:2.5603039264679 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='8351'DB:business_master_new
loadtime:2.5613179206848 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:2.5613708496094 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='8351'DB:business_master_new
loadtime:2.5624530315399 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:2.5625128746033 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='8351'DB:business_master_new
loadtime:2.563688993454 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:2.5637340545654 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='8351'DB:business_master_new
loadtime:2.5700259208679 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:2.5700759887695 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='8351'DB:business_master_new
loadtime:2.5785639286041 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:2.5785999298096 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='8351'DB:business_master_new
loadtime:2.5803909301758 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:2.5804870128632 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='8351'DB:business_master_new
loadtime:2.5823030471802 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:2.5823650360107 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='8351'DB:business_master_new
loadtime:2.5842878818512 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:2.5843348503113 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='8351'DB:business_master_new
loadtime:2.5993268489838 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:2.5994119644165 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='8351'DB:business_master_new
loadtime:2.6010808944702 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:2.6011250019073 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='8351'DB:business_master_new
loadtime:2.603903055191 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:2.6039559841156 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='8351'DB:business_master_new
loadtime:2.606183052063 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:2.606260061264 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='8351'DB:business_master_new
loadtime:2.6086509227753 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:2.6087009906769 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.6099729537964 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:2.6100289821625 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.6112380027771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:2.611300945282 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='8351'DB:business_master_new
loadtime:2.6123099327087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:2.6123690605164 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='8351'DB:business_master_new
loadtime:2.6142389774323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:2.6143329143524 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.6164140701294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.6165170669556 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='8351'DB:business_master_new
loadtime:2.6195690631866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:2.6196558475494 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='8351'DB:business_master_new
loadtime:2.6216790676117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.621778011322 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='8351'DB:business_master_new
loadtime:2.6237869262695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.6239068508148 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='8351'DB:business_master_new
loadtime:2.6290528774261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.6291959285736 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='8351'DB:business_master_new
loadtime:2.6311349868774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:2.6312010288239 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='8351'DB:business_master_new
loadtime:2.6336848735809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.6337418556213 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.6347670555115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:2.6348369121552 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='8351'DB:business_master_new
loadtime:2.6368598937988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:2.6369700431824 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='8351'DB:business_master_new
loadtime:2.6394319534302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:2.639533996582 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='8351'DB:business_master_new
loadtime:2.6411979198456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:2.6412880420685 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.643257856369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:2.6433219909668 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='8351'DB:business_master_new
loadtime:2.6457250118256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:2.6458449363708 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='8351'DB:business_master_new
loadtime:2.6472270488739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:2.6472768783569 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='8351'DB:business_master_new
loadtime:2.6490268707275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:2.6491060256958 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='8351'DB:business_master_new
loadtime:2.6509568691254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:2.6510648727417 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='8351'DB:business_master_new
loadtime:2.6528680324554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:2.6529278755188 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='8351'DB:business_master_new
loadtime:2.6553430557251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:2.6554598808289 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='8351'DB:business_master_new
loadtime:2.6563999652863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:2.6564710140228 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='8351'DB:business_master_new
loadtime:2.6579520702362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:2.6580018997192 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='8351'DB:business_master_new
loadtime:2.6602659225464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:2.6603848934174 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='8351'DB:business_master_new
loadtime:2.6642739772797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.6643109321594 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='8351'DB:business_master_new
loadtime:2.6758608818054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:2.6759190559387 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='8351'DB:business_master_new
loadtime:2.6764588356018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:2.6764960289001 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='8351'DB:business_master_new
loadtime:2.6776058673859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.6776678562164 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='8351'DB:business_master_new
loadtime:2.6787099838257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:2.6787700653076 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='8351'DB:business_master_new
loadtime:2.6869540214539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:2.6870038509369 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='8351'DB:business_master_new
loadtime:2.6880118846893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:2.6880679130554 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='8351'DB:business_master_new
loadtime:2.6892318725586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:2.6892900466919 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='8351'DB:business_master_new
loadtime:2.6910619735718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:2.6911098957062 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='8351'DB:business_master_new
loadtime:2.6921789646149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:2.6922369003296 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.6933720111847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:2.6934180259705 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='8351'DB:business_master_new
loadtime:2.6937248706818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:2.6937680244446 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='8351'DB:business_master_new
loadtime:2.6950218677521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:2.6950719356537 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='8351'DB:business_master_new
loadtime:2.6953949928284 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:2.6954438686371 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='8351'DB:business_master_new
loadtime:2.6957490444183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:2.6957859992981 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='8351'DB:business_master_new
loadtime:2.6968140602112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.6968710422516 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='8351'DB:business_master_new
loadtime:2.6983978748322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.6984570026398 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='8351'DB:business_master_new
loadtime:2.7087059020996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:2.70876288414 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='8351'DB:business_master_new
loadtime:2.710196018219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:2.7102508544922 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='8351'DB:business_master_new
loadtime:2.7124309539795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:2.7124898433685 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='8351'DB:business_master_new
loadtime:2.7127668857574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:2.7128310203552 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='8351'DB:business_master_new
loadtime:2.7133848667145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:2.7134158611298 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='8351'DB:business_master_new
loadtime:2.7145130634308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:2.714567899704 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='8351'DB:business_master_new
loadtime:2.7157709598541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.7158398628235 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='8351'DB:business_master_new
loadtime:2.7375998497009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:2.7376570701599 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='8351'DB:business_master_new
loadtime:2.7404198646545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.7404689788818 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='8351'DB:business_master_new
loadtime:2.7416150569916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.7416648864746 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='8351'DB:business_master_new
loadtime:2.7432949542999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:2.7433619499207 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='8351'DB:business_master_new
loadtime:2.7442848682404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.7443249225616 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='8351'DB:business_master_new
loadtime:2.7455680370331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.7456328868866 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='8351'DB:business_master_new
loadtime:2.7468309402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:2.7468769550323 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='8351'DB:business_master_new
loadtime:2.7481598854065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:2.7482199668884 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='8351'DB:business_master_new
loadtime:2.7496738433838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:2.7497329711914 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='8351'DB:business_master_new
loadtime:2.7508158683777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:2.7508728504181 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='8351'DB:business_master_new
loadtime:2.7558159828186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:2.7558598518372 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='8351'DB:business_master_new
loadtime:2.7562119960785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:2.7562620639801 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='8351'DB:business_master_new
loadtime:2.7572679519653 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:2.7573120594025 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='8351'DB:business_master_new
loadtime:2.7583000659943 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:2.7583599090576 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='8351'DB:business_master_new
loadtime:2.7596728801727 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:2.7597210407257 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='8351'DB:business_master_new
loadtime:2.7608320713043 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:2.7608878612518 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='8351'DB:business_master_new
loadtime:2.7620260715485 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:2.7620890140533 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:2.7630729675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:2.7631340026855 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='8351'DB:business_master_new
loadtime:2.7669260501862 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:2.7669818401337 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='8351'DB:business_master_new
loadtime:2.7673380374908 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:2.7673859596252 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='8351'DB:business_master_new
loadtime:2.7676689624786 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:2.7676959037781 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='8351'DB:business_master_new
loadtime:2.7686769962311 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:2.76873087883 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.7723989486694 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:2.7724409103394 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='8351'DB:business_master_new
loadtime:2.7744140625 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:2.774463891983 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='8351'DB:business_master_new
loadtime:2.7754609584808 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:2.7755229473114 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='8351'DB:business_master_new
loadtime:2.778981924057 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:2.7790248394012 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='8351'DB:business_master_new
loadtime:2.7804548740387 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:2.7805068492889 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='8351'DB:business_master_new
loadtime:2.7823829650879 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:2.7824189662933 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='8351'DB:business_master_new
loadtime:2.7826960086823 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:2.7827398777008 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='8351'DB:business_master_new
loadtime:2.7837550640106 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:2.7838180065155 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='8351'DB:business_master_new
loadtime:2.7849998474121 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:2.7850618362427 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='8351'DB:business_master_new
loadtime:2.7863428592682 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:2.7863910198212 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='8351'DB:business_master_new
loadtime:2.7866668701172 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.7867069244385 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='8351'DB:business_master_new
loadtime:2.7882678508759 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:2.7883288860321 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.8039200305939 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:2.8039710521698 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='8351'DB:business_master_new
loadtime:2.8050010204315 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:2.8050539493561 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='8351'DB:business_master_new
loadtime:2.8142969608307 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:2.8143570423126 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='8351'DB:business_master_new
loadtime:2.8152799606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:2.8153178691864 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='8351'DB:business_master_new
loadtime:2.8204848766327 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:2.82053399086 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='8351'DB:business_master_new
loadtime:2.8208260536194 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:2.8208599090576 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.8219020366669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:2.8219499588013 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='8351'DB:business_master_new
loadtime:2.8235540390015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.823606967926 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='8351'DB:business_master_new
loadtime:2.825140953064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:2.8251910209656 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='8351'DB:business_master_new
loadtime:2.826534986496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:2.8265969753265 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='8351'DB:business_master_new
loadtime:2.8275518417358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:2.8275890350342 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='8351'DB:business_master_new
loadtime:2.8286640644073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.8287220001221 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='8351'DB:business_master_new
loadtime:2.829864025116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.8299238681793 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='8351'DB:business_master_new
loadtime:2.831111907959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:2.8311829566956 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='8351'DB:business_master_new
loadtime:2.8327548503876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:2.8328168392181 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='8351'DB:business_master_new
loadtime:2.8340449333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:2.8340928554535 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.8351979255676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:2.8352448940277 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='8351'DB:business_master_new
loadtime:2.8432259559631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:2.8432629108429 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='8351'DB:business_master_new
loadtime:2.8435728549957 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:2.8436169624329 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='8351'DB:business_master_new
loadtime:2.8438990116119 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:2.8439319133759 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.8444578647614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:2.8445069789886 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='8351'DB:business_master_new
loadtime:2.8455910682678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:2.8456468582153 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='8351'DB:business_master_new
loadtime:2.8468210697174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:2.8468749523163 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='8351'DB:business_master_new
loadtime:2.8480558395386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:2.8481149673462 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='8351'DB:business_master_new
loadtime:2.8483738899231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.8484129905701 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='8351'DB:business_master_new
loadtime:2.8493819236755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:2.8494510650635 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='8351'DB:business_master_new
loadtime:2.8505299091339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:2.8505899906158 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='8351'DB:business_master_new
loadtime:2.8519470691681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:2.8520090579987 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='8351'DB:business_master_new
loadtime:2.8530340194702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:2.8530788421631 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='8351'DB:business_master_new
loadtime:2.853325843811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:2.8533680438995 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='8351'DB:business_master_new
loadtime:2.8539528846741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.853991985321 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='8351'DB:business_master_new
loadtime:2.8553190231323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.8553788661957 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='8351'DB:business_master_new
loadtime:2.8571419715881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.8571848869324 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='8351'DB:business_master_new
loadtime:2.8583679199219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:2.8584139347076 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='8351'DB:business_master_new
loadtime:2.8602919578552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:2.8603458404541 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='8351'DB:business_master_new
loadtime:2.8606090545654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:2.8606429100037 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='8351'DB:business_master_new
loadtime:2.8616209030151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.8616769313812 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='8351'DB:business_master_new
loadtime:2.863214969635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:2.8632609844208 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='8351'DB:business_master_new
loadtime:2.8786950111389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:2.8787920475006 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='8351'DB:business_master_new
loadtime:2.8790948390961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:2.8791520595551 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='8351'DB:business_master_new
loadtime:2.8857479095459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:2.8858070373535 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='8351'DB:business_master_new
loadtime:2.8869750499725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:2.8870139122009 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='8351'DB:business_master_new
loadtime:2.8880829811096 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.888170003891 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.888365983963 / seconds
Operation template executed (chunk cache operation)
loadtime:2.888466835022 / seconds
template override:Default
loadtime:2.8884880542755 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:2.8893229961395 / seconds
Template Constructed, Array Rows:49
loadtime:2.8895740509033 / seconds
TOTAL EXECUTION TIME: 2.88937
loadtime:2.8896999359131 / 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] => child-day-care-services [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:2.8897049427032
TOTAL KEY ARRAYS: 69