Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00011014938354492 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0025060176849365 / seconds
host not found setting manual db connection
loadtime:0.010400056838989 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010655164718628 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010883092880249 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010952949523926 / seconds
zipcode:
loadtime:0.010987043380737 / seconds
Query Executed:select * from search_referrer where page_hash='461ce650496f67bbbd462263e16b8fa0' limit 10 DB:ezrox_toadli
loadtime:0.011260986328125 / seconds
Operation header executed (non global)
loadtime:0.011295080184937 / seconds
Operation leaderboard executed (non global)
loadtime:0.011347055435181 / seconds
Operation square executed (non global)
loadtime:0.011377096176147 / seconds
Operation square_bottom executed (non global)
loadtime:0.011404037475586 / seconds
Operation smallsquare executed (non global)
loadtime:0.011430025100708 / seconds
Operation headeradright executed (non global)
loadtime:0.01145601272583 / seconds
Operation google_analytics executed (non global)
loadtime:0.011481046676636 / seconds
Operation topstories executed (non global)
loadtime:0.011507034301758 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011533975601196 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011559009552002 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011826992034912 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.012022972106934 / seconds
Operation categories executed (global stored into APC)
loadtime:0.012063980102539 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.012128114700317 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.012186050415039 / seconds
Template key: archive_menu pushed
loadtime:0.012195110321045 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.012209177017212 / seconds
Template key: get_gravatar pushed
loadtime:0.012216091156006 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.012223958969116 / seconds
*10)-10)+1 | start:0
loadtime:0.012266159057617 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.012308120727539 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.012344121932983 / seconds
DB connected to localhost business_master_new
loadtime:0.012622117996216 / seconds
Query Executed:select * from `ma_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.03179407119751 / seconds
Query stored in cache : _QUERY_www.toadli.comedd1c5b611b28a3896ed1c469cc1a736
loadtime:0.034024000167847 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.034090995788574 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='6021'DB:business_master_new
loadtime:0.037062168121338 / seconds
Query stored in cache : _QUERY_www.toadli.com13ea3b41ed6c64b7cd77701c75b2fb11
loadtime:0.037103176116943 / seconds
559 / 11
loadtime:0.03717303276062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.037243127822876 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='6021'DB:business_master_new
loadtime:0.045417070388794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.045500993728638 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='6021'DB:business_master_new
loadtime:0.046036958694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.046098947525024 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='6021'DB:business_master_new
loadtime:0.05788516998291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.057995080947876 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='6021'DB:business_master_new
loadtime:0.064082145690918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.064162969589233 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='6021'DB:business_master_new
loadtime:0.068456172943115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.068535089492798 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='6021'DB:business_master_new
loadtime:0.075957059860229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.07604718208313 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='6021'DB:business_master_new
loadtime:0.076452016830444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.076514959335327 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='6021'DB:business_master_new
loadtime:0.085062980651855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.085160970687866 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='6021'DB:business_master_new
loadtime:0.09261417388916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.092698097229004 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='6021'DB:business_master_new
loadtime:0.1038191318512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.10391116142273 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='6021'DB:business_master_new
loadtime:0.11856818199158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.11866617202759 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='6021'DB:business_master_new
loadtime:0.11909604072571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.11917114257812 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='6021'DB:business_master_new
loadtime:0.13291716575623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.13301110267639 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='6021'DB:business_master_new
loadtime:0.13344597816467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.13351011276245 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='6021'DB:business_master_new
loadtime:0.13390111923218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.13396310806274 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='6021'DB:business_master_new
loadtime:0.13602495193481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.13610100746155 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='6021'DB:business_master_new
loadtime:0.13752603530884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.13758897781372 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='6021'DB:business_master_new
loadtime:0.13864016532898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.13870215415955 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='6021'DB:business_master_new
loadtime:0.14605307579041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.14614510536194 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.14677214622498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.14683508872986 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='6021'DB:business_master_new
loadtime:0.1485710144043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.14864706993103 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='6021'DB:business_master_new
loadtime:0.15425395965576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.15433716773987 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='6021'DB:business_master_new
loadtime:0.16761708259583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.16770696640015 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='6021'DB:business_master_new
loadtime:0.16922116279602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.16929912567139 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='6021'DB:business_master_new
loadtime:0.17901515960693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.17910099029541 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='6021'DB:business_master_new
loadtime:0.18345499038696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.18353605270386 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='6021'DB:business_master_new
loadtime:0.18655204772949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.18662905693054 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='6021'DB:business_master_new
loadtime:0.19114995002747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.19122815132141 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='6021'DB:business_master_new
loadtime:0.19165110588074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.1917130947113 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='6021'DB:business_master_new
loadtime:0.19283008575439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.19290614128113 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='6021'DB:business_master_new
loadtime:0.19654011726379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.19662308692932 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='6021'DB:business_master_new
loadtime:0.2000560760498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.20014595985413 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='6021'DB:business_master_new
loadtime:0.20053195953369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.20059514045715 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='6021'DB:business_master_new
loadtime:0.20168614387512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.20176005363464 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='6021'DB:business_master_new
loadtime:0.20959496498108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.20968103408813 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='6021'DB:business_master_new
loadtime:0.21456217765808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.21464395523071 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='6021'DB:business_master_new
loadtime:0.2211799621582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.22126197814941 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='6021'DB:business_master_new
loadtime:0.23157906532288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.23166704177856 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='6021'DB:business_master_new
loadtime:0.23328113555908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.23334503173828 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='6021'DB:business_master_new
loadtime:0.2338490486145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.23391008377075 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='6021'DB:business_master_new
loadtime:0.23540496826172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.23548102378845 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='6021'DB:business_master_new
loadtime:0.23670196533203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.23676514625549 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='6021'DB:business_master_new
loadtime:0.25396418571472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:0.25406312942505 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='6021'DB:business_master_new
loadtime:0.26404714584351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.2641441822052 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='6021'DB:business_master_new
loadtime:0.26754903793335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:0.26762795448303 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='6021'DB:business_master_new
loadtime:0.26840996742249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.26847314834595 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='6021'DB:business_master_new
loadtime:0.2705659866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:0.27064108848572 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='6021'DB:business_master_new
loadtime:0.27126502990723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.27132701873779 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='6021'DB:business_master_new
loadtime:0.28784203529358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:0.28815507888794 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='6021'DB:business_master_new
loadtime:0.28910613059998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:0.28919315338135 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='6021'DB:business_master_new
loadtime:0.29257702827454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:0.29265403747559 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='6021'DB:business_master_new
loadtime:0.29588413238525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:0.29596209526062 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='6021'DB:business_master_new
loadtime:0.29794716835022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.29801511764526 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='6021'DB:business_master_new
loadtime:0.29843807220459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:0.29849910736084 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='6021'DB:business_master_new
loadtime:0.31599617004395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:0.31609106063843 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='6021'DB:business_master_new
loadtime:0.3166720867157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.31673502922058 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='6021'DB:business_master_new
loadtime:0.32282614707947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.32290697097778 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='6021'DB:business_master_new
loadtime:0.33017301559448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.33026218414307 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='6021'DB:business_master_new
loadtime:0.34201216697693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:0.34210395812988 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='6021'DB:business_master_new
loadtime:0.34380197525024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:0.34387898445129 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='6021'DB:business_master_new
loadtime:0.37123918533325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.37139511108398 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='6021'DB:business_master_new
loadtime:0.37288904190063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.37295818328857 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='6021'DB:business_master_new
loadtime:0.39362096786499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:0.39372706413269 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='6021'DB:business_master_new
loadtime:0.39427495002747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:0.39434003829956 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='6021'DB:business_master_new
loadtime:0.39475107192993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:0.39481210708618 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='6021'DB:business_master_new
loadtime:0.39536118507385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:0.39542317390442 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='6021'DB:business_master_new
loadtime:0.39602708816528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.39608907699585 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='6021'DB:business_master_new
loadtime:0.41227006912231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:0.41236901283264 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.41907596588135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:0.41917109489441 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='6021'DB:business_master_new
loadtime:0.42053413391113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.42059803009033 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='6021'DB:business_master_new
loadtime:0.46938610076904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.46956205368042 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='6021'DB:business_master_new
loadtime:0.48144698143005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.4815399646759 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='6021'DB:business_master_new
loadtime:0.48375105857849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:0.48381495475769 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='6021'DB:business_master_new
loadtime:0.48850202560425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:0.48858213424683 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='6021'DB:business_master_new
loadtime:0.48982214927673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.48989796638489 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='6021'DB:business_master_new
loadtime:0.49522304534912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:0.49529910087585 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='6021'DB:business_master_new
loadtime:0.49629306793213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.4963550567627 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='6021'DB:business_master_new
loadtime:0.50396203994751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:0.50404596328735 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='6021'DB:business_master_new
loadtime:0.50946497917175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:0.50954508781433 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='6021'DB:business_master_new
loadtime:0.51007509231567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:0.51014995574951 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='6021'DB:business_master_new
loadtime:0.5106029510498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:0.51066613197327 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='6021'DB:business_master_new
loadtime:0.51120209693909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.51127099990845 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='6021'DB:business_master_new
loadtime:0.51741003990173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:0.51749205589294 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='6021'DB:business_master_new
loadtime:0.53286600112915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.53307294845581 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='6021'DB:business_master_new
loadtime:0.54503917694092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:0.54514002799988 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.54619407653809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.54625296592712 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='6021'DB:business_master_new
loadtime:0.54749798774719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.54756617546082 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='6021'DB:business_master_new
loadtime:0.54834413528442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.54840016365051 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='6021'DB:business_master_new
loadtime:0.54912304878235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:0.54917907714844 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='6021'DB:business_master_new
loadtime:0.55630016326904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:0.55637407302856 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='6021'DB:business_master_new
loadtime:0.5706741809845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:0.57075905799866 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='6021'DB:business_master_new
loadtime:0.57240009307861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:0.57246994972229 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='6021'DB:business_master_new
loadtime:0.57283711433411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.57289004325867 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='6021'DB:business_master_new
loadtime:0.57840704917908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:0.57847499847412 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='6021'DB:business_master_new
loadtime:0.58376002311707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:0.58383703231812 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='6021'DB:business_master_new
loadtime:0.58470106124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.58475708961487 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='6021'DB:business_master_new
loadtime:0.59726095199585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.59733510017395 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='6021'DB:business_master_new
loadtime:0.59827995300293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:0.59834814071655 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='6021'DB:business_master_new
loadtime:0.6000611782074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:0.60013103485107 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='6021'DB:business_master_new
loadtime:0.60062098503113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:0.60067701339722 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='6021'DB:business_master_new
loadtime:0.6015100479126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:0.60156512260437 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='6021'DB:business_master_new
loadtime:0.60195899009705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.60202217102051 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='6021'DB:business_master_new
loadtime:0.60522317886353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:0.60529208183289 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='6021'DB:business_master_new
loadtime:0.62011504173279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:0.62020111083984 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='6021'DB:business_master_new
loadtime:0.62078309059143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.62083697319031 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='6021'DB:business_master_new
loadtime:0.63251113891602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.63259100914001 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='6021'DB:business_master_new
loadtime:0.63349413871765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.63355016708374 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='6021'DB:business_master_new
loadtime:0.63728499412537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:0.63735318183899 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='6021'DB:business_master_new
loadtime:0.64080715179443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:0.64086198806763 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='6021'DB:business_master_new
loadtime:0.6418890953064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:0.64195609092712 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='6021'DB:business_master_new
loadtime:0.64351201057434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.6435661315918 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='6021'DB:business_master_new
loadtime:0.66106510162354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:0.66118097305298 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='6021'DB:business_master_new
loadtime:0.66179418563843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.6618549823761 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='6021'DB:business_master_new
loadtime:0.66554307937622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.66561317443848 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='6021'DB:business_master_new
loadtime:0.66758418083191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:0.66765117645264 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='6021'DB:business_master_new
loadtime:0.67681097984314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:0.67688703536987 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='6021'DB:business_master_new
loadtime:0.67731809616089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.67737412452698 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='6021'DB:business_master_new
loadtime:0.68137216567993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:0.68143916130066 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='6021'DB:business_master_new
loadtime:0.68257808685303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:0.68263506889343 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='6021'DB:business_master_new
loadtime:0.68952512741089 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.68959903717041 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='6021'DB:business_master_new
loadtime:0.68997311592102 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:0.69003701210022 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='6021'DB:business_master_new
loadtime:0.69100403785706 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:0.69107007980347 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='6021'DB:business_master_new
loadtime:0.69627714157104 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:0.69634795188904 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='6021'DB:business_master_new
loadtime:0.69751811027527 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:0.69757199287415 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='6021'DB:business_master_new
loadtime:0.69850206375122 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:0.69856715202332 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='6021'DB:business_master_new
loadtime:0.69895195960999 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:0.69901609420776 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='6021'DB:business_master_new
loadtime:0.7063090801239 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:0.70637512207031 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='6021'DB:business_master_new
loadtime:0.70987415313721 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:0.7099289894104 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='6021'DB:business_master_new
loadtime:0.71818900108337 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:0.71826100349426 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='6021'DB:business_master_new
loadtime:0.71863198280334 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:0.7186861038208 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='6021'DB:business_master_new
loadtime:0.71952605247498 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:0.71957898139954 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='6021'DB:business_master_new
loadtime:0.72008609771729 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:0.72013998031616 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='6021'DB:business_master_new
loadtime:0.72049999237061 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:0.72055506706238 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='6021'DB:business_master_new
loadtime:0.72379207611084 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:0.72384595870972 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='6021'DB:business_master_new
loadtime:0.72531414031982 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:0.72538018226624 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='6021'DB:business_master_new
loadtime:0.72596216201782 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:0.72602415084839 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='6021'DB:business_master_new
loadtime:0.72772908210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:0.72778296470642 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='6021'DB:business_master_new
loadtime:0.72964811325073 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:0.72971606254578 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='6021'DB:business_master_new
loadtime:0.73621296882629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:0.73628807067871 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='6021'DB:business_master_new
loadtime:0.73869895935059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:0.73876595497131 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='6021'DB:business_master_new
loadtime:0.74584197998047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.74591016769409 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='6021'DB:business_master_new
loadtime:0.74655914306641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:0.74661302566528 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='6021'DB:business_master_new
loadtime:0.75310802459717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:0.75318503379822 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='6021'DB:business_master_new
loadtime:0.75358200073242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:0.75363516807556 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='6021'DB:business_master_new
loadtime:0.75424408912659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.75429797172546 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='6021'DB:business_master_new
loadtime:0.75806617736816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:0.75813698768616 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='6021'DB:business_master_new
loadtime:0.77000403404236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:0.77007913589478 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='6021'DB:business_master_new
loadtime:0.77686095237732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:0.77693700790405 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='6021'DB:business_master_new
loadtime:0.80322813987732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.80334115028381 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='6021'DB:business_master_new
loadtime:0.81320810317993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:0.81328511238098 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='6021'DB:business_master_new
loadtime:0.81388998031616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:0.81395697593689 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='6021'DB:business_master_new
loadtime:0.81843018531799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:0.81849908828735 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='6021'DB:business_master_new
loadtime:0.82012796401978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:0.82018899917603 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='6021'DB:business_master_new
loadtime:0.83395099639893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.83403515815735 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='6021'DB:business_master_new
loadtime:0.83887910842896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:0.838947057724 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='6021'DB:business_master_new
loadtime:0.83934712409973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:0.83940196037292 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='6021'DB:business_master_new
loadtime:0.84046697616577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:0.84053301811218 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='6021'DB:business_master_new
loadtime:0.84848403930664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:0.84855508804321 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='6021'DB:business_master_new
loadtime:0.87736201286316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.87746715545654 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='6021'DB:business_master_new
loadtime:0.88857817649841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.88865995407104 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='6021'DB:business_master_new
loadtime:0.89662504196167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:0.89670014381409 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='6021'DB:business_master_new
loadtime:0.89707517623901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.89713001251221 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='6021'DB:business_master_new
loadtime:0.90145015716553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.90154504776001 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='6021'DB:business_master_new
loadtime:0.90232706069946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:0.90238213539124 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='6021'DB:business_master_new
loadtime:0.90314197540283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.90320014953613 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='6021'DB:business_master_new
loadtime:0.90360498428345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.90365695953369 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='6021'DB:business_master_new
loadtime:0.91800403594971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.91808295249939 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='6021'DB:business_master_new
loadtime:0.91867303848267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.91872906684875 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='6021'DB:business_master_new
loadtime:0.92247009277344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.92252397537231 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='6021'DB:business_master_new
loadtime:0.92505407333374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.92510795593262 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='6021'DB:business_master_new
loadtime:0.92603611946106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:0.92609095573425 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='6021'DB:business_master_new
loadtime:0.93445515632629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:0.93452715873718 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='6021'DB:business_master_new
loadtime:0.93502902984619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:0.93508315086365 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='6021'DB:business_master_new
loadtime:0.93553113937378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.93558502197266 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='6021'DB:business_master_new
loadtime:0.945631980896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.9457061290741 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='6021'DB:business_master_new
loadtime:0.95050501823425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:0.9505729675293 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='6021'DB:business_master_new
loadtime:0.95380306243896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:0.95387101173401 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='6021'DB:business_master_new
loadtime:0.95995116233826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.96003317832947 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='6021'DB:business_master_new
loadtime:0.96284413337708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.96291303634644 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='6021'DB:business_master_new
loadtime:0.96381211280823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:0.96386694908142 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='6021'DB:business_master_new
loadtime:0.96751403808594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.9675760269165 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='6021'DB:business_master_new
loadtime:0.96818900108337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.96824216842651 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='6021'DB:business_master_new
loadtime:0.97792100906372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:0.97799515724182 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.97858500480652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:0.97864007949829 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='6021'DB:business_master_new
loadtime:0.98285913467407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.98292803764343 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='6021'DB:business_master_new
loadtime:0.98363995552063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:0.98369407653809 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='6021'DB:business_master_new
loadtime:0.98758101463318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:0.98764896392822 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='6021'DB:business_master_new
loadtime:0.99369096755981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:0.99376010894775 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='6021'DB:business_master_new
loadtime:0.99585509300232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:0.99593806266785 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='6021'DB:business_master_new
loadtime:0.99726796150208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:0.99732613563538 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='6021'DB:business_master_new
loadtime:0.99777007102966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.99782800674438 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='6021'DB:business_master_new
loadtime:1.0161850452423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:1.0162711143494 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='6021'DB:business_master_new
loadtime:1.0166599750519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:1.0167150497437 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='6021'DB:business_master_new
loadtime:1.0177490711212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:1.0178151130676 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='6021'DB:business_master_new
loadtime:1.0183119773865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:1.0183660984039 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='6021'DB:business_master_new
loadtime:1.0306930541992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:1.0307710170746 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='6021'DB:business_master_new
loadtime:1.0318601131439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:1.03191614151 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='6021'DB:business_master_new
loadtime:1.0366699695587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:1.0367391109467 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='6021'DB:business_master_new
loadtime:1.0428690910339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.0429389476776 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='6021'DB:business_master_new
loadtime:1.0436880588531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:1.0437550544739 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='6021'DB:business_master_new
loadtime:1.0512990951538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:1.0513670444489 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='6021'DB:business_master_new
loadtime:1.0667409896851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:1.0668411254883 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='6021'DB:business_master_new
loadtime:1.0702230930328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.0702800750732 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='6021'DB:business_master_new
loadtime:1.0765001773834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:1.0765709877014 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='6021'DB:business_master_new
loadtime:1.0776381492615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.0776941776276 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='6021'DB:business_master_new
loadtime:1.0792109966278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.0792651176453 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='6021'DB:business_master_new
loadtime:1.0877161026001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:1.0877850055695 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='6021'DB:business_master_new
loadtime:1.0923480987549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:1.0924160480499 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='6021'DB:business_master_new
loadtime:1.0928831100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:1.0929360389709 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='6021'DB:business_master_new
loadtime:1.0941071510315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:1.0941770076752 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='6021'DB:business_master_new
loadtime:1.1120719909668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:1.1121571063995 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='6021'DB:business_master_new
loadtime:1.1126821041107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:1.1127371788025 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='6021'DB:business_master_new
loadtime:1.1206011772156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:1.1206710338593 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='6021'DB:business_master_new
loadtime:1.1248400211334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:1.1249091625214 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='6021'DB:business_master_new
loadtime:1.1322751045227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:1.1323449611664 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='6021'DB:business_master_new
loadtime:1.1436841487885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.1437611579895 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='6021'DB:business_master_new
loadtime:1.1447601318359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.1448149681091 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='6021'DB:business_master_new
loadtime:1.1522109508514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:1.1522829532623 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='6021'DB:business_master_new
loadtime:1.1526811122894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.152734041214 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='6021'DB:business_master_new
loadtime:1.1577019691467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.1577701568604 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='6021'DB:business_master_new
loadtime:1.1598720550537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:1.1599390506744 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='6021'DB:business_master_new
loadtime:1.1619231700897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.1619989871979 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='6021'DB:business_master_new
loadtime:1.1809530258179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:1.1810441017151 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='6021'DB:business_master_new
loadtime:1.1861009597778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:1.1861741542816 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='6021'DB:business_master_new
loadtime:1.1870741844177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:1.1871299743652 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='6021'DB:business_master_new
loadtime:1.1907970905304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.1908640861511 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='6021'DB:business_master_new
loadtime:1.1956210136414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:1.1956911087036 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='6021'DB:business_master_new
loadtime:1.1962909698486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:1.1963450908661 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='6021'DB:business_master_new
loadtime:1.2121620178223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:1.2122421264648 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='6021'DB:business_master_new
loadtime:1.2131831645966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.2132389545441 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='6021'DB:business_master_new
loadtime:1.2280850410461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:1.2281670570374 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='6021'DB:business_master_new
loadtime:1.2285661697388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.2286281585693 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='6021'DB:business_master_new
loadtime:1.2326519489288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.2327191829681 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='6021'DB:business_master_new
loadtime:1.2334179878235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.2334730625153 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='6021'DB:business_master_new
loadtime:1.2392511367798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:1.2393221855164 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='6021'DB:business_master_new
loadtime:1.2449741363525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.2450549602509 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='6021'DB:business_master_new
loadtime:1.2740960121155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:1.274227142334 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='6021'DB:business_master_new
loadtime:1.2820451259613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:1.2821309566498 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='6021'DB:business_master_new
loadtime:1.2860050201416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.2860729694366 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='6021'DB:business_master_new
loadtime:1.3062331676483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:1.3063440322876 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='6021'DB:business_master_new
loadtime:1.3109209537506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:1.3109970092773 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='6021'DB:business_master_new
loadtime:1.3273310661316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:1.327418088913 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='6021'DB:business_master_new
loadtime:1.3279919624329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.3280580043793 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='6021'DB:business_master_new
loadtime:1.3307731151581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:1.3308410644531 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='6021'DB:business_master_new
loadtime:1.3317489624023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:1.3318159580231 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='6021'DB:business_master_new
loadtime:1.3399419784546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:1.340026140213 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='6021'DB:business_master_new
loadtime:1.350753068924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.3508291244507 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='6021'DB:business_master_new
loadtime:1.3546941280365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:1.3547620773315 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='6021'DB:business_master_new
loadtime:1.3727741241455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:1.3728580474854 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='6021'DB:business_master_new
loadtime:1.3823800086975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:1.3824570178986 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='6021'DB:business_master_new
loadtime:1.382954120636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:1.3830189704895 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='6021'DB:business_master_new
loadtime:1.3876650333405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:1.3877329826355 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='6021'DB:business_master_new
loadtime:1.3954641819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:1.3955390453339 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='6021'DB:business_master_new
loadtime:1.4011571407318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:1.4012341499329 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='6021'DB:business_master_new
loadtime:1.4056460857391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:1.4057149887085 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='6021'DB:business_master_new
loadtime:1.4111471176147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:1.4112241268158 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='6021'DB:business_master_new
loadtime:1.4170401096344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:1.4171121120453 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='6021'DB:business_master_new
loadtime:1.434159040451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:1.4342501163483 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='6021'DB:business_master_new
loadtime:1.4397101402283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.4397790431976 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='6021'DB:business_master_new
loadtime:1.4488799571991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:1.4489531517029 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='6021'DB:business_master_new
loadtime:1.4528830051422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:1.4529500007629 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='6021'DB:business_master_new
loadtime:1.453369140625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:1.4534239768982 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='6021'DB:business_master_new
loadtime:1.4566080570221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:1.4566769599915 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='6021'DB:business_master_new
loadtime:1.4703691005707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:1.4704480171204 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='6021'DB:business_master_new
loadtime:1.4791481494904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:1.4792280197144 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='6021'DB:business_master_new
loadtime:1.4797229766846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.479777097702 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='6021'DB:business_master_new
loadtime:1.4851090908051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.4851839542389 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='6021'DB:business_master_new
loadtime:1.4976291656494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:1.4977121353149 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='6021'DB:business_master_new
loadtime:1.4983141422272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:1.4983689785004 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='6021'DB:business_master_new
loadtime:1.504702091217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:1.5047700405121 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='6021'DB:business_master_new
loadtime:1.5054061412811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:1.5054609775543 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='6021'DB:business_master_new
loadtime:1.5100409984589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:1.5101089477539 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='6021'DB:business_master_new
loadtime:1.5110630989075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.511116027832 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='6021'DB:business_master_new
loadtime:1.5187921524048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:1.5188620090485 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='6021'DB:business_master_new
loadtime:1.5193469524384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:1.5194029808044 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='6021'DB:business_master_new
loadtime:1.5197720527649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:1.5198240280151 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='6021'DB:business_master_new
loadtime:1.5202000141144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:1.5202519893646 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='6021'DB:business_master_new
loadtime:1.5206470489502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:1.5206990242004 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='6021'DB:business_master_new
loadtime:1.523638010025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:1.5237040519714 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='6021'DB:business_master_new
loadtime:1.5249359607697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:1.5249891281128 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='6021'DB:business_master_new
loadtime:1.5256810188293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.5257329940796 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='6021'DB:business_master_new
loadtime:1.5261480808258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:1.5262050628662 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='6021'DB:business_master_new
loadtime:1.5268540382385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:1.5269050598145 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='6021'DB:business_master_new
loadtime:1.5429811477661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:1.5430560112 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='6021'DB:business_master_new
loadtime:1.5556600093842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:1.5557379722595 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='6021'DB:business_master_new
loadtime:1.5733640193939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:1.5734701156616 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='6021'DB:business_master_new
loadtime:1.5896270275116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:1.5897121429443 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='6021'DB:business_master_new
loadtime:1.5985331535339 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:1.5986211299896 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='6021'DB:business_master_new
loadtime:1.5990350246429 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:1.599091053009 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='6021'DB:business_master_new
loadtime:1.6277341842651 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:1.6278481483459 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='6021'DB:business_master_new
loadtime:1.6286890506744 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:1.6287469863892 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='6021'DB:business_master_new
loadtime:1.6292359828949 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:1.6292901039124 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='6021'DB:business_master_new
loadtime:1.629949092865 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:1.6300001144409 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='6021'DB:business_master_new
loadtime:1.6305201053619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.6305730342865 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='6021'DB:business_master_new
loadtime:1.6338341236115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:1.633908033371 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='6021'DB:business_master_new
loadtime:1.6467220783234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.646800994873 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='6021'DB:business_master_new
loadtime:1.6560959815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:1.6561660766602 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='6021'DB:business_master_new
loadtime:1.6673200130463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:1.6674020290375 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='6021'DB:business_master_new
loadtime:1.6724510192871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:1.6725239753723 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='6021'DB:business_master_new
loadtime:1.6743230819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:1.6743910312653 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='6021'DB:business_master_new
loadtime:1.6747660636902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:1.6748201847076 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='6021'DB:business_master_new
loadtime:1.6795330047607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:1.6796009540558 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='6021'DB:business_master_new
loadtime:1.6799991130829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:1.6800620555878 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='6021'DB:business_master_new
loadtime:1.6855440139771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:1.6856269836426 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='6021'DB:business_master_new
loadtime:1.6860191822052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:1.6860730648041 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='6021'DB:business_master_new
loadtime:1.6902830600739 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:1.6903581619263 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='6021'DB:business_master_new
loadtime:1.6975700855255 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:1.6976449489594 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='6021'DB:business_master_new
loadtime:1.6981379985809 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:1.6981971263885 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='6021'DB:business_master_new
loadtime:1.7099781036377 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:1.7100629806519 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='6021'DB:business_master_new
loadtime:1.7197649478912 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:1.719838142395 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='6021'DB:business_master_new
loadtime:1.7256600856781 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:1.7257270812988 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='6021'DB:business_master_new
loadtime:1.7288031578064 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:1.7288701534271 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='6021'DB:business_master_new
loadtime:1.7292549610138 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:1.7293100357056 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='6021'DB:business_master_new
loadtime:1.7297530174255 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:1.7298040390015 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='6021'DB:business_master_new
loadtime:1.7306020259857 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:1.7306549549103 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='6021'DB:business_master_new
loadtime:1.7356071472168 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:1.7356741428375 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='6021'DB:business_master_new
loadtime:1.7445240020752 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:1.7445950508118 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='6021'DB:business_master_new
loadtime:1.7459001541138 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:1.7459659576416 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='6021'DB:business_master_new
loadtime:1.7470641136169 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:1.7471289634705 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='6021'DB:business_master_new
loadtime:1.7523231506348 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:1.75239610672 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='6021'DB:business_master_new
loadtime:1.7528419494629 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:1.752895116806 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='6021'DB:business_master_new
loadtime:1.7561881542206 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:1.7562539577484 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='6021'DB:business_master_new
loadtime:1.7601931095123 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:1.7602620124817 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='6021'DB:business_master_new
loadtime:1.7606961727142 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:1.7607481479645 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='6021'DB:business_master_new
loadtime:1.7611820697784 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:1.761234998703 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='6021'DB:business_master_new
loadtime:1.7624220848083 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:1.7624759674072 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='6021'DB:business_master_new
loadtime:1.7629110813141 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:1.7629630565643 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='6021'DB:business_master_new
loadtime:1.7633850574493 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:1.7634379863739 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='6021'DB:business_master_new
loadtime:1.770681142807 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:1.7707550525665 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='6021'DB:business_master_new
loadtime:1.7712080478668 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:1.7712631225586 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='6021'DB:business_master_new
loadtime:1.7723190784454 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:1.7723851203918 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='6021'DB:business_master_new
loadtime:1.77303814888 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:1.7730929851532 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='6021'DB:business_master_new
loadtime:1.7734889984131 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:1.7735421657562 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='6021'DB:business_master_new
loadtime:1.7757730484009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:1.7758400440216 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='6021'DB:business_master_new
loadtime:1.7898609638214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:1.7899370193481 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='6021'DB:business_master_new
loadtime:1.7988381385803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:1.7989110946655 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='6021'DB:business_master_new
loadtime:1.8007709980011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.8008379936218 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='6021'DB:business_master_new
loadtime:1.8021910190582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:1.8022570610046 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='6021'DB:business_master_new
loadtime:1.8081960678101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:1.8082671165466 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='6021'DB:business_master_new
loadtime:1.8158271312714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:1.8158960342407 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='6021'DB:business_master_new
loadtime:1.8320469856262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:1.8321220874786 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='6021'DB:business_master_new
loadtime:1.8325390815735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:1.8325951099396 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='6021'DB:business_master_new
loadtime:1.8374171257019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:1.8374881744385 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='6021'DB:business_master_new
loadtime:1.838418006897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:1.8384730815887 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='6021'DB:business_master_new
loadtime:1.838858127594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:1.8389091491699 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='6021'DB:business_master_new
loadtime:1.8397850990295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.8398370742798 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='6021'DB:business_master_new
loadtime:1.8438899517059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:1.8439559936523 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='6021'DB:business_master_new
loadtime:1.8520610332489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:1.8521499633789 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='6021'DB:business_master_new
loadtime:1.8569710254669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:1.8570539951324 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='6021'DB:business_master_new
loadtime:1.8579940795898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.8580679893494 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='6021'DB:business_master_new
loadtime:1.8631091117859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.8631851673126 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='6021'DB:business_master_new
loadtime:1.8688089847565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:1.8688759803772 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='6021'DB:business_master_new
loadtime:1.8704590797424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:1.8705270290375 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='6021'DB:business_master_new
loadtime:1.8892149925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.8893001079559 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='6021'DB:business_master_new
loadtime:1.8897180557251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.8897750377655 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='6021'DB:business_master_new
loadtime:1.8977911472321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:1.8978610038757 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='6021'DB:business_master_new
loadtime:1.9029400348663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:1.903018951416 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='6021'DB:business_master_new
loadtime:1.9034600257874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:1.9035160541534 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='6021'DB:business_master_new
loadtime:1.9044940471649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:1.9045481681824 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='6021'DB:business_master_new
loadtime:1.9049711227417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:1.9050321578979 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='6021'DB:business_master_new
loadtime:1.9054429531097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:1.9054970741272 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='6021'DB:business_master_new
loadtime:1.9245460033417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.9246389865875 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='6021'DB:business_master_new
loadtime:1.9252660274506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:1.925323009491 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='6021'DB:business_master_new
loadtime:1.9299631118774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.9300260543823 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='6021'DB:business_master_new
loadtime:1.9511590003967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:1.9512541294098 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='6021'DB:business_master_new
loadtime:1.9528450965881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:1.9529011249542 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='6021'DB:business_master_new
loadtime:1.9561660289764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:1.956237077713 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='6021'DB:business_master_new
loadtime:1.9566731452942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.9567260742188 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='6021'DB:business_master_new
loadtime:1.9583179950714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:1.9583849906921 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='6021'DB:business_master_new
loadtime:1.9656929969788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:1.9657611846924 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='6021'DB:business_master_new
loadtime:1.9933400154114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.9934451580048 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='6021'DB:business_master_new
loadtime:2.0027799606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:2.0028581619263 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='6021'DB:business_master_new
loadtime:2.0097870826721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:2.0098609924316 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='6021'DB:business_master_new
loadtime:2.0103659629822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:2.0104219913483 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='6021'DB:business_master_new
loadtime:2.0193099975586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:2.0193829536438 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='6021'DB:business_master_new
loadtime:2.0199060440063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:2.0199620723724 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='6021'DB:business_master_new
loadtime:2.0249710083008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:2.0250470638275 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='6021'DB:business_master_new
loadtime:2.0371680259705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:2.0372471809387 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='6021'DB:business_master_new
loadtime:2.0382151603699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:2.0382709503174 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='6021'DB:business_master_new
loadtime:2.0392379760742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.0392911434174 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='6021'DB:business_master_new
loadtime:2.0410621166229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.0411281585693 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='6021'DB:business_master_new
loadtime:2.0487999916077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:2.0488691329956 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='6021'DB:business_master_new
loadtime:2.0541789531708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:2.0542480945587 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='6021'DB:business_master_new
loadtime:2.0621690750122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:2.0622441768646 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='6021'DB:business_master_new
loadtime:2.0628061294556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:2.0628590583801 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='6021'DB:business_master_new
loadtime:2.0673191547394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:2.0673890113831 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='6021'DB:business_master_new
loadtime:2.0757541656494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:2.0758261680603 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='6021'DB:business_master_new
loadtime:2.07843708992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:2.0785059928894 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='6021'DB:business_master_new
loadtime:2.079204082489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:2.0792591571808 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='6021'DB:business_master_new
loadtime:2.0800089836121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:2.0800631046295 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='6021'DB:business_master_new
loadtime:2.0822520256042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:2.0823221206665 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='6021'DB:business_master_new
loadtime:2.0833740234375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:2.083428144455 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='6021'DB:business_master_new
loadtime:2.0850291252136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.0850820541382 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='6021'DB:business_master_new
loadtime:2.1019811630249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:2.1020729541779 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='6021'DB:business_master_new
loadtime:2.1081321239471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:2.1082081794739 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='6021'DB:business_master_new
loadtime:2.1086101531982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:2.1086640357971 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='6021'DB:business_master_new
loadtime:2.1093909740448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:2.1094441413879 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='6021'DB:business_master_new
loadtime:2.1168420314789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:2.1169171333313 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='6021'DB:business_master_new
loadtime:2.1274271011353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:2.1275000572205 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='6021'DB:business_master_new
loadtime:2.1280410289764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:2.1280961036682 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='6021'DB:business_master_new
loadtime:2.1353120803833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:2.1353831291199 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='6021'DB:business_master_new
loadtime:2.1427400112152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.1428101062775 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='6021'DB:business_master_new
loadtime:2.1496579647064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:2.149729013443 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='6021'DB:business_master_new
loadtime:2.1531000137329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:2.1531691551208 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='6021'DB:business_master_new
loadtime:2.1573510169983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:2.1574370861053 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='6021'DB:business_master_new
loadtime:2.157879114151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:2.1579339504242 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='6021'DB:business_master_new
loadtime:2.160994052887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:2.1610481739044 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='6021'DB:business_master_new
loadtime:2.1641840934753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:2.1642510890961 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='6021'DB:business_master_new
loadtime:2.1778531074524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:2.1779341697693 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='6021'DB:business_master_new
loadtime:2.1786470413208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:2.1787030696869 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='6021'DB:business_master_new
loadtime:2.1793370246887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:2.1793911457062 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='6021'DB:business_master_new
loadtime:2.1797540187836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.1798059940338 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='6021'DB:business_master_new
loadtime:2.1857280731201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:2.1858041286469 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='6021'DB:business_master_new
loadtime:2.2066609859467 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:2.2067670822144 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='6021'DB:business_master_new
loadtime:2.2073850631714 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:2.2074439525604 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='6021'DB:business_master_new
loadtime:2.2081179618835 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:2.2081751823425 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='6021'DB:business_master_new
loadtime:2.2087280750275 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:2.2087800502777 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='6021'DB:business_master_new
loadtime:2.2098400592804 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:2.209892988205 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='6021'DB:business_master_new
loadtime:2.21027302742 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:2.2103259563446 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='6021'DB:business_master_new
loadtime:2.2150449752808 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:2.2151141166687 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='6021'DB:business_master_new
loadtime:2.2178020477295 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:2.2178721427917 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='6021'DB:business_master_new
loadtime:2.2226619720459 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:2.2227311134338 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='6021'DB:business_master_new
loadtime:2.2293961048126 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:2.2294709682465 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='6021'DB:business_master_new
loadtime:2.2302670478821 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:2.2303340435028 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='6021'DB:business_master_new
loadtime:2.2314910888672 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:2.231546163559 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='6021'DB:business_master_new
loadtime:2.2372281551361 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:2.237300157547 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='6021'DB:business_master_new
loadtime:2.2399411201477 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:2.2400159835815 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='6021'DB:business_master_new
loadtime:2.2405440807343 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:2.2405979633331 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='6021'DB:business_master_new
loadtime:2.2412371635437 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:2.2412910461426 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='6021'DB:business_master_new
loadtime:2.2417969703674 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:2.2418491840363 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='6021'DB:business_master_new
loadtime:2.2424671649933 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:2.2425200939178 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='6021'DB:business_master_new
loadtime:2.2430610656738 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:2.2431130409241 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='6021'DB:business_master_new
loadtime:2.243812084198 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:2.2438640594482 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='6021'DB:business_master_new
loadtime:2.2503850460052 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:2.2504570484161 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='6021'DB:business_master_new
loadtime:2.2572319507599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:2.257306098938 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='6021'DB:business_master_new
loadtime:2.2592241764069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:2.2592899799347 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='6021'DB:business_master_new
loadtime:2.2650480270386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:2.2651150226593 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='6021'DB:business_master_new
loadtime:2.2717430591583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.2718150615692 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='6021'DB:business_master_new
loadtime:2.2724139690399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:2.2724690437317 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='6021'DB:business_master_new
loadtime:2.2772731781006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.2773420810699 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='6021'DB:business_master_new
loadtime:2.2829620838165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.2830419540405 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='6021'DB:business_master_new
loadtime:2.3257119655609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.3258559703827 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='6021'DB:business_master_new
loadtime:2.3303680419922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:2.3304409980774 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='6021'DB:business_master_new
loadtime:2.3309381008148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.3310000896454 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='6021'DB:business_master_new
loadtime:2.3327150344849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:2.3327820301056 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='6021'DB:business_master_new
loadtime:2.342404127121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:2.3424820899963 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='6021'DB:business_master_new
loadtime:2.3550989627838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:2.3551850318909 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='6021'DB:business_master_new
loadtime:2.3596000671387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:2.3596701622009 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='6021'DB:business_master_new
loadtime:2.364413022995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:2.3644840717316 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='6021'DB:business_master_new
loadtime:2.3730289936066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:2.3731091022491 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='6021'DB:business_master_new
loadtime:2.3745350837708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:2.374605178833 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='6021'DB:business_master_new
loadtime:2.3790459632874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:2.379114151001 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='6021'DB:business_master_new
loadtime:2.3851029872894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:2.3851771354675 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='6021'DB:business_master_new
loadtime:2.3919880390167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:2.3920631408691 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='6021'DB:business_master_new
loadtime:2.406886100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:2.4069709777832 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='6021'DB:business_master_new
loadtime:2.4073801040649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:2.407436132431 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='6021'DB:business_master_new
loadtime:2.408921957016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:2.4089760780334 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='6021'DB:business_master_new
loadtime:2.4197030067444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:2.4197821617126 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='6021'DB:business_master_new
loadtime:2.420389175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.4204449653625 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='6021'DB:business_master_new
loadtime:2.4216279983521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:2.4216959476471 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='6021'DB:business_master_new
loadtime:2.4220740795135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:2.4221301078796 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='6021'DB:business_master_new
loadtime:2.4269530773163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.4270310401917 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='6021'DB:business_master_new
loadtime:2.4295270442963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:2.4295930862427 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='6021'DB:business_master_new
loadtime:2.4308609962463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:2.4309160709381 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='6021'DB:business_master_new
loadtime:2.4342269897461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:2.4342951774597 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='6021'DB:business_master_new
loadtime:2.440201997757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:2.4402689933777 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='6021'DB:business_master_new
loadtime:2.4407601356506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:2.4408130645752 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='6021'DB:business_master_new
loadtime:2.4445209503174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:2.4446029663086 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='6021'DB:business_master_new
loadtime:2.4509689807892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:2.4510540962219 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='6021'DB:business_master_new
loadtime:2.4514751434326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:2.4515311717987 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='6021'DB:business_master_new
loadtime:2.4595980644226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:2.459673166275 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='6021'DB:business_master_new
loadtime:2.4600789546967 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:2.4601340293884 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='6021'DB:business_master_new
loadtime:2.4605350494385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:2.4605891704559 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='6021'DB:business_master_new
loadtime:2.4626491069794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.4627170562744 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='6021'DB:business_master_new
loadtime:2.475753068924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.4758269786835 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='6021'DB:business_master_new
loadtime:2.4767031669617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:2.4767589569092 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='6021'DB:business_master_new
loadtime:2.4861199855804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:2.4861950874329 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='6021'DB:business_master_new
loadtime:2.5140120983124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:2.5141069889069 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='6021'DB:business_master_new
loadtime:2.5145471096039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:2.51460313797 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='6021'DB:business_master_new
loadtime:2.5150120258331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:2.5150661468506 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='6021'DB:business_master_new
loadtime:2.5196750164032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:2.5197479724884 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='6021'DB:business_master_new
loadtime:2.526435136795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.5265040397644 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='6021'DB:business_master_new
loadtime:2.5277481079102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:2.5278141498566 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='6021'DB:business_master_new
loadtime:2.5283901691437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.5284440517426 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='6021'DB:business_master_new
loadtime:2.5288591384888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.5289101600647 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='6021'DB:business_master_new
loadtime:2.5428981781006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:2.5429799556732 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='6021'DB:business_master_new
loadtime:2.5434319972992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.5434880256653 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='6021'DB:business_master_new
loadtime:2.5497121810913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.5497841835022 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='6021'DB:business_master_new
loadtime:2.5568201541901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:2.5568931102753 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='6021'DB:business_master_new
loadtime:2.5651490688324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:2.5652379989624 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='6021'DB:business_master_new
loadtime:2.5761451721191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:2.5762269496918 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='6021'DB:business_master_new
loadtime:2.5790200233459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:2.579087972641 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='6021'DB:business_master_new
loadtime:2.5797691345215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:2.5798230171204 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='6021'DB:business_master_new
loadtime:2.5802481174469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:2.5803020000458 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='6021'DB:business_master_new
loadtime:2.5818359851837 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:2.5818901062012 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='6021'DB:business_master_new
loadtime:2.5851540565491 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:2.58522605896 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='6021'DB:business_master_new
loadtime:2.5856821537018 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:2.5857350826263 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='6021'DB:business_master_new
loadtime:2.5911021232605 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:2.5911719799042 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='6021'DB:business_master_new
loadtime:2.5968120098114 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:2.5968790054321 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='6021'DB:business_master_new
loadtime:2.5986349582672 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:2.5987019538879 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='6021'DB:business_master_new
loadtime:2.5994400978088 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:2.5994970798492 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='6021'DB:business_master_new
loadtime:2.5999109745026 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:2.5999641418457 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='6021'DB:business_master_new
loadtime:2.6003510951996 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:2.6004049777985 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='6021'DB:business_master_new
loadtime:2.6020431518555 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:2.6021089553833 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='6021'DB:business_master_new
loadtime:2.6029341220856 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:2.6029889583588 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='6021'DB:business_master_new
loadtime:2.603532075882 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:2.6035850048065 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='6021'DB:business_master_new
loadtime:2.6048600673676 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:2.6049129962921 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='6021'DB:business_master_new
loadtime:2.6057779788971 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:2.6058449745178 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='6021'DB:business_master_new
loadtime:2.606320142746 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:2.6063740253448 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='6021'DB:business_master_new
loadtime:2.6067790985107 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:2.6068301200867 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='6021'DB:business_master_new
loadtime:2.607213973999 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:2.6072671413422 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='6021'DB:business_master_new
loadtime:2.6089611053467 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:2.6090221405029 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='6021'DB:business_master_new
loadtime:2.6142179965973 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:2.6142840385437 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='6021'DB:business_master_new
loadtime:2.6227979660034 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:2.6228721141815 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='6021'DB:business_master_new
loadtime:2.6232531070709 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.623309135437 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='6021'DB:business_master_new
loadtime:2.638699054718 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:2.6387829780579 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='6021'DB:business_master_new
loadtime:2.639867067337 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:2.6399230957031 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='6021'DB:business_master_new
loadtime:2.6430261135101 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:2.6430940628052 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='6021'DB:business_master_new
loadtime:2.6439871788025 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:2.6440510749817 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='6021'DB:business_master_new
loadtime:2.6452741622925 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:2.6453280448914 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='6021'DB:business_master_new
loadtime:2.6460230350494 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:2.6460890769958 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='6021'DB:business_master_new
loadtime:2.6464841365814 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:2.6465380191803 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='6021'DB:business_master_new
loadtime:2.6514310836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:2.6514980792999 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='6021'DB:business_master_new
loadtime:2.6650130748749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.6651170253754 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='6021'DB:business_master_new
loadtime:2.6790680885315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:2.6791501045227 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='6021'DB:business_master_new
loadtime:2.6885371208191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:2.688618183136 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='6021'DB:business_master_new
loadtime:2.6890189647675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:2.6890749931335 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='6021'DB:business_master_new
loadtime:2.6928250789642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.692892074585 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='6021'DB:business_master_new
loadtime:2.6980290412903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.6980981826782 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='6021'DB:business_master_new
loadtime:2.704971075058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:2.7050490379333 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='6021'DB:business_master_new
loadtime:2.7055370807648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:2.7055921554565 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='6021'DB:business_master_new
loadtime:2.712639093399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:2.7127120494843 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='6021'DB:business_master_new
loadtime:2.718533039093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:2.7186050415039 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='6021'DB:business_master_new
loadtime:2.7195041179657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:2.7195589542389 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='6021'DB:business_master_new
loadtime:2.7199749946594 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:2.72003698349 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='6021'DB:business_master_new
loadtime:2.7204179763794 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:2.7204711437225 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='6021'DB:business_master_new
loadtime:2.7209041118622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:2.7209560871124 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='6021'DB:business_master_new
loadtime:2.7255849838257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:2.7256560325623 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='6021'DB:business_master_new
loadtime:2.7310330867767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:2.7311019897461 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='6021'DB:business_master_new
loadtime:2.7372829914093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:2.7373559474945 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='6021'DB:business_master_new
loadtime:2.7377490997314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.7378029823303 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='6021'DB:business_master_new
loadtime:2.7393641471863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:2.7394180297852 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='6021'DB:business_master_new
loadtime:2.7441000938416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:2.7441761493683 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='6021'DB:business_master_new
loadtime:2.7542591094971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:2.7543430328369 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='6021'DB:business_master_new
loadtime:2.7585949897766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:2.7586660385132 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='6021'DB:business_master_new
loadtime:2.7590939998627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:2.7591490745544 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='6021'DB:business_master_new
loadtime:2.759644985199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.7596991062164 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='6021'DB:business_master_new
loadtime:2.7688961029053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.7689690589905 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='6021'DB:business_master_new
loadtime:2.7696151733398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.7696690559387 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='6021'DB:business_master_new
loadtime:2.7759439945221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:2.7760241031647 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='6021'DB:business_master_new
loadtime:2.7983989715576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:2.7985019683838 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='6021'DB:business_master_new
loadtime:2.798877954483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:2.7989361286163 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='6021'DB:business_master_new
loadtime:2.8001761436462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.8002309799194 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='6021'DB:business_master_new
loadtime:2.8006811141968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:2.8007340431213 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='6021'DB:business_master_new
loadtime:2.8168549537659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:2.8169951438904 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='6021'DB:business_master_new
loadtime:2.8174240589142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:2.8174829483032 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='6021'DB:business_master_new
loadtime:2.818372964859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:2.8184270858765 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='6021'DB:business_master_new
loadtime:2.8249080181122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:2.8249771595001 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='6021'DB:business_master_new
loadtime:2.829442024231 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.8296070098877 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.8300890922546 / seconds
Operation template executed (chunk cache operation)
loadtime:2.8302571773529 / seconds
template override:Default
loadtime:2.8303010463715 / 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.8315620422363 / seconds
Template Constructed, Array Rows:49
loadtime:2.8321120738983 / seconds
TOTAL EXECUTION TIME: 2.83165
loadtime:2.8349809646606 / 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] => national-commercial-banks [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.8349921703339
TOTAL KEY ARRAYS: 69