Executed SQL

EXPLAIN SELECT `RecordedVideo`.id AS `RecordedVideo_id`, `RecordedVideo`.`owningUser` AS `RecordedVideo_owningUser`, `RecordedVideo`.views AS `RecordedVideo_views`, `RecordedVideo`.length AS `RecordedVideo_length`, `RecordedVideo`.`thumbnailLocation` AS `RecordedVideo_thumbnailLocation`, `RecordedVideo`.`channelName` AS `RecordedVideo_channelName`, `RecordedVideo`.topic AS `RecordedVideo_topic`, `RecordedVideo`.`videoDate` AS `RecordedVideo_videoDate`, user.`pictureLocation` AS `user_pictureLocation`, `Channel`.protected AS `Channel_protected`, `Channel`.`channelName` AS `ChanName` FROM `RecordedVideo` INNER JOIN `Channel` ON `RecordedVideo`.`channelID` = `Channel`.id INNER JOIN user ON `RecordedVideo`.`owningUser` = user.id WHERE `RecordedVideo`.pending = false AND `RecordedVideo`.published = true ORDER BY `RecordedVideo`.views DESC LIMIT %(param_1)s

Original query duration

1.1461 ms

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