Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.8889389038086E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017919540405273 / seconds
host not found setting manual db connection
loadtime:0.0095608234405518 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097990036010742 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099468231201172 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010005950927734 / seconds
zipcode:
loadtime:0.010033845901489 / seconds
Query Executed:select * from search_referrer where page_hash='4ff10845542d45dd88f6244b0ce252f8' limit 10 DB:ezrox_toadli
loadtime:0.010244846343994 / seconds
Operation header executed (non global)
loadtime:0.010272979736328 / seconds
Operation leaderboard executed (non global)
loadtime:0.01032280921936 / seconds
Operation square executed (non global)
loadtime:0.010352849960327 / seconds
Operation square_bottom executed (non global)
loadtime:0.010379791259766 / seconds
Operation smallsquare executed (non global)
loadtime:0.010406017303467 / seconds
Operation headeradright executed (non global)
loadtime:0.010430812835693 / seconds
Operation google_analytics executed (non global)
loadtime:0.010455846786499 / seconds
Operation topstories executed (non global)
loadtime:0.010481834411621 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010507822036743 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010532855987549 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010792970657349 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010981798171997 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011022806167603 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011082887649536 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011129856109619 / seconds
Template key: archive_menu pushed
loadtime:0.011138916015625 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011152982711792 / seconds
Template key: get_gravatar pushed
loadtime:0.011159896850586 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011168956756592 / seconds
*10)-10)+1 | start:0
loadtime:0.011207818984985 / seconds
Query loaded from cache:select * from categories where cat_URLid='gasoline-service-station'
loadtime:0.011248826980591 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.011283874511719 / seconds
DB connected to localhost business_master_new
loadtime:0.011518001556396 / seconds
Query Executed:select * from `ma_catmap` where sic='5541' order by city ascDB:business_master_new
loadtime:0.021828889846802 / seconds
Query stored in cache : _QUERY_www.toadli.com2fbcc6255000254918afa9366b33d655
loadtime:0.024030923843384 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.024091958999634 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='5541'DB:business_master_new
loadtime:0.02705979347229 / seconds
Query stored in cache : _QUERY_www.toadli.coma5e2cc9425767034d7dc8403b112965f
loadtime:0.027099847793579 / seconds
559 / 11
loadtime:0.027156829833984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.027222871780396 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='5541'DB:business_master_new
loadtime:0.039042949676514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.039127826690674 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='5541'DB:business_master_new
loadtime:0.039677858352661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.039739847183228 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='5541'DB:business_master_new
loadtime:0.05056095123291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.050650835037231 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='5541'DB:business_master_new
loadtime:0.054738998413086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.054829835891724 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='5541'DB:business_master_new
loadtime:0.058897018432617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.0589759349823 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='5541'DB:business_master_new
loadtime:0.066128969192505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.066210985183716 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='5541'DB:business_master_new
loadtime:0.066622018814087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.066685914993286 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='5541'DB:business_master_new
loadtime:0.07507586479187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.075156927108765 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='5541'DB:business_master_new
loadtime:0.082435846328735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.082518815994263 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='5541'DB:business_master_new
loadtime:0.093116998672485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.093199968338013 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='5541'DB:business_master_new
loadtime:0.10742688179016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.10751485824585 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='5541'DB:business_master_new
loadtime:0.10795879364014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.1080219745636 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='5541'DB:business_master_new
loadtime:0.12146186828613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.12154793739319 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='5541'DB:business_master_new
loadtime:0.12200689315796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.12206983566284 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='5541'DB:business_master_new
loadtime:0.12247681617737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.1225368976593 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='5541'DB:business_master_new
loadtime:0.12552785873413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.1255898475647 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='5541'DB:business_master_new
loadtime:0.12701487541199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.12707591056824 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='5541'DB:business_master_new
loadtime:0.12813782691956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.12819886207581 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='5541'DB:business_master_new
loadtime:0.13527584075928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.13535785675049 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.13602089881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.13608384132385 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='5541'DB:business_master_new
loadtime:0.13784098625183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.13791489601135 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='5541'DB:business_master_new
loadtime:0.14328479766846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.14336681365967 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='5541'DB:business_master_new
loadtime:0.15630388259888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.15639400482178 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='5541'DB:business_master_new
loadtime:0.15791583061218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.15799283981323 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='5541'DB:business_master_new
loadtime:0.16743898391724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.1675238609314 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='5541'DB:business_master_new
loadtime:0.17165780067444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.17173981666565 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='5541'DB:business_master_new
loadtime:0.17573595046997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.17582201957703 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='5541'DB:business_master_new
loadtime:0.18010592460632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.18018293380737 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='5541'DB:business_master_new
loadtime:0.18063282966614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.1806948184967 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='5541'DB:business_master_new
loadtime:0.18182897567749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.18189001083374 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='5541'DB:business_master_new
loadtime:0.18524885177612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.18531084060669 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='5541'DB:business_master_new
loadtime:0.18853497505188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.18861794471741 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='5541'DB:business_master_new
loadtime:0.18903279304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.18909502029419 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='5541'DB:business_master_new
loadtime:0.19019794464111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.19025897979736 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='5541'DB:business_master_new
loadtime:0.19779992103577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.19788098335266 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='5541'DB:business_master_new
loadtime:0.20248079299927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.20255899429321 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='5541'DB:business_master_new
loadtime:0.2087869644165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.20886588096619 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='5541'DB:business_master_new
loadtime:0.21895694732666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.21904802322388 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='5541'DB:business_master_new
loadtime:0.22067379951477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.22075080871582 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='5541'DB:business_master_new
loadtime:0.22128200531006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.22134399414062 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='5541'DB:business_master_new
loadtime:0.22285795211792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.22293186187744 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='5541'DB:business_master_new
loadtime:0.22414898872375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.22422480583191 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='5541'DB:business_master_new
loadtime:0.240886926651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:0.24098181724548 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='5541'DB:business_master_new
loadtime:0.25067186355591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.25075697898865 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='5541'DB:business_master_new
loadtime:0.25396585464478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:0.25404191017151 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='5541'DB:business_master_new
loadtime:0.25484299659729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.25491881370544 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='5541'DB:business_master_new
loadtime:0.25795102119446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:0.25802683830261 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='5541'DB:business_master_new
loadtime:0.25866389274597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.25872492790222 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='5541'DB:business_master_new
loadtime:0.27233600616455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:0.27244591712952 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='5541'DB:business_master_new
loadtime:0.27344298362732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:0.27350783348083 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='5541'DB:business_master_new
loadtime:0.27669596672058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:0.27678298950195 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='5541'DB:business_master_new
loadtime:0.2797999382019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:0.27986288070679 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='5541'DB:business_master_new
loadtime:0.28281092643738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.28288888931274 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='5541'DB:business_master_new
loadtime:0.28332281112671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:0.28338479995728 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='5541'DB:business_master_new
loadtime:0.30055284500122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:0.30065178871155 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='5541'DB:business_master_new
loadtime:0.30125284194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.30131697654724 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='5541'DB:business_master_new
loadtime:0.30715179443359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.30722784996033 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:0.31420683860779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.314297914505 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='5541'DB:business_master_new
loadtime:0.32575082778931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:0.325847864151 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='5541'DB:business_master_new
loadtime:0.3275408744812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:0.32760882377625 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='5541'DB:business_master_new
loadtime:0.35254979133606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.35266995429993 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='5541'DB:business_master_new
loadtime:0.35409688949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.35416197776794 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='5541'DB:business_master_new
loadtime:0.37414693832397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:0.37423586845398 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='5541'DB:business_master_new
loadtime:0.37479782104492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:0.37485980987549 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='5541'DB:business_master_new
loadtime:0.37528681755066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:0.37534689903259 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='5541'DB:business_master_new
loadtime:0.37591195106506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:0.37597298622131 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='5541'DB:business_master_new
loadtime:0.37658286094666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.3766508102417 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='5541'DB:business_master_new
loadtime:0.38944292068481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:0.38952779769897 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='5541'DB:business_master_new
loadtime:0.39591884613037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:0.3960018157959 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='5541'DB:business_master_new
loadtime:0.39736390113831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.39743900299072 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='5541'DB:business_master_new
loadtime:0.44544386863708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.44558596611023 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='5541'DB:business_master_new
loadtime:0.45702981948853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.45711588859558 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='5541'DB:business_master_new
loadtime:0.45933389663696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:0.4594099521637 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='5541'DB:business_master_new
loadtime:0.46388101577759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:0.46396088600159 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='5541'DB:business_master_new
loadtime:0.46521282196045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.46527695655823 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='5541'DB:business_master_new
loadtime:0.47040796279907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:0.47048687934875 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='5541'DB:business_master_new
loadtime:0.47148990631104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.47155380249023 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='5541'DB:business_master_new
loadtime:0.47893500328064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:0.47901082038879 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='5541'DB:business_master_new
loadtime:0.48414087295532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:0.48421692848206 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='5541'DB:business_master_new
loadtime:0.48477292060852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:0.48483490943909 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='5541'DB:business_master_new
loadtime:0.48530292510986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:0.4853630065918 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='5541'DB:business_master_new
loadtime:0.48591279983521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.48597478866577 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='5541'DB:business_master_new
loadtime:0.49182295799255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:0.49189901351929 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='5541'DB:business_master_new
loadtime:0.50388097763062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.50396800041199 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='5541'DB:business_master_new
loadtime:0.51394081115723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:0.51402282714844 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='5541'DB:business_master_new
loadtime:0.51508188247681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.51515984535217 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='5541'DB:business_master_new
loadtime:0.51643085479736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.51649284362793 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='5541'DB:business_master_new
loadtime:0.5173168182373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.51737999916077 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='5541'DB:business_master_new
loadtime:0.51815485954285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:0.51821494102478 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='5541'DB:business_master_new
loadtime:0.5250678062439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:0.52514696121216 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='5541'DB:business_master_new
loadtime:0.53901481628418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:0.53910684585571 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='5541'DB:business_master_new
loadtime:0.54078698158264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:0.5408627986908 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='5541'DB:business_master_new
loadtime:0.54128098487854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.54134297370911 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='5541'DB:business_master_new
loadtime:0.54671001434326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:0.54680585861206 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='5541'DB:business_master_new
loadtime:0.55189180374146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:0.55197501182556 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='5541'DB:business_master_new
loadtime:0.5528838634491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.55296301841736 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='5541'DB:business_master_new
loadtime:0.56518983840942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.56527185440063 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='5541'DB:business_master_new
loadtime:0.56626081466675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:0.5663378238678 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='5541'DB:business_master_new
loadtime:0.56809687614441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:0.56817293167114 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='5541'DB:business_master_new
loadtime:0.56871700286865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:0.56878995895386 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='5541'DB:business_master_new
loadtime:0.56966996192932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:0.56973099708557 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='5541'DB:business_master_new
loadtime:0.5701858997345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.57024693489075 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='5541'DB:business_master_new
loadtime:0.57329893112183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:0.57337498664856 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='5541'DB:business_master_new
loadtime:0.58778882026672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:0.58787894248962 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='5541'DB:business_master_new
loadtime:0.58850598335266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.58856987953186 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='5541'DB:business_master_new
loadtime:0.59999799728394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.60008597373962 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='5541'DB:business_master_new
loadtime:0.60103893280029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.60111498832703 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='5541'DB:business_master_new
loadtime:0.6047158241272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:0.60480785369873 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='5541'DB:business_master_new
loadtime:0.60811185836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:0.60818982124329 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='5541'DB:business_master_new
loadtime:0.60926294326782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:0.60932588577271 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='5541'DB:business_master_new
loadtime:0.61093688011169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.61101078987122 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='5541'DB:business_master_new
loadtime:0.62815284729004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:0.62824296951294 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='5541'DB:business_master_new
loadtime:0.62869787216187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.62877297401428 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='5541'DB:business_master_new
loadtime:0.63217687606812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.63225388526917 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='5541'DB:business_master_new
loadtime:0.63520884513855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:0.63528394699097 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='5541'DB:business_master_new
loadtime:0.6440908908844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:0.64416790008545 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='5541'DB:business_master_new
loadtime:0.64462399482727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.64468693733215 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='5541'DB:business_master_new
loadtime:0.64854097366333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:0.64862585067749 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='5541'DB:business_master_new
loadtime:0.64980483055115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:0.64986801147461 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='5541'DB:business_master_new
loadtime:0.65646696090698 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.65654587745667 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='5541'DB:business_master_new
loadtime:0.65698480606079 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:0.65704798698425 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='5541'DB:business_master_new
loadtime:0.6580798625946 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:0.65815401077271 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:0.66314601898193 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:0.66322183609009 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='5541'DB:business_master_new
loadtime:0.66443681716919 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:0.66451096534729 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='5541'DB:business_master_new
loadtime:0.6654908657074 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:0.66555285453796 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='5541'DB:business_master_new
loadtime:0.66600894927979 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:0.66607189178467 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='5541'DB:business_master_new
loadtime:0.67322301864624 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:0.67330479621887 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='5541'DB:business_master_new
loadtime:0.67667484283447 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:0.67673802375793 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='5541'DB:business_master_new
loadtime:0.68471598625183 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:0.68480491638184 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='5541'DB:business_master_new
loadtime:0.68522691726685 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:0.68528890609741 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='5541'DB:business_master_new
loadtime:0.68618488311768 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:0.68624591827393 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='5541'DB:business_master_new
loadtime:0.68680596351624 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:0.6868679523468 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='5541'DB:business_master_new
loadtime:0.68727397918701 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:0.68733382225037 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='5541'DB:business_master_new
loadtime:0.69041800498962 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:0.69049882888794 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='5541'DB:business_master_new
loadtime:0.69202494621277 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:0.6921010017395 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='5541'DB:business_master_new
loadtime:0.6927478313446 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:0.69283294677734 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='5541'DB:business_master_new
loadtime:0.6945788860321 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:0.69464492797852 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='5541'DB:business_master_new
loadtime:0.69753193855286 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:0.69761896133423 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='5541'DB:business_master_new
loadtime:0.70385599136353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:0.70393681526184 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='5541'DB:business_master_new
loadtime:0.70639085769653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:0.70646786689758 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='5541'DB:business_master_new
loadtime:0.71333694458008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.71341300010681 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='5541'DB:business_master_new
loadtime:0.71410894393921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:0.71417093276978 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='5541'DB:business_master_new
loadtime:0.72044396400452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:0.7205228805542 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='5541'DB:business_master_new
loadtime:0.72098588943481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:0.72104787826538 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='5541'DB:business_master_new
loadtime:0.7217059135437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.72177791595459 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='5541'DB:business_master_new
loadtime:0.72534990310669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:0.72542595863342 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='5541'DB:business_master_new
loadtime:0.73703193664551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:0.73711681365967 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='5541'DB:business_master_new
loadtime:0.74368500709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:0.74377799034119 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='5541'DB:business_master_new
loadtime:0.76971483230591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.76983094215393 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='5541'DB:business_master_new
loadtime:0.77941179275513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:0.77949690818787 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='5541'DB:business_master_new
loadtime:0.78016185760498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:0.78022480010986 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='5541'DB:business_master_new
loadtime:0.78442287445068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:0.78449892997742 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='5541'DB:business_master_new
loadtime:0.7861659526825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:0.78624200820923 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='5541'DB:business_master_new
loadtime:0.79986500740051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.79995179176331 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='5541'DB:business_master_new
loadtime:0.80461287498474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:0.80468988418579 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='5541'DB:business_master_new
loadtime:0.80513501167297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:0.80519700050354 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='5541'DB:business_master_new
loadtime:0.80632996559143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:0.80640602111816 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='5541'DB:business_master_new
loadtime:0.81409096717834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:0.81417489051819 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='5541'DB:business_master_new
loadtime:0.82705402374268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.82715892791748 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='5541'DB:business_master_new
loadtime:0.83806490898132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.83814883232117 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='5541'DB:business_master_new
loadtime:0.84585189819336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:0.84593200683594 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='5541'DB:business_master_new
loadtime:0.84634590148926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.84640789031982 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='5541'DB:business_master_new
loadtime:0.8505380153656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.85062193870544 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='5541'DB:business_master_new
loadtime:0.85144281387329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:0.85150480270386 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='5541'DB:business_master_new
loadtime:0.85232186317444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.85239601135254 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='5541'DB:business_master_new
loadtime:0.85307693481445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.85313892364502 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='5541'DB:business_master_new
loadtime:0.86708498001099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.8671669960022 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='5541'DB:business_master_new
loadtime:0.86781597137451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.86787796020508 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='5541'DB:business_master_new
loadtime:0.8714599609375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.87152194976807 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='5541'DB:business_master_new
loadtime:0.87404298782349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.87410402297974 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='5541'DB:business_master_new
loadtime:0.87515091896057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:0.87523198127747 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='5541'DB:business_master_new
loadtime:0.8833179473877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:0.88339591026306 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='5541'DB:business_master_new
loadtime:0.88395690917969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:0.88401889801025 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='5541'DB:business_master_new
loadtime:0.88451790809631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.88457894325256 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='5541'DB:business_master_new
loadtime:0.89429688453674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.89437580108643 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='5541'DB:business_master_new
loadtime:0.89903402328491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:0.89911198616028 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='5541'DB:business_master_new
loadtime:0.90218091011047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:0.90225696563721 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='5541'DB:business_master_new
loadtime:0.90716791152954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.90724682807922 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='5541'DB:business_master_new
loadtime:0.9102029800415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.91027998924255 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='5541'DB:business_master_new
loadtime:0.91095900535583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:0.91102194786072 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='5541'DB:business_master_new
loadtime:0.91413187980652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.91420793533325 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='5541'DB:business_master_new
loadtime:0.91486287117004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.91492390632629 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='5541'DB:business_master_new
loadtime:0.92443895339966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:0.92452692985535 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='5541'DB:business_master_new
loadtime:0.92515683174133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:0.92522001266479 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='5541'DB:business_master_new
loadtime:0.92923378944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.92931199073792 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='5541'DB:business_master_new
loadtime:0.93007683753967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:0.93013787269592 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='5541'DB:business_master_new
loadtime:0.93378496170044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:0.93384695053101 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='5541'DB:business_master_new
loadtime:0.93974494934082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:0.93983888626099 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='5541'DB:business_master_new
loadtime:0.94185185432434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:0.94192886352539 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='5541'DB:business_master_new
loadtime:0.94328689575195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:0.94334888458252 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='5541'DB:business_master_new
loadtime:0.94386196136475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.943922996521 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='5541'DB:business_master_new
loadtime:0.96180891990662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:0.96190094947815 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='5541'DB:business_master_new
loadtime:0.9623429775238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:0.96240592002869 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='5541'DB:business_master_new
loadtime:0.96343493461609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:0.96349501609802 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='5541'DB:business_master_new
loadtime:0.9640429019928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:0.96410393714905 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='5541'DB:business_master_new
loadtime:0.97627401351929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.97636294364929 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='5541'DB:business_master_new
loadtime:0.97749996185303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:0.97756385803223 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='5541'DB:business_master_new
loadtime:0.98218894004822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:0.98227000236511 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='5541'DB:business_master_new
loadtime:0.98814082145691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:0.98821902275085 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='5541'DB:business_master_new
loadtime:0.9890239238739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:0.98908591270447 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='5541'DB:business_master_new
loadtime:0.99635696411133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:0.99643683433533 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='5541'DB:business_master_new
loadtime:1.0113799571991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:1.0114657878876 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='5541'DB:business_master_new
loadtime:1.0147190093994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.0147960186005 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='5541'DB:business_master_new
loadtime:1.0208308696747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:1.02090883255 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='5541'DB:business_master_new
loadtime:1.022027015686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.0220899581909 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='5541'DB:business_master_new
loadtime:1.0236508846283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.0237247943878 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='5541'DB:business_master_new
loadtime:1.0319809913635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:1.0320618152618 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='5541'DB:business_master_new
loadtime:1.0364208221436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:1.036495923996 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='5541'DB:business_master_new
loadtime:1.0370337963104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:1.0370960235596 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='5541'DB:business_master_new
loadtime:1.0383138656616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:1.0383899211884 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='5541'DB:business_master_new
loadtime:1.0560269355774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:1.0561130046844 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='5541'DB:business_master_new
loadtime:1.0566968917847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:1.0567708015442 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='5541'DB:business_master_new
loadtime:1.0643639564514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:1.0644428730011 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='5541'DB:business_master_new
loadtime:1.0684659481049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:1.0685458183289 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='5541'DB:business_master_new
loadtime:1.0757319927216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:1.0758259296417 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='5541'DB:business_master_new
loadtime:1.0867919921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.0868718624115 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='5541'DB:business_master_new
loadtime:1.087917804718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.0879797935486 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='5541'DB:business_master_new
loadtime:1.0951538085938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:1.0952379703522 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='5541'DB:business_master_new
loadtime:1.0956959724426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.0957589149475 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='5541'DB:business_master_new
loadtime:1.1005439758301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.1006238460541 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='5541'DB:business_master_new
loadtime:1.1036968231201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:1.1037600040436 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='5541'DB:business_master_new
loadtime:1.1058099269867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.1058838367462 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='5541'DB:business_master_new
loadtime:1.1245448589325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:1.12464594841 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='5541'DB:business_master_new
loadtime:1.1295628547668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:1.1296508312225 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='5541'DB:business_master_new
loadtime:1.1305868625641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:1.1306669712067 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='5541'DB:business_master_new
loadtime:1.1341688632965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.1342439651489 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='5541'DB:business_master_new
loadtime:1.1388008594513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:1.1388788223267 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='5541'DB:business_master_new
loadtime:1.1395108699799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:1.1395728588104 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='5541'DB:business_master_new
loadtime:1.1555299758911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:1.1556339263916 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='5541'DB:business_master_new
loadtime:1.1566109657288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.1566758155823 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='5541'DB:business_master_new
loadtime:1.1712248325348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:1.1713128089905 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='5541'DB:business_master_new
loadtime:1.1717808246613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.1718428134918 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='5541'DB:business_master_new
loadtime:1.1757729053497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.1758499145508 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='5541'DB:business_master_new
loadtime:1.17657995224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.1766469478607 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='5541'DB:business_master_new
loadtime:1.1821780204773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:1.182256937027 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='5541'DB:business_master_new
loadtime:1.187698841095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.1877930164337 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='5541'DB:business_master_new
loadtime:1.2139458656311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:1.2140529155731 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='5541'DB:business_master_new
loadtime:1.2214188575745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:1.2214968204498 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='5541'DB:business_master_new
loadtime:1.225389957428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.225466966629 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='5541'DB:business_master_new
loadtime:1.245208978653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:1.2452998161316 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='5541'DB:business_master_new
loadtime:1.2498819828033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:1.249960899353 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='5541'DB:business_master_new
loadtime:1.2657568454742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:1.2658548355103 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='5541'DB:business_master_new
loadtime:1.2664649486542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.2665288448334 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='5541'DB:business_master_new
loadtime:1.2692840099335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:1.269357919693 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='5541'DB:business_master_new
loadtime:1.2703168392181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:1.2703928947449 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='5541'DB:business_master_new
loadtime:1.2832429409027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:1.2833209037781 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='5541'DB:business_master_new
loadtime:1.293753862381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.293839931488 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='5541'DB:business_master_new
loadtime:1.2975208759308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:1.2975969314575 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='5541'DB:business_master_new
loadtime:1.3153398036957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:1.3154418468475 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='5541'DB:business_master_new
loadtime:1.3247549533844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:1.3248498439789 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='5541'DB:business_master_new
loadtime:1.3253979682922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:1.3254609107971 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='5541'DB:business_master_new
loadtime:1.3299179077148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:1.3299930095673 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='5541'DB:business_master_new
loadtime:1.3374838829041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:1.3375618457794 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='5541'DB:business_master_new
loadtime:1.3430418968201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:1.3431289196014 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='5541'DB:business_master_new
loadtime:1.3473789691925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:1.3474559783936 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='5541'DB:business_master_new
loadtime:1.3527338504791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:1.3528249263763 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='5541'DB:business_master_new
loadtime:1.3584477901459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:1.3585259914398 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='5541'DB:business_master_new
loadtime:1.3752930164337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:1.3753929138184 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='5541'DB:business_master_new
loadtime:1.3806779384613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.380756855011 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='5541'DB:business_master_new
loadtime:1.3896358013153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:1.3897140026093 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='5541'DB:business_master_new
loadtime:1.3934648036957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:1.3935279846191 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='5541'DB:business_master_new
loadtime:1.3940029144287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:1.3940629959106 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='5541'DB:business_master_new
loadtime:1.3970668315887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:1.397127866745 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='5541'DB:business_master_new
loadtime:1.410472869873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:1.4105648994446 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='5541'DB:business_master_new
loadtime:1.4191207885742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:1.4192068576813 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='5541'DB:business_master_new
loadtime:1.4197599887848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.4198338985443 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='5541'DB:business_master_new
loadtime:1.4249618053436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.4250388145447 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='5541'DB:business_master_new
loadtime:1.4372518062592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:1.4373400211334 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='5541'DB:business_master_new
loadtime:1.4379899501801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:1.4380528926849 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='5541'DB:business_master_new
loadtime:1.4441468715668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:1.4442248344421 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='5541'DB:business_master_new
loadtime:1.4449069499969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:1.4449708461761 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='5541'DB:business_master_new
loadtime:1.44939494133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:1.4494698047638 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='5541'DB:business_master_new
loadtime:1.4504718780518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.4505338668823 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='5541'DB:business_master_new
loadtime:1.4580159187317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:1.4580969810486 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='5541'DB:business_master_new
loadtime:1.4585559368134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:1.4586229324341 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='5541'DB:business_master_new
loadtime:1.4590559005737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:1.4591159820557 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='5541'DB:business_master_new
loadtime:1.459529876709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:1.4595899581909 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='5541'DB:business_master_new
loadtime:1.4600529670715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:1.4601140022278 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='5541'DB:business_master_new
loadtime:1.464035987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:1.464115858078 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='5541'DB:business_master_new
loadtime:1.465402841568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:1.465479850769 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='5541'DB:business_master_new
loadtime:1.4662249088287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.4662868976593 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='5541'DB:business_master_new
loadtime:1.4667699337006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:1.4668319225311 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='5541'DB:business_master_new
loadtime:1.4675350189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:1.4675970077515 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='5541'DB:business_master_new
loadtime:1.4804468154907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:1.4805088043213 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='5541'DB:business_master_new
loadtime:1.4920868873596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:1.492164850235 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='5541'DB:business_master_new
loadtime:1.5086419582367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:1.5087258815765 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='5541'DB:business_master_new
loadtime:1.5212118625641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:1.5212910175323 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='5541'DB:business_master_new
loadtime:1.5297048091888 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:1.5297939777374 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='5541'DB:business_master_new
loadtime:1.5302429199219 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:1.5303058624268 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='5541'DB:business_master_new
loadtime:1.5581839084625 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:1.558287858963 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='5541'DB:business_master_new
loadtime:1.5591669082642 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:1.5592308044434 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='5541'DB:business_master_new
loadtime:1.5597720146179 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:1.5598328113556 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='5541'DB:business_master_new
loadtime:1.5605449676514 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:1.560623884201 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='5541'DB:business_master_new
loadtime:1.5611670017242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.5612289905548 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='5541'DB:business_master_new
loadtime:1.5642509460449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:1.5643270015717 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='5541'DB:business_master_new
loadtime:1.576798915863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.5768809318542 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='5541'DB:business_master_new
loadtime:1.5859529972076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:1.5860319137573 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='5541'DB:business_master_new
loadtime:1.5968198776245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:1.5969009399414 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='5541'DB:business_master_new
loadtime:1.6017370223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:1.6018288135529 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='5541'DB:business_master_new
loadtime:1.603670835495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:1.6037340164185 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='5541'DB:business_master_new
loadtime:1.6041707992554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:1.6042308807373 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='5541'DB:business_master_new
loadtime:1.608729839325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:1.6088190078735 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='5541'DB:business_master_new
loadtime:1.609267950058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:1.6093299388885 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='5541'DB:business_master_new
loadtime:1.6145308017731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:1.6146149635315 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='5541'DB:business_master_new
loadtime:1.6150469779968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:1.6151080131531 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='5541'DB:business_master_new
loadtime:1.6191189289093 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:1.6191937923431 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='5541'DB:business_master_new
loadtime:1.626149892807 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:1.6262278556824 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='5541'DB:business_master_new
loadtime:1.6267828941345 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:1.6268448829651 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='5541'DB:business_master_new
loadtime:1.6383039951324 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:1.6383860111237 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='5541'DB:business_master_new
loadtime:1.6478898525238 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:1.6479778289795 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='5541'DB:business_master_new
loadtime:1.6536459922791 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:1.6537280082703 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='5541'DB:business_master_new
loadtime:1.6566410064697 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:1.6567180156708 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='5541'DB:business_master_new
loadtime:1.6571378707886 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:1.6571989059448 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='5541'DB:business_master_new
loadtime:1.6577069759369 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:1.6577777862549 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='5541'DB:business_master_new
loadtime:1.658618927002 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:1.658695936203 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='5541'DB:business_master_new
loadtime:1.6634469032288 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:1.6635239124298 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='5541'DB:business_master_new
loadtime:1.672073841095 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:1.6721639633179 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='5541'DB:business_master_new
loadtime:1.6735219955444 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:1.6735990047455 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='5541'DB:business_master_new
loadtime:1.6747589111328 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:1.674831867218 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='5541'DB:business_master_new
loadtime:1.6798458099365 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:1.6799268722534 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='5541'DB:business_master_new
loadtime:1.6804249286652 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:1.6804869174957 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='5541'DB:business_master_new
loadtime:1.6836040019989 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:1.6836678981781 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='5541'DB:business_master_new
loadtime:1.6874179840088 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:1.6874959468842 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='5541'DB:business_master_new
loadtime:1.6879999637604 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:1.6880619525909 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='5541'DB:business_master_new
loadtime:1.6885349750519 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:1.6885948181152 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='5541'DB:business_master_new
loadtime:1.6898488998413 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:1.6899240016937 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='5541'DB:business_master_new
loadtime:1.6904149055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:1.6904799938202 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='5541'DB:business_master_new
loadtime:1.6909668445587 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:1.691027879715 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='5541'DB:business_master_new
loadtime:1.6980729103088 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:1.6981530189514 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='5541'DB:business_master_new
loadtime:1.6986498832703 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:1.6987118721008 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='5541'DB:business_master_new
loadtime:1.6998198032379 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:1.699893951416 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='5541'DB:business_master_new
loadtime:1.7005939483643 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:1.7006719112396 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='5541'DB:business_master_new
loadtime:1.7011198997498 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:1.701180934906 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='5541'DB:business_master_new
loadtime:1.7034618854523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:1.7035398483276 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='5541'DB:business_master_new
loadtime:1.717307806015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:1.7173910140991 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='5541'DB:business_master_new
loadtime:1.7260398864746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:1.7261219024658 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='5541'DB:business_master_new
loadtime:1.7289798259735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.7290558815002 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='5541'DB:business_master_new
loadtime:1.7304589748383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:1.7305328845978 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='5541'DB:business_master_new
loadtime:1.7362658977509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:1.7363419532776 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='5541'DB:business_master_new
loadtime:1.7437047958374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:1.743793964386 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='5541'DB:business_master_new
loadtime:1.7596139907837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:1.759703874588 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.7602918148041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:1.7603549957275 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='5541'DB:business_master_new
loadtime:1.7649948596954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:1.7650728225708 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='5541'DB:business_master_new
loadtime:1.7660479545593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:1.7661099433899 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='5541'DB:business_master_new
loadtime:1.766548871994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:1.7666158676147 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='5541'DB:business_master_new
loadtime:1.7675359249115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.7675969600677 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='5541'DB:business_master_new
loadtime:1.771500825882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:1.7715818881989 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='5541'DB:business_master_new
loadtime:1.779464006424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:1.7795448303223 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='5541'DB:business_master_new
loadtime:1.7841708660126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:1.7842597961426 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='5541'DB:business_master_new
loadtime:1.7852528095245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.7853138446808 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='5541'DB:business_master_new
loadtime:1.7901768684387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.7902548313141 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='5541'DB:business_master_new
loadtime:1.7956538200378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:1.7957320213318 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='5541'DB:business_master_new
loadtime:1.7973439693451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:1.7974059581757 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='5541'DB:business_master_new
loadtime:1.8156819343567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.8157818317413 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='5541'DB:business_master_new
loadtime:1.8162457942963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.8163080215454 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='5541'DB:business_master_new
loadtime:1.8241219520569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:1.8242039680481 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='5541'DB:business_master_new
loadtime:1.8290870189667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:1.8291509151459 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='5541'DB:business_master_new
loadtime:1.8296649456024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:1.8297259807587 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='5541'DB:business_master_new
loadtime:1.8307459354401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:1.8308188915253 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='5541'DB:business_master_new
loadtime:1.8312959671021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:1.8313579559326 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='5541'DB:business_master_new
loadtime:1.831827878952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:1.831887960434 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='5541'DB:business_master_new
loadtime:1.8502769470215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.8503608703613 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='5541'DB:business_master_new
loadtime:1.8510320186615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:1.8510949611664 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='5541'DB:business_master_new
loadtime:1.8557589054108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.8558459281921 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='5541'DB:business_master_new
loadtime:1.8766188621521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:1.876708984375 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='5541'DB:business_master_new
loadtime:1.8783419132233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:1.8784058094025 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='5541'DB:business_master_new
loadtime:1.8815138339996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:1.8815898895264 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='5541'DB:business_master_new
loadtime:1.8821189403534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.882180929184 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='5541'DB:business_master_new
loadtime:1.8838868141174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:1.8839478492737 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='5541'DB:business_master_new
loadtime:1.8911669254303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:1.8912289142609 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='5541'DB:business_master_new
loadtime:1.9181489944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.9182558059692 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='5541'DB:business_master_new
loadtime:1.9273989200592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:1.9274859428406 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='5541'DB:business_master_new
loadtime:1.9341888427734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:1.934271812439 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='5541'DB:business_master_new
loadtime:1.9348227977753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:1.9348859786987 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='5541'DB:business_master_new
loadtime:1.9435520172119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:1.9436469078064 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='5541'DB:business_master_new
loadtime:1.944219827652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:1.9442830085754 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='5541'DB:business_master_new
loadtime:1.9490699768066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:1.9491448402405 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='5541'DB:business_master_new
loadtime:1.9611628055573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.9612548351288 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='5541'DB:business_master_new
loadtime:1.9622678756714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:1.9623320102692 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='5541'DB:business_master_new
loadtime:1.9633510112762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:1.9634118080139 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='5541'DB:business_master_new
loadtime:1.9652199745178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:1.9652810096741 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='5541'DB:business_master_new
loadtime:1.9728097915649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:1.9728908538818 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='5541'DB:business_master_new
loadtime:1.978040933609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:1.9781179428101 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='5541'DB:business_master_new
loadtime:1.985878944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:1.9859638214111 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='5541'DB:business_master_new
loadtime:1.9865748882294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:1.9866437911987 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='5541'DB:business_master_new
loadtime:1.9909238815308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:1.9910018444061 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='5541'DB:business_master_new
loadtime:1.9991319179535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:1.9992108345032 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='5541'DB:business_master_new
loadtime:2.0018730163574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:2.0019488334656 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='5541'DB:business_master_new
loadtime:2.0026969909668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:2.0027589797974 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='5541'DB:business_master_new
loadtime:2.0035560131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:2.003623008728 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='5541'DB:business_master_new
loadtime:2.0058608055115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:2.0059218406677 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='5541'DB:business_master_new
loadtime:2.0070300102234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:2.0070908069611 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='5541'DB:business_master_new
loadtime:2.0087490081787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.0088329315186 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='5541'DB:business_master_new
loadtime:2.0255029201508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:2.0255918502808 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='5541'DB:business_master_new
loadtime:2.0314748287201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:2.0315527915955 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='5541'DB:business_master_new
loadtime:2.0320188999176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:2.0320808887482 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='5541'DB:business_master_new
loadtime:2.0328588485718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:2.032919883728 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='5541'DB:business_master_new
loadtime:2.0401108264923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:2.0401899814606 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='5541'DB:business_master_new
loadtime:2.050402879715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:2.0504868030548 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='5541'DB:business_master_new
loadtime:2.0510849952698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:2.0511469841003 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='5541'DB:business_master_new
loadtime:2.0640568733215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:2.0641338825226 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='5541'DB:business_master_new
loadtime:2.0713238716125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.0714089870453 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='5541'DB:business_master_new
loadtime:2.0775859355927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:2.0776569843292 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='5541'DB:business_master_new
loadtime:2.0800759792328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:2.0801508426666 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='5541'DB:business_master_new
loadtime:2.0834679603577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:2.0835440158844 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='5541'DB:business_master_new
loadtime:2.0840368270874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:2.084098815918 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='5541'DB:business_master_new
loadtime:2.0869879722595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:2.0870499610901 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='5541'DB:business_master_new
loadtime:2.090010881424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:2.0900897979736 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='5541'DB:business_master_new
loadtime:2.1033868789673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:2.1034729480743 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='5541'DB:business_master_new
loadtime:2.1042368412018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:2.1043009757996 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='5541'DB:business_master_new
loadtime:2.104984998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:2.1050457954407 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='5541'DB:business_master_new
loadtime:2.1054608821869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.1055209636688 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='5541'DB:business_master_new
loadtime:2.1111929416656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:2.1112749576569 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='5541'DB:business_master_new
loadtime:2.1316637992859 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:2.1317598819733 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='5541'DB:business_master_new
loadtime:2.1323828697205 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:2.1324470043182 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='5541'DB:business_master_new
loadtime:2.1331830024719 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:2.1332588195801 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='5541'DB:business_master_new
loadtime:2.1338829994202 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:2.1339437961578 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='5541'DB:business_master_new
loadtime:2.1350498199463 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:2.1351108551025 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='5541'DB:business_master_new
loadtime:2.1355299949646 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:2.1355907917023 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='5541'DB:business_master_new
loadtime:2.1400969028473 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:2.1401748657227 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='5541'DB:business_master_new
loadtime:2.1429219245911 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:2.1429839134216 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='5541'DB:business_master_new
loadtime:2.1474888324738 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:2.1475658416748 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='5541'DB:business_master_new
loadtime:2.1540358066559 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:2.1541128158569 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='5541'DB:business_master_new
loadtime:2.1549508571625 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:2.155012845993 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='5541'DB:business_master_new
loadtime:2.1562159061432 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:2.1562759876251 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='5541'DB:business_master_new
loadtime:2.1617088317871 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:2.1617999076843 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='5541'DB:business_master_new
loadtime:2.1644690036774 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:2.1645438671112 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='5541'DB:business_master_new
loadtime:2.1651298999786 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:2.1651909351349 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='5541'DB:business_master_new
loadtime:2.1658809185028 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:2.1659419536591 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='5541'DB:business_master_new
loadtime:2.1664998531342 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:2.1665608882904 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='5541'DB:business_master_new
loadtime:2.1672279834747 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:2.1672878265381 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='5541'DB:business_master_new
loadtime:2.167888879776 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:2.1679489612579 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='5541'DB:business_master_new
loadtime:2.1687059402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:2.1687788963318 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='5541'DB:business_master_new
loadtime:2.1750907897949 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:2.1751749515533 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='5541'DB:business_master_new
loadtime:2.181783914566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:2.1818659305573 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='5541'DB:business_master_new
loadtime:2.1847569942474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:2.1848318576813 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='5541'DB:business_master_new
loadtime:2.1904058456421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:2.1904928684235 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='5541'DB:business_master_new
loadtime:2.1969439983368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.1970269680023 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='5541'DB:business_master_new
loadtime:2.1976709365845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:2.197732925415 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='5541'DB:business_master_new
loadtime:2.2023758888245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.2024548053741 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='5541'DB:business_master_new
loadtime:2.2078659534454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.2079448699951 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='5541'DB:business_master_new
loadtime:2.2207858562469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.2209069728851 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='5541'DB:business_master_new
loadtime:2.225154876709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:2.2252337932587 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='5541'DB:business_master_new
loadtime:2.2258019447327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.2258639335632 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='5541'DB:business_master_new
loadtime:2.227618932724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:2.2276809215546 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='5541'DB:business_master_new
loadtime:2.2370820045471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:2.237165927887 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='5541'DB:business_master_new
loadtime:2.2494850158691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:2.2495748996735 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='5541'DB:business_master_new
loadtime:2.2538239955902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:2.2539038658142 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='5541'DB:business_master_new
loadtime:2.2584848403931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:2.2585690021515 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='5541'DB:business_master_new
loadtime:2.2669129371643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:2.266991853714 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='5541'DB:business_master_new
loadtime:2.2684588432312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:2.2685329914093 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='5541'DB:business_master_new
loadtime:2.2727727890015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:2.2728509902954 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='5541'DB:business_master_new
loadtime:2.2786548137665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:2.2787368297577 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='5541'DB:business_master_new
loadtime:2.2853548526764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:2.285434961319 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='5541'DB:business_master_new
loadtime:2.3001279830933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:2.3002200126648 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='5541'DB:business_master_new
loadtime:2.3006649017334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:2.3007287979126 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='5541'DB:business_master_new
loadtime:2.3022677898407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:2.3023288249969 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='5541'DB:business_master_new
loadtime:2.3127989768982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:2.3128819465637 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='5541'DB:business_master_new
loadtime:2.3135209083557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.3135828971863 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='5541'DB:business_master_new
loadtime:2.3147838115692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:2.3148598670959 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='5541'DB:business_master_new
loadtime:2.3152828216553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:2.3153448104858 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='5541'DB:business_master_new
loadtime:2.320033788681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.320111989975 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='5541'DB:business_master_new
loadtime:2.3226459026337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:2.3227219581604 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='5541'DB:business_master_new
loadtime:2.3240389823914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:2.3241009712219 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='5541'DB:business_master_new
loadtime:2.3272318840027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:2.3273088932037 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='5541'DB:business_master_new
loadtime:2.3330328464508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:2.3331129550934 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='5541'DB:business_master_new
loadtime:2.333664894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:2.3337268829346 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='5541'DB:business_master_new
loadtime:2.3372769355774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:2.3373558521271 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='5541'DB:business_master_new
loadtime:2.3432788848877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:2.3433568477631 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='5541'DB:business_master_new
loadtime:2.3438320159912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:2.3438940048218 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='5541'DB:business_master_new
loadtime:2.3517158031464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:2.3518028259277 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='5541'DB:business_master_new
loadtime:2.3522479534149 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:2.3523089885712 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='5541'DB:business_master_new
loadtime:2.3527839183807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:2.352844953537 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='5541'DB:business_master_new
loadtime:2.3549499511719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.3550109863281 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='5541'DB:business_master_new
loadtime:2.3677108287811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.3678059577942 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='5541'DB:business_master_new
loadtime:2.3687279224396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:2.3688018321991 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='5541'DB:business_master_new
loadtime:2.3778820037842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:2.3779699802399 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='5541'DB:business_master_new
loadtime:2.3908469676971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:2.3909440040588 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='5541'DB:business_master_new
loadtime:2.391420841217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:2.3914840221405 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='5541'DB:business_master_new
loadtime:2.3919467926025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:2.3920078277588 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='5541'DB:business_master_new
loadtime:2.3964049816132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:2.3964807987213 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='5541'DB:business_master_new
loadtime:2.4029369354248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.403018951416 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='5541'DB:business_master_new
loadtime:2.4043109416962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:2.4043879508972 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='5541'DB:business_master_new
loadtime:2.4050199985504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.405081987381 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='5541'DB:business_master_new
loadtime:2.4055318832397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.4055919647217 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='5541'DB:business_master_new
loadtime:2.419224023819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:2.4193108081818 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='5541'DB:business_master_new
loadtime:2.4198098182678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.4198739528656 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='5541'DB:business_master_new
loadtime:2.4258728027344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.4259538650513 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='5541'DB:business_master_new
loadtime:2.4328517913818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:2.4329359531403 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='5541'DB:business_master_new
loadtime:2.4408979415894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:2.4409778118134 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='5541'DB:business_master_new
loadtime:2.45152592659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:2.4516129493713 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='5541'DB:business_master_new
loadtime:2.455353975296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:2.4554319381714 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='5541'DB:business_master_new
loadtime:2.456179857254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:2.4562418460846 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='5541'DB:business_master_new
loadtime:2.4567170143127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:2.4567890167236 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='5541'DB:business_master_new
loadtime:2.4583768844604 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:2.458438873291 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='5541'DB:business_master_new
loadtime:2.4615349769592 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:2.4616169929504 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='5541'DB:business_master_new
loadtime:2.4621338844299 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:2.4621958732605 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='5541'DB:business_master_new
loadtime:2.4673659801483 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:2.467444896698 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:2.4729509353638 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:2.4730288982391 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='5541'DB:business_master_new
loadtime:2.4748368263245 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:2.4749159812927 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='5541'DB:business_master_new
loadtime:2.4757030010223 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:2.475793838501 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='5541'DB:business_master_new
loadtime:2.4762649536133 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:2.4763259887695 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='5541'DB:business_master_new
loadtime:2.4767808914185 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:2.4768419265747 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='5541'DB:business_master_new
loadtime:2.4785168170929 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:2.4785768985748 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='5541'DB:business_master_new
loadtime:2.4794638156891 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:2.4795248508453 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='5541'DB:business_master_new
loadtime:2.4801368713379 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:2.4801979064941 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='5541'DB:business_master_new
loadtime:2.4815278053284 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:2.4815888404846 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='5541'DB:business_master_new
loadtime:2.4824810028076 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:2.4825417995453 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='5541'DB:business_master_new
loadtime:2.4830639362335 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:2.4831249713898 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='5541'DB:business_master_new
loadtime:2.4835779666901 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:2.4836440086365 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='5541'DB:business_master_new
loadtime:2.484071969986 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:2.4841318130493 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='5541'DB:business_master_new
loadtime:2.4868319034576 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:2.4869079589844 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='5541'DB:business_master_new
loadtime:2.491956949234 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:2.4920380115509 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='5541'DB:business_master_new
loadtime:2.5002908706665 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:2.5003759860992 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='5541'DB:business_master_new
loadtime:2.5008008480072 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.5008637905121 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='5541'DB:business_master_new
loadtime:2.5158050060272 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:2.5158967971802 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='5541'DB:business_master_new
loadtime:2.5170300006866 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:2.5170938968658 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='5541'DB:business_master_new
loadtime:2.5200088024139 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:2.5200848579407 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='5541'DB:business_master_new
loadtime:2.5210359096527 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:2.5210988521576 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='5541'DB:business_master_new
loadtime:2.5223670005798 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:2.5224277973175 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='5541'DB:business_master_new
loadtime:2.5231828689575 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:2.5232429504395 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='5541'DB:business_master_new
loadtime:2.5236928462982 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:2.5237529277802 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='5541'DB:business_master_new
loadtime:2.5284938812256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:2.528571844101 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='5541'DB:business_master_new
loadtime:2.5416488647461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.5417327880859 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='5541'DB:business_master_new
loadtime:2.5552268028259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:2.5553109645844 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='5541'DB:business_master_new
loadtime:2.5644519329071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:2.5645368099213 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='5541'DB:business_master_new
loadtime:2.5649878978729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:2.5650508403778 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='5541'DB:business_master_new
loadtime:2.56866979599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.5687489509583 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='5541'DB:business_master_new
loadtime:2.5736699104309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.5737459659576 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='5541'DB:business_master_new
loadtime:2.5804209709167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:2.5805017948151 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='5541'DB:business_master_new
loadtime:2.5810530185699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:2.5811150074005 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='5541'DB:business_master_new
loadtime:2.5879819393158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:2.5880630016327 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='5541'DB:business_master_new
loadtime:2.5937089920044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:2.5937988758087 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='5541'DB:business_master_new
loadtime:2.5947449207306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:2.5948309898376 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='5541'DB:business_master_new
loadtime:2.5953040122986 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:2.5953648090363 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='5541'DB:business_master_new
loadtime:2.5958089828491 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:2.5958700180054 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='5541'DB:business_master_new
loadtime:2.5963578224182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:2.5964179039001 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='5541'DB:business_master_new
loadtime:2.6007850170135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:2.6008639335632 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='5541'DB:business_master_new
loadtime:2.6060128211975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:2.6060888767242 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='5541'DB:business_master_new
loadtime:2.6121039390564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:2.6121838092804 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='5541'DB:business_master_new
loadtime:2.6126339435577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.6126959323883 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='5541'DB:business_master_new
loadtime:2.6142988204956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:2.6143598556519 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='5541'DB:business_master_new
loadtime:2.6188290119171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:2.6189048290253 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='5541'DB:business_master_new
loadtime:2.6284718513489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:2.6285548210144 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='5541'DB:business_master_new
loadtime:2.6325929164886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:2.6326768398285 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='5541'DB:business_master_new
loadtime:2.633143901825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:2.6332077980042 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='5541'DB:business_master_new
loadtime:2.6337699890137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.6338319778442 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='5541'DB:business_master_new
loadtime:2.6428318023682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.6429128646851 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='5541'DB:business_master_new
loadtime:2.6435928344727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.6436588764191 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='5541'DB:business_master_new
loadtime:2.649729013443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:2.6498229503632 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='5541'DB:business_master_new
loadtime:2.6717150211334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:2.6718218326569 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='5541'DB:business_master_new
loadtime:2.6722400188446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:2.6723029613495 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='5541'DB:business_master_new
loadtime:2.6735799312592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.6736459732056 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='5541'DB:business_master_new
loadtime:2.6741559505463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:2.6742157936096 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='5541'DB:business_master_new
loadtime:2.6870808601379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:2.6872248649597 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='5541'DB:business_master_new
loadtime:2.687686920166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:2.6877539157867 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='5541'DB:business_master_new
loadtime:2.6887028217316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:2.6887738704681 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='5541'DB:business_master_new
loadtime:2.6949388980865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:2.6950190067291 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='5541'DB:business_master_new
loadtime:2.6992518901825 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.6994178295135 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.6998889446259 / seconds
Operation template executed (chunk cache operation)
loadtime:2.7000539302826 / seconds
template override:Default
loadtime:2.7000949382782 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:2.7013239860535 / seconds
Template Constructed, Array Rows:49
loadtime:2.7018709182739 / seconds
TOTAL EXECUTION TIME: 2.70141
loadtime:2.7047379016876 / 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] => gasoline-service-station [stateURLid] => massachusetts )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:2.7047479152679
TOTAL KEY ARRAYS: 69