请问这个多表联查sql还能怎么优化？

2016-12-15 02:20:18 428 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

暗月项目七详解本文围绕“暗月靶场项目七”展开，记录了一次从外网 Web 入口逐步深入内网并最终获取域控目标的完整实训过程。阅读详情

请问这个多表联合查询的sql语句还能怎么优化？现在以查询cpu就会彪很高。



SELECT 

      o.mobile AS mobile,

			o.user_name AS userName,

			o.dealer_id AS dealerId,

			o.location_id AS locationId,

			o.user_ip AS userIp,

			CASE

				WHEN LENGTH(IFNULL(city.attach_province_id, '')) = 0 

				THEN city.city_name

				ELSE CONCAT(city.attach_province_name,' ',city.attach_city_name)

		    END AS city,

            CONCAT(car.car_name,' ',car.car_year) AS carName,

			cs.cs_show_name AS cbName,

			cs.mb_Name AS bsName,

            o.car_id AS carId,

            DATE_FORMAT(o.create_time,'%Y-%m-%d %H:%i:%s') AS createTime,

			o.update_by AS updateBy,

			o.STATUS,

			o.source,

			o.channel,

			o.zt,

			o.key

	FROM car_order o

	LEFT JOIN car_city city ON o.location_id = city.city_id 

	LEFT JOIN (SELECT dealer_short_name, dealer_id FROM car_dealer GROUP BY dealer_id) dealer ON dealer.dealer_id = o.dealer_id 

	LEFT JOIN car_info car ON car.car_id = o.car_id 

	LEFT JOIN car_serial cs ON cs.cs_id = car.cs_id 

	WHERE date_format(o.create_time, '%Y-%m-%d') BETWEEN date_format('2016-12-14', '%Y-%m-%d') AND date_format('2016-12-15', '%Y-%m-%d')