先看下sql explain select distinct zc.*,zp.id zpid,saved_path,zf.id zfid,pac.comp_name,retailing_name,scale_name,country_name,pp.person_name,pac.full_name as market_name,ztp.place_name,concat(pac.full_name,_,zc.company_id) as market,concat(retailing_name,_,…