Executed SQL

EXPLAIN SELECT `Clips`.id AS `Clips_id`, `Clips`.`thumbnailLocation` AS `Clips_thumbnailLocation`, `Channel`.`owningUser` AS `Channel_owningUser`, `Clips`.views AS `Clips_views`, `Clips`.length AS `Clips_length`, `Clips`.`clipName` AS `Clips_clipName`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelName` AS `Channel_channelName`, `RecordedVideo`.topic AS `RecordedVideo_topic`, `RecordedVideo`.`videoDate` AS `RecordedVideo_videoDate`, user.`pictureLocation` AS `user_pictureLocation`, `Clips`.`parentVideo` AS `Clips_parentVideo` FROM `Clips` INNER JOIN `RecordedVideo` ON `Clips`.`parentVideo` = `RecordedVideo`.id INNER JOIN `Channel` ON `Channel`.id = `RecordedVideo`.`channelID` INNER JOIN user ON user.id = `Channel`.`owningUser` WHERE `Clips`.published = true ORDER BY `Clips`.views DESC LIMIT %(param_1)s

Original query duration

1.0543 ms

ID	SELECT_TYPE	TABLE	TYPE	POSSIBLE_KEYS	KEY	KEY_LEN	REF	ROWS	EXTRA
1	SIMPLE	Clips	ALL	parentVideo	None	None	None	1	Using where; Using filesort
1	SIMPLE	RecordedVideo	eq_ref	PRIMARY,channelID	PRIMARY	4	bufrstreaming.Clips.parentVideo	1	Using where
1	SIMPLE	Channel	eq_ref	PRIMARY,owningUser	PRIMARY	4	bufrstreaming.RecordedVideo.channelID	1	Using where
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	bufrstreaming.Channel.owningUser	1