MySQL 查询语句优化 - 获取车辆抓拍数据

SELECT c48, c590, c584, c583, c585, c586, c587, c588, c589, c49, c592, c593, c594, c595, c596, c597, c598, c599 FROM ( SELECT c590, c583, ROUND(CAST(c584 AS DECIMAL), 0) AS c584, c585, c586, c48, c587, c588, c589, c592, c49, c593, c594, c595, c596, c597, c598, c599 FROM ( SELECT c582, c583, c584, c585, c586, c587, c588, c589, c590, c591, c592, c593, c594, c595, c596, c597, c598, c599, CASE c597 WHEN '市内常口' THEN 8 WHEN '辖区暂口' THEN 9 WHEN '非常非暂' THEN 10 END AS c48, '车辆抓拍' AS c49 FROM ( SELECT c582, c583, c584, c585, c586, c587, c588, c589, c590, c591, c592, c593, c594, c595, c596, c597, c598, c599 FROM ( SELECT face_times AS c582, name AS c583, vehicle_times AS c584, community_code AS c585, human_id AS c586, community_full_name AS c587, region_name AS c588, gender_name AS c589, snap_days AS c590, snap_times AS c591, street_road_name AS c592, communitee_name AS c593, cert_num AS c594, contact_phone AS c595, police_station_name AS c596, person_type AS c597, property_company_phone_number AS c598, calc_date AS c599 FROM dws_com_snap_statistics_middle_last7day ) t1 WHERE c599 = CURRENT_DATE AND c584 > 0 AND ((c597 = '非常非暂' AND c591 > 3) OR c597 != '非常非暂') ) tempt ) tempt ) tempt