Mysql多表联查优化案例

案例1

SELECT
	u.interfaceDataId AS interfaceDataId,
	u.sensorNumber AS sensorNumber,
	u.tPort AS tPort,
	u.aPort AS aPort,
	u.threeTPort AS threeTPort,
	u.syncTime AS syncTime,
	t.address AS address
FROM
	(
		SELECT
			interface_data_id AS interfaceDataId,
			sensor_number AS sensorNumber,
			t_port AS tPort,
			a_port AS aPort,
			three_t_port AS threeTPort,
			sync_time AS syncTime
		FROM
			interface_data_list
		WHERE
			sync_time > CURDATE()
	) u STRAIGHT_JOIN (
		SELECT
			b.address as address,
			b.sensor_number AS sensorNumber
		FROM
			user_project c
		JOIN interface_list b ON c.project_list_id = b.project_list_id
		JOIN building a ON b.b_id = a.b_id
		WHERE
			1 = 1
		AND c.user_id = 27
		AND a.building_data =9
	) t ON u.sensorNumber = t.sensorNumber ORDER BY u.syncTime DESC