Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.8930130004883E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018880367279053 / seconds
host not found setting manual db connection
loadtime:0.0096950531005859 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0099461078643799 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010184049606323 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010249137878418 / seconds
zipcode:
loadtime:0.010276079177856 / seconds
Query Executed:select * from search_referrer where page_hash='9dd2e576f167e96387e7388145d7eb01' limit 10 DB:ezrox_toadli
loadtime:0.010585069656372 / seconds
Operation header executed (non global)
loadtime:0.0106201171875 / seconds
Operation leaderboard executed (non global)
loadtime:0.010673999786377 / seconds
Operation square executed (non global)
loadtime:0.010703086853027 / seconds
Operation square_bottom executed (non global)
loadtime:0.010730981826782 / seconds
Operation smallsquare executed (non global)
loadtime:0.010756015777588 / seconds
Operation headeradright executed (non global)
loadtime:0.010781049728394 / seconds
Operation google_analytics executed (non global)
loadtime:0.010806083679199 / seconds
Operation topstories executed (non global)
loadtime:0.010831117630005 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010857105255127 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010882139205933 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011140108108521 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.01134204864502 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01137900352478 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011450052261353 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011502027511597 / seconds
Template key: archive_menu pushed
loadtime:0.011511087417603 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011523962020874 / seconds
Template key: get_gravatar pushed
loadtime:0.011531114578247 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011539936065674 / seconds
*10)-10)+1 | start:0
loadtime:0.011580944061279 / seconds
Query loaded from cache:select * from categories where cat_URLid='child-day-care-services'
loadtime:0.011627912521362 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.011667966842651 / seconds
DB connected to localhost business_master_new
loadtime:0.011929988861084 / seconds
Query Executed:select * from `ma_catmap` where sic='8351' order by city ascDB:business_master_new
loadtime:0.038772106170654 / seconds
Query stored in cache : _QUERY_www.toadli.com4c2bd20ec1d3a58e40e9690064ec8372
loadtime:0.040995121002197 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.041055917739868 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='8351'DB:business_master_new
loadtime:0.045454978942871 / seconds
Query stored in cache : _QUERY_www.toadli.comebf528c40e43866fc62668d6ad48c496
loadtime:0.045490980148315 / seconds
559 / 11
loadtime:0.045547008514404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.045618057250977 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='8351'DB:business_master_new
loadtime:0.073740005493164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.07382607460022 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='8351'DB:business_master_new
loadtime:0.074358940124512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.074413061141968 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='8351'DB:business_master_new
loadtime:0.08582592010498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.085925102233887 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='8351'DB:business_master_new
loadtime:0.090501070022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.090574979782104 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='8351'DB:business_master_new
loadtime:0.095093965530396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.095165967941284 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='8351'DB:business_master_new
loadtime:0.10282206535339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.1028950214386 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='8351'DB:business_master_new
loadtime:0.10328507423401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.10333895683289 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='8351'DB:business_master_new
loadtime:0.11213707923889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.1122100353241 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='8351'DB:business_master_new
loadtime:0.11995100975037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.12004995346069 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='8351'DB:business_master_new
loadtime:0.13136911392212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.13146901130676 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='8351'DB:business_master_new
loadtime:0.14631509780884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.14642000198364 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='8351'DB:business_master_new
loadtime:0.14683413505554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.14689111709595 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='8351'DB:business_master_new
loadtime:0.16096591949463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.16105508804321 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='8351'DB:business_master_new
loadtime:0.16149497032166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.16155099868774 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='8351'DB:business_master_new
loadtime:0.16193604469299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.16198897361755 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='8351'DB:business_master_new
loadtime:0.16402101516724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.16409301757812 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='8351'DB:business_master_new
loadtime:0.16550397872925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.16557192802429 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='8351'DB:business_master_new
loadtime:0.16661190986633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.16667914390564 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='8351'DB:business_master_new
loadtime:0.17427492141724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.17435503005981 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='8351'DB:business_master_new
loadtime:0.17498707771301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.1750431060791 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='8351'DB:business_master_new
loadtime:0.17676997184753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.17683792114258 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='8351'DB:business_master_new
loadtime:0.18268895149231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.18276405334473 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='8351'DB:business_master_new
loadtime:0.19646406173706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.19656014442444 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='8351'DB:business_master_new
loadtime:0.19805908203125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.19812798500061 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='8351'DB:business_master_new
loadtime:0.20807814598083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.20815801620483 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='8351'DB:business_master_new
loadtime:0.21302509307861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.21309304237366 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='8351'DB:business_master_new
loadtime:0.21678900718689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.21685695648193 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='8351'DB:business_master_new
loadtime:0.22273206710815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.22280311584473 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='8351'DB:business_master_new
loadtime:0.22321796417236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.2232711315155 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='8351'DB:business_master_new
loadtime:0.22436714172363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.22443103790283 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='8351'DB:business_master_new
loadtime:0.22818899154663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.22824311256409 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='8351'DB:business_master_new
loadtime:0.23190212249756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.23197102546692 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='8351'DB:business_master_new
loadtime:0.23234605789185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.23239898681641 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='8351'DB:business_master_new
loadtime:0.23348903656006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.23354196548462 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='8351'DB:business_master_new
loadtime:0.24161791801453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.24169993400574 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='8351'DB:business_master_new
loadtime:0.24677109718323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.2468421459198 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='8351'DB:business_master_new
loadtime:0.25351095199585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.25358200073242 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='8351'DB:business_master_new
loadtime:0.26423192024231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.26432204246521 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='8351'DB:business_master_new
loadtime:0.2659330368042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.26598906517029 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='8351'DB:business_master_new
loadtime:0.26648998260498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.26654195785522 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='8351'DB:business_master_new
loadtime:0.26802396774292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.26809000968933 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='8351'DB:business_master_new
loadtime:0.26928210258484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.26934695243835 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='8351'DB:business_master_new
loadtime:0.28683614730835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:0.28692412376404 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='8351'DB:business_master_new
loadtime:0.29720306396484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.29728412628174 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='8351'DB:business_master_new
loadtime:0.30090093612671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:0.30097007751465 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='8351'DB:business_master_new
loadtime:0.30175113677979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.30181908607483 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='8351'DB:business_master_new
loadtime:0.30390095710754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:0.30396914482117 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='8351'DB:business_master_new
loadtime:0.30457305908203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.3046441078186 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='8351'DB:business_master_new
loadtime:0.32317900657654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:0.3233380317688 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='8351'DB:business_master_new
loadtime:0.32428193092346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:0.32434296607971 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='8351'DB:business_master_new
loadtime:0.32794904708862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:0.32801508903503 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='8351'DB:business_master_new
loadtime:0.33146095275879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:0.33152794837952 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='8351'DB:business_master_new
loadtime:0.33486199378967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.33491611480713 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='8351'DB:business_master_new
loadtime:0.33532214164734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:0.33537292480469 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='8351'DB:business_master_new
loadtime:0.35319209098816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:0.35328102111816 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='8351'DB:business_master_new
loadtime:0.35386514663696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.35391998291016 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='8351'DB:business_master_new
loadtime:0.36015701293945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.36022400856018 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='8351'DB:business_master_new
loadtime:0.36767101287842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.36774301528931 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='8351'DB:business_master_new
loadtime:0.37966203689575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:0.37975001335144 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='8351'DB:business_master_new
loadtime:0.3814480304718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:0.3815290927887 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='8351'DB:business_master_new
loadtime:0.407310962677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.40745210647583 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:0.40891003608704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.40898013114929 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='8351'DB:business_master_new
loadtime:0.42987895011902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:0.42998194694519 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='8351'DB:business_master_new
loadtime:0.4308009147644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:0.43085908889771 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='8351'DB:business_master_new
loadtime:0.43146014213562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:0.4315140247345 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='8351'DB:business_master_new
loadtime:0.43227410316467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:0.43232703208923 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='8351'DB:business_master_new
loadtime:0.43318891525269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.43324303627014 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='8351'DB:business_master_new
loadtime:0.45222210884094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:0.45231103897095 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='8351'DB:business_master_new
loadtime:0.4593460559845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:0.45942091941833 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='8351'DB:business_master_new
loadtime:0.4608199596405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.46087503433228 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='8351'DB:business_master_new
loadtime:0.51097893714905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.51110100746155 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='8351'DB:business_master_new
loadtime:0.52327394485474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.52335405349731 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='8351'DB:business_master_new
loadtime:0.52561402320862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:0.52568697929382 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='8351'DB:business_master_new
loadtime:0.53062391281128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:0.53069591522217 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='8351'DB:business_master_new
loadtime:0.5319459438324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.53200101852417 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='8351'DB:business_master_new
loadtime:0.53758811950684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:0.53766107559204 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='8351'DB:business_master_new
loadtime:0.53865313529968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.53870701789856 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='8351'DB:business_master_new
loadtime:0.5465841293335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:0.54666113853455 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='8351'DB:business_master_new
loadtime:0.55232095718384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:0.55239009857178 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='8351'DB:business_master_new
loadtime:0.55292391777039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:0.55297994613647 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='8351'DB:business_master_new
loadtime:0.55343008041382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:0.55349111557007 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='8351'DB:business_master_new
loadtime:0.55400991439819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.55406212806702 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='8351'DB:business_master_new
loadtime:0.56037592887878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:0.56043004989624 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='8351'DB:business_master_new
loadtime:0.57317304611206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.57325005531311 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='8351'DB:business_master_new
loadtime:0.58380007743835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:0.58387804031372 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='8351'DB:business_master_new
loadtime:0.5849289894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.58499693870544 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='8351'DB:business_master_new
loadtime:0.58626413345337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.58632898330688 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='8351'DB:business_master_new
loadtime:0.58714509010315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.58719992637634 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='8351'DB:business_master_new
loadtime:0.58796501159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:0.58803200721741 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='8351'DB:business_master_new
loadtime:0.59542512893677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:0.59550213813782 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='8351'DB:business_master_new
loadtime:0.61035108566284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:0.61048793792725 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='8351'DB:business_master_new
loadtime:0.61219692230225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:0.61226201057434 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='8351'DB:business_master_new
loadtime:0.61269092559814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.61275410652161 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='8351'DB:business_master_new
loadtime:0.61858892440796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:0.61866998672485 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='8351'DB:business_master_new
loadtime:0.62428307533264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:0.62436699867249 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='8351'DB:business_master_new
loadtime:0.62529397010803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.6253559589386 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='8351'DB:business_master_new
loadtime:0.63842105865479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.63852405548096 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='8351'DB:business_master_new
loadtime:0.63953399658203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:0.63959813117981 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='8351'DB:business_master_new
loadtime:0.64138412475586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:0.64146208763123 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='8351'DB:business_master_new
loadtime:0.64201498031616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:0.64207696914673 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='8351'DB:business_master_new
loadtime:0.64296793937683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:0.64302897453308 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='8351'DB:business_master_new
loadtime:0.64348006248474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.64355111122131 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='8351'DB:business_master_new
loadtime:0.64704704284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:0.64712595939636 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='8351'DB:business_master_new
loadtime:0.66250491142273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:0.66259813308716 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='8351'DB:business_master_new
loadtime:0.66323900222778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.66330313682556 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='8351'DB:business_master_new
loadtime:0.67536306381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.67544913291931 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='8351'DB:business_master_new
loadtime:0.67640209197998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.67647790908813 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='8351'DB:business_master_new
loadtime:0.68052792549133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:0.68060612678528 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='8351'DB:business_master_new
loadtime:0.68434309959412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:0.68441891670227 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='8351'DB:business_master_new
loadtime:0.6855161190033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:0.68559408187866 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='8351'DB:business_master_new
loadtime:0.68722105026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.68729710578918 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='8351'DB:business_master_new
loadtime:0.70546007156372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:0.70559406280518 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='8351'DB:business_master_new
loadtime:0.7060489654541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.70611596107483 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='8351'DB:business_master_new
loadtime:0.71001601219177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.71009397506714 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='8351'DB:business_master_new
loadtime:0.7121250629425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:0.71220707893372 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='8351'DB:business_master_new
loadtime:0.72181010246277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:0.72190809249878 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='8351'DB:business_master_new
loadtime:0.72236394882202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.72242999076843 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='8351'DB:business_master_new
loadtime:0.72673296928406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:0.72681093215942 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='8351'DB:business_master_new
loadtime:0.72800493240356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:0.72808194160461 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='8351'DB:business_master_new
loadtime:0.73528814315796 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.73537302017212 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='8351'DB:business_master_new
loadtime:0.73581314086914 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:0.73587608337402 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='8351'DB:business_master_new
loadtime:0.73691511154175 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:0.73697710037231 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='8351'DB:business_master_new
loadtime:0.74254012107849 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:0.74262309074402 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:0.74386096000671 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:0.74392414093018 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='8351'DB:business_master_new
loadtime:0.74491405487061 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:0.74497699737549 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='8351'DB:business_master_new
loadtime:0.74541807174683 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:0.74548101425171 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:0.75317096710205 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:0.75325512886047 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='8351'DB:business_master_new
loadtime:0.75711703300476 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:0.75719714164734 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='8351'DB:business_master_new
loadtime:0.76588296890259 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:0.76596808433533 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='8351'DB:business_master_new
loadtime:0.76639008522034 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:0.76645302772522 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='8351'DB:business_master_new
loadtime:0.76735997200012 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:0.76743412017822 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='8351'DB:business_master_new
loadtime:0.76800608634949 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:0.76806807518005 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='8351'DB:business_master_new
loadtime:0.76847410202026 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:0.76854610443115 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='8351'DB:business_master_new
loadtime:0.77210593223572 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:0.7721860408783 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='8351'DB:business_master_new
loadtime:0.77372694015503 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:0.77380394935608 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='8351'DB:business_master_new
loadtime:0.77444410324097 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:0.77451705932617 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='8351'DB:business_master_new
loadtime:0.77632999420166 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:0.77641201019287 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='8351'DB:business_master_new
loadtime:0.77835893630981 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:0.77843594551086 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:0.78716611862183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:0.78725099563599 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='8351'DB:business_master_new
loadtime:0.78976607322693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:0.78984308242798 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='8351'DB:business_master_new
loadtime:0.79728198051453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.79736495018005 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='8351'DB:business_master_new
loadtime:0.7980740070343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:0.79815101623535 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='8351'DB:business_master_new
loadtime:0.80495500564575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:0.80503392219543 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='8351'DB:business_master_new
loadtime:0.80548095703125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:0.80555391311646 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='8351'DB:business_master_new
loadtime:0.80622100830078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.80628299713135 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='8351'DB:business_master_new
loadtime:0.81034111976624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:0.8104190826416 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='8351'DB:business_master_new
loadtime:0.82283711433411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:0.82292199134827 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='8351'DB:business_master_new
loadtime:0.830078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:0.83016490936279 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='8351'DB:business_master_new
loadtime:0.86194014549255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.86205697059631 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:0.87228798866272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:0.87237310409546 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='8351'DB:business_master_new
loadtime:0.87304711341858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:0.87312412261963 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='8351'DB:business_master_new
loadtime:0.87788391113281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:0.87796592712402 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='8351'DB:business_master_new
loadtime:0.87967610359192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:0.87975192070007 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='8351'DB:business_master_new
loadtime:0.89421200752258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.89430904388428 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='8351'DB:business_master_new
loadtime:0.89962005615234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:0.89971303939819 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='8351'DB:business_master_new
loadtime:0.9001579284668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:0.90022110939026 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='8351'DB:business_master_new
loadtime:0.90134692192078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:0.90140795707703 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='8351'DB:business_master_new
loadtime:0.90980505943298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:0.90989303588867 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='8351'DB:business_master_new
loadtime:0.94623613357544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.94636201858521 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='8351'DB:business_master_new
loadtime:0.95800995826721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.95810699462891 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='8351'DB:business_master_new
loadtime:0.96647310256958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:0.96656513214111 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='8351'DB:business_master_new
loadtime:0.96698904037476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.96705198287964 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='8351'DB:business_master_new
loadtime:0.97171497344971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.9717960357666 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='8351'DB:business_master_new
loadtime:0.97263097763062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:0.97270607948303 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='8351'DB:business_master_new
loadtime:0.9735209941864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.97359895706177 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='8351'DB:business_master_new
loadtime:0.97406196594238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.97412514686584 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='8351'DB:business_master_new
loadtime:0.98893213272095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.9890251159668 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='8351'DB:business_master_new
loadtime:0.98968505859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.98974895477295 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='8351'DB:business_master_new
loadtime:0.9938530921936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.99393510818481 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='8351'DB:business_master_new
loadtime:0.99650812149048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.99659109115601 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='8351'DB:business_master_new
loadtime:0.99758696556091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:0.99765014648438 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='8351'DB:business_master_new
loadtime:1.0064179897308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:1.006500005722 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='8351'DB:business_master_new
loadtime:1.007061958313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:1.0071239471436 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='8351'DB:business_master_new
loadtime:1.0076379776001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:1.0077090263367 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='8351'DB:business_master_new
loadtime:1.0181701183319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:1.0182499885559 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='8351'DB:business_master_new
loadtime:1.0234169960022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:1.023500919342 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='8351'DB:business_master_new
loadtime:1.0270440578461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:1.0271239280701 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='8351'DB:business_master_new
loadtime:1.032534122467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:1.0325970649719 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='8351'DB:business_master_new
loadtime:1.0346529483795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.0347440242767 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='8351'DB:business_master_new
loadtime:1.0354099273682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:1.0354859828949 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='8351'DB:business_master_new
loadtime:1.0390441417694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:1.0391209125519 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='8351'DB:business_master_new
loadtime:1.0397810935974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:1.0398421287537 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='8351'DB:business_master_new
loadtime:1.0499510765076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:1.0500340461731 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='8351'DB:business_master_new
loadtime:1.0506730079651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:1.05073595047 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='8351'DB:business_master_new
loadtime:1.0552539825439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:1.0553340911865 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='8351'DB:business_master_new
loadtime:1.0561010837555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:1.056174993515 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='8351'DB:business_master_new
loadtime:1.0603311061859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:1.0604090690613 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='8351'DB:business_master_new
loadtime:1.0668530464172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:1.0669329166412 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='8351'DB:business_master_new
loadtime:1.0689730644226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:1.0690479278564 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='8351'DB:business_master_new
loadtime:1.0704340934753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:1.0705170631409 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='8351'DB:business_master_new
loadtime:1.07102394104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:1.0710849761963 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='8351'DB:business_master_new
loadtime:1.0901660919189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:1.0902819633484 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='8351'DB:business_master_new
loadtime:1.0907371044159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:1.0908031463623 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='8351'DB:business_master_new
loadtime:1.0918469429016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:1.0919089317322 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='8351'DB:business_master_new
loadtime:1.0924451351166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:1.0925099849701 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='8351'DB:business_master_new
loadtime:1.1052849292755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:1.1053690910339 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='8351'DB:business_master_new
loadtime:1.1065261363983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:1.1065900325775 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='8351'DB:business_master_new
loadtime:1.1117000579834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:1.1117789745331 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='8351'DB:business_master_new
loadtime:1.1182401180267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.118320941925 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='8351'DB:business_master_new
loadtime:1.1191399097443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:1.119215965271 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='8351'DB:business_master_new
loadtime:1.1271440982819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:1.1272261142731 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='8351'DB:business_master_new
loadtime:1.1430840492249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:1.1431839466095 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='8351'DB:business_master_new
loadtime:1.1469130516052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.1469941139221 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='8351'DB:business_master_new
loadtime:1.1536190509796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:1.1537179946899 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='8351'DB:business_master_new
loadtime:1.1548490524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.1549129486084 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='8351'DB:business_master_new
loadtime:1.156494140625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.156574010849 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='8351'DB:business_master_new
loadtime:1.1655540466309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:1.1656401157379 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='8351'DB:business_master_new
loadtime:1.170520067215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:1.170599937439 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='8351'DB:business_master_new
loadtime:1.1711270809174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:1.1711890697479 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='8351'DB:business_master_new
loadtime:1.1724290847778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:1.1724910736084 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='8351'DB:business_master_new
loadtime:1.1909871101379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:1.1910741329193 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='8351'DB:business_master_new
loadtime:1.1916611194611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:1.1917331218719 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='8351'DB:business_master_new
loadtime:1.1999769210815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:1.2000670433044 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='8351'DB:business_master_new
loadtime:1.2045979499817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:1.2046909332275 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='8351'DB:business_master_new
loadtime:1.2124540805817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:1.2125420570374 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='8351'DB:business_master_new
loadtime:1.2242870330811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.2243790626526 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='8351'DB:business_master_new
loadtime:1.2254431247711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.225527048111 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='8351'DB:business_master_new
loadtime:1.2332730293274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:1.23335313797 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='8351'DB:business_master_new
loadtime:1.2338230609894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.2338860034943 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='8351'DB:business_master_new
loadtime:1.2392101287842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.2392930984497 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='8351'DB:business_master_new
loadtime:1.2414679527283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:1.2415509223938 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='8351'DB:business_master_new
loadtime:1.2436261177063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.2436969280243 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='8351'DB:business_master_new
loadtime:1.2633581161499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:1.2634580135345 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='8351'DB:business_master_new
loadtime:1.2688589096069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:1.2689399719238 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='8351'DB:business_master_new
loadtime:1.2698991298676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:1.2699611186981 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='8351'DB:business_master_new
loadtime:1.27401304245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.2741000652313 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='8351'DB:business_master_new
loadtime:1.2792000770569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:1.2792799472809 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='8351'DB:business_master_new
loadtime:1.2799360752106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:1.2799980640411 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='8351'DB:business_master_new
loadtime:1.296226978302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:1.2963240146637 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='8351'DB:business_master_new
loadtime:1.2973210811615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.2974009513855 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='8351'DB:business_master_new
loadtime:1.3128530979156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:1.3129470348358 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='8351'DB:business_master_new
loadtime:1.3133981227875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.3134620189667 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='8351'DB:business_master_new
loadtime:1.3178589344025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.317939043045 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='8351'DB:business_master_new
loadtime:1.3187000751495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.3187749385834 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='8351'DB:business_master_new
loadtime:1.3248779773712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:1.3249580860138 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='8351'DB:business_master_new
loadtime:1.3309149742126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.3309960365295 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='8351'DB:business_master_new
loadtime:1.3583149909973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:1.3584189414978 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='8351'DB:business_master_new
loadtime:1.3664140701294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:1.3665130138397 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='8351'DB:business_master_new
loadtime:1.3704850673676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.3705670833588 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='8351'DB:business_master_new
loadtime:1.3912250995636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:1.3913240432739 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='8351'DB:business_master_new
loadtime:1.3960049152374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:1.3960869312286 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='8351'DB:business_master_new
loadtime:1.412859916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:1.4129519462585 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='8351'DB:business_master_new
loadtime:1.4135830402374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.4136469364166 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='8351'DB:business_master_new
loadtime:1.4164590835571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:1.4165389537811 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='8351'DB:business_master_new
loadtime:1.417503118515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:1.4175789356232 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='8351'DB:business_master_new
loadtime:1.4261679649353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:1.4262599945068 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='8351'DB:business_master_new
loadtime:1.4374511241913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.4375479221344 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='8351'DB:business_master_new
loadtime:1.4417400360107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:1.4418210983276 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='8351'DB:business_master_new
loadtime:1.460529088974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:1.4606230258942 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='8351'DB:business_master_new
loadtime:1.4705181121826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:1.4706070423126 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='8351'DB:business_master_new
loadtime:1.4711589813232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:1.471223115921 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='8351'DB:business_master_new
loadtime:1.4761919975281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:1.4762709140778 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='8351'DB:business_master_new
loadtime:1.4843521118164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:1.4844310283661 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='8351'DB:business_master_new
loadtime:1.4904770851135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:1.4905729293823 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='8351'DB:business_master_new
loadtime:1.495304107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:1.4953849315643 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='8351'DB:business_master_new
loadtime:1.5011639595032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:1.5012440681458 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='8351'DB:business_master_new
loadtime:1.5074219703674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:1.5075099468231 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='8351'DB:business_master_new
loadtime:1.5252320766449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:1.5253269672394 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='8351'DB:business_master_new
loadtime:1.531140089035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.5312230587006 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='8351'DB:business_master_new
loadtime:1.5407431125641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:1.5408301353455 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='8351'DB:business_master_new
loadtime:1.5450899600983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:1.5451691150665 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='8351'DB:business_master_new
loadtime:1.5456459522247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:1.5457179546356 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='8351'DB:business_master_new
loadtime:1.5492041110992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:1.5492820739746 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='8351'DB:business_master_new
loadtime:1.5635199546814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:1.5636160373688 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='8351'DB:business_master_new
loadtime:1.5727820396423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:1.5728750228882 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='8351'DB:business_master_new
loadtime:1.573429107666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.5734920501709 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='8351'DB:business_master_new
loadtime:1.5791780948639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.5792579650879 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='8351'DB:business_master_new
loadtime:1.5923309326172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:1.592423915863 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='8351'DB:business_master_new
loadtime:1.5930800437927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:1.5931439399719 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='8351'DB:business_master_new
loadtime:1.5998411178589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:1.5999200344086 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='8351'DB:business_master_new
loadtime:1.6006031036377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:1.6006760597229 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='8351'DB:business_master_new
loadtime:1.6056079864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:1.6056981086731 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='8351'DB:business_master_new
loadtime:1.6067199707031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.6067819595337 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='8351'DB:business_master_new
loadtime:1.6149151325226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:1.6150040626526 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='8351'DB:business_master_new
loadtime:1.6154670715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:1.6155350208282 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='8351'DB:business_master_new
loadtime:1.6159701347351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:1.6160299777985 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='8351'DB:business_master_new
loadtime:1.6164469718933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:1.6165111064911 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='8351'DB:business_master_new
loadtime:1.616975069046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:1.6170361042023 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='8351'DB:business_master_new
loadtime:1.6200721263885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:1.6201529502869 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='8351'DB:business_master_new
loadtime:1.6214520931244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:1.6215200424194 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='8351'DB:business_master_new
loadtime:1.6222689151764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.6223289966583 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='8351'DB:business_master_new
loadtime:1.6228039264679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:1.6228649616241 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='8351'DB:business_master_new
loadtime:1.6235859394073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:1.6236469745636 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='8351'DB:business_master_new
loadtime:1.6424899101257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:1.6425709724426 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='8351'DB:business_master_new
loadtime:1.6549510955811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:1.6550390720367 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='8351'DB:business_master_new
loadtime:1.6725339889526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:1.6726319789886 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='8351'DB:business_master_new
loadtime:1.6910071372986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:1.6910989284515 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='8351'DB:business_master_new
loadtime:1.7001719474792 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:1.7002580165863 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='8351'DB:business_master_new
loadtime:1.7007241249084 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:1.7007870674133 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='8351'DB:business_master_new
loadtime:1.7302529811859 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:1.730376958847 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='8351'DB:business_master_new
loadtime:1.7312560081482 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:1.7313220500946 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='8351'DB:business_master_new
loadtime:1.7318661212921 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:1.7319269180298 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='8351'DB:business_master_new
loadtime:1.7326700687408 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:1.7327311038971 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='8351'DB:business_master_new
loadtime:1.7332649230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.733325958252 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='8351'DB:business_master_new
loadtime:1.7368021011353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:1.7368791103363 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='8351'DB:business_master_new
loadtime:1.7501480579376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.7502341270447 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='8351'DB:business_master_new
loadtime:1.759959936142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:1.7600450515747 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='8351'DB:business_master_new
loadtime:1.7716529369354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:1.7717499732971 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='8351'DB:business_master_new
loadtime:1.7770819664001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:1.777163028717 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='8351'DB:business_master_new
loadtime:1.7790439128876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:1.7791221141815 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='8351'DB:business_master_new
loadtime:1.7795629501343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:1.7796249389648 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='8351'DB:business_master_new
loadtime:1.7846789360046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:1.7847590446472 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='8351'DB:business_master_new
loadtime:1.7852129936218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:1.7852749824524 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='8351'DB:business_master_new
loadtime:1.7910161018372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:1.7911009788513 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='8351'DB:business_master_new
loadtime:1.7915260791779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:1.7915921211243 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='8351'DB:business_master_new
loadtime:1.7961361408234 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:1.7962160110474 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='8351'DB:business_master_new
loadtime:1.8037869930267 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:1.8038740158081 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='8351'DB:business_master_new
loadtime:1.8044140338898 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:1.8044769763947 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='8351'DB:business_master_new
loadtime:1.8167240619659 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:1.8168070316315 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='8351'DB:business_master_new
loadtime:1.8269600868225 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:1.8270471096039 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='8351'DB:business_master_new
loadtime:1.8332829475403 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:1.8333659172058 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:1.8367400169373 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:1.8368170261383 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='8351'DB:business_master_new
loadtime:1.8372371196747 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:1.8372991085052 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='8351'DB:business_master_new
loadtime:1.8378210067749 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:1.8378949165344 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='8351'DB:business_master_new
loadtime:1.8387660980225 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:1.838828086853 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='8351'DB:business_master_new
loadtime:1.8441541194916 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:1.8442339897156 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='8351'DB:business_master_new
loadtime:1.8535130023956 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:1.8535969257355 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='8351'DB:business_master_new
loadtime:1.854973077774 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:1.8550369739532 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='8351'DB:business_master_new
loadtime:1.8562059402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:1.8562679290771 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='8351'DB:business_master_new
loadtime:1.8617990016937 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:1.8618810176849 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='8351'DB:business_master_new
loadtime:1.8623819351196 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:1.8624451160431 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:1.8660490512848 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:1.8661279678345 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='8351'DB:business_master_new
loadtime:1.8703589439392 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:1.8704380989075 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='8351'DB:business_master_new
loadtime:1.8709449768066 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:1.8710069656372 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='8351'DB:business_master_new
loadtime:1.8714830875397 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:1.8715491294861 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='8351'DB:business_master_new
loadtime:1.8728210926056 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:1.8728981018066 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='8351'DB:business_master_new
loadtime:1.8733949661255 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:1.8734569549561 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='8351'DB:business_master_new
loadtime:1.8739399909973 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:1.8740000724792 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='8351'DB:business_master_new
loadtime:1.8816421031952 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:1.881735086441 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='8351'DB:business_master_new
loadtime:1.8822250366211 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:1.882287979126 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='8351'DB:business_master_new
loadtime:1.8834080696106 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:1.8834691047668 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='8351'DB:business_master_new
loadtime:1.8841800689697 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:1.884241104126 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='8351'DB:business_master_new
loadtime:1.8847029209137 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:1.8847639560699 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:1.8870730400085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:1.887148141861 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='8351'DB:business_master_new
loadtime:1.9016900062561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:1.9017779827118 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='8351'DB:business_master_new
loadtime:1.9111700057983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:1.9112651348114 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='8351'DB:business_master_new
loadtime:1.9132099151611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.9132890701294 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='8351'DB:business_master_new
loadtime:1.9147160053253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:1.9147779941559 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='8351'DB:business_master_new
loadtime:1.9210910797119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:1.9211759567261 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='8351'DB:business_master_new
loadtime:1.9291620254517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:1.9292471408844 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='8351'DB:business_master_new
loadtime:1.9460170269012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:1.9461040496826 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='8351'DB:business_master_new
loadtime:1.9465820789337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:1.9466459751129 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='8351'DB:business_master_new
loadtime:1.9517769813538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:1.951856136322 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='8351'DB:business_master_new
loadtime:1.9528489112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:1.9529111385345 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='8351'DB:business_master_new
loadtime:1.9533529281616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:1.9534139633179 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='8351'DB:business_master_new
loadtime:1.954353094101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.9544150829315 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='8351'DB:business_master_new
loadtime:1.9588279724121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:1.9589109420776 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='8351'DB:business_master_new
loadtime:1.9673299789429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:1.9674091339111 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='8351'DB:business_master_new
loadtime:1.9725370407104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:1.9726159572601 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='8351'DB:business_master_new
loadtime:1.9736180305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.9736909866333 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='8351'DB:business_master_new
loadtime:1.9790410995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.979120016098 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='8351'DB:business_master_new
loadtime:1.9850690364838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:1.9851491451263 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='8351'DB:business_master_new
loadtime:1.9867961406708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:1.9868729114532 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='8351'DB:business_master_new
loadtime:2.0061259269714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:2.0062201023102 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='8351'DB:business_master_new
loadtime:2.0067009925842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:2.0067660808563 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='8351'DB:business_master_new
loadtime:2.0151450634003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:2.0152270793915 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='8351'DB:business_master_new
loadtime:2.020651102066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:2.0207419395447 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='8351'DB:business_master_new
loadtime:2.0212280750275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:2.0212910175323 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='8351'DB:business_master_new
loadtime:2.0223400592804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:2.022402048111 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='8351'DB:business_master_new
loadtime:2.0229001045227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:2.022961139679 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='8351'DB:business_master_new
loadtime:2.0234160423279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:2.0234761238098 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='8351'DB:business_master_new
loadtime:2.0431609153748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:2.043270111084 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='8351'DB:business_master_new
loadtime:2.0439510345459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:2.044016122818 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='8351'DB:business_master_new
loadtime:2.0490341186523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:2.0491149425507 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.0709691047668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:2.0710709095001 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='8351'DB:business_master_new
loadtime:2.0727450847626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:2.0728240013123 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='8351'DB:business_master_new
loadtime:2.0763649940491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:2.0764420032501 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='8351'DB:business_master_new
loadtime:2.076945066452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:2.0770080089569 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='8351'DB:business_master_new
loadtime:2.0786881446838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:2.0787630081177 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='8351'DB:business_master_new
loadtime:2.086385011673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:2.0864479541779 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='8351'DB:business_master_new
loadtime:2.1149749755859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:2.1150939464569 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='8351'DB:business_master_new
loadtime:2.1249380111694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:2.1250350475311 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='8351'DB:business_master_new
loadtime:2.1322989463806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:2.1323850154877 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='8351'DB:business_master_new
loadtime:2.1329410076141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:2.1330051422119 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='8351'DB:business_master_new
loadtime:2.1422650814056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:2.1423499584198 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='8351'DB:business_master_new
loadtime:2.1429369449615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:2.1430020332336 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='8351'DB:business_master_new
loadtime:2.1483640670776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:2.1484460830688 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='8351'DB:business_master_new
loadtime:2.1611130237579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:2.1612010002136 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='8351'DB:business_master_new
loadtime:2.1622269153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:2.1622910499573 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='8351'DB:business_master_new
loadtime:2.1633229255676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.1633970737457 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='8351'DB:business_master_new
loadtime:2.1652500629425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.1653249263763 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='8351'DB:business_master_new
loadtime:2.1734099388123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:2.1734900474548 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='8351'DB:business_master_new
loadtime:2.1791560649872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:2.1792371273041 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='8351'DB:business_master_new
loadtime:2.1876549720764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:2.1877610683441 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='8351'DB:business_master_new
loadtime:2.1883809566498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:2.1884460449219 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='8351'DB:business_master_new
loadtime:2.1932399272919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:2.1933200359344 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='8351'DB:business_master_new
loadtime:2.2021250724792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:2.2022190093994 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='8351'DB:business_master_new
loadtime:2.2049360275269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:2.2050189971924 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='8351'DB:business_master_new
loadtime:2.2057819366455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:2.2058439254761 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='8351'DB:business_master_new
loadtime:2.2066550254822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:2.2067251205444 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='8351'DB:business_master_new
loadtime:2.2090020179749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:2.2090790271759 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='8351'DB:business_master_new
loadtime:2.210205078125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:2.2102680206299 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.2119660377502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.2120411396027 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='8351'DB:business_master_new
loadtime:2.2297389507294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:2.2298390865326 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='8351'DB:business_master_new
loadtime:2.236289024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:2.2363741397858 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.2368431091309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:2.2369060516357 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='8351'DB:business_master_new
loadtime:2.237694978714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:2.2377569675446 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='8351'DB:business_master_new
loadtime:2.245542049408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:2.2456209659576 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='8351'DB:business_master_new
loadtime:2.2565851211548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:2.2566781044006 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='8351'DB:business_master_new
loadtime:2.2572710514069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:2.2573471069336 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='8351'DB:business_master_new
loadtime:2.2649710178375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:2.2650549411774 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='8351'DB:business_master_new
loadtime:2.2728929519653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.2729859352112 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='8351'DB:business_master_new
loadtime:2.2797451019287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:2.2798359394073 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='8351'DB:business_master_new
loadtime:2.2822980880737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:2.2823741436005 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='8351'DB:business_master_new
loadtime:2.2861649990082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:2.2862420082092 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='8351'DB:business_master_new
loadtime:2.2867479324341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:2.2868220806122 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='8351'DB:business_master_new
loadtime:2.2901990413666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:2.2902779579163 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='8351'DB:business_master_new
loadtime:2.2937109470367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:2.2937879562378 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='8351'DB:business_master_new
loadtime:2.3079259395599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:2.3080160617828 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='8351'DB:business_master_new
loadtime:2.3087899684906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:2.3088529109955 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='8351'DB:business_master_new
loadtime:2.3095419406891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:2.309602022171 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.3101389408112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.3101999759674 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='8351'DB:business_master_new
loadtime:2.3164370059967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:2.3165240287781 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='8351'DB:business_master_new
loadtime:2.3378350734711 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:2.3379271030426 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='8351'DB:business_master_new
loadtime:2.33855509758 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:2.3386189937592 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='8351'DB:business_master_new
loadtime:2.3393471240997 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:2.3394069671631 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='8351'DB:business_master_new
loadtime:2.3400330543518 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:2.3400950431824 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='8351'DB:business_master_new
loadtime:2.3412201404572 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:2.3412809371948 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='8351'DB:business_master_new
loadtime:2.341717004776 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:2.3417780399323 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.3468170166016 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:2.3468990325928 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='8351'DB:business_master_new
loadtime:2.3497009277344 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:2.3497791290283 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='8351'DB:business_master_new
loadtime:2.3547899723053 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:2.3548679351807 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='8351'DB:business_master_new
loadtime:2.361841917038 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:2.3619210720062 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='8351'DB:business_master_new
loadtime:2.3627679347992 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:2.362832069397 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='8351'DB:business_master_new
loadtime:2.3640520572662 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:2.3641140460968 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='8351'DB:business_master_new
loadtime:2.3701000213623 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:2.3701839447021 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='8351'DB:business_master_new
loadtime:2.3729231357574 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:2.3730039596558 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='8351'DB:business_master_new
loadtime:2.3735899925232 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:2.3736519813538 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='8351'DB:business_master_new
loadtime:2.3743469715118 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:2.3744070529938 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='8351'DB:business_master_new
loadtime:2.3749899864197 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:2.3750510215759 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='8351'DB:business_master_new
loadtime:2.3757269382477 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:2.3757889270782 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='8351'DB:business_master_new
loadtime:2.3763830661774 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:2.3764569759369 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='8351'DB:business_master_new
loadtime:2.3772270679474 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:2.377289056778 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.384202003479 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:2.384290933609 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.3913459777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:2.3914251327515 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='8351'DB:business_master_new
loadtime:2.3934280872345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:2.3935089111328 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='8351'DB:business_master_new
loadtime:2.399698972702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:2.3997869491577 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.4067299365997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.4068109989166 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='8351'DB:business_master_new
loadtime:2.40744805336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:2.4075169563293 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='8351'DB:business_master_new
loadtime:2.4126811027527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.4127650260925 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='8351'DB:business_master_new
loadtime:2.4187381267548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.4188189506531 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='8351'DB:business_master_new
loadtime:2.4626970291138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.4628660678864 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='8351'DB:business_master_new
loadtime:2.467710018158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:2.467796087265 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='8351'DB:business_master_new
loadtime:2.4683470726013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.4684090614319 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.4702079296112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:2.4702849388123 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='8351'DB:business_master_new
loadtime:2.4803309440613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:2.4804179668427 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='8351'DB:business_master_new
loadtime:2.4935319423676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:2.4936199188232 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='8351'DB:business_master_new
loadtime:2.4983730316162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:2.4984560012817 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.5035269260406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:2.5036120414734 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='8351'DB:business_master_new
loadtime:2.5126550197601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:2.5127599239349 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='8351'DB:business_master_new
loadtime:2.5142531394958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:2.5143189430237 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='8351'DB:business_master_new
loadtime:2.5191090106964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:2.5191910266876 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='8351'DB:business_master_new
loadtime:2.5255370140076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:2.5256199836731 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='8351'DB:business_master_new
loadtime:2.532753944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:2.5328330993652 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='8351'DB:business_master_new
loadtime:2.5483570098877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:2.5484471321106 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='8351'DB:business_master_new
loadtime:2.5489010810852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:2.5489649772644 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='8351'DB:business_master_new
loadtime:2.550528049469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:2.5506029129028 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='8351'DB:business_master_new
loadtime:2.5647621154785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:2.5648579597473 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='8351'DB:business_master_new
loadtime:2.565505027771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.5655839443207 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='8351'DB:business_master_new
loadtime:2.5668029785156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:2.5668771266937 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='8351'DB:business_master_new
loadtime:2.5672969818115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:2.5673580169678 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='8351'DB:business_master_new
loadtime:2.5725679397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.5726499557495 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='8351'DB:business_master_new
loadtime:2.5752389431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:2.5753171443939 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='8351'DB:business_master_new
loadtime:2.5766820907593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:2.5767440795898 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='8351'DB:business_master_new
loadtime:2.5803260803223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:2.5804040431976 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='8351'DB:business_master_new
loadtime:2.5867171287537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:2.5867991447449 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='8351'DB:business_master_new
loadtime:2.5873460769653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:2.5874090194702 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='8351'DB:business_master_new
loadtime:2.5914540290833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:2.591539144516 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.5980110168457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:2.5980899333954 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='8351'DB:business_master_new
loadtime:2.5985651016235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:2.5986270904541 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='8351'DB:business_master_new
loadtime:2.6070420742035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:2.6071190834045 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='8351'DB:business_master_new
loadtime:2.6075749397278 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:2.6076369285583 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='8351'DB:business_master_new
loadtime:2.6081020832062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:2.6081631183624 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='8351'DB:business_master_new
loadtime:2.6103069782257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.6103839874268 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='8351'DB:business_master_new
loadtime:2.6239590644836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.6240501403809 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='8351'DB:business_master_new
loadtime:2.625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:2.625077009201 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='8351'DB:business_master_new
loadtime:2.6347949504852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:2.6348779201508 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='8351'DB:business_master_new
loadtime:2.6638600826263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:2.6639699935913 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='8351'DB:business_master_new
loadtime:2.6644611358643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:2.6645309925079 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='8351'DB:business_master_new
loadtime:2.6649899482727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:2.665050983429 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='8351'DB:business_master_new
loadtime:2.6699969768524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:2.6700780391693 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='8351'DB:business_master_new
loadtime:2.6770980358124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.6771819591522 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='8351'DB:business_master_new
loadtime:2.6784949302673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:2.6785769462585 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='8351'DB:business_master_new
loadtime:2.6791989803314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.679260969162 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='8351'DB:business_master_new
loadtime:2.6797320842743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.6797931194305 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='8351'DB:business_master_new
loadtime:2.694344997406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:2.6944401264191 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='8351'DB:business_master_new
loadtime:2.6949470043182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.695011138916 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='8351'DB:business_master_new
loadtime:2.7016539573669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.7017540931702 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='8351'DB:business_master_new
loadtime:2.7091770172119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:2.7092580795288 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='8351'DB:business_master_new
loadtime:2.7178280353546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:2.7179090976715 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='8351'DB:business_master_new
loadtime:2.7292520999908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:2.7293400764465 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='8351'DB:business_master_new
loadtime:2.7322311401367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:2.7323100566864 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='8351'DB:business_master_new
loadtime:2.7330629825592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:2.7331259250641 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='8351'DB:business_master_new
loadtime:2.7336061000824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:2.7336759567261 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='8351'DB:business_master_new
loadtime:2.7352950572968 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:2.7353711128235 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='8351'DB:business_master_new
loadtime:2.7389600276947 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:2.7390379905701 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='8351'DB:business_master_new
loadtime:2.7395579814911 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:2.739620923996 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='8351'DB:business_master_new
loadtime:2.7453079223633 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:2.7453880310059 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='8351'DB:business_master_new
loadtime:2.7513959407806 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:2.7514779567719 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='8351'DB:business_master_new
loadtime:2.753319978714 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:2.7533950805664 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='8351'DB:business_master_new
loadtime:2.7541959285736 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:2.7542719841003 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='8351'DB:business_master_new
loadtime:2.7547609806061 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:2.7548229694366 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='8351'DB:business_master_new
loadtime:2.7552599906921 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:2.7553200721741 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='8351'DB:business_master_new
loadtime:2.7570390701294 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:2.75710105896 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.7580001354218 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:2.7580599784851 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='8351'DB:business_master_new
loadtime:2.7586579322815 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:2.7587289810181 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='8351'DB:business_master_new
loadtime:2.7600779533386 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:2.7601540088654 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='8351'DB:business_master_new
loadtime:2.7610621452332 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:2.7611241340637 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='8351'DB:business_master_new
loadtime:2.7616491317749 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:2.7617199420929 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='8351'DB:business_master_new
loadtime:2.7621779441833 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:2.7622399330139 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='8351'DB:business_master_new
loadtime:2.7626810073853 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:2.7627410888672 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='8351'DB:business_master_new
loadtime:2.7645161151886 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:2.7645959854126 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='8351'DB:business_master_new
loadtime:2.7702050209045 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:2.7702939510345 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='8351'DB:business_master_new
loadtime:2.7791569232941 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:2.7792420387268 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='8351'DB:business_master_new
loadtime:2.7796769142151 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.7797410488129 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='8351'DB:business_master_new
loadtime:2.7954149246216 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:2.79549908638 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='8351'DB:business_master_new
loadtime:2.796648979187 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:2.7967231273651 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='8351'DB:business_master_new
loadtime:2.8001029491425 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:2.8001799583435 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='8351'DB:business_master_new
loadtime:2.8011441230774 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:2.8012199401855 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='8351'DB:business_master_new
loadtime:2.8025069236755 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:2.802570104599 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='8351'DB:business_master_new
loadtime:2.8033211231232 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:2.8033809661865 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='8351'DB:business_master_new
loadtime:2.8038439750671 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:2.8039050102234 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='8351'DB:business_master_new
loadtime:2.8091280460358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:2.8092060089111 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='8351'DB:business_master_new
loadtime:2.8231999874115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.8232879638672 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='8351'DB:business_master_new
loadtime:2.8376851081848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:2.8377721309662 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='8351'DB:business_master_new
loadtime:2.8475639820099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:2.8476519584656 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='8351'DB:business_master_new
loadtime:2.8480989933014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:2.8481631278992 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='8351'DB:business_master_new
loadtime:2.8522639274597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.8523449897766 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='8351'DB:business_master_new
loadtime:2.8578650951385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.8579559326172 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='8351'DB:business_master_new
loadtime:2.8652110099792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:2.8652939796448 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='8351'DB:business_master_new
loadtime:2.8658459186554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:2.8659090995789 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='8351'DB:business_master_new
loadtime:2.8733580112457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:2.8734450340271 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='8351'DB:business_master_new
loadtime:2.8796000480652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:2.8796870708466 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='8351'DB:business_master_new
loadtime:2.8806419372559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:2.8807139396667 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='8351'DB:business_master_new
loadtime:2.881187915802 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:2.8812489509583 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='8351'DB:business_master_new
loadtime:2.8817040920258 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:2.881765127182 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='8351'DB:business_master_new
loadtime:2.8822569847107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:2.8823170661926 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='8351'DB:business_master_new
loadtime:2.8872010707855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:2.8872799873352 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='8351'DB:business_master_new
loadtime:2.8930470943451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:2.8931341171265 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='8351'DB:business_master_new
loadtime:2.8997430801392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:2.8998279571533 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='8351'DB:business_master_new
loadtime:2.9002730846405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.9003360271454 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='8351'DB:business_master_new
loadtime:2.9019799232483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:2.9020569324493 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='8351'DB:business_master_new
loadtime:2.9070570468903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:2.9071369171143 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='8351'DB:business_master_new
loadtime:2.9173610210419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:2.9174439907074 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='8351'DB:business_master_new
loadtime:2.9219660758972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:2.9220430850983 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='8351'DB:business_master_new
loadtime:2.9225101470947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:2.9225759506226 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='8351'DB:business_master_new
loadtime:2.9231231212616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.9231839179993 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='8351'DB:business_master_new
loadtime:2.9328210353851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.9329040050507 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='8351'DB:business_master_new
loadtime:2.9336020946503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.9336750507355 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='8351'DB:business_master_new
loadtime:2.9403369426727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:2.9404261112213 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='8351'DB:business_master_new
loadtime:2.9634780883789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:2.9635829925537 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='8351'DB:business_master_new
loadtime:2.9640100002289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:2.9640741348267 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='8351'DB:business_master_new
loadtime:2.9653749465942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.9654529094696 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='8351'DB:business_master_new
loadtime:2.965980052948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:2.9660420417786 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='8351'DB:business_master_new
loadtime:2.9849269390106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:2.9850859642029 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='8351'DB:business_master_new
loadtime:2.985552072525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:2.9856219291687 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='8351'DB:business_master_new
loadtime:2.9865701198578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:2.9866309165955 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='8351'DB:business_master_new
loadtime:2.9933590888977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:2.9934411048889 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='8351'DB:business_master_new
loadtime:2.9981899261475 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.9983599185944 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.998822927475 / seconds
Operation template executed (chunk cache operation)
loadtime:2.9989840984344 / seconds
template override:Default
loadtime:2.9990270137787 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:3.0008289813995 / seconds
Template Constructed, Array Rows:49
loadtime:3.0013539791107 / seconds
TOTAL EXECUTION TIME: 3.00092
loadtime:3.0043289661407 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => child-day-care-services [stateURLid] => massachusetts )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:3.0043389797211
TOTAL KEY ARRAYS: 69