Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.5101852416992E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018241405487061 / seconds
host not found setting manual db connection
loadtime:0.010825157165527 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011152982711792 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.011340141296387 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.011409044265747 / seconds
zipcode:
loadtime:0.011438131332397 / seconds
Query Executed:select * from search_referrer where page_hash='862fd41e4d172ed2010e45b5cf39dc85' limit 10 DB:ezrox_toadli
loadtime:0.011686086654663 / seconds
Operation header executed (non global)
loadtime:0.011721134185791 / seconds
Operation leaderboard executed (non global)
loadtime:0.011774063110352 / seconds
Operation square executed (non global)
loadtime:0.011803150177002 / seconds
Operation square_bottom executed (non global)
loadtime:0.011831045150757 / seconds
Operation smallsquare executed (non global)
loadtime:0.011857032775879 / seconds
Operation headeradright executed (non global)
loadtime:0.011896133422852 / seconds
Operation google_analytics executed (non global)
loadtime:0.01192307472229 / seconds
Operation topstories executed (non global)
loadtime:0.011949062347412 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011976957321167 / seconds
Operation memberbuscount executed (non global)
loadtime:0.012001991271973 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.012274026870728 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.012469053268433 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01252007484436 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.012587070465088 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.012639999389648 / seconds
Template key: archive_menu pushed
loadtime:0.012650012969971 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.012663125991821 / seconds
Template key: get_gravatar pushed
loadtime:0.012670040130615 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.012680053710938 / seconds
*10)-10)+1 | start:0
loadtime:0.012724161148071 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.012771129608154 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.01282000541687 / seconds
DB connected to localhost business_master_new
loadtime:0.013105154037476 / seconds
Query Executed:select * from `ma_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.072941064834595 / seconds
Query stored in cache : _QUERY_www.toadli.comcdec1a7de0ff9bc0ecd3ca78d5585d5d
loadtime:0.075171947479248 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.075237989425659 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='7231'DB:business_master_new
loadtime:0.078284978866577 / seconds
Query stored in cache : _QUERY_www.toadli.com0ac483e8305f9de378e024ff1d037ab3
loadtime:0.078325986862183 / seconds
559 / 11
loadtime:0.078384160995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.078466176986694 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='7231'DB:business_master_new
loadtime:0.1395161151886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.13967895507812 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='7231'DB:business_master_new
loadtime:0.1402850151062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.14035797119141 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='7231'DB:business_master_new
loadtime:0.15441107749939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.15452408790588 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='7231'DB:business_master_new
loadtime:0.15765404701233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.1577410697937 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='7231'DB:business_master_new
loadtime:0.21457600593567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.21473097801208 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='7231'DB:business_master_new
loadtime:0.27129602432251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.27147197723389 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='7231'DB:business_master_new
loadtime:0.2719349861145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.27200794219971 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='7231'DB:business_master_new
loadtime:0.28366994857788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.2837860584259 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='7231'DB:business_master_new
loadtime:0.29424595832825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.29435300827026 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='7231'DB:business_master_new
loadtime:0.3083610534668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.30846905708313 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='7231'DB:business_master_new
loadtime:0.32631611824036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.32648897171021 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='7231'DB:business_master_new
loadtime:0.32689595222473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.32696604728699 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='7231'DB:business_master_new
loadtime:0.34391403198242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.34406113624573 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='7231'DB:business_master_new
loadtime:0.344486951828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.34455609321594 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='7231'DB:business_master_new
loadtime:0.34494996070862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.34501814842224 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='7231'DB:business_master_new
loadtime:0.34708404541016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.34716415405273 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='7231'DB:business_master_new
loadtime:0.34858202934265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.34866714477539 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='7231'DB:business_master_new
loadtime:0.34971404075623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.34978294372559 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='7231'DB:business_master_new
loadtime:0.40717005729675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.40736103057861 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.40807795524597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.40814900398254 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='7231'DB:business_master_new
loadtime:0.40988302230835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.40998601913452 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='7231'DB:business_master_new
loadtime:0.41445994377136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.41456508636475 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='7231'DB:business_master_new
loadtime:0.4311420917511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.43129706382751 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='7231'DB:business_master_new
loadtime:0.43280911445618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.43288898468018 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='7231'DB:business_master_new
loadtime:0.44568204879761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.44580817222595 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='7231'DB:business_master_new
loadtime:0.50268697738647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.50284099578857 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='7231'DB:business_master_new
loadtime:0.50594115257263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.50603008270264 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='7231'DB:business_master_new
loadtime:0.56258702278137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.56275010108948 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='7231'DB:business_master_new
loadtime:0.56325697898865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.56332302093506 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='7231'DB:business_master_new
loadtime:0.56443405151367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.56451916694641 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='7231'DB:business_master_new
loadtime:0.56699800491333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.56709694862366 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='7231'DB:business_master_new
loadtime:0.5693621635437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.56945705413818 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='7231'DB:business_master_new
loadtime:0.56983494758606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.56990814208984 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='7231'DB:business_master_new
loadtime:0.57100915908813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.57108807563782 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='7231'DB:business_master_new
loadtime:0.58186316490173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.58196902275085 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='7231'DB:business_master_new
loadtime:0.63871812820435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.63888001441956 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='7231'DB:business_master_new
loadtime:0.69549608230591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.69566798210144 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='7231'DB:business_master_new
loadtime:0.70926713943481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.70939898490906 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='7231'DB:business_master_new
loadtime:0.71102404594421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.71111917495728 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='7231'DB:business_master_new
loadtime:0.7116219997406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.71168494224548 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='7231'DB:business_master_new
loadtime:0.71320009231567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.7132670879364 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='7231'DB:business_master_new
loadtime:0.71447610855103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.71455216407776 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='7231'DB:business_master_new
loadtime:0.73515701293945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:0.73532104492188 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='7231'DB:business_master_new
loadtime:0.74836397171021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.74848699569702 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='7231'DB:business_master_new
loadtime:0.75074005126953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:0.75083613395691 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='7231'DB:business_master_new
loadtime:0.75161409378052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.75168514251709 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='7231'DB:business_master_new
loadtime:0.75377416610718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:0.75385808944702 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='7231'DB:business_master_new
loadtime:0.75447702407837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.7545599937439 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='7231'DB:business_master_new
loadtime:0.81283497810364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:0.81342816352844 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='7231'DB:business_master_new
loadtime:0.81445598602295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:0.81455898284912 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='7231'DB:business_master_new
loadtime:0.81680512428284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:0.81689500808716 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='7231'DB:business_master_new
loadtime:0.81897902488708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:0.81907296180725 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='7231'DB:business_master_new
loadtime:0.82106614112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.82114195823669 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='7231'DB:business_master_new
loadtime:0.82155108451843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:0.82161402702332 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='7231'DB:business_master_new
loadtime:0.8425669670105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:0.8427050113678 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='7231'DB:business_master_new
loadtime:0.84329700469971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.84336400032043 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='7231'DB:business_master_new
loadtime:0.90050506591797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.90064001083374 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='7231'DB:business_master_new
loadtime:0.95727610588074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.95742797851562 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='7231'DB:business_master_new
loadtime:0.9722261428833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:0.97233510017395 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='7231'DB:business_master_new
loadtime:0.97403216362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:0.97411704063416 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='7231'DB:business_master_new
loadtime:1.0031759738922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:1.0033941268921 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='7231'DB:business_master_new
loadtime:1.004812002182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:1.0049049854279 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='7231'DB:business_master_new
loadtime:1.0288450717926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:1.029018163681 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='7231'DB:business_master_new
loadtime:1.0295491218567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:1.0296330451965 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='7231'DB:business_master_new
loadtime:1.0300631523132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:1.030130147934 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='7231'DB:business_master_new
loadtime:1.0306611061096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:1.0307221412659 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='7231'DB:business_master_new
loadtime:1.0313260555267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:1.0313930511475 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='7231'DB:business_master_new
loadtime:1.0510849952698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:1.0512139797211 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='7231'DB:business_master_new
loadtime:1.0566310882568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:1.0567359924316 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='7231'DB:business_master_new
loadtime:1.0581030845642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:1.0581820011139 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='7231'DB:business_master_new
loadtime:1.11106300354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:1.1113309860229 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='7231'DB:business_master_new
loadtime:1.1692640781403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:1.1694440841675 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='7231'DB:business_master_new
loadtime:1.1717331409454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:1.1718111038208 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='7231'DB:business_master_new
loadtime:1.1754269599915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:1.1755340099335 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='7231'DB:business_master_new
loadtime:1.1767661571503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:1.1768419742584 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='7231'DB:business_master_new
loadtime:1.1810631752014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:1.1811590194702 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='7231'DB:business_master_new
loadtime:1.1821801662445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:1.1822550296783 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='7231'DB:business_master_new
loadtime:1.2393040657043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:1.2394561767578 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='7231'DB:business_master_new
loadtime:1.2438039779663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:1.2439050674438 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='7231'DB:business_master_new
loadtime:1.244430065155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:1.2445149421692 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='7231'DB:business_master_new
loadtime:1.2449729442596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:1.2450361251831 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='7231'DB:business_master_new
loadtime:1.24556016922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.2456390857697 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='7231'DB:business_master_new
loadtime:1.3021540641785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:1.3023061752319 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='7231'DB:business_master_new
loadtime:1.3179130554199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:1.318058013916 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='7231'DB:business_master_new
loadtime:1.3312730789185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:1.3314020633698 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='7231'DB:business_master_new
loadtime:1.3324489593506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:1.3325271606445 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='7231'DB:business_master_new
loadtime:1.3337931632996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.3338680267334 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='7231'DB:business_master_new
loadtime:1.334673166275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:1.3347561359406 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:1.3355190753937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:1.3355989456177 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='7231'DB:business_master_new
loadtime:1.3928570747375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:1.3930261135101 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='7231'DB:business_master_new
loadtime:1.4108500480652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:1.4110481739044 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='7231'DB:business_master_new
loadtime:1.4127070903778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:1.412789106369 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='7231'DB:business_master_new
loadtime:1.4132051467896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:1.4132680892944 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='7231'DB:business_master_new
loadtime:1.4706280231476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:1.4708230495453 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='7231'DB:business_master_new
loadtime:1.5272600650787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:1.5274260044098 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='7231'DB:business_master_new
loadtime:1.5283901691437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:1.5284621715546 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='7231'DB:business_master_new
loadtime:1.544114112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:1.5442180633545 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='7231'DB:business_master_new
loadtime:1.5451910495758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:1.5452620983124 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='7231'DB:business_master_new
loadtime:1.547012090683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:1.5471069812775 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='7231'DB:business_master_new
loadtime:1.5476231575012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:1.5476970672607 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='7231'DB:business_master_new
loadtime:1.5485689640045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:1.5486309528351 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='7231'DB:business_master_new
loadtime:1.5490741729736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:1.549134016037 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='7231'DB:business_master_new
loadtime:1.5512320995331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:1.5513181686401 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='7231'DB:business_master_new
loadtime:1.5694680213928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:1.5696320533752 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='7231'DB:business_master_new
loadtime:1.570258140564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:1.5703270435333 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='7231'DB:business_master_new
loadtime:1.5850970745087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:1.5852079391479 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='7231'DB:business_master_new
loadtime:1.5861411094666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:1.5862259864807 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='7231'DB:business_master_new
loadtime:1.6432120800018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:1.6433689594269 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='7231'DB:business_master_new
loadtime:1.645791053772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:1.6458749771118 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='7231'DB:business_master_new
loadtime:1.646938085556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:1.6470091342926 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='7231'DB:business_master_new
loadtime:1.6486001014709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:1.6486821174622 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='7231'DB:business_master_new
loadtime:1.6697039604187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:1.6699020862579 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='7231'DB:business_master_new
loadtime:1.6703319549561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:1.6704020500183 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='7231'DB:business_master_new
loadtime:1.6728789806366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:1.6729609966278 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='7231'DB:business_master_new
loadtime:1.6749491691589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:1.6750340461731 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='7231'DB:business_master_new
loadtime:1.6873791217804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:1.687509059906 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='7231'DB:business_master_new
loadtime:1.6879560947418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:1.6880280971527 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='7231'DB:business_master_new
loadtime:1.6909821033478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:1.6910841464996 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='7231'DB:business_master_new
loadtime:1.6922481060028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:1.6923310756683 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='7231'DB:business_master_new
loadtime:1.7494421005249 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:1.7495930194855 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='7231'DB:business_master_new
loadtime:1.7500779628754 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:1.7501430511475 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='7231'DB:business_master_new
loadtime:1.7511501312256 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:1.7512221336365 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='7231'DB:business_master_new
loadtime:1.8077890872955 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:1.8079710006714 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='7231'DB:business_master_new
loadtime:1.8095209598541 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:1.8096139431 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='7231'DB:business_master_new
loadtime:1.8105850219727 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:1.8106620311737 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='7231'DB:business_master_new
loadtime:1.8110949993134 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:1.8111720085144 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='7231'DB:business_master_new
loadtime:1.8678550720215 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:1.8680210113525 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='7231'DB:business_master_new
loadtime:1.8705201148987 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:1.8706059455872 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='7231'DB:business_master_new
loadtime:1.9274401664734 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:1.9276249408722 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='7231'DB:business_master_new
loadtime:1.9280951023102 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:1.9281740188599 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='7231'DB:business_master_new
loadtime:1.9290580749512 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:1.9291441440582 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='7231'DB:business_master_new
loadtime:1.9296741485596 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:1.9297370910645 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='7231'DB:business_master_new
loadtime:1.9301371574402 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:1.9302179813385 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='7231'DB:business_master_new
loadtime:1.932343006134 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:1.9324290752411 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='7231'DB:business_master_new
loadtime:1.9339239597321 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:1.93399310112 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='7231'DB:business_master_new
loadtime:1.9346051216125 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:1.9346780776978 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='7231'DB:business_master_new
loadtime:1.9364330768585 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:1.9365170001984 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='7231'DB:business_master_new
loadtime:1.9384331703186 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:1.9385149478912 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='7231'DB:business_master_new
loadtime:1.9480800628662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:1.948184967041 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='7231'DB:business_master_new
loadtime:1.9507451057434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:1.9508290290833 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='7231'DB:business_master_new
loadtime:2.0079231262207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:2.0080840587616 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='7231'DB:business_master_new
loadtime:2.008810043335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:2.0089061260223 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='7231'DB:business_master_new
loadtime:2.0653309822083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:2.06547498703 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='7231'DB:business_master_new
loadtime:2.0659639835358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:2.0660500526428 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='7231'DB:business_master_new
loadtime:2.0666830539703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:2.0667691230774 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='7231'DB:business_master_new
loadtime:2.1229100227356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:2.1230680942535 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='7231'DB:business_master_new
loadtime:2.138365983963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:2.1385231018066 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='7231'DB:business_master_new
loadtime:2.1953599452972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:2.1955449581146 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='7231'DB:business_master_new
loadtime:2.226114988327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:2.2264051437378 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='7231'DB:business_master_new
loadtime:2.2392320632935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:2.2393569946289 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='7231'DB:business_master_new
loadtime:2.2400000095367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:2.2400829792023 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='7231'DB:business_master_new
loadtime:2.2971000671387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:2.297266960144 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='7231'DB:business_master_new
loadtime:2.2989950180054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:2.2990951538086 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='7231'DB:business_master_new
loadtime:2.3164110183716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:2.3165700435638 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='7231'DB:business_master_new
loadtime:2.3733141422272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:2.3734951019287 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='7231'DB:business_master_new
loadtime:2.3739969730377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:2.3740739822388 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='7231'DB:business_master_new
loadtime:2.3751699924469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:2.3752570152283 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='7231'DB:business_master_new
loadtime:2.4326159954071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:2.43279504776 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='7231'DB:business_master_new
loadtime:2.4655351638794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.4657289981842 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='7231'DB:business_master_new
loadtime:2.4800741672516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:2.4802279472351 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='7231'DB:business_master_new
loadtime:2.5374870300293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:2.537670135498 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='7231'DB:business_master_new
loadtime:2.5381450653076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:2.538211107254 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='7231'DB:business_master_new
loadtime:2.5945689678192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:2.5947201251984 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='7231'DB:business_master_new
loadtime:2.5955920219421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:2.5956740379333 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='7231'DB:business_master_new
loadtime:2.5964729785919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:2.5965449810028 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='7231'DB:business_master_new
loadtime:2.5969910621643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:2.5970640182495 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='7231'DB:business_master_new
loadtime:2.6145751476288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:2.6146969795227 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='7231'DB:business_master_new
loadtime:2.6153249740601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:2.6153919696808 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='7231'DB:business_master_new
loadtime:2.6721019744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:2.6722331047058 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='7231'DB:business_master_new
loadtime:2.6748139858246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:2.6749019622803 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='7231'DB:business_master_new
loadtime:2.6758570671082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:2.6759400367737 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='7231'DB:business_master_new
loadtime:2.7328679561615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:2.7330169677734 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='7231'DB:business_master_new
loadtime:2.7336111068726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:2.7336871623993 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='7231'DB:business_master_new
loadtime:2.7341821193695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:2.7342441082001 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='7231'DB:business_master_new
loadtime:2.7474761009216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:2.7475991249084 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='7231'DB:business_master_new
loadtime:2.8043200969696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:2.8044610023499 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='7231'DB:business_master_new
loadtime:2.8066401481628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:2.8067190647125 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='7231'DB:business_master_new
loadtime:2.8630101680756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:2.863165140152 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='7231'DB:business_master_new
loadtime:2.8652420043945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:2.8653230667114 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='7231'DB:business_master_new
loadtime:2.8659710884094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:2.8660531044006 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='7231'DB:business_master_new
loadtime:2.8682091236115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:2.8682940006256 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='7231'DB:business_master_new
loadtime:2.8689169883728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:2.8689801692963 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='7231'DB:business_master_new
loadtime:2.8858289718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:2.8859350681305 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='7231'DB:business_master_new
loadtime:2.8865351676941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:2.8866219520569 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='7231'DB:business_master_new
loadtime:2.9430611133575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:2.9431929588318 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='7231'DB:business_master_new
loadtime:2.9439849853516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:2.94406914711 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='7231'DB:business_master_new
loadtime:3.0002391338348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:3.0003809928894 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='7231'DB:business_master_new
loadtime:3.0568130016327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:3.0569839477539 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='7231'DB:business_master_new
loadtime:3.0590629577637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:3.0591471195221 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='7231'DB:business_master_new
loadtime:3.0605039596558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:3.0605981349945 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='7231'DB:business_master_new
loadtime:3.0610871315002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:3.0611491203308 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='7231'DB:business_master_new
loadtime:3.0828671455383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:3.0830540657043 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='7231'DB:business_master_new
loadtime:3.0834741592407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:3.0835440158844 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='7231'DB:business_master_new
loadtime:3.0845611095428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:3.0846359729767 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='7231'DB:business_master_new
loadtime:3.0851681232452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:3.0852391719818 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='7231'DB:business_master_new
loadtime:3.1006419658661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:3.100753068924 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='7231'DB:business_master_new
loadtime:3.1018760204315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:3.1019630432129 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='7231'DB:business_master_new
loadtime:3.1587669849396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:3.158940076828 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='7231'DB:business_master_new
loadtime:3.2155859470367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:3.2157530784607 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='7231'DB:business_master_new
loadtime:3.2166049480438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:3.2166831493378 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='7231'DB:business_master_new
loadtime:3.2271721363068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:3.2272551059723 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='7231'DB:business_master_new
loadtime:3.2457301616669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:3.2458600997925 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='7231'DB:business_master_new
loadtime:3.2482149600983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:3.2483031749725 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='7231'DB:business_master_new
loadtime:3.3052191734314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:3.3053750991821 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='7231'DB:business_master_new
loadtime:3.3065421581268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:3.3066260814667 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='7231'DB:business_master_new
loadtime:3.3081870079041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:3.3082649707794 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='7231'DB:business_master_new
loadtime:3.32000207901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:3.3201529979706 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='7231'DB:business_master_new
loadtime:3.376638174057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:3.3768150806427 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='7231'DB:business_master_new
loadtime:3.3774011135101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:3.3774659633636 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='7231'DB:business_master_new
loadtime:3.3786799907684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:3.3787620067596 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='7231'DB:business_master_new
loadtime:3.4001779556274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:3.4003291130066 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='7231'DB:business_master_new
loadtime:3.4008810520172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:3.4009649753571 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='7231'DB:business_master_new
loadtime:3.4585800170898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:3.4587819576263 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='7231'DB:business_master_new
loadtime:3.5153789520264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:3.5155401229858 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='7231'DB:business_master_new
loadtime:3.5722789764404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:3.572478055954 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='7231'DB:business_master_new
loadtime:3.5869450569153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:3.5870800018311 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='7231'DB:business_master_new
loadtime:3.5881190299988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:3.5881979465485 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='7231'DB:business_master_new
loadtime:3.6451799869537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:3.645348072052 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='7231'DB:business_master_new
loadtime:3.6458370685577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:3.6459059715271 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='7231'DB:business_master_new
loadtime:3.7022349834442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:3.7023730278015 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='7231'DB:business_master_new
loadtime:3.7046120166779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:3.7047030925751 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='7231'DB:business_master_new
loadtime:3.7067439556122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:3.7068259716034 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='7231'DB:business_master_new
loadtime:3.7295200824738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:3.7297241687775 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='7231'DB:business_master_new
loadtime:3.7865090370178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:3.786679983139 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='7231'DB:business_master_new
loadtime:3.7876670360565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:3.7877531051636 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='7231'DB:business_master_new
loadtime:3.8440120220184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:3.8441550731659 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='7231'DB:business_master_new
loadtime:3.9005191326141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:3.9006869792938 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='7231'DB:business_master_new
loadtime:3.9013841152191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:3.9014670848846 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='7231'DB:business_master_new
loadtime:3.9207999706268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:3.9209880828857 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='7231'DB:business_master_new
loadtime:3.921952009201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:3.9220249652863 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='7231'DB:business_master_new
loadtime:3.9399650096893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:3.9400999546051 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='7231'DB:business_master_new
loadtime:3.9405281543732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:3.9405951499939 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='7231'DB:business_master_new
loadtime:3.9435520172119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:3.9436371326447 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='7231'DB:business_master_new
loadtime:3.9443640708923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:3.9444539546967 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='7231'DB:business_master_new
loadtime:4.0013070106506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:4.0014650821686 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='7231'DB:business_master_new
loadtime:4.0580151081085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:4.0581741333008 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='7231'DB:business_master_new
loadtime:4.0885910987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:4.0888171195984 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='7231'DB:business_master_new
loadtime:4.14590716362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:4.146152973175 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='7231'DB:business_master_new
loadtime:4.1501410007477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:4.1502449512482 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='7231'DB:business_master_new
loadtime:4.1739971637726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:4.1742000579834 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='7231'DB:business_master_new
loadtime:4.1788110733032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:4.1789221763611 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='7231'DB:business_master_new
loadtime:4.1985750198364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:4.1987581253052 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='7231'DB:business_master_new
loadtime:4.1993761062622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:4.1994459629059 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='7231'DB:business_master_new
loadtime:4.2022130489349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:4.2022919654846 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='7231'DB:business_master_new
loadtime:4.2032380104065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:4.2033140659332 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='7231'DB:business_master_new
loadtime:4.2145171165466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:4.2146291732788 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='7231'DB:business_master_new
loadtime:4.2725350856781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:4.272714138031 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='7231'DB:business_master_new
loadtime:4.3290300369263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:4.329204082489 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='7231'DB:business_master_new
loadtime:4.3507881164551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:4.3509430885315 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='7231'DB:business_master_new
loadtime:4.3634390830994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:4.3635580539703 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='7231'DB:business_master_new
loadtime:4.3641011714935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:4.3641741275787 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='7231'DB:business_master_new
loadtime:4.4211790561676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:4.421345949173 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='7231'DB:business_master_new
loadtime:4.4321970939636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:4.4323060512543 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='7231'DB:business_master_new
loadtime:4.4896349906921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:4.489846944809 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='7231'DB:business_master_new
loadtime:4.4932210445404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:4.4933080673218 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='7231'DB:business_master_new
loadtime:4.5498869419098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:4.5500650405884 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='7231'DB:business_master_new
loadtime:4.6065731048584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:4.6067261695862 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='7231'DB:business_master_new
loadtime:4.6275300979614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:4.6277279853821 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='7231'DB:business_master_new
loadtime:4.6843490600586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:4.6845140457153 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='7231'DB:business_master_new
loadtime:4.7415111064911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:4.7417049407959 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='7231'DB:business_master_new
loadtime:4.7978830337524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:4.7980589866638 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='7231'DB:business_master_new
loadtime:4.7985620498657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:4.7986259460449 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='7231'DB:business_master_new
loadtime:4.800714969635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:4.8008100986481 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='7231'DB:business_master_new
loadtime:4.8179180622101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:4.8180911540985 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='7231'DB:business_master_new
loadtime:4.8298671245575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:4.8299870491028 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='7231'DB:business_master_new
loadtime:4.8305110931396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:4.8305780887604 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='7231'DB:business_master_new
loadtime:4.887552022934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:4.887717962265 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='7231'DB:business_master_new
loadtime:4.9036631584167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:4.9038281440735 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='7231'DB:business_master_new
loadtime:4.9044549465179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:4.904529094696 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='7231'DB:business_master_new
loadtime:4.9613461494446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:4.9615089893341 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='7231'DB:business_master_new
loadtime:4.9622249603271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:4.962296962738 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='7231'DB:business_master_new
loadtime:5.0186321735382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:5.0187849998474 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='7231'DB:business_master_new
loadtime:5.0198340415955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:5.0199019908905 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='7231'DB:business_master_new
loadtime:5.0762770175934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:5.07643699646 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='7231'DB:business_master_new
loadtime:5.0769469738007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:5.0770180225372 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='7231'DB:business_master_new
loadtime:5.0774290561676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:5.077497959137 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='7231'DB:business_master_new
loadtime:5.0778901576996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:5.0779571533203 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='7231'DB:business_master_new
loadtime:5.07839012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:5.0784540176392 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='7231'DB:business_master_new
loadtime:5.0814471244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:5.0815441608429 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='7231'DB:business_master_new
loadtime:5.082818031311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:5.0829041004181 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='7231'DB:business_master_new
loadtime:5.0836231708527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:5.0836901664734 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='7231'DB:business_master_new
loadtime:5.0841419696808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:5.0842101573944 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='7231'DB:business_master_new
loadtime:5.0848970413208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:5.0849781036377 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='7231'DB:business_master_new
loadtime:5.092700958252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:5.0927929878235 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='7231'DB:business_master_new
loadtime:5.1077740192413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:5.1078939437866 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='7231'DB:business_master_new
loadtime:5.1280870437622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:5.12824010849 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='7231'DB:business_master_new
loadtime:5.1402499675751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:5.1403739452362 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='7231'DB:business_master_new
loadtime:5.1978981494904 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:5.1980719566345 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='7231'DB:business_master_new
loadtime:5.1985630989075 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:5.1986269950867 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='7231'DB:business_master_new
loadtime:5.2312841415405 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:5.2315590381622 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='7231'DB:business_master_new
loadtime:5.2324161529541 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:5.2324969768524 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='7231'DB:business_master_new
loadtime:5.2330141067505 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:5.2331001758575 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='7231'DB:business_master_new
loadtime:5.2337970733643 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:5.2338709831238 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='7231'DB:business_master_new
loadtime:5.234395980835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:5.2344570159912 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='7231'DB:business_master_new
loadtime:5.2365109920502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:5.2365989685059 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='7231'DB:business_master_new
loadtime:5.2526021003723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:5.2527310848236 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='7231'DB:business_master_new
loadtime:5.3101711273193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:5.3103451728821 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='7231'DB:business_master_new
loadtime:5.3247649669647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:5.324893951416 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='7231'DB:business_master_new
loadtime:5.3816440105438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:5.3818380832672 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='7231'DB:business_master_new
loadtime:5.3837449550629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:5.3838131427765 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='7231'DB:business_master_new
loadtime:5.3842389583588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:5.3843071460724 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='7231'DB:business_master_new
loadtime:5.4414000511169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:5.4415700435638 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='7231'DB:business_master_new
loadtime:5.4420890808105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:5.4421610832214 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='7231'DB:business_master_new
loadtime:5.4464571475983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:5.4465630054474 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='7231'DB:business_master_new
loadtime:5.4469709396362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:5.4470570087433 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='7231'DB:business_master_new
loadtime:5.5038139820099 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:5.5039739608765 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='7231'DB:business_master_new
loadtime:5.5608620643616 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:5.5610589981079 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='7231'DB:business_master_new
loadtime:5.5616390705109 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:5.5617070198059 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='7231'DB:business_master_new
loadtime:5.5767321586609 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:5.5768661499023 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='7231'DB:business_master_new
loadtime:5.5898320674896 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:5.5899920463562 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='7231'DB:business_master_new
loadtime:5.6469399929047 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:5.6471230983734 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='7231'DB:business_master_new
loadtime:5.6491589546204 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:5.6492531299591 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='7231'DB:business_master_new
loadtime:5.649649143219 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:5.6497139930725 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='7231'DB:business_master_new
loadtime:5.6502079963684 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:5.6502749919891 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='7231'DB:business_master_new
loadtime:5.6511149406433 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:5.6511969566345 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='7231'DB:business_master_new
loadtime:5.7077560424805 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:5.7079181671143 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='7231'DB:business_master_new
loadtime:5.7200219631195 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:5.7201609611511 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='7231'DB:business_master_new
loadtime:5.7215089797974 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:5.7216041088104 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='7231'DB:business_master_new
loadtime:5.7227411270142 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:5.7228209972382 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='7231'DB:business_master_new
loadtime:5.779422044754 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:5.7795951366425 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='7231'DB:business_master_new
loadtime:5.7801420688629 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:5.7802181243896 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='7231'DB:business_master_new
loadtime:5.7824020385742 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:5.7824921607971 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='7231'DB:business_master_new
loadtime:5.785313129425 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:5.7854130268097 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='7231'DB:business_master_new
loadtime:5.7858779430389 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:5.7859790325165 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='7231'DB:business_master_new
loadtime:5.7864360809326 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:5.7865061759949 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='7231'DB:business_master_new
loadtime:5.7877349853516 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:5.78781914711 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='7231'DB:business_master_new
loadtime:5.7883031368256 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:5.7883739471436 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='7231'DB:business_master_new
loadtime:5.7888159751892 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:5.7888870239258 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='7231'DB:business_master_new
loadtime:5.8456749916077 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:5.8458480834961 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='7231'DB:business_master_new
loadtime:5.8463790416718 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:5.846451997757 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='7231'DB:business_master_new
loadtime:5.8475461006165 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:5.8476071357727 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='7231'DB:business_master_new
loadtime:5.8483021259308 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:5.8483641147614 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='7231'DB:business_master_new
loadtime:5.8487839698792 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:5.8488540649414 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='7231'DB:business_master_new
loadtime:5.8511509895325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:5.851243019104 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='7231'DB:business_master_new
loadtime:5.8686230182648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:5.8687691688538 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='7231'DB:business_master_new
loadtime:5.9259941577911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:5.9261791706085 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='7231'DB:business_master_new
loadtime:5.9281520843506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:5.9282469749451 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='7231'DB:business_master_new
loadtime:5.9296460151672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:5.9297311306 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='7231'DB:business_master_new
loadtime:5.9862811565399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:5.9864461421967 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='7231'DB:business_master_new
loadtime:5.9972031116486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:5.9973180294037 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='7231'DB:business_master_new
loadtime:6.0168840885162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:6.0170350074768 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='7231'DB:business_master_new
loadtime:6.0174939632416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:6.0175709724426 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='7231'DB:business_master_new
loadtime:6.0742220878601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:6.0743701457977 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='7231'DB:business_master_new
loadtime:6.075394153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:6.0754771232605 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='7231'DB:business_master_new
loadtime:6.0758950710297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:6.0759661197662 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='7231'DB:business_master_new
loadtime:6.076868057251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:6.0769519805908 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='7231'DB:business_master_new
loadtime:6.1334481239319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:6.1335861682892 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='7231'DB:business_master_new
loadtime:6.1904470920563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:6.1906199455261 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='7231'DB:business_master_new
loadtime:6.2470071315765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:6.2471859455109 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='7231'DB:business_master_new
loadtime:6.2482290267944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:6.2483050823212 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='7231'DB:business_master_new
loadtime:6.3046820163727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:6.3048331737518 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='7231'DB:business_master_new
loadtime:6.3612649440765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:6.3614430427551 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='7231'DB:business_master_new
loadtime:6.3631219863892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:6.3632061481476 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='7231'DB:business_master_new
loadtime:6.3854160308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:6.3856120109558 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='7231'DB:business_master_new
loadtime:6.3860809803009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:6.3861639499664 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='7231'DB:business_master_new
loadtime:6.3972780704498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:6.3973879814148 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='7231'DB:business_master_new
loadtime:6.4546980857849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:6.4548881053925 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='7231'DB:business_master_new
loadtime:6.4554381370544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:6.455512046814 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='7231'DB:business_master_new
loadtime:6.4565269947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:6.4565980434418 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='7231'DB:business_master_new
loadtime:6.4570770263672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:6.4571440219879 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='7231'DB:business_master_new
loadtime:6.4575741291046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:6.457640171051 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='7231'DB:business_master_new
loadtime:6.480082988739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:6.4802310466766 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='7231'DB:business_master_new
loadtime:6.4808671474457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:6.4809420108795 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='7231'DB:business_master_new
loadtime:6.4845070838928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:6.4845969676971 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='7231'DB:business_master_new
loadtime:6.509092092514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:6.5092489719391 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='7231'DB:business_master_new
loadtime:6.5108959674835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:6.5109870433807 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='7231'DB:business_master_new
loadtime:6.51313996315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:6.5132300853729 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='7231'DB:business_master_new
loadtime:6.5136909484863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:6.5137591362 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='7231'DB:business_master_new
loadtime:6.5153939723969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:6.5154860019684 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='7231'DB:business_master_new
loadtime:6.5728840827942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:6.5730540752411 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='7231'DB:business_master_new
loadtime:6.6046431064606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:6.6048891544342 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='7231'DB:business_master_new
loadtime:6.6625499725342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:6.6627700328827 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='7231'DB:business_master_new
loadtime:6.7194759845734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:6.7196581363678 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='7231'DB:business_master_new
loadtime:6.7202470302582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:6.7203121185303 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='7231'DB:business_master_new
loadtime:6.7322840690613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:6.7323970794678 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='7231'DB:business_master_new
loadtime:6.7329530715942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:6.7330191135406 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='7231'DB:business_master_new
loadtime:6.7895350456238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:6.7896800041199 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='7231'DB:business_master_new
loadtime:6.8053710460663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:6.8055341243744 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='7231'DB:business_master_new
loadtime:6.8065280914307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:6.8066000938416 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='7231'DB:business_master_new
loadtime:6.807608127594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:6.807685136795 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='7231'DB:business_master_new
loadtime:6.8094980716705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:6.8095829486847 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='7231'DB:business_master_new
loadtime:6.8664710521698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:6.8666310310364 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='7231'DB:business_master_new
loadtime:6.9228661060333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:6.9230329990387 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='7231'DB:business_master_new
loadtime:6.9799540042877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:6.980152130127 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='7231'DB:business_master_new
loadtime:6.9808101654053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:6.9808909893036 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='7231'DB:business_master_new
loadtime:6.9843621253967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:6.9844419956207 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='7231'DB:business_master_new
loadtime:7.0412919521332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:7.0414869785309 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='7231'DB:business_master_new
loadtime:7.0442190170288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:7.044310092926 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='7231'DB:business_master_new
loadtime:7.0450530052185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:7.0451250076294 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='7231'DB:business_master_new
loadtime:7.0458941459656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:7.0459570884705 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='7231'DB:business_master_new
loadtime:7.0481851100922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:7.0482630729675 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='7231'DB:business_master_new
loadtime:7.0493590831757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:7.049437046051 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='7231'DB:business_master_new
loadtime:7.0510959625244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:7.0511720180511 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:7.0715169906616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:7.0716590881348 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='7231'DB:business_master_new
loadtime:7.0766611099243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:7.0767769813538 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='7231'DB:business_master_new
loadtime:7.0772221088409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:7.0772969722748 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='7231'DB:business_master_new
loadtime:7.0780560970306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:7.0781280994415 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='7231'DB:business_master_new
loadtime:7.1351351737976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:7.1352870464325 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='7231'DB:business_master_new
loadtime:7.1926281452179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:7.1928570270538 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='7231'DB:business_master_new
loadtime:7.1935000419617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:7.1935980319977 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='7231'DB:business_master_new
loadtime:7.2038459777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:7.2039539813995 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='7231'DB:business_master_new
loadtime:7.2103760242462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:7.2104799747467 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='7231'DB:business_master_new
loadtime:7.2672700881958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:7.2674291133881 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='7231'DB:business_master_new
loadtime:7.2699179649353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:7.2700049877167 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='7231'DB:business_master_new
loadtime:7.2723960876465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:7.2724921703339 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='7231'DB:business_master_new
loadtime:7.2729570865631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:7.2730250358582 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='7231'DB:business_master_new
loadtime:7.2750060558319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:7.2750930786133 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='7231'DB:business_master_new
loadtime:7.2771100997925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:7.277204990387 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='7231'DB:business_master_new
loadtime:7.2940170764923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:7.2941591739655 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='7231'DB:business_master_new
loadtime:7.2948911190033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:7.2949681282043 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='7231'DB:business_master_new
loadtime:7.2956221103668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:7.2956910133362 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='7231'DB:business_master_new
loadtime:7.296098947525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:7.2961640357971 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='7231'DB:business_master_new
loadtime:7.3532040119171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:7.3533821105957 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='7231'DB:business_master_new
loadtime:7.3777539730072 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:7.37797498703 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='7231'DB:business_master_new
loadtime:7.3787291049957 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:7.3788161277771 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='7231'DB:business_master_new
loadtime:7.3795289993286 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:7.3795959949493 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='7231'DB:business_master_new
loadtime:7.3801970481873 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:7.3802671432495 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='7231'DB:business_master_new
loadtime:7.3813660144806 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:7.3814280033112 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='7231'DB:business_master_new
loadtime:7.3818230628967 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:7.3819019794464 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='7231'DB:business_master_new
loadtime:7.4392220973969 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:7.4394099712372 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='7231'DB:business_master_new
loadtime:7.442244052887 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:7.4423470497131 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='7231'DB:business_master_new
loadtime:7.4992780685425 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:7.4994390010834 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='7231'DB:business_master_new
loadtime:7.5563430786133 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:7.5565149784088 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='7231'DB:business_master_new
loadtime:7.5574109554291 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:7.5574910640717 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='7231'DB:business_master_new
loadtime:7.5586850643158 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:7.5587651729584 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='7231'DB:business_master_new
loadtime:7.6151840686798 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:7.6153521537781 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='7231'DB:business_master_new
loadtime:7.6181190013885 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:7.6182060241699 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='7231'DB:business_master_new
loadtime:7.6187579631805 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:7.6188430786133 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='7231'DB:business_master_new
loadtime:7.6195111274719 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:7.6195919513702 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='7231'DB:business_master_new
loadtime:7.6201469898224 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:7.620218038559 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='7231'DB:business_master_new
loadtime:7.6208510398865 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:7.6209290027618 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='7231'DB:business_master_new
loadtime:7.6215031147003 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:7.6215641498566 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='7231'DB:business_master_new
loadtime:7.6223039627075 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:7.6223659515381 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='7231'DB:business_master_new
loadtime:7.6791591644287 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:7.6793329715729 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='7231'DB:business_master_new
loadtime:7.7359640598297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:7.7361330986023 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='7231'DB:business_master_new
loadtime:7.7381660938263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:7.7382581233978 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='7231'DB:business_master_new
loadtime:7.7469921112061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:7.7470870018005 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='7231'DB:business_master_new
loadtime:7.8037929534912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:7.8039920330048 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='7231'DB:business_master_new
loadtime:7.8046650886536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:7.8047440052032 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='7231'DB:business_master_new
loadtime:7.8609781265259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:7.8611309528351 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='7231'DB:business_master_new
loadtime:7.9176399707794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:7.9178099632263 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='7231'DB:business_master_new
loadtime:7.9648201465607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:7.9651761054993 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='7231'DB:business_master_new
loadtime:7.9685561656952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:7.96866106987 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='7231'DB:business_master_new
loadtime:7.9692010879517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:7.9692661762238 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='7231'DB:business_master_new
loadtime:7.971027135849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:7.9711170196533 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='7231'DB:business_master_new
loadtime:7.9838540554047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:7.9839789867401 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='7231'DB:business_master_new
loadtime:8.0045311450958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:8.0046510696411 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='7231'DB:business_master_new
loadtime:8.0080060958862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:8.0081131458282 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='7231'DB:business_master_new
loadtime:8.0651211738586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:8.0652761459351 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='7231'DB:business_master_new
loadtime:8.0769939422607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:8.0771160125732 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='7231'DB:business_master_new
loadtime:8.0785801410675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:8.0786731243134 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='7231'DB:business_master_new
loadtime:8.1353180408478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:8.1354660987854 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='7231'DB:business_master_new
loadtime:8.1919641494751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:8.1921470165253 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='7231'DB:business_master_new
loadtime:8.2488400936127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:8.249027967453 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='7231'DB:business_master_new
loadtime:8.2674570083618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:8.267627954483 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='7231'DB:business_master_new
loadtime:8.2680640220642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:8.2681400775909 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='7231'DB:business_master_new
loadtime:8.2696690559387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:8.2697551250458 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='7231'DB:business_master_new
loadtime:8.2836670875549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:8.2837910652161 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='7231'DB:business_master_new
loadtime:8.2844250202179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:8.284499168396 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='7231'DB:business_master_new
loadtime:8.2856800556183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:8.2857630252838 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='7231'DB:business_master_new
loadtime:8.2861759662628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:8.2862529754639 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='7231'DB:business_master_new
loadtime:8.3430759906769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:8.3432149887085 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='7231'DB:business_master_new
loadtime:8.3458001613617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:8.3459060192108 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='7231'DB:business_master_new
loadtime:8.3472220897675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:8.3473069667816 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='7231'DB:business_master_new
loadtime:8.3495161533356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:8.3496060371399 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='7231'DB:business_master_new
loadtime:8.4064991474152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:8.406681060791 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='7231'DB:business_master_new
loadtime:8.4072921276093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:8.40735912323 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='7231'DB:business_master_new
loadtime:8.410001039505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:8.4101049900055 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='7231'DB:business_master_new
loadtime:8.4673330783844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:8.4675159454346 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='7231'DB:business_master_new
loadtime:8.4680531024933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:8.4681301116943 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='7231'DB:business_master_new
loadtime:8.4792189598083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:8.4793181419373 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='7231'DB:business_master_new
loadtime:8.4797360897064 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:8.479807138443 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:8.4802520275116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:8.480327129364 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='7231'DB:business_master_new
loadtime:8.4824290275574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:8.4825119972229 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='7231'DB:business_master_new
loadtime:8.4988400936127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:8.4989819526672 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='7231'DB:business_master_new
loadtime:8.4998850822449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:8.4999780654907 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='7231'DB:business_master_new
loadtime:8.5163049697876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:8.5164141654968 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='7231'DB:business_master_new
loadtime:8.5481810569763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:8.5483930110931 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='7231'DB:business_master_new
loadtime:8.5488760471344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:8.5489511489868 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='7231'DB:business_master_new
loadtime:8.5493800640106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:8.5494530200958 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='7231'DB:business_master_new
loadtime:8.6065249443054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:8.6066801548004 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='7231'DB:business_master_new
loadtime:8.6634049415588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:8.6635820865631 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='7231'DB:business_master_new
loadtime:8.664929151535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:8.6650171279907 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='7231'DB:business_master_new
loadtime:8.6656229496002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:8.6656861305237 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='7231'DB:business_master_new
loadtime:8.6661310195923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:8.6661920547485 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='7231'DB:business_master_new
loadtime:8.6834599971771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:8.6835780143738 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='7231'DB:business_master_new
loadtime:8.6840620040894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:8.6841330528259 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='7231'DB:business_master_new
loadtime:8.7410271167755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:8.7411921024323 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='7231'DB:business_master_new
loadtime:8.7977919578552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:8.7979950904846 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='7231'DB:business_master_new
loadtime:8.8546710014343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:8.8548610210419 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='7231'DB:business_master_new
loadtime:8.8689091205597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:8.8690099716187 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='7231'DB:business_master_new
loadtime:8.8718590736389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:8.8719501495361 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='7231'DB:business_master_new
loadtime:8.8726661205292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:8.8727431297302 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='7231'DB:business_master_new
loadtime:8.8732039928436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:8.8732740879059 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='7231'DB:business_master_new
loadtime:8.8748619556427 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:8.8749439716339 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='7231'DB:business_master_new
loadtime:8.8771059513092 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:8.8771901130676 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='7231'DB:business_master_new
loadtime:8.8776710033417 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:8.8777351379395 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='7231'DB:business_master_new
loadtime:8.9345920085907 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:8.9347310066223 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='7231'DB:business_master_new
loadtime:8.9915289878845 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:8.9916830062866 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='7231'DB:business_master_new
loadtime:8.9935481548309 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:8.9936289787292 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='7231'DB:business_master_new
loadtime:8.9944059848785 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:8.9944989681244 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='7231'DB:business_master_new
loadtime:8.9949569702148 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:8.9950261116028 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='7231'DB:business_master_new
loadtime:8.9954481124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:8.995509147644 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='7231'DB:business_master_new
loadtime:8.9972009658813 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:8.9972951412201 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='7231'DB:business_master_new
loadtime:8.9981729984283 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:8.9982621669769 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='7231'DB:business_master_new
loadtime:8.9988210201263 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:8.9988901615143 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='7231'DB:business_master_new
loadtime:9.0002119541168 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:9.0002961158752 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='7231'DB:business_master_new
loadtime:9.0011780261993 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:9.0012640953064 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='7231'DB:business_master_new
loadtime:9.0017521381378 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:9.0018191337585 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='7231'DB:business_master_new
loadtime:9.0022661685944 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:9.0023281574249 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='7231'DB:business_master_new
loadtime:9.0027241706848 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:9.0027890205383 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='7231'DB:business_master_new
loadtime:9.004536151886 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:9.0046241283417 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='7231'DB:business_master_new
loadtime:9.0610611438751 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:9.0612001419067 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='7231'DB:business_master_new
loadtime:9.0728960037231 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:9.073037147522 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='7231'DB:business_master_new
loadtime:9.0734391212463 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:9.0735151767731 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='7231'DB:business_master_new
loadtime:9.0919620990753 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:9.0921039581299 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='7231'DB:business_master_new
loadtime:9.0932290554047 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:9.0933101177216 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='7231'DB:business_master_new
loadtime:9.0952770709991 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:9.0953559875488 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='7231'DB:business_master_new
loadtime:9.0962870121002 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:9.0963671207428 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='7231'DB:business_master_new
loadtime:9.0976240634918 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:9.0977101325989 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='7231'DB:business_master_new
loadtime:9.0984480381012 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:9.0985341072083 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='7231'DB:business_master_new
loadtime:9.0989651679993 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:9.0990290641785 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='7231'DB:business_master_new
loadtime:9.1558220386505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:9.1559779644012 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='7231'DB:business_master_new
loadtime:9.1726181507111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:9.1727421283722 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='7231'DB:business_master_new
loadtime:9.1898939609528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:9.1900560855865 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='7231'DB:business_master_new
loadtime:9.2474429607391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:9.2476150989532 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='7231'DB:business_master_new
loadtime:9.2481009960175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:9.2481670379639 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='7231'DB:business_master_new
loadtime:9.2508909702301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:9.250981092453 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='7231'DB:business_master_new
loadtime:9.3197820186615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:9.3199200630188 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='7231'DB:business_master_new
loadtime:9.3765180110931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:9.3766901493073 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='7231'DB:business_master_new
loadtime:9.3772850036621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:9.377357006073 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='7231'DB:business_master_new
loadtime:9.4341640472412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:9.4343359470367 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='7231'DB:business_master_new
loadtime:9.491259098053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:9.4914360046387 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='7231'DB:business_master_new
loadtime:9.4924311637878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:9.4925019741058 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='7231'DB:business_master_new
loadtime:9.492959022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:9.4930291175842 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='7231'DB:business_master_new
loadtime:9.4934470653534 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:9.4935140609741 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='7231'DB:business_master_new
loadtime:9.4939939975739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:9.4940710067749 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='7231'DB:business_master_new
loadtime:9.4975509643555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:9.4976470470428 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='7231'DB:business_master_new
loadtime:9.5542280673981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:9.5543899536133 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='7231'DB:business_master_new
loadtime:9.6108779907227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:9.6110601425171 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='7231'DB:business_master_new
loadtime:9.6115460395813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:9.6116111278534 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='7231'DB:business_master_new
loadtime:9.6132230758667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:9.6133019924164 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='7231'DB:business_master_new
loadtime:9.6695649623871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:9.669713973999 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='7231'DB:business_master_new
loadtime:9.6827411651611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:9.6828560829163 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='7231'DB:business_master_new
loadtime:9.7392871379852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:9.7394530773163 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='7231'DB:business_master_new
loadtime:9.7399640083313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:9.7400300502777 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='7231'DB:business_master_new
loadtime:9.7405610084534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:9.7406229972839 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='7231'DB:business_master_new
loadtime:9.7973210811615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:9.7974860668182 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='7231'DB:business_master_new
loadtime:9.7982289791107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:9.7983069419861 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='7231'DB:business_master_new
loadtime:9.8034830093384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:9.8035819530487 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='7231'DB:business_master_new
loadtime:9.8292920589447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:9.829451084137 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='7231'DB:business_master_new
loadtime:9.829852104187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:9.829941034317 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='7231'DB:business_master_new
loadtime:9.8312139511108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:9.8312759399414 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='7231'DB:business_master_new
loadtime:9.8317589759827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:9.8318200111389 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='7231'DB:business_master_new
loadtime:9.904461145401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:9.9049799442291 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='7231'DB:business_master_new
loadtime:9.9054870605469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:9.9055740833282 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='7231'DB:business_master_new
loadtime:9.9065029621124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:9.9065771102905 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='7231'DB:business_master_new
loadtime:9.9118311405182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:9.9119281768799 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='7231'DB:business_master_new
loadtime:9.9152891635895 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:9.9154620170593 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:9.9159491062164 / seconds
Operation template executed (chunk cache operation)
loadtime:9.9161291122437 / seconds
template override:Default
loadtime:9.9161729812622 / 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:9.9181351661682 / seconds
Template Constructed, Array Rows:49
loadtime:9.9189190864563 / seconds
TOTAL EXECUTION TIME: 9.91823
loadtime:9.9226331710815 / 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] => beauty-shops [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:9.9226441383362
TOTAL KEY ARRAYS: 69